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 vote169 views1 answer
Tsql pad left
SQL
1 vote169 views1 answer
Mysql select if empty result
SQL
0 vote174 views1 answer
SQL Query to delete all the tables in a database
SQL
8 votes150 views1 answer
Today minus 15 days postgresql
SQL
0 vote175 views1 answer
Postgres full text search example
SQL
0 vote166 views1 answer
Sql server concat null
SQL
0 vote150 views1 answer
Create table if not exist with exceptions
SQL
7 votes159 views1 answer
Connect mysql docker
SQL
0 vote154 views1 answer
Sql tabelle erstellen
SQL
0 vote154 views4 answers
User defined function sql
SQL