MySQL Forums :: Install & Repo :: Big Threads_connected

Advanced Search

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

Options: ReplyQuote

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.