RE: best-performing CPU + platform for MySQL now? Opteron? OpenBSD? SuSE?

[Donny Simonton]

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:Jeremy@stripped]
> Sent: Tuesday, September 14, 2004 2:11 PM
> To: Miles Keaton
> Cc: mysql@stripped
> 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!
> <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=1
>