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

        Smart Checklist

          Attachments

          1. image-2018-05-31-15-50-46-114.png
            403 kB
            Roma Novikov
          2. Screenshot_20180531_133621.png
            30 kB
            Vadim Yalovets
          3. Screenshot_20180531_133720.png
            70 kB
            Vadim Yalovets
          4. Screenshot_20180531_133800.png
            15 kB
            Vadim Yalovets
          5. Screenshot_20180531_133815.png
            37 kB
            Vadim Yalovets

            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