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

4 votes234 views1 answer
Refresh postgres config
SQL
0 vote188 views1 answer
Sql truncate table referencing itself
SQL
0 vote222 views1 answer
Drop specific row postgresql
SQL
2 votes249 views2 answers
Postgres change owner of schema
SQL
0 vote183 views1 answer
Hangfire clean script
SQL
4 votes222 views1 answer
Adding data to table in sql python
SQL
0 vote221 views1 answer
Show create table in postgresql
SQL
2 votes232 views6 answers
Mysql change timezone
SQL
28 votes238 views6 answers
Mysql change user password
SQL
5 votes243 views2 answers
Sql number columns
SQL