Hi Matt, I am trying it now! Thanks! Seems to work, I am running
it on one of the QA servers now and I see it spawning many mysql
processes! Very cool! BTW to anyone usings ports after a source
install use DB_DIR=/usr/local/var you will get an error at the end of
make install, but it's OK! When did this get in!
Ken
----- Original Message -----
From: "Matthew Reimer" <[EMAIL PROTECTED]>
To: "Ken Menzel" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, June 13, 2001 1:18 PM
Subject: Re: Multiple CPU's in Freebsd
> 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
>
>
---------------------------------------------------------------------
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
