InnoDB System Variables 3288 Minimum Value 1 Maximum Value 1024 Command-Line Format --innodb-sync-spin-loops=# System Variable innodb_sync_spin_loops Scope Global Dynamic Yes SET_VAR  Hint Applies No Type Integer Default Value 30 Minimum Value 0 Maximum Value 4294967295 Command-Line Format --innodb-sync-debug[={OFF|ON}] System Variable innodb_sync_debug Scope Global Dynamic No SET_VAR  Hint Applies No Type Boolean Default Value OFF Command-Line Format --innodb-table-locks[={OFF|ON}] System Variable innodb_table_locks Scope Global, Session Dynamic Yes SET_VAR  Hint Applies No Type Boolean 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. The number of times a thread waits for an  InnoDB  mutex to be freed before the thread is suspended. 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 • innodb_sync_debug • innodb_table_locks