From owner-freebsd-questions  Tue Jun 11  0:42:29 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 BF9E837B40C
	for <freebsd-questions@FreeBSD.ORG>; Tue, 11 Jun 2002 00:42:22 -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 g5B7gIWM001846;
	Tue, 11 Jun 2002 09:42:19 +0200 (CEST)
	(envelope-from leo@ktv.se)
Content-Type: text/plain;
  charset="iso-8859-1"
From: Leo De Geer <leo@ktv.se>
Reply-To: leo@ktv.se
Organization: Kristianstad Teknikverkstad
To: Alexander V Zubchenko <stalker@hermes-comp.zp.ua>
Subject: Re: problem with mysql threads on freebsd
Date: Tue, 11 Jun 2002 09:42:01 +0200
X-Mailer: KMail [version 1.4]
Cc: Dicky Wahyu Purnomo <dicky.wahyu@1rstwap.com>,
	<mysql@lists.mysql.com>, <freebsd-questions@FreeBSD.ORG>
References: <20020611102150.X87697-100000@server.hermes-comp.zp.ua>
In-Reply-To: <20020611102150.X87697-100000@server.hermes-comp.zp.ua>
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable
Message-Id: <200206110942.01377.leo@ktv.se>
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

On Tuesday 11 June 2002 09.26, Alexander V Zubchenko wrote:
> Greetings!
>
> On Tue, 11 Jun 2002, Leo De Geer wrote:
> > On Tuesday 11 June 2002 08.49, Dicky Wahyu Purnomo wrote:
> > > On Tue, 11 Jun 2002 08:36:55 +0200
> > >
> > > Leo De Geer <leo@ktv.se> wrote:
> > > > im not abel to get mysql to use more then one thread on my freebs=
d
> > > > 4.5-stable any one having a klue that wrong?????
> > >
> > > from what method / tools, you get this information ?
>
> Good question.
>
> > > try mysqladmin -p status
> >
> > yast by putting load to it. and by using the top.
> > then i get al the load on the master pid
>
> Sorry, but, afaic, You don't understand what threads are. Thread is
> subprogram, which is executed simultaneously with main program (main
> thread) in _same_ process. PID is process parameter and additional
> threads don't create additional PID's. Multithreading,
> in fact, allow You to not create additional processes (which is
> resource-consuming task), but do parallel computations inside _one_
> process. So master pid _must_ take all load, if it act as
> multithreaded program.
>
> 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
>
>
> To Unsubscribe: send mail to majordomo@FreeBSD.org
> with "unsubscribe freebsd-questions" in the body of the message
but in my case its not good to have it that way im having one dedikated d=
ual=20
server for the sql and now im yust using one cpu for the sql questions. i=
=20
nead it to start sub conections to the sql to serv all my conections good=
=2E=20
--=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