Page 1 of 2 12 LastLast
Results 1 to 10 of 16

Thread: Running out of database connections

  1. #1
    Administrator
    Join Date
    Dec 2002
    Posts
    324

    Running out of database connections

    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

  2. #2
    Elite Member stapel's Avatar
    Join Date
    Feb 2004
    Posts
    11,064
    Just right now, yes, I've been having problems with that.

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

    Eliz.

  3. #3
    Elite Member
    Join Date
    Apr 2005
    Location
    PA, USA
    Posts
    8,223
    When are peak hours? I have not experienced any difficulties. I'm not usually on in the early evening.

  4. #4
    Administrator
    Join Date
    Dec 2002
    Posts
    324
    5pm ish

  5. #5
    Elite Member
    Join Date
    Sep 2005
    Posts
    7,294
    I have difficulty on occasion, but it's not a lot.

  6. #6
    Elite Member
    Join Date
    Sep 2005
    Posts
    7,294
    But I digress. Last night I had a terrible time with it.

  7. #7
    Elite Member stapel's Avatar
    Join Date
    Feb 2004
    Posts
    11,064
    Quote Originally Posted by galactus
    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.

  8. #8
    Administrator
    Join Date
    Dec 2002
    Posts
    324
    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.

  9. #9
    Elite Member
    Join Date
    Sep 2005
    Posts
    7,294
    What are spiders anyway?. Is it remote computers programmed to send out those **** and pill sites?.

  10. #10
    Administrator
    Join Date
    Dec 2002
    Posts
    324
    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.

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •