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 vote117 views1 answer
Check psql validity function
SQL
0 vote112 views1 answer
Oracle sql log to console
SQL
8 votes108 views3 answers
Alter table auto_increment
SQL
8 votes125 views1 answer
Declare table variable sql server
SQL
0 vote116 views1 answer
Oracle sql winter time change
SQL
4 votes129 views1 answer
Conda install sqlalchemy
SQL
3 votes207 views4 answers
Sql interview questions
SQL
0 vote124 views1 answer
Sql server isnull function nor working count
SQL
0 vote110 views1 answer
Postrgres trunc
SQL
0 vote134 views1 answer
Including parameters in OPENQUERY
SQL