[2024-07-12 10:53:23.723896] Starting SPDK v24.09-pre git sha1 719d03c6a / DPDK 24.03.0 initialization... [2024-07-12 10:53:23.724229] [ 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_pid2126850 ] Set seed to 1720774403716254 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-07-12 10:53:24.037562] app.c: 908:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-07-12 10:53:24.354818] app.c: 603:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-07-12 10:53:24.354875] app.c: 604:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 2126850' to capture a snapshot of events at runtime. [2024-07-12 10:53:24.354894] app.c: 609:app_setup_trace: *NOTICE*: 'spdk_trace' without parameters will also work if this is the only [2024-07-12 10:53:24.354914] app.c: 610:app_setup_trace: *NOTICE*: SPDK application currently running. [2024-07-12 10:53:24.354928] app.c: 611:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid2126850 for offline analysis/debug. [2024-07-12 10:53:24.355078] reactor.c: 941:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Fri Jul 12 10:53:31 2024 CPU: 72 * Intel(R) Xeon(R) Gold 6140 CPU @ 2.30GHz CPUCache: 25344 KB 2024/07/12-10:53:35 ... thread 0: (1000000,1000000) ops and (271354.0,271354.0) ops/second in (3.685223,3.685223) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 0/0 0.00 KB 0.0 0.0 0.0 0.0 0.8 0.8 0.0 1.0 0.0 262.0 3.13 2.87 10 0.313 0 0 0.0 0.0 L2 1/0 62.99 MB 0.6 0.0 0.0 0.0 0.0 0.0 0.8 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L3 9/0 755.92 MB 0.8 0.0 0.0 0.0 0.0 0.0 0.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 10/0 818.92 MB 0.0 0.0 0.0 0.0 0.8 0.8 1.5 1.0 0.0 262.0 3.13 2.87 10 0.313 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 0.2 0.2 0.9 1.0 0.0 198.9 0.95 0.89 2 0.475 0 0 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- High 0/0 0.00 KB 0.0 0.0 0.0 0.0 0.8 0.8 0.0 0.0 0.0 262.0 3.13 2.87 10 0.313 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.800, interval 0.185 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 0.80 GB write, 220.82 MB/s write, 0.00 GB read, 0.00 MB/s read, 3.1 seconds Interval compaction: 0.18 GB write, 275.74 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: 5, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 5, interval: 1 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 50 Average: 611.7800 StdDev: 1137.56 Min: 1 Median: 5.6667 Max: 4215 Percentiles: P50: 5.67 P75: 505.00 P99: 4215.00 P99.9: 4215.00 P99.99: 4215.00 ------------------------------------------------------ [ 0, 1 ] 9 18.000% 18.000% #### ( 1, 2 ] 6 12.000% 30.000% ## ( 2, 3 ] 5 10.000% 40.000% ## ( 4, 6 ] 6 12.000% 52.000% ## ( 6, 10 ] 4 8.000% 60.000% ## ( 250, 380 ] 5 10.000% 70.000% ## ( 380, 580 ] 4 8.000% 78.000% ## ( 870, 1300 ] 4 8.000% 86.000% ## ( 1300, 1900 ] 1 2.000% 88.000% ( 2900, 4400 ] 6 12.000% 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, 265.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.147 H:M:S, 30.9 percent Interval writes: 0 writes, 168K keys, 0 commit groups, 0.0 writes per commit group, ingest: 165.48 MB, 241.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.542 H:M:S, 79.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/07/12-10:53:40 ... thread 0: (1000000,2000000) ops and (212597.5,238408.9) ops/second in (4.703725,8.388948) 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 253.8 7.45 6.88 22 0.339 0 0 0.0 0.0 L3 10/0 881.89 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 1007.91 MB 0.1 0.0 0.0 0.0 0.0 0.0 1.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 22/0 1.85 GB 0.0 0.0 0.0 0.0 1.8 1.8 2.8 1.0 0.0 253.8 7.45 6.88 22 0.339 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.2 1.0 0.0 239.0 5.27 4.90 14 0.377 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 253.8 7.45 6.88 22 0.339 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): 8.4 total, 5.4 interval Flush(GB): cumulative 1.846, 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.85 GB write, 224.65 MB/s write, 0.00 GB read, 0.00 MB/s read, 7.4 seconds Interval compaction: 1.23 GB write, 233.79 MB/s write, 0.00 GB read, 0.00 MB/s read, 5.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: 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: 110 Average: 566.7545 StdDev: 1037.18 Min: 1 Median: 6.7273 Max: 4215 Percentiles: P50: 6.73 P75: 546.67 P99: 4215.00 P99.9: 4215.00 P99.99: 4215.00 ------------------------------------------------------ [ 0, 1 ] 16 14.545% 14.545% ### ( 1, 2 ] 15 13.636% 28.182% ### ( 2, 3 ] 12 10.909% 39.091% ## ( 4, 6 ] 10 9.091% 48.182% ## ( 6, 10 ] 11 10.000% 58.182% ## ( 10, 15 ] 1 0.909% 59.091% ( 22, 34 ] 1 0.909% 60.000% ( 250, 380 ] 9 8.182% 68.182% ## ( 380, 580 ] 9 8.182% 76.364% ## ( 870, 1300 ] 13 11.818% 88.182% ## ( 1300, 1900 ] 2 1.818% 90.000% ( 2900, 4400 ] 11 10.000% 100.000% ## ** DB Stats ** Uptime(secs): 8.4 total, 4.7 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 233.99 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.319 H:M:S, 39.5 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 209.24 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:2.172 H:M:S, 46.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/07/12-10:53:44 ... thread 0: (1000000,3000000) ops and (261641.8,245680.8) ops/second in (3.822019,12.210967) 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 261.8 10.83 9.96 33 0.328 0 0 0.0 0.0 L3 9/0 755.91 MB 0.8 0.0 0.0 0.0 0.0 0.0 2.8 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 24/0 2.03 GB 0.2 0.0 0.0 0.0 0.0 0.0 2.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 33/0 2.77 GB 0.0 0.0 0.0 0.0 2.8 2.8 4.8 1.0 0.0 261.8 10.83 9.96 33 0.328 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 254.8 8.65 7.99 25 0.346 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 261.8 10.83 9.96 33 0.328 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 12.2 total, 9.2 interval Flush(GB): cumulative 2.768, interval 2.153 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, 231.70 MB/s write, 0.00 GB read, 0.00 MB/s read, 10.8 seconds Interval compaction: 2.15 GB write, 239.36 MB/s write, 0.00 GB read, 0.00 MB/s read, 8.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: 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: 165 Average: 589.6606 StdDev: 1097.75 Min: 1 Median: 6.4000 Max: 4267 Percentiles: P50: 6.40 P75: 575.00 P99: 4254.41 P99.9: 4267.00 P99.99: 4267.00 ------------------------------------------------------ [ 0, 1 ] 27 16.364% 16.364% ### ( 1, 2 ] 25 15.152% 31.515% ### ( 2, 3 ] 12 7.273% 38.788% # ( 4, 6 ] 17 10.303% 49.091% ## ( 6, 10 ] 15 9.091% 58.182% ## ( 10, 15 ] 2 1.212% 59.394% ( 22, 34 ] 1 0.606% 60.000% ( 250, 380 ] 15 9.091% 69.091% ## ( 380, 580 ] 10 6.061% 75.152% # ( 580, 870 ] 4 2.424% 77.576% ( 870, 1300 ] 16 9.697% 87.273% ## ( 1300, 1900 ] 3 1.818% 89.091% ( 1900, 2900 ] 1 0.606% 89.697% ( 2900, 4400 ] 17 10.303% 100.000% ## ** DB Stats ** Uptime(secs): 12.2 total, 3.8 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 241.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:4.634 H:M:S, 37.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 257.50 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:1.315 H:M:S, 34.4 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/07/12-10:53:47 ... thread 0: (1000000,4000000) ops and (271096.2,251577.2) ops/second in (3.688728,15.899695) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 0/0 0.00 KB 0.0 0.0 0.0 0.0 3.8 3.8 0.0 1.0 0.0 270.4 14.21 13.01 45 0.316 0 0 0.0 0.0 L3 9/0 755.90 MB 0.8 0.0 0.0 0.0 0.0 0.0 3.8 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 36/0 3.01 GB 0.3 0.0 0.0 0.0 0.0 0.0 3.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 45/0 3.75 GB 0.0 0.0 0.0 0.0 3.8 3.8 6.8 1.0 0.0 270.4 14.21 13.01 45 0.316 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 3.1 3.1 6.2 1.0 0.0 267.0 12.03 11.03 37 0.325 0 0 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- High 0/0 0.00 KB 0.0 0.0 0.0 0.0 3.8 3.8 0.0 0.0 0.0 270.4 14.21 13.01 45 0.316 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 15.9 total, 12.9 interval Flush(GB): cumulative 3.753, 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.75 GB write, 241.32 MB/s write, 0.00 GB read, 0.00 MB/s read, 14.2 seconds Interval compaction: 3.14 GB write, 249.05 MB/s write, 0.00 GB read, 0.00 MB/s read, 12.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: 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: 225 Average: 626.5200 StdDev: 1186.42 Min: 1 Median: 5.6897 Max: 5113 Percentiles: P50: 5.69 P75: 607.19 P99: 4950.00 P99.9: 5113.00 P99.99: 5113.00 ------------------------------------------------------ [ 0, 1 ] 42 18.667% 18.667% #### ( 1, 2 ] 34 15.111% 33.778% ### ( 2, 3 ] 12 5.333% 39.111% # ( 4, 6 ] 29 12.889% 52.000% ### ( 6, 10 ] 15 6.667% 58.667% # ( 10, 15 ] 2 0.889% 59.556% ( 22, 34 ] 1 0.444% 60.000% ( 250, 380 ] 23 10.222% 70.222% ## ( 380, 580 ] 10 4.444% 74.667% # ( 580, 870 ] 8 3.556% 78.222% # ( 870, 1300 ] 19 8.444% 86.667% ## ( 1300, 1900 ] 4 1.778% 88.444% ( 1900, 2900 ] 1 0.444% 88.889% ( 2900, 4400 ] 22 9.778% 98.667% ## ( 4400, 6600 ] 3 1.333% 100.000% ** DB Stats ** Uptime(secs): 15.9 total, 3.7 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 247.24 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:5.825 H:M:S, 36.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 266.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:1.191 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/12-10:53:51 ... thread 0: (1000000,5000000) ops and (272089.4,255428.4) ops/second in (3.675263,19.574958) 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 276.1 17.57 16.06 57 0.308 0 0 0.0 0.0 L3 9/0 755.94 MB 0.8 0.0 0.0 0.0 0.0 0.0 4.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 48/0 4.00 GB 0.4 0.0 0.0 0.0 0.0 0.0 4.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 57/0 4.74 GB 0.0 0.0 0.0 0.0 4.7 4.7 8.7 1.0 0.0 276.1 17.57 16.06 57 0.308 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 274.1 15.40 14.08 49 0.314 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 276.1 17.57 16.06 57 0.308 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 19.6 total, 16.6 interval Flush(GB): cumulative 4.737, 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.74 GB write, 247.50 MB/s write, 0.00 GB read, 0.00 MB/s read, 17.6 seconds Interval compaction: 4.12 GB write, 254.63 MB/s write, 0.00 GB read, 0.00 MB/s read, 15.4 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 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: 285 Average: 614.1860 StdDev: 1162.36 Min: 1 Median: 5.4878 Max: 5113 Percentiles: P50: 5.49 P75: 622.29 P99: 4510.00 P99.9: 5113.00 P99.99: 5113.00 ------------------------------------------------------ [ 0, 1 ] 53 18.596% 18.596% #### ( 1, 2 ] 47 16.491% 35.088% ### ( 2, 3 ] 12 4.211% 39.298% # ( 4, 6 ] 41 14.386% 53.684% ### ( 6, 10 ] 15 5.263% 58.947% # ( 10, 15 ] 2 0.702% 59.649% ( 22, 34 ] 1 0.351% 60.000% ( 250, 380 ] 31 10.877% 70.877% ## ( 380, 580 ] 10 3.509% 74.386% # ( 580, 870 ] 12 4.211% 78.596% # ( 870, 1300 ] 24 8.421% 87.018% ## ( 1300, 1900 ] 5 1.754% 88.772% ( 1900, 2900 ] 1 0.351% 89.123% ( 2900, 4400 ] 28 9.825% 98.947% ## ( 4400, 6600 ] 3 1.053% 100.000% ** DB Stats ** Uptime(secs): 19.6 total, 3.7 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 251.09 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.009 H:M:S, 35.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 267.79 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:1.184 H:M:S, 32.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/07/12-10:53:55 ... thread 0: (1000000,6000000) ops and (284230.5,259816.4) ops/second in (3.518271,23.093229) 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 277.9 20.63 18.84 68 0.303 0 0 0.0 0.0 L3 8/0 629.94 MB 0.6 0.0 0.0 0.0 0.0 0.0 5.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 60/0 4.98 GB 0.5 0.0 0.0 0.0 0.0 0.0 5.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 68/0 5.60 GB 0.0 0.0 0.0 0.0 5.6 5.6 10.6 1.0 0.0 277.9 20.63 18.84 68 0.303 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 5.0 5.0 10.0 1.0 0.0 276.5 18.45 16.86 60 0.308 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 277.9 20.63 18.84 68 0.303 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 23.1 total, 20.1 interval Flush(GB): cumulative 5.598, interval 4.983 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 5.60 GB write, 247.98 MB/s write, 0.00 GB read, 0.00 MB/s read, 20.6 seconds Interval compaction: 4.98 GB write, 253.94 MB/s write, 0.00 GB read, 0.00 MB/s read, 18.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: 42, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 42, interval: 38 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 340 Average: 609.1500 StdDev: 1155.65 Min: 1 Median: 5.3846 Max: 5113 Percentiles: P50: 5.38 P75: 618.67 P99: 4382.35 P99.9: 5113.00 P99.99: 5113.00 ------------------------------------------------------ [ 0, 1 ] 62 18.235% 18.235% #### ( 1, 2 ] 60 17.647% 35.882% #### ( 2, 3 ] 12 3.529% 39.412% # ( 4, 6 ] 52 15.294% 54.706% ### ( 6, 10 ] 15 4.412% 59.118% # ( 10, 15 ] 2 0.588% 59.706% ( 22, 34 ] 1 0.294% 60.000% ( 250, 380 ] 39 11.471% 71.471% ## ( 380, 580 ] 10 2.941% 74.412% # ( 580, 870 ] 15 4.412% 78.824% # ( 870, 1300 ] 29 8.529% 87.353% ## ( 1300, 1900 ] 5 1.471% 88.824% ( 1900, 2900 ] 1 0.294% 89.118% ( 2900, 4400 ] 34 10.000% 99.118% ## ( 4400, 6600 ] 3 0.882% 100.000% ** DB Stats ** Uptime(secs): 23.1 total, 3.5 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 255.45 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:8.020 H:M:S, 34.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 279.74 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:1.011 H:M:S, 28.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/07/12-10:53:58 ... thread 0: (1000000,7000000) ops and (262876.4,260249.2) ops/second in (3.804069,26.897298) 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 279.8 24.09 21.99 80 0.301 0 0 0.0 0.0 L3 8/0 629.94 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 L4 72/0 5.97 GB 0.6 0.0 0.0 0.0 0.0 0.0 6.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 80/0 6.58 GB 0.0 0.0 0.0 0.0 6.6 6.6 12.5 1.0 0.0 279.8 24.09 21.99 80 0.301 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 6.0 6.0 11.9 1.0 0.0 278.8 21.92 20.02 72 0.304 0 0 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- High 0/0 0.00 KB 0.0 0.0 0.0 0.0 6.6 6.6 0.0 0.0 0.0 279.8 24.09 21.99 80 0.301 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 26.9 total, 23.9 interval Flush(GB): cumulative 6.582, interval 5.967 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 6.58 GB write, 250.38 MB/s write, 0.00 GB read, 0.00 MB/s read, 24.1 seconds Interval compaction: 5.97 GB write, 255.69 MB/s write, 0.00 GB read, 0.00 MB/s read, 21.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: 50, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 50, interval: 46 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 400 Average: 613.9425 StdDev: 1158.00 Min: 1 Median: 5.3651 Max: 5113 Percentiles: P50: 5.37 P75: 625.79 P99: 4364.29 P99.9: 5113.00 P99.99: 5113.00 ------------------------------------------------------ [ 0, 1 ] 70 17.500% 17.500% #### ( 1, 2 ] 75 18.750% 36.250% #### ( 2, 3 ] 12 3.000% 39.250% # ( 4, 6 ] 63 15.750% 55.000% ### ( 6, 10 ] 15 3.750% 58.750% # ( 10, 15 ] 4 1.000% 59.750% ( 22, 34 ] 1 0.250% 60.000% ( 250, 380 ] 46 11.500% 71.500% ## ( 380, 580 ] 11 2.750% 74.250% # ( 580, 870 ] 19 4.750% 79.000% # ( 870, 1300 ] 30 7.500% 86.500% ## ( 1300, 1900 ] 8 2.000% 88.500% ( 1900, 2900 ] 1 0.250% 88.750% ( 2900, 4400 ] 42 10.500% 99.250% ## ( 4400, 6600 ] 3 0.750% 100.000% ** DB Stats ** Uptime(secs): 26.9 total, 3.8 interval Cumulative writes: 0 writes, 7000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 6.73 GB, 255.91 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:9.318 H:M:S, 34.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 258.72 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:1.299 H:M:S, 34.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/07/12-10:54:02 ... thread 0: (1000000,8000000) ops and (278964.2,262450.1) ops/second in (3.584690,30.481988) 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 283.4 27.34 24.94 92 0.297 0 0 0.0 0.0 L3 8/0 629.93 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 L4 84/0 6.95 GB 0.7 0.0 0.0 0.0 0.0 0.0 7.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 92/0 7.57 GB 0.0 0.0 0.0 0.0 7.6 7.6 14.5 1.0 0.0 283.4 27.34 24.94 92 0.297 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 7.0 7.0 13.9 1.0 0.0 282.9 25.16 22.97 84 0.300 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 283.4 27.34 24.94 92 0.297 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 30.5 total, 27.5 interval Flush(GB): cumulative 7.567, interval 6.951 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, 254.00 MB/s write, 0.00 GB read, 0.00 MB/s read, 27.3 seconds Interval compaction: 6.95 GB write, 259.01 MB/s write, 0.00 GB read, 0.00 MB/s read, 25.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: 56, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 56, interval: 52 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 460 Average: 606.2261 StdDev: 1142.67 Min: 1 Median: 5.3333 Max: 5113 Percentiles: P50: 5.33 P75: 617.83 P99: 4351.02 P99.9: 5113.00 P99.99: 5113.00 ------------------------------------------------------ [ 0, 1 ] 80 17.391% 17.391% ### ( 1, 2 ] 87 18.913% 36.304% #### ( 2, 3 ] 13 2.826% 39.130% # ( 4, 6 ] 75 16.304% 55.435% ### ( 6, 10 ] 16 3.478% 58.913% # ( 10, 15 ] 4 0.870% 59.783% ( 22, 34 ] 1 0.217% 60.000% ( 250, 380 ] 54 11.739% 71.739% ## ( 380, 580 ] 12 2.609% 74.348% # ( 580, 870 ] 23 5.000% 79.348% # ( 870, 1300 ] 34 7.391% 86.739% # ( 1300, 1900 ] 8 1.739% 88.478% ( 1900, 2900 ] 1 0.217% 88.696% ( 2900, 4400 ] 49 10.652% 99.348% ## ( 4400, 6600 ] 3 0.652% 100.000% ** DB Stats ** Uptime(secs): 30.5 total, 3.6 interval Cumulative writes: 0 writes, 8000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 7.69 GB, 258.10 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:10.409 H:M:S, 34.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 274.56 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:1.091 H:M:S, 30.4 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/07/12-10:54:05 ... thread 0: (1000000,9000000) ops and (301546.2,266286.1) ops/second in (3.316241,33.798229) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 0/0 0.00 KB 0.0 0.0 0.0 0.0 8.5 8.5 0.0 1.0 0.0 287.6 30.23 27.54 104 0.291 0 0 0.0 0.0 L3 12/0 944.90 MB 0.9 0.0 0.0 0.0 0.0 0.0 8.5 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 92/0 7.57 GB 0.8 0.0 0.0 0.0 0.0 0.0 7.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 104/0 8.49 GB 0.0 0.0 0.0 0.0 8.5 8.5 16.1 1.0 0.0 287.6 30.23 27.54 104 0.291 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 7.9 7.9 15.4 1.0 0.0 287.4 28.06 25.57 96 0.292 0 0 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- High 0/0 0.00 KB 0.0 0.0 0.0 0.0 8.5 8.5 0.0 0.0 0.0 287.6 30.23 27.54 104 0.291 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): 33.8 total, 30.8 interval Flush(GB): cumulative 8.489, interval 7.874 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 8.49 GB write, 257.03 MB/s write, 0.00 GB read, 0.00 MB/s read, 30.2 seconds Interval compaction: 7.87 GB write, 261.81 MB/s write, 0.00 GB read, 0.00 MB/s read, 28.1 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 62, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 62, interval: 58 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 520 Average: 613.8000 StdDev: 1162.23 Min: 1 Median: 5.2941 Max: 5943 Percentiles: P50: 5.29 P75: 580.00 P99: 4368.42 P99.9: 5943.00 P99.99: 5943.00 ------------------------------------------------------ [ 0, 1 ] 94 18.077% 18.077% #### ( 1, 2 ] 97 18.654% 36.731% #### ( 2, 3 ] 13 2.500% 39.231% # ( 3, 4 ] 1 0.192% 39.423% ( 4, 6 ] 85 16.346% 55.769% ### ( 6, 10 ] 17 3.269% 59.038% # ( 10, 15 ] 4 0.769% 59.808% ( 22, 34 ] 1 0.192% 60.000% ( 250, 380 ] 63 12.115% 72.115% ## ( 380, 580 ] 15 2.885% 75.000% # ( 580, 870 ] 23 4.423% 79.423% # ( 870, 1300 ] 36 6.923% 86.346% # ( 1300, 1900 ] 9 1.731% 88.077% ( 1900, 2900 ] 1 0.192% 88.269% ( 2900, 4400 ] 57 10.962% 99.231% ## ( 4400, 6600 ] 4 0.769% 100.000% ** DB Stats ** Uptime(secs): 33.8 total, 3.3 interval Cumulative writes: 0 writes, 9000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 8.65 GB, 261.90 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.243 H:M:S, 33.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 296.78 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.833 H:M:S, 25.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/07/12-10:54:09 ... thread 0: (1000000,10000000) ops and (254807.7,265092.0) ops/second in (3.924528,37.722757) 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 287.9 33.70 30.70 116 0.290 0 0 0.0 0.0 L3 8/0 692.93 MB 0.7 0.0 0.0 0.0 0.0 0.0 9.5 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 108/0 8.80 GB 0.9 0.0 0.0 0.0 0.0 0.0 8.8 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 116/0 9.47 GB 0.0 0.0 0.0 0.0 9.5 9.5 18.3 1.0 0.0 287.9 33.70 30.70 116 0.290 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.7 1.0 0.0 287.8 31.52 28.73 108 0.292 0 0 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- High 0/0 0.00 KB 0.0 0.0 0.0 0.0 9.5 9.5 0.0 0.0 0.0 287.9 33.70 30.70 116 0.290 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 37.7 total, 34.7 interval Flush(GB): cumulative 9.474, interval 8.858 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, 257.01 MB/s write, 0.00 GB read, 0.00 MB/s read, 33.7 seconds Interval compaction: 8.86 GB write, 261.24 MB/s write, 0.00 GB read, 0.00 MB/s read, 31.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: 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: 580 Average: 607.1828 StdDev: 1145.98 Min: 1 Median: 5.2903 Max: 5943 Percentiles: P50: 5.29 P75: 568.89 P99: 4357.14 P99.9: 5943.00 P99.99: 5943.00 ------------------------------------------------------ [ 0, 1 ] 108 18.621% 18.621% #### ( 1, 2 ] 105 18.103% 36.724% #### ( 2, 3 ] 15 2.586% 39.310% # ( 3, 4 ] 2 0.345% 39.655% ( 4, 6 ] 93 16.034% 55.690% ### ( 6, 10 ] 20 3.448% 59.138% # ( 10, 15 ] 4 0.690% 59.828% ( 22, 34 ] 1 0.172% 60.000% ( 250, 380 ] 70 12.069% 72.069% ## ( 380, 580 ] 18 3.103% 75.172% # ( 580, 870 ] 24 4.138% 79.310% # ( 870, 1300 ] 40 6.897% 86.207% # ( 1300, 1900 ] 12 2.069% 88.276% ( 1900, 2900 ] 1 0.172% 88.448% ( 2900, 4400 ] 63 10.862% 99.310% ## ( 4400, 6600 ] 4 0.690% 100.000% ** DB Stats ** Uptime(secs): 37.7 total, 3.9 interval Cumulative writes: 0 writes, 10M keys, 0 commit groups, 0.0 writes per commit group, ingest: 9.61 GB, 260.74 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.638 H:M:S, 33.5 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 250.78 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:1.395 H:M:S, 35.6 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/07/12-10:54:13 ... thread 0: (1000000,11000000) ops and (262734.1,264875.9) ops/second in (3.806130,41.528887) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 0/0 0.00 KB 0.0 0.0 0.0 0.0 10.5 10.5 0.0 1.0 0.0 288.2 37.15 33.85 128 0.290 0 0 0.0 0.0 L3 8/0 692.95 MB 0.7 0.0 0.0 0.0 0.0 0.0 10.5 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 116/0 9.47 GB 1.0 0.0 0.0 0.0 0.0 0.0 9.8 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 4/0 314.97 MB 0.0 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 128/0 10.46 GB 0.0 0.0 0.0 0.0 10.5 10.5 20.5 1.0 0.0 288.2 37.15 33.85 128 0.290 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 9.8 9.8 19.9 1.0 0.0 288.1 34.98 31.88 120 0.291 0 0 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- High 0/0 0.00 KB 0.0 0.0 0.0 0.0 10.5 10.5 0.0 0.0 0.0 288.2 37.15 33.85 128 0.290 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 41.6 total, 38.5 interval Flush(GB): cumulative 10.458, 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.46 GB write, 257.72 MB/s write, 0.00 GB read, 0.00 MB/s read, 37.2 seconds Interval compaction: 9.84 GB write, 261.59 MB/s write, 0.00 GB read, 0.00 MB/s read, 35.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: 78, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 78, interval: 74 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 640 Average: 598.7062 StdDev: 1132.15 Min: 1 Median: 5.2571 Max: 5943 Percentiles: P50: 5.26 P75: 580.00 P99: 4368.66 P99.9: 5943.00 P99.99: 5943.00 ------------------------------------------------------ [ 0, 1 ] 116 18.125% 18.125% #### ( 1, 2 ] 121 18.906% 37.031% #### ( 2, 3 ] 15 2.344% 39.375% ( 3, 4 ] 2 0.312% 39.688% ( 4, 6 ] 105 16.406% 56.094% ### ( 6, 10 ] 20 3.125% 59.219% # ( 10, 15 ] 4 0.625% 59.844% ( 22, 34 ] 1 0.156% 60.000% ( 250, 380 ] 78 12.188% 72.188% ## ( 380, 580 ] 18 2.812% 75.000% # ( 580, 870 ] 29 4.531% 79.531% # ( 870, 1300 ] 44 6.875% 86.406% # ( 1300, 1900 ] 14 2.188% 88.594% ( 1900, 2900 ] 1 0.156% 88.750% ( 2900, 4400 ] 67 10.469% 99.219% ## ( 4400, 6600 ] 5 0.781% 100.000% ** DB Stats ** Uptime(secs): 41.6 total, 3.8 interval Cumulative writes: 0 writes, 11M keys, 0 commit groups, 0.0 writes per commit group, ingest: 10.57 GB, 260.54 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:13.941 H:M:S, 33.5 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 258.58 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:1.303 H:M:S, 34.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/07/12-10:54:17 ... thread 0: (1000000,12000000) ops and (267608.6,265101.5) ops/second in (3.736800,45.265687) 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 288.8 40.56 36.94 140 0.290 0 0 0.0 0.0 L3 8/0 692.92 MB 0.7 0.0 0.0 0.0 0.0 0.0 11.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 116/0 9.47 GB 1.0 0.0 0.0 0.0 0.0 0.0 10.8 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 16/0 1.29 GB 0.0 0.0 0.0 0.0 0.0 0.0 1.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 140/0 11.44 GB 0.0 0.0 0.0 0.0 11.4 11.4 23.5 1.0 0.0 288.8 40.56 36.94 140 0.290 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 10.8 10.8 22.9 1.0 0.0 288.8 38.39 34.97 132 0.291 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 288.8 40.56 36.94 140 0.290 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 45.3 total, 42.3 interval Flush(GB): cumulative 11.442, interval 10.827 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, 258.71 MB/s write, 0.00 GB read, 0.00 MB/s read, 40.6 seconds Interval compaction: 10.83 GB write, 262.31 MB/s write, 0.00 GB read, 0.00 MB/s read, 38.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: 86, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 86, interval: 82 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 700 Average: 608.5486 StdDev: 1148.77 Min: 1 Median: 5.2632 Max: 5943 Percentiles: P50: 5.26 P75: 588.79 P99: 4360.53 P99.9: 5943.00 P99.99: 5943.00 ------------------------------------------------------ [ 0, 1 ] 130 18.571% 18.571% #### ( 1, 2 ] 130 18.571% 37.143% #### ( 2, 3 ] 15 2.143% 39.286% ( 3, 4 ] 3 0.429% 39.714% ( 4, 6 ] 114 16.286% 56.000% ### ( 6, 10 ] 23 3.286% 59.286% # ( 10, 15 ] 4 0.571% 59.857% ( 22, 34 ] 1 0.143% 60.000% ( 250, 380 ] 86 12.286% 72.286% ## ( 380, 580 ] 18 2.571% 74.857% # ( 580, 870 ] 33 4.714% 79.571% # ( 870, 1300 ] 45 6.429% 86.000% # ( 1300, 1900 ] 16 2.286% 88.286% ( 1900, 2900 ] 1 0.143% 88.429% ( 2900, 4400 ] 76 10.857% 99.286% ## ( 4400, 6600 ] 5 0.714% 100.000% ** DB Stats ** Uptime(secs): 45.3 total, 3.7 interval Cumulative writes: 0 writes, 12M keys, 0 commit groups, 0.0 writes per commit group, ingest: 11.53 GB, 260.78 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:15.160 H:M:S, 33.5 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 263.38 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:1.219 H:M:S, 32.6 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/07/12-10:54:22 ... thread 0: (1000000,13000000) ops and (176343.4,255220.0) ops/second in (5.670754,50.936441) 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 277.8 45.81 41.85 151 0.303 0 0 0.0 0.0 L3 7/0 692.94 MB 0.7 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 120/0 9.72 GB 1.0 0.0 0.0 0.0 0.0 0.0 11.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 24/0 2.03 GB 0.0 0.0 0.0 0.0 0.0 0.0 2.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 151/0 12.43 GB 0.0 0.0 0.0 0.0 12.4 12.4 26.2 1.0 0.0 277.8 45.81 41.85 151 0.303 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.6 1.0 0.0 277.2 43.63 39.88 143 0.305 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 277.8 45.81 41.85 151 0.303 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 51.0 total, 47.9 interval Flush(GB): cumulative 12.426, 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.43 GB write, 249.70 MB/s write, 0.00 GB read, 0.00 MB/s read, 45.8 seconds Interval compaction: 11.81 GB write, 252.31 MB/s write, 0.00 GB read, 0.00 MB/s read, 43.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: 93, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 93, interval: 89 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 755 Average: 606.3894 StdDev: 1137.12 Min: 1 Median: 5.3478 Max: 5943 Percentiles: P50: 5.35 P75: 607.72 P99: 4352.19 P99.9: 5943.00 P99.99: 5943.00 ------------------------------------------------------ [ 0, 1 ] 130 17.219% 17.219% ### ( 1, 2 ] 137 18.146% 35.364% #### ( 2, 3 ] 30 3.974% 39.338% # ( 3, 4 ] 3 0.397% 39.735% ( 4, 6 ] 115 15.232% 54.967% ### ( 6, 10 ] 32 4.238% 59.205% # ( 10, 15 ] 5 0.662% 59.868% ( 22, 34 ] 1 0.132% 60.000% ( 250, 380 ] 87 11.523% 71.523% ## ( 380, 580 ] 23 3.046% 74.570% # ( 580, 870 ] 34 4.503% 79.073% # ( 870, 1300 ] 55 7.285% 86.358% # ( 1300, 1900 ] 16 2.119% 88.477% ( 1900, 2900 ] 2 0.265% 88.742% ( 2900, 4400 ] 80 10.596% 99.338% ## ( 4400, 6600 ] 5 0.662% 100.000% ** DB Stats ** Uptime(secs): 51.0 total, 5.7 interval Cumulative writes: 0 writes, 13M keys, 0 commit groups, 0.0 writes per commit group, ingest: 12.49 GB, 251.07 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:17.917 H:M:S, 35.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 173.55 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:2.757 H:M:S, 48.6 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/07/12-10:54:26 ... thread 0: (1000000,14000000) ops and (258146.2,255426.8) ops/second in (3.873774,54.810215) 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 277.8 49.21 44.95 162 0.304 0 0 0.0 0.0 L3 10/0 881.91 MB 0.9 0.0 0.0 0.0 0.0 0.0 13.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 116/0 9.47 GB 1.0 0.0 0.0 0.0 0.0 0.0 12.5 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 36/0 3.01 GB 0.0 0.0 0.0 0.0 0.0 0.0 3.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 162/0 13.35 GB 0.0 0.0 0.0 0.0 13.3 13.3 28.9 1.0 0.0 277.8 49.21 44.95 162 0.304 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 12.7 12.7 28.2 1.0 0.0 277.2 47.03 42.97 154 0.305 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 277.8 49.21 44.95 162 0.304 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.8 total, 51.8 interval Flush(GB): cumulative 13.349, 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.35 GB write, 249.29 MB/s write, 0.00 GB read, 0.00 MB/s read, 49.2 seconds Interval compaction: 12.73 GB write, 251.68 MB/s write, 0.00 GB read, 0.00 MB/s read, 47.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: 100, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 100, interval: 96 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 810 Average: 607.2765 StdDev: 1137.02 Min: 1 Median: 5.3548 Max: 5943 Percentiles: P50: 5.35 P75: 620.90 P99: 4346.55 P99.9: 5943.00 P99.99: 5943.00 ------------------------------------------------------ [ 0, 1 ] 139 17.160% 17.160% ### ( 1, 2 ] 146 18.025% 35.185% #### ( 2, 3 ] 33 4.074% 39.259% # ( 3, 4 ] 3 0.370% 39.630% ( 4, 6 ] 124 15.309% 54.938% ### ( 6, 10 ] 34 4.198% 59.136% # ( 10, 15 ] 6 0.741% 59.877% ( 22, 34 ] 1 0.123% 60.000% ( 250, 380 ] 93 11.481% 71.481% ## ( 380, 580 ] 23 2.840% 74.321% # ( 580, 870 ] 39 4.815% 79.136% # ( 870, 1300 ] 57 7.037% 86.173% # ( 1300, 1900 ] 18 2.222% 88.395% ( 1900, 2900 ] 2 0.247% 88.642% ( 2900, 4400 ] 87 10.741% 99.383% ## ( 4400, 6600 ] 5 0.617% 100.000% ** DB Stats ** Uptime(secs): 54.8 total, 3.9 interval Cumulative writes: 0 writes, 14M keys, 0 commit groups, 0.0 writes per commit group, ingest: 13.46 GB, 251.28 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:19.191 H:M:S, 35.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 254.07 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:1.273 H:M:S, 32.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/07/12-10:54:32 ... thread 0: (1000000,15000000) ops and (190249.3,249723.3) ops/second in (5.256262,60.066477) 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 275.0 53.38 48.74 178 0.300 0 0 0.0 0.0 L3 14/0 881.91 MB 0.9 0.0 0.0 0.0 0.0 0.0 14.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 116/0 9.47 GB 1.0 0.0 0.0 0.0 0.0 0.0 13.5 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 48/0 4.00 GB 0.0 0.0 0.0 0.0 0.0 0.0 4.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 178/0 14.33 GB 0.0 0.0 0.0 0.0 14.3 14.3 31.8 1.0 0.0 275.0 53.38 48.74 178 0.300 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 13.7 13.7 31.2 1.0 0.0 274.4 51.20 46.76 170 0.301 0 0 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- High 0/0 0.00 KB 0.0 0.0 0.0 0.0 14.3 14.3 0.0 0.0 0.0 275.0 53.38 48.74 178 0.300 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 60.1 total, 57.1 interval Flush(GB): cumulative 14.333, 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.33 GB write, 244.26 MB/s write, 0.00 GB read, 0.00 MB/s read, 53.4 seconds Interval compaction: 13.72 GB write, 246.16 MB/s write, 0.00 GB read, 0.00 MB/s read, 51.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: 100, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 100, interval: 96 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 890 Average: 619.8753 StdDev: 1160.08 Min: 1 Median: 5.4046 Max: 5943 Percentiles: P50: 5.40 P75: 591.15 P99: 4356.06 P99.9: 5943.00 P99.99: 5943.00 ------------------------------------------------------ [ 0, 1 ] 147 16.517% 16.517% ### ( 1, 2 ] 162 18.202% 34.719% #### ( 2, 3 ] 41 4.607% 39.326% # ( 3, 4 ] 3 0.337% 39.663% ( 4, 6 ] 131 14.719% 54.382% ### ( 6, 10 ] 41 4.607% 58.989% # ( 10, 15 ] 8 0.899% 59.888% ( 22, 34 ] 1 0.112% 60.000% ( 250, 380 ] 101 11.348% 71.348% ## ( 380, 580 ] 31 3.483% 74.831% # ( 580, 870 ] 39 4.382% 79.213% # ( 870, 1300 ] 59 6.629% 85.843% # ( 1300, 1900 ] 18 2.022% 87.865% ( 1900, 2900 ] 3 0.337% 88.202% ( 2900, 4400 ] 99 11.124% 99.326% ## ( 4400, 6600 ] 6 0.674% 100.000% ** DB Stats ** Uptime(secs): 60.1 total, 5.3 interval Cumulative writes: 0 writes, 15M keys, 0 commit groups, 0.0 writes per commit group, ingest: 14.42 GB, 245.68 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:19.191 H:M:S, 31.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 187.23 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.000 H:M:S, 0.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/07/12-10:54:37 ... thread 0: (1000000,16000000) ops and (172381.1,242911.6) ops/second in (5.801099,65.867576) 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 267.9 58.32 53.31 192 0.304 0 0 0.0 0.0 L3 12/0 818.90 MB 0.8 0.0 0.0 0.0 0.0 0.0 15.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 120/0 9.47 GB 1.0 0.0 0.0 0.0 0.0 0.0 14.5 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 60/0 4.98 GB 0.1 0.0 0.0 0.0 0.0 0.0 5.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 192/0 15.26 GB 0.0 0.0 0.0 0.0 15.3 15.3 34.7 1.0 0.0 267.9 58.32 53.31 192 0.304 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 14.6 14.6 34.1 1.0 0.0 267.0 56.14 51.34 184 0.305 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 267.9 58.32 53.31 192 0.304 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.9 total, 62.9 interval Flush(GB): cumulative 15.256, interval 14.641 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, 237.09 MB/s write, 0.00 GB read, 0.00 MB/s read, 58.3 seconds Interval compaction: 14.64 GB write, 238.48 MB/s write, 0.00 GB read, 0.00 MB/s read, 56.1 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 101, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 101, interval: 97 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 960 Average: 629.2760 StdDev: 1172.24 Min: 1 Median: 5.5115 Max: 5943 Percentiles: P50: 5.51 P75: 580.00 P99: 4350.91 P99.9: 5943.00 P99.99: 5943.00 ------------------------------------------------------ [ 0, 1 ] 147 15.312% 15.312% ### ( 1, 2 ] 168 17.500% 32.812% #### ( 2, 3 ] 63 6.562% 39.375% # ( 3, 4 ] 3 0.312% 39.688% ( 4, 6 ] 131 13.646% 53.333% ### ( 6, 10 ] 52 5.417% 58.750% # ( 10, 15 ] 11 1.146% 59.896% ( 22, 34 ] 1 0.104% 60.000% ( 250, 380 ] 101 10.521% 70.521% ## ( 380, 580 ] 43 4.479% 75.000% # ( 580, 870 ] 40 4.167% 79.167% # ( 870, 1300 ] 62 6.458% 85.625% # ( 1300, 1900 ] 19 1.979% 87.604% ( 1900, 2900 ] 3 0.312% 87.917% ( 2900, 4400 ] 110 11.458% 99.375% ## ( 4400, 6600 ] 6 0.625% 100.000% ** DB Stats ** Uptime(secs): 65.9 total, 5.8 interval Cumulative writes: 0 writes, 16M keys, 0 commit groups, 0.0 writes per commit group, ingest: 15.38 GB, 238.99 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:19.673 H:M:S, 29.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 169.66 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.482 H:M:S, 8.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/07/12-10:54:43 ... thread 0: (1000000,17000000) ops and (183941.3,238415.5) ops/second in (5.436518,71.304094) 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 262.5 63.11 57.76 207 0.305 0 0 0.0 0.0 L2 1/0 62.99 MB 0.6 0.0 0.0 0.0 0.0 0.0 16.2 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L3 14/0 881.92 MB 0.9 0.0 0.0 0.0 0.0 0.0 16.1 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 124/0 9.66 GB 1.0 0.0 0.0 0.0 0.0 0.0 15.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 68/0 5.60 GB 0.1 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 Sum 207/0 16.18 GB 0.0 0.0 0.0 0.0 16.2 16.2 53.2 1.0 0.0 262.5 63.11 57.76 207 0.305 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 15.6 15.6 52.5 1.0 0.0 261.5 60.94 55.79 199 0.306 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 262.5 63.11 57.76 207 0.305 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 71.3 total, 68.3 interval Flush(GB): cumulative 16.179, interval 15.564 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 16.18 GB write, 232.27 MB/s write, 0.00 GB read, 0.00 MB/s read, 63.1 seconds Interval compaction: 15.56 GB write, 233.33 MB/s write, 0.00 GB read, 0.00 MB/s read, 60.9 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 101, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 101, interval: 97 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1035 Average: 627.6618 StdDev: 1165.33 Min: 1 Median: 5.6260 Max: 5943 Percentiles: P50: 5.63 P75: 563.90 P99: 4345.17 P99.9: 5943.00 P99.99: 5943.00 ------------------------------------------------------ [ 0, 1 ] 147 14.203% 14.203% ### ( 1, 2 ] 177 17.101% 31.304% ### ( 2, 3 ] 82 7.923% 39.227% ## ( 3, 4 ] 5 0.483% 39.710% ( 4, 6 ] 131 12.657% 52.367% ### ( 6, 10 ] 65 6.280% 58.647% # ( 10, 15 ] 13 1.256% 59.903% ( 22, 34 ] 1 0.097% 60.000% ( 250, 380 ] 101 9.758% 69.758% ## ( 380, 580 ] 59 5.700% 75.459% # ( 580, 870 ] 40 3.865% 79.324% # ( 870, 1300 ] 65 6.280% 85.604% # ( 1300, 1900 ] 20 1.932% 87.536% ( 1900, 2900 ] 4 0.386% 87.923% ( 2900, 4400 ] 119 11.498% 99.420% ## ( 4400, 6600 ] 6 0.580% 100.000% ** DB Stats ** Uptime(secs): 71.3 total, 5.4 interval Cumulative writes: 0 writes, 17M keys, 0 commit groups, 0.0 writes per commit group, ingest: 16.34 GB, 234.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:19.673 H:M:S, 27.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 181.03 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.000 H:M:S, 0.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/07/12-10:54:48 ... thread 0: (1000000,18000000) ops and (187850.8,234902.7) ops/second in (5.323375,76.627469) 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 263.7 66.89 61.15 224 0.299 0 0 0.0 0.0 L3 12/0 755.91 MB 0.8 0.0 0.0 0.0 0.0 0.0 17.2 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 128/0 9.54 GB 1.0 0.0 0.0 0.0 0.0 0.0 16.5 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 84/0 6.95 GB 0.1 0.0 0.0 0.0 0.0 0.0 7.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 224/0 17.22 GB 0.0 0.0 0.0 0.0 17.2 17.2 40.7 1.0 0.0 263.7 66.89 61.15 224 0.299 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 16.6 16.6 40.0 1.0 0.0 262.8 64.71 59.18 216 0.300 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 263.7 66.89 61.15 224 0.299 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): 76.7 total, 73.6 interval Flush(GB): cumulative 17.225, 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.22 GB write, 230.11 MB/s write, 0.00 GB read, 0.00 MB/s read, 66.9 seconds Interval compaction: 16.61 GB write, 231.00 MB/s write, 0.00 GB read, 0.00 MB/s read, 64.7 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 101, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 101, interval: 97 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1120 Average: 632.1223 StdDev: 1171.97 Min: 1 Median: 5.6454 Max: 5943 Percentiles: P50: 5.65 P75: 550.97 P99: 4341.35 P99.9: 5943.00 P99.99: 5943.00 ------------------------------------------------------ [ 0, 1 ] 159 14.196% 14.196% ### ( 1, 2 ] 196 17.500% 31.696% #### ( 2, 3 ] 84 7.500% 39.196% ## ( 3, 4 ] 5 0.446% 39.643% ( 4, 6 ] 141 12.589% 52.232% ### ( 6, 10 ] 72 6.429% 58.661% # ( 10, 15 ] 14 1.250% 59.911% ( 22, 34 ] 1 0.089% 60.000% ( 250, 380 ] 115 10.268% 70.268% ## ( 380, 580 ] 62 5.536% 75.804% # ( 580, 870 ] 40 3.571% 79.375% # ( 870, 1300 ] 67 5.982% 85.357% # ( 1300, 1900 ] 20 1.786% 87.143% ( 1900, 2900 ] 5 0.446% 87.589% ( 2900, 4400 ] 133 11.875% 99.464% ## ( 4400, 6600 ] 6 0.536% 100.000% ** DB Stats ** Uptime(secs): 76.7 total, 5.3 interval Cumulative writes: 0 writes, 18M keys, 0 commit groups, 0.0 writes per commit group, ingest: 17.30 GB, 231.12 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:19.673 H:M:S, 25.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 184.88 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.000 H:M:S, 0.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/07/12-10:54:53 ... thread 0: (1000000,19000000) ops and (188199.3,231874.2) ops/second in (5.313516,81.940985) 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 263.2 70.61 64.56 239 0.295 0 0 0.0 0.0 L2 1/0 62.99 MB 0.6 0.0 0.0 0.0 0.0 0.0 18.1 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L3 14/0 881.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.66 GB 1.0 0.0 0.0 0.0 0.0 0.0 17.2 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 92/0 7.57 GB 0.1 0.0 0.0 0.0 0.0 0.0 7.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 239/0 18.15 GB 0.0 0.0 0.0 0.0 18.1 18.1 61.0 1.0 0.0 263.2 70.61 64.56 239 0.295 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 17.5 17.5 60.4 1.0 0.0 262.3 68.44 62.58 231 0.296 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 263.2 70.61 64.56 239 0.295 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): 82.0 total, 78.9 interval Flush(GB): cumulative 18.148, 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.15 GB write, 226.72 MB/s write, 0.00 GB read, 0.00 MB/s read, 70.6 seconds Interval compaction: 17.53 GB write, 227.42 MB/s write, 0.00 GB read, 0.00 MB/s read, 68.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: 101, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 101, interval: 97 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1195 Average: 631.0427 StdDev: 1169.48 Min: 1 Median: 5.6803 Max: 5943 Percentiles: P50: 5.68 P75: 542.50 P99: 4337.59 P99.9: 5943.00 P99.99: 5943.00 ------------------------------------------------------ [ 0, 1 ] 164 13.724% 13.724% ### ( 1, 2 ] 213 17.824% 31.548% #### ( 2, 3 ] 92 7.699% 39.247% ## ( 3, 4 ] 5 0.418% 39.665% ( 4, 6 ] 147 12.301% 51.967% ## ( 6, 10 ] 79 6.611% 58.577% # ( 10, 15 ] 15 1.255% 59.833% ( 22, 34 ] 1 0.084% 59.916% ( 76, 110 ] 1 0.084% 60.000% ( 250, 380 ] 124 10.377% 70.377% ## ( 380, 580 ] 68 5.690% 76.067% # ( 580, 870 ] 40 3.347% 79.414% # ( 870, 1300 ] 71 5.941% 85.356% # ( 1300, 1900 ] 21 1.757% 87.113% ( 1900, 2900 ] 5 0.418% 87.531% ( 2900, 4400 ] 143 11.967% 99.498% ## ( 4400, 6600 ] 6 0.502% 100.000% ** DB Stats ** Uptime(secs): 82.0 total, 5.3 interval Cumulative writes: 0 writes, 19M keys, 0 commit groups, 0.0 writes per commit group, ingest: 18.26 GB, 228.14 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:19.673 H:M:S, 24.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 185.22 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.000 H:M:S, 0.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/07/12-10:54:59 ... thread 0: (1000000,20000000) ops and (171607.7,227872.9) ops/second in (5.827246,87.768231) 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 258.2 75.88 69.44 254 0.299 0 0 0.0 0.0 L2 1/0 63.00 MB 0.6 0.0 0.0 0.0 0.0 0.0 19.1 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L3 13/0 881.94 MB 0.9 0.0 0.0 0.0 0.0 0.0 19.1 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 136/0 9.72 GB 1.0 0.0 0.0 0.0 0.0 0.0 18.2 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 104/0 8.49 GB 0.1 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 Sum 254/0 19.13 GB 0.0 0.0 0.0 0.0 19.1 19.1 64.9 1.0 0.0 258.2 75.88 69.44 254 0.299 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 18.5 18.5 64.3 1.0 0.0 257.3 73.70 67.47 246 0.300 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 258.2 75.88 69.44 254 0.299 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): 87.8 total, 84.8 interval Flush(GB): cumulative 19.132, interval 18.517 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, 223.15 MB/s write, 0.00 GB read, 0.00 MB/s read, 75.9 seconds Interval compaction: 18.52 GB write, 223.68 MB/s write, 0.00 GB read, 0.00 MB/s read, 73.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: 103, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 103, interval: 99 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1270 Average: 634.0874 StdDev: 1170.39 Min: 1 Median: 5.7823 Max: 5943 Percentiles: P50: 5.78 P75: 542.20 P99: 4334.74 P99.9: 5943.00 P99.99: 5943.00 ------------------------------------------------------ [ 0, 1 ] 164 12.913% 12.913% ### ( 1, 2 ] 221 17.402% 30.315% ### ( 2, 3 ] 114 8.976% 39.291% ## ( 3, 4 ] 5 0.394% 39.685% ( 4, 6 ] 147 11.575% 51.260% ## ( 6, 10 ] 89 7.008% 58.268% # ( 10, 15 ] 20 1.575% 59.843% ( 22, 34 ] 1 0.079% 59.921% ( 76, 110 ] 1 0.079% 60.000% ( 250, 380 ] 124 9.764% 69.764% ## ( 380, 580 ] 82 6.457% 76.220% # ( 580, 870 ] 40 3.150% 79.370% # ( 870, 1300 ] 76 5.984% 85.354% # ( 1300, 1900 ] 21 1.654% 87.008% ( 1900, 2900 ] 5 0.394% 87.402% ( 2900, 4400 ] 154 12.126% 99.528% ## ( 4400, 6600 ] 6 0.472% 100.000% ** DB Stats ** Uptime(secs): 87.8 total, 5.8 interval Cumulative writes: 0 writes, 20M keys, 0 commit groups, 0.0 writes per commit group, ingest: 19.22 GB, 224.21 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:20.177 H:M:S, 23.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 168.89 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.504 H:M:S, 8.6 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 : 4.388 micros/op 227868 ops/sec 87.770 seconds 20000000 operations; 220.8 MB/s Microseconds per write: Count: 20000000 Average: 4.3884 StdDev: 590.78 Min: 1 Median: 1.9618 Max: 686115 Percentiles: P50: 1.96 P75: 3.37 P99: 13.64 P99.9: 112.36 P99.99: 358.22 ------------------------------------------------------ [ 0, 1 ] 5804044 29.020% 29.020% ###### ( 1, 2 ] 4362542 21.813% 50.833% #### ( 2, 3 ] 3819961 19.100% 69.933% #### ( 3, 4 ] 2740074 13.700% 83.633% ### ( 4, 6 ] 1334381 6.672% 90.305% # ( 6, 10 ] 1489930 7.450% 97.755% # ( 10, 15 ] 342022 1.710% 99.465% ( 15, 22 ] 67474 0.337% 99.802% ( 22, 34 ] 15150 0.076% 99.878% ( 34, 51 ] 2861 0.014% 99.892% ( 51, 76 ] 921 0.005% 99.897% ( 76, 110 ] 285 0.001% 99.898% ( 110, 170 ] 9018 0.045% 99.943% ( 170, 250 ] 4215 0.021% 99.964% ( 250, 380 ] 6153 0.031% 99.995% ( 380, 580 ] 671 0.003% 99.999% ( 580, 870 ] 168 0.001% 99.999% ( 870, 1300 ] 11 0.000% 99.999% ( 1300, 1900 ] 4 0.000% 99.999% ( 1900, 2900 ] 7 0.000% 99.999% ( 2900, 4400 ] 2 0.000% 99.999% ( 4400, 6600 ] 2 0.000% 99.999% ( 6600, 9900 ] 4 0.000% 100.000% ( 9900, 14000 ] 4 0.000% 100.000% ( 14000, 22000 ] 21 0.000% 100.000% ( 22000, 33000 ] 10 0.000% 100.000% ( 33000, 50000 ] 3 0.000% 100.000% ( 50000, 75000 ] 3 0.000% 100.000% ( 110000, 170000 ] 2 0.000% 100.000% ( 170000, 250000 ] 7 0.000% 100.000% ( 250000, 380000 ] 35 0.000% 100.000% ( 380000, 570000 ] 14 0.000% 100.000% ( 570000, 860000 ] 1 0.000% 100.000% STATISTICS: rocksdb.block.cache.miss COUNT : 0 rocksdb.block.cache.hit COUNT : 0 rocksdb.block.cache.add COUNT : 0 rocksdb.block.cache.add.failures COUNT : 0 rocksdb.block.cache.index.miss COUNT : 0 rocksdb.block.cache.index.hit COUNT : 0 rocksdb.block.cache.index.add COUNT : 0 rocksdb.block.cache.index.bytes.insert COUNT : 0 rocksdb.block.cache.filter.miss COUNT : 0 rocksdb.block.cache.filter.hit COUNT : 0 rocksdb.block.cache.filter.add COUNT : 0 rocksdb.block.cache.filter.bytes.insert COUNT : 0 rocksdb.block.cache.data.miss COUNT : 0 rocksdb.block.cache.data.hit COUNT : 0 rocksdb.block.cache.data.add COUNT : 0 rocksdb.block.cache.data.bytes.insert COUNT : 0 rocksdb.block.cache.bytes.read COUNT : 0 rocksdb.block.cache.bytes.write COUNT : 0 rocksdb.bloom.filter.useful COUNT : 0 rocksdb.bloom.filter.full.positive COUNT : 0 rocksdb.bloom.filter.full.true.positive COUNT : 0 rocksdb.persistent.cache.hit COUNT : 0 rocksdb.persistent.cache.miss COUNT : 0 rocksdb.sim.block.cache.hit COUNT : 0 rocksdb.sim.block.cache.miss COUNT : 0 rocksdb.memtable.hit COUNT : 0 rocksdb.memtable.miss COUNT : 0 rocksdb.l0.hit COUNT : 0 rocksdb.l1.hit COUNT : 0 rocksdb.l2andup.hit COUNT : 0 rocksdb.compaction.key.drop.new COUNT : 0 rocksdb.compaction.key.drop.obsolete COUNT : 0 rocksdb.compaction.key.drop.range_del COUNT : 0 rocksdb.compaction.key.drop.user COUNT : 0 rocksdb.compaction.range_del.drop.obsolete COUNT : 0 rocksdb.compaction.optimized.del.drop.obsolete COUNT : 0 rocksdb.compaction.cancelled COUNT : 0 rocksdb.number.keys.written COUNT : 20000000 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 20640000000 rocksdb.bytes.read COUNT : 0 rocksdb.number.db.seek COUNT : 0 rocksdb.number.db.next COUNT : 0 rocksdb.number.db.prev COUNT : 0 rocksdb.number.db.seek.found COUNT : 0 rocksdb.number.db.next.found COUNT : 0 rocksdb.number.db.prev.found COUNT : 0 rocksdb.db.iter.bytes.read COUNT : 0 rocksdb.no.file.opens COUNT : 254 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 20176618 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 : 20542692220 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 : 20378279936 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 : 124509425 rocksdb.non.last.level.read.count COUNT : 1270 rocksdb.block.checksum.compute.count COUNT : 762 rocksdb.multiget.coroutine.count COUNT : 0 rocksdb.blobdb.cache.miss COUNT : 0 rocksdb.blobdb.cache.hit COUNT : 0 rocksdb.blobdb.cache.add COUNT : 0 rocksdb.blobdb.cache.add.failures COUNT : 0 rocksdb.blobdb.cache.bytes.read COUNT : 0 rocksdb.blobdb.cache.bytes.write COUNT : 0 rocksdb.read.async.micros COUNT : 0 rocksdb.async.read.error.count COUNT : 0 rocksdb.secondary.cache.filter.hits COUNT : 0 rocksdb.secondary.cache.index.hits COUNT : 0 rocksdb.secondary.cache.data.hits COUNT : 0 rocksdb.table.open.prefetch.tail.miss COUNT : 0 rocksdb.table.open.prefetch.tail.hit COUNT : 0 rocksdb.db.get.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.db.write.micros P50 : 0.984577 P95 : 8.152625 P99 : 12.928040 P100 : 686111.000000 COUNT : 20000000 SUM : 72890116 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 : 519.560440 P95 : 753.000000 P99 : 753.000000 P100 : 753.000000 COUNT : 254 SUM : 138520 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 : 121.769231 P95 : 229.238095 P99 : 2234.666667 P100 : 2828.000000 COUNT : 998 SUM : 161809 rocksdb.table.open.io.micros P50 : 3540.776699 P95 : 6215.820896 P99 : 6549.432836 P100 : 6921.000000 COUNT : 254 SUM : 919177 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 : 1036.625000 P95 : 4255.033557 P99 : 5584.000000 P100 : 6013.000000 COUNT : 508 SUM : 855548 rocksdb.write.raw.block.micros P50 : 0.725878 P95 : 1.961894 P99 : 6.473810 P100 : 5407.000000 COUNT : 4982913 SUM : 16063251 rocksdb.numfiles.in.singlecompaction P50 : 1.000000 P95 : 3.569767 P99 : 3.913953 P100 : 4.000000 COUNT : 740 SUM : 1105 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 : 232857.142857 P95 : 509346.153846 P99 : 569561.538462 P100 : 685860.000000 COUNT : 103 SUM : 20176618 rocksdb.sst.read.micros P50 : 5.782313 P95 : 3839.935065 P99 : 4334.740260 P100 : 5943.000000 COUNT : 1270 SUM : 805291 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 : 249375.000000 P95 : 566589.743590 P99 : 798616.666667 P100 : 830631.000000 COUNT : 254 SUM : 75878694 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