So if you used innodb_thread_concurrency over 500 (or default value in 5.0.8-5.0.18), don’t forget to change it to 0 in new versions, otherwise you can experience leaps of performance.?? 没懂的说,需要把innodb_thread_concurrency改成0? 再请教一下,我在show variables里面怎么没看到thread_concurrency参数?
The range of this variable is 0 to 1000. A value of 20 or higher is interpreted as infinite concurrency before MySQL 5.0.19. From 5.0.19 on, you can disable thread concurrency checking by setting the value to 0, which allows InnoDB to create as many threads as it needs. The default value has changed several times: 8 before MySQL 5.0.8, 20 (infinite) from 5.0.8 through 5.0.18, 0 (infinite) from 5.0.19 to 5.0.20, and 8 (finite) from 5.0.21 on. 这个是官网看到的。
我是在/proc/cpuinfo里看到的是8CPU,如果是4个双核CPU,那也是需要设置为16么?还有,我这里使用的表大部分是innodb表,是否需要设置innodb_thread_concurrency=16呢?
再想请教一下,这两个参数是否都是设置MYSQL使用多CPU的进程?
没懂的说,需要把innodb_thread_concurrency改成0?
再请教一下,我在show variables里面怎么没看到thread_concurrency参数?
这个是官网看到的。