Re: INNODB and Max Processors

2009-01-30 Thread Baron Schwartz
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 rea

INNODB and Max Processors

2009-01-30 Thread Gary W. Smith
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 du