List:General Discussion« Previous MessageNext Message »
From:Moon's Father Date:April 16 2009 7:58am
Subject:Re: MySQL runs on 16-cores server
View as plain text  
Thanks for you reply.

I read the official document and found the variable called
"thread_concurrency" could only affect on solaris.

On Sat, Apr 11, 2009 at 5:04 AM, mos <mos99@stripped> wrote:

> At 06:00 AM 4/10/2009, you wrote:
>
>> Hi.
>>   If the server has 16 cores, how to set parameters to make MySQL runs
>> well.
>> Any reply is appreciated.
>>
>
> 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.
>
> Mike
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=1
>
>


-- 
I'm a MySQL DBA in china.
More about me just visit here:
http://yueliangdao0608.cublog.cn

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