Re: Quata Support with MySQL
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. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, WCNet, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]
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! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED] -- Christopher F. Miller, Publisher [EMAIL PROTECTED] 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 -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]
Re: Quata Support with MySQL
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. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, WCNet, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/
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! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED] -- Christopher F. Miller, Publisher [EMAIL PROTECTED] 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
