Optimizing Mysql: thread_concurrency
While optimizing our mysql server here at work I tried modifying the value of thread_concurrency with very little effect the servers performance. Further research (aka googling) shows that this value actually only works with Solaris, we're using Fedora Core. It's even on the manual, I wonder why they never even bothered to add that to the comment for this variable.
# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 2
# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 2
From the manual
This variable is specific to Solaris systems, for which mysqld invokes thethr_setconcurrency()
with the variable value. This function enables applications to give the threads system a hint about the desired number of threads that should be run at the same time. This variable was added in MySQL 3.23.7.
Comments
Post a Comment