Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

MySQL Disk Usage

Discussion in 'General Discussion' started by Salman75, Aug 19, 2008.

  1. Salman75

    Salman75 Well-Known Member

    Joined:
    Jan 20, 2004
    Messages:
    102
    Likes Received:
    0
    Trophy Points:
    166
    HI,

    WHM does not seem to keep a check on the sql disk usage of accounts. The sql usage can actually be higher than the total disk space allowed for that account.

    Is there any way to track and control sql disk usage so it does not overgrow the actual disk space allowed to that account?

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  2. chirpy

    chirpy Well-Known Member

    Joined:
    Jun 15, 2002
    Messages:
    13,460
    Likes Received:
    21
    Trophy Points:
    463
    Location:
    Go on, have a guess
    The only current method is to use /scripts/updatemysqlquota and the schedule it to run on a frequent basis (e.g. hourly or daily). However, there is a significant risk in this method whereby MySQL will crash and refuse to start if any account goes over quota.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. Salman75

    Salman75 Well-Known Member

    Joined:
    Jan 20, 2004
    Messages:
    102
    Likes Received:
    0
    Trophy Points:
    166
    Thank you for the reply Jonathan.

    Well, thats not a very nice way to find out one of your accounts is over-quota ...... :eek:

    cPanel folks should be aware of this issue and should have already done something to fix it.

    Can someone from cPanel please reply?
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  4. chirpy

    chirpy Well-Known Member

    Joined:
    Jun 15, 2002
    Messages:
    13,460
    Likes Received:
    21
    Trophy Points:
    463
    Location:
    Go on, have a guess
    Check bugzilla there's an enhancement request for this.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice