Train GraphicClick on the map to explore geographics
 
I need help
FAQ
Emergency
About .
Travel & transport from BBC stories as at 15:15 09 Jan 2025
 
* Fresh weather warnings for ice across UK
Read about the forum [here].
Register [here] - it's free.
What do I gain from registering? [here]
 today - Bath Railway Society
24/01/25 - Westbury Station reopens
24/01/25 - LTP4 Wilts / Consultation end
24/01/25 - Bristol Rail Campaign AGM 2025

On this day
9th Jan (2004)
Incorporation of Railway Development Society Ltd (now Railfuture) (link)

Train RunningDelayed
13:15 London Paddington to Cardiff Central
14:32 London Paddington to Cheltenham Spa
14:50 Trowbridge to Bristol Temple Meads
Abbreviation pageAcronymns and abbreviations
Stn ComparatorStation Comparator
Rail newsNews Now - live rail news feed
Site Style 1 2 3 4
Next departures • Bristol Temple MeadsBath SpaChippenhamSwindonDidcot ParkwayReadingLondon PaddingtonMelksham
Exeter St DavidsTauntonWestburyTrowbridgeBristol ParkwayCardiff CentralOxfordCheltenham SpaBirmingham New Street
January 09, 2025, 15:22:15 *
Welcome, Guest. Please login or register.

Login with username, password and session length
Forgotten your username or password? - get a reminder
Most recently liked subjects
[167] 'Railway 200' events and commemorations 2025
[114] Thumpers for Dummies
[96] Railcard Prices going up
[57] Outstanding server / web site issues
[33] Oxford station - facilities, improvements, parking, incidents ...
[21] Views sought : how train companies give assistance to disabled...
 
News: the Great Western Coffee Shop ... keeping you up to date with travel around the South West
 
   Home   Help Search Calendar Login Register  
Pages: [1]
  Print  
Author Topic: Server busy - a bit of background  (Read 3393 times)
grahame
Administrator
Hero Member
*****
Posts: 43073



View Profile WWW Email
« 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 (Simple Machines Forum - The software we use on this site) 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.
Logged

Coffee Shop Admin, Chair of Melksham Rail User Group, TravelWatch SouthWest Board Member
SandTEngineer
Hero Member
*****
Posts: 3485


View Profile
« Reply #1 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.
« Last Edit: March 30, 2016, 15:17:08 by SandTEngineer » Logged
Do you have something you would like to add to this thread, or would you like to raise a new question at the Coffee Shop? Please [register] (it is free) if you have not done so before, or login (at the top of this page) if you already have an account - we would love to read what you have to say!

You can find out more about how this forum works [here] - that will link you to a copy of the forum agreement that you can read before you join, and tell you very much more about how we operate. We are an independent forum, provided and run by customers of Great Western Railway, for customers of Great Western Railway and we welcome railway professionals as members too, in either a personal or official capacity. Views expressed in posts are not necessarily the views of the operators of the forum.

As well as posting messages onto existing threads, and starting new subjects, members can communicate with each other through personal messages if they wish. And once members have made a certain number of posts, they will automatically be admitted to the "frequent posters club", where subjects not-for-public-domain are discussed; anything from the occasional rant to meetups we may be having ...

 
Pages: [1]
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.2 | SMF © 2006-2007, Simple Machines LLC Valid XHTML 1.0! Valid CSS!
This forum is provided by customers of Great Western Railway (formerly First Great Western), and the 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 the content provided by one of our posters contravenes our posting rules (email link to report). Forum hosted by Well House Consultants

Jump to top of pageJump to Forum Home Page