slow query logging in mysql server

Posted by Vinayak Mahadevan on Server Fault See other posts from Server Fault or by Vinayak Mahadevan
Published on 2011-01-24T17:35:41Z Indexed on 2011/02/06 7:27 UTC
Read the original article Hit count: 571

Filed under:
|

Hi

I have installed MySQL Community Edition 5.1.41 on a windows 2000 server. In my.ini file I have enabled slow query logging and have redirected the output to a table.I have set the long_query_time to 10 seconds. Then after running some queries I checked up the slow query log table and found that all the queries which were executed have been logged and a file called database-slow.log has also been created in the data folder. Can anybody please tell me where I am going wrong. I am using the inbuilt innodb and not activated the innodb plugin.

Thanks

© Server Fault or respective owner

Related posts about mysql

Related posts about logging