Running out of database connections

Ted

Administrator
Staff member
Joined
Dec 21, 2002
Messages
367
Are you guys having frequent trouble connecting to the database during peak hours? I'm talking about getting that nasty max_user_connections error message. I would like to know if this is getting to be annoying or if it's just like once a month that it happens to you.

Thanks!
Ted
 
Just right now, yes, I've been having problems with that.

Maybe you're getting "too" popular...? :wink:

Eliz.
 
When are peak hours? I have not experienced any difficulties. I'm not usually on in the early evening.
 
I have difficulty on occasion, but it's not a lot.
 
But I digress. Last night I had a terrible time with it.
 
galactus said:
Last night I had a terrible time with it.
Me, too. It was centered around 9:15-ish (central time) last night, and lasted more than half an hour, if I recall correctly.

Eliz.
 
Yeah I'm not surprised it was slow on Tuesday... somebody came in and spidered the entire forum so there were about 70,000 pages requested in an hour or so. It wasn't a regular search engine but I haven't looked deep into the logs to see what it was.

I've also removed the headline feed from the homepage so hopefully that will reduce the unnecessary database activity and clear things up a little.
 
What are spiders anyway?. Is it remote computers programmed to send out those porn and pill sites?.
 
No, not like that. I'm talking about like Googlebot, which is what Google uses to visit billions of web pages a month. It comes around, visits your links, but generally doesn't cause a problem.

In this case, somebody else had a program like this that got into the forum and just chewed through all the tens of thousands of posts and member profiles and other stuff that most spiders (robots) ignore.
 
I have been having an unusually rough time logging on today. Keep getting that error message. Anyone else?.
 
Yes; me, too. (Though naturally the problem has eased by now, or else I couldn't have replied. :wink:)

Perhaps some thought should be given to installing a bad-bot trap to protect the site...?

Eliz.
 
I'm not sure if that's the problem today. Hmm. I'll remove the message board feed from the remaining HTML pages to see if that helps some.

Thanks for keeping me updated guys! :)

------------------------------

note: I'm having real trouble posting this message now... something has to be done. If this doesn't help then when I get back from Spring Break I'll have to talk to my host. I don't really want to move to a dedicated server but it may be necessary.

Hang in there guys, I appreciate your patience!
Ted
 
Problem Solved!

It wasn't the forum after all... it was actually my math glossary. There was one line of code that was using a pconnect instead of connect, so the connections weren't being closed properly. There was also an old tracking script I had on some old pages that weren't even linked from anywhere on the site anymore, so I deleted those and removed the scripts.

In English that means... I better not see this problem again, but PLEASE post if it does show up.

Ted
 
Top