We're doing some mysql benchmarking. For some reason it seems that ide
drives are currently beating a scsi raid array and it seems to be related
to fsync's. Bonnie stats show the scsi array to blow away ide as
expected, but mysql tests still have the idea beating on plain insert
speeds. Can an
Hi!
> "Jeremy" == Jeremy Hansen <[EMAIL PROTECTED]> writes:
Jeremy> We're doing some mysql benchmarking. For some reason it seems that ide
Jeremy> drives are currently beating a scsi raid array and it seems to be related
Jeremy> to fsync's. Bonnie stats show the scsi array to blow away id
<[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, March 02, 2001 11:27 AM
Subject: scsi vs ide performance on fsync's
We're doing some mysql benchmarking. For some reason it seems that ide
drives are currently beating a scsi raid array an
TECTED] 321-676-2923,x203
> http://www.csihq.com Computer Science Innovations
> http://www.csihq.com/~mike My home page
> FAX 321-676-2355
> - Original Message -
> From: "Jeremy Hansen" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Cc: <[EMA
Douglas Gilbert wrote:
> There is definitely something strange going on here.
> As the bonnie test below shows, the SCSI disk used
> for my tests should vastly outperform the old IDE one:
First thank you and others with my clueless investigation about
the module loading under Debian GNU/Linux. (I
Networks
S-742 94 Östhammar +46 10 270 26 67 Computers
Sweden Consulting
---
From: Ishikawa <[EMAIL PROTECTED]>
Subject: Re: scsi vs
Karl Hammar wrote:
> Strange -- my times stays about the same:
>
> (lk2.2.18 with sym-2.1.0-20001230 driver)
Hm...
There could be kenrel-related factors.
My PC runs the kernel 2.4.2
The scsi code was patched with
"scsi241_ey2.diff.g" posted on this mailing list
by Doug Gilbert on Feb 8, 2001.
(
Hi!
> "Mike" == Mike Black <[EMAIL PROTECTED]> writes:
Mike> Here's a strace -r on IDE:
Mike> 0.001488 write(3, "\214\1\0\0Blah Blah Blah Blah Blah Bla"..., 56) = 56
Mike> 0.000516 fdatasync(0x3)= 0
Mike> 0.001530 write(3, "\215\1\0\0Blah Blah Blah Blah Blah Bla".
Hello,
Michael Widenius wrote on Monday, March 05, 2001:
>
> I wonder from where the fdatasync() is comming; MySQL is not doing
> those (if you are not running mysqld with --flush)
The call is either a fsync or an fdatasync that is done by Berkley DB on the
transaction log.
Regards,
Chris Dela
Since the intention of fsync and fdatasync seems to be
to write dirty fs buffers to persistent storage (i.e.
the "oxide") then the best time is not necessarily
the objective. Given the IDE times that people have
been reporting, it is very unlikely that any of those
IDE disks were really doing 200
10 matches
Mail list logo
