[2024-11-17 20:50:55.911488] Starting SPDK v24.09.1-pre git sha1 b18e1bd62 / DPDK 22.11.4 initialization... [2024-11-17 20:50:55.911636] [ 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_pid1214019 ] Set seed to 1731873055908003 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-11-17 20:50:55.997980] app.c: 917:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-11-17 20:50:56.039431] app.c: 610:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-11-17 20:50:56.039480] app.c: 611:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 1214019' to capture a snapshot of events at runtime. [2024-11-17 20:50:56.039490] app.c: 616:app_setup_trace: *NOTICE*: 'spdk_trace' without parameters will also work if this is the only [2024-11-17 20:50:56.039506] app.c: 617:app_setup_trace: *NOTICE*: SPDK application currently running. [2024-11-17 20:50:56.039514] app.c: 618:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid1214019 for offline analysis/debug. [2024-11-17 20:50:56.039603] reactor.c: 990:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Sun Nov 17 20:51:00 2024 CPU: 96 * Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz CPUCache: 36608 KB 2024/11/17-20:51:08 ... thread 0: (1000000,1000000) ops and (130278.7,130278.7) ops/second in (7.675853,7.675853) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 7/4 629.92 MB 25.2 0.0 0.0 0.0 0.8 0.8 0.0 1.0 0.0 117.0 7.00 2.40 9 0.777 0 0 0.0 0.0 L1 2/2 122.51 MB 0.0 0.3 0.2 0.1 0.3 0.2 0.0 1.4 123.9 123.8 2.45 1.32 2 1.223 307K 134 0.0 0.0 L2 3/0 208.49 MB 2.1 0.2 0.1 0.1 0.2 0.1 0.0 2.2 111.5 111.4 1.81 0.95 1 1.810 204K 280 0.0 0.0 L3 47/8 3.92 GB 3.3 3.5 2.6 0.9 3.4 2.5 0.1 1.3 102.0 100.7 34.82 16.60 18 1.934 2158K 0 0.0 0.0 L4 196/16 12.16 GB 1.2 3.4 2.3 1.1 3.3 2.2 0.3 1.5 113.2 111.9 30.55 16.23 24 1.273 1961K 0 0.0 0.0 L5 1096/0 90.18 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1351/30 107.20 GB 0.0 7.3 5.1 2.2 8.1 5.9 0.5 10.1 98.1 107.6 76.62 37.51 54 1.419 4633K 414 0.0 0.0 Int 0/0 0.00 KB 0.0 7.3 5.1 2.2 8.1 5.9 0.5 10.1 98.1 107.6 76.62 37.51 54 1.419 4633K 414 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.3 5.1 2.2 7.3 5.1 0.0 0.0 107.9 106.7 69.62 35.10 45 1.547 4633K 414 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 0.8 0.8 0.0 0.0 0.0 117.0 7.00 2.40 9 0.777 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): 7.9 total, 7.7 interval Flush(GB): cumulative 0.800, interval 0.800 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.05 GB write, 1045.68 MB/s write, 7.34 GB read, 952.64 MB/s read, 76.6 seconds Interval compaction: 8.05 GB write, 1074.33 MB/s write, 7.34 GB read, 978.75 MB/s read, 76.6 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 30, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 30, interval: 30 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 106744 Average: 9.6484 StdDev: 132.77 Min: 1 Median: 1.8529 Max: 8115 Percentiles: P50: 1.85 P75: 2.79 P99: 9.74 P99.9: 1907.11 P99.99: 5301.26 ------------------------------------------------------ [ 0, 1 ] 4142 3.880% 3.880% # ( 1, 2 ] 57721 54.074% 57.955% ########### ( 2, 3 ] 23023 21.568% 79.523% #### ( 3, 4 ] 9813 9.193% 88.716% ## ( 4, 6 ] 9311 8.723% 97.439% ## ( 6, 10 ] 1783 1.670% 99.109% ( 10, 15 ] 367 0.344% 99.453% ( 15, 22 ] 44 0.041% 99.494% ( 22, 34 ] 4 0.004% 99.498% ( 34, 51 ] 3 0.003% 99.501% ( 76, 110 ] 1 0.001% 99.502% ( 110, 170 ] 7 0.007% 99.508% ( 170, 250 ] 19 0.018% 99.526% ( 250, 380 ] 34 0.032% 99.558% ( 380, 580 ] 78 0.073% 99.631% ( 580, 870 ] 116 0.109% 99.740% ( 870, 1300 ] 105 0.098% 99.838% ( 1300, 1900 ] 67 0.063% 99.901% ( 1900, 2900 ] 36 0.034% 99.934% ( 2900, 4400 ] 55 0.052% 99.986% ( 4400, 6600 ] 13 0.012% 99.998% ( 6600, 9900 ] 5 0.005% 100.003% ** Level 1 read latency histogram (micros): Count: 51941 Average: 9.5371 StdDev: 132.05 Min: 1 Median: 1.9012 Max: 6448 Percentiles: P50: 1.90 P75: 2.86 P99: 9.78 P99.9: 2402.27 P99.99: 4967.57 ------------------------------------------------------ [ 0, 1 ] 1385 2.666% 2.666% # ( 1, 2 ] 27281 52.523% 55.190% ########### ( 2, 3 ] 12033 23.167% 78.356% ##### ( 3, 4 ] 5123 9.863% 88.219% ## ( 4, 6 ] 4770 9.183% 97.403% ## ( 6, 10 ] 879 1.692% 99.095% ( 10, 15 ] 224 0.431% 99.526% ( 15, 22 ] 27 0.052% 99.578% ( 22, 34 ] 5 0.010% 99.588% ( 51, 76 ] 1 0.002% 99.590% ( 76, 110 ] 3 0.006% 99.596% ( 110, 170 ] 2 0.004% 99.600% ( 170, 250 ] 5 0.010% 99.609% ( 250, 380 ] 6 0.012% 99.621% ( 380, 580 ] 19 0.037% 99.657% ( 580, 870 ] 42 0.081% 99.738% ( 870, 1300 ] 42 0.081% 99.819% ( 1300, 1900 ] 29 0.056% 99.875% ( 1900, 2900 ] 26 0.050% 99.925% ( 2900, 4400 ] 32 0.062% 99.987% ( 4400, 6600 ] 7 0.013% 100.000% ** Level 2 read latency histogram (micros): Count: 588243 Average: 14.5679 StdDev: 182.37 Min: 1 Median: 1.9971 Max: 11512 Percentiles: P50: 2.00 P75: 3.03 P99: 11.62 P99.9: 1408.72 P99.99: 2058.38 ------------------------------------------------------ [ 0, 1 ] 12825 2.180% 2.180% ( 1, 2 ] 282104 47.957% 50.137% ########## ( 2, 3 ] 144483 24.562% 74.699% ##### ( 3, 4 ] 63482 10.792% 85.491% ## ( 4, 6 ] 61950 10.531% 96.022% ## ( 6, 10 ] 16342 2.778% 98.800% # ( 10, 15 ] 3634 0.618% 99.418% ( 15, 22 ] 543 0.092% 99.510% ( 22, 34 ] 94 0.016% 99.526% ( 34, 51 ] 55 0.009% 99.536% ( 51, 76 ] 39 0.007% 99.542% ( 76, 110 ] 26 0.004% 99.547% ( 110, 170 ] 53 0.009% 99.556% ( 170, 250 ] 113 0.019% 99.575% ( 250, 380 ] 229 0.039% 99.614% ( 380, 580 ] 361 0.061% 99.675% ( 580, 870 ] 573 0.097% 99.773% ( 870, 1300 ] 652 0.111% 99.884% ( 1300, 1900 ] 534 0.091% 99.974% ( 1900, 2900 ] 582 0.099% 100.073% ( 2900, 4400 ] 581 0.099% 100.172% ( 4400, 6600 ] 181 0.031% 100.203% ( 6600, 9900 ] 27 0.005% 100.207% ( 9900, 14000 ] 1 0.000% 100.208% ** Level 3 read latency histogram (micros): Count: 799512 Average: 12.0782 StdDev: 160.07 Min: 0 Median: 1.9835 Max: 9306 Percentiles: P50: 1.98 P75: 2.97 P99: 9.88 P99.9: 834.05 P99.99: 1200.79 ------------------------------------------------------ [ 0, 1 ] 13862 1.734% 1.734% ( 1, 2 ] 392361 49.075% 50.809% ########## ( 2, 3 ] 199316 24.930% 75.739% ##### ( 3, 4 ] 86050 10.763% 86.501% ## ( 4, 6 ] 81095 10.143% 96.644% ## ( 6, 10 ] 19407 2.427% 99.072% ( 10, 15 ] 4310 0.539% 99.611% ( 15, 22 ] 617 0.077% 99.688% ( 22, 34 ] 79 0.010% 99.698% ( 34, 51 ] 48 0.006% 99.704% ( 51, 76 ] 65 0.008% 99.712% ( 76, 110 ] 31 0.004% 99.716% ( 110, 170 ] 64 0.008% 99.724% ( 170, 250 ] 119 0.015% 99.739% ( 250, 380 ] 214 0.027% 99.766% ( 380, 580 ] 444 0.056% 99.821% ( 580, 870 ] 722 0.090% 99.911% ( 870, 1300 ] 819 0.102% 100.014% ( 1300, 1900 ] 572 0.072% 100.085% ( 1900, 2900 ] 559 0.070% 100.155% ( 2900, 4400 ] 629 0.079% 100.234% ( 4400, 6600 ] 196 0.025% 100.259% ( 6600, 9900 ] 28 0.004% 100.262% ** Level 4 read latency histogram (micros): Count: 319734 Average: 25.9820 StdDev: 254.85 Min: 1 Median: 1.9715 Max: 9416 Percentiles: P50: 1.97 P75: 2.97 P99: 580.25 P99.9: 3301.69 P99.99: 4032.05 ------------------------------------------------------ [ 0, 1 ] 5973 1.868% 1.868% ( 1, 2 ] 158405 49.543% 51.411% ########## ( 2, 3 ] 77805 24.334% 75.745% ##### ( 3, 4 ] 33147 10.367% 86.112% ## ( 4, 6 ] 30234 9.456% 95.568% ## ( 6, 10 ] 8048 2.517% 98.085% # ( 10, 15 ] 1644 0.514% 98.599% ( 15, 22 ] 224 0.070% 98.670% ( 22, 34 ] 22 0.007% 98.676% ( 34, 51 ] 19 0.006% 98.682% ( 51, 76 ] 19 0.006% 98.688% ( 76, 110 ] 11 0.003% 98.692% ( 110, 170 ] 63 0.020% 98.711% ( 170, 250 ] 152 0.048% 98.759% ( 250, 380 ] 247 0.077% 98.836% ( 380, 580 ] 525 0.164% 99.000% ( 580, 870 ] 749 0.234% 99.235% ( 870, 1300 ] 887 0.277% 99.512% ( 1300, 1900 ] 580 0.181% 99.693% ( 1900, 2900 ] 504 0.158% 99.851% ( 2900, 4400 ] 591 0.185% 100.036% ( 4400, 6600 ] 207 0.065% 100.101% ( 6600, 9900 ] 37 0.012% 100.112% ** Level 5 read latency histogram (micros): Count: 12302 Average: 1821.1902 StdDev: 1586.08 Min: 80 Median: 1214.0405 Max: 14084 Percentiles: P50: 1214.04 P75: 2691.31 P99: 7472.48 P99.9: 9829.70 P99.99: 13882.02 ------------------------------------------------------ ( 76, 110 ] 24 0.195% 0.195% ( 110, 170 ] 122 0.992% 1.187% ( 170, 250 ] 275 2.235% 3.422% ( 250, 380 ] 687 5.584% 9.007% # ( 380, 580 ] 1349 10.966% 19.972% ## ( 580, 870 ] 1997 16.233% 36.205% ### ( 870, 1300 ] 2121 17.241% 53.447% ### ( 1300, 1900 ] 1550 12.600% 66.046% ### ( 1900, 2900 ] 1392 11.315% 77.361% ## ( 2900, 4400 ] 1802 14.648% 92.009% ### ( 4400, 6600 ] 819 6.657% 98.667% # ( 6600, 9900 ] 155 1.260% 99.927% ( 9900, 14000 ] 8 0.065% 99.992% ( 14000, 22000 ] 1 0.008% 100.000% ** DB Stats ** Uptime(secs): 7.9 total, 7.7 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 124.77 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:3.723 H:M:S, 47.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 128.17 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:3.723 H:M:S, 48.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 10 num-running-flushes: 1 2024/11/17-20:51:15 ... thread 0: (1000000,2000000) ops and (134630.7,132418.9) ops/second in (7.427727,15.103580) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 12/12 1.29 GB 0.0 0.3 0.0 0.3 2.2 1.8 0.0 1.2 18.9 131.9 16.71 6.77 22 0.759 319K 374 0.0 0.0 L1 5/5 499.39 MB 0.0 0.8 0.6 0.2 0.8 0.6 0.0 1.4 121.7 121.5 6.60 3.56 3 2.201 815K 1151 0.0 0.0 L2 2/0 81.75 MB 0.8 0.2 0.1 0.1 0.2 0.1 0.0 2.2 111.5 111.4 1.81 0.95 1 1.810 204K 280 0.0 0.0 L3 14/0 953.25 MB 1.0 3.5 2.6 0.9 3.4 2.5 0.2 1.3 102.0 100.7 34.82 16.60 18 1.934 2158K 0 0.0 0.0 L4 171/0 9.54 GB 1.0 10.0 5.1 4.9 9.8 4.9 0.6 1.9 120.6 118.5 84.69 47.65 50 1.694 4220K 8558 0.0 0.0 L5 1164/0 95.78 GB 1.0 0.0 0.0 0.0 0.0 0.0 5.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1368/17 108.11 GB 0.0 14.7 8.4 6.4 16.4 10.0 6.4 8.9 104.3 115.8 144.62 75.54 94 1.539 7720K 10K 0.0 0.0 Int 0/0 0.00 KB 0.0 14.7 8.4 6.4 16.4 10.0 6.4 8.9 104.3 115.8 144.62 75.54 94 1.539 7720K 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 14.7 8.4 6.4 14.5 8.2 0.0 0.0 115.9 114.1 130.19 70.05 73 1.783 7720K 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 130.9 14.43 5.49 21 0.687 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.3 total, 15.1 interval Flush(GB): cumulative 1.845, interval 1.845 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 16.36 GB write, 1093.67 MB/s write, 14.73 GB read, 985.09 MB/s read, 144.6 seconds Interval compaction: 16.36 GB write, 1108.90 MB/s write, 14.73 GB read, 998.81 MB/s read, 144.6 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 69, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 69, interval: 69 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 419095 Average: 10.3345 StdDev: 125.72 Min: 1 Median: 1.8123 Max: 10241 Percentiles: P50: 1.81 P75: 2.71 P99: 12.41 P99.9: 1565.69 P99.99: 3424.04 ------------------------------------------------------ [ 0, 1 ] 21469 5.123% 5.123% # ( 1, 2 ] 231541 55.248% 60.371% ########### ( 2, 3 ] 85801 20.473% 80.843% #### ( 3, 4 ] 35480 8.466% 89.309% ## ( 4, 6 ] 32780 7.822% 97.131% ## ( 6, 10 ] 7212 1.721% 98.852% ( 10, 15 ] 1291 0.308% 99.160% ( 15, 22 ] 137 0.033% 99.193% ( 22, 34 ] 9 0.002% 99.195% ( 34, 51 ] 13 0.003% 99.198% ( 51, 76 ] 14 0.003% 99.201% ( 76, 110 ] 80 0.019% 99.220% ( 110, 170 ] 423 0.101% 99.321% ( 170, 250 ] 347 0.083% 99.404% ( 250, 380 ] 307 0.073% 99.477% ( 380, 580 ] 521 0.124% 99.602% ( 580, 870 ] 626 0.149% 99.751% ( 870, 1300 ] 510 0.122% 99.873% ( 1300, 1900 ] 264 0.063% 99.936% ( 1900, 2900 ] 170 0.041% 99.976% ( 2900, 4400 ] 172 0.041% 100.017% ( 4400, 6600 ] 47 0.011% 100.028% ( 6600, 9900 ] 9 0.002% 100.031% ( 9900, 14000 ] 1 0.000% 100.031% ** Level 1 read latency histogram (micros): Count: 138443 Average: 10.0749 StdDev: 138.01 Min: 1 Median: 1.8963 Max: 9765 Percentiles: P50: 1.90 P75: 2.86 P99: 10.63 P99.9: 1890.27 P99.99: 5789.27 ------------------------------------------------------ [ 0, 1 ] 3617 2.613% 2.613% # ( 1, 2 ] 73196 52.871% 55.483% ########### ( 2, 3 ] 31242 22.567% 78.050% ##### ( 3, 4 ] 13145 9.495% 87.545% ## ( 4, 6 ] 12721 9.189% 96.734% ## ( 6, 10 ] 3065 2.214% 98.948% ( 10, 15 ] 577 0.417% 99.364% ( 15, 22 ] 64 0.046% 99.411% ( 22, 34 ] 8 0.006% 99.416% ( 34, 51 ] 3 0.002% 99.419% ( 51, 76 ] 4 0.003% 99.421% ( 76, 110 ] 10 0.007% 99.429% ( 110, 170 ] 40 0.029% 99.458% ( 170, 250 ] 39 0.028% 99.486% ( 250, 380 ] 68 0.049% 99.535% ( 380, 580 ] 125 0.090% 99.625% ( 580, 870 ] 163 0.118% 99.743% ( 870, 1300 ] 130 0.094% 99.837% ( 1300, 1900 ] 89 0.064% 99.901% ( 1900, 2900 ] 44 0.032% 99.933% ( 2900, 4400 ] 64 0.046% 99.979% ( 4400, 6600 ] 24 0.017% 99.996% ( 6600, 9900 ] 5 0.004% 100.000% ** Level 2 read latency histogram (micros): Count: 646367 Average: 14.2081 StdDev: 179.52 Min: 1 Median: 1.9984 Max: 11512 Percentiles: P50: 2.00 P75: 3.03 P99: 11.61 P99.9: 1443.39 P99.99: 2165.16 ------------------------------------------------------ [ 0, 1 ] 13475 2.085% 2.085% ( 1, 2 ] 310208 47.993% 50.077% ########## ( 2, 3 ] 159186 24.628% 74.705% ##### ( 3, 4 ] 69728 10.788% 85.493% ## ( 4, 6 ] 67984 10.518% 96.011% ## ( 6, 10 ] 18057 2.794% 98.804% # ( 10, 15 ] 3938 0.609% 99.413% ( 15, 22 ] 583 0.090% 99.504% ( 22, 34 ] 96 0.015% 99.519% ( 34, 51 ] 58 0.009% 99.528% ( 51, 76 ] 45 0.007% 99.534% ( 76, 110 ] 29 0.004% 99.539% ( 110, 170 ] 66 0.010% 99.549% ( 170, 250 ] 128 0.020% 99.569% ( 250, 380 ] 257 0.040% 99.609% ( 380, 580 ] 402 0.062% 99.671% ( 580, 870 ] 643 0.099% 99.770% ( 870, 1300 ] 705 0.109% 99.879% ( 1300, 1900 ] 555 0.086% 99.965% ( 1900, 2900 ] 601 0.093% 100.058% ( 2900, 4400 ] 622 0.096% 100.155% ( 4400, 6600 ] 191 0.030% 100.184% ( 6600, 9900 ] 30 0.005% 100.189% ( 9900, 14000 ] 1 0.000% 100.189% ** Level 3 read latency histogram (micros): Count: 1459617 Average: 11.0831 StdDev: 150.77 Min: 0 Median: 1.9798 Max: 13439 Percentiles: P50: 1.98 P75: 2.97 P99: 9.77 P99.9: 759.06 P99.99: 1108.77 ------------------------------------------------------ [ 0, 1 ] 24406 1.672% 1.672% ( 1, 2 ] 719916 49.322% 50.994% ########## ( 2, 3 ] 361446 24.763% 75.757% ##### ( 3, 4 ] 155529 10.655% 86.413% ## ( 4, 6 ] 148704 10.188% 96.601% ## ( 6, 10 ] 37188 2.548% 99.149% # ( 10, 15 ] 7307 0.501% 99.649% ( 15, 22 ] 1037 0.071% 99.720% ( 22, 34 ] 97 0.007% 99.727% ( 34, 51 ] 104 0.007% 99.734% ( 51, 76 ] 133 0.009% 99.743% ( 76, 110 ] 44 0.003% 99.746% ( 110, 170 ] 107 0.007% 99.753% ( 170, 250 ] 194 0.013% 99.767% ( 250, 380 ] 369 0.025% 99.792% ( 380, 580 ] 770 0.053% 99.845% ( 580, 870 ] 1306 0.089% 99.934% ( 870, 1300 ] 1466 0.100% 100.035% ( 1300, 1900 ] 926 0.063% 100.098% ( 1900, 2900 ] 830 0.057% 100.155% ( 2900, 4400 ] 974 0.067% 100.222% ( 4400, 6600 ] 319 0.022% 100.244% ( 6600, 9900 ] 47 0.003% 100.247% ( 9900, 14000 ] 2 0.000% 100.247% ** Level 4 read latency histogram (micros): Count: 1245287 Average: 17.2422 StdDev: 195.01 Min: 1 Median: 1.9666 Max: 15229 Percentiles: P50: 1.97 P75: 2.95 P99: 13.87 P99.9: 1309.41 P99.99: 1794.93 ------------------------------------------------------ [ 0, 1 ] 20880 1.677% 1.677% ( 1, 2 ] 622566 49.994% 51.670% ########## ( 2, 3 ] 305272 24.514% 76.185% ##### ( 3, 4 ] 128858 10.348% 86.532% ## ( 4, 6 ] 119528 9.598% 96.131% ## ( 6, 10 ] 31262 2.510% 98.641% # ( 10, 15 ] 5775 0.464% 99.105% ( 15, 22 ] 706 0.057% 99.162% ( 22, 34 ] 51 0.004% 99.166% ( 34, 51 ] 100 0.008% 99.174% ( 51, 76 ] 115 0.009% 99.183% ( 76, 110 ] 129 0.010% 99.193% ( 110, 170 ] 450 0.036% 99.229% ( 170, 250 ] 702 0.056% 99.286% ( 250, 380 ] 939 0.075% 99.361% ( 380, 580 ] 1796 0.144% 99.505% ( 580, 870 ] 2442 0.196% 99.702% ( 870, 1300 ] 2449 0.197% 99.898% ( 1300, 1900 ] 1385 0.111% 100.009% ( 1900, 2900 ] 1070 0.086% 100.095% ( 2900, 4400 ] 1326 0.106% 100.202% ( 4400, 6600 ] 410 0.033% 100.235% ( 6600, 9900 ] 80 0.006% 100.241% ( 9900, 14000 ] 8 0.001% 100.242% ( 14000, 22000 ] 2 0.000% 100.242% ** Level 5 read latency histogram (micros): Count: 34865 Average: 1277.5771 StdDev: 1335.44 Min: 78 Median: 813.0069 Max: 19044 Percentiles: P50: 813.01 P75: 1566.51 P99: 6359.33 P99.9: 9654.73 P99.99: 17027.00 ------------------------------------------------------ ( 76, 110 ] 510 1.463% 1.463% ( 110, 170 ] 1956 5.610% 7.073% # ( 170, 250 ] 1997 5.728% 12.801% # ( 250, 380 ] 2879 8.258% 21.058% ## ( 380, 580 ] 4884 14.008% 35.067% ### ( 580, 870 ] 6480 18.586% 53.653% #### ( 870, 1300 ] 5921 16.983% 70.635% ### ( 1300, 1900 ] 3426 9.826% 80.462% ## ( 1900, 2900 ] 2455 7.041% 87.503% # ( 2900, 4400 ] 2961 8.493% 95.996% ## ( 4400, 6600 ] 1176 3.373% 99.369% # ( 6600, 9900 ] 200 0.574% 99.943% ( 9900, 14000 ] 15 0.043% 99.986% ( 14000, 22000 ] 4 0.011% 99.997% ** DB Stats ** Uptime(secs): 15.3 total, 7.4 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 128.52 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:7.209 H:M:S, 47.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 132.50 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:3.486 H:M:S, 46.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/11/17-20:51:18 ... thread 0: (1000000,3000000) ops and (283645.1,161038.3) ops/second in (3.525533,18.629113) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 12/8 1.66 GB 119.5 1.5 0.0 1.5 4.3 2.8 0.0 1.5 61.2 178.3 24.72 14.13 42 0.589 1535K 1809 0.0 0.0 L1 10/0 1.10 GB 112.4 1.9 1.2 0.7 1.9 1.2 0.0 1.6 137.8 137.4 14.02 8.87 4 3.506 1962K 5710 0.0 0.0 L2 2/0 81.75 MB 0.8 0.2 0.1 0.1 0.2 0.1 0.0 2.2 111.5 111.4 1.81 0.95 1 1.810 204K 280 0.0 0.0 L3 14/0 953.25 MB 1.0 3.5 2.6 0.9 3.4 2.5 0.2 1.3 102.0 100.7 34.82 16.60 18 1.934 2158K 0 0.0 0.0 L4 171/0 9.54 GB 1.0 10.0 5.1 4.9 9.8 4.9 0.6 1.9 120.6 118.5 84.69 47.65 50 1.694 4220K 8558 0.0 0.0 L5 1164/0 95.78 GB 1.0 0.0 0.0 0.0 0.0 0.0 5.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1373/8 109.09 GB 0.0 17.0 9.0 8.0 19.6 11.6 6.4 6.9 108.8 125.4 160.06 88.21 115 1.392 10M 16K 0.0 0.0 Int 0/0 0.00 KB 0.0 17.0 9.0 8.0 19.6 11.6 6.4 6.9 108.8 125.4 160.06 88.21 115 1.392 10M 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 17.0 9.0 8.0 16.8 8.8 0.0 0.0 122.3 120.6 142.41 79.94 78 1.826 10M 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 164.2 17.65 8.27 37 0.477 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 18.8 total, 18.6 interval Flush(GB): cumulative 2.830, interval 2.830 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 19.61 GB write, 1065.63 MB/s write, 17.00 GB read, 924.20 MB/s read, 160.1 seconds Interval compaction: 19.61 GB write, 1077.66 MB/s write, 17.00 GB read, 934.63 MB/s read, 160.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: 69, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 69, interval: 69 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 763106 Average: 7.9640 StdDev: 95.84 Min: 0 Median: 1.6591 Max: 10241 Percentiles: P50: 1.66 P75: 2.30 P99: 17.40 P99.9: 948.24 P99.99: 1806.32 ------------------------------------------------------ [ 0, 1 ] 85861 11.252% 11.252% ## ( 1, 2 ] 448642 58.792% 70.043% ############ ( 2, 3 ] 124724 16.344% 86.387% ### ( 3, 4 ] 46010 6.029% 92.417% # ( 4, 6 ] 38902 5.098% 97.514% # ( 6, 10 ] 9474 1.242% 98.756% ( 10, 15 ] 1788 0.234% 98.990% ( 15, 22 ] 216 0.028% 99.019% ( 22, 34 ] 17 0.002% 99.021% ( 34, 51 ] 14 0.002% 99.023% ( 51, 76 ] 17 0.002% 99.025% ( 76, 110 ] 518 0.068% 99.093% ( 110, 170 ] 2101 0.275% 99.368% ( 170, 250 ] 1352 0.177% 99.545% ( 250, 380 ] 859 0.113% 99.658% ( 380, 580 ] 959 0.126% 99.784% ( 580, 870 ] 787 0.103% 99.887% ( 870, 1300 ] 560 0.073% 99.960% ( 1300, 1900 ] 271 0.036% 99.996% ( 1900, 2900 ] 173 0.023% 100.018% ( 2900, 4400 ] 172 0.023% 100.041% ( 4400, 6600 ] 47 0.006% 100.047% ( 6600, 9900 ] 9 0.001% 100.048% ( 9900, 14000 ] 1 0.000% 100.048% ** Level 1 read latency histogram (micros): Count: 205010 Average: 8.6278 StdDev: 115.20 Min: 1 Median: 1.8222 Max: 9765 Percentiles: P50: 1.82 P75: 2.71 P99: 13.58 P99.9: 1446.60 P99.99: 5087.41 ------------------------------------------------------ [ 0, 1 ] 8550 4.171% 4.171% # ( 1, 2 ] 114277 55.742% 59.913% ########### ( 2, 3 ] 43731 21.331% 81.244% #### ( 3, 4 ] 16354 7.977% 89.221% ## ( 4, 6 ] 15101 7.366% 96.587% # ( 6, 10 ] 4408 2.150% 98.737% ( 10, 15 ] 753 0.367% 99.104% ( 15, 22 ] 101 0.049% 99.154% ( 22, 34 ] 13 0.006% 99.160% ( 34, 51 ] 4 0.002% 99.162% ( 51, 76 ] 5 0.002% 99.164% ( 76, 110 ] 129 0.063% 99.227% ( 110, 170 ] 428 0.209% 99.436% ( 170, 250 ] 211 0.103% 99.539% ( 250, 380 ] 177 0.086% 99.625% ( 380, 580 ] 202 0.099% 99.724% ( 580, 870 ] 200 0.098% 99.821% ( 870, 1300 ] 139 0.068% 99.889% ( 1300, 1900 ] 90 0.044% 99.933% ( 1900, 2900 ] 44 0.021% 99.955% ( 2900, 4400 ] 65 0.032% 99.986% ( 4400, 6600 ] 24 0.012% 99.998% ( 6600, 9900 ] 5 0.002% 100.000% ** Level 2 read latency histogram (micros): Count: 646591 Average: 14.2830 StdDev: 179.55 Min: 1 Median: 1.9988 Max: 11512 Percentiles: P50: 2.00 P75: 3.03 P99: 11.89 P99.9: 1443.14 P99.99: 2165.13 ------------------------------------------------------ [ 0, 1 ] 13475 2.084% 2.084% ( 1, 2 ] 310208 47.976% 50.060% ########## ( 2, 3 ] 159186 24.619% 74.679% ##### ( 3, 4 ] 69728 10.784% 85.463% ## ( 4, 6 ] 67984 10.514% 95.977% ## ( 6, 10 ] 18057 2.793% 98.770% # ( 10, 15 ] 3938 0.609% 99.379% ( 15, 22 ] 583 0.090% 99.469% ( 22, 34 ] 96 0.015% 99.484% ( 34, 51 ] 58 0.009% 99.493% ( 51, 76 ] 45 0.007% 99.500% ( 76, 110 ] 53 0.008% 99.508% ( 110, 170 ] 155 0.024% 99.532% ( 170, 250 ] 170 0.026% 99.558% ( 250, 380 ] 291 0.045% 99.603% ( 380, 580 ] 429 0.066% 99.670% ( 580, 870 ] 651 0.101% 99.770% ( 870, 1300 ] 705 0.109% 99.880% ( 1300, 1900 ] 555 0.086% 99.965% ( 1900, 2900 ] 601 0.093% 100.058% ( 2900, 4400 ] 622 0.096% 100.155% ( 4400, 6600 ] 191 0.030% 100.184% ( 6600, 9900 ] 30 0.005% 100.189% ( 9900, 14000 ] 1 0.000% 100.189% ** Level 3 read latency histogram (micros): Count: 1460421 Average: 11.1982 StdDev: 150.84 Min: 0 Median: 1.9804 Max: 13439 Percentiles: P50: 1.98 P75: 2.97 P99: 9.85 P99.9: 761.62 P99.99: 1109.14 ------------------------------------------------------ [ 0, 1 ] 24406 1.671% 1.671% ( 1, 2 ] 719916 49.295% 50.966% ########## ( 2, 3 ] 361446 24.749% 75.716% ##### ( 3, 4 ] 155529 10.650% 86.365% ## ( 4, 6 ] 148704 10.182% 96.548% ## ( 6, 10 ] 37188 2.546% 99.094% # ( 10, 15 ] 7307 0.500% 99.594% ( 15, 22 ] 1037 0.071% 99.665% ( 22, 34 ] 97 0.007% 99.672% ( 34, 51 ] 104 0.007% 99.679% ( 51, 76 ] 133 0.009% 99.688% ( 76, 110 ] 135 0.009% 99.697% ( 110, 170 ] 445 0.030% 99.728% ( 170, 250 ] 364 0.025% 99.753% ( 250, 380 ] 469 0.032% 99.785% ( 380, 580 ] 847 0.058% 99.843% ( 580, 870 ] 1331 0.091% 99.934% ( 870, 1300 ] 1469 0.101% 100.035% ( 1300, 1900 ] 926 0.063% 100.098% ( 1900, 2900 ] 830 0.057% 100.155% ( 2900, 4400 ] 974 0.067% 100.222% ( 4400, 6600 ] 319 0.022% 100.243% ( 6600, 9900 ] 47 0.003% 100.247% ( 9900, 14000 ] 2 0.000% 100.247% ** Level 4 read latency histogram (micros): Count: 1252689 Average: 18.3608 StdDev: 195.44 Min: 1 Median: 1.9724 Max: 15229 Percentiles: P50: 1.97 P75: 2.97 P99: 176.56 P99.9: 1308.35 P99.99: 1796.06 ------------------------------------------------------ [ 0, 1 ] 20880 1.667% 1.667% ( 1, 2 ] 622627 49.703% 51.370% ########## ( 2, 3 ] 305511 24.388% 75.758% ##### ( 3, 4 ] 129000 10.298% 86.056% ## ( 4, 6 ] 119737 9.558% 95.615% ## ( 6, 10 ] 31293 2.498% 98.113% ( 10, 15 ] 5788 0.462% 98.575% ( 15, 22 ] 707 0.056% 98.631% ( 22, 34 ] 51 0.004% 98.635% ( 34, 51 ] 100 0.008% 98.643% ( 51, 76 ] 115 0.009% 98.652% ( 76, 110 ] 920 0.073% 98.726% ( 110, 170 ] 3258 0.260% 98.986% ( 170, 250 ] 2135 0.170% 99.156% ( 250, 380 ] 1661 0.133% 99.289% ( 380, 580 ] 2433 0.194% 99.483% ( 580, 870 ] 2706 0.216% 99.699% ( 870, 1300 ] 2495 0.199% 99.898% ( 1300, 1900 ] 1387 0.111% 100.009% ( 1900, 2900 ] 1071 0.085% 100.095% ( 2900, 4400 ] 1328 0.106% 100.201% ( 4400, 6600 ] 410 0.033% 100.233% ( 6600, 9900 ] 80 0.006% 100.240% ( 9900, 14000 ] 8 0.001% 100.240% ( 14000, 22000 ] 2 0.000% 100.241% ** Level 5 read latency histogram (micros): Count: 75420 Average: 712.9826 StdDev: 1055.44 Min: 77 Median: 300.9767 Max: 19044 Percentiles: P50: 300.98 P75: 785.85 P99: 5596.90 P99.9: 8952.57 P99.99: 12758.52 ------------------------------------------------------ ( 76, 110 ] 5343 7.084% 7.084% # ( 110, 170 ] 18688 24.779% 31.863% ##### ( 170, 250 ] 10720 14.214% 46.077% ### ( 250, 380 ] 7546 10.005% 56.082% ## ( 380, 580 ] 8578 11.374% 67.456% ## ( 580, 870 ] 8016 10.628% 78.084% ## ( 870, 1300 ] 6232 8.263% 86.347% ## ( 1300, 1900 ] 3468 4.598% 90.945% # ( 1900, 2900 ] 2471 3.276% 94.222% # ( 2900, 4400 ] 2964 3.930% 98.152% # ( 4400, 6600 ] 1176 1.559% 99.711% ( 6600, 9900 ] 200 0.265% 99.976% ( 9900, 14000 ] 15 0.020% 99.996% ( 14000, 22000 ] 4 0.005% 100.001% ** DB Stats ** Uptime(secs): 18.8 total, 3.5 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 156.71 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:7.209 H:M:S, 38.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 279.15 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: 0 2024/11/17-20:51:22 ... thread 0: (1000000,4000000) ops and (293115.9,181482.2) ops/second in (3.411620,22.040733) 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.58 GB 239.1 2.5 0.0 2.5 6.2 3.7 0.0 1.7 80.0 201.8 31.51 20.48 61 0.517 2558K 2751 0.0 0.0 L1 10/0 1.10 GB 112.4 1.9 1.2 0.7 1.9 1.2 0.0 1.6 137.8 137.4 14.02 8.87 4 3.506 1962K 5710 0.0 0.0 L2 2/0 81.75 MB 0.8 0.2 0.1 0.1 0.2 0.1 0.0 2.2 111.5 111.4 1.81 0.95 1 1.810 204K 280 0.0 0.0 L3 14/0 953.25 MB 1.0 3.5 2.6 0.9 3.4 2.5 0.2 1.3 102.0 100.7 34.82 16.60 18 1.934 2158K 0 0.0 0.0 L4 171/0 9.54 GB 1.0 10.0 5.1 4.9 9.8 4.9 0.6 1.9 120.6 118.5 84.69 47.65 50 1.694 4220K 8558 0.0 0.0 L5 1164/0 95.78 GB 1.0 0.0 0.0 0.0 0.0 0.0 5.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1376/4 110.01 GB 0.0 18.0 9.0 9.0 21.5 12.5 6.4 5.7 110.4 132.0 166.85 94.56 134 1.245 11M 17K 0.0 0.0 Int 0/0 0.00 KB 0.0 18.0 9.0 9.0 21.5 12.5 6.4 5.7 110.4 132.0 166.85 94.56 134 1.245 11M 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 18.0 9.0 9.0 17.8 8.8 0.0 0.0 125.9 124.3 146.31 83.76 82 1.784 11M 17K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 3.8 3.8 0.0 0.0 0.0 187.1 20.54 10.80 52 0.395 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): 22.3 total, 22.0 interval Flush(GB): cumulative 3.753, interval 3.753 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: 21.51 GB write, 989.99 MB/s write, 17.99 GB read, 827.81 MB/s read, 166.8 seconds Interval compaction: 21.51 GB write, 999.44 MB/s write, 17.99 GB read, 835.71 MB/s read, 166.8 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 69, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 69, interval: 69 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1020634 Average: 6.8341 StdDev: 83.65 Min: 0 Median: 1.5838 Max: 10241 Percentiles: P50: 1.58 P75: 2.04 P99: 13.63 P99.9: 790.08 P99.99: 1574.59 ------------------------------------------------------ [ 0, 1 ] 160207 15.697% 15.697% ### ( 1, 2 ] 599703 58.758% 74.455% ############ ( 2, 3 ] 143703 14.080% 88.534% ### ( 3, 4 ] 52212 5.116% 93.650% # ( 4, 6 ] 42650 4.179% 97.829% # ( 6, 10 ] 10347 1.014% 98.843% ( 10, 15 ] 2215 0.217% 99.060% ( 15, 22 ] 278 0.027% 99.087% ( 22, 34 ] 20 0.002% 99.089% ( 34, 51 ] 14 0.001% 99.090% ( 51, 76 ] 20 0.002% 99.092% ( 76, 110 ] 657 0.064% 99.157% ( 110, 170 ] 2897 0.284% 99.440% ( 170, 250 ] 1943 0.190% 99.631% ( 250, 380 ] 1059 0.104% 99.735% ( 380, 580 ] 1091 0.107% 99.841% ( 580, 870 ] 826 0.081% 99.922% ( 870, 1300 ] 566 0.055% 99.978% ( 1300, 1900 ] 273 0.027% 100.005% ( 1900, 2900 ] 173 0.017% 100.022% ( 2900, 4400 ] 173 0.017% 100.039% ( 4400, 6600 ] 47 0.005% 100.043% ( 6600, 9900 ] 9 0.001% 100.044% ( 9900, 14000 ] 1 0.000% 100.044% ** Level 1 read latency histogram (micros): Count: 206287 Average: 9.0591 StdDev: 115.32 Min: 1 Median: 1.8271 Max: 9765 Percentiles: P50: 1.83 P75: 2.72 P99: 105.29 P99.9: 1438.09 P99.99: 5075.70 ------------------------------------------------------ [ 0, 1 ] 8553 4.146% 4.146% # ( 1, 2 ] 114365 55.440% 59.586% ########### ( 2, 3 ] 43913 21.287% 80.873% #### ( 3, 4 ] 16545 8.020% 88.894% ## ( 4, 6 ] 15323 7.428% 96.322% # ( 6, 10 ] 4443 2.154% 98.475% ( 10, 15 ] 765 0.371% 98.846% ( 15, 22 ] 102 0.049% 98.896% ( 22, 34 ] 14 0.007% 98.902% ( 34, 51 ] 4 0.002% 98.904% ( 51, 76 ] 5 0.002% 98.907% ( 76, 110 ] 223 0.108% 99.015% ( 110, 170 ] 706 0.342% 99.357% ( 170, 250 ] 310 0.150% 99.507% ( 250, 380 ] 212 0.103% 99.610% ( 380, 580 ] 231 0.112% 99.722% ( 580, 870 ] 205 0.099% 99.822% ( 870, 1300 ] 141 0.068% 99.890% ( 1300, 1900 ] 90 0.044% 99.934% ( 1900, 2900 ] 44 0.021% 99.955% ( 2900, 4400 ] 65 0.032% 99.986% ( 4400, 6600 ] 24 0.012% 99.998% ( 6600, 9900 ] 5 0.002% 100.000% ** Level 2 read latency histogram (micros): Count: 646857 Average: 14.3532 StdDev: 179.57 Min: 1 Median: 1.9992 Max: 11512 Percentiles: P50: 2.00 P75: 3.03 P99: 12.22 P99.9: 1442.86 P99.99: 2165.08 ------------------------------------------------------ [ 0, 1 ] 13475 2.083% 2.083% ( 1, 2 ] 310208 47.956% 50.039% ########## ( 2, 3 ] 159186 24.609% 74.648% ##### ( 3, 4 ] 69728 10.780% 85.428% ## ( 4, 6 ] 67984 10.510% 95.938% ## ( 6, 10 ] 18057 2.791% 98.729% # ( 10, 15 ] 3938 0.609% 99.338% ( 15, 22 ] 583 0.090% 99.428% ( 22, 34 ] 96 0.015% 99.443% ( 34, 51 ] 58 0.009% 99.452% ( 51, 76 ] 45 0.007% 99.459% ( 76, 110 ] 113 0.017% 99.477% ( 110, 170 ] 284 0.044% 99.520% ( 170, 250 ] 208 0.032% 99.553% ( 250, 380 ] 309 0.048% 99.600% ( 380, 580 ] 445 0.069% 99.669% ( 580, 870 ] 654 0.101% 99.770% ( 870, 1300 ] 707 0.109% 99.880% ( 1300, 1900 ] 555 0.086% 99.965% ( 1900, 2900 ] 601 0.093% 100.058% ( 2900, 4400 ] 622 0.096% 100.154% ( 4400, 6600 ] 191 0.030% 100.184% ( 6600, 9900 ] 30 0.005% 100.189% ( 9900, 14000 ] 1 0.000% 100.189% ** Level 3 read latency histogram (micros): Count: 1461314 Average: 11.3063 StdDev: 150.90 Min: 0 Median: 1.9810 Max: 13439 Percentiles: P50: 1.98 P75: 2.97 P99: 9.95 P99.9: 763.12 P99.99: 1109.66 ------------------------------------------------------ [ 0, 1 ] 24406 1.670% 1.670% ( 1, 2 ] 719916 49.265% 50.935% ########## ( 2, 3 ] 361446 24.734% 75.669% ##### ( 3, 4 ] 155529 10.643% 86.313% ## ( 4, 6 ] 148704 10.176% 96.489% ## ( 6, 10 ] 37188 2.545% 99.033% # ( 10, 15 ] 7307 0.500% 99.533% ( 15, 22 ] 1037 0.071% 99.604% ( 22, 34 ] 97 0.007% 99.611% ( 34, 51 ] 104 0.007% 99.618% ( 51, 76 ] 133 0.009% 99.627% ( 76, 110 ] 306 0.021% 99.648% ( 110, 170 ] 882 0.060% 99.709% ( 170, 250 ] 519 0.036% 99.744% ( 250, 380 ] 528 0.036% 99.780% ( 380, 580 ] 902 0.062% 99.842% ( 580, 870 ] 1344 0.092% 99.934% ( 870, 1300 ] 1471 0.101% 100.035% ( 1300, 1900 ] 926 0.063% 100.098% ( 1900, 2900 ] 831 0.057% 100.155% ( 2900, 4400 ] 974 0.067% 100.221% ( 4400, 6600 ] 319 0.022% 100.243% ( 6600, 9900 ] 47 0.003% 100.246% ( 9900, 14000 ] 2 0.000% 100.247% ** Level 4 read latency histogram (micros): Count: 1261317 Average: 19.4756 StdDev: 195.58 Min: 1 Median: 1.9793 Max: 15229 Percentiles: P50: 1.98 P75: 2.99 P99: 232.40 P99.9: 1308.91 P99.99: 1797.86 ------------------------------------------------------ [ 0, 1 ] 20880 1.655% 1.655% ( 1, 2 ] 622661 49.366% 51.021% ########## ( 2, 3 ] 305602 24.229% 75.250% ##### ( 3, 4 ] 129066 10.233% 85.483% ## ( 4, 6 ] 119837 9.501% 94.984% ## ( 6, 10 ] 31305 2.482% 97.466% ( 10, 15 ] 5795 0.459% 97.925% ( 15, 22 ] 707 0.056% 97.981% ( 22, 34 ] 51 0.004% 97.985% ( 34, 51 ] 100 0.008% 97.993% ( 51, 76 ] 116 0.009% 98.002% ( 76, 110 ] 2482 0.197% 98.199% ( 110, 170 ] 7319 0.580% 98.779% ( 170, 250 ] 3568 0.283% 99.062% ( 250, 380 ] 2234 0.177% 99.239% ( 380, 580 ] 2929 0.232% 99.472% ( 580, 870 ] 2865 0.227% 99.699% ( 870, 1300 ] 2518 0.200% 99.898% ( 1300, 1900 ] 1393 0.110% 100.009% ( 1900, 2900 ] 1074 0.085% 100.094% ( 2900, 4400 ] 1329 0.105% 100.199% ( 4400, 6600 ] 410 0.033% 100.232% ( 6600, 9900 ] 80 0.006% 100.238% ( 9900, 14000 ] 8 0.001% 100.239% ( 14000, 22000 ] 2 0.000% 100.239% ** Level 5 read latency histogram (micros): Count: 122844 Average: 509.6391 StdDev: 869.74 Min: 72 Median: 192.1233 Max: 19044 Percentiles: P50: 192.12 P75: 489.13 P99: 4709.72 P99.9: 8170.07 P99.99: 11462.26 ------------------------------------------------------ ( 51, 76 ] 11 0.009% 0.009% ( 76, 110 ] 14147 11.516% 11.525% ## ( 110, 170 ] 42070 34.247% 45.772% ####### ( 170, 250 ] 18782 15.289% 61.061% ### ( 250, 380 ] 10891 8.866% 69.927% ## ( 380, 580 ] 11421 9.297% 79.224% ## ( 580, 870 ] 8858 7.211% 86.435% # ( 870, 1300 ] 6330 5.153% 91.588% # ( 1300, 1900 ] 3486 2.838% 94.425% # ( 1900, 2900 ] 2487 2.025% 96.450% ( 2900, 4400 ] 2967 2.415% 98.865% ( 4400, 6600 ] 1176 0.957% 99.823% ( 6600, 9900 ] 200 0.163% 99.985% ( 9900, 14000 ] 15 0.012% 99.998% ( 14000, 22000 ] 4 0.003% 100.001% ** DB Stats ** Uptime(secs): 22.3 total, 3.4 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 176.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:7.209 H:M:S, 32.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 288.49 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/17-20:51:25 ... thread 0: (1000000,5000000) ops and (290998.9,196254.1) ops/second in (3.436439,25.477172) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 19/4 3.56 GB 339.8 3.4 0.0 3.4 8.2 4.7 0.0 1.7 92.1 218.5 38.33 26.87 81 0.473 3582K 3771 0.0 0.0 L1 10/0 1.10 GB 112.4 1.9 1.2 0.7 1.9 1.2 0.0 1.6 137.8 137.4 14.02 8.87 4 3.506 1962K 5710 0.0 0.0 L2 2/0 81.75 MB 0.8 0.2 0.1 0.1 0.2 0.1 0.0 2.2 111.5 111.4 1.81 0.95 1 1.810 204K 280 0.0 0.0 L3 14/0 953.25 MB 1.0 3.5 2.6 0.9 3.4 2.5 0.2 1.3 102.0 100.7 34.82 16.60 18 1.934 2158K 0 0.0 0.0 L4 171/0 9.54 GB 1.0 10.0 5.1 4.9 9.8 4.9 0.6 1.9 120.6 118.5 84.69 47.65 50 1.694 4220K 8558 0.0 0.0 L5 1164/0 95.78 GB 1.0 0.0 0.0 0.0 0.0 0.0 5.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1380/4 110.99 GB 0.0 19.0 9.0 10.0 23.5 13.5 6.4 5.0 111.9 138.5 173.66 100.95 154 1.128 12M 18K 0.0 0.0 Int 0/0 0.00 KB 0.0 19.0 9.0 10.0 23.5 13.5 6.4 5.0 111.9 138.5 173.66 100.95 154 1.128 12M 18K 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 19.0 9.0 10.0 18.7 8.8 0.0 0.0 129.4 127.9 150.11 87.49 86 1.745 12M 18K 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 206.0 23.55 13.46 68 0.346 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 25.7 total, 25.5 interval Flush(GB): cumulative 4.737, interval 4.737 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: 23.48 GB write, 935.99 MB/s write, 18.97 GB read, 756.32 MB/s read, 173.7 seconds Interval compaction: 23.48 GB write, 943.72 MB/s write, 18.97 GB read, 762.56 MB/s read, 173.7 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 69, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 69, interval: 69 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1281578 Average: 6.2426 StdDev: 75.54 Min: 0 Median: 1.5370 Max: 10241 Percentiles: P50: 1.54 P75: 1.96 P99: 13.54 P99.9: 688.93 P99.99: 1334.69 ------------------------------------------------------ [ 0, 1 ] 237828 18.557% 18.557% #### ( 1, 2 ] 750454 58.557% 77.114% ############ ( 2, 3 ] 161887 12.632% 89.746% ### ( 3, 4 ] 58806 4.589% 94.335% # ( 4, 6 ] 46837 3.655% 97.990% # ( 6, 10 ] 11157 0.871% 98.860% ( 10, 15 ] 2535 0.198% 99.058% ( 15, 22 ] 324 0.025% 99.083% ( 22, 34 ] 22 0.002% 99.085% ( 34, 51 ] 17 0.001% 99.086% ( 51, 76 ] 22 0.002% 99.088% ( 76, 110 ] 903 0.070% 99.158% ( 110, 170 ] 3981 0.311% 99.469% ( 170, 250 ] 2635 0.206% 99.675% ( 250, 380 ] 1305 0.102% 99.776% ( 380, 580 ] 1250 0.098% 99.874% ( 580, 870 ] 893 0.070% 99.944% ( 870, 1300 ] 580 0.045% 99.989% ( 1300, 1900 ] 274 0.021% 100.010% ( 1900, 2900 ] 176 0.014% 100.024% ( 2900, 4400 ] 173 0.013% 100.038% ( 4400, 6600 ] 47 0.004% 100.041% ( 6600, 9900 ] 9 0.001% 100.042% ( 9900, 14000 ] 1 0.000% 100.042% ** Level 1 read latency histogram (micros): Count: 207448 Average: 9.6186 StdDev: 115.67 Min: 1 Median: 1.8318 Max: 9765 Percentiles: P50: 1.83 P75: 2.74 P99: 138.91 P99.9: 1430.35 P99.99: 5065.06 ------------------------------------------------------ [ 0, 1 ] 8555 4.124% 4.124% # ( 1, 2 ] 114410 55.151% 59.275% ########### ( 2, 3 ] 44042 21.230% 80.505% #### ( 3, 4 ] 16688 8.044% 88.550% ## ( 4, 6 ] 15479 7.462% 96.012% # ( 6, 10 ] 4461 2.150% 98.162% ( 10, 15 ] 770 0.371% 98.533% ( 15, 22 ] 102 0.049% 98.582% ( 22, 34 ] 14 0.007% 98.589% ( 34, 51 ] 4 0.002% 98.591% ( 51, 76 ] 5 0.002% 98.593% ( 76, 110 ] 354 0.171% 98.764% ( 110, 170 ] 1016 0.490% 99.254% ( 170, 250 ] 427 0.206% 99.460% ( 250, 380 ] 263 0.127% 99.586% ( 380, 580 ] 270 0.130% 99.717% ( 580, 870 ] 216 0.104% 99.821% ( 870, 1300 ] 145 0.070% 99.891% ( 1300, 1900 ] 90 0.043% 99.934% ( 1900, 2900 ] 44 0.021% 99.955% ( 2900, 4400 ] 65 0.031% 99.987% ( 4400, 6600 ] 24 0.012% 99.998% ( 6600, 9900 ] 5 0.002% 100.000% ** Level 2 read latency histogram (micros): Count: 647119 Average: 14.4221 StdDev: 179.59 Min: 1 Median: 1.9996 Max: 11512 Percentiles: P50: 2.00 P75: 3.04 P99: 12.55 P99.9: 1443.66 P99.99: 2166.26 ------------------------------------------------------ [ 0, 1 ] 13475 2.082% 2.082% ( 1, 2 ] 310208 47.937% 50.019% ########## ( 2, 3 ] 159186 24.599% 74.618% ##### ( 3, 4 ] 69728 10.775% 85.393% ## ( 4, 6 ] 67984 10.506% 95.899% ## ( 6, 10 ] 18057 2.790% 98.689% # ( 10, 15 ] 3938 0.609% 99.298% ( 15, 22 ] 583 0.090% 99.388% ( 22, 34 ] 96 0.015% 99.403% ( 34, 51 ] 58 0.009% 99.412% ( 51, 76 ] 45 0.007% 99.419% ( 76, 110 ] 155 0.024% 99.443% ( 110, 170 ] 426 0.066% 99.509% ( 170, 250 ] 250 0.039% 99.547% ( 250, 380 ] 325 0.050% 99.597% ( 380, 580 ] 461 0.071% 99.669% ( 580, 870 ] 657 0.102% 99.770% ( 870, 1300 ] 707 0.109% 99.879% ( 1300, 1900 ] 555 0.086% 99.965% ( 1900, 2900 ] 602 0.093% 100.058% ( 2900, 4400 ] 622 0.096% 100.154% ( 4400, 6600 ] 191 0.030% 100.184% ( 6600, 9900 ] 30 0.005% 100.189% ( 9900, 14000 ] 1 0.000% 100.189% ** Level 3 read latency histogram (micros): Count: 1462258 Average: 11.4195 StdDev: 150.95 Min: 0 Median: 1.9817 Max: 13439 Percentiles: P50: 1.98 P75: 2.97 P99: 10.31 P99.9: 764.97 P99.99: 1110.19 ------------------------------------------------------ [ 0, 1 ] 24406 1.669% 1.669% ( 1, 2 ] 719916 49.233% 50.902% ########## ( 2, 3 ] 361446 24.718% 75.621% ##### ( 3, 4 ] 155529 10.636% 86.257% ## ( 4, 6 ] 148704 10.169% 96.426% ## ( 6, 10 ] 37188 2.543% 98.969% # ( 10, 15 ] 7307 0.500% 99.469% ( 15, 22 ] 1037 0.071% 99.540% ( 22, 34 ] 97 0.007% 99.547% ( 34, 51 ] 104 0.007% 99.554% ( 51, 76 ] 133 0.009% 99.563% ( 76, 110 ] 474 0.032% 99.595% ( 110, 170 ] 1343 0.092% 99.687% ( 170, 250 ] 693 0.047% 99.735% ( 250, 380 ] 593 0.041% 99.775% ( 380, 580 ] 957 0.065% 99.841% ( 580, 870 ] 1362 0.093% 99.934% ( 870, 1300 ] 1473 0.101% 100.034% ( 1300, 1900 ] 927 0.063% 100.098% ( 1900, 2900 ] 831 0.057% 100.155% ( 2900, 4400 ] 974 0.067% 100.221% ( 4400, 6600 ] 319 0.022% 100.243% ( 6600, 9900 ] 47 0.003% 100.246% ( 9900, 14000 ] 2 0.000% 100.246% ** Level 4 read latency histogram (micros): Count: 1269648 Average: 20.5681 StdDev: 195.69 Min: 1 Median: 1.9860 Max: 15229 Percentiles: P50: 1.99 P75: 3.02 P99: 268.44 P99.9: 1308.31 P99.99: 1799.08 ------------------------------------------------------ [ 0, 1 ] 20880 1.645% 1.645% ( 1, 2 ] 622666 49.042% 50.687% ########## ( 2, 3 ] 305617 24.071% 74.758% ##### ( 3, 4 ] 129083 10.167% 84.925% ## ( 4, 6 ] 119859 9.440% 94.365% ## ( 6, 10 ] 31308 2.466% 96.831% ( 10, 15 ] 5797 0.457% 97.288% ( 15, 22 ] 707 0.056% 97.343% ( 22, 34 ] 51 0.004% 97.347% ( 34, 51 ] 100 0.008% 97.355% ( 51, 76 ] 118 0.009% 97.364% ( 76, 110 ] 3970 0.313% 97.677% ( 110, 170 ] 11397 0.898% 98.575% ( 170, 250 ] 4997 0.394% 98.968% ( 250, 380 ] 2830 0.223% 99.191% ( 380, 580 ] 3427 0.270% 99.461% ( 580, 870 ] 3015 0.237% 99.699% ( 870, 1300 ] 2537 0.200% 99.898% ( 1300, 1900 ] 1397 0.110% 100.009% ( 1900, 2900 ] 1077 0.085% 100.093% ( 2900, 4400 ] 1329 0.105% 100.198% ( 4400, 6600 ] 410 0.032% 100.230% ( 6600, 9900 ] 80 0.006% 100.237% ( 9900, 14000 ] 8 0.001% 100.237% ( 14000, 22000 ] 2 0.000% 100.237% ** Level 5 read latency histogram (micros): Count: 168926 Average: 421.6950 StdDev: 758.64 Min: 72 Median: 167.3605 Max: 19044 Percentiles: P50: 167.36 P75: 366.42 P99: 4249.26 P99.9: 7360.22 P99.99: 9868.77 ------------------------------------------------------ ( 51, 76 ] 18 0.011% 0.011% ( 76, 110 ] 22488 13.312% 13.323% ### ( 110, 170 ] 64808 38.365% 51.688% ######## ( 170, 250 ] 26797 15.863% 67.551% ### ( 250, 380 ] 14051 8.318% 75.869% ## ( 380, 580 ] 14323 8.479% 84.348% ## ( 580, 870 ] 9642 5.708% 90.055% # ( 870, 1300 ] 6435 3.809% 93.865% # ( 1300, 1900 ] 3497 2.070% 95.935% ( 1900, 2900 ] 2508 1.485% 97.420% ( 2900, 4400 ] 2968 1.757% 99.177% ( 4400, 6600 ] 1176 0.696% 99.873% ( 6600, 9900 ] 200 0.118% 99.991% ( 9900, 14000 ] 15 0.009% 100.000% ( 14000, 22000 ] 4 0.002% 100.002% ** DB Stats ** Uptime(secs): 25.7 total, 3.4 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 191.56 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:7.209 H:M:S, 28.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 286.40 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 using bdev Nvme0n1 Initializing RocksDB Options from the specified file Initializing RocksDB Options from command-line flags Integrated BlobDB: blob cache disabled Keys: 16 bytes each (+ 0 bytes user-defined timestamp) Values: 1000 bytes each (1000 bytes after compression) Entries: 100000000 Prefix: 0 bytes Keys per prefix: 0 RawSize: 96893.3 MB (estimated) FileSize: 96893.3 MB (estimated) Write rate: 0 bytes/second Read rate: 0 ops/second Compression: NoCompression Compression sampling rate: 0 Memtablerep: SkipListFactory Perf Level: 1 ------------------------------------------------ DB path: [/mnt/rocksdb] readwhilewriting : 249.434 micros/op 16021 ops/sec 60.106 seconds 962996 operations; 15.5 MB/s (239999 of 239999 found) Microseconds per read: Count: 962996 Average: 249.4359 StdDev: 762.62 Min: 1 Median: 168.9893 Max: 90438 Percentiles: P50: 168.99 P75: 229.52 P99: 1491.21 P99.9: 12211.75 P99.99: 30431.47 ------------------------------------------------------ [ 0, 1 ] 1 0.000% 0.000% ( 1, 2 ] 8 0.001% 0.001% ( 2, 3 ] 43 0.004% 0.005% ( 3, 4 ] 68 0.007% 0.012% ( 4, 6 ] 91 0.009% 0.022% ( 6, 10 ] 383 0.040% 0.062% ( 10, 15 ] 3963 0.412% 0.473% ( 15, 22 ] 4655 0.483% 0.957% ( 22, 34 ] 9673 1.004% 1.961% ( 34, 51 ] 3475 0.361% 2.322% ( 51, 76 ] 453 0.047% 2.369% ( 76, 110 ] 24637 2.558% 4.927% # ( 110, 170 ] 441485 45.845% 50.772% ######### ( 170, 250 ] 313608 32.566% 83.338% ####### ( 250, 380 ] 90168 9.363% 92.701% ## ( 380, 580 ] 35511 3.688% 96.389% # ( 580, 870 ] 15711 1.631% 98.020% ( 870, 1300 ] 8216 0.853% 98.874% ( 1300, 1900 ] 3819 0.397% 99.270% ( 1900, 2900 ] 2396 0.249% 99.519% ( 2900, 4400 ] 2382 0.247% 99.766% ( 4400, 6600 ] 830 0.086% 99.853% ( 6600, 9900 ] 245 0.025% 99.878% ( 9900, 14000 ] 376 0.039% 99.917% ( 14000, 22000 ] 554 0.058% 99.975% ( 22000, 33000 ] 194 0.020% 99.995% ( 33000, 50000 ] 33 0.003% 99.998% ( 50000, 75000 ] 17 0.002% 100.000% ( 75000, 110000 ] 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 : 19087173 rocksdb.bloom.filter.full.positive COUNT : 1148655 rocksdb.bloom.filter.full.true.positive COUNT : 962520 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 : 476 rocksdb.memtable.miss COUNT : 962520 rocksdb.l0.hit COUNT : 34826 rocksdb.l1.hit COUNT : 10059 rocksdb.l2andup.hit COUNT : 917635 rocksdb.compaction.key.drop.new COUNT : 280159 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 : 5440765 rocksdb.number.keys.read COUNT : 962996 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 5614869480 rocksdb.bytes.read COUNT : 962996000 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 : 1674 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 39485201 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 : 22928780352 rocksdb.compact.write.bytes COUNT : 22644414462 rocksdb.flush.write.bytes COUNT : 5614916141 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 : 25 rocksdb.number.superversion_acquires COUNT : 1087 rocksdb.number.superversion_releases COUNT : 1052 rocksdb.number.superversion_cleanups COUNT : 274 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 : 292 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 : 5569628160 rocksdb.memtable.garbage.bytes.at.flush COUNT : 2151424 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 : 27714630736 rocksdb.non.last.level.read.count COUNT : 6553959 rocksdb.block.checksum.compute.count COUNT : 6716624 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 : 168.093171 P95 : 503.616575 P99 : 1489.728369 P100 : 90436.000000 COUNT : 962996 SUM : 239324744 rocksdb.db.write.micros P50 : 1.559908 P95 : 4.446370 P99 : 9.338791 P100 : 875560.000000 COUNT : 5440765 SUM : 53304626 rocksdb.compaction.times.micros P50 : 1513793.103448 P95 : 2883333.333333 P99 : 6896000.000000 P100 : 7421460.000000 COUNT : 88 SUM : 152052876 rocksdb.compaction.times.cpu_micros P50 : 922962.962963 P95 : 1848421.052632 P99 : 4564000.000000 P100 : 5308714.000000 COUNT : 88 SUM : 89386955 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 : 785.121951 P95 : 24200.000000 P99 : 124400.000000 P100 : 156144.000000 COUNT : 76 SUM : 501661 rocksdb.compaction.outfile.sync.micros P50 : 42180.000000 P95 : 226266.666667 P99 : 480225.000000 P100 : 810180.000000 COUNT : 289 SUM : 19666618 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 : 405.000000 P95 : 4557.142857 P99 : 7810.000000 P100 : 8730.000000 COUNT : 190 SUM : 228995 rocksdb.table.open.io.micros P50 : 9301.470588 P95 : 20598.742138 P99 : 26423.571429 P100 : 29098.000000 COUNT : 1674 SUM : 15847774 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 : 4.131375 P95 : 9.901996 P99 : 159.373420 P100 : 16139.000000 COUNT : 5554888 SUM : 80292062 rocksdb.read.block.get.micros P50 : 134.726710 P95 : 371.315428 P99 : 1347.195556 P100 : 26856.000000 COUNT : 1160343 SUM : 202566833 rocksdb.write.raw.block.micros P50 : 0.537118 P95 : 1.388911 P99 : 3.870164 P100 : 22640.000000 COUNT : 6845597 SUM : 22229613 rocksdb.numfiles.in.singlecompaction P50 : 3.034884 P95 : 5.464286 P99 : 9.400000 P100 : 27.000000 COUNT : 115 SUM : 402 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.590203 P95 : 2104.431805 P99 : 2742.508165 P100 : 875363.000000 COUNT : 141637 SUM : 39498374 rocksdb.sst.read.micros P50 : 2.213291 P95 : 160.405797 P99 : 469.238196 P100 : 19044.000000 COUNT : 6554417 SUM : 265806634 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 : 1000.000000 P95 : 1000.000000 P99 : 1000.000000 P100 : 1000.000000 COUNT : 962996 SUM : 962996000 rocksdb.bytes.per.write P50 : 1032.000000 P95 : 1032.000000 P99 : 1032.000000 P100 : 1032.000000 COUNT : 5440765 SUM : 5614869480 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 : 224285.714286 P95 : 1038500.000000 P99 : 1121109.000000 P100 : 1121109.000000 COUNT : 76 SUM : 25163189 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 : 295 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