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
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: What's the best os?
Jeremy Zawodny wrote: On Fri, Jun 01, 2001 at 12:28:17PM +0400, Ilya Martynov wrote: JZ On Fri, Jun 01, 2001 at 01:45:24AM -0400, David Freeman wrote: JZ Assuming you'll use Apache 2.x one day, I'd lean away from FreeBSD JZ until the threading issues are resolved. I could envision you running JZ 1 threaded MySQL server and 1 threaded Apache server. Under FreeBSD JZ (today), you'd have 2 idle CPUs and 2 busy CPUs because it'd never JZ spread the threads from each server across the CPUs the way you'd JZ like. AFAIK you can compile mysql on FreeBSD with LinuxThreads (they have been ported on FreeBSD). In this case threads will spread across the CPUs as on Linux. Funny you mention that... It comes up once in a while, but almost everytime it's someone saying I've heard that you can... I've yet to meet someone who does it and likes it. I'm not saying it's bad, but it just seems like one of those things that people suggest but don't actually have experience with. I haven't tried this myself, but I noticed that a week or so ago linuxthreads support was added to the mysql323-server port, enabled by building WITH_LINUXTHREADS=1. Matt - 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