Check MySQL table size

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";

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.