Uploaded image for project: 'Percona Server'
  1. Percona Server
  2. PS-1830

LP #482454: userstats patch only updates I_S tables when handle is closed

    Details

    • Type: Bug
    • Status: Done
    • Priority: Low
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None

      Description

      **Reported in Launchpad by Ryan Lowe last update 25-06-2012 04:43:03

      The I_S tables are only updated with metrics when a table handle is closed (not handed back to the table cache). This means that well-tuned instances of MySQL can encounter situations where the stats don't get updated!!! I see 2 solutions to this:

      1 - Update the documentation to reflect in order to get a consistent read, you must issue FLUSH TABLES.
      2 - Change the call to update statistics when a table handle is passed back to the cache.

      The problem with #2 is if I have an instance with no table cache, the stats may never get updated.

      – Ryan Lowe

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                lpjirasync lpjirasync (Inactive)
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: