[client]
#default-character-set = utf8mb4
port = 3513
socket = /Data/mysql/my3513/run/mysql.3513.sock
#loose-default-character-set = utf8
[mysqld]
read_only = 1
port = 3513
socket = /Data/mysql/my3513/run/mysql.3513.sock
datadir = /Data/mysql/my3513/data
server-id = 1536238916
character-set-server = utf8mb4
collation-server = utf8mb4_bin
default-storage-engine = InnoDB
skip_name_resolve = 1
open_files_limit = 60000
secure_file_priv = /Data/mysql/backup/
federated
skip-slave-start
skip-name-resolve
skip-external-locking
log-slave-updates
rpl_semi_sync_master_enabled = 1
rpl_semi_sync_master_timeout = 1000 # 1 second
local_infile = 1
back_log = 500
max_allowed_packet = 1073741824
max_connections = 12000
max_connect_errors = 800
key_buffer_size = 64M
sort_buffer_size = 16M
read_buffer_size = 16M
read_rnd_buffer_size = 16M
join_buffer_size = 64M
tmp_table_size = 64M
max_heap_table_size = 64M
binlog_cache_size = 8M
myisam_sort_buffer_size = 64M
thread_cache_size = 512
query_cache_size = 32M
slow_query_log = 1
slow_query_log_file = /Data/mysql/my3513/log/mysql-slow.log
long_query_time = 0.1
log-error = /Data/mysql/my3513/log/mysql-error.log
log-bin = /Data/mysql/my3513/log/mysql-bin
log-bin-index = /Data/mysql/my3513/log/master-log-bin.index
relay-log = /Data/mysql/my3513/log/slave-relay
relay-log-info-file = /Data/mysql/my3513/log/slave-relay-log.info
relay-log-index = /Data/mysql/my3513/log/slave-relay-log.index
master-info-file = /Data/mysql/my3513/log/master.info
binlog_format = ROW
relay_log_purge = 0
tmpdir = /Data/mysql/my3513/tmp
thread_concurrency = 32
secure_auth = 1
local-infile = 0
event_scheduler = OFF
datadir = /Data/mysql/my3513/data
expire_logs_days = 21
lower_case_table_names = 1
innodb_large_prefix=ON
innodb_file_per_table = 1
innodb_file_format = barracuda
innodb_file_format_check = 1
innodb_open_files = 4096
innodb_data_home_dir = /Data/mysql/my3513/data
innodb_data_file_path = ibdata1:1000M;ibdata2:1000M;ibdata3:1000M;ibdata4:100M:autoextend
innodb_log_group_home_dir = /Data/mysql/my3513/log
innodb_table_locks = 0
innodb_buffer_pool_size = 32G
innodb_log_file_size = 512M
innodb_log_files_in_group = 2
innodb_log_buffer_size = 128M
innodb_flush_method = O_DIRECT
innodb_flush_log_at_trx_commit = 1
sync_binlog = 1
innodb_max_dirty_pages_pct = 60
innodb_write_io_threads = 16
innodb_read_io_threads = 8
innodb_adaptive_flushing = 1
innodb_thread_concurrency = 0
innodb_io_capacity_max = 25000
innodb_io_capacity = 20000
performance_schema_consumer_events_waits_current=on
performance_schema_consumer_events_stages_current=on
performance_schema_consumer_events_statements_current=on
performance_schema_consumer_events_waits_history=on
performance_schema_consumer_events_stages_history=on
performance_schema_consumer_events_statements_history=on
performance_schema_events_stages_history_long_size = 100000
performance_schema_events_stages_history_size = 1000
performance_schema_events_statements_history_long_size = 100000
performance_schema_events_statements_history_size = 1000
performance_schema_events_waits_history_long_size = 100000
performance_schema_events_waits_history_size = 1000
query_response_time_stats = on
innodb_monitor_enable = on
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
[isamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M
[myisamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout
