Set this in you're my.cnf and restart and see if that solves your problem. open-files-limit=36864
*** Don't ask me what that number is, it's just a random number. Donny > -----Original Message----- > From: Ken Menzel [mailto:[EMAIL PROTECTED] > Sent: Monday, February 23, 2004 10:20 AM > To: Christof Egner > Cc: [EMAIL PROTECTED] > Subject: Re: Can't create a new thread (errno 11) > > Hi Christof, > You don't mention the OS version you are using (So I will assume > Linux) is there a sysctl for the max number of threads on your OS? > Ken > ----- Original Message ----- > From: "Christof Egner" <[EMAIL PROTECTED]> > To: "James Kelty" <[EMAIL PROTECTED]> > Cc: <[EMAIL PROTECTED]> > Sent: Saturday, February 21, 2004 5:18 AM > Subject: Re: Can't create a new thread (errno 11) > > > > 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? > > > > -Christof > > > > James Kelty wrote: > > > Check the max_connections variable > > > > > > > > > Mysql> show variables liks '%connection%'; > > > > > > -James > > > > > > -----Original Message----- > > > From: Christof Egner [mailto:[EMAIL PROTECTED] > > > Sent: Friday, February 20, 2004 9:03 AM > > > To: [EMAIL PROTECTED] > > > Subject: Can't create a new thread (errno 11) > > > > > > Hello, > > > > > > I'm having problems with a 4.0.18 MySQL Server. Since this > afternoon I > > > get the error "Can't create a new thread (errno 11)" when MySQL > has > > > forked about 200-300 threads. > > > > > > What does it mean? I'm not running out of RAM or disk space. > > > > > > Best Regards, > > > Christof > > > > > > > > > > > > > > > -- > > _______________________________________________________________ > > Configo Systems GmbH - Jahnstr. 62 - 64285 Darmstadt - DE > > Tel +49.6151.39656.0 Fax .49 http://www.configo.de > > > > > > -- > > 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] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
