Catman Posted March 21, 2006 Report Share Posted March 21, 2006 (edited) The last few days I get keeping a database error that there are "Too Many Connections". Are a lot of people getting this also? (edited: for spelling ) Edited March 21, 2006 by Catman Quote Link to post Share on other sites
Kingmob3 Posted March 21, 2006 Report Share Posted March 21, 2006 i got it a few times yesterday. I gave it a min and let modzilla refresh. KM3 Quote Link to post Share on other sites
curlyboy Posted March 21, 2006 Report Share Posted March 21, 2006 yes i get this as well, but it usually go after about 10 minutes. curlyboy Quote Link to post Share on other sites
Samm Posted March 21, 2006 Report Share Posted March 21, 2006 Quite simply; Arnie's is suffering a problem of having too many people looking at it. ASCUKs idea of solving this was to require logging on and stop guests from accessing the forums. I have no idea what's wrong really, but seen as Arnie is away I can't see it changing any time soon. Quote Link to post Share on other sites
Sledge Posted March 22, 2006 Report Share Posted March 22, 2006 (edited) Much as I hate going "ZOMG!!! Search!!!" there's already at least two other threads on this on the first page in Site Errors and Suggestions. Edited March 22, 2006 by Sledge Quote Link to post Share on other sites
HaVoC Posted March 22, 2006 Report Share Posted March 22, 2006 I have no idea what's wrong really, but seen as Arnie is away I can't see it changing any time soon. <{POST_SNAPBACK}> Will has admin access as well now though, so it could actually be solvable given a bit of thought and him knowing how to use all the power he's just been given! Quote Link to post Share on other sites
Trigger Happy10 Posted March 22, 2006 Report Share Posted March 22, 2006 Well I do think that making the forums private will help, it may discourage new users Quote Link to post Share on other sites
R22Master Posted March 22, 2006 Report Share Posted March 22, 2006 Hi all, Right - The "Low-down" for y'all... A month ago this site was receiving SO MANY connections (around the 700 simultaneously mark) that the CPU was being drowned out for extended periods and the whole site was being killed. Now, to understand what "Connections" are - A Connection is a request sent to the server. One user NORMALLY has one connection at any one time. However, some users have multiple browser windows open and are making multiple connections at any given moment (replying to a thread in one window while refreshing another window and opening a thread in another window). This is THREE connections. Now, when a server is being bombarded with 700 PHP connection requests CONSTANTLY it has a tendancy of dying. Result - up to an hour of down-time while its internal diagnostic systems notice the outage and reboot. So a few months ago the number of simultaneous "connections" was limited to 450. This means that any overloads are limited to minutes not hours, and there will be no "Total overload" of the CPU/RAM,etc... Put simply, if you see a "Too many connections" message, wait for 2 minutes and then hit "Refresh". Your connection should then come back to you. This is the price we pay for being the world's number 1 Airsoft community Quote Link to post Share on other sites
Catman Posted March 22, 2006 Author Report Share Posted March 22, 2006 cheers for the low-down and heres a clicky for Sledge And no actually there are this post and this post (which gives no real info other than "omg dude there was an error") however they don't specify this problem Quote Link to post Share on other sites
HaVoC Posted March 23, 2006 Report Share Posted March 23, 2006 I suddenly feel guilty about having 5 Firefox tabs open viewing different threads... Quote Link to post Share on other sites
Catman Posted March 23, 2006 Author Report Share Posted March 23, 2006 I suddenly feel guilty about having 5 Firefox tabs open viewing different threads... <{POST_SNAPBACK}> Only? Err ...I mean... curse you! *shakes fist* Quote Link to post Share on other sites
gazchap Posted March 23, 2006 Report Share Posted March 23, 2006 This is a question for Ivery really, but out of sheer curiousity what are the specs of the hosting server hosting this site? I would have thought most servers would be able to cope with 700 mySQL connections! Quote Link to post Share on other sites
Hellfire8 Posted March 23, 2006 Report Share Posted March 23, 2006 What about limiting the amount of guests that can use the board/view it at anyone time? Set the server up so onlyl 150 or something guest can view the website, just an idea. Quote Link to post Share on other sites
Prometheus Posted March 23, 2006 Report Share Posted March 23, 2006 This is a question for Ivery really, but out of sheer curiousity what are the specs of the hosting server hosting this site? I would have thought most servers would be able to cope with 700 mySQL connections! <{POST_SNAPBACK}> Well, the server is also split between Arnies and Ivery's site, I think. So that may have an impact on the problem. ~P Quote Link to post Share on other sites
Onechance Posted March 23, 2006 Report Share Posted March 23, 2006 Could this mean airsoft is gaining popularity in the UK? Might help the VCBR cause a little Quote Link to post Share on other sites
Prometheus Posted March 23, 2006 Report Share Posted March 23, 2006 The increase in viewers is in the wider world such as the US and Canada. Quote Link to post Share on other sites
Samm Posted March 23, 2006 Report Share Posted March 23, 2006 ... Or the rest of the world? Quote Link to post Share on other sites
Prometheus Posted March 23, 2006 Report Share Posted March 23, 2006 Well of course, but most people who frequent the boards are from: USA Hong Kong UK Canada Japan There are very few people outside of these countries, so I did'nt bother to list them all. ~P Quote Link to post Share on other sites
joeking27 Posted March 23, 2006 Report Share Posted March 23, 2006 Well of course, but most people who frequent the boards are from: USA Hong Kong UK Canada Japan There are very few people outside of these countries, so I did'nt bother to list them all. ~P <{POST_SNAPBACK}> Why don't you fix all the problems, as you seem to have server access to get at the stats for this page... Quote Link to post Share on other sites
Catman Posted March 24, 2006 Author Report Share Posted March 24, 2006 is it me or is it getting worse? and I won't mention what I do for a living, *waves hand* no I am nothing to do with websites, web servers and (My)SQL databases... and these aren't the droids you're looking for Quote Link to post Share on other sites
R22Master Posted March 24, 2006 Report Share Posted March 24, 2006 I suddenly feel guilty about having 5 Firefox tabs open viewing different threads... <{POST_SNAPBACK}> And so you should Well, not just you, but ALL members using multiple windows/Firefox tabs are taking up connections that stop other users from viewing the site. Yes, it may help you do several things at once, but each one of those "things" is a user that is being "bounced" from the site. The problem is that at the moment, demand is MASSIVELY high and finance is low. These two factors are mutually exclusive which is leading to outages for some users. And don't think that this is because us owners/admins/moderators are over-using the site - even I have had a job connecting this fine evening which added an hour to various admin tasks and left me with one fewer hour of sleep tonight. Anyway, upgrades are being considered at the moment and improvements are being tabled. Until they are put in to place though we have to take account of the fact that this site's popularity has grown beyond all expectations and beyond all other internet web sites. They say there is a price to be paid for fame and popularity. For us it is the occasional 5 minutes of outage here and there. For others it is either hounding by the paparazzi or death on a toilet. Personally, I am happy to stick with the occasional outage Rest assured, as server upgrades are planned or implemented you will be the first to know Quote Link to post Share on other sites
Prometheus Posted March 24, 2006 Report Share Posted March 24, 2006 R22,do you know how much the upgrades will cost? I'd be willing to chip in for, as I'm sure other member would too. if you have a quote, I'll pay a certain percent of it. I want my Arnies back ~P Quote Link to post Share on other sites
1st Commando Posted March 24, 2006 Report Share Posted March 24, 2006 remember guys its going to be a lot busier in the period that ASCUK is down Quote Link to post Share on other sites
bronney Posted March 29, 2006 Report Share Posted March 29, 2006 This is the price we pay for being the world's number 1 Airsoft communityThat's exactly what I was thinking about when I hit the error. Man I love Arnie's. Quote Link to post Share on other sites
Sledge Posted March 29, 2006 Report Share Posted March 29, 2006 Arnie's: so good, it's broken! Quote Link to post Share on other sites
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.