database quota

[Giuseppe]

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

Giuseppe

[till]

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

[Giuseppe]

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

[erosbk]

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.

[till]

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.