[mysqld]
port = 3306

server-id = 4294967295
skip-slave-start

default-time-zone='+08:00'

table_definition_cache=400
performance_schema_max_table_instances=400
table_open_cache=256


slow_query_log = 0

log-bin=mysql-bin
binlog-format = ROW
max_binlog_size = 200M
expire_logs_days = 7

explicit_defaults_for_timestamp = true
character_set_server = utf8
skip-name-resolve
max_connect_errors = 100
max_allowed_packet = 20M

connect_timeout = 3600

max_connections = 1000
max_user_connection = 600

# wait_timeout = 86400

# interactive_timeout = 86400

innodb_lock_wait_timeout = 10

long_query_time = 2

innodb_flush_log_at_trx_commit=1

# 默认128M
# innodb_buffer_pool_size=48G

#  默认8M
innodb_log_buffer_size=2M

#  默认8M
key_buffer_size=5M

# 默认16M
# tmp_table_size=16M

# 
ignore-db-dir=lost+found

#尝试修复ka1的mysql起不来的问题
#innodb_force_recovery = 6
#innodb_purge_thread = 0
