Skip site navigation (1)Skip section navigation (2)
Date:      Fri, 20 Mar 2009 13:38:27 -0400 (EDT)
From:      Matt Juszczak <matt@atopia.net>
To:        freebsd-questions@freebsd.org
Subject:   MySQL 5.0 on FreeBSD 7
Message-ID:  <alpine.BSF.2.00.0903201338190.29988@pluto.atopia.net>

Next in thread | Raw E-Mail | Index | Archive | Help
Hi all,

About a year ago, I setup MySQL 5.0.45 on a FreeBSD 6.x box (64 bit).  I 
read at the time that the use of pthreads with FreeBSD would significantly 
improve performance, but as I was running the 64 bit version of FreeBSD, I 
could not use them.

Fast forward to today - a different setup and new opportunity has allowed 
me to research this combination again.  This time, some reading I have 
done on the use of FreeBSD 7 with MySQL has shown significant performance 
increases, but none of them really mention in detail how MySQL was setup.

I decided to install a 64 bit version of FreeBSD 7.x (to address the 8 GB 
RAM in the box) and attempt to build with pthreads enabled, as well as a 
static build and optimized compiler options.  Once again, got the 
error/warning in ports that the linux pthreads only works with the i386 32 
bit setup.

So I'm wondering if anyone here has successfully seen a MySQL 5.x 
performance boost with FreeBSD 7 compared to that of FreeBSD 6 on a 64 bit 
architecture, and if so, what they did to enable that boost.

Thanks!

-Matt



Want to link to this message? Use this URL: <http://docs.FreeBSD.org/cgi/mid.cgi?alpine.BSF.2.00.0903201338190.29988>