Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
[mysqld]
sql_mode=no_engine_substitution,no_unsigned_subtraction
default_tmp_storage_engine=MyISAM
sync_relay_log_info=100
relay_log_recovery=1
relay_log_info_repository=FILE
innodb_purge_threads=8
innodb_compression_pad_pct_max=37
innodb_compression_failure_threshold_pct=10
innodb_flush_neighbors=0
innodb_old_blocks_pct=50
innodb_max_dirty_pages_pct=75
innodb_max_dirty_pages_pct_lwm=0
innodb_adaptive_flushing=1
innodb_adaptive_flushing_lwm=10
innodb_adaptive_hash_index=0
innodb_flushing_avg_loops=30
innodb_max_purge_lag=0
innodb_max_purge_lag_delay=0
eq_range_index_dive_limit=1000
gtid_mode=OFF
enforce_gtid_consistency=ON
lock_wait_timeout=60
ssl=0
plugin_load=
skip_temp_pool=0
long_query_time=10
wait_timeout=10
interactive_timeout=120
max_allowed_packet=128M
slave_max_allowed_packet=256M
skip_name_resolve
back_log=4096
max_connections=5000
max_user_connections=4000
max_connect_errors=3000
key_buffer_size=16M
myisam_sort_buffer_size=256M
max_tmp_tables=64
read_buffer_size=1M
read_rnd_buffer_size=1M
sort_buffer_size=2M
table_open_cache=50000
table_definition_cache=60000
query_cache_limit=4M
query_cache_size=0
query_cache_type=0
thread_cache_size=500
thread_stack=196608
open_files_limit=32767
net_read_timeout=15
net_write_timeout=30
tmp_table_size=64M
max_heap_table_size=512M
group_concat_max_len=1024
default_storage_engine=InnoDB
innodb_compression_level=1
innodb_file_format=Barracuda
innodb_file_per_table=1
innodb_lock_wait_timeout=2
innodb_log_buffer_size=4M
innodb_log_compressed_pages=0
innodb_old_blocks_time=1000
innodb_open_files=10240
innodb_stats_on_metadata=0
datadir=/data/mysql/orig5635/data
innodb_data_home_dir=/data/mysql/orig5635/data
innodb_data_file_path=ibdata1:512M:autoextend
innodb_log_group_home_dir=/txlogs/myrocks
max_binlog_size=1G
binlog_cache_size=262144
max_binlog_cache_size=666G
log_bin=/binlogs/myrocks/bl
sync_binlog=0
binlog_format=row
tmpdir=/tmp
slave_load_tmpdir=/tmp
slow_query_log_file=/data/mysql/orig5635/slow.log
slow_query_log=1
log_slow_slave_statements=1
long_query_time=10
performance_schema=1
innodb_buffer_pool_instances=8
innodb_io_capacity=20000
innodb_io_capacity_max=40000
innodb_lru_scan_depth=5000
innodb_buffer_pool_size=200G
innodb_flush_log_at_trx_commit=2
innodb_doublewrite=1
innodb_page_size=16K
innodb_thread_concurrency=256
innodb_read_io_threads=32
innodb_write_io_threads=4
innodb_flush_method=O_DIRECT
performance_schema=1
# TODO - edit these
innodb_buffer_pool_size= 150G for in-memory, 35G for IO-bound
innodb_log_file_size= one of 2000M, 4000M, 8000M, 16000M
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.