[2024-07-25 11:00:35.653599] Starting SPDK v24.09-pre git sha1 623b676ee / DPDK 24.03.0 initialization... [2024-07-25 11:00:35.653918] [ 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_pid838492 ] Set seed to 1721898035646367 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-07-25 11:00:35.852505] app.c: 909:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-07-25 11:00:36.171771] app.c: 603:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-07-25 11:00:36.171833] app.c: 604:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 838492' to capture a snapshot of events at runtime. [2024-07-25 11:00:36.171851] app.c: 609:app_setup_trace: *NOTICE*: 'spdk_trace' without parameters will also work if this is the only [2024-07-25 11:00:36.171871] app.c: 610:app_setup_trace: *NOTICE*: SPDK application currently running. [2024-07-25 11:00:36.171885] app.c: 611:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid838492 for offline analysis/debug. [2024-07-25 11:00:36.172015] reactor.c: 941:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Thu Jul 25 11:00:43 2024 CPU: 72 * Intel(R) Xeon(R) Gold 6140 CPU @ 2.30GHz CPUCache: 25344 KB 2024/07/25-11:00:46 ... thread 0: (1000000,1000000) ops and (313536.8,313536.8) ops/second in (3.189418,3.189418) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 0/0 0.00 KB 0.0 0.0 0.0 0.0 0.8 0.8 0.0 1.0 0.0 307.2 2.67 2.40 11 0.242 0 0 0.0 0.0 L3 11/0 818.93 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 11/0 818.93 MB 0.0 0.0 0.0 0.0 0.8 0.8 0.8 1.0 0.0 307.2 2.67 2.40 11 0.242 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 0.1 0.1 17179869183.4 1.0 0.0 349.3 0.18 0.16 1 0.180 0 0 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- High 0/0 0.00 KB 0.0 0.0 0.0 0.0 0.8 0.8 0.0 0.0 0.0 307.2 2.67 2.40 11 0.242 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): 3.2 total, 0.2 interval Flush(GB): cumulative 0.800, interval 0.062 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 0.80 GB write, 254.57 MB/s write, 0.00 GB read, 0.00 MB/s read, 2.7 seconds Interval compaction: 0.06 GB write, 333.02 MB/s write, 0.00 GB read, 0.00 MB/s read, 0.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: 5, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 5, interval: 1 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 55 Average: 685.7818 StdDev: 1268.14 Min: 1 Median: 4.1667 Max: 4093 Percentiles: P50: 4.17 P75: 369.17 P99: 4093.00 P99.9: 4093.00 P99.99: 4093.00 ------------------------------------------------------ [ 0, 1 ] 10 18.182% 18.182% #### ( 1, 2 ] 11 20.000% 38.182% #### ( 3, 4 ] 6 10.909% 49.091% ## ( 4, 6 ] 6 10.909% 60.000% ## ( 250, 380 ] 9 16.364% 76.364% ### ( 380, 580 ] 2 3.636% 80.000% # ( 870, 1300 ] 1 1.818% 81.818% ( 1900, 2900 ] 2 3.636% 85.455% # ( 2900, 4400 ] 8 14.545% 100.000% ### ** DB Stats ** Uptime(secs): 3.2 total, 0.2 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 305.92 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:0.671 H:M:S, 20.9 percent Interval writes: 0 writes, 62K keys, 0 commit groups, 0.0 writes per commit group, ingest: 61.98 MB, 325.74 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.029 H:M:S, 15.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/07/25-11:00:50 ... thread 0: (1000000,2000000) ops and (289352.0,300959.3) ops/second in (3.455998,6.645416) 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 322.7 5.86 5.25 24 0.244 0 0 0.0 0.0 L3 12/0 944.92 MB 0.9 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 944.92 MB 0.1 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 Sum 24/0 1.85 GB 0.0 0.0 0.0 0.0 1.8 1.8 2.8 1.0 0.0 322.7 5.86 5.25 24 0.244 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 1.1 1.1 1.4 1.0 0.0 336.4 3.37 3.01 14 0.241 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 322.7 5.86 5.25 24 0.244 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): 6.7 total, 3.6 interval Flush(GB): cumulative 1.846, interval 1.107 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 1.85 GB write, 283.21 MB/s write, 0.00 GB read, 0.00 MB/s read, 5.9 seconds Interval compaction: 1.11 GB write, 311.08 MB/s write, 0.00 GB read, 0.00 MB/s read, 3.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: 9, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 9, interval: 5 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 120 Average: 669.2667 StdDev: 1255.20 Min: 1 Median: 4.6154 Max: 4918 Percentiles: P50: 4.62 P75: 446.67 P99: 4380.00 P99.9: 4918.00 P99.99: 4918.00 ------------------------------------------------------ [ 0, 1 ] 21 17.500% 17.500% #### ( 1, 2 ] 21 17.500% 35.000% #### ( 2, 3 ] 3 2.500% 37.500% # ( 3, 4 ] 11 9.167% 46.667% ## ( 4, 6 ] 13 10.833% 57.500% ## ( 6, 10 ] 2 1.667% 59.167% ( 15, 22 ] 1 0.833% 60.000% ( 250, 380 ] 16 13.333% 73.333% ### ( 380, 580 ] 6 5.000% 78.333% # ( 580, 870 ] 1 0.833% 79.167% ( 870, 1300 ] 6 5.000% 84.167% # ( 1900, 2900 ] 3 2.500% 86.667% # ( 2900, 4400 ] 15 12.500% 99.167% ### ( 4400, 6600 ] 1 0.833% 100.000% ** DB Stats ** Uptime(secs): 6.7 total, 3.5 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 294.98 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:1.631 H:M:S, 24.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 284.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:0.960 H:M:S, 27.8 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/07/25-11:00:55 ... thread 0: (1000000,3000000) ops and (185647.1,249335.5) ops/second in (5.386563,12.031979) 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 265.5 10.68 9.75 34 0.314 0 0 0.0 0.0 L3 10/0 944.91 MB 0.9 0.0 0.0 0.0 0.0 0.0 2.8 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 24/0 1.85 GB 0.2 0.0 0.0 0.0 0.0 0.0 1.8 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 34/0 2.77 GB 0.0 0.0 0.0 0.0 2.8 2.8 4.6 1.0 0.0 265.5 10.68 9.75 34 0.314 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 2.0 2.0 3.2 1.0 0.0 253.8 8.19 7.52 24 0.341 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 265.5 10.68 9.75 34 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): 12.1 total, 9.0 interval Flush(GB): cumulative 2.768, interval 2.030 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, 235.06 MB/s write, 0.00 GB read, 0.00 MB/s read, 10.7 seconds Interval compaction: 2.03 GB write, 230.17 MB/s write, 0.00 GB read, 0.00 MB/s read, 8.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: 19, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 19, interval: 15 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 170 Average: 687.4765 StdDev: 1240.34 Min: 1 Median: 5.3846 Max: 4918 Percentiles: P50: 5.38 P75: 552.73 P99: 4352.27 P99.9: 4918.00 P99.99: 4918.00 ------------------------------------------------------ [ 0, 1 ] 21 12.353% 12.353% ## ( 1, 2 ] 26 15.294% 27.647% ### ( 2, 3 ] 18 10.588% 38.235% ## ( 3, 4 ] 11 6.471% 44.706% # ( 4, 6 ] 13 7.647% 52.353% ## ( 6, 10 ] 12 7.059% 59.412% # ( 15, 22 ] 1 0.588% 60.000% ( 250, 380 ] 16 9.412% 69.412% ## ( 380, 580 ] 11 6.471% 75.882% # ( 580, 870 ] 1 0.588% 76.471% ( 870, 1300 ] 13 7.647% 84.118% ## ( 1300, 1900 ] 1 0.588% 84.706% ( 1900, 2900 ] 3 1.765% 86.471% ( 2900, 4400 ] 22 12.941% 99.412% ### ( 4400, 6600 ] 1 0.588% 100.000% ** DB Stats ** Uptime(secs): 12.1 total, 5.4 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 244.83 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.469 H:M:S, 37.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 182.71 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.838 H:M:S, 52.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/07/25-11:01:00 ... thread 0: (1000000,4000000) ops and (212900.4,239105.6) ops/second in (4.697032,16.729011) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 0/0 0.00 KB 0.0 0.0 0.0 0.0 3.7 3.7 0.0 1.0 0.0 252.0 15.00 13.76 45 0.333 0 0 0.0 0.0 L2 1/0 62.99 MB 0.6 0.0 0.0 0.0 0.0 0.0 3.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L3 8/0 692.90 MB 0.7 0.0 0.0 0.0 0.0 0.0 3.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 36/0 2.95 GB 0.3 0.0 0.0 0.0 0.0 0.0 3.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 45/0 3.69 GB 0.0 0.0 0.0 0.0 3.7 3.7 10.3 1.0 0.0 252.0 15.00 13.76 45 0.333 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 3.0 3.0 8.9 1.0 0.0 241.7 12.51 11.53 35 0.357 0 0 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- High 0/0 0.00 KB 0.0 0.0 0.0 0.0 3.7 3.7 0.0 0.0 0.0 252.0 15.00 13.76 45 0.333 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): 16.8 total, 13.7 interval Flush(GB): cumulative 3.691, interval 2.953 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 3.69 GB write, 225.56 MB/s write, 0.00 GB read, 0.00 MB/s read, 15.0 seconds Interval compaction: 2.95 GB write, 220.25 MB/s write, 0.00 GB read, 0.00 MB/s read, 12.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: 27, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 27, interval: 23 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 225 Average: 680.5111 StdDev: 1223.86 Min: 1 Median: 5.5625 Max: 4918 Percentiles: P50: 5.56 P75: 564.38 P99: 4335.34 P99.9: 4918.00 P99.99: 4918.00 ------------------------------------------------------ [ 0, 1 ] 27 12.000% 12.000% ## ( 1, 2 ] 33 14.667% 26.667% ### ( 2, 3 ] 27 12.000% 38.667% ## ( 3, 4 ] 13 5.778% 44.444% # ( 4, 6 ] 16 7.111% 51.556% # ( 6, 10 ] 18 8.000% 59.556% ## ( 15, 22 ] 1 0.444% 60.000% ( 250, 380 ] 19 8.444% 68.444% ## ( 380, 580 ] 16 7.111% 75.556% # ( 580, 870 ] 1 0.444% 76.000% ( 870, 1300 ] 20 8.889% 84.889% ## ( 1300, 1900 ] 1 0.444% 85.333% ( 1900, 2900 ] 3 1.333% 86.667% ( 2900, 4400 ] 29 12.889% 99.556% ### ( 4400, 6600 ] 1 0.444% 100.000% ** DB Stats ** Uptime(secs): 16.8 total, 4.7 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 234.94 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:6.641 H:M:S, 39.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 209.53 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:2.173 H:M:S, 46.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/07/25-11:01:03 ... thread 0: (1000000,5000000) ops and (314982.5,251208.4) ops/second in (3.174780,19.903791) 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 267.5 17.90 16.35 58 0.309 0 0 0.0 0.0 L2 1/0 62.99 MB 0.6 0.0 0.0 0.0 0.0 0.0 4.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L3 9/0 692.91 MB 0.7 0.0 0.0 0.0 0.0 0.0 4.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 48/0 3.94 GB 0.4 0.0 0.0 0.0 0.0 0.0 3.9 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 58/0 4.68 GB 0.0 0.0 0.0 0.0 4.7 4.7 13.2 1.0 0.0 267.5 17.90 16.35 58 0.309 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 3.9 3.9 11.8 1.0 0.0 261.6 15.41 14.11 48 0.321 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 267.5 17.90 16.35 58 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): 19.9 total, 16.9 interval Flush(GB): cumulative 4.675, interval 3.937 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 4.68 GB write, 240.20 MB/s write, 0.00 GB read, 0.00 MB/s read, 17.9 seconds Interval compaction: 3.94 GB write, 238.51 MB/s write, 0.00 GB read, 0.00 MB/s read, 15.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: 30, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 30, interval: 26 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 290 Average: 664.4690 StdDev: 1208.51 Min: 1 Median: 4.9474 Max: 4918 Percentiles: P50: 4.95 P75: 532.63 P99: 4325.00 P99.9: 4918.00 P99.99: 4918.00 ------------------------------------------------------ [ 0, 1 ] 42 14.483% 14.483% ### ( 1, 2 ] 44 15.172% 29.655% ### ( 2, 3 ] 28 9.655% 39.310% ## ( 3, 4 ] 22 7.586% 46.897% ## ( 4, 6 ] 19 6.552% 53.448% # ( 6, 10 ] 18 6.207% 59.655% # ( 15, 22 ] 1 0.345% 60.000% ( 250, 380 ] 29 10.000% 70.000% ## ( 380, 580 ] 19 6.552% 76.552% # ( 580, 870 ] 1 0.345% 76.897% ( 870, 1300 ] 23 7.931% 84.828% ## ( 1300, 1900 ] 2 0.690% 85.517% ( 1900, 2900 ] 3 1.034% 86.552% ( 2900, 4400 ] 38 13.103% 99.655% ### ( 4400, 6600 ] 1 0.345% 100.000% ** DB Stats ** Uptime(secs): 19.9 total, 3.2 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 246.89 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.268 H:M:S, 36.5 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 310.00 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.627 H:M:S, 19.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/07/25-11:01:06 ... thread 0: (1000000,6000000) ops and (307506.9,259114.9) ops/second in (3.251960,23.155751) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 0/0 0.00 KB 0.0 0.0 0.0 0.0 5.6 5.6 0.0 1.0 0.0 276.7 20.72 18.87 70 0.296 0 0 0.0 0.0 L3 10/0 755.91 MB 0.8 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.86 GB 0.5 0.0 0.0 0.0 0.0 0.0 4.9 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 70/0 5.60 GB 0.0 0.0 0.0 0.0 5.6 5.6 10.5 1.0 0.0 276.7 20.72 18.87 70 0.296 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 4.9 4.9 9.0 1.0 0.0 273.0 18.23 16.64 60 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 5.6 5.6 0.0 0.0 0.0 276.7 20.72 18.87 70 0.296 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 23.2 total, 20.2 interval Flush(GB): cumulative 5.598, interval 4.860 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 5.60 GB write, 247.27 MB/s write, 0.00 GB read, 0.00 MB/s read, 20.7 seconds Interval compaction: 4.86 GB write, 246.90 MB/s write, 0.00 GB read, 0.00 MB/s read, 18.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: 35, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 35, interval: 31 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 350 Average: 663.9286 StdDev: 1209.79 Min: 1 Median: 4.6087 Max: 4918 Percentiles: P50: 4.61 P75: 518.10 P99: 4320.21 P99.9: 4918.00 P99.99: 4918.00 ------------------------------------------------------ [ 0, 1 ] 55 15.714% 15.714% ### ( 1, 2 ] 54 15.429% 31.143% ### ( 2, 3 ] 29 8.286% 39.429% ## ( 3, 4 ] 30 8.571% 48.000% ## ( 4, 6 ] 23 6.571% 54.571% # ( 6, 10 ] 18 5.143% 59.714% # ( 15, 22 ] 1 0.286% 60.000% ( 250, 380 ] 38 10.857% 70.857% ## ( 380, 580 ] 21 6.000% 76.857% # ( 580, 870 ] 1 0.286% 77.143% ( 870, 1300 ] 26 7.429% 84.571% # ( 1300, 1900 ] 3 0.857% 85.429% ( 1900, 2900 ] 3 0.857% 86.286% ( 2900, 4400 ] 47 13.429% 99.714% ### ( 4400, 6600 ] 1 0.286% 100.000% ** DB Stats ** Uptime(secs): 23.2 total, 3.3 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 254.71 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.028 H:M:S, 34.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 302.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:0.760 H:M:S, 23.4 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/07/25-11:01:09 ... thread 0: (1000000,7000000) ops and (314650.5,265817.3) ops/second in (3.178129,26.333880) 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 285.5 23.61 21.47 83 0.284 0 0 0.0 0.0 L3 11/0 818.91 MB 0.8 0.0 0.0 0.0 0.0 0.0 6.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 72/0 5.78 GB 0.6 0.0 0.0 0.0 0.0 0.0 5.8 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 83/0 6.58 GB 0.0 0.0 0.0 0.0 6.6 6.6 12.4 1.0 0.0 285.5 23.61 21.47 83 0.284 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 5.8 5.8 11.0 1.0 0.0 283.3 21.12 19.23 73 0.289 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 285.5 23.61 21.47 83 0.284 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): 26.4 total, 23.3 interval Flush(GB): cumulative 6.582, interval 5.844 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, 255.69 MB/s write, 0.00 GB read, 0.00 MB/s read, 23.6 seconds Interval compaction: 5.84 GB write, 256.47 MB/s write, 0.00 GB read, 0.00 MB/s read, 21.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: 39, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 39, interval: 35 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 415 Average: 651.2000 StdDev: 1196.34 Min: 1 Median: 4.4643 Max: 4918 Percentiles: P50: 4.46 P75: 498.75 P99: 4314.09 P99.9: 4918.00 P99.99: 4918.00 ------------------------------------------------------ [ 0, 1 ] 72 17.349% 17.349% ### ( 1, 2 ] 63 15.181% 32.530% ### ( 2, 3 ] 32 7.711% 40.241% ## ( 3, 4 ] 34 8.193% 48.434% ## ( 4, 6 ] 28 6.747% 55.181% # ( 6, 10 ] 18 4.337% 59.518% # ( 10, 15 ] 1 0.241% 59.759% ( 15, 22 ] 1 0.241% 60.000% ( 250, 380 ] 48 11.566% 71.566% ## ( 380, 580 ] 24 5.783% 77.349% # ( 580, 870 ] 1 0.241% 77.590% ( 870, 1300 ] 29 6.988% 84.578% # ( 1300, 1900 ] 5 1.205% 85.783% ( 1900, 2900 ] 3 0.723% 86.506% ( 2900, 4400 ] 55 13.253% 99.759% ### ( 4400, 6600 ] 1 0.241% 100.000% ** DB Stats ** Uptime(secs): 26.4 total, 3.2 interval Cumulative writes: 0 writes, 7000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 6.73 GB, 261.34 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:8.719 H:M:S, 33.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 309.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.691 H:M:S, 21.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/07/25-11:01:15 ... thread 0: (1000000,8000000) ops and (186233.2,252338.1) ops/second in (5.369611,31.703491) 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 272.0 28.49 26.04 94 0.303 0 0 0.0 0.0 L3 10/0 944.91 MB 0.9 0.0 0.0 0.0 0.0 0.0 7.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 84/0 6.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 94/0 7.57 GB 0.0 0.0 0.0 0.0 7.6 7.6 14.2 1.0 0.0 272.0 28.49 26.04 94 0.303 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 6.8 6.8 12.8 1.0 0.0 268.9 26.00 23.80 84 0.310 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 272.0 28.49 26.04 94 0.303 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.7 total, 28.7 interval Flush(GB): cumulative 7.567, interval 6.828 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, 244.18 MB/s write, 0.00 GB read, 0.00 MB/s read, 28.5 seconds Interval compaction: 6.83 GB write, 243.61 MB/s write, 0.00 GB read, 0.00 MB/s read, 26.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: 49, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 49, interval: 45 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 470 Average: 636.9277 StdDev: 1164.60 Min: 1 Median: 4.7273 Max: 4918 Percentiles: P50: 4.73 P75: 526.43 P99: 4305.93 P99.9: 4918.00 P99.99: 4918.00 ------------------------------------------------------ [ 0, 1 ] 75 15.957% 15.957% ### ( 1, 2 ] 68 14.468% 30.426% ### ( 2, 3 ] 46 9.787% 40.213% ## ( 3, 4 ] 34 7.234% 47.447% # ( 4, 6 ] 33 7.021% 54.468% # ( 6, 10 ] 24 5.106% 59.574% # ( 10, 15 ] 1 0.213% 59.787% ( 15, 22 ] 1 0.213% 60.000% ( 250, 380 ] 50 10.638% 70.638% ## ( 380, 580 ] 28 5.957% 76.596% # ( 580, 870 ] 2 0.426% 77.021% ( 870, 1300 ] 39 8.298% 85.319% ## ( 1300, 1900 ] 6 1.277% 86.596% ( 1900, 2900 ] 3 0.638% 87.234% ( 2900, 4400 ] 59 12.553% 99.787% ### ( 4400, 6600 ] 1 0.213% 100.000% ** DB Stats ** Uptime(secs): 31.7 total, 5.4 interval Cumulative writes: 0 writes, 8000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 7.69 GB, 248.13 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:11.508 H:M:S, 36.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 183.29 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.789 H:M:S, 51.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/07/25-11:01:20 ... thread 0: (1000000,9000000) ops and (181181.9,241787.3) ops/second in (5.519314,37.222805) 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.5 8.5 0.0 1.0 0.0 260.1 33.42 30.63 104 0.321 0 0 0.0 0.0 L3 8/0 755.90 MB 0.8 0.0 0.0 0.0 0.0 0.0 8.5 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 96/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 104/0 8.49 GB 0.0 0.0 0.0 0.0 8.5 8.5 16.2 1.0 0.0 260.1 33.42 30.63 104 0.321 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 7.8 7.8 14.8 1.0 0.0 256.6 30.94 28.39 94 0.329 0 0 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- High 0/0 0.00 KB 0.0 0.0 0.0 0.0 8.5 8.5 0.0 0.0 0.0 260.1 33.42 30.63 104 0.321 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 37.3 total, 34.2 interval Flush(GB): cumulative 8.489, interval 7.751 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.49 GB write, 233.37 MB/s write, 0.00 GB read, 0.00 MB/s read, 33.4 seconds Interval compaction: 7.75 GB write, 231.93 MB/s write, 0.00 GB read, 0.00 MB/s read, 30.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: 59, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 59, interval: 55 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 520 Average: 664.2865 StdDev: 1210.32 Min: 1 Median: 5.0303 Max: 4996 Percentiles: P50: 5.03 P75: 549.70 P99: 4371.87 P99.9: 4996.00 P99.99: 4996.00 ------------------------------------------------------ [ 0, 1 ] 75 14.423% 14.423% ### ( 1, 2 ] 75 14.423% 28.846% ### ( 2, 3 ] 59 11.346% 40.192% ## ( 3, 4 ] 34 6.538% 46.731% # ( 4, 6 ] 33 6.346% 53.077% # ( 6, 10 ] 34 6.538% 59.615% # ( 10, 15 ] 1 0.192% 59.808% ( 15, 22 ] 1 0.192% 60.000% ( 250, 380 ] 50 9.615% 69.615% ## ( 380, 580 ] 33 6.346% 75.962% # ( 580, 870 ] 2 0.385% 76.346% ( 870, 1300 ] 44 8.462% 84.808% ## ( 1300, 1900 ] 8 1.538% 86.346% ( 1900, 2900 ] 3 0.577% 86.923% ( 2900, 4400 ] 64 12.308% 99.231% ## ( 4400, 6600 ] 4 0.769% 100.000% ** DB Stats ** Uptime(secs): 37.3 total, 5.5 interval Cumulative writes: 0 writes, 9000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 8.65 GB, 237.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:14.470 H:M:S, 38.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 178.32 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:2.962 H:M:S, 53.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/07/25-11:01:25 ... thread 0: (1000000,10000000) ops and (217952.4,239171.7) ops/second in (4.588157,41.810962) 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 257.3 37.70 34.58 116 0.325 0 0 0.0 0.0 L3 8/0 629.95 MB 0.6 0.0 0.0 0.0 0.0 0.0 9.5 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 108/0 8.86 GB 0.9 0.0 0.0 0.0 0.0 0.0 8.9 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 116/0 9.47 GB 0.0 0.0 0.0 0.0 9.5 9.5 18.3 1.0 0.0 257.3 37.70 34.58 116 0.325 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 8.7 8.7 16.9 1.0 0.0 254.0 35.22 32.35 106 0.332 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 257.3 37.70 34.58 116 0.325 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): 41.8 total, 38.8 interval Flush(GB): cumulative 9.474, interval 8.735 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, 231.87 MB/s write, 0.00 GB read, 0.00 MB/s read, 37.7 seconds Interval compaction: 8.74 GB write, 230.48 MB/s write, 0.00 GB read, 0.00 MB/s read, 35.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: 67, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 67, interval: 63 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 580 Average: 654.4862 StdDev: 1195.25 Min: 1 Median: 5.0270 Max: 4996 Percentiles: P50: 5.03 P75: 552.97 P99: 4382.35 P99.9: 4996.00 P99.99: 4996.00 ------------------------------------------------------ [ 0, 1 ] 84 14.483% 14.483% ### ( 1, 2 ] 82 14.138% 28.621% ### ( 2, 3 ] 67 11.552% 40.172% ## ( 3, 4 ] 38 6.552% 46.724% # ( 4, 6 ] 37 6.379% 53.103% # ( 6, 10 ] 38 6.552% 59.655% # ( 10, 15 ] 1 0.172% 59.828% ( 15, 22 ] 1 0.172% 60.000% ( 250, 380 ] 55 9.483% 69.483% ## ( 380, 580 ] 37 6.379% 75.862% # ( 580, 870 ] 2 0.345% 76.207% ( 870, 1300 ] 51 8.793% 85.000% ## ( 1300, 1900 ] 11 1.897% 86.897% ( 1900, 2900 ] 3 0.517% 87.414% ( 2900, 4400 ] 68 11.724% 99.138% ## ( 4400, 6600 ] 5 0.862% 100.000% ** DB Stats ** Uptime(secs): 41.8 total, 4.6 interval Cumulative writes: 0 writes, 10M keys, 0 commit groups, 0.0 writes per commit group, ingest: 9.61 GB, 235.24 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:16.526 H:M:S, 39.5 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 214.51 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.056 H:M:S, 44.8 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/07/25-11:01:28 ... thread 0: (1000000,11000000) ops and (315135.5,244530.3) ops/second in (3.173238,44.984200) 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.4 10.4 0.0 1.0 0.0 263.3 40.44 37.01 128 0.316 0 0 0.0 0.0 L3 12/0 944.91 MB 0.9 0.0 0.0 0.0 0.0 0.0 10.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 116/0 9.47 GB 1.0 0.0 0.0 0.0 0.0 0.0 9.5 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 128/0 10.40 GB 0.0 0.0 0.0 0.0 10.4 10.4 19.9 1.0 0.0 263.3 40.44 37.01 128 0.316 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 9.7 9.7 18.5 1.0 0.0 260.6 37.95 34.78 118 0.322 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.4 10.4 0.0 0.0 0.0 263.3 40.44 37.01 128 0.316 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 45.0 total, 42.0 interval Flush(GB): cumulative 10.396, interval 9.658 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.40 GB write, 236.51 MB/s write, 0.00 GB read, 0.00 MB/s read, 40.4 seconds Interval compaction: 9.66 GB write, 235.57 MB/s write, 0.00 GB read, 0.00 MB/s read, 38.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: 71, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 71, interval: 67 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 644 Average: 649.4565 StdDev: 1194.36 Min: 1 Median: 4.7805 Max: 4996 Percentiles: P50: 4.78 P75: 535.00 P99: 4371.58 P99.9: 4996.00 P99.99: 4996.00 ------------------------------------------------------ [ 0, 1 ] 99 15.373% 15.373% ### ( 1, 2 ] 93 14.441% 29.814% ### ( 2, 3 ] 67 10.404% 40.217% ## ( 3, 4 ] 47 7.298% 47.516% # ( 4, 6 ] 41 6.366% 53.882% # ( 6, 10 ] 38 5.901% 59.783% # ( 10, 15 ] 1 0.155% 59.938% ( 15, 22 ] 1 0.155% 60.093% ( 250, 380 ] 65 10.093% 70.186% ## ( 380, 580 ] 40 6.211% 76.398% # ( 580, 870 ] 2 0.311% 76.708% ( 870, 1300 ] 53 8.230% 84.938% ## ( 1300, 1900 ] 13 2.019% 86.957% ( 1900, 2900 ] 3 0.466% 87.422% ( 2900, 4400 ] 76 11.801% 99.224% ## ( 4400, 6600 ] 5 0.776% 100.000% ** DB Stats ** Uptime(secs): 45.0 total, 3.2 interval Cumulative writes: 0 writes, 11M keys, 0 commit groups, 0.0 writes per commit group, ingest: 10.57 GB, 240.52 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:17.234 H:M:S, 38.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 310.16 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.708 H:M:S, 22.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/07/25-11:01:31 ... thread 0: (1000000,12000000) ops and (306759.0,248735.1) ops/second in (3.259888,48.244088) 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 268.2 43.45 39.70 141 0.308 0 0 0.0 0.0 L2 1/0 62.99 MB 0.6 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 L3 12/0 944.88 MB 0.9 0.0 0.0 0.0 0.0 0.0 11.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 116/0 9.47 GB 1.0 0.0 0.0 0.0 0.0 0.0 10.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 12/0 944.92 MB 0.0 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 Sum 141/0 11.38 GB 0.0 0.0 0.0 0.0 11.4 11.4 34.0 1.0 0.0 268.2 43.45 39.70 141 0.308 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 10.6 10.6 32.6 1.0 0.0 266.0 40.96 37.46 131 0.313 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 268.2 43.45 39.70 141 0.308 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.3 total, 45.2 interval Flush(GB): cumulative 11.381, interval 10.642 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, 241.42 MB/s write, 0.00 GB read, 0.00 MB/s read, 43.4 seconds Interval compaction: 10.64 GB write, 240.87 MB/s write, 0.00 GB read, 0.00 MB/s read, 41.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: 75, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 75, interval: 71 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 705 Average: 654.4596 StdDev: 1203.25 Min: 1 Median: 4.6279 Max: 4996 Percentiles: P50: 4.63 P75: 527.67 P99: 4364.24 P99.9: 4996.00 P99.99: 4996.00 ------------------------------------------------------ [ 0, 1 ] 113 16.028% 16.028% ### ( 1, 2 ] 103 14.610% 30.638% ### ( 2, 3 ] 71 10.071% 40.709% ## ( 3, 4 ] 52 7.376% 48.085% # ( 4, 6 ] 43 6.099% 54.184% # ( 6, 10 ] 39 5.532% 59.716% # ( 10, 15 ] 1 0.142% 59.858% ( 15, 22 ] 1 0.142% 60.000% ( 250, 380 ] 74 10.496% 70.496% ## ( 380, 580 ] 43 6.099% 76.596% # ( 580, 870 ] 2 0.284% 76.879% ( 870, 1300 ] 55 7.801% 84.681% ## ( 1300, 1900 ] 14 1.986% 86.667% ( 1900, 2900 ] 3 0.426% 87.092% ( 2900, 4400 ] 86 12.199% 99.291% ## ( 4400, 6600 ] 5 0.709% 100.000% ** DB Stats ** Uptime(secs): 48.3 total, 3.3 interval Cumulative writes: 0 writes, 12M keys, 0 commit groups, 0.0 writes per commit group, ingest: 11.53 GB, 244.66 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:18.009 H:M:S, 37.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 301.90 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.775 H:M:S, 23.8 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/07/25-11:01:35 ... thread 0: (1000000,13000000) ops and (284129.9,251141.7) ops/second in (3.519517,51.763605) 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 272.8 46.65 42.56 154 0.303 0 0 0.0 0.0 L3 10/0 818.91 MB 0.8 0.0 0.0 0.0 0.0 0.0 12.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 116/0 9.41 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 28/0 2.21 GB 0.0 0.0 0.0 0.0 0.0 0.0 2.2 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 154/0 12.43 GB 0.0 0.0 0.0 0.0 12.4 12.4 26.3 1.0 0.0 272.8 46.65 42.56 154 0.303 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 11.7 11.7 24.9 1.0 0.0 271.0 44.16 40.32 144 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 12.4 12.4 0.0 0.0 0.0 272.8 46.65 42.56 154 0.303 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): 51.8 total, 48.8 interval Flush(GB): cumulative 12.426, interval 11.688 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 12.43 GB write, 245.69 MB/s write, 0.00 GB read, 0.00 MB/s read, 46.6 seconds Interval compaction: 11.69 GB write, 245.45 MB/s write, 0.00 GB read, 0.00 MB/s read, 44.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: 81, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 81, interval: 77 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 770 Average: 647.1286 StdDev: 1192.86 Min: 1 Median: 4.4091 Max: 4996 Percentiles: P50: 4.41 P75: 518.30 P99: 4356.91 P99.9: 4996.00 P99.99: 4996.00 ------------------------------------------------------ [ 0, 1 ] 132 17.143% 17.143% ### ( 1, 2 ] 110 14.286% 31.429% ### ( 2, 3 ] 75 9.740% 41.169% ## ( 3, 4 ] 59 7.662% 48.831% ## ( 4, 6 ] 44 5.714% 54.545% # ( 6, 10 ] 40 5.195% 59.740% # ( 10, 15 ] 1 0.130% 59.870% ( 15, 22 ] 1 0.130% 60.000% ( 250, 380 ] 83 10.779% 70.779% ## ( 380, 580 ] 47 6.104% 76.883% # ( 580, 870 ] 2 0.260% 77.143% ( 870, 1300 ] 60 7.792% 84.935% ## ( 1300, 1900 ] 14 1.818% 86.753% ( 1900, 2900 ] 3 0.390% 87.143% ( 2900, 4400 ] 94 12.208% 99.351% ## ( 4400, 6600 ] 5 0.649% 100.000% ** DB Stats ** Uptime(secs): 51.8 total, 3.5 interval Cumulative writes: 0 writes, 13M keys, 0 commit groups, 0.0 writes per commit group, ingest: 12.49 GB, 247.04 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:19.033 H:M:S, 36.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 279.64 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.024 H:M:S, 29.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/07/25-11:01:38 ... thread 0: (1000000,14000000) ops and (312386.2,254708.6) ops/second in (3.201166,54.964771) 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 276.6 49.42 45.01 166 0.298 0 0 0.0 0.0 L3 10/0 818.90 MB 0.8 0.0 0.0 0.0 0.0 0.0 13.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 120/0 9.60 GB 1.0 0.0 0.0 0.0 0.0 0.0 12.5 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 36/0 2.95 GB 0.0 0.0 0.0 0.0 0.0 0.0 3.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 166/0 13.35 GB 0.0 0.0 0.0 0.0 13.3 13.3 28.9 1.0 0.0 276.6 49.42 45.01 166 0.298 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 12.6 12.6 27.4 1.0 0.0 275.2 46.93 42.78 156 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 13.3 13.3 0.0 0.0 0.0 276.6 49.42 45.01 166 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): 55.0 total, 52.0 interval Flush(GB): cumulative 13.349, interval 12.611 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.35 GB write, 248.57 MB/s write, 0.00 GB read, 0.00 MB/s read, 49.4 seconds Interval compaction: 12.61 GB write, 248.51 MB/s write, 0.00 GB read, 0.00 MB/s read, 46.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: 86, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 86, interval: 82 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 830 Average: 651.9325 StdDev: 1200.13 Min: 1 Median: 4.1364 Max: 4996 Percentiles: P50: 4.14 P75: 510.00 P99: 4352.86 P99.9: 4996.00 P99.99: 4996.00 ------------------------------------------------------ [ 0, 1 ] 152 18.313% 18.313% #### ( 1, 2 ] 114 13.735% 32.048% ### ( 2, 3 ] 78 9.398% 41.446% ## ( 3, 4 ] 68 8.193% 49.639% ## ( 4, 6 ] 44 5.301% 54.940% # ( 6, 10 ] 40 4.819% 59.759% # ( 10, 15 ] 1 0.120% 59.880% ( 15, 22 ] 1 0.120% 60.000% ( 250, 380 ] 92 11.084% 71.084% ## ( 380, 580 ] 50 6.024% 77.108% # ( 580, 870 ] 2 0.241% 77.349% ( 870, 1300 ] 60 7.229% 84.578% # ( 1300, 1900 ] 15 1.807% 86.386% ( 1900, 2900 ] 3 0.361% 86.747% ( 2900, 4400 ] 105 12.651% 99.398% ### ( 4400, 6600 ] 5 0.602% 100.000% ** DB Stats ** Uptime(secs): 55.0 total, 3.2 interval Cumulative writes: 0 writes, 14M keys, 0 commit groups, 0.0 writes per commit group, ingest: 13.46 GB, 250.56 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:19.758 H:M:S, 35.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 307.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:0.725 H:M:S, 22.6 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/07/25-11:01:41 ... thread 0: (1000000,15000000) ops and (303098.9,257448.7) ops/second in (3.299253,58.264024) 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 279.0 52.37 47.69 178 0.294 0 0 0.0 0.0 L2 1/0 62.99 MB 0.6 0.0 0.0 0.0 0.0 0.0 14.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L3 9/0 755.91 MB 0.8 0.0 0.0 0.0 0.0 0.0 14.2 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 120/0 9.54 GB 1.0 0.0 0.0 0.0 0.0 0.0 13.5 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 48/0 3.94 GB 0.0 0.0 0.0 0.0 0.0 0.0 3.9 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 178/0 14.27 GB 0.0 0.0 0.0 0.0 14.3 14.3 45.9 1.0 0.0 279.0 52.37 47.69 178 0.294 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 13.5 13.5 44.5 1.0 0.0 277.8 49.89 45.46 168 0.297 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 279.0 52.37 47.69 178 0.294 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): 58.3 total, 55.3 interval Flush(GB): cumulative 14.272, interval 13.534 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, 250.71 MB/s write, 0.00 GB read, 0.00 MB/s read, 52.4 seconds Interval compaction: 13.53 GB write, 250.77 MB/s write, 0.00 GB read, 0.00 MB/s read, 49.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: 92, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 92, interval: 88 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 890 Average: 643.7022 StdDev: 1188.07 Min: 1 Median: 3.9740 Max: 4996 Percentiles: P50: 3.97 P75: 502.64 P99: 4347.30 P99.9: 4996.00 P99.99: 4996.00 ------------------------------------------------------ [ 0, 1 ] 169 18.989% 18.989% #### ( 1, 2 ] 121 13.596% 32.584% ### ( 2, 3 ] 80 8.989% 41.573% ## ( 3, 4 ] 77 8.652% 50.225% ## ( 4, 6 ] 45 5.056% 55.281% # ( 6, 10 ] 40 4.494% 59.775% # ( 10, 15 ] 1 0.112% 59.888% ( 15, 22 ] 1 0.112% 60.000% ( 250, 380 ] 101 11.348% 71.348% ## ( 380, 580 ] 53 5.955% 77.303% # ( 580, 870 ] 2 0.225% 77.528% ( 870, 1300 ] 63 7.079% 84.607% # ( 1300, 1900 ] 18 2.022% 86.629% ( 1900, 2900 ] 3 0.337% 86.966% ( 2900, 4400 ] 111 12.472% 99.438% ## ( 4400, 6600 ] 5 0.562% 100.000% ** DB Stats ** Uptime(secs): 58.3 total, 3.3 interval Cumulative writes: 0 writes, 15M keys, 0 commit groups, 0.0 writes per commit group, ingest: 14.42 GB, 253.26 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.544 H:M:S, 35.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 298.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.786 H:M:S, 23.8 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/07/25-11:01:44 ... thread 0: (1000000,16000000) ops and (314998.2,260422.4) ops/second in (3.174621,61.438645) 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 282.4 55.32 50.34 191 0.290 0 0 0.0 0.0 L3 11/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 120/0 9.54 GB 1.0 0.0 0.0 0.0 0.0 0.0 14.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 60/0 4.86 GB 0.0 0.0 0.0 0.0 0.0 0.0 4.9 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 191/0 15.26 GB 0.0 0.0 0.0 0.0 15.3 15.3 34.5 1.0 0.0 282.4 55.32 50.34 191 0.290 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 14.5 14.5 33.1 1.0 0.0 281.4 52.83 48.10 181 0.292 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 282.4 55.32 50.34 191 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): 61.5 total, 58.4 interval Flush(GB): cumulative 15.256, interval 14.518 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 15.26 GB write, 254.16 MB/s write, 0.00 GB read, 0.00 MB/s read, 55.3 seconds Interval compaction: 14.52 GB write, 254.39 MB/s write, 0.00 GB read, 0.00 MB/s read, 52.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: 96, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 96, interval: 92 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 955 Average: 635.7204 StdDev: 1177.40 Min: 1 Median: 3.9107 Max: 4996 Percentiles: P50: 3.91 P75: 495.18 P99: 4342.16 P99.9: 4996.00 P99.99: 4996.00 ------------------------------------------------------ [ 0, 1 ] 187 19.581% 19.581% #### ( 1, 2 ] 129 13.508% 33.089% ### ( 2, 3 ] 85 8.901% 41.990% ## ( 3, 4 ] 84 8.796% 50.785% ## ( 4, 6 ] 46 4.817% 55.602% # ( 6, 10 ] 40 4.188% 59.791% # ( 10, 15 ] 1 0.105% 59.895% ( 15, 22 ] 1 0.105% 60.000% ( 250, 380 ] 111 11.623% 71.623% ## ( 380, 580 ] 56 5.864% 77.487% # ( 580, 870 ] 3 0.314% 77.801% ( 870, 1300 ] 66 6.911% 84.712% # ( 1300, 1900 ] 20 2.094% 86.806% ( 1900, 2900 ] 3 0.314% 87.120% ( 2900, 4400 ] 118 12.356% 99.476% ## ( 4400, 6600 ] 5 0.524% 100.000% ** DB Stats ** Uptime(secs): 61.5 total, 3.2 interval Cumulative writes: 0 writes, 16M keys, 0 commit groups, 0.0 writes per commit group, ingest: 15.38 GB, 256.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:21.243 H:M:S, 34.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 310.02 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.700 H:M:S, 22.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/07/25-11:01:48 ... thread 0: (1000000,17000000) ops and (310422.3,262913.4) ops/second in (3.221418,64.660063) 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 285.1 58.12 52.85 203 0.286 0 0 0.0 0.0 L3 11/0 881.90 MB 0.9 0.0 0.0 0.0 0.0 0.0 16.2 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 120/0 9.54 GB 1.0 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 L5 72/0 5.78 GB 0.1 0.0 0.0 0.0 0.0 0.0 5.8 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 203/0 16.18 GB 0.0 0.0 0.0 0.0 16.2 16.2 37.3 1.0 0.0 285.1 58.12 52.85 203 0.286 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 15.4 15.4 35.9 1.0 0.0 284.2 55.63 50.62 193 0.288 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 285.1 58.12 52.85 203 0.286 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): 64.7 total, 61.7 interval Flush(GB): cumulative 16.179, interval 15.441 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, 256.11 MB/s write, 0.00 GB read, 0.00 MB/s read, 58.1 seconds Interval compaction: 15.44 GB write, 256.43 MB/s write, 0.00 GB read, 0.00 MB/s read, 55.6 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 101, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 101, interval: 97 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1015 Average: 636.0049 StdDev: 1178.15 Min: 1 Median: 3.8750 Max: 4996 Percentiles: P50: 3.88 P75: 489.32 P99: 4339.17 P99.9: 4996.00 P99.99: 4996.00 ------------------------------------------------------ [ 0, 1 ] 203 20.000% 20.000% #### ( 1, 2 ] 137 13.498% 33.498% ### ( 2, 3 ] 87 8.571% 42.069% ## ( 3, 4 ] 92 9.064% 51.133% ## ( 4, 6 ] 48 4.729% 55.862% # ( 6, 10 ] 40 3.941% 59.803% # ( 10, 15 ] 1 0.099% 59.901% ( 15, 22 ] 1 0.099% 60.000% ( 250, 380 ] 120 11.823% 71.823% ## ( 380, 580 ] 59 5.813% 77.635% # ( 580, 870 ] 3 0.296% 77.931% ( 870, 1300 ] 67 6.601% 84.532% # ( 1300, 1900 ] 22 2.167% 86.700% ( 1900, 2900 ] 3 0.296% 86.995% ( 2900, 4400 ] 127 12.512% 99.507% ### ( 4400, 6600 ] 5 0.493% 100.000% ** DB Stats ** Uptime(secs): 64.7 total, 3.2 interval Cumulative writes: 0 writes, 17M keys, 0 commit groups, 0.0 writes per commit group, ingest: 16.34 GB, 258.65 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:21.999 H:M:S, 34.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 305.51 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.756 H:M:S, 23.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/07/25-11:01:51 ... thread 0: (1000000,18000000) ops and (309851.4,265144.9) ops/second in (3.227353,67.887416) 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 287.6 61.11 55.52 216 0.283 0 0 0.0 0.0 L2 1/0 62.99 MB 0.6 0.0 0.0 0.0 0.0 0.0 17.2 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L3 11/0 881.89 MB 0.9 0.0 0.0 0.0 0.0 0.0 17.1 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 120/0 9.60 GB 1.0 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 L5 84/0 6.64 GB 0.1 0.0 0.0 0.0 0.0 0.0 6.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 216/0 17.16 GB 0.0 0.0 0.0 0.0 17.2 17.2 57.1 1.0 0.0 287.6 61.11 55.52 216 0.283 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 16.4 16.4 55.7 1.0 0.0 286.9 58.62 53.28 206 0.285 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 287.6 61.11 55.52 216 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): 67.9 total, 64.9 interval Flush(GB): cumulative 17.163, interval 16.425 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 17.16 GB write, 258.78 MB/s write, 0.00 GB read, 0.00 MB/s read, 61.1 seconds Interval compaction: 16.42 GB write, 259.21 MB/s write, 0.00 GB read, 0.00 MB/s read, 58.6 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 107, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 107, interval: 103 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1080 Average: 633.5417 StdDev: 1175.82 Min: 1 Median: 3.8365 Max: 4996 Percentiles: P50: 3.84 P75: 483.23 P99: 4335.56 P99.9: 4996.00 P99.99: 4996.00 ------------------------------------------------------ [ 0, 1 ] 219 20.278% 20.278% #### ( 1, 2 ] 147 13.611% 33.889% ### ( 2, 3 ] 87 8.056% 41.944% ## ( 3, 4 ] 104 9.630% 51.574% ## ( 4, 6 ] 49 4.537% 56.111% # ( 6, 10 ] 40 3.704% 59.815% # ( 10, 15 ] 1 0.093% 59.907% ( 15, 22 ] 1 0.093% 60.000% ( 250, 380 ] 130 12.037% 72.037% ## ( 380, 580 ] 62 5.741% 77.778% # ( 580, 870 ] 3 0.278% 78.056% ( 870, 1300 ] 71 6.574% 84.630% # ( 1300, 1900 ] 23 2.130% 86.759% ( 1900, 2900 ] 3 0.278% 87.037% ( 2900, 4400 ] 135 12.500% 99.537% ### ( 4400, 6600 ] 5 0.463% 100.000% ** DB Stats ** Uptime(secs): 67.9 total, 3.2 interval Cumulative writes: 0 writes, 18M keys, 0 commit groups, 0.0 writes per commit group, ingest: 17.30 GB, 260.85 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.747 H:M:S, 33.5 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 304.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:0.748 H:M:S, 23.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/07/25-11:01:54 ... thread 0: (1000000,19000000) ops and (311607.6,267242.1) ops/second in (3.209164,71.096580) 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 289.9 63.89 58.01 228 0.280 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 11/0 881.92 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 120/0 9.41 GB 1.0 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 L5 96/0 7.75 GB 0.1 0.0 0.0 0.0 0.0 0.0 7.8 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 228/0 18.09 GB 0.0 0.0 0.0 0.0 18.1 18.1 61.0 1.0 0.0 289.9 63.89 58.01 228 0.280 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 17.3 17.3 59.6 1.0 0.0 289.3 61.41 55.78 218 0.282 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 289.9 63.89 58.01 228 0.280 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 71.1 total, 68.1 interval Flush(GB): cumulative 18.086, interval 17.348 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, 260.39 MB/s write, 0.00 GB read, 0.00 MB/s read, 63.9 seconds Interval compaction: 17.35 GB write, 260.87 MB/s write, 0.00 GB read, 0.00 MB/s read, 61.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: 112, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 112, interval: 108 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1140 Average: 632.6482 StdDev: 1174.94 Min: 1 Median: 3.7909 Max: 4996 Percentiles: P50: 3.79 P75: 478.46 P99: 4332.87 P99.9: 4996.00 P99.99: 4996.00 ------------------------------------------------------ [ 0, 1 ] 232 20.351% 20.351% #### ( 1, 2 ] 158 13.860% 34.211% ### ( 2, 3 ] 93 8.158% 42.368% ## ( 3, 4 ] 110 9.649% 52.018% ## ( 4, 6 ] 49 4.298% 56.316% # ( 6, 10 ] 40 3.509% 59.825% # ( 10, 15 ] 1 0.088% 59.912% ( 15, 22 ] 1 0.088% 60.000% ( 250, 380 ] 139 12.193% 72.193% ## ( 380, 580 ] 65 5.702% 77.895% # ( 580, 870 ] 3 0.263% 78.158% ( 870, 1300 ] 73 6.404% 84.561% # ( 1300, 1900 ] 24 2.105% 86.667% ( 1900, 2900 ] 4 0.351% 87.018% ( 2900, 4400 ] 143 12.544% 99.561% ### ( 4400, 6600 ] 5 0.439% 100.000% ** DB Stats ** Uptime(secs): 71.1 total, 3.2 interval Cumulative writes: 0 writes, 19M keys, 0 commit groups, 0.0 writes per commit group, ingest: 18.26 GB, 262.92 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:23.476 H:M:S, 33.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 306.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.729 H:M:S, 22.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/07/25-11:01:58 ... thread 0: (1000000,20000000) ops and (282071.1,267946.4) ops/second in (3.545206,74.641786) 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 291.8 67.15 60.93 241 0.279 0 0 0.0 0.0 L3 9/0 755.92 MB 0.8 0.0 0.0 0.0 0.0 0.0 19.1 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 124/0 9.54 GB 1.0 0.0 0.0 0.0 0.0 0.0 18.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 108/0 8.86 GB 0.1 0.0 0.0 0.0 0.0 0.0 8.9 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 241/0 19.13 GB 0.0 0.0 0.0 0.0 19.1 19.1 46.4 1.0 0.0 291.8 67.15 60.93 241 0.279 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 18.4 18.4 45.0 1.0 0.0 291.3 64.66 58.69 231 0.280 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 291.8 67.15 60.93 241 0.279 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): 74.7 total, 71.6 interval Flush(GB): cumulative 19.132, interval 18.394 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 19.13 GB write, 262.37 MB/s write, 0.00 GB read, 0.00 MB/s read, 67.1 seconds Interval compaction: 18.39 GB write, 262.91 MB/s write, 0.00 GB read, 0.00 MB/s read, 64.7 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 118, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 118, interval: 114 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1205 Average: 635.2149 StdDev: 1180.95 Min: 1 Median: 3.7542 Max: 4996 Percentiles: P50: 3.75 P75: 474.93 P99: 4339.90 P99.9: 4996.00 P99.99: 4996.00 ------------------------------------------------------ [ 0, 1 ] 247 20.498% 20.498% #### ( 1, 2 ] 169 14.025% 34.523% ### ( 2, 3 ] 96 7.967% 42.490% ## ( 3, 4 ] 120 9.959% 52.448% ## ( 4, 6 ] 49 4.066% 56.515% # ( 6, 10 ] 40 3.320% 59.834% # ( 10, 15 ] 1 0.083% 59.917% ( 15, 22 ] 1 0.083% 60.000% ( 250, 380 ] 148 12.282% 72.282% ## ( 380, 580 ] 69 5.726% 78.008% # ( 580, 870 ] 3 0.249% 78.257% ( 870, 1300 ] 74 6.141% 84.398% # ( 1300, 1900 ] 26 2.158% 86.556% ( 1900, 2900 ] 5 0.415% 86.971% ( 2900, 4400 ] 151 12.531% 99.502% ### ( 4400, 6600 ] 6 0.498% 100.000% ** DB Stats ** Uptime(secs): 74.7 total, 3.5 interval Cumulative writes: 0 writes, 20M keys, 0 commit groups, 0.0 writes per commit group, ingest: 19.22 GB, 263.61 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.533 H:M:S, 32.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 277.62 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.057 H:M:S, 29.8 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.732 micros/op 267943 ops/sec 74.643 seconds 20000000 operations; 259.6 MB/s Microseconds per write: Count: 20000000 Average: 3.7321 StdDev: 658.05 Min: 1 Median: 1.1905 Max: 683316 Percentiles: P50: 1.19 P75: 3.04 P99: 8.75 P99.9: 111.62 P99.99: 241.10 ------------------------------------------------------ [ 0, 1 ] 8947371 44.737% 44.737% ######### ( 1, 2 ] 5526326 27.632% 72.368% ###### ( 2, 3 ] 405893 2.029% 74.398% ( 3, 4 ] 2825336 14.127% 88.525% ### ( 4, 6 ] 1904906 9.525% 98.049% ## ( 6, 10 ] 277059 1.385% 99.434% ( 10, 15 ] 62440 0.312% 99.747% ( 15, 22 ] 22430 0.112% 99.859% ( 22, 34 ] 6144 0.031% 99.890% ( 34, 51 ] 1208 0.006% 99.896% ( 51, 76 ] 501 0.003% 99.898% ( 76, 110 ] 46 0.000% 99.898% ( 110, 170 ] 12620 0.063% 99.961% ( 170, 250 ] 6436 0.032% 99.994% ( 250, 380 ] 775 0.004% 99.997% ( 380, 580 ] 319 0.002% 99.999% ( 580, 870 ] 53 0.000% 99.999% ( 870, 1300 ] 7 0.000% 99.999% ( 1300, 1900 ] 4 0.000% 99.999% ( 1900, 2900 ] 3 0.000% 99.999% ( 2900, 4400 ] 2 0.000% 99.999% ( 4400, 6600 ] 2 0.000% 99.999% ( 6600, 9900 ] 10 0.000% 99.999% ( 9900, 14000 ] 4 0.000% 99.999% ( 14000, 22000 ] 4 0.000% 99.999% ( 22000, 33000 ] 9 0.000% 100.000% ( 50000, 75000 ] 20 0.000% 100.000% ( 75000, 110000 ] 1 0.000% 100.000% ( 110000, 170000 ] 1 0.000% 100.000% ( 170000, 250000 ] 39 0.000% 100.000% ( 250000, 380000 ] 10 0.000% 100.000% ( 380000, 570000 ] 20 0.000% 100.000% ( 570000, 860000 ] 1 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 : 241 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 24533234 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 : 20542582045 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 : 20378182656 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 : 124500240 rocksdb.non.last.level.read.count COUNT : 1205 rocksdb.block.checksum.compute.count COUNT : 723 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.688040 P95 : 4.491886 P99 : 7.253443 P100 : 683313.000000 COUNT : 20000000 SUM : 63615992 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 : 541.744966 P95 : 837.616667 P99 : 868.678889 P100 : 931.000000 COUNT : 241 SUM : 142154 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 : 107.870707 P95 : 245.851852 P99 : 2231.428571 P100 : 2744.000000 COUNT : 936 SUM : 154448 rocksdb.table.open.io.micros P50 : 3472.834646 P95 : 6047.250000 P99 : 6577.450000 P100 : 6853.000000 COUNT : 241 SUM : 855522 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 : 1067.800000 P95 : 4237.919463 P99 : 5111.000000 P100 : 5111.000000 COUNT : 482 SUM : 807133 rocksdb.write.raw.block.micros P50 : 0.607281 P95 : 1.874570 P99 : 3.887972 P100 : 3663.000000 COUNT : 4982993 SUM : 14246582 rocksdb.numfiles.in.singlecompaction P50 : 1.000000 P95 : 3.593529 P99 : 3.918706 P100 : 4.000000 COUNT : 691 SUM : 1063 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 : 192564.102564 P95 : 523450.000000 P99 : 568290.000000 P100 : 683098.000000 COUNT : 118 SUM : 24533234 rocksdb.sst.read.micros P50 : 3.754167 P95 : 3861.092715 P99 : 4339.900662 P100 : 4996.000000 COUNT : 1205 SUM : 765434 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 : 235135.135135 P95 : 685275.000000 P99 : 817519.000000 P100 : 817519.000000 COUNT : 241 SUM : 67148623 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