The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

My mysql load is take huge cpu 700% !!!

Discussion in 'Database Discussions' started by ahmedsss88, Jun 29, 2014.

  1. ahmedsss88

    ahmedsss88 Registered

    Joined:
    Jun 29, 2014
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Cairo, Egypt, Egypt
    cPanel Access Level:
    Root Administrator
    Hi
    i have big problem in my server
    mysql is high load its arrive to up to 700% cpu


    top - 01:00:06 up 4 days, 16:21, 1 user, load average: 1.12, 1.64, 1.94
    Tasks: 367 total, 1 running, 365 sleeping, 0 stopped, 1 zombie
    Cpu(s): 13.0%us, 3.7%sy, 0.0%ni, 83.1%id, 0.2%wa, 0.0%hi, 0.1%si, 0.0%st
    Mem: 16226852k total, 10987852k used, 5239000k free, 1415308k buffers
    Swap: 2097144k total, 14028k used, 2083116k free, 8007220k cached

    PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
    3419 mysql 20 0 4404m 263m 5872 S 117.8 1.7 26576:26 mysqld
    2942 zonanetw 20 0 15296 1508 952 R 0.7 0.0 0:01.51 top
    12202 nobody 20 0 67016 3540 1936 S 0.3 0.0 0:00.13 httpd
    18774 zonanetw 20 0 166m 7776 4804 S 0.3 0.0 0:00.08 php


    my current visitors is 200:250 in moment

    when my website is working the visitors may be 1000:3000 in moment
    can anyone help me ?
     
  2. kernow

    kernow Well-Known Member

    Joined:
    Jul 23, 2004
    Messages:
    865
    Likes Received:
    9
    Trophy Points:
    18
    cPanel Access Level:
    Root Administrator
    Login to WHM>>>>>"Show mysql processes" and see what's causing the heavy load. Also check WHM>>>>Apache status to see if there is a spike in connections, are most coming from just one IP perhaps?
    Run ( or install) "Mytop" a script like "top" for Mysql.
     
  3. ahmedsss88

    ahmedsss88 Registered

    Joined:
    Jun 29, 2014
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Cairo, Egypt, Egypt
    cPanel Access Level:
    Root Administrator

    thx
    i have checked "Show mysql processes"

    all requests time is between 0:1
    sleep is between 25:500

    my.cnf file

    [mysqld]
    innodb_file_per_table=1
    max_allowed_packet=268435456



    i think the "Apache status" is normal
     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    653
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello :)

    The following command should help you determine which databases/tables are the most active:

    Code:
    mysqladmin processlist
    You may also find this thread helpful:

    Troubleshooting High Load On Linux Servers

    Thank you.
     
Loading...

Share This Page