From owner-freebsd-performance@FreeBSD.ORG Wed May 21 14:45:10 2008 Return-Path: Delivered-To: freebsd-performance@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 147A0106567A for ; Wed, 21 May 2008 14:45:10 +0000 (UTC) (envelope-from t.pajor@kei.pl) Received: from smtp.kei.pl (v45.rev.tld.pl [195.149.224.45]) by mx1.freebsd.org (Postfix) with ESMTP id 447F68FC1E for ; Wed, 21 May 2008 14:45:08 +0000 (UTC) (envelope-from t.pajor@kei.pl) Received: (qmail 18251 invoked by uid 45007); 21 May 2008 14:45:07 -0000 X-clamdmail: clamdmail 0.18a Received: from v45.rev.tld.pl (t.pajor@kei.pl@195.149.224.45) by smtp.kei.pl with ESMTPA; 21 May 2008 14:45:07 -0000 References: <20080521155508.6ccfcfb5@twoflower.in.publishing.hu> In-Reply-To: <20080521155508.6ccfcfb5@twoflower.in.publishing.hu> Received: from 195.149.231.62 (Poczta WWW Kei.pl authenticated user t.pajor@kei.pl) by poczta45.kei.pl with HTTP; Wed, 21 May 2008 16:45:07 +0200 (CEST) Message-ID: <3abeb97e28be5b2107ea97e65ae88762.t.pajor@kei.pl> From: To: Content-Transfer-Encoding: quoted-printable Date: Wed, 21 May 2008 16:45:07 +0200 MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-2 X-Priority: 3 X-Mailer-Version: 1.0 X-Mailer: Poczta WWW Kei.pl X-Organisation: Kei.pl X-User-IP: 195.149.231.62 X-Http-User-Agent: Opera/9.50 (X11; Linux i686; U; en) X-Mailman-Approved-At: Wed, 21 May 2008 15:27:10 +0000 Subject: Re: mysql performance on freebsd 7 X-BeenThere: freebsd-performance@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Performance/tuning List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 21 May 2008 14:45:10 -0000 > May I ask whether you are using innodb or myisam? both on freebsd and Lin= ux. > And what filesystem are you using for mysql's data files? UFS, ZFS o= r anything > else? MySQL engine used is MEMORY, filesystem is ufs, but = it's not relevant. =20 > IIRC there's some hack to reduce gettimeofday()'= s precision in advance to > enhance it's performance, that could also help= a bit. What do You mean? > Have you built your mysql with linking it= against libthr? It's a standard build from ports-current. Stats are = at http://p1.kei.pl/mon/