RE: Crazy Threads
I was watching the log for errors, but none occurred. I absolutely lost at what this could be. I just did a mysql_install_db (and deleted the old) thinking maybe a permission might be messed up. We'll see if that helps. Chris Hilbert -Original Message- From: Werner Stuerenburg [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 02, 2001 8:46 AM To: Chris Hilbert Cc: [EMAIL PROTECTED] Subject: Re: Crazy Threads Chris Hilbert schrieb am Donnerstag, 2. August 2001, 12:54:55: > Its seems like the only way to watch the process list would be to do > something like mysqladmin -uroot -i 1 processlist. Since I can't show > processlist when it won't connect to it (I tried to do it while it was > dead). Still, this would consume a lot of resource and might not even > work right...since I'd technically have to wait an hour or so for it > to crash. > Any other ideas? You could watch the log file and error log. Those grow pretty big very fast, so you could rename the old ones and start new ones. Data from an hour should be easy to manage. Hence you will see exactly what mysql does and what kind of errors occur, if any. -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 . Fax 0(049) 5224-997 409 http://pferdezeitung.de - 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
Re: Crazy Threads
Chris Hilbert schrieb am Donnerstag, 2. August 2001, 12:54:55: > Its seems like the only way to watch the process list would be to do > something like mysqladmin -uroot -i 1 processlist. Since I can't show > processlist when it won't connect to it (I tried to do it while it was > dead). Still, this would consume a lot of resource and might not even > work right...since I'd technically have to wait an hour or so for it to > crash. > Any other ideas? You could watch the log file and error log. Those grow pretty big very fast, so you could rename the old ones and start new ones. Data from an hour should be easy to manage. Hence you will see exactly what mysql does and what kind of errors occur, if any. -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 ยท Fax 0(049) 5224-997 409 http://pferdezeitung.de - 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
Re: Crazy Threads
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