[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

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
> -- 
> Jeremy D. Zawodny     |  Perl, Web, MySQL, Linux Magazine, WCNet, Yahoo!
> <Jeremy@Zawodny.com>  |  http://jeremy.zawodny.com/
> -- 
> To UNSUBSCRIBE, email to debian-isp-request@lists.debian.org
> with a subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org


Christopher F. Miller, Publisher                               cfm@maine.com
MaineStreet Communications, Inc           208 Portland Road, Gray, ME  04039
1.207.657.5078                                         http://www.maine.com/
Content/site management, online commerce, internet integration, Debian linux

Reply to: