Skip site navigation (1)Skip section navigation (2)
Date:      Wed, 25 Jan 2006 17:56:59 +0000 (GMT)
From:      Robert Watson <rwatson@FreeBSD.org>
To:        Christopher Arnold <chris@arnold.se>
Cc:        current@freebsd.org
Subject:   Re: MySql and timekeeping?
Message-ID:  <20060125175504.Q70912@fledge.watson.org>
In-Reply-To: <20060125182006.I94600@home.arnold.se>
References:  <20060125182006.I94600@home.arnold.se>

next in thread | previous in thread | raw e-mail | index | archive | help

On Wed, 25 Jan 2006, Christopher Arnold wrote:

> some time ago there was some discussions regarding MySql and timekeeping.
>
> There was some ideas of using lower resolution when doing timekeeping to 
> keep the timekeeping cost down. Has anything been done in this area?
>
> Or should we stick to using Linux as our MySql platform?
>
> While we are at it, have anyone done a recent comparison of the MySql 
> performance under Linux and FreeBSD?

I added new clock_gettime() variants that allow retrieval of a low accuracy 
low granularity on -CURRENT, time stamp at low cost.  I also wrote a small 
wrapper library to allow people to compare before/after with various 
benchmarks.  I never really heard back from anyone authoritatively.  phk has 
also been circulating patches that reduce general CPU accounting measurement 
in the CPU by switching to a different definition of CPU time, which should 
also affect MySQL significantly, especially when running the MySQL benchmark 
client and server on the same hardware.

Robert N M Watson



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20060125175504.Q70912>