1flush status;
2SET @saved_thread_cache_size = @@global.thread_cache_size;
3set global thread_cache_size = 0;
4show variables like "thread_cache_size";
5Variable_name	Value
6thread_cache_size	0
7select @id_increment;
8@id_increment
91
10select @thread_id_increment;
11@thread_id_increment
121
13select @id_increment;
14@id_increment
151
16select @thread_id_increment;
17@thread_id_increment
181
19set global thread_cache_size = 100;
20show variables like "thread_cache_size";
21Variable_name	Value
22thread_cache_size	100
23select @id_increment;
24@id_increment
251
26select @thread_id_increment;
27@thread_id_increment
281
29select @id_increment;
30@id_increment
311
32select @thread_id_increment;
33@thread_id_increment
341
35set global thread_cache_size = @saved_thread_cache_size;
36show status like "performance_schema_thread%";
37Variable_name	Value
38Performance_schema_thread_classes_lost	0
39Performance_schema_thread_instances_lost	0
40