MySQL Forums
Forum List  »  Docs

Re: Enabling slow query log in windows
Posted by: Stefan Hinz
Date: August 22, 2004 01:22PM

Bastien Koert wrote:

> Didn't work, we used winmysqladmin to set it in
> the my.ini file. Should it go someplace else?

No, %windir%\my.ini (e.g. c:\windows\my.ini) is the right location.

> The servers are, as mentioned windows, and are
> rebooted every night.
>
> If you have any other ideas, I'd appreciate the
> help...

I'd suggest to try these steps in my.ini:

1) log-slow-queries -- This will enable the default slow query log file, <hostname>-slow.log in the MySQL data directory (e.g. c:\mysql\data\). If this doesn't work, there's some other problem, maybe the server doesn't read my.ini for some reason, or some entries get overwritten by another configuration file.

2) log-slow-queries=<filename>

3) log-slow-queries=<your>/<path>/<filename>

Options: ReplyQuote


Subject
Views
Written By
Posted
30770
August 16, 2004 10:14AM
12633
August 17, 2004 04:00AM
Re: Enabling slow query log in windows
17716
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.