[mysqld]
max_connections=5000
table_open_cache=50000
table_definition_cache=60000
query_cache_type=0
skip_log_bin
binlog-format=ROW
sync-binlog=0
# log_bin=/ssd1/scratch/data.mdcallag/binlogs/bl
slow_query_log_file=/ssd1/scratch/data.mdcallag/slow.log
slow_query_log=1
long_query_time=2
join_buffer_size=32K
sort_buffer_size=32K

innodb_flush_neighbors=0
innodb_read_io_threads=4
innodb_thread_concurrency=256
innodb_write_io_threads=4
innodb_io_capacity=10000
innodb_io_capacity_max=20000
innodb_lru_scan_depth=4000
innodb_flush_log_at_trx_commit=2
innodb_flush_method=O_DIRECT
innodb_doublewrite=1
innodb_page_size=8K
innodb_log_file_size=2000M
innodb_buffer_pool_size=100G
innodb_open_files=10000
innodb_log_buffer_size=64M
innodb_max_dirty_pages_pct=90
innodb_max_dirty_pages_pct_lwm=10
innodb_adaptive_flushing = 1
innodb_page_cleaners=4
innodb_use_native_aio=1
innodb_stats_persistent=1
#innodb_spin_wait_delay=6 / 96
innodb_purge_threads=4

innodb_log_group_home_dir=/ssd1/scratch/data.mdcallag/txlogs
innodb_data_home_dir=/ssd1/scratch/data.mdcallag/data
innodb_data_file_path=ibdata1:512M:autoextend

datadir=/ssd1/scratch/data.mdcallag/data

[mysqld_safe]
malloc-lib=/usr/lib64/libjemalloc.so