mysql slow queries

A note that have helped me on my issue. This is not my original work. It came from google search where I stumbled upon. I have forgotten where I got it from within postgres forums.

[mysqld]
long_query_time=1
log-slow-queries=/var/log/mysql/log-slow-queries.log

You must create the file manually and change owners this way:

mkdir /var/log/mysql
touch /var/log/mysql/log-slow-queries.log
chown mysql.mysql -R /var/log/mysql