+- ispCP - Board - Support (http://www.isp-control.net/forum)
+-- Forum: ispCP Omega Development Area (/forum-1.html)
+--- Forum: General discussion (/forum-11.html)
+--- Thread: Mysql Database Size -> Disk Usage (/thread-1056.html)
Mysql Database Size -> Disk Usage - kvaes - 07-27-2007 12:32 AM
Is the mysql database counted as Disk usage too? Cause users can use the database as a workaround for disk quota's then...
RE: Mysql Database Size -> Disk Usage - BeNe - 07-27-2007 01:01 AM
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
RE: Mysql Database Size -> Disk Usage - kvaes - 07-27-2007 01:29 AM
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?)
RE: Mysql Database Size -> Disk Usage - kvaes - 07-27-2007 01:35 AM
http://www.modwest.com/help/kb6-199.html
apparently thru "show table status"
RE: Mysql Database Size -> Disk Usage - raphael - 07-27-2007 05:44 AM
AFAIR it also checks the disk usage of the mysql data files
RE: Mysql Database Size -> Disk Usage - ephigenie - 07-27-2007 05:50 AM
some time ago i found a possible solution to set a quota for mysql :
http://www.isp-control.net/ispcp/wiki/mysql_quota_script
RE: Mysql Database Size -> Disk Usage - kvaes - 07-27-2007 05:55 PM
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) :-)
RE: Mysql Database Size -> Disk Usage - kvaes - 07-27-2007 06:51 PM
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?
RE: Mysql Database Size -> Disk Usage - raphael - 07-28-2007 04:37 AM
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/Mail_quota_alternative
Maybe I could try to do something like that
RE: Mysql Database Size -> Disk Usage - ephigenie - 07-28-2007 05:25 AM
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 ...