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

2 votes157 views1 answer
Postgresql drop primary key constraint
SQL
0 vote132 views1 answer
SQL division of an integer by another integer get float CAST
SQL
3 votes152 views1 answer
How to check schema privileges in oracle
SQL
0 vote163 views1 answer
How to change mysql root password in windows 10
SQL
0 vote148 views1 answer
Renommer table sql
SQL
0 vote158 views1 answer
Select a row include list of array with join table SQL
SQL
1 vote158 views1 answer
Postgres get month name from date
SQL
0 vote177 views1 answer
Nodejs sql get one to many relationship as array
SQL
0 vote185 views1 answer
Postgres truncate with cascade
SQL
0 vote179 views1 answer
What are the advantages of MySQL when compared with Oracle?
SQL