[2024-11-20 15:20:34.289660] Starting SPDK v25.01-pre git sha1 32c3f377c / DPDK 24.03.0 initialization... [2024-11-20 15:20:34.289799] [ 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_pid4092014 ] Set seed to 1732112434286863 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-11-20 15:20:34.460117] app.c: 919:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-11-20 15:20:34.612277] app.c: 612:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-11-20 15:20:34.612343] app.c: 613:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 4092014' to capture a snapshot of events at runtime. [2024-11-20 15:20:34.612363] app.c: 618:app_setup_trace: *NOTICE*: 'spdk_trace' without parameters will also work if this is the only [2024-11-20 15:20:34.612384] app.c: 619:app_setup_trace: *NOTICE*: SPDK application currently running. [2024-11-20 15:20:34.612399] app.c: 620:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid4092014 for offline analysis/debug. [2024-11-20 15:20:34.614225] reactor.c:1005:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Wed Nov 20 15:20:41 2024 CPU: 72 * Intel(R) Xeon(R) Gold 6140 CPU @ 2.30GHz CPUCache: 25344 KB 2024/11/20-15:20:43 ... thread 0: (1000000,1000000) ops and (393451.1,393451.1) ops/second in (2.541612,2.541612) 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 377.2 2.17 1.95 10 0.217 0 0 0.0 0.0 L3 10/0 818.89 MB 0.8 0.0 0.0 0.0 0.0 0.0 0.8 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 10/0 818.89 MB 0.0 0.0 0.0 0.0 0.8 0.8 0.8 1.0 0.0 377.2 2.17 1.95 10 0.217 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 0.8 0.8 0.8 1.0 0.0 377.2 2.17 1.95 10 0.217 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 377.2 2.17 1.95 10 0.217 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 2.6 total, 2.6 interval Flush(GB): cumulative 0.800, interval 0.800 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 0.80 GB write, 319.94 MB/s write, 0.00 GB read, 0.00 MB/s read, 2.2 seconds Interval compaction: 0.80 GB write, 319.94 MB/s write, 0.00 GB read, 0.00 MB/s read, 2.2 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 7, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 7, interval: 7 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 50 Average: 518.8400 StdDev: 998.16 Min: 0 Median: 4.5714 Max: 4167 Percentiles: P50: 4.57 P75: 413.33 P99: 4167.00 P99.9: 4167.00 P99.99: 4167.00 ------------------------------------------------------ [ 0, 1 ] 17 34.000% 34.000% ####### ( 1, 2 ] 3 6.000% 40.000% # ( 3, 4 ] 3 6.000% 46.000% # ( 4, 6 ] 7 14.000% 60.000% ### ( 170, 250 ] 7 14.000% 74.000% ### ( 380, 580 ] 3 6.000% 80.000% # ( 1300, 1900 ] 5 10.000% 90.000% ## ( 1900, 2900 ] 1 2.000% 92.000% ( 2900, 4400 ] 4 8.000% 100.000% ## ** DB Stats ** Uptime(secs): 2.6 total, 2.6 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 384.51 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.812 H:M:S, 31.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 384.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.812 H:M:S, 31.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/11/20-15:20:46 ... thread 0: (1000000,2000000) ops and (375315.8,384169.5) ops/second in (2.664423,5.206035) 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 394.9 4.63 4.10 22 0.210 0 0 0.0 0.0 L3 10/0 818.91 MB 0.8 0.0 0.0 0.0 0.0 0.0 1.8 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 12/0 1007.89 MB 0.1 0.0 0.0 0.0 0.0 0.0 1.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 22/0 1.78 GB 0.0 0.0 0.0 0.0 1.8 1.8 2.8 1.0 0.0 394.9 4.63 4.10 22 0.210 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 0.8 0.8 0.9 1.0 0.0 412.4 1.99 1.75 10 0.199 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 394.9 4.63 4.10 22 0.210 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 5.2 total, 2.2 interval Flush(GB): cumulative 1.784, interval 0.800 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 1.78 GB write, 349.70 MB/s write, 0.00 GB read, 0.00 MB/s read, 4.6 seconds Interval compaction: 0.80 GB write, 371.39 MB/s write, 0.00 GB read, 0.00 MB/s read, 2.0 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 15, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 15, interval: 7 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 110 Average: 589.9000 StdDev: 1129.07 Min: 0 Median: 4.0000 Max: 4167 Percentiles: P50: 4.00 P75: 422.86 P99: 4167.00 P99.9: 4167.00 P99.99: 4167.00 ------------------------------------------------------ [ 0, 1 ] 39 35.455% 35.455% ####### ( 1, 2 ] 4 3.636% 39.091% # ( 3, 4 ] 12 10.909% 50.000% ## ( 4, 6 ] 11 10.000% 60.000% ## ( 170, 250 ] 15 13.636% 73.636% ### ( 380, 580 ] 7 6.364% 80.000% # ( 870, 1300 ] 1 0.909% 80.909% ( 1300, 1900 ] 6 5.455% 86.364% # ( 1900, 2900 ] 4 3.636% 90.000% # ( 2900, 4400 ] 11 10.000% 100.000% ## ** DB Stats ** Uptime(secs): 5.2 total, 2.2 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 376.80 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.752 H:M:S, 33.5 percent Interval writes: 0 writes, 857K keys, 0 commit groups, 0.0 writes per commit group, ingest: 843.93 MB, 382.49 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.730 H:M:S, 33.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/11/20-15:20:48 ... thread 0: (1000000,3000000) ops and (379895.2,382734.1) ops/second in (2.632305,7.838340) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 0/0 0.00 KB 0.0 0.0 0.0 0.0 2.7 2.7 0.0 1.0 0.0 400.5 6.92 6.12 33 0.210 0 0 0.0 0.0 L2 1/0 62.99 MB 0.6 0.0 0.0 0.0 0.0 0.0 2.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L3 8/0 692.93 MB 0.7 0.0 0.0 0.0 0.0 0.0 2.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 24/0 1.97 GB 0.2 0.0 0.0 0.0 0.0 0.0 2.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 33/0 2.71 GB 0.0 0.0 0.0 0.0 2.7 2.7 7.3 1.0 0.0 400.5 6.92 6.12 33 0.210 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 1.7 1.7 5.4 1.0 0.0 412.1 4.28 3.77 21 0.204 0 0 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- High 0/0 0.00 KB 0.0 0.0 0.0 0.0 2.7 2.7 0.0 0.0 0.0 400.5 6.92 6.12 33 0.210 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 7.9 total, 4.8 interval Flush(GB): cumulative 2.707, interval 1.722 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 2.71 GB write, 352.80 MB/s write, 0.00 GB read, 0.00 MB/s read, 6.9 seconds Interval compaction: 1.72 GB write, 364.63 MB/s write, 0.00 GB read, 0.00 MB/s read, 4.3 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 22, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 22, interval: 14 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 165 Average: 593.4242 StdDev: 1139.67 Min: 0 Median: 4.1765 Max: 4376 Percentiles: P50: 4.18 P75: 430.00 P99: 4262.50 P99.9: 4376.00 P99.99: 4376.00 ------------------------------------------------------ [ 0, 1 ] 58 35.152% 35.152% ####### ( 1, 2 ] 7 4.242% 39.394% # ( 3, 4 ] 16 9.697% 49.091% ## ( 4, 6 ] 17 10.303% 59.394% ## ( 6, 10 ] 1 0.606% 60.000% ( 170, 250 ] 22 13.333% 73.333% ### ( 380, 580 ] 11 6.667% 80.000% # ( 580, 870 ] 1 0.606% 80.606% ( 870, 1300 ] 2 1.212% 81.818% ( 1300, 1900 ] 7 4.242% 86.061% # ( 1900, 2900 ] 5 3.030% 89.091% # ( 2900, 4400 ] 18 10.909% 100.000% ## ** DB Stats ** Uptime(secs): 7.9 total, 2.6 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 375.82 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:2.665 H:M:S, 33.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 373.88 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.913 H:M:S, 34.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/11/20-15:20:51 ... thread 0: (1000000,4000000) ops and (371803.9,379941.7) ops/second in (2.689590,10.527930) 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 403.2 9.38 8.27 45 0.208 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.93 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 403.2 9.38 8.27 45 0.208 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 2.7 2.7 8.4 1.0 0.0 411.6 6.73 5.92 33 0.204 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 403.2 9.38 8.27 45 0.208 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): 10.5 total, 7.5 interval Flush(GB): cumulative 3.691, interval 2.707 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, 358.40 MB/s write, 0.00 GB read, 0.00 MB/s read, 9.4 seconds Interval compaction: 2.71 GB write, 368.24 MB/s write, 0.00 GB read, 0.00 MB/s read, 6.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: 30, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 30, interval: 22 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 225 Average: 612.3378 StdDev: 1174.57 Min: 0 Median: 4.4231 Max: 4482 Percentiles: P50: 4.42 P75: 430.00 P99: 4327.88 P99.9: 4482.00 P99.99: 4482.00 ------------------------------------------------------ [ 0, 1 ] 77 34.222% 34.222% ####### ( 1, 2 ] 10 4.444% 38.667% # ( 3, 4 ] 20 8.889% 47.556% ## ( 4, 6 ] 26 11.556% 59.111% ## ( 6, 10 ] 2 0.889% 60.000% ( 170, 250 ] 30 13.333% 73.333% ### ( 380, 580 ] 15 6.667% 80.000% # ( 580, 870 ] 1 0.444% 80.444% ( 870, 1300 ] 3 1.333% 81.778% ( 1300, 1900 ] 9 4.000% 85.778% # ( 1900, 2900 ] 5 2.222% 88.000% ( 2900, 4400 ] 26 11.556% 99.556% ## ( 4400, 6600 ] 1 0.444% 100.000% ** DB Stats ** Uptime(secs): 10.5 total, 2.7 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 373.30 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:3.634 H:M:S, 34.5 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 365.93 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.969 H:M:S, 36.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/11/20-15:20:54 ... thread 0: (1000000,5000000) ops and (364298.7,376706.6) ops/second in (2.745000,13.272930) 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 402.7 11.89 10.48 57 0.209 0 0 0.0 0.0 L2 1/0 62.99 MB 0.6 0.0 0.0 0.0 0.0 0.0 4.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L3 8/0 692.92 MB 0.7 0.0 0.0 0.0 0.0 0.0 4.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 48/0 3.94 GB 0.4 0.0 0.0 0.0 0.0 0.0 3.9 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 57/0 4.68 GB 0.0 0.0 0.0 0.0 4.7 4.7 13.2 1.0 0.0 402.7 11.89 10.48 57 0.209 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 3.7 3.7 11.3 1.0 0.0 408.7 9.25 8.13 45 0.205 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 402.7 11.89 10.48 57 0.209 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): 13.3 total, 10.3 interval Flush(GB): cumulative 4.675, interval 3.691 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, 360.21 MB/s write, 0.00 GB read, 0.00 MB/s read, 11.9 seconds Interval compaction: 3.69 GB write, 367.95 MB/s write, 0.00 GB read, 0.00 MB/s read, 9.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: 38, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 38, interval: 30 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 285 Average: 601.5088 StdDev: 1156.84 Min: 0 Median: 4.3939 Max: 4482 Percentiles: P50: 4.39 P75: 430.00 P99: 4315.91 P99.9: 4482.00 P99.99: 4482.00 ------------------------------------------------------ [ 0, 1 ] 100 35.088% 35.088% ####### ( 1, 2 ] 11 3.860% 38.947% # ( 3, 4 ] 25 8.772% 47.719% ## ( 4, 6 ] 33 11.579% 59.298% ## ( 6, 10 ] 2 0.702% 60.000% ( 170, 250 ] 38 13.333% 73.333% ### ( 380, 580 ] 19 6.667% 80.000% # ( 580, 870 ] 2 0.702% 80.702% ( 870, 1300 ] 5 1.754% 82.456% ( 1300, 1900 ] 10 3.509% 85.965% # ( 1900, 2900 ] 6 2.105% 88.070% ( 2900, 4400 ] 33 11.579% 99.649% ## ( 4400, 6600 ] 1 0.351% 100.000% ** DB Stats ** Uptime(secs): 13.3 total, 2.7 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 370.25 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:4.669 H:M:S, 35.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 358.54 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:1.035 H:M:S, 37.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/11/20-15:20:57 ... thread 0: (1000000,6000000) ops and (362514.5,374264.6) ops/second in (2.758510,16.031440) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 0/0 0.00 KB 0.0 0.0 0.0 0.0 5.7 5.7 0.0 1.0 0.0 402.4 14.40 12.70 69 0.209 0 0 0.0 0.0 L1 1/1 63.00 MB 0.0 0.0 0.0 0.0 0.0 0.0 5.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L3 8/0 692.95 MB 0.7 0.0 0.0 0.0 0.0 0.0 5.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 60/0 4.92 GB 0.5 0.0 0.0 0.0 0.0 0.0 4.9 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 69/1 5.66 GB 0.0 0.0 0.0 0.0 5.7 5.7 16.2 1.0 0.0 402.4 14.40 12.70 69 0.209 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 4.7 4.7 14.3 1.0 0.0 407.1 11.76 10.35 57 0.206 0 0 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- High 0/0 0.00 KB 0.0 0.0 0.0 0.0 5.7 5.7 0.0 0.0 0.0 402.4 14.40 12.70 69 0.209 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.0 total, 13.0 interval Flush(GB): cumulative 5.660, interval 4.675 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 5.66 GB write, 361.10 MB/s write, 0.00 GB read, 0.00 MB/s read, 14.4 seconds Interval compaction: 4.68 GB write, 367.41 MB/s write, 0.00 GB read, 0.00 MB/s read, 11.8 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 46, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 46, interval: 38 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 345 Average: 619.7014 StdDev: 1196.07 Min: 0 Median: 4.3421 Max: 6551 Percentiles: P50: 4.34 P75: 430.00 P99: 4346.95 P99.9: 6220.50 P99.99: 6551.00 ------------------------------------------------------ [ 0, 1 ] 123 35.652% 35.652% ####### ( 1, 2 ] 11 3.188% 38.841% # ( 3, 4 ] 32 9.275% 48.116% ## ( 4, 6 ] 38 11.014% 59.130% ## ( 6, 10 ] 2 0.580% 59.710% ( 10, 15 ] 1 0.290% 60.000% ( 170, 250 ] 45 13.043% 73.043% ### ( 250, 380 ] 1 0.290% 73.333% ( 380, 580 ] 23 6.667% 80.000% # ( 580, 870 ] 2 0.580% 80.580% ( 870, 1300 ] 5 1.449% 82.029% ( 1300, 1900 ] 10 2.899% 84.928% # ( 1900, 2900 ] 9 2.609% 87.536% # ( 2900, 4400 ] 41 11.884% 99.420% ## ( 4400, 6600 ] 2 0.580% 100.000% ** DB Stats ** Uptime(secs): 16.0 total, 2.8 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 367.93 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:5.713 H:M:S, 35.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 356.77 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:1.044 H:M:S, 37.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/11/20-15:20:59 ... thread 0: (1000000,7000000) ops and (372803.3,374055.1) ops/second in (2.682380,18.713820) 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 404.1 16.68 14.71 80 0.208 0 0 0.0 0.0 L3 8/0 692.93 MB 0.7 0.0 0.0 0.0 0.0 0.0 6.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 72/0 5.91 GB 0.6 0.0 0.0 0.0 0.0 0.0 5.9 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 80/0 6.58 GB 0.0 0.0 0.0 0.0 6.6 6.6 12.5 1.0 0.0 404.1 16.68 14.71 80 0.208 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 5.6 5.6 10.6 1.0 0.0 408.4 14.04 12.36 68 0.206 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 404.1 16.68 14.71 80 0.208 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): 18.7 total, 15.7 interval Flush(GB): cumulative 6.582, interval 5.598 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, 359.83 MB/s write, 0.00 GB read, 0.00 MB/s read, 16.7 seconds Interval compaction: 5.60 GB write, 364.82 MB/s write, 0.00 GB read, 0.00 MB/s read, 14.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: 54, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 54, interval: 46 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 400 Average: 603.9725 StdDev: 1176.25 Min: 0 Median: 4.1951 Max: 6551 Percentiles: P50: 4.20 P75: 431.85 P99: 4334.78 P99.9: 6160.00 P99.99: 6551.00 ------------------------------------------------------ [ 0, 1 ] 145 36.250% 36.250% ####### ( 1, 2 ] 11 2.750% 39.000% # ( 3, 4 ] 40 10.000% 49.000% ## ( 4, 6 ] 41 10.250% 59.250% ## ( 6, 10 ] 2 0.500% 59.750% ( 10, 15 ] 1 0.250% 60.000% ( 170, 250 ] 52 13.000% 73.000% ### ( 250, 380 ] 1 0.250% 73.250% ( 380, 580 ] 27 6.750% 80.000% # ( 580, 870 ] 2 0.500% 80.500% ( 870, 1300 ] 10 2.500% 83.000% # ( 1300, 1900 ] 11 2.750% 85.750% # ( 1900, 2900 ] 9 2.250% 88.000% ( 2900, 4400 ] 46 11.500% 99.500% ## ( 4400, 6600 ] 2 0.500% 100.000% ** DB Stats ** Uptime(secs): 18.7 total, 2.7 interval Cumulative writes: 0 writes, 7000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 6.73 GB, 367.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:6.690 H:M:S, 35.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 366.93 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.977 H:M:S, 36.4 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/11/20-15:21:02 ... thread 0: (1000000,8000000) ops and (363464.8,372697.7) ops/second in (2.751298,21.465118) 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 403.7 19.19 16.91 92 0.209 0 0 0.0 0.0 L3 8/0 692.93 MB 0.7 0.0 0.0 0.0 0.0 0.0 7.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 84/0 6.89 GB 0.7 0.0 0.0 0.0 0.0 0.0 6.9 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 92/0 7.57 GB 0.0 0.0 0.0 0.0 7.6 7.6 14.5 1.0 0.0 403.7 19.19 16.91 92 0.209 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 6.6 6.6 12.5 1.0 0.0 407.3 16.55 14.56 80 0.207 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 403.7 19.19 16.91 92 0.209 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): 21.5 total, 18.5 interval Flush(GB): cumulative 7.567, interval 6.582 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, 360.67 MB/s write, 0.00 GB read, 0.00 MB/s read, 19.2 seconds Interval compaction: 6.58 GB write, 365.05 MB/s write, 0.00 GB read, 0.00 MB/s read, 16.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: 62, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 62, interval: 54 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 460 Average: 606.0957 StdDev: 1189.73 Min: 0 Median: 4.2128 Max: 6551 Percentiles: P50: 4.21 P75: 431.61 P99: 4576.00 P99.9: 6397.60 P99.99: 6551.00 ------------------------------------------------------ [ 0, 1 ] 167 36.304% 36.304% ####### ( 1, 2 ] 13 2.826% 39.130% # ( 3, 4 ] 45 9.783% 48.913% ## ( 4, 6 ] 47 10.217% 59.130% ## ( 6, 10 ] 3 0.652% 59.783% ( 10, 15 ] 1 0.217% 60.000% ( 170, 250 ] 60 13.043% 73.043% ### ( 250, 380 ] 1 0.217% 73.261% ( 380, 580 ] 31 6.739% 80.000% # ( 580, 870 ] 4 0.870% 80.870% ( 870, 1300 ] 11 2.391% 83.261% ( 1300, 1900 ] 13 2.826% 86.087% # ( 1900, 2900 ] 9 1.957% 88.043% ( 2900, 4400 ] 50 10.870% 98.913% ## ( 4400, 6600 ] 5 1.087% 100.000% ** DB Stats ** Uptime(secs): 21.5 total, 2.8 interval Cumulative writes: 0 writes, 8000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 7.69 GB, 366.50 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:7.722 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, 357.72 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:1.031 H:M:S, 37.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/11/20-15:21:05 ... thread 0: (1000000,9000000) ops and (367529.8,372116.3) ops/second in (2.720868,24.185986) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 0/0 0.00 KB 0.0 0.0 0.0 0.0 8.6 8.6 0.0 1.0 0.0 403.9 21.68 19.10 104 0.208 0 0 0.0 0.0 L3 8/0 692.93 MB 0.7 0.0 0.0 0.0 0.0 0.0 8.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 96/0 7.87 GB 0.8 0.0 0.0 0.0 0.0 0.0 7.9 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 104/0 8.55 GB 0.0 0.0 0.0 0.0 8.6 8.6 16.4 1.0 0.0 403.9 21.68 19.10 104 0.208 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 7.6 7.6 14.5 1.0 0.0 407.0 19.04 16.74 92 0.207 0 0 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- High 0/0 0.00 KB 0.0 0.0 0.0 0.0 8.6 8.6 0.0 0.0 0.0 403.9 21.68 19.10 104 0.208 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): 24.2 total, 21.2 interval Flush(GB): cumulative 8.551, interval 7.567 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 8.55 GB write, 361.76 MB/s write, 0.00 GB read, 0.00 MB/s read, 21.7 seconds Interval compaction: 7.57 GB write, 365.74 MB/s write, 0.00 GB read, 0.00 MB/s read, 19.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: 70, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 70, interval: 62 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 520 Average: 612.7288 StdDev: 1200.85 Min: 0 Median: 4.0800 Max: 6551 Percentiles: P50: 4.08 P75: 435.56 P99: 4394.92 P99.9: 6371.20 P99.99: 6551.00 ------------------------------------------------------ [ 0, 1 ] 188 36.154% 36.154% ####### ( 1, 2 ] 15 2.885% 39.038% # ( 3, 4 ] 55 10.577% 49.615% ## ( 4, 6 ] 50 9.615% 59.231% ## ( 6, 10 ] 3 0.577% 59.808% ( 10, 15 ] 1 0.192% 60.000% ( 170, 250 ] 67 12.885% 72.885% ### ( 250, 380 ] 1 0.192% 73.077% ( 380, 580 ] 36 6.923% 80.000% # ( 580, 870 ] 4 0.769% 80.769% ( 870, 1300 ] 13 2.500% 83.269% # ( 1300, 1900 ] 14 2.692% 85.962% # ( 1900, 2900 ] 9 1.731% 87.692% ( 2900, 4400 ] 59 11.346% 99.038% ## ( 4400, 6600 ] 5 0.962% 100.000% ** DB Stats ** Uptime(secs): 24.2 total, 2.7 interval Cumulative writes: 0 writes, 9000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 8.65 GB, 365.96 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.710 H:M:S, 36.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 361.72 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.988 H:M:S, 36.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/11/20-15:21:08 ... thread 0: (1000000,10000000) ops and (356123.6,370452.7) ops/second in (2.808014,26.994000) 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 401.7 24.15 21.29 115 0.210 0 0 0.0 0.0 L3 11/0 944.89 MB 0.9 0.0 0.0 0.0 0.0 0.0 9.5 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 104/0 8.55 GB 0.9 0.0 0.0 0.0 0.0 0.0 8.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 115/0 9.47 GB 0.0 0.0 0.0 0.0 9.5 9.5 18.0 1.0 0.0 401.7 24.15 21.29 115 0.210 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 8.5 8.5 16.1 1.0 0.0 404.1 21.51 18.94 103 0.209 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 401.7 24.15 21.29 115 0.210 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 27.0 total, 24.0 interval Flush(GB): cumulative 9.474, interval 8.489 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, 359.14 MB/s write, 0.00 GB read, 0.00 MB/s read, 24.2 seconds Interval compaction: 8.49 GB write, 362.32 MB/s write, 0.00 GB read, 0.00 MB/s read, 21.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: 78, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 78, interval: 70 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 575 Average: 608.4904 StdDev: 1189.76 Min: 0 Median: 4.0545 Max: 6551 Percentiles: P50: 4.05 P75: 436.25 P99: 4382.69 P99.9: 6347.00 P99.99: 6551.00 ------------------------------------------------------ [ 0, 1 ] 209 36.348% 36.348% ####### ( 1, 2 ] 16 2.783% 39.130% # ( 3, 4 ] 61 10.609% 49.739% ## ( 4, 6 ] 55 9.565% 59.304% ## ( 6, 10 ] 3 0.522% 59.826% ( 10, 15 ] 1 0.174% 60.000% ( 170, 250 ] 74 12.870% 72.870% ### ( 250, 380 ] 1 0.174% 73.043% ( 380, 580 ] 40 6.957% 80.000% # ( 580, 870 ] 4 0.696% 80.696% ( 870, 1300 ] 14 2.435% 83.130% ( 1300, 1900 ] 17 2.957% 86.087% # ( 1900, 2900 ] 10 1.739% 87.826% ( 2900, 4400 ] 65 11.304% 99.130% ## ( 4400, 6600 ] 5 0.870% 100.000% ** DB Stats ** Uptime(secs): 27.0 total, 2.8 interval Cumulative writes: 0 writes, 10M keys, 0 commit groups, 0.0 writes per commit group, ingest: 9.61 GB, 364.35 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:9.758 H:M:S, 36.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 350.50 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.048 H:M:S, 37.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/11/20-15:21:10 ... thread 0: (1000000,11000000) ops and (367531.5,370185.2) ops/second in (2.720855,29.714855) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 0/0 0.00 KB 0.0 0.0 0.0 0.0 10.5 10.5 0.0 1.0 0.0 401.8 26.65 23.49 127 0.210 0 0 0.0 0.0 L3 11/0 944.88 MB 0.9 0.0 0.0 0.0 0.0 0.0 10.5 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 116/0 9.54 GB 1.0 0.0 0.0 0.0 0.0 0.0 9.5 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 127/0 10.46 GB 0.0 0.0 0.0 0.0 10.5 10.5 20.0 1.0 0.0 401.8 26.65 23.49 127 0.210 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 9.5 9.5 18.1 1.0 0.0 404.0 24.01 21.14 115 0.209 0 0 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- High 0/0 0.00 KB 0.0 0.0 0.0 0.0 10.5 10.5 0.0 0.0 0.0 401.8 26.65 23.49 127 0.210 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): 29.7 total, 26.7 interval Flush(GB): cumulative 10.458, interval 9.474 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 10.46 GB write, 360.17 MB/s write, 0.00 GB read, 0.00 MB/s read, 26.7 seconds Interval compaction: 9.47 GB write, 363.14 MB/s write, 0.00 GB read, 0.00 MB/s read, 24.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: 86, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 86, interval: 78 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 635 Average: 610.5307 StdDev: 1191.13 Min: 0 Median: 3.9928 Max: 6551 Percentiles: P50: 3.99 P75: 435.68 P99: 4372.26 P99.9: 6320.60 P99.99: 6551.00 ------------------------------------------------------ [ 0, 1 ] 231 36.378% 36.378% ####### ( 1, 2 ] 18 2.835% 39.213% # ( 3, 4 ] 69 10.866% 50.079% ## ( 4, 6 ] 59 9.291% 59.370% ## ( 6, 10 ] 3 0.472% 59.843% ( 10, 15 ] 1 0.157% 60.000% ( 170, 250 ] 82 12.913% 72.913% ### ( 250, 380 ] 1 0.157% 73.071% ( 380, 580 ] 44 6.929% 80.000% # ( 580, 870 ] 6 0.945% 80.945% ( 870, 1300 ] 14 2.205% 83.150% ( 1300, 1900 ] 17 2.677% 85.827% # ( 1900, 2900 ] 12 1.890% 87.717% ( 2900, 4400 ] 73 11.496% 99.213% ## ( 4400, 6600 ] 5 0.787% 100.000% ** DB Stats ** Uptime(secs): 29.7 total, 2.7 interval Cumulative writes: 0 writes, 11M keys, 0 commit groups, 0.0 writes per commit group, ingest: 10.57 GB, 364.11 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:10.750 H:M:S, 36.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 361.73 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.992 H:M:S, 36.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/11/20-15:21:13 ... thread 0: (1000000,12000000) ops and (354650.7,368838.9) ops/second in (2.819676,32.534531) 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 400.8 29.23 25.78 139 0.210 0 0 0.0 0.0 L3 11/0 944.95 MB 0.9 0.0 0.0 0.0 0.0 0.0 11.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 116/0 9.54 GB 1.0 0.0 0.0 0.0 0.0 0.0 10.5 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 12/0 1007.89 MB 0.0 0.0 0.0 0.0 0.0 0.0 1.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 139/0 11.44 GB 0.0 0.0 0.0 0.0 11.4 11.4 22.9 1.0 0.0 400.8 29.23 25.78 139 0.210 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 10.5 10.5 21.0 1.0 0.0 402.7 26.59 23.43 127 0.209 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 400.8 29.23 25.78 139 0.210 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 32.6 total, 29.5 interval Flush(GB): cumulative 11.442, interval 10.458 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 11.44 GB write, 359.94 MB/s write, 0.00 GB read, 0.00 MB/s read, 29.2 seconds Interval compaction: 10.46 GB write, 362.60 MB/s write, 0.00 GB read, 0.00 MB/s read, 26.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: 94, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 94, interval: 86 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 695 Average: 615.2806 StdDev: 1199.25 Min: 0 Median: 3.9805 Max: 6551 Percentiles: P50: 3.98 P75: 438.16 P99: 4364.33 P99.9: 6294.20 P99.99: 6551.00 ------------------------------------------------------ [ 0, 1 ] 252 36.259% 36.259% ####### ( 1, 2 ] 20 2.878% 39.137% # ( 3, 4 ] 77 11.079% 50.216% ## ( 4, 6 ] 64 9.209% 59.424% ## ( 6, 10 ] 3 0.432% 59.856% ( 10, 15 ] 1 0.144% 60.000% ( 170, 250 ] 89 12.806% 72.806% ### ( 250, 380 ] 1 0.144% 72.950% ( 380, 580 ] 49 7.050% 80.000% # ( 580, 870 ] 6 0.863% 80.863% ( 870, 1300 ] 16 2.302% 83.165% ( 1300, 1900 ] 18 2.590% 85.755% # ( 1900, 2900 ] 12 1.727% 87.482% ( 2900, 4400 ] 82 11.799% 99.281% ## ( 4400, 6600 ] 5 0.719% 100.000% ** DB Stats ** Uptime(secs): 32.6 total, 2.8 interval Cumulative writes: 0 writes, 12M keys, 0 commit groups, 0.0 writes per commit group, ingest: 11.53 GB, 362.81 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.837 H:M:S, 36.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 349.04 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:1.087 H:M:S, 38.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/11/20-15:21:16 ... thread 0: (1000000,13000000) ops and (367254.4,368716.5) ops/second in (2.722908,35.257439) 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 401.4 31.70 27.96 151 0.210 0 0 0.0 0.0 L3 11/0 944.91 MB 0.9 0.0 0.0 0.0 0.0 0.0 12.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 116/0 9.54 GB 1.0 0.0 0.0 0.0 0.0 0.0 11.5 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 24/0 1.97 GB 0.0 0.0 0.0 0.0 0.0 0.0 2.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 151/0 12.43 GB 0.0 0.0 0.0 0.0 12.4 12.4 25.9 1.0 0.0 401.4 31.70 27.96 151 0.210 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 11.4 11.4 24.0 1.0 0.0 403.2 29.06 25.61 139 0.209 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 401.4 31.70 27.96 151 0.210 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 35.3 total, 32.3 interval Flush(GB): cumulative 12.426, interval 11.442 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, 360.72 MB/s write, 0.00 GB read, 0.00 MB/s read, 31.7 seconds Interval compaction: 11.44 GB write, 363.24 MB/s write, 0.00 GB read, 0.00 MB/s read, 29.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: 102, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 102, interval: 94 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 755 Average: 604.6887 StdDev: 1181.22 Min: 0 Median: 3.9819 Max: 6551 Percentiles: P50: 3.98 P75: 437.55 P99: 4356.03 P99.9: 6267.80 P99.99: 6551.00 ------------------------------------------------------ [ 0, 1 ] 275 36.424% 36.424% ####### ( 1, 2 ] 21 2.781% 39.205% # ( 3, 4 ] 83 10.993% 50.199% ## ( 4, 6 ] 70 9.272% 59.470% ## ( 6, 10 ] 3 0.397% 59.868% ( 10, 15 ] 1 0.132% 60.000% ( 170, 250 ] 97 12.848% 72.848% ### ( 250, 380 ] 1 0.132% 72.980% ( 380, 580 ] 53 7.020% 80.000% # ( 580, 870 ] 6 0.795% 80.795% ( 870, 1300 ] 20 2.649% 83.444% # ( 1300, 1900 ] 20 2.649% 86.093% # ( 1900, 2900 ] 13 1.722% 87.815% ( 2900, 4400 ] 87 11.523% 99.338% ## ( 4400, 6600 ] 5 0.662% 100.000% ** DB Stats ** Uptime(secs): 35.3 total, 2.7 interval Cumulative writes: 0 writes, 13M keys, 0 commit groups, 0.0 writes per commit group, ingest: 12.49 GB, 362.70 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:12.842 H:M:S, 36.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 361.43 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:1.005 H:M:S, 36.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/11/20-15:21:18 ... thread 0: (1000000,14000000) ops and (386060.3,369903.5) ops/second in (2.590269,37.847708) 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 400.9 33.94 29.95 162 0.210 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 116/0 9.54 GB 1.0 0.0 0.0 0.0 0.0 0.0 12.5 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 36/0 2.95 GB 0.0 0.0 0.0 0.0 0.0 0.0 3.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 162/0 13.29 GB 0.0 0.0 0.0 0.0 13.3 13.3 28.7 1.0 0.0 400.9 33.94 29.95 162 0.210 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 12.3 12.3 26.8 1.0 0.0 402.5 31.30 27.60 150 0.209 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 400.9 33.94 29.95 162 0.210 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.9 total, 34.8 interval Flush(GB): cumulative 13.288, interval 12.303 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 13.29 GB write, 359.34 MB/s write, 0.00 GB read, 0.00 MB/s read, 33.9 seconds Interval compaction: 12.30 GB write, 361.55 MB/s write, 0.00 GB read, 0.00 MB/s read, 31.3 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 109, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 109, interval: 101 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 810 Average: 601.9765 StdDev: 1176.97 Min: 0 Median: 3.9556 Max: 6551 Percentiles: P50: 3.96 P75: 435.36 P99: 4350.00 P99.9: 6243.60 P99.99: 6551.00 ------------------------------------------------------ [ 0, 1 ] 297 36.667% 36.667% ####### ( 1, 2 ] 21 2.593% 39.259% # ( 2, 3 ] 1 0.123% 39.383% ( 3, 4 ] 90 11.111% 50.494% ## ( 4, 6 ] 73 9.012% 59.506% ## ( 6, 10 ] 3 0.370% 59.877% ( 10, 15 ] 1 0.123% 60.000% ( 170, 250 ] 105 12.963% 72.963% ### ( 250, 380 ] 1 0.123% 73.086% ( 380, 580 ] 56 6.914% 80.000% # ( 580, 870 ] 6 0.741% 80.741% ( 870, 1300 ] 22 2.716% 83.457% # ( 1300, 1900 ] 23 2.840% 86.296% # ( 1900, 2900 ] 13 1.605% 87.901% ( 2900, 4400 ] 93 11.481% 99.383% ## ( 4400, 6600 ] 5 0.617% 100.000% ** DB Stats ** Uptime(secs): 37.9 total, 2.6 interval Cumulative writes: 0 writes, 14M keys, 0 commit groups, 0.0 writes per commit group, ingest: 13.46 GB, 363.88 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:13.705 H:M:S, 36.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 379.97 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.863 H:M:S, 33.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/11/20-15:21:22 ... thread 0: (1000000,15000000) ops and (302351.5,364474.7) ops/second in (3.307409,41.155117) 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 396.3 36.88 32.59 173 0.213 0 0 0.0 0.0 L3 9/0 818.89 MB 0.8 0.0 0.0 0.0 0.0 0.0 14.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 116/0 9.54 GB 1.0 0.0 0.0 0.0 0.0 0.0 13.5 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 48/0 3.94 GB 0.0 0.0 0.0 0.0 0.0 0.0 3.9 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 173/0 14.27 GB 0.0 0.0 0.0 0.0 14.3 14.3 31.7 1.0 0.0 396.3 36.88 32.59 173 0.213 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 13.3 13.3 29.8 1.0 0.0 397.4 34.24 30.24 161 0.213 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 396.3 36.88 32.59 173 0.213 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.2 total, 38.2 interval Flush(GB): cumulative 14.272, interval 13.288 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, 354.95 MB/s write, 0.00 GB read, 0.00 MB/s read, 36.9 seconds Interval compaction: 13.29 GB write, 356.62 MB/s write, 0.00 GB read, 0.00 MB/s read, 34.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: 118, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 118, interval: 110 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 865 Average: 607.3630 StdDev: 1182.98 Min: 0 Median: 3.9839 Max: 6551 Percentiles: P50: 3.98 P75: 439.17 P99: 4346.32 P99.9: 6219.40 P99.99: 6551.00 ------------------------------------------------------ [ 0, 1 ] 314 36.301% 36.301% ####### ( 1, 2 ] 26 3.006% 39.306% # ( 2, 3 ] 1 0.116% 39.422% ( 3, 4 ] 93 10.751% 50.173% ## ( 4, 6 ] 80 9.249% 59.422% ## ( 6, 10 ] 4 0.462% 59.884% ( 10, 15 ] 1 0.116% 60.000% ( 170, 250 ] 107 12.370% 72.370% ## ( 250, 380 ] 5 0.578% 72.948% ( 380, 580 ] 60 6.936% 79.884% # ( 580, 870 ] 7 0.809% 80.694% ( 870, 1300 ] 24 2.775% 83.468% # ( 1300, 1900 ] 23 2.659% 86.127% # ( 1900, 2900 ] 13 1.503% 87.630% ( 2900, 4400 ] 102 11.792% 99.422% ## ( 4400, 6600 ] 5 0.578% 100.000% ** DB Stats ** Uptime(secs): 41.2 total, 3.3 interval Cumulative writes: 0 writes, 15M keys, 0 commit groups, 0.0 writes per commit group, ingest: 14.42 GB, 358.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:15.280 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, 297.57 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.575 H:M:S, 47.6 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/11/20-15:21:25 ... thread 0: (1000000,16000000) ops and (320311.0,361360.8) ops/second in (3.121966,44.277083) 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 393.7 39.84 35.24 185 0.215 0 0 0.0 0.0 L3 9/0 818.89 MB 0.8 0.0 0.0 0.0 0.0 0.0 15.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 116/0 9.60 GB 1.0 0.0 0.0 0.0 0.0 0.0 14.5 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 60/0 4.92 GB 0.1 0.0 0.0 0.0 0.0 0.0 4.9 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 185/0 15.32 GB 0.0 0.0 0.0 0.0 15.3 15.3 34.8 1.0 0.0 393.7 39.84 35.24 185 0.215 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 14.3 14.3 32.9 1.0 0.0 394.6 37.20 32.89 173 0.215 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 393.7 39.84 35.24 185 0.215 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): 44.3 total, 41.3 interval Flush(GB): cumulative 15.318, interval 14.333 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 15.32 GB write, 354.11 MB/s write, 0.00 GB read, 0.00 MB/s read, 39.8 seconds Interval compaction: 14.33 GB write, 355.59 MB/s write, 0.00 GB read, 0.00 MB/s read, 37.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: 128, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 128, interval: 120 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 925 Average: 603.1351 StdDev: 1174.13 Min: 0 Median: 4.0562 Max: 6551 Percentiles: P50: 4.06 P75: 440.77 P99: 4340.97 P99.9: 6193.00 P99.99: 6551.00 ------------------------------------------------------ [ 0, 1 ] 333 36.000% 36.000% ####### ( 1, 2 ] 31 3.351% 39.351% # ( 2, 3 ] 1 0.108% 39.459% ( 3, 4 ] 95 10.270% 49.730% ## ( 4, 6 ] 89 9.622% 59.351% ## ( 6, 10 ] 5 0.541% 59.892% ( 10, 15 ] 1 0.108% 60.000% ( 170, 250 ] 111 12.000% 72.000% ## ( 250, 380 ] 8 0.865% 72.865% ( 380, 580 ] 65 7.027% 79.892% # ( 580, 870 ] 8 0.865% 80.757% ( 870, 1300 ] 26 2.811% 83.568% # ( 1300, 1900 ] 26 2.811% 86.378% # ( 1900, 2900 ] 13 1.405% 87.784% ( 2900, 4400 ] 108 11.676% 99.459% ## ( 4400, 6600 ] 5 0.541% 100.000% ** DB Stats ** Uptime(secs): 44.3 total, 3.1 interval Cumulative writes: 0 writes, 16M keys, 0 commit groups, 0.0 writes per commit group, ingest: 15.38 GB, 355.50 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:16.681 H:M:S, 37.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 315.25 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.401 H:M:S, 44.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/11/20-15:21:27 ... thread 0: (1000000,17000000) ops and (392618.5,363061.0) ops/second in (2.547002,46.824085) 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 394.0 42.05 37.19 196 0.215 0 0 0.0 0.0 L3 8/0 629.92 MB 0.6 0.0 0.0 0.0 0.0 0.0 16.2 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 116/0 9.66 GB 1.0 0.0 0.0 0.0 0.0 0.0 15.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 72/0 5.91 GB 0.1 0.0 0.0 0.0 0.0 0.0 5.9 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 196/0 16.18 GB 0.0 0.0 0.0 0.0 16.2 16.2 37.6 1.0 0.0 394.0 42.05 37.19 196 0.215 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 15.2 15.2 35.7 1.0 0.0 394.9 39.40 34.84 184 0.214 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 394.0 42.05 37.19 196 0.215 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): 46.8 total, 43.8 interval Flush(GB): cumulative 16.179, interval 15.195 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, 353.68 MB/s write, 0.00 GB read, 0.00 MB/s read, 42.0 seconds Interval compaction: 15.19 GB write, 355.05 MB/s write, 0.00 GB read, 0.00 MB/s read, 39.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: 135, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 135, interval: 127 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 980 Average: 601.0827 StdDev: 1170.28 Min: 0 Median: 4.0632 Max: 6551 Percentiles: P50: 4.06 P75: 438.82 P99: 4336.84 P99.9: 6168.80 P99.99: 6551.00 ------------------------------------------------------ [ 0, 1 ] 354 36.122% 36.122% ####### ( 1, 2 ] 32 3.265% 39.388% # ( 2, 3 ] 1 0.102% 39.490% ( 3, 4 ] 100 10.204% 49.694% ## ( 4, 6 ] 95 9.694% 59.388% ## ( 6, 10 ] 5 0.510% 59.898% ( 10, 15 ] 1 0.102% 60.000% ( 170, 250 ] 119 12.143% 72.143% ## ( 250, 380 ] 8 0.816% 72.959% ( 380, 580 ] 68 6.939% 79.898% # ( 580, 870 ] 8 0.816% 80.714% ( 870, 1300 ] 27 2.755% 83.469% # ( 1300, 1900 ] 29 2.959% 86.429% # ( 1900, 2900 ] 14 1.429% 87.857% ( 2900, 4400 ] 114 11.633% 99.490% ## ( 4400, 6600 ] 5 0.510% 100.000% ** DB Stats ** Uptime(secs): 46.8 total, 2.5 interval Cumulative writes: 0 writes, 17M keys, 0 commit groups, 0.0 writes per commit group, ingest: 16.34 GB, 357.18 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.511 H:M:S, 37.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 386.40 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.830 H:M:S, 32.6 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/11/20-15:21:30 ... thread 0: (1000000,18000000) ops and (360043.8,362892.1) ops/second in (2.777440,49.601525) 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 394.2 44.58 39.41 208 0.214 0 0 0.0 0.0 L3 8/0 629.92 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 L4 116/0 9.66 GB 1.0 0.0 0.0 0.0 0.0 0.0 16.5 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 84/0 6.89 GB 0.1 0.0 0.0 0.0 0.0 0.0 6.9 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 208/0 17.16 GB 0.0 0.0 0.0 0.0 17.2 17.2 40.6 1.0 0.0 394.2 44.58 39.41 208 0.214 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 16.2 16.2 38.7 1.0 0.0 395.0 41.94 37.06 196 0.214 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 394.2 44.58 39.41 208 0.214 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): 49.6 total, 46.6 interval Flush(GB): cumulative 17.163, interval 16.179 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, 354.20 MB/s write, 0.00 GB read, 0.00 MB/s read, 44.6 seconds Interval compaction: 16.18 GB write, 355.52 MB/s write, 0.00 GB read, 0.00 MB/s read, 41.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: 143, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 143, interval: 135 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1040 Average: 605.5894 StdDev: 1177.89 Min: 0 Median: 4.0971 Max: 6551 Percentiles: P50: 4.10 P75: 438.33 P99: 4346.34 P99.9: 6218.67 P99.99: 6551.00 ------------------------------------------------------ [ 0, 1 ] 376 36.154% 36.154% ####### ( 1, 2 ] 34 3.269% 39.423% # ( 2, 3 ] 1 0.096% 39.519% ( 3, 4 ] 104 10.000% 49.519% ## ( 4, 6 ] 103 9.904% 59.423% ## ( 6, 10 ] 5 0.481% 59.904% ( 10, 15 ] 1 0.096% 60.000% ( 170, 250 ] 127 12.212% 72.212% ## ( 250, 380 ] 8 0.769% 72.981% ( 380, 580 ] 72 6.923% 79.904% # ( 580, 870 ] 8 0.769% 80.673% ( 870, 1300 ] 29 2.788% 83.462% # ( 1300, 1900 ] 29 2.788% 86.250% # ( 1900, 2900 ] 14 1.346% 87.596% ( 2900, 4400 ] 123 11.827% 99.423% ## ( 4400, 6600 ] 6 0.577% 100.000% ** DB Stats ** Uptime(secs): 49.6 total, 2.8 interval Cumulative writes: 0 writes, 18M keys, 0 commit groups, 0.0 writes per commit group, ingest: 17.30 GB, 357.03 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.565 H:M:S, 37.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 354.36 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.054 H:M:S, 37.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/11/20-15:21:33 ... thread 0: (1000000,19000000) ops and (353452.7,362382.7) ops/second in (2.829233,52.430758) 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 393.4 47.08 41.64 219 0.215 0 0 0.0 0.0 L3 11/0 944.92 MB 0.9 0.0 0.0 0.0 0.0 0.0 18.1 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 116/0 9.60 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 92/0 7.57 GB 0.1 0.0 0.0 0.0 0.0 0.0 7.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 219/0 18.09 GB 0.0 0.0 0.0 0.0 18.1 18.1 42.8 1.0 0.0 393.4 47.08 41.64 219 0.215 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 17.1 17.1 40.9 1.0 0.0 394.1 44.44 39.29 207 0.215 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 393.4 47.08 41.64 219 0.215 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 52.4 total, 49.4 interval Flush(GB): cumulative 18.086, interval 17.102 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 18.09 GB write, 353.11 MB/s write, 0.00 GB read, 0.00 MB/s read, 47.1 seconds Interval compaction: 17.10 GB write, 354.28 MB/s write, 0.00 GB read, 0.00 MB/s read, 44.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: 151, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 151, interval: 143 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1095 Average: 601.9123 StdDev: 1170.17 Min: 0 Median: 4.0654 Max: 6551 Percentiles: P50: 4.07 P75: 438.55 P99: 4341.99 P99.9: 6198.50 P99.99: 6551.00 ------------------------------------------------------ [ 0, 1 ] 396 36.164% 36.164% ####### ( 1, 2 ] 36 3.288% 39.452% # ( 2, 3 ] 1 0.091% 39.543% ( 3, 4 ] 111 10.137% 49.680% ## ( 4, 6 ] 107 9.772% 59.452% ## ( 6, 10 ] 5 0.457% 59.909% ( 10, 15 ] 1 0.091% 60.000% ( 170, 250 ] 134 12.237% 72.237% ## ( 250, 380 ] 8 0.731% 72.968% ( 380, 580 ] 76 6.941% 79.909% # ( 580, 870 ] 8 0.731% 80.639% ( 870, 1300 ] 31 2.831% 83.470% # ( 1300, 1900 ] 31 2.831% 86.301% # ( 1900, 2900 ] 16 1.461% 87.763% ( 2900, 4400 ] 128 11.689% 99.452% ## ( 4400, 6600 ] 6 0.548% 100.000% ** DB Stats ** Uptime(secs): 52.4 total, 2.8 interval Cumulative writes: 0 writes, 19M keys, 0 commit groups, 0.0 writes per commit group, ingest: 18.26 GB, 356.53 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:19.650 H:M:S, 37.5 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 347.86 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:1.085 H:M:S, 38.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/11/20-15:21:36 ... thread 0: (1000000,20000000) ops and (362046.4,362365.9) ops/second in (2.762077,55.192835) 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 393.9 49.58 43.86 231 0.215 0 0 0.0 0.0 L3 11/0 881.90 MB 0.9 0.0 0.0 0.0 0.0 0.0 19.1 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 116/0 9.66 GB 1.0 0.0 0.0 0.0 0.0 0.0 18.2 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 104/0 8.55 GB 0.1 0.0 0.0 0.0 0.0 0.0 8.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 231/0 19.07 GB 0.0 0.0 0.0 0.0 19.1 19.1 45.8 1.0 0.0 393.9 49.58 43.86 231 0.215 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 18.1 18.1 43.9 1.0 0.0 394.6 46.94 41.51 219 0.214 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 393.9 49.58 43.86 231 0.215 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.2 total, 52.2 interval Flush(GB): cumulative 19.070, interval 18.086 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 19.07 GB write, 353.70 MB/s write, 0.00 GB read, 0.00 MB/s read, 49.6 seconds Interval compaction: 18.09 GB write, 354.85 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: 159, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 159, interval: 151 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1155 Average: 602.0623 StdDev: 1173.19 Min: 0 Median: 3.9959 Max: 6551 Percentiles: P50: 4.00 P75: 438.12 P99: 4348.68 P99.9: 6237.00 P99.99: 6551.00 ------------------------------------------------------ [ 0, 1 ] 419 36.277% 36.277% ####### ( 1, 2 ] 36 3.117% 39.394% # ( 2, 3 ] 1 0.087% 39.481% ( 3, 4 ] 122 10.563% 50.043% ## ( 4, 6 ] 109 9.437% 59.481% ## ( 6, 10 ] 5 0.433% 59.913% ( 10, 15 ] 1 0.087% 60.000% ( 170, 250 ] 142 12.294% 72.294% ## ( 250, 380 ] 8 0.693% 72.987% ( 380, 580 ] 80 6.926% 79.913% # ( 580, 870 ] 8 0.693% 80.606% ( 870, 1300 ] 34 2.944% 83.550% # ( 1300, 1900 ] 32 2.771% 86.320% # ( 1900, 2900 ] 18 1.558% 87.879% ( 2900, 4400 ] 133 11.515% 99.394% ## ( 4400, 6600 ] 7 0.606% 100.000% ** DB Stats ** Uptime(secs): 55.2 total, 2.8 interval Cumulative writes: 0 writes, 20M keys, 0 commit groups, 0.0 writes per commit group, ingest: 19.22 GB, 356.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:20.684 H:M:S, 37.5 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 356.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:1.034 H:M:S, 37.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 using bdev Nvme0n1 Initializing RocksDB Options from the specified file Initializing RocksDB Options from command-line flags Integrated BlobDB: blob cache disabled Keys: 16 bytes each (+ 0 bytes user-defined timestamp) Values: 1000 bytes each (1000 bytes after compression) Entries: 20000000 Prefix: 0 bytes Keys per prefix: 0 RawSize: 19378.7 MB (estimated) FileSize: 19378.7 MB (estimated) Write rate: 0 bytes/second Read rate: 0 ops/second Compression: NoCompression Compression sampling rate: 0 Memtablerep: SkipListFactory Perf Level: 1 ------------------------------------------------ Initializing RocksDB Options from the specified file Initializing RocksDB Options from command-line flags Integrated BlobDB: blob cache disabled DB path: [/mnt/rocksdb] fillseq : 2.760 micros/op 362361 ops/sec 55.194 seconds 20000000 operations; 351.1 MB/s Microseconds per write: Count: 20000000 Average: 2.7597 StdDev: 451.90 Min: 0 Median: 0.6872 Max: 385992 Percentiles: P50: 0.69 P75: 1.82 P99: 5.48 P99.9: 111.08 P99.99: 169.46 ------------------------------------------------------ [ 0, 1 ] 14551149 72.756% 72.756% ############### ( 1, 2 ] 545708 2.729% 75.484% # ( 2, 3 ] 3367255 16.836% 92.321% ### ( 3, 4 ] 1081891 5.409% 97.730% # ( 4, 6 ] 342620 1.713% 99.443% ( 6, 10 ] 56499 0.282% 99.726% ( 10, 15 ] 17513 0.088% 99.813% ( 15, 22 ] 13359 0.067% 99.880% ( 22, 34 ] 3181 0.016% 99.896% ( 34, 51 ] 416 0.002% 99.898% ( 51, 76 ] 66 0.000% 99.898% ( 76, 110 ] 9 0.000% 99.898% ( 110, 170 ] 18502 0.093% 99.991% ( 170, 250 ] 1304 0.007% 99.997% ( 250, 380 ] 319 0.002% 99.999% ( 380, 580 ] 31 0.000% 99.999% ( 580, 870 ] 4 0.000% 99.999% ( 870, 1300 ] 1 0.000% 99.999% ( 1300, 1900 ] 3 0.000% 99.999% ( 1900, 2900 ] 3 0.000% 99.999% ( 2900, 4400 ] 3 0.000% 99.999% ( 4400, 6600 ] 4 0.000% 99.999% ( 9900, 14000 ] 2 0.000% 99.999% ( 14000, 22000 ] 3 0.000% 99.999% ( 22000, 33000 ] 12 0.000% 99.999% ( 33000, 50000 ] 55 0.000% 100.000% ( 50000, 75000 ] 7 0.000% 100.000% ( 75000, 110000 ] 1 0.000% 100.000% ( 110000, 170000 ] 1 0.000% 100.000% ( 170000, 250000 ] 67 0.000% 100.000% ( 250000, 380000 ] 11 0.000% 100.000% ( 380000, 570000 ] 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 : 231 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 20684175 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 : 20476522095 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 : 20312668160 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 : 124089663 rocksdb.non.last.level.read.count COUNT : 1155 rocksdb.block.checksum.compute.count COUNT : 693 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.678282 P95 : 3.003574 P99 : 4.440821 P100 : 385990.000000 COUNT : 20000000 SUM : 48241595 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 : 683.916667 P95 : 768.000000 P99 : 768.000000 P100 : 768.000000 COUNT : 231 SUM : 139339 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 : 112.943038 P95 : 247.081967 P99 : 3133.181818 P100 : 4083.000000 COUNT : 929 SUM : 166660 rocksdb.table.open.io.micros P50 : 3310.869565 P95 : 5851.290323 P99 : 6507.032258 P100 : 7291.000000 COUNT : 231 SUM : 757554 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 : 790.909091 P95 : 4259.302326 P99 : 5676.000000 P100 : 6598.000000 COUNT : 462 SUM : 722954 rocksdb.write.raw.block.micros P50 : 0.509202 P95 : 0.967483 P99 : 2.693636 P100 : 2637.000000 COUNT : 4964754 SUM : 10871121 rocksdb.numfiles.in.singlecompaction P50 : 1.000000 P95 : 3.571605 P99 : 3.914321 P100 : 4.000000 COUNT : 694 SUM : 1017 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 : 140000.000000 P95 : 297863.636364 P99 : 373027.272727 P100 : 385784.000000 COUNT : 159 SUM : 20684175 rocksdb.sst.read.micros P50 : 3.995902 P95 : 3827.631579 P99 : 4348.684211 P100 : 6551.000000 COUNT : 1155 SUM : 695382 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 : 160583.941606 P95 : 364481.250000 P99 : 379496.250000 P100 : 465943.000000 COUNT : 231 SUM : 49578072 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