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

Re: Limit MySQL database sizes

On Thu, Jan 23, 2003 at 06:02:21AM +0800, Jason Lim wrote:
> Hi all,
> 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.

> Right now we're using a custom script that just reports any values over a
> certain amount, and the possibility to "trim" very large ones, but it
> would be much better if something like a proper quota could be put on (eg.
> 30Mb).
> Any ideas?

There is no build-in mechanism yet.
Jeremy D. Zawodny     |  Perl, Web, MySQL, Linux Magazine, Yahoo!
<Jeremy@Zawodny.com>  |  http://jeremy.zawodny.com/

Reply to: