I'm curious about the database size that some of you have. Could you please list the size of your database along with the number of posts, threads and members you have? I've only administered fairly small boards until now and the biggest database I ever got was only 50 MB.
Database Size
Collapse
X
-
around
854k posts
54k thread
110k private messages
12k attachments at av 36kb size
7880+ members
= 1.3GB:: Always Back Up Forum Database + Attachments BEFORE upgrading !
:: Nginx SPDY SSL - World Flags Demo [video results]
:: vBulletin hacked forums: Clean Up Guide for VPS/Dedicated hosting users [ vbulletin.com blog summary ] -
6,075 members
21,391 threads
253,562 posts
7,476 PMs
no attachments
= 178MB
Seach index @ 3 letter words minimum
= 90MB
Total 261MB
www.ausforum.comComment
-
Total: 656.1 MB
379mb (8000+) attachments
29k threads
700k+ postsHP DL-380 G6, 2x E5520, 28GB RAM, 4x300GB SAS, VMWare ESXi
- Unreal Tournament : Assault forums - irc://irc.utassault.net:6667 -
Comment
-
164,950 posts
5,197 PM's
926 attachments
136,962 searchable words
1,550,111 search index records
145.7mb (145.4 after an optimize...)
Off Topic CentralComment
-
1.9 million posts (deleted 300k)
39,000 members (deleted 17k)
300k PMs
0 attachments
0 searchindex
=
1680 mb database
880 mb indices
15 mb avatarsvB Retro -> See vBulletin 1.1.2 and travel back to the Year 2000!
Overgrow the Government: The Edge Forums
presented by Overgrow Marijuana Magazine
*warning: adult content since vB1.1... now faster than ever!Comment
-
Database Data Usage: 84.46 MB
Database Index Usage: 18.54 MB
Attachment Usage: 15.31 MB (Deleted 30-MB)
Custom Avatar Usage: 0.96 MB
Members: 738, Threads: 8,726, Posts: 80,875MCSE, MVP, CCIE
Microsoft Beta Team
Comment
-
Originally posted by 0ptimaHow did you guys purge parts of your attachement table? An sql query by date? Any referential integrity problems?
Since MySQL, doesn't have referential integrity, there really can't be any problems. The biggest thing that would happen is a post wouldn't show up depending on how the query is run.Translations provided by Google.
Wayne Luke
The Rabid Badger - a vBulletin Cloud demonstration site.
vBulletin 5 APIComment
-
Members: 6,870
Threads: 9,153
Posts: 73,069
Custom Avatar Usage: 1.13 MB
Attachment Usage: 11.95 MB
Total Database Size: 89.76 MBComment
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Comment