RE: [cobalt-users] Enforcing Disk Space limits on MySQL Databases

["Phil Beynon" <phil@xxxxxxxxxxxxxxxxxxxxxxxxx>]

> Michele Neylon :: Blacknight Solutions schrieb:
>
> >Afaik you can't easily implement it, as the MySQL data is not
> stored in the
> >site directory, so it is not 'owned' by the web users.
> >I know that some CPs support limitations though I've never heard of a RAQ
> >version
> >
> ><snip>
> >
> >>Does anyone have an effective way of monitoring/limiting disk
> >>space usage of
> >>a sites MySQL Database using the site allowed disk quota on a Raq4?
> >>
> >>Thanks in advance!
> >>______________________________
> >>
> >>
> <snip>
>
> the quota is counted by the system. You might check it with
>
> #> quota -uv username
>
> every file which is owned by a user - wherever it lays - will count. So
> the database file itself should be owned by the user, but this might be
> a problem for the mysql server who might not open it, if it is not owned
> as the mysql user or maybe will change it back. Never tryed it.
> So you might try it first with the test database:
>
> #> chown username:mysql  /var/lib/mysql/test  -R
>
> note that the database itself is a directrory with the tablefiles.
>
> all without warranty
>
> regards

I'm pretty sure that I read somewhere on the MySQL site advising against
doing that with symlinks, though I can't remember exactly where it was on
the site or the reason given why.

Phil


** http://www.diygear.com THE Online DIY Toolstore For DIY & Business
** Infolink Electronic Systems Ltd. http://www.infolinkelectronics.co.uk
** Professional Web Design & Cobalt Hosting Solutions
** Sun Cobalt iForce Reseller - Canon Silver Reseller
** Contact: Sales@xxxxxxxxxxxxxxxxxxxxxxxxx
** Tel / Fax 0121 458 4894 (office) 0121 441 3558 (home)