Under "[mysqld]" copy the details below :vi /etc/my.cnf
You must create the file manually and change ownership :[mysqld]
log-slow-queries = ON
long_query_time=1
log-slow-queries=/var/lib/mysql/log-slow-queries.log
Restart mysqltouch /var/lib/mysql/log-slow-queries.log
chown mysql.mysql /var/lib/mysql/log-slow-queries.log
Check the logs :/etc/init.d/mysql restart
tail -f /var/lib/mysql/log-slow-queries.log