Date: Tue, 11 Jun 2002 09:42:01 +0200 From: Leo De Geer <leo@ktv.se> To: Alexander V Zubchenko <stalker@hermes-comp.zp.ua> Cc: Dicky Wahyu Purnomo <dicky.wahyu@1rstwap.com>, <mysql@lists.mysql.com>, <freebsd-questions@FreeBSD.ORG> Subject: Re: problem with mysql threads on freebsd Message-ID: <200206110942.01377.leo@ktv.se> In-Reply-To: <20020611102150.X87697-100000@server.hermes-comp.zp.ua> References: <20020611102150.X87697-100000@server.hermes-comp.zp.ua>
next in thread | previous in thread | raw e-mail | index | archive | help
On Tuesday 11 June 2002 09.26, Alexander V Zubchenko wrote: > Greetings! > > On Tue, 11 Jun 2002, Leo De Geer wrote: > > On Tuesday 11 June 2002 08.49, Dicky Wahyu Purnomo wrote: > > > On Tue, 11 Jun 2002 08:36:55 +0200 > > > > > > Leo De Geer <leo@ktv.se> wrote: > > > > im not abel to get mysql to use more then one thread on my freebs= d > > > > 4.5-stable any one having a klue that wrong????? > > > > > > from what method / tools, you get this information ? > > Good question. > > > > try mysqladmin -p status > > > > yast by putting load to it. and by using the top. > > then i get al the load on the master pid > > Sorry, but, afaic, You don't understand what threads are. Thread is > subprogram, which is executed simultaneously with main program (main > thread) in _same_ process. PID is process parameter and additional > threads don't create additional PID's. Multithreading, > in fact, allow You to not create additional processes (which is > resource-consuming task), but do parallel computations inside _one_ > process. So master pid _must_ take all load, if it act as > multithreaded program. > > With respect, > > Alexander V Zubchenko,=09=09E-Mail: stalker@hermes-comp.zp.ua > System Administrator,=09=09WWW: http://www.hermes-comp.zp.ua/ > Hermes-comp, > Ukraine, > Zaporizhzhya, > Geroev Stalingrada 50 > phone/fax: +380 612 64-19-72 > > > To Unsubscribe: send mail to majordomo@FreeBSD.org > with "unsubscribe freebsd-questions" in the body of the message but in my case its not good to have it that way im having one dedikated d= ual=20 server for the sql and now im yust using one cpu for the sql questions. i= =20 nead it to start sub conections to the sql to serv all my conections good= =2E=20 --=20 MVH C. Leo De Geer www.dinsignal.com www.ktv.se www.teknikshoppen.nu 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?200206110942.01377.leo>