Get the database size in MySQL

This article outlines the process of determining the size of a MySQL database and assessing the available free space within it.

Determine the database size:

Execute the following MySQL query to showcase the database name and its size in megabytes:

SELECT table_schema "DataBase", 
sum( data_length + index_length ) / 1024 / 1024 "DataBase Size in MB" 
FROM information_schema.TABLES 
GROUP BY table_schema ;

Determine the amount of available space:

Execute the subsequent query to observe the available free space in megabytes for a MySQL database.

SELECT table_schema "DataBase", 
sum( data_length + index_length ) / 1024 / 1024 "DataBase Size in MB",
sum( data_free )/ 1024 / 1024 "Free Space in MB"
FROM information_schema.TABLES
GROUP BY table_schema ;

Hope it worked !! 🙂