Members Members   Search Search   Help Help   Register Register   Login Login   Home Home
Home » Performance » MySQL » innodb_thread_concurrency values for many cpu systems
innodb_thread_concurrency values for many cpu systems [message #218] Mon, 02 October 2006 11:55 Go to next message
aronrosenberg
Messages: 16
Registered: September 2006
Junior Member
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?
Report message to a moderator
Re: innodb_thread_concurrency values for many cpu systems [message #219 is a reply to message #218 ] Tue, 03 October 2006 13:41 Go to previous message
Peter is currently offline Peter
Messages: 405
Registered: August 2006
Senior Member
Super Guru
innodb_thread_concurrency is not always solving problems on boxes with high number of CPUs. You may try values 8 or 16 to start with while sometimes smaller value as 2 or 4 give better performance.

You also might wish to disable hypperthreading.

You can also check this post:

http://www.mysqlperformanceblog.com/2006/07/28/returning-to- innodb-scalability/

It has plenty of good details.

Peter Zaitsev, MySQL Performance Expert
MySQL Performance Blog - http://www.mysqlperformanceblog.com
MySQL Consulting http://www.mysqlperformanceblog.com/mysql-consulting/
Report message to a moderator
Previous Topic:Optimal database structure
Next Topic:Commit latency for rows containing longblob columns..
Goto Forum:
  

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [ ]

Current Time: Fri Jul 10 01:11:42 EDT 2009

Total time taken to generate the page: 0.00787 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 2.7.7.
Copyright ©2001-2007 FUD Forum Bulletin Board Software

MySQL is a trademark of Sun Microsystems.
InnoDB is a trademark of Oracle Corp.

Percona Performance Forums are a service of Percona, Inc.
Not affiliated with Sun Microsystems or Oracle Corp.