Debian Codegraph @

mysql-test/suite/perfschema/r/start_server_off.result

raw
1 show databases;
2 Database
3 information_schema
4 mtr
5 mysql
6 performance_schema
7 sys
8 test
9 select count(*) from performance_schema.performance_timers;
10 count(*)
11 0
12 select count(*) from performance_schema.setup_consumers;
13 count(*)
14 0
15 select count(*) > 4 from performance_schema.setup_instruments;
16 count(*) > 4
17 0
18 select * from performance_schema.accounts;
19 select * from performance_schema.cond_instances;
20 select * from performance_schema.events_stages_current;
21 select * from performance_schema.events_stages_history;
22 select * from performance_schema.events_stages_history_long;
23 select * from performance_schema.events_stages_summary_by_account_by_event_name;
24 select * from performance_schema.events_stages_summary_by_host_by_event_name;
25 select * from performance_schema.events_stages_summary_by_thread_by_event_name;
26 select * from performance_schema.events_stages_summary_by_user_by_event_name;
27 select * from performance_schema.events_stages_summary_global_by_event_name;
28 select * from performance_schema.events_statements_current;
29 select * from performance_schema.events_statements_histogram_by_digest;
30 select * from performance_schema.events_statements_histogram_global;
31 select * from performance_schema.events_statements_history;
32 select * from performance_schema.events_statements_history_long;
33 select * from performance_schema.events_statements_summary_by_account_by_event_name;
34 select * from performance_schema.events_statements_summary_by_digest;
35 select * from performance_schema.events_statements_summary_by_host_by_event_name;
36 select * from performance_schema.events_statements_summary_by_thread_by_event_name;
37 select * from performance_schema.events_statements_summary_by_user_by_event_name;
38 select * from performance_schema.events_statements_summary_global_by_event_name;
39 select * from performance_schema.events_transactions_current;
40 select * from performance_schema.events_transactions_history;
41 select * from performance_schema.events_transactions_history_long;
42 select * from performance_schema.events_transactions_summary_by_account_by_event_name;
43 select * from performance_schema.events_transactions_summary_by_host_by_event_name;
44 select * from performance_schema.events_transactions_summary_by_thread_by_event_name;
45 select * from performance_schema.events_transactions_summary_by_user_by_event_name;
46 select * from performance_schema.events_transactions_summary_global_by_event_name;
47 select * from performance_schema.events_waits_current;
48 select * from performance_schema.events_waits_history;
49 select * from performance_schema.events_waits_history_long;
50 select * from performance_schema.events_waits_summary_by_account_by_event_name;
51 select * from performance_schema.events_waits_summary_by_host_by_event_name;
52 select * from performance_schema.events_waits_summary_by_instance;
53 select * from performance_schema.events_waits_summary_by_thread_by_event_name;
54 select * from performance_schema.events_waits_summary_by_user_by_event_name;
55 select * from performance_schema.events_waits_summary_global_by_event_name;
56 select * from performance_schema.memory_summary_by_account_by_event_name;
57 select * from performance_schema.memory_summary_by_host_by_event_name;
58 select * from performance_schema.memory_summary_by_thread_by_event_name;
59 select * from performance_schema.memory_summary_by_user_by_event_name;
60 select * from performance_schema.memory_summary_global_by_event_name;
61 select * from performance_schema.events_errors_summary_by_account_by_error;
62 select * from performance_schema.events_errors_summary_by_host_by_error;
63 select * from performance_schema.events_errors_summary_by_thread_by_error;
64 select * from performance_schema.events_errors_summary_by_user_by_error;
65 select * from performance_schema.events_errors_summary_global_by_error;
66 select * from performance_schema.file_instances;
67 select * from performance_schema.file_summary_by_event_name;
68 select * from performance_schema.file_summary_by_instance;
69 select * from performance_schema.host_cache;
70 select * from performance_schema.hosts;
71 select * from performance_schema.memory_summary_by_account_by_event_name;
72 select * from performance_schema.memory_summary_by_host_by_event_name;
73 select * from performance_schema.memory_summary_by_thread_by_event_name;
74 select * from performance_schema.memory_summary_by_user_by_event_name;
75 select * from performance_schema.memory_summary_global_by_event_name;
76 select * from performance_schema.metadata_locks;
77 select * from performance_schema.mutex_instances;
78 select * from performance_schema.objects_summary_global_by_type;
79 select * from performance_schema.performance_timers;
80 select * from performance_schema.rwlock_instances;
81 select * from performance_schema.data_locks;
82 select * from performance_schema.data_lock_waits;
83 select * from performance_schema.session_account_connect_attrs;
84 select * from performance_schema.session_connect_attrs;
85 select * from performance_schema.setup_actors;
86 select * from performance_schema.setup_consumers;
87 select * from performance_schema.setup_instruments;
88 select * from performance_schema.setup_objects;
89 select * from performance_schema.setup_threads;
90 select * from performance_schema.socket_instances;
91 select * from performance_schema.socket_summary_by_instance;
92 select * from performance_schema.socket_summary_by_event_name;
93 select * from performance_schema.table_handles;
94 select * from performance_schema.table_io_waits_summary_by_index_usage;
95 select * from performance_schema.table_io_waits_summary_by_table;
96 select * from performance_schema.table_lock_waits_summary_by_table;
97 select * from performance_schema.threads;
98 select * from performance_schema.users;
99 select * from performance_schema.replication_connection_configuration;
100 select * from performance_schema.replication_connection_status;
101 select * from performance_schema.replication_applier_configuration;
102 select * from performance_schema.replication_applier_status;
103 select * from performance_schema.replication_applier_status_by_coordinator;
104 select * from performance_schema.replication_applier_status_by_worker;
105 select * from performance_schema.global_status;
106 select * from performance_schema.status_by_thread;
107 select * from performance_schema.status_by_user;
108 select * from performance_schema.status_by_host;
109 select * from performance_schema.status_by_account;
110 select * from performance_schema.session_status;
111 select * from performance_schema.global_variables;
112 select * from performance_schema.variables_by_thread;
113 select * from performance_schema.session_variables;
114 show engine PERFORMANCE_SCHEMA status;
115 show global status like "performance_schema%";
116 select * from information_schema.engines
117 where engine = "PERFORMANCE_SCHEMA";
118 ENGINE SUPPORT COMMENT TRANSACTIONS XA SAVEPOINTS
119 PERFORMANCE_SCHEMA YES Performance Schema NO NO NO
120 show global status like "performance_schema%_lost";
121 Variable_name Value
122 Performance_schema_accounts_lost 0
123 Performance_schema_cond_classes_lost 0
124 Performance_schema_cond_instances_lost 0
125 Performance_schema_digest_lost 0
126 Performance_schema_file_classes_lost 0
127 Performance_schema_file_handles_lost 0
128 Performance_schema_file_instances_lost 0
129 Performance_schema_hosts_lost 0
130 Performance_schema_index_stat_lost 0
131 Performance_schema_locker_lost 0
132 Performance_schema_memory_classes_lost 0
133 Performance_schema_metadata_lock_lost 0
134 Performance_schema_mutex_classes_lost 0
135 Performance_schema_mutex_instances_lost 0
136 Performance_schema_nested_statement_lost 0
137 Performance_schema_prepared_statements_lost 0
138 Performance_schema_program_lost 0
139 Performance_schema_rwlock_classes_lost 0
140 Performance_schema_rwlock_instances_lost 0
141 Performance_schema_session_connect_attrs_lost 0
142 Performance_schema_socket_classes_lost 0
143 Performance_schema_socket_instances_lost 0
144 Performance_schema_stage_classes_lost 0
145 Performance_schema_statement_classes_lost 0
146 Performance_schema_table_handles_lost 0
147 Performance_schema_table_instances_lost 0
148 Performance_schema_table_lock_stat_lost 0
149 Performance_schema_thread_classes_lost 0
150 Performance_schema_thread_instances_lost 0
151 Performance_schema_users_lost 0
152 select * from performance_schema.setup_consumers;
153 NAME ENABLED
154 select * from performance_schema.setup_instruments;
155 NAME ENABLED TIMED PROPERTIES FLAGS VOLATILITY DOCUMENTATION
156 select * from performance_schema.setup_actors;
157 HOST USER ROLE ENABLED HISTORY
158 select * from performance_schema.setup_objects;
159 OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME ENABLED TIMED
160 insert into performance_schema.setup_objects values ('TABLE', 'myschema', 'myobject', 'YES', 'YES');
161 ERROR HY000: Invalid performance_schema usage.
162 insert into performance_schema.setup_actors values ('myhost', 'mysuser', 'myrole', 'YES', 'YES');
163 ERROR HY000: Invalid performance_schema usage.
164 select * from performance_schema.setup_objects;
165 OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME ENABLED TIMED
166 update performance_schema.setup_objects set OBJECT_NAME = 'myobject';
167 delete from performance_schema.setup_objects;
168 select * from performance_schema.setup_actors;
169 HOST USER ROLE ENABLED HISTORY
170 update performance_schema.setup_actors set HOST = 'myhost';
171 delete from performance_schema.setup_actors;
172 truncate performance_schema.events_stages_history_long;
173 truncate performance_schema.events_statements_history_long;
174 truncate performance_schema.events_waits_history_long;
175 truncate performance_schema.setup_objects;
176 truncate performance_schema.setup_actors;
177 show global status like "performance_schema%_lost";
178 Variable_name Value
179 Performance_schema_accounts_lost 0
180 Performance_schema_cond_classes_lost 0
181 Performance_schema_cond_instances_lost 0
182 Performance_schema_digest_lost 0
183 Performance_schema_file_classes_lost 0
184 Performance_schema_file_handles_lost 0
185 Performance_schema_file_instances_lost 0
186 Performance_schema_hosts_lost 0
187 Performance_schema_index_stat_lost 0
188 Performance_schema_locker_lost 0
189 Performance_schema_memory_classes_lost 0
190 Performance_schema_metadata_lock_lost 0
191 Performance_schema_mutex_classes_lost 0
192 Performance_schema_mutex_instances_lost 0
193 Performance_schema_nested_statement_lost 0
194 Performance_schema_prepared_statements_lost 0
195 Performance_schema_program_lost 0
196 Performance_schema_rwlock_classes_lost 0
197 Performance_schema_rwlock_instances_lost 0
198 Performance_schema_session_connect_attrs_lost 0
199 Performance_schema_socket_classes_lost 0
200 Performance_schema_socket_instances_lost 0
201 Performance_schema_stage_classes_lost 0
202 Performance_schema_statement_classes_lost 0
203 Performance_schema_table_handles_lost 0
204 Performance_schema_table_instances_lost 0
205 Performance_schema_table_lock_stat_lost 0
206 Performance_schema_thread_classes_lost 0
207 Performance_schema_thread_instances_lost 0
208 Performance_schema_users_lost 0
209 show session status like "performance_schema%_lost";
210 Variable_name Value
211 Performance_schema_accounts_lost 0
212 Performance_schema_cond_classes_lost 0
213 Performance_schema_cond_instances_lost 0
214 Performance_schema_digest_lost 0
215 Performance_schema_file_classes_lost 0
216 Performance_schema_file_handles_lost 0
217 Performance_schema_file_instances_lost 0
218 Performance_schema_hosts_lost 0
219 Performance_schema_index_stat_lost 0
220 Performance_schema_locker_lost 0
221 Performance_schema_memory_classes_lost 0
222 Performance_schema_metadata_lock_lost 0
223 Performance_schema_mutex_classes_lost 0
224 Performance_schema_mutex_instances_lost 0
225 Performance_schema_nested_statement_lost 0
226 Performance_schema_prepared_statements_lost 0
227 Performance_schema_program_lost 0
228 Performance_schema_rwlock_classes_lost 0
229 Performance_schema_rwlock_instances_lost 0
230 Performance_schema_session_connect_attrs_lost 0
231 Performance_schema_socket_classes_lost 0
232 Performance_schema_socket_instances_lost 0
233 Performance_schema_stage_classes_lost 0
234 Performance_schema_statement_classes_lost 0
235 Performance_schema_table_handles_lost 0
236 Performance_schema_table_instances_lost 0
237 Performance_schema_table_lock_stat_lost 0
238 Performance_schema_thread_classes_lost 0
239 Performance_schema_thread_instances_lost 0
240 Performance_schema_users_lost 0
241 show global variables like "performance_schema";
242 Variable_name Value
243 performance_schema OFF
244 show session variables like "performance_schema";
245 Variable_name Value
246 performance_schema OFF