Uploaded image for project: 'Percona Server for MySQL'
  1. Percona Server for MySQL
  2. PS-1301

LP #1100643: InnoDB monitor reads in data pages needlessly

Details

    • Bug
    • Status: Done
    • High
    • Resolution: Fixed
    • None
    • None
    • None

    Description

      **Reported in Launchpad by Laurynas Biveinis last update 07-02-2013 05:18:32

      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.

      Attachments

        Activity

          People

            Unassigned Unassigned
            lpjirasync lpjirasync (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Smart Checklist