InnoDB monitor reads in data pages needlessly

Bug #1100643 reported by Laurynas Biveinis
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Server moved to https://jira.percona.com/projects/PS
Fix Released
Medium
Laurynas Biveinis
5.1
Fix Released
Medium
Laurynas Biveinis
5.5
Fix Released
Medium
Laurynas Biveinis

Bug Description

XtraDB introduces innodb_show_verbose_locks option. When it's 0 (the default), the detailed lock info is omitted from the InnoDB monitor output. But the relevant data pages are still being read in by lock_print_info_all_transactions():

   lock_mutex_exit_kernel();

   mtr_start(&mtr);

   buf_page_get_gen(space, zip_size, page_no, RW_NO_LATCH,
      NULL, BUF_GET_POSSIBLY_FREED,
      __FILE__, __LINE__, &mtr);

   mtr_commit(&mtr);

   load_page_first = FALSE;

   lock_mutex_enter_kernel();

This snippet-except for kernel mutex ops-should be guarded by if (srv_show_verbose_locks) check.

Tags: xtradb

Related branches

Revision history for this message
Laurynas Biveinis (laurynas-biveinis) wrote :

5.1 affected too.

tags: added: xtradb
Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-1301

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers