content_image/762603.jpg content_image/762604.jpg content_image/762605.jpg content_image/762606.jpg
<img src='content_image/762603.jpg'>

Defines the size of the mutex/lock wait array. Increasing the value splits the internal data structure used to coordinate threads, for higher concurrency in workloads with large numbers of waiting threads. This setting must be configured when the MySQL instance is starting up, and cannot be changed afterward. Increasing the value is recommended for workloads that frequently produce a large number of waiting threads, typically greater than 768. 

• innodb_sync_spin_loops 

<img src='content_image/762604.jpg'>

The number of times a thread waits for an InnoDB  mutex to be freed before the thread is suspended. 

• innodb_sync_debug 

<img src='content_image/762605.jpg'>

Enables sync debug checking for the InnoDB  storage engine. This option is only available if debugging support is compiled in using the WITH_DEBUG CMake  option. 

• innodb_table_locks 

<img src='content_image/762606.jpg'>

