Heavy 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

0 vote232 views1 answer
Sqlite closes value
SQL
0 vote226 views1 answer
Postgres where
SQL
20 votes227 views4 answers
Reset auto increment in MySQL
SQL
0 vote252 views1 answer
Enable outgoing remote MySQL access
SQL
0 vote247 views1 answer
Port 5432 is already in use Usually this means that there is already a PostgreSQL server running on your Mac. If you want to run multiple servers simultaneously, use different ports.
SQL
3 votes224 views1 answer
Search for column name in psql
SQL
9 votes235 views2 answers
Convert data type in sql
SQL
0 vote262 views1 answer
Check constraint is violated
SQL
0 vote231 views1 answer
Drop constraint in ms sql
SQL
5 votes248 views1 answer
How to get all dates in a month in oracle
SQL