[2024-11-17 03:26:39.033289] Starting SPDK v24.01.1-pre git sha1 c13c99a5e / DPDK 23.11.0 initialization... [2024-11-17 03:26:39.033407] [ DPDK EAL parameters: rocksdb --no-shconf -c 0x1 --huge-unlink --no-telemetry --log-level=lib.eal:6 --log-level=lib.cryptodev:5 --log-level=user1:6 --base-virtaddr=0x200000000000 --match-allocations --file-prefix=spdk_pid1979221 ] Set seed to 1731810399030931 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-11-17 03:26:39.137722] app.c: 798:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-11-17 03:26:39.352710] app.c: 488:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-11-17 03:26:39.352759] app.c: 489:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 1979221' to capture a snapshot of events at runtime. [2024-11-17 03:26:39.352770] app.c: 494:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid1979221 for offline analysis/debug. [2024-11-17 03:26:39.352795] reactor.c: 937:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Sun Nov 17 03:26:47 2024 CPU: 96 * Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz CPUCache: 36608 KB 2024/11/17-03:26:50 ... thread 0: (1000000,1000000) ops and (364902.9,364902.9) ops/second in (2.740455,2.740455) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 8/8 504.04 MB 0.0 0.0 0.0 0.0 0.8 0.8 0.0 1.0 0.0 359.8 2.28 2.05 12 0.190 0 0 0.0 0.0 L1 3/3 188.87 MB 0.0 0.2 0.2 0.0 0.2 0.2 0.1 1.0 255.5 255.4 0.74 0.71 1 0.739 191K 73 0.0 0.0 L2 2/1 125.96 MB 0.0 0.1 0.1 0.1 0.1 0.1 0.1 2.0 236.1 236.0 0.53 0.51 1 0.534 127K 45 0.0 0.0 L3 8/0 678.10 MB 0.7 0.0 0.0 0.0 0.0 0.0 0.2 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 116/0 9.60 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1044/0 85.88 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1181/12 96.94 GB 0.0 0.3 0.2 0.1 1.1 1.0 1.1 1.4 88.7 319.4 3.55 3.28 14 0.254 319K 118 0.0 0.0 Int 0/0 0.00 KB 0.0 0.3 0.2 0.1 1.1 1.0 0.9 1.4 88.7 319.4 3.55 3.28 14 0.254 319K 118 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.3 0.2 0.1 0.3 0.2 0.0 0.0 247.4 247.3 1.27 1.22 2 0.637 319K 118 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 359.8 2.28 2.05 12 0.190 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 3.0 total, 2.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: 1.11 GB write, 381.02 MB/s write, 0.31 GB read, 105.84 MB/s read, 3.5 seconds Interval compaction: 1.11 GB write, 413.47 MB/s write, 0.31 GB read, 114.85 MB/s read, 3.5 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 1, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 1, interval: 1 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 113355 Average: 1.9477 StdDev: 23.25 Min: 1 Median: 1.2381 Max: 4256 Percentiles: P50: 1.24 P75: 1.66 P99: 4.31 P99.9: 9.59 P99.99: 293.19 ------------------------------------------------------ [ 0, 1 ] 40867 36.052% 36.052% ####### ( 1, 2 ] 66415 58.590% 94.642% ############ ( 2, 3 ] 3324 2.932% 97.575% # ( 3, 4 ] 1482 1.307% 98.882% ( 4, 6 ] 869 0.767% 99.649% ( 6, 10 ] 319 0.281% 99.930% ( 10, 15 ] 43 0.038% 99.968% ( 15, 22 ] 15 0.013% 99.981% ( 51, 76 ] 1 0.001% 99.982% ( 110, 170 ] 7 0.006% 99.989% ( 170, 250 ] 3 0.003% 99.991% ( 250, 380 ] 2 0.002% 99.993% ( 380, 580 ] 5 0.004% 99.997% ( 580, 870 ] 1 0.001% 99.998% ( 870, 1300 ] 1 0.001% 99.999% ( 1900, 2900 ] 2 0.002% 100.001% ( 2900, 4400 ] 3 0.003% 100.004% ** Level 1 read latency histogram (micros): Count: 20387 Average: 1.8824 StdDev: 9.00 Min: 0 Median: 1.2688 Max: 992 Percentiles: P50: 1.27 P75: 1.68 P99: 4.01 P99.9: 8.47 P99.99: 377.48 ------------------------------------------------------ [ 0, 1 ] 6884 33.767% 33.767% ####### ( 1, 2 ] 12310 60.382% 94.148% ############ ( 2, 3 ] 673 3.301% 97.449% # ( 3, 4 ] 316 1.550% 98.999% ( 4, 6 ] 163 0.800% 99.799% ( 6, 10 ] 35 0.172% 99.971% ( 10, 15 ] 2 0.010% 99.980% ( 170, 250 ] 1 0.005% 99.985% ( 250, 380 ] 2 0.010% 99.995% ( 580, 870 ] 1 0.005% 100.000% ( 870, 1300 ] 1 0.005% 100.005% ** Level 2 read latency histogram (micros): Count: 5570 Average: 5.3302 StdDev: 85.79 Min: 0 Median: 1.6572 Max: 4280 Percentiles: P50: 1.66 P75: 2.35 P99: 9.65 P99.9: 523.00 P99.99: 3982.25 ------------------------------------------------------ [ 0, 1 ] 640 11.490% 11.490% ## ( 1, 2 ] 3264 58.600% 70.090% ############ ( 2, 3 ] 790 14.183% 84.273% ### ( 3, 4 ] 347 6.230% 90.503% # ( 4, 6 ] 362 6.499% 97.002% # ( 6, 10 ] 122 2.190% 99.192% ( 10, 15 ] 26 0.467% 99.659% ( 15, 22 ] 4 0.072% 99.731% ( 22, 34 ] 1 0.018% 99.749% ( 51, 76 ] 2 0.036% 99.785% ( 76, 110 ] 1 0.018% 99.803% ( 170, 250 ] 2 0.036% 99.838% ( 250, 380 ] 2 0.036% 99.874% ( 380, 580 ] 2 0.036% 99.910% ( 1300, 1900 ] 1 0.018% 99.928% ( 1900, 2900 ] 2 0.036% 99.964% ( 2900, 4400 ] 2 0.036% 100.000% ** Level 3 read latency histogram (micros): Count: 50 Average: 3445.1200 StdDev: 2423.00 Min: 62 Median: 2809.0909 Max: 10280 Percentiles: P50: 2809.09 P75: 4226.92 P99: 10280.00 P99.9: 10280.00 P99.99: 10280.00 ------------------------------------------------------ ( 51, 76 ] 1 2.000% 2.000% ( 250, 380 ] 3 6.000% 8.000% # ( 870, 1300 ] 2 4.000% 12.000% # ( 1300, 1900 ] 9 18.000% 30.000% #### ( 1900, 2900 ] 11 22.000% 52.000% #### ( 2900, 4400 ] 13 26.000% 78.000% ##### ( 4400, 6600 ] 4 8.000% 86.000% ## ( 6600, 9900 ] 6 12.000% 98.000% ## ( 9900, 14000 ] 1 2.000% 100.000% ** Level 4 read latency histogram (micros): Count: 20 Average: 3871.4500 StdDev: 2792.07 Min: 571 Median: 2733.3333 Max: 9871 Percentiles: P50: 2733.33 P75: 5866.67 P99: 9735.00 P99.9: 9871.00 P99.99: 9871.00 ------------------------------------------------------ ( 380, 580 ] 1 5.000% 5.000% # ( 870, 1300 ] 1 5.000% 10.000% # ( 1300, 1900 ] 3 15.000% 25.000% ### ( 1900, 2900 ] 6 30.000% 55.000% ###### ( 2900, 4400 ] 2 10.000% 65.000% ## ( 4400, 6600 ] 3 15.000% 80.000% ### ( 6600, 9900 ] 4 20.000% 100.000% #### ** Level 5 read latency histogram (micros): Count: 20 Average: 699.6500 StdDev: 915.28 Min: 51 Median: 146.0000 Max: 2755 Percentiles: P50: 146.00 P75: 870.00 P99: 2755.00 P99.9: 2755.00 P99.99: 2755.00 ------------------------------------------------------ ( 34, 51 ] 1 5.000% 5.000% # ( 76, 110 ] 6 30.000% 35.000% ###### ( 110, 170 ] 5 25.000% 60.000% ##### ( 580, 870 ] 3 15.000% 75.000% ### ( 870, 1300 ] 1 5.000% 80.000% # ( 1900, 2900 ] 4 20.000% 100.000% #### ** DB Stats ** Uptime(secs): 3.0 total, 2.7 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 330.70 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.205 H:M:S, 6.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 358.77 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.205 H:M:S, 7.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/11/17-03:26:53 ... thread 0: (1000000,2000000) ops and (333342.8,348409.6) ops/second in (2.999915,5.740370) 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 1.23 GB 18.9 0.8 0.0 0.8 2.6 1.8 0.0 1.4 100.3 323.9 8.17 7.58 29 0.282 831K 849 0.0 0.0 L1 1/1 3.04 MB 0.0 0.6 0.4 0.2 0.6 0.4 0.1 1.4 240.2 239.9 2.62 2.54 2 1.311 639K 815 0.0 0.0 L2 5/3 437.96 MB 0.5 0.1 0.1 0.1 0.1 0.1 0.5 2.0 236.1 236.0 0.53 0.51 1 0.534 127K 45 0.0 0.0 L3 16/1 803.15 MB 0.7 0.1 0.1 0.0 0.1 0.1 0.2 1.0 207.0 207.0 0.60 0.54 1 0.604 126K 0 0.0 0.0 L4 116/0 9.60 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1044/0 85.88 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1191/11 97.92 GB 0.0 1.7 0.6 1.0 3.4 2.4 1.5 1.9 142.5 295.6 11.93 11.18 33 0.361 1726K 1709 0.0 0.0 Int 0/0 0.00 KB 0.0 1.7 0.6 1.0 3.4 2.4 1.3 1.9 142.5 295.6 11.93 11.18 33 0.361 1726K 1709 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.7 0.6 1.0 1.7 0.6 0.0 0.0 248.9 248.6 6.83 6.61 7 0.976 1726K 1709 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 358.5 5.10 4.57 26 0.196 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.7 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.44 GB write, 589.89 MB/s write, 1.66 GB read, 284.47 MB/s read, 11.9 seconds Interval compaction: 3.44 GB write, 613.89 MB/s write, 1.66 GB read, 296.04 MB/s read, 11.9 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: 5, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 5, interval: 5 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 378755 Average: 2.1010 StdDev: 15.57 Min: 1 Median: 1.4135 Max: 4256 Percentiles: P50: 1.41 P75: 1.80 P99: 5.42 P99.9: 9.78 P99.99: 21.00 ------------------------------------------------------ [ 0, 1 ] 89062 23.514% 23.514% ##### ( 1, 2 ] 242617 64.056% 87.571% ############# ( 2, 3 ] 27614 7.291% 94.862% # ( 3, 4 ] 10868 2.869% 97.731% # ( 4, 6 ] 6758 1.784% 99.515% ( 6, 10 ] 1543 0.407% 99.923% ( 10, 15 ] 226 0.060% 99.982% ( 15, 22 ] 34 0.009% 99.991% ( 22, 34 ] 3 0.001% 99.992% ( 34, 51 ] 2 0.001% 99.993% ( 51, 76 ] 3 0.001% 99.993% ( 110, 170 ] 13 0.003% 99.997% ( 170, 250 ] 9 0.002% 99.999% ( 250, 380 ] 6 0.002% 100.001% ( 380, 580 ] 11 0.003% 100.004% ( 580, 870 ] 5 0.001% 100.005% ( 870, 1300 ] 7 0.002% 100.007% ( 1900, 2900 ] 3 0.001% 100.008% ( 2900, 4400 ] 4 0.001% 100.009% ** Level 1 read latency histogram (micros): Count: 100797 Average: 2.2163 StdDev: 9.22 Min: 0 Median: 1.5133 Max: 1772 Percentiles: P50: 1.51 P75: 1.89 P99: 5.62 P99.9: 10.01 P99.99: 246.81 ------------------------------------------------------ [ 0, 1 ] 16032 15.905% 15.905% ### ( 1, 2 ] 66954 66.425% 82.330% ############# ( 2, 3 ] 11402 11.312% 93.642% ## ( 3, 4 ] 3425 3.398% 97.040% # ( 4, 6 ] 2442 2.423% 99.462% ( 6, 10 ] 441 0.438% 99.900% ( 10, 15 ] 80 0.079% 99.979% ( 15, 22 ] 7 0.007% 99.986% ( 22, 34 ] 1 0.001% 99.987% ( 110, 170 ] 1 0.001% 99.988% ( 170, 250 ] 2 0.002% 99.990% ( 250, 380 ] 2 0.002% 99.992% ( 380, 580 ] 3 0.003% 99.995% ( 580, 870 ] 1 0.001% 99.996% ( 870, 1300 ] 3 0.003% 99.999% ( 1300, 1900 ] 1 0.001% 100.000% ** Level 2 read latency histogram (micros): Count: 31763 Average: 2.8785 StdDev: 35.96 Min: 0 Median: 1.6091 Max: 4280 Percentiles: P50: 1.61 P75: 2.03 P99: 7.53 P99.9: 14.21 P99.99: 2311.85 ------------------------------------------------------ [ 0, 1 ] 3686 11.605% 11.605% ## ( 1, 2 ] 20023 63.039% 74.643% ############# ( 2, 3 ] 4103 12.918% 87.561% ### ( 3, 4 ] 1837 5.783% 93.344% # ( 4, 6 ] 1655 5.210% 98.555% # ( 6, 10 ] 370 1.165% 99.720% ( 10, 15 ] 68 0.214% 99.934% ( 15, 22 ] 6 0.019% 99.953% ( 22, 34 ] 1 0.003% 99.956% ( 51, 76 ] 2 0.006% 99.962% ( 76, 110 ] 1 0.003% 99.965% ( 170, 250 ] 2 0.006% 99.972% ( 250, 380 ] 2 0.006% 99.978% ( 380, 580 ] 2 0.006% 99.984% ( 1300, 1900 ] 1 0.003% 99.987% ( 1900, 2900 ] 2 0.006% 99.994% ( 2900, 4400 ] 2 0.006% 100.000% ** Level 3 read latency histogram (micros): Count: 15196 Average: 13.6479 StdDev: 241.41 Min: 1 Median: 1.5621 Max: 10280 Percentiles: P50: 1.56 P75: 1.93 P99: 6.20 P99.9: 3915.85 P99.99: 9614.22 ------------------------------------------------------ [ 0, 1 ] 1838 12.095% 12.095% ## ( 1, 2 ] 10248 67.439% 79.534% ############# ( 2, 3 ] 1974 12.990% 92.524% ### ( 3, 4 ] 586 3.856% 96.381% # ( 4, 6 ] 394 2.593% 98.973% # ( 6, 10 ] 80 0.526% 99.500% ( 10, 15 ] 21 0.138% 99.638% ( 15, 22 ] 1 0.007% 99.645% ( 22, 34 ] 1 0.007% 99.651% ( 51, 76 ] 1 0.007% 99.658% ( 76, 110 ] 1 0.007% 99.664% ( 250, 380 ] 3 0.020% 99.684% ( 380, 580 ] 1 0.007% 99.691% ( 870, 1300 ] 3 0.020% 99.710% ( 1300, 1900 ] 9 0.059% 99.770% ( 1900, 2900 ] 11 0.072% 99.842% ( 2900, 4400 ] 13 0.086% 99.928% ( 4400, 6600 ] 4 0.026% 99.954% ( 6600, 9900 ] 6 0.039% 99.993% ( 9900, 14000 ] 1 0.007% 100.000% ** Level 4 read latency histogram (micros): Count: 20 Average: 3871.4500 StdDev: 2792.07 Min: 571 Median: 2733.3333 Max: 9871 Percentiles: P50: 2733.33 P75: 5866.67 P99: 9735.00 P99.9: 9871.00 P99.99: 9871.00 ------------------------------------------------------ ( 380, 580 ] 1 5.000% 5.000% # ( 870, 1300 ] 1 5.000% 10.000% # ( 1300, 1900 ] 3 15.000% 25.000% ### ( 1900, 2900 ] 6 30.000% 55.000% ###### ( 2900, 4400 ] 2 10.000% 65.000% ## ( 4400, 6600 ] 3 15.000% 80.000% ### ( 6600, 9900 ] 4 20.000% 100.000% #### ** Level 5 read latency histogram (micros): Count: 20 Average: 699.6500 StdDev: 915.28 Min: 51 Median: 146.0000 Max: 2755 Percentiles: P50: 146.00 P75: 870.00 P99: 2755.00 P99.9: 2755.00 P99.99: 2755.00 ------------------------------------------------------ ( 34, 51 ] 1 5.000% 5.000% # ( 76, 110 ] 6 30.000% 35.000% ###### ( 110, 170 ] 5 25.000% 60.000% ##### ( 580, 870 ] 3 15.000% 75.000% ### ( 870, 1300 ] 1 5.000% 80.000% # ( 1900, 2900 ] 4 20.000% 100.000% #### ** DB Stats ** Uptime(secs): 6.0 total, 3.0 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 329.39 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:0.588 H:M:S, 9.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 328.08 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.383 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/17-03:26:56 ... thread 0: (1000000,3000000) ops and (327162.2,341027.0) ops/second in (3.056588,8.796958) 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/14 2.21 GB 62.9 1.3 0.0 1.3 4.1 2.8 0.0 1.5 102.3 321.4 12.93 12.00 45 0.287 1343K 1371 0.0 0.0 L1 1/1 3.04 MB 0.0 0.6 0.4 0.2 0.6 0.4 0.1 1.4 240.2 239.9 2.62 2.54 2 1.311 639K 815 0.0 0.0 L2 2/0 51.67 MB 0.5 0.1 0.1 0.1 0.1 0.1 0.5 2.0 236.1 236.0 0.53 0.51 1 0.534 127K 45 0.0 0.0 L3 49/0 976.98 MB 1.0 0.6 0.5 0.1 0.6 0.5 0.2 1.2 195.6 195.5 3.19 2.76 2 1.594 633K 493 0.0 0.0 L4 136/0 9.50 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1048/0 86.19 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1253/15 98.90 GB 0.0 2.6 1.0 1.6 5.4 3.8 2.0 2.0 140.2 287.1 19.28 17.81 50 0.386 2744K 2724 0.0 0.0 Int 0/0 0.00 KB 0.0 2.6 1.0 1.6 5.4 3.8 1.9 2.0 140.2 287.1 19.28 17.81 50 0.386 2744K 2724 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.6 1.0 1.6 2.6 1.0 0.0 0.0 238.6 238.3 11.33 10.70 10 1.133 2744K 2724 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 356.7 7.95 7.12 40 0.199 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 9.0 total, 8.8 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.40 GB write, 612.76 MB/s write, 2.64 GB read, 299.21 MB/s read, 19.3 seconds Interval compaction: 5.40 GB write, 629.02 MB/s write, 2.64 GB read, 307.15 MB/s read, 19.3 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 9, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 9, interval: 9 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 737042 Average: 2.1601 StdDev: 13.57 Min: 1 Median: 1.4727 Max: 4256 Percentiles: P50: 1.47 P75: 1.85 P99: 5.46 P99.9: 9.66 P99.99: 14.75 ------------------------------------------------------ [ 0, 1 ] 137654 18.677% 18.677% #### ( 1, 2 ] 488416 66.267% 84.944% ############# ( 2, 3 ] 68217 9.256% 94.199% ## ( 3, 4 ] 24484 3.322% 97.521% # ( 4, 6 ] 14893 2.021% 99.542% ( 6, 10 ] 2891 0.392% 99.934% ( 10, 15 ] 437 0.059% 99.993% ( 15, 22 ] 46 0.006% 99.999% ( 22, 34 ] 5 0.001% 100.000% ( 34, 51 ] 5 0.001% 100.001% ( 51, 76 ] 5 0.001% 100.001% ( 110, 170 ] 16 0.002% 100.004% ( 170, 250 ] 17 0.002% 100.006% ( 250, 380 ] 8 0.001% 100.007% ( 380, 580 ] 14 0.002% 100.009% ( 580, 870 ] 15 0.002% 100.011% ( 870, 1300 ] 9 0.001% 100.012% ( 1300, 1900 ] 1 0.000% 100.012% ( 1900, 2900 ] 3 0.000% 100.013% ( 2900, 4400 ] 7 0.001% 100.014% ** Level 1 read latency histogram (micros): Count: 146061 Average: 2.2639 StdDev: 7.68 Min: 0 Median: 1.5546 Max: 1772 Percentiles: P50: 1.55 P75: 1.93 P99: 5.69 P99.9: 10.49 P99.99: 31.58 ------------------------------------------------------ [ 0, 1 ] 19344 13.244% 13.244% ### ( 1, 2 ] 96799 66.273% 79.517% ############# ( 2, 3 ] 19041 13.036% 92.553% ### ( 3, 4 ] 5805 3.974% 96.527% # ( 4, 6 ] 4262 2.918% 99.445% # ( 6, 10 ] 651 0.446% 99.891% ( 10, 15 ] 132 0.090% 99.982% ( 15, 22 ] 10 0.007% 99.988% ( 22, 34 ] 3 0.002% 99.990% ( 51, 76 ] 1 0.001% 99.991% ( 110, 170 ] 1 0.001% 99.992% ( 170, 250 ] 2 0.001% 99.993% ( 250, 380 ] 2 0.001% 99.995% ( 380, 580 ] 3 0.002% 99.997% ( 580, 870 ] 1 0.001% 99.997% ( 870, 1300 ] 3 0.002% 99.999% ( 1300, 1900 ] 1 0.001% 100.000% ** Level 2 read latency histogram (micros): Count: 31763 Average: 2.8785 StdDev: 35.96 Min: 0 Median: 1.6091 Max: 4280 Percentiles: P50: 1.61 P75: 2.03 P99: 7.53 P99.9: 14.21 P99.99: 2311.85 ------------------------------------------------------ [ 0, 1 ] 3686 11.605% 11.605% ## ( 1, 2 ] 20023 63.039% 74.643% ############# ( 2, 3 ] 4103 12.918% 87.561% ### ( 3, 4 ] 1837 5.783% 93.344% # ( 4, 6 ] 1655 5.210% 98.555% # ( 6, 10 ] 370 1.165% 99.720% ( 10, 15 ] 68 0.214% 99.934% ( 15, 22 ] 6 0.019% 99.953% ( 22, 34 ] 1 0.003% 99.956% ( 51, 76 ] 2 0.006% 99.962% ( 76, 110 ] 1 0.003% 99.965% ( 170, 250 ] 2 0.006% 99.972% ( 250, 380 ] 2 0.006% 99.978% ( 380, 580 ] 2 0.006% 99.984% ( 1300, 1900 ] 1 0.003% 99.987% ( 1900, 2900 ] 2 0.006% 99.994% ( 2900, 4400 ] 2 0.006% 100.000% ** Level 3 read latency histogram (micros): Count: 28895 Average: 8.4051 StdDev: 175.20 Min: 0 Median: 1.5917 Max: 10280 Percentiles: P50: 1.59 P75: 1.97 P99: 6.53 P99.9: 2455.00 P99.99: 8860.77 ------------------------------------------------------ [ 0, 1 ] 3032 10.493% 10.493% ## ( 1, 2 ] 19293 66.769% 77.263% ############# ( 2, 3 ] 4041 13.985% 91.248% ### ( 3, 4 ] 1297 4.489% 95.736% # ( 4, 6 ] 924 3.198% 98.934% # ( 6, 10 ] 145 0.502% 99.436% ( 10, 15 ] 59 0.204% 99.640% ( 15, 22 ] 12 0.042% 99.682% ( 22, 34 ] 18 0.062% 99.744% ( 34, 51 ] 7 0.024% 99.768% ( 51, 76 ] 1 0.003% 99.772% ( 76, 110 ] 1 0.003% 99.775% ( 110, 170 ] 6 0.021% 99.796% ( 170, 250 ] 8 0.028% 99.823% ( 250, 380 ] 3 0.010% 99.834% ( 380, 580 ] 1 0.003% 99.837% ( 870, 1300 ] 3 0.010% 99.848% ( 1300, 1900 ] 9 0.031% 99.879% ( 1900, 2900 ] 11 0.038% 99.917% ( 2900, 4400 ] 13 0.045% 99.962% ( 4400, 6600 ] 4 0.014% 99.976% ( 6600, 9900 ] 6 0.021% 99.997% ( 9900, 14000 ] 1 0.003% 100.000% ** Level 4 read latency histogram (micros): Count: 20 Average: 3871.4500 StdDev: 2792.07 Min: 571 Median: 2733.3333 Max: 9871 Percentiles: P50: 2733.33 P75: 5866.67 P99: 9735.00 P99.9: 9871.00 P99.99: 9871.00 ------------------------------------------------------ ( 380, 580 ] 1 5.000% 5.000% # ( 870, 1300 ] 1 5.000% 10.000% # ( 1300, 1900 ] 3 15.000% 25.000% ### ( 1900, 2900 ] 6 30.000% 55.000% ###### ( 2900, 4400 ] 2 10.000% 65.000% ## ( 4400, 6600 ] 3 15.000% 80.000% ### ( 6600, 9900 ] 4 20.000% 100.000% #### ** Level 5 read latency histogram (micros): Count: 40 Average: 682.6250 StdDev: 853.09 Min: 51 Median: 159.0909 Max: 2777 Percentiles: P50: 159.09 P75: 977.50 P99: 2777.00 P99.9: 2777.00 P99.99: 2777.00 ------------------------------------------------------ ( 34, 51 ] 1 2.500% 2.500% # ( 76, 110 ] 10 25.000% 27.500% ##### ( 110, 170 ] 11 27.500% 55.000% ###### ( 170, 250 ] 1 2.500% 57.500% # ( 250, 380 ] 1 2.500% 60.000% # ( 580, 870 ] 5 12.500% 72.500% ### ( 870, 1300 ] 4 10.000% 82.500% ## ( 1300, 1900 ] 1 2.500% 85.000% # ( 1900, 2900 ] 6 15.000% 100.000% ### ** DB Stats ** Uptime(secs): 9.0 total, 3.1 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 326.88 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:1.011 H:M:S, 11.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 321.99 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.423 H:M:S, 13.8 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/11/17-03:26:59 ... thread 0: (1000000,4000000) ops and (333246.1,339047.9) ops/second in (3.000785,11.797743) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 12/4 2.09 GB 182.5 2.4 0.0 2.4 6.1 3.7 0.0 1.6 123.6 313.6 19.88 18.59 62 0.321 2494K 2556 0.0 0.0 L1 11/0 1.04 GB 106.8 1.7 1.5 0.2 1.7 1.5 0.1 1.1 233.3 232.5 7.30 7.09 3 2.433 1729K 5434 0.0 0.0 L2 2/0 51.67 MB 0.5 0.1 0.1 0.1 0.1 0.1 0.5 2.0 236.1 236.0 0.53 0.51 1 0.534 127K 45 0.0 0.0 L3 49/0 976.98 MB 1.0 0.6 0.5 0.1 0.6 0.5 0.2 1.2 195.6 195.5 3.19 2.76 2 1.594 633K 493 0.0 0.0 L4 136/0 9.50 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1048/0 86.19 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1258/4 99.82 GB 0.0 4.8 2.0 2.8 8.5 5.7 2.0 2.3 158.9 280.9 30.90 28.95 68 0.454 4985K 8528 0.0 0.0 Int 0/0 0.00 KB 0.0 4.8 2.0 2.8 8.5 5.7 1.9 2.3 158.9 280.9 30.90 28.95 68 0.454 4985K 8528 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 4.8 2.0 2.8 4.8 2.0 0.0 0.0 241.3 240.8 20.35 19.51 15 1.357 4985K 8528 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 3.7 3.7 0.0 0.0 0.0 358.2 10.55 9.44 53 0.199 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 12.0 total, 11.8 interval Flush(GB): cumulative 3.691, interval 3.691 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 8.48 GB write, 721.38 MB/s write, 4.79 GB read, 408.01 MB/s read, 30.9 seconds Interval compaction: 8.48 GB write, 735.66 MB/s write, 4.79 GB read, 416.08 MB/s read, 30.9 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: 14, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 14, interval: 14 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1063825 Average: 2.1465 StdDev: 12.04 Min: 1 Median: 1.4711 Max: 4256 Percentiles: P50: 1.47 P75: 1.85 P99: 5.44 P99.9: 9.59 P99.99: 14.19 ------------------------------------------------------ [ 0, 1 ] 199170 18.722% 18.722% #### ( 1, 2 ] 706303 66.393% 85.115% ############# ( 2, 3 ] 97749 9.188% 94.303% ## ( 3, 4 ] 34613 3.254% 97.557% # ( 4, 6 ] 21260 1.998% 99.555% ( 6, 10 ] 4087 0.384% 99.940% ( 10, 15 ] 641 0.060% 100.000% ( 15, 22 ] 64 0.006% 100.006% ( 22, 34 ] 7 0.001% 100.006% ( 34, 51 ] 7 0.001% 100.007% ( 51, 76 ] 6 0.001% 100.008% ( 110, 170 ] 20 0.002% 100.010% ( 170, 250 ] 24 0.002% 100.012% ( 250, 380 ] 12 0.001% 100.013% ( 380, 580 ] 17 0.002% 100.015% ( 580, 870 ] 21 0.002% 100.017% ( 870, 1300 ] 18 0.002% 100.018% ( 1300, 1900 ] 1 0.000% 100.018% ( 1900, 2900 ] 4 0.000% 100.019% ( 2900, 4400 ] 7 0.001% 100.019% ** Level 1 read latency histogram (micros): Count: 146887 Average: 2.3623 StdDev: 13.08 Min: 0 Median: 1.5541 Max: 2045 Percentiles: P50: 1.55 P75: 1.93 P99: 5.70 P99.9: 11.24 P99.99: 552.45 ------------------------------------------------------ [ 0, 1 ] 19522 13.290% 13.290% ### ( 1, 2 ] 97321 66.256% 79.546% ############# ( 2, 3 ] 19112 13.011% 92.558% ### ( 3, 4 ] 5825 3.966% 96.523% # ( 4, 6 ] 4273 2.909% 99.432% # ( 6, 10 ] 654 0.445% 99.877% ( 10, 15 ] 133 0.091% 99.968% ( 15, 22 ] 10 0.007% 99.975% ( 22, 34 ] 3 0.002% 99.977% ( 51, 76 ] 1 0.001% 99.978% ( 110, 170 ] 3 0.002% 99.980% ( 170, 250 ] 3 0.002% 99.982% ( 250, 380 ] 8 0.005% 99.987% ( 380, 580 ] 5 0.003% 99.990% ( 580, 870 ] 3 0.002% 99.993% ( 870, 1300 ] 7 0.005% 99.997% ( 1300, 1900 ] 3 0.002% 99.999% ( 1900, 2900 ] 1 0.001% 100.000% ** Level 2 read latency histogram (micros): Count: 31763 Average: 2.8785 StdDev: 35.96 Min: 0 Median: 1.6091 Max: 4280 Percentiles: P50: 1.61 P75: 2.03 P99: 7.53 P99.9: 14.21 P99.99: 2311.85 ------------------------------------------------------ [ 0, 1 ] 3686 11.605% 11.605% ## ( 1, 2 ] 20023 63.039% 74.643% ############# ( 2, 3 ] 4103 12.918% 87.561% ### ( 3, 4 ] 1837 5.783% 93.344% # ( 4, 6 ] 1655 5.210% 98.555% # ( 6, 10 ] 370 1.165% 99.720% ( 10, 15 ] 68 0.214% 99.934% ( 15, 22 ] 6 0.019% 99.953% ( 22, 34 ] 1 0.003% 99.956% ( 51, 76 ] 2 0.006% 99.962% ( 76, 110 ] 1 0.003% 99.965% ( 170, 250 ] 2 0.006% 99.972% ( 250, 380 ] 2 0.006% 99.978% ( 380, 580 ] 2 0.006% 99.984% ( 1300, 1900 ] 1 0.003% 99.987% ( 1900, 2900 ] 2 0.006% 99.994% ( 2900, 4400 ] 2 0.006% 100.000% ** Level 3 read latency histogram (micros): Count: 28895 Average: 8.4051 StdDev: 175.20 Min: 0 Median: 1.5917 Max: 10280 Percentiles: P50: 1.59 P75: 1.97 P99: 6.53 P99.9: 2455.00 P99.99: 8860.77 ------------------------------------------------------ [ 0, 1 ] 3032 10.493% 10.493% ## ( 1, 2 ] 19293 66.769% 77.263% ############# ( 2, 3 ] 4041 13.985% 91.248% ### ( 3, 4 ] 1297 4.489% 95.736% # ( 4, 6 ] 924 3.198% 98.934% # ( 6, 10 ] 145 0.502% 99.436% ( 10, 15 ] 59 0.204% 99.640% ( 15, 22 ] 12 0.042% 99.682% ( 22, 34 ] 18 0.062% 99.744% ( 34, 51 ] 7 0.024% 99.768% ( 51, 76 ] 1 0.003% 99.772% ( 76, 110 ] 1 0.003% 99.775% ( 110, 170 ] 6 0.021% 99.796% ( 170, 250 ] 8 0.028% 99.823% ( 250, 380 ] 3 0.010% 99.834% ( 380, 580 ] 1 0.003% 99.837% ( 870, 1300 ] 3 0.010% 99.848% ( 1300, 1900 ] 9 0.031% 99.879% ( 1900, 2900 ] 11 0.038% 99.917% ( 2900, 4400 ] 13 0.045% 99.962% ( 4400, 6600 ] 4 0.014% 99.976% ( 6600, 9900 ] 6 0.021% 99.997% ( 9900, 14000 ] 1 0.003% 100.000% ** Level 4 read latency histogram (micros): Count: 20 Average: 3871.4500 StdDev: 2792.07 Min: 571 Median: 2733.3333 Max: 9871 Percentiles: P50: 2733.33 P75: 5866.67 P99: 9735.00 P99.9: 9871.00 P99.99: 9871.00 ------------------------------------------------------ ( 380, 580 ] 1 5.000% 5.000% # ( 870, 1300 ] 1 5.000% 10.000% # ( 1300, 1900 ] 3 15.000% 25.000% ### ( 1900, 2900 ] 6 30.000% 55.000% ###### ( 2900, 4400 ] 2 10.000% 65.000% ## ( 4400, 6600 ] 3 15.000% 80.000% ### ( 6600, 9900 ] 4 20.000% 100.000% #### ** Level 5 read latency histogram (micros): Count: 40 Average: 682.6250 StdDev: 853.09 Min: 51 Median: 159.0909 Max: 2777 Percentiles: P50: 159.09 P75: 977.50 P99: 2777.00 P99.9: 2777.00 P99.99: 2777.00 ------------------------------------------------------ ( 34, 51 ] 1 2.500% 2.500% # ( 76, 110 ] 10 25.000% 27.500% ##### ( 110, 170 ] 11 27.500% 55.000% ###### ( 170, 250 ] 1 2.500% 57.500% # ( 250, 380 ] 1 2.500% 60.000% # ( 580, 870 ] 5 12.500% 72.500% ### ( 870, 1300 ] 4 10.000% 82.500% ## ( 1300, 1900 ] 1 2.500% 85.000% # ( 1900, 2900 ] 6 15.000% 100.000% ### ** DB Stats ** Uptime(secs): 12.0 total, 3.0 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 327.15 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.404 H:M:S, 11.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 327.97 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.393 H:M:S, 13.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/11/17-03:27:02 ... thread 0: (1000000,5000000) ops and (340163.7,339270.5) ops/second in (2.939761,14.737504) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 17/4 3.07 GB 289.5 3.3 0.0 3.3 7.9 4.7 0.0 1.7 128.5 312.6 25.98 24.33 79 0.329 3390K 3502 0.0 0.0 L1 11/0 1.04 GB 106.8 1.7 1.5 0.2 1.7 1.5 0.1 1.1 233.3 232.5 7.30 7.09 3 2.433 1729K 5434 0.0 0.0 L2 2/0 51.67 MB 0.5 0.1 0.1 0.1 0.1 0.1 0.5 2.0 236.1 236.0 0.53 0.51 1 0.534 127K 45 0.0 0.0 L3 49/0 976.98 MB 1.0 0.6 0.5 0.1 0.6 0.5 0.2 1.2 195.6 195.5 3.19 2.76 2 1.594 633K 493 0.0 0.0 L4 136/0 9.50 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1048/0 86.19 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1263/4 100.80 GB 0.0 5.7 2.0 3.6 10.3 6.7 2.0 2.2 156.5 285.6 37.00 34.68 85 0.435 5880K 9474 0.0 0.0 Int 0/0 0.00 KB 0.0 5.7 2.0 3.6 10.3 6.7 1.9 2.2 156.5 285.6 37.00 34.68 85 0.435 5880K 9474 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 5.7 2.0 3.6 5.6 2.0 0.0 0.0 244.5 244.1 23.68 22.78 18 1.316 5880K 9474 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 359.5 13.32 11.90 67 0.199 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 15.0 total, 14.7 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: 10.32 GB write, 705.90 MB/s write, 5.66 GB read, 386.80 MB/s read, 37.0 seconds Interval compaction: 10.32 GB write, 717.08 MB/s write, 5.66 GB read, 392.93 MB/s read, 37.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: 18, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 18, interval: 18 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1320987 Average: 2.1185 StdDev: 12.43 Min: 1 Median: 1.4522 Max: 4444 Percentiles: P50: 1.45 P75: 1.83 P99: 5.36 P99.9: 9.62 P99.99: 14.46 ------------------------------------------------------ [ 0, 1 ] 264419 20.017% 20.017% #### ( 1, 2 ] 875803 66.299% 86.316% ############# ( 2, 3 ] 111916 8.472% 94.788% ## ( 3, 4 ] 39444 2.986% 97.774% # ( 4, 6 ] 23759 1.799% 99.573% ( 6, 10 ] 4775 0.361% 99.934% ( 10, 15 ] 828 0.063% 99.997% ( 15, 22 ] 87 0.007% 100.003% ( 22, 34 ] 10 0.001% 100.004% ( 34, 51 ] 8 0.001% 100.005% ( 51, 76 ] 8 0.001% 100.005% ( 76, 110 ] 1 0.000% 100.005% ( 110, 170 ] 27 0.002% 100.007% ( 170, 250 ] 27 0.002% 100.009% ( 250, 380 ] 14 0.001% 100.011% ( 380, 580 ] 20 0.002% 100.012% ( 580, 870 ] 28 0.002% 100.014% ( 870, 1300 ] 25 0.002% 100.016% ( 1300, 1900 ] 4 0.000% 100.016% ( 1900, 2900 ] 4 0.000% 100.017% ( 2900, 4400 ] 8 0.001% 100.017% ( 4400, 6600 ] 1 0.000% 100.017% ** Level 1 read latency histogram (micros): Count: 146887 Average: 2.3623 StdDev: 13.08 Min: 0 Median: 1.5541 Max: 2045 Percentiles: P50: 1.55 P75: 1.93 P99: 5.70 P99.9: 11.24 P99.99: 552.45 ------------------------------------------------------ [ 0, 1 ] 19522 13.290% 13.290% ### ( 1, 2 ] 97321 66.256% 79.546% ############# ( 2, 3 ] 19112 13.011% 92.558% ### ( 3, 4 ] 5825 3.966% 96.523% # ( 4, 6 ] 4273 2.909% 99.432% # ( 6, 10 ] 654 0.445% 99.877% ( 10, 15 ] 133 0.091% 99.968% ( 15, 22 ] 10 0.007% 99.975% ( 22, 34 ] 3 0.002% 99.977% ( 51, 76 ] 1 0.001% 99.978% ( 110, 170 ] 3 0.002% 99.980% ( 170, 250 ] 3 0.002% 99.982% ( 250, 380 ] 8 0.005% 99.987% ( 380, 580 ] 5 0.003% 99.990% ( 580, 870 ] 3 0.002% 99.993% ( 870, 1300 ] 7 0.005% 99.997% ( 1300, 1900 ] 3 0.002% 99.999% ( 1900, 2900 ] 1 0.001% 100.000% ** Level 2 read latency histogram (micros): Count: 31763 Average: 2.8785 StdDev: 35.96 Min: 0 Median: 1.6091 Max: 4280 Percentiles: P50: 1.61 P75: 2.03 P99: 7.53 P99.9: 14.21 P99.99: 2311.85 ------------------------------------------------------ [ 0, 1 ] 3686 11.605% 11.605% ## ( 1, 2 ] 20023 63.039% 74.643% ############# ( 2, 3 ] 4103 12.918% 87.561% ### ( 3, 4 ] 1837 5.783% 93.344% # ( 4, 6 ] 1655 5.210% 98.555% # ( 6, 10 ] 370 1.165% 99.720% ( 10, 15 ] 68 0.214% 99.934% ( 15, 22 ] 6 0.019% 99.953% ( 22, 34 ] 1 0.003% 99.956% ( 51, 76 ] 2 0.006% 99.962% ( 76, 110 ] 1 0.003% 99.965% ( 170, 250 ] 2 0.006% 99.972% ( 250, 380 ] 2 0.006% 99.978% ( 380, 580 ] 2 0.006% 99.984% ( 1300, 1900 ] 1 0.003% 99.987% ( 1900, 2900 ] 2 0.006% 99.994% ( 2900, 4400 ] 2 0.006% 100.000% ** Level 3 read latency histogram (micros): Count: 28895 Average: 8.4051 StdDev: 175.20 Min: 0 Median: 1.5917 Max: 10280 Percentiles: P50: 1.59 P75: 1.97 P99: 6.53 P99.9: 2455.00 P99.99: 8860.77 ------------------------------------------------------ [ 0, 1 ] 3032 10.493% 10.493% ## ( 1, 2 ] 19293 66.769% 77.263% ############# ( 2, 3 ] 4041 13.985% 91.248% ### ( 3, 4 ] 1297 4.489% 95.736% # ( 4, 6 ] 924 3.198% 98.934% # ( 6, 10 ] 145 0.502% 99.436% ( 10, 15 ] 59 0.204% 99.640% ( 15, 22 ] 12 0.042% 99.682% ( 22, 34 ] 18 0.062% 99.744% ( 34, 51 ] 7 0.024% 99.768% ( 51, 76 ] 1 0.003% 99.772% ( 76, 110 ] 1 0.003% 99.775% ( 110, 170 ] 6 0.021% 99.796% ( 170, 250 ] 8 0.028% 99.823% ( 250, 380 ] 3 0.010% 99.834% ( 380, 580 ] 1 0.003% 99.837% ( 870, 1300 ] 3 0.010% 99.848% ( 1300, 1900 ] 9 0.031% 99.879% ( 1900, 2900 ] 11 0.038% 99.917% ( 2900, 4400 ] 13 0.045% 99.962% ( 4400, 6600 ] 4 0.014% 99.976% ( 6600, 9900 ] 6 0.021% 99.997% ( 9900, 14000 ] 1 0.003% 100.000% ** Level 4 read latency histogram (micros): Count: 20 Average: 3871.4500 StdDev: 2792.07 Min: 571 Median: 2733.3333 Max: 9871 Percentiles: P50: 2733.33 P75: 5866.67 P99: 9735.00 P99.9: 9871.00 P99.99: 9871.00 ------------------------------------------------------ ( 380, 580 ] 1 5.000% 5.000% # ( 870, 1300 ] 1 5.000% 10.000% # ( 1300, 1900 ] 3 15.000% 25.000% ### ( 1900, 2900 ] 6 30.000% 55.000% ###### ( 2900, 4400 ] 2 10.000% 65.000% ## ( 4400, 6600 ] 3 15.000% 80.000% ### ( 6600, 9900 ] 4 20.000% 100.000% #### ** Level 5 read latency histogram (micros): Count: 40 Average: 682.6250 StdDev: 853.09 Min: 51 Median: 159.0909 Max: 2777 Percentiles: P50: 159.09 P75: 977.50 P99: 2777.00 P99.9: 2777.00 P99.99: 2777.00 ------------------------------------------------------ ( 34, 51 ] 1 2.500% 2.500% # ( 76, 110 ] 10 25.000% 27.500% ##### ( 110, 170 ] 11 27.500% 55.000% ###### ( 170, 250 ] 1 2.500% 57.500% # ( 250, 380 ] 1 2.500% 60.000% # ( 580, 870 ] 5 12.500% 72.500% ### ( 870, 1300 ] 4 10.000% 82.500% ## ( 1300, 1900 ] 1 2.500% 85.000% # ( 1900, 2900 ] 6 15.000% 100.000% ### ** DB Stats ** Uptime(secs): 15.0 total, 2.9 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 328.65 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:1.771 H:M:S, 11.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 334.79 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.367 H:M:S, 12.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/11/17-03:27:12 ... thread 0: (1000000,6000000) ops and (106980.4,249117.6) ops/second in (9.347510,24.085014) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 21/15 4.12 GB 100.7 4.3 0.0 4.3 10.0 5.7 0.0 1.8 133.5 310.6 33.04 30.96 99 0.334 4477K 4527 0.0 0.0 L1 11/11 1.04 GB 0.0 1.7 1.5 0.2 1.7 1.5 0.1 1.1 233.3 232.5 7.30 7.09 3 2.433 1729K 5434 0.0 0.0 L2 2/0 51.67 MB 0.5 0.1 0.1 0.1 0.1 0.1 0.5 2.0 236.1 236.0 0.53 0.51 1 0.534 127K 45 0.0 0.0 L3 49/0 976.98 MB 1.0 0.6 0.5 0.1 0.6 0.5 0.2 1.2 195.6 195.5 3.19 2.76 2 1.594 633K 493 0.0 0.0 L4 136/0 9.50 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1048/0 86.19 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1267/26 101.85 GB 0.0 6.7 2.0 4.7 12.4 7.7 2.0 2.2 155.7 288.4 44.06 41.32 105 0.420 6967K 10K 0.0 0.0 Int 0/0 0.00 KB 0.0 6.7 2.0 4.7 12.4 7.7 1.9 2.2 155.7 288.4 44.06 41.32 105 0.420 6967K 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 6.7 2.0 4.7 6.7 2.0 0.0 0.0 248.1 247.7 27.67 26.70 22 1.258 6967K 10K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 5.7 5.7 0.0 0.0 0.0 357.3 16.40 14.62 83 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): 24.3 total, 24.1 interval Flush(GB): cumulative 5.721, interval 5.721 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: 12.41 GB write, 522.60 MB/s write, 6.70 GB read, 282.16 MB/s read, 44.1 seconds Interval compaction: 12.41 GB write, 527.67 MB/s write, 6.70 GB read, 284.90 MB/s read, 44.1 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 8, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 8, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 19, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 8, total-stops: 19, interval: 27 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1937205 Average: 2.1257 StdDev: 12.67 Min: 0 Median: 1.4394 Max: 5711 Percentiles: P50: 1.44 P75: 1.81 P99: 5.38 P99.9: 9.83 P99.99: 109.81 ------------------------------------------------------ [ 0, 1 ] 399329 20.614% 20.614% #### ( 1, 2 ] 1295463 66.873% 87.486% ############# ( 2, 3 ] 148938 7.688% 95.175% ## ( 3, 4 ] 52802 2.726% 97.900% # ( 4, 6 ] 30786 1.589% 99.490% ( 6, 10 ] 8311 0.429% 99.919% ( 10, 15 ] 1075 0.055% 99.974% ( 15, 22 ] 149 0.008% 99.982% ( 22, 34 ] 15 0.001% 99.983% ( 34, 51 ] 9 0.000% 99.983% ( 51, 76 ] 10 0.001% 99.984% ( 76, 110 ] 127 0.007% 99.990% ( 110, 170 ] 226 0.012% 100.002% ( 170, 250 ] 89 0.005% 100.006% ( 250, 380 ] 47 0.002% 100.009% ( 380, 580 ] 44 0.002% 100.011% ( 580, 870 ] 42 0.002% 100.013% ( 870, 1300 ] 32 0.002% 100.015% ( 1300, 1900 ] 7 0.000% 100.015% ( 1900, 2900 ] 5 0.000% 100.016% ( 2900, 4400 ] 11 0.001% 100.016% ( 4400, 6600 ] 2 0.000% 100.016% ** Level 1 read latency histogram (micros): Count: 281079 Average: 2.3477 StdDev: 12.43 Min: 0 Median: 1.4653 Max: 2711 Percentiles: P50: 1.47 P75: 1.85 P99: 6.57 P99.9: 93.90 P99.99: 473.60 ------------------------------------------------------ [ 0, 1 ] 54856 19.516% 19.516% #### ( 1, 2 ] 184131 65.509% 85.025% ############# ( 2, 3 ] 24950 8.877% 93.901% ## ( 3, 4 ] 8272 2.943% 96.844% # ( 4, 6 ] 5689 2.024% 98.868% ( 6, 10 ] 2584 0.919% 99.788% ( 10, 15 ] 205 0.073% 99.861% ( 15, 22 ] 33 0.012% 99.872% ( 22, 34 ] 3 0.001% 99.873% ( 51, 76 ] 7 0.002% 99.876% ( 76, 110 ] 129 0.046% 99.922% ( 110, 170 ] 128 0.046% 99.967% ( 170, 250 ] 31 0.011% 99.978% ( 250, 380 ] 24 0.009% 99.987% ( 380, 580 ] 19 0.007% 99.994% ( 580, 870 ] 6 0.002% 99.996% ( 870, 1300 ] 7 0.002% 99.998% ( 1300, 1900 ] 3 0.001% 99.999% ( 1900, 2900 ] 2 0.001% 100.000% ** Level 2 read latency histogram (micros): Count: 31763 Average: 2.8785 StdDev: 35.96 Min: 0 Median: 1.6091 Max: 4280 Percentiles: P50: 1.61 P75: 2.03 P99: 7.53 P99.9: 14.21 P99.99: 2311.85 ------------------------------------------------------ [ 0, 1 ] 3686 11.605% 11.605% ## ( 1, 2 ] 20023 63.039% 74.643% ############# ( 2, 3 ] 4103 12.918% 87.561% ### ( 3, 4 ] 1837 5.783% 93.344% # ( 4, 6 ] 1655 5.210% 98.555% # ( 6, 10 ] 370 1.165% 99.720% ( 10, 15 ] 68 0.214% 99.934% ( 15, 22 ] 6 0.019% 99.953% ( 22, 34 ] 1 0.003% 99.956% ( 51, 76 ] 2 0.006% 99.962% ( 76, 110 ] 1 0.003% 99.965% ( 170, 250 ] 2 0.006% 99.972% ( 250, 380 ] 2 0.006% 99.978% ( 380, 580 ] 2 0.006% 99.984% ( 1300, 1900 ] 1 0.003% 99.987% ( 1900, 2900 ] 2 0.006% 99.994% ( 2900, 4400 ] 2 0.006% 100.000% ** Level 3 read latency histogram (micros): Count: 28895 Average: 8.4051 StdDev: 175.20 Min: 0 Median: 1.5917 Max: 10280 Percentiles: P50: 1.59 P75: 1.97 P99: 6.53 P99.9: 2455.00 P99.99: 8860.77 ------------------------------------------------------ [ 0, 1 ] 3032 10.493% 10.493% ## ( 1, 2 ] 19293 66.769% 77.263% ############# ( 2, 3 ] 4041 13.985% 91.248% ### ( 3, 4 ] 1297 4.489% 95.736% # ( 4, 6 ] 924 3.198% 98.934% # ( 6, 10 ] 145 0.502% 99.436% ( 10, 15 ] 59 0.204% 99.640% ( 15, 22 ] 12 0.042% 99.682% ( 22, 34 ] 18 0.062% 99.744% ( 34, 51 ] 7 0.024% 99.768% ( 51, 76 ] 1 0.003% 99.772% ( 76, 110 ] 1 0.003% 99.775% ( 110, 170 ] 6 0.021% 99.796% ( 170, 250 ] 8 0.028% 99.823% ( 250, 380 ] 3 0.010% 99.834% ( 380, 580 ] 1 0.003% 99.837% ( 870, 1300 ] 3 0.010% 99.848% ( 1300, 1900 ] 9 0.031% 99.879% ( 1900, 2900 ] 11 0.038% 99.917% ( 2900, 4400 ] 13 0.045% 99.962% ( 4400, 6600 ] 4 0.014% 99.976% ( 6600, 9900 ] 6 0.021% 99.997% ( 9900, 14000 ] 1 0.003% 100.000% ** Level 4 read latency histogram (micros): Count: 20 Average: 3871.4500 StdDev: 2792.07 Min: 571 Median: 2733.3333 Max: 9871 Percentiles: P50: 2733.33 P75: 5866.67 P99: 9735.00 P99.9: 9871.00 P99.99: 9871.00 ------------------------------------------------------ ( 380, 580 ] 1 5.000% 5.000% # ( 870, 1300 ] 1 5.000% 10.000% # ( 1300, 1900 ] 3 15.000% 25.000% ### ( 1900, 2900 ] 6 30.000% 55.000% ###### ( 2900, 4400 ] 2 10.000% 65.000% ## ( 4400, 6600 ] 3 15.000% 80.000% ### ( 6600, 9900 ] 4 20.000% 100.000% #### ** Level 5 read latency histogram (micros): Count: 40 Average: 682.6250 StdDev: 853.09 Min: 51 Median: 159.0909 Max: 2777 Percentiles: P50: 159.09 P75: 977.50 P99: 2777.00 P99.9: 2777.00 P99.99: 2777.00 ------------------------------------------------------ ( 34, 51 ] 1 2.500% 2.500% # ( 76, 110 ] 10 25.000% 27.500% ##### ( 110, 170 ] 11 27.500% 55.000% ###### ( 170, 250 ] 1 2.500% 57.500% # ( 250, 380 ] 1 2.500% 60.000% # ( 580, 870 ] 5 12.500% 72.500% ### ( 870, 1300 ] 4 10.000% 82.500% ## ( 1300, 1900 ] 1 2.500% 85.000% # ( 1900, 2900 ] 6 15.000% 100.000% ### ** DB Stats ** Uptime(secs): 24.3 total, 9.3 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 242.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:8.227 H:M:S, 33.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 105.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:6.456 H:M:S, 69.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 0 2024/11/17-03:27:27 ... thread 0: (1000000,7000000) ops and (64063.4,176346.6) ops/second in (15.609533,39.694547) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 11/11 1.84 GB 0.0 6.0 0.0 6.0 12.5 6.6 0.0 1.9 135.4 284.6 45.11 39.96 113 0.399 6203K 9844 0.0 0.0 L1 10/10 1.08 GB 0.0 5.8 4.6 1.2 5.8 4.5 0.1 1.2 219.7 216.5 27.22 25.57 4 6.805 6073K 88K 0.0 0.0 L2 1/1 935.75 KB 0.0 0.1 0.1 0.1 0.1 0.1 3.5 2.0 236.1 236.0 0.53 0.51 1 0.534 127K 45 0.0 0.0 L3 23/9 1.71 GB 0.9 2.5 1.9 0.5 2.5 1.9 1.8 1.3 135.7 135.4 18.69 11.95 14 1.335 2420K 1595 0.0 0.0 L4 157/3 9.46 GB 1.0 1.8 1.6 0.2 1.8 1.6 1.3 1.1 122.6 122.2 15.24 8.90 16 0.953 1898K 6864 0.0 0.0 L5 1076/0 88.52 GB 0.9 0.0 0.0 0.0 0.0 0.0 3.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1278/34 102.61 GB 0.0 16.2 8.2 8.0 22.7 14.7 9.7 3.4 155.6 217.7 106.80 86.89 148 0.722 16M 106K 0.0 0.0 Int 0/0 0.00 KB 0.0 16.2 8.2 8.0 22.7 14.7 9.6 3.4 155.6 217.7 106.80 86.89 148 0.722 16M 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 16.2 8.2 8.0 16.1 8.1 0.0 0.0 194.4 193.1 85.52 69.90 54 1.584 16M 106K 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 316.8 21.28 16.99 94 0.226 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): 39.9 total, 39.7 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: 22.71 GB write, 582.30 MB/s write, 16.23 GB read, 416.28 MB/s read, 106.8 seconds Interval compaction: 22.71 GB write, 585.73 MB/s write, 16.23 GB read, 418.73 MB/s read, 106.8 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 12, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 12, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 46, pending-compaction-bytes-delays: 1, pending-compaction-bytes-stops: 0, total-delays: 13, total-stops: 46, interval: 59 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2945534 Average: 3.1056 StdDev: 43.69 Min: 0 Median: 1.4813 Max: 11493 Percentiles: P50: 1.48 P75: 1.87 P99: 7.42 P99.9: 158.96 P99.99: 507.70 ------------------------------------------------------ [ 0, 1 ] 560463 19.028% 19.028% #### ( 1, 2 ] 1895679 64.358% 83.385% ############# ( 2, 3 ] 273468 9.284% 92.669% ## ( 3, 4 ] 100815 3.423% 96.092% # ( 4, 6 ] 76849 2.609% 98.701% # ( 6, 10 ] 24846 0.844% 99.545% ( 10, 15 ] 3866 0.131% 99.676% ( 15, 22 ] 642 0.022% 99.698% ( 22, 34 ] 41 0.001% 99.699% ( 34, 51 ] 18 0.001% 99.700% ( 51, 76 ] 13 0.000% 99.700% ( 76, 110 ] 2196 0.075% 99.775% ( 110, 170 ] 4526 0.154% 99.928% ( 170, 250 ] 958 0.033% 99.961% ( 250, 380 ] 538 0.018% 99.979% ( 380, 580 ] 505 0.017% 99.996% ( 580, 870 ] 252 0.009% 100.005% ( 870, 1300 ] 125 0.004% 100.009% ( 1300, 1900 ] 56 0.002% 100.011% ( 1900, 2900 ] 86 0.003% 100.014% ( 2900, 4400 ] 122 0.004% 100.018% ( 4400, 6600 ] 51 0.002% 100.020% ( 6600, 9900 ] 22 0.001% 100.020% ( 9900, 14000 ] 1 0.000% 100.021% ** Level 1 read latency histogram (micros): Count: 1015052 Average: 6.8598 StdDev: 119.28 Min: 0 Median: 1.7592 Max: 15515 Percentiles: P50: 1.76 P75: 2.65 P99: 9.36 P99.9: 303.45 P99.99: 1218.12 ------------------------------------------------------ [ 0, 1 ] 96967 9.553% 9.553% ## ( 1, 2 ] 540759 53.274% 62.827% ########### ( 2, 3 ] 188663 18.587% 81.413% #### ( 3, 4 ] 79676 7.849% 89.263% ## ( 4, 6 ] 83668 8.243% 97.506% ## ( 6, 10 ] 18083 1.781% 99.287% ( 10, 15 ] 4298 0.423% 99.711% ( 15, 22 ] 544 0.054% 99.764% ( 22, 34 ] 47 0.005% 99.769% ( 34, 51 ] 21 0.002% 99.771% ( 51, 76 ] 25 0.002% 99.773% ( 76, 110 ] 476 0.047% 99.820% ( 110, 170 ] 577 0.057% 99.877% ( 170, 250 ] 162 0.016% 99.893% ( 250, 380 ] 175 0.017% 99.910% ( 380, 580 ] 261 0.026% 99.936% ( 580, 870 ] 322 0.032% 99.968% ( 870, 1300 ] 281 0.028% 99.995% ( 1300, 1900 ] 175 0.017% 100.013% ( 1900, 2900 ] 300 0.030% 100.042% ( 2900, 4400 ] 373 0.037% 100.079% ( 4400, 6600 ] 127 0.013% 100.091% ( 6600, 9900 ] 50 0.005% 100.096% ( 9900, 14000 ] 4 0.000% 100.097% ( 14000, 22000 ] 1 0.000% 100.097% ** Level 2 read latency histogram (micros): Count: 55989 Average: 7.2740 StdDev: 106.99 Min: 0 Median: 1.7055 Max: 10221 Percentiles: P50: 1.71 P75: 2.47 P99: 9.59 P99.9: 1255.68 P99.99: 4266.76 ------------------------------------------------------ [ 0, 1 ] 4707 8.407% 8.407% ## ( 1, 2 ] 33009 58.956% 67.363% ############ ( 2, 3 ] 9134 16.314% 83.677% ### ( 3, 4 ] 3957 7.067% 90.745% # ( 4, 6 ] 3805 6.796% 97.541% # ( 6, 10 ] 911 1.627% 99.168% ( 10, 15 ] 185 0.330% 99.498% ( 15, 22 ] 12 0.021% 99.520% ( 22, 34 ] 3 0.005% 99.525% ( 51, 76 ] 2 0.004% 99.528% ( 76, 110 ] 5 0.009% 99.537% ( 110, 170 ] 16 0.029% 99.566% ( 170, 250 ] 23 0.041% 99.607% ( 250, 380 ] 45 0.080% 99.687% ( 380, 580 ] 54 0.096% 99.784% ( 580, 870 ] 40 0.071% 99.855% ( 870, 1300 ] 29 0.052% 99.907% ( 1300, 1900 ] 9 0.016% 99.923% ( 1900, 2900 ] 22 0.039% 99.962% ( 2900, 4400 ] 18 0.032% 99.995% ( 4400, 6600 ] 2 0.004% 99.998% ( 6600, 9900 ] 1 0.002% 100.000% ( 9900, 14000 ] 1 0.002% 100.002% ** Level 3 read latency histogram (micros): Count: 547947 Average: 12.7314 StdDev: 162.06 Min: 0 Median: 1.9838 Max: 15642 Percentiles: P50: 1.98 P75: 3.05 P99: 11.82 P99.9: 1192.75 P99.99: 1882.59 ------------------------------------------------------ [ 0, 1 ] 13488 2.462% 2.462% ( 1, 2 ] 264780 48.322% 50.784% ########## ( 2, 3 ] 129894 23.706% 74.489% ##### ( 3, 4 ] 59668 10.889% 85.379% ## ( 4, 6 ] 62900 11.479% 96.858% ## ( 6, 10 ] 10775 1.966% 98.824% ( 10, 15 ] 2639 0.482% 99.306% ( 15, 22 ] 303 0.055% 99.361% ( 22, 34 ] 63 0.011% 99.373% ( 34, 51 ] 23 0.004% 99.377% ( 51, 76 ] 8 0.001% 99.378% ( 76, 110 ] 6 0.001% 99.380% ( 110, 170 ] 100 0.018% 99.398% ( 170, 250 ] 244 0.045% 99.442% ( 250, 380 ] 467 0.085% 99.528% ( 380, 580 ] 750 0.137% 99.664% ( 580, 870 ] 894 0.163% 99.828% ( 870, 1300 ] 529 0.097% 99.924% ( 1300, 1900 ] 372 0.068% 99.992% ( 1900, 2900 ] 304 0.055% 100.047% ( 2900, 4400 ] 398 0.073% 100.120% ( 4400, 6600 ] 112 0.020% 100.141% ( 6600, 9900 ] 38 0.007% 100.147% ( 9900, 14000 ] 1 0.000% 100.148% ( 14000, 22000 ] 1 0.000% 100.148% ** Level 4 read latency histogram (micros): Count: 9304 Average: 19.6661 StdDev: 264.45 Min: 1 Median: 2.0552 Max: 9871 Percentiles: P50: 2.06 P75: 3.12 P99: 109.77 P99.9: 4343.00 P99.99: 9132.42 ------------------------------------------------------ [ 0, 1 ] 216 2.322% 2.322% ( 1, 2 ] 4308 46.303% 48.624% ######### ( 2, 3 ] 2317 24.903% 73.528% ##### ( 3, 4 ] 1112 11.952% 85.479% ## ( 4, 6 ] 1059 11.382% 96.862% ## ( 6, 10 ] 145 1.558% 98.420% ( 10, 15 ] 33 0.355% 98.775% ( 15, 22 ] 9 0.097% 98.871% ( 22, 34 ] 3 0.032% 98.904% ( 34, 51 ] 2 0.021% 98.925% ( 51, 76 ] 1 0.011% 98.936% ( 76, 110 ] 6 0.064% 99.000% ( 110, 170 ] 4 0.043% 99.043% ( 170, 250 ] 23 0.247% 99.291% ( 250, 380 ] 3 0.032% 99.323% ( 380, 580 ] 9 0.097% 99.420% ( 580, 870 ] 8 0.086% 99.506% ( 870, 1300 ] 10 0.107% 99.613% ( 1300, 1900 ] 10 0.107% 99.721% ( 1900, 2900 ] 9 0.097% 99.817% ( 2900, 4400 ] 8 0.086% 99.903% ( 4400, 6600 ] 5 0.054% 99.957% ( 6600, 9900 ] 4 0.043% 100.000% ** Level 5 read latency histogram (micros): Count: 180 Average: 1709.2889 StdDev: 1700.25 Min: 51 Median: 936.1538 Max: 7812 Percentiles: P50: 936.15 P75: 2693.10 P99: 7812.00 P99.9: 7812.00 P99.99: 7812.00 ------------------------------------------------------ ( 34, 51 ] 1 0.556% 0.556% ( 76, 110 ] 11 6.111% 6.667% # ( 110, 170 ] 14 7.778% 14.444% ## ( 170, 250 ] 8 4.444% 18.889% # ( 250, 380 ] 13 7.222% 26.111% # ( 380, 580 ] 17 9.444% 35.556% ## ( 580, 870 ] 24 13.333% 48.889% ### ( 870, 1300 ] 13 7.222% 56.111% # ( 1300, 1900 ] 11 6.111% 62.222% # ( 1900, 2900 ] 29 16.111% 78.333% ### ( 2900, 4400 ] 23 12.778% 91.111% ### ( 4400, 6600 ] 13 7.222% 98.333% # ( 6600, 9900 ] 3 1.667% 100.000% ** DB Stats ** Uptime(secs): 39.9 total, 15.6 interval Cumulative writes: 0 writes, 7000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 6.73 GB, 172.53 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:20.518 H:M:S, 51.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 63.05 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:12.292 H:M:S, 78.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 5 num-running-flushes: 1 2024/11/17-03:27:30 ... thread 0: (1000000,8000000) ops and (305072.0,186165.7) ops/second in (3.277915,42.972462) 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/7 2.88 GB 151.0 6.9 0.0 6.9 14.5 7.6 0.0 1.9 135.9 286.1 51.92 46.35 130 0.399 7162K 10K 0.0 0.0 L1 10/10 1.08 GB 0.0 5.8 4.6 1.2 5.8 4.5 0.1 1.2 219.7 216.5 27.22 25.57 4 6.805 6073K 88K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.1 0.1 0.1 3.5 2.0 236.1 236.0 0.53 0.51 1 0.534 127K 45 0.0 0.0 L3 13/0 919.56 MB 0.9 3.1 1.9 1.2 3.1 1.9 1.8 1.6 135.1 134.8 23.80 14.82 15 1.587 3110K 2522 0.0 0.0 L4 163/0 9.65 GB 1.0 2.0 1.8 0.3 2.0 1.8 1.9 1.1 126.0 125.5 16.38 9.78 18 0.910 2095K 7615 0.0 0.0 L5 1084/0 89.14 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 1283/17 103.65 GB 0.0 18.0 8.4 9.6 25.5 15.9 11.0 3.3 153.9 218.1 119.84 97.03 168 0.713 18M 109K 0.0 0.0 Int 0/0 0.00 KB 0.0 18.0 8.4 9.6 25.5 15.9 10.8 3.3 153.9 218.1 119.84 97.03 168 0.713 18M 109K 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 8.4 9.6 17.9 8.3 0.0 0.0 193.1 191.9 95.49 77.30 60 1.591 18M 109K 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 320.7 24.36 19.73 108 0.226 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.2 total, 43.0 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: 25.53 GB write, 604.93 MB/s write, 18.01 GB read, 426.79 MB/s read, 119.8 seconds Interval compaction: 25.53 GB write, 608.21 MB/s write, 18.01 GB read, 429.10 MB/s read, 119.8 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 12, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 12, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 59, pending-compaction-bytes-delays: 1, pending-compaction-bytes-stops: 0, total-delays: 13, total-stops: 59, interval: 72 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3305271 Average: 3.0391 StdDev: 41.42 Min: 0 Median: 1.4953 Max: 11493 Percentiles: P50: 1.50 P75: 1.88 P99: 7.22 P99.9: 153.90 P99.99: 449.78 ------------------------------------------------------ [ 0, 1 ] 595779 18.025% 18.025% #### ( 1, 2 ] 2133698 64.554% 82.580% ############# ( 2, 3 ] 328692 9.944% 92.524% ## ( 3, 4 ] 115987 3.509% 96.033% # ( 4, 6 ] 89620 2.711% 98.745% # ( 6, 10 ] 27577 0.834% 99.579% ( 10, 15 ] 4257 0.129% 99.708% ( 15, 22 ] 686 0.021% 99.728% ( 22, 34 ] 45 0.001% 99.730% ( 34, 51 ] 18 0.001% 99.730% ( 51, 76 ] 13 0.000% 99.731% ( 76, 110 ] 2227 0.067% 99.798% ( 110, 170 ] 4601 0.139% 99.937% ( 170, 250 ] 994 0.030% 99.967% ( 250, 380 ] 564 0.017% 99.984% ( 380, 580 ] 523 0.016% 100.000% ( 580, 870 ] 264 0.008% 100.008% ( 870, 1300 ] 137 0.004% 100.012% ( 1300, 1900 ] 58 0.002% 100.014% ( 1900, 2900 ] 87 0.003% 100.017% ( 2900, 4400 ] 123 0.004% 100.021% ( 4400, 6600 ] 51 0.002% 100.022% ( 6600, 9900 ] 22 0.001% 100.023% ( 9900, 14000 ] 1 0.000% 100.023% ** Level 1 read latency histogram (micros): Count: 1110507 Average: 6.5179 StdDev: 114.12 Min: 0 Median: 1.7477 Max: 15515 Percentiles: P50: 1.75 P75: 2.61 P99: 9.31 P99.9: 257.29 P99.99: 1208.43 ------------------------------------------------------ [ 0, 1 ] 103378 9.309% 9.309% ## ( 1, 2 ] 604351 54.421% 63.730% ########### ( 2, 3 ] 204646 18.428% 82.158% #### ( 3, 4 ] 83247 7.496% 89.655% # ( 4, 6 ] 87446 7.874% 97.529% ## ( 6, 10 ] 19760 1.779% 99.309% ( 10, 15 ] 4517 0.407% 99.715% ( 15, 22 ] 565 0.051% 99.766% ( 22, 34 ] 50 0.005% 99.771% ( 34, 51 ] 21 0.002% 99.773% ( 51, 76 ] 25 0.002% 99.775% ( 76, 110 ] 533 0.048% 99.823% ( 110, 170 ] 655 0.059% 99.882% ( 170, 250 ] 193 0.017% 99.899% ( 250, 380 ] 187 0.017% 99.916% ( 380, 580 ] 272 0.024% 99.940% ( 580, 870 ] 329 0.030% 99.970% ( 870, 1300 ] 282 0.025% 99.995% ( 1300, 1900 ] 178 0.016% 100.012% ( 1900, 2900 ] 300 0.027% 100.039% ( 2900, 4400 ] 373 0.034% 100.072% ( 4400, 6600 ] 127 0.011% 100.084% ( 6600, 9900 ] 50 0.005% 100.088% ( 9900, 14000 ] 4 0.000% 100.088% ( 14000, 22000 ] 1 0.000% 100.089% ** Level 2 read latency histogram (micros): Count: 76223 Average: 6.0279 StdDev: 91.80 Min: 0 Median: 1.6908 Max: 10221 Percentiles: P50: 1.69 P75: 2.39 P99: 9.25 P99.9: 955.66 P99.99: 4098.14 ------------------------------------------------------ [ 0, 1 ] 6182 8.110% 8.110% ## ( 1, 2 ] 46224 60.643% 68.754% ############ ( 2, 3 ] 12201 16.007% 84.761% ### ( 3, 4 ] 5072 6.654% 91.415% # ( 4, 6 ] 4720 6.192% 97.607% # ( 6, 10 ] 1308 1.716% 99.323% ( 10, 15 ] 228 0.299% 99.622% ( 15, 22 ] 14 0.018% 99.641% ( 22, 34 ] 3 0.004% 99.644% ( 51, 76 ] 2 0.003% 99.647% ( 76, 110 ] 5 0.007% 99.654% ( 110, 170 ] 16 0.021% 99.675% ( 170, 250 ] 23 0.030% 99.705% ( 250, 380 ] 46 0.060% 99.765% ( 380, 580 ] 56 0.073% 99.839% ( 580, 870 ] 41 0.054% 99.892% ( 870, 1300 ] 29 0.038% 99.930% ( 1300, 1900 ] 9 0.012% 99.942% ( 1900, 2900 ] 22 0.029% 99.971% ( 2900, 4400 ] 18 0.024% 99.995% ( 4400, 6600 ] 2 0.003% 99.997% ( 6600, 9900 ] 1 0.001% 99.999% ( 9900, 14000 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 553426 Average: 12.6977 StdDev: 161.43 Min: 0 Median: 1.9799 Max: 15642 Percentiles: P50: 1.98 P75: 3.04 P99: 11.91 P99.9: 1193.76 P99.99: 1883.50 ------------------------------------------------------ [ 0, 1 ] 13644 2.465% 2.465% ( 1, 2 ] 268460 48.509% 50.974% ########## ( 2, 3 ] 130856 23.645% 74.619% ##### ( 3, 4 ] 59930 10.829% 85.448% ## ( 4, 6 ] 63109 11.403% 96.851% ## ( 6, 10 ] 10882 1.966% 98.817% ( 10, 15 ] 2645 0.478% 99.295% ( 15, 22 ] 304 0.055% 99.350% ( 22, 34 ] 63 0.011% 99.362% ( 34, 51 ] 24 0.004% 99.366% ( 51, 76 ] 8 0.001% 99.367% ( 76, 110 ] 17 0.003% 99.370% ( 110, 170 ] 123 0.022% 99.393% ( 170, 250 ] 265 0.048% 99.441% ( 250, 380 ] 476 0.086% 99.527% ( 380, 580 ] 765 0.138% 99.665% ( 580, 870 ] 898 0.162% 99.827% ( 870, 1300 ] 536 0.097% 99.924% ( 1300, 1900 ] 376 0.068% 99.992% ( 1900, 2900 ] 305 0.055% 100.047% ( 2900, 4400 ] 398 0.072% 100.119% ( 4400, 6600 ] 112 0.020% 100.139% ( 6600, 9900 ] 38 0.007% 100.146% ( 9900, 14000 ] 1 0.000% 100.146% ( 14000, 22000 ] 1 0.000% 100.146% ** Level 4 read latency histogram (micros): Count: 10284 Average: 18.2828 StdDev: 251.78 Min: 1 Median: 1.9888 Max: 9871 Percentiles: P50: 1.99 P75: 3.03 P99: 93.91 P99.9: 4159.25 P99.99: 9051.57 ------------------------------------------------------ [ 0, 1 ] 272 2.645% 2.645% # ( 1, 2 ] 4925 47.890% 50.535% ########## ( 2, 3 ] 2484 24.154% 74.689% ##### ( 3, 4 ] 1179 11.464% 86.153% ## ( 4, 6 ] 1103 10.725% 96.879% ## ( 6, 10 ] 164 1.595% 98.473% ( 10, 15 ] 34 0.331% 98.804% ( 15, 22 ] 10 0.097% 98.901% ( 22, 34 ] 4 0.039% 98.940% ( 34, 51 ] 2 0.019% 98.960% ( 51, 76 ] 1 0.010% 98.969% ( 76, 110 ] 6 0.058% 99.028% ( 110, 170 ] 4 0.039% 99.067% ( 170, 250 ] 26 0.253% 99.319% ( 250, 380 ] 4 0.039% 99.358% ( 380, 580 ] 11 0.107% 99.465% ( 580, 870 ] 9 0.088% 99.553% ( 870, 1300 ] 10 0.097% 99.650% ( 1300, 1900 ] 10 0.097% 99.747% ( 1900, 2900 ] 9 0.088% 99.835% ( 2900, 4400 ] 8 0.078% 99.912% ( 4400, 6600 ] 5 0.049% 99.961% ( 6600, 9900 ] 4 0.039% 100.000% ** Level 5 read latency histogram (micros): Count: 220 Average: 1546.1909 StdDev: 1633.12 Min: 51 Median: 805.5556 Max: 7812 Percentiles: P50: 805.56 P75: 2475.76 P99: 7480.00 P99.9: 7812.00 P99.99: 7812.00 ------------------------------------------------------ ( 34, 51 ] 1 0.455% 0.455% ( 76, 110 ] 13 5.909% 6.364% # ( 110, 170 ] 27 12.273% 18.636% ## ( 170, 250 ] 13 5.909% 24.545% # ( 250, 380 ] 16 7.273% 31.818% # ( 380, 580 ] 19 8.636% 40.455% ## ( 580, 870 ] 27 12.273% 52.727% ## ( 870, 1300 ] 16 7.273% 60.000% # ( 1300, 1900 ] 14 6.364% 66.364% # ( 1900, 2900 ] 33 15.000% 81.364% ### ( 2900, 4400 ] 25 11.364% 92.727% ## ( 4400, 6600 ] 13 5.909% 98.636% # ( 6600, 9900 ] 3 1.364% 100.000% ** DB Stats ** Uptime(secs): 43.2 total, 3.3 interval Cumulative writes: 0 writes, 8000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 7.69 GB, 182.22 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:21.161 H:M:S, 49.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 300.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:0.642 H:M:S, 19.6 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/17-03:27:33 ... thread 0: (1000000,9000000) ops and (332984.5,195756.0) ops/second in (3.003143,45.975605) 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/7 3.81 GB 245.4 7.8 0.0 7.8 16.3 8.5 0.0 1.9 136.9 287.7 57.99 52.04 146 0.397 8058K 11K 0.0 0.0 L1 10/10 1.08 GB 0.0 5.8 4.6 1.2 5.8 4.5 0.1 1.2 219.7 216.5 27.22 25.57 4 6.805 6073K 88K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.1 0.1 0.1 3.5 2.0 236.1 236.0 0.53 0.51 1 0.534 127K 45 0.0 0.0 L3 13/0 919.56 MB 0.9 3.1 1.9 1.2 3.1 1.9 1.8 1.6 135.1 134.8 23.80 14.82 15 1.587 3110K 2522 0.0 0.0 L4 163/0 9.65 GB 1.0 2.0 1.8 0.3 2.0 1.8 1.9 1.1 126.0 125.5 16.38 9.78 18 0.910 2095K 7615 0.0 0.0 L5 1084/0 89.14 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 1287/17 104.58 GB 0.0 18.9 8.4 10.5 27.3 16.8 11.0 3.2 153.5 222.1 125.91 102.72 184 0.684 19M 110K 0.0 0.0 Int 0/0 0.00 KB 0.0 18.9 8.4 10.5 27.3 16.8 10.8 3.2 153.5 222.1 125.91 102.72 184 0.684 19M 110K 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.9 8.4 10.5 18.8 8.3 0.0 0.0 195.4 194.2 98.89 80.63 63 1.570 19M 110K 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 324.0 27.03 22.09 121 0.223 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.2 total, 46.0 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: 27.31 GB write, 605.13 MB/s write, 18.87 GB read, 418.14 MB/s read, 125.9 seconds Interval compaction: 27.31 GB write, 608.20 MB/s write, 18.87 GB read, 420.26 MB/s read, 125.9 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 12, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 12, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 63, pending-compaction-bytes-delays: 1, pending-compaction-bytes-stops: 0, total-delays: 13, total-stops: 63, interval: 76 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3583512 Average: 2.9821 StdDev: 39.92 Min: 0 Median: 1.5004 Max: 11493 Percentiles: P50: 1.50 P75: 1.89 P99: 7.01 P99.9: 149.83 P99.99: 421.31 ------------------------------------------------------ [ 0, 1 ] 629983 17.580% 17.580% #### ( 1, 2 ] 2321595 64.785% 82.366% ############# ( 2, 3 ] 365222 10.192% 92.557% ## ( 3, 4 ] 125882 3.513% 96.070% # ( 4, 6 ] 97616 2.724% 98.794% # ( 6, 10 ] 29103 0.812% 99.606% ( 10, 15 ] 4463 0.125% 99.731% ( 15, 22 ] 701 0.020% 99.750% ( 22, 34 ] 48 0.001% 99.752% ( 34, 51 ] 18 0.001% 99.752% ( 51, 76 ] 15 0.000% 99.753% ( 76, 110 ] 2227 0.062% 99.815% ( 110, 170 ] 4603 0.128% 99.943% ( 170, 250 ] 1003 0.028% 99.971% ( 250, 380 ] 566 0.016% 99.987% ( 380, 580 ] 526 0.015% 100.002% ( 580, 870 ] 273 0.008% 100.009% ( 870, 1300 ] 141 0.004% 100.013% ( 1300, 1900 ] 61 0.002% 100.015% ( 1900, 2900 ] 87 0.002% 100.017% ( 2900, 4400 ] 125 0.003% 100.021% ( 4400, 6600 ] 51 0.001% 100.022% ( 6600, 9900 ] 22 0.001% 100.023% ( 9900, 14000 ] 1 0.000% 100.023% ** Level 1 read latency histogram (micros): Count: 1240414 Average: 6.1427 StdDev: 108.07 Min: 0 Median: 1.7318 Max: 15515 Percentiles: P50: 1.73 P75: 2.55 P99: 9.25 P99.9: 236.44 P99.99: 1189.80 ------------------------------------------------------ [ 0, 1 ] 113156 9.122% 9.122% ## ( 1, 2 ] 692835 55.855% 64.978% ########### ( 2, 3 ] 225157 18.152% 83.129% #### ( 3, 4 ] 87268 7.035% 90.165% # ( 4, 6 ] 91692 7.392% 97.557% # ( 6, 10 ] 22008 1.774% 99.331% ( 10, 15 ] 4788 0.386% 99.717% ( 15, 22 ] 579 0.047% 99.764% ( 22, 34 ] 51 0.004% 99.768% ( 34, 51 ] 22 0.002% 99.770% ( 51, 76 ] 25 0.002% 99.772% ( 76, 110 ] 569 0.046% 99.817% ( 110, 170 ] 806 0.065% 99.882% ( 170, 250 ] 262 0.021% 99.904% ( 250, 380 ] 221 0.018% 99.921% ( 380, 580 ] 296 0.024% 99.945% ( 580, 870 ] 343 0.028% 99.973% ( 870, 1300 ] 285 0.023% 99.996% ( 1300, 1900 ] 178 0.014% 100.010% ( 1900, 2900 ] 300 0.024% 100.034% ( 2900, 4400 ] 373 0.030% 100.064% ( 4400, 6600 ] 127 0.010% 100.075% ( 6600, 9900 ] 50 0.004% 100.079% ( 9900, 14000 ] 4 0.000% 100.079% ( 14000, 22000 ] 1 0.000% 100.079% ** Level 2 read latency histogram (micros): Count: 76223 Average: 6.0279 StdDev: 91.80 Min: 0 Median: 1.6908 Max: 10221 Percentiles: P50: 1.69 P75: 2.39 P99: 9.25 P99.9: 955.66 P99.99: 4098.14 ------------------------------------------------------ [ 0, 1 ] 6182 8.110% 8.110% ## ( 1, 2 ] 46224 60.643% 68.754% ############ ( 2, 3 ] 12201 16.007% 84.761% ### ( 3, 4 ] 5072 6.654% 91.415% # ( 4, 6 ] 4720 6.192% 97.607% # ( 6, 10 ] 1308 1.716% 99.323% ( 10, 15 ] 228 0.299% 99.622% ( 15, 22 ] 14 0.018% 99.641% ( 22, 34 ] 3 0.004% 99.644% ( 51, 76 ] 2 0.003% 99.647% ( 76, 110 ] 5 0.007% 99.654% ( 110, 170 ] 16 0.021% 99.675% ( 170, 250 ] 23 0.030% 99.705% ( 250, 380 ] 46 0.060% 99.765% ( 380, 580 ] 56 0.073% 99.839% ( 580, 870 ] 41 0.054% 99.892% ( 870, 1300 ] 29 0.038% 99.930% ( 1300, 1900 ] 9 0.012% 99.942% ( 1900, 2900 ] 22 0.029% 99.971% ( 2900, 4400 ] 18 0.024% 99.995% ( 4400, 6600 ] 2 0.003% 99.997% ( 6600, 9900 ] 1 0.001% 99.999% ( 9900, 14000 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 553426 Average: 12.6977 StdDev: 161.43 Min: 0 Median: 1.9799 Max: 15642 Percentiles: P50: 1.98 P75: 3.04 P99: 11.91 P99.9: 1193.76 P99.99: 1883.50 ------------------------------------------------------ [ 0, 1 ] 13644 2.465% 2.465% ( 1, 2 ] 268460 48.509% 50.974% ########## ( 2, 3 ] 130856 23.645% 74.619% ##### ( 3, 4 ] 59930 10.829% 85.448% ## ( 4, 6 ] 63109 11.403% 96.851% ## ( 6, 10 ] 10882 1.966% 98.817% ( 10, 15 ] 2645 0.478% 99.295% ( 15, 22 ] 304 0.055% 99.350% ( 22, 34 ] 63 0.011% 99.362% ( 34, 51 ] 24 0.004% 99.366% ( 51, 76 ] 8 0.001% 99.367% ( 76, 110 ] 17 0.003% 99.370% ( 110, 170 ] 123 0.022% 99.393% ( 170, 250 ] 265 0.048% 99.441% ( 250, 380 ] 476 0.086% 99.527% ( 380, 580 ] 765 0.138% 99.665% ( 580, 870 ] 898 0.162% 99.827% ( 870, 1300 ] 536 0.097% 99.924% ( 1300, 1900 ] 376 0.068% 99.992% ( 1900, 2900 ] 305 0.055% 100.047% ( 2900, 4400 ] 398 0.072% 100.119% ( 4400, 6600 ] 112 0.020% 100.139% ( 6600, 9900 ] 38 0.007% 100.146% ( 9900, 14000 ] 1 0.000% 100.146% ( 14000, 22000 ] 1 0.000% 100.146% ** Level 4 read latency histogram (micros): Count: 10284 Average: 18.2828 StdDev: 251.78 Min: 1 Median: 1.9888 Max: 9871 Percentiles: P50: 1.99 P75: 3.03 P99: 93.91 P99.9: 4159.25 P99.99: 9051.57 ------------------------------------------------------ [ 0, 1 ] 272 2.645% 2.645% # ( 1, 2 ] 4925 47.890% 50.535% ########## ( 2, 3 ] 2484 24.154% 74.689% ##### ( 3, 4 ] 1179 11.464% 86.153% ## ( 4, 6 ] 1103 10.725% 96.879% ## ( 6, 10 ] 164 1.595% 98.473% ( 10, 15 ] 34 0.331% 98.804% ( 15, 22 ] 10 0.097% 98.901% ( 22, 34 ] 4 0.039% 98.940% ( 34, 51 ] 2 0.019% 98.960% ( 51, 76 ] 1 0.010% 98.969% ( 76, 110 ] 6 0.058% 99.028% ( 110, 170 ] 4 0.039% 99.067% ( 170, 250 ] 26 0.253% 99.319% ( 250, 380 ] 4 0.039% 99.358% ( 380, 580 ] 11 0.107% 99.465% ( 580, 870 ] 9 0.088% 99.553% ( 870, 1300 ] 10 0.097% 99.650% ( 1300, 1900 ] 10 0.097% 99.747% ( 1900, 2900 ] 9 0.088% 99.835% ( 2900, 4400 ] 8 0.078% 99.912% ( 4400, 6600 ] 5 0.049% 99.961% ( 6600, 9900 ] 4 0.039% 100.000% ** Level 5 read latency histogram (micros): Count: 220 Average: 1546.1909 StdDev: 1633.12 Min: 51 Median: 805.5556 Max: 7812 Percentiles: P50: 805.56 P75: 2475.76 P99: 7480.00 P99.9: 7812.00 P99.99: 7812.00 ------------------------------------------------------ ( 34, 51 ] 1 0.455% 0.455% ( 76, 110 ] 13 5.909% 6.364% # ( 110, 170 ] 27 12.273% 18.636% ## ( 170, 250 ] 13 5.909% 24.545% # ( 250, 380 ] 16 7.273% 31.818% # ( 380, 580 ] 19 8.636% 40.455% ## ( 580, 870 ] 27 12.273% 52.727% ## ( 870, 1300 ] 16 7.273% 60.000% # ( 1300, 1900 ] 14 6.364% 66.364% # ( 1900, 2900 ] 33 15.000% 81.364% ### ( 2900, 4400 ] 25 11.364% 92.727% ## ( 4400, 6600 ] 13 5.909% 98.636% # ( 6600, 9900 ] 3 1.364% 100.000% ** DB Stats ** Uptime(secs): 46.2 total, 3.0 interval Cumulative writes: 0 writes, 9000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 8.65 GB, 191.68 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.560 H:M:S, 46.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 327.78 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.399 H:M:S, 13.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/17-03:27:36 ... thread 0: (1000000,10000000) ops and (326546.0,203923.7) ops/second in (3.062356,49.037961) 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 3.56 GB 333.5 8.9 0.0 8.9 18.3 9.5 0.0 1.9 139.4 288.3 65.06 58.72 163 0.399 9209K 13K 0.0 0.0 L1 26/0 2.23 GB 228.1 8.1 5.8 2.3 8.0 5.7 0.1 1.4 208.8 206.1 39.65 35.91 5 7.930 7283K 88K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.1 0.1 0.1 3.5 2.0 236.1 236.0 0.53 0.51 1 0.534 127K 45 0.0 0.0 L3 13/0 919.56 MB 0.9 3.1 1.9 1.2 3.1 1.9 1.8 1.6 135.1 134.8 23.80 14.82 15 1.587 3110K 2522 0.0 0.0 L4 163/0 9.65 GB 1.0 2.0 1.8 0.3 2.0 1.8 1.9 1.1 126.0 125.5 16.38 9.78 18 0.910 2095K 7615 0.0 0.0 L5 1084/0 89.14 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 1301/4 105.48 GB 0.0 22.2 9.5 12.7 31.6 18.9 11.0 3.3 156.5 222.3 145.42 119.75 202 0.720 21M 111K 0.0 0.0 Int 0/0 0.00 KB 0.0 22.2 9.5 12.7 31.6 18.9 10.8 3.3 156.5 222.3 145.42 119.75 202 0.720 21M 111K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 22.2 9.5 12.7 22.1 9.4 0.0 0.0 196.7 195.5 115.69 95.26 68 1.701 21M 111K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 9.5 9.5 0.0 0.0 0.0 326.3 29.73 24.48 134 0.222 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 49.3 total, 49.0 interval Flush(GB): cumulative 9.474, interval 9.474 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 31.56 GB write, 655.97 MB/s write, 22.22 GB read, 461.76 MB/s read, 145.4 seconds Interval compaction: 31.56 GB write, 659.09 MB/s write, 22.22 GB read, 463.95 MB/s read, 145.4 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 12, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 12, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 67, pending-compaction-bytes-delays: 1, pending-compaction-bytes-stops: 0, total-delays: 13, total-stops: 67, interval: 80 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3843713 Average: 2.9283 StdDev: 38.79 Min: 0 Median: 1.4965 Max: 11493 Percentiles: P50: 1.50 P75: 1.88 P99: 6.81 P99.9: 146.61 P99.99: 403.74 ------------------------------------------------------ [ 0, 1 ] 683223 17.775% 17.775% #### ( 1, 2 ] 2494762 64.905% 82.680% ############# ( 2, 3 ] 386698 10.061% 92.741% ## ( 3, 4 ] 132615 3.450% 96.191% # ( 4, 6 ] 101888 2.651% 98.842% # ( 6, 10 ] 30080 0.783% 99.624% ( 10, 15 ] 4726 0.123% 99.747% ( 15, 22 ] 726 0.019% 99.766% ( 22, 34 ] 50 0.001% 99.767% ( 34, 51 ] 18 0.000% 99.768% ( 51, 76 ] 18 0.000% 99.768% ( 76, 110 ] 2247 0.058% 99.827% ( 110, 170 ] 4621 0.120% 99.947% ( 170, 250 ] 1021 0.027% 99.973% ( 250, 380 ] 573 0.015% 99.988% ( 380, 580 ] 536 0.014% 100.002% ( 580, 870 ] 280 0.007% 100.010% ( 870, 1300 ] 148 0.004% 100.013% ( 1300, 1900 ] 63 0.002% 100.015% ( 1900, 2900 ] 87 0.002% 100.017% ( 2900, 4400 ] 129 0.003% 100.021% ( 4400, 6600 ] 51 0.001% 100.022% ( 6600, 9900 ] 22 0.001% 100.023% ( 9900, 14000 ] 1 0.000% 100.023% ** Level 1 read latency histogram (micros): Count: 1297953 Average: 6.0388 StdDev: 105.96 Min: 0 Median: 1.7253 Max: 15515 Percentiles: P50: 1.73 P75: 2.53 P99: 9.25 P99.9: 239.19 P99.99: 1212.57 ------------------------------------------------------ [ 0, 1 ] 117748 9.072% 9.072% ## ( 1, 2 ] 732424 56.429% 65.501% ########### ( 2, 3 ] 233482 17.988% 83.489% #### ( 3, 4 ] 89161 6.869% 90.359% # ( 4, 6 ] 93439 7.199% 97.558% # ( 6, 10 ] 23045 1.775% 99.333% ( 10, 15 ] 4910 0.378% 99.712% ( 15, 22 ] 587 0.045% 99.757% ( 22, 34 ] 51 0.004% 99.761% ( 34, 51 ] 22 0.002% 99.762% ( 51, 76 ] 27 0.002% 99.764% ( 76, 110 ] 613 0.047% 99.812% ( 110, 170 ] 903 0.070% 99.881% ( 170, 250 ] 281 0.022% 99.903% ( 250, 380 ] 235 0.018% 99.921% ( 380, 580 ] 302 0.023% 99.944% ( 580, 870 ] 355 0.027% 99.972% ( 870, 1300 ] 299 0.023% 99.995% ( 1300, 1900 ] 193 0.015% 100.010% ( 1900, 2900 ] 302 0.023% 100.033% ( 2900, 4400 ] 374 0.029% 100.062% ( 4400, 6600 ] 127 0.010% 100.071% ( 6600, 9900 ] 50 0.004% 100.075% ( 9900, 14000 ] 4 0.000% 100.076% ( 14000, 22000 ] 1 0.000% 100.076% ** Level 2 read latency histogram (micros): Count: 76223 Average: 6.0279 StdDev: 91.80 Min: 0 Median: 1.6908 Max: 10221 Percentiles: P50: 1.69 P75: 2.39 P99: 9.25 P99.9: 955.66 P99.99: 4098.14 ------------------------------------------------------ [ 0, 1 ] 6182 8.110% 8.110% ## ( 1, 2 ] 46224 60.643% 68.754% ############ ( 2, 3 ] 12201 16.007% 84.761% ### ( 3, 4 ] 5072 6.654% 91.415% # ( 4, 6 ] 4720 6.192% 97.607% # ( 6, 10 ] 1308 1.716% 99.323% ( 10, 15 ] 228 0.299% 99.622% ( 15, 22 ] 14 0.018% 99.641% ( 22, 34 ] 3 0.004% 99.644% ( 51, 76 ] 2 0.003% 99.647% ( 76, 110 ] 5 0.007% 99.654% ( 110, 170 ] 16 0.021% 99.675% ( 170, 250 ] 23 0.030% 99.705% ( 250, 380 ] 46 0.060% 99.765% ( 380, 580 ] 56 0.073% 99.839% ( 580, 870 ] 41 0.054% 99.892% ( 870, 1300 ] 29 0.038% 99.930% ( 1300, 1900 ] 9 0.012% 99.942% ( 1900, 2900 ] 22 0.029% 99.971% ( 2900, 4400 ] 18 0.024% 99.995% ( 4400, 6600 ] 2 0.003% 99.997% ( 6600, 9900 ] 1 0.001% 99.999% ( 9900, 14000 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 553426 Average: 12.6977 StdDev: 161.43 Min: 0 Median: 1.9799 Max: 15642 Percentiles: P50: 1.98 P75: 3.04 P99: 11.91 P99.9: 1193.76 P99.99: 1883.50 ------------------------------------------------------ [ 0, 1 ] 13644 2.465% 2.465% ( 1, 2 ] 268460 48.509% 50.974% ########## ( 2, 3 ] 130856 23.645% 74.619% ##### ( 3, 4 ] 59930 10.829% 85.448% ## ( 4, 6 ] 63109 11.403% 96.851% ## ( 6, 10 ] 10882 1.966% 98.817% ( 10, 15 ] 2645 0.478% 99.295% ( 15, 22 ] 304 0.055% 99.350% ( 22, 34 ] 63 0.011% 99.362% ( 34, 51 ] 24 0.004% 99.366% ( 51, 76 ] 8 0.001% 99.367% ( 76, 110 ] 17 0.003% 99.370% ( 110, 170 ] 123 0.022% 99.393% ( 170, 250 ] 265 0.048% 99.441% ( 250, 380 ] 476 0.086% 99.527% ( 380, 580 ] 765 0.138% 99.665% ( 580, 870 ] 898 0.162% 99.827% ( 870, 1300 ] 536 0.097% 99.924% ( 1300, 1900 ] 376 0.068% 99.992% ( 1900, 2900 ] 305 0.055% 100.047% ( 2900, 4400 ] 398 0.072% 100.119% ( 4400, 6600 ] 112 0.020% 100.139% ( 6600, 9900 ] 38 0.007% 100.146% ( 9900, 14000 ] 1 0.000% 100.146% ( 14000, 22000 ] 1 0.000% 100.146% ** Level 4 read latency histogram (micros): Count: 10284 Average: 18.2828 StdDev: 251.78 Min: 1 Median: 1.9888 Max: 9871 Percentiles: P50: 1.99 P75: 3.03 P99: 93.91 P99.9: 4159.25 P99.99: 9051.57 ------------------------------------------------------ [ 0, 1 ] 272 2.645% 2.645% # ( 1, 2 ] 4925 47.890% 50.535% ########## ( 2, 3 ] 2484 24.154% 74.689% ##### ( 3, 4 ] 1179 11.464% 86.153% ## ( 4, 6 ] 1103 10.725% 96.879% ## ( 6, 10 ] 164 1.595% 98.473% ( 10, 15 ] 34 0.331% 98.804% ( 15, 22 ] 10 0.097% 98.901% ( 22, 34 ] 4 0.039% 98.940% ( 34, 51 ] 2 0.019% 98.960% ( 51, 76 ] 1 0.010% 98.969% ( 76, 110 ] 6 0.058% 99.028% ( 110, 170 ] 4 0.039% 99.067% ( 170, 250 ] 26 0.253% 99.319% ( 250, 380 ] 4 0.039% 99.358% ( 380, 580 ] 11 0.107% 99.465% ( 580, 870 ] 9 0.088% 99.553% ( 870, 1300 ] 10 0.097% 99.650% ( 1300, 1900 ] 10 0.097% 99.747% ( 1900, 2900 ] 9 0.088% 99.835% ( 2900, 4400 ] 8 0.078% 99.912% ( 4400, 6600 ] 5 0.049% 99.961% ( 6600, 9900 ] 4 0.039% 100.000% ** Level 5 read latency histogram (micros): Count: 220 Average: 1546.1909 StdDev: 1633.12 Min: 51 Median: 805.5556 Max: 7812 Percentiles: P50: 805.56 P75: 2475.76 P99: 7480.00 P99.9: 7812.00 P99.99: 7812.00 ------------------------------------------------------ ( 34, 51 ] 1 0.455% 0.455% ( 76, 110 ] 13 5.909% 6.364% # ( 110, 170 ] 27 12.273% 18.636% ## ( 170, 250 ] 13 5.909% 24.545% # ( 250, 380 ] 16 7.273% 31.818% # ( 380, 580 ] 19 8.636% 40.455% ## ( 580, 870 ] 27 12.273% 52.727% ## ( 870, 1300 ] 16 7.273% 60.000% # ( 1300, 1900 ] 14 6.364% 66.364% # ( 1900, 2900 ] 33 15.000% 81.364% ### ( 2900, 4400 ] 25 11.364% 92.727% ## ( 4400, 6600 ] 13 5.909% 98.636% # ( 6600, 9900 ] 3 1.364% 100.000% ** DB Stats ** Uptime(secs): 49.3 total, 3.1 interval Cumulative writes: 0 writes, 10M keys, 0 commit groups, 0.0 writes per commit group, ingest: 9.61 GB, 199.74 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.037 H:M:S, 44.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 321.38 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.477 H:M:S, 15.6 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] overwrite : 5.954 micros/op 167941 ops/sec 60.057 seconds 10085999 operations; 162.7 MB/s Microseconds per write: Count: 10085999 Average: 5.9545 StdDev: 476.13 Min: 0 Median: 1.7202 Max: 891989 Percentiles: P50: 1.72 P75: 2.71 P99: 8.93 P99.9: 1178.94 P99.99: 2757.10 ------------------------------------------------------ [ 0, 1 ] 1434652 14.224% 14.224% ### ( 1, 2 ] 5009967 49.672% 63.897% ########## ( 2, 3 ] 1578718 15.653% 79.549% ### ( 3, 4 ] 1377215 13.655% 93.204% ### ( 4, 6 ] 506768 5.024% 98.228% # ( 6, 10 ] 106408 1.055% 99.283% ( 10, 15 ] 33101 0.328% 99.612% ( 15, 22 ] 8357 0.083% 99.694% ( 22, 34 ] 1517 0.015% 99.710% ( 34, 51 ] 209 0.002% 99.712% ( 51, 76 ] 19 0.000% 99.712% ( 76, 110 ] 7210 0.071% 99.783% ( 110, 170 ] 2553 0.025% 99.809% ( 170, 250 ] 304 0.003% 99.812% ( 250, 380 ] 141 0.001% 99.813% ( 380, 580 ] 14 0.000% 99.813% ( 580, 870 ] 14 0.000% 99.813% ( 870, 1300 ] 12173 0.121% 99.934% ( 1300, 1900 ] 21 0.000% 99.934% ( 1900, 2900 ] 6568 0.065% 99.999% ( 2900, 4400 ] 31 0.000% 100.000% ( 4400, 6600 ] 5 0.000% 100.000% ( 6600, 9900 ] 3 0.000% 100.000% ( 14000, 22000 ] 5 0.000% 100.000% ( 22000, 33000 ] 2 0.000% 100.000% ( 33000, 50000 ] 2 0.000% 100.000% ( 75000, 110000 ] 1 0.000% 100.000% ( 110000, 170000 ] 1 0.000% 100.000% ( 170000, 250000 ] 17 0.000% 100.000% ( 570000, 860000 ] 2 0.000% 100.000% ( 860000, 1200000 ] 1 0.000% 100.000% STATISTICS: rocksdb.block.cache.miss COUNT : 0 rocksdb.block.cache.hit COUNT : 0 rocksdb.block.cache.add COUNT : 0 rocksdb.block.cache.add.failures COUNT : 0 rocksdb.block.cache.index.miss COUNT : 0 rocksdb.block.cache.index.hit COUNT : 0 rocksdb.block.cache.index.add COUNT : 0 rocksdb.block.cache.index.bytes.insert COUNT : 0 rocksdb.block.cache.filter.miss COUNT : 0 rocksdb.block.cache.filter.hit COUNT : 0 rocksdb.block.cache.filter.add COUNT : 0 rocksdb.block.cache.filter.bytes.insert COUNT : 0 rocksdb.block.cache.data.miss COUNT : 0 rocksdb.block.cache.data.hit COUNT : 0 rocksdb.block.cache.data.add COUNT : 0 rocksdb.block.cache.data.bytes.insert COUNT : 0 rocksdb.block.cache.bytes.read COUNT : 0 rocksdb.block.cache.bytes.write COUNT : 0 rocksdb.bloom.filter.useful COUNT : 0 rocksdb.bloom.filter.full.positive COUNT : 0 rocksdb.bloom.filter.full.true.positive COUNT : 0 rocksdb.persistent.cache.hit COUNT : 0 rocksdb.persistent.cache.miss COUNT : 0 rocksdb.sim.block.cache.hit COUNT : 0 rocksdb.sim.block.cache.miss COUNT : 0 rocksdb.memtable.hit COUNT : 0 rocksdb.memtable.miss COUNT : 0 rocksdb.l0.hit COUNT : 0 rocksdb.l1.hit COUNT : 0 rocksdb.l2andup.hit COUNT : 0 rocksdb.compaction.key.drop.new COUNT : 184535 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 : 10085999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 10408750968 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 : 476 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 32665292 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 : 26631420338 rocksdb.compact.write.bytes COUNT : 26450931464 rocksdb.flush.write.bytes COUNT : 10370751749 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 : 52 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 : 283 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 : 10287389696 rocksdb.memtable.garbage.bytes.at.flush COUNT : 4238336 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 : 26724497244 rocksdb.non.last.level.read.count COUNT : 6453693 rocksdb.block.checksum.compute.count COUNT : 6452793 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.367716 P95 : 3.871138 P99 : 7.319137 P100 : 891984.000000 COUNT : 10085999 SUM : 55441385 rocksdb.compaction.times.micros P50 : 1130740.740741 P95 : 5436666.666667 P99 : 16480000.000000 P100 : 19918385.000000 COUNT : 69 SUM : 116865727 rocksdb.compaction.times.cpu_micros P50 : 905769.230769 P95 : 3670000.000000 P99 : 16480000.000000 P100 : 18477377.000000 COUNT : 69 SUM : 96420594 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 : 655.400000 P95 : 1200.562500 P99 : 13241.500000 P100 : 103277.000000 COUNT : 137 SUM : 224319 rocksdb.compaction.outfile.sync.micros P50 : 987.272727 P95 : 62500.000000 P99 : 110000.000000 P100 : 153679.000000 COUNT : 300 SUM : 2844217 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 : 119.750000 P95 : 1731.250000 P99 : 3675.000000 P100 : 5226.000000 COUNT : 245 SUM : 88673 rocksdb.table.open.io.micros P50 : 1745.454545 P95 : 9991.111111 P99 : 19461.333333 P100 : 21835.000000 COUNT : 476 SUM : 1338988 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.601266 P95 : 7.474204 P99 : 10.972816 P100 : 15646.000000 COUNT : 6451585 SUM : 41347385 rocksdb.read.block.get.micros P50 : 571.111111 P95 : 4213.114754 P99 : 7944.000000 P100 : 10318.000000 COUNT : 952 SUM : 1066250 rocksdb.write.raw.block.micros P50 : 0.512573 P95 : 0.973888 P99 : 2.755319 P100 : 30805.000000 COUNT : 8917835 SUM : 18665010 rocksdb.numfiles.in.singlecompaction P50 : 3.302632 P95 : 7.000000 P99 : 31.600000 P100 : 40.000000 COUNT : 120 SUM : 481 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.563614 P95 : 1237.872402 P99 : 2650.259621 P100 : 891798.000000 COUNT : 166930 SUM : 32680923 rocksdb.sst.read.micros P50 : 1.551050 P95 : 4.386120 P99 : 8.309978 P100 : 15642.000000 COUNT : 6454100 SUM : 28502948 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 : 10085999 SUM : 10408750968 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 : 209545.454545 P95 : 423700.000000 P99 : 806350.000000 P100 : 980389.000000 COUNT : 137 SUM : 30278946 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 : 291 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