Re: scsi vs ide performance on fsync's

2001-03-05 Thread Karl Hammar
Networks S-742 94 sthammar +46 10 270 26 67 Computers Sweden Consulting --- From: Ishikawa [EMAIL PROTECTED] Subject: Re: scsi vs ide performance on f

scsi vs ide performance on fsync's

2001-03-05 Thread Michael Widenius
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 ide as

RE: scsi vs ide performance on fsync's

2001-03-05 Thread Chris Delaney
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

Re: scsi vs ide performance on fsync's

2001-03-05 Thread Douglas Gilbert
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

Re: scsi vs ide performance on fsync's

2001-03-04 Thread Douglas Gilbert
DE drives with the same behavior. Michael D. Black Principal Engineer [EMAIL PROTECTED] 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:

Re: scsi vs ide performance on fsync's

2001-03-04 Thread Ishikawa
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

Re: scsi vs ide performance on fsync's

2001-03-02 Thread Mike Black
___ Michael D. Black Principal Engineer [EMAIL PROTECTED] 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]