Kbase P8012: What is the recommended stripe size for a database?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
9/11/2009 |
|
Status: Verified
GOAL:
What is the recommended stripe size for a database?
GOAL:
How to configure striping with a database?
GOAL:
How big should I make my database extents?
FACT(s) (Environment):
Progress 9.x
UNIX
OpenEdge Database Category: Configuration
FIX:
Progress does not have specific recommendations regarding stripe sizes for a database. We can however, make the following suggestions based on our experiences.
1) Use extent sizes of 1 or 2 GB.
2) In our tests on Linux, we got quite good results with a number of drives combined into a single stripe set using a 3 way raid controller. We got a
bit better performance with a 1 MB stripe block size than with a 64 KB stripe block size.
3) Keep the BI (Before Image) and AI (After Image) files on separate drives. Do not put them into the stripe set.
4) Use DB (Database), BI, and AI block sizes of 8 KB.