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 vote339 views1 answer
Sql delete row from table where id
SQL
1 vote384 views1 answer
Sql view where tables have same column name combine results
SQL
0 vote344 views1 answer
How to do a function to return row type from a table in pl/sql
SQL
3 votes344 views1 answer
Oracle revoke grant
SQL
0 vote378 views3 answers
CONTACT FORM SQL
SQL
0 vote354 views1 answer
Postgres drop type
SQL
3 votes326 views1 answer
Sql multiple column index
SQL
0 vote345 views1 answer
Hibernate xml property MySQL url, username and password
SQL
4 votes355 views2 answers
Mysql how to change default charset
SQL
0 vote349 views1 answer
Sql find leading space
SQL