[mysqld] # Charset character-set-server = utf8mb4 collation-server = utf8mb4_unicode_ci # Performance innodb_buffer_pool_size = 256M innodb_log_file_size = 64M innodb_flush_log_at_trx_commit = 2 innodb_flush_method = O_DIRECT # Connection max_connections = 200 wait_timeout = 28800 interactive_timeout = 28800 connect_timeout = 10 # Query cache (disabled in MySQL 8, remove if needed) # query_cache_type = 0 # Slow query log slow_query_log = 1 long_query_time = 2 slow_query_log_file = /var/lib/mysql/slow.log # General max_allowed_packet = 64M sql_mode = STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION [mysql] default-character-set = utf8mb4 [client] default-character-set = utf8mb4