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
_______________________________________________
freebsd-performance@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-performance
To unsubscribe, send any mail to "[EMAIL PROTECTED]"
