67
mysql实例自定义参数设置

云数据库sql server实例不支持修改参数,mysql实例支持修改参数,具体参数列表见下文mysql参数列表。

修改参数

1.登录控制台->云数据库->管理云数据库实例。

2. 找到需要设置参数的目标实例,单击管理

3. 在云数据库详情页面最右侧点击参数设置

4. 修改参数后,点击预览,预览修改的参数

5. 点击保存,保存参数修改

导入参数

  1. 在参数设置页面,更多操作->导入参数

2. 在导入参数弹出窗口,单击确定导入参数

  • 多参数导入, 请以换行形式进行
  • 导入参数值为字符时参数名与参数值之间不能有空格,如binlog_checksum=crc32
  • 支持导入的参数见下文mysql参数列表

mysql参数列表

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