1. 

   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:

   Follow @dwhs

   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.

    

   #1 WebHostPro, Dec 10, 2003
2. 

   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

    

   #2 pingo, Dec 10, 2003
3. 

   Juanra Well-Known Member

   Joined:

   Sep 22, 2001

   Messages:

   777

   Likes Received:

   0

   Trophy Points:

   316

   Location:

   Spain

   mtop.sf.net

    

   #3 Juanra, Dec 10, 2003

• Log in with Facebook
• Log in with Twitter

Your name or email address:

Do you already have an account?

• No, create an account now.
• Yes, my password is:
• Forgot your password?

Stay logged in