I've recently been tasked with scalability/performance testing of a Dell
PowerEdge 2950. This is the one with the new Intel Woodcrest Xeons.
Since I haven't seen any info on this box posted to the list, I figured
people might be interested in the results, and maybe in return share a
few tips on performance tweaks.
After doing some reading on the performance list, I realize that there's
a preference for Opteron; however, the goal of these experiments is to
see what I can get the 2950 to do. I will also be comparing performance
vs. a 1850 at some point, if there's any interest I can post those
Here's the hardware:
2xDual Core 3.0 Ghz CPU (Xeon 5160- 1333Mhz FSB, 4 MB shared cache per
8 GB RAM (DDR2, fully buffered, Dual Ranked, 667 Mhz)
6x300 10k RPM SAS drives
Perc 5i w/256 MB battery backed cache
The target application:
Mostly OLAP (large bulk loads, then lots of reporting, possibly moving
to real-time loads in the future). All of this will be run on FreeBSD
6.1 amd64. (If I have some extra time, I might be able to run a few
tests on linux just for comparison's sake)
Make sure the RAID is giving reasonable performance:
bonnie++ -d /u/bonnie -s 1000:8k
time bash -c "(dd if=/dev/zero of=bigfile count=125000 bs=8k && sync)"
Now, I realize that the above are overly simple, and not indicative of
overall performance, however here's what I'm seeing:
Single 10K 300 GB drive - ~75 Mb/s on both tests, more or less
RAID 10, 6 disks (3 sets of mirrored pairs) - ~117 Mb/s
The RAID 10 numbers look way off to me, so my next step is to go test
some different RAID configs. I'm going to look at a mirrored pair, and a
striped pair first, just to make sure the setup is sane. Then, RAID 5 x
6 disks, and mirrored pair + raid 10 with 4. Possibly software raid,
however I'm not very familiar with this on FreeBSD.
Once I get the RAID giving me reasonable results (I would think that a
raid 10 with 6 10k drives should be able to push >200 MB/s sustained
IO...no?) I will move on to other more DB specific tests.
A few questions:
1) Does anyone have other suggestions for testing raw IO for the RAID?
2) What is reasonable IO (bonnie++, dd) for 4 or 6 disks- RAID 10?
3) For DB tests, I would like to compare performance on the different
RAID configs and vs. the 1850. Maybe to assist also in some basic
postgresql.conf and OS tuning (but that will be saved mostly for when I
start application level testing). I realize that benchmarks don't
necessarily map to application performance, but it helps me establish a
baseline for the hardware. I'm currently running pgbench, but would like
something with a few more features (but hopefully without too much setup
time). I've heard mention of the OSDL's DBT tests, and I'm specifically
interested in DBT-2 and DBT-3. Any suggestions here?
Here's some initial numbers from pgbench (-s 50 -c 10 -t 100). Please
keep in mind that these are default installs of FreeBSD 6.1 and Postgres
8.1.4- NO tuning yet.
1850: run1: 121 tps, run2: 132 tps, run3: 229 tps
2950: run1: 178 tps, run2: 201 tps, run3:259 tps
Obviously neither PG nor FreeBSD are taking advantage of all the
hardware available in either case.
I will post the additional RAID numbers shortly...
pgsql-performance by date
|Next:||From: David Lang||Date: 2006-08-09 16:19:53|
|Subject: Re: Hardware upgraded but performance still ain't good|
|Previous:||From: Scott Marlowe||Date: 2006-08-09 15:15:27|
|Subject: Re: most bang for buck with ~ $20,000|