On Tuesday 11 June 2002 10.48, Simon Green wrote:
> We are ruing a box with freeBSD and MySQL with twin processors....
> It looked like it was using only on processor but we decided that it was
> the way FreeBSD's threads work?
> There seems to be two problems with ruing MySQL on FreeBSD.
> One: Seems not to use both processors (on twin system)
> Two: All ways a load on 1 even when the system in not at hi load (seem to
> go down when it is!)
> What is up with freeBSD or MySQL.....
> -----Original Message-----
> From: Leo De Geer [mailto:leo@stripped]
> Sent: 11 June 2002 09:35
> To: Alexander V Zubchenko
> Cc: Dicky Wahyu Purnomo; mysql@stripped;
> Subject: Re: problem with mysql threads on freebsd
> On Tuesday 11 June 2002 09.57, Alexander V Zubchenko wrote:
> > Greetings!
> > On Tue, 11 Jun 2002, Leo De Geer wrote:
> > > but in my case its not good to have it that way im having one dedikated
> > > dual server for the sql and now im yust using one cpu for the sql
> > > questions. i nead it to start sub conections to the sql to serv all my
> > > conections good.
> > In such case provide, please additional info. AFAIU, You want to use
> > both cpu for sql, in other words, optimal use of Your server. Than, do
> > You recompile (or compile) kernel with SMP support (afaik, this is
> > only arch for multicpu systems, supported by fbsd)? You can b sure,
> > that if mysql will run separate process for each request, it will
> > slowdown perfomance, but never increase it. In fact, balancing load on
> > many cpus is OS task. And multithreaded processes _must_ b processed
> > similarly to multiprocess environment (but i don't know, how exactly
> > fbsd smp-support built). Check Your kernel config
> > /usr/src/sys/i386/conf/<name>. You may find also this <name>
> > interesting:
> > LINT - list [almost?] all options recognized in config-file.
> > With respect,
> > Alexander V Zubchenko, E-Mail: stalker@stripped
> > System Administrator, WWW: http://www.hermes-comp.zp.ua/
> > Hermes-comp,
> > Ukraine,
> > Zaporizhzhya,
> > Geroev Stalingrada 50
> > phone/fax: +380 612 64-19-72
> the kernel is runing both cpu. and the balancing is working good on
> but the sql!
> i have on my linux sql server aproximatly 100 simultanius conections that
> you think that the standard memory size of 128 do you think i nead to put
> up to 256 meg in the kernel
the problen nr 2 i dont have but the server we have dont handle the load on
one cpu. at the moment we are runing the sql on a linux instead (same
hardwere) but i sucks. alla auter servers is freebsd and they run mutch beter
MVH C. Leo De Geer