mysqld: cpu overloaded

Discussion in 'Server Operation' started by rizwan65, Jun 7, 2011.

  1. rizwan65

    rizwan65 New Member

    Hi bros
    I have a VPS 512mb (Burst 2GB) hosting few sites on it with not much traffic

    I am facing high cpu load for the last few days and seems mysqld is overloading the cpu

    Any suggestion will be appreciated
    Regards
    Rizwan

    Sorry MODs I have submitted in wrong section please move to appropriate section

    Top output is as under

    top - 18:44:04 up 6 days, 12:19, 0 users, load average: 9.81, 8.44, 5.50
    Tasks: 42 total, 2 running, 40 sleeping, 0 stopped, 0 zombie
    Cpu(s): 32.0%us, 55.8%sy, 0.0%ni, 12.2%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
    Mem: 2097152k total, 496708k used, 1600444k free, 0k buffers
    Swap: 0k total, 0k used, 0k free, 0k cached

    PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
    25665 mysql 15 0 148m 41m 6904 S 215.2 2.0 29:22:14 mysqld
    19929 apache 16 0 60792 30m 5104 S 6.6 1.5 0:07.50 httpd
    1458 apache 15 0 59700 28m 4660 S 0.3 1.4 0:03.24 httpd
    2044 apache 15 0 50920 19m 4100 S 0.3 0.9 0:01.31 httpd
    1 root 15 0 2156 656 568 S 0.0 0.0 0:00.96 init
    1987 apache 15 0 50920 19m 4100 S 0.0 0.9 0:00.91 httpd
    2043 apache 16 0 50920 19m 4100 S 0.0 0.9 0:01.32 httpd
    3155 apache 15 0 51200 19m 4412 S 0.0 1.0 0:00.64 httpd
    3156 apache 16 0 50920 19m 4100 S 0.0 0.9 0:01.11 httpd
    3646 apache 16 0 59196 28m 4908 S 0.0 1.4 0:03.81 httpd
    5218 clamav 16 0 15388 1616 1012 S 0.0 0.1 0:00.31 freshclam
    5981 lxpopuse 16 0 36408 31m 2484 S 0.0 1.6 0:03.21 spamd
    7697 lxpopuse 15 0 39256 34m 2516 S 0.0 1.7 0:20.55 spamd
    9484 apache 15 0 60560 29m 4968 S 0.0 1.5 0:04.14 httpd
    13480 named 21 0 91508 4112 2044 S 0.0 0.2 0:13.39 named
    17476 root 15 0 7188 1064 660 S 0.0 0.1 0:01.38 sshd
    17492 root 15 0 2832 896 724 S 0.0 0.0 0:01.64 xinetd
    21733 root 15 0 33856 29m 2416 S 0.0 1.4 0:07.96 spamd
    21848 lxlabs 15 0 5580 932 500 S 0.0 0.0 0:00.20 kloxo.httpd
    22441 root 15 0 26448 14m 4172 S 0.0 0.7 0:01.01 php
    22462 root 15 0 11212 348 224 R 0.0 0.0 0:00.00 vzctl
    22466 root 16 0 3708 1460 1236 S 0.0 0.1 0:00.01 bash
    23643 root 15 0 49016 20m 7376 S 0.0 1.0 0:02.51 httpd
    24010 root 15 0 2288 1016 816 R 0.0 0.0 0:00.00 top
     
    Last edited: Jun 7, 2011
  2. till

    till Super Moderator Staff Member ISPConfig Developer

  3. rizwan65

    rizwan65 New Member

    till thanks for your reply
    Actually I started happening suddenly, it was running fine past

    I have checked the processes and found one process in the state of (Copying to tmp table) of a script creating cpu load

    1694 | db_user | localhost | db_name | Query | 1 | Copying to tmp table | SELECT tv.vid FROM `tag_video` AS tv, `tags` AS t WHERE tv.tag

    These processes keep on increasing from 1 to 5 or more and cpu goes to above 200
     

Share This Page