List:General Discussion« Previous MessageNext Message »
From:Baron Schwartz Date:April 11 2009 2:58pm
Subject:Re: MySQL runs on 16-cores server
View as plain text  
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.

Baron

On Sat, Apr 11, 2009 at 9:27 AM, Andy Smith <a.smith@stripped> wrote:
> Hi,
>
>  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
Thread
MySQL runs on 16-cores serverMoon's Father10 Apr
  • Re: MySQL runs on 16-cores serverUwe Kiewel10 Apr
    • Re: MySQL runs on 16-cores serverWm Mussatto10 Apr
      • Re: MySQL runs on 16-cores serverAndrew Garner10 Apr
    • Re: MySQL runs on 16-cores serverMoon's Father11 Apr
      • Re: MySQL runs on 16-cores servermos11 Apr
      • Re: MySQL runs on 16-cores serverUwe Kiewel11 Apr
  • Re: MySQL runs on 16-cores servermos10 Apr
    • Re: MySQL runs on 16-cores serverAndy Smith11 Apr
      • Re: MySQL runs on 16-cores serverBaron Schwartz11 Apr
        • Re: Re: MySQL runs on 16-cores serverKen Jacobs11 Apr
        • Re: MySQL runs on 16-cores serverDavid Sparks14 Apr
          • Re: MySQL runs on 16-cores serverBaron Schwartz14 Apr
      • Re: MySQL runs on 16-cores servermos11 Apr
        • RE: MySQL runs on 16-cores serverJerry Schwartz13 Apr
          • RE: MySQL runs on 16-cores servermos13 Apr
            • Re: MySQL runs on 16-cores serverBaron Schwartz13 Apr
              • Re: MySQL runs on 16-cores servermos14 Apr
                • Re: MySQL runs on 16-cores serverBaron Schwartz14 Apr
                  • RE: MySQL runs on 16-cores serverMark14 Apr
            • find records with only numbersEd Reed13 Apr
              • Re: find records with only numbersClaudio Nanni13 Apr
              • Re: find records with only numbersPinter Tibor13 Apr
                • Re: find records with only numbersClaudio Nanni13 Apr
            • RE: MySQL runs on 16-cores serverWm Mussatto13 Apr
    • Re: MySQL runs on 16-cores serverMoon's Father16 Apr
  • RE: MySQL runs on 16-cores servergenie.japo15 Apr