Date: Mon, 1 Jul 2002 14:32:01 -0400 From: "Ken Menzel" <kenm@icarz.com> To: "Odhiambo Washington" <wash@wananchi.com>, "mySQL" <mysql@lists.mysql.com> Cc: "FBSD-Q" <freebsd-questions@freebsd.org> Subject: Re: Help! MySQL overloading my system Message-ID: <057601c2212d$97cf8600$681663cf@icarz.com> References: <20020701171727.GG74909@ns2.wananchi.com>
next in thread | previous in thread | raw e-mail | index | archive | help
Hi, As a first step I would find out what mysql is doing, Use either 'show processlist' or using mysqladmin 'mysqladmin proc'. Or even better install mytop (cd /usr/ports/databases/mytop; make install; ). This program sorts the output for you. There does seem to be a sometimes bug with mysql that 'may' be related to the thread cache. If you have increased the thread cahce (which is mostly not needed) Try reducing the thread cache to 2, but make sure that it is not just a slow query causing the problem. Hope this helps, Ken ----- Original Message ----- From: "Odhiambo Washington" <wash@wananchi.com> To: "mySQL" <mysql@lists.mysql.com> Cc: "FBSD-Q" <freebsd-questions@freebsd.org> Sent: Monday, July 01, 2002 1:17 PM Subject: Help! MySQL overloading my system > > 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. > > -------------------------------------------------------------------- - > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <mysql-thread113504@lists.mysql.com> > To unsubscribe, e-mail <mysql-unsubscribe-kenm=icarz.com@lists.mysql.com> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > 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?057601c2212d$97cf8600$681663cf>