Date: Tue, 1 Nov 2005 10:39:58 +0000 From: Chris <chrcoluk@gmail.com> To: Michael VInce <mv@roq.com> Cc: current@freebsd.org, Marian Hettwer <MH@kernel32.de> Subject: Re: MySQL Performance 6.0rc1 Message-ID: <3aaaa3a0511010239o2777743dh@mail.gmail.com> In-Reply-To: <4361EE53.80603@roq.com> References: <435F48DA.6060009@kernel32.de> <20051026105411.L32255@fledge.watson.org> <435F6B01.5020003@kernel32.de> <4361DDBB.4060903@roq.com> <4361EE53.80603@roq.com>
next in thread | previous in thread | raw e-mail | index | archive | help
Interesting thread I ran super-smack on my production server. It is an amd64 but using i386 kernel 32bit binaries mysql is optimised fairly well, mysql 4.0.x compiled with static but not optimised. in make.conf -O2. I am using libpthread I believe the new threading library introduced to 5.x, os is Freebsd 5.4. super-smack-1.2 # super-smack /usr/share/smacks/select-key.smack 10 10000 Query Barrel Report for client smacker1 connect: max=3D45ms min=3D0ms avg=3D 31ms from 10 clients Query_type num_queries max_time min_time q_per_s select_index 200000 0 0 29222.26 so I had a high average ms but my queries per second is impressive seeing as what has been posted, also bear in mind this box is under load since it is a production web server, I have a high cache hit efficiency like I said I optimised it. It is probable the default's are just more suited for linux but I think once tweaked it works just as well on bsd. Chris
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?3aaaa3a0511010239o2777743dh>