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

Add time acquiring locks graphs to Cluster and Replset MongoDB dashboards

    XMLWordPrintable

    Details

      Description

      Moving this issue in from our old repo: https://github.com/Percona-Lab/grafana_mongodb_dashboards/issues/36.

      Please add graphs for the metric 'mongodb_mongod_locks_time_acquiring_global_microseconds_total', showing the time spent waiting for locks in the server/engine. This is an increasing counter of microseconds, so I think we just need to use increase() on it.

      Please create 2 x graphs, one matching type="write", one matching type="read" to separate read vs write locks.

      On the Cluster page the lock graphs are most useful nearby the "Collection lock time" graph. The new graphs could probably just get added to the bottom for the Replset dash.

      Metric example:

      $ curl -s http://localhost:9104/metrics|grep acq
      # HELP mongodb_mongod_locks_time_acquiring_global_microseconds_total amount of time in microseconds that any database has spent waiting for the global lock
      # TYPE mongodb_mongod_locks_time_acquiring_global_microseconds_total counter
      mongodb_mongod_locks_time_acquiring_global_microseconds_total{database="Collection",type="read"} 0
      mongodb_mongod_locks_time_acquiring_global_microseconds_total{database="Collection",type="write"} 0
      mongodb_mongod_locks_time_acquiring_global_microseconds_total{database="Database",type="read"} 0
      mongodb_mongod_locks_time_acquiring_global_microseconds_total{database="Database",type="write"} 0
      mongodb_mongod_locks_time_acquiring_global_microseconds_total{database="Global",type="read"} 0
      mongodb_mongod_locks_time_acquiring_global_microseconds_total{database="Global",type="write"} 7497
      mongodb_mongod_locks_time_acquiring_global_microseconds_total{database="Metadata",type="read"} 0
      mongodb_mongod_locks_time_acquiring_global_microseconds_total{database="Metadata",type="write"} 0
      mongodb_mongod_locks_time_acquiring_global_microseconds_total{database="oplog",type="read"} 0
      mongodb_mongod_locks_time_acquiring_global_microseconds_total{database="oplog",type="write"} 0
      

        Smart Checklist

          Attachments

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              tim.vaillancourt Tim Vaillancourt (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated: