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

Reply via email to