/SQL/Find largest table in mysql database

Find largest table in mysql database

SELECT table_schema as "Database", 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 
ORDER BY table_schema, (data_length + index_length) DESC

Similar codes

3 votes351 views3 answers
1396(hy00) mysql error
SQL
0 vote326 views1 answer
Cannot create a JSON value from a string with CHARACTER SET 'binary'.
SQL
1 vote355 views2 answers
Postgresql check privileges on schema
SQL
1 vote331 views2 answers
Remove space in mysql
SQL
2 votes331 views1 answer
Q operator in sql
SQL
0 vote334 views1 answer
C# get sql min date
SQL
0 vote316 views1 answer
Connect to ssms with python
SQL
0 vote376 views1 answer
Add two days to current date in sql when creating tables
SQL
0 vote343 views1 answer
Mysql vs sql server performance benchmark
SQL
2 votes322 views1 answer
Removing view
SQL