[2024-12-08 18:47:23.778091] Starting SPDK v24.01.1-pre git sha1 c13c99a5e / DPDK 23.11.0 initialization... [2024-12-08 18:47:23.778232] [ DPDK EAL parameters: rocksdb --no-shconf -c 0x1 --huge-unlink --no-telemetry --log-level=lib.eal:6 --log-level=lib.cryptodev:5 --log-level=user1:6 --base-virtaddr=0x200000000000 --match-allocations --file-prefix=spdk_pid1885772 ] Set seed to 1733680043775484 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-12-08 18:47:23.904799] app.c: 798:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-12-08 18:47:23.944454] app.c: 488:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-12-08 18:47:23.944503] app.c: 489:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 1885772' to capture a snapshot of events at runtime. [2024-12-08 18:47:23.944519] app.c: 494:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid1885772 for offline analysis/debug. [2024-12-08 18:47:23.944553] reactor.c: 937:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Sun Dec 8 18:47:25 2024 CPU: 72 * Intel(R) Xeon(R) Gold 6140 CPU @ 2.30GHz CPUCache: 25344 KB 2024/12/08-18:47:28 ... thread 0: (1000000,1000000) ops and (334662.7,334662.7) ops/second in (2.988083,2.988083) 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 7/4 441.01 MB 18.9 0.0 0.0 0.0 0.9 0.9 0.0 1.0 0.0 353.3 2.50 2.34 13 0.192 0 0 0.0 0.0 L1 4/0 251.76 MB 25.2 0.2 0.2 0.0 0.2 0.2 0.2 1.0 251.9 251.6 1.00 0.98 1 1.001 255K 232 0.0 0.0 L2 3/2 188.88 MB 0.0 0.2 0.1 0.1 0.2 0.1 0.1 1.5 250.8 250.7 0.75 0.74 1 0.753 191K 80 0.0 0.0 L3 10/0 804.11 MB 0.8 0.0 0.0 0.0 0.0 0.0 0.1 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 116/0 9.54 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1068/0 85.82 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1208/6 97.00 GB 0.0 0.4 0.4 0.1 1.3 1.2 0.4 1.5 103.7 311.2 4.25 4.06 15 0.283 447K 312 0.0 0.0 Int 0/0 0.00 KB 0.0 0.4 0.4 0.1 1.3 1.2 0.2 1.5 103.7 311.2 4.25 4.06 15 0.283 447K 312 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) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 0.4 0.4 0.1 0.4 0.4 0.0 0.0 251.4 251.2 1.75 1.72 2 0.877 447K 312 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 0.9 0.9 0.0 0.0 0.0 353.3 2.50 2.34 13 0.192 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 3.1 total, 3.0 interval Flush(GB): cumulative 0.861, interval 0.861 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.29 GB write, 420.04 MB/s write, 0.43 GB read, 140.05 MB/s read, 4.3 seconds Interval compaction: 1.29 GB write, 442.36 MB/s write, 0.43 GB read, 147.49 MB/s read, 4.3 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 1, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 1, interval: 1 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 155100 Average: 1.9010 StdDev: 4.91 Min: 0 Median: 1.2994 Max: 1493 Percentiles: P50: 1.30 P75: 1.73 P99: 5.38 P99.9: 9.84 P99.99: 171.78 ------------------------------------------------------ [ 0, 1 ] 50627 32.642% 32.642% ####### ( 1, 2 ] 89936 57.986% 90.627% ############ ( 2, 3 ] 7872 5.075% 95.703% # ( 3, 4 ] 3748 2.417% 98.119% ( 4, 6 ] 1978 1.275% 99.395% ( 6, 10 ] 818 0.527% 99.922% ( 10, 15 ] 87 0.056% 99.978% ( 15, 22 ] 12 0.008% 99.986% ( 22, 34 ] 4 0.003% 99.988% ( 34, 51 ] 1 0.001% 99.989% ( 76, 110 ] 1 0.001% 99.990% ( 110, 170 ] 1 0.001% 99.990% ( 170, 250 ] 22 0.014% 100.005% ( 250, 380 ] 2 0.001% 100.006% ( 380, 580 ] 1 0.001% 100.006% ( 1300, 1900 ] 1 0.001% 100.007% ** Level 1 read latency histogram (micros): Count: 20 Average: 98.6500 StdDev: 186.25 Min: 1 Median: 1.6667 Max: 649 Percentiles: P50: 1.67 P75: 22.00 P99: 649.00 P99.9: 649.00 P99.99: 649.00 ------------------------------------------------------ [ 0, 1 ] 6 30.000% 30.000% ###### ( 1, 2 ] 6 30.000% 60.000% ###### ( 2, 3 ] 1 5.000% 65.000% # ( 4, 6 ] 1 5.000% 70.000% # ( 15, 22 ] 1 5.000% 75.000% # ( 110, 170 ] 1 5.000% 80.000% # ( 250, 380 ] 1 5.000% 85.000% # ( 380, 580 ] 2 10.000% 95.000% ## ( 580, 870 ] 1 5.000% 100.000% # ** Level 2 read latency histogram (micros): Count: 39116 Average: 2.4181 StdDev: 16.90 Min: 1 Median: 1.5031 Max: 2702 Percentiles: P50: 1.50 P75: 1.88 P99: 7.10 P99.9: 14.08 P99.99: 685.21 ------------------------------------------------------ [ 0, 1 ] 6614 16.909% 16.909% ### ( 1, 2 ] 25727 65.771% 82.680% ############# ( 2, 3 ] 3202 8.186% 90.866% ## ( 3, 4 ] 1847 4.722% 95.587% # ( 4, 6 ] 1235 3.157% 98.745% # ( 6, 10 ] 363 0.928% 99.673% ( 10, 15 ] 109 0.279% 99.951% ( 15, 22 ] 2 0.005% 99.957% ( 22, 34 ] 1 0.003% 99.959% ( 34, 51 ] 1 0.003% 99.962% ( 51, 76 ] 1 0.003% 99.964% ( 110, 170 ] 4 0.010% 99.974% ( 170, 250 ] 1 0.003% 99.977% ( 380, 580 ] 4 0.010% 99.987% ( 580, 870 ] 3 0.008% 99.995% ( 870, 1300 ] 1 0.003% 99.997% ( 1900, 2900 ] 1 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 40 Average: 1110.9750 StdDev: 835.82 Min: 148 Median: 812.0000 Max: 3302 Percentiles: P50: 812.00 P75: 1600.00 P99: 3302.00 P99.9: 3302.00 P99.99: 3302.00 ------------------------------------------------------ ( 110, 170 ] 1 2.500% 2.500% # ( 170, 250 ] 2 5.000% 7.500% # ( 250, 380 ] 3 7.500% 15.000% ## ( 380, 580 ] 10 25.000% 40.000% ##### ( 580, 870 ] 5 12.500% 52.500% ### ( 870, 1300 ] 5 12.500% 65.000% ### ( 1300, 1900 ] 8 20.000% 85.000% #### ( 1900, 2900 ] 3 7.500% 92.500% ## ( 2900, 4400 ] 3 7.500% 100.000% ## ** Level 4 read latency histogram (micros): Count: 30 Average: 1192.4000 StdDev: 445.63 Min: 410 Median: 1171.0000 Max: 2616 Percentiles: P50: 1171.00 P75: 1570.00 P99: 2616.00 P99.9: 2616.00 P99.99: 2616.00 ------------------------------------------------------ ( 380, 580 ] 2 6.667% 6.667% # ( 580, 870 ] 6 20.000% 26.667% #### ( 870, 1300 ] 10 33.333% 60.000% ####### ( 1300, 1900 ] 10 33.333% 93.333% ####### ( 1900, 2900 ] 2 6.667% 100.000% # ** DB Stats ** Uptime(secs): 3.1 total, 3.0 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 312.54 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:0.206 H:M:S, 6.5 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 329.11 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.206 H:M:S, 6.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/08-18:47:31 ... thread 0: (1000000,2000000) ops and (353674.3,343906.0) ops/second in (2.827460,5.815543) 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 10/4 1.35 GB 113.3 1.0 0.0 1.0 2.8 1.8 0.0 1.6 111.5 313.6 9.04 8.59 32 0.282 1023K 965 0.0 0.0 L1 0/0 0.00 KB 0.0 0.2 0.2 0.0 0.2 0.2 0.2 1.0 251.9 251.6 1.00 0.98 1 1.001 255K 232 0.0 0.0 L2 1/0 3.68 MB 0.0 0.2 0.1 0.1 0.2 0.1 0.3 1.5 244.2 244.1 0.79 0.76 2 0.394 195K 85 0.0 0.0 L3 26/0 989.53 MB 1.0 0.6 0.4 0.2 0.6 0.4 0.1 1.4 211.5 211.3 2.95 2.80 3 0.984 633K 524 0.0 0.0 L4 148/0 9.41 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.2 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1072/0 86.19 GB 0.9 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 1257/4 97.92 GB 0.0 2.0 0.8 1.2 3.8 2.6 1.2 2.1 150.7 283.2 13.78 13.13 38 0.363 2108K 1806 0.0 0.0 Int 0/0 0.00 KB 0.0 2.0 0.8 1.2 3.8 2.6 1.1 2.1 150.7 283.2 13.78 13.13 38 0.363 2108K 1806 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) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 2.0 0.8 1.2 2.0 0.8 0.0 0.0 239.7 239.4 8.67 8.36 10 0.867 2108K 1806 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 1.8 1.8 0.0 0.0 0.0 357.3 5.11 4.77 28 0.183 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 6.0 total, 5.8 interval Flush(GB): cumulative 1.784, interval 1.784 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.81 GB write, 652.92 MB/s write, 2.03 GB read, 347.53 MB/s read, 13.8 seconds Interval compaction: 3.81 GB write, 670.75 MB/s write, 2.03 GB read, 357.02 MB/s read, 13.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: 1, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 1, interval: 1 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 396944 Average: 2.0226 StdDev: 5.47 Min: 0 Median: 1.3791 Max: 1493 Percentiles: P50: 1.38 P75: 1.79 P99: 5.71 P99.9: 11.16 P99.99: 21.93 ------------------------------------------------------ [ 0, 1 ] 107607 27.109% 27.109% ##### ( 1, 2 ] 239710 60.389% 87.498% ############ ( 2, 3 ] 26863 6.767% 94.265% # ( 3, 4 ] 12683 3.195% 97.460% # ( 4, 6 ] 7139 1.798% 99.259% ( 6, 10 ] 2457 0.619% 99.878% ( 10, 15 ] 380 0.096% 99.974% ( 15, 22 ] 66 0.017% 99.990% ( 22, 34 ] 15 0.004% 99.994% ( 34, 51 ] 2 0.001% 99.994% ( 51, 76 ] 3 0.001% 99.995% ( 76, 110 ] 3 0.001% 99.996% ( 110, 170 ] 2 0.001% 99.996% ( 170, 250 ] 43 0.011% 100.007% ( 250, 380 ] 10 0.003% 100.010% ( 380, 580 ] 3 0.001% 100.011% ( 580, 870 ] 3 0.001% 100.011% ( 870, 1300 ] 2 0.001% 100.012% ( 1300, 1900 ] 2 0.001% 100.012% ** Level 1 read latency histogram (micros): Count: 63917 Average: 2.3592 StdDev: 3.93 Min: 1 Median: 1.5820 Max: 649 Percentiles: P50: 1.58 P75: 1.97 P99: 6.99 P99.9: 14.26 P99.99: 23.22 ------------------------------------------------------ [ 0, 1 ] 7964 12.460% 12.460% ## ( 1, 2 ] 41226 64.499% 76.959% ############# ( 2, 3 ] 7913 12.380% 89.339% ## ( 3, 4 ] 3517 5.502% 94.842% # ( 4, 6 ] 2514 3.933% 98.775% # ( 6, 10 ] 581 0.909% 99.684% ( 10, 15 ] 162 0.253% 99.937% ( 15, 22 ] 33 0.052% 99.989% ( 22, 34 ] 6 0.009% 99.998% ( 34, 51 ] 2 0.003% 100.002% ( 51, 76 ] 1 0.002% 100.003% ( 110, 170 ] 1 0.002% 100.005% ( 250, 380 ] 1 0.002% 100.006% ( 380, 580 ] 2 0.003% 100.009% ( 580, 870 ] 1 0.002% 100.011% ** Level 2 read latency histogram (micros): Count: 47979 Average: 2.3774 StdDev: 15.27 Min: 1 Median: 1.5048 Max: 2702 Percentiles: P50: 1.50 P75: 1.88 P99: 6.99 P99.9: 14.08 P99.99: 599.54 ------------------------------------------------------ [ 0, 1 ] 8010 16.695% 16.695% ### ( 1, 2 ] 31655 65.977% 82.672% ############# ( 2, 3 ] 4000 8.337% 91.009% ## ( 3, 4 ] 2239 4.667% 95.675% # ( 4, 6 ] 1488 3.101% 98.777% # ( 6, 10 ] 432 0.900% 99.677% ( 10, 15 ] 131 0.273% 99.950% ( 15, 22 ] 6 0.013% 99.962% ( 22, 34 ] 1 0.002% 99.965% ( 34, 51 ] 1 0.002% 99.967% ( 51, 76 ] 2 0.004% 99.971% ( 110, 170 ] 4 0.008% 99.979% ( 170, 250 ] 1 0.002% 99.981% ( 380, 580 ] 4 0.008% 99.990% ( 580, 870 ] 3 0.006% 99.996% ( 870, 1300 ] 1 0.002% 99.998% ( 1900, 2900 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 47877 Average: 3.3073 StdDev: 40.39 Min: 0 Median: 1.5634 Max: 3302 Percentiles: P50: 1.56 P75: 1.95 P99: 7.88 P99.9: 119.63 P99.99: 1765.92 ------------------------------------------------------ [ 0, 1 ] 6638 13.865% 13.865% ### ( 1, 2 ] 30707 64.137% 78.002% ############# ( 2, 3 ] 5483 11.452% 89.454% ## ( 3, 4 ] 2644 5.522% 94.977% # ( 4, 6 ] 1713 3.578% 98.555% # ( 6, 10 ] 453 0.946% 99.501% ( 10, 15 ] 114 0.238% 99.739% ( 15, 22 ] 25 0.052% 99.791% ( 22, 34 ] 45 0.094% 99.885% ( 34, 51 ] 6 0.013% 99.898% ( 110, 170 ] 7 0.015% 99.912% ( 170, 250 ] 3 0.006% 99.919% ( 250, 380 ] 6 0.013% 99.931% ( 380, 580 ] 12 0.025% 99.956% ( 580, 870 ] 5 0.010% 99.967% ( 870, 1300 ] 5 0.010% 99.977% ( 1300, 1900 ] 8 0.017% 99.994% ( 1900, 2900 ] 3 0.006% 100.000% ( 2900, 4400 ] 3 0.006% 100.006% ** Level 4 read latency histogram (micros): Count: 30 Average: 1192.4000 StdDev: 445.63 Min: 410 Median: 1171.0000 Max: 2616 Percentiles: P50: 1171.00 P75: 1570.00 P99: 2616.00 P99.9: 2616.00 P99.99: 2616.00 ------------------------------------------------------ ( 380, 580 ] 2 6.667% 6.667% # ( 580, 870 ] 6 20.000% 26.667% #### ( 870, 1300 ] 10 33.333% 60.000% ####### ( 1300, 1900 ] 10 33.333% 93.333% ####### ( 1900, 2900 ] 2 6.667% 100.000% # ** Level 5 read latency histogram (micros): Count: 20 Average: 339.3000 StdDev: 295.29 Min: 111 Median: 196.6667 Max: 1148 Percentiles: P50: 196.67 P75: 380.00 P99: 1148.00 P99.9: 1148.00 P99.99: 1148.00 ------------------------------------------------------ ( 110, 170 ] 9 45.000% 45.000% ######### ( 170, 250 ] 3 15.000% 60.000% ### ( 250, 380 ] 3 15.000% 75.000% ### ( 380, 580 ] 1 5.000% 80.000% # ( 580, 870 ] 2 10.000% 90.000% ## ( 870, 1300 ] 2 10.000% 100.000% ## ** DB Stats ** Uptime(secs): 6.0 total, 2.8 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 329.36 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:0.206 H:M:S, 3.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 348.08 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.000 H:M:S, 0.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/12/08-18:47:34 ... thread 0: (1000000,3000000) ops and (319956.0,335534.0) ops/second in (3.125430,8.940973) 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 12/4 2.34 GB 207.7 2.0 0.0 2.0 4.8 2.8 0.0 1.7 131.6 311.0 15.79 15.07 50 0.316 2110K 2035 0.0 0.0 L1 0/0 0.00 KB 0.0 0.2 0.2 0.0 0.2 0.2 0.2 1.0 251.9 251.6 1.00 0.98 1 1.001 255K 232 0.0 0.0 L2 1/0 3.68 MB 0.0 0.2 0.1 0.1 0.2 0.1 0.3 1.5 244.2 244.1 0.79 0.76 2 0.394 195K 85 0.0 0.0 L3 26/0 989.53 MB 1.0 0.6 0.4 0.2 0.6 0.4 0.1 1.4 211.5 211.3 2.95 2.80 3 0.984 633K 524 0.0 0.0 L4 148/0 9.41 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.2 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1072/0 86.19 GB 0.9 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 1259/4 98.90 GB 0.0 3.1 0.8 2.3 5.8 3.6 1.2 2.1 153.3 291.2 20.53 19.61 56 0.367 3196K 2876 0.0 0.0 Int 0/0 0.00 KB 0.0 3.1 0.8 2.3 5.8 3.6 1.1 2.1 153.3 291.2 20.53 19.61 56 0.367 3196K 2876 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) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 3.1 0.8 2.3 3.1 0.8 0.0 0.0 249.1 248.8 12.64 12.25 14 0.903 3196K 2876 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 2.8 2.8 0.0 0.0 0.0 359.1 7.89 7.36 42 0.188 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): 9.1 total, 8.9 interval Flush(GB): cumulative 2.769, interval 2.769 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.84 GB write, 657.01 MB/s write, 3.07 GB read, 345.86 MB/s read, 20.5 seconds Interval compaction: 5.84 GB write, 668.67 MB/s write, 3.07 GB read, 352.01 MB/s read, 20.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: 4, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 4, interval: 4 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 647322 Average: 1.9607 StdDev: 6.27 Min: 0 Median: 1.3397 Max: 1501 Percentiles: P50: 1.34 P75: 1.76 P99: 5.49 P99.9: 11.19 P99.99: 23.96 ------------------------------------------------------ [ 0, 1 ] 191694 29.613% 29.613% ###### ( 1, 2 ] 388479 60.013% 89.627% ############ ( 2, 3 ] 37676 5.820% 95.447% # ( 3, 4 ] 16529 2.553% 98.000% # ( 4, 6 ] 8695 1.343% 99.344% ( 6, 10 ] 3452 0.533% 99.877% ( 10, 15 ] 635 0.098% 99.975% ( 15, 22 ] 95 0.015% 99.990% ( 22, 34 ] 20 0.003% 99.993% ( 34, 51 ] 6 0.001% 99.994% ( 51, 76 ] 6 0.001% 99.995% ( 76, 110 ] 3 0.000% 99.995% ( 110, 170 ] 2 0.000% 99.995% ( 170, 250 ] 61 0.009% 100.005% ( 250, 380 ] 16 0.002% 100.007% ( 380, 580 ] 7 0.001% 100.008% ( 580, 870 ] 5 0.001% 100.009% ( 870, 1300 ] 6 0.001% 100.010% ( 1300, 1900 ] 4 0.001% 100.011% ** Level 1 read latency histogram (micros): Count: 63917 Average: 2.3592 StdDev: 3.93 Min: 1 Median: 1.5820 Max: 649 Percentiles: P50: 1.58 P75: 1.97 P99: 6.99 P99.9: 14.26 P99.99: 23.22 ------------------------------------------------------ [ 0, 1 ] 7964 12.460% 12.460% ## ( 1, 2 ] 41226 64.499% 76.959% ############# ( 2, 3 ] 7913 12.380% 89.339% ## ( 3, 4 ] 3517 5.502% 94.842% # ( 4, 6 ] 2514 3.933% 98.775% # ( 6, 10 ] 581 0.909% 99.684% ( 10, 15 ] 162 0.253% 99.937% ( 15, 22 ] 33 0.052% 99.989% ( 22, 34 ] 6 0.009% 99.998% ( 34, 51 ] 2 0.003% 100.002% ( 51, 76 ] 1 0.002% 100.003% ( 110, 170 ] 1 0.002% 100.005% ( 250, 380 ] 1 0.002% 100.006% ( 380, 580 ] 2 0.003% 100.009% ( 580, 870 ] 1 0.002% 100.011% ** Level 2 read latency histogram (micros): Count: 47979 Average: 2.3774 StdDev: 15.27 Min: 1 Median: 1.5048 Max: 2702 Percentiles: P50: 1.50 P75: 1.88 P99: 6.99 P99.9: 14.08 P99.99: 599.54 ------------------------------------------------------ [ 0, 1 ] 8010 16.695% 16.695% ### ( 1, 2 ] 31655 65.977% 82.672% ############# ( 2, 3 ] 4000 8.337% 91.009% ## ( 3, 4 ] 2239 4.667% 95.675% # ( 4, 6 ] 1488 3.101% 98.777% # ( 6, 10 ] 432 0.900% 99.677% ( 10, 15 ] 131 0.273% 99.950% ( 15, 22 ] 6 0.013% 99.962% ( 22, 34 ] 1 0.002% 99.965% ( 34, 51 ] 1 0.002% 99.967% ( 51, 76 ] 2 0.004% 99.971% ( 110, 170 ] 4 0.008% 99.979% ( 170, 250 ] 1 0.002% 99.981% ( 380, 580 ] 4 0.008% 99.990% ( 580, 870 ] 3 0.006% 99.996% ( 870, 1300 ] 1 0.002% 99.998% ( 1900, 2900 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 47877 Average: 3.3073 StdDev: 40.39 Min: 0 Median: 1.5634 Max: 3302 Percentiles: P50: 1.56 P75: 1.95 P99: 7.88 P99.9: 119.63 P99.99: 1765.92 ------------------------------------------------------ [ 0, 1 ] 6638 13.865% 13.865% ### ( 1, 2 ] 30707 64.137% 78.002% ############# ( 2, 3 ] 5483 11.452% 89.454% ## ( 3, 4 ] 2644 5.522% 94.977% # ( 4, 6 ] 1713 3.578% 98.555% # ( 6, 10 ] 453 0.946% 99.501% ( 10, 15 ] 114 0.238% 99.739% ( 15, 22 ] 25 0.052% 99.791% ( 22, 34 ] 45 0.094% 99.885% ( 34, 51 ] 6 0.013% 99.898% ( 110, 170 ] 7 0.015% 99.912% ( 170, 250 ] 3 0.006% 99.919% ( 250, 380 ] 6 0.013% 99.931% ( 380, 580 ] 12 0.025% 99.956% ( 580, 870 ] 5 0.010% 99.967% ( 870, 1300 ] 5 0.010% 99.977% ( 1300, 1900 ] 8 0.017% 99.994% ( 1900, 2900 ] 3 0.006% 100.000% ( 2900, 4400 ] 3 0.006% 100.006% ** Level 4 read latency histogram (micros): Count: 30 Average: 1192.4000 StdDev: 445.63 Min: 410 Median: 1171.0000 Max: 2616 Percentiles: P50: 1171.00 P75: 1570.00 P99: 2616.00 P99.9: 2616.00 P99.99: 2616.00 ------------------------------------------------------ ( 380, 580 ] 2 6.667% 6.667% # ( 580, 870 ] 6 20.000% 26.667% #### ( 870, 1300 ] 10 33.333% 60.000% ####### ( 1300, 1900 ] 10 33.333% 93.333% ####### ( 1900, 2900 ] 2 6.667% 100.000% # ** Level 5 read latency histogram (micros): Count: 20 Average: 339.3000 StdDev: 295.29 Min: 111 Median: 196.6667 Max: 1148 Percentiles: P50: 196.67 P75: 380.00 P99: 1148.00 P99.9: 1148.00 P99.99: 1148.00 ------------------------------------------------------ ( 110, 170 ] 9 45.000% 45.000% ######### ( 170, 250 ] 3 15.000% 60.000% ### ( 250, 380 ] 3 15.000% 75.000% ### ( 380, 580 ] 1 5.000% 80.000% # ( 580, 870 ] 2 10.000% 90.000% ## ( 870, 1300 ] 2 10.000% 100.000% ## ** DB Stats ** Uptime(secs): 9.1 total, 3.1 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 324.39 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:0.558 H:M:S, 6.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 314.90 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.352 H:M:S, 11.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/12/08-18:47:37 ... thread 0: (1000000,4000000) ops and (358046.5,340892.5) ops/second in (2.792933,11.733906) 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 18/4 3.26 GB 308.4 2.8 0.0 2.8 6.5 3.7 0.0 1.8 135.4 312.0 21.40 20.45 68 0.315 2942K 2850 0.0 0.0 L1 0/0 0.00 KB 0.0 0.2 0.2 0.0 0.2 0.2 0.2 1.0 251.9 251.6 1.00 0.98 1 1.001 255K 232 0.0 0.0 L2 1/0 3.68 MB 0.0 0.2 0.1 0.1 0.2 0.1 0.3 1.5 244.2 244.1 0.79 0.76 2 0.394 195K 85 0.0 0.0 L3 26/0 989.53 MB 1.0 0.6 0.4 0.2 0.6 0.4 0.1 1.4 211.5 211.3 2.95 2.80 3 0.984 633K 524 0.0 0.0 L4 148/0 9.41 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.2 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1072/0 86.19 GB 0.9 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 1265/4 99.82 GB 0.0 3.9 0.8 3.1 7.6 4.5 1.2 2.0 151.8 296.2 26.14 24.99 74 0.353 4027K 3691 0.0 0.0 Int 0/0 0.00 KB 0.0 3.9 0.8 3.1 7.6 4.5 1.1 2.0 151.8 296.2 26.14 24.99 74 0.353 4027K 3691 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) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 3.9 0.8 3.1 3.9 0.8 0.0 0.0 252.0 251.8 15.74 15.29 17 0.926 4027K 3691 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 3.7 3.7 0.0 0.0 0.0 363.5 10.40 9.70 57 0.182 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): 11.9 total, 11.7 interval Flush(GB): cumulative 3.691, interval 3.691 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 7.56 GB write, 650.96 MB/s write, 3.87 GB read, 333.50 MB/s read, 26.1 seconds Interval compaction: 7.56 GB write, 659.77 MB/s write, 3.87 GB read, 338.02 MB/s read, 26.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: 4, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 4, interval: 4 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 897493 Average: 1.9455 StdDev: 5.82 Min: 0 Median: 1.3371 Max: 1501 Percentiles: P50: 1.34 P75: 1.75 P99: 5.38 P99.9: 11.45 P99.99: 21.96 ------------------------------------------------------ [ 0, 1 ] 265344 29.565% 29.565% ###### ( 1, 2 ] 544095 60.624% 90.189% ############ ( 2, 3 ] 50084 5.580% 95.769% # ( 3, 4 ] 21682 2.416% 98.185% ( 4, 6 ] 10580 1.179% 99.364% ( 6, 10 ] 4528 0.505% 99.869% ( 10, 15 ] 974 0.109% 99.977% ( 15, 22 ] 117 0.013% 99.990% ( 22, 34 ] 28 0.003% 99.993% ( 34, 51 ] 6 0.001% 99.994% ( 51, 76 ] 7 0.001% 99.995% ( 76, 110 ] 3 0.000% 99.995% ( 110, 170 ] 2 0.000% 99.995% ( 170, 250 ] 86 0.010% 100.005% ( 250, 380 ] 22 0.002% 100.007% ( 380, 580 ] 9 0.001% 100.008% ( 580, 870 ] 6 0.001% 100.009% ( 870, 1300 ] 8 0.001% 100.010% ( 1300, 1900 ] 4 0.000% 100.010% ** Level 1 read latency histogram (micros): Count: 63917 Average: 2.3592 StdDev: 3.93 Min: 1 Median: 1.5820 Max: 649 Percentiles: P50: 1.58 P75: 1.97 P99: 6.99 P99.9: 14.26 P99.99: 23.22 ------------------------------------------------------ [ 0, 1 ] 7964 12.460% 12.460% ## ( 1, 2 ] 41226 64.499% 76.959% ############# ( 2, 3 ] 7913 12.380% 89.339% ## ( 3, 4 ] 3517 5.502% 94.842% # ( 4, 6 ] 2514 3.933% 98.775% # ( 6, 10 ] 581 0.909% 99.684% ( 10, 15 ] 162 0.253% 99.937% ( 15, 22 ] 33 0.052% 99.989% ( 22, 34 ] 6 0.009% 99.998% ( 34, 51 ] 2 0.003% 100.002% ( 51, 76 ] 1 0.002% 100.003% ( 110, 170 ] 1 0.002% 100.005% ( 250, 380 ] 1 0.002% 100.006% ( 380, 580 ] 2 0.003% 100.009% ( 580, 870 ] 1 0.002% 100.011% ** Level 2 read latency histogram (micros): Count: 47979 Average: 2.3774 StdDev: 15.27 Min: 1 Median: 1.5048 Max: 2702 Percentiles: P50: 1.50 P75: 1.88 P99: 6.99 P99.9: 14.08 P99.99: 599.54 ------------------------------------------------------ [ 0, 1 ] 8010 16.695% 16.695% ### ( 1, 2 ] 31655 65.977% 82.672% ############# ( 2, 3 ] 4000 8.337% 91.009% ## ( 3, 4 ] 2239 4.667% 95.675% # ( 4, 6 ] 1488 3.101% 98.777% # ( 6, 10 ] 432 0.900% 99.677% ( 10, 15 ] 131 0.273% 99.950% ( 15, 22 ] 6 0.013% 99.962% ( 22, 34 ] 1 0.002% 99.965% ( 34, 51 ] 1 0.002% 99.967% ( 51, 76 ] 2 0.004% 99.971% ( 110, 170 ] 4 0.008% 99.979% ( 170, 250 ] 1 0.002% 99.981% ( 380, 580 ] 4 0.008% 99.990% ( 580, 870 ] 3 0.006% 99.996% ( 870, 1300 ] 1 0.002% 99.998% ( 1900, 2900 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 47877 Average: 3.3073 StdDev: 40.39 Min: 0 Median: 1.5634 Max: 3302 Percentiles: P50: 1.56 P75: 1.95 P99: 7.88 P99.9: 119.63 P99.99: 1765.92 ------------------------------------------------------ [ 0, 1 ] 6638 13.865% 13.865% ### ( 1, 2 ] 30707 64.137% 78.002% ############# ( 2, 3 ] 5483 11.452% 89.454% ## ( 3, 4 ] 2644 5.522% 94.977% # ( 4, 6 ] 1713 3.578% 98.555% # ( 6, 10 ] 453 0.946% 99.501% ( 10, 15 ] 114 0.238% 99.739% ( 15, 22 ] 25 0.052% 99.791% ( 22, 34 ] 45 0.094% 99.885% ( 34, 51 ] 6 0.013% 99.898% ( 110, 170 ] 7 0.015% 99.912% ( 170, 250 ] 3 0.006% 99.919% ( 250, 380 ] 6 0.013% 99.931% ( 380, 580 ] 12 0.025% 99.956% ( 580, 870 ] 5 0.010% 99.967% ( 870, 1300 ] 5 0.010% 99.977% ( 1300, 1900 ] 8 0.017% 99.994% ( 1900, 2900 ] 3 0.006% 100.000% ( 2900, 4400 ] 3 0.006% 100.006% ** Level 4 read latency histogram (micros): Count: 30 Average: 1192.4000 StdDev: 445.63 Min: 410 Median: 1171.0000 Max: 2616 Percentiles: P50: 1171.00 P75: 1570.00 P99: 2616.00 P99.9: 2616.00 P99.99: 2616.00 ------------------------------------------------------ ( 380, 580 ] 2 6.667% 6.667% # ( 580, 870 ] 6 20.000% 26.667% #### ( 870, 1300 ] 10 33.333% 60.000% ####### ( 1300, 1900 ] 10 33.333% 93.333% ####### ( 1900, 2900 ] 2 6.667% 100.000% # ** Level 5 read latency histogram (micros): Count: 20 Average: 339.3000 StdDev: 295.29 Min: 111 Median: 196.6667 Max: 1148 Percentiles: P50: 196.67 P75: 380.00 P99: 1148.00 P99.9: 1148.00 P99.99: 1148.00 ------------------------------------------------------ ( 110, 170 ] 9 45.000% 45.000% ######### ( 170, 250 ] 3 15.000% 60.000% ### ( 250, 380 ] 3 15.000% 75.000% ### ( 380, 580 ] 1 5.000% 80.000% # ( 580, 870 ] 2 10.000% 90.000% ## ( 870, 1300 ] 2 10.000% 100.000% ## ** DB Stats ** Uptime(secs): 11.9 total, 2.8 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 330.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:0.558 H:M:S, 4.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 352.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:0.000 H:M:S, 0.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/12/08-18:47:52 ... thread 0: (1000000,5000000) ops and (65314.1,184880.2) ops/second in (15.310637,27.044543) 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 21/18 4.36 GB 37.8 4.1 0.0 4.1 8.9 4.8 0.0 1.8 142.5 310.8 29.18 27.95 91 0.321 4221K 4012 0.0 0.0 L1 0/0 0.00 KB 0.0 0.2 0.2 0.0 0.2 0.2 0.2 1.0 251.9 251.6 1.00 0.98 1 1.001 255K 232 0.0 0.0 L2 1/0 3.68 MB 0.0 0.2 0.1 0.1 0.2 0.1 0.3 1.5 244.2 244.1 0.79 0.76 2 0.394 195K 85 0.0 0.0 L3 26/0 989.53 MB 1.0 0.6 0.4 0.2 0.6 0.4 0.1 1.4 211.5 211.3 2.95 2.80 3 0.984 633K 524 0.0 0.0 L4 148/0 9.41 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.2 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1072/0 86.19 GB 0.9 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 1268/18 100.93 GB 0.0 5.1 0.8 4.3 9.9 5.6 1.2 2.1 154.1 298.8 33.92 32.48 97 0.350 5307K 4853 0.0 0.0 Int 0/0 0.00 KB 0.0 5.1 0.8 4.3 9.9 5.6 1.1 2.1 154.1 298.8 33.92 32.48 97 0.350 5307K 4853 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) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 5.1 0.8 4.3 5.1 0.8 0.0 0.0 255.4 255.1 20.47 19.95 22 0.930 5307K 4853 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 4.8 4.8 0.0 0.0 0.0 365.4 13.45 12.54 75 0.179 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.2 total, 27.0 interval Flush(GB): cumulative 4.799, interval 4.799 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.90 GB write, 372.56 MB/s write, 5.10 GB read, 192.13 MB/s read, 33.9 seconds Interval compaction: 9.90 GB write, 374.75 MB/s write, 5.10 GB read, 193.26 MB/s read, 33.9 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 13, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 13, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 4, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 13, total-stops: 4, interval: 17 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1957483 Average: 1.9250 StdDev: 5.80 Min: 0 Median: 1.2867 Max: 1501 Percentiles: P50: 1.29 P75: 1.70 P99: 5.38 P99.9: 14.07 P99.99: 164.46 ------------------------------------------------------ [ 0, 1 ] 642728 32.834% 32.834% ####### ( 1, 2 ] 1172175 59.882% 92.716% ############ ( 2, 3 ] 78294 4.000% 96.716% # ( 3, 4 ] 34362 1.755% 98.471% ( 4, 6 ] 15014 0.767% 99.238% ( 6, 10 ] 11485 0.587% 99.825% ( 10, 15 ] 1805 0.092% 99.917% ( 15, 22 ] 483 0.025% 99.942% ( 22, 34 ] 49 0.003% 99.944% ( 34, 51 ] 9 0.000% 99.945% ( 51, 76 ] 10 0.001% 99.945% ( 76, 110 ] 443 0.023% 99.968% ( 110, 170 ] 474 0.024% 99.992% ( 170, 250 ] 192 0.010% 100.002% ( 250, 380 ] 48 0.002% 100.004% ( 380, 580 ] 18 0.001% 100.005% ( 580, 870 ] 17 0.001% 100.006% ( 870, 1300 ] 12 0.001% 100.007% ( 1300, 1900 ] 5 0.000% 100.007% ** Level 1 read latency histogram (micros): Count: 63917 Average: 2.3592 StdDev: 3.93 Min: 1 Median: 1.5820 Max: 649 Percentiles: P50: 1.58 P75: 1.97 P99: 6.99 P99.9: 14.26 P99.99: 23.22 ------------------------------------------------------ [ 0, 1 ] 7964 12.460% 12.460% ## ( 1, 2 ] 41226 64.499% 76.959% ############# ( 2, 3 ] 7913 12.380% 89.339% ## ( 3, 4 ] 3517 5.502% 94.842% # ( 4, 6 ] 2514 3.933% 98.775% # ( 6, 10 ] 581 0.909% 99.684% ( 10, 15 ] 162 0.253% 99.937% ( 15, 22 ] 33 0.052% 99.989% ( 22, 34 ] 6 0.009% 99.998% ( 34, 51 ] 2 0.003% 100.002% ( 51, 76 ] 1 0.002% 100.003% ( 110, 170 ] 1 0.002% 100.005% ( 250, 380 ] 1 0.002% 100.006% ( 380, 580 ] 2 0.003% 100.009% ( 580, 870 ] 1 0.002% 100.011% ** Level 2 read latency histogram (micros): Count: 47979 Average: 2.3774 StdDev: 15.27 Min: 1 Median: 1.5048 Max: 2702 Percentiles: P50: 1.50 P75: 1.88 P99: 6.99 P99.9: 14.08 P99.99: 599.54 ------------------------------------------------------ [ 0, 1 ] 8010 16.695% 16.695% ### ( 1, 2 ] 31655 65.977% 82.672% ############# ( 2, 3 ] 4000 8.337% 91.009% ## ( 3, 4 ] 2239 4.667% 95.675% # ( 4, 6 ] 1488 3.101% 98.777% # ( 6, 10 ] 432 0.900% 99.677% ( 10, 15 ] 131 0.273% 99.950% ( 15, 22 ] 6 0.013% 99.962% ( 22, 34 ] 1 0.002% 99.965% ( 34, 51 ] 1 0.002% 99.967% ( 51, 76 ] 2 0.004% 99.971% ( 110, 170 ] 4 0.008% 99.979% ( 170, 250 ] 1 0.002% 99.981% ( 380, 580 ] 4 0.008% 99.990% ( 580, 870 ] 3 0.006% 99.996% ( 870, 1300 ] 1 0.002% 99.998% ( 1900, 2900 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 47877 Average: 3.3073 StdDev: 40.39 Min: 0 Median: 1.5634 Max: 3302 Percentiles: P50: 1.56 P75: 1.95 P99: 7.88 P99.9: 119.63 P99.99: 1765.92 ------------------------------------------------------ [ 0, 1 ] 6638 13.865% 13.865% ### ( 1, 2 ] 30707 64.137% 78.002% ############# ( 2, 3 ] 5483 11.452% 89.454% ## ( 3, 4 ] 2644 5.522% 94.977% # ( 4, 6 ] 1713 3.578% 98.555% # ( 6, 10 ] 453 0.946% 99.501% ( 10, 15 ] 114 0.238% 99.739% ( 15, 22 ] 25 0.052% 99.791% ( 22, 34 ] 45 0.094% 99.885% ( 34, 51 ] 6 0.013% 99.898% ( 110, 170 ] 7 0.015% 99.912% ( 170, 250 ] 3 0.006% 99.919% ( 250, 380 ] 6 0.013% 99.931% ( 380, 580 ] 12 0.025% 99.956% ( 580, 870 ] 5 0.010% 99.967% ( 870, 1300 ] 5 0.010% 99.977% ( 1300, 1900 ] 8 0.017% 99.994% ( 1900, 2900 ] 3 0.006% 100.000% ( 2900, 4400 ] 3 0.006% 100.006% ** Level 4 read latency histogram (micros): Count: 30 Average: 1192.4000 StdDev: 445.63 Min: 410 Median: 1171.0000 Max: 2616 Percentiles: P50: 1171.00 P75: 1570.00 P99: 2616.00 P99.9: 2616.00 P99.99: 2616.00 ------------------------------------------------------ ( 380, 580 ] 2 6.667% 6.667% # ( 580, 870 ] 6 20.000% 26.667% #### ( 870, 1300 ] 10 33.333% 60.000% ####### ( 1300, 1900 ] 10 33.333% 93.333% ####### ( 1900, 2900 ] 2 6.667% 100.000% # ** Level 5 read latency histogram (micros): Count: 20 Average: 339.3000 StdDev: 295.29 Min: 111 Median: 196.6667 Max: 1148 Percentiles: P50: 196.67 P75: 380.00 P99: 1148.00 P99.9: 1148.00 P99.99: 1148.00 ------------------------------------------------------ ( 110, 170 ] 9 45.000% 45.000% ######### ( 170, 250 ] 3 15.000% 60.000% ### ( 250, 380 ] 3 15.000% 75.000% ### ( 380, 580 ] 1 5.000% 80.000% # ( 580, 870 ] 2 10.000% 90.000% ## ( 870, 1300 ] 2 10.000% 100.000% ## ** DB Stats ** Uptime(secs): 27.2 total, 15.3 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 180.88 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:12.727 H:M:S, 46.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 64.28 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:12.169 H:M:S, 79.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 0 2024/12/08-18:48:04 ... thread 0: (1000000,6000000) ops and (86643.1,155496.2) ops/second in (11.541598,38.586141) 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 6/4 818.29 MB 18.9 4.4 0.0 4.4 10.0 5.6 0.0 1.8 125.3 283.5 36.21 31.97 101 0.358 4605K 4565 0.0 0.0 L1 3/3 168.18 MB 0.0 4.6 4.6 0.0 4.6 4.5 0.2 1.0 210.1 206.5 22.63 20.13 3 7.543 4793K 80K 0.0 0.0 L2 7/6 442.55 MB 0.0 0.2 0.1 0.1 0.2 0.1 4.4 1.5 244.2 244.1 0.79 0.76 2 0.394 195K 85 0.0 0.0 L3 35/19 2.27 GB 0.9 2.3 1.9 0.5 2.3 1.8 2.4 1.3 153.1 152.7 15.68 11.56 11 1.425 1639K 825 0.0 0.0 L4 146/0 9.51 GB 1.0 2.7 2.0 0.6 2.7 2.0 0.6 1.3 114.7 114.3 23.86 13.78 19 1.256 2750K 7205 0.0 0.0 L5 1100/0 88.46 GB 0.9 0.0 0.0 0.0 0.0 0.0 2.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1297/32 101.64 GB 0.0 14.3 8.6 5.7 19.8 14.1 10.2 3.5 147.4 204.2 99.16 78.20 136 0.729 13M 93K 0.0 0.0 Int 0/0 0.00 KB 0.0 14.3 8.6 5.7 19.8 14.1 10.1 3.5 147.4 204.2 99.16 78.20 136 0.729 13M 93K 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) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 14.3 8.6 5.7 14.2 8.5 0.0 0.0 181.3 180.0 80.65 63.25 52 1.551 13M 93K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 5.6 5.6 0.0 0.0 0.0 309.8 18.51 14.95 84 0.220 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): 38.7 total, 38.6 interval Flush(GB): cumulative 5.598, interval 5.598 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 19.78 GB write, 522.62 MB/s write, 14.28 GB read, 377.27 MB/s read, 99.2 seconds Interval compaction: 19.78 GB write, 524.77 MB/s write, 14.28 GB read, 378.83 MB/s read, 99.2 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 13, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 13, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 33, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 13, total-stops: 33, interval: 46 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2442320 Average: 2.8307 StdDev: 38.02 Min: 0 Median: 1.3387 Max: 17654 Percentiles: P50: 1.34 P75: 1.77 P99: 8.21 P99.9: 160.09 P99.99: 367.77 ------------------------------------------------------ [ 0, 1 ] 738373 30.232% 30.232% ###### ( 1, 2 ] 1425580 58.370% 88.602% ############ ( 2, 3 ] 131946 5.402% 94.005% # ( 3, 4 ] 64677 2.648% 96.653% # ( 4, 6 ] 46248 1.894% 98.547% ( 6, 10 ] 20083 0.822% 99.369% ( 10, 15 ] 3996 0.164% 99.533% ( 15, 22 ] 1022 0.042% 99.574% ( 22, 34 ] 82 0.003% 99.578% ( 34, 51 ] 17 0.001% 99.578% ( 51, 76 ] 14 0.001% 99.579% ( 76, 110 ] 2471 0.101% 99.680% ( 110, 170 ] 6431 0.263% 99.943% ( 170, 250 ] 652 0.027% 99.970% ( 250, 380 ] 535 0.022% 99.992% ( 380, 580 ] 86 0.004% 99.996% ( 580, 870 ] 53 0.002% 99.998% ( 870, 1300 ] 34 0.001% 99.999% ( 1300, 1900 ] 33 0.001% 100.001% ( 1900, 2900 ] 34 0.001% 100.002% ( 2900, 4400 ] 58 0.002% 100.004% ( 4400, 6600 ] 13 0.001% 100.005% ( 6600, 9900 ] 18 0.001% 100.006% ( 9900, 14000 ] 4 0.000% 100.006% ( 14000, 22000 ] 1 0.000% 100.006% ** Level 1 read latency histogram (micros): Count: 1034699 Average: 8.3739 StdDev: 158.83 Min: 1 Median: 2.0262 Max: 36820 Percentiles: P50: 2.03 P75: 3.22 P99: 10.86 P99.9: 20.72 P99.99: 223.50 ------------------------------------------------------ [ 0, 1 ] 24679 2.385% 2.385% ( 1, 2 ] 486378 47.007% 49.392% ######### ( 2, 3 ] 239847 23.180% 72.572% ##### ( 3, 4 ] 115240 11.138% 83.710% ## ( 4, 6 ] 130927 12.654% 96.363% ### ( 6, 10 ] 25544 2.469% 98.832% ( 10, 15 ] 10115 0.978% 99.810% ( 15, 22 ] 1147 0.111% 99.921% ( 22, 34 ] 150 0.014% 99.935% ( 34, 51 ] 44 0.004% 99.939% ( 51, 76 ] 17 0.002% 99.941% ( 76, 110 ] 48 0.005% 99.946% ( 110, 170 ] 189 0.018% 99.964% ( 170, 250 ] 409 0.040% 100.003% ( 250, 380 ] 449 0.043% 100.047% ( 380, 580 ] 368 0.036% 100.082% ( 580, 870 ] 210 0.020% 100.103% ( 870, 1300 ] 156 0.015% 100.118% ( 1300, 1900 ] 185 0.018% 100.136% ( 1900, 2900 ] 314 0.030% 100.166% ( 2900, 4400 ] 428 0.041% 100.207% ( 4400, 6600 ] 175 0.017% 100.224% ( 6600, 9900 ] 120 0.012% 100.236% ( 9900, 14000 ] 10 0.001% 100.237% ( 14000, 22000 ] 6 0.001% 100.237% ( 22000, 33000 ] 4 0.000% 100.238% ( 33000, 50000 ] 1 0.000% 100.238% ** Level 2 read latency histogram (micros): Count: 54830 Average: 9.6941 StdDev: 179.95 Min: 1 Median: 1.5539 Max: 11030 Percentiles: P50: 1.55 P75: 1.95 P99: 9.27 P99.9: 3339.00 P99.99: 8463.26 ------------------------------------------------------ [ 0, 1 ] 8139 14.844% 14.844% ### ( 1, 2 ] 34800 63.469% 78.313% ############# ( 2, 3 ] 5659 10.321% 88.634% ## ( 3, 4 ] 2945 5.371% 94.005% # ( 4, 6 ] 2247 4.098% 98.103% # ( 6, 10 ] 601 1.096% 99.199% ( 10, 15 ] 213 0.388% 99.588% ( 15, 22 ] 12 0.022% 99.610% ( 22, 34 ] 3 0.005% 99.615% ( 34, 51 ] 1 0.002% 99.617% ( 51, 76 ] 2 0.004% 99.621% ( 76, 110 ] 5 0.009% 99.630% ( 110, 170 ] 36 0.066% 99.695% ( 170, 250 ] 25 0.046% 99.741% ( 250, 380 ] 8 0.015% 99.756% ( 380, 580 ] 18 0.033% 99.788% ( 580, 870 ] 15 0.027% 99.816% ( 870, 1300 ] 8 0.015% 99.830% ( 1300, 1900 ] 8 0.015% 99.845% ( 1900, 2900 ] 17 0.031% 99.876% ( 2900, 4400 ] 45 0.082% 99.958% ( 4400, 6600 ] 13 0.024% 99.982% ( 6600, 9900 ] 8 0.015% 99.996% ( 9900, 14000 ] 2 0.004% 100.000% ** Level 3 read latency histogram (micros): Count: 449311 Average: 13.0587 StdDev: 189.25 Min: 0 Median: 1.9838 Max: 24768 Percentiles: P50: 1.98 P75: 3.19 P99: 14.97 P99.9: 1446.57 P99.99: 2999.48 ------------------------------------------------------ [ 0, 1 ] 14956 3.329% 3.329% # ( 1, 2 ] 213150 47.439% 50.768% ######### ( 2, 3 ] 99580 22.163% 72.931% #### ( 3, 4 ] 50166 11.165% 84.096% ## ( 4, 6 ] 52185 11.614% 95.710% ## ( 6, 10 ] 10531 2.344% 98.054% ( 10, 15 ] 4278 0.952% 99.006% ( 15, 22 ] 508 0.113% 99.119% ( 22, 34 ] 102 0.023% 99.142% ( 34, 51 ] 18 0.004% 99.146% ( 51, 76 ] 9 0.002% 99.148% ( 76, 110 ] 50 0.011% 99.159% ( 110, 170 ] 587 0.131% 99.290% ( 170, 250 ] 697 0.155% 99.445% ( 250, 380 ] 725 0.161% 99.606% ( 380, 580 ] 641 0.143% 99.749% ( 580, 870 ] 411 0.091% 99.840% ( 870, 1300 ] 233 0.052% 99.892% ( 1300, 1900 ] 142 0.032% 99.924% ( 1900, 2900 ] 272 0.061% 99.984% ( 2900, 4400 ] 378 0.084% 100.069% ( 4400, 6600 ] 71 0.016% 100.084% ( 6600, 9900 ] 52 0.012% 100.096% ( 9900, 14000 ] 4 0.001% 100.097% ( 14000, 22000 ] 8 0.002% 100.099% ( 22000, 33000 ] 2 0.000% 100.099% ** Level 4 read latency histogram (micros): Count: 95305 Average: 9.4391 StdDev: 139.25 Min: 1 Median: 1.9544 Max: 8353 Percentiles: P50: 1.95 P75: 3.00 P99: 12.41 P99.9: 1500.49 P99.99: 3685.55 ------------------------------------------------------ [ 0, 1 ] 2305 2.419% 2.419% ( 1, 2 ] 47512 49.853% 52.271% ########## ( 2, 3 ] 21754 22.826% 75.097% ##### ( 3, 4 ] 9905 10.393% 85.490% ## ( 4, 6 ] 10568 11.089% 96.578% ## ( 6, 10 ] 1911 2.005% 98.583% ( 10, 15 ] 825 0.866% 99.449% ( 15, 22 ] 87 0.091% 99.540% ( 22, 34 ] 11 0.012% 99.552% ( 34, 51 ] 3 0.003% 99.555% ( 51, 76 ] 4 0.004% 99.559% ( 76, 110 ] 1 0.001% 99.560% ( 110, 170 ] 17 0.018% 99.578% ( 170, 250 ] 65 0.068% 99.646% ( 250, 380 ] 72 0.076% 99.722% ( 380, 580 ] 82 0.086% 99.808% ( 580, 870 ] 44 0.046% 99.854% ( 870, 1300 ] 32 0.034% 99.888% ( 1300, 1900 ] 35 0.037% 99.924% ( 1900, 2900 ] 30 0.031% 99.956% ( 2900, 4400 ] 62 0.065% 100.021% ( 4400, 6600 ] 17 0.018% 100.039% ( 6600, 9900 ] 5 0.005% 100.044% ** Level 5 read latency histogram (micros): Count: 160 Average: 806.2000 StdDev: 1021.38 Min: 107 Median: 440.8696 Max: 7757 Percentiles: P50: 440.87 P75: 960.53 P99: 5280.00 P99.9: 7757.00 P99.99: 7757.00 ------------------------------------------------------ ( 76, 110 ] 1 0.625% 0.625% ( 110, 170 ] 18 11.250% 11.875% ## ( 170, 250 ] 29 18.125% 30.000% #### ( 250, 380 ] 25 15.625% 45.625% ### ( 380, 580 ] 23 14.375% 60.000% ### ( 580, 870 ] 20 12.500% 72.500% ### ( 870, 1300 ] 19 11.875% 84.375% ## ( 1300, 1900 ] 9 5.625% 90.000% # ( 1900, 2900 ] 4 2.500% 92.500% # ( 2900, 4400 ] 10 6.250% 98.750% # ( 4400, 6600 ] 1 0.625% 99.375% ( 6600, 9900 ] 1 0.625% 100.000% ** DB Stats ** Uptime(secs): 38.7 total, 11.5 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 152.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:20.394 H:M:S, 52.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 85.27 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:7.666 H:M:S, 66.4 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 7 num-running-flushes: 1 2024/12/08-18:48:07 ... thread 0: (1000000,7000000) ops and (277068.2,165895.0) ops/second in (3.609220,42.195361) 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 8/7 1.23 GB 6.3 5.3 0.0 5.3 11.9 6.6 0.0 1.8 125.3 282.6 43.22 38.20 119 0.363 5501K 5574 0.0 0.0 L1 11/11 795.08 MB 0.0 5.4 5.2 0.2 5.3 5.1 0.2 1.0 207.5 204.3 26.76 23.80 4 6.689 5603K 82K 0.0 0.0 L2 1/0 18.22 KB 0.0 0.2 0.1 0.1 0.2 0.1 4.4 1.5 244.2 244.1 0.79 0.76 2 0.394 195K 85 0.0 0.0 L3 16/0 880.93 MB 0.9 4.2 2.3 1.9 4.2 2.3 2.4 1.8 147.0 146.5 29.20 21.13 17 1.718 3429K 6974 0.0 0.0 L4 146/0 9.68 GB 1.0 3.2 2.5 0.7 3.2 2.5 2.0 1.3 121.3 120.9 27.00 16.30 24 1.125 3297K 8915 0.0 0.0 L5 1120/0 90.12 GB 0.9 0.0 0.0 0.0 0.0 0.0 4.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1302/18 102.67 GB 0.0 18.3 10.1 8.2 24.8 16.7 13.3 3.7 147.5 200.2 126.97 100.19 166 0.765 18M 104K 0.0 0.0 Int 0/0 0.00 KB 0.0 18.3 10.1 8.2 24.8 16.7 13.2 3.7 147.5 200.2 126.97 100.19 166 0.765 18M 104K 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) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 18.3 10.1 8.2 18.2 10.0 0.0 0.0 178.4 177.3 105.00 82.37 67 1.567 18M 104K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 6.6 6.6 0.0 0.0 0.0 309.6 21.97 17.82 99 0.222 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.4 total, 42.2 interval Flush(GB): cumulative 6.644, interval 6.644 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: 24.82 GB write, 600.11 MB/s write, 18.29 GB read, 442.15 MB/s read, 127.0 seconds Interval compaction: 24.82 GB write, 602.37 MB/s write, 18.29 GB read, 443.81 MB/s read, 127.0 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 13, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 13, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 49, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 13, total-stops: 49, interval: 62 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2787210 Average: 2.8215 StdDev: 37.25 Min: 0 Median: 1.3719 Max: 17654 Percentiles: P50: 1.37 P75: 1.80 P99: 8.10 P99.9: 157.16 P99.99: 349.35 ------------------------------------------------------ [ 0, 1 ] 782863 28.088% 28.088% ###### ( 1, 2 ] 1642086 58.915% 87.003% ############ ( 2, 3 ] 174160 6.249% 93.251% # ( 3, 4 ] 85280 3.060% 96.311% # ( 4, 6 ] 62318 2.236% 98.547% ( 6, 10 ] 24010 0.861% 99.408% ( 10, 15 ] 4930 0.177% 99.585% ( 15, 22 ] 1102 0.040% 99.625% ( 22, 34 ] 91 0.003% 99.628% ( 34, 51 ] 18 0.001% 99.629% ( 51, 76 ] 15 0.001% 99.629% ( 76, 110 ] 2481 0.089% 99.718% ( 110, 170 ] 6450 0.231% 99.950% ( 170, 250 ] 698 0.025% 99.975% ( 250, 380 ] 563 0.020% 99.995% ( 380, 580 ] 105 0.004% 99.999% ( 580, 870 ] 62 0.002% 100.001% ( 870, 1300 ] 37 0.001% 100.002% ( 1300, 1900 ] 38 0.001% 100.003% ( 1900, 2900 ] 44 0.002% 100.005% ( 2900, 4400 ] 73 0.003% 100.008% ( 4400, 6600 ] 14 0.001% 100.008% ( 6600, 9900 ] 18 0.001% 100.009% ( 9900, 14000 ] 4 0.000% 100.009% ( 14000, 22000 ] 1 0.000% 100.009% ** Level 1 read latency histogram (micros): Count: 1183658 Average: 7.7516 StdDev: 148.74 Min: 0 Median: 1.9891 Max: 36820 Percentiles: P50: 1.99 P75: 3.16 P99: 10.76 P99.9: 20.47 P99.99: 187.50 ------------------------------------------------------ [ 0, 1 ] 31522 2.663% 2.663% # ( 1, 2 ] 566478 47.858% 50.521% ########## ( 2, 3 ] 269499 22.768% 73.290% ##### ( 3, 4 ] 128544 10.860% 84.150% ## ( 4, 6 ] 144784 12.232% 96.381% ## ( 6, 10 ] 29259 2.472% 98.853% ( 10, 15 ] 11366 0.960% 99.814% ( 15, 22 ] 1308 0.111% 99.924% ( 22, 34 ] 160 0.014% 99.938% ( 34, 51 ] 46 0.004% 99.942% ( 51, 76 ] 17 0.001% 99.943% ( 76, 110 ] 124 0.010% 99.953% ( 110, 170 ] 332 0.028% 99.981% ( 170, 250 ] 460 0.039% 100.020% ( 250, 380 ] 470 0.040% 100.060% ( 380, 580 ] 380 0.032% 100.092% ( 580, 870 ] 215 0.018% 100.110% ( 870, 1300 ] 161 0.014% 100.124% ( 1300, 1900 ] 188 0.016% 100.140% ( 1900, 2900 ] 318 0.027% 100.167% ( 2900, 4400 ] 430 0.036% 100.203% ( 4400, 6600 ] 175 0.015% 100.218% ( 6600, 9900 ] 120 0.010% 100.228% ( 9900, 14000 ] 10 0.001% 100.229% ( 14000, 22000 ] 6 0.001% 100.229% ( 22000, 33000 ] 4 0.000% 100.230% ( 33000, 50000 ] 1 0.000% 100.230% ** Level 2 read latency histogram (micros): Count: 77150 Average: 8.4748 StdDev: 155.64 Min: 1 Median: 1.6628 Max: 11030 Percentiles: P50: 1.66 P75: 2.37 P99: 10.87 P99.9: 2654.76 P99.99: 7542.56 ------------------------------------------------------ [ 0, 1 ] 8465 10.972% 10.972% ## ( 1, 2 ] 45430 58.885% 69.857% ############ ( 2, 3 ] 10812 14.014% 83.872% ### ( 3, 4 ] 5491 7.117% 90.989% # ( 4, 6 ] 4942 6.406% 97.395% # ( 6, 10 ] 1150 1.491% 98.885% ( 10, 15 ] 506 0.656% 99.541% ( 15, 22 ] 47 0.061% 99.602% ( 22, 34 ] 3 0.004% 99.606% ( 34, 51 ] 1 0.001% 99.607% ( 51, 76 ] 4 0.005% 99.612% ( 76, 110 ] 5 0.006% 99.619% ( 110, 170 ] 54 0.070% 99.689% ( 170, 250 ] 45 0.058% 99.747% ( 250, 380 ] 35 0.045% 99.793% ( 380, 580 ] 27 0.035% 99.828% ( 580, 870 ] 20 0.026% 99.854% ( 870, 1300 ] 11 0.014% 99.868% ( 1300, 1900 ] 9 0.012% 99.879% ( 1900, 2900 ] 21 0.027% 99.907% ( 2900, 4400 ] 48 0.062% 99.969% ( 4400, 6600 ] 14 0.018% 99.987% ( 6600, 9900 ] 8 0.010% 99.997% ( 9900, 14000 ] 2 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 602215 Average: 10.9579 StdDev: 166.22 Min: 0 Median: 1.9569 Max: 24768 Percentiles: P50: 1.96 P75: 3.09 P99: 13.83 P99.9: 839.19 P99.99: 2243.64 ------------------------------------------------------ [ 0, 1 ] 18647 3.096% 3.096% # ( 1, 2 ] 295196 49.018% 52.115% ########## ( 2, 3 ] 131698 21.869% 73.984% #### ( 3, 4 ] 65670 10.905% 84.888% ## ( 4, 6 ] 67575 11.221% 96.110% ## ( 6, 10 ] 13559 2.252% 98.361% ( 10, 15 ] 5018 0.833% 99.194% ( 15, 22 ] 592 0.098% 99.293% ( 22, 34 ] 111 0.018% 99.311% ( 34, 51 ] 20 0.003% 99.314% ( 51, 76 ] 9 0.001% 99.316% ( 76, 110 ] 68 0.011% 99.327% ( 110, 170 ] 696 0.116% 99.443% ( 170, 250 ] 830 0.138% 99.581% ( 250, 380 ] 825 0.137% 99.718% ( 380, 580 ] 710 0.118% 99.835% ( 580, 870 ] 435 0.072% 99.908% ( 870, 1300 ] 250 0.042% 99.949% ( 1300, 1900 ] 142 0.024% 99.973% ( 1900, 2900 ] 302 0.050% 100.023% ( 2900, 4400 ] 395 0.066% 100.089% ( 4400, 6600 ] 73 0.012% 100.101% ( 6600, 9900 ] 52 0.009% 100.109% ( 9900, 14000 ] 4 0.001% 100.110% ( 14000, 22000 ] 8 0.001% 100.111% ( 22000, 33000 ] 2 0.000% 100.112% ** Level 4 read latency histogram (micros): Count: 106807 Average: 10.1170 StdDev: 137.35 Min: 1 Median: 1.9642 Max: 8353 Percentiles: P50: 1.96 P75: 3.05 P99: 14.08 P99.9: 1530.16 P99.99: 3713.12 ------------------------------------------------------ [ 0, 1 ] 2527 2.366% 2.366% ( 1, 2 ] 52764 49.401% 51.767% ########## ( 2, 3 ] 24303 22.754% 74.521% ##### ( 3, 4 ] 11147 10.437% 84.958% ## ( 4, 6 ] 11972 11.209% 96.167% ## ( 6, 10 ] 2259 2.115% 98.282% ( 10, 15 ] 941 0.881% 99.163% ( 15, 22 ] 95 0.089% 99.252% ( 22, 34 ] 12 0.011% 99.263% ( 34, 51 ] 4 0.004% 99.267% ( 51, 76 ] 4 0.004% 99.271% ( 76, 110 ] 6 0.006% 99.276% ( 110, 170 ] 91 0.085% 99.361% ( 170, 250 ] 151 0.141% 99.503% ( 250, 380 ] 163 0.153% 99.655% ( 380, 580 ] 144 0.135% 99.790% ( 580, 870 ] 67 0.063% 99.853% ( 870, 1300 ] 36 0.034% 99.887% ( 1300, 1900 ] 37 0.035% 99.921% ( 1900, 2900 ] 37 0.035% 99.956% ( 2900, 4400 ] 67 0.063% 100.019% ( 4400, 6600 ] 17 0.016% 100.035% ( 6600, 9900 ] 5 0.005% 100.039% ** Level 5 read latency histogram (micros): Count: 260 Average: 672.8154 StdDev: 883.94 Min: 103 Median: 369.4595 Max: 7757 Percentiles: P50: 369.46 P75: 795.43 P99: 4840.00 P99.9: 7757.00 P99.99: 7757.00 ------------------------------------------------------ ( 76, 110 ] 3 1.154% 1.154% ( 110, 170 ] 40 15.385% 16.538% ### ( 170, 250 ] 53 20.385% 36.923% #### ( 250, 380 ] 37 14.231% 51.154% ### ( 380, 580 ] 36 13.846% 65.000% ### ( 580, 870 ] 35 13.462% 78.462% ### ( 870, 1300 ] 30 11.538% 90.000% ## ( 1300, 1900 ] 9 3.462% 93.462% # ( 1900, 2900 ] 4 1.538% 95.000% ( 2900, 4400 ] 10 3.846% 98.846% # ( 4400, 6600 ] 2 0.769% 99.615% ( 6600, 9900 ] 1 0.385% 100.000% ** DB Stats ** Uptime(secs): 42.4 total, 3.6 interval Cumulative writes: 0 writes, 7000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 6.73 GB, 162.65 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:21.014 H:M:S, 49.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 272.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:0.621 H:M:S, 17.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/12/08-18:48:10 ... thread 0: (1000000,8000000) ops and (335552.3,177087.1) ops/second in (2.980161,45.175522) 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 16/11 2.15 GB 75.5 5.8 0.0 5.8 13.3 7.6 0.0 1.8 124.1 286.3 47.73 42.48 135 0.354 6012K 6078 0.0 0.0 L1 11/11 795.08 MB 0.0 5.4 5.2 0.2 5.3 5.1 0.2 1.0 207.5 204.3 26.76 23.80 4 6.689 5603K 82K 0.0 0.0 L2 1/0 18.22 KB 0.0 0.2 0.1 0.1 0.2 0.1 4.4 1.5 244.2 244.1 0.79 0.76 2 0.394 195K 85 0.0 0.0 L3 16/0 880.93 MB 0.9 4.2 2.3 1.9 4.2 2.3 2.4 1.8 147.0 146.5 29.20 21.13 17 1.718 3429K 6974 0.0 0.0 L4 146/0 9.68 GB 1.0 3.2 2.5 0.7 3.2 2.5 2.0 1.3 121.3 120.9 27.00 16.30 24 1.125 3297K 8915 0.0 0.0 L5 1120/0 90.12 GB 0.9 0.0 0.0 0.0 0.0 0.0 4.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1310/22 103.59 GB 0.0 18.8 10.1 8.7 26.2 17.6 13.3 3.5 146.3 204.3 131.48 104.47 182 0.722 18M 104K 0.0 0.0 Int 0/0 0.00 KB 0.0 18.8 10.1 8.7 26.2 17.6 13.2 3.5 146.3 204.3 131.48 104.47 182 0.722 18M 104K 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) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 18.8 10.1 8.7 18.7 10.0 0.0 0.0 179.8 178.7 106.96 84.29 69 1.550 18M 104K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 7.6 7.6 0.0 0.0 0.0 316.1 24.52 20.18 113 0.217 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 45.3 total, 45.2 interval Flush(GB): cumulative 7.567, interval 7.567 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 26.24 GB write, 592.62 MB/s write, 18.78 GB read, 424.20 MB/s read, 131.5 seconds Interval compaction: 26.24 GB write, 594.70 MB/s write, 18.78 GB read, 425.69 MB/s read, 131.5 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 13, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 13, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 50, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 13, total-stops: 50, interval: 63 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3087118 Average: 2.7583 StdDev: 35.43 Min: 0 Median: 1.3847 Max: 17654 Percentiles: P50: 1.38 P75: 1.80 P99: 7.82 P99.9: 153.99 P99.99: 325.33 ------------------------------------------------------ [ 0, 1 ] 834900 27.045% 27.045% ##### ( 1, 2 ] 1842180 59.673% 86.718% ############ ( 2, 3 ] 202578 6.562% 93.280% # ( 3, 4 ] 96730 3.133% 96.413% # ( 4, 6 ] 68249 2.211% 98.624% ( 6, 10 ] 25569 0.828% 99.452% ( 10, 15 ] 5295 0.172% 99.624% ( 15, 22 ] 1134 0.037% 99.660% ( 22, 34 ] 105 0.003% 99.664% ( 34, 51 ] 20 0.001% 99.664% ( 51, 76 ] 16 0.001% 99.665% ( 76, 110 ] 2510 0.081% 99.746% ( 110, 170 ] 6476 0.210% 99.956% ( 170, 250 ] 720 0.023% 99.979% ( 250, 380 ] 570 0.018% 99.998% ( 380, 580 ] 109 0.004% 100.001% ( 580, 870 ] 64 0.002% 100.003% ( 870, 1300 ] 39 0.001% 100.005% ( 1300, 1900 ] 39 0.001% 100.006% ( 1900, 2900 ] 44 0.001% 100.007% ( 2900, 4400 ] 73 0.002% 100.010% ( 4400, 6600 ] 14 0.000% 100.010% ( 6600, 9900 ] 18 0.001% 100.011% ( 9900, 14000 ] 4 0.000% 100.011% ( 14000, 22000 ] 1 0.000% 100.011% ** Level 1 read latency histogram (micros): Count: 1241157 Average: 7.5107 StdDev: 145.26 Min: 0 Median: 1.9593 Max: 36820 Percentiles: P50: 1.96 P75: 3.08 P99: 10.65 P99.9: 20.88 P99.99: 189.64 ------------------------------------------------------ [ 0, 1 ] 40631 3.274% 3.274% # ( 1, 2 ] 604527 48.707% 51.980% ########## ( 2, 3 ] 275278 22.179% 74.160% #### ( 3, 4 ] 130569 10.520% 84.679% ## ( 4, 6 ] 145917 11.757% 96.436% ## ( 6, 10 ] 30309 2.442% 98.878% ( 10, 15 ] 11564 0.932% 99.810% ( 15, 22 ] 1334 0.107% 99.917% ( 22, 34 ] 161 0.013% 99.930% ( 34, 51 ] 47 0.004% 99.934% ( 51, 76 ] 17 0.001% 99.935% ( 76, 110 ] 134 0.011% 99.946% ( 110, 170 ] 429 0.035% 99.981% ( 170, 250 ] 472 0.038% 100.019% ( 250, 380 ] 478 0.039% 100.057% ( 380, 580 ] 381 0.031% 100.088% ( 580, 870 ] 215 0.017% 100.105% ( 870, 1300 ] 161 0.013% 100.118% ( 1300, 1900 ] 188 0.015% 100.133% ( 1900, 2900 ] 318 0.026% 100.159% ( 2900, 4400 ] 430 0.035% 100.194% ( 4400, 6600 ] 175 0.014% 100.208% ( 6600, 9900 ] 120 0.010% 100.217% ( 9900, 14000 ] 10 0.001% 100.218% ( 14000, 22000 ] 6 0.000% 100.219% ( 22000, 33000 ] 4 0.000% 100.219% ( 33000, 50000 ] 1 0.000% 100.219% ** Level 2 read latency histogram (micros): Count: 77150 Average: 8.4748 StdDev: 155.64 Min: 1 Median: 1.6628 Max: 11030 Percentiles: P50: 1.66 P75: 2.37 P99: 10.87 P99.9: 2654.76 P99.99: 7542.56 ------------------------------------------------------ [ 0, 1 ] 8465 10.972% 10.972% ## ( 1, 2 ] 45430 58.885% 69.857% ############ ( 2, 3 ] 10812 14.014% 83.872% ### ( 3, 4 ] 5491 7.117% 90.989% # ( 4, 6 ] 4942 6.406% 97.395% # ( 6, 10 ] 1150 1.491% 98.885% ( 10, 15 ] 506 0.656% 99.541% ( 15, 22 ] 47 0.061% 99.602% ( 22, 34 ] 3 0.004% 99.606% ( 34, 51 ] 1 0.001% 99.607% ( 51, 76 ] 4 0.005% 99.612% ( 76, 110 ] 5 0.006% 99.619% ( 110, 170 ] 54 0.070% 99.689% ( 170, 250 ] 45 0.058% 99.747% ( 250, 380 ] 35 0.045% 99.793% ( 380, 580 ] 27 0.035% 99.828% ( 580, 870 ] 20 0.026% 99.854% ( 870, 1300 ] 11 0.014% 99.868% ( 1300, 1900 ] 9 0.012% 99.879% ( 1900, 2900 ] 21 0.027% 99.907% ( 2900, 4400 ] 48 0.062% 99.969% ( 4400, 6600 ] 14 0.018% 99.987% ( 6600, 9900 ] 8 0.010% 99.997% ( 9900, 14000 ] 2 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 602215 Average: 10.9579 StdDev: 166.22 Min: 0 Median: 1.9569 Max: 24768 Percentiles: P50: 1.96 P75: 3.09 P99: 13.83 P99.9: 839.19 P99.99: 2243.64 ------------------------------------------------------ [ 0, 1 ] 18647 3.096% 3.096% # ( 1, 2 ] 295196 49.018% 52.115% ########## ( 2, 3 ] 131698 21.869% 73.984% #### ( 3, 4 ] 65670 10.905% 84.888% ## ( 4, 6 ] 67575 11.221% 96.110% ## ( 6, 10 ] 13559 2.252% 98.361% ( 10, 15 ] 5018 0.833% 99.194% ( 15, 22 ] 592 0.098% 99.293% ( 22, 34 ] 111 0.018% 99.311% ( 34, 51 ] 20 0.003% 99.314% ( 51, 76 ] 9 0.001% 99.316% ( 76, 110 ] 68 0.011% 99.327% ( 110, 170 ] 696 0.116% 99.443% ( 170, 250 ] 830 0.138% 99.581% ( 250, 380 ] 825 0.137% 99.718% ( 380, 580 ] 710 0.118% 99.835% ( 580, 870 ] 435 0.072% 99.908% ( 870, 1300 ] 250 0.042% 99.949% ( 1300, 1900 ] 142 0.024% 99.973% ( 1900, 2900 ] 302 0.050% 100.023% ( 2900, 4400 ] 395 0.066% 100.089% ( 4400, 6600 ] 73 0.012% 100.101% ( 6600, 9900 ] 52 0.009% 100.109% ( 9900, 14000 ] 4 0.001% 100.110% ( 14000, 22000 ] 8 0.001% 100.111% ( 22000, 33000 ] 2 0.000% 100.112% ** Level 4 read latency histogram (micros): Count: 106807 Average: 10.1170 StdDev: 137.35 Min: 1 Median: 1.9642 Max: 8353 Percentiles: P50: 1.96 P75: 3.05 P99: 14.08 P99.9: 1530.16 P99.99: 3713.12 ------------------------------------------------------ [ 0, 1 ] 2527 2.366% 2.366% ( 1, 2 ] 52764 49.401% 51.767% ########## ( 2, 3 ] 24303 22.754% 74.521% ##### ( 3, 4 ] 11147 10.437% 84.958% ## ( 4, 6 ] 11972 11.209% 96.167% ## ( 6, 10 ] 2259 2.115% 98.282% ( 10, 15 ] 941 0.881% 99.163% ( 15, 22 ] 95 0.089% 99.252% ( 22, 34 ] 12 0.011% 99.263% ( 34, 51 ] 4 0.004% 99.267% ( 51, 76 ] 4 0.004% 99.271% ( 76, 110 ] 6 0.006% 99.276% ( 110, 170 ] 91 0.085% 99.361% ( 170, 250 ] 151 0.141% 99.503% ( 250, 380 ] 163 0.153% 99.655% ( 380, 580 ] 144 0.135% 99.790% ( 580, 870 ] 67 0.063% 99.853% ( 870, 1300 ] 36 0.034% 99.887% ( 1300, 1900 ] 37 0.035% 99.921% ( 1900, 2900 ] 37 0.035% 99.956% ( 2900, 4400 ] 67 0.063% 100.019% ( 4400, 6600 ] 17 0.016% 100.035% ( 6600, 9900 ] 5 0.005% 100.039% ** Level 5 read latency histogram (micros): Count: 260 Average: 672.8154 StdDev: 883.94 Min: 103 Median: 369.4595 Max: 7757 Percentiles: P50: 369.46 P75: 795.43 P99: 4840.00 P99.9: 7757.00 P99.99: 7757.00 ------------------------------------------------------ ( 76, 110 ] 3 1.154% 1.154% ( 110, 170 ] 40 15.385% 16.538% ### ( 170, 250 ] 53 20.385% 36.923% #### ( 250, 380 ] 37 14.231% 51.154% ### ( 380, 580 ] 36 13.846% 65.000% ### ( 580, 870 ] 35 13.462% 78.462% ### ( 870, 1300 ] 30 11.538% 90.000% ## ( 1300, 1900 ] 9 3.462% 93.462% # ( 1900, 2900 ] 4 1.538% 95.000% ( 2900, 4400 ] 10 3.846% 98.846% # ( 4400, 6600 ] 2 0.769% 99.615% ( 6600, 9900 ] 1 0.385% 100.000% ** DB Stats ** Uptime(secs): 45.3 total, 3.0 interval Cumulative writes: 0 writes, 8000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 7.69 GB, 173.67 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:21.192 H:M:S, 46.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 330.25 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.178 H:M:S, 6.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/08-18:48:14 ... thread 0: (1000000,9000000) ops and (294888.0,185312.4) ops/second in (3.391118,48.566640) 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 18/11 3.20 GB 182.5 7.1 0.0 7.1 15.7 8.6 0.0 1.8 129.7 287.5 55.86 50.28 157 0.356 7356K 7465 0.0 0.0 L1 11/11 795.08 MB 0.0 5.4 5.2 0.2 5.3 5.1 0.2 1.0 207.5 204.3 26.76 23.80 4 6.689 5603K 82K 0.0 0.0 L2 1/0 18.22 KB 0.0 0.2 0.1 0.1 0.2 0.1 4.4 1.5 244.2 244.1 0.79 0.76 2 0.394 195K 85 0.0 0.0 L3 16/0 880.93 MB 0.9 4.2 2.3 1.9 4.2 2.3 2.4 1.8 147.0 146.5 29.20 21.13 17 1.718 3429K 6974 0.0 0.0 L4 146/0 9.68 GB 1.0 3.2 2.5 0.7 3.2 2.5 2.0 1.3 121.3 120.9 27.00 16.30 24 1.125 3297K 8915 0.0 0.0 L5 1120/0 90.12 GB 0.9 0.0 0.0 0.0 0.0 0.0 4.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1312/22 104.64 GB 0.0 20.1 10.1 10.0 28.6 18.6 13.3 3.3 147.2 209.6 139.60 112.26 204 0.684 19M 106K 0.0 0.0 Int 0/0 0.00 KB 0.0 20.1 10.1 10.0 28.6 18.6 13.2 3.3 147.2 209.6 139.60 112.26 204 0.684 19M 106K 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) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 20.1 10.1 10.0 20.0 10.0 0.0 0.0 183.4 182.3 112.10 89.30 74 1.515 19M 106K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 8.6 8.6 0.0 0.0 0.0 320.7 27.51 22.96 130 0.212 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 48.7 total, 48.6 interval Flush(GB): cumulative 8.613, interval 8.613 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: 28.57 GB write, 600.48 MB/s write, 20.07 GB read, 421.83 MB/s read, 139.6 seconds Interval compaction: 28.57 GB write, 602.44 MB/s write, 20.07 GB read, 423.21 MB/s read, 139.6 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 18, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 18, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 50, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 18, total-stops: 50, interval: 68 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3477372 Average: 2.7077 StdDev: 33.45 Min: 0 Median: 1.4014 Max: 17654 Percentiles: P50: 1.40 P75: 1.81 P99: 7.64 P99.9: 150.25 P99.99: 290.97 ------------------------------------------------------ [ 0, 1 ] 894679 25.729% 25.729% ##### ( 1, 2 ] 2102408 60.460% 86.188% ############ ( 2, 3 ] 242913 6.986% 93.174% # ( 3, 4 ] 113485 3.264% 96.437% # ( 4, 6 ] 77488 2.228% 98.666% ( 6, 10 ] 28440 0.818% 99.484% ( 10, 15 ] 6120 0.176% 99.660% ( 15, 22 ] 1198 0.034% 99.694% ( 22, 34 ] 117 0.003% 99.697% ( 34, 51 ] 21 0.001% 99.698% ( 51, 76 ] 19 0.001% 99.699% ( 76, 110 ] 2576 0.074% 99.773% ( 110, 170 ] 6608 0.190% 99.963% ( 170, 250 ] 768 0.022% 99.985% ( 250, 380 ] 591 0.017% 100.002% ( 380, 580 ] 118 0.003% 100.005% ( 580, 870 ] 67 0.002% 100.007% ( 870, 1300 ] 42 0.001% 100.008% ( 1300, 1900 ] 39 0.001% 100.009% ( 1900, 2900 ] 44 0.001% 100.011% ( 2900, 4400 ] 73 0.002% 100.013% ( 4400, 6600 ] 14 0.000% 100.013% ( 6600, 9900 ] 18 0.001% 100.014% ( 9900, 14000 ] 4 0.000% 100.014% ( 14000, 22000 ] 1 0.000% 100.014% ** Level 1 read latency histogram (micros): Count: 1311042 Average: 7.2562 StdDev: 141.36 Min: 0 Median: 1.9319 Max: 36820 Percentiles: P50: 1.93 P75: 3.00 P99: 10.52 P99.9: 21.54 P99.99: 193.84 ------------------------------------------------------ [ 0, 1 ] 48268 3.682% 3.682% # ( 1, 2 ] 651628 49.703% 53.385% ########## ( 2, 3 ] 283882 21.653% 75.038% #### ( 3, 4 ] 133511 10.184% 85.221% ## ( 4, 6 ] 147833 11.276% 96.497% ## ( 6, 10 ] 31581 2.409% 98.906% ( 10, 15 ] 11771 0.898% 99.804% ( 15, 22 ] 1346 0.103% 99.907% ( 22, 34 ] 162 0.012% 99.919% ( 34, 51 ] 48 0.004% 99.923% ( 51, 76 ] 17 0.001% 99.924% ( 76, 110 ] 195 0.015% 99.939% ( 110, 170 ] 519 0.040% 99.979% ( 170, 250 ] 503 0.038% 100.017% ( 250, 380 ] 484 0.037% 100.054% ( 380, 580 ] 385 0.029% 100.083% ( 580, 870 ] 215 0.016% 100.100% ( 870, 1300 ] 161 0.012% 100.112% ( 1300, 1900 ] 188 0.014% 100.126% ( 1900, 2900 ] 318 0.024% 100.150% ( 2900, 4400 ] 430 0.033% 100.183% ( 4400, 6600 ] 175 0.013% 100.197% ( 6600, 9900 ] 120 0.009% 100.206% ( 9900, 14000 ] 10 0.001% 100.207% ( 14000, 22000 ] 6 0.000% 100.207% ( 22000, 33000 ] 4 0.000% 100.207% ( 33000, 50000 ] 1 0.000% 100.207% ** Level 2 read latency histogram (micros): Count: 77150 Average: 8.4748 StdDev: 155.64 Min: 1 Median: 1.6628 Max: 11030 Percentiles: P50: 1.66 P75: 2.37 P99: 10.87 P99.9: 2654.76 P99.99: 7542.56 ------------------------------------------------------ [ 0, 1 ] 8465 10.972% 10.972% ## ( 1, 2 ] 45430 58.885% 69.857% ############ ( 2, 3 ] 10812 14.014% 83.872% ### ( 3, 4 ] 5491 7.117% 90.989% # ( 4, 6 ] 4942 6.406% 97.395% # ( 6, 10 ] 1150 1.491% 98.885% ( 10, 15 ] 506 0.656% 99.541% ( 15, 22 ] 47 0.061% 99.602% ( 22, 34 ] 3 0.004% 99.606% ( 34, 51 ] 1 0.001% 99.607% ( 51, 76 ] 4 0.005% 99.612% ( 76, 110 ] 5 0.006% 99.619% ( 110, 170 ] 54 0.070% 99.689% ( 170, 250 ] 45 0.058% 99.747% ( 250, 380 ] 35 0.045% 99.793% ( 380, 580 ] 27 0.035% 99.828% ( 580, 870 ] 20 0.026% 99.854% ( 870, 1300 ] 11 0.014% 99.868% ( 1300, 1900 ] 9 0.012% 99.879% ( 1900, 2900 ] 21 0.027% 99.907% ( 2900, 4400 ] 48 0.062% 99.969% ( 4400, 6600 ] 14 0.018% 99.987% ( 6600, 9900 ] 8 0.010% 99.997% ( 9900, 14000 ] 2 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 602215 Average: 10.9579 StdDev: 166.22 Min: 0 Median: 1.9569 Max: 24768 Percentiles: P50: 1.96 P75: 3.09 P99: 13.83 P99.9: 839.19 P99.99: 2243.64 ------------------------------------------------------ [ 0, 1 ] 18647 3.096% 3.096% # ( 1, 2 ] 295196 49.018% 52.115% ########## ( 2, 3 ] 131698 21.869% 73.984% #### ( 3, 4 ] 65670 10.905% 84.888% ## ( 4, 6 ] 67575 11.221% 96.110% ## ( 6, 10 ] 13559 2.252% 98.361% ( 10, 15 ] 5018 0.833% 99.194% ( 15, 22 ] 592 0.098% 99.293% ( 22, 34 ] 111 0.018% 99.311% ( 34, 51 ] 20 0.003% 99.314% ( 51, 76 ] 9 0.001% 99.316% ( 76, 110 ] 68 0.011% 99.327% ( 110, 170 ] 696 0.116% 99.443% ( 170, 250 ] 830 0.138% 99.581% ( 250, 380 ] 825 0.137% 99.718% ( 380, 580 ] 710 0.118% 99.835% ( 580, 870 ] 435 0.072% 99.908% ( 870, 1300 ] 250 0.042% 99.949% ( 1300, 1900 ] 142 0.024% 99.973% ( 1900, 2900 ] 302 0.050% 100.023% ( 2900, 4400 ] 395 0.066% 100.089% ( 4400, 6600 ] 73 0.012% 100.101% ( 6600, 9900 ] 52 0.009% 100.109% ( 9900, 14000 ] 4 0.001% 100.110% ( 14000, 22000 ] 8 0.001% 100.111% ( 22000, 33000 ] 2 0.000% 100.112% ** Level 4 read latency histogram (micros): Count: 106807 Average: 10.1170 StdDev: 137.35 Min: 1 Median: 1.9642 Max: 8353 Percentiles: P50: 1.96 P75: 3.05 P99: 14.08 P99.9: 1530.16 P99.99: 3713.12 ------------------------------------------------------ [ 0, 1 ] 2527 2.366% 2.366% ( 1, 2 ] 52764 49.401% 51.767% ########## ( 2, 3 ] 24303 22.754% 74.521% ##### ( 3, 4 ] 11147 10.437% 84.958% ## ( 4, 6 ] 11972 11.209% 96.167% ## ( 6, 10 ] 2259 2.115% 98.282% ( 10, 15 ] 941 0.881% 99.163% ( 15, 22 ] 95 0.089% 99.252% ( 22, 34 ] 12 0.011% 99.263% ( 34, 51 ] 4 0.004% 99.267% ( 51, 76 ] 4 0.004% 99.271% ( 76, 110 ] 6 0.006% 99.276% ( 110, 170 ] 91 0.085% 99.361% ( 170, 250 ] 151 0.141% 99.503% ( 250, 380 ] 163 0.153% 99.655% ( 380, 580 ] 144 0.135% 99.790% ( 580, 870 ] 67 0.063% 99.853% ( 870, 1300 ] 36 0.034% 99.887% ( 1300, 1900 ] 37 0.035% 99.921% ( 1900, 2900 ] 37 0.035% 99.956% ( 2900, 4400 ] 67 0.063% 100.019% ( 4400, 6600 ] 17 0.016% 100.035% ( 6600, 9900 ] 5 0.005% 100.039% ** Level 5 read latency histogram (micros): Count: 260 Average: 672.8154 StdDev: 883.94 Min: 103 Median: 369.4595 Max: 7757 Percentiles: P50: 369.46 P75: 795.43 P99: 4840.00 P99.9: 7757.00 P99.99: 7757.00 ------------------------------------------------------ ( 76, 110 ] 3 1.154% 1.154% ( 110, 170 ] 40 15.385% 16.538% ### ( 170, 250 ] 53 20.385% 36.923% #### ( 250, 380 ] 37 14.231% 51.154% ### ( 380, 580 ] 36 13.846% 65.000% ### ( 580, 870 ] 35 13.462% 78.462% ### ( 870, 1300 ] 30 11.538% 90.000% ## ( 1300, 1900 ] 9 3.462% 93.462% # ( 1900, 2900 ] 4 1.538% 95.000% ( 2900, 4400 ] 10 3.846% 98.846% # ( 4400, 6600 ] 2 0.769% 99.615% ( 6600, 9900 ] 1 0.385% 100.000% ** DB Stats ** Uptime(secs): 48.7 total, 3.4 interval Cumulative writes: 0 writes, 9000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 8.65 GB, 181.78 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:21.769 H:M:S, 44.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 290.23 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.576 H:M:S, 17.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 0 2024/12/08-18:48:18 ... thread 0: (1000000,10000000) ops and (242548.3,189791.0) ops/second in (4.122891,52.689531) 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 19/16 2.95 GB 25.2 7.6 0.0 7.6 17.1 9.5 0.0 1.8 128.3 289.9 60.39 54.61 173 0.349 7867K 7976 0.0 0.0 L1 17/17 1.93 GB 0.0 7.4 6.4 1.0 7.3 6.3 0.2 1.1 210.4 207.6 35.85 32.59 5 7.170 7625K 98K 0.0 0.0 L2 1/0 18.22 KB 0.0 0.2 0.1 0.1 0.2 0.1 4.4 1.5 244.2 244.1 0.79 0.76 2 0.394 195K 85 0.0 0.0 L3 16/0 880.93 MB 0.9 4.2 2.3 1.9 4.2 2.3 2.4 1.8 147.0 146.5 29.20 21.13 17 1.718 3429K 6974 0.0 0.0 L4 146/0 9.68 GB 1.0 3.2 2.5 0.7 3.2 2.5 2.0 1.3 121.3 120.9 27.00 16.30 24 1.125 3297K 8915 0.0 0.0 L5 1120/0 90.12 GB 0.9 0.0 0.0 0.0 0.0 0.0 4.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1319/33 105.54 GB 0.0 22.5 11.3 11.2 31.9 20.7 13.3 3.3 150.4 213.3 153.23 125.39 221 0.693 22M 122K 0.0 0.0 Int 0/0 0.00 KB 0.0 22.5 11.3 11.2 31.9 20.7 13.2 3.3 150.4 213.3 153.23 125.39 221 0.693 22M 122K 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) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 22.5 11.3 11.2 22.4 11.2 0.0 0.0 187.2 186.2 123.11 99.98 77 1.599 22M 122K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 9.5 9.5 0.0 0.0 0.0 324.2 30.12 25.40 144 0.209 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 52.9 total, 52.7 interval Flush(GB): cumulative 9.536, interval 9.536 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: 31.92 GB write, 618.41 MB/s write, 22.51 GB read, 436.13 MB/s read, 153.2 seconds Interval compaction: 31.92 GB write, 620.27 MB/s write, 22.51 GB read, 437.45 MB/s read, 153.2 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 22, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 22, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 51, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 22, total-stops: 51, interval: 73 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3781855 Average: 2.6672 StdDev: 32.13 Min: 0 Median: 1.4057 Max: 17654 Percentiles: P50: 1.41 P75: 1.82 P99: 7.54 P99.9: 148.27 P99.99: 281.33 ------------------------------------------------------ [ 0, 1 ] 955101 25.255% 25.255% ##### ( 1, 2 ] 2306868 60.998% 86.253% ############ ( 2, 3 ] 266254 7.040% 93.293% # ( 3, 4 ] 122564 3.241% 96.534% # ( 4, 6 ] 81355 2.151% 98.685% ( 6, 10 ] 30910 0.817% 99.503% ( 10, 15 ] 6649 0.176% 99.679% ( 15, 22 ] 1250 0.033% 99.712% ( 22, 34 ] 122 0.003% 99.715% ( 34, 51 ] 23 0.001% 99.716% ( 51, 76 ] 20 0.001% 99.716% ( 76, 110 ] 2653 0.070% 99.786% ( 110, 170 ] 6750 0.178% 99.965% ( 170, 250 ] 813 0.021% 99.986% ( 250, 380 ] 605 0.016% 100.002% ( 380, 580 ] 121 0.003% 100.005% ( 580, 870 ] 71 0.002% 100.007% ( 870, 1300 ] 44 0.001% 100.008% ( 1300, 1900 ] 40 0.001% 100.009% ( 1900, 2900 ] 44 0.001% 100.011% ( 2900, 4400 ] 73 0.002% 100.013% ( 4400, 6600 ] 14 0.000% 100.013% ( 6600, 9900 ] 18 0.000% 100.013% ( 9900, 14000 ] 4 0.000% 100.014% ( 14000, 22000 ] 1 0.000% 100.014% ** Level 1 read latency histogram (micros): Count: 1419308 Average: 6.9082 StdDev: 135.91 Min: 0 Median: 1.8840 Max: 36820 Percentiles: P50: 1.88 P75: 2.93 P99: 10.32 P99.9: 72.79 P99.99: 203.14 ------------------------------------------------------ [ 0, 1 ] 70876 4.994% 4.994% # ( 1, 2 ] 722635 50.915% 55.908% ########## ( 2, 3 ] 291884 20.565% 76.474% #### ( 3, 4 ] 136228 9.598% 86.072% ## ( 4, 6 ] 149249 10.516% 96.587% ## ( 6, 10 ] 33470 2.358% 98.946% ( 10, 15 ] 11956 0.842% 99.788% ( 15, 22 ] 1363 0.096% 99.884% ( 22, 34 ] 163 0.011% 99.895% ( 34, 51 ] 49 0.003% 99.899% ( 51, 76 ] 18 0.001% 99.900% ( 76, 110 ] 403 0.028% 99.929% ( 110, 170 ] 643 0.045% 99.974% ( 170, 250 ] 553 0.039% 100.013% ( 250, 380 ] 491 0.035% 100.047% ( 380, 580 ] 411 0.029% 100.076% ( 580, 870 ] 220 0.016% 100.092% ( 870, 1300 ] 163 0.011% 100.103% ( 1300, 1900 ] 188 0.013% 100.117% ( 1900, 2900 ] 318 0.022% 100.139% ( 2900, 4400 ] 430 0.030% 100.169% ( 4400, 6600 ] 175 0.012% 100.182% ( 6600, 9900 ] 120 0.008% 100.190% ( 9900, 14000 ] 10 0.001% 100.191% ( 14000, 22000 ] 6 0.000% 100.191% ( 22000, 33000 ] 4 0.000% 100.192% ( 33000, 50000 ] 1 0.000% 100.192% ** Level 2 read latency histogram (micros): Count: 77150 Average: 8.4748 StdDev: 155.64 Min: 1 Median: 1.6628 Max: 11030 Percentiles: P50: 1.66 P75: 2.37 P99: 10.87 P99.9: 2654.76 P99.99: 7542.56 ------------------------------------------------------ [ 0, 1 ] 8465 10.972% 10.972% ## ( 1, 2 ] 45430 58.885% 69.857% ############ ( 2, 3 ] 10812 14.014% 83.872% ### ( 3, 4 ] 5491 7.117% 90.989% # ( 4, 6 ] 4942 6.406% 97.395% # ( 6, 10 ] 1150 1.491% 98.885% ( 10, 15 ] 506 0.656% 99.541% ( 15, 22 ] 47 0.061% 99.602% ( 22, 34 ] 3 0.004% 99.606% ( 34, 51 ] 1 0.001% 99.607% ( 51, 76 ] 4 0.005% 99.612% ( 76, 110 ] 5 0.006% 99.619% ( 110, 170 ] 54 0.070% 99.689% ( 170, 250 ] 45 0.058% 99.747% ( 250, 380 ] 35 0.045% 99.793% ( 380, 580 ] 27 0.035% 99.828% ( 580, 870 ] 20 0.026% 99.854% ( 870, 1300 ] 11 0.014% 99.868% ( 1300, 1900 ] 9 0.012% 99.879% ( 1900, 2900 ] 21 0.027% 99.907% ( 2900, 4400 ] 48 0.062% 99.969% ( 4400, 6600 ] 14 0.018% 99.987% ( 6600, 9900 ] 8 0.010% 99.997% ( 9900, 14000 ] 2 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 602215 Average: 10.9579 StdDev: 166.22 Min: 0 Median: 1.9569 Max: 24768 Percentiles: P50: 1.96 P75: 3.09 P99: 13.83 P99.9: 839.19 P99.99: 2243.64 ------------------------------------------------------ [ 0, 1 ] 18647 3.096% 3.096% # ( 1, 2 ] 295196 49.018% 52.115% ########## ( 2, 3 ] 131698 21.869% 73.984% #### ( 3, 4 ] 65670 10.905% 84.888% ## ( 4, 6 ] 67575 11.221% 96.110% ## ( 6, 10 ] 13559 2.252% 98.361% ( 10, 15 ] 5018 0.833% 99.194% ( 15, 22 ] 592 0.098% 99.293% ( 22, 34 ] 111 0.018% 99.311% ( 34, 51 ] 20 0.003% 99.314% ( 51, 76 ] 9 0.001% 99.316% ( 76, 110 ] 68 0.011% 99.327% ( 110, 170 ] 696 0.116% 99.443% ( 170, 250 ] 830 0.138% 99.581% ( 250, 380 ] 825 0.137% 99.718% ( 380, 580 ] 710 0.118% 99.835% ( 580, 870 ] 435 0.072% 99.908% ( 870, 1300 ] 250 0.042% 99.949% ( 1300, 1900 ] 142 0.024% 99.973% ( 1900, 2900 ] 302 0.050% 100.023% ( 2900, 4400 ] 395 0.066% 100.089% ( 4400, 6600 ] 73 0.012% 100.101% ( 6600, 9900 ] 52 0.009% 100.109% ( 9900, 14000 ] 4 0.001% 100.110% ( 14000, 22000 ] 8 0.001% 100.111% ( 22000, 33000 ] 2 0.000% 100.112% ** Level 4 read latency histogram (micros): Count: 106807 Average: 10.1170 StdDev: 137.35 Min: 1 Median: 1.9642 Max: 8353 Percentiles: P50: 1.96 P75: 3.05 P99: 14.08 P99.9: 1530.16 P99.99: 3713.12 ------------------------------------------------------ [ 0, 1 ] 2527 2.366% 2.366% ( 1, 2 ] 52764 49.401% 51.767% ########## ( 2, 3 ] 24303 22.754% 74.521% ##### ( 3, 4 ] 11147 10.437% 84.958% ## ( 4, 6 ] 11972 11.209% 96.167% ## ( 6, 10 ] 2259 2.115% 98.282% ( 10, 15 ] 941 0.881% 99.163% ( 15, 22 ] 95 0.089% 99.252% ( 22, 34 ] 12 0.011% 99.263% ( 34, 51 ] 4 0.004% 99.267% ( 51, 76 ] 4 0.004% 99.271% ( 76, 110 ] 6 0.006% 99.276% ( 110, 170 ] 91 0.085% 99.361% ( 170, 250 ] 151 0.141% 99.503% ( 250, 380 ] 163 0.153% 99.655% ( 380, 580 ] 144 0.135% 99.790% ( 580, 870 ] 67 0.063% 99.853% ( 870, 1300 ] 36 0.034% 99.887% ( 1300, 1900 ] 37 0.035% 99.921% ( 1900, 2900 ] 37 0.035% 99.956% ( 2900, 4400 ] 67 0.063% 100.019% ( 4400, 6600 ] 17 0.016% 100.035% ( 6600, 9900 ] 5 0.005% 100.039% ** Level 5 read latency histogram (micros): Count: 260 Average: 672.8154 StdDev: 883.94 Min: 103 Median: 369.4595 Max: 7757 Percentiles: P50: 369.46 P75: 795.43 P99: 4840.00 P99.9: 7757.00 P99.99: 7757.00 ------------------------------------------------------ ( 76, 110 ] 3 1.154% 1.154% ( 110, 170 ] 40 15.385% 16.538% ### ( 170, 250 ] 53 20.385% 36.923% #### ( 250, 380 ] 37 14.231% 51.154% ### ( 380, 580 ] 36 13.846% 65.000% ### ( 580, 870 ] 35 13.462% 78.462% ### ( 870, 1300 ] 30 11.538% 90.000% ## ( 1300, 1900 ] 9 3.462% 93.462% # ( 1900, 2900 ] 4 1.538% 95.000% ( 2900, 4400 ] 10 3.846% 98.846% # ( 4400, 6600 ] 2 0.769% 99.615% ( 6600, 9900 ] 1 0.385% 100.000% ** DB Stats ** Uptime(secs): 52.9 total, 4.1 interval Cumulative writes: 0 writes, 10M keys, 0 commit groups, 0.0 writes per commit group, ingest: 9.61 GB, 186.22 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.156 H:M:S, 43.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 238.71 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:1.387 H:M:S, 33.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 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: 100000000 Prefix: 0 bytes Keys per prefix: 0 RawSize: 96893.3 MB (estimated) FileSize: 96893.3 MB (estimated) Write rate: 0 bytes/second Read rate: 0 ops/second Compression: NoCompression Compression sampling rate: 0 Memtablerep: SkipListFactory Perf Level: 1 ------------------------------------------------ DB path: [/mnt/rocksdb] overwrite : 5.815 micros/op 171958 ops/sec 60.026 seconds 10321999 operations; 166.6 MB/s Microseconds per write: Count: 10321999 Average: 5.8154 StdDev: 357.25 Min: 0 Median: 1.7706 Max: 591651 Percentiles: P50: 1.77 P75: 3.04 P99: 8.76 P99.9: 1168.54 P99.99: 2775.58 ------------------------------------------------------ [ 0, 1 ] 1405827 13.620% 13.620% ### ( 1, 2 ] 4873130 47.211% 60.831% ######### ( 2, 3 ] 1399035 13.554% 74.385% ### ( 3, 4 ] 1440682 13.957% 88.342% ### ( 4, 6 ] 1013137 9.815% 98.157% ## ( 6, 10 ] 125856 1.219% 99.377% ( 10, 15 ] 24759 0.240% 99.617% ( 15, 22 ] 7894 0.076% 99.693% ( 22, 34 ] 2697 0.026% 99.719% ( 34, 51 ] 419 0.004% 99.723% ( 51, 76 ] 59 0.001% 99.724% ( 76, 110 ] 17 0.000% 99.724% ( 110, 170 ] 9541 0.092% 99.816% ( 170, 250 ] 766 0.007% 99.824% ( 250, 380 ] 198 0.002% 99.826% ( 380, 580 ] 41 0.000% 99.826% ( 580, 870 ] 27 0.000% 99.826% ( 870, 1300 ] 10935 0.106% 99.932% ( 1300, 1900 ] 20 0.000% 99.933% ( 1900, 2900 ] 6769 0.066% 99.998% ( 2900, 4400 ] 149 0.001% 100.000% ( 4400, 6600 ] 9 0.000% 100.000% ( 6600, 9900 ] 13 0.000% 100.000% ( 9900, 14000 ] 2 0.000% 100.000% ( 22000, 33000 ] 1 0.000% 100.000% ( 33000, 50000 ] 1 0.000% 100.000% ( 50000, 75000 ] 2 0.000% 100.000% ( 75000, 110000 ] 2 0.000% 100.000% ( 110000, 170000 ] 1 0.000% 100.000% ( 170000, 250000 ] 5 0.000% 100.000% ( 250000, 380000 ] 2 0.000% 100.000% ( 380000, 570000 ] 2 0.000% 100.000% ( 570000, 860000 ] 1 0.000% 100.000% STATISTICS: rocksdb.block.cache.miss COUNT : 0 rocksdb.block.cache.hit COUNT : 0 rocksdb.block.cache.add COUNT : 0 rocksdb.block.cache.add.failures COUNT : 0 rocksdb.block.cache.index.miss COUNT : 0 rocksdb.block.cache.index.hit COUNT : 0 rocksdb.block.cache.index.add COUNT : 0 rocksdb.block.cache.index.bytes.insert COUNT : 0 rocksdb.block.cache.filter.miss COUNT : 0 rocksdb.block.cache.filter.hit COUNT : 0 rocksdb.block.cache.filter.add COUNT : 0 rocksdb.block.cache.filter.bytes.insert COUNT : 0 rocksdb.block.cache.data.miss COUNT : 0 rocksdb.block.cache.data.hit COUNT : 0 rocksdb.block.cache.data.add COUNT : 0 rocksdb.block.cache.data.bytes.insert COUNT : 0 rocksdb.block.cache.bytes.read COUNT : 0 rocksdb.block.cache.bytes.write COUNT : 0 rocksdb.bloom.filter.useful COUNT : 0 rocksdb.bloom.filter.full.positive COUNT : 0 rocksdb.bloom.filter.full.true.positive COUNT : 0 rocksdb.persistent.cache.hit COUNT : 0 rocksdb.persistent.cache.miss COUNT : 0 rocksdb.sim.block.cache.hit COUNT : 0 rocksdb.sim.block.cache.miss COUNT : 0 rocksdb.memtable.hit COUNT : 0 rocksdb.memtable.miss COUNT : 0 rocksdb.l0.hit COUNT : 0 rocksdb.l1.hit COUNT : 0 rocksdb.l2andup.hit COUNT : 0 rocksdb.compaction.key.drop.new COUNT : 170140 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 : 10321999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 10652302968 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 : 526 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 29525743 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 : 28072356987 rocksdb.compact.write.bytes COUNT : 27903516356 rocksdb.flush.write.bytes COUNT : 10635587808 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 : 62 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 : 324 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 : 10549534720 rocksdb.memtable.garbage.bytes.at.flush COUNT : 3840000 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 : 28171665003 rocksdb.non.last.level.read.count COUNT : 6802530 rocksdb.block.checksum.compute.count COUNT : 6801540 rocksdb.multiget.coroutine.count COUNT : 0 rocksdb.blobdb.cache.miss COUNT : 0 rocksdb.blobdb.cache.hit COUNT : 0 rocksdb.blobdb.cache.add COUNT : 0 rocksdb.blobdb.cache.add.failures COUNT : 0 rocksdb.blobdb.cache.bytes.read COUNT : 0 rocksdb.blobdb.cache.bytes.write COUNT : 0 rocksdb.read.async.micros COUNT : 0 rocksdb.async.read.error.count COUNT : 0 rocksdb.secondary.cache.filter.hits COUNT : 0 rocksdb.secondary.cache.index.hits COUNT : 0 rocksdb.secondary.cache.data.hits COUNT : 0 rocksdb.table.open.prefetch.tail.miss COUNT : 0 rocksdb.table.open.prefetch.tail.hit COUNT : 0 rocksdb.db.get.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.db.write.micros P50 : 1.426582 P95 : 4.760883 P99 : 7.458434 P100 : 591650.000000 COUNT : 10321999 SUM : 55279410 rocksdb.compaction.times.micros P50 : 1091025.641026 P95 : 4276666.666667 P99 : 15520000.000000 P100 : 18376506.000000 COUNT : 81 SUM : 129470162 rocksdb.compaction.times.cpu_micros P50 : 961190.476190 P95 : 3582500.000000 P99 : 15520000.000000 P100 : 17040841.000000 COUNT : 81 SUM : 106252825 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 : 538.620690 P95 : 1273.125000 P99 : 5500.000000 P100 : 10457.000000 COUNT : 150 SUM : 111840 rocksdb.compaction.outfile.sync.micros P50 : 886.044776 P95 : 7676.428571 P99 : 9706.714286 P100 : 14116.000000 COUNT : 323 SUM : 630610 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 : 101.572650 P95 : 812.000000 P99 : 4113.333333 P100 : 19276.000000 COUNT : 272 SUM : 90419 rocksdb.table.open.io.micros P50 : 856.107784 P95 : 5624.666667 P99 : 8922.000000 P100 : 16166.000000 COUNT : 526 SUM : 845557 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 : 3.614465 P95 : 8.159965 P99 : 13.229711 P100 : 36825.000000 COUNT : 6799988 SUM : 45597937 rocksdb.read.block.get.micros P50 : 340.254777 P95 : 2026.315789 P99 : 4370.000000 P100 : 7904.000000 COUNT : 1052 SUM : 640953 rocksdb.write.raw.block.micros P50 : 0.518036 P95 : 0.984269 P99 : 3.265601 P100 : 30945.000000 COUNT : 9334035 SUM : 22230628 rocksdb.numfiles.in.singlecompaction P50 : 3.363636 P95 : 5.733333 P99 : 20.740000 P100 : 29.000000 COUNT : 136 SUM : 547 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 : 0.562096 P95 : 1249.467915 P99 : 2663.514116 P100 : 591446.000000 COUNT : 160855 SUM : 29536694 rocksdb.sst.read.micros P50 : 1.550619 P95 : 4.796067 P99 : 9.298261 P100 : 36820.000000 COUNT : 6802633 SUM : 30258835 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 : 10321999 SUM : 10652302968 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 : 183134.328358 P95 : 459166.666667 P99 : 751250.000000 P100 : 804129.000000 COUNT : 150 SUM : 31218618 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 : 345 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