Hi Rafael,
This is not an easy task, there are really only two ways to
accomplish this. But first I must ask if you have check how much CPU
% is currently in use? Is consistently high? The other cpus's will
be used to runs things such as Apache, but mysql will run on one
processor. Or, you could start several mysqld processes, each
listening to a different port or IP address. To use different IP
addresses one would have to enable multiple virtual IP's for that
machine. I understand there are some big threads improvements coming
for FreeBSD, but I am not sure when they are coming.
If you use multiple ports, your application will have to select the
port to connect to (such as 3306, 3307, 3308, 3309) or if you use
multiple IP addresses then you can use DNS round Robin technique with
multiple A records for a single name.
Sorry there is currently no easy answer.
Ken (also a FreeBSD multi CPU user).
----- Original Message -----
From: "Rafael Martinez" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, June 12, 2001 10:52 AM
Subject: Re: Multiple CPU's in Freebsd
> ---Reply to mail from Sinisa Milivojevic about Multiple CPU's
> > [EMAIL PROTECTED] writes:
> >> Hi,
> >> Can anyone help me out! Does MySQL run efficently in a multi
> >> CPU environment.
> >
> [..........]
>
> > MySQL supports as many CPU as you might have, but FreeBSD threads
do
> > not support SMP, so MySQL can not use them.
> >
>
> I am trying to run mysql in freebsd 4.3 in a 4xCpu machine. And as
you
> say mysql only use 1 of them.
>
> Is it possible in any way to use all the cpus in this machine with
mysql?
> I thougt I was doing something wrong or that I had to patch some
libraries
> but after your answer I am starting to panic. What about
MIT-threads?
>
> I can not install Linux in this machine (scsi + raid card not
stable),
> that is the reason because I am using freebsd and I need to get this
> machine in production as soon as possible.
>
> Any ideas, suggestions, tips, help are welcome.
> Sincerely
> Rafael Martinez
>
>
>
>
> --------------------------------------------------------------------
-
> 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
