From owner-freebsd-threads@FreeBSD.ORG Wed Apr 14 03:54:46 2004 Return-Path: Delivered-To: freebsd-threads@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id D12AF16A4CE for ; Wed, 14 Apr 2004 03:54:46 -0700 (PDT) Received: from publicd.ub.mng.net (publicd.ub.mng.net [202.179.0.88]) by mx1.FreeBSD.org (Postfix) with ESMTP id 0EA1D43D2D for ; Wed, 14 Apr 2004 03:54:43 -0700 (PDT) (envelope-from ganbold@micom.mng.net) Received: from [202.179.0.164] (helo=ganbold.micom.mng.net) by publicd.ub.mng.net with asmtp (Exim 4.30; FreeBSD) id 1BDiuO-000P9o-RI; Wed, 14 Apr 2004 19:50:24 +0800 Message-Id: <6.0.3.0.2.20040414195314.02a5ac88@202.179.0.80> X-Sender: ganbold@micom.mng.net@202.179.0.80 X-Mailer: QUALCOMM Windows Eudora Version 6.0.3.0 Date: Wed, 14 Apr 2004 19:59:33 +0900 To: Alexander Leidinger From: Ganbold In-Reply-To: <20040414124103.6ba2b65c@Magellan.Leidinger.net> References: <20040413204833.17d23b10@Magellan.Leidinger.net> <20040414124103.6ba2b65c@Magellan.Leidinger.net> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed cc: kenm@icarz.com cc: mysql@lists.mysql.com cc: julian@elischer.org cc: threads@freebsd.org Subject: Re: FBSD 5.2.CURRENT-p4 and mysqld problems X-BeenThere: freebsd-threads@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Threading on FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 14 Apr 2004 10:54:46 -0000 Hi, So what threading library should I use with mysql? Can somebody recommend me which to use? Because I'm bit confused. I used to use linuxthreads and it was pretty good. Now there appears some other threading libraries:) Which one is reliable and has good performance? Ganbold At 07:41 PM 14.04.2004, you wrote: >On Tue, 13 Apr 2004 14:49:41 -0700 (PDT) >Julian Elischer wrote: > > > So is this with system scope threads or process scope threads? > >Whatever MySQL uses when compiled to use libpthread. > > > what is the performance like? > >It's a different system (2.4 GHz P4, vinum-stripe on 2 SATA disks >(ICH5), 1GB RAM) and the kernel is compiled with icc, so I can't >compare. But it was fast. Just some seconds to add this with the mysql >client program: > % wc nurdaten.sql > 30161 180515 4781902 nurdaten.sql > > % grep INSERT nurdaten.sql | wc -l > 30007 > >The other system (2.8 GHz P4, ATA-stripe (Promise) on 2 SATA disks, 1GB >RAM) with a -current as of March 19 needed several seconds longer (with >linuxthreads instead of pthreads). But we're comparing apples with >oranges here. > >Bye, >Alexander. > >-- > I'm available to get hired. > >http://www.Leidinger.net Alexander @ Leidinger.net > GPG fingerprint = C518 BC70 E67F 143F BE91 3365 79E2 9C60 B006 3FE7