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
fbsd.questions at rachie.is-a-geek.net
Tue Sep 23 17:46:47 UTC 2008
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
+ 1000 * (sort_buffer_size+64M+binlog_cache_size_innodb)
You don't have that much memory.
There's a similar formula for MyISAM, but can't seem to find it at the moment.
Problem with today's modular software: they start with the modules
and never get to the software part.
More information about the freebsd-questions