Dans : /etc/my.cnf
log-slow-queries = /var/log/mysql-slow.log
long_query_time = 5
log-long-format
#log-queries-not-using-indexes
log-warnings=2
Dans : /var/log/
touch mysql-slow.log
chmod 660 mysql-slow.log
chown mysql:mysql mysql-slow.log
service mysql restart