1
Server Move and Outage Reports / Re: Not loading? 4.12.17
« on: April 12, 2017, 05:52:46 PM »works for meIt was the "Today's Posts" search that was giving the 500 error. Everything is back to normal now.
This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
works for meIt was the "Today's Posts" search that was giving the 500 error. Everything is back to normal now.
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!
Yup, we're back up, I'd like to take credit for it but it's really the GeoVario staff and mcubed that did the work.
This one was odd.. the front end server stopped responding and when the datacenter checked the physical computer it was turned off.
We're still trying to find out if it was a heat sensor that panicked, a power glitch or clumsy cleaning crew with a mop...
The DB is safe, we've got a lot pulling on the DB server right now so it's being bogged down.
Should be better shortly.
Damn, another database error. Can the DB be saved?
We've been having some issues with our current hosting company so this forum was set up in case the original had problems. Then we could let everyone know what was happening.
If you don't mind me asking: what kind of problems?