From: Date: September 15 2004 12:37am
Subject: RE: best-performing CPU + platform for MySQL now? Opteron? OpenBSD? SuSE?
List-Archive: http://lists.mysql.com/mysql/172618
Message-Id: <002001c49aab$74f1df30$e800fe0a@DBA>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

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:donny@stripped]
> Sent: Tuesday, September 14, 2004 2:15 PM
> To: 'Brian Abbott'; mysql@stripped
> Cc: 'Miles Keaton'
> Subject: RE: best-performing CPU + platform for MySQL now? Opteron?
> OpenBSD? SuSE?
>=20
> MySQL released this a few weeks ago.
>=20
> =
http://www.mysql.com/news-and-events/press-release/release_2004_27.html
>=20
> 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.
>=20
> Donny
>=20
> > -----Original Message-----
> > From: Brian Abbott [mailto:brian.abbott@stripped]
> > Sent: Tuesday, September 14, 2004 4:32 PM
> > To: mysql@stripped; '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:Jeremy@stripped]
> > Sent: Tuesday, September 14, 2004 2:21 PM
> > To: Donny Simonton
> > Cc: mysql@stripped; '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!
> > <Jeremy@stripped>  |  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/mysql?unsub=3Dbrian.abbott@stripped
> >
>=20
>=20
>=20
>=20
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=3Ddathan@stripped