On Sep 28, 2005, at 5:05 PM, Atle Veka wrote:

I am planning on running some tests on a SATA server with a 3ware 9000
series RAID card to see if there's a stripe size that performs better than


This might be able to help you out:

http://hashmysql.org/index.php?title=Opteron_HOWTO

These are difficult questions. you also should figure out what the block size of your filesystem is. I think ideally it should be N*stripe_size where N is the number of disks you have. This way you can read one block as a set of N IOs in parallel across your disks.

Also note that SATA is probably not what you want if you need decent IO. SCSI will still give you a win.

Let us know what you find out...

Check the archives too. I think there was some commentary about using a 16k strip and seeing a significant performance boost. Also some RAID controllers don't allow you to change the strip size.

Moral of the story is that disk sucks... Disk is the new tape...

Kevin

Kevin A. Burton, Location - San Francisco, CA
      AIM/YIM - sfburtonator,  Web - http://www.feedblog.org/
GPG fingerprint: 5FB2 F3E2 760E 70A8 6174 D393 E84D 8D04



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to