mysql has about 50GB of temp space to work with so thats not the problem.
Its strange because the server is not that loaded and around 12-04 at night no cronjobs that affects mysql or general server performance are being run.
Is is possible to se how many queued up questions mysql has at the moment?
Peter Lovatt wrote:
Hi
there a are a couple of things that I have found cause occasional lock ups.
running out of temp space - MySql builds temp files on bigger queries and if it runs out of temp disk space it grinds to a halt, which causes all the following queries to queue up until max_connections is exceeded.
the second cause is one massive query - big tables, lots of joins etc - that takes so much processing power that there is nothing left. MySql and perhaps the server slows down to the point that it cannot process any more queries, and again the queue builds until max_connections is exceeded.
if the lockup occurs overnight this might be the time the server is doing housekeeping - apache log analysis for example - so it may be the server is loaded too heavily to manage MySql queries too, so again the queue builds up.
Just a few thoughts - hope it helps.
Peter
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
