If you're using 4 or 8 cpus, I highly recommend considering Solaris 10.
It's free and it's true threading implementation and fine grained locking
increase scalability and even out cpu load on multi-cpu systems much better
than my RHEL 4 U2 (Linux 2.6) systems do. Their benchmarks back up my
experiences. I have 8 4-cpu and 2 8-cpu systems which are dedicated MySQL
systems. I am running Solaris 10 on the 8 cpu systems, and I am amazed at
how well the load balances, and how much faster it is. All of these systems
are Opteron dual core. Two of them (the 8 core systems) are Sun's V40z's,
the other systems are Supermicro Opterons.
Sun also has some awesome CoolThreads offerings (SPARC architecture), but I
haven't had a chance to benchmark one yet. With 32 concurrent threads on a
single 8 core 4 way threaded cpu, I'd like to see how MySQL's performance is
on those systems. Does anyone have any experience with or information about
CoolThreads systems running MySQL?
Even if you stick to amd64, I think for high end MySQL usage, Solaris 10 is
the way to go.
----- Original Message -----
From: "Scott Tanner" <[EMAIL PROTECTED]>
To: <mysql@lists.mysql.com>
Sent: Friday, August 11, 2006 12:53 PM
Subject: Re: More than 4 CPUs?
From the articles I've read recently, 8 CPU's seems to be the point
where the scalability ratio starts dropping. See the following articles
for examples:
http://developers.sun.com/solaris/articles/mysql_perf_tune.html
http://corporateclub.mandriva.com/xwiki/bin/download/Main/Technology/mysql-performance-whitepaper.pdf
I know there were some presentations at this years MySQL Conference that
went over this (MySQL Performance Landscape comes to mind). You might be
able to find a presentations on the mysql site.
Regards,
Scott Tanner
On Fri, 2006-08-11 at 14:44 -0400, Ed Pauley II wrote:
It seems like I once read that you don't get any performance gains in
MySQL when you go above 4 CPUs per server. Is this correct? I was
considering a 4 dual-core CPU machine. Should I go with a 2 dual-core
machine instead?
Thanks!
--
Ed Pauley II
--
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]
