From owner-freebsd-performance@FreeBSD.ORG  Mon May 14 12:01:23 2007
Return-Path: <owner-freebsd-performance@FreeBSD.ORG>
X-Original-To: freebsd-performance@freebsd.org
Delivered-To: freebsd-performance@freebsd.org
Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52])
	by hub.freebsd.org (Postfix) with ESMTP id D1A2516A405
	for <freebsd-performance@freebsd.org>;
	Mon, 14 May 2007 12:01:23 +0000 (UTC)
	(envelope-from cheffo@FreeBSD-BG.org)
Received: from blah.sun-fish.com (blah.sun-fish.com [217.18.249.150])
	by mx1.freebsd.org (Postfix) with ESMTP id 8D20913C44B
	for <freebsd-performance@freebsd.org>;
	Mon, 14 May 2007 12:01:23 +0000 (UTC)
	(envelope-from cheffo@FreeBSD-BG.org)
Received: from blah.sun-fish.com (localhost [127.0.0.1])
	by blah.sun-fish.com (Postfix) with ESMTP id 8A4DD1B10EE9;
	Mon, 14 May 2007 14:01:22 +0200 (CEST)
Received: from hater.cmotd.com (hater.cmotd.com [192.168.3.125])
	by blah.sun-fish.com (Postfix) with ESMTP id 876531B10EE0;
	Mon, 14 May 2007 14:01:22 +0200 (CEST)
Message-ID: <46484F91.4020803@FreeBSD-BG.org>
Date: Mon, 14 May 2007 15:01:21 +0300
From: Cheffo <cheffo@FreeBSD-BG.org>
User-Agent: Thunderbird 2.0.0.0 (X11/20070425)
MIME-Version: 1.0
To: Alexandr <son@ehl.kiev.ua>
References: <46443103.9010008@otel.net><17838240D9A5544AAA5FF95F8D52031602018EFA@ad-exh01.adhost.lan>
	<46483584.70608@FreeBSD-BG.org>
	<017f01c79614$dbae6420$0200a8c0@ssoniccp3pvd>
In-Reply-To: <017f01c79614$dbae6420$0200a8c0@ssoniccp3pvd>
Content-Type: text/plain; charset=windows-1251; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: ClamAV using ClamSMTP on BLAH
Cc: freebsd-performance@freebsd.org, ivo tasev <tasev@otel.net>
Subject: Re: 6.2 Stable + Mysql 5.0 poor performance
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: Mon, 14 May 2007 12:01:23 -0000

Alexandr wrote:
>> Do you need more info?
> 
> I think you should look at this
> http://people.freebsd.org/~kris/scaling/mysql.html
> 
> 

What exactly you suggest ? :)

Increasing thread_concurrency from 8 to 16 brings me worst results (I 
have only 4 cores not 8, and this is supposed to be CPUs*2 )

Or I miss something else from this post ?

BTW I'm using 4BSD scheduler not ULE (big improvements in ULE are in 7.x 
right?)


-- 

Best Wishes,
Stefan Lambrev
ICQ# 24134177