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

0 vote262 views1 answer
Flask_sqlalchemy install
SQL
0 vote301 views1 answer
Mysql_union
SQL
20 votes302 views4 answers
Reset auto increment in MySQL
SQL
1 vote298 views1 answer
Oracle aleter trigger ora-01031
SQL
0 vote331 views1 answer
Hibernate dialect property xml for mysql 8
SQL
0 vote325 views1 answer
SQL Where-Klausel
SQL
0 vote322 views1 answer
Postrgres trunc
SQL
0 vote343 views1 answer
Get role postgres
SQL
15 votes292 views2 answers
How to know the username of postgresql
SQL
0 vote343 views1 answer
Dataframe lambda elif
SQL