Limit MySQL database sizes

["Jason Lim" <maillist@jasonlim.com>]

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.

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?

Thanks in advance.

Jas.