Chris`I

You need to scan it with a QR Code reader - it takes you to the best place

Dont worry the other Chris is doing it

See other thread, we're busy doing "stuff"

We're trying out a few things If you want to be really scared, the forum may be down later

I've said it before and I'll say it again - I hate you And clipless You laughed at my cliplessness - I knew you'd turn to the dark side one day

And actually the Garage mod is almost ready to go once we sort out these issues

No problems to report today from the logs I can see. Remember some problems can be down to your ISP

Scan it with RedLazer or similar QR Code reader

Dont be too upset being on ya tod, it means theres no one to slow you down

Nothing a quick hour with a Dremel can't sort Excellent, whats the lead time atm? I see there will be a lot of demand

Will it fit in a 370z? We dont have the same size cubby to put it in

Ironically if Husky hadnt gone on there and posted it someone wouldnt have reported it to us. Hows that for club relations

Like Z Club

This is the same session issue. You open the index when the forum is fine, but when you return it is fubard. The reason you cant get past clicking the first link is it tries to see what your session is, but as that is locked out, you cant go anywhere. Sessions are the lynchpin of the forum and when they are locked out no one can access the forum - not even mods and admin. We know the change to make, but its akin to tuning your car yourself - we need to know what we are doing first time round so it doesnt break the whole thing for everyone

This is why I waited for a Black Edition 370z - anthracite wheels dont really show brake dust. My old gold Rota's were a nightmare I do find with Poorboys wheel sealant if you do the wheels when clean, it makes them very easy to clean in the future. Just use water and LSP safe shampoo (Dodo, megs, etc)

The sessions table as you can imagine is like the gatekeeper to the forum. Before you can do anything (log in, view thread, post, create PMs), it goes to the sessions table to see what your status is. Due to the design of MyISAM, anything that changes in that table locks the whole thing, not only to other writes but also reads. You can see how this can be quite catastrophic then when it decides to lock for anything more than a few seconds, literally no one can do anything. InnoDb removes this and things should run a lot smoother. WRT to the backend design, not a lot we can do with that, its phpBB's remit. But going by fact there are bigger forums out there using it, we should be ok. They are all using InnoDB which shows us its the right way to go

Think there have been quite a few people over the years from here. Do a quick search and you should find a few threads. I think the general concensus is

No offence taken - we know we're not that big compared to some other forums out there. I have worked/work doing data ETL/warehousing for some of the worlds biggest telco's and payment processors so know what truely massive volumes look like What we do know is that the number of people trying to log on at once causes a sessions table to lock up, which InnoDB will fix. This is not helped by a problem that may be lingering in the chat mod too which I need to look at tonight. We should be fine moving over to InnoDB alone. Its what phpBB forums themselves use and as you say, we're not a big forum in that sense, so its just the table locking that is the issue. We know there is plenty of disk IO and CPU left to spare. InnoDB has the problem that it doesnt support full text searching so we cant move all tables without very big modifications to the forum, but the tables effected fortunately arent searched, so we are ok. All thats really happened is that we've grown too big/busy for MyISAM engine which is the MySQL default.

That sounds about right - its in the service manual ( http://www.nicoclub.com/FSM/ ). You'd certainly want to loosen off the handbrake lever end before adjusting the back

Do you know much about MySQL and MyISAM/InnoDB? I know a lot of DBAs in my field of work but they are all DB2 and Oracle based being that they work for big firms. The problems we are looking at are tuning these to the size that the forum has now become. MySQL is good out the box for small forums, but as we have so many people logging on at once now its becoming overwhelmed (not a hardware issue) with table locking. We're moving table(s) over to InnoDB as we think this will solve it FWIW the forum isnt acutally crashing, its hitting near deadlock as tables become locked and all queries are queued behind it. This queue eventually gets so long that the server takes a long time to recover. Google/Bing bots live on here and make lots of requests which make the queue grow very quickly too. Its not a hardware issue as the server has loads of resource left, its an internal bottleneck of MySQL and MyISAM.

Thanks Vik

No there isnt anything wrong with that. But expecting people to give up all their time to solve the problem is. We do this part time as and when we can and we do our best. We ask for as much info as possible to help us find out what is going wrong. You want me to spend a few days and fix it - you pay my day rate and I'll do it - though the invoice might make you cry. Thanks for the info Vik - moving in the right direction

This has been done

nightmare.... lol! can you change my old one to WINKJ? got sick of having a boring username. I'll have to delete this user, so give me 10mins and try logging in again and it should hook up to the old login (ie use the old password if its different). You may need to clear your cookies as it might try and log in as your current user. I'll email you when done