Implemented: MySQL Quotas
Posted by Jules on January 31st, 2010 - announcements | No Comments »
As per our previous post on the MySQL Quota changes, we have now implemented MySQL quotas across the board. This post will try and cover all the details you may need regarding the new quota system.
What is the quota size for databases now?
The quota is currently hard-coded to 256MB. There are no plans to increase this in the future.
What will happen if my database is over quota?
Your database will have the UPDATE, INSERT and CREATE permissions revoked. This will mean that no new data can be added to the database until you reduce the size to less than 256MB.
Will this cause an error on my site?
Unfortunately this is impossible to determine, and fundamentally depends on how your site is developed. Some sites will generate a MySQL error, perhaps related to invalid permissions. Some sites may be less friendly and show nothing at all. If you’re experiencing odd problems, you should first check the size of your MySQL database(s) within cPanel.
I’ve reduced my database size, when will my site/database be working again?
The quota system is scheduled to execute every 5 minutes, so your site/database will be working within 5 minutes of reducing the size.
Will you notify me if my database is over size?
Unfortunately, due to the very dynamic nature of databases, and various limitations within our billing system (currently), we are unable to notify you if your database has had the permissions revoked. We are working to include this, and other account notifications in a future client area, but presently this is something you will need to monitor manually.
We apologise for any inconvenience that this change may cause, and we hope you understand our reasons for implementing this. As always, if you have any questions, comments or concerns, please let us know.
