From owner-freebsd-performance@FreeBSD.ORG  Thu Jan  3 21:52:39 2008
Return-Path: <owner-freebsd-performance@FreeBSD.ORG>
Delivered-To: freebsd-performance@freebsd.org
Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34])
	by hub.freebsd.org (Postfix) with ESMTP id 6875E16A41A
	for <freebsd-performance@freebsd.org>;
	Thu,  3 Jan 2008 21:52:39 +0000 (UTC)
	(envelope-from kris@FreeBSD.org)
Received: from weak.local (freefall.freebsd.org [IPv6:2001:4f8:fff6::28])
	by mx1.freebsd.org (Postfix) with ESMTP id 8746B13C465;
	Thu,  3 Jan 2008 21:52:38 +0000 (UTC)
	(envelope-from kris@FreeBSD.org)
Message-ID: <477D5927.4030100@FreeBSD.org>
Date: Thu, 03 Jan 2008 22:52:39 +0100
From: Kris Kennaway <kris@FreeBSD.org>
User-Agent: Thunderbird 2.0.0.9 (Macintosh/20071031)
MIME-Version: 1.0
To: Gergely CZUCZY <phoemix@harmless.hu>
References: <20071129101729.GA57985@harmless.hu>
	<20071130143023.I884@192.168.1.107>
	<20071201163334.GA21709@harmless.hu>
	<200712012055.lB1Kt5IQ005728@lava.sentex.ca>
	<20071201205609.GA54238@harmless.hu>
	<200712012108.lB1L8qAd005766@lava.sentex.ca>
	<20071201211012.GA55519@harmless.hu>
	<20071201122122.S884@192.168.1.107>
	<20071204130810.GA77186@harmless.hu> <47779AA7.2060801@FreeBSD.org>
	<20071230132451.GA61295@harmless.hu>
In-Reply-To: <20071230132451.GA61295@harmless.hu>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Cc: Jeff Roberson <jroberson@chesapeake.net>, freebsd-performance@freebsd.org
Subject: Re: mysql scaling questions
X-BeenThere: freebsd-performance@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: Performance/tuning <freebsd-performance.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-performance>,
	<mailto:freebsd-performance-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-performance>
List-Post: <mailto:freebsd-performance@freebsd.org>
List-Help: <mailto:freebsd-performance-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-performance>,
	<mailto:freebsd-performance-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Thu, 03 Jan 2008 21:52:39 -0000

Gergely CZUCZY wrote:

>> * Compare to my config file here:
>>
>> http://people.freebsd.org/~kris/scaling/my.cnf
>>
>> The default mysql config has very poor performance for innodb (you need at least innodb_thread_concurrency = 0 to disable some mysql 
>> brain-death).  Maybe tuning is required for myisam also.
>>
>> * Also make sure you are using identical config settings on the two systems.
> http://phoemix.harmless.hu/mysql/ verify yourself. Only the paths are
> updated, but the main parameters are just the same.

You are not in fact using the same config parameters as I am.  When I 
use your config file I see a large performance loss when I run locally 
even with innodb.

Kris