Get size of each database on a MySQL Server
Run the following command
SELECT table_schema AS "Database name", SUM(data_length + index_length) / 1024 / 1024 AS "Size (MB)" FROM information_schema.TABLES GROUP BY table_schema;
Source : http://makandracards.com/makandra/1447-list-sizes-of-mysql-databases
Was this post helpful?
Let us know if you liked the post. That’s the only way we can improve.