MySQL isn't multi-process, it's single-process and multi-threaded.
A lot of work is going into making it scale better on SMP machines.
Much of this is to be released in future versions of MySQL. The
Drizzle developers are also doing a lot of good work, but that's in
Drizzle. Right now if you want a more scalable *current* version of
MySQL, you need to look to the Google patches, the Percona builds (and
Percona XtraDB, a fork of InnoDB), or OurDelta builds.
On Sat, Apr 11, 2009 at 9:27 AM, Andy Smith <a.smith@stripped> wrote:
> In what way can having more cores slow down MySQL (or any other app for
> that matter)? Are you simlpy referring to the fact that some mutlicore
> servers might be slower in single threaded preformance than a higher clocked
> single core system? If I have a mutlicore system with fast single threaded
> performance I wouldnt expect it to be slower in almost any cases with
> something like a mutliprocess database system,
> thanks Andy.
> Quoting mos <mos99@stripped>:
>> Using more cores with MySQL doesn't mean it will run faster. In fact, it
>> could slow it down. Make sure you have done benchmarking with your current
>> computer so you can compare the difference. InnoDb and MyISAM don't scale
>> well with multi-cores I'm afraid.
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1
Baron Schwartz, Director of Consulting, Percona Inc.
Our Blog: http://www.mysqlperformanceblog.com/
Our Services: http://www.percona.com/services.html