From owner-freebsd-questions Fri Mar 22 3:35:33 2002 Delivered-To: freebsd-questions@freebsd.org Received: from mail.gmx.net (mail.gmx.net [213.165.64.20]) by hub.freebsd.org (Postfix) with SMTP id E322937B400 for ; Fri, 22 Mar 2002 03:35:29 -0800 (PST) Received: (qmail 26122 invoked by uid 0); 22 Mar 2002 11:35:29 -0000 Received: from unknown (HELO gmx.net) (217.110.34.96) by mail.gmx.net (mp002-rz3) with SMTP; 22 Mar 2002 11:35:29 -0000 Message-ID: <3C9B33D4.1020601@gmx.net> Date: Fri, 22 Mar 2002 13:38:28 +0000 From: sunny dale User-Agent: Mozilla/5.0 (X11; U; Linux i386; en-US; rv:0.9.7+) Gecko/20020110 X-Accept-Language: en-us MIME-Version: 1.0 To: jason+freebsd@kanda.com Cc: freebsd-questions@freebsd.org Subject: Re: mysqld doesnt spawn child process References: <20020322122206.X28894-100000@uk2.kanda-systems.net> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit 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 - is it multithreaded on *bsd only? i have a mysqld on a linux box running which spawns child processeses. - if somehow it should be possible to run it in multiprocess "mode" is that preferable? sorry if my questions are being stupid. i still am a newbie. 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