inventory/docker/mysql/my.cnf

[mysqld]
# General Configuration
default-storage-engine=InnoDB
character-set-server=utf8mb4
collation-server=utf8mb4_unicode_ci

# Performance Settings
innodb_buffer_pool_size=256M
innodb_log_file_size=64M
innodb_flush_log_at_trx_commit=2
innodb_flush_method=O_DIRECT

# Connection Settings
max_connections=100
max_allowed_packet=64M

# Query Cache (disabled for performance in MySQL 8)
query_cache_type=0
query_cache_size=0

# Slow Query Log
slow_query_log=1
slow_query_log_file=/var/log/mysql/slow.log
long_query_time=2

# Error Log
log_error=/var/log/mysql/error.log

# Binary Log (for replication if needed)
log_bin=mysql-bin
binlog_format=ROW
expire_logs_days=7

[mysql]
default-character-set=utf8mb4

[client]
default-character-set=utf8mb4