A friend of mine started up http://spammerhunters.com/index.php recently, and asked for some help tonight. It seemed at certain times throughout the day the site would freak out. Well, thanks to analyze.php, his analysis:
Quote:
"DB Error, could not list tables MySQL Error: User 'mysqluser' has exceeded the 'max_questions' resource (current value: 36000)"
I'm hitting the database query limit. And it re-queues each hour. "
He is currently with Powweb.
_________________ Paul Laudanski, Microsoft MVP Windows-Security
CastleCops: [de] [en] [wiki]
mospaw Nuke Cadet
Joined: Jul 16, 2003
Posts: 1
Posted:
Wed Jul 16, 2003 7:09 pm
Quote:
He is currently with Powweb.
Not for long!
I understand their desire to limit database queries so the shared box doesn't get too bogged down by any one site, and I knew the limitation before I signed up, but I had NO idea that NUKE was that heavy ... over 36,000 queries per hour (sometimes within 42 minutes) on the site's first day! YOW! (We did have 10,000 page views in our first day online.)
I'm disappointed that Powweb could not help me find out what was happening. I asked them specifically if I was hitting any limits, like bandwidth, database, etc. and they checked the logs and said I wasn't. Well, I was.
I'm searching for a dedicated box right now. Things should stabilize in a day or two.
Zhen-Xjell Nuke Cops Founder
Joined: Nov 14, 2002
Posts: 5939
Posted:
Wed Jul 16, 2003 7:13 pm
If you want to check out Jaguarpc.com, send an email inquiry to Greg Landis (admin at jaguarpc.com). Both Paul Wilders (http://wilderssecurity.com) and myself host dedicated with him. Tell'em I sent you, and point him to this thread.
_________________ Paul Laudanski, Microsoft MVP Windows-Security
CastleCops: [de] [en] [wiki]
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 vote in polls in this forum
