From owner-freebsd-amd64@FreeBSD.ORG Tue Mar 2 20:51:10 2004 Return-Path: Delivered-To: freebsd-amd64@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id CBA2D16A4CF for ; Tue, 2 Mar 2004 20:51:10 -0800 (PST) Received: from bigtex.jrv.org (bigtex.jrv.org [208.202.121.130]) by mx1.FreeBSD.org (Postfix) with ESMTP id 031F843D1D for ; Tue, 2 Mar 2004 20:51:10 -0800 (PST) (envelope-from james@bigtex.jrv.org) Received: from bigtex.jrv.org (localhost [127.0.0.1]) by bigtex.jrv.org (8.12.1/8.12.1) with ESMTP id i232qFp9040506 (version=TLSv1/SSLv3 cipher=EDH-RSA-DES-CBC3-SHA bits=168 verify=NO); Tue, 2 Mar 2004 20:52:15 -0600 (CST) Received: (from james@localhost) by bigtex.jrv.org (8.12.1/8.12.1/Submit) id i232qFlf040503; Tue, 2 Mar 2004 20:52:15 -0600 (CST) Date: Tue, 2 Mar 2004 20:52:15 -0600 (CST) Message-Id: <200403030252.i232qFlf040503@bigtex.jrv.org> From: James Van Artsdalen To: tomh@waterloo.equitrac.com In-reply-to: (tomh@waterloo.equitrac.com) References: cc: freebsd-amd64@freebsd.org Subject: Re: High volume AMD64 MySQL server -- FreeBSD vs Linux? X-BeenThere: freebsd-amd64@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Porting FreeBSD to the AMD64 platform List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 03 Mar 2004 04:51:10 -0000 How do SQL servers respond to additional memory? The thing that sets 64-bit FreeBSD apart in my mind is the ability for a process to have a 16+ GB resident working set if desired. See if the SQL guys have performance curves for process sizes. I would not be at all surprised if a single 8 GB Opteron could outperform a pair of Xeon systems, even if the Xeons had faster CPU and disk. If RAM is a powerful influence keep in mind that you can go to 16 GB without doing anything exotic, using ECC RAM at < $500 per GB. PS. I'm aware of Intel systems with > 4 GB RAM. PAE is a hack and not at all the same as having the memory in-process. > From: "Haapanen, Tom" > Date: Tue, 2 Mar 2004 19:25:59 -0500 > > Currently running dual Opteron 242s with 2 GB, and there has not been a > single FreeBSD or MySQL glitch in the 45 or so days that the system has been > in production. > > -----Original Message----- > From: JG [mailto:amd64list@jpgsworld.com] > Sent: Tuesday 02 March 2004 18:59 > To: freebsd-amd64@freebsd.org > Subject: High volume AMD64 MySQL server -- FreeBSD vs Linux? > > Tyan S2880UGNR Dual Opteron Motherboard > 2 Opteron 240 CPU's > 2 gigs (2 1gig modules) of PC2700 Registered ECC DDR memory LSI Zero Channel > Raid Controller (Megaraid 320-0) > 4 Fujitsu MAM3184MP U160 Scsi Drives - 15,000rpm 18gb > - these will be ran as two 2 drive raid 0 channels, > one for MyISAM tables and the other for InnoDB.