[2024-07-21 12:44:48.637133] Starting SPDK v24.05.1-pre git sha1 5fa2f5086 / DPDK 22.11.4 initialization... [2024-07-21 12:44:48.637238] [ 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_pid1983059 ] Set seed to 1721558688634684 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-07-21 12:44:48.721753] app.c: 909:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-07-21 12:44:48.763775] app.c: 604:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-07-21 12:44:48.763826] app.c: 605:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 1983059' to capture a snapshot of events at runtime. [2024-07-21 12:44:48.763836] app.c: 610:app_setup_trace: *NOTICE*: 'spdk_trace' without parameters will also work if this is the only [2024-07-21 12:44:48.763846] app.c: 611:app_setup_trace: *NOTICE*: SPDK application currently running. [2024-07-21 12:44:48.763853] app.c: 612:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid1983059 for offline analysis/debug. [2024-07-21 12:44:48.763936] reactor.c: 937:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Sun Jul 21 12:44:53 2024 CPU: 96 * Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz CPUCache: 36608 KB 2024/07/21-12:44:56 ... thread 0: (1000000,1000000) ops and (338488.3,338488.3) ops/second in (2.954312,2.954312) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 10/9 692.99 MB 6.3 0.0 0.0 0.0 0.9 0.9 0.0 1.0 0.0 346.7 2.54 2.30 12 0.212 0 0 0.0 0.0 L2 3/2 237.43 MB 0.5 0.3 0.2 0.2 0.3 0.2 0.0 1.8 259.3 259.2 1.35 1.30 2 0.673 354K 177 0.0 0.0 L3 11/0 881.90 MB 0.9 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 116/0 9.54 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1040/0 85.69 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1180/11 97.00 GB 0.0 0.3 0.2 0.2 1.2 1.0 0.0 1.4 89.8 316.4 3.89 3.60 14 0.278 354K 177 0.0 0.0 Int 0/0 0.00 KB 0.0 0.3 0.2 0.2 1.2 1.0 0.0 1.4 89.8 316.4 3.89 3.60 14 0.278 354K 177 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.2 0.3 0.2 0.0 0.0 259.3 259.2 1.35 1.30 2 0.673 354K 177 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 0.9 0.9 0.0 0.0 0.0 346.7 2.54 2.30 12 0.212 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 3.2 total, 3.0 interval Flush(GB): cumulative 0.861, interval 0.861 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 1.20 GB write, 389.71 MB/s write, 0.34 GB read, 110.56 MB/s read, 3.9 seconds Interval compaction: 1.20 GB write, 416.44 MB/s write, 0.34 GB read, 118.14 MB/s read, 3.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: 2, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 2, interval: 2 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 133420 Average: 1.9610 StdDev: 14.79 Min: 1 Median: 1.2962 Max: 3069 Percentiles: P50: 1.30 P75: 1.72 P99: 4.92 P99.9: 9.41 P99.99: 144.93 ------------------------------------------------------ [ 0, 1 ] 43625 32.697% 32.697% ####### ( 1, 2 ] 77962 58.434% 91.131% ############ ( 2, 3 ] 6865 5.145% 96.276% # ( 3, 4 ] 2900 2.174% 98.450% ( 4, 6 ] 1629 1.221% 99.671% ( 6, 10 ] 380 0.285% 99.956% ( 10, 15 ] 42 0.031% 99.987% ( 15, 22 ] 10 0.007% 99.995% ( 22, 34 ] 3 0.002% 99.997% ( 34, 51 ] 4 0.003% 100.000% ( 110, 170 ] 8 0.006% 100.006% ( 170, 250 ] 2 0.001% 100.007% ( 250, 380 ] 5 0.004% 100.011% ( 380, 580 ] 2 0.001% 100.013% ( 580, 870 ] 2 0.001% 100.014% ( 870, 1300 ] 2 0.001% 100.016% ( 1300, 1900 ] 1 0.001% 100.016% ( 1900, 2900 ] 2 0.001% 100.018% ( 2900, 4400 ] 1 0.001% 100.019% ** Level 1 read latency histogram (micros): Count: 12359 Average: 3.3289 StdDev: 50.63 Min: 1 Median: 1.1995 Max: 3743 Percentiles: P50: 1.20 P75: 1.70 P99: 10.20 P99.9: 277.78 P99.99: 3473.07 ------------------------------------------------------ [ 0, 1 ] 4943 39.995% 39.995% ######## ( 1, 2 ] 6198 50.150% 90.145% ########## ( 2, 3 ] 755 6.109% 96.254% # ( 3, 4 ] 102 0.825% 97.079% ( 4, 6 ] 88 0.712% 97.791% ( 6, 10 ] 148 1.198% 98.989% ( 10, 15 ] 36 0.291% 99.280% ( 15, 22 ] 5 0.040% 99.320% ( 22, 34 ] 1 0.008% 99.328% ( 34, 51 ] 41 0.332% 99.660% ( 51, 76 ] 15 0.121% 99.782% ( 76, 110 ] 4 0.032% 99.814% ( 110, 170 ] 2 0.016% 99.830% ( 170, 250 ] 8 0.065% 99.895% ( 250, 380 ] 3 0.024% 99.919% ( 380, 580 ] 6 0.049% 99.968% ( 580, 870 ] 1 0.008% 99.976% ( 1900, 2900 ] 1 0.008% 99.984% ( 2900, 4400 ] 2 0.016% 100.000% ** Level 2 read latency histogram (micros): Count: 68476 Average: 1.9622 StdDev: 5.73 Min: 0 Median: 1.3526 Max: 1046 Percentiles: P50: 1.35 P75: 1.77 P99: 5.32 P99.9: 9.89 P99.99: 176.10 ------------------------------------------------------ [ 0, 1 ] 19614 28.644% 28.644% ###### ( 1, 2 ] 41477 60.572% 89.215% ############ ( 2, 3 ] 4246 6.201% 95.416% # ( 3, 4 ] 1767 2.580% 97.996% # ( 4, 6 ] 1042 1.522% 99.518% ( 6, 10 ] 270 0.394% 99.912% ( 10, 15 ] 43 0.063% 99.975% ( 15, 22 ] 5 0.007% 99.982% ( 22, 34 ] 2 0.003% 99.985% ( 34, 51 ] 1 0.001% 99.987% ( 110, 170 ] 3 0.004% 99.991% ( 170, 250 ] 2 0.003% 99.994% ( 250, 380 ] 2 0.003% 99.997% ( 380, 580 ] 1 0.001% 99.999% ( 580, 870 ] 1 0.001% 100.000% ( 870, 1300 ] 1 0.001% 100.001% ** Level 3 read latency histogram (micros): Count: 55 Average: 1562.8000 StdDev: 1301.35 Min: 67 Median: 913.0000 Max: 4882 Percentiles: P50: 913.00 P75: 2650.00 P99: 4882.00 P99.9: 4882.00 P99.99: 4882.00 ------------------------------------------------------ ( 51, 76 ] 1 1.818% 1.818% ( 110, 170 ] 1 1.818% 3.636% ( 170, 250 ] 3 5.455% 9.091% # ( 250, 380 ] 3 5.455% 14.545% # ( 380, 580 ] 9 16.364% 30.909% ### ( 580, 870 ] 10 18.182% 49.091% #### ( 870, 1300 ] 5 9.091% 58.182% ## ( 1300, 1900 ] 4 7.273% 65.455% # ( 1900, 2900 ] 7 12.727% 78.182% ### ( 2900, 4400 ] 11 20.000% 98.182% #### ( 4400, 6600 ] 1 1.818% 100.000% ** Level 4 read latency histogram (micros): Count: 20 Average: 1786.4000 StdDev: 1617.18 Min: 153 Median: 1085.0000 Max: 5116 Percentiles: P50: 1085.00 P75: 3275.00 P99: 5116.00 P99.9: 5116.00 P99.99: 5116.00 ------------------------------------------------------ ( 110, 170 ] 1 5.000% 5.000% # ( 170, 250 ] 4 20.000% 25.000% #### ( 380, 580 ] 1 5.000% 30.000% # ( 580, 870 ] 2 10.000% 40.000% ## ( 870, 1300 ] 4 20.000% 60.000% #### ( 1300, 1900 ] 1 5.000% 65.000% # ( 1900, 2900 ] 1 5.000% 70.000% # ( 2900, 4400 ] 4 20.000% 90.000% #### ( 4400, 6600 ] 2 10.000% 100.000% ## ** DB Stats ** Uptime(secs): 3.2 total, 3.0 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 311.54 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.421 H:M:S, 13.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 332.82 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.421 H:M:S, 14.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/07/21-12:44:59 ... thread 0: (1000000,2000000) ops and (329961.7,334170.6) ops/second in (3.030655,5.984967) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 10/4 1.35 GB 113.3 0.9 0.0 0.9 2.7 1.8 0.0 1.5 101.0 317.4 8.73 8.08 29 0.301 895K 977 0.0 0.0 L1 1/0 2.99 MB 0.3 0.3 0.3 0.0 0.3 0.3 0.2 1.0 245.6 245.2 1.28 1.25 1 1.283 319K 437 0.0 0.0 L2 2/1 147.32 MB 1.0 0.3 0.2 0.2 0.3 0.2 0.4 1.8 259.3 259.2 1.35 1.30 2 0.673 354K 177 0.0 0.0 L3 20/11 1.09 GB 0.2 0.2 0.2 0.0 0.2 0.2 0.2 1.0 229.7 229.7 0.81 0.75 1 0.815 189K 0 0.0 0.0 L4 173/0 9.70 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.0 1.0 127.8 127.8 1.32 0.89 1 1.317 170K 0 0.0 0.0 L5 1040/0 85.69 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1246/16 97.98 GB 0.0 1.9 0.8 1.0 3.7 2.7 0.7 2.0 141.0 280.9 13.49 12.27 34 0.397 1930K 1591 0.0 0.0 Int 0/0 0.00 KB 0.0 1.9 0.8 1.0 3.7 2.7 0.7 2.0 141.0 280.9 13.49 12.27 34 0.397 1930K 1591 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.9 0.8 1.0 1.9 0.8 0.0 0.0 234.1 233.9 8.12 7.47 8 1.015 1930K 1591 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 352.0 5.37 4.80 26 0.207 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 6.2 total, 6.0 interval Flush(GB): cumulative 1.846, interval 1.846 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.70 GB write, 612.32 MB/s write, 1.86 GB read, 307.24 MB/s read, 13.5 seconds Interval compaction: 3.70 GB write, 633.05 MB/s write, 1.86 GB read, 317.64 MB/s read, 13.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: 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: 404012 Average: 2.1637 StdDev: 13.16 Min: 0 Median: 1.4604 Max: 3902 Percentiles: P50: 1.46 P75: 1.86 P99: 5.52 P99.9: 9.92 P99.99: 15.74 ------------------------------------------------------ [ 0, 1 ] 84239 20.851% 20.851% #### ( 1, 2 ] 255779 63.310% 84.160% ############# ( 2, 3 ] 38045 9.417% 93.577% ## ( 3, 4 ] 15134 3.746% 97.323% # ( 4, 6 ] 8907 2.205% 99.528% ( 6, 10 ] 1535 0.380% 99.908% ( 10, 15 ] 329 0.081% 99.989% ( 15, 22 ] 34 0.008% 99.998% ( 22, 34 ] 6 0.001% 99.999% ( 34, 51 ] 5 0.001% 100.000% ( 51, 76 ] 2 0.000% 100.001% ( 110, 170 ] 11 0.003% 100.003% ( 170, 250 ] 13 0.003% 100.007% ( 250, 380 ] 11 0.003% 100.009% ( 380, 580 ] 3 0.001% 100.010% ( 580, 870 ] 10 0.002% 100.013% ( 870, 1300 ] 5 0.001% 100.014% ( 1300, 1900 ] 1 0.000% 100.014% ( 1900, 2900 ] 3 0.001% 100.015% ( 2900, 4400 ] 3 0.001% 100.016% ** Level 1 read latency histogram (micros): Count: 12379 Average: 3.5172 StdDev: 51.55 Min: 1 Median: 1.2000 Max: 3743 Percentiles: P50: 1.20 P75: 1.70 P99: 11.00 P99.9: 354.39 P99.99: 3471.57 ------------------------------------------------------ [ 0, 1 ] 4948 39.971% 39.971% ######## ( 1, 2 ] 6206 50.133% 90.104% ########## ( 2, 3 ] 755 6.099% 96.203% # ( 3, 4 ] 103 0.832% 97.035% ( 4, 6 ] 88 0.711% 97.746% ( 6, 10 ] 148 1.196% 98.942% ( 10, 15 ] 36 0.291% 99.233% ( 15, 22 ] 5 0.040% 99.273% ( 22, 34 ] 1 0.008% 99.281% ( 34, 51 ] 41 0.331% 99.612% ( 51, 76 ] 15 0.121% 99.733% ( 76, 110 ] 4 0.032% 99.766% ( 110, 170 ] 2 0.016% 99.782% ( 170, 250 ] 9 0.073% 99.855% ( 250, 380 ] 7 0.057% 99.911% ( 380, 580 ] 6 0.048% 99.960% ( 580, 870 ] 1 0.008% 99.968% ( 870, 1300 ] 1 0.008% 99.976% ( 1900, 2900 ] 1 0.008% 99.984% ( 2900, 4400 ] 2 0.016% 100.000% ** Level 2 read latency histogram (micros): Count: 76153 Average: 2.0040 StdDev: 5.44 Min: 0 Median: 1.3850 Max: 1046 Percentiles: P50: 1.39 P75: 1.79 P99: 5.42 P99.9: 9.92 P99.99: 157.69 ------------------------------------------------------ [ 0, 1 ] 20163 26.477% 26.477% ##### ( 1, 2 ] 46524 61.093% 87.570% ############ ( 2, 3 ] 5558 7.298% 94.868% # ( 3, 4 ] 2200 2.889% 97.757% # ( 4, 6 ] 1330 1.746% 99.504% ( 6, 10 ] 308 0.404% 99.908% ( 10, 15 ] 51 0.067% 99.975% ( 15, 22 ] 5 0.007% 99.982% ( 22, 34 ] 2 0.003% 99.984% ( 34, 51 ] 1 0.001% 99.986% ( 51, 76 ] 1 0.001% 99.987% ( 110, 170 ] 3 0.004% 99.991% ( 170, 250 ] 2 0.003% 99.993% ( 250, 380 ] 2 0.003% 99.996% ( 380, 580 ] 1 0.001% 99.997% ( 580, 870 ] 1 0.001% 99.999% ( 870, 1300 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 194874 Average: 3.5384 StdDev: 37.40 Min: 1 Median: 1.6606 Max: 4882 Percentiles: P50: 1.66 P75: 2.24 P99: 9.02 P99.9: 170.94 P99.99: 464.36 ------------------------------------------------------ [ 0, 1 ] 18667 9.579% 9.579% ## ( 1, 2 ] 119247 61.192% 70.771% ############ ( 2, 3 ] 34374 17.639% 88.410% #### ( 3, 4 ] 10129 5.198% 93.608% # ( 4, 6 ] 8030 4.121% 97.728% # ( 6, 10 ] 3281 1.684% 99.412% ( 10, 15 ] 494 0.253% 99.665% ( 15, 22 ] 81 0.042% 99.707% ( 22, 34 ] 20 0.010% 99.717% ( 34, 51 ] 3 0.002% 99.719% ( 51, 76 ] 5 0.003% 99.721% ( 76, 110 ] 84 0.043% 99.764% ( 110, 170 ] 263 0.135% 99.899% ( 170, 250 ] 96 0.049% 99.949% ( 250, 380 ] 59 0.030% 99.979% ( 380, 580 ] 51 0.026% 100.005% ( 580, 870 ] 40 0.021% 100.026% ( 870, 1300 ] 9 0.005% 100.030% ( 1300, 1900 ] 5 0.003% 100.033% ( 1900, 2900 ] 7 0.004% 100.036% ( 2900, 4400 ] 11 0.006% 100.042% ( 4400, 6600 ] 1 0.001% 100.043% ** Level 4 read latency histogram (micros): Count: 305 Average: 122.9049 StdDev: 605.46 Min: 0 Median: 1.7870 Max: 5116 Percentiles: P50: 1.79 P75: 5.39 P99: 4006.25 P99.9: 5116.00 P99.99: 5116.00 ------------------------------------------------------ [ 0, 1 ] 62 20.328% 20.328% #### ( 1, 2 ] 115 37.705% 58.033% ######## ( 2, 3 ] 24 7.869% 65.902% ## ( 3, 4 ] 18 5.902% 71.803% # ( 4, 6 ] 14 4.590% 76.393% # ( 6, 10 ] 36 11.803% 88.197% ## ( 10, 15 ] 8 2.623% 90.820% # ( 15, 22 ] 4 1.311% 92.131% ( 22, 34 ] 1 0.328% 92.459% ( 76, 110 ] 1 0.328% 92.787% ( 110, 170 ] 2 0.656% 93.443% ( 170, 250 ] 4 1.311% 94.754% ( 380, 580 ] 2 0.656% 95.410% ( 580, 870 ] 2 0.656% 96.066% ( 870, 1300 ] 4 1.311% 97.377% ( 1300, 1900 ] 1 0.328% 97.705% ( 1900, 2900 ] 1 0.328% 98.033% ( 2900, 4400 ] 4 1.311% 99.344% ( 4400, 6600 ] 2 0.656% 100.000% ** DB Stats ** Uptime(secs): 6.2 total, 3.0 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 318.01 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.825 H:M:S, 13.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 324.76 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.403 H:M:S, 13.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/07/21-12:45:01 ... thread 0: (1000000,3000000) ops and (361582.8,342834.2) ops/second in (2.765618,8.750585) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 14/13 2.21 GB 6.3 1.7 0.0 1.7 4.4 2.7 0.0 1.6 119.3 313.7 14.25 13.26 45 0.317 1727K 1867 0.0 0.0 L1 1/1 2.99 MB 0.0 0.3 0.3 0.0 0.3 0.3 0.2 1.0 245.6 245.2 1.28 1.25 1 1.283 319K 437 0.0 0.0 L2 1/0 96.99 MB 1.0 0.3 0.2 0.2 0.3 0.2 0.4 1.8 259.3 259.2 1.35 1.30 2 0.673 354K 177 0.0 0.0 L3 20/0 906.32 MB 0.9 1.1 0.2 0.9 1.1 0.2 0.2 4.7 241.2 240.8 4.64 4.28 2 2.321 1136K 1720 0.0 0.0 L4 173/0 9.64 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.3 1.0 127.8 127.8 1.32 0.89 1 1.317 170K 0 0.0 0.0 L5 1044/0 86.00 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1253/14 98.84 GB 0.0 3.6 0.9 2.7 6.3 3.6 1.3 2.3 159.9 281.1 22.84 20.97 51 0.448 3709K 4201 0.0 0.0 Int 0/0 0.00 KB 0.0 3.6 0.9 2.7 6.3 3.6 1.3 2.3 159.9 281.1 22.84 20.97 51 0.448 3709K 4201 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 3.6 0.9 2.7 3.6 0.9 0.0 0.0 242.8 242.5 15.05 14.02 12 1.254 3709K 4201 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 2.7 2.7 0.0 0.0 0.0 355.6 7.79 6.94 39 0.200 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 9.0 total, 8.8 interval Flush(GB): cumulative 2.707, interval 2.707 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 6.27 GB write, 716.97 MB/s write, 3.57 GB read, 407.91 MB/s read, 22.8 seconds Interval compaction: 6.27 GB write, 733.57 MB/s write, 3.57 GB read, 417.36 MB/s read, 22.8 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 10, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 10, interval: 10 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 637564 Average: 2.1557 StdDev: 12.41 Min: 0 Median: 1.4521 Max: 3902 Percentiles: P50: 1.45 P75: 1.84 P99: 5.52 P99.9: 10.03 P99.99: 31.89 ------------------------------------------------------ [ 0, 1 ] 135205 21.206% 21.206% #### ( 1, 2 ] 406024 63.684% 84.890% ############# ( 2, 3 ] 57964 9.091% 93.982% ## ( 3, 4 ] 22231 3.487% 97.468% # ( 4, 6 ] 12851 2.016% 99.484% ( 6, 10 ] 2648 0.415% 99.899% ( 10, 15 ] 515 0.081% 99.980% ( 15, 22 ] 54 0.008% 99.989% ( 22, 34 ] 10 0.002% 99.990% ( 34, 51 ] 6 0.001% 99.991% ( 51, 76 ] 11 0.002% 99.993% ( 76, 110 ] 36 0.006% 99.999% ( 110, 170 ] 26 0.004% 100.003% ( 170, 250 ] 22 0.003% 100.006% ( 250, 380 ] 17 0.003% 100.009% ( 380, 580 ] 8 0.001% 100.010% ( 580, 870 ] 21 0.003% 100.013% ( 870, 1300 ] 6 0.001% 100.014% ( 1300, 1900 ] 3 0.000% 100.015% ( 1900, 2900 ] 4 0.001% 100.015% ( 2900, 4400 ] 4 0.001% 100.016% ** Level 1 read latency histogram (micros): Count: 12380 Average: 3.5171 StdDev: 51.55 Min: 1 Median: 1.2001 Max: 3743 Percentiles: P50: 1.20 P75: 1.70 P99: 11.00 P99.9: 354.37 P99.99: 3471.50 ------------------------------------------------------ [ 0, 1 ] 4948 39.968% 39.968% ######## ( 1, 2 ] 6206 50.129% 90.097% ########## ( 2, 3 ] 756 6.107% 96.204% # ( 3, 4 ] 103 0.832% 97.036% ( 4, 6 ] 88 0.711% 97.746% ( 6, 10 ] 148 1.195% 98.942% ( 10, 15 ] 36 0.291% 99.233% ( 15, 22 ] 5 0.040% 99.273% ( 22, 34 ] 1 0.008% 99.281% ( 34, 51 ] 41 0.331% 99.612% ( 51, 76 ] 15 0.121% 99.733% ( 76, 110 ] 4 0.032% 99.766% ( 110, 170 ] 2 0.016% 99.782% ( 170, 250 ] 9 0.073% 99.855% ( 250, 380 ] 7 0.057% 99.911% ( 380, 580 ] 6 0.048% 99.960% ( 580, 870 ] 1 0.008% 99.968% ( 870, 1300 ] 1 0.008% 99.976% ( 1900, 2900 ] 1 0.008% 99.984% ( 2900, 4400 ] 2 0.016% 100.000% ** Level 2 read latency histogram (micros): Count: 88643 Average: 2.0498 StdDev: 5.06 Min: 0 Median: 1.4211 Max: 1046 Percentiles: P50: 1.42 P75: 1.82 P99: 5.49 P99.9: 9.87 P99.99: 132.71 ------------------------------------------------------ [ 0, 1 ] 21155 23.865% 23.865% ##### ( 1, 2 ] 55010 62.058% 85.923% ############ ( 2, 3 ] 7280 8.213% 94.136% ## ( 3, 4 ] 2961 3.340% 97.476% # ( 4, 6 ] 1809 2.041% 99.517% ( 6, 10 ] 351 0.396% 99.913% ( 10, 15 ] 56 0.063% 99.976% ( 15, 22 ] 7 0.008% 99.984% ( 22, 34 ] 2 0.002% 99.986% ( 34, 51 ] 1 0.001% 99.988% ( 51, 76 ] 1 0.001% 99.989% ( 110, 170 ] 3 0.003% 99.992% ( 170, 250 ] 2 0.002% 99.994% ( 250, 380 ] 2 0.002% 99.997% ( 380, 580 ] 1 0.001% 99.998% ( 580, 870 ] 1 0.001% 99.999% ( 870, 1300 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 266712 Average: 3.3696 StdDev: 33.22 Min: 1 Median: 1.6159 Max: 4882 Percentiles: P50: 1.62 P75: 2.05 P99: 8.92 P99.9: 186.05 P99.99: 533.91 ------------------------------------------------------ [ 0, 1 ] 29770 11.162% 11.162% ## ( 1, 2 ] 168181 63.057% 74.219% ############# ( 2, 3 ] 41089 15.406% 89.625% ### ( 3, 4 ] 12496 4.685% 94.310% # ( 4, 6 ] 9218 3.456% 97.766% # ( 6, 10 ] 4505 1.689% 99.455% ( 10, 15 ] 554 0.208% 99.663% ( 15, 22 ] 96 0.036% 99.699% ( 22, 34 ] 24 0.009% 99.708% ( 34, 51 ] 6 0.002% 99.710% ( 51, 76 ] 11 0.004% 99.714% ( 76, 110 ] 129 0.048% 99.763% ( 110, 170 ] 340 0.127% 99.890% ( 170, 250 ] 131 0.049% 99.939% ( 250, 380 ] 83 0.031% 99.970% ( 380, 580 ] 68 0.025% 99.996% ( 580, 870 ] 58 0.022% 100.018% ( 870, 1300 ] 11 0.004% 100.022% ( 1300, 1900 ] 6 0.002% 100.024% ( 1900, 2900 ] 7 0.003% 100.027% ( 2900, 4400 ] 11 0.004% 100.031% ( 4400, 6600 ] 1 0.000% 100.031% ** Level 4 read latency histogram (micros): Count: 305 Average: 122.9049 StdDev: 605.46 Min: 0 Median: 1.7870 Max: 5116 Percentiles: P50: 1.79 P75: 5.39 P99: 4006.25 P99.9: 5116.00 P99.99: 5116.00 ------------------------------------------------------ [ 0, 1 ] 62 20.328% 20.328% #### ( 1, 2 ] 115 37.705% 58.033% ######## ( 2, 3 ] 24 7.869% 65.902% ## ( 3, 4 ] 18 5.902% 71.803% # ( 4, 6 ] 14 4.590% 76.393% # ( 6, 10 ] 36 11.803% 88.197% ## ( 10, 15 ] 8 2.623% 90.820% # ( 15, 22 ] 4 1.311% 92.131% ( 22, 34 ] 1 0.328% 92.459% ( 76, 110 ] 1 0.328% 92.787% ( 110, 170 ] 2 0.656% 93.443% ( 170, 250 ] 4 1.311% 94.754% ( 380, 580 ] 2 0.656% 95.410% ( 580, 870 ] 2 0.656% 96.066% ( 870, 1300 ] 4 1.311% 97.377% ( 1300, 1900 ] 1 0.328% 97.705% ( 1900, 2900 ] 1 0.328% 98.033% ( 2900, 4400 ] 4 1.311% 99.344% ( 4400, 6600 ] 2 0.656% 100.000% ** Level 5 read latency histogram (micros): Count: 20 Average: 959.1000 StdDev: 1146.16 Min: 78 Median: 446.6667 Max: 4166 Percentiles: P50: 446.67 P75: 1300.00 P99: 4166.00 P99.9: 4166.00 P99.99: 4166.00 ------------------------------------------------------ ( 76, 110 ] 5 25.000% 25.000% ##### ( 170, 250 ] 2 10.000% 35.000% ## ( 250, 380 ] 2 10.000% 45.000% ## ( 380, 580 ] 3 15.000% 60.000% ### ( 580, 870 ] 1 5.000% 65.000% # ( 870, 1300 ] 2 10.000% 75.000% ## ( 1300, 1900 ] 1 5.000% 80.000% # ( 1900, 2900 ] 2 10.000% 90.000% ## ( 2900, 4400 ] 2 10.000% 100.000% ## ** DB Stats ** Uptime(secs): 9.0 total, 2.8 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 329.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:1.021 H:M:S, 11.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 355.86 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.196 H:M:S, 7.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/07/21-12:45:05 ... thread 0: (1000000,4000000) ops and (306017.2,332823.7) ops/second in (3.267790,12.018375) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 19/13 3.26 GB 113.3 2.5 0.0 2.5 6.3 3.7 0.0 1.7 125.3 311.5 20.62 19.23 62 0.333 2622K 2875 0.0 0.0 L1 1/1 2.99 MB 0.0 0.3 0.3 0.0 0.3 0.3 0.2 1.0 245.6 245.2 1.28 1.25 1 1.283 319K 437 0.0 0.0 L2 1/0 96.99 MB 1.0 0.3 0.2 0.2 0.3 0.2 0.4 1.8 259.3 259.2 1.35 1.30 2 0.673 354K 177 0.0 0.0 L3 20/0 906.32 MB 0.9 1.1 0.2 0.9 1.1 0.2 0.2 4.7 241.2 240.8 4.64 4.28 2 2.321 1136K 1720 0.0 0.0 L4 173/0 9.64 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.3 1.0 127.8 127.8 1.32 0.89 1 1.317 170K 0 0.0 0.0 L5 1044/0 86.00 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1258/14 99.88 GB 0.0 4.4 0.9 3.5 8.2 4.6 1.3 2.2 155.3 286.7 29.20 26.94 68 0.429 4604K 5209 0.0 0.0 Int 0/0 0.00 KB 0.0 4.4 0.9 3.5 8.2 4.6 1.3 2.2 155.3 286.7 29.20 26.94 68 0.429 4604K 5209 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.4 0.9 3.5 4.4 0.9 0.0 0.0 247.2 247.0 18.34 17.25 15 1.223 4604K 5209 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 3.8 3.8 0.0 0.0 0.0 353.7 10.86 9.69 53 0.205 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 12.2 total, 12.0 interval Flush(GB): cumulative 3.753, interval 3.753 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 8.18 GB write, 684.97 MB/s write, 4.43 GB read, 371.01 MB/s read, 29.2 seconds Interval compaction: 8.18 GB write, 696.52 MB/s write, 4.43 GB read, 377.27 MB/s read, 29.2 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 1, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 1, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 14, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 1, total-stops: 14, interval: 15 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1088338 Average: 2.1902 StdDev: 10.98 Min: 0 Median: 1.4810 Max: 3902 Percentiles: P50: 1.48 P75: 1.86 P99: 5.55 P99.9: 9.90 P99.99: 18.26 ------------------------------------------------------ [ 0, 1 ] 201585 18.522% 18.522% #### ( 1, 2 ] 712287 65.447% 83.970% ############# ( 2, 3 ] 108408 9.961% 93.930% ## ( 3, 4 ] 38438 3.532% 97.462% # ( 4, 6 ] 21565 1.981% 99.444% ( 6, 10 ] 5089 0.468% 99.911% ( 10, 15 ] 813 0.075% 99.986% ( 15, 22 ] 97 0.009% 99.995% ( 22, 34 ] 14 0.001% 99.996% ( 34, 51 ] 7 0.001% 99.997% ( 51, 76 ] 12 0.001% 99.998% ( 76, 110 ] 106 0.010% 100.008% ( 110, 170 ] 62 0.006% 100.013% ( 170, 250 ] 34 0.003% 100.016% ( 250, 380 ] 32 0.003% 100.019% ( 380, 580 ] 25 0.002% 100.022% ( 580, 870 ] 27 0.002% 100.024% ( 870, 1300 ] 12 0.001% 100.025% ( 1300, 1900 ] 7 0.001% 100.026% ( 1900, 2900 ] 5 0.000% 100.026% ( 2900, 4400 ] 4 0.000% 100.027% ** Level 1 read latency histogram (micros): Count: 12380 Average: 3.5171 StdDev: 51.55 Min: 1 Median: 1.2001 Max: 3743 Percentiles: P50: 1.20 P75: 1.70 P99: 11.00 P99.9: 354.37 P99.99: 3471.50 ------------------------------------------------------ [ 0, 1 ] 4948 39.968% 39.968% ######## ( 1, 2 ] 6206 50.129% 90.097% ########## ( 2, 3 ] 756 6.107% 96.204% # ( 3, 4 ] 103 0.832% 97.036% ( 4, 6 ] 88 0.711% 97.746% ( 6, 10 ] 148 1.195% 98.942% ( 10, 15 ] 36 0.291% 99.233% ( 15, 22 ] 5 0.040% 99.273% ( 22, 34 ] 1 0.008% 99.281% ( 34, 51 ] 41 0.331% 99.612% ( 51, 76 ] 15 0.121% 99.733% ( 76, 110 ] 4 0.032% 99.766% ( 110, 170 ] 2 0.016% 99.782% ( 170, 250 ] 9 0.073% 99.855% ( 250, 380 ] 7 0.057% 99.911% ( 380, 580 ] 6 0.048% 99.960% ( 580, 870 ] 1 0.008% 99.968% ( 870, 1300 ] 1 0.008% 99.976% ( 1900, 2900 ] 1 0.008% 99.984% ( 2900, 4400 ] 2 0.016% 100.000% ** Level 2 read latency histogram (micros): Count: 88643 Average: 2.0498 StdDev: 5.06 Min: 0 Median: 1.4211 Max: 1046 Percentiles: P50: 1.42 P75: 1.82 P99: 5.49 P99.9: 9.87 P99.99: 132.71 ------------------------------------------------------ [ 0, 1 ] 21155 23.865% 23.865% ##### ( 1, 2 ] 55010 62.058% 85.923% ############ ( 2, 3 ] 7280 8.213% 94.136% ## ( 3, 4 ] 2961 3.340% 97.476% # ( 4, 6 ] 1809 2.041% 99.517% ( 6, 10 ] 351 0.396% 99.913% ( 10, 15 ] 56 0.063% 99.976% ( 15, 22 ] 7 0.008% 99.984% ( 22, 34 ] 2 0.002% 99.986% ( 34, 51 ] 1 0.001% 99.988% ( 51, 76 ] 1 0.001% 99.989% ( 110, 170 ] 3 0.003% 99.992% ( 170, 250 ] 2 0.002% 99.994% ( 250, 380 ] 2 0.002% 99.997% ( 380, 580 ] 1 0.001% 99.998% ( 580, 870 ] 1 0.001% 99.999% ( 870, 1300 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 266712 Average: 3.3696 StdDev: 33.22 Min: 1 Median: 1.6159 Max: 4882 Percentiles: P50: 1.62 P75: 2.05 P99: 8.92 P99.9: 186.05 P99.99: 533.91 ------------------------------------------------------ [ 0, 1 ] 29770 11.162% 11.162% ## ( 1, 2 ] 168181 63.057% 74.219% ############# ( 2, 3 ] 41089 15.406% 89.625% ### ( 3, 4 ] 12496 4.685% 94.310% # ( 4, 6 ] 9218 3.456% 97.766% # ( 6, 10 ] 4505 1.689% 99.455% ( 10, 15 ] 554 0.208% 99.663% ( 15, 22 ] 96 0.036% 99.699% ( 22, 34 ] 24 0.009% 99.708% ( 34, 51 ] 6 0.002% 99.710% ( 51, 76 ] 11 0.004% 99.714% ( 76, 110 ] 129 0.048% 99.763% ( 110, 170 ] 340 0.127% 99.890% ( 170, 250 ] 131 0.049% 99.939% ( 250, 380 ] 83 0.031% 99.970% ( 380, 580 ] 68 0.025% 99.996% ( 580, 870 ] 58 0.022% 100.018% ( 870, 1300 ] 11 0.004% 100.022% ( 1300, 1900 ] 6 0.002% 100.024% ( 1900, 2900 ] 7 0.003% 100.027% ( 2900, 4400 ] 11 0.004% 100.031% ( 4400, 6600 ] 1 0.000% 100.031% ** Level 4 read latency histogram (micros): Count: 305 Average: 122.9049 StdDev: 605.46 Min: 0 Median: 1.7870 Max: 5116 Percentiles: P50: 1.79 P75: 5.39 P99: 4006.25 P99.9: 5116.00 P99.99: 5116.00 ------------------------------------------------------ [ 0, 1 ] 62 20.328% 20.328% #### ( 1, 2 ] 115 37.705% 58.033% ######## ( 2, 3 ] 24 7.869% 65.902% ## ( 3, 4 ] 18 5.902% 71.803% # ( 4, 6 ] 14 4.590% 76.393% # ( 6, 10 ] 36 11.803% 88.197% ## ( 10, 15 ] 8 2.623% 90.820% # ( 15, 22 ] 4 1.311% 92.131% ( 22, 34 ] 1 0.328% 92.459% ( 76, 110 ] 1 0.328% 92.787% ( 110, 170 ] 2 0.656% 93.443% ( 170, 250 ] 4 1.311% 94.754% ( 380, 580 ] 2 0.656% 95.410% ( 580, 870 ] 2 0.656% 96.066% ( 870, 1300 ] 4 1.311% 97.377% ( 1300, 1900 ] 1 0.328% 97.705% ( 1900, 2900 ] 1 0.328% 98.033% ( 2900, 4400 ] 4 1.311% 99.344% ( 4400, 6600 ] 2 0.656% 100.000% ** Level 5 read latency histogram (micros): Count: 20 Average: 959.1000 StdDev: 1146.16 Min: 78 Median: 446.6667 Max: 4166 Percentiles: P50: 446.67 P75: 1300.00 P99: 4166.00 P99.9: 4166.00 P99.99: 4166.00 ------------------------------------------------------ ( 76, 110 ] 5 25.000% 25.000% ##### ( 170, 250 ] 2 10.000% 35.000% ## ( 250, 380 ] 2 10.000% 45.000% ## ( 380, 580 ] 3 15.000% 60.000% ### ( 580, 870 ] 1 5.000% 65.000% # ( 870, 1300 ] 2 10.000% 75.000% ## ( 1300, 1900 ] 1 5.000% 80.000% # ( 1900, 2900 ] 2 10.000% 90.000% ## ( 2900, 4400 ] 2 10.000% 100.000% ## ** DB Stats ** Uptime(secs): 12.2 total, 3.3 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 322.08 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:1.673 H:M:S, 13.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 301.18 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.652 H:M:S, 20.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/07/21-12:45:09 ... thread 0: (1000000,5000000) ops and (204274.1,295617.3) ops/second in (4.895383,16.913758) 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/9 2.27 GB 18.9 3.6 0.0 3.6 8.2 4.7 0.0 1.8 134.4 310.3 27.19 25.46 80 0.340 3709K 4032 0.0 0.0 L1 12/12 1.39 GB 0.0 2.2 2.2 0.0 2.2 2.2 0.2 1.0 238.0 236.2 9.53 9.24 2 4.766 2303K 17K 0.0 0.0 L2 4/4 515.11 MB 0.0 0.3 0.2 0.2 0.3 0.2 0.9 1.8 259.3 259.2 1.35 1.30 2 0.673 354K 177 0.0 0.0 L3 21/1 1003.24 MB 0.9 1.2 0.3 0.9 1.2 0.3 0.2 3.7 229.3 229.0 5.39 4.84 3 1.795 1254K 1786 0.0 0.0 L4 173/0 9.64 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.3 1.0 127.8 127.8 1.32 0.89 1 1.317 170K 0 0.0 0.0 L5 1044/0 86.00 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1266/26 100.79 GB 0.0 7.5 2.9 4.6 12.1 7.5 1.8 2.6 171.4 277.8 44.78 41.73 88 0.509 7793K 23K 0.0 0.0 Int 0/0 0.00 KB 0.0 7.5 2.9 4.6 12.1 7.5 1.8 2.6 171.4 277.8 44.78 41.73 88 0.509 7793K 23K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 7.5 2.9 4.6 7.5 2.9 0.0 0.0 245.6 244.9 31.25 29.65 21 1.488 7793K 23K 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 353.9 13.53 12.08 67 0.202 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): 17.1 total, 16.9 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: 12.15 GB write, 726.67 MB/s write, 7.50 GB read, 448.38 MB/s read, 44.8 seconds Interval compaction: 12.15 GB write, 735.38 MB/s write, 7.50 GB read, 453.75 MB/s read, 44.8 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: 14, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 8, total-stops: 14, interval: 22 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1590911 Average: 2.2013 StdDev: 10.81 Min: 0 Median: 1.4703 Max: 3902 Percentiles: P50: 1.47 P75: 1.85 P99: 5.64 P99.9: 10.50 P99.99: 105.45 ------------------------------------------------------ [ 0, 1 ] 301760 18.968% 18.968% #### ( 1, 2 ] 1049639 65.977% 84.945% ############# ( 2, 3 ] 147774 9.289% 94.234% ## ( 3, 4 ] 52980 3.330% 97.564% # ( 4, 6 ] 27909 1.754% 99.318% ( 6, 10 ] 9136 0.574% 99.892% ( 10, 15 ] 1209 0.076% 99.968% ( 15, 22 ] 148 0.009% 99.978% ( 22, 34 ] 18 0.001% 99.979% ( 34, 51 ] 11 0.001% 99.979% ( 51, 76 ] 12 0.001% 99.980% ( 76, 110 ] 180 0.011% 99.992% ( 110, 170 ] 207 0.013% 100.005% ( 170, 250 ] 80 0.005% 100.010% ( 250, 380 ] 68 0.004% 100.014% ( 380, 580 ] 50 0.003% 100.017% ( 580, 870 ] 58 0.004% 100.021% ( 870, 1300 ] 22 0.001% 100.022% ( 1300, 1900 ] 7 0.000% 100.022% ( 1900, 2900 ] 6 0.000% 100.023% ( 2900, 4400 ] 5 0.000% 100.023% ** Level 1 read latency histogram (micros): Count: 81581 Average: 3.7842 StdDev: 32.76 Min: 0 Median: 1.5914 Max: 3743 Percentiles: P50: 1.59 P75: 1.99 P99: 9.51 P99.9: 331.97 P99.99: 698.92 ------------------------------------------------------ [ 0, 1 ] 10388 12.733% 12.733% ### ( 1, 2 ] 51409 63.016% 75.749% ############# ( 2, 3 ] 11832 14.503% 90.253% ### ( 3, 4 ] 3778 4.631% 94.884% # ( 4, 6 ] 2372 2.908% 97.791% # ( 6, 10 ] 1125 1.379% 99.170% ( 10, 15 ] 216 0.265% 99.435% ( 15, 22 ] 34 0.042% 99.477% ( 22, 34 ] 2 0.002% 99.479% ( 34, 51 ] 41 0.050% 99.529% ( 51, 76 ] 15 0.018% 99.548% ( 76, 110 ] 69 0.085% 99.632% ( 110, 170 ] 138 0.169% 99.801% ( 170, 250 ] 47 0.058% 99.859% ( 250, 380 ] 53 0.065% 99.924% ( 380, 580 ] 44 0.054% 99.978% ( 580, 870 ] 24 0.029% 100.007% ( 870, 1300 ] 12 0.015% 100.022% ( 1300, 1900 ] 2 0.002% 100.025% ( 1900, 2900 ] 1 0.001% 100.026% ( 2900, 4400 ] 3 0.004% 100.029% ** Level 2 read latency histogram (micros): Count: 88643 Average: 2.0498 StdDev: 5.06 Min: 0 Median: 1.4211 Max: 1046 Percentiles: P50: 1.42 P75: 1.82 P99: 5.49 P99.9: 9.87 P99.99: 132.71 ------------------------------------------------------ [ 0, 1 ] 21155 23.865% 23.865% ##### ( 1, 2 ] 55010 62.058% 85.923% ############ ( 2, 3 ] 7280 8.213% 94.136% ## ( 3, 4 ] 2961 3.340% 97.476% # ( 4, 6 ] 1809 2.041% 99.517% ( 6, 10 ] 351 0.396% 99.913% ( 10, 15 ] 56 0.063% 99.976% ( 15, 22 ] 7 0.008% 99.984% ( 22, 34 ] 2 0.002% 99.986% ( 34, 51 ] 1 0.001% 99.988% ( 51, 76 ] 1 0.001% 99.989% ( 110, 170 ] 3 0.003% 99.992% ( 170, 250 ] 2 0.002% 99.994% ( 250, 380 ] 2 0.002% 99.997% ( 380, 580 ] 1 0.001% 99.998% ( 580, 870 ] 1 0.001% 99.999% ( 870, 1300 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 271519 Average: 3.7467 StdDev: 35.10 Min: 1 Median: 1.6206 Max: 4882 Percentiles: P50: 1.62 P75: 2.08 P99: 9.32 P99.9: 273.58 P99.99: 619.82 ------------------------------------------------------ [ 0, 1 ] 30016 11.055% 11.055% ## ( 1, 2 ] 170384 62.752% 73.807% ############# ( 2, 3 ] 42348 15.597% 89.404% ### ( 3, 4 ] 12836 4.727% 94.131% # ( 4, 6 ] 9407 3.465% 97.596% # ( 6, 10 ] 4593 1.692% 99.287% ( 10, 15 ] 574 0.211% 99.499% ( 15, 22 ] 105 0.039% 99.537% ( 22, 34 ] 26 0.010% 99.547% ( 34, 51 ] 6 0.002% 99.549% ( 51, 76 ] 11 0.004% 99.553% ( 76, 110 ] 208 0.077% 99.630% ( 110, 170 ] 514 0.189% 99.819% ( 170, 250 ] 193 0.071% 99.890% ( 250, 380 ] 146 0.054% 99.944% ( 380, 580 ] 114 0.042% 99.986% ( 580, 870 ] 79 0.029% 100.015% ( 870, 1300 ] 16 0.006% 100.021% ( 1300, 1900 ] 7 0.003% 100.024% ( 1900, 2900 ] 7 0.003% 100.026% ( 2900, 4400 ] 11 0.004% 100.030% ( 4400, 6600 ] 1 0.000% 100.031% ** Level 4 read latency histogram (micros): Count: 305 Average: 122.9049 StdDev: 605.46 Min: 0 Median: 1.7870 Max: 5116 Percentiles: P50: 1.79 P75: 5.39 P99: 4006.25 P99.9: 5116.00 P99.99: 5116.00 ------------------------------------------------------ [ 0, 1 ] 62 20.328% 20.328% #### ( 1, 2 ] 115 37.705% 58.033% ######## ( 2, 3 ] 24 7.869% 65.902% ## ( 3, 4 ] 18 5.902% 71.803% # ( 4, 6 ] 14 4.590% 76.393% # ( 6, 10 ] 36 11.803% 88.197% ## ( 10, 15 ] 8 2.623% 90.820% # ( 15, 22 ] 4 1.311% 92.131% ( 22, 34 ] 1 0.328% 92.459% ( 76, 110 ] 1 0.328% 92.787% ( 110, 170 ] 2 0.656% 93.443% ( 170, 250 ] 4 1.311% 94.754% ( 380, 580 ] 2 0.656% 95.410% ( 580, 870 ] 2 0.656% 96.066% ( 870, 1300 ] 4 1.311% 97.377% ( 1300, 1900 ] 1 0.328% 97.705% ( 1900, 2900 ] 1 0.328% 98.033% ( 2900, 4400 ] 4 1.311% 99.344% ( 4400, 6600 ] 2 0.656% 100.000% ** Level 5 read latency histogram (micros): Count: 20 Average: 959.1000 StdDev: 1146.16 Min: 78 Median: 446.6667 Max: 4166 Percentiles: P50: 446.67 P75: 1300.00 P99: 4166.00 P99.9: 4166.00 P99.99: 4166.00 ------------------------------------------------------ ( 76, 110 ] 5 25.000% 25.000% ##### ( 170, 250 ] 2 10.000% 35.000% ## ( 250, 380 ] 2 10.000% 45.000% ## ( 380, 580 ] 3 15.000% 60.000% ### ( 580, 870 ] 1 5.000% 65.000% # ( 870, 1300 ] 2 10.000% 75.000% ## ( 1300, 1900 ] 1 5.000% 80.000% # ( 1900, 2900 ] 2 10.000% 90.000% ## ( 2900, 4400 ] 2 10.000% 100.000% ## ** DB Stats ** Uptime(secs): 17.1 total, 4.9 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 287.47 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:3.898 H:M:S, 22.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 201.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:2.225 H:M:S, 45.4 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/07/21-12:45:12 ... thread 0: (1000000,6000000) ops and (334701.9,301484.9) ops/second in (2.987733,19.901491) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 19/17 3.20 GB 56.6 4.1 0.0 4.1 9.7 5.6 0.0 1.7 131.8 310.8 32.01 29.94 95 0.337 4285K 4645 0.0 0.0 L1 12/12 1.39 GB 0.0 2.2 2.2 0.0 2.2 2.2 0.2 1.0 238.0 236.2 9.53 9.24 2 4.766 2303K 17K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.3 0.2 0.2 0.3 0.2 0.9 1.8 259.3 259.2 1.35 1.30 2 0.673 354K 177 0.0 0.0 L3 19/0 843.72 MB 0.8 1.8 0.8 1.0 1.8 0.8 0.2 2.2 229.5 229.1 8.19 7.48 4 2.046 1908K 3439 0.0 0.0 L4 176/0 9.62 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.9 1.0 127.8 127.8 1.32 0.89 1 1.317 170K 0 0.0 0.0 L5 1052/0 86.68 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1278/29 101.71 GB 0.0 8.7 3.4 5.3 14.3 9.0 3.1 2.5 169.6 278.5 52.39 48.85 104 0.504 9023K 25K 0.0 0.0 Int 0/0 0.00 KB 0.0 8.7 3.4 5.3 14.3 9.0 3.1 2.5 169.6 278.5 52.39 48.85 104 0.504 9023K 25K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 8.7 3.4 5.3 8.7 3.4 0.0 0.0 245.5 244.8 36.20 34.41 24 1.508 9023K 25K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 5.6 5.6 0.0 0.0 0.0 353.9 16.20 14.44 80 0.202 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): 20.1 total, 19.9 interval Flush(GB): cumulative 5.598, interval 5.598 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 14.25 GB write, 725.79 MB/s write, 8.68 GB read, 441.97 MB/s read, 52.4 seconds Interval compaction: 14.25 GB write, 733.18 MB/s write, 8.68 GB read, 446.47 MB/s read, 52.4 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: 17, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 8, total-stops: 17, interval: 25 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1945238 Average: 2.2354 StdDev: 10.75 Min: 0 Median: 1.4902 Max: 4008 Percentiles: P50: 1.49 P75: 1.87 P99: 5.71 P99.9: 10.90 P99.99: 98.80 ------------------------------------------------------ [ 0, 1 ] 340352 17.497% 17.497% ### ( 1, 2 ] 1289913 66.311% 83.808% ############# ( 2, 3 ] 193199 9.932% 93.740% ## ( 3, 4 ] 70608 3.630% 97.370% # ( 4, 6 ] 37132 1.909% 99.279% ( 6, 10 ] 11788 0.606% 99.885% ( 10, 15 ] 1683 0.087% 99.971% ( 15, 22 ] 190 0.010% 99.981% ( 22, 34 ] 23 0.001% 99.982% ( 34, 51 ] 12 0.001% 99.983% ( 51, 76 ] 13 0.001% 99.983% ( 76, 110 ] 199 0.010% 99.994% ( 110, 170 ] 242 0.012% 100.006% ( 170, 250 ] 111 0.006% 100.012% ( 250, 380 ] 87 0.004% 100.016% ( 380, 580 ] 67 0.003% 100.020% ( 580, 870 ] 68 0.003% 100.023% ( 870, 1300 ] 26 0.001% 100.024% ( 1300, 1900 ] 9 0.000% 100.025% ( 1900, 2900 ] 6 0.000% 100.025% ( 2900, 4400 ] 6 0.000% 100.025% ** Level 1 read latency histogram (micros): Count: 232720 Average: 3.0530 StdDev: 21.03 Min: 0 Median: 1.6039 Max: 3743 Percentiles: P50: 1.60 P75: 1.98 P99: 8.68 P99.9: 185.88 P99.99: 575.69 ------------------------------------------------------ [ 0, 1 ] 21833 9.382% 9.382% ## ( 1, 2 ] 156527 67.260% 76.641% ############# ( 2, 3 ] 31688 13.616% 90.258% ### ( 3, 4 ] 11369 4.885% 95.143% # ( 4, 6 ] 6429 2.763% 97.906% # ( 6, 10 ] 3796 1.631% 99.537% ( 10, 15 ] 404 0.174% 99.710% ( 15, 22 ] 49 0.021% 99.731% ( 22, 34 ] 3 0.001% 99.733% ( 34, 51 ] 41 0.018% 99.750% ( 51, 76 ] 15 0.006% 99.757% ( 76, 110 ] 137 0.059% 99.816% ( 110, 170 ] 180 0.077% 99.893% ( 170, 250 ] 82 0.035% 99.928% ( 250, 380 ] 86 0.037% 99.965% ( 380, 580 ] 59 0.025% 99.991% ( 580, 870 ] 32 0.014% 100.004% ( 870, 1300 ] 14 0.006% 100.010% ( 1300, 1900 ] 2 0.001% 100.011% ( 1900, 2900 ] 1 0.000% 100.012% ( 2900, 4400 ] 3 0.001% 100.013% ** Level 2 read latency histogram (micros): Count: 88643 Average: 2.0498 StdDev: 5.06 Min: 0 Median: 1.4211 Max: 1046 Percentiles: P50: 1.42 P75: 1.82 P99: 5.49 P99.9: 9.87 P99.99: 132.71 ------------------------------------------------------ [ 0, 1 ] 21155 23.865% 23.865% ##### ( 1, 2 ] 55010 62.058% 85.923% ############ ( 2, 3 ] 7280 8.213% 94.136% ## ( 3, 4 ] 2961 3.340% 97.476% # ( 4, 6 ] 1809 2.041% 99.517% ( 6, 10 ] 351 0.396% 99.913% ( 10, 15 ] 56 0.063% 99.976% ( 15, 22 ] 7 0.008% 99.984% ( 22, 34 ] 2 0.002% 99.986% ( 34, 51 ] 1 0.001% 99.988% ( 51, 76 ] 1 0.001% 99.989% ( 110, 170 ] 3 0.003% 99.992% ( 170, 250 ] 2 0.002% 99.994% ( 250, 380 ] 2 0.002% 99.997% ( 380, 580 ] 1 0.001% 99.998% ( 580, 870 ] 1 0.001% 99.999% ( 870, 1300 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 271569 Average: 3.7688 StdDev: 35.24 Min: 1 Median: 1.6206 Max: 4882 Percentiles: P50: 1.62 P75: 2.08 P99: 9.34 P99.9: 280.04 P99.99: 626.56 ------------------------------------------------------ [ 0, 1 ] 30027 11.057% 11.057% ## ( 1, 2 ] 170401 62.747% 73.804% ############# ( 2, 3 ] 42349 15.594% 89.398% ### ( 3, 4 ] 12836 4.727% 94.125% # ( 4, 6 ] 9407 3.464% 97.588% # ( 6, 10 ] 4595 1.692% 99.280% ( 10, 15 ] 574 0.211% 99.492% ( 15, 22 ] 105 0.039% 99.531% ( 22, 34 ] 26 0.010% 99.540% ( 34, 51 ] 6 0.002% 99.542% ( 51, 76 ] 12 0.004% 99.547% ( 76, 110 ] 208 0.077% 99.623% ( 110, 170 ] 515 0.190% 99.813% ( 170, 250 ] 202 0.074% 99.887% ( 250, 380 ] 149 0.055% 99.942% ( 380, 580 ] 117 0.043% 99.985% ( 580, 870 ] 80 0.029% 100.015% ( 870, 1300 ] 17 0.006% 100.021% ( 1300, 1900 ] 7 0.003% 100.024% ( 1900, 2900 ] 7 0.003% 100.026% ( 2900, 4400 ] 11 0.004% 100.030% ( 4400, 6600 ] 1 0.000% 100.031% ** Level 4 read latency histogram (micros): Count: 305 Average: 122.9049 StdDev: 605.46 Min: 0 Median: 1.7870 Max: 5116 Percentiles: P50: 1.79 P75: 5.39 P99: 4006.25 P99.9: 5116.00 P99.99: 5116.00 ------------------------------------------------------ [ 0, 1 ] 62 20.328% 20.328% #### ( 1, 2 ] 115 37.705% 58.033% ######## ( 2, 3 ] 24 7.869% 65.902% ## ( 3, 4 ] 18 5.902% 71.803% # ( 4, 6 ] 14 4.590% 76.393% # ( 6, 10 ] 36 11.803% 88.197% ## ( 10, 15 ] 8 2.623% 90.820% # ( 15, 22 ] 4 1.311% 92.131% ( 22, 34 ] 1 0.328% 92.459% ( 76, 110 ] 1 0.328% 92.787% ( 110, 170 ] 2 0.656% 93.443% ( 170, 250 ] 4 1.311% 94.754% ( 380, 580 ] 2 0.656% 95.410% ( 580, 870 ] 2 0.656% 96.066% ( 870, 1300 ] 4 1.311% 97.377% ( 1300, 1900 ] 1 0.328% 97.705% ( 1900, 2900 ] 1 0.328% 98.033% ( 2900, 4400 ] 4 1.311% 99.344% ( 4400, 6600 ] 2 0.656% 100.000% ** Level 5 read latency histogram (micros): Count: 60 Average: 866.9833 StdDev: 1168.57 Min: 78 Median: 315.0000 Max: 5730 Percentiles: P50: 315.00 P75: 1156.67 P99: 5280.00 P99.9: 5730.00 P99.99: 5730.00 ------------------------------------------------------ ( 76, 110 ] 12 20.000% 20.000% #### ( 110, 170 ] 9 15.000% 35.000% ### ( 170, 250 ] 7 11.667% 46.667% ## ( 250, 380 ] 4 6.667% 53.333% # ( 380, 580 ] 7 11.667% 65.000% ## ( 580, 870 ] 4 6.667% 71.667% # ( 870, 1300 ] 3 5.000% 76.667% # ( 1300, 1900 ] 4 6.667% 83.333% # ( 1900, 2900 ] 6 10.000% 93.333% ## ( 2900, 4400 ] 3 5.000% 98.333% # ( 4400, 6600 ] 1 1.667% 100.000% ** DB Stats ** Uptime(secs): 20.1 total, 3.0 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 293.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:4.282 H:M:S, 21.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 329.41 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.385 H:M:S, 12.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/07/21-12:45:18 ... thread 0: (1000000,7000000) ops and (193800.6,279313.6) ops/second in (5.159944,25.061435) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 19/15 4.24 GB 94.4 5.5 0.0 5.5 12.1 6.6 0.0 1.8 139.6 308.8 40.16 37.68 115 0.349 5692K 6053 0.0 0.0 L1 12/12 1.39 GB 0.0 2.2 2.2 0.0 2.2 2.2 0.2 1.0 238.0 236.2 9.53 9.24 2 4.766 2303K 17K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.3 0.2 0.2 0.3 0.2 0.9 1.8 259.3 259.2 1.35 1.30 2 0.673 354K 177 0.0 0.0 L3 19/0 843.72 MB 0.8 1.8 0.8 1.0 1.8 0.8 0.2 2.2 229.5 229.1 8.19 7.48 4 2.046 1908K 3439 0.0 0.0 L4 176/0 9.62 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.9 1.0 127.8 127.8 1.32 0.89 1 1.317 170K 0 0.0 0.0 L5 1052/0 86.68 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1278/27 102.75 GB 0.0 10.0 3.4 6.6 16.6 10.0 3.1 2.5 169.7 281.6 60.54 56.58 124 0.488 10M 27K 0.0 0.0 Int 0/0 0.00 KB 0.0 10.0 3.4 6.6 16.6 10.0 3.1 2.5 169.7 281.6 60.54 56.58 124 0.488 10M 27K 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 10.0 3.4 6.6 10.0 3.4 0.0 0.0 248.4 247.7 41.35 39.46 29 1.426 10M 27K 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 354.5 19.19 17.12 95 0.202 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 25.3 total, 25.1 interval Flush(GB): cumulative 6.644, interval 6.644 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 16.65 GB write, 674.75 MB/s write, 10.03 GB read, 406.57 MB/s read, 60.5 seconds Interval compaction: 16.65 GB write, 680.21 MB/s write, 10.03 GB read, 409.85 MB/s read, 60.5 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 16, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 16, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 20, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 16, total-stops: 20, interval: 36 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2401382 Average: 2.2477 StdDev: 11.12 Min: 0 Median: 1.4873 Max: 4008 Percentiles: P50: 1.49 P75: 1.86 P99: 5.72 P99.9: 11.50 P99.99: 130.28 ------------------------------------------------------ [ 0, 1 ] 422903 17.611% 17.611% #### ( 1, 2 ] 1596117 66.467% 84.077% ############# ( 2, 3 ] 235865 9.822% 93.899% ## ( 3, 4 ] 84644 3.525% 97.424% # ( 4, 6 ] 43915 1.829% 99.253% ( 6, 10 ] 14913 0.621% 99.874% ( 10, 15 ] 2077 0.086% 99.961% ( 15, 22 ] 226 0.009% 99.970% ( 22, 34 ] 25 0.001% 99.971% ( 34, 51 ] 13 0.001% 99.972% ( 51, 76 ] 15 0.001% 99.972% ( 76, 110 ] 295 0.012% 99.984% ( 110, 170 ] 396 0.016% 100.001% ( 170, 250 ] 170 0.007% 100.008% ( 250, 380 ] 133 0.006% 100.014% ( 380, 580 ] 101 0.004% 100.018% ( 580, 870 ] 87 0.004% 100.021% ( 870, 1300 ] 31 0.001% 100.023% ( 1300, 1900 ] 11 0.000% 100.023% ( 1900, 2900 ] 7 0.000% 100.023% ( 2900, 4400 ] 9 0.000% 100.024% ** Level 1 read latency histogram (micros): Count: 373036 Average: 2.8688 StdDev: 18.00 Min: 0 Median: 1.5625 Max: 3743 Percentiles: P50: 1.56 P75: 1.94 P99: 8.57 P99.9: 164.19 P99.99: 574.09 ------------------------------------------------------ [ 0, 1 ] 46082 12.353% 12.353% ## ( 1, 2 ] 249648 66.923% 79.277% ############# ( 2, 3 ] 45525 12.204% 91.480% ## ( 3, 4 ] 15398 4.128% 95.608% # ( 4, 6 ] 8778 2.353% 97.961% ( 6, 10 ] 6030 1.616% 99.578% ( 10, 15 ] 559 0.150% 99.728% ( 15, 22 ] 69 0.018% 99.746% ( 22, 34 ] 5 0.001% 99.747% ( 34, 51 ] 42 0.011% 99.759% ( 51, 76 ] 16 0.004% 99.763% ( 76, 110 ] 241 0.065% 99.828% ( 110, 170 ] 300 0.080% 99.908% ( 170, 250 ] 120 0.032% 99.940% ( 250, 380 ] 111 0.030% 99.970% ( 380, 580 ] 78 0.021% 99.991% ( 580, 870 ] 44 0.012% 100.003% ( 870, 1300 ] 15 0.004% 100.007% ( 1300, 1900 ] 2 0.001% 100.007% ( 1900, 2900 ] 1 0.000% 100.008% ( 2900, 4400 ] 3 0.001% 100.008% ** Level 2 read latency histogram (micros): Count: 88643 Average: 2.0498 StdDev: 5.06 Min: 0 Median: 1.4211 Max: 1046 Percentiles: P50: 1.42 P75: 1.82 P99: 5.49 P99.9: 9.87 P99.99: 132.71 ------------------------------------------------------ [ 0, 1 ] 21155 23.865% 23.865% ##### ( 1, 2 ] 55010 62.058% 85.923% ############ ( 2, 3 ] 7280 8.213% 94.136% ## ( 3, 4 ] 2961 3.340% 97.476% # ( 4, 6 ] 1809 2.041% 99.517% ( 6, 10 ] 351 0.396% 99.913% ( 10, 15 ] 56 0.063% 99.976% ( 15, 22 ] 7 0.008% 99.984% ( 22, 34 ] 2 0.002% 99.986% ( 34, 51 ] 1 0.001% 99.988% ( 51, 76 ] 1 0.001% 99.989% ( 110, 170 ] 3 0.003% 99.992% ( 170, 250 ] 2 0.002% 99.994% ( 250, 380 ] 2 0.002% 99.997% ( 380, 580 ] 1 0.001% 99.998% ( 580, 870 ] 1 0.001% 99.999% ( 870, 1300 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 271569 Average: 3.7688 StdDev: 35.24 Min: 1 Median: 1.6206 Max: 4882 Percentiles: P50: 1.62 P75: 2.08 P99: 9.34 P99.9: 280.04 P99.99: 626.56 ------------------------------------------------------ [ 0, 1 ] 30027 11.057% 11.057% ## ( 1, 2 ] 170401 62.747% 73.804% ############# ( 2, 3 ] 42349 15.594% 89.398% ### ( 3, 4 ] 12836 4.727% 94.125% # ( 4, 6 ] 9407 3.464% 97.588% # ( 6, 10 ] 4595 1.692% 99.280% ( 10, 15 ] 574 0.211% 99.492% ( 15, 22 ] 105 0.039% 99.531% ( 22, 34 ] 26 0.010% 99.540% ( 34, 51 ] 6 0.002% 99.542% ( 51, 76 ] 12 0.004% 99.547% ( 76, 110 ] 208 0.077% 99.623% ( 110, 170 ] 515 0.190% 99.813% ( 170, 250 ] 202 0.074% 99.887% ( 250, 380 ] 149 0.055% 99.942% ( 380, 580 ] 117 0.043% 99.985% ( 580, 870 ] 80 0.029% 100.015% ( 870, 1300 ] 17 0.006% 100.021% ( 1300, 1900 ] 7 0.003% 100.024% ( 1900, 2900 ] 7 0.003% 100.026% ( 2900, 4400 ] 11 0.004% 100.030% ( 4400, 6600 ] 1 0.000% 100.031% ** Level 4 read latency histogram (micros): Count: 305 Average: 122.9049 StdDev: 605.46 Min: 0 Median: 1.7870 Max: 5116 Percentiles: P50: 1.79 P75: 5.39 P99: 4006.25 P99.9: 5116.00 P99.99: 5116.00 ------------------------------------------------------ [ 0, 1 ] 62 20.328% 20.328% #### ( 1, 2 ] 115 37.705% 58.033% ######## ( 2, 3 ] 24 7.869% 65.902% ## ( 3, 4 ] 18 5.902% 71.803% # ( 4, 6 ] 14 4.590% 76.393% # ( 6, 10 ] 36 11.803% 88.197% ## ( 10, 15 ] 8 2.623% 90.820% # ( 15, 22 ] 4 1.311% 92.131% ( 22, 34 ] 1 0.328% 92.459% ( 76, 110 ] 1 0.328% 92.787% ( 110, 170 ] 2 0.656% 93.443% ( 170, 250 ] 4 1.311% 94.754% ( 380, 580 ] 2 0.656% 95.410% ( 580, 870 ] 2 0.656% 96.066% ( 870, 1300 ] 4 1.311% 97.377% ( 1300, 1900 ] 1 0.328% 97.705% ( 1900, 2900 ] 1 0.328% 98.033% ( 2900, 4400 ] 4 1.311% 99.344% ( 4400, 6600 ] 2 0.656% 100.000% ** Level 5 read latency histogram (micros): Count: 60 Average: 866.9833 StdDev: 1168.57 Min: 78 Median: 315.0000 Max: 5730 Percentiles: P50: 315.00 P75: 1156.67 P99: 5280.00 P99.9: 5730.00 P99.99: 5730.00 ------------------------------------------------------ ( 76, 110 ] 12 20.000% 20.000% #### ( 110, 170 ] 9 15.000% 35.000% ### ( 170, 250 ] 7 11.667% 46.667% ## ( 250, 380 ] 4 6.667% 53.333% # ( 380, 580 ] 7 11.667% 65.000% ## ( 580, 870 ] 4 6.667% 71.667% # ( 870, 1300 ] 3 5.000% 76.667% # ( 1300, 1900 ] 4 6.667% 83.333% # ( 1900, 2900 ] 6 10.000% 93.333% ## ( 2900, 4400 ] 3 5.000% 98.333% # ( 4400, 6600 ] 1 1.667% 100.000% ** DB Stats ** Uptime(secs): 25.3 total, 5.2 interval Cumulative writes: 0 writes, 7000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 6.73 GB, 272.67 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:6.871 H:M:S, 27.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 190.74 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:2.589 H:M:S, 50.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/07/21-12:45:52 ... thread 0: (1000000,8000000) ops and (29108.9,134645.7) ops/second in (34.353754,59.415189) 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 3/2 314.89 MB 12.6 7.2 0.0 7.2 14.8 7.6 0.0 1.9 141.4 291.1 52.10 46.93 132 0.395 7482K 13K 0.0 0.0 L1 5/5 270.56 MB 0.0 11.1 7.1 4.0 10.9 7.0 0.2 1.5 222.9 219.7 51.01 46.77 5 10.201 10M 69K 0.0 0.0 L2 29/25 3.56 GB 4.7 0.3 0.2 0.2 0.3 0.2 6.7 1.8 259.3 259.2 1.35 1.30 2 0.673 354K 177 0.0 0.0 L3 35/12 2.16 GB 1.3 5.8 3.0 2.8 5.8 3.0 0.3 1.9 171.2 170.2 34.71 25.69 22 1.578 5905K 33K 0.0 0.0 L4 182/4 9.96 GB 1.0 1.2 1.1 0.0 1.2 1.1 0.9 1.0 166.3 166.1 7.13 5.48 14 0.509 1201K 1646 0.0 0.0 L5 1060/0 87.29 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1314/48 103.55 GB 0.0 25.6 11.5 14.1 33.0 18.9 9.8 4.3 179.2 231.1 146.30 126.17 175 0.836 25M 117K 0.0 0.0 Int 0/0 0.00 KB 0.0 25.6 11.5 14.1 33.0 18.9 9.7 4.3 179.2 231.1 146.30 126.17 175 0.836 25M 117K 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 25.6 11.5 14.1 25.4 11.2 0.0 0.0 214.8 213.0 122.06 106.31 66 1.849 25M 117K 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 322.3 24.24 19.86 109 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): 59.6 total, 59.4 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: 33.02 GB write, 567.16 MB/s write, 25.60 GB read, 439.75 MB/s read, 146.3 seconds Interval compaction: 33.02 GB write, 569.09 MB/s write, 25.60 GB read, 441.26 MB/s read, 146.3 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 20, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 20, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 32, pending-compaction-bytes-delays: 30, pending-compaction-bytes-stops: 0, total-delays: 50, total-stops: 32, interval: 82 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3778039 Average: 2.7949 StdDev: 19.40 Min: 0 Median: 1.4814 Max: 6734 Percentiles: P50: 1.48 P75: 1.87 P99: 7.62 P99.9: 152.96 P99.99: 402.55 ------------------------------------------------------ [ 0, 1 ] 709658 18.784% 18.784% #### ( 1, 2 ] 2449677 64.840% 83.624% ############# ( 2, 3 ] 355741 9.416% 93.040% ## ( 3, 4 ] 130364 3.451% 96.490% # ( 4, 6 ] 82058 2.172% 98.662% ( 6, 10 ] 31500 0.834% 99.496% ( 10, 15 ] 4123 0.109% 99.605% ( 15, 22 ] 677 0.018% 99.623% ( 22, 34 ] 43 0.001% 99.624% ( 34, 51 ] 16 0.000% 99.625% ( 51, 76 ] 345 0.009% 99.634% ( 76, 110 ] 6540 0.173% 99.807% ( 110, 170 ] 4915 0.130% 99.937% ( 170, 250 ] 1087 0.029% 99.966% ( 250, 380 ] 836 0.022% 99.988% ( 380, 580 ] 720 0.019% 100.007% ( 580, 870 ] 264 0.007% 100.014% ( 870, 1300 ] 84 0.002% 100.016% ( 1300, 1900 ] 34 0.001% 100.017% ( 1900, 2900 ] 23 0.001% 100.018% ( 2900, 4400 ] 30 0.001% 100.018% ( 4400, 6600 ] 7 0.000% 100.019% ( 6600, 9900 ] 1 0.000% 100.019% ** Level 1 read latency histogram (micros): Count: 2111449 Average: 4.7853 StdDev: 82.86 Min: 0 Median: 1.5834 Max: 24965 Percentiles: P50: 1.58 P75: 2.13 P99: 9.18 P99.9: 147.98 P99.99: 399.19 ------------------------------------------------------ [ 0, 1 ] 368102 17.434% 17.434% ### ( 1, 2 ] 1178585 55.819% 73.252% ########### ( 2, 3 ] 276381 13.090% 86.342% ### ( 3, 4 ] 125766 5.956% 92.298% # ( 4, 6 ] 113352 5.368% 97.667% # ( 6, 10 ] 35359 1.675% 99.341% ( 10, 15 ] 6031 0.286% 99.627% ( 15, 22 ] 886 0.042% 99.669% ( 22, 34 ] 50 0.002% 99.671% ( 34, 51 ] 63 0.003% 99.674% ( 51, 76 ] 450 0.021% 99.696% ( 76, 110 ] 2925 0.139% 99.834% ( 110, 170 ] 2192 0.104% 99.938% ( 170, 250 ] 516 0.024% 99.963% ( 250, 380 ] 524 0.025% 99.987% ( 380, 580 ] 582 0.028% 100.015% ( 580, 870 ] 535 0.025% 100.040% ( 870, 1300 ] 365 0.017% 100.058% ( 1300, 1900 ] 226 0.011% 100.068% ( 1900, 2900 ] 284 0.013% 100.082% ( 2900, 4400 ] 352 0.017% 100.098% ( 4400, 6600 ] 91 0.004% 100.103% ( 6600, 9900 ] 45 0.002% 100.105% ( 9900, 14000 ] 4 0.000% 100.105% ( 14000, 22000 ] 1 0.000% 100.105% ( 22000, 33000 ] 1 0.000% 100.105% ** Level 2 read latency histogram (micros): Count: 88643 Average: 2.0498 StdDev: 5.06 Min: 0 Median: 1.4211 Max: 1046 Percentiles: P50: 1.42 P75: 1.82 P99: 5.49 P99.9: 9.87 P99.99: 132.71 ------------------------------------------------------ [ 0, 1 ] 21155 23.865% 23.865% ##### ( 1, 2 ] 55010 62.058% 85.923% ############ ( 2, 3 ] 7280 8.213% 94.136% ## ( 3, 4 ] 2961 3.340% 97.476% # ( 4, 6 ] 1809 2.041% 99.517% ( 6, 10 ] 351 0.396% 99.913% ( 10, 15 ] 56 0.063% 99.976% ( 15, 22 ] 7 0.008% 99.984% ( 22, 34 ] 2 0.002% 99.986% ( 34, 51 ] 1 0.001% 99.988% ( 51, 76 ] 1 0.001% 99.989% ( 110, 170 ] 3 0.003% 99.992% ( 170, 250 ] 2 0.002% 99.994% ( 250, 380 ] 2 0.002% 99.997% ( 380, 580 ] 1 0.001% 99.998% ( 580, 870 ] 1 0.001% 99.999% ( 870, 1300 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 1071848 Average: 5.8633 StdDev: 92.56 Min: 1 Median: 1.8383 Max: 18621 Percentiles: P50: 1.84 P75: 2.78 P99: 9.27 P99.9: 222.08 P99.99: 508.64 ------------------------------------------------------ [ 0, 1 ] 45826 4.275% 4.275% # ( 1, 2 ] 584650 54.546% 58.821% ########### ( 2, 3 ] 221078 20.626% 79.447% #### ( 3, 4 ] 101714 9.490% 88.937% ## ( 4, 6 ] 91491 8.536% 97.473% ## ( 6, 10 ] 19997 1.866% 99.338% ( 10, 15 ] 3984 0.372% 99.710% ( 15, 22 ] 479 0.045% 99.755% ( 22, 34 ] 53 0.005% 99.760% ( 34, 51 ] 12 0.001% 99.761% ( 51, 76 ] 18 0.002% 99.762% ( 76, 110 ] 319 0.030% 99.792% ( 110, 170 ] 817 0.076% 99.868% ( 170, 250 ] 521 0.049% 99.917% ( 250, 380 ] 476 0.044% 99.961% ( 380, 580 ] 477 0.045% 100.006% ( 580, 870 ] 465 0.043% 100.049% ( 870, 1300 ] 289 0.027% 100.076% ( 1300, 1900 ] 156 0.015% 100.091% ( 1900, 2900 ] 194 0.018% 100.109% ( 2900, 4400 ] 216 0.020% 100.129% ( 4400, 6600 ] 64 0.006% 100.135% ( 6600, 9900 ] 25 0.002% 100.137% ( 9900, 14000 ] 6 0.001% 100.138% ( 14000, 22000 ] 1 0.000% 100.138% ** Level 4 read latency histogram (micros): Count: 10441 Average: 77.4899 StdDev: 388.46 Min: 0 Median: 1.9944 Max: 12231 Percentiles: P50: 1.99 P75: 3.46 P99: 1667.08 P99.9: 5052.48 P99.99: 9754.47 ------------------------------------------------------ [ 0, 1 ] 335 3.209% 3.209% # ( 1, 2 ] 4913 47.055% 50.263% ######### ( 2, 3 ] 2046 19.596% 69.859% #### ( 3, 4 ] 1176 11.263% 81.122% ## ( 4, 6 ] 624 5.976% 87.099% # ( 6, 10 ] 228 2.184% 89.283% ( 10, 15 ] 62 0.594% 89.876% ( 15, 22 ] 8 0.077% 89.953% ( 22, 34 ] 1 0.010% 89.963% ( 34, 51 ] 1 0.010% 89.972% ( 76, 110 ] 54 0.517% 90.489% ( 110, 170 ] 150 1.437% 91.926% ( 170, 250 ] 141 1.350% 93.277% ( 250, 380 ] 140 1.341% 94.617% ( 380, 580 ] 171 1.638% 96.255% ( 580, 870 ] 135 1.293% 97.548% ( 870, 1300 ] 121 1.159% 98.707% ( 1300, 1900 ] 50 0.479% 99.186% ( 1900, 2900 ] 37 0.354% 99.540% ( 2900, 4400 ] 34 0.326% 99.866% ( 4400, 6600 ] 12 0.115% 99.981% ( 6600, 9900 ] 1 0.010% 99.990% ( 9900, 14000 ] 1 0.010% 100.000% ** Level 5 read latency histogram (micros): Count: 100 Average: 848.4100 StdDev: 1069.09 Min: 78 Median: 368.1818 Max: 5730 Percentiles: P50: 368.18 P75: 1156.67 P99: 4400.00 P99.9: 5730.00 P99.99: 5730.00 ------------------------------------------------------ ( 76, 110 ] 15 15.000% 15.000% ### ( 110, 170 ] 16 16.000% 31.000% ### ( 170, 250 ] 9 9.000% 40.000% ## ( 250, 380 ] 11 11.000% 51.000% ## ( 380, 580 ] 11 11.000% 62.000% ## ( 580, 870 ] 9 9.000% 71.000% ## ( 870, 1300 ] 6 6.000% 77.000% # ( 1300, 1900 ] 6 6.000% 83.000% # ( 1900, 2900 ] 12 12.000% 95.000% ## ( 2900, 4400 ] 4 4.000% 99.000% # ( 4400, 6600 ] 1 1.000% 100.000% ** DB Stats ** Uptime(secs): 59.6 total, 34.4 interval Cumulative writes: 0 writes, 8000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 7.69 GB, 132.06 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:37.552 H:M:S, 63.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 28.65 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:30.680 H:M:S, 89.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 10 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 : 7.377 micros/op 135546 ops/sec 60.001 seconds 8132999 operations; 131.3 MB/s Microseconds per write: Count: 8132999 Average: 7.3775 StdDev: 543.76 Min: 1 Median: 1.7217 Max: 1000469 Percentiles: P50: 1.72 P75: 2.70 P99: 9.90 P99.9: 1259.04 P99.99: 2777.75 ------------------------------------------------------ [ 0, 1 ] 1205294 14.820% 14.820% ### ( 1, 2 ] 3964702 48.748% 63.568% ########## ( 2, 3 ] 1319523 16.224% 79.792% ### ( 3, 4 ] 1065563 13.102% 92.894% ### ( 4, 6 ] 396211 4.872% 97.766% # ( 6, 10 ] 103051 1.267% 99.033% ( 10, 15 ] 35612 0.438% 99.471% ( 15, 22 ] 7905 0.097% 99.568% ( 22, 34 ] 1897 0.023% 99.591% ( 34, 51 ] 200 0.002% 99.594% ( 51, 76 ] 22 0.000% 99.594% ( 76, 110 ] 5516 0.068% 99.662% ( 110, 170 ] 2329 0.029% 99.690% ( 170, 250 ] 236 0.003% 99.693% ( 250, 380 ] 152 0.002% 99.695% ( 380, 580 ] 22 0.000% 99.696% ( 580, 870 ] 21 0.000% 99.696% ( 870, 1300 ] 18359 0.226% 99.922% ( 1300, 1900 ] 47 0.001% 99.922% ( 1900, 2900 ] 6293 0.077% 99.999% ( 2900, 4400 ] 19 0.000% 100.000% ( 4400, 6600 ] 4 0.000% 100.000% ( 6600, 9900 ] 2 0.000% 100.000% ( 9900, 14000 ] 1 0.000% 100.000% ( 14000, 22000 ] 1 0.000% 100.000% ( 170000, 250000 ] 15 0.000% 100.000% ( 570000, 860000 ] 1 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 : 222998 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 : 8132999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 8393254968 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 : 475 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 37725379 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 : 29913114258 rocksdb.compact.write.bytes COUNT : 29681291404 rocksdb.flush.write.bytes COUNT : 8257110225 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 : 28 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 : 236 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 : 8190563328 rocksdb.memtable.garbage.bytes.at.flush COUNT : 3206144 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 : 29983913627 rocksdb.non.last.level.read.count COUNT : 7248616 rocksdb.block.checksum.compute.count COUNT : 7247694 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.357837 P95 : 3.903505 P99 : 8.698073 P100 : 1000468.000000 COUNT : 8132999 SUM : 56205624 rocksdb.compaction.times.micros P50 : 1076896.551724 P95 : 5290000.000000 P99 : 23151496.000000 P100 : 23151496.000000 COUNT : 71 SUM : 128052883 rocksdb.compaction.times.cpu_micros P50 : 963214.285714 P95 : 5290000.000000 P99 : 19160000.000000 P100 : 21034311.000000 COUNT : 71 SUM : 109791099 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 : 707.796610 P95 : 1287.352941 P99 : 21600.000000 P100 : 22111.000000 COUNT : 110 SUM : 147750 rocksdb.compaction.outfile.sync.micros P50 : 915.529412 P95 : 103000.000000 P99 : 210960.000000 P100 : 290806.000000 COUNT : 344 SUM : 4964893 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 : 95.318182 P95 : 1605.000000 P99 : 4422.000000 P100 : 7170.000000 COUNT : 199 SUM : 62535 rocksdb.table.open.io.micros P50 : 1280.454545 P95 : 6114.705882 P99 : 9248.684211 P100 : 10600.000000 COUNT : 475 SUM : 860534 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.600213 P95 : 7.651795 P99 : 12.222138 P100 : 24970.000000 COUNT : 7246571 SUM : 45209775 rocksdb.read.block.get.micros P50 : 400.754717 P95 : 3161.627907 P99 : 4900.000000 P100 : 7641.000000 COUNT : 950 SUM : 731534 rocksdb.write.raw.block.micros P50 : 0.512181 P95 : 0.973143 P99 : 2.768421 P100 : 19616.000000 COUNT : 9191859 SUM : 18392955 rocksdb.numfiles.in.singlecompaction P50 : 3.120000 P95 : 8.500000 P99 : 21.300000 P100 : 28.000000 COUNT : 110 SUM : 435 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.567056 P95 : 1202.675832 P99 : 2569.528812 P100 : 1000267.000000 COUNT : 209602 SUM : 37745851 rocksdb.sst.read.micros P50 : 1.568097 P95 : 4.565999 P99 : 8.905077 P100 : 24965.000000 COUNT : 7249109 SUM : 30347773 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 : 8132999 SUM : 8393254968 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 : 208857.142857 P95 : 375357.142857 P99 : 1013000.000000 P100 : 1120136.000000 COUNT : 110 SUM : 24754860 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 : 301 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