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 vote211 views3 answers
Insert query in ci
SQL
0 vote257 views1 answer
Postgres row expiration
SQL
0 vote188 views1 answer
Get yesterday date ISO in psql
SQL
5 votes192 views1 answer
Update sql user password
SQL
0 vote190 views1 answer
Oarcale list objects
SQL
1 vote206 views1 answer
Describe table in sql
SQL
28 votes291 views6 answers
Foreign key
SQL
0 vote264 views1 answer
Compare two tables to find unmatched records
SQL
0 vote198 views1 answer
Mysql max number not returning correct value
SQL
0 vote210 views1 answer
Insert into Select * - NAYCode.com
SQL