List:General Discussion« Previous MessageNext Message »
From:Baron Schwartz Date:April 13 2009 7:21pm
Subject:Re: MySQL runs on 16-cores server
View as plain text  
Mike,

> MySQL does not scale well beyond 4 processors, at least not like PostgreSql
> does. MySQL seems to hit a plateau rather quickly. If XtraDb's modified
> Innodb plugin scales better, then fine.  But I haven't seen any benchmarks
> showing the speed improvements relative to the number of processors used and
> is something I'd really like to see.

You can find such benchmarks on our blog.  And Mark Callaghan and
maybe some others have benchmarked it too.  Of course, we would love
to see more independent benchmarks.  Vadim considers that we've solved
scalability problems in XtraDB up to 16 cores, and I agree, though I
am less of an expert than he is.  However, many problems in MySQL
itself remain even if all the storage engines are fixed.

>> As others said, the major bottlenecks are likely to be internal (to the
>> DB)
>> locking and disk access speed.
>
> Of course. When it comes to MySQL, I would invest more money into more
> memory and fast SSD drives rather than more CPU's. You'll get a bigger bang
> for the buck. :)

None of MySQL's current storage engines takes advantage of a lot of
memory or fast SSD drives either, in my opinion.  Not like they could,
anyway.

Have you seen our (or Jignesh Shah's, or Matt Yonkovit's) benchmarks
and discussion on SSD drives?  When you disable the (unsafe,
non-battery-backed) write cache, suddenly they aren't so fast anymore.

Baron
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