From owner-freebsd-performance@FreeBSD.ORG  Thu Jan 26 00:27:00 2006
Return-Path: <owner-freebsd-performance@FreeBSD.ORG>
X-Original-To: performance@freebsd.org
Delivered-To: freebsd-performance@FreeBSD.ORG
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id AE31916A420
	for <performance@freebsd.org>; Thu, 26 Jan 2006 00:27:00 +0000 (GMT)
	(envelope-from rwatson@FreeBSD.org)
Received: from cyrus.watson.org (cyrus.watson.org [209.31.154.42])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 3CFFE43D48
	for <performance@freebsd.org>; Thu, 26 Jan 2006 00:27:00 +0000 (GMT)
	(envelope-from rwatson@FreeBSD.org)
Received: from fledge.watson.org (fledge.watson.org [209.31.154.41])
	by cyrus.watson.org (Postfix) with ESMTP id 0F83346B83;
	Wed, 25 Jan 2006 19:26:53 -0500 (EST)
Date: Thu, 26 Jan 2006 00:28:19 +0000 (GMT)
From: Robert Watson <rwatson@FreeBSD.org>
X-X-Sender: robert@fledge.watson.org
To: Ivan Voras <ivoras@fer.hr>
In-Reply-To: <43D7C337.7080701@fer.hr>
Message-ID: <20060126002646.R89523@fledge.watson.org>
References: <43D75F58.7090505@webmatic.de> <43D7C337.7080701@fer.hr>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed
Cc: performance@freebsd.org, "Thomas Krause \(Webmatic\)" <tk@webmatic.de>
Subject: Re: mysql performance tuning @ FreeBSD6
X-BeenThere: freebsd-performance@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: Performance/tuning <freebsd-performance.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-performance>,
	<mailto:freebsd-performance-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-performance>
List-Post: <mailto:freebsd-performance@freebsd.org>
List-Help: <mailto:freebsd-performance-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-performance>,
	<mailto:freebsd-performance-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Thu, 26 Jan 2006 00:27:00 -0000


On Wed, 25 Jan 2006, Ivan Voras wrote:

> Thomas Krause (Webmatic) wrote:
>
>> But with static linked libraries, I cannot switch between
>> libthread and libthr - right? Could somebody give me an inspiration/
>> recommendation?
>
> Unless you are ready to count individual CPU cycles, you won't find a 
> noticable difference between static and dynamic linked executables on 
> application such as MySQL. You should probably leave them dynamic so you can 
> experiment with libmap.
>
> If you tried everything from here: 
> http://wikitest.freebsd.org/moin.cgi/MySQL and still get low results, then 
> you're out of luck.

BTW, I've updated the page to point at the timestamp wrapper library:

     http://www.watson.org/~robert/freebsd/clock/

Still the imperfect prototype, I'd love to see some practical feedback on any 
performance impact it has for MySQL or other applications along those lines. 
Basically, you preload this library and set an environmental variable to
override the application's selection of clock quality for gettimeofday() and 
time().

Robert N M Watson