Database size limit
Category path: | ISPmanager Business -> Database servers |
ISPmanager Lite -> Database servers |
This article provides information about database size limits in ISPmanager 5 Business.
In ISPmanager 5 Business you can limit database size for a particular user. Once the limit is set, the cron job is started to check database size. You can specify the following parameter in the control panel's configuration file to set a period in minutes:
LimitDbSizeCheckPeriod
the default value - 10 (minutes)
If the total size of user's databases is reaching the limit, the databases will be set to read-only.
If the the total size of user's databases is below the limit permitted, the databases that were previously in the Read-only mode, will continue their normal operation.
Read-only denies write permissions for all databases created by the user in the control panel.
For MySQL the following permissions cannot be used:
- INSERT
- CREATE
- ALTER
- CREATE_VIEW
- CREATE_ROUTINE
- GRANT
For PostgerSQL the Read-only mode is not implemented yet.