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 <g...@primeexalia.com> 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
