/gist:fd5179599f673aa4f295d33caf299d7f
Created May 11, 2017
InnoDB 5.6.35 my.cnf
| nc_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 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