Code: Select all
SELECT table_schema "DATABASE 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 ; DB Name | Size in MB: 5.61689663 | Free Space in MB: 0.00012207
DB2 Name | Size in MB: 9.84901047 | Free Space in MB: 0.00001907
Considering its a busy website, I am little bit concerned about the free space. Is it something worth worrying about? If yes, when do you start thinking of moving from shared hosting to dedicated server?