Post #126
I've had it quite a few times today! Just now was the latest one!________________________________________
MY RALLYE PROJECT
|
| Author | Subject: Unable to connect too many connections? |
 tommy_306
Regular  Location: Manchester Registered: 18 Oct 2004 Posts: 409 Status: Offline |
|
 Posted 21st Mar 2012 at 21:49
|
|
|
tommy_306
Regular Location: Manchester Registered: 18 Oct 2004 Posts: 409 Status: Offline |
Post #127
I've had it quite a few times today! Just now was the latest one!________________________________________ MY RALLYE PROJECT |
|
Posted 21st Mar 2012 at 21:49
|
|
|
dangti6
aka JKshooter  Location: Taunton, Somerset Registered: 15 Jun 2006 Posts: 10,305 Status: Offline |
Post #128
And again. Just had it________________________________________  |
|
Posted 21st Mar 2012 at 21:49
|
|
|
tommy_306
Regular Location: Manchester Registered: 18 Oct 2004 Posts: 409 Status: Offline |
Post #129
I've had it quite a few times today! Just now was the latest one!________________________________________ MY RALLYE PROJECT |
|
Posted 21st Mar 2012 at 21:49
|
|
|
warner
Junior User  Location: Watford Registered: 10 Feb 2011 Posts: 52 Status: Offline |
Post #130
Me too, 6 times today.________________________________________ '96 GTI-6 daily'93 180SX drifter 20 Febuary 1997 - Thursday's car..has far to go?  |
|
Posted 21st Mar 2012 at 21:52
|
|
|
roland rat
Yeeeah Rat fans!  Location: Swansea Registered: 29 Nov 2006 Posts: 22,282 Status: Offline |
Post #131
Sock blocked again!  |
|
Posted 21st Mar 2012 at 22:05
|
|
stan_306gti6
Forum Admin Location: Kent Registered: 18 Jan 2004 Posts: 21,768 Status: Offline |
Post #132
Obviously more fettling needed.  ________________________________________ "Supercharged - 454.1bhp/317.5lb/ft"Peugeot 306 GTi-6 2000 (X), Moonstone  |
|
Posted 21st Mar 2012 at 22:36
|
|
|
luke306rallye
Regular  Location: Rotherham Registered: 13 Sep 2010 Posts: 310 Status: Offline |
Post #133
ben.cashmore wrote: I just had this, trying to click to page 2 of a thread. Unable to connect - User gti6admin already has more than 'max_user_connections' active connections I've had this a few times recently. |
|
Posted 22nd Mar 2012 at 00:11
|
|
|
owain
Seasoned Pro  Location: Essex Registered: 20 May 2009 Posts: 9,185 Status: Offline |
Post #134
Ash - are you sure there's not a rogue query somewhere with a missing mysql_close() function or something? Even with 50 people browsing the site they shouldn't all be running queries at precisely the same time (not in computing terms anyway). MySQL is more than capable of handling tens of thousands of simultaneous users, so there must be something going on somewhere. When we've seen things like this on customers' servers it's been because a query somewhere is leaving connections open rather than closing them, didn't know if that was possible? ________________________________________ Membership expiring soon, get in contact on our new little forum project. |
|
Posted 22nd Mar 2012 at 08:28
|
|
|
owain
Seasoned Pro Location: Essex Registered: 20 May 2009 Posts: 9,185 Status: Offline |
Post #135
 ________________________________________ Membership expiring soon, get in contact on our new little forum project. |
|
Posted 22nd Mar 2012 at 21:41
|
|
|
welshpug!
Capt Pedantic  Location: Bigend, Wales. Registered: 27 Mar 2007 Posts: 25,817 Status: Offline |
Post #136
 ________________________________________ need a part number? get on here - http://public.servicebox.peugeot.comBring on the Trumpets. |
