Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- [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_file_format=Barracuda
- 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
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement