[2024-11-19 20:12:24.244478] Starting SPDK v24.09.1-pre git sha1 b18e1bd62 / DPDK 23.11.0 initialization... [2024-11-19 20:12:24.244757] [ 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_pid1629012 ] Set seed to 1732043544237790 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-11-19 20:12:24.357187] app.c: 917:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-11-19 20:12:24.398707] app.c: 610:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-11-19 20:12:24.398756] app.c: 611:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 1629012' to capture a snapshot of events at runtime. [2024-11-19 20:12:24.398767] app.c: 616:app_setup_trace: *NOTICE*: 'spdk_trace' without parameters will also work if this is the only [2024-11-19 20:12:24.398777] app.c: 617:app_setup_trace: *NOTICE*: SPDK application currently running. [2024-11-19 20:12:24.398785] app.c: 618:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid1629012 for offline analysis/debug. [2024-11-19 20:12:24.398872] reactor.c: 990:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Tue Nov 19 20:12:28 2024 CPU: 96 * Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz CPUCache: 36608 KB 2024/11/19-20:12:31 ... thread 0: (1000000,1000000) ops and (331087.3,331087.3) ops/second in (3.020351,3.020351) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 6/4 440.95 MB 18.9 0.0 0.0 0.0 0.9 0.9 0.0 1.0 0.0 348.9 2.53 2.28 12 0.211 0 0 0.0 0.0 L1 3/0 249.35 MB 24.9 0.2 0.2 0.0 0.2 0.2 0.2 1.0 242.5 242.2 1.04 1.00 1 1.039 255K 232 0.0 0.0 L2 3/2 191.26 MB 0.0 0.2 0.1 0.1 0.2 0.1 0.2 1.5 242.2 242.1 0.80 0.76 2 0.399 196K 84 0.0 0.0 L3 11/0 930.15 MB 0.9 0.0 0.0 0.0 0.0 0.0 0.1 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 116/0 9.60 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 1040/0 85.63 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 1179/6 97.00 GB 0.0 0.4 0.4 0.1 1.3 1.2 0.5 1.5 102.0 304.0 4.36 4.04 15 0.291 452K 316 0.0 0.0 Int 0/0 0.00 KB 0.0 0.4 0.4 0.1 1.3 1.2 0.4 1.5 102.0 304.0 4.36 4.04 15 0.291 452K 316 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 0.4 0.4 0.1 0.4 0.4 0.0 0.0 242.4 242.2 1.84 1.76 3 0.612 452K 316 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 348.9 2.53 2.28 12 0.211 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.0 interval Flush(GB): cumulative 0.861, interval 0.861 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 1.30 GB write, 413.10 MB/s write, 0.43 GB read, 138.61 MB/s read, 4.4 seconds Interval compaction: 1.30 GB write, 439.05 MB/s write, 0.43 GB read, 147.32 MB/s read, 4.4 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 4, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 4, interval: 4 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 158372 Average: 1.9880 StdDev: 15.69 Min: 1 Median: 1.3322 Max: 4509 Percentiles: P50: 1.33 P75: 1.75 P99: 5.18 P99.9: 9.65 P99.99: 25.49 ------------------------------------------------------ [ 0, 1 ] 47806 30.186% 30.186% ###### ( 1, 2 ] 94468 59.649% 89.835% ############ ( 2, 3 ] 9286 5.863% 95.699% # ( 3, 4 ] 3859 2.437% 98.135% ( 4, 6 ] 2313 1.460% 99.596% ( 6, 10 ] 529 0.334% 99.930% ( 10, 15 ] 80 0.051% 99.980% ( 15, 22 ] 15 0.009% 99.990% ( 22, 34 ] 4 0.003% 99.992% ( 51, 76 ] 1 0.001% 99.993% ( 110, 170 ] 7 0.004% 99.997% ( 170, 250 ] 3 0.002% 99.999% ( 250, 380 ] 6 0.004% 100.003% ( 580, 870 ] 4 0.003% 100.006% ( 870, 1300 ] 1 0.001% 100.006% ( 1900, 2900 ] 2 0.001% 100.008% ( 4400, 6600 ] 1 0.001% 100.008% ** Level 1 read latency histogram (micros): Count: 633 Average: 17.2654 StdDev: 136.42 Min: 1 Median: 2.5766 Max: 2190 Percentiles: P50: 2.58 P75: 3.49 P99: 424.67 P99.9: 2190.00 P99.99: 2190.00 ------------------------------------------------------ [ 0, 1 ] 7 1.106% 1.106% ( 1, 2 ] 174 27.488% 28.594% ##### ( 2, 3 ] 235 37.125% 65.719% ####### ( 3, 4 ] 119 18.799% 84.518% #### ( 4, 6 ] 54 8.531% 93.049% ## ( 6, 10 ] 27 4.265% 97.314% # ( 10, 15 ] 5 0.790% 98.104% ( 22, 34 ] 1 0.158% 98.262% ( 110, 170 ] 1 0.158% 98.420% ( 170, 250 ] 1 0.158% 98.578% ( 250, 380 ] 2 0.316% 98.894% ( 380, 580 ] 3 0.474% 99.368% ( 870, 1300 ] 1 0.158% 99.526% ( 1300, 1900 ] 2 0.316% 99.842% ( 1900, 2900 ] 1 0.158% 100.000% ** Level 2 read latency histogram (micros): Count: 43194 Average: 2.2520 StdDev: 6.84 Min: 1 Median: 1.5375 Max: 1307 Percentiles: P50: 1.54 P75: 1.91 P99: 5.83 P99.9: 9.98 P99.99: 26.08 ------------------------------------------------------ [ 0, 1 ] 5824 13.483% 13.483% ### ( 1, 2 ] 29343 67.933% 81.416% ############## ( 2, 3 ] 4503 10.425% 91.841% ## ( 3, 4 ] 1913 4.429% 96.270% # ( 4, 6 ] 1292 2.991% 99.261% # ( 6, 10 ] 277 0.641% 99.903% ( 10, 15 ] 28 0.065% 99.968% ( 15, 22 ] 9 0.021% 99.988% ( 22, 34 ] 2 0.005% 99.993% ( 34, 51 ] 1 0.002% 99.995% ( 170, 250 ] 2 0.005% 100.000% ( 380, 580 ] 1 0.002% 100.002% ( 1300, 1900 ] 1 0.002% 100.005% ** Level 3 read latency histogram (micros): Count: 50 Average: 1720.2400 StdDev: 1287.69 Min: 81 Median: 1500.0000 Max: 4573 Percentiles: P50: 1500.00 P75: 2650.00 P99: 4573.00 P99.9: 4573.00 P99.99: 4573.00 ------------------------------------------------------ ( 76, 110 ] 1 2.000% 2.000% ( 170, 250 ] 4 8.000% 10.000% ## ( 250, 380 ] 4 8.000% 18.000% ## ( 380, 580 ] 5 10.000% 28.000% ## ( 580, 870 ] 4 8.000% 36.000% ## ( 870, 1300 ] 6 12.000% 48.000% ## ( 1300, 1900 ] 3 6.000% 54.000% # ( 1900, 2900 ] 14 28.000% 82.000% ###### ( 2900, 4400 ] 8 16.000% 98.000% ### ( 4400, 6600 ] 1 2.000% 100.000% ** Level 4 read latency histogram (micros): Count: 25 Average: 1563.9200 StdDev: 1510.20 Min: 155 Median: 833.7500 Max: 6064 Percentiles: P50: 833.75 P75: 2337.50 P99: 6064.00 P99.9: 6064.00 P99.99: 6064.00 ------------------------------------------------------ ( 110, 170 ] 1 4.000% 4.000% # ( 170, 250 ] 1 4.000% 8.000% # ( 380, 580 ] 7 28.000% 36.000% ###### ( 580, 870 ] 4 16.000% 52.000% ### ( 870, 1300 ] 3 12.000% 64.000% ## ( 1300, 1900 ] 1 4.000% 68.000% # ( 1900, 2900 ] 4 16.000% 84.000% ### ( 2900, 4400 ] 2 8.000% 92.000% ## ( 4400, 6600 ] 2 8.000% 100.000% ## ** DB Stats ** Uptime(secs): 3.2 total, 3.0 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 306.41 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:0.436 H:M:S, 13.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 325.59 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.436 H:M:S, 14.4 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/19-20:12:34 ... thread 0: (1000000,2000000) ops and (353288.6,341827.9) ops/second in (2.830547,5.850898) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 14/13 1.35 GB 25.2 0.5 0.0 0.5 2.3 1.8 0.0 1.3 71.0 328.4 7.10 6.50 28 0.253 511K 484 0.0 0.0 L1 3/3 249.35 MB 0.0 0.2 0.2 0.0 0.2 0.2 0.2 1.0 242.5 242.2 1.04 1.00 1 1.039 255K 232 0.0 0.0 L2 1/0 4.21 MB 0.0 0.2 0.1 0.1 0.2 0.1 0.2 1.5 242.2 242.1 0.80 0.76 2 0.399 196K 84 0.0 0.0 L3 18/0 948.95 MB 0.9 0.2 0.2 0.0 0.2 0.2 0.1 1.0 232.7 232.7 0.80 0.75 1 0.804 189K 0 0.0 0.0 L4 173/0 9.76 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.0 1.0 137.2 137.2 1.23 0.86 1 1.227 170K 0 0.0 0.0 L5 1040/0 85.63 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 1249/16 97.92 GB 0.0 1.3 0.7 0.6 3.1 2.5 0.5 1.7 119.0 285.5 10.96 9.87 33 0.332 1324K 800 0.0 0.0 Int 0/0 0.00 KB 0.0 1.3 0.7 0.6 3.1 2.5 0.4 1.7 119.0 285.5 10.96 9.87 33 0.332 1324K 800 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 1.3 0.7 0.6 1.3 0.7 0.0 0.0 226.5 226.4 5.76 5.22 7 0.823 1324K 800 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 351.1 5.20 4.64 26 0.200 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 6.0 total, 5.9 interval Flush(GB): cumulative 1.784, interval 1.784 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 3.06 GB write, 518.11 MB/s write, 1.27 GB read, 215.90 MB/s read, 11.0 seconds Interval compaction: 3.06 GB write, 534.93 MB/s write, 1.27 GB read, 222.90 MB/s read, 11.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: 6, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 6, interval: 6 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 402947 Average: 2.0941 StdDev: 13.83 Min: 0 Median: 1.4250 Max: 4509 Percentiles: P50: 1.43 P75: 1.82 P99: 5.23 P99.9: 9.31 P99.99: 14.55 ------------------------------------------------------ [ 0, 1 ] 92158 22.871% 22.871% ##### ( 1, 2 ] 257200 63.830% 86.701% ############# ( 2, 3 ] 33674 8.357% 95.058% ## ( 3, 4 ] 11814 2.932% 97.990% # ( 4, 6 ] 6598 1.637% 99.627% ( 6, 10 ] 1330 0.330% 99.957% ( 10, 15 ] 147 0.036% 99.994% ( 15, 22 ] 21 0.005% 99.999% ( 22, 34 ] 8 0.002% 100.001% ( 51, 76 ] 4 0.001% 100.002% ( 110, 170 ] 16 0.004% 100.006% ( 170, 250 ] 7 0.002% 100.007% ( 250, 380 ] 10 0.002% 100.010% ( 380, 580 ] 1 0.000% 100.010% ( 580, 870 ] 7 0.002% 100.012% ( 870, 1300 ] 4 0.001% 100.013% ( 1300, 1900 ] 5 0.001% 100.014% ( 1900, 2900 ] 4 0.001% 100.015% ( 2900, 4400 ] 1 0.000% 100.015% ( 4400, 6600 ] 1 0.000% 100.016% ** Level 1 read latency histogram (micros): Count: 46390 Average: 2.2902 StdDev: 16.06 Min: 1 Median: 1.5035 Max: 2190 Percentiles: P50: 1.50 P75: 1.88 P99: 5.35 P99.9: 9.65 P99.99: 537.40 ------------------------------------------------------ [ 0, 1 ] 7719 16.639% 16.639% ### ( 1, 2 ] 30737 66.258% 82.897% ############# ( 2, 3 ] 5315 11.457% 94.354% ## ( 3, 4 ] 1558 3.358% 97.713% # ( 4, 6 ] 885 1.908% 99.621% ( 6, 10 ] 142 0.306% 99.927% ( 10, 15 ] 18 0.039% 99.966% ( 15, 22 ] 1 0.002% 99.968% ( 22, 34 ] 2 0.004% 99.972% ( 34, 51 ] 1 0.002% 99.974% ( 51, 76 ] 1 0.002% 99.976% ( 110, 170 ] 1 0.002% 99.978% ( 170, 250 ] 1 0.002% 99.981% ( 250, 380 ] 2 0.004% 99.985% ( 380, 580 ] 3 0.006% 99.991% ( 870, 1300 ] 1 0.002% 99.994% ( 1300, 1900 ] 2 0.004% 99.998% ( 1900, 2900 ] 1 0.002% 100.000% ** Level 2 read latency histogram (micros): Count: 47966 Average: 2.2365 StdDev: 6.50 Min: 1 Median: 1.5346 Max: 1307 Percentiles: P50: 1.53 P75: 1.90 P99: 5.79 P99.9: 9.93 P99.99: 23.22 ------------------------------------------------------ [ 0, 1 ] 6476 13.501% 13.501% ### ( 1, 2 ] 32748 68.273% 81.775% ############## ( 2, 3 ] 4988 10.399% 92.174% ## ( 3, 4 ] 2042 4.257% 96.431% # ( 4, 6 ] 1374 2.865% 99.295% # ( 6, 10 ] 295 0.615% 99.910% ( 10, 15 ] 29 0.060% 99.971% ( 15, 22 ] 9 0.019% 99.990% ( 22, 34 ] 2 0.004% 99.994% ( 34, 51 ] 1 0.002% 99.996% ( 170, 250 ] 2 0.004% 100.000% ( 380, 580 ] 1 0.002% 100.002% ( 1300, 1900 ] 1 0.002% 100.004% ** Level 3 read latency histogram (micros): Count: 42809 Average: 4.4726 StdDev: 73.57 Min: 0 Median: 1.6901 Max: 4573 Percentiles: P50: 1.69 P75: 2.26 P99: 5.97 P99.9: 358.97 P99.99: 3784.83 ------------------------------------------------------ [ 0, 1 ] 2583 6.034% 6.034% # ( 1, 2 ] 27272 63.706% 69.740% ############# ( 2, 3 ] 8746 20.430% 90.170% #### ( 3, 4 ] 2042 4.770% 94.940% # ( 4, 6 ] 1762 4.116% 99.056% # ( 6, 10 ] 285 0.666% 99.722% ( 10, 15 ] 57 0.133% 99.855% ( 15, 22 ] 8 0.019% 99.874% ( 22, 34 ] 1 0.002% 99.876% ( 76, 110 ] 1 0.002% 99.879% ( 110, 170 ] 1 0.002% 99.881% ( 170, 250 ] 4 0.009% 99.890% ( 250, 380 ] 5 0.012% 99.902% ( 380, 580 ] 5 0.012% 99.914% ( 580, 870 ] 4 0.009% 99.923% ( 870, 1300 ] 7 0.016% 99.939% ( 1300, 1900 ] 3 0.007% 99.946% ( 1900, 2900 ] 14 0.033% 99.979% ( 2900, 4400 ] 8 0.019% 99.998% ( 4400, 6600 ] 1 0.002% 100.000% ** Level 4 read latency histogram (micros): Count: 310 Average: 131.4226 StdDev: 603.94 Min: 0 Median: 1.5610 Max: 6064 Percentiles: P50: 1.56 P75: 5.00 P99: 3575.00 P99.9: 6064.00 P99.99: 6064.00 ------------------------------------------------------ [ 0, 1 ] 86 27.742% 27.742% ###### ( 1, 2 ] 123 39.677% 67.419% ######## ( 2, 3 ] 14 4.516% 71.935% # ( 3, 4 ] 3 0.968% 72.903% ( 4, 6 ] 13 4.194% 77.097% # ( 6, 10 ] 37 11.935% 89.032% ## ( 10, 15 ] 6 1.935% 90.968% ( 110, 170 ] 1 0.323% 91.290% ( 170, 250 ] 3 0.968% 92.258% ( 380, 580 ] 8 2.581% 94.839% # ( 580, 870 ] 4 1.290% 96.129% ( 870, 1300 ] 3 0.968% 97.097% ( 1300, 1900 ] 1 0.323% 97.419% ( 1900, 2900 ] 4 1.290% 98.710% ( 2900, 4400 ] 2 0.645% 99.355% ( 4400, 6600 ] 2 0.645% 100.000% ** DB Stats ** Uptime(secs): 6.0 total, 2.8 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 325.76 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:0.667 H:M:S, 11.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 347.71 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.231 H:M:S, 8.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/11/19-20:12:37 ... thread 0: (1000000,3000000) ops and (311196.8,330968.8) ops/second in (3.213401,9.064299) 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 13/11 1.78 GB 44.1 1.4 0.0 1.4 4.1 2.8 0.0 1.5 104.7 318.9 13.23 12.29 44 0.301 1407K 1433 0.0 0.0 L1 8/8 813.21 MB 0.0 1.0 0.8 0.2 1.0 0.8 0.2 1.3 232.3 231.7 4.60 4.46 2 2.299 1084K 2927 0.0 0.0 L2 1/0 4.21 MB 0.0 0.2 0.1 0.1 0.2 0.1 0.2 1.5 242.2 242.1 0.80 0.76 2 0.399 196K 84 0.0 0.0 L3 18/0 948.95 MB 0.9 0.2 0.2 0.0 0.2 0.2 0.1 1.0 232.7 232.7 0.80 0.75 1 0.804 189K 0 0.0 0.0 L4 173/0 9.76 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.0 1.0 137.2 137.2 1.23 0.86 1 1.227 170K 0 0.0 0.0 L5 1040/0 85.63 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 1253/19 98.90 GB 0.0 2.9 1.3 1.7 5.7 4.0 0.5 2.1 145.3 282.3 20.66 19.12 50 0.413 3048K 4444 0.0 0.0 Int 0/0 0.00 KB 0.0 2.9 1.3 1.7 5.7 4.0 0.4 2.1 145.3 282.3 20.66 19.12 50 0.413 3048K 4444 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.9 1.3 1.7 2.9 1.3 0.0 0.0 238.4 238.0 12.60 11.90 11 1.145 3048K 4444 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 351.6 8.06 7.22 39 0.207 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.3 total, 9.1 interval Flush(GB): cumulative 2.768, interval 2.768 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 5.70 GB write, 630.17 MB/s write, 2.93 GB read, 324.39 MB/s read, 20.7 seconds Interval compaction: 5.70 GB write, 643.37 MB/s write, 2.93 GB read, 331.19 MB/s read, 20.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: 12, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 12, interval: 12 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 720136 Average: 2.1309 StdDev: 13.01 Min: 0 Median: 1.4578 Max: 4509 Percentiles: P50: 1.46 P75: 1.84 P99: 5.30 P99.9: 9.30 P99.99: 13.49 ------------------------------------------------------ [ 0, 1 ] 144053 20.004% 20.004% #### ( 1, 2 ] 471819 65.518% 85.522% ############# ( 2, 3 ] 65455 9.089% 94.611% ## ( 3, 4 ] 23333 3.240% 97.851% # ( 4, 6 ] 12745 1.770% 99.621% ( 6, 10 ] 2439 0.339% 99.959% ( 10, 15 ] 315 0.044% 100.003% ( 15, 22 ] 28 0.004% 100.007% ( 22, 34 ] 13 0.002% 100.009% ( 34, 51 ] 3 0.000% 100.009% ( 51, 76 ] 5 0.001% 100.010% ( 110, 170 ] 23 0.003% 100.013% ( 170, 250 ] 12 0.002% 100.015% ( 250, 380 ] 16 0.002% 100.017% ( 380, 580 ] 2 0.000% 100.017% ( 580, 870 ] 12 0.002% 100.019% ( 870, 1300 ] 6 0.001% 100.020% ( 1300, 1900 ] 8 0.001% 100.021% ( 1900, 2900 ] 6 0.001% 100.022% ( 2900, 4400 ] 3 0.000% 100.022% ( 4400, 6600 ] 1 0.000% 100.022% ** Level 1 read latency histogram (micros): Count: 119751 Average: 2.2038 StdDev: 13.19 Min: 0 Median: 1.4716 Max: 2190 Percentiles: P50: 1.47 P75: 1.85 P99: 5.26 P99.9: 9.54 P99.99: 530.62 ------------------------------------------------------ [ 0, 1 ] 22444 18.742% 18.742% #### ( 1, 2 ] 79369 66.278% 85.021% ############# ( 2, 3 ] 11755 9.816% 94.837% ## ( 3, 4 ] 3696 3.086% 97.923% # ( 4, 6 ] 2042 1.705% 99.628% ( 6, 10 ] 367 0.306% 99.935% ( 10, 15 ] 37 0.031% 99.966% ( 15, 22 ] 8 0.007% 99.972% ( 22, 34 ] 3 0.003% 99.975% ( 34, 51 ] 3 0.003% 99.977% ( 51, 76 ] 2 0.002% 99.979% ( 110, 170 ] 2 0.002% 99.981% ( 170, 250 ] 1 0.001% 99.982% ( 250, 380 ] 4 0.003% 99.985% ( 380, 580 ] 8 0.007% 99.992% ( 580, 870 ] 1 0.001% 99.992% ( 870, 1300 ] 5 0.004% 99.997% ( 1300, 1900 ] 3 0.003% 99.999% ( 1900, 2900 ] 1 0.001% 100.000% ** Level 2 read latency histogram (micros): Count: 47966 Average: 2.2365 StdDev: 6.50 Min: 1 Median: 1.5346 Max: 1307 Percentiles: P50: 1.53 P75: 1.90 P99: 5.79 P99.9: 9.93 P99.99: 23.22 ------------------------------------------------------ [ 0, 1 ] 6476 13.501% 13.501% ### ( 1, 2 ] 32748 68.273% 81.775% ############## ( 2, 3 ] 4988 10.399% 92.174% ## ( 3, 4 ] 2042 4.257% 96.431% # ( 4, 6 ] 1374 2.865% 99.295% # ( 6, 10 ] 295 0.615% 99.910% ( 10, 15 ] 29 0.060% 99.971% ( 15, 22 ] 9 0.019% 99.990% ( 22, 34 ] 2 0.004% 99.994% ( 34, 51 ] 1 0.002% 99.996% ( 170, 250 ] 2 0.004% 100.000% ( 380, 580 ] 1 0.002% 100.002% ( 1300, 1900 ] 1 0.002% 100.004% ** Level 3 read latency histogram (micros): Count: 42809 Average: 4.4726 StdDev: 73.57 Min: 0 Median: 1.6901 Max: 4573 Percentiles: P50: 1.69 P75: 2.26 P99: 5.97 P99.9: 358.97 P99.99: 3784.83 ------------------------------------------------------ [ 0, 1 ] 2583 6.034% 6.034% # ( 1, 2 ] 27272 63.706% 69.740% ############# ( 2, 3 ] 8746 20.430% 90.170% #### ( 3, 4 ] 2042 4.770% 94.940% # ( 4, 6 ] 1762 4.116% 99.056% # ( 6, 10 ] 285 0.666% 99.722% ( 10, 15 ] 57 0.133% 99.855% ( 15, 22 ] 8 0.019% 99.874% ( 22, 34 ] 1 0.002% 99.876% ( 76, 110 ] 1 0.002% 99.879% ( 110, 170 ] 1 0.002% 99.881% ( 170, 250 ] 4 0.009% 99.890% ( 250, 380 ] 5 0.012% 99.902% ( 380, 580 ] 5 0.012% 99.914% ( 580, 870 ] 4 0.009% 99.923% ( 870, 1300 ] 7 0.016% 99.939% ( 1300, 1900 ] 3 0.007% 99.946% ( 1900, 2900 ] 14 0.033% 99.979% ( 2900, 4400 ] 8 0.019% 99.998% ( 4400, 6600 ] 1 0.002% 100.000% ** Level 4 read latency histogram (micros): Count: 310 Average: 131.4226 StdDev: 603.94 Min: 0 Median: 1.5610 Max: 6064 Percentiles: P50: 1.56 P75: 5.00 P99: 3575.00 P99.9: 6064.00 P99.99: 6064.00 ------------------------------------------------------ [ 0, 1 ] 86 27.742% 27.742% ###### ( 1, 2 ] 123 39.677% 67.419% ######## ( 2, 3 ] 14 4.516% 71.935% # ( 3, 4 ] 3 0.968% 72.903% ( 4, 6 ] 13 4.194% 77.097% # ( 6, 10 ] 37 11.935% 89.032% ## ( 10, 15 ] 6 1.935% 90.968% ( 110, 170 ] 1 0.323% 91.290% ( 170, 250 ] 3 0.968% 92.258% ( 380, 580 ] 8 2.581% 94.839% # ( 580, 870 ] 4 1.290% 96.129% ( 870, 1300 ] 3 0.968% 97.097% ( 1300, 1900 ] 1 0.323% 97.419% ( 1900, 2900 ] 4 1.290% 98.710% ( 2900, 4400 ] 2 0.645% 99.355% ( 4400, 6600 ] 2 0.645% 100.000% ** DB Stats ** Uptime(secs): 9.3 total, 3.2 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 318.99 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:1.260 H:M:S, 13.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 306.28 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.593 H:M:S, 18.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/19-20:12:40 ... thread 0: (1000000,4000000) ops and (333106.9,331500.7) ops/second in (3.002039,12.066338) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 18/11 2.77 GB 144.8 2.2 0.0 2.2 5.9 3.8 0.0 1.6 115.5 316.7 19.09 17.79 61 0.313 2238K 2288 0.0 0.0 L1 8/8 813.21 MB 0.0 1.0 0.8 0.2 1.0 0.8 0.2 1.3 232.3 231.7 4.60 4.46 2 2.299 1084K 2927 0.0 0.0 L2 1/0 4.21 MB 0.0 0.2 0.1 0.1 0.2 0.1 0.2 1.5 242.2 242.1 0.80 0.76 2 0.399 196K 84 0.0 0.0 L3 18/0 948.95 MB 0.9 0.2 0.2 0.0 0.2 0.2 0.1 1.0 232.7 232.7 0.80 0.75 1 0.804 189K 0 0.0 0.0 L4 173/0 9.76 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.0 1.0 137.2 137.2 1.23 0.86 1 1.227 170K 0 0.0 0.0 L5 1040/0 85.63 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 1258/19 99.88 GB 0.0 3.7 1.3 2.5 7.5 5.0 0.5 2.0 144.1 288.9 26.51 24.62 67 0.396 3880K 5299 0.0 0.0 Int 0/0 0.00 KB 0.0 3.7 1.3 2.5 7.5 5.0 0.4 2.0 144.1 288.9 26.51 24.62 67 0.396 3880K 5299 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 3.7 1.3 2.5 3.7 1.3 0.0 0.0 244.6 244.3 15.62 14.87 14 1.116 3880K 5299 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 352.9 10.89 9.74 53 0.205 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 12.3 total, 12.1 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: 7.48 GB write, 624.80 MB/s write, 3.73 GB read, 311.76 MB/s read, 26.5 seconds Interval compaction: 7.48 GB write, 634.63 MB/s write, 3.73 GB read, 316.66 MB/s read, 26.5 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: 14, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 1, total-stops: 14, interval: 15 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1035102 Average: 2.1610 StdDev: 12.35 Min: 0 Median: 1.4728 Max: 4509 Percentiles: P50: 1.47 P75: 1.85 P99: 5.34 P99.9: 9.53 P99.99: 14.75 ------------------------------------------------------ [ 0, 1 ] 192755 18.622% 18.622% #### ( 1, 2 ] 687002 66.370% 84.992% ############# ( 2, 3 ] 98664 9.532% 94.524% ## ( 3, 4 ] 34122 3.296% 97.821% # ( 4, 6 ] 18274 1.765% 99.586% ( 6, 10 ] 3687 0.356% 99.942% ( 10, 15 ] 520 0.050% 99.992% ( 15, 22 ] 50 0.005% 99.997% ( 22, 34 ] 19 0.002% 99.999% ( 34, 51 ] 4 0.000% 100.000% ( 51, 76 ] 10 0.001% 100.000% ( 76, 110 ] 57 0.006% 100.006% ( 110, 170 ] 59 0.006% 100.012% ( 170, 250 ] 35 0.003% 100.015% ( 250, 380 ] 30 0.003% 100.018% ( 380, 580 ] 12 0.001% 100.019% ( 580, 870 ] 21 0.002% 100.021% ( 870, 1300 ] 9 0.001% 100.022% ( 1300, 1900 ] 8 0.001% 100.023% ( 1900, 2900 ] 7 0.001% 100.023% ( 2900, 4400 ] 4 0.000% 100.024% ( 4400, 6600 ] 1 0.000% 100.024% ** Level 1 read latency histogram (micros): Count: 191278 Average: 2.2162 StdDev: 10.96 Min: 0 Median: 1.4934 Max: 2190 Percentiles: P50: 1.49 P75: 1.86 P99: 5.37 P99.9: 9.73 P99.99: 417.44 ------------------------------------------------------ [ 0, 1 ] 31842 16.647% 16.647% ### ( 1, 2 ] 129300 67.598% 84.245% ############## ( 2, 3 ] 19898 10.403% 94.648% ## ( 3, 4 ] 5997 3.135% 97.783% # ( 4, 6 ] 3394 1.774% 99.557% ( 6, 10 ] 703 0.368% 99.925% ( 10, 15 ] 68 0.036% 99.960% ( 15, 22 ] 10 0.005% 99.965% ( 22, 34 ] 4 0.002% 99.968% ( 34, 51 ] 3 0.002% 99.969% ( 51, 76 ] 2 0.001% 99.970% ( 110, 170 ] 18 0.009% 99.980% ( 170, 250 ] 8 0.004% 99.984% ( 250, 380 ] 10 0.005% 99.989% ( 380, 580 ] 10 0.005% 99.994% ( 580, 870 ] 2 0.001% 99.995% ( 870, 1300 ] 5 0.003% 99.998% ( 1300, 1900 ] 3 0.002% 99.999% ( 1900, 2900 ] 1 0.001% 100.000% ** Level 2 read latency histogram (micros): Count: 47966 Average: 2.2365 StdDev: 6.50 Min: 1 Median: 1.5346 Max: 1307 Percentiles: P50: 1.53 P75: 1.90 P99: 5.79 P99.9: 9.93 P99.99: 23.22 ------------------------------------------------------ [ 0, 1 ] 6476 13.501% 13.501% ### ( 1, 2 ] 32748 68.273% 81.775% ############## ( 2, 3 ] 4988 10.399% 92.174% ## ( 3, 4 ] 2042 4.257% 96.431% # ( 4, 6 ] 1374 2.865% 99.295% # ( 6, 10 ] 295 0.615% 99.910% ( 10, 15 ] 29 0.060% 99.971% ( 15, 22 ] 9 0.019% 99.990% ( 22, 34 ] 2 0.004% 99.994% ( 34, 51 ] 1 0.002% 99.996% ( 170, 250 ] 2 0.004% 100.000% ( 380, 580 ] 1 0.002% 100.002% ( 1300, 1900 ] 1 0.002% 100.004% ** Level 3 read latency histogram (micros): Count: 42809 Average: 4.4726 StdDev: 73.57 Min: 0 Median: 1.6901 Max: 4573 Percentiles: P50: 1.69 P75: 2.26 P99: 5.97 P99.9: 358.97 P99.99: 3784.83 ------------------------------------------------------ [ 0, 1 ] 2583 6.034% 6.034% # ( 1, 2 ] 27272 63.706% 69.740% ############# ( 2, 3 ] 8746 20.430% 90.170% #### ( 3, 4 ] 2042 4.770% 94.940% # ( 4, 6 ] 1762 4.116% 99.056% # ( 6, 10 ] 285 0.666% 99.722% ( 10, 15 ] 57 0.133% 99.855% ( 15, 22 ] 8 0.019% 99.874% ( 22, 34 ] 1 0.002% 99.876% ( 76, 110 ] 1 0.002% 99.879% ( 110, 170 ] 1 0.002% 99.881% ( 170, 250 ] 4 0.009% 99.890% ( 250, 380 ] 5 0.012% 99.902% ( 380, 580 ] 5 0.012% 99.914% ( 580, 870 ] 4 0.009% 99.923% ( 870, 1300 ] 7 0.016% 99.939% ( 1300, 1900 ] 3 0.007% 99.946% ( 1900, 2900 ] 14 0.033% 99.979% ( 2900, 4400 ] 8 0.019% 99.998% ( 4400, 6600 ] 1 0.002% 100.000% ** Level 4 read latency histogram (micros): Count: 310 Average: 131.4226 StdDev: 603.94 Min: 0 Median: 1.5610 Max: 6064 Percentiles: P50: 1.56 P75: 5.00 P99: 3575.00 P99.9: 6064.00 P99.99: 6064.00 ------------------------------------------------------ [ 0, 1 ] 86 27.742% 27.742% ###### ( 1, 2 ] 123 39.677% 67.419% ######## ( 2, 3 ] 14 4.516% 71.935% # ( 3, 4 ] 3 0.968% 72.903% ( 4, 6 ] 13 4.194% 77.097% # ( 6, 10 ] 37 11.935% 89.032% ## ( 10, 15 ] 6 1.935% 90.968% ( 110, 170 ] 1 0.323% 91.290% ( 170, 250 ] 3 0.968% 92.258% ( 380, 580 ] 8 2.581% 94.839% # ( 580, 870 ] 4 1.290% 96.129% ( 870, 1300 ] 3 0.968% 97.097% ( 1300, 1900 ] 1 0.323% 97.419% ( 1900, 2900 ] 4 1.290% 98.710% ( 2900, 4400 ] 2 0.645% 99.355% ( 4400, 6600 ] 2 0.645% 100.000% ** DB Stats ** Uptime(secs): 12.3 total, 3.0 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 321.16 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:1.644 H:M:S, 13.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 327.84 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.384 H:M:S, 12.8 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/19-20:12:44 ... thread 0: (1000000,5000000) ops and (244523.8,309484.1) ops/second in (4.089582,16.155920) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 14/11 2.58 GB 18.9 3.2 0.0 3.2 7.9 4.7 0.0 1.7 127.0 312.5 25.79 24.14 80 0.322 3326K 3423 0.0 0.0 L1 16/16 1.89 GB 0.0 2.9 1.9 1.0 2.9 1.9 0.2 1.5 230.2 228.8 13.09 12.65 3 4.364 3060K 17K 0.0 0.0 L2 1/0 4.21 MB 0.0 0.2 0.1 0.1 0.2 0.1 0.2 1.5 242.2 242.1 0.80 0.76 2 0.399 196K 84 0.0 0.0 L3 18/0 948.95 MB 0.9 0.2 0.2 0.0 0.2 0.2 0.1 1.0 232.7 232.7 0.80 0.75 1 0.804 189K 0 0.0 0.0 L4 173/0 9.76 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.0 1.0 137.2 137.2 1.23 0.86 1 1.227 170K 0 0.0 0.0 L5 1040/0 85.63 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 1262/27 100.79 GB 0.0 6.7 2.4 4.3 11.3 7.0 0.5 2.4 163.9 278.2 41.71 39.16 87 0.479 6944K 21K 0.0 0.0 Int 0/0 0.00 KB 0.0 6.7 2.4 4.3 11.3 7.0 0.4 2.4 163.9 278.2 41.71 39.16 87 0.479 6944K 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 6.7 2.4 4.3 6.7 2.4 0.0 0.0 243.0 242.2 28.14 27.03 19 1.481 6944K 21K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 4.7 4.7 0.0 0.0 0.0 352.8 13.57 12.13 68 0.200 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): 16.3 total, 16.2 interval Flush(GB): cumulative 4.676, interval 4.676 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 11.33 GB write, 709.89 MB/s write, 6.68 GB read, 418.34 MB/s read, 41.7 seconds Interval compaction: 11.33 GB write, 718.23 MB/s write, 6.68 GB read, 423.26 MB/s read, 41.7 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 6, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 6, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 14, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 6, total-stops: 14, interval: 20 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1397695 Average: 2.2289 StdDev: 13.03 Min: 0 Median: 1.4754 Max: 4509 Percentiles: P50: 1.48 P75: 1.85 P99: 5.45 P99.9: 9.99 P99.99: 132.88 ------------------------------------------------------ [ 0, 1 ] 255247 18.262% 18.262% #### ( 1, 2 ] 933148 66.763% 85.025% ############# ( 2, 3 ] 131767 9.427% 94.453% ## ( 3, 4 ] 45911 3.285% 97.738% # ( 4, 6 ] 24353 1.742% 99.480% ( 6, 10 ] 5881 0.421% 99.901% ( 10, 15 ] 859 0.061% 99.962% ( 15, 22 ] 71 0.005% 99.967% ( 22, 34 ] 22 0.002% 99.969% ( 34, 51 ] 5 0.000% 99.969% ( 51, 76 ] 18 0.001% 99.970% ( 76, 110 ] 184 0.013% 99.984% ( 110, 170 ] 234 0.017% 100.000% ( 170, 250 ] 110 0.008% 100.008% ( 250, 380 ] 78 0.006% 100.014% ( 380, 580 ] 50 0.004% 100.017% ( 580, 870 ] 42 0.003% 100.020% ( 870, 1300 ] 18 0.001% 100.022% ( 1300, 1900 ] 11 0.001% 100.022% ( 1900, 2900 ] 10 0.001% 100.023% ( 2900, 4400 ] 5 0.000% 100.024% ( 4400, 6600 ] 1 0.000% 100.024% ** Level 1 read latency histogram (micros): Count: 288766 Average: 2.3861 StdDev: 14.54 Min: 0 Median: 1.4854 Max: 3157 Percentiles: P50: 1.49 P75: 1.86 P99: 5.78 P99.9: 85.59 P99.99: 655.48 ------------------------------------------------------ [ 0, 1 ] 49803 17.247% 17.247% ### ( 1, 2 ] 194857 67.479% 84.726% ############# ( 2, 3 ] 27969 9.686% 94.412% ## ( 3, 4 ] 8676 3.005% 97.416% # ( 4, 6 ] 5139 1.780% 99.196% ( 6, 10 ] 1873 0.649% 99.845% ( 10, 15 ] 113 0.039% 99.884% ( 15, 22 ] 17 0.006% 99.890% ( 22, 34 ] 6 0.002% 99.892% ( 34, 51 ] 3 0.001% 99.893% ( 51, 76 ] 6 0.002% 99.895% ( 76, 110 ] 54 0.019% 99.913% ( 110, 170 ] 123 0.043% 99.956% ( 170, 250 ] 30 0.010% 99.966% ( 250, 380 ] 34 0.012% 99.978% ( 380, 580 ] 31 0.011% 99.989% ( 580, 870 ] 12 0.004% 99.993% ( 870, 1300 ] 13 0.005% 99.998% ( 1300, 1900 ] 5 0.002% 99.999% ( 1900, 2900 ] 1 0.000% 100.000% ( 2900, 4400 ] 1 0.000% 100.000% ** Level 2 read latency histogram (micros): Count: 47966 Average: 2.2365 StdDev: 6.50 Min: 1 Median: 1.5346 Max: 1307 Percentiles: P50: 1.53 P75: 1.90 P99: 5.79 P99.9: 9.93 P99.99: 23.22 ------------------------------------------------------ [ 0, 1 ] 6476 13.501% 13.501% ### ( 1, 2 ] 32748 68.273% 81.775% ############## ( 2, 3 ] 4988 10.399% 92.174% ## ( 3, 4 ] 2042 4.257% 96.431% # ( 4, 6 ] 1374 2.865% 99.295% # ( 6, 10 ] 295 0.615% 99.910% ( 10, 15 ] 29 0.060% 99.971% ( 15, 22 ] 9 0.019% 99.990% ( 22, 34 ] 2 0.004% 99.994% ( 34, 51 ] 1 0.002% 99.996% ( 170, 250 ] 2 0.004% 100.000% ( 380, 580 ] 1 0.002% 100.002% ( 1300, 1900 ] 1 0.002% 100.004% ** Level 3 read latency histogram (micros): Count: 42809 Average: 4.4726 StdDev: 73.57 Min: 0 Median: 1.6901 Max: 4573 Percentiles: P50: 1.69 P75: 2.26 P99: 5.97 P99.9: 358.97 P99.99: 3784.83 ------------------------------------------------------ [ 0, 1 ] 2583 6.034% 6.034% # ( 1, 2 ] 27272 63.706% 69.740% ############# ( 2, 3 ] 8746 20.430% 90.170% #### ( 3, 4 ] 2042 4.770% 94.940% # ( 4, 6 ] 1762 4.116% 99.056% # ( 6, 10 ] 285 0.666% 99.722% ( 10, 15 ] 57 0.133% 99.855% ( 15, 22 ] 8 0.019% 99.874% ( 22, 34 ] 1 0.002% 99.876% ( 76, 110 ] 1 0.002% 99.879% ( 110, 170 ] 1 0.002% 99.881% ( 170, 250 ] 4 0.009% 99.890% ( 250, 380 ] 5 0.012% 99.902% ( 380, 580 ] 5 0.012% 99.914% ( 580, 870 ] 4 0.009% 99.923% ( 870, 1300 ] 7 0.016% 99.939% ( 1300, 1900 ] 3 0.007% 99.946% ( 1900, 2900 ] 14 0.033% 99.979% ( 2900, 4400 ] 8 0.019% 99.998% ( 4400, 6600 ] 1 0.002% 100.000% ** Level 4 read latency histogram (micros): Count: 310 Average: 131.4226 StdDev: 603.94 Min: 0 Median: 1.5610 Max: 6064 Percentiles: P50: 1.56 P75: 5.00 P99: 3575.00 P99.9: 6064.00 P99.99: 6064.00 ------------------------------------------------------ [ 0, 1 ] 86 27.742% 27.742% ###### ( 1, 2 ] 123 39.677% 67.419% ######## ( 2, 3 ] 14 4.516% 71.935% # ( 3, 4 ] 3 0.968% 72.903% ( 4, 6 ] 13 4.194% 77.097% # ( 6, 10 ] 37 11.935% 89.032% ## ( 10, 15 ] 6 1.935% 90.968% ( 110, 170 ] 1 0.323% 91.290% ( 170, 250 ] 3 0.968% 92.258% ( 380, 580 ] 8 2.581% 94.839% # ( 580, 870 ] 4 1.290% 96.129% ( 870, 1300 ] 3 0.968% 97.097% ( 1300, 1900 ] 1 0.323% 97.419% ( 1900, 2900 ] 4 1.290% 98.710% ( 2900, 4400 ] 2 0.645% 99.355% ( 4400, 6600 ] 2 0.645% 100.000% ** DB Stats ** Uptime(secs): 16.3 total, 4.1 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 301.02 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.062 H:M:S, 18.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 240.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:1.419 H:M:S, 34.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/11/19-20:13:04 ... thread 0: (1000000,6000000) ops and (51001.8,167770.7) ops/second in (19.607169,35.763089) 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 2/2 1.10 GB 0.0 5.3 0.0 5.3 10.9 5.6 0.0 1.9 149.0 306.4 36.36 34.32 99 0.367 5499K 9039 0.0 0.0 L1 7/7 704.45 MB 0.0 7.2 4.3 2.9 7.1 4.2 0.2 1.7 224.2 221.4 33.00 30.70 4 8.250 7514K 93K 0.0 0.0 L2 1/0 4.21 MB 0.0 0.2 0.1 0.1 0.2 0.1 3.7 1.5 242.2 242.1 0.80 0.76 2 0.399 196K 84 0.0 0.0 L3 35/9 3.54 GB 2.5 0.2 0.2 0.0 0.2 0.2 3.6 1.0 232.7 232.7 0.80 0.75 1 0.804 189K 0 0.0 0.0 L4 184/24 10.67 GB 1.1 0.2 0.2 0.0 0.2 0.2 0.9 1.0 137.2 137.2 1.23 0.86 1 1.227 170K 0 0.0 0.0 L5 1040/0 85.63 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 1269/42 101.63 GB 0.0 13.1 4.8 8.3 18.5 10.3 8.4 3.3 185.1 263.1 72.19 67.38 107 0.675 13M 102K 0.0 0.0 Int 0/0 0.00 KB 0.0 13.1 4.8 8.3 18.5 10.3 8.3 3.3 185.1 263.1 72.19 67.38 107 0.675 13M 102K 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 13.1 4.8 8.3 13.0 4.7 0.0 0.0 239.0 237.2 55.92 52.85 25 2.237 13M 102K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 5.6 5.6 0.0 0.0 0.0 352.4 16.27 14.53 82 0.198 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): 36.0 total, 35.8 interval Flush(GB): cumulative 5.598, interval 5.598 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 18.55 GB write, 528.31 MB/s write, 13.05 GB read, 371.73 MB/s read, 72.2 seconds Interval compaction: 18.55 GB write, 531.11 MB/s write, 13.05 GB read, 373.70 MB/s read, 72.2 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 9, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 9, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 16, pending-compaction-bytes-delays: 8, pending-compaction-bytes-stops: 0, total-delays: 17, total-stops: 16, interval: 33 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2549914 Average: 2.6528 StdDev: 19.47 Min: 0 Median: 1.4492 Max: 5769 Percentiles: P50: 1.45 P75: 1.83 P99: 5.81 P99.9: 143.50 P99.99: 365.30 ------------------------------------------------------ [ 0, 1 ] 517809 20.307% 20.307% #### ( 1, 2 ] 1685563 66.103% 86.410% ############# ( 2, 3 ] 208968 8.195% 94.605% ## ( 3, 4 ] 74156 2.908% 97.513% # ( 4, 6 ] 41827 1.640% 99.153% ( 6, 10 ] 10869 0.426% 99.580% ( 10, 15 ] 1607 0.063% 99.643% ( 15, 22 ] 172 0.007% 99.649% ( 22, 34 ] 40 0.002% 99.651% ( 34, 51 ] 7 0.000% 99.651% ( 51, 76 ] 138 0.005% 99.657% ( 76, 110 ] 4541 0.178% 99.835% ( 110, 170 ] 2986 0.117% 99.952% ( 170, 250 ] 584 0.023% 99.975% ( 250, 380 ] 442 0.017% 99.992% ( 380, 580 ] 402 0.016% 100.008% ( 580, 870 ] 172 0.007% 100.014% ( 870, 1300 ] 46 0.002% 100.016% ( 1300, 1900 ] 25 0.001% 100.017% ( 1900, 2900 ] 18 0.001% 100.018% ( 2900, 4400 ] 27 0.001% 100.019% ( 4400, 6600 ] 4 0.000% 100.019% ** Level 1 read latency histogram (micros): Count: 829129 Average: 3.0534 StdDev: 35.39 Min: 0 Median: 1.4414 Max: 7663 Percentiles: P50: 1.44 P75: 1.84 P99: 7.32 P99.9: 150.68 P99.99: 535.79 ------------------------------------------------------ [ 0, 1 ] 185514 22.375% 22.375% #### ( 1, 2 ] 518953 62.590% 84.965% ############# ( 2, 3 ] 69186 8.344% 93.309% ## ( 3, 4 ] 25210 3.041% 96.350% # ( 4, 6 ] 19841 2.393% 98.743% ( 6, 10 ] 6471 0.780% 99.523% ( 10, 15 ] 712 0.086% 99.609% ( 15, 22 ] 91 0.011% 99.620% ( 22, 34 ] 14 0.002% 99.622% ( 34, 51 ] 8 0.001% 99.623% ( 51, 76 ] 104 0.013% 99.635% ( 76, 110 ] 1565 0.189% 99.824% ( 110, 170 ] 932 0.112% 99.936% ( 170, 250 ] 163 0.020% 99.956% ( 250, 380 ] 153 0.018% 99.974% ( 380, 580 ] 167 0.020% 99.995% ( 580, 870 ] 102 0.012% 100.007% ( 870, 1300 ] 57 0.007% 100.014% ( 1300, 1900 ] 33 0.004% 100.018% ( 1900, 2900 ] 27 0.003% 100.021% ( 2900, 4400 ] 39 0.005% 100.026% ( 4400, 6600 ] 4 0.000% 100.026% ( 6600, 9900 ] 1 0.000% 100.026% ** Level 2 read latency histogram (micros): Count: 47966 Average: 2.2365 StdDev: 6.50 Min: 1 Median: 1.5346 Max: 1307 Percentiles: P50: 1.53 P75: 1.90 P99: 5.79 P99.9: 9.93 P99.99: 23.22 ------------------------------------------------------ [ 0, 1 ] 6476 13.501% 13.501% ### ( 1, 2 ] 32748 68.273% 81.775% ############## ( 2, 3 ] 4988 10.399% 92.174% ## ( 3, 4 ] 2042 4.257% 96.431% # ( 4, 6 ] 1374 2.865% 99.295% # ( 6, 10 ] 295 0.615% 99.910% ( 10, 15 ] 29 0.060% 99.971% ( 15, 22 ] 9 0.019% 99.990% ( 22, 34 ] 2 0.004% 99.994% ( 34, 51 ] 1 0.002% 99.996% ( 170, 250 ] 2 0.004% 100.000% ( 380, 580 ] 1 0.002% 100.002% ( 1300, 1900 ] 1 0.002% 100.004% ** Level 3 read latency histogram (micros): Count: 42809 Average: 4.4726 StdDev: 73.57 Min: 0 Median: 1.6901 Max: 4573 Percentiles: P50: 1.69 P75: 2.26 P99: 5.97 P99.9: 358.97 P99.99: 3784.83 ------------------------------------------------------ [ 0, 1 ] 2583 6.034% 6.034% # ( 1, 2 ] 27272 63.706% 69.740% ############# ( 2, 3 ] 8746 20.430% 90.170% #### ( 3, 4 ] 2042 4.770% 94.940% # ( 4, 6 ] 1762 4.116% 99.056% # ( 6, 10 ] 285 0.666% 99.722% ( 10, 15 ] 57 0.133% 99.855% ( 15, 22 ] 8 0.019% 99.874% ( 22, 34 ] 1 0.002% 99.876% ( 76, 110 ] 1 0.002% 99.879% ( 110, 170 ] 1 0.002% 99.881% ( 170, 250 ] 4 0.009% 99.890% ( 250, 380 ] 5 0.012% 99.902% ( 380, 580 ] 5 0.012% 99.914% ( 580, 870 ] 4 0.009% 99.923% ( 870, 1300 ] 7 0.016% 99.939% ( 1300, 1900 ] 3 0.007% 99.946% ( 1900, 2900 ] 14 0.033% 99.979% ( 2900, 4400 ] 8 0.019% 99.998% ( 4400, 6600 ] 1 0.002% 100.000% ** Level 4 read latency histogram (micros): Count: 6223 Average: 107.7509 StdDev: 461.52 Min: 0 Median: 2.3874 Max: 7184 Percentiles: P50: 2.39 P75: 3.92 P99: 2551.84 P99.9: 4869.95 P99.99: 5817.76 ------------------------------------------------------ [ 0, 1 ] 174 2.796% 2.796% # ( 1, 2 ] 2356 37.860% 40.656% ######## ( 2, 3 ] 1501 24.120% 64.776% ##### ( 3, 4 ] 689 11.072% 75.848% ## ( 4, 6 ] 507 8.147% 83.995% ## ( 6, 10 ] 212 3.407% 87.402% # ( 10, 15 ] 43 0.691% 88.093% ( 15, 22 ] 8 0.129% 88.221% ( 22, 34 ] 1 0.016% 88.237% ( 76, 110 ] 7 0.112% 88.350% ( 110, 170 ] 43 0.691% 89.041% ( 170, 250 ] 108 1.735% 90.776% ( 250, 380 ] 132 2.121% 92.897% ( 380, 580 ] 125 2.009% 94.906% ( 580, 870 ] 123 1.977% 96.883% ( 870, 1300 ] 73 1.173% 98.056% ( 1300, 1900 ] 34 0.546% 98.602% ( 1900, 2900 ] 38 0.611% 99.213% ( 2900, 4400 ] 40 0.643% 99.855% ( 4400, 6600 ] 13 0.209% 100.064% ( 6600, 9900 ] 1 0.016% 100.080% ** DB Stats ** Uptime(secs): 36.0 total, 19.6 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 164.24 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:19.457 H:M:S, 54.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 50.20 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:16.394 H:M:S, 83.6 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 10 num-running-flushes: 1 2024/11/19-20:13:09 ... thread 0: (1000000,7000000) ops and (216035.5,173301.8) ops/second in (4.628869,40.391958) 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/6 2.09 GB 75.5 5.9 0.0 5.9 12.5 6.6 0.0 1.9 139.5 294.7 43.36 39.40 114 0.380 6139K 9786 0.0 0.0 L1 7/7 704.45 MB 0.0 7.2 4.3 2.9 7.1 4.2 0.2 1.7 224.2 221.4 33.00 30.70 4 8.250 7514K 93K 0.0 0.0 L2 1/0 4.21 MB 0.0 0.2 0.1 0.1 0.2 0.1 3.7 1.5 242.2 242.1 0.80 0.76 2 0.399 196K 84 0.0 0.0 L3 14/0 920.25 MB 0.9 0.2 0.2 0.0 0.2 0.2 3.6 1.0 232.7 232.7 0.80 0.75 1 0.804 189K 0 0.0 0.0 L4 153/0 9.68 GB 1.0 3.3 2.8 0.5 3.3 2.8 0.9 1.2 123.2 123.0 27.72 16.04 22 1.260 2988K 2217 0.0 0.0 L5 1084/0 89.26 GB 0.9 0.0 0.0 0.0 0.0 0.0 3.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1268/13 102.61 GB 0.0 16.8 7.4 9.4 23.3 13.9 12.0 3.5 163.1 225.9 105.68 87.64 143 0.739 17M 105K 0.0 0.0 Int 0/0 0.00 KB 0.0 16.8 7.4 9.4 23.3 13.9 11.9 3.5 163.1 225.9 105.68 87.64 143 0.739 17M 105K 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 16.8 7.4 9.4 16.7 7.3 0.0 0.0 203.1 201.8 84.91 70.43 48 1.769 17M 105K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 6.6 6.6 0.0 0.0 0.0 324.5 20.77 17.21 95 0.219 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): 40.6 total, 40.4 interval Flush(GB): cumulative 6.583, interval 6.583 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.31 GB write, 588.23 MB/s write, 16.84 GB read, 424.82 MB/s read, 105.7 seconds Interval compaction: 23.31 GB write, 591.00 MB/s write, 16.84 GB read, 426.82 MB/s read, 105.7 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 9, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 9, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 39, pending-compaction-bytes-delays: 8, pending-compaction-bytes-stops: 0, total-delays: 17, total-stops: 39, interval: 56 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2920427 Average: 2.8365 StdDev: 29.20 Min: 0 Median: 1.4870 Max: 7644 Percentiles: P50: 1.49 P75: 1.87 P99: 6.19 P99.9: 140.81 P99.99: 382.54 ------------------------------------------------------ [ 0, 1 ] 536435 18.368% 18.368% #### ( 1, 2 ] 1896950 64.955% 83.323% ############# ( 2, 3 ] 288476 9.878% 93.201% ## ( 3, 4 ] 100928 3.456% 96.657% # ( 4, 6 ] 67611 2.315% 98.972% ( 6, 10 ] 17769 0.608% 99.580% ( 10, 15 ] 2716 0.093% 99.673% ( 15, 22 ] 306 0.010% 99.684% ( 22, 34 ] 49 0.002% 99.685% ( 34, 51 ] 7 0.000% 99.686% ( 51, 76 ] 138 0.005% 99.690% ( 76, 110 ] 4569 0.156% 99.847% ( 110, 170 ] 3027 0.104% 99.950% ( 170, 250 ] 646 0.022% 99.973% ( 250, 380 ] 504 0.017% 99.990% ( 380, 580 ] 469 0.016% 100.006% ( 580, 870 ] 227 0.008% 100.014% ( 870, 1300 ] 90 0.003% 100.017% ( 1300, 1900 ] 45 0.002% 100.018% ( 1900, 2900 ] 51 0.002% 100.020% ( 2900, 4400 ] 69 0.002% 100.022% ( 4400, 6600 ] 17 0.001% 100.023% ( 6600, 9900 ] 5 0.000% 100.023% ** Level 1 read latency histogram (micros): Count: 1443293 Average: 4.7962 StdDev: 74.65 Min: 0 Median: 1.6529 Max: 9081 Percentiles: P50: 1.65 P75: 2.35 P99: 8.67 P99.9: 104.20 P99.99: 185.29 ------------------------------------------------------ [ 0, 1 ] 191631 13.277% 13.277% ### ( 1, 2 ] 811770 56.244% 69.522% ########### ( 2, 3 ] 227344 15.752% 85.273% ### ( 3, 4 ] 95395 6.610% 91.883% # ( 4, 6 ] 87999 6.097% 97.980% # ( 6, 10 ] 22045 1.527% 99.507% ( 10, 15 ] 3672 0.254% 99.762% ( 15, 22 ] 536 0.037% 99.799% ( 22, 34 ] 35 0.002% 99.801% ( 34, 51 ] 11 0.001% 99.802% ( 51, 76 ] 107 0.007% 99.810% ( 76, 110 ] 1573 0.109% 99.919% ( 110, 170 ] 985 0.068% 99.987% ( 170, 250 ] 239 0.017% 100.003% ( 250, 380 ] 313 0.022% 100.025% ( 380, 580 ] 404 0.028% 100.053% ( 580, 870 ] 397 0.028% 100.081% ( 870, 1300 ] 252 0.017% 100.098% ( 1300, 1900 ] 183 0.013% 100.111% ( 1900, 2900 ] 240 0.017% 100.127% ( 2900, 4400 ] 276 0.019% 100.146% ( 4400, 6600 ] 58 0.004% 100.150% ( 6600, 9900 ] 11 0.001% 100.151% ** Level 2 read latency histogram (micros): Count: 47966 Average: 2.2365 StdDev: 6.50 Min: 1 Median: 1.5346 Max: 1307 Percentiles: P50: 1.53 P75: 1.90 P99: 5.79 P99.9: 9.93 P99.99: 23.22 ------------------------------------------------------ [ 0, 1 ] 6476 13.501% 13.501% ### ( 1, 2 ] 32748 68.273% 81.775% ############## ( 2, 3 ] 4988 10.399% 92.174% ## ( 3, 4 ] 2042 4.257% 96.431% # ( 4, 6 ] 1374 2.865% 99.295% # ( 6, 10 ] 295 0.615% 99.910% ( 10, 15 ] 29 0.060% 99.971% ( 15, 22 ] 9 0.019% 99.990% ( 22, 34 ] 2 0.004% 99.994% ( 34, 51 ] 1 0.002% 99.996% ( 170, 250 ] 2 0.004% 100.000% ( 380, 580 ] 1 0.002% 100.002% ( 1300, 1900 ] 1 0.002% 100.004% ** Level 3 read latency histogram (micros): Count: 42809 Average: 4.4726 StdDev: 73.57 Min: 0 Median: 1.6901 Max: 4573 Percentiles: P50: 1.69 P75: 2.26 P99: 5.97 P99.9: 358.97 P99.99: 3784.83 ------------------------------------------------------ [ 0, 1 ] 2583 6.034% 6.034% # ( 1, 2 ] 27272 63.706% 69.740% ############# ( 2, 3 ] 8746 20.430% 90.170% #### ( 3, 4 ] 2042 4.770% 94.940% # ( 4, 6 ] 1762 4.116% 99.056% # ( 6, 10 ] 285 0.666% 99.722% ( 10, 15 ] 57 0.133% 99.855% ( 15, 22 ] 8 0.019% 99.874% ( 22, 34 ] 1 0.002% 99.876% ( 76, 110 ] 1 0.002% 99.879% ( 110, 170 ] 1 0.002% 99.881% ( 170, 250 ] 4 0.009% 99.890% ( 250, 380 ] 5 0.012% 99.902% ( 380, 580 ] 5 0.012% 99.914% ( 580, 870 ] 4 0.009% 99.923% ( 870, 1300 ] 7 0.016% 99.939% ( 1300, 1900 ] 3 0.007% 99.946% ( 1900, 2900 ] 14 0.033% 99.979% ( 2900, 4400 ] 8 0.019% 99.998% ( 4400, 6600 ] 1 0.002% 100.000% ** Level 4 read latency histogram (micros): Count: 137858 Average: 27.4768 StdDev: 229.45 Min: 0 Median: 1.9476 Max: 7184 Percentiles: P50: 1.95 P75: 2.95 P99: 729.72 P99.9: 3048.27 P99.99: 3879.11 ------------------------------------------------------ [ 0, 1 ] 2271 1.647% 1.647% ( 1, 2 ] 70343 51.026% 52.673% ########## ( 2, 3 ] 32432 23.526% 76.199% ##### ( 3, 4 ] 15227 11.045% 87.244% ## ( 4, 6 ] 11794 8.555% 95.799% ## ( 6, 10 ] 2143 1.554% 97.354% ( 10, 15 ] 484 0.351% 97.705% ( 15, 22 ] 42 0.030% 97.735% ( 22, 34 ] 6 0.004% 97.740% ( 34, 51 ] 6 0.004% 97.744% ( 51, 76 ] 2 0.001% 97.746% ( 76, 110 ] 30 0.022% 97.767% ( 110, 170 ] 119 0.086% 97.854% ( 170, 250 ] 287 0.208% 98.062% ( 250, 380 ] 410 0.297% 98.359% ( 380, 580 ] 553 0.401% 98.760% ( 580, 870 ] 640 0.464% 99.225% ( 870, 1300 ] 444 0.322% 99.547% ( 1300, 1900 ] 253 0.184% 99.730% ( 1900, 2900 ] 212 0.154% 99.884% ( 2900, 4400 ] 224 0.162% 100.046% ( 4400, 6600 ] 57 0.041% 100.088% ( 6600, 9900 ] 4 0.003% 100.091% ** Level 5 read latency histogram (micros): Count: 220 Average: 1206.2773 StdDev: 1209.13 Min: 79 Median: 690.4762 Max: 6298 Percentiles: P50: 690.48 P75: 1937.04 P99: 5390.00 P99.9: 6298.00 P99.99: 6298.00 ------------------------------------------------------ ( 76, 110 ] 8 3.636% 3.636% # ( 110, 170 ] 18 8.182% 11.818% ## ( 170, 250 ] 24 10.909% 22.727% ## ( 250, 380 ] 22 10.000% 32.727% ## ( 380, 580 ] 30 13.636% 46.364% ### ( 580, 870 ] 21 9.545% 55.909% ## ( 870, 1300 ] 24 10.909% 66.818% ## ( 1300, 1900 ] 17 7.727% 74.545% ## ( 1900, 2900 ] 27 12.273% 86.818% ## ( 2900, 4400 ] 25 11.364% 98.182% ## ( 4400, 6600 ] 4 1.818% 100.000% ** DB Stats ** Uptime(secs): 40.6 total, 4.6 interval Cumulative writes: 0 writes, 7000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 6.73 GB, 169.76 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:21.355 H:M:S, 52.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 212.62 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:1.898 H:M:S, 41.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/19-20:13:12 ... thread 0: (1000000,8000000) ops and (303081.6,183102.4) ops/second in (3.299442,43.691400) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 17/10 3.13 GB 151.0 6.4 0.0 6.4 14.0 7.6 0.0 1.8 135.6 297.1 48.30 44.00 130 0.372 6651K 10K 0.0 0.0 L1 7/7 704.45 MB 0.0 7.2 4.3 2.9 7.1 4.2 0.2 1.7 224.2 221.4 33.00 30.70 4 8.250 7514K 93K 0.0 0.0 L2 1/0 4.21 MB 0.0 0.2 0.1 0.1 0.2 0.1 3.7 1.5 242.2 242.1 0.80 0.76 2 0.399 196K 84 0.0 0.0 L3 14/0 920.25 MB 0.9 0.2 0.2 0.0 0.2 0.2 3.6 1.0 232.7 232.7 0.80 0.75 1 0.804 189K 0 0.0 0.0 L4 153/0 9.68 GB 1.0 3.3 2.8 0.5 3.3 2.8 0.9 1.2 123.2 123.0 27.72 16.04 22 1.260 2988K 2217 0.0 0.0 L5 1084/0 89.26 GB 0.9 0.0 0.0 0.0 0.0 0.0 3.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1276/17 103.66 GB 0.0 17.3 7.4 9.9 24.9 14.9 12.0 3.3 160.4 230.0 110.62 92.24 159 0.696 17M 106K 0.0 0.0 Int 0/0 0.00 KB 0.0 17.3 7.4 9.9 24.9 14.9 11.9 3.3 160.4 230.0 110.62 92.24 159 0.696 17M 106K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 17.3 7.4 9.9 17.2 7.3 0.0 0.0 204.5 203.2 86.78 72.26 50 1.736 17M 106K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 7.6 7.6 0.0 0.0 0.0 327.6 23.84 19.98 109 0.219 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): 43.9 total, 43.7 interval Flush(GB): cumulative 7.628, interval 7.628 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 24.85 GB write, 579.88 MB/s write, 17.33 GB read, 404.36 MB/s read, 110.6 seconds Interval compaction: 24.85 GB write, 582.40 MB/s write, 17.33 GB read, 406.12 MB/s read, 110.6 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 9, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 9, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 44, pending-compaction-bytes-delays: 8, pending-compaction-bytes-stops: 0, total-delays: 17, total-stops: 44, interval: 61 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3207475 Average: 2.7853 StdDev: 28.10 Min: 0 Median: 1.4919 Max: 7644 Percentiles: P50: 1.49 P75: 1.87 P99: 6.02 P99.9: 134.83 P99.99: 365.05 ------------------------------------------------------ [ 0, 1 ] 573606 17.883% 17.883% #### ( 1, 2 ] 2094082 65.288% 83.171% ############# ( 2, 3 ] 323481 10.085% 93.256% ## ( 3, 4 ] 111012 3.461% 96.717% # ( 4, 6 ] 73137 2.280% 98.997% ( 6, 10 ] 19465 0.607% 99.604% ( 10, 15 ] 3126 0.097% 99.702% ( 15, 22 ] 328 0.010% 99.712% ( 22, 34 ] 51 0.002% 99.714% ( 34, 51 ] 7 0.000% 99.714% ( 51, 76 ] 140 0.004% 99.718% ( 76, 110 ] 4576 0.143% 99.861% ( 110, 170 ] 3036 0.095% 99.955% ( 170, 250 ] 655 0.020% 99.976% ( 250, 380 ] 511 0.016% 99.992% ( 380, 580 ] 474 0.015% 100.007% ( 580, 870 ] 232 0.007% 100.014% ( 870, 1300 ] 95 0.003% 100.017% ( 1300, 1900 ] 45 0.001% 100.018% ( 1900, 2900 ] 53 0.002% 100.020% ( 2900, 4400 ] 69 0.002% 100.022% ( 4400, 6600 ] 18 0.001% 100.023% ( 6600, 9900 ] 5 0.000% 100.023% ** Level 1 read latency histogram (micros): Count: 1576164 Average: 4.6181 StdDev: 71.53 Min: 0 Median: 1.6427 Max: 9081 Percentiles: P50: 1.64 P75: 2.29 P99: 8.65 P99.9: 105.78 P99.99: 205.57 ------------------------------------------------------ [ 0, 1 ] 207431 13.160% 13.160% ### ( 1, 2 ] 903419 57.318% 70.478% ########### ( 2, 3 ] 243228 15.432% 85.910% ### ( 3, 4 ] 99614 6.320% 92.230% # ( 4, 6 ] 90734 5.757% 97.986% # ( 6, 10 ] 24156 1.533% 99.519% ( 10, 15 ] 3803 0.241% 99.760% ( 15, 22 ] 547 0.035% 99.795% ( 22, 34 ] 37 0.002% 99.797% ( 34, 51 ] 12 0.001% 99.798% ( 51, 76 ] 136 0.009% 99.807% ( 76, 110 ] 1679 0.107% 99.913% ( 110, 170 ] 1093 0.069% 99.983% ( 170, 250 ] 264 0.017% 99.999% ( 250, 380 ] 341 0.022% 100.021% ( 380, 580 ] 422 0.027% 100.048% ( 580, 870 ] 406 0.026% 100.073% ( 870, 1300 ] 256 0.016% 100.090% ( 1300, 1900 ] 184 0.012% 100.101% ( 1900, 2900 ] 240 0.015% 100.117% ( 2900, 4400 ] 276 0.018% 100.134% ( 4400, 6600 ] 58 0.004% 100.138% ( 6600, 9900 ] 11 0.001% 100.139% ** Level 2 read latency histogram (micros): Count: 47966 Average: 2.2365 StdDev: 6.50 Min: 1 Median: 1.5346 Max: 1307 Percentiles: P50: 1.53 P75: 1.90 P99: 5.79 P99.9: 9.93 P99.99: 23.22 ------------------------------------------------------ [ 0, 1 ] 6476 13.501% 13.501% ### ( 1, 2 ] 32748 68.273% 81.775% ############## ( 2, 3 ] 4988 10.399% 92.174% ## ( 3, 4 ] 2042 4.257% 96.431% # ( 4, 6 ] 1374 2.865% 99.295% # ( 6, 10 ] 295 0.615% 99.910% ( 10, 15 ] 29 0.060% 99.971% ( 15, 22 ] 9 0.019% 99.990% ( 22, 34 ] 2 0.004% 99.994% ( 34, 51 ] 1 0.002% 99.996% ( 170, 250 ] 2 0.004% 100.000% ( 380, 580 ] 1 0.002% 100.002% ( 1300, 1900 ] 1 0.002% 100.004% ** Level 3 read latency histogram (micros): Count: 42809 Average: 4.4726 StdDev: 73.57 Min: 0 Median: 1.6901 Max: 4573 Percentiles: P50: 1.69 P75: 2.26 P99: 5.97 P99.9: 358.97 P99.99: 3784.83 ------------------------------------------------------ [ 0, 1 ] 2583 6.034% 6.034% # ( 1, 2 ] 27272 63.706% 69.740% ############# ( 2, 3 ] 8746 20.430% 90.170% #### ( 3, 4 ] 2042 4.770% 94.940% # ( 4, 6 ] 1762 4.116% 99.056% # ( 6, 10 ] 285 0.666% 99.722% ( 10, 15 ] 57 0.133% 99.855% ( 15, 22 ] 8 0.019% 99.874% ( 22, 34 ] 1 0.002% 99.876% ( 76, 110 ] 1 0.002% 99.879% ( 110, 170 ] 1 0.002% 99.881% ( 170, 250 ] 4 0.009% 99.890% ( 250, 380 ] 5 0.012% 99.902% ( 380, 580 ] 5 0.012% 99.914% ( 580, 870 ] 4 0.009% 99.923% ( 870, 1300 ] 7 0.016% 99.939% ( 1300, 1900 ] 3 0.007% 99.946% ( 1900, 2900 ] 14 0.033% 99.979% ( 2900, 4400 ] 8 0.019% 99.998% ( 4400, 6600 ] 1 0.002% 100.000% ** Level 4 read latency histogram (micros): Count: 137858 Average: 27.4768 StdDev: 229.45 Min: 0 Median: 1.9476 Max: 7184 Percentiles: P50: 1.95 P75: 2.95 P99: 729.72 P99.9: 3048.27 P99.99: 3879.11 ------------------------------------------------------ [ 0, 1 ] 2271 1.647% 1.647% ( 1, 2 ] 70343 51.026% 52.673% ########## ( 2, 3 ] 32432 23.526% 76.199% ##### ( 3, 4 ] 15227 11.045% 87.244% ## ( 4, 6 ] 11794 8.555% 95.799% ## ( 6, 10 ] 2143 1.554% 97.354% ( 10, 15 ] 484 0.351% 97.705% ( 15, 22 ] 42 0.030% 97.735% ( 22, 34 ] 6 0.004% 97.740% ( 34, 51 ] 6 0.004% 97.744% ( 51, 76 ] 2 0.001% 97.746% ( 76, 110 ] 30 0.022% 97.767% ( 110, 170 ] 119 0.086% 97.854% ( 170, 250 ] 287 0.208% 98.062% ( 250, 380 ] 410 0.297% 98.359% ( 380, 580 ] 553 0.401% 98.760% ( 580, 870 ] 640 0.464% 99.225% ( 870, 1300 ] 444 0.322% 99.547% ( 1300, 1900 ] 253 0.184% 99.730% ( 1900, 2900 ] 212 0.154% 99.884% ( 2900, 4400 ] 224 0.162% 100.046% ( 4400, 6600 ] 57 0.041% 100.088% ( 6600, 9900 ] 4 0.003% 100.091% ** Level 5 read latency histogram (micros): Count: 220 Average: 1206.2773 StdDev: 1209.13 Min: 79 Median: 690.4762 Max: 6298 Percentiles: P50: 690.48 P75: 1937.04 P99: 5390.00 P99.9: 6298.00 P99.99: 6298.00 ------------------------------------------------------ ( 76, 110 ] 8 3.636% 3.636% # ( 110, 170 ] 18 8.182% 11.818% ## ( 170, 250 ] 24 10.909% 22.727% ## ( 250, 380 ] 22 10.000% 32.727% ## ( 380, 580 ] 30 13.636% 46.364% ### ( 580, 870 ] 21 9.545% 55.909% ## ( 870, 1300 ] 24 10.909% 66.818% ## ( 1300, 1900 ] 17 7.727% 74.545% ## ( 1900, 2900 ] 27 12.273% 86.818% ## ( 2900, 4400 ] 25 11.364% 98.182% ## ( 4400, 6600 ] 4 1.818% 100.000% ** DB Stats ** Uptime(secs): 43.9 total, 3.3 interval Cumulative writes: 0 writes, 8000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 7.69 GB, 179.42 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:22.017 H:M:S, 50.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 298.22 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.662 H:M:S, 20.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/11/19-20:13:15 ... thread 0: (1000000,9000000) ops and (329486.1,192610.5) ops/second in (3.035029,46.726429) 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/17 2.95 GB 12.6 7.2 0.0 7.2 15.7 8.5 0.0 1.8 136.3 298.0 54.07 49.40 146 0.370 7482K 11K 0.0 0.0 L1 23/23 1.78 GB 0.0 9.0 5.4 3.6 8.9 5.3 0.2 1.6 218.4 216.0 42.28 38.64 5 8.455 8660K 93K 0.0 0.0 L2 1/0 4.21 MB 0.0 0.2 0.1 0.1 0.2 0.1 3.7 1.5 242.2 242.1 0.80 0.76 2 0.399 196K 84 0.0 0.0 L3 14/0 920.25 MB 0.9 0.2 0.2 0.0 0.2 0.2 3.6 1.0 232.7 232.7 0.80 0.75 1 0.804 189K 0 0.0 0.0 L4 153/0 9.68 GB 1.0 3.3 2.8 0.5 3.3 2.8 0.9 1.2 123.2 123.0 27.72 16.04 22 1.260 2988K 2217 0.0 0.0 L5 1084/0 89.26 GB 0.9 0.0 0.0 0.0 0.0 0.0 3.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1294/40 104.57 GB 0.0 19.9 8.5 11.4 28.4 17.0 12.0 3.3 162.3 231.0 125.66 105.59 176 0.714 19M 106K 0.0 0.0 Int 0/0 0.00 KB 0.0 19.9 8.5 11.4 28.4 17.0 11.9 3.3 162.3 231.0 125.66 105.59 176 0.714 19M 106K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 19.9 8.5 11.4 19.8 8.4 0.0 0.0 205.7 204.5 99.13 83.23 54 1.836 19M 106K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 8.6 8.6 0.0 0.0 0.0 330.0 26.53 22.35 122 0.217 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 46.9 total, 46.7 interval Flush(GB): cumulative 8.551, interval 8.551 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 28.35 GB write, 618.82 MB/s write, 19.92 GB read, 434.73 MB/s read, 125.7 seconds Interval compaction: 28.35 GB write, 621.33 MB/s write, 19.92 GB read, 436.49 MB/s read, 125.7 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 9, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 9, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 48, pending-compaction-bytes-delays: 8, pending-compaction-bytes-stops: 0, total-delays: 17, total-stops: 48, interval: 65 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3402444 Average: 2.7565 StdDev: 27.53 Min: 0 Median: 1.4867 Max: 7644 Percentiles: P50: 1.49 P75: 1.87 P99: 5.98 P99.9: 133.73 P99.99: 364.39 ------------------------------------------------------ [ 0, 1 ] 620675 18.242% 18.242% #### ( 1, 2 ] 2219932 65.245% 83.487% ############# ( 2, 3 ] 337748 9.927% 93.414% ## ( 3, 4 ] 115556 3.396% 96.810% # ( 4, 6 ] 75138 2.208% 99.018% ( 6, 10 ] 20225 0.594% 99.613% ( 10, 15 ] 3317 0.097% 99.710% ( 15, 22 ] 354 0.010% 99.721% ( 22, 34 ] 53 0.002% 99.722% ( 34, 51 ] 12 0.000% 99.723% ( 51, 76 ] 142 0.004% 99.727% ( 76, 110 ] 4653 0.137% 99.864% ( 110, 170 ] 3134 0.092% 99.956% ( 170, 250 ] 697 0.020% 99.976% ( 250, 380 ] 535 0.016% 99.992% ( 380, 580 ] 489 0.014% 100.006% ( 580, 870 ] 246 0.007% 100.014% ( 870, 1300 ] 100 0.003% 100.017% ( 1300, 1900 ] 45 0.001% 100.018% ( 1900, 2900 ] 53 0.002% 100.019% ( 2900, 4400 ] 71 0.002% 100.021% ( 4400, 6600 ] 18 0.001% 100.022% ( 6600, 9900 ] 5 0.000% 100.022% ** Level 1 read latency histogram (micros): Count: 1642867 Average: 4.5560 StdDev: 70.22 Min: 0 Median: 1.6349 Max: 9081 Percentiles: P50: 1.63 P75: 2.26 P99: 8.65 P99.9: 108.29 P99.99: 225.41 ------------------------------------------------------ [ 0, 1 ] 219681 13.372% 13.372% ### ( 1, 2 ] 947777 57.690% 71.062% ############ ( 2, 3 ] 249143 15.165% 86.227% ### ( 3, 4 ] 101394 6.172% 92.399% # ( 4, 6 ] 91771 5.586% 97.985% # ( 6, 10 ] 25157 1.531% 99.516% ( 10, 15 ] 3884 0.236% 99.753% ( 15, 22 ] 556 0.034% 99.787% ( 22, 34 ] 37 0.002% 99.789% ( 34, 51 ] 12 0.001% 99.790% ( 51, 76 ] 138 0.008% 99.798% ( 76, 110 ] 1763 0.107% 99.905% ( 110, 170 ] 1193 0.073% 99.978% ( 170, 250 ] 284 0.017% 99.995% ( 250, 380 ] 363 0.022% 100.017% ( 380, 580 ] 443 0.027% 100.044% ( 580, 870 ] 415 0.025% 100.070% ( 870, 1300 ] 266 0.016% 100.086% ( 1300, 1900 ] 188 0.011% 100.097% ( 1900, 2900 ] 240 0.015% 100.112% ( 2900, 4400 ] 276 0.017% 100.129% ( 4400, 6600 ] 58 0.004% 100.132% ( 6600, 9900 ] 11 0.001% 100.133% ** Level 2 read latency histogram (micros): Count: 47966 Average: 2.2365 StdDev: 6.50 Min: 1 Median: 1.5346 Max: 1307 Percentiles: P50: 1.53 P75: 1.90 P99: 5.79 P99.9: 9.93 P99.99: 23.22 ------------------------------------------------------ [ 0, 1 ] 6476 13.501% 13.501% ### ( 1, 2 ] 32748 68.273% 81.775% ############## ( 2, 3 ] 4988 10.399% 92.174% ## ( 3, 4 ] 2042 4.257% 96.431% # ( 4, 6 ] 1374 2.865% 99.295% # ( 6, 10 ] 295 0.615% 99.910% ( 10, 15 ] 29 0.060% 99.971% ( 15, 22 ] 9 0.019% 99.990% ( 22, 34 ] 2 0.004% 99.994% ( 34, 51 ] 1 0.002% 99.996% ( 170, 250 ] 2 0.004% 100.000% ( 380, 580 ] 1 0.002% 100.002% ( 1300, 1900 ] 1 0.002% 100.004% ** Level 3 read latency histogram (micros): Count: 42809 Average: 4.4726 StdDev: 73.57 Min: 0 Median: 1.6901 Max: 4573 Percentiles: P50: 1.69 P75: 2.26 P99: 5.97 P99.9: 358.97 P99.99: 3784.83 ------------------------------------------------------ [ 0, 1 ] 2583 6.034% 6.034% # ( 1, 2 ] 27272 63.706% 69.740% ############# ( 2, 3 ] 8746 20.430% 90.170% #### ( 3, 4 ] 2042 4.770% 94.940% # ( 4, 6 ] 1762 4.116% 99.056% # ( 6, 10 ] 285 0.666% 99.722% ( 10, 15 ] 57 0.133% 99.855% ( 15, 22 ] 8 0.019% 99.874% ( 22, 34 ] 1 0.002% 99.876% ( 76, 110 ] 1 0.002% 99.879% ( 110, 170 ] 1 0.002% 99.881% ( 170, 250 ] 4 0.009% 99.890% ( 250, 380 ] 5 0.012% 99.902% ( 380, 580 ] 5 0.012% 99.914% ( 580, 870 ] 4 0.009% 99.923% ( 870, 1300 ] 7 0.016% 99.939% ( 1300, 1900 ] 3 0.007% 99.946% ( 1900, 2900 ] 14 0.033% 99.979% ( 2900, 4400 ] 8 0.019% 99.998% ( 4400, 6600 ] 1 0.002% 100.000% ** Level 4 read latency histogram (micros): Count: 137858 Average: 27.4768 StdDev: 229.45 Min: 0 Median: 1.9476 Max: 7184 Percentiles: P50: 1.95 P75: 2.95 P99: 729.72 P99.9: 3048.27 P99.99: 3879.11 ------------------------------------------------------ [ 0, 1 ] 2271 1.647% 1.647% ( 1, 2 ] 70343 51.026% 52.673% ########## ( 2, 3 ] 32432 23.526% 76.199% ##### ( 3, 4 ] 15227 11.045% 87.244% ## ( 4, 6 ] 11794 8.555% 95.799% ## ( 6, 10 ] 2143 1.554% 97.354% ( 10, 15 ] 484 0.351% 97.705% ( 15, 22 ] 42 0.030% 97.735% ( 22, 34 ] 6 0.004% 97.740% ( 34, 51 ] 6 0.004% 97.744% ( 51, 76 ] 2 0.001% 97.746% ( 76, 110 ] 30 0.022% 97.767% ( 110, 170 ] 119 0.086% 97.854% ( 170, 250 ] 287 0.208% 98.062% ( 250, 380 ] 410 0.297% 98.359% ( 380, 580 ] 553 0.401% 98.760% ( 580, 870 ] 640 0.464% 99.225% ( 870, 1300 ] 444 0.322% 99.547% ( 1300, 1900 ] 253 0.184% 99.730% ( 1900, 2900 ] 212 0.154% 99.884% ( 2900, 4400 ] 224 0.162% 100.046% ( 4400, 6600 ] 57 0.041% 100.088% ( 6600, 9900 ] 4 0.003% 100.091% ** Level 5 read latency histogram (micros): Count: 220 Average: 1206.2773 StdDev: 1209.13 Min: 79 Median: 690.4762 Max: 6298 Percentiles: P50: 690.48 P75: 1937.04 P99: 5390.00 P99.9: 6298.00 P99.99: 6298.00 ------------------------------------------------------ ( 76, 110 ] 8 3.636% 3.636% # ( 110, 170 ] 18 8.182% 11.818% ## ( 170, 250 ] 24 10.909% 22.727% ## ( 250, 380 ] 22 10.000% 32.727% ## ( 380, 580 ] 30 13.636% 46.364% ### ( 580, 870 ] 21 9.545% 55.909% ## ( 870, 1300 ] 24 10.909% 66.818% ## ( 1300, 1900 ] 17 7.727% 74.545% ## ( 1900, 2900 ] 27 12.273% 86.818% ## ( 2900, 4400 ] 25 11.364% 98.182% ## ( 4400, 6600 ] 4 1.818% 100.000% ** DB Stats ** Uptime(secs): 46.9 total, 3.0 interval Cumulative writes: 0 writes, 9000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 8.65 GB, 188.79 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:22.447 H:M:S, 47.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 324.36 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.431 H:M:S, 14.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 using bdev Nvme0n1 Initializing RocksDB Options from the specified file Initializing RocksDB Options from command-line flags Integrated BlobDB: blob cache disabled Keys: 16 bytes each (+ 0 bytes user-defined timestamp) Values: 1000 bytes each (1000 bytes after compression) Entries: 100000000 Prefix: 0 bytes Keys per prefix: 0 RawSize: 96893.3 MB (estimated) FileSize: 96893.3 MB (estimated) Write rate: 0 bytes/second Read rate: 0 ops/second Compression: NoCompression Compression sampling rate: 0 Memtablerep: SkipListFactory Perf Level: 1 ------------------------------------------------ DB path: [/mnt/rocksdb] overwrite : 6.323 micros/op 158146 ops/sec 60.071 seconds 9499999 operations; 153.2 MB/s Microseconds per write: Count: 9499999 Average: 6.3233 StdDev: 413.74 Min: 1 Median: 1.7268 Max: 748631 Percentiles: P50: 1.73 P75: 2.73 P99: 9.43 P99.9: 1204.26 P99.99: 2744.56 ------------------------------------------------------ [ 0, 1 ] 1334204 14.044% 14.044% ### ( 1, 2 ] 4699975 49.473% 63.518% ########## ( 2, 3 ] 1499786 15.787% 79.305% ### ( 3, 4 ] 1282961 13.505% 92.810% ### ( 4, 6 ] 491095 5.169% 97.979% # ( 6, 10 ] 113120 1.191% 99.170% ( 10, 15 ] 36559 0.385% 99.555% ( 15, 22 ] 8552 0.090% 99.645% ( 22, 34 ] 1799 0.019% 99.664% ( 34, 51 ] 240 0.003% 99.666% ( 51, 76 ] 16 0.000% 99.666% ( 76, 110 ] 6553 0.069% 99.735% ( 110, 170 ] 2615 0.028% 99.763% ( 170, 250 ] 285 0.003% 99.766% ( 250, 380 ] 169 0.002% 99.768% ( 380, 580 ] 22 0.000% 99.768% ( 580, 870 ] 17 0.000% 99.768% ( 870, 1300 ] 16120 0.170% 99.938% ( 1300, 1900 ] 22 0.000% 99.938% ( 1900, 2900 ] 5848 0.062% 100.000% ( 2900, 4400 ] 11 0.000% 100.000% ( 4400, 6600 ] 2 0.000% 100.000% ( 6600, 9900 ] 1 0.000% 100.000% ( 9900, 14000 ] 2 0.000% 100.000% ( 14000, 22000 ] 3 0.000% 100.000% ( 22000, 33000 ] 3 0.000% 100.000% ( 33000, 50000 ] 1 0.000% 100.000% ( 110000, 170000 ] 1 0.000% 100.000% ( 170000, 250000 ] 15 0.000% 100.000% ( 570000, 860000 ] 2 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 : 175520 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 : 9499999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 9803998968 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 : 452 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 34135364 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 : 25730348021 rocksdb.compact.write.bytes COUNT : 25564718175 rocksdb.flush.write.bytes COUNT : 9776396259 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 : 53 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 : 254 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 : 9697712128 rocksdb.memtable.garbage.bytes.at.flush COUNT : 3907584 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 : 25820286133 rocksdb.non.last.level.read.count COUNT : 6237039 rocksdb.block.checksum.compute.count COUNT : 6236188 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.370696 P95 : 3.907574 P99 : 8.036509 P100 : 748629.000000 COUNT : 9499999 SUM : 55664154 rocksdb.compaction.times.micros P50 : 1139677.419355 P95 : 6747500.000000 P99 : 17440000.000000 P100 : 19907959.000000 COUNT : 57 SUM : 102218631 rocksdb.compaction.times.cpu_micros P50 : 945000.000000 P95 : 6747500.000000 P99 : 17440000.000000 P100 : 18046450.000000 COUNT : 57 SUM : 86277619 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 : 665.410959 P95 : 1225.944444 P99 : 44730.000000 P100 : 58561.000000 COUNT : 131 SUM : 218988 rocksdb.compaction.outfile.sync.micros P50 : 928.636364 P95 : 91187.500000 P99 : 152840.000000 P100 : 167845.000000 COUNT : 286 SUM : 3784031 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 : 102.444444 P95 : 919.142857 P99 : 1692.000000 P100 : 3114.000000 COUNT : 204 SUM : 41797 rocksdb.table.open.io.micros P50 : 1456.521739 P95 : 7871.111111 P99 : 10911.333333 P100 : 12055.000000 COUNT : 452 SUM : 939779 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.552999 P95 : 6.649540 P99 : 9.958614 P100 : 10622.000000 COUNT : 6234916 SUM : 35977063 rocksdb.read.block.get.micros P50 : 459.545455 P95 : 3335.294118 P99 : 4398.823529 P100 : 6411.000000 COUNT : 904 SUM : 755695 rocksdb.write.raw.block.micros P50 : 0.511886 P95 : 0.972584 P99 : 2.766206 P100 : 13790.000000 COUNT : 8559435 SUM : 16649753 rocksdb.numfiles.in.singlecompaction P50 : 3.477941 P95 : 6.900000 P99 : 35.530000 P100 : 36.000000 COUNT : 91 SUM : 417 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.561854 P95 : 1189.472751 P99 : 2561.779603 P100 : 748446.000000 COUNT : 200456 SUM : 34153313 rocksdb.sst.read.micros P50 : 1.509308 P95 : 3.884350 P99 : 7.666197 P100 : 9081.000000 COUNT : 6237258 SUM : 23453689 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 : 9499999 SUM : 9803998968 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 : 212857.142857 P95 : 366566.666667 P99 : 770100.000000 P100 : 940552.000000 COUNT : 131 SUM : 28145131 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 : 280 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