Thank you very much for your information. I have encountered another problem if I use this approach. The problem is I can change the database directory to another group which has quota. However, whatever mysql create new table, it will use its configrated group (namely 'mysql' in Redhat default rpm).
I think I can perform chgrp by a cron job at a regular interval. However, I will come back to my original problem that I can't limit disk usage at real time and a single program fault will make my server unfunctional. Thank you again for your valuable information and can you give me more help. Best regards, > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > Hello KH, > > Tuesday, February 18, 2003, 2:15:47 PM, you wrote: > > > Thank you very much for your information. Can you tell me more how to limit > > size of directory in Linux? I can only set quota for users or groups but not > > for directory. > > very simple > chown or chgrp the dir and set the quota for that group/user > example: > chgrp -Rv quota100MB /home/slpl/ > > quota100MB meaning a group which will assign a quota of 100MB > if the group don't exist create one > > P.S. > This was done by reading the man > > > Thank you very much. > > >> On Tuesday 18 February 2003 04:26, KH Chiu wrote: > >> > >> > I am planning to offer a free service that allow users to use my server to > >> > learn php and MySQL. I am a bit worry about if one of users (either > >> > intentionally or unintentionally) get into infinite loop with insert > >> > statement. It will quickly eat up the disk space and make my server > >> > unfunctional. So is there any way to limit the size of individual > > database? > >> > >> With MySQL - nope. > >> You can limit size of the database directory. > >> > >> -- > >> For technical support contracts, goto https://order.mysql.com/?ref=ensita > >> This email is sponsored by Ensita.net http://www.ensita.net/ > >> __ ___ ___ ____ __ > >> / |/ /_ __/ __/ __ \/ / Victoria Reznichenko > >> / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] > >> /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net > >> <___/ www.mysql.com > >> > >> --------------------------------------------------------------------- > >> 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 <mysql-unsubscribe- > > [EMAIL PROTECTED]> > >> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > -- > > Yours, > > KH Chiu > > C&A Computer Consultants Ltd. > > Tel: 3104 2070 Fax: 3010 0896 > > Email: [EMAIL PROTECTED] > > Website: www.caconsultant.com > > - -- > Best regards, > Solid <mailto:[EMAIL PROTECTED]> > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.2.1 (MingW32) > > iD8DBQE+Ukgq2PEgI0nAJngRApOdAJwKaXPMfZB2DVsdDTXp1mp/BxDCqQCcD3Y6 > AkLZAP16pGRHRb+t+O07ZhA= > =maAp > -----END PGP SIGNATURE----- -- Yours, KH Chiu C&A Computer Consultants Ltd. Tel: 3104 2070 Fax: 3010 0896 Email: [EMAIL PROTECTED] Website: www.caconsultant.com --------------------------------------------------------------------- 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