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 <mo...@fastmail.fm> 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=yueliangdao0...@gmail.com > > -- I'm a MySQL DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn