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

        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

                  Smart Checklist