Debian Codegraph @

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

raw
1 flush global 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 connect con1, localhost, root, , ;
8 connect con2, localhost, root, , ;
9 connection default;
10 select @id_increment;
11 @id_increment
12 1
13 select @thread_id_increment;
14 @thread_id_increment
15 1
16 disconnect con2;
17 connection default;
18 connect con3, localhost, root, , ;
19 disconnect con3;
20 disconnect con1;
21 connection default;
22 select @id_increment;
23 @id_increment
24 1
25 select @thread_id_increment;
26 @thread_id_increment
27 1
28 set global thread_cache_size = 100;
29 show global variables like "thread_cache_size";
30 Variable_name Value
31 thread_cache_size 100
32 connect con1, localhost, root, , ;
33 connect con2, localhost, root, , ;
34 connection default;
35 select @id_increment;
36 @id_increment
37 1
38 select @thread_id_increment;
39 @thread_id_increment
40 1
41 disconnect con2;
42 connection default;
43 connect con3, localhost, root, , ;
44 disconnect con3;
45 disconnect con1;
46 connection default;
47 select @id_increment;
48 @id_increment
49 1
50 select @thread_id_increment;
51 @thread_id_increment
52 1
53 set global thread_cache_size = @saved_thread_cache_size;
54 show global status like "performance_schema_thread%";
55 Variable_name Value
56 Performance_schema_thread_classes_lost 0
57 Performance_schema_thread_instances_lost 0