mysql5.6环境配置_MySQL 5.6 生产环境标准配置

mysql版本信息:

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 5077992

Server version: 5.6.16-log Source distribution

Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

auto_increment_increment = 1 auto_increment_offset = 1 back_log = 3000 binlog_cache_size = 2097152 binlog_checksum = CRC32 binlog_row_image = full binlog_stmt_cache_size = 32768 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 div_precision_increment = 4 ft_min_word_len = 4 ft_query_expansion_limit = 20 group_concat_max_len = 1024 innodb_adaptive_hash_index = ON innodb_autoinc_lock_mode = 1 innodb_concurrency_tickets = 5000 innodb_ft_max_token_size = 84 innodb_ft_min_token_size = 3 innodb_large_prefix = OFF innodb_lock_wait_timeout = 50 innodb_max_dirty_pages_pct = 75 innodb_old_blocks_pct = 37 innodb_old_blocks_time = 1000 innodb_open_files = 3000 innodb_print_all_deadlocks = OFF innodb_purge_batch_size = 300 innodb_purge_threads = 1 innodb_read_ahead_threshold = 56 innodb_read_io_threads = 4 innodb_rollback_on_timeout = OFF innodb_stats_method = nulls_equal innodb_stats_on_metadata = OFF innodb_stats_sample_pages = 8 innodb_strict_mode = OFF innodb_table_locks = ON innodb_thread_concurrency = 0 innodb_thread_sleep_delay = 10000 innodb_write_io_threads = 4 interactive_timeout = 7200 key_cache_age_threshold = 300 key_cache_block_size = 1024 key_cache_division_limit = 100 log_queries_not_using_indexes = OFF long_query_time = 1 loose_max_statement_time = 0 loose_rds_max_tmp_disk_space = 10737418240 loose_rds_threads_running_high_watermark = 50000 loose_tokudb_buffer_pool_ratio = 0 low_priority_updates = 0 max_allowed_packet = 1024M max_connect_errors = 100 max_length_for_sort_data = 1024 myisam_sort_buffer_size = 262144 net_read_timeout = 30 net_retry_count = 10 net_write_timeout = 60 open_files_limit = 65535 performance_schema = OFF query_alloc_block_size = 8192 query_cache_limit = 1048576 query_cache_size = 0 query_cache_type = 0 query_prealloc_size = 8192 slow_launch_time = 2 sql_mode = table_definition_cache = 512 table_open_cache = 100 tmp_table_size = 2097152 transaction_isolation = READ-COMMITTED wait_timeout = 86400 eq_range_index_dive_limit = 10 innodb_additional_mem_pool_size = 2097152 innodb_online_alter_log_max_size = 134217728 loose_innodb_rds_io_latency_warning = 0 loose_rds_audit_log_version = MYSQL_V0 loose_rds_audit_max_sql_size = 2048 loose_rds_binlog_latency_warning = 0 loose_rds_binlog_savepoint_release = OFF loose_rds_enable_exec_plan_cache = OFF loose_rds_exec_plan_hash_partitions = 8 loose_rds_max_exec_plan_caches = 1048576 loose_rds_show_slave_status_timeout = 31536000 loose_rds_tablestat = OFF loose_slave_pr_mode = TABLE loose_tokudb_bypass_rightmost_insert = OFF max_prepared_stmt_count = 16382 max_write_lock_count = 102400 rds_reset_all_filter = 0 rds_sql_select_filter = ''