MySQL Forums
Forum List  »  Docs

Enabling slow query log in windows
Posted by: Bastien Koert
Date: August 16, 2004 10:14AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Enabling slow query log in windows
30785
August 16, 2004 10:14AM
12639
August 17, 2004 04:00AM
17725
August 22, 2004 01:22PM


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.