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 vote229 views1 answer
How to find the most occuring in SQL
SQL
21 votes244 views6 answers
Change column in mysql
SQL
1 vote261 views2 answers
Mysql extract number from string
SQL
0 vote229 views1 answer
Query to insert image
SQL
0 vote271 views1 answer
Mysql get nth highest
SQL
0 vote219 views1 answer
Mysql database is not starting in xampp
SQL
0 vote226 views1 answer
How to avoid duplicate records in sqlite
SQL
1 vote250 views1 answer
Avg mysql
SQL
1 vote236 views1 answer
Postgresql blocked on mac
SQL
0 vote230 views1 answer
Json not contains mysql
SQL