[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
