| 云數(shù)據(jù)庫(kù)SQL Server實(shí)例不支持修改參數(shù),MySQL實(shí)例支持修改參數(shù),具體參數(shù)列表見(jiàn)下文MySQL參數(shù)列表。 修改參數(shù)1.登錄控制臺(tái)->云數(shù)據(jù)庫(kù)->管理云數(shù)據(jù)庫(kù)實(shí)例。 2. 找到需要設(shè)置參數(shù)的目標(biāo)實(shí)例,單擊管理  3. 在云數(shù)據(jù)庫(kù)詳情頁(yè)面最右側(cè)點(diǎn)擊參數(shù)設(shè)置  4. 修改參數(shù)后,點(diǎn)擊預(yù)覽,預(yù)覽修改的參數(shù)  5. 點(diǎn)擊保存,保存參數(shù)修改 導(dǎo)入?yún)?shù)在參數(shù)設(shè)置頁(yè)面,更多操作->導(dǎo)入?yún)?shù)
  2. 在導(dǎo)入?yún)?shù)彈出窗口,單擊確定導(dǎo)入?yún)?shù) 多參數(shù)導(dǎo)入, 請(qǐng)以換行形式進(jìn)行導(dǎo)入?yún)?shù)值為字符時(shí)參數(shù)名與參數(shù)值之間不能有空格,如binlog_checksum=CRC32支持導(dǎo)入的參數(shù)見(jiàn)下文MySQL參數(shù)列表
 MySQL參數(shù)列表auto_increment_increment= 10auto_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
 |