[mysqld]
skip-log-bin = 1
default-authentication-plugin = mysql_native_password

# Memory & Cache Optimization
innodb_buffer_pool_size = 38G
innodb_buffer_pool_instances = 8
innodb_log_file_size = 4G
innodb_redo_log_capacity = 4G
innodb_file_per_table = 1

# Safe limits for shared hosting
max_connections = 320
max_user_connections = 20

# Per-connection memory (prevent swap)
join_buffer_size = 1M
sort_buffer_size = 2M
read_buffer_size = 256K
read_rnd_buffer_size = 512K

# Query behavior & safety
sql_mode = STRICT_ALL_TABLES,NO_ENGINE_SUBSTITUTION
innodb_strict_mode = ON
performance_schema = ON

# Timeouts — prevent idle waste
wait_timeout = 50
interactive_timeout = 50

# Other
open_files_limit = 80000
mysqlx = 0
max_allowed_packet=268435456