From owner-freebsd-questions Wed Apr 3 1:39:11 2002 Delivered-To: freebsd-questions@freebsd.org Received: from uk2.kanda-systems.net (uk2.kanda-systems.net [193.195.117.202]) by hub.freebsd.org (Postfix) with ESMTP id 025D437B41F for ; Wed, 3 Apr 2002 01:39:09 -0800 (PST) Received: from localhost.kanda-systems.net (localhost.kanda-systems.net [127.0.0.1]) by uk2.kanda-systems.net (Postfix) with ESMTP id 1D2373C1E8; Wed, 3 Apr 2002 11:44:39 +0100 (BST) Date: Wed, 3 Apr 2002 11:44:38 +0100 (BST) From: jason+freebsd@kanda.com X-X-Sender: jason@uk2.kanda-systems.net Reply-To: jason+freebsd@kanda.com To: alexus Cc: freebsd-questions@FreeBSD.ORG Subject: Re: mysql eats up only one Cpu instead of both? In-Reply-To: <000f01c1da9d$24051cc0$0d00a8c0@alexus> Message-ID: <20020403113229.U82078-100000@uk2.kanda-systems.net> 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 On Tue, 2 Apr 2002, alexus wrote: > >i compiled in kernel two processors, in dmesg both of 'em show up.. but >when i run mysql only one processor is using.. why? MySQL us running multi-threaded, not multi-process. So you won't be able to see what CPU each thread is running on using top. I'm not sure if there are any tools to give this kind of information. Below is an explanation of why things look different than on Linux: On Fri, 22 Mar 2002, sunny dale wrote: > - is it multithreaded on *bsd only? i have a mysqld on a linux box > running which spawns child processeses. Its all to do with threading libraries, take a look at: http://pauillac.inria.fr/~xleroy/linuxthreads/faq.html#K To summarize, LinuxThreads (threading library used on Linux) creates a seperate process for each new thread, therefore each thread is viewable through ps & top etc. FreeBSD creates real threads (ie. not processes) therefore they are not visible through process viewing tools as they are not processes ;) Jason To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message