[2024-07-15 09:19:02.386197] Starting SPDK v24.09-pre git sha1 dd0e45974 / DPDK 24.03.0 initialization... [2024-07-15 09:19:02.386388] [ 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_pid3886874 ] Set seed to 1721027942383216 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-07-15 09:19:02.532501] app.c: 908:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-07-15 09:19:02.753433] app.c: 603:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-07-15 09:19:02.753509] app.c: 604:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 3886874' to capture a snapshot of events at runtime. [2024-07-15 09:19:02.753530] app.c: 609:app_setup_trace: *NOTICE*: 'spdk_trace' without parameters will also work if this is the only [2024-07-15 09:19:02.753550] app.c: 610:app_setup_trace: *NOTICE*: SPDK application currently running. [2024-07-15 09:19:02.753566] app.c: 611:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid3886874 for offline analysis/debug. [2024-07-15 09:19:02.753708] reactor.c: 941:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Mon Jul 15 09:19:08 2024 CPU: 48 * Intel(R) Xeon(R) CPU E5-2697 v2 @ 2.70GHz CPUCache: 30720 KB 2024/07/15-09:19:12 ... thread 0: (1000000,1000000) ops and (269810.2,269810.2) ops/second in (3.706309,3.706309) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 0/0 0.00 KB 0.0 0.0 0.0 0.0 0.9 0.9 0.0 1.0 0.0 266.5 3.31 3.02 12 0.276 0 0 0.0 0.0 L2 1/0 63.00 MB 0.6 0.0 0.0 0.0 0.0 0.0 0.9 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L3 11/0 818.91 MB 0.8 0.0 0.0 0.0 0.0 0.0 0.8 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 12/0 881.91 MB 0.0 0.0 0.0 0.0 0.9 0.9 1.7 1.0 0.0 266.5 3.31 3.02 12 0.276 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 0.3 0.3 1.1 1.0 0.0 303.5 1.04 0.94 4 0.259 0 0 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- High 0/0 0.00 KB 0.0 0.0 0.0 0.0 0.9 0.9 0.0 0.0 0.0 266.5 3.31 3.02 12 0.276 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 3.7 total, 0.7 interval Flush(GB): cumulative 0.861, interval 0.308 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 0.86 GB write, 235.61 MB/s write, 0.00 GB read, 0.00 MB/s read, 3.3 seconds Interval compaction: 0.31 GB write, 445.97 MB/s write, 0.00 GB read, 0.00 MB/s read, 1.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: 4, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 4, interval: 0 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 60 Average: 464.3667 StdDev: 903.17 Min: 1 Median: 5.0909 Max: 3069 Percentiles: P50: 5.09 P75: 242.00 P99: 3069.00 P99.9: 3069.00 P99.99: 3069.00 ------------------------------------------------------ [ 0, 1 ] 11 18.333% 18.333% #### ( 1, 2 ] 13 21.667% 40.000% #### ( 4, 6 ] 11 18.333% 58.333% #### ( 6, 10 ] 1 1.667% 60.000% ( 170, 250 ] 10 16.667% 76.667% ### ( 380, 580 ] 3 5.000% 81.667% # ( 870, 1300 ] 3 5.000% 86.667% # ( 1300, 1900 ] 1 1.667% 88.333% ( 1900, 2900 ] 5 8.333% 96.667% ## ( 2900, 4400 ] 2 3.333% 100.000% # ** DB Stats ** Uptime(secs): 3.7 total, 0.7 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 262.92 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:0.647 H:M:S, 17.3 percent Interval writes: 0 writes, 232K keys, 0 commit groups, 0.0 writes per commit group, ingest: 228.47 MB, 323.21 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.228 H:M:S, 32.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/07/15-09:19:15 ... thread 0: (1000000,2000000) ops and (281605.9,275581.9) ops/second in (3.551062,7.257371) 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 282.3 6.47 5.90 25 0.259 0 0 0.0 0.0 L3 13/0 944.91 MB 0.9 0.0 0.0 0.0 0.0 0.0 1.8 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 12/0 881.91 MB 0.1 0.0 0.0 0.0 0.0 0.0 0.9 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 25/0 1.78 GB 0.0 0.0 0.0 0.0 1.8 1.8 2.6 1.0 0.0 282.3 6.47 5.90 25 0.259 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 1.2 1.2 2.1 1.0 0.0 299.9 4.20 3.82 17 0.247 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 282.3 6.47 5.90 25 0.259 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 7.3 total, 4.3 interval Flush(GB): cumulative 1.784, interval 1.230 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, 250.45 MB/s write, 0.00 GB read, 0.00 MB/s read, 6.5 seconds Interval compaction: 1.23 GB write, 295.93 MB/s write, 0.00 GB read, 0.00 MB/s read, 4.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: 8, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 8, interval: 4 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 125 Average: 372.9680 StdDev: 775.16 Min: 1 Median: 5.1364 Max: 3069 Percentiles: P50: 5.14 P75: 241.43 P99: 3069.00 P99.9: 3069.00 P99.99: 3069.00 ------------------------------------------------------ [ 0, 1 ] 27 21.600% 21.600% #### ( 1, 2 ] 23 18.400% 40.000% #### ( 4, 6 ] 22 17.600% 57.600% #### ( 6, 10 ] 3 2.400% 60.000% ( 170, 250 ] 21 16.800% 76.800% ### ( 380, 580 ] 9 7.200% 84.000% # ( 580, 870 ] 4 3.200% 87.200% # ( 870, 1300 ] 4 3.200% 90.400% # ( 1300, 1900 ] 2 1.600% 92.000% ( 1900, 2900 ] 8 6.400% 98.400% # ( 2900, 4400 ] 2 1.600% 100.000% ** DB Stats ** Uptime(secs): 7.3 total, 3.6 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 269.85 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:1.226 H:M:S, 16.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 277.16 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.579 H:M:S, 16.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/07/15-09:19:19 ... thread 0: (1000000,3000000) ops and (285233.0,278725.5) ops/second in (3.505906,10.763277) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 0/0 0.00 KB 0.0 0.0 0.0 0.0 2.8 2.8 0.0 1.0 0.0 288.9 9.81 8.93 39 0.252 0 0 0.0 0.0 L3 11/0 818.92 MB 0.8 0.0 0.0 0.0 0.0 0.0 2.8 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 28/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 39/0 2.77 GB 0.0 0.0 0.0 0.0 2.8 2.8 4.7 1.0 0.0 288.9 9.81 8.93 39 0.252 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 2.2 2.2 4.2 1.0 0.0 300.7 7.54 6.85 31 0.243 0 0 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- High 0/0 0.00 KB 0.0 0.0 0.0 0.0 2.8 2.8 0.0 0.0 0.0 288.9 9.81 8.93 39 0.252 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.8 total, 7.8 interval Flush(GB): cumulative 2.768, interval 2.215 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 2.77 GB write, 262.47 MB/s write, 0.00 GB read, 0.00 MB/s read, 9.8 seconds Interval compaction: 2.21 GB write, 292.12 MB/s write, 0.00 GB read, 0.00 MB/s read, 7.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: 11, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 11, interval: 7 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 195 Average: 388.7282 StdDev: 789.76 Min: 1 Median: 5.1471 Max: 3080 Percentiles: P50: 5.15 P75: 240.91 P99: 3080.00 P99.9: 3080.00 P99.99: 3080.00 ------------------------------------------------------ [ 0, 1 ] 42 21.538% 21.538% #### ( 1, 2 ] 36 18.462% 40.000% #### ( 4, 6 ] 34 17.436% 57.436% ### ( 6, 10 ] 5 2.564% 60.000% # ( 170, 250 ] 33 16.923% 76.923% ### ( 380, 580 ] 11 5.641% 82.564% # ( 580, 870 ] 5 2.564% 85.128% # ( 870, 1300 ] 10 5.128% 90.256% # ( 1300, 1900 ] 3 1.538% 91.795% ( 1900, 2900 ] 12 6.154% 97.949% # ( 2900, 4400 ] 4 2.051% 100.000% ** DB Stats ** Uptime(secs): 10.8 total, 3.5 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 273.38 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:1.751 H:M:S, 16.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 280.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.525 H:M:S, 15.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/07/15-09:19:22 ... thread 0: (1000000,4000000) ops and (273842.2,277488.4) ops/second in (3.651738,14.415015) 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 287.5 13.15 11.93 52 0.253 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 11/0 818.92 MB 0.8 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 40/0 2.83 GB 0.3 0.0 0.0 0.0 0.0 0.0 2.8 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 52/0 3.69 GB 0.0 0.0 0.0 0.0 3.7 3.7 10.2 1.0 0.0 287.5 13.15 11.93 52 0.253 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 3.1 3.1 9.6 1.0 0.0 295.4 10.88 9.85 44 0.247 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 287.5 13.15 11.93 52 0.253 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 14.5 total, 11.4 interval Flush(GB): cumulative 3.691, interval 3.137 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, 261.53 MB/s write, 0.00 GB read, 0.00 MB/s read, 13.1 seconds Interval compaction: 3.14 GB write, 281.45 MB/s write, 0.00 GB read, 0.00 MB/s read, 10.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: 13, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 13, interval: 9 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 260 Average: 432.2154 StdDev: 889.43 Min: 1 Median: 5.2000 Max: 3910 Percentiles: P50: 5.20 P75: 240.91 P99: 3910.00 P99.9: 3910.00 P99.99: 3910.00 ------------------------------------------------------ [ 0, 1 ] 61 23.462% 23.462% ##### ( 1, 2 ] 42 16.154% 39.615% ### ( 4, 6 ] 45 17.308% 56.923% ### ( 6, 10 ] 7 2.692% 59.615% # ( 10, 15 ] 1 0.385% 60.000% ( 170, 250 ] 44 16.923% 76.923% ### ( 250, 380 ] 1 0.385% 77.308% ( 380, 580 ] 12 4.615% 81.923% # ( 580, 870 ] 6 2.308% 84.231% ( 870, 1300 ] 12 4.615% 88.846% # ( 1300, 1900 ] 5 1.923% 90.769% ( 1900, 2900 ] 13 5.000% 95.769% # ( 2900, 4400 ] 11 4.231% 100.000% # ** DB Stats ** Uptime(secs): 14.5 total, 3.7 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 272.41 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.320 H:M:S, 16.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 269.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.569 H:M:S, 15.6 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/07/15-09:19:26 ... thread 0: (1000000,5000000) ops and (276457.7,277281.7) ops/second in (3.617190,18.032205) 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 288.0 16.62 15.10 66 0.252 0 0 0.0 0.0 L3 10/0 692.93 MB 0.7 0.0 0.0 0.0 0.0 0.0 4.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 56/0 4.00 GB 0.4 0.0 0.0 0.0 0.0 0.0 4.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 66/0 4.68 GB 0.0 0.0 0.0 0.0 4.7 4.7 8.7 1.0 0.0 288.0 16.62 15.10 66 0.252 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 4.1 4.1 8.1 1.0 0.0 294.1 14.35 13.02 58 0.247 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 288.0 16.62 15.10 66 0.252 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.1 total, 15.0 interval Flush(GB): cumulative 4.675, interval 4.122 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, 264.96 MB/s write, 0.00 GB read, 0.00 MB/s read, 16.6 seconds Interval compaction: 4.12 GB write, 280.77 MB/s write, 0.00 GB read, 0.00 MB/s read, 14.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: 17, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 17, interval: 13 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 330 Average: 409.0727 StdDev: 849.82 Min: 1 Median: 5.2143 Max: 3910 Percentiles: P50: 5.21 P75: 242.00 P99: 3910.00 P99.9: 3910.00 P99.99: 3910.00 ------------------------------------------------------ [ 0, 1 ] 73 22.121% 22.121% #### ( 1, 2 ] 58 17.576% 39.697% #### ( 4, 6 ] 56 16.970% 56.667% ### ( 6, 10 ] 10 3.030% 59.697% # ( 10, 15 ] 1 0.303% 60.000% ( 170, 250 ] 55 16.667% 76.667% ### ( 250, 380 ] 2 0.606% 77.273% ( 380, 580 ] 18 5.455% 82.727% # ( 580, 870 ] 8 2.424% 85.152% ( 870, 1300 ] 16 4.848% 90.000% # ( 1300, 1900 ] 5 1.515% 91.515% ( 1900, 2900 ] 16 4.848% 96.364% # ( 2900, 4400 ] 12 3.636% 100.000% # ** DB Stats ** Uptime(secs): 18.1 total, 3.6 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 272.34 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:2.884 H:M:S, 16.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 272.09 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.564 H:M:S, 15.6 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/07/15-09:19:29 ... thread 0: (1000000,6000000) ops and (287273.0,278898.4) ops/second in (3.481009,21.513214) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 0/0 0.00 KB 0.0 0.0 0.0 0.0 5.6 5.6 0.0 1.0 0.0 289.7 19.79 17.95 79 0.250 0 0 0.0 0.0 L2 1/0 62.99 MB 0.6 0.0 0.0 0.0 0.0 0.0 5.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L3 10/0 692.94 MB 0.7 0.0 0.0 0.0 0.0 0.0 5.5 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 68/0 4.86 GB 0.5 0.0 0.0 0.0 0.0 0.0 4.9 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 79/0 5.60 GB 0.0 0.0 0.0 0.0 5.6 5.6 16.0 1.0 0.0 289.7 19.79 17.95 79 0.250 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 5.0 5.0 15.4 1.0 0.0 294.9 17.52 15.87 71 0.247 0 0 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- High 0/0 0.00 KB 0.0 0.0 0.0 0.0 5.6 5.6 0.0 0.0 0.0 289.7 19.79 17.95 79 0.250 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 5.598, interval 5.044 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 5.60 GB write, 266.01 MB/s write, 0.00 GB read, 0.00 MB/s read, 19.8 seconds Interval compaction: 5.04 GB write, 279.02 MB/s write, 0.00 GB read, 0.00 MB/s read, 17.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: 20, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 20, interval: 16 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 395 Average: 427.6911 StdDev: 878.02 Min: 1 Median: 5.2388 Max: 3910 Percentiles: P50: 5.24 P75: 242.92 P99: 3910.00 P99.9: 3910.00 P99.99: 3910.00 ------------------------------------------------------ [ 0, 1 ] 90 22.785% 22.785% ##### ( 1, 2 ] 66 16.709% 39.494% ### ( 4, 6 ] 67 16.962% 56.456% ### ( 6, 10 ] 12 3.038% 59.494% # ( 10, 15 ] 1 0.253% 59.747% ( 15, 22 ] 1 0.253% 60.000% ( 170, 250 ] 65 16.456% 76.456% ### ( 250, 380 ] 2 0.506% 76.962% ( 380, 580 ] 21 5.316% 82.278% # ( 580, 870 ] 9 2.278% 84.557% ( 870, 1300 ] 18 4.557% 89.114% # ( 1300, 1900 ] 7 1.772% 90.886% ( 1900, 2900 ] 20 5.063% 95.949% # ( 2900, 4400 ] 16 4.051% 100.000% # ** DB Stats ** Uptime(secs): 21.6 total, 3.5 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 274.02 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.358 H:M:S, 15.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 282.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.474 H:M:S, 13.6 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/07/15-09:19:33 ... thread 0: (1000000,7000000) ops and (260953.0,276185.1) ops/second in (3.832107,25.345321) 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 289.9 23.47 21.28 93 0.252 0 0 0.0 0.0 L2 1/0 63.00 MB 0.6 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 L3 12/0 881.89 MB 0.9 0.0 0.0 0.0 0.0 0.0 6.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 80/0 5.72 GB 0.6 0.0 0.0 0.0 0.0 0.0 5.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 93/0 6.64 GB 0.0 0.0 0.0 0.0 6.6 6.6 18.9 1.0 0.0 289.9 23.47 21.28 93 0.252 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 6.1 6.1 18.4 1.0 0.0 294.2 21.20 19.20 85 0.249 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 289.9 23.47 21.28 93 0.252 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 25.4 total, 22.3 interval Flush(GB): cumulative 6.644, interval 6.090 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 6.64 GB write, 268.04 MB/s write, 0.00 GB read, 0.00 MB/s read, 23.5 seconds Interval compaction: 6.09 GB write, 279.09 MB/s write, 0.00 GB read, 0.00 MB/s read, 21.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: 25, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 25, interval: 21 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 465 Average: 410.1677 StdDev: 851.79 Min: 1 Median: 5.2597 Max: 3910 Percentiles: P50: 5.26 P75: 243.42 P99: 3910.00 P99.9: 3910.00 P99.99: 3910.00 ------------------------------------------------------ [ 0, 1 ] 107 23.011% 23.011% ##### ( 1, 2 ] 77 16.559% 39.570% ### ( 4, 6 ] 77 16.559% 56.129% ### ( 6, 10 ] 16 3.441% 59.570% # ( 10, 15 ] 1 0.215% 59.785% ( 15, 22 ] 1 0.215% 60.000% ( 170, 250 ] 76 16.344% 76.344% ### ( 250, 380 ] 2 0.430% 76.774% ( 380, 580 ] 31 6.667% 83.441% # ( 580, 870 ] 10 2.151% 85.591% ( 870, 1300 ] 20 4.301% 89.892% # ( 1300, 1900 ] 7 1.505% 91.398% ( 1900, 2900 ] 22 4.731% 96.129% # ( 2900, 4400 ] 18 3.871% 100.000% # ** DB Stats ** Uptime(secs): 25.4 total, 3.8 interval Cumulative writes: 0 writes, 7000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 6.73 GB, 271.42 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.173 H:M:S, 16.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 256.83 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.815 H:M:S, 21.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/07/15-09:19:37 ... thread 0: (1000000,8000000) ops and (277016.3,276288.7) ops/second in (3.609896,28.955217) 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 289.8 26.74 24.25 106 0.252 0 0 0.0 0.0 L2 1/0 62.99 MB 0.6 0.0 0.0 0.0 0.0 0.0 7.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L3 13/0 944.90 MB 0.9 0.0 0.0 0.0 0.0 0.0 7.5 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 92/0 6.58 GB 0.7 0.0 0.0 0.0 0.0 0.0 6.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 106/0 7.57 GB 0.0 0.0 0.0 0.0 7.6 7.6 21.7 1.0 0.0 289.8 26.74 24.25 106 0.252 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 7.0 7.0 21.1 1.0 0.0 293.5 24.47 22.17 98 0.250 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 289.8 26.74 24.25 106 0.252 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.0 total, 26.0 interval Flush(GB): cumulative 7.567, interval 7.013 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, 267.25 MB/s write, 0.00 GB read, 0.00 MB/s read, 26.7 seconds Interval compaction: 7.01 GB write, 276.68 MB/s write, 0.00 GB read, 0.00 MB/s read, 24.5 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 28, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 28, interval: 24 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 530 Average: 411.4321 StdDev: 854.20 Min: 1 Median: 5.2644 Max: 3910 Percentiles: P50: 5.26 P75: 243.95 P99: 3910.00 P99.9: 3910.00 P99.99: 3910.00 ------------------------------------------------------ [ 0, 1 ] 120 22.642% 22.642% ##### ( 1, 2 ] 90 16.981% 39.623% ### ( 4, 6 ] 87 16.415% 56.038% ### ( 6, 10 ] 19 3.585% 59.623% # ( 10, 15 ] 1 0.189% 59.811% ( 15, 22 ] 1 0.189% 60.000% ( 170, 250 ] 86 16.226% 76.226% ### ( 250, 380 ] 3 0.566% 76.792% ( 380, 580 ] 34 6.415% 83.208% # ( 580, 870 ] 13 2.453% 85.660% ( 870, 1300 ] 23 4.340% 90.000% # ( 1300, 1900 ] 7 1.321% 91.321% ( 1900, 2900 ] 24 4.528% 95.849% # ( 2900, 4400 ] 22 4.151% 100.000% # ** DB Stats ** Uptime(secs): 29.0 total, 3.6 interval Cumulative writes: 0 writes, 8000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 7.69 GB, 271.58 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:4.766 H:M:S, 16.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 272.64 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.594 H:M:S, 16.4 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/07/15-09:19:40 ... thread 0: (1000000,9000000) ops and (277224.0,276392.3) ops/second in (3.607191,32.562408) 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 289.7 30.22 27.39 120 0.252 0 0 0.0 0.0 L2 1/0 62.99 MB 0.6 0.0 0.0 0.0 0.0 0.0 8.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L3 11/0 818.93 MB 0.8 0.0 0.0 0.0 0.0 0.0 8.5 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 108/0 7.69 GB 0.8 0.0 0.0 0.0 0.0 0.0 7.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 120/0 8.55 GB 0.0 0.0 0.0 0.0 8.6 8.6 24.7 1.0 0.0 289.7 30.22 27.39 120 0.252 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 8.0 8.0 24.2 1.0 0.0 293.0 27.95 25.31 112 0.250 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 289.7 30.22 27.39 120 0.252 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.6 interval Flush(GB): cumulative 8.551, interval 7.997 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, 268.60 MB/s write, 0.00 GB read, 0.00 MB/s read, 30.2 seconds Interval compaction: 8.00 GB write, 277.01 MB/s write, 0.00 GB read, 0.00 MB/s read, 27.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: 32, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 32, interval: 28 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 600 Average: 404.2833 StdDev: 845.72 Min: 1 Median: 5.2917 Max: 3910 Percentiles: P50: 5.29 P75: 243.47 P99: 3910.00 P99.9: 3910.00 P99.99: 3910.00 ------------------------------------------------------ [ 0, 1 ] 139 23.167% 23.167% ##### ( 1, 2 ] 99 16.500% 39.667% ### ( 4, 6 ] 96 16.000% 55.667% ### ( 6, 10 ] 23 3.833% 59.500% # ( 10, 15 ] 1 0.167% 59.667% ( 15, 22 ] 2 0.333% 60.000% ( 170, 250 ] 98 16.333% 76.333% ### ( 250, 380 ] 3 0.500% 76.833% ( 380, 580 ] 40 6.667% 83.500% # ( 580, 870 ] 15 2.500% 86.000% # ( 870, 1300 ] 25 4.167% 90.167% # ( 1300, 1900 ] 10 1.667% 91.833% ( 1900, 2900 ] 24 4.000% 95.833% # ( 2900, 4400 ] 25 4.167% 100.000% # ** DB Stats ** Uptime(secs): 32.6 total, 3.6 interval Cumulative writes: 0 writes, 9000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 8.65 GB, 271.72 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:5.337 H:M:S, 16.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 272.84 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.571 H:M:S, 15.8 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/07/15-09:19:44 ... thread 0: (1000000,10000000) ops and (281126.6,276858.6) ops/second in (3.557116,36.119524) 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 289.7 33.49 30.34 133 0.252 0 0 0.0 0.0 L3 13/0 944.93 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 120/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 133/0 9.47 GB 0.0 0.0 0.0 0.0 9.5 9.5 18.0 1.0 0.0 289.7 33.49 30.34 133 0.252 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 8.9 8.9 17.5 1.0 0.0 292.6 31.22 28.26 125 0.250 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 289.7 33.49 30.34 133 0.252 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): 36.2 total, 33.1 interval Flush(GB): cumulative 9.474, interval 8.920 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, 268.31 MB/s write, 0.00 GB read, 0.00 MB/s read, 33.5 seconds Interval compaction: 8.92 GB write, 275.79 MB/s write, 0.00 GB read, 0.00 MB/s read, 31.2 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 35, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 35, interval: 31 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 665 Average: 402.2060 StdDev: 840.70 Min: 1 Median: 5.3173 Max: 3910 Percentiles: P50: 5.32 P75: 243.21 P99: 3910.00 P99.9: 3910.00 P99.99: 3910.00 ------------------------------------------------------ [ 0, 1 ] 156 23.459% 23.459% ##### ( 1, 2 ] 108 16.241% 39.699% ### ( 4, 6 ] 104 15.639% 55.338% ### ( 6, 10 ] 28 4.211% 59.549% # ( 10, 15 ] 1 0.150% 59.699% ( 15, 22 ] 2 0.301% 60.000% ( 170, 250 ] 109 16.391% 76.391% ### ( 250, 380 ] 4 0.602% 76.992% ( 380, 580 ] 44 6.617% 83.609% # ( 580, 870 ] 16 2.406% 86.015% ( 870, 1300 ] 28 4.211% 90.226% # ( 1300, 1900 ] 10 1.504% 91.729% ( 1900, 2900 ] 30 4.511% 96.241% # ( 2900, 4400 ] 25 3.759% 100.000% # ** DB Stats ** Uptime(secs): 36.2 total, 3.6 interval Cumulative writes: 0 writes, 10M keys, 0 commit groups, 0.0 writes per commit group, ingest: 9.61 GB, 272.20 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.834 H:M:S, 16.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 276.68 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.497 H:M:S, 14.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/07/15-09:19:48 ... thread 0: (1000000,11000000) ops and (276876.2,276860.2) ops/second in (3.611722,39.731246) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 0/0 0.00 KB 0.0 0.0 0.0 0.0 10.4 10.4 0.0 1.0 0.0 289.6 36.75 33.29 146 0.252 0 0 0.0 0.0 L2 1/0 62.99 MB 0.6 0.0 0.0 0.0 0.0 0.0 10.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L3 13/0 944.89 MB 0.9 0.0 0.0 0.0 0.0 0.0 10.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 132/0 9.41 GB 1.0 0.0 0.0 0.0 0.0 0.0 9.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 146/0 10.40 GB 0.0 0.0 0.0 0.0 10.4 10.4 30.1 1.0 0.0 289.6 36.75 33.29 146 0.252 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 9.8 9.8 29.6 1.0 0.0 292.3 34.48 31.21 138 0.250 0 0 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- High 0/0 0.00 KB 0.0 0.0 0.0 0.0 10.4 10.4 0.0 0.0 0.0 289.6 36.75 33.29 146 0.252 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): 39.8 total, 36.7 interval Flush(GB): cumulative 10.396, interval 9.843 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 10.40 GB write, 267.70 MB/s write, 0.00 GB read, 0.00 MB/s read, 36.8 seconds Interval compaction: 9.84 GB write, 274.40 MB/s write, 0.00 GB read, 0.00 MB/s read, 34.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: 40, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 40, interval: 36 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 730 Average: 411.7370 StdDev: 855.58 Min: 1 Median: 5.2931 Max: 3910 Percentiles: P50: 5.29 P75: 243.00 P99: 3910.00 P99.9: 3910.00 P99.99: 3910.00 ------------------------------------------------------ [ 0, 1 ] 174 23.836% 23.836% ##### ( 1, 2 ] 116 15.890% 39.726% ### ( 4, 6 ] 116 15.890% 55.616% ### ( 6, 10 ] 29 3.973% 59.589% # ( 10, 15 ] 1 0.137% 59.726% ( 15, 22 ] 2 0.274% 60.000% ( 170, 250 ] 120 16.438% 76.438% ### ( 250, 380 ] 4 0.548% 76.986% ( 380, 580 ] 46 6.301% 83.288% # ( 580, 870 ] 18 2.466% 85.753% ( 870, 1300 ] 30 4.110% 89.863% # ( 1300, 1900 ] 10 1.370% 91.233% ( 1900, 2900 ] 34 4.658% 95.890% # ( 2900, 4400 ] 30 4.110% 100.000% # ** DB Stats ** Uptime(secs): 39.8 total, 3.6 interval Cumulative writes: 0 writes, 11M keys, 0 commit groups, 0.0 writes per commit group, ingest: 10.57 GB, 272.23 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:6.425 H:M:S, 16.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 272.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:0.591 H:M:S, 16.4 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/07/15-09:19:52 ... thread 0: (1000000,12000000) ops and (256008.9,274993.7) ops/second in (3.906114,43.637360) 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 289.3 40.50 36.68 160 0.253 0 0 0.0 0.0 L2 1/0 62.99 MB 0.6 0.0 0.0 0.0 0.0 0.0 11.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L3 11/0 818.92 MB 0.8 0.0 0.0 0.0 0.0 0.0 11.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 136/0 9.72 GB 1.0 0.0 0.0 0.0 0.0 0.0 10.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 12/0 881.91 MB 0.0 0.0 0.0 0.0 0.0 0.0 0.9 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 160/0 11.44 GB 0.0 0.0 0.0 0.0 11.4 11.4 34.3 1.0 0.0 289.3 40.50 36.68 160 0.253 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 10.9 10.9 33.7 1.0 0.0 291.6 38.23 34.60 152 0.252 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 289.3 40.50 36.68 160 0.253 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 43.7 total, 40.6 interval Flush(GB): cumulative 11.442, interval 10.889 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, 268.28 MB/s write, 0.00 GB read, 0.00 MB/s read, 40.5 seconds Interval compaction: 10.89 GB write, 274.38 MB/s write, 0.00 GB read, 0.00 MB/s read, 38.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: 45, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 45, interval: 41 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 800 Average: 401.5213 StdDev: 838.03 Min: 1 Median: 5.3016 Max: 3910 Percentiles: P50: 5.30 P75: 243.28 P99: 3910.00 P99.9: 3910.00 P99.99: 3910.00 ------------------------------------------------------ [ 0, 1 ] 190 23.750% 23.750% ##### ( 1, 2 ] 128 16.000% 39.750% ### ( 4, 6 ] 126 15.750% 55.500% ### ( 6, 10 ] 31 3.875% 59.375% # ( 10, 15 ] 1 0.125% 59.500% ( 15, 22 ] 4 0.500% 60.000% ( 170, 250 ] 131 16.375% 76.375% ### ( 250, 380 ] 4 0.500% 76.875% ( 380, 580 ] 52 6.500% 83.375% # ( 580, 870 ] 23 2.875% 86.250% # ( 870, 1300 ] 33 4.125% 90.375% # ( 1300, 1900 ] 10 1.250% 91.625% ( 1900, 2900 ] 36 4.500% 96.125% # ( 2900, 4400 ] 31 3.875% 100.000% # ** DB Stats ** Uptime(secs): 43.7 total, 3.9 interval Cumulative writes: 0 writes, 12M keys, 0 commit groups, 0.0 writes per commit group, ingest: 11.53 GB, 270.42 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.276 H:M:S, 16.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 251.96 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.851 H:M:S, 21.8 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/07/15-09:19:55 ... thread 0: (1000000,13000000) ops and (276819.9,275133.3) ops/second in (3.612457,47.249817) 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 289.1 43.80 39.66 173 0.253 0 0 0.0 0.0 L3 13/0 944.88 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 136/0 9.72 GB 1.0 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 L5 24/0 1.72 GB 0.0 0.0 0.0 0.0 0.0 0.0 1.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 173/0 12.36 GB 0.0 0.0 0.0 0.0 12.4 12.4 25.5 1.0 0.0 289.1 43.80 39.66 173 0.253 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 11.8 11.8 25.0 1.0 0.0 291.2 41.53 37.58 165 0.252 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 289.1 43.80 39.66 173 0.253 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 47.3 total, 44.2 interval Flush(GB): cumulative 12.365, interval 11.811 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 12.36 GB write, 267.77 MB/s write, 0.00 GB read, 0.00 MB/s read, 43.8 seconds Interval compaction: 11.81 GB write, 273.33 MB/s write, 0.00 GB read, 0.00 MB/s read, 41.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: 49, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 49, interval: 45 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 865 Average: 408.9306 StdDev: 855.57 Min: 1 Median: 5.2786 Max: 4637 Percentiles: P50: 5.28 P75: 243.62 P99: 4081.25 P99.9: 4637.00 P99.99: 4637.00 ------------------------------------------------------ [ 0, 1 ] 203 23.468% 23.468% ##### ( 1, 2 ] 140 16.185% 39.653% ### ( 4, 6 ] 140 16.185% 55.838% ### ( 6, 10 ] 31 3.584% 59.422% # ( 10, 15 ] 1 0.116% 59.538% ( 15, 22 ] 4 0.462% 60.000% ( 170, 250 ] 141 16.301% 76.301% ### ( 250, 380 ] 5 0.578% 76.879% ( 380, 580 ] 54 6.243% 83.121% # ( 580, 870 ] 24 2.775% 85.896% # ( 870, 1300 ] 37 4.277% 90.173% # ( 1300, 1900 ] 12 1.387% 91.561% ( 1900, 2900 ] 36 4.162% 95.723% # ( 2900, 4400 ] 36 4.162% 99.884% # ( 4400, 6600 ] 1 0.116% 100.000% ** DB Stats ** Uptime(secs): 47.3 total, 3.6 interval Cumulative writes: 0 writes, 13M keys, 0 commit groups, 0.0 writes per commit group, ingest: 12.49 GB, 270.57 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.867 H:M:S, 16.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 272.44 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.590 H:M:S, 16.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/07/15-09:19:59 ... thread 0: (1000000,14000000) ops and (281954.1,275609.6) ops/second in (3.546677,50.796494) 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 289.4 47.01 42.55 186 0.253 0 0 0.0 0.0 L2 1/0 62.99 MB 0.6 0.0 0.0 0.0 0.0 0.0 13.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L3 13/0 944.90 MB 0.9 0.0 0.0 0.0 0.0 0.0 13.2 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 132/0 9.47 GB 1.0 0.0 0.0 0.0 0.0 0.0 12.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 40/0 2.83 GB 0.0 0.0 0.0 0.0 0.0 0.0 2.8 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 186/0 13.29 GB 0.0 0.0 0.0 0.0 13.3 13.3 41.6 1.0 0.0 289.4 47.01 42.55 186 0.253 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 12.7 12.7 41.1 1.0 0.0 291.5 44.74 40.47 178 0.251 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 289.4 47.01 42.55 186 0.253 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 50.8 total, 47.8 interval Flush(GB): cumulative 13.288, interval 12.734 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, 267.67 MB/s write, 0.00 GB read, 0.00 MB/s read, 47.0 seconds Interval compaction: 12.73 GB write, 272.82 MB/s write, 0.00 GB read, 0.00 MB/s read, 44.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: 53, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 53, interval: 49 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 934 Average: 403.9893 StdDev: 848.98 Min: 1 Median: 5.2848 Max: 4637 Percentiles: P50: 5.28 P75: 242.94 P99: 4070.79 P99.9: 4545.20 P99.99: 4637.00 ------------------------------------------------------ [ 0, 1 ] 220 23.555% 23.555% ##### ( 1, 2 ] 150 16.060% 39.615% ### ( 4, 6 ] 151 16.167% 55.782% ### ( 6, 10 ] 35 3.747% 59.529% # ( 10, 15 ] 1 0.107% 59.636% ( 15, 22 ] 4 0.428% 60.064% ( 170, 250 ] 153 16.381% 76.445% ### ( 250, 380 ] 5 0.535% 76.981% ( 380, 580 ] 60 6.424% 83.405% # ( 580, 870 ] 27 2.891% 86.296% # ( 870, 1300 ] 38 4.069% 90.364% # ( 1300, 1900 ] 12 1.285% 91.649% ( 1900, 2900 ] 39 4.176% 95.824% # ( 2900, 4400 ] 38 4.069% 99.893% # ( 4400, 6600 ] 1 0.107% 100.000% ** DB Stats ** Uptime(secs): 50.8 total, 3.5 interval Cumulative writes: 0 writes, 14M keys, 0 commit groups, 0.0 writes per commit group, ingest: 13.46 GB, 271.06 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.396 H:M:S, 16.5 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 277.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.530 H:M:S, 14.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/07/15-09:20:02 ... thread 0: (1000000,15000000) ops and (273744.5,275484.4) ops/second in (3.653041,54.449535) 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 289.2 50.53 45.76 200 0.253 0 0 0.0 0.0 L2 1/0 62.99 MB 0.6 0.0 0.0 0.0 0.0 0.0 14.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L3 11/0 818.92 MB 0.8 0.0 0.0 0.0 0.0 0.0 14.2 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 136/0 9.72 GB 1.0 0.0 0.0 0.0 0.0 0.0 13.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 52/0 3.69 GB 0.0 0.0 0.0 0.0 0.0 0.0 3.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 200/0 14.27 GB 0.0 0.0 0.0 0.0 14.3 14.3 45.6 1.0 0.0 289.2 50.53 45.76 200 0.253 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 13.7 13.7 45.0 1.0 0.0 291.1 48.26 43.68 192 0.251 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 289.2 50.53 45.76 200 0.253 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): 54.5 total, 51.4 interval Flush(GB): cumulative 14.272, interval 13.718 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, 268.22 MB/s write, 0.00 GB read, 0.00 MB/s read, 50.5 seconds Interval compaction: 13.72 GB write, 273.04 MB/s write, 0.00 GB read, 0.00 MB/s read, 48.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: 58, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 58, interval: 54 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1000 Average: 401.0410 StdDev: 841.41 Min: 1 Median: 5.2919 Max: 4637 Percentiles: P50: 5.29 P75: 243.17 P99: 4070.73 P99.9: 4400.00 P99.99: 4637.00 ------------------------------------------------------ [ 0, 1 ] 238 23.800% 23.800% ##### ( 1, 2 ] 158 15.800% 39.600% ### ( 4, 6 ] 161 16.100% 55.700% ### ( 6, 10 ] 37 3.700% 59.400% # ( 10, 15 ] 1 0.100% 59.500% ( 15, 22 ] 5 0.500% 60.000% ( 170, 250 ] 164 16.400% 76.400% ### ( 250, 380 ] 5 0.500% 76.900% ( 380, 580 ] 64 6.400% 83.300% # ( 580, 870 ] 31 3.100% 86.400% # ( 870, 1300 ] 41 4.100% 90.500% # ( 1300, 1900 ] 13 1.300% 91.800% ( 1900, 2900 ] 40 4.000% 95.800% # ( 2900, 4400 ] 41 4.100% 99.900% # ( 4400, 6600 ] 1 0.100% 100.000% ** DB Stats ** Uptime(secs): 54.5 total, 3.7 interval Cumulative writes: 0 writes, 15M keys, 0 commit groups, 0.0 writes per commit group, ingest: 14.42 GB, 270.95 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:9.009 H:M:S, 16.5 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 269.42 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.613 H:M:S, 16.8 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/07/15-09:20:06 ... thread 0: (1000000,16000000) ops and (255646.1,274154.8) ops/second in (3.911657,58.361192) 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 288.9 54.07 48.99 213 0.254 0 0 0.0 0.0 L3 9/0 692.92 MB 0.7 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 136/0 9.72 GB 1.0 0.0 0.0 0.0 0.0 0.0 14.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 68/0 4.86 GB 0.0 0.0 0.0 0.0 0.0 0.0 4.9 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 213/0 15.26 GB 0.0 0.0 0.0 0.0 15.3 15.3 34.7 1.0 0.0 288.9 54.07 48.99 213 0.254 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 14.7 14.7 34.1 1.0 0.0 290.6 51.80 46.91 205 0.253 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 288.9 54.07 48.99 213 0.254 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 58.4 total, 55.4 interval Flush(GB): cumulative 15.256, interval 14.703 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 15.26 GB write, 267.52 MB/s write, 0.00 GB read, 0.00 MB/s read, 54.1 seconds Interval compaction: 14.70 GB write, 271.95 MB/s write, 0.00 GB read, 0.00 MB/s read, 51.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: 63, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 63, interval: 59 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1065 Average: 398.1615 StdDev: 834.06 Min: 1 Median: 5.2849 Max: 4637 Percentiles: P50: 5.28 P75: 243.45 P99: 4046.95 P99.9: 4397.62 P99.99: 4637.00 ------------------------------------------------------ [ 0, 1 ] 257 24.131% 24.131% ##### ( 1, 2 ] 165 15.493% 39.624% ### ( 4, 6 ] 172 16.150% 55.775% ### ( 6, 10 ] 39 3.662% 59.437% # ( 10, 15 ] 1 0.094% 59.531% ( 15, 22 ] 5 0.469% 60.000% ( 170, 250 ] 174 16.338% 76.338% ### ( 250, 380 ] 6 0.563% 76.901% ( 380, 580 ] 69 6.479% 83.380% # ( 580, 870 ] 32 3.005% 86.385% # ( 870, 1300 ] 45 4.225% 90.610% # ( 1300, 1900 ] 13 1.221% 91.831% ( 1900, 2900 ] 45 4.225% 96.056% # ( 2900, 4400 ] 41 3.850% 99.906% # ( 4400, 6600 ] 1 0.094% 100.000% ** DB Stats ** Uptime(secs): 58.4 total, 3.9 interval Cumulative writes: 0 writes, 16M keys, 0 commit groups, 0.0 writes per commit group, ingest: 15.38 GB, 269.65 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:9.888 H:M:S, 16.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 251.61 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.879 H:M:S, 22.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/07/15-09:20:10 ... thread 0: (1000000,17000000) ops and (274266.3,274161.3) ops/second in (3.646092,62.007284) 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 288.6 57.63 52.21 227 0.254 0 0 0.0 0.0 L3 11/0 818.91 MB 0.8 0.0 0.0 0.0 0.0 0.0 16.2 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 136/0 9.72 GB 1.0 0.0 0.0 0.0 0.0 0.0 15.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 80/0 5.72 GB 0.1 0.0 0.0 0.0 0.0 0.0 5.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 227/0 16.24 GB 0.0 0.0 0.0 0.0 16.2 16.2 37.4 1.0 0.0 288.6 57.63 52.21 227 0.254 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 15.7 15.7 36.8 1.0 0.0 290.2 55.36 50.13 219 0.253 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 288.6 57.63 52.21 227 0.254 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 62.0 total, 59.0 interval Flush(GB): cumulative 16.241, interval 15.687 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.24 GB write, 268.04 MB/s write, 0.00 GB read, 0.00 MB/s read, 57.6 seconds Interval compaction: 15.69 GB write, 272.23 MB/s write, 0.00 GB read, 0.00 MB/s read, 55.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: 67, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 67, interval: 63 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1135 Average: 402.0396 StdDev: 840.45 Min: 1 Median: 5.2703 Max: 4637 Percentiles: P50: 5.27 P75: 243.23 P99: 4055.00 P99.9: 4395.50 P99.99: 4637.00 ------------------------------------------------------ [ 0, 1 ] 277 24.405% 24.405% ##### ( 1, 2 ] 173 15.242% 39.648% ### ( 4, 6 ] 185 16.300% 55.947% ### ( 6, 10 ] 39 3.436% 59.383% # ( 10, 15 ] 1 0.088% 59.471% ( 15, 22 ] 6 0.529% 60.000% ( 170, 250 ] 186 16.388% 76.388% ### ( 250, 380 ] 6 0.529% 76.916% ( 380, 580 ] 72 6.344% 83.260% # ( 580, 870 ] 36 3.172% 86.432% # ( 870, 1300 ] 45 3.965% 90.396% # ( 1300, 1900 ] 13 1.145% 91.542% ( 1900, 2900 ] 50 4.405% 95.947% # ( 2900, 4400 ] 45 3.965% 99.912% # ( 4400, 6600 ] 1 0.088% 100.000% ** DB Stats ** Uptime(secs): 62.0 total, 3.6 interval Cumulative writes: 0 writes, 17M keys, 0 commit groups, 0.0 writes per commit group, ingest: 16.34 GB, 269.67 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:10.487 H:M:S, 16.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 269.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.599 H:M:S, 16.4 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/07/15-09:20:13 ... thread 0: (1000000,18000000) ops and (283914.3,274685.6) ops/second in (3.522190,65.529474) 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 289.0 60.82 55.12 240 0.253 0 0 0.0 0.0 L2 1/0 63.00 MB 0.6 0.0 0.0 0.0 0.0 0.0 17.2 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L3 11/0 818.91 MB 0.8 0.0 0.0 0.0 0.0 0.0 17.1 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 136/0 9.72 GB 1.0 0.0 0.0 0.0 0.0 0.0 16.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 92/0 6.58 GB 0.1 0.0 0.0 0.0 0.0 0.0 6.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 240/0 17.16 GB 0.0 0.0 0.0 0.0 17.2 17.2 57.1 1.0 0.0 289.0 60.82 55.12 240 0.253 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 16.6 16.6 56.6 1.0 0.0 290.5 58.55 53.04 232 0.252 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 289.0 60.82 55.12 240 0.253 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): 65.6 total, 62.5 interval Flush(GB): cumulative 17.163, interval 16.610 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, 268.05 MB/s write, 0.00 GB read, 0.00 MB/s read, 60.8 seconds Interval compaction: 16.61 GB write, 272.00 MB/s write, 0.00 GB read, 0.00 MB/s read, 58.6 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 70, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 70, interval: 66 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1200 Average: 397.4850 StdDev: 831.10 Min: 1 Median: 5.2718 Max: 4637 Percentiles: P50: 5.27 P75: 243.10 P99: 4048.94 P99.9: 4393.62 P99.99: 4637.00 ------------------------------------------------------ [ 0, 1 ] 291 24.250% 24.250% ##### ( 1, 2 ] 185 15.417% 39.667% ### ( 4, 6 ] 195 16.250% 55.917% ### ( 6, 10 ] 41 3.417% 59.333% # ( 10, 15 ] 2 0.167% 59.500% ( 15, 22 ] 6 0.500% 60.000% ( 170, 250 ] 197 16.417% 76.417% ### ( 250, 380 ] 6 0.500% 76.917% ( 380, 580 ] 76 6.333% 83.250% # ( 580, 870 ] 38 3.167% 86.417% # ( 870, 1300 ] 51 4.250% 90.667% # ( 1300, 1900 ] 13 1.083% 91.750% ( 1900, 2900 ] 51 4.250% 96.000% # ( 2900, 4400 ] 47 3.917% 99.917% # ( 4400, 6600 ] 1 0.083% 100.000% ** DB Stats ** Uptime(secs): 65.6 total, 3.5 interval Cumulative writes: 0 writes, 18M keys, 0 commit groups, 0.0 writes per commit group, ingest: 17.30 GB, 270.19 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:10.985 H:M:S, 16.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 279.42 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.499 H:M:S, 14.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/07/15-09:20:17 ... thread 0: (1000000,19000000) ops and (274630.9,274682.7) ops/second in (3.641251,69.170725) 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 288.7 64.14 58.13 253 0.254 0 0 0.0 0.0 L3 13/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 132/0 9.47 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 108/0 7.69 GB 0.1 0.0 0.0 0.0 0.0 0.0 7.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 253/0 18.09 GB 0.0 0.0 0.0 0.0 18.1 18.1 42.9 1.0 0.0 288.7 64.14 58.13 253 0.254 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 17.5 17.5 42.4 1.0 0.0 290.2 61.87 56.05 245 0.253 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 288.7 64.14 58.13 253 0.254 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 69.2 total, 66.2 interval Flush(GB): cumulative 18.086, interval 17.532 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, 267.60 MB/s write, 0.00 GB read, 0.00 MB/s read, 64.1 seconds Interval compaction: 17.53 GB write, 271.32 MB/s write, 0.00 GB read, 0.00 MB/s read, 61.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: 74, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 74, interval: 70 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1265 Average: 403.6814 StdDev: 841.21 Min: 1 Median: 5.2767 Max: 4637 Percentiles: P50: 5.28 P75: 243.33 P99: 4057.35 P99.9: 4392.21 P99.99: 4637.00 ------------------------------------------------------ [ 0, 1 ] 302 23.874% 23.874% ##### ( 1, 2 ] 199 15.731% 39.605% ### ( 4, 6 ] 206 16.285% 55.889% ### ( 6, 10 ] 43 3.399% 59.289% # ( 10, 15 ] 2 0.158% 59.447% ( 15, 22 ] 6 0.474% 59.921% ( 22, 34 ] 1 0.079% 60.000% ( 170, 250 ] 207 16.364% 76.364% ### ( 250, 380 ] 7 0.553% 76.917% ( 380, 580 ] 78 6.166% 83.083% # ( 580, 870 ] 40 3.162% 86.245% # ( 870, 1300 ] 53 4.190% 90.435% # ( 1300, 1900 ] 13 1.028% 91.462% ( 1900, 2900 ] 56 4.427% 95.889% # ( 2900, 4400 ] 51 4.032% 99.921% # ( 4400, 6600 ] 1 0.079% 100.000% ** DB Stats ** Uptime(secs): 69.2 total, 3.6 interval Cumulative writes: 0 writes, 19M keys, 0 commit groups, 0.0 writes per commit group, ingest: 18.26 GB, 270.20 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.594 H:M:S, 16.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 270.30 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.608 H:M:S, 16.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/07/15-09:20:21 ... thread 0: (1000000,20000000) ops and (252806.1,273499.3) ops/second in (3.955600,73.126325) 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 288.4 67.92 61.56 267 0.254 0 0 0.0 0.0 L3 11/0 818.91 MB 0.8 0.0 0.0 0.0 0.0 0.0 19.1 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 132/0 9.47 GB 1.0 0.0 0.0 0.0 0.0 0.0 18.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 124/0 8.86 GB 0.1 0.0 0.0 0.0 0.0 0.0 8.9 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 267/0 19.13 GB 0.0 0.0 0.0 0.0 19.1 19.1 46.3 1.0 0.0 288.4 67.92 61.56 267 0.254 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 18.6 18.6 45.8 1.0 0.0 289.8 65.65 59.48 259 0.253 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 288.4 67.92 61.56 267 0.254 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 73.2 total, 70.1 interval Flush(GB): cumulative 19.132, interval 18.578 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 19.13 GB write, 267.77 MB/s write, 0.00 GB read, 0.00 MB/s read, 67.9 seconds Interval compaction: 18.58 GB write, 271.28 MB/s write, 0.00 GB read, 0.00 MB/s read, 65.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: 80, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 80, interval: 76 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1335 Average: 406.5356 StdDev: 845.88 Min: 1 Median: 5.2798 Max: 4637 Percentiles: P50: 5.28 P75: 243.49 P99: 4063.18 P99.9: 4390.86 P99.99: 4637.00 ------------------------------------------------------ [ 0, 1 ] 322 24.120% 24.120% ##### ( 1, 2 ] 206 15.431% 39.551% ### ( 4, 6 ] 218 16.330% 55.880% ### ( 6, 10 ] 46 3.446% 59.326% # ( 10, 15 ] 2 0.150% 59.476% ( 15, 22 ] 6 0.449% 59.925% ( 22, 34 ] 1 0.075% 60.000% ( 170, 250 ] 218 16.330% 76.330% ### ( 250, 380 ] 7 0.524% 76.854% ( 380, 580 ] 83 6.217% 83.071% # ( 580, 870 ] 42 3.146% 86.217% # ( 870, 1300 ] 55 4.120% 90.337% # ( 1300, 1900 ] 13 0.974% 91.311% ( 1900, 2900 ] 60 4.494% 95.805% # ( 2900, 4400 ] 55 4.120% 99.925% # ( 4400, 6600 ] 1 0.075% 100.000% ** DB Stats ** Uptime(secs): 73.2 total, 4.0 interval Cumulative writes: 0 writes, 20M keys, 0 commit groups, 0.0 writes per commit group, ingest: 19.22 GB, 269.04 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:12.495 H:M:S, 17.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 248.81 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.901 H:M:S, 22.8 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 using bdev Nvme0n1 Initializing RocksDB Options from the specified file Initializing RocksDB Options from command-line flags Integrated BlobDB: blob cache disabled Keys: 16 bytes each (+ 0 bytes user-defined timestamp) Values: 1000 bytes each (1000 bytes after compression) Entries: 20000000 Prefix: 0 bytes Keys per prefix: 0 RawSize: 19378.7 MB (estimated) FileSize: 19378.7 MB (estimated) Write rate: 0 bytes/second Read rate: 0 ops/second Compression: NoCompression Compression sampling rate: 0 Memtablerep: SkipListFactory Perf Level: 1 ------------------------------------------------ Initializing RocksDB Options from the specified file Initializing RocksDB Options from command-line flags Integrated BlobDB: blob cache disabled DB path: [/mnt/rocksdb] fillseq : 3.656 micros/op 273496 ops/sec 73.127 seconds 20000000 operations; 265.0 MB/s Microseconds per write: Count: 20000000 Average: 3.6563 StdDev: 408.41 Min: 1 Median: 1.7315 Max: 346700 Percentiles: P50: 1.73 P75: 3.17 P99: 12.88 P99.9: 97.86 P99.99: 167.51 ------------------------------------------------------ [ 0, 1 ] 1055020 5.275% 5.275% # ( 1, 2 ] 12227560 61.138% 66.413% ############ ( 2, 3 ] 1298069 6.490% 72.903% # ( 3, 4 ] 2464748 12.324% 85.227% ## ( 4, 6 ] 2425010 12.125% 97.352% ## ( 6, 10 ] 290928 1.455% 98.807% ( 10, 15 ] 67073 0.335% 99.142% ( 15, 22 ] 133889 0.669% 99.811% ( 22, 34 ] 15949 0.080% 99.891% ( 34, 51 ] 1303 0.007% 99.898% ( 51, 76 ] 91 0.000% 99.898% ( 76, 110 ] 560 0.003% 99.901% ( 110, 170 ] 18570 0.093% 99.994% ( 170, 250 ] 903 0.005% 99.998% ( 250, 380 ] 207 0.001% 99.999% ( 380, 580 ] 27 0.000% 100.000% ( 580, 870 ] 9 0.000% 100.000% ( 870, 1300 ] 1 0.000% 100.000% ( 1300, 1900 ] 2 0.000% 100.000% ( 1900, 2900 ] 2 0.000% 100.000% ( 2900, 4400 ] 2 0.000% 100.000% ( 4400, 6600 ] 5 0.000% 100.000% ( 6600, 9900 ] 7 0.000% 100.000% ( 9900, 14000 ] 5 0.000% 100.000% ( 14000, 22000 ] 7 0.000% 100.000% ( 22000, 33000 ] 6 0.000% 100.000% ( 33000, 50000 ] 2 0.000% 100.000% ( 50000, 75000 ] 1 0.000% 100.000% ( 170000, 250000 ] 27 0.000% 100.000% ( 250000, 380000 ] 17 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 : 267 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 12494622 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 : 20542690393 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 : 20378277888 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 : 124511998 rocksdb.non.last.level.read.count COUNT : 1335 rocksdb.block.checksum.compute.count COUNT : 801 rocksdb.multiget.coroutine.count COUNT : 0 rocksdb.blobdb.cache.miss COUNT : 0 rocksdb.blobdb.cache.hit COUNT : 0 rocksdb.blobdb.cache.add COUNT : 0 rocksdb.blobdb.cache.add.failures COUNT : 0 rocksdb.blobdb.cache.bytes.read COUNT : 0 rocksdb.blobdb.cache.bytes.write COUNT : 0 rocksdb.read.async.micros COUNT : 0 rocksdb.async.read.error.count COUNT : 0 rocksdb.secondary.cache.filter.hits COUNT : 0 rocksdb.secondary.cache.index.hits COUNT : 0 rocksdb.secondary.cache.data.hits COUNT : 0 rocksdb.table.open.prefetch.tail.miss COUNT : 0 rocksdb.table.open.prefetch.tail.hit COUNT : 0 rocksdb.db.get.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.db.write.micros P50 : 1.000000 P95 : 4.040174 P99 : 9.065948 P100 : 346696.000000 COUNT : 20000000 SUM : 57776257 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 : 723.260000 P95 : 862.634000 P99 : 1048.000000 P100 : 1048.000000 COUNT : 267 SUM : 183841 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 : 243.475177 P95 : 2465.454545 P99 : 2842.181818 P100 : 3190.000000 COUNT : 1036 SUM : 703537 rocksdb.table.open.io.micros P50 : 2278.787879 P95 : 4310.141509 P99 : 5507.000000 P100 : 5507.000000 COUNT : 267 SUM : 634579 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 : 571.836735 P95 : 3806.923077 P99 : 4299.846154 P100 : 4777.000000 COUNT : 534 SUM : 583613 rocksdb.write.raw.block.micros P50 : 0.606415 P95 : 1.816165 P99 : 4.769705 P100 : 2419.000000 COUNT : 4983233 SUM : 15301318 rocksdb.numfiles.in.singlecompaction P50 : 1.000000 P95 : 3.597368 P99 : 3.919474 P100 : 4.000000 COUNT : 765 SUM : 1181 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 : 181851.851852 P95 : 346449.000000 P99 : 346449.000000 P100 : 346449.000000 COUNT : 80 SUM : 12494622 rocksdb.sst.read.micros P50 : 5.279817 P95 : 2720.833333 P99 : 4063.181818 P100 : 4637.000000 COUNT : 1335 SUM : 542725 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 : 218325.791855 P95 : 513633.333333 P99 : 527909.000000 P100 : 527909.000000 COUNT : 267 SUM : 67920851 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