Debian Codegraph @

mysql-test/suite/perfschema/include/schema.inc

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