Hi, First of all, we can presume you're using SMP kernel. Then I'd suggest using Linuxthreads despite your dislike for them - by my experience, they work far better for mysql/FreeBSD than native threads. May be you try it again - compile mysql from the ports (WITH_LINUXTHREADS=yes), and it should solve it.
Regards ---- Alexander Varshavchick, Metrocom Joint Stock Company Phone: (812)118-3322, 118-3115(fax) On Fri, 10 Jan 2003, Tommy F. Eriksen wrote: > Date: Fri, 10 Jan 2003 09:14:18 +0100 > From: Tommy F. Eriksen <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Subject: Using more than one CPU on FreeBSD? > > Hi, > > I've "inherited" a FreeBSD/MySQL database-server (Compaq DL360, dual P3 1GHz), >running (at the moment): Server version: 4.0.3-beta > However, as far as I can tell, MySQL/FreeBSD 4.6.2-RELEASE still can't agree on >utilizing more than one CPU. > > My question is this: > A year or two ago, someone mentioned simply running two mysqld's on the same >database-files (using file-locking) and then, using some form for loadbalancing >between the two, was able to use more than one CPU for the mysqlds. > Is this still the "recommended" way of doing this? > I know I could use Linuxthreads, but the times I've tried them in the past, they >have done more harm than good (low performance, unstability etc). > > Any advice would be appreciated :) > Kind regards, > Tommy Eriksen > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php