Heavy table in mysql

SELECT table_name AS "Table",
ROUND(((data_length + index_length) / 1024 / 1024), 2) AS "Size (MB)"
FROM information_schema.TABLES
WHERE (data_length + index_length) > 1000000  AND table_schema = "magento" 
ORDER BY (data_length + index_length) DESC;

Similar codes

0 vote334 views1 answer
Psql list view rules
SQL
1 vote404 views1 answer
Sql select row with max date
SQL
0 vote339 views1 answer
Mysql update table from select on another table
SQL
10 votes329 views2 answers
Sql rtrim
SQL
15 votes318 views2 answers
How to know the username of postgresql
SQL
1 vote345 views1 answer
Ora-01950 no privileges on tablespace
SQL
6 votes390 views1 answer
Oracle trigger after logon on database
SQL
1 vote352 views1 answer
Is sql fast
SQL
18 votes330 views2 answers
Find all tables containing column with specified name - MS SQL Server
SQL
2 votes346 views1 answer
Mysql clear screen
SQL