How to find big tables of a MySQL database?

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;

stackoverflow.com/a/9620273

See also: How to order MySQL databases by size?