Benchmark MySQL Performance On FreeBSD And Linux

[Scott Long]

Gea-Suan Lin wrote:

> On Fri, Dec 16, 2005 at 08:06:09AM +0100, Rink Springer wrote:
> 
>>>And you should disable these options, it may increase ~10% again:
>>>
>>>-cpu             I486_CPU
>>>-cpu             I586_CPU
>>> cpu             I686_CPU
>>
>>A recent discussion on -STABLE warned against removing I586_CPU, refer
>>to
>>http://lists.freebsd.org/pipermail/freebsd-stable/2005-December/020696.html
>>for more information.
> 
> 
> Thanks, I'll try it later.
> 
> BTW, did anyone try using jemalloc to test mysql ?
> 

It was tried recently using supersmack and unix domain sockets.  The
results were slightly slower (around 6%, IIRC).  The theory is that
jemalloc doesn't pad out allocations as much, so there is high potential
for cache line sharing (and thus cache thrash) between CPUs.

Scott