SUSE 10 Server using 80-98 % CPU

[alexsqlforums]

Hi all
I have a mysql server and all of the sudden this morning at 10AM the cpu started peaking between 80-98%.

the interface is turned off on this server with init3.

Is this a bug or something else???

THANK YOU

Here is my ps -ef output:
ps -ef
UID PID PPID C STIME TTY TIME CMD
root 1 0 0 Aug06 ? 00:00:10 init [3]
root 2 1 0 Aug06 ? 00:02:01 [migration/0]
root 3 1 0 Aug06 ? 00:00:00 [ksoftirqd/0]
root 4 1 0 Aug06 ? 00:00:13 [migration/1]
root 5 1 0 Aug06 ? 00:00:00 [ksoftirqd/1]
root 6 1 0 Aug06 ? 00:00:00 [migration/2]
root 7 1 0 Aug06 ? 00:00:00 [ksoftirqd/2]
root 8 1 0 Aug06 ? 00:00:00 [migration/3]
root 9 1 0 Aug06 ? 00:00:00 [ksoftirqd/3]
root 10 1 0 Aug06 ? 00:00:01 [migration/4]
root 11 1 0 Aug06 ? 00:00:00 [ksoftirqd/4]
root 12 1 0 Aug06 ? 00:00:00 [migration/5]
root 13 1 0 Aug06 ? 00:00:00 [ksoftirqd/5]
root 14 1 0 Aug06 ? 00:00:00 [migration/6]
root 15 1 0 Aug06 ? 00:00:00 [ksoftirqd/6]
root 16 1 0 Aug06 ? 00:00:00 [migration/7]
root 17 1 0 Aug06 ? 00:00:00 [ksoftirqd/7]
root 18 1 0 Aug06 ? 00:00:04 [migration/8]
root 19 1 0 Aug06 ? 00:00:00 [ksoftirqd/8]
root 20 1 0 Aug06 ? 00:00:01 [migration/9]
root 21 1 0 Aug06 ? 00:00:00 [ksoftirqd/9]
root 22 1 0 Aug06 ? 00:00:00 [migration/10]
root 23 1 0 Aug06 ? 00:00:00 [ksoftirqd/10]
root 24 1 0 Aug06 ? 00:00:01 [migration/11]
root 25 1 0 Aug06 ? 00:00:00 [ksoftirqd/11]
root 26 1 0 Aug06 ? 00:00:00 [migration/12]
root 27 1 0 Aug06 ? 00:00:00 [ksoftirqd/12]
root 28 1 0 Aug06 ? 00:00:00 [migration/13]
root 29 1 0 Aug06 ? 00:00:00 [ksoftirqd/13]
root 30 1 0 Aug06 ? 00:00:00 [migration/14]
root 31 1 0 Aug06 ? 00:00:00 [ksoftirqd/14]
root 32 1 0 Aug06 ? 00:00:00 [migration/15]
root 33 1 0 Aug06 ? 00:00:00 [ksoftirqd/15]
root 34 1 0 Aug06 ? 00:00:00 [events/0]
root 35 1 0 Aug06 ? 00:00:00 [events/1]
root 36 1 0 Aug06 ? 00:00:00 [events/2]
root 37 1 0 Aug06 ? 00:00:00 [events/3]
root 38 1 0 Aug06 ? 00:00:00 [events/4]
root 39 1 0 Aug06 ? 00:00:00 [events/5]
root 40 1 0 Aug06 ? 00:00:00 [events/6]
root 41 1 0 Aug06 ? 00:00:00 [events/7]
root 42 1 0 Aug06 ? 00:00:00 [events/8]
root 43 1 0 Aug06 ? 00:00:00 [events/9]
root 44 1 0 Aug06 ? 00:00:00 [events/10]
root 45 1 0 Aug06 ? 00:00:00 [events/11]
root 46 1 0 Aug06 ? 00:00:00 [events/12]
root 47 1 0 Aug06 ? 00:00:00 [events/13]
root 48 1 0 Aug06 ? 00:00:00 [events/14]
root 49 1 0 Aug06 ? 00:00:00 [events/15]
root 50 1 0 Aug06 ? 00:00:00 [khelper]
root 51 1 0 Aug06 ? 00:00:00 [kthread]
root 69 51 0 Aug06 ? 00:00:00 [kblockd/0]
root 70 51 0 Aug06 ? 00:00:02 [kblockd/1]
root 71 51 0 Aug06 ? 00:00:00 [kblockd/2]
root 72 51 0 Aug06 ? 00:00:00 [kblockd/3]
root 73 51 0 Aug06 ? 00:00:00 [kblockd/4]
root 74 51 0 Aug06 ? 00:00:05 [kblockd/5]
root 75 51 0 Aug06 ? 00:00:00 [kblockd/6]
root 76 51 0 Aug06 ? 00:00:00 [kblockd/7]
root 77 51 0 Aug06 ? 00:00:00 [kblockd/8]
root 78 51 0 Aug06 ? 00:00:04 [kblockd/9]
root 79 51 0 Aug06 ? 00:00:00 [kblockd/10]
root 80 51 0 Aug06 ? 00:00:00 [kblockd/11]
root 81 51 0 Aug06 ? 00:00:00 [kblockd/12]
root 82 51 0 Aug06 ? 00:00:03 [kblockd/13]
root 83 51 0 Aug06 ? 00:00:00 [kblockd/14]
root 84 51 0 Aug06 ? 00:00:00 [kblockd/15]
root 85 51 0 Aug06 ? 00:00:00 [kacpid]
root 429 1 0 Aug06 ? 00:00:11 [kswapd0]
root 430 51 0 Aug06 ? 00:00:00 [aio/0]
root 431 51 0 Aug06 ? 00:00:00 [aio/1]
root 432 51 0 Aug06 ? 00:00:00 [aio/2]
root 433 51 0 Aug06 ? 00:00:00 [aio/3]
root 434 51 0 Aug06 ? 00:00:00 [aio/4]
root 435 51 0 Aug06 ? 00:00:00 [aio/5]
root 436 51 0 Aug06 ? 00:00:00 [aio/6]
root 437 51 0 Aug06 ? 00:00:00 [aio/7]
root 438 51 0 Aug06 ? 00:00:00 [aio/8]
root 439 51 0 Aug06 ? 00:00:00 [aio/9]
root 440 51 0 Aug06 ? 00:00:00 [aio/10]
root 441 51 0 Aug06 ? 00:00:00 [aio/11]
root 442 51 0 Aug06 ? 00:00:00 [aio/12]
root 443 51 0 Aug06 ? 00:00:00 [aio/13]
root 444 51 0 Aug06 ? 00:00:00 [aio/14]
root 445 51 0 Aug06 ? 00:00:00 [aio/15]
root 669 51 0 Aug06 ? 00:00:00 [cqueue/0]
root 670 51 0 Aug06 ? 00:00:00 [cqueue/1]
root 671 51 0 Aug06 ? 00:00:00 [cqueue/2]
root 672 51 0 Aug06 ? 00:00:00 [cqueue/3]
root 673 51 0 Aug06 ? 00:00:00 [cqueue/4]
root 674 51 0 Aug06 ? 00:00:00 [cqueue/5]
root 675 51 0 Aug06 ? 00:00:00 [cqueue/6]
root 676 51 0 Aug06 ? 00:00:00 [cqueue/7]
root 677 51 0 Aug06 ? 00:00:00 [cqueue/8]
root 678 51 0 Aug06 ? 00:00:00 [cqueue/9]
root 679 51 0 Aug06 ? 00:00:00 [cqueue/10]
root 680 51 0 Aug06 ? 00:00:00 [cqueue/11]
root 681 51 0 Aug06 ? 00:00:00 [cqueue/12]
root 682 51 0 Aug06 ? 00:00:00 [cqueue/13]
root 683 51 0 Aug06 ? 00:00:00 [cqueue/14]
root 684 51 0 Aug06 ? 00:00:00 [cqueue/15]
root 685 51 0 Aug06 ? 00:00:00 [kseriod]
root 718 51 0 Aug06 ? 00:00:00 [kpsmoused]
root 1255 51 0 Aug06 ? 00:00:00 [scsi_eh_0]
root 1413 51 0 Aug06 ? 00:00:00 [scsi_eh_1]
root 1446 51 0 Aug06 ? 00:00:00 [scsi_eh_2]
root 1597 51 0 Aug06 ? 00:00:00 [ata/0]
root 1598 51 0 Aug06 ? 00:00:00 [ata/1]
root 1599 51 0 Aug06 ? 00:00:00 [ata/2]
root 1600 51 0 Aug06 ? 00:00:00 [ata/3]
root 1601 51 0 Aug06 ? 00:00:00 [ata/4]
root 1602 51 0 Aug06 ? 00:00:00 [ata/5]
root 1603 51 0 Aug06 ? 00:00:00 [ata/6]
root 1604 51 0 Aug06 ? 00:00:00 [ata/7]
root 1605 51 0 Aug06 ? 00:00:00 [ata/8]
root 1606 51 0 Aug06 ? 00:00:00 [ata/9]
root 1607 51 0 Aug06 ? 00:00:00 [ata/10]
root 1608 51 0 Aug06 ? 00:00:00 [ata/11]
root 1609 51 0 Aug06 ? 00:00:00 [ata/12]
root 1610 51 0 Aug06 ? 00:00:00 [ata/13]
root 1611 51 0 Aug06 ? 00:00:00 [ata/14]
root 1612 51 0 Aug06 ? 00:00:00 [ata/15]
root 1613 51 0 Aug06 ? 00:00:00 [ata_aux]
root 1714 51 0 Aug06 ? 00:00:00 [reiserfs/0]
root 1715 51 0 Aug06 ? 00:00:00 [reiserfs/1]
root 1716 51 0 Aug06 ? 00:00:00 [reiserfs/2]
root 1717 51 0 Aug06 ? 00:00:00 [reiserfs/3]
root 1718 51 0 Aug06 ? 00:00:00 [reiserfs/4]
root 1719 51 0 Aug06 ? 00:00:00 [reiserfs/5]
root 1720 51 0 Aug06 ? 00:00:00 [reiserfs/6]
root 1721 51 0 Aug06 ? 00:00:00 [reiserfs/7]
root 1722 51 0 Aug06 ? 00:00:00 [reiserfs/8]
root 1723 51 0 Aug06 ? 00:00:00 [reiserfs/9]
root 1724 51 0 Aug06 ? 00:00:00 [reiserfs/10]
root 1725 51 0 Aug06 ? 00:00:00 [reiserfs/11]
root 1726 51 0 Aug06 ? 00:00:00 [reiserfs/12]
root 1727 51 0 Aug06 ? 00:00:00 [reiserfs/13]
root 1728 51 0 Aug06 ? 00:00:00 [reiserfs/14]
root 1729 51 0 Aug06 ? 00:00:00 [reiserfs/15]
root 1791 1 0 Aug06 ? 00:00:00 /sbin/udevd --daemon
root 2705 1 0 Aug06 ? 00:00:00 [shpchpd_event]
root 2807 51 0 Aug06 ? 00:00:00 [khubd]
root 4069 1 0 Aug06 ? 00:00:00 /sbin/resmgrd
root 4079 1 0 Aug06 ? 00:00:09 /usr/sbin/irqbalance
root 4083 1 0 Aug06 ? 00:00:00 /sbin/acpid
100 4106 1 0 Aug06 ? 01:15:00 /usr/bin/dbus-daemon --system
root 4162 1 0 Aug06 ? 00:54:18 /usr/sbin/hald --daemon=yes --retain-privileges
root 4334 1 0 Aug06 ? 00:00:02 /opt/galaxy/Base/EvMgrC
root 4346 1 0 Aug06 ? 00:01:30 /opt/galaxy/Base/cvd
root 4412 4162 0 Aug06 ? 00:00:00 hald-addon-acpi
root 4492 1 0 Aug06 ? 00:00:26 /sbin/syslog-ng
root 4498 1 0 Aug06 ? 00:00:00 /sbin/klogd -c 1 -x -x
daemon 4510 1 0 Aug06 ? 00:00:05 /usr/sbin/slpd
nobody 4521 1 0 Aug06 ? 00:00:00 /sbin/portmap
root 4565 4162 0 Aug06 ? 00:19:15 hald-addon-storage
root 4567 4162 0 Aug06 ? 00:01:51 hald-addon-storage
root 4752 1 0 Aug06 ? 00:00:00 /usr/sbin/xinetd
root 4857 1 0 Aug06 ? 00:00:02 /usr/sbin/sshd -o PidFile=/var/run/sshd.init.pid
ntp 4932 1 0 Aug06 ? 00:02:47 /usr/sbin/ntpd -p /var/lib/ntp/var/run/ntp/ntpd.pid -u ntp -i /var/lib/ntp
root 4999 1 0 Aug06 ? 00:50:09 /usr/sbin/nscd
root 5173 1 0 Aug06 ? 00:00:01 /usr/sbin/powersaved -d -f /var/run/acpid.socket -v 3
root 5519 1 0 Aug06 ? 00:00:04 /usr/lib/postfix/master
postfix 5535 5519 0 Aug06 ? 00:00:04 qmgr -l -t fifo -u
root 5545 1 0 Aug06 ? 00:00:08 /usr/sbin/cron
root 5641 1 0 Aug06 ? 00:00:01 login -- root
root 5642 1 0 Aug06 tty2 00:00:00 /sbin/mingetty tty2
root 5643 1 0 Aug06 tty3 00:00:00 /sbin/mingetty tty3
root 5644 1 0 Aug06 tty4 00:00:00 /sbin/mingetty tty4
root 5645 1 0 Aug06 tty5 00:00:00 /sbin/mingetty tty5
root 5646 1 0 Aug06 tty6 00:00:00 /sbin/mingetty tty6
root 5736 51 0 Aug06 ? 00:00:00 [kauditd]
root 11244 5641 0 Aug27 tty1 00:00:00 -bash
root 11281 11244 0 Aug27 tty1 00:00:00 /bin/sh /usr/X11R6/bin/startx
root 11282 11244 0 Aug27 tty1 00:00:00 tee /root/.X.err
root 11306 11281 0 Aug27 tty1 00:00:00 /usr/X11R6/bin/xinit /usr/X11R6/lib/X11/xinit/xinitrc -- /usr/X11R6/lib/X11/xinit/xserverrc -auth /root/.serve
root 11307 11306 0 Aug27 tty7 04:22:34 X :0 -auth /root/.serverauth.11281 -nolisten tcp -nolisten tcp
root 11314 11306 0 Aug27 tty1 00:00:00 /opt/gnome/bin/gnome-session
root 11324 1 0 Aug27 tty1 00:00:00 /usr/bin/dbus-launch --sh-syntax --exit-with-session /usr/X11R6/bin/gnome
root 11325 1 0 Aug27 ? 00:00:00 dbus-daemon --fork --print-pid 8 --print-address 6 --session
root 11329 1 0 Aug27 tty1 00:00:03 /opt/gnome/lib/GConf/2/gconfd-2 4
root 11334 1 0 Aug27 tty1 00:00:00 /opt/gnome/bin/gnome-keyring-daemon
root 11336 1 0 Aug27 ? 00:00:00 /opt/gnome/lib/bonobo/bonobo-activation-server --ac-activate --ior-output-fd=17
root 11338 1 0 Aug27 ? 00:05:52 /opt/gnome/lib/control-center-2.0/gnome-settings-daemon --oaf-activate-iid=OAFIID:GNOME_SettingsDaemon --oaf-i
root 11358 1 0 Aug27 ? 00:00:25 /opt/gnome/bin/metacity --sm-client-id=default0
root 11363 1 0 Aug27 ? 00:00:03 gnome-panel --sm-client-id default1
root 11365 1 0 Aug27 ? 00:04:45 nautilus --no-default-window --sm-client-id default2
root 11367 1 0 Aug27 ? 00:00:31 zen-updater --desktop /usr/lib/zen-updater/ZenUpdater.exe --patch-view
root 11381 1 0 Aug27 ? 00:05:19 /opt/gnome/bin/application-browser -h
root 11383 1 0 Aug27 ? 01:04:42 /opt/gnome/lib/gnome-main-menu/main-menu --oaf-activate-iid=OAFIID:GNOME_MainMenu_Factory --oaf-ior-fd=29
root 11384 1 0 Aug27 ? 00:00:08 gnome-volume-manager --sm-disable
root 11386 1 0 Aug27 ? 00:31:22 /opt/gnome/lib64/gnome-applets/intlclock-applet --oaf-activate-iid=OAFIID:IntlClockApplet_Factory --oaf-ior-fd
root 11389 1 0 Aug27 ? 00:02:49 /opt/gnome/sbin/gnome-vfs-daemon --oaf-activate-iid=OAFIID:GNOME_VFS_Daemon_Factory --oaf-ior-fd=33
root 11390 1 0 Aug27 ? 15:49:17 gnome-power-manager --sm-disable
root 11533 1 0 Aug27 ? 00:00:03 gnome-screensaver
root 14105 51 0 Nov15 ? 00:00:01 [pdflush]
root 22717 51 0 Nov20 ? 00:15:14 [pdflush]
root 26071 1 0 Nov20 ? 00:28:52 /opt/mysql/enterprise/agent/lib/mysql-service-agent/mysql-service-agent -f /opt/mysql/enterprise/agent/etc/mys
root 26286 1 0 Nov20 ? 00:00:00 /bin/sh /usr/local/mysql/bin/mysqld_safe --datadir=/var/lib/mysql/data --pid-file=/var/lib/mysql/data/ezasqlp0
mysql 26324 26286 64 Nov20 ? 21-05:46:42 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/var/lib/mysql/data --user=mysql --pid-fil
postfix 3134 5519 0 11:26 ? 00:00:00 pickup -l -t fifo -u
root 4797 1 9 10:41 ? 00:09:53 zmd /usr/lib/zmd/zmd.exe --sleep 82199
root 3492 4857 0 12:23 ? 00:00:00 sshd: root@pts/0
root 3495 3492 0 12:23 pts/0 00:00:00 -bash
root 3527 3495 0 12:24 pts/0 00:00:00 ps -ef

[coopstah13]

what is the high CPU utilization process according to top?

[alexsqlforums]

It was 98.4 at one point.

it's weird everything is fine now the CPU was high for 3 hours from 10AM to 1PM.

[alexsqlforums]

I thought i was all those gnome processes but it was Mysql that was killing the box.

Thanks