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

Data from INFORMATION_SCHEMA cached for 24h

    XMLWordPrintable

    Details

    • Story Points:
      2
    • Sprint:
      Platform Sprint 22, Platform Sprint 23
    • Needs Review:
      Yes
    • Needs QA:
      Yes

      Description

      Based on https://www.percona.com/blog/2020/01/03/inconsistent-table-information-in-mysql-8-0-information_schema/

      The Problem: data received from INFORMATION_SCHEMA is cached for 24h so not really actual.

      We should add "set session information_schema_stats_expiry=0" MySQL Command to get better data.

      Note: This is session variable so we can change this on our side without impacting Database Server (Rule: don't change DB global settings is followed in this case )

      QA: we need to ensure the behavior and performance are not affected after this implementation

      Affected metrics are used for next elements:

      Dashboard Element
      MySQL_Table_Details Largest Tables by Row Count
      MySQL_InnoDB_Details Avg Row Size
        Index Size Per Row
        Estimated Rows

        Smart Checklist

          Attachments

            Activity

              People

              Assignee:
              jiri.ctvrtka Jiří Čtvrtka
              Reporter:
              roma.novikov Roma Novikov
              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 - Not Specified
                  Not Specified
                  Logged:
                  Time Spent - 2 days, 3 hours, 30 minutes
                  2d 3h 30m