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 vote192 views4 answers
Get week day from date in sql
SQL
0 vote210 views1 answer
Mssql find deadlocks
SQL
1 vote183 views1 answer
Sql select where id not exists in another table
SQL
0 vote187 views1 answer
Every Derived yable must have its own alias
SQL
3 votes183 views4 answers
Show databases in sql server
SQL
1 vote173 views1 answer
Adding indexing on a db model in mysql using sequelize
SQL
3 votes184 views1 answer
Get current month last date in sql server
SQL
0 vote171 views1 answer
Sql server obtener nombre sin espacios en blanco
SQL
0 vote325 views2 answers
Https://cloud.google.com/shell/docs/using-web-preview#previewing_the_application
SQL
0 vote185 views1 answer
Rename view mysql
SQL