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..... > > Simon > > -----Original Message----- > From: Leo De Geer [mailto:[EMAIL PROTECTED]] > Sent: 11 June 2002 09:35 > To: Alexander V Zubchenko > Cc: Dicky Wahyu Purnomo; [EMAIL PROTECTED]; > [EMAIL PROTECTED] > 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: [EMAIL PROTECTED] > > 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 > everything > but the sql! > > i have on my linux sql server aproximatly 100 simultanius conections that > du > > you think that the standard memory size of 128 do you think i nead to put > it > > 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
regards leo -- MVH C. Leo De Geer www.dinsignal.com www.ktv.se www.teknikshoppen.nu --------------------------------------------------------------------- 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
