[2024-11-19 11:02:53.720065] Starting SPDK v25.01-pre git sha1 029355612 / DPDK 24.03.0 initialization... [2024-11-19 11:02:53.720338] [ 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_pid2822485 ] Set seed to 1732010573713200 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-11-19 11:02:53.849904] app.c: 919:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-11-19 11:02:53.959266] app.c: 612:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-11-19 11:02:53.959314] app.c: 613:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 2822485' to capture a snapshot of events at runtime. [2024-11-19 11:02:53.959325] app.c: 618:app_setup_trace: *NOTICE*: 'spdk_trace' without parameters will also work if this is the only [2024-11-19 11:02:53.959335] app.c: 619:app_setup_trace: *NOTICE*: SPDK application currently running. [2024-11-19 11:02:53.959342] app.c: 620:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid2822485 for offline analysis/debug. [2024-11-19 11:02:53.960773] reactor.c:1005:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Tue Nov 19 11:02:59 2024 CPU: 96 * Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz CPUCache: 36608 KB 2024/11/19-11:03:02 ... thread 0: (1000000,1000000) ops and (418325.5,418325.5) ops/second in (2.390483,2.390483) 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 404.7 2.02 1.82 10 0.202 0 0 0.0 0.0 L3 10/0 818.91 MB 0.8 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 Sum 10/0 818.91 MB 0.0 0.0 0.0 0.0 0.8 0.8 0.8 1.0 0.0 404.7 2.02 1.82 10 0.202 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 0.8 0.8 0.8 1.0 0.0 404.7 2.02 1.82 10 0.202 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 404.7 2.02 1.82 10 0.202 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): 2.4 total, 2.4 interval Flush(GB): cumulative 0.800, interval 0.800 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, 336.31 MB/s write, 0.00 GB read, 0.00 MB/s read, 2.0 seconds Interval compaction: 0.80 GB write, 336.31 MB/s write, 0.00 GB read, 0.00 MB/s read, 2.0 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: 7, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 7, interval: 7 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 50 Average: 434.0000 StdDev: 878.81 Min: 0 Median: 3.6000 Max: 3229 Percentiles: P50: 3.60 P75: 271.67 P99: 3229.00 P99.9: 3229.00 P99.99: 3229.00 ------------------------------------------------------ [ 0, 1 ] 20 40.000% 40.000% ######## ( 2, 3 ] 2 4.000% 44.000% # ( 3, 4 ] 5 10.000% 54.000% ## ( 4, 6 ] 3 6.000% 60.000% # ( 110, 170 ] 5 10.000% 70.000% ## ( 170, 250 ] 2 4.000% 74.000% # ( 250, 380 ] 3 6.000% 80.000% # ( 870, 1300 ] 5 10.000% 90.000% ## ( 1300, 1900 ] 1 2.000% 92.000% ( 2900, 4400 ] 4 8.000% 100.000% ## ** DB Stats ** Uptime(secs): 2.4 total, 2.4 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 404.17 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:0.695 H:M:S, 28.5 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 404.17 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.695 H:M:S, 28.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/11/19-11:03:04 ... thread 0: (1000000,2000000) ops and (408822.1,413519.2) ops/second in (2.446052,4.836535) 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 424.7 4.30 3.87 22 0.195 0 0 0.0 0.0 L3 10/0 818.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 1007.88 MB 0.1 0.0 0.0 0.0 0.0 0.0 1.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 22/0 1.78 GB 0.0 0.0 0.0 0.0 1.8 1.8 2.8 1.0 0.0 424.7 4.30 3.87 22 0.195 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 0.7 0.7 1.4 1.0 0.0 440.1 1.72 1.55 9 0.191 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 424.7 4.30 3.87 22 0.195 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): 4.9 total, 1.8 interval Flush(GB): cumulative 1.784, interval 0.738 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.78 GB write, 374.26 MB/s write, 0.00 GB read, 0.00 MB/s read, 4.3 seconds Interval compaction: 0.74 GB write, 411.68 MB/s write, 0.00 GB read, 0.00 MB/s read, 1.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: 14, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 14, interval: 5 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 110 Average: 445.4727 StdDev: 928.73 Min: 0 Median: 3.5833 Max: 3445 Percentiles: P50: 3.58 P75: 277.86 P99: 3445.00 P99.9: 3445.00 P99.99: 3445.00 ------------------------------------------------------ [ 0, 1 ] 44 40.000% 40.000% ######## ( 2, 3 ] 4 3.636% 43.636% # ( 3, 4 ] 12 10.909% 54.545% ## ( 4, 6 ] 5 4.545% 59.091% # ( 6, 10 ] 1 0.909% 60.000% ( 110, 170 ] 6 5.455% 65.455% # ( 170, 250 ] 9 8.182% 73.636% ## ( 250, 380 ] 7 6.364% 80.000% # ( 380, 580 ] 1 0.909% 80.909% ( 580, 870 ] 1 0.909% 81.818% ( 870, 1300 ] 9 8.182% 90.000% ## ( 1300, 1900 ] 1 0.909% 90.909% ( 1900, 2900 ] 1 0.909% 91.818% ( 2900, 4400 ] 9 8.182% 100.000% ## ** DB Stats ** Uptime(secs): 4.9 total, 1.8 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 403.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:1.480 H:M:S, 30.3 percent Interval writes: 0 writes, 743K keys, 0 commit groups, 0.0 writes per commit group, ingest: 731.33 MB, 398.09 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.603 H:M:S, 32.8 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/11/19-11:03:07 ... thread 0: (1000000,3000000) ops and (397835.3,408155.6) ops/second in (2.513603,7.350138) 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.7 2.7 0.0 1.0 0.0 426.8 6.49 5.84 33 0.197 0 0 0.0 0.0 L2 1/0 62.99 MB 0.6 0.0 0.0 0.0 0.0 0.0 2.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L3 8/0 692.91 MB 0.7 0.0 0.0 0.0 0.0 0.0 2.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 24/0 1.97 GB 0.2 0.0 0.0 0.0 0.0 0.0 2.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 33/0 2.71 GB 0.0 0.0 0.0 0.0 2.7 2.7 7.3 1.0 0.0 426.8 6.49 5.84 33 0.197 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 1.7 1.7 6.0 1.0 0.0 434.9 3.91 3.51 20 0.196 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.7 2.7 0.0 0.0 0.0 426.8 6.49 5.84 33 0.197 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): 7.4 total, 4.3 interval Flush(GB): cumulative 2.707, interval 1.661 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.71 GB write, 374.82 MB/s write, 0.00 GB read, 0.00 MB/s read, 6.5 seconds Interval compaction: 1.66 GB write, 391.00 MB/s write, 0.00 GB read, 0.00 MB/s read, 3.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: 21, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 21, interval: 12 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 165 Average: 479.9515 StdDev: 1011.79 Min: 0 Median: 3.4722 Max: 4045 Percentiles: P50: 3.47 P75: 282.50 P99: 4045.00 P99.9: 4045.00 P99.99: 4045.00 ------------------------------------------------------ [ 0, 1 ] 66 40.000% 40.000% ######## ( 2, 3 ] 8 4.848% 44.848% # ( 3, 4 ] 18 10.909% 55.758% ## ( 4, 6 ] 6 3.636% 59.394% # ( 6, 10 ] 1 0.606% 60.000% ( 110, 170 ] 8 4.848% 64.848% # ( 170, 250 ] 14 8.485% 73.333% ## ( 250, 380 ] 11 6.667% 80.000% # ( 380, 580 ] 1 0.606% 80.606% ( 580, 870 ] 3 1.818% 82.424% ( 870, 1300 ] 11 6.667% 89.091% # ( 1300, 1900 ] 2 1.212% 90.303% ( 1900, 2900 ] 1 0.606% 90.909% ( 2900, 4400 ] 15 9.091% 100.000% ## ** DB Stats ** Uptime(secs): 7.4 total, 2.5 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 399.28 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.333 H:M:S, 31.5 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 391.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:0.853 H:M:S, 33.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/11/19-11:03:09 ... thread 0: (1000000,4000000) ops and (398687.2,405746.6) ops/second in (2.508232,9.858370) 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 430.0 8.79 7.89 45 0.195 0 0 0.0 0.0 L2 1/0 62.99 MB 0.6 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 L3 8/0 692.92 MB 0.7 0.0 0.0 0.0 0.0 0.0 3.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 36/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 45/0 3.69 GB 0.0 0.0 0.0 0.0 3.7 3.7 10.3 1.0 0.0 430.0 8.79 7.89 45 0.195 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 2.6 2.6 8.9 1.0 0.0 436.4 6.21 5.56 32 0.194 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 430.0 8.79 7.89 45 0.195 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): 9.9 total, 6.9 interval Flush(GB): cumulative 3.691, interval 2.645 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, 381.66 MB/s write, 0.00 GB read, 0.00 MB/s read, 8.8 seconds Interval compaction: 2.65 GB write, 394.97 MB/s write, 0.00 GB read, 0.00 MB/s read, 6.2 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: 29, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 29, interval: 20 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 225 Average: 499.2667 StdDev: 1040.96 Min: 0 Median: 3.5435 Max: 4193 Percentiles: P50: 3.54 P75: 282.50 P99: 4193.00 P99.9: 4193.00 P99.99: 4193.00 ------------------------------------------------------ [ 0, 1 ] 86 38.222% 38.222% ######## ( 1, 2 ] 2 0.889% 39.111% ( 2, 3 ] 12 5.333% 44.444% # ( 3, 4 ] 23 10.222% 54.667% ## ( 4, 6 ] 10 4.444% 59.111% # ( 6, 10 ] 2 0.889% 60.000% ( 110, 170 ] 10 4.444% 64.444% # ( 170, 250 ] 20 8.889% 73.333% ## ( 250, 380 ] 15 6.667% 80.000% # ( 380, 580 ] 2 0.889% 80.889% ( 580, 870 ] 3 1.333% 82.222% ( 870, 1300 ] 12 5.333% 87.556% # ( 1300, 1900 ] 4 1.778% 89.333% ( 1900, 2900 ] 4 1.778% 91.111% ( 2900, 4400 ] 20 8.889% 100.000% ## ** DB Stats ** Uptime(secs): 9.9 total, 2.5 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 397.53 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:3.180 H:M:S, 32.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 392.39 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.847 H:M:S, 33.8 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/11/19-11:03:12 ... thread 0: (1000000,5000000) ops and (393900.7,403320.7) ops/second in (2.538711,12.397081) 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 430.8 11.11 9.96 57 0.195 0 0 0.0 0.0 L2 1/0 62.99 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 8/0 692.92 MB 0.7 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 48/0 3.94 GB 0.4 0.0 0.0 0.0 0.0 0.0 3.9 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 57/0 4.68 GB 0.0 0.0 0.0 0.0 4.7 4.7 13.2 1.0 0.0 430.8 11.11 9.96 57 0.195 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 3.6 3.6 11.9 1.0 0.0 435.7 8.53 7.63 44 0.194 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 430.8 11.11 9.96 57 0.195 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): 12.4 total, 9.4 interval Flush(GB): cumulative 4.675, interval 3.629 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, 384.80 MB/s write, 0.00 GB read, 0.00 MB/s read, 11.1 seconds Interval compaction: 3.63 GB write, 395.52 MB/s write, 0.00 GB read, 0.00 MB/s read, 8.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: 37, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 37, interval: 28 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 285 Average: 539.0175 StdDev: 1133.78 Min: 0 Median: 3.5179 Max: 5968 Percentiles: P50: 3.52 P75: 289.34 P99: 4352.78 P99.9: 5968.00 P99.99: 5968.00 ------------------------------------------------------ [ 0, 1 ] 109 38.246% 38.246% ######## ( 1, 2 ] 2 0.702% 38.947% ( 2, 3 ] 17 5.965% 44.912% # ( 3, 4 ] 28 9.825% 54.737% ## ( 4, 6 ] 12 4.211% 58.947% # ( 6, 10 ] 3 1.053% 60.000% ( 110, 170 ] 13 4.561% 64.561% # ( 170, 250 ] 24 8.421% 72.982% ## ( 250, 380 ] 19 6.667% 79.649% # ( 380, 580 ] 3 1.053% 80.702% ( 580, 870 ] 3 1.053% 81.754% ( 870, 1300 ] 15 5.263% 87.018% # ( 1300, 1900 ] 4 1.404% 88.421% ( 1900, 2900 ] 4 1.404% 89.825% ( 2900, 4400 ] 27 9.474% 99.298% ## ( 4400, 6600 ] 2 0.702% 100.000% ** DB Stats ** Uptime(secs): 12.4 total, 2.5 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 395.52 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:4.062 H:M:S, 32.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 387.67 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.882 H:M:S, 34.8 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/11/19-11:03:14 ... thread 0: (1000000,6000000) ops and (399042.0,402601.3) ops/second in (2.506002,14.903083) 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.7 5.7 0.0 1.0 0.0 432.6 13.40 11.99 69 0.194 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.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L3 8/0 692.93 MB 0.7 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 L4 60/0 4.92 GB 0.5 0.0 0.0 0.0 0.0 0.0 4.9 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 69/0 5.66 GB 0.0 0.0 0.0 0.0 5.7 5.7 16.2 1.0 0.0 432.6 13.40 11.99 69 0.194 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 4.6 4.6 14.8 1.0 0.0 437.0 10.81 9.67 56 0.193 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.7 5.7 0.0 0.0 0.0 432.6 13.40 11.99 69 0.194 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): 14.9 total, 11.9 interval Flush(GB): cumulative 5.660, interval 4.614 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.66 GB write, 387.71 MB/s write, 0.00 GB read, 0.00 MB/s read, 13.4 seconds Interval compaction: 4.61 GB write, 396.92 MB/s write, 0.00 GB read, 0.00 MB/s read, 10.8 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: 45, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 45, interval: 36 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 345 Average: 532.2029 StdDev: 1113.25 Min: 0 Median: 3.5000 Max: 5968 Percentiles: P50: 3.50 P75: 288.15 P99: 4334.09 P99.9: 5968.00 P99.99: 5968.00 ------------------------------------------------------ [ 0, 1 ] 133 38.551% 38.551% ######## ( 1, 2 ] 2 0.580% 39.130% ( 2, 3 ] 22 6.377% 45.507% # ( 3, 4 ] 31 8.986% 54.493% ## ( 4, 6 ] 16 4.638% 59.130% # ( 6, 10 ] 3 0.870% 60.000% ( 110, 170 ] 14 4.058% 64.058% # ( 170, 250 ] 31 8.986% 73.043% ## ( 250, 380 ] 23 6.667% 79.710% # ( 380, 580 ] 3 0.870% 80.580% ( 580, 870 ] 4 1.159% 81.739% ( 870, 1300 ] 18 5.217% 86.957% # ( 1300, 1900 ] 5 1.449% 88.406% ( 1900, 2900 ] 5 1.449% 89.855% ( 2900, 4400 ] 33 9.565% 99.420% ## ( 4400, 6600 ] 2 0.580% 100.000% ** DB Stats ** Uptime(secs): 14.9 total, 2.5 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 395.05 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:4.881 H:M:S, 32.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 392.74 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.818 H:M:S, 32.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/11/19-11:03:17 ... thread 0: (1000000,7000000) ops and (393627.3,401294.3) ops/second in (2.540474,17.443557) 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 432.8 15.57 13.95 80 0.195 0 0 0.0 0.0 L3 8/0 692.93 MB 0.7 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 72/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 80/0 6.58 GB 0.0 0.0 0.0 0.0 6.6 6.6 12.5 1.0 0.0 432.8 15.57 13.95 80 0.195 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 5.5 5.5 11.1 1.0 0.0 436.4 12.99 11.62 67 0.194 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 432.8 15.57 13.95 80 0.195 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 6.582, interval 5.537 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.58 GB write, 385.42 MB/s write, 0.00 GB read, 0.00 MB/s read, 15.6 seconds Interval compaction: 5.54 GB write, 392.53 MB/s write, 0.00 GB read, 0.00 MB/s read, 13.0 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: 53, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 53, interval: 44 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 400 Average: 536.0575 StdDev: 1113.50 Min: 0 Median: 3.4444 Max: 5968 Percentiles: P50: 3.44 P75: 288.52 P99: 4323.08 P99.9: 5968.00 P99.99: 5968.00 ------------------------------------------------------ [ 0, 1 ] 154 38.500% 38.500% ######## ( 1, 2 ] 3 0.750% 39.250% ( 2, 3 ] 27 6.750% 46.000% # ( 3, 4 ] 36 9.000% 55.000% ## ( 4, 6 ] 17 4.250% 59.250% # ( 6, 10 ] 3 0.750% 60.000% ( 110, 170 ] 15 3.750% 63.750% # ( 170, 250 ] 37 9.250% 73.000% ## ( 250, 380 ] 27 6.750% 79.750% # ( 380, 580 ] 4 1.000% 80.750% ( 580, 870 ] 4 1.000% 81.750% ( 870, 1300 ] 20 5.000% 86.750% # ( 1300, 1900 ] 5 1.250% 88.000% ( 1900, 2900 ] 7 1.750% 89.750% ( 2900, 4400 ] 39 9.750% 99.500% ## ( 4400, 6600 ] 2 0.500% 100.000% ** DB Stats ** Uptime(secs): 17.5 total, 2.5 interval Cumulative writes: 0 writes, 7000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 6.73 GB, 393.94 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:5.762 H:M:S, 32.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 387.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.882 H:M:S, 34.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/11/19-11:03:19 ... thread 0: (1000000,8000000) ops and (394701.8,400458.2) ops/second in (2.533558,19.977115) 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 432.6 17.91 16.03 92 0.195 0 0 0.0 0.0 L3 8/0 692.90 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 84/0 6.89 GB 0.7 0.0 0.0 0.0 0.0 0.0 6.9 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 92/0 7.57 GB 0.0 0.0 0.0 0.0 7.6 7.6 14.5 1.0 0.0 432.6 17.91 16.03 92 0.195 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 6.5 6.5 13.1 1.0 0.0 435.6 15.33 13.70 79 0.194 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 432.6 17.91 16.03 92 0.195 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): 20.0 total, 17.0 interval Flush(GB): cumulative 7.567, interval 6.521 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.57 GB write, 386.99 MB/s write, 0.00 GB read, 0.00 MB/s read, 17.9 seconds Interval compaction: 6.52 GB write, 393.32 MB/s write, 0.00 GB read, 0.00 MB/s read, 15.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: 61, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 61, interval: 52 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 460 Average: 548.0565 StdDev: 1129.66 Min: 0 Median: 3.4545 Max: 5968 Percentiles: P50: 3.45 P75: 291.94 P99: 4317.02 P99.9: 5968.00 P99.99: 5968.00 ------------------------------------------------------ [ 0, 1 ] 177 38.478% 38.478% ######## ( 1, 2 ] 3 0.652% 39.130% ( 2, 3 ] 30 6.522% 45.652% # ( 3, 4 ] 44 9.565% 55.217% ## ( 4, 6 ] 19 4.130% 59.348% # ( 6, 10 ] 3 0.652% 60.000% ( 110, 170 ] 19 4.130% 64.130% # ( 170, 250 ] 40 8.696% 72.826% ## ( 250, 380 ] 31 6.739% 79.565% # ( 380, 580 ] 5 1.087% 80.652% ( 580, 870 ] 4 0.870% 81.522% ( 870, 1300 ] 22 4.783% 86.304% # ( 1300, 1900 ] 6 1.304% 87.609% ( 1900, 2900 ] 8 1.739% 89.348% ( 2900, 4400 ] 47 10.217% 99.565% ## ( 4400, 6600 ] 2 0.435% 100.000% ** DB Stats ** Uptime(secs): 20.0 total, 2.5 interval Cumulative writes: 0 writes, 8000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 7.69 GB, 393.25 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.652 H:M:S, 33.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 388.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.890 H:M:S, 35.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/11/19-11:03:22 ... thread 0: (1000000,9000000) ops and (390429.5,399318.5) ops/second in (2.561282,22.538397) 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 431.0 20.31 18.18 104 0.195 0 0 0.0 0.0 L2 1/0 62.99 MB 0.6 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 L3 11/0 944.89 MB 0.9 0.0 0.0 0.0 0.0 0.0 8.5 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 92/0 7.57 GB 0.8 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 Sum 104/0 8.55 GB 0.0 0.0 0.0 0.0 8.6 8.6 24.6 1.0 0.0 431.0 20.31 18.18 104 0.195 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 7.5 7.5 23.3 1.0 0.0 433.4 17.73 15.86 91 0.195 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 431.0 20.31 18.18 104 0.195 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.6 total, 19.5 interval Flush(GB): cumulative 8.551, interval 7.505 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.55 GB write, 387.73 MB/s write, 0.00 GB read, 0.00 MB/s read, 20.3 seconds Interval compaction: 7.51 GB write, 393.34 MB/s write, 0.00 GB read, 0.00 MB/s read, 17.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: 69, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 69, interval: 60 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 520 Average: 541.8250 StdDev: 1113.70 Min: 0 Median: 3.4118 Max: 5968 Percentiles: P50: 3.41 P75: 290.86 P99: 4309.43 P99.9: 5968.00 P99.99: 5968.00 ------------------------------------------------------ [ 0, 1 ] 200 38.462% 38.462% ######## ( 1, 2 ] 4 0.769% 39.231% ( 2, 3 ] 35 6.731% 45.962% # ( 3, 4 ] 51 9.808% 55.769% ## ( 4, 6 ] 19 3.654% 59.423% # ( 6, 10 ] 3 0.577% 60.000% ( 110, 170 ] 21 4.038% 64.038% # ( 170, 250 ] 46 8.846% 72.885% ## ( 250, 380 ] 35 6.731% 79.615% # ( 380, 580 ] 5 0.962% 80.577% ( 580, 870 ] 4 0.769% 81.346% ( 870, 1300 ] 25 4.808% 86.154% # ( 1300, 1900 ] 9 1.731% 87.885% ( 1900, 2900 ] 8 1.538% 89.423% ( 2900, 4400 ] 53 10.192% 99.615% ## ( 4400, 6600 ] 2 0.385% 100.000% ** DB Stats ** Uptime(secs): 22.6 total, 2.6 interval Cumulative writes: 0 writes, 9000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 8.65 GB, 392.23 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:7.532 H:M:S, 33.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 384.27 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.880 H:M:S, 34.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/11/19-11:03:24 ... thread 0: (1000000,10000000) ops and (395301.4,398913.2) ops/second in (2.529715,25.068112) 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 431.5 22.48 20.12 115 0.195 0 0 0.0 0.0 L3 11/0 944.90 MB 0.9 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.55 GB 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 Sum 115/0 9.47 GB 0.0 0.0 0.0 0.0 9.5 9.5 18.0 1.0 0.0 431.5 22.48 20.12 115 0.195 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 8.4 8.4 16.7 1.0 0.0 433.7 19.90 17.80 102 0.195 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 431.5 22.48 20.12 115 0.195 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): 25.1 total, 22.1 interval Flush(GB): cumulative 9.474, interval 8.428 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.47 GB write, 386.30 MB/s write, 0.00 GB read, 0.00 MB/s read, 22.5 seconds Interval compaction: 8.43 GB write, 391.07 MB/s write, 0.00 GB read, 0.00 MB/s read, 19.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: 77, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 77, interval: 68 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 575 Average: 547.3565 StdDev: 1121.86 Min: 0 Median: 3.3947 Max: 5968 Percentiles: P50: 3.39 P75: 291.91 P99: 4307.79 P99.9: 5967.50 P99.99: 5968.00 ------------------------------------------------------ [ 0, 1 ] 219 38.087% 38.087% ######## ( 1, 2 ] 5 0.870% 38.957% ( 2, 3 ] 41 7.130% 46.087% # ( 3, 4 ] 57 9.913% 56.000% ## ( 4, 6 ] 19 3.304% 59.304% # ( 6, 10 ] 3 0.522% 59.826% ( 10, 15 ] 1 0.174% 60.000% ( 110, 170 ] 26 4.522% 64.522% # ( 170, 250 ] 48 8.348% 72.870% ## ( 250, 380 ] 38 6.609% 79.478% # ( 380, 580 ] 6 1.043% 80.522% ( 580, 870 ] 5 0.870% 81.391% ( 870, 1300 ] 27 4.696% 86.087% # ( 1300, 1900 ] 9 1.565% 87.652% ( 1900, 2900 ] 8 1.391% 89.043% ( 2900, 4400 ] 61 10.609% 99.652% ## ( 4400, 6600 ] 2 0.348% 100.000% ** DB Stats ** Uptime(secs): 25.1 total, 2.5 interval Cumulative writes: 0 writes, 10M keys, 0 commit groups, 0.0 writes per commit group, ingest: 9.61 GB, 391.91 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:8.422 H:M:S, 33.5 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 389.05 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.890 H:M:S, 35.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/11/19-11:03:27 ... thread 0: (1000000,11000000) ops and (394264.2,398486.0) ops/second in (2.536370,27.604482) 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 431.7 24.80 22.21 127 0.195 0 0 0.0 0.0 L3 11/0 944.88 MB 0.9 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 116/0 9.54 GB 1.0 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 Sum 127/0 10.46 GB 0.0 0.0 0.0 0.0 10.5 10.5 20.0 1.0 0.0 431.7 24.80 22.21 127 0.195 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 9.4 9.4 18.6 1.0 0.0 433.7 22.22 19.88 114 0.195 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 431.7 24.80 22.21 127 0.195 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): 27.6 total, 24.6 interval Flush(GB): cumulative 10.458, interval 9.412 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.46 GB write, 387.31 MB/s write, 0.00 GB read, 0.00 MB/s read, 24.8 seconds Interval compaction: 9.41 GB write, 391.72 MB/s write, 0.00 GB read, 0.00 MB/s read, 22.2 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: 85, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 85, interval: 76 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 635 Average: 549.3685 StdDev: 1121.36 Min: 0 Median: 3.3864 Max: 5968 Percentiles: P50: 3.39 P75: 291.01 P99: 4305.43 P99.9: 5901.50 P99.99: 5968.00 ------------------------------------------------------ [ 0, 1 ] 242 38.110% 38.110% ######## ( 1, 2 ] 6 0.945% 39.055% ( 2, 3 ] 44 6.929% 45.984% # ( 3, 4 ] 66 10.394% 56.378% ## ( 4, 6 ] 19 2.992% 59.370% # ( 6, 10 ] 3 0.472% 59.843% ( 10, 15 ] 1 0.157% 60.000% ( 110, 170 ] 33 5.197% 65.197% # ( 170, 250 ] 49 7.717% 72.913% ## ( 250, 380 ] 42 6.614% 79.528% # ( 380, 580 ] 6 0.945% 80.472% ( 580, 870 ] 6 0.945% 81.417% ( 870, 1300 ] 28 4.409% 85.827% # ( 1300, 1900 ] 10 1.575% 87.402% ( 1900, 2900 ] 9 1.417% 88.819% ( 2900, 4400 ] 69 10.866% 99.685% ## ( 4400, 6600 ] 2 0.315% 100.000% ** DB Stats ** Uptime(secs): 27.6 total, 2.5 interval Cumulative writes: 0 writes, 11M keys, 0 commit groups, 0.0 writes per commit group, ingest: 10.57 GB, 391.55 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.298 H:M:S, 33.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 388.03 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.875 H:M:S, 34.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/11/19-11:03:29 ... thread 0: (1000000,12000000) ops and (396551.3,398324.1) ops/second in (2.521742,30.126224) 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 432.1 27.12 24.27 139 0.195 0 0 0.0 0.0 L3 11/0 944.90 MB 0.9 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 116/0 9.54 GB 1.0 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 L5 12/0 1007.88 MB 0.0 0.0 0.0 0.0 0.0 0.0 1.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 139/0 11.44 GB 0.0 0.0 0.0 0.0 11.4 11.4 22.9 1.0 0.0 432.1 27.12 24.27 139 0.195 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 10.4 10.4 21.6 1.0 0.0 433.9 24.54 21.95 126 0.195 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 432.1 27.12 24.27 139 0.195 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): 30.2 total, 27.1 interval Flush(GB): cumulative 11.442, interval 10.396 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, 388.35 MB/s write, 0.00 GB read, 0.00 MB/s read, 27.1 seconds Interval compaction: 10.40 GB write, 392.46 MB/s write, 0.00 GB read, 0.00 MB/s read, 24.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: 93, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 93, interval: 84 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 695 Average: 550.9741 StdDev: 1122.38 Min: 0 Median: 3.3958 Max: 5968 Percentiles: P50: 3.40 P75: 290.27 P99: 4319.93 P99.9: 5968.00 P99.99: 5968.00 ------------------------------------------------------ [ 0, 1 ] 265 38.129% 38.129% ######## ( 1, 2 ] 7 1.007% 39.137% ( 2, 3 ] 47 6.763% 45.899% # ( 3, 4 ] 72 10.360% 56.259% ## ( 4, 6 ] 22 3.165% 59.424% # ( 6, 10 ] 3 0.432% 59.856% ( 10, 15 ] 1 0.144% 60.000% ( 110, 170 ] 35 5.036% 65.036% # ( 170, 250 ] 55 7.914% 72.950% ## ( 250, 380 ] 46 6.619% 79.568% # ( 380, 580 ] 6 0.863% 80.432% ( 580, 870 ] 6 0.863% 81.295% ( 870, 1300 ] 31 4.460% 85.755% # ( 1300, 1900 ] 11 1.583% 87.338% ( 1900, 2900 ] 11 1.583% 88.921% ( 2900, 4400 ] 74 10.647% 99.568% ## ( 4400, 6600 ] 3 0.432% 100.000% ** DB Stats ** Uptime(secs): 30.2 total, 2.5 interval Cumulative writes: 0 writes, 12M keys, 0 commit groups, 0.0 writes per commit group, ingest: 11.53 GB, 391.45 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:10.157 H:M:S, 33.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 390.28 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.859 H:M:S, 34.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/11/19-11:03:32 ... thread 0: (1000000,13000000) ops and (383831.5,397170.5) ops/second in (2.605310,32.731534) 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 431.5 29.49 26.37 151 0.195 0 0 0.0 0.0 L3 11/0 944.92 MB 0.9 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 116/0 9.54 GB 1.0 0.0 0.0 0.0 0.0 0.0 11.5 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 24/0 1.97 GB 0.0 0.0 0.0 0.0 0.0 0.0 2.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 151/0 12.43 GB 0.0 0.0 0.0 0.0 12.4 12.4 25.9 1.0 0.0 431.5 29.49 26.37 151 0.195 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 11.4 11.4 24.5 1.0 0.0 433.1 26.91 24.05 138 0.195 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 431.5 29.49 26.37 151 0.195 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): 32.8 total, 29.7 interval Flush(GB): cumulative 12.426, interval 11.381 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, 388.23 MB/s write, 0.00 GB read, 0.00 MB/s read, 29.5 seconds Interval compaction: 11.38 GB write, 391.97 MB/s write, 0.00 GB read, 0.00 MB/s read, 26.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: 101, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 101, interval: 92 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 755 Average: 558.3179 StdDev: 1140.03 Min: 0 Median: 3.4295 Max: 5968 Percentiles: P50: 3.43 P75: 289.65 P99: 4334.26 P99.9: 5968.00 P99.99: 5968.00 ------------------------------------------------------ [ 0, 1 ] 289 38.278% 38.278% ######## ( 1, 2 ] 7 0.927% 39.205% ( 2, 3 ] 48 6.358% 45.563% # ( 3, 4 ] 78 10.331% 55.894% ## ( 4, 6 ] 27 3.576% 59.470% # ( 6, 10 ] 3 0.397% 59.868% ( 10, 15 ] 1 0.132% 60.000% ( 110, 170 ] 40 5.298% 65.298% # ( 170, 250 ] 58 7.682% 72.980% ## ( 250, 380 ] 50 6.623% 79.603% # ( 380, 580 ] 6 0.795% 80.397% ( 580, 870 ] 6 0.795% 81.192% ( 870, 1300 ] 34 4.503% 85.695% # ( 1300, 1900 ] 12 1.589% 87.285% ( 1900, 2900 ] 11 1.457% 88.742% ( 2900, 4400 ] 81 10.728% 99.470% ## ( 4400, 6600 ] 4 0.530% 100.000% ** DB Stats ** Uptime(secs): 32.8 total, 2.6 interval Cumulative writes: 0 writes, 13M keys, 0 commit groups, 0.0 writes per commit group, ingest: 12.49 GB, 390.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:11.078 H:M:S, 33.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 377.77 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.922 H:M:S, 35.4 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/11/19-11:03:34 ... thread 0: (1000000,14000000) ops and (427427.1,399188.9) ops/second in (2.339580,35.071114) 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.3 13.3 0.0 1.0 0.0 431.2 31.55 28.21 162 0.195 0 0 0.0 0.0 L3 10/0 818.91 MB 0.8 0.0 0.0 0.0 0.0 0.0 13.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 116/0 9.54 GB 1.0 0.0 0.0 0.0 0.0 0.0 12.5 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 36/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 162/0 13.29 GB 0.0 0.0 0.0 0.0 13.3 13.3 28.7 1.0 0.0 431.2 31.55 28.21 162 0.195 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 12.2 12.2 27.4 1.0 0.0 432.7 28.97 25.89 149 0.194 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.3 13.3 0.0 0.0 0.0 431.2 31.55 28.21 162 0.195 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): 35.1 total, 32.1 interval Flush(GB): cumulative 13.288, interval 12.242 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.29 GB write, 387.48 MB/s write, 0.00 GB read, 0.00 MB/s read, 31.6 seconds Interval compaction: 12.24 GB write, 390.87 MB/s write, 0.00 GB read, 0.00 MB/s read, 29.0 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: 108, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 108, interval: 99 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 810 Average: 554.5506 StdDev: 1135.77 Min: 0 Median: 3.4405 Max: 5968 Percentiles: P50: 3.44 P75: 288.02 P99: 4328.49 P99.9: 5968.00 P99.99: 5968.00 ------------------------------------------------------ [ 0, 1 ] 309 38.148% 38.148% ######## ( 1, 2 ] 9 1.111% 39.259% ( 2, 3 ] 50 6.173% 45.432% # ( 3, 4 ] 84 10.370% 55.802% ## ( 4, 6 ] 30 3.704% 59.506% # ( 6, 10 ] 3 0.370% 59.877% ( 10, 15 ] 1 0.123% 60.000% ( 110, 170 ] 42 5.185% 65.185% # ( 170, 250 ] 64 7.901% 73.086% ## ( 250, 380 ] 53 6.543% 79.630% # ( 380, 580 ] 6 0.741% 80.370% ( 580, 870 ] 7 0.864% 81.235% ( 870, 1300 ] 38 4.691% 85.926% # ( 1300, 1900 ] 12 1.481% 87.407% ( 1900, 2900 ] 12 1.481% 88.889% ( 2900, 4400 ] 86 10.617% 99.506% ## ( 4400, 6600 ] 4 0.494% 100.000% ** DB Stats ** Uptime(secs): 35.1 total, 2.3 interval Cumulative writes: 0 writes, 14M keys, 0 commit groups, 0.0 writes per commit group, ingest: 13.46 GB, 392.38 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:11.766 H:M:S, 33.5 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 420.67 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.688 H:M:S, 29.4 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/11/19-11:03:37 ... thread 0: (1000000,15000000) ops and (387036.4,398355.1) ops/second in (2.583736,37.654850) 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 430.7 33.93 30.34 174 0.195 0 0 0.0 0.0 L3 10/0 818.91 MB 0.8 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 116/0 9.54 GB 1.0 0.0 0.0 0.0 0.0 0.0 13.5 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 48/0 3.94 GB 0.0 0.0 0.0 0.0 0.0 0.0 3.9 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 174/0 14.27 GB 0.0 0.0 0.0 0.0 14.3 14.3 31.7 1.0 0.0 430.7 33.93 30.34 174 0.195 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 13.2 13.2 30.3 1.0 0.0 432.0 31.35 28.02 161 0.195 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 430.7 33.93 30.34 174 0.195 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): 37.7 total, 34.7 interval Flush(GB): cumulative 14.272, interval 13.226 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.27 GB write, 387.66 MB/s write, 0.00 GB read, 0.00 MB/s read, 33.9 seconds Interval compaction: 13.23 GB write, 390.82 MB/s write, 0.00 GB read, 0.00 MB/s read, 31.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: 116, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 116, interval: 107 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 870 Average: 556.6690 StdDev: 1136.87 Min: 0 Median: 3.4468 Max: 5968 Percentiles: P50: 3.45 P75: 287.63 P99: 4324.19 P99.9: 5968.00 P99.99: 5968.00 ------------------------------------------------------ [ 0, 1 ] 333 38.276% 38.276% ######## ( 1, 2 ] 9 1.034% 39.310% ( 2, 3 ] 51 5.862% 45.172% # ( 3, 4 ] 94 10.805% 55.977% ## ( 4, 6 ] 31 3.563% 59.540% # ( 6, 10 ] 3 0.345% 59.885% ( 10, 15 ] 1 0.115% 60.000% ( 110, 170 ] 47 5.402% 65.402% # ( 170, 250 ] 67 7.701% 73.103% ## ( 250, 380 ] 57 6.552% 79.655% # ( 380, 580 ] 6 0.690% 80.345% ( 580, 870 ] 8 0.920% 81.264% ( 870, 1300 ] 39 4.483% 85.747% # ( 1300, 1900 ] 13 1.494% 87.241% ( 1900, 2900 ] 14 1.609% 88.851% ( 2900, 4400 ] 93 10.690% 99.540% ## ( 4400, 6600 ] 4 0.460% 100.000% ** DB Stats ** Uptime(secs): 37.7 total, 2.6 interval Cumulative writes: 0 writes, 15M keys, 0 commit groups, 0.0 writes per commit group, ingest: 14.42 GB, 391.59 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.684 H:M:S, 33.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 380.92 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.918 H:M:S, 35.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/11/19-11:03:39 ... thread 0: (1000000,16000000) ops and (393852.4,398070.6) ops/second in (2.539022,40.193872) 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 430.9 36.26 32.42 186 0.195 0 0 0.0 0.0 L3 10/0 818.91 MB 0.8 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 116/0 9.54 GB 1.0 0.0 0.0 0.0 0.0 0.0 14.5 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 60/0 4.92 GB 0.1 0.0 0.0 0.0 0.0 0.0 4.9 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 186/0 15.26 GB 0.0 0.0 0.0 0.0 15.3 15.3 34.6 1.0 0.0 430.9 36.26 32.42 186 0.195 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 14.2 14.2 33.3 1.0 0.0 432.1 33.67 30.10 173 0.195 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 430.9 36.26 32.42 186 0.195 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 15.256, interval 14.210 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.26 GB write, 388.24 MB/s write, 0.00 GB read, 0.00 MB/s read, 36.3 seconds Interval compaction: 14.21 GB write, 391.23 MB/s write, 0.00 GB read, 0.00 MB/s read, 33.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: 124, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 124, interval: 115 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 930 Average: 559.9570 StdDev: 1139.79 Min: 0 Median: 3.4356 Max: 5968 Percentiles: P50: 3.44 P75: 287.30 P99: 4321.29 P99.9: 5968.00 P99.99: 5968.00 ------------------------------------------------------ [ 0, 1 ] 357 38.387% 38.387% ######## ( 1, 2 ] 9 0.968% 39.355% ( 2, 3 ] 55 5.914% 45.269% # ( 3, 4 ] 101 10.860% 56.129% ## ( 4, 6 ] 32 3.441% 59.570% # ( 6, 10 ] 3 0.323% 59.892% ( 10, 15 ] 1 0.108% 60.000% ( 110, 170 ] 50 5.376% 65.376% # ( 170, 250 ] 72 7.742% 73.118% ## ( 250, 380 ] 61 6.559% 79.677% # ( 380, 580 ] 6 0.645% 80.323% ( 580, 870 ] 8 0.860% 81.183% ( 870, 1300 ] 40 4.301% 85.484% # ( 1300, 1900 ] 15 1.613% 87.097% ( 1900, 2900 ] 15 1.613% 88.710% ( 2900, 4400 ] 101 10.860% 99.570% ## ( 4400, 6600 ] 4 0.430% 100.000% ** DB Stats ** Uptime(secs): 40.2 total, 2.5 interval Cumulative writes: 0 writes, 16M keys, 0 commit groups, 0.0 writes per commit group, ingest: 15.38 GB, 391.34 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:13.563 H:M:S, 33.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 387.58 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.879 H:M:S, 34.6 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/11/19-11:03:42 ... thread 0: (1000000,17000000) ops and (390513.3,397618.0) ops/second in (2.560732,42.754604) 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.2 16.2 0.0 1.0 0.0 430.4 38.49 34.42 197 0.195 0 0 0.0 0.0 L2 1/0 63.00 MB 0.6 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 L3 8/0 692.94 MB 0.7 0.0 0.0 0.0 0.0 0.0 16.1 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 116/0 9.54 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 72/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 197/0 16.18 GB 0.0 0.0 0.0 0.0 16.2 16.2 53.6 1.0 0.0 430.4 38.49 34.42 197 0.195 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 15.1 15.1 52.3 1.0 0.0 431.5 35.91 32.10 184 0.195 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.2 16.2 0.0 0.0 0.0 430.4 38.49 34.42 197 0.195 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): 42.8 total, 39.8 interval Flush(GB): cumulative 16.179, interval 15.133 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.18 GB write, 387.09 MB/s write, 0.00 GB read, 0.00 MB/s read, 38.5 seconds Interval compaction: 15.13 GB write, 389.80 MB/s write, 0.00 GB read, 0.00 MB/s read, 35.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: 131, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 131, interval: 122 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 985 Average: 557.5299 StdDev: 1133.43 Min: 0 Median: 3.4198 Max: 5968 Percentiles: P50: 3.42 P75: 287.50 P99: 4317.99 P99.9: 5968.00 P99.99: 5968.00 ------------------------------------------------------ [ 0, 1 ] 379 38.477% 38.477% ######## ( 1, 2 ] 9 0.914% 39.391% ( 2, 3 ] 60 6.091% 45.482% # ( 3, 4 ] 106 10.761% 56.244% ## ( 4, 6 ] 33 3.350% 59.594% # ( 6, 10 ] 3 0.305% 59.898% ( 10, 15 ] 1 0.102% 60.000% ( 110, 170 ] 52 5.279% 65.279% # ( 170, 250 ] 77 7.817% 73.096% ## ( 250, 380 ] 65 6.599% 79.695% # ( 380, 580 ] 6 0.609% 80.305% ( 580, 870 ] 8 0.812% 81.117% ( 870, 1300 ] 44 4.467% 85.584% # ( 1300, 1900 ] 15 1.523% 87.107% ( 1900, 2900 ] 16 1.624% 88.731% ( 2900, 4400 ] 107 10.863% 99.594% ## ( 4400, 6600 ] 4 0.406% 100.000% ** DB Stats ** Uptime(secs): 42.8 total, 2.6 interval Cumulative writes: 0 writes, 17M keys, 0 commit groups, 0.0 writes per commit group, ingest: 16.34 GB, 390.92 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:14.474 H:M:S, 33.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 384.38 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.911 H:M:S, 35.6 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/11/19-11:03:45 ... thread 0: (1000000,18000000) ops and (391089.9,397249.6) ops/second in (2.556957,45.311561) 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 430.4 40.84 36.51 209 0.195 0 0 0.0 0.0 L2 1/0 62.99 MB 0.6 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 L3 8/0 692.95 MB 0.7 0.0 0.0 0.0 0.0 0.0 17.1 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 116/0 9.54 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 84/0 6.89 GB 0.1 0.0 0.0 0.0 0.0 0.0 6.9 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 209/0 17.16 GB 0.0 0.0 0.0 0.0 17.2 17.2 57.6 1.0 0.0 430.4 40.84 36.51 209 0.195 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 16.1 16.1 56.2 1.0 0.0 431.5 38.25 34.19 196 0.195 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 430.4 40.84 36.51 209 0.195 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.4 total, 42.3 interval Flush(GB): cumulative 17.163, interval 16.117 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.16 GB write, 387.49 MB/s write, 0.00 GB read, 0.00 MB/s read, 40.8 seconds Interval compaction: 16.12 GB write, 390.07 MB/s write, 0.00 GB read, 0.00 MB/s read, 38.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: 139, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 139, interval: 130 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1045 Average: 559.9416 StdDev: 1136.96 Min: 0 Median: 3.4398 Max: 5968 Percentiles: P50: 3.44 P75: 289.09 P99: 4327.65 P99.9: 5968.00 P99.99: 5968.00 ------------------------------------------------------ [ 0, 1 ] 400 38.278% 38.278% ######## ( 1, 2 ] 11 1.053% 39.330% ( 2, 3 ] 64 6.124% 45.455% # ( 3, 4 ] 108 10.335% 55.789% ## ( 4, 6 ] 40 3.828% 59.617% # ( 6, 10 ] 3 0.287% 59.904% ( 10, 15 ] 1 0.096% 60.000% ( 110, 170 ] 54 5.167% 65.167% # ( 170, 250 ] 82 7.847% 73.014% ## ( 250, 380 ] 69 6.603% 79.617% # ( 380, 580 ] 7 0.670% 80.287% ( 580, 870 ] 8 0.766% 81.053% ( 870, 1300 ] 47 4.498% 85.550% # ( 1300, 1900 ] 16 1.531% 87.081% ( 1900, 2900 ] 17 1.627% 88.708% ( 2900, 4400 ] 113 10.813% 99.522% ## ( 4400, 6600 ] 5 0.478% 100.000% ** DB Stats ** Uptime(secs): 45.4 total, 2.6 interval Cumulative writes: 0 writes, 18M keys, 0 commit groups, 0.0 writes per commit group, ingest: 17.30 GB, 390.58 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.362 H:M:S, 33.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 384.91 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.887 H:M:S, 34.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/11/19-11:03:47 ... thread 0: (1000000,19000000) ops and (391075.7,396919.8) ops/second in (2.557050,47.868611) 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.1 18.1 0.0 1.0 0.0 430.6 43.16 38.59 221 0.195 0 0 0.0 0.0 L2 1/0 63.00 MB 0.6 0.0 0.0 0.0 0.0 0.0 18.1 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L3 8/0 692.93 MB 0.7 0.0 0.0 0.0 0.0 0.0 18.1 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 116/0 9.54 GB 1.0 0.0 0.0 0.0 0.0 0.0 17.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 96/0 7.87 GB 0.1 0.0 0.0 0.0 0.0 0.0 7.9 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 221/0 18.15 GB 0.0 0.0 0.0 0.0 18.1 18.1 61.5 1.0 0.0 430.6 43.16 38.59 221 0.195 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 17.1 17.1 60.2 1.0 0.0 431.6 40.58 36.27 208 0.195 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.1 18.1 0.0 0.0 0.0 430.6 43.16 38.59 221 0.195 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): 47.9 total, 44.9 interval Flush(GB): cumulative 18.147, interval 17.102 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.15 GB write, 387.85 MB/s write, 0.00 GB read, 0.00 MB/s read, 43.2 seconds Interval compaction: 17.10 GB write, 390.30 MB/s write, 0.00 GB read, 0.00 MB/s read, 40.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: 147, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 147, interval: 138 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1105 Average: 560.1312 StdDev: 1135.58 Min: 0 Median: 3.4459 Max: 5968 Percentiles: P50: 3.45 P75: 288.73 P99: 4325.00 P99.9: 5968.00 P99.99: 5968.00 ------------------------------------------------------ [ 0, 1 ] 423 38.281% 38.281% ######## ( 1, 2 ] 12 1.086% 39.367% ( 2, 3 ] 68 6.154% 45.520% # ( 3, 4 ] 111 10.045% 55.566% ## ( 4, 6 ] 45 4.072% 59.638% # ( 6, 10 ] 3 0.271% 59.910% ( 10, 15 ] 1 0.090% 60.000% ( 110, 170 ] 55 4.977% 64.977% # ( 170, 250 ] 89 8.054% 73.032% ## ( 250, 380 ] 73 6.606% 79.638% # ( 380, 580 ] 7 0.633% 80.271% ( 580, 870 ] 8 0.724% 80.995% ( 870, 1300 ] 50 4.525% 85.520% # ( 1300, 1900 ] 17 1.538% 87.059% ( 1900, 2900 ] 17 1.538% 88.597% ( 2900, 4400 ] 121 10.950% 99.548% ## ( 4400, 6600 ] 5 0.452% 100.000% ** DB Stats ** Uptime(secs): 47.9 total, 2.6 interval Cumulative writes: 0 writes, 19M keys, 0 commit groups, 0.0 writes per commit group, ingest: 18.26 GB, 390.28 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:16.251 H:M:S, 33.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 384.90 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.889 H:M:S, 34.8 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/11/19-11:03:50 ... thread 0: (1000000,20000000) ops and (388466.6,396488.4) ops/second in (2.574224,50.442835) 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 430.5 45.36 40.56 232 0.196 0 0 0.0 0.0 L3 8/0 692.94 MB 0.7 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 116/0 9.54 GB 1.0 0.0 0.0 0.0 0.0 0.0 18.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 108/0 8.86 GB 0.1 0.0 0.0 0.0 0.0 0.0 8.9 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 232/0 19.07 GB 0.0 0.0 0.0 0.0 19.1 19.1 46.3 1.0 0.0 430.5 45.36 40.56 232 0.196 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 18.0 18.0 45.0 1.0 0.0 431.4 42.78 38.24 219 0.195 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 430.5 45.36 40.56 232 0.196 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.5 total, 47.4 interval Flush(GB): cumulative 19.070, interval 18.024 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.07 GB write, 386.79 MB/s write, 0.00 GB read, 0.00 MB/s read, 45.4 seconds Interval compaction: 18.02 GB write, 389.04 MB/s write, 0.00 GB read, 0.00 MB/s read, 42.8 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: 155, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 155, interval: 146 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1160 Average: 557.8888 StdDev: 1131.04 Min: 0 Median: 3.4444 Max: 5968 Percentiles: P50: 3.44 P75: 288.83 P99: 4322.66 P99.9: 5968.00 P99.99: 5968.00 ------------------------------------------------------ [ 0, 1 ] 444 38.276% 38.276% ######## ( 1, 2 ] 13 1.121% 39.397% ( 2, 3 ] 71 6.121% 45.517% # ( 3, 4 ] 117 10.086% 55.603% ## ( 4, 6 ] 47 4.052% 59.655% # ( 6, 10 ] 3 0.259% 59.914% ( 10, 15 ] 1 0.086% 60.000% ( 110, 170 ] 58 5.000% 65.000% # ( 170, 250 ] 93 8.017% 73.017% ## ( 250, 380 ] 77 6.638% 79.655% # ( 380, 580 ] 7 0.603% 80.259% ( 580, 870 ] 10 0.862% 81.121% ( 870, 1300 ] 52 4.483% 85.603% # ( 1300, 1900 ] 17 1.466% 87.069% ( 1900, 2900 ] 17 1.466% 88.534% ( 2900, 4400 ] 128 11.034% 99.569% ## ( 4400, 6600 ] 5 0.431% 100.000% ** DB Stats ** Uptime(secs): 50.5 total, 2.6 interval Cumulative writes: 0 writes, 20M keys, 0 commit groups, 0.0 writes per commit group, ingest: 19.22 GB, 389.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:17.158 H:M:S, 34.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 382.32 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.908 H:M:S, 35.3 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 : 2.522 micros/op 396483 ops/sec 50.443 seconds 20000000 operations; 384.2 MB/s Microseconds per write: Count: 20000000 Average: 2.5222 StdDev: 387.95 Min: 0 Median: 0.7106 Max: 242407 Percentiles: P50: 0.71 P75: 1.48 P99: 5.39 P99.9: 76.72 P99.99: 153.92 ------------------------------------------------------ [ 0, 1 ] 14071929 70.360% 70.360% ############## ( 1, 2 ] 1923044 9.615% 79.975% ## ( 2, 3 ] 3084653 15.423% 95.398% ### ( 3, 4 ] 603397 3.017% 98.415% # ( 4, 6 ] 168254 0.841% 99.256% ( 6, 10 ] 86397 0.432% 99.688% ( 10, 15 ] 25877 0.129% 99.818% ( 15, 22 ] 13556 0.068% 99.886% ( 22, 34 ] 2263 0.011% 99.897% ( 34, 51 ] 268 0.001% 99.898% ( 51, 76 ] 23 0.000% 99.898% ( 76, 110 ] 16089 0.080% 99.979% ( 110, 170 ] 3074 0.015% 99.994% ( 170, 250 ] 749 0.004% 99.998% ( 250, 380 ] 213 0.001% 99.999% ( 380, 580 ] 53 0.000% 99.999% ( 580, 870 ] 4 0.000% 99.999% ( 870, 1300 ] 1 0.000% 99.999% ( 2900, 4400 ] 2 0.000% 99.999% ( 4400, 6600 ] 1 0.000% 99.999% ( 6600, 9900 ] 4 0.000% 99.999% ( 9900, 14000 ] 5 0.000% 99.999% ( 14000, 22000 ] 18 0.000% 99.999% ( 22000, 33000 ] 27 0.000% 100.000% ( 33000, 50000 ] 19 0.000% 100.000% ( 50000, 75000 ] 1 0.000% 100.000% ( 75000, 110000 ] 1 0.000% 100.000% ( 170000, 250000 ] 78 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 : 232 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 17158429 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 : 20476538592 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 : 20312676352 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 : 124094034 rocksdb.non.last.level.read.count COUNT : 1160 rocksdb.block.checksum.compute.count COUNT : 696 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 : 0.675735 P95 : 2.739212 P99 : 4.049727 P100 : 242404.000000 COUNT : 20000000 SUM : 42506897 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 : 493.658537 P95 : 755.611111 P99 : 855.714815 P100 : 935.000000 COUNT : 233 SUM : 122731 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 : 82.719895 P95 : 169.560345 P99 : 2435.000000 P100 : 3005.000000 COUNT : 937 SUM : 131757 rocksdb.table.open.io.micros P50 : 3259.504132 P95 : 5536.666667 P99 : 6387.333333 P100 : 6576.000000 COUNT : 232 SUM : 704471 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 : 572.857143 P95 : 4194.736842 P99 : 4558.400000 P100 : 6014.000000 COUNT : 464 SUM : 671023 rocksdb.write.raw.block.micros P50 : 0.508693 P95 : 0.966516 P99 : 2.386895 P100 : 1955.000000 COUNT : 4976160 SUM : 9990900 rocksdb.numfiles.in.singlecompaction P50 : 1.000000 P95 : 3.577711 P99 : 3.915542 P100 : 4.000000 COUNT : 701 SUM : 1028 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 : 170512.820513 P95 : 242051.282051 P99 : 242220.000000 P100 : 242220.000000 COUNT : 155 SUM : 17158429 rocksdb.sst.read.micros P50 : 3.440678 P95 : 3776.562500 P99 : 4322.187500 P100 : 5968.000000 COUNT : 1164 SUM : 647328 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 : 155686.274510 P95 : 328820.000000 P99 : 328820.000000 P100 : 328820.000000 COUNT : 233 SUM : 45528086 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