To control this, you can disable automatic statistics updates for such tables, and schedule a job that periodically runs .
Will it be safe before the fix for lp:1704195 (migrated to PS-2503)?
While automatic statistics updates usually work fine, there are cases when they do not do their job properly.
For example, Inno DB uses 20 sample 16K pages when it updates persistent statistics, and eight 16K pages when it updates transient statistics.
The article describes what if some long-running query starts and doesn't finish before The last two operations are usually fast, but they cannot finish if another query touched either the table share instance or acquired query cache mutex.And, in its turn, it cannot allow for incoming queries to start. Thus, old entries in the query cache will still be correct. Therefore, there is no need to remove it from the table definition cache. Today I wanted to look at the relative merits of different optimization paths that can be taken on a Greenfield project.This ensures that the author environment controls all traffic.
In other cases, such as for Communities features (for example, forums, blogs, comments, and reviews), the amount of user generated content (UGC) being entered in the publish environment is difficult to efficiently synchronize across AEM instances using replicaiton. Instead, the deployment for Communities requires a common store for UGC (see Community Content Storage).It might be very difficult to make any database changes to that other application. If the data has many access patterns to being served (i.e.