MySQL : Find databases size

By | October 23, 2014

In this post we will know how to find out the databases size in the MySQL server.

MySQL Select Query to find database sizes :-

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

The above query will list out all the database names and the sizes in MB which are in the MySQL Server. The output will be as shown below

In SQLYog editor :-

databases size

 

 

Leave a Reply

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