Community Forums
Connect with us on LinkedIn
+ Reply to Thread
Results 1 to 4 of 4
  1. #1
    Member
    Join Date
    Jan 2004
    Posts
    103

    Default MySQL Disk Usage

    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.
    Cheap Reseller Hosting, Business Hosting & Personal Hosting
    cPanel & WHM - PHP4 & PHP5 - SiteBuilder - Free Domain For Life
    Serving Thousands of Customers Since 2001
    www.QualityHostOnline.com

  2. #2
    Super Moderator This forum account has been confirmed by cPanel staff to represent a vendor. chirpy's Avatar
    Join Date
    Jun 2002
    Location
    Go on, have a guess
    Posts
    13,495

    Default

    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.
    Jonathan Michaelson

    Need your cPanel servers secured and tuned?
    cPanel Server Configuration, Security, Recovery and Antivirus/AntiSpam Services
    Developers of the most effective (and free) Firewall & Security Solution for cPanel Servers - csf
    http://www.configserver.com

  3. #3
    Member
    Join Date
    Jan 2004
    Posts
    103

    Default

    Thank you for the reply Jonathan.

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

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

    Can someone from cPanel please reply?
    Cheap Reseller Hosting, Business Hosting & Personal Hosting
    cPanel & WHM - PHP4 & PHP5 - SiteBuilder - Free Domain For Life
    Serving Thousands of Customers Since 2001
    www.QualityHostOnline.com

  4. #4
    Super Moderator This forum account has been confirmed by cPanel staff to represent a vendor. chirpy's Avatar
    Join Date
    Jun 2002
    Location
    Go on, have a guess
    Posts
    13,495

    Default

    Check bugzilla there's an enhancement request for this.
    Jonathan Michaelson

    Need your cPanel servers secured and tuned?
    cPanel Server Configuration, Security, Recovery and Antivirus/AntiSpam Services
    Developers of the most effective (and free) Firewall & Security Solution for cPanel Servers - csf
    http://www.configserver.com

Similar Threads & Tags
Similar threads

  1. is mysql usage added to cpanel disk usage for clients?
    By Snowman30 in forum cPanel and WHM Discussions
    Replies: 1
    Last Post: 09-24-2009, 08:12 AM
  2. Mail usage: show disk space used does not match actual disk usage
    By NNNils in forum cPanel and WHM Discussions
    Replies: 1
    Last Post: 11-25-2004, 07:01 AM
  3. mysql disk usage
    By NNNils in forum cPanel and WHM Discussions
    Replies: 1
    Last Post: 09-11-2003, 03:28 PM
Linkedin       Facebook       Twitter       RSS       Flickr       YouTube