35 lines
998 B
SQL
35 lines
998 B
SQL
# Gathering Reports for Xplugin Instruments in Performance
|
|
# Schema
|
|
|
|
# Following test fragment needs to be reworked
|
|
#select DISTINCT EVENT_NAME from performance_schema.events_waits_current
|
|
#where EVENT_NAME like '%mysqlx%'
|
|
#ORDER BY EVENT_NAME;
|
|
|
|
-->sql
|
|
select DISTINCT EVENT_NAME from performance_schema.events_waits_history
|
|
where EVENT_NAME like '%mysqlx%'
|
|
ORDER BY EVENT_NAME;
|
|
|
|
select DISTINCT EVENT_NAME from performance_schema.events_waits_history_long
|
|
where EVENT_NAME like '%mysqlx%'
|
|
ORDER BY EVENT_NAME;
|
|
|
|
SELECT DISTINCT name FROM performance_schema.threads
|
|
WHERE name LIKE 'thread/mysqlx/%'
|
|
ORDER BY name;
|
|
|
|
SELECT DISTINCT name FROM performance_schema.mutex_instances
|
|
WHERE name LIKE 'wait/synch/mutex/mysqlx/%'
|
|
ORDER BY name;
|
|
|
|
SELECT DISTINCT name FROM performance_schema.cond_instances
|
|
WHERE name LIKE 'wait/synch/cond/mysqlx/%'
|
|
ORDER BY name;
|
|
|
|
SELECT DISTINCT name FROM performance_schema.rwlock_instances
|
|
WHERE name LIKE 'wait/synch/rwlock/mysqlx/%'
|
|
ORDER BY name;
|
|
-->endsql
|
|
|