From owner-freebsd-questions  Fri Mar 22  5:52:24 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 6B27E37B404
	for <freebsd-questions@freebsd.org>; Fri, 22 Mar 2002 05:52:17 -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 663E63C1E8; Fri, 22 Mar 2002 14:50:25 +0000 (GMT)
Date: Fri, 22 Mar 2002 14:50:25 +0000 (GMT)
From: jason+freebsd@kanda.com
X-X-Sender: jason@uk2.kanda-systems.net
Reply-To: jason+freebsd@kanda.com
To: sunny dale <s.dale@gmx.net>
Cc: freebsd-questions@freebsd.org
Subject: Re: mysqld doesnt spawn child process
In-Reply-To: <3C9B33D4.1020601@gmx.net>
Message-ID: <20020322130056.K28894-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: <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 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 ;)

> sorry if my questions are being stupid. i still am a newbie.

Don't worry about it, I was also a bit puzzled by this :)

Jason


 >
>
>
> jason+freebsd@kanda.com wrote:
>
> >
> >
> >>"ps ax" shows ONE mysqld running. i'd like it spawn a few child
> >>processes. i've read somewhere, that mysqld spawns them dynamically...
> >>but no matter how hard i stress mysqld "ps ax" show only one process.
> >>max_connections is set to 300. basically i'd like mysqld to be able to
> >>handle even more queries than it does so far.
> >>
> >>any hints would be highly appreciated.
> >>
> >
> >Mysql is multi-threaded not multi-process.  Therefore you  will see one
> >big ugly looking process from ps or top.
> >
> >Jaosn.
> >
> >
> >To Unsubscribe: send mail to majordomo@FreeBSD.org
> >with "unsubscribe freebsd-questions" in the body of the message
> >
> >
>
>
>




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