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.

Best way to catch resource hogs mysql/php

Discussion in 'General Discussion' started by dmtnet, Feb 22, 2006.

  1. dmtnet

    dmtnet Active Member

    Joined:
    Feb 1, 2003
    Messages:
    31
    Likes Received:
    0
    Trophy Points:
    6
    I need some advice on how to catch some resource hogs on mysql and php automatically if possible and give me a report every hour ar the end of night. But I would be willing to settle for whatever. I bet have two users I think are using just too much and i need a way of tracking it down for sure.

    thanks ahead of time
     
  2. fikse

    fikse Well-Known Member

    Joined:
    May 10, 2003
    Messages:
    112
    Likes Received:
    0
    Trophy Points:
    16
    have you tried, whm > main > server status > CPU/memory/mysql usage?

    this shows which accounts (domains) have used the most resouces in the last 24 hours, and you can move forward and backward through different days....
     
  3. jacks

    jacks Active Member

    Joined:
    Nov 15, 2004
    Messages:
    31
    Likes Received:
    0
    Trophy Points:
    6
    i had a simialr problem in the past two weeks and i couldn't catch the resource hogs. i went to Andy (servertune.com) and he sorted things out for me. it is paid service, but worth it. ;)
     
  4. myusername

    myusername Well-Known Member
    PartnerNOC

    Joined:
    Mar 6, 2003
    Messages:
    691
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    chown -R us.*yourbase*
    cPanel Access Level:
    DataCenter Provider
    Twitter:
    Install mytop which should help you in tracking down problematic users.
     
Loading...

Share This Page