Where am I wasting resources? How to fix this problem?

VeeJay maanjee at gmail.com
Tue Apr 28 08:22:36 UTC 2009


Hello guys and gurus

I am keep getting this error after a while "*1135: 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*"

Even though, I have 16GB memory and 32GB swap. But mysqlserver stops
answering. Could you please help me to fix this problem?

I am running FreeBSD on a Dell PowerEdge 2950 III having 2 x CPU 3,0 GHz
Intel Xeon L5450 Quad-Core 2x6MB cache WITH 16 GB RAM

Here is a snapshot from using top to have a overview of system resources...

last pid: 27056;  load averages:  1.05,  1.04,
1.01
up 3+16:22:44  09:01:53
3038 processes:2 running, 3036 sleeping
CPU: 12.4% user,  0.0% nice,  0.1% system,  0.0% interrupt, 87.4% idle
Mem: 6237M Active, 4005M Inact, 925M Wired, 40K Cache, 214M Buf, 4491M Free
Swap: 32G Total, 32G Free

  PID USERNAME    THR PRI NICE   SIZE    RES STATE  C   TIME   WCPU COMMAND
 3010 mysql      1500  51    0  1643M   822M ucond  2   0:01 100.00% mysqld
27030 sshUser       1  44    0 16304K  8316K CPU0   0   0:01  0.39% top
26838 sshUser       1  45    0 26448K  2464K select 5   0:22  0.20% sshd
  853 root               1  44    0   114M 19060K select 0   0:32  0.00%
httpd
  790 postfix           1   4    0  4600K  2120K kqread 2   0:12  0.00% qmgr
23542 apache        1   4    0   118M 46520K sbwait 3   0:09  0.00% httpd
23420 apache        1   4    0   118M 42340K sbwait 7   0:08  0.00% httpd
23543 apache        1   4    0   118M 51032K sbwait 2   0:08  0.00% httpd
22853 apache        1   4    0   118M 48384K sbwait 4   0:07  0.00% httpd
23768 apache        1   4    0   118M 35432K sbwait 0   0:07  0.00% httpd
23748 apache        1   4    0   118M 36560K sbwait 2   0:07  0.00% httpd
22861 apache        1   4    0   118M 48420K sbwait 2   0:07  0.00% httpd
23618 apache        1   4    0   117M 45696K sbwait 2   0:06  0.00% httpd
23222 apache        1   4    0   118M 46080K sbwait 3   0:06  0.00% httpd
23700 apache        1   4    0   118M 39572K sbwait 0   0:06  0.00% httpd
23534 apache        1   4    0   118M 43984K sbwait 0   0:06  0.00% httpd
23439 apache        1   4    0   118M 42980K sbwait 4   0:06  0.00% httpd
23480 apache        1   4    0   118M 42724K sbwait 0   0:05  0.00% httpd
  782 root               1   4    0  4604K  1552K kqread 2   0:05  0.00%
master
26843 sshUser       1  44    0 21560K  5824K select 1   0:05  0.00%
sftp-server
23066 apache        1   4    0   118M 42328K sbwait 3   0:05  0.00% httpd
23619 apache        1   4    0   118M 48012K sbwait 3   0:05  0.00% httpd
23224 apache        1   4    0   118M 46436K sbwait 3   0:05  0.00% httpd
23220 apache        1   4    0   118M 50776K sbwait 3   0:05  0.00% httpd
23176 apache        1   4    0   118M 44956K sbwait 5   0:04  0.00% httpd
23467 apache        1   4    0   118M 41692K sbwait 0   0:04  0.00% httpd
23294 apache        1   4    0   116M 45552K sbwait 0   0:04  0.00% httpd
22884 apache        1   4    0   118M 48596K sbwait 0   0:04  0.00% httpd
23214 apache        1   4    0   118M 48508K sbwait 4   0:04  0.00% httpd
23177 apache        1   4    0   118M 44844K sbwait 6   0:04  0.00% httpd
23278 apache        1   4    0   117M 44812K sbwait 5   0:04  0.00% httpd
23497 apache        1   4    0   117M 41612K sbwait 0   0:04  0.00% httpd
23477 apache        1   4    0   118M 42332K sbwait 2   0:04  0.00% httpd
23371 apache        1   4    0   118M 42176K sbwait 4   0:04  0.00% httpd
23563 apache        1   4    0   118M 45096K sbwait 2   0:04  0.00% httpd
  629 root              1  44    0  5688K  1252K select 0   0:04  0.00%
syslogd
23119 apache        1   4    0   118M 42088K sbwait 0   0:03  0.00% httpd

Any help will be appreciated....
-- 
Thanks!

BR / vj


More information about the freebsd-questions mailing list