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

Sam Nilsson wrote:
Hello,

The error message: 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

Our website started getting this error several weeks ago (when we
increased the number of application server machines connecting to the
database from 5 to 7. It seems to happen anywhere from every 2 days
to once a week, there does not seem to be a consistent pattern. Our
CPU utilization, memory utilization, and number of HTTP Requests seem
to be at "normal" (they are no where closed to being maxed out). When
this error happens we CAN log onto the server with the MySQL database,
but I CAN NOT use the mysql client to connect to the mysql database
(localhost connection as root) - it reports the error mentioned
above. The way we temporarily solve the problem is to restart one of
our web servers.

Here is our technology stack:

Web Servers: 7, Each server has:
4 Gb of Memory on each server
FreeBSD 6.2-RELEASE-p9
2.4 GHz CPU
Apache 2.2
Webware for Python
Python 2.5

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


We have tried bumping up our number of max allowed connections (up to
1000) on MySQL and kern.ssize to 512Mb for FreeBSD. That did not
help. The max connections usually hovers ~300, so it does not even
get close to the 1000 we have set. Finally the last place that we
have looked is the openfiles, it is set at 20,000 for the whole
system, with 14K per process on the FreeBSD operating system.


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

Any help would be much appreciated.

Thanks
- Sam Nilsson

If you havent already, you could try increasing the per process memory
limit as per examples in
http://unix.derkeiler.com/Mailing-Lists/FreeBSD/hackers/2008-05/msg00258.html
(man tuning also says a bit about these tuneables but doesnt have the
examples that post does)


Vince

_______________________________________________
freebsd-questions@xxxxxxxxxxx mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to
"freebsd-questions-unsubscribe@xxxxxxxxxxx"

_______________________________________________
freebsd-questions@xxxxxxxxxxx mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to "freebsd-questions-unsubscribe@xxxxxxxxxxx"

Relevant Pages

  • Re: Reducing load for LAMP app?
    ... MySQL: as much as possible, he keeps query results in RAM, but ... His hoster says that Apache server is under significant load. ... Using apc is pretty much transparent, but memcached will require modifying your database abstraction layer using the memcached functions. ... With persistent connections, you must have the maximum number of connections *ever* required allocated *all of the time* - even if no one is using your server. ...
    (comp.lang.php)
  • Re: Experiences with mysql_pconnect?
    ... talk to a MySQL 5.0.45 DB on an Apache 1.3 series server. ... dangling connections to the server at the php.net site. ... especially when the server is remote as it requires multiple calls to MySQL. ... queries that you execute on a regular basis, preparing it and then ...
    (comp.lang.php)
  • Re: SQL Timeout problem
    ... the amount of buffer pool memory allocated to SQL Server ... and the amount of freely usable MEM TO LEAVE memory to use for connections. ... > The results for the "BlkBy" spid is the same. ...
    (microsoft.public.sqlserver.server)
  • Re: Experiences with mysql_pconnect?
    ... talk to a MySQL 5.0.45 DB on an Apache 1.3 series server. ... dangling connections to the server at the php.net site. ... > Using prepared statements will probably speed up your app a lot. ... especially when the server is remote as it requires multiple calls to MySQL. ...
    (comp.lang.php)
  • RE: 2008 Terminal server stops accepting connections and is solved
    ... Memory was added on the ... did you update anything on the terminal server? ... Can you keep a session open for yourself until the next problem occurrs - ... its caused by incoming connections. ...
    (microsoft.public.windows.terminal_services)
Quantcast