Enabling slow query log in windows
Hi All
have searched and searched but have not been able to figure out how to enable slow query log in windows. *nix samples abound, but sadly, no windows examples...
Please let me know how to configure the my.cnf or the my.ini file to make this work on windows.
Our current setup is
my.cnf
set-variable = long_query_time=2
log-long-format
log-slow-queries = c:\mysql\log\slow_queries.log
But it shows nothing. When I run the slow query query thru phpmyadmin, I get like 1200 entries...
Should I look at changing the time limit, or have I done something else wrong?
TIA
Bastien
Subject
Views
Written By
Posted
Enabling slow query log in windows
30785
August 16, 2004 10:14AM
12639
August 17, 2004 04:00AM
10053
August 20, 2004 10:16AM
17725
August 22, 2004 01:22PM
9194
September 21, 2007 08:52PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.