Date: Tue, 13 Dec 2005 16:20:26 +1030 From: Greg 'groggy' Lehey <grog@FreeBSD.org> To: David Xu <davidxu@freebsd.org> Cc: Michael Vince <mv@roq.com>, freebsd-performance@freebsd.org, "Gustavo A. Baratto" <gbaratto@superb.net> Subject: Re: new benchmarks. WAS: FreeBSD MySQL still WAY slower than Linux Message-ID: <20051213055026.GB6336@wantadilla.lemis.com> In-Reply-To: <4398CE7E.5050007@freebsd.org> References: <04f401c5f630$b9af6570$6450fb40@guinness> <438FB036.3000804@roq.com> <20051209000704.GA80362@wantadilla.lemis.com> <4398CE7E.5050007@freebsd.org>
next in thread | previous in thread | raw e-mail | index | archive | help
--Fba/0zbH8Xs+Fj9o Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Friday, 9 December 2005 at 8:23:26 +0800, David Xu wrote: > Greg 'groggy' Lehey wrote: > >> I've heard this claim again and again, and I intend to look at it when >> I have time. I find it difficult to believe that this alone could >> explain the sometimes horrendous performance differences (3 to 1) that >> have been reported. >> >> Can somebody tell me: >> >> 1. How many calls there are per second? >> 2. Where they're coming from? This would involve profiling, of >> course. > > You find ktrace result of mysql: > http://people.freebsd.org/~davidxu/mysql/mysql_ktrace.txt > gettimeofday() almost follows every network I/O. ktrace doesn't give a call graph. We don't know which function is calling it. That's why we need profiling. > Also you can find its I/O size: > http://people.freebsd.org/~davidxu/mysql/iosize.txt Ugh. It would be nice to know what those fds are. > I guess the gettimeofday() call is relevant to mysql's connection > keepalive work, sounds like a very silly method. As you say, that's a guess. We need to find out facts. Greg -- See complete headers for address and phone numbers. --Fba/0zbH8Xs+Fj9o Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.1 (FreeBSD) iD8DBQFDnmEiIubykFB6QiMRAkZCAJ9EFT5JyxqNkwg8999CzC7xYaChUwCeL4Ph nYNLcsu3fksBnBqLqnJezDE= =Q879 -----END PGP SIGNATURE----- --Fba/0zbH8Xs+Fj9o--
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20051213055026.GB6336>