|
Alibaba Cloud SQL Server instance does not support parameter modification, while MySQL instance supports parameter modification. See the following for the specific parameter list MySQL parameter list. modify parameters 1. Log in to the console ->ApsaraDB ->Manage ApsaraDB instances. 2. Find the target instance that needs to set parameters, and click Manage 3. Click parameter settings on the right side of the cloud database details page 4. After modifying parameters, click Preview to preview the modified parameters 5. Click Save to save parameter modification Import Parameters- On the parameter setting page, more operations ->import parameters
2. In the import parameter pop-up window, click OK to import the parameter - Multi parameter import, please use newline format
- When the import parameter value is a character, there must be no space between the parameter name and the parameter value, such as
binlog_checksum=CRC32 - The parameters that support import are shown in the following MySQL parameter list
MySQL parameter list auto_increment_increment= 10
auto_increment_offset= 5
back_log= 3000
binlog_cache_size= 2097152
binlog_checksum=CRC32
binlog_order_commits=ON
binlog_rows_query_log_events=OFF
binlog_row_image=full
binlog_stmt_cache_size=32768
block_encryption_mode="aes-128-ecb"
bulk_insert_buffer_size=4194304
character_set_client=utf8
character_set_filesystem=binary
character_set_server=utf8
concurrent_insert=1
connect_timeout=10
default_storage_engine=InnoDB
default_time_zone=SYSTEM
default_week_format=0
delayed_insert_limit=100
delayed_insert_timeout=300
delayed_queue_size=1000
delay_key_write=ON
disconnect_on_expired_password=ON
div_precision_increment=4
end_markers_in_json=OFF
eq_range_index_dive_limit=10
explicit_defaults_for_timestamp=false
flush_time=0
ft_max_word_len=84
ft_min_word_len=4
ft_query_expansion_limit=20
group_concat_max_len=1024
host_cache_size=643
innodb_adaptive_flushing=ON
innodb_adaptive_flushing_lwm=10
innodb_adaptive_hash_index=ON
innodb_adaptive_max_sleep_delay=150000
innodb_additional_mem_pool_size=2097152
innodb_autoextend_increment=64
innodb_autoinc_lock_mode=2
innodb_buffer_pool_dump_at_shutdown=OFF
innodb_buffer_pool_instances=8
innodb_buffer_pool_load_at_startup=OFF
innodb_change_buffering=all
innodb_change_buffer_max_size=25
innodb_checksum_algorithm=innodb
innodb_cmp_per_index_enabled=OFF
innodb_commit_concurrency=0
innodb_compression_failure_threshold_pct=5
innodb_compression_level=6
innodb_compression_pad_pct_max=50
innodb_concurrency_tickets=5000
innodb_disable_sort_file_cache=ON
innodb_flush_method=O_DIRECT
innodb_flush_neighbors=1
innodb_ft_cache_size=8000000
innodb_ft_enable_diag_print=OFF
innodb_ft_enable_stopword=ON
innodb_ft_max_token_size=84
innodb_ft_min_token_size=3
innodb_ft_num_word_optimize=2000
innodb_ft_result_cache_limit=2000000000
innodb_ft_sort_pll_degree=2
innodb_ft_total_cache_size=640000000
innodb_io_capacity=2000
innodb_io_capacity_max=4000
innodb_large_prefix=OFF
innodb_lock_wait_timeout=50
innodb_log_compressed_pages=OFF
innodb_lru_scan_depth=1024
innodb_max_dirty_pages_pct=75
innodb_max_dirty_pages_pct_lwm=0
innodb_max_purge_lag=0
innodb_max_purge_lag_delay=0
innodb_monitor_disable=\s
innodb_monitor_enable=\s
innodb_old_blocks_pct=37
innodb_old_blocks_time=1000
innodb_online_alter_log_max_size=134217728
innodb_open_files=3000
innodb_optimize_fulltext_only=OFF
innodb_print_all_deadlocks=OFF
innodb_purge_batch_size=300
innodb_purge_threads=1
innodb_random_read_ahead=OFF
innodb_read_ahead_threshold=56
innodb_read_io_threads=4
innodb_rollback_on_timeout=OFF
innodb_rollback_segments=128
innodb_sort_buffer_size=1048576
innodb_spin_wait_delay=6
innodb_stats_auto_recalc=ON
innodb_stats_method=nulls_equal
innodb_stats_on_metadata=OFF
innodb_stats_persistent=ON
innodb_stats_persistent_sample_pages=20
innodb_stats_sample_pages=8
innodb_stats_transient_sample_pages=8
innodb_status_output=OFF
innodb_status_output_locks=OFF
innodb_strict_mode=OFF
innodb_support_xa=ON
innodb_sync_array_size=1
innodb_sync_spin_loops=100
innodb_table_locks=ON
innodb_thread_concurrency=0
innodb_thread_sleep_delay=10000
innodb_write_io_threads=4
interactive_timeout=7200
join_buffer_size=262144
key_cache_age_threshold=300
key_cache_block_size=1024
key_cache_division_limit=100
lc_time_names=en_US
lock_wait_timeout=31536000
log_queries_not_using_indexes=OFF
log_throttle_queries_not_using_indexes=0
long_query_time=1
loose_gap_lock_raise_error=OFF
loose_gap_lock_write_log=OFF
loose_max_statement_time=0
loose_optimizer_trace=enabled=off,one_line=off
loose_optimizer_trace_features=greedy_search=on,range_optimizer=on,dynamic_range=on,repeated_subselect=on
loose_rds_indexstat=OFF
loose_rds_max_tmp_disk_space=10737418240
loose_rds_set_connection_id_enabled=ON
loose_rds_tablestat=OFF
loose_rds_threads_running_high_watermark=50000
loose_thread_handling="one-thread-per-connection"
loose_thread_pool_oversubscribe=10
loose_thread_pool_size=64
loose_thread_pool_stall_limit=30
loose_tokudb_auto_analyze=30
loose_tokudb_buffer_pool_ratio=0
loose_validate_password_length=8
low_priority_updates=0
master_verify_checksum=OFF
max_allowed_packet=1073741824
max_binlog_stmt_cache_size=18446744073709547520
max_connect_errors=100
max_error_count=64
max_heap_table_size=16777216
max_join_size=18446744073709551615
max_length_for_sort_data=1024
max_prepared_stmt_count=16382
max_seeks_for_key=18446744073709500000
max_sort_length=1024
max_sp_recursion_depth=0
max_write_lock_count=102400
metadata_locks_cache_size=1024
min_examined_row_limit=0
myisam_sort_buffer_size=262144
net_buffer_length=16384
net_read_timeout=30
net_retry_count=10
net_write_timeout=60
old_passwords=0
open_files_limit=65535
optimizer_prune_level=1
optimizer_search_depth=62
optimizer_trace_limit=1
optimizer_trace_max_mem_size=16384
optimizer_trace_offset=-1
performance_schema=OFF
preload_buffer_size=32768
query_alloc_block_size=8192
query_cache_limit=1048576
query_cache_min_res_unit=4096
query_cache_size=3145728
query_cache_type=0
query_cache_wlock_invalidate=OFF
query_prealloc_size=8192
range_alloc_block_size=4096
rds_reset_all_filter=0
slave_net_timeout=60
slow_launch_time=2
slow_query_log=ON
sort_buffer_size=262144
sql_mode=\s
stored_program_cache=256
table_definition_cache=512
table_open_cache=2000
table_open_cache_instances=1
thread_cache_size=100
thread_stack=262144
tls_version=TLSv1,TLSv1.1,TLSv1.2
tmp_table_size=2097152
transaction_alloc_block_size=8192
transaction_isolation=READ-COMMITTED
transaction_prealloc_size=4096
updatable_views_with_limit=YES
wait_timeout=86400
|
