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

7 votes371 views1 answer
Oracle pagination query offset
SQL
2 votes354 views1 answer
Import large .sql files into lampp
SQL
2 votes439 views5 answers
Tablespace ORACLE
SQL
0 vote355 views1 answer
Pgadmin see indexes
SQL
1 vote363 views1 answer
Trigger in postgresql to change incoming entry
SQL
0 vote366 views1 answer
Symfony\Component\Debug\Exception\FatalThrowableError : Class 'Doctrine\DBAL\Driver\PDOSqlite\Driver' not found
SQL
1 vote376 views1 answer
Oracle avg
SQL
0 vote375 views1 answer
Update having mysql
SQL
0 vote356 views1 answer
Initcap in mysql
SQL
0 vote365 views1 answer
After kill process Failed to start mysqld.service: Unit mysqld.service not found.
SQL