What happens when the user reaches their quota limitation from MySQL doing an insert? IIRC, the filesystem won't allow the write and could potentially cause problems with the database.
You may choose to put them on another un-quota-ed filesystem and write a quick perl script to check the size of each database. Fire off an email to you or the customer. If they don't reduce the size of the database in a day or so, charge 'em for more disk space. :) The quota function at the MySQL level would be preferable to keep data integrity. MySQL using the OS level soft/hard quota would be even nicer for sysadmins. -J -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Iikka Meriläinen Sent: Tuesday, October 08, 2002 12:58 PM To: Jesse Sheidlower Cc: [EMAIL PROTECTED] Subject: Re: Limiting size of individual databases? On Tue, 8 Oct 2002, Jesse Sheidlower wrote: > I'm sure this is a common requirement, but the only thing I could > find in the docs or in a book or two was an unanswered version of > the same question at http://www.mysql.com/doc/en/CREATE_DATABASE.html . > > I'm setting up MySQL on a small ISP and would like to be able to > restrict the size of individual databases to something like 25M. > What's the best way of getting this done? The server is running > Solaris, if it's necessary to do it through the OS insteady of > through MySQL. Hi, Unfortunately you'll have to use Solaris disk quotas for that. Make sure that the table files of each restricted-space user count towards their personal quotas. This means that you have to create a separate OS account for each user you want to restrict with the quota. This also means that the table files must be owned by those restricted users. I hope this quota feature will be added into MySQL in the future. Best regards, Iikka --------------------------------------------------------------------- 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
