LightDB 手工开启增量检查点

原创姚崇 2023-11-30

216

1、在数据库初始化阶段

执行 -k 进行初始化
初始化后会在原本的同级别目录中多出data_increment和lt_data_increment文件夹

lt_initdb -p5433 -D /usr/local/lightdb/lightdb-x/13.8-23.3/cluster/data_increment -k
[lightdb@xncs206 cluster]$ ll
total 8
drwxrwxr-x  2 lightdb lightdb   70 Nov 29 13:33 archive
drwx------ 20 lightdb lightdb 4096 Nov 30 00:00 data
drwx------ 20 lightdb lightdb 4096 Nov 30 13:12 data_increment
drwxrwxr-x  3 lightdb lightdb   22 Nov 23 16:43 lt_data
drwxrwxr-x  3 lightdb lightdb   22 Nov 30 13:12 lt_data_increment

$ lt_initdb --help

lt_initdb initializes a LightDB database cluster.

Usage:
  lt_initdb [OPTION]... [DATADIR]

Less commonly used options:
  -d, --debug               generate lots of debugging output
  -k, --data-checksums      use data page checksums
... ...
复制

lt_initdb -k 是 LightDB 中的一个参数，它用于初始化数据库集群时启用数据页校验和（data page checksums）。数据页面校验和是一种技术，用于检测数据文件中的错误或损坏。

当使用 lt_initdb 命令初始化数据库时，可以使用 -k 或 --data-checksums 参数，以便在数据库集群中启用数据页面校验和。一旦启用了数据页面校验，LightDB将对数据页中的内容计算校验，并将其存储在数据文件中。在读取数据页时，将再次计算校验和并与存储的校验和进行比较，以检测数据文件中的错误或损坏。

开启增量检查点GUC参数

enable_incremental_checkpoint = on
enable_double_write = on
复制

增量检查点日志解读

开启增量检查点后，默认$LTDATA/log中会记录相关信息

