> From: machielr@stripped> To: mysql@stripped> Subject: slow queries not being logged
> Date: Tue, 23 Feb 2010 09:59:13 +0200
>
> Good day all
>
>
>
> I hope you can assist me with this one...
>
>
>
> We have a client where the slow query log was disabled.
>
Slow query log is on the server only. If you are saying you have enabled the slow query
log and the servers query log is empty can you post your my.cnf/my.ini file. Also make
sure --long-query-time is set appropriately.
>
>
> We noticed that the slow query amount (when viewing global
> status) has skyrocketed during the last 2 weeks going up to over 2 million
> (from 160 million queries).
>
>
>
> We wanted to look at these queries to see if it can be
> optimised to reduce the amount and went through the whole database restart
> routine to enable the slow query log again (they are running version 5.0 so
> had to restart).
>
>
>
>
>
> However, even though the slow query log is enabled, it is
> not logging the queries to the file specified.
>
>
>
> Can someone please assist in why this is not being done? I
> thought that it might be logging to a default filename but there is only one
> slow queries log file in the directory and it is empty.
>
>
>
> Checking the global status again, it showed 29 000 slow
> queries since this morning (3 hours ago) but nothing in the logs.
>
>
>
>
>
> Your help will be appreciated.
>
>
>
>
>
> Regards
>
>
>
_________________________________________________________________
Do you have a story that started on Hotmail? Tell us now
http://clk.atdmt.com/UKM/go/195013117/direct/01/

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.