Log slow queries

De Reyesoft

Activar Log slow queries (log-slow-queries). 

 # mysqladmin var -u process_user --password=[contraseña]  | grep log_slow_queries
 | log_slow_queries                | OFF
 # mkdir /var/log/mysql
 # chmod mysql:mysql /var/log/mysql
 # vim /etc/my.cnf
     [mysqld]
     long_query_time = 1
     log-slow-queries = /var/log/mysql/mysql-slow.log
 # /etc/init.d/mysqld restart
Obtenido de "http://wiki.reyesoft.com/Log_slow_queries"