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