Skip navigation links

MySQL Forums :: Database Administration & Monitoring :: Urgent: Thread Problem with MySQL Server


Advanced Search

Urgent: Thread Problem with MySQL Server
Posted by: mfeldheim ()
Date: January 10, 2005 11:28AM

Hello all together,

since some time I have the problem that my MySQL Server blocks for short time because of too many open threads.

In the threadlist appear strange "unatorized users":

95487 unauthenticated user mymysqlhost.de:56734 no database Connect Reading from net ---

these threads increment as long as the server breaks down.

Host 'mymysqlhost.de' is blocked because of many connection errors. Unblock with 'mysqladmin flush-hosts'

I tried to solve the problem by setting down the timeout and raised the maximum threads.
Nothing helped, the problem appears in irregular time gaps

I don't know what else to do.. or what is the cause for this myterious users.

Can somebody say me a reason and a solution how to fix the problem?

Thank you very much

Greetz T_Crusher

Options: ReplyQuote


Subject Written By Posted
Urgent: Thread Problem with MySQL Server mfeldheim 01/10/2005 11:28AM
Re: Urgent: Thread Problem with MySQL Server Azli Ehwan 01/25/2005 01:17AM
Re: Urgent: Thread Problem with MySQL Server Marek Wylon 03/04/2005 06:17AM
Re: Urgent: Thread Problem with MySQL Server Matthew Boehm 03/21/2005 04:37PM
Re: Urgent: Thread Problem with MySQL Server 04/07/2005 01:33PM


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.