Activer le slowlog MySQL

vi /etc/mysql/my.cnf

1	vi /etc/mysql/my.cnf

Décommenter les 2 lignes suivantes:

log_slow_queries = /var/log/mysql/mysql-slow.log
long_query_time = 10

log_slow_queries = /var/log/mysql/mysql-slow.log

long_query_time = 10

Enregistrer et relancer MySQL

service mysql restart

1	service mysql restart

Memo