PDA

View Full Version : MySQL max connections

mjp
6-12-04, 02:00 PM
The 'max connections' on the dedicated MySQL database servers (mysql01.powweb.com to mysql05.powweb.com) have been doubled, so we shouldn't see any more of the "mysql error: Too many connections" errors.

Note that the individual user limits remain at 72,000 max_questions per user per hour.
B&T
6-12-04, 04:53 PM
PowWeb comes through again :)
mjp
6-12-04, 06:38 PM
We don't like seeing errors any more than you guys do. ;)
BucShot
6-20-04, 01:14 PM
I'm not a fan of errors either, but right now www01 is out of memory...
tbonekkt
6-20-04, 02:11 PM
I'm not a fan of errors either, but right now www01 is out of memory...
How did you come to that conclusion? This thread is about the dedicated mysql servers, not the web servers.
bernie
6-24-04, 01:11 PM
I'm getting an out of memory error on mysql01. :(
B&T
6-24-04, 02:25 PM
I'm getting an out of memory error on mysql01. :(
If you have MySQL server out of memory errors (had a few myself lately), see this thread:

http://forum.powweb.com/showthread.php?t=38193

But the bottom line is this:

That error has started to show up more since PowWeb raised the max connections - so everyone would quit getting that error.

There will always be a weak link. They pegged the last one, now there is this one. On a shared service you just go down the line.

They let more users on by increasing the max connections, now sometimes there is no more "room at the inn" - out of memory.

If this happens a lot then Powweb will need to address this issue.
AdamSocial
7-3-04, 05:19 PM
I have a question regarding max_connections.

Does this open up a chance for a malicious user to somehow flood page requests, knowing that there are limitations on the amount of SQL connections permitted, in an kind of DOS attack?

It's almost a nightmare. I run a pretty successful local music scene site, and I've had to move hosts multiple times because I give a bands CD a bad review, they're immature, and resort to anything to bring me down.

I've been very happy so far with my tenure at powweb, and have only encountered the max_connections error once, running PHP-Nuke, with their integrated port of phpBB.

PS - For some reason, one of my database users that have reached max queries didn't reset at the top of the hour.

Thanks.
A concerned webmaster / MySQL n00b.
B&T
7-3-04, 06:06 PM
I suppose that could happen. But I suspect PowWeb would shut down your site if this was a continual problem.
secretvenues
7-4-04, 11:01 PM
Can someone please help us with this problem we have been having for the last 2 hours or longer.

ERROR! There was an error in the last mysql statement.
Please email the forum administrator to service this problem if this problem persists.


This is what were getting.

http://www.secretvenues.com/forum/
B&T
7-5-04, 10:09 AM
Can someone please help us with this problem we have been having for the last 2 hours or longer.

ERROR! There was an error in the last mysql statement.
Please email the forum administrator to service this problem if this problem persists.


This is what were getting.

http://www.secretvenues.com/forum/
Works fine for me.
hpa
7-12-04, 06:56 PM
I'm not familiar with the "72000 max_questions per user per hour"

What does this involve?

I only have a forum running with around 15 users on (AT ANY GIVING TIME). Most of them are on quite abit and they are getn this sql error.

As admin of my site, i need to be on alot and do things but i cannot see how users can be affected.

PLEASE educate me on this "72000 max_questions per user per hour" thingie.
B&T
7-12-04, 07:27 PM
I'm not familiar with the "72000 max_questions per user per hour"

What does this involve?

I only have a forum running with around 15 users on (AT ANY GIVING TIME). Most of them are on quite abit and they are getn this sql error.

As admin of my site, i need to be on alot and do things but i cannot see how users can be affected.

PLEASE educate me on this "72000 max_questions per user per hour" thingie.
http://forum.powweb.com/showthread.php?s=&threadid=23735
hpa
7-12-04, 07:38 PM
A query is essentially a request that a user puts through to the database.

So by having 72000 of these, how does that translates interms of forum activity (like surfing the forum and using forum functions)?
B&T
7-12-04, 08:21 PM
So by having 72000 of these, how does that translates interms of forum activity (like surfing the forum and using forum functions)?
I cannot imagine forum 15 users hitting the limit unless your forum software is really poorly written.
hpa
7-12-04, 08:41 PM
I cannot imagine forum 15 users hitting the limit unless your forum software is really poorly written.

Well i cannot imagine this:

Surfed my site normally all day yesterday at work and nothing happened. Logged of and went home....got back on my site (that's 2 hours after), browsed and replied a couple of PM when i got the 72000 sql error.

I dont think i used 72000 queries within 5 mins and just on browsing and replying to 2 PMs.