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

Reply via email to