Resolved Where can I find server global statistics?

[lola]

Hi there,

I use plesk 12.5 on a linux machine. Is there any possibility (option in plesk) where I can check the used database disk space? I mean not the used database disk space of each abonnement. I mean the server global diskspace. I only find a note that shows the hole used disk space (inkl. mail, web, database, logs and so on).

 

[IgorG]

You can use something like this:

mysql> SELECT table_schema "Data Base Name", sum( data_length + index_length ) / 1024 / 1024 "Data Base Size in MB" FROM information_schema.TABLES GROUP BY table_schema;
+-------------------------+----------------------+
| Data Base Name | Data Base Size in MB |
+-------------------------+----------------------+
| apsc | 0.84375000 |
| horde | 5.81250000 |
| information_schema | 0.00781250 |
| mysql | 0.62958336 |
| phpmyadmin_hq02okHSZJg5 | 0.04296875 |
| psa | 6.81250000 |
| roundcubemail | 0.46875000 |
| sitebuilder5 | 0.74562263 |
| wordpress_2 | 0.68750000 |
+-------------------------+----------------------+
9 rows in set (0.28 sec)

 

[lola]

Hi Igor,

thanks for your hint. This isn't comfortable, but it works.