On Sat, 5 May 2001 13:47:57 -0600
"Zak Greant" <[EMAIL PROTECTED]> wrote:
> chintanp wrote:
> > I want to implement disk quota's for various MySQL databases.
> > I checked out various books,but did not find the answere.
> > Can you please help me in achieving my goal ?
> > I am using Red Hat Linux 7.
>
> Hello,
>
> I had to do this for an employer a few years ago.
>
> I wrote a perl script that found the size of database
> directories in the MySQL data directory.
>
> I tied the directories back to users by using a simple
> text file.
>
> user_1:db_1,db_2
> user_2:db_3
> ...
>
> Then I grabbed a module from CPAN that does reporting
> of user quotas.
>
> IIRC, the only trouble that I ran into was trying to
> use the system's (an older BSD/OS) quota command to
> fetch user quota data...
and put this in a cron job which removes write access attribute on database(s) when
exceeding quota. sounds like a good tool to me :)
>
> Good Luck!
>
>
> Zak Greant
> Freelance Designer / Programmer / Writer
>
> PHP QA Team Member
> http://qa.php.net/
>
> Am I working on a project for or with you?
> Check http://calendar.yahoo.ca/jagreant
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
