Forum Outage

General Questions and comments

Moderators: IMC, Club Staff

Post Reply
User avatar
Bennoz
National President
Posts: 23676
jedwabna poszewka promocja
Joined: Fri Jan 21, 2005 6:00 pm
Location: Sydney
Contact:

Forum Outage

Post by Bennoz »

Ok, its back up as you can see guys.

Problem was relating to the database, more specifically the Search_word_match table (ie the table the lists the location of all the searched words.)

It had blown out to over half a gig in size and was being belted by bots. We almost cooked a piece of ram in the server Im told :lol:

So, for this week I have disabled the search function (well, it'll still search, but yeild no results) and I'll check back in with the host next Monday
to confirm its resolved the overload. Then I'll turn the search back on, but I'll have to rebuild the search index manually. I need to exclude all
common words like 'and' 'to' 'the' etc to reduce the size of the table, therefore reducing the query load on the table, therefore not cooking ram.

I also have to put more antispam stuff on the signup page, while bots can't get through at the moment because I manually approve every single new account,
they are piling up dead at the front door. For every genuine new user account, there are 1-200 spam accounts created... A list I have to wade through every day.
User avatar
bass_twitch
Oldtimer
Posts: 2423
Joined: Thu May 27, 2010 3:37 pm
Location: Western Sydney, NSW

Re: Forum Outage

Post by bass_twitch »

:alien: hooray!
Image
User avatar
-Nighthawk-
Oldtimer
Posts: 1540
Joined: Wed Jan 28, 2009 6:00 pm
Location: Melbourne

Re: Forum Outage

Post by -Nighthawk- »

Yay, I've been checking the forum twice daily to see when it comes back up.

Unfortunately had to cancel the event in VIC due to not getting in contact with anyone :P
User avatar
SchumieFan
Oldtimer
Posts: 5875
Joined: Thu Aug 05, 2004 5:00 pm
Location: GPS signal lost
Contact:

Re: Forum Outage

Post by SchumieFan »

good stuff buddy... you should find someone to palm off some of the authorisations
Image
User avatar
Supplanter
Forum Moderator
Posts: 6422
Joined: Tue Oct 22, 2002 5:00 pm
Location: Arizona Bay
Contact:

Re: Forum Outage

Post by Supplanter »

SchumieFan wrote:good stuff buddy... you should find someone to palm off some of the authorisations
Co-ords/Mods?
LED ALL the things.
User avatar
Lawso
Penis Fingers
Posts: 2458
Joined: Sat Apr 05, 2008 5:00 pm
Location: Canberra
Contact:

Re: Forum Outage

Post by Lawso »

i was about to ask "bennoz...what did you do now?"
Image
topao
Veteran Mechanic
Posts: 825
Joined: Thu Oct 05, 2006 5:00 pm
Location: Sydney
Contact:

Re: Forum Outage

Post by topao »

why don't you just block the bots in a .htaccess file?
User avatar
Astron_Boy
Trolling Gen Y
Posts: 8400
Joined: Sun May 27, 2007 5:00 pm
Location: Wine Country NSW
Contact:

Re: Forum Outage

Post by Astron_Boy »

Oh, thank hell, it's back, no more :utbnb: withdrawls.
Image
Post Reply