From owner-freebsd-performance@FreeBSD.ORG Wed Apr 14 14:10:53 2010 Return-Path: Delivered-To: freebsd-performance@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id E52E3106564A for ; Wed, 14 Apr 2010 14:10:53 +0000 (UTC) (envelope-from gofp-freebsd-performance@m.gmane.org) Received: from lo.gmane.org (lo.gmane.org [80.91.229.12]) by mx1.freebsd.org (Postfix) with ESMTP id 6F84D8FC14 for ; Wed, 14 Apr 2010 14:10:53 +0000 (UTC) Received: from list by lo.gmane.org with local (Exim 4.69) (envelope-from ) id 1O23Iq-0004oH-BV for freebsd-performance@freebsd.org; Wed, 14 Apr 2010 16:10:52 +0200 Received: from lara.cc.fer.hr ([161.53.72.113]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Wed, 14 Apr 2010 16:10:52 +0200 Received: from ivoras by lara.cc.fer.hr with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Wed, 14 Apr 2010 16:10:52 +0200 X-Injected-Via-Gmane: http://gmane.org/ To: freebsd-performance@freebsd.org From: Ivan Voras Date: Wed, 14 Apr 2010 16:10:54 +0200 Lines: 105 Message-ID: References: <4BC4D46B.9040805@arcor.de> <4BC5C8FA.3030505@arcor.de> Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@dough.gmane.org X-Gmane-NNTP-Posting-Host: lara.cc.fer.hr User-Agent: Mozilla/5.0 (X11; U; FreeBSD amd64; en-US; rv:1.9.1.8) Gecko/20100329 Thunderbird/3.0.3 In-Reply-To: <4BC5C8FA.3030505@arcor.de> X-Enigmail-Version: 1.0.1 Subject: Re: is there a problem with the HP SmartArray P410 and/or Postgres on FreeBSD ? X-BeenThere: freebsd-performance@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Performance/tuning List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 14 Apr 2010 14:10:54 -0000 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" >