Date: Sun, 23 May 2004 14:32:40 +0300 From: Petri Helenius <pete@he.iki.fi> To: JG <amd64list@jpgsworld.com> Cc: freebsd-threads@freebsd.org Subject: Re: Why is MySQL nearly twice as fast on Linux? Message-ID: <40B08BD8.4030004@he.iki.fi> In-Reply-To: <5.2.0.9.2.20040522135338.0158cc50@mail.ojoink.com> References: <5.2.0.9.2.20040522100318.01598f50@mail.ojoink.com> <5.2.0.9.2.20040522052606.0156fd70@mail.ojoink.com> <5.2.0.9.2.20040521154458.01627688@127.0.0.1> <5.2.0.9.2.20040521154458.01627688@127.0.0.1> <5.2.0.9.2.20040522052606.0156fd70@mail.ojoink.com> <5.2.0.9.2.20040522100318.01598f50@mail.ojoink.com> <5.2.0.9.2.20040522135338.0158cc50@mail.ojoink.com>
next in thread | previous in thread | raw e-mail | index | archive | help
JG wrote: > > While the benchmarks are running, gstat basically looks like this: > > amd64f# gstat > dT: 0.502 flag_I 500000us sizeof 288 i -1 > L(q) ops/s r/s kBps ms/r w/s kBps ms/w %busy Name > 0 0 0 0 0.0 0 0 0.0 0.0| ad0 > 0 0 0 0 0.0 0 0 0.0 0.0| ad0s1 > 0 0 0 0 0.0 0 0 0.0 0.0| acd0 > 0 0 0 0 0.0 0 0 0.0 0.0| amrd0 > 0 0 0 0 0.0 0 0 0.0 0.0| amrd1 > 0 0 0 0 0.0 0 0 0.0 0.0| ad0s1a > 0 0 0 0 0.0 0 0 0.0 0.0| ad0s1b > 0 0 0 0 0.0 0 0 0.0 0.0| ad0s1c > 0 0 0 0 0.0 0 0 0.0 0.0| ad0s1d > 0 0 0 0 0.0 0 0 0.0 0.0| ad0s1e > 0 0 0 0 0.0 0 0 0.0 0.0| amrd0s1 > 0 0 0 0 0.0 0 0 0.0 0.0| amrd1s1 > > With the exception of a few split-second ticks to the amrd1 > drive (the mysql data drive) > Which means that either your dataset fits into the memory you have allocated for mysql or your are CPU bound or both. How does top -H look when running the test? Pete
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?40B08BD8.4030004>