From owner-freebsd-current@FreeBSD.ORG Mon Oct 31 17:21:08 2005 Return-Path: X-Original-To: current@FreeBSD.org Delivered-To: freebsd-current@FreeBSD.ORG Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 3034A16A41F; Mon, 31 Oct 2005 17:21:08 +0000 (GMT) (envelope-from rwatson@FreeBSD.org) Received: from cyrus.watson.org (cyrus.watson.org [209.31.154.42]) by mx1.FreeBSD.org (Postfix) with ESMTP id D61C543D45; Mon, 31 Oct 2005 17:21:07 +0000 (GMT) (envelope-from rwatson@FreeBSD.org) Received: from fledge.watson.org (fledge.watson.org [209.31.154.41]) by cyrus.watson.org (Postfix) with ESMTP id 1CBF346B4B; Mon, 31 Oct 2005 12:21:07 -0500 (EST) Date: Mon, 31 Oct 2005 17:21:06 +0000 (GMT) From: Robert Watson X-X-Sender: robert@fledge.watson.org To: Will Saxon In-Reply-To: <0E972CEE334BFE4291CD07E056C76ED808DC30A8@bragi.housing.ufl.edu> Message-ID: <20051031171123.U80645@fledge.watson.org> References: <0E972CEE334BFE4291CD07E056C76ED808DC30A8@bragi.housing.ufl.edu> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed Cc: Greg 'groggy' Lehey , current@FreeBSD.org, Marian Hettwer Subject: RE: MySQL Performance 6.0rc1 X-BeenThere: freebsd-current@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Discussions about the use of FreeBSD-current List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 31 Oct 2005 17:21:08 -0000 On Mon, 31 Oct 2005, Will Saxon wrote: >> This kind of issue, but also performance differences, are a >> disadvantage for both groups. One of my tasks at MySQL is to do >> something about that, but I'm spread pretty thin. If anybody has input >> on this kind of topic, I'd be interested to hear from you. > > Well I would like to see a HOWTO or something about proper configuration > of MySQL for FreeBSD systems. > > I have a quad opteron that I am currently struggling with using 6.0-RC1, > and I am staring at some of the benchmarks in this thread with disbelief > as I can only pull about 9K qps where others are getting 18-20K qps with > lesser hardware. > > I may just not be very good at searching through list archives, but it's > difficult to find up to date information including suggested kernel > configurations, gotchas for high memory configurations, etc. Well, I'm happy to do a bit of gathering of information. So far the main two recommendations have been: - Look at time counting -- if TSC is safe for your host, it can significantly improve performance. - Use libthr in FreEBSD 6.x, or linuxthreads in earlier versions. - Make sure you're using UNIX domain sockets for local traffic. Any other things to add to the list? I've created a page here: http://wikitest.freebsd.org/moin.cgi/MySQL Eventually we might want to turn this into a more formal document. Robert N M Watson