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 |
Meaning |
---|---|---|
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 |
page_id |
INTEGER |
Page of the replication log committed in the slave database |
offset |
INTEGER |
Offset of the replication log committed in the slave database |
log_record_time |
DATETIME |
Timestamp included in replication log committed in the slave database, i.e. the creation time of the log |
last_access_time |
DATETIME |
Time when applylogdb was committed in the slave database |
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 |
required_page_id |
INTEGER |
Minimum pageid that applylogdb can read |
start_time |
DATETIME |
Time when the applylogdb process accessed the slave database |