Kevin, As I mentioned earlier, set this in you're my.cnf and restart mysql. It has helped me on many occasions.
open-files-limit=36864 Donny > -----Original Message----- > From: Kevin Marks [mailto:[EMAIL PROTECTED] > Sent: Monday, February 23, 2004 6:27 PM > To: [EMAIL PROTECTED] > Subject: Re: Can't create a new thread (errno 11) > > > On Feb 23, 2004, at 10:36 AM, Sasha Pachev wrote: > > > Christof Egner wrote: > >> Hello James, > >> thanks for your answer, but max_connections is set high enough > >> (double the number of the currently used threads). I think the error > >> would be "Too many connections", wouldn't it? > > > > This error comes from LinuxThreads when pthread_create() fails for one > > reason or another. There could be several reasons - out of RAM, out of > > address space, low compiled max thread limit, library compatibility, > > or just a bug in LinuxThreads. If you are not using the official MySQL > > binary, try it. If you are, try compiling your own - sometimes the > > official binary does not quite get along with the local system > > libraries or configuration. > > > > max_connections is just a sanity limit MySQL imposes on itself, and if > > the thread library does not cooperate, it may stop allowing new > > connections before reaching it. > > > > I'm seeing this too - the db gets into a state where it can no longer > make new threads, and then mysql restart will fail, and only a reboot > will fix it. > > This is with mysql 4.0.16 on debian 2.4.20 > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
