Re: Benchmark MySQL Performance On FreeBSD And Linux

[Scott Long <scottl@xxxxxxxxxx>]

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