[2024-07-15 23:56:34.457122] Starting SPDK v24.05.1-pre git sha1 5fa2f5086 / DPDK 22.11.4 initialization... [2024-07-15 23:56:34.457374] [ DPDK EAL parameters: rocksdb --no-shconf -c 0x1 --huge-unlink --no-telemetry --log-level=lib.eal:6 --log-level=lib.cryptodev:5 --log-level=user1:6 --base-virtaddr=0x200000000000 --match-allocations --file-prefix=spdk_pid3633689 ] Set seed to 1721080594450799 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-07-15 23:56:34.551375] app.c: 909:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-07-15 23:56:34.589218] app.c: 604:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-07-15 23:56:34.589265] app.c: 605:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 3633689' to capture a snapshot of events at runtime. [2024-07-15 23:56:34.589274] app.c: 610:app_setup_trace: *NOTICE*: 'spdk_trace' without parameters will also work if this is the only [2024-07-15 23:56:34.589284] app.c: 611:app_setup_trace: *NOTICE*: SPDK application currently running. [2024-07-15 23:56:34.589291] app.c: 612:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid3633689 for offline analysis/debug. [2024-07-15 23:56:34.589377] reactor.c: 937:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Mon Jul 15 23:56:38 2024 CPU: 96 * Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz CPUCache: 36608 KB 2024/07/15-23:56:41 ... thread 0: (1000000,1000000) ops and (336321.7,336321.7) ops/second in (2.973344,2.973344) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 9/6 629.98 MB 25.2 0.0 0.0 0.0 0.9 0.9 0.0 1.0 0.0 349.0 2.53 2.27 12 0.211 0 0 0.0 0.0 L2 3/2 251.73 MB 0.0 0.4 0.2 0.2 0.4 0.2 0.2 2.0 254.9 254.7 1.48 1.44 2 0.741 383K 206 0.0 0.0 L3 11/0 930.14 MB 0.9 0.0 0.0 0.0 0.0 0.0 0.1 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 116/0 9.54 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1040/0 85.69 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1179/8 97.00 GB 0.0 0.4 0.2 0.2 1.2 1.0 0.3 1.4 94.2 314.1 4.01 3.72 14 0.286 383K 206 0.0 0.0 Int 0/0 0.00 KB 0.0 0.4 0.2 0.2 1.2 1.0 0.2 1.4 94.2 314.1 4.01 3.72 14 0.286 383K 206 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 0.0 0.0 254.9 254.7 1.48 1.44 2 0.741 383K 206 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 349.0 2.53 2.27 12 0.211 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 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.23 GB write, 391.64 MB/s write, 0.37 GB read, 117.50 MB/s read, 4.0 seconds Interval compaction: 1.23 GB write, 423.44 MB/s write, 0.37 GB read, 127.04 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: 113154 Average: 2.0717 StdDev: 30.75 Min: 0 Median: 1.2816 Max: 5008 Percentiles: P50: 1.28 P75: 1.70 P99: 4.23 P99.9: 9.93 P99.99: 326.12 ------------------------------------------------------ [ 0, 1 ] 37633 33.258% 33.258% ####### ( 1, 2 ] 67283 59.461% 92.720% ############ ( 2, 3 ] 5215 4.609% 97.328% # ( 3, 4 ] 1789 1.581% 98.909% ( 4, 6 ] 873 0.772% 99.681% ( 6, 10 ] 252 0.223% 99.904% ( 10, 15 ] 61 0.054% 99.958% ( 15, 22 ] 16 0.014% 99.972% ( 22, 34 ] 5 0.004% 99.976% ( 34, 51 ] 2 0.002% 99.978% ( 51, 76 ] 1 0.001% 99.979% ( 110, 170 ] 6 0.005% 99.984% ( 170, 250 ] 2 0.002% 99.986% ( 250, 380 ] 8 0.007% 99.993% ( 1300, 1900 ] 1 0.001% 99.994% ( 2900, 4400 ] 5 0.004% 99.998% ( 4400, 6600 ] 2 0.002% 100.000% ** Level 1 read latency histogram (micros): Count: 5 Average: 1829.0000 StdDev: 1736.75 Min: 337 Median: 530.0000 Max: 4577 Percentiles: P50: 530.00 P75: 4025.00 P99: 4577.00 P99.9: 4577.00 P99.99: 4577.00 ------------------------------------------------------ ( 250, 380 ] 1 20.000% 20.000% #### ( 380, 580 ] 2 40.000% 60.000% ######## ( 2900, 4400 ] 1 20.000% 80.000% #### ( 4400, 6600 ] 1 20.000% 100.000% #### ** Level 2 read latency histogram (micros): Count: 71713 Average: 1.9081 StdDev: 6.61 Min: 0 Median: 1.3244 Max: 1199 Percentiles: P50: 1.32 P75: 1.73 P99: 5.09 P99.9: 9.70 P99.99: 31.94 ------------------------------------------------------ [ 0, 1 ] 21474 29.944% 29.944% ###### ( 1, 2 ] 44341 61.831% 91.776% ############ ( 2, 3 ] 3363 4.690% 96.465% # ( 3, 4 ] 1381 1.926% 98.391% ( 4, 6 ] 804 1.121% 99.512% ( 6, 10 ] 303 0.423% 99.934% ( 10, 15 ] 35 0.049% 99.983% ( 15, 22 ] 6 0.008% 99.992% ( 22, 34 ] 1 0.001% 99.993% ( 34, 51 ] 1 0.001% 99.994% ( 250, 380 ] 2 0.003% 99.997% ( 380, 580 ] 1 0.001% 99.999% ( 580, 870 ] 2 0.003% 100.001% ( 870, 1300 ] 1 0.001% 100.003% ** Level 3 read latency histogram (micros): Count: 50 Average: 1765.6200 StdDev: 1417.05 Min: 155 Median: 1228.3333 Max: 5017 Percentiles: P50: 1228.33 P75: 2828.57 P99: 5017.00 P99.9: 5017.00 P99.99: 5017.00 ------------------------------------------------------ ( 110, 170 ] 1 2.000% 2.000% ( 170, 250 ] 3 6.000% 8.000% # ( 250, 380 ] 2 4.000% 12.000% # ( 380, 580 ] 7 14.000% 26.000% ### ( 580, 870 ] 7 14.000% 40.000% ### ( 870, 1300 ] 6 12.000% 52.000% ## ( 1300, 1900 ] 5 10.000% 62.000% ## ( 1900, 2900 ] 7 14.000% 76.000% ### ( 2900, 4400 ] 10 20.000% 96.000% #### ( 4400, 6600 ] 2 4.000% 100.000% # ** Level 4 read latency histogram (micros): Count: 25 Average: 1677.0400 StdDev: 1556.91 Min: 77 Median: 1192.5000 Max: 5800 Percentiles: P50: 1192.50 P75: 2587.50 P99: 5800.00 P99.9: 5800.00 P99.99: 5800.00 ------------------------------------------------------ ( 76, 110 ] 3 12.000% 12.000% ## ( 250, 380 ] 2 8.000% 20.000% ## ( 380, 580 ] 2 8.000% 28.000% ## ( 580, 870 ] 4 16.000% 44.000% ### ( 870, 1300 ] 2 8.000% 52.000% ## ( 1300, 1900 ] 3 12.000% 64.000% ## ( 1900, 2900 ] 4 16.000% 80.000% ### ( 2900, 4400 ] 3 12.000% 92.000% ## ( 4400, 6600 ] 2 8.000% 100.000% ## ** DB Stats ** Uptime(secs): 3.2 total, 3.0 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 305.98 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:0.421 H:M:S, 13.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 330.76 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.421 H:M:S, 14.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/07/15-23:56:44 ... thread 0: (1000000,2000000) ops and (353794.6,344836.9) ops/second in (2.826499,5.799843) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 11/8 1.17 GB 62.9 0.6 0.0 0.6 2.3 1.8 0.0 1.3 76.9 324.7 7.37 6.79 28 0.263 575K 600 0.0 0.0 L1 1/0 3.68 MB 0.4 0.4 0.4 0.0 0.4 0.4 0.2 1.0 235.4 235.0 1.61 1.55 1 1.606 383K 591 0.0 0.0 L2 2/1 54.50 MB 0.5 0.4 0.2 0.2 0.4 0.2 0.5 2.0 254.9 254.7 1.48 1.44 2 0.741 383K 206 0.0 0.0 L3 21/11 1.25 GB 0.3 0.2 0.2 0.0 0.2 0.2 0.4 1.0 231.3 231.3 1.08 1.01 1 1.078 253K 0 0.0 0.0 L4 173/0 9.75 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.0 1.0 147.2 147.2 1.53 1.12 1 1.525 228K 0 0.0 0.0 L5 1040/0 85.69 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1248/20 97.92 GB 0.0 1.8 1.0 0.7 3.5 2.8 1.2 2.0 137.6 277.3 13.06 11.92 33 0.396 1824K 1397 0.0 0.0 Int 0/0 0.00 KB 0.0 1.8 1.0 0.7 3.5 2.8 1.1 2.0 137.6 277.3 13.06 11.92 33 0.396 1824K 1397 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 1.8 1.0 0.7 1.8 1.0 0.0 0.0 227.6 227.4 7.89 7.28 7 1.128 1824K 1397 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 353.4 5.17 4.63 26 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): 6.0 total, 5.8 interval Flush(GB): cumulative 1.784, interval 1.784 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 3.54 GB write, 599.43 MB/s write, 1.75 GB read, 297.35 MB/s read, 13.1 seconds Interval compaction: 3.54 GB write, 624.40 MB/s write, 1.75 GB read, 309.73 MB/s read, 13.1 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 5, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 5, interval: 5 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 385003 Average: 2.2658 StdDev: 18.12 Min: 0 Median: 1.5036 Max: 5008 Percentiles: P50: 1.50 P75: 1.89 P99: 5.68 P99.9: 10.69 P99.99: 16.17 ------------------------------------------------------ [ 0, 1 ] 68114 17.692% 17.692% #### ( 1, 2 ] 246991 64.153% 81.845% ############# ( 2, 3 ] 41982 10.904% 92.749% ## ( 3, 4 ] 15284 3.970% 96.719% # ( 4, 6 ] 10465 2.718% 99.437% # ( 6, 10 ] 1729 0.449% 99.886% ( 10, 15 ] 394 0.102% 99.989% ( 15, 22 ] 39 0.010% 99.999% ( 22, 34 ] 11 0.003% 100.002% ( 34, 51 ] 5 0.001% 100.003% ( 51, 76 ] 2 0.001% 100.003% ( 110, 170 ] 14 0.004% 100.007% ( 170, 250 ] 8 0.002% 100.009% ( 250, 380 ] 11 0.003% 100.012% ( 380, 580 ] 4 0.001% 100.013% ( 580, 870 ] 6 0.002% 100.015% ( 870, 1300 ] 3 0.001% 100.015% ( 1300, 1900 ] 2 0.001% 100.016% ( 1900, 2900 ] 2 0.001% 100.016% ( 2900, 4400 ] 5 0.001% 100.018% ( 4400, 6600 ] 2 0.001% 100.018% ** Level 1 read latency histogram (micros): Count: 30 Average: 467.6000 StdDev: 991.39 Min: 1 Median: 2.0000 Max: 4577 Percentiles: P50: 2.00 P75: 413.33 P99: 4577.00 P99.9: 4577.00 P99.99: 4577.00 ------------------------------------------------------ [ 0, 1 ] 7 23.333% 23.333% ##### ( 1, 2 ] 8 26.667% 50.000% ##### ( 2, 3 ] 1 3.333% 53.333% # ( 4, 6 ] 1 3.333% 56.667% # ( 110, 170 ] 1 3.333% 60.000% # ( 170, 250 ] 1 3.333% 63.333% # ( 250, 380 ] 3 10.000% 73.333% ## ( 380, 580 ] 3 10.000% 83.333% ## ( 870, 1300 ] 2 6.667% 90.000% # ( 1300, 1900 ] 1 3.333% 93.333% # ( 2900, 4400 ] 1 3.333% 96.667% # ( 4400, 6600 ] 1 3.333% 100.000% # ** Level 2 read latency histogram (micros): Count: 95605 Average: 1.9918 StdDev: 5.75 Min: 0 Median: 1.3901 Max: 1199 Percentiles: P50: 1.39 P75: 1.78 P99: 5.41 P99.9: 9.72 P99.99: 21.51 ------------------------------------------------------ [ 0, 1 ] 24165 25.276% 25.276% ##### ( 1, 2 ] 60586 63.371% 88.647% ############# ( 2, 3 ] 6335 6.626% 95.273% # ( 3, 4 ] 2489 2.603% 97.877% # ( 4, 6 ] 1527 1.597% 99.474% ( 6, 10 ] 438 0.458% 99.932% ( 10, 15 ] 48 0.050% 99.982% ( 15, 22 ] 8 0.008% 99.991% ( 22, 34 ] 1 0.001% 99.992% ( 34, 51 ] 1 0.001% 99.993% ( 51, 76 ] 1 0.001% 99.994% ( 250, 380 ] 2 0.002% 99.996% ( 380, 580 ] 1 0.001% 99.997% ( 580, 870 ] 2 0.002% 99.999% ( 870, 1300 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 175785 Average: 3.5475 StdDev: 40.80 Min: 1 Median: 1.6979 Max: 5017 Percentiles: P50: 1.70 P75: 2.35 P99: 9.06 P99.9: 160.18 P99.99: 494.25 ------------------------------------------------------ [ 0, 1 ] 13303 7.568% 7.568% ## ( 1, 2 ] 106875 60.799% 68.366% ############ ( 2, 3 ] 33706 19.175% 87.541% #### ( 3, 4 ] 9695 5.515% 93.056% # ( 4, 6 ] 8252 4.694% 97.751% # ( 6, 10 ] 2870 1.633% 99.383% ( 10, 15 ] 541 0.308% 99.691% ( 15, 22 ] 107 0.061% 99.752% ( 22, 34 ] 22 0.013% 99.764% ( 34, 51 ] 4 0.002% 99.767% ( 51, 76 ] 7 0.004% 99.771% ( 76, 110 ] 75 0.043% 99.813% ( 110, 170 ] 182 0.104% 99.917% ( 170, 250 ] 61 0.035% 99.952% ( 250, 380 ] 44 0.025% 99.977% ( 380, 580 ] 41 0.023% 100.000% ( 580, 870 ] 27 0.015% 100.015% ( 870, 1300 ] 8 0.005% 100.020% ( 1300, 1900 ] 8 0.005% 100.024% ( 1900, 2900 ] 7 0.004% 100.028% ( 2900, 4400 ] 10 0.006% 100.034% ( 4400, 6600 ] 2 0.001% 100.035% ** Level 4 read latency histogram (micros): Count: 310 Average: 140.9323 StdDev: 634.85 Min: 0 Median: 1.6842 Max: 5800 Percentiles: P50: 1.68 P75: 5.91 P99: 3850.00 P99.9: 5800.00 P99.99: 5800.00 ------------------------------------------------------ [ 0, 1 ] 64 20.645% 20.645% #### ( 1, 2 ] 133 42.903% 63.548% ######### ( 2, 3 ] 21 6.774% 70.323% # ( 3, 4 ] 4 1.290% 71.613% ( 4, 6 ] 11 3.548% 75.161% # ( 6, 10 ] 10 3.226% 78.387% # ( 10, 15 ] 37 11.935% 90.323% ## ( 15, 22 ] 1 0.323% 90.645% ( 22, 34 ] 1 0.323% 90.968% ( 76, 110 ] 3 0.968% 91.935% ( 170, 250 ] 2 0.645% 92.581% ( 250, 380 ] 3 0.968% 93.548% ( 380, 580 ] 2 0.645% 94.194% ( 580, 870 ] 4 1.290% 95.484% ( 870, 1300 ] 2 0.645% 96.129% ( 1300, 1900 ] 3 0.968% 97.097% ( 1900, 2900 ] 4 1.290% 98.387% ( 2900, 4400 ] 3 0.968% 99.355% ( 4400, 6600 ] 2 0.645% 100.000% ** DB Stats ** Uptime(secs): 6.0 total, 2.8 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 325.72 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:0.646 H:M:S, 10.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 348.20 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.224 H:M:S, 7.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/07/15-23:56:47 ... thread 0: (1000000,3000000) ops and (342115.8,343925.1) ops/second in (2.922987,8.722830) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 12/10 2.09 GB 12.6 1.7 0.0 1.7 4.4 2.7 0.0 1.6 119.1 313.0 14.28 13.31 45 0.317 1727K 1819 0.0 0.0 L1 1/1 3.68 MB 0.0 0.4 0.4 0.0 0.4 0.4 0.2 1.0 235.4 235.0 1.61 1.55 1 1.606 383K 591 0.0 0.0 L2 1/0 52.10 MB 0.5 0.4 0.2 0.2 0.4 0.2 0.5 2.0 254.9 254.7 1.48 1.44 2 0.741 383K 206 0.0 0.0 L3 17/0 761.39 MB 0.8 1.2 0.2 0.9 1.2 0.2 0.4 4.7 238.3 237.8 4.96 4.59 2 2.480 1200K 2429 0.0 0.0 L4 173/0 9.58 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.5 1.0 147.2 147.2 1.53 1.12 1 1.525 228K 0 0.0 0.0 L5 1048/0 86.37 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1252/11 98.84 GB 0.0 3.8 1.0 2.8 6.5 3.7 2.4 2.4 161.9 277.9 23.86 22.01 51 0.468 3923K 5045 0.0 0.0 Int 0/0 0.00 KB 0.0 3.8 1.0 2.8 6.5 3.7 2.3 2.4 161.9 277.9 23.86 22.01 51 0.468 3923K 5045 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.8 1.0 2.8 3.8 1.0 0.0 0.0 239.8 239.5 16.11 15.09 12 1.343 3923K 5045 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 2.7 2.7 0.0 0.0 0.0 357.9 7.75 6.92 39 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.7 interval Flush(GB): cumulative 2.707, interval 2.707 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 6.47 GB write, 739.48 MB/s write, 3.77 GB read, 430.89 MB/s read, 23.9 seconds Interval compaction: 6.47 GB write, 759.95 MB/s write, 3.77 GB read, 442.82 MB/s read, 23.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: 8, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 8, interval: 8 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 621149 Average: 2.2332 StdDev: 15.57 Min: 0 Median: 1.4931 Max: 5008 Percentiles: P50: 1.49 P75: 1.88 P99: 5.65 P99.9: 10.72 P99.99: 18.62 ------------------------------------------------------ [ 0, 1 ] 112860 18.170% 18.170% #### ( 1, 2 ] 400998 64.557% 82.727% ############# ( 2, 3 ] 65166 10.491% 93.218% ## ( 3, 4 ] 23190 3.733% 96.952% # ( 4, 6 ] 15432 2.484% 99.436% ( 6, 10 ] 2792 0.449% 99.886% ( 10, 15 ] 623 0.100% 99.986% ( 15, 22 ] 50 0.008% 99.994% ( 22, 34 ] 13 0.002% 99.996% ( 34, 51 ] 7 0.001% 99.997% ( 51, 76 ] 4 0.001% 99.998% ( 76, 110 ] 18 0.003% 100.001% ( 110, 170 ] 23 0.004% 100.004% ( 170, 250 ] 11 0.002% 100.006% ( 250, 380 ] 19 0.003% 100.009% ( 380, 580 ] 5 0.001% 100.010% ( 580, 870 ] 12 0.002% 100.012% ( 870, 1300 ] 12 0.002% 100.014% ( 1300, 1900 ] 2 0.000% 100.014% ( 1900, 2900 ] 2 0.000% 100.014% ( 2900, 4400 ] 6 0.001% 100.015% ( 4400, 6600 ] 2 0.000% 100.016% ** Level 1 read latency histogram (micros): Count: 28281 Average: 3.6484 StdDev: 38.45 Min: 1 Median: 1.6566 Max: 4577 Percentiles: P50: 1.66 P75: 2.16 P99: 9.17 P99.9: 307.19 P99.99: 1403.14 ------------------------------------------------------ [ 0, 1 ] 1966 6.952% 6.952% # ( 1, 2 ] 18541 65.560% 72.512% ############# ( 2, 3 ] 4439 15.696% 88.208% ### ( 3, 4 ] 1615 5.711% 93.918% # ( 4, 6 ] 1028 3.635% 97.553% # ( 6, 10 ] 516 1.825% 99.378% ( 10, 15 ] 54 0.191% 99.569% ( 15, 22 ] 3 0.011% 99.579% ( 51, 76 ] 2 0.007% 99.586% ( 76, 110 ] 46 0.163% 99.749% ( 110, 170 ] 21 0.074% 99.823% ( 170, 250 ] 16 0.057% 99.880% ( 250, 380 ] 13 0.046% 99.926% ( 380, 580 ] 13 0.046% 99.972% ( 580, 870 ] 3 0.011% 99.982% ( 870, 1300 ] 2 0.007% 99.989% ( 1300, 1900 ] 1 0.004% 99.993% ( 2900, 4400 ] 1 0.004% 99.996% ( 4400, 6600 ] 1 0.004% 100.000% ** Level 2 read latency histogram (micros): Count: 95906 Average: 2.0230 StdDev: 6.89 Min: 0 Median: 1.3915 Max: 1199 Percentiles: P50: 1.39 P75: 1.79 P99: 5.42 P99.9: 9.78 P99.99: 295.81 ------------------------------------------------------ [ 0, 1 ] 24170 25.202% 25.202% ##### ( 1, 2 ] 60744 63.337% 88.539% ############# ( 2, 3 ] 6436 6.711% 95.250% # ( 3, 4 ] 2507 2.614% 97.864% # ( 4, 6 ] 1536 1.602% 99.465% ( 6, 10 ] 441 0.460% 99.925% ( 10, 15 ] 48 0.050% 99.975% ( 15, 22 ] 8 0.008% 99.983% ( 22, 34 ] 1 0.001% 99.984% ( 34, 51 ] 1 0.001% 99.985% ( 51, 76 ] 1 0.001% 99.986% ( 110, 170 ] 2 0.002% 99.989% ( 250, 380 ] 4 0.004% 99.993% ( 380, 580 ] 3 0.003% 99.996% ( 580, 870 ] 3 0.003% 99.999% ( 870, 1300 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 265012 Average: 3.3408 StdDev: 34.55 Min: 0 Median: 1.6386 Max: 5017 Percentiles: P50: 1.64 P75: 2.13 P99: 8.94 P99.9: 172.90 P99.99: 553.24 ------------------------------------------------------ [ 0, 1 ] 25228 9.520% 9.520% ## ( 1, 2 ] 167980 63.386% 72.905% ############# ( 2, 3 ] 43297 16.338% 89.243% ### ( 3, 4 ] 12781 4.823% 94.066% # ( 4, 6 ] 9895 3.734% 97.800% # ( 6, 10 ] 4335 1.636% 99.435% ( 10, 15 ] 655 0.247% 99.683% ( 15, 22 ] 116 0.044% 99.726% ( 22, 34 ] 23 0.009% 99.735% ( 34, 51 ] 4 0.002% 99.737% ( 51, 76 ] 8 0.003% 99.740% ( 76, 110 ] 137 0.052% 99.791% ( 110, 170 ] 284 0.107% 99.898% ( 170, 250 ] 110 0.042% 99.940% ( 250, 380 ] 71 0.027% 99.967% ( 380, 580 ] 71 0.027% 99.994% ( 580, 870 ] 40 0.015% 100.009% ( 870, 1300 ] 12 0.005% 100.013% ( 1300, 1900 ] 8 0.003% 100.016% ( 1900, 2900 ] 7 0.003% 100.019% ( 2900, 4400 ] 10 0.004% 100.023% ( 4400, 6600 ] 2 0.001% 100.023% ** Level 4 read latency histogram (micros): Count: 310 Average: 140.9323 StdDev: 634.85 Min: 0 Median: 1.6842 Max: 5800 Percentiles: P50: 1.68 P75: 5.91 P99: 3850.00 P99.9: 5800.00 P99.99: 5800.00 ------------------------------------------------------ [ 0, 1 ] 64 20.645% 20.645% #### ( 1, 2 ] 133 42.903% 63.548% ######### ( 2, 3 ] 21 6.774% 70.323% # ( 3, 4 ] 4 1.290% 71.613% ( 4, 6 ] 11 3.548% 75.161% # ( 6, 10 ] 10 3.226% 78.387% # ( 10, 15 ] 37 11.935% 90.323% ## ( 15, 22 ] 1 0.323% 90.645% ( 22, 34 ] 1 0.323% 90.968% ( 76, 110 ] 3 0.968% 91.935% ( 170, 250 ] 2 0.645% 92.581% ( 250, 380 ] 3 0.968% 93.548% ( 380, 580 ] 2 0.645% 94.194% ( 580, 870 ] 4 1.290% 95.484% ( 870, 1300 ] 2 0.645% 96.129% ( 1300, 1900 ] 3 0.968% 97.097% ( 1900, 2900 ] 4 1.290% 98.387% ( 2900, 4400 ] 3 0.968% 99.355% ( 4400, 6600 ] 2 0.645% 100.000% ** Level 5 read latency histogram (micros): Count: 40 Average: 807.9000 StdDev: 966.75 Min: 81 Median: 328.0000 Max: 3256 Percentiles: P50: 328.00 P75: 1085.00 P99: 3256.00 P99.9: 3256.00 P99.99: 3256.00 ------------------------------------------------------ ( 76, 110 ] 5 12.500% 12.500% ### ( 110, 170 ] 11 27.500% 40.000% ###### ( 170, 250 ] 1 2.500% 42.500% # ( 250, 380 ] 5 12.500% 55.000% ### ( 380, 580 ] 3 7.500% 62.500% ## ( 580, 870 ] 4 10.000% 72.500% ## ( 870, 1300 ] 2 5.000% 77.500% # ( 1300, 1900 ] 3 7.500% 85.000% ## ( 1900, 2900 ] 2 5.000% 90.000% # ( 2900, 4400 ] 4 10.000% 100.000% ## ** DB Stats ** Uptime(secs): 9.0 total, 2.9 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 329.30 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:1.030 H:M:S, 11.5 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 336.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.385 H:M:S, 13.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/07/15-23:56:51 ... thread 0: (1000000,4000000) ops and (287472.7,327830.7) ops/second in (3.478591,12.201421) 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/14 3.20 GB 94.4 2.5 0.0 2.5 6.3 3.8 0.0 1.7 123.9 311.0 20.85 19.46 63 0.331 2622K 2800 0.0 0.0 L1 1/1 3.68 MB 0.0 0.4 0.4 0.0 0.4 0.4 0.2 1.0 235.4 235.0 1.61 1.55 1 1.606 383K 591 0.0 0.0 L2 1/0 52.10 MB 0.5 0.4 0.2 0.2 0.4 0.2 0.5 2.0 254.9 254.7 1.48 1.44 2 0.741 383K 206 0.0 0.0 L3 17/0 761.39 MB 0.8 1.2 0.2 0.9 1.2 0.2 0.4 4.7 238.3 237.8 4.96 4.59 2 2.480 1200K 2429 0.0 0.0 L4 173/0 9.58 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.5 1.0 147.2 147.2 1.53 1.12 1 1.525 228K 0 0.0 0.0 L5 1048/0 86.37 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1258/15 99.94 GB 0.0 4.6 1.0 3.6 8.4 4.8 2.4 2.2 156.0 284.1 30.43 28.17 69 0.441 4818K 6026 0.0 0.0 Int 0/0 0.00 KB 0.0 4.6 1.0 3.6 8.4 4.8 2.3 2.2 156.0 284.1 30.43 28.17 69 0.441 4818K 6026 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.6 1.0 3.6 4.6 1.0 0.0 0.0 244.3 243.9 19.43 18.34 15 1.295 4818K 6026 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 3.8 3.8 0.0 0.0 0.0 355.1 11.00 9.83 54 0.204 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 12.4 total, 12.2 interval Flush(GB): cumulative 3.814, interval 3.814 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 8.44 GB write, 694.68 MB/s write, 4.63 GB read, 381.31 MB/s read, 30.4 seconds Interval compaction: 8.44 GB write, 708.43 MB/s write, 4.63 GB read, 388.86 MB/s read, 30.4 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 2, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 2, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 13, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 2, total-stops: 13, interval: 15 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1066679 Average: 2.2236 StdDev: 13.39 Min: 0 Median: 1.5009 Max: 5008 Percentiles: P50: 1.50 P75: 1.88 P99: 5.61 P99.9: 9.98 P99.99: 14.81 ------------------------------------------------------ [ 0, 1 ] 180541 16.926% 16.926% ### ( 1, 2 ] 704357 66.033% 82.958% ############# ( 2, 3 ] 112956 10.590% 93.548% ## ( 3, 4 ] 38900 3.647% 97.195% # ( 4, 6 ] 23867 2.238% 99.432% ( 6, 10 ] 5015 0.470% 99.902% ( 10, 15 ] 974 0.091% 99.994% ( 15, 22 ] 102 0.010% 100.003% ( 22, 34 ] 19 0.002% 100.005% ( 34, 51 ] 10 0.001% 100.006% ( 51, 76 ] 6 0.001% 100.006% ( 76, 110 ] 33 0.003% 100.009% ( 110, 170 ] 70 0.007% 100.016% ( 170, 250 ] 23 0.002% 100.018% ( 250, 380 ] 29 0.003% 100.021% ( 380, 580 ] 15 0.001% 100.022% ( 580, 870 ] 18 0.002% 100.024% ( 870, 1300 ] 18 0.002% 100.026% ( 1300, 1900 ] 5 0.000% 100.026% ( 1900, 2900 ] 2 0.000% 100.026% ( 2900, 4400 ] 7 0.001% 100.027% ( 4400, 6600 ] 2 0.000% 100.027% ** Level 1 read latency histogram (micros): Count: 28281 Average: 3.6484 StdDev: 38.45 Min: 1 Median: 1.6566 Max: 4577 Percentiles: P50: 1.66 P75: 2.16 P99: 9.17 P99.9: 307.19 P99.99: 1403.14 ------------------------------------------------------ [ 0, 1 ] 1966 6.952% 6.952% # ( 1, 2 ] 18541 65.560% 72.512% ############# ( 2, 3 ] 4439 15.696% 88.208% ### ( 3, 4 ] 1615 5.711% 93.918% # ( 4, 6 ] 1028 3.635% 97.553% # ( 6, 10 ] 516 1.825% 99.378% ( 10, 15 ] 54 0.191% 99.569% ( 15, 22 ] 3 0.011% 99.579% ( 51, 76 ] 2 0.007% 99.586% ( 76, 110 ] 46 0.163% 99.749% ( 110, 170 ] 21 0.074% 99.823% ( 170, 250 ] 16 0.057% 99.880% ( 250, 380 ] 13 0.046% 99.926% ( 380, 580 ] 13 0.046% 99.972% ( 580, 870 ] 3 0.011% 99.982% ( 870, 1300 ] 2 0.007% 99.989% ( 1300, 1900 ] 1 0.004% 99.993% ( 2900, 4400 ] 1 0.004% 99.996% ( 4400, 6600 ] 1 0.004% 100.000% ** Level 2 read latency histogram (micros): Count: 95906 Average: 2.0230 StdDev: 6.89 Min: 0 Median: 1.3915 Max: 1199 Percentiles: P50: 1.39 P75: 1.79 P99: 5.42 P99.9: 9.78 P99.99: 295.81 ------------------------------------------------------ [ 0, 1 ] 24170 25.202% 25.202% ##### ( 1, 2 ] 60744 63.337% 88.539% ############# ( 2, 3 ] 6436 6.711% 95.250% # ( 3, 4 ] 2507 2.614% 97.864% # ( 4, 6 ] 1536 1.602% 99.465% ( 6, 10 ] 441 0.460% 99.925% ( 10, 15 ] 48 0.050% 99.975% ( 15, 22 ] 8 0.008% 99.983% ( 22, 34 ] 1 0.001% 99.984% ( 34, 51 ] 1 0.001% 99.985% ( 51, 76 ] 1 0.001% 99.986% ( 110, 170 ] 2 0.002% 99.989% ( 250, 380 ] 4 0.004% 99.993% ( 380, 580 ] 3 0.003% 99.996% ( 580, 870 ] 3 0.003% 99.999% ( 870, 1300 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 265012 Average: 3.3408 StdDev: 34.55 Min: 0 Median: 1.6386 Max: 5017 Percentiles: P50: 1.64 P75: 2.13 P99: 8.94 P99.9: 172.90 P99.99: 553.24 ------------------------------------------------------ [ 0, 1 ] 25228 9.520% 9.520% ## ( 1, 2 ] 167980 63.386% 72.905% ############# ( 2, 3 ] 43297 16.338% 89.243% ### ( 3, 4 ] 12781 4.823% 94.066% # ( 4, 6 ] 9895 3.734% 97.800% # ( 6, 10 ] 4335 1.636% 99.435% ( 10, 15 ] 655 0.247% 99.683% ( 15, 22 ] 116 0.044% 99.726% ( 22, 34 ] 23 0.009% 99.735% ( 34, 51 ] 4 0.002% 99.737% ( 51, 76 ] 8 0.003% 99.740% ( 76, 110 ] 137 0.052% 99.791% ( 110, 170 ] 284 0.107% 99.898% ( 170, 250 ] 110 0.042% 99.940% ( 250, 380 ] 71 0.027% 99.967% ( 380, 580 ] 71 0.027% 99.994% ( 580, 870 ] 40 0.015% 100.009% ( 870, 1300 ] 12 0.005% 100.013% ( 1300, 1900 ] 8 0.003% 100.016% ( 1900, 2900 ] 7 0.003% 100.019% ( 2900, 4400 ] 10 0.004% 100.023% ( 4400, 6600 ] 2 0.001% 100.023% ** Level 4 read latency histogram (micros): Count: 310 Average: 140.9323 StdDev: 634.85 Min: 0 Median: 1.6842 Max: 5800 Percentiles: P50: 1.68 P75: 5.91 P99: 3850.00 P99.9: 5800.00 P99.99: 5800.00 ------------------------------------------------------ [ 0, 1 ] 64 20.645% 20.645% #### ( 1, 2 ] 133 42.903% 63.548% ######### ( 2, 3 ] 21 6.774% 70.323% # ( 3, 4 ] 4 1.290% 71.613% ( 4, 6 ] 11 3.548% 75.161% # ( 6, 10 ] 10 3.226% 78.387% # ( 10, 15 ] 37 11.935% 90.323% ## ( 15, 22 ] 1 0.323% 90.645% ( 22, 34 ] 1 0.323% 90.968% ( 76, 110 ] 3 0.968% 91.935% ( 170, 250 ] 2 0.645% 92.581% ( 250, 380 ] 3 0.968% 93.548% ( 380, 580 ] 2 0.645% 94.194% ( 580, 870 ] 4 1.290% 95.484% ( 870, 1300 ] 2 0.645% 96.129% ( 1300, 1900 ] 3 0.968% 97.097% ( 1900, 2900 ] 4 1.290% 98.387% ( 2900, 4400 ] 3 0.968% 99.355% ( 4400, 6600 ] 2 0.645% 100.000% ** Level 5 read latency histogram (micros): Count: 40 Average: 807.9000 StdDev: 966.75 Min: 81 Median: 328.0000 Max: 3256 Percentiles: P50: 328.00 P75: 1085.00 P99: 3256.00 P99.9: 3256.00 P99.99: 3256.00 ------------------------------------------------------ ( 76, 110 ] 5 12.500% 12.500% ### ( 110, 170 ] 11 27.500% 40.000% ###### ( 170, 250 ] 1 2.500% 42.500% # ( 250, 380 ] 5 12.500% 55.000% ### ( 380, 580 ] 3 7.500% 62.500% ## ( 580, 870 ] 4 10.000% 72.500% ## ( 870, 1300 ] 2 5.000% 77.500% # ( 1300, 1900 ] 3 7.500% 85.000% ## ( 1900, 2900 ] 2 5.000% 90.000% # ( 2900, 4400 ] 4 10.000% 100.000% ## ** DB Stats ** Uptime(secs): 12.4 total, 3.5 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 316.34 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:1.902 H:M:S, 15.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 282.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.871 H:M:S, 25.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 0 2024/07/15-23:56:55 ... thread 0: (1000000,5000000) ops and (205432.1,292925.1) ops/second in (4.867788,17.069209) 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 2.09 GB 132.1 3.6 0.0 3.6 8.2 4.7 0.0 1.8 133.9 309.3 27.28 25.55 81 0.337 3709K 3905 0.0 0.0 L1 9/0 968.88 MB 96.9 2.3 2.3 0.0 2.3 2.3 0.2 1.0 233.1 231.3 10.28 9.93 2 5.138 2432K 18K 0.0 0.0 L2 9/3 1.06 GB 7.7 0.4 0.2 0.2 0.4 0.2 1.5 2.0 254.9 254.7 1.48 1.44 2 0.741 383K 206 0.0 0.0 L3 17/9 761.39 MB 0.5 1.2 0.2 0.9 1.2 0.2 0.4 4.7 238.3 237.8 4.96 4.59 2 2.480 1200K 2429 0.0 0.0 L4 173/0 9.58 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.5 1.0 147.2 147.2 1.53 1.12 1 1.525 228K 0 0.0 0.0 L5 1048/0 86.37 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1266/16 100.79 GB 0.0 7.7 3.0 4.7 12.3 7.6 3.4 2.6 172.1 276.7 45.53 42.64 88 0.517 7954K 25K 0.0 0.0 Int 0/0 0.00 KB 0.0 7.7 3.0 4.7 12.3 7.6 3.3 2.6 172.1 276.7 45.53 42.64 88 0.517 7954K 25K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 7.7 3.0 4.7 7.6 3.0 0.0 0.0 244.6 243.8 32.03 30.58 20 1.601 7954K 25K 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 354.7 13.50 12.05 68 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): 17.3 total, 17.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: 12.30 GB write, 727.56 MB/s write, 7.65 GB read, 452.50 MB/s read, 45.5 seconds Interval compaction: 12.30 GB write, 737.86 MB/s write, 7.65 GB read, 458.91 MB/s read, 45.5 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 11, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 11, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 13, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 11, total-stops: 13, interval: 24 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1643987 Average: 2.2233 StdDev: 12.77 Min: 0 Median: 1.4916 Max: 5008 Percentiles: P50: 1.49 P75: 1.87 P99: 5.69 P99.9: 10.44 P99.99: 20.19 ------------------------------------------------------ [ 0, 1 ] 282680 17.195% 17.195% ### ( 1, 2 ] 1097026 66.730% 83.924% ############# ( 2, 3 ] 163684 9.957% 93.881% ## ( 3, 4 ] 56251 3.422% 97.303% # ( 4, 6 ] 32969 2.005% 99.308% ( 6, 10 ] 9600 0.584% 99.892% ( 10, 15 ] 1509 0.092% 99.984% ( 15, 22 ] 141 0.009% 99.992% ( 22, 34 ] 25 0.002% 99.994% ( 34, 51 ] 11 0.001% 99.994% ( 51, 76 ] 7 0.000% 99.995% ( 76, 110 ] 128 0.008% 100.003% ( 110, 170 ] 139 0.008% 100.011% ( 170, 250 ] 58 0.004% 100.015% ( 250, 380 ] 62 0.004% 100.018% ( 380, 580 ] 47 0.003% 100.021% ( 580, 870 ] 35 0.002% 100.023% ( 870, 1300 ] 26 0.002% 100.025% ( 1300, 1900 ] 5 0.000% 100.025% ( 1900, 2900 ] 2 0.000% 100.025% ( 2900, 4400 ] 11 0.001% 100.026% ( 4400, 6600 ] 2 0.000% 100.026% ** Level 1 read latency histogram (micros): Count: 45677 Average: 5.4285 StdDev: 45.31 Min: 1 Median: 1.7401 Max: 4577 Percentiles: P50: 1.74 P75: 2.50 P99: 13.80 P99.9: 442.53 P99.99: 569.02 ------------------------------------------------------ [ 0, 1 ] 2376 5.202% 5.202% # ( 1, 2 ] 27647 60.527% 65.729% ############ ( 2, 3 ] 8478 18.561% 84.290% #### ( 3, 4 ] 3093 6.771% 91.061% # ( 4, 6 ] 2483 5.436% 96.497% # ( 6, 10 ] 1019 2.231% 98.728% ( 10, 15 ] 166 0.363% 99.091% ( 15, 22 ] 34 0.074% 99.166% ( 22, 34 ] 11 0.024% 99.190% ( 34, 51 ] 2 0.004% 99.194% ( 51, 76 ] 4 0.009% 99.203% ( 76, 110 ] 74 0.162% 99.365% ( 110, 170 ] 84 0.184% 99.549% ( 170, 250 ] 79 0.173% 99.722% ( 250, 380 ] 63 0.138% 99.860% ( 380, 580 ] 65 0.142% 100.002% ( 580, 870 ] 18 0.039% 100.042% ( 870, 1300 ] 13 0.028% 100.070% ( 1300, 1900 ] 5 0.011% 100.081% ( 2900, 4400 ] 1 0.002% 100.083% ( 4400, 6600 ] 1 0.002% 100.085% ** Level 2 read latency histogram (micros): Count: 95906 Average: 2.0230 StdDev: 6.89 Min: 0 Median: 1.3915 Max: 1199 Percentiles: P50: 1.39 P75: 1.79 P99: 5.42 P99.9: 9.78 P99.99: 295.81 ------------------------------------------------------ [ 0, 1 ] 24170 25.202% 25.202% ##### ( 1, 2 ] 60744 63.337% 88.539% ############# ( 2, 3 ] 6436 6.711% 95.250% # ( 3, 4 ] 2507 2.614% 97.864% # ( 4, 6 ] 1536 1.602% 99.465% ( 6, 10 ] 441 0.460% 99.925% ( 10, 15 ] 48 0.050% 99.975% ( 15, 22 ] 8 0.008% 99.983% ( 22, 34 ] 1 0.001% 99.984% ( 34, 51 ] 1 0.001% 99.985% ( 51, 76 ] 1 0.001% 99.986% ( 110, 170 ] 2 0.002% 99.989% ( 250, 380 ] 4 0.004% 99.993% ( 380, 580 ] 3 0.003% 99.996% ( 580, 870 ] 3 0.003% 99.999% ( 870, 1300 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 265300 Average: 3.4047 StdDev: 34.85 Min: 0 Median: 1.6393 Max: 5017 Percentiles: P50: 1.64 P75: 2.13 P99: 9.00 P99.9: 198.89 P99.99: 564.27 ------------------------------------------------------ [ 0, 1 ] 25228 9.509% 9.509% ## ( 1, 2 ] 168040 63.340% 72.849% ############# ( 2, 3 ] 43399 16.358% 89.207% ### ( 3, 4 ] 12812 4.829% 94.037% # ( 4, 6 ] 9918 3.738% 97.775% # ( 6, 10 ] 4339 1.636% 99.410% ( 10, 15 ] 659 0.248% 99.659% ( 15, 22 ] 117 0.044% 99.703% ( 22, 34 ] 23 0.009% 99.712% ( 34, 51 ] 4 0.002% 99.713% ( 51, 76 ] 9 0.003% 99.717% ( 76, 110 ] 145 0.055% 99.771% ( 110, 170 ] 299 0.113% 99.884% ( 170, 250 ] 121 0.046% 99.930% ( 250, 380 ] 85 0.032% 99.962% ( 380, 580 ] 83 0.031% 99.993% ( 580, 870 ] 43 0.016% 100.009% ( 870, 1300 ] 12 0.005% 100.014% ( 1300, 1900 ] 8 0.003% 100.017% ( 1900, 2900 ] 7 0.003% 100.019% ( 2900, 4400 ] 10 0.004% 100.023% ( 4400, 6600 ] 2 0.001% 100.024% ** Level 4 read latency histogram (micros): Count: 310 Average: 140.9323 StdDev: 634.85 Min: 0 Median: 1.6842 Max: 5800 Percentiles: P50: 1.68 P75: 5.91 P99: 3850.00 P99.9: 5800.00 P99.99: 5800.00 ------------------------------------------------------ [ 0, 1 ] 64 20.645% 20.645% #### ( 1, 2 ] 133 42.903% 63.548% ######### ( 2, 3 ] 21 6.774% 70.323% # ( 3, 4 ] 4 1.290% 71.613% ( 4, 6 ] 11 3.548% 75.161% # ( 6, 10 ] 10 3.226% 78.387% # ( 10, 15 ] 37 11.935% 90.323% ## ( 15, 22 ] 1 0.323% 90.645% ( 22, 34 ] 1 0.323% 90.968% ( 76, 110 ] 3 0.968% 91.935% ( 170, 250 ] 2 0.645% 92.581% ( 250, 380 ] 3 0.968% 93.548% ( 380, 580 ] 2 0.645% 94.194% ( 580, 870 ] 4 1.290% 95.484% ( 870, 1300 ] 2 0.645% 96.129% ( 1300, 1900 ] 3 0.968% 97.097% ( 1900, 2900 ] 4 1.290% 98.387% ( 2900, 4400 ] 3 0.968% 99.355% ( 4400, 6600 ] 2 0.645% 100.000% ** Level 5 read latency histogram (micros): Count: 40 Average: 807.9000 StdDev: 966.75 Min: 81 Median: 328.0000 Max: 3256 Percentiles: P50: 328.00 P75: 1085.00 P99: 3256.00 P99.9: 3256.00 P99.99: 3256.00 ------------------------------------------------------ ( 76, 110 ] 5 12.500% 12.500% ### ( 110, 170 ] 11 27.500% 40.000% ###### ( 170, 250 ] 1 2.500% 42.500% # ( 250, 380 ] 5 12.500% 55.000% ### ( 380, 580 ] 3 7.500% 62.500% ## ( 580, 870 ] 4 10.000% 72.500% ## ( 870, 1300 ] 2 5.000% 77.500% # ( 1300, 1900 ] 3 7.500% 85.000% ## ( 1900, 2900 ] 2 5.000% 90.000% # ( 2900, 4400 ] 4 10.000% 100.000% ## ** DB Stats ** Uptime(secs): 17.3 total, 4.9 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 284.24 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:4.148 H:M:S, 24.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 202.18 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:2.246 H:M:S, 46.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 4 num-running-flushes: 1 2024/07/15-23:56:59 ... thread 0: (1000000,6000000) ops and (308869.1,295467.1) ops/second in (3.237618,20.306827) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 14/4 3.01 GB 276.7 4.9 0.0 4.9 10.5 5.6 0.0 1.9 140.9 301.0 35.76 33.33 97 0.369 5116K 6961 0.0 0.0 L1 9/0 968.88 MB 96.9 2.3 2.3 0.0 2.3 2.3 0.2 1.0 233.1 231.3 10.28 9.93 2 5.138 2432K 18K 0.0 0.0 L2 1/1 128.78 MB 0.0 0.4 0.2 0.2 0.4 0.2 1.5 2.0 254.9 254.7 1.48 1.44 2 0.741 383K 206 0.0 0.0 L3 22/2 1.05 GB 1.0 2.7 1.2 1.5 2.7 1.2 0.4 2.3 213.8 213.4 13.01 11.67 9 1.445 2824K 6006 0.0 0.0 L4 174/0 9.59 GB 1.0 0.5 0.4 0.0 0.5 0.4 0.9 1.1 164.2 164.0 2.86 2.27 4 0.714 460K 196 0.0 0.0 L5 1056/0 86.98 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1276/7 101.70 GB 0.0 10.8 4.1 6.7 16.4 9.7 4.4 2.9 174.5 264.5 63.38 58.64 114 0.556 11M 32K 0.0 0.0 Int 0/0 0.00 KB 0.0 10.8 4.1 6.7 16.4 9.7 4.3 2.9 174.5 264.5 63.38 58.64 114 0.556 11M 32K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 10.8 4.1 6.7 10.8 4.1 0.0 0.0 235.7 235.0 46.94 44.15 33 1.422 11M 32K 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 348.6 16.44 14.48 81 0.203 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 20.5 total, 20.3 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: 16.37 GB write, 815.70 MB/s write, 10.80 GB read, 538.34 MB/s read, 63.4 seconds Interval compaction: 16.37 GB write, 825.40 MB/s write, 10.80 GB read, 544.75 MB/s read, 63.4 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 11, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 11, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 21, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 11, total-stops: 21, interval: 32 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2002177 Average: 2.3524 StdDev: 14.80 Min: 0 Median: 1.5338 Max: 5008 Percentiles: P50: 1.53 P75: 1.92 P99: 5.85 P99.9: 10.98 P99.99: 21.95 ------------------------------------------------------ [ 0, 1 ] 301383 15.053% 15.053% ### ( 1, 2 ] 1310860 65.472% 80.524% ############# ( 2, 3 ] 227495 11.362% 91.887% ## ( 3, 4 ] 86695 4.330% 96.217% # ( 4, 6 ] 60180 3.006% 99.223% # ( 6, 10 ] 13168 0.658% 99.880% ( 10, 15 ] 2015 0.101% 99.981% ( 15, 22 ] 183 0.009% 99.990% ( 22, 34 ] 29 0.001% 99.992% ( 34, 51 ] 13 0.001% 99.992% ( 51, 76 ] 8 0.000% 99.993% ( 76, 110 ] 140 0.007% 100.000% ( 110, 170 ] 175 0.009% 100.008% ( 170, 250 ] 99 0.005% 100.013% ( 250, 380 ] 87 0.004% 100.018% ( 380, 580 ] 81 0.004% 100.022% ( 580, 870 ] 57 0.003% 100.025% ( 870, 1300 ] 34 0.002% 100.026% ( 1300, 1900 ] 10 0.000% 100.027% ( 1900, 2900 ] 20 0.001% 100.028% ( 2900, 4400 ] 13 0.001% 100.028% ( 4400, 6600 ] 2 0.000% 100.028% ** Level 1 read latency histogram (micros): Count: 374362 Average: 4.1297 StdDev: 43.84 Min: 1 Median: 1.8666 Max: 5851 Percentiles: P50: 1.87 P75: 2.80 P99: 9.15 P99.9: 120.73 P99.99: 320.10 ------------------------------------------------------ [ 0, 1 ] 7874 2.103% 2.103% ( 1, 2 ] 206899 55.267% 57.370% ########### ( 2, 3 ] 82717 22.095% 79.466% #### ( 3, 4 ] 33681 8.997% 88.463% ## ( 4, 6 ] 33451 8.935% 97.398% ## ( 6, 10 ] 7627 2.037% 99.436% ( 10, 15 ] 1413 0.377% 99.813% ( 15, 22 ] 162 0.043% 99.856% ( 22, 34 ] 18 0.005% 99.861% ( 34, 51 ] 4 0.001% 99.862% ( 51, 76 ] 6 0.002% 99.864% ( 76, 110 ] 110 0.029% 99.893% ( 110, 170 ] 149 0.040% 99.933% ( 170, 250 ] 145 0.039% 99.972% ( 250, 380 ] 129 0.034% 100.006% ( 380, 580 ] 142 0.038% 100.044% ( 580, 870 ] 77 0.021% 100.065% ( 870, 1300 ] 40 0.011% 100.075% ( 1300, 1900 ] 12 0.003% 100.079% ( 1900, 2900 ] 69 0.018% 100.097% ( 2900, 4400 ] 11 0.003% 100.100% ( 4400, 6600 ] 2 0.001% 100.100% ** Level 2 read latency histogram (micros): Count: 95906 Average: 2.0230 StdDev: 6.89 Min: 0 Median: 1.3915 Max: 1199 Percentiles: P50: 1.39 P75: 1.79 P99: 5.42 P99.9: 9.78 P99.99: 295.81 ------------------------------------------------------ [ 0, 1 ] 24170 25.202% 25.202% ##### ( 1, 2 ] 60744 63.337% 88.539% ############# ( 2, 3 ] 6436 6.711% 95.250% # ( 3, 4 ] 2507 2.614% 97.864% # ( 4, 6 ] 1536 1.602% 99.465% ( 6, 10 ] 441 0.460% 99.925% ( 10, 15 ] 48 0.050% 99.975% ( 15, 22 ] 8 0.008% 99.983% ( 22, 34 ] 1 0.001% 99.984% ( 34, 51 ] 1 0.001% 99.985% ( 51, 76 ] 1 0.001% 99.986% ( 110, 170 ] 2 0.002% 99.989% ( 250, 380 ] 4 0.004% 99.993% ( 380, 580 ] 3 0.003% 99.996% ( 580, 870 ] 3 0.003% 99.999% ( 870, 1300 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 411166 Average: 3.5307 StdDev: 30.47 Min: 0 Median: 1.7372 Max: 5017 Percentiles: P50: 1.74 P75: 2.49 P99: 8.84 P99.9: 171.82 P99.99: 391.59 ------------------------------------------------------ [ 0, 1 ] 27437 6.673% 6.673% # ( 1, 2 ] 241666 58.776% 65.449% ############ ( 2, 3 ] 80110 19.484% 84.932% #### ( 3, 4 ] 28125 6.840% 91.773% # ( 4, 6 ] 25068 6.097% 97.869% # ( 6, 10 ] 6549 1.593% 99.462% ( 10, 15 ] 969 0.236% 99.698% ( 15, 22 ] 172 0.042% 99.740% ( 22, 34 ] 31 0.008% 99.747% ( 34, 51 ] 4 0.001% 99.748% ( 51, 76 ] 9 0.002% 99.750% ( 76, 110 ] 207 0.050% 99.801% ( 110, 170 ] 403 0.098% 99.899% ( 170, 250 ] 213 0.052% 99.951% ( 250, 380 ] 154 0.037% 99.988% ( 380, 580 ] 136 0.033% 100.021% ( 580, 870 ] 77 0.019% 100.040% ( 870, 1300 ] 28 0.007% 100.047% ( 1300, 1900 ] 9 0.002% 100.049% ( 1900, 2900 ] 7 0.002% 100.051% ( 2900, 4400 ] 10 0.002% 100.053% ( 4400, 6600 ] 2 0.000% 100.054% ** Level 4 read latency histogram (micros): Count: 6224 Average: 28.3416 StdDev: 171.04 Min: 0 Median: 1.9191 Max: 5800 Percentiles: P50: 1.92 P75: 3.06 P99: 592.76 P99.9: 2594.00 P99.99: 5800.00 ------------------------------------------------------ [ 0, 1 ] 227 3.647% 3.647% # ( 1, 2 ] 3139 50.434% 54.081% ########## ( 2, 3 ] 1268 20.373% 74.454% #### ( 3, 4 ] 591 9.496% 83.949% ## ( 4, 6 ] 366 5.880% 89.830% # ( 6, 10 ] 125 2.008% 91.838% ( 10, 15 ] 77 1.237% 93.075% ( 15, 22 ] 6 0.096% 93.172% ( 22, 34 ] 1 0.016% 93.188% ( 76, 110 ] 47 0.755% 93.943% ( 110, 170 ] 114 1.832% 95.774% ( 170, 250 ] 78 1.253% 97.028% ( 250, 380 ] 64 1.028% 98.056% ( 380, 580 ] 57 0.916% 98.972% ( 580, 870 ] 40 0.643% 99.614% ( 870, 1300 ] 8 0.129% 99.743% ( 1300, 1900 ] 7 0.112% 99.855% ( 1900, 2900 ] 4 0.064% 99.920% ( 2900, 4400 ] 3 0.048% 99.968% ( 4400, 6600 ] 2 0.032% 100.000% ** Level 5 read latency histogram (micros): Count: 80 Average: 840.3750 StdDev: 980.28 Min: 77 Median: 358.3333 Max: 4163 Percentiles: P50: 358.33 P75: 1192.50 P99: 4163.00 P99.9: 4163.00 P99.99: 4163.00 ------------------------------------------------------ ( 76, 110 ] 10 12.500% 12.500% ### ( 110, 170 ] 14 17.500% 30.000% #### ( 170, 250 ] 6 7.500% 37.500% ## ( 250, 380 ] 12 15.000% 52.500% ### ( 380, 580 ] 7 8.750% 61.250% ## ( 580, 870 ] 8 10.000% 71.250% ## ( 870, 1300 ] 4 5.000% 76.250% # ( 1300, 1900 ] 6 7.500% 83.750% ## ( 1900, 2900 ] 7 8.750% 92.500% ## ( 2900, 4400 ] 6 7.500% 100.000% ## ** DB Stats ** Uptime(secs): 20.6 total, 3.2 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 287.35 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:4.599 H:M:S, 22.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 303.99 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.452 H:M:S, 14.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/07/15-23:57:02 ... thread 0: (1000000,7000000) ops and (280688.7,293261.4) ops/second in (3.562666,23.869493) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 19/17 3.99 GB 37.8 5.8 0.0 5.8 12.4 6.6 0.0 1.9 141.0 301.3 41.99 39.20 114 0.368 6011K 7915 0.0 0.0 L1 9/9 968.88 MB 0.0 2.3 2.3 0.0 2.3 2.3 0.2 1.0 233.1 231.3 10.28 9.93 2 5.138 2432K 18K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 1.5 2.0 254.9 254.7 1.48 1.44 2 0.741 383K 206 0.0 0.0 L3 20/0 983.45 MB 1.0 2.9 1.3 1.6 2.9 1.3 0.4 2.2 214.6 214.1 13.98 12.58 10 1.398 3046K 6523 0.0 0.0 L4 172/0 9.43 GB 1.0 0.7 0.7 0.0 0.7 0.6 0.9 1.1 172.5 172.2 4.13 3.39 7 0.590 699K 572 0.0 0.0 L5 1060/0 87.35 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1280/26 102.68 GB 0.0 12.1 4.5 7.6 18.7 11.0 4.8 2.8 172.7 266.0 71.85 66.55 135 0.532 12M 34K 0.0 0.0 Int 0/0 0.00 KB 0.0 12.1 4.5 7.6 18.7 11.0 4.7 2.8 172.7 266.0 71.85 66.55 135 0.532 12M 34K 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.1 4.5 7.6 12.1 4.4 0.0 0.0 236.1 235.4 52.56 49.50 40 1.314 12M 34K 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 349.3 19.30 17.05 95 0.203 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 24.1 total, 23.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: 18.66 GB write, 792.58 MB/s write, 12.12 GB read, 514.50 MB/s read, 71.9 seconds Interval compaction: 18.66 GB write, 800.60 MB/s write, 12.12 GB read, 519.70 MB/s read, 71.9 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 13, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 13, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 25, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 13, total-stops: 25, interval: 38 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2368361 Average: 2.3658 StdDev: 14.32 Min: 0 Median: 1.5311 Max: 5008 Percentiles: P50: 1.53 P75: 1.91 P99: 5.86 P99.9: 11.80 P99.99: 110.03 ------------------------------------------------------ [ 0, 1 ] 358717 15.146% 15.146% ### ( 1, 2 ] 1554207 65.624% 80.770% ############# ( 2, 3 ] 266942 11.271% 92.041% ## ( 3, 4 ] 101285 4.277% 96.318% # ( 4, 6 ] 68317 2.885% 99.202% # ( 6, 10 ] 15633 0.660% 99.862% ( 10, 15 ] 2478 0.105% 99.967% ( 15, 22 ] 229 0.010% 99.977% ( 22, 34 ] 34 0.001% 99.978% ( 34, 51 ] 13 0.001% 99.979% ( 51, 76 ] 9 0.000% 99.979% ( 76, 110 ] 260 0.011% 99.990% ( 110, 170 ] 353 0.015% 100.005% ( 170, 250 ] 164 0.007% 100.012% ( 250, 380 ] 126 0.005% 100.017% ( 380, 580 ] 111 0.005% 100.022% ( 580, 870 ] 77 0.003% 100.025% ( 870, 1300 ] 44 0.002% 100.027% ( 1300, 1900 ] 12 0.001% 100.027% ( 1900, 2900 ] 21 0.001% 100.028% ( 2900, 4400 ] 13 0.001% 100.029% ( 4400, 6600 ] 2 0.000% 100.029% ** Level 1 read latency histogram (micros): Count: 384956 Average: 4.0849 StdDev: 43.25 Min: 1 Median: 1.8594 Max: 5851 Percentiles: P50: 1.86 P75: 2.78 P99: 9.12 P99.9: 116.86 P99.99: 320.04 ------------------------------------------------------ [ 0, 1 ] 8527 2.215% 2.215% ( 1, 2 ] 214051 55.604% 57.819% ########### ( 2, 3 ] 84407 21.926% 79.745% #### ( 3, 4 ] 34197 8.883% 88.629% ## ( 4, 6 ] 33809 8.783% 97.411% ## ( 6, 10 ] 7835 2.035% 99.447% ( 10, 15 ] 1428 0.371% 99.818% ( 15, 22 ] 162 0.042% 99.860% ( 22, 34 ] 18 0.005% 99.864% ( 34, 51 ] 4 0.001% 99.865% ( 51, 76 ] 6 0.002% 99.867% ( 76, 110 ] 110 0.029% 99.896% ( 110, 170 ] 149 0.039% 99.934% ( 170, 250 ] 145 0.038% 99.972% ( 250, 380 ] 129 0.034% 100.005% ( 380, 580 ] 142 0.037% 100.042% ( 580, 870 ] 78 0.020% 100.063% ( 870, 1300 ] 40 0.010% 100.073% ( 1300, 1900 ] 12 0.003% 100.076% ( 1900, 2900 ] 69 0.018% 100.094% ( 2900, 4400 ] 11 0.003% 100.097% ( 4400, 6600 ] 2 0.001% 100.097% ** Level 2 read latency histogram (micros): Count: 95906 Average: 2.0230 StdDev: 6.89 Min: 0 Median: 1.3915 Max: 1199 Percentiles: P50: 1.39 P75: 1.79 P99: 5.42 P99.9: 9.78 P99.99: 295.81 ------------------------------------------------------ [ 0, 1 ] 24170 25.202% 25.202% ##### ( 1, 2 ] 60744 63.337% 88.539% ############# ( 2, 3 ] 6436 6.711% 95.250% # ( 3, 4 ] 2507 2.614% 97.864% # ( 4, 6 ] 1536 1.602% 99.465% ( 6, 10 ] 441 0.460% 99.925% ( 10, 15 ] 48 0.050% 99.975% ( 15, 22 ] 8 0.008% 99.983% ( 22, 34 ] 1 0.001% 99.984% ( 34, 51 ] 1 0.001% 99.985% ( 51, 76 ] 1 0.001% 99.986% ( 110, 170 ] 2 0.002% 99.989% ( 250, 380 ] 4 0.004% 99.993% ( 380, 580 ] 3 0.003% 99.996% ( 580, 870 ] 3 0.003% 99.999% ( 870, 1300 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 481615 Average: 3.4122 StdDev: 28.17 Min: 0 Median: 1.7492 Max: 5017 Percentiles: P50: 1.75 P75: 2.51 P99: 8.66 P99.9: 148.62 P99.99: 310.70 ------------------------------------------------------ [ 0, 1 ] 28846 5.989% 5.989% # ( 1, 2 ] 282901 58.740% 64.730% ############ ( 2, 3 ] 96590 20.055% 84.785% #### ( 3, 4 ] 33452 6.946% 91.731% # ( 4, 6 ] 30133 6.257% 97.987% # ( 6, 10 ] 7320 1.520% 99.507% ( 10, 15 ] 1177 0.244% 99.752% ( 15, 22 ] 196 0.041% 99.792% ( 22, 34 ] 35 0.007% 99.800% ( 34, 51 ] 6 0.001% 99.801% ( 51, 76 ] 11 0.002% 99.803% ( 76, 110 ] 207 0.043% 99.846% ( 110, 170 ] 403 0.084% 99.930% ( 170, 250 ] 217 0.045% 99.975% ( 250, 380 ] 156 0.032% 100.007% ( 380, 580 ] 136 0.028% 100.036% ( 580, 870 ] 77 0.016% 100.051% ( 870, 1300 ] 28 0.006% 100.057% ( 1300, 1900 ] 9 0.002% 100.059% ( 1900, 2900 ] 7 0.001% 100.061% ( 2900, 4400 ] 10 0.002% 100.063% ( 4400, 6600 ] 2 0.000% 100.063% ** Level 4 read latency histogram (micros): Count: 12159 Average: 23.1800 StdDev: 134.06 Min: 0 Median: 1.8597 Max: 5800 Percentiles: P50: 1.86 P75: 2.90 P99: 495.36 P99.9: 1513.08 P99.99: 3292.05 ------------------------------------------------------ [ 0, 1 ] 500 4.112% 4.112% # ( 1, 2 ] 6490 53.376% 57.488% ########### ( 2, 3 ] 2367 19.467% 76.955% #### ( 3, 4 ] 1006 8.274% 85.229% ## ( 4, 6 ] 627 5.157% 90.386% # ( 6, 10 ] 240 1.974% 92.360% ( 10, 15 ] 102 0.839% 93.198% ( 15, 22 ] 9 0.074% 93.272% ( 22, 34 ] 2 0.016% 93.289% ( 34, 51 ] 2 0.016% 93.305% ( 76, 110 ] 125 1.028% 94.333% ( 110, 170 ] 251 2.064% 96.398% ( 170, 250 ] 147 1.209% 97.607% ( 250, 380 ] 110 0.905% 98.511% ( 380, 580 ] 103 0.847% 99.358% ( 580, 870 ] 54 0.444% 99.803% ( 870, 1300 ] 9 0.074% 99.877% ( 1300, 1900 ] 8 0.066% 99.942% ( 1900, 2900 ] 5 0.041% 99.984% ( 2900, 4400 ] 3 0.025% 100.008% ( 4400, 6600 ] 2 0.016% 100.025% ** Level 5 read latency histogram (micros): Count: 100 Average: 815.6100 StdDev: 964.57 Min: 77 Median: 340.0000 Max: 4163 Percentiles: P50: 340.00 P75: 1128.00 P99: 4163.00 P99.9: 4163.00 P99.99: 4163.00 ------------------------------------------------------ ( 76, 110 ] 15 15.000% 15.000% ### ( 110, 170 ] 20 20.000% 35.000% #### ( 170, 250 ] 6 6.000% 41.000% # ( 250, 380 ] 13 13.000% 54.000% ### ( 380, 580 ] 7 7.000% 61.000% # ( 580, 870 ] 11 11.000% 72.000% ## ( 870, 1300 ] 5 5.000% 77.000% # ( 1300, 1900 ] 6 6.000% 83.000% # ( 1900, 2900 ] 10 10.000% 93.000% ## ( 2900, 4400 ] 7 7.000% 100.000% # ** DB Stats ** Uptime(secs): 24.1 total, 3.6 interval Cumulative writes: 0 writes, 7000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 6.73 GB, 285.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:5.555 H:M:S, 23.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 276.25 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.955 H:M:S, 26.8 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/07/15-23:57:11 ... thread 0: (1000000,8000000) ops and (118664.7,247704.1) ops/second in (8.427107,32.296600) 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/13 5.03 GB 169.7 7.8 0.0 7.8 15.4 7.6 0.0 2.0 151.8 299.9 52.69 49.45 137 0.385 8122K 11K 0.0 0.0 L1 9/9 968.88 MB 0.0 2.3 2.3 0.0 2.3 2.3 0.2 1.0 233.1 231.3 10.28 9.93 2 5.138 2432K 18K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 1.5 2.0 254.9 254.7 1.48 1.44 2 0.741 383K 206 0.0 0.0 L3 20/0 983.45 MB 1.0 2.9 1.3 1.6 2.9 1.3 0.4 2.2 214.6 214.1 13.98 12.58 10 1.398 3046K 6523 0.0 0.0 L4 172/0 9.43 GB 1.0 0.7 0.7 0.0 0.7 0.6 0.9 1.1 172.5 172.2 4.13 3.39 7 0.590 699K 572 0.0 0.0 L5 1060/0 87.35 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1279/22 103.73 GB 0.0 14.1 4.5 9.7 21.7 12.1 4.8 2.8 175.5 269.6 82.55 76.80 158 0.522 14M 37K 0.0 0.0 Int 0/0 0.00 KB 0.0 14.1 4.5 9.7 21.7 12.1 4.7 2.8 175.5 269.6 82.55 76.80 158 0.522 14M 37K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 14.1 4.5 9.7 14.1 4.4 0.0 0.0 240.8 240.1 60.15 57.01 46 1.308 14M 37K 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 348.7 22.40 19.79 112 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): 32.5 total, 32.3 interval Flush(GB): cumulative 7.629, interval 7.629 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 21.73 GB write, 683.98 MB/s write, 14.14 GB read, 445.12 MB/s read, 82.5 seconds Interval compaction: 21.73 GB write, 689.10 MB/s write, 14.14 GB read, 448.45 MB/s read, 82.5 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 24, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 24, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 25, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 24, total-stops: 25, interval: 49 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3267823 Average: 2.3178 StdDev: 13.08 Min: 0 Median: 1.5120 Max: 5008 Percentiles: P50: 1.51 P75: 1.89 P99: 5.85 P99.9: 12.17 P99.99: 124.63 ------------------------------------------------------ [ 0, 1 ] 523052 16.006% 16.006% ### ( 1, 2 ] 2169693 66.396% 82.402% ############# ( 2, 3 ] 342453 10.480% 92.881% ## ( 3, 4 ] 127132 3.890% 96.772% # ( 4, 6 ] 78642 2.407% 99.178% ( 6, 10 ] 22194 0.679% 99.857% ( 10, 15 ] 3201 0.098% 99.955% ( 15, 22 ] 497 0.015% 99.971% ( 22, 34 ] 40 0.001% 99.972% ( 34, 51 ] 19 0.001% 99.972% ( 51, 76 ] 9 0.000% 99.973% ( 76, 110 ] 426 0.013% 99.986% ( 110, 170 ] 571 0.017% 100.003% ( 170, 250 ] 231 0.007% 100.010% ( 250, 380 ] 174 0.005% 100.016% ( 380, 580 ] 147 0.004% 100.020% ( 580, 870 ] 99 0.003% 100.023% ( 870, 1300 ] 48 0.001% 100.025% ( 1300, 1900 ] 13 0.000% 100.025% ( 1900, 2900 ] 27 0.001% 100.026% ( 2900, 4400 ] 13 0.000% 100.026% ( 4400, 6600 ] 2 0.000% 100.026% ** Level 1 read latency histogram (micros): Count: 451192 Average: 3.8536 StdDev: 40.14 Min: 1 Median: 1.7919 Max: 5851 Percentiles: P50: 1.79 P75: 2.66 P99: 9.05 P99.9: 117.07 P99.99: 327.51 ------------------------------------------------------ [ 0, 1 ] 20737 4.596% 4.596% # ( 1, 2 ] 258690 57.335% 61.931% ########### ( 2, 3 ] 89951 19.936% 81.867% #### ( 3, 4 ] 35863 7.949% 89.816% ## ( 4, 6 ] 34682 7.687% 97.502% ## ( 6, 10 ] 8853 1.962% 99.465% ( 10, 15 ] 1498 0.332% 99.797% ( 15, 22 ] 186 0.041% 99.838% ( 22, 34 ] 19 0.004% 99.842% ( 34, 51 ] 4 0.001% 99.843% ( 51, 76 ] 23 0.005% 99.848% ( 76, 110 ] 213 0.047% 99.895% ( 110, 170 ] 185 0.041% 99.936% ( 170, 250 ] 160 0.035% 99.972% ( 250, 380 ] 139 0.031% 100.002% ( 380, 580 ] 148 0.033% 100.035% ( 580, 870 ] 81 0.018% 100.053% ( 870, 1300 ] 41 0.009% 100.062% ( 1300, 1900 ] 12 0.003% 100.065% ( 1900, 2900 ] 69 0.015% 100.080% ( 2900, 4400 ] 11 0.002% 100.083% ( 4400, 6600 ] 2 0.000% 100.083% ** Level 2 read latency histogram (micros): Count: 95906 Average: 2.0230 StdDev: 6.89 Min: 0 Median: 1.3915 Max: 1199 Percentiles: P50: 1.39 P75: 1.79 P99: 5.42 P99.9: 9.78 P99.99: 295.81 ------------------------------------------------------ [ 0, 1 ] 24170 25.202% 25.202% ##### ( 1, 2 ] 60744 63.337% 88.539% ############# ( 2, 3 ] 6436 6.711% 95.250% # ( 3, 4 ] 2507 2.614% 97.864% # ( 4, 6 ] 1536 1.602% 99.465% ( 6, 10 ] 441 0.460% 99.925% ( 10, 15 ] 48 0.050% 99.975% ( 15, 22 ] 8 0.008% 99.983% ( 22, 34 ] 1 0.001% 99.984% ( 34, 51 ] 1 0.001% 99.985% ( 51, 76 ] 1 0.001% 99.986% ( 110, 170 ] 2 0.002% 99.989% ( 250, 380 ] 4 0.004% 99.993% ( 380, 580 ] 3 0.003% 99.996% ( 580, 870 ] 3 0.003% 99.999% ( 870, 1300 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 481615 Average: 3.4122 StdDev: 28.17 Min: 0 Median: 1.7492 Max: 5017 Percentiles: P50: 1.75 P75: 2.51 P99: 8.66 P99.9: 148.62 P99.99: 310.70 ------------------------------------------------------ [ 0, 1 ] 28846 5.989% 5.989% # ( 1, 2 ] 282901 58.740% 64.730% ############ ( 2, 3 ] 96590 20.055% 84.785% #### ( 3, 4 ] 33452 6.946% 91.731% # ( 4, 6 ] 30133 6.257% 97.987% # ( 6, 10 ] 7320 1.520% 99.507% ( 10, 15 ] 1177 0.244% 99.752% ( 15, 22 ] 196 0.041% 99.792% ( 22, 34 ] 35 0.007% 99.800% ( 34, 51 ] 6 0.001% 99.801% ( 51, 76 ] 11 0.002% 99.803% ( 76, 110 ] 207 0.043% 99.846% ( 110, 170 ] 403 0.084% 99.930% ( 170, 250 ] 217 0.045% 99.975% ( 250, 380 ] 156 0.032% 100.007% ( 380, 580 ] 136 0.028% 100.036% ( 580, 870 ] 77 0.016% 100.051% ( 870, 1300 ] 28 0.006% 100.057% ( 1300, 1900 ] 9 0.002% 100.059% ( 1900, 2900 ] 7 0.001% 100.061% ( 2900, 4400 ] 10 0.002% 100.063% ( 4400, 6600 ] 2 0.000% 100.063% ** Level 4 read latency histogram (micros): Count: 12159 Average: 23.1800 StdDev: 134.06 Min: 0 Median: 1.8597 Max: 5800 Percentiles: P50: 1.86 P75: 2.90 P99: 495.36 P99.9: 1513.08 P99.99: 3292.05 ------------------------------------------------------ [ 0, 1 ] 500 4.112% 4.112% # ( 1, 2 ] 6490 53.376% 57.488% ########### ( 2, 3 ] 2367 19.467% 76.955% #### ( 3, 4 ] 1006 8.274% 85.229% ## ( 4, 6 ] 627 5.157% 90.386% # ( 6, 10 ] 240 1.974% 92.360% ( 10, 15 ] 102 0.839% 93.198% ( 15, 22 ] 9 0.074% 93.272% ( 22, 34 ] 2 0.016% 93.289% ( 34, 51 ] 2 0.016% 93.305% ( 76, 110 ] 125 1.028% 94.333% ( 110, 170 ] 251 2.064% 96.398% ( 170, 250 ] 147 1.209% 97.607% ( 250, 380 ] 110 0.905% 98.511% ( 380, 580 ] 103 0.847% 99.358% ( 580, 870 ] 54 0.444% 99.803% ( 870, 1300 ] 9 0.074% 99.877% ( 1300, 1900 ] 8 0.066% 99.942% ( 1900, 2900 ] 5 0.041% 99.984% ( 2900, 4400 ] 3 0.025% 100.008% ( 4400, 6600 ] 2 0.016% 100.025% ** Level 5 read latency histogram (micros): Count: 100 Average: 815.6100 StdDev: 964.57 Min: 77 Median: 340.0000 Max: 4163 Percentiles: P50: 340.00 P75: 1128.00 P99: 4163.00 P99.9: 4163.00 P99.99: 4163.00 ------------------------------------------------------ ( 76, 110 ] 15 15.000% 15.000% ### ( 110, 170 ] 20 20.000% 35.000% #### ( 170, 250 ] 6 6.000% 41.000% # ( 250, 380 ] 13 13.000% 54.000% ### ( 380, 580 ] 7 7.000% 61.000% # ( 580, 870 ] 11 11.000% 72.000% ## ( 870, 1300 ] 5 5.000% 77.000% # ( 1300, 1900 ] 6 6.000% 83.000% # ( 1900, 2900 ] 10 10.000% 93.000% ## ( 2900, 4400 ] 7 7.000% 100.000% # ** DB Stats ** Uptime(secs): 32.5 total, 8.4 interval Cumulative writes: 0 writes, 8000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 7.69 GB, 241.97 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:11.346 H:M:S, 34.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 116.79 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:5.791 H:M:S, 68.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/07/15-23:57:27 ... thread 0: (1000000,9000000) ops and (60122.3,183938.6) ops/second in (16.632766,48.929366) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 12/9 2.58 GB 37.8 8.3 0.0 8.3 16.8 8.5 0.0 2.0 145.9 295.9 58.29 53.90 152 0.384 8633K 12K 0.0 0.0 L1 16/16 1.63 GB 0.0 6.7 5.7 0.9 6.6 5.6 0.2 1.1 218.4 215.0 31.24 28.85 3 10.414 6928K 106K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 4.1 2.0 254.9 254.7 1.48 1.44 2 0.741 383K 206 0.0 0.0 L3 17/2 1.10 GB 0.9 5.8 3.3 2.5 5.8 3.3 1.0 1.8 168.8 167.7 35.19 26.04 23 1.530 6032K 37K 0.0 0.0 L4 171/3 9.59 GB 1.0 3.3 3.1 0.2 3.3 3.1 0.9 1.1 151.3 150.9 22.51 15.75 35 0.643 3369K 3337 0.0 0.0 L5 1088/0 89.63 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 1304/30 104.53 GB 0.0 24.5 12.3 12.2 32.9 20.7 10.3 3.8 168.4 226.2 148.72 125.99 215 0.692 25M 160K 0.0 0.0 Int 0/0 0.00 KB 0.0 24.5 12.3 12.2 32.9 20.7 10.2 3.8 168.4 226.2 148.72 125.99 215 0.692 25M 160K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 24.5 12.3 12.2 24.3 12.1 0.0 0.0 203.5 202.1 123.10 103.71 90 1.368 25M 160K 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 341.7 25.62 22.28 125 0.205 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 49.2 total, 48.9 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: 32.85 GB write, 684.12 MB/s write, 24.46 GB read, 509.39 MB/s read, 148.7 seconds Interval compaction: 32.85 GB write, 687.50 MB/s write, 24.46 GB read, 511.90 MB/s read, 148.7 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 27, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 27, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 34, pending-compaction-bytes-delays: 31, pending-compaction-bytes-stops: 0, total-delays: 58, total-stops: 34, interval: 92 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 4011264 Average: 2.8405 StdDev: 23.94 Min: 0 Median: 1.5208 Max: 7981 Percentiles: P50: 1.52 P75: 1.91 P99: 7.42 P99.9: 143.16 P99.99: 358.12 ------------------------------------------------------ [ 0, 1 ] 655859 16.350% 16.350% ### ( 1, 2 ] 2591692 64.610% 80.961% ############# ( 2, 3 ] 428869 10.692% 91.652% ## ( 3, 4 ] 166757 4.157% 95.810% # ( 4, 6 ] 116024 2.892% 98.702% # ( 6, 10 ] 33744 0.841% 99.543% ( 10, 15 ] 5459 0.136% 99.679% ( 15, 22 ] 862 0.021% 99.701% ( 22, 34 ] 59 0.001% 99.702% ( 34, 51 ] 49 0.001% 99.704% ( 51, 76 ] 122 0.003% 99.707% ( 76, 110 ] 5264 0.131% 99.838% ( 110, 170 ] 4516 0.113% 99.950% ( 170, 250 ] 1026 0.026% 99.976% ( 250, 380 ] 678 0.017% 99.993% ( 380, 580 ] 689 0.017% 100.010% ( 580, 870 ] 294 0.007% 100.017% ( 870, 1300 ] 110 0.003% 100.020% ( 1300, 1900 ] 31 0.001% 100.021% ( 1900, 2900 ] 47 0.001% 100.022% ( 2900, 4400 ] 52 0.001% 100.023% ( 4400, 6600 ] 15 0.000% 100.024% ( 6600, 9900 ] 4 0.000% 100.024% ** Level 1 read latency histogram (micros): Count: 1146533 Average: 5.6311 StdDev: 90.09 Min: 1 Median: 1.7873 Max: 12719 Percentiles: P50: 1.79 P75: 2.74 P99: 9.64 P99.9: 164.62 P99.99: 487.09 ------------------------------------------------------ [ 0, 1 ] 94462 8.239% 8.239% ## ( 1, 2 ] 608167 53.044% 61.283% ########### ( 2, 3 ] 212486 18.533% 79.816% #### ( 3, 4 ] 97293 8.486% 88.302% ## ( 4, 6 ] 99913 8.714% 97.016% ## ( 6, 10 ] 24993 2.180% 99.196% ( 10, 15 ] 5058 0.441% 99.637% ( 15, 22 ] 593 0.052% 99.689% ( 22, 34 ] 61 0.005% 99.694% ( 34, 51 ] 14 0.001% 99.695% ( 51, 76 ] 133 0.012% 99.707% ( 76, 110 ] 1233 0.108% 99.814% ( 110, 170 ] 1077 0.094% 99.908% ( 170, 250 ] 341 0.030% 99.938% ( 250, 380 ] 355 0.031% 99.969% ( 380, 580 ] 447 0.039% 100.008% ( 580, 870 ] 387 0.034% 100.042% ( 870, 1300 ] 237 0.021% 100.063% ( 1300, 1900 ] 129 0.011% 100.074% ( 1900, 2900 ] 162 0.014% 100.088% ( 2900, 4400 ] 243 0.021% 100.109% ( 4400, 6600 ] 87 0.008% 100.117% ( 6600, 9900 ] 29 0.003% 100.119% ( 9900, 14000 ] 3 0.000% 100.119% ** Level 2 read latency histogram (micros): Count: 95906 Average: 2.0230 StdDev: 6.89 Min: 0 Median: 1.3915 Max: 1199 Percentiles: P50: 1.39 P75: 1.79 P99: 5.42 P99.9: 9.78 P99.99: 295.81 ------------------------------------------------------ [ 0, 1 ] 24170 25.202% 25.202% ##### ( 1, 2 ] 60744 63.337% 88.539% ############# ( 2, 3 ] 6436 6.711% 95.250% # ( 3, 4 ] 2507 2.614% 97.864% # ( 4, 6 ] 1536 1.602% 99.465% ( 6, 10 ] 441 0.460% 99.925% ( 10, 15 ] 48 0.050% 99.975% ( 15, 22 ] 8 0.008% 99.983% ( 22, 34 ] 1 0.001% 99.984% ( 34, 51 ] 1 0.001% 99.985% ( 51, 76 ] 1 0.001% 99.986% ( 110, 170 ] 2 0.002% 99.989% ( 250, 380 ] 4 0.004% 99.993% ( 380, 580 ] 3 0.003% 99.996% ( 580, 870 ] 3 0.003% 99.999% ( 870, 1300 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 1373274 Average: 4.2370 StdDev: 59.08 Min: 0 Median: 1.9299 Max: 13598 Percentiles: P50: 1.93 P75: 2.94 P99: 8.82 P99.9: 14.21 P99.99: 19.54 ------------------------------------------------------ [ 0, 1 ] 37786 2.752% 2.752% # ( 1, 2 ] 697740 50.809% 53.560% ########## ( 2, 3 ] 313742 22.846% 76.406% ##### ( 3, 4 ] 143636 10.459% 86.866% ## ( 4, 6 ] 147803 10.763% 97.629% ## ( 6, 10 ] 26703 1.944% 99.573% ( 10, 15 ] 5340 0.389% 99.962% ( 15, 22 ] 598 0.044% 100.005% ( 22, 34 ] 70 0.005% 100.010% ( 34, 51 ] 22 0.002% 100.012% ( 51, 76 ] 57 0.004% 100.016% ( 76, 110 ] 229 0.017% 100.033% ( 110, 170 ] 483 0.035% 100.068% ( 170, 250 ] 342 0.025% 100.093% ( 250, 380 ] 384 0.028% 100.121% ( 380, 580 ] 356 0.026% 100.147% ( 580, 870 ] 282 0.021% 100.167% ( 870, 1300 ] 155 0.011% 100.179% ( 1300, 1900 ] 87 0.006% 100.185% ( 1900, 2900 ] 54 0.004% 100.189% ( 2900, 4400 ] 109 0.008% 100.197% ( 4400, 6600 ] 38 0.003% 100.200% ( 6600, 9900 ] 13 0.001% 100.201% ( 9900, 14000 ] 3 0.000% 100.201% ** Level 4 read latency histogram (micros): Count: 71777 Average: 30.7350 StdDev: 208.52 Min: 0 Median: 1.9925 Max: 7900 Percentiles: P50: 1.99 P75: 3.15 P99: 846.29 P99.9: 3100.50 P99.99: 5107.27 ------------------------------------------------------ [ 0, 1 ] 1270 1.769% 1.769% ( 1, 2 ] 34881 48.596% 50.366% ########## ( 2, 3 ] 16472 22.949% 73.315% ##### ( 3, 4 ] 8238 11.477% 84.792% ## ( 4, 6 ] 6428 8.956% 93.747% ## ( 6, 10 ] 1220 1.700% 95.447% ( 10, 15 ] 382 0.532% 95.979% ( 15, 22 ] 31 0.043% 96.022% ( 22, 34 ] 5 0.007% 96.029% ( 34, 51 ] 3 0.004% 96.034% ( 51, 76 ] 6 0.008% 96.042% ( 76, 110 ] 162 0.226% 96.268% ( 110, 170 ] 366 0.510% 96.778% ( 170, 250 ] 313 0.436% 97.214% ( 250, 380 ] 332 0.463% 97.676% ( 380, 580 ] 481 0.670% 98.346% ( 580, 870 ] 511 0.712% 99.058% ( 870, 1300 ] 326 0.454% 99.512% ( 1300, 1900 ] 177 0.247% 99.759% ( 1900, 2900 ] 92 0.128% 99.887% ( 2900, 4400 ] 69 0.096% 99.983% ( 4400, 6600 ] 15 0.021% 100.004% ( 6600, 9900 ] 5 0.007% 100.011% ** Level 5 read latency histogram (micros): Count: 240 Average: 1127.3458 StdDev: 1305.78 Min: 77 Median: 521.1765 Max: 6980 Percentiles: P50: 521.18 P75: 1690.00 P99: 5984.00 P99.9: 6980.00 P99.99: 6980.00 ------------------------------------------------------ ( 76, 110 ] 26 10.833% 10.833% ## ( 110, 170 ] 33 13.750% 24.583% ### ( 170, 250 ] 20 8.333% 32.917% ## ( 250, 380 ] 29 12.083% 45.000% ## ( 380, 580 ] 17 7.083% 52.083% # ( 580, 870 ] 22 9.167% 61.250% ## ( 870, 1300 ] 20 8.333% 69.583% ## ( 1300, 1900 ] 20 8.333% 77.917% ## ( 1900, 2900 ] 21 8.750% 86.667% ## ( 2900, 4400 ] 26 10.833% 97.500% ## ( 4400, 6600 ] 5 2.083% 99.583% ( 6600, 9900 ] 1 0.417% 100.000% ** DB Stats ** Uptime(secs): 49.2 total, 16.6 interval Cumulative writes: 0 writes, 9000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 8.65 GB, 180.13 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:25.015 H:M:S, 50.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 59.17 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:13.670 H:M:S, 82.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 4 num-running-flushes: 1 2024/07/15-23:57:30 ... thread 0: (1000000,10000000) ops and (324920.0,192281.6) ops/second in (3.077681,52.007047) 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/9 3.50 GB 138.5 9.2 0.0 9.2 18.6 9.5 0.0 2.0 145.6 295.9 64.45 59.67 168 0.384 9529K 13K 0.0 0.0 L1 16/16 1.63 GB 0.0 6.7 5.7 0.9 6.6 5.6 0.2 1.1 218.4 215.0 31.24 28.85 3 10.414 6928K 106K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 4.1 2.0 254.9 254.7 1.48 1.44 2 0.741 383K 206 0.0 0.0 L3 15/0 937.02 MB 0.9 5.8 3.3 2.5 5.8 3.3 1.0 1.8 168.8 167.7 35.19 26.04 23 1.530 6032K 37K 0.0 0.0 L4 168/0 9.40 GB 1.0 3.5 3.3 0.3 3.5 3.3 0.9 1.1 153.9 153.6 23.55 16.73 37 0.637 3585K 3337 0.0 0.0 L5 1092/0 90.00 GB 0.9 0.0 0.0 0.0 0.0 0.0 4.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1307/25 105.45 GB 0.0 25.5 12.5 13.1 34.8 21.8 10.7 3.7 167.7 228.9 155.92 132.73 233 0.669 26M 161K 0.0 0.0 Int 0/0 0.00 KB 0.0 25.5 12.5 13.1 34.8 21.8 10.6 3.7 167.7 228.9 155.92 132.73 233 0.669 26M 161K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 25.5 12.5 13.1 25.4 12.3 0.0 0.0 205.0 203.7 127.54 108.02 95 1.343 26M 161K 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 341.9 28.38 24.71 138 0.206 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.3 total, 52.0 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: 34.85 GB write, 682.97 MB/s write, 25.54 GB read, 500.48 MB/s read, 155.9 seconds Interval compaction: 34.85 GB write, 686.15 MB/s write, 25.54 GB read, 502.80 MB/s read, 155.9 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 27, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 27, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 38, pending-compaction-bytes-delays: 31, pending-compaction-bytes-stops: 0, total-delays: 58, total-stops: 38, interval: 96 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 4319813 Average: 2.8070 StdDev: 23.23 Min: 0 Median: 1.5241 Max: 7981 Percentiles: P50: 1.52 P75: 1.91 P99: 7.27 P99.9: 138.19 P99.99: 330.26 ------------------------------------------------------ [ 0, 1 ] 692296 16.026% 16.026% ### ( 1, 2 ] 2800272 64.824% 80.850% ############# ( 2, 3 ] 469242 10.863% 91.713% ## ( 3, 4 ] 178953 4.143% 95.855% # ( 4, 6 ] 124402 2.880% 98.735% # ( 6, 10 ] 35934 0.832% 99.567% ( 10, 15 ] 5827 0.135% 99.702% ( 15, 22 ] 894 0.021% 99.722% ( 22, 34 ] 63 0.001% 99.724% ( 34, 51 ] 51 0.001% 99.725% ( 51, 76 ] 124 0.003% 99.728% ( 76, 110 ] 5290 0.122% 99.850% ( 110, 170 ] 4566 0.106% 99.956% ( 170, 250 ] 1041 0.024% 99.980% ( 250, 380 ] 690 0.016% 99.996% ( 380, 580 ] 705 0.016% 100.012% ( 580, 870 ] 299 0.007% 100.019% ( 870, 1300 ] 117 0.003% 100.022% ( 1300, 1900 ] 35 0.001% 100.023% ( 1900, 2900 ] 48 0.001% 100.024% ( 2900, 4400 ] 52 0.001% 100.025% ( 4400, 6600 ] 15 0.000% 100.026% ( 6600, 9900 ] 4 0.000% 100.026% ** Level 1 read latency histogram (micros): Count: 1236398 Average: 5.4162 StdDev: 86.81 Min: 1 Median: 1.7668 Max: 12719 Percentiles: P50: 1.77 P75: 2.68 P99: 9.57 P99.9: 163.88 P99.99: 488.81 ------------------------------------------------------ [ 0, 1 ] 105393 8.524% 8.524% ## ( 1, 2 ] 668760 54.089% 62.614% ########### ( 2, 3 ] 224561 18.163% 80.776% #### ( 3, 4 ] 99847 8.076% 88.852% ## ( 4, 6 ] 101829 8.236% 97.088% ## ( 6, 10 ] 26456 2.140% 99.227% ( 10, 15 ] 5178 0.419% 99.646% ( 15, 22 ] 604 0.049% 99.695% ( 22, 34 ] 63 0.005% 99.700% ( 34, 51 ] 16 0.001% 99.701% ( 51, 76 ] 137 0.011% 99.713% ( 76, 110 ] 1302 0.105% 99.818% ( 110, 170 ] 1131 0.091% 99.909% ( 170, 250 ] 369 0.030% 99.939% ( 250, 380 ] 377 0.030% 99.970% ( 380, 580 ] 462 0.037% 100.007% ( 580, 870 ] 391 0.032% 100.039% ( 870, 1300 ] 239 0.019% 100.058% ( 1300, 1900 ] 129 0.010% 100.068% ( 1900, 2900 ] 162 0.013% 100.082% ( 2900, 4400 ] 243 0.020% 100.101% ( 4400, 6600 ] 87 0.007% 100.108% ( 6600, 9900 ] 29 0.002% 100.111% ( 9900, 14000 ] 3 0.000% 100.111% ** Level 2 read latency histogram (micros): Count: 95906 Average: 2.0230 StdDev: 6.89 Min: 0 Median: 1.3915 Max: 1199 Percentiles: P50: 1.39 P75: 1.79 P99: 5.42 P99.9: 9.78 P99.99: 295.81 ------------------------------------------------------ [ 0, 1 ] 24170 25.202% 25.202% ##### ( 1, 2 ] 60744 63.337% 88.539% ############# ( 2, 3 ] 6436 6.711% 95.250% # ( 3, 4 ] 2507 2.614% 97.864% # ( 4, 6 ] 1536 1.602% 99.465% ( 6, 10 ] 441 0.460% 99.925% ( 10, 15 ] 48 0.050% 99.975% ( 15, 22 ] 8 0.008% 99.983% ( 22, 34 ] 1 0.001% 99.984% ( 34, 51 ] 1 0.001% 99.985% ( 51, 76 ] 1 0.001% 99.986% ( 110, 170 ] 2 0.002% 99.989% ( 250, 380 ] 4 0.004% 99.993% ( 380, 580 ] 3 0.003% 99.996% ( 580, 870 ] 3 0.003% 99.999% ( 870, 1300 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 1385008 Average: 4.2223 StdDev: 58.83 Min: 0 Median: 1.9276 Max: 13598 Percentiles: P50: 1.93 P75: 2.93 P99: 8.81 P99.9: 14.20 P99.99: 19.50 ------------------------------------------------------ [ 0, 1 ] 38099 2.751% 2.751% # ( 1, 2 ] 705484 50.937% 53.688% ########## ( 2, 3 ] 316011 22.817% 76.505% ##### ( 3, 4 ] 144371 10.424% 86.928% ## ( 4, 6 ] 148388 10.714% 97.642% ## ( 6, 10 ] 26771 1.933% 99.575% ( 10, 15 ] 5359 0.387% 99.962% ( 15, 22 ] 601 0.043% 100.005% ( 22, 34 ] 70 0.005% 100.011% ( 34, 51 ] 22 0.002% 100.012% ( 51, 76 ] 57 0.004% 100.016% ( 76, 110 ] 229 0.017% 100.033% ( 110, 170 ] 483 0.035% 100.068% ( 170, 250 ] 342 0.025% 100.092% ( 250, 380 ] 384 0.028% 100.120% ( 380, 580 ] 356 0.026% 100.146% ( 580, 870 ] 282 0.020% 100.166% ( 870, 1300 ] 155 0.011% 100.177% ( 1300, 1900 ] 87 0.006% 100.184% ( 1900, 2900 ] 54 0.004% 100.188% ( 2900, 4400 ] 109 0.008% 100.195% ( 4400, 6600 ] 38 0.003% 100.198% ( 6600, 9900 ] 13 0.001% 100.199% ( 9900, 14000 ] 3 0.000% 100.199% ** Level 4 read latency histogram (micros): Count: 72306 Average: 30.5687 StdDev: 207.81 Min: 0 Median: 1.9894 Max: 7900 Percentiles: P50: 1.99 P75: 3.14 P99: 843.91 P99.9: 3089.00 P99.99: 5099.51 ------------------------------------------------------ [ 0, 1 ] 1308 1.809% 1.809% ( 1, 2 ] 35220 48.710% 50.519% ########## ( 2, 3 ] 16557 22.899% 73.417% ##### ( 3, 4 ] 8265 11.431% 84.848% ## ( 4, 6 ] 6450 8.920% 93.768% ## ( 6, 10 ] 1230 1.701% 95.469% ( 10, 15 ] 382 0.528% 95.998% ( 15, 22 ] 31 0.043% 96.040% ( 22, 34 ] 5 0.007% 96.047% ( 34, 51 ] 3 0.004% 96.052% ( 51, 76 ] 6 0.008% 96.060% ( 76, 110 ] 162 0.224% 96.284% ( 110, 170 ] 367 0.508% 96.791% ( 170, 250 ] 317 0.438% 97.230% ( 250, 380 ] 332 0.459% 97.689% ( 380, 580 ] 482 0.667% 98.356% ( 580, 870 ] 512 0.708% 99.064% ( 870, 1300 ] 327 0.452% 99.516% ( 1300, 1900 ] 177 0.245% 99.761% ( 1900, 2900 ] 92 0.127% 99.888% ( 2900, 4400 ] 69 0.095% 99.983% ( 4400, 6600 ] 15 0.021% 100.004% ( 6600, 9900 ] 5 0.007% 100.011% ** Level 5 read latency histogram (micros): Count: 260 Average: 1092.4038 StdDev: 1279.38 Min: 77 Median: 491.1111 Max: 6980 Percentiles: P50: 491.11 P75: 1614.29 P99: 5896.00 P99.9: 6980.00 P99.99: 6980.00 ------------------------------------------------------ ( 76, 110 ] 31 11.923% 11.923% ## ( 110, 170 ] 37 14.231% 26.154% ### ( 170, 250 ] 22 8.462% 34.615% ## ( 250, 380 ] 30 11.538% 46.154% ## ( 380, 580 ] 18 6.923% 53.077% # ( 580, 870 ] 22 8.462% 61.538% ## ( 870, 1300 ] 24 9.231% 70.769% ## ( 1300, 1900 ] 21 8.077% 78.846% ## ( 1900, 2900 ] 23 8.846% 87.692% ## ( 2900, 4400 ] 26 10.000% 97.692% ## ( 4400, 6600 ] 5 1.923% 99.615% ( 6600, 9900 ] 1 0.385% 100.000% ** DB Stats ** Uptime(secs): 52.3 total, 3.1 interval Cumulative writes: 0 writes, 10M keys, 0 commit groups, 0.0 writes per commit group, ingest: 9.61 GB, 188.36 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:25.514 H:M:S, 48.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 319.80 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.498 H:M:S, 16.2 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.559 micros/op 179890 ops/sec 60.070 seconds 10805999 operations; 174.3 MB/s Microseconds per write: Count: 10805999 Average: 5.5587 StdDev: 292.20 Min: 0 Median: 1.7185 Max: 263815 Percentiles: P50: 1.72 P75: 2.64 P99: 7.33 P99.9: 1151.24 P99.99: 2749.58 ------------------------------------------------------ [ 0, 1 ] 1580750 14.628% 14.628% ### ( 1, 2 ] 5319712 49.229% 63.858% ########## ( 2, 3 ] 1879939 17.397% 81.255% ### ( 3, 4 ] 1412607 13.072% 94.327% ### ( 4, 6 ] 479782 4.440% 98.767% # ( 6, 10 ] 75747 0.701% 99.468% ( 10, 15 ] 17775 0.164% 99.633% ( 15, 22 ] 6925 0.064% 99.697% ( 22, 34 ] 1987 0.018% 99.715% ( 34, 51 ] 187 0.002% 99.717% ( 51, 76 ] 23 0.000% 99.717% ( 76, 110 ] 7747 0.072% 99.789% ( 110, 170 ] 2841 0.026% 99.815% ( 170, 250 ] 284 0.003% 99.818% ( 250, 380 ] 60 0.001% 99.818% ( 380, 580 ] 32 0.000% 99.819% ( 580, 870 ] 23 0.000% 99.819% ( 870, 1300 ] 13412 0.124% 99.943% ( 1300, 1900 ] 89 0.001% 99.944% ( 1900, 2900 ] 5881 0.054% 99.998% ( 2900, 4400 ] 118 0.001% 99.999% ( 4400, 6600 ] 33 0.000% 100.000% ( 6600, 9900 ] 17 0.000% 100.000% ( 9900, 14000 ] 2 0.000% 100.000% ( 14000, 22000 ] 4 0.000% 100.000% ( 22000, 33000 ] 3 0.000% 100.000% ( 170000, 250000 ] 17 0.000% 100.000% ( 250000, 380000 ] 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 : 219520 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 : 10805999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 11151790968 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 : 542 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 31452225 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 : 33475193416 rocksdb.compact.write.bytes COUNT : 33265366508 rocksdb.flush.write.bytes COUNT : 11097433584 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 : 61 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 : 209 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 : 11008096256 rocksdb.memtable.garbage.bytes.at.flush COUNT : 4415488 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 : 33577476566 rocksdb.non.last.level.read.count COUNT : 8114833 rocksdb.block.checksum.compute.count COUNT : 8113810 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.354235 P95 : 3.747060 P99 : 5.914353 P100 : 263813.000000 COUNT : 10805999 SUM : 55212096 rocksdb.compaction.times.micros P50 : 971714.285714 P95 : 3390000.000000 P99 : 14080000.000000 P100 : 20967711.000000 COUNT : 99 SUM : 132038298 rocksdb.compaction.times.cpu_micros P50 : 847916.666667 P95 : 3267500.000000 P99 : 14080000.000000 P100 : 18913845.000000 COUNT : 99 SUM : 112449942 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.882353 P95 : 1261.031250 P99 : 5522.000000 P100 : 7223.000000 COUNT : 149 SUM : 118831 rocksdb.compaction.outfile.sync.micros P50 : 937.187500 P95 : 98557.692308 P99 : 213500.000000 P100 : 229199.000000 COUNT : 365 SUM : 5651137 rocksdb.wal.file.sync.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.manifest.file.sync.micros P50 : 96.162791 P95 : 1300.000000 P99 : 2633.333333 P100 : 4384.000000 COUNT : 280 SUM : 71359 rocksdb.table.open.io.micros P50 : 1370.588235 P95 : 6774.705882 P99 : 12187.800000 P100 : 31157.000000 COUNT : 542 SUM : 1123426 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.679431 P95 : 8.003467 P99 : 12.260307 P100 : 15004.000000 COUNT : 8112603 SUM : 47758808 rocksdb.read.block.get.micros P50 : 470.598291 P95 : 3403.773585 P99 : 5522.000000 P100 : 15185.000000 COUNT : 1084 SUM : 922603 rocksdb.write.raw.block.micros P50 : 0.513178 P95 : 0.975037 P99 : 2.787591 P100 : 21857.000000 COUNT : 10746380 SUM : 19967859 rocksdb.numfiles.in.singlecompaction P50 : 2.852941 P95 : 5.050000 P99 : 17.135000 P100 : 22.000000 COUNT : 139 SUM : 481 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.554792 P95 : 1178.078427 P99 : 2589.403138 P100 : 263624.000000 COUNT : 198134 SUM : 31462545 rocksdb.sst.read.micros P50 : 1.621205 P95 : 4.767863 P99 : 8.866239 P100 : 13598.000000 COUNT : 8115585 SUM : 30835539 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 : 10805999 SUM : 11151790968 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 : 210377.358491 P95 : 349552.631579 P99 : 523450.000000 P100 : 610228.000000 COUNT : 149 SUM : 30924677 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 : 350 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