Skip to content

Instantly share code, notes, and snippets.

@mdcallag
Created January 14, 2016 16:30
Show Gist options
  • Save mdcallag/6591502e53ec1635a4d3 to your computer and use it in GitHub Desktop.
Save mdcallag/6591502e53ec1635a4d3 to your computer and use it in GitHub Desktop.
[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
# log_slow_extra=1
group_concat_max_len=1024
default_storage_engine=InnoDB
innodb_compression_level=1
# innodb_deadlock_detect=0
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_log_file_size=2000M
innodb_old_blocks_time=1000
innodb_open_files=10240
innodb_stats_on_metadata=0
innodb_log_file_size=2000M
datadir=/data/mysql/orig5626/data
innodb_data_home_dir=/data/mysql/orig5626/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
tmpdir=/tmp
slave_load_tmpdir=/tmp
slow_query_log_file=/data/mysql/orig5626/slow.log
slow_query_log=1
log_slow_slave_statements=1
performance_schema=1
# innodb_use_native_aio=0
innodb_buffer_pool_instances=8
# innodb_page_cleaner_interval_millis=1000
innodb_io_capacity=10000
innodb_io_capacity_max=20000
innodb_lru_scan_depth=2000
innodb_buffer_pool_size=105G
# innodb_page_cleaners=8
innodb_flush_log_at_trx_commit=2
innodb_flush_method=O_DIRECT
innodb_doublewrite=1
innodb_page_size=8K
innodb_thread_concurrency=256
innodb_read_io_threads=32
innodb_write_io_threads=4
long_query_time=10
skip_log_bin
sync_binlog=0
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment