# test
[mysqld]
pid-file        = /var/run/mysqld/mysqld.pid
socket          = /var/run/mysqld/mysqld.sock
datadir         = /var/lib/mysql
log-error       = /var/log/mysql/error.log
symbolic-links  = 0

# Desactivation des modes SQL stricts pour compatibilite application
sql_mode = NO_ENGINE_SUBSTITUTION

# Optimisation memoire et connexions
max_connections = 5000
max_connect_errors = 500
connect_timeout = 20
wait_timeout = 28800
interactive_timeout = 28800
max_allowed_packet = 64M
thread_cache_size = 128

# Buffers (a ajuster selon RAM)
sort_buffer_size = 4M
read_buffer_size = 2M
read_rnd_buffer_size = 8M
join_buffer_size = 2M

# Tables temporaires
tmp_table_size = 128M
max_heap_table_size = 128M

# InnoDB (le moteur par defaut)
innodb_buffer_pool_size = 1G
innodb_log_file_size = 256M
innodb_flush_log_at_trx_commit = 1
innodb_file_per_table = 1
innodb_flush_method = O_DIRECT

# MyISAM (si encore utilise)
key_buffer_size = 128M
myisam_sort_buffer_size = 64M
myisam_recover_options = BACKUP

# Journalisation requetes lentes
slow_query_log = 1
slow_query_log_file = /var/log/mysql/mysql-slow.log
long_query_time = 8

# Replication (desactive le demarrage automatique du slave)
skip-slave-start

# Reduit les resolutions DNS inutiles
skip-name-resolve

# Empêche le demarrage si fichiers corrompus
innodb_strict_mode = 1