From owner-freebsd-questions Tue Jun 11 1:34:57 2002 Delivered-To: freebsd-questions@freebsd.org Received: from bamse.ktv.se (bamse.ktv.se [195.17.241.138]) by hub.freebsd.org (Postfix) with ESMTP id 1260237B407 for ; Tue, 11 Jun 2002 01:34:51 -0700 (PDT) Received: from leo.ktv.se (gw.ktv.se [194.52.13.251]) by bamse.ktv.se (8.12.3/8.12.3) with ESMTP id g5B8Z4WM002061; Tue, 11 Jun 2002 10:35:04 +0200 (CEST) (envelope-from leo@ktv.se) Content-Type: text/plain; charset="iso-8859-1" From: Leo De Geer Reply-To: leo@ktv.se Organization: Kristianstad Teknikverkstad To: Alexander V Zubchenko Subject: Re: problem with mysql threads on freebsd Date: Tue, 11 Jun 2002 10:34:46 +0200 X-Mailer: KMail [version 1.4] Cc: Dicky Wahyu Purnomo , , References: <20020611104600.A87813-100000@server.hermes-comp.zp.ua> In-Reply-To: <20020611104600.A87813-100000@server.hermes-comp.zp.ua> MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Message-Id: <200206111034.46397.leo@ktv.se> Sender: owner-freebsd-questions@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.ORG 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 dedikat= ed > > 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 m= y > > 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/. You may find also this > interesting: > LINT - list [almost?] all options recognized in config-file. > > With respect, > > Alexander V Zubchenko,=09=09E-Mail: stalker@hermes-comp.zp.ua > System Administrator,=09=09WWW: 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 every= thing=20 but the sql! i have on my linux sql server aproximatly 100 simultanius conections that= du=20 you think that the standard memory size of 128 do you think i nead to put= it=20 up to 256 meg in the kernel --=20 MVH C. Leo De Geer www.dinsignal.com www.ktv.se www.teknikshoppen.nu To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message