[2024-11-15 10:00:51.129232] Starting SPDK v25.01-pre git sha1 41bc9c125 / DPDK 24.03.0 initialization... [2024-11-15 10:00:51.129565] [ 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_pid804642 ] Set seed to 1731661251121977 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-11-15 10:00:51.278717] app.c: 919:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-11-15 10:00:51.380709] app.c: 612:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-11-15 10:00:51.380764] app.c: 613:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 804642' to capture a snapshot of events at runtime. [2024-11-15 10:00:51.380792] app.c: 618:app_setup_trace: *NOTICE*: 'spdk_trace' without parameters will also work if this is the only [2024-11-15 10:00:51.380806] app.c: 619:app_setup_trace: *NOTICE*: SPDK application currently running. [2024-11-15 10:00:51.380816] app.c: 620:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid804642 for offline analysis/debug. [2024-11-15 10:00:51.382018] reactor.c:1005:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Fri Nov 15 10:00:54 2024 CPU: 72 * Intel(R) Xeon(R) Gold 6140 CPU @ 2.30GHz CPUCache: 25344 KB 2024/11/15-10:00:57 ... thread 0: (1000000,1000000) ops and (323935.4,323935.4) ops/second in (3.087035,3.087035) 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 9/8 628.95 MB 12.6 0.0 0.0 0.0 0.9 0.9 0.0 1.0 0.0 340.5 2.59 2.40 13 0.199 0 0 0.0 0.0 L1 3/3 188.17 MB 0.0 0.2 0.2 0.0 0.2 0.2 0.1 1.0 242.2 241.4 0.78 0.76 1 0.779 191K 592 0.0 0.0 L2 1/1 100.06 MB 0.0 0.2 0.1 0.1 0.2 0.1 0.0 2.6 246.3 245.8 0.65 0.63 1 0.653 163K 325 0.0 0.0 L3 15/8 753.36 MB 0.1 0.1 0.1 0.0 0.1 0.1 0.0 1.0 227.3 227.4 0.27 0.25 1 0.266 61K 0 0.0 0.0 L4 116/0 9.41 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 116/0 9.04 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 260/20 20.09 GB 0.0 0.4 0.3 0.1 1.3 1.2 0.1 1.5 95.7 301.1 4.28 4.04 16 0.268 416K 917 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 95.7 301.1 4.28 4.04 16 0.268 416K 917 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 241.5 240.9 1.70 1.64 3 0.566 416K 917 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 340.5 2.59 2.40 13 0.199 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.2 total, 3.1 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, 409.04 MB/s write, 0.40 GB read, 130.04 MB/s read, 4.3 seconds Interval compaction: 1.26 GB write, 417.56 MB/s write, 0.40 GB read, 132.75 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: 3, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 3, interval: 3 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 106024 Average: 2.1002 StdDev: 6.21 Min: 1 Median: 1.4205 Max: 1229 Percentiles: P50: 1.42 P75: 1.82 P99: 5.83 P99.9: 13.55 P99.99: 257.38 ------------------------------------------------------ [ 0, 1 ] 25352 23.912% 23.912% ##### ( 1, 2 ] 65777 62.040% 85.951% ############ ( 2, 3 ] 9398 8.864% 94.815% ## ( 3, 4 ] 2879 2.715% 97.531% # ( 4, 6 ] 1708 1.611% 99.142% ( 6, 10 ] 667 0.629% 99.771% ( 10, 15 ] 197 0.186% 99.957% ( 15, 22 ] 20 0.019% 99.975% ( 22, 34 ] 4 0.004% 99.979% ( 34, 51 ] 1 0.001% 99.980% ( 76, 110 ] 1 0.001% 99.981% ( 170, 250 ] 12 0.011% 99.992% ( 250, 380 ] 7 0.007% 99.999% ( 380, 580 ] 6 0.006% 100.005% ( 870, 1300 ] 1 0.001% 100.006% ** Level 1 read latency histogram (micros): Count: 27213 Average: 2.3306 StdDev: 7.52 Min: 1 Median: 1.5813 Max: 1073 Percentiles: P50: 1.58 P75: 1.95 P99: 5.98 P99.9: 13.00 P99.99: 286.23 ------------------------------------------------------ [ 0, 1 ] 2756 10.128% 10.128% ## ( 1, 2 ] 18667 68.596% 78.723% ############## ( 2, 3 ] 3945 14.497% 93.220% ### ( 3, 4 ] 970 3.564% 96.785% # ( 4, 6 ] 609 2.238% 99.023% ( 6, 10 ] 214 0.786% 99.809% ( 10, 15 ] 43 0.158% 99.967% ( 15, 22 ] 4 0.015% 99.982% ( 22, 34 ] 1 0.004% 99.985% ( 34, 51 ] 1 0.004% 99.989% ( 170, 250 ] 1 0.004% 99.993% ( 250, 380 ] 1 0.004% 99.996% ( 380, 580 ] 1 0.004% 100.000% ( 870, 1300 ] 1 0.004% 100.004% ** Level 2 read latency histogram (micros): Count: 40482 Average: 2.8283 StdDev: 37.38 Min: 0 Median: 1.3929 Max: 4920 Percentiles: P50: 1.39 P75: 1.80 P99: 8.89 P99.9: 152.03 P99.99: 1279.27 ------------------------------------------------------ [ 0, 1 ] 10439 25.787% 25.787% ##### ( 1, 2 ] 24946 61.622% 87.409% ############ ( 2, 3 ] 2604 6.432% 93.842% # ( 3, 4 ] 981 2.423% 96.265% ( 4, 6 ] 784 1.937% 98.202% ( 6, 10 ] 447 1.104% 99.306% ( 10, 15 ] 124 0.306% 99.612% ( 15, 22 ] 14 0.035% 99.647% ( 22, 34 ] 1 0.002% 99.649% ( 34, 51 ] 22 0.054% 99.704% ( 51, 76 ] 8 0.020% 99.723% ( 76, 110 ] 47 0.116% 99.839% ( 110, 170 ] 35 0.086% 99.926% ( 170, 250 ] 15 0.037% 99.963% ( 250, 380 ] 7 0.017% 99.980% ( 380, 580 ] 2 0.005% 99.985% ( 580, 870 ] 1 0.002% 99.988% ( 870, 1300 ] 1 0.002% 99.990% ( 1900, 2900 ] 1 0.002% 99.993% ( 2900, 4400 ] 2 0.005% 99.998% ( 4400, 6600 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 83669 Average: 3.8503 StdDev: 67.32 Min: 1 Median: 1.5170 Max: 5983 Percentiles: P50: 1.52 P75: 1.89 P99: 9.41 P99.9: 160.25 P99.99: 3979.12 ------------------------------------------------------ [ 0, 1 ] 12504 14.945% 14.945% ### ( 1, 2 ] 56737 67.811% 82.756% ############## ( 2, 3 ] 7545 9.018% 91.774% ## ( 3, 4 ] 3099 3.704% 95.477% # ( 4, 6 ] 1671 1.997% 97.475% ( 6, 10 ] 1497 1.789% 99.264% ( 10, 15 ] 235 0.281% 99.545% ( 15, 22 ] 17 0.020% 99.565% ( 22, 34 ] 2 0.002% 99.567% ( 34, 51 ] 111 0.133% 99.700% ( 51, 76 ] 48 0.057% 99.757% ( 76, 110 ] 55 0.066% 99.823% ( 110, 170 ] 78 0.093% 99.916% ( 170, 250 ] 23 0.027% 99.944% ( 250, 380 ] 8 0.010% 99.953% ( 380, 580 ] 6 0.007% 99.961% ( 580, 870 ] 3 0.004% 99.964% ( 870, 1300 ] 1 0.001% 99.965% ( 1300, 1900 ] 1 0.001% 99.967% ( 1900, 2900 ] 12 0.014% 99.981% ( 2900, 4400 ] 12 0.014% 99.995% ( 4400, 6600 ] 5 0.006% 100.001% ** Level 4 read latency histogram (micros): Count: 30 Average: 2212.7000 StdDev: 1725.20 Min: 99 Median: 2066.6667 Max: 5810 Percentiles: P50: 2066.67 P75: 3650.00 P99: 5810.00 P99.9: 5810.00 P99.99: 5810.00 ------------------------------------------------------ ( 76, 110 ] 3 10.000% 10.000% ## ( 170, 250 ] 1 3.333% 13.333% # ( 250, 380 ] 4 13.333% 26.667% ### ( 380, 580 ] 1 3.333% 30.000% # ( 580, 870 ] 1 3.333% 33.333% # ( 870, 1300 ] 1 3.333% 36.667% # ( 1300, 1900 ] 3 10.000% 46.667% ## ( 1900, 2900 ] 6 20.000% 66.667% #### ( 2900, 4400 ] 5 16.667% 83.333% ### ( 4400, 6600 ] 5 16.667% 100.000% ### ** DB Stats ** Uptime(secs): 3.2 total, 3.1 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 312.10 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:0.200 H:M:S, 6.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 318.57 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.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/11/15-10:01:00 ... thread 0: (1000000,2000000) ops and (337451.6,330555.4) ops/second in (2.963388,6.050423) 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 11/4 1.29 GB 106.6 0.7 0.0 0.7 2.5 1.8 0.0 1.4 91.9 313.5 8.21 7.75 31 0.265 766K 3685 0.0 0.0 L1 1/0 49.95 MB 5.0 0.6 0.4 0.2 0.6 0.4 0.1 1.4 234.3 232.7 2.68 2.61 2 1.342 638K 4110 0.0 0.0 L2 1/1 128.78 MB 0.0 0.2 0.1 0.1 0.2 0.1 0.4 2.6 246.3 245.8 0.65 0.63 1 0.653 163K 325 0.0 0.0 L3 20/2 979.19 MB 0.9 1.1 0.4 0.7 1.1 0.4 0.0 2.8 241.4 240.8 4.85 4.60 4 1.212 1188K 3047 0.0 0.0 L4 120/0 9.54 GB 1.0 0.1 0.1 0.0 0.1 0.1 0.0 1.0 215.9 215.9 0.60 0.58 1 0.597 130K 0 0.0 0.0 L5 116/0 9.04 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 269/7 21.00 GB 0.0 2.8 1.0 1.8 4.5 2.8 0.4 2.6 167.3 274.0 16.99 16.16 39 0.436 2887K 11K 0.0 0.0 Int 0/0 0.00 KB 0.0 2.8 1.0 1.8 4.5 2.8 0.4 2.6 167.3 274.0 16.99 16.16 39 0.436 2887K 11K 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.8 1.0 1.8 2.8 1.0 0.0 0.0 241.5 240.6 11.77 11.35 11 1.070 2887K 11K 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 349.3 5.22 4.81 28 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): 6.1 total, 6.1 interval Flush(GB): cumulative 1.782, interval 1.782 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 4.55 GB write, 761.28 MB/s write, 2.78 GB read, 464.84 MB/s read, 17.0 seconds Interval compaction: 4.55 GB write, 769.38 MB/s write, 2.78 GB read, 469.79 MB/s read, 17.0 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 3, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 3, interval: 3 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 369095 Average: 2.4778 StdDev: 6.75 Min: 1 Median: 1.6204 Max: 1310 Percentiles: P50: 1.62 P75: 2.08 P99: 6.94 P99.9: 13.80 P99.99: 123.31 ------------------------------------------------------ [ 0, 1 ] 41520 11.249% 11.249% ## ( 1, 2 ] 230555 62.465% 73.714% ############ ( 2, 3 ] 58066 15.732% 89.446% ### ( 3, 4 ] 19909 5.394% 94.840% # ( 4, 6 ] 14543 3.940% 98.780% # ( 6, 10 ] 3450 0.935% 99.715% ( 10, 15 ] 898 0.243% 99.958% ( 15, 22 ] 79 0.021% 99.980% ( 22, 34 ] 16 0.004% 99.984% ( 34, 51 ] 4 0.001% 99.985% ( 51, 76 ] 1 0.000% 99.985% ( 76, 110 ] 4 0.001% 99.986% ( 110, 170 ] 59 0.016% 100.002% ( 170, 250 ] 46 0.012% 100.015% ( 250, 380 ] 28 0.008% 100.022% ( 380, 580 ] 19 0.005% 100.028% ( 580, 870 ] 2 0.001% 100.028% ( 870, 1300 ] 4 0.001% 100.029% ( 1300, 1900 ] 1 0.000% 100.030% ** Level 1 read latency histogram (micros): Count: 145870 Average: 2.9550 StdDev: 9.44 Min: 1 Median: 1.7595 Max: 1073 Percentiles: P50: 1.76 P75: 2.49 P99: 9.02 P99.9: 143.44 P99.99: 267.75 ------------------------------------------------------ [ 0, 1 ] 6220 4.264% 4.264% # ( 1, 2 ] 87838 60.217% 64.481% ############ ( 2, 3 ] 31446 21.558% 86.038% #### ( 3, 4 ] 9135 6.262% 92.301% # ( 4, 6 ] 7751 5.314% 97.614% # ( 6, 10 ] 2673 1.832% 99.447% ( 10, 15 ] 484 0.332% 99.779% ( 15, 22 ] 85 0.058% 99.837% ( 22, 34 ] 13 0.009% 99.846% ( 34, 51 ] 2 0.001% 99.847% ( 76, 110 ] 3 0.002% 99.849% ( 110, 170 ] 133 0.091% 99.940% ( 170, 250 ] 69 0.047% 99.988% ( 250, 380 ] 25 0.017% 100.005% ( 380, 580 ] 10 0.007% 100.012% ( 580, 870 ] 4 0.003% 100.014% ( 870, 1300 ] 1 0.001% 100.015% ** Level 2 read latency histogram (micros): Count: 65636 Average: 2.8501 StdDev: 29.54 Min: 0 Median: 1.5426 Max: 4920 Percentiles: P50: 1.54 P75: 1.96 P99: 9.00 P99.9: 132.48 P99.99: 523.64 ------------------------------------------------------ [ 0, 1 ] 11584 17.649% 17.649% #### ( 1, 2 ] 39137 59.627% 77.276% ############ ( 2, 3 ] 7710 11.747% 89.023% ## ( 3, 4 ] 3064 4.668% 93.691% # ( 4, 6 ] 2644 4.028% 97.719% # ( 6, 10 ] 1119 1.705% 99.424% ( 10, 15 ] 202 0.308% 99.732% ( 15, 22 ] 17 0.026% 99.758% ( 22, 34 ] 1 0.002% 99.759% ( 34, 51 ] 22 0.034% 99.793% ( 51, 76 ] 8 0.012% 99.805% ( 76, 110 ] 47 0.072% 99.877% ( 110, 170 ] 41 0.062% 99.939% ( 170, 250 ] 21 0.032% 99.971% ( 250, 380 ] 11 0.017% 99.988% ( 380, 580 ] 2 0.003% 99.991% ( 580, 870 ] 1 0.002% 99.992% ( 870, 1300 ] 1 0.002% 99.994% ( 1900, 2900 ] 1 0.002% 99.995% ( 2900, 4400 ] 2 0.003% 99.998% ( 4400, 6600 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 234384 Average: 3.4075 StdDev: 41.42 Min: 0 Median: 1.6225 Max: 5983 Percentiles: P50: 1.62 P75: 2.04 P99: 9.22 P99.9: 177.89 P99.99: 539.72 ------------------------------------------------------ [ 0, 1 ] 22771 9.715% 9.715% ## ( 1, 2 ] 151686 64.717% 74.432% ############# ( 2, 3 ] 34212 14.597% 89.029% ### ( 3, 4 ] 12131 5.176% 94.204% # ( 4, 6 ] 7968 3.400% 97.604% # ( 6, 10 ] 4065 1.734% 99.338% ( 10, 15 ] 531 0.227% 99.565% ( 15, 22 ] 39 0.017% 99.581% ( 22, 34 ] 5 0.002% 99.584% ( 34, 51 ] 183 0.078% 99.662% ( 51, 76 ] 92 0.039% 99.701% ( 76, 110 ] 100 0.043% 99.744% ( 110, 170 ] 355 0.151% 99.895% ( 170, 250 ] 128 0.055% 99.950% ( 250, 380 ] 74 0.032% 99.981% ( 380, 580 ] 27 0.012% 99.993% ( 580, 870 ] 8 0.003% 99.996% ( 870, 1300 ] 1 0.000% 99.997% ( 1300, 1900 ] 1 0.000% 99.997% ( 1900, 2900 ] 12 0.005% 100.002% ( 2900, 4400 ] 12 0.005% 100.007% ( 4400, 6600 ] 5 0.002% 100.009% ** Level 4 read latency histogram (micros): Count: 50 Average: 1355.9400 StdDev: 1700.15 Min: 1 Median: 302.0000 Max: 5810 Percentiles: P50: 302.00 P75: 2483.33 P99: 5810.00 P99.9: 5810.00 P99.99: 5810.00 ------------------------------------------------------ [ 0, 1 ] 6 12.000% 12.000% ## ( 1, 2 ] 5 10.000% 22.000% ## ( 2, 3 ] 1 2.000% 24.000% ( 22, 34 ] 1 2.000% 26.000% ( 76, 110 ] 3 6.000% 32.000% # ( 110, 170 ] 4 8.000% 40.000% ## ( 170, 250 ] 3 6.000% 46.000% # ( 250, 380 ] 5 10.000% 56.000% ## ( 380, 580 ] 1 2.000% 58.000% ( 580, 870 ] 1 2.000% 60.000% ( 870, 1300 ] 1 2.000% 62.000% ( 1300, 1900 ] 3 6.000% 68.000% # ( 1900, 2900 ] 6 12.000% 80.000% ## ( 2900, 4400 ] 5 10.000% 90.000% ## ( 4400, 6600 ] 5 10.000% 100.000% ## ** DB Stats ** Uptime(secs): 6.1 total, 3.0 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 321.80 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:0.200 H:M:S, 3.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 332.13 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: 2 num-running-flushes: 1 2024/11/15-10:01:03 ... thread 0: (1000000,3000000) ops and (346898.2,335829.2) ops/second in (2.882690,8.933113) 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 15/4 2.26 GB 206.7 1.7 0.0 1.7 4.5 2.8 0.0 1.6 118.2 307.5 14.91 14.14 51 0.292 1788K 8538 0.0 0.0 L1 1/0 49.95 MB 5.0 0.6 0.4 0.2 0.6 0.4 0.1 1.4 234.3 232.7 2.68 2.61 2 1.342 638K 4110 0.0 0.0 L2 0/0 0.00 KB 0.0 0.2 0.1 0.1 0.2 0.1 0.4 2.6 246.3 245.8 0.65 0.63 1 0.653 163K 325 0.0 0.0 L3 17/0 744.41 MB 0.7 1.3 0.5 0.8 1.3 0.5 0.0 2.5 239.4 238.8 5.65 5.38 5 1.131 1374K 3463 0.0 0.0 L4 123/0 9.58 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.3 1.0 221.1 221.1 1.06 1.03 2 0.530 238K 0 0.0 0.0 L5 120/0 9.35 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 276/4 21.98 GB 0.0 4.0 1.3 2.8 6.8 4.0 1.0 2.5 165.9 278.6 24.96 23.78 61 0.409 4203K 16K 0.0 0.0 Int 0/0 0.00 KB 0.0 4.0 1.3 2.8 6.8 4.0 1.0 2.5 165.9 278.6 24.96 23.78 61 0.409 4203K 16K 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.0 1.3 2.8 4.0 1.2 0.0 0.0 244.1 243.1 16.96 16.39 17 0.998 4203K 16K 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 354.0 8.00 7.39 44 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): 9.0 total, 8.9 interval Flush(GB): cumulative 2.765, interval 2.765 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.79 GB write, 772.69 MB/s write, 4.04 GB read, 459.94 MB/s read, 25.0 seconds Interval compaction: 6.79 GB write, 778.26 MB/s write, 4.04 GB read, 463.25 MB/s read, 25.0 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 3, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 3, interval: 3 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 612892 Average: 2.3207 StdDev: 6.36 Min: 0 Median: 1.5469 Max: 1310 Percentiles: P50: 1.55 P75: 1.94 P99: 6.04 P99.9: 13.34 P99.99: 46.62 ------------------------------------------------------ [ 0, 1 ] 93560 15.265% 15.265% ### ( 1, 2 ] 389290 63.517% 78.782% ############# ( 2, 3 ] 79497 12.971% 91.753% ### ( 3, 4 ] 26565 4.334% 96.087% # ( 4, 6 ] 17799 2.904% 98.992% # ( 6, 10 ] 4734 0.772% 99.764% ( 10, 15 ] 1249 0.204% 99.968% ( 15, 22 ] 111 0.018% 99.986% ( 22, 34 ] 22 0.004% 99.989% ( 34, 51 ] 5 0.001% 99.990% ( 51, 76 ] 1 0.000% 99.990% ( 76, 110 ] 4 0.001% 99.991% ( 110, 170 ] 59 0.010% 100.001% ( 170, 250 ] 62 0.010% 100.011% ( 250, 380 ] 38 0.006% 100.017% ( 380, 580 ] 27 0.004% 100.021% ( 580, 870 ] 5 0.001% 100.022% ( 870, 1300 ] 7 0.001% 100.023% ( 1300, 1900 ] 1 0.000% 100.023% ** Level 1 read latency histogram (micros): Count: 145870 Average: 2.9550 StdDev: 9.44 Min: 1 Median: 1.7595 Max: 1073 Percentiles: P50: 1.76 P75: 2.49 P99: 9.02 P99.9: 143.44 P99.99: 267.75 ------------------------------------------------------ [ 0, 1 ] 6220 4.264% 4.264% # ( 1, 2 ] 87838 60.217% 64.481% ############ ( 2, 3 ] 31446 21.558% 86.038% #### ( 3, 4 ] 9135 6.262% 92.301% # ( 4, 6 ] 7751 5.314% 97.614% # ( 6, 10 ] 2673 1.832% 99.447% ( 10, 15 ] 484 0.332% 99.779% ( 15, 22 ] 85 0.058% 99.837% ( 22, 34 ] 13 0.009% 99.846% ( 34, 51 ] 2 0.001% 99.847% ( 76, 110 ] 3 0.002% 99.849% ( 110, 170 ] 133 0.091% 99.940% ( 170, 250 ] 69 0.047% 99.988% ( 250, 380 ] 25 0.017% 100.005% ( 380, 580 ] 10 0.007% 100.012% ( 580, 870 ] 4 0.003% 100.014% ( 870, 1300 ] 1 0.001% 100.015% ** Level 2 read latency histogram (micros): Count: 65636 Average: 2.8501 StdDev: 29.54 Min: 0 Median: 1.5426 Max: 4920 Percentiles: P50: 1.54 P75: 1.96 P99: 9.00 P99.9: 132.48 P99.99: 523.64 ------------------------------------------------------ [ 0, 1 ] 11584 17.649% 17.649% #### ( 1, 2 ] 39137 59.627% 77.276% ############ ( 2, 3 ] 7710 11.747% 89.023% ## ( 3, 4 ] 3064 4.668% 93.691% # ( 4, 6 ] 2644 4.028% 97.719% # ( 6, 10 ] 1119 1.705% 99.424% ( 10, 15 ] 202 0.308% 99.732% ( 15, 22 ] 17 0.026% 99.758% ( 22, 34 ] 1 0.002% 99.759% ( 34, 51 ] 22 0.034% 99.793% ( 51, 76 ] 8 0.012% 99.805% ( 76, 110 ] 47 0.072% 99.877% ( 110, 170 ] 41 0.062% 99.939% ( 170, 250 ] 21 0.032% 99.971% ( 250, 380 ] 11 0.017% 99.988% ( 380, 580 ] 2 0.003% 99.991% ( 580, 870 ] 1 0.002% 99.992% ( 870, 1300 ] 1 0.002% 99.994% ( 1900, 2900 ] 1 0.002% 99.995% ( 2900, 4400 ] 2 0.003% 99.998% ( 4400, 6600 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 264545 Average: 3.3057 StdDev: 39.02 Min: 0 Median: 1.6321 Max: 5983 Percentiles: P50: 1.63 P75: 2.08 P99: 9.05 P99.9: 167.56 P99.99: 521.69 ------------------------------------------------------ [ 0, 1 ] 24316 9.192% 9.192% ## ( 1, 2 ] 170783 64.557% 73.749% ############# ( 2, 3 ] 40758 15.407% 89.156% ### ( 3, 4 ] 13597 5.140% 94.295% # ( 4, 6 ] 9152 3.460% 97.755% # ( 6, 10 ] 4320 1.633% 99.388% ( 10, 15 ] 587 0.222% 99.610% ( 15, 22 ] 43 0.016% 99.626% ( 22, 34 ] 6 0.002% 99.628% ( 34, 51 ] 184 0.070% 99.698% ( 51, 76 ] 92 0.035% 99.733% ( 76, 110 ] 100 0.038% 99.771% ( 110, 170 ] 357 0.135% 99.905% ( 170, 250 ] 128 0.048% 99.954% ( 250, 380 ] 75 0.028% 99.982% ( 380, 580 ] 29 0.011% 99.993% ( 580, 870 ] 8 0.003% 99.996% ( 870, 1300 ] 1 0.000% 99.997% ( 1300, 1900 ] 1 0.000% 99.997% ( 1900, 2900 ] 12 0.005% 100.002% ( 2900, 4400 ] 12 0.005% 100.006% ( 4400, 6600 ] 5 0.002% 100.008% ** Level 4 read latency histogram (micros): Count: 65 Average: 1058.0923 StdDev: 1587.88 Min: 0 Median: 165.0000 Max: 5810 Percentiles: P50: 165.00 P75: 1850.00 P99: 5810.00 P99.9: 5810.00 P99.99: 5810.00 ------------------------------------------------------ [ 0, 1 ] 13 20.000% 20.000% #### ( 1, 2 ] 6 9.231% 29.231% ## ( 2, 3 ] 2 3.077% 32.308% # ( 10, 15 ] 1 1.538% 33.846% ( 22, 34 ] 1 1.538% 35.385% ( 76, 110 ] 4 6.154% 41.538% # ( 110, 170 ] 6 9.231% 50.769% ## ( 170, 250 ] 3 4.615% 55.385% # ( 250, 380 ] 7 10.769% 66.154% ## ( 380, 580 ] 1 1.538% 67.692% ( 580, 870 ] 1 1.538% 69.231% ( 870, 1300 ] 1 1.538% 70.769% ( 1300, 1900 ] 3 4.615% 75.385% # ( 1900, 2900 ] 6 9.231% 84.615% ## ( 2900, 4400 ] 5 7.692% 92.308% ## ( 4400, 6600 ] 5 7.692% 100.000% ## ** Level 5 read latency histogram (micros): Count: 20 Average: 419.4000 StdDev: 450.17 Min: 124 Median: 170.0000 Max: 1838 Percentiles: P50: 170.00 P75: 380.00 P99: 1780.00 P99.9: 1838.00 P99.99: 1838.00 ------------------------------------------------------ ( 110, 170 ] 10 50.000% 50.000% ########## ( 170, 250 ] 2 10.000% 60.000% ## ( 250, 380 ] 3 15.000% 75.000% ### ( 580, 870 ] 1 5.000% 80.000% # ( 870, 1300 ] 3 15.000% 95.000% ### ( 1300, 1900 ] 1 5.000% 100.000% # ** DB Stats ** Uptime(secs): 9.0 total, 2.9 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 328.08 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, 2.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 341.41 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/11/15-10:01:06 ... thread 0: (1000000,4000000) ops and (341050.5,337119.5) ops/second in (2.932117,11.865230) 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.18 GB 300.6 2.7 0.0 2.7 6.4 3.7 0.0 1.7 130.2 307.0 21.27 20.26 70 0.304 2811K 13K 0.0 0.0 L1 1/0 49.95 MB 5.0 0.6 0.4 0.2 0.6 0.4 0.1 1.4 234.3 232.7 2.68 2.61 2 1.342 638K 4110 0.0 0.0 L2 0/0 0.00 KB 0.0 0.2 0.1 0.1 0.2 0.1 0.4 2.6 246.3 245.8 0.65 0.63 1 0.653 163K 325 0.0 0.0 L3 17/0 744.41 MB 0.7 1.3 0.5 0.8 1.3 0.5 0.0 2.5 239.4 238.8 5.65 5.38 5 1.131 1374K 3463 0.0 0.0 L4 123/0 9.58 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.3 1.0 221.1 221.1 1.06 1.03 2 0.530 238K 0 0.0 0.0 L5 120/0 9.35 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 279/4 22.89 GB 0.0 5.0 1.3 3.8 8.7 4.9 1.0 2.4 164.3 284.1 31.32 29.90 80 0.391 5225K 21K 0.0 0.0 Int 0/0 0.00 KB 0.0 5.0 1.3 3.8 8.7 4.9 1.0 2.4 164.3 284.1 31.32 29.90 80 0.391 5225K 21K 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.0 1.3 3.8 5.0 1.2 0.0 0.0 247.5 246.4 20.79 20.16 21 0.990 5225K 21K 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 358.6 10.53 9.74 59 0.178 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.9 interval Flush(GB): cumulative 3.686, interval 3.686 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 8.69 GB write, 745.84 MB/s write, 5.03 GB read, 431.28 MB/s read, 31.3 seconds Interval compaction: 8.69 GB write, 749.88 MB/s write, 5.03 GB read, 433.62 MB/s read, 31.3 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 1, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 1, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 3, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 1, total-stops: 3, interval: 4 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 863217 Average: 2.2341 StdDev: 6.27 Min: 0 Median: 1.5058 Max: 1315 Percentiles: P50: 1.51 P75: 1.90 P99: 5.90 P99.9: 13.08 P99.99: 32.15 ------------------------------------------------------ [ 0, 1 ] 152138 17.625% 17.625% #### ( 1, 2 ] 552564 64.012% 81.637% ############# ( 2, 3 ] 98379 11.397% 93.034% ## ( 3, 4 ] 32323 3.744% 96.778% # ( 4, 6 ] 20177 2.337% 99.115% ( 6, 10 ] 5785 0.670% 99.786% ( 10, 15 ] 1604 0.186% 99.971% ( 15, 22 ] 137 0.016% 99.987% ( 22, 34 ] 28 0.003% 99.991% ( 34, 51 ] 5 0.001% 99.991% ( 51, 76 ] 4 0.000% 99.992% ( 76, 110 ] 5 0.001% 99.992% ( 110, 170 ] 59 0.007% 99.999% ( 170, 250 ] 77 0.009% 100.008% ( 250, 380 ] 48 0.006% 100.013% ( 380, 580 ] 32 0.004% 100.017% ( 580, 870 ] 9 0.001% 100.018% ( 870, 1300 ] 10 0.001% 100.019% ( 1300, 1900 ] 2 0.000% 100.020% ** Level 1 read latency histogram (micros): Count: 145870 Average: 2.9550 StdDev: 9.44 Min: 1 Median: 1.7595 Max: 1073 Percentiles: P50: 1.76 P75: 2.49 P99: 9.02 P99.9: 143.44 P99.99: 267.75 ------------------------------------------------------ [ 0, 1 ] 6220 4.264% 4.264% # ( 1, 2 ] 87838 60.217% 64.481% ############ ( 2, 3 ] 31446 21.558% 86.038% #### ( 3, 4 ] 9135 6.262% 92.301% # ( 4, 6 ] 7751 5.314% 97.614% # ( 6, 10 ] 2673 1.832% 99.447% ( 10, 15 ] 484 0.332% 99.779% ( 15, 22 ] 85 0.058% 99.837% ( 22, 34 ] 13 0.009% 99.846% ( 34, 51 ] 2 0.001% 99.847% ( 76, 110 ] 3 0.002% 99.849% ( 110, 170 ] 133 0.091% 99.940% ( 170, 250 ] 69 0.047% 99.988% ( 250, 380 ] 25 0.017% 100.005% ( 380, 580 ] 10 0.007% 100.012% ( 580, 870 ] 4 0.003% 100.014% ( 870, 1300 ] 1 0.001% 100.015% ** Level 2 read latency histogram (micros): Count: 65636 Average: 2.8501 StdDev: 29.54 Min: 0 Median: 1.5426 Max: 4920 Percentiles: P50: 1.54 P75: 1.96 P99: 9.00 P99.9: 132.48 P99.99: 523.64 ------------------------------------------------------ [ 0, 1 ] 11584 17.649% 17.649% #### ( 1, 2 ] 39137 59.627% 77.276% ############ ( 2, 3 ] 7710 11.747% 89.023% ## ( 3, 4 ] 3064 4.668% 93.691% # ( 4, 6 ] 2644 4.028% 97.719% # ( 6, 10 ] 1119 1.705% 99.424% ( 10, 15 ] 202 0.308% 99.732% ( 15, 22 ] 17 0.026% 99.758% ( 22, 34 ] 1 0.002% 99.759% ( 34, 51 ] 22 0.034% 99.793% ( 51, 76 ] 8 0.012% 99.805% ( 76, 110 ] 47 0.072% 99.877% ( 110, 170 ] 41 0.062% 99.939% ( 170, 250 ] 21 0.032% 99.971% ( 250, 380 ] 11 0.017% 99.988% ( 380, 580 ] 2 0.003% 99.991% ( 580, 870 ] 1 0.002% 99.992% ( 870, 1300 ] 1 0.002% 99.994% ( 1900, 2900 ] 1 0.002% 99.995% ( 2900, 4400 ] 2 0.003% 99.998% ( 4400, 6600 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 264545 Average: 3.3057 StdDev: 39.02 Min: 0 Median: 1.6321 Max: 5983 Percentiles: P50: 1.63 P75: 2.08 P99: 9.05 P99.9: 167.56 P99.99: 521.69 ------------------------------------------------------ [ 0, 1 ] 24316 9.192% 9.192% ## ( 1, 2 ] 170783 64.557% 73.749% ############# ( 2, 3 ] 40758 15.407% 89.156% ### ( 3, 4 ] 13597 5.140% 94.295% # ( 4, 6 ] 9152 3.460% 97.755% # ( 6, 10 ] 4320 1.633% 99.388% ( 10, 15 ] 587 0.222% 99.610% ( 15, 22 ] 43 0.016% 99.626% ( 22, 34 ] 6 0.002% 99.628% ( 34, 51 ] 184 0.070% 99.698% ( 51, 76 ] 92 0.035% 99.733% ( 76, 110 ] 100 0.038% 99.771% ( 110, 170 ] 357 0.135% 99.905% ( 170, 250 ] 128 0.048% 99.954% ( 250, 380 ] 75 0.028% 99.982% ( 380, 580 ] 29 0.011% 99.993% ( 580, 870 ] 8 0.003% 99.996% ( 870, 1300 ] 1 0.000% 99.997% ( 1300, 1900 ] 1 0.000% 99.997% ( 1900, 2900 ] 12 0.005% 100.002% ( 2900, 4400 ] 12 0.005% 100.006% ( 4400, 6600 ] 5 0.002% 100.008% ** Level 4 read latency histogram (micros): Count: 65 Average: 1058.0923 StdDev: 1587.88 Min: 0 Median: 165.0000 Max: 5810 Percentiles: P50: 165.00 P75: 1850.00 P99: 5810.00 P99.9: 5810.00 P99.99: 5810.00 ------------------------------------------------------ [ 0, 1 ] 13 20.000% 20.000% #### ( 1, 2 ] 6 9.231% 29.231% ## ( 2, 3 ] 2 3.077% 32.308% # ( 10, 15 ] 1 1.538% 33.846% ( 22, 34 ] 1 1.538% 35.385% ( 76, 110 ] 4 6.154% 41.538% # ( 110, 170 ] 6 9.231% 50.769% ## ( 170, 250 ] 3 4.615% 55.385% # ( 250, 380 ] 7 10.769% 66.154% ## ( 380, 580 ] 1 1.538% 67.692% ( 580, 870 ] 1 1.538% 69.231% ( 870, 1300 ] 1 1.538% 70.769% ( 1300, 1900 ] 3 4.615% 75.385% # ( 1900, 2900 ] 6 9.231% 84.615% ## ( 2900, 4400 ] 5 7.692% 92.308% ## ( 4400, 6600 ] 5 7.692% 100.000% ## ** Level 5 read latency histogram (micros): Count: 20 Average: 419.4000 StdDev: 450.17 Min: 124 Median: 170.0000 Max: 1838 Percentiles: P50: 170.00 P75: 380.00 P99: 1780.00 P99.9: 1838.00 P99.99: 1838.00 ------------------------------------------------------ ( 110, 170 ] 10 50.000% 50.000% ########## ( 170, 250 ] 2 10.000% 60.000% ## ( 250, 380 ] 3 15.000% 75.000% ### ( 580, 870 ] 1 5.000% 80.000% # ( 870, 1300 ] 3 15.000% 95.000% ### ( 1300, 1900 ] 1 5.000% 100.000% # ** DB Stats ** Uptime(secs): 11.9 total, 2.9 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 329.94 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:0.257 H:M:S, 2.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 335.66 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.057 H:M:S, 2.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 using bdev Nvme0n1 Initializing RocksDB Options from the specified file Initializing RocksDB Options from command-line flags Integrated BlobDB: blob cache disabled Keys: 16 bytes each (+ 0 bytes user-defined timestamp) Values: 1000 bytes each (1000 bytes after compression) Entries: 20000000 Prefix: 0 bytes Keys per prefix: 0 RawSize: 19378.7 MB (estimated) FileSize: 19378.7 MB (estimated) Write rate: 0 bytes/second Read rate: 0 ops/second Compression: NoCompression Compression sampling rate: 0 Memtablerep: SkipListFactory Perf Level: 1 ------------------------------------------------ DB path: [/mnt/rocksdb] overwrite : 4.328 micros/op 231055 ops/sec 20.090 seconds 4641999 operations; 223.9 MB/s Microseconds per write: Count: 4641999 Average: 4.3279 StdDev: 92.20 Min: 1 Median: 1.8036 Max: 169356 Percentiles: P50: 1.80 P75: 3.11 P99: 9.20 P99.9: 879.62 P99.99: 2461.18 ------------------------------------------------------ [ 0, 1 ] 524815 11.306% 11.306% ## ( 1, 2 ] 2235145 48.150% 59.456% ########## ( 2, 3 ] 649877 14.000% 73.456% ### ( 3, 4 ] 643986 13.873% 87.329% ### ( 4, 6 ] 484727 10.442% 97.771% ## ( 6, 10 ] 71222 1.534% 99.306% ( 10, 15 ] 16383 0.353% 99.659% ( 15, 22 ] 4924 0.106% 99.765% ( 22, 34 ] 1256 0.027% 99.792% ( 34, 51 ] 187 0.004% 99.796% ( 51, 76 ] 31 0.001% 99.797% ( 76, 110 ] 4 0.000% 99.797% ( 110, 170 ] 4286 0.092% 99.889% ( 170, 250 ] 313 0.007% 99.896% ( 250, 380 ] 102 0.002% 99.898% ( 380, 580 ] 11 0.000% 99.898% ( 580, 870 ] 6 0.000% 99.898% ( 870, 1300 ] 3666 0.079% 99.977% ( 1300, 1900 ] 4 0.000% 99.977% ( 1900, 2900 ] 1051 0.023% 100.000% ( 22000, 33000 ] 2 0.000% 100.000% ( 110000, 170000 ] 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 : 166027 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 : 4641999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 4790542968 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 : 152 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 6355634 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 : 7985584714 rocksdb.compact.write.bytes COUNT : 7822854804 rocksdb.flush.write.bytes COUNT : 4749836771 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 : 14 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 : 89 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 : 4717783040 rocksdb.memtable.garbage.bytes.at.flush COUNT : 7518208 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 : 8024822261 rocksdb.non.last.level.read.count COUNT : 1937165 rocksdb.block.checksum.compute.count COUNT : 1936875 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.456432 P95 : 4.890074 P99 : 8.052144 P100 : 169354.000000 COUNT : 4641999 SUM : 17848238 rocksdb.compaction.times.micros P50 : 957142.857143 P95 : 2700000.000000 P99 : 3030854.000000 P100 : 3030854.000000 COUNT : 24 SUM : 23714159 rocksdb.compaction.times.cpu_micros P50 : 957142.857143 P95 : 1760000.000000 P99 : 2921370.000000 P100 : 2921370.000000 COUNT : 24 SUM : 23042566 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 : 531.282051 P95 : 1250.159091 P99 : 1439.000000 P100 : 1439.000000 COUNT : 71 SUM : 44436 rocksdb.compaction.outfile.sync.micros P50 : 683.571429 P95 : 1187.892857 P99 : 1277.578571 P100 : 1298.000000 COUNT : 73 SUM : 51237 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 : 75.038462 P95 : 186.000000 P99 : 250.000000 P100 : 342.000000 COUNT : 100 SUM : 9275 rocksdb.table.open.io.micros P50 : 774.512195 P95 : 15244.444444 P99 : 16998.000000 P100 : 16998.000000 COUNT : 152 SUM : 329902 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.555080 P95 : 6.329978 P99 : 10.098505 P100 : 948.000000 COUNT : 1936518 SUM : 8701217 rocksdb.read.block.get.micros P50 : 353.235294 P95 : 3750.000000 P99 : 5931.200000 P100 : 5937.000000 COUNT : 304 SUM : 221980 rocksdb.write.raw.block.micros P50 : 0.511937 P95 : 0.972680 P99 : 2.977147 P100 : 2814.000000 COUNT : 3045564 SUM : 5742634 rocksdb.numfiles.in.singlecompaction P50 : 3.343750 P95 : 9.100000 P99 : 18.000000 P100 : 18.000000 COUNT : 29 SUM : 122 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.568326 P95 : 1191.574387 P99 : 2525.423406 P100 : 169155.000000 COUNT : 39568 SUM : 6360587 rocksdb.sst.read.micros P50 : 1.495317 P95 : 3.617001 P99 : 7.057383 P100 : 5983.000000 COUNT : 1937339 SUM : 4810756 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 : 4641999 SUM : 4790542968 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 : 175555.555556 P95 : 246555.555556 P99 : 333850.000000 P100 : 340433.000000 COUNT : 71 SUM : 12622257 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 : 92 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