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 vote172 views3 answers
Sql union
SQL
0 vote163 views1 answer
Snap craft
SQL
0 vote162 views1 answer
Console output pl sql
SQL
0 vote168 views1 answer
What is SQL data store?
SQL
0 vote242 views1 answer
Mysql equivalent decode oracle
SQL
3 votes156 views2 answers
To_char oracle
SQL
0 vote257 views1 answer
How to get table current identity value in sql server
SQL
5 votes184 views3 answers
String concatenation sql server
SQL
5 votes171 views4 answers
Select random rows sql
SQL
3 votes161 views2 answers
Sql server current date without time
SQL