[mysqld]
skip-networking=0
bind-address=0.0.0.0
socket=/tmp/mysql.sock
ssl=0
port=3306
# general
skip_log_bin=0
log_bin=mysql-bin
server_id=1
sync_binlog=1
max_connections=100000
table_open_cache=2000
table_open_cache_instances=16
back_log=1500
max_prepared_stmt_count=128000
character_set_server=latin1
collation_server=latin1_swedish_ci
transaction_isolation=REPEATABLE-READ
# files
innodb_open_files=500005
# buffers
innodb_log_buffer_size=64M
# tune
innodb_doublewrite=1
innodb_flush_log_at_trx_commit=1
join_buffer_size=32K
sort_buffer_size=32K
innodb_use_native_aio=1
innodb_stats_persistent=1
innodb_log_write_ahead_size=4096
# purge
innodb_purge_threads=4
innodb_max_purge_lag=0
innodb_max_purge_lag_delay=1
innodb_io_capacity=200
innodb_io_capacity_max=2000
innodb_lru_scan_depth=128
innodb_adaptive_hash_index=0
innodb_undo_log_truncate=on
innodb_fast_shutdown=1
# perf special
innodb_max_dirty_pages_pct=1
innodb_max_dirty_pages_pct_lwm=0.1
innodb_adaptive_flushing=1
innodb_adaptive_flushing_lwm=0.1
innodb_flush_neighbors=0
innodb_read_io_threads=8
innodb_write_io_threads=8
innodb_read_ahead_threshold=0
innodb_buffer_pool_dump_at_shutdown=0
innodb_buffer_pool_load_at_startup=0
# diagnostics
performance_schema=OFF
event_scheduler=OFF
# logging
log_error=mysql.err
log_error_verbosity=3
# set at runtime
#datadir
#innodb_log_group_home_dir
#innodb_log_file_size
#innodb_redo_log_capacity
#innodb_buffer_pool_size
#innodb_buffer_pool_instances