Skip to content

Instantly share code, notes, and snippets.

@mdcallag
Created May 11, 2017 01:08
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
Star You must be signed in to star a gist
Save mdcallag/dbf5ddf5717e8bd7caee6b8a402f6eb6 to your computer and use it in GitHub Desktop.
my.cnf for InnoDB 5.7.17
[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
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/orig5717/data
innodb_data_home_dir=/data/mysql/orig5717/data
innodb_data_file_path=ibdata1:512M:autoextend
innodb_log_group_home_dir=/txlogs/myrocks
log_bin=/binlogs/myrocks/bl
max_binlog_size=1G
binlog_cache_size=262144
max_binlog_cache_size=666G
server_id=77
sync_binlog=0
tmpdir=/tmp
slave_load_tmpdir=/tmp
slow_query_log_file=/data/mysql/orig5717/slow.log
slow_query_log=1
log_slow_slave_statements=1
secure_file_priv=""
long_query_time=10
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_page_cleaners=8
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 set this
innodb_buffer_pool_size=180G or 35G
# TODO set this
innodb_log_file_size=xM
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment