problem with mysql threads on freebsd
im not abel to get mysql to use more then one thread on my freebsd 4.5-stable any one having a klue that wrong? regards leo -- MVH C. Leo De Geer www.dinsignal.com www.ktv.se www.teknikshoppen.nu - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: problem with mysql threads on freebsd
On Tue, 11 Jun 2002 08:36:55 +0200 Leo De Geer [EMAIL PROTECTED] wrote: im not abel to get mysql to use more then one thread on my freebsd 4.5-stable any one having a klue that wrong? from what method / tools, you get this information ? try mysqladmin -p status -- Linux is not user-friendly. It _is_ user-friendly. It is not ignorant-friendly and idiot-friendly. -- Seen somewhere on the net - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: problem with mysql threads on freebsd
On Tuesday 11 June 2002 08.49, Dicky Wahyu Purnomo wrote: On Tue, 11 Jun 2002 08:36:55 +0200 Leo De Geer [EMAIL PROTECTED] wrote: im not abel to get mysql to use more then one thread on my freebsd 4.5-stable any one having a klue that wrong? from what method / tools, you get this information ? 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 -- MVH C. Leo De Geer www.dinsignal.com www.ktv.se www.teknikshoppen.nu - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: problem with mysql threads on freebsd
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 [EMAIL PROTECTED] wrote: im not abel to get mysql to use more then one thread on my freebsd 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, E-Mail: [EMAIL PROTECTED] System Administrator, WWW: http://www.hermes-comp.zp.ua/ Hermes-comp, Ukraine, Zaporizhzhya, Geroev Stalingrada 50 phone/fax: +380 612 64-19-72 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: problem with mysql threads on freebsd
On Tuesday 11 June 2002 08.49, Dicky Wahyu Purnomo wrote: On Tue, 11 Jun 2002 08:36:55 +0200 Leo De Geer [EMAIL PROTECTED] wrote: im not abel to get mysql to use more then one thread on my freebsd 4.5-stable any one having a klue that wrong? from what method / tools, you get this information ? try mysqladmin -p status the mysqladmin dets the result Uptime: 51804 Threads: 2 Questions: 1757 Slow queries: 0 Opens: 48 Flush tables: 1 Open tables: 37 Queries per second avg: 0.03 -- MVH C. Leo De Geer www.dinsignal.com www.ktv.se www.teknikshoppen.nu - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: problem with mysql threads on freebsd
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 [EMAIL PROTECTED] wrote: im not abel to get mysql to use more then one thread on my freebsd 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,E-Mail: [EMAIL PROTECTED] System Administrator, WWW: 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 [EMAIL PROTECTED] 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 dual server for the sql and now im yust using one cpu for the sql questions. i nead it to start sub conections to the sql to serv all my conections good. -- MVH C. Leo De Geer www.dinsignal.com www.ktv.se www.teknikshoppen.nu - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: problem with mysql threads on freebsd
On Tuesday 11 June 2002 09.57, Alexander V Zubchenko wrote: Greetings! On Tue, 11 Jun 2002, Leo De Geer wrote: but in my case its not good to have it that way im having one dedikated dual server for the sql and now im yust using one cpu for the sql questions. i nead it to start sub conections to the sql to serv all my conections good. In such case provide, please additional info. AFAIU, You want to use both cpu for sql, in other words, optimal use of Your server. Than, do You recompile (or compile) kernel with SMP support (afaik, this is only arch for multicpu systems, supported by fbsd)? You can b sure, that if mysql will run separate process for each request, it will slowdown perfomance, but never increase it. In fact, balancing load on many cpus is OS task. And multithreaded processes _must_ b processed similarly to multiprocess environment (but i don't know, how exactly fbsd smp-support built). Check Your kernel config /usr/src/sys/i386/conf/name. You may find also this name interesting: LINT - list [almost?] all options recognized in config-file. With respect, Alexander V Zubchenko,E-Mail: [EMAIL PROTECTED] System Administrator, WWW: http://www.hermes-comp.zp.ua/ Hermes-comp, Ukraine, Zaporizhzhya, Geroev Stalingrada 50 phone/fax: +380 612 64-19-72 the kernel is runing both cpu. and the balancing is working good on everything but the sql! i have on my linux sql server aproximatly 100 simultanius conections that du you think that the standard memory size of 128 do you think i nead to put it up to 256 meg in the kernel -- MVH C. Leo De Geer www.dinsignal.com www.ktv.se www.teknikshoppen.nu - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: problem with mysql threads on freebsd
Leo, I believe there was a conversation about this subject several weeks ago, in which the conclusion was that a good reason to use Linux, in preference to FreeBSD, for database servers is that Linux multi-processor support works and FreeBSD doesn't. --Erv sql,query At 09:42 AM 6/11/2002 +0200, Leo De Geer wrote: but in my case its not good to have it that way im having one dedikated dual server for the sql and now im yust using one cpu for the sql questions. i nead it to start sub conections to the sql to serv all my conections good. -- MVH C. Leo De Geer www.dinsignal.com www.ktv.se www.teknikshoppen.nu - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: problem with mysql threads on freebsd
We are ruing a box with freeBSD and MySQL with twin processors It looked like it was using only on processor but we decided that it was the way FreeBSD's threads work? There seems to be two problems with ruing MySQL on FreeBSD. One: Seems not to use both processors (on twin system) Two: All ways a load on 1 even when the system in not at hi load (seem to go down when it is!) What is up with freeBSD or MySQL. Simon -Original Message- From: Leo De Geer [mailto:[EMAIL PROTECTED]] Sent: 11 June 2002 09:35 To: Alexander V Zubchenko Cc: Dicky Wahyu Purnomo; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: problem with mysql threads on freebsd On Tuesday 11 June 2002 09.57, Alexander V Zubchenko wrote: Greetings! On Tue, 11 Jun 2002, Leo De Geer wrote: but in my case its not good to have it that way im having one dedikated dual server for the sql and now im yust using one cpu for the sql questions. i nead it to start sub conections to the sql to serv all my conections good. In such case provide, please additional info. AFAIU, You want to use both cpu for sql, in other words, optimal use of Your server. Than, do You recompile (or compile) kernel with SMP support (afaik, this is only arch for multicpu systems, supported by fbsd)? You can b sure, that if mysql will run separate process for each request, it will slowdown perfomance, but never increase it. In fact, balancing load on many cpus is OS task. And multithreaded processes _must_ b processed similarly to multiprocess environment (but i don't know, how exactly fbsd smp-support built). Check Your kernel config /usr/src/sys/i386/conf/name. You may find also this name interesting: LINT - list [almost?] all options recognized in config-file. With respect, Alexander V Zubchenko,E-Mail: [EMAIL PROTECTED] System Administrator, WWW: http://www.hermes-comp.zp.ua/ Hermes-comp, Ukraine, Zaporizhzhya, Geroev Stalingrada 50 phone/fax: +380 612 64-19-72 the kernel is runing both cpu. and the balancing is working good on everything but the sql! i have on my linux sql server aproximatly 100 simultanius conections that du you think that the standard memory size of 128 do you think i nead to put it up to 256 meg in the kernel -- MVH C. Leo De Geer www.dinsignal.com www.ktv.se www.teknikshoppen.nu - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: problem with mysql threads on freebsd
On Tuesday 11 June 2002 10.48, Simon Green wrote: We are ruing a box with freeBSD and MySQL with twin processors It looked like it was using only on processor but we decided that it was the way FreeBSD's threads work? There seems to be two problems with ruing MySQL on FreeBSD. One: Seems not to use both processors (on twin system) Two: All ways a load on 1 even when the system in not at hi load (seem to go down when it is!) What is up with freeBSD or MySQL. Simon -Original Message- From: Leo De Geer [mailto:[EMAIL PROTECTED]] Sent: 11 June 2002 09:35 To: Alexander V Zubchenko Cc: Dicky Wahyu Purnomo; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: problem with mysql threads on freebsd On Tuesday 11 June 2002 09.57, Alexander V Zubchenko wrote: Greetings! On Tue, 11 Jun 2002, Leo De Geer wrote: but in my case its not good to have it that way im having one dedikated dual server for the sql and now im yust using one cpu for the sql questions. i nead it to start sub conections to the sql to serv all my conections good. In such case provide, please additional info. AFAIU, You want to use both cpu for sql, in other words, optimal use of Your server. Than, do You recompile (or compile) kernel with SMP support (afaik, this is only arch for multicpu systems, supported by fbsd)? You can b sure, that if mysql will run separate process for each request, it will slowdown perfomance, but never increase it. In fact, balancing load on many cpus is OS task. And multithreaded processes _must_ b processed similarly to multiprocess environment (but i don't know, how exactly fbsd smp-support built). Check Your kernel config /usr/src/sys/i386/conf/name. You may find also this name interesting: LINT - list [almost?] all options recognized in config-file. With respect, Alexander V Zubchenko, E-Mail: [EMAIL PROTECTED] System Administrator, WWW: http://www.hermes-comp.zp.ua/ Hermes-comp, Ukraine, Zaporizhzhya, Geroev Stalingrada 50 phone/fax: +380 612 64-19-72 the kernel is runing both cpu. and the balancing is working good on everything but the sql! i have on my linux sql server aproximatly 100 simultanius conections that du you think that the standard memory size of 128 do you think i nead to put it up to 256 meg in the kernel the problen nr 2 i dont have but the server we have dont handle the load on one cpu. at the moment we are runing the sql on a linux instead (same hardwere) but i sucks. alla auter servers is freebsd and they run mutch beter regards leo -- MVH C. Leo De Geer www.dinsignal.com www.ktv.se www.teknikshoppen.nu - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: problem with mysql threads on freebsd
Hello Leo De Geer [EMAIL PROTECTED], the problen nr 2 i dont have but the server we have dont handle the load on one cpu. at the moment we are runing the sql on a linux instead (same hardwere) but i sucks. alla auter servers is freebsd and they run mutch beter Why MySQL on Linux sucks? Can you give any concret examples? -- Patrick Hsieh [EMAIL PROTECTED] GPG public key http://pahud.net/pubkeys/pahudatpahud.gpg - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: problem with mysql threads on freebsd
On Tuesday 11 June 2002 16.30, Dan Nelson wrote: In the last episode (Jun 11), Leo De Geer said: im not abel to get mysql to use more then one thread on my freebsd 4.5-stable any one having a klue that wrong? Do not assume that the way Linux manages threads is the only one. Mysql on FreeBSD does create threads; they are just not visible via top (in fact Linux is the only OS that shows threads in top). FreeBSD's threads system, however will not put those threads on multiple CPUs. You can work around this by building the mysql port with LinuxThreads: cd /usr/ports/databases/mysql323-server make WITH_LINUXTHREADS=yes This is only useful if your system is dedicated to mysql, though. If it is a combination webserver/database, the other CPU will be busy enough serving webpages, and FreeBSD's regular threads will do fine. thanks that is the thing i have looking for. regards leo -- MVH C. Leo De Geer www.dinsignal.com www.ktv.se www.teknikshoppen.nu - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php