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

11 votes344 views4 answers
Round in sql
SQL
0 vote368 views1 answer
Sqlalchemy one column of two has to be not null
SQL
13 votes371 views1 answer
Fetch first 5 rows in oracle sql developer
SQL
19 votes344 views2 answers
Mysql add column after another
SQL
0 vote386 views1 answer
Postgresql la fonction dblink_connect(unknown, unknown) n'existe pas
SQL
0 vote379 views1 answer
Find the names of sailors who have reserved at least one boat
SQL
1 vote394 views2 answers
Postgresql check privileges on schema
SQL
0 vote374 views1 answer
Drop database using terminal postgres
SQL
3 votes348 views1 answer
Mssql remove column
SQL
0 vote349 views1 answer
User, group, or role 'open' already exists in the current database.
SQL