On Thu, Dec 04, 2003 at 10:33:17AM -0500, Brent Baisley wrote: > > Actually, you want to try to match the stripe size to your data size. > The ideal would be to have a stripe size equal to the size of a record > in your database. This way the disk needs only one read or write for > each database record.
That depends on the storage engine you're using. For MyISAM, yes, the record size is a good way to do it. But for InnoDB, you'd probably want to use its page size. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 4.0.15-Yahoo-SMP: up 88 days, processed 3,535,395,556 queries (464/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]