On Wed, Aug 01, 2001 at 10:46:39PM -0500, Chris Hilbert wrote:
>
> 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.
Are you running a MySQL binary that you compiled?
Can you capture the output of SHOW PROCESSLIST before it happens?
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 <-- NEW
MySQL 3.23.29: up 46 days, processed 372,337,510 queries (91/sec. avg)
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
