Date: Sat, 22 Feb 2003 10:28:06 +0100 (CET) From: Martin Blapp <mb@imp.ch> To: freebsd-bugs@FreeBSD.org Cc: HiTech Creations Support <htsupp@hitechcreations.com> Subject: Re: kern/39878: mysqld process suddenly runs at 99% CPU without load, and a restart of mysqld is required. Message-ID: <20030222102442.A55282@levais.imp.ch>
next in thread | raw e-mail | index | archive | help
Hi,
We had this problem too. There are several problems causing
this. Some of them are libc_r bugs and some parts of FreeBSD
aren't even threadsafe (gethostbyname, realpath) ...
You can solve all these problems with:
make WITH_LINUXTHREADS=YES
and use this patch for mysql:
--- sql/violite.c.orig Fri Feb 21 17:02:16 2003
+++ sql/violite.c Fri Feb 21 17:03:38 2003
@@ -110,6 +110,9 @@
vio->sd);
#if !defined(___WIN__) && !defined(__EMX__) && !defined(OS2)
#if !defined(NO_FCNTL_NONBLOCK)
+#if defined(__FreeBSD__)
+ fcntl(sd, F_SETFL, vio->fcntl_mode); /* Yahoo! FreeBSD patch */
+#endif
vio->fcntl_mode = fcntl(sd, F_GETFL);
#elif defined(HAVE_SYS_IOCTL_H) /* hpux */
/* Non blocking sockets doesn't work good on HPUX 11.0 */
--- libmysql/violite.c.orig Fri Feb 21 17:02:31 2003
+++ libmysql/violite.c Fri Feb 21 17:04:09 2003
@@ -110,6 +110,9 @@
vio->sd);
#if !defined(___WIN__) && !defined(__EMX__) && !defined(OS2)
#if !defined(NO_FCNTL_NONBLOCK)
+#if defined(__FreeBSD__)
+ fcntl(sd, F_SETFL, vio->fcntl_mode); /* Yahoo! FreeBSD patch */
+#endif
vio->fcntl_mode = fcntl(sd, F_GETFL);
#elif defined(HAVE_SYS_IOCTL_H) /* hpux */
/* Non blocking sockets doesn't work good on HPUX 11.0 */
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
------------------------------------------------------------------
To Unsubscribe: send mail to majordomo@FreeBSD.org
with "unsubscribe freebsd-bugs" in the body of the message
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20030222102442.A55282>