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! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
