I'm managing two database servers, one 3.23.52 and one 3.23.52-Max (using innodb tables on that one).
They are both running along fine until they suddently start to accumulate a lot of treads (a lot ~= 200-300), the state of these threads is mostly "closing" and "opening" tables. This drives up the load to amazing numbers and I'm forced to shut the mysql-server down. Since I'm running these servers in a shared environment I got a lot of users using these servers, and so far I haven't got any grip on whats causing these problems. I got these problems on both servers (one with max and one without), both servers got diffrent users. I've ruled out hardware problems since I get exactly the same behaviour on two independent servers. It would be great if sombody knows the answer to my questions bellow: - is there any know problems with mysql on linux? or with 3.23.52 that should cause this behaviour - what should I do to find the error, my logs shows nothing pecuilar. I'm currently dumping a processlist each five seconds to a file. regards /Lars --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
