Debian Codegraph @

mysql-test/suite/x/include/xplugin_pfs_instruments_query.inc

raw
1 # Gathering Reports for Xplugin Instruments in Performance
2 # Schema
3
4 # Following test fragment needs to be reworked
5 #select DISTINCT EVENT_NAME from performance_schema.events_waits_current
6 #where EVENT_NAME like '%mysqlx%'
7 #ORDER BY EVENT_NAME;
8
9 -->sql
10 select DISTINCT EVENT_NAME from performance_schema.events_waits_history
11 where EVENT_NAME like '%mysqlx%'
12 ORDER BY EVENT_NAME;
13
14 select DISTINCT EVENT_NAME from performance_schema.events_waits_history_long
15 where EVENT_NAME like '%mysqlx%'
16 ORDER BY EVENT_NAME;
17
18 SELECT DISTINCT name FROM performance_schema.threads
19 WHERE name LIKE 'thread/mysqlx/%'
20 ORDER BY name;
21
22 SELECT DISTINCT name FROM performance_schema.mutex_instances
23 WHERE name LIKE 'wait/synch/mutex/mysqlx/%'
24 ORDER BY name;
25
26 SELECT DISTINCT name FROM performance_schema.cond_instances
27 WHERE name LIKE 'wait/synch/cond/mysqlx/%'
28 ORDER BY name;
29
30 SELECT DISTINCT name FROM performance_schema.rwlock_instances
31 WHERE name LIKE 'wait/synch/rwlock/mysqlx/%'
32 ORDER BY name;
33 -->endsql
34