[client] port = 3306 socket = /tmp/mysql.sock [mysqld] port = 3306 datadir = /var/opt/data/snow/glide/mysql/data tmpdir = /var/opt/data/snow/glide/mysql/temp socket = /tmp/mysql.sock user = snowinsp server-id = 1002 key_buffer_size = 128M join_buffer_size = 256K max_allowed_packet = 32M max_binlog_size = 256M tmp_table_size = 64M sort_buffer_size = 1M open-files-limit = 16384 net_write_timeout = 900 net_read_timeout = 900 lock_wait_timeout = 14400 sync_binlog = 1 innodb_support_xa = 1 optimizer_switch = index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,engine_condition_pushdown=on,index_condition_pushdown=off,mrr=on,mrr_cost_based=on,block_nested_loop=on,batched_key_access=off,materialization=on,semijoin=on,loosescan=on,firstmatch=on,subquery_materialization_cost_based=on,use_index_extensions=on log-bin = /var/opt/data/snow/glide/mysql/binlog/mysql-binlog log-bin-index = /var/opt/data/snow/glide/mysql/binlog/mysql-binlog.index relay-log = /var/opt/data/snow/glide/mysql/relaylog/mysql-relay relay-log-index = /var/opt/data/snow/glide/mysql/relaylog/mysql-relay.index relay-log-info-file = /var/opt/data/snow/glide/mysql/relaylog/mysql-relay.info relay_log_recovery = 1 relay_log_info_repository = TABLE master_info_repository = TABLE expire_logs_days = 3 log-slave-updates = 1 read-only = 1 binlog_cache_size = 1M binlog_format = MIXED slave_compressed_protocol = 1 log-bin-trust-function-creators = 1 #skip-slave-start #init-file = /glide/my_init_file.sql default-storage-engine = innodb character-set-server = utf8 innodb_file_format = Barracuda query_cache_size = 0 query_cache_type = 0 innodb_use_native_aio = 1 innodb_stats_persistent = 1 innodb_adaptive_flushing = 1 innodb_checksum_algorithm = crc32 innodb_log_buffer_size = 64M innodb_flush_log_at_trx_commit = 1 innodb_stats_on_metadata = 0 innodb_flush_method = O_DIRECT innodb_lock_wait_timeout = 50 innodb_thread_concurrency = 0 innodb_file_per_table performance_schema = on innodb_data_file_path = ibdata1:10M:autoextend old_passwords = 0 secure-auth = on local-infile = off bind-address = 0.0.0.0 innodb_monitor_disable = ALL max_connections = 2500 back_log = 2500 table_open_cache_instances = 8 innodb_log_files_in_group = 3 innodb_buffer_pool_size = 180G innodb_log_file_size = 1024M innodb_read_io_threads = 10 innodb_write_io_threads = 8 innodb_sync_spin_loops = 20 innodb_io_capacity = 65536 innodb_buffer_pool_instances = 12 innodb_additional_mem_pool_size = 20M innodb_open_files = 8000 table_open_cache = 8000 table_definition_cache = 12000 innodb_autoinc_lock_mode = 2 innodb_purge_threads = 4 innodb_purge_batch_size = 300 innodb_max_purge_lag = 5000000 blackhole = off archive = off federated = off innodb_spin_wait_delay = 48 symbolic-links = 0 ##replication cluster test params need to be deleted before live replicate-wild-ignore-table=mysql.% [mysqld_safe] log-error = /var/opt/log/snow/mysql/mysqld.log #log-error = /var/opt/data/snow/glide/mysql/mysqld.log pid-file=/var/run/mysqld/mysqld.pid [mysqldump] quick max_allowed_packet = 32M [mysql] no-auto-rehash