Database size in MySQL

We have to find out our database size with the help of this query.

The following select command we will use for finding out the database size :

SELECT
table_schema AS 'operater',
Round( Sum( data_length + index_length ) / 1024 / 1024, 3 ) AS 'Db Size (MB)',
Round( Sum( data_free ) / 1024 / 1024, 3 ) AS 'Free Space (MB)'
FROM information_schema.tables
GROUP BY table_schema ;

Explanation:

In the above query we have to use the select command, where 'operater' is the database name

Output :