Ok, we know that FreeBSD has problems with its thread implementation; however, I'd like to know if the MySql guys know exactly what causes the problems to which Mr Zawodny refers.
I'm running FreeBSD 4.6.2, and have seen the 'rogue thread' problem before which leads me to believe that either FreeBSD has not addressed the problem or MySql hasn't. To be fair MySql says in its documentation that FreeBSD is not recommended because of its threading implementation. Furthermore, I wonder if anyone has been working with MySql and FreeBSD 5.0 DP1 and, if so, what behavior they've experienced. Peter <^_^> -----Original Message----- From: Simon Green [mailto:sgreen@;eurobell.net] Sent: Thursday, November 07, 2002 6:04 AM To: 'Bogdan TARU'; [EMAIL PROTECTED] Subject: RE: MySQL CPU usage skyrocketing See links form mail list. http://jeremy.zawodny.com/blog/archives/000203.html#000203 http://jeremy.zawodny.com/blog/archives/000264.html#000264 Simon -----Original Message----- From: Bogdan TARU [mailto:bgd@;icomag.de] Sent: 07 November 2002 10:35 To: [EMAIL PROTECTED] Subject: MySQL CPU usage skyrocketing Hi, I am running MySQL 3.23.41 on a FreeBSD 4.4, and I experience very high loads of the machine, without any apparent reason. We have a new project using this MySQL engine, with lots of inserts/deletes. But it happens that in the mornings, when nobody makes any kind of access to the database, we still have a MySQL daemon eating up 99% of CPU. If I log in as 'root' to the mysql server and make a 'show processlist', the only process in the 'query' command is mine ('show processlist'), all the others are in sleep mode (with NULL info). Is there any periodic maintanance/optimization work that the mysql server is doing? If so, why does it take so long? Can I schedule it sometimes during the night (and if so, how?) Thanks, bogdan ---------------------------- iCom Media AG Kirchweg 36 Koln, 50858 Germany Phone: +49-(0)221-485-689-16 Fax : +49-(0)221-485-689-20 Mobile:+49-(0)173-906-46-01 --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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