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

2 votes150 views1 answer
Coalesce sql
SQL
0 vote139 views1 answer
On sql table data exists
SQL
0 vote125 views1 answer
What are the aggregate function in sql
SQL
5 votes144 views6 answers
In operator sql
SQL
0 vote164 views1 answer
Day of the week sqlite
SQL
1 vote136 views1 answer
Sql server locks
SQL
0 vote114 views1 answer
Mysql sleep connections
SQL
0 vote140 views1 answer
How to convert external table to managed table in hive
SQL
0 vote143 views1 answer
What is database username and password in mysqliconnect
SQL
53 votes326 views6 answers
How to install mysql ubuntu
SQL