External mysql and statistics

[unlo]

Hello!

Plesk 9.2.2, sles 10sp2

We are using external mysql server for our clients, and plesk statistics do not count size of that external databases.

Is it a bug?
How counts plesk statistics of databases??

 

[Nataliya Zagr]

Hello,

The reason of this behavior is the fact that Parallels Plesk Panel (PP) is not counting the disk usage at the external storage. You can verify it at the PP database with the help of the following query:

mysql> select dom_id,dbases from disk_usage limit 3;
+--------+--------+
| dom_id | dbases |
+--------+--------+
| 1 | 6144 |
| 2 | 4096 |
| 3 | 0 |
+--------+--------+
3 rows in set (0.01 sec)

Where dom_id is the id of the domain and dbases is the space that is occupied by the databases.

Thank you

 

[unlo]

So, plesk counts real size on disk.

Seems to be we are need to do a parser...

We are use that trick for mysql counting (sql query) :
select SUM(data_length+index_length) from information_schema.tables where table_schema = 'dbname';