More on MySQL -- Fatal trap 12

Kris Gale kris-fbsd at asn.net
Tue Feb 17 17:23:37 PST 2004


> (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


More information about the freebsd-threads mailing list