Examples of org.apache.derby.impl.services.daemon.IndexStatisticsDaemonImpl

Package org.apache.derby.impl.services.daemon

Examples of org.apache.derby.impl.services.daemon.IndexStatisticsDaemonImpl

org.apache.derby.impl.services.daemon.IndexStatisticsDaemonImpl
Daemon acting as a coordinator for creating and updating index cardinality statistics.
The need for updated statistics is currently determined when compiling a SELECT query. The unit of work is then scheduled with this daemon, and the work itself will be carried out in a separate thread. If the worker thread doesn't exist it is created, if it is idle the unit of work will be processed immediately, and if it is busy the unit of work has to wait in the queue.
The daemon code has a notion of a background task. If the update is run as a background task, it will try to affect other activity in the Derby database as little as possible. As far as possible, it will not set locks on the conglomerates it scans, and if it needs to take locks it will give up immediately if the locks cannot be obtained. In some cases it will also roll back to release locks already taken, ad then retry. Since we are accessing shared structures the background work may still interfere with the user activity in the database due to locking, but all such operations carried out by the daemon are of short duration.
The high level flow of an update to index statistics is:
1. schedule update (the only action carried out by the user thread)
3. for each index:
List of possible improvements:
1. Reduce potential impact of multiple invalidations (per table), probably by finding a way to invalidate only once after all indexes for a table have had their statistics updated. So far invalidation has proven to be the most difficult piece of the puzzle due to the interaction with the data dictionary and sensitivity to concurrent activity for the table.
Implementation notes: List of potential cleanups before going into a release:
1. Consider removing all tracing code. May involve improving logging if parts of the trace output is valuable enough.

        if (af.isReadOnly()) {
            indexStatsUpdateDisabled = true;
            return;
        }


        indexRefresher = new IndexStatisticsDaemonImpl(
                   Monitor.getStream(), indexStatsUpdateLogging,
                   indexStatsUpdateTracing, db, authorizationDatabaseOwner,
                   dbName);
    }

View Full Code Here

    private boolean qualifiesForStatisticsUpdateCheck(TableDescriptor td)
            throws StandardException {
        int qualifiedIndexes = 0;
        // Only base tables qualifies.
        if (td.getTableType() == TableDescriptor.BASE_TABLE_TYPE) {
            IndexStatisticsDaemonImpl istatDaemon = (IndexStatisticsDaemonImpl)
                    getDataDictionary().getIndexStatsRefresher(false);
            // Usually only tables with at least one non-unique index or
            // multi-column unique indexes qualify, but soft-upgrade mode is a
            // special case (as is the temporary user override available).
            // TODO: Rewrite if-logic when the temporary override is removed.

View Full Code Here

        if (af.isReadOnly()) {
            indexStatsUpdateDisabled = true;
            return;
        }


        indexRefresher = new IndexStatisticsDaemonImpl(
                   Monitor.getStream(), indexStatsUpdateLogging,
                   indexStatsUpdateTracing, db, authorizationDatabaseOwner,
                   dbName);
    }

View Full Code Here

    private boolean qualifiesForStatisticsUpdateCheck(TableDescriptor td)
            throws StandardException {
        int qualifiedIndexes = 0;
        // Only base tables qualifies.
        if (td.getTableType() == TableDescriptor.BASE_TABLE_TYPE) {
            IndexStatisticsDaemonImpl istatDaemon = (IndexStatisticsDaemonImpl)
                    getDataDictionary().getIndexStatsRefresher(false);
            // Usually only tables with at least one non-unique index or
            // multi-column unique indexes qualify, but soft-upgrade mode is a
            // special case (as is the temporary user override available).
            // TODO: Rewrite if-logic when the temporary override is removed.

View Full Code Here

        if (af.isReadOnly()) {
            indexStatsUpdateDisabled = true;
            return;
        }


        indexRefresher = new IndexStatisticsDaemonImpl(
                   Monitor.getStream(), indexStatsUpdateLogging,
                   indexStatsUpdateTracing, db, authorizationDatabaseOwner,
                   dbName);
    }

View Full Code Here

        if (af.isReadOnly()) {
            indexStatsUpdateDisabled = true;
            return;
        }


        indexRefresher = new IndexStatisticsDaemonImpl(
                   Monitor.getStream(), indexStatsUpdateLogging,
                   indexStatsUpdateTracing, db, authorizationDatabaseOwner,
                   dbName);
    }

View Full Code Here

    private boolean qualifiesForStatisticsUpdateCheck(TableDescriptor td)
            throws StandardException {
        int qualifiedIndexes = 0;
        // Only base tables qualifies.
        if (td.getTableType() == TableDescriptor.BASE_TABLE_TYPE) {
            IndexStatisticsDaemonImpl istatDaemon = (IndexStatisticsDaemonImpl)
                    getDataDictionary().getIndexStatsRefresher(false);
            // Usually only tables with at least one non-unique index or
            // multi-column unique indexes qualify, but soft-upgrade mode is a
            // special case (as is the temporary user override available).
            // TODO: Rewrite if-logic when the temporary override is removed.

View Full Code Here

        if (af.isReadOnly()) {
            indexStatsUpdateDisabled = true;
            return;
        }


        indexRefresher = new IndexStatisticsDaemonImpl(
                   Monitor.getStream(), indexStatsUpdateLogging,
                   indexStatsUpdateTracing, db, authorizationDatabaseOwner,
                   dbName);
    }

View Full Code Here

    private boolean qualifiesForStatisticsUpdateCheck(TableDescriptor td)
            throws StandardException {
        int qualifiedIndexes = 0;
        // Only base tables qualifies.
        if (td.getTableType() == TableDescriptor.BASE_TABLE_TYPE) {
            IndexStatisticsDaemonImpl istatDaemon = (IndexStatisticsDaemonImpl)
                    getDataDictionary().getIndexStatsRefresher(false);
            // Usually only tables with at least one non-unique index or
            // multi-column unique indexes qualify, but soft-upgrade mode is a
            // special case (as is the temporary user override available).
            // TODO: Rewrite if-logic when the temporary override is removed.

View Full Code Here

        if (af.isReadOnly()) {
            indexStatsUpdateDisabled = true;
            return;
        }


        indexRefresher = new IndexStatisticsDaemonImpl(
                   Monitor.getStream(), indexStatsUpdateLogging,
                   indexStatsUpdateTracing, db, authorizationDatabaseOwner,
                   dbName);
    }

View Full Code Here

0 1

TOP

Related Classes of org.apache.derby.impl.services.daemon.IndexStatisticsDaemonImpl

org.apache.derby.catalog.types.StatisticsImpl

org.apache.derby.catalog.UUID

org.apache.derby.iapi.services.context.ContextService

org.apache.derby.iapi.services.uuid.UUIDFactory

org.apache.derby.iapi.sql.depend.DependencyManager

org.apache.derby.iapi.sql.dictionary.ConglomerateDescriptor

org.apache.derby.iapi.sql.dictionary.DataDictionary

org.apache.derby.iapi.sql.dictionary.IndexRowGenerator

org.apache.derby.iapi.sql.dictionary.StatisticsDescriptor

org.apache.derby.iapi.sql.dictionary.TableDescriptor

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.