MySQL Forums
Forum List  »  Security

unauthenticated user in login status : zombie Threads
Posted by: Armand Krijgsman
Date: March 27, 2008 05:57AM

Hi All,

I am new to this forum, so thank you for your time reading my first post.
Since 2 days I keep getting "Maximum connection limit reached" errors, so I went looking in the process list, and found lots of connections to my server from other hosts then localhost.

These threads seemed to be inactive, so I killed them.
They however keep the connection reserved in the proccess list, even when their status is killed.

I was happy to be able to create a replication server back 2 years ago (which is still working) So I am a bit affraid in doing a full mysqld restart. (so don't even know if this empties up the connections)

My questions:
- Is there a way to flush the threads? (mysqladmin flush-threads isn't working)
- Is there a way to block outside tcp connections without blocking the replication host?
- Is it save to restart mysqld for my replication host? (And will this clear my threads list?)

Thanks in advance!

Regards,
Armand

Options: ReplyQuote


Subject
Views
Written By
Posted
unauthenticated user in login status : zombie Threads
5978
March 27, 2008 05:57AM


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.