[2024-12-13 19:06:39.021068] Starting SPDK v25.01-pre git sha1 e01cb43b8 / DPDK 22.11.4 initialization... [2024-12-13 19:06:39.021347] [ DPDK EAL parameters: rocksdb --no-shconf -c 0x1 --huge-unlink --no-telemetry --log-level=lib.eal:6 --log-level=lib.cryptodev:5 --log-level=lib.power:5 --log-level=user1:6 --base-virtaddr=0x200000000000 --match-allocations --file-prefix=spdk_pid182606 ] Set seed to 1734113199014367 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-12-13 19:06:39.137405] app.c: 919:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-12-13 19:06:39.160691] app.c: 612:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-12-13 19:06:39.160738] app.c: 613:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 182606' to capture a snapshot of events at runtime. [2024-12-13 19:06:39.160749] app.c: 618:app_setup_trace: *NOTICE*: 'spdk_trace' without parameters will also work if this is the only [2024-12-13 19:06:39.160759] app.c: 619:app_setup_trace: *NOTICE*: SPDK application currently running. [2024-12-13 19:06:39.160767] app.c: 620:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid182606 for offline analysis/debug. [2024-12-13 19:06:39.161365] reactor.c: 995:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Fri Dec 13 19:06:43 2024 CPU: 96 * Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz CPUCache: 36608 KB 2024/12/13-19:06:46 ... thread 0: (1000000,1000000) ops and (333870.8,333870.8) ops/second in (2.995171,2.995171) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 10/9 692.95 MB 6.3 0.0 0.0 0.0 0.9 0.9 0.0 1.0 0.0 344.7 2.56 2.29 12 0.213 0 0 0.0 0.0 L2 3/2 237.04 MB 0.5 0.3 0.2 0.2 0.3 0.2 0.0 1.8 243.0 242.8 1.43 1.36 2 0.717 353K 185 0.0 0.0 L3 9/0 755.93 MB 0.8 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 116/0 9.54 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 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/11 97.00 GB 0.0 0.3 0.2 0.2 1.2 1.0 0.0 1.4 87.3 308.1 3.99 3.65 14 0.285 353K 185 0.0 0.0 Int 0/0 0.00 KB 0.0 0.3 0.2 0.2 1.2 1.0 0.0 1.4 87.3 308.1 3.99 3.65 14 0.285 353K 185 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 0.3 0.2 0.2 0.3 0.2 0.0 0.0 243.0 242.8 1.43 1.36 2 0.717 353K 185 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 0.9 0.9 0.0 0.0 0.0 344.7 2.56 2.29 12 0.213 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 3.2 total, 3.0 interval Flush(GB): cumulative 0.861, interval 0.861 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 1.20 GB write, 381.26 MB/s write, 0.34 GB read, 108.00 MB/s read, 4.0 seconds Interval compaction: 1.20 GB write, 410.52 MB/s write, 0.34 GB read, 116.29 MB/s read, 4.0 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 3, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 3, interval: 3 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 126144 Average: 2.0535 StdDev: 15.28 Min: 1 Median: 1.3661 Max: 3509 Percentiles: P50: 1.37 P75: 1.78 P99: 5.35 P99.9: 10.60 P99.99: 30.31 ------------------------------------------------------ [ 0, 1 ] 35255 27.948% 27.948% ###### ( 1, 2 ] 75979 60.232% 88.180% ############ ( 2, 3 ] 8962 7.105% 95.285% # ( 3, 4 ] 3389 2.687% 97.971% # ( 4, 6 ] 1932 1.532% 99.503% ( 6, 10 ] 489 0.388% 99.891% ( 10, 15 ] 115 0.091% 99.982% ( 15, 22 ] 11 0.009% 99.990% ( 22, 34 ] 2 0.002% 99.992% ( 34, 51 ] 2 0.002% 99.994% ( 51, 76 ] 2 0.002% 99.995% ( 110, 170 ] 7 0.006% 100.001% ( 170, 250 ] 3 0.002% 100.003% ( 250, 380 ] 7 0.006% 100.009% ( 380, 580 ] 1 0.001% 100.010% ( 580, 870 ] 1 0.001% 100.010% ( 870, 1300 ] 1 0.001% 100.011% ( 1300, 1900 ] 2 0.002% 100.013% ( 2900, 4400 ] 2 0.002% 100.014% ** Level 1 read latency histogram (micros): Count: 12265 Average: 3.1632 StdDev: 30.92 Min: 1 Median: 1.3216 Max: 2283 Percentiles: P50: 1.32 P75: 1.77 P99: 9.37 P99.9: 306.39 P99.99: 1764.10 ------------------------------------------------------ [ 0, 1 ] 3955 32.246% 32.246% ###### ( 1, 2 ] 6771 55.206% 87.452% ########### ( 2, 3 ] 983 8.015% 95.467% ## ( 3, 4 ] 150 1.223% 96.690% ( 4, 6 ] 183 1.492% 98.182% ( 6, 10 ] 119 0.970% 99.152% ( 10, 15 ] 19 0.155% 99.307% ( 15, 22 ] 12 0.098% 99.405% ( 22, 34 ] 2 0.016% 99.421% ( 34, 51 ] 19 0.155% 99.576% ( 51, 76 ] 16 0.130% 99.706% ( 76, 110 ] 6 0.049% 99.755% ( 110, 170 ] 5 0.041% 99.796% ( 170, 250 ] 11 0.090% 99.886% ( 250, 380 ] 4 0.033% 99.918% ( 380, 580 ] 3 0.024% 99.943% ( 580, 870 ] 4 0.033% 99.976% ( 870, 1300 ] 1 0.008% 99.984% ( 1300, 1900 ] 1 0.008% 99.992% ( 1900, 2900 ] 1 0.008% 100.000% ** Level 2 read latency histogram (micros): Count: 74860 Average: 1.9706 StdDev: 3.81 Min: 1 Median: 1.3776 Max: 766 Percentiles: P50: 1.38 P75: 1.78 P99: 5.40 P99.9: 10.79 P99.99: 140.28 ------------------------------------------------------ [ 0, 1 ] 19725 26.349% 26.349% ##### ( 1, 2 ] 46884 62.629% 88.978% ############# ( 2, 3 ] 4903 6.550% 95.528% # ( 3, 4 ] 1778 2.375% 97.903% ( 4, 6 ] 1171 1.564% 99.467% ( 6, 10 ] 314 0.419% 99.886% ( 10, 15 ] 64 0.085% 99.972% ( 15, 22 ] 6 0.008% 99.980% ( 22, 34 ] 4 0.005% 99.985% ( 34, 51 ] 1 0.001% 99.987% ( 51, 76 ] 1 0.001% 99.988% ( 110, 170 ] 3 0.004% 99.992% ( 170, 250 ] 2 0.003% 99.995% ( 250, 380 ] 3 0.004% 99.999% ( 580, 870 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 45 Average: 1568.1111 StdDev: 1416.75 Min: 115 Median: 977.5000 Max: 5388 Percentiles: P50: 977.50 P75: 2427.78 P99: 5388.00 P99.9: 5388.00 P99.99: 5388.00 ------------------------------------------------------ ( 110, 170 ] 3 6.667% 6.667% # ( 170, 250 ] 2 4.444% 11.111% # ( 250, 380 ] 5 11.111% 22.222% ## ( 380, 580 ] 6 13.333% 35.556% ### ( 580, 870 ] 6 13.333% 48.889% ### ( 870, 1300 ] 2 4.444% 53.333% # ( 1300, 1900 ] 5 11.111% 64.444% ## ( 1900, 2900 ] 9 20.000% 84.444% #### ( 2900, 4400 ] 4 8.889% 93.333% ## ( 4400, 6600 ] 3 6.667% 100.000% # ** Level 4 read latency histogram (micros): Count: 30 Average: 1727.4000 StdDev: 1150.89 Min: 259 Median: 1700.0000 Max: 4742 Percentiles: P50: 1700.00 P75: 2550.00 P99: 4742.00 P99.9: 4742.00 P99.99: 4742.00 ------------------------------------------------------ ( 250, 380 ] 2 6.667% 6.667% # ( 380, 580 ] 5 16.667% 23.333% ### ( 580, 870 ] 4 13.333% 36.667% ### ( 870, 1300 ] 2 6.667% 43.333% # ( 1300, 1900 ] 3 10.000% 53.333% ## ( 1900, 2900 ] 10 33.333% 86.667% ####### ( 2900, 4400 ] 3 10.000% 96.667% ## ( 4400, 6600 ] 1 3.333% 100.000% # ** DB Stats ** Uptime(secs): 3.2 total, 3.0 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 305.00 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:0.398 H:M:S, 12.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 328.31 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.398 H:M:S, 13.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/12/13-19:06:49 ... thread 0: (1000000,2000000) ops and (351482.2,342450.2) ops/second in (2.845094,5.840265) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 10/4 1.29 GB 107.0 0.9 0.0 0.9 2.6 1.8 0.0 1.5 102.4 314.4 8.61 7.98 29 0.297 895K 986 0.0 0.0 L1 1/0 2.56 MB 0.3 0.3 0.3 0.0 0.3 0.3 0.2 1.0 240.3 239.9 1.31 1.27 1 1.311 319K 411 0.0 0.0 L2 1/0 49.74 MB 0.5 0.3 0.2 0.2 0.3 0.2 0.4 1.8 243.0 242.8 1.43 1.36 2 0.717 353K 185 0.0 0.0 L3 25/0 974.13 MB 1.0 0.7 0.5 0.2 0.7 0.5 0.0 1.4 196.1 195.9 3.50 3.07 3 1.167 697K 590 0.0 0.0 L4 148/0 9.50 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1048/0 86.12 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1233/4 97.92 GB 0.0 2.2 1.0 1.2 4.0 2.8 1.1 2.2 150.2 273.0 14.86 13.68 35 0.425 2266K 2172 0.0 0.0 Int 0/0 0.00 KB 0.0 2.2 1.0 1.2 4.0 2.8 1.1 2.2 150.2 273.0 14.86 13.68 35 0.425 2266K 2172 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 2.2 1.0 1.2 2.2 1.0 0.0 0.0 231.0 230.8 9.66 9.04 9 1.073 2266K 2172 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 351.5 5.20 4.64 26 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): 6.1 total, 5.8 interval Flush(GB): cumulative 1.784, interval 1.784 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 3.96 GB write, 668.11 MB/s write, 2.18 GB read, 367.60 MB/s read, 14.9 seconds Interval compaction: 3.96 GB write, 694.41 MB/s write, 2.18 GB read, 382.07 MB/s read, 14.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: 7, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 7, interval: 7 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 394123 Average: 2.1492 StdDev: 10.47 Min: 1 Median: 1.4584 Max: 3509 Percentiles: P50: 1.46 P75: 1.86 P99: 5.69 P99.9: 9.97 P99.99: 14.99 ------------------------------------------------------ [ 0, 1 ] 83295 21.134% 21.134% #### ( 1, 2 ] 248181 62.970% 84.105% ############# ( 2, 3 ] 37209 9.441% 93.546% ## ( 3, 4 ] 13816 3.506% 97.051% # ( 4, 6 ] 9108 2.311% 99.362% ( 6, 10 ] 2135 0.542% 99.904% ( 10, 15 ] 341 0.087% 99.990% ( 15, 22 ] 41 0.010% 100.001% ( 22, 34 ] 8 0.002% 100.003% ( 34, 51 ] 4 0.001% 100.004% ( 51, 76 ] 2 0.001% 100.004% ( 110, 170 ] 13 0.003% 100.008% ( 170, 250 ] 14 0.004% 100.011% ( 250, 380 ] 11 0.003% 100.014% ( 380, 580 ] 4 0.001% 100.015% ( 580, 870 ] 6 0.002% 100.016% ( 870, 1300 ] 5 0.001% 100.018% ( 1300, 1900 ] 2 0.001% 100.018% ( 1900, 2900 ] 1 0.000% 100.019% ( 2900, 4400 ] 2 0.001% 100.019% ** Level 1 read latency histogram (micros): Count: 91465 Average: 2.5654 StdDev: 11.91 Min: 1 Median: 1.6327 Max: 2283 Percentiles: P50: 1.63 P75: 2.11 P99: 6.53 P99.9: 17.63 P99.99: 268.49 ------------------------------------------------------ [ 0, 1 ] 9175 10.031% 10.031% ## ( 1, 2 ] 57784 63.176% 73.207% ############# ( 2, 3 ] 15131 16.543% 89.750% ### ( 3, 4 ] 4378 4.787% 94.537% # ( 4, 6 ] 3982 4.354% 98.890% # ( 6, 10 ] 751 0.821% 99.711% ( 10, 15 ] 162 0.177% 99.888% ( 15, 22 ] 28 0.031% 99.919% ( 22, 34 ] 3 0.003% 99.922% ( 34, 51 ] 20 0.022% 99.944% ( 51, 76 ] 17 0.019% 99.963% ( 76, 110 ] 6 0.007% 99.969% ( 110, 170 ] 5 0.005% 99.975% ( 170, 250 ] 13 0.014% 99.989% ( 250, 380 ] 6 0.007% 99.996% ( 380, 580 ] 3 0.003% 99.999% ( 580, 870 ] 6 0.007% 100.005% ( 870, 1300 ] 1 0.001% 100.007% ( 1300, 1900 ] 1 0.001% 100.008% ( 1900, 2900 ] 1 0.001% 100.009% ** Level 2 read latency histogram (micros): Count: 75817 Average: 1.9765 StdDev: 3.79 Min: 1 Median: 1.3817 Max: 766 Percentiles: P50: 1.38 P75: 1.78 P99: 5.42 P99.9: 10.72 P99.99: 138.37 ------------------------------------------------------ [ 0, 1 ] 19780 26.089% 26.089% ##### ( 1, 2 ] 47488 62.635% 88.724% ############# ( 2, 3 ] 5106 6.735% 95.459% # ( 3, 4 ] 1820 2.401% 97.859% ( 4, 6 ] 1218 1.606% 99.466% ( 6, 10 ] 320 0.422% 99.888% ( 10, 15 ] 64 0.084% 99.972% ( 15, 22 ] 6 0.008% 99.980% ( 22, 34 ] 4 0.005% 99.985% ( 34, 51 ] 1 0.001% 99.987% ( 51, 76 ] 1 0.001% 99.988% ( 110, 170 ] 3 0.004% 99.992% ( 170, 250 ] 2 0.003% 99.995% ( 250, 380 ] 3 0.004% 99.999% ( 580, 870 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 47892 Average: 4.0108 StdDev: 65.38 Min: 0 Median: 1.6576 Max: 5388 Percentiles: P50: 1.66 P75: 2.19 P99: 6.81 P99.9: 182.66 P99.99: 2701.20 ------------------------------------------------------ [ 0, 1 ] 3941 8.229% 8.229% ## ( 1, 2 ] 30420 63.518% 71.747% ############# ( 2, 3 ] 8179 17.078% 88.825% ### ( 3, 4 ] 2628 5.487% 94.312% # ( 4, 6 ] 2173 4.537% 98.849% # ( 6, 10 ] 358 0.748% 99.597% ( 10, 15 ] 86 0.180% 99.777% ( 15, 22 ] 21 0.044% 99.820% ( 22, 34 ] 29 0.061% 99.881% ( 34, 51 ] 2 0.004% 99.885% ( 110, 170 ] 6 0.013% 99.898% ( 170, 250 ] 7 0.015% 99.912% ( 250, 380 ] 8 0.017% 99.929% ( 380, 580 ] 7 0.015% 99.944% ( 580, 870 ] 7 0.015% 99.958% ( 870, 1300 ] 2 0.004% 99.962% ( 1300, 1900 ] 6 0.013% 99.975% ( 1900, 2900 ] 9 0.019% 99.994% ( 2900, 4400 ] 4 0.008% 100.002% ( 4400, 6600 ] 3 0.006% 100.008% ** Level 4 read latency histogram (micros): Count: 30 Average: 1727.4000 StdDev: 1150.89 Min: 259 Median: 1700.0000 Max: 4742 Percentiles: P50: 1700.00 P75: 2550.00 P99: 4742.00 P99.9: 4742.00 P99.99: 4742.00 ------------------------------------------------------ ( 250, 380 ] 2 6.667% 6.667% # ( 380, 580 ] 5 16.667% 23.333% ### ( 580, 870 ] 4 13.333% 36.667% ### ( 870, 1300 ] 2 6.667% 43.333% # ( 1300, 1900 ] 3 10.000% 53.333% ## ( 1900, 2900 ] 10 33.333% 86.667% ####### ( 2900, 4400 ] 3 10.000% 96.667% ## ( 4400, 6600 ] 1 3.333% 100.000% # ** Level 5 read latency histogram (micros): Count: 20 Average: 599.1000 StdDev: 602.75 Min: 78 Median: 250.0000 Max: 1928 Percentiles: P50: 250.00 P75: 870.00 P99: 1928.00 P99.9: 1928.00 P99.99: 1928.00 ------------------------------------------------------ ( 76, 110 ] 5 25.000% 25.000% ##### ( 110, 170 ] 2 10.000% 35.000% ## ( 170, 250 ] 3 15.000% 50.000% ### ( 380, 580 ] 3 15.000% 65.000% ### ( 580, 870 ] 2 10.000% 75.000% ## ( 870, 1300 ] 1 5.000% 80.000% # ( 1300, 1900 ] 3 15.000% 95.000% ### ( 1900, 2900 ] 1 5.000% 100.000% # ** DB Stats ** Uptime(secs): 6.1 total, 2.8 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 324.18 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.598 H:M:S, 9.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 345.93 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.200 H:M:S, 7.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/12/13-19:06:52 ... thread 0: (1000000,3000000) ops and (337037.7,340626.8) ops/second in (2.967027,8.807292) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 15/8 2.27 GB 176.2 1.7 0.0 1.7 4.4 2.8 0.0 1.6 117.8 314.1 14.43 13.45 46 0.314 1726K 1893 0.0 0.0 L1 1/0 2.56 MB 0.3 0.3 0.3 0.0 0.3 0.3 0.2 1.0 240.3 239.9 1.31 1.27 1 1.311 319K 411 0.0 0.0 L2 1/0 49.74 MB 0.5 0.3 0.2 0.2 0.3 0.2 0.4 1.8 243.0 242.8 1.43 1.36 2 0.717 353K 185 0.0 0.0 L3 25/0 974.13 MB 1.0 0.7 0.5 0.2 0.7 0.5 0.0 1.4 196.1 195.9 3.50 3.07 3 1.167 697K 590 0.0 0.0 L4 148/0 9.50 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1048/0 86.12 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1238/8 98.90 GB 0.0 3.0 1.0 2.0 5.7 3.7 1.1 2.1 147.5 284.5 20.68 19.15 52 0.398 3097K 3079 0.0 0.0 Int 0/0 0.00 KB 0.0 3.0 1.0 2.0 5.7 3.7 1.1 2.1 147.5 284.5 20.68 19.15 52 0.398 3097K 3079 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 3.0 1.0 2.0 3.0 1.0 0.0 0.0 239.9 239.6 12.72 12.05 12 1.060 3097K 3079 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 2.8 2.8 0.0 0.0 0.0 356.1 7.96 7.10 40 0.199 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 9.0 total, 8.8 interval Flush(GB): cumulative 2.768, interval 2.768 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 5.74 GB write, 650.81 MB/s write, 2.98 GB read, 337.54 MB/s read, 20.7 seconds Interval compaction: 5.74 GB write, 667.80 MB/s write, 2.98 GB read, 346.35 MB/s read, 20.7 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 10, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 10, interval: 10 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 637724 Average: 2.0611 StdDev: 11.71 Min: 0 Median: 1.3996 Max: 4190 Percentiles: P50: 1.40 P75: 1.80 P99: 5.50 P99.9: 9.92 P99.99: 15.62 ------------------------------------------------------ [ 0, 1 ] 161305 25.294% 25.294% ##### ( 1, 2 ] 394294 61.828% 87.122% ############ ( 2, 3 ] 49425 7.750% 94.872% ## ( 3, 4 ] 17856 2.800% 97.672% # ( 4, 6 ] 11254 1.765% 99.437% ( 6, 10 ] 3012 0.472% 99.909% ( 10, 15 ] 509 0.080% 99.989% ( 15, 22 ] 59 0.009% 99.998% ( 22, 34 ] 17 0.003% 100.001% ( 34, 51 ] 4 0.001% 100.002% ( 51, 76 ] 4 0.001% 100.002% ( 110, 170 ] 17 0.003% 100.005% ( 170, 250 ] 22 0.003% 100.008% ( 250, 380 ] 19 0.003% 100.011% ( 380, 580 ] 6 0.001% 100.012% ( 580, 870 ] 9 0.001% 100.014% ( 870, 1300 ] 10 0.002% 100.015% ( 1300, 1900 ] 4 0.001% 100.016% ( 1900, 2900 ] 1 0.000% 100.016% ( 2900, 4400 ] 4 0.001% 100.017% ** Level 1 read latency histogram (micros): Count: 91465 Average: 2.5654 StdDev: 11.91 Min: 1 Median: 1.6327 Max: 2283 Percentiles: P50: 1.63 P75: 2.11 P99: 6.53 P99.9: 17.63 P99.99: 268.49 ------------------------------------------------------ [ 0, 1 ] 9175 10.031% 10.031% ## ( 1, 2 ] 57784 63.176% 73.207% ############# ( 2, 3 ] 15131 16.543% 89.750% ### ( 3, 4 ] 4378 4.787% 94.537% # ( 4, 6 ] 3982 4.354% 98.890% # ( 6, 10 ] 751 0.821% 99.711% ( 10, 15 ] 162 0.177% 99.888% ( 15, 22 ] 28 0.031% 99.919% ( 22, 34 ] 3 0.003% 99.922% ( 34, 51 ] 20 0.022% 99.944% ( 51, 76 ] 17 0.019% 99.963% ( 76, 110 ] 6 0.007% 99.969% ( 110, 170 ] 5 0.005% 99.975% ( 170, 250 ] 13 0.014% 99.989% ( 250, 380 ] 6 0.007% 99.996% ( 380, 580 ] 3 0.003% 99.999% ( 580, 870 ] 6 0.007% 100.005% ( 870, 1300 ] 1 0.001% 100.007% ( 1300, 1900 ] 1 0.001% 100.008% ( 1900, 2900 ] 1 0.001% 100.009% ** Level 2 read latency histogram (micros): Count: 75817 Average: 1.9765 StdDev: 3.79 Min: 1 Median: 1.3817 Max: 766 Percentiles: P50: 1.38 P75: 1.78 P99: 5.42 P99.9: 10.72 P99.99: 138.37 ------------------------------------------------------ [ 0, 1 ] 19780 26.089% 26.089% ##### ( 1, 2 ] 47488 62.635% 88.724% ############# ( 2, 3 ] 5106 6.735% 95.459% # ( 3, 4 ] 1820 2.401% 97.859% ( 4, 6 ] 1218 1.606% 99.466% ( 6, 10 ] 320 0.422% 99.888% ( 10, 15 ] 64 0.084% 99.972% ( 15, 22 ] 6 0.008% 99.980% ( 22, 34 ] 4 0.005% 99.985% ( 34, 51 ] 1 0.001% 99.987% ( 51, 76 ] 1 0.001% 99.988% ( 110, 170 ] 3 0.004% 99.992% ( 170, 250 ] 2 0.003% 99.995% ( 250, 380 ] 3 0.004% 99.999% ( 580, 870 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 47892 Average: 4.0108 StdDev: 65.38 Min: 0 Median: 1.6576 Max: 5388 Percentiles: P50: 1.66 P75: 2.19 P99: 6.81 P99.9: 182.66 P99.99: 2701.20 ------------------------------------------------------ [ 0, 1 ] 3941 8.229% 8.229% ## ( 1, 2 ] 30420 63.518% 71.747% ############# ( 2, 3 ] 8179 17.078% 88.825% ### ( 3, 4 ] 2628 5.487% 94.312% # ( 4, 6 ] 2173 4.537% 98.849% # ( 6, 10 ] 358 0.748% 99.597% ( 10, 15 ] 86 0.180% 99.777% ( 15, 22 ] 21 0.044% 99.820% ( 22, 34 ] 29 0.061% 99.881% ( 34, 51 ] 2 0.004% 99.885% ( 110, 170 ] 6 0.013% 99.898% ( 170, 250 ] 7 0.015% 99.912% ( 250, 380 ] 8 0.017% 99.929% ( 380, 580 ] 7 0.015% 99.944% ( 580, 870 ] 7 0.015% 99.958% ( 870, 1300 ] 2 0.004% 99.962% ( 1300, 1900 ] 6 0.013% 99.975% ( 1900, 2900 ] 9 0.019% 99.994% ( 2900, 4400 ] 4 0.008% 100.002% ( 4400, 6600 ] 3 0.006% 100.008% ** Level 4 read latency histogram (micros): Count: 30 Average: 1727.4000 StdDev: 1150.89 Min: 259 Median: 1700.0000 Max: 4742 Percentiles: P50: 1700.00 P75: 2550.00 P99: 4742.00 P99.9: 4742.00 P99.99: 4742.00 ------------------------------------------------------ ( 250, 380 ] 2 6.667% 6.667% # ( 380, 580 ] 5 16.667% 23.333% ### ( 580, 870 ] 4 13.333% 36.667% ### ( 870, 1300 ] 2 6.667% 43.333% # ( 1300, 1900 ] 3 10.000% 53.333% ## ( 1900, 2900 ] 10 33.333% 86.667% ####### ( 2900, 4400 ] 3 10.000% 96.667% ## ( 4400, 6600 ] 1 3.333% 100.000% # ** Level 5 read latency histogram (micros): Count: 20 Average: 599.1000 StdDev: 602.75 Min: 78 Median: 250.0000 Max: 1928 Percentiles: P50: 250.00 P75: 870.00 P99: 1928.00 P99.9: 1928.00 P99.99: 1928.00 ------------------------------------------------------ ( 76, 110 ] 5 25.000% 25.000% ##### ( 110, 170 ] 2 10.000% 35.000% ## ( 170, 250 ] 3 15.000% 50.000% ### ( 380, 580 ] 3 15.000% 65.000% ### ( 580, 870 ] 2 10.000% 75.000% ## ( 870, 1300 ] 1 5.000% 80.000% # ( 1300, 1900 ] 3 15.000% 95.000% ### ( 1900, 2900 ] 1 5.000% 100.000% # ** DB Stats ** Uptime(secs): 9.0 total, 3.0 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 326.65 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:0.959 H:M:S, 10.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 331.71 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.361 H:M:S, 12.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/13-19:06:55 ... thread 0: (1000000,4000000) ops and (340414.5,340573.7) ops/second in (2.937595,11.744887) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 16/4 3.20 GB 295.8 2.8 0.0 2.8 6.5 3.7 0.0 1.7 133.4 311.1 21.25 19.93 63 0.337 2878K 3130 0.0 0.0 L1 1/0 2.56 MB 0.3 0.3 0.3 0.0 0.3 0.3 0.2 1.0 240.3 239.9 1.31 1.27 1 1.311 319K 411 0.0 0.0 L2 1/0 49.74 MB 0.5 0.3 0.2 0.2 0.3 0.2 0.4 1.8 243.0 242.8 1.43 1.36 2 0.717 353K 185 0.0 0.0 L3 25/0 974.13 MB 1.0 0.7 0.5 0.2 0.7 0.5 0.0 1.4 196.1 195.9 3.50 3.07 3 1.167 697K 590 0.0 0.0 L4 148/0 9.50 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1048/0 86.12 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1239/4 99.82 GB 0.0 4.1 1.0 3.1 7.8 4.7 1.1 2.1 152.2 289.5 27.50 25.63 69 0.399 4249K 4316 0.0 0.0 Int 0/0 0.00 KB 0.0 4.1 1.0 3.1 7.8 4.7 1.1 2.1 152.2 289.5 27.50 25.63 69 0.399 4249K 4316 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.1 1.0 3.1 4.1 1.0 0.0 0.0 246.5 246.2 16.98 16.24 16 1.061 4249K 4316 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 3.7 3.7 0.0 0.0 0.0 359.3 10.52 9.40 53 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): 12.0 total, 11.7 interval Flush(GB): cumulative 3.691, interval 3.691 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 7.77 GB write, 664.66 MB/s write, 4.09 GB read, 349.43 MB/s read, 27.5 seconds Interval compaction: 7.77 GB write, 677.67 MB/s write, 4.09 GB read, 356.27 MB/s read, 27.5 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 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: 883825 Average: 2.0225 StdDev: 11.59 Min: 0 Median: 1.3770 Max: 4190 Percentiles: P50: 1.38 P75: 1.78 P99: 5.33 P99.9: 9.86 P99.99: 17.07 ------------------------------------------------------ [ 0, 1 ] 236652 26.776% 26.776% ##### ( 1, 2 ] 544486 61.606% 88.382% ############ ( 2, 3 ] 62818 7.108% 95.489% # ( 3, 4 ] 22292 2.522% 98.011% # ( 4, 6 ] 13150 1.488% 99.499% ( 6, 10 ] 3671 0.415% 99.914% ( 10, 15 ] 644 0.073% 99.987% ( 15, 22 ] 80 0.009% 99.996% ( 22, 34 ] 20 0.002% 99.999% ( 34, 51 ] 7 0.001% 99.999% ( 51, 76 ] 6 0.001% 100.000% ( 110, 170 ] 23 0.003% 100.003% ( 170, 250 ] 27 0.003% 100.006% ( 250, 380 ] 26 0.003% 100.009% ( 380, 580 ] 9 0.001% 100.010% ( 580, 870 ] 14 0.002% 100.011% ( 870, 1300 ] 14 0.002% 100.013% ( 1300, 1900 ] 6 0.001% 100.014% ( 1900, 2900 ] 2 0.000% 100.014% ( 2900, 4400 ] 5 0.001% 100.014% ** Level 1 read latency histogram (micros): Count: 91465 Average: 2.5654 StdDev: 11.91 Min: 1 Median: 1.6327 Max: 2283 Percentiles: P50: 1.63 P75: 2.11 P99: 6.53 P99.9: 17.63 P99.99: 268.49 ------------------------------------------------------ [ 0, 1 ] 9175 10.031% 10.031% ## ( 1, 2 ] 57784 63.176% 73.207% ############# ( 2, 3 ] 15131 16.543% 89.750% ### ( 3, 4 ] 4378 4.787% 94.537% # ( 4, 6 ] 3982 4.354% 98.890% # ( 6, 10 ] 751 0.821% 99.711% ( 10, 15 ] 162 0.177% 99.888% ( 15, 22 ] 28 0.031% 99.919% ( 22, 34 ] 3 0.003% 99.922% ( 34, 51 ] 20 0.022% 99.944% ( 51, 76 ] 17 0.019% 99.963% ( 76, 110 ] 6 0.007% 99.969% ( 110, 170 ] 5 0.005% 99.975% ( 170, 250 ] 13 0.014% 99.989% ( 250, 380 ] 6 0.007% 99.996% ( 380, 580 ] 3 0.003% 99.999% ( 580, 870 ] 6 0.007% 100.005% ( 870, 1300 ] 1 0.001% 100.007% ( 1300, 1900 ] 1 0.001% 100.008% ( 1900, 2900 ] 1 0.001% 100.009% ** Level 2 read latency histogram (micros): Count: 75817 Average: 1.9765 StdDev: 3.79 Min: 1 Median: 1.3817 Max: 766 Percentiles: P50: 1.38 P75: 1.78 P99: 5.42 P99.9: 10.72 P99.99: 138.37 ------------------------------------------------------ [ 0, 1 ] 19780 26.089% 26.089% ##### ( 1, 2 ] 47488 62.635% 88.724% ############# ( 2, 3 ] 5106 6.735% 95.459% # ( 3, 4 ] 1820 2.401% 97.859% ( 4, 6 ] 1218 1.606% 99.466% ( 6, 10 ] 320 0.422% 99.888% ( 10, 15 ] 64 0.084% 99.972% ( 15, 22 ] 6 0.008% 99.980% ( 22, 34 ] 4 0.005% 99.985% ( 34, 51 ] 1 0.001% 99.987% ( 51, 76 ] 1 0.001% 99.988% ( 110, 170 ] 3 0.004% 99.992% ( 170, 250 ] 2 0.003% 99.995% ( 250, 380 ] 3 0.004% 99.999% ( 580, 870 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 47892 Average: 4.0108 StdDev: 65.38 Min: 0 Median: 1.6576 Max: 5388 Percentiles: P50: 1.66 P75: 2.19 P99: 6.81 P99.9: 182.66 P99.99: 2701.20 ------------------------------------------------------ [ 0, 1 ] 3941 8.229% 8.229% ## ( 1, 2 ] 30420 63.518% 71.747% ############# ( 2, 3 ] 8179 17.078% 88.825% ### ( 3, 4 ] 2628 5.487% 94.312% # ( 4, 6 ] 2173 4.537% 98.849% # ( 6, 10 ] 358 0.748% 99.597% ( 10, 15 ] 86 0.180% 99.777% ( 15, 22 ] 21 0.044% 99.820% ( 22, 34 ] 29 0.061% 99.881% ( 34, 51 ] 2 0.004% 99.885% ( 110, 170 ] 6 0.013% 99.898% ( 170, 250 ] 7 0.015% 99.912% ( 250, 380 ] 8 0.017% 99.929% ( 380, 580 ] 7 0.015% 99.944% ( 580, 870 ] 7 0.015% 99.958% ( 870, 1300 ] 2 0.004% 99.962% ( 1300, 1900 ] 6 0.013% 99.975% ( 1900, 2900 ] 9 0.019% 99.994% ( 2900, 4400 ] 4 0.008% 100.002% ( 4400, 6600 ] 3 0.006% 100.008% ** Level 4 read latency histogram (micros): Count: 30 Average: 1727.4000 StdDev: 1150.89 Min: 259 Median: 1700.0000 Max: 4742 Percentiles: P50: 1700.00 P75: 2550.00 P99: 4742.00 P99.9: 4742.00 P99.99: 4742.00 ------------------------------------------------------ ( 250, 380 ] 2 6.667% 6.667% # ( 380, 580 ] 5 16.667% 23.333% ### ( 580, 870 ] 4 13.333% 36.667% ### ( 870, 1300 ] 2 6.667% 43.333% # ( 1300, 1900 ] 3 10.000% 53.333% ## ( 1900, 2900 ] 10 33.333% 86.667% ####### ( 2900, 4400 ] 3 10.000% 96.667% ## ( 4400, 6600 ] 1 3.333% 100.000% # ** Level 5 read latency histogram (micros): Count: 20 Average: 599.1000 StdDev: 602.75 Min: 78 Median: 250.0000 Max: 1928 Percentiles: P50: 250.00 P75: 870.00 P99: 1928.00 P99.9: 1928.00 P99.99: 1928.00 ------------------------------------------------------ ( 76, 110 ] 5 25.000% 25.000% ##### ( 110, 170 ] 2 10.000% 35.000% ## ( 170, 250 ] 3 15.000% 50.000% ### ( 380, 580 ] 3 15.000% 65.000% ### ( 580, 870 ] 2 10.000% 75.000% ## ( 870, 1300 ] 1 5.000% 80.000% # ( 1300, 1900 ] 3 15.000% 95.000% ### ( 1900, 2900 ] 1 5.000% 100.000% # ** DB Stats ** Uptime(secs): 12.0 total, 2.9 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 328.71 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.316 H:M:S, 11.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 335.03 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.357 H:M:S, 12.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/12/13-19:06:58 ... thread 0: (1000000,5000000) ops and (301917.5,332070.4) ops/second in (3.312163,15.057050) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 19/17 4.18 GB 12.6 3.9 0.0 3.9 8.5 4.7 0.0 1.8 140.5 309.9 28.24 26.57 82 0.344 4029K 4409 0.0 0.0 L1 1/1 2.56 MB 0.0 0.3 0.3 0.0 0.3 0.3 0.2 1.0 240.3 239.9 1.31 1.27 1 1.311 319K 411 0.0 0.0 L2 1/0 49.74 MB 0.5 0.3 0.2 0.2 0.3 0.2 0.4 1.8 243.0 242.8 1.43 1.36 2 0.717 353K 185 0.0 0.0 L3 25/0 974.13 MB 1.0 0.7 0.5 0.2 0.7 0.5 0.0 1.4 196.1 195.9 3.50 3.07 3 1.167 697K 590 0.0 0.0 L4 148/0 9.50 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1048/0 86.12 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1242/18 100.81 GB 0.0 5.2 1.0 4.2 9.9 5.6 1.1 2.1 154.2 292.9 34.49 32.27 88 0.392 5400K 5595 0.0 0.0 Int 0/0 0.00 KB 0.0 5.2 1.0 4.2 9.9 5.6 1.1 2.1 154.2 292.9 34.49 32.27 88 0.392 5400K 5595 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.2 1.0 4.2 5.2 1.0 0.0 0.0 250.7 250.4 21.22 20.42 20 1.061 5400K 5595 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 360.8 13.27 11.85 68 0.195 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.3 total, 15.1 interval Flush(GB): cumulative 4.676, interval 4.676 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 9.86 GB write, 660.68 MB/s write, 5.19 GB read, 347.90 MB/s read, 34.5 seconds Interval compaction: 9.86 GB write, 670.77 MB/s write, 5.19 GB read, 353.21 MB/s read, 34.5 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 4, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 4, 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: 4, total-stops: 16, interval: 20 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1158139 Average: 2.0439 StdDev: 11.79 Min: 0 Median: 1.3691 Max: 4190 Percentiles: P50: 1.37 P75: 1.77 P99: 5.22 P99.9: 10.16 P99.99: 146.76 ------------------------------------------------------ [ 0, 1 ] 315223 27.218% 27.218% ##### ( 1, 2 ] 714749 61.715% 88.933% ############ ( 2, 3 ] 79215 6.840% 95.773% # ( 3, 4 ] 27928 2.411% 98.185% ( 4, 6 ] 15460 1.335% 99.520% ( 6, 10 ] 4382 0.378% 99.898% ( 10, 15 ] 775 0.067% 99.965% ( 15, 22 ] 96 0.008% 99.973% ( 22, 34 ] 22 0.002% 99.975% ( 34, 51 ] 10 0.001% 99.976% ( 51, 76 ] 8 0.001% 99.977% ( 76, 110 ] 60 0.005% 99.982% ( 110, 170 ] 157 0.014% 99.995% ( 170, 250 ] 69 0.006% 100.001% ( 250, 380 ] 43 0.004% 100.005% ( 380, 580 ] 31 0.003% 100.008% ( 580, 870 ] 25 0.002% 100.010% ( 870, 1300 ] 20 0.002% 100.012% ( 1300, 1900 ] 7 0.001% 100.012% ( 1900, 2900 ] 3 0.000% 100.012% ( 2900, 4400 ] 6 0.001% 100.013% ** Level 1 read latency histogram (micros): Count: 91466 Average: 2.5679 StdDev: 11.94 Min: 1 Median: 1.6327 Max: 2283 Percentiles: P50: 1.63 P75: 2.11 P99: 6.54 P99.9: 17.88 P99.99: 268.49 ------------------------------------------------------ [ 0, 1 ] 9175 10.031% 10.031% ## ( 1, 2 ] 57784 63.175% 73.206% ############# ( 2, 3 ] 15131 16.543% 89.749% ### ( 3, 4 ] 4378 4.786% 94.536% # ( 4, 6 ] 3982 4.354% 98.889% # ( 6, 10 ] 751 0.821% 99.710% ( 10, 15 ] 162 0.177% 99.887% ( 15, 22 ] 28 0.031% 99.918% ( 22, 34 ] 3 0.003% 99.921% ( 34, 51 ] 20 0.022% 99.943% ( 51, 76 ] 17 0.019% 99.962% ( 76, 110 ] 6 0.007% 99.968% ( 110, 170 ] 5 0.005% 99.974% ( 170, 250 ] 14 0.015% 99.989% ( 250, 380 ] 6 0.007% 99.996% ( 380, 580 ] 3 0.003% 99.999% ( 580, 870 ] 6 0.007% 100.005% ( 870, 1300 ] 1 0.001% 100.007% ( 1300, 1900 ] 1 0.001% 100.008% ( 1900, 2900 ] 1 0.001% 100.009% ** Level 2 read latency histogram (micros): Count: 75817 Average: 1.9765 StdDev: 3.79 Min: 1 Median: 1.3817 Max: 766 Percentiles: P50: 1.38 P75: 1.78 P99: 5.42 P99.9: 10.72 P99.99: 138.37 ------------------------------------------------------ [ 0, 1 ] 19780 26.089% 26.089% ##### ( 1, 2 ] 47488 62.635% 88.724% ############# ( 2, 3 ] 5106 6.735% 95.459% # ( 3, 4 ] 1820 2.401% 97.859% ( 4, 6 ] 1218 1.606% 99.466% ( 6, 10 ] 320 0.422% 99.888% ( 10, 15 ] 64 0.084% 99.972% ( 15, 22 ] 6 0.008% 99.980% ( 22, 34 ] 4 0.005% 99.985% ( 34, 51 ] 1 0.001% 99.987% ( 51, 76 ] 1 0.001% 99.988% ( 110, 170 ] 3 0.004% 99.992% ( 170, 250 ] 2 0.003% 99.995% ( 250, 380 ] 3 0.004% 99.999% ( 580, 870 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 47892 Average: 4.0108 StdDev: 65.38 Min: 0 Median: 1.6576 Max: 5388 Percentiles: P50: 1.66 P75: 2.19 P99: 6.81 P99.9: 182.66 P99.99: 2701.20 ------------------------------------------------------ [ 0, 1 ] 3941 8.229% 8.229% ## ( 1, 2 ] 30420 63.518% 71.747% ############# ( 2, 3 ] 8179 17.078% 88.825% ### ( 3, 4 ] 2628 5.487% 94.312% # ( 4, 6 ] 2173 4.537% 98.849% # ( 6, 10 ] 358 0.748% 99.597% ( 10, 15 ] 86 0.180% 99.777% ( 15, 22 ] 21 0.044% 99.820% ( 22, 34 ] 29 0.061% 99.881% ( 34, 51 ] 2 0.004% 99.885% ( 110, 170 ] 6 0.013% 99.898% ( 170, 250 ] 7 0.015% 99.912% ( 250, 380 ] 8 0.017% 99.929% ( 380, 580 ] 7 0.015% 99.944% ( 580, 870 ] 7 0.015% 99.958% ( 870, 1300 ] 2 0.004% 99.962% ( 1300, 1900 ] 6 0.013% 99.975% ( 1900, 2900 ] 9 0.019% 99.994% ( 2900, 4400 ] 4 0.008% 100.002% ( 4400, 6600 ] 3 0.006% 100.008% ** Level 4 read latency histogram (micros): Count: 30 Average: 1727.4000 StdDev: 1150.89 Min: 259 Median: 1700.0000 Max: 4742 Percentiles: P50: 1700.00 P75: 2550.00 P99: 4742.00 P99.9: 4742.00 P99.99: 4742.00 ------------------------------------------------------ ( 250, 380 ] 2 6.667% 6.667% # ( 380, 580 ] 5 16.667% 23.333% ### ( 580, 870 ] 4 13.333% 36.667% ### ( 870, 1300 ] 2 6.667% 43.333% # ( 1300, 1900 ] 3 10.000% 53.333% ## ( 1900, 2900 ] 10 33.333% 86.667% ####### ( 2900, 4400 ] 3 10.000% 96.667% ## ( 4400, 6600 ] 1 3.333% 100.000% # ** Level 5 read latency histogram (micros): Count: 20 Average: 599.1000 StdDev: 602.75 Min: 78 Median: 250.0000 Max: 1928 Percentiles: P50: 250.00 P75: 870.00 P99: 1928.00 P99.9: 1928.00 P99.99: 1928.00 ------------------------------------------------------ ( 76, 110 ] 5 25.000% 25.000% ##### ( 110, 170 ] 2 10.000% 35.000% ## ( 170, 250 ] 3 15.000% 50.000% ### ( 380, 580 ] 3 15.000% 65.000% ### ( 580, 870 ] 2 10.000% 75.000% ## ( 870, 1300 ] 1 5.000% 80.000% # ( 1300, 1900 ] 3 15.000% 95.000% ### ( 1900, 2900 ] 1 5.000% 100.000% # ** DB Stats ** Uptime(secs): 15.3 total, 3.3 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 321.87 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.003 H:M:S, 13.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 297.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.687 H:M:S, 20.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/12/13-19:07:20 ... thread 0: (1000000,6000000) ops and (45115.5,161193.2) ops/second in (22.165354,37.222404) 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/8 1.05 GB 6.3 4.4 0.0 4.4 10.0 5.6 0.0 1.8 128.8 293.6 34.74 30.89 97 0.358 4541K 4907 0.0 0.0 L1 5/5 467.80 MB 0.0 4.4 4.4 0.0 4.3 4.3 0.2 1.0 221.3 217.2 20.21 18.62 2 10.103 4539K 82K 0.0 0.0 L2 8/7 951.20 MB 1.3 0.3 0.2 0.2 0.3 0.2 3.9 1.8 243.0 242.8 1.43 1.36 2 0.717 353K 185 0.0 0.0 L3 26/12 1.94 GB 0.9 1.3 1.0 0.3 1.3 1.0 2.1 1.3 150.9 150.7 8.69 6.02 7 1.242 1299K 922 0.0 0.0 L4 154/6 9.86 GB 1.0 1.8 1.5 0.3 1.8 1.5 0.4 1.2 112.7 112.3 16.54 8.85 14 1.181 1868K 6494 0.0 0.0 L5 1064/0 87.42 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1266/38 101.64 GB 0.0 12.2 7.0 5.1 17.7 12.5 8.2 3.2 152.8 221.8 81.61 65.73 122 0.669 12M 94K 0.0 0.0 Int 0/0 0.00 KB 0.0 12.2 7.0 5.1 17.7 12.5 8.2 3.2 152.8 221.8 81.61 65.73 122 0.669 12M 94K 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 12.2 7.0 5.1 12.1 6.9 0.0 0.0 195.7 194.2 63.71 51.39 41 1.554 12M 94K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 5.6 5.6 0.0 0.0 0.0 320.1 17.91 14.34 81 0.221 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): 37.5 total, 37.2 interval Flush(GB): cumulative 5.598, interval 5.598 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 17.68 GB write, 483.35 MB/s write, 12.18 GB read, 332.88 MB/s read, 81.6 seconds Interval compaction: 17.68 GB write, 486.34 MB/s write, 12.18 GB read, 334.93 MB/s read, 81.6 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 12, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 12, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 31, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 12, total-stops: 31, interval: 43 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2459193 Average: 2.7808 StdDev: 33.15 Min: 0 Median: 1.3512 Max: 15131 Percentiles: P50: 1.35 P75: 1.77 P99: 5.96 P99.9: 153.91 P99.99: 585.69 ------------------------------------------------------ [ 0, 1 ] 714419 29.051% 29.051% ###### ( 1, 2 ] 1467076 59.657% 88.708% ############ ( 2, 3 ] 149164 6.066% 94.773% # ( 3, 4 ] 60612 2.465% 97.238% ( 4, 6 ] 44237 1.799% 99.037% ( 6, 10 ] 10975 0.446% 99.483% ( 10, 15 ] 1937 0.079% 99.562% ( 15, 22 ] 332 0.014% 99.575% ( 22, 34 ] 46 0.002% 99.577% ( 34, 51 ] 14 0.001% 99.578% ( 51, 76 ] 87 0.004% 99.581% ( 76, 110 ] 4927 0.200% 99.782% ( 110, 170 ] 3975 0.162% 99.943% ( 170, 250 ] 445 0.018% 99.961% ( 250, 380 ] 351 0.014% 99.976% ( 380, 580 ] 347 0.014% 99.990% ( 580, 870 ] 208 0.008% 99.998% ( 870, 1300 ] 93 0.004% 100.002% ( 1300, 1900 ] 50 0.002% 100.004% ( 1900, 2900 ] 58 0.002% 100.007% ( 2900, 4400 ] 52 0.002% 100.009% ( 4400, 6600 ] 13 0.001% 100.009% ( 6600, 9900 ] 2 0.000% 100.009% ( 9900, 14000 ] 1 0.000% 100.009% ( 14000, 22000 ] 2 0.000% 100.009% ** Level 1 read latency histogram (micros): Count: 660292 Average: 7.5074 StdDev: 113.64 Min: 1 Median: 1.9788 Max: 12995 Percentiles: P50: 1.98 P75: 2.97 P99: 9.33 P99.9: 70.58 P99.99: 455.06 ------------------------------------------------------ [ 0, 1 ] 15024 2.275% 2.275% ( 1, 2 ] 321961 48.760% 51.036% ########## ( 2, 3 ] 163861 24.816% 75.852% ##### ( 3, 4 ] 69897 10.586% 86.438% ## ( 4, 6 ] 70191 10.630% 97.068% ## ( 6, 10 ] 15340 2.323% 99.391% ( 10, 15 ] 2908 0.440% 99.832% ( 15, 22 ] 359 0.054% 99.886% ( 22, 34 ] 37 0.006% 99.892% ( 34, 51 ] 32 0.005% 99.897% ( 51, 76 ] 29 0.004% 99.901% ( 76, 110 ] 41 0.006% 99.907% ( 110, 170 ] 91 0.014% 99.921% ( 170, 250 ] 135 0.020% 99.942% ( 250, 380 ] 199 0.030% 99.972% ( 380, 580 ] 325 0.049% 100.021% ( 580, 870 ] 359 0.054% 100.075% ( 870, 1300 ] 267 0.040% 100.116% ( 1300, 1900 ] 155 0.023% 100.139% ( 1900, 2900 ] 223 0.034% 100.173% ( 2900, 4400 ] 273 0.041% 100.214% ( 4400, 6600 ] 69 0.010% 100.225% ( 6600, 9900 ] 14 0.002% 100.227% ( 9900, 14000 ] 1 0.000% 100.227% ** Level 2 read latency histogram (micros): Count: 76047 Average: 3.4930 StdDev: 66.97 Min: 1 Median: 1.3840 Max: 7091 Percentiles: P50: 1.38 P75: 1.78 P99: 5.57 P99.9: 231.80 P99.99: 3536.62 ------------------------------------------------------ [ 0, 1 ] 19780 26.010% 26.010% ##### ( 1, 2 ] 47505 62.468% 88.478% ############ ( 2, 3 ] 5183 6.816% 95.294% # ( 3, 4 ] 1841 2.421% 97.715% ( 4, 6 ] 1247 1.640% 99.354% ( 6, 10 ] 323 0.425% 99.779% ( 10, 15 ] 66 0.087% 99.866% ( 15, 22 ] 7 0.009% 99.875% ( 22, 34 ] 4 0.005% 99.880% ( 34, 51 ] 1 0.001% 99.882% ( 51, 76 ] 1 0.001% 99.883% ( 76, 110 ] 1 0.001% 99.884% ( 110, 170 ] 5 0.007% 99.891% ( 170, 250 ] 9 0.012% 99.903% ( 250, 380 ] 9 0.012% 99.915% ( 380, 580 ] 14 0.018% 99.933% ( 580, 870 ] 12 0.016% 99.949% ( 870, 1300 ] 10 0.013% 99.962% ( 1300, 1900 ] 7 0.009% 99.971% ( 1900, 2900 ] 11 0.014% 99.986% ( 2900, 4400 ] 8 0.011% 99.996% ( 4400, 6600 ] 2 0.003% 99.999% ( 6600, 9900 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 354234 Average: 12.7353 StdDev: 156.74 Min: 0 Median: 1.9339 Max: 16666 Percentiles: P50: 1.93 P75: 2.93 P99: 13.07 P99.9: 1238.08 P99.99: 1919.44 ------------------------------------------------------ [ 0, 1 ] 9130 2.577% 2.577% # ( 1, 2 ] 179876 50.779% 53.356% ########## ( 2, 3 ] 82596 23.317% 76.673% ##### ( 3, 4 ] 36346 10.260% 86.933% ## ( 4, 6 ] 34278 9.677% 96.610% ## ( 6, 10 ] 7702 2.174% 98.784% ( 10, 15 ] 1247 0.352% 99.136% ( 15, 22 ] 159 0.045% 99.181% ( 22, 34 ] 45 0.013% 99.194% ( 34, 51 ] 8 0.002% 99.196% ( 51, 76 ] 3 0.001% 99.197% ( 76, 110 ] 20 0.006% 99.203% ( 110, 170 ] 133 0.038% 99.240% ( 170, 250 ] 245 0.069% 99.309% ( 250, 380 ] 407 0.115% 99.424% ( 380, 580 ] 608 0.172% 99.596% ( 580, 870 ] 690 0.195% 99.791% ( 870, 1300 ] 453 0.128% 99.919% ( 1300, 1900 ] 250 0.071% 99.989% ( 1900, 2900 ] 184 0.052% 100.041% ( 2900, 4400 ] 224 0.063% 100.104% ( 4400, 6600 ] 42 0.012% 100.116% ( 6600, 9900 ] 13 0.004% 100.120% ( 9900, 14000 ] 4 0.001% 100.121% ( 14000, 22000 ] 3 0.001% 100.122% ** Level 4 read latency histogram (micros): Count: 33653 Average: 9.1172 StdDev: 139.63 Min: 1 Median: 1.9838 Max: 7899 Percentiles: P50: 1.98 P75: 2.97 P99: 9.48 P99.9: 2252.61 P99.99: 5366.06 ------------------------------------------------------ [ 0, 1 ] 320 0.951% 0.951% ( 1, 2 ] 16778 49.856% 50.807% ########## ( 2, 3 ] 8419 25.017% 75.824% ##### ( 3, 4 ] 3696 10.983% 86.807% ## ( 4, 6 ] 3627 10.778% 97.584% ## ( 6, 10 ] 548 1.628% 99.213% ( 10, 15 ] 105 0.312% 99.525% ( 15, 22 ] 19 0.056% 99.581% ( 22, 34 ] 3 0.009% 99.590% ( 51, 76 ] 1 0.003% 99.593% ( 76, 110 ] 2 0.006% 99.599% ( 110, 170 ] 7 0.021% 99.620% ( 170, 250 ] 26 0.077% 99.697% ( 250, 380 ] 8 0.024% 99.721% ( 380, 580 ] 12 0.036% 99.756% ( 580, 870 ] 17 0.051% 99.807% ( 870, 1300 ] 14 0.042% 99.848% ( 1300, 1900 ] 11 0.033% 99.881% ( 1900, 2900 ] 18 0.053% 99.935% ( 2900, 4400 ] 16 0.048% 99.982% ( 4400, 6600 ] 6 0.018% 100.000% ( 6600, 9900 ] 2 0.006% 100.006% ** Level 5 read latency histogram (micros): Count: 100 Average: 1722.7800 StdDev: 1811.34 Min: 78 Median: 931.4286 Max: 8725 Percentiles: P50: 931.43 P75: 2669.23 P99: 8250.00 P99.9: 8725.00 P99.99: 8725.00 ------------------------------------------------------ ( 76, 110 ] 5 5.000% 5.000% # ( 110, 170 ] 5 5.000% 10.000% # ( 170, 250 ] 7 7.000% 17.000% # ( 250, 380 ] 6 6.000% 23.000% # ( 380, 580 ] 18 18.000% 41.000% #### ( 580, 870 ] 8 8.000% 49.000% ## ( 870, 1300 ] 7 7.000% 56.000% # ( 1300, 1900 ] 9 9.000% 65.000% ## ( 1900, 2900 ] 13 13.000% 78.000% ### ( 2900, 4400 ] 10 10.000% 88.000% ## ( 4400, 6600 ] 10 10.000% 98.000% ## ( 6600, 9900 ] 2 2.000% 100.000% ** DB Stats ** Uptime(secs): 37.5 total, 22.2 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 157.66 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:20.647 H:M:S, 55.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 44.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:18.644 H:M:S, 84.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 6 num-running-flushes: 1 2024/12/13-19:07:24 ... thread 0: (1000000,7000000) ops and (272266.4,171168.9) ops/second in (3.672874,40.895278) 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.41 GB 119.6 5.4 0.0 5.4 11.9 6.6 0.0 1.8 130.0 289.7 42.16 37.43 113 0.373 5564K 6138 0.0 0.0 L1 6/0 616.21 MB 61.6 5.4 5.0 0.5 5.4 4.9 0.2 1.1 207.7 204.4 26.81 23.52 3 8.938 5178K 82K 0.0 0.0 L2 6/5 357.28 MB 0.6 0.3 0.2 0.2 0.3 0.2 4.3 1.8 243.0 242.8 1.43 1.36 2 0.717 353K 185 0.0 0.0 L3 15/5 1019.69 MB 0.4 2.9 1.8 1.1 2.9 1.8 2.4 1.6 153.9 153.5 19.47 13.43 9 2.163 2487K 2412 0.0 0.0 L4 156/0 9.50 GB 1.0 2.3 1.8 0.5 2.3 1.8 2.1 1.2 121.6 121.1 19.27 11.02 17 1.134 2355K 8268 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 1284/14 102.61 GB 0.0 16.3 8.8 7.6 22.8 15.3 12.9 3.5 153.3 214.1 109.15 86.77 144 0.758 15M 99K 0.0 0.0 Int 0/0 0.00 KB 0.0 16.3 8.8 7.6 22.8 15.3 12.9 3.5 153.3 214.1 109.15 86.77 144 0.758 15M 99K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 16.3 8.8 7.6 16.2 8.7 0.0 0.0 190.1 188.9 88.03 69.82 50 1.761 15M 99K 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 319.1 21.13 16.94 94 0.225 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): 41.1 total, 40.9 interval Flush(GB): cumulative 6.583, interval 6.583 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 22.82 GB write, 568.19 MB/s write, 16.34 GB read, 406.96 MB/s read, 109.2 seconds Interval compaction: 22.82 GB write, 571.38 MB/s write, 16.34 GB read, 409.24 MB/s read, 109.2 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 12, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 12, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 38, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 12, total-stops: 38, interval: 50 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2787910 Average: 2.7914 StdDev: 31.62 Min: 0 Median: 1.3970 Max: 15131 Percentiles: P50: 1.40 P75: 1.82 P99: 6.12 P99.9: 149.94 P99.99: 531.28 ------------------------------------------------------ [ 0, 1 ] 732422 26.271% 26.271% ##### ( 1, 2 ] 1666180 59.764% 86.036% ############ ( 2, 3 ] 210174 7.539% 93.575% ## ( 3, 4 ] 84884 3.045% 96.619% # ( 4, 6 ] 65905 2.364% 98.983% ( 6, 10 ] 14989 0.538% 99.521% ( 10, 15 ] 2433 0.087% 99.608% ( 15, 22 ] 381 0.014% 99.622% ( 22, 34 ] 49 0.002% 99.624% ( 34, 51 ] 16 0.001% 99.624% ( 51, 76 ] 88 0.003% 99.627% ( 76, 110 ] 4934 0.177% 99.804% ( 110, 170 ] 4008 0.144% 99.948% ( 170, 250 ] 484 0.017% 99.965% ( 250, 380 ] 394 0.014% 99.980% ( 380, 580 ] 385 0.014% 99.993% ( 580, 870 ] 234 0.008% 100.002% ( 870, 1300 ] 107 0.004% 100.006% ( 1300, 1900 ] 56 0.002% 100.008% ( 1900, 2900 ] 61 0.002% 100.010% ( 2900, 4400 ] 53 0.002% 100.012% ( 4400, 6600 ] 13 0.000% 100.012% ( 6600, 9900 ] 2 0.000% 100.012% ( 9900, 14000 ] 1 0.000% 100.012% ( 14000, 22000 ] 2 0.000% 100.012% ** Level 1 read latency histogram (micros): Count: 1025902 Average: 6.5573 StdDev: 95.92 Min: 1 Median: 1.9497 Max: 12995 Percentiles: P50: 1.95 P75: 2.91 P99: 9.35 P99.9: 192.61 P99.99: 497.86 ------------------------------------------------------ [ 0, 1 ] 21034 2.050% 2.050% ( 1, 2 ] 517974 50.490% 52.540% ########## ( 2, 3 ] 253106 24.672% 77.211% ##### ( 3, 4 ] 101366 9.881% 87.092% ## ( 4, 6 ] 101102 9.855% 96.947% ## ( 6, 10 ] 25151 2.452% 99.399% ( 10, 15 ] 4095 0.399% 99.798% ( 15, 22 ] 479 0.047% 99.845% ( 22, 34 ] 46 0.004% 99.849% ( 34, 51 ] 33 0.003% 99.852% ( 51, 76 ] 29 0.003% 99.855% ( 76, 110 ] 92 0.009% 99.864% ( 110, 170 ] 288 0.028% 99.892% ( 170, 250 ] 294 0.029% 99.921% ( 250, 380 ] 383 0.037% 99.958% ( 380, 580 ] 559 0.054% 100.013% ( 580, 870 ] 547 0.053% 100.066% ( 870, 1300 ] 381 0.037% 100.103% ( 1300, 1900 ] 203 0.020% 100.123% ( 1900, 2900 ] 266 0.026% 100.149% ( 2900, 4400 ] 288 0.028% 100.177% ( 4400, 6600 ] 72 0.007% 100.184% ( 6600, 9900 ] 14 0.001% 100.185% ( 9900, 14000 ] 1 0.000% 100.185% ** Level 2 read latency histogram (micros): Count: 88450 Average: 3.5965 StdDev: 64.07 Min: 1 Median: 1.4333 Max: 7091 Percentiles: P50: 1.43 P75: 1.83 P99: 5.94 P99.9: 351.08 P99.99: 3304.06 ------------------------------------------------------ [ 0, 1 ] 20332 22.987% 22.987% ##### ( 1, 2 ] 55138 62.338% 85.325% ############ ( 2, 3 ] 7448 8.421% 93.746% ## ( 3, 4 ] 2756 3.116% 96.862% # ( 4, 6 ] 1955 2.210% 99.072% ( 6, 10 ] 607 0.686% 99.758% ( 10, 15 ] 79 0.089% 99.847% ( 15, 22 ] 8 0.009% 99.856% ( 22, 34 ] 4 0.005% 99.861% ( 34, 51 ] 1 0.001% 99.862% ( 51, 76 ] 1 0.001% 99.863% ( 76, 110 ] 1 0.001% 99.864% ( 110, 170 ] 7 0.008% 99.872% ( 170, 250 ] 9 0.010% 99.882% ( 250, 380 ] 20 0.023% 99.905% ( 380, 580 ] 21 0.024% 99.929% ( 580, 870 ] 19 0.021% 99.950% ( 870, 1300 ] 12 0.014% 99.964% ( 1300, 1900 ] 8 0.009% 99.973% ( 1900, 2900 ] 13 0.015% 99.988% ( 2900, 4400 ] 8 0.009% 99.997% ( 4400, 6600 ] 2 0.002% 99.999% ( 6600, 9900 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 464704 Average: 11.1537 StdDev: 139.60 Min: 0 Median: 1.9250 Max: 16666 Percentiles: P50: 1.93 P75: 2.91 P99: 12.62 P99.9: 1171.69 P99.99: 1907.93 ------------------------------------------------------ [ 0, 1 ] 12022 2.587% 2.587% # ( 1, 2 ] 238185 51.255% 53.842% ########## ( 2, 3 ] 107560 23.146% 76.988% ##### ( 3, 4 ] 46964 10.106% 87.094% ## ( 4, 6 ] 43838 9.434% 96.528% ## ( 6, 10 ] 10634 2.288% 98.816% ( 10, 15 ] 1630 0.351% 99.167% ( 15, 22 ] 220 0.047% 99.214% ( 22, 34 ] 52 0.011% 99.226% ( 34, 51 ] 9 0.002% 99.227% ( 51, 76 ] 3 0.001% 99.228% ( 76, 110 ] 73 0.016% 99.244% ( 110, 170 ] 257 0.055% 99.299% ( 170, 250 ] 359 0.077% 99.376% ( 250, 380 ] 533 0.115% 99.491% ( 380, 580 ] 744 0.160% 99.651% ( 580, 870 ] 809 0.174% 99.825% ( 870, 1300 ] 495 0.107% 99.932% ( 1300, 1900 ] 269 0.058% 99.990% ( 1900, 2900 ] 193 0.042% 100.031% ( 2900, 4400 ] 231 0.050% 100.081% ( 4400, 6600 ] 43 0.009% 100.090% ( 6600, 9900 ] 13 0.003% 100.093% ( 9900, 14000 ] 4 0.001% 100.094% ( 14000, 22000 ] 3 0.001% 100.094% ** Level 4 read latency histogram (micros): Count: 46995 Average: 8.1906 StdDev: 122.37 Min: 1 Median: 1.9782 Max: 7899 Percentiles: P50: 1.98 P75: 2.94 P99: 9.70 P99.9: 1669.46 P99.99: 4876.85 ------------------------------------------------------ [ 0, 1 ] 414 0.881% 0.881% ( 1, 2 ] 23597 50.212% 51.093% ########## ( 2, 3 ] 11917 25.358% 76.451% ##### ( 3, 4 ] 4988 10.614% 87.065% ## ( 4, 6 ] 4822 10.261% 97.325% ## ( 6, 10 ] 852 1.813% 99.138% ( 10, 15 ] 151 0.321% 99.460% ( 15, 22 ] 26 0.055% 99.515% ( 22, 34 ] 3 0.006% 99.521% ( 51, 76 ] 1 0.002% 99.523% ( 76, 110 ] 5 0.011% 99.534% ( 110, 170 ] 23 0.049% 99.583% ( 170, 250 ] 47 0.100% 99.683% ( 250, 380 ] 22 0.047% 99.730% ( 380, 580 ] 28 0.060% 99.789% ( 580, 870 ] 27 0.057% 99.847% ( 870, 1300 ] 17 0.036% 99.883% ( 1300, 1900 ] 13 0.028% 99.911% ( 1900, 2900 ] 18 0.038% 99.949% ( 2900, 4400 ] 18 0.038% 99.987% ( 4400, 6600 ] 6 0.013% 100.000% ( 6600, 9900 ] 2 0.004% 100.004% ** Level 5 read latency histogram (micros): Count: 240 Average: 1291.9375 StdDev: 1453.42 Min: 78 Median: 661.2000 Max: 8725 Percentiles: P50: 661.20 P75: 2000.00 P99: 6512.00 P99.9: 8725.00 P99.99: 8725.00 ------------------------------------------------------ ( 76, 110 ] 17 7.083% 7.083% # ( 110, 170 ] 27 11.250% 18.333% ## ( 170, 250 ] 15 6.250% 24.583% # ( 250, 380 ] 22 9.167% 33.750% ## ( 380, 580 ] 32 13.333% 47.083% ### ( 580, 870 ] 25 10.417% 57.500% ## ( 870, 1300 ] 20 8.333% 65.833% ## ( 1300, 1900 ] 19 7.917% 73.750% ## ( 1900, 2900 ] 30 12.500% 86.250% ### ( 2900, 4400 ] 21 8.750% 95.000% ## ( 4400, 6600 ] 10 4.167% 99.167% # ( 6600, 9900 ] 2 0.833% 100.000% ** DB Stats ** Uptime(secs): 41.1 total, 3.7 interval Cumulative writes: 0 writes, 7000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 6.73 GB, 167.51 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:21.530 H:M:S, 52.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 267.96 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.883 H:M:S, 24.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 6 num-running-flushes: 1 2024/12/13-19:07:27 ... thread 0: (1000000,8000000) ops and (293380.9,180571.4) ops/second in (3.408538,44.303816) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 17/15 2.46 GB 44.1 5.9 0.0 5.9 13.5 7.6 0.0 1.8 126.6 290.0 47.76 42.39 129 0.370 6140K 6760 0.0 0.0 L1 6/6 616.21 MB 0.0 5.4 5.0 0.5 5.4 4.9 0.2 1.1 207.7 204.4 26.81 23.52 3 8.938 5178K 82K 0.0 0.0 L2 1/0 60.01 MB 0.6 0.3 0.2 0.2 0.3 0.2 4.3 1.8 243.0 242.8 1.43 1.36 2 0.717 353K 185 0.0 0.0 L3 19/0 920.41 MB 0.9 3.8 2.1 1.7 3.8 2.1 2.4 1.8 157.3 156.8 24.76 17.73 14 1.769 3399K 6264 0.0 0.0 L4 156/0 9.57 GB 1.0 2.8 2.2 0.6 2.8 2.2 2.1 1.3 130.0 129.5 21.90 13.36 22 0.996 2858K 10K 0.0 0.0 L5 1096/0 90.06 GB 0.9 0.0 0.0 0.0 0.0 0.0 4.2 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1295/21 103.65 GB 0.0 18.3 9.5 8.8 25.8 17.0 13.2 3.4 152.5 215.2 122.68 98.36 170 0.722 17M 105K 0.0 0.0 Int 0/0 0.00 KB 0.0 18.3 9.5 8.8 25.8 17.0 13.2 3.4 152.5 215.2 122.68 98.36 170 0.722 17M 105K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 18.3 9.5 8.8 18.2 9.3 0.0 0.0 190.4 189.3 98.22 78.65 62 1.584 17M 105K 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 319.4 24.46 19.71 108 0.226 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 44.5 total, 44.3 interval Flush(GB): cumulative 7.628, interval 7.628 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 25.78 GB write, 592.78 MB/s write, 18.27 GB read, 420.00 MB/s read, 122.7 seconds Interval compaction: 25.78 GB write, 595.86 MB/s write, 18.27 GB read, 422.18 MB/s read, 122.7 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 12, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 12, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 43, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 12, total-stops: 43, interval: 55 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3161360 Average: 2.7603 StdDev: 30.34 Min: 0 Median: 1.4230 Max: 15131 Percentiles: P50: 1.42 P75: 1.84 P99: 5.99 P99.9: 143.83 P99.99: 468.77 ------------------------------------------------------ [ 0, 1 ] 771951 24.418% 24.418% ##### ( 1, 2 ] 1912084 60.483% 84.901% ############ ( 2, 3 ] 265519 8.399% 93.300% ## ( 3, 4 ] 102253 3.234% 96.535% # ( 4, 6 ] 78208 2.474% 99.008% ( 6, 10 ] 17727 0.561% 99.569% ( 10, 15 ] 2700 0.085% 99.655% ( 15, 22 ] 405 0.013% 99.667% ( 22, 34 ] 50 0.002% 99.669% ( 34, 51 ] 16 0.001% 99.670% ( 51, 76 ] 90 0.003% 99.672% ( 76, 110 ] 4936 0.156% 99.829% ( 110, 170 ] 4017 0.127% 99.956% ( 170, 250 ] 502 0.016% 99.971% ( 250, 380 ] 408 0.013% 99.984% ( 380, 580 ] 412 0.013% 99.997% ( 580, 870 ] 257 0.008% 100.006% ( 870, 1300 ] 122 0.004% 100.009% ( 1300, 1900 ] 67 0.002% 100.012% ( 1900, 2900 ] 63 0.002% 100.014% ( 2900, 4400 ] 56 0.002% 100.015% ( 4400, 6600 ] 13 0.000% 100.016% ( 6600, 9900 ] 2 0.000% 100.016% ( 9900, 14000 ] 1 0.000% 100.016% ( 14000, 22000 ] 2 0.000% 100.016% ** Level 1 read latency histogram (micros): Count: 1132274 Average: 6.2623 StdDev: 91.64 Min: 1 Median: 1.9474 Max: 12995 Percentiles: P50: 1.95 P75: 2.90 P99: 9.29 P99.9: 136.34 P99.99: 437.56 ------------------------------------------------------ [ 0, 1 ] 22180 1.959% 1.959% ( 1, 2 ] 574131 50.706% 52.665% ########## ( 2, 3 ] 279841 24.715% 77.380% ##### ( 3, 4 ] 111674 9.863% 87.243% ## ( 4, 6 ] 110359 9.747% 96.989% ## ( 6, 10 ] 27715 2.448% 99.437% ( 10, 15 ] 4411 0.390% 99.827% ( 15, 22 ] 502 0.044% 99.871% ( 22, 34 ] 47 0.004% 99.875% ( 34, 51 ] 33 0.003% 99.878% ( 51, 76 ] 29 0.003% 99.881% ( 76, 110 ] 92 0.008% 99.889% ( 110, 170 ] 291 0.026% 99.914% ( 170, 250 ] 296 0.026% 99.941% ( 250, 380 ] 394 0.035% 99.975% ( 380, 580 ] 576 0.051% 100.026% ( 580, 870 ] 561 0.050% 100.076% ( 870, 1300 ] 394 0.035% 100.111% ( 1300, 1900 ] 209 0.018% 100.129% ( 1900, 2900 ] 270 0.024% 100.153% ( 2900, 4400 ] 289 0.026% 100.178% ( 4400, 6600 ] 72 0.006% 100.185% ( 6600, 9900 ] 14 0.001% 100.186% ( 9900, 14000 ] 1 0.000% 100.186% ** Level 2 read latency histogram (micros): Count: 88450 Average: 3.5965 StdDev: 64.07 Min: 1 Median: 1.4333 Max: 7091 Percentiles: P50: 1.43 P75: 1.83 P99: 5.94 P99.9: 351.08 P99.99: 3304.06 ------------------------------------------------------ [ 0, 1 ] 20332 22.987% 22.987% ##### ( 1, 2 ] 55138 62.338% 85.325% ############ ( 2, 3 ] 7448 8.421% 93.746% ## ( 3, 4 ] 2756 3.116% 96.862% # ( 4, 6 ] 1955 2.210% 99.072% ( 6, 10 ] 607 0.686% 99.758% ( 10, 15 ] 79 0.089% 99.847% ( 15, 22 ] 8 0.009% 99.856% ( 22, 34 ] 4 0.005% 99.861% ( 34, 51 ] 1 0.001% 99.862% ( 51, 76 ] 1 0.001% 99.863% ( 76, 110 ] 1 0.001% 99.864% ( 110, 170 ] 7 0.008% 99.872% ( 170, 250 ] 9 0.010% 99.882% ( 250, 380 ] 20 0.023% 99.905% ( 380, 580 ] 21 0.024% 99.929% ( 580, 870 ] 19 0.021% 99.950% ( 870, 1300 ] 12 0.014% 99.964% ( 1300, 1900 ] 8 0.009% 99.973% ( 1900, 2900 ] 13 0.015% 99.988% ( 2900, 4400 ] 8 0.009% 99.997% ( 4400, 6600 ] 2 0.002% 99.999% ( 6600, 9900 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 577050 Average: 9.7168 StdDev: 125.85 Min: 0 Median: 1.9270 Max: 16666 Percentiles: P50: 1.93 P75: 2.91 P99: 10.35 P99.9: 913.13 P99.99: 1438.43 ------------------------------------------------------ [ 0, 1 ] 14792 2.563% 2.563% # ( 1, 2 ] 295276 51.170% 53.733% ########## ( 2, 3 ] 135093 23.411% 77.144% ##### ( 3, 4 ] 58627 10.160% 87.304% ## ( 4, 6 ] 54666 9.473% 96.777% ## ( 6, 10 ] 12692 2.199% 98.977% ( 10, 15 ] 1918 0.332% 99.309% ( 15, 22 ] 242 0.042% 99.351% ( 22, 34 ] 57 0.010% 99.361% ( 34, 51 ] 9 0.002% 99.363% ( 51, 76 ] 4 0.001% 99.363% ( 76, 110 ] 97 0.017% 99.380% ( 110, 170 ] 326 0.056% 99.437% ( 170, 250 ] 408 0.071% 99.507% ( 250, 380 ] 593 0.103% 99.610% ( 380, 580 ] 793 0.137% 99.748% ( 580, 870 ] 829 0.144% 99.891% ( 870, 1300 ] 508 0.088% 99.979% ( 1300, 1900 ] 270 0.047% 100.026% ( 1900, 2900 ] 194 0.034% 100.060% ( 2900, 4400 ] 233 0.040% 100.100% ( 4400, 6600 ] 43 0.007% 100.107% ( 6600, 9900 ] 13 0.002% 100.110% ( 9900, 14000 ] 4 0.001% 100.110% ( 14000, 22000 ] 3 0.001% 100.111% ** Level 4 read latency histogram (micros): Count: 69149 Average: 7.6589 StdDev: 103.34 Min: 1 Median: 2.0239 Max: 7899 Percentiles: P50: 2.02 P75: 2.98 P99: 12.03 P99.9: 989.81 P99.99: 3990.42 ------------------------------------------------------ [ 0, 1 ] 582 0.842% 0.842% ( 1, 2 ] 33562 48.536% 49.377% ########## ( 2, 3 ] 18032 26.077% 75.454% ##### ( 3, 4 ] 7453 10.778% 86.233% ## ( 4, 6 ] 7278 10.525% 96.758% ## ( 6, 10 ] 1445 2.090% 98.847% ( 10, 15 ] 260 0.376% 99.223% ( 15, 22 ] 34 0.049% 99.273% ( 22, 34 ] 7 0.010% 99.283% ( 51, 76 ] 2 0.003% 99.286% ( 76, 110 ] 51 0.074% 99.359% ( 110, 170 ] 92 0.133% 99.492% ( 170, 250 ] 96 0.139% 99.631% ( 250, 380 ] 69 0.100% 99.731% ( 380, 580 ] 64 0.093% 99.824% ( 580, 870 ] 47 0.068% 99.892% ( 870, 1300 ] 21 0.030% 99.922% ( 1300, 1900 ] 16 0.023% 99.945% ( 1900, 2900 ] 18 0.026% 99.971% ( 2900, 4400 ] 18 0.026% 99.997% ( 4400, 6600 ] 6 0.009% 100.006% ( 6600, 9900 ] 2 0.003% 100.009% ** Level 5 read latency histogram (micros): Count: 260 Average: 1241.2346 StdDev: 1425.40 Min: 78 Median: 614.8000 Max: 8725 Percentiles: P50: 614.80 P75: 1900.00 P99: 6468.00 P99.9: 8725.00 P99.99: 8725.00 ------------------------------------------------------ ( 76, 110 ] 21 8.077% 8.077% ## ( 110, 170 ] 32 12.308% 20.385% ## ( 170, 250 ] 17 6.538% 26.923% # ( 250, 380 ] 25 9.615% 36.538% ## ( 380, 580 ] 32 12.308% 48.846% ## ( 580, 870 ] 25 9.615% 58.462% ## ( 870, 1300 ] 22 8.462% 66.923% ## ( 1300, 1900 ] 21 8.077% 75.000% ## ( 1900, 2900 ] 31 11.923% 86.923% ## ( 2900, 4400 ] 22 8.462% 95.385% ## ( 4400, 6600 ] 10 3.846% 99.231% # ( 6600, 9900 ] 2 0.769% 100.000% ** DB Stats ** Uptime(secs): 44.5 total, 3.4 interval Cumulative writes: 0 writes, 8000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 7.69 GB, 176.79 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:22.215 H:M:S, 49.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 288.64 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.685 H:M:S, 20.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/12/13-19:07:31 ... thread 0: (1000000,9000000) ops and (303363.8,189074.9) ops/second in (3.296372,47.600188) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 18/11 3.38 GB 163.6 7.0 0.0 7.0 15.6 8.5 0.0 1.8 131.1 290.8 54.78 49.02 146 0.375 7291K 7946 0.0 0.0 L1 6/6 616.21 MB 0.0 5.4 5.0 0.5 5.4 4.9 0.2 1.1 207.7 204.4 26.81 23.52 3 8.938 5178K 82K 0.0 0.0 L2 1/0 60.01 MB 0.6 0.3 0.2 0.2 0.3 0.2 4.3 1.8 243.0 242.8 1.43 1.36 2 0.717 353K 185 0.0 0.0 L3 19/0 920.41 MB 0.9 3.8 2.1 1.7 3.8 2.1 2.4 1.8 157.3 156.8 24.76 17.73 14 1.769 3399K 6264 0.0 0.0 L4 156/0 9.57 GB 1.0 2.8 2.2 0.6 2.8 2.2 2.1 1.3 130.0 129.5 21.90 13.36 22 0.996 2858K 10K 0.0 0.0 L5 1096/0 90.06 GB 0.9 0.0 0.0 0.0 0.0 0.0 4.2 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1296/17 104.57 GB 0.0 19.4 9.5 9.9 27.8 17.9 13.2 3.3 153.0 219.6 129.69 105.00 187 0.694 19M 106K 0.0 0.0 Int 0/0 0.00 KB 0.0 19.4 9.5 9.9 27.8 17.9 13.2 3.3 153.0 219.6 129.69 105.00 187 0.694 19M 106K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 19.4 9.5 9.9 19.3 9.3 0.0 0.0 193.5 192.3 102.54 82.87 66 1.554 19M 106K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 8.6 8.6 0.0 0.0 0.0 322.5 27.15 22.12 121 0.224 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): 47.8 total, 47.6 interval Flush(GB): cumulative 8.551, interval 8.551 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 27.81 GB write, 595.37 MB/s write, 19.37 GB read, 414.76 MB/s read, 129.7 seconds Interval compaction: 27.81 GB write, 598.25 MB/s write, 19.37 GB read, 416.77 MB/s read, 129.7 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: 46, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 14, total-stops: 46, interval: 60 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3540462 Average: 2.7111 StdDev: 28.97 Min: 0 Median: 1.4337 Max: 15131 Percentiles: P50: 1.43 P75: 1.84 P99: 5.97 P99.9: 139.07 P99.99: 428.02 ------------------------------------------------------ [ 0, 1 ] 829540 23.430% 23.430% ##### ( 1, 2 ] 2168771 61.257% 84.687% ############ ( 2, 3 ] 308559 8.715% 93.402% ## ( 3, 4 ] 114089 3.222% 96.625% # ( 4, 6 ] 85207 2.407% 99.031% ( 6, 10 ] 20331 0.574% 99.606% ( 10, 15 ] 2881 0.081% 99.687% ( 15, 22 ] 418 0.012% 99.699% ( 22, 34 ] 54 0.002% 99.700% ( 34, 51 ] 21 0.001% 99.701% ( 51, 76 ] 93 0.003% 99.703% ( 76, 110 ] 4969 0.140% 99.844% ( 110, 170 ] 4106 0.116% 99.960% ( 170, 250 ] 528 0.015% 99.975% ( 250, 380 ] 438 0.012% 99.987% ( 380, 580 ] 433 0.012% 99.999% ( 580, 870 ] 268 0.008% 100.007% ( 870, 1300 ] 126 0.004% 100.010% ( 1300, 1900 ] 69 0.002% 100.012% ( 1900, 2900 ] 64 0.002% 100.014% ( 2900, 4400 ] 59 0.002% 100.016% ( 4400, 6600 ] 13 0.000% 100.016% ( 6600, 9900 ] 2 0.000% 100.016% ( 9900, 14000 ] 1 0.000% 100.016% ( 14000, 22000 ] 2 0.000% 100.016% ** Level 1 read latency histogram (micros): Count: 1159073 Average: 6.1919 StdDev: 90.62 Min: 1 Median: 1.9357 Max: 12995 Percentiles: P50: 1.94 P75: 2.89 P99: 9.28 P99.9: 145.24 P99.99: 440.54 ------------------------------------------------------ [ 0, 1 ] 24956 2.153% 2.153% ( 1, 2 ] 592682 51.134% 53.287% ########## ( 2, 3 ] 283323 24.444% 77.731% ##### ( 3, 4 ] 112554 9.711% 87.442% ## ( 4, 6 ] 110951 9.572% 97.014% ## ( 6, 10 ] 28095 2.424% 99.438% ( 10, 15 ] 4418 0.381% 99.819% ( 15, 22 ] 503 0.043% 99.863% ( 22, 34 ] 47 0.004% 99.867% ( 34, 51 ] 33 0.003% 99.870% ( 51, 76 ] 32 0.003% 99.872% ( 76, 110 ] 122 0.011% 99.883% ( 110, 170 ] 337 0.029% 99.912% ( 170, 250 ] 319 0.028% 99.940% ( 250, 380 ] 408 0.035% 99.975% ( 380, 580 ] 585 0.050% 100.025% ( 580, 870 ] 566 0.049% 100.074% ( 870, 1300 ] 394 0.034% 100.108% ( 1300, 1900 ] 209 0.018% 100.126% ( 1900, 2900 ] 270 0.023% 100.149% ( 2900, 4400 ] 289 0.025% 100.174% ( 4400, 6600 ] 72 0.006% 100.180% ( 6600, 9900 ] 14 0.001% 100.182% ( 9900, 14000 ] 1 0.000% 100.182% ** Level 2 read latency histogram (micros): Count: 88450 Average: 3.5965 StdDev: 64.07 Min: 1 Median: 1.4333 Max: 7091 Percentiles: P50: 1.43 P75: 1.83 P99: 5.94 P99.9: 351.08 P99.99: 3304.06 ------------------------------------------------------ [ 0, 1 ] 20332 22.987% 22.987% ##### ( 1, 2 ] 55138 62.338% 85.325% ############ ( 2, 3 ] 7448 8.421% 93.746% ## ( 3, 4 ] 2756 3.116% 96.862% # ( 4, 6 ] 1955 2.210% 99.072% ( 6, 10 ] 607 0.686% 99.758% ( 10, 15 ] 79 0.089% 99.847% ( 15, 22 ] 8 0.009% 99.856% ( 22, 34 ] 4 0.005% 99.861% ( 34, 51 ] 1 0.001% 99.862% ( 51, 76 ] 1 0.001% 99.863% ( 76, 110 ] 1 0.001% 99.864% ( 110, 170 ] 7 0.008% 99.872% ( 170, 250 ] 9 0.010% 99.882% ( 250, 380 ] 20 0.023% 99.905% ( 380, 580 ] 21 0.024% 99.929% ( 580, 870 ] 19 0.021% 99.950% ( 870, 1300 ] 12 0.014% 99.964% ( 1300, 1900 ] 8 0.009% 99.973% ( 1900, 2900 ] 13 0.015% 99.988% ( 2900, 4400 ] 8 0.009% 99.997% ( 4400, 6600 ] 2 0.002% 99.999% ( 6600, 9900 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 577050 Average: 9.7168 StdDev: 125.85 Min: 0 Median: 1.9270 Max: 16666 Percentiles: P50: 1.93 P75: 2.91 P99: 10.35 P99.9: 913.13 P99.99: 1438.43 ------------------------------------------------------ [ 0, 1 ] 14792 2.563% 2.563% # ( 1, 2 ] 295276 51.170% 53.733% ########## ( 2, 3 ] 135093 23.411% 77.144% ##### ( 3, 4 ] 58627 10.160% 87.304% ## ( 4, 6 ] 54666 9.473% 96.777% ## ( 6, 10 ] 12692 2.199% 98.977% ( 10, 15 ] 1918 0.332% 99.309% ( 15, 22 ] 242 0.042% 99.351% ( 22, 34 ] 57 0.010% 99.361% ( 34, 51 ] 9 0.002% 99.363% ( 51, 76 ] 4 0.001% 99.363% ( 76, 110 ] 97 0.017% 99.380% ( 110, 170 ] 326 0.056% 99.437% ( 170, 250 ] 408 0.071% 99.507% ( 250, 380 ] 593 0.103% 99.610% ( 380, 580 ] 793 0.137% 99.748% ( 580, 870 ] 829 0.144% 99.891% ( 870, 1300 ] 508 0.088% 99.979% ( 1300, 1900 ] 270 0.047% 100.026% ( 1900, 2900 ] 194 0.034% 100.060% ( 2900, 4400 ] 233 0.040% 100.100% ( 4400, 6600 ] 43 0.007% 100.107% ( 6600, 9900 ] 13 0.002% 100.110% ( 9900, 14000 ] 4 0.001% 100.110% ( 14000, 22000 ] 3 0.001% 100.111% ** Level 4 read latency histogram (micros): Count: 69149 Average: 7.6589 StdDev: 103.34 Min: 1 Median: 2.0239 Max: 7899 Percentiles: P50: 2.02 P75: 2.98 P99: 12.03 P99.9: 989.81 P99.99: 3990.42 ------------------------------------------------------ [ 0, 1 ] 582 0.842% 0.842% ( 1, 2 ] 33562 48.536% 49.377% ########## ( 2, 3 ] 18032 26.077% 75.454% ##### ( 3, 4 ] 7453 10.778% 86.233% ## ( 4, 6 ] 7278 10.525% 96.758% ## ( 6, 10 ] 1445 2.090% 98.847% ( 10, 15 ] 260 0.376% 99.223% ( 15, 22 ] 34 0.049% 99.273% ( 22, 34 ] 7 0.010% 99.283% ( 51, 76 ] 2 0.003% 99.286% ( 76, 110 ] 51 0.074% 99.359% ( 110, 170 ] 92 0.133% 99.492% ( 170, 250 ] 96 0.139% 99.631% ( 250, 380 ] 69 0.100% 99.731% ( 380, 580 ] 64 0.093% 99.824% ( 580, 870 ] 47 0.068% 99.892% ( 870, 1300 ] 21 0.030% 99.922% ( 1300, 1900 ] 16 0.023% 99.945% ( 1900, 2900 ] 18 0.026% 99.971% ( 2900, 4400 ] 18 0.026% 99.997% ( 4400, 6600 ] 6 0.009% 100.006% ( 6600, 9900 ] 2 0.003% 100.009% ** Level 5 read latency histogram (micros): Count: 260 Average: 1241.2346 StdDev: 1425.40 Min: 78 Median: 614.8000 Max: 8725 Percentiles: P50: 614.80 P75: 1900.00 P99: 6468.00 P99.9: 8725.00 P99.99: 8725.00 ------------------------------------------------------ ( 76, 110 ] 21 8.077% 8.077% ## ( 110, 170 ] 32 12.308% 20.385% ## ( 170, 250 ] 17 6.538% 26.923% # ( 250, 380 ] 25 9.615% 36.538% ## ( 380, 580 ] 32 12.308% 48.846% ## ( 580, 870 ] 25 9.615% 58.462% ## ( 870, 1300 ] 22 8.462% 66.923% ## ( 1300, 1900 ] 21 8.077% 75.000% ## ( 1900, 2900 ] 31 11.923% 86.923% ## ( 2900, 4400 ] 22 8.462% 95.385% ## ( 4400, 6600 ] 10 3.846% 99.231% # ( 6600, 9900 ] 2 0.769% 100.000% ** DB Stats ** Uptime(secs): 47.8 total, 3.3 interval Cumulative writes: 0 writes, 9000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 8.65 GB, 185.18 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:22.883 H:M:S, 47.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 298.68 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.667 H:M:S, 20.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/13-19:07:35 ... thread 0: (1000000,10000000) ops and (239816.0,193161.9) ops/second in (4.169864,51.770052) 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/16 2.83 GB 0.0 7.8 0.0 7.8 17.3 9.5 0.0 1.8 131.9 291.7 60.65 54.52 163 0.372 8123K 8793 0.0 0.0 L1 18/18 2.06 GB 0.0 7.5 6.5 1.1 7.4 6.3 0.2 1.1 212.0 209.1 36.29 32.60 4 9.072 7338K 101K 0.0 0.0 L2 1/0 60.01 MB 0.6 0.3 0.2 0.2 0.3 0.2 4.3 1.8 243.0 242.8 1.43 1.36 2 0.717 353K 185 0.0 0.0 L3 19/0 920.41 MB 0.9 3.8 2.1 1.7 3.8 2.1 2.4 1.8 157.3 156.8 24.76 17.73 14 1.769 3399K 6264 0.0 0.0 L4 156/0 9.57 GB 1.0 2.8 2.2 0.6 2.8 2.2 2.1 1.3 130.0 129.5 21.90 13.36 22 0.996 2858K 10K 0.0 0.0 L5 1096/0 90.06 GB 0.9 0.0 0.0 0.0 0.0 0.0 4.2 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1306/34 105.48 GB 0.0 22.3 10.9 11.3 31.6 20.3 13.2 3.3 157.1 223.0 145.04 119.57 205 0.708 22M 126K 0.0 0.0 Int 0/0 0.00 KB 0.0 22.3 10.9 11.3 31.6 20.3 13.2 3.3 157.1 223.0 145.04 119.57 205 0.708 22M 126K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 22.3 10.9 11.3 22.1 10.8 0.0 0.0 198.0 196.8 115.06 94.95 70 1.644 22M 126K 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 323.6 29.98 24.62 135 0.222 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 52.0 total, 51.8 interval Flush(GB): cumulative 9.474, interval 9.474 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 31.59 GB write, 622.06 MB/s write, 22.25 GB read, 438.15 MB/s read, 145.0 seconds Interval compaction: 31.59 GB write, 624.83 MB/s write, 22.25 GB read, 440.09 MB/s read, 145.0 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: 47, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 20, total-stops: 47, interval: 67 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3800521 Average: 2.6882 StdDev: 28.15 Min: 0 Median: 1.4367 Max: 15131 Percentiles: P50: 1.44 P75: 1.84 P99: 5.95 P99.9: 137.75 P99.99: 420.76 ------------------------------------------------------ [ 0, 1 ] 876707 23.068% 23.068% ##### ( 1, 2 ] 2343742 61.669% 84.737% ############ ( 2, 3 ] 333067 8.764% 93.501% ## ( 3, 4 ] 121952 3.209% 96.710% # ( 4, 6 ] 89160 2.346% 99.056% ( 6, 10 ] 21404 0.563% 99.619% ( 10, 15 ] 2995 0.079% 99.698% ( 15, 22 ] 431 0.011% 99.709% ( 22, 34 ] 60 0.002% 99.710% ( 34, 51 ] 22 0.001% 99.711% ( 51, 76 ] 96 0.003% 99.714% ( 76, 110 ] 5124 0.135% 99.848% ( 110, 170 ] 4241 0.112% 99.960% ( 170, 250 ] 576 0.015% 99.975% ( 250, 380 ] 471 0.012% 99.988% ( 380, 580 ] 461 0.012% 100.000% ( 580, 870 ] 285 0.007% 100.007% ( 870, 1300 ] 128 0.003% 100.011% ( 1300, 1900 ] 71 0.002% 100.012% ( 1900, 2900 ] 64 0.002% 100.014% ( 2900, 4400 ] 60 0.002% 100.016% ( 4400, 6600 ] 13 0.000% 100.016% ( 6600, 9900 ] 2 0.000% 100.016% ( 9900, 14000 ] 1 0.000% 100.016% ( 14000, 22000 ] 2 0.000% 100.016% ** Level 1 read latency histogram (micros): Count: 1310833 Average: 5.7885 StdDev: 85.43 Min: 1 Median: 1.8706 Max: 12995 Percentiles: P50: 1.87 P75: 2.80 P99: 9.18 P99.9: 149.45 P99.99: 454.41 ------------------------------------------------------ [ 0, 1 ] 51964 3.964% 3.964% # ( 1, 2 ] 693109 52.875% 56.840% ########### ( 2, 3 ] 298359 22.761% 79.601% ##### ( 3, 4 ] 116550 8.891% 88.492% ## ( 4, 6 ] 113954 8.693% 97.185% ## ( 6, 10 ] 29940 2.284% 99.469% ( 10, 15 ] 4486 0.342% 99.811% ( 15, 22 ] 513 0.039% 99.851% ( 22, 34 ] 48 0.004% 99.854% ( 34, 51 ] 34 0.003% 99.857% ( 51, 76 ] 54 0.004% 99.861% ( 76, 110 ] 238 0.018% 99.879% ( 110, 170 ] 417 0.032% 99.911% ( 170, 250 ] 361 0.028% 99.939% ( 250, 380 ] 446 0.034% 99.973% ( 380, 580 ] 618 0.047% 100.020% ( 580, 870 ] 585 0.045% 100.064% ( 870, 1300 ] 406 0.031% 100.095% ( 1300, 1900 ] 213 0.016% 100.112% ( 1900, 2900 ] 270 0.021% 100.132% ( 2900, 4400 ] 289 0.022% 100.154% ( 4400, 6600 ] 72 0.005% 100.160% ( 6600, 9900 ] 14 0.001% 100.161% ( 9900, 14000 ] 1 0.000% 100.161% ** Level 2 read latency histogram (micros): Count: 88450 Average: 3.5965 StdDev: 64.07 Min: 1 Median: 1.4333 Max: 7091 Percentiles: P50: 1.43 P75: 1.83 P99: 5.94 P99.9: 351.08 P99.99: 3304.06 ------------------------------------------------------ [ 0, 1 ] 20332 22.987% 22.987% ##### ( 1, 2 ] 55138 62.338% 85.325% ############ ( 2, 3 ] 7448 8.421% 93.746% ## ( 3, 4 ] 2756 3.116% 96.862% # ( 4, 6 ] 1955 2.210% 99.072% ( 6, 10 ] 607 0.686% 99.758% ( 10, 15 ] 79 0.089% 99.847% ( 15, 22 ] 8 0.009% 99.856% ( 22, 34 ] 4 0.005% 99.861% ( 34, 51 ] 1 0.001% 99.862% ( 51, 76 ] 1 0.001% 99.863% ( 76, 110 ] 1 0.001% 99.864% ( 110, 170 ] 7 0.008% 99.872% ( 170, 250 ] 9 0.010% 99.882% ( 250, 380 ] 20 0.023% 99.905% ( 380, 580 ] 21 0.024% 99.929% ( 580, 870 ] 19 0.021% 99.950% ( 870, 1300 ] 12 0.014% 99.964% ( 1300, 1900 ] 8 0.009% 99.973% ( 1900, 2900 ] 13 0.015% 99.988% ( 2900, 4400 ] 8 0.009% 99.997% ( 4400, 6600 ] 2 0.002% 99.999% ( 6600, 9900 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 577050 Average: 9.7168 StdDev: 125.85 Min: 0 Median: 1.9270 Max: 16666 Percentiles: P50: 1.93 P75: 2.91 P99: 10.35 P99.9: 913.13 P99.99: 1438.43 ------------------------------------------------------ [ 0, 1 ] 14792 2.563% 2.563% # ( 1, 2 ] 295276 51.170% 53.733% ########## ( 2, 3 ] 135093 23.411% 77.144% ##### ( 3, 4 ] 58627 10.160% 87.304% ## ( 4, 6 ] 54666 9.473% 96.777% ## ( 6, 10 ] 12692 2.199% 98.977% ( 10, 15 ] 1918 0.332% 99.309% ( 15, 22 ] 242 0.042% 99.351% ( 22, 34 ] 57 0.010% 99.361% ( 34, 51 ] 9 0.002% 99.363% ( 51, 76 ] 4 0.001% 99.363% ( 76, 110 ] 97 0.017% 99.380% ( 110, 170 ] 326 0.056% 99.437% ( 170, 250 ] 408 0.071% 99.507% ( 250, 380 ] 593 0.103% 99.610% ( 380, 580 ] 793 0.137% 99.748% ( 580, 870 ] 829 0.144% 99.891% ( 870, 1300 ] 508 0.088% 99.979% ( 1300, 1900 ] 270 0.047% 100.026% ( 1900, 2900 ] 194 0.034% 100.060% ( 2900, 4400 ] 233 0.040% 100.100% ( 4400, 6600 ] 43 0.007% 100.107% ( 6600, 9900 ] 13 0.002% 100.110% ( 9900, 14000 ] 4 0.001% 100.110% ( 14000, 22000 ] 3 0.001% 100.111% ** Level 4 read latency histogram (micros): Count: 69149 Average: 7.6589 StdDev: 103.34 Min: 1 Median: 2.0239 Max: 7899 Percentiles: P50: 2.02 P75: 2.98 P99: 12.03 P99.9: 989.81 P99.99: 3990.42 ------------------------------------------------------ [ 0, 1 ] 582 0.842% 0.842% ( 1, 2 ] 33562 48.536% 49.377% ########## ( 2, 3 ] 18032 26.077% 75.454% ##### ( 3, 4 ] 7453 10.778% 86.233% ## ( 4, 6 ] 7278 10.525% 96.758% ## ( 6, 10 ] 1445 2.090% 98.847% ( 10, 15 ] 260 0.376% 99.223% ( 15, 22 ] 34 0.049% 99.273% ( 22, 34 ] 7 0.010% 99.283% ( 51, 76 ] 2 0.003% 99.286% ( 76, 110 ] 51 0.074% 99.359% ( 110, 170 ] 92 0.133% 99.492% ( 170, 250 ] 96 0.139% 99.631% ( 250, 380 ] 69 0.100% 99.731% ( 380, 580 ] 64 0.093% 99.824% ( 580, 870 ] 47 0.068% 99.892% ( 870, 1300 ] 21 0.030% 99.922% ( 1300, 1900 ] 16 0.023% 99.945% ( 1900, 2900 ] 18 0.026% 99.971% ( 2900, 4400 ] 18 0.026% 99.997% ( 4400, 6600 ] 6 0.009% 100.006% ( 6600, 9900 ] 2 0.003% 100.009% ** Level 5 read latency histogram (micros): Count: 260 Average: 1241.2346 StdDev: 1425.40 Min: 78 Median: 614.8000 Max: 8725 Percentiles: P50: 614.80 P75: 1900.00 P99: 6468.00 P99.9: 8725.00 P99.99: 8725.00 ------------------------------------------------------ ( 76, 110 ] 21 8.077% 8.077% ## ( 110, 170 ] 32 12.308% 20.385% ## ( 170, 250 ] 17 6.538% 26.923% # ( 250, 380 ] 25 9.615% 36.538% ## ( 380, 580 ] 32 12.308% 48.846% ## ( 580, 870 ] 25 9.615% 58.462% ## ( 870, 1300 ] 22 8.462% 66.923% ## ( 1300, 1900 ] 21 8.077% 75.000% ## ( 1900, 2900 ] 31 11.923% 86.923% ## ( 2900, 4400 ] 22 8.462% 95.385% ## ( 4400, 6600 ] 10 3.846% 99.231% # ( 6600, 9900 ] 2 0.769% 100.000% ** DB Stats ** Uptime(secs): 52.0 total, 4.2 interval Cumulative writes: 0 writes, 10M keys, 0 commit groups, 0.0 writes per commit group, ingest: 9.61 GB, 189.26 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.340 H:M:S, 46.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 236.02 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.457 H:M:S, 34.9 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.828 micros/op 171573 ops/sec 60.033 seconds 10299999 operations; 166.2 MB/s Microseconds per write: Count: 10299999 Average: 5.8284 StdDev: 443.62 Min: 0 Median: 1.7340 Max: 780343 Percentiles: P50: 1.73 P75: 2.76 P99: 9.70 P99.9: 1141.07 P99.99: 2695.15 ------------------------------------------------------ [ 0, 1 ] 1409293 13.682% 13.682% ### ( 1, 2 ] 5096666 49.482% 63.165% ########## ( 2, 3 ] 1606509 15.597% 78.762% ### ( 3, 4 ] 1403854 13.630% 92.391% ### ( 4, 6 ] 553423 5.373% 97.765% # ( 6, 10 ] 137571 1.336% 99.100% ( 10, 15 ] 49101 0.477% 99.577% ( 15, 22 ] 10986 0.107% 99.684% ( 22, 34 ] 2083 0.020% 99.704% ( 34, 51 ] 300 0.003% 99.707% ( 51, 76 ] 27 0.000% 99.707% ( 76, 110 ] 7085 0.069% 99.776% ( 110, 170 ] 2800 0.027% 99.803% ( 170, 250 ] 315 0.003% 99.806% ( 250, 380 ] 237 0.002% 99.808% ( 380, 580 ] 31 0.000% 99.809% ( 580, 870 ] 24 0.000% 99.809% ( 870, 1300 ] 14902 0.145% 99.953% ( 1300, 1900 ] 24 0.000% 99.954% ( 1900, 2900 ] 4701 0.046% 99.999% ( 2900, 4400 ] 33 0.000% 100.000% ( 4400, 6600 ] 2 0.000% 100.000% ( 6600, 9900 ] 2 0.000% 100.000% ( 9900, 14000 ] 2 0.000% 100.000% ( 14000, 22000 ] 3 0.000% 100.000% ( 22000, 33000 ] 2 0.000% 100.000% ( 50000, 75000 ] 1 0.000% 100.000% ( 110000, 170000 ] 5 0.000% 100.000% ( 170000, 250000 ] 13 0.000% 100.000% ( 250000, 380000 ] 2 0.000% 100.000% ( 570000, 860000 ] 2 0.000% 100.000% STATISTICS: rocksdb.block.cache.miss COUNT : 0 rocksdb.block.cache.hit COUNT : 0 rocksdb.block.cache.add COUNT : 0 rocksdb.block.cache.add.failures COUNT : 0 rocksdb.block.cache.index.miss COUNT : 0 rocksdb.block.cache.index.hit COUNT : 0 rocksdb.block.cache.index.add COUNT : 0 rocksdb.block.cache.index.bytes.insert COUNT : 0 rocksdb.block.cache.filter.miss COUNT : 0 rocksdb.block.cache.filter.hit COUNT : 0 rocksdb.block.cache.filter.add COUNT : 0 rocksdb.block.cache.filter.bytes.insert COUNT : 0 rocksdb.block.cache.data.miss COUNT : 0 rocksdb.block.cache.data.hit COUNT : 0 rocksdb.block.cache.data.add COUNT : 0 rocksdb.block.cache.data.bytes.insert COUNT : 0 rocksdb.block.cache.bytes.read COUNT : 0 rocksdb.block.cache.bytes.write COUNT : 0 rocksdb.bloom.filter.useful COUNT : 0 rocksdb.bloom.filter.full.positive COUNT : 0 rocksdb.bloom.filter.full.true.positive COUNT : 0 rocksdb.persistent.cache.hit COUNT : 0 rocksdb.persistent.cache.miss COUNT : 0 rocksdb.sim.block.cache.hit COUNT : 0 rocksdb.sim.block.cache.miss COUNT : 0 rocksdb.memtable.hit COUNT : 0 rocksdb.memtable.miss COUNT : 0 rocksdb.l0.hit COUNT : 0 rocksdb.l1.hit COUNT : 0 rocksdb.l2andup.hit COUNT : 0 rocksdb.compaction.key.drop.new COUNT : 175281 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 : 10299999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 10629598968 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 : 496 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 31406470 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 : 26773295153 rocksdb.compact.write.bytes COUNT : 26600412448 rocksdb.flush.write.bytes COUNT : 10569068626 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 : 62 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 : 286 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 : 10483939328 rocksdb.memtable.garbage.bytes.at.flush COUNT : 4149248 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 : 26871758098 rocksdb.non.last.level.read.count COUNT : 6488135 rocksdb.block.checksum.compute.count COUNT : 6487205 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.384844 P95 : 3.942079 P99 : 8.353830 P100 : 780341.000000 COUNT : 10299999 SUM : 55180226 rocksdb.compaction.times.micros P50 : 1093750.000000 P95 : 5840000.000000 P99 : 16240000.000000 P100 : 18895209.000000 COUNT : 72 SUM : 117210107 rocksdb.compaction.times.cpu_micros P50 : 940000.000000 P95 : 3880000.000000 P99 : 16240000.000000 P100 : 17345493.000000 COUNT : 72 SUM : 97056509 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 : 690.126582 P95 : 1900.000000 P99 : 146000.000000 P100 : 277717.000000 COUNT : 140 SUM : 710235 rocksdb.compaction.outfile.sync.micros P50 : 999.000000 P95 : 131473.684211 P99 : 169873.684211 P100 : 213168.000000 COUNT : 304 SUM : 5780950 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 : 102.741573 P95 : 855.500000 P99 : 3710.000000 P100 : 4910.000000 COUNT : 246 SUM : 60264 rocksdb.table.open.io.micros P50 : 1359.016393 P95 : 7865.000000 P99 : 12483.000000 P100 : 20954.000000 COUNT : 496 SUM : 1097855 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.603085 P95 : 7.564909 P99 : 10.765249 P100 : 19687.000000 COUNT : 6485887 SUM : 39122408 rocksdb.read.block.get.micros P50 : 448.750000 P95 : 3336.956522 P99 : 5438.400000 P100 : 8820.000000 COUNT : 992 SUM : 867865 rocksdb.write.raw.block.micros P50 : 0.513447 P95 : 0.975549 P99 : 2.858792 P100 : 18609.000000 COUNT : 9002477 SUM : 18128317 rocksdb.numfiles.in.singlecompaction P50 : 3.351190 P95 : 6.550000 P99 : 19.970000 P100 : 30.000000 COUNT : 129 SUM : 511 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.563933 P95 : 1185.260690 P99 : 2535.068347 P100 : 780162.000000 COUNT : 173961 SUM : 31426761 rocksdb.sst.read.micros P50 : 1.549291 P95 : 4.411814 P99 : 8.163003 P100 : 16666.000000 COUNT : 6488498 SUM : 25929917 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 : 10299999 SUM : 10629598968 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 : 211739.130435 P95 : 373500.000000 P99 : 935605.000000 P100 : 935605.000000 COUNT : 140 SUM : 31031531 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 : 299 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