Find the answer to your Linux question:
Results 1 to 4 of 4
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 ...
Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #1
    Just Joined!
    Join Date
    Oct 2007
    Posts
    16

    SUSE 10 Server using 80-98 % CPU


    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

  2. #2
    Linux Guru coopstah13's Avatar
    Join Date
    Nov 2007
    Location
    NH, USA
    Posts
    3,149
    what is the high CPU utilization process according to top?

  3. #3
    Just Joined!
    Join Date
    Oct 2007
    Posts
    16
    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.

  4. $spacer_open
    $spacer_close
  5. #4
    Just Joined!
    Join Date
    Oct 2007
    Posts
    16
    I thought i was all those gnome processes but it was Mysql that was killing the box.

    Thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •