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

Re: Limit MySQL database sizes

> > Normal filesystem quotas don't work, since the database is owned by
> > "MySQL" and not the user him/herself.
> You can chown the data files and make sure they're group-writable.

Could you expand on that a bit? You mean make it owned by the user, and
group writable by MySQL?

> > 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
> > 30Mb).
> >
> > Any ideas?
> There is no build-in mechanism yet.

Mmm... then how on earth are those "Cpanels" and others doing it?

Reply to: