Activate slow queries log

If your mysql database is not as fast as it used to be, maybe it is a good idea to activate the slow queries log. Add the following lines in your .my.cnf file:

All the queries that take more than 2sec to execute will be logged in the /var/log/mysql-slow-queries.log file