Date: Tue, 23 Sep 2008 19:46:44 +0200 From: Mel <fbsd.questions@rachie.is-a-geek.net> To: freebsd-questions@freebsd.org Cc: Sam Nilsson <lists@servingpeace.com> Subject: Re: 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 Message-ID: <200809231946.45454.fbsd.questions@rachie.is-a-geek.net> In-Reply-To: <48D8C166.1020601@servingpeace.com> References: <48D8C166.1020601@servingpeace.com>
next in thread | previous in thread | raw e-mail | index | archive | help
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.
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?200809231946.45454.fbsd.questions>