sebastian.piskorski
sebastian.piskorski
Reputation Top 10%
sebastian.piskorski piskorski
1 Snippet  (538th place)
Published
1 Channel
Created
1 Channel
Following
31 points  (1127th 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  3674  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 ;
;