List:General Discussion« Previous MessageNext Message »
From:Ananda Kumar Date:December 31 2008 1:44pm
Subject:slow query log
View as plain text  
Hi All,
I have enabled slow query log.
Generally this file will have sql's which take more than long-query time to
execute and also sql's not using indexes.
But i see sql's which does not come under the above condition.
I have set the long-query time to 1 Sec .

The query takes less than 1 sec to execute and also uses indexes, but still
its recored in slow query log.
Any idea why this happens.

Thanks for your help.

regards
anandkl

Thread
slow query logAnanda Kumar31 Dec
Re: slow query logceo31 Dec
Re: slow query logAnanda Kumar2 Jan
  • Re: slow query logBaron Schwartz2 Jan
    • Re: slow query logAnanda Kumar2 Jan