[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

# 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=20M

# 默认16M
# tmp_table_size=16M

default_authentication_plugin=mysql_native_password