Hi,
(10-07-2008 05:42 AM)zmediaguru Wrote: Has anyone worked on a modification to use a MySQL query replace the 'du' function for counting database size?
This is already implemented in the ispCP engine if I'm right. You have to change in
/var/www/ispcp/engine/quota/ispcp-dsk-quota the line 370:
Code:
$rs = mysqldb_quota_by_dir_engine();
to
Code:
$rs = mysqldb_quota_by_mysql_engine();
By doing so you switch from retrieving the space used by mysql-dbs from the 'du'-procedure to a method depending only on mysql queries.
I haven't tested this since I don't use another MySQL server, but IMHO it should work.
Regards
FeG