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 vote188 views1 answer
Ef core 5.0 usesqlserver not found
SQL
0 vote198 views1 answer
Recently updated stored procedure in sql server
SQL
5 votes197 views1 answer
Sysdate in oracle sql
SQL
15 votes237 views5 answers
Show tables in oracle
SQL
1 vote135 views1 answer
Postgres division by zero
SQL
2 votes142 views1 answer
Sql float to int
SQL
0 vote201 views1 answer
Hierarchal database table
SQL
0 vote188 views1 answer
Get the previous column of a table in mysql
SQL
2 votes199 views1 answer
Apex execute batch job
SQL
5 votes185 views2 answers
Sql create tabel with primary key auto_increment code
SQL