From owner-freebsd-questions  Tue Jun 11  1:23:51 2002
Delivered-To: freebsd-questions@freebsd.org
Received: from lexx.zssm.zp.ua (lexx.zssm.zp.ua [212.8.32.8])
	by hub.freebsd.org (Postfix) with ESMTP id B4CFA37B405
	for <freebsd-questions@FreeBSD.ORG>; Tue, 11 Jun 2002 01:23:18 -0700 (PDT)
Received: from server.hermes-comp.zp.ua (germes-comp.zssm.zp.ua [212.8.32.132] (may be forged))
	by lexx.zssm.zp.ua (8.9.2/8.9.2) with ESMTP id LAA03063;
	Tue, 11 Jun 2002 11:01:27 +0300 (EET DST)
Received: from localhost (localhost [127.0.0.1])
	by server.hermes-comp.zp.ua (Postfix) with ESMTP
	id 7740538302; Tue, 11 Jun 2002 10:57:23 +0300 (EEST)
Date: Tue, 11 Jun 2002 10:57:23 +0300 (EEST)
From: Alexander V Zubchenko <stalker@hermes-comp.zp.ua>
To: Leo De Geer <leo@ktv.se>
Cc: Dicky Wahyu Purnomo <dicky.wahyu@1rstwap.com>,
	<mysql@lists.mysql.com>, <freebsd-questions@FreeBSD.ORG>
Subject: Re: problem with mysql threads on freebsd
In-Reply-To: <200206110942.01377.leo@ktv.se>
Message-ID: <20020611104600.A87813-100000@server.hermes-comp.zp.ua>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
Sender: owner-freebsd-questions@FreeBSD.ORG
Precedence: bulk
List-ID: <freebsd-questions.FreeBSD.ORG>
List-Archive: <http://docs.freebsd.org/mail/> (Web Archive)
List-Help: <mailto:majordomo@FreeBSD.ORG?subject=help> (List Instructions)
List-Subscribe: <mailto:majordomo@FreeBSD.ORG?subject=subscribe%20freebsd-questions>
List-Unsubscribe: <mailto:majordomo@FreeBSD.ORG?subject=unsubscribe%20freebsd-questions>
X-Loop: FreeBSD.ORG

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@hermes-comp.zp.ua
System Administrator,		WWW: http://www.hermes-comp.zp.ua/
Hermes-comp,
Ukraine,
Zaporizhzhya,
Geroev Stalingrada 50
phone/fax: +380 612 64-19-72



To Unsubscribe: send mail to majordomo@FreeBSD.org
with "unsubscribe freebsd-questions" in the body of the message