Problem Statement: Problem Statement



Yüklə 2,03 Mb.
səhifə7/25
tarix26.12.2016
ölçüsü2,03 Mb.
#3373
1   2   3   4   5   6   7   8   9   10   ...   25

Detection

  • The best way to detect if the logical log is a bottleneck is to look at the recent checkpoint activity:
    • The server keeps track of the last 20 checkpoints.
    • If a substantial portion of the recent checkpoints were triggered because of the logical log, then we should increase the logical log space by adding another logical log.
    • If a long transaction or checkpoint blocking occurs because of the logical log, we should also add another logical log to the log space.


Expansion

  • Expansion

    • We already have the adding logical logs dynamically feature:
      • DYNAMIC_LOGS 2 in the configuration file defined by $ONCONFIG environment variable.
        • Typically executes only when the server runs out of logical log space.
      • The server already contains the logic to extend a dbspace while adding a logical log.
    • There is a new, additional Logical Log expansion parameter in the configuration file called AUTO_LLOG



Yüklə 2,03 Mb.

Dostları ilə paylaş:
1   2   3   4   5   6   7   8   9   10   ...   25




Verilənlər bazası müəlliflik hüququ ilə müdafiə olunur ©azkurs.org 2024
rəhbərliyinə müraciət

gir | qeydiyyatdan keç
    Ana səhifə


yükləyin