How to get size of MySQL Databases - MySQL Developer Tutorial

Get Size of Schema or Database by using MySQL Workbench:


If you are using MySQL Workbench, then you can use Schema Inspector to check the size of Schema or Database in MySQL.  In Navigator pane, Go to SCHEMAS tab, Right click on the Schema and choose Schema Inspector. The very first tab is called "info" and it displays the schema size in Kilo bytes.

Get the Database size or Schema size in MySQL Workbench

Query to get Size of Databases in MySQL or MariaDB: 


MySQL database size can also be display by using System tables.  You can use below query to run on MySQL to get the size of all MySQL Databases.


SELECT table_schema "DB Name", SUM(data_length + index_length)/1024 AS "DB Size in Kilo Bytes", ROUND(SUM(data_length + index_length)/1024/1024, 1) "DB Size in MB" FROM information_schema.tables GROUP BY table_schema;



How to get the size of databases in MySQL | Get Databases size in MariaDB

2 comments: