日志机制
基本术语
redo log (redo log files )
wal segment file 16MB
xlog record(wal data) – 每个变更对应1条 行粒度
wal buffer
lsn(log sequence number)
checkpointer
checkpoint
sys_control
redo log buffer -> online redo log files -> archived redo log file
WAL参数解析
检查点参数解析
实验
WAL日志切换:
WAL段文件写满
archive_mode , archive_timeout
sys_switch_wal
切换时间设置多久合适?
sys_walfile_name
select sys_walfile_name(sys_current_wal_lsn());
sys_resetwal
sys_resetwal --help
sys_resetwal resets the Kingbase write-ahead log.
Usage:
sys_resetwal [OPTION]... DATADIR
Options:
-c, --commit-timestamp-ids=XID,XID
set oldest and newest transactions bearing
commit timestamp (zero means no change)
[-D, --kingbase-data=]DATADIR data directory
-e, --epoch=XIDEPOCH set next transaction ID epoch
-f, --force force update to be done
-g, --dbmode set database mode
-l, --next-wal-file=WALFILE set minimum starting location for new WAL
-m, --multixact-ids=MXID,MXID set next and oldest multitransaction ID
-n, --dry-run no update, just show what would be done
-o, --next-oid=OID set next OID
-O, --multixact-offset=OFFSET set next multitransaction offset
-V, --version output version information, then exit
-x, --next-transaction-id=XID set next transaction ID
--wal-segsize=SIZE size of WAL segments, in megabytes
-?, --help show this help, then exit
Report bugs to <kingbase-bugs@kingbase.com.cn>.
日志挖掘:sys_waldump
扩展
vastbase=# show checkpoint_
checkpoint_completion_target checkpoint_flush_after checkpoint_segments checkpoint_timeout checkpoint_wait_timeout checkpoint_warning
vastbase=# show checkpoint_segments ;
checkpoint_segments
---------------------
1024
(1 row)
vastbase=# show advance_xlog_file_num;
advance_xlog_file_num
-----------------------
10
(1 row)
vastbase=#