limiting users sql databases

amadkow · 08-08-2005, 05:33 PM

I have been looking around for a good method to limit how large a users sql data base can be. Would it be posible to put a user quota on the / then chown the db to that user? The only problem I see with that is I would have to set up a script to check the permissions on their database every once in a while. Does any one know of any better sollutions or methods to this?

fouldsy · 08-09-2005, 11:05 AM

I don't know of any built-in MySQL function to limit database size, the method I've used in the past is as you mention - create a db, set owner + group for the user concerned, then specify the file quota. Works well, the same way disk quotas for home drives work. When the db reaches it limits, it stops any further data adding, which can be a bugger depending on what your end users are utilising the database for!