Database size

Ye' old general discussion board. Basically, for everything that isn't covered elsewhere. Come here to shoot the breeze, shoot your mouth off, or whatever suits your fancy.
This forum is not for asking programming related questions.

Moderator: General Moderators

Post Reply
wasir
Forum Commoner
Posts: 49
Joined: Sun Jul 08, 2007 11:28 pm

Database size

Post by wasir »

I tested my database size using query:

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 ; 
and got result:
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?
alex.barylski
DevNet Evangelist
Posts: 6267
Joined: Tue Dec 21, 2004 5:00 pm
Location: Winnipeg

Re: Database size

Post by alex.barylski »

When your shared server can no longer keep up with the requests, it varies in every situation.
Post Reply