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

[Goetz Lohmann <goetz.lohmann@xxxxxx>]

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