113
云计算
云服务器
产品简介
计费规则
购买指导
控制台使用指南
常见问题
负载均衡
产品简介
产品价格
购买指南
快速入门
用户指南
实践操作
常见问题
云数据库
产品简介
计费规则
购买指导
快速入门
连接实例
控制台使用指南
对象存储
产品简介
控制台使用指南
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

这条帮助是否解决了您的问题? 已解决 未解决

提交成功!非常感谢您的反馈,我们会继续努力做到更好! 很抱歉未能解决您的疑问。我们已收到您的反馈意见,同时会及时作出反馈处理!