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!
Powered by vBulletin™ Version 4.0.0 Beta 4 Copyright © 2009 vBulletin Solutions, Inc. All rights