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 vote126 views1 answer
Postgresql combine values in one field
SQL
5 votes146 views1 answer
Oracle sysdate - 1 month
SQL
23 votes165 views6 answers
Create table sql
SQL
1 vote161 views1 answer
Wordpress change url phpmyadmin
SQL
0 vote127 views1 answer
Mysql export search results
SQL
1 vote106 views1 answer
Denied
SQL
0 vote127 views1 answer
Wincc 7.4 to sql stackoverflow
SQL
0 vote131 views1 answer
Why mysql is used?
SQL
0 vote235 views2 answers
Reduce size of SQL server log file truncate - Source :NAYCode.com
SQL
0 vote128 views1 answer
Postgres list tables and row counts
SQL