Enable Logging of Slow Queries

vim /etc/my.cnf

log-slow-queries = /var/log/mysql/mysql-slow.log
long_query_time = 1