[2024-11-18 19:13:28.114997] Starting SPDK v24.01.1-pre git sha1 c13c99a5e / DPDK 23.11.0 initialization... [2024-11-18 19:13:28.115253] [ 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_pid1989153 ] Set seed to 1731953608108306 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-11-18 19:13:28.235753] app.c: 798:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-11-18 19:13:28.446134] app.c: 488:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-11-18 19:13:28.446181] app.c: 489:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 1989153' to capture a snapshot of events at runtime. [2024-11-18 19:13:28.446191] app.c: 494:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid1989153 for offline analysis/debug. [2024-11-18 19:13:28.446219] reactor.c: 937:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Mon Nov 18 19:13:37 2024 CPU: 96 * Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz CPUCache: 36608 KB 2024/11/18-19:13:40 ... thread 0: (1000000,1000000) ops and (334379.7,334379.7) ops/second in (2.990612,2.990612) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 6/4 440.97 MB 18.9 0.0 0.0 0.0 0.9 0.9 0.0 1.0 0.0 351.8 2.51 2.24 12 0.209 0 0 0.0 0.0 L1 3/0 249.57 MB 25.0 0.2 0.2 0.0 0.2 0.2 0.2 1.0 250.0 249.7 1.01 0.98 1 1.008 255K 263 0.0 0.0 L2 3/2 191.03 MB 0.0 0.2 0.1 0.1 0.2 0.1 0.2 1.5 235.7 235.5 0.82 0.78 2 0.409 195K 86 0.0 0.0 L3 10/0 867.12 MB 0.9 0.0 0.0 0.0 0.0 0.0 0.1 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 116/0 9.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 1044/0 85.75 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 1182/6 97.00 GB 0.0 0.4 0.4 0.1 1.3 1.2 0.5 1.5 102.6 306.1 4.33 4.00 15 0.289 451K 349 0.0 0.0 Int 0/0 0.00 KB 0.0 0.4 0.4 0.1 1.3 1.2 0.4 1.5 102.6 306.1 4.33 4.00 15 0.289 451K 349 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 0.4 0.4 0.1 0.4 0.4 0.0 0.0 243.6 243.4 1.83 1.76 3 0.609 451K 349 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 351.8 2.51 2.24 12 0.209 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 3.2 total, 3.0 interval Flush(GB): cumulative 0.861, interval 0.861 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 1.30 GB write, 413.97 MB/s write, 0.43 GB read, 138.81 MB/s read, 4.3 seconds Interval compaction: 1.30 GB write, 443.30 MB/s write, 0.43 GB read, 148.65 MB/s read, 4.3 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 4, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 4, interval: 4 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 155701 Average: 2.0659 StdDev: 17.03 Min: 0 Median: 1.3813 Max: 4364 Percentiles: P50: 1.38 P75: 1.78 P99: 5.40 P99.9: 9.65 P99.99: 68.87 ------------------------------------------------------ [ 0, 1 ] 40482 26.000% 26.000% ##### ( 1, 2 ] 98001 62.942% 88.942% ############# ( 2, 3 ] 9762 6.270% 95.211% # ( 3, 4 ] 4046 2.599% 97.810% # ( 4, 6 ] 2648 1.701% 99.511% ( 6, 10 ] 664 0.426% 99.937% ( 10, 15 ] 64 0.041% 99.978% ( 15, 22 ] 12 0.008% 99.986% ( 22, 34 ] 3 0.002% 99.988% ( 34, 51 ] 2 0.001% 99.989% ( 51, 76 ] 2 0.001% 99.990% ( 110, 170 ] 6 0.004% 99.994% ( 170, 250 ] 4 0.003% 99.997% ( 250, 380 ] 2 0.001% 99.998% ( 380, 580 ] 5 0.003% 100.001% ( 580, 870 ] 1 0.001% 100.002% ( 870, 1300 ] 3 0.002% 100.004% ( 2900, 4400 ] 3 0.002% 100.006% ** Level 1 read latency histogram (micros): Count: 574 Average: 17.6986 StdDev: 137.87 Min: 1 Median: 1.9101 Max: 2357 Percentiles: P50: 1.91 P75: 2.82 P99: 432.00 P99.9: 2326.00 P99.99: 2357.00 ------------------------------------------------------ [ 0, 1 ] 44 7.666% 7.666% ## ( 1, 2 ] 267 46.516% 54.181% ######### ( 2, 3 ] 146 25.436% 79.617% ##### ( 3, 4 ] 51 8.885% 88.502% ## ( 4, 6 ] 42 7.317% 95.819% # ( 6, 10 ] 8 1.394% 97.213% ( 10, 15 ] 3 0.523% 97.735% ( 15, 22 ] 2 0.348% 98.084% ( 110, 170 ] 1 0.174% 98.258% ( 170, 250 ] 1 0.174% 98.432% ( 250, 380 ] 3 0.523% 98.955% ( 380, 580 ] 1 0.174% 99.129% ( 580, 870 ] 1 0.174% 99.303% ( 870, 1300 ] 2 0.348% 99.652% ( 1300, 1900 ] 1 0.174% 99.826% ( 1900, 2900 ] 1 0.174% 100.000% ** Level 2 read latency histogram (micros): Count: 40753 Average: 2.2960 StdDev: 7.20 Min: 0 Median: 1.5382 Max: 1107 Percentiles: P50: 1.54 P75: 1.91 P99: 5.99 P99.9: 11.66 P99.99: 33.55 ------------------------------------------------------ [ 0, 1 ] 5676 13.928% 13.928% ### ( 1, 2 ] 27318 67.033% 80.961% ############# ( 2, 3 ] 4132 10.139% 91.100% ## ( 3, 4 ] 1860 4.564% 95.664% # ( 4, 6 ] 1372 3.367% 99.031% # ( 6, 10 ] 342 0.839% 99.870% ( 10, 15 ] 46 0.113% 99.983% ( 15, 22 ] 4 0.010% 99.993% ( 22, 34 ] 2 0.005% 99.998% ( 34, 51 ] 1 0.002% 100.000% ( 170, 250 ] 1 0.002% 100.002% ( 380, 580 ] 2 0.005% 100.007% ( 580, 870 ] 1 0.002% 100.010% ( 870, 1300 ] 1 0.002% 100.012% ** Level 3 read latency histogram (micros): Count: 45 Average: 3934.4667 StdDev: 3839.69 Min: 513 Median: 1771.4286 Max: 12842 Percentiles: P50: 1771.43 P75: 7218.75 P99: 12842.00 P99.9: 12842.00 P99.99: 12842.00 ------------------------------------------------------ ( 380, 580 ] 1 2.222% 2.222% ( 580, 870 ] 2 4.444% 6.667% # ( 870, 1300 ] 14 31.111% 37.778% ###### ( 1300, 1900 ] 7 15.556% 53.333% ### ( 1900, 2900 ] 3 6.667% 60.000% # ( 2900, 4400 ] 4 8.889% 68.889% ## ( 4400, 6600 ] 2 4.444% 73.333% # ( 6600, 9900 ] 4 8.889% 82.222% ## ( 9900, 14000 ] 8 17.778% 100.000% #### ** Level 4 read latency histogram (micros): Count: 30 Average: 4502.6000 StdDev: 3779.12 Min: 996 Median: 2150.0000 Max: 11199 Percentiles: P50: 2150.00 P75: 8662.50 P99: 11199.00 P99.9: 11199.00 P99.99: 11199.00 ------------------------------------------------------ ( 870, 1300 ] 4 13.333% 13.333% ### ( 1300, 1900 ] 10 33.333% 46.667% ####### ( 1900, 2900 ] 4 13.333% 60.000% ### ( 4400, 6600 ] 2 6.667% 66.667% # ( 6600, 9900 ] 4 13.333% 80.000% ### ( 9900, 14000 ] 6 20.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, 307.16 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:0.430 H:M:S, 13.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 328.84 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.430 H:M:S, 14.4 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/18-19:13:42 ... thread 0: (1000000,2000000) ops and (360854.0,347112.8) ops/second in (2.771204,5.761816) 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/16 1.35 GB 6.3 0.2 0.0 0.2 2.0 1.8 0.0 1.1 41.4 341.5 6.09 5.51 27 0.225 255K 245 0.0 0.0 L1 3/3 249.57 MB 0.0 0.2 0.2 0.0 0.2 0.2 0.2 1.0 250.0 249.7 1.01 0.98 1 1.008 255K 263 0.0 0.0 L2 1/0 3.75 MB 0.0 0.2 0.1 0.1 0.2 0.1 0.2 1.5 235.7 235.5 0.82 0.78 2 0.409 195K 86 0.0 0.0 L3 17/0 885.86 MB 0.9 0.2 0.2 0.0 0.2 0.2 0.1 1.0 218.8 218.8 0.86 0.79 1 0.856 190K 0 0.0 0.0 L4 174/0 9.70 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.0 1.0 138.1 138.1 1.22 0.86 1 1.221 171K 0 0.0 0.0 L5 1044/0 85.75 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 1256/19 97.92 GB 0.0 1.0 0.7 0.3 2.8 2.5 0.5 1.6 105.4 288.2 9.99 8.92 32 0.312 1068K 594 0.0 0.0 Int 0/0 0.00 KB 0.0 1.0 0.7 0.3 2.8 2.5 0.4 1.6 105.4 288.2 9.99 8.92 32 0.312 1068K 594 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.0 0.7 0.3 1.0 0.7 0.0 0.0 216.0 215.9 4.87 4.36 6 0.812 1068K 594 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 357.0 5.12 4.56 26 0.197 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.8 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: 2.81 GB write, 481.82 MB/s write, 1.03 GB read, 176.16 MB/s read, 10.0 seconds Interval compaction: 2.81 GB write, 499.55 MB/s write, 1.03 GB read, 182.64 MB/s read, 10.0 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 6, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 6, interval: 6 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 341976 Average: 2.1798 StdDev: 17.71 Min: 0 Median: 1.4557 Max: 4759 Percentiles: P50: 1.46 P75: 1.84 P99: 5.55 P99.9: 9.60 P99.99: 15.22 ------------------------------------------------------ [ 0, 1 ] 69181 20.230% 20.230% #### ( 1, 2 ] 223424 65.333% 85.563% ############# ( 2, 3 ] 30542 8.931% 94.494% ## ( 3, 4 ] 9808 2.868% 97.362% # ( 4, 6 ] 7216 2.110% 99.472% ( 6, 10 ] 1625 0.475% 99.947% ( 10, 15 ] 146 0.043% 99.990% ( 15, 22 ] 25 0.007% 99.997% ( 22, 34 ] 6 0.002% 99.999% ( 34, 51 ] 3 0.001% 100.000% ( 51, 76 ] 3 0.001% 100.001% ( 110, 170 ] 15 0.004% 100.005% ( 170, 250 ] 7 0.002% 100.007% ( 250, 380 ] 7 0.002% 100.009% ( 380, 580 ] 8 0.002% 100.012% ( 580, 870 ] 3 0.001% 100.013% ( 870, 1300 ] 5 0.001% 100.014% ( 1300, 1900 ] 1 0.000% 100.014% ( 1900, 2900 ] 2 0.001% 100.015% ( 2900, 4400 ] 5 0.001% 100.016% ( 4400, 6600 ] 1 0.000% 100.017% ** Level 1 read latency histogram (micros): Count: 29064 Average: 2.4035 StdDev: 19.52 Min: 1 Median: 1.5072 Max: 2357 Percentiles: P50: 1.51 P75: 1.88 P99: 5.54 P99.9: 9.87 P99.99: 1105.12 ------------------------------------------------------ [ 0, 1 ] 4536 15.607% 15.607% ### ( 1, 2 ] 19708 67.809% 83.416% ############## ( 2, 3 ] 3245 11.165% 94.581% ## ( 3, 4 ] 800 2.753% 97.333% # ( 4, 6 ] 629 2.164% 99.498% ( 6, 10 ] 121 0.416% 99.914% ( 10, 15 ] 11 0.038% 99.952% ( 15, 22 ] 3 0.010% 99.962% ( 110, 170 ] 1 0.003% 99.966% ( 170, 250 ] 1 0.003% 99.969% ( 250, 380 ] 3 0.010% 99.979% ( 380, 580 ] 1 0.003% 99.983% ( 580, 870 ] 1 0.003% 99.986% ( 870, 1300 ] 2 0.007% 99.993% ( 1300, 1900 ] 1 0.003% 99.997% ( 1900, 2900 ] 1 0.003% 100.000% ** Level 2 read latency histogram (micros): Count: 47966 Average: 2.2858 StdDev: 6.65 Min: 0 Median: 1.5436 Max: 1107 Percentiles: P50: 1.54 P75: 1.92 P99: 5.96 P99.9: 11.81 P99.99: 30.81 ------------------------------------------------------ [ 0, 1 ] 6446 13.439% 13.439% ### ( 1, 2 ] 32263 67.262% 80.701% ############# ( 2, 3 ] 5172 10.783% 91.484% ## ( 3, 4 ] 2095 4.368% 95.851% # ( 4, 6 ] 1541 3.213% 99.064% # ( 6, 10 ] 380 0.792% 99.856% ( 10, 15 ] 58 0.121% 99.977% ( 15, 22 ] 4 0.008% 99.985% ( 22, 34 ] 3 0.006% 99.992% ( 34, 51 ] 1 0.002% 99.994% ( 170, 250 ] 1 0.002% 99.996% ( 380, 580 ] 2 0.004% 100.000% ( 580, 870 ] 1 0.002% 100.002% ( 870, 1300 ] 1 0.002% 100.004% ** Level 3 read latency histogram (micros): Count: 42875 Average: 6.3074 StdDev: 178.12 Min: 0 Median: 1.5130 Max: 12842 Percentiles: P50: 1.51 P75: 1.87 P99: 5.91 P99.9: 873.58 P99.99: 11802.66 ------------------------------------------------------ [ 0, 1 ] 6144 14.330% 14.330% ### ( 1, 2 ] 29811 69.530% 83.860% ############## ( 2, 3 ] 4836 11.279% 95.139% ## ( 3, 4 ] 831 1.938% 97.078% ( 4, 6 ] 863 2.013% 99.090% ( 6, 10 ] 290 0.676% 99.767% ( 10, 15 ] 39 0.091% 99.858% ( 15, 22 ] 8 0.019% 99.876% ( 22, 34 ] 2 0.005% 99.881% ( 51, 76 ] 1 0.002% 99.883% ( 76, 110 ] 1 0.002% 99.886% ( 110, 170 ] 1 0.002% 99.888% ( 250, 380 ] 1 0.002% 99.890% ( 380, 580 ] 1 0.002% 99.893% ( 580, 870 ] 3 0.007% 99.900% ( 870, 1300 ] 15 0.035% 99.935% ( 1300, 1900 ] 7 0.016% 99.951% ( 1900, 2900 ] 3 0.007% 99.958% ( 2900, 4400 ] 4 0.009% 99.967% ( 4400, 6600 ] 2 0.005% 99.972% ( 6600, 9900 ] 4 0.009% 99.981% ( 9900, 14000 ] 8 0.019% 100.000% ** Level 4 read latency histogram (micros): Count: 320 Average: 426.5938 StdDev: 1748.64 Min: 1 Median: 1.9709 Max: 11199 Percentiles: P50: 1.97 P75: 6.42 P99: 11199.00 P99.9: 11199.00 P99.99: 11199.00 ------------------------------------------------------ [ 0, 1 ] 60 18.750% 18.750% #### ( 1, 2 ] 103 32.188% 50.938% ###### ( 2, 3 ] 54 16.875% 67.812% ### ( 3, 4 ] 9 2.812% 70.625% # ( 4, 6 ] 12 3.750% 74.375% # ( 6, 10 ] 19 5.938% 80.312% # ( 10, 15 ] 26 8.125% 88.438% ## ( 15, 22 ] 5 1.562% 90.000% ( 110, 170 ] 1 0.312% 90.312% ( 170, 250 ] 1 0.312% 90.625% ( 870, 1300 ] 4 1.250% 91.875% ( 1300, 1900 ] 10 3.125% 95.000% # ( 1900, 2900 ] 4 1.250% 96.250% ( 4400, 6600 ] 2 0.625% 96.875% ( 6600, 9900 ] 4 1.250% 98.125% ( 9900, 14000 ] 6 1.875% 100.000% ** DB Stats ** Uptime(secs): 6.0 total, 2.8 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 329.42 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:0.616 H:M:S, 10.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 355.15 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.185 H:M:S, 6.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/11/18-19:13:45 ... thread 0: (1000000,3000000) ops and (332656.4,342156.4) ops/second in (3.006105,8.767921) 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.54 GB 132.2 1.4 0.0 1.4 4.1 2.7 0.0 1.5 108.0 314.6 13.41 12.42 44 0.305 1471K 1588 0.0 0.0 L1 5/0 485.75 MB 48.6 1.2 1.0 0.2 1.2 1.0 0.2 1.2 233.9 233.0 5.38 5.23 2 2.688 1276K 4556 0.0 0.0 L2 1/0 3.75 MB 0.0 0.2 0.1 0.1 0.2 0.1 0.7 1.5 235.7 235.5 0.82 0.78 2 0.409 195K 86 0.0 0.0 L3 13/0 708.01 MB 0.7 0.2 0.2 0.0 0.2 0.2 0.6 1.0 218.8 218.8 0.86 0.79 1 0.856 190K 0 0.0 0.0 L4 174/0 9.70 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.7 1.0 138.1 138.1 1.22 0.86 1 1.221 171K 0 0.0 0.0 L5 1052/0 86.43 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 1255/4 98.84 GB 0.0 3.2 1.5 1.7 5.9 4.2 2.8 2.2 150.1 277.7 21.68 20.08 50 0.434 3304K 6230 0.0 0.0 Int 0/0 0.00 KB 0.0 3.2 1.5 1.7 5.9 4.2 2.7 2.2 150.1 277.7 21.68 20.08 50 0.434 3304K 6230 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.2 1.5 1.7 3.2 1.5 0.0 0.0 234.3 233.9 13.89 13.15 11 1.263 3304K 6230 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.8 7.79 6.93 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: 5.88 GB write, 670.31 MB/s write, 3.18 GB read, 362.40 MB/s read, 21.7 seconds Interval compaction: 5.88 GB write, 686.51 MB/s write, 3.18 GB read, 371.16 MB/s read, 21.7 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 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: 706685 Average: 2.2103 StdDev: 14.83 Min: 0 Median: 1.4991 Max: 4759 Percentiles: P50: 1.50 P75: 1.87 P99: 5.55 P99.9: 9.46 P99.99: 13.81 ------------------------------------------------------ [ 0, 1 ] 116712 16.515% 16.515% ### ( 1, 2 ] 474108 67.089% 83.604% ############# ( 2, 3 ] 74034 10.476% 94.081% ## ( 3, 4 ] 22126 3.131% 97.212% # ( 4, 6 ] 16288 2.305% 99.516% ( 6, 10 ] 3134 0.443% 99.960% ( 10, 15 ] 280 0.040% 100.000% ( 15, 22 ] 39 0.006% 100.005% ( 22, 34 ] 9 0.001% 100.006% ( 34, 51 ] 8 0.001% 100.007% ( 51, 76 ] 6 0.001% 100.008% ( 110, 170 ] 18 0.003% 100.011% ( 170, 250 ] 14 0.002% 100.013% ( 250, 380 ] 11 0.002% 100.014% ( 380, 580 ] 13 0.002% 100.016% ( 580, 870 ] 6 0.001% 100.017% ( 870, 1300 ] 12 0.002% 100.019% ( 1300, 1900 ] 3 0.000% 100.019% ( 1900, 2900 ] 3 0.000% 100.020% ( 2900, 4400 ] 7 0.001% 100.021% ( 4400, 6600 ] 1 0.000% 100.021% ** Level 1 read latency histogram (micros): Count: 63977 Average: 2.5022 StdDev: 21.13 Min: 1 Median: 1.5395 Max: 2357 Percentiles: P50: 1.54 P75: 1.90 P99: 5.48 P99.9: 9.75 P99.99: 1265.80 ------------------------------------------------------ [ 0, 1 ] 8027 12.547% 12.547% ### ( 1, 2 ] 44416 69.425% 81.972% ############## ( 2, 3 ] 7760 12.129% 94.101% ## ( 3, 4 ] 2052 3.207% 97.308% # ( 4, 6 ] 1462 2.285% 99.594% ( 6, 10 ] 209 0.327% 99.920% ( 10, 15 ] 19 0.030% 99.950% ( 15, 22 ] 4 0.006% 99.956% ( 22, 34 ] 1 0.002% 99.958% ( 110, 170 ] 1 0.002% 99.959% ( 170, 250 ] 1 0.002% 99.961% ( 250, 380 ] 4 0.006% 99.967% ( 380, 580 ] 9 0.014% 99.981% ( 580, 870 ] 1 0.002% 99.983% ( 870, 1300 ] 5 0.008% 99.991% ( 1300, 1900 ] 3 0.005% 99.995% ( 1900, 2900 ] 3 0.005% 100.000% ** Level 2 read latency histogram (micros): Count: 47966 Average: 2.2858 StdDev: 6.65 Min: 0 Median: 1.5436 Max: 1107 Percentiles: P50: 1.54 P75: 1.92 P99: 5.96 P99.9: 11.81 P99.99: 30.81 ------------------------------------------------------ [ 0, 1 ] 6446 13.439% 13.439% ### ( 1, 2 ] 32263 67.262% 80.701% ############# ( 2, 3 ] 5172 10.783% 91.484% ## ( 3, 4 ] 2095 4.368% 95.851% # ( 4, 6 ] 1541 3.213% 99.064% # ( 6, 10 ] 380 0.792% 99.856% ( 10, 15 ] 58 0.121% 99.977% ( 15, 22 ] 4 0.008% 99.985% ( 22, 34 ] 3 0.006% 99.992% ( 34, 51 ] 1 0.002% 99.994% ( 170, 250 ] 1 0.002% 99.996% ( 380, 580 ] 2 0.004% 100.000% ( 580, 870 ] 1 0.002% 100.002% ( 870, 1300 ] 1 0.002% 100.004% ** Level 3 read latency histogram (micros): Count: 42875 Average: 6.3074 StdDev: 178.12 Min: 0 Median: 1.5130 Max: 12842 Percentiles: P50: 1.51 P75: 1.87 P99: 5.91 P99.9: 873.58 P99.99: 11802.66 ------------------------------------------------------ [ 0, 1 ] 6144 14.330% 14.330% ### ( 1, 2 ] 29811 69.530% 83.860% ############## ( 2, 3 ] 4836 11.279% 95.139% ## ( 3, 4 ] 831 1.938% 97.078% ( 4, 6 ] 863 2.013% 99.090% ( 6, 10 ] 290 0.676% 99.767% ( 10, 15 ] 39 0.091% 99.858% ( 15, 22 ] 8 0.019% 99.876% ( 22, 34 ] 2 0.005% 99.881% ( 51, 76 ] 1 0.002% 99.883% ( 76, 110 ] 1 0.002% 99.886% ( 110, 170 ] 1 0.002% 99.888% ( 250, 380 ] 1 0.002% 99.890% ( 380, 580 ] 1 0.002% 99.893% ( 580, 870 ] 3 0.007% 99.900% ( 870, 1300 ] 15 0.035% 99.935% ( 1300, 1900 ] 7 0.016% 99.951% ( 1900, 2900 ] 3 0.007% 99.958% ( 2900, 4400 ] 4 0.009% 99.967% ( 4400, 6600 ] 2 0.005% 99.972% ( 6600, 9900 ] 4 0.009% 99.981% ( 9900, 14000 ] 8 0.019% 100.000% ** Level 4 read latency histogram (micros): Count: 320 Average: 426.5938 StdDev: 1748.64 Min: 1 Median: 1.9709 Max: 11199 Percentiles: P50: 1.97 P75: 6.42 P99: 11199.00 P99.9: 11199.00 P99.99: 11199.00 ------------------------------------------------------ [ 0, 1 ] 60 18.750% 18.750% #### ( 1, 2 ] 103 32.188% 50.938% ###### ( 2, 3 ] 54 16.875% 67.812% ### ( 3, 4 ] 9 2.812% 70.625% # ( 4, 6 ] 12 3.750% 74.375% # ( 6, 10 ] 19 5.938% 80.312% # ( 10, 15 ] 26 8.125% 88.438% ## ( 15, 22 ] 5 1.562% 90.000% ( 110, 170 ] 1 0.312% 90.312% ( 170, 250 ] 1 0.312% 90.625% ( 870, 1300 ] 4 1.250% 91.875% ( 1300, 1900 ] 10 3.125% 95.000% # ( 1900, 2900 ] 4 1.250% 96.250% ( 4400, 6600 ] 2 0.625% 96.875% ( 6600, 9900 ] 4 1.250% 98.125% ( 9900, 14000 ] 6 1.875% 100.000% ** Level 5 read latency histogram (micros): Count: 40 Average: 851.6000 StdDev: 1103.22 Min: 81 Median: 250.0000 Max: 3959 Percentiles: P50: 250.00 P75: 1013.33 P99: 3959.00 P99.9: 3959.00 P99.99: 3959.00 ------------------------------------------------------ ( 76, 110 ] 5 12.500% 12.500% ### ( 110, 170 ] 14 35.000% 47.500% ####### ( 170, 250 ] 1 2.500% 50.000% # ( 250, 380 ] 1 2.500% 52.500% # ( 380, 580 ] 1 2.500% 55.000% # ( 580, 870 ] 7 17.500% 72.500% #### ( 870, 1300 ] 3 7.500% 80.000% ## ( 1300, 1900 ] 2 5.000% 85.000% # ( 1900, 2900 ] 3 7.500% 92.500% ## ( 2900, 4400 ] 3 7.500% 100.000% ## ** DB Stats ** Uptime(secs): 9.0 total, 3.0 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 328.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:0.995 H:M:S, 11.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 327.40 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.380 H:M:S, 12.6 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/11/18-19:13:48 ... thread 0: (1000000,4000000) ops and (340492.2,341738.8) ops/second in (2.936925,11.704846) 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/8 2.52 GB 201.4 2.2 0.0 2.2 5.9 3.7 0.0 1.6 117.6 313.4 19.29 17.95 61 0.316 2302K 2458 0.0 0.0 L1 5/0 485.75 MB 48.6 1.2 1.0 0.2 1.2 1.0 0.2 1.2 233.9 233.0 5.38 5.23 2 2.688 1276K 4556 0.0 0.0 L2 1/0 3.75 MB 0.0 0.2 0.1 0.1 0.2 0.1 0.7 1.5 235.7 235.5 0.82 0.78 2 0.409 195K 86 0.0 0.0 L3 13/0 708.01 MB 0.7 0.2 0.2 0.0 0.2 0.2 0.6 1.0 218.8 218.8 0.86 0.79 1 0.856 190K 0 0.0 0.0 L4 174/0 9.70 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.7 1.0 138.1 138.1 1.22 0.86 1 1.221 171K 0 0.0 0.0 L5 1052/0 86.43 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 1260/8 99.82 GB 0.0 4.0 1.5 2.5 7.7 5.1 2.8 2.1 147.8 284.7 27.56 25.61 67 0.411 4136K 7100 0.0 0.0 Int 0/0 0.00 KB 0.0 4.0 1.5 2.5 7.7 5.1 2.7 2.1 147.8 284.7 27.56 25.61 67 0.411 4136K 7100 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 4.0 1.5 2.5 4.0 1.4 0.0 0.0 239.4 238.9 17.02 16.21 14 1.216 4136K 7100 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.7 10.54 9.39 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): 11.9 total, 11.7 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: 7.66 GB write, 658.34 MB/s write, 3.98 GB read, 341.81 MB/s read, 27.6 seconds Interval compaction: 7.66 GB write, 670.26 MB/s write, 3.98 GB read, 348.00 MB/s read, 27.6 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 11, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 11, interval: 11 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 944490 Average: 2.1481 StdDev: 13.58 Min: 0 Median: 1.4659 Max: 4759 Percentiles: P50: 1.47 P75: 1.84 P99: 5.44 P99.9: 9.41 P99.99: 14.15 ------------------------------------------------------ [ 0, 1 ] 178532 18.902% 18.902% #### ( 1, 2 ] 630400 66.745% 85.647% ############# ( 2, 3 ] 86216 9.128% 94.776% ## ( 3, 4 ] 26539 2.810% 97.586% # ( 4, 6 ] 18612 1.971% 99.556% ( 6, 10 ] 3813 0.404% 99.960% ( 10, 15 ] 342 0.036% 99.996% ( 15, 22 ] 66 0.007% 100.003% ( 22, 34 ] 11 0.001% 100.004% ( 34, 51 ] 13 0.001% 100.006% ( 51, 76 ] 7 0.001% 100.006% ( 76, 110 ] 1 0.000% 100.007% ( 110, 170 ] 24 0.003% 100.009% ( 170, 250 ] 20 0.002% 100.011% ( 250, 380 ] 17 0.002% 100.013% ( 380, 580 ] 14 0.001% 100.015% ( 580, 870 ] 13 0.001% 100.016% ( 870, 1300 ] 17 0.002% 100.018% ( 1300, 1900 ] 5 0.001% 100.018% ( 1900, 2900 ] 4 0.000% 100.019% ( 2900, 4400 ] 7 0.001% 100.019% ( 4400, 6600 ] 1 0.000% 100.019% ** Level 1 read latency histogram (micros): Count: 63977 Average: 2.5022 StdDev: 21.13 Min: 1 Median: 1.5395 Max: 2357 Percentiles: P50: 1.54 P75: 1.90 P99: 5.48 P99.9: 9.75 P99.99: 1265.80 ------------------------------------------------------ [ 0, 1 ] 8027 12.547% 12.547% ### ( 1, 2 ] 44416 69.425% 81.972% ############## ( 2, 3 ] 7760 12.129% 94.101% ## ( 3, 4 ] 2052 3.207% 97.308% # ( 4, 6 ] 1462 2.285% 99.594% ( 6, 10 ] 209 0.327% 99.920% ( 10, 15 ] 19 0.030% 99.950% ( 15, 22 ] 4 0.006% 99.956% ( 22, 34 ] 1 0.002% 99.958% ( 110, 170 ] 1 0.002% 99.959% ( 170, 250 ] 1 0.002% 99.961% ( 250, 380 ] 4 0.006% 99.967% ( 380, 580 ] 9 0.014% 99.981% ( 580, 870 ] 1 0.002% 99.983% ( 870, 1300 ] 5 0.008% 99.991% ( 1300, 1900 ] 3 0.005% 99.995% ( 1900, 2900 ] 3 0.005% 100.000% ** Level 2 read latency histogram (micros): Count: 47966 Average: 2.2858 StdDev: 6.65 Min: 0 Median: 1.5436 Max: 1107 Percentiles: P50: 1.54 P75: 1.92 P99: 5.96 P99.9: 11.81 P99.99: 30.81 ------------------------------------------------------ [ 0, 1 ] 6446 13.439% 13.439% ### ( 1, 2 ] 32263 67.262% 80.701% ############# ( 2, 3 ] 5172 10.783% 91.484% ## ( 3, 4 ] 2095 4.368% 95.851% # ( 4, 6 ] 1541 3.213% 99.064% # ( 6, 10 ] 380 0.792% 99.856% ( 10, 15 ] 58 0.121% 99.977% ( 15, 22 ] 4 0.008% 99.985% ( 22, 34 ] 3 0.006% 99.992% ( 34, 51 ] 1 0.002% 99.994% ( 170, 250 ] 1 0.002% 99.996% ( 380, 580 ] 2 0.004% 100.000% ( 580, 870 ] 1 0.002% 100.002% ( 870, 1300 ] 1 0.002% 100.004% ** Level 3 read latency histogram (micros): Count: 42875 Average: 6.3074 StdDev: 178.12 Min: 0 Median: 1.5130 Max: 12842 Percentiles: P50: 1.51 P75: 1.87 P99: 5.91 P99.9: 873.58 P99.99: 11802.66 ------------------------------------------------------ [ 0, 1 ] 6144 14.330% 14.330% ### ( 1, 2 ] 29811 69.530% 83.860% ############## ( 2, 3 ] 4836 11.279% 95.139% ## ( 3, 4 ] 831 1.938% 97.078% ( 4, 6 ] 863 2.013% 99.090% ( 6, 10 ] 290 0.676% 99.767% ( 10, 15 ] 39 0.091% 99.858% ( 15, 22 ] 8 0.019% 99.876% ( 22, 34 ] 2 0.005% 99.881% ( 51, 76 ] 1 0.002% 99.883% ( 76, 110 ] 1 0.002% 99.886% ( 110, 170 ] 1 0.002% 99.888% ( 250, 380 ] 1 0.002% 99.890% ( 380, 580 ] 1 0.002% 99.893% ( 580, 870 ] 3 0.007% 99.900% ( 870, 1300 ] 15 0.035% 99.935% ( 1300, 1900 ] 7 0.016% 99.951% ( 1900, 2900 ] 3 0.007% 99.958% ( 2900, 4400 ] 4 0.009% 99.967% ( 4400, 6600 ] 2 0.005% 99.972% ( 6600, 9900 ] 4 0.009% 99.981% ( 9900, 14000 ] 8 0.019% 100.000% ** Level 4 read latency histogram (micros): Count: 320 Average: 426.5938 StdDev: 1748.64 Min: 1 Median: 1.9709 Max: 11199 Percentiles: P50: 1.97 P75: 6.42 P99: 11199.00 P99.9: 11199.00 P99.99: 11199.00 ------------------------------------------------------ [ 0, 1 ] 60 18.750% 18.750% #### ( 1, 2 ] 103 32.188% 50.938% ###### ( 2, 3 ] 54 16.875% 67.812% ### ( 3, 4 ] 9 2.812% 70.625% # ( 4, 6 ] 12 3.750% 74.375% # ( 6, 10 ] 19 5.938% 80.312% # ( 10, 15 ] 26 8.125% 88.438% ## ( 15, 22 ] 5 1.562% 90.000% ( 110, 170 ] 1 0.312% 90.312% ( 170, 250 ] 1 0.312% 90.625% ( 870, 1300 ] 4 1.250% 91.875% ( 1300, 1900 ] 10 3.125% 95.000% # ( 1900, 2900 ] 4 1.250% 96.250% ( 4400, 6600 ] 2 0.625% 96.875% ( 6600, 9900 ] 4 1.250% 98.125% ( 9900, 14000 ] 6 1.875% 100.000% ** Level 5 read latency histogram (micros): Count: 40 Average: 851.6000 StdDev: 1103.22 Min: 81 Median: 250.0000 Max: 3959 Percentiles: P50: 250.00 P75: 1013.33 P99: 3959.00 P99.9: 3959.00 P99.99: 3959.00 ------------------------------------------------------ ( 76, 110 ] 5 12.500% 12.500% ### ( 110, 170 ] 14 35.000% 47.500% ####### ( 170, 250 ] 1 2.500% 50.000% # ( 250, 380 ] 1 2.500% 52.500% # ( 380, 580 ] 1 2.500% 55.000% # ( 580, 870 ] 7 17.500% 72.500% #### ( 870, 1300 ] 3 7.500% 80.000% ## ( 1300, 1900 ] 2 5.000% 85.000% # ( 1900, 2900 ] 3 7.500% 92.500% ## ( 2900, 4400 ] 3 7.500% 100.000% ## ** DB Stats ** Uptime(secs): 11.9 total, 2.9 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 330.31 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.346 H:M:S, 11.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 335.11 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.350 H:M:S, 11.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/18-19:13:51 ... thread 0: (1000000,5000000) ops and (335760.5,340526.2) ops/second in (2.978313,14.683159) 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/15 3.50 GB 12.6 3.3 0.0 3.3 8.0 4.7 0.0 1.7 129.2 310.9 26.33 24.62 79 0.333 3454K 3713 0.0 0.0 L1 5/5 485.75 MB 0.0 1.2 1.0 0.2 1.2 1.0 0.2 1.2 233.9 233.0 5.38 5.23 2 2.688 1276K 4556 0.0 0.0 L2 1/0 3.75 MB 0.0 0.2 0.1 0.1 0.2 0.1 0.7 1.5 235.7 235.5 0.82 0.78 2 0.409 195K 86 0.0 0.0 L3 13/0 708.01 MB 0.7 0.2 0.2 0.0 0.2 0.2 0.6 1.0 218.8 218.8 0.86 0.79 1 0.856 190K 0 0.0 0.0 L4 174/0 9.70 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.7 1.0 138.1 138.1 1.22 0.86 1 1.221 171K 0 0.0 0.0 L5 1052/0 86.43 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 1262/20 100.80 GB 0.0 5.1 1.5 3.6 9.8 6.1 2.8 2.1 150.5 288.6 34.60 32.28 85 0.407 5287K 8355 0.0 0.0 Int 0/0 0.00 KB 0.0 5.1 1.5 3.6 9.8 6.1 2.7 2.1 150.5 288.6 34.60 32.28 85 0.407 5287K 8355 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.1 1.5 3.6 5.1 1.4 0.0 0.0 244.9 244.5 21.27 20.39 18 1.181 5287K 8355 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.1 13.33 11.89 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): 14.9 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: 9.75 GB write, 670.41 MB/s write, 5.09 GB read, 349.59 MB/s read, 34.6 seconds Interval compaction: 9.75 GB write, 680.09 MB/s write, 5.09 GB read, 354.64 MB/s read, 34.6 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 15, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 15, interval: 15 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1187759 Average: 2.1524 StdDev: 13.81 Min: 0 Median: 1.4538 Max: 4759 Percentiles: P50: 1.45 P75: 1.83 P99: 5.36 P99.9: 9.50 P99.99: 84.28 ------------------------------------------------------ [ 0, 1 ] 233341 19.645% 19.645% #### ( 1, 2 ] 794549 66.895% 86.540% ############# ( 2, 3 ] 101764 8.568% 95.108% ## ( 3, 4 ] 31666 2.666% 97.774% # ( 4, 6 ] 21406 1.802% 99.576% ( 6, 10 ] 4394 0.370% 99.946% ( 10, 15 ] 385 0.032% 99.979% ( 15, 22 ] 90 0.008% 99.986% ( 22, 34 ] 14 0.001% 99.987% ( 34, 51 ] 13 0.001% 99.988% ( 51, 76 ] 9 0.001% 99.989% ( 76, 110 ] 42 0.004% 99.993% ( 110, 170 ] 110 0.009% 100.002% ( 170, 250 ] 48 0.004% 100.006% ( 250, 380 ] 31 0.003% 100.009% ( 380, 580 ] 29 0.002% 100.011% ( 580, 870 ] 24 0.002% 100.013% ( 870, 1300 ] 23 0.002% 100.015% ( 1300, 1900 ] 7 0.001% 100.016% ( 1900, 2900 ] 5 0.000% 100.016% ( 2900, 4400 ] 7 0.001% 100.017% ( 4400, 6600 ] 2 0.000% 100.017% ** Level 1 read latency histogram (micros): Count: 63978 Average: 2.5050 StdDev: 21.15 Min: 1 Median: 1.5395 Max: 2357 Percentiles: P50: 1.54 P75: 1.90 P99: 5.48 P99.9: 9.77 P99.99: 1265.79 ------------------------------------------------------ [ 0, 1 ] 8027 12.547% 12.547% ### ( 1, 2 ] 44416 69.424% 81.970% ############## ( 2, 3 ] 7760 12.129% 94.100% ## ( 3, 4 ] 2052 3.207% 97.307% # ( 4, 6 ] 1462 2.285% 99.592% ( 6, 10 ] 209 0.327% 99.919% ( 10, 15 ] 19 0.030% 99.948% ( 15, 22 ] 4 0.006% 99.955% ( 22, 34 ] 1 0.002% 99.956% ( 110, 170 ] 1 0.002% 99.958% ( 170, 250 ] 2 0.003% 99.961% ( 250, 380 ] 4 0.006% 99.967% ( 380, 580 ] 9 0.014% 99.981% ( 580, 870 ] 1 0.002% 99.983% ( 870, 1300 ] 5 0.008% 99.991% ( 1300, 1900 ] 3 0.005% 99.995% ( 1900, 2900 ] 3 0.005% 100.000% ** Level 2 read latency histogram (micros): Count: 47966 Average: 2.2858 StdDev: 6.65 Min: 0 Median: 1.5436 Max: 1107 Percentiles: P50: 1.54 P75: 1.92 P99: 5.96 P99.9: 11.81 P99.99: 30.81 ------------------------------------------------------ [ 0, 1 ] 6446 13.439% 13.439% ### ( 1, 2 ] 32263 67.262% 80.701% ############# ( 2, 3 ] 5172 10.783% 91.484% ## ( 3, 4 ] 2095 4.368% 95.851% # ( 4, 6 ] 1541 3.213% 99.064% # ( 6, 10 ] 380 0.792% 99.856% ( 10, 15 ] 58 0.121% 99.977% ( 15, 22 ] 4 0.008% 99.985% ( 22, 34 ] 3 0.006% 99.992% ( 34, 51 ] 1 0.002% 99.994% ( 170, 250 ] 1 0.002% 99.996% ( 380, 580 ] 2 0.004% 100.000% ( 580, 870 ] 1 0.002% 100.002% ( 870, 1300 ] 1 0.002% 100.004% ** Level 3 read latency histogram (micros): Count: 42875 Average: 6.3074 StdDev: 178.12 Min: 0 Median: 1.5130 Max: 12842 Percentiles: P50: 1.51 P75: 1.87 P99: 5.91 P99.9: 873.58 P99.99: 11802.66 ------------------------------------------------------ [ 0, 1 ] 6144 14.330% 14.330% ### ( 1, 2 ] 29811 69.530% 83.860% ############## ( 2, 3 ] 4836 11.279% 95.139% ## ( 3, 4 ] 831 1.938% 97.078% ( 4, 6 ] 863 2.013% 99.090% ( 6, 10 ] 290 0.676% 99.767% ( 10, 15 ] 39 0.091% 99.858% ( 15, 22 ] 8 0.019% 99.876% ( 22, 34 ] 2 0.005% 99.881% ( 51, 76 ] 1 0.002% 99.883% ( 76, 110 ] 1 0.002% 99.886% ( 110, 170 ] 1 0.002% 99.888% ( 250, 380 ] 1 0.002% 99.890% ( 380, 580 ] 1 0.002% 99.893% ( 580, 870 ] 3 0.007% 99.900% ( 870, 1300 ] 15 0.035% 99.935% ( 1300, 1900 ] 7 0.016% 99.951% ( 1900, 2900 ] 3 0.007% 99.958% ( 2900, 4400 ] 4 0.009% 99.967% ( 4400, 6600 ] 2 0.005% 99.972% ( 6600, 9900 ] 4 0.009% 99.981% ( 9900, 14000 ] 8 0.019% 100.000% ** Level 4 read latency histogram (micros): Count: 320 Average: 426.5938 StdDev: 1748.64 Min: 1 Median: 1.9709 Max: 11199 Percentiles: P50: 1.97 P75: 6.42 P99: 11199.00 P99.9: 11199.00 P99.99: 11199.00 ------------------------------------------------------ [ 0, 1 ] 60 18.750% 18.750% #### ( 1, 2 ] 103 32.188% 50.938% ###### ( 2, 3 ] 54 16.875% 67.812% ### ( 3, 4 ] 9 2.812% 70.625% # ( 4, 6 ] 12 3.750% 74.375% # ( 6, 10 ] 19 5.938% 80.312% # ( 10, 15 ] 26 8.125% 88.438% ## ( 15, 22 ] 5 1.562% 90.000% ( 110, 170 ] 1 0.312% 90.312% ( 170, 250 ] 1 0.312% 90.625% ( 870, 1300 ] 4 1.250% 91.875% ( 1300, 1900 ] 10 3.125% 95.000% # ( 1900, 2900 ] 4 1.250% 96.250% ( 4400, 6600 ] 2 0.625% 96.875% ( 6600, 9900 ] 4 1.250% 98.125% ( 9900, 14000 ] 6 1.875% 100.000% ** Level 5 read latency histogram (micros): Count: 40 Average: 851.6000 StdDev: 1103.22 Min: 81 Median: 250.0000 Max: 3959 Percentiles: P50: 250.00 P75: 1013.33 P99: 3959.00 P99.9: 3959.00 P99.99: 3959.00 ------------------------------------------------------ ( 76, 110 ] 5 12.500% 12.500% ### ( 110, 170 ] 14 35.000% 47.500% ####### ( 170, 250 ] 1 2.500% 50.000% # ( 250, 380 ] 1 2.500% 52.500% # ( 380, 580 ] 1 2.500% 55.000% # ( 580, 870 ] 7 17.500% 72.500% #### ( 870, 1300 ] 3 7.500% 80.000% ## ( 1300, 1900 ] 2 5.000% 85.000% # ( 1900, 2900 ] 3 7.500% 92.500% ## ( 2900, 4400 ] 3 7.500% 100.000% ## ** DB Stats ** Uptime(secs): 14.9 total, 3.0 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 330.34 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.735 H:M:S, 11.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 330.45 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.389 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/18-19:14:09 ... thread 0: (1000000,6000000) ops and (55619.9,183697.8) ops/second in (17.979185,32.662344) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 18/15 4.54 GB 119.1 5.4 0.0 5.4 11.1 5.7 0.0 1.9 146.1 300.3 37.93 35.29 100 0.379 5627K 9257 0.0 0.0 L1 5/5 485.75 MB 0.0 1.2 1.0 0.2 1.2 1.0 0.2 1.2 233.9 233.0 5.38 5.23 2 2.688 1276K 4556 0.0 0.0 L2 1/0 3.75 MB 0.0 0.2 0.1 0.1 0.2 0.1 0.7 1.5 235.7 235.5 0.82 0.78 2 0.409 195K 86 0.0 0.0 L3 13/0 708.01 MB 0.7 0.2 0.2 0.0 0.2 0.2 0.6 1.0 218.8 218.8 0.86 0.79 1 0.856 190K 0 0.0 0.0 L4 174/0 9.70 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.7 1.0 138.1 138.1 1.22 0.86 1 1.221 171K 0 0.0 0.0 L5 1052/0 86.43 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/20 101.84 GB 0.0 7.2 1.5 5.7 12.9 7.2 2.8 2.3 159.1 285.6 46.20 42.95 106 0.436 7461K 13K 0.0 0.0 Int 0/0 0.00 KB 0.0 7.2 1.5 5.7 12.9 7.2 2.7 2.3 159.1 285.6 46.20 42.95 106 0.436 7461K 13K 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.2 1.5 5.7 7.2 1.4 0.0 0.0 245.5 245.1 29.93 28.44 23 1.301 7461K 13K 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 360.0 16.27 14.51 83 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): 32.9 total, 32.7 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.88 GB write, 401.30 MB/s write, 7.18 GB read, 223.52 MB/s read, 46.2 seconds Interval compaction: 12.88 GB write, 403.90 MB/s write, 7.18 GB read, 224.97 MB/s read, 46.2 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: 16, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 12, total-stops: 16, interval: 28 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2566468 Average: 2.8697 StdDev: 18.70 Min: 0 Median: 1.4535 Max: 4759 Percentiles: P50: 1.45 P75: 1.83 P99: 7.26 P99.9: 168.42 P99.99: 441.50 ------------------------------------------------------ [ 0, 1 ] 503358 19.613% 19.613% #### ( 1, 2 ] 1719729 67.008% 86.620% ############# ( 2, 3 ] 203593 7.933% 94.553% ## ( 3, 4 ] 64660 2.519% 97.073% # ( 4, 6 ] 43660 1.701% 98.774% ( 6, 10 ] 18359 0.715% 99.489% ( 10, 15 ] 1225 0.048% 99.537% ( 15, 22 ] 477 0.019% 99.556% ( 22, 34 ] 31 0.001% 99.557% ( 34, 51 ] 18 0.001% 99.557% ( 51, 76 ] 106 0.004% 99.562% ( 76, 110 ] 2889 0.113% 99.674% ( 110, 170 ] 5953 0.232% 99.906% ( 170, 250 ] 1242 0.048% 99.954% ( 250, 380 ] 753 0.029% 99.984% ( 380, 580 ] 515 0.020% 100.004% ( 580, 870 ] 208 0.008% 100.012% ( 870, 1300 ] 59 0.002% 100.014% ( 1300, 1900 ] 17 0.001% 100.015% ( 1900, 2900 ] 18 0.001% 100.016% ( 2900, 4400 ] 14 0.001% 100.016% ( 4400, 6600 ] 2 0.000% 100.016% ** Level 1 read latency histogram (micros): Count: 181351 Average: 2.9871 StdDev: 17.83 Min: 1 Median: 1.4707 Max: 2357 Percentiles: P50: 1.47 P75: 1.86 P99: 8.80 P99.9: 167.38 P99.99: 722.20 ------------------------------------------------------ [ 0, 1 ] 35343 19.489% 19.489% #### ( 1, 2 ] 117549 64.819% 84.307% ############# ( 2, 3 ] 15200 8.382% 92.689% ## ( 3, 4 ] 5568 3.070% 95.759% # ( 4, 6 ] 4434 2.445% 98.204% ( 6, 10 ] 2063 1.138% 99.342% ( 10, 15 ] 150 0.083% 99.424% ( 15, 22 ] 79 0.044% 99.468% ( 22, 34 ] 2 0.001% 99.469% ( 76, 110 ] 379 0.209% 99.678% ( 110, 170 ] 421 0.232% 99.910% ( 170, 250 ] 62 0.034% 99.944% ( 250, 380 ] 38 0.021% 99.965% ( 380, 580 ] 38 0.021% 99.986% ( 580, 870 ] 14 0.008% 99.994% ( 870, 1300 ] 5 0.003% 99.997% ( 1300, 1900 ] 3 0.002% 99.998% ( 1900, 2900 ] 3 0.002% 100.000% ** Level 2 read latency histogram (micros): Count: 47966 Average: 2.2858 StdDev: 6.65 Min: 0 Median: 1.5436 Max: 1107 Percentiles: P50: 1.54 P75: 1.92 P99: 5.96 P99.9: 11.81 P99.99: 30.81 ------------------------------------------------------ [ 0, 1 ] 6446 13.439% 13.439% ### ( 1, 2 ] 32263 67.262% 80.701% ############# ( 2, 3 ] 5172 10.783% 91.484% ## ( 3, 4 ] 2095 4.368% 95.851% # ( 4, 6 ] 1541 3.213% 99.064% # ( 6, 10 ] 380 0.792% 99.856% ( 10, 15 ] 58 0.121% 99.977% ( 15, 22 ] 4 0.008% 99.985% ( 22, 34 ] 3 0.006% 99.992% ( 34, 51 ] 1 0.002% 99.994% ( 170, 250 ] 1 0.002% 99.996% ( 380, 580 ] 2 0.004% 100.000% ( 580, 870 ] 1 0.002% 100.002% ( 870, 1300 ] 1 0.002% 100.004% ** Level 3 read latency histogram (micros): Count: 42875 Average: 6.3074 StdDev: 178.12 Min: 0 Median: 1.5130 Max: 12842 Percentiles: P50: 1.51 P75: 1.87 P99: 5.91 P99.9: 873.58 P99.99: 11802.66 ------------------------------------------------------ [ 0, 1 ] 6144 14.330% 14.330% ### ( 1, 2 ] 29811 69.530% 83.860% ############## ( 2, 3 ] 4836 11.279% 95.139% ## ( 3, 4 ] 831 1.938% 97.078% ( 4, 6 ] 863 2.013% 99.090% ( 6, 10 ] 290 0.676% 99.767% ( 10, 15 ] 39 0.091% 99.858% ( 15, 22 ] 8 0.019% 99.876% ( 22, 34 ] 2 0.005% 99.881% ( 51, 76 ] 1 0.002% 99.883% ( 76, 110 ] 1 0.002% 99.886% ( 110, 170 ] 1 0.002% 99.888% ( 250, 380 ] 1 0.002% 99.890% ( 380, 580 ] 1 0.002% 99.893% ( 580, 870 ] 3 0.007% 99.900% ( 870, 1300 ] 15 0.035% 99.935% ( 1300, 1900 ] 7 0.016% 99.951% ( 1900, 2900 ] 3 0.007% 99.958% ( 2900, 4400 ] 4 0.009% 99.967% ( 4400, 6600 ] 2 0.005% 99.972% ( 6600, 9900 ] 4 0.009% 99.981% ( 9900, 14000 ] 8 0.019% 100.000% ** Level 4 read latency histogram (micros): Count: 320 Average: 426.5938 StdDev: 1748.64 Min: 1 Median: 1.9709 Max: 11199 Percentiles: P50: 1.97 P75: 6.42 P99: 11199.00 P99.9: 11199.00 P99.99: 11199.00 ------------------------------------------------------ [ 0, 1 ] 60 18.750% 18.750% #### ( 1, 2 ] 103 32.188% 50.938% ###### ( 2, 3 ] 54 16.875% 67.812% ### ( 3, 4 ] 9 2.812% 70.625% # ( 4, 6 ] 12 3.750% 74.375% # ( 6, 10 ] 19 5.938% 80.312% # ( 10, 15 ] 26 8.125% 88.438% ## ( 15, 22 ] 5 1.562% 90.000% ( 110, 170 ] 1 0.312% 90.312% ( 170, 250 ] 1 0.312% 90.625% ( 870, 1300 ] 4 1.250% 91.875% ( 1300, 1900 ] 10 3.125% 95.000% # ( 1900, 2900 ] 4 1.250% 96.250% ( 4400, 6600 ] 2 0.625% 96.875% ( 6600, 9900 ] 4 1.250% 98.125% ( 9900, 14000 ] 6 1.875% 100.000% ** Level 5 read latency histogram (micros): Count: 40 Average: 851.6000 StdDev: 1103.22 Min: 81 Median: 250.0000 Max: 3959 Percentiles: P50: 250.00 P75: 1013.33 P99: 3959.00 P99.9: 3959.00 P99.99: 3959.00 ------------------------------------------------------ ( 76, 110 ] 5 12.500% 12.500% ### ( 110, 170 ] 14 35.000% 47.500% ####### ( 170, 250 ] 1 2.500% 50.000% # ( 250, 380 ] 1 2.500% 52.500% # ( 380, 580 ] 1 2.500% 55.000% # ( 580, 870 ] 7 17.500% 72.500% #### ( 870, 1300 ] 3 7.500% 80.000% ## ( 1300, 1900 ] 2 5.000% 85.000% # ( 1900, 2900 ] 3 7.500% 92.500% ## ( 2900, 4400 ] 3 7.500% 100.000% ## ** DB Stats ** Uptime(secs): 32.9 total, 18.0 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 179.62 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:16.655 H:M:S, 50.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 54.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:14.920 H:M:S, 83.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 0 2024/11/18-19:14:15 ... thread 0: (1000000,7000000) ops and (177803.0,182831.8) ops/second in (5.624203,38.286547) 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/4 2.02 GB 62.9 6.0 0.0 6.0 12.6 6.6 0.0 1.9 132.9 277.8 46.45 40.38 113 0.411 6267K 10K 0.0 0.0 L1 8/8 783.01 MB 0.0 5.1 4.4 0.7 5.0 4.3 0.2 1.1 214.4 211.2 24.27 22.38 3 8.091 5284K 77K 0.0 0.0 L2 3/3 386.34 MB 0.0 0.2 0.1 0.1 0.2 0.1 3.7 1.5 235.7 235.5 0.82 0.78 2 0.409 195K 86 0.0 0.0 L3 24/9 1.47 GB 1.0 2.3 1.6 0.7 2.3 1.6 1.9 1.5 147.8 146.9 15.93 11.04 7 2.276 2392K 15K 0.0 0.0 L4 183/11 10.26 GB 1.0 2.1 2.0 0.1 2.1 2.0 0.7 1.0 123.5 123.3 17.06 9.98 24 0.711 2074K 1287 0.0 0.0 L5 1068/0 87.72 GB 0.9 0.0 0.0 0.0 0.0 0.0 2.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1294/35 102.62 GB 0.0 15.7 8.0 7.6 22.1 14.5 8.4 3.4 153.4 216.8 104.53 84.55 149 0.702 16M 104K 0.0 0.0 Int 0/0 0.00 KB 0.0 15.7 8.0 7.6 22.1 14.5 8.3 3.4 153.4 216.8 104.53 84.55 149 0.702 16M 104K 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 15.7 8.0 7.6 15.6 7.9 0.0 0.0 192.6 191.3 83.23 67.62 55 1.513 16M 104K 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.5 21.30 16.93 94 0.227 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): 38.5 total, 38.3 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.13 GB write, 588.73 MB/s write, 15.66 GB read, 416.42 MB/s read, 104.5 seconds Interval compaction: 22.13 GB write, 591.99 MB/s write, 15.66 GB read, 418.72 MB/s read, 104.5 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 14, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 14, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 40, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 14, total-stops: 40, interval: 54 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2881078 Average: 3.1683 StdDev: 38.08 Min: 0 Median: 1.4940 Max: 17357 Percentiles: P50: 1.49 P75: 1.88 P99: 7.91 P99.9: 169.28 P99.99: 529.00 ------------------------------------------------------ [ 0, 1 ] 517425 17.959% 17.959% #### ( 1, 2 ] 1868658 64.860% 82.819% ############# ( 2, 3 ] 278057 9.651% 92.470% ## ( 3, 4 ] 92913 3.225% 95.695% # ( 4, 6 ] 82612 2.867% 98.563% # ( 6, 10 ] 26342 0.914% 99.477% ( 10, 15 ] 2589 0.090% 99.567% ( 15, 22 ] 561 0.019% 99.586% ( 22, 34 ] 42 0.001% 99.588% ( 34, 51 ] 22 0.001% 99.588% ( 51, 76 ] 111 0.004% 99.592% ( 76, 110 ] 2916 0.101% 99.694% ( 110, 170 ] 6022 0.209% 99.903% ( 170, 250 ] 1291 0.045% 99.947% ( 250, 380 ] 806 0.028% 99.975% ( 380, 580 ] 569 0.020% 99.995% ( 580, 870 ] 262 0.009% 100.004% ( 870, 1300 ] 105 0.004% 100.008% ( 1300, 1900 ] 62 0.002% 100.010% ( 1900, 2900 ] 66 0.002% 100.012% ( 2900, 4400 ] 80 0.003% 100.015% ( 4400, 6600 ] 31 0.001% 100.016% ( 6600, 9900 ] 7 0.000% 100.016% ( 9900, 14000 ] 1 0.000% 100.016% ( 14000, 22000 ] 2 0.000% 100.016% ** Level 1 read latency histogram (micros): Count: 932016 Average: 6.8517 StdDev: 117.68 Min: 1 Median: 1.8900 Max: 21393 Percentiles: P50: 1.89 P75: 2.88 P99: 9.62 P99.9: 183.28 P99.99: 524.23 ------------------------------------------------------ [ 0, 1 ] 48040 5.154% 5.154% # ( 1, 2 ] 469641 50.390% 55.544% ########## ( 2, 3 ] 206173 22.121% 77.665% #### ( 3, 4 ] 80581 8.646% 86.311% ## ( 4, 6 ] 97598 10.472% 96.783% ## ( 6, 10 ] 22837 2.450% 99.233% ( 10, 15 ] 4581 0.492% 99.725% ( 15, 22 ] 488 0.052% 99.777% ( 22, 34 ] 52 0.006% 99.783% ( 34, 51 ] 8 0.001% 99.784% ( 51, 76 ] 11 0.001% 99.785% ( 76, 110 ] 419 0.045% 99.830% ( 110, 170 ] 614 0.066% 99.896% ( 170, 250 ] 253 0.027% 99.923% ( 250, 380 ] 348 0.037% 99.960% ( 380, 580 ] 388 0.042% 100.002% ( 580, 870 ] 413 0.044% 100.046% ( 870, 1300 ] 299 0.032% 100.078% ( 1300, 1900 ] 186 0.020% 100.098% ( 1900, 2900 ] 232 0.025% 100.123% ( 2900, 4400 ] 252 0.027% 100.150% ( 4400, 6600 ] 75 0.008% 100.158% ( 6600, 9900 ] 40 0.004% 100.162% ( 9900, 14000 ] 6 0.001% 100.163% ( 14000, 22000 ] 6 0.001% 100.164% ** Level 2 read latency histogram (micros): Count: 48919 Average: 2.7686 StdDev: 20.03 Min: 0 Median: 1.5485 Max: 2401 Percentiles: P50: 1.55 P75: 1.92 P99: 6.48 P99.9: 191.15 P99.99: 732.84 ------------------------------------------------------ [ 0, 1 ] 6492 13.271% 13.271% ### ( 1, 2 ] 32759 66.966% 80.237% ############# ( 2, 3 ] 5387 11.012% 91.249% ## ( 3, 4 ] 2157 4.409% 95.658% # ( 4, 6 ] 1587 3.244% 98.902% # ( 6, 10 ] 396 0.810% 99.712% ( 10, 15 ] 63 0.129% 99.841% ( 15, 22 ] 6 0.012% 99.853% ( 22, 34 ] 4 0.008% 99.861% ( 34, 51 ] 1 0.002% 99.863% ( 76, 110 ] 2 0.004% 99.867% ( 110, 170 ] 10 0.020% 99.888% ( 170, 250 ] 23 0.047% 99.935% ( 250, 380 ] 12 0.025% 99.959% ( 380, 580 ] 13 0.027% 99.986% ( 580, 870 ] 4 0.008% 99.994% ( 870, 1300 ] 3 0.006% 100.000% ( 1900, 2900 ] 2 0.004% 100.004% ** Level 3 read latency histogram (micros): Count: 430020 Average: 5.5755 StdDev: 118.15 Min: 0 Median: 2.0694 Max: 35892 Percentiles: P50: 2.07 P75: 3.07 P99: 8.43 P99.9: 13.37 P99.99: 26.00 ------------------------------------------------------ [ 0, 1 ] 9205 2.141% 2.141% ( 1, 2 ] 198011 46.047% 48.188% ######### ( 2, 3 ] 112237 26.100% 74.288% ##### ( 3, 4 ] 44205 10.280% 84.568% ## ( 4, 6 ] 57068 13.271% 97.839% ### ( 6, 10 ] 8218 1.911% 99.750% ( 10, 15 ] 961 0.223% 99.973% ( 15, 22 ] 67 0.016% 99.989% ( 22, 34 ] 18 0.004% 99.993% ( 34, 51 ] 4 0.001% 99.994% ( 51, 76 ] 3 0.001% 99.995% ( 76, 110 ] 6 0.001% 99.996% ( 110, 170 ] 18 0.004% 100.000% ( 170, 250 ] 52 0.012% 100.012% ( 250, 380 ] 42 0.010% 100.022% ( 380, 580 ] 48 0.011% 100.033% ( 580, 870 ] 74 0.017% 100.050% ( 870, 1300 ] 80 0.019% 100.069% ( 1300, 1900 ] 44 0.010% 100.079% ( 1900, 2900 ] 58 0.013% 100.093% ( 2900, 4400 ] 100 0.023% 100.116% ( 4400, 6600 ] 18 0.004% 100.120% ( 6600, 9900 ] 11 0.003% 100.123% ( 9900, 14000 ] 10 0.002% 100.125% ( 14000, 22000 ] 1 0.000% 100.125% ( 33000, 50000 ] 1 0.000% 100.126% ** Level 4 read latency histogram (micros): Count: 25392 Average: 128.1829 StdDev: 663.77 Min: 1 Median: 2.2650 Max: 40292 Percentiles: P50: 2.27 P75: 3.65 P99: 3286.73 P99.9: 7628.13 P99.99: 13799.03 ------------------------------------------------------ [ 0, 1 ] 560 2.205% 2.205% ( 1, 2 ] 10502 41.359% 43.565% ######## ( 2, 3 ] 6166 24.283% 67.848% ##### ( 3, 4 ] 2811 11.070% 78.919% ## ( 4, 6 ] 2308 9.089% 88.008% ## ( 6, 10 ] 523 2.060% 90.068% ( 10, 15 ] 197 0.776% 90.844% ( 15, 22 ] 28 0.110% 90.954% ( 22, 34 ] 6 0.024% 90.977% ( 34, 51 ] 3 0.012% 90.989% ( 76, 110 ] 6 0.024% 91.013% ( 110, 170 ] 77 0.303% 91.316% ( 170, 250 ] 130 0.512% 91.828% ( 250, 380 ] 216 0.851% 92.679% ( 380, 580 ] 358 1.410% 94.089% ( 580, 870 ] 424 1.670% 95.759% ( 870, 1300 ] 348 1.371% 97.129% ( 1300, 1900 ] 243 0.957% 98.086% ( 1900, 2900 ] 180 0.709% 98.795% ( 2900, 4400 ] 202 0.796% 99.590% ( 4400, 6600 ] 73 0.287% 99.878% ( 6600, 9900 ] 18 0.071% 99.949% ( 9900, 14000 ] 11 0.043% 99.992% ( 14000, 22000 ] 2 0.008% 100.000% ( 33000, 50000 ] 1 0.004% 100.004% ** Level 5 read latency histogram (micros): Count: 133 Average: 1475.0526 StdDev: 1457.99 Min: 81 Median: 813.6111 Max: 5996 Percentiles: P50: 813.61 P75: 2297.06 P99: 5996.00 P99.9: 5996.00 P99.99: 5996.00 ------------------------------------------------------ ( 76, 110 ] 5 3.759% 3.759% # ( 110, 170 ] 15 11.278% 15.038% ## ( 170, 250 ] 3 2.256% 17.293% ( 250, 380 ] 14 10.526% 27.820% ## ( 380, 580 ] 15 11.278% 39.098% ## ( 580, 870 ] 18 13.534% 52.632% ### ( 870, 1300 ] 9 6.767% 59.398% # ( 1300, 1900 ] 14 10.526% 69.925% ## ( 1900, 2900 ] 17 12.782% 82.707% ### ( 2900, 4400 ] 16 12.030% 94.737% ## ( 4400, 6600 ] 7 5.263% 100.000% # ** DB Stats ** Uptime(secs): 38.5 total, 5.6 interval Cumulative writes: 0 writes, 7000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 6.73 GB, 178.94 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:19.204 H:M:S, 49.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 174.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:2.549 H:M:S, 45.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 9 num-running-flushes: 1 2024/11/18-19:14:19 ... thread 0: (1000000,8000000) ops and (267128.9,190340.0) ops/second in (3.743511,42.030058) 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/12 3.01 GB 106.9 6.7 0.0 6.7 14.3 7.6 0.0 1.9 129.7 275.8 52.95 45.92 128 0.414 6970K 10K 0.0 0.0 L1 8/8 783.01 MB 0.0 5.1 4.4 0.7 5.0 4.3 0.2 1.1 214.4 211.2 24.27 22.38 3 8.091 5284K 77K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.2 0.1 0.1 0.2 0.1 3.7 1.5 235.7 235.5 0.82 0.78 2 0.409 195K 86 0.0 0.0 L3 14/0 999.69 MB 1.0 3.0 1.9 1.0 3.0 1.9 1.9 1.5 146.0 145.1 20.99 14.48 10 2.099 3113K 18K 0.0 0.0 L4 177/0 9.46 GB 1.0 3.0 2.8 0.1 3.0 2.8 0.7 1.0 122.4 122.2 24.75 15.05 37 0.669 2997K 2396 0.0 0.0 L5 1088/0 89.38 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 1302/20 103.59 GB 0.0 17.9 9.3 8.7 25.4 16.7 10.1 3.4 148.3 210.0 123.79 98.60 180 0.688 18M 109K 0.0 0.0 Int 0/0 0.00 KB 0.0 17.9 9.3 8.7 25.4 16.7 10.0 3.4 148.3 210.0 123.79 98.60 180 0.688 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 17.9 9.3 8.7 17.8 9.2 0.0 0.0 185.4 184.2 99.04 79.02 73 1.357 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 313.2 24.74 19.58 107 0.231 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): 42.2 total, 42.0 interval Flush(GB): cumulative 7.567, interval 7.567 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.38 GB write, 615.33 MB/s write, 17.93 GB read, 434.57 MB/s read, 123.8 seconds Interval compaction: 25.38 GB write, 618.43 MB/s write, 17.93 GB read, 436.76 MB/s read, 123.8 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 14, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 14, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 52, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 14, total-stops: 52, interval: 66 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3285341 Average: 3.2483 StdDev: 54.86 Min: 0 Median: 1.5205 Max: 34416 Percentiles: P50: 1.52 P75: 1.91 P99: 7.89 P99.9: 165.45 P99.99: 498.14 ------------------------------------------------------ [ 0, 1 ] 543293 16.537% 16.537% ### ( 1, 2 ] 2112054 64.287% 80.824% ############# ( 2, 3 ] 360629 10.977% 91.801% ## ( 3, 4 ] 114360 3.481% 95.282% # ( 4, 6 ] 106957 3.256% 98.538% # ( 6, 10 ] 32107 0.977% 99.515% ( 10, 15 ] 3365 0.102% 99.617% ( 15, 22 ] 609 0.019% 99.636% ( 22, 34 ] 45 0.001% 99.637% ( 34, 51 ] 23 0.001% 99.638% ( 51, 76 ] 118 0.004% 99.641% ( 76, 110 ] 2918 0.089% 99.730% ( 110, 170 ] 6036 0.184% 99.914% ( 170, 250 ] 1312 0.040% 99.954% ( 250, 380 ] 836 0.025% 99.979% ( 380, 580 ] 595 0.018% 99.997% ( 580, 870 ] 309 0.009% 100.007% ( 870, 1300 ] 121 0.004% 100.011% ( 1300, 1900 ] 73 0.002% 100.013% ( 1900, 2900 ] 76 0.002% 100.015% ( 2900, 4400 ] 96 0.003% 100.018% ( 4400, 6600 ] 36 0.001% 100.019% ( 6600, 9900 ] 16 0.000% 100.020% ( 9900, 14000 ] 6 0.000% 100.020% ( 14000, 22000 ] 9 0.000% 100.020% ( 22000, 33000 ] 1 0.000% 100.020% ( 33000, 50000 ] 1 0.000% 100.020% ** Level 1 read latency histogram (micros): Count: 975340 Average: 6.9429 StdDev: 124.72 Min: 1 Median: 1.8909 Max: 21393 Percentiles: P50: 1.89 P75: 2.88 P99: 9.62 P99.9: 193.01 P99.99: 548.42 ------------------------------------------------------ [ 0, 1 ] 49305 5.055% 5.055% # ( 1, 2 ] 492054 50.449% 55.505% ########## ( 2, 3 ] 216696 22.217% 77.722% #### ( 3, 4 ] 83941 8.606% 86.328% ## ( 4, 6 ] 101964 10.454% 96.783% ## ( 6, 10 ] 23869 2.447% 99.230% ( 10, 15 ] 4807 0.493% 99.723% ( 15, 22 ] 502 0.051% 99.774% ( 22, 34 ] 52 0.005% 99.780% ( 34, 51 ] 8 0.001% 99.780% ( 51, 76 ] 12 0.001% 99.782% ( 76, 110 ] 435 0.045% 99.826% ( 110, 170 ] 644 0.066% 99.892% ( 170, 250 ] 263 0.027% 99.919% ( 250, 380 ] 357 0.037% 99.956% ( 380, 580 ] 396 0.041% 99.996% ( 580, 870 ] 418 0.043% 100.039% ( 870, 1300 ] 308 0.032% 100.071% ( 1300, 1900 ] 191 0.020% 100.090% ( 1900, 2900 ] 238 0.024% 100.115% ( 2900, 4400 ] 261 0.027% 100.142% ( 4400, 6600 ] 77 0.008% 100.149% ( 6600, 9900 ] 46 0.005% 100.154% ( 9900, 14000 ] 12 0.001% 100.155% ( 14000, 22000 ] 9 0.001% 100.156% ** Level 2 read latency histogram (micros): Count: 48919 Average: 2.7686 StdDev: 20.03 Min: 0 Median: 1.5485 Max: 2401 Percentiles: P50: 1.55 P75: 1.92 P99: 6.48 P99.9: 191.15 P99.99: 732.84 ------------------------------------------------------ [ 0, 1 ] 6492 13.271% 13.271% ### ( 1, 2 ] 32759 66.966% 80.237% ############# ( 2, 3 ] 5387 11.012% 91.249% ## ( 3, 4 ] 2157 4.409% 95.658% # ( 4, 6 ] 1587 3.244% 98.902% # ( 6, 10 ] 396 0.810% 99.712% ( 10, 15 ] 63 0.129% 99.841% ( 15, 22 ] 6 0.012% 99.853% ( 22, 34 ] 4 0.008% 99.861% ( 34, 51 ] 1 0.002% 99.863% ( 76, 110 ] 2 0.004% 99.867% ( 110, 170 ] 10 0.020% 99.888% ( 170, 250 ] 23 0.047% 99.935% ( 250, 380 ] 12 0.025% 99.959% ( 380, 580 ] 13 0.027% 99.986% ( 580, 870 ] 4 0.008% 99.994% ( 870, 1300 ] 3 0.006% 100.000% ( 1900, 2900 ] 2 0.004% 100.004% ** Level 3 read latency histogram (micros): Count: 683222 Average: 5.9238 StdDev: 138.02 Min: 0 Median: 2.0329 Max: 35892 Percentiles: P50: 2.03 P75: 2.99 P99: 8.53 P99.9: 13.59 P99.99: 30.34 ------------------------------------------------------ [ 0, 1 ] 13490 1.974% 1.974% ( 1, 2 ] 322237 47.164% 49.139% ######### ( 2, 3 ] 178666 26.151% 75.289% ##### ( 3, 4 ] 67881 9.935% 85.225% ## ( 4, 6 ] 85575 12.525% 97.750% ### ( 6, 10 ] 13490 1.974% 99.724% ( 10, 15 ] 1671 0.245% 99.969% ( 15, 22 ] 127 0.019% 99.988% ( 22, 34 ] 24 0.004% 99.991% ( 34, 51 ] 4 0.001% 99.992% ( 51, 76 ] 4 0.001% 99.992% ( 76, 110 ] 11 0.002% 99.994% ( 110, 170 ] 27 0.004% 99.998% ( 170, 250 ] 95 0.014% 100.012% ( 250, 380 ] 78 0.011% 100.023% ( 380, 580 ] 104 0.015% 100.038% ( 580, 870 ] 147 0.022% 100.060% ( 870, 1300 ] 133 0.019% 100.079% ( 1300, 1900 ] 70 0.010% 100.090% ( 1900, 2900 ] 88 0.013% 100.102% ( 2900, 4400 ] 128 0.019% 100.121% ( 4400, 6600 ] 30 0.004% 100.126% ( 6600, 9900 ] 39 0.006% 100.131% ( 9900, 14000 ] 16 0.002% 100.134% ( 14000, 22000 ] 10 0.001% 100.135% ( 22000, 33000 ] 2 0.000% 100.135% ( 33000, 50000 ] 1 0.000% 100.136% ** Level 4 read latency histogram (micros): Count: 34210 Average: 120.1413 StdDev: 644.02 Min: 1 Median: 2.2174 Max: 40292 Percentiles: P50: 2.22 P75: 3.58 P99: 3109.40 P99.9: 7969.50 P99.99: 15158.00 ------------------------------------------------------ [ 0, 1 ] 848 2.479% 2.479% ( 1, 2 ] 14467 42.289% 44.768% ######## ( 2, 3 ] 8233 24.066% 68.834% ##### ( 3, 4 ] 3665 10.713% 79.547% ## ( 4, 6 ] 2986 8.728% 88.275% ## ( 6, 10 ] 688 2.011% 90.286% ( 10, 15 ] 243 0.710% 90.997% ( 15, 22 ] 33 0.096% 91.093% ( 22, 34 ] 8 0.023% 91.117% ( 34, 51 ] 8 0.023% 91.140% ( 76, 110 ] 22 0.064% 91.204% ( 110, 170 ] 145 0.424% 91.628% ( 170, 250 ] 190 0.555% 92.184% ( 250, 380 ] 311 0.909% 93.093% ( 380, 580 ] 484 1.415% 94.507% ( 580, 870 ] 546 1.596% 96.103% ( 870, 1300 ] 447 1.307% 97.410% ( 1300, 1900 ] 294 0.859% 98.270% ( 1900, 2900 ] 215 0.628% 98.898% ( 2900, 4400 ] 250 0.731% 99.629% ( 4400, 6600 ] 82 0.240% 99.868% ( 6600, 9900 ] 26 0.076% 99.944% ( 9900, 14000 ] 15 0.044% 99.988% ( 14000, 22000 ] 4 0.012% 100.000% ( 33000, 50000 ] 1 0.003% 100.003% ** Level 5 read latency histogram (micros): Count: 220 Average: 1550.5091 StdDev: 1562.38 Min: 81 Median: 785.8065 Max: 6967 Percentiles: P50: 785.81 P75: 2542.86 P99: 6380.00 P99.9: 6967.00 P99.99: 6967.00 ------------------------------------------------------ ( 76, 110 ] 9 4.091% 4.091% # ( 110, 170 ] 20 9.091% 13.182% ## ( 170, 250 ] 12 5.455% 18.636% # ( 250, 380 ] 24 10.909% 29.545% ## ( 380, 580 ] 23 10.455% 40.000% ## ( 580, 870 ] 31 14.091% 54.091% ### ( 870, 1300 ] 10 4.545% 58.636% # ( 1300, 1900 ] 18 8.182% 66.818% ## ( 1900, 2900 ] 28 12.727% 79.545% ### ( 2900, 4400 ] 32 14.545% 94.091% ### ( 4400, 6600 ] 12 5.455% 99.545% # ( 6600, 9900 ] 1 0.455% 100.000% ** DB Stats ** Uptime(secs): 42.2 total, 3.7 interval Cumulative writes: 0 writes, 8000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 7.69 GB, 186.38 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.144 H:M:S, 47.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 262.90 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.940 H:M:S, 25.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/11/18-19:14:22 ... thread 0: (1000000,9000000) ops and (332221.1,199821.9) ops/second in (3.010044,45.040102) 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 16/8 3.93 GB 232.8 7.8 0.0 7.8 16.3 8.5 0.0 1.9 133.1 277.6 60.09 52.68 145 0.414 8122K 12K 0.0 0.0 L1 8/8 783.01 MB 0.0 5.1 4.4 0.7 5.0 4.3 0.2 1.1 214.4 211.2 24.27 22.38 3 8.091 5284K 77K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.2 0.1 0.1 0.2 0.1 3.7 1.5 235.7 235.5 0.82 0.78 2 0.409 195K 86 0.0 0.0 L3 14/0 999.69 MB 1.0 3.0 1.9 1.0 3.0 1.9 1.9 1.5 146.0 145.1 20.99 14.48 10 2.099 3113K 18K 0.0 0.0 L4 177/0 9.46 GB 1.0 3.0 2.8 0.1 3.0 2.8 0.7 1.0 122.4 122.2 24.75 15.05 37 0.669 2997K 2396 0.0 0.0 L5 1088/0 89.38 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 1303/16 104.51 GB 0.0 19.0 9.3 9.8 27.4 17.6 10.1 3.2 148.9 214.4 130.92 105.36 197 0.665 19M 111K 0.0 0.0 Int 0/0 0.00 KB 0.0 19.0 9.3 9.8 27.4 17.6 10.0 3.2 148.9 214.4 130.92 105.36 197 0.665 19M 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 19.0 9.3 9.8 18.9 9.2 0.0 0.0 188.3 187.2 103.51 83.41 77 1.344 19M 111K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 8.5 8.5 0.0 0.0 0.0 317.2 27.41 21.95 120 0.228 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): 45.3 total, 45.0 interval Flush(GB): cumulative 8.490, interval 8.490 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.41 GB write, 620.30 MB/s write, 19.03 GB read, 430.72 MB/s read, 130.9 seconds Interval compaction: 27.41 GB write, 623.22 MB/s write, 19.03 GB read, 432.75 MB/s read, 130.9 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 14, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 14, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 56, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 14, total-stops: 56, interval: 70 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3563563 Average: 3.1882 StdDev: 52.78 Min: 0 Median: 1.5268 Max: 34416 Percentiles: P50: 1.53 P75: 1.91 P99: 7.69 P99.9: 163.11 P99.99: 477.78 ------------------------------------------------------ [ 0, 1 ] 571860 16.047% 16.047% ### ( 1, 2 ] 2296894 64.455% 80.502% ############# ( 2, 3 ] 403514 11.323% 91.826% ## ( 3, 4 ] 124596 3.496% 95.322% # ( 4, 6 ] 116896 3.280% 98.602% # ( 6, 10 ] 33599 0.943% 99.545% ( 10, 15 ] 3500 0.098% 99.644% ( 15, 22 ] 627 0.018% 99.661% ( 22, 34 ] 50 0.001% 99.663% ( 34, 51 ] 27 0.001% 99.663% ( 51, 76 ] 118 0.003% 99.667% ( 76, 110 ] 2939 0.082% 99.749% ( 110, 170 ] 6080 0.171% 99.920% ( 170, 250 ] 1354 0.038% 99.958% ( 250, 380 ] 852 0.024% 99.982% ( 380, 580 ] 619 0.017% 99.999% ( 580, 870 ] 317 0.009% 100.008% ( 870, 1300 ] 131 0.004% 100.012% ( 1300, 1900 ] 76 0.002% 100.014% ( 1900, 2900 ] 77 0.002% 100.016% ( 2900, 4400 ] 96 0.003% 100.018% ( 4400, 6600 ] 36 0.001% 100.020% ( 6600, 9900 ] 16 0.000% 100.020% ( 9900, 14000 ] 6 0.000% 100.020% ( 14000, 22000 ] 9 0.000% 100.020% ( 22000, 33000 ] 1 0.000% 100.020% ( 33000, 50000 ] 1 0.000% 100.020% ** Level 1 read latency histogram (micros): Count: 1101073 Average: 6.4690 StdDev: 117.46 Min: 1 Median: 1.8549 Max: 21393 Percentiles: P50: 1.85 P75: 2.80 P99: 9.54 P99.9: 177.33 P99.99: 546.78 ------------------------------------------------------ [ 0, 1 ] 59032 5.361% 5.361% # ( 1, 2 ] 574947 52.217% 57.578% ########## ( 2, 3 ] 238332 21.645% 79.224% #### ( 3, 4 ] 87918 7.985% 87.208% ## ( 4, 6 ] 106779 9.698% 96.906% ## ( 6, 10 ] 26070 2.368% 99.274% ( 10, 15 ] 5020 0.456% 99.730% ( 15, 22 ] 516 0.047% 99.777% ( 22, 34 ] 52 0.005% 99.781% ( 34, 51 ] 8 0.001% 99.782% ( 51, 76 ] 16 0.001% 99.784% ( 76, 110 ] 540 0.049% 99.833% ( 110, 170 ] 716 0.065% 99.898% ( 170, 250 ] 294 0.027% 99.924% ( 250, 380 ] 377 0.034% 99.959% ( 380, 580 ] 416 0.038% 99.996% ( 580, 870 ] 423 0.038% 100.035% ( 870, 1300 ] 308 0.028% 100.063% ( 1300, 1900 ] 191 0.017% 100.080% ( 1900, 2900 ] 239 0.022% 100.102% ( 2900, 4400 ] 261 0.024% 100.126% ( 4400, 6600 ] 77 0.007% 100.133% ( 6600, 9900 ] 46 0.004% 100.137% ( 9900, 14000 ] 12 0.001% 100.138% ( 14000, 22000 ] 9 0.001% 100.139% ** Level 2 read latency histogram (micros): Count: 48919 Average: 2.7686 StdDev: 20.03 Min: 0 Median: 1.5485 Max: 2401 Percentiles: P50: 1.55 P75: 1.92 P99: 6.48 P99.9: 191.15 P99.99: 732.84 ------------------------------------------------------ [ 0, 1 ] 6492 13.271% 13.271% ### ( 1, 2 ] 32759 66.966% 80.237% ############# ( 2, 3 ] 5387 11.012% 91.249% ## ( 3, 4 ] 2157 4.409% 95.658% # ( 4, 6 ] 1587 3.244% 98.902% # ( 6, 10 ] 396 0.810% 99.712% ( 10, 15 ] 63 0.129% 99.841% ( 15, 22 ] 6 0.012% 99.853% ( 22, 34 ] 4 0.008% 99.861% ( 34, 51 ] 1 0.002% 99.863% ( 76, 110 ] 2 0.004% 99.867% ( 110, 170 ] 10 0.020% 99.888% ( 170, 250 ] 23 0.047% 99.935% ( 250, 380 ] 12 0.025% 99.959% ( 380, 580 ] 13 0.027% 99.986% ( 580, 870 ] 4 0.008% 99.994% ( 870, 1300 ] 3 0.006% 100.000% ( 1900, 2900 ] 2 0.004% 100.004% ** Level 3 read latency histogram (micros): Count: 683222 Average: 5.9238 StdDev: 138.02 Min: 0 Median: 2.0329 Max: 35892 Percentiles: P50: 2.03 P75: 2.99 P99: 8.53 P99.9: 13.59 P99.99: 30.34 ------------------------------------------------------ [ 0, 1 ] 13490 1.974% 1.974% ( 1, 2 ] 322237 47.164% 49.139% ######### ( 2, 3 ] 178666 26.151% 75.289% ##### ( 3, 4 ] 67881 9.935% 85.225% ## ( 4, 6 ] 85575 12.525% 97.750% ### ( 6, 10 ] 13490 1.974% 99.724% ( 10, 15 ] 1671 0.245% 99.969% ( 15, 22 ] 127 0.019% 99.988% ( 22, 34 ] 24 0.004% 99.991% ( 34, 51 ] 4 0.001% 99.992% ( 51, 76 ] 4 0.001% 99.992% ( 76, 110 ] 11 0.002% 99.994% ( 110, 170 ] 27 0.004% 99.998% ( 170, 250 ] 95 0.014% 100.012% ( 250, 380 ] 78 0.011% 100.023% ( 380, 580 ] 104 0.015% 100.038% ( 580, 870 ] 147 0.022% 100.060% ( 870, 1300 ] 133 0.019% 100.079% ( 1300, 1900 ] 70 0.010% 100.090% ( 1900, 2900 ] 88 0.013% 100.102% ( 2900, 4400 ] 128 0.019% 100.121% ( 4400, 6600 ] 30 0.004% 100.126% ( 6600, 9900 ] 39 0.006% 100.131% ( 9900, 14000 ] 16 0.002% 100.134% ( 14000, 22000 ] 10 0.001% 100.135% ( 22000, 33000 ] 2 0.000% 100.135% ( 33000, 50000 ] 1 0.000% 100.136% ** Level 4 read latency histogram (micros): Count: 34210 Average: 120.1413 StdDev: 644.02 Min: 1 Median: 2.2174 Max: 40292 Percentiles: P50: 2.22 P75: 3.58 P99: 3109.40 P99.9: 7969.50 P99.99: 15158.00 ------------------------------------------------------ [ 0, 1 ] 848 2.479% 2.479% ( 1, 2 ] 14467 42.289% 44.768% ######## ( 2, 3 ] 8233 24.066% 68.834% ##### ( 3, 4 ] 3665 10.713% 79.547% ## ( 4, 6 ] 2986 8.728% 88.275% ## ( 6, 10 ] 688 2.011% 90.286% ( 10, 15 ] 243 0.710% 90.997% ( 15, 22 ] 33 0.096% 91.093% ( 22, 34 ] 8 0.023% 91.117% ( 34, 51 ] 8 0.023% 91.140% ( 76, 110 ] 22 0.064% 91.204% ( 110, 170 ] 145 0.424% 91.628% ( 170, 250 ] 190 0.555% 92.184% ( 250, 380 ] 311 0.909% 93.093% ( 380, 580 ] 484 1.415% 94.507% ( 580, 870 ] 546 1.596% 96.103% ( 870, 1300 ] 447 1.307% 97.410% ( 1300, 1900 ] 294 0.859% 98.270% ( 1900, 2900 ] 215 0.628% 98.898% ( 2900, 4400 ] 250 0.731% 99.629% ( 4400, 6600 ] 82 0.240% 99.868% ( 6600, 9900 ] 26 0.076% 99.944% ( 9900, 14000 ] 15 0.044% 99.988% ( 14000, 22000 ] 4 0.012% 100.000% ( 33000, 50000 ] 1 0.003% 100.003% ** Level 5 read latency histogram (micros): Count: 220 Average: 1550.5091 StdDev: 1562.38 Min: 81 Median: 785.8065 Max: 6967 Percentiles: P50: 785.81 P75: 2542.86 P99: 6380.00 P99.9: 6967.00 P99.99: 6967.00 ------------------------------------------------------ ( 76, 110 ] 9 4.091% 4.091% # ( 110, 170 ] 20 9.091% 13.182% ## ( 170, 250 ] 12 5.455% 18.636% # ( 250, 380 ] 24 10.909% 29.545% ## ( 380, 580 ] 23 10.455% 40.000% ## ( 580, 870 ] 31 14.091% 54.091% ### ( 870, 1300 ] 10 4.545% 58.636% # ( 1300, 1900 ] 18 8.182% 66.818% ## ( 1900, 2900 ] 28 12.727% 79.545% ### ( 2900, 4400 ] 32 14.545% 94.091% ### ( 4400, 6600 ] 12 5.455% 99.545% # ( 6600, 9900 ] 1 0.455% 100.000% ** DB Stats ** Uptime(secs): 45.3 total, 3.0 interval Cumulative writes: 0 writes, 9000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 8.65 GB, 195.73 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.562 H:M:S, 45.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 326.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.418 H:M:S, 13.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/18-19:14:25 ... thread 0: (1000000,10000000) ops and (306918.5,207046.6) ops/second in (3.258194,48.298296) 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 16/4 3.50 GB 327.2 8.7 0.0 8.7 18.1 9.5 0.0 1.9 133.6 279.4 66.47 58.66 161 0.413 9017K 13K 0.0 0.0 L1 27/0 2.16 GB 221.0 7.3 5.8 1.5 7.2 5.7 0.2 1.2 205.5 202.9 36.15 32.49 4 9.038 6749K 77K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.2 0.1 0.1 0.2 0.1 3.7 1.5 235.7 235.5 0.82 0.78 2 0.409 195K 86 0.0 0.0 L3 14/0 999.69 MB 1.0 3.0 1.9 1.0 3.0 1.9 1.9 1.5 146.0 145.1 20.99 14.48 10 2.099 3113K 18K 0.0 0.0 L4 177/0 9.46 GB 1.0 3.0 2.8 0.1 3.0 2.8 0.7 1.0 122.4 122.2 24.75 15.05 37 0.669 2997K 2396 0.0 0.0 L5 1088/0 89.38 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 1322/4 105.48 GB 0.0 22.1 10.7 11.4 31.4 20.0 10.1 3.3 151.5 215.6 149.18 121.45 214 0.697 22M 111K 0.0 0.0 Int 0/0 0.00 KB 0.0 22.1 10.7 11.4 31.4 20.0 10.0 3.3 151.5 215.6 149.18 121.45 214 0.697 22M 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.1 10.7 11.4 21.9 10.5 0.0 0.0 190.1 189.0 118.87 96.93 81 1.467 22M 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 320.0 30.32 24.53 133 0.228 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): 48.5 total, 48.3 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.42 GB write, 663.13 MB/s write, 22.07 GB read, 465.86 MB/s read, 149.2 seconds Interval compaction: 31.42 GB write, 666.04 MB/s write, 22.07 GB read, 467.91 MB/s read, 149.2 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 15, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 15, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 61, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 15, total-stops: 61, interval: 76 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3826926 Average: 3.1184 StdDev: 51.05 Min: 0 Median: 1.5222 Max: 34416 Percentiles: P50: 1.52 P75: 1.91 P99: 7.46 P99.9: 160.80 P99.99: 467.68 ------------------------------------------------------ [ 0, 1 ] 621191 16.232% 16.232% ### ( 1, 2 ] 2474500 64.660% 80.892% ############# ( 2, 3 ] 428451 11.196% 92.088% ## ( 3, 4 ] 130561 3.412% 95.500% # ( 4, 6 ] 121367 3.171% 98.671% # ( 6, 10 ] 34493 0.901% 99.572% ( 10, 15 ] 3576 0.093% 99.666% ( 15, 22 ] 653 0.017% 99.683% ( 22, 34 ] 54 0.001% 99.684% ( 34, 51 ] 31 0.001% 99.685% ( 51, 76 ] 121 0.003% 99.688% ( 76, 110 ] 2940 0.077% 99.765% ( 110, 170 ] 6096 0.159% 99.924% ( 170, 250 ] 1370 0.036% 99.960% ( 250, 380 ] 864 0.023% 99.983% ( 380, 580 ] 628 0.016% 99.999% ( 580, 870 ] 324 0.008% 100.008% ( 870, 1300 ] 136 0.004% 100.011% ( 1300, 1900 ] 79 0.002% 100.013% ( 1900, 2900 ] 79 0.002% 100.015% ( 2900, 4400 ] 97 0.003% 100.018% ( 4400, 6600 ] 36 0.001% 100.019% ( 6600, 9900 ] 16 0.000% 100.019% ( 9900, 14000 ] 6 0.000% 100.019% ( 14000, 22000 ] 9 0.000% 100.020% ( 22000, 33000 ] 1 0.000% 100.020% ( 33000, 50000 ] 1 0.000% 100.020% ** Level 1 read latency histogram (micros): Count: 1163113 Average: 6.3173 StdDev: 114.56 Min: 1 Median: 1.8391 Max: 21393 Percentiles: P50: 1.84 P75: 2.77 P99: 9.51 P99.9: 182.12 P99.99: 565.37 ------------------------------------------------------ [ 0, 1 ] 63674 5.474% 5.474% # ( 1, 2 ] 617222 53.066% 58.541% ########### ( 2, 3 ] 248722 21.384% 79.925% #### ( 3, 4 ] 89578 7.702% 87.627% ## ( 4, 6 ] 108499 9.328% 96.955% ## ( 6, 10 ] 27097 2.330% 99.285% ( 10, 15 ] 5122 0.440% 99.725% ( 15, 22 ] 524 0.045% 99.770% ( 22, 34 ] 52 0.004% 99.774% ( 34, 51 ] 8 0.001% 99.775% ( 51, 76 ] 16 0.001% 99.777% ( 76, 110 ] 610 0.052% 99.829% ( 110, 170 ] 780 0.067% 99.896% ( 170, 250 ] 303 0.026% 99.922% ( 250, 380 ] 393 0.034% 99.956% ( 380, 580 ] 428 0.037% 99.993% ( 580, 870 ] 443 0.038% 100.031% ( 870, 1300 ] 317 0.027% 100.058% ( 1300, 1900 ] 203 0.017% 100.075% ( 1900, 2900 ] 242 0.021% 100.096% ( 2900, 4400 ] 261 0.022% 100.119% ( 4400, 6600 ] 77 0.007% 100.125% ( 6600, 9900 ] 46 0.004% 100.129% ( 9900, 14000 ] 12 0.001% 100.130% ( 14000, 22000 ] 9 0.001% 100.131% ** Level 2 read latency histogram (micros): Count: 48919 Average: 2.7686 StdDev: 20.03 Min: 0 Median: 1.5485 Max: 2401 Percentiles: P50: 1.55 P75: 1.92 P99: 6.48 P99.9: 191.15 P99.99: 732.84 ------------------------------------------------------ [ 0, 1 ] 6492 13.271% 13.271% ### ( 1, 2 ] 32759 66.966% 80.237% ############# ( 2, 3 ] 5387 11.012% 91.249% ## ( 3, 4 ] 2157 4.409% 95.658% # ( 4, 6 ] 1587 3.244% 98.902% # ( 6, 10 ] 396 0.810% 99.712% ( 10, 15 ] 63 0.129% 99.841% ( 15, 22 ] 6 0.012% 99.853% ( 22, 34 ] 4 0.008% 99.861% ( 34, 51 ] 1 0.002% 99.863% ( 76, 110 ] 2 0.004% 99.867% ( 110, 170 ] 10 0.020% 99.888% ( 170, 250 ] 23 0.047% 99.935% ( 250, 380 ] 12 0.025% 99.959% ( 380, 580 ] 13 0.027% 99.986% ( 580, 870 ] 4 0.008% 99.994% ( 870, 1300 ] 3 0.006% 100.000% ( 1900, 2900 ] 2 0.004% 100.004% ** Level 3 read latency histogram (micros): Count: 683222 Average: 5.9238 StdDev: 138.02 Min: 0 Median: 2.0329 Max: 35892 Percentiles: P50: 2.03 P75: 2.99 P99: 8.53 P99.9: 13.59 P99.99: 30.34 ------------------------------------------------------ [ 0, 1 ] 13490 1.974% 1.974% ( 1, 2 ] 322237 47.164% 49.139% ######### ( 2, 3 ] 178666 26.151% 75.289% ##### ( 3, 4 ] 67881 9.935% 85.225% ## ( 4, 6 ] 85575 12.525% 97.750% ### ( 6, 10 ] 13490 1.974% 99.724% ( 10, 15 ] 1671 0.245% 99.969% ( 15, 22 ] 127 0.019% 99.988% ( 22, 34 ] 24 0.004% 99.991% ( 34, 51 ] 4 0.001% 99.992% ( 51, 76 ] 4 0.001% 99.992% ( 76, 110 ] 11 0.002% 99.994% ( 110, 170 ] 27 0.004% 99.998% ( 170, 250 ] 95 0.014% 100.012% ( 250, 380 ] 78 0.011% 100.023% ( 380, 580 ] 104 0.015% 100.038% ( 580, 870 ] 147 0.022% 100.060% ( 870, 1300 ] 133 0.019% 100.079% ( 1300, 1900 ] 70 0.010% 100.090% ( 1900, 2900 ] 88 0.013% 100.102% ( 2900, 4400 ] 128 0.019% 100.121% ( 4400, 6600 ] 30 0.004% 100.126% ( 6600, 9900 ] 39 0.006% 100.131% ( 9900, 14000 ] 16 0.002% 100.134% ( 14000, 22000 ] 10 0.001% 100.135% ( 22000, 33000 ] 2 0.000% 100.135% ( 33000, 50000 ] 1 0.000% 100.136% ** Level 4 read latency histogram (micros): Count: 34210 Average: 120.1413 StdDev: 644.02 Min: 1 Median: 2.2174 Max: 40292 Percentiles: P50: 2.22 P75: 3.58 P99: 3109.40 P99.9: 7969.50 P99.99: 15158.00 ------------------------------------------------------ [ 0, 1 ] 848 2.479% 2.479% ( 1, 2 ] 14467 42.289% 44.768% ######## ( 2, 3 ] 8233 24.066% 68.834% ##### ( 3, 4 ] 3665 10.713% 79.547% ## ( 4, 6 ] 2986 8.728% 88.275% ## ( 6, 10 ] 688 2.011% 90.286% ( 10, 15 ] 243 0.710% 90.997% ( 15, 22 ] 33 0.096% 91.093% ( 22, 34 ] 8 0.023% 91.117% ( 34, 51 ] 8 0.023% 91.140% ( 76, 110 ] 22 0.064% 91.204% ( 110, 170 ] 145 0.424% 91.628% ( 170, 250 ] 190 0.555% 92.184% ( 250, 380 ] 311 0.909% 93.093% ( 380, 580 ] 484 1.415% 94.507% ( 580, 870 ] 546 1.596% 96.103% ( 870, 1300 ] 447 1.307% 97.410% ( 1300, 1900 ] 294 0.859% 98.270% ( 1900, 2900 ] 215 0.628% 98.898% ( 2900, 4400 ] 250 0.731% 99.629% ( 4400, 6600 ] 82 0.240% 99.868% ( 6600, 9900 ] 26 0.076% 99.944% ( 9900, 14000 ] 15 0.044% 99.988% ( 14000, 22000 ] 4 0.012% 100.000% ( 33000, 50000 ] 1 0.003% 100.003% ** Level 5 read latency histogram (micros): Count: 220 Average: 1550.5091 StdDev: 1562.38 Min: 81 Median: 785.8065 Max: 6967 Percentiles: P50: 785.81 P75: 2542.86 P99: 6380.00 P99.9: 6967.00 P99.99: 6967.00 ------------------------------------------------------ ( 76, 110 ] 9 4.091% 4.091% # ( 110, 170 ] 20 9.091% 13.182% ## ( 170, 250 ] 12 5.455% 18.636% # ( 250, 380 ] 24 10.909% 29.545% ## ( 380, 580 ] 23 10.455% 40.000% ## ( 580, 870 ] 31 14.091% 54.091% ### ( 870, 1300 ] 10 4.545% 58.636% # ( 1300, 1900 ] 18 8.182% 66.818% ## ( 1900, 2900 ] 28 12.727% 79.545% ### ( 2900, 4400 ] 32 14.545% 94.091% ### ( 4400, 6600 ] 12 5.455% 99.545% # ( 6600, 9900 ] 1 0.455% 100.000% ** DB Stats ** Uptime(secs): 48.5 total, 3.3 interval Cumulative writes: 0 writes, 10M keys, 0 commit groups, 0.0 writes per commit group, ingest: 9.61 GB, 202.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:21.219 H:M:S, 43.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 302.07 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.657 H:M:S, 20.2 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.820 micros/op 171818 ops/sec 60.058 seconds 10318999 operations; 166.5 MB/s Microseconds per write: Count: 10318999 Average: 5.8198 StdDev: 448.92 Min: 0 Median: 1.7249 Max: 668344 Percentiles: P50: 1.72 P75: 2.71 P99: 8.85 P99.9: 1142.55 P99.99: 2721.11 ------------------------------------------------------ [ 0, 1 ] 1457444 14.124% 14.124% ### ( 1, 2 ] 5106918 49.490% 63.614% ########## ( 2, 3 ] 1665255 16.138% 79.752% ### ( 3, 4 ] 1390371 13.474% 93.226% ### ( 4, 6 ] 520014 5.039% 98.265% # ( 6, 10 ] 106384 1.031% 99.296% ( 10, 15 ] 32782 0.318% 99.614% ( 15, 22 ] 8364 0.081% 99.695% ( 22, 34 ] 1512 0.015% 99.710% ( 34, 51 ] 202 0.002% 99.712% ( 51, 76 ] 28 0.000% 99.712% ( 76, 110 ] 7345 0.071% 99.783% ( 110, 170 ] 2648 0.026% 99.809% ( 170, 250 ] 298 0.003% 99.812% ( 250, 380 ] 153 0.001% 99.813% ( 380, 580 ] 45 0.000% 99.814% ( 580, 870 ] 25 0.000% 99.814% ( 870, 1300 ] 14029 0.136% 99.950% ( 1300, 1900 ] 15 0.000% 99.950% ( 1900, 2900 ] 5036 0.049% 99.999% ( 2900, 4400 ] 88 0.001% 100.000% ( 4400, 6600 ] 6 0.000% 100.000% ( 6600, 9900 ] 6 0.000% 100.000% ( 9900, 14000 ] 2 0.000% 100.000% ( 14000, 22000 ] 1 0.000% 100.000% ( 22000, 33000 ] 2 0.000% 100.000% ( 50000, 75000 ] 1 0.000% 100.000% ( 75000, 110000 ] 2 0.000% 100.000% ( 170000, 250000 ] 18 0.000% 100.000% ( 250000, 380000 ] 1 0.000% 100.000% ( 380000, 570000 ] 2 0.000% 100.000% ( 570000, 860000 ] 2 0.000% 100.000% STATISTICS: rocksdb.block.cache.miss COUNT : 0 rocksdb.block.cache.hit COUNT : 0 rocksdb.block.cache.add COUNT : 0 rocksdb.block.cache.add.failures COUNT : 0 rocksdb.block.cache.index.miss COUNT : 0 rocksdb.block.cache.index.hit COUNT : 0 rocksdb.block.cache.index.add COUNT : 0 rocksdb.block.cache.index.bytes.insert COUNT : 0 rocksdb.block.cache.filter.miss COUNT : 0 rocksdb.block.cache.filter.hit COUNT : 0 rocksdb.block.cache.filter.add COUNT : 0 rocksdb.block.cache.filter.bytes.insert COUNT : 0 rocksdb.block.cache.data.miss COUNT : 0 rocksdb.block.cache.data.hit COUNT : 0 rocksdb.block.cache.data.add COUNT : 0 rocksdb.block.cache.data.bytes.insert COUNT : 0 rocksdb.block.cache.bytes.read COUNT : 0 rocksdb.block.cache.bytes.write COUNT : 0 rocksdb.bloom.filter.useful COUNT : 0 rocksdb.bloom.filter.full.positive COUNT : 0 rocksdb.bloom.filter.full.true.positive COUNT : 0 rocksdb.persistent.cache.hit COUNT : 0 rocksdb.persistent.cache.miss COUNT : 0 rocksdb.sim.block.cache.hit COUNT : 0 rocksdb.sim.block.cache.miss COUNT : 0 rocksdb.memtable.hit COUNT : 0 rocksdb.memtable.miss COUNT : 0 rocksdb.l0.hit COUNT : 0 rocksdb.l1.hit COUNT : 0 rocksdb.l2andup.hit COUNT : 0 rocksdb.compaction.key.drop.new COUNT : 189361 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 : 10318999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 10649206968 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 : 497 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 31776113 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 : 26774905314 rocksdb.compact.write.bytes COUNT : 26589035107 rocksdb.flush.write.bytes COUNT : 10635000259 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 : 54 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 : 285 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 : 10549478400 rocksdb.memtable.garbage.bytes.at.flush COUNT : 4302848 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 : 26870304769 rocksdb.non.last.level.read.count COUNT : 6488786 rocksdb.block.checksum.compute.count COUNT : 6487846 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.368604 P95 : 3.865608 P99 : 7.175209 P100 : 668342.000000 COUNT : 10318999 SUM : 55251535 rocksdb.compaction.times.micros P50 : 975909.090909 P95 : 4195000.000000 P99 : 15360000.000000 P100 : 18897466.000000 COUNT : 83 SUM : 121045218 rocksdb.compaction.times.cpu_micros P50 : 845500.000000 P95 : 2825000.000000 P99 : 15360000.000000 P100 : 17149805.000000 COUNT : 83 SUM : 99068264 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 : 702.559524 P95 : 2975.000000 P99 : 43370.000000 P100 : 266535.000000 COUNT : 139 SUM : 443529 rocksdb.compaction.outfile.sync.micros P50 : 1141.987952 P95 : 65750.000000 P99 : 192133.333333 P100 : 440501.000000 COUNT : 317 SUM : 3771792 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 : 107.500000 P95 : 1272.357143 P99 : 4253.000000 P100 : 7356.000000 COUNT : 249 SUM : 84184 rocksdb.table.open.io.micros P50 : 1648.529412 P95 : 11524.230769 P99 : 25225.000000 P100 : 25225.000000 COUNT : 497 SUM : 1470695 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.668890 P95 : 7.895736 P99 : 11.312885 P100 : 40297.000000 COUNT : 6486378 SUM : 42609622 rocksdb.read.block.get.micros P50 : 528.979592 P95 : 4536.190476 P99 : 11452.875000 P100 : 13093.000000 COUNT : 994 SUM : 1221299 rocksdb.write.raw.block.micros P50 : 0.513804 P95 : 0.976228 P99 : 2.771667 P100 : 60887.000000 COUNT : 9015443 SUM : 20383598 rocksdb.numfiles.in.singlecompaction P50 : 3.100000 P95 : 3.970000 P99 : 20.880000 P100 : 42.000000 COUNT : 116 SUM : 429 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.561779 P95 : 1188.417683 P99 : 2560.175159 P100 : 668124.000000 COUNT : 173928 SUM : 31791980 rocksdb.sst.read.micros P50 : 1.592568 P95 : 4.737342 P99 : 8.570173 P100 : 40292.000000 COUNT : 6488914 SUM : 29517376 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 : 10318999 SUM : 10649206968 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 : 212758.620690 P95 : 462785.714286 P99 : 725633.333333 P100 : 829111.000000 COUNT : 139 SUM : 31584582 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 : 296 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