MySQL Disk Utilisation
The disk utilisation log can be found in the log directory, under the respective parent server name, and dated for each day:
Eg.
/microcloud/logs_ro/stack1/disk-mysql-2015-08-10.log.gz
It provides a breakdown of total utilsation, followed by a list of usage per database, and the largest tables within those.
Eg.
**********************
* Current Disk Usage *
**********************
Size Used Avail Use% Mounted
115G 45G 65G 41% mysql
**********************
* Usage Per Database *
**********************
Database Size (MB)
======== =========
demo 19.19681549
mysql 0.63944721
munin_innodb 0.01562500
information_schema 0.00878906
performance_schema 0.00000000
*****************************************
* Largest Tables for Largest 1 Database *
*****************************************
Database Table Size (MB)
======== ===== =========
demo ampersand_integration_message_identifier 10346.00
demo ampersand_integration_flag 4969.75
demo sales_flat_quote_address 2348.70
demo catalog_product_index_price_cl 2075.00
demo sales_flat_quote_item_option 1952.72