[2024-07-15 13:59:05.637680] Starting SPDK v24.09-pre git sha1 2728651ee / DPDK 24.03.0 initialization... [2024-07-15 13:59:05.637874] [ DPDK EAL parameters: rocksdb --no-shconf -c 0x1 --huge-unlink --no-telemetry --log-level=lib.eal:6 --log-level=lib.cryptodev:5 --log-level=lib.power:5 --log-level=user1:6 --base-virtaddr=0x200000000000 --match-allocations --file-prefix=spdk_pid1231716 ] Set seed to 1721044745633313 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-07-15 13:59:05.841179] app.c: 909:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-07-15 13:59:06.156856] app.c: 603:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-07-15 13:59:06.156917] app.c: 604:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 1231716' to capture a snapshot of events at runtime. [2024-07-15 13:59:06.156936] app.c: 609:app_setup_trace: *NOTICE*: 'spdk_trace' without parameters will also work if this is the only [2024-07-15 13:59:06.156956] app.c: 610:app_setup_trace: *NOTICE*: SPDK application currently running. [2024-07-15 13:59:06.156970] app.c: 611:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid1231716 for offline analysis/debug. [2024-07-15 13:59:06.157108] reactor.c: 941:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Mon Jul 15 13:59:13 2024 CPU: 72 * Intel(R) Xeon(R) Gold 6140 CPU @ 2.30GHz CPUCache: 25344 KB 2024/07/15-13:59:19 ... thread 0: (1000000,1000000) ops and (183889.1,183889.1) ops/second in (5.438061,5.438061) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 0/0 0.00 KB 0.0 0.0 0.0 0.0 0.8 0.8 0.0 1.0 0.0 171.0 4.79 4.50 9 0.532 0 0 0.0 0.0 L2 1/0 62.99 MB 0.6 0.0 0.0 0.0 0.0 0.0 0.8 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L3 8/0 755.94 MB 0.8 0.0 0.0 0.0 0.0 0.0 0.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 9/0 818.93 MB 0.0 0.0 0.0 0.0 0.8 0.8 1.5 1.0 0.0 171.0 4.79 4.50 9 0.532 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 0.4 0.4 1.2 1.0 0.0 195.5 2.26 2.10 5 0.451 0 0 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- High 0/0 0.00 KB 0.0 0.0 0.0 0.0 0.8 0.8 0.0 0.0 0.0 171.0 4.79 4.50 9 0.532 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 5.5 total, 2.4 interval Flush(GB): cumulative 0.800, interval 0.431 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 0.80 GB write, 149.84 MB/s write, 0.00 GB read, 0.00 MB/s read, 4.8 seconds Interval compaction: 0.43 GB write, 180.88 MB/s write, 0.00 GB read, 0.00 MB/s read, 2.3 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 9, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 9, interval: 5 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 45 Average: 774.3556 StdDev: 1296.93 Min: 2 Median: 9.0000 Max: 4023 Percentiles: P50: 9.00 P75: 995.42 P99: 4023.00 P99.9: 4023.00 P99.99: 4023.00 ------------------------------------------------------ ( 1, 2 ] 6 13.333% 13.333% ### ( 2, 3 ] 10 22.222% 35.556% #### ( 3, 4 ] 2 4.444% 40.000% # ( 6, 10 ] 6 13.333% 53.333% ### ( 10, 15 ] 3 6.667% 60.000% # ( 380, 580 ] 5 11.111% 71.111% ## ( 870, 1300 ] 6 13.333% 84.444% ### ( 2900, 4400 ] 7 15.556% 100.000% ### ** DB Stats ** Uptime(secs): 5.5 total, 2.4 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 180.08 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:2.843 H:M:S, 52.0 percent Interval writes: 0 writes, 491K keys, 0 commit groups, 0.0 writes per commit group, ingest: 484.22 MB, 198.54 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:1.174 H:M:S, 48.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/07/15-13:59:25 ... thread 0: (1000000,2000000) ops and (158364.8,170175.2) ops/second in (6.314535,11.752596) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 0/0 0.00 KB 0.0 0.0 0.0 0.0 1.8 1.8 0.0 1.0 0.0 177.3 10.66 10.02 20 0.533 0 0 0.0 0.0 L3 8/0 755.91 MB 0.8 0.0 0.0 0.0 0.0 0.0 1.8 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 12/0 1.11 GB 0.1 0.0 0.0 0.0 0.0 0.0 1.1 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 20/0 1.85 GB 0.0 0.0 0.0 0.0 1.8 1.8 3.0 1.0 0.0 177.3 10.66 10.02 20 0.533 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 1.5 1.5 2.6 1.0 0.0 186.1 8.12 7.63 16 0.508 0 0 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- High 0/0 0.00 KB 0.0 0.0 0.0 0.0 1.8 1.8 0.0 0.0 0.0 177.3 10.66 10.02 20 0.533 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 11.8 total, 8.8 interval Flush(GB): cumulative 1.846, interval 1.476 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 1.85 GB write, 160.43 MB/s write, 0.00 GB read, 0.00 MB/s read, 10.7 seconds Interval compaction: 1.48 GB write, 172.74 MB/s write, 0.00 GB read, 0.00 MB/s read, 8.1 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 20, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 20, interval: 16 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 100 Average: 667.0500 StdDev: 1126.62 Min: 2 Median: 9.0769 Max: 4023 Percentiles: P50: 9.08 P75: 977.50 P99: 4023.00 P99.9: 4023.00 P99.99: 4023.00 ------------------------------------------------------ ( 1, 2 ] 10 10.000% 10.000% ## ( 2, 3 ] 27 27.000% 37.000% ##### ( 3, 4 ] 2 2.000% 39.000% ( 4, 6 ] 1 1.000% 40.000% ( 6, 10 ] 13 13.000% 53.000% ### ( 10, 15 ] 7 7.000% 60.000% # ( 380, 580 ] 10 10.000% 70.000% ## ( 580, 870 ] 1 1.000% 71.000% ( 870, 1300 ] 16 16.000% 87.000% ### ( 1300, 1900 ] 2 2.000% 89.000% ( 2900, 4400 ] 11 11.000% 100.000% ## ** DB Stats ** Uptime(secs): 11.8 total, 6.3 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 167.10 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:6.570 H:M:S, 55.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 155.86 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:3.726 H:M:S, 59.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/07/15-13:59:31 ... thread 0: (1000000,3000000) ops and (176132.3,172115.6) ops/second in (5.677550,17.430146) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 0/0 0.00 KB 0.0 0.0 0.0 0.0 2.8 2.8 0.0 1.0 0.0 179.4 15.80 14.86 30 0.527 0 0 0.0 0.0 L3 10/0 944.92 MB 0.9 0.0 0.0 0.0 0.0 0.0 2.8 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 20/0 1.85 GB 0.2 0.0 0.0 0.0 0.0 0.0 1.8 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 30/0 2.77 GB 0.0 0.0 0.0 0.0 2.8 2.8 4.6 1.0 0.0 179.4 15.80 14.86 30 0.527 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 2.4 2.4 4.2 1.0 0.0 185.2 13.26 12.46 26 0.510 0 0 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- High 0/0 0.00 KB 0.0 0.0 0.0 0.0 2.8 2.8 0.0 0.0 0.0 179.4 15.80 14.86 30 0.527 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 17.5 total, 14.4 interval Flush(GB): cumulative 2.768, interval 2.399 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 2.77 GB write, 162.38 MB/s write, 0.00 GB read, 0.00 MB/s read, 15.8 seconds Interval compaction: 2.40 GB write, 170.26 MB/s write, 0.00 GB read, 0.00 MB/s read, 13.3 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 30, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 30, interval: 26 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 150 Average: 626.4067 StdDev: 1065.84 Min: 2 Median: 9.1111 Max: 4023 Percentiles: P50: 9.11 P75: 969.82 P99: 4023.00 P99.9: 4023.00 P99.99: 4023.00 ------------------------------------------------------ ( 1, 2 ] 19 12.667% 12.667% ### ( 2, 3 ] 37 24.667% 37.333% ##### ( 3, 4 ] 2 1.333% 38.667% ( 4, 6 ] 3 2.000% 40.667% ( 6, 10 ] 18 12.000% 52.667% ## ( 10, 15 ] 11 7.333% 60.000% # ( 380, 580 ] 15 10.000% 70.000% ## ( 580, 870 ] 1 0.667% 70.667% ( 870, 1300 ] 28 18.667% 89.333% #### ( 1300, 1900 ] 2 1.333% 90.667% ( 2900, 4400 ] 14 9.333% 100.000% ## ** DB Stats ** Uptime(secs): 17.5 total, 5.7 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 169.13 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:9.666 H:M:S, 55.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 173.35 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:3.096 H:M:S, 54.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/07/15-13:59:36 ... thread 0: (1000000,4000000) ops and (185450.4,175266.2) ops/second in (5.392278,22.822424) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 0/0 0.00 KB 0.0 0.0 0.0 0.0 3.7 3.7 0.0 1.0 0.0 183.0 20.65 19.39 40 0.516 0 0 0.0 0.0 L3 8/0 755.91 MB 0.8 0.0 0.0 0.0 0.0 0.0 3.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 32/0 2.95 GB 0.3 0.0 0.0 0.0 0.0 0.0 3.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 40/0 3.69 GB 0.0 0.0 0.0 0.0 3.7 3.7 6.6 1.0 0.0 183.0 20.65 19.39 40 0.516 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 3.3 3.3 6.3 1.0 0.0 187.8 18.12 16.99 36 0.503 0 0 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- High 0/0 0.00 KB 0.0 0.0 0.0 0.0 3.7 3.7 0.0 0.0 0.0 183.0 20.65 19.39 40 0.516 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 22.8 total, 19.8 interval Flush(GB): cumulative 3.691, interval 3.322 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 3.69 GB write, 165.41 MB/s write, 0.00 GB read, 0.00 MB/s read, 20.6 seconds Interval compaction: 3.32 GB write, 171.61 MB/s write, 0.00 GB read, 0.00 MB/s read, 18.1 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 40, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 40, interval: 36 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 200 Average: 674.6350 StdDev: 1145.28 Min: 2 Median: 9.0769 Max: 4620 Percentiles: P50: 9.08 P75: 987.27 P99: 4328.57 P99.9: 4620.00 P99.99: 4620.00 ------------------------------------------------------ ( 1, 2 ] 24 12.000% 12.000% ## ( 2, 3 ] 51 25.500% 37.500% ##### ( 3, 4 ] 2 1.000% 38.500% ( 4, 6 ] 3 1.500% 40.000% ( 6, 10 ] 26 13.000% 53.000% ### ( 10, 15 ] 13 6.500% 59.500% # ( 22, 34 ] 1 0.500% 60.000% ( 380, 580 ] 20 10.000% 70.000% ## ( 580, 870 ] 1 0.500% 70.500% ( 870, 1300 ] 33 16.500% 87.000% ### ( 1300, 1900 ] 4 2.000% 89.000% ( 2900, 4400 ] 21 10.500% 99.500% ## ( 4400, 6600 ] 1 0.500% 100.000% ** DB Stats ** Uptime(secs): 22.8 total, 5.4 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 172.29 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:12.484 H:M:S, 54.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 182.52 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:2.818 H:M:S, 52.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/07/15-13:59:42 ... thread 0: (1000000,5000000) ops and (178545.4,175912.4) ops/second in (5.600816,28.423240) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 0/0 0.00 KB 0.0 0.0 0.0 0.0 4.7 4.7 0.0 1.0 0.0 184.4 25.97 24.38 51 0.509 0 0 0.0 0.0 L2 1/0 63.00 MB 0.6 0.0 0.0 0.0 0.0 0.0 4.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L3 10/0 944.91 MB 0.9 0.0 0.0 0.0 0.0 0.0 4.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 40/0 3.69 GB 0.4 0.0 0.0 0.0 0.0 0.0 3.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 51/0 4.68 GB 0.0 0.0 0.0 0.0 4.7 4.7 13.0 1.0 0.0 184.4 25.97 24.38 51 0.509 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 4.3 4.3 12.6 1.0 0.0 188.2 23.43 21.98 47 0.499 0 0 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- High 0/0 0.00 KB 0.0 0.0 0.0 0.0 4.7 4.7 0.0 0.0 0.0 184.4 25.97 24.38 51 0.509 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 28.5 total, 25.4 interval Flush(GB): cumulative 4.675, interval 4.306 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 4.68 GB write, 168.28 MB/s write, 0.00 GB read, 0.00 MB/s read, 26.0 seconds Interval compaction: 4.31 GB write, 173.45 MB/s write, 0.00 GB read, 0.00 MB/s read, 23.4 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 51, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 51, interval: 47 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 255 Average: 662.4235 StdDev: 1129.91 Min: 2 Median: 9.0000 Max: 4620 Percentiles: P50: 9.00 P75: 982.50 P99: 4310.58 P99.9: 4620.00 P99.99: 4620.00 ------------------------------------------------------ ( 1, 2 ] 30 11.765% 11.765% ## ( 2, 3 ] 66 25.882% 37.647% ##### ( 3, 4 ] 2 0.784% 38.431% ( 4, 6 ] 4 1.569% 40.000% ( 6, 10 ] 34 13.333% 53.333% ### ( 10, 15 ] 15 5.882% 59.216% # ( 22, 34 ] 2 0.784% 60.000% ( 380, 580 ] 26 10.196% 70.196% ## ( 580, 870 ] 1 0.392% 70.588% ( 870, 1300 ] 43 16.863% 87.451% ### ( 1300, 1900 ] 5 1.961% 89.412% ( 2900, 4400 ] 26 10.196% 99.608% ## ( 4400, 6600 ] 1 0.392% 100.000% ** DB Stats ** Uptime(secs): 28.5 total, 5.6 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 172.97 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:15.488 H:M:S, 54.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 175.72 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:3.004 H:M:S, 53.6 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/07/15-13:59:47 ... thread 0: (1000000,6000000) ops and (174833.2,175731.6) ops/second in (5.719738,34.142978) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 0/0 0.00 KB 0.0 0.0 0.0 0.0 5.6 5.6 0.0 1.0 0.0 184.0 31.15 29.25 61 0.511 0 0 0.0 0.0 L2 1/0 62.99 MB 0.6 0.0 0.0 0.0 0.0 0.0 5.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L3 8/0 755.93 MB 0.8 0.0 0.0 0.0 0.0 0.0 5.5 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 52/0 4.80 GB 0.5 0.0 0.0 0.0 0.0 0.0 4.8 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 61/0 5.60 GB 0.0 0.0 0.0 0.0 5.6 5.6 15.9 1.0 0.0 184.0 31.15 29.25 61 0.511 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 5.2 5.2 15.6 1.0 0.0 187.1 28.62 26.86 57 0.502 0 0 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- High 0/0 0.00 KB 0.0 0.0 0.0 0.0 5.6 5.6 0.0 0.0 0.0 184.0 31.15 29.25 61 0.511 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 34.2 total, 31.1 interval Flush(GB): cumulative 5.598, interval 5.229 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 5.60 GB write, 167.76 MB/s write, 0.00 GB read, 0.00 MB/s read, 31.2 seconds Interval compaction: 5.23 GB write, 171.93 MB/s write, 0.00 GB read, 0.00 MB/s read, 28.6 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 61, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 61, interval: 57 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 305 Average: 645.6393 StdDev: 1099.25 Min: 2 Median: 8.9756 Max: 4620 Percentiles: P50: 8.98 P75: 979.49 P99: 4297.50 P99.9: 4620.00 P99.99: 4620.00 ------------------------------------------------------ ( 1, 2 ] 39 12.787% 12.787% ### ( 2, 3 ] 77 25.246% 38.033% ##### ( 3, 4 ] 2 0.656% 38.689% ( 4, 6 ] 4 1.311% 40.000% ( 6, 10 ] 41 13.443% 53.443% ### ( 10, 15 ] 18 5.902% 59.344% # ( 22, 34 ] 2 0.656% 60.000% ( 380, 580 ] 31 10.164% 70.164% ## ( 580, 870 ] 1 0.328% 70.492% ( 870, 1300 ] 54 17.705% 88.197% #### ( 1300, 1900 ] 5 1.639% 89.836% ( 2900, 4400 ] 30 9.836% 99.672% ## ( 4400, 6600 ] 1 0.328% 100.000% ** DB Stats ** Uptime(secs): 34.2 total, 5.7 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 172.82 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:18.628 H:M:S, 54.5 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 172.07 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:3.140 H:M:S, 54.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/07/15-13:59:53 ... thread 0: (1000000,7000000) ops and (165141.2,174136.3) ops/second in (6.055423,40.198401) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 0/0 0.00 KB 0.0 0.0 0.0 0.0 6.6 6.6 0.0 1.0 0.0 184.9 36.78 34.54 72 0.511 0 0 0.0 0.0 L3 8/0 755.91 MB 0.8 0.0 0.0 0.0 0.0 0.0 6.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 64/0 5.91 GB 0.6 0.0 0.0 0.0 0.0 0.0 5.9 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 72/0 6.64 GB 0.0 0.0 0.0 0.0 6.6 6.6 12.5 1.0 0.0 184.9 36.78 34.54 72 0.511 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 6.3 6.3 12.2 1.0 0.0 187.6 34.25 32.14 68 0.504 0 0 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- High 0/0 0.00 KB 0.0 0.0 0.0 0.0 6.6 6.6 0.0 0.0 0.0 184.9 36.78 34.54 72 0.511 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 40.2 total, 37.2 interval Flush(GB): cumulative 6.644, interval 6.275 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 6.64 GB write, 169.13 MB/s write, 0.00 GB read, 0.00 MB/s read, 36.8 seconds Interval compaction: 6.27 GB write, 172.73 MB/s write, 0.00 GB read, 0.00 MB/s read, 34.3 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 72, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 72, interval: 68 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 360 Average: 664.1528 StdDev: 1124.78 Min: 2 Median: 8.8000 Max: 4620 Percentiles: P50: 8.80 P75: 989.84 P99: 4297.37 P99.9: 4620.00 P99.99: 4620.00 ------------------------------------------------------ ( 1, 2 ] 46 12.778% 12.778% ### ( 2, 3 ] 92 25.556% 38.333% ##### ( 3, 4 ] 2 0.556% 38.889% ( 4, 6 ] 5 1.389% 40.278% ( 6, 10 ] 50 13.889% 54.167% ### ( 10, 15 ] 19 5.278% 59.444% # ( 22, 34 ] 2 0.556% 60.000% ( 380, 580 ] 36 10.000% 70.000% ## ( 580, 870 ] 1 0.278% 70.278% ( 870, 1300 ] 61 16.944% 87.222% ### ( 1300, 1900 ] 7 1.944% 89.167% ( 2900, 4400 ] 38 10.556% 99.722% ## ( 4400, 6600 ] 1 0.278% 100.000% ** DB Stats ** Uptime(secs): 40.2 total, 6.1 interval Cumulative writes: 0 writes, 7000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 6.73 GB, 171.27 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:22.094 H:M:S, 54.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 162.53 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:3.467 H:M:S, 57.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/07/15-13:59:58 ... thread 0: (1000000,8000000) ops and (208660.9,177813.9) ops/second in (4.792465,44.990866) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 0/0 0.00 KB 0.0 0.0 0.0 0.0 7.6 7.6 0.0 1.0 0.0 194.2 40.22 37.63 86 0.468 0 0 0.0 0.0 L3 10/0 692.94 MB 0.7 0.0 0.0 0.0 0.0 0.0 7.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 76/0 6.95 GB 0.7 0.0 0.0 0.0 0.0 0.0 7.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 86/0 7.63 GB 0.0 0.0 0.0 0.0 7.6 7.6 14.6 1.0 0.0 194.2 40.22 37.63 86 0.468 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 7.3 7.3 14.2 1.0 0.0 197.2 37.69 35.24 82 0.460 0 0 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- High 0/0 0.00 KB 0.0 0.0 0.0 0.0 7.6 7.6 0.0 0.0 0.0 194.2 40.22 37.63 86 0.468 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 45.0 total, 42.0 interval Flush(GB): cumulative 7.628, interval 7.259 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 7.63 GB write, 173.51 MB/s write, 0.00 GB read, 0.00 MB/s read, 40.2 seconds Interval compaction: 7.26 GB write, 177.02 MB/s write, 0.00 GB read, 0.00 MB/s read, 37.7 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 76, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 76, interval: 72 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 430 Average: 673.5395 StdDev: 1154.46 Min: 1 Median: 8.4000 Max: 4620 Percentiles: P50: 8.40 P75: 965.16 P99: 4302.94 P99.9: 4620.00 P99.99: 4620.00 ------------------------------------------------------ [ 0, 1 ] 17 3.953% 3.953% # ( 1, 2 ] 55 12.791% 16.744% ### ( 2, 3 ] 94 21.860% 38.605% #### ( 3, 4 ] 4 0.930% 39.535% ( 4, 6 ] 12 2.791% 42.326% # ( 6, 10 ] 55 12.791% 55.116% ### ( 10, 15 ] 19 4.419% 59.535% # ( 22, 34 ] 2 0.465% 60.000% ( 250, 380 ] 11 2.558% 62.558% # ( 380, 580 ] 39 9.070% 71.628% ## ( 580, 870 ] 1 0.233% 71.860% ( 870, 1300 ] 61 14.186% 86.047% ### ( 1300, 1900 ] 8 1.860% 87.907% ( 2900, 4400 ] 51 11.860% 99.767% ## ( 4400, 6600 ] 1 0.233% 100.000% ** DB Stats ** Uptime(secs): 45.0 total, 4.8 interval Cumulative writes: 0 writes, 8000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 7.69 GB, 174.90 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:22.741 H:M:S, 50.5 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 205.34 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.647 H:M:S, 13.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/07/15-14:00:04 ... thread 0: (1000000,9000000) ops and (189129.5,179003.9) ops/second in (5.287382,50.278248) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 0/0 0.00 KB 0.0 0.0 0.0 0.0 8.6 8.6 0.0 1.0 0.0 203.9 43.26 40.33 102 0.424 0 0 0.0 0.0 L3 14/0 881.91 MB 0.9 0.0 0.0 0.0 0.0 0.0 8.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 88/0 7.75 GB 0.8 0.0 0.0 0.0 0.0 0.0 7.8 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 102/0 8.61 GB 0.0 0.0 0.0 0.0 8.6 8.6 16.4 1.0 0.0 203.9 43.26 40.33 102 0.424 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 8.2 8.2 16.0 1.0 0.0 207.3 40.73 37.93 98 0.416 0 0 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- High 0/0 0.00 KB 0.0 0.0 0.0 0.0 8.6 8.6 0.0 0.0 0.0 203.9 43.26 40.33 102 0.424 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 50.3 total, 47.3 interval Flush(GB): cumulative 8.612, interval 8.243 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 8.61 GB write, 175.31 MB/s write, 0.00 GB read, 0.00 MB/s read, 43.3 seconds Interval compaction: 8.24 GB write, 178.54 MB/s write, 0.00 GB read, 0.00 MB/s read, 40.7 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 76, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 76, interval: 72 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 510 Average: 666.1980 StdDev: 1156.08 Min: 1 Median: 7.9661 Max: 4620 Percentiles: P50: 7.97 P75: 935.89 P99: 4303.91 P99.9: 4620.00 P99.99: 4620.00 ------------------------------------------------------ [ 0, 1 ] 35 6.863% 6.863% # ( 1, 2 ] 69 13.529% 20.392% ### ( 2, 3 ] 94 18.431% 38.824% #### ( 3, 4 ] 4 0.784% 39.608% ( 4, 6 ] 24 4.706% 44.314% # ( 6, 10 ] 59 11.569% 55.882% ## ( 10, 15 ] 19 3.725% 59.608% # ( 22, 34 ] 2 0.392% 60.000% ( 250, 380 ] 27 5.294% 65.294% # ( 380, 580 ] 39 7.647% 72.941% ## ( 580, 870 ] 1 0.196% 73.137% ( 870, 1300 ] 62 12.157% 85.294% ## ( 1300, 1900 ] 10 1.961% 87.255% ( 2900, 4400 ] 64 12.549% 99.804% ### ( 4400, 6600 ] 1 0.196% 100.000% ** DB Stats ** Uptime(secs): 50.3 total, 5.3 interval Cumulative writes: 0 writes, 9000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 8.65 GB, 176.08 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:22.741 H:M:S, 45.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 186.14 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.000 H:M:S, 0.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 0 2024/07/15-14:00:09 ... thread 0: (1000000,10000000) ops and (190273.0,180070.3) ops/second in (5.255607,55.533855) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 0/0 0.00 KB 0.0 0.0 0.0 0.0 9.5 9.5 0.0 1.0 0.0 211.7 46.12 42.86 117 0.394 0 0 0.0 0.0 L2 1/0 63.00 MB 0.6 0.0 0.0 0.0 0.0 0.0 9.5 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L3 12/0 755.95 MB 0.8 0.0 0.0 0.0 0.0 0.0 9.5 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 104/0 8.74 GB 0.9 0.0 0.0 0.0 0.0 0.0 8.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 117/0 9.54 GB 0.0 0.0 0.0 0.0 9.5 9.5 27.7 1.0 0.0 211.7 46.12 42.86 117 0.394 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 9.2 9.2 27.4 1.0 0.0 215.3 43.59 40.46 113 0.386 0 0 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- High 0/0 0.00 KB 0.0 0.0 0.0 0.0 9.5 9.5 0.0 0.0 0.0 211.7 46.12 42.86 117 0.394 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 55.6 total, 52.5 interval Flush(GB): cumulative 9.535, interval 9.166 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 9.54 GB write, 175.73 MB/s write, 0.00 GB read, 0.00 MB/s read, 46.1 seconds Interval compaction: 9.17 GB write, 178.67 MB/s write, 0.00 GB read, 0.00 MB/s read, 43.6 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 76, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 76, interval: 72 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 585 Average: 659.6684 StdDev: 1159.64 Min: 1 Median: 7.6923 Max: 4620 Percentiles: P50: 7.69 P75: 908.04 P99: 4301.69 P99.9: 4620.00 P99.99: 4620.00 ------------------------------------------------------ [ 0, 1 ] 49 8.376% 8.376% ## ( 1, 2 ] 84 14.359% 22.735% ### ( 2, 3 ] 94 16.068% 38.803% ### ( 3, 4 ] 4 0.684% 39.487% ( 4, 6 ] 34 5.812% 45.299% # ( 6, 10 ] 65 11.111% 56.410% ## ( 10, 15 ] 19 3.248% 59.658% # ( 22, 34 ] 2 0.342% 60.000% ( 250, 380 ] 41 7.009% 67.009% # ( 380, 580 ] 40 6.838% 73.846% # ( 580, 870 ] 1 0.171% 74.017% ( 870, 1300 ] 65 11.111% 85.128% ## ( 1300, 1900 ] 12 2.051% 87.179% ( 2900, 4400 ] 74 12.650% 99.829% ### ( 4400, 6600 ] 1 0.171% 100.000% ** DB Stats ** Uptime(secs): 55.6 total, 5.3 interval Cumulative writes: 0 writes, 10M keys, 0 commit groups, 0.0 writes per commit group, ingest: 9.61 GB, 177.14 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:22.741 H:M:S, 40.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 187.26 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.000 H:M:S, 0.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/07/15-14:00:14 ... thread 0: (1000000,11000000) ops and (190041.1,180933.3) ops/second in (5.262021,60.795876) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 0/0 0.00 KB 0.0 0.0 0.0 0.0 10.5 10.5 0.0 1.0 0.0 219.1 49.17 45.58 133 0.370 0 0 0.0 0.0 L2 1/0 62.99 MB 0.6 0.0 0.0 0.0 0.0 0.0 10.5 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L3 12/0 755.90 MB 0.8 0.0 0.0 0.0 0.0 0.0 10.5 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 120/0 9.72 GB 1.0 0.0 0.0 0.0 0.0 0.0 9.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 133/0 10.52 GB 0.0 0.0 0.0 0.0 10.5 10.5 30.7 1.0 0.0 219.1 49.17 45.58 133 0.370 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 10.2 10.2 30.3 1.0 0.0 222.8 46.64 43.18 129 0.362 0 0 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- High 0/0 0.00 KB 0.0 0.0 0.0 0.0 10.5 10.5 0.0 0.0 0.0 219.1 49.17 45.58 133 0.370 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 60.8 total, 57.8 interval Flush(GB): cumulative 10.519, interval 10.150 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 10.52 GB write, 177.10 MB/s write, 0.00 GB read, 0.00 MB/s read, 49.2 seconds Interval compaction: 10.15 GB write, 179.84 MB/s write, 0.00 GB read, 0.00 MB/s read, 46.6 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 76, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 76, interval: 72 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 665 Average: 647.3549 StdDev: 1146.78 Min: 1 Median: 7.4722 Max: 4620 Percentiles: P50: 7.47 P75: 881.40 P99: 4296.65 P99.9: 4620.00 P99.99: 4620.00 ------------------------------------------------------ [ 0, 1 ] 72 10.827% 10.827% ## ( 1, 2 ] 93 13.985% 24.812% ### ( 2, 3 ] 94 14.135% 38.947% ### ( 3, 4 ] 4 0.602% 39.549% ( 4, 6 ] 43 6.466% 46.015% # ( 6, 10 ] 72 10.827% 56.842% ## ( 10, 15 ] 19 2.857% 59.699% # ( 22, 34 ] 2 0.301% 60.000% ( 250, 380 ] 57 8.571% 68.571% ## ( 380, 580 ] 40 6.015% 74.586% # ( 580, 870 ] 1 0.150% 74.737% ( 870, 1300 ] 66 9.925% 84.662% ## ( 1300, 1900 ] 14 2.105% 86.767% ( 1900, 2900 ] 5 0.752% 87.519% ( 2900, 4400 ] 82 12.331% 99.850% ## ( 4400, 6600 ] 1 0.150% 100.000% ** DB Stats ** Uptime(secs): 60.8 total, 5.3 interval Cumulative writes: 0 writes, 11M keys, 0 commit groups, 0.0 writes per commit group, ingest: 10.57 GB, 177.99 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:22.741 H:M:S, 37.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 187.04 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.000 H:M:S, 0.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 0 2024/07/15-14:00:19 ... thread 0: (1000000,12000000) ops and (190408.8,181686.8) ops/second in (5.251859,66.047735) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 0/0 0.00 KB 0.0 0.0 0.0 0.0 11.4 11.4 0.0 1.0 0.0 225.2 52.02 48.09 148 0.351 0 0 0.0 0.0 L3 12/0 755.92 MB 0.8 0.0 0.0 0.0 0.0 0.0 11.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 124/0 9.60 GB 1.0 0.0 0.0 0.0 0.0 0.0 10.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 12/0 1.11 GB 0.0 0.0 0.0 0.0 0.0 0.0 1.1 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 148/0 11.44 GB 0.0 0.0 0.0 0.0 11.4 11.4 23.3 1.0 0.0 225.2 52.02 48.09 148 0.351 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 11.1 11.1 22.9 1.0 0.0 229.1 49.49 45.69 144 0.344 0 0 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- High 0/0 0.00 KB 0.0 0.0 0.0 0.0 11.4 11.4 0.0 0.0 0.0 225.2 52.02 48.09 148 0.351 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 66.1 total, 63.0 interval Flush(GB): cumulative 11.442, interval 11.073 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 11.44 GB write, 177.33 MB/s write, 0.00 GB read, 0.00 MB/s read, 52.0 seconds Interval compaction: 11.07 GB write, 179.85 MB/s write, 0.00 GB read, 0.00 MB/s read, 49.5 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 76, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 76, interval: 72 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 740 Average: 652.0041 StdDev: 1169.76 Min: 1 Median: 7.2267 Max: 4622 Percentiles: P50: 7.23 P75: 575.00 P99: 4327.47 P99.9: 4622.00 P99.99: 4622.00 ------------------------------------------------------ [ 0, 1 ] 93 12.568% 12.568% ### ( 1, 2 ] 102 13.784% 26.351% ### ( 2, 3 ] 94 12.703% 39.054% ### ( 3, 4 ] 4 0.541% 39.595% ( 4, 6 ] 54 7.297% 46.892% # ( 6, 10 ] 75 10.135% 57.027% ## ( 10, 15 ] 20 2.703% 59.730% # ( 22, 34 ] 2 0.270% 60.000% ( 250, 380 ] 72 9.730% 69.730% ## ( 380, 580 ] 40 5.405% 75.135% # ( 580, 870 ] 1 0.135% 75.270% ( 870, 1300 ] 68 9.189% 84.459% ## ( 1300, 1900 ] 15 2.027% 86.486% ( 1900, 2900 ] 6 0.811% 87.297% ( 2900, 4400 ] 91 12.297% 99.595% ## ( 4400, 6600 ] 3 0.405% 100.000% ** DB Stats ** Uptime(secs): 66.1 total, 5.3 interval Cumulative writes: 0 writes, 12M keys, 0 commit groups, 0.0 writes per commit group, ingest: 11.53 GB, 178.74 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:22.741 H:M:S, 34.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 187.40 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.000 H:M:S, 0.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/07/15-14:00:25 ... thread 0: (1000000,13000000) ops and (190088.4,182306.6) ops/second in (5.260710,71.308445) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 0/0 0.00 KB 0.0 0.0 0.0 0.0 12.4 12.4 0.0 1.0 0.0 230.9 55.10 50.82 164 0.336 0 0 0.0 0.0 L3 12/0 755.91 MB 0.8 0.0 0.0 0.0 0.0 0.0 12.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 128/0 9.47 GB 1.0 0.0 0.0 0.0 0.0 0.0 11.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 24/0 2.21 GB 0.0 0.0 0.0 0.0 0.0 0.0 2.2 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 164/0 12.43 GB 0.0 0.0 0.0 0.0 12.4 12.4 26.3 1.0 0.0 230.9 55.10 50.82 164 0.336 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 12.1 12.1 26.0 1.0 0.0 234.9 52.57 48.42 160 0.329 0 0 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- High 0/0 0.00 KB 0.0 0.0 0.0 0.0 12.4 12.4 0.0 0.0 0.0 230.9 55.10 50.82 164 0.336 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 71.3 total, 68.3 interval Flush(GB): cumulative 12.426, interval 12.057 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 12.43 GB write, 178.38 MB/s write, 0.00 GB read, 0.00 MB/s read, 55.1 seconds Interval compaction: 12.06 GB write, 180.75 MB/s write, 0.00 GB read, 0.00 MB/s read, 52.6 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 76, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 76, interval: 72 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 820 Average: 646.8817 StdDev: 1171.34 Min: 1 Median: 6.9744 Max: 4622 Percentiles: P50: 6.97 P75: 555.00 P99: 4335.71 P99.9: 4622.00 P99.99: 4622.00 ------------------------------------------------------ [ 0, 1 ] 112 13.659% 13.659% ### ( 1, 2 ] 114 13.902% 27.561% ### ( 2, 3 ] 94 11.463% 39.024% ## ( 3, 4 ] 4 0.488% 39.512% ( 4, 6 ] 67 8.171% 47.683% ## ( 6, 10 ] 78 9.512% 57.195% ## ( 10, 15 ] 21 2.561% 59.756% # ( 22, 34 ] 2 0.244% 60.000% ( 250, 380 ] 88 10.732% 70.732% ## ( 380, 580 ] 40 4.878% 75.610% # ( 580, 870 ] 1 0.122% 75.732% ( 870, 1300 ] 70 8.537% 84.268% ## ( 1300, 1900 ] 17 2.073% 86.341% ( 1900, 2900 ] 10 1.220% 87.561% ( 2900, 4400 ] 98 11.951% 99.512% ## ( 4400, 6600 ] 4 0.488% 100.000% ** DB Stats ** Uptime(secs): 71.3 total, 5.3 interval Cumulative writes: 0 writes, 13M keys, 0 commit groups, 0.0 writes per commit group, ingest: 12.49 GB, 179.35 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:22.741 H:M:S, 31.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 187.08 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.000 H:M:S, 0.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/07/15-14:00:30 ... thread 0: (1000000,14000000) ops and (189956.8,182832.5) ops/second in (5.264355,76.572800) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 0/0 0.00 KB 0.0 0.0 0.0 0.0 13.4 13.4 0.0 1.0 0.0 236.1 58.16 53.56 180 0.323 0 0 0.0 0.0 L3 12/0 755.92 MB 0.8 0.0 0.0 0.0 0.0 0.0 13.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 136/0 9.72 GB 1.0 0.0 0.0 0.0 0.0 0.0 12.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 32/0 2.95 GB 0.0 0.0 0.0 0.0 0.0 0.0 3.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 180/0 13.41 GB 0.0 0.0 0.0 0.0 13.4 13.4 29.0 1.0 0.0 236.1 58.16 53.56 180 0.323 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 13.0 13.0 28.7 1.0 0.0 240.1 55.63 51.16 176 0.316 0 0 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- High 0/0 0.00 KB 0.0 0.0 0.0 0.0 13.4 13.4 0.0 0.0 0.0 236.1 58.16 53.56 180 0.323 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 76.6 total, 73.6 interval Flush(GB): cumulative 13.411, interval 13.042 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 13.41 GB write, 179.28 MB/s write, 0.00 GB read, 0.00 MB/s read, 58.2 seconds Interval compaction: 13.04 GB write, 181.52 MB/s write, 0.00 GB read, 0.00 MB/s read, 55.6 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 76, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 76, interval: 72 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 900 Average: 642.5789 StdDev: 1168.05 Min: 1 Median: 6.6582 Max: 4622 Percentiles: P50: 6.66 P75: 535.00 P99: 4330.56 P99.9: 4622.00 P99.99: 4622.00 ------------------------------------------------------ [ 0, 1 ] 134 14.889% 14.889% ### ( 1, 2 ] 124 13.778% 28.667% ### ( 2, 3 ] 94 10.444% 39.111% ## ( 3, 4 ] 4 0.444% 39.556% ( 4, 6 ] 81 9.000% 48.556% ## ( 6, 10 ] 79 8.778% 57.333% ## ( 10, 15 ] 22 2.444% 59.778% ( 22, 34 ] 2 0.222% 60.000% ( 250, 380 ] 104 11.556% 71.556% ## ( 380, 580 ] 40 4.444% 76.000% # ( 580, 870 ] 1 0.111% 76.111% ( 870, 1300 ] 72 8.000% 84.111% ## ( 1300, 1900 ] 19 2.111% 86.222% ( 1900, 2900 ] 12 1.333% 87.556% ( 2900, 4400 ] 108 12.000% 99.556% ## ( 4400, 6600 ] 4 0.444% 100.000% ** DB Stats ** Uptime(secs): 76.6 total, 5.3 interval Cumulative writes: 0 writes, 14M keys, 0 commit groups, 0.0 writes per commit group, ingest: 13.46 GB, 179.88 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:22.741 H:M:S, 29.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 186.96 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.000 H:M:S, 0.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 0 2024/07/15-14:00:35 ... thread 0: (1000000,15000000) ops and (190461.1,183322.1) ops/second in (5.250417,81.823217) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 0/0 0.00 KB 0.0 0.0 0.0 0.0 14.3 14.3 0.0 1.0 0.0 240.3 61.09 56.14 195 0.313 0 0 0.0 0.0 L2 1/0 62.99 MB 0.6 0.0 0.0 0.0 0.0 0.0 14.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L3 14/0 881.92 MB 0.9 0.0 0.0 0.0 0.0 0.0 14.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 140/0 9.72 GB 1.0 0.0 0.0 0.0 0.0 0.0 13.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 40/0 3.69 GB 0.0 0.0 0.0 0.0 0.0 0.0 3.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 195/0 14.33 GB 0.0 0.0 0.0 0.0 14.3 14.3 45.7 1.0 0.0 240.3 61.09 56.14 195 0.313 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 14.0 14.0 45.3 1.0 0.0 244.2 58.56 53.74 191 0.307 0 0 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- High 0/0 0.00 KB 0.0 0.0 0.0 0.0 14.3 14.3 0.0 0.0 0.0 240.3 61.09 56.14 195 0.313 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 81.9 total, 78.8 interval Flush(GB): cumulative 14.334, interval 13.964 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 14.33 GB write, 179.32 MB/s write, 0.00 GB read, 0.00 MB/s read, 61.1 seconds Interval compaction: 13.96 GB write, 181.41 MB/s write, 0.00 GB read, 0.00 MB/s read, 58.6 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 76, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 76, interval: 72 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 975 Average: 647.5344 StdDev: 1184.37 Min: 1 Median: 6.4146 Max: 4622 Percentiles: P50: 6.41 P75: 517.80 P99: 4327.52 P99.9: 4622.00 P99.99: 4622.00 ------------------------------------------------------ [ 0, 1 ] 154 15.795% 15.795% ### ( 1, 2 ] 133 13.641% 29.436% ### ( 2, 3 ] 94 9.641% 39.077% ## ( 3, 4 ] 4 0.410% 39.487% ( 4, 6 ] 94 9.641% 49.128% ## ( 6, 10 ] 82 8.410% 57.538% ## ( 10, 15 ] 22 2.256% 59.795% ( 22, 34 ] 2 0.205% 60.000% ( 250, 380 ] 118 12.103% 72.103% ## ( 380, 580 ] 41 4.205% 76.308% # ( 580, 870 ] 1 0.103% 76.410% ( 870, 1300 ] 73 7.487% 83.897% # ( 1300, 1900 ] 22 2.256% 86.154% ( 1900, 2900 ] 12 1.231% 87.385% ( 2900, 4400 ] 119 12.205% 99.590% ## ( 4400, 6600 ] 4 0.410% 100.000% ** DB Stats ** Uptime(secs): 81.9 total, 5.3 interval Cumulative writes: 0 writes, 15M keys, 0 commit groups, 0.0 writes per commit group, ingest: 14.42 GB, 180.36 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:22.741 H:M:S, 27.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 187.45 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.000 H:M:S, 0.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/07/15-14:00:40 ... thread 0: (1000000,16000000) ops and (189747.3,183710.9) ops/second in (5.270168,87.093385) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 0/0 0.00 KB 0.0 0.0 0.0 0.0 15.3 15.3 0.0 1.0 0.0 244.4 64.17 58.88 211 0.304 0 0 0.0 0.0 L2 1/0 63.00 MB 0.6 0.0 0.0 0.0 0.0 0.0 15.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L3 14/0 881.91 MB 0.9 0.0 0.0 0.0 0.0 0.0 15.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 144/0 9.60 GB 1.0 0.0 0.0 0.0 0.0 0.0 14.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 52/0 4.80 GB 0.0 0.0 0.0 0.0 0.0 0.0 4.8 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 211/0 15.32 GB 0.0 0.0 0.0 0.0 15.3 15.3 49.8 1.0 0.0 244.4 64.17 58.88 211 0.304 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 14.9 14.9 49.4 1.0 0.0 248.3 61.64 56.48 207 0.298 0 0 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- High 0/0 0.00 KB 0.0 0.0 0.0 0.0 15.3 15.3 0.0 0.0 0.0 244.4 64.17 58.88 211 0.304 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 87.1 total, 84.1 interval Flush(GB): cumulative 15.318, interval 14.949 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 15.32 GB write, 180.04 MB/s write, 0.00 GB read, 0.00 MB/s read, 64.2 seconds Interval compaction: 14.95 GB write, 182.03 MB/s write, 0.00 GB read, 0.00 MB/s read, 61.6 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 76, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 76, interval: 72 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1055 Average: 642.4445 StdDev: 1180.83 Min: 1 Median: 6.2955 Max: 4622 Percentiles: P50: 6.30 P75: 498.29 P99: 4323.84 P99.9: 4622.00 P99.99: 4622.00 ------------------------------------------------------ [ 0, 1 ] 172 16.303% 16.303% ### ( 1, 2 ] 146 13.839% 30.142% ### ( 2, 3 ] 94 8.910% 39.052% ## ( 3, 4 ] 5 0.474% 39.526% ( 4, 6 ] 104 9.858% 49.384% ## ( 6, 10 ] 88 8.341% 57.725% ## ( 10, 15 ] 22 2.085% 59.810% ( 22, 34 ] 2 0.190% 60.000% ( 250, 380 ] 134 12.701% 72.701% ### ( 380, 580 ] 41 3.886% 76.588% # ( 580, 870 ] 1 0.095% 76.682% ( 870, 1300 ] 77 7.299% 83.981% # ( 1300, 1900 ] 24 2.275% 86.256% ( 1900, 2900 ] 12 1.137% 87.393% ( 2900, 4400 ] 129 12.227% 99.621% ## ( 4400, 6600 ] 4 0.379% 100.000% ** DB Stats ** Uptime(secs): 87.1 total, 5.3 interval Cumulative writes: 0 writes, 16M keys, 0 commit groups, 0.0 writes per commit group, ingest: 15.38 GB, 180.75 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:22.741 H:M:S, 26.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 186.75 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.000 H:M:S, 0.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/07/15-14:00:46 ... thread 0: (1000000,17000000) ops and (189897.7,184063.6) ops/second in (5.265992,92.359377) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 0/0 0.00 KB 0.0 0.0 0.0 0.0 16.3 16.3 0.0 1.0 0.0 248.3 67.23 61.59 227 0.296 0 0 0.0 0.0 L2 1/0 62.99 MB 0.6 0.0 0.0 0.0 0.0 0.0 16.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L3 14/0 881.90 MB 0.9 0.0 0.0 0.0 0.0 0.0 16.2 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 148/0 9.47 GB 1.0 0.0 0.0 0.0 0.0 0.0 15.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 64/0 5.91 GB 0.1 0.0 0.0 0.0 0.0 0.0 5.9 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 227/0 16.30 GB 0.0 0.0 0.0 0.0 16.3 16.3 53.8 1.0 0.0 248.3 67.23 61.59 227 0.296 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 15.9 15.9 53.5 1.0 0.0 252.2 64.70 59.20 223 0.290 0 0 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- High 0/0 0.00 KB 0.0 0.0 0.0 0.0 16.3 16.3 0.0 0.0 0.0 248.3 67.23 61.59 227 0.296 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 92.4 total, 89.4 interval Flush(GB): cumulative 16.302, interval 15.933 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 16.30 GB write, 180.69 MB/s write, 0.00 GB read, 0.00 MB/s read, 67.2 seconds Interval compaction: 15.93 GB write, 182.58 MB/s write, 0.00 GB read, 0.00 MB/s read, 64.7 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 76, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 76, interval: 72 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1135 Average: 641.1110 StdDev: 1180.56 Min: 1 Median: 6.0659 Max: 4622 Percentiles: P50: 6.07 P75: 478.78 P99: 4322.36 P99.9: 4622.00 P99.99: 4622.00 ------------------------------------------------------ [ 0, 1 ] 187 16.476% 16.476% ### ( 1, 2 ] 163 14.361% 30.837% ### ( 2, 3 ] 94 8.282% 39.119% ## ( 3, 4 ] 5 0.441% 39.559% ( 4, 6 ] 117 10.308% 49.868% ## ( 6, 10 ] 91 8.018% 57.885% ## ( 10, 15 ] 22 1.938% 59.824% ( 22, 34 ] 2 0.176% 60.000% ( 250, 380 ] 150 13.216% 73.216% ### ( 380, 580 ] 41 3.612% 76.828% # ( 580, 870 ] 1 0.088% 76.916% ( 870, 1300 ] 80 7.048% 83.965% # ( 1300, 1900 ] 24 2.115% 86.079% ( 1900, 2900 ] 12 1.057% 87.137% ( 2900, 4400 ] 142 12.511% 99.648% ### ( 4400, 6600 ] 4 0.352% 100.000% ** DB Stats ** Uptime(secs): 92.4 total, 5.3 interval Cumulative writes: 0 writes, 17M keys, 0 commit groups, 0.0 writes per commit group, ingest: 16.34 GB, 181.10 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:22.741 H:M:S, 24.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 186.89 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.000 H:M:S, 0.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 0 2024/07/15-14:00:51 ... thread 0: (1000000,18000000) ops and (190424.9,184405.8) ops/second in (5.251414,97.610791) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 0/0 0.00 KB 0.0 0.0 0.0 0.0 17.2 17.2 0.0 1.0 0.0 251.6 70.12 64.14 242 0.290 0 0 0.0 0.0 L3 14/0 881.92 MB 0.9 0.0 0.0 0.0 0.0 0.0 17.2 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 156/0 9.72 GB 1.0 0.0 0.0 0.0 0.0 0.0 16.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 72/0 6.64 GB 0.1 0.0 0.0 0.0 0.0 0.0 6.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 242/0 17.22 GB 0.0 0.0 0.0 0.0 17.2 17.2 40.2 1.0 0.0 251.6 70.12 64.14 242 0.290 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 16.9 16.9 39.9 1.0 0.0 255.4 67.58 61.75 238 0.284 0 0 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- High 0/0 0.00 KB 0.0 0.0 0.0 0.0 17.2 17.2 0.0 0.0 0.0 251.6 70.12 64.14 242 0.290 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 97.6 total, 94.6 interval Flush(GB): cumulative 17.225, interval 16.856 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 17.22 GB write, 180.65 MB/s write, 0.00 GB read, 0.00 MB/s read, 70.1 seconds Interval compaction: 16.86 GB write, 182.43 MB/s write, 0.00 GB read, 0.00 MB/s read, 67.6 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 76, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 76, interval: 72 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1210 Average: 644.5884 StdDev: 1187.09 Min: 1 Median: 5.9688 Max: 4622 Percentiles: P50: 5.97 P75: 460.49 P99: 4322.12 P99.9: 4622.00 P99.99: 4622.00 ------------------------------------------------------ [ 0, 1 ] 207 17.107% 17.107% ### ( 1, 2 ] 173 14.298% 31.405% ### ( 2, 3 ] 94 7.769% 39.174% ## ( 3, 4 ] 5 0.413% 39.587% ( 4, 6 ] 128 10.579% 50.165% ## ( 6, 10 ] 95 7.851% 58.017% ## ( 10, 15 ] 22 1.818% 59.835% ( 22, 34 ] 2 0.165% 60.000% ( 250, 380 ] 165 13.636% 73.636% ### ( 380, 580 ] 41 3.388% 77.025% # ( 580, 870 ] 1 0.083% 77.107% ( 870, 1300 ] 81 6.694% 83.802% # ( 1300, 1900 ] 24 1.983% 85.785% ( 1900, 2900 ] 12 0.992% 86.777% ( 2900, 4400 ] 156 12.893% 99.669% ### ( 4400, 6600 ] 4 0.331% 100.000% ** DB Stats ** Uptime(secs): 97.6 total, 5.3 interval Cumulative writes: 0 writes, 18M keys, 0 commit groups, 0.0 writes per commit group, ingest: 17.30 GB, 181.44 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:22.741 H:M:S, 23.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 187.42 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.000 H:M:S, 0.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/07/15-14:00:56 ... thread 0: (1000000,19000000) ops and (190002.1,184692.1) ops/second in (5.263101,102.873892) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 0/0 0.00 KB 0.0 0.0 0.0 0.0 18.2 18.2 0.0 1.0 0.0 254.0 73.41 67.09 258 0.285 0 0 0.0 0.0 L3 14/0 881.91 MB 0.9 0.0 0.0 0.0 0.0 0.0 18.2 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 156/0 9.60 GB 1.0 0.0 0.0 0.0 0.0 0.0 17.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 88/0 7.75 GB 0.1 0.0 0.0 0.0 0.0 0.0 7.8 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 258/0 18.21 GB 0.0 0.0 0.0 0.0 18.2 18.2 43.3 1.0 0.0 254.0 73.41 67.09 258 0.285 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 17.8 17.8 42.9 1.0 0.0 257.8 70.88 64.70 254 0.279 0 0 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- High 0/0 0.00 KB 0.0 0.0 0.0 0.0 18.2 18.2 0.0 0.0 0.0 254.0 73.41 67.09 258 0.285 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 102.9 total, 99.9 interval Flush(GB): cumulative 18.209, interval 17.840 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 18.21 GB write, 181.20 MB/s write, 0.00 GB read, 0.00 MB/s read, 73.4 seconds Interval compaction: 17.84 GB write, 182.91 MB/s write, 0.00 GB read, 0.00 MB/s read, 70.9 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 76, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 76, interval: 72 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1290 Average: 642.7791 StdDev: 1184.33 Min: 1 Median: 5.9143 Max: 4622 Percentiles: P50: 5.91 P75: 440.98 P99: 4320.54 P99.9: 4622.00 P99.99: 4622.00 ------------------------------------------------------ [ 0, 1 ] 224 17.364% 17.364% ### ( 1, 2 ] 188 14.574% 31.938% ### ( 2, 3 ] 94 7.287% 39.225% # ( 3, 4 ] 5 0.388% 39.612% ( 4, 6 ] 140 10.853% 50.465% ## ( 6, 10 ] 99 7.674% 58.140% ## ( 10, 15 ] 22 1.705% 59.845% ( 22, 34 ] 2 0.155% 60.000% ( 250, 380 ] 181 14.031% 74.031% ### ( 380, 580 ] 41 3.178% 77.209% # ( 580, 870 ] 1 0.078% 77.287% ( 870, 1300 ] 84 6.512% 83.798% # ( 1300, 1900 ] 25 1.938% 85.736% ( 1900, 2900 ] 12 0.930% 86.667% ( 2900, 4400 ] 168 13.023% 99.690% ### ( 4400, 6600 ] 4 0.310% 100.000% ** DB Stats ** Uptime(secs): 102.9 total, 5.3 interval Cumulative writes: 0 writes, 19M keys, 0 commit groups, 0.0 writes per commit group, ingest: 18.26 GB, 181.72 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:22.741 H:M:S, 22.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 187.00 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.000 H:M:S, 0.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 0 2024/07/15-14:01:01 ... thread 0: (1000000,20000000) ops and (189401.8,184922.1) ops/second in (5.279782,108.153674) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 0/0 0.00 KB 0.0 0.0 0.0 0.0 19.1 19.1 0.0 1.0 0.0 255.7 76.62 69.96 273 0.281 0 0 0.0 0.0 L2 1/0 63.00 MB 0.6 0.0 0.0 0.0 0.0 0.0 19.1 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L3 12/0 755.92 MB 0.8 0.0 0.0 0.0 0.0 0.0 19.1 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 156/0 9.60 GB 1.0 0.0 0.0 0.0 0.0 0.0 18.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 104/0 8.74 GB 0.1 0.0 0.0 0.0 0.0 0.0 8.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 273/0 19.13 GB 0.0 0.0 0.0 0.0 19.1 19.1 65.3 1.0 0.0 255.7 76.62 69.96 273 0.281 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 18.8 18.8 64.9 1.0 0.0 259.3 74.09 67.57 269 0.275 0 0 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- High 0/0 0.00 KB 0.0 0.0 0.0 0.0 19.1 19.1 0.0 0.0 0.0 255.7 76.62 69.96 273 0.281 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 108.2 total, 105.2 interval Flush(GB): cumulative 19.132, interval 18.763 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 19.13 GB write, 181.09 MB/s write, 0.00 GB read, 0.00 MB/s read, 76.6 seconds Interval compaction: 18.76 GB write, 182.71 MB/s write, 0.00 GB read, 0.00 MB/s read, 74.1 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 76, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 76, interval: 72 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1365 Average: 643.9993 StdDev: 1186.18 Min: 1 Median: 5.8497 Max: 4622 Percentiles: P50: 5.85 P75: 422.68 P99: 4320.03 P99.9: 4622.00 P99.99: 4622.00 ------------------------------------------------------ [ 0, 1 ] 237 17.363% 17.363% ### ( 1, 2 ] 205 15.018% 32.381% ### ( 2, 3 ] 94 6.886% 39.267% # ( 3, 4 ] 5 0.366% 39.634% ( 4, 6 ] 153 11.209% 50.842% ## ( 6, 10 ] 101 7.399% 58.242% # ( 10, 15 ] 22 1.612% 59.853% ( 22, 34 ] 2 0.147% 60.000% ( 250, 380 ] 196 14.359% 74.359% ### ( 380, 580 ] 41 3.004% 77.363% # ( 580, 870 ] 1 0.073% 77.436% ( 870, 1300 ] 86 6.300% 83.736% # ( 1300, 1900 ] 25 1.832% 85.568% ( 1900, 2900 ] 12 0.879% 86.447% ( 2900, 4400 ] 181 13.260% 99.707% ### ( 4400, 6600 ] 4 0.293% 100.000% ** DB Stats ** Uptime(secs): 108.2 total, 5.3 interval Cumulative writes: 0 writes, 20M keys, 0 commit groups, 0.0 writes per commit group, ingest: 19.22 GB, 181.95 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:22.741 H:M:S, 21.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 186.41 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.000 H:M:S, 0.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 using bdev Nvme0n1 Initializing RocksDB Options from the specified file Initializing RocksDB Options from command-line flags Integrated BlobDB: blob cache disabled Keys: 16 bytes each (+ 0 bytes user-defined timestamp) Values: 1000 bytes each (1000 bytes after compression) Entries: 20000000 Prefix: 0 bytes Keys per prefix: 0 RawSize: 19378.7 MB (estimated) FileSize: 19378.7 MB (estimated) Write rate: 0 bytes/second Read rate: 0 ops/second Compression: NoCompression Compression sampling rate: 0 Memtablerep: SkipListFactory Perf Level: 1 ------------------------------------------------ Initializing RocksDB Options from the specified file Initializing RocksDB Options from command-line flags Integrated BlobDB: blob cache disabled DB path: [/mnt/rocksdb] fillseq : 5.408 micros/op 184919 ops/sec 108.155 seconds 20000000 operations; 179.2 MB/s Microseconds per write: Count: 20000000 Average: 5.4077 StdDev: 747.06 Min: 1 Median: 2.5795 Max: 690941 Percentiles: P50: 2.58 P75: 3.70 P99: 14.75 P99.9: 120.40 P99.99: 371.79 ------------------------------------------------------ [ 0, 1 ] 3162230 15.811% 15.811% ### ( 1, 2 ] 2201477 11.007% 26.819% ## ( 2, 3 ] 8000549 40.003% 66.821% ######## ( 3, 4 ] 2339221 11.696% 78.517% ## ( 4, 6 ] 680797 3.404% 81.921% # ( 6, 10 ] 2806617 14.033% 95.954% ### ( 10, 15 ] 640830 3.204% 99.159% # ( 15, 22 ] 113938 0.570% 99.728% ( 22, 34 ] 27963 0.140% 99.868% ( 34, 51 ] 4533 0.023% 99.891% ( 51, 76 ] 1359 0.007% 99.898% ( 76, 110 ] 145 0.001% 99.898% ( 110, 170 ] 1967 0.010% 99.908% ( 170, 250 ] 4821 0.024% 99.932% ( 250, 380 ] 12332 0.062% 99.994% ( 380, 580 ] 874 0.004% 99.998% ( 580, 870 ] 237 0.001% 99.999% ( 870, 1300 ] 18 0.000% 100.000% ( 1300, 1900 ] 5 0.000% 100.000% ( 1900, 2900 ] 7 0.000% 100.000% ( 2900, 4400 ] 3 0.000% 100.000% ( 4400, 6600 ] 1 0.000% 100.000% ( 22000, 33000 ] 1 0.000% 100.000% ( 33000, 50000 ] 7 0.000% 100.000% ( 50000, 75000 ] 26 0.000% 100.000% ( 75000, 110000 ] 1 0.000% 100.000% ( 170000, 250000 ] 2 0.000% 100.000% ( 250000, 380000 ] 1 0.000% 100.000% ( 380000, 570000 ] 31 0.000% 100.000% ( 570000, 860000 ] 7 0.000% 100.000% STATISTICS: rocksdb.block.cache.miss COUNT : 0 rocksdb.block.cache.hit COUNT : 0 rocksdb.block.cache.add COUNT : 0 rocksdb.block.cache.add.failures COUNT : 0 rocksdb.block.cache.index.miss COUNT : 0 rocksdb.block.cache.index.hit COUNT : 0 rocksdb.block.cache.index.add COUNT : 0 rocksdb.block.cache.index.bytes.insert COUNT : 0 rocksdb.block.cache.filter.miss COUNT : 0 rocksdb.block.cache.filter.hit COUNT : 0 rocksdb.block.cache.filter.add COUNT : 0 rocksdb.block.cache.filter.bytes.insert COUNT : 0 rocksdb.block.cache.data.miss COUNT : 0 rocksdb.block.cache.data.hit COUNT : 0 rocksdb.block.cache.data.add COUNT : 0 rocksdb.block.cache.data.bytes.insert COUNT : 0 rocksdb.block.cache.bytes.read COUNT : 0 rocksdb.block.cache.bytes.write COUNT : 0 rocksdb.bloom.filter.useful COUNT : 0 rocksdb.bloom.filter.full.positive COUNT : 0 rocksdb.bloom.filter.full.true.positive COUNT : 0 rocksdb.persistent.cache.hit COUNT : 0 rocksdb.persistent.cache.miss COUNT : 0 rocksdb.sim.block.cache.hit COUNT : 0 rocksdb.sim.block.cache.miss COUNT : 0 rocksdb.memtable.hit COUNT : 0 rocksdb.memtable.miss COUNT : 0 rocksdb.l0.hit COUNT : 0 rocksdb.l1.hit COUNT : 0 rocksdb.l2andup.hit COUNT : 0 rocksdb.compaction.key.drop.new COUNT : 0 rocksdb.compaction.key.drop.obsolete COUNT : 0 rocksdb.compaction.key.drop.range_del COUNT : 0 rocksdb.compaction.key.drop.user COUNT : 0 rocksdb.compaction.range_del.drop.obsolete COUNT : 0 rocksdb.compaction.optimized.del.drop.obsolete COUNT : 0 rocksdb.compaction.cancelled COUNT : 0 rocksdb.number.keys.written COUNT : 20000000 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 20640000000 rocksdb.bytes.read COUNT : 0 rocksdb.number.db.seek COUNT : 0 rocksdb.number.db.next COUNT : 0 rocksdb.number.db.prev COUNT : 0 rocksdb.number.db.seek.found COUNT : 0 rocksdb.number.db.next.found COUNT : 0 rocksdb.number.db.prev.found COUNT : 0 rocksdb.db.iter.bytes.read COUNT : 0 rocksdb.no.file.opens COUNT : 273 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 22741297 rocksdb.db.mutex.wait.micros COUNT : 0 rocksdb.number.multiget.get COUNT : 0 rocksdb.number.multiget.keys.read COUNT : 0 rocksdb.number.multiget.bytes.read COUNT : 0 rocksdb.number.merge.failures COUNT : 0 rocksdb.bloom.filter.prefix.checked COUNT : 0 rocksdb.bloom.filter.prefix.useful COUNT : 0 rocksdb.number.reseeks.iteration COUNT : 0 rocksdb.getupdatessince.calls COUNT : 0 rocksdb.wal.synced COUNT : 0 rocksdb.wal.bytes COUNT : 0 rocksdb.write.self COUNT : 0 rocksdb.write.other COUNT : 0 rocksdb.write.wal COUNT : 0 rocksdb.compact.read.bytes COUNT : 0 rocksdb.compact.write.bytes COUNT : 0 rocksdb.flush.write.bytes COUNT : 20542724436 rocksdb.compact.read.marked.bytes COUNT : 0 rocksdb.compact.read.periodic.bytes COUNT : 0 rocksdb.compact.read.ttl.bytes COUNT : 0 rocksdb.compact.write.marked.bytes COUNT : 0 rocksdb.compact.write.periodic.bytes COUNT : 0 rocksdb.compact.write.ttl.bytes COUNT : 0 rocksdb.number.direct.load.table.properties COUNT : 0 rocksdb.number.superversion_acquires COUNT : 0 rocksdb.number.superversion_releases COUNT : 0 rocksdb.number.superversion_cleanups COUNT : 0 rocksdb.number.block.compressed COUNT : 0 rocksdb.number.block.decompressed COUNT : 0 rocksdb.number.block.not_compressed COUNT : 0 rocksdb.merge.operation.time.nanos COUNT : 0 rocksdb.filter.operation.time.nanos COUNT : 0 rocksdb.row.cache.hit COUNT : 0 rocksdb.row.cache.miss COUNT : 0 rocksdb.read.amp.estimate.useful.bytes COUNT : 0 rocksdb.read.amp.total.read.bytes COUNT : 0 rocksdb.number.rate_limiter.drains COUNT : 0 rocksdb.number.iter.skip COUNT : 0 rocksdb.blobdb.num.put COUNT : 0 rocksdb.blobdb.num.write COUNT : 0 rocksdb.blobdb.num.get COUNT : 0 rocksdb.blobdb.num.multiget COUNT : 0 rocksdb.blobdb.num.seek COUNT : 0 rocksdb.blobdb.num.next COUNT : 0 rocksdb.blobdb.num.prev COUNT : 0 rocksdb.blobdb.num.keys.written COUNT : 0 rocksdb.blobdb.num.keys.read COUNT : 0 rocksdb.blobdb.bytes.written COUNT : 0 rocksdb.blobdb.bytes.read COUNT : 0 rocksdb.blobdb.write.inlined COUNT : 0 rocksdb.blobdb.write.inlined.ttl COUNT : 0 rocksdb.blobdb.write.blob COUNT : 0 rocksdb.blobdb.write.blob.ttl COUNT : 0 rocksdb.blobdb.blob.file.bytes.written COUNT : 0 rocksdb.blobdb.blob.file.bytes.read COUNT : 0 rocksdb.blobdb.blob.file.synced COUNT : 0 rocksdb.blobdb.blob.index.expired.count COUNT : 0 rocksdb.blobdb.blob.index.expired.size COUNT : 0 rocksdb.blobdb.blob.index.evicted.count COUNT : 0 rocksdb.blobdb.blob.index.evicted.size COUNT : 0 rocksdb.blobdb.gc.num.files COUNT : 0 rocksdb.blobdb.gc.num.new.files COUNT : 0 rocksdb.blobdb.gc.failures COUNT : 0 rocksdb.blobdb.gc.num.keys.relocated COUNT : 0 rocksdb.blobdb.gc.bytes.relocated COUNT : 0 rocksdb.blobdb.fifo.num.files.evicted COUNT : 0 rocksdb.blobdb.fifo.num.keys.evicted COUNT : 0 rocksdb.blobdb.fifo.bytes.evicted COUNT : 0 rocksdb.txn.overhead.mutex.prepare COUNT : 0 rocksdb.txn.overhead.mutex.old.commit.map COUNT : 0 rocksdb.txn.overhead.duplicate.key COUNT : 0 rocksdb.txn.overhead.mutex.snapshot COUNT : 0 rocksdb.txn.get.tryagain COUNT : 0 rocksdb.number.multiget.keys.found COUNT : 0 rocksdb.num.iterator.created COUNT : 0 rocksdb.num.iterator.deleted COUNT : 0 rocksdb.block.cache.compression.dict.miss COUNT : 0 rocksdb.block.cache.compression.dict.hit COUNT : 0 rocksdb.block.cache.compression.dict.add COUNT : 0 rocksdb.block.cache.compression.dict.bytes.insert COUNT : 0 rocksdb.block.cache.add.redundant COUNT : 0 rocksdb.block.cache.index.add.redundant COUNT : 0 rocksdb.block.cache.filter.add.redundant COUNT : 0 rocksdb.block.cache.data.add.redundant COUNT : 0 rocksdb.block.cache.compression.dict.add.redundant COUNT : 0 rocksdb.files.marked.trash COUNT : 0 rocksdb.files.deleted.immediately COUNT : 0 rocksdb.error.handler.bg.errro.count COUNT : 0 rocksdb.error.handler.bg.io.errro.count COUNT : 0 rocksdb.error.handler.bg.retryable.io.errro.count COUNT : 0 rocksdb.error.handler.autoresume.count COUNT : 0 rocksdb.error.handler.autoresume.retry.total.count COUNT : 0 rocksdb.error.handler.autoresume.success.count COUNT : 0 rocksdb.memtable.payload.bytes.at.flush COUNT : 20378305536 rocksdb.memtable.garbage.bytes.at.flush COUNT : 0 rocksdb.secondary.cache.hits COUNT : 0 rocksdb.verify_checksum.read.bytes COUNT : 0 rocksdb.backup.read.bytes COUNT : 0 rocksdb.backup.write.bytes COUNT : 0 rocksdb.remote.compact.read.bytes COUNT : 0 rocksdb.remote.compact.write.bytes COUNT : 0 rocksdb.hot.file.read.bytes COUNT : 0 rocksdb.warm.file.read.bytes COUNT : 0 rocksdb.cold.file.read.bytes COUNT : 0 rocksdb.hot.file.read.count COUNT : 0 rocksdb.warm.file.read.count COUNT : 0 rocksdb.cold.file.read.count COUNT : 0 rocksdb.last.level.read.bytes COUNT : 0 rocksdb.last.level.read.count COUNT : 0 rocksdb.non.last.level.read.bytes COUNT : 124516555 rocksdb.non.last.level.read.count COUNT : 1365 rocksdb.block.checksum.compute.count COUNT : 819 rocksdb.multiget.coroutine.count COUNT : 0 rocksdb.blobdb.cache.miss COUNT : 0 rocksdb.blobdb.cache.hit COUNT : 0 rocksdb.blobdb.cache.add COUNT : 0 rocksdb.blobdb.cache.add.failures COUNT : 0 rocksdb.blobdb.cache.bytes.read COUNT : 0 rocksdb.blobdb.cache.bytes.write COUNT : 0 rocksdb.read.async.micros COUNT : 0 rocksdb.async.read.error.count COUNT : 0 rocksdb.secondary.cache.filter.hits COUNT : 0 rocksdb.secondary.cache.index.hits COUNT : 0 rocksdb.secondary.cache.data.hits COUNT : 0 rocksdb.table.open.prefetch.tail.miss COUNT : 0 rocksdb.table.open.prefetch.tail.hit COUNT : 0 rocksdb.db.get.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.db.write.micros P50 : 1.501304 P95 : 9.553349 P99 : 14.231421 P100 : 690939.000000 COUNT : 20000000 SUM : 88662181 rocksdb.compaction.times.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.compaction.times.cpu_micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.subcompaction.setup.times.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.table.sync.micros P50 : 517.185930 P95 : 823.076389 P99 : 867.059722 P100 : 983.000000 COUNT : 273 SUM : 157088 rocksdb.compaction.outfile.sync.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.wal.file.sync.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.manifest.file.sync.micros P50 : 235.207547 P95 : 2418.348624 P99 : 2803.669725 P100 : 2832.000000 COUNT : 1050 SUM : 594724 rocksdb.table.open.io.micros P50 : 3535.350318 P95 : 5947.173913 P99 : 6469.434783 P100 : 6502.000000 COUNT : 273 SUM : 989777 rocksdb.db.multiget.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.read.block.compaction.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.read.block.get.micros P50 : 1185.918367 P95 : 4236.440678 P99 : 4729.000000 P100 : 4729.000000 COUNT : 546 SUM : 927142 rocksdb.write.raw.block.micros P50 : 0.731969 P95 : 1.990157 P99 : 8.557394 P100 : 9877.000000 COUNT : 4991365 SUM : 16134364 rocksdb.numfiles.in.singlecompaction P50 : 1.000000 P95 : 3.575275 P99 : 3.915055 P100 : 4.000000 COUNT : 773 SUM : 1182 rocksdb.db.seek.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.db.write.stall P50 : 380000.000000 P95 : 690619.000000 P99 : 690619.000000 P100 : 690619.000000 COUNT : 76 SUM : 22741297 rocksdb.sst.read.micros P50 : 5.849673 P95 : 3867.541436 P99 : 4320.027624 P100 : 4622.000000 COUNT : 1365 SUM : 879059 rocksdb.num.subcompactions.scheduled P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.bytes.per.read P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.bytes.per.write P50 : 1032.000000 P95 : 1032.000000 P99 : 1032.000000 P100 : 1032.000000 COUNT : 20000000 SUM : 20640000000 rocksdb.bytes.per.multiget P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.bytes.compressed P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.bytes.decompressed P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.compression.times.nanos P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.decompression.times.nanos P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.read.num.merge_operands P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.blobdb.key.size P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.blobdb.value.size P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.blobdb.write.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.blobdb.get.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.blobdb.multiget.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.blobdb.seek.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.blobdb.next.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.blobdb.prev.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.blobdb.blob.file.write.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.blobdb.blob.file.read.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.blobdb.blob.file.sync.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.blobdb.compression.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.blobdb.decompression.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.db.flush.micros P50 : 225151.515152 P95 : 755828.947368 P99 : 832195.000000 P100 : 832195.000000 COUNT : 273 SUM : 76624327 rocksdb.sst.batch.size P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.num.index.and.filter.blocks.read.per.level P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.num.sst.read.per.level P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.error.handler.autoresume.retry.count P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.async.read.bytes P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.poll.wait.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.prefetched.bytes.discarded P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.multiget.io.batch.size P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.num.level.read.per.multiget P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.async.prefetch.abort.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.table.open.prefetch.tail.read.bytes P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0