Why is MySQL nearly twice as fast on Linux?

[Daniel Eischen]

On Mon, 24 May 2004, Chris Elsworth wrote:

> On Mon, May 24, 2004 at 10:13:36AM -0400, Daniel Eischen wrote:
> > On Mon, 24 May 2004, Petri Helenius wrote:
> > 
> > > I changed the test to use InnoDB table type and saw 50% performance 
> > > improvement.
> > 
> > Are you able to run the test using InnoDB under Linux also
> > (just to see if Linux also gets a ~50% improvement)?
> 
> I've just done so. It doesn't make much difference.

[ ... ]

> So, each of the smackfiles used below was changed to have sql_no_cache
> in the select. The _i smackfile simply has type=innodb in the create
> table statement.
> 
> Here's the numbers:

And what kind of improvement do you see using FreeBSD (-current,
libpthread)?

-- 
Dan Eischen