|
Home > Archive > Apache Server configuration support > August 2006 > apache: heavy load + mysql: too many connections
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
apache: heavy load + mysql: too many connections
|
|
| Felix Natter 2006-08-29, 1:50 am |
| hi,
on an apache 1.3.37/mysql 3.23.49 server we often experience a extensive
slowdown and we get random "Too many connections" errors from the
MySQL-server. The problem goes away for a short time when I restart the
apache (apparently not when restarting mysql).
I tried to use mtop (shows the sql queries currently processed) to find out
what's causing this, but I see nothing special. I have also already
incremented the mysql max_connections variable.
How can I find out what causes this without having to read *all* apache
logs (which is impossible)? What tools should I be using?
thank you!
--
Felix Natter
| |
| Davide Bianchi 2006-08-29, 1:50 am |
| On 2006-08-28, Felix Natter <fnatter@gmx.net> wrote:
> slowdown and we get random "Too many connections" errors from the
> MySQL-server.
That make me think that you are running some kind of web application
that doesn't use connection-pooling, so each and every request is a new
connection, the connection is then not properly terminated for some
reason.
I'm not sure if there is a tool that could show up some usefull information,
the only thing you can do is to get a good software debugger and start
debugging your applications.
Davide
--
A four-year-old child could understand that. Run out and find me
a four-year-old child, I can't make head or tail out of it.
-- Julius Henry "Groucho" Marx (http://en.wikiquote.org/wiki/Groucho_Marx)
|
|
|
|
|