Tagged: innodb data size

MySQL Table Engine Data Usage statistics

Came across a useful MySQL query at themattreid.com blog to use MySQL information_schema to calculate MySQL table engine data usage statistics for Innodb and MyISAM. select round(sum(innodb_data_size + innodb_index_size) / (innodb_data_free + sum(innodb_data_size + innodb_index_size))) * 100 as ‘innodb_tablespace_utilization_perc’ , (data_size + index_size) / gb as total_size_gb , index_size /...