Big 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 vote266 views1 answer
The differnece between to values in sql
SQL
4 votes146 views1 answer
T-sql get duplicate rows
SQL
1 vote157 views1 answer
Postgres power
SQL
1 vote144 views2 answers
Foreign key set 0
SQL
1 vote141 views1 answer
Sql first day quarter
SQL
0 vote132 views2 answers
Psql commande \gset
SQL
0 vote133 views1 answer
Hibernate show sql xml property
SQL
0 vote132 views1 answer
How to add session data into mysql database from button
SQL
0 vote139 views1 answer
How to connect to mysql in ef 6
SQL
0 vote130 views1 answer
How to drop columns with constraint from a table in sql script
SQL