InnoDB System Variables to 60, 70, or more. Through testing, you find that performance remains largely stable with a limit of 80 concurrent users. In this case, set  innodb_thread_concurrency  to 80. •If you do not want  InnoDB  to use more than a certain number of virtual CPUs for user threads (20 virtual CPUs, for example), set  innodb_thread_concurrency  to this number (or possibly lower, depending on performance testing). If your goal is to isolate MySQL from other applications, consider binding the  mysqld  process exclusively to the virtual CPUs. Be aware, however, that exclusive binding can result in non-optimal hardware usage if the  mysqld  process is not consistently busy. In this case, you can bind the  mysqld  process to the virtual CPUs but allow other applications to use some or all of the virtual CPUs. Note From an operating system perspective, using a resource management solution to manage how CPU time is shared among applications may be preferable to binding the  mysqld  process. For example, you could assign 90% of virtual CPU time to a given application while other critical processes  are not  running, and scale that value back to 40% when other critical processes  are  running. •In some cases, the optimal  innodb_thread_concurrency  setting can be smaller than the number of virtual CPUs. •An  innodb_thread_concurrency  value that is too high can cause performance regression due to increased contention on system internals and resources. •Monitor and analyze your system regularly. Changes to workload, number of users, or computing environment may require that you adjust the  innodb_thread_concurrency  setting. • innodb_thread_sleep_delay A value of 0 disables the  queries inside InnoDB  and  queries in queue   counters in the  ROW OPERATIONS  section of  SHOW ENGINE INNODB STATUS  output. For related information, see Section 15.8.4, “Configuring Thread Concurrency for InnoDB” . How long  InnoDB  threads sleep before joining the  InnoDB  queue, in microseconds. The default value is 10000. A value of 0 disables sleep. You can set  innodb_adaptive_max_sleep_delay  to the highest value you would allow for  innodb_thread_sleep_delay , and  InnoDB  automatically adjusts innodb_thread_sleep_delay  up or down depending on current thread-scheduling activity. This 3292 Command-Line Format --innodb-thread-sleep-delay=# System Variable innodb_thread_sleep_delay Scope Global Dynamic Yes SET_VAR  Hint Applies No Type Integer Default Value 10000 Minimum Value 0 Maximum Value 1000000