identifier les requètes lentes sur MySQL

1. Télécharger et installer ActivePerl : http://www.activestate.com/activeperl/downloads/

2. Editer le fichier de conf « my.ini »

slow_query_log=1
slow_query_log_file=c:\logmysql.log
long_query_time=0.1

3. Redémarrer mysql

4. Exécuter sous DOS

C:\Documents and Settings\Formation>perl "C:\Program Files\MySQL\MySQL Server 5.
5\bin\mysqldumpslow.pl" c:\logmysql.log
Reading mysql slow query log from c:\logmysql.log
Count: 1 Time=0.00s (0s) Lock=0.00s (0s) Rows=0.0 (0), 0users@0hosts
c:\Program Files\MySQL\MySQL Server N.N\bin\mysqld, Version: N.N.N-log (MySQL
Community Server (GPL)). started with:
TCP Port: N, Named Pipe: (null)
# Time: N N:N:N
# User@Host: root[root] @ localhost [N.N.N.N]
# Query_time: N.N Lock_time: N.N Rows_sent: N Rows_examined: N
SET timestamp=N;
SHOW FULL COLUMNS FROM `world_innodb`.`city`