From owner-freebsd-stable@FreeBSD.ORG Sun Oct 3 13:51:27 2010 Return-Path: Delivered-To: freebsd-stable@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 286FA106566C for ; Sun, 3 Oct 2010 13:51:27 +0000 (UTC) (envelope-from steven43126@gmail.com) Received: from mail-ww0-f50.google.com (mail-ww0-f50.google.com [74.125.82.50]) by mx1.freebsd.org (Postfix) with ESMTP id A5D248FC14 for ; Sun, 3 Oct 2010 13:51:26 +0000 (UTC) Received: by wwb17 with SMTP id 17so5719082wwb.31 for ; Sun, 03 Oct 2010 06:51:25 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:received:in-reply-to :references:date:message-id:subject:from:to:cc:content-type; bh=XgpAHwDcGP/n65ikBxZsVO/im2jMq+zwS4tqO4XHSg0=; b=jAHFcGKnAHtgk++iH/l+ZMHOdrKSa0WGnvArz90EiYlsVAPCkgkplM8U6SQ0TTf68R yIcKwDtx37knNiaiXlxqzSqg98TBNUd+hvAPzowjcunnJVWHYnGhpXHzl0+eIsNqedzo QF22TmWwa675zmi0eFmgBb8W8XE3pQZu9vByw= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type; b=PTS+HxoiKBacGTWJPwkeNlsJwrtbfu5/PdVog9FIHt8LdEUnNcFbPh7X17l3U0HGxi bfh5PFfBTb48b0EAyrMv2RYfhN4+koN0W2DhkLLFj1XPkc24CXtkBOGD8q4KIJ1BIZ+e hDrHPTfd2EqWsQFtBLgv2K1zQAt/WaLxZ4kgA= MIME-Version: 1.0 Received: by 10.227.147.144 with SMTP id l16mr7045006wbv.45.1286112466713; Sun, 03 Oct 2010 06:27:46 -0700 (PDT) Received: by 10.227.139.143 with HTTP; Sun, 3 Oct 2010 06:27:46 -0700 (PDT) In-Reply-To: <20101002223005.GA78136@icarus.home.lan> References: <20101002223005.GA78136@icarus.home.lan> Date: Sun, 3 Oct 2010 14:27:46 +0100 Message-ID: From: Steven Williamson To: Jeremy Chadwick Content-Type: text/plain; charset=ISO-8859-1 X-Content-Filtered-By: Mailman/MimeDel 2.1.5 Cc: Rumen Telbizov , Steven Hartland , freebsd-stable@freebsd.org Subject: Re: MySQL performance concern 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: Sun, 03 Oct 2010 13:51:27 -0000 The tunings between your Linux and FreeBSD instances differ severely, > and some of the variables don't even exist any longer (example: > table_cache is now known as table_open_cache as of MySQL 5.1.3, and > probably key_buffer vs. key_buffer_size too). > > Can you please rule out MySQL tunings being responsible for the problem? > > Quick and dirty performance comparison ruling out MySQL tuning, install sysbench. This will give you a quick overview of how the OS / Hardware is performing. For a decent comparison there are too many variables here, the hardware is vastly different. Would be nice to see the same Linux install on the new hardware and the benchmarks for that if you have time. P.S Performance tuning can be a very time consuming business, an almost unending task. Best method is not to see if system x is faster than system y. But to state exactly what performance you require. If you only need 600 inserts per min for now and the next year, tune to that and your good to go. Otherwise you can end up spending days to get that extra 2 or 3 inserts per min which you really didn't need :) Regards Steven Williamson