Create a gist now

Instantly share code, notes, and snippets.

What would you like to do?
[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
socket=/tmp/mysql.sock
tokudb_cache_size = 40G
tokudb_directio = OFF
tokudb_empty_scan = disabled
tokudb_read_block_size = 8K
tokudb_commit_sync = OFF
tokudb_checkpointing_period = 900
tokudb_block_size = 4M
tokudb_cleaner_iterations = 10000
# tokudb_fanout = 128
tokudb_checkpoint_pool_threads = 4
tokudb_enable_partial_eviction = OFF
tokudb_row_format = tokudb_zlib
default-storage-engine = tokudb
skip-innodb
default-tmp-storage-engine=MyISAM
[mysqld_safe]
malloc-lib=/usr/lib64/libjemalloc.so
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment