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)
Connection issues here at OLH, Traffic, and CF down
-
WadeFillingame
- Posts: 1530
- Joined: Wed Apr 04, 2007 12:14 am
-
Knuck42
- Posts: 1798
- Joined: Thu Apr 05, 2007 11:02 pm
Re: Connection issues here at OLH, Traffic, and CF down
Keep up the good work Wade!
:bigup:
: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/
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
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
Thanks Wade... I thought you had been attacked as well.
Keep up the excellent work... :cool:
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
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
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
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
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.
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
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/
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
I hate spiders.
Eat, Drink, Smoke, ...... and be Happy 