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

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
ed me diagnose similar issues in the past. When the problem arises,
this'll 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)