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: 570
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