MySQL Enterprise Thread Pool [mysqld] plugin-load-add=thread_pool=thread_pool.so plugin-load-add=tp_thread_state=thread_pool.so plugin-load-add=tp_thread_group_state=thread_pool.so plugin-load-add=tp_thread_group_stats=thread_pool.so [mysqld] plugin-load-add=thread_pool=thread_pool.so [mysqld] plugin-load-add=thread_pool=thread_pool.so plugin-load-add=tp_thread_state=thread_pool.so mysql>  SELECT PLUGIN_NAME, PLUGIN_STATUS FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME LIKE ’thread%’ OR PLUGIN_NAME LIKE ’tp%’; +-----------------------+---------------+ | PLUGIN_NAME | PLUGIN_STATUS | +-----------------------+---------------+ | thread_pool | ACTIVE | | TP_THREAD_STATE | ACTIVE | | TP_THREAD_GROUP_STATE | ACTIVE | | TP_THREAD_GROUP_STATS | ACTIVE | +-----------------------+---------------+ 1082 • thread_pool_stall_limit : The time before an executing statement is considered to be stalled. • thread_pool_size : The number of thread groups in the thread pool. This is the most important parameter controlling thread pool performance. • thread_pool_prio_kickup_timer : How long before the thread pool moves a statement awaiting execution from the low-priority queue to the high-priority queue. • thread_pool_max_unused_threads : How many sleeping threads to permit. • thread_pool_max_active_query_threads : How many active threads per group to permit. • thread_pool_high_priority_connection : How to schedule statement execution for a session. • thread_pool_algorithm : The concurrency algorithm to use for scheduling. 5.6.3.3 Thread Pool Operation The thread pool exposes system variables that may be used to configure its operation: The thread pool consists of a number of thread groups, each of which manages a set of client connections. As connections are established, the thread pool assigns them to thread groups in round-robin fashion. If a plugin fails to initialize, check the server error log for diagnostic messages. If the server loads the thread pool plugin successfully, it sets the  thread_handling  system variable to loaded-dynamically . To verify plugin installation, examine the  INFORMATION_SCHEMA.PLUGINS  table or use the  SHOW PLUGINS  statement (see Section 5.6.2, “Obtaining Server Plugin Information” ). For example: To load the thread pool plugin and only the  TP_THREAD_STATE INFORMATION_SCHEMA  table, use options like this: If desired, you can load individual plugins from the library file. To load the thread pool plugin but not the INFORMATION_SCHEMA  tables, use an option like this: