How to Get All Databases Size from MySQL Server

Get all Databases size from MySQL Server

SELECT table_schema "Database Name", 
 Round(Sum(data_length + index_length) / 1024 / 1024, 1) "Size (MB)" 
FROM information_schema.tables 
GROUP BY table_schema;

Leave a Reply

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