[2024-12-09 10:26:13.688766] Starting SPDK v25.01-pre git sha1 b71c8b8dd / DPDK 24.03.0 initialization... [2024-12-09 10:26:13.689099] [ 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_pid573489 ] Set seed to 1733736373682644 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-12-09 10:26:13.906481] app.c: 919:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-12-09 10:26:14.018175] app.c: 612:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-12-09 10:26:14.018262] app.c: 613:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 573489' to capture a snapshot of events at runtime. [2024-12-09 10:26:14.018279] app.c: 618:app_setup_trace: *NOTICE*: 'spdk_trace' without parameters will also work if this is the only [2024-12-09 10:26:14.018294] app.c: 619:app_setup_trace: *NOTICE*: SPDK application currently running. [2024-12-09 10:26:14.018306] app.c: 620:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid573489 for offline analysis/debug. [2024-12-09 10:26:14.019596] reactor.c:1005:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Mon Dec 9 10:26:19 2024 CPU: 36 * Intel(R) Xeon(R) CPU E5-2699 v3 @ 2.30GHz CPUCache: 46080 KB 2024/12/09-10:26:23 ... thread 0: (1000000,1000000) ops and (247711.9,247711.9) ops/second in (4.036947,4.036947) 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.9 0.9 0.0 1.0 0.0 241.3 3.65 3.38 10 0.365 0 0 0.0 0.0 L2 1/0 62.99 MB 0.6 0.0 0.0 0.0 0.0 0.0 0.9 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L3 9/0 818.94 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 881.94 MB 0.0 0.0 0.0 0.0 0.9 0.9 1.7 1.0 0.0 241.3 3.65 3.38 10 0.365 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 0.4 0.4 0.9 1.0 0.0 382.4 1.15 1.03 5 0.231 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.9 0.9 0.0 0.0 0.0 241.3 3.65 3.38 10 0.365 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.1 total, 1.0 interval Flush(GB): cumulative 0.861, interval 0.431 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 0.86 GB write, 217.60 MB/s write, 0.00 GB read, 0.00 MB/s read, 3.7 seconds Interval compaction: 0.43 GB write, 425.28 MB/s write, 0.00 GB read, 0.00 MB/s read, 1.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: 7, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 7, interval: 1 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 50 Average: 359.1200 StdDev: 685.51 Min: 1 Median: 6.0000 Max: 2873 Percentiles: P50: 6.00 P75: 492.50 P99: 2733.33 P99.9: 2873.00 P99.99: 2873.00 ------------------------------------------------------ [ 0, 1 ] 7 14.000% 14.000% ### ( 1, 2 ] 7 14.000% 28.000% ### ( 2, 3 ] 6 12.000% 40.000% ## ( 3, 4 ] 2 4.000% 44.000% # ( 4, 6 ] 3 6.000% 50.000% # ( 6, 10 ] 5 10.000% 60.000% ## ( 170, 250 ] 3 6.000% 66.000% # ( 380, 580 ] 8 16.000% 82.000% ### ( 580, 870 ] 4 8.000% 90.000% ## ( 870, 1300 ] 1 2.000% 92.000% ( 1300, 1900 ] 1 2.000% 94.000% ( 1900, 2900 ] 3 6.000% 100.000% # ** DB Stats ** Uptime(secs): 4.1 total, 1.0 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 242.82 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:2.057 H:M:S, 50.8 percent Interval writes: 0 writes, 360K keys, 0 commit groups, 0.0 writes per commit group, ingest: 354.38 MB, 341.60 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.445 H:M:S, 42.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/12/09-10:26:26 ... thread 0: (1000000,2000000) ops and (340682.5,286852.2) ops/second in (2.935284,6.972231) 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 292.0 6.26 5.74 21 0.298 0 0 0.0 0.0 L3 9/0 755.92 MB 0.8 0.0 0.0 0.0 0.0 0.0 1.8 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 12/0 1.05 GB 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 21/0 1.78 GB 0.0 0.0 0.0 0.0 1.8 1.8 2.8 1.0 0.0 292.0 6.26 5.74 21 0.298 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 1.4 1.4 2.0 1.0 0.0 369.0 3.76 3.38 16 0.235 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 292.0 6.26 5.74 21 0.298 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.0 total, 4.0 interval Flush(GB): cumulative 1.784, interval 1.353 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, 261.42 MB/s write, 0.00 GB read, 0.00 MB/s read, 6.3 seconds Interval compaction: 1.35 GB write, 348.90 MB/s write, 0.00 GB read, 0.00 MB/s read, 3.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: 12, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 12, interval: 6 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 105 Average: 395.1143 StdDev: 766.66 Min: 1 Median: 4.6250 Max: 3147 Percentiles: P50: 4.62 P75: 466.36 P99: 2892.86 P99.9: 3147.00 P99.99: 3147.00 ------------------------------------------------------ [ 0, 1 ] 27 25.714% 25.714% ##### ( 1, 2 ] 9 8.571% 34.286% ## ( 2, 3 ] 6 5.714% 40.000% # ( 3, 4 ] 8 7.619% 47.619% ## ( 4, 6 ] 8 7.619% 55.238% ## ( 6, 10 ] 5 4.762% 60.000% # ( 170, 250 ] 10 9.524% 69.524% ## ( 250, 380 ] 1 0.952% 70.476% ( 380, 580 ] 11 10.476% 80.952% ## ( 580, 870 ] 6 5.714% 86.667% # ( 870, 1300 ] 3 2.857% 89.524% # ( 1300, 1900 ] 3 2.857% 92.381% # ( 1900, 2900 ] 7 6.667% 99.048% # ( 2900, 4400 ] 1 0.952% 100.000% ** DB Stats ** Uptime(secs): 7.0 total, 2.9 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 281.67 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.030 H:M:S, 43.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 335.30 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.973 H:M:S, 33.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/12/09-10:26:29 ... thread 0: (1000000,3000000) ops and (351994.1,305711.0) ops/second in (2.840957,9.813188) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 0/0 0.00 KB 0.0 0.0 0.0 0.0 2.8 2.8 0.0 1.0 0.0 318.1 8.91 8.13 33 0.270 0 0 0.0 0.0 L3 9/0 755.92 MB 0.8 0.0 0.0 0.0 0.0 0.0 2.8 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 24/0 2.03 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.77 GB 0.0 0.0 0.0 0.0 2.8 2.8 4.8 1.0 0.0 318.1 8.91 8.13 33 0.270 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 2.3 2.3 4.0 1.0 0.0 373.5 6.41 5.78 28 0.229 0 0 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- High 0/0 0.00 KB 0.0 0.0 0.0 0.0 2.8 2.8 0.0 0.0 0.0 318.1 8.91 8.13 33 0.270 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.8 total, 6.8 interval Flush(GB): cumulative 2.768, interval 2.338 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 2.77 GB write, 288.40 MB/s write, 0.00 GB read, 0.00 MB/s read, 8.9 seconds Interval compaction: 2.34 GB write, 351.35 MB/s write, 0.00 GB read, 0.00 MB/s read, 6.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: 19, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 19, interval: 13 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 165 Average: 373.3636 StdDev: 739.56 Min: 1 Median: 4.7222 Max: 3147 Percentiles: P50: 4.72 P75: 451.88 P99: 3147.00 P99.9: 3147.00 P99.99: 3147.00 ------------------------------------------------------ [ 0, 1 ] 47 28.485% 28.485% ###### ( 1, 2 ] 13 7.879% 36.364% ## ( 2, 3 ] 6 3.636% 40.000% # ( 3, 4 ] 10 6.061% 46.061% # ( 4, 6 ] 18 10.909% 56.970% ## ( 6, 10 ] 5 3.030% 60.000% # ( 170, 250 ] 18 10.909% 70.909% ## ( 250, 380 ] 1 0.606% 71.515% ( 380, 580 ] 16 9.697% 81.212% ## ( 580, 870 ] 11 6.667% 87.879% # ( 870, 1300 ] 5 3.030% 90.909% # ( 1300, 1900 ] 3 1.818% 92.727% ( 1900, 2900 ] 10 6.061% 98.788% # ( 2900, 4400 ] 2 1.212% 100.000% ** DB Stats ** Uptime(secs): 9.8 total, 2.8 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 300.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:3.914 H:M:S, 39.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 346.43 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.884 H:M:S, 31.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/12/09-10:26:32 ... thread 0: (1000000,4000000) ops and (341077.1,313846.7) ops/second in (2.931888,12.745076) 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.8 3.8 0.0 1.0 0.0 330.1 11.64 10.58 45 0.259 0 0 0.0 0.0 L3 9/0 755.92 MB 0.8 0.0 0.0 0.0 0.0 0.0 3.8 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 36/0 3.01 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.75 GB 0.0 0.0 0.0 0.0 3.8 3.8 6.8 1.0 0.0 330.1 11.64 10.58 45 0.259 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 3.3 3.3 6.0 1.0 0.0 372.2 9.14 8.23 40 0.229 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.8 3.8 0.0 0.0 0.0 330.1 11.64 10.58 45 0.259 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.8 total, 9.7 interval Flush(GB): cumulative 3.753, interval 3.322 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 3.75 GB write, 301.12 MB/s write, 0.00 GB read, 0.00 MB/s read, 11.6 seconds Interval compaction: 3.32 GB write, 349.07 MB/s write, 0.00 GB read, 0.00 MB/s read, 9.1 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 27, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 27, interval: 21 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 225 Average: 354.7289 StdDev: 713.61 Min: 1 Median: 4.8214 Max: 3147 Percentiles: P50: 4.82 P75: 423.18 P99: 2880.77 P99.9: 3147.00 P99.99: 3147.00 ------------------------------------------------------ [ 0, 1 ] 67 29.778% 29.778% ###### ( 1, 2 ] 16 7.111% 36.889% # ( 2, 3 ] 6 2.667% 39.556% # ( 3, 4 ] 12 5.333% 44.889% # ( 4, 6 ] 28 12.444% 57.333% ## ( 6, 10 ] 6 2.667% 60.000% # ( 110, 170 ] 1 0.444% 60.444% ( 170, 250 ] 25 11.111% 71.556% ## ( 250, 380 ] 3 1.333% 72.889% ( 380, 580 ] 22 9.778% 82.667% ## ( 580, 870 ] 13 5.778% 88.444% # ( 870, 1300 ] 7 3.111% 91.556% # ( 1300, 1900 ] 4 1.778% 93.333% ( 1900, 2900 ] 13 5.778% 99.111% # ( 2900, 4400 ] 2 0.889% 100.000% ** DB Stats ** Uptime(secs): 12.8 total, 2.9 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 308.49 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.877 H:M:S, 38.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 335.68 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.963 H:M:S, 32.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/12/09-10:26:35 ... thread 0: (1000000,5000000) ops and (350178.2,320497.1) ops/second in (2.855689,15.600765) 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 339.5 14.29 12.97 57 0.251 0 0 0.0 0.0 L3 9/0 755.92 MB 0.8 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 L4 48/0 4.00 GB 0.4 0.0 0.0 0.0 0.0 0.0 4.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 57/0 4.74 GB 0.0 0.0 0.0 0.0 4.7 4.7 8.7 1.0 0.0 339.5 14.29 12.97 57 0.251 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 4.3 4.3 7.9 1.0 0.0 374.2 11.78 10.61 52 0.227 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 339.5 14.29 12.97 57 0.251 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): 15.6 total, 12.6 interval Flush(GB): cumulative 4.737, interval 4.306 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 4.74 GB write, 310.60 MB/s write, 0.00 GB read, 0.00 MB/s read, 14.3 seconds Interval compaction: 4.31 GB write, 349.94 MB/s write, 0.00 GB read, 0.00 MB/s read, 11.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: 34, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 34, interval: 28 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 285 Average: 364.5439 StdDev: 735.21 Min: 1 Median: 4.7838 Max: 3147 Percentiles: P50: 4.78 P75: 403.91 P99: 3147.00 P99.9: 3147.00 P99.99: 3147.00 ------------------------------------------------------ [ 0, 1 ] 87 30.526% 30.526% ###### ( 1, 2 ] 20 7.018% 37.544% # ( 2, 3 ] 7 2.456% 40.000% ( 3, 4 ] 14 4.912% 44.912% # ( 4, 6 ] 37 12.982% 57.895% ### ( 6, 10 ] 6 2.105% 60.000% ( 110, 170 ] 1 0.351% 60.351% ( 170, 250 ] 33 11.579% 71.930% ## ( 250, 380 ] 6 2.105% 74.035% ( 380, 580 ] 23 8.070% 82.105% ## ( 580, 870 ] 16 5.614% 87.719% # ( 870, 1300 ] 11 3.860% 91.579% # ( 1300, 1900 ] 4 1.404% 92.982% ( 1900, 2900 ] 16 5.614% 98.596% # ( 2900, 4400 ] 4 1.404% 100.000% ** DB Stats ** Uptime(secs): 15.6 total, 2.9 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 315.10 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:5.773 H:M:S, 37.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 344.63 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.896 H:M:S, 31.4 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/12/09-10:26:38 ... thread 0: (1000000,6000000) ops and (288196.8,314620.1) ops/second in (3.469851,19.070616) 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 332.1 17.45 15.87 68 0.257 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 7/0 629.92 MB 0.6 0.0 0.0 0.0 0.0 0.0 5.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 60/0 4.98 GB 0.5 0.0 0.0 0.0 0.0 0.0 5.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 68/0 5.66 GB 0.0 0.0 0.0 0.0 5.7 5.7 16.2 1.0 0.0 332.1 17.45 15.87 68 0.257 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 5.2 5.2 15.4 1.0 0.0 358.2 14.95 13.52 63 0.237 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 332.1 17.45 15.87 68 0.257 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): 19.1 total, 16.1 interval Flush(GB): cumulative 5.660, interval 5.229 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 5.66 GB write, 303.64 MB/s write, 0.00 GB read, 0.00 MB/s read, 17.5 seconds Interval compaction: 5.23 GB write, 333.18 MB/s write, 0.00 GB read, 0.00 MB/s read, 14.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: 42, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 42, interval: 36 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 340 Average: 358.1912 StdDev: 719.61 Min: 1 Median: 4.9091 Max: 3147 Percentiles: P50: 4.91 P75: 415.71 P99: 3147.00 P99.9: 3147.00 P99.99: 3147.00 ------------------------------------------------------ [ 0, 1 ] 97 28.529% 28.529% ###### ( 1, 2 ] 29 8.529% 37.059% ## ( 2, 3 ] 10 2.941% 40.000% # ( 3, 4 ] 14 4.118% 44.118% # ( 4, 6 ] 44 12.941% 57.059% ### ( 6, 10 ] 10 2.941% 60.000% # ( 110, 170 ] 1 0.294% 60.294% ( 170, 250 ] 38 11.176% 71.471% ## ( 250, 380 ] 7 2.059% 73.529% ( 380, 580 ] 28 8.235% 81.765% ## ( 580, 870 ] 23 6.765% 88.529% # ( 870, 1300 ] 12 3.529% 92.059% # ( 1300, 1900 ] 5 1.471% 93.529% ( 1900, 2900 ] 16 4.706% 98.235% # ( 2900, 4400 ] 6 1.765% 100.000% ** DB Stats ** Uptime(secs): 19.1 total, 3.5 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 309.39 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.278 H:M:S, 38.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 283.65 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:1.505 H:M:S, 43.4 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/12/09-10:26:41 ... thread 0: (1000000,7000000) ops and (336080.0,317516.5) ops/second in (2.975482,22.046098) 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 335.9 20.06 18.25 79 0.254 0 0 0.0 0.0 L3 11/0 944.90 MB 0.9 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 68/0 5.66 GB 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 Sum 79/0 6.58 GB 0.0 0.0 0.0 0.0 6.6 6.6 12.2 1.0 0.0 335.9 20.06 18.25 79 0.254 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 6.2 6.2 11.4 1.0 0.0 358.7 17.56 15.89 74 0.237 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 335.9 20.06 18.25 79 0.254 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.1 total, 19.0 interval Flush(GB): cumulative 6.582, interval 6.152 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, 305.52 MB/s write, 0.00 GB read, 0.00 MB/s read, 20.1 seconds Interval compaction: 6.15 GB write, 330.74 MB/s write, 0.00 GB read, 0.00 MB/s read, 17.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: 50, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 50, interval: 44 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 395 Average: 340.1823 StdDev: 681.68 Min: 1 Median: 4.9038 Max: 3147 Percentiles: P50: 4.90 P75: 407.42 P99: 3147.00 P99.9: 3147.00 P99.99: 3147.00 ------------------------------------------------------ [ 0, 1 ] 114 28.861% 28.861% ###### ( 1, 2 ] 34 8.608% 37.468% ## ( 2, 3 ] 10 2.532% 40.000% # ( 3, 4 ] 16 4.051% 44.051% # ( 4, 6 ] 52 13.165% 57.215% ### ( 6, 10 ] 11 2.785% 60.000% # ( 110, 170 ] 1 0.253% 60.253% ( 170, 250 ] 45 11.392% 71.646% ## ( 250, 380 ] 9 2.278% 73.924% ( 380, 580 ] 31 7.848% 81.772% ## ( 580, 870 ] 30 7.595% 89.367% ## ( 870, 1300 ] 14 3.544% 92.911% # ( 1300, 1900 ] 6 1.519% 94.430% ( 1900, 2900 ] 16 4.051% 98.481% # ( 2900, 4400 ] 6 1.519% 100.000% ** DB Stats ** Uptime(secs): 22.1 total, 3.0 interval Cumulative writes: 0 writes, 7000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 6.73 GB, 312.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:8.281 H:M:S, 37.5 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 330.76 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:1.003 H:M:S, 33.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/12/09-10:26:46 ... thread 0: (1000000,8000000) ops and (191254.8,293311.8) ops/second in (5.228628,27.274726) 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 309.1 25.06 22.95 90 0.278 0 0 0.0 0.0 L1 1/1 62.99 MB 0.0 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 L3 9/0 881.91 MB 0.9 0.0 0.0 0.0 0.0 0.0 7.5 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 80/0 6.64 GB 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 Sum 90/1 7.57 GB 0.0 0.0 0.0 0.0 7.6 7.6 21.7 1.0 0.0 309.1 25.06 22.95 90 0.278 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 7.1 7.1 20.9 1.0 0.0 323.9 22.56 20.60 85 0.265 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 309.1 25.06 22.95 90 0.278 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.3 total, 24.3 interval Flush(GB): cumulative 7.567, interval 7.136 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, 283.91 MB/s write, 0.00 GB read, 0.00 MB/s read, 25.1 seconds Interval compaction: 7.14 GB write, 301.02 MB/s write, 0.00 GB read, 0.00 MB/s read, 22.6 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 61, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 61, interval: 55 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 450 Average: 355.5844 StdDev: 704.55 Min: 1 Median: 5.1154 Max: 3830 Percentiles: P50: 5.12 P75: 435.88 P99: 3556.25 P99.9: 3830.00 P99.99: 3830.00 ------------------------------------------------------ [ 0, 1 ] 114 25.333% 25.333% ##### ( 1, 2 ] 47 10.444% 35.778% ## ( 2, 3 ] 19 4.222% 40.000% # ( 3, 4 ] 16 3.556% 43.556% # ( 4, 6 ] 52 11.556% 55.111% ## ( 6, 10 ] 22 4.889% 60.000% # ( 110, 170 ] 1 0.222% 60.222% ( 170, 250 ] 45 10.000% 70.222% ## ( 250, 380 ] 12 2.667% 72.889% # ( 380, 580 ] 34 7.556% 80.444% ## ( 580, 870 ] 38 8.444% 88.889% ## ( 870, 1300 ] 17 3.778% 92.667% # ( 1300, 1900 ] 7 1.556% 94.222% ( 1900, 2900 ] 18 4.000% 98.222% # ( 2900, 4400 ] 8 1.778% 100.000% ** DB Stats ** Uptime(secs): 27.3 total, 5.2 interval Cumulative writes: 0 writes, 8000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 7.69 GB, 288.50 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.515 H:M:S, 42.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 188.23 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:3.234 H:M:S, 61.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/12/09-10:26:50 ... thread 0: (1000000,9000000) ops and (257914.8,288906.2) ops/second in (3.877249,31.151975) 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 306.4 28.58 26.19 101 0.283 0 0 0.0 0.0 L3 9/0 818.92 MB 0.8 0.0 0.0 0.0 0.0 0.0 8.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 92/0 7.75 GB 0.8 0.0 0.0 0.0 0.0 0.0 7.8 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 101/0 8.55 GB 0.0 0.0 0.0 0.0 8.6 8.6 16.3 1.0 0.0 306.4 28.58 26.19 101 0.283 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 8.1 8.1 15.5 1.0 0.0 318.8 26.08 23.83 96 0.272 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 306.4 28.58 26.19 101 0.283 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): 31.2 total, 28.2 interval Flush(GB): cumulative 8.551, interval 8.120 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, 280.93 MB/s write, 0.00 GB read, 0.00 MB/s read, 28.6 seconds Interval compaction: 8.12 GB write, 295.37 MB/s write, 0.00 GB read, 0.00 MB/s read, 26.1 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 70, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 70, interval: 64 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 505 Average: 352.8455 StdDev: 693.82 Min: 1 Median: 5.1695 Max: 3830 Percentiles: P50: 5.17 P75: 448.75 P99: 3558.33 P99.9: 3830.00 P99.99: 3830.00 ------------------------------------------------------ [ 0, 1 ] 128 25.347% 25.347% ##### ( 1, 2 ] 53 10.495% 35.842% ## ( 2, 3 ] 20 3.960% 39.802% # ( 3, 4 ] 17 3.366% 43.168% # ( 4, 6 ] 59 11.683% 54.851% ## ( 6, 10 ] 25 4.950% 59.802% # ( 22, 34 ] 1 0.198% 60.000% ( 110, 170 ] 1 0.198% 60.198% ( 170, 250 ] 49 9.703% 69.901% ## ( 250, 380 ] 12 2.376% 72.277% ( 380, 580 ] 40 7.921% 80.198% ## ( 580, 870 ] 44 8.713% 88.911% ## ( 870, 1300 ] 21 4.158% 93.069% # ( 1300, 1900 ] 7 1.386% 94.455% ( 1900, 2900 ] 19 3.762% 98.218% # ( 2900, 4400 ] 9 1.782% 100.000% ** DB Stats ** Uptime(secs): 31.2 total, 3.9 interval Cumulative writes: 0 writes, 9000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 8.65 GB, 284.19 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.408 H:M:S, 43.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 253.85 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:1.892 H:M:S, 48.8 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/12/09-10:26:54 ... thread 0: (1000000,10000000) ops and (263890.3,286193.2) ops/second in (3.789454,34.941429) 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 302.2 32.10 29.44 112 0.287 0 0 0.0 0.0 L3 8/0 692.93 MB 0.7 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.80 GB 0.9 0.0 0.0 0.0 0.0 0.0 8.8 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 112/0 9.47 GB 0.0 0.0 0.0 0.0 9.5 9.5 18.3 1.0 0.0 302.2 32.10 29.44 112 0.287 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 9.0 9.0 17.5 1.0 0.0 312.9 29.60 27.08 107 0.277 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 302.2 32.10 29.44 112 0.287 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.0 total, 31.9 interval Flush(GB): cumulative 9.474, interval 9.043 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, 277.51 MB/s write, 0.00 GB read, 0.00 MB/s read, 32.1 seconds Interval compaction: 9.04 GB write, 289.91 MB/s write, 0.00 GB read, 0.00 MB/s read, 29.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: 79, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 79, interval: 73 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 560 Average: 357.9179 StdDev: 706.23 Min: 1 Median: 5.2258 Max: 3830 Percentiles: P50: 5.23 P75: 452.73 P99: 3636.36 P99.9: 3830.00 P99.99: 3830.00 ------------------------------------------------------ [ 0, 1 ] 138 24.643% 24.643% ##### ( 1, 2 ] 60 10.714% 35.357% ## ( 2, 3 ] 25 4.464% 39.821% # ( 3, 4 ] 19 3.393% 43.214% # ( 4, 6 ] 62 11.071% 54.286% ## ( 6, 10 ] 30 5.357% 59.643% # ( 15, 22 ] 1 0.179% 59.821% ( 22, 34 ] 1 0.179% 60.000% ( 110, 170 ] 1 0.179% 60.179% ( 170, 250 ] 54 9.643% 69.821% ## ( 250, 380 ] 13 2.321% 72.143% ( 380, 580 ] 44 7.857% 80.000% ## ( 580, 870 ] 50 8.929% 88.929% ## ( 870, 1300 ] 23 4.107% 93.036% # ( 1300, 1900 ] 7 1.250% 94.286% ( 1900, 2900 ] 21 3.750% 98.036% # ( 2900, 4400 ] 11 1.964% 100.000% ** DB Stats ** Uptime(secs): 35.0 total, 3.8 interval Cumulative writes: 0 writes, 10M keys, 0 commit groups, 0.0 writes per commit group, ingest: 9.61 GB, 281.54 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.227 H:M:S, 43.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 259.72 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:1.820 H:M:S, 48.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/12/09-10:26:58 ... thread 0: (1000000,11000000) ops and (258033.9,283381.8) ops/second in (3.875460,38.816889) 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 300.7 35.61 32.69 123 0.290 0 0 0.0 0.0 L3 7/0 629.94 MB 0.6 0.0 0.0 0.0 0.0 0.0 10.5 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 112/0 9.47 GB 1.0 0.0 0.0 0.0 0.0 0.0 9.8 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 4/0 377.98 MB 0.0 0.0 0.0 0.0 0.0 0.0 0.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 123/0 10.46 GB 0.0 0.0 0.0 0.0 10.5 10.5 20.7 1.0 0.0 300.7 35.61 32.69 123 0.290 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 10.0 10.0 19.9 1.0 0.0 310.1 33.11 30.34 118 0.281 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 300.7 35.61 32.69 123 0.290 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 38.8 total, 35.8 interval Flush(GB): cumulative 10.458, interval 10.027 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, 275.77 MB/s write, 0.00 GB read, 0.00 MB/s read, 35.6 seconds Interval compaction: 10.03 GB write, 286.68 MB/s write, 0.00 GB read, 0.00 MB/s read, 33.1 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 87, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 87, interval: 81 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 615 Average: 358.9577 StdDev: 705.69 Min: 1 Median: 5.2687 Max: 3830 Percentiles: P50: 5.27 P75: 461.91 P99: 3690.38 P99.9: 3830.00 P99.99: 3830.00 ------------------------------------------------------ [ 0, 1 ] 146 23.740% 23.740% ##### ( 1, 2 ] 71 11.545% 35.285% ## ( 2, 3 ] 28 4.553% 39.837% # ( 3, 4 ] 20 3.252% 43.089% # ( 4, 6 ] 67 10.894% 53.984% ## ( 6, 10 ] 35 5.691% 59.675% # ( 15, 22 ] 1 0.163% 59.837% ( 22, 34 ] 1 0.163% 60.000% ( 110, 170 ] 1 0.163% 60.163% ( 170, 250 ] 58 9.431% 69.593% ## ( 250, 380 ] 14 2.276% 71.870% ( 380, 580 ] 47 7.642% 79.512% ## ( 580, 870 ] 58 9.431% 88.943% ## ( 870, 1300 ] 26 4.228% 93.171% # ( 1300, 1900 ] 8 1.301% 94.472% ( 1900, 2900 ] 21 3.415% 97.886% # ( 2900, 4400 ] 13 2.114% 100.000% ** DB Stats ** Uptime(secs): 38.8 total, 3.9 interval Cumulative writes: 0 writes, 11M keys, 0 commit groups, 0.0 writes per commit group, ingest: 10.57 GB, 278.79 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.139 H:M:S, 44.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 253.95 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:1.911 H:M:S, 49.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/12/09-10:27:03 ... thread 0: (1000000,12000000) ops and (201735.1,274136.1) ops/second in (4.956996,43.773885) 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 290.6 40.10 36.89 133 0.302 0 0 0.0 0.0 L3 9/0 881.89 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 112/0 9.47 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 1.05 GB 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 133/0 11.38 GB 0.0 0.0 0.0 0.0 11.4 11.4 22.9 1.0 0.0 290.6 40.10 36.89 133 0.302 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 11.0 11.0 22.1 1.0 0.0 298.2 37.60 34.54 128 0.294 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 290.6 40.10 36.89 133 0.302 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): 43.8 total, 40.8 interval Flush(GB): cumulative 11.381, interval 10.950 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.38 GB write, 266.13 MB/s write, 0.00 GB read, 0.00 MB/s read, 40.1 seconds Interval compaction: 10.95 GB write, 275.00 MB/s write, 0.00 GB read, 0.00 MB/s read, 37.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: 97, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 97, interval: 91 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 665 Average: 357.7985 StdDev: 697.56 Min: 1 Median: 5.3971 Max: 3830 Percentiles: P50: 5.40 P75: 469.62 P99: 3632.69 P99.9: 3830.00 P99.99: 3830.00 ------------------------------------------------------ [ 0, 1 ] 148 22.256% 22.256% #### ( 1, 2 ] 82 12.331% 34.586% ## ( 2, 3 ] 35 5.263% 39.850% # ( 3, 4 ] 20 3.008% 42.857% # ( 4, 6 ] 68 10.226% 53.083% ## ( 6, 10 ] 44 6.617% 59.699% # ( 15, 22 ] 1 0.150% 59.850% ( 22, 34 ] 1 0.150% 60.000% ( 110, 170 ] 1 0.150% 60.150% ( 170, 250 ] 58 8.722% 68.872% ## ( 250, 380 ] 17 2.556% 71.429% # ( 380, 580 ] 53 7.970% 79.398% ## ( 580, 870 ] 64 9.624% 89.023% ## ( 870, 1300 ] 29 4.361% 93.383% # ( 1300, 1900 ] 8 1.203% 94.586% ( 1900, 2900 ] 23 3.459% 98.045% # ( 2900, 4400 ] 13 1.955% 100.000% ** DB Stats ** Uptime(secs): 43.8 total, 5.0 interval Cumulative writes: 0 writes, 12M keys, 0 commit groups, 0.0 writes per commit group, ingest: 11.53 GB, 269.70 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:20.100 H:M:S, 45.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 198.55 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:2.961 H:M:S, 59.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/12/09-10:27:08 ... thread 0: (1000000,13000000) ops and (211468.4,268026.2) ops/second in (4.728840,48.502725) 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 284.0 44.58 41.07 144 0.310 0 0 0.0 0.0 L2 1/0 63.00 MB 0.6 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 L3 7/0 692.95 MB 0.7 0.0 0.0 0.0 0.0 0.0 12.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 112/0 9.60 GB 1.0 0.0 0.0 0.0 0.0 0.0 11.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 24/0 2.03 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 144/0 12.36 GB 0.0 0.0 0.0 0.0 12.4 12.4 38.3 1.0 0.0 284.0 44.58 41.07 144 0.310 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 11.9 11.9 37.5 1.0 0.0 290.4 42.08 38.71 139 0.303 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 284.0 44.58 41.07 144 0.310 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): 48.5 total, 45.5 interval Flush(GB): cumulative 12.365, interval 11.934 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.36 GB write, 260.97 MB/s write, 0.00 GB read, 0.00 MB/s read, 44.6 seconds Interval compaction: 11.93 GB write, 268.57 MB/s write, 0.00 GB read, 0.00 MB/s read, 42.1 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 107, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 107, interval: 101 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 720 Average: 355.5736 StdDev: 687.49 Min: 1 Median: 5.5143 Max: 3830 Percentiles: P50: 5.51 P75: 474.92 P99: 3569.23 P99.9: 3830.00 P99.99: 3830.00 ------------------------------------------------------ [ 0, 1 ] 152 21.111% 21.111% #### ( 1, 2 ] 92 12.778% 33.889% ### ( 2, 3 ] 43 5.972% 39.861% # ( 3, 4 ] 20 2.778% 42.639% # ( 4, 6 ] 70 9.722% 52.361% ## ( 6, 10 ] 53 7.361% 59.722% # ( 15, 22 ] 1 0.139% 59.861% ( 22, 34 ] 1 0.139% 60.000% ( 110, 170 ] 1 0.139% 60.139% ( 170, 250 ] 59 8.194% 68.333% ## ( 250, 380 ] 20 2.778% 71.111% # ( 380, 580 ] 59 8.194% 79.306% ## ( 580, 870 ] 70 9.722% 89.028% ## ( 870, 1300 ] 32 4.444% 93.472% # ( 1300, 1900 ] 9 1.250% 94.722% ( 1900, 2900 ] 25 3.472% 98.194% # ( 2900, 4400 ] 13 1.806% 100.000% ** DB Stats ** Uptime(secs): 48.5 total, 4.7 interval Cumulative writes: 0 writes, 13M keys, 0 commit groups, 0.0 writes per commit group, ingest: 12.49 GB, 263.70 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:22.806 H:M:S, 47.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 208.13 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:2.706 H:M:S, 57.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/12/09-10:27:11 ... thread 0: (1000000,14000000) ops and (267015.0,267953.7) ops/second in (3.745108,52.247833) 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 283.4 48.01 44.23 155 0.310 0 0 0.0 0.0 L2 1/0 62.99 MB 0.6 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 L3 10/0 881.90 MB 0.9 0.0 0.0 0.0 0.0 0.0 13.2 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 112/0 9.72 GB 1.0 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 L5 32/0 2.65 GB 0.0 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 Sum 155/0 13.29 GB 0.0 0.0 0.0 0.0 13.3 13.3 41.5 1.0 0.0 283.4 48.01 44.23 155 0.310 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 12.9 12.9 40.7 1.0 0.0 289.3 45.51 41.87 150 0.303 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 283.4 48.01 44.23 155 0.310 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): 52.3 total, 49.2 interval Flush(GB): cumulative 13.288, interval 12.857 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, 260.34 MB/s write, 0.00 GB read, 0.00 MB/s read, 48.0 seconds Interval compaction: 12.86 GB write, 267.33 MB/s write, 0.00 GB read, 0.00 MB/s read, 45.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: 116, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 116, interval: 110 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 775 Average: 363.5355 StdDev: 701.45 Min: 1 Median: 5.5270 Max: 3830 Percentiles: P50: 5.53 P75: 480.81 P99: 3505.77 P99.9: 3830.00 P99.99: 3830.00 ------------------------------------------------------ [ 0, 1 ] 161 20.774% 20.774% #### ( 1, 2 ] 100 12.903% 33.677% ### ( 2, 3 ] 48 6.194% 39.871% # ( 3, 4 ] 22 2.839% 42.710% # ( 4, 6 ] 74 9.548% 52.258% ## ( 6, 10 ] 58 7.484% 59.742% # ( 15, 22 ] 1 0.129% 59.871% ( 22, 34 ] 1 0.129% 60.000% ( 110, 170 ] 1 0.129% 60.129% ( 170, 250 ] 64 8.258% 68.387% ## ( 250, 380 ] 20 2.581% 70.968% # ( 380, 580 ] 62 8.000% 78.968% ## ( 580, 870 ] 74 9.548% 88.516% ## ( 870, 1300 ] 36 4.645% 93.161% # ( 1300, 1900 ] 9 1.161% 94.323% ( 1900, 2900 ] 31 4.000% 98.323% # ( 2900, 4400 ] 13 1.677% 100.000% ** DB Stats ** Uptime(secs): 52.3 total, 3.7 interval Cumulative writes: 0 writes, 14M keys, 0 commit groups, 0.0 writes per commit group, ingest: 13.46 GB, 263.64 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:24.540 H:M:S, 47.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 262.79 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:1.733 H:M:S, 46.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/12/09-10:27:16 ... thread 0: (1000000,15000000) ops and (219545.8,264072.0) ops/second in (4.554858,56.802691) 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 280.1 52.18 48.10 166 0.314 0 0 0.0 0.0 L3 10/0 881.92 MB 0.9 0.0 0.0 0.0 0.0 0.0 14.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 108/0 9.41 GB 1.0 0.0 0.0 0.0 0.0 0.0 13.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 48/0 4.00 GB 0.0 0.0 0.0 0.0 0.0 0.0 4.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 166/0 14.27 GB 0.0 0.0 0.0 0.0 14.3 14.3 31.7 1.0 0.0 280.1 52.18 48.10 166 0.314 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 13.8 13.8 30.9 1.0 0.0 285.3 49.67 45.75 161 0.309 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 280.1 52.18 48.10 166 0.314 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): 56.8 total, 53.8 interval Flush(GB): cumulative 14.272, interval 13.841 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, 257.21 MB/s write, 0.00 GB read, 0.00 MB/s read, 52.2 seconds Interval compaction: 13.84 GB write, 263.44 MB/s write, 0.00 GB read, 0.00 MB/s read, 49.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: 125, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 125, interval: 119 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 830 Average: 366.4554 StdDev: 706.59 Min: 1 Median: 5.5584 Max: 3830 Percentiles: P50: 5.56 P75: 481.47 P99: 3570.00 P99.9: 3830.00 P99.99: 3830.00 ------------------------------------------------------ [ 0, 1 ] 169 20.361% 20.361% #### ( 1, 2 ] 107 12.892% 33.253% ### ( 2, 3 ] 55 6.627% 39.880% # ( 3, 4 ] 24 2.892% 42.771% # ( 4, 6 ] 77 9.277% 52.048% ## ( 6, 10 ] 63 7.590% 59.639% ## ( 15, 22 ] 2 0.241% 59.880% ( 22, 34 ] 1 0.120% 60.000% ( 110, 170 ] 1 0.120% 60.120% ( 170, 250 ] 67 8.072% 68.193% ## ( 250, 380 ] 22 2.651% 70.843% # ( 380, 580 ] 68 8.193% 79.036% ## ( 580, 870 ] 78 9.398% 88.434% ## ( 870, 1300 ] 38 4.578% 93.012% # ( 1300, 1900 ] 10 1.205% 94.217% ( 1900, 2900 ] 33 3.976% 98.193% # ( 2900, 4400 ] 15 1.807% 100.000% ** DB Stats ** Uptime(secs): 56.8 total, 4.6 interval Cumulative writes: 0 writes, 15M keys, 0 commit groups, 0.0 writes per commit group, ingest: 14.42 GB, 259.82 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:27.127 H:M:S, 47.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 216.08 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:2.588 H:M:S, 56.8 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/12/09-10:27:20 ... thread 0: (1000000,16000000) ops and (252417.2,263312.1) ops/second in (3.961695,60.764386) 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 280.2 55.97 51.60 178 0.314 0 0 0.0 0.0 L3 10/0 881.91 MB 0.9 0.0 0.0 0.0 0.0 0.0 15.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 108/0 9.47 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.98 GB 0.1 0.0 0.0 0.0 0.0 0.0 5.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 178/0 15.32 GB 0.0 0.0 0.0 0.0 15.3 15.3 34.8 1.0 0.0 280.2 55.97 51.60 178 0.314 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 14.9 14.9 34.0 1.0 0.0 285.1 53.47 49.25 173 0.309 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 280.2 55.97 51.60 178 0.314 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 60.8 total, 57.8 interval Flush(GB): cumulative 15.318, interval 14.887 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 15.32 GB write, 258.07 MB/s write, 0.00 GB read, 0.00 MB/s read, 56.0 seconds Interval compaction: 14.89 GB write, 263.91 MB/s write, 0.00 GB read, 0.00 MB/s read, 53.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: 135, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 135, interval: 129 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 890 Average: 366.5596 StdDev: 706.94 Min: 1 Median: 5.5714 Max: 3830 Percentiles: P50: 5.57 P75: 480.00 P99: 3614.71 P99.9: 3830.00 P99.99: 3830.00 ------------------------------------------------------ [ 0, 1 ] 182 20.449% 20.449% #### ( 1, 2 ] 114 12.809% 33.258% ### ( 2, 3 ] 59 6.629% 39.888% # ( 3, 4 ] 24 2.697% 42.584% # ( 4, 6 ] 84 9.438% 52.022% ## ( 6, 10 ] 68 7.640% 59.663% ## ( 15, 22 ] 2 0.225% 59.888% ( 22, 34 ] 1 0.112% 60.000% ( 110, 170 ] 1 0.112% 60.112% ( 170, 250 ] 71 7.978% 68.090% ## ( 250, 380 ] 25 2.809% 70.899% # ( 380, 580 ] 73 8.202% 79.101% ## ( 580, 870 ] 83 9.326% 88.427% ## ( 870, 1300 ] 41 4.607% 93.034% # ( 1300, 1900 ] 11 1.236% 94.270% ( 1900, 2900 ] 34 3.820% 98.090% # ( 2900, 4400 ] 17 1.910% 100.000% ** DB Stats ** Uptime(secs): 60.8 total, 4.0 interval Cumulative writes: 0 writes, 16M keys, 0 commit groups, 0.0 writes per commit group, ingest: 15.38 GB, 259.08 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:29.117 H:M:S, 47.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 248.43 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:1.990 H:M:S, 50.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/12/09-10:27:23 ... thread 0: (1000000,17000000) ops and (357337.4,267451.8) ops/second in (2.798476,63.562862) 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 283.4 58.45 53.85 189 0.309 0 0 0.0 0.0 L3 9/0 755.92 MB 0.8 0.0 0.0 0.0 0.0 0.0 16.2 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 108/0 9.47 GB 1.0 0.0 0.0 0.0 0.0 0.0 15.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 72/0 5.97 GB 0.1 0.0 0.0 0.0 0.0 0.0 6.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 189/0 16.18 GB 0.0 0.0 0.0 0.0 16.2 16.2 37.6 1.0 0.0 283.4 58.45 53.85 189 0.309 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 15.7 15.7 36.8 1.0 0.0 288.2 55.95 51.49 184 0.304 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 283.4 58.45 53.85 189 0.309 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): 63.6 total, 60.6 interval Flush(GB): cumulative 16.179, interval 15.748 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, 260.58 MB/s write, 0.00 GB read, 0.00 MB/s read, 58.5 seconds Interval compaction: 15.75 GB write, 266.27 MB/s write, 0.00 GB read, 0.00 MB/s read, 56.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: 142, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 142, interval: 136 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 945 Average: 369.3249 StdDev: 714.08 Min: 1 Median: 5.4946 Max: 3830 Percentiles: P50: 5.49 P75: 475.33 P99: 3612.50 P99.9: 3830.00 P99.99: 3830.00 ------------------------------------------------------ [ 0, 1 ] 199 21.058% 21.058% #### ( 1, 2 ] 119 12.593% 33.651% ### ( 2, 3 ] 59 6.243% 39.894% # ( 3, 4 ] 26 2.751% 42.646% # ( 4, 6 ] 93 9.841% 52.487% ## ( 6, 10 ] 68 7.196% 59.683% # ( 15, 22 ] 2 0.212% 59.894% ( 22, 34 ] 1 0.106% 60.000% ( 110, 170 ] 1 0.106% 60.106% ( 170, 250 ] 79 8.360% 68.466% ## ( 250, 380 ] 26 2.751% 71.217% # ( 380, 580 ] 75 7.937% 79.153% ## ( 580, 870 ] 85 8.995% 88.148% ## ( 870, 1300 ] 44 4.656% 92.804% # ( 1300, 1900 ] 12 1.270% 94.074% ( 1900, 2900 ] 38 4.021% 98.095% # ( 2900, 4400 ] 18 1.905% 100.000% ** DB Stats ** Uptime(secs): 63.6 total, 2.8 interval Cumulative writes: 0 writes, 17M keys, 0 commit groups, 0.0 writes per commit group, ingest: 16.34 GB, 263.16 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:29.929 H:M:S, 47.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 351.68 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.811 H:M:S, 29.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/12/09-10:27:26 ... thread 0: (1000000,18000000) ops and (307412.1,269397.3) ops/second in (3.252962,66.815824) 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 286.8 61.49 56.61 201 0.306 0 0 0.0 0.0 L3 9/0 818.90 MB 0.8 0.0 0.0 0.0 0.0 0.0 17.2 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 108/0 9.41 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 7.01 GB 0.1 0.0 0.0 0.0 0.0 0.0 7.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 201/0 17.22 GB 0.0 0.0 0.0 0.0 17.2 17.2 40.7 1.0 0.0 286.8 61.49 56.61 201 0.306 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 16.8 16.8 39.9 1.0 0.0 291.5 58.99 54.26 196 0.301 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 286.8 61.49 56.61 201 0.306 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 66.8 total, 63.8 interval Flush(GB): cumulative 17.225, interval 16.794 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 17.22 GB write, 263.92 MB/s write, 0.00 GB read, 0.00 MB/s read, 61.5 seconds Interval compaction: 16.79 GB write, 269.48 MB/s write, 0.00 GB read, 0.00 MB/s read, 59.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: 151, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 151, interval: 145 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1005 Average: 366.6408 StdDev: 710.76 Min: 1 Median: 5.4412 Max: 3830 Percentiles: P50: 5.44 P75: 470.74 P99: 3606.58 P99.9: 3830.00 P99.99: 3830.00 ------------------------------------------------------ [ 0, 1 ] 218 21.692% 21.692% #### ( 1, 2 ] 123 12.239% 33.930% ## ( 2, 3 ] 59 5.871% 39.801% # ( 3, 4 ] 29 2.886% 42.687% # ( 4, 6 ] 102 10.149% 52.836% ## ( 6, 10 ] 69 6.866% 59.701% # ( 15, 22 ] 2 0.199% 59.900% ( 22, 34 ] 1 0.100% 60.000% ( 110, 170 ] 1 0.100% 60.100% ( 170, 250 ] 86 8.557% 68.657% ## ( 250, 380 ] 27 2.687% 71.343% # ( 380, 580 ] 81 8.060% 79.403% ## ( 580, 870 ] 88 8.756% 88.159% ## ( 870, 1300 ] 45 4.478% 92.637% # ( 1300, 1900 ] 16 1.592% 94.229% ( 1900, 2900 ] 39 3.881% 98.109% # ( 2900, 4400 ] 19 1.891% 100.000% ** DB Stats ** Uptime(secs): 66.8 total, 3.3 interval Cumulative writes: 0 writes, 18M keys, 0 commit groups, 0.0 writes per commit group, ingest: 17.30 GB, 265.07 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:31.186 H:M:S, 46.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 302.55 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:1.258 H:M:S, 38.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/12/09-10:27:30 ... thread 0: (1000000,19000000) ops and (262589.6,269030.2) ops/second in (3.808224,70.624048) 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 285.5 64.88 59.75 211 0.307 0 0 0.0 0.0 L2 1/0 62.99 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 10/0 944.89 MB 0.9 0.0 0.0 0.0 0.0 0.0 18.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 112/0 9.72 GB 1.0 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 L5 88/0 7.38 GB 0.1 0.0 0.0 0.0 0.0 0.0 7.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 211/0 18.09 GB 0.0 0.0 0.0 0.0 18.1 18.1 60.6 1.0 0.0 285.5 64.88 59.75 211 0.307 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 17.7 17.7 59.8 1.0 0.0 289.8 62.38 57.39 206 0.303 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 285.5 64.88 59.75 211 0.307 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): 70.6 total, 67.6 interval Flush(GB): cumulative 18.086, interval 17.655 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.09 GB write, 262.18 MB/s write, 0.00 GB read, 0.00 MB/s read, 64.9 seconds Interval compaction: 17.66 GB write, 267.35 MB/s write, 0.00 GB read, 0.00 MB/s read, 62.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: 159, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 159, interval: 153 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1055 Average: 370.8133 StdDev: 719.43 Min: 1 Median: 5.4623 Max: 3830 Percentiles: P50: 5.46 P75: 471.28 P99: 3646.43 P99.9: 3830.00 P99.99: 3830.00 ------------------------------------------------------ [ 0, 1 ] 227 21.517% 21.517% #### ( 1, 2 ] 130 12.322% 33.839% ## ( 2, 3 ] 63 5.972% 39.810% # ( 3, 4 ] 30 2.844% 42.654% # ( 4, 6 ] 106 10.047% 52.701% ## ( 6, 10 ] 74 7.014% 59.716% # ( 15, 22 ] 2 0.190% 59.905% ( 22, 34 ] 1 0.095% 60.000% ( 110, 170 ] 1 0.095% 60.095% ( 170, 250 ] 89 8.436% 68.531% ## ( 250, 380 ] 29 2.749% 71.280% # ( 380, 580 ] 86 8.152% 79.431% ## ( 580, 870 ] 91 8.626% 88.057% ## ( 870, 1300 ] 46 4.360% 92.417% # ( 1300, 1900 ] 17 1.611% 94.028% ( 1900, 2900 ] 42 3.981% 98.009% # ( 2900, 4400 ] 21 1.991% 100.000% ** DB Stats ** Uptime(secs): 70.6 total, 3.8 interval Cumulative writes: 0 writes, 19M keys, 0 commit groups, 0.0 writes per commit group, ingest: 18.26 GB, 264.72 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:33.019 H:M:S, 46.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 258.44 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:1.833 H:M:S, 48.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/12/09-10:27:34 ... thread 0: (1000000,20000000) ops and (218788.6,265976.3) ops/second in (4.570622,75.194670) 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 282.5 69.12 63.71 222 0.311 0 0 0.0 0.0 L2 1/0 62.99 MB 0.6 0.0 0.0 0.0 0.0 0.0 19.1 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L3 9/0 881.88 MB 0.9 0.0 0.0 0.0 0.0 0.0 19.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 112/0 9.72 GB 1.0 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 L5 100/0 8.43 GB 0.1 0.0 0.0 0.0 0.0 0.0 8.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 222/0 19.07 GB 0.0 0.0 0.0 0.0 19.1 19.1 64.7 1.0 0.0 282.5 69.12 63.71 222 0.311 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 18.6 18.6 63.9 1.0 0.0 286.5 66.62 61.35 217 0.307 0 0 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- High 0/0 0.00 KB 0.0 0.0 0.0 0.0 19.1 19.1 0.0 0.0 0.0 282.5 69.12 63.71 222 0.311 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): 75.2 total, 72.2 interval Flush(GB): cumulative 19.070, interval 18.640 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, 259.64 MB/s write, 0.00 GB read, 0.00 MB/s read, 69.1 seconds Interval compaction: 18.64 GB write, 264.38 MB/s write, 0.00 GB read, 0.00 MB/s read, 66.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: 169, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 169, interval: 163 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1110 Average: 371.0568 StdDev: 718.87 Min: 1 Median: 5.5229 Max: 3830 Percentiles: P50: 5.52 P75: 475.70 P99: 3676.09 P99.9: 3830.00 P99.99: 3830.00 ------------------------------------------------------ [ 0, 1 ] 231 20.811% 20.811% #### ( 1, 2 ] 139 12.523% 33.333% ### ( 2, 3 ] 72 6.486% 39.820% # ( 3, 4 ] 30 2.703% 42.523% # ( 4, 6 ] 109 9.820% 52.342% ## ( 6, 10 ] 82 7.387% 59.730% # ( 15, 22 ] 2 0.180% 59.910% ( 22, 34 ] 1 0.090% 60.000% ( 110, 170 ] 1 0.090% 60.090% ( 170, 250 ] 91 8.198% 68.288% ## ( 250, 380 ] 30 2.703% 70.991% # ( 380, 580 ] 93 8.378% 79.369% ## ( 580, 870 ] 96 8.649% 88.018% ## ( 870, 1300 ] 50 4.505% 92.523% # ( 1300, 1900 ] 17 1.532% 94.054% ( 1900, 2900 ] 43 3.874% 97.928% # ( 2900, 4400 ] 23 2.072% 100.000% ** DB Stats ** Uptime(secs): 75.2 total, 4.6 interval Cumulative writes: 0 writes, 20M keys, 0 commit groups, 0.0 writes per commit group, ingest: 19.22 GB, 261.72 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:35.609 H:M:S, 47.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 215.33 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:2.590 H:M:S, 56.7 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 : 3.760 micros/op 265973 ops/sec 75.195 seconds 20000000 operations; 257.7 MB/s Microseconds per write: Count: 20000000 Average: 3.7597 StdDev: 804.21 Min: 0 Median: 0.8407 Max: 658390 Percentiles: P50: 0.84 P75: 2.00 P99: 5.99 P99.9: 82.86 P99.99: 168.29 ------------------------------------------------------ [ 0, 1 ] 11895429 59.477% 59.477% ############ ( 1, 2 ] 3115238 15.576% 75.053% ### ( 2, 3 ] 3110696 15.553% 90.607% ### ( 3, 4 ] 1364483 6.822% 97.429% # ( 4, 6 ] 316226 1.581% 99.010% ( 6, 10 ] 54504 0.273% 99.283% ( 10, 15 ] 101301 0.507% 99.789% ( 15, 22 ] 14100 0.071% 99.860% ( 22, 34 ] 6094 0.030% 99.890% ( 34, 51 ] 1292 0.006% 99.897% ( 51, 76 ] 241 0.001% 99.898% ( 76, 110 ] 1964 0.010% 99.908% ( 110, 170 ] 16915 0.085% 99.992% ( 170, 250 ] 865 0.004% 99.997% ( 250, 380 ] 340 0.002% 99.998% ( 380, 580 ] 110 0.001% 99.999% ( 580, 870 ] 9 0.000% 99.999% ( 870, 1300 ] 12 0.000% 99.999% ( 1300, 1900 ] 2 0.000% 99.999% ( 1900, 2900 ] 6 0.000% 99.999% ( 2900, 4400 ] 2 0.000% 99.999% ( 4400, 6600 ] 1 0.000% 99.999% ( 6600, 9900 ] 10 0.000% 99.999% ( 9900, 14000 ] 7 0.000% 99.999% ( 14000, 22000 ] 14 0.000% 99.999% ( 22000, 33000 ] 7 0.000% 99.999% ( 33000, 50000 ] 3 0.000% 99.999% ( 50000, 75000 ] 1 0.000% 99.999% ( 75000, 110000 ] 38 0.000% 100.000% ( 170000, 250000 ] 40 0.000% 100.000% ( 250000, 380000 ] 12 0.000% 100.000% ( 380000, 570000 ] 33 0.000% 100.000% ( 570000, 860000 ] 5 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 : 222 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 35609129 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 : 20476574343 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 : 20312714240 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 : 124091025 rocksdb.non.last.level.read.count COUNT : 1110 rocksdb.block.checksum.compute.count COUNT : 666 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.679656 P95 : 2.952602 P99 : 5.287302 P100 : 658389.000000 COUNT : 20000000 SUM : 65753192 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 : 654.459459 P95 : 850.209459 P99 : 867.609459 P100 : 883.000000 COUNT : 222 SUM : 135954 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 : 108.323394 P95 : 208.976744 P99 : 1923.750000 P100 : 3188.000000 COUNT : 881 SUM : 128476 rocksdb.table.open.io.micros P50 : 2081.818182 P95 : 4166.923077 P99 : 4371.846154 P100 : 4763.000000 COUNT : 222 SUM : 498220 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 : 646.458333 P95 : 3325.806452 P99 : 3918.000000 P100 : 3918.000000 COUNT : 444 SUM : 449891 rocksdb.write.raw.block.micros P50 : 0.591237 P95 : 1.751332 P99 : 4.228940 P100 : 3657.000000 COUNT : 4969612 SUM : 13805710 rocksdb.numfiles.in.singlecompaction P50 : 1.000000 P95 : 3.580128 P99 : 3.916026 P100 : 4.000000 COUNT : 655 SUM : 977 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 : 181000.000000 P95 : 550136.363636 P99 : 658174.000000 P100 : 658174.000000 COUNT : 169 SUM : 35609129 rocksdb.sst.read.micros P50 : 5.522936 P95 : 2144.186047 P99 : 3676.086957 P100 : 3830.000000 COUNT : 1110 SUM : 411873 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 : 280121.951220 P95 : 752839.000000 P99 : 752839.000000 P100 : 752839.000000 COUNT : 222 SUM : 69124999 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