How to find big tables of a MySQL database?

MySQL
,
1 
SELECT
	table_name AS `Table`
	,round(((data_length + index_length) / 1024 / 1024), 2) `Size in MB`
FROM information_schema.TABLES
WHERE '<database>' = table_schema
ORDER BY (data_length + index_length) DESC
LIMIT 20;

stackoverflow.com/a/9620273

2

See also: How to order MySQL databases by size?

3

How to find big tables of a PostgreSQL database?