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

Add ratio of AHI efficiency vs AHI overhead on AHI Maintainance Graph for InnoDB Metrics Advanced dashboard

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: New
    • Priority: Medium
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Grafana Dashboards
    • Labels:

      Description

      Hi

      [image: Inline image 1]

      This graph uses the most important (easy to explain) metric of AHI efficiency - Hits to Overhead ratio which should be plotted on the
      Right side and computed as:

      (adaptive_hash_searches-adaptive_hash_searches_btree)/(adaptive_hash_rows_added+adaptive_hash_rows_removed+adaptive_hash_rows_updated)

      The goal is to have this value high 3-5 or more in which case hits are likely to provide more value than the overhead they are causing

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                pz Peter Zaitsev
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated: