database quota

Discussion in 'Installation/Configuration' started by Giuseppe, Jul 23, 2011.

  1. Giuseppe

    Giuseppe New Member

    Hi,
    i need to know how database quota is calculated.
    I have ispconfig 3.0.3.3 on i386 debian 6.
    Thank you.

    Giuseppe
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    There is no database quota available in ispconfig 3 yet, as mysql does not has quota support for databases.
     
  3. Giuseppe

    Giuseppe New Member

    database quote

    Hi,
    so the database can have illimited size space?
    or it use the web site space?
    Thank you.
     
  4. erosbk

    erosbk New Member

    If databases were saved in a specific path per each user, could be possible to check for size of every file in each user folder.

    Maybe a cron could check with a db_quota table, and, if size >= db_quota, remove INSERT / UPDATE permissions for users. If size < db_quota, then grant permissions back.

    Could this approach work? is not the best but, I think that this could help a lot.
     
  5. till

    till Super Moderator Staff Member ISPConfig Developer

    Mysql stores all databases in it main database path and if innodb is used, even all databases are in the same file. So the only way to get the size is to query mysql for the table sizes and then build some kind of quota function around that.
     

Share This Page