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