Invalid opts->opts_size 0 too small, please set opts_size correctly [2024-08-10 07:09:24.223313] Starting SPDK v24.09-pre git sha1 227b8322c / DPDK 22.11.4 initialization... [2024-08-10 07:09:24.223577] [ DPDK EAL parameters: rocksdb --no-shconf -c 0x1 --huge-unlink --no-telemetry --log-level=lib.eal:6 --log-level=lib.cryptodev:5 --log-level=lib.power:5 --log-level=user1:6 --base-virtaddr=0x200000000000 --match-allocations --file-prefix=spdk_pid1347883 ] Set seed to 1723266564216521 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-08-10 07:09:24.322938] app.c: 910:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-08-10 07:09:24.364727] app.c: 604:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-08-10 07:09:24.364773] app.c: 605:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 1347883' to capture a snapshot of events at runtime. [2024-08-10 07:09:24.364784] app.c: 610:app_setup_trace: *NOTICE*: 'spdk_trace' without parameters will also work if this is the only [2024-08-10 07:09:24.364798] app.c: 611:app_setup_trace: *NOTICE*: SPDK application currently running. [2024-08-10 07:09:24.364806] app.c: 612:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid1347883 for offline analysis/debug. [2024-08-10 07:09:24.364894] reactor.c: 941:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Sat Aug 10 07:09:28 2024 CPU: 96 * Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz CPUCache: 36608 KB 2024/08/10-07:09:31 ... thread 0: (1000000,1000000) ops and (324670.5,324670.5) ops/second in (3.080046,3.080046) 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.98 MB 18.9 0.0 0.0 0.0 0.9 0.9 0.0 1.0 0.0 341.6 2.58 2.33 12 0.215 0 0 0.0 0.0 L1 3/0 249.50 MB 25.0 0.2 0.2 0.0 0.2 0.2 0.2 1.0 248.9 248.7 1.01 0.98 1 1.012 255K 230 0.0 0.0 L2 3/2 191.11 MB 0.0 0.2 0.1 0.1 0.2 0.1 0.1 1.5 244.3 244.2 0.79 0.76 2 0.395 195K 101 0.0 0.0 L3 11/0 867.41 MB 0.9 0.0 0.0 0.0 0.0 0.0 0.1 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 116/0 9.60 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1044/0 85.69 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1183/6 97.00 GB 0.0 0.4 0.4 0.1 1.3 1.2 0.4 1.5 101.5 302.6 4.38 4.07 15 0.292 451K 331 0.0 0.0 Int 0/0 0.00 KB 0.0 0.4 0.4 0.1 1.3 1.2 0.2 1.5 101.5 302.6 4.38 4.07 15 0.292 451K 331 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 246.9 246.7 1.80 1.74 3 0.601 451K 331 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 341.6 2.58 2.33 12 0.215 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.3 total, 3.1 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, 401.67 MB/s write, 0.43 GB read, 134.71 MB/s read, 4.4 seconds Interval compaction: 1.30 GB write, 430.44 MB/s write, 0.43 GB read, 144.36 MB/s read, 4.4 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 3, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 3, interval: 3 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 159127 Average: 1.9354 StdDev: 11.01 Min: 0 Median: 1.3191 Max: 3170 Percentiles: P50: 1.32 P75: 1.73 P99: 5.08 P99.9: 9.72 P99.99: 64.59 ------------------------------------------------------ [ 0, 1 ] 48931 30.750% 30.750% ###### ( 1, 2 ] 96003 60.331% 91.081% ############ ( 2, 3 ] 8216 5.163% 96.244% # ( 3, 4 ] 3278 2.060% 98.304% ( 4, 6 ] 2053 1.290% 99.594% ( 6, 10 ] 525 0.330% 99.924% ( 10, 15 ] 85 0.053% 99.977% ( 15, 22 ] 17 0.011% 99.988% ( 22, 34 ] 4 0.003% 99.991% ( 51, 76 ] 2 0.001% 99.992% ( 110, 170 ] 7 0.004% 99.996% ( 170, 250 ] 5 0.003% 99.999% ( 250, 380 ] 5 0.003% 100.003% ( 380, 580 ] 2 0.001% 100.004% ( 580, 870 ] 1 0.001% 100.004% ( 870, 1300 ] 1 0.001% 100.005% ( 1300, 1900 ] 1 0.001% 100.006% ( 1900, 2900 ] 1 0.001% 100.006% ( 2900, 4400 ] 1 0.001% 100.007% ** Level 1 read latency histogram (micros): Count: 593 Average: 7.1551 StdDev: 55.61 Min: 1 Median: 1.9050 Max: 1183 Percentiles: P50: 1.91 P75: 2.65 P99: 114.20 P99.9: 1045.01 P99.99: 1183.00 ------------------------------------------------------ [ 0, 1 ] 25 4.216% 4.216% # ( 1, 2 ] 300 50.590% 54.806% ########## ( 2, 3 ] 184 31.029% 85.835% ###### ( 3, 4 ] 26 4.384% 90.219% # ( 4, 6 ] 36 6.071% 96.290% # ( 6, 10 ] 15 2.530% 98.820% # ( 15, 22 ] 1 0.169% 98.988% ( 110, 170 ] 1 0.169% 99.157% ( 170, 250 ] 1 0.169% 99.325% ( 250, 380 ] 2 0.337% 99.663% ( 380, 580 ] 1 0.169% 99.831% ( 870, 1300 ] 1 0.169% 100.000% ** Level 2 read latency histogram (micros): Count: 43143 Average: 2.5496 StdDev: 26.22 Min: 1 Median: 1.5137 Max: 3268 Percentiles: P50: 1.51 P75: 1.88 P99: 5.84 P99.9: 10.98 P99.99: 1402.85 ------------------------------------------------------ [ 0, 1 ] 6382 14.793% 14.793% ### ( 1, 2 ] 29567 68.533% 83.325% ############## ( 2, 3 ] 3952 9.160% 92.485% ## ( 3, 4 ] 1733 4.017% 96.502% # ( 4, 6 ] 1171 2.714% 99.217% # ( 6, 10 ] 289 0.670% 99.886% ( 10, 15 ] 30 0.070% 99.956% ( 15, 22 ] 5 0.012% 99.968% ( 51, 76 ] 1 0.002% 99.970% ( 170, 250 ] 1 0.002% 99.972% ( 250, 380 ] 1 0.002% 99.975% ( 380, 580 ] 2 0.005% 99.979% ( 580, 870 ] 2 0.005% 99.984% ( 870, 1300 ] 2 0.005% 99.988% ( 1300, 1900 ] 4 0.009% 99.998% ( 1900, 2900 ] 1 0.002% 100.000% ( 2900, 4400 ] 1 0.002% 100.002% ** Level 3 read latency histogram (micros): Count: 45 Average: 1560.9556 StdDev: 1397.93 Min: 44 Median: 1085.0000 Max: 6363 Percentiles: P50: 1085.00 P75: 2368.75 P99: 6105.00 P99.9: 6363.00 P99.99: 6363.00 ------------------------------------------------------ ( 34, 51 ] 2 4.444% 4.444% # ( 110, 170 ] 1 2.222% 6.667% ( 170, 250 ] 2 4.444% 11.111% # ( 250, 380 ] 6 13.333% 24.444% ### ( 380, 580 ] 1 2.222% 26.667% ( 580, 870 ] 7 15.556% 42.222% ### ( 870, 1300 ] 7 15.556% 57.778% ### ( 1300, 1900 ] 4 8.889% 66.667% ## ( 1900, 2900 ] 8 17.778% 84.444% #### ( 2900, 4400 ] 5 11.111% 95.556% ## ( 4400, 6600 ] 2 4.444% 100.000% # ** Level 4 read latency histogram (micros): Count: 25 Average: 1798.3200 StdDev: 1234.33 Min: 441 Median: 1350.0000 Max: 4927 Percentiles: P50: 1350.00 P75: 2275.00 P99: 4927.00 P99.9: 4927.00 P99.99: 4927.00 ------------------------------------------------------ ( 380, 580 ] 2 8.000% 8.000% ## ( 580, 870 ] 2 8.000% 16.000% ## ( 870, 1300 ] 8 32.000% 48.000% ###### ( 1300, 1900 ] 6 24.000% 72.000% ##### ( 1900, 2900 ] 2 8.000% 80.000% ## ( 2900, 4400 ] 3 12.000% 92.000% ## ( 4400, 6600 ] 2 8.000% 100.000% ## ** DB Stats ** Uptime(secs): 3.3 total, 3.1 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 298.00 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.423 H:M:S, 12.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 319.29 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.423 H:M:S, 13.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/08/10-07:09:34 ... thread 0: (1000000,2000000) ops and (345839.1,334920.6) ops/second in (2.891518,5.971564) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 11/10 1.35 GB 12.6 0.8 0.0 0.8 2.6 1.8 0.0 1.4 97.4 314.7 8.40 7.79 29 0.290 831K 863 0.0 0.0 L1 0/0 0.00 KB 0.0 0.2 0.2 0.0 0.2 0.2 0.2 1.0 248.9 248.7 1.01 0.98 1 1.012 255K 230 0.0 0.0 L2 2/1 80.89 MB 0.8 0.2 0.1 0.1 0.2 0.1 0.3 1.5 244.3 244.2 0.79 0.76 2 0.395 195K 101 0.0 0.0 L3 20/11 1.03 GB 0.2 0.2 0.2 0.0 0.2 0.2 0.3 1.0 220.8 220.8 0.85 0.78 1 0.848 190K 0 0.0 0.0 L4 174/0 9.76 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.0 1.0 134.3 134.3 1.25 0.87 1 1.252 170K 0 0.0 0.0 L5 1044/0 85.69 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1251/22 97.92 GB 0.0 1.6 0.7 0.9 3.4 2.5 0.8 1.9 131.6 279.9 12.31 11.18 34 0.362 1644K 1194 0.0 0.0 Int 0/0 0.00 KB 0.0 1.6 0.7 0.9 3.4 2.5 0.7 1.9 131.6 279.9 12.31 11.18 34 0.362 1644K 1194 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.6 0.7 0.9 1.6 0.7 0.0 0.0 230.8 230.6 7.02 6.45 8 0.877 1644K 1194 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 345.3 5.29 4.74 26 0.203 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 6.2 total, 6.0 interval Flush(GB): cumulative 1.784, interval 1.784 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 3.36 GB write, 556.19 MB/s write, 1.58 GB read, 261.43 MB/s read, 12.3 seconds Interval compaction: 3.36 GB write, 576.74 MB/s write, 1.58 GB read, 271.10 MB/s read, 12.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: 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: 380888 Average: 2.1171 StdDev: 10.66 Min: 0 Median: 1.4417 Max: 3170 Percentiles: P50: 1.44 P75: 1.83 P99: 5.45 P99.9: 9.67 P99.99: 23.82 ------------------------------------------------------ [ 0, 1 ] 81653 21.438% 21.438% #### ( 1, 2 ] 246292 64.663% 86.100% ############# ( 2, 3 ] 31277 8.212% 94.312% ## ( 3, 4 ] 12537 3.292% 97.603% # ( 4, 6 ] 7361 1.933% 99.536% ( 6, 10 ] 1513 0.397% 99.933% ( 10, 15 ] 187 0.049% 99.982% ( 15, 22 ] 30 0.008% 99.990% ( 22, 34 ] 6 0.002% 99.992% ( 34, 51 ] 3 0.001% 99.992% ( 51, 76 ] 4 0.001% 99.993% ( 110, 170 ] 10 0.003% 99.996% ( 170, 250 ] 13 0.003% 99.999% ( 250, 380 ] 11 0.003% 100.002% ( 380, 580 ] 5 0.001% 100.004% ( 580, 870 ] 6 0.002% 100.005% ( 870, 1300 ] 6 0.002% 100.007% ( 1300, 1900 ] 5 0.001% 100.008% ( 1900, 2900 ] 2 0.001% 100.009% ( 2900, 4400 ] 1 0.000% 100.009% ** Level 1 read latency histogram (micros): Count: 593 Average: 7.1551 StdDev: 55.61 Min: 1 Median: 1.9050 Max: 1183 Percentiles: P50: 1.91 P75: 2.65 P99: 114.20 P99.9: 1045.01 P99.99: 1183.00 ------------------------------------------------------ [ 0, 1 ] 25 4.216% 4.216% # ( 1, 2 ] 300 50.590% 54.806% ########## ( 2, 3 ] 184 31.029% 85.835% ###### ( 3, 4 ] 26 4.384% 90.219% # ( 4, 6 ] 36 6.071% 96.290% # ( 6, 10 ] 15 2.530% 98.820% # ( 15, 22 ] 1 0.169% 98.988% ( 110, 170 ] 1 0.169% 99.157% ( 170, 250 ] 1 0.169% 99.325% ( 250, 380 ] 2 0.337% 99.663% ( 380, 580 ] 1 0.169% 99.831% ( 870, 1300 ] 1 0.169% 100.000% ** Level 2 read latency histogram (micros): Count: 48659 Average: 2.5160 StdDev: 24.69 Min: 1 Median: 1.5236 Max: 3268 Percentiles: P50: 1.52 P75: 1.89 P99: 5.82 P99.9: 10.79 P99.99: 1320.11 ------------------------------------------------------ [ 0, 1 ] 6881 14.141% 14.141% ### ( 1, 2 ] 33321 68.479% 82.620% ############## ( 2, 3 ] 4863 9.994% 92.614% ## ( 3, 4 ] 1942 3.991% 96.605% # ( 4, 6 ] 1280 2.631% 99.235% # ( 6, 10 ] 318 0.654% 99.889% ( 10, 15 ] 34 0.070% 99.959% ( 15, 22 ] 6 0.012% 99.971% ( 51, 76 ] 1 0.002% 99.973% ( 170, 250 ] 1 0.002% 99.975% ( 250, 380 ] 1 0.002% 99.977% ( 380, 580 ] 2 0.004% 99.982% ( 580, 870 ] 2 0.004% 99.986% ( 870, 1300 ] 2 0.004% 99.990% ( 1300, 1900 ] 4 0.008% 99.998% ( 1900, 2900 ] 1 0.002% 100.000% ( 2900, 4400 ] 1 0.002% 100.002% ** Level 3 read latency histogram (micros): Count: 194924 Average: 3.3712 StdDev: 35.62 Min: 1 Median: 1.6375 Max: 6363 Percentiles: P50: 1.64 P75: 2.11 P99: 8.61 P99.9: 166.92 P99.99: 561.12 ------------------------------------------------------ [ 0, 1 ] 17966 9.217% 9.217% ## ( 1, 2 ] 124691 63.969% 73.186% ############# ( 2, 3 ] 32607 16.728% 89.914% ### ( 3, 4 ] 9405 4.825% 94.739% # ( 4, 6 ] 6396 3.281% 98.020% # ( 6, 10 ] 2928 1.502% 99.522% ( 10, 15 ] 293 0.150% 99.673% ( 15, 22 ] 66 0.034% 99.707% ( 22, 34 ] 31 0.016% 99.722% ( 34, 51 ] 6 0.003% 99.726% ( 51, 76 ] 11 0.006% 99.731% ( 76, 110 ] 90 0.046% 99.777% ( 110, 170 ] 252 0.129% 99.907% ( 170, 250 ] 81 0.042% 99.948% ( 250, 380 ] 48 0.025% 99.973% ( 380, 580 ] 37 0.019% 99.992% ( 580, 870 ] 35 0.018% 100.010% ( 870, 1300 ] 17 0.009% 100.018% ( 1300, 1900 ] 7 0.004% 100.022% ( 1900, 2900 ] 8 0.004% 100.026% ( 2900, 4400 ] 5 0.003% 100.029% ( 4400, 6600 ] 2 0.001% 100.030% ** Level 4 read latency histogram (micros): Count: 315 Average: 145.6508 StdDev: 596.98 Min: 1 Median: 1.6304 Max: 4927 Percentiles: P50: 1.63 P75: 4.94 P99: 3825.00 P99.9: 4927.00 P99.99: 4927.00 ------------------------------------------------------ [ 0, 1 ] 56 17.778% 17.778% #### ( 1, 2 ] 161 51.111% 68.889% ########## ( 2, 3 ] 13 4.127% 73.016% # ( 3, 4 ] 2 0.635% 73.651% ( 4, 6 ] 9 2.857% 76.508% # ( 6, 10 ] 46 14.603% 91.111% ### ( 10, 15 ] 2 0.635% 91.746% ( 22, 34 ] 1 0.317% 92.063% ( 380, 580 ] 2 0.635% 92.698% ( 580, 870 ] 2 0.635% 93.333% ( 870, 1300 ] 8 2.540% 95.873% # ( 1300, 1900 ] 6 1.905% 97.778% ( 1900, 2900 ] 2 0.635% 98.413% ( 2900, 4400 ] 3 0.952% 99.365% ( 4400, 6600 ] 2 0.635% 100.000% ** DB Stats ** Uptime(secs): 6.2 total, 2.9 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 317.78 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.626 H:M:S, 10.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 340.37 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.202 H:M:S, 7.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/08/10-07:09:37 ... thread 0: (1000000,3000000) ops and (327766.4,332501.5) ops/second in (3.050953,9.022517) 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/10 2.34 GB 107.0 1.6 0.0 1.6 4.4 2.8 0.0 1.6 113.3 309.3 14.46 13.49 46 0.314 1663K 1705 0.0 0.0 L1 0/0 0.00 KB 0.0 0.2 0.2 0.0 0.2 0.2 0.2 1.0 248.9 248.7 1.01 0.98 1 1.012 255K 230 0.0 0.0 L2 1/0 77.00 MB 0.8 0.2 0.1 0.1 0.2 0.1 0.3 1.5 244.3 244.2 0.79 0.76 2 0.395 195K 101 0.0 0.0 L3 12/0 543.81 MB 0.5 1.0 0.2 0.8 1.0 0.2 0.3 5.5 228.4 227.6 4.63 4.32 2 2.317 1075K 3945 0.0 0.0 L4 170/0 9.59 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.5 1.0 134.3 134.3 1.25 0.87 1 1.252 170K 0 0.0 0.0 L5 1052/0 86.37 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 1251/10 98.90 GB 0.0 3.2 0.7 2.5 6.0 3.5 1.9 2.2 149.5 277.2 22.14 20.42 52 0.426 3360K 5981 0.0 0.0 Int 0/0 0.00 KB 0.0 3.2 0.7 2.5 6.0 3.5 1.8 2.2 149.5 277.2 22.14 20.42 52 0.426 3360K 5981 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 0.7 2.5 3.2 0.7 0.0 0.0 236.9 236.5 13.97 13.10 12 1.164 3360K 5981 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 2.8 2.8 0.0 0.0 0.0 346.8 8.17 7.31 40 0.204 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.2 total, 9.0 interval Flush(GB): cumulative 2.768, interval 2.768 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 5.99 GB write, 663.98 MB/s write, 3.23 GB read, 357.99 MB/s read, 22.1 seconds Interval compaction: 5.99 GB write, 680.22 MB/s write, 3.23 GB read, 366.75 MB/s read, 22.1 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 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: 792850 Average: 2.2024 StdDev: 11.13 Min: 0 Median: 1.4952 Max: 3745 Percentiles: P50: 1.50 P75: 1.87 P99: 5.50 P99.9: 9.61 P99.99: 14.57 ------------------------------------------------------ [ 0, 1 ] 132808 16.751% 16.751% ### ( 1, 2 ] 532322 67.140% 83.891% ############# ( 2, 3 ] 77826 9.816% 93.707% ## ( 3, 4 ] 29600 3.733% 97.440% # ( 4, 6 ] 16498 2.081% 99.521% ( 6, 10 ] 3334 0.421% 99.942% ( 10, 15 ] 422 0.053% 99.995% ( 15, 22 ] 50 0.006% 100.001% ( 22, 34 ] 10 0.001% 100.003% ( 34, 51 ] 4 0.001% 100.003% ( 51, 76 ] 5 0.001% 100.004% ( 76, 110 ] 20 0.003% 100.006% ( 110, 170 ] 40 0.005% 100.011% ( 170, 250 ] 37 0.005% 100.016% ( 250, 380 ] 30 0.004% 100.020% ( 380, 580 ] 13 0.002% 100.021% ( 580, 870 ] 12 0.002% 100.023% ( 870, 1300 ] 10 0.001% 100.024% ( 1300, 1900 ] 7 0.001% 100.025% ( 1900, 2900 ] 4 0.001% 100.025% ( 2900, 4400 ] 3 0.000% 100.026% ** Level 1 read latency histogram (micros): Count: 593 Average: 7.1551 StdDev: 55.61 Min: 1 Median: 1.9050 Max: 1183 Percentiles: P50: 1.91 P75: 2.65 P99: 114.20 P99.9: 1045.01 P99.99: 1183.00 ------------------------------------------------------ [ 0, 1 ] 25 4.216% 4.216% # ( 1, 2 ] 300 50.590% 54.806% ########## ( 2, 3 ] 184 31.029% 85.835% ###### ( 3, 4 ] 26 4.384% 90.219% # ( 4, 6 ] 36 6.071% 96.290% # ( 6, 10 ] 15 2.530% 98.820% # ( 15, 22 ] 1 0.169% 98.988% ( 110, 170 ] 1 0.169% 99.157% ( 170, 250 ] 1 0.169% 99.325% ( 250, 380 ] 2 0.337% 99.663% ( 380, 580 ] 1 0.169% 99.831% ( 870, 1300 ] 1 0.169% 100.000% ** Level 2 read latency histogram (micros): Count: 77271 Average: 2.8270 StdDev: 22.17 Min: 1 Median: 1.5680 Max: 3268 Percentiles: P50: 1.57 P75: 1.94 P99: 7.44 P99.9: 152.87 P99.99: 834.86 ------------------------------------------------------ [ 0, 1 ] 8785 11.369% 11.369% ## ( 1, 2 ] 52556 68.015% 79.384% ############## ( 2, 3 ] 9207 11.915% 91.299% ## ( 3, 4 ] 3534 4.574% 95.873% # ( 4, 6 ] 2113 2.735% 98.607% # ( 6, 10 ] 840 1.087% 99.695% ( 10, 15 ] 75 0.097% 99.792% ( 15, 22 ] 12 0.016% 99.807% ( 51, 76 ] 3 0.004% 99.811% ( 76, 110 ] 33 0.043% 99.854% ( 110, 170 ] 50 0.065% 99.918% ( 170, 250 ] 17 0.022% 99.940% ( 250, 380 ] 17 0.022% 99.962% ( 380, 580 ] 16 0.021% 99.983% ( 580, 870 ] 6 0.008% 99.991% ( 870, 1300 ] 2 0.003% 99.994% ( 1300, 1900 ] 4 0.005% 99.999% ( 1900, 2900 ] 1 0.001% 100.000% ( 2900, 4400 ] 1 0.001% 100.001% ** Level 3 read latency histogram (micros): Count: 234689 Average: 3.3193 StdDev: 34.23 Min: 1 Median: 1.6335 Max: 6363 Percentiles: P50: 1.63 P75: 2.07 P99: 8.58 P99.9: 167.70 P99.99: 606.95 ------------------------------------------------------ [ 0, 1 ] 20750 8.841% 8.841% ## ( 1, 2 ] 152475 64.969% 73.810% ############# ( 2, 3 ] 37898 16.148% 89.959% ### ( 3, 4 ] 11507 4.903% 94.862% # ( 4, 6 ] 7383 3.146% 98.008% # ( 6, 10 ] 3614 1.540% 99.547% ( 10, 15 ] 341 0.145% 99.693% ( 15, 22 ] 69 0.029% 99.722% ( 22, 34 ] 33 0.014% 99.736% ( 34, 51 ] 6 0.003% 99.739% ( 51, 76 ] 12 0.005% 99.744% ( 76, 110 ] 98 0.042% 99.786% ( 110, 170 ] 279 0.119% 99.905% ( 170, 250 ] 94 0.040% 99.945% ( 250, 380 ] 61 0.026% 99.971% ( 380, 580 ] 42 0.018% 99.988% ( 580, 870 ] 38 0.016% 100.005% ( 870, 1300 ] 22 0.009% 100.014% ( 1300, 1900 ] 7 0.003% 100.017% ( 1900, 2900 ] 11 0.005% 100.022% ( 2900, 4400 ] 5 0.002% 100.024% ( 4400, 6600 ] 2 0.001% 100.025% ** Level 4 read latency histogram (micros): Count: 315 Average: 145.6508 StdDev: 596.98 Min: 1 Median: 1.6304 Max: 4927 Percentiles: P50: 1.63 P75: 4.94 P99: 3825.00 P99.9: 4927.00 P99.99: 4927.00 ------------------------------------------------------ [ 0, 1 ] 56 17.778% 17.778% #### ( 1, 2 ] 161 51.111% 68.889% ########## ( 2, 3 ] 13 4.127% 73.016% # ( 3, 4 ] 2 0.635% 73.651% ( 4, 6 ] 9 2.857% 76.508% # ( 6, 10 ] 46 14.603% 91.111% ### ( 10, 15 ] 2 0.635% 91.746% ( 22, 34 ] 1 0.317% 92.063% ( 380, 580 ] 2 0.635% 92.698% ( 580, 870 ] 2 0.635% 93.333% ( 870, 1300 ] 8 2.540% 95.873% # ( 1300, 1900 ] 6 1.905% 97.778% ( 1900, 2900 ] 2 0.635% 98.413% ( 2900, 4400 ] 3 0.952% 99.365% ( 4400, 6600 ] 2 0.635% 100.000% ** Level 5 read latency histogram (micros): Count: 40 Average: 1000.9750 StdDev: 1101.40 Min: 123 Median: 500.0000 Max: 3918 Percentiles: P50: 500.00 P75: 1300.00 P99: 3918.00 P99.9: 3918.00 P99.99: 3918.00 ------------------------------------------------------ ( 110, 170 ] 6 15.000% 15.000% ### ( 170, 250 ] 4 10.000% 25.000% ## ( 250, 380 ] 7 17.500% 42.500% #### ( 380, 580 ] 5 12.500% 55.000% ### ( 580, 870 ] 6 15.000% 70.000% ### ( 870, 1300 ] 2 5.000% 75.000% # ( 1900, 2900 ] 6 15.000% 90.000% ### ( 2900, 4400 ] 4 10.000% 100.000% ## ** DB Stats ** Uptime(secs): 9.2 total, 3.1 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 319.37 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.998 H:M:S, 10.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 322.59 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.372 H:M:S, 12.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/08/10-07:09:40 ... thread 0: (1000000,4000000) ops and (320275.8,329358.4) ops/second in (3.122309,12.144826) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 14/10 2.27 GB 31.5 2.5 0.0 2.5 6.1 3.7 0.0 1.7 123.3 308.2 20.43 19.12 62 0.330 2558K 2704 0.0 0.0 L1 6/6 487.88 MB 0.0 1.2 1.2 0.0 1.2 1.2 0.2 1.0 237.5 236.6 5.30 5.13 2 2.651 1278K 4169 0.0 0.0 L2 1/1 128.77 MB 0.0 0.2 0.1 0.1 0.2 0.1 0.8 1.5 244.3 244.2 0.79 0.76 2 0.395 195K 101 0.0 0.0 L3 20/2 1006.05 MB 0.9 1.6 0.6 1.0 1.6 0.6 0.3 2.5 220.2 219.5 7.58 7.02 4 1.896 1695K 5000 0.0 0.0 L4 170/0 9.59 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.5 1.0 134.3 134.3 1.25 0.87 1 1.252 170K 0 0.0 0.0 L5 1052/0 86.37 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/19 99.82 GB 0.0 5.7 2.2 3.5 9.4 5.8 2.4 2.5 164.3 270.8 35.36 32.90 71 0.498 5899K 11K 0.0 0.0 Int 0/0 0.00 KB 0.0 5.7 2.2 3.5 9.4 5.8 2.3 2.5 164.3 270.8 35.36 32.90 71 0.498 5899K 11K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 5.7 2.2 3.5 5.7 2.1 0.0 0.0 237.3 236.8 24.49 23.18 18 1.360 5899K 11K 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 347.6 10.87 9.72 53 0.205 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 12.4 total, 12.1 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: 9.35 GB write, 774.40 MB/s write, 5.67 GB read, 469.76 MB/s read, 35.4 seconds Interval compaction: 9.35 GB write, 788.48 MB/s write, 5.67 GB read, 478.30 MB/s read, 35.4 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 14, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 14, interval: 14 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1050603 Average: 2.2157 StdDev: 11.33 Min: 0 Median: 1.4962 Max: 4111 Percentiles: P50: 1.50 P75: 1.87 P99: 5.51 P99.9: 9.75 P99.99: 65.18 ------------------------------------------------------ [ 0, 1 ] 173971 16.559% 16.559% ### ( 1, 2 ] 708023 67.392% 83.951% ############# ( 2, 3 ] 103076 9.811% 93.762% ## ( 3, 4 ] 39043 3.716% 97.479% # ( 4, 6 ] 21223 2.020% 99.499% ( 6, 10 ] 4493 0.428% 99.926% ( 10, 15 ] 574 0.055% 99.981% ( 15, 22 ] 72 0.007% 99.988% ( 22, 34 ] 11 0.001% 99.989% ( 34, 51 ] 4 0.000% 99.989% ( 51, 76 ] 14 0.001% 99.991% ( 76, 110 ] 74 0.007% 99.998% ( 110, 170 ] 87 0.008% 100.006% ( 170, 250 ] 58 0.006% 100.011% ( 250, 380 ] 40 0.004% 100.015% ( 380, 580 ] 21 0.002% 100.017% ( 580, 870 ] 15 0.001% 100.019% ( 870, 1300 ] 17 0.002% 100.020% ( 1300, 1900 ] 9 0.001% 100.021% ( 1900, 2900 ] 4 0.000% 100.022% ( 2900, 4400 ] 4 0.000% 100.022% ** Level 1 read latency histogram (micros): Count: 155515 Average: 2.7931 StdDev: 14.06 Min: 1 Median: 1.6025 Max: 1358 Percentiles: P50: 1.60 P75: 1.97 P99: 7.75 P99.9: 155.21 P99.99: 460.37 ------------------------------------------------------ [ 0, 1 ] 14222 9.145% 9.145% ## ( 1, 2 ] 105462 67.815% 76.960% ############## ( 2, 3 ] 22103 14.213% 91.173% ### ( 3, 4 ] 6829 4.391% 95.564% # ( 4, 6 ] 4628 2.976% 98.540% # ( 6, 10 ] 1634 1.051% 99.590% ( 10, 15 ] 282 0.181% 99.772% ( 15, 22 ] 56 0.036% 99.808% ( 22, 34 ] 7 0.005% 99.812% ( 51, 76 ] 3 0.002% 99.814% ( 76, 110 ] 32 0.021% 99.835% ( 110, 170 ] 136 0.087% 99.922% ( 170, 250 ] 56 0.036% 99.958% ( 250, 380 ] 40 0.026% 99.984% ( 380, 580 ] 26 0.017% 100.001% ( 580, 870 ] 9 0.006% 100.006% ( 870, 1300 ] 7 0.005% 100.011% ( 1300, 1900 ] 1 0.001% 100.012% ** Level 2 read latency histogram (micros): Count: 77271 Average: 2.8270 StdDev: 22.17 Min: 1 Median: 1.5680 Max: 3268 Percentiles: P50: 1.57 P75: 1.94 P99: 7.44 P99.9: 152.87 P99.99: 834.86 ------------------------------------------------------ [ 0, 1 ] 8785 11.369% 11.369% ## ( 1, 2 ] 52556 68.015% 79.384% ############## ( 2, 3 ] 9207 11.915% 91.299% ## ( 3, 4 ] 3534 4.574% 95.873% # ( 4, 6 ] 2113 2.735% 98.607% # ( 6, 10 ] 840 1.087% 99.695% ( 10, 15 ] 75 0.097% 99.792% ( 15, 22 ] 12 0.016% 99.807% ( 51, 76 ] 3 0.004% 99.811% ( 76, 110 ] 33 0.043% 99.854% ( 110, 170 ] 50 0.065% 99.918% ( 170, 250 ] 17 0.022% 99.940% ( 250, 380 ] 17 0.022% 99.962% ( 380, 580 ] 16 0.021% 99.983% ( 580, 870 ] 6 0.008% 99.991% ( 870, 1300 ] 2 0.003% 99.994% ( 1300, 1900 ] 4 0.005% 99.999% ( 1900, 2900 ] 1 0.001% 100.000% ( 2900, 4400 ] 1 0.001% 100.001% ** Level 3 read latency histogram (micros): Count: 245796 Average: 3.6580 StdDev: 35.25 Min: 0 Median: 1.6354 Max: 6363 Percentiles: P50: 1.64 P75: 2.09 P99: 9.03 P99.9: 243.47 P99.99: 692.64 ------------------------------------------------------ [ 0, 1 ] 21779 8.861% 8.861% ## ( 1, 2 ] 159146 64.747% 73.608% ############# ( 2, 3 ] 40061 16.298% 89.906% ### ( 3, 4 ] 11907 4.844% 94.751% # ( 4, 6 ] 7628 3.103% 97.854% # ( 6, 10 ] 3722 1.514% 99.368% ( 10, 15 ] 359 0.146% 99.514% ( 15, 22 ] 73 0.030% 99.544% ( 22, 34 ] 34 0.014% 99.558% ( 34, 51 ] 6 0.002% 99.560% ( 51, 76 ] 12 0.005% 99.565% ( 76, 110 ] 208 0.085% 99.650% ( 110, 170 ] 460 0.187% 99.837% ( 170, 250 ] 169 0.069% 99.906% ( 250, 380 ] 109 0.044% 99.950% ( 380, 580 ] 79 0.032% 99.982% ( 580, 870 ] 50 0.020% 100.002% ( 870, 1300 ] 27 0.011% 100.013% ( 1300, 1900 ] 7 0.003% 100.016% ( 1900, 2900 ] 11 0.004% 100.021% ( 2900, 4400 ] 5 0.002% 100.023% ( 4400, 6600 ] 2 0.001% 100.024% ** Level 4 read latency histogram (micros): Count: 315 Average: 145.6508 StdDev: 596.98 Min: 1 Median: 1.6304 Max: 4927 Percentiles: P50: 1.63 P75: 4.94 P99: 3825.00 P99.9: 4927.00 P99.99: 4927.00 ------------------------------------------------------ [ 0, 1 ] 56 17.778% 17.778% #### ( 1, 2 ] 161 51.111% 68.889% ########## ( 2, 3 ] 13 4.127% 73.016% # ( 3, 4 ] 2 0.635% 73.651% ( 4, 6 ] 9 2.857% 76.508% # ( 6, 10 ] 46 14.603% 91.111% ### ( 10, 15 ] 2 0.635% 91.746% ( 22, 34 ] 1 0.317% 92.063% ( 380, 580 ] 2 0.635% 92.698% ( 580, 870 ] 2 0.635% 93.333% ( 870, 1300 ] 8 2.540% 95.873% # ( 1300, 1900 ] 6 1.905% 97.778% ( 1900, 2900 ] 2 0.635% 98.413% ( 2900, 4400 ] 3 0.952% 99.365% ( 4400, 6600 ] 2 0.635% 100.000% ** Level 5 read latency histogram (micros): Count: 40 Average: 1000.9750 StdDev: 1101.40 Min: 123 Median: 500.0000 Max: 3918 Percentiles: P50: 500.00 P75: 1300.00 P99: 3918.00 P99.9: 3918.00 P99.99: 3918.00 ------------------------------------------------------ ( 110, 170 ] 6 15.000% 15.000% ### ( 170, 250 ] 4 10.000% 25.000% ## ( 250, 380 ] 7 17.500% 42.500% #### ( 380, 580 ] 5 12.500% 55.000% ### ( 580, 870 ] 6 15.000% 70.000% ### ( 870, 1300 ] 2 5.000% 75.000% # ( 1900, 2900 ] 6 15.000% 90.000% ### ( 2900, 4400 ] 4 10.000% 100.000% ## ** DB Stats ** Uptime(secs): 12.4 total, 3.1 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 318.32 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.396 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, 315.21 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.399 H:M:S, 12.8 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/08/10-07:09:44 ... thread 0: (1000000,5000000) ops and (260230.6,312742.9) ops/second in (3.842746,15.987572) 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/10 3.32 GB 138.5 3.5 0.0 3.5 8.2 4.7 0.0 1.7 130.6 306.8 27.50 25.75 82 0.335 3645K 3858 0.0 0.0 L1 6/6 487.88 MB 0.0 1.2 1.2 0.0 1.2 1.2 0.2 1.0 237.5 236.6 5.30 5.13 2 2.651 1278K 4169 0.0 0.0 L2 0/0 0.00 KB 0.0 0.2 0.1 0.1 0.2 0.1 0.8 1.5 244.3 244.2 0.79 0.76 2 0.395 195K 101 0.0 0.0 L3 20/0 910.99 MB 0.9 1.8 0.8 1.1 1.8 0.8 0.3 2.4 219.9 219.2 8.61 7.99 5 1.723 1923K 5325 0.0 0.0 L4 168/0 9.50 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.7 1.0 134.3 134.3 1.25 0.87 1 1.252 170K 0 0.0 0.0 L5 1056/0 86.68 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1268/16 100.86 GB 0.0 6.9 2.3 4.7 11.7 7.0 3.0 2.5 163.5 274.8 43.46 40.50 92 0.472 7214K 13K 0.0 0.0 Int 0/0 0.00 KB 0.0 6.9 2.3 4.7 11.7 7.0 2.9 2.5 163.5 274.8 43.46 40.50 92 0.472 7214K 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 6.9 2.3 4.7 6.9 2.3 0.0 0.0 240.8 240.3 29.50 28.05 23 1.283 7214K 13K 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 347.6 13.95 12.45 69 0.202 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 16.2 total, 16.0 interval Flush(GB): cumulative 4.737, interval 4.737 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 11.66 GB write, 736.68 MB/s write, 6.94 GB read, 438.29 MB/s read, 43.5 seconds Interval compaction: 11.66 GB write, 746.85 MB/s write, 6.94 GB read, 444.34 MB/s read, 43.5 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 5, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 5, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 19, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 5, total-stops: 19, interval: 24 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1542454 Average: 2.2344 StdDev: 11.98 Min: 0 Median: 1.5035 Max: 4111 Percentiles: P50: 1.50 P75: 1.87 P99: 5.54 P99.9: 9.83 P99.99: 53.31 ------------------------------------------------------ [ 0, 1 ] 242901 15.748% 15.748% ### ( 1, 2 ] 1049312 68.029% 83.776% ############## ( 2, 3 ] 154702 10.030% 93.806% ## ( 3, 4 ] 56683 3.675% 97.481% # ( 4, 6 ] 30455 1.974% 99.455% ( 6, 10 ] 7166 0.465% 99.920% ( 10, 15 ] 964 0.062% 99.982% ( 15, 22 ] 91 0.006% 99.988% ( 22, 34 ] 16 0.001% 99.989% ( 34, 51 ] 8 0.001% 99.990% ( 51, 76 ] 19 0.001% 99.991% ( 76, 110 ] 105 0.007% 99.998% ( 110, 170 ] 154 0.010% 100.008% ( 170, 250 ] 89 0.006% 100.014% ( 250, 380 ] 62 0.004% 100.018% ( 380, 580 ] 35 0.002% 100.020% ( 580, 870 ] 31 0.002% 100.022% ( 870, 1300 ] 22 0.001% 100.023% ( 1300, 1900 ] 11 0.001% 100.024% ( 1900, 2900 ] 7 0.000% 100.025% ( 2900, 4400 ] 7 0.000% 100.025% ** Level 1 read latency histogram (micros): Count: 195640 Average: 2.8247 StdDev: 13.64 Min: 1 Median: 1.6090 Max: 1358 Percentiles: P50: 1.61 P75: 1.98 P99: 8.09 P99.9: 157.28 P99.99: 485.06 ------------------------------------------------------ [ 0, 1 ] 16682 8.527% 8.527% ## ( 1, 2 ] 133235 68.102% 76.629% ############## ( 2, 3 ] 27676 14.146% 90.775% ### ( 3, 4 ] 8851 4.524% 95.300% # ( 4, 6 ] 6008 3.071% 98.370% # ( 6, 10 ] 2358 1.205% 99.576% ( 10, 15 ] 336 0.172% 99.747% ( 15, 22 ] 63 0.032% 99.780% ( 22, 34 ] 8 0.004% 99.784% ( 34, 51 ] 2 0.001% 99.785% ( 51, 76 ] 31 0.016% 99.801% ( 76, 110 ] 48 0.025% 99.825% ( 110, 170 ] 187 0.096% 99.921% ( 170, 250 ] 72 0.037% 99.958% ( 250, 380 ] 45 0.023% 99.981% ( 380, 580 ] 37 0.019% 99.999% ( 580, 870 ] 11 0.006% 100.005% ( 870, 1300 ] 7 0.004% 100.009% ( 1300, 1900 ] 1 0.001% 100.009% ** Level 2 read latency histogram (micros): Count: 77271 Average: 2.8270 StdDev: 22.17 Min: 1 Median: 1.5680 Max: 3268 Percentiles: P50: 1.57 P75: 1.94 P99: 7.44 P99.9: 152.87 P99.99: 834.86 ------------------------------------------------------ [ 0, 1 ] 8785 11.369% 11.369% ## ( 1, 2 ] 52556 68.015% 79.384% ############## ( 2, 3 ] 9207 11.915% 91.299% ## ( 3, 4 ] 3534 4.574% 95.873% # ( 4, 6 ] 2113 2.735% 98.607% # ( 6, 10 ] 840 1.087% 99.695% ( 10, 15 ] 75 0.097% 99.792% ( 15, 22 ] 12 0.016% 99.807% ( 51, 76 ] 3 0.004% 99.811% ( 76, 110 ] 33 0.043% 99.854% ( 110, 170 ] 50 0.065% 99.918% ( 170, 250 ] 17 0.022% 99.940% ( 250, 380 ] 17 0.022% 99.962% ( 380, 580 ] 16 0.021% 99.983% ( 580, 870 ] 6 0.008% 99.991% ( 870, 1300 ] 2 0.003% 99.994% ( 1300, 1900 ] 4 0.005% 99.999% ( 1900, 2900 ] 1 0.001% 100.000% ( 2900, 4400 ] 1 0.001% 100.001% ** Level 3 read latency histogram (micros): Count: 252696 Average: 3.6282 StdDev: 34.79 Min: 0 Median: 1.6346 Max: 6363 Percentiles: P50: 1.63 P75: 2.08 P99: 8.97 P99.9: 241.82 P99.99: 688.64 ------------------------------------------------------ [ 0, 1 ] 22331 8.837% 8.837% ## ( 1, 2 ] 163910 64.865% 73.702% ############# ( 2, 3 ] 41036 16.239% 89.941% ### ( 3, 4 ] 12235 4.842% 94.783% # ( 4, 6 ] 7864 3.112% 97.895% # ( 6, 10 ] 3756 1.486% 99.381% ( 10, 15 ] 362 0.143% 99.524% ( 15, 22 ] 73 0.029% 99.553% ( 22, 34 ] 34 0.013% 99.567% ( 34, 51 ] 6 0.002% 99.569% ( 51, 76 ] 12 0.005% 99.574% ( 76, 110 ] 208 0.082% 99.656% ( 110, 170 ] 461 0.182% 99.839% ( 170, 250 ] 173 0.068% 99.907% ( 250, 380 ] 111 0.044% 99.951% ( 380, 580 ] 80 0.032% 99.983% ( 580, 870 ] 50 0.020% 100.002% ( 870, 1300 ] 27 0.011% 100.013% ( 1300, 1900 ] 7 0.003% 100.016% ( 1900, 2900 ] 11 0.004% 100.020% ( 2900, 4400 ] 5 0.002% 100.022% ( 4400, 6600 ] 2 0.001% 100.023% ** Level 4 read latency histogram (micros): Count: 315 Average: 145.6508 StdDev: 596.98 Min: 1 Median: 1.6304 Max: 4927 Percentiles: P50: 1.63 P75: 4.94 P99: 3825.00 P99.9: 4927.00 P99.99: 4927.00 ------------------------------------------------------ [ 0, 1 ] 56 17.778% 17.778% #### ( 1, 2 ] 161 51.111% 68.889% ########## ( 2, 3 ] 13 4.127% 73.016% # ( 3, 4 ] 2 0.635% 73.651% ( 4, 6 ] 9 2.857% 76.508% # ( 6, 10 ] 46 14.603% 91.111% ### ( 10, 15 ] 2 0.635% 91.746% ( 22, 34 ] 1 0.317% 92.063% ( 380, 580 ] 2 0.635% 92.698% ( 580, 870 ] 2 0.635% 93.333% ( 870, 1300 ] 8 2.540% 95.873% # ( 1300, 1900 ] 6 1.905% 97.778% ( 1900, 2900 ] 2 0.635% 98.413% ( 2900, 4400 ] 3 0.952% 99.365% ( 4400, 6600 ] 2 0.635% 100.000% ** Level 5 read latency histogram (micros): Count: 60 Average: 918.2833 StdDev: 995.58 Min: 112 Median: 513.3333 Max: 3918 Percentiles: P50: 513.33 P75: 1300.00 P99: 3918.00 P99.9: 3918.00 P99.99: 3918.00 ------------------------------------------------------ ( 110, 170 ] 11 18.333% 18.333% #### ( 170, 250 ] 7 11.667% 30.000% ## ( 250, 380 ] 8 13.333% 43.333% ### ( 380, 580 ] 6 10.000% 53.333% ## ( 580, 870 ] 11 18.333% 71.667% #### ( 870, 1300 ] 2 3.333% 75.000% # ( 1300, 1900 ] 2 3.333% 78.333% # ( 1900, 2900 ] 9 15.000% 93.333% ### ( 2900, 4400 ] 4 6.667% 100.000% # ** DB Stats ** Uptime(secs): 16.2 total, 3.8 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 303.57 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:2.478 H:M:S, 15.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 256.12 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:1.082 H:M:S, 28.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/08/10-07:09:52 ... thread 0: (1000000,6000000) ops and (124954.6,250099.2) ops/second in (8.002904,23.990476) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 12/11 2.27 GB 6.3 5.0 0.0 5.0 10.7 5.7 0.0 1.9 142.8 302.7 36.18 33.95 99 0.365 5244K 8910 0.0 0.0 L1 12/12 1.42 GB 0.0 3.7 3.2 0.5 3.6 3.2 0.2 1.1 227.7 225.7 16.52 15.80 3 5.506 3818K 32K 0.0 0.0 L2 5/3 640.02 MB 2.6 0.2 0.1 0.1 0.2 0.1 1.8 1.5 244.3 244.2 0.79 0.76 2 0.395 195K 101 0.0 0.0 L3 29/9 1.26 GB 0.8 2.6 1.1 1.4 2.6 1.1 0.3 2.2 216.1 215.3 12.15 11.20 8 1.518 2666K 10K 0.0 0.0 L4 168/0 9.50 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.7 1.0 134.3 134.3 1.25 0.87 1 1.252 170K 0 0.0 0.0 L5 1056/0 86.68 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1282/35 101.75 GB 0.0 11.6 4.6 7.0 17.2 10.2 4.0 3.0 178.1 264.0 66.89 62.59 113 0.592 12M 51K 0.0 0.0 Int 0/0 0.00 KB 0.0 11.6 4.6 7.0 17.2 10.2 3.9 3.0 178.1 264.0 66.89 62.59 113 0.592 12M 51K 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 11.6 4.6 7.0 11.6 4.6 0.0 0.0 237.8 236.7 50.10 47.62 30 1.670 12M 51K 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 345.2 16.79 14.96 83 0.202 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 24.2 total, 24.0 interval Flush(GB): cumulative 5.660, interval 5.660 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: 17.24 GB write, 729.20 MB/s write, 11.63 GB read, 491.99 MB/s read, 66.9 seconds Interval compaction: 17.24 GB write, 735.91 MB/s write, 11.63 GB read, 496.52 MB/s read, 66.9 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 11, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 11, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 21, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 11, total-stops: 21, interval: 32 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2272326 Average: 2.4134 StdDev: 13.83 Min: 0 Median: 1.4996 Max: 4111 Percentiles: P50: 1.50 P75: 1.87 P99: 5.74 P99.9: 83.18 P99.99: 233.58 ------------------------------------------------------ [ 0, 1 ] 365875 16.101% 16.101% ### ( 1, 2 ] 1541748 67.849% 83.950% ############## ( 2, 3 ] 221773 9.760% 93.710% ## ( 3, 4 ] 80896 3.560% 97.270% # ( 4, 6 ] 45198 1.989% 99.259% ( 6, 10 ] 12649 0.557% 99.816% ( 10, 15 ] 1488 0.065% 99.881% ( 15, 22 ] 166 0.007% 99.889% ( 22, 34 ] 27 0.001% 99.890% ( 34, 51 ] 13 0.001% 99.890% ( 51, 76 ] 31 0.001% 99.892% ( 76, 110 ] 903 0.040% 99.931% ( 110, 170 ] 1057 0.047% 99.978% ( 170, 250 ] 347 0.015% 99.993% ( 250, 380 ] 306 0.013% 100.007% ( 380, 580 ] 209 0.009% 100.016% ( 580, 870 ] 101 0.004% 100.020% ( 870, 1300 ] 44 0.002% 100.022% ( 1300, 1900 ] 16 0.001% 100.023% ( 1900, 2900 ] 10 0.000% 100.023% ( 2900, 4400 ] 10 0.000% 100.024% ** Level 1 read latency histogram (micros): Count: 419967 Average: 2.9638 StdDev: 18.16 Min: 1 Median: 1.6024 Max: 3382 Percentiles: P50: 1.60 P75: 1.97 P99: 8.19 P99.9: 162.47 P99.99: 512.72 ------------------------------------------------------ [ 0, 1 ] 39992 9.523% 9.523% ## ( 1, 2 ] 282183 67.192% 76.714% ############# ( 2, 3 ] 57239 13.629% 90.344% ### ( 3, 4 ] 19694 4.689% 95.033% # ( 4, 6 ] 13630 3.245% 98.279% # ( 6, 10 ] 5526 1.316% 99.594% ( 10, 15 ] 579 0.138% 99.732% ( 15, 22 ] 83 0.020% 99.752% ( 22, 34 ] 8 0.002% 99.754% ( 34, 51 ] 3 0.001% 99.755% ( 51, 76 ] 36 0.009% 99.763% ( 76, 110 ] 240 0.057% 99.820% ( 110, 170 ] 382 0.091% 99.911% ( 170, 250 ] 152 0.036% 99.948% ( 250, 380 ] 107 0.025% 99.973% ( 380, 580 ] 107 0.025% 99.999% ( 580, 870 ] 49 0.012% 100.010% ( 870, 1300 ] 19 0.005% 100.015% ( 1300, 1900 ] 7 0.002% 100.016% ( 1900, 2900 ] 3 0.001% 100.017% ( 2900, 4400 ] 1 0.000% 100.017% ** Level 2 read latency histogram (micros): Count: 77271 Average: 2.8270 StdDev: 22.17 Min: 1 Median: 1.5680 Max: 3268 Percentiles: P50: 1.57 P75: 1.94 P99: 7.44 P99.9: 152.87 P99.99: 834.86 ------------------------------------------------------ [ 0, 1 ] 8785 11.369% 11.369% ## ( 1, 2 ] 52556 68.015% 79.384% ############## ( 2, 3 ] 9207 11.915% 91.299% ## ( 3, 4 ] 3534 4.574% 95.873% # ( 4, 6 ] 2113 2.735% 98.607% # ( 6, 10 ] 840 1.087% 99.695% ( 10, 15 ] 75 0.097% 99.792% ( 15, 22 ] 12 0.016% 99.807% ( 51, 76 ] 3 0.004% 99.811% ( 76, 110 ] 33 0.043% 99.854% ( 110, 170 ] 50 0.065% 99.918% ( 170, 250 ] 17 0.022% 99.940% ( 250, 380 ] 17 0.022% 99.962% ( 380, 580 ] 16 0.021% 99.983% ( 580, 870 ] 6 0.008% 99.991% ( 870, 1300 ] 2 0.003% 99.994% ( 1300, 1900 ] 4 0.005% 99.999% ( 1900, 2900 ] 1 0.001% 100.000% ( 2900, 4400 ] 1 0.001% 100.001% ** Level 3 read latency histogram (micros): Count: 362296 Average: 3.8080 StdDev: 33.09 Min: 0 Median: 1.6782 Max: 6363 Percentiles: P50: 1.68 P75: 2.27 P99: 9.14 P99.9: 272.35 P99.99: 605.95 ------------------------------------------------------ [ 0, 1 ] 25549 7.052% 7.052% # ( 1, 2 ] 229430 63.327% 70.379% ############# ( 2, 3 ] 63182 17.439% 87.818% ### ( 3, 4 ] 21053 5.811% 93.629% # ( 4, 6 ] 14732 4.066% 97.695% # ( 6, 10 ] 6017 1.661% 99.356% ( 10, 15 ] 613 0.169% 99.525% ( 15, 22 ] 102 0.028% 99.553% ( 22, 34 ] 38 0.010% 99.564% ( 34, 51 ] 7 0.002% 99.566% ( 51, 76 ] 16 0.004% 99.570% ( 76, 110 ] 269 0.074% 99.644% ( 110, 170 ] 601 0.166% 99.810% ( 170, 250 ] 293 0.081% 99.891% ( 250, 380 ] 196 0.054% 99.945% ( 380, 580 ] 155 0.043% 99.988% ( 580, 870 ] 98 0.027% 100.015% ( 870, 1300 ] 41 0.011% 100.026% ( 1300, 1900 ] 10 0.003% 100.029% ( 1900, 2900 ] 13 0.004% 100.033% ( 2900, 4400 ] 5 0.001% 100.034% ( 4400, 6600 ] 2 0.001% 100.035% ** Level 4 read latency histogram (micros): Count: 315 Average: 145.6508 StdDev: 596.98 Min: 1 Median: 1.6304 Max: 4927 Percentiles: P50: 1.63 P75: 4.94 P99: 3825.00 P99.9: 4927.00 P99.99: 4927.00 ------------------------------------------------------ [ 0, 1 ] 56 17.778% 17.778% #### ( 1, 2 ] 161 51.111% 68.889% ########## ( 2, 3 ] 13 4.127% 73.016% # ( 3, 4 ] 2 0.635% 73.651% ( 4, 6 ] 9 2.857% 76.508% # ( 6, 10 ] 46 14.603% 91.111% ### ( 10, 15 ] 2 0.635% 91.746% ( 22, 34 ] 1 0.317% 92.063% ( 380, 580 ] 2 0.635% 92.698% ( 580, 870 ] 2 0.635% 93.333% ( 870, 1300 ] 8 2.540% 95.873% # ( 1300, 1900 ] 6 1.905% 97.778% ( 1900, 2900 ] 2 0.635% 98.413% ( 2900, 4400 ] 3 0.952% 99.365% ( 4400, 6600 ] 2 0.635% 100.000% ** Level 5 read latency histogram (micros): Count: 60 Average: 918.2833 StdDev: 995.58 Min: 112 Median: 513.3333 Max: 3918 Percentiles: P50: 513.33 P75: 1300.00 P99: 3918.00 P99.9: 3918.00 P99.99: 3918.00 ------------------------------------------------------ ( 110, 170 ] 11 18.333% 18.333% #### ( 170, 250 ] 7 11.667% 30.000% ## ( 250, 380 ] 8 13.333% 43.333% ### ( 380, 580 ] 6 10.000% 53.333% ## ( 580, 870 ] 11 18.333% 71.667% #### ( 870, 1300 ] 2 3.333% 75.000% # ( 1300, 1900 ] 2 3.333% 78.333% # ( 1900, 2900 ] 9 15.000% 93.333% ### ( 2900, 4400 ] 4 6.667% 100.000% # ** DB Stats ** Uptime(secs): 24.2 total, 8.0 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 243.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:7.528 H:M:S, 31.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 122.98 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:5.049 H:M:S, 63.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 5 num-running-flushes: 1 2024/08/10-07:09:56 ... thread 0: (1000000,7000000) ops and (250797.4,250198.7) ops/second in (3.987282,27.977758) 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/11 3.19 GB 100.7 6.0 0.0 6.0 12.5 6.6 0.0 1.9 140.2 294.6 43.59 40.22 114 0.382 6203K 10K 0.0 0.0 L1 12/12 1.42 GB 0.0 3.7 3.2 0.5 3.6 3.2 0.2 1.1 227.7 225.7 16.52 15.80 3 5.506 3818K 32K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.2 0.1 0.1 0.2 0.1 1.8 1.5 244.3 244.2 0.79 0.76 2 0.395 195K 101 0.0 0.0 L3 23/0 977.32 MB 1.0 3.9 1.8 2.2 3.9 1.7 0.3 2.2 209.3 208.3 19.22 17.38 13 1.478 4085K 18K 0.0 0.0 L4 177/0 9.74 GB 1.0 1.1 1.1 0.1 1.1 1.1 0.7 1.0 131.0 130.8 8.91 5.43 20 0.446 1164K 1137 0.0 0.0 L5 1064/0 87.35 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1291/23 102.66 GB 0.0 14.9 6.2 8.7 21.4 12.7 4.7 3.3 171.3 246.3 89.02 79.60 152 0.586 15M 62K 0.0 0.0 Int 0/0 0.00 KB 0.0 14.9 6.2 8.7 21.4 12.7 4.5 3.3 171.3 246.3 89.02 79.60 152 0.586 15M 62K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 14.9 6.2 8.7 14.8 6.1 0.0 0.0 221.9 221.0 68.73 62.08 57 1.206 15M 62K 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 332.2 20.29 17.52 95 0.214 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): 28.2 total, 28.0 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: 21.42 GB write, 777.67 MB/s write, 14.90 GB read, 540.89 MB/s read, 89.0 seconds Interval compaction: 21.42 GB write, 783.80 MB/s write, 14.90 GB read, 545.15 MB/s read, 89.0 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 11, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 11, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 33, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 11, total-stops: 33, interval: 44 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2716339 Average: 2.5218 StdDev: 17.88 Min: 0 Median: 1.5402 Max: 7977 Percentiles: P50: 1.54 P75: 1.92 P99: 5.93 P99.9: 19.85 P99.99: 211.97 ------------------------------------------------------ [ 0, 1 ] 386876 14.243% 14.243% ### ( 1, 2 ] 1797882 66.188% 80.430% ############# ( 2, 3 ] 310045 11.414% 91.844% ## ( 3, 4 ] 118246 4.353% 96.197% # ( 4, 6 ] 78790 2.901% 99.098% # ( 6, 10 ] 19316 0.711% 99.809% ( 10, 15 ] 2296 0.085% 99.894% ( 15, 22 ] 248 0.009% 99.903% ( 22, 34 ] 31 0.001% 99.904% ( 34, 51 ] 14 0.001% 99.904% ( 51, 76 ] 35 0.001% 99.906% ( 76, 110 ] 936 0.034% 99.940% ( 110, 170 ] 1142 0.042% 99.982% ( 170, 250 ] 401 0.015% 99.997% ( 250, 380 ] 350 0.013% 100.010% ( 380, 580 ] 237 0.009% 100.019% ( 580, 870 ] 121 0.004% 100.023% ( 870, 1300 ] 58 0.002% 100.025% ( 1300, 1900 ] 24 0.001% 100.026% ( 1900, 2900 ] 20 0.001% 100.027% ( 2900, 4400 ] 18 0.001% 100.028% ( 4400, 6600 ] 4 0.000% 100.028% ( 6600, 9900 ] 2 0.000% 100.028% ** Level 1 read latency histogram (micros): Count: 588192 Average: 3.4030 StdDev: 36.79 Min: 1 Median: 1.6601 Max: 11319 Percentiles: P50: 1.66 P75: 2.20 P99: 8.57 P99.9: 168.36 P99.99: 574.12 ------------------------------------------------------ [ 0, 1 ] 44765 7.611% 7.611% ## ( 1, 2 ] 377689 64.212% 71.822% ############# ( 2, 3 ] 92202 15.675% 87.498% ### ( 3, 4 ] 34932 5.939% 93.437% # ( 4, 6 ] 26687 4.537% 97.974% # ( 6, 10 ] 9408 1.599% 99.573% ( 10, 15 ] 1030 0.175% 99.749% ( 15, 22 ] 146 0.025% 99.773% ( 22, 34 ] 8 0.001% 99.775% ( 34, 51 ] 3 0.001% 99.775% ( 51, 76 ] 40 0.007% 99.782% ( 76, 110 ] 259 0.044% 99.826% ( 110, 170 ] 447 0.076% 99.902% ( 170, 250 ] 202 0.034% 99.936% ( 250, 380 ] 156 0.027% 99.963% ( 380, 580 ] 164 0.028% 99.991% ( 580, 870 ] 86 0.015% 100.005% ( 870, 1300 ] 61 0.010% 100.016% ( 1300, 1900 ] 32 0.005% 100.021% ( 1900, 2900 ] 19 0.003% 100.024% ( 2900, 4400 ] 12 0.002% 100.027% ( 4400, 6600 ] 4 0.001% 100.027% ( 6600, 9900 ] 1 0.000% 100.027% ( 9900, 14000 ] 1 0.000% 100.028% ** Level 2 read latency histogram (micros): Count: 77271 Average: 2.8270 StdDev: 22.17 Min: 1 Median: 1.5680 Max: 3268 Percentiles: P50: 1.57 P75: 1.94 P99: 7.44 P99.9: 152.87 P99.99: 834.86 ------------------------------------------------------ [ 0, 1 ] 8785 11.369% 11.369% ## ( 1, 2 ] 52556 68.015% 79.384% ############## ( 2, 3 ] 9207 11.915% 91.299% ## ( 3, 4 ] 3534 4.574% 95.873% # ( 4, 6 ] 2113 2.735% 98.607% # ( 6, 10 ] 840 1.087% 99.695% ( 10, 15 ] 75 0.097% 99.792% ( 15, 22 ] 12 0.016% 99.807% ( 51, 76 ] 3 0.004% 99.811% ( 76, 110 ] 33 0.043% 99.854% ( 110, 170 ] 50 0.065% 99.918% ( 170, 250 ] 17 0.022% 99.940% ( 250, 380 ] 17 0.022% 99.962% ( 380, 580 ] 16 0.021% 99.983% ( 580, 870 ] 6 0.008% 99.991% ( 870, 1300 ] 2 0.003% 99.994% ( 1300, 1900 ] 4 0.005% 99.999% ( 1900, 2900 ] 1 0.001% 100.000% ( 2900, 4400 ] 1 0.001% 100.001% ** Level 3 read latency histogram (micros): Count: 771521 Average: 4.0758 StdDev: 47.42 Min: 0 Median: 1.7965 Max: 7610 Percentiles: P50: 1.80 P75: 2.64 P99: 8.61 P99.9: 148.15 P99.99: 274.87 ------------------------------------------------------ [ 0, 1 ] 30997 4.018% 4.018% # ( 1, 2 ] 445413 57.732% 61.749% ############ ( 2, 3 ] 159969 20.734% 82.484% #### ( 3, 4 ] 64429 8.351% 90.835% ## ( 4, 6 ] 55099 7.142% 97.976% # ( 6, 10 ] 12123 1.571% 99.548% ( 10, 15 ] 1707 0.221% 99.769% ( 15, 22 ] 181 0.023% 99.792% ( 22, 34 ] 44 0.006% 99.798% ( 34, 51 ] 15 0.002% 99.800% ( 51, 76 ] 19 0.002% 99.802% ( 76, 110 ] 304 0.039% 99.842% ( 110, 170 ] 707 0.092% 99.933% ( 170, 250 ] 385 0.050% 99.983% ( 250, 380 ] 271 0.035% 100.018% ( 380, 580 ] 257 0.033% 100.052% ( 580, 870 ] 201 0.026% 100.078% ( 870, 1300 ] 81 0.010% 100.088% ( 1300, 1900 ] 48 0.006% 100.094% ( 1900, 2900 ] 43 0.006% 100.100% ( 2900, 4400 ] 57 0.007% 100.107% ( 4400, 6600 ] 11 0.001% 100.109% ( 6600, 9900 ] 2 0.000% 100.109% ** Level 4 read latency histogram (micros): Count: 14370 Average: 109.5563 StdDev: 490.88 Min: 1 Median: 1.9648 Max: 7801 Percentiles: P50: 1.96 P75: 3.28 P99: 2773.15 P99.9: 5864.06 P99.99: 7801.00 ------------------------------------------------------ [ 0, 1 ] 422 2.937% 2.937% # ( 1, 2 ] 7010 48.782% 51.719% ########## ( 2, 3 ] 2920 20.320% 72.039% #### ( 3, 4 ] 1502 10.452% 82.491% ## ( 4, 6 ] 853 5.936% 88.427% # ( 6, 10 ] 338 2.352% 90.779% ( 10, 15 ] 37 0.257% 91.037% ( 15, 22 ] 5 0.035% 91.072% ( 22, 34 ] 3 0.021% 91.093% ( 34, 51 ] 1 0.007% 91.100% ( 76, 110 ] 13 0.090% 91.190% ( 110, 170 ] 80 0.557% 91.747% ( 170, 250 ] 74 0.515% 92.262% ( 250, 380 ] 129 0.898% 93.159% ( 380, 580 ] 172 1.197% 94.356% ( 580, 870 ] 223 1.552% 95.908% ( 870, 1300 ] 211 1.468% 97.376% ( 1300, 1900 ] 139 0.967% 98.344% ( 1900, 2900 ] 108 0.752% 99.095% ( 2900, 4400 ] 95 0.661% 99.756% ( 4400, 6600 ] 31 0.216% 99.972% ( 6600, 9900 ] 5 0.035% 100.007% ** Level 5 read latency histogram (micros): Count: 100 Average: 1138.7000 StdDev: 1201.24 Min: 98 Median: 618.6667 Max: 5415 Percentiles: P50: 618.67 P75: 2090.48 P99: 5415.00 P99.9: 5415.00 P99.99: 5415.00 ------------------------------------------------------ ( 76, 110 ] 2 2.000% 2.000% ( 110, 170 ] 14 14.000% 16.000% ### ( 170, 250 ] 12 12.000% 28.000% ## ( 250, 380 ] 12 12.000% 40.000% ## ( 380, 580 ] 8 8.000% 48.000% ## ( 580, 870 ] 15 15.000% 63.000% ### ( 870, 1300 ] 5 5.000% 68.000% # ( 1300, 1900 ] 3 3.000% 71.000% # ( 1900, 2900 ] 21 21.000% 92.000% #### ( 2900, 4400 ] 6 6.000% 98.000% # ( 4400, 6600 ] 2 2.000% 100.000% ** DB Stats ** Uptime(secs): 28.2 total, 4.0 interval Cumulative writes: 0 writes, 7000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 6.73 GB, 244.30 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:8.631 H:M:S, 30.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 246.83 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:1.103 H:M:S, 27.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/08/10-07:10:00 ... thread 0: (1000000,8000000) ops and (290399.3,254604.4) ops/second in (3.443535,31.421293) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 18/11 4.17 GB 207.6 7.1 0.0 7.1 14.6 7.6 0.0 1.9 142.6 294.9 50.79 47.03 133 0.382 7354K 11K 0.0 0.0 L1 12/12 1.42 GB 0.0 3.7 3.2 0.5 3.6 3.2 0.2 1.1 227.7 225.7 16.52 15.80 3 5.506 3818K 32K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.2 0.1 0.1 0.2 0.1 1.8 1.5 244.3 244.2 0.79 0.76 2 0.395 195K 101 0.0 0.0 L3 23/0 977.32 MB 1.0 3.9 1.8 2.2 3.9 1.7 0.3 2.2 209.3 208.3 19.22 17.38 13 1.478 4085K 18K 0.0 0.0 L4 177/0 9.74 GB 1.0 1.1 1.1 0.1 1.1 1.1 0.7 1.0 131.0 130.8 8.91 5.43 20 0.446 1164K 1137 0.0 0.0 L5 1064/0 87.35 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1294/23 103.64 GB 0.0 16.0 6.2 9.8 23.5 13.7 4.7 3.1 170.3 250.1 96.23 86.40 171 0.563 16M 63K 0.0 0.0 Int 0/0 0.00 KB 0.0 16.0 6.2 9.8 23.5 13.7 4.5 3.1 170.3 250.1 96.23 86.40 171 0.563 16M 63K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 16.0 6.2 9.8 15.9 6.1 0.0 0.0 224.5 223.6 72.99 66.26 61 1.197 16M 63K 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 333.4 23.24 20.14 110 0.211 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 31.6 total, 31.4 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: 23.51 GB write, 760.69 MB/s write, 16.00 GB read, 517.86 MB/s read, 96.2 seconds Interval compaction: 23.51 GB write, 766.03 MB/s write, 16.00 GB read, 521.50 MB/s read, 96.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: 36, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 15, total-stops: 36, interval: 51 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3070883 Average: 2.5000 StdDev: 17.25 Min: 0 Median: 1.5374 Max: 7977 Percentiles: P50: 1.54 P75: 1.91 P99: 5.91 P99.9: 15.00 P99.99: 205.82 ------------------------------------------------------ [ 0, 1 ] 437518 14.247% 14.247% ### ( 1, 2 ] 2042996 66.528% 80.775% ############# ( 2, 3 ] 347152 11.305% 92.080% ## ( 3, 4 ] 131327 4.277% 96.356% # ( 4, 6 ] 85017 2.768% 99.125% # ( 6, 10 ] 21291 0.693% 99.818% ( 10, 15 ] 2511 0.082% 99.900% ( 15, 22 ] 269 0.009% 99.909% ( 22, 34 ] 35 0.001% 99.910% ( 34, 51 ] 19 0.001% 99.911% ( 51, 76 ] 37 0.001% 99.912% ( 76, 110 ] 977 0.032% 99.944% ( 110, 170 ] 1229 0.040% 99.984% ( 170, 250 ] 442 0.014% 99.998% ( 250, 380 ] 381 0.012% 100.010% ( 380, 580 ] 264 0.009% 100.019% ( 580, 870 ] 133 0.004% 100.023% ( 870, 1300 ] 65 0.002% 100.025% ( 1300, 1900 ] 28 0.001% 100.026% ( 1900, 2900 ] 22 0.001% 100.027% ( 2900, 4400 ] 18 0.001% 100.028% ( 4400, 6600 ] 4 0.000% 100.028% ( 6600, 9900 ] 2 0.000% 100.028% ** Level 1 read latency histogram (micros): Count: 708213 Average: 3.2614 StdDev: 33.80 Min: 1 Median: 1.6425 Max: 11319 Percentiles: P50: 1.64 P75: 2.11 P99: 8.48 P99.9: 162.85 P99.99: 571.06 ------------------------------------------------------ [ 0, 1 ] 56868 8.030% 8.030% ## ( 1, 2 ] 462645 65.326% 73.355% ############# ( 2, 3 ] 106244 15.002% 88.357% ### ( 3, 4 ] 39286 5.547% 93.904% # ( 4, 6 ] 29171 4.119% 98.023% # ( 6, 10 ] 11153 1.575% 99.598% ( 10, 15 ] 1158 0.164% 99.762% ( 15, 22 ] 158 0.022% 99.784% ( 22, 34 ] 13 0.002% 99.786% ( 34, 51 ] 3 0.000% 99.786% ( 51, 76 ] 45 0.006% 99.793% ( 76, 110 ] 301 0.043% 99.835% ( 110, 170 ] 522 0.074% 99.909% ( 170, 250 ] 234 0.033% 99.942% ( 250, 380 ] 174 0.025% 99.966% ( 380, 580 ] 175 0.025% 99.991% ( 580, 870 ] 93 0.013% 100.004% ( 870, 1300 ] 63 0.009% 100.013% ( 1300, 1900 ] 32 0.005% 100.018% ( 1900, 2900 ] 19 0.003% 100.020% ( 2900, 4400 ] 12 0.002% 100.022% ( 4400, 6600 ] 4 0.001% 100.023% ( 6600, 9900 ] 1 0.000% 100.023% ( 9900, 14000 ] 1 0.000% 100.023% ** Level 2 read latency histogram (micros): Count: 77271 Average: 2.8270 StdDev: 22.17 Min: 1 Median: 1.5680 Max: 3268 Percentiles: P50: 1.57 P75: 1.94 P99: 7.44 P99.9: 152.87 P99.99: 834.86 ------------------------------------------------------ [ 0, 1 ] 8785 11.369% 11.369% ## ( 1, 2 ] 52556 68.015% 79.384% ############## ( 2, 3 ] 9207 11.915% 91.299% ## ( 3, 4 ] 3534 4.574% 95.873% # ( 4, 6 ] 2113 2.735% 98.607% # ( 6, 10 ] 840 1.087% 99.695% ( 10, 15 ] 75 0.097% 99.792% ( 15, 22 ] 12 0.016% 99.807% ( 51, 76 ] 3 0.004% 99.811% ( 76, 110 ] 33 0.043% 99.854% ( 110, 170 ] 50 0.065% 99.918% ( 170, 250 ] 17 0.022% 99.940% ( 250, 380 ] 17 0.022% 99.962% ( 380, 580 ] 16 0.021% 99.983% ( 580, 870 ] 6 0.008% 99.991% ( 870, 1300 ] 2 0.003% 99.994% ( 1300, 1900 ] 4 0.005% 99.999% ( 1900, 2900 ] 1 0.001% 100.000% ( 2900, 4400 ] 1 0.001% 100.001% ** Level 3 read latency histogram (micros): Count: 771521 Average: 4.0758 StdDev: 47.42 Min: 0 Median: 1.7965 Max: 7610 Percentiles: P50: 1.80 P75: 2.64 P99: 8.61 P99.9: 148.15 P99.99: 274.87 ------------------------------------------------------ [ 0, 1 ] 30997 4.018% 4.018% # ( 1, 2 ] 445413 57.732% 61.749% ############ ( 2, 3 ] 159969 20.734% 82.484% #### ( 3, 4 ] 64429 8.351% 90.835% ## ( 4, 6 ] 55099 7.142% 97.976% # ( 6, 10 ] 12123 1.571% 99.548% ( 10, 15 ] 1707 0.221% 99.769% ( 15, 22 ] 181 0.023% 99.792% ( 22, 34 ] 44 0.006% 99.798% ( 34, 51 ] 15 0.002% 99.800% ( 51, 76 ] 19 0.002% 99.802% ( 76, 110 ] 304 0.039% 99.842% ( 110, 170 ] 707 0.092% 99.933% ( 170, 250 ] 385 0.050% 99.983% ( 250, 380 ] 271 0.035% 100.018% ( 380, 580 ] 257 0.033% 100.052% ( 580, 870 ] 201 0.026% 100.078% ( 870, 1300 ] 81 0.010% 100.088% ( 1300, 1900 ] 48 0.006% 100.094% ( 1900, 2900 ] 43 0.006% 100.100% ( 2900, 4400 ] 57 0.007% 100.107% ( 4400, 6600 ] 11 0.001% 100.109% ( 6600, 9900 ] 2 0.000% 100.109% ** Level 4 read latency histogram (micros): Count: 14370 Average: 109.5563 StdDev: 490.88 Min: 1 Median: 1.9648 Max: 7801 Percentiles: P50: 1.96 P75: 3.28 P99: 2773.15 P99.9: 5864.06 P99.99: 7801.00 ------------------------------------------------------ [ 0, 1 ] 422 2.937% 2.937% # ( 1, 2 ] 7010 48.782% 51.719% ########## ( 2, 3 ] 2920 20.320% 72.039% #### ( 3, 4 ] 1502 10.452% 82.491% ## ( 4, 6 ] 853 5.936% 88.427% # ( 6, 10 ] 338 2.352% 90.779% ( 10, 15 ] 37 0.257% 91.037% ( 15, 22 ] 5 0.035% 91.072% ( 22, 34 ] 3 0.021% 91.093% ( 34, 51 ] 1 0.007% 91.100% ( 76, 110 ] 13 0.090% 91.190% ( 110, 170 ] 80 0.557% 91.747% ( 170, 250 ] 74 0.515% 92.262% ( 250, 380 ] 129 0.898% 93.159% ( 380, 580 ] 172 1.197% 94.356% ( 580, 870 ] 223 1.552% 95.908% ( 870, 1300 ] 211 1.468% 97.376% ( 1300, 1900 ] 139 0.967% 98.344% ( 1900, 2900 ] 108 0.752% 99.095% ( 2900, 4400 ] 95 0.661% 99.756% ( 4400, 6600 ] 31 0.216% 99.972% ( 6600, 9900 ] 5 0.035% 100.007% ** Level 5 read latency histogram (micros): Count: 100 Average: 1138.7000 StdDev: 1201.24 Min: 98 Median: 618.6667 Max: 5415 Percentiles: P50: 618.67 P75: 2090.48 P99: 5415.00 P99.9: 5415.00 P99.99: 5415.00 ------------------------------------------------------ ( 76, 110 ] 2 2.000% 2.000% ( 110, 170 ] 14 14.000% 16.000% ### ( 170, 250 ] 12 12.000% 28.000% ## ( 250, 380 ] 12 12.000% 40.000% ## ( 380, 580 ] 8 8.000% 48.000% ## ( 580, 870 ] 15 15.000% 63.000% ### ( 870, 1300 ] 5 5.000% 68.000% # ( 1300, 1900 ] 3 3.000% 71.000% # ( 1900, 2900 ] 21 21.000% 92.000% #### ( 2900, 4400 ] 6 6.000% 98.000% # ( 4400, 6600 ] 2 2.000% 100.000% ** DB Stats ** Uptime(secs): 31.6 total, 3.4 interval Cumulative writes: 0 writes, 8000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 7.69 GB, 248.82 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:9.338 H:M:S, 29.5 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 285.81 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.708 H:M:S, 20.6 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/08/10-07:10:12 ... thread 0: (1000000,9000000) ops and (80323.3,205147.0) ops/second in (12.449687,43.870980) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 13/11 3.19 GB 37.8 8.6 0.0 8.6 17.1 8.5 0.0 2.0 147.8 293.3 59.66 55.20 151 0.395 8953K 14K 0.0 0.0 L1 19/19 2.31 GB 0.0 7.0 5.1 1.9 6.9 5.0 0.2 1.4 223.6 221.3 32.01 30.25 4 8.002 7268K 74K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.2 0.1 0.1 0.2 0.1 2.8 1.5 244.3 244.2 0.79 0.76 2 0.395 195K 101 0.0 0.0 L3 21/0 946.05 MB 0.9 5.9 2.7 3.2 5.9 2.7 0.3 2.1 202.2 201.2 29.88 26.46 21 1.423 6137K 32K 0.0 0.0 L4 174/0 9.74 GB 1.0 2.3 2.1 0.3 2.3 2.1 0.7 1.1 156.9 156.4 15.26 10.99 32 0.477 2372K 4360 0.0 0.0 L5 1076/0 88.34 GB 0.9 0.0 0.0 0.0 0.0 0.0 2.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1303/30 104.50 GB 0.0 24.0 10.0 14.0 32.4 18.4 6.6 3.8 178.8 241.1 137.59 123.65 210 0.655 24M 125K 0.0 0.0 Int 0/0 0.00 KB 0.0 24.0 10.0 14.0 32.4 18.4 6.5 3.8 178.8 241.1 137.59 123.65 210 0.655 24M 125K 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 24.0 10.0 14.0 23.9 9.9 0.0 0.0 220.9 219.8 111.36 101.08 86 1.295 24M 125K 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 331.4 26.23 22.57 124 0.212 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 44.1 total, 43.9 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: 32.39 GB write, 752.25 MB/s write, 24.03 GB read, 558.00 MB/s read, 137.6 seconds Interval compaction: 32.39 GB write, 756.03 MB/s write, 24.03 GB read, 560.81 MB/s read, 137.6 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 18, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 18, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 37, pending-compaction-bytes-delays: 23, pending-compaction-bytes-stops: 0, total-delays: 41, total-stops: 37, interval: 78 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3921182 Average: 2.5635 StdDev: 17.70 Min: 0 Median: 1.5343 Max: 7977 Percentiles: P50: 1.53 P75: 1.91 P99: 5.97 P99.9: 88.50 P99.99: 285.19 ------------------------------------------------------ [ 0, 1 ] 566705 14.452% 14.452% ### ( 1, 2 ] 2609038 66.537% 80.989% ############# ( 2, 3 ] 434163 11.072% 92.062% ## ( 3, 4 ] 165630 4.224% 96.286% # ( 4, 6 ] 107972 2.754% 99.039% # ( 6, 10 ] 29295 0.747% 99.786% ( 10, 15 ] 3375 0.086% 99.872% ( 15, 22 ] 382 0.010% 99.882% ( 22, 34 ] 47 0.001% 99.883% ( 34, 51 ] 28 0.001% 99.884% ( 51, 76 ] 57 0.001% 99.885% ( 76, 110 ] 1547 0.039% 99.925% ( 110, 170 ] 1770 0.045% 99.970% ( 170, 250 ] 632 0.016% 99.986% ( 250, 380 ] 550 0.014% 100.000% ( 380, 580 ] 478 0.012% 100.012% ( 580, 870 ] 258 0.007% 100.019% ( 870, 1300 ] 123 0.003% 100.022% ( 1300, 1900 ] 48 0.001% 100.023% ( 1900, 2900 ] 28 0.001% 100.024% ( 2900, 4400 ] 20 0.001% 100.025% ( 4400, 6600 ] 4 0.000% 100.025% ( 6600, 9900 ] 2 0.000% 100.025% ** Level 1 read latency histogram (micros): Count: 1198028 Average: 3.3856 StdDev: 33.73 Min: 1 Median: 1.6388 Max: 11319 Percentiles: P50: 1.64 P75: 2.15 P99: 8.54 P99.9: 153.73 P99.99: 500.46 ------------------------------------------------------ [ 0, 1 ] 114929 9.593% 9.593% ## ( 1, 2 ] 757779 63.252% 72.845% ############# ( 2, 3 ] 174678 14.580% 87.426% ### ( 3, 4 ] 70385 5.875% 93.301% # ( 4, 6 ] 55860 4.663% 97.964% # ( 6, 10 ] 19557 1.632% 99.596% ( 10, 15 ] 2018 0.168% 99.764% ( 15, 22 ] 288 0.024% 99.788% ( 22, 34 ] 23 0.002% 99.790% ( 34, 51 ] 3 0.000% 99.791% ( 51, 76 ] 96 0.008% 99.799% ( 76, 110 ] 644 0.054% 99.852% ( 110, 170 ] 782 0.065% 99.918% ( 170, 250 ] 350 0.029% 99.947% ( 250, 380 ] 306 0.026% 99.972% ( 380, 580 ] 349 0.029% 100.002% ( 580, 870 ] 234 0.020% 100.021% ( 870, 1300 ] 163 0.014% 100.035% ( 1300, 1900 ] 76 0.006% 100.041% ( 1900, 2900 ] 34 0.003% 100.044% ( 2900, 4400 ] 18 0.002% 100.045% ( 4400, 6600 ] 7 0.001% 100.046% ( 6600, 9900 ] 1 0.000% 100.046% ( 9900, 14000 ] 1 0.000% 100.046% ** Level 2 read latency histogram (micros): Count: 77271 Average: 2.8270 StdDev: 22.17 Min: 1 Median: 1.5680 Max: 3268 Percentiles: P50: 1.57 P75: 1.94 P99: 7.44 P99.9: 152.87 P99.99: 834.86 ------------------------------------------------------ [ 0, 1 ] 8785 11.369% 11.369% ## ( 1, 2 ] 52556 68.015% 79.384% ############## ( 2, 3 ] 9207 11.915% 91.299% ## ( 3, 4 ] 3534 4.574% 95.873% # ( 4, 6 ] 2113 2.735% 98.607% # ( 6, 10 ] 840 1.087% 99.695% ( 10, 15 ] 75 0.097% 99.792% ( 15, 22 ] 12 0.016% 99.807% ( 51, 76 ] 3 0.004% 99.811% ( 76, 110 ] 33 0.043% 99.854% ( 110, 170 ] 50 0.065% 99.918% ( 170, 250 ] 17 0.022% 99.940% ( 250, 380 ] 17 0.022% 99.962% ( 380, 580 ] 16 0.021% 99.983% ( 580, 870 ] 6 0.008% 99.991% ( 870, 1300 ] 2 0.003% 99.994% ( 1300, 1900 ] 4 0.005% 99.999% ( 1900, 2900 ] 1 0.001% 100.000% ( 2900, 4400 ] 1 0.001% 100.001% ** Level 3 read latency histogram (micros): Count: 1287446 Average: 4.0133 StdDev: 42.36 Min: 0 Median: 1.8110 Max: 7610 Percentiles: P50: 1.81 P75: 2.68 P99: 8.47 P99.9: 125.66 P99.99: 251.22 ------------------------------------------------------ [ 0, 1 ] 43469 3.376% 3.376% # ( 1, 2 ] 740166 57.491% 60.867% ########### ( 2, 3 ] 266488 20.699% 81.566% #### ( 3, 4 ] 113510 8.817% 90.383% ## ( 4, 6 ] 98280 7.634% 98.017% ## ( 6, 10 ] 20514 1.593% 99.610% ( 10, 15 ] 2693 0.209% 99.819% ( 15, 22 ] 341 0.026% 99.846% ( 22, 34 ] 52 0.004% 99.850% ( 34, 51 ] 16 0.001% 99.851% ( 51, 76 ] 22 0.002% 99.853% ( 76, 110 ] 387 0.030% 99.883% ( 110, 170 ] 845 0.066% 99.949% ( 170, 250 ] 530 0.041% 99.990% ( 250, 380 ] 452 0.035% 100.025% ( 380, 580 ] 450 0.035% 100.060% ( 580, 870 ] 412 0.032% 100.092% ( 870, 1300 ] 213 0.017% 100.108% ( 1300, 1900 ] 83 0.006% 100.115% ( 1900, 2900 ] 52 0.004% 100.119% ( 2900, 4400 ] 67 0.005% 100.124% ( 4400, 6600 ] 11 0.001% 100.125% ( 6600, 9900 ] 2 0.000% 100.125% ** Level 4 read latency histogram (micros): Count: 69291 Average: 31.6926 StdDev: 234.62 Min: 0 Median: 1.8993 Max: 7801 Percentiles: P50: 1.90 P75: 2.95 P99: 813.45 P99.9: 3707.95 P99.99: 5682.45 ------------------------------------------------------ [ 0, 1 ] 1775 2.562% 2.562% # ( 1, 2 ] 36550 52.749% 55.310% ########### ( 2, 3 ] 14423 20.815% 76.125% #### ( 3, 4 ] 6790 9.799% 85.925% ## ( 4, 6 ] 4977 7.183% 93.107% # ( 6, 10 ] 1636 2.361% 95.468% ( 10, 15 ] 185 0.267% 95.735% ( 15, 22 ] 30 0.043% 95.779% ( 22, 34 ] 9 0.013% 95.792% ( 34, 51 ] 1 0.001% 95.793% ( 51, 76 ] 6 0.009% 95.802% ( 76, 110 ] 228 0.329% 96.131% ( 110, 170 ] 581 0.838% 96.969% ( 170, 250 ] 399 0.576% 97.545% ( 250, 380 ] 344 0.496% 98.042% ( 380, 580 ] 392 0.566% 98.607% ( 580, 870 ] 338 0.488% 99.095% ( 870, 1300 ] 247 0.356% 99.452% ( 1300, 1900 ] 144 0.208% 99.659% ( 1900, 2900 ] 115 0.166% 99.825% ( 2900, 4400 ] 96 0.139% 99.964% ( 4400, 6600 ] 31 0.045% 100.009% ( 6600, 9900 ] 5 0.007% 100.016% ** Level 5 read latency histogram (micros): Count: 160 Average: 982.2188 StdDev: 1088.12 Min: 70 Median: 480.0000 Max: 5415 Percentiles: P50: 480.00 P75: 1642.86 P99: 4840.00 P99.9: 5415.00 P99.99: 5415.00 ------------------------------------------------------ ( 51, 76 ] 1 0.625% 0.625% ( 76, 110 ] 8 5.000% 5.625% # ( 110, 170 ] 24 15.000% 20.625% ### ( 170, 250 ] 16 10.000% 30.625% ## ( 250, 380 ] 24 15.000% 45.625% ### ( 380, 580 ] 14 8.750% 54.375% ## ( 580, 870 ] 20 12.500% 66.875% ### ( 870, 1300 ] 9 5.625% 72.500% # ( 1300, 1900 ] 7 4.375% 76.875% # ( 1900, 2900 ] 27 16.875% 93.750% ### ( 2900, 4400 ] 8 5.000% 98.750% # ( 4400, 6600 ] 2 1.250% 100.000% ** DB Stats ** Uptime(secs): 44.1 total, 12.4 interval Cumulative writes: 0 writes, 9000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 8.65 GB, 200.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:18.673 H:M:S, 42.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 79.05 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:9.335 H:M:S, 75.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 using bdev Nvme0n1 Initializing RocksDB Options from the specified file Initializing RocksDB Options from command-line flags Integrated BlobDB: blob cache disabled Keys: 16 bytes each (+ 0 bytes user-defined timestamp) Values: 1000 bytes each (1000 bytes after compression) Entries: 100000000 Prefix: 0 bytes Keys per prefix: 0 RawSize: 96893.3 MB (estimated) FileSize: 96893.3 MB (estimated) Write rate: 0 bytes/second Read rate: 0 ops/second Compression: NoCompression Compression sampling rate: 0 Memtablerep: SkipListFactory Perf Level: 1 ------------------------------------------------ DB path: [/mnt/rocksdb] overwrite : 6.447 micros/op 155099 ops/sec 60.136 seconds 9326999 operations; 150.3 MB/s Microseconds per write: Count: 9326999 Average: 6.4475 StdDev: 289.18 Min: 1 Median: 1.7892 Max: 309617 Percentiles: P50: 1.79 P75: 2.86 P99: 10.43 P99.9: 1182.18 P99.99: 2644.92 ------------------------------------------------------ [ 0, 1 ] 1004407 10.769% 10.769% ## ( 1, 2 ] 4636736 49.713% 60.482% ########## ( 2, 3 ] 1577369 16.912% 77.394% ### ( 3, 4 ] 1302553 13.965% 91.359% ### ( 4, 6 ] 558044 5.983% 97.342% # ( 6, 10 ] 150193 1.610% 98.953% ( 10, 15 ] 51647 0.554% 99.506% ( 15, 22 ] 10053 0.108% 99.614% ( 22, 34 ] 1601 0.017% 99.631% ( 34, 51 ] 218 0.002% 99.634% ( 51, 76 ] 20 0.000% 99.634% ( 76, 110 ] 6372 0.068% 99.702% ( 110, 170 ] 2623 0.028% 99.730% ( 170, 250 ] 248 0.003% 99.733% ( 250, 380 ] 217 0.002% 99.735% ( 380, 580 ] 35 0.000% 99.736% ( 580, 870 ] 27 0.000% 99.736% ( 870, 1300 ] 21087 0.226% 99.962% ( 1300, 1900 ] 56 0.001% 99.963% ( 1900, 2900 ] 3437 0.037% 99.999% ( 2900, 4400 ] 25 0.000% 100.000% ( 4400, 6600 ] 9 0.000% 100.000% ( 6600, 9900 ] 2 0.000% 100.000% ( 14000, 22000 ] 1 0.000% 100.000% ( 22000, 33000 ] 2 0.000% 100.000% ( 110000, 170000 ] 1 0.000% 100.000% ( 170000, 250000 ] 15 0.000% 100.000% ( 250000, 380000 ] 1 0.000% 100.000% STATISTICS: rocksdb.block.cache.miss COUNT : 0 rocksdb.block.cache.hit COUNT : 0 rocksdb.block.cache.add COUNT : 0 rocksdb.block.cache.add.failures COUNT : 0 rocksdb.block.cache.index.miss COUNT : 0 rocksdb.block.cache.index.hit COUNT : 0 rocksdb.block.cache.index.add COUNT : 0 rocksdb.block.cache.index.bytes.insert COUNT : 0 rocksdb.block.cache.filter.miss COUNT : 0 rocksdb.block.cache.filter.hit COUNT : 0 rocksdb.block.cache.filter.add COUNT : 0 rocksdb.block.cache.filter.bytes.insert COUNT : 0 rocksdb.block.cache.data.miss COUNT : 0 rocksdb.block.cache.data.hit COUNT : 0 rocksdb.block.cache.data.add COUNT : 0 rocksdb.block.cache.data.bytes.insert COUNT : 0 rocksdb.block.cache.bytes.read COUNT : 0 rocksdb.block.cache.bytes.write COUNT : 0 rocksdb.bloom.filter.useful COUNT : 0 rocksdb.bloom.filter.full.positive COUNT : 0 rocksdb.bloom.filter.full.true.positive COUNT : 0 rocksdb.persistent.cache.hit COUNT : 0 rocksdb.persistent.cache.miss COUNT : 0 rocksdb.sim.block.cache.hit COUNT : 0 rocksdb.sim.block.cache.miss COUNT : 0 rocksdb.memtable.hit COUNT : 0 rocksdb.memtable.miss COUNT : 0 rocksdb.l0.hit COUNT : 0 rocksdb.l1.hit COUNT : 0 rocksdb.l2andup.hit COUNT : 0 rocksdb.compaction.key.drop.new COUNT : 219822 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 : 9326999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 9625462968 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 : 508 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 33384007 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 : 32343960033 rocksdb.compact.write.bytes COUNT : 32141479866 rocksdb.flush.write.bytes COUNT : 9578307227 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 : 41 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 : 253 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 : 9501123584 rocksdb.memtable.garbage.bytes.at.flush COUNT : 3742720 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 : 32426101751 rocksdb.non.last.level.read.count COUNT : 7840884 rocksdb.block.checksum.compute.count COUNT : 7839909 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.439709 P95 : 4.095691 P99 : 8.978550 P100 : 309612.000000 COUNT : 9326999 SUM : 55446844 rocksdb.compaction.times.micros P50 : 964193.548387 P95 : 3614000.000000 P99 : 14880000.000000 P100 : 15489047.000000 COUNT : 89 SUM : 117221962 rocksdb.compaction.times.cpu_micros P50 : 923142.857143 P95 : 3614000.000000 P99 : 14443394.000000 P100 : 14443394.000000 COUNT : 89 SUM : 106793119 rocksdb.subcompaction.setup.times.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.table.sync.micros P50 : 707.317073 P95 : 1450.000000 P99 : 12770.000000 P100 : 120699.000000 COUNT : 130 SUM : 233601 rocksdb.compaction.outfile.sync.micros P50 : 935.887097 P95 : 10412.500000 P99 : 34700.000000 P100 : 95823.000000 COUNT : 370 SUM : 948447 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 : 96.065574 P95 : 589.666667 P99 : 1276.657143 P100 : 3730.000000 COUNT : 238 SUM : 44890 rocksdb.table.open.io.micros P50 : 1225.862069 P95 : 6058.461538 P99 : 11212.000000 P100 : 15985.000000 COUNT : 508 SUM : 908520 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.644309 P95 : 7.153547 P99 : 9.942366 P100 : 11327.000000 COUNT : 7838358 SUM : 42083800 rocksdb.read.block.get.micros P50 : 366.021505 P95 : 2746.875000 P99 : 4392.258065 P100 : 7693.000000 COUNT : 1016 SUM : 741852 rocksdb.write.raw.block.micros P50 : 0.512963 P95 : 0.974630 P99 : 2.882987 P100 : 8511.000000 COUNT : 10104164 SUM : 18700421 rocksdb.numfiles.in.singlecompaction P50 : 3.141509 P95 : 6.900000 P99 : 21.615000 P100 : 26.000000 COUNT : 111 SUM : 426 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.563588 P95 : 1148.009931 P99 : 2273.527007 P100 : 309396.000000 COUNT : 219167 SUM : 33407452 rocksdb.sst.read.micros P50 : 1.572438 P95 : 4.098477 P99 : 7.881034 P100 : 11319.000000 COUNT : 7840916 SUM : 25803968 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 : 9326999 SUM : 9625462968 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 : 215048.543689 P95 : 367000.000000 P99 : 487174.000000 P100 : 487174.000000 COUNT : 130 SUM : 27511880 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 : 348 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