On Thu, Nov 07, 2002 at 08:48:15AM -0500, Grigor, Peter wrote: > 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.
The problem is the MySQL (by default) uses name resolution extensively. But the resolver calls are not thread-safe on FreeBSD. Race coniditions exist that can cause odd cicumstances which result in MySQL thrashing a bit. > 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. It's not a MySQL problem--it's a FreeBSD problem. This problem doesn't exist on other platforms. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 3.23.51: up 93 days, processed 1,954,122,045 queries (241/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