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

5 votes81 views1 answer
Postgres upsert
SQL
9 votes139 views3 answers
Postgres make sql dump
SQL
1 vote121 views1 answer
Sample in sql
SQL
0 vote142 views1 answer
Sql date with year
SQL
3 votes103 views1 answer
Mysql CURRENT_TIMESTAMP()
SQL
5 votes115 views2 answers
Postgre insert select
SQL
0 vote114 views1 answer
OFFSET consulta mysql
SQL
0 vote128 views2 answers
Clauses in mysql
SQL
0 vote119 views1 answer
Postgres drop type
SQL
18 votes113 views6 answers
Laravel form validation
SQL