Try this: update your ports, then build the mysql port with
"WITH_LINUXTHREADS=1". This should result in a FreeBSD native binary
linked against linuxthreads instead of libc_r, so it should use multiple
processors.
Matt
Ken Menzel wrote:
>
> 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
---------------------------------------------------------------------
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
