Skip site navigation (1)Skip section navigation (2)
Date:      Wed, 28 Apr 2004 17:08:05 -0700
From:      Jeremy Gray <Jeremy@jpgsworld.com>
To:        freebsd-amd64@freebsd.org
Subject:   FreeBSD AMD64 + high performance MySQL - Possible?
Message-ID:  <5.2.0.9.2.20040428170631.014778f0@127.0.0.1>

next in thread | raw e-mail | index | archive | help

A person I know runs a very large forum using a dual AMD Opteron box
running AMD64 Linux for the MySQL database backend. I think he does several
thousand concurrent connections per second or something.

I intend to do the same, and have the hardware sitting here to do it...

But alas, I am a FreeBSD user and would like to stay that way for this
database server if possible.


I read a lot on Jeremy Zawodny's BLOG site (Yahoo's server god I guess)
where he initially slammed MySQL on FreeBSD because of FreeBSD's
poor thread support vs linux and then made several follow ups....

The first stating that if you compile MySQL on FreeBSD with inuxThreads
support it will eliminate the poor threading issue. (Which, afaik, is not 
an option
  for me on AMD64)

The second follow up he made was that FreeBSD 5.2 and on (for i386) use
a new threading method (called?) that helps resolve FreeBSD's threading issues
with MySQL.

But I noticed in just last weeks archives that people were still discussing
FreeBSD + MySQL problems... presumably on intel architecture.

Several weeks ago the MySQL port maintainer Alex Dupre was given
access to our Opteron machine in order to make optimizations the port
for AMD64. But I think at the time he said the new threading was still
being worked on or something.

So I guess my question is... does anyone know the best way to compile
MySQL on an AMD64 box without too much (or any) performance loss over
an identical linux machine?


If anyone from the FreeBSD/AMD64 dev team would like to use our hardware
to optimize threading for MySQL on AMD64, and compare the results to a linux
install (I have a linux install on identical drive we can swap out)...

I would be more than willing to donate access to interested and qualified 
parties.

Dual Opteron 241 CPUs, 2 Gigs ram.
Tyan S2880UGNR w/ LSI Zero Channel Raid card
4x 15k rpm SCSI drives running 2 raid 0 channels.
Swapable OS/system drive.



Thanks for any information!



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