db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kristian Waagan (JIRA)" <j...@apache.org>
Subject [jira] Created: (DERBY-4940) Tune istat operational characteristics
Date Tue, 07 Dec 2010 21:21:09 GMT
Tune istat operational characteristics
--------------------------------------

                 Key: DERBY-4940
                 URL: https://issues.apache.org/jira/browse/DERBY-4940
             Project: Derby
          Issue Type: Sub-task
          Components: SQL
    Affects Versions: 10.8.0.0
            Reporter: Kristian Waagan


The istat feature relies in a few tuning parameters to work properly.
The main goals of the feature is to avoid stale statistics degrading query performance, and
at the same time not interfere too much with user activity. Some study of applications "in
the field" is necessary to properly size the set of parameters.

It is also clear that it is impossible to make the feature behave exactly as wanted for all
types of applications. Users that want full control of their statistics, can disable the istat
daemon and manually monitor and update the statistics.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message