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

LP #1264187: PS INNODB MUTEX Also needs Source File and Line Number

    Details

    • Type: Bug
    • Status: Done
    • Priority: Low
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None

      Description

      **Reported in Launchpad by Jervin R last update 26-02-2014 04:17:16

      From PS:

      InnoDB &buf_pool->LRU_list_mutex os_waits=34
      InnoDB &buf_pool->flush_list_mutex os_waits=14
      InnoDB &buf_pool->flush_state_mutex os_waits=233
      InnoDB &buf_pool->zip_mutex os_waits=10
      InnoDB &buf_pool->free_list_mutex os_waits=1
      InnoDB &buf_pool->LRU_list_mutex os_waits=33
      InnoDB &buf_pool->flush_list_mutex os_waits=17
      InnoDB &buf_pool->flush_state_mutex os_waits=228

      From upstream:

      InnoDB buf0buf.cc:1290 os_waits=144
      InnoDB buf0buf.cc:1244 os_waits=2593648
      InnoDB buf0buf.cc:1242 os_waits=12246520
      InnoDB buf0buf.cc:1290 os_waits=188
      InnoDB buf0buf.cc:1244 os_waits=2600430
      InnoDB buf0buf.cc:1242 os_waits=12439595

      Neither is very useful at first glance, if we can add the source file and line number on the PS output it would be a winner

        Smart Checklist

          Attachments

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: