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

    XMLWordPrintable

    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: