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

RDS/Aurora disk related graphs are empty

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Priority: High
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.14.0
    • Component/s: Grafana Dashboards
    • Labels:
      None

      Description

      For AWS Aurora disk related (operations, latency, throughput) graphs are populated directly from CloudWatch. However, all data points are missing, because metrics are stored within RDSOSMetrics when enhanced monitoring is enabled.

      This can be fetched directly from Prometheus, as rds_exporter fetches this (from /enhanced route).

       

      [root@0abb803d12bc opt]# curl 127.0.0.1:9042/enhanced | grep -i 'read\|write'
      # HELP node_vmstat_pswpin Number of kilobytes the system has swapped in from disk per second (disk reads).
      # HELP node_vmstat_pswpout Number of kilobytes the system has swapped out to disk per second (disk writes).
      # HELP rdsosmetrics_diskIO_diskQueueDepth The number of outstanding read/write requests waiting to access the disk.
      # HELP rdsosmetrics_diskIO_readIOsPS The number of read operations per second. This metric is not available for Amazon Aurora.
      # TYPE rdsosmetrics_diskIO_readIOsPS gauge
      rdsosmetrics_diskIO_readIOsPS{id="0",instance="xx",region="us-east-1"} 0
      # HELP rdsosmetrics_diskIO_readLatency The average amount of time taken per disk I/O operation.
      # TYPE rdsosmetrics_diskIO_readLatency gauge
      rdsosmetrics_diskIO_readLatency{id="0",instance="xx",region="us-east-1"} 0
      [...]

       

        Smart Checklist

          Attachments

          1. PMM-2856 Image 1.png
            PMM-2856 Image 1.png
            131 kB
          2. rds-aurora1.png
            rds-aurora1.png
            117 kB
          3. rds-mysql56.png
            rds-mysql56.png
            124 kB
          4. rds-mysql57.png
            rds-mysql57.png
            114 kB
          5. Screenshot_20180828_125928.png
            Screenshot_20180828_125928.png
            206 kB

            Issue Links

              Activity

                People

                • Assignee:
                  Unassigned
                  Reporter:
                  iwo.panowicz Iwo Panowicz
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  5 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Time Tracking

                    Estimated:
                    Original Estimate - Not Specified
                    Not Specified
                    Remaining:
                    Remaining Estimate - 0 minutes
                    0m
                    Logged:
                    Time Spent - 5 hours, 30 minutes
                    5h 30m