Connection issues here at OLH, Traffic, and CF down

Open forum to discuss pretty much anything.
Post Reply
WadeFillingame
Posts: 1530
Joined: Wed Apr 04, 2007 12:14 am

Connection issues here at OLH, Traffic, and CF down

Post by WadeFillingame »

I've been under a rock for the last few days so I missed the CF going down thing.  :popcorn:

I'm guessing that with CF down some increased number of people were here looking around.  Well, it seems that my host has some server side protections in place that limit my database queries to 50,000 per hour.  A lot of things on this page query the database every time you load a page.  I'm sure karma is one of them so I've disabled it.  I may have to disable the custom titles too.  I haven't looked into the code but I'm know that it has to query the database to determine your title.  I've left it on fir now but if I have problems  tomorrow I'll disable it too.  I'll see what else I can do to get the queries under control, and I'm putting in a ticket to the host to see what my options are.  (hope I don't have to move the site) 

In the mean time, if you get a message saying something to to effect that the database questions has exceeded 50,000 it should re-set within an hour.  Till then I'm working on a solution.  (I'm allowed a bunch of databases and I'm only using one for this site, so I'm hoping that I can negotiate a deal to get more dbase queries for fewer databases)


Knuck42
Posts: 1798
Joined: Thu Apr 05, 2007 11:02 pm

Re: Connection issues here at OLH, Traffic, and CF down

Post by Knuck42 »

Keep up the good work Wade!

:bigup:
My CF History May Be Viewed Here...  http://lounge.cigarfamily.com/usernote.php?u=18152

My OLH History May Be Viewed Here... http://www.onlinehumidor.com/forum/index.php?action=profile;u=172

Scumbag List May Be Viewed Here...  http://www.scumbagslist.com/
Rooster
Posts: 151
Joined: Sat Apr 07, 2007 12:54 am

Re: Connection issues here at OLH, Traffic, and CF down

Post by Rooster »

i felt so naked and alone!!! :tears:
Trblmkr
Posts: 15
Joined: Fri Jun 22, 2007 5:05 pm

Re: Connection issues here at OLH, Traffic, and CF down

Post by Trblmkr »

Thanks Wade... I thought you had been attacked as well.

Keep up the excellent work... :cool:
WadeFillingame
Posts: 1530
Joined: Wed Apr 04, 2007 12:14 am

Re: Connection issues here at OLH, Traffic, and CF down

Post by WadeFillingame »

So far it looks as if we're still OK here.

Actually I did get a huge hit over the weekend.  Looking at the stats I had slightly higher unique users, but I got hit with 4 to 5 times the usual number of page loads (over 40K page loads)...

I doubt if it was anything but it was enough to kick us over the line on queries from time to time
Trblmkr
Posts: 15
Joined: Fri Jun 22, 2007 5:05 pm

Re: Connection issues here at OLH, Traffic, and CF down

Post by Trblmkr »

Probably a bunch of us from CF tuning in here to see what's going on.  Hoping that someone had an answer for us.
WadeFillingame
Posts: 1530
Joined: Wed Apr 04, 2007 12:14 am

Re: Connection issues here at OLH, Traffic, and CF down

Post by WadeFillingame »

and we are back.  :bounce:

Another short talk with tech support and I think I have it fixed now.  Seems that my database was open to spiders and was getting queried by every search engine in the world.  I think I've got it fixed.  Sorry for the interruption tonight.


Knuck42
Posts: 1798
Joined: Thu Apr 05, 2007 11:02 pm

Re: Connection issues here at OLH, Traffic, and CF down

Post by Knuck42 »

Are we talking about Seegar's link again?  Dems some nadty spiders fo sho!
My CF History May Be Viewed Here...  http://lounge.cigarfamily.com/usernote.php?u=18152

My OLH History May Be Viewed Here... http://www.onlinehumidor.com/forum/index.php?action=profile;u=172

Scumbag List May Be Viewed Here...  http://www.scumbagslist.com/
atomross13
Posts: 1395
Joined: Sat Apr 07, 2007 12:51 am

Re: Connection issues here at OLH, Traffic, and CF down

Post by atomross13 »

I hate spiders.
Eat, Drink, Smoke, ...... and be Happy :)
Post Reply