Creating the MySQL slow query log file

Question

What do I need to do to generate the slow logs file in MySQL?

I did:

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

What more do I need to do to?

Answer 1

Seeing the path of the slow log is for Windows, I suggest putting quotes around the path

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

also make sure the lines are under the [mysqld] group header

The only thing left to do is restart mysql

run this

C:\> net stop mysql

wait about 30 seconds, then run

C:\> net start mysql

If this does not work, perhaps try flipping the slashes in the path

[mysqld]
log_slow_queries  = "C:/Program Files/MySQL/MySQL Server 5.1/mysql-slow.log"
long_query_time  = 1 

Give it a Try !!!