Get Size of Tables or Database in MySQL

Primary tabs

Submitted by geoff on Wed, 2012-01-04 02:19

Get Size of Tables in a single MySQL Database

For a given "schema_name" (aka database)

SELECT table_name, table_rows, data_length, index_length,
round(((data_length + index_length) / 1024 / 1024),2) "Size in MB"
FROM information_schema.TABLES
WHERE table_schema = "schema_name";

Get Total size of MySQL Databases

SELECT table_schema "Data Base Name",
    sum( data_length + index_length) / 1024 / 1024
    "Data Base Size in MB"
FROM information_schema.TABLES
GROUP BY table_schema ;

Tags:

Your IP Info

IP Address Locator

Speed Test

Test how fast your Internet connection really is.

DropBox

Use this link to get DropBox http://db.tt/iQHWaaF