MySQL quota - suggestion

tomek1

Verified User
Joined
Nov 8, 2003
Messages
13
It would be nice to have MySQL quota.
As I know MySQL database can grow to package disk space limit.
Is it possible to do ?

Thanks
Tom
 
this woulb be great.. mysql bases that are big big can kill the speed of the server... we need how to limit all databases to a fixed amount of space
 
This would be a nice feature but hard to implement since MySQL doesn't have any kind of build in quota management. As far as I know the only way to do it, would have some script get a list of all databases per user, tally up the size of all tables within those databases, then do whatever depending on their sizes.

This brings up a question. If a user goes over the limit, what will happen? Suspension? seems a bit harsh, or would it act the same way as quota does now?

Eitherway, personally I won't be limiting users mysql databases since it's included as part of their account quota.
Just my thoughts ;)
 
Back
Top