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