# Optimización MySQL para servidor con 8GB RAM
# Configuración para Taxes Software

[mysqld]
# ===================================
# InnoDB Buffer Pool - Parámetro más importante
# ===================================
# Se asigna 4GB (50% de RAM total)
innodb_buffer_pool_size = 4G
innodb_buffer_pool_instances = 4
innodb_buffer_pool_chunk_size = 128M

# ===================================
# InnoDB Log Files
# ===================================
innodb_log_file_size = 512M
innodb_log_buffer_size = 32M
innodb_flush_log_at_trx_commit = 2
innodb_flush_method = O_DIRECT

# ===================================
# Thread y Table Cache
# ===================================
thread_cache_size = 50
thread_stack = 256K
table_open_cache = 4000
table_definition_cache = 2000

# ===================================
# Buffers generales
# ===================================
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 4M
join_buffer_size = 2M
tmp_table_size = 256M
max_heap_table_size = 256M

# ===================================
# MyISAM (si se usa)
# ===================================
key_buffer_size = 128M
myisam_sort_buffer_size = 64M

# ===================================
# Conexiones
# ===================================
max_connections = 200
max_allowed_packet = 64M
connect_timeout = 10
wait_timeout = 600
interactive_timeout = 600

# ===================================
# Logs y Debugging
# ===================================
slow_query_log = 1
slow_query_log_file = /var/lib/mysql/slow-query.log
long_query_time = 2
log_error = /var/lib/mysql/error.log

# ===================================
# Optimizaciones adicionales
# ===================================
# Desactivar DNS lookup para mejorar rendimiento de conexiones
skip_name_resolve = 1