[mysqld]
transaction_isolation=REPEATABLE-READ
#transaction-isolation = READ-COMMITTED

#myisam
key_buffer_size=4000M
ft_max_word_len = 16
low_priority_updates=1

#gen
ssl=0
core-file
max_connections=4000
table_open_cache = 8000
table_open_cache_instances=16
back_log=1500
query_cache_type=0
join_buffer_size=32K
sort_buffer_size=32K

# files
innodb_file_per_table
innodb_log_file_size=1024M
innodb_log_files_in_group = 4
innodb_open_files=4000
innodb_use_native_aio=1
innodb_stats_persistent = 1

# buffers
innodb_buffer_pool_size=32000M
innodb_buffer_pool_instances=8
innodb_log_buffer_size=64M

innodb_checksums=0
innodb_doublewrite=0
innodb_support_xa=0
innodb_thread_concurrency=64
innodb_flush_log_at_trx_commit=2
innodb_flush_method=O_DIRECT_NO_FSYNC
innodb_max_dirty_pages_pct=90
innodb_max_dirty_pages_pct_lwm=10

#perf
innodb_spin_wait_delay=6
innodb_adaptive_flushing = 1
innodb_flush_neighbors = 0
innodb_read_io_threads=16
innodb_write_io_threads=16
innodb_io_capacity=4000
innodb_io_capacity_max=10000
innodb_purge_threads=4
innodb_adaptive_hash_index=0
innodb_max_purge_lag_delay=300000
innodb_max_purge_lag=500000
innodb_lru_scan_depth=2000
innodb_change_buffering=none
innodb_read_only=0
innodb_page_cleaners=4


#binlog
sync-binlog=10000
relay-log=relay-1
binlog-format=row
enforce-gtid-consistency
gtid-mode=on
master-info-repository=TABLE
relay-log-info-repository=TABLE
plugin-dir=lib/plugin/

# monitoring
performance_schema=OFF