Debian Codegraph @

mysql-test/suite/sys_vars/r/innodb_monitor_reset_basic.result

raw
1 set global innodb_monitor_disable = All;
2 select name, status from information_schema.innodb_metrics;
3 name status
4 metadata_table_handles_opened disabled
5 metadata_table_handles_closed disabled
6 metadata_table_reference_count disabled
7 lock_deadlocks disabled
8 lock_deadlock_false_positives disabled
9 lock_deadlock_rounds disabled
10 lock_threads_waiting disabled
11 lock_timeouts disabled
12 lock_rec_lock_waits disabled
13 lock_table_lock_waits disabled
14 lock_rec_lock_requests disabled
15 lock_rec_release_attempts disabled
16 lock_rec_grant_attempts disabled
17 lock_rec_lock_created disabled
18 lock_rec_lock_removed disabled
19 lock_rec_locks disabled
20 lock_table_lock_created disabled
21 lock_table_lock_removed disabled
22 lock_table_locks disabled
23 lock_row_lock_current_waits disabled
24 lock_row_lock_time disabled
25 lock_row_lock_time_max disabled
26 lock_row_lock_waits disabled
27 lock_row_lock_time_avg disabled
28 lock_schedule_refreshes disabled
29 buffer_pool_size disabled
30 buffer_pool_reads disabled
31 buffer_pool_read_requests disabled
32 buffer_pool_write_requests disabled
33 buffer_pool_wait_free disabled
34 buffer_pool_read_ahead disabled
35 buffer_pool_read_ahead_evicted disabled
36 buffer_pool_pages_total disabled
37 buffer_pool_pages_misc disabled
38 buffer_pool_pages_data disabled
39 buffer_pool_bytes_data disabled
40 buffer_pool_pages_dirty disabled
41 buffer_pool_bytes_dirty disabled
42 buffer_pool_pages_free disabled
43 buffer_pages_created disabled
44 buffer_pages_written disabled
45 buffer_pages_read disabled
46 buffer_data_reads disabled
47 buffer_data_written disabled
48 buffer_flush_batch_scanned disabled
49 buffer_flush_batch_num_scan disabled
50 buffer_flush_batch_scanned_per_call disabled
51 buffer_flush_batch_total_pages disabled
52 buffer_flush_batches disabled
53 buffer_flush_batch_pages disabled
54 buffer_flush_neighbor_total_pages disabled
55 buffer_flush_neighbor disabled
56 buffer_flush_neighbor_pages disabled
57 buffer_flush_n_to_flush_requested disabled
58 buffer_flush_n_to_flush_by_dirty_page disabled
59 buffer_flush_n_to_flush_by_age disabled
60 buffer_flush_adaptive_avg_time_slot disabled
61 buffer_LRU_batch_flush_avg_time_slot disabled
62 buffer_flush_adaptive_avg_time_thread disabled
63 buffer_LRU_batch_flush_avg_time_thread disabled
64 buffer_flush_adaptive_avg_time_est disabled
65 buffer_LRU_batch_flush_avg_time_est disabled
66 buffer_flush_avg_time disabled
67 buffer_flush_adaptive_avg_pass disabled
68 buffer_LRU_batch_flush_avg_pass disabled
69 buffer_flush_avg_pass disabled
70 buffer_LRU_get_free_loops disabled
71 buffer_LRU_get_free_waits disabled
72 buffer_flush_avg_page_rate disabled
73 buffer_flush_lsn_avg_rate disabled
74 buffer_flush_pct_for_dirty disabled
75 buffer_flush_pct_for_lsn disabled
76 buffer_flush_sync_waits disabled
77 buffer_flush_adaptive_total_pages disabled
78 buffer_flush_adaptive disabled
79 buffer_flush_adaptive_pages disabled
80 buffer_flush_sync_total_pages disabled
81 buffer_flush_sync disabled
82 buffer_flush_sync_pages disabled
83 buffer_flush_background_total_pages disabled
84 buffer_flush_background disabled
85 buffer_flush_background_pages disabled
86 buffer_LRU_batch_scanned disabled
87 buffer_LRU_batch_num_scan disabled
88 buffer_LRU_batch_scanned_per_call disabled
89 buffer_LRU_batch_flush_total_pages disabled
90 buffer_LRU_batches_flush disabled
91 buffer_LRU_batch_flush_pages disabled
92 buffer_LRU_batch_evict_total_pages disabled
93 buffer_LRU_batches_evict disabled
94 buffer_LRU_batch_evict_pages disabled
95 buffer_LRU_single_flush_scanned disabled
96 buffer_LRU_single_flush_num_scan disabled
97 buffer_LRU_single_flush_scanned_per_call disabled
98 buffer_LRU_single_flush_failure_count disabled
99 buffer_LRU_get_free_search disabled
100 buffer_LRU_search_scanned disabled
101 buffer_LRU_search_num_scan disabled
102 buffer_LRU_search_scanned_per_call disabled
103 buffer_LRU_unzip_search_scanned disabled
104 buffer_LRU_unzip_search_num_scan disabled
105 buffer_LRU_unzip_search_scanned_per_call disabled
106 buffer_page_read_index_leaf disabled
107 buffer_page_read_index_non_leaf disabled
108 buffer_page_read_index_ibuf_leaf disabled
109 buffer_page_read_index_ibuf_non_leaf disabled
110 buffer_page_read_undo_log disabled
111 buffer_page_read_index_inode disabled
112 buffer_page_read_ibuf_free_list disabled
113 buffer_page_read_ibuf_bitmap disabled
114 buffer_page_read_system_page disabled
115 buffer_page_read_trx_system disabled
116 buffer_page_read_fsp_hdr disabled
117 buffer_page_read_xdes disabled
118 buffer_page_read_blob disabled
119 buffer_page_read_zblob disabled
120 buffer_page_read_zblob2 disabled
121 buffer_page_read_rseg_array disabled
122 buffer_page_read_other disabled
123 buffer_page_written_index_leaf disabled
124 buffer_page_written_index_non_leaf disabled
125 buffer_page_written_index_ibuf_leaf disabled
126 buffer_page_written_index_ibuf_non_leaf disabled
127 buffer_page_written_undo_log disabled
128 buffer_page_written_index_inode disabled
129 buffer_page_written_ibuf_free_list disabled
130 buffer_page_written_ibuf_bitmap disabled
131 buffer_page_written_system_page disabled
132 buffer_page_written_trx_system disabled
133 buffer_page_written_fsp_hdr disabled
134 buffer_page_written_xdes disabled
135 buffer_page_written_blob disabled
136 buffer_page_written_zblob disabled
137 buffer_page_written_zblob2 disabled
138 buffer_page_written_rseg_array disabled
139 buffer_page_written_other disabled
140 buffer_page_written_on_log_no_waits disabled
141 buffer_page_written_on_log_waits disabled
142 buffer_page_written_on_log_wait_loops disabled
143 os_data_reads disabled
144 os_data_writes disabled
145 os_data_fsyncs disabled
146 os_pending_reads disabled
147 os_pending_writes disabled
148 os_log_bytes_written disabled
149 os_log_fsyncs disabled
150 os_log_pending_fsyncs disabled
151 os_log_pending_writes disabled
152 trx_rw_commits disabled
153 trx_ro_commits disabled
154 trx_nl_ro_commits disabled
155 trx_commits_insert_update disabled
156 trx_rollbacks disabled
157 trx_rollbacks_savepoint disabled
158 trx_rollback_active disabled
159 trx_active_transactions disabled
160 trx_allocations disabled
161 trx_on_log_no_waits disabled
162 trx_on_log_waits disabled
163 trx_on_log_wait_loops disabled
164 trx_rseg_history_len disabled
165 trx_undo_slots_used disabled
166 trx_undo_slots_cached disabled
167 trx_rseg_current_size disabled
168 purge_del_mark_records disabled
169 purge_upd_exist_or_extern_records disabled
170 purge_invoked disabled
171 purge_undo_log_pages disabled
172 purge_dml_delay_usec disabled
173 purge_stop_count disabled
174 purge_resume_count disabled
175 purge_truncate_history_count disabled
176 purge_truncate_history_usec disabled
177 undo_truncate_count disabled
178 undo_truncate_start_logging_count disabled
179 undo_truncate_done_logging_count disabled
180 undo_truncate_usec disabled
181 log_lsn_last_flush disabled
182 log_lsn_last_checkpoint disabled
183 log_lsn_current disabled
184 log_lsn_archived disabled
185 log_lsn_checkpoint_age disabled
186 log_lsn_buf_dirty_pages_added disabled
187 log_lsn_buf_pool_oldest_approx disabled
188 log_lsn_buf_pool_oldest_lwm disabled
189 log_max_modified_age_async disabled
190 log_max_modified_age_sync disabled
191 log_waits disabled
192 log_write_requests disabled
193 log_writes disabled
194 log_flush_total_time disabled
195 log_flush_max_time disabled
196 log_flush_avg_time disabled
197 log_flush_lsn_avg_rate disabled
198 log_full_block_writes disabled
199 log_partial_block_writes disabled
200 log_padded disabled
201 log_next_file disabled
202 log_checkpoints disabled
203 log_free_space disabled
204 log_concurrency_margin disabled
205 log_writer_no_waits disabled
206 log_writer_waits disabled
207 log_writer_wait_loops disabled
208 log_writer_on_file_space_waits disabled
209 log_writer_on_archiver_waits disabled
210 log_flusher_no_waits disabled
211 log_flusher_waits disabled
212 log_flusher_wait_loops disabled
213 log_write_notifier_no_waits disabled
214 log_write_notifier_waits disabled
215 log_write_notifier_wait_loops disabled
216 log_flush_notifier_no_waits disabled
217 log_flush_notifier_waits disabled
218 log_flush_notifier_wait_loops disabled
219 log_write_to_file_requests_interval disabled
220 log_on_write_no_waits disabled
221 log_on_write_waits disabled
222 log_on_write_wait_loops disabled
223 log_on_flush_no_waits disabled
224 log_on_flush_waits disabled
225 log_on_flush_wait_loops disabled
226 log_on_recent_written_wait_loops disabled
227 log_on_recent_closed_wait_loops disabled
228 log_on_buffer_space_no_waits disabled
229 log_on_buffer_space_waits disabled
230 log_on_buffer_space_wait_loops disabled
231 log_on_file_space_no_waits disabled
232 log_on_file_space_waits disabled
233 log_on_file_space_wait_loops disabled
234 compress_pages_compressed disabled
235 compress_pages_decompressed disabled
236 compression_pad_increments disabled
237 compression_pad_decrements disabled
238 index_page_splits disabled
239 index_page_merge_attempts disabled
240 index_page_merge_successful disabled
241 index_page_reorg_attempts disabled
242 index_page_reorg_successful disabled
243 index_page_discards disabled
244 adaptive_hash_searches disabled
245 adaptive_hash_searches_btree disabled
246 adaptive_hash_pages_added disabled
247 adaptive_hash_pages_removed disabled
248 adaptive_hash_rows_added disabled
249 adaptive_hash_rows_removed disabled
250 adaptive_hash_rows_deleted_no_hash_entry disabled
251 adaptive_hash_rows_updated disabled
252 file_num_open_files disabled
253 ibuf_merges_insert disabled
254 ibuf_merges_delete_mark disabled
255 ibuf_merges_delete disabled
256 ibuf_merges_discard_insert disabled
257 ibuf_merges_discard_delete_mark disabled
258 ibuf_merges_discard_delete disabled
259 ibuf_merges disabled
260 ibuf_size disabled
261 innodb_master_thread_sleeps disabled
262 innodb_activity_count disabled
263 innodb_master_active_loops disabled
264 innodb_master_idle_loops disabled
265 innodb_background_drop_table_usec disabled
266 innodb_ibuf_merge_usec disabled
267 innodb_mem_validate_usec disabled
268 innodb_master_purge_usec disabled
269 innodb_dict_lru_usec disabled
270 innodb_dict_lru_count disabled
271 innodb_dblwr_writes disabled
272 innodb_dblwr_pages_written disabled
273 innodb_page_size disabled
274 innodb_rwlock_s_spin_waits disabled
275 innodb_rwlock_x_spin_waits disabled
276 innodb_rwlock_sx_spin_waits disabled
277 innodb_rwlock_s_spin_rounds disabled
278 innodb_rwlock_x_spin_rounds disabled
279 innodb_rwlock_sx_spin_rounds disabled
280 innodb_rwlock_s_os_waits disabled
281 innodb_rwlock_x_os_waits disabled
282 innodb_rwlock_sx_os_waits disabled
283 dml_reads disabled
284 dml_inserts disabled
285 dml_deletes disabled
286 dml_updates disabled
287 dml_system_reads disabled
288 dml_system_inserts disabled
289 dml_system_deletes disabled
290 dml_system_updates disabled
291 sampled_pages_read disabled
292 sampled_pages_skipped disabled
293 ddl_background_drop_tables disabled
294 ddl_online_create_index disabled
295 ddl_pending_alter_table disabled
296 ddl_sort_file_alter_table disabled
297 ddl_log_file_alter_table disabled
298 icp_attempts disabled
299 icp_no_match disabled
300 icp_out_of_range disabled
301 icp_match disabled
302 module_cpu disabled
303 cpu_utime_abs disabled
304 cpu_stime_abs disabled
305 cpu_utime_pct disabled
306 cpu_stime_pct disabled
307 cpu_n disabled
308 module_page_track disabled
309 page_track_resets disabled
310 page_track_partial_block_writes disabled
311 page_track_full_block_writes disabled
312 page_track_checkpoint_partial_flush_request disabled
313 module_dblwr disabled
314 dblwr_async_requests disabled
315 dblwr_sync_requests disabled
316 dblwr_flush_requests disabled
317 dblwr_flush_wait_events disabled
318 set global innodb_monitor_enable = all;
319 create table monitor_test(col int) engine = innodb;
320 drop table monitor_test;
321 select name from information_schema.innodb_metrics where status!='enabled';
322 name
323 set global innodb_monitor_enable = aaa;
324 ERROR 42000: Variable 'innodb_monitor_enable' can't be set to the value of 'aaa'
325 set global innodb_monitor_disable = All;
326 select name from information_schema.innodb_metrics where status!='disabled';
327 name
328 set global innodb_monitor_reset_all = all;
329 select name from information_schema.innodb_metrics where count!=0;
330 name
331 set global innodb_monitor_enable = "%lock%";
332 select name from information_schema.innodb_metrics
333 where status != IF(name like "%lock%", 'enabled', 'disabled');
334 name
335 set global innodb_monitor_disable = "%lock%";
336 select name, status from information_schema.innodb_metrics
337 where name like "%lock%";
338 name status
339 lock_deadlocks disabled
340 lock_deadlock_false_positives disabled
341 lock_deadlock_rounds disabled
342 lock_threads_waiting disabled
343 lock_timeouts disabled
344 lock_rec_lock_waits disabled
345 lock_table_lock_waits disabled
346 lock_rec_lock_requests disabled
347 lock_rec_release_attempts disabled
348 lock_rec_grant_attempts disabled
349 lock_rec_lock_created disabled
350 lock_rec_lock_removed disabled
351 lock_rec_locks disabled
352 lock_table_lock_created disabled
353 lock_table_lock_removed disabled
354 lock_table_locks disabled
355 lock_row_lock_current_waits disabled
356 lock_row_lock_time disabled
357 lock_row_lock_time_max disabled
358 lock_row_lock_waits disabled
359 lock_row_lock_time_avg disabled
360 lock_schedule_refreshes disabled
361 log_full_block_writes disabled
362 log_partial_block_writes disabled
363 innodb_rwlock_s_spin_waits disabled
364 innodb_rwlock_x_spin_waits disabled
365 innodb_rwlock_sx_spin_waits disabled
366 innodb_rwlock_s_spin_rounds disabled
367 innodb_rwlock_x_spin_rounds disabled
368 innodb_rwlock_sx_spin_rounds disabled
369 innodb_rwlock_s_os_waits disabled
370 innodb_rwlock_x_os_waits disabled
371 innodb_rwlock_sx_os_waits disabled
372 page_track_partial_block_writes disabled
373 page_track_full_block_writes disabled
374 set global innodb_monitor_enable = "%lock*";
375 ERROR 42000: Variable 'innodb_monitor_enable' can't be set to the value of '%lock*'
376 set global innodb_monitor_enable="%%%%%%%%%%%%%%%%%%%%%%%%%%%";
377 select name from information_schema.innodb_metrics where status!='enabled';
378 name
379 set global innodb_monitor_disable="%%%%%";
380 select name from information_schema.innodb_metrics where status!='disabled';
381 name
382 set global innodb_monitor_enable="%";
383 select name from information_schema.innodb_metrics where status!='enabled';
384 name
385 set global innodb_monitor_disable="%_%";
386 select name from information_schema.innodb_metrics where status!='disabled';
387 name
388 set global innodb_monitor_enable="log%%%%";
389 select name from information_schema.innodb_metrics
390 where status != IF(name like "log%", 'enabled', 'disabled');
391 name
392 set global innodb_monitor_enable="os_%a_fs_ncs";
393 set global innodb_monitor_enable="os%pending%";
394 select name, status from information_schema.innodb_metrics
395 where name like "os%";
396 name status
397 os_data_reads disabled
398 os_data_writes disabled
399 os_data_fsyncs enabled
400 os_pending_reads enabled
401 os_pending_writes enabled
402 os_log_bytes_written disabled
403 os_log_fsyncs disabled
404 os_log_pending_fsyncs enabled
405 os_log_pending_writes enabled
406 set global innodb_monitor_enable="";
407 ERROR 42000: Variable 'innodb_monitor_enable' can't be set to the value of ''
408 set global innodb_monitor_enable="_";
409 ERROR 42000: Variable 'innodb_monitor_enable' can't be set to the value of '_'
410 SET global innodb_monitor_disable = module_metadata;
411 SET global innodb_monitor_reset_all = module_metadata;
412 set global innodb_monitor_enable = metadata_table_handles_opened;
413 create table monitor_test(col int) engine = innodb;
414 select * from monitor_test;
415 col
416 select name, max_count, min_count, count,
417 max_count_reset, min_count_reset, count_reset, status
418 from information_schema.innodb_metrics
419 where name = "metadata_table_handles_opened";
420 name max_count min_count count max_count_reset min_count_reset count_reset status
421 metadata_table_handles_opened 1 NULL 1 1 NULL 1 enabled
422 set global innodb_monitor_reset = metadata_table_handles_opened;
423 select name, max_count, min_count, count,
424 max_count_reset, min_count_reset, count_reset, status
425 from information_schema.innodb_metrics
426 where name = "metadata_table_handles_opened";
427 name max_count min_count count max_count_reset min_count_reset count_reset status
428 metadata_table_handles_opened 1 NULL 1 NULL NULL 0 enabled
429 drop table monitor_test;
430 create table monitor_test(col int) engine = innodb;
431 select * from monitor_test;
432 col
433 select name, max_count, min_count, count,
434 max_count_reset, min_count_reset, count_reset, status
435 from information_schema.innodb_metrics
436 where name = "metadata_table_handles_opened";
437 name max_count min_count count max_count_reset min_count_reset count_reset status
438 metadata_table_handles_opened 2 NULL 2 1 NULL 1 enabled
439 set global innodb_monitor_reset_all = metadata_table_handles_opened;
440 select name, max_count, min_count, count,
441 max_count_reset, min_count_reset, count_reset, status
442 from information_schema.innodb_metrics
443 where name = "metadata_table_handles_opened";
444 name max_count min_count count max_count_reset min_count_reset count_reset status
445 metadata_table_handles_opened 2 NULL 2 1 NULL 1 enabled
446 set global innodb_monitor_disable = metadata_table_handles_opened;
447 set global innodb_monitor_reset = metadata_table_handles_opened;
448 select name, max_count, min_count, count,
449 max_count_reset, min_count_reset, count_reset, status
450 from information_schema.innodb_metrics
451 where name = "metadata_table_handles_opened";
452 name max_count min_count count max_count_reset min_count_reset count_reset status
453 metadata_table_handles_opened 2 NULL 2 NULL NULL 0 disabled
454 drop table monitor_test;
455 create table monitor_test(col int) engine = innodb;
456 select * from monitor_test;
457 col
458 select name, max_count, min_count, count,
459 max_count_reset, min_count_reset, count_reset, status
460 from information_schema.innodb_metrics
461 where name = "metadata_table_handles_opened";
462 name max_count min_count count max_count_reset min_count_reset count_reset status
463 metadata_table_handles_opened 2 NULL 2 NULL NULL 0 disabled
464 set global innodb_monitor_reset_all = metadata_table_handles_opened;
465 select name, max_count, min_count, count,
466 max_count_reset, min_count_reset, count_reset, status
467 from information_schema.innodb_metrics
468 where name = "metadata_table_handles_opened";
469 name max_count min_count count max_count_reset min_count_reset count_reset status
470 metadata_table_handles_opened NULL NULL 0 NULL NULL 0 disabled
471 set global innodb_monitor_enable = metadata_table_handles_opened;
472 drop table monitor_test;
473 create table monitor_test(col int) engine = innodb stats_persistent=0;
474 select * from monitor_test;
475 col
476 select name, max_count, min_count, count,
477 max_count_reset, min_count_reset, count_reset, status
478 from information_schema.innodb_metrics
479 where name = "metadata_table_handles_opened";
480 name max_count min_count count max_count_reset min_count_reset count_reset status
481 metadata_table_handles_opened 1 NULL 1 1 NULL 1 enabled
482 set global innodb_monitor_enable = metadata_table_handles_closed;
483 create index idx on monitor_test(col);
484 select name, max_count, min_count, count,
485 max_count_reset, min_count_reset, count_reset, status
486 from information_schema.innodb_metrics
487 where name = "metadata_table_handles_closed";
488 name max_count min_count count max_count_reset min_count_reset count_reset status
489 metadata_table_handles_closed 1 NULL 1 1 NULL 1 enabled
490 select name, max_count, min_count, count,
491 max_count_reset, min_count_reset, count_reset, status
492 from information_schema.innodb_metrics
493 where name like "metadata%";
494 name max_count min_count count max_count_reset min_count_reset count_reset status
495 metadata_table_handles_opened 2 NULL 2 2 NULL 2 enabled
496 metadata_table_handles_closed 1 NULL 1 1 NULL 1 enabled
497 metadata_table_reference_count NULL NULL 0 NULL NULL 0 disabled
498 set global innodb_monitor_disable = module_metadata;
499 set global innodb_monitor_reset = module_metadata;
500 select name, max_count, min_count, count,
501 max_count_reset, min_count_reset, count_reset, status
502 from information_schema.innodb_metrics
503 where name like "metadata%";
504 name max_count min_count count max_count_reset min_count_reset count_reset status
505 metadata_table_handles_opened 2 NULL 2 NULL NULL 0 disabled
506 metadata_table_handles_closed 1 NULL 1 NULL NULL 0 disabled
507 metadata_table_reference_count NULL NULL 0 NULL NULL 0 disabled
508 set global innodb_monitor_reset_all = module_metadata;
509 select name, max_count, min_count, count,
510 max_count_reset, min_count_reset, count_reset, status
511 from information_schema.innodb_metrics
512 where name like "metadata%";
513 name max_count min_count count max_count_reset min_count_reset count_reset status
514 metadata_table_handles_opened NULL NULL 0 NULL NULL 0 disabled
515 metadata_table_handles_closed NULL NULL 0 NULL NULL 0 disabled
516 metadata_table_reference_count NULL NULL 0 NULL NULL 0 disabled
517 set global innodb_monitor_enable = module_trx;
518 begin;
519 insert into monitor_test values(9);
520 commit;
521 begin;
522 insert into monitor_test values(9);
523 rollback;
524 select name, max_count, min_count, count,
525 max_count_reset, min_count_reset, count_reset, status
526 from information_schema.innodb_metrics
527 where name like "trx_rollbacks" or name like "trx_active_transactions";
528 name max_count min_count count max_count_reset min_count_reset count_reset status
529 trx_rollbacks 1 NULL 1 1 NULL 1 enabled
530 trx_active_transactions 1 0 0 1 0 0 enabled
531 set global innodb_monitor_disable = module_trx;
532 set global innodb_monitor_enable = module_dml;
533 insert into monitor_test values(9);
534 update monitor_test set col = 10 where col = 9;
535 select name, max_count, min_count, count,
536 max_count_reset, min_count_reset, count_reset, status
537 from information_schema.innodb_metrics
538 where name like "dml%";
539 name max_count min_count count max_count_reset min_count_reset count_reset status
540 dml_reads 4 NULL 4 4 NULL 4 enabled
541 dml_inserts 1 NULL 1 1 NULL 1 enabled
542 dml_deletes 0 NULL 0 0 NULL 0 enabled
543 dml_updates 2 NULL 2 2 NULL 2 enabled
544 dml_system_reads 0 NULL 0 0 NULL 0 enabled
545 dml_system_inserts 0 NULL 0 0 NULL 0 enabled
546 dml_system_deletes 0 NULL 0 0 NULL 0 enabled
547 dml_system_updates 0 NULL 0 0 NULL 0 enabled
548 delete from monitor_test;
549 select name, max_count, min_count, count,
550 max_count_reset, min_count_reset, count_reset, status
551 from information_schema.innodb_metrics
552 where name like "dml%";
553 name max_count min_count count max_count_reset min_count_reset count_reset status
554 dml_reads 6 NULL 6 6 NULL 6 enabled
555 dml_inserts 1 NULL 1 1 NULL 1 enabled
556 dml_deletes 2 NULL 2 2 NULL 2 enabled
557 dml_updates 2 NULL 2 2 NULL 2 enabled
558 dml_system_reads 0 NULL 0 0 NULL 0 enabled
559 dml_system_inserts 0 NULL 0 0 NULL 0 enabled
560 dml_system_deletes 0 NULL 0 0 NULL 0 enabled
561 dml_system_updates 0 NULL 0 0 NULL 0 enabled
562 set global innodb_monitor_reset = module_dml;
563 select name, max_count, min_count, count,
564 max_count_reset, min_count_reset, count_reset, status
565 from information_schema.innodb_metrics
566 where name like "dml%";
567 name max_count min_count count max_count_reset min_count_reset count_reset status
568 dml_reads 6 NULL 6 0 NULL 0 enabled
569 dml_inserts 1 NULL 1 0 NULL 0 enabled
570 dml_deletes 2 NULL 2 0 NULL 0 enabled
571 dml_updates 2 NULL 2 0 NULL 0 enabled
572 dml_system_reads 0 NULL 0 0 NULL 0 enabled
573 dml_system_inserts 0 NULL 0 0 NULL 0 enabled
574 dml_system_deletes 0 NULL 0 0 NULL 0 enabled
575 dml_system_updates 0 NULL 0 0 NULL 0 enabled
576 insert into monitor_test values(9);
577 insert into monitor_test values(1);
578 delete from monitor_test;
579 select name, max_count, min_count, count,
580 max_count_reset, min_count_reset, count_reset, status
581 from information_schema.innodb_metrics
582 where name like "dml%";
583 name max_count min_count count max_count_reset min_count_reset count_reset status
584 dml_reads 8 NULL 8 2 NULL 2 enabled
585 dml_inserts 3 NULL 3 2 NULL 2 enabled
586 dml_deletes 4 NULL 4 2 NULL 2 enabled
587 dml_updates 2 NULL 2 0 NULL 0 enabled
588 dml_system_reads 0 NULL 0 0 NULL 0 enabled
589 dml_system_inserts 0 NULL 0 0 NULL 0 enabled
590 dml_system_deletes 0 NULL 0 0 NULL 0 enabled
591 dml_system_updates 0 NULL 0 0 NULL 0 enabled
592 set global innodb_monitor_reset_all = module_dml;
593 select name, max_count, min_count, count,
594 max_count_reset, min_count_reset, count_reset, status
595 from information_schema.innodb_metrics
596 where name like "dml%";
597 name max_count min_count count max_count_reset min_count_reset count_reset status
598 dml_reads 8 NULL 8 2 NULL 2 enabled
599 dml_inserts 3 NULL 3 2 NULL 2 enabled
600 dml_deletes 4 NULL 4 2 NULL 2 enabled
601 dml_updates 2 NULL 2 0 NULL 0 enabled
602 dml_system_reads 0 NULL 0 0 NULL 0 enabled
603 dml_system_inserts 0 NULL 0 0 NULL 0 enabled
604 dml_system_deletes 0 NULL 0 0 NULL 0 enabled
605 dml_system_updates 0 NULL 0 0 NULL 0 enabled
606 set global innodb_monitor_disable = module_dml;
607 select name, max_count, min_count, count,
608 max_count_reset, min_count_reset, count_reset, status
609 from information_schema.innodb_metrics
610 where name like "dml%";
611 name max_count min_count count max_count_reset min_count_reset count_reset status
612 dml_reads 8 NULL 8 2 NULL 2 disabled
613 dml_inserts 3 NULL 3 2 NULL 2 disabled
614 dml_deletes 4 NULL 4 2 NULL 2 disabled
615 dml_updates 2 NULL 2 0 NULL 0 disabled
616 dml_system_reads 0 NULL 0 0 NULL 0 disabled
617 dml_system_inserts 0 NULL 0 0 NULL 0 disabled
618 dml_system_deletes 0 NULL 0 0 NULL 0 disabled
619 dml_system_updates 0 NULL 0 0 NULL 0 disabled
620 set global innodb_monitor_reset_all = module_dml;
621 select name, max_count, min_count, count,
622 max_count_reset, min_count_reset, count_reset, status
623 from information_schema.innodb_metrics
624 where name like "dml%";
625 name max_count min_count count max_count_reset min_count_reset count_reset status
626 dml_reads NULL NULL 0 NULL NULL 0 disabled
627 dml_inserts NULL NULL 0 NULL NULL 0 disabled
628 dml_deletes NULL NULL 0 NULL NULL 0 disabled
629 dml_updates NULL NULL 0 NULL NULL 0 disabled
630 dml_system_reads NULL NULL 0 NULL NULL 0 disabled
631 dml_system_inserts NULL NULL 0 NULL NULL 0 disabled
632 dml_system_deletes NULL NULL 0 NULL NULL 0 disabled
633 dml_system_updates NULL NULL 0 NULL NULL 0 disabled
634 set global innodb_monitor_enable = dml_inserts;
635 insert into monitor_test values(9);
636 insert into monitor_test values(1);
637 delete from monitor_test;
638 select name, max_count, min_count, count,
639 max_count_reset, min_count_reset, count_reset, status
640 from information_schema.innodb_metrics
641 where name like "dml%";
642 name max_count min_count count max_count_reset min_count_reset count_reset status
643 dml_reads NULL NULL 0 NULL NULL 0 disabled
644 dml_inserts 2 NULL 2 2 NULL 2 enabled
645 dml_deletes NULL NULL 0 NULL NULL 0 disabled
646 dml_updates NULL NULL 0 NULL NULL 0 disabled
647 dml_system_reads NULL NULL 0 NULL NULL 0 disabled
648 dml_system_inserts NULL NULL 0 NULL NULL 0 disabled
649 dml_system_deletes NULL NULL 0 NULL NULL 0 disabled
650 dml_system_updates NULL NULL 0 NULL NULL 0 disabled
651 set global innodb_monitor_disable = module_dml;
652 drop table monitor_test;
653 set global innodb_monitor_enable = file_num_open_files;
654 select name, max_count, min_count, count,
655 max_count_reset, min_count_reset, count_reset, status
656 from information_schema.innodb_metrics
657 where name like "file_num_open_files";
658 name max_count min_count count max_count_reset min_count_reset count_reset status
659 file_num_open_files # # # # # # enabled
660 set global innodb_monitor_disable = file_num_open_files;
661 set global innodb_monitor_enable = "icp%";
662 create table monitor_test(a char(3), b int, c char(2),
663 primary key (a(1), c(1)), key(b)) engine = innodb;
664 insert into monitor_test values("13", 2, "aa");
665 select a from monitor_test where b < 1 for update;
666 a
667 select name, count from information_schema.innodb_metrics
668 where name like "icp%";
669 name count
670 icp_attempts 1
671 icp_no_match 0
672 icp_out_of_range 1
673 icp_match 0
674 select a from monitor_test where b < 3 for update;
675 a
676 13
677 select name, count from information_schema.innodb_metrics
678 where name like "icp%";
679 name count
680 icp_attempts 2
681 icp_no_match 0
682 icp_out_of_range 1
683 icp_match 1
684 drop table monitor_test;
685 set global innodb_monitor_disable = All;
686 set global innodb_monitor_reset_all = all;
687 set global innodb_monitor_reset_all=0xe7;
688 ERROR 42000: Variable 'innodb_monitor_reset_all' can't be set to the value of '\xE7'
689 set global innodb_monitor_enable =0xee;
690 ERROR 42000: Variable 'innodb_monitor_enable' can't be set to the value of '\xEE'
691 set global innodb_monitor_reset =0xe9;
692 ERROR 42000: Variable 'innodb_monitor_reset' can't be set to the value of '\xE9'
693 set global innodb_monitor_disable =0xed;
694 ERROR 42000: Variable 'innodb_monitor_disable' can't be set to the value of '\xED'