XMLWordPrintable

    Details

    • Type: New Feature
    • Status: Done
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: 1.14.0
    • Component/s: Grafana Dashboards
    • Labels:

      Description

      The MySQL MyRocks Metrics dashboard is missing 
      couple of crucial information.
      I suggest to add equivalent of InnoDB Row Operations - "RocksDB Row Operations" graph, with series like:

      rate(mysql_global_status_rocksdb_rows_inserted{instance="$host"}[$interval]) or irate(mysql_global_status_rocksdb_rows_inserted{instance="$host"}[5m])
      

      &

      rate(mysql_global_status_rocksdb_rows_updated{instance="$host"}[$interval]) or irate(mysql_global_status_rocksdb_rows_updated{instance="$host"}[5m])
      

      &

      rate(mysql_global_status_rocksdb_rows_deleted{instance="$host"}[$interval]) or irate(mysql_global_status_rocksdb_rows_deleted{instance="$host"}[5m])
      

      Also, graph showing "Memtable Size", with for example:
      mysql_global_status_rocksdb_memtable_total/1024/1024 as Memtable Total MB
      and
      mysql_global_status_rocksdb_memtable_unflushed/1024/1024 as Memtable Unflushed MB

      Another graph IMHO worth adding: "RocksDB Stalls", including rate variables:

      • mysql_global_status_rocksdb_stall_micros (this one may be very fast growing, not like the others, so should be probably scaled differently)
      • mysql_global_status_rocksdb_stall_memtable_limit_slowdowns
      • mysql_global_status_rocksdb_stall_total_stops
        etc

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              przemyslaw.malkowski@percona.com Przemyslaw Malkowski
              Votes:
              0 Vote for this issue
              Watchers:
              4 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 - 2 hours
                  2h

                    Smart Checklist