Mysql Database Size -> Disk Usage

[kvaes]

Is the mysql database counted as Disk usage too? Cause users can use the database as a workaround for disk quota's then...

[BeNe]

I don´t think so. The My-ISAM Files are in other Diretories so i mean that they are not counted. But i´m not sure.

Greez BeNe

[kvaes]

BeNe Wrote:I don´t think so. The My-ISAM Files are in other Diretories so i mean that they are not counted. But i´m not sure.

Greez BeNe

but... let's say phpMyAdmin is capable of telling the size of a database
ispcp knows which database belongs to which user, so it should be possible?
(long run attempt?)

[kvaes]

http://www.modwest.com/help/kb6-199.html

apparently thru "show table status"

[raphael]

AFAIR it also checks the disk usage of the mysql data files

[ephigenie]

some time ago i found a possible solution to set a quota for mysql :

http://www.isp-control.net/ispcp/wiki/my...ota_script

[kvaes]

looks good, but how handle the quota's I guess? shutdown, or more on an administrative note
(give the isp the chance to bill, without downtime for the user)

another thing I was wondering, what about the mailboxes?
is there a way to stop a user from creating an mailbox with a size of N GigaByte?




sorry for the questions, been functionality testing ispcp for my own webhosting
I like it a lot, but I was missing these things
(and I don't know if they are available in the commercial variants, so don't shoot me for that) :-)

[kvaes]

just checked the whishlist, it's on there... (both mysql & mail)
so I guess my questions were posted too soon

going further thru the wishlist:
Are there any specifications on what the billing gui should do? Or is there already development started on that one?

[raphael]

Just verified the mysql quota thing. Currently the check is performed by checking the disk space used by the database data files. There seems to be an other implementation of mysql quota which queries the mysql server, but personally I prefer the former.
There's a hack for VHCS for mail quota: http://vhcs.puuhis.net/wiki/index.php/Ma...lternative

Maybe I could try to do something like that

[ephigenie]

the script i meant which is querying the server is a lot better because it restricts further growing of the database if the quota is exceeded.

And thats what quotas are for

Yeah just checking the database size is nice and take it into account - but
instead of the webspace where the user is limited by proftpd he can grow its database to gigabytes ...