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 WebHostPro, Dec 10, 2003.

  1. WebHostPro

    WebHostPro Well-Known Member
    PartnerNOC

    Joined:
    Jul 28, 2002
    Messages:
    1,597
    Likes Received:
    10
    Trophy Points:
    168
    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:
    166
    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:
    316
    Location:
    Spain
Loading...

Share This Page