sebastian.piskorski
sebastian.piskorski
Reputation Top 10%
sebastian.piskorski piskorski
1 Snippet  (541st place)
Published
1 Channel
Created
1 Channel
Following
31 points  (1130th place)
Reputation
Junior Code Generator
Junior Publisher
Junior Trend Maker
Junior Autobiographer
Senior Autobiographer
Master Autobiographer
Junior Famous Coder

Recent Snippets See all snippets by sebastian.piskorski

public by sebastian.piskorski  3686  3  5  2

[MySQL] Calculate Database size

[MySQL] Calculate Database size using simple single query.
SELECT table_schema "Data Base Name",
    sum( data_length + index_length ) / 1024 / 1024 "Data Base Size in MB",
    sum( data_free )/ 1024 / 1024 "Free Space in MB"
FROM information_schema.TABLES
GROUP BY table_schema ;
;