Chris`I

If it were that simple we'd do it Remember we havent coded any of this from scratch, phpBB itself is prebundled software, the chat mod is a mod to that software. Unfortunately we're not going to go in and hack it all apart to make it work for what is essentially a feature used by the minority. If the forum proves stable after the current changes (looks that way) we will bring back chat and see if that brings back any issues. If it does I'm afraid it will get removed

I know plenty of DBAs from my old work places, working on very large DB's but they are all experts in the wrong software - Oracle, DB2, Teradata, Netezza etc. Its finding someone that knows mySQL well that is hard Even on the phpBB forums they wont answer questions on how to tune mySQL for phpBB itself, its like getting blood from a stone As Chris has said, chat may or may not be back permenantly. It uses the DB for some stuff and may be causing the server to become overloaded. We need to work out if its a badly coded mod which will always kill the DB or if it ok as a mod put a bit too much load on the DB highlighting the problems. Small but significant difference.

Know much about mySQL and myISAM or InnoDB variables? Will do after 5 minute of googling But that will only put you on a par with us - we want help from someone who knows what they are doing!

Not sure what thats all about, the changes we've made shouldnt effect the way the forum functions, but we have had reports of this happening. Keep an eye on it and if it happens frequently from the same computer with the same browser then let us know. The changes did mess around with the sessions held on the server. It may be that the session store on your PC in the cookie doesnt match the server any more so you need to start a new session before it will let you search. If thats the case it should only happen once per computer/browser combo. Dont get time to go to the club, sodding people on here moaning its not quick enough/stable enough or something

Know much about mySQL and myISAM or InnoDB variables?

Everyone happy last night? Think we've worked out a few things and a few more in the pipeline to speed it up a bit more hopefully (or rather not cause it to slow down). Also think I've worked out how to allow ODBC with our hosts which means we can look at plugging in some monitoring s/w in the future to keep an eye on things

Shotgun testing it when Tim gets some. Bug **** me right off!

Err, link no worky

Boooo - who approved this - I think I might delete it GLWS Linda, its a cracking car. Shame to loose a sprinkle, especially one that made it to meets too. Good job Sam got a go when he did huh

Locked at OP's request

When I got mine it was ~£400 for the first years tax and ~£400 showroom tax. This should be included on the OTR price though.

Definately get the Connect Premium if you can afford it, well worth it in the long run

Works fine for me

One will be MY2009 and the other will be MY2010. They could both be on 10 plates but they are different model years. Connect Premium was brought in with MY2010 and normal satnav was before this in MY2009. The price increase for Connect Premium over satnav was £200 IIRC, so there should be less of a difference than that on 2 second hand cars. Quite how they have a brand new car for £200 more I dont know, the RRP on them is now £35k+

Be careful or they might clamp it

Avoid Japspeed is my advice from seeing other 350z products made by them

+1

Funny you mention that, I bought a new chain for the commuter as it was a bit noisy and I was never happy with it. Always had KMC chains and always been happy with them so swapped it up. Forgot to measure the old one until last night and realised that it was between 0.75-1 on my chain guage so managed to swap it out just in time. My spidey chain stretch senses are obviously working well Dont know how or why but KMC chains seem to be sooo much smoother than Shimano and SRAM (Shim on my commuter previously and SRAM on the Stumpy which self destructed!). Not even running the best of best KMC chains, just the boggo £15 ones!

Easier just to get you to tell us when it happens

Might have been that it needed to create a new session before it would let you do the search if that was the first time you've clicked it since the changes (on your phone). If all is well after that I wouldnt worry.

Just to be clear (for others mainly) if you get a timeout and the site doesnt even load then thats not a browser issue. Its a browser issue when you can see the site but not log on.

Oh you'd be surprised: The amount of threads I've seen with "I was passing Elises/Caterhams/GT3s all day in my Zed!" on here beggars belief! But I did beat that GT3 And then I woke up

From GA: Pageviews per hour: 1900 : 1,984 2000 : 2,185 2100 : 2,354 2200 : 2,785 2300 : 1,554 0000 : 644 As you can see the site "appeared" to be up, as this follows the usual trend when comparing it to same time last week and same time last month (looking in GA I can overlay them ontop of each other). That said if it locks up for 1/2hr then goes back to normal then its not always obvious from these stats.

So just to confirm last night, you couldnt reach the site at all? It wasnt a case that the site wouldnt log you in? Looks like I need to stay on the site a little longer on a night I do have logs that show the numbers of queries and usually this drops if there are any significant lock outs and its fine last night and GA gives hour by hour breakdowns and again looked ok but after what you said, maybe not! Thanks for the feedback its most appreciated

The problem is the site was/is never actually "crashing". The database tables were locking up, but the database service was never actually failing, neither was any other service on the server. I have a few scripts to poll the database every minute or so. The problem with locking tables is the reason for the locking is very hard to trace. Evidently it will be either in phpBB's code or a modification made to the site, which is beyond the realms of most developers to find. Switching the database engine for the problem table removes the locking, but may throw other issues. This is what I am trying to find out. For me last night the forum was quicker than it has been for a while and a few others have told me the same. In fact Google Analytics which reports page load speeds for IE9 and Chrome categorically shows its quicker. I wanted to make sure there arent people out there having issues that are the fault of the forum