Gamer Girrl RPG Superstar 2011 Top 32 |
Gary Teter Senior Software Developer |
One of our database servers powered itself off over the weekend and is currently in pieces on a desk in my office, so the remaining servers are shouldering a heavier load than they're used to. And one of the side effects unfortunately is that instances of the website will shut themselves down automatically if they detect they're taking forever to respond to requests. That's why you've been getting kicked to the front page so often.
After carefully examining our application logs over the past couple days I've identified a handful of places where we were hitting the database more than we needed to, and a few hours ago rolled new code that seems to be working better.
One unfortunate side effect of my explorations is the discovery that Heathy's Saltmarsh PBP thread is a huge performance hit to the site. I don't know of many other internet forums that even allow active 8,000-post threads, but I'd like to figure out how to keep that one going instead of locking it and making the players use a new one. I think I know what to do to fix the problem, but I'll need to take the messageboards down for a few hours to make it happen. We'll give advance notice if it comes to this.
Sharoth |
One of our database servers powered itself off over the weekend and is currently in pieces on a desk in my office, so the remaining servers are shouldering a heavier load than they're used to. And one of the side effects unfortunately is that instances of the website will shut themselves down automatically if they detect they're taking forever to respond to request. That's why you've been getting kicked to the front page so often.
After carefully examining our application logs over the past couple days I've identified a handful of places where we were hitting the database more than we needed to, and a few hours ago rolled new code that seems to be working better.
One unfortunate side effect of my explorations is the discovery that Heathy's Saltmarsh PBP thread is a huge performance hit to the site. I don't know of any other internet forums that even allow active 8,000-post threads, but I'd like to figure out how to keep that one going instead of locking it and making the players use a new one. I think I know what to do to fix the problem, but I'll need to take the messageboards down for a few hours to make it happen. We'll give advance notice if it comes to this.
~gives a wicked grin~ Or you could just SUSPEND the Were-Mutt. With over 20k posts, isn't he a drain on the server resources all by himself? ~GRINS and runs~
j/k! j/k! I too would like to see that PBP thread preserved if at all possible.
Gary Teter Senior Software Developer |
~gives a wicked grin~ Or you could just SUSPEND the Were-Mutt. With over 20k posts, isn't he a drain on the server resources all by himself? ~GRINS and runs~
Actually yes, until the changes I made today, I believe that looking at Heathy's recent post page was probably a huge resource drain.
I didn't actually discover that by seeing requests for his recent posts, it was another user whose name I can't recall. Might have been some sort of silvery dragony thing....
Ross Byers RPG Superstar 2008 Top 32 |
Sharoth |
Sharoth wrote:~gives a wicked grin~ Or you could just SUSPEND the Were-Mutt. With over 20k posts, isn't he a drain on the server resources all by himself? ~GRINS and runs~Actually yes, until the changes I made today, I believe that looking at Heathy's recent post page was probably a huge resource drain.
I didn't actually discover that by seeing requests for his recent posts, it was another user whose name I can't recall. Might have been some sort of silvery dragony thing....
~laughter~ Well, I was just kidding, but I guess it makes sense in a strange sort of way! Keep up the good work, Gary!
Kruelaid |
One unfortunate side effect of my explorations is the discovery that Heathy's Saltmarsh PBP thread is a huge performance hit to the site. I don't know of many other internet forums that even allow active 8,000-post threads, but I'd like to figure out how to keep that one going instead of locking it and making the players use a new one. I think I know what to do to fix the problem, but I'll need to take the messageboards down for a few hours to make it happen. We'll give advance notice if it comes to this.
ROFL. HEATHANSSON!
Maybe you should start charging them. Ummm wait... then again maybe not.
Gary Teter Senior Software Developer |
I'll just start it over, It's no big deal. I'd consider it asinine to not do so if it causes a problem.
No need, and actually if I'm right it won't help unless I make other changes anyway.
We have to beat that card-playing thread anyway, so here's to the next 5,000 posts!
(Umm. Unless of course I can't figure it out because I'm stupid or something and we end up having to lock the thread anyway. But I'm pretty sure I've got it figured out.)
PS: Unless of course I am stupid, in which case I would think I've figured it out when I really haven't, and of course, being stupid, I wouldn't know until I tried. Hmmm.
Gary Teter Senior Software Developer |
Gary Teter Senior Software Developer |
Gary Teter Senior Software Developer |
Sharoth |
Tell the truth, I've had the PBP forum collapsed for months. Today I uncollapsed it just so I could get a better grip on what's going on there. This stuff is important to me because I care about how y'all are using our website and I want it to be its best.
Thank you Gary. Now how do you take your bribes?
Gary Teter Senior Software Developer |
Mark Moreland Director of Brand Strategy |
Adam Daigle Director of Game Development |
Dhampir984 |
I don't know of many other internet forums that even allow active 8,000-post threads, but I'd like to figure out how to keep that one going instead of locking it and making the players use a new one.
Amazon's have made it over 20k before, but now they have it set to lock at 5k but it respawns with a new thread linking back to the now locked 5k thread. It doesn't totally kill the old one, but tries to keep it viable without crashing stuff.
Gary Teter Senior Software Developer |