EmergencyEMERGENCY? Get 24/7 Help Now!

Tuning InnoDB Concurrency Tickets

 | May 24, 2010 |  Posted In: Benchmarks, Insight for DBAs, MySQL

InnoDB has an oft-unused parameter innodb_concurrency_tickets that seems widely misunderstood. From the docs: “The number of threads that can enter InnoDB concurrently is determined by the innodb_thread_concurrency variable. A thread is placed in a queue when it tries to enter InnoDB if the number of threads has already reached the concurrency limit. When a thread […]

Read More