22 lines
514 B
INI
22 lines
514 B
INI
[mysqld]
|
|
# --- Log de Errores ---
|
|
log_error = /var/log/mysql/error.log
|
|
|
|
# --- Log General (Consultas y Debug) ---
|
|
general_log = 1
|
|
general_log_file = /var/log/mysql/general.log
|
|
|
|
# --- Registro de Transacciones (Binary Log) ---
|
|
server-id = 1
|
|
log_bin = /var/log/mysql/mysql-bin.log
|
|
binlog_format = ROW
|
|
expire_logs_days = 7
|
|
|
|
# --- Consultas Lentas (Slow Query Log) ---
|
|
slow_query_log = 1
|
|
slow_query_log_file = /var/log/mysql/slow.log
|
|
long_query_time = 2
|
|
|
|
# --- Depuración de InnoDB ---
|
|
innodb_print_all_deadlocks = 1
|