[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Re: Limit MySQL database sizes

On Wed, Jan 22, 2003 at 02:39:34PM -0800, Jeremy Zawodny wrote:
> > How can a "quota" be put on MySQL sizes? That is... in a similar fashion
> > to the "commercial" control panels like Cpanel and such?
> > 
> > Normal filesystem quotas don't work, since the database is owned by user
> > "MySQL" and not the user him/herself.
> You can chown the data files and make sure they're group-writable.

Oh, please NEVER use system quotas on mysql databases! This leads to
severe data corruption as mysql has much data in cache that does not get
written to disk once the quota is exceeded! 

As long as there's no way for a user to get the actual used size the 
only thing you can do is limiting him manually by some sort of mail 
remainder and extra fees.



Christian Hammers             WESTEND GmbH  |  Internet-Business-Provider
Technik                       CISCO Systems Partner - Authorized Reseller
                              Lütticher Strasse 10     Tel 0241/701333-11
ch@westend.com                D-52064 Aachen              Fax 0241/911879

Reply to: