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

1 vote162 views2 answers
Mysql type conversion
SQL
0 vote165 views1 answer
Date on SQL
SQL
3 votes177 views2 answers
Postgresql remove not null constraint
SQL
0 vote175 views1 answer
Set column in all row mysql
SQL
2 votes169 views1 answer
Oracle kill session by sql_id
SQL
0 vote174 views1 answer
Mysql not defined
SQL
9 votes162 views2 answers
Oracle all tables in schema
SQL
6 votes154 views4 answers
Sqlite drop table
SQL
0 vote164 views1 answer
Copied text from internet not inserting in mysql
SQL
0 vote179 views1 answer
Ajax error exception handeling
SQL