[mysqld]
port = 3306
bind-address = 0
skip-host-cache
skip-name-resolve
#log_error = /var/log/mysql.error.log

slow_query_log = 1
#slow_query_log_file = /var/log/mysql.slow.log
long_query_time = 5
log_slow_verbosity = query_plan
log-queries-not-using-indexes

skip-external-locking

expire_logs_days            = 7
max_binlog_size             = 50M

max_allowed_packet          = 32M
key_buffer_size             = 16M
innodb_buffer_pool_size     = 1G
innodb_file_per_table       = 1
innodb_flush_method         = O_DIRECT
innodb_flush_log_at_trx_commit  = 0
innodb_stats_on_metadata = OFF

default_time_zone = '+00:00'
sql_mode = STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION,NO_UNSIGNED_SUBTRACTION,PAD_CHAR_TO_FULL_LENGTH,NO_AUTO_CREATE_USER

character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci

[client]
default-character-set=utf8mb4