From owner-freebsd-questions Tue Jun 11 0:34:41 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 241AA37B400 for ; Tue, 11 Jun 2002 00:34:25 -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 KAA00541; Tue, 11 Jun 2002 10:30:09 +0300 (EET DST) Received: from localhost (localhost [127.0.0.1]) by server.hermes-comp.zp.ua (Postfix) with ESMTP id A56A438302; Tue, 11 Jun 2002 10:26:03 +0300 (EEST) Date: Tue, 11 Jun 2002 10:26:03 +0300 (EEST) From: Alexander V Zubchenko To: Leo De Geer Cc: Dicky Wahyu Purnomo , , Subject: Re: problem with mysql threads on freebsd In-Reply-To: <200206110924.35335.leo@ktv.se> Message-ID: <20020611102150.X87697-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: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.ORG 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 wrote: > > > im not abel to get mysql to use more then one thread on my freebsd > > > 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, 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