Re: MySQL a quotas?
On Mon, Sep 30, 2002 at 10:24:42AM -0400, Bill Leonard wrote: on 9/30/02 9:47 AM, Victoria Reznichenko at [EMAIL PROTECTED] wrote: It's not a so good decision and not suitable if database contains InnoDB tables, but you can't limit database size only with MySQL. Is this a planned feature anywhere on the MySQL roadmap for 4.x? A database size quota? It's not terrible difficult to implement outside of MySQL as a separate daemon. I've got a design in mind, but need to protoype it one of these days. It'd probably be 300-500 lines of Perl at the most. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 55 days, processed 1,162,276,712 queries (240/sec. avg) - 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
re: MySQL a quotas?
Jiri, Sunday, September 29, 2002, 11:18:51 PM, you wrote: JM I'm solving problem how to set up quota on MySQL db. I've look for that JM in mailing lists and docummentation but with no success. JM Can someone help me with this problem? You can do it using disk quotas. -- 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: MySQL a quotas?
On Mon, 30 Sep 2002, Victoria Reznichenko wrote: Jiri, Sunday, September 29, 2002, 11:18:51 PM, you wrote: JM I'm solving problem how to set up quota on MySQL db. I've look for that JM in mailing lists and docummentation but with no success. JM Can someone help me with this problem? You can do it using disk quotas. Just out of curiosity, how will the user know whether the disk was full (quota exceeded) or has other errors occurred when he/she, for example, inserts a row that doesn't fit into the quota? After reading the manual on full disk conditions, I got the picture that the inserting thread gets stuck, and checks for free space once in a minute. Does the user running the inserting thread get a specific error, others thatn a note in the error log? Best regards, Iikka ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - 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
re: re: MySQL a quotas?
Iikka, Monday, September 30, 2002, 2:40:32 PM, you wrote: Jiri, Sunday, September 29, 2002, 11:18:51 PM, you wrote: JM I'm solving problem how to set up quota on MySQL db. I've look for that JM in mailing lists and docummentation but with no success. JM Can someone help me with this problem? You can do it using disk quotas. IM Just out of curiosity, how will the user know whether the disk was full (quota IM exceeded) or has other errors occurred when he/she, for example, inserts a row IM that doesn't fit into the quota? After reading the manual on full disk IM conditions, I got the picture that the inserting thread gets stuck, and checks IM for free space once in a minute. Does the user running the inserting thread IM get a specific error, others thatn a note in the error log? User will get error 28: No space left on device. It's not a so good decision and not suitable if database contains InnoDB tables, but you can't limit database size only with MySQL. -- 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL a quotas?
on 9/30/02 9:47 AM, Victoria Reznichenko at [EMAIL PROTECTED] wrote: It's not a so good decision and not suitable if database contains InnoDB tables, but you can't limit database size only with MySQL. Is this a planned feature anywhere on the MySQL roadmap for 4.x? A database size quota? Thanks for the info! -- Bill Leonard [EMAIL PROTECTED] www.machinemen.com407.464.0147 XrackHosting.com - Mac OS X hosting on Apple's Xserve! http://www.xrackhosting.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
MySQL a quotas?
Hi, I'm solving problem how to set up quota on MySQL db. I've look for that in mailing lists and docummentation but with no success. Can someone help me with this problem? Thanks -- jiri musil [EMAIL PROTECTED], icq# 125282227 - 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
Mysql hosting (quotas)
Hi. Anyone realized subj? I have quotas on /home. And I want to let my users using mysql... but what about quotas? :( Mysql works under mysql and all tables creates under owner *mysql* :-\ Any tips? P.s. uname -a: OpenBSD ns 2.9 NS#2 i386 -- %whois -R NULL-RIPN PGP: http://null.magelan.ru/null.asc Pager: +7 095 974-0003, #30369 - 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
