Debian Codegraph @

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

raw
1 select component_urn from mysql.component;
2 component_urn
3 INSTALL COMPONENT "file://component_pfs_example";
4 select component_urn from mysql.component;
5 component_urn
6 file://component_pfs_example
7 select NAME, ENABLED, TIMED, PROPERTIES, VOLATILITY, DOCUMENTATION
8 from performance_schema.setup_instruments
9 where NAME like "%/pfs_example/%";
10 NAME ENABLED TIMED PROPERTIES VOLATILITY DOCUMENTATION
11 wait/synch/cond/pfs_example/X YES YES 0 NULL
12 wait/synch/cond/pfs_example/Y YES YES 0 NULL
13 wait/synch/mutex/pfs_example/T YES YES 3 And more.
14 wait/synch/mutex/pfs_example/X YES YES singleton 1 Example doc, permanent mutex, singleton.
15 wait/synch/mutex/pfs_example/Y YES YES 7 Example doc, very volatile mutexes.
16 wait/synch/mutex/pfs_example/Z YES YES singleton 2 Another example.
17 wait/synch/rwlock/pfs_example/T YES YES 0 NULL
18 wait/synch/rwlock/pfs_example/X YES YES 0 NULL
19 wait/synch/rwlock/pfs_example/Y YES YES 0 NULL
20 wait/synch/rwlock/pfs_example/Z YES YES 0 NULL
21 wait/synch/sxlock/pfs_example/S1 YES YES 0 NULL
22 wait/synch/sxlock/pfs_example/S2 YES YES 0 NULL
23 select NAME, LOCKED_BY_THREAD_ID is not NULL
24 from performance_schema.mutex_instances
25 where NAME like "wait/synch/mutex/pfs_example/%";
26 NAME LOCKED_BY_THREAD_ID is not NULL
27 wait/synch/mutex/pfs_example/T 0
28 wait/synch/mutex/pfs_example/X 0
29 wait/synch/mutex/pfs_example/Y 0
30 wait/synch/mutex/pfs_example/Z 0
31 select NAME, WRITE_LOCKED_BY_THREAD_ID is not NULL, READ_LOCKED_BY_COUNT
32 from performance_schema.rwlock_instances
33 where NAME like "wait/synch/%/pfs_example/%";
34 NAME WRITE_LOCKED_BY_THREAD_ID is not NULL READ_LOCKED_BY_COUNT
35 wait/synch/rwlock/pfs_example/T 0 0
36 wait/synch/rwlock/pfs_example/X 0 0
37 wait/synch/rwlock/pfs_example/Y 0 0
38 wait/synch/rwlock/pfs_example/Z 0 0
39 wait/synch/sxlock/pfs_example/S1 0 0
40 wait/synch/sxlock/pfs_example/S2 0 0
41 select NAME
42 from performance_schema.cond_instances
43 where NAME like "wait/synch/%/pfs_example/%";
44 NAME
45 wait/synch/cond/pfs_example/X
46 wait/synch/cond/pfs_example/Y
47 UNINSTALL COMPONENT "file://component_pfs_example";
48 select component_urn from mysql.component;
49 component_urn
50 select NAME, ENABLED, TIMED, PROPERTIES, VOLATILITY, DOCUMENTATION
51 from performance_schema.setup_instruments
52 where NAME like "wait/synch/mutex/pfs_example/%";
53 NAME ENABLED TIMED PROPERTIES VOLATILITY DOCUMENTATION
54 wait/synch/mutex/pfs_example/T YES YES 3 And more.
55 wait/synch/mutex/pfs_example/X YES YES singleton 1 Example doc, permanent mutex, singleton.
56 wait/synch/mutex/pfs_example/Y YES YES 7 Example doc, very volatile mutexes.
57 wait/synch/mutex/pfs_example/Z YES YES singleton 2 Another example.
58 select *
59 from performance_schema.mutex_instances
60 where NAME like "%/pfs_example/%";
61 NAME OBJECT_INSTANCE_BEGIN LOCKED_BY_THREAD_ID
62 select *
63 from performance_schema.rwlock_instances
64 where NAME like "%/pfs_example/%";
65 NAME OBJECT_INSTANCE_BEGIN WRITE_LOCKED_BY_THREAD_ID READ_LOCKED_BY_COUNT
66 select *
67 from performance_schema.cond_instances
68 where NAME like "%/pfs_example/%";
69 NAME OBJECT_INSTANCE_BEGIN
70 select * from performance_schema.global_status
71 where variable_name like "performance_schema%classes_lost";
72 VARIABLE_NAME VARIABLE_VALUE
73 Performance_schema_cond_classes_lost 0
74 Performance_schema_file_classes_lost 0
75 Performance_schema_memory_classes_lost 0
76 Performance_schema_mutex_classes_lost 0
77 Performance_schema_rwlock_classes_lost 0
78 Performance_schema_socket_classes_lost 0
79 Performance_schema_stage_classes_lost 0
80 Performance_schema_statement_classes_lost 0
81 Performance_schema_thread_classes_lost 0