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.

Mysql db using 185GB space - quota shows 88MB

Discussion in 'General Discussion' started by 4u123, Oct 9, 2008.

  1. 4u123

    4u123 Well-Known Member
    PartnerNOC

    Joined:
    Jan 2, 2006
    Messages:
    765
    Likes Received:
    1
    Trophy Points:
    18
    Had a major problem with a user using 185GB of space. He is using a CMS called "MODX" and there is some kind of problem with it because the table "modx_event_log" in his database was 185GB. I only found out about it when I noticed the server running out of space.

    I truncated the table and everything is ok for now but it concerns me. I was under the impression that the users mysql file size was included in their quota - is this not the case ?
     
  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
  3. npsari

    npsari Member

    Joined:
    Nov 8, 2007
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    My server is also showing some strange values
    I try to ignore them, but now that iam thinking about it, i will actually investigate why my server shows such a big hard disk usage
     
  4. cPanelKenneth

    cPanelKenneth cPanel Development
    Staff Member

    Joined:
    Apr 7, 2006
    Messages:
    4,458
    Likes Received:
    22
    Trophy Points:
    38
    cPanel Access Level:
    Root Administrator
    This should be addressed in cPanel 11.25. All significant user owned/created data that does not reside in the home directory will be included in the File Space used value.
     
  5. 4u123

    4u123 Well-Known Member
    PartnerNOC

    Joined:
    Jan 2, 2006
    Messages:
    765
    Likes Received:
    1
    Trophy Points:
    18
    And can you tell us what will happen if the mysql usage takes the customer over their limit?
     
  6. cPanelKenneth

    cPanelKenneth cPanel Development
    Staff Member

    Joined:
    Apr 7, 2006
    Messages:
    4,458
    Likes Received:
    22
    Trophy Points:
    38
    cPanel Access Level:
    Root Administrator
    That is currently undefined, although we are open to suggestions.
     
  7. 4u123

    4u123 Well-Known Member
    PartnerNOC

    Joined:
    Jan 2, 2006
    Messages:
    765
    Likes Received:
    1
    Trophy Points:
    18
    This inclusion will still trigger the disk usage emails right? So customers and admins will be emailed depending on the settings in WHM and those warnings will be based on the accumulated total of disk and mysql usage?

    Personally speaking I think that the linux quotas system is a waste of time and you shouldnt use it. I think that there should be one total made up of the disk and mysql usage which should trigger warnings to both the customer and the server admin with plenty of notice.

    I also think that we should be able to query the space used via the api in order to charge the customer for extra usage and automatically increase a customers limit the same way if they buy more space. If the limits can be handled by the billing system instead of the cpanel server, you have a good line of communication with the customer and a way to increase revenue whilst keeping track of things. I think the same should be available for bandwidth.

    The big question is really about whether to suspend the account or how to stop them using it if they havent paid for their usage. Some people will prefer to let the customer keep on using disk space and charge them for it. Others will prefer to stop their service - similar to the way the bandwidth notice appears. It would be good to have both options available.

    One thing I know is that you cant impose the same restrictions in place with quotas for mysql usage. You might argue that using the quotas system is good because it prevents the customer from writing to the disk but keeps their site online. Although it causes their mail to bounce and they cant write any temporary data. Because mysql usage is not included in the users quota it wont stop them from writing to the disk - which is historically the problem that has caused this debate in the first place.

    I would suggest a different option. Give them plenty of warning in their cpanel interface and via email that their disk usage has been reached. A popup after cpanel login would also be good - but why not give them a +10%buffer at which point the account becomes suspended. This way they have had lots of time before they reached their limit to buy some more space or upgrade - they have been notified at the point they go over and they have been given a buffer so service has been kept going for them but at the point they reach 10% over, thats really time to say "ok youve had plenty of warning we have to suspend your account now".
     
  8. cPanelKenneth

    cPanelKenneth cPanel Development
    Staff Member

    Joined:
    Apr 7, 2006
    Messages:
    4,458
    Likes Received:
    22
    Trophy Points:
    38
    cPanel Access Level:
    Root Administrator
    It should.

    The file system quota has its use and purpose, but certain shows deficiencies when dealing with certain scenarios. Your ideas are much appreciated.
     
Loading...

Share This Page