Date: Mon, 2 Aug 2004 13:48:34 +0200 (CEST) From: Martin Blapp <mb@imp.ch> To: freebsd-hackers@freebsd.org Cc: questions@freebsd.org Subject: Solution: FreeBSD and MySQL - mysqld eats CPU alive Message-ID: <20040802133701.V27692@cvs.imp.ch>
next in thread | raw e-mail | index | archive | help
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@imp.ch> <mbr@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@freebsd.org> PGP Fingerprint: B434 53FC C87C FE7B 0A18 B84C 8686 EF22 D300 551E ------------------------------------------------------------------
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20040802133701.V27692>