Index

Itanium2
STP 8-ways

Itanium2

This series of data varies the volume striping for the log partition.

linux-2.6.3
4 1.5GHz processors
400 warehouses
8 KB block size, used by PostgreSQL
3 controllers, 2 channels each
3 14-disk arrays

30 disk volume for database tables, indexes
6 disk volume for database log

oprofile annotated source is not working

run id	stripe width	metric
31	512 KB	3860.99
32	256 KB	4397.95
34	128 KB	4564.94
35	64 KB	4583.65
36	32 KB	4549.68
37	16 KB	4565.72
38	8 KB	3374.35

STP 8-ways

Striping is changed for all the lvm2 volumes. There are two 5-disk raid-0 arrays grouped together for the db log partition. There are twenty-eight single drives grouped together for the rest of the database.

linux-2.6.2
8 700MHz Pentium III Xeons
200 warehouses

old adapted cards (stp8-000)
run id	stripe width	metric
288912	512 KB	1752.70
288913	256 KB	1734.25
288914	128 KB	1726.65
288915	64 KB	1757.60
288916	32 KB	1734.20
288917	16 KB	1731.85

new adapted cards (stp8-002)
run id	stripe width	metric
289055	512 KB	1583.19
289056	256 KB	1761.70
289057	128 KB	1786.50
289058	64 KB	1755.40
289059	32 KB	1749.50
289060	16 KB	1722.65
289061	8 KB	1743.85