Results 1 to 4 of 4

Thread: High Load CPU

  1. #1

    High Load CPU

    Hello,
    I get the following message from my dedicated server:
    PHP Code:
     While processingthe cpu has been maxed out for more than a 6 hour period.
    The current load/uptime line on the server at the time of 
    this email is
      07
    :23:03 up 2 days23:42,  0 users,  load average8.716.636.41
      You should check the server to see why the load is so high 
    and take 
    steps to lower the load
    .  If you want stats to continue to run even with a high loadEdit 
    /var/cpanel/cpanel.config and change extracpus to a number larger then 0 (run 
    /usr/local/cpanel/startup afterwards to pickup the changes). 
    If I run top command from ssh I see that mysqld use 105-125%of CPU.
    How may I check which query use so much the CPU ?

    Thanks!

  2. #2
    Join Date
    Apr 2003
    Location
    NC
    Posts
    3,080
    You could use mytop or look at "show processlist" within mysql.

    You may also gain from optimizing MySQL or some other parts of the server.
    John W, CISSP, C|EH
    MS Information Security and Assurance
    ITEagleEye.com - Server Administration and Security
    Yawig.com - Managed VPS and Dedicated Servers with VIP Service

  3. #3
    How/What should I do to look at "show processlist" within mysql.

  4. #4
    Join Date
    Jul 2002
    Location
    World Wide Web
    Posts
    1,680
    Do you have whm?
    Michael Vlastos
    HostWired.com - Innovative Hosting Solutions since 2005 | cPanel, Softaculous
    Personalized support | No site suspensions | No overloaded servers | Green Hosting
    Multiple Backups | Average Response Time: 20 min | Toll Free: 1-855-ECO-HOST

Similar Threads

  1. My server is very slow, High CPU, High Apache load....Please help.
    By awaisuk in forum Hosting Security and Technology
    Replies: 6
    Last Post: 11-01-2009, 01:00 PM
  2. Need help optimizing server, High load, high CPU usage
    By chasebug in forum Hosting Security and Technology
    Replies: 2
    Last Post: 10-17-2009, 08:38 AM
  3. High CPU load but no high process
    By roro in forum Hosting Security and Technology
    Replies: 10
    Last Post: 11-09-2008, 08:45 PM
  4. Need Help - High CPU Load
    By Buffy807 in forum VPS Hosting
    Replies: 13
    Last Post: 11-17-2006, 01:18 PM
  5. High CPU load
    By George_Fusioned in forum Dedicated Server
    Replies: 4
    Last Post: 03-12-2005, 11:40 AM

Tags for this Thread

Posting Permissions

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