Details

    • Type: Sub-task Sub-task
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 10.8.1.2
    • Fix Version/s: 10.8.1.2
    • Component/s: SQL
    • Labels:
      None
    • Issue & fix info:
      Release Note Needed

      Description

      Enable automatic updates and creations of index cardinality statistics, and wire the tests into the regression suite.

      1. releaseNote.html
        5 kB
        Knut Anders Hatlen
      2. releaseNote.html
        5 kB
        Knut Anders Hatlen
      3. releaseNote.html
        5 kB
        Rick Hillegas
      4. releaseNote.html
        5 kB
        Rick Hillegas
      5. derby-4939-1a-enable_istat.diff
        3 kB
        Kristian Waagan

        Issue Links

          Activity

          Hide
          Kristian Waagan added a comment -

          Closing issue, the feature has been enabled and most of the resulting problems have been resolved.
          I think we have JIRAs for the remaining bugs that surfaced when the feature was first enabled, none of which were considered show-stoppers for the release.

          Show
          Kristian Waagan added a comment - Closing issue, the feature has been enabled and most of the resulting problems have been resolved. I think we have JIRAs for the remaining bugs that surfaced when the feature was first enabled, none of which were considered show-stoppers for the release.
          Hide
          Rick Hillegas added a comment -

          Hi Dag,

          Those sound like reasonable improvements to the detailed release note for this issue. Feel free to post an improved note. Thanks.

          Show
          Rick Hillegas added a comment - Hi Dag, Those sound like reasonable improvements to the detailed release note for this issue. Feel free to post an improved note. Thanks.
          Hide
          Dag H. Wanvik added a comment -

          Small comment on the release notes:

          > "During query compilation, Derby now checks if the index cardinality statistics for the tables involved in the query are out of date. If > the statistics are outdated, the query compiler will schedule a job that updates them in a separate thread. "

          Strictly speaking, "out-of-date" is an elusive goal, we can't really claim more than a best shot using heuristics. So maybe we should
          qualify this statement to say something like "deemed out of date", and add a sentence to say that one can always force an update using SYSCS_UTIL.SYSCS_UPDATE_STATISTICS if the automation doesn't work well enough for an application?

          Show
          Dag H. Wanvik added a comment - Small comment on the release notes: > "During query compilation, Derby now checks if the index cardinality statistics for the tables involved in the query are out of date. If > the statistics are outdated, the query compiler will schedule a job that updates them in a separate thread. " Strictly speaking, "out-of-date" is an elusive goal, we can't really claim more than a best shot using heuristics. So maybe we should qualify this statement to say something like "deemed out of date", and add a sentence to say that one can always force an update using SYSCS_UTIL.SYSCS_UPDATE_STATISTICS if the automation doesn't work well enough for an application?
          Hide
          Andrew McIntyre added a comment -
          Show
          Andrew McIntyre added a comment -
          Hide
          Rick Hillegas added a comment -

          Re-attaching the 2011-03-03 release note since we have re-enabled istat=on as the default behavior for 10.8.1.

          Show
          Rick Hillegas added a comment - Re-attaching the 2011-03-03 release note since we have re-enabled istat=on as the default behavior for 10.8.1.
          Hide
          Rick Hillegas added a comment -

          Attaching a new version of the release note. This version describes the default 10.8.1 behavior: by default the istat daemon does not run automatically in 10.8.1.

          Show
          Rick Hillegas added a comment - Attaching a new version of the release note. This version describes the default 10.8.1 behavior: by default the istat daemon does not run automatically in 10.8.1.
          Hide
          Kristian Waagan added a comment -

          I added a bunch of links, with the following groups:

          • incorporates : bugs in the feature itself or in the new tests
          • breaks : existing tests broken by the new feature
          • is related to : various follow-up work, or changes required due to side-effects caused by the new feature
          Show
          Kristian Waagan added a comment - I added a bunch of links, with the following groups: incorporates : bugs in the feature itself or in the new tests breaks : existing tests broken by the new feature is related to : various follow-up work, or changes required due to side-effects caused by the new feature
          Hide
          Knut Anders Hatlen added a comment -

          Updated the release note to reflect that logging is now disabled by default.

          Show
          Knut Anders Hatlen added a comment - Updated the release note to reflect that logging is now disabled by default.
          Hide
          Rick Hillegas added a comment -

          Thanks for the release note, Knut. It looks good. It may need to be adjusted if you go ahead and disable the logging of statistics update events. Thanks.

          Show
          Rick Hillegas added a comment - Thanks for the release note, Knut. It looks good. It may need to be adjusted if you go ahead and disable the logging of statistics update events. Thanks.
          Hide
          Knut Anders Hatlen added a comment -

          Uploading a first attempt on a release note. Feel free to improve as needed.

          Show
          Knut Anders Hatlen added a comment - Uploading a first attempt on a release note. Feel free to improve as needed.
          Hide
          Knut Anders Hatlen added a comment -

          Reopening to allow attaching a release note.

          Show
          Knut Anders Hatlen added a comment - Reopening to allow attaching a release note.
          Hide
          Kristian Waagan added a comment -

          Closing issue.
          The feature has been enabled, and the first batch of errors has been partially addressed.
          I consider the situation as good enough such that there is no need to disable the feature at this point.

          Show
          Kristian Waagan added a comment - Closing issue. The feature has been enabled, and the first batch of errors has been partially addressed. I consider the situation as good enough such that there is no need to disable the feature at this point.
          Hide
          Kristian Waagan added a comment -

          Attached patch 1a, which enables the feature.

          I expect there will be issues to deal with, please bring them up on derby-dev and/or file JIRA issues.

          To disable the feature use derby.storage.indexStats.auto=false.
          See https://issues.apache.org/jira/browse/DERBY-4938?focusedCommentId=12992769&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-12992769 (or DERBY-4771) for more information on the available experimental (debug/troubleshooting) knobs.

          Committed to trunk with revision 1069598.

          Show
          Kristian Waagan added a comment - Attached patch 1a, which enables the feature. I expect there will be issues to deal with, please bring them up on derby-dev and/or file JIRA issues. To disable the feature use derby.storage.indexStats.auto=false. See https://issues.apache.org/jira/browse/DERBY-4938?focusedCommentId=12992769&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-12992769 (or DERBY-4771 ) for more information on the available experimental (debug/troubleshooting) knobs. Committed to trunk with revision 1069598.

            People

            • Assignee:
              Kristian Waagan
              Reporter:
              Kristian Waagan
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development