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.

Package doesn't take into account MySQL space

Discussion in 'General Discussion' started by Data 1, Sep 8, 2009.

  1. Data 1

    Data 1 Well-Known Member

    Joined:
    May 25, 2008
    Messages:
    113
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Columbus Ohio
    cPanel Access Level:
    DataCenter Provider
    I host mostly bulletin boards. The MySQL databases related to these boards almost always outweigh the web files as far as disk space.

    Is there any way to get cpanel to count the MySQL space as part of the total disk space allotted in the package?

    Jim
     
  2. cPanelDavidG

    cPanelDavidG Technical Product Specialist

    Joined:
    Nov 29, 2006
    Messages:
    11,279
    Likes Received:
    8
    Trophy Points:
    38
    Location:
    Houston, TX
    cPanel Access Level:
    Root Administrator
    This is functionality we're working on for version 11.25 (the next incremental version of cPanel/WHM).
     
  3. Spiral

    Spiral BANNED

    Joined:
    Jun 24, 2005
    Messages:
    2,023
    Likes Received:
    7
    Trophy Points:
    0
    For now your only hope is a custom scripts to check the sum total space
    used on users plus MySQL database space and report that to you.

    Cpanel doesn't currently have a way to give that to you at once although
    that is something they are currently working on so I hear.
     
  4. Data 1

    Data 1 Well-Known Member

    Joined:
    May 25, 2008
    Messages:
    113
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Columbus Ohio
    cPanel Access Level:
    DataCenter Provider
    Thank you all, I was hoping it wasn't something I might have overlooked.

    I have a hard time explaining to customers why they need a larger package.

    Jim
     
  5. Data 1

    Data 1 Well-Known Member

    Joined:
    May 25, 2008
    Messages:
    113
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Columbus Ohio
    cPanel Access Level:
    DataCenter Provider
    Digging this back up because unless I'm missing something big it did not happen with 11.25. I've only updated one server so far but the MySQL usage still isn't subtracted from total disk space allotted. If there is a switch I have to flip let me know please-

    Jim
     
  6. Data 1

    Data 1 Well-Known Member

    Joined:
    May 25, 2008
    Messages:
    113
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Columbus Ohio
    cPanel Access Level:
    DataCenter Provider
    Sorry, found it. It's in tweak settings. My bad.
     
  7. Data 1

    Data 1 Well-Known Member

    Joined:
    May 25, 2008
    Messages:
    113
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Columbus Ohio
    cPanel Access Level:
    DataCenter Provider
    I enabled this new feature since the 11.25 upgrade and though it counts the space now as disk space it doesn't seem to do anything about it. I have one customer in particular that is about 20% over disk quota and his site is still going.

    I know the moment someone goes over on bandwidth they get no site and a warning.... isn't it the same for disk usage?
     
  8. Data 1

    Data 1 Well-Known Member

    Joined:
    May 25, 2008
    Messages:
    113
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Columbus Ohio
    cPanel Access Level:
    DataCenter Provider
    OK I'm bumping this because I really feel it should be shutting Mr. overuse off.

    I know the guy and will give him the extra space free of charge no problem.... but cpanel should shut him off for over quota. Am I missing some kind of point here?
     

    Attached Files:

    #8 Data 1, Dec 27, 2009
    Last edited: Dec 27, 2009
  9. cPanelKenneth

    cPanelKenneth cPanel Development
    Staff Member

    Joined:
    Apr 7, 2006
    Messages:
    4,458
    Likes Received:
    22
    Trophy Points:
    38
    cPanel Access Level:
    Root Administrator
    When an account exhausts its disk quota an email is sent to the admin and account contact but otherwise no action is taken.
     
  10. Data 1

    Data 1 Well-Known Member

    Joined:
    May 25, 2008
    Messages:
    113
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Columbus Ohio
    cPanel Access Level:
    DataCenter Provider
    I don't remember this being the behavior of previous releases. I have had people shut down over bandwidth overuse.

    Now that I think about it FTP does keep them from uploading anything else but the site would still be accessible. This happened recently when a customer backed up their database to their web space and it went over. The backup even failed.

    Is this the case? I can live with it but it seems like bandwidth or disk... overuse is overuse...

    Thank you
     
  11. cPanelKenneth

    cPanelKenneth cPanel Development
    Staff Member

    Joined:
    Apr 7, 2006
    Messages:
    4,458
    Likes Received:
    22
    Trophy Points:
    38
    cPanel Access Level:
    Root Administrator
    Once the disk quota is exhausted the account cannot upload more data.

    The database quota system is a soft quota system and is not tied into the disk quota system. Large databases will not cause consumption of the disk quota ( at the filesystem/kernel level).

    cPanel 11.25 tracks the disk usage of an accounts databases and provides means for billing systems to retrieve that data. You, or your billing application, can take action based upon that data. The cPanel/WHM application takes no action.
     
Loading...

Share This Page