From owner-freebsd-threads@FreeBSD.ORG  Tue Feb 17 17:23:37 2004
Return-Path: <owner-freebsd-threads@FreeBSD.ORG>
Delivered-To: freebsd-threads@freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id ACB6C16A4CE
	for <freebsd-threads@freebsd.org>;
	Tue, 17 Feb 2004 17:23:37 -0800 (PST)
Received: from mail.asn.net (mail.asn.net [66.235.231.4])
	by mx1.FreeBSD.org (Postfix) with SMTP id 7CB7F43D1F
	for <freebsd-threads@freebsd.org>;
	Tue, 17 Feb 2004 17:23:37 -0800 (PST)
	(envelope-from kris-fbsd@asn.net)
Received: (qmail 47829 invoked by uid 80); 18 Feb 2004 01:23:37 -0000
Received: from 68.106.19.246
        (SquirrelMail authenticated user kgale)
        by mail.asn.net with HTTP;
        Tue, 17 Feb 2004 18:23:37 -0700 (MST)
Message-ID: <49363.68.106.19.246.1077067417.squirrel@mail.asn.net>
In-Reply-To: <20040218000052.GA70706@crodrigues.org>
References: <56666.68.106.19.246.1077058348.squirrel@mail.asn.net>
    <20040218000052.GA70706@crodrigues.org>
Date: Tue, 17 Feb 2004 18:23:37 -0700 (MST)
From: "Kris Gale" <kris-fbsd@asn.net>
To: freebsd-threads@freebsd.org
User-Agent: SquirrelMail/1.4.2
MIME-Version: 1.0
Content-Type: text/plain;charset=iso-8859-1
Content-Transfer-Encoding: 8bit
X-Priority: 3
Importance: Normal
Subject: Re: More on MySQL -- Fatal trap 12
X-BeenThere: freebsd-threads@freebsd.org
X-Mailman-Version: 2.1.1
Precedence: list
List-Id: Threading on FreeBSD <freebsd-threads.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-threads>,
	<mailto:freebsd-threads-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-threads>
List-Post: <mailto:freebsd-threads@freebsd.org>
List-Help: <mailto:freebsd-threads-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-threads>,
	<mailto:freebsd-threads-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Wed, 18 Feb 2004 01:23:37 -0000

> (1) steps you used to build MySQL, ie. cd /usr/ports/blah, make install

This is assuming you have a current build (with KSE as the default
threading system.)

# cd /usr/ports/databases/mysql40-server
# make OVERWRITE_DB=yes install

Then, to install the dependencies for my script, and to
fetch it:

# cd ../p5-DBI
# make install
# cd ../p5-DBD-mysql40
# make install
# cd ~
# fetch http://hutta.com/test-threads.pl

To test:

# /usr/local/etc/rc.d/mysql-server.sh start
# ./test-threads.pl

> (2) output of the following:
>
> sysctl hw.model hw.physmem hw.usermem kern.threads.max_threads_per_proc \
>        kern.threads.max_groups_per_proc kern.threads.max_threads_hits \
>        kern.threads.virtual_cpu

hw.model: Intel(R) Xeon(TM) CPU 2.66GHz
hw.physmem: 4151197696
hw.usermem: 4111593472
kern.threads.max_threads_per_proc: 2500
kern.threads.max_groups_per_proc: 2500
kern.threads.max_threads_hits: 0
kern.threads.virtual_cpu: 4

Kris Gale