Database size limit

From ISPWiki
Jump to: navigation, search

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.