Date: Wed, 26 Oct 2005 10:57:26 +0100 (BST) From: Robert Watson <rwatson@FreeBSD.org> To: Marian Hettwer <MH@kernel32.de> Cc: current@freebsd.org Subject: Re: MySQL Performance 6.0rc1 Message-ID: <20051026105411.L32255@fledge.watson.org> In-Reply-To: <435F48DA.6060009@kernel32.de> References: <435F48DA.6060009@kernel32.de>
next in thread | previous in thread | raw e-mail | index | archive | help
On Wed, 26 Oct 2005, Marian Hettwer wrote: > I'm using RC1 on some of my test servers and workstations. So far, it > runs very good (as in stable and fast) :) However, I thought of doing a > small benchmark of MySQL in comparison to Linux 2.6.8 (Debian Sarge) and > the results are kinda... shocking. > > On FreeBSD I took a pretty much generic kernel, I just removed debugging > options, added SMP and changed the scheduler from BSD to ULE. I used > super-smack to do a select-key test. MySQL 4.1 was build from ports with > BUILD_OPTIMIZED and BUILD_STATIC Could you: - Switch back to 4BSD - Use libmap to configure the mysql server to use libthr instead of libpthread And see what that does to performance using otherwise identical configurations? You might also consider installing MySQL 4.0.x on freebsd and linux and see how they compare. I've not looked closely, but I seem to remember observing that something changed between 4.0 and 4.1 that seriously impacted performance on FreeBSD, but not on Linux. I've not had time to confirm or investigate this. Robert N M Watson > > super-smack gave me these numbers: Query Barrel Report for client > smacker1 connect: max=15ms min=1ms avg= 12ms from 10 clients Query_type > num_queries max_time min_time q_per_s select_index 200000 2 0 3673.36 > > My Kernel Config: http://unixoid.de/rabauke/freebsd/EDGECRUSHER My > dmesg: http://unixoid.de/rabauke/freebsd/dmesg.freebsd6rc1 > > Since I have an identical second disk in my Dual Xeon BOX, I installed a > Debian Sarge with Linux SMP Kernel 2.6.8, installed mysql-server41 (which is > 4.1.11) and did the same super-smack test. Results: > Query Barrel Report for client smacker1 > connect: max=35ms min=0ms avg= 9ms from 10 clients > Query_type num_queries max_time min_time q_per_s > select_index 200000 0 0 > 14736.23 > > Whut? 14700 queries/second compared to only 3600 q/s on FreeBSD? > > I do know, that rc1 is not about performance, this will be -RELEASE then. I > do know too, that it was just a quick shot and probably I should compile my > own version of the MySQL server from sources on FreeBSD and Debian to have > the very same mysql version. > However, I can't imagine that I would gain 4 to 5 times the performance on > FreeBSD just by compiling mysql myself... > > Any Ideas where this huge difference comes from? Did I oversee some debugging > features still active in RC1 ? > > Best regards and keep up the good work on 6.x! > - Marian > _______________________________________________ > freebsd-current@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-current > To unsubscribe, send any mail to "freebsd-current-unsubscribe@freebsd.org" >
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20051026105411.L32255>