From owner-freebsd-questions  Fri Mar 22  3:25:18 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 7137A37B41A
	for <freebsd-questions@freebsd.org>; Fri, 22 Mar 2002 03:25:15 -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 8CB1F3C1ED; Fri, 22 Mar 2002 12:23:24 +0000 (GMT)
Date: Fri, 22 Mar 2002 12:23:24 +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: <3C9B2D07.3080600@gmx.net>
Message-ID: <20020322122206.X28894-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




> "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