Details

    • Type: Bug
    • Status: Done
    • Priority: Medium
    • Resolution: Fixed
    • Affects Version/s: 1.1.4
    • Fix Version/s: 1.2.0
    • Component/s: Grafana Dashboards
    • Labels:
      None
    • Sprint:
      27W2017Y (07/3-07/9), 28W2017Y (07/10-07/16 ) R

      Description

      Hi,

      I noticed this graph

      It does not pass sniff test as we're only doing page merges and no page splits... as such database should be "shrinking" while tpcc workload is growing database. Looking into the graph I see formula for Page Splits is:

      rate(mysql_info_schema_innodb_metrics_index_index_page_splits_total{instance="$host"}[$interval])/rate(mysql_info_schema_innodb_metrics_adaptive_hash_index_adaptive_hash_searches_btree_total{instance="$host"}[$interval]) or irate(mysql_info_schema_innodb_metrics_adaptive_hash_index_adaptive_hash_searches_total{instance="$host"}[$interval])/rate(mysql_info_schema_innodb_metrics_index_index_page_splits_total{instance="$host"}[5m])

      Which is obvious copy/paste error it should be:

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

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                nailya.kutlubaeva Nailya Kutlubaeva
                Reporter:
                pz Peter Zaitsev
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: