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 vote146 views1 answer
Why we have to set the password for my sql server
SQL
3 votes149 views2 answers
Mysql time
SQL
0 vote157 views1 answer
Narural join
SQL
7 votes152 views3 answers
Sql fill table with info from anothe rtable
SQL
11 votes155 views6 answers
Distinct sql
SQL
0 vote193 views1 answer
Mysql extract day from date leading zero
SQL
2 votes143 views1 answer
Mysql sysdate
SQL
1 vote160 views1 answer
Ubuntu mysql cannot connect to database server remote
SQL
27 votes274 views3 answers
Mysql delete row
SQL
6 votes161 views3 answers
Sql select last id
SQL