Find MySQL Database and Table Size
To find size of database using SQL command, run following SQL in MySQL promt.
|
1 |
SELECT table_schema AS "Database", ROUND(SUM(data_length + index_length) / 1024 / 1024, 2) AS "Size (MB)" FROM information_schema.TABLES GROUP BY table_schema; |
Example
FInd disk usage by tables
To find disk usage by tables in database, run
|
1 |
SELECT table_name AS "Table", round(((data_length + index_length) / 1024 / 1024), 2) as "size (MB)" FROM information_schema.TABLES WHERE table_schema = "DB_NAME_HERE" ORDER BY data_length DESC; |
In above SQL, replace DB_NAME_HERE with actual name of the database.
Example
|
1 |
SELECT table_name AS "Table", round(((data_length + index_length) / 1024 / 1024), 2) as "size (MB)" FROM information_schema.TABLES WHERE table_schema = "xogifts_db" ORDER BY data_length DESC; |
See MySQL