InnoDB monitor reads in data pages needlessly

Bug #1100643 reported by Laurynas Biveinis on 2013-01-17
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Server
Medium
Laurynas Biveinis
5.1
Medium
Laurynas Biveinis
5.5
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.

Related branches

lp:~laurynas-biveinis/percona-server/bug1100178-1100643-5.1
Stewart Smith (community): Approve on 2013-02-06
George Ormond Lorch III: Approve (g2) on 2013-02-05
lp:~laurynas-biveinis/percona-server/bug1100178-1100643-5.5
Stewart Smith (community): Approve on 2013-02-06
George Ormond Lorch III: Approve (g2) on 2013-02-04

5.1 affected too.

tags: added: xtradb
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers