Debian Codegraph @

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

raw
1
2 select component_urn from mysql.component;
3
4 INSTALL COMPONENT "file://component_pfs_example";
5
6 select component_urn from mysql.component;
7
8 --sorted_result
9 select NAME, ENABLED, TIMED, PROPERTIES, VOLATILITY, DOCUMENTATION
10 from performance_schema.setup_instruments
11 where NAME like "%/pfs_example/%";
12
13 --sorted_result
14 select NAME, LOCKED_BY_THREAD_ID is not NULL
15 from performance_schema.mutex_instances
16 where NAME like "wait/synch/mutex/pfs_example/%";
17
18 --sorted_result
19 select NAME, WRITE_LOCKED_BY_THREAD_ID is not NULL, READ_LOCKED_BY_COUNT
20 from performance_schema.rwlock_instances
21 where NAME like "wait/synch/%/pfs_example/%";
22
23 --sorted_result
24 select NAME
25 from performance_schema.cond_instances
26 where NAME like "wait/synch/%/pfs_example/%";
27
28 UNINSTALL COMPONENT "file://component_pfs_example";
29
30 select component_urn from mysql.component;
31
32 --sorted_result
33 select NAME, ENABLED, TIMED, PROPERTIES, VOLATILITY, DOCUMENTATION
34 from performance_schema.setup_instruments
35 where NAME like "wait/synch/mutex/pfs_example/%";
36
37 --sorted_result
38 select *
39 from performance_schema.mutex_instances
40 where NAME like "%/pfs_example/%";
41
42 --sorted_result
43 select *
44 from performance_schema.rwlock_instances
45 where NAME like "%/pfs_example/%";
46
47 --sorted_result
48 select *
49 from performance_schema.cond_instances
50 where NAME like "%/pfs_example/%";
51
52 --sorted_result
53 select * from performance_schema.global_status
54 where variable_name like "performance_schema%classes_lost";
55