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

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

Choose a language for easy browsing: