Tag: MySQL

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;