Debian Codegraph @

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

raw
1 select component_urn from mysql.component;
2 component_urn
3 select *
4 from performance_schema.mutex_instances
5 where NAME like "%/pfs_example/%";
6 NAME OBJECT_INSTANCE_BEGIN LOCKED_BY_THREAD_ID
7 INSTALL COMPONENT "file://component_pfs_example";
8 select component_urn from mysql.component;
9 component_urn
10 file://component_pfs_example
11 select NAME, ENABLED, TIMED, PROPERTIES, VOLATILITY, DOCUMENTATION
12 from performance_schema.setup_instruments
13 where NAME like "%/pfs_example/%";
14 NAME ENABLED TIMED PROPERTIES VOLATILITY DOCUMENTATION
15 wait/synch/cond/pfs_example/X YES YES 0 NULL
16 wait/synch/cond/pfs_example/Y YES YES 0 NULL
17 wait/synch/mutex/pfs_example/T YES YES 3 And more.
18 wait/synch/mutex/pfs_example/X YES YES singleton 1 Example doc, permanent mutex, singleton.
19 wait/synch/mutex/pfs_example/Y YES YES 7 Example doc, very volatile mutexes.
20 wait/synch/mutex/pfs_example/Z YES YES singleton 2 Another example.
21 wait/synch/rwlock/pfs_example/T YES YES 0 NULL
22 wait/synch/rwlock/pfs_example/X YES YES 0 NULL
23 wait/synch/rwlock/pfs_example/Y YES YES 0 NULL
24 wait/synch/rwlock/pfs_example/Z YES YES 0 NULL
25 wait/synch/sxlock/pfs_example/S1 YES YES 0 NULL
26 wait/synch/sxlock/pfs_example/S2 YES YES 0 NULL
27 select NAME
28 from performance_schema.mutex_instances
29 where NAME like "%/pfs_example/%";
30 NAME
31 wait/synch/mutex/pfs_example/T
32 wait/synch/mutex/pfs_example/X
33 wait/synch/mutex/pfs_example/Y
34 wait/synch/mutex/pfs_example/Z
35 UNINSTALL COMPONENT "file://component_pfs_example";
36 select component_urn from mysql.component;
37 component_urn
38 select NAME, ENABLED, TIMED, PROPERTIES, VOLATILITY, DOCUMENTATION
39 from performance_schema.setup_instruments
40 where NAME like "wait/synch/mutex/pfs_example/%";
41 NAME ENABLED TIMED PROPERTIES VOLATILITY DOCUMENTATION
42 wait/synch/mutex/pfs_example/T YES YES 3 And more.
43 wait/synch/mutex/pfs_example/X YES YES singleton 1 Example doc, permanent mutex, singleton.
44 wait/synch/mutex/pfs_example/Y YES YES 7 Example doc, very volatile mutexes.
45 wait/synch/mutex/pfs_example/Z YES YES singleton 2 Another example.
46 select *
47 from performance_schema.mutex_instances
48 where NAME like "%/pfs_example/%";
49 NAME OBJECT_INSTANCE_BEGIN LOCKED_BY_THREAD_ID
50 INSTALL COMPONENT "file://component_pfs_example";
51 select component_urn from mysql.component;
52 component_urn
53 file://component_pfs_example
54 select NAME, ENABLED, TIMED, PROPERTIES, VOLATILITY, DOCUMENTATION
55 from performance_schema.setup_instruments
56 where NAME like "wait/synch/mutex/pfs_example/%";
57 NAME ENABLED TIMED PROPERTIES VOLATILITY DOCUMENTATION
58 wait/synch/mutex/pfs_example/T YES YES 3 And more.
59 wait/synch/mutex/pfs_example/X YES YES singleton 1 Example doc, permanent mutex, singleton.
60 wait/synch/mutex/pfs_example/Y YES YES 7 Example doc, very volatile mutexes.
61 wait/synch/mutex/pfs_example/Z YES YES singleton 2 Another example.
62 select NAME
63 from performance_schema.mutex_instances
64 where NAME like "%/pfs_example/%";
65 NAME
66 wait/synch/mutex/pfs_example/T
67 wait/synch/mutex/pfs_example/X
68 wait/synch/mutex/pfs_example/Y
69 wait/synch/mutex/pfs_example/Z
70 # restart
71 select component_urn from mysql.component;
72 component_urn
73 file://component_pfs_example
74 select NAME, ENABLED, TIMED, PROPERTIES, VOLATILITY, DOCUMENTATION
75 from performance_schema.setup_instruments
76 where NAME like "wait/synch/mutex/pfs_example/%";
77 NAME ENABLED TIMED PROPERTIES VOLATILITY DOCUMENTATION
78 wait/synch/mutex/pfs_example/T YES YES 3 And more.
79 wait/synch/mutex/pfs_example/X YES YES singleton 1 Example doc, permanent mutex, singleton.
80 wait/synch/mutex/pfs_example/Y YES YES 7 Example doc, very volatile mutexes.
81 wait/synch/mutex/pfs_example/Z YES YES singleton 2 Another example.
82 select NAME
83 from performance_schema.mutex_instances
84 where NAME like "%/pfs_example/%";
85 NAME
86 wait/synch/mutex/pfs_example/T
87 wait/synch/mutex/pfs_example/X
88 wait/synch/mutex/pfs_example/Y
89 wait/synch/mutex/pfs_example/Z
90 UNINSTALL COMPONENT "file://component_pfs_example";
91 select component_urn from mysql.component;
92 component_urn
93 select NAME, ENABLED, TIMED, PROPERTIES, VOLATILITY, DOCUMENTATION
94 from performance_schema.setup_instruments
95 where NAME like "wait/synch/mutex/pfs_example/%";
96 NAME ENABLED TIMED PROPERTIES VOLATILITY DOCUMENTATION
97 wait/synch/mutex/pfs_example/T YES YES 3 And more.
98 wait/synch/mutex/pfs_example/X YES YES singleton 1 Example doc, permanent mutex, singleton.
99 wait/synch/mutex/pfs_example/Y YES YES 7 Example doc, very volatile mutexes.
100 wait/synch/mutex/pfs_example/Z YES YES singleton 2 Another example.
101 select *
102 from performance_schema.mutex_instances
103 where NAME like "%/pfs_example/%";
104 NAME OBJECT_INSTANCE_BEGIN LOCKED_BY_THREAD_ID
105 # restart
106 select component_urn from mysql.component;
107 component_urn
108 select NAME, ENABLED, TIMED, PROPERTIES, VOLATILITY, DOCUMENTATION
109 from performance_schema.setup_instruments
110 where NAME like "wait/synch/mutex/pfs_example/%";
111 NAME ENABLED TIMED PROPERTIES VOLATILITY DOCUMENTATION
112 select *
113 from performance_schema.mutex_instances
114 where NAME like "%/pfs_example/%";
115 NAME OBJECT_INSTANCE_BEGIN LOCKED_BY_THREAD_ID