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 <[EMAIL PROTECTED]> "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 <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
