Ritesh Shetty wrote:
Hello,
My mysql server sometime just slows responding to database queries....It
is as slow as less than 1 per sec.
But it speeds up by itself after some time , I have noticed that when it
speeds up there are lot more MYsql thread than just one thread when it
is slow.
Sounds like you have some queries running that aren't indexed properly.
Try enabling your slow-query-log and see what gets put into that, then
you can work on fixing those queries.
See http://dev.mysql.com/doc/refman/5.1/en/slow-query-log.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
