Get Size of All Tables in a MySQL Database

A small query to retrieve the size per table 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
	table_schema = 'db_name'
ORDER BY
	(data_length + index_length)
	DESC;