cPanel & WHM Version 80 has been released, and brings a slew of great updates. Take a look at what is included, and then upgrade today!
 

Disable inserts/updates for databases once a user reaches their quota

virmix shared this idea 6 years ago
Open Discussion

Like Disk quota (MB) , but for mysql size


And other function ... send email when near to limit


I think this 2 features will be usefull

Comments (5)

photo
2

I think having a MySQL quota would easily break MyISAM tables, and possibly InnoDB as well when the user reaches the limit.

photo
3

I think that this can be achieved removing INSERT privilege from all MySQL users (including cPanel user) after defined disk quota was exceeded.


This option can be defined under every package, mysql INSERT privilege will be disabled when client account or mysql database hit defined limit. So option can be: after hitting defined account disk space limit, after hitting 50% (or any other defined percent) of disk space limit or another option after hitting defined limit just for mysql disk usage.


This will not break any MySQL dabatases/tables as we will only disable inserting new data into MySQL database. And this will successfully prevent using 1GB or more MySQL space under account that was limited to 100MB.


Then, after account or mysql disk space usage was lowered or account upgraded to bigger package just enable back INSERT privilege.


Additionally, temporary remove INSERT privilege from "cPanel -> MySQLDatabases" while disk usage was over defined limit, to prevent creating new mysql user with INSERT privilege that will override existing users or modifying existing user privileges.

photo
1

How would implementing this feature beneficial to your business?


How would this add value to your customers?

photo
1

Kenneth Power wrote:

How would implementing this feature beneficial to your business?


How would this add value to your customers?

It means better management of MySQL. Customers that have large hosting space can abuse the fact that they can pretty much upload as many tables as they like in MySQL.


It would benefit customers by ensuring a reliable service for them.

photo
2

I'd love this feature as well - I happen to have customers that tend to have a lot more SQL activity (inserts/updates) than actual data on disk, so they can grow a lot over the quota.

A customer could even use blobs and store images/other data in the DB to bypass a quota limitation, so blocking INSERT/UPDATE on quota exceeded would be awesome :-)