Re: What's the best os?
On Sat, Jun 02, 2001 at 01:49:59PM +0400, Ilya Martynov wrote: 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. JZ Funny you mention that... It comes up once in a while, but almost JZ everytime it's someone saying I've heard that you can... I've yet to JZ meet someone who does it and likes it. JZ I'm not saying it's bad, but it just seems like one of those things JZ that people suggest but don't actually have experience with. Ok. I did not compile MySQL with LinuxThreads on FreeBSD myself. I have no idea how to do it because I never tried to do it. But I do know that production server owned by company at which I work do run MySQL with LinuxThreads on FreeBSD. After switch on MySQL with LinuxThreads it was possible to see that perfomance was increased. Output of 'show proceslist' shows that MySQL server is much less loaded (because it handles requests faster) than before. Also people who tested it on test server before deploying on production said that it worked faster. This is real experience. Good to hear. I've heard similar reports from others. I'm going to have to find the time to try this myself. 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 17 days, processed 133,432,323 queries (86/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: 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
Re: What's the best os?
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. JZ Funny you mention that... It comes up once in a while, but almost JZ everytime it's someone saying I've heard that you can... I've yet to JZ meet someone who does it and likes it. JZ I'm not saying it's bad, but it just seems like one of those things JZ that people suggest but don't actually have experience with. Ok. I did not compile MySQL with LinuxThreads on FreeBSD myself. I have no idea how to do it because I never tried to do it. But I do know that production server owned by company at which I work do run MySQL with LinuxThreads on FreeBSD. After switch on MySQL with LinuxThreads it was possible to see that perfomance was increased. Output of 'show proceslist' shows that MySQL server is much less loaded (because it handles requests faster) than before. Also people who tested it on test server before deploying on production said that it worked faster. This is real experience. -- -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- | Ilya Martynov (http://martynov.org/)| | GnuPG 1024D/323BDEE6 D7F7 561E 4C1D 8A15 8E80 E4AE BE1A 53EB 323B DEE6 | | AGAVA Software Company (http://www.agava.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: What's the best os?
JZ On Fri, Jun 01, 2001 at 01:45:24AM -0400, David Freeman wrote: The server is a quad xeon lh4, it will host a web site written in php, and using a mysql database which holds 125,000 squ's and descriptions. The server's only job is to host this site. 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. -- -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- | Ilya Martynov (http://martynov.org/)| | GnuPG 1024D/323BDEE6 D7F7 561E 4C1D 8A15 8E80 E4AE BE1A 53EB 323B DEE6 | | AGAVA Software Company (http://www.agava.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: What's the best os?
On 01 Jun 2001 00:30:20 -0400, David Freeman wrote: My question is, what is the best OS for a heavy usage, multi-processor mysql database driven web site. We could use almost anything, but we would prefer to use a free OS such as freebsd or Linux based OS. Some people reported better performance for MySQL on Linux than on Solaris, using the same hardware (Sparc). While i don't think there's much difference between Linux and FreeBSD, i would expect Linux-2.4 to handle SMP and threads a little bit better than FreeBSD. But this is close to religious war... I would reccomend Linux with kernel 2.4. You should use a journalised filesystem, of course. Now, while ReiserFS does better when it comes to handling lots of small files, XFS is better at ensuring high I/O rates, especially for simultaneous access to large files in heavy-loaded SMP environments, because that's what it was designed for. So, it's better suited for databases, such as MySQL. XFS-1.0 is already available for Linux (kernel 2.4), and it's fully stable. You can download it from here: http://oss.sgi.com/projects/xfs/ Or, if you prefer, get an ISO image containing a modified Red Hat 7.1 kit, able to install itself directly on XFS, from here: http://oss.sgi.com/projects/xfs/1.0_installer.html -- Florin Andrei - 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?
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. 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 7 days, processed 46,316,122 queries (73/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: What's the best os?
On Fri, Jun 01, 2001 at 03:50:30PM -0700, Florin Andrei wrote: On 01 Jun 2001 00:30:20 -0400, David Freeman wrote: My question is, what is the best OS for a heavy usage, multi-processor mysql database driven web site. We could use almost anything, but we would prefer to use a free OS such as freebsd or Linux based OS. Some people reported better performance for MySQL on Linux than on Solaris, using the same hardware (Sparc). While i don't think there's much difference between Linux and FreeBSD, i would expect Linux-2.4 to handle SMP and threads a little bit better than FreeBSD. But this is close to religious war... Actually, it has little to do with religion and lots to do with fact. I work in what's almost completely a FreeBSD shop. We have core FreeBSD developers on staff. But we still use Linux for our SMP MySQL servers. When FreeBSD catches up, I'll glady switch [back] to it. :-) 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 7 days, processed 46,319,862 queries (73/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
What's the best os?
Hi group, I am putting together a new web server to serve our new web site. We expect a-lot of traffic on this site, so we have purchased a HP LH4 quad xeon 550 2mb cache server. The site will use the mysql database to hold about 125,000 squ's with descriptions, and notes for each squ. The web surfers will be searching through the database frequently. My question is, what is the best OS for a heavy usage, multi-processor mysql database driven web site. We could use almost anything, but we would prefer to use a free OS such as freebsd or Linux based OS. Any input would be greatly appreciated!! David Freeman www.prioritycomputers.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: What's the best os?
On Fri, Jun 01, 2001 at 12:30:20AM -0400, David Freeman wrote: I am putting together a new web server to serve our new web site. We expect a-lot of traffic on this site, so we have purchased a HP LH4 quad xeon 550 2mb cache server. The site will use the mysql database to hold about 125,000 squ's with descriptions, and notes for each squ. The web surfers will be searching through the database frequently. My question is, what is the best OS for a heavy usage, multi-processor mysql database driven web site. We could use almost anything, but we would prefer to use a free OS such as freebsd or Linux based OS. This is treading dangerously close to religious war.. I would wager that the performance difference between a Linux install and a FreeBSD install would be so small that it would be more valuable to make the decision based on a different criteria. Perhaps instead of performance, you can weigh whether it on which platform your developers are most comfortable with, or have the most experience in.. There are exceptions of course, such as one OS having better drivers for your hardware than another, but generally, it's hard to place one as being better than the other when the choices are FreeBSD or Linux. Linux vs say, Solaris on the other hand is much different. Especially where MySQL or Apache are concerned. [Solaris being the bad choice on that hardware] -- Michael Bacarella [EMAIL PROTECTED] Technical Staff / System Development, New York Connect.Net, Ltd. - 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?
On Fri, Jun 01, 2001 at 12:30:20AM -0400, David Freeman wrote: I am putting together a new web server to serve our new web site. We expect a-lot of traffic on this site, so we have purchased a HP LH4 quad xeon 550 2mb cache server. The site will use the mysql database to hold about 125,000 squ's with descriptions, and notes for each squ. The web surfers will be searching through the database frequently. My question is, what is the best OS for a heavy usage, multi-processor mysql database driven web site. We could use almost anything, but we would prefer to use a free OS such as freebsd or Linux based OS. Since you mentioned multi-processor, I'd recommend Linux (2.4 with ReiserFS) or Solaris. FreeBSD won't let you take full advantage of both CPUs the way other OSes will. One thing that's not entirely clear, though, is whether your server is a database server only. Or do you plan on running Apache on it as well? If it's not a dedicated DB server, the multi-processor issue will become less important. 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 6 days, processed 41,280,444 queries (73/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: What's the best os?
The server is a quad xeon lh4, it will host a web site written in php, and using a mysql database which holds 125,000 squ's and descriptions. The server's only job is to host this site. Thanks for the responce. dave freeman -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Sent: Friday, June 01, 2001 1:42 AM To: David Freeman Cc: [EMAIL PROTECTED] Subject: Re: What's the best os? On Fri, Jun 01, 2001 at 12:30:20AM -0400, David Freeman wrote: I am putting together a new web server to serve our new web site. We expect a-lot of traffic on this site, so we have purchased a HP LH4 quad xeon 550 2mb cache server. The site will use the mysql database to hold about 125,000 squ's with descriptions, and notes for each squ. The web surfers will be searching through the database frequently. My question is, what is the best OS for a heavy usage, multi-processor mysql database driven web site. We could use almost anything, but we would prefer to use a free OS such as freebsd or Linux based OS. Since you mentioned multi-processor, I'd recommend Linux (2.4 with ReiserFS) or Solaris. FreeBSD won't let you take full advantage of both CPUs the way other OSes will. One thing that's not entirely clear, though, is whether your server is a database server only. Or do you plan on running Apache on it as well? If it's not a dedicated DB server, the multi-processor issue will become less important. 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 6 days, processed 41,280,444 queries (73/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: What's the best os?
On Fri, Jun 01, 2001 at 01:45:24AM -0400, David Freeman wrote: The server is a quad xeon lh4, it will host a web site written in php, and using a mysql database which holds 125,000 squ's and descriptions. The server's only job is to host this site. Assuming you'll use Apache 2.x one day, I'd lean away from FreeBSD until the threading issues are resolved. I could envision you running 1 threaded MySQL server and 1 threaded Apache server. Under FreeBSD (today), you'd have 2 idle CPUs and 2 busy CPUs because it'd never spread the threads from each server across the CPUs the way you'd like. Linux or Solaris should handle it quite well, though. Hope that helps, 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 6 days, processed 41,316,177 queries (73/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