[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 key_buffer_size = 128M max_allowed_packet = 32M tmp_table_size = 64M max_heap_table_size = 64M max_binlog_size = 256M sort_buffer_size = 256k myisam_sort_buffer_size = 256k open-files-limit = 8192 net_write_timeout = 900 net_read_timeout = 900 server-id = 102 sync_binlog = 1 innodb_support_xa = 1 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 default-storage-engine = innodb character-set-server = utf8 innodb_file_format = Barracuda query_cache_size = 0 query_cache_type = 0 innodb_additional_mem_pool_size = 20M innodb_buffer_pool_size = 110G innodb_buffer_pool_instances = 12 innodb_io_capacity = 65536 innodb_open_files = 8000 table_open_cache = 8000 table_definition_cache = 12000 max_connections = 2400 innodb_lock_wait_timeout = 50 innodb_thread_concurrency = 0 innodb_sync_spin_loops = 20 innodb_log_file_size = 512M innodb_read_io_threads = 10 innodb_write_io_threads = 8 innodb_autoinc_lock_mode = 2 innodb_purge_threads = 4 innodb_purge_batch_size = 300 innodb_max_purge_lag = 5000000 open-files-limit = 16384 key_buffer_size = 200M back_log = 2500 table_open_cache_instances = 8 innodb_log_files_in_group = 3 innodb_log_buffer_size = 64M join_buffer_size = 256K sort_buffer_size = 1M innodb_use_native_aio = 1 innodb_stats_persistent = 1 innodb_spin_wait_delay = 48 innodb_adaptive_flushing = 1 innodb_checksum_algorithm = crc32 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 innodb_log_buffer_size = 16M innodb_flush_log_at_trx_commit = 1 innodb_stats_on_metadata = 0 innodb_flush_method = O_DIRECT innodb_file_per_table innodb_data_file_path = ibdata1:10M:autoextend blackhole = off archive = off federated = off innodb_monitor_disable = ALL performance_schema = on old_passwords = 0 secure-auth = on local-infile = off bind-address = 0.0.0.0 symbolic-links = 0 [mysqld_safe] log-error = /var/opt/log/snow/mysql/mysqld.log [mysqldump] quick max_allowed_packet = 32M [mysql] no-auto-rehash