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]