2023-11-30 14:53:55.760421T,,,,,checkpointer,,00000,2023-11-30 13:29:10 CST,0,334993,LOG:  [Batch flush] DW truncate end: file_head[dwn 4, start 3297], total_pages 0
2023-11-30 14:53:55.861001T,,,,,checkpointer,,00000,2023-11-30 13:29:10 CST,0,334993,LOG:  [Batch flush] DW truncate end: file_head[dwn 4, start 22462], total_pages 0
2023-11-30 14:53:55.863255T,,,,,checkpointer,,00000,2023-11-30 13:29:10 CST,0,334993,LOG:  checkpoint complete(mode=incremental): wrote 0 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.001 s, sync=0.302 s, total=0.305 s; sync files=0, lo
ngest=0.000 s, average=0.000 s; distance=110743 kB, estimate=1414180 kB
2023-11-30 14:53:58.516474T,,,,,page writer main process,,00000,2023-11-30 13:29:10 CST,0,334994,LOG:  Pagewriter main thread get requested_flush_num = 818, dirty rate = 227.85, dirty percent = 0.02
2023-11-30 14:54:04.878089T,,,,,page writer main process,,00000,2023-11-30 13:29:10 CST,0,334994,LOG:  Pagewriter main thread get requested_flush_num = 818, dirty rate = 334.33, dirty percent = 0.02
2023-11-30 14:54:11.238122T,,,,,page writer main process,,00000,2023-11-30 13:29:10 CST,0,334994,LOG:  Pagewriter main thread get requested_flush_num = 818, dirty rate = 251.08, dirty percent = 0.02
2023-11-30 14:54:17.598150T,,,,,page writer main process,,00000,2023-11-30 13:29:10 CST,0,334994,LOG:  Pagewriter main thread get requested_flush_num = 818, dirty rate = 231.98, dirty percent = 0.02
2023-11-30 14:54:23.958488T,,,,,page writer main process,,00000,2023-11-30 13:29:10 CST,0,334994,LOG:  Pagewriter main thread get requested_flush_num = 818, dirty rate = 215.50, dirty percent = 0.02
2023-11-30 14:54:30.317980T,,,,,page writer main process,,00000,2023-11-30 13:29:10 CST,0,334994,LOG:  Pagewriter main thread get requested_flush_num = 818, dirty rate = 235.60, dirty percent = 0.02
2023-11-30 14:54:36.679390T,,,,,page writer main process,,00000,2023-11-30 13:29:10 CST,0,334994,LOG:  Pagewriter main thread get requested_flush_num = 818, dirty rate = 316.45, dirty percent = 0.02
2023-11-30 14:54:43.039586T,,,,,page writer main process,,00000,2023-11-30 13:29:10 CST,0,334994,LOG:  Pagewriter main thread get requested_flush_num = 818, dirty rate = 221.99, dirty percent = 0.02
2023-11-30 14:54:49.406567T,,,,,page writer main process,,00000,2023-11-30 13:29:10 CST,0,334994,LOG:  Pagewriter main thread get requested_flush_num = 826, dirty rate = 232.16, dirty percent = 0.02
2023-11-30 14:54:55.768057T,,,,,page writer main process,,00000,2023-11-30 13:29:10 CST,0,334994,LOG:  Pagewriter main thread get requested_flush_num = 886, dirty rate = 211.77, dirty percent = 0.02
2023-11-30 14:54:55.873477T,,,,,checkpointer,,00000,2023-11-30 13:29:10 CST,0,334993,LOG:  checkpoint starting(mode=incremental): time
2023-11-30 14:54:56.075297T,,,,,checkpointer,,00000,2023-11-30 13:29:10 CST,0,334993,LOG:  [Batch flush] DW truncate end: file_head[dwn 4, start 5845], total_pages 0
2023-11-30 14:54:56.176015T,,,,,checkpointer,,00000,2023-11-30 13:29:10 CST,0,334993,LOG:  [Batch flush] DW truncate end: file_head[dwn 5, start 2880], total_pages 0
2023-11-30 14:54:56.178212T,,,,,checkpointer,,00000,2023-11-30 13:29:10 CST,0,334993,LOG:  checkpoint complete(mode=incremental): wrote 0 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.000 s, sync=0.302 s, total=0.305 s; sync files=0, lo
ngest=0.000 s, average=0.000 s; distance=100347 kB, estimate=1282797 kB
2023-11-30 14:55:02.133500T,,,,,page writer main process,,00000,2023-11-30 13:29:10 CST,0,334994,LOG:  Pagewriter main thread get requested_flush_num = 818, dirty rate = 266.43, dirty percent = 0.02
2023-11-30 14:55:08.468966T,,,,,page writer main process,,00000,2023-11-30 13:29:10 CST,0,334994,LOG:  Pagewriter main thread get requested_flush_num = 818, dirty rate = 319.53, dirty percent = 0.02
2023-11-30 14:55:14.801178T,,,,,page writer main process,,00000,2023-11-30 13:29:10 CST,0,334994,LOG:  Pagewriter main thread get requested_flush_num = 818, dirty rate = 212.70, dirty percent = 0.02
2023-11-30 14:55:21.161491T,,,,,page writer main process,,00000,2023-11-30 13:29:10 CST,0,334994,LOG:  Pagewriter main thread get requested_flush_num = 818, dirty rate = 245.07, dirty percent = 0.02
2023-11-30 14:55:27.523026T,,,,,page writer main process,,00000,2023-11-30 13:29:10 CST,0,334994,LOG:  Pagewriter main thread get requested_flush_num = 818, dirty rate = 183.68, dirty percent = 0.02
2023-11-30 14:55:33.881736T,,,,,page writer main process,,00000,2023-11-30 13:29:10 CST,0,334994,LOG:  Pagewriter main thread get requested_flush_num = 818, dirty rate = 264.22, dirty percent = 0.02
2023-11-30 14:55:40.242749T,,,,,page writer main process,,00000,2023-11-30 13:29:10 CST,0,334994,LOG:  Pagewriter main thread get requested_flush_num = 818, dirty rate = 333.77, dirty percent = 0.02
2023-11-30 14:55:46.602731T,,,,,page writer main process,,00000,2023-11-30 13:29:10 CST,0,334994,LOG:  Pagewriter main thread get requested_flush_num = 818, dirty rate = 194.73, dirty percent = 0.02
2023-11-30 14:55:52.962386T,,,,,page writer main process,,00000,2023-11-30 13:29:10 CST,0,334994,LOG:  Pagewriter main thread get requested_flush_num = 834, dirty rate = 263.07, dirty percent = 0.02
2023-11-30 14:55:55.237934T,,,,,checkpointer,,00000,2023-11-30 13:29:10 CST,0,334993,LOG:  checkpoint starting(mode=incremental): time
2023-11-30 14:55:55.439766T,,,,,checkpointer,,00000,2023-11-30 13:29:10 CST,0,334993,LOG:  [Batch flush] DW truncate end: file_head[dwn 4, start 9136], total_pages 0
2023-11-30 14:55:55.540351T,,,,,checkpointer,,00000,2023-11-30 13:29:10 CST,0,334993,LOG:  [Batch flush] DW truncate end: file_head[dwn 5, start 14440], total_pages 0
2023-11-30 14:55:55.542704T,,,,,checkpointer,,00000,2023-11-30 13:29:10 CST,0,334993,LOG:  checkpoint complete(mode=incremental): wrote 0 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.000 s, sync=0.302 s, total=0.305 s; sync files=0, lo
ngest=0.000 s, average=0.000 s; distance=108997 kB, estimate=1165417 kB
2023-11-30 14:55:59.328851T,,,,,page writer main process,,00000,2023-11-30 13:29:10 CST,0,334994,LOG:  Pagewriter main thread get requested_flush_num = 894, dirty rate = 215.46, dirty percent = 0.02
2023-11-30 14:56:05.689121T,,,,,page writer main process,,00000,2023-11-30 13:29:10 CST,0,334994,LOG:  Pagewriter main thread get requested_flush_num = 818, dirty rate = 230.47, dirty percent = 0.02
2023-11-30 14:56:12.049588T,,,,,page writer main process,,00000,2023-11-30 13:29:10 CST,0,334994,LOG:  Pagewriter main thread get requested_flush_num = 818, dirty rate = 366.70, dirty percent = 0.02
2023-11-30 14:56:18.408821T,,,,,page writer main process,,00000,2023-11-30 13:29:10 CST,0,334994,LOG:  Pagewriter main thread get requested_flush_num = 818, dirty rate = 194.94, dirty percent = 0.02
2023-11-30 14:56:24.768877T,,,,,page writer main process,,00000,2023-11-30 13:29:10 CST,0,334994,LOG:  Pagewriter main thread get requested_flush_num = 818, dirty rate = 264.59, dirty percent = 0.02
2023-11-30 14:56:31.128594T,,,,,page writer main process,,00000,2023-11-30 13:29:10 CST,0,334994,LOG:  Pagewriter main thread get requested_flush_num = 818, dirty rate = 212.91, dirty percent = 0.02
2023-11-30 14:56:37.489235T,,,,,page writer main process,,00000,2023-11-30 13:29:10 CST,0,334994,LOG:  Pagewriter main thread get requested_flush_num = 818, dirty rate = 231.51, dirty percent = 0.02
2023-11-30 14:56:43.848687T,,,,,page writer main process,,00000,2023-11-30 13:29:10 CST,0,334994,LOG:  Pagewriter main thread get requested_flush_num = 818, dirty rate = 331.40, dirty percent = 0.11
2023-11-30 14:56:50.211356T,,,,,page writer main process,,00000,2023-11-30 13:29:10 CST,0,334994,LOG:  Pagewriter main thread get requested_flush_num = 826, dirty rate = 1480.19, dirty percent = 0.28
2023-11-30 14:56:55.593408T,,,,,checkpointer,,00000,2023-11-30 13:29:10 CST,0,334993,LOG:  checkpoint starting(mode=incremental): time
2023-11-30 14:56:55.795564T,,,,,checkpointer,,00000,2023-11-30 13:29:10 CST,0,334993,LOG:  [Batch flush] DW truncate end: file_head[dwn 4, start 15061], total_pages 0
2023-11-30 14:56:55.896319T,,,,,checkpointer,,00000,2023-11-30 13:29:10 CST,0,334993,LOG:  [Batch flush] DW truncate end: file_head[dwn 5, start 24819], total_pages 0
2023-11-30 14:56:55.898738T,,,,,checkpointer,,00000,2023-11-30 13:29:10 CST,0,334993,LOG:  checkpoint complete(mode=incremental): wrote 0 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.000 s, sync=0.302 s, total=0.306 s; sync files=0, lo
ngest=0.000 s, average=0.000 s; distance=104169 kB, estimate=1059292 kB
2023-11-30 14:56:56.579166T,,,,,page writer main process,,00000,2023-11-30 13:29:10 CST,0,334994,LOG:  Pagewriter main thread get requested_flush_num = 878, dirty rate = 2663.78, dirty percent = 0.45
2023-11-30 14:57:02.926279T,,,,,page writer main process,,00000,2023-11-30 13:29:10 CST,0,334994,LOG:  Pagewriter main thread get requested_flush_num = 924, dirty rate = 3132.43, dirty percent = 0.54
2023-11-30 14:57:04.491397T,,,,,autovacuum worker,,00000,2023-11-30 14:56:40 CST,0,388970,LOG:  [Single flush] Reset DW file: file_head[dwn 67, start 0], write pos is 0
2023-11-30 14:57:04.491397T,,,,,autovacuum worker,,00000,2023-11-30 14:56:40 CST,0,388970,CONTEXT:  while scanning block 65945 of relation "hs_prd.prd_busin_entrust"
2023-11-30 14:57:09.291345T,,,,,page writer main process,,00000,2023-11-30 13:29:10 CST,0,334994,LOG:  Pagewriter main thread get requested_flush_num = 983, dirty rate = 3084.79, dirty percent = 0.54
2023-11-30 14:57:15.638569T,,,,,page writer main process,,00000,2023-11-30 13:29:10 CST,0,334994,LOG:  Pagewriter main thread get requested_flush_num = 818, dirty rate = 2551.66, dirty percent = 0.53
2023-11-30 14:57:18.279130T,,,,,autovacuum worker,,00000,2023-11-30 14:56:40 CST,0,388970,LOG:  [Single flush] Reset DW file: file_head[dwn 68, start 0], write pos is 0
2023-11-30 14:57:18.279130T,,,,,autovacuum worker,,00000,2023-11-30 14:56:40 CST,0,388970,CONTEXT:  while scanning block 100197 of relation "hs_prd.prd_busin_entrust"
2023-11-30 14:57:22.062764T,,,,,page writer main process,,00000,2023-11-30 13:29:10 CST,0,334994,LOG:  Pagewriter main thread get requested_flush_num = 818, dirty rate = 2767.82, dirty percent = 0.54
2023-11-30 14:57:28.426140T,,,,,page writer main process,,00000,2023-11-30 13:29:10 CST,0,334994,LOG:  Pagewriter main thread get requested_flush_num = 818, dirty rate = 2472.40, dirty percent = 0.53
2023-11-30 14:57:33.029103T,,,,,autovacuum worker,,00000,2023-11-30 14:56:40 CST,0,388970,LOG:  [Single flush] Reset DW file: file_head[dwn 69, start 0], write pos is 0
2023-11-30 14:57:33.029103T,,,,,autovacuum worker,,00000,2023-11-30 14:56:40 CST,0,388970,CONTEXT:  while scanning block 136764 of relation "hs_prd.prd_busin_entrust"
2023-11-30 14:57:34.808028T,,,,,page writer main process,,00000,2023-11-30 13:29:10 CST,0,334994,LOG:  Pagewriter main thread get requested_flush_num = 818, dirty rate = 2746.39, dirty percent = 0.53
2023-11-30 14:57:41.145050T,,,,,page writer main process,,00000,2023-11-30 13:29:10 CST,0,334994,LOG:  Pagewriter main thread get requested_flush_num = 818, dirty rate = 2758.34, dirty percent = 0.54
2023-11-30 14:57:47.480735T,,,,,page writer main process,,00000,2023-11-30 13:29:10 CST,0,334994,LOG:  Pagewriter main thread get requested_flush_num = 818, dirty rate = 2587.42, dirty percent = 0.53
2023-11-30 14:57:48.189066T,,,,,autovacuum worker,,00000,2023-11-30 14:56:40 CST,0,388970,LOG:  [Single flush] Reset DW file: file_head[dwn 70, start 0], write pos is 0
2023-11-30 14:57:48.189066T,,,,,autovacuum worker,,00000,2023-11-30 14:56:40 CST,0,388970,CONTEXT:  while scanning block 174905 of relation "hs_prd.prd_busin_entrust"
2023-11-30 14:57:53.892232T,,,,,page writer main process,,00000,2023-11-30 13:29:10 CST,0,334994,LOG:  Pagewriter main thread get requested_flush_num = 818, dirty rate = 2771.99, dirty percent = 0.53
2023-11-30 14:57:55.959749T,,,,,checkpointer,,00000,2023-11-30 13:29:10 CST,0,334993,LOG:  checkpoint starting(mode=incremental): time
2023-11-30 14:57:56.161889T,,,,,checkpointer,,00000,2023-11-30 13:29:10 CST,0,334993,LOG:  [Batch flush] DW truncate end: file_head[dwn 4, start 27462], total_pages 0
2023-11-30 14:57:56.262721T,,,,,checkpointer,,00000,2023-11-30 13:29:10 CST,0,334993,LOG:  [Batch flush] DW truncate end: file_head[dwn 6, start 6557], total_pages 0
2023-11-30 14:57:56.363368T,,,,,checkpointer,,00000,2023-11-30 13:29:10 CST,0,334993,LOG:  [Single flush] DW truncate end: file_head[dwn 70, start 19189], write_pos 19436
2023-11-30 14:57:56.366100T,,,,,checkpointer,,00000,2023-11-30 13:29:10 CST,0,334993,LOG:  checkpoint complete(mode=incremental): wrote 0 buffers (0.0%); 0 WAL file(s) added, 0 removed, 1 recycled; write=0.000 s, sync=0.403 s, total=0.407 s; sync files=0, lo
ngest=0.000 s, average=0.000 s; distance=99871 kB, estimate=963350 kB
2023-11-30 14:58:00.255989T,,,,,page writer main process,,00000,2023-11-30 13:29:10 CST,0,334994,LOG:  Pagewriter main thread get requested_flush_num = 818, dirty rate = 2755.65, dirty percent = 0.52
2023-11-30 14:58:03.131422T,,,,,autovacuum worker,,00000,2023-11-30 14:56:40 CST,0,388970,LOG:  [Single flush] Reset DW file: file_head[dwn 71, start 0], write pos is 0
2023-11-30 14:58:03.131422T,,,,,autovacuum worker,,00000,2023-11-30 14:56:40 CST,0,388970,CONTEXT:  while scanning block 212148 of relation "hs_prd.prd_busin_entrust"
2023-11-30 14:58:06.628782T,,,,,page writer main process,,00000,2023-11-30 13:29:10 CST,0,334994,LOG:  Pagewriter main thread get requested_flush_num = 863, dirty rate = 2455.11, dirty percent = 0.54
2023-11-30 14:58:12.965479T,,,,,page writer main process,,00000,2023-11-30 13:29:10 CST,0,334994,LOG:  Pagewriter main thread get requested_flush_num = 920, dirty rate = 2791.01, dirty percent = 0.53
2023-11-30 14:58:17.123238T,,,,,autovacuum worker,,00000,2023-11-30 14:56:40 CST,0,388970,LOG:  [Single flush] Reset DW file: file_head[dwn 72, start 0], write pos is 0
2023-11-30 14:58:17.123238T,,,,,autovacuum worker,,00000,2023-11-30 14:56:40 CST,0,388970,CONTEXT:  while scanning block 246527 of relation "hs_prd.prd_busin_entrust"
2023-11-30 14:58:19.374019T,,,,,page writer main process,,00000,2023-11-30 13:29:10 CST,0,334994,LOG:  Pagewriter main thread get requested_flush_num = 818, dirty rate = 2877.40, dirty percent = 0.52
2023-11-30 14:58:25.712208T,,,,,page writer main process,,00000,2023-11-30 13:29:10 CST,0,334994,LOG:  Pagewriter main thread get requested_flush_num = 818, dirty rate = 2412.00, dirty percent = 0.54
2023-11-30 14:58:32.018604T,,,,,autovacuum worker,,00000,2023-11-30 14:56:40 CST,0,388970,LOG:  [Single flush] Reset DW file: file_head[dwn 73, start 0], write pos is 0
2023-11-30 14:58:32.018604T,,,,,autovacuum worker,,00000,2023-11-30 14:56:40 CST,0,388970,CONTEXT:  while scanning block 283731 of relation "hs_prd.prd_busin_entrust"
2023-11-30 14:58:32.107079T,,,,,page writer main process,,00000,2023-11-30 13:29:10 CST,0,334994,LOG:  Pagewriter main thread get requested_flush_num = 818, dirty rate = 2829.15, dirty percent = 0.53
2023-11-30 14:58:38.443462T,,,,,page writer main process,,00000,2023-11-30 13:29:10 CST,0,334994,LOG:  Pagewriter main thread get requested_flush_num = 818, dirty rate = 2414.11, dirty percent = 0.53
2023-11-30 14:58:44.782381T,,,,,page writer main process,,00000,2023-11-30 13:29:10 CST,0,334994,LOG:  Pagewriter main thread get requested_flush_num = 818, dirty rate = 2738.91, dirty percent = 0.54
2023-11-30 14:58:47.178700T,,,,,autovacuum worker,,00000,2023-11-30 14:56:40 CST,0,388970,LOG:  [Single flush] Reset DW file: file_head[dwn 74, start 0], write pos is 0
2023-11-30 14:58:47.178700T,,,,,autovacuum worker,,00000,2023-11-30 14:56:40 CST,0,388970,CONTEXT:  while scanning block 321813 of relation "hs_prd.prd_busin_entrust"
2023-11-30 14:58:51.185808T,,,,,page writer main process,,00000,2023-11-30 13:29:10 CST,0,334994,LOG:  Pagewriter main thread get requested_flush_num = 818, dirty rate = 2981.39, dirty percent = 0.53
2023-11-30 14:58:55.425409T,,,,,checkpointer,,00000,2023-11-30 13:29:10 CST,0,334993,LOG:  checkpoint starting(mode=incremental): time
2023-11-30 14:58:55.627231T,,,,,checkpointer,,00000,2023-11-30 13:29:10 CST,0,334993,LOG:  [Batch flush] DW truncate end: file_head[dwn 5, start 8072], total_pages 0
2023-11-30 14:58:55.727861T,,,,,checkpointer,,00000,2023-11-30 13:29:10 CST,0,334993,LOG:  [Batch flush] DW truncate end: file_head[dwn 6, start 20597], total_pages 0
2023-11-30 14:58:55.828714T,,,,,checkpointer,,00000,2023-11-30 13:29:10 CST,0,334993,LOG:  [Single flush] DW truncate end: file_head[dwn 74, start 20285], write_pos 20526
2023-11-30 14:58:55.831027T,,,,,checkpointer,,00000,2023-11-30 13:29:10 CST,0,334993,LOG:  checkpoint complete(mode=incremental): wrote 0 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.000 s, sync=0.403 s, total=0.406 s; sync files=0, lo
ngest=0.000 s, average=0.000 s; distance=80923 kB, estimate=875107 kB
2023-11-30 14:58:57.550942T,,,,,page writer main process,,00000,2023-11-30 13:29:10 CST,0,334994,LOG:  Pagewriter main thread get requested_flush_num = 818, dirty rate = 2431.27, dirty percent = 0.53
2023-11-30 14:59:01.112556T,,,,,autovacuum worker,,00000,2023-11-30 14:56:40 CST,0,388970,LOG:  [Single flush] Reset DW file: file_head[dwn 75, start 0], write pos is 0
2023-11-30 14:59:01.112556T,,,,,autovacuum worker,,00000,2023-11-30 14:56:40 CST,0,388970,CONTEXT:  while scanning block 355974 of relation "hs_prd.prd_busin_entrust"
2023-11-30 14:59:03.921702T,,,,,page writer main process,,00000,2023-11-30 13:29:10 CST,0,334994,LOG:  Pagewriter main thread get requested_flush_num = 855, dirty rate = 2728.03, dirty percent = 0.54
2023-11-30 14:59:10.257908T,,,,,page writer main process,,00000,2023-11-30 13:29:10 CST,0,334994,LOG:  Pagewriter main thread get requested_flush_num = 898, dirty rate = 2831.05, dirty percent = 0.54
2023-11-30 14:59:16.135066T,,,,,autovacuum worker,,00000,2023-11-30 14:56:40 CST,0,388970,LOG:  [Single flush] Reset DW file: file_head[dwn 76, start 0], write pos is 0
2023-11-30 14:59:16.135066T,,,,,autovacuum worker,,00000,2023-11-30 14:56:40 CST,0,388970,CONTEXT:  while scanning block 393449 of relation "hs_prd.prd_busin_entrust"
2023-11-30 14:59:16.668768T,,,,,page writer main process,,00000,2023-11-30 13:29:10 CST,0,334994,LOG:  Pagewriter main thread get requested_flush_num = 818, dirty rate = 2439.25, dirty percent = 0.53
2023-11-30 14:59:23.005549T,,,,,page writer main process,,00000,2023-11-30 13:29:10 CST,0,334994,LOG:  Pagewriter main thread get requested_flush_num = 818, dirty rate = 2848.52, dirty percent = 0.52
2023-11-30 14:59:29.347333T,,,,,page writer main process,,00000,2023-11-30 13:29:10 CST,0,334994,LOG:  Pagewriter main thread get requested_flush_num = 818, dirty rate = 2404.22, dirty percent = 0.54
2023-11-30 14:59:31.335019T,,,,,autovacuum worker,,00000,2023-11-30 14:56:40 CST,0,388970,LOG:  [Single flush] Reset DW file: file_head[dwn 77, start 0], write pos is 0
2023-11-30 14:59:31.335019T,,,,,autovacuum worker,,00000,2023-11-30 14:56:40 CST,0,388970,CONTEXT:  while scanning block 431406 of relation "hs_prd.prd_busin_entrust"
2023-11-30 14:59:35.746107T,,,,,page writer main process,,00000,2023-11-30 13:29:10 CST,0,334994,LOG:  Pagewriter main thread get requested_flush_num = 818, dirty rate = 2828.67, dirty percent = 0.53
2023-11-30 14:59:42.108044T,,,,,page writer main process,,00000,2023-11-30 13:29:10 CST,0,334994,LOG:  Pagewriter main thread get requested_flush_num = 818, dirty rate = 2752.02, dirty percent = 0.53
2023-11-30 14:59:46.085050T,,,,,autovacuum worker,,00000,2023-11-30 14:56:40 CST,0,388970,LOG:  [Single flush] Reset DW file: file_head[dwn 78, start 0], write pos is 0
2023-11-30 14:59:46.085050T,,,,,autovacuum worker,,00000,2023-11-30 14:56:40 CST,0,388970,CONTEXT:  while scanning block 467978 of relation "hs_prd.prd_busin_entrust"
2023-11-30 14:59:48.540463T,,,,,page writer main process,,00000,2023-11-30 13:29:10 CST,0,334994,LOG:  Pagewriter main thread get requested_flush_num = 818, dirty rate = 2423.76, dirty percent = 0.54
2023-11-30 14:59:54.879576T,,,,,page writer main process,,00000,2023-11-30 13:29:10 CST,0,334994,LOG:  Pagewriter main thread get requested_flush_num = 818, dirty rate = 2930.83, dirty percent = 0.53
2023-11-30 14:59:55.870813T,,,,,checkpointer,,00000,2023-11-30 13:29:10 CST,0,334993,LOG:  checkpoint starting(mode=incremental): time
2023-11-30 14:59:56.071767T,,,,,checkpointer,,00000,2023-11-30 13:29:10 CST,0,334993,LOG:  [Batch flush] DW truncate end: file_head[dwn 5, start 20287], total_pages 0
2023-11-30 14:59:56.172046T,,,,,checkpointer,,00000,2023-11-30 13:29:10 CST,0,334993,LOG:  [Batch flush] DW truncate end: file_head[dwn 7, start 2461], total_pages 0
2023-11-30 14:59:56.272300T,,,,,checkpointer,,00000,2023-11-30 13:29:10 CST,0,334993,LOG:  [Single flush] DW truncate end: file_head[dwn 78, start 22810], write_pos 23051
2023-11-30 14:59:56.274380T,,,,,checkpointer,,00000,2023-11-30 13:29:10 CST,0,334993,LOG:  checkpoint complete(mode=incremental): wrote 0 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.000 s, sync=0.401 s, total=0.404 s; sync files=0, lo
ngest=0.000 s, average=0.000 s; distance=86424 kB, estimate=796239 kB
2023-11-30 14:59:59.418357T,,,,,autovacuum worker,,00000,2023-11-30 14:56:40 CST,0,388970,LOG:  [Single flush] Reset DW file: file_head[dwn 79, start 0], write pos is 0
2023-11-30 15:00:01.275412T,,,,,page writer main process,,00000,2023-11-30 13:29:10 CST,0,334994,LOG:  Pagewriter main thread get requested_flush_num = 818, dirty rate = 2767.48, dirty percent = 0.38
2023-11-30 15:00:05.417723T,,,,,autovacuum worker,,00000,2023-11-30 14:56:40 CST,0,388970,LOG:  [Single flush] Reset DW file: file_head[dwn 80, start 0], write pos is 0
2023-11-30 15:00:07.690792T,,,,,page writer main process,,00000,2023-11-30 13:29:10 CST,0,334994,LOG:  Pagewriter main thread get requested_flush_num = 818, dirty rate = 1657.61, dirty percent = 0.04
2023-11-30 15:00:14.030899T,,,,,page writer main process,,00000,2023-11-30 13:29:10 CST,0,334994,LOG:  Pagewriter main thread get requested_flush_num = 818, dirty rate = 209.11, dirty percent = 0.03
2023-11-30 15:00:20.366758T,,,,,page writer main process,,00000,2023-11-30 13:29:10 CST,0,334994,LOG:  Pagewriter main thread get requested_flush_num = 818, dirty rate = 121.07, dirty percent = 0.06
2023-11-30 15:00:26.720383T,,,,,page writer main process,,00000,2023-11-30 13:29:10 CST,0,334994,LOG:  Pagewriter main thread get requested_flush_num = 818, dirty rate = 902.21, dirty percent = 0.22
2023-11-30 15:00:33.073936T,,,,,page writer main process,,00000,2023-11-30 13:29:10 CST,0,334994,LOG:  Pagewriter main thread get requested_flush_num = 818, dirty rate = 2773.72, dirty percent = 0.39
2023-11-30 15:00:39.405919T,,,,,page writer main process,,00000,2023-11-30 13:29:10 CST,0,334994,LOG:  Pagewriter main thread get requested_flush_num = 818, dirty rate = 2760.60, dirty percent = 0.54
2023-11-30 15:00:45.741540T,,,,,page writer main process,,00000,2023-11-30 13:29:10 CST,0,334994,LOG:  Pagewriter main thread get requested_flush_num = 818, dirty rate = 3208.26, dirty percent = 0.53
2023-11-30 15:00:48.163511T,,,,,autovacuum worker,,00000,2023-11-30 14:56:40 CST,0,388970,LOG:  [Single flush] Reset DW file: file_head[dwn 81, start 0], write pos is 0
2023-11-30 15:00:48.163511T,,,,,autovacuum worker,,00000,2023-11-30 14:56:40 CST,0,388970,CONTEXT:  while scanning block 75946 of relation "hs_prd.prd_client"
2023-11-30 15:00:52.131670T,,,,,page writer main process,,00000,2023-11-30 13:29:10 CST,0,334994,LOG:  Pagewriter main thread get requested_flush_num = 818, dirty rate = 2822.83, dirty percent = 0.52
2023-11-30 15:00:55.333502T,,,,,checkpointer,,00000,2023-11-30 13:29:10 CST,0,334993,LOG:  checkpoint starting(mode=incremental): time
2023-11-30 15:00:55.534731T,,,,,checkpointer,,00000,2023-11-30 13:29:10 CST,0,334993,LOG:  [Batch flush] DW truncate end: file_head[dwn 5, start 30952], total_pages 0
2023-11-30 15:00:55.635131T,,,,,checkpointer,,00000,2023-11-30 13:29:10 CST,0,334993,LOG:  [Batch flush] DW truncate end: file_head[dwn 7, start 14354], total_pages 0
2023-11-30 15:00:55.735794T,,,,,checkpointer,,00000,2023-11-30 13:29:10 CST,0,334993,LOG:  [Single flush] DW truncate end: file_head[dwn 81, start 17656], write_pos 17786
2023-11-30 15:00:55.737923T,,,,,checkpointer,,00000,2023-11-30 13:29:10 CST,0,334993,LOG:  checkpoint complete(mode=incremental): wrote 0 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.000 s, sync=0.402 s, total=0.405 s; sync files=0, lo
ngest=0.000 s, average=0.000 s; distance=81134 kB, estimate=724728 kB
2023-11-30 15:00:58.507675T,,,,,page writer main process,,00000,2023-11-30 13:29:10 CST,0,334994,LOG:  Pagewriter main thread get requested_flush_num = 818, dirty rate = 2499.75, dirty percent = 0.54
2023-11-30 15:01:03.178750T,,,,,autovacuum worker,,00000,2023-11-30 14:56:40 CST,0,388970,LOG:  [Single flush] Reset DW file: file_head[dwn 82, start 0], write pos is 0
2023-11-30 15:01:03.178750T,,,,,autovacuum worker,,00000,2023-11-30 14:56:40 CST,0,388970,CONTEXT:  while scanning block 113494 of relation "hs_prd.prd_client"
2023-11-30 15:01:04.880526T,,,,,page writer main process,,00000,2023-11-30 13:29:10 CST,0,334994,LOG:  Pagewriter main thread get requested_flush_num = 818, dirty rate = 2825.63, dirty percent = 0.54
复制