I'm trying to log MySQL slow queries, but I can't turn it on, I will explain all my steps:
- I Edit my.cnf and add the following lines
long_query_time = 1
slow_query_log_file = /home/mysql/slow_queries.log
slow_query_log = 1
- Give mysql user permitions to write on the file
chown -R mysql:mysql /home/mysql
- Restart the service
/etc/init.d/mysqld restart
I check the MySQL logs and don't find any error during the restart!