|
Home > Archive > Web Servers on Unix and Linux > September 2006 > apache: severe load problems + 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: severe load problems + mysql: too many connections
|
|
| Felix Natter 2006-08-28, 7:23 pm |
| 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.
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
| |
| Juha Laiho 2006-09-02, 1:24 pm |
| Felix Natter <fnatter@gmx.net> said:
>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).
....
>How can I find out what causes this without having to read *all* apache
>logs (which is impossible)? What tools should I be using?
The server-status display of Apache (with ExtendedStatus enabled) has
helped me diagnose similar issues in the past. When the problem arises,
this'll help you see what URLs are being accessed at the moment.
One thing you could be dealing with is too lax timeout for persistent
connections, or overall allowing too many persistent connections at
a given time. It may sound backwards, but at times throttling down
may give better performance.
--
Wolf a.k.a. Juha Laiho Espoo, Finland
(GC 3.0) GIT d- s+: a C++ ULSH++++$ P++@ L+++ E- W+$@ N++ !K w !O !M V
PS(+) PE Y+ PGP(+) t- 5 !X R !tv b+ !DI D G e+ h---- r+++ y++++
"...cancel my subscription to the resurrection!" (Jim Morrison)
|
|
|
|
|