Script to find MySQL table size
Script will report the table size of a MySQL table. You just need to provide the query with the name of the schema and the table name as well.
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"
AND table_name = "TABLE_NAME";
