From owner-freebsd-fs@FreeBSD.ORG Tue Jul 16 15:33:36 2013 Return-Path: Delivered-To: freebsd-fs@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [8.8.178.115]) by hub.freebsd.org (Postfix) with ESMTP id 3718CE53; Tue, 16 Jul 2013 15:33:36 +0000 (UTC) (envelope-from jhb@freebsd.org) Received: from bigwig.baldwin.cx (bigwig.baldwin.cx [IPv6:2001:470:1f11:75::1]) by mx1.freebsd.org (Postfix) with ESMTP id 0E69FE91; Tue, 16 Jul 2013 15:33:36 +0000 (UTC) Received: from jhbbsd.localnet (unknown [209.249.190.124]) by bigwig.baldwin.cx (Postfix) with ESMTPSA id 2082DB917; Tue, 16 Jul 2013 11:33:34 -0400 (EDT) From: John Baldwin To: freebsd-fs@freebsd.org Subject: Re: RAID10 stripe size and PostgreSQL performance Date: Tue, 16 Jul 2013 11:04:53 -0400 User-Agent: KMail/1.13.5 (FreeBSD/8.2-CBSD-20110714-p25; KDE/4.5.5; amd64; ; ) References: In-Reply-To: MIME-Version: 1.0 Content-Type: Text/Plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Message-Id: <201307161104.54089.jhb@freebsd.org> X-Greylist: Sender succeeded SMTP AUTH, not delayed by milter-greylist-4.2.7 (bigwig.baldwin.cx); Tue, 16 Jul 2013 11:33:34 -0400 (EDT) Cc: freebsd-database@freebsd.org, Ivan Voras X-BeenThere: freebsd-fs@freebsd.org X-Mailman-Version: 2.1.14 Precedence: list List-Id: Filesystems List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 16 Jul 2013 15:33:36 -0000 On Friday, July 12, 2013 3:15:03 pm Artem Naluzhnyy wrote: > On Fri, Jul 12, 2013 at 4:55 PM, Ivan Voras wrote: > > I just looked at your RAID configuration at http://pastebin.com/F8uZEZdm > > and you have a mirror of stripes (RAID-01) nor a stripe of mirrors > > (RAID-10). And apparently, is I parse your configuration correctly, you > > have a 1M stripe in the MIRROR part of the RAID, and an unknown stripe > > size in the STRIPE part. > > This is probably a bug in mfiutil output. There is no "RAID 01" option > in the controller configuration, and its documentation says > (http://goo.gl/6X5pe): > > "RAID 10, a combination of RAID 0 and RAID 1, consists of striped data > across mirrored spans. A RAID 10 drive group is a spanned drive group > that creates a striped set from a series of mirrored drives. RAID 10 > allows a maximum of eight spans. You must use an even number of > configuration Scenarios 1-7 drives in each RAID virtual drive in the > span. The RAID 1 virtual drives must have the same stripe size." > > There is also no options to configure a different stripe size for the > mirrors, I can only set it globally for the whole RAID 10 volume. It is true that mfi only does stripes across RAID mirrors. mfiutil depends on the secondary raid level being set in the ddf info for detecting a RAID-10 vs a RAID-1, but not all mfi BIOS-configured volumes have that set. It should probably check if a volume spans multiple arrays instead. -- John Baldwin