Date: Thu, 5 Oct 2006 19:24:04 -0400 (EDT) From: "Jerry Bell" <jbell@stelesys.com> To: freebsd-performance@freebsd.org Subject: Re: Help with improving mysql performance on 6.2PRE Message-ID: <2840.71.56.92.181.1160090644.squirrel@www.stelesys.com> In-Reply-To: <45255A36.5010108@quip.cz> References: <3731.71.56.92.181.1160009571.squirrel@www.stelesys.com> <45255A36.5010108@quip.cz>
next in thread | previous in thread | raw e-mail | index | archive | help
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@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-performance > To unsubscribe, send any mail to > "freebsd-performance-unsubscribe@freebsd.org" >
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?2840.71.56.92.181.1160090644.squirrel>