1
# Tests for PERFORMANCE_SCHEMA
3
--source include/not_embedded.inc
4
--source include/have_perfschema.inc
6
--source ../include/start_server_common.inc
8
show variables like "performance_schema%";
11
select * from performance_schema.setup_instruments;
12
select TIMER_NAME from performance_schema.performance_timers;
13
select * from performance_schema.setup_consumers;
14
select NAME from performance_schema.setup_timers;
17
select * from performance_schema.accounts;
18
select * from performance_schema.cond_instances;
19
select * from performance_schema.events_stages_current;
20
select * from performance_schema.events_stages_history;
21
select * from performance_schema.events_stages_history_long;
22
select * from performance_schema.events_stages_summary_by_account_by_event_name;
23
select * from performance_schema.events_stages_summary_by_host_by_event_name;
24
select * from performance_schema.events_stages_summary_by_thread_by_event_name;
25
select * from performance_schema.events_stages_summary_by_user_by_event_name;
26
select * from performance_schema.events_stages_summary_global_by_event_name;
27
select * from performance_schema.events_statements_current;
28
select * from performance_schema.events_statements_history;
29
select * from performance_schema.events_statements_history_long;
30
select * from performance_schema.events_statements_summary_by_account_by_event_name;
31
select * from performance_schema.events_statements_summary_by_host_by_event_name;
32
select * from performance_schema.events_statements_summary_by_thread_by_event_name;
33
select * from performance_schema.events_statements_summary_by_user_by_event_name;
34
select * from performance_schema.events_statements_summary_global_by_event_name;
35
select * from performance_schema.events_waits_current;
36
select * from performance_schema.events_waits_history;
37
select * from performance_schema.events_waits_history_long;
38
select * from performance_schema.events_waits_summary_by_account_by_event_name;
39
select * from performance_schema.events_waits_summary_by_host_by_event_name;
40
select * from performance_schema.events_waits_summary_by_instance;
41
select * from performance_schema.events_waits_summary_by_thread_by_event_name;
42
select * from performance_schema.events_waits_summary_by_user_by_event_name;
43
select * from performance_schema.events_waits_summary_global_by_event_name;
44
select * from performance_schema.file_instances;
45
select * from performance_schema.file_summary_by_event_name;
46
select * from performance_schema.file_summary_by_instance;
47
select * from performance_schema.session_account_connect_attrs;
48
select * from performance_schema.session_connect_attrs;
49
select * from performance_schema.socket_instances;
50
select * from performance_schema.socket_summary_by_instance;
51
select * from performance_schema.socket_summary_by_event_name;
52
select * from performance_schema.hosts;
53
select * from performance_schema.mutex_instances;
54
select * from performance_schema.objects_summary_global_by_type;
55
select * from performance_schema.rwlock_instances;
56
select * from performance_schema.setup_actors;
57
select * from performance_schema.setup_objects;
58
select * from performance_schema.threads;
59
select * from performance_schema.users;