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

0 vote133 views1 answer
Mysql sql select one day before
SQL
0 vote149 views1 answer
St_buffer mysql
SQL
3 votes135 views1 answer
Index using in query plsql
SQL
1 vote134 views1 answer
Join first name and last name sql
SQL
6 votes149 views1 answer
Oracle trigger after logon on schema
SQL
0 vote167 views1 answer
Convert sqlalchemy.util._collections to list of string
SQL
9 votes133 views2 answers
Get first 3 letters in sql
SQL
3 votes222 views1 answer
Sql add two values together
SQL
11 votes139 views4 answers
Query DISTINCT
SQL
-1 vote143 views1 answer
Raise ImproperlyConfigured('mysqlclient 1.3.13 or newer is required; you have %s.' % Database.__version__) django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.9.3.
SQL