Skip site navigation (1)Skip section navigation (2)
Date:      Fri, 20 Mar 2009 13:24:15 -0500
From:      Adam Vandemore <amvandemore@gmail.com>
To:        Matt Juszczak <matt@atopia.net>
Cc:        freebsd-questions@freebsd.org
Subject:   Re: MySQL 5.0 on FreeBSD 7
Message-ID:  <49C3DF4F.8020106@gmail.com>
In-Reply-To: <alpine.BSF.2.00.0903201338190.29988@pluto.atopia.net>
References:  <alpine.BSF.2.00.0903201338190.29988@pluto.atopia.net>

next in thread | previous in thread | raw e-mail | index | archive | help
Matt Juszczak wrote:
> 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
> _______________________________________________
> freebsd-questions@freebsd.org mailing list
> http://lists.freebsd.org/mailman/listinfo/freebsd-questions
> To unsubscribe, send any mail to 
> "freebsd-questions-unsubscribe@freebsd.org"
>
Opps

here is link:

http://people.freebsd.org/~kris/scaling/mysql.html

-- 
Adam Vandemore
Systems Administrator
IMED Mobility
(605) 498-1610




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