| 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 |
|