mysql 5.6 my.cnf文件

#
[mysqld]


# GENERAL #
character_set_server           = utf8
collation_server               = utf8_general_ci
user                           = mysql
default_storage_engine         = InnoDB
port                           = 3307
socket                         = /u01/mysql/3307/proc/mysql.sock
pid_file                       = /u01/mysql/3307/proc/mysql.pid


# MyISAM #
key_buffer_size                = 128M
myisam_sort_buffer_size        = 8M
read_rnd_buffer_size           = 262144


# SAFETY #
back_log                       = 50
bind-address                   = 0.0.0.0
innodb                         = FORCE
innodb_strict_mode             = 1
max_allowed_packet             = 32M
max_connect_errors             = 1000000
interactive_timeout            = 900
wait_timeout                   = 900
skip_grant_tables              = 0
skip_name_resolve              = 1
host_cache_size                = 0
sql_mode                       = NO_AUTO_CREATE_USER
sysdate_is_now                 = 1
transaction_isolation          = REPEATABLE-READ
explicit_defaults_for_timestamp = 1


# DATA STORAGE #
basedir                        = /usr/local/mysql
datadir                        = /u01/mysql/3307/data
tmpdir                         = /u01/mysql/3307/tmp


# BINARY LOGGING #
binlog_cache_size              = 1M
binlog_format                  = ROW
expire_logs_days               = 7
max_binlog_size                = 512M
max_binlog_cache_size          = 4G
log_bin                        = /u01/mysql/3307/log/binlog/mysql-bin
log_bin_index                  = /u01/mysql/3307/log/binlog/mysql-bin.index
sync_binlog                    = 0
innodb_support_xa              = 1
master-info-repository         = TABLE


# REPLICATION #
log_slave_updates              = 1
read_only                      = 0
relay_log                      = /u01/mysql/3307/log/relay/relay-bin
relay_log_index                = /u01/mysql/3307/log/relay/relay-bin.index
server_id                      = 1
slave_skip_errors              = OFF
skip_slave_start
slave_net_timeout              = 60
relay-log-info-repository      = TABLE


# GTID setting
gtid-mode                      = on
enforce-gtid-consistency       = true
sync-master-info               = 1
slave-parallel-workers         = 4
binlog-checksum                = CRC32
master-verify-checksum         = 1
slave-sql-verify-checksum      = 1
binlog-rows-query-log_events   = 1


# CACHES AND LIMITS #
max_connections                = 2000
max_heap_table_size            = 128M
tmp_table_size                 = 128M
open_files_limit               = 65535
query_cache_limit              = 1M
query_cache_min_res_unit       = 4096
query_cache_size               = 0
query_cache_type               = 0
join_buffer_size               = 1M
read_buffer_size               = 1M
sort_buffer_size               = 1M
table_definition_cache         = 4096
table_open_cache               = 4000
thread_cache_size              = 1000


# INNODB #
innodb_autoextend_increment    = 8
innodb_buffer_pool_instances   = 8
innodb_buffer_pool_size        = 8G
innodb_buffer_pool_load_at_startup  = ON
innodb_buffer_pool_dump_at_shutdown = ON
innodb_fast_shutdown           = 1
innodb_file_format             = Barracuda
innodb_file_format_max         = Barracuda
innodb_file_per_table          = 1
innodb_force_recovery          = 0
innodb_flush_log_at_trx_commit = 2
innodb_flush_method            = O_DIRECT
innodb_lock_wait_timeout       = 50
innodb_log_buffer_size         = 8M
innodb_log_file_size           = 512M
innodb_data_home_dir           = /u01/mysql/3307/innodb/data
innodb_data_file_path          = ibdata1:1024M:autoextend
innodb_log_group_home_dir      = /u01/mysql/3307/innodb/log
innodb_log_files_in_group      = 2
innodb_open_files              = 10000
innodb_purge_threads           = 4
innodb_read_io_threads         = 8
innodb_write_io_threads        = 8
innodb_sync_spin_loops         = 30
innodb_thread_concurrency      = 24


# LOGGING #
general_log                    = 0
general_log_file               = /u01/mysql/3307/log/general/mysql-general.log
log_error                      = /u01/mysql/3307/log/error/mysql-error.log
log_queries_not_using_indexes  = 0
long_query_time                = 1
slow_query_log                 = 1
slow_query_log_file            = /u01/mysql/3307/log/slow/mysql-slow.log