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

Remote bug watches

Bug watches keep track of this bug in other bug trackers.