How to find the largest tables of a MySQL database?

See also: How to order MySQL databases by size?