[2024-07-26 11:03:32.570339] Starting SPDK v24.09-pre git sha1 704257090 / DPDK 24.03.0 initialization... [2024-07-26 11:03:32.570666] [ 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_pid3241654 ] Set seed to 1721984612562834 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-07-26 11:03:32.882985] app.c: 909:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-07-26 11:03:33.198319] app.c: 603:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-07-26 11:03:33.198372] app.c: 604:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 3241654' to capture a snapshot of events at runtime. [2024-07-26 11:03:33.198391] app.c: 609:app_setup_trace: *NOTICE*: 'spdk_trace' without parameters will also work if this is the only [2024-07-26 11:03:33.198410] app.c: 610:app_setup_trace: *NOTICE*: SPDK application currently running. [2024-07-26 11:03:33.198425] app.c: 611:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid3241654 for offline analysis/debug. [2024-07-26 11:03:33.198557] reactor.c: 941:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Fri Jul 26 11:03:40 2024 CPU: 72 * Intel(R) Xeon(R) Gold 6140 CPU @ 2.30GHz CPUCache: 25344 KB 2024/07/26-11:03:46 ... thread 0: (1000000,1000000) ops and (184323.8,184323.8) ops/second in (5.425236,5.425236) 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 171.4 4.78 4.49 9 0.531 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 8/0 755.91 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 9/0 818.90 MB 0.0 0.0 0.0 0.0 0.8 0.8 1.5 1.0 0.0 171.4 4.78 4.49 9 0.531 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 0.4 0.4 1.2 1.0 0.0 196.9 2.24 2.09 5 0.448 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 171.4 4.78 4.49 9 0.531 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 5.5 total, 2.4 interval Flush(GB): cumulative 0.800, interval 0.431 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 0.80 GB write, 150.13 MB/s write, 0.00 GB read, 0.00 MB/s read, 4.8 seconds Interval compaction: 0.43 GB write, 181.80 MB/s write, 0.00 GB read, 0.00 MB/s read, 2.2 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 9, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 9, interval: 5 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 45 Average: 803.2889 StdDev: 1346.19 Min: 2 Median: 9.6000 Max: 4312 Percentiles: P50: 9.60 P75: 995.42 P99: 4303.57 P99.9: 4312.00 P99.99: 4312.00 ------------------------------------------------------ ( 1, 2 ] 5 11.111% 11.111% ## ( 2, 3 ] 12 26.667% 37.778% ##### ( 3, 4 ] 1 2.222% 40.000% ( 6, 10 ] 5 11.111% 51.111% ## ( 10, 15 ] 4 8.889% 60.000% ## ( 380, 580 ] 5 11.111% 71.111% ## ( 870, 1300 ] 6 13.333% 84.444% ### ( 2900, 4400 ] 7 15.556% 100.000% ### ** DB Stats ** Uptime(secs): 5.5 total, 2.4 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 180.43 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:2.848 H:M:S, 52.2 percent Interval writes: 0 writes, 493K keys, 0 commit groups, 0.0 writes per commit group, ingest: 485.37 MB, 200.05 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.161 H:M:S, 47.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/07/26-11:03:51 ... thread 0: (1000000,2000000) ops and (186860.7,185583.6) ops/second in (5.351581,10.776817) 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 189.2 9.65 9.04 20 0.483 0 0 0.0 0.0 L2 1/0 62.99 MB 0.6 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 L3 7/0 629.93 MB 0.6 0.0 0.0 0.0 0.0 0.0 1.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 12/0 1.11 GB 0.1 0.0 0.0 0.0 0.0 0.0 1.1 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 20/0 1.78 GB 0.0 0.0 0.0 0.0 1.8 1.8 4.6 1.0 0.0 189.2 9.65 9.04 20 0.483 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 1.4 1.4 4.2 1.0 0.0 203.6 7.12 6.64 16 0.445 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 189.2 9.65 9.04 20 0.483 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 10.8 total, 7.8 interval Flush(GB): cumulative 1.784, interval 1.415 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 1.78 GB write, 169.05 MB/s write, 0.00 GB read, 0.00 MB/s read, 9.7 seconds Interval compaction: 1.41 GB write, 186.30 MB/s write, 0.00 GB read, 0.00 MB/s read, 7.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: 18, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 18, interval: 14 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 100 Average: 675.7000 StdDev: 1158.35 Min: 1 Median: 9.0769 Max: 4312 Percentiles: P50: 9.08 P75: 962.14 P99: 4275.00 P99.9: 4312.00 P99.99: 4312.00 ------------------------------------------------------ [ 0, 1 ] 2 2.000% 2.000% ( 1, 2 ] 12 12.000% 14.000% ## ( 2, 3 ] 24 24.000% 38.000% ##### ( 3, 4 ] 2 2.000% 40.000% ( 6, 10 ] 13 13.000% 53.000% ### ( 10, 15 ] 7 7.000% 60.000% # ( 250, 380 ] 3 3.000% 63.000% # ( 380, 580 ] 8 8.000% 71.000% ## ( 580, 870 ] 1 1.000% 72.000% ( 870, 1300 ] 14 14.000% 86.000% ### ( 1300, 1900 ] 2 2.000% 88.000% ( 2900, 4400 ] 12 12.000% 100.000% ## ** DB Stats ** Uptime(secs): 10.8 total, 5.4 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 182.15 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.600 H:M:S, 51.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 183.91 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.752 H:M:S, 51.4 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/07/26-11:03:55 ... thread 0: (1000000,3000000) ops and (245567.8,202033.6) ops/second in (4.072195,14.849012) 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 211.6 13.40 12.49 32 0.419 0 0 0.0 0.0 L2 1/0 62.99 MB 0.6 0.0 0.0 0.0 0.0 0.0 2.8 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L3 11/0 944.89 MB 0.9 0.0 0.0 0.0 0.0 0.0 2.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 20/0 1.78 GB 0.2 0.0 0.0 0.0 0.0 0.0 1.8 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 32/0 2.77 GB 0.0 0.0 0.0 0.0 2.8 2.8 7.3 1.0 0.0 211.6 13.40 12.49 32 0.419 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 2.4 2.4 6.9 1.0 0.0 226.2 10.86 10.09 28 0.388 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 211.6 13.40 12.49 32 0.419 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 14.9 total, 11.8 interval Flush(GB): cumulative 2.768, interval 2.399 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, 190.52 MB/s write, 0.00 GB read, 0.00 MB/s read, 13.4 seconds Interval compaction: 2.40 GB write, 207.33 MB/s write, 0.00 GB read, 0.00 MB/s read, 10.9 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 24, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 24, interval: 20 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 160 Average: 622.5063 StdDev: 1085.86 Min: 1 Median: 8.7826 Max: 4312 Percentiles: P50: 8.78 P75: 870.00 P99: 4258.82 P99.9: 4312.00 P99.99: 4312.00 ------------------------------------------------------ [ 0, 1 ] 7 4.375% 4.375% # ( 1, 2 ] 27 16.875% 21.250% ### ( 2, 3 ] 28 17.500% 38.750% #### ( 3, 4 ] 2 1.250% 40.000% ( 6, 10 ] 23 14.375% 54.375% ### ( 10, 15 ] 8 5.000% 59.375% # ( 34, 51 ] 1 0.625% 60.000% ( 250, 380 ] 9 5.625% 65.625% # ( 380, 580 ] 10 6.250% 71.875% # ( 580, 870 ] 5 3.125% 75.000% # ( 870, 1300 ] 17 10.625% 85.625% ## ( 1300, 1900 ] 5 3.125% 88.750% # ( 1900, 2900 ] 1 0.625% 89.375% ( 2900, 4400 ] 17 10.625% 100.000% ## ** DB Stats ** Uptime(secs): 14.9 total, 4.1 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 198.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:7.149 H:M:S, 48.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 241.69 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.549 H:M:S, 38.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/07/26-11:03:59 ... thread 0: (1000000,4000000) ops and (266993.3,215118.2) ops/second in (3.745413,18.594425) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 0/0 0.00 KB 0.0 0.0 0.0 0.0 3.7 3.7 0.0 1.0 0.0 227.1 16.64 15.43 43 0.387 0 0 0.0 0.0 L3 11/0 944.90 MB 0.9 0.0 0.0 0.0 0.0 0.0 3.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 32/0 2.77 GB 0.3 0.0 0.0 0.0 0.0 0.0 2.8 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 43/0 3.69 GB 0.0 0.0 0.0 0.0 3.7 3.7 6.5 1.0 0.0 227.1 16.64 15.43 43 0.387 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 3.3 3.3 6.1 1.0 0.0 241.2 14.10 13.04 39 0.362 0 0 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- High 0/0 0.00 KB 0.0 0.0 0.0 0.0 3.7 3.7 0.0 0.0 0.0 227.1 16.64 15.43 43 0.387 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 18.6 total, 15.6 interval Flush(GB): cumulative 3.691, interval 3.322 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 3.69 GB write, 202.94 MB/s write, 0.00 GB read, 0.00 MB/s read, 16.6 seconds Interval compaction: 3.32 GB write, 218.13 MB/s write, 0.00 GB read, 0.00 MB/s read, 14.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: 29, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 29, interval: 25 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 219 Average: 644.9041 StdDev: 1167.87 Min: 1 Median: 8.5294 Max: 6110 Percentiles: P50: 8.53 P75: 749.17 P99: 4328.60 P99.9: 6110.00 P99.99: 6110.00 ------------------------------------------------------ [ 0, 1 ] 15 6.849% 6.849% # ( 1, 2 ] 42 19.178% 26.027% #### ( 2, 3 ] 28 12.785% 38.813% ### ( 3, 4 ] 2 0.913% 39.726% ( 4, 6 ] 1 0.457% 40.183% ( 6, 10 ] 34 15.525% 55.708% ### ( 10, 15 ] 8 3.653% 59.361% # ( 15, 22 ] 1 0.457% 59.817% ( 34, 51 ] 1 0.457% 60.274% ( 250, 380 ] 17 7.763% 68.037% ## ( 380, 580 ] 10 4.566% 72.603% # ( 580, 870 ] 9 4.110% 76.712% # ( 870, 1300 ] 18 8.219% 84.932% ## ( 1300, 1900 ] 6 2.740% 87.671% # ( 1900, 2900 ] 1 0.457% 88.128% ( 2900, 4400 ] 25 11.416% 99.543% ## ( 4400, 6600 ] 1 0.457% 100.000% ** DB Stats ** Uptime(secs): 18.6 total, 3.7 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 211.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:8.389 H:M:S, 45.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 262.77 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:1.240 H:M:S, 33.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/07/26-11:04:04 ... thread 0: (1000000,5000000) ops and (193439.2,210402.2) ops/second in (5.169583,23.764008) 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 223.4 21.43 19.90 54 0.397 0 0 0.0 0.0 L3 10/0 944.90 MB 0.9 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 44/0 3.75 GB 0.4 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 Sum 54/0 4.68 GB 0.0 0.0 0.0 0.0 4.7 4.7 8.4 1.0 0.0 223.4 21.43 19.90 54 0.397 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 4.3 4.3 8.1 1.0 0.0 233.3 18.90 17.50 50 0.378 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 223.4 21.43 19.90 54 0.397 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.8 total, 20.8 interval Flush(GB): cumulative 4.675, interval 4.306 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 4.68 GB write, 201.21 MB/s write, 0.00 GB read, 0.00 MB/s read, 21.4 seconds Interval compaction: 4.31 GB write, 212.36 MB/s write, 0.00 GB read, 0.00 MB/s read, 18.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: 38, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 38, interval: 34 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 270 Average: 642.7519 StdDev: 1145.83 Min: 1 Median: 8.6341 Max: 6110 Percentiles: P50: 8.63 P75: 809.58 P99: 4315.00 P99.9: 6006.00 P99.99: 6110.00 ------------------------------------------------------ [ 0, 1 ] 15 5.556% 5.556% # ( 1, 2 ] 51 18.889% 24.444% #### ( 2, 3 ] 38 14.074% 38.519% ### ( 3, 4 ] 3 1.111% 39.630% ( 4, 6 ] 1 0.370% 40.000% ( 6, 10 ] 41 15.185% 55.185% ### ( 10, 15 ] 11 4.074% 59.259% # ( 15, 22 ] 1 0.370% 59.630% ( 34, 51 ] 1 0.370% 60.000% ( 250, 380 ] 18 6.667% 66.667% # ( 380, 580 ] 13 4.815% 71.481% # ( 580, 870 ] 12 4.444% 75.926% # ( 870, 1300 ] 26 9.630% 85.556% ## ( 1300, 1900 ] 7 2.593% 88.148% # ( 1900, 2900 ] 1 0.370% 88.519% ( 2900, 4400 ] 30 11.111% 99.630% ## ( 4400, 6600 ] 1 0.370% 100.000% ** DB Stats ** Uptime(secs): 23.8 total, 5.2 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 206.82 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:10.992 H:M:S, 46.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 190.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:2.603 H:M:S, 50.4 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/07/26-11:04:08 ... thread 0: (1000000,6000000) ops and (250413.2,216158.5) ops/second in (3.993400,27.757408) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 0/0 0.00 KB 0.0 0.0 0.0 0.0 5.7 5.7 0.0 1.0 0.0 230.0 25.19 23.35 66 0.382 0 0 0.0 0.0 L2 1/0 62.99 MB 0.6 0.0 0.0 0.0 0.0 0.0 5.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L3 9/0 755.90 MB 0.8 0.0 0.0 0.0 0.0 0.0 5.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 56/0 4.86 GB 0.5 0.0 0.0 0.0 0.0 0.0 4.9 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 66/0 5.66 GB 0.0 0.0 0.0 0.0 5.7 5.7 16.1 1.0 0.0 230.0 25.19 23.35 66 0.382 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 5.3 5.3 15.7 1.0 0.0 239.1 22.66 20.95 62 0.365 0 0 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- High 0/0 0.00 KB 0.0 0.0 0.0 0.0 5.7 5.7 0.0 0.0 0.0 230.0 25.19 23.35 66 0.382 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 27.8 total, 24.8 interval Flush(GB): cumulative 5.660, interval 5.290 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 5.66 GB write, 208.57 MB/s write, 0.00 GB read, 0.00 MB/s read, 25.2 seconds Interval compaction: 5.29 GB write, 218.82 MB/s write, 0.00 GB read, 0.00 MB/s read, 22.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: 45, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 45, interval: 41 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 330 Average: 639.4182 StdDev: 1143.18 Min: 1 Median: 8.4615 Max: 6110 Percentiles: P50: 8.46 P75: 770.31 P99: 4306.76 P99.9: 5874.00 P99.99: 6110.00 ------------------------------------------------------ [ 0, 1 ] 23 6.970% 6.970% # ( 1, 2 ] 66 20.000% 26.970% #### ( 2, 3 ] 39 11.818% 38.788% ## ( 3, 4 ] 3 0.909% 39.697% ( 4, 6 ] 2 0.606% 40.303% ( 6, 10 ] 52 15.758% 56.061% ### ( 10, 15 ] 11 3.333% 59.394% # ( 15, 22 ] 1 0.303% 59.697% ( 34, 51 ] 1 0.303% 60.000% ( 250, 380 ] 25 7.576% 67.576% ## ( 380, 580 ] 14 4.242% 71.818% # ( 580, 870 ] 16 4.848% 76.667% # ( 870, 1300 ] 28 8.485% 85.152% ## ( 1300, 1900 ] 9 2.727% 87.879% # ( 1900, 2900 ] 2 0.606% 88.485% ( 2900, 4400 ] 37 11.212% 99.697% ## ( 4400, 6600 ] 1 0.303% 100.000% ** DB Stats ** Uptime(secs): 27.8 total, 4.0 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 212.52 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:12.471 H:M:S, 44.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 246.45 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.479 H:M:S, 37.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/07/26-11:04:12 ... thread 0: (1000000,7000000) ops and (271912.4,222681.3) ops/second in (3.677655,31.435063) 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 237.7 28.36 26.23 77 0.368 0 0 0.0 0.0 L3 9/0 755.92 MB 0.8 0.0 0.0 0.0 0.0 0.0 6.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 68/0 5.84 GB 0.6 0.0 0.0 0.0 0.0 0.0 5.8 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 77/0 6.58 GB 0.0 0.0 0.0 0.0 6.6 6.6 12.4 1.0 0.0 237.7 28.36 26.23 77 0.368 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 6.2 6.2 12.1 1.0 0.0 246.4 25.82 23.83 73 0.354 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 237.7 28.36 26.23 77 0.368 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 31.5 total, 28.4 interval Flush(GB): cumulative 6.582, interval 6.213 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, 214.22 MB/s write, 0.00 GB read, 0.00 MB/s read, 28.4 seconds Interval compaction: 6.21 GB write, 223.75 MB/s write, 0.00 GB read, 0.00 MB/s read, 25.8 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 53, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 53, interval: 49 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 385 Average: 637.1948 StdDev: 1142.45 Min: 1 Median: 8.3810 Max: 6110 Percentiles: P50: 8.38 P75: 750.38 P99: 4302.84 P99.9: 5753.00 P99.99: 6110.00 ------------------------------------------------------ [ 0, 1 ] 31 8.052% 8.052% ## ( 1, 2 ] 80 20.779% 28.831% #### ( 2, 3 ] 39 10.130% 38.961% ## ( 3, 4 ] 3 0.779% 39.740% ( 4, 6 ] 2 0.519% 40.260% ( 6, 10 ] 63 16.364% 56.623% ### ( 10, 15 ] 11 2.857% 59.481% # ( 15, 22 ] 1 0.260% 59.740% ( 34, 51 ] 1 0.260% 60.000% ( 250, 380 ] 32 8.312% 68.312% ## ( 380, 580 ] 14 3.636% 71.948% # ( 580, 870 ] 20 5.195% 77.143% # ( 870, 1300 ] 29 7.532% 84.675% ## ( 1300, 1900 ] 12 3.117% 87.792% # ( 1900, 2900 ] 2 0.519% 88.312% ( 2900, 4400 ] 44 11.429% 99.740% ## ( 4400, 6600 ] 1 0.260% 100.000% ** DB Stats ** Uptime(secs): 31.5 total, 3.7 interval Cumulative writes: 0 writes, 7000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 6.73 GB, 218.96 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:13.618 H:M:S, 43.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 267.61 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:1.147 H:M:S, 31.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/07/26-11:04:16 ... thread 0: (1000000,8000000) ops and (261367.5,226879.0) ops/second in (3.826031,35.261094) 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 243.0 31.89 29.43 89 0.358 0 0 0.0 0.0 L3 9/0 755.93 MB 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 L4 80/0 6.83 GB 0.7 0.0 0.0 0.0 0.0 0.0 6.8 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 89/0 7.57 GB 0.0 0.0 0.0 0.0 7.6 7.6 14.4 1.0 0.0 243.0 31.89 29.43 89 0.358 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 7.2 7.2 14.0 1.0 0.0 251.1 29.35 27.03 85 0.345 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 243.0 31.89 29.43 89 0.358 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 35.3 total, 32.3 interval Flush(GB): cumulative 7.567, interval 7.197 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, 219.55 MB/s write, 0.00 GB read, 0.00 MB/s read, 31.9 seconds Interval compaction: 7.20 GB write, 228.45 MB/s write, 0.00 GB read, 0.00 MB/s read, 29.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: 61, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 61, interval: 57 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 445 Average: 637.9820 StdDev: 1156.29 Min: 1 Median: 8.3288 Max: 6110 Percentiles: P50: 8.33 P75: 727.90 P99: 4355.61 P99.9: 6110.00 P99.99: 6110.00 ------------------------------------------------------ [ 0, 1 ] 38 8.539% 8.539% ## ( 1, 2 ] 96 21.573% 30.112% #### ( 2, 3 ] 39 8.764% 38.876% ## ( 3, 4 ] 3 0.674% 39.551% ( 4, 6 ] 4 0.899% 40.449% ( 6, 10 ] 73 16.404% 56.854% ### ( 10, 15 ] 12 2.697% 59.551% # ( 15, 22 ] 1 0.225% 59.775% ( 34, 51 ] 1 0.225% 60.000% ( 250, 380 ] 39 8.764% 68.764% ## ( 380, 580 ] 15 3.371% 72.135% # ( 580, 870 ] 25 5.618% 77.753% # ( 870, 1300 ] 32 7.191% 84.944% # ( 1300, 1900 ] 13 2.921% 87.865% # ( 1900, 2900 ] 2 0.449% 88.315% ( 2900, 4400 ] 49 11.011% 99.326% ## ( 4400, 6600 ] 3 0.674% 100.000% ** DB Stats ** Uptime(secs): 35.3 total, 3.8 interval Cumulative writes: 0 writes, 8000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 7.69 GB, 223.11 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:14.920 H:M:S, 42.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 257.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:1.302 H:M:S, 34.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/07/26-11:04:19 ... thread 0: (1000000,9000000) ops and (265107.2,230573.2) ops/second in (3.772059,39.033153) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 0/0 0.00 KB 0.0 0.0 0.0 0.0 8.6 8.6 0.0 1.0 0.0 247.7 35.35 32.58 101 0.350 0 0 0.0 0.0 L3 9/0 755.93 MB 0.8 0.0 0.0 0.0 0.0 0.0 8.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 92/0 7.81 GB 0.8 0.0 0.0 0.0 0.0 0.0 7.8 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 101/0 8.55 GB 0.0 0.0 0.0 0.0 8.6 8.6 16.4 1.0 0.0 247.7 35.35 32.58 101 0.350 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 8.2 8.2 16.0 1.0 0.0 255.4 32.81 30.18 97 0.338 0 0 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- High 0/0 0.00 KB 0.0 0.0 0.0 0.0 8.6 8.6 0.0 0.0 0.0 247.7 35.35 32.58 101 0.350 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 39.1 total, 36.0 interval Flush(GB): cumulative 8.551, interval 8.182 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 8.55 GB write, 224.16 MB/s write, 0.00 GB read, 0.00 MB/s read, 35.3 seconds Interval compaction: 8.18 GB write, 232.51 MB/s write, 0.00 GB read, 0.00 MB/s read, 32.8 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 69, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 69, interval: 65 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 505 Average: 632.6515 StdDev: 1148.46 Min: 1 Median: 8.2824 Max: 6110 Percentiles: P50: 8.28 P75: 717.50 P99: 4345.09 P99.9: 6110.00 P99.99: 6110.00 ------------------------------------------------------ [ 0, 1 ] 45 8.911% 8.911% ## ( 1, 2 ] 113 22.376% 31.287% #### ( 2, 3 ] 39 7.723% 39.010% ## ( 3, 4 ] 3 0.594% 39.604% ( 4, 6 ] 4 0.792% 40.396% ( 6, 10 ] 85 16.832% 57.228% ### ( 10, 15 ] 12 2.376% 59.604% ( 15, 22 ] 1 0.198% 59.802% ( 34, 51 ] 1 0.198% 60.000% ( 250, 380 ] 47 9.307% 69.307% ## ( 380, 580 ] 15 2.970% 72.277% # ( 580, 870 ] 29 5.743% 78.020% # ( 870, 1300 ] 35 6.931% 84.950% # ( 1300, 1900 ] 15 2.970% 87.921% # ( 1900, 2900 ] 2 0.396% 88.317% ( 2900, 4400 ] 56 11.089% 99.406% ## ( 4400, 6600 ] 3 0.594% 100.000% ** DB Stats ** Uptime(secs): 39.1 total, 3.8 interval Cumulative writes: 0 writes, 9000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 8.65 GB, 226.76 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:16.173 H:M:S, 41.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 260.92 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.253 H:M:S, 33.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/07/26-11:04:23 ... thread 0: (1000000,10000000) ops and (263942.2,233525.6) ops/second in (3.788708,42.821861) 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 251.4 38.84 35.76 113 0.344 0 0 0.0 0.0 L3 9/0 755.91 MB 0.8 0.0 0.0 0.0 0.0 0.0 9.5 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 104/0 8.80 GB 0.9 0.0 0.0 0.0 0.0 0.0 8.8 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 113/0 9.54 GB 0.0 0.0 0.0 0.0 9.5 9.5 18.3 1.0 0.0 251.4 38.84 35.76 113 0.344 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 9.2 9.2 18.0 1.0 0.0 258.5 36.31 33.36 109 0.333 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 251.4 38.84 35.76 113 0.344 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): 42.9 total, 39.8 interval Flush(GB): cumulative 9.535, interval 9.166 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.54 GB write, 227.86 MB/s write, 0.00 GB read, 0.00 MB/s read, 38.8 seconds Interval compaction: 9.17 GB write, 235.70 MB/s write, 0.00 GB read, 0.00 MB/s read, 36.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: 76, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 76, interval: 72 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 565 Average: 638.5699 StdDev: 1157.08 Min: 1 Median: 8.2708 Max: 6110 Percentiles: P50: 8.27 P75: 709.62 P99: 4338.85 P99.9: 6110.00 P99.99: 6110.00 ------------------------------------------------------ [ 0, 1 ] 53 9.381% 9.381% ## ( 1, 2 ] 129 22.832% 32.212% ##### ( 2, 3 ] 39 6.903% 39.115% # ( 3, 4 ] 3 0.531% 39.646% ( 4, 6 ] 4 0.708% 40.354% ( 6, 10 ] 96 16.991% 57.345% ### ( 10, 15 ] 12 2.124% 59.469% ( 15, 22 ] 1 0.177% 59.646% ( 34, 51 ] 2 0.354% 60.000% ( 250, 380 ] 54 9.558% 69.558% ## ( 380, 580 ] 16 2.832% 72.389% # ( 580, 870 ] 33 5.841% 78.230% # ( 870, 1300 ] 36 6.372% 84.602% # ( 1300, 1900 ] 17 3.009% 87.611% # ( 1900, 2900 ] 2 0.354% 87.965% ( 2900, 4400 ] 65 11.504% 99.469% ## ( 4400, 6600 ] 3 0.531% 100.000% ** DB Stats ** Uptime(secs): 42.9 total, 3.8 interval Cumulative writes: 0 writes, 10M keys, 0 commit groups, 0.0 writes per commit group, ingest: 9.61 GB, 229.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:17.433 H:M:S, 40.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 259.77 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:1.260 H:M:S, 33.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/07/26-11:04:27 ... thread 0: (1000000,11000000) ops and (295355.6,238056.0) ops/second in (3.385749,46.207610) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 0/0 0.00 KB 0.0 0.0 0.0 0.0 10.4 10.4 0.0 1.0 0.0 254.5 41.83 38.46 124 0.337 0 0 0.0 0.0 L3 8/0 629.93 MB 0.6 0.0 0.0 0.0 0.0 0.0 10.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 112/0 9.41 GB 1.0 0.0 0.0 0.0 0.0 0.0 9.8 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 4/0 377.95 MB 0.0 0.0 0.0 0.0 0.0 0.0 0.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 124/0 10.40 GB 0.0 0.0 0.0 0.0 10.4 10.4 20.5 1.0 0.0 254.5 41.83 38.46 124 0.337 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 10.0 10.0 20.2 1.0 0.0 261.3 39.29 36.06 120 0.327 0 0 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- High 0/0 0.00 KB 0.0 0.0 0.0 0.0 10.4 10.4 0.0 0.0 0.0 254.5 41.83 38.46 124 0.337 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 46.2 total, 43.2 interval Flush(GB): cumulative 10.396, interval 10.027 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 10.40 GB write, 230.25 MB/s write, 0.00 GB read, 0.00 MB/s read, 41.8 seconds Interval compaction: 10.03 GB write, 237.64 MB/s write, 0.00 GB read, 0.00 MB/s read, 39.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: 83, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 83, interval: 79 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 620 Average: 634.5516 StdDev: 1151.41 Min: 1 Median: 8.2095 Max: 6110 Percentiles: P50: 8.21 P75: 697.57 P99: 4332.39 P99.9: 6110.00 P99.99: 6110.00 ------------------------------------------------------ [ 0, 1 ] 59 9.516% 9.516% ## ( 1, 2 ] 145 23.387% 32.903% ##### ( 2, 3 ] 39 6.290% 39.194% # ( 3, 4 ] 3 0.484% 39.677% ( 4, 6 ] 6 0.968% 40.645% ( 6, 10 ] 105 16.935% 57.581% ### ( 10, 15 ] 12 1.935% 59.516% ( 15, 22 ] 1 0.161% 59.677% ( 34, 51 ] 2 0.323% 60.000% ( 250, 380 ] 62 10.000% 70.000% ## ( 380, 580 ] 16 2.581% 72.581% # ( 580, 870 ] 37 5.968% 78.548% # ( 870, 1300 ] 37 5.968% 84.516% # ( 1300, 1900 ] 19 3.065% 87.581% # ( 1900, 2900 ] 3 0.484% 88.065% ( 2900, 4400 ] 71 11.452% 99.516% ## ( 4400, 6600 ] 3 0.484% 100.000% ** DB Stats ** Uptime(secs): 46.2 total, 3.4 interval Cumulative writes: 0 writes, 11M keys, 0 commit groups, 0.0 writes per commit group, ingest: 10.57 GB, 234.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:18.324 H:M:S, 39.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 290.68 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.891 H:M:S, 26.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/07/26-11:04:32 ... thread 0: (1000000,12000000) ops and (190205.6,233167.8) ops/second in (5.257468,51.465078) 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 249.7 46.67 42.97 135 0.346 0 0 0.0 0.0 L2 1/0 62.99 MB 0.6 0.0 0.0 0.0 0.0 0.0 11.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L3 10/0 944.89 MB 0.9 0.0 0.0 0.0 0.0 0.0 11.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 116/0 9.66 GB 1.0 0.0 0.0 0.0 0.0 0.0 10.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 8/0 755.91 MB 0.0 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 135/0 11.38 GB 0.0 0.0 0.0 0.0 11.4 11.4 33.8 1.0 0.0 249.7 46.67 42.97 135 0.346 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 11.0 11.0 33.5 1.0 0.0 255.5 44.13 40.57 131 0.337 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 249.7 46.67 42.97 135 0.346 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.5 total, 48.5 interval Flush(GB): cumulative 11.381, interval 11.011 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 11.38 GB write, 226.31 MB/s write, 0.00 GB read, 0.00 MB/s read, 46.7 seconds Interval compaction: 11.01 GB write, 232.66 MB/s write, 0.00 GB read, 0.00 MB/s read, 44.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: 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: 675 Average: 646.0874 StdDev: 1170.31 Min: 1 Median: 8.2162 Max: 6110 Percentiles: P50: 8.22 P75: 711.64 P99: 4346.43 P99.9: 6110.00 P99.99: 6110.00 ------------------------------------------------------ [ 0, 1 ] 62 9.185% 9.185% ## ( 1, 2 ] 153 22.667% 31.852% ##### ( 2, 3 ] 50 7.407% 39.259% # ( 3, 4 ] 3 0.444% 39.704% ( 4, 6 ] 8 1.185% 40.889% ( 6, 10 ] 111 16.444% 57.333% ### ( 10, 15 ] 15 2.222% 59.556% ( 15, 22 ] 1 0.148% 59.704% ( 34, 51 ] 2 0.296% 60.000% ( 250, 380 ] 64 9.481% 69.481% ## ( 380, 580 ] 20 2.963% 72.444% # ( 580, 870 ] 38 5.630% 78.074% # ( 870, 1300 ] 43 6.370% 84.444% # ( 1300, 1900 ] 20 2.963% 87.407% # ( 1900, 2900 ] 4 0.593% 88.000% ( 2900, 4400 ] 77 11.407% 99.407% ## ( 4400, 6600 ] 4 0.593% 100.000% ** DB Stats ** Uptime(secs): 51.5 total, 5.3 interval Cumulative writes: 0 writes, 12M keys, 0 commit groups, 0.0 writes per commit group, ingest: 11.53 GB, 229.35 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:20.990 H:M:S, 40.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 187.20 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.666 H:M:S, 50.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/07/26-11:04:37 ... thread 0: (1000000,13000000) ops and (212784.5,231462.2) ops/second in (4.699591,56.164669) 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 249.5 51.00 46.95 147 0.347 0 0 0.0 0.0 L3 11/0 944.89 MB 0.9 0.0 0.0 0.0 0.0 0.0 12.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 116/0 9.72 GB 1.0 0.0 0.0 0.0 0.0 0.0 11.5 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 20/0 1.78 GB 0.0 0.0 0.0 0.0 0.0 0.0 1.8 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 147/0 12.43 GB 0.0 0.0 0.0 0.0 12.4 12.4 25.7 1.0 0.0 249.5 51.00 46.95 147 0.347 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 12.1 12.1 25.3 1.0 0.0 254.8 48.46 44.55 143 0.339 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 249.5 51.00 46.95 147 0.347 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 56.2 total, 53.2 interval Flush(GB): cumulative 12.426, interval 12.057 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, 226.44 MB/s write, 0.00 GB read, 0.00 MB/s read, 51.0 seconds Interval compaction: 12.06 GB write, 232.23 MB/s write, 0.00 GB read, 0.00 MB/s read, 48.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: 102, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 102, interval: 98 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 735 Average: 649.0585 StdDev: 1178.41 Min: 1 Median: 8.2314 Max: 6110 Percentiles: P50: 8.23 P75: 712.92 P99: 4358.04 P99.9: 6110.00 P99.99: 6110.00 ------------------------------------------------------ [ 0, 1 ] 69 9.388% 9.388% ## ( 1, 2 ] 164 22.313% 31.701% #### ( 2, 3 ] 56 7.619% 39.320% ## ( 3, 4 ] 3 0.408% 39.728% ( 4, 6 ] 8 1.088% 40.816% ( 6, 10 ] 121 16.463% 57.279% ### ( 10, 15 ] 17 2.313% 59.592% ( 15, 22 ] 1 0.136% 59.728% ( 34, 51 ] 2 0.272% 60.000% ( 250, 380 ] 70 9.524% 69.524% ## ( 380, 580 ] 21 2.857% 72.381% # ( 580, 870 ] 42 5.714% 78.095% # ( 870, 1300 ] 48 6.531% 84.626% # ( 1300, 1900 ] 20 2.721% 87.347% # ( 1900, 2900 ] 4 0.544% 87.891% ( 2900, 4400 ] 84 11.429% 99.320% ## ( 4400, 6600 ] 5 0.680% 100.000% ** DB Stats ** Uptime(secs): 56.2 total, 4.7 interval Cumulative writes: 0 writes, 13M keys, 0 commit groups, 0.0 writes per commit group, ingest: 12.49 GB, 227.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:23.142 H:M:S, 41.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 209.42 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:2.152 H:M:S, 45.8 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/07/26-11:04:40 ... thread 0: (1000000,14000000) ops and (284487.5,234585.4) ops/second in (3.515093,59.679762) 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 251.6 54.07 49.75 158 0.342 0 0 0.0 0.0 L3 10/0 818.90 MB 0.8 0.0 0.0 0.0 0.0 0.0 13.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 116/0 9.72 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 32/0 2.77 GB 0.0 0.0 0.0 0.0 0.0 0.0 2.8 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 158/0 13.29 GB 0.0 0.0 0.0 0.0 13.3 13.3 28.5 1.0 0.0 251.6 54.07 49.75 158 0.342 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 12.9 12.9 28.2 1.0 0.0 256.7 51.53 47.35 154 0.335 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 251.6 54.07 49.75 158 0.342 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): 59.7 total, 56.7 interval Flush(GB): cumulative 13.288, interval 12.918 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 13.29 GB write, 227.88 MB/s write, 0.00 GB read, 0.00 MB/s read, 54.1 seconds Interval compaction: 12.92 GB write, 233.39 MB/s write, 0.00 GB read, 0.00 MB/s read, 51.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: 109, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 109, interval: 105 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 790 Average: 645.4418 StdDev: 1172.66 Min: 1 Median: 8.1417 Max: 6110 Percentiles: P50: 8.14 P75: 705.67 P99: 4352.20 P99.9: 6110.00 P99.99: 6110.00 ------------------------------------------------------ [ 0, 1 ] 79 10.000% 10.000% ## ( 1, 2 ] 176 22.278% 32.278% #### ( 2, 3 ] 56 7.089% 39.367% # ( 3, 4 ] 3 0.380% 39.747% ( 4, 6 ] 13 1.646% 41.392% ( 6, 10 ] 127 16.076% 57.468% ### ( 10, 15 ] 17 2.152% 59.620% ( 15, 22 ] 1 0.127% 59.747% ( 34, 51 ] 2 0.253% 60.000% ( 250, 380 ] 78 9.873% 69.873% ## ( 380, 580 ] 21 2.658% 72.532% # ( 580, 870 ] 45 5.696% 78.228% # ( 870, 1300 ] 51 6.456% 84.684% # ( 1300, 1900 ] 21 2.658% 87.342% # ( 1900, 2900 ] 4 0.506% 87.848% ( 2900, 4400 ] 91 11.519% 99.367% ## ( 4400, 6600 ] 5 0.633% 100.000% ** DB Stats ** Uptime(secs): 59.7 total, 3.5 interval Cumulative writes: 0 writes, 14M keys, 0 commit groups, 0.0 writes per commit group, ingest: 13.46 GB, 230.76 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:24.137 H:M:S, 40.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 279.99 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.995 H:M:S, 28.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/07/26-11:04:44 ... thread 0: (1000000,15000000) ops and (262248.2,236246.7) ops/second in (3.813181,63.492943) 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 253.9 57.56 52.92 170 0.339 0 0 0.0 0.0 L3 10/0 818.91 MB 0.8 0.0 0.0 0.0 0.0 0.0 14.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 116/0 9.72 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 44/0 3.75 GB 0.0 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 Sum 170/0 14.27 GB 0.0 0.0 0.0 0.0 14.3 14.3 31.5 1.0 0.0 253.9 57.56 52.92 170 0.339 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 13.9 13.9 31.1 1.0 0.0 258.7 55.02 50.52 166 0.331 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 253.9 57.56 52.92 170 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): 63.5 total, 60.5 interval Flush(GB): cumulative 14.272, interval 13.903 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 14.27 GB write, 230.07 MB/s write, 0.00 GB read, 0.00 MB/s read, 57.6 seconds Interval compaction: 13.90 GB write, 235.34 MB/s write, 0.00 GB read, 0.00 MB/s read, 55.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: 117, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 117, interval: 113 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 850 Average: 645.4141 StdDev: 1172.54 Min: 1 Median: 8.0882 Max: 6110 Percentiles: P50: 8.09 P75: 701.33 P99: 4346.97 P99.9: 6110.00 P99.99: 6110.00 ------------------------------------------------------ [ 0, 1 ] 87 10.235% 10.235% ## ( 1, 2 ] 192 22.588% 32.824% ##### ( 2, 3 ] 56 6.588% 39.412% # ( 3, 4 ] 3 0.353% 39.765% ( 4, 6 ] 16 1.882% 41.647% ( 6, 10 ] 136 16.000% 57.647% ### ( 10, 15 ] 17 2.000% 59.647% ( 15, 22 ] 1 0.118% 59.765% ( 34, 51 ] 2 0.235% 60.000% ( 250, 380 ] 86 10.118% 70.118% ## ( 380, 580 ] 21 2.471% 72.588% ( 580, 870 ] 49 5.765% 78.353% # ( 870, 1300 ] 52 6.118% 84.471% # ( 1300, 1900 ] 24 2.824% 87.294% # ( 1900, 2900 ] 4 0.471% 87.765% ( 2900, 4400 ] 99 11.647% 99.412% ## ( 4400, 6600 ] 5 0.588% 100.000% ** DB Stats ** Uptime(secs): 63.5 total, 3.8 interval Cumulative writes: 0 writes, 15M keys, 0 commit groups, 0.0 writes per commit group, ingest: 14.42 GB, 232.40 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:25.423 H:M:S, 40.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 258.10 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.286 H:M:S, 33.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/07/26-11:04:48 ... thread 0: (1000000,16000000) ops and (261124.0,237661.9) ops/second in (3.829598,67.322541) 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 255.7 61.10 56.14 182 0.336 0 0 0.0 0.0 L3 10/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 116/0 9.60 GB 1.0 0.0 0.0 0.0 0.0 0.0 14.5 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 56/0 4.86 GB 0.0 0.0 0.0 0.0 0.0 0.0 4.9 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 182/0 15.26 GB 0.0 0.0 0.0 0.0 15.3 15.3 34.6 1.0 0.0 255.7 61.10 56.14 182 0.336 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 14.9 14.9 34.2 1.0 0.0 260.3 58.56 53.74 178 0.329 0 0 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- High 0/0 0.00 KB 0.0 0.0 0.0 0.0 15.3 15.3 0.0 0.0 0.0 255.7 61.10 56.14 182 0.336 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 67.4 total, 64.3 interval Flush(GB): cumulative 15.256, interval 14.887 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 15.26 GB write, 231.95 MB/s write, 0.00 GB read, 0.00 MB/s read, 61.1 seconds Interval compaction: 14.89 GB write, 237.00 MB/s write, 0.00 GB read, 0.00 MB/s read, 58.6 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 125, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 125, interval: 121 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 910 Average: 644.7121 StdDev: 1172.37 Min: 1 Median: 8.0680 Max: 6110 Percentiles: P50: 8.07 P75: 695.46 P99: 4342.52 P99.9: 6110.00 P99.99: 6110.00 ------------------------------------------------------ [ 0, 1 ] 99 10.879% 10.879% ## ( 1, 2 ] 204 22.418% 33.297% #### ( 2, 3 ] 56 6.154% 39.451% # ( 3, 4 ] 3 0.330% 39.780% ( 4, 6 ] 17 1.868% 41.648% ( 6, 10 ] 147 16.154% 57.802% ### ( 10, 15 ] 17 1.868% 59.670% ( 15, 22 ] 1 0.110% 59.780% ( 34, 51 ] 2 0.220% 60.000% ( 250, 380 ] 94 10.330% 70.330% ## ( 380, 580 ] 21 2.308% 72.637% ( 580, 870 ] 54 5.934% 78.571% # ( 870, 1300 ] 54 5.934% 84.505% # ( 1300, 1900 ] 25 2.747% 87.253% # ( 1900, 2900 ] 4 0.440% 87.692% ( 2900, 4400 ] 107 11.758% 99.451% ## ( 4400, 6600 ] 5 0.549% 100.000% ** DB Stats ** Uptime(secs): 67.4 total, 3.8 interval Cumulative writes: 0 writes, 16M keys, 0 commit groups, 0.0 writes per commit group, ingest: 15.38 GB, 233.80 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:26.730 H:M:S, 39.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 256.99 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.307 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/26-11:04:51 ... thread 0: (1000000,17000000) ops and (271843.7,239432.8) ops/second in (3.678585,71.001126) 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 257.8 64.27 59.04 193 0.333 0 0 0.0 0.0 L2 1/0 62.99 MB 0.6 0.0 0.0 0.0 0.0 0.0 16.2 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L3 8/0 692.91 MB 0.7 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 116/0 9.60 GB 1.0 0.0 0.0 0.0 0.0 0.0 15.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 68/0 5.84 GB 0.1 0.0 0.0 0.0 0.0 0.0 5.8 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 193/0 16.18 GB 0.0 0.0 0.0 0.0 16.2 16.2 53.6 1.0 0.0 257.8 64.27 59.04 193 0.333 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 15.8 15.8 53.2 1.0 0.0 262.2 61.74 56.64 189 0.327 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 257.8 64.27 59.04 193 0.333 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 71.0 total, 68.0 interval Flush(GB): cumulative 16.179, interval 15.810 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, 233.24 MB/s write, 0.00 GB read, 0.00 MB/s read, 64.3 seconds Interval compaction: 15.81 GB write, 238.07 MB/s write, 0.00 GB read, 0.00 MB/s read, 61.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: 132, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 132, interval: 128 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 965 Average: 640.2705 StdDev: 1165.38 Min: 1 Median: 8.0764 Max: 6110 Percentiles: P50: 8.08 P75: 693.75 P99: 4337.72 P99.9: 6110.00 P99.99: 6110.00 ------------------------------------------------------ [ 0, 1 ] 104 10.777% 10.777% ## ( 1, 2 ] 221 22.902% 33.679% ##### ( 2, 3 ] 56 5.803% 39.482% # ( 3, 4 ] 3 0.311% 39.793% ( 4, 6 ] 17 1.762% 41.554% ( 6, 10 ] 157 16.269% 57.824% ### ( 10, 15 ] 18 1.865% 59.689% ( 15, 22 ] 1 0.104% 59.793% ( 34, 51 ] 2 0.207% 60.000% ( 250, 380 ] 101 10.466% 70.466% ## ( 380, 580 ] 21 2.176% 72.642% ( 580, 870 ] 58 6.010% 78.653% # ( 870, 1300 ] 57 5.907% 84.560% # ( 1300, 1900 ] 28 2.902% 87.461% # ( 1900, 2900 ] 4 0.415% 87.876% ( 2900, 4400 ] 112 11.606% 99.482% ## ( 4400, 6600 ] 5 0.518% 100.000% ** DB Stats ** Uptime(secs): 71.0 total, 3.7 interval Cumulative writes: 0 writes, 17M keys, 0 commit groups, 0.0 writes per commit group, ingest: 16.34 GB, 235.55 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:27.888 H:M:S, 39.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 267.55 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:1.158 H:M:S, 31.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/07/26-11:04:55 ... thread 0: (1000000,18000000) ops and (267550.0,240838.9) ops/second in (3.737619,74.738745) 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 259.6 67.70 62.16 205 0.330 0 0 0.0 0.0 L2 1/0 63.00 MB 0.6 0.0 0.0 0.0 0.0 0.0 17.2 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L3 8/0 692.92 MB 0.7 0.0 0.0 0.0 0.0 0.0 17.1 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 116/0 9.60 GB 1.0 0.0 0.0 0.0 0.0 0.0 16.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 80/0 6.83 GB 0.1 0.0 0.0 0.0 0.0 0.0 6.8 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 205/0 17.16 GB 0.0 0.0 0.0 0.0 17.2 17.2 57.5 1.0 0.0 259.6 67.70 62.16 205 0.330 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 16.8 16.8 57.1 1.0 0.0 263.9 65.17 59.76 201 0.324 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 259.6 67.70 62.16 205 0.330 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 74.8 total, 71.7 interval Flush(GB): cumulative 17.163, interval 16.794 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 17.16 GB write, 235.06 MB/s write, 0.00 GB read, 0.00 MB/s read, 67.7 seconds Interval compaction: 16.79 GB write, 239.72 MB/s write, 0.00 GB read, 0.00 MB/s read, 65.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: 140, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 140, interval: 136 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1025 Average: 640.4937 StdDev: 1163.90 Min: 1 Median: 8.0595 Max: 6110 Percentiles: P50: 8.06 P75: 691.09 P99: 4334.92 P99.9: 6110.00 P99.99: 6110.00 ------------------------------------------------------ [ 0, 1 ] 112 10.927% 10.927% ## ( 1, 2 ] 237 23.122% 34.049% ##### ( 2, 3 ] 56 5.463% 39.512% # ( 3, 4 ] 3 0.293% 39.805% ( 4, 6 ] 18 1.756% 41.561% ( 6, 10 ] 168 16.390% 57.951% ### ( 10, 15 ] 18 1.756% 59.707% ( 15, 22 ] 1 0.098% 59.805% ( 34, 51 ] 2 0.195% 60.000% ( 250, 380 ] 109 10.634% 70.634% ## ( 380, 580 ] 21 2.049% 72.683% ( 580, 870 ] 62 6.049% 78.732% # ( 870, 1300 ] 58 5.659% 84.390% # ( 1300, 1900 ] 30 2.927% 87.317% # ( 1900, 2900 ] 4 0.390% 87.707% ( 2900, 4400 ] 121 11.805% 99.512% ## ( 4400, 6600 ] 5 0.488% 100.000% ** DB Stats ** Uptime(secs): 74.8 total, 3.7 interval Cumulative writes: 0 writes, 18M keys, 0 commit groups, 0.0 writes per commit group, ingest: 17.30 GB, 236.94 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:29.100 H:M:S, 38.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 263.32 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:1.211 H:M:S, 32.4 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/07/26-11:04:59 ... thread 0: (1000000,19000000) ops and (262198.9,241876.0) ops/second in (3.813898,78.552643) 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 260.9 71.23 65.39 217 0.328 0 0 0.0 0.0 L2 1/0 63.00 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 8/0 692.93 MB 0.7 0.0 0.0 0.0 0.0 0.0 18.1 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 116/0 9.60 GB 1.0 0.0 0.0 0.0 0.0 0.0 17.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 92/0 7.81 GB 0.1 0.0 0.0 0.0 0.0 0.0 7.8 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 217/0 18.15 GB 0.0 0.0 0.0 0.0 18.1 18.1 61.5 1.0 0.0 260.9 71.23 65.39 217 0.328 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 17.8 17.8 61.1 1.0 0.0 265.0 68.69 62.99 213 0.323 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 260.9 71.23 65.39 217 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): 78.6 total, 75.6 interval Flush(GB): cumulative 18.147, interval 17.778 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, 236.48 MB/s write, 0.00 GB read, 0.00 MB/s read, 71.2 seconds Interval compaction: 17.78 GB write, 240.96 MB/s write, 0.00 GB read, 0.00 MB/s read, 68.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: 148, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 148, interval: 144 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1085 Average: 631.0396 StdDev: 1150.58 Min: 1 Median: 8.0337 Max: 6110 Percentiles: P50: 8.03 P75: 687.13 P99: 4329.80 P99.9: 6110.00 P99.99: 6110.00 ------------------------------------------------------ [ 0, 1 ] 120 11.060% 11.060% ## ( 1, 2 ] 253 23.318% 34.378% ##### ( 2, 3 ] 56 5.161% 39.539% # ( 3, 4 ] 3 0.276% 39.816% ( 4, 6 ] 20 1.843% 41.659% ( 6, 10 ] 178 16.406% 58.065% ### ( 10, 15 ] 18 1.659% 59.724% ( 15, 22 ] 1 0.092% 59.816% ( 34, 51 ] 2 0.184% 60.000% ( 250, 380 ] 117 10.783% 70.783% ## ( 380, 580 ] 21 1.935% 72.719% ( 580, 870 ] 67 6.175% 78.894% # ( 870, 1300 ] 64 5.899% 84.793% # ( 1300, 1900 ] 31 2.857% 87.650% # ( 1900, 2900 ] 4 0.369% 88.018% ( 2900, 4400 ] 125 11.521% 99.539% ## ( 4400, 6600 ] 5 0.461% 100.000% ** DB Stats ** Uptime(secs): 78.6 total, 3.8 interval Cumulative writes: 0 writes, 19M keys, 0 commit groups, 0.0 writes per commit group, ingest: 18.26 GB, 237.96 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:30.380 H:M:S, 38.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 258.05 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.280 H:M:S, 33.6 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 0 num-running-flushes: 1 2024/07/26-11:05:03 ... thread 0: (1000000,20000000) ops and (260322.2,242736.0) ops/second in (3.841394,82.394037) 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 262.1 74.76 68.61 229 0.326 0 0 0.0 0.0 L1 1/1 62.99 MB 0.0 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 8/0 692.94 MB 0.7 0.0 0.0 0.0 0.0 0.0 19.1 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 116/0 9.60 GB 1.0 0.0 0.0 0.0 0.0 0.0 18.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 104/0 8.80 GB 0.1 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 229/1 19.13 GB 0.0 0.0 0.0 0.0 19.1 19.1 65.4 1.0 0.0 262.1 74.76 68.61 229 0.326 0 0 0.0 0.0 Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 18.8 18.8 65.0 1.0 0.0 266.0 72.22 66.21 225 0.321 0 0 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- High 0/0 0.00 KB 0.0 0.0 0.0 0.0 19.1 19.1 0.0 0.0 0.0 262.1 74.76 68.61 229 0.326 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.4 total, 79.4 interval Flush(GB): cumulative 19.132, interval 18.763 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, 237.69 MB/s write, 0.00 GB read, 0.00 MB/s read, 74.8 seconds Interval compaction: 18.76 GB write, 241.99 MB/s write, 0.00 GB read, 0.00 MB/s read, 72.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: 156, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 156, interval: 152 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1145 Average: 631.6760 StdDev: 1156.66 Min: 1 Median: 8.0000 Max: 6384 Percentiles: P50: 8.00 P75: 685.18 P99: 4337.60 P99.9: 6180.17 P99.99: 6384.00 ------------------------------------------------------ [ 0, 1 ] 124 10.830% 10.830% ## ( 1, 2 ] 273 23.843% 34.672% ##### ( 2, 3 ] 56 4.891% 39.563% # ( 3, 4 ] 3 0.262% 39.825% ( 4, 6 ] 23 2.009% 41.834% ( 6, 10 ] 187 16.332% 58.166% ### ( 10, 15 ] 18 1.572% 59.738% ( 15, 22 ] 1 0.087% 59.825% ( 34, 51 ] 2 0.175% 60.000% ( 250, 380 ] 125 10.917% 70.917% ## ( 380, 580 ] 21 1.834% 72.751% ( 580, 870 ] 71 6.201% 78.952% # ( 870, 1300 ] 66 5.764% 84.716% # ( 1300, 1900 ] 34 2.969% 87.686% # ( 1900, 2900 ] 4 0.349% 88.035% ( 2900, 4400 ] 131 11.441% 99.476% ## ( 4400, 6600 ] 6 0.524% 100.000% ** DB Stats ** Uptime(secs): 82.4 total, 3.8 interval Cumulative writes: 0 writes, 20M keys, 0 commit groups, 0.0 writes per commit group, ingest: 19.22 GB, 238.81 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:31.682 H:M:S, 38.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 256.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:1.302 H:M:S, 33.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 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.120 micros/op 242733 ops/sec 82.395 seconds 20000000 operations; 235.2 MB/s Microseconds per write: Count: 20000000 Average: 4.1197 StdDev: 763.18 Min: 1 Median: 1.2392 Max: 672556 Percentiles: P50: 1.24 P75: 3.05 P99: 8.88 P99.9: 111.62 P99.99: 244.16 ------------------------------------------------------ [ 0, 1 ] 8592365 42.962% 42.962% ######### ( 1, 2 ] 5884733 29.424% 72.385% ###### ( 2, 3 ] 387458 1.937% 74.323% ( 3, 4 ] 2763901 13.820% 88.142% ### ( 4, 6 ] 1960178 9.801% 97.943% ## ( 6, 10 ] 293802 1.469% 99.412% ( 10, 15 ] 67306 0.337% 99.749% ( 15, 22 ] 22239 0.111% 99.860% ( 22, 34 ] 5373 0.027% 99.887% ( 34, 51 ] 1684 0.008% 99.895% ( 51, 76 ] 575 0.003% 99.898% ( 76, 110 ] 46 0.000% 99.898% ( 110, 170 ] 12559 0.063% 99.961% ( 170, 250 ] 6236 0.031% 99.992% ( 250, 380 ] 942 0.005% 99.997% ( 380, 580 ] 380 0.002% 99.999% ( 580, 870 ] 41 0.000% 99.999% ( 870, 1300 ] 7 0.000% 99.999% ( 1300, 1900 ] 1 0.000% 99.999% ( 1900, 2900 ] 14 0.000% 99.999% ( 2900, 4400 ] 5 0.000% 99.999% ( 4400, 6600 ] 7 0.000% 99.999% ( 6600, 9900 ] 10 0.000% 99.999% ( 9900, 14000 ] 20 0.000% 99.999% ( 14000, 22000 ] 9 0.000% 99.999% ( 22000, 33000 ] 4 0.000% 99.999% ( 33000, 50000 ] 6 0.000% 100.000% ( 50000, 75000 ] 13 0.000% 100.000% ( 110000, 170000 ] 2 0.000% 100.000% ( 170000, 250000 ] 1 0.000% 100.000% ( 250000, 380000 ] 56 0.000% 100.000% ( 380000, 570000 ] 24 0.000% 100.000% ( 570000, 860000 ] 3 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 : 229 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 31682490 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 : 20542519164 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 : 20378132480 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 : 124491407 rocksdb.non.last.level.read.count COUNT : 1145 rocksdb.block.checksum.compute.count COUNT : 687 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.689463 P95 : 4.523183 P99 : 7.362351 P100 : 672553.000000 COUNT : 20000000 SUM : 71257765 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 : 561.746032 P95 : 756.000000 P99 : 756.000000 P100 : 756.000000 COUNT : 229 SUM : 132370 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 : 249.603960 P95 : 2271.232877 P99 : 2774.246575 P100 : 2888.000000 COUNT : 918 SUM : 529660 rocksdb.table.open.io.micros P50 : 3388.839286 P95 : 6131.714286 P99 : 7509.000000 P100 : 7509.000000 COUNT : 229 SUM : 819547 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 : 1129.178082 P95 : 4238.372093 P99 : 5480.444444 P100 : 6453.000000 COUNT : 458 SUM : 768369 rocksdb.write.raw.block.micros P50 : 0.694268 P95 : 1.935365 P99 : 5.617388 P100 : 5264.000000 COUNT : 4976135 SUM : 15673521 rocksdb.numfiles.in.singlecompaction P50 : 1.000000 P95 : 3.577160 P99 : 3.915432 P100 : 4.000000 COUNT : 685 SUM : 1010 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 : 261607.142857 P95 : 532000.000000 P99 : 672292.000000 P100 : 672292.000000 COUNT : 156 SUM : 31682490 rocksdb.sst.read.micros P50 : 8.000000 P95 : 3813.167939 P99 : 4337.595420 P100 : 6384.000000 COUNT : 1145 SUM : 723269 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 : 242698.412698 P95 : 701880.952381 P99 : 828376.190476 P100 : 835539.000000 COUNT : 229 SUM : 74759478 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