Breaking News: Grepper is joining You.com. Read the official announcement!

mysql select table order by size

vickzkater answered on July 23, 2023 Popularity 2/10 Helpfulness 3/10

answer mysql select table order by size

mysql select table order by size

Comment

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"
ORDER BY (data_length + index_length) DESC;

# Note: Replace schema_name above with the name of your database

Popularity 2/10 Helpfulness 3/10 Language sql

Source: stackoverflow.com

Tags: mysql select size sql

Link to this answer
Share Copy Link