Last visit was: Sat Oct 21, 2017 2:36 am It is currently Sat Oct 21, 2017 2:36 am

All times are UTC+01:00




 [ 28 posts ]  Go to page 1 2 Next
Author Message
PostPosted: Wed Sep 30, 2009 8:14 am 
Offline
Site Admin
User avatar

Joined: Wed Dec 17, 2008 1:24 pm
Posts: 20
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


Top
   
 
PostPosted: Wed Sep 30, 2009 9:03 am 
Offline
Needs more cowbell
User avatar

Joined: Fri Apr 03, 2009 10:09 am
Posts: 9011
Current ride: None
Location: Southampton
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 ..”


Top
   
 
PostPosted: Wed Sep 30, 2009 9:06 am 
Offline
User avatar

Joined: Tue May 12, 2009 3:46 pm
Posts: 695
Location: Sunny Scarborough
Ash,

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

_________________
Be seeing you

I


Top
   
 
PostPosted: Wed Sep 30, 2009 12:04 pm 
Offline
Needs more cowbell
User avatar

Joined: Fri Apr 03, 2009 10:09 am
Posts: 9011
Current ride: None
Location: Southampton
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 :evil: :evil: :evil:

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 ..”


Top
   
 
PostPosted: Wed Sep 30, 2009 12:15 pm 
Offline
User avatar

Joined: Wed Apr 29, 2009 7:27 pm
Posts: 664
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 this on yer fueller...........


Top
   
 
PostPosted: Wed Sep 30, 2009 12:20 pm 
Offline
User avatar

Joined: Wed Apr 29, 2009 10:10 pm
Posts: 833
Location: Thames Valley, Rive Droite.
Wot ^^ he ^^ said. :worthy:

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


Top
   
 
PostPosted: Wed Sep 30, 2009 12:50 pm 
Offline
Needs more cowbell
User avatar

Joined: Fri Apr 03, 2009 10:09 am
Posts: 9011
Current ride: None
Location: Southampton
Thanks chaps :)

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


Top
   
 
PostPosted: Wed Sep 30, 2009 12:58 pm 
Offline
User avatar

Joined: Wed May 06, 2009 1:55 pm
Posts: 4336
Current ride: 98 S1W
Location: Perth, not the Scottish one
:yup:


Top
   
 
PostPosted: Wed Sep 30, 2009 1:17 pm 
Offline
User avatar

Joined: Wed May 06, 2009 6:24 pm
Posts: 795
Location: Kent
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? :4roz: :4roz: :4roz: :4roz:


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


Top
   
 
PostPosted: Wed Sep 30, 2009 1:19 pm 
Offline
Needs more cowbell
User avatar

Joined: Fri Apr 03, 2009 10:09 am
Posts: 9011
Current ride: None
Location: Southampton
Well don't be to quick to thank me yet, we don't know for certain this will work ... :oooops: :?

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


Top
   
 
PostPosted: Wed Sep 30, 2009 1:28 pm 
Offline
User avatar

Joined: Tue May 12, 2009 3:46 pm
Posts: 695
Location: Sunny Scarborough
Ash wrote:
Well don't be to quick to thank me yet, we don't know for certain this will work ... :oooops: :?


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


Top
   
 
PostPosted: Wed Sep 30, 2009 2:03 pm 
Offline
Needs more cowbell
User avatar

Joined: Fri Apr 03, 2009 10:09 am
Posts: 9011
Current ride: None
Location: Southampton
No problem :mrgreen: :mrgreen: :yup: :lol:

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


Top
   
 
PostPosted: Wed Sep 30, 2009 6:00 pm 
Offline
Moderator
User avatar

Joined: Wed Apr 15, 2009 5:25 pm
Posts: 11400
Location: Oswestry
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 8-)) and make sure you put yourself and family first.

Well done that man :yup:

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


Top
   
 
PostPosted: Wed Sep 30, 2009 6:10 pm 
Offline
Needs more cowbell
User avatar

Joined: Fri Apr 03, 2009 10:09 am
Posts: 9011
Current ride: None
Location: Southampton
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 :yup:

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

;)

Image

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


Top
   
 
PostPosted: Wed Sep 30, 2009 6:17 pm 
Offline
User avatar

Joined: Fri May 15, 2009 5:34 pm
Posts: 3578
Location: The borders of insanity
Ash wrote:
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 :yup:

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

;)

Image
Ash mate - Pull the trigger :twisted:

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.


Top
   
 
 [ 28 posts ]  Go to page 1 2 Next

All times are UTC+01:00


Who is online

Users browsing this forum: CommonCrawl [Bot] and 0 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
Powered by phpBB® Forum Software © phpBB Limited