MySQL Storage Limit

Discussion in 'General' started by todx, Nov 30, 2012.

  1. todx

    todx Member

    Does ISPC3 offer a way to limit the size of MySQL databases or does every database have unlimited ammount of space it can use?
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    There are no mysql quota limits as mysql does not offer to limit the site of a database and linux filesystem quote does not work for this purpose as well as all databases use the same linux user "mysql", so you would be able to limit only the size of all mysql databases but not a specific mysql database.
  3. Croydon

    Croydon ISPConfig Developer ISPConfig Developer

  4. cfoe

    cfoe ISPConfig Developer ISPConfig Developer

    Wouldnt it be possible to add some kind of soft-limit?
    It might not be possible to limit the size of dbs but the size can be calculated.
    This value could be compared to the "limit" for the user. If the size is greater than the limit new dbs could be denied.
    A notification could be added as soon as notifications are implemented into ISPConfig.
  5. till

    till Super Moderator Staff Member ISPConfig Developer

    We are working on such a function already, please see ispconfig roadmap.

Share This Page