|
Posted 22nd Mar 2012 at 21:51
|
|
|
nashy
Sarcastic Tw@  Location: Nuts deep Registered: 13 Aug 2004 Posts: 14,788 Status: Offline |
Post #137
So you all got locked out again, beyond a joke, Ash, demand your money back, this server space is bo***cks!________________________________________ Pete Sims - R.I.P buddy!PS£ id - onenashy |
|
Posted 22nd Mar 2012 at 22:06
|
|
|
BrianM
Regular  Location: Kirkcaldy Registered: 01 May 2009 Posts: 487 Status: Offline |
Post #138
I seem to be getting more over the past few days??________________________________________ '13 208 Gti Bianca White, '99 Bianca 306 Rallye, '92 309 Goodwood GTi 5dr, '92 Miami Blue 309 GTi 3dr. |
|
Posted 22nd Mar 2012 at 22:16
|
|
|
owain
Seasoned Pro Location: Essex Registered: 20 May 2009 Posts: 9,185 Status: Offline |
Post #139
nashy wrote: So you all got locked out again, beyond a joke, Ash, demand your money back, this server space is bo***cks! It's not to do with the server, as I believe we're now on a dedicated server; where I work we run servers that run hundreds of websites from one MySQL server without issue. I suspect it's the issue I said to Ash earlier. ________________________________________ Membership expiring soon, get in contact on our new little forum project. |
|
Posted 23rd Mar 2012 at 07:24
|
|
captainash
Admin Location: Ferndown Registered: 10 Dec 2002 Posts: 3,923 Status: Offline |
Post #140
I'm not using persistent links, so they get closed at the end of each script.We'll find the problem eventually. Frustrating though, like you say it should be capable of running hundreds of genuine connections all day long. ________________________________________ quote: Ash is in charge, from afar |
|
Posted 23rd Mar 2012 at 08:28
|
|
|
owain
Seasoned Pro Location: Essex Registered: 20 May 2009 Posts: 9,185 Status: Offline |
Post #141
Ash - have you tried doing a "show status" in MySQL when the site's down? It should show you any running queries, if they're all the same query you'll know that's the problem. Or turn on log_slow_queries, so you can see if it's one taking forever. Also (although it kinda gets around the issue rather than fixing it), do you do any kind of page caching? I don't really do PHP but in ASP and ColdFusion you can just set a page to regenerate only every five seconds or so, so everyone's views are a few seconds out of date but if fifty people hit the front page at the same time it only has to run the code once. I've seen that make massive improvements on pages I've done before. ________________________________________ Membership expiring soon, get in contact on our new little forum project. |
|
Posted 23rd Mar 2012 at 08:32
|
|
|
captainash
Admin Location: Ferndown Registered: 10 Dec 2002 Posts: 3,923 Status: Offline |
Post #142
Haven't done, but I'll have a look if/when it happens next.I don't think we're using page caching at the moment, but that would definitely speed up the top-level forum pages. I'll look into that too  ________________________________________ quote: Ash is in charge, from afar |
|
Posted 23rd Mar 2012 at 08:47
|
|
|
billyboy99
Seasoned Pro  Location: London Registered: 12 Nov 2010 Posts: 1,658 Status: Offline |
Post #143
owain wrote: Ash - have you tried doing a "show status" in MySQL when the site's down? It should show you any running queries, if they're all the same query you'll know that's the problem. Or turn on log_slow_queries, so you can see if it's one taking forever. Also (although it kinda gets around the issue rather than fixing it), do you do any kind of page caching? I don't really do PHP but in ASP and ColdFusion you can just set a page to regenerate only every five seconds or so, so everyone's views are a few seconds out of date but if fifty people hit the front page at the same time it only has to run the code once. I've seen that make massive improvements on pages I've done before. who died and made you Bill Gates? |
|
Posted 23rd Mar 2012 at 11:23
|
|
|
owain
Seasoned Pro Location: Essex Registered: 20 May 2009 Posts: 9,185 Status: Offline |
Post #144
billyboy99 wrote: who died and made you Bill Gates? Not sure Bill Gates would use PHP and MySQL. Obviously. ________________________________________ Membership expiring soon, get in contact on our new little forum project. |
|
Posted 23rd Mar 2012 at 11:39
|
|
|
dangti6
aka JKshooter Location: Taunton, Somerset Registered: 15 Jun 2006 Posts: 10,305 Status: Offline |
Post #145
Owain. Given the reigns, how long do you reckon it would take you to diagnose and sort for good?________________________________________ |
|
Posted 23rd Mar 2012 at 11:43
|
|
|
owain
Seasoned Pro Location: Essex Registered: 20 May 2009 Posts: 9,185 Status: Offline |
Post #146
dangti6 wrote: Owain. Given the reigns, how long do you reckon it would take you to diagnose and sort for good? Not that sort of issue unfortunately, would mean trawling through code and watching database logs, which anyone could do as well as I can. ________________________________________ Membership expiring soon, get in contact on our new little forum project. |
|
Posted 23rd Mar 2012 at 11:49
|
|
|
scott dt
Regular  Location: London Registered: 02 Jun 2008 Posts: 497 Status: Offline |
Post #147
Since it's a dedicated server and you have full mysql access can you not take a look through the mysql logs to find what queries were running at the time that the site went down?Also for reference, memcache is a php version of page caching which is pretty well documented  ________________________________________ Team Jenvey 45 |
|
Posted 23rd Mar 2012 at 19:04
|
|
|
captainash
Admin Location: Ferndown Registered: 10 Dec 2002 Posts: 3,923 Status: Offline |
Post #148
Page caching isn't the solution. I've enabled slow query logging, will see what that highlights.________________________________________ quote: Ash is in charge, from afar |
|
Posted 23rd Mar 2012 at 19:08
|
|
|
scott dt
Regular Location: London Registered: 02 Jun 2008 Posts: 497 Status: Offline |
Post #149
Just thought I'd save you a search since you said you'd like into it.________________________________________ Team Jenvey 45 |
|
Posted 23rd Mar 2012 at 19:18
|
|
|
grumpychef
The Rib Man  Location: nth wurzleset Registered: 28 Oct 2006 Posts: 2,533 Status: Offline |
Post #150
Unable to connect - User gti6admin already has more than 'max_user_connections' active connectionsstill happening guys 21.32 today was able to hit refresh a few times to get back in and it only lasted a few minutes but somewhat irksome still! ________________________________________ Formally team BLAZE now Team bianca recuperating from multiple organ failure nicely! items replaced so far, clutch, cambelt etc, radiator, exhaust, most of front running gear, wish bones, drop links, ball joints, track rod ends, bearings, brakes, calipers, discs, and pads, brake lines, front springs, brake balance compensator thingy, hand brake cable, throttle cable (twice), coil pack, door handle, windscreen, wipers, head lamps several sensors and bulbs  .rear beam new throttle cable, new battery. .......... yeah man, team money pit! but shes still rollin! |
|
Posted 29th Mar 2012 at 21:36
|
|
The Peugeot GTi-6 & Rallye Owners Club - ©2024 all rights reserved.
Please Note: The views and opinions found herein are those of individuals, and not of The Peugeot 306 GTi-6 & Rallye Owners Club or any individuals involved.
No responsibility is taken or assumed for any comments or statements made on, or in relation to, this website. Please see our updated privacy policy.