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]
