Re: Quata Support with MySQL
On Fri, Nov 02, 2001 at 02:10:38AM -0500, Keith Elder wrote:
> I was wondering if anyone had any type of hints as howto setup
> virtual mysql accounts with quota support.
There's no really good way to do it yet. MySQL itself has no quota
system. And if you use OS quotas, you risk table corruption when a
user goes over quota.
You could have a cron jobs to compute each users usage once a day and
let them know if they're over.
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, WCNet, Yahoo!
<Jeremy@Zawodny.com> | http://jeremy.zawodny.com/