[mysqld] # Character set configuration character-set-server = utf8mb4 collation-server = utf8mb4_unicode_ci # Performance tuning max_connections = 200 innodb_buffer_pool_size = 512M innodb_log_file_size = 128M # Binary logging log_bin = mysql-bin binlog_format = ROW expire_logs_days = 7 # Slow query log slow_query_log = 1 slow_query_log_file = /var/log/mysql/slow-query.log long_query_time = 2 [client] default-character-set = utf8mb4 [mysql] default-character-set = utf8mb4