# For advice on how to change settings please see # http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html [mysqld] #####1个#号的需要根据情况解开,2个##不建议解开,3个###非特殊情况不要解开 ###忘记root密码### ###skip-grant-tables # # Remove leading # and set to the amount of RAM for the most important data # cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%. # innodb_buffer_pool_size = 128M # # Remove leading # to turn on a very important data integrity option: logging # changes to the binary log between backups. # log_bin # # Remove leading # to set options mainly useful for reporting servers. # The server defaults are faster for transactions and fast SELECTs. # Adjust sizes as needed, experiment to find the optimal values. # join_buffer_size = 128M # sort_buffer_size = 2M # read_rnd_buffer_size = 2M datadir=/var/lib/mysql ##mysql8 是 /var/run/mysqld/mysqld.sock,注释掉,使用默认配置 #socket=/var/lib/mysql/mysql.sock sort_buffer_size=6M join_buffer_size = 4M read_buffer_size = 6M read_rnd_buffer_size = 6M # Disabling symbolic-links is recommended to prevent assorted security risks symbolic-links=0 log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid skip_name_resolve table_open_cache = 2048 binlog_cache_size = 1M max_heap_table_size = 256M tmp_table_size = 256M query_cache_size=256M query_cache_type=1 ### master 主库 ### #server-id=1 ### 开机不启动同步,一般不需要解开 #### ###skip_slave_start=1 ##使用GTID实现复制## #gtid_mode = on #enforce_gtid_consistency = 1 #slave_parallel_type=LOGICAL_CLOCK #slave_parallel_workers=16 #master_info_repository=TABLE #relay_log_info_repository=TABLE #relay_log_recovery=ON #log_bin = mysql-bin #log_bin_index = mysql-bin.index #binlog_format=ROW #expire_logs_days=30 #sync_master_info=1 #log_slave_updates=ON ###slave 从库 ### ### 开机不启动同步,一般不需要解开 #### ###skip_slave_start=1 #server-id=2 #super_read_only=on #read_only=on ##使用GTID实现复制## #gtid_mode = on #enforce_gtid_consistency = 1 #slave_parallel_type=LOGICAL_CLOCK #slave_parallel_workers=16 #master_info_repository=TABLE #relay_log_info_repository=TABLE #relay_log_recovery=ON #log_bin = mysql-bin #log_bin_index = mysql-bin.index #relay_log = relay-bin #relay_log-index = relay-bin.index #binlog_format=ROW #expire_logs_days=30 #sync_master_info=1 #log_slave_updates=ON max_connections = 5000 default_password_lifetime=0 character_set_server=utf8mb4 loose-default_character_set = utf8mb4 lower_case_table_names=1 ### 为了处理不规范的 order by,一般不需要解开 ### ##sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION key_buffer_size=512M innodb_log_buffer_size=20M innodb_log_file_size = 512M innodb_flush_log_at_trx_commit=2 innodb_buffer_pool_size=4G innodb_log_files_in_group = 2 innodb_max_dirty_pages_pct =80 innodb_lock_wait_timeout = 60 bulk_insert_buffer_size=64M max_allowed_packet = 128M innodb_write_io_threads = 8 innodb_read_io_threads = 8 thread_cache_size = 64