Index size of a mysql database

-1

What would be the structure of a query to get the total size in MB of all index of the tables of a certain banco de dados in mysql ?

    
asked by anonymous 03.11.2016 / 11:28

1 answer

1

See this:

select database_name, table_name, index_name, stat_value*@@innodb_page_size
from mysql.innodb_index_stats where stat_name='size';

This is also interesting:

SELECT concat(table_schema,'.',table_name),
concat(round(table_rows/1000000,2),'M') rows,
concat(round(data_length/(1024*1024*1024),2),'G') DATA,
concat(round(index_length/(1024*1024*1024),2),'G') idx,
concat(round((data_length+index_length)/(1024*1024*1024),2),'G') total_size,
round(index_length/data_length,2) idxfrac 
FROM information_schema.TABLES 
ORDER BY data_length+index_length DESC LIMIT 20;

link

    
03.11.2016 / 12:00