PDA

View Full Version : Space Requirement Question



silentdub
Sun 8th Feb '09, 10:38pm
I already purchasd the vbulletin software, I am putting some feelers out for a host.

I am planning on a small forum, about 5 or 6 message areas. I am not sure that I will host pics as of yet.

What size SQL DB should I be requesting? I know it will start off small, I just don't know what to expect.

I see that most places give you 100MB on up, I think 100MB is small, but what do I know.

Can anyonehelp me out with some stats?

I took a quick look at this site:
Threads: 288,979, Posts: 1,652,367, Members: 202,829, Active Members: 8,232

Close to 300,000 threads, 1.6 mil posts I can't see getting that big in the next 3 years, so what size DB is this site using?

peterska2
Mon 9th Feb '09, 12:50am
How much MySQL disk space is used is highly dependent on the type of forum you run, and factors such as:
- Your average allowed attachment and avatar size
- How many attachments and avatars you have stored in your vBulletin database
- How many private messages you have stored in your vBulletin database from members
- How many posts and threads you have and the size and variables you have set for your searchindex
- How many members you have
- How many forums you have
And so on and so forth.

For example, one installation we have seen had 5,800+ members, 40,000 threads, 662,000 posts, 70,000 private messages and 8,000 attachments. The total MySQL database size was 940MB - which comes to around 140MB per 100,000 posts. Please note that it does vary from forum to forum, so your mileage may vary.

silentdub
Mon 9th Feb '09, 12:47pm
How much MySQL disk space is used is highly dependent on the type of forum you run, and factors such as:
- Your average allowed attachment and avatar size
- How many attachments and avatars you have stored in your vBulletin database
- How many private messages you have stored in your vBulletin database from members
- How many posts and threads you have and the size and variables you have set for your searchindex
- How many members you have
- How many forums you have
And so on and so forth.

For example, one installation we have seen had 5,800+ members, 40,000 threads, 662,000 posts, 70,000 private messages and 8,000 attachments. The total MySQL database size was 940MB - which comes to around 140MB per 100,000 posts. Please note that it does vary from forum to forum, so your mileage may vary.

Perfect, that is what I was looking for. I know that I can always upgrade, but I don't want to opt for 100MB SQL, and be full in a month.

The example you have provided, I don't see being the case for years.

Thanks again!