From owner-freebsd-database@FreeBSD.ORG Tue Jul 19 06:21:36 2005 Return-Path: X-Original-To: freebsd-database@freebsd.org Delivered-To: freebsd-database@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 538B716A41C for ; Tue, 19 Jul 2005 06:21:36 +0000 (GMT) (envelope-from mike@daboyz.org) Received: from jorm.daboyz.org (jorm.daboyz.org [209.67.213.18]) by mx1.FreeBSD.org (Postfix) with ESMTP id 1C82A43D4C for ; Tue, 19 Jul 2005 06:21:36 +0000 (GMT) (envelope-from mike@daboyz.org) Received: by jorm.daboyz.org (Postfix, from userid 10001) id C925914A6B; Tue, 19 Jul 2005 01:33:09 -0500 (CDT) Date: Tue, 19 Jul 2005 01:33:09 -0500 From: Michael Barrett To: freebsd-database@freebsd.org Message-ID: <20050719063309.GA63017@daboyz.org> Mail-Followup-To: freebsd-database@freebsd.org Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.4.2.1i Subject: Big DB (100G+) w/ MySQL 4.1 and FreeBSD 4? X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 19 Jul 2005 06:21:36 -0000 Does anyone here have any experience with dealing with large MySQL 4.1 databases (over 100 gigs) on FreeBSD 4.x? I'm running into performance issues with a similar setup, and I wanted to compare notes with anyone else who may have tried this. Our current setup is: Dell 2650 w/ 2CPU's (533 FSB) and 3G of RAM FreeBSD 4.11 running SMP MySQL 4.1.12 using LinuxThreads Our tables are almost completely innodb using seperate files per table. The size of our mysql datadir is around 199 Gigs. We're seeing all sorts of weird performance issues. The biggest 'issue' we're seeing is that some queries take over a minute to return, yet the system itself (CPU, disks, etc) see almost no activity while this is going on. We had the MySQL AB folks out to take a look, and even running their pre-built binary (w/ LinuxThreads) from their website we saw the same issues. They agreed that 'something was wrong', but couldn't give us any quick ideas on what exactly we could do about it. If you do have experience with a system around the size of ours with similar setup, I'd love to hear about your experiences. Also, seeing any loader.conf, sysctl.conf, my.cnf, and general tips about kernel configuration would be awesome. Thanks for any help you can provide. -- ________________________________________________________________________ Mike Barrett | "We have veggie bacon, why don't we have mike@daboyz.org | meat fruit?" www.daboyz.org | -- My ex-coworker, Ben ------------------------+-----------------------------------------------