4 February 2011

MySQL Tables Sizes

SELECT table_name, round(((data_length + index_length) / (1024*1024)), 2) AS "Size (MiB)" FROM information_schema.tables WHERE table_schema = "your_schema_name";

No comments: