All

I have made some changes to the search function of the forum ..

As you will have noticed we are experiencing a Max Connections time out occasionally (Twice last night) This is caused by the search function of the forum locking the database so that nothing else can write to it when the search function is used heavily, once locked it doesn't release previous connections and locks its self up. I have to then SSH into the server and run some script to restart the MYSQL Data Base, and in drastic cases restart the entire server. If I am not around then this wont get done until I either notice its happened or get a call from one of you, and then I can only fix it if im in front of a PC with Secure Shell access.

This issue is not unique, hundreds of websites using the same forum engine have the same issue right now and we all await a bug fix release from PHP.com, until this happens (we don't know when ) we have to take some small measures to try to decrease the frequency with this this issue is happening.

I have now limited the search function to just 2 key words per search and a period of 60 seconds between searches. For guests the time is increased to 90 seconds.

I have also allocated more of the servers CPU power towards the search function to try and help it along a bit.

There are some more drastic back end fixes but this requires rewriting the MYSQL tables for the search function and its a long and costly job, A job I want to use as a last resort right now. I have 34SP looking into a few areas that are out of our control, server and connection wise.

I know this may become frustrating but please bear with us whilst we are trying to fix the issue. Your patience is appreciated, whilst mine is wearing thin.

Thanks

Ash.

_________________
El presidente

Just to add, we might be working on the forum today and to do this we need to disable the board for some periods of time, sorry for any inconvenience, but its a necessary to stop the DB being written too, whilst its being worked on.

_________________
"With square conduct, level steps, and upright intentions ..”

Ash,

Thanks for letting us know and thanks again for all the work you do on the board.

_________________
Be seeing you

I

OK, the boards were disabled for the last hour or so this morning, I noticed a floor in it though because those who automatically log in, were still able to do so

We have changed the way the search function indexes itself in the DB, it has been rewritten after other tests failed to fix it. I will leave the settings mentioned above the same for now and see how we go.

If we find that we have cured the issue, then awesome if not then we will revisit it again. We are waiting for a bug fix to be released but so far nothing has appeared, so we have to try something for ourselves and this is it.

Please bear with us if we do suffer another connection issue, we are working really hard to solve this as we know how frustrating it is for you guys as well as us!

Thanks for your continued patience

_________________
"With square conduct, level steps, and upright intentions ..”

Ash, you're an absolute superstar. What ever happens, put yourself and the family first mate. It isn't the end of the world if anyone can't log in for an hour or two.

_________________
Try doing this to yer fueller...........

Wot ^^ he ^^ said.

_________________
Good in straight lines
2001 X1 "The Tart's Handbag"
2001 FZS1000 "The Fridge"

Thanks chaps

_________________
"With square conduct, level steps, and upright intentions ..”

_________________
Travelling through time at the speed of light

Yup, I agree with them up there. Brilliant job Ash, you're a star.
Just don't let our demands take priority over your own eh?


and wtf are you on about, don't understand a bloody word

Well don't be to quick to thank me yet, we don't know for certain this will work ...

_________________
"With square conduct, level steps, and upright intentions ..”

Personally, I'm grateful that you put the time and effort in to the site. The fact that you manage it brilliantly is a huge bonus. So: thanks for all the work and thanks that you succeed.

_________________
Be seeing you

I

No problem

_________________
"With square conduct, level steps, and upright intentions ..”

Ash, as one of the people who has some idea of the large % of your life you put into the site to keep it open for us, I would just like to say a huge thanks. I don't think everyone appreciates how much time you dedicate to it - but always remember, it's only a bloody website (the best there is, of course ) and make sure you put yourself and family first.

Well done that man

_________________
If your dreams don't scare you, they are not big enough.

No real thanks needed but appreciated chap, you and the rest of the team also do your fair share here as well, for which I am very grateful

Now ... someone make a donation to the site or this cute fluffy kitten gets it ...

_________________
"With square conduct, level steps, and upright intentions ..”

Ash mate - Pull the trigger

I am in awe - just pulled a 10hour day in front of a screen doing site-admin - Thank f*ck I'm escaping as of NOW.

_________________
Sept 2017. Email will find me.