- automatic_sp_privileges = ON
- auto_increment_increment = 1
- auto_increment_offset = 1
- avoid_temporal_upgrade = OFF
- back_log = 3000
- binlog_cache_size = 128KB
- 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_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
- event_scheduler = OFF
- explicit_defaults_for_timestamp = OFF
- 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 = 644
- innodb_adaptive_flushing = ON
- innodb_adaptive_flushing_lwm = 10
- innodb_adaptive_hash_index = ON
- innodb_adaptive_max_sleep_delay = 150000
- innodb_autoextend_increment = 64
- innodb_autoinc_lock_mode = 2
- innodb_buffer_pool_dump_at_shutdown = ON
- innodb_buffer_pool_dump_pct = 25
- innodb_buffer_pool_instances = 1
- innodb_buffer_pool_load_at_startup = ON
- innodb_change_buffering = all
- innodb_change_buffer_max_size = 25
- innodb_checksum_algorithm = crc32
- 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_data_file_purge = ON
- innodb_data_file_purge_interval = 100
- innodb_data_file_purge_max_size = 128
- innodb_deadlock_detect = ON
- innodb_disable_sort_file_cache = ON
- innodb_flush_method = O_DIRECT
- innodb_flush_neighbors = 1
- innodb_flush_sync = ON
- 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_lock_wait_timeout = 50
- innodb_log_checksums = ON
- 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_max_undo_log_size = 1073741824
- innodb_monitor_disable =
- innodb_monitor_enable =
- innodb_old_blocks_pct = 37
- innodb_old_blocks_time = 1000
- innodb_online_alter_log_max_size = 134217728
- innodb_open_files
来源: http://www.bubuko.com/infodetail-3328432.html