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 vote236 views1 answer
Sql oracle update multiple rows
SQL
0 vote171 views1 answer
Search starting with mysql
SQL
4 votes217 views2 answers
DB::transaction
SQL
0 vote184 views1 answer
Sql server roles and users
SQL
0 vote221 views2 answers
How to truncate all table in mysql workbench
SQL
1 vote173 views1 answer
Mysql list bigger table
SQL
0 vote215 views1 answer
After kill process Failed to start mysqld.service: Unit mysqld.service not found.
SQL
0 vote178 views1 answer
Is there a way to use read_sql_query and the query has WHERE column = Variable?
SQL
4 votes218 views1 answer
Fatal error: libpq-fe.h: No such file or directory
SQL
2 votes170 views1 answer
Sql server case sensitive search
SQL