Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- [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
- # block_create_myisam=1
- gtid_mode=OFF
- enforce_gtid_consistency=ON
- lock_wait_timeout=60
- # part_scan_max=1000
- ssl=0
- plugin_load=
- skip_temp_pool=0
- # block_ftwrl=1
- #skip_partition=1
- 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_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/orig5710/data
- innodb_data_home_dir=/data/mysql/orig5710/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/orig5710/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
- innodb_buffer_pool_size=195G
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement