云数据库SQL Server实例不支持修改参数,MySQL实例支持修改参数,具体参数列表见下文MySQL参数列表。 修改参数1.登录控制台->云数据库->管理云数据库实例。
2. 找到需要设置参数的目标实例,单击管理 3. 在云数据库详情页面最右侧点击参数设置 4. 修改参数后,点击预览,预览修改的参数 5. 点击保存,保存参数修改 导入参数- 在参数设置页面,更多操作->导入参数
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 |