Re: best-performing CPU + platform for MySQL now? Opteron? OpenBSD? SuSE?
Thank you for valuable feedback! -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: best-performing CPU + platform for MySQL now? Opteron? OpenBSD? SuSE?
At 02:04 AM 9/24/2004, Egor Egorov wrote: Jeremy Zawodny <[EMAIL PROTECTED]> wrote: >> > And we've had good but limited experiences so far with 64 bit FreeBSD >> > 5 on amd64 (also a quad w/32GB). >> >> Somewhere in this list I've seen controversial reports about FreeBSD/amd64. >> Seems like it's not yet stable and may give unpredictable performance >> behaviour, no? >> >> What's your opinion? > > Agreed. FreeBSD's production release is 4.10. The 5.x tree is still > a work in progress, much like MySQL 4.1. We are speaking of AMD64 port, are we? I might as well put in my 2 cents here since myself and several others did many MANY MySQL benchmarks with AMD64 hardware and various FreeBSD and Linux OS installs and configurations. Bottom line? As of about 2-3 months ago or so mandrake64 "out of the box" (free ISO install) beat any and all flavors of FreeBSD nearly 2 to 1 (twice as many queries per second). Another person I was talking with was using the Debian64 beta and getting similar results (on basically identical hardware). Before people start screaming "troll! troll!" and saying how we must have tested wrong, or unfairly, or this way or that way... it should be known that there are probably almost 100 messages on the subject with us, others, and people on the FreeBSD development team bouncing ideas back and forth as to why the results were so poor vs what we were getting in Linux. There was no end-user solution provided in the end. Before you start flaming please catch up first. There are threads on the subject in: freebsd-amd64 freebsd-threads freebsd-kernel It starts here... http://lists.freebsd.org/pipermail/freebsd-amd64/2004-May/001247.html But people top posted a lot and broke up the archive. So click "thread" and scroll down so you can see the rest of the posts. The discussions weren't limited to that mailing list though. I think that just might have been the first list they were posted to before it was suggested to be a problem for the -threads list, thren -kernel, then -threads again. At that point I had ran out of time. I love FreeBSD myself... so having to use Linux to get this kind of performance out of the MySQL server kind of sucks for us as well. Maybe the FreeBSD team has made improvements where the performance was lacking since those discussions. I'll be doing benchmarks again in a couple weeks to find out. - JG -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: best-performing CPU + platform for MySQL now? Opteron? OpenBSD? SuSE?
Jeremy Zawodny <[EMAIL PROTECTED]> wrote: >> > And we've had good but limited experiences so far with 64 bit FreeBSD >> > 5 on amd64 (also a quad w/32GB). >> >> Somewhere in this list I've seen controversial reports about FreeBSD/amd64. >> Seems like it's not yet stable and may give unpredictable performance >> behaviour, no? >> >> What's your opinion? > > Agreed. FreeBSD's production release is 4.10. The 5.x tree is still > a work in progress, much like MySQL 4.1. We are speaking of AMD64 port, are we? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: best-performing CPU + platform for MySQL now? Opteron? OpenBSD? SuSE?
On Fri, Sep 17, 2004 at 04:01:53PM +0300, Egor Egorov wrote: > Jeremy Zawodny <[EMAIL PROTECTED]> wrote: > > >> I can verify that a quad opteron 2.2 runs about a million times > >> better than a quad xeon 3.06. The opteron can handle more than 3 > >> gigs of memory which is a 32 bit limitation. Right now in my quad > >> opteron we have 32 gigs of memory and MySQL is using 16.8 gigs of > >> the memory. > >> > >> We run fedora core 2, with the rpm built by MySQL. We don't run anything > >> else any longer. > > > > And we've had good but limited experiences so far with 64 bit FreeBSD > > 5 on amd64 (also a quad w/32GB). > > Somewhere in this list I've seen controversial reports about FreeBSD/amd64. > Seems like it's not yet stable and may give unpredictable performance > behaviour, no? > > What's your opinion? Agreed. FreeBSD's production release is 4.10. The 5.x tree is still a work in progress, much like MySQL 4.1. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ [book] High Performance MySQL -- http://highperformancemysql.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: best-performing CPU + platform for MySQL now? Opteron? OpenBSD? SuSE?
Jeremy Zawodny <[EMAIL PROTECTED]> wrote: >> I can verify that a quad opteron 2.2 runs about a million times >> better than a quad xeon 3.06. The opteron can handle more than 3 >> gigs of memory which is a 32 bit limitation. Right now in my quad >> opteron we have 32 gigs of memory and MySQL is using 16.8 gigs of >> the memory. >> >> We run fedora core 2, with the rpm built by MySQL. We don't run anything >> else any longer. > > And we've had good but limited experiences so far with 64 bit FreeBSD > 5 on amd64 (also a quad w/32GB). Somewhere in this list I've seen controversial reports about FreeBSD/amd64. Seems like it's not yet stable and may give unpredictable performance behaviour, no? What's your opinion? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: best-performing CPU + platform for MySQL now? Opteron? OpenBSD? SuSE?
"Dathan Vance Pattishall" <[EMAIL PROTECTED]> wrote: > I get permission from my bosses to release the benchmarks I will send it = > to the list. Please! This definitely will be a valuable information for the community. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: best-performing CPU + platform for MySQL now? Opteron? OpenBSD? SuSE?
Friendster has for lack of better words HAVE A LOT of Opterons. In fact we have become experts with configuring what would be best with mySQL + Linux + opterons. I have a ton of benchmarks for various kernels and configs on local disk and or SAN configs. Just to give you some really basic stats we do more then 1 billion queries per day on less servers then Live Journal (source from mySQL conference). If I get permission from my bosses to release the benchmarks I will send it to the list. DVP Dathan Vance Pattishall http://www.friendster.com > -Original Message- > From: Donny Simonton [mailto:[EMAIL PROTECTED] > Sent: Tuesday, September 14, 2004 2:15 PM > To: 'Brian Abbott'; [EMAIL PROTECTED] > Cc: 'Miles Keaton' > Subject: RE: best-performing CPU + platform for MySQL now? Opteron? > OpenBSD? SuSE? > > MySQL released this a few weeks ago. > > http://www.mysql.com/news-and-events/press-release/release_2004_27.html > > As far as personal benchmarks, it's fast. Real fast. With a quad Xeon > (which was more expensive than the quad opteron) our master server had a > normal load of 2-3. With the the quad opteron it's less than .25. > > Donny > > > -Original Message- > > From: Brian Abbott [mailto:[EMAIL PROTECTED] > > Sent: Tuesday, September 14, 2004 4:32 PM > > To: [EMAIL PROTECTED]; 'Donny Simonton' > > Cc: 'Miles Keaton' > > Subject: RE: best-performing CPU + platform for MySQL now? Opteron? > > OpenBSD? SuSE? > > > > Do you guys have metrics on this that you would be willing to share? We > > are looking at upgrading to the Opteron (from the Xeon) at the moment. > > Any information would be very helpful. > > > > Brian Abbott > > > > -Original Message- > > From: Jeremy Zawodny [mailto:[EMAIL PROTECTED] > > Sent: Tuesday, September 14, 2004 2:21 PM > > To: Donny Simonton > > Cc: [EMAIL PROTECTED]; 'Miles Keaton' > > Subject: Re: best-performing CPU + platform for MySQL now? Opteron? > > OpenBSD? SuSE? > > > > > > On Tue, Sep 14, 2004 at 03:05:07PM -0500, Donny Simonton wrote: > > > > > > I can verify that a quad opteron 2.2 runs about a million times better > > > > > than a quad xeon 3.06. The opteron can handle more than 3 gigs of > > > memory which is a 32 bit limitation. Right now in my quad opteron we > > > have 32 gigs of memory and MySQL is using 16.8 gigs of the memory. > > > > > > We run fedora core 2, with the rpm built by MySQL. We don't run > > > anything else any longer. > > > > And we've had good but limited experiences so far with 64 bit FreeBSD 5 > > on amd64 (also a quad w/32GB). > > > > Jeremy > > -- > > Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! > > <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ > > > > [book] High Performance MySQL -- http://highperformancemysql.com/ > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: best-performing CPU + platform for MySQL now? Opteron? OpenBSD? SuSE?
MySQL released this a few weeks ago. http://www.mysql.com/news-and-events/press-release/release_2004_27.html As far as personal benchmarks, it's fast. Real fast. With a quad Xeon (which was more expensive than the quad opteron) our master server had a normal load of 2-3. With the the quad opteron it's less than .25. Donny > -Original Message- > From: Brian Abbott [mailto:[EMAIL PROTECTED] > Sent: Tuesday, September 14, 2004 4:32 PM > To: [EMAIL PROTECTED]; 'Donny Simonton' > Cc: 'Miles Keaton' > Subject: RE: best-performing CPU + platform for MySQL now? Opteron? > OpenBSD? SuSE? > > Do you guys have metrics on this that you would be willing to share? We > are looking at upgrading to the Opteron (from the Xeon) at the moment. > Any information would be very helpful. > > Brian Abbott > > -Original Message- > From: Jeremy Zawodny [mailto:[EMAIL PROTECTED] > Sent: Tuesday, September 14, 2004 2:21 PM > To: Donny Simonton > Cc: [EMAIL PROTECTED]; 'Miles Keaton' > Subject: Re: best-performing CPU + platform for MySQL now? Opteron? > OpenBSD? SuSE? > > > On Tue, Sep 14, 2004 at 03:05:07PM -0500, Donny Simonton wrote: > > > > I can verify that a quad opteron 2.2 runs about a million times better > > > than a quad xeon 3.06. The opteron can handle more than 3 gigs of > > memory which is a 32 bit limitation. Right now in my quad opteron we > > have 32 gigs of memory and MySQL is using 16.8 gigs of the memory. > > > > We run fedora core 2, with the rpm built by MySQL. We don't run > > anything else any longer. > > And we've had good but limited experiences so far with 64 bit FreeBSD 5 > on amd64 (also a quad w/32GB). > > Jeremy > -- > Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! > <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ > > [book] High Performance MySQL -- http://highperformancemysql.com/ > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: best-performing CPU + platform for MySQL now? Opteron? OpenBSD? SuSE?
On Tue, Sep 14, 2004 at 02:31:54PM -0700, Brian Abbott wrote: > Do you guys have metrics on this that you would be willing to share? We > are looking at upgrading to the Opteron (from the Xeon) at the moment. > Any information would be very helpful. I don't have any yet but should in a week or two. I just haven't run any benchmarks... -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ [book] High Performance MySQL -- http://highperformancemysql.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: best-performing CPU + platform for MySQL now? Opteron? OpenBSD? SuSE?
Also, out of curiosity, who was your vendor for the opteron? Brian -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 14, 2004 2:21 PM To: Donny Simonton Cc: [EMAIL PROTECTED]; 'Miles Keaton' Subject: Re: best-performing CPU + platform for MySQL now? Opteron? OpenBSD? SuSE? On Tue, Sep 14, 2004 at 03:05:07PM -0500, Donny Simonton wrote: > > I can verify that a quad opteron 2.2 runs about a million times better > than a quad xeon 3.06. The opteron can handle more than 3 gigs of > memory which is a 32 bit limitation. Right now in my quad opteron we > have 32 gigs of memory and MySQL is using 16.8 gigs of the memory. > > We run fedora core 2, with the rpm built by MySQL. We don't run > anything else any longer. And we've had good but limited experiences so far with 64 bit FreeBSD 5 on amd64 (also a quad w/32GB). Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ [book] High Performance MySQL -- http://highperformancemysql.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: best-performing CPU + platform for MySQL now? Opteron? OpenBSD? SuSE?
Do you guys have metrics on this that you would be willing to share? We are looking at upgrading to the Opteron (from the Xeon) at the moment. Any information would be very helpful. Brian Abbott -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 14, 2004 2:21 PM To: Donny Simonton Cc: [EMAIL PROTECTED]; 'Miles Keaton' Subject: Re: best-performing CPU + platform for MySQL now? Opteron? OpenBSD? SuSE? On Tue, Sep 14, 2004 at 03:05:07PM -0500, Donny Simonton wrote: > > I can verify that a quad opteron 2.2 runs about a million times better > than a quad xeon 3.06. The opteron can handle more than 3 gigs of > memory which is a 32 bit limitation. Right now in my quad opteron we > have 32 gigs of memory and MySQL is using 16.8 gigs of the memory. > > We run fedora core 2, with the rpm built by MySQL. We don't run > anything else any longer. And we've had good but limited experiences so far with 64 bit FreeBSD 5 on amd64 (also a quad w/32GB). Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ [book] High Performance MySQL -- http://highperformancemysql.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: best-performing CPU + platform for MySQL now? Opteron? OpenBSD? SuSE?
On Tue, Sep 14, 2004 at 03:05:07PM -0500, Donny Simonton wrote: > > I can verify that a quad opteron 2.2 runs about a million times > better than a quad xeon 3.06. The opteron can handle more than 3 > gigs of memory which is a 32 bit limitation. Right now in my quad > opteron we have 32 gigs of memory and MySQL is using 16.8 gigs of > the memory. > > We run fedora core 2, with the rpm built by MySQL. We don't run anything > else any longer. And we've had good but limited experiences so far with 64 bit FreeBSD 5 on amd64 (also a quad w/32GB). Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ [book] High Performance MySQL -- http://highperformancemysql.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: best-performing CPU + platform for MySQL now? Opteron? OpenBSD? SuSE?
I can verify that a quad opteron 2.2 runs about a million times better than a quad xeon 3.06. The opteron can handle more than 3 gigs of memory which is a 32 bit limitation. Right now in my quad opteron we have 32 gigs of memory and MySQL is using 16.8 gigs of the memory. We run fedora core 2, with the rpm built by MySQL. We don't run anything else any longer. Donny > -Original Message- > From: Jeremy Zawodny [mailto:[EMAIL PROTECTED] > Sent: Tuesday, September 14, 2004 2:11 PM > To: Miles Keaton > Cc: [EMAIL PROTECTED] > Subject: Re: best-performing CPU + platform for MySQL now? Opteron? > OpenBSD? SuSE? > > On Mon, Sep 06, 2004 at 12:48:37PM -0700, Miles Keaton wrote: > > If my company wants to get the best-performing fastest platform for a > > MySQL server, what would it be these days? Opteron? Dual? Quad? > > > > And on a related note... > > > > If a 64-bit CPU, then I'm assuming it would need an operating system > > designed for that 64-bit CPU, to get best performance, right? > > > > I know that OpenBSD has an amd64 version and that the OpenBSD > > developers seem to say that Opteron is their favorite (and > > most-currently-developed) CPU. I've used OpenBSD in the past and > > like it a lot. > > > > Is anyone here using MySQL on OpenBSD+Opteron in a high-load situation? > > MySQL works quite well on Opteron machines. > > However, OpenBSD is a poor platform choice for running MySQL. It's > known to run much better on FreeBSD or Linux (depending on your > particular preference). > > Jeremy > -- > Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! > <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ > > [book] High Performance MySQL -- http://highperformancemysql.com/ > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: best-performing CPU + platform for MySQL now? Opteron? OpenBSD? SuSE?
On Mon, Sep 06, 2004 at 12:48:37PM -0700, Miles Keaton wrote: > If my company wants to get the best-performing fastest platform for a > MySQL server, what would it be these days? Opteron? Dual? Quad? > > And on a related note... > > If a 64-bit CPU, then I'm assuming it would need an operating system > designed for that 64-bit CPU, to get best performance, right? > > I know that OpenBSD has an amd64 version and that the OpenBSD > developers seem to say that Opteron is their favorite (and > most-currently-developed) CPU. I've used OpenBSD in the past and > like it a lot. > > Is anyone here using MySQL on OpenBSD+Opteron in a high-load situation? MySQL works quite well on Opteron machines. However, OpenBSD is a poor platform choice for running MySQL. It's known to run much better on FreeBSD or Linux (depending on your particular preference). Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ [book] High Performance MySQL -- http://highperformancemysql.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]