Uploaded image for project: 'Percona Monitoring and Management'
  1. Percona Monitoring and Management
  2. PMM-1078

Provide chart for InnoDB Thread Concurrency, queries in queue

    Details

      Description

      Capture the innodb_thread_concurrency metrics in a chart on PMM - SHOW ENGINE INNODB STATUS has this data under "ROW OPERATIONS" section

      --------------
      ROW OPERATIONS
      --------------
      0 queries inside InnoDB, 0 queries in queue
      

      Attached is screenshot from New Relic MySQL plugin which has this metrics, this metrics is quite useful to understand if there were a lot of threads waiting inside InnoDB when innodb_thread_concurrency is set to a non zero value.

      Tasks

      1. Create Graph item on InnoDB Metrics dashboard
      2. Expose -collect.engine_innodb_status as a pmm-admin add mysql:metrics option such as --enable-engine-innodb-status
      3. Update documentation to highlight usage of --enable-engine-innodb-status

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                Neo Anderson Neo
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated: