Linux
#
# include *.cnf from the config directory
#
!includedir /etc/my.cnf.d
#
# This group is read both by the client and the server
# use it for options that affect everything
#
[client-server]
socket=/var/lib/mysql/mysql.sock
[client]
port = 3306
[mysqld]
#####################################
# Server management #
#####################################
port = 3306
bind-address = 0.0.0.0
back_log = 0
max_connections = 4000
wait_timeout = 1024
max_connect_errors = 10
table_open_cache = 8000
table_open_cache_instances = 16
max_allowed_packet = 32M
max_heap_table_size = 512M
read_buffer_size = 64M
read_rnd_buffer_size = 64M
sort_buffer_size = 64M
join_buffer_size = 64M
thread_cache_size = 512
thread_stack = 240K
default-storage-engine = InnoDB
transaction_isolation = REPEATABLE-READ
log-error=/var/log/mysqld.log
#####################################
# InnoDB Configuration #
#####################################
innodb_buffer_pool_size = 100G
innodb_data_file_path = ibdata1:10M:autoextend
innodb_write_io_threads = 64
innodb_read_io_threads = 64
innodb_flush_log_at_trx_commit = 1
innodb_log_buffer_size = 1GB
innodb_change_buffer_max_size = 25
innodb_max_dirty_pages_pct=90
innodb_max_dirty_pages_pct_lwm=10
innodb_log_file_size=32G
innodb_lock_wait_timeout = 256
innodb_flush_method = O_DIRECT
innodb_file_per_table
innodb_doublewrite=1
innodb_open_files=32768
innodb_use_native_aio=1
innodb_spin_wait_delay=6
innodb_max_purge_lag_delay=300000
innodb_max_purge_lag=0
innodb_checksum_algorithm=strict_crc32
innodb_io_capacity=10000
innodb_io_capacity_max=30000
innodb_change_buffering=none
innodb_read_only=0
innodb_undo_log_truncate=off
innodb_adaptive_flushing=0
innodb_adaptive_flushing_lwm=10
innodb_flush_neighbors=0