Not the answer you need?
Register and ask your own question!

innodb_thread_concurrency values for many cpu systems

aronrosenbergaronrosenberg ContributorInactive User Role Beginner
High level question: What is a good innodb_thread_concurrency value for a large scale 8 CPU box?

We have a new set of dual processor dual core (with hyperthread) servers on the way and are debating which value for innodb_thread_concurrency is best. The OS see's 8 CPU's in each of these boxes. Shoould we use a high or infinate innodb_thread_concurrency or use lower because of the problem of sharing the mutex's for the innodb buffer pool that was blogged about last month?


Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.