MySQL Forums :: Install :: Big Threads_connected
Big Threads_connected
Posted by: Vladimir Polukhin ()
Date: October 25, 2011 04:18PM
Hello. From time to time (couple times per month) there is a problem with the work of mysql.
First, a dramatic increase Threads_connected until it reaches the limit max_threads = 250. moreover, the usual Threads_connected value does not exceed 5.
It freezes (I waited for 10 minutes) when I try to restart it with message "Waiting for PIDS: 99125." and I have to kill process (and then restore a bunch of tables)
In the Show processlist requests attended to different tables in all sorts of different statuses: end, Locked, update, NULL
First, a dramatic increase Threads_connected until it reaches the limit max_threads = 250. moreover, the usual Threads_connected value does not exceed 5.
It freezes (I waited for 10 minutes) when I try to restart it with message "Waiting for PIDS: 99125." and I have to kill process (and then restore a bunch of tables)
In the Show processlist requests attended to different tables in all sorts of different statuses: end, Locked, update, NULL
| Subject | Written By | Posted |
|---|---|---|
| Big Threads_connected | Vladimir Polukhin | 10/25/2011 04:18PM |
| Re: Big Threads_connected | Vladimir Polukhin | 10/25/2011 04:24PM |
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.
© 2013, Oracle Corporation and/or its affiliates