Cannot Connect: Can't create a new thread (errno 11)

Folks,  

I'm wondering is someone could help us in trying to resolve the above error, we have read through what threads we could find and tried all the suggestions, but have had no luck.  

There are no memory problems, in fact when this happens if there is still a localhost client connection to the server you can do whatever you want, everything is running normal. It just refuses all new connections. When it happens there is plenty of memory on the machine and no load at all (everything is running just as it should). Once things fall below 90, everything comes back.  

The problem happens when the process list hits the 91st process every time. 90 processes, no problems, the 91st process/connection gets the above error and any after that simple gets "Can't connect to MySQL server".  

We've tried all the obvious things, messing with the number of connections, open files etc. Nothing seems to work.  

We are running MySQL 5 on Centos 5 (flavor of RedHat). The machine is dedicated to MySQL.  

Below is a link to a text file that shows the OS limits for the mysql account on the machine and the output from show variables (including it made the message to large for the list).  

http://208.3.90.212/wtresults.txt  

Do you need help?

In addition to our free technical library, Pantek provides professional IT services to companies who utilize Open Source software: Learn more about Pantek's Technical Support offerings Place an order for 24/7/365 Technical Support here Learn more about Pantek, who we are, and what we do Chat with a Live Operator Related lists.mysql.com Links announce benchmarks bugs certification cluster commits dotnet gui-tools internals java maxdb myodbc mysql mysqldoc packagers perl plusplus replication win32 Request more information about Pantek

If anyone has any suggestions, it would be appreciated.  

Thanks!   Received on Wed Jul 4 11:56:34 2007