MySQL 5.6 & 5.7 optimal configuration file template (my. ini), mysql5.6

MySQL 5.6 & 5.7 optimal configuration file template (my. ini), mysql5.6

Inside has compiled a new configuration file template based on MySQL 5.6 and 5.7, which basically covers 90% of the optimization options. You only need to make slight modifications based on your server configuration, for example, InnoDB buffer pool size and IO capacity (innodb_buffer_pool_size, innodb_io_capacity ). Note that this configuration file does not need to be modified. You can directly run it in MySQL 5.6 and 5.7. Here we use a small trick. For details, see the configuration file. If there is a problem with the configuration parameters, you can also give feedback to Inside Jun in a timely manner. Let's grow together.

The reason for triggering this is that most of the MySQL configuration files on the network are very old, most of them are based on MySQL 5.1, this leads to the fact that most MySQL instances are not running in the optimal environment, leading to incorrect use or catastrophic accidents, such as data loss and master-slave data inconsistency. These problems have been solved in versions 5.6 and later.

Finally, we discard your so-called, outdated, and wrong MySQL configuration file and target a brand new MySQL era featuring high performance, high reliability, and high scalability, all you need to do is download this configuration file and use it in your production environment. The configuration is as follows:

[client]user=davidpassword=88888888 [mysqld]########basic settings########server-id = 11port = 3306user = mysqlbind_address = 10.166.224.32autocommit = 0character_set_server=utf8mb4skip_name_resolve = 1max_connections = 800max_connect_errors = 1000datadir = /data/mysql_datatransaction_isolation = READ-COMMITTEDexplicit_defaults_for_timestamp = 1join_buffer_size = 134217728tmp_table_size = 67108864tmpdir = /tmpmax_allowed_packet = 16777216sql_mode = "STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER"interactive_timeout = 1800wait_timeout = 1800read_buffer_size = 16777216read_rnd_buffer_size = 33554432sort_buffer_size = 33554432########log settings########log_error = error.logslow_query_log = 1slow_query_log_file = slow.loglog_queries_not_using_indexes = 1log_slow_admin_statements = 1log_slow_slave_statements = 1log_throttle_queries_not_using_indexes = 10expire_logs_days = 90long_query_time = 2min_examined_row_limit = 100########replication settings########master_info_repository = TABLErelay_log_info_repository = TABLElog_bin = bin.logsync_binlog = 1gtid_mode = onenforce_gtid_consistency = 1log_slave_updatesbinlog_format = rowrelay_log = relay.logrelay_log_recovery = 1binlog_gtid_simple_recovery = 1slave_skip_errors = ddl_exist_errors########innodb settings########innodb_page_size = 8192innodb_buffer_pool_size = 6Ginnodb_buffer_pool_instances = 8innodb_buffer_pool_load_at_startup = 1innodb_buffer_pool_dump_at_shutdown = 1innodb_lru_scan_depth = 2000innodb_lock_wait_timeout = 5innodb_io_capacity = 4000innodb_io_capacity_max = 8000innodb_flush_method = O_DIRECTinnodb_file_format = Barracudainnodb_file_format_max = Barracudainnodb_log_group_home_dir = /redolog/innodb_undo_directory = /undolog/innodb_undo_logs = 128innodb_undo_tablespaces = 3innodb_flush_neighbors = 1innodb_log_file_size = 4Ginnodb_log_buffer_size = 16777216innodb_purge_threads = 4innodb_large_prefix = 1innodb_thread_concurrency = 64innodb_print_all_deadlocks = 1innodb_strict_mode = 1innodb_sort_buffer_size = 67108864########semi sync replication settings########plugin_dir=/usr/local/mysql/lib/pluginplugin_load = "rpl_semi_sync_master=semisync_master.so;rpl_semi_sync_slave=semisync_slave.so"loose_rpl_semi_sync_master_enabled = 1loose_rpl_semi_sync_slave_enabled = 1loose_rpl_semi_sync_master_timeout = 5000 [mysqld-5.7]innodb_buffer_pool_dump_pct = 40innodb_page_cleaners = 4innodb_undo_log_truncate = 1innodb_max_undo_log_size = 2Ginnodb_purge_rseg_truncate_frequency = 128binlog_gtid_simple_recovery=1log_timestamps=systemtransaction_write_set_extraction=MURMUR32show_compatibility_56=on

Finally, to download the configuration file, click: http://pan.baidu.com/s/1jHMPu9C