From owner-freebsd-threads@FreeBSD.ORG Wed Apr 14 03:40:57 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 064FB16A4CE for ; Wed, 14 Apr 2004 03:40:57 -0700 (PDT) Received: from mailout09.sul.t-online.com (mailout09.sul.t-online.com [194.25.134.84]) by mx1.FreeBSD.org (Postfix) with ESMTP id 5EC5143D48 for ; Wed, 14 Apr 2004 03:40:56 -0700 (PDT) (envelope-from Alexander@Leidinger.net) Received: from fwd09.aul.t-online.de by mailout09.sul.t-online.com with smtp id 1BDhp7-0004NV-03; Wed, 14 Apr 2004 12:40:53 +0200 Received: from Andro-Beta.Leidinger.net (SyGed8ZCQe307m6MXNUvBE7+WgVWCh3nY+3DLcmaK91elvhO5O1k8w@[217.83.19.131]) by fmrl09.sul.t-online.com with esmtp id 1BDhox-07YZKy0; Wed, 14 Apr 2004 12:40:43 +0200 Received: from Magellan.Leidinger.net (Magellan.Leidinger.net [192.168.1.1]) i3EAecbq050852; Wed, 14 Apr 2004 12:40:38 +0200 (CEST) (envelope-from Alexander@Leidinger.net) Date: Wed, 14 Apr 2004 12:41:03 +0200 From: Alexander Leidinger To: Julian Elischer Message-Id: <20040414124103.6ba2b65c@Magellan.Leidinger.net> In-Reply-To: References: <20040413204833.17d23b10@Magellan.Leidinger.net> X-Mailer: Sylpheed version 0.9.10claws (GTK+ 1.2.10; i386-portbld-freebsd5.2) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Seen: false X-ID: SyGed8ZCQe307m6MXNUvBE7+WgVWCh3nY+3DLcmaK91elvhO5O1k8w@t-dialin.net cc: Alexander Leidinger cc: threads@freebsd.org cc: Ken Menzel 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:40:57 -0000 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