Database size in MySQL

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 :

Db-size.gif

Next Recommended Reading Reduce Size Of MS Access DataBase