Help with improving mysql performance on 6.2PRE

[Miroslav Lachman]

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]
> libc_r.so.5             libthr.so.2
> libc_r.so.6             libthr.so.2
> libthr.so.2             libthr.so.2
> libpthread.so.1         libthr.so.2
> libpthread.so.2         libthr.so.2

[...]

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

[/usr/local/libexec/mysqld]
libpthread.so.2      libthr.so.2
libpthread.so        libthr.so

Miroslav Lachman