Btown slow and 'too many connections'

Anything else.. come on in, and pull up a seat.

Moderator: Moderators

Post Reply
User avatar
kturock ( 592 )
2014 Painting Challenge Champion!
Posts: 4292
Joined: Sun Nov 20, 2005 12:55 am
Location: wpb., florida

Btown slow and 'too many connections'

Post by kturock »

According to btown's own stats, "In total there are 374 users online :: 204 registered, 27 hidden and 143 guests (based on users active over the past 60 minutes)
Most users ever online was 1114 on Mon Nov 28, 2011 10:04 pm".

Yet I've been slow and hit or miss and getting the 'too many connections' General Error" for the last several hours.

So if it's at 33% of it's max, wtf is the problem?

Here's the error I just got, again.

General Error

SQL ERROR [ mysql4 ]

Too many connections [1040]

An sql error occurred while fetching this page. Please contact an administrator if this problem persists
Heh, I was called a Grognard. ;-)


USPS Postal Inspectors: 1-877-876-2455
USPS complaint center delivery problem, lost mail, track & confirm, etc. 1-800-275-8777
MagickalMemories ( 832 )
Lord Logorrheic!
Posts: 16741
Joined: Thu Sep 04, 2003 11:38 pm
Location: St. Louis, MO - USA

Re: Btown slow and 'too many connections'

Post by MagickalMemories »

It's not at 33% of it's max. The more connections, the higher chance of something going wrong. The 1114 is not a true number. We did a reset on something one day last year, and it caused that day's connections to merge with some previous day's "highest" connection numbers. Our current record is about 500 at a time.
Our current plan is... screwy.
These messages just started happening tonight. It seems we're on a 2 to 3 year cycle. Every 2 to 3 years, this issue pops up unexpectedly. We've already started looking at new plans with the existing host, and are willing to go to a sivveret host if necessary. The Mechanic is on top of this one. : )

Eric
Lower rating? You ship first.

Give me a sense of humor Lord. Give me the grace to see a joke.
To get some humor out of life and pass it on to other folk.


I think what this situation needs is some imagination.

"...I'm a nerd, and I'm here tonight to stand up for the rights of other nerds.” – Gilbert Lowell

Want my help with a BTR or backout? All messages sent/posted should be in CHRONOLOGICAL order. Otherwise, I just won't read it.
Post Reply

Return to “Bartertown Cafe and Coffee”