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

9 votes104 views2 answers
Default number in sql
SQL
0 vote128 views1 answer
. ERROR! The server quit without updating PID file (/usr/local/var/mysql/MacBook-Pro-de-Quentin.local.pid).
SQL
0 vote124 views1 answer
Sql values not in another table
SQL
0 vote125 views1 answer
Trigger stock phpmyadmin
SQL
0 vote116 views1 answer
T sql return on letters only
SQL
0 vote119 views1 answer
Mysql exception output
SQL
9 votes129 views6 answers
Oracle substring
SQL
4 votes114 views1 answer
Oracle user tables
SQL
0 vote107 views1 answer
Mariadb maximum left join
SQL
0 vote113 views1 answer
Mysql subdate
SQL