Date: Tue, 20 Apr 2004 15:13:06 -0400 From: "Ken Menzel" <kenfreebsd@icarz.com> To: <freebsd-threads@freebsd.org> Subject: Re: MySQL and libpthread Message-ID: <05b101c4270b$82e696d0$8adb7bd1@icarz.com> References: <Pine.GSO.4.10.10404200731590.23563-100000@pcnet5.pcnet.com>
next in thread | previous in thread | raw e-mail | index | archive | help
Hi Dan, Looks like a simple enough patch, is this something that should be suggested to the mysql folks to include in future versions for FreeBSD? Looks like this patch does not break 4.9 with or without Linux threads. (I checked). Is there any downside to this for FreeBSD? Would other platforms perhaps benefit from this change? Ken ----- Original Message ----- From: "Daniel Eischen" <eischen@vigrid.com> To: "Mike Silbersack" <silby@silby.com> Cc: <threads@freebsd.org> Sent: Tuesday, April 20, 2004 7:39 AM Subject: Re: MySQL and libpthread > On Tue, 20 Apr 2004, Mike Silbersack wrote: > > > > > I haven't had time to fully track it down yet, but FYI I've found that > > MySQL and libpthread don't seem to get along well for me; with sources > > from april 12th and mysql 4.1 from ports, mysqld just seems to hang for > > long periods of time, and is unkillable. When I libmap it to libthr or > > libc_r, all is well. > > There are a lot of posts regarding mysql in the threads > archives. Two things -- mysql with libwrap support doesn't > work with default CFLAGS (-march), and mysql uses scope > system threads which chew up more kernel resources and > can hang when you hit kern.threads.* limits. > > To make mysql40 use scope process threads: > > http://people.freebsd.org/~deischen/mysql40-server.diffs > > > The test I was running was simply mysql's included benchmark suite, using > > local socket connections to mysql. If one of the libpthread developers > > can not reproduce this behavior, I'll try more tests later in the week to > > see if I can pin it down more. > > I've got mysql40-server running here with the above patches > and a test script that causes creation of 1800 mysql threads. > > -- > Dan Eischen > > _______________________________________________ > freebsd-threads@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-threads > To unsubscribe, send any mail to "freebsd-threads-unsubscribe@freebsd.org" >
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?05b101c4270b$82e696d0$8adb7bd1>