Date: Fri, 22 Mar 2002 14:50:25 +0000 (GMT) From: jason+freebsd@kanda.com To: sunny dale <s.dale@gmx.net> Cc: freebsd-questions@freebsd.org Subject: Re: mysqld doesnt spawn child process Message-ID: <20020322130056.K28894-100000@uk2.kanda-systems.net> In-Reply-To: <3C9B33D4.1020601@gmx.net>
next in thread | previous in thread | raw e-mail | index | archive | help
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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20020322130056.K28894-100000>