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.

Server load 287.87 (8 CPUs)

Discussion in 'General Discussion' started by bt4, Nov 19, 2011.

  1. bt4

    bt4 Well-Known Member

    Joined:
    Jul 1, 2010
    Messages:
    69
    Likes Received:
    0
    Trophy Points:
    6
    Server load 287.87 (8 CPUs)

    Server is very slow
    i don't know its about daily, weekly, monthly, backup or what?

    if yes how i can force stop this backup
     
  2. nightman

    nightman Member

    Joined:
    Aug 3, 2008
    Messages:
    17
    Likes Received:
    0
    Trophy Points:
    1
    if you don't mind, post the TOP output here.
     
  3. bt4

    bt4 Well-Known Member

    Joined:
    Jul 1, 2010
    Messages:
    69
    Likes Received:
    0
    Trophy Points:
    6
    any help!!!!!
     
  4. nightman

    nightman Member

    Joined:
    Aug 3, 2008
    Messages:
    17
    Likes Received:
    0
    Trophy Points:
    1
    have you checked your TOP output? what it says?
     
  5. bt4

    bt4 Well-Known Member

    Joined:
    Jul 1, 2010
    Messages:
    69
    Likes Received:
    0
    Trophy Points:
    6
    what is urmean top output?
    how i can check
     
  6. nightman

    nightman Member

    Joined:
    Aug 3, 2008
    Messages:
    17
    Likes Received:
    0
    Trophy Points:
    1
    if you have ssh access to your server run following command

    top

    then you will see the process list.

    press ctrl+C to terminate the top.
     
  7. bt4

    bt4 Well-Known Member

    Joined:
    Jul 1, 2010
    Messages:
    69
    Likes Received:
    0
    Trophy Points:
    6
    14840 mysql 20 0 4210m 124m 5404 S 771.7 3.2 410:03.47 mysqld
    24726 ybak 20 0 198m 12m 7016 S 8.0 0.3 0:00.57 lsphp5
    24741 nar44 20 0 107m 15m 6276 D 5.3 0.4 0:00.16 lsphp5
    24739 uarr104 20 0 198m 12m 6664 S 4.6 0.3 0:00.14 lsphp5
    24734 uar87 20 0 103m 11m 6476 S 4.3 0.3 0:00.24 lsphp5
    24724 ssshb 20 0 103m 11m 6592 S 1.7 0.3 0:00.21 lsphp5
    24742 magic4ku 20 0 102m 9452 5120 R 1.3 0.2 0:00.04 lsphp5
    24054 nobody 1 -19 37884 13m 524 S 0.7 0.3 0:01.10 litespeed
    24556 root 20 0 14932 1328 952 R 0.7 0.0 0:00.21 top
    1 root 20 0 19112 1124 872 S 0.0 0.0 0:03.22 init
     
  8. nightman

    nightman Member

    Joined:
    Aug 3, 2008
    Messages:
    17
    Likes Received:
    0
    Trophy Points:
    1
    You have mysql is using most of your resources, then there are lightspeed also using some.

    login to your mysql server using your admin username and password, then type > show processlist;

    it will show which mysql command take most of the resources.
     
  9. bt4

    bt4 Well-Known Member

    Joined:
    Jul 1, 2010
    Messages:
    69
    Likes Received:
    0
    Trophy Points:
    6
    its some host i find it!
    but how i can to know what this host use for make this load to mysqlserver
     
  10. nightman

    nightman Member

    Joined:
    Aug 3, 2008
    Messages:
    17
    Likes Received:
    0
    Trophy Points:
    1
    what you mean by some host? have you given access to your mysql server external sites? in your process list, you can see what are they doing.
     
  11. bt4

    bt4 Well-Known Member

    Joined:
    Jul 1, 2010
    Messages:
    69
    Likes Received:
    0
    Trophy Points:
    6
    ----+
    | Id | User | Host | db | Command | Time | State | Info |
    +------+-----------------+-----------+-----------------+---------+------+----------------+----------------------------------------------------------------------------------+
    | 16 | member22_soft | localhost | member22_soft | Query | 1419 | Sorting result | SELECT * FROM userstats WHERE userip='66.102.12.94' ORDER BY date DESC LIMIT 1

    i dont want suspend this host!

    have any way to finish this load to mysql
     
  12. nightman

    nightman Member

    Joined:
    Aug 3, 2008
    Messages:
    17
    Likes Received:
    0
    Trophy Points:
    1
    you cannot say this host is causing the load.

    You need to find out is there any mysql commands repeatedly running/querying your database. you can enable the mysql logfile in your my.cnf file then analyze the log file to find out who use the most of the resources.

    I sent you a PM. take a look.
     
  13. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,623
    Likes Received:
    21
    Trophy Points:
    38
    Location:
    somewhere over the rainbow
    cPanel Access Level:
    Root Administrator
    Please try checking WHM > Daily Process Logs to see what users show the highest CPU, memory and MySQL usage as well as top processes. Since that data is an aggregate of all data collected from 0000 beginning that day, it can be helpful in determining who might be causing any load issues during that set day.
     
Loading...

Share This Page