It went in Wed May 23 20:26:06 2001 UTC.
http://www.freebsd.org/cgi/cvsweb.cgi/ports/databases/mysql323-server/Makefile.diff?r1=1.114&r2=1.115
Matt
Ken Menzel wrote:
>
> 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
