[mysqld]
...
# * Logging and Replication
#
# Both location gets rotated by the cronjob.
# Be aware that this log type is a performance killer.
log = /var/lib/mysql/log/sql.log
log_slow_queries = /var/lib/mysql/log/sql.slow.log
long_query_time = 2
And restart mysqld instance.
Nessun commento:
Posta un commento