Re: Limit MySQL database sizes

2003-01-23 Thread Christian Hammers
On Fri, Jan 24, 2003 at 04:12:36AM +0800, Jason Lim wrote: > But then how do all those "commercial" control panels, like Cpanel, > H-sphere, and others, do their "MySQL quota"? I don't know those products. Do they have evaluation version or online docs that could be used to reverse engeneer what

Re: Limit MySQL database sizes

2003-01-23 Thread Jason Lim
> Oh, please NEVER use system quotas on mysql databases! This leads to > severe data corruption as mysql has much data in cache that does not get > written to disk once the quota is exceeded! > > As long as there's no way for a user to get the actual used size the > only thing you can do is limiti

Re: Limit MySQL database sizes

2003-01-23 Thread Christian Hammers
On Wed, Jan 22, 2003 at 02:39:34PM -0800, Jeremy Zawodny wrote: > > 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

Re: Limit MySQL database sizes

2003-01-22 Thread Jeremy Zawodny
On Thu, Jan 23, 2003 at 06:50:30AM +0800, Jason Lim wrote: > > > 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. > > Could you expand on that a bit? You

Re: Limit MySQL database sizes

2003-01-22 Thread Jeremy Zawodny
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 n

Re: Limit MySQL database sizes

2003-01-22 Thread Jason Lim
> > 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. Could you expand on that a bit? You mean make it owned by the user, and group writable by MySQL? > > Right

Limit MySQL database sizes

2003-01-22 Thread Jason Lim
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