Date: Wed, 14 Apr 2010 16:10:54 +0200 From: Ivan Voras <ivoras@freebsd.org> To: freebsd-performance@freebsd.org Subject: Re: is there a problem with the HP SmartArray P410 and/or Postgres on FreeBSD ? Message-ID: <hq4id2$2du$1@dough.gmane.org> In-Reply-To: <4BC5C8FA.3030505@arcor.de> References: <4BC4D46B.9040805@arcor.de> <hq40et$tgo$1@dough.gmane.org> <4BC5C8FA.3030505@arcor.de>
next in thread | previous in thread | raw e-mail | index | archive | help
On 04/14/10 15:54, Christoph Weber-Fahr wrote: > Hello, > > On 14.04.2010 11:04, Ivan Voras wrote: >> On 04/13/10 22:30, Christoph Weber-Fahr wrote: >>> Hello, >>> >>> on a new HP Proliant DL385 G6 I have a P410 with BBWC and >>> 8 hard drives in RAID5. >>> (BBWC is Battery Backed Write Cache Enabler, and the controller >>> is configured with 300M (75%) write cache). >>> >>> One of the applications we want to run is PostgreSQL (not the top >>> priority, else we would use a different RAID scenario). >>> >>> But before getting the system live, we tested the performance. >>> PostgreSQL gets a whole wopping 80 (!) tps out of this >>> scenario wit pgbench ( -c 5 -t 5000) > >> Can you give more details about your hardware? CPU? Memory? File system? >> The "100% sys time" point makes it possible it's not the storage itself >> that is the issue. > > CPU is a single AMD Athlon 2427 6-core processor, with 4 Gig RAM. > > Filesystem is standard bsd ufs/ffs with softupdates on a 3.2 TB RAID5. > > As for 100%sys time, I didn't claim that. I just note the storage > device da0 in the systat -vmstat screen is marked as 100% busy. Hi, Ok, thanks for clarifying that. In this case, and looking at the stats below, I think you are right - something really is problematic with your storage. Unfortunately, I don't clearly see what could be the issue, except if your BBU is not enabled or the controller isn't set for write-through. I have a P400 on a machine and it works as expected (on 6 drives in RAID-10). What are your sequential read and write rates? Try testing with bonnie++. I get > 200 MB/s in either direction but rewrite rates of 38 MB/s. It also reports seek rate of ~~850/s. > iostat -x 1 > extended device statistics > device r/s w/s kr/s kw/s wait svc_t %b > da0 1.1 16.4 15.4 1030.9 1 5.5 7 > pass0 0.0 0.0 0.0 0.0 0 0.0 0 > extended device statistics > device r/s w/s kr/s kw/s wait svc_t %b > da0 0.0 57.0 0.0 3645.3 1 18.1 100 > pass0 0.0 0.0 0.0 0.0 0 0.0 0 > extended device statistics > device r/s w/s kr/s kw/s wait svc_t %b > da0 0.0 400.5 0.0 24052.3 1 2.6 96 > pass0 0.0 0.0 0.0 0.0 0 0.0 0 > extended device statistics > device r/s w/s kr/s kw/s wait svc_t %b > da0 0.0 196.8 0.0 12593.5 1 5.2 97 > pass0 0.0 0.0 0.0 0.0 0 0.0 0 > extended device statistics > device r/s w/s kr/s kw/s wait svc_t %b > da0 0.0 61.9 0.0 3963.4 1 16.5 98 > pass0 0.0 0.0 0.0 0.0 0 0.0 0 > extended device statistics > device r/s w/s kr/s kw/s wait svc_t %b > da0 0.0 70.9 0.0 4538.8 1 14.5 99 > pass0 0.0 0.0 0.0 0.0 0 0.0 0 > extended device statistics > device r/s w/s kr/s kw/s wait svc_t %b > da0 0.0 61.9 0.0 3963.4 1 16.6 100 > pass0 0.0 0.0 0.0 0.0 0 0.0 0 > extended device statistics > device r/s w/s kr/s kw/s wait svc_t %b > da0 0.0 60.9 0.0 3899.5 1 16.5 97 > pass0 0.0 0.0 0.0 0.0 0 0.0 0 > extended device statistics > device r/s w/s kr/s kw/s wait svc_t %b > da0 0.0 76.9 0.0 4922.3 1 13.9 101 > pass0 0.0 0.0 0.0 0.0 0 0.0 0 > extended device statistics > device r/s w/s kr/s kw/s wait svc_t %b > da0 0.0 62.9 0.0 4027.3 1 16.4 100 > pass0 0.0 0.0 0.0 0.0 0 0.0 0 > > gstat > > dT: 1.001s w: 1.000s > L(q) ops/s r/s kBps ms/r w/s kBps ms/w %busy Name > 0 0 0 0 0.0 0 0 0.0 0.0| acd0 > 1 68 0 0 0.0 68 4347 14.8 99.4| da0 > 0 0 0 0 0.0 0 0 0.0 0.0| da0p1 > 0 0 0 0 0.0 0 0 0.0 0.0| da0p2 > 0 0 0 0 0.0 0 0 0.0 0.0| da0p3 > 0 0 0 0 0.0 0 0 0.0 0.0| da0p4 > 0 0 0 0 0.0 0 0 0.0 0.0| da0p5 > 1 68 0 0 0.0 68 4347 14.9 99.6| da0p6 > _______________________________________________ > freebsd-performance@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-performance > To unsubscribe, send any mail to "freebsd-performance-unsubscribe@freebsd.org" >
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?hq4id2$2du$1>