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.

help tracking down mysql excessive use

Discussion in 'General Discussion' started by DWHS.net, Dec 10, 2003.

  1. WebHostPro

    WebHostPro Well-Known Member
    PartnerNOC

    Joined:
    Jul 28, 2002
    Messages:
    1,593
    Likes Received:
    9
    Trophy Points:
    38
    Location:
    LA, Costa RIca
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello,

    I can't seem to track down who using huge mysql resource:

    mysql 1.29 0.80

    Any ideas would be very helpful.

    I have checked the message log but no help so far.
     
  2. pingo

    pingo Well-Known Member

    Joined:
    Nov 16, 2002
    Messages:
    428
    Likes Received:
    0
    Trophy Points:
    16
    You can look at mysql processes by:

    mysqladmin -p processlist

    The following command will show the top 10 CPU hogs. The worst is at the bottom:

    ps -efw --sort %cpu | tail

    John
     
  3. Juanra

    Juanra Well-Known Member

    Joined:
    Sep 22, 2001
    Messages:
    777
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Spain
Loading...

Share This Page