Events:
- MySQL database quota reached
- MySQL database soft quota reached
- Microsoft SQL Server database quota reached
- Microsoft SQL Server database soft quota reached
| Parameter name and description | Environment variable name | Notes |
|---|---|---|
| Subscription’s domain name | OLD_DOMAIN_NAME |
|
| Subscription’s GUID | OLD_DOMAIN_GUID |
|
| Customer’s GUID | OLD_CLIENT_GUID |
|
| Customer’s GUID | OLD_CLIENT_GUID |
|
| The total amount of disk space that can be used by MySQL databases on a subscription |
OLD_MYSQL_DATABASE_QUOTA |
Only for MySQL events |
| Disk space currently used by MySQL databases on a subscription | OLD_MYSQL_DATABASE_USAGE |
Only for MySQL events |
| The total amount of disk space that can be used by Microsoft SQL Server databases on a subscription |
OLD_MICROSOFT_SQL_DATABASE_QUOTA |
Only for MS SQL Server events |
| Disk space currently used by Microsoft SQL Server databases on a subscription |
OLD_MICROSOFT_SQL_DATABASE_USAGE |
Only for MS SQL Server events |
The soft limit can be changed in the panel.ini file by
specifying the option databaseManagement.diskSpaceSoftQuota. The value
is percentage of the limit (default is 85%). For example:
[databaseManagement]
diskSpaceSoftQuota=50
Example of event handler:
C:tempmssql_soft.bat <NEW_DOMAIN_NAME> <NEW_DOMAIN_GUID> <NEW_CLIENT_GUID> <NEW_MICROSOFT_SQL_DATABASE_QUOTA> <NEW_MICROSOFT_SQL_DATABASE_USAGE> <OLD_DOMAIN_NAME> <OLD_DOMAIN_GUID> <OLD_CLIENT_GUID>
echo "--------------" >> c:tempmssql_soft_handler.log
date /T >> c:tempmssql_soft_handler.log
echo "NEW_DOMAIN_NAME: %1" >> c:tempmssql_soft_handler.log
echo "NEW_DOMAIN_GUID: %2" >> c:tempmssql_soft_handler.log
echo "NEW_CLIENT_GUID: %3" >> c:tempmssql_soft_handler.log
echo "NEW_MICROSOFT_SQL_DATABASE_QUOTA: %4" >> c:tempmssql_soft_handler.log
echo "NEW_MICROSOFT_SQL_DATABASE_USAGE: %5" >> c:tempmssql_soft_handler.log
echo "OLD_DOMAIN_NAME: %6" >> c:tempmssql_soft_handler.log
echo "OLD_DOMAIN_GUID: %7" >> c:tempmssql_soft_handler.log
echo "OLD_CLIENT_GUID: %8" >> c:tempmssql_soft_handler.log
echo "--------------" >> c:tempmssql_soft_handler.log