Big 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

44 votes392 views6 answers
Rename command in sql
SQL
0 vote330 views1 answer
Sqlite update where exists
SQL
103 votes562 views1 answer
Like sql
SQL
0 vote352 views1 answer
Mysql match in serialized data
SQL
0 vote315 views1 answer
Wordpress sql find and replace
SQL
0 vote390 views2 answers
Mysql cast to varchar
SQL
1 vote332 views1 answer
Add constraint sql
SQL
0 vote347 views1 answer
Wincc 7.4 to sql stackoverflow
SQL
0 vote363 views1 answer
Sqlite get date only
SQL
-2 votes339 views1 answer
Group functions in sql
SQL