Get size of table in MB

Get size of your database tables in MB

Description

Inspired by this stackoverflow post, you can use the following snippet to get the size of your db tables:

SELECT 
    table_name AS `Table`, 
    round(((data_length + index_length) / 1024 / 1024), 2) `Size in MB` 
FROM information_schema.TABLES 
WHERE table_schema =<SCHEMA>