MySql process gone crazy
top shows
FreeBSD 5.1-RELEASE (GENERIC) #0: Thu Jun 5 02:55:42 GMT 2003
Welcome to FreeBSD!
last pid: 19342; load averages: 1.00, 1.00, 1.00 up 32+01:11:11 20:47:24
46 processes: 2 running, 44 sleeping
CPU states: 22.2% user, 0.0% nice, 77.8% system, 0.0% interrupt, 0.0% idle
Mem: 181M Active, 343M Inact, 372M Wired, 47M Cache, 111M Buf, 48M Free
Swap: 2011M Total, 2011M Free
PID USERNAME PRI NICE SIZE RES STATE TIME WCPU CPU COMMAND
78183 mysql 125 0 53192K 21140K RUN 21.1H 99.02% 99.02% mysqld
56774 mailnull 8 0 4744K 3992K nanslp 1:39 0.00% 0.00% perl
26220 bind 96 0 3940K 3260K select 1:35 0.00% 0.00% named
39532 root 8 0 2280K 1644K nanslp 1:10 0.00% 0.00% perl
56796 cpanel 96 0 6856K 2720K select 0:19 0.00% 0.00% stunnel-4.04l
409 root 8 0 1304K 888K nanslp 0:18 0.00% 0.00% cron
74616 root 96 0 2180K 1456K select 0:18 0.00% 0.00% proftpd
225 root 96 0 1272K 776K select 0:10 0.00% 0.00% syslogd
97367 root 8 20 25736K 23484K nanslp 0:06 0.00% 0.00% perl
53134 root 96 0 8084K 5028K select 0:05 0.00% 0.00% httpd
56766 root 4 0 3828K 2436K accept 0:04 0.00% 0.00% webmaild
359 root 96 0 3432K 1880K select 0:04 0.00% 0.00% sshd
91136 root 4 0 4740K 3028K accept 0:04 0.00% 0.00% cpaneld
39669 root 4 0 4684K 2944K accept 0:03 0.00% 0.00% cppop
39527 mailnull 96 0 5216K 1924K select 0:03 0.00% 0.00% exim-4.24-4
53141 nobody 20 0 15784K 13088K lockf 0:03 0.00% 0.00% httpd
and;
$ ps -aux shows
USER PID %CPU %MEM VSZ RSS TT STAT STARTED TIME COMMAND
mysql 78183 99.0 2.0 53192 21140 ?? R Sun09AM 1264:44.24 /usr/local/lib
e
root 10 0.0 0.0 0 12 ?? DL 21Nov03 0:00.00 (ktrace)
root 1 0.0 0.0 740 240 ?? ILs 21Nov03 0:01.55 /sbin/init --
root 11 0.0 0.0 0 12 ?? RL 21Nov03 25350:58.18 (idle)
root 12 0.0 0.0 0 12 ?? WL 21Nov03 1:08.03 (swi1: net)
root 13 0.0 0.0 0 12 ?? WL 21Nov03 14:31.16 (swi7: tty
ioroot 2 0.0 0.0 0 12 ?? DL 21Nov03 0:55.79 (g_event)
root 3 0.0 0.0 0 12 ?? DL 21Nov03 1:04.94 (g_up)
root 4 0.0 0.0 0 12 ?? DL 21Nov03 1:17.82 (g_down)
root 15 0.0 0.0 0 12 ?? DL 21Nov03 1:05.43 (random)
root 16 0.0 0.0 0 12 ?? WL 21Nov03 0:00.00 (swi6: acpitas
root 5 0.0 0.0 0 12 ?? IL 21Nov03 0:00.00 (acpi_task0)
root 6 0.0 0.0 0 12 ?? IL 21Nov03 0:00.00 (acpi_task1)
root 7 0.0 0.0 0 12 ?? IL 21Nov03 0:00.00 (acpi_task2)
root 23 0.0 0.0 0 12 ?? DL 21Nov03 1:30.93 (acpi_thermal)
root 24 0.0 0.0 0 12 ?? WL 21Nov03 2:35.59 (irq11: rl0)
root 25 0.0 0.0 0 12 ?? WL 21Nov03 1:17.00 (irq14: ata0)
root 26 0.0 0.0 0 12 ?? WL 21Nov03 0:00.16 (irq15: ata1)
root 8 0.0 0.0 0 12 ?? DL 21Nov03 0:01.86 (pagedaemon)
root 9 0.0 0.0 0 12 ?? DL 21Nov03 0:00.00 (vmdaemon)
root 31 0.0 0.0 0 12 ?? RL 21Nov03 1:15.15 (pagezero)
root 32 0.0 0.0 0 12 ?? DL 21Nov03 1:27.25 (bufdaemon)
root 33 0.0 0.0 0 12 ?? DL 21Nov03 34:19.13 (syncer)
root 34 0.0 0.0 0 12 ?? DL 21Nov03 0:07.51 (vnlru)
root 35 0.0 0.0 0 12 ?? IL 21Nov03 0:00.00 (nfsiod 0)
root 36 0.0 0.0 0 12 ?? IL 21Nov03 0:00.00 (nfsiod 1)
root 37 0.0 0.0 0 12 ?? IL 21Nov03 0:00.00 (nfsiod 2)
root 38 0.0 0.0 0 12 ?? IL 21Nov03 0:00.00 (nfsiod 3)
root 121 0.0 0.0 228 80 ?? Is 21Nov03 0:00.00 adjkerntz -i
root 225 0.0 0.1 1272 776 ?? Ss 21Nov03 0:09.90 /usr/sbin/syslo
root 359 0.0 0.2 3432 1880 ?? Is 21Nov03 0:03.92 /usr/sbin/sshd
root 409 0.0 0.1 1304 888 ?? Is 21Nov03 0:18.42 /usr/sbin/cron
root 445 0.0 0.1 1236 792 v0 Is+ 21Nov03 0:00.00 /usr/libexec/ge
root 446 0.0 0.1 1236 792 v1 Is+ 21Nov03 0:00.00 /usr/libexec/ge
root 447 0.0 0.1 1236 792 v2 Is+ 21Nov03 0:00.00 /usr/libexec/ge
root 448 0.0 0.1 1236 792 v3 Is+ 21Nov03 0:00.00 /usr/libexec/ge
root 449 0.0 0.1 1236 792 v4 Is+ 21Nov03 0:00.00 /usr/libexec/ge
root 450 0.0 0.1 1236 792 v5 Is+ 21Nov03 0:00.00 /usr/libexec/ge
root 451 0.0 0.1 1236 792 v6 Is+ 21Nov03 0:00.00 /usr/libexec/ge
root 452 0.0 0.1 1236 792 v7 Is+ 21Nov03 0:00.00 /usr/libexec/ge
root 56766 0.0 0.2 3828 2436 p0- I 21Nov03 0:04.02 /usr/local/cpan
mailnull 56774 0.0 0.4 4744 3992 p0- S 21Nov03 1:39.11 /usr/bin/perl /
root 56777 0.0 0.3 4228 2676 p0- I 21Nov03 0:02.01 /usr/local/cpan
cpanel 56796 0.0 0.3 6856 2720 ?? Ss 21Nov03 0:19.31 /usr/bin/stunne
nobody 56798 0.0 0.1 1132 616 p0- I 21Nov03 0:00.00 /usr/local/cpan
nobody 56800 0.0 0.2 2768 2184 p0- I 21Nov03 0:00.00 entropychat (pe
root 56871 0.0 0.1 1376 944 ?? Is 21Nov03 0:01.67 /usr/sbin/inetd
root 65058 0.0 1.7 18372 17688 ?? Is 22Nov03 0:00.91 /usr/bin/spamd
nobody 74616 0.0 0.1 2180 1456 ?? Ss 22Nov03 0:17.53 proftpd: (accep
root 91136 0.0 0.3 4740 3028 ?? I 23Nov03 0:03.59 /usr/local/cpan
mailnull 39527 0.0 0.2 5216 1924 ?? Is 2Dec03 0:02.84 /usr/sbin/sendm
mailnull 39530 0.0 0.2 5216 1808 ?? Is 2Dec03 0:00.00 /usr/sbin/sendm
root 39532 0.0 0.2 2280 1644 ?? S 2Dec03 1:09.97 antirelayd (per
root 39669 0.0 0.3 4684 2944 ?? I 2Dec03 0:03.13 /usr/local/cpan
bind 26220 0.0 0.3 3940 3260 ?? Ss 7Dec03 1:35.18 /usr/sbin/named
root 54383 0.0 0.0 912 516 ?? I 15Dec03 0:00.01 /bin/sh /usr/lo
root 97367 0.0 2.3 25736 23484 p1- IN Wed10PM 0:06.19 cpanellogd - sl
root 53134 0.0 0.5 8084 5028 ?? Ss Sat12AM 0:05.35 /usr/local/apac
nobody 53140 0.0 1.4 16880 14180 ?? I Sat12AM 0:02.20 /usr/local/apac
nobody 53141 0.0 1.3 15784 13088 ?? I Sat12AM 0:02.84 /usr/local/apac
nobody 53142 0.0 1.2 14848 12120 ?? I Sat12AM 0:01.94 /usr/local/apac
nobody 53143 0.0 1.4 16852 14064 ?? I Sat12AM 0:01.86 /usr/local/apac
nobody 53144 0.0 1.2 14952 12232 ?? I Sat12AM 0:01.73 /usr/local/apac
nobody 53145 0.0 1.4 16776 14056 ?? I Sat12AM 0:02.18 /usr/local/apac
nobody 53148 0.0 1.4 16840 14140 ?? I Sat12AM 0:02.23 /usr/local/apac
nobody 53149 0.0 1.3 15840 13124 ?? I Sat12AM 0:02.39 /usr/local/apac
nobody 53150 0.0 1.4 16816 14112 ?? I Sat12AM 0:02.51 /usr/local/apac
nobody 53154 0.0 1.2 14948 12236 ?? I Sat12AM 0:01.90 /usr/local/apac
root 9427 0.0 0.3 3436 2844 ?? I 6:14AM 0:01.72 chkservd (perl)
root 0 0.0 0.0 0 4 ?? DLs 21Nov03 0:02.26 (swapper)
$ last pid: 19342; load averages: 1.00, 1.00, 1.00 up 32+01:11:11 20:47:24
WHM Process Manager shows:]
Process /usr/local/libexec/mysqld--basedir=/usr/local--datadir=/var/db/mysql--user=mysql--pid-file=/var/db/mysql/ca001.pid
Owner mysql
PID 78183
CPU % 97.56%
MEM % 4
Any suggestions?
