Gary,
I need to know a lot about your workload to say whether it will work
well on InnoDB with 4+ processors. You can check
http://www.mysqlperformanceblog.com/ for a lot of benchmarks in this
area. But in general, my opinion is that for most workloads, 4 total
processors (cores included) is reasonable. Not as good as it could
be, but reasonable.
The only real answer is to benchmark *your* workload and see what
happens. And if you run into something that's a weak area, change it
-- there are workarounds for many of the trouble spots.
However, note that a single query will only ever run on a single core,
so if latency is your concern, you need fast, not many.
Baron
On Fri, Jan 30, 2009 at 12:32 PM, Gary W. Smith wrote:
> A few weeks back I was reading an article that said that INNODB doesn't take
> adantage of servers using more than 4 processors. I think I also recieved
> this as a reply some time ago as to the same thing.
>
> I was wondering if this is indeed true. We are using 5.1.30 and wanted to
> pickup a new dual quad core with 32GB. Before we make the purchase we just
> want to make sure the database will be able to take advantage of it.
> Otherwise we will go for the dual core higher speed.
>
> This will support hundreds of connections per second and some complicated
> queries. Overall the data will be less than 50gb so we are looking at more
> ram to hope that it will support both application and os level caching.
>
> Any advice would be greatly appreciated.
>
> Gary
>
--
Baron Schwartz, Director of Consulting, Percona Inc.
Our Blog: http://www.mysqlperformanceblog.com/
Our Services: http://www.percona.com/services.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org