Oracle-L: 1M STRIPE SIZE BEST?

From: Post, Ethan <Ethan.Post_at_ps.net>
Date: Wed, 20 Nov 2002 14:53:56 -0800
Message-ID: <F001.005085D4.20021120145356@fatcity.com>

A number of papers recommend a stripe size of 1 M (even for EMC) for volumes containing data files. I also have the following email from Eyal Aronoff of Quest dated Nov 2000. A number of the white papers are more recent.

The reasons for a larger stripe size on a non-RAID 5 device are: 1) Sequential reads are faster if you can take advantege of the read ahead built into the disk caching
2) If a 64K read does not start on the first block of the stripe, two "spindled" are locked for the duration of the read

However, lately we have been testing some EMC gear and it looks like EMC have optimized both of those for smaller strip size too.

The bottom line - I no longer have an opinion one way or another. The undelying technology just changes too rapidly.

Eyal

Your opinions/comments as far as a "best" practice in setting stripe sizes would be greatly appreciated.

Thanks,
Ethan
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Post, Ethan
INET: Ethan.Post_at_ps.net

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Nov 20 2002 - 16:53:56 CST