177
mysql实例自定义参数设置

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

修改参数

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



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


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


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


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

导入参数

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


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

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


mysql参数列表

auto_increment_increment= 10auto_increment_offset= 5back_log= 3000binlog_cache_size= 2097152binlog_checksum=crc32binlog_order_commits=onbinlog_rows_query_log_events=offbinlog_row_image=fullbinlog_stmt_cache_size=32768block_encryption_mode="aes-128-ecb"bulk_insert_buffer_size=4194304character_set_client=utf8character_set_filesystem=binarycharacter_set_server=utf8concurrent_insert=1connect_timeout=10default_storage_engine=innodbdefault_time_zone=systemdefault_week_format=0delayed_insert_limit=100delayed_insert_timeout=300delayed_queue_size=1000delay_key_write=ondisconnect_on_expired_password=ondiv_precision_increment=4end_markers_in_json=offeq_range_index_dive_limit=10explicit_defaults_for_timestamp=falseflush_time=0ft_max_word_len=84ft_min_word_len=4ft_query_expansion_limit=20group_concat_max_len=1024host_cache_size=643innodb_adaptive_flushing=oninnodb_adaptive_flushing_lwm=10innodb_adaptive_hash_index=oninnodb_adaptive_max_sleep_delay=150000innodb_additional_mem_pool_size=2097152innodb_autoextend_increment=64innodb_autoinc_lock_mode=2innodb_buffer_pool_dump_at_shutdown=offinnodb_buffer_pool_instances=8innodb_buffer_pool_load_at_startup=offinnodb_change_buffering=allinnodb_change_buffer_max_size=25innodb_checksum_algorithm=innodbinnodb_cmp_per_index_enabled=offinnodb_commit_concurrency=0innodb_compression_failure_threshold_pct=5innodb_compression_level=6innodb_compression_pad_pct_max=50innodb_concurrency_tickets=5000innodb_disable_sort_file_cache=oninnodb_flush_method=o_directinnodb_flush_neighbors=1innodb_ft_cache_size=8000000innodb_ft_enable_diag_print=offinnodb_ft_enable_stopword=oninnodb_ft_max_token_size=84innodb_ft_min_token_size=3innodb_ft_num_word_optimize=2000innodb_ft_result_cache_limit=2000000000innodb_ft_sort_pll_degree=2innodb_ft_total_cache_size=640000000innodb_io_capacity=2000innodb_io_capacity_max=4000innodb_large_prefix=offinnodb_lock_wait_timeout=50innodb_log_compressed_pages=offinnodb_lru_scan_depth=1024innodb_max_dirty_pages_pct=75innodb_max_dirty_pages_pct_lwm=0innodb_max_purge_lag=0innodb_max_purge_lag_delay=0innodb_monitor_disable=\sinnodb_monitor_enable=\sinnodb_old_blocks_pct=37innodb_old_blocks_time=1000innodb_online_alter_log_max_size=134217728innodb_open_files=3000innodb_optimize_fulltext_only=offinnodb_print_all_deadlocks=offinnodb_purge_batch_size=300innodb_purge_threads=1innodb_random_read_ahead=offinnodb_read_ahead_threshold=56innodb_read_io_threads=4innodb_rollback_on_timeout=offinnodb_rollback_segments=128innodb_sort_buffer_size=1048576innodb_spin_wait_delay=6innodb_stats_auto_recalc=oninnodb_stats_method=nulls_equalinnodb_stats_on_metadata=offinnodb_stats_persistent=oninnodb_stats_persistent_sample_pages=20innodb_stats_sample_pages=8innodb_stats_transient_sample_pages=8innodb_status_output=offinnodb_status_output_locks=offinnodb_strict_mode=offinnodb_support_xa=oninnodb_sync_array_size=1innodb_sync_spin_loops=100innodb_table_locks=oninnodb_thread_concurrency=0innodb_thread_sleep_delay=10000innodb_write_io_threads=4interactive_timeout=7200join_buffer_size=262144key_cache_age_threshold=300key_cache_block_size=1024key_cache_division_limit=100lc_time_names=en_uslock_wait_timeout=31536000log_queries_not_using_indexes=offlog_throttle_queries_not_using_indexes=0long_query_time=1loose_gap_lock_raise_error=offloose_gap_lock_write_log=offloose_max_statement_time=0loose_optimizer_trace=enabled=off,one_line=offloose_optimizer_trace_features=greedy_search=on,range_optimizer=on,dynamic_range=on,repeated_subselect=onloose_rds_indexstat=offloose_rds_max_tmp_disk_space=10737418240loose_rds_set_connection_id_enabled=onloose_rds_tablestat=offloose_rds_threads_running_high_watermark=50000loose_thread_handling="one-thread-per-connection"loose_thread_pool_oversubscribe=10loose_thread_pool_size=64loose_thread_pool_stall_limit=30loose_tokudb_auto_analyze=30loose_tokudb_buffer_pool_ratio=0loose_validate_password_length=8low_priority_updates=0master_verify_checksum=offmax_allowed_packet=1073741824max_binlog_stmt_cache_size=18446744073709547520max_connect_errors=100max_error_count=64max_heap_table_size=16777216max_join_size=18446744073709551615max_length_for_sort_data=1024max_prepared_stmt_count=16382max_seeks_for_key=18446744073709500000max_sort_length=1024max_sp_recursion_depth=0max_write_lock_count=102400metadata_locks_cache_size=1024min_examined_row_limit=0myisam_sort_buffer_size=262144net_buffer_length=16384net_read_timeout=30net_retry_count=10net_write_timeout=60old_passwords=0open_files_limit=65535optimizer_prune_level=1optimizer_search_depth=62optimizer_trace_limit=1optimizer_trace_max_mem_size=16384optimizer_trace_offset=-1performance_schema=offpreload_buffer_size=32768query_alloc_block_size=8192query_cache_limit=1048576query_cache_min_res_unit=4096query_cache_size=3145728query_cache_type=0query_cache_wlock_invalidate=offquery_prealloc_size=8192range_alloc_block_size=4096rds_reset_all_filter=0slave_net_timeout=60slow_launch_time=2slow_query_log=onsort_buffer_size=262144sql_mode=\sstored_program_cache=256table_definition_cache=512table_open_cache=2000table_open_cache_instances=1thread_cache_size=100thread_stack=262144tls_version=tlsv1,tlsv1.1,tlsv1.2tmp_table_size=2097152transaction_alloc_block_size=8192transaction_isolation=read-committedtransaction_prealloc_size=4096updatable_views_with_limit=yeswait_timeout=86400