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

1 vote199 views1 answer
Get create table query existing table mysql
SQL
28 votes155 views6 answers
Distinct sql
SQL
0 vote196 views1 answer
Mysql installer did not find packages in the current bundle suitable for installation
SQL
0 vote239 views2 answers
Soql last year
SQL
0 vote202 views1 answer
Count characters of string mysql
SQL
1 vote245 views1 answer
Psql search table
SQL
2 votes251 views3 answers
How to replace null values in sql
SQL
1 vote241 views1 answer
Select not matching data with join table
SQL
3 votes221 views5 answers
No module named 'MySQLdb'
SQL
1 vote179 views1 answer
Deleting database in sql
SQL