| 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 log | Ananda Kumar | 31 Dec |
| • Re: slow query log | ceo | 31 Dec |
| • Re: slow query log | Ananda Kumar | 2 Jan |
| • Re: slow query log | Baron Schwartz | 2 Jan |
| • Re: slow query log | Ananda Kumar | 2 Jan |
