Sloooooooow


PDA






Derek Zeanah
January 9, 2013, 01:08 PM
This is what happens when THR goes down, then when it comes back up 1,000 people all hit "refresh" in their browsers at once. Tha database server is used to 100-300 queries per second, and it takes between 6 and 12 queries per page request, so all of a sudden we get a deluge of 30-90 times our normal load, and the database server takes a while to catch up.

Luckily this only happens when we go down during the day.

If we can keep the load balancer back up, and if the database server continues to behave, then I hope we'll be back to our old, reliable service today.

Though to be honest at this point I'm waiting for the next shoe to drop...

If you enjoyed reading about "Sloooooooow" here in TheHighRoad.org archive, you'll LOVE our community. Come join TheHighRoad.org today for the full version!
If you enjoyed reading about "Sloooooooow" here in TheHighRoad.org archive, you'll LOVE our community. Come join TheHighRoad.org today for the full version!