From owner-freebsd-questions@FreeBSD.ORG Tue Apr 28 08:22:35 2009 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id BBFEE106564A for ; Tue, 28 Apr 2009 08:22:35 +0000 (UTC) (envelope-from maanjee@gmail.com) Received: from qw-out-2122.google.com (qw-out-2122.google.com [74.125.92.24]) by mx1.freebsd.org (Postfix) with ESMTP id 6B8388FC16 for ; Tue, 28 Apr 2009 08:22:35 +0000 (UTC) (envelope-from maanjee@gmail.com) Received: by qw-out-2122.google.com with SMTP id 3so317216qwe.7 for ; Tue, 28 Apr 2009 01:22:34 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:date:message-id:subject :from:to:content-type; bh=nu+klGRb85IBmaWaq4PkV4LTeAhC9IFtITPNy+FoPew=; b=AuxE66Qee5TbhJxr7AKLxjXehBn3fbPIzQgFNV/5T+2D/L1wwzRJipAmLyiacILbkc e44PkSuQOZEvZfs2t7/4ZNjT8gtwTLYHDlC3GBBCoRDWQwLj8i+1jek/SmqizE4UA3In FJ1yVT0QGsfovk24x+QAIuyQGhKSHVxPPtxJE= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:date:message-id:subject:from:to:content-type; b=RVg8FXpVVqxvym9L98CqC7KwK3chkRgmbY6/PoPI9BO7Dsi6y8WrHzxwknStduMdOQ IzAvM+UFrRRRZehMQm/aWoQ7pfAGieiBelY1v6aUOvjalWELnuCje5BKlsIzN/hlqGe8 HMCj1ddg4qPF0Fc8uevUveztWF8IVaqmwT0Qc= MIME-Version: 1.0 Received: by 10.229.94.147 with SMTP id z19mr3399115qcm.34.1240906954882; Tue, 28 Apr 2009 01:22:34 -0700 (PDT) Date: Tue, 28 Apr 2009 10:22:34 +0200 Message-ID: <2cd0a0da0904280122x5416837re97255dc37283dc5@mail.gmail.com> From: VeeJay To: FreeBSD-Questions , VeeJay Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Content-Filtered-By: Mailman/MimeDel 2.1.5 Cc: Subject: Where am I wasting resources? How to fix this problem? X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 28 Apr 2009 08:22:36 -0000 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