Debian Codegraph @

mysql-test/suite/perfschema/r/thread_cache.result

raw
1 flush status;
2 SET @saved_thread_cache_size = @@global.thread_cache_size;
3 set global thread_cache_size = 0;
4 show global variables like "thread_cache_size";
5 Variable_name Value
6 thread_cache_size 0
7 select @id_increment;
8 @id_increment
9 1
10 select @thread_id_increment;
11 @thread_id_increment
12 1
13 select @id_increment;
14 @id_increment
15 1
16 select @thread_id_increment;
17 @thread_id_increment
18 1
19 set global thread_cache_size = 100;
20 show global variables like "thread_cache_size";
21 Variable_name Value
22 thread_cache_size 100
23 select @id_increment;
24 @id_increment
25 1
26 select @thread_id_increment;
27 @thread_id_increment
28 1
29 select @id_increment;
30 @id_increment
31 1
32 select @thread_id_increment;
33 @thread_id_increment
34 1
35 set global thread_cache_size = @saved_thread_cache_size;
36 show global status like "performance_schema_thread%";
37 Variable_name Value
38 Performance_schema_thread_classes_lost 0
39 Performance_schema_thread_instances_lost 0