Slow Server with MySQL Errors

scattered · November 18th, 2005, 10:45 PM

I've been having some problems with my server. Since i moved onto it I've been getting MySQL errors "max_users_connected". Surpass has been good trying to help me out.

I was wondering if someone else could think of a reason. So far they've told me it seems like a problem with one of the running services. After they said they tweaked services and settings, I'm still getting the errors or painfully slow loading times.

My site, www.greendaycommunity.org doesn't even load right now. And usually when it does it's either slow or gives me a MySQL error.

Anyone had this problem or know of a possible solution?

**David** · November 19th, 2005, 12:08 AM

I know there was a user on the board here who complained about his Invision Board forum running into this error before, and after reading through the forums over at IPB, it seems like it's either a problem with persistant connection being set to ON (in the server that is) or a problem with MySQL not dropping the connection like it should.

scattered · November 19th, 2005, 12:22 AM

Yeah i sent in a ticket to support with Invision and they told me that it was a server issue. So i'm not really sure where to turn anymore.

scattered · November 19th, 2005, 12:26 AM

Well i just found this thread on their forum

http://forums.invisionpower.com/inde...hl=MySQL+Error

Guess it could be an Invision problem.

**David** · November 19th, 2005, 12:32 AM

Well, I know you can turn off persistant connections now. It's buried in the code somewhere, I think in init.php but I'm not sure now. That is, if you're using the most up to date version.

scattered · November 19th, 2005, 12:40 AM

Yeah, actually this just started happening after we upgraded to 2.1

**David** · November 19th, 2005, 12:44 AM

Which version of 2.1 are you running? I have 2.1.1 running and haven't had any trouble like this with it (of course, mine isn't used very regularly) and am about to start using 2.1.3 instead.

scattered · November 19th, 2005, 12:55 AM

Yeah I'm using 2.1.3.

The forum just came back up, but i turned it offline till i hopefully find whatever is causing this.

**David** · November 19th, 2005, 1:00 AM

Probably a good idea. My 2.1.3 isn't active for users yet so I haven't run into this. Hopefully it will be solved soon.

November 18th, 2005, 10:45 PM	#1 (permalink)
scattered Registered User Fresh Surpasser Joined in Nov 2005 8 posts Gave thanks: 1 Thanked 0 times	Slow Server with MySQL Errors I've been having some problems with my server. Since i moved onto it I've been getting MySQL errors "max_users_connected". Surpass has been good trying to help me out. I was wondering if someone else could think of a reason. So far they've told me it seems like a problem with one of the running services. After they said they tweaked services and settings, I'm still getting the errors or painfully slow loading times. My site, www.greendaycommunity.org doesn't even load right now. And usually when it does it's either slow or gives me a MySQL error. Anyone had this problem or know of a possible solution?

November 19th, 2005, 12:08 AM	#2 (permalink)
David says GIMME SOME MORE! Resident. Joined in Mar 2004 Lives in fear of Obama. Hosted on Pass 7 13,092 posts Gave thanks: 8 Thanked 34 times	I know there was a user on the board here who complained about his Invision Board forum running into this error before, and after reading through the forums over at IPB, it seems like it's either a problem with persistant connection being set to ON (in the server that is) or a problem with MySQL not dropping the connection like it should. __________________

November 19th, 2005, 12:32 AM	#5 (permalink)
David says GIMME SOME MORE! Resident. Joined in Mar 2004 Lives in fear of Obama. Hosted on Pass 7 13,092 posts Gave thanks: 8 Thanked 34 times	Well, I know you can turn off persistant connections now. It's buried in the code somewhere, I think in init.php but I'm not sure now. That is, if you're using the most up to date version. __________________

November 19th, 2005, 12:44 AM	#7 (permalink)
David says GIMME SOME MORE! Resident. Joined in Mar 2004 Lives in fear of Obama. Hosted on Pass 7 13,092 posts Gave thanks: 8 Thanked 34 times	Which version of 2.1 are you running? I have 2.1.1 running and haven't had any trouble like this with it (of course, mine isn't used very regularly) and am about to start using 2.1.3 instead. __________________

November 19th, 2005, 1:00 AM	#9 (permalink)
David says GIMME SOME MORE! Resident. Joined in Mar 2004 Lives in fear of Obama. Hosted on Pass 7 13,092 posts Gave thanks: 8 Thanked 34 times	Probably a good idea. My 2.1.3 isn't active for users yet so I haven't run into this. Hopefully it will be solved soon. __________________

November 19th, 2005, 12:22 AM	#3 (permalink)
scattered Registered User Fresh Surpasser Joined in Nov 2005 8 posts Gave thanks: 1 Thanked 0 times	Yeah i sent in a ticket to support with Invision and they told me that it was a server issue. So i'm not really sure where to turn anymore.

November 19th, 2005, 12:26 AM	#4 (permalink)
scattered Registered User Fresh Surpasser Joined in Nov 2005 8 posts Gave thanks: 1 Thanked 0 times	Well i just found this thread on their forum http://forums.invisionpower.com/inde...hl=MySQL+Error Guess it could be an Invision problem.

November 19th, 2005, 12:40 AM	#6 (permalink)
scattered Registered User Fresh Surpasser Joined in Nov 2005 8 posts Gave thanks: 1 Thanked 0 times	Yeah, actually this just started happening after we upgraded to 2.1

November 19th, 2005, 12:55 AM	#8 (permalink)
scattered Registered User Fresh Surpasser Joined in Nov 2005 8 posts Gave thanks: 1 Thanked 0 times	Yeah I'm using 2.1.3. The forum just came back up, but i turned it offline till i hopefully find whatever is causing this.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search