Date: Tue, 17 Feb 2004 18:12:48 -0700 (MST) From: "Kris Gale" <kris-fbsd@asn.net> To: freebsd-threads@freebsd.org Subject: Re: More on MySQL -- Fatal trap 12 Message-ID: <49327.68.106.19.246.1077066768.squirrel@mail.asn.net> In-Reply-To: <Pine.GSO.4.10.10402171926550.4193-100000@pcnet5.pcnet.com> References: <56666.68.106.19.246.1077058348.squirrel@mail.asn.net> <Pine.GSO.4.10.10402171926550.4193-100000@pcnet5.pcnet.com>
next in thread | previous in thread | raw e-mail | index | archive | help
> 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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?49327.68.106.19.246.1077066768.squirrel>