Re[2]: Multiple CPU's in Freebsd
Hello Matthew, Thursday, June 14, 2001, 12:18:08 AM, you wrote: MR Try this: update your ports, then build the mysql port with MR WITH_LINUXTHREADS=1. This should result in a FreeBSD native binary MR linked against linuxthreads instead of libc_r, so it should use multiple MR processors. Hm.. I have dual PIII platform with FreeBSD 4.3-R And want to mysqld have worked on both cpu's. I recompile mysql-server port with WITH_LINUXTHREADS=1, and notice every thread in its own process. All was fine... But next morning I've noticed all PHP applications using MySQL roaming some about 'too many connections' mysqladmin processlist shown a great number of working threads with great live time. Starting the 'top' I've noticed that all mysqld processes was swapped out from memory !!! Nothing worked. 8-E So, I've return to the latest binary... ;( Is there any solve for this problem ? * Ìîé àäðåñ - íå äîì è íå yëèöà, ìîé àäðåñ [EMAIL PROTECTED] -- Best Regards Strange Alex - 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: Multiple CPU's in Freebsd
Rafael Martinez writes: Hello First of all, thank you to everybody who came with good suggestions and fixes. I have the 4xCpu machine with freebsd and mysql using all of then, and it looks pretty good :-) (we'll see when I finish testing it ;-) ). One idea will be to put this information in the Mysql-manual so anybody who ones to install/compile from source in freebsd can do it without the problems we have had. Sincerely rafael Martinez We have known about LinuxThreads option on FreeBSD, but it was not stable for quite some time. When it becomes feasible to build MySQL on the off-shelf FreeBSD, we shall come up with configure that will automatically use it. Meanwhile, yes, we shall inlude a necessary info in our manual. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - 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: Multiple CPU's in Freebsd
Hi! What is the version of FreeBSD that makes this possible ?? -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - 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: Multiple CPU's in Freebsd
Hi Sinisa, Since matt hasn't responded yet, I'll let you know, its not the version of FreeBSD, but the ports collection. The ports collections does not have a version number, people should just fetch latest (using cvsup) however you can fetch by date. A package in the ports collection may require a particulur version of soemthing else (ie OS or Library) but when the package is built it will check and update or error as necessary. I can give you more details if you want Sinisa. Ken - Original Message - From: Sinisa Milivojevic [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, June 14, 2001 7:11 AM Subject: Re: Multiple CPU's in Freebsd Hi! What is the version of FreeBSD that makes this possible ?? -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - 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: Multiple CPU's in Freebsd
Ken Menzel writes: Hi Sinisa, Since matt hasn't responded yet, I'll let you know, its not the version of FreeBSD, but the ports collection. The ports collections does not have a version number, people should just fetch latest (using cvsup) however you can fetch by date. A package in the ports collection may require a particulur version of soemthing else (ie OS or Library) but when the package is built it will check and update or error as necessary. I can give you more details if you want Sinisa. Ken Thanks for the info Ken. The info that you have provided is truly sufficient. We shall try to change building process of MySQL for FreeBSD as soon as it becomes feasible. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - 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: Multiple CPU's in Freebsd
---Reply to mail from Sinisa Milivojevic about Multiple CPU's in Freebsd Ken Menzel writes: Hi Sinisa, Since matt hasn't responded yet, I'll let you know, its not the version of FreeBSD, but the ports collection. The ports collections does not have a version number, people should just fetch latest (using cvsup) however you can fetch by date. A package in the ports collection may require a particulur version of soemthing else (ie OS or Library) but when the package is built it will check and update or error as necessary. I can give you more details if you want Sinisa. Ken Thanks for the info Ken. The info that you have provided is truly sufficient. We shall try to change building process of MySQL for FreeBSD as soon as it becomes feasible. Hello First of all, thank you to everybody who came with good suggestions and fixes. I have the 4xCpu machine with freebsd and mysql using all of then, and it looks pretty good :-) (we'll see when I finish testing it ;-) ). One idea will be to put this information in the Mysql-manual so anybody who ones to install/compile from source in freebsd can do it without the problems we have had. Sincerely rafael Martinez - 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: Multiple CPU's in Freebsd
Try this: update your ports, then build the mysql port with WITH_LINUXTHREADS=1. This should result in a FreeBSD native binary linked against linuxthreads instead of libc_r, so it should use multiple processors. Matt Ken Menzel wrote: Hi Rafael, This is not an easy task, there are really only two ways to accomplish this. But first I must ask if you have check how much CPU % is currently in use? Is consistently high? The other cpus's will be used to runs things such as Apache, but mysql will run on one processor. Or, you could start several mysqld processes, each listening to a different port or IP address. To use different IP addresses one would have to enable multiple virtual IP's for that machine. I understand there are some big threads improvements coming for FreeBSD, but I am not sure when they are coming. If you use multiple ports, your application will have to select the port to connect to (such as 3306, 3307, 3308, 3309) or if you use multiple IP addresses then you can use DNS round Robin technique with multiple A records for a single name. Sorry there is currently no easy answer. Ken (also a FreeBSD multi CPU user). - Original Message - From: Rafael Martinez [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, June 12, 2001 10:52 AM Subject: Re: Multiple CPU's in Freebsd ---Reply to mail from Sinisa Milivojevic about Multiple CPU's [EMAIL PROTECTED] writes: Hi, Can anyone help me out! Does MySQL run efficently in a multi CPU environment. [..] MySQL supports as many CPU as you might have, but FreeBSD threads do not support SMP, so MySQL can not use them. I am trying to run mysql in freebsd 4.3 in a 4xCpu machine. And as you say mysql only use 1 of them. Is it possible in any way to use all the cpus in this machine with mysql? I thougt I was doing something wrong or that I had to patch some libraries but after your answer I am starting to panic. What about MIT-threads? I can not install Linux in this machine (scsi + raid card not stable), that is the reason because I am using freebsd and I need to get this machine in production as soon as possible. Any ideas, suggestions, tips, help are welcome. Sincerely Rafael Martinez - 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 - 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: Multiple CPU's in Freebsd
Hi Matt, I am trying it now! Thanks! Seems to work, I am running it on one of the QA servers now and I see it spawning many mysql processes! Very cool! BTW to anyone usings ports after a source install use DB_DIR=/usr/local/var you will get an error at the end of make install, but it's OK! When did this get in! Ken - Original Message - From: Matthew Reimer [EMAIL PROTECTED] To: Ken Menzel [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, June 13, 2001 1:18 PM Subject: Re: Multiple CPU's in Freebsd Try this: update your ports, then build the mysql port with WITH_LINUXTHREADS=1. This should result in a FreeBSD native binary linked against linuxthreads instead of libc_r, so it should use multiple processors. Matt Ken Menzel wrote: Hi Rafael, This is not an easy task, there are really only two ways to accomplish this. But first I must ask if you have check how much CPU % is currently in use? Is consistently high? The other cpus's will be used to runs things such as Apache, but mysql will run on one processor. Or, you could start several mysqld processes, each listening to a different port or IP address. To use different IP addresses one would have to enable multiple virtual IP's for that machine. I understand there are some big threads improvements coming for FreeBSD, but I am not sure when they are coming. If you use multiple ports, your application will have to select the port to connect to (such as 3306, 3307, 3308, 3309) or if you use multiple IP addresses then you can use DNS round Robin technique with multiple A records for a single name. Sorry there is currently no easy answer. Ken (also a FreeBSD multi CPU user). - Original Message - From: Rafael Martinez [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, June 12, 2001 10:52 AM Subject: Re: Multiple CPU's in Freebsd ---Reply to mail from Sinisa Milivojevic about Multiple CPU's [EMAIL PROTECTED] writes: Hi, Can anyone help me out! Does MySQL run efficently in a multi CPU environment. [..] MySQL supports as many CPU as you might have, but FreeBSD threads do not support SMP, so MySQL can not use them. I am trying to run mysql in freebsd 4.3 in a 4xCpu machine. And as you say mysql only use 1 of them. Is it possible in any way to use all the cpus in this machine with mysql? I thougt I was doing something wrong or that I had to patch some libraries but after your answer I am starting to panic. What about MIT-threads? I can not install Linux in this machine (scsi + raid card not stable), that is the reason because I am using freebsd and I need to get this machine in production as soon as possible. Any ideas, suggestions, tips, help are welcome. Sincerely Rafael Martinez - 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 - 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: Multiple CPU's in Freebsd
It went in Wed May 23 20:26:06 2001 UTC. http://www.freebsd.org/cgi/cvsweb.cgi/ports/databases/mysql323-server/Makefile.diff?r1=1.114r2=1.115 Matt Ken Menzel wrote: Hi Matt, I am trying it now! Thanks! Seems to work, I am running it on one of the QA servers now and I see it spawning many mysql processes! Very cool! BTW to anyone usings ports after a source install use DB_DIR=/usr/local/var you will get an error at the end of make install, but it's OK! When did this get in! Ken - Original Message - From: Matthew Reimer [EMAIL PROTECTED] To: Ken Menzel [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, June 13, 2001 1:18 PM Subject: Re: Multiple CPU's in Freebsd Try this: update your ports, then build the mysql port with WITH_LINUXTHREADS=1. This should result in a FreeBSD native binary linked against linuxthreads instead of libc_r, so it should use multiple processors. Matt Ken Menzel wrote: Hi Rafael, This is not an easy task, there are really only two ways to accomplish this. But first I must ask if you have check how much CPU % is currently in use? Is consistently high? The other cpus's will be used to runs things such as Apache, but mysql will run on one processor. Or, you could start several mysqld processes, each listening to a different port or IP address. To use different IP addresses one would have to enable multiple virtual IP's for that machine. I understand there are some big threads improvements coming for FreeBSD, but I am not sure when they are coming. If you use multiple ports, your application will have to select the port to connect to (such as 3306, 3307, 3308, 3309) or if you use multiple IP addresses then you can use DNS round Robin technique with multiple A records for a single name. Sorry there is currently no easy answer. Ken (also a FreeBSD multi CPU user). - Original Message - From: Rafael Martinez [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, June 12, 2001 10:52 AM Subject: Re: Multiple CPU's in Freebsd ---Reply to mail from Sinisa Milivojevic about Multiple CPU's [EMAIL PROTECTED] writes: Hi, Can anyone help me out! Does MySQL run efficently in a multi CPU environment. [..] MySQL supports as many CPU as you might have, but FreeBSD threads do not support SMP, so MySQL can not use them. I am trying to run mysql in freebsd 4.3 in a 4xCpu machine. And as you say mysql only use 1 of them. Is it possible in any way to use all the cpus in this machine with mysql? I thougt I was doing something wrong or that I had to patch some libraries but after your answer I am starting to panic. What about MIT-threads? I can not install Linux in this machine (scsi + raid card not stable), that is the reason because I am using freebsd and I need to get this machine in production as soon as possible. Any ideas, suggestions, tips, help are welcome. Sincerely Rafael Martinez - 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 - 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: Multiple CPU's in Freebsd
On Wed, Jun 13, 2001 at 03:19:30PM -0400, Ken Menzel wrote: Hi Matt, I am trying it now! Thanks! Seems to work, I am running it on one of the QA servers now and I see it spawning many mysql processes! Very cool! BTW to anyone usings ports after a source install use DB_DIR=/usr/local/var you will get an error at the end of make install, but it's OK! When did this get in! Ken, I'd love to hear what your expierince is after running it for a bit. It may solve a long-standing problem we've seen with MySQL on FreeBSD. Thanks! Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951 MySQL 3.23.29: up 19 days, processed 130,418,698 queries (78/sec. avg) - 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: Multiple CPU's in Freebsd
---Reply to mail from Sinisa Milivojevic about Multiple CPU's [EMAIL PROTECTED] writes: Hi, Can anyone help me out! Does MySQL run efficently in a multi CPU environment. [..] MySQL supports as many CPU as you might have, but FreeBSD threads do not support SMP, so MySQL can not use them. I am trying to run mysql in freebsd 4.3 in a 4xCpu machine. And as you say mysql only use 1 of them. Is it possible in any way to use all the cpus in this machine with mysql? I thougt I was doing something wrong or that I had to patch some libraries but after your answer I am starting to panic. What about MIT-threads? I can not install Linux in this machine (scsi + raid card not stable), that is the reason because I am using freebsd and I need to get this machine in production as soon as possible. Any ideas, suggestions, tips, help are welcome. Sincerely Rafael Martinez - 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