MySQL: Script to check the size of Database and Tables

This article is half-done without your Comment! *** Please share your thoughts via Comment ***

In this post, I am sharing a script for checking the size of Database and Tables in MySQL.

MySQL: Script to find total occupied Size of each Storage Engines

MySQL: Script to find Largest Databases size on Server

Find the size of Database:

SELECT

table_schema AS Database_Name

,ROUND(SUM(data_length + index_length) / 1024 / 1024, 1) AS SizeInMB

FROM information_schema.tables

GROUP BY table_schema

Find the size of Table:

SELECT

table_name AS TableName

,ROUND(((data_length + index_length) / 1024 / 1024), 2) AS SizeInMB

FROM information_schema.TABLES

WHERE table_schema = 'Database_NAME'

AND table_name = 'Table_Name'

Sep 17, 2018Anvesh Patel

Database Engineer