From owner-freebsd-questions Mon Jul 1 10:18:52 2002 Delivered-To: freebsd-questions@freebsd.org Received: from mx1.FreeBSD.org (mx1.FreeBSD.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id EF80537B401 for ; Mon, 1 Jul 2002 10:18:46 -0700 (PDT) Received: from ns2.wananchi.com (ns2.wananchi.com [62.8.64.4]) by mx1.FreeBSD.org (Postfix) with ESMTP id 1DAE043E35 for ; Mon, 1 Jul 2002 10:18:42 -0700 (PDT) (envelope-from wash@wananchi.com) Received: from wash by ns2.wananchi.com with local (Exim 3.36 #1 (FreeBSD)) id 17P4nn-0008JM-00; Mon, 01 Jul 2002 20:17:27 +0300 Date: Mon, 1 Jul 2002 20:17:27 +0300 From: Odhiambo Washington To: mySQL Cc: FBSD-Q Subject: Help! MySQL overloading my system Message-ID: <20020701171727.GG74909@ns2.wananchi.com> Mail-Followup-To: Odhiambo Washington , mySQL , FBSD-Q Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.4i X-Disclaimer: Any views expressed in this message,where not explicitly attributed otherwise, are mine alone!. X-Fortune: A professor is one who talks in someone else's sleep. X-Operating-System: FreeBSD 4.5-STABLE i386 X-Best-Window-Manager: Blackbox X-Designation: Systems Administrator, Wananchi Online Ltd. X-Location: Nairobi, KE, East Africa. X-Uptime: 8:12PM up 28 days, 10:56, 4 users, load averages: 0.77, 1.22, 1.39 Sender: owner-freebsd-questions@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.ORG Alors! I run MySQL-3.23.41 on FreeBSD-4.5-STABLE but everytime I get my system slowing down and on checking with `top` I see MySQL as the culprit: last pid: 29586; load averages: 1.41, 1.45, 1.48 up 28+10:55:17 20:10:59 90 processes: 3 running, 83 sleeping, 1 stopped, 3 zombie CPU states: 16.7% user, 0.0% nice, 51.4% system, 0.4% interrupt, 31.5% idle Mem: 249M Active, 36M Inact, 71M Wired, 16M Cache, 48M Buf, 1960K Free Swap: 1374M Total, 58M Used, 1316M Free, 4% Inuse PID USERNAME PRI NICE SIZE RES STATE C TIME WCPU CPU COMMAND 28687 mysql 63 0 40604K 5940K RUN 0 27.8H 88.23% 88.23% mysqld 29489 wash 10 0 12944K 12420K nanslp 0 0:04 23.89% 11.43% perl 29424 wash 10 0 12904K 12376K nanslp 1 0:04 10.06% 6.54% perl 29382 root 30 0 2072K 1200K CPU0 0 0:02 3.50% 2.83% top 29511 exim 2 0 3692K 2240K select 1 0:01 3.84% 1.51% exim 29576 exim 2 0 3700K 2240K select 0 0:00 9.74% 0.93% exim 41215 www 18 0 41056K 24592K lockf 1 0:40 0.29% 0.29% httpd 41216 www 18 0 39980K 24316K lockf 1 0:23 0.15% 0.15% httpd 684 root 2 0 1492K 840K select 1 110:49 0.10% 0.10% tpop3d Could someone more knowledgeable point me in the right direction towards isolating what could be causing this load. I have several databases on this box, TWO of which are very busy as the SMTP/POP3 daemons both interact with it as this is the main server. Thanking you in advance. -Wash -- Odhiambo Washington "The box said 'Requires Wananchi Online Ltd. www.wananchi.com Windows 95, NT, or better,' Tel: 254 2 313985-9 Fax: 254 2 313922 so I installed FreeBSD." GSM: 254 72 743 223 GSM: 254 733 744 121 This sig is McQ! :-) Westheimer's Discovery: A couple of months in the laboratory can frequently save a couple of hours in the library. To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message