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]