Debian Codegraph @

mysql-test/suite/perfschema/t/pfs_example_lifecycle.test

raw
1 select component_urn from mysql.component;
2
3 --sorted_result
4 select *
5 from performance_schema.mutex_instances
6 where NAME like "%/pfs_example/%";
7
8 INSTALL COMPONENT "file://component_pfs_example";
9
10 select component_urn from mysql.component;
11
12 --sorted_result
13 select NAME, ENABLED, TIMED, PROPERTIES, VOLATILITY, DOCUMENTATION
14 from performance_schema.setup_instruments
15 where NAME like "%/pfs_example/%";
16
17 --sorted_result
18 select NAME
19 from performance_schema.mutex_instances
20 where NAME like "%/pfs_example/%";
21
22 UNINSTALL COMPONENT "file://component_pfs_example";
23
24 select component_urn from mysql.component;
25
26 --sorted_result
27 select NAME, ENABLED, TIMED, PROPERTIES, VOLATILITY, DOCUMENTATION
28 from performance_schema.setup_instruments
29 where NAME like "wait/synch/mutex/pfs_example/%";
30
31 --sorted_result
32 select *
33 from performance_schema.mutex_instances
34 where NAME like "%/pfs_example/%";
35
36 INSTALL COMPONENT "file://component_pfs_example";
37
38 select component_urn from mysql.component;
39
40 --sorted_result
41 select NAME, ENABLED, TIMED, PROPERTIES, VOLATILITY, DOCUMENTATION
42 from performance_schema.setup_instruments
43 where NAME like "wait/synch/mutex/pfs_example/%";
44
45 --sorted_result
46 select NAME
47 from performance_schema.mutex_instances
48 where NAME like "%/pfs_example/%";
49
50 --source include/restart_mysqld.inc
51
52 select component_urn from mysql.component;
53
54 --sorted_result
55 select NAME, ENABLED, TIMED, PROPERTIES, VOLATILITY, DOCUMENTATION
56 from performance_schema.setup_instruments
57 where NAME like "wait/synch/mutex/pfs_example/%";
58
59 --sorted_result
60 select NAME
61 from performance_schema.mutex_instances
62 where NAME like "%/pfs_example/%";
63
64 UNINSTALL COMPONENT "file://component_pfs_example";
65
66 select component_urn from mysql.component;
67
68 --sorted_result
69 select NAME, ENABLED, TIMED, PROPERTIES, VOLATILITY, DOCUMENTATION
70 from performance_schema.setup_instruments
71 where NAME like "wait/synch/mutex/pfs_example/%";
72
73 --sorted_result
74 select *
75 from performance_schema.mutex_instances
76 where NAME like "%/pfs_example/%";
77
78 --source include/restart_mysqld.inc
79
80 select component_urn from mysql.component;
81
82 --sorted_result
83 select NAME, ENABLED, TIMED, PROPERTIES, VOLATILITY, DOCUMENTATION
84 from performance_schema.setup_instruments
85 where NAME like "wait/synch/mutex/pfs_example/%";
86
87 --sorted_result
88 select *
89 from performance_schema.mutex_instances
90 where NAME like "%/pfs_example/%";
91