Help with improving mysql performance on 6.2PRE

Miroslav Lachman 000.fbsd at
Thu Oct 5 12:17:19 PDT 2006

Jerry Bell wrote:

> I have a Dell PE2950 with 2 dual core 3.73Ghz processors and 4G of ram. 
> I've looked through some of the lists here and have seen super-smack
> results in the 42k qps range on a 2 dual core opteron system.  I'm able to
> get up to about 34k with the wide at the back of my server whilest rubbing
> the side of it.
> Here's what I've done:
> built both mysql 5.0 and 5.1 from ports with build_static and
> optimazations on.
> changed the clock to TSC
> added the following to my /etc/libmap.conf file:
> [mysqld]


As Nick Evans said, you can't use static version of MySQL daemon if you 
want to use /etc/libmap.conf

I tested both (static vs. dynamic with libmap.conf), dynamic with libthr 
performs much better than static on Dual Xeon 3GHz SMP system with 2GB 
of RAM.

My /etc/libmap.conf is just


Miroslav Lachman

More information about the freebsd-performance mailing list