[mysqld]
datadir      = /path/to/datadir
tmpdir       = ../tmp
socket       = mysql.sock
bind_address = 0.0.0.0
back_log  = 2000
server_id = 2
read_only = 1
log_error_verbosity = 2
event_scheduler = OFF

log-bin          = ../log/binlog
binlog_format    = ROW
binlog_row_image = full
sync_binlog      = 0
expire_logs_days = 1
log_slave_updates
max_binlog_size  = 100M

relay_log = ../log/relaylog
max_relay_log_size = 100M

slave_compressed_protocol = OFF

general_log         = OFF
general_log_file    = ../log/query.log
slow_query_log      = 1
slow_query_log_file = ../log/slowlog
long_query_time     = 3
log_queries_not_using_indexes = 0
min_examined_row_limit = 10000

log_syslog = 0

default_password_lifetime = 0

show_compatibility_56 = 1

character_set_server = utf8mb4
concurrent_insert = AUTO
group_concat_max_len = 1048576
init_connect = 'SET NAMES utf8mb4'
key_buffer_size = 768M
max_allowed_packet = 16M
slave_max_allowed_packet = 128M
max_connections = 3000
max_connect_errors = 15000
max_heap_table_size = 64M
myisam_repair_threads = 1
myisam_sort_buffer_size = 64M
open_files_limit = 20000

report_host = server800
report_port = 3306

range_optimizer_max_mem_size = 16M

query_cache_size = 0
query_cache_type = 0

read_buffer_size = 128k
sort_buffer_size = 1M

sql_mode = NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

table_definition_cache = 3000
table_open_cache = 3000
thread_cache_size = 1500
tmp_table_size = 64M
transaction-isolation = READ-COMMITTED
wait_timeout = 300

myisam_recover_options = FORCE,BACKUP

master_info_repository    = TABLE
relay_log_info_repository = TABLE
relay_log_recovery        = 1
slave_net_timeout = 3600
sync_master_info = 10000
sync_relay_log_info = 10000

host_cache_size = 5000

gtid_mode = OFF
enforce_gtid_consistency = 0

slave_parallel_workers = 0

default_storage_engine = InnoDB
default_tmp_storage_engine = InnoDB

innodb_adaptive_flushing = 1
innodb_adaptive_hash_index = 1
innodb_buffer_pool_dump_at_shutdown = 1

innodb_buffer_pool_dump_pct = 25
innodb_buffer_pool_load_at_startup  = 1
innodb_buffer_pool_size = 10G

innodb_change_buffering = ALL
innodb_file_per_table

innodb_flush_neighbors = 1

innodb_doublewrite = 1

innodb_flush_log_at_trx_commit = 1
innodb_flush_method = O_DIRECT
innodb_io_capacity = 600
innodb_io_capacity_max = 1200	
innodb_lock_wait_timeout = 50
innodb_log_buffer_size = 256M
innodb_log_files_in_group = 2
innodb_log_file_size = 512M
innodb_max_dirty_pages_pct = 20
innodb_open_files = 3000
innodb_purge_threads = 1
innodb_purge_batch_size = 300
innodb_read_io_threads = 12
innodb_stats_on_metadata = 0
innodb_thread_concurrency = 999
innodb_write_io_threads = 12

innodb_autoinc_lock_mode=2
innodb_numa_interleave=ON

performance_schema = 1

[mysqld_safe]
log-error = /var/log/mysqld.log
pid_file = /var/run/mysqld/mysqld.pid
core-file-size = unlimited

[mysqldump]
quick
max_allowed_packet = 16M
default-character-set = utf8mb4
ignore-table=mysql.gtid_executed

[mysql]
no-auto-rehash
default_character_set = utf8mb4
prompt = \u@server800 [\d]>\_

[myisamchk]
key_buffer_size = 768M
sort_buffer_size = 256M
read_buffer_size = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout

[client]
socket = /path/to/datadir/mysql.sock