I noticed an issue with MySQL v3.23.40 on my Linux box where after a
random amount of time (usually over an hour) MySQL runs a hell of a lot
of threads for no apparent reason. I watched it when i ran mysqladmin
-uroot -i 5 status as it went from 1 or 2 threads to 10, 20, 40, 50, 60,
70...(and had a hell of a lot of open tables as well) and then finally
crashed. I can't stop MySQL after the crash or kill the process from
the Linux command line, only way to fix is reboot the system. Anyone
have any idea why this happens...I have it running a crontab which
restarts mysql every hour...which bypasses the issue sort of...but would
like to avoid the cron.
Thanks,
Chris Hilbert
