Date: Mon, 1 Jul 2002 20:17:27 +0300 From: Odhiambo Washington <wash@wananchi.com> To: mySQL <mysql@lists.mysql.com> Cc: FBSD-Q <freebsd-questions@freebsd.org> Subject: Help! MySQL overloading my system Message-ID: <20020701171727.GG74909@ns2.wananchi.com>
next in thread | raw e-mail | index | archive | help
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: <cut> 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 <wash@wananchi.com> "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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20020701171727.GG74909>