Return to Snippet

Revision: 12180
at March 4, 2009 22:15 by zingo


Initial Code
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;

Initial URL
http://axonflux.com/useful-query-mysql-table-index

Initial Description
Show table size, number of rows, and size of indexes in MySQL.

Initial Title
MySQL table size, number of rows, and size of indexes

Initial Tags
mysql, sql

Initial Language
MySQL