Tuesday, August 18, 2009

Show MySQL databases size

Counting all databases size in MySQL - original posted here.
select table_schema "Database",
sum( data_length + index_length ) / 1024 / 1024 "Size (MB)",
sum( data_free )/ 1024 / 1024 "Free (MB)"
from information_schema.tables
group by table_schema;

No comments: