Thread_concurrency

Oct 29, 2007

what's the correct value for thread_concurrency in /etc/my.cnf if the processor is

Dual Processor Dual Core Opteron 270

is it 4 or 8?

View 2 Replies

Thread_concurrency And Centos

Apr 12, 2007

I have a core2duo at SoftLayer. MySQL 4.1.20.

I tried to add thread_concurrency=4 to my.cnf. I restarted mysqld, but thread_concurrency doesn't show up in "show variables".

Also, is TOP supposed to show the loads in each core separately?

View 4 Replies View Related

Is Thread_concurrency Variable Effective

Dec 18, 2008

It's recommended to make thread_concurrency = Number of CPU's x 2. But this is really effective with latest mysql5 versions?
[url]
Default 10
Range 1-512

Why to set it to 8 (4 cpus), for example, if recommended default value is 10? And why to set such a low value if range is till 512?

Also, how to check assigned value as "show variables;" command omit this value.

View 3 Replies View Related

Mysql Thread_concurrency On A Single-Processor QuadCore

Feb 6, 2008

setting up the MySql thread_concurrency variable on a Single-Processor Xeon 2.6ghz QuadCore .

Should it be 8 (num of cores * 2) ? or 4?

View 0 Replies View Related