Posted By

zingo on 03/04/09

Tagged

mysql
sql

Versions (?)

Last Edited at 03/04/09 10:15pm

Statistics

Viewed 1162 times

Favorited by 1 user(s)

Related snippets

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

/ Published in: MySQL

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

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

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;