From owner-freebsd-threads@FreeBSD.ORG Tue Feb 17 17:12:49 2004 Return-Path: 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 3618116A4CE for ; Tue, 17 Feb 2004 17:12:49 -0800 (PST) Received: from mail.asn.net (mail.asn.net [66.235.231.4]) by mx1.FreeBSD.org (Postfix) with SMTP id 1E14F43D1D for ; Tue, 17 Feb 2004 17:12:49 -0800 (PST) (envelope-from kris-fbsd@asn.net) Received: (qmail 47447 invoked by uid 80); 18 Feb 2004 01:12:48 -0000 Received: from 68.106.19.246 (SquirrelMail authenticated user kgale) by mail.asn.net with HTTP; Tue, 17 Feb 2004 18:12:48 -0700 (MST) Message-ID: <49327.68.106.19.246.1077066768.squirrel@mail.asn.net> In-Reply-To: References: <56666.68.106.19.246.1077058348.squirrel@mail.asn.net> Date: Tue, 17 Feb 2004 18:12:48 -0700 (MST) From: "Kris Gale" 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 List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 18 Feb 2004 01:12:49 -0000 > You expect 900 threads on the server (perhaps a few more > for overhead tasks), right? Yep, and that's what I see. MySQL reports 900 threads in this instance. > What are the settings for kern.thread.*? kern.threads.debug: 0 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 > I would like to see how MySQL works when using process > scope threads. Do you know enough to hack it to do that? Wish I did. =) > A step-by-step process of how to set up MySQL and run > the tests would be nice along with the perl script. The script is at http://hutta.com/test-threads.pl A current build will automatically use KSE for MySQL, but a build from a few weeks ago will need the proper entries in libmap.conf. Set OVERWRITE_DB=yes when installing the port (databases/mysql40-server) to get default databases set up, and my perl script will create everything it needs for testing. I haven't seen any difference in using BUILD_OPTIMIZED or BUILD_STATIC, so use those as you so feel. I'm using the following config file for mysql: ---[ BEGIN /etc/my.cnf ]--- [client] port = 3306 socket = /tmp/mysql.sock [mysqld] set-variable = max_connections=6000 port = 3306 socket = /tmp/mysql.sock skip-locking set-variable = key_buffer=1024M set-variable = max_allowed_packet=1M set-variable = table_cache=512 set-variable = sort_buffer=1M set-variable = record_buffer=1M set-variable = myisam_sort_buffer_size=128M set-variable = thread_cache=8 set-variable = thread_concurrency=4 server-id = 1 skip-innodb tmpdir = /usr/tmp/ [mysql] no-auto-rehash ---[ END /etc/my.cnf ]---- Kris Gale