RPC has moved! These pages have been kept for historical purposes

Please be sure to visit https://ffxiv-roleplayers.com/ directly for the new page.

Recent forum error pages

Threaded Mode | Linear Mode

FreelanceWizard FreelanceWizard Find all posts by this user Visit this user's website Random RPer #258 Posts:2,319 Joined:Sep 2010 Character:L'yhta Mahre Linkshell:Mysterium Server:Balmung Reputation: 317 Timezone:UTC-6 RE: Recent forum error pages | #6 11-07-2014, 11:57 PM And to follow up... The errors and extreme slowness we experienced this afternoon were due to a MySQL thing I've fixed. (As they say in the Lean world, every time you lower the water level, you end up hitting some new rocks. ) Show Content Technical details We use SSD storage for our RDS instance, which has something like an IOPS (IOs per second) limit. It can burst to obscene levels (3000 or so IOPS), but the actual normal IOPS depends on how much storage you have allocated. You get 3 IOPS per GB. Bursting is based on a limited set of IOPS credits, and when you run out, RDS locks you down to your purchased rate. You regain credits over time based on the amount of storage you allocate. For reasons of my bank account, I try to keep the allocated storage on RDS to a relatively low level, since I pay $0.115 per GB allocated. I had 20 GB allocated, which is 60 IOPS. I based this on the server monitoring by Amazon. I did not, however, zoom in far enough to see how our average IOPS is impacted minute to minute (lazy Freelance, you should know better!). At this point, any DBAs around can see where this is going... When I fixed the aforementioned PHP problem, our PHP throughput went up a lot. This meant our database IOPS usage went up a lot (more pages processed = more DB queries = more IOPS). We burned through our credit usage and, predictably, this ground MySQL to a halt, and ground the site to a halt. The fix was for me to allocate more storage to handle our real IOPS, after doing some poking around in the Cloudwatch monitoring to work it out. We now have enough storage to have the necessary IOPS so that the server won't melt down under load. I also noticed one more error that might've been causing some grief to people, albeit rarely. Sometimes web browsers ask for weird things, and the response from PHP can have large headers. Our nginx header buffers were too small to support this, which might've caused error pages to appear. I've rejiggered the buffer allocation to use fewer, bigger buffers to fix this. The Freelance Wizard Quality RP at low, low prices! ((about me | about L'yhta Mahre | L'yhta's desk | about Mysterium, the Ivory Tower: a heavy RP society of mages))

« Next Oldest | Next Newest »

Messages In This Thread

Recent forum error pages - by FreelanceWizard - 11-04-2014, 09:17 PM RE: Recent forum error pages - by FreelanceWizard - 11-06-2014, 12:23 PM RE: Recent forum error pages - by Tiergan - 11-06-2014, 12:35 PM RE: Recent forum error pages - by Unnamed Mercenary - 11-06-2014, 12:39 PM RE: Recent forum error pages - by FreelanceWizard - 11-06-2014, 12:56 PM RE: Recent forum error pages - by FreelanceWizard - 11-07-2014, 11:57 PM RE: Recent forum error pages - by Blue - 12-06-2014, 05:39 PM RE: Recent forum error pages - by FreelanceWizard - 12-06-2014, 07:18 PM RE: Recent forum error pages - by Blue - 12-06-2014, 11:17 PM RE: Recent forum error pages - by FreelanceWizard - 12-07-2014, 02:29 AM RE: Recent forum error pages - by FreelanceWizard - 12-07-2014, 12:49 PM RE: Recent forum error pages - by Blue - 12-11-2014, 01:48 AM RE: Recent forum error pages - by Warren Castille - 12-11-2014, 04:20 PM RE: Recent forum error pages - by Atoli - 12-11-2014, 04:25 PM RE: Recent forum error pages - by FreelanceWizard - 12-11-2014, 04:58 PM RE: Recent forum error pages - by Blue - 12-12-2014, 01:20 AM RE: Recent forum error pages - by FreelanceWizard - 12-12-2014, 09:37 AM RE: Recent forum error pages - by Blue - 12-12-2014, 09:58 AM RE: Recent forum error pages - by Atoli - 01-01-2015, 12:58 AM RE: Recent forum error pages - by FreelanceWizard - 01-01-2015, 01:20 AM RE: Recent forum error pages - by Atoli - 01-01-2015, 02:19 AM

• View a Printable Version
• Send this Thread to a Friend
• Subscribe to this thread

Users browsing this thread: 1 Guest(s)

Index | Return to Top | Lite (Archive) Mode | RSS Syndication | Current time: 10-30-2025, 10:00 PM