So, I don't normally post or ask questions. Generally I tinker and fiddle with things until I figure them out. This one, however, has mystified me for awhile. I own a website that utilizes Vbulletin 4.2.2 ( http://www.rpgchat.com/ ). We are a website dedicated to creative writing, roleplaying, and other play by post style cooperative writing. This essentially means that most of the posts on my website need to stay there (they hold memories for a lot of people as well as being used in later writings).
My issue, however, is the fact that my Vbulletin Database is approached 8 GB in size. I've installed VBOptimize, which does wonders for it and really assisted with migrating attachments, avatars, and the like OUT OF my database and into APC (Alternate PHP Caching system).
I've pruned the members that joined older than 365 days with 0 posts, and I've also deleted members older than 1,825 days with less than 10 posts who haven't logged in since their last post. I've also pruned all the threads that I can get away with without incurring the wrath of my user base.
With all this in mind, is there any alternative ways for me to continue to shrink my database size? Any tricks, etc?
As it stands, my site has gotten so big and requires so many resources, that it is rendered unusable on any system with less than 8 GB of RAM (my forum is hosted off of a dedicated server, not a shared server). I was wondering what my options are for making a 13+ year old forum database smaller?
Thank you in advance.
My issue, however, is the fact that my Vbulletin Database is approached 8 GB in size. I've installed VBOptimize, which does wonders for it and really assisted with migrating attachments, avatars, and the like OUT OF my database and into APC (Alternate PHP Caching system).
I've pruned the members that joined older than 365 days with 0 posts, and I've also deleted members older than 1,825 days with less than 10 posts who haven't logged in since their last post. I've also pruned all the threads that I can get away with without incurring the wrath of my user base.
With all this in mind, is there any alternative ways for me to continue to shrink my database size? Any tricks, etc?
As it stands, my site has gotten so big and requires so many resources, that it is rendered unusable on any system with less than 8 GB of RAM (my forum is hosted off of a dedicated server, not a shared server). I was wondering what my options are for making a 13+ year old forum database smaller?
Thank you in advance.
Comment