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
I check the mysql logs and don't find aby error during the restart!
Thanks in advance!!