Solution: FreeBSD and MySQL - mysqld eats CPU alive

[Martin Blapp]

Hi all,

We have many Mysql's running here, and just to tell you, there
are fixes/workarounds for the behaviour you see:

FreeBSD 4.8 / 4.9 / 4.10 :
--------------------------

Compile port with WITH_LINUXTHREADS=YES or remove tcpwrappers
support manually from the build if it hangs with libc_r. Use IP adresses for
master/slave configurations in my.cnf. On problem here is that getnamebyhost()
is not threadsafe. This produces the strange errors you see.

We run all mysqld without tcpwrappers support and do not have any
hangs anymore.

FreeBSD 5.2.1
-------------

You have to use libc_r.so libpthreads.so hangs occasionally

FreeBSD Current
---------------

You can use libpthrads.so or libc_r.so

Martin

Martin Blapp, <mb at imp.ch> <mbr at FreeBSD.org>
------------------------------------------------------------------
ImproWare AG, UNIXSP & ISP, Zurlindenstrasse 29, 4133 Pratteln, CH
Phone: +41 61 826 93 00 Fax: +41 61 826 93 01
PGP: <finger -l mbr at freebsd.org>
PGP Fingerprint: B434 53FC C87C FE7B 0A18 B84C 8686 EF22 D300 551E
------------------------------------------------------------------