Mysql - Linuxthreads : Still needed?

Paul Armstrong freebsdhackers at otoh.org
Tue Nov 9 13:14:01 PST 2004


On Tue, Nov 09, 2004 at 09:53:08PM +0100, jesk wrote:
> > For those that like a link:
> >
> > http://marc.theaimsgroup.com/?l=freebsd-current&m=109842492327954&w=2
> >
> > On Tue, 9 Nov 2004, jesk wrote:
> >
> > >> It would be nice if you could post the resaults back to the list
> > >> so other do not have to go through these steps and maybe create
> > >> an interesting disccusion about the use of linuxthreads with
> > >> MySQL or the "new" threading lib in fbsd.
> > >>
> > >> I my self am about to embark on quest to upgrade my servers from
> > >> 4.10 to 5.3-RELEASE and resault from a test like this would be
> > >> greatly appriceated since then I (and propably many others) will
> > >> not have to duplicate the efforts.
> > >>
> > >> Anyways, I could always run some tests to for comparisment.
> > >
> > > I did a performance comparison with different threading methods.
> > > Look for MySQL Performance thread on current@
> > >
> >
> fbsd outperformed linux in the end of my tests. ;)
> dont forget to disable HTT, this will increase the performance of threading.

The thread mentions that "update query first then select query" is
faster on Linux. What did you need to change to fix that (or did one of
the updates on the way to STABLE fix it)?

Paul



More information about the freebsd-hackers mailing list