Search code examples
mysqlloggingmysql-slow-query-log

mysql-slow-log file is not generated

log_slow_queries  = "C:\Program Files\MySQL\MySQL Server 5.1\mysql-slow.log" 
long_query_time  = 1

I wrote the lines above in my.ini file. But after running my query, which is taking more than 1 second to execute, the log file is not generated. What am I doing wrong?

Thanks in advance....

Solution

  • Please restart mysql service. Pl execute this and check : SHOW VARIABLES LIKE '%slow_query_log%'; this will help you to identify the location of the mysql slow query log file.