From owner-freebsd-questions Fri Mar 22 8: 4:38 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 18E1C37B419 for ; Fri, 22 Mar 2002 08:04:32 -0800 (PST) Received: (qmail 11972 invoked by uid 0); 22 Mar 2002 16:04:30 -0000 Received: from unknown (HELO gmx.net) (217.110.34.96) by mail.gmx.net (mp011-rz3) with SMTP; 22 Mar 2002 16:04:30 -0000 Message-ID: <3C9B72E1.30904@gmx.net> Date: Fri, 22 Mar 2002 18:07:29 +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: <20020322130056.K28894-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 thanks. helped me alot! jason+freebsd@kanda.com wrote: >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