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


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22

--source include/not_embedded.inc
--source include/have_perfschema.inc
--source include/have_maria.inc
--source include/have_archive.inc
--source include/have_blackhole.inc

use performance_schema;

#
# list all instances of everything.
#

#
# "group by" sorts and removes duplicates.
# "where" filters out instances that can be conditionally compiled out
#

select name from mutex_instances group by name;
select name from rwlock_instances group by name;
select name from cond_instances group by name;
select event_name from file_instances group by event_name;
select name from threads group by name;