MySQL Error: Can't create a new thread (errno 35); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug

[Mel]

On Tuesday 23 September 2008 12:13:58 Sam Nilsson wrote:

> DB Servers: One Master, Two Read Only (replication)
>    4 GB of Memory on each server
>    FreeBSD 6.3-RELEASE-p3 FreeBSD 6.3-RELEASE-p3
>    MySQL 5.0.1

> Here are some relevent items from my.cnf:
>   - set-variable = max_connections=1000
>   - set-variable = key_buffer_size=384M
>   - set-variable = read_buffer_size=64M
>   - set-variable = read_rnd_buffer_size=32M
>   - set-variable = thread_cache_size=20

You're shooting yourself in the foot:
1000*2MB=2G for thread stack
+ 384M
+ 1000 * (sort_buffer_size+64M+binlog_cache_size_innodb)

You don't have that much memory.
http://dev.mysql.com/doc/refman/5.0/en/innodb-configuration.html

There's a similar formula for MyISAM, but can't seem to find it at the moment.


-- 
Mel

Problem with today's modular software: they start with the modules
    and never get to the software part.