Great Western Coffee Shop

Sideshoots - associated subjects => News, Help and Assistance => Topic started by: grahame on March 30, 2016, 13:06:43



Title: Server busy - a bit of background
Post by: grahame on March 30, 2016, 13:06:43
Our server that hosts The Coffee Shop is handling record levels of traffic - not so much from Coffee Shop users, but rather from automata which are indexing the various sites on the host, and from traffic levels on the sites that have had an increase in traffic (or in the case of http://option247.uk are new).  6.5 million requests so far this month!

99% of the time it's fine - with system loading being in the range of 50% to 70%.   However, at certain times there's a spike and you may see occasional messages like this:

Quote
Connection Problems

Sorry, SMF was unable to connect to the database. This may be caused by the server being busy. Please try again later.

For most of that 1% of the time that the loading is too high to handle, requests are queued and users don't even notice - but if the busyness persists, the queues can get full, and you may see the message above.   Typically it happens during some sort of backup procedure where a table of database has to be reserved / locked by the backup process to ensure the integrity of the backup; such procedures are scheduled as much as we can to happen at quieter time,  but as we have long periods of busyness and some fast changing (and growing) databases, there are occasions when they're happening at a busy time.

Should you get the error message above, please follow the suggestion and "try later". During the daytime, 5 minutes later should be plenty; night owls (who normally get very fast responses from our server!) may find that it takes a bit longer to be back with you.


Title: Re: Server busy - a bit of background
Post by: SandTEngineer on March 30, 2016, 14:44:17
Thanks for that Grahame.  I've had that message a few times over the past weeks, strangely when just pressing the submit icon when sending a post.  It never bothers me as I usually succeed after a couple of minutes.



This page is printed from the "Coffee Shop" forum at http://gwr.passenger.chat which is provided by a customer of Great Western Railway. Views expressed are those of the individual posters concerned. Visit www.gwr.com for the official Great Western Railway website. Please contact the administrators of this site if you feel that content provided contravenes our posting rules ( see http://railcustomer.info/1761 ). The forum is hosted by Well House Consultants - http://www.wellho.net