Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

Versions available for this page: CUBRID 8.3.0 |  CUBRID 8.3.1 |  CUBRID 8.4.0 |  CUBRID 8.4.1 |  CUBRID 8.4.3 |  CUBRID 9.0.0 | 

db_ha_apply_info

A table that stores the progress status every time the applylogdb utility applies replication logs. This table is updated at every point the applylogdb utility commits, and the acculmative count of operations are stored in the *_counter column. The meaning of each column is as follows:

Column Name

Column Type

Description

db_name

VARCHAR(255)

Name of the database stored in the log

db_creation_time

DATETIME

Creation time of the source database for the log to be applied

copied_log_path

VARCHAR(4096)

Path to the log file to be applied

committed_lsa_pageid

BIGINT

The page id of commit log lsa reflected last.
Although applylogdb is restarted, the logs before last_committed_lsa are not reflected again.

committed_lsa_offset

INTEGER

The offset of commit log lsa reflected last.
Although applylogdb is restarted, the logs before last_committed_lsa are not reflected again.

committed_rep_pageid

BIGINT

The page id of the replication log lsa reflected last.
Check whether the reflection of replication has been delayed or not.

committed_rep_offset

INTEGER

The offset of the replication log lsa reflected last.
Check whether the reflection of replication has been delayed or not.

append_lsa_page_id

BIGINT

The page id of the last replication log lsa at the last reflection.
Saves append_lsa of the replication log header that is being processed by applylogdb at the time of reflecting the replication.
Checks whether the reflection of replication has been delayed or not at the time of reflecting the replication log.

append_lsa_offset

INTEGER

The offset of the last replication log lsa at the last refelction.
Saves append_lsa of the replication log header that is being processed by applylogdb at the time of reflecting the replication.
Checks whether the reflection of replication has been delayed or not at the time of reflecting the replication log.

eof_lsa_page_id

BIGINT

The page id of the replication log eof lsa at the last reflection.
Saves eof_lsa of the replication log header that is being processed by applylogdb at the time of reflecting the replication.
Checks whether the reflection of replication has been delayed or not at the time of reflecting the replication log.

eof_lsa_offset

INTEGER

The offset of the replication log eof lsa at the last reflection.
Saves eof_lsa of the replication log header that is being processed by applylogdb at the time of reflecting the replication.
Checks whether the reflection of replication has been delayed or not at the time of reflecting the replication log.

final_lsa_pageid

BIGINT

The pageid of replication log lsa processed last by applylogdb.
Checks whether the reflection of replication has been delayed or not.

final_lsa_offset

INTEGER

The offset of replication log lsa processed last by applylogdb.
Checks whether the reflection of replication has been delayed or not.

required_page_id

BIGINT

The smallest page which should not be deleted by the log_max_archives parameter. The log page number from which the replication will be reflected.

required_page_offset

INTEGER

The offset of the log page from which the replication will be reflected.

log_record_time

DATETIME

Timestamp included in replication log committed in the slave database, i.e. the creation time of the log

log_commit_time

DATETIME

The time of reflecting the last commit log

last_access_time

DATETIME

The final update time of the db_ha_apply_info catalog

status

INTEGER

Progress status (0: IDLE, 1: BUSY)

insert_counter

BIGINT

Number of times that applylogdb was inserted

update_counter

BIGINT

Number of times that applylogdb was updated

delete_counter

BIGINT

Number of times that applylogdb was deleted

schema_counter

BIGINT

Number of times that applylogdb changed the schema

commit_counter

BIGINT

Number of times that applylogdb was committed

fail_counter

BIGINT

Number of times that applylogdb failed to be inserted/updated/deleted/committed and to change the schema

start_time

DATETIME

Time when the applylogdb process accessed the slave database