Enabling MySQL Slow Query Log
1. Check if its enabled:
mysqladmin -u root -p var |grep log_slow_queries
2. If off, edit /etc/mysql/my.cnf
3. add this under mysqld section:
[mysqld]
long_query_time = 1
log-slow-queries = /var/log/mysql/mysql-slow.logsource: http://www.ducea.com/2006/11/06/identifying-mysql-slow-queries/Comments [0]







