Skip site navigation (1)Skip section navigation (2)
Date:      Tue, 17 Feb 2004 18:23:37 -0700 (MST)
From:      "Kris Gale" <kris-fbsd@asn.net>
To:        freebsd-threads@freebsd.org
Subject:   Re: More on MySQL -- Fatal trap 12
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>

next in thread | previous in thread | raw e-mail | index | archive | help
> (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



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?49363.68.106.19.246.1077067417.squirrel>