Jeremy, I am not sure if I have seen benchmarks of this. I think the stripe size is not very important, as long as you make it significantly bigger than the InnoDB page size of 16 kB.
Since it is not guaranteed that the OS will align InnoDB's data pages to stripes, having a small, 16 kB stripe size might cause 2 disk reads for a random read of an InnoDB page. Since there are usually unexplained performance phenomena in file i/o and disk i/o, a real-world test is needed for your particular software/hardware combination to determine a good stripe size. Best regards, Heikki Innobase Oy InnoDB - transactions, row level locking, and foreign keys for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables http://www.innodb.com/order.php Register now for the 2004 MySQL Users Conference! http://www.mysql.com/events/uc2004/index.html ............. List:MySQL General Discussion« Previous MessageNext Message » From: Jeremy Zawodny Date:March 18 2004 11:48pm Subject: Optimal RAID stripe size(s) for InnoDB? Has anyone done much testing with RAID stripe sizes for heavy concurrency InnoDB-based applications? I'm expecting that using a stripe size that matches InnoDB's page size would make sense, but it could save a lot of testing if someone else has already done this. Thanks, Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
