Help with improving mysql performance on 6.2PRE

[Jerry Bell]

Many thanks to all who responded.  You are an incredibly smart group of
people.

The recompiling without static yielded much better results:

2950# super-smack -d mysql select-key-mysql.smack 10 10000
Query Barrel Report for client smacker1
connect: max=1ms  min=0ms avg= 0ms from 10 clients
Query_type      num_queries     max_time        min_time        q_per_s
select_index    200000  0       0       51118.22

>From ~34k qps to ~51k qps is quite an improvement!

I always thougt that compiling something static increased performance, but
then that's probably true for things that have to startup and shutdown
frequently.

Thanks again.

Jerry
> 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 at freebsd.org mailing list
> http://lists.freebsd.org/mailman/listinfo/freebsd-performance
> To unsubscribe, send any mail to
> "freebsd-performance-unsubscribe at freebsd.org"
>