From owner-freebsd-questions@FreeBSD.ORG Thu Apr 30 19:02:41 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 258F2106566B for ; Thu, 30 Apr 2009 19:02:41 +0000 (UTC) (envelope-from maanjee@gmail.com) Received: from mail-qy0-f105.google.com (mail-qy0-f105.google.com [209.85.221.105]) by mx1.freebsd.org (Postfix) with ESMTP id CEB788FC15 for ; Thu, 30 Apr 2009 19:02:40 +0000 (UTC) (envelope-from maanjee@gmail.com) Received: by qyk3 with SMTP id 3so4057284qyk.3 for ; Thu, 30 Apr 2009 12:02:40 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :date:message-id:subject:from:to:cc:content-type; bh=t10BGz0k3i1dgeSjx15Cx8KLX+mPSf4qG4UwE2a5rzI=; b=XL9DokzOI/a0GIAEo6Gxvai/hrnVC3vjgyKkQ9iORXK511cTUoVW+Oht6QNP6V6bcw xImmrU/X6aWI//g1RID3/cYWYG7XMtx0Gzx3smT1zm+NoMgy6vBsq3D47fmhr3g9aYJm uJjUsXRsERv+2+ISUrpNZLobqCvtli1SYPZDU= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type; b=l53Zxpnx+6KtkmEScbHclYjY01feu0Tq/8tzgtkidPdXSP+16N7Phf2K6+e10YpWaX 4NLxpy469W9OMai1Tv4nXbwe97LUo790vkKJ8UWIs6628jaJcX6NsxAv62O56LyeU+jW 4MPg51N6/VW9nmWF5B0qx97rVogIcCg3US1yc= MIME-Version: 1.0 Received: by 10.229.85.132 with SMTP id o4mr1683293qcl.0.1241118158800; Thu, 30 Apr 2009 12:02:38 -0700 (PDT) In-Reply-To: <2cd0a0da0904280640r12f0028fq9beb49ee0dce5fc7@mail.gmail.com> References: <2cd0a0da0904280122x5416837re97255dc37283dc5@mail.gmail.com> <49F6E261.6040808@aboutsupport.com> <2cd0a0da0904280521u125b4180s4e626670b67b73d5@mail.gmail.com> <200904281519.12945.mel.flynn+fbsd.questions@mailing.thruhere.net> <2cd0a0da0904280640r12f0028fq9beb49ee0dce5fc7@mail.gmail.com> Date: Thu, 30 Apr 2009 21:02:38 +0200 Message-ID: <2cd0a0da0904301202n1edaea1du5bba7e8b34266d70@mail.gmail.com> From: VeeJay To: Mel Flynn Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Content-Filtered-By: Mailman/MimeDel 2.1.5 Cc: Peter , freebsd-questions@freebsd.org Subject: Re: 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: Thu, 30 Apr 2009 19:02:41 -0000 Hi Mel I tried your suggestions by giving values vm.kmem_size_max="1024M" vm.kmem_size="1024M" but still got mysql hung.... without any luck.... here is the top output: even though there is plenty of free memory.... Guys, I am not very good on freebsd, its you guys who help me to keeping my server up... I hope you can spare a few minutes to sort this problem... last pid: 19656; load averages: 1.00, 1.00, 1.00 up 2+05:00:12 19:18:47 3049 processes:2 running, 3047 sleeping CPU: 12.5% user, 0.0% nice, 0.1% system, 0.0% interrupt, 87.4% idle Mem: 6253M Active, 3810M Inact, 921M Wired, 128K Cache, 214M Buf, 4683M Free Swap: 32G Total, 32G Free PID USERNAME THR PRI NICE SIZE RES STATE C TIME WCPU COMMAND 830 mysql 1500 44 0 1670M 813M ucond 1 0:00 100.00% mysqld 19649 sshUser 1 44 0 16304K 8340K CPU1 1 0:00 0.39% top 18277 sshUser 1 44 0 26448K 2756K select 0 0:28 0.00% sshd 841 root 1 44 0 115M 17132K select 0 0:24 0.00% httpd 790 postfix 1 4 0 4600K 1972K kqread 1 0:07 0.00% qmgr 14353 apache 1 4 0 117M 50896K sbwait 0 0:05 0.00% httpd 17564 apache 1 4 0 119M 16084K sbwait 0 0:05 0.00% httpd 18320 sshUser 1 44 0 21560K 5920K select 1 0:04 0.00% sftp-server 14395 apache 1 4 0 117M 51684K sbwait 0 0:04 0.00% httpd 782 root 1 4 0 4604K 1548K kqread 5 0:04 0.00% master 14456 apache 1 4 0 120M 52440K sbwait 0 0:03 0.00% httpd 629 root 1 44 0 5688K 1252K select 2 0:02 0.00% syslogd 18687 apache 1 4 0 116M 21528K sbwait 1 0:02 0.00% httpd 17759 apache 1 4 0 118M 15852K sbwait 3 0:02 0.00% httpd 17561 apache 1 4 0 117M 19368K sbwait 5 0:02 0.00% httpd 14609 apache 1 4 0 116M 50696K sbwait 2 0:02 0.00% httpd 14623 apache 1 4 0 117M 46444K sbwait 0 0:02 0.00% httpd 17599 apache 1 4 0 118M 14884K sbwait 1 0:02 0.00% httpd 16262 apache 1 4 0 119M 37000K sbwait 5 0:02 0.00% httpd 15176 apache 1 4 0 119M 32660K sbwait 3 0:01 0.00% httpd 16147 apache 1 4 0 118M 37540K sbwait 3 0:01 0.00% httpd 14624 apache 1 4 0 118M 45248K sbwait 2 0:01 0.00% httpd 18696 apache 1 4 0 116M 13544K sbwait 3 0:01 0.00% httpd 15694 apache 1 4 0 118M 31304K sbwait 2 0:01 0.00% httpd 17442 apache 1 4 0 118M 17872K sbwait 5 0:01 0.00% httpd 14621 apache 1 4 0 117M 45496K sbwait 4 0:01 0.00% httpd 17412 apache 1 4 0 118M 21500K sbwait 0 0:01 0.00% httpd 17504 apache 1 4 0 118M 16052K sbwait 0 0:01 0.00% httpd 14626 apache 1 4 0 118M 50984K sbwait 0 0:01 0.00% httpd 17448 apache 1 4 0 119M 19772K sbwait 5 0:01 0.00% httpd 12204 apache 1 4 0 116M 43588K sbwait 4 0:01 0.00% httpd 17560 apache 1 4 0 118M 15300K sbwait 0 0:01 0.00% httpd 17729 apache 1 4 0 119M 19828K sbwait 3 0:01 0.00% httpd 18017 apache 1 4 0 119M 17808K sbwait 3 0:01 0.00% httpd 16802 apache 1 4 0 118M 37124K sbwait 4 0:01 0.00% httpd 15640 apache 1 4 0 118M 31864K sbwait 4 0:01 0.00% httpd 18411 apache 1 4 0 119M 15084K sbwait 0 0:01 0.00% httpd -- Thanks! BR / vj