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
email@example.com D-52064 Aachen Fax 0241/911879