From owner-freebsd-stable@FreeBSD.ORG Tue Oct 24 12:34:34 2006 Return-Path: X-Original-To: freebsd-stable@FreeBSD.ORG Delivered-To: freebsd-stable@FreeBSD.ORG Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id BB09916A415 for ; Tue, 24 Oct 2006 12:34:34 +0000 (UTC) (envelope-from olli@lurza.secnetix.de) Received: from lurza.secnetix.de (lurza.secnetix.de [83.120.8.8]) by mx1.FreeBSD.org (Postfix) with ESMTP id ECF8B43D78 for ; Tue, 24 Oct 2006 12:34:33 +0000 (GMT) (envelope-from olli@lurza.secnetix.de) Received: from lurza.secnetix.de (qnunef@localhost [127.0.0.1]) by lurza.secnetix.de (8.13.4/8.13.4) with ESMTP id k9OCYQSG016931; Tue, 24 Oct 2006 14:34:31 +0200 (CEST) (envelope-from oliver.fromme@secnetix.de) Received: (from olli@localhost) by lurza.secnetix.de (8.13.4/8.13.1/Submit) id k9OCYPDJ016930; Tue, 24 Oct 2006 14:34:25 +0200 (CEST) (envelope-from olli) Date: Tue, 24 Oct 2006 14:34:25 +0200 (CEST) Message-Id: <200610241234.k9OCYPDJ016930@lurza.secnetix.de> From: Oliver Fromme To: freebsd-stable@FreeBSD.ORG, mikej@rogers.com In-Reply-To: <453D49D2.1010705@rogers.com> X-Newsgroups: list.freebsd-stable User-Agent: tin/1.8.2-20060425 ("Shillay") (UNIX) (FreeBSD/4.11-STABLE (i386)) X-Greylist: Sender IP whitelisted, not delayed by milter-greylist-2.1.2 (lurza.secnetix.de [127.0.0.1]); Tue, 24 Oct 2006 14:34:31 +0200 (CEST) Cc: Subject: Re: Running large DB's on FreeBSD X-BeenThere: freebsd-stable@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Production branch of FreeBSD source code List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 24 Oct 2006 12:34:34 -0000 Mike Jakubik wrote: > I am in the process of implementing a fairly large mysql server for > an even larger company, and naturally i want to use FreeBSD. The > hardware will be an HP DL385, 2 x dual-core Opterons, 16GB RAM, 7 x 15k > rpm disks in a RAID5 setup. I'm not exactly informed as to the specific > workload yet, however i know the database will have several million rows > and be larger than 10GB. As others have noted, RAID5 is worst-case for databases. For both reliability and performance I recommend RAID1 or RAID10. > So, first of all, am i crazy for choosing fbsd+mysql for this rather > than something like Solaris + Oracle? :) My recommendation is FreeBSD + PostgreSQL. I've worked quite a lot with various Mysql and PostgreSQL databases in the past, and the latter outperforms other combinations in general. Also it is my impression that PostgreSQL is much more reliable and resistant against evil things like crashes (power failure or whatever), thanks to its WAL data storage which is similar to a journaled file system (transaction-aware, of course). A few years ago (2002) I fed the German phone book into a PostgreSQL database running on a Pentium-III 800 MHz with 256 MB RAM (FreeBSD 4-stable). I was just curious how well it would cpe with that. Importing the 35.6 million rows and creating an index took 40 Minutes (I think I didn't even use the optimized COPY instruction, so it could have been even faster). Select commands on the table were processed surprisingly fast, but I didn't really hammer on it because the machine was running a production Apache at the same time. :-) Best regards Oliver -- Oliver Fromme, secnetix GmbH & Co. KG, Marktplatz 29, 85567 Grafing Dienstleistungen mit Schwerpunkt FreeBSD: http://www.secnetix.de/bsd Any opinions expressed in this message may be personal to the author and may not necessarily reflect the opinions of secnetix in any way. "If you aim the gun at your foot and pull the trigger, it's UNIX's job to ensure reliable delivery of the bullet to where you aimed the gun (in this case, Mr. Foot)." -- Terry Lambert, FreeBSD-hackers mailing list.