We are currently upgrading from MyISAM to InnoDB.
Calguns.net has been growing a lot and there are a lot more people reading and posting in tens of thousands of threads at any given moment.
This is a huge performance issue for the default table engine that vBulletin uses, MyISAM, as that engine locks the entire table unlike InnoDB, which locks the rows inside the table instead. The problem comes from the massive query that is required to sort through all those posts, update the thread when new replies happen and to update individual posts when an edit is made, because these slow queries pile up, locking the post table for others.
InnoDB is suppose to alleviate much of the problems we've been having so we're going to give it a try.
GeoVario recently (in the last week or so) upgraded our servers and we've found that throwing hardware at the issue isn't helping so now we're trying to upgrade various software aspects.
Thank you for you patience, Calguns.net will reopen very shortly, hopefully much faster and without the double/triple/quadruple posts!
