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 votes229 views1 answer
Identity insert on sql server
SQL
0 vote246 views2 answers
How to install psql in ubuntu
SQL
1 vote199 views1 answer
How to drop function in sql
SQL
-1 vote199 views5 answers
Online sql to linq generator
SQL
0 vote187 views1 answer
Postgres call view
SQL
3 votes205 views1 answer
Oracle revoke
SQL
1 vote189 views1 answer
Group_concat max length mysql
SQL
0 vote202 views1 answer
Sql server user permissions and roles
SQL
3 votes197 views3 answers
Update join
SQL
0 vote217 views2 answers
Plpgsql
SQL