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
> 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
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
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
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
> > 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
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
7 matches
Mail list logo