1# Tests for PERFORMANCE_SCHEMA
2#    Show existing objects and information about their structure
3
4show databases like 'performance_schema';
5show create database performance_schema;
6
7use performance_schema;
8
9show tables;
10
11show create table accounts;
12show create table cond_instances;
13show create table events_stages_current;
14show create table events_stages_history;
15show create table events_stages_history_long;
16show create table events_stages_summary_by_host_by_event_name;
17show create table events_stages_summary_by_thread_by_event_name;
18show create table events_stages_summary_by_user_by_event_name;
19show create table events_stages_summary_by_account_by_event_name;
20show create table events_stages_summary_global_by_event_name;
21show create table events_statements_current;
22show create table events_statements_history;
23show create table events_statements_history_long;
24show create table events_statements_summary_by_digest;
25show create table events_statements_summary_by_host_by_event_name;
26show create table events_statements_summary_by_thread_by_event_name;
27show create table events_statements_summary_by_user_by_event_name;
28show create table events_statements_summary_by_account_by_event_name;
29show create table events_statements_summary_global_by_event_name;
30show create table events_transactions_current;
31show create table events_transactions_history;
32show create table events_transactions_history_long;
33show create table events_transactions_summary_by_host_by_event_name;
34show create table events_transactions_summary_by_thread_by_event_name;
35show create table events_transactions_summary_by_user_by_event_name;
36show create table events_transactions_summary_by_account_by_event_name;
37show create table events_transactions_summary_global_by_event_name;
38show create table events_waits_current;
39show create table events_waits_history;
40show create table events_waits_history_long;
41show create table events_waits_summary_by_host_by_event_name;
42show create table events_waits_summary_by_instance;
43show create table events_waits_summary_by_thread_by_event_name;
44show create table events_waits_summary_by_user_by_event_name;
45show create table events_waits_summary_by_account_by_event_name;
46show create table events_waits_summary_global_by_event_name;
47show create table memory_summary_by_host_by_event_name;
48show create table memory_summary_by_thread_by_event_name;
49show create table memory_summary_by_user_by_event_name;
50show create table memory_summary_by_account_by_event_name;
51show create table memory_summary_global_by_event_name;
52show create table metadata_locks;
53show create table file_instances;
54show create table file_summary_by_event_name;
55show create table file_summary_by_instance;
56show create table host_cache;
57show create table hosts;
58show create table mutex_instances;
59show create table objects_summary_global_by_type;
60show create table performance_timers;
61show create table data_locks;
62show create table data_lock_waits;
63show create table rwlock_instances;
64show create table setup_actors;
65show create table setup_consumers;
66show create table setup_instruments;
67show create table setup_objects;
68show create table socket_instances;
69show create table socket_summary_by_instance;
70show create table socket_summary_by_event_name;
71show create table table_handles;
72show create table table_io_waits_summary_by_index_usage;
73show create table table_io_waits_summary_by_table;
74show create table table_lock_waits_summary_by_table;
75show create table threads;
76show create table users;
77
78