Re: Quata Support with MySQL
On Sun, Nov 04, 2001 at 09:59:28AM -0800, Jeremy Zawodny wrote:
> On Fri, Nov 02, 2001 at 02:10:38AM -0500, Keith Elder wrote:
> > Greetings,
> > 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.
You could dump their tables into their userland periodically. Of course,
then they would be double overquota for the mySQL data even though it
would only get counted once. :-)
> Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, WCNet, Yahoo!
> <Jeremy@Zawodny.com> | http://jeremy.zawodny.com/
> To UNSUBSCRIBE, email to firstname.lastname@example.org
> with a subject of "unsubscribe". Trouble? Contact email@example.com
Christopher F. Miller, Publisher firstname.lastname@example.org
MaineStreet Communications, Inc 208 Portland Road, Gray, ME 04039
Content/site management, online commerce, internet integration, Debian linux