[2024-07-23 19:44:21.614084] Starting SPDK v24.01.1-pre git sha1 dbef7efac / DPDK 23.11.0 initialization... [2024-07-23 19:44:21.614227] [ 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_pid2022024 ] Set seed to 1721756661610744 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-07-23 19:44:21.716932] app.c: 798:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-07-23 19:44:21.752727] app.c: 488:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-07-23 19:44:21.752771] app.c: 489:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 2022024' to capture a snapshot of events at runtime. [2024-07-23 19:44:21.752782] app.c: 494:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid2022024 for offline analysis/debug. [2024-07-23 19:44:21.752810] reactor.c: 937:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Tue Jul 23 19:44:26 2024 CPU: 96 * Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz CPUCache: 36608 KB 2024/07/23-19:44:28 ... thread 0: (1000000,1000000) ops and (357136.1,357136.1) ops/second in (2.800053,2.800053) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 9/6 567.04 MB 18.9 0.0 0.0 0.0 0.8 0.8 0.0 1.0 0.0 352.8 2.32 2.09 12 0.193 0 0 0.0 0.0 L2 3/2 251.73 MB 0.0 0.4 0.2 0.2 0.4 0.2 0.1 2.0 246.6 246.5 1.53 1.48 2 0.766 383K 208 0.0 0.0 L3 10/0 804.28 MB 0.8 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.82 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/8 96.94 GB 0.0 0.4 0.2 0.2 1.2 1.0 0.2 1.5 98.1 310.5 3.85 3.57 14 0.275 383K 208 0.0 0.0 Int 0/0 0.00 KB 0.0 0.4 0.2 0.2 1.2 1.0 0.2 1.5 98.1 310.5 3.85 3.57 14 0.275 383K 208 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.2 0.2 0.4 0.2 0.0 0.0 246.6 246.5 1.53 1.48 2 0.766 383K 208 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 0.8 0.8 0.0 0.0 0.0 352.8 2.32 2.09 12 0.193 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 3.0 total, 2.8 interval Flush(GB): cumulative 0.800, interval 0.800 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 1.17 GB write, 401.32 MB/s write, 0.37 GB read, 126.74 MB/s read, 3.9 seconds Interval compaction: 1.17 GB write, 427.20 MB/s write, 0.37 GB read, 134.91 MB/s read, 3.9 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 2, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 2, interval: 2 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 100459 Average: 1.8301 StdDev: 17.79 Min: 0 Median: 1.1764 Max: 4172 Percentiles: P50: 1.18 P75: 1.63 P99: 3.72 P99.9: 9.16 P99.99: 291.34 ------------------------------------------------------ [ 0, 1 ] 40458 40.273% 40.273% ######## ( 1, 2 ] 55405 55.152% 95.425% ########### ( 2, 3 ] 2776 2.763% 98.188% # ( 3, 4 ] 1129 1.124% 99.312% ( 4, 6 ] 455 0.453% 99.765% ( 6, 10 ] 174 0.173% 99.938% ( 10, 15 ] 26 0.026% 99.964% ( 15, 22 ] 10 0.010% 99.974% ( 22, 34 ] 1 0.001% 99.975% ( 34, 51 ] 1 0.001% 99.976% ( 51, 76 ] 2 0.002% 99.978% ( 110, 170 ] 4 0.004% 99.982% ( 170, 250 ] 9 0.009% 99.991% ( 250, 380 ] 3 0.003% 99.994% ( 380, 580 ] 2 0.002% 99.996% ( 580, 870 ] 2 0.002% 99.998% ( 870, 1300 ] 1 0.001% 99.999% ( 1300, 1900 ] 1 0.001% 100.000% ( 2900, 4400 ] 2 0.002% 100.002% ** Level 2 read latency histogram (micros): Count: 51119 Average: 1.9877 StdDev: 16.64 Min: 1 Median: 1.2046 Max: 1688 Percentiles: P50: 1.20 P75: 1.66 P99: 4.69 P99.9: 9.93 P99.99: 1060.94 ------------------------------------------------------ [ 0, 1 ] 19827 38.786% 38.786% ######## ( 1, 2 ] 28016 54.805% 93.591% ########### ( 2, 3 ] 1734 3.392% 96.984% # ( 3, 4 ] 879 1.720% 98.703% ( 4, 6 ] 442 0.865% 99.568% ( 6, 10 ] 173 0.338% 99.906% ( 10, 15 ] 22 0.043% 99.949% ( 15, 22 ] 7 0.014% 99.963% ( 22, 34 ] 2 0.004% 99.967% ( 34, 51 ] 1 0.002% 99.969% ( 250, 380 ] 5 0.010% 99.978% ( 380, 580 ] 3 0.006% 99.984% ( 580, 870 ] 2 0.004% 99.988% ( 870, 1300 ] 2 0.004% 99.992% ( 1300, 1900 ] 4 0.008% 100.000% ** Level 3 read latency histogram (micros): Count: 40 Average: 1352.0500 StdDev: 1307.59 Min: 178 Median: 725.0000 Max: 5498 Percentiles: P50: 725.00 P75: 2122.22 P99: 5498.00 P99.9: 5498.00 P99.99: 5498.00 ------------------------------------------------------ ( 170, 250 ] 2 5.000% 5.000% # ( 250, 380 ] 4 10.000% 15.000% ## ( 380, 580 ] 11 27.500% 42.500% ###### ( 580, 870 ] 6 15.000% 57.500% ### ( 870, 1300 ] 2 5.000% 62.500% # ( 1300, 1900 ] 3 7.500% 70.000% ## ( 1900, 2900 ] 9 22.500% 92.500% ##### ( 2900, 4400 ] 1 2.500% 95.000% # ( 4400, 6600 ] 2 5.000% 100.000% # ** Level 4 read latency histogram (micros): Count: 30 Average: 1643.7333 StdDev: 1464.82 Min: 330 Median: 1156.6667 Max: 6708 Percentiles: P50: 1156.67 P75: 2025.00 P99: 6708.00 P99.9: 6708.00 P99.99: 6708.00 ------------------------------------------------------ ( 250, 380 ] 3 10.000% 10.000% ## ( 380, 580 ] 4 13.333% 23.333% ### ( 580, 870 ] 4 13.333% 36.667% ### ( 870, 1300 ] 6 20.000% 56.667% #### ( 1300, 1900 ] 5 16.667% 73.333% ### ( 1900, 2900 ] 4 13.333% 86.667% ### ( 2900, 4400 ] 2 6.667% 93.333% # ( 4400, 6600 ] 1 3.333% 96.667% # ( 6600, 9900 ] 1 3.333% 100.000% # ** DB Stats ** Uptime(secs): 3.0 total, 2.8 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 330.04 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.223 H:M:S, 7.5 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 351.22 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.223 H:M:S, 7.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/07/23-19:44:31 ... thread 0: (1000000,2000000) ops and (324076.6,339804.2) ops/second in (3.085690,5.885743) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 14/11 1.17 GB 18.9 0.2 0.0 0.2 2.0 1.8 0.0 1.1 41.3 340.8 6.10 5.53 27 0.226 255K 229 0.0 0.0 L1 1/1 3.06 MB 0.0 0.4 0.4 0.0 0.4 0.4 0.2 1.0 239.1 238.7 1.58 1.53 1 1.581 383K 619 0.0 0.0 L2 2/1 54.83 MB 0.5 0.4 0.2 0.2 0.4 0.2 0.4 2.0 246.6 246.5 1.53 1.48 2 0.766 383K 208 0.0 0.0 L3 20/10 1.12 GB 0.3 0.2 0.2 0.0 0.2 0.2 0.4 1.0 229.4 229.4 1.09 1.02 1 1.088 253K 0 0.0 0.0 L4 174/0 9.75 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.0 1.0 153.4 153.4 1.47 1.10 1 1.466 228K 0 0.0 0.0 L5 1044/0 85.82 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 1255/23 97.92 GB 0.0 1.4 1.0 0.4 3.2 2.8 1.1 1.8 126.0 281.2 11.77 10.65 32 0.368 1505K 1056 0.0 0.0 Int 0/0 0.00 KB 0.0 1.4 1.0 0.4 3.2 2.8 1.1 1.8 126.0 281.2 11.77 10.65 32 0.368 1505K 1056 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.4 1.0 0.4 1.4 1.0 0.0 0.0 223.7 223.5 6.63 6.07 6 1.104 1505K 1056 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 355.5 5.14 4.59 26 0.198 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 6.1 total, 5.9 interval Flush(GB): cumulative 1.784, interval 1.784 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 3.23 GB write, 545.25 MB/s write, 1.45 GB read, 244.33 MB/s read, 11.8 seconds Interval compaction: 3.23 GB write, 561.98 MB/s write, 1.45 GB read, 251.82 MB/s read, 11.8 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 8, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 8, interval: 8 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 371586 Average: 2.1405 StdDev: 11.42 Min: 0 Median: 1.4469 Max: 4172 Percentiles: P50: 1.45 P75: 1.84 P99: 5.64 P99.9: 10.23 P99.99: 14.62 ------------------------------------------------------ [ 0, 1 ] 79951 21.516% 21.516% #### ( 1, 2 ] 236817 63.731% 85.248% ############# ( 2, 3 ] 29155 7.846% 93.094% ## ( 3, 4 ] 14525 3.909% 97.003% # ( 4, 6 ] 9027 2.429% 99.432% ( 6, 10 ] 1723 0.464% 99.896% ( 10, 15 ] 381 0.103% 99.998% ( 15, 22 ] 35 0.009% 100.008% ( 22, 34 ] 5 0.001% 100.009% ( 34, 51 ] 2 0.001% 100.009% ( 51, 76 ] 7 0.002% 100.011% ( 110, 170 ] 7 0.002% 100.013% ( 170, 250 ] 18 0.005% 100.018% ( 250, 380 ] 14 0.004% 100.022% ( 380, 580 ] 3 0.001% 100.023% ( 580, 870 ] 4 0.001% 100.024% ( 870, 1300 ] 4 0.001% 100.025% ( 1300, 1900 ] 1 0.000% 100.025% ( 1900, 2900 ] 2 0.001% 100.026% ( 2900, 4400 ] 2 0.001% 100.026% ** Level 1 read latency histogram (micros): Count: 26 Average: 170.1538 StdDev: 321.93 Min: 0 Median: 1.7143 Max: 1216 Percentiles: P50: 1.71 P75: 230.00 P99: 1216.00 P99.9: 1216.00 P99.99: 1216.00 ------------------------------------------------------ [ 0, 1 ] 8 30.769% 30.769% ###### ( 1, 2 ] 7 26.923% 57.692% ##### ( 2, 3 ] 1 3.846% 61.538% # ( 3, 4 ] 1 3.846% 65.385% # ( 4, 6 ] 1 3.846% 69.231% # ( 170, 250 ] 2 7.692% 76.923% ## ( 250, 380 ] 2 7.692% 84.615% ## ( 380, 580 ] 1 3.846% 88.462% # ( 580, 870 ] 1 3.846% 92.308% # ( 870, 1300 ] 2 7.692% 100.000% ## ** Level 2 read latency histogram (micros): Count: 95729 Average: 2.0610 StdDev: 12.18 Min: 1 Median: 1.3531 Max: 1688 Percentiles: P50: 1.35 P75: 1.77 P99: 5.48 P99.9: 9.90 P99.99: 475.14 ------------------------------------------------------ [ 0, 1 ] 27745 28.983% 28.983% ###### ( 1, 2 ] 56979 59.521% 88.504% ############ ( 2, 3 ] 5636 5.887% 94.391% # ( 3, 4 ] 3089 3.227% 97.618% # ( 4, 6 ] 1785 1.865% 99.483% ( 6, 10 ] 409 0.427% 99.910% ( 10, 15 ] 58 0.061% 99.971% ( 15, 22 ] 8 0.008% 99.979% ( 22, 34 ] 3 0.003% 99.982% ( 34, 51 ] 1 0.001% 99.983% ( 250, 380 ] 5 0.005% 99.989% ( 380, 580 ] 3 0.003% 99.992% ( 580, 870 ] 2 0.002% 99.994% ( 870, 1300 ] 2 0.002% 99.996% ( 1300, 1900 ] 4 0.004% 100.000% ** Level 3 read latency histogram (micros): Count: 185050 Average: 3.0889 StdDev: 31.11 Min: 1 Median: 1.5634 Max: 5498 Percentiles: P50: 1.56 P75: 1.96 P99: 8.81 P99.9: 145.80 P99.99: 448.73 ------------------------------------------------------ [ 0, 1 ] 26930 14.553% 14.553% ### ( 1, 2 ] 116435 62.921% 77.474% ############# ( 2, 3 ] 22944 12.399% 89.872% ## ( 3, 4 ] 8324 4.498% 94.371% # ( 4, 6 ] 6529 3.528% 97.899% # ( 6, 10 ] 2900 1.567% 99.466% ( 10, 15 ] 461 0.249% 99.715% ( 15, 22 ] 76 0.041% 99.756% ( 22, 34 ] 14 0.008% 99.764% ( 34, 51 ] 7 0.004% 99.768% ( 51, 76 ] 24 0.013% 99.781% ( 76, 110 ] 104 0.056% 99.837% ( 110, 170 ] 196 0.106% 99.943% ( 170, 250 ] 36 0.019% 99.962% ( 250, 380 ] 35 0.019% 99.981% ( 380, 580 ] 48 0.026% 100.007% ( 580, 870 ] 18 0.010% 100.017% ( 870, 1300 ] 7 0.004% 100.021% ( 1300, 1900 ] 4 0.002% 100.023% ( 1900, 2900 ] 11 0.006% 100.029% ( 2900, 4400 ] 1 0.001% 100.029% ( 4400, 6600 ] 2 0.001% 100.030% ** Level 4 read latency histogram (micros): Count: 320 Average: 163.3281 StdDev: 656.41 Min: 0 Median: 2.4107 Max: 6708 Percentiles: P50: 2.41 P75: 10.74 P99: 3500.00 P99.9: 6708.00 P99.99: 6708.00 ------------------------------------------------------ [ 0, 1 ] 34 10.625% 10.625% ## ( 1, 2 ] 103 32.188% 42.812% ###### ( 2, 3 ] 56 17.500% 60.312% #### ( 3, 4 ] 26 8.125% 68.438% ## ( 4, 6 ] 15 4.688% 73.125% # ( 6, 10 ] 2 0.625% 73.750% ( 10, 15 ] 27 8.438% 82.188% ## ( 15, 22 ] 17 5.312% 87.500% # ( 22, 34 ] 5 1.562% 89.062% ( 34, 51 ] 1 0.312% 89.375% ( 110, 170 ] 1 0.312% 89.688% ( 170, 250 ] 2 0.625% 90.312% ( 250, 380 ] 3 0.938% 91.250% ( 380, 580 ] 4 1.250% 92.500% ( 580, 870 ] 4 1.250% 93.750% ( 870, 1300 ] 7 2.188% 95.938% ( 1300, 1900 ] 5 1.562% 97.500% ( 1900, 2900 ] 4 1.250% 98.750% ( 2900, 4400 ] 2 0.625% 99.375% ( 4400, 6600 ] 1 0.312% 99.688% ( 6600, 9900 ] 1 0.312% 100.000% ** DB Stats ** Uptime(secs): 6.1 total, 3.1 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 324.40 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.634 H:M:S, 10.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 318.95 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.411 H:M:S, 13.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/07/23-19:44:35 ... thread 0: (1000000,3000000) ops and (319672.8,332817.8) ops/second in (3.128199,9.013942) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 9/4 1.48 GB 119.6 1.4 0.0 1.4 4.1 2.8 0.0 1.5 104.1 316.9 13.32 12.32 45 0.296 1407K 1490 0.0 0.0 L1 3/0 212.83 MB 21.3 1.0 1.0 0.0 1.0 1.0 0.2 1.0 232.3 231.7 4.62 4.49 2 2.312 1090K 2578 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 0.9 2.0 246.6 246.5 1.53 1.48 2 0.766 383K 208 0.0 0.0 L3 21/0 909.65 MB 0.9 1.9 0.8 1.1 1.9 0.8 0.4 2.5 230.1 229.6 8.41 7.89 6 1.402 1966K 4035 0.0 0.0 L4 174/0 9.53 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.8 1.0 153.4 153.4 1.47 1.10 1 1.466 228K 0 0.0 0.0 L5 1056/0 86.80 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 1263/4 98.90 GB 0.0 4.9 2.2 2.7 7.6 5.0 3.3 2.8 170.3 266.6 29.35 27.28 56 0.524 5075K 8311 0.0 0.0 Int 0/0 0.00 KB 0.0 4.9 2.2 2.7 7.6 5.0 3.3 2.8 170.3 266.6 29.35 27.28 56 0.524 5075K 8311 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.9 2.2 2.7 4.9 2.2 0.0 0.0 234.3 233.9 21.34 20.15 16 1.334 5075K 8311 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 353.8 8.01 7.13 40 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.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: 7.64 GB write, 850.94 MB/s write, 4.88 GB read, 543.58 MB/s read, 29.4 seconds Interval compaction: 7.64 GB write, 867.98 MB/s write, 4.88 GB read, 554.47 MB/s read, 29.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: 12, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 12, interval: 12 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 709326 Average: 2.2701 StdDev: 11.61 Min: 0 Median: 1.5114 Max: 4172 Percentiles: P50: 1.51 P75: 1.90 P99: 5.85 P99.9: 11.22 P99.99: 14.44 ------------------------------------------------------ [ 0, 1 ] 123020 17.343% 17.343% ### ( 1, 2 ] 452930 63.854% 81.197% ############# ( 2, 3 ] 66927 9.435% 90.632% ## ( 3, 4 ] 35911 5.063% 95.695% # ( 4, 6 ] 25401 3.581% 99.276% # ( 6, 10 ] 4188 0.590% 99.866% ( 10, 15 ] 989 0.139% 100.006% ( 15, 22 ] 99 0.014% 100.020% ( 22, 34 ] 12 0.002% 100.021% ( 34, 51 ] 3 0.000% 100.022% ( 51, 76 ] 9 0.001% 100.023% ( 110, 170 ] 10 0.001% 100.024% ( 170, 250 ] 29 0.004% 100.028% ( 250, 380 ] 19 0.003% 100.031% ( 380, 580 ] 7 0.001% 100.032% ( 580, 870 ] 8 0.001% 100.033% ( 870, 1300 ] 7 0.001% 100.034% ( 1300, 1900 ] 3 0.000% 100.035% ( 1900, 2900 ] 6 0.001% 100.036% ( 2900, 4400 ] 3 0.000% 100.036% ** Level 1 read latency histogram (micros): Count: 217238 Average: 2.7575 StdDev: 11.95 Min: 0 Median: 1.6826 Max: 1797 Percentiles: P50: 1.68 P75: 2.37 P99: 7.69 P99.9: 12.65 P99.99: 14.24 ------------------------------------------------------ [ 0, 1 ] 16801 7.734% 7.734% ## ( 1, 2 ] 134521 61.923% 69.657% ############ ( 2, 3 ] 30986 14.264% 83.921% ### ( 3, 4 ] 16753 7.712% 91.633% ## ( 4, 6 ] 14815 6.820% 98.452% # ( 6, 10 ] 2821 1.299% 99.751% ( 10, 15 ] 612 0.282% 100.033% ( 15, 22 ] 76 0.035% 100.068% ( 22, 34 ] 6 0.003% 100.070% ( 34, 51 ] 2 0.001% 100.071% ( 76, 110 ] 9 0.004% 100.075% ( 110, 170 ] 30 0.014% 100.089% ( 170, 250 ] 17 0.008% 100.097% ( 250, 380 ] 21 0.010% 100.107% ( 380, 580 ] 19 0.009% 100.116% ( 580, 870 ] 11 0.005% 100.121% ( 870, 1300 ] 7 0.003% 100.124% ( 1300, 1900 ] 4 0.002% 100.126% ** Level 2 read latency histogram (micros): Count: 124198 Average: 2.3032 StdDev: 13.01 Min: 1 Median: 1.3994 Max: 1688 Percentiles: P50: 1.40 P75: 1.81 P99: 5.96 P99.9: 94.82 P99.99: 554.19 ------------------------------------------------------ [ 0, 1 ] 31920 25.701% 25.701% ##### ( 1, 2 ] 75554 60.834% 86.534% ############ ( 2, 3 ] 8216 6.615% 93.150% # ( 3, 4 ] 4611 3.713% 96.862% # ( 4, 6 ] 2711 2.183% 99.045% ( 6, 10 ] 916 0.738% 99.783% ( 10, 15 ] 108 0.087% 99.870% ( 15, 22 ] 10 0.008% 99.878% ( 22, 34 ] 3 0.002% 99.880% ( 34, 51 ] 1 0.001% 99.881% ( 76, 110 ] 43 0.035% 99.915% ( 110, 170 ] 44 0.035% 99.951% ( 170, 250 ] 24 0.019% 99.970% ( 250, 380 ] 15 0.012% 99.982% ( 380, 580 ] 11 0.009% 99.991% ( 580, 870 ] 5 0.004% 99.995% ( 870, 1300 ] 2 0.002% 99.997% ( 1300, 1900 ] 4 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 239487 Average: 3.1313 StdDev: 29.27 Min: 1 Median: 1.5747 Max: 5498 Percentiles: P50: 1.57 P75: 1.97 P99: 8.93 P99.9: 157.98 P99.99: 519.55 ------------------------------------------------------ [ 0, 1 ] 33231 13.876% 13.876% ### ( 1, 2 ] 150530 62.855% 76.731% ############# ( 2, 3 ] 29132 12.164% 88.895% ## ( 3, 4 ] 12111 5.057% 93.952% # ( 4, 6 ] 9244 3.860% 97.812% # ( 6, 10 ] 3884 1.622% 99.434% ( 10, 15 ] 638 0.266% 99.701% ( 15, 22 ] 84 0.035% 99.736% ( 22, 34 ] 23 0.010% 99.745% ( 34, 51 ] 7 0.003% 99.748% ( 51, 76 ] 35 0.015% 99.763% ( 76, 110 ] 139 0.058% 99.821% ( 110, 170 ] 237 0.099% 99.920% ( 170, 250 ] 75 0.031% 99.951% ( 250, 380 ] 47 0.020% 99.971% ( 380, 580 ] 66 0.028% 99.998% ( 580, 870 ] 29 0.012% 100.010% ( 870, 1300 ] 12 0.005% 100.015% ( 1300, 1900 ] 4 0.002% 100.017% ( 1900, 2900 ] 12 0.005% 100.022% ( 2900, 4400 ] 1 0.000% 100.023% ( 4400, 6600 ] 2 0.001% 100.023% ** Level 4 read latency histogram (micros): Count: 320 Average: 163.3281 StdDev: 656.41 Min: 0 Median: 2.4107 Max: 6708 Percentiles: P50: 2.41 P75: 10.74 P99: 3500.00 P99.9: 6708.00 P99.99: 6708.00 ------------------------------------------------------ [ 0, 1 ] 34 10.625% 10.625% ## ( 1, 2 ] 103 32.188% 42.812% ###### ( 2, 3 ] 56 17.500% 60.312% #### ( 3, 4 ] 26 8.125% 68.438% ## ( 4, 6 ] 15 4.688% 73.125% # ( 6, 10 ] 2 0.625% 73.750% ( 10, 15 ] 27 8.438% 82.188% ## ( 15, 22 ] 17 5.312% 87.500% # ( 22, 34 ] 5 1.562% 89.062% ( 34, 51 ] 1 0.312% 89.375% ( 110, 170 ] 1 0.312% 89.688% ( 170, 250 ] 2 0.625% 90.312% ( 250, 380 ] 3 0.938% 91.250% ( 380, 580 ] 4 1.250% 92.500% ( 580, 870 ] 4 1.250% 93.750% ( 870, 1300 ] 7 2.188% 95.938% ( 1300, 1900 ] 5 1.562% 97.500% ( 1900, 2900 ] 4 1.250% 98.750% ( 2900, 4400 ] 2 0.625% 99.375% ( 4400, 6600 ] 1 0.312% 99.688% ( 6600, 9900 ] 1 0.312% 100.000% ** Level 5 read latency histogram (micros): Count: 60 Average: 764.9833 StdDev: 951.58 Min: 75 Median: 241.1111 Max: 3488 Percentiles: P50: 241.11 P75: 1156.67 P99: 3488.00 P99.9: 3488.00 P99.99: 3488.00 ------------------------------------------------------ ( 51, 76 ] 1 1.667% 1.667% ( 76, 110 ] 11 18.333% 20.000% #### ( 110, 170 ] 10 16.667% 36.667% ### ( 170, 250 ] 9 15.000% 51.667% ### ( 250, 380 ] 4 6.667% 58.333% # ( 380, 580 ] 5 8.333% 66.667% ## ( 580, 870 ] 3 5.000% 71.667% # ( 870, 1300 ] 3 5.000% 76.667% # ( 1300, 1900 ] 4 6.667% 83.333% # ( 1900, 2900 ] 7 11.667% 95.000% ## ( 2900, 4400 ] 3 5.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, 321.07 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.050 H:M:S, 11.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 314.61 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.416 H:M:S, 13.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/07/23-19:44:38 ... thread 0: (1000000,4000000) ops and (334642.5,333272.1) ops/second in (2.988264,12.002206) 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/4 2.46 GB 226.6 2.2 0.0 2.2 6.0 3.8 0.0 1.6 116.9 314.9 19.40 18.05 62 0.313 2302K 2439 0.0 0.0 L1 3/0 212.83 MB 21.3 1.0 1.0 0.0 1.0 1.0 0.2 1.0 232.3 231.7 4.62 4.49 2 2.312 1090K 2578 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 0.9 2.0 246.6 246.5 1.53 1.48 2 0.766 383K 208 0.0 0.0 L3 21/0 909.65 MB 0.9 1.9 0.8 1.1 1.9 0.8 0.4 2.5 230.1 229.6 8.41 7.89 6 1.402 1966K 4035 0.0 0.0 L4 174/0 9.53 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.8 1.0 153.4 153.4 1.47 1.10 1 1.466 228K 0 0.0 0.0 L5 1056/0 86.80 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/4 99.88 GB 0.0 5.7 2.2 3.5 9.5 6.0 3.3 2.5 166.0 274.2 35.43 33.00 73 0.485 5971K 9260 0.0 0.0 Int 0/0 0.00 KB 0.0 5.7 2.2 3.5 9.5 6.0 3.3 2.5 166.0 274.2 35.43 33.00 73 0.485 5971K 9260 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.2 0.0 0.0 238.5 238.1 24.66 23.41 19 1.298 5971K 9260 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 3.8 3.8 0.0 0.0 0.0 356.6 10.78 9.59 54 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): 12.2 total, 12.0 interval Flush(GB): cumulative 3.753, interval 3.753 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 9.49 GB write, 797.26 MB/s write, 5.74 GB read, 482.65 MB/s read, 35.4 seconds Interval compaction: 9.49 GB write, 809.26 MB/s write, 5.74 GB read, 489.91 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: 968877 Average: 2.1725 StdDev: 11.98 Min: 0 Median: 1.4569 Max: 4172 Percentiles: P50: 1.46 P75: 1.85 P99: 5.73 P99.9: 10.92 P99.99: 14.55 ------------------------------------------------------ [ 0, 1 ] 204088 21.064% 21.064% #### ( 1, 2 ] 613599 63.331% 84.395% ############# ( 2, 3 ] 77134 7.961% 92.357% ## ( 3, 4 ] 40583 4.189% 96.545% # ( 4, 6 ] 27444 2.833% 99.378% # ( 6, 10 ] 4839 0.499% 99.877% ( 10, 15 ] 1203 0.124% 100.001% ( 15, 22 ] 128 0.013% 100.015% ( 22, 34 ] 14 0.001% 100.016% ( 34, 51 ] 6 0.001% 100.017% ( 51, 76 ] 10 0.001% 100.018% ( 110, 170 ] 18 0.002% 100.020% ( 170, 250 ] 33 0.003% 100.023% ( 250, 380 ] 26 0.003% 100.026% ( 380, 580 ] 9 0.001% 100.027% ( 580, 870 ] 13 0.001% 100.028% ( 870, 1300 ] 11 0.001% 100.029% ( 1300, 1900 ] 4 0.000% 100.029% ( 1900, 2900 ] 7 0.001% 100.030% ( 2900, 4400 ] 5 0.001% 100.031% ** Level 1 read latency histogram (micros): Count: 217238 Average: 2.7575 StdDev: 11.95 Min: 0 Median: 1.6826 Max: 1797 Percentiles: P50: 1.68 P75: 2.37 P99: 7.69 P99.9: 12.65 P99.99: 14.24 ------------------------------------------------------ [ 0, 1 ] 16801 7.734% 7.734% ## ( 1, 2 ] 134521 61.923% 69.657% ############ ( 2, 3 ] 30986 14.264% 83.921% ### ( 3, 4 ] 16753 7.712% 91.633% ## ( 4, 6 ] 14815 6.820% 98.452% # ( 6, 10 ] 2821 1.299% 99.751% ( 10, 15 ] 612 0.282% 100.033% ( 15, 22 ] 76 0.035% 100.068% ( 22, 34 ] 6 0.003% 100.070% ( 34, 51 ] 2 0.001% 100.071% ( 76, 110 ] 9 0.004% 100.075% ( 110, 170 ] 30 0.014% 100.089% ( 170, 250 ] 17 0.008% 100.097% ( 250, 380 ] 21 0.010% 100.107% ( 380, 580 ] 19 0.009% 100.116% ( 580, 870 ] 11 0.005% 100.121% ( 870, 1300 ] 7 0.003% 100.124% ( 1300, 1900 ] 4 0.002% 100.126% ** Level 2 read latency histogram (micros): Count: 124198 Average: 2.3032 StdDev: 13.01 Min: 1 Median: 1.3994 Max: 1688 Percentiles: P50: 1.40 P75: 1.81 P99: 5.96 P99.9: 94.82 P99.99: 554.19 ------------------------------------------------------ [ 0, 1 ] 31920 25.701% 25.701% ##### ( 1, 2 ] 75554 60.834% 86.534% ############ ( 2, 3 ] 8216 6.615% 93.150% # ( 3, 4 ] 4611 3.713% 96.862% # ( 4, 6 ] 2711 2.183% 99.045% ( 6, 10 ] 916 0.738% 99.783% ( 10, 15 ] 108 0.087% 99.870% ( 15, 22 ] 10 0.008% 99.878% ( 22, 34 ] 3 0.002% 99.880% ( 34, 51 ] 1 0.001% 99.881% ( 76, 110 ] 43 0.035% 99.915% ( 110, 170 ] 44 0.035% 99.951% ( 170, 250 ] 24 0.019% 99.970% ( 250, 380 ] 15 0.012% 99.982% ( 380, 580 ] 11 0.009% 99.991% ( 580, 870 ] 5 0.004% 99.995% ( 870, 1300 ] 2 0.002% 99.997% ( 1300, 1900 ] 4 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 239487 Average: 3.1313 StdDev: 29.27 Min: 1 Median: 1.5747 Max: 5498 Percentiles: P50: 1.57 P75: 1.97 P99: 8.93 P99.9: 157.98 P99.99: 519.55 ------------------------------------------------------ [ 0, 1 ] 33231 13.876% 13.876% ### ( 1, 2 ] 150530 62.855% 76.731% ############# ( 2, 3 ] 29132 12.164% 88.895% ## ( 3, 4 ] 12111 5.057% 93.952% # ( 4, 6 ] 9244 3.860% 97.812% # ( 6, 10 ] 3884 1.622% 99.434% ( 10, 15 ] 638 0.266% 99.701% ( 15, 22 ] 84 0.035% 99.736% ( 22, 34 ] 23 0.010% 99.745% ( 34, 51 ] 7 0.003% 99.748% ( 51, 76 ] 35 0.015% 99.763% ( 76, 110 ] 139 0.058% 99.821% ( 110, 170 ] 237 0.099% 99.920% ( 170, 250 ] 75 0.031% 99.951% ( 250, 380 ] 47 0.020% 99.971% ( 380, 580 ] 66 0.028% 99.998% ( 580, 870 ] 29 0.012% 100.010% ( 870, 1300 ] 12 0.005% 100.015% ( 1300, 1900 ] 4 0.002% 100.017% ( 1900, 2900 ] 12 0.005% 100.022% ( 2900, 4400 ] 1 0.000% 100.023% ( 4400, 6600 ] 2 0.001% 100.023% ** Level 4 read latency histogram (micros): Count: 320 Average: 163.3281 StdDev: 656.41 Min: 0 Median: 2.4107 Max: 6708 Percentiles: P50: 2.41 P75: 10.74 P99: 3500.00 P99.9: 6708.00 P99.99: 6708.00 ------------------------------------------------------ [ 0, 1 ] 34 10.625% 10.625% ## ( 1, 2 ] 103 32.188% 42.812% ###### ( 2, 3 ] 56 17.500% 60.312% #### ( 3, 4 ] 26 8.125% 68.438% ## ( 4, 6 ] 15 4.688% 73.125% # ( 6, 10 ] 2 0.625% 73.750% ( 10, 15 ] 27 8.438% 82.188% ## ( 15, 22 ] 17 5.312% 87.500% # ( 22, 34 ] 5 1.562% 89.062% ( 34, 51 ] 1 0.312% 89.375% ( 110, 170 ] 1 0.312% 89.688% ( 170, 250 ] 2 0.625% 90.312% ( 250, 380 ] 3 0.938% 91.250% ( 380, 580 ] 4 1.250% 92.500% ( 580, 870 ] 4 1.250% 93.750% ( 870, 1300 ] 7 2.188% 95.938% ( 1300, 1900 ] 5 1.562% 97.500% ( 1900, 2900 ] 4 1.250% 98.750% ( 2900, 4400 ] 2 0.625% 99.375% ( 4400, 6600 ] 1 0.312% 99.688% ( 6600, 9900 ] 1 0.312% 100.000% ** Level 5 read latency histogram (micros): Count: 60 Average: 764.9833 StdDev: 951.58 Min: 75 Median: 241.1111 Max: 3488 Percentiles: P50: 241.11 P75: 1156.67 P99: 3488.00 P99.9: 3488.00 P99.99: 3488.00 ------------------------------------------------------ ( 51, 76 ] 1 1.667% 1.667% ( 76, 110 ] 11 18.333% 20.000% #### ( 110, 170 ] 10 16.667% 36.667% ### ( 170, 250 ] 9 15.000% 51.667% ### ( 250, 380 ] 4 6.667% 58.333% # ( 380, 580 ] 5 8.333% 66.667% ## ( 580, 870 ] 3 5.000% 71.667% # ( 870, 1300 ] 3 5.000% 76.667% # ( 1300, 1900 ] 4 6.667% 83.333% # ( 1900, 2900 ] 7 11.667% 95.000% ## ( 2900, 4400 ] 3 5.000% 100.000% # ** DB Stats ** Uptime(secs): 12.2 total, 3.0 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 323.10 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.438 H:M:S, 11.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 329.35 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.388 H:M:S, 13.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/07/23-19:44:41 ... thread 0: (1000000,5000000) ops and (314098.3,329252.3) ops/second in (3.183717,15.185923) 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 3.38 GB 69.2 3.0 0.0 3.0 7.7 4.7 0.0 1.6 122.3 314.2 25.25 23.54 79 0.320 3134K 3348 0.0 0.0 L1 3/3 212.83 MB 0.0 1.0 1.0 0.0 1.0 1.0 0.2 1.0 232.3 231.7 4.62 4.49 2 2.312 1090K 2578 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 0.9 2.0 246.6 246.5 1.53 1.48 2 0.766 383K 208 0.0 0.0 L3 21/0 909.65 MB 0.9 1.9 0.8 1.1 1.9 0.8 0.4 2.5 230.1 229.6 8.41 7.89 6 1.402 1966K 4035 0.0 0.0 L4 174/0 9.53 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.8 1.0 153.4 153.4 1.47 1.10 1 1.466 228K 0 0.0 0.0 L5 1056/0 86.80 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 1272/18 100.80 GB 0.0 6.5 2.2 4.3 11.3 6.9 3.3 2.4 162.3 279.5 41.28 38.50 90 0.459 6803K 10K 0.0 0.0 Int 0/0 0.00 KB 0.0 6.5 2.2 4.3 11.3 6.9 3.3 2.4 162.3 279.5 41.28 38.50 90 0.459 6803K 10K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 6.5 2.2 4.3 6.5 2.2 0.0 0.0 242.1 241.7 27.67 26.37 22 1.258 6803K 10K 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 356.3 13.61 12.13 68 0.200 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 15.4 total, 15.2 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.27 GB write, 750.92 MB/s write, 6.54 GB read, 435.95 MB/s read, 41.3 seconds Interval compaction: 11.27 GB write, 759.85 MB/s write, 6.54 GB read, 441.14 MB/s read, 41.3 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 1, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 1, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 16, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 1, total-stops: 16, interval: 17 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1347277 Average: 2.1641 StdDev: 11.73 Min: 0 Median: 1.4534 Max: 4172 Percentiles: P50: 1.45 P75: 1.84 P99: 5.69 P99.9: 10.80 P99.99: 14.70 ------------------------------------------------------ [ 0, 1 ] 278645 20.682% 20.682% #### ( 1, 2 ] 871253 64.668% 85.350% ############# ( 2, 3 ] 102799 7.630% 92.980% ## ( 3, 4 ] 52848 3.923% 96.902% # ( 4, 6 ] 33460 2.484% 99.386% ( 6, 10 ] 6676 0.496% 99.882% ( 10, 15 ] 1558 0.116% 99.997% ( 15, 22 ] 149 0.011% 100.008% ( 22, 34 ] 19 0.001% 100.010% ( 34, 51 ] 10 0.001% 100.010% ( 51, 76 ] 11 0.001% 100.011% ( 76, 110 ] 76 0.006% 100.017% ( 110, 170 ] 72 0.005% 100.022% ( 170, 250 ] 48 0.004% 100.026% ( 250, 380 ] 40 0.003% 100.029% ( 380, 580 ] 15 0.001% 100.030% ( 580, 870 ] 16 0.001% 100.031% ( 870, 1300 ] 16 0.001% 100.032% ( 1300, 1900 ] 5 0.000% 100.033% ( 1900, 2900 ] 9 0.001% 100.033% ( 2900, 4400 ] 7 0.001% 100.034% ** Level 1 read latency histogram (micros): Count: 217239 Average: 2.7575 StdDev: 11.95 Min: 0 Median: 1.6826 Max: 1797 Percentiles: P50: 1.68 P75: 2.37 P99: 7.69 P99.9: 12.65 P99.99: 14.24 ------------------------------------------------------ [ 0, 1 ] 16801 7.734% 7.734% ## ( 1, 2 ] 134521 61.923% 69.657% ############ ( 2, 3 ] 30986 14.264% 83.920% ### ( 3, 4 ] 16753 7.712% 91.632% ## ( 4, 6 ] 14816 6.820% 98.452% # ( 6, 10 ] 2821 1.299% 99.751% ( 10, 15 ] 612 0.282% 100.033% ( 15, 22 ] 76 0.035% 100.068% ( 22, 34 ] 6 0.003% 100.070% ( 34, 51 ] 2 0.001% 100.071% ( 76, 110 ] 9 0.004% 100.075% ( 110, 170 ] 30 0.014% 100.089% ( 170, 250 ] 17 0.008% 100.097% ( 250, 380 ] 21 0.010% 100.107% ( 380, 580 ] 19 0.009% 100.116% ( 580, 870 ] 11 0.005% 100.121% ( 870, 1300 ] 7 0.003% 100.124% ( 1300, 1900 ] 4 0.002% 100.126% ** Level 2 read latency histogram (micros): Count: 124198 Average: 2.3032 StdDev: 13.01 Min: 1 Median: 1.3994 Max: 1688 Percentiles: P50: 1.40 P75: 1.81 P99: 5.96 P99.9: 94.82 P99.99: 554.19 ------------------------------------------------------ [ 0, 1 ] 31920 25.701% 25.701% ##### ( 1, 2 ] 75554 60.834% 86.534% ############ ( 2, 3 ] 8216 6.615% 93.150% # ( 3, 4 ] 4611 3.713% 96.862% # ( 4, 6 ] 2711 2.183% 99.045% ( 6, 10 ] 916 0.738% 99.783% ( 10, 15 ] 108 0.087% 99.870% ( 15, 22 ] 10 0.008% 99.878% ( 22, 34 ] 3 0.002% 99.880% ( 34, 51 ] 1 0.001% 99.881% ( 76, 110 ] 43 0.035% 99.915% ( 110, 170 ] 44 0.035% 99.951% ( 170, 250 ] 24 0.019% 99.970% ( 250, 380 ] 15 0.012% 99.982% ( 380, 580 ] 11 0.009% 99.991% ( 580, 870 ] 5 0.004% 99.995% ( 870, 1300 ] 2 0.002% 99.997% ( 1300, 1900 ] 4 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 239487 Average: 3.1313 StdDev: 29.27 Min: 1 Median: 1.5747 Max: 5498 Percentiles: P50: 1.57 P75: 1.97 P99: 8.93 P99.9: 157.98 P99.99: 519.55 ------------------------------------------------------ [ 0, 1 ] 33231 13.876% 13.876% ### ( 1, 2 ] 150530 62.855% 76.731% ############# ( 2, 3 ] 29132 12.164% 88.895% ## ( 3, 4 ] 12111 5.057% 93.952% # ( 4, 6 ] 9244 3.860% 97.812% # ( 6, 10 ] 3884 1.622% 99.434% ( 10, 15 ] 638 0.266% 99.701% ( 15, 22 ] 84 0.035% 99.736% ( 22, 34 ] 23 0.010% 99.745% ( 34, 51 ] 7 0.003% 99.748% ( 51, 76 ] 35 0.015% 99.763% ( 76, 110 ] 139 0.058% 99.821% ( 110, 170 ] 237 0.099% 99.920% ( 170, 250 ] 75 0.031% 99.951% ( 250, 380 ] 47 0.020% 99.971% ( 380, 580 ] 66 0.028% 99.998% ( 580, 870 ] 29 0.012% 100.010% ( 870, 1300 ] 12 0.005% 100.015% ( 1300, 1900 ] 4 0.002% 100.017% ( 1900, 2900 ] 12 0.005% 100.022% ( 2900, 4400 ] 1 0.000% 100.023% ( 4400, 6600 ] 2 0.001% 100.023% ** Level 4 read latency histogram (micros): Count: 320 Average: 163.3281 StdDev: 656.41 Min: 0 Median: 2.4107 Max: 6708 Percentiles: P50: 2.41 P75: 10.74 P99: 3500.00 P99.9: 6708.00 P99.99: 6708.00 ------------------------------------------------------ [ 0, 1 ] 34 10.625% 10.625% ## ( 1, 2 ] 103 32.188% 42.812% ###### ( 2, 3 ] 56 17.500% 60.312% #### ( 3, 4 ] 26 8.125% 68.438% ## ( 4, 6 ] 15 4.688% 73.125% # ( 6, 10 ] 2 0.625% 73.750% ( 10, 15 ] 27 8.438% 82.188% ## ( 15, 22 ] 17 5.312% 87.500% # ( 22, 34 ] 5 1.562% 89.062% ( 34, 51 ] 1 0.312% 89.375% ( 110, 170 ] 1 0.312% 89.688% ( 170, 250 ] 2 0.625% 90.312% ( 250, 380 ] 3 0.938% 91.250% ( 380, 580 ] 4 1.250% 92.500% ( 580, 870 ] 4 1.250% 93.750% ( 870, 1300 ] 7 2.188% 95.938% ( 1300, 1900 ] 5 1.562% 97.500% ( 1900, 2900 ] 4 1.250% 98.750% ( 2900, 4400 ] 2 0.625% 99.375% ( 4400, 6600 ] 1 0.312% 99.688% ( 6600, 9900 ] 1 0.312% 100.000% ** Level 5 read latency histogram (micros): Count: 60 Average: 764.9833 StdDev: 951.58 Min: 75 Median: 241.1111 Max: 3488 Percentiles: P50: 241.11 P75: 1156.67 P99: 3488.00 P99.9: 3488.00 P99.99: 3488.00 ------------------------------------------------------ ( 51, 76 ] 1 1.667% 1.667% ( 76, 110 ] 11 18.333% 20.000% #### ( 110, 170 ] 10 16.667% 36.667% ### ( 170, 250 ] 9 15.000% 51.667% ### ( 250, 380 ] 4 6.667% 58.333% # ( 380, 580 ] 5 8.333% 66.667% ## ( 580, 870 ] 3 5.000% 71.667% # ( 870, 1300 ] 3 5.000% 76.667% # ( 1300, 1900 ] 4 6.667% 83.333% # ( 1900, 2900 ] 7 11.667% 95.000% ## ( 2900, 4400 ] 3 5.000% 100.000% # ** DB Stats ** Uptime(secs): 15.4 total, 3.2 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 320.21 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.001 H:M:S, 13.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 309.14 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.563 H:M:S, 17.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/07/23-19:44:48 ... thread 0: (1000000,6000000) ops and (142658.9,270323.3) ops/second in (7.009726,22.195649) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 19/11 4.36 GB 195.0 4.7 0.0 4.7 10.3 5.7 0.0 1.8 140.3 310.1 34.11 32.04 99 0.345 4860K 6084 0.0 0.0 L1 3/3 212.83 MB 0.0 1.0 1.0 0.0 1.0 1.0 0.2 1.0 232.3 231.7 4.62 4.49 2 2.312 1090K 2578 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 0.9 2.0 246.6 246.5 1.53 1.48 2 0.766 383K 208 0.0 0.0 L3 21/0 909.65 MB 0.9 1.9 0.8 1.1 1.9 0.8 0.4 2.5 230.1 229.6 8.41 7.89 6 1.402 1966K 4035 0.0 0.0 L4 174/0 9.53 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.8 1.0 153.4 153.4 1.47 1.10 1 1.466 228K 0 0.0 0.0 L5 1056/0 86.80 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 1273/14 101.78 GB 0.0 8.2 2.2 6.0 13.9 7.9 3.3 2.4 167.5 282.8 50.15 46.99 110 0.456 8529K 12K 0.0 0.0 Int 0/0 0.00 KB 0.0 8.2 2.2 6.0 13.9 7.9 3.3 2.4 167.5 282.8 50.15 46.99 110 0.456 8529K 12K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 8.2 2.2 6.0 8.2 2.2 0.0 0.0 247.9 247.5 33.89 32.51 27 1.255 8529K 12K 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 356.4 16.26 14.48 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): 22.4 total, 22.2 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: 13.85 GB write, 633.79 MB/s write, 8.20 GB read, 375.38 MB/s read, 50.1 seconds Interval compaction: 13.85 GB write, 638.95 MB/s write, 8.20 GB read, 378.43 MB/s read, 50.1 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 10, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 10, 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: 10, total-stops: 16, interval: 26 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2106318 Average: 2.1410 StdDev: 10.55 Min: 0 Median: 1.4382 Max: 4172 Percentiles: P50: 1.44 P75: 1.82 P99: 5.67 P99.9: 10.91 P99.99: 21.80 ------------------------------------------------------ [ 0, 1 ] 444353 21.096% 21.096% #### ( 1, 2 ] 1389481 65.967% 87.063% ############# ( 2, 3 ] 142685 6.774% 93.838% # ( 3, 4 ] 73447 3.487% 97.325% # ( 4, 6 ] 42247 2.006% 99.330% ( 6, 10 ] 11620 0.552% 99.882% ( 10, 15 ] 2083 0.099% 99.981% ( 15, 22 ] 198 0.009% 99.990% ( 22, 34 ] 22 0.001% 99.991% ( 34, 51 ] 12 0.001% 99.992% ( 51, 76 ] 30 0.001% 99.993% ( 76, 110 ] 279 0.013% 100.007% ( 110, 170 ] 201 0.010% 100.016% ( 170, 250 ] 95 0.005% 100.021% ( 250, 380 ] 86 0.004% 100.025% ( 380, 580 ] 39 0.002% 100.027% ( 580, 870 ] 33 0.002% 100.028% ( 870, 1300 ] 21 0.001% 100.029% ( 1300, 1900 ] 7 0.000% 100.029% ( 1900, 2900 ] 12 0.001% 100.030% ( 2900, 4400 ] 7 0.000% 100.030% ** Level 1 read latency histogram (micros): Count: 247902 Average: 2.7385 StdDev: 11.93 Min: 0 Median: 1.6463 Max: 1797 Percentiles: P50: 1.65 P75: 2.22 P99: 7.80 P99.9: 13.54 P99.99: 18.07 ------------------------------------------------------ [ 0, 1 ] 23811 9.605% 9.605% ## ( 1, 2 ] 154938 62.500% 72.105% ############ ( 2, 3 ] 32465 13.096% 85.201% ### ( 3, 4 ] 17508 7.062% 92.263% # ( 4, 6 ] 15249 6.151% 98.414% # ( 6, 10 ] 3223 1.300% 99.714% ( 10, 15 ] 649 0.262% 99.976% ( 15, 22 ] 78 0.031% 100.008% ( 22, 34 ] 7 0.003% 100.010% ( 34, 51 ] 2 0.001% 100.011% ( 51, 76 ] 4 0.002% 100.013% ( 76, 110 ] 66 0.027% 100.040% ( 110, 170 ] 77 0.031% 100.071% ( 170, 250 ] 24 0.010% 100.080% ( 250, 380 ] 27 0.011% 100.091% ( 380, 580 ] 23 0.009% 100.100% ( 580, 870 ] 13 0.005% 100.106% ( 870, 1300 ] 7 0.003% 100.109% ( 1300, 1900 ] 4 0.002% 100.110% ** Level 2 read latency histogram (micros): Count: 124198 Average: 2.3032 StdDev: 13.01 Min: 1 Median: 1.3994 Max: 1688 Percentiles: P50: 1.40 P75: 1.81 P99: 5.96 P99.9: 94.82 P99.99: 554.19 ------------------------------------------------------ [ 0, 1 ] 31920 25.701% 25.701% ##### ( 1, 2 ] 75554 60.834% 86.534% ############ ( 2, 3 ] 8216 6.615% 93.150% # ( 3, 4 ] 4611 3.713% 96.862% # ( 4, 6 ] 2711 2.183% 99.045% ( 6, 10 ] 916 0.738% 99.783% ( 10, 15 ] 108 0.087% 99.870% ( 15, 22 ] 10 0.008% 99.878% ( 22, 34 ] 3 0.002% 99.880% ( 34, 51 ] 1 0.001% 99.881% ( 76, 110 ] 43 0.035% 99.915% ( 110, 170 ] 44 0.035% 99.951% ( 170, 250 ] 24 0.019% 99.970% ( 250, 380 ] 15 0.012% 99.982% ( 380, 580 ] 11 0.009% 99.991% ( 580, 870 ] 5 0.004% 99.995% ( 870, 1300 ] 2 0.002% 99.997% ( 1300, 1900 ] 4 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 239487 Average: 3.1313 StdDev: 29.27 Min: 1 Median: 1.5747 Max: 5498 Percentiles: P50: 1.57 P75: 1.97 P99: 8.93 P99.9: 157.98 P99.99: 519.55 ------------------------------------------------------ [ 0, 1 ] 33231 13.876% 13.876% ### ( 1, 2 ] 150530 62.855% 76.731% ############# ( 2, 3 ] 29132 12.164% 88.895% ## ( 3, 4 ] 12111 5.057% 93.952% # ( 4, 6 ] 9244 3.860% 97.812% # ( 6, 10 ] 3884 1.622% 99.434% ( 10, 15 ] 638 0.266% 99.701% ( 15, 22 ] 84 0.035% 99.736% ( 22, 34 ] 23 0.010% 99.745% ( 34, 51 ] 7 0.003% 99.748% ( 51, 76 ] 35 0.015% 99.763% ( 76, 110 ] 139 0.058% 99.821% ( 110, 170 ] 237 0.099% 99.920% ( 170, 250 ] 75 0.031% 99.951% ( 250, 380 ] 47 0.020% 99.971% ( 380, 580 ] 66 0.028% 99.998% ( 580, 870 ] 29 0.012% 100.010% ( 870, 1300 ] 12 0.005% 100.015% ( 1300, 1900 ] 4 0.002% 100.017% ( 1900, 2900 ] 12 0.005% 100.022% ( 2900, 4400 ] 1 0.000% 100.023% ( 4400, 6600 ] 2 0.001% 100.023% ** Level 4 read latency histogram (micros): Count: 320 Average: 163.3281 StdDev: 656.41 Min: 0 Median: 2.4107 Max: 6708 Percentiles: P50: 2.41 P75: 10.74 P99: 3500.00 P99.9: 6708.00 P99.99: 6708.00 ------------------------------------------------------ [ 0, 1 ] 34 10.625% 10.625% ## ( 1, 2 ] 103 32.188% 42.812% ###### ( 2, 3 ] 56 17.500% 60.312% #### ( 3, 4 ] 26 8.125% 68.438% ## ( 4, 6 ] 15 4.688% 73.125% # ( 6, 10 ] 2 0.625% 73.750% ( 10, 15 ] 27 8.438% 82.188% ## ( 15, 22 ] 17 5.312% 87.500% # ( 22, 34 ] 5 1.562% 89.062% ( 34, 51 ] 1 0.312% 89.375% ( 110, 170 ] 1 0.312% 89.688% ( 170, 250 ] 2 0.625% 90.312% ( 250, 380 ] 3 0.938% 91.250% ( 380, 580 ] 4 1.250% 92.500% ( 580, 870 ] 4 1.250% 93.750% ( 870, 1300 ] 7 2.188% 95.938% ( 1300, 1900 ] 5 1.562% 97.500% ( 1900, 2900 ] 4 1.250% 98.750% ( 2900, 4400 ] 2 0.625% 99.375% ( 4400, 6600 ] 1 0.312% 99.688% ( 6600, 9900 ] 1 0.312% 100.000% ** Level 5 read latency histogram (micros): Count: 60 Average: 764.9833 StdDev: 951.58 Min: 75 Median: 241.1111 Max: 3488 Percentiles: P50: 241.11 P75: 1156.67 P99: 3488.00 P99.9: 3488.00 P99.99: 3488.00 ------------------------------------------------------ ( 51, 76 ] 1 1.667% 1.667% ( 76, 110 ] 11 18.333% 20.000% #### ( 110, 170 ] 10 16.667% 36.667% ### ( 170, 250 ] 9 15.000% 51.667% ### ( 250, 380 ] 4 6.667% 58.333% # ( 380, 580 ] 5 8.333% 66.667% ## ( 580, 870 ] 3 5.000% 71.667% # ( 870, 1300 ] 3 5.000% 76.667% # ( 1300, 1900 ] 4 6.667% 83.333% # ( 1900, 2900 ] 7 11.667% 95.000% ## ( 2900, 4400 ] 3 5.000% 100.000% # ** DB Stats ** Uptime(secs): 22.4 total, 7.0 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 263.89 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:6.170 H:M:S, 27.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 140.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:4.169 H:M:S, 59.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/07/23-19:44:53 ... thread 0: (1000000,7000000) ops and (200336.2,257473.6) ops/second in (4.991608,27.187257) 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 2.83 GB 25.2 5.2 0.0 5.2 11.7 6.6 0.0 1.8 134.3 305.3 39.39 36.34 114 0.346 5372K 6570 0.0 0.0 L1 21/21 1.70 GB 0.0 3.7 3.5 0.2 3.7 3.5 0.2 1.0 228.6 226.3 16.64 16.02 3 5.547 3862K 36K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 1.8 2.0 246.6 246.5 1.53 1.48 2 0.766 383K 208 0.0 0.0 L3 27/5 1.19 GB 1.0 3.5 1.7 1.8 3.5 1.7 0.4 2.0 209.7 208.8 17.05 15.22 14 1.218 3631K 14K 0.0 0.0 L4 180/9 9.83 GB 1.0 0.8 0.8 0.0 0.8 0.8 0.8 1.0 146.6 146.4 5.92 4.08 12 0.493 877K 1375 0.0 0.0 L5 1060/0 87.11 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1303/47 102.66 GB 0.0 13.6 6.2 7.4 20.1 12.7 4.6 3.1 172.8 255.8 80.53 73.14 145 0.555 14M 59K 0.0 0.0 Int 0/0 0.00 KB 0.0 13.6 6.2 7.4 20.1 12.7 4.6 3.1 172.8 255.8 80.53 73.14 145 0.555 14M 59K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 13.6 6.2 7.4 13.5 6.1 0.0 0.0 228.6 227.7 60.86 56.19 49 1.242 14M 59K 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 342.7 19.67 16.95 96 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): 27.4 total, 27.2 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: 20.11 GB write, 752.55 MB/s write, 13.59 GB read, 508.46 MB/s read, 80.5 seconds Interval compaction: 20.11 GB write, 757.55 MB/s write, 13.59 GB read, 511.84 MB/s read, 80.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: 22, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 14, total-stops: 22, interval: 36 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2507812 Average: 2.2959 StdDev: 15.43 Min: 0 Median: 1.4623 Max: 7419 Percentiles: P50: 1.46 P75: 1.85 P99: 5.87 P99.9: 12.63 P99.99: 115.85 ------------------------------------------------------ [ 0, 1 ] 498421 19.875% 19.875% #### ( 1, 2 ] 1634026 65.157% 85.032% ############# ( 2, 3 ] 189165 7.543% 92.575% ## ( 3, 4 ] 99710 3.976% 96.551% # ( 4, 6 ] 65672 2.619% 99.170% # ( 6, 10 ] 16694 0.666% 99.836% ( 10, 15 ] 3077 0.123% 99.958% ( 15, 22 ] 271 0.011% 99.969% ( 22, 34 ] 25 0.001% 99.970% ( 34, 51 ] 14 0.001% 99.971% ( 51, 76 ] 32 0.001% 99.972% ( 76, 110 ] 420 0.017% 99.989% ( 110, 170 ] 361 0.014% 100.003% ( 170, 250 ] 182 0.007% 100.010% ( 250, 380 ] 160 0.006% 100.017% ( 380, 580 ] 125 0.005% 100.022% ( 580, 870 ] 105 0.004% 100.026% ( 870, 1300 ] 61 0.002% 100.028% ( 1300, 1900 ] 24 0.001% 100.029% ( 1900, 2900 ] 16 0.001% 100.030% ( 2900, 4400 ] 14 0.001% 100.030% ( 4400, 6600 ] 1 0.000% 100.030% ( 6600, 9900 ] 1 0.000% 100.031% ** Level 1 read latency histogram (micros): Count: 513048 Average: 3.5207 StdDev: 41.85 Min: 0 Median: 1.6906 Max: 7409 Percentiles: P50: 1.69 P75: 2.43 P99: 8.61 P99.9: 14.78 P99.99: 128.56 ------------------------------------------------------ [ 0, 1 ] 40310 7.857% 7.857% ## ( 1, 2 ] 313073 61.022% 68.879% ############ ( 2, 3 ] 73572 14.340% 83.219% ### ( 3, 4 ] 39442 7.688% 90.907% ## ( 4, 6 ] 36074 7.031% 97.938% # ( 6, 10 ] 8334 1.624% 99.563% ( 10, 15 ] 1810 0.353% 99.916% ( 15, 22 ] 182 0.035% 99.951% ( 22, 34 ] 15 0.003% 99.954% ( 34, 51 ] 5 0.001% 99.955% ( 51, 76 ] 18 0.004% 99.958% ( 76, 110 ] 119 0.023% 99.982% ( 110, 170 ] 138 0.027% 100.009% ( 170, 250 ] 99 0.019% 100.028% ( 250, 380 ] 118 0.023% 100.051% ( 380, 580 ] 113 0.022% 100.073% ( 580, 870 ] 67 0.013% 100.086% ( 870, 1300 ] 43 0.008% 100.094% ( 1300, 1900 ] 26 0.005% 100.099% ( 1900, 2900 ] 30 0.006% 100.105% ( 2900, 4400 ] 30 0.006% 100.111% ( 4400, 6600 ] 5 0.001% 100.112% ( 6600, 9900 ] 1 0.000% 100.112% ** Level 2 read latency histogram (micros): Count: 124198 Average: 2.3032 StdDev: 13.01 Min: 1 Median: 1.3994 Max: 1688 Percentiles: P50: 1.40 P75: 1.81 P99: 5.96 P99.9: 94.82 P99.99: 554.19 ------------------------------------------------------ [ 0, 1 ] 31920 25.701% 25.701% ##### ( 1, 2 ] 75554 60.834% 86.534% ############ ( 2, 3 ] 8216 6.615% 93.150% # ( 3, 4 ] 4611 3.713% 96.862% # ( 4, 6 ] 2711 2.183% 99.045% ( 6, 10 ] 916 0.738% 99.783% ( 10, 15 ] 108 0.087% 99.870% ( 15, 22 ] 10 0.008% 99.878% ( 22, 34 ] 3 0.002% 99.880% ( 34, 51 ] 1 0.001% 99.881% ( 76, 110 ] 43 0.035% 99.915% ( 110, 170 ] 44 0.035% 99.951% ( 170, 250 ] 24 0.019% 99.970% ( 250, 380 ] 15 0.012% 99.982% ( 380, 580 ] 11 0.009% 99.991% ( 580, 870 ] 5 0.004% 99.995% ( 870, 1300 ] 2 0.002% 99.997% ( 1300, 1900 ] 4 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 621571 Average: 3.4677 StdDev: 34.95 Min: 1 Median: 1.7385 Max: 6024 Percentiles: P50: 1.74 P75: 2.61 P99: 8.92 P99.9: 113.78 P99.99: 268.67 ------------------------------------------------------ [ 0, 1 ] 45589 7.334% 7.334% # ( 1, 2 ] 359111 57.775% 65.109% ############ ( 2, 3 ] 100917 16.236% 81.345% ### ( 3, 4 ] 52457 8.439% 89.784% ## ( 4, 6 ] 49464 7.958% 97.742% ## ( 6, 10 ] 10719 1.725% 99.467% ( 10, 15 ] 2197 0.353% 99.820% ( 15, 22 ] 220 0.035% 99.856% ( 22, 34 ] 35 0.006% 99.861% ( 34, 51 ] 10 0.002% 99.863% ( 51, 76 ] 38 0.006% 99.869% ( 76, 110 ] 170 0.027% 99.896% ( 110, 170 ] 356 0.057% 99.954% ( 170, 250 ] 202 0.032% 99.986% ( 250, 380 ] 166 0.027% 100.013% ( 380, 580 ] 146 0.023% 100.036% ( 580, 870 ] 78 0.013% 100.049% ( 870, 1300 ] 35 0.006% 100.055% ( 1300, 1900 ] 15 0.002% 100.057% ( 1900, 2900 ] 24 0.004% 100.061% ( 2900, 4400 ] 21 0.003% 100.064% ( 4400, 6600 ] 5 0.001% 100.065% ** Level 4 read latency histogram (micros): Count: 15340 Average: 80.0336 StdDev: 426.53 Min: 0 Median: 1.8949 Max: 12130 Percentiles: P50: 1.89 P75: 3.24 P99: 2029.73 P99.9: 5171.16 P99.99: 7406.30 ------------------------------------------------------ [ 0, 1 ] 825 5.378% 5.378% # ( 1, 2 ] 7650 49.870% 55.248% ########## ( 2, 3 ] 2647 17.256% 72.503% ### ( 3, 4 ] 1626 10.600% 83.103% ## ( 4, 6 ] 1049 6.838% 89.941% # ( 6, 10 ] 309 2.014% 91.956% ( 10, 15 ] 126 0.821% 92.777% ( 15, 22 ] 26 0.169% 92.947% ( 22, 34 ] 5 0.033% 92.979% ( 34, 51 ] 1 0.007% 92.986% ( 76, 110 ] 27 0.176% 93.162% ( 110, 170 ] 59 0.385% 93.546% ( 170, 250 ] 81 0.528% 94.074% ( 250, 380 ] 117 0.763% 94.837% ( 380, 580 ] 168 1.095% 95.932% ( 580, 870 ] 194 1.265% 97.197% ( 870, 1300 ] 165 1.076% 98.272% ( 1300, 1900 ] 103 0.671% 98.944% ( 1900, 2900 ] 74 0.482% 99.426% ( 2900, 4400 ] 67 0.437% 99.863% ( 4400, 6600 ] 19 0.124% 99.987% ( 6600, 9900 ] 6 0.039% 100.026% ( 9900, 14000 ] 2 0.013% 100.039% ** Level 5 read latency histogram (micros): Count: 85 Average: 1147.2941 StdDev: 1282.22 Min: 75 Median: 400.0000 Max: 5058 Percentiles: P50: 400.00 P75: 2179.41 P99: 5058.00 P99.9: 5058.00 P99.99: 5058.00 ------------------------------------------------------ ( 51, 76 ] 1 1.176% 1.176% ( 76, 110 ] 12 14.118% 15.294% ### ( 110, 170 ] 13 15.294% 30.588% ### ( 170, 250 ] 10 11.765% 42.353% ## ( 250, 380 ] 6 7.059% 49.412% # ( 380, 580 ] 5 5.882% 55.294% # ( 580, 870 ] 4 4.706% 60.000% # ( 870, 1300 ] 4 4.706% 64.706% # ( 1300, 1900 ] 4 4.706% 69.412% # ( 1900, 2900 ] 17 20.000% 89.412% #### ( 2900, 4400 ] 7 8.235% 97.647% ## ( 4400, 6600 ] 2 2.353% 100.000% ** DB Stats ** Uptime(secs): 27.4 total, 5.0 interval Cumulative writes: 0 writes, 7000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 6.73 GB, 251.72 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.203 H:M:S, 30.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 197.17 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.033 H:M:S, 40.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 8 num-running-flushes: 1 2024/07/23-19:44:56 ... thread 0: (1000000,8000000) ops and (303964.7,262492.1) ops/second in (3.289856,30.477113) 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/12 3.87 GB 138.4 6.4 0.0 6.4 14.0 7.6 0.0 1.8 138.4 303.3 47.32 43.78 132 0.358 6651K 8086 0.0 0.0 L1 21/21 1.70 GB 0.0 3.7 3.5 0.2 3.7 3.5 0.2 1.0 228.6 226.3 16.64 16.02 3 5.547 3862K 36K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 1.8 2.0 246.6 246.5 1.53 1.48 2 0.766 383K 208 0.0 0.0 L3 22/0 951.10 MB 1.0 3.5 1.7 1.8 3.5 1.7 0.4 2.0 209.7 208.8 17.05 15.22 14 1.218 3631K 14K 0.0 0.0 L4 181/0 9.73 GB 1.0 1.1 1.1 0.1 1.1 1.1 0.8 1.1 143.4 143.1 8.08 5.40 17 0.475 1168K 1968 0.0 0.0 L5 1064/0 87.48 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 1305/33 103.70 GB 0.0 15.1 6.5 8.6 22.7 14.0 4.9 3.0 170.7 256.2 90.62 81.90 168 0.539 15M 61K 0.0 0.0 Int 0/0 0.00 KB 0.0 15.1 6.5 8.6 22.7 14.0 4.9 3.0 170.7 256.2 90.62 81.90 168 0.539 15M 61K 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.1 6.5 8.6 15.0 6.4 0.0 0.0 227.8 226.9 67.88 62.24 58 1.170 15M 61K 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 343.5 22.74 19.66 110 0.207 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 30.7 total, 30.5 interval Flush(GB): cumulative 7.629, interval 7.629 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.67 GB write, 757.19 MB/s write, 15.10 GB read, 504.44 MB/s read, 90.6 seconds Interval compaction: 22.67 GB write, 761.68 MB/s write, 15.10 GB read, 507.43 MB/s read, 90.6 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: 28, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 15, total-stops: 28, interval: 43 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2924791 Average: 2.3021 StdDev: 15.14 Min: 0 Median: 1.4668 Max: 7419 Percentiles: P50: 1.47 P75: 1.85 P99: 5.88 P99.9: 12.59 P99.99: 115.22 ------------------------------------------------------ [ 0, 1 ] 566735 19.377% 19.377% #### ( 1, 2 ] 1918796 65.605% 84.981% ############# ( 2, 3 ] 223136 7.629% 92.611% ## ( 3, 4 ] 116334 3.978% 96.588% # ( 4, 6 ] 75200 2.571% 99.159% # ( 6, 10 ] 19816 0.678% 99.837% ( 10, 15 ] 3575 0.122% 99.959% ( 15, 22 ] 302 0.010% 99.969% ( 22, 34 ] 28 0.001% 99.970% ( 34, 51 ] 17 0.001% 99.971% ( 51, 76 ] 35 0.001% 99.972% ( 76, 110 ] 485 0.017% 99.989% ( 110, 170 ] 489 0.017% 100.005% ( 170, 250 ] 229 0.008% 100.013% ( 250, 380 ] 190 0.006% 100.020% ( 380, 580 ] 156 0.005% 100.025% ( 580, 870 ] 115 0.004% 100.029% ( 870, 1300 ] 72 0.002% 100.031% ( 1300, 1900 ] 25 0.001% 100.032% ( 1900, 2900 ] 20 0.001% 100.033% ( 2900, 4400 ] 14 0.000% 100.033% ( 4400, 6600 ] 2 0.000% 100.034% ( 6600, 9900 ] 1 0.000% 100.034% ** Level 1 read latency histogram (micros): Count: 550426 Average: 3.4814 StdDev: 40.60 Min: 0 Median: 1.6801 Max: 7409 Percentiles: P50: 1.68 P75: 2.38 P99: 8.63 P99.9: 15.52 P99.99: 150.22 ------------------------------------------------------ [ 0, 1 ] 44793 8.138% 8.138% ## ( 1, 2 ] 338791 61.551% 69.689% ############ ( 2, 3 ] 77398 14.061% 83.750% ### ( 3, 4 ] 40974 7.444% 91.194% # ( 4, 6 ] 37073 6.735% 97.929% # ( 6, 10 ] 8953 1.627% 99.556% ( 10, 15 ] 1881 0.342% 99.898% ( 15, 22 ] 184 0.033% 99.931% ( 22, 34 ] 16 0.003% 99.934% ( 34, 51 ] 5 0.001% 99.935% ( 51, 76 ] 19 0.003% 99.938% ( 76, 110 ] 169 0.031% 99.969% ( 110, 170 ] 173 0.031% 100.001% ( 170, 250 ] 111 0.020% 100.021% ( 250, 380 ] 133 0.024% 100.045% ( 380, 580 ] 124 0.023% 100.067% ( 580, 870 ] 70 0.013% 100.080% ( 870, 1300 ] 44 0.008% 100.088% ( 1300, 1900 ] 26 0.005% 100.093% ( 1900, 2900 ] 30 0.005% 100.098% ( 2900, 4400 ] 30 0.005% 100.104% ( 4400, 6600 ] 5 0.001% 100.105% ( 6600, 9900 ] 1 0.000% 100.105% ** Level 2 read latency histogram (micros): Count: 124198 Average: 2.3032 StdDev: 13.01 Min: 1 Median: 1.3994 Max: 1688 Percentiles: P50: 1.40 P75: 1.81 P99: 5.96 P99.9: 94.82 P99.99: 554.19 ------------------------------------------------------ [ 0, 1 ] 31920 25.701% 25.701% ##### ( 1, 2 ] 75554 60.834% 86.534% ############ ( 2, 3 ] 8216 6.615% 93.150% # ( 3, 4 ] 4611 3.713% 96.862% # ( 4, 6 ] 2711 2.183% 99.045% ( 6, 10 ] 916 0.738% 99.783% ( 10, 15 ] 108 0.087% 99.870% ( 15, 22 ] 10 0.008% 99.878% ( 22, 34 ] 3 0.002% 99.880% ( 34, 51 ] 1 0.001% 99.881% ( 76, 110 ] 43 0.035% 99.915% ( 110, 170 ] 44 0.035% 99.951% ( 170, 250 ] 24 0.019% 99.970% ( 250, 380 ] 15 0.012% 99.982% ( 380, 580 ] 11 0.009% 99.991% ( 580, 870 ] 5 0.004% 99.995% ( 870, 1300 ] 2 0.002% 99.997% ( 1300, 1900 ] 4 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 632785 Average: 3.4490 StdDev: 34.64 Min: 1 Median: 1.7364 Max: 6024 Percentiles: P50: 1.74 P75: 2.60 P99: 8.89 P99.9: 110.88 P99.99: 263.10 ------------------------------------------------------ [ 0, 1 ] 46392 7.331% 7.331% # ( 1, 2 ] 366648 57.942% 65.273% ############ ( 2, 3 ] 102436 16.188% 81.461% ### ( 3, 4 ] 53129 8.396% 89.858% ## ( 4, 6 ] 50047 7.909% 97.767% ## ( 6, 10 ] 10801 1.707% 99.473% ( 10, 15 ] 2221 0.351% 99.824% ( 15, 22 ] 220 0.035% 99.859% ( 22, 34 ] 35 0.006% 99.865% ( 34, 51 ] 10 0.002% 99.866% ( 51, 76 ] 38 0.006% 99.872% ( 76, 110 ] 170 0.027% 99.899% ( 110, 170 ] 356 0.056% 99.955% ( 170, 250 ] 202 0.032% 99.987% ( 250, 380 ] 166 0.026% 100.014% ( 380, 580 ] 146 0.023% 100.037% ( 580, 870 ] 78 0.012% 100.049% ( 870, 1300 ] 35 0.006% 100.055% ( 1300, 1900 ] 15 0.002% 100.057% ( 1900, 2900 ] 24 0.004% 100.061% ( 2900, 4400 ] 21 0.003% 100.064% ( 4400, 6600 ] 5 0.001% 100.065% ** Level 4 read latency histogram (micros): Count: 16175 Average: 76.2333 StdDev: 415.82 Min: 0 Median: 1.8730 Max: 12130 Percentiles: P50: 1.87 P75: 3.16 P99: 1916.89 P99.9: 5074.47 P99.99: 7360.37 ------------------------------------------------------ [ 0, 1 ] 957 5.917% 5.917% # ( 1, 2 ] 8168 50.498% 56.414% ########## ( 2, 3 ] 2732 16.890% 73.304% ### ( 3, 4 ] 1669 10.318% 83.623% ## ( 4, 6 ] 1074 6.640% 90.263% # ( 6, 10 ] 328 2.028% 92.291% ( 10, 15 ] 128 0.791% 93.082% ( 15, 22 ] 26 0.161% 93.243% ( 22, 34 ] 5 0.031% 93.274% ( 34, 51 ] 1 0.006% 93.280% ( 76, 110 ] 27 0.167% 93.447% ( 110, 170 ] 60 0.371% 93.818% ( 170, 250 ] 86 0.532% 94.349% ( 250, 380 ] 118 0.730% 95.079% ( 380, 580 ] 168 1.039% 96.117% ( 580, 870 ] 197 1.218% 97.335% ( 870, 1300 ] 165 1.020% 98.355% ( 1300, 1900 ] 103 0.637% 98.992% ( 1900, 2900 ] 74 0.457% 99.450% ( 2900, 4400 ] 67 0.414% 99.864% ( 4400, 6600 ] 19 0.117% 99.981% ( 6600, 9900 ] 6 0.037% 100.019% ( 9900, 14000 ] 2 0.012% 100.031% ** Level 5 read latency histogram (micros): Count: 100 Average: 1155.1200 StdDev: 1292.67 Min: 75 Median: 408.5714 Max: 5058 Percentiles: P50: 408.57 P75: 2194.12 P99: 5058.00 P99.9: 5058.00 P99.99: 5058.00 ------------------------------------------------------ ( 51, 76 ] 1 1.000% 1.000% ( 76, 110 ] 14 14.000% 15.000% ### ( 110, 170 ] 13 13.000% 28.000% ### ( 170, 250 ] 10 10.000% 38.000% ## ( 250, 380 ] 11 11.000% 49.000% ## ( 380, 580 ] 7 7.000% 56.000% # ( 580, 870 ] 5 5.000% 61.000% # ( 870, 1300 ] 5 5.000% 66.000% # ( 1300, 1900 ] 4 4.000% 70.000% # ( 1900, 2900 ] 17 17.000% 87.000% ### ( 2900, 4400 ] 11 11.000% 98.000% ## ( 4400, 6600 ] 2 2.000% 100.000% ** DB Stats ** Uptime(secs): 30.7 total, 3.3 interval Cumulative writes: 0 writes, 8000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 7.69 GB, 256.80 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.837 H:M:S, 28.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 299.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:0.634 H:M:S, 19.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/07/23-19:45:15 ... thread 0: (1000000,9000000) ops and (52556.4,181802.4) ops/second in (19.027177,49.504290) 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/14 2.46 GB 12.6 6.9 0.0 6.9 15.4 8.5 0.0 1.8 134.9 300.9 52.31 47.91 147 0.356 7163K 8548 0.0 0.0 L1 13/13 1.54 GB 0.0 7.7 5.8 1.9 7.6 5.7 0.2 1.3 225.4 222.5 34.92 32.88 4 8.730 7514K 36K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 4.2 2.0 246.6 246.5 1.53 1.48 2 0.766 383K 208 0.0 0.0 L3 18/0 994.55 MB 1.0 7.5 3.8 3.6 7.4 3.8 0.7 1.9 175.7 174.8 43.46 33.78 31 1.402 7757K 42K 0.0 0.0 L4 177/0 9.75 GB 1.0 3.6 3.4 0.2 3.6 3.4 0.8 1.1 145.5 145.1 25.38 16.99 44 0.577 3637K 4127 0.0 0.0 L5 1092/0 89.75 GB 0.9 0.0 0.0 0.0 0.0 0.0 3.9 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1316/27 104.47 GB 0.0 26.0 13.2 12.8 34.3 21.5 9.8 4.0 169.0 223.1 157.59 133.04 228 0.691 26M 92K 0.0 0.0 Int 0/0 0.00 KB 0.0 26.0 13.2 12.8 34.3 21.5 9.8 4.0 169.0 223.1 157.59 133.04 228 0.691 26M 92K 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 26.0 13.2 12.8 25.9 13.0 0.0 0.0 202.2 200.9 131.75 111.08 105 1.255 26M 92K 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 336.4 25.85 21.96 123 0.210 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 49.7 total, 49.5 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: 34.34 GB write, 707.77 MB/s write, 26.01 GB read, 536.05 MB/s read, 157.6 seconds Interval compaction: 34.34 GB write, 710.35 MB/s write, 26.01 GB read, 538.01 MB/s read, 157.6 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 16, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 16, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 35, pending-compaction-bytes-delays: 40, pending-compaction-bytes-stops: 0, total-delays: 56, total-stops: 35, interval: 91 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3645831 Average: 2.7093 StdDev: 27.15 Min: 0 Median: 1.4706 Max: 7419 Percentiles: P50: 1.47 P75: 1.86 P99: 6.64 P99.9: 100.81 P99.99: 413.73 ------------------------------------------------------ [ 0, 1 ] 715715 19.631% 19.631% #### ( 1, 2 ] 2352612 64.529% 84.160% ############# ( 2, 3 ] 281870 7.731% 91.891% ## ( 3, 4 ] 148006 4.060% 95.951% # ( 4, 6 ] 106376 2.918% 98.869% # ( 6, 10 ] 29746 0.816% 99.684% ( 10, 15 ] 5627 0.154% 99.839% ( 15, 22 ] 508 0.014% 99.853% ( 22, 34 ] 45 0.001% 99.854% ( 34, 51 ] 21 0.001% 99.854% ( 51, 76 ] 107 0.003% 99.857% ( 76, 110 ] 2130 0.058% 99.916% ( 110, 170 ] 1674 0.046% 99.962% ( 170, 250 ] 451 0.012% 99.974% ( 250, 380 ] 489 0.013% 99.988% ( 380, 580 ] 542 0.015% 100.002% ( 580, 870 ] 426 0.012% 100.014% ( 870, 1300 ] 248 0.007% 100.021% ( 1300, 1900 ] 116 0.003% 100.024% ( 1900, 2900 ] 72 0.002% 100.026% ( 2900, 4400 ] 65 0.002% 100.028% ( 4400, 6600 ] 13 0.000% 100.028% ( 6600, 9900 ] 2 0.000% 100.028% ** Level 1 read latency histogram (micros): Count: 1508519 Average: 4.9675 StdDev: 76.39 Min: 0 Median: 1.6451 Max: 8726 Percentiles: P50: 1.65 P75: 2.39 P99: 9.34 P99.9: 124.30 P99.99: 400.84 ------------------------------------------------------ [ 0, 1 ] 207239 13.738% 13.738% ### ( 1, 2 ] 848009 56.215% 69.953% ########### ( 2, 3 ] 193079 12.799% 82.752% ### ( 3, 4 ] 110824 7.347% 90.098% # ( 4, 6 ] 110966 7.356% 97.454% # ( 6, 10 ] 27953 1.853% 99.307% ( 10, 15 ] 6256 0.415% 99.722% ( 15, 22 ] 711 0.047% 99.769% ( 22, 34 ] 54 0.004% 99.773% ( 34, 51 ] 30 0.002% 99.775% ( 51, 76 ] 202 0.013% 99.788% ( 76, 110 ] 1482 0.098% 99.886% ( 110, 170 ] 862 0.057% 99.944% ( 170, 250 ] 291 0.019% 99.963% ( 250, 380 ] 357 0.024% 99.986% ( 380, 580 ] 510 0.034% 100.020% ( 580, 870 ] 483 0.032% 100.052% ( 870, 1300 ] 379 0.025% 100.077% ( 1300, 1900 ] 192 0.013% 100.090% ( 1900, 2900 ] 206 0.014% 100.104% ( 2900, 4400 ] 282 0.019% 100.123% ( 4400, 6600 ] 76 0.005% 100.128% ( 6600, 9900 ] 13 0.001% 100.128% ** Level 2 read latency histogram (micros): Count: 124198 Average: 2.3032 StdDev: 13.01 Min: 1 Median: 1.3994 Max: 1688 Percentiles: P50: 1.40 P75: 1.81 P99: 5.96 P99.9: 94.82 P99.99: 554.19 ------------------------------------------------------ [ 0, 1 ] 31920 25.701% 25.701% ##### ( 1, 2 ] 75554 60.834% 86.534% ############ ( 2, 3 ] 8216 6.615% 93.150% # ( 3, 4 ] 4611 3.713% 96.862% # ( 4, 6 ] 2711 2.183% 99.045% ( 6, 10 ] 916 0.738% 99.783% ( 10, 15 ] 108 0.087% 99.870% ( 15, 22 ] 10 0.008% 99.878% ( 22, 34 ] 3 0.002% 99.880% ( 34, 51 ] 1 0.001% 99.881% ( 76, 110 ] 43 0.035% 99.915% ( 110, 170 ] 44 0.035% 99.951% ( 170, 250 ] 24 0.019% 99.970% ( 250, 380 ] 15 0.012% 99.982% ( 380, 580 ] 11 0.009% 99.991% ( 580, 870 ] 5 0.004% 99.995% ( 870, 1300 ] 2 0.002% 99.997% ( 1300, 1900 ] 4 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 1699184 Average: 4.5265 StdDev: 64.46 Min: 1 Median: 1.8470 Max: 11737 Percentiles: P50: 1.85 P75: 2.93 P99: 8.96 P99.9: 14.22 P99.99: 17.53 ------------------------------------------------------ [ 0, 1 ] 73572 4.330% 4.330% # ( 1, 2 ] 916219 53.921% 58.251% ########### ( 2, 3 ] 307469 18.095% 76.346% #### ( 3, 4 ] 179784 10.581% 86.927% ## ( 4, 6 ] 181112 10.659% 97.585% ## ( 6, 10 ] 32485 1.912% 99.497% ( 10, 15 ] 8101 0.477% 99.974% ( 15, 22 ] 754 0.044% 100.018% ( 22, 34 ] 71 0.004% 100.023% ( 34, 51 ] 33 0.002% 100.024% ( 51, 76 ] 117 0.007% 100.031% ( 76, 110 ] 203 0.012% 100.043% ( 110, 170 ] 421 0.025% 100.068% ( 170, 250 ] 355 0.021% 100.089% ( 250, 380 ] 449 0.026% 100.115% ( 380, 580 ] 486 0.029% 100.144% ( 580, 870 ] 390 0.023% 100.167% ( 870, 1300 ] 307 0.018% 100.185% ( 1300, 1900 ] 146 0.009% 100.194% ( 1900, 2900 ] 159 0.009% 100.203% ( 2900, 4400 ] 193 0.011% 100.214% ( 4400, 6600 ] 56 0.003% 100.218% ( 6600, 9900 ] 14 0.001% 100.218% ( 9900, 14000 ] 3 0.000% 100.219% ** Level 4 read latency histogram (micros): Count: 61140 Average: 64.6793 StdDev: 391.05 Min: 0 Median: 1.7980 Max: 12130 Percentiles: P50: 1.80 P75: 2.88 P99: 1808.90 P99.9: 5265.33 P99.99: 7813.99 ------------------------------------------------------ [ 0, 1 ] 4093 6.694% 6.694% # ( 1, 2 ] 33180 54.269% 60.963% ########### ( 2, 3 ] 9766 15.973% 76.937% ### ( 3, 4 ] 5585 9.135% 86.071% ## ( 4, 6 ] 3594 5.878% 91.950% # ( 6, 10 ] 1172 1.917% 93.867% ( 10, 15 ] 376 0.615% 94.482% ( 15, 22 ] 62 0.101% 94.583% ( 22, 34 ] 9 0.015% 94.598% ( 34, 51 ] 1 0.002% 94.599% ( 51, 76 ] 2 0.003% 94.603% ( 76, 110 ] 105 0.172% 94.774% ( 110, 170 ] 216 0.353% 95.128% ( 170, 250 ] 227 0.371% 95.499% ( 250, 380 ] 327 0.535% 96.034% ( 380, 580 ] 484 0.792% 96.825% ( 580, 870 ] 566 0.926% 97.751% ( 870, 1300 ] 510 0.834% 98.585% ( 1300, 1900 ] 299 0.489% 99.074% ( 1900, 2900 ] 234 0.383% 99.457% ( 2900, 4400 ] 239 0.391% 99.848% ( 4400, 6600 ] 81 0.132% 99.980% ( 6600, 9900 ] 16 0.026% 100.007% ( 9900, 14000 ] 4 0.007% 100.013% ** Level 5 read latency histogram (micros): Count: 240 Average: 1229.1458 StdDev: 1423.37 Min: 75 Median: 480.0000 Max: 7787 Percentiles: P50: 480.00 P75: 2185.71 P99: 6086.67 P99.9: 7787.00 P99.99: 7787.00 ------------------------------------------------------ ( 51, 76 ] 1 0.417% 0.417% ( 76, 110 ] 27 11.250% 11.667% ## ( 110, 170 ] 28 11.667% 23.333% ## ( 170, 250 ] 27 11.250% 34.583% ## ( 250, 380 ] 28 11.667% 46.250% ## ( 380, 580 ] 18 7.500% 53.750% ## ( 580, 870 ] 17 7.083% 60.833% # ( 870, 1300 ] 15 6.250% 67.083% # ( 1300, 1900 ] 11 4.583% 71.667% # ( 1900, 2900 ] 28 11.667% 83.333% ## ( 2900, 4400 ] 33 13.750% 97.083% ### ( 4400, 6600 ] 6 2.500% 99.583% # ( 6600, 9900 ] 1 0.417% 100.000% ** DB Stats ** Uptime(secs): 49.7 total, 19.0 interval Cumulative writes: 0 writes, 9000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 8.65 GB, 178.27 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:24.601 H:M:S, 49.5 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 51.73 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:15.764 H:M:S, 82.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/07/23-19:45:19 ... thread 0: (1000000,10000000) ops and (269848.7,187934.4) ops/second in (3.705780,53.210070) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 19/14 3.50 GB 125.9 8.1 0.0 8.1 17.6 9.5 0.0 1.8 137.7 300.4 59.93 55.11 166 0.361 8378K 9860 0.0 0.0 L1 13/13 1.54 GB 0.0 7.7 5.8 1.9 7.6 5.7 0.2 1.3 225.4 222.5 34.92 32.88 4 8.730 7514K 36K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 4.2 2.0 246.6 246.5 1.53 1.48 2 0.766 383K 208 0.0 0.0 L3 18/0 994.55 MB 1.0 7.5 3.8 3.6 7.4 3.8 0.7 1.9 175.7 174.8 43.46 33.78 31 1.402 7757K 42K 0.0 0.0 L4 177/0 9.75 GB 1.0 3.6 3.4 0.2 3.6 3.4 0.8 1.1 145.5 145.1 25.38 16.99 44 0.577 3637K 4127 0.0 0.0 L5 1092/0 89.75 GB 0.9 0.0 0.0 0.0 0.0 0.0 3.9 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1319/27 105.51 GB 0.0 27.2 13.2 14.0 36.6 22.5 9.8 3.8 168.4 226.6 165.22 140.25 247 0.669 27M 93K 0.0 0.0 Int 0/0 0.00 KB 0.0 27.2 13.2 14.0 36.6 22.5 9.8 3.8 168.4 226.6 165.22 140.25 247 0.669 27M 93K 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 27.2 13.2 14.0 27.0 13.0 0.0 0.0 204.2 203.0 136.32 115.56 109 1.251 27M 93K 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 337.8 28.90 24.69 138 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): 53.4 total, 53.2 interval Flush(GB): cumulative 9.536, interval 9.536 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: 36.56 GB write, 701.09 MB/s write, 27.18 GB read, 521.26 MB/s read, 165.2 seconds Interval compaction: 36.56 GB write, 703.47 MB/s write, 27.18 GB read, 523.03 MB/s read, 165.2 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 20, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 20, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 39, pending-compaction-bytes-delays: 40, pending-compaction-bytes-stops: 0, total-delays: 60, total-stops: 39, interval: 99 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 4094694 Average: 2.6575 StdDev: 25.95 Min: 0 Median: 1.4722 Max: 7419 Percentiles: P50: 1.47 P75: 1.86 P99: 6.52 P99.9: 91.82 P99.99: 336.63 ------------------------------------------------------ [ 0, 1 ] 790138 19.297% 19.297% #### ( 1, 2 ] 2662278 65.018% 84.314% ############# ( 2, 3 ] 317463 7.753% 92.067% ## ( 3, 4 ] 164232 4.011% 96.078% # ( 4, 6 ] 115315 2.816% 98.894% # ( 6, 10 ] 33156 0.810% 99.704% ( 10, 15 ] 6277 0.153% 99.857% ( 15, 22 ] 544 0.013% 99.871% ( 22, 34 ] 52 0.001% 99.872% ( 34, 51 ] 25 0.001% 99.873% ( 51, 76 ] 109 0.003% 99.875% ( 76, 110 ] 2173 0.053% 99.928% ( 110, 170 ] 1714 0.042% 99.970% ( 170, 250 ] 471 0.012% 99.982% ( 250, 380 ] 508 0.012% 99.994% ( 380, 580 ] 565 0.014% 100.008% ( 580, 870 ] 436 0.011% 100.019% ( 870, 1300 ] 251 0.006% 100.025% ( 1300, 1900 ] 116 0.003% 100.028% ( 1900, 2900 ] 75 0.002% 100.029% ( 2900, 4400 ] 66 0.002% 100.031% ( 4400, 6600 ] 14 0.000% 100.031% ( 6600, 9900 ] 2 0.000% 100.031% ** Level 1 read latency histogram (micros): Count: 1575033 Average: 4.8701 StdDev: 74.79 Min: 0 Median: 1.6392 Max: 8726 Percentiles: P50: 1.64 P75: 2.36 P99: 9.31 P99.9: 125.11 P99.99: 402.24 ------------------------------------------------------ [ 0, 1 ] 214930 13.646% 13.646% ### ( 1, 2 ] 895797 56.875% 70.521% ########### ( 2, 3 ] 198685 12.615% 83.136% ### ( 3, 4 ] 113279 7.192% 90.328% # ( 4, 6 ] 112534 7.145% 97.473% # ( 6, 10 ] 29057 1.845% 99.317% ( 10, 15 ] 6355 0.403% 99.721% ( 15, 22 ] 723 0.046% 99.767% ( 22, 34 ] 54 0.003% 99.770% ( 34, 51 ] 30 0.002% 99.772% ( 51, 76 ] 202 0.013% 99.785% ( 76, 110 ] 1579 0.100% 99.885% ( 110, 170 ] 925 0.059% 99.944% ( 170, 250 ] 299 0.019% 99.963% ( 250, 380 ] 369 0.023% 99.986% ( 380, 580 ] 517 0.033% 100.019% ( 580, 870 ] 487 0.031% 100.050% ( 870, 1300 ] 379 0.024% 100.074% ( 1300, 1900 ] 192 0.012% 100.086% ( 1900, 2900 ] 206 0.013% 100.099% ( 2900, 4400 ] 282 0.018% 100.117% ( 4400, 6600 ] 76 0.005% 100.122% ( 6600, 9900 ] 13 0.001% 100.123% ** Level 2 read latency histogram (micros): Count: 124198 Average: 2.3032 StdDev: 13.01 Min: 1 Median: 1.3994 Max: 1688 Percentiles: P50: 1.40 P75: 1.81 P99: 5.96 P99.9: 94.82 P99.99: 554.19 ------------------------------------------------------ [ 0, 1 ] 31920 25.701% 25.701% ##### ( 1, 2 ] 75554 60.834% 86.534% ############ ( 2, 3 ] 8216 6.615% 93.150% # ( 3, 4 ] 4611 3.713% 96.862% # ( 4, 6 ] 2711 2.183% 99.045% ( 6, 10 ] 916 0.738% 99.783% ( 10, 15 ] 108 0.087% 99.870% ( 15, 22 ] 10 0.008% 99.878% ( 22, 34 ] 3 0.002% 99.880% ( 34, 51 ] 1 0.001% 99.881% ( 76, 110 ] 43 0.035% 99.915% ( 110, 170 ] 44 0.035% 99.951% ( 170, 250 ] 24 0.019% 99.970% ( 250, 380 ] 15 0.012% 99.982% ( 380, 580 ] 11 0.009% 99.991% ( 580, 870 ] 5 0.004% 99.995% ( 870, 1300 ] 2 0.002% 99.997% ( 1300, 1900 ] 4 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 1699184 Average: 4.5265 StdDev: 64.46 Min: 1 Median: 1.8470 Max: 11737 Percentiles: P50: 1.85 P75: 2.93 P99: 8.96 P99.9: 14.22 P99.99: 17.53 ------------------------------------------------------ [ 0, 1 ] 73572 4.330% 4.330% # ( 1, 2 ] 916219 53.921% 58.251% ########### ( 2, 3 ] 307469 18.095% 76.346% #### ( 3, 4 ] 179784 10.581% 86.927% ## ( 4, 6 ] 181112 10.659% 97.585% ## ( 6, 10 ] 32485 1.912% 99.497% ( 10, 15 ] 8101 0.477% 99.974% ( 15, 22 ] 754 0.044% 100.018% ( 22, 34 ] 71 0.004% 100.023% ( 34, 51 ] 33 0.002% 100.024% ( 51, 76 ] 117 0.007% 100.031% ( 76, 110 ] 203 0.012% 100.043% ( 110, 170 ] 421 0.025% 100.068% ( 170, 250 ] 355 0.021% 100.089% ( 250, 380 ] 449 0.026% 100.115% ( 380, 580 ] 486 0.029% 100.144% ( 580, 870 ] 390 0.023% 100.167% ( 870, 1300 ] 307 0.018% 100.185% ( 1300, 1900 ] 146 0.009% 100.194% ( 1900, 2900 ] 159 0.009% 100.203% ( 2900, 4400 ] 193 0.011% 100.214% ( 4400, 6600 ] 56 0.003% 100.218% ( 6600, 9900 ] 14 0.001% 100.218% ( 9900, 14000 ] 3 0.000% 100.219% ** Level 4 read latency histogram (micros): Count: 61140 Average: 64.6793 StdDev: 391.05 Min: 0 Median: 1.7980 Max: 12130 Percentiles: P50: 1.80 P75: 2.88 P99: 1808.90 P99.9: 5265.33 P99.99: 7813.99 ------------------------------------------------------ [ 0, 1 ] 4093 6.694% 6.694% # ( 1, 2 ] 33180 54.269% 60.963% ########### ( 2, 3 ] 9766 15.973% 76.937% ### ( 3, 4 ] 5585 9.135% 86.071% ## ( 4, 6 ] 3594 5.878% 91.950% # ( 6, 10 ] 1172 1.917% 93.867% ( 10, 15 ] 376 0.615% 94.482% ( 15, 22 ] 62 0.101% 94.583% ( 22, 34 ] 9 0.015% 94.598% ( 34, 51 ] 1 0.002% 94.599% ( 51, 76 ] 2 0.003% 94.603% ( 76, 110 ] 105 0.172% 94.774% ( 110, 170 ] 216 0.353% 95.128% ( 170, 250 ] 227 0.371% 95.499% ( 250, 380 ] 327 0.535% 96.034% ( 380, 580 ] 484 0.792% 96.825% ( 580, 870 ] 566 0.926% 97.751% ( 870, 1300 ] 510 0.834% 98.585% ( 1300, 1900 ] 299 0.489% 99.074% ( 1900, 2900 ] 234 0.383% 99.457% ( 2900, 4400 ] 239 0.391% 99.848% ( 4400, 6600 ] 81 0.132% 99.980% ( 6600, 9900 ] 16 0.026% 100.007% ( 9900, 14000 ] 4 0.007% 100.013% ** Level 5 read latency histogram (micros): Count: 240 Average: 1229.1458 StdDev: 1423.37 Min: 75 Median: 480.0000 Max: 7787 Percentiles: P50: 480.00 P75: 2185.71 P99: 6086.67 P99.9: 7787.00 P99.99: 7787.00 ------------------------------------------------------ ( 51, 76 ] 1 0.417% 0.417% ( 76, 110 ] 27 11.250% 11.667% ## ( 110, 170 ] 28 11.667% 23.333% ## ( 170, 250 ] 27 11.250% 34.583% ## ( 250, 380 ] 28 11.667% 46.250% ## ( 380, 580 ] 18 7.500% 53.750% ## ( 580, 870 ] 17 7.083% 60.833% # ( 870, 1300 ] 15 6.250% 67.083% # ( 1300, 1900 ] 11 4.583% 71.667% # ( 1900, 2900 ] 28 11.667% 83.333% ## ( 2900, 4400 ] 33 13.750% 97.083% ### ( 4400, 6600 ] 6 2.500% 99.583% # ( 6600, 9900 ] 1 0.417% 100.000% ** DB Stats ** Uptime(secs): 53.4 total, 3.7 interval Cumulative writes: 0 writes, 10M keys, 0 commit groups, 0.0 writes per commit group, ingest: 9.61 GB, 184.33 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:25.621 H:M:S, 48.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 265.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:1.021 H:M:S, 27.5 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 : 5.626 micros/op 177755 ops/sec 60.049 seconds 10673999 operations; 172.2 MB/s Microseconds per write: Count: 10673999 Average: 5.6257 StdDev: 269.09 Min: 0 Median: 1.7536 Max: 234338 Percentiles: P50: 1.75 P75: 2.75 P99: 9.45 P99.9: 1133.19 P99.99: 2713.12 ------------------------------------------------------ [ 0, 1 ] 1360520 12.746% 12.746% ### ( 1, 2 ] 5276422 49.432% 62.179% ########## ( 2, 3 ] 1829819 17.143% 79.321% ### ( 3, 4 ] 1438719 13.479% 92.800% ### ( 4, 6 ] 545668 5.112% 97.912% # ( 6, 10 ] 134696 1.262% 99.174% ( 10, 15 ] 44417 0.416% 99.590% ( 15, 22 ] 10088 0.095% 99.685% ( 22, 34 ] 2128 0.020% 99.705% ( 34, 51 ] 214 0.002% 99.707% ( 51, 76 ] 26 0.000% 99.707% ( 76, 110 ] 7261 0.068% 99.775% ( 110, 170 ] 3088 0.029% 99.804% ( 170, 250 ] 311 0.003% 99.807% ( 250, 380 ] 201 0.002% 99.809% ( 380, 580 ] 31 0.000% 99.809% ( 580, 870 ] 27 0.000% 99.809% ( 870, 1300 ] 15830 0.148% 99.958% ( 1300, 1900 ] 118 0.001% 99.959% ( 1900, 2900 ] 4117 0.039% 99.997% ( 2900, 4400 ] 198 0.002% 99.999% ( 4400, 6600 ] 60 0.001% 100.000% ( 6600, 9900 ] 15 0.000% 100.000% ( 9900, 14000 ] 3 0.000% 100.000% ( 14000, 22000 ] 2 0.000% 100.000% ( 22000, 33000 ] 1 0.000% 100.000% ( 50000, 75000 ] 1 0.000% 100.000% ( 110000, 170000 ] 1 0.000% 100.000% ( 170000, 250000 ] 17 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 : 214653 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 : 10673999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 11015566968 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 : 593 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 30437466 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 : 34396198867 rocksdb.compact.write.bytes COUNT : 34190004688 rocksdb.flush.write.bytes COUNT : 10965644919 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 : 58 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 : 242 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 : 10877191168 rocksdb.memtable.garbage.bytes.at.flush COUNT : 4195328 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 : 34494545162 rocksdb.non.last.level.read.count COUNT : 8336328 rocksdb.block.checksum.compute.count COUNT : 8335200 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.396145 P95 : 3.896211 P99 : 8.019339 P100 : 234332.000000 COUNT : 10673999 SUM : 54907467 rocksdb.compaction.times.micros P50 : 947297.297297 P95 : 2770000.000000 P99 : 13454000.000000 P100 : 18277555.000000 COUNT : 113 SUM : 142094737 rocksdb.compaction.times.cpu_micros P50 : 897317.073171 P95 : 2250000.000000 P99 : 13454000.000000 P100 : 16859426.000000 COUNT : 113 SUM : 121257045 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 : 706.290323 P95 : 1465.000000 P99 : 7441.500000 P100 : 8999.000000 COUNT : 149 SUM : 133002 rocksdb.compaction.outfile.sync.micros P50 : 1039.519231 P95 : 49008.333333 P99 : 85850.000000 P100 : 97174.000000 COUNT : 414 SUM : 3061549 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.500000 P95 : 1185.333333 P99 : 3335.000000 P100 : 4346.000000 COUNT : 284 SUM : 80795 rocksdb.table.open.io.micros P50 : 1314.705882 P95 : 6509.250000 P99 : 11997.833333 P100 : 15609.000000 COUNT : 593 SUM : 1183223 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.616222 P95 : 7.901550 P99 : 11.446356 P100 : 12139.000000 COUNT : 8333483 SUM : 49851920 rocksdb.read.block.get.micros P50 : 387.079646 P95 : 3488.095238 P99 : 5517.111111 P100 : 7951.000000 COUNT : 1186 SUM : 984187 rocksdb.write.raw.block.micros P50 : 0.512678 P95 : 0.974088 P99 : 2.838884 P100 : 20355.000000 COUNT : 10936692 SUM : 20988611 rocksdb.numfiles.in.singlecompaction P50 : 2.700000 P95 : 4.650000 P99 : 25.180000 P100 : 29.000000 COUNT : 147 SUM : 512 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.562346 P95 : 1171.771739 P99 : 2517.254519 P100 : 234101.000000 COUNT : 183796 SUM : 30456570 rocksdb.sst.read.micros P50 : 1.566272 P95 : 4.754305 P99 : 8.510350 P100 : 12130.000000 COUNT : 8336511 SUM : 32667360 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 : 10673999 SUM : 11015566968 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 : 206559.139785 P95 : 357575.000000 P99 : 476081.000000 P100 : 476081.000000 COUNT : 149 SUM : 30886191 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 : 391 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