Attempt to compute the physical size of databases / tables

physical_size.sql

SELECT
   TABLE_SCHEMA AS 'Database',
   TABLE_NAME AS 'Table',
   ROUND(((DATA_LENGTH + INDEX_LENGTH) / 1024 / 1024), 2) 'Size in MB'
FROM information_schema.TABLES
WHERE
   TABLE_SCHEMA = '<database_name>'
   AND TABLE_NAME = '<table_name>'
ORDER BY (DATA_LENGTH + INDEX_LENGTH) DESC;