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. DWHS.net

    DWHS.net Well-Known Member
    PartnerNOC

    Joined:
    Jul 28, 2002
    Messages:
    1,569
    Likes Received:
    6
    Trophy Points:
    38
    Location:
    LA, Costa RIca
    cPanel Access Level:
    Root Administrator
    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:
    430
    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