[mysqld]
datadir      = /path/to/datadir
tmpdir       = ../tmp
socket       = mysql.sock
bind_address = 0.0.0.0

back_log  = 1000

server_id = 999999999
read_only = 0 

event_scheduler = ON

log-bin          = ../log/binlog
binlog_format    = STATEMENT
binlog_row_image = minimal
sync_binlog      = 1
expire_logs_days = 7
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

character_set_server = utf8
concurrent_insert = AUTO
group_concat_max_len = 1048576
init_connect = 'SET NAMES utf8'
key_buffer_size = 64M
max_allowed_packet = 16M
max_connections = 7000
max_connect_errors = 15000
max_heap_table_size = 64M
myisam_repair_threads = 1
myisam_sort_buffer_size = 64M
open_files_limit = 20000

report_host = slave-5-6-25
report_port = 3306

optimizer_switch = 'index_merge=off,index_merge_union=off,index_merge_sort_union=off,index_merge_intersection=off'

query_cache_size = 0
query_cache_type = 0

read_buffer_size = 128k
sort_buffer_size = 1M

sql_mode = NO_ENGINE_SUBSTITUTION

table_definition_cache = 3000
table_open_cache = 3000
thread_cache_size = 3500
tmp_table_size = 64M
transaction-isolation = REPEATABLE-READ
wait_timeout = 300

myisam_recover_options = FORCE,BACKUP

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

host_cache_size = 2000

gtid_mode = OFF
enforce_gtid_consistency = 0

slave_parallel_workers = 25

default_storage_engine = InnoDB
default_tmp_storage_engine = InnoDB

innodb_adaptive_flushing = 1
innodb_adaptive_hash_index = 0
innodb_buffer_pool_dump_at_shutdown = 1
innodb_buffer_pool_load_at_startup  = 0
innodb_buffer_pool_size = 56G

innodb_buffer_pool_instances = 28
innodb_change_buffering = INSERTS
innodb_file_per_table
innodb_file_format = Barracuda

innodb_flush_neighbors = 1

innodb_doublewrite = 1

innodb_flush_log_at_trx_commit = 2
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 = 1024M
innodb_max_dirty_pages_pct = 75
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_support_xa = 1

performance_schema = 1
performance_schema_consumer_events_statements_current = ON
performance_schema_consumer_events_statements_history_long = OFF
performance_schema_consumer_events_waits_current = ON
performance_schema_consumer_events_waits_history = ON
performance_schema_consumer_events_waits_history_long = ON

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

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash
default_character_set = utf8

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

[mysqlhotcopy]
interactive-timeout

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