From owner-freebsd-performance@FreeBSD.ORG  Sun Feb 25 19:22:04 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 838E416A403
	for <freebsd-performance@freebsd.org>;
	Sun, 25 Feb 2007 19:22:04 +0000 (UTC)
	(envelope-from killing@multiplay.co.uk)
Received: from multiplay.co.uk (core6.multiplay.co.uk [85.236.96.23])
	by mx1.freebsd.org (Postfix) with ESMTP id 1095B13C494
	for <freebsd-performance@freebsd.org>;
	Sun, 25 Feb 2007 19:21:59 +0000 (UTC)
	(envelope-from killing@multiplay.co.uk)
X-Spam-Checker-Version: SpamAssassin 3.1.5 (2006-08-29) on 
	core6.multiplay.co.uk
X-Spam-Level: 
X-Spam-Status: No, score=-24.6 required=6.0 tests=BAYES_00,HTML_50_60,
	HTML_MESSAGE,USER_IN_WHITELIST,USER_IN_WHITELIST_TO autolearn=ham 
	version=3.1.5
Received: from vader ([212.135.219.179])
	by multiplay.co.uk (multiplay.co.uk [85.236.96.23])
	(MDaemon PRO v9.5.4) with ESMTP id md50003560499.msg
	for <freebsd-performance@freebsd.org>; Sun, 25 Feb 2007 19:19:39 +0000
Message-ID: <002401c75911$df69fdd0$b3db87d4@multiplay.co.uk>
From: "Steven Hartland" <killing@multiplay.co.uk>
To: "Francisco Reyes" <lists@stringsutils.com>,
	"Petri Helenius" <pete@he.iki.fi>
References: <0e2001c7574c$26bc15a0$b3db87d4@multiplay.co.uk>
	<cone.1172277148.840621.73625.5001@35st.simplicato.com>
	<20070224005748.GA25295@xor.obsecurity.org>
	<cone.1172420214.242114.68971.1000@zoraida.natserv.net>
	<45E1C3FC.6040905@he.iki.fi>
	<cone.1172426306.859823.68971.1000@zoraida.natserv.net>
Date: Sun, 25 Feb 2007 19:19:23 -0000
MIME-Version: 1.0
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2900.3028
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028
X-MDRemoteIP: 212.135.219.179
X-Return-Path: killing@multiplay.co.uk
X-Envelope-From: killing@multiplay.co.uk
X-MDaemon-Deliver-To: freebsd-performance@freebsd.org
X-Spam-Processed: multiplay.co.uk, Sun, 25 Feb 2007 19:19:40 +0000
X-MDAV-Processed: multiplay.co.uk, Sun, 25 Feb 2007 19:19:40 +0000
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
X-Content-Filtered-By: Mailman/MimeDel 2.1.5
Cc: freebsd-performance@freebsd.org, Kris Kennaway <kris@obsecurity.org>
Subject: Re: FreeBSD Scaling on 6.2-RELEASE?
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: Sun, 25 Feb 2007 19:22:04 -0000

Francisco Reyes wrote:
> What combination of FreeBSD+Mysql will have multiple threads run by
> different CPUs?
>=20
> In the few SMP FreeBSD + Mysql setups (mysql 4.X) that I have at work
> I only see mysql in one cpu as reported by top.

I just did the tests highlighted on the thread:
Progress on scaling of FreeBSD on 8 CPU systems

During that you see mysql using 130+% in top as its being scheduled on
more than 1 cpu due it being multi-threaded so this does happen

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
This e.mail is private and confidential between Multiplay (UK) Ltd. and the person or entity to whom it is addressed. In the event of misdirection, the recipient is prohibited from using, copying, printing or otherwise disseminating it or any information contained in it.=20

In the event of misdirection, illegible or incomplete transmission please telephone +44 845 868 1337
or return the E.mail to postmaster@multiplay.co.uk.