Date: Mon, 24 May 2004 10:39:03 -0400 From: "Ken Menzel" <kenfreebsd@icarz.com> To: "Petri Helenius" <pete@he.iki.fi>, "Thomas Hurst" <tom.hurst@clara.net> Cc: freebsd-threads@freebsd.org Subject: Re: Why is MySQL nearly twice as fast on Linux? Message-ID: <105b01c4419c$dc7a9060$8adb7bd1@icarz.com> References: <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><5.2.0.9.2.20040523090659.01628af8@mail.ojoink.com><5.2.0.9.2.20040523102747.015557e8@mail.ojoink.com><5.2.0.9.2.20040523104834.01465598@mail.ojoink.com><5.2.0.9.2.20040523114544.014d8150@mail.ojoink.com><40B13BB3.3030807@freebsd.org> <20040524003505.GB2713@voi.aagh.net> <40B19F2E.8010804@he.iki.fi>
next in thread | previous in thread | raw e-mail | index | archive | help
Also note that InnoDB tables use a clustered index for the primary key. If you are using the primary key the data will be read at the same time as the index when the correct node is located (Re: High performance MySQL by Jeremy Zawodney and Derek Balling). MyISAM tables use btree's in a separate file scanning the index then starting a read of the data file at the appropriate disk location. Primay key lookups with innodb should be faster and use less disk seeking. Hope this helps, Ken ----- Original Message ----- From: "Petri Helenius" <pete@he.iki.fi> To: "Thomas Hurst" <tom.hurst@clara.net> Cc: <freebsd-threads@freebsd.org> Sent: Monday, May 24, 2004 3:07 AM Subject: Re: Why is MySQL nearly twice as fast on Linux? > Thomas Hurst wrote: > > > > >Only if you're only using one table. While this is true in this > >benchmark, it isn't really relevent because we're only testing selects, > >which are pure reads. There should be no table locking getting in the > >way; Linux's performance would seem to confirm this. > > > > > > > I changed the test to use InnoDB table type and saw 50% performance > improvement. > > Pete > > > _______________________________________________ > freebsd-threads@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-threads > To unsubscribe, send any mail to "freebsd-threads-unsubscribe@freebsd.org" >
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?105b01c4419c$dc7a9060$8adb7bd1>