[ Sunday, January 16, 2000 ] David Corbin wrote:
> My real question, is how do strip-size, Oracle block size, and ext2 file
> system block size interact, and what should they be to get the most
> efficient database? (The database, while not large, is used for both
> operations and "warehousing", so it is difficult to identify what the
> read/write ratio is).
If at all possible, split this into 2 devices, 2 fs's, 2
db's...warehousing (with a good schema) almost always do better with
increasing block size (and have a read percentage typically next to 100,
or at 100 if you exclude the typical load times)... leave the OLTP/OLAP
on 4k blocks (md, ext2, and oracle).
This is based on my personal experience running 8i on RH 6.1 with
databases of both types until I moved my warehousing to raid1 (almost
all reads, so perf of raid0) and left the operations stuff on raid5.
Total of 4 db's around 600GB in size.
James
--
Miscellaneous Engineer --- IBM Netfinity Performance Development
