Debian Codegraph @

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

raw
1 # Tests for PERFORMANCE_SCHEMA
2
3 show databases;
4
5 select count(*) from performance_schema.performance_timers;
6 select count(*) from performance_schema.setup_consumers;
7 # wait/io/table/sql/handler is a native instrument
8 # wait/lock/table/sql/handler is a native instrument
9 # idle/io/socket is a native instrument
10 # wait/lock/metadata is a native instrument
11 select count(*) > 4 from performance_schema.setup_instruments;
12
13 # Make sure we don't crash, no matter what the starting parameters are
14
15 --disable_result_log
16 select * from performance_schema.accounts;
17 select * from performance_schema.cond_instances;
18 select * from performance_schema.events_stages_current;
19 select * from performance_schema.events_stages_history;
20 select * from performance_schema.events_stages_history_long;
21 select * from performance_schema.events_stages_summary_by_account_by_event_name;
22 select * from performance_schema.events_stages_summary_by_host_by_event_name;
23 select * from performance_schema.events_stages_summary_by_thread_by_event_name;
24 select * from performance_schema.events_stages_summary_by_user_by_event_name;
25 select * from performance_schema.events_stages_summary_global_by_event_name;
26 select * from performance_schema.events_statements_current;
27 select * from performance_schema.events_statements_histogram_by_digest;
28 select * from performance_schema.events_statements_histogram_global;
29 select * from performance_schema.events_statements_history;
30 select * from performance_schema.events_statements_history_long;
31 select * from performance_schema.events_statements_summary_by_account_by_event_name;
32 select * from performance_schema.events_statements_summary_by_digest;
33 select * from performance_schema.events_statements_summary_by_host_by_event_name;
34 select * from performance_schema.events_statements_summary_by_thread_by_event_name;
35 select * from performance_schema.events_statements_summary_by_user_by_event_name;
36 select * from performance_schema.events_statements_summary_global_by_event_name;
37 select * from performance_schema.events_transactions_current;
38 select * from performance_schema.events_transactions_history;
39 select * from performance_schema.events_transactions_history_long;
40 select * from performance_schema.events_transactions_summary_by_account_by_event_name;
41 select * from performance_schema.events_transactions_summary_by_host_by_event_name;
42 select * from performance_schema.events_transactions_summary_by_thread_by_event_name;
43 select * from performance_schema.events_transactions_summary_by_user_by_event_name;
44 select * from performance_schema.events_transactions_summary_global_by_event_name;
45 select * from performance_schema.events_waits_current;
46 select * from performance_schema.events_waits_history;
47 select * from performance_schema.events_waits_history_long;
48 select * from performance_schema.events_waits_summary_by_account_by_event_name;
49 select * from performance_schema.events_waits_summary_by_host_by_event_name;
50 select * from performance_schema.events_waits_summary_by_instance;
51 select * from performance_schema.events_waits_summary_by_thread_by_event_name;
52 select * from performance_schema.events_waits_summary_by_user_by_event_name;
53 select * from performance_schema.events_waits_summary_global_by_event_name;
54 select * from performance_schema.memory_summary_by_account_by_event_name;
55 select * from performance_schema.memory_summary_by_host_by_event_name;
56 select * from performance_schema.memory_summary_by_thread_by_event_name;
57 select * from performance_schema.memory_summary_by_user_by_event_name;
58 select * from performance_schema.memory_summary_global_by_event_name;
59 select * from performance_schema.events_errors_summary_by_account_by_error;
60 select * from performance_schema.events_errors_summary_by_host_by_error;
61 select * from performance_schema.events_errors_summary_by_thread_by_error;
62 select * from performance_schema.events_errors_summary_by_user_by_error;
63 select * from performance_schema.events_errors_summary_global_by_error;
64 select * from performance_schema.file_instances;
65 select * from performance_schema.file_summary_by_event_name;
66 select * from performance_schema.file_summary_by_instance;
67 select * from performance_schema.host_cache;
68 select * from performance_schema.hosts;
69 select * from performance_schema.memory_summary_by_account_by_event_name;
70 select * from performance_schema.memory_summary_by_host_by_event_name;
71 select * from performance_schema.memory_summary_by_thread_by_event_name;
72 select * from performance_schema.memory_summary_by_user_by_event_name;
73 select * from performance_schema.memory_summary_global_by_event_name;
74 select * from performance_schema.metadata_locks;
75 select * from performance_schema.mutex_instances;
76 select * from performance_schema.objects_summary_global_by_type;
77 select * from performance_schema.performance_timers;
78 select * from performance_schema.rwlock_instances;
79 select * from performance_schema.data_locks;
80 select * from performance_schema.data_lock_waits;
81 select * from performance_schema.session_account_connect_attrs;
82 select * from performance_schema.session_connect_attrs;
83 select * from performance_schema.setup_actors;
84 select * from performance_schema.setup_consumers;
85 select * from performance_schema.setup_instruments;
86 select * from performance_schema.setup_objects;
87 select * from performance_schema.setup_threads;
88 select * from performance_schema.socket_instances;
89 select * from performance_schema.socket_summary_by_instance;
90 select * from performance_schema.socket_summary_by_event_name;
91 select * from performance_schema.table_handles;
92 select * from performance_schema.table_io_waits_summary_by_index_usage;
93 select * from performance_schema.table_io_waits_summary_by_table;
94 select * from performance_schema.table_lock_waits_summary_by_table;
95 select * from performance_schema.threads;
96 select * from performance_schema.users;
97 select * from performance_schema.replication_connection_configuration;
98 select * from performance_schema.replication_connection_status;
99 select * from performance_schema.replication_applier_configuration;
100 select * from performance_schema.replication_applier_status;
101 select * from performance_schema.replication_applier_status_by_coordinator;
102 select * from performance_schema.replication_applier_status_by_worker;
103 select * from performance_schema.global_status;
104 select * from performance_schema.status_by_thread;
105 select * from performance_schema.status_by_user;
106 select * from performance_schema.status_by_host;
107 select * from performance_schema.status_by_account;
108 select * from performance_schema.session_status;
109 select * from performance_schema.global_variables;
110 select * from performance_schema.variables_by_thread;
111 select * from performance_schema.session_variables;
112 --enable_result_log
113
114 # This has an unrepeatable output, it does depends too much on
115 # - the platform hardware (sizeof structures, padding)
116 # - the compiler used (sizeof(enum))
117 # - the platform header files (sizeof(size_t))
118 # - the code path in the server (what gets executed and instrumented
119 # at runtime)
120
121 --disable_result_log
122 show engine PERFORMANCE_SCHEMA status;
123 show global status like "performance_schema%";
124 --enable_result_log
125