[2024-12-09 11:46:51.878099] Starting SPDK v25.01-pre git sha1 90d04af13 / DPDK 24.03.0 initialization... [2024-12-09 11:46:51.878259] [ DPDK EAL parameters: rocksdb --no-shconf -c 0x1 --huge-unlink --no-telemetry --log-level=lib.eal:6 --log-level=lib.cryptodev:5 --log-level=lib.power:5 --log-level=user1:6 --base-virtaddr=0x200000000000 --match-allocations --file-prefix=spdk_pid4176076 ] Set seed to 1733741211874557 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-12-09 11:46:52.018244] app.c: 919:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-12-09 11:46:52.122316] app.c: 612:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-12-09 11:46:52.122366] app.c: 613:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 4176076' to capture a snapshot of events at runtime. [2024-12-09 11:46:52.122379] app.c: 618:app_setup_trace: *NOTICE*: 'spdk_trace' without parameters will also work if this is the only [2024-12-09 11:46:52.122392] app.c: 619:app_setup_trace: *NOTICE*: SPDK application currently running. [2024-12-09 11:46:52.122402] app.c: 620:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid4176076 for offline analysis/debug. [2024-12-09 11:46:52.123600] reactor.c:1005:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Mon Dec 9 11:46:55 2024 CPU: 72 * Intel(R) Xeon(R) Gold 6140 CPU @ 2.30GHz CPUCache: 25344 KB 2024/12/09-11:46:58 ... thread 0: (1000000,1000000) ops and (341091.3,341091.3) ops/second in (2.931766,2.931766) 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/9 629.19 MB 6.3 0.0 0.0 0.0 0.9 0.9 0.0 1.0 0.0 349.5 2.52 2.35 13 0.194 0 0 0.0 0.0 L1 3/3 188.08 MB 0.0 0.2 0.2 0.0 0.2 0.2 0.1 1.0 248.9 248.3 0.76 0.74 1 0.757 191K 425 0.0 0.0 L2 1/1 100.58 MB 0.0 0.2 0.1 0.1 0.2 0.1 0.0 2.6 241.1 240.6 0.67 0.64 1 0.667 163K 289 0.0 0.0 L3 16/9 878.82 MB 0.1 0.1 0.1 0.0 0.1 0.1 0.0 1.0 193.4 193.4 0.31 0.29 1 0.310 60K 0 0.0 0.0 L4 116/0 9.47 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 112/0 8.86 GB 0.1 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 258/22 20.09 GB 0.0 0.4 0.3 0.1 1.3 1.2 0.1 1.5 96.2 303.0 4.25 4.02 16 0.266 415K 714 0.0 0.0 Int 0/0 0.00 KB 0.0 0.4 0.3 0.1 1.3 1.2 0.1 1.5 96.2 303.0 4.25 4.02 16 0.266 415K 714 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.3 0.1 0.4 0.3 0.0 0.0 236.0 235.5 1.73 1.67 3 0.578 415K 714 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 349.5 2.52 2.35 13 0.194 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.0 total, 2.9 interval Flush(GB): cumulative 0.860, interval 0.860 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.26 GB write, 428.99 MB/s write, 0.40 GB read, 136.16 MB/s read, 4.3 seconds Interval compaction: 1.26 GB write, 439.44 MB/s write, 0.40 GB read, 139.48 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: 2, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 2, interval: 2 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 116636 Average: 2.0437 StdDev: 6.03 Min: 1 Median: 1.3846 Max: 1231 Percentiles: P50: 1.38 P75: 1.79 P99: 5.68 P99.9: 11.91 P99.99: 24.02 ------------------------------------------------------ [ 0, 1 ] 30719 26.337% 26.337% ##### ( 1, 2 ] 71753 61.519% 87.856% ############ ( 2, 3 ] 8083 6.930% 94.786% # ( 3, 4 ] 3178 2.725% 97.511% # ( 4, 6 ] 2068 1.773% 99.284% ( 6, 10 ] 661 0.567% 99.851% ( 10, 15 ] 155 0.133% 99.984% ( 15, 22 ] 9 0.008% 99.991% ( 22, 34 ] 2 0.002% 99.993% ( 34, 51 ] 1 0.001% 99.994% ( 51, 76 ] 1 0.001% 99.995% ( 170, 250 ] 12 0.010% 100.005% ( 250, 380 ] 4 0.003% 100.009% ( 380, 580 ] 9 0.008% 100.016% ( 870, 1300 ] 1 0.001% 100.017% ** Level 1 read latency histogram (micros): Count: 21895 Average: 2.1565 StdDev: 6.64 Min: 1 Median: 1.4673 Max: 714 Percentiles: P50: 1.47 P75: 1.86 P99: 5.63 P99.9: 9.70 P99.99: 355.36 ------------------------------------------------------ [ 0, 1 ] 4471 20.420% 20.420% #### ( 1, 2 ] 13858 63.293% 83.713% ############# ( 2, 3 ] 2162 9.874% 93.588% ## ( 3, 4 ] 752 3.435% 97.022% # ( 4, 6 ] 533 2.434% 99.456% ( 6, 10 ] 107 0.489% 99.945% ( 10, 15 ] 9 0.041% 99.986% ( 34, 51 ] 1 0.005% 99.991% ( 170, 250 ] 1 0.005% 99.995% ( 250, 380 ] 1 0.005% 100.000% ( 380, 580 ] 1 0.005% 100.005% ( 580, 870 ] 1 0.005% 100.009% ** Level 2 read latency histogram (micros): Count: 40163 Average: 2.7522 StdDev: 15.19 Min: 0 Median: 1.4581 Max: 1148 Percentiles: P50: 1.46 P75: 1.88 P99: 9.67 P99.9: 144.52 P99.99: 868.42 ------------------------------------------------------ [ 0, 1 ] 9255 23.044% 23.044% ##### ( 1, 2 ] 23634 58.845% 81.889% ############ ( 2, 3 ] 3808 9.481% 91.370% ## ( 3, 4 ] 1320 3.287% 94.657% # ( 4, 6 ] 1245 3.100% 97.757% # ( 6, 10 ] 545 1.357% 99.114% ( 10, 15 ] 188 0.468% 99.582% ( 15, 22 ] 16 0.040% 99.622% ( 22, 34 ] 5 0.012% 99.634% ( 34, 51 ] 27 0.067% 99.701% ( 51, 76 ] 4 0.010% 99.711% ( 76, 110 ] 58 0.144% 99.856% ( 110, 170 ] 31 0.077% 99.933% ( 170, 250 ] 11 0.027% 99.960% ( 250, 380 ] 7 0.017% 99.978% ( 380, 580 ] 2 0.005% 99.983% ( 580, 870 ] 3 0.007% 99.990% ( 870, 1300 ] 4 0.010% 100.000% ** Level 3 read latency histogram (micros): Count: 26432 Average: 8.2015 StdDev: 165.84 Min: 1 Median: 1.7264 Max: 8721 Percentiles: P50: 1.73 P75: 2.53 P99: 12.62 P99.9: 820.24 P99.99: 8446.24 ------------------------------------------------------ [ 0, 1 ] 1589 6.012% 6.012% # ( 1, 2 ] 16006 60.555% 66.567% ############ ( 2, 3 ] 4201 15.894% 82.461% ### ( 3, 4 ] 1995 7.548% 90.008% ## ( 4, 6 ] 1600 6.053% 96.062% # ( 6, 10 ] 656 2.482% 98.543% ( 10, 15 ] 230 0.870% 99.414% ( 15, 22 ] 29 0.110% 99.523% ( 22, 34 ] 9 0.034% 99.557% ( 34, 51 ] 6 0.023% 99.580% ( 110, 170 ] 58 0.219% 99.799% ( 170, 250 ] 4 0.015% 99.815% ( 250, 380 ] 2 0.008% 99.822% ( 380, 580 ] 4 0.015% 99.837% ( 580, 870 ] 20 0.076% 99.913% ( 870, 1300 ] 2 0.008% 99.921% ( 1900, 2900 ] 3 0.011% 99.932% ( 2900, 4400 ] 3 0.011% 99.943% ( 4400, 6600 ] 9 0.034% 99.977% ( 6600, 9900 ] 6 0.023% 100.000% ** Level 4 read latency histogram (micros): Count: 25 Average: 3075.4400 StdDev: 2216.68 Min: 139 Median: 3025.0000 Max: 7515 Percentiles: P50: 3025.00 P75: 4730.00 P99: 7515.00 P99.9: 7515.00 P99.99: 7515.00 ------------------------------------------------------ ( 110, 170 ] 1 4.000% 4.000% # ( 250, 380 ] 1 4.000% 8.000% # ( 380, 580 ] 1 4.000% 12.000% # ( 580, 870 ] 1 4.000% 16.000% # ( 870, 1300 ] 4 16.000% 32.000% ### ( 1300, 1900 ] 2 8.000% 40.000% ## ( 1900, 2900 ] 2 8.000% 48.000% ## ( 2900, 4400 ] 6 24.000% 72.000% ##### ( 4400, 6600 ] 5 20.000% 92.000% #### ( 6600, 9900 ] 2 8.000% 100.000% ## ** DB Stats ** Uptime(secs): 3.0 total, 2.9 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 327.47 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.200 H:M:S, 6.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 335.36 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.200 H:M:S, 6.8 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/12/09-11:47:01 ... thread 0: (1000000,2000000) ops and (325034.7,332869.5) ops/second in (3.076595,6.008361) 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.22 GB 100.3 0.7 0.0 0.7 2.5 1.8 0.0 1.4 91.2 311.3 8.27 7.82 30 0.276 766K 3630 0.0 0.0 L1 1/0 23.19 MB 2.3 0.7 0.5 0.2 0.7 0.5 0.1 1.4 230.9 229.0 2.99 2.92 2 1.497 701K 5369 0.0 0.0 L2 2/2 229.36 MB 0.0 0.2 0.1 0.1 0.2 0.1 0.5 2.6 241.1 240.6 0.67 0.64 1 0.667 163K 289 0.0 0.0 L3 18/14 1.19 GB 0.3 0.4 0.4 0.0 0.4 0.4 0.0 1.1 207.5 207.0 2.17 2.08 3 0.724 457K 1137 0.0 0.0 L4 116/0 9.47 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 112/0 8.86 GB 0.1 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 259/20 21.00 GB 0.0 2.0 0.9 1.1 3.8 2.7 0.5 2.1 145.9 274.4 14.11 13.46 36 0.392 2089K 10K 0.0 0.0 Int 0/0 0.00 KB 0.0 2.0 0.9 1.1 3.8 2.7 0.5 2.1 145.9 274.4 14.11 13.46 36 0.392 2089K 10K 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.9 1.1 2.0 0.9 0.0 0.0 231.2 230.0 8.90 8.65 9 0.989 2089K 10K 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 350.4 5.21 4.81 27 0.193 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.1 total, 6.0 interval Flush(GB): cumulative 1.781, interval 1.781 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.78 GB write, 636.52 MB/s write, 2.01 GB read, 338.30 MB/s read, 14.1 seconds Interval compaction: 3.78 GB write, 644.09 MB/s write, 2.01 GB read, 342.33 MB/s read, 14.1 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 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: 396722 Average: 2.5494 StdDev: 8.04 Min: 1 Median: 1.6627 Max: 2461 Percentiles: P50: 1.66 P75: 2.26 P99: 7.24 P99.9: 14.11 P99.99: 27.26 ------------------------------------------------------ [ 0, 1 ] 40885 10.306% 10.306% ## ( 1, 2 ] 237612 59.894% 70.200% ############ ( 2, 3 ] 72097 18.173% 88.373% #### ( 3, 4 ] 22630 5.704% 94.077% # ( 4, 6 ] 18378 4.632% 98.709% # ( 6, 10 ] 3722 0.938% 99.648% ( 10, 15 ] 1218 0.307% 99.955% ( 15, 22 ] 133 0.034% 99.988% ( 22, 34 ] 19 0.005% 99.993% ( 34, 51 ] 6 0.002% 99.994% ( 51, 76 ] 4 0.001% 99.995% ( 76, 110 ] 2 0.001% 99.996% ( 110, 170 ] 64 0.016% 100.012% ( 170, 250 ] 39 0.010% 100.022% ( 250, 380 ] 18 0.005% 100.026% ( 380, 580 ] 23 0.006% 100.032% ( 580, 870 ] 4 0.001% 100.033% ( 870, 1300 ] 6 0.002% 100.035% ( 1300, 1900 ] 1 0.000% 100.035% ( 1900, 2900 ] 1 0.000% 100.035% ** Level 1 read latency histogram (micros): Count: 147334 Average: 2.9349 StdDev: 8.25 Min: 1 Median: 1.8142 Max: 973 Percentiles: P50: 1.81 P75: 2.61 P99: 9.17 P99.9: 27.09 P99.99: 183.55 ------------------------------------------------------ [ 0, 1 ] 6717 4.559% 4.559% # ( 1, 2 ] 82226 55.809% 60.368% ########### ( 2, 3 ] 35111 23.831% 84.199% ##### ( 3, 4 ] 10221 6.937% 91.136% # ( 4, 6 ] 9586 6.506% 97.643% # ( 6, 10 ] 2525 1.714% 99.357% ( 10, 15 ] 702 0.476% 99.833% ( 15, 22 ] 95 0.064% 99.898% ( 22, 34 ] 11 0.007% 99.905% ( 34, 51 ] 3 0.002% 99.907% ( 51, 76 ] 3 0.002% 99.909% ( 76, 110 ] 30 0.020% 99.929% ( 110, 170 ] 84 0.057% 99.986% ( 170, 250 ] 37 0.025% 100.012% ( 250, 380 ] 8 0.005% 100.017% ( 380, 580 ] 10 0.007% 100.024% ( 580, 870 ] 4 0.003% 100.026% ( 870, 1300 ] 2 0.001% 100.028% ** Level 2 read latency histogram (micros): Count: 50969 Average: 3.0014 StdDev: 15.95 Min: 0 Median: 1.5158 Max: 1148 Percentiles: P50: 1.52 P75: 1.93 P99: 9.67 P99.9: 200.43 P99.99: 763.97 ------------------------------------------------------ [ 0, 1 ] 9735 19.100% 19.100% #### ( 1, 2 ] 30532 59.903% 79.003% ############ ( 2, 3 ] 5913 11.601% 90.604% ## ( 3, 4 ] 1896 3.720% 94.324% # ( 4, 6 ] 1670 3.277% 97.601% # ( 6, 10 ] 778 1.526% 99.127% ( 10, 15 ] 200 0.392% 99.519% ( 15, 22 ] 19 0.037% 99.557% ( 22, 34 ] 5 0.010% 99.566% ( 34, 51 ] 27 0.053% 99.619% ( 51, 76 ] 4 0.008% 99.627% ( 76, 110 ] 58 0.114% 99.741% ( 110, 170 ] 70 0.137% 99.878% ( 170, 250 ] 29 0.057% 99.935% ( 250, 380 ] 18 0.035% 99.971% ( 380, 580 ] 8 0.016% 99.986% ( 580, 870 ] 3 0.006% 99.992% ( 870, 1300 ] 4 0.008% 100.000% ** Level 3 read latency histogram (micros): Count: 228927 Average: 3.7124 StdDev: 57.11 Min: 1 Median: 1.7486 Max: 8721 Percentiles: P50: 1.75 P75: 2.50 P99: 9.82 P99.9: 163.13 P99.99: 501.07 ------------------------------------------------------ [ 0, 1 ] 10065 4.397% 4.397% # ( 1, 2 ] 139460 60.919% 65.316% ############ ( 2, 3 ] 44105 19.266% 84.582% #### ( 3, 4 ] 15744 6.877% 91.459% # ( 4, 6 ] 12318 5.381% 96.840% # ( 6, 10 ] 5181 2.263% 99.103% ( 10, 15 ] 1069 0.467% 99.570% ( 15, 22 ] 106 0.046% 99.616% ( 22, 34 ] 18 0.008% 99.624% ( 34, 51 ] 199 0.087% 99.711% ( 51, 76 ] 88 0.038% 99.749% ( 76, 110 ] 52 0.023% 99.772% ( 110, 170 ] 331 0.145% 99.917% ( 170, 250 ] 116 0.051% 99.967% ( 250, 380 ] 40 0.017% 99.985% ( 380, 580 ] 20 0.009% 99.993% ( 580, 870 ] 23 0.010% 100.003% ( 870, 1300 ] 2 0.001% 100.004% ( 1900, 2900 ] 3 0.001% 100.006% ( 2900, 4400 ] 3 0.001% 100.007% ( 4400, 6600 ] 9 0.004% 100.011% ( 6600, 9900 ] 6 0.003% 100.014% ** Level 4 read latency histogram (micros): Count: 25 Average: 3075.4400 StdDev: 2216.68 Min: 139 Median: 3025.0000 Max: 7515 Percentiles: P50: 3025.00 P75: 4730.00 P99: 7515.00 P99.9: 7515.00 P99.99: 7515.00 ------------------------------------------------------ ( 110, 170 ] 1 4.000% 4.000% # ( 250, 380 ] 1 4.000% 8.000% # ( 380, 580 ] 1 4.000% 12.000% # ( 580, 870 ] 1 4.000% 16.000% # ( 870, 1300 ] 4 16.000% 32.000% ### ( 1300, 1900 ] 2 8.000% 40.000% ## ( 1900, 2900 ] 2 8.000% 48.000% ## ( 2900, 4400 ] 6 24.000% 72.000% ##### ( 4400, 6600 ] 5 20.000% 92.000% #### ( 6600, 9900 ] 2 8.000% 100.000% ## ** DB Stats ** Uptime(secs): 6.1 total, 3.1 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 323.66 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.375 H:M:S, 6.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 319.93 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.175 H:M:S, 5.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/12/09-11:47:04 ... thread 0: (1000000,3000000) ops and (331786.8,332507.8) ops/second in (3.013984,9.022345) 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/12 2.20 GB 68.9 1.5 0.0 1.5 4.2 2.8 0.0 1.5 106.7 306.1 14.16 13.43 48 0.295 1533K 7280 0.0 0.0 L1 1/1 23.19 MB 0.0 0.7 0.5 0.2 0.7 0.5 0.1 1.4 230.9 229.0 2.99 2.92 2 1.497 701K 5369 0.0 0.0 L2 0/0 0.00 KB 0.0 0.2 0.1 0.1 0.2 0.1 0.5 2.6 241.1 240.6 0.67 0.64 1 0.667 163K 289 0.0 0.0 L3 19/0 934.58 MB 0.9 1.6 0.6 0.9 1.5 0.6 0.0 2.5 227.7 227.0 6.98 6.66 5 1.396 1613K 4338 0.0 0.0 L4 122/0 9.67 GB 1.0 0.3 0.3 0.0 0.3 0.3 0.3 1.0 202.8 202.8 1.27 1.21 1 1.270 261K 0 0.0 0.0 L5 116/0 9.17 GB 0.1 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 274/13 21.97 GB 0.0 4.1 1.4 2.7 6.9 4.2 1.1 2.5 161.4 269.4 26.06 24.84 57 0.457 4273K 17K 0.0 0.0 Int 0/0 0.00 KB 0.0 4.1 1.4 2.7 6.9 4.2 1.1 2.5 161.4 269.4 26.06 24.84 57 0.457 4273K 17K 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 4.1 1.4 2.7 4.1 1.4 0.0 0.0 233.9 233.0 17.99 17.38 15 1.199 4273K 17K 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 350.4 8.08 7.46 42 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): 9.1 total, 9.0 interval Flush(GB): cumulative 2.764, interval 2.764 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 6.86 GB write, 771.93 MB/s write, 4.11 GB read, 462.64 MB/s read, 26.1 seconds Interval compaction: 6.86 GB write, 778.04 MB/s write, 4.11 GB read, 466.31 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: 6, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 6, interval: 6 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 707558 Average: 2.6196 StdDev: 8.55 Min: 1 Median: 1.6586 Max: 2461 Percentiles: P50: 1.66 P75: 2.21 P99: 7.73 P99.9: 14.90 P99.99: 154.45 ------------------------------------------------------ [ 0, 1 ] 64920 9.175% 9.175% ## ( 1, 2 ] 438602 61.988% 71.163% ############ ( 2, 3 ] 129037 18.237% 89.400% #### ( 3, 4 ] 36716 5.189% 94.589% # ( 4, 6 ] 27935 3.948% 98.538% # ( 6, 10 ] 7545 1.066% 99.604% ( 10, 15 ] 2138 0.302% 99.906% ( 15, 22 ] 237 0.033% 99.940% ( 22, 34 ] 27 0.004% 99.943% ( 34, 51 ] 9 0.001% 99.945% ( 51, 76 ] 9 0.001% 99.946% ( 76, 110 ] 30 0.004% 99.950% ( 110, 170 ] 381 0.054% 100.004% ( 170, 250 ] 121 0.017% 100.021% ( 250, 380 ] 63 0.009% 100.030% ( 380, 580 ] 46 0.007% 100.036% ( 580, 870 ] 9 0.001% 100.038% ( 870, 1300 ] 11 0.002% 100.039% ( 1300, 1900 ] 1 0.000% 100.039% ( 1900, 2900 ] 1 0.000% 100.040% ** Level 1 read latency histogram (micros): Count: 168221 Average: 2.8951 StdDev: 7.75 Min: 1 Median: 1.8070 Max: 973 Percentiles: P50: 1.81 P75: 2.59 P99: 9.13 P99.9: 21.05 P99.99: 179.03 ------------------------------------------------------ [ 0, 1 ] 7322 4.353% 4.353% # ( 1, 2 ] 95148 56.561% 60.914% ########### ( 2, 3 ] 40001 23.779% 84.693% ##### ( 3, 4 ] 11367 6.757% 91.450% # ( 4, 6 ] 10405 6.185% 97.635% # ( 6, 10 ] 2938 1.747% 99.382% ( 10, 15 ] 781 0.464% 99.846% ( 15, 22 ] 105 0.062% 99.908% ( 22, 34 ] 12 0.007% 99.916% ( 34, 51 ] 3 0.002% 99.917% ( 51, 76 ] 3 0.002% 99.919% ( 76, 110 ] 30 0.018% 99.937% ( 110, 170 ] 85 0.051% 99.988% ( 170, 250 ] 37 0.022% 100.010% ( 250, 380 ] 8 0.005% 100.014% ( 380, 580 ] 10 0.006% 100.020% ( 580, 870 ] 4 0.002% 100.023% ( 870, 1300 ] 2 0.001% 100.024% ** Level 2 read latency histogram (micros): Count: 65614 Average: 2.8696 StdDev: 14.07 Min: 0 Median: 1.5463 Max: 1148 Percentiles: P50: 1.55 P75: 1.95 P99: 9.25 P99.9: 166.90 P99.99: 622.40 ------------------------------------------------------ [ 0, 1 ] 10738 16.365% 16.365% ### ( 1, 2 ] 40399 61.571% 77.936% ############ ( 2, 3 ] 8220 12.528% 90.464% ### ( 3, 4 ] 2613 3.982% 94.446% # ( 4, 6 ] 2115 3.223% 97.670% # ( 6, 10 ] 1073 1.635% 99.305% ( 10, 15 ] 209 0.319% 99.624% ( 15, 22 ] 20 0.030% 99.654% ( 22, 34 ] 6 0.009% 99.663% ( 34, 51 ] 27 0.041% 99.704% ( 51, 76 ] 4 0.006% 99.710% ( 76, 110 ] 58 0.088% 99.799% ( 110, 170 ] 70 0.107% 99.906% ( 170, 250 ] 29 0.044% 99.950% ( 250, 380 ] 18 0.027% 99.977% ( 380, 580 ] 8 0.012% 99.989% ( 580, 870 ] 3 0.005% 99.994% ( 870, 1300 ] 4 0.006% 100.000% ** Level 3 read latency histogram (micros): Count: 307685 Average: 3.6760 StdDev: 49.82 Min: 0 Median: 1.7605 Max: 8721 Percentiles: P50: 1.76 P75: 2.51 P99: 9.87 P99.9: 185.58 P99.99: 420.20 ------------------------------------------------------ [ 0, 1 ] 12490 4.059% 4.059% # ( 1, 2 ] 185863 60.407% 64.466% ############ ( 2, 3 ] 63494 20.636% 85.102% #### ( 3, 4 ] 20070 6.523% 91.625% # ( 4, 6 ] 16038 5.212% 96.838% # ( 6, 10 ] 6875 2.234% 99.072% ( 10, 15 ] 1466 0.476% 99.549% ( 15, 22 ] 157 0.051% 99.600% ( 22, 34 ] 20 0.007% 99.606% ( 34, 51 ] 199 0.065% 99.671% ( 51, 76 ] 89 0.029% 99.700% ( 76, 110 ] 52 0.017% 99.717% ( 110, 170 ] 524 0.170% 99.887% ( 170, 250 ] 207 0.067% 99.954% ( 250, 380 ] 104 0.034% 99.988% ( 380, 580 ] 31 0.010% 99.998% ( 580, 870 ] 25 0.008% 100.006% ( 870, 1300 ] 3 0.001% 100.007% ( 1900, 2900 ] 3 0.001% 100.008% ( 2900, 4400 ] 3 0.001% 100.009% ( 4400, 6600 ] 9 0.003% 100.012% ( 6600, 9900 ] 6 0.002% 100.014% ** Level 4 read latency histogram (micros): Count: 55 Average: 1439.4909 StdDev: 2114.30 Min: 1 Median: 230.0000 Max: 7515 Percentiles: P50: 230.00 P75: 2525.00 P99: 7515.00 P99.9: 7515.00 P99.99: 7515.00 ------------------------------------------------------ [ 0, 1 ] 10 18.182% 18.182% #### ( 1, 2 ] 6 10.909% 29.091% ## ( 2, 3 ] 2 3.636% 32.727% # ( 34, 51 ] 2 3.636% 36.364% # ( 110, 170 ] 6 10.909% 47.273% ## ( 170, 250 ] 2 3.636% 50.909% # ( 250, 380 ] 3 5.455% 56.364% # ( 380, 580 ] 2 3.636% 60.000% # ( 580, 870 ] 1 1.818% 61.818% ( 870, 1300 ] 4 7.273% 69.091% # ( 1300, 1900 ] 2 3.636% 72.727% # ( 1900, 2900 ] 2 3.636% 76.364% # ( 2900, 4400 ] 6 10.909% 87.273% ## ( 4400, 6600 ] 5 9.091% 96.364% ## ( 6600, 9900 ] 2 3.636% 100.000% # ** Level 5 read latency histogram (micros): Count: 20 Average: 443.1500 StdDev: 524.36 Min: 105 Median: 196.6667 Max: 2261 Percentiles: P50: 196.67 P75: 580.00 P99: 2261.00 P99.9: 2261.00 P99.99: 2261.00 ------------------------------------------------------ ( 76, 110 ] 2 10.000% 10.000% ## ( 110, 170 ] 7 35.000% 45.000% ####### ( 170, 250 ] 3 15.000% 60.000% ### ( 250, 380 ] 2 10.000% 70.000% ## ( 380, 580 ] 1 5.000% 75.000% # ( 580, 870 ] 1 5.000% 80.000% # ( 870, 1300 ] 3 15.000% 95.000% ### ( 1900, 2900 ] 1 5.000% 100.000% # ** DB Stats ** Uptime(secs): 9.1 total, 3.0 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 324.61 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.555 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, 326.54 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.180 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/09-11:47:07 ... thread 0: (1000000,4000000) ops and (280400.9,317746.1) ops/second in (3.566322,12.588667) 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 14/8 1.90 GB 144.0 2.3 0.0 2.3 6.0 3.7 0.0 1.6 114.8 303.4 20.28 19.28 66 0.307 2363K 11K 0.0 0.0 L1 11/0 1.27 GB 130.1 2.0 1.8 0.2 1.9 1.7 0.1 1.1 223.1 218.3 9.10 8.77 3 3.034 2062K 43K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.2 0.1 0.1 0.2 0.1 0.5 2.6 241.1 240.6 0.67 0.64 1 0.667 163K 289 0.0 0.0 L3 19/0 934.58 MB 0.9 1.6 0.6 0.9 1.5 0.6 0.0 2.5 227.7 227.0 6.98 6.66 5 1.396 1613K 4338 0.0 0.0 L4 122/0 9.67 GB 1.0 0.3 0.3 0.0 0.3 0.3 0.3 1.0 202.8 202.8 1.27 1.21 1 1.270 261K 0 0.0 0.0 L5 116/0 9.17 GB 0.1 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 282/8 22.92 GB 0.0 6.2 2.7 3.5 9.9 6.4 1.1 2.6 166.2 264.9 38.29 36.54 76 0.504 6464K 59K 0.0 0.0 Int 0/0 0.00 KB 0.0 6.2 2.7 3.5 9.9 6.4 1.1 2.6 166.2 264.9 38.29 36.54 76 0.504 6464K 59K 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 6.2 2.7 3.5 6.2 2.7 0.0 0.0 233.3 231.1 27.28 26.37 19 1.436 6464K 59K 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 348.5 11.01 10.17 57 0.193 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 12.7 total, 12.6 interval Flush(GB): cumulative 3.747, interval 3.747 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, 801.02 MB/s write, 6.22 GB read, 502.68 MB/s read, 38.3 seconds Interval compaction: 9.90 GB write, 805.56 MB/s write, 6.22 GB read, 505.54 MB/s read, 38.3 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 4, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 4, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 7, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 4, total-stops: 7, interval: 11 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1134611 Average: 2.5473 StdDev: 8.13 Min: 0 Median: 1.6290 Max: 2461 Percentiles: P50: 1.63 P75: 2.07 P99: 7.38 P99.9: 14.58 P99.99: 145.48 ------------------------------------------------------ [ 0, 1 ] 110006 9.695% 9.695% ## ( 1, 2 ] 727060 64.080% 73.776% ############# ( 2, 3 ] 193299 17.037% 90.812% ### ( 3, 4 ] 51678 4.555% 95.367% # ( 4, 6 ] 37172 3.276% 98.643% # ( 6, 10 ] 11765 1.037% 99.680% ( 10, 15 ] 2729 0.241% 99.921% ( 15, 22 ] 281 0.025% 99.945% ( 22, 34 ] 36 0.003% 99.948% ( 34, 51 ] 10 0.001% 99.949% ( 51, 76 ] 12 0.001% 99.950% ( 76, 110 ] 108 0.010% 99.960% ( 110, 170 ] 581 0.051% 100.011% ( 170, 250 ] 188 0.017% 100.028% ( 250, 380 ] 89 0.008% 100.036% ( 380, 580 ] 64 0.006% 100.041% ( 580, 870 ] 13 0.001% 100.042% ( 870, 1300 ] 15 0.001% 100.044% ( 1300, 1900 ] 2 0.000% 100.044% ( 1900, 2900 ] 1 0.000% 100.044% ** Level 1 read latency histogram (micros): Count: 174164 Average: 3.0358 StdDev: 12.45 Min: 1 Median: 1.8016 Max: 1998 Percentiles: P50: 1.80 P75: 2.58 P99: 9.21 P99.9: 117.36 P99.99: 239.77 ------------------------------------------------------ [ 0, 1 ] 7739 4.444% 4.444% # ( 1, 2 ] 98986 56.835% 61.278% ########### ( 2, 3 ] 41123 23.612% 84.890% ##### ( 3, 4 ] 11579 6.648% 91.538% # ( 4, 6 ] 10547 6.056% 97.594% # ( 6, 10 ] 3048 1.750% 99.344% ( 10, 15 ] 792 0.455% 99.799% ( 15, 22 ] 105 0.060% 99.859% ( 22, 34 ] 12 0.007% 99.866% ( 34, 51 ] 3 0.002% 99.868% ( 51, 76 ] 3 0.002% 99.870% ( 76, 110 ] 38 0.022% 99.891% ( 110, 170 ] 121 0.069% 99.961% ( 170, 250 ] 58 0.033% 99.994% ( 250, 380 ] 12 0.007% 100.001% ( 380, 580 ] 17 0.010% 100.011% ( 580, 870 ] 16 0.009% 100.020% ( 870, 1300 ] 3 0.002% 100.022% ( 1300, 1900 ] 1 0.001% 100.022% ( 1900, 2900 ] 1 0.001% 100.023% ** Level 2 read latency histogram (micros): Count: 65614 Average: 2.8696 StdDev: 14.07 Min: 0 Median: 1.5463 Max: 1148 Percentiles: P50: 1.55 P75: 1.95 P99: 9.25 P99.9: 166.90 P99.99: 622.40 ------------------------------------------------------ [ 0, 1 ] 10738 16.365% 16.365% ### ( 1, 2 ] 40399 61.571% 77.936% ############ ( 2, 3 ] 8220 12.528% 90.464% ### ( 3, 4 ] 2613 3.982% 94.446% # ( 4, 6 ] 2115 3.223% 97.670% # ( 6, 10 ] 1073 1.635% 99.305% ( 10, 15 ] 209 0.319% 99.624% ( 15, 22 ] 20 0.030% 99.654% ( 22, 34 ] 6 0.009% 99.663% ( 34, 51 ] 27 0.041% 99.704% ( 51, 76 ] 4 0.006% 99.710% ( 76, 110 ] 58 0.088% 99.799% ( 110, 170 ] 70 0.107% 99.906% ( 170, 250 ] 29 0.044% 99.950% ( 250, 380 ] 18 0.027% 99.977% ( 380, 580 ] 8 0.012% 99.989% ( 580, 870 ] 3 0.005% 99.994% ( 870, 1300 ] 4 0.006% 100.000% ** Level 3 read latency histogram (micros): Count: 307685 Average: 3.6760 StdDev: 49.82 Min: 0 Median: 1.7605 Max: 8721 Percentiles: P50: 1.76 P75: 2.51 P99: 9.87 P99.9: 185.58 P99.99: 420.20 ------------------------------------------------------ [ 0, 1 ] 12490 4.059% 4.059% # ( 1, 2 ] 185863 60.407% 64.466% ############ ( 2, 3 ] 63494 20.636% 85.102% #### ( 3, 4 ] 20070 6.523% 91.625% # ( 4, 6 ] 16038 5.212% 96.838% # ( 6, 10 ] 6875 2.234% 99.072% ( 10, 15 ] 1466 0.476% 99.549% ( 15, 22 ] 157 0.051% 99.600% ( 22, 34 ] 20 0.007% 99.606% ( 34, 51 ] 199 0.065% 99.671% ( 51, 76 ] 89 0.029% 99.700% ( 76, 110 ] 52 0.017% 99.717% ( 110, 170 ] 524 0.170% 99.887% ( 170, 250 ] 207 0.067% 99.954% ( 250, 380 ] 104 0.034% 99.988% ( 380, 580 ] 31 0.010% 99.998% ( 580, 870 ] 25 0.008% 100.006% ( 870, 1300 ] 3 0.001% 100.007% ( 1900, 2900 ] 3 0.001% 100.008% ( 2900, 4400 ] 3 0.001% 100.009% ( 4400, 6600 ] 9 0.003% 100.012% ( 6600, 9900 ] 6 0.002% 100.014% ** Level 4 read latency histogram (micros): Count: 55 Average: 1439.4909 StdDev: 2114.30 Min: 1 Median: 230.0000 Max: 7515 Percentiles: P50: 230.00 P75: 2525.00 P99: 7515.00 P99.9: 7515.00 P99.99: 7515.00 ------------------------------------------------------ [ 0, 1 ] 10 18.182% 18.182% #### ( 1, 2 ] 6 10.909% 29.091% ## ( 2, 3 ] 2 3.636% 32.727% # ( 34, 51 ] 2 3.636% 36.364% # ( 110, 170 ] 6 10.909% 47.273% ## ( 170, 250 ] 2 3.636% 50.909% # ( 250, 380 ] 3 5.455% 56.364% # ( 380, 580 ] 2 3.636% 60.000% # ( 580, 870 ] 1 1.818% 61.818% ( 870, 1300 ] 4 7.273% 69.091% # ( 1300, 1900 ] 2 3.636% 72.727% # ( 1900, 2900 ] 2 3.636% 76.364% # ( 2900, 4400 ] 6 10.909% 87.273% ## ( 4400, 6600 ] 5 9.091% 96.364% ## ( 6600, 9900 ] 2 3.636% 100.000% # ** Level 5 read latency histogram (micros): Count: 20 Average: 443.1500 StdDev: 524.36 Min: 105 Median: 196.6667 Max: 2261 Percentiles: P50: 196.67 P75: 580.00 P99: 2261.00 P99.9: 2261.00 P99.99: 2261.00 ------------------------------------------------------ ( 76, 110 ] 2 10.000% 10.000% ## ( 110, 170 ] 7 35.000% 45.000% ####### ( 170, 250 ] 3 15.000% 60.000% ### ( 250, 380 ] 2 10.000% 70.000% ## ( 380, 580 ] 1 5.000% 75.000% # ( 580, 870 ] 1 5.000% 80.000% # ( 870, 1300 ] 3 15.000% 95.000% ### ( 1900, 2900 ] 1 5.000% 100.000% # ** DB Stats ** Uptime(secs): 12.7 total, 3.6 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 310.91 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:1.340 H:M:S, 10.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 275.96 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.785 H:M:S, 22.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/09-11:47:10 ... thread 0: (1000000,5000000) ops and (342520.7,322410.1) ops/second in (2.919532,15.508199) 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 17/4 2.88 GB 269.3 3.3 0.0 3.3 8.0 4.7 0.0 1.7 123.7 302.9 26.95 25.69 85 0.317 3385K 16K 0.0 0.0 L1 11/0 1.27 GB 130.1 2.0 1.8 0.2 1.9 1.7 0.1 1.1 223.1 218.3 9.10 8.77 3 3.034 2062K 43K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.2 0.1 0.1 0.2 0.1 0.5 2.6 241.1 240.6 0.67 0.64 1 0.667 163K 289 0.0 0.0 L3 19/0 934.58 MB 0.9 1.6 0.6 0.9 1.5 0.6 0.0 2.5 227.7 227.0 6.98 6.66 5 1.396 1613K 4338 0.0 0.0 L4 122/0 9.67 GB 1.0 0.3 0.3 0.0 0.3 0.3 0.3 1.0 202.8 202.8 1.27 1.21 1 1.270 261K 0 0.0 0.0 L5 116/0 9.17 GB 0.1 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 285/4 23.89 GB 0.0 7.2 2.7 4.5 11.9 7.4 1.1 2.5 163.9 270.2 44.96 42.95 95 0.473 7486K 64K 0.0 0.0 Int 0/0 0.00 KB 0.0 7.2 2.7 4.5 11.9 7.4 1.1 2.5 163.9 270.2 44.96 42.95 95 0.473 7486K 64K 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 7.2 2.7 4.5 7.1 2.6 0.0 0.0 236.1 234.0 31.22 30.24 23 1.357 7486K 64K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 4.7 4.7 0.0 0.0 0.0 352.5 13.74 12.72 72 0.191 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 15.6 total, 15.5 interval Flush(GB): cumulative 4.730, interval 4.730 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 11.87 GB write, 779.80 MB/s write, 7.20 GB read, 473.10 MB/s read, 45.0 seconds Interval compaction: 11.87 GB write, 783.40 MB/s write, 7.20 GB read, 475.28 MB/s read, 45.0 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 4, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 4, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 8, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 4, total-stops: 8, interval: 12 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1373824 Average: 2.4588 StdDev: 7.85 Min: 0 Median: 1.5916 Max: 2461 Percentiles: P50: 1.59 P75: 1.98 P99: 6.93 P99.9: 14.33 P99.99: 144.76 ------------------------------------------------------ [ 0, 1 ] 162000 11.792% 11.792% ## ( 1, 2 ] 887330 64.588% 76.380% ############# ( 2, 3 ] 211577 15.401% 91.781% ### ( 3, 4 ] 56886 4.141% 95.922% # ( 4, 6 ] 39361 2.865% 98.787% # ( 6, 10 ] 12678 0.923% 99.709% ( 10, 15 ] 3023 0.220% 99.929% ( 15, 22 ] 316 0.023% 99.952% ( 22, 34 ] 42 0.003% 99.956% ( 34, 51 ] 11 0.001% 99.956% ( 51, 76 ] 18 0.001% 99.958% ( 76, 110 ] 109 0.008% 99.966% ( 110, 170 ] 581 0.042% 100.008% ( 170, 250 ] 202 0.015% 100.023% ( 250, 380 ] 101 0.007% 100.030% ( 380, 580 ] 67 0.005% 100.035% ( 580, 870 ] 17 0.001% 100.036% ( 870, 1300 ] 20 0.001% 100.037% ( 1300, 1900 ] 2 0.000% 100.038% ( 1900, 2900 ] 1 0.000% 100.038% ** Level 1 read latency histogram (micros): Count: 174164 Average: 3.0358 StdDev: 12.45 Min: 1 Median: 1.8016 Max: 1998 Percentiles: P50: 1.80 P75: 2.58 P99: 9.21 P99.9: 117.36 P99.99: 239.77 ------------------------------------------------------ [ 0, 1 ] 7739 4.444% 4.444% # ( 1, 2 ] 98986 56.835% 61.278% ########### ( 2, 3 ] 41123 23.612% 84.890% ##### ( 3, 4 ] 11579 6.648% 91.538% # ( 4, 6 ] 10547 6.056% 97.594% # ( 6, 10 ] 3048 1.750% 99.344% ( 10, 15 ] 792 0.455% 99.799% ( 15, 22 ] 105 0.060% 99.859% ( 22, 34 ] 12 0.007% 99.866% ( 34, 51 ] 3 0.002% 99.868% ( 51, 76 ] 3 0.002% 99.870% ( 76, 110 ] 38 0.022% 99.891% ( 110, 170 ] 121 0.069% 99.961% ( 170, 250 ] 58 0.033% 99.994% ( 250, 380 ] 12 0.007% 100.001% ( 380, 580 ] 17 0.010% 100.011% ( 580, 870 ] 16 0.009% 100.020% ( 870, 1300 ] 3 0.002% 100.022% ( 1300, 1900 ] 1 0.001% 100.022% ( 1900, 2900 ] 1 0.001% 100.023% ** Level 2 read latency histogram (micros): Count: 65614 Average: 2.8696 StdDev: 14.07 Min: 0 Median: 1.5463 Max: 1148 Percentiles: P50: 1.55 P75: 1.95 P99: 9.25 P99.9: 166.90 P99.99: 622.40 ------------------------------------------------------ [ 0, 1 ] 10738 16.365% 16.365% ### ( 1, 2 ] 40399 61.571% 77.936% ############ ( 2, 3 ] 8220 12.528% 90.464% ### ( 3, 4 ] 2613 3.982% 94.446% # ( 4, 6 ] 2115 3.223% 97.670% # ( 6, 10 ] 1073 1.635% 99.305% ( 10, 15 ] 209 0.319% 99.624% ( 15, 22 ] 20 0.030% 99.654% ( 22, 34 ] 6 0.009% 99.663% ( 34, 51 ] 27 0.041% 99.704% ( 51, 76 ] 4 0.006% 99.710% ( 76, 110 ] 58 0.088% 99.799% ( 110, 170 ] 70 0.107% 99.906% ( 170, 250 ] 29 0.044% 99.950% ( 250, 380 ] 18 0.027% 99.977% ( 380, 580 ] 8 0.012% 99.989% ( 580, 870 ] 3 0.005% 99.994% ( 870, 1300 ] 4 0.006% 100.000% ** Level 3 read latency histogram (micros): Count: 307685 Average: 3.6760 StdDev: 49.82 Min: 0 Median: 1.7605 Max: 8721 Percentiles: P50: 1.76 P75: 2.51 P99: 9.87 P99.9: 185.58 P99.99: 420.20 ------------------------------------------------------ [ 0, 1 ] 12490 4.059% 4.059% # ( 1, 2 ] 185863 60.407% 64.466% ############ ( 2, 3 ] 63494 20.636% 85.102% #### ( 3, 4 ] 20070 6.523% 91.625% # ( 4, 6 ] 16038 5.212% 96.838% # ( 6, 10 ] 6875 2.234% 99.072% ( 10, 15 ] 1466 0.476% 99.549% ( 15, 22 ] 157 0.051% 99.600% ( 22, 34 ] 20 0.007% 99.606% ( 34, 51 ] 199 0.065% 99.671% ( 51, 76 ] 89 0.029% 99.700% ( 76, 110 ] 52 0.017% 99.717% ( 110, 170 ] 524 0.170% 99.887% ( 170, 250 ] 207 0.067% 99.954% ( 250, 380 ] 104 0.034% 99.988% ( 380, 580 ] 31 0.010% 99.998% ( 580, 870 ] 25 0.008% 100.006% ( 870, 1300 ] 3 0.001% 100.007% ( 1900, 2900 ] 3 0.001% 100.008% ( 2900, 4400 ] 3 0.001% 100.009% ( 4400, 6600 ] 9 0.003% 100.012% ( 6600, 9900 ] 6 0.002% 100.014% ** Level 4 read latency histogram (micros): Count: 55 Average: 1439.4909 StdDev: 2114.30 Min: 1 Median: 230.0000 Max: 7515 Percentiles: P50: 230.00 P75: 2525.00 P99: 7515.00 P99.9: 7515.00 P99.99: 7515.00 ------------------------------------------------------ [ 0, 1 ] 10 18.182% 18.182% #### ( 1, 2 ] 6 10.909% 29.091% ## ( 2, 3 ] 2 3.636% 32.727% # ( 34, 51 ] 2 3.636% 36.364% # ( 110, 170 ] 6 10.909% 47.273% ## ( 170, 250 ] 2 3.636% 50.909% # ( 250, 380 ] 3 5.455% 56.364% # ( 380, 580 ] 2 3.636% 60.000% # ( 580, 870 ] 1 1.818% 61.818% ( 870, 1300 ] 4 7.273% 69.091% # ( 1300, 1900 ] 2 3.636% 72.727% # ( 1900, 2900 ] 2 3.636% 76.364% # ( 2900, 4400 ] 6 10.909% 87.273% ## ( 4400, 6600 ] 5 9.091% 96.364% ## ( 6600, 9900 ] 2 3.636% 100.000% # ** Level 5 read latency histogram (micros): Count: 20 Average: 443.1500 StdDev: 524.36 Min: 105 Median: 196.6667 Max: 2261 Percentiles: P50: 196.67 P75: 580.00 P99: 2261.00 P99.9: 2261.00 P99.99: 2261.00 ------------------------------------------------------ ( 76, 110 ] 2 10.000% 10.000% ## ( 110, 170 ] 7 35.000% 45.000% ####### ( 170, 250 ] 3 15.000% 60.000% ### ( 250, 380 ] 2 10.000% 70.000% ## ( 380, 580 ] 1 5.000% 75.000% # ( 580, 870 ] 1 5.000% 80.000% # ( 870, 1300 ] 3 15.000% 95.000% ### ( 1900, 2900 ] 1 5.000% 100.000% # ** DB Stats ** Uptime(secs): 15.6 total, 2.9 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 315.82 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:1.511 H:M:S, 9.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 337.09 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.171 H:M:S, 5.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/12/09-11:47:14 ... thread 0: (1000000,6000000) ops and (270967.5,312521.5) ops/second in (3.690480,19.198679) 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/18 3.85 GB 0.0 4.5 0.0 4.5 10.2 5.7 0.0 1.8 133.4 300.4 34.89 33.34 106 0.329 4727K 22K 0.0 0.0 L1 11/11 1.27 GB 0.0 2.0 1.8 0.2 1.9 1.7 0.1 1.1 223.1 218.3 9.10 8.77 3 3.034 2062K 43K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.2 0.1 0.1 0.2 0.1 0.5 2.6 241.1 240.6 0.67 0.64 1 0.667 163K 289 0.0 0.0 L3 19/0 934.58 MB 0.9 1.6 0.6 0.9 1.5 0.6 0.0 2.5 227.7 227.0 6.98 6.66 5 1.396 1613K 4338 0.0 0.0 L4 122/0 9.67 GB 1.0 0.3 0.3 0.0 0.3 0.3 0.3 1.0 202.8 202.8 1.27 1.21 1 1.270 261K 0 0.0 0.0 L5 116/0 9.17 GB 0.1 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 286/29 24.87 GB 0.0 8.5 2.7 5.8 14.1 8.4 1.1 2.5 164.3 273.5 52.91 50.61 116 0.456 8827K 71K 0.0 0.0 Int 0/0 0.00 KB 0.0 8.5 2.7 5.8 14.1 8.4 1.1 2.5 164.3 273.5 52.91 50.61 116 0.456 8827K 71K 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 8.5 2.7 5.8 8.4 2.6 0.0 0.0 238.7 236.7 36.42 35.34 28 1.301 8827K 71K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 5.7 5.7 0.0 0.0 0.0 354.8 16.49 15.27 88 0.187 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 19.3 total, 19.2 interval Flush(GB): cumulative 5.713, interval 5.713 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 14.13 GB write, 750.91 MB/s write, 8.49 GB read, 451.05 MB/s read, 52.9 seconds Interval compaction: 14.13 GB write, 753.70 MB/s write, 8.49 GB read, 452.73 MB/s read, 52.9 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 11, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 11, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 8, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 11, total-stops: 8, interval: 19 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1659787 Average: 2.4184 StdDev: 8.03 Min: 0 Median: 1.5581 Max: 2461 Percentiles: P50: 1.56 P75: 1.94 P99: 6.65 P99.9: 14.72 P99.99: 154.63 ------------------------------------------------------ [ 0, 1 ] 227947 13.734% 13.734% ### ( 1, 2 ] 1078590 64.984% 78.717% ############# ( 2, 3 ] 229693 13.839% 92.556% ### ( 3, 4 ] 62925 3.791% 96.347% # ( 4, 6 ] 41794 2.518% 98.865% # ( 6, 10 ] 13848 0.834% 99.699% ( 10, 15 ] 3527 0.212% 99.912% ( 15, 22 ] 360 0.022% 99.934% ( 22, 34 ] 50 0.003% 99.937% ( 34, 51 ] 13 0.001% 99.937% ( 51, 76 ] 22 0.001% 99.939% ( 76, 110 ] 188 0.011% 99.950% ( 110, 170 ] 894 0.054% 100.004% ( 170, 250 ] 239 0.014% 100.018% ( 250, 380 ] 124 0.007% 100.026% ( 380, 580 ] 71 0.004% 100.030% ( 580, 870 ] 20 0.001% 100.031% ( 870, 1300 ] 25 0.002% 100.033% ( 1300, 1900 ] 2 0.000% 100.033% ( 1900, 2900 ] 2 0.000% 100.033% ** Level 1 read latency histogram (micros): Count: 174374 Average: 3.0869 StdDev: 12.72 Min: 1 Median: 1.8026 Max: 1998 Percentiles: P50: 1.80 P75: 2.58 P99: 9.30 P99.9: 132.72 P99.99: 240.08 ------------------------------------------------------ [ 0, 1 ] 7739 4.438% 4.438% # ( 1, 2 ] 98986 56.766% 61.205% ########### ( 2, 3 ] 41123 23.583% 84.788% ##### ( 3, 4 ] 11679 6.698% 91.486% # ( 4, 6 ] 10587 6.071% 97.557% # ( 6, 10 ] 3048 1.748% 99.305% ( 10, 15 ] 796 0.456% 99.761% ( 15, 22 ] 107 0.061% 99.823% ( 22, 34 ] 12 0.007% 99.830% ( 34, 51 ] 3 0.002% 99.831% ( 51, 76 ] 3 0.002% 99.833% ( 76, 110 ] 53 0.030% 99.864% ( 110, 170 ] 168 0.096% 99.960% ( 170, 250 ] 60 0.034% 99.994% ( 250, 380 ] 12 0.007% 100.001% ( 380, 580 ] 17 0.010% 100.011% ( 580, 870 ] 16 0.009% 100.020% ( 870, 1300 ] 3 0.002% 100.022% ( 1300, 1900 ] 1 0.001% 100.022% ( 1900, 2900 ] 1 0.001% 100.023% ** Level 2 read latency histogram (micros): Count: 65614 Average: 2.8696 StdDev: 14.07 Min: 0 Median: 1.5463 Max: 1148 Percentiles: P50: 1.55 P75: 1.95 P99: 9.25 P99.9: 166.90 P99.99: 622.40 ------------------------------------------------------ [ 0, 1 ] 10738 16.365% 16.365% ### ( 1, 2 ] 40399 61.571% 77.936% ############ ( 2, 3 ] 8220 12.528% 90.464% ### ( 3, 4 ] 2613 3.982% 94.446% # ( 4, 6 ] 2115 3.223% 97.670% # ( 6, 10 ] 1073 1.635% 99.305% ( 10, 15 ] 209 0.319% 99.624% ( 15, 22 ] 20 0.030% 99.654% ( 22, 34 ] 6 0.009% 99.663% ( 34, 51 ] 27 0.041% 99.704% ( 51, 76 ] 4 0.006% 99.710% ( 76, 110 ] 58 0.088% 99.799% ( 110, 170 ] 70 0.107% 99.906% ( 170, 250 ] 29 0.044% 99.950% ( 250, 380 ] 18 0.027% 99.977% ( 380, 580 ] 8 0.012% 99.989% ( 580, 870 ] 3 0.005% 99.994% ( 870, 1300 ] 4 0.006% 100.000% ** Level 3 read latency histogram (micros): Count: 307685 Average: 3.6760 StdDev: 49.82 Min: 0 Median: 1.7605 Max: 8721 Percentiles: P50: 1.76 P75: 2.51 P99: 9.87 P99.9: 185.58 P99.99: 420.20 ------------------------------------------------------ [ 0, 1 ] 12490 4.059% 4.059% # ( 1, 2 ] 185863 60.407% 64.466% ############ ( 2, 3 ] 63494 20.636% 85.102% #### ( 3, 4 ] 20070 6.523% 91.625% # ( 4, 6 ] 16038 5.212% 96.838% # ( 6, 10 ] 6875 2.234% 99.072% ( 10, 15 ] 1466 0.476% 99.549% ( 15, 22 ] 157 0.051% 99.600% ( 22, 34 ] 20 0.007% 99.606% ( 34, 51 ] 199 0.065% 99.671% ( 51, 76 ] 89 0.029% 99.700% ( 76, 110 ] 52 0.017% 99.717% ( 110, 170 ] 524 0.170% 99.887% ( 170, 250 ] 207 0.067% 99.954% ( 250, 380 ] 104 0.034% 99.988% ( 380, 580 ] 31 0.010% 99.998% ( 580, 870 ] 25 0.008% 100.006% ( 870, 1300 ] 3 0.001% 100.007% ( 1900, 2900 ] 3 0.001% 100.008% ( 2900, 4400 ] 3 0.001% 100.009% ( 4400, 6600 ] 9 0.003% 100.012% ( 6600, 9900 ] 6 0.002% 100.014% ** Level 4 read latency histogram (micros): Count: 55 Average: 1439.4909 StdDev: 2114.30 Min: 1 Median: 230.0000 Max: 7515 Percentiles: P50: 230.00 P75: 2525.00 P99: 7515.00 P99.9: 7515.00 P99.99: 7515.00 ------------------------------------------------------ [ 0, 1 ] 10 18.182% 18.182% #### ( 1, 2 ] 6 10.909% 29.091% ## ( 2, 3 ] 2 3.636% 32.727% # ( 34, 51 ] 2 3.636% 36.364% # ( 110, 170 ] 6 10.909% 47.273% ## ( 170, 250 ] 2 3.636% 50.909% # ( 250, 380 ] 3 5.455% 56.364% # ( 380, 580 ] 2 3.636% 60.000% # ( 580, 870 ] 1 1.818% 61.818% ( 870, 1300 ] 4 7.273% 69.091% # ( 1300, 1900 ] 2 3.636% 72.727% # ( 1900, 2900 ] 2 3.636% 76.364% # ( 2900, 4400 ] 6 10.909% 87.273% ## ( 4400, 6600 ] 5 9.091% 96.364% ## ( 6600, 9900 ] 2 3.636% 100.000% # ** Level 5 read latency histogram (micros): Count: 20 Average: 443.1500 StdDev: 524.36 Min: 105 Median: 196.6667 Max: 2261 Percentiles: P50: 196.67 P75: 580.00 P99: 2261.00 P99.9: 2261.00 P99.99: 2261.00 ------------------------------------------------------ ( 76, 110 ] 2 10.000% 10.000% ## ( 110, 170 ] 7 35.000% 45.000% ####### ( 170, 250 ] 3 15.000% 60.000% ### ( 250, 380 ] 2 10.000% 70.000% ## ( 380, 580 ] 1 5.000% 75.000% # ( 580, 870 ] 1 5.000% 80.000% # ( 870, 1300 ] 3 15.000% 95.000% ### ( 1900, 2900 ] 1 5.000% 100.000% # ** DB Stats ** Uptime(secs): 19.3 total, 3.7 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 306.41 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:2.495 H:M:S, 12.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 266.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.984 H:M:S, 26.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 0 using bdev Nvme0n1 Initializing RocksDB Options from the specified file Initializing RocksDB Options from command-line flags Integrated BlobDB: blob cache disabled Keys: 16 bytes each (+ 0 bytes user-defined timestamp) Values: 1000 bytes each (1000 bytes after compression) Entries: 20000000 Prefix: 0 bytes Keys per prefix: 0 RawSize: 19378.7 MB (estimated) FileSize: 19378.7 MB (estimated) Write rate: 0 bytes/second Read rate: 0 ops/second Compression: NoCompression Compression sampling rate: 0 Memtablerep: SkipListFactory Perf Level: 1 ------------------------------------------------ DB path: [/mnt/rocksdb] overwrite : 3.256 micros/op 307124 ops/sec 20.060 seconds 6160999 operations; 297.6 MB/s Microseconds per write: Count: 6160999 Average: 3.2560 StdDev: 163.78 Min: 0 Median: 1.7297 Max: 194197 Percentiles: P50: 1.73 P75: 2.96 P99: 7.19 P99.9: 126.77 P99.99: 1221.74 ------------------------------------------------------ [ 0, 1 ] 923052 14.982% 14.982% ### ( 1, 2 ] 2956503 47.987% 62.970% ########## ( 2, 3 ] 774015 12.563% 75.533% ### ( 3, 4 ] 859235 13.946% 89.479% ### ( 4, 6 ] 569512 9.244% 98.723% ## ( 6, 10 ] 57403 0.932% 99.655% ( 10, 15 ] 9304 0.151% 99.806% ( 15, 22 ] 2882 0.047% 99.852% ( 22, 34 ] 1121 0.018% 99.871% ( 34, 51 ] 163 0.003% 99.873% ( 51, 76 ] 22 0.000% 99.874% ( 76, 110 ] 6 0.000% 99.874% ( 110, 170 ] 5796 0.094% 99.968% ( 170, 250 ] 407 0.007% 99.974% ( 250, 380 ] 50 0.001% 99.975% ( 380, 580 ] 3 0.000% 99.975% ( 580, 870 ] 5 0.000% 99.975% ( 870, 1300 ] 1105 0.018% 99.993% ( 1900, 2900 ] 406 0.007% 100.000% ( 4400, 6600 ] 2 0.000% 100.000% ( 6600, 9900 ] 1 0.000% 100.000% ( 9900, 14000 ] 1 0.000% 100.000% ( 170000, 250000 ] 5 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 : 94303 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 : 6160999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 6358150968 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 : 190 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 2926841 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 : 9328461432 rocksdb.compact.write.bytes COUNT : 9229531970 rocksdb.flush.write.bytes COUNT : 6332129498 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 : 13 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 : 120 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 : 6290410496 rocksdb.memtable.garbage.bytes.at.flush COUNT : 10990592 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 : 9376633586 rocksdb.non.last.level.read.count COUNT : 2260106 rocksdb.block.checksum.compute.count COUNT : 2259739 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.376928 P95 : 4.525365 P99 : 5.955209 P100 : 194194.000000 COUNT : 6160999 SUM : 17426446 rocksdb.compaction.times.micros P50 : 1060000.000000 P95 : 3740000.000000 P99 : 5884000.000000 P100 : 6107692.000000 COUNT : 28 SUM : 36422193 rocksdb.compaction.times.cpu_micros P50 : 1048888.888889 P95 : 3740000.000000 P99 : 5849404.000000 P100 : 5849404.000000 COUNT : 28 SUM : 35340537 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 : 558.000000 P95 : 1131.000000 P99 : 1131.000000 P100 : 1131.000000 COUNT : 91 SUM : 59641 rocksdb.compaction.outfile.sync.micros P50 : 748.604651 P95 : 1257.000000 P99 : 1451.000000 P100 : 1451.000000 COUNT : 80 SUM : 61525 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 : 78.756757 P95 : 198.800000 P99 : 364.400000 P100 : 479.000000 COUNT : 124 SUM : 12118 rocksdb.table.open.io.micros P50 : 816.734694 P95 : 15090.909091 P99 : 19768.000000 P100 : 19768.000000 COUNT : 190 SUM : 420615 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.685759 P95 : 7.310996 P99 : 11.663125 P100 : 5546.000000 COUNT : 2259273 SUM : 10699762 rocksdb.read.block.get.micros P50 : 380.000000 P95 : 3650.000000 P99 : 7392.000000 P100 : 9021.000000 COUNT : 380 SUM : 297065 rocksdb.write.raw.block.micros P50 : 0.512583 P95 : 0.973908 P99 : 3.157605 P100 : 2751.000000 COUNT : 3769448 SUM : 7340761 rocksdb.numfiles.in.singlecompaction P50 : 3.477273 P95 : 9.133333 P99 : 29.000000 P100 : 29.000000 COUNT : 33 SUM : 162 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.554531 P95 : 1158.263587 P99 : 2532.561576 P100 : 194008.000000 COUNT : 15518 SUM : 2927477 rocksdb.sst.read.micros P50 : 1.596905 P95 : 3.941043 P99 : 8.091771 P100 : 8721.000000 COUNT : 2260266 SUM : 6098856 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 : 6160999 SUM : 6358150968 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 : 193571.428571 P95 : 281416.666667 P99 : 360283.333333 P100 : 361560.000000 COUNT : 91 SUM : 17021166 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 : 120 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