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 count(*) from performance_schema.setup_timers;
19 count(*)
20 0
21 Warnings:
22 Warning 1287 'performance_schema.setup_timers' is deprecated and will be removed in a future release
23 select * from performance_schema.accounts;
24 select * from performance_schema.cond_instances;
25 select * from performance_schema.events_stages_current;
26 select * from performance_schema.events_stages_history;
27 select * from performance_schema.events_stages_history_long;
28 select * from performance_schema.events_stages_summary_by_account_by_event_name;
29 select * from performance_schema.events_stages_summary_by_host_by_event_name;
30 select * from performance_schema.events_stages_summary_by_thread_by_event_name;
31 select * from performance_schema.events_stages_summary_by_user_by_event_name;
32 select * from performance_schema.events_stages_summary_global_by_event_name;
33 select * from performance_schema.events_statements_current;
34 select * from performance_schema.events_statements_history;
35 select * from performance_schema.events_statements_history_long;
36 select * from performance_schema.events_statements_summary_by_account_by_event_name;
37 select * from performance_schema.events_statements_summary_by_digest;
38 select * from performance_schema.events_statements_summary_by_host_by_event_name;
39 select * from performance_schema.events_statements_summary_by_thread_by_event_name;
40 select * from performance_schema.events_statements_summary_by_user_by_event_name;
41 select * from performance_schema.events_statements_summary_global_by_event_name;
42 select * from performance_schema.events_transactions_current;
43 select * from performance_schema.events_transactions_history;
44 select * from performance_schema.events_transactions_history_long;
45 select * from performance_schema.events_transactions_summary_by_account_by_event_name;
46 select * from performance_schema.events_transactions_summary_by_host_by_event_name;
47 select * from performance_schema.events_transactions_summary_by_thread_by_event_name;
48 select * from performance_schema.events_transactions_summary_by_user_by_event_name;
49 select * from performance_schema.events_transactions_summary_global_by_event_name;
50 select * from performance_schema.events_waits_current;
51 select * from performance_schema.events_waits_history;
52 select * from performance_schema.events_waits_history_long;
53 select * from performance_schema.events_waits_summary_by_account_by_event_name;
54 select * from performance_schema.events_waits_summary_by_host_by_event_name;
55 select * from performance_schema.events_waits_summary_by_instance;
56 select * from performance_schema.events_waits_summary_by_thread_by_event_name;
57 select * from performance_schema.events_waits_summary_by_user_by_event_name;
58 select * from performance_schema.events_waits_summary_global_by_event_name;
59 select * from performance_schema.memory_summary_by_account_by_event_name;
60 select * from performance_schema.memory_summary_by_host_by_event_name;
61 select * from performance_schema.memory_summary_by_thread_by_event_name;
62 select * from performance_schema.memory_summary_by_user_by_event_name;
63 select * from performance_schema.memory_summary_global_by_event_name;
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.session_account_connect_attrs;
80 select * from performance_schema.session_connect_attrs;
81 select * from performance_schema.setup_actors;
82 select * from performance_schema.setup_consumers;
83 select * from performance_schema.setup_instruments;
84 select * from performance_schema.setup_objects;
85 select * from performance_schema.setup_timers;
86 select * from performance_schema.socket_instances;
87 select * from performance_schema.socket_summary_by_instance;
88 select * from performance_schema.socket_summary_by_event_name;
89 select * from performance_schema.table_handles;
90 select * from performance_schema.table_io_waits_summary_by_index_usage;
91 select * from performance_schema.table_io_waits_summary_by_table;
92 select * from performance_schema.table_lock_waits_summary_by_table;
93 select * from performance_schema.threads;
94 select * from performance_schema.users;
95 select * from performance_schema.replication_connection_configuration;
96 select * from performance_schema.replication_applier_configuration;
97 select * from performance_schema.replication_applier_status;
98 select * from performance_schema.replication_applier_status_by_coordinator;
99 select * from performance_schema.global_status;
100 select * from performance_schema.status_by_thread;
101 select * from performance_schema.status_by_user;
102 select * from performance_schema.status_by_host;
103 select * from performance_schema.status_by_account;
104 select * from performance_schema.session_status;
105 show global variables like "performance_schema%";
106 Variable_name Value
107 performance_schema OFF
108 performance_schema_accounts_size 100
109 performance_schema_digests_size 200
110 performance_schema_events_stages_history_long_size 1000
111 performance_schema_events_stages_history_size 10
112 performance_schema_events_statements_history_long_size 1000
113 performance_schema_events_statements_history_size 10
114 performance_schema_events_transactions_history_long_size 1000
115 performance_schema_events_transactions_history_size 10
116 performance_schema_events_waits_history_long_size 10000
117 performance_schema_events_waits_history_size 10
118 performance_schema_hosts_size 100
119 performance_schema_max_cond_classes 90
120 performance_schema_max_cond_instances 1500
121 performance_schema_max_digest_length 1024
122 performance_schema_max_file_classes 80
123 performance_schema_max_file_handles 32768
124 performance_schema_max_file_instances 10000
125 performance_schema_max_index_stat 5000
126 performance_schema_max_memory_classes 320
127 performance_schema_max_metadata_locks 10000
128 performance_schema_max_mutex_classes 210
129 performance_schema_max_mutex_instances 5000
130 performance_schema_max_prepared_statements_instances 100
131 performance_schema_max_program_instances 5000
132 performance_schema_max_rwlock_classes 50
133 performance_schema_max_rwlock_instances 5000
134 performance_schema_max_socket_classes 10
135 performance_schema_max_socket_instances 1000
136 performance_schema_max_sql_text_length 1024
137 performance_schema_max_stage_classes 160
138 performance_schema_max_statement_classes 223
139 performance_schema_max_statement_stack 10
140 performance_schema_max_table_handles 1000
141 performance_schema_max_table_instances 500
142 performance_schema_max_table_lock_stat 500
143 performance_schema_max_thread_classes 50
144 performance_schema_max_thread_instances 400
145 performance_schema_session_connect_attrs_size 2048
146 performance_schema_setup_actors_size 100
147 performance_schema_setup_objects_size 100
148 performance_schema_users_size 100
149 show engine PERFORMANCE_SCHEMA status;
150 show global status like "performance_schema%";
151 select * from information_schema.engines
152 where engine = "PERFORMANCE_SCHEMA";
153 ENGINE SUPPORT COMMENT TRANSACTIONS XA SAVEPOINTS
154 PERFORMANCE_SCHEMA YES Performance Schema NO NO NO
155 show status like "performance_schema%";
156 Variable_name Value
157 Performance_schema_accounts_lost 0
158 Performance_schema_cond_classes_lost 0
159 Performance_schema_cond_instances_lost 0
160 Performance_schema_digest_lost 0
161 Performance_schema_file_classes_lost 0
162 Performance_schema_file_handles_lost 0
163 Performance_schema_file_instances_lost 0
164 Performance_schema_hosts_lost 0
165 Performance_schema_index_stat_lost 0
166 Performance_schema_locker_lost 0
167 Performance_schema_memory_classes_lost 0
168 Performance_schema_metadata_lock_lost 0
169 Performance_schema_mutex_classes_lost 0
170 Performance_schema_mutex_instances_lost 0
171 Performance_schema_nested_statement_lost 0
172 Performance_schema_prepared_statements_lost 0
173 Performance_schema_program_lost 0
174 Performance_schema_rwlock_classes_lost 0
175 Performance_schema_rwlock_instances_lost 0
176 Performance_schema_session_connect_attrs_lost 0
177 Performance_schema_socket_classes_lost 0
178 Performance_schema_socket_instances_lost 0
179 Performance_schema_stage_classes_lost 0
180 Performance_schema_statement_classes_lost 0
181 Performance_schema_table_handles_lost 0
182 Performance_schema_table_instances_lost 0
183 Performance_schema_table_lock_stat_lost 0
184 Performance_schema_thread_classes_lost 0
185 Performance_schema_thread_instances_lost 0
186 Performance_schema_users_lost 0
187 show variables like "performance_schema";
188 Variable_name Value
189 performance_schema OFF
190 select * from performance_schema.setup_consumers;
191 NAME ENABLED
192 select * from performance_schema.setup_instruments;
193 NAME ENABLED TIMED
194 select * from performance_schema.setup_actors;
195 HOST USER ROLE ENABLED HISTORY
196 select * from performance_schema.setup_objects;
197 OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME ENABLED TIMED
198 select * from performance_schema.setup_timers;
199 NAME TIMER_NAME
200 Warnings:
201 Warning 1287 'performance_schema.setup_timers' is deprecated and will be removed in a future release
202 insert into performance_schema.setup_objects values ('TABLE', 'myschema', 'myobject', 'YES', 'YES');
203 ERROR HY000: Invalid performance_schema usage
204 insert into performance_schema.setup_actors values ('myhost', 'mysuser', 'myrole', 'YES', 'YES');
205 ERROR HY000: Invalid performance_schema usage
206 select * from performance_schema.setup_objects;
207 OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME ENABLED TIMED
208 update performance_schema.setup_objects set OBJECT_NAME = 'myobject';
209 delete from performance_schema.setup_objects;
210 select * from performance_schema.setup_actors;
211 HOST USER ROLE ENABLED HISTORY
212 update performance_schema.setup_actors set HOST = 'myhost';
213 delete from performance_schema.setup_actors;
214 truncate performance_schema.events_stages_history_long;
215 truncate performance_schema.events_statements_history_long;
216 truncate performance_schema.events_waits_history_long;
217 truncate performance_schema.setup_objects;
218 truncate performance_schema.setup_actors;
219 show global status like "performance_schema%";
220 Variable_name Value
221 Performance_schema_accounts_lost 0
222 Performance_schema_cond_classes_lost 0
223 Performance_schema_cond_instances_lost 0
224 Performance_schema_digest_lost 0
225 Performance_schema_file_classes_lost 0
226 Performance_schema_file_handles_lost 0
227 Performance_schema_file_instances_lost 0
228 Performance_schema_hosts_lost 0
229 Performance_schema_index_stat_lost 0
230 Performance_schema_locker_lost 0
231 Performance_schema_memory_classes_lost 0
232 Performance_schema_metadata_lock_lost 0
233 Performance_schema_mutex_classes_lost 0
234 Performance_schema_mutex_instances_lost 0
235 Performance_schema_nested_statement_lost 0
236 Performance_schema_prepared_statements_lost 0
237 Performance_schema_program_lost 0
238 Performance_schema_rwlock_classes_lost 0
239 Performance_schema_rwlock_instances_lost 0
240 Performance_schema_session_connect_attrs_lost 0
241 Performance_schema_socket_classes_lost 0
242 Performance_schema_socket_instances_lost 0
243 Performance_schema_stage_classes_lost 0
244 Performance_schema_statement_classes_lost 0
245 Performance_schema_table_handles_lost 0
246 Performance_schema_table_instances_lost 0
247 Performance_schema_table_lock_stat_lost 0
248 Performance_schema_thread_classes_lost 0
249 Performance_schema_thread_instances_lost 0
250 Performance_schema_users_lost 0
251 show session status like "performance_schema%";
252 Variable_name Value
253 Performance_schema_accounts_lost 0
254 Performance_schema_cond_classes_lost 0
255 Performance_schema_cond_instances_lost 0
256 Performance_schema_digest_lost 0
257 Performance_schema_file_classes_lost 0
258 Performance_schema_file_handles_lost 0
259 Performance_schema_file_instances_lost 0
260 Performance_schema_hosts_lost 0
261 Performance_schema_index_stat_lost 0
262 Performance_schema_locker_lost 0
263 Performance_schema_memory_classes_lost 0
264 Performance_schema_metadata_lock_lost 0
265 Performance_schema_mutex_classes_lost 0
266 Performance_schema_mutex_instances_lost 0
267 Performance_schema_nested_statement_lost 0
268 Performance_schema_prepared_statements_lost 0
269 Performance_schema_program_lost 0
270 Performance_schema_rwlock_classes_lost 0
271 Performance_schema_rwlock_instances_lost 0
272 Performance_schema_session_connect_attrs_lost 0
273 Performance_schema_socket_classes_lost 0
274 Performance_schema_socket_instances_lost 0
275 Performance_schema_stage_classes_lost 0
276 Performance_schema_statement_classes_lost 0
277 Performance_schema_table_handles_lost 0
278 Performance_schema_table_instances_lost 0
279 Performance_schema_table_lock_stat_lost 0
280 Performance_schema_thread_classes_lost 0
281 Performance_schema_thread_instances_lost 0
282 Performance_schema_users_lost 0