Debian Codegraph @

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

raw
1
2 # Test requires: sp-protocol/ps-protocol/view-protocol/cursor-protocol disabled
3 --source include/no_protocol.inc
4 --source include/not_windows.inc
5
6 # Bug#79784 update setup_instruments do not affect the global
7 # mutex/rwlock/cond
8
9 # Verify instruments are off by default, per *.opt file
10 select count(*) from performance_schema.setup_instruments
11 where enabled='YES'
12 and name like "wait/%";
13
14 # Verify that we have instrumented objects
15 select count(*) > 0 from performance_schema.mutex_instances;
16 select count(*) > 0 from performance_schema.rwlock_instances;
17 select count(*) > 0 from performance_schema.cond_instances;
18 select count(*) > 0 from performance_schema.socket_instances;
19
20 # Check for some known global objects.
21 select NAME from performance_schema.mutex_instances
22 where NAME = "wait/synch/mutex/sql/tz_LOCK";
23 select NAME from performance_schema.rwlock_instances
24 where NAME = "wait/synch/rwlock/sql/LOCK_system_variables_hash";
25 select NAME from performance_schema.cond_instances
26 where NAME = "wait/synch/cond/sql/COND_server_started";
27 select EVENT_NAME from performance_schema.socket_instances
28 where EVENT_NAME = "wait/io/socket/sql/client_connection";