From owner-freebsd-questions@FreeBSD.ORG Thu Apr 30 19:52:52 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 C7E38106564A for ; Thu, 30 Apr 2009 19:52:52 +0000 (UTC) (envelope-from cswiger@mac.com) Received: from mail-out4.apple.com (mail-out4.apple.com [17.254.13.23]) by mx1.freebsd.org (Postfix) with ESMTP id A8EE78FC22 for ; Thu, 30 Apr 2009 19:52:52 +0000 (UTC) (envelope-from cswiger@mac.com) Received: from relay11.apple.com (relay11.apple.com [17.128.113.48]) by mail-out4.apple.com (Postfix) with ESMTP id 9159C620E2DA; Thu, 30 Apr 2009 12:52:52 -0700 (PDT) Received: from relay11.apple.com (unknown [127.0.0.1]) by relay11.apple.com (Symantec Brightmail Gateway) with ESMTP id 777DD2809D; Thu, 30 Apr 2009 12:52:52 -0700 (PDT) X-AuditID: 11807130-9f1b4bb000000d47-7e-49fa0194b947 Received: from cswiger1.apple.com (cswiger1.apple.com [17.227.140.124]) (using TLSv1 with cipher AES128-SHA (128/128 bits)) (No client certificate requested) by relay11.apple.com (Apple SCV relay) with ESMTP id 6358328097; Thu, 30 Apr 2009 12:52:52 -0700 (PDT) Message-Id: From: Chuck Swiger To: VeeJay In-Reply-To: <2cd0a0da0904301202n1edaea1du5bba7e8b34266d70@mail.gmail.com> Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes Content-Transfer-Encoding: 7bit Mime-Version: 1.0 (Apple Message framework v930.3) Date: Thu, 30 Apr 2009 12:49:13 -0700 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> <2cd0a0da0904301202n1edaea1du5bba7e8b34266d70@mail.gmail.com> X-Mailer: Apple Mail (2.930.3) X-Brightmail-Tracker: AAAAAA== Cc: FreeBSD - 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:52:53 -0000 Hi, VeeJay-- On Apr 30, 2009, at 12:02 PM, VeeJay wrote: > 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 It sure looks like you're running into a system limit with the maximum # of threads available to the mysql process. That's likely to be a consequence of some kind of query deadlock which is causing processes to get stuck and not be able to complete their work, resulting in subsequent requests also blocking until MySQL is no longer able to support more connection requests. There isn't enough information about what you're doing to really go much further-- something as simple as using MyISAM with full table- level locking versus InnoDB with row-level locking could be the problem, or you might have to take a closer look at the workload and outstanding queries. Regards, -- -Chuck