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.
> 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/