MySQL my.cnf关键参数配置

my.cnf关键性参数
[client]
port = 3306
socket = /data/mysql/mysql.sock
[mysql]
prompt = "\u@db \R:\m:\s [\d]> "
no-auto-rehash
[mysqld]
skip_name_resolve = 1
open_files_limit = 65535
max_connections = 200
max_allowed_packet = 512M
slow_query_log_file = /data/mysql/mysqlslow.log
log-error = /data/mysql/mysqlerr.log
long_query_time = 300
server-id = 3306+ip
#binlog conf
log-bin = /data/mysql/mysql-binlog
sync_binlog = 1
binlog_cache_size = 4M
max_binlog_cache_size = 1G
max_binlog_size = 1G
expire_logs_days = 7
binlog_format = row
#gtid conf
gtid_mode = on
enfore_gtid_consistency =1

transaction_isolation = READ-COMMITTED
#mem conf
innodb_buffer_pool_size = 1024M
innodb_buffer_pool_instances = 8
innodb_buffer_pool_load_at_startup = 1
innodb_buffer_pool_dump_at_shutdown = 1
innodb_data_file_path = ibdata1:1G:autoextend
innodb_flush_log_at_trx_commit = 1
innodb_log_buffer_size = 32M
innodb_log_file_size = 2G
innodb_log_files_in_group = 2
innodb_max_undo_log_size = 4G
innodb_io_capacity = 4000
innodb_io_capacity_max = 8000
innodb_flush_neighbors = 0
innodb_write_io_threads = 8
innodb_read_io_threads = 8
innodb_purge_threads = 4

innodb_page_cleaners = 4
innodb_open_files = 65535
innodb_max_dirty_pages_pct = 50
innodb_flush_method = O_DIRECT
innodb_lru_scan_depth = 4000
innodb_cheacksum_algorithm = crc32
innodb_lock_wait_timeout = 10
innodb_rollback_on_timeout = 1
innodb_print_all_deadlocks = 1
innodb_file_per_table = 1
innodb_online_alter_log_max_size = 4G
internal_tmp_disk_storage_engine = InnoDB
innodb_stats_on_metadata = 0
innodb_status_file = 1
innodb_status_output = 0
innodb_status_output_locks = 0
performance_schema = 1
performance_schema_instrument = '%=on'
[mysqldump]
quick
max_allowed_packet = 512M

从库my.cnf关键参数配置
server-id = 3306+ip
#MTS conf
slave-parallel-type=LOGICAL_CLOCK
slave-parallel-workers=5
master_info_repository=TABLE
relay_log_info_repository=TABLE
relay_log_recovery = 1

从库配置：
#relay log conf
relay_log_recovery =1
relay_log=/u01/mysql/logs/relay-bin
max_relay_log_size = 0
relay_log_purge = 1
sync_relay_log = 0
sync_relay_log_info = 0