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.

Mysql takes up most of cpu time

Discussion in 'General Discussion' started by asiams, Jan 30, 2007.

  1. asiams

    asiams Well-Known Member

    Joined:
    May 28, 2003
    Messages:
    89
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Hokkaido, JAPAN
    I have a load report as follow:

    --------------------------------------------------------------------------------------------

    Your server, server22, appears to have a high load.

    The load averages are:
    1 minute: 4.19 (1.0475 per CPU)
    5 minutes: 1.62 (0.405 per CPU)
    15 minutes: 0.66 (0.165 per CPU)

    Here is what was just recorded as the current load.
    If blank, it means you have no current processes with a high load.

    - The process ID #4322 under the user mysql is using 271% CPU and 3.8% Memory with the command -- which has used 469 minutes and 44.40 seconds of CPU time.


    #####################################

    The top 10 processes are using a total of 403% CPU and a total of 9.5% Memory. The process list will follow.

    Here are the top 10 processes:

    - The process ID #4322 under the user mysql is using 271% CPU and 3.8% Memory with the command -- which has used 469 minutes and 44.40 seconds of CPU time.

    --------------------------------------------------------------------------

    I often have this kind of report coming by mysql dominating cpu time.

    I have 4 cpus.

    Can anyone tell me what caused this?

    How to balance the cpu usage?

    I have checked by searching the forum, but could not find any solution.

    Thanks for help.

    asiams
     
Loading...

Share This Page