From owner-freebsd-threads@FreeBSD.ORG Wed Apr 14 04:11:59 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 1A40E16A4CE for ; Wed, 14 Apr 2004 04:11:59 -0700 (PDT) Received: from cyber-media.co.uk (cms2.gotadsl.co.uk [81.6.247.204]) by mx1.FreeBSD.org (Postfix) with ESMTP id C3EEE43D5E for ; Wed, 14 Apr 2004 04:11:57 -0700 (PDT) (envelope-from ganbold@micom.mng.net) Received: from mail pickup service by cyber-media.co.uk with Microsoft SMTPSVC; Wed, 14 Apr 2004 12:16:05 +0100 thread-index: AcQiEeChFi5rkpCLQJarKoqfJdkCpg== Mailing-List: contact mysql-help@lists.mysql.com; run by ezmlm Precedence: bulk Delivered-To: mailing list mysql@lists.mysql.com Message-ID: <000f01c42211$e0a45130$0100000a@cybermedia.local> Content-Transfer-Encoding: 7bit Received-SPF: pass (lists: local policy designates 202.179.0.88 as permitted sender) X-Mailer: QUALCOMM Windows Eudora Version 6.0.3.0 Date: Wed, 14 Apr 2004 12:16:05 +0100 To: From: "Ganbold" Content-Class: urn:content-classes:message In-Reply-To: <20040414124103.6ba2b65c@Magellan.Leidinger.net> Importance: normal Priority: normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.132 References: <20040413204833.17d23b10@Magellan.Leidinger.net> <20040414124103.6ba2b65c@Magellan.Leidinger.net> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed X-Virus-Checked: Checked Status: X-OriginalArrivalTime: 14 Apr 2004 11:16:05.0359 (UTC) FILETIME=[E0BE8FF0:01C42211] 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 List-Id: Threading on FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 14 Apr 2004 11:11:59 -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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=Roland@cyber-media.co.uk