From owner-freebsd-amd64@FreeBSD.ORG Tue Oct 19 15:42:55 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 D508316A4CE for ; Tue, 19 Oct 2004 15:42:55 +0000 (GMT) Received: from mx1.pragmeta.com (mx1.pragmeta.com [216.230.164.35]) by mx1.FreeBSD.org (Postfix) with ESMTP id 3F03E43D41 for ; Tue, 19 Oct 2004 15:42:53 +0000 (GMT) (envelope-from jendries@pragmeta.com) Received: from [10.0.0.201] (host-64-246-146-151.ubr0.dc1-alb.inoc.net [64.246.146.151]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by mx1.pragmeta.com (Postfix) with ESMTP id 9937F55F04C for ; Tue, 19 Oct 2004 11:42:53 -0400 (EDT) Message-ID: <417535F5.4040003@pragmeta.com> Date: Tue, 19 Oct 2004 11:42:45 -0400 From: Josh Endries User-Agent: Mozilla Thunderbird 0.7.3 (X11/20041006) X-Accept-Language: en-us, en MIME-Version: 1.0 To: freebsd-amd64@freebsd.org Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Subject: dual Opteron AMD64 MySQL server performance/RAID card questions 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: Tue, 19 Oct 2004 15:42:56 -0000 Hi all, I have a shiny new dual Opteron system to mold into a MySQL server. The machine has a U320 10k 70 GB RAID 5 array (LSI MegaRAID 320-1), 2 GB RAM. I'm wondering the best way to go about this. I'm using FreeBSD 5 (duh), actually 5.3-BETA7 right now, and the mysql41-server port. MySQL 4.1 works out of the box, and I think is using both CPUs, yay! My method of testing this is running super-smack and watching top's kernel thread display, looking for CPU0 and CPU1 in the state column, though not necessarily at the same time (I don't think I've ever seen that). Not very realiable heh, but I dunno how else to check for that. I ran some tests using super-smack's select-key and update-select smack files, 100 clients * 100 queries. I found that there was very little difference between MySQL 4.0 and 4.1, 4BSD and ULE, "-DWITH_OPENSSL -DBUILD_OPTIMIZED" and "-DWITH_OPENSSL -DBUILD_OPTIMIZED -DWITH_PROC_SCOPE_PTH". I got ~1330 and ~660 queries/sec, +/- 20, (respectively) for all kernel/build flag configurations. Probably all sorts of problems with this test, but I just wanted an idea if what it could do. What I'm wondering is: are there any reasons to use one configuration over the other (ULE vs. 4BSD), or are there any other considerations for a server like this? Other optimizations? My other concern is the RAID. I haven't found any utilities or anything to monitor the RAID state and report or fix, rebuild, etc. without rebooting into the BIOS. Are there any SCSI RAID cards that support this in FreeBSD? Thanks, Josh