[2024-12-13 12:17:33.209845] Starting SPDK v25.01-pre git sha1 e01cb43b8 / DPDK 22.11.4 initialization... [2024-12-13 12:17:33.210115] [ DPDK EAL parameters: rocksdb --no-shconf -c 0x1 --huge-unlink --no-telemetry --log-level=lib.eal:6 --log-level=lib.cryptodev:5 --log-level=lib.power:5 --log-level=user1:6 --base-virtaddr=0x200000000000 --match-allocations --file-prefix=spdk_pid182153 ] Set seed to 1734088653203171 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-12-13 12:17:33.311737] app.c: 919:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-12-13 12:17:33.334970] app.c: 612:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-12-13 12:17:33.335014] app.c: 613:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 182153' to capture a snapshot of events at runtime. [2024-12-13 12:17:33.335025] app.c: 618:app_setup_trace: *NOTICE*: 'spdk_trace' without parameters will also work if this is the only [2024-12-13 12:17:33.335036] app.c: 619:app_setup_trace: *NOTICE*: SPDK application currently running. [2024-12-13 12:17:33.335043] app.c: 620:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid182153 for offline analysis/debug. [2024-12-13 12:17:33.335595] reactor.c: 995:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Fri Dec 13 12:17:37 2024 CPU: 96 * Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz CPUCache: 36608 KB 2024/12/13-12:17:40 ... thread 0: (1000000,1000000) ops and (336028.4,336028.4) ops/second in (2.975939,2.975939) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 10/9 693.00 MB 12.6 0.0 0.0 0.0 0.9 0.9 0.0 1.0 0.0 349.8 2.52 2.28 12 0.210 0 0 0.0 0.0 L2 3/2 236.96 MB 0.5 0.3 0.2 0.2 0.3 0.2 0.0 1.8 246.3 246.1 1.41 1.36 2 0.707 353K 207 0.0 0.0 L3 10/0 881.90 MB 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 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/11 97.00 GB 0.0 0.3 0.2 0.2 1.2 1.0 0.0 1.4 88.5 312.6 3.94 3.64 14 0.281 353K 207 0.0 0.0 Int 0/0 0.00 KB 0.0 0.3 0.2 0.2 1.2 1.0 0.0 1.4 88.5 312.6 3.94 3.64 14 0.281 353K 207 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 0.3 0.2 0.2 0.3 0.2 0.0 0.0 246.3 246.1 1.41 1.36 2 0.707 353K 207 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.8 2.52 2.28 12 0.210 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 3.2 total, 3.0 interval Flush(GB): cumulative 0.861, interval 0.861 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 1.20 GB write, 385.25 MB/s write, 0.34 GB read, 109.10 MB/s read, 3.9 seconds Interval compaction: 1.20 GB write, 413.11 MB/s write, 0.34 GB read, 116.99 MB/s read, 3.9 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 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: 143834 Average: 2.0776 StdDev: 15.76 Min: 0 Median: 1.3853 Max: 3716 Percentiles: P50: 1.39 P75: 1.80 P99: 5.41 P99.9: 9.42 P99.99: 23.48 ------------------------------------------------------ [ 0, 1 ] 38603 26.839% 26.839% ##### ( 1, 2 ] 86471 60.119% 86.957% ############ ( 2, 3 ] 10931 7.600% 94.557% ## ( 3, 4 ] 4353 3.026% 97.583% # ( 4, 6 ] 2889 2.009% 99.592% ( 6, 10 ] 522 0.363% 99.955% ( 10, 15 ] 44 0.031% 99.985% ( 15, 22 ] 9 0.006% 99.992% ( 22, 34 ] 5 0.003% 99.995% ( 34, 51 ] 1 0.001% 99.996% ( 51, 76 ] 2 0.001% 99.997% ( 110, 170 ] 7 0.005% 100.002% ( 170, 250 ] 3 0.002% 100.004% ( 250, 380 ] 7 0.005% 100.009% ( 380, 580 ] 1 0.001% 100.010% ( 580, 870 ] 1 0.001% 100.010% ( 1300, 1900 ] 2 0.001% 100.012% ( 1900, 2900 ] 1 0.001% 100.013% ( 2900, 4400 ] 2 0.001% 100.014% ** Level 2 read latency histogram (micros): Count: 82141 Average: 2.1891 StdDev: 12.64 Min: 1 Median: 1.3896 Max: 2423 Percentiles: P50: 1.39 P75: 1.80 P99: 5.73 P99.9: 35.68 P99.99: 374.43 ------------------------------------------------------ [ 0, 1 ] 21779 26.514% 26.514% ##### ( 1, 2 ] 49522 60.289% 86.803% ############ ( 2, 3 ] 6088 7.412% 94.215% # ( 3, 4 ] 2367 2.882% 97.096% # ( 4, 6 ] 1805 2.197% 99.294% ( 6, 10 ] 405 0.493% 99.787% ( 10, 15 ] 71 0.086% 99.873% ( 15, 22 ] 18 0.022% 99.895% ( 22, 34 ] 2 0.002% 99.898% ( 34, 51 ] 29 0.035% 99.933% ( 51, 76 ] 2 0.002% 99.935% ( 110, 170 ] 28 0.034% 99.970% ( 170, 250 ] 13 0.016% 99.985% ( 250, 380 ] 5 0.006% 99.991% ( 380, 580 ] 2 0.002% 99.994% ( 580, 870 ] 4 0.005% 99.999% ( 1300, 1900 ] 1 0.001% 100.000% ( 1900, 2900 ] 1 0.001% 100.001% ** Level 3 read latency histogram (micros): Count: 50 Average: 1499.3600 StdDev: 1205.39 Min: 168 Median: 977.5000 Max: 5100 Percentiles: P50: 977.50 P75: 2400.00 P99: 5100.00 P99.9: 5100.00 P99.99: 5100.00 ------------------------------------------------------ ( 110, 170 ] 2 4.000% 4.000% # ( 170, 250 ] 1 2.000% 6.000% ( 250, 380 ] 2 4.000% 10.000% # ( 380, 580 ] 10 20.000% 30.000% #### ( 580, 870 ] 9 18.000% 48.000% #### ( 870, 1300 ] 4 8.000% 56.000% ## ( 1300, 1900 ] 5 10.000% 66.000% ## ( 1900, 2900 ] 9 18.000% 84.000% #### ( 2900, 4400 ] 7 14.000% 98.000% ### ( 4400, 6600 ] 1 2.000% 100.000% ** Level 4 read latency histogram (micros): Count: 25 Average: 1557.6800 StdDev: 1270.58 Min: 283 Median: 1192.5000 Max: 4474 Percentiles: P50: 1192.50 P75: 2337.50 P99: 4474.00 P99.9: 4474.00 P99.99: 4474.00 ------------------------------------------------------ ( 250, 380 ] 3 12.000% 12.000% ## ( 380, 580 ] 6 24.000% 36.000% ##### ( 580, 870 ] 2 8.000% 44.000% ## ( 870, 1300 ] 2 8.000% 52.000% ## ( 1300, 1900 ] 4 16.000% 68.000% ### ( 1900, 2900 ] 4 16.000% 84.000% ### ( 2900, 4400 ] 3 12.000% 96.000% ## ( 4400, 6600 ] 1 4.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, 308.21 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:0.395 H:M:S, 12.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 330.42 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.395 H:M:S, 13.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/12/13-12:17:43 ... thread 0: (1000000,2000000) ops and (325982.6,330929.3) ops/second in (3.067648,6.043587) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 13/11 1.35 GB 44.1 0.6 0.0 0.6 2.4 1.8 0.0 1.3 75.0 324.9 7.56 6.95 28 0.270 575K 678 0.0 0.0 L1 4/4 314.57 MB 0.0 0.3 0.3 0.0 0.3 0.3 0.2 1.0 232.7 232.4 1.35 1.31 1 1.354 319K 422 0.0 0.0 L2 1/0 49.92 MB 0.5 0.3 0.2 0.2 0.3 0.2 0.0 1.8 246.3 246.1 1.41 1.36 2 0.707 353K 207 0.0 0.0 L3 17/0 900.72 MB 0.9 0.2 0.2 0.0 0.2 0.2 0.0 1.0 221.0 221.0 0.85 0.77 1 0.846 189K 0 0.0 0.0 L4 173/0 9.70 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.0 1.0 140.4 140.4 1.20 0.84 1 1.198 170K 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/15 97.98 GB 0.0 1.5 0.8 0.7 3.4 2.7 0.2 1.8 128.1 280.8 12.37 11.24 33 0.375 1610K 1307 0.0 0.0 Int 0/0 0.00 KB 0.0 1.5 0.8 0.7 3.4 2.7 0.2 1.8 128.1 280.8 12.37 11.24 33 0.375 1610K 1307 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.5 0.8 0.7 1.5 0.8 0.0 0.0 227.7 227.5 6.96 6.39 7 0.995 1610K 1307 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 349.4 5.41 4.85 26 0.208 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.3 total, 6.0 interval Flush(GB): cumulative 1.846, interval 1.846 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.39 GB write, 554.93 MB/s write, 1.55 GB read, 253.27 MB/s read, 12.4 seconds Interval compaction: 3.39 GB write, 574.70 MB/s write, 1.55 GB read, 262.30 MB/s read, 12.4 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 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: 385168 Average: 2.1769 StdDev: 14.39 Min: 0 Median: 1.4671 Max: 3716 Percentiles: P50: 1.47 P75: 1.86 P99: 5.54 P99.9: 9.66 P99.99: 14.41 ------------------------------------------------------ [ 0, 1 ] 78313 20.332% 20.332% #### ( 1, 2 ] 244630 63.513% 83.845% ############# ( 2, 3 ] 38578 10.016% 93.861% ## ( 3, 4 ] 13240 3.437% 97.298% # ( 4, 6 ] 8487 2.203% 99.502% ( 6, 10 ] 1677 0.435% 99.937% ( 10, 15 ] 232 0.060% 99.997% ( 15, 22 ] 23 0.006% 100.003% ( 22, 34 ] 10 0.003% 100.006% ( 34, 51 ] 3 0.001% 100.006% ( 51, 76 ] 3 0.001% 100.007% ( 110, 170 ] 17 0.004% 100.012% ( 170, 250 ] 8 0.002% 100.014% ( 250, 380 ] 11 0.003% 100.017% ( 380, 580 ] 3 0.001% 100.017% ( 580, 870 ] 4 0.001% 100.018% ( 870, 1300 ] 2 0.001% 100.019% ( 1300, 1900 ] 5 0.001% 100.020% ( 1900, 2900 ] 3 0.001% 100.021% ( 2900, 4400 ] 4 0.001% 100.022% ** Level 1 read latency histogram (micros): Count: 39482 Average: 2.1508 StdDev: 8.67 Min: 1 Median: 1.4657 Max: 1174 Percentiles: P50: 1.47 P75: 1.85 P99: 5.50 P99.9: 9.65 P99.99: 390.36 ------------------------------------------------------ [ 0, 1 ] 7851 19.885% 19.885% #### ( 1, 2 ] 25530 64.662% 84.547% ############# ( 2, 3 ] 3897 9.870% 94.418% ## ( 3, 4 ] 1221 3.093% 97.510% # ( 4, 6 ] 782 1.981% 99.491% ( 6, 10 ] 177 0.448% 99.939% ( 10, 15 ] 17 0.043% 99.982% ( 34, 51 ] 1 0.003% 99.985% ( 250, 380 ] 2 0.005% 99.990% ( 380, 580 ] 1 0.003% 99.992% ( 580, 870 ] 2 0.005% 99.997% ( 870, 1300 ] 1 0.003% 100.000% ** Level 2 read latency histogram (micros): Count: 87984 Average: 2.2057 StdDev: 12.22 Min: 1 Median: 1.4103 Max: 2423 Percentiles: P50: 1.41 P75: 1.82 P99: 5.75 P99.9: 21.66 P99.99: 359.24 ------------------------------------------------------ [ 0, 1 ] 22159 25.185% 25.185% ##### ( 1, 2 ] 53212 60.479% 85.664% ############ ( 2, 3 ] 7243 8.232% 93.897% ## ( 3, 4 ] 2651 3.013% 96.910% # ( 4, 6 ] 2096 2.382% 99.292% ( 6, 10 ] 440 0.500% 99.792% ( 10, 15 ] 76 0.086% 99.878% ( 15, 22 ] 20 0.023% 99.901% ( 22, 34 ] 2 0.002% 99.903% ( 34, 51 ] 29 0.033% 99.936% ( 51, 76 ] 2 0.002% 99.939% ( 110, 170 ] 28 0.032% 99.970% ( 170, 250 ] 13 0.015% 99.985% ( 250, 380 ] 5 0.006% 99.991% ( 380, 580 ] 2 0.002% 99.993% ( 580, 870 ] 4 0.005% 99.998% ( 1300, 1900 ] 1 0.001% 99.999% ( 1900, 2900 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 42802 Average: 3.9313 StdDev: 65.91 Min: 1 Median: 1.5189 Max: 5100 Percentiles: P50: 1.52 P75: 1.90 P99: 5.85 P99.9: 456.33 P99.99: 3697.10 ------------------------------------------------------ [ 0, 1 ] 6736 15.738% 15.738% ### ( 1, 2 ] 28261 66.027% 81.765% ############# ( 2, 3 ] 5260 12.289% 94.054% ## ( 3, 4 ] 1266 2.958% 97.012% # ( 4, 6 ] 919 2.147% 99.159% ( 6, 10 ] 258 0.603% 99.762% ( 10, 15 ] 34 0.079% 99.841% ( 15, 22 ] 13 0.030% 99.872% ( 22, 34 ] 2 0.005% 99.876% ( 110, 170 ] 3 0.007% 99.883% ( 170, 250 ] 1 0.002% 99.886% ( 250, 380 ] 2 0.005% 99.890% ( 380, 580 ] 11 0.026% 99.916% ( 580, 870 ] 9 0.021% 99.937% ( 870, 1300 ] 5 0.012% 99.949% ( 1300, 1900 ] 5 0.012% 99.960% ( 1900, 2900 ] 9 0.021% 99.981% ( 2900, 4400 ] 7 0.016% 99.998% ( 4400, 6600 ] 1 0.002% 100.000% ** Level 4 read latency histogram (micros): Count: 310 Average: 133.5806 StdDev: 557.22 Min: 0 Median: 1.6271 Max: 4474 Percentiles: P50: 1.63 P75: 5.90 P99: 3350.00 P99.9: 4474.00 P99.99: 4474.00 ------------------------------------------------------ [ 0, 1 ] 81 26.129% 26.129% ##### ( 1, 2 ] 118 38.065% 64.194% ######## ( 2, 3 ] 21 6.774% 70.968% # ( 3, 4 ] 3 0.968% 71.935% ( 4, 6 ] 10 3.226% 75.161% # ( 6, 10 ] 34 10.968% 86.129% ## ( 10, 15 ] 11 3.548% 89.677% # ( 15, 22 ] 2 0.645% 90.323% ( 51, 76 ] 1 0.323% 90.645% ( 170, 250 ] 2 0.645% 91.290% ( 250, 380 ] 3 0.968% 92.258% ( 380, 580 ] 7 2.258% 94.516% ( 580, 870 ] 3 0.968% 95.484% ( 870, 1300 ] 2 0.645% 96.129% ( 1300, 1900 ] 4 1.290% 97.419% ( 1900, 2900 ] 4 1.290% 98.710% ( 2900, 4400 ] 3 0.968% 99.677% ( 4400, 6600 ] 1 0.323% 100.000% ** DB Stats ** Uptime(secs): 6.3 total, 3.1 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 314.39 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.841 H:M:S, 13.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 320.82 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.446 H:M:S, 14.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/13-12:17:46 ... thread 0: (1000000,3000000) ops and (357946.1,339470.0) ops/second in (2.793717,8.837304) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 13/8 1.54 GB 100.7 1.0 0.0 1.0 3.8 2.7 0.0 1.4 89.5 320.9 11.97 11.03 43 0.278 1087K 1197 0.0 0.0 L1 5/0 487.84 MB 48.8 1.3 1.0 0.3 1.3 1.0 0.2 1.3 229.1 228.3 5.77 5.60 2 2.886 1342K 4594 0.0 0.0 L2 1/0 49.92 MB 0.5 0.3 0.2 0.2 0.3 0.2 0.5 1.8 246.3 246.1 1.41 1.36 2 0.707 353K 207 0.0 0.0 L3 13/0 722.89 MB 0.7 0.2 0.2 0.0 0.2 0.2 0.5 1.0 221.0 221.0 0.85 0.77 1 0.846 189K 0 0.0 0.0 L4 173/0 9.70 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.7 1.0 140.4 140.4 1.20 0.84 1 1.198 170K 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 1253/8 98.84 GB 0.0 3.0 1.5 1.5 5.7 4.2 2.5 2.1 146.1 276.5 21.20 19.61 49 0.433 3144K 5998 0.0 0.0 Int 0/0 0.00 KB 0.0 3.0 1.5 1.5 5.7 4.2 2.5 2.1 146.1 276.5 21.20 19.61 49 0.433 3144K 5998 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 3.0 1.5 1.5 3.0 1.5 0.0 0.0 232.5 232.1 13.32 12.55 10 1.332 3144K 5998 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 351.6 7.88 7.06 39 0.202 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 9.1 total, 8.8 interval Flush(GB): cumulative 2.707, interval 2.707 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 5.73 GB write, 647.49 MB/s write, 3.02 GB read, 342.04 MB/s read, 21.2 seconds Interval compaction: 5.73 GB write, 663.26 MB/s write, 3.02 GB read, 350.37 MB/s read, 21.2 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 11, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 11, interval: 11 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 673490 Average: 2.1472 StdDev: 12.54 Min: 0 Median: 1.4694 Max: 3716 Percentiles: P50: 1.47 P75: 1.85 P99: 5.41 P99.9: 9.57 P99.99: 14.43 ------------------------------------------------------ [ 0, 1 ] 131065 19.461% 19.461% #### ( 1, 2 ] 438178 65.061% 84.521% ############# ( 2, 3 ] 66996 9.948% 94.469% ## ( 3, 4 ] 21449 3.185% 97.654% # ( 4, 6 ] 12840 1.906% 99.560% ( 6, 10 ] 2562 0.380% 99.941% ( 10, 15 ] 377 0.056% 99.997% ( 15, 22 ] 34 0.005% 100.002% ( 22, 34 ] 13 0.002% 100.004% ( 34, 51 ] 6 0.001% 100.004% ( 51, 76 ] 7 0.001% 100.005% ( 110, 170 ] 22 0.003% 100.009% ( 170, 250 ] 14 0.002% 100.011% ( 250, 380 ] 18 0.003% 100.014% ( 380, 580 ] 5 0.001% 100.014% ( 580, 870 ] 9 0.001% 100.016% ( 870, 1300 ] 3 0.000% 100.016% ( 1300, 1900 ] 7 0.001% 100.017% ( 1900, 2900 ] 4 0.001% 100.018% ( 2900, 4400 ] 5 0.001% 100.018% ** Level 1 read latency histogram (micros): Count: 79927 Average: 2.2494 StdDev: 12.82 Min: 1 Median: 1.4819 Max: 1676 Percentiles: P50: 1.48 P75: 1.86 P99: 5.35 P99.9: 9.63 P99.99: 653.03 ------------------------------------------------------ [ 0, 1 ] 14172 17.731% 17.731% #### ( 1, 2 ] 53520 66.961% 84.692% ############# ( 2, 3 ] 8115 10.153% 94.845% ## ( 3, 4 ] 2366 2.960% 97.805% # ( 4, 6 ] 1416 1.772% 99.577% ( 6, 10 ] 284 0.355% 99.932% ( 10, 15 ] 25 0.031% 99.964% ( 15, 22 ] 1 0.001% 99.965% ( 22, 34 ] 2 0.003% 99.967% ( 34, 51 ] 1 0.001% 99.969% ( 51, 76 ] 2 0.003% 99.971% ( 250, 380 ] 11 0.014% 99.985% ( 380, 580 ] 3 0.004% 99.989% ( 580, 870 ] 4 0.005% 99.994% ( 870, 1300 ] 3 0.004% 99.997% ( 1300, 1900 ] 2 0.003% 100.000% ** Level 2 read latency histogram (micros): Count: 87984 Average: 2.2057 StdDev: 12.22 Min: 1 Median: 1.4103 Max: 2423 Percentiles: P50: 1.41 P75: 1.82 P99: 5.75 P99.9: 21.66 P99.99: 359.24 ------------------------------------------------------ [ 0, 1 ] 22159 25.185% 25.185% ##### ( 1, 2 ] 53212 60.479% 85.664% ############ ( 2, 3 ] 7243 8.232% 93.897% ## ( 3, 4 ] 2651 3.013% 96.910% # ( 4, 6 ] 2096 2.382% 99.292% ( 6, 10 ] 440 0.500% 99.792% ( 10, 15 ] 76 0.086% 99.878% ( 15, 22 ] 20 0.023% 99.901% ( 22, 34 ] 2 0.002% 99.903% ( 34, 51 ] 29 0.033% 99.936% ( 51, 76 ] 2 0.002% 99.939% ( 110, 170 ] 28 0.032% 99.970% ( 170, 250 ] 13 0.015% 99.985% ( 250, 380 ] 5 0.006% 99.991% ( 380, 580 ] 2 0.002% 99.993% ( 580, 870 ] 4 0.005% 99.998% ( 1300, 1900 ] 1 0.001% 99.999% ( 1900, 2900 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 42802 Average: 3.9313 StdDev: 65.91 Min: 1 Median: 1.5189 Max: 5100 Percentiles: P50: 1.52 P75: 1.90 P99: 5.85 P99.9: 456.33 P99.99: 3697.10 ------------------------------------------------------ [ 0, 1 ] 6736 15.738% 15.738% ### ( 1, 2 ] 28261 66.027% 81.765% ############# ( 2, 3 ] 5260 12.289% 94.054% ## ( 3, 4 ] 1266 2.958% 97.012% # ( 4, 6 ] 919 2.147% 99.159% ( 6, 10 ] 258 0.603% 99.762% ( 10, 15 ] 34 0.079% 99.841% ( 15, 22 ] 13 0.030% 99.872% ( 22, 34 ] 2 0.005% 99.876% ( 110, 170 ] 3 0.007% 99.883% ( 170, 250 ] 1 0.002% 99.886% ( 250, 380 ] 2 0.005% 99.890% ( 380, 580 ] 11 0.026% 99.916% ( 580, 870 ] 9 0.021% 99.937% ( 870, 1300 ] 5 0.012% 99.949% ( 1300, 1900 ] 5 0.012% 99.960% ( 1900, 2900 ] 9 0.021% 99.981% ( 2900, 4400 ] 7 0.016% 99.998% ( 4400, 6600 ] 1 0.002% 100.000% ** Level 4 read latency histogram (micros): Count: 310 Average: 133.5806 StdDev: 557.22 Min: 0 Median: 1.6271 Max: 4474 Percentiles: P50: 1.63 P75: 5.90 P99: 3350.00 P99.9: 4474.00 P99.99: 4474.00 ------------------------------------------------------ [ 0, 1 ] 81 26.129% 26.129% ##### ( 1, 2 ] 118 38.065% 64.194% ######## ( 2, 3 ] 21 6.774% 70.968% # ( 3, 4 ] 3 0.968% 71.935% ( 4, 6 ] 10 3.226% 75.161% # ( 6, 10 ] 34 10.968% 86.129% ## ( 10, 15 ] 11 3.548% 89.677% # ( 15, 22 ] 2 0.645% 90.323% ( 51, 76 ] 1 0.323% 90.645% ( 170, 250 ] 2 0.645% 91.290% ( 250, 380 ] 3 0.968% 92.258% ( 380, 580 ] 7 2.258% 94.516% ( 580, 870 ] 3 0.968% 95.484% ( 870, 1300 ] 2 0.645% 96.129% ( 1300, 1900 ] 4 1.290% 97.419% ( 1900, 2900 ] 4 1.290% 98.710% ( 2900, 4400 ] 3 0.968% 99.677% ( 4400, 6600 ] 1 0.323% 100.000% ** Level 5 read latency histogram (micros): Count: 40 Average: 656.1250 StdDev: 702.03 Min: 83 Median: 302.0000 Max: 2360 Percentiles: P50: 302.00 P75: 797.50 P99: 2360.00 P99.9: 2360.00 P99.99: 2360.00 ------------------------------------------------------ ( 76, 110 ] 3 7.500% 7.500% ## ( 110, 170 ] 14 35.000% 42.500% ####### ( 170, 250 ] 1 2.500% 45.000% # ( 250, 380 ] 5 12.500% 57.500% ### ( 380, 580 ] 1 2.500% 60.000% # ( 580, 870 ] 8 20.000% 80.000% #### ( 1300, 1900 ] 4 10.000% 90.000% ## ( 1900, 2900 ] 4 10.000% 100.000% ## ** DB Stats ** Uptime(secs): 9.1 total, 2.8 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 326.09 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.042 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, 352.30 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.200 H:M:S, 7.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/13-12:17:49 ... thread 0: (1000000,4000000) ops and (337957.7,339090.7) ops/second in (2.958950,11.796254) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 15/15 2.52 GB 0.0 2.2 0.0 2.2 5.8 3.7 0.0 1.6 116.1 315.1 18.99 17.66 61 0.311 2238K 2419 0.0 0.0 L1 5/5 487.84 MB 0.0 1.3 1.0 0.3 1.3 1.0 0.2 1.3 229.1 228.3 5.77 5.60 2 2.886 1342K 4594 0.0 0.0 L2 1/0 49.92 MB 0.5 0.3 0.2 0.2 0.3 0.2 0.5 1.8 246.3 246.1 1.41 1.36 2 0.707 353K 207 0.0 0.0 L3 13/0 722.89 MB 0.7 0.2 0.2 0.0 0.2 0.2 0.5 1.0 221.0 221.0 0.85 0.77 1 0.846 189K 0 0.0 0.0 L4 173/0 9.70 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.7 1.0 140.4 140.4 1.20 0.84 1 1.198 170K 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 1255/20 99.82 GB 0.0 4.1 1.5 2.6 7.8 5.2 2.5 2.1 149.9 283.6 28.22 26.23 67 0.421 4295K 7220 0.0 0.0 Int 0/0 0.00 KB 0.0 4.1 1.5 2.6 7.8 5.2 2.5 2.1 149.9 283.6 28.22 26.23 67 0.421 4295K 7220 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 4.1 1.5 2.6 4.1 1.5 0.0 0.0 240.8 240.4 17.57 16.71 14 1.255 4295K 7220 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 3.7 3.7 0.0 0.0 0.0 354.9 10.65 9.52 53 0.201 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 12.0 total, 11.8 interval Flush(GB): cumulative 3.691, interval 3.691 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 7.82 GB write, 666.19 MB/s write, 4.13 GB read, 352.18 MB/s read, 28.2 seconds Interval compaction: 7.82 GB write, 678.35 MB/s write, 4.13 GB read, 358.61 MB/s read, 28.2 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 15, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 15, interval: 15 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 909012 Average: 2.0942 StdDev: 12.54 Min: 0 Median: 1.4297 Max: 3716 Percentiles: P50: 1.43 P75: 1.82 P99: 5.27 P99.9: 9.60 P99.99: 14.87 ------------------------------------------------------ [ 0, 1 ] 204238 22.468% 22.468% #### ( 1, 2 ] 582425 64.072% 86.540% ############# ( 2, 3 ] 78364 8.621% 95.161% ## ( 3, 4 ] 25616 2.818% 97.979% # ( 4, 6 ] 14579 1.604% 99.583% ( 6, 10 ] 3199 0.352% 99.935% ( 10, 15 ] 515 0.057% 99.992% ( 15, 22 ] 61 0.007% 99.998% ( 22, 34 ] 15 0.002% 100.000% ( 34, 51 ] 8 0.001% 100.001% ( 51, 76 ] 8 0.001% 100.002% ( 76, 110 ] 2 0.000% 100.002% ( 110, 170 ] 34 0.004% 100.006% ( 170, 250 ] 22 0.002% 100.008% ( 250, 380 ] 22 0.002% 100.011% ( 380, 580 ] 8 0.001% 100.011% ( 580, 870 ] 15 0.002% 100.013% ( 870, 1300 ] 10 0.001% 100.014% ( 1300, 1900 ] 9 0.001% 100.015% ( 1900, 2900 ] 7 0.001% 100.016% ( 2900, 4400 ] 5 0.001% 100.017% ** Level 1 read latency histogram (micros): Count: 79928 Average: 2.2494 StdDev: 12.82 Min: 1 Median: 1.4819 Max: 1676 Percentiles: P50: 1.48 P75: 1.86 P99: 5.35 P99.9: 9.63 P99.99: 653.02 ------------------------------------------------------ [ 0, 1 ] 14172 17.731% 17.731% #### ( 1, 2 ] 53520 66.960% 84.691% ############# ( 2, 3 ] 8115 10.153% 94.844% ## ( 3, 4 ] 2367 2.961% 97.806% # ( 4, 6 ] 1416 1.772% 99.577% ( 6, 10 ] 284 0.355% 99.932% ( 10, 15 ] 25 0.031% 99.964% ( 15, 22 ] 1 0.001% 99.965% ( 22, 34 ] 2 0.003% 99.967% ( 34, 51 ] 1 0.001% 99.969% ( 51, 76 ] 2 0.003% 99.971% ( 250, 380 ] 11 0.014% 99.985% ( 380, 580 ] 3 0.004% 99.989% ( 580, 870 ] 4 0.005% 99.994% ( 870, 1300 ] 3 0.004% 99.997% ( 1300, 1900 ] 2 0.003% 100.000% ** Level 2 read latency histogram (micros): Count: 87984 Average: 2.2057 StdDev: 12.22 Min: 1 Median: 1.4103 Max: 2423 Percentiles: P50: 1.41 P75: 1.82 P99: 5.75 P99.9: 21.66 P99.99: 359.24 ------------------------------------------------------ [ 0, 1 ] 22159 25.185% 25.185% ##### ( 1, 2 ] 53212 60.479% 85.664% ############ ( 2, 3 ] 7243 8.232% 93.897% ## ( 3, 4 ] 2651 3.013% 96.910% # ( 4, 6 ] 2096 2.382% 99.292% ( 6, 10 ] 440 0.500% 99.792% ( 10, 15 ] 76 0.086% 99.878% ( 15, 22 ] 20 0.023% 99.901% ( 22, 34 ] 2 0.002% 99.903% ( 34, 51 ] 29 0.033% 99.936% ( 51, 76 ] 2 0.002% 99.939% ( 110, 170 ] 28 0.032% 99.970% ( 170, 250 ] 13 0.015% 99.985% ( 250, 380 ] 5 0.006% 99.991% ( 380, 580 ] 2 0.002% 99.993% ( 580, 870 ] 4 0.005% 99.998% ( 1300, 1900 ] 1 0.001% 99.999% ( 1900, 2900 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 42802 Average: 3.9313 StdDev: 65.91 Min: 1 Median: 1.5189 Max: 5100 Percentiles: P50: 1.52 P75: 1.90 P99: 5.85 P99.9: 456.33 P99.99: 3697.10 ------------------------------------------------------ [ 0, 1 ] 6736 15.738% 15.738% ### ( 1, 2 ] 28261 66.027% 81.765% ############# ( 2, 3 ] 5260 12.289% 94.054% ## ( 3, 4 ] 1266 2.958% 97.012% # ( 4, 6 ] 919 2.147% 99.159% ( 6, 10 ] 258 0.603% 99.762% ( 10, 15 ] 34 0.079% 99.841% ( 15, 22 ] 13 0.030% 99.872% ( 22, 34 ] 2 0.005% 99.876% ( 110, 170 ] 3 0.007% 99.883% ( 170, 250 ] 1 0.002% 99.886% ( 250, 380 ] 2 0.005% 99.890% ( 380, 580 ] 11 0.026% 99.916% ( 580, 870 ] 9 0.021% 99.937% ( 870, 1300 ] 5 0.012% 99.949% ( 1300, 1900 ] 5 0.012% 99.960% ( 1900, 2900 ] 9 0.021% 99.981% ( 2900, 4400 ] 7 0.016% 99.998% ( 4400, 6600 ] 1 0.002% 100.000% ** Level 4 read latency histogram (micros): Count: 310 Average: 133.5806 StdDev: 557.22 Min: 0 Median: 1.6271 Max: 4474 Percentiles: P50: 1.63 P75: 5.90 P99: 3350.00 P99.9: 4474.00 P99.99: 4474.00 ------------------------------------------------------ [ 0, 1 ] 81 26.129% 26.129% ##### ( 1, 2 ] 118 38.065% 64.194% ######## ( 2, 3 ] 21 6.774% 70.968% # ( 3, 4 ] 3 0.968% 71.935% ( 4, 6 ] 10 3.226% 75.161% # ( 6, 10 ] 34 10.968% 86.129% ## ( 10, 15 ] 11 3.548% 89.677% # ( 15, 22 ] 2 0.645% 90.323% ( 51, 76 ] 1 0.323% 90.645% ( 170, 250 ] 2 0.645% 91.290% ( 250, 380 ] 3 0.968% 92.258% ( 380, 580 ] 7 2.258% 94.516% ( 580, 870 ] 3 0.968% 95.484% ( 870, 1300 ] 2 0.645% 96.129% ( 1300, 1900 ] 4 1.290% 97.419% ( 1900, 2900 ] 4 1.290% 98.710% ( 2900, 4400 ] 3 0.968% 99.677% ( 4400, 6600 ] 1 0.323% 100.000% ** Level 5 read latency histogram (micros): Count: 40 Average: 656.1250 StdDev: 702.03 Min: 83 Median: 302.0000 Max: 2360 Percentiles: P50: 302.00 P75: 797.50 P99: 2360.00 P99.9: 2360.00 P99.99: 2360.00 ------------------------------------------------------ ( 76, 110 ] 3 7.500% 7.500% ## ( 110, 170 ] 14 35.000% 42.500% ####### ( 170, 250 ] 1 2.500% 45.000% # ( 250, 380 ] 5 12.500% 57.500% ### ( 380, 580 ] 1 2.500% 60.000% # ( 580, 870 ] 8 20.000% 80.000% #### ( 1300, 1900 ] 4 10.000% 90.000% ## ( 1900, 2900 ] 4 10.000% 100.000% ## ** DB Stats ** Uptime(secs): 12.0 total, 3.0 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 327.69 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.420 H:M:S, 11.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 332.61 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.378 H:M:S, 12.8 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/13-12:17:53 ... thread 0: (1000000,5000000) ops and (259285.4,319427.4) ops/second in (3.856754,15.653008) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 18/11 3.50 GB 125.9 3.2 0.0 3.2 7.9 4.7 0.0 1.7 126.6 311.5 25.87 24.14 80 0.323 3326K 3566 0.0 0.0 L1 5/5 487.84 MB 0.0 1.3 1.0 0.3 1.3 1.0 0.2 1.3 229.1 228.3 5.77 5.60 2 2.886 1342K 4594 0.0 0.0 L2 1/0 49.92 MB 0.5 0.3 0.2 0.2 0.3 0.2 0.5 1.8 246.3 246.1 1.41 1.36 2 0.707 353K 207 0.0 0.0 L3 13/0 722.89 MB 0.7 0.2 0.2 0.0 0.2 0.2 0.5 1.0 221.0 221.0 0.85 0.77 1 0.846 189K 0 0.0 0.0 L4 173/0 9.70 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.7 1.0 140.4 140.4 1.20 0.84 1 1.198 170K 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/16 100.80 GB 0.0 5.2 1.5 3.7 9.8 6.2 2.5 2.1 151.0 287.2 35.10 32.72 86 0.408 5383K 8367 0.0 0.0 Int 0/0 0.00 KB 0.0 5.2 1.5 3.7 9.8 6.2 2.5 2.1 151.0 287.2 35.10 32.72 86 0.408 5383K 8367 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 5.2 1.5 3.7 5.2 1.5 0.0 0.0 245.5 245.1 21.59 20.67 18 1.200 5383K 8367 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.4 13.51 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): 15.9 total, 15.7 interval Flush(GB): cumulative 4.676, interval 4.676 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 9.84 GB write, 635.21 MB/s write, 5.18 GB read, 334.08 MB/s read, 35.1 seconds Interval compaction: 9.84 GB write, 643.95 MB/s write, 5.18 GB read, 338.67 MB/s read, 35.1 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 7, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 7, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 17, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 7, total-stops: 17, interval: 24 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1401491 Average: 2.1250 StdDev: 11.63 Min: 0 Median: 1.4572 Max: 4011 Percentiles: P50: 1.46 P75: 1.84 P99: 5.37 P99.9: 9.69 P99.99: 14.47 ------------------------------------------------------ [ 0, 1 ] 281658 20.097% 20.097% #### ( 1, 2 ] 916580 65.400% 85.497% ############# ( 2, 3 ] 131635 9.392% 94.890% ## ( 3, 4 ] 41580 2.967% 97.857% # ( 4, 6 ] 23426 1.672% 99.528% ( 6, 10 ] 5643 0.403% 99.931% ( 10, 15 ] 927 0.066% 99.997% ( 15, 22 ] 104 0.007% 100.004% ( 22, 34 ] 23 0.002% 100.006% ( 34, 51 ] 11 0.001% 100.007% ( 51, 76 ] 11 0.001% 100.008% ( 76, 110 ] 16 0.001% 100.009% ( 110, 170 ] 46 0.003% 100.012% ( 170, 250 ] 41 0.003% 100.015% ( 250, 380 ] 35 0.002% 100.017% ( 380, 580 ] 17 0.001% 100.019% ( 580, 870 ] 22 0.002% 100.020% ( 870, 1300 ] 14 0.001% 100.021% ( 1300, 1900 ] 9 0.001% 100.022% ( 1900, 2900 ] 8 0.001% 100.022% ( 2900, 4400 ] 7 0.000% 100.023% ** Level 1 read latency histogram (micros): Count: 79928 Average: 2.2494 StdDev: 12.82 Min: 1 Median: 1.4819 Max: 1676 Percentiles: P50: 1.48 P75: 1.86 P99: 5.35 P99.9: 9.63 P99.99: 653.02 ------------------------------------------------------ [ 0, 1 ] 14172 17.731% 17.731% #### ( 1, 2 ] 53520 66.960% 84.691% ############# ( 2, 3 ] 8115 10.153% 94.844% ## ( 3, 4 ] 2367 2.961% 97.806% # ( 4, 6 ] 1416 1.772% 99.577% ( 6, 10 ] 284 0.355% 99.932% ( 10, 15 ] 25 0.031% 99.964% ( 15, 22 ] 1 0.001% 99.965% ( 22, 34 ] 2 0.003% 99.967% ( 34, 51 ] 1 0.001% 99.969% ( 51, 76 ] 2 0.003% 99.971% ( 250, 380 ] 11 0.014% 99.985% ( 380, 580 ] 3 0.004% 99.989% ( 580, 870 ] 4 0.005% 99.994% ( 870, 1300 ] 3 0.004% 99.997% ( 1300, 1900 ] 2 0.003% 100.000% ** Level 2 read latency histogram (micros): Count: 87984 Average: 2.2057 StdDev: 12.22 Min: 1 Median: 1.4103 Max: 2423 Percentiles: P50: 1.41 P75: 1.82 P99: 5.75 P99.9: 21.66 P99.99: 359.24 ------------------------------------------------------ [ 0, 1 ] 22159 25.185% 25.185% ##### ( 1, 2 ] 53212 60.479% 85.664% ############ ( 2, 3 ] 7243 8.232% 93.897% ## ( 3, 4 ] 2651 3.013% 96.910% # ( 4, 6 ] 2096 2.382% 99.292% ( 6, 10 ] 440 0.500% 99.792% ( 10, 15 ] 76 0.086% 99.878% ( 15, 22 ] 20 0.023% 99.901% ( 22, 34 ] 2 0.002% 99.903% ( 34, 51 ] 29 0.033% 99.936% ( 51, 76 ] 2 0.002% 99.939% ( 110, 170 ] 28 0.032% 99.970% ( 170, 250 ] 13 0.015% 99.985% ( 250, 380 ] 5 0.006% 99.991% ( 380, 580 ] 2 0.002% 99.993% ( 580, 870 ] 4 0.005% 99.998% ( 1300, 1900 ] 1 0.001% 99.999% ( 1900, 2900 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 42802 Average: 3.9313 StdDev: 65.91 Min: 1 Median: 1.5189 Max: 5100 Percentiles: P50: 1.52 P75: 1.90 P99: 5.85 P99.9: 456.33 P99.99: 3697.10 ------------------------------------------------------ [ 0, 1 ] 6736 15.738% 15.738% ### ( 1, 2 ] 28261 66.027% 81.765% ############# ( 2, 3 ] 5260 12.289% 94.054% ## ( 3, 4 ] 1266 2.958% 97.012% # ( 4, 6 ] 919 2.147% 99.159% ( 6, 10 ] 258 0.603% 99.762% ( 10, 15 ] 34 0.079% 99.841% ( 15, 22 ] 13 0.030% 99.872% ( 22, 34 ] 2 0.005% 99.876% ( 110, 170 ] 3 0.007% 99.883% ( 170, 250 ] 1 0.002% 99.886% ( 250, 380 ] 2 0.005% 99.890% ( 380, 580 ] 11 0.026% 99.916% ( 580, 870 ] 9 0.021% 99.937% ( 870, 1300 ] 5 0.012% 99.949% ( 1300, 1900 ] 5 0.012% 99.960% ( 1900, 2900 ] 9 0.021% 99.981% ( 2900, 4400 ] 7 0.016% 99.998% ( 4400, 6600 ] 1 0.002% 100.000% ** Level 4 read latency histogram (micros): Count: 310 Average: 133.5806 StdDev: 557.22 Min: 0 Median: 1.6271 Max: 4474 Percentiles: P50: 1.63 P75: 5.90 P99: 3350.00 P99.9: 4474.00 P99.99: 4474.00 ------------------------------------------------------ [ 0, 1 ] 81 26.129% 26.129% ##### ( 1, 2 ] 118 38.065% 64.194% ######## ( 2, 3 ] 21 6.774% 70.968% # ( 3, 4 ] 3 0.968% 71.935% ( 4, 6 ] 10 3.226% 75.161% # ( 6, 10 ] 34 10.968% 86.129% ## ( 10, 15 ] 11 3.548% 89.677% # ( 15, 22 ] 2 0.645% 90.323% ( 51, 76 ] 1 0.323% 90.645% ( 170, 250 ] 2 0.645% 91.290% ( 250, 380 ] 3 0.968% 92.258% ( 380, 580 ] 7 2.258% 94.516% ( 580, 870 ] 3 0.968% 95.484% ( 870, 1300 ] 2 0.645% 96.129% ( 1300, 1900 ] 4 1.290% 97.419% ( 1900, 2900 ] 4 1.290% 98.710% ( 2900, 4400 ] 3 0.968% 99.677% ( 4400, 6600 ] 1 0.323% 100.000% ** Level 5 read latency histogram (micros): Count: 40 Average: 656.1250 StdDev: 702.03 Min: 83 Median: 302.0000 Max: 2360 Percentiles: P50: 302.00 P75: 797.50 P99: 2360.00 P99.9: 2360.00 P99.99: 2360.00 ------------------------------------------------------ ( 76, 110 ] 3 7.500% 7.500% ## ( 110, 170 ] 14 35.000% 42.500% ####### ( 170, 250 ] 1 2.500% 45.000% # ( 250, 380 ] 5 12.500% 57.500% ### ( 380, 580 ] 1 2.500% 60.000% # ( 580, 870 ] 8 20.000% 80.000% #### ( 1300, 1900 ] 4 10.000% 90.000% ## ( 1900, 2900 ] 4 10.000% 100.000% ## ** DB Stats ** Uptime(secs): 15.9 total, 3.9 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 310.07 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:2.597 H:M:S, 16.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 255.19 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:1.177 H:M:S, 30.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/12/13-12:18:01 ... thread 0: (1000000,6000000) ops and (120168.8,250264.5) ops/second in (8.321625,23.974633) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 9/4 2.15 GB 194.6 5.0 0.0 5.0 10.6 5.6 0.0 1.9 144.0 305.5 35.44 33.21 99 0.358 5180K 8965 0.0 0.0 L1 15/0 1.71 GB 175.0 4.0 3.3 0.8 4.0 3.2 0.2 1.2 226.1 223.8 18.31 17.56 3 6.103 4202K 40K 0.0 0.0 L2 9/6 1.05 GB 3.9 0.3 0.2 0.2 0.3 0.2 1.5 1.8 246.3 246.1 1.41 1.36 2 0.707 353K 207 0.0 0.0 L3 13/6 722.89 MB 0.0 0.2 0.2 0.0 0.2 0.2 0.5 1.0 221.0 221.0 0.85 0.77 1 0.846 189K 0 0.0 0.0 L4 173/0 9.70 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.7 1.0 140.4 140.4 1.20 0.84 1 1.198 170K 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 1267/16 101.69 GB 0.0 9.7 3.8 5.9 15.3 9.3 3.6 2.7 173.8 273.2 57.21 53.75 106 0.540 10M 49K 0.0 0.0 Int 0/0 0.00 KB 0.0 9.7 3.8 5.9 15.3 9.3 3.6 2.7 173.8 273.2 57.21 53.75 106 0.540 10M 49K 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 9.7 3.8 5.9 9.7 3.7 0.0 0.0 242.7 241.5 40.97 39.27 23 1.781 10M 49K 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 353.1 16.24 14.48 83 0.196 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 24.2 total, 24.0 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: 15.26 GB write, 645.94 MB/s write, 9.71 GB read, 411.06 MB/s read, 57.2 seconds Interval compaction: 15.26 GB write, 651.74 MB/s write, 9.71 GB read, 414.75 MB/s read, 57.2 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 16, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 16, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 17, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 16, total-stops: 17, interval: 33 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2218445 Average: 2.2862 StdDev: 12.39 Min: 0 Median: 1.4630 Max: 4011 Percentiles: P50: 1.46 P75: 1.84 P99: 5.63 P99.9: 16.26 P99.99: 168.25 ------------------------------------------------------ [ 0, 1 ] 429672 19.368% 19.368% #### ( 1, 2 ] 1467590 66.154% 85.522% ############# ( 2, 3 ] 203293 9.164% 94.686% ## ( 3, 4 ] 65810 2.966% 97.652% # ( 4, 6 ] 36717 1.655% 99.307% ( 6, 10 ] 11647 0.525% 99.832% ( 10, 15 ] 1467 0.066% 99.899% ( 15, 22 ] 175 0.008% 99.907% ( 22, 34 ] 30 0.001% 99.908% ( 34, 51 ] 16 0.001% 99.909% ( 51, 76 ] 23 0.001% 99.910% ( 76, 110 ] 858 0.039% 99.948% ( 110, 170 ] 954 0.043% 99.991% ( 170, 250 ] 272 0.012% 100.004% ( 250, 380 ] 162 0.007% 100.011% ( 380, 580 ] 121 0.005% 100.016% ( 580, 870 ] 86 0.004% 100.020% ( 870, 1300 ] 23 0.001% 100.021% ( 1300, 1900 ] 13 0.001% 100.022% ( 1900, 2900 ] 11 0.000% 100.022% ( 2900, 4400 ] 8 0.000% 100.023% ** Level 1 read latency histogram (micros): Count: 243507 Average: 3.3783 StdDev: 29.34 Min: 1 Median: 1.5511 Max: 4921 Percentiles: P50: 1.55 P75: 1.94 P99: 8.07 P99.9: 230.90 P99.99: 543.30 ------------------------------------------------------ [ 0, 1 ] 36060 14.809% 14.809% ### ( 1, 2 ] 155493 63.856% 78.664% ############# ( 2, 3 ] 29123 11.960% 90.624% ## ( 3, 4 ] 10504 4.314% 94.938% # ( 4, 6 ] 8486 3.485% 98.423% # ( 6, 10 ] 2722 1.118% 99.540% ( 10, 15 ] 299 0.123% 99.663% ( 15, 22 ] 45 0.018% 99.682% ( 22, 34 ] 9 0.004% 99.685% ( 34, 51 ] 3 0.001% 99.687% ( 51, 76 ] 10 0.004% 99.691% ( 76, 110 ] 212 0.087% 99.778% ( 110, 170 ] 215 0.088% 99.866% ( 170, 250 ] 111 0.046% 99.912% ( 250, 380 ] 111 0.046% 99.957% ( 380, 580 ] 100 0.041% 99.998% ( 580, 870 ] 55 0.023% 100.021% ( 870, 1300 ] 31 0.013% 100.034% ( 1300, 1900 ] 23 0.009% 100.043% ( 1900, 2900 ] 5 0.002% 100.045% ( 2900, 4400 ] 1 0.000% 100.046% ( 4400, 6600 ] 1 0.000% 100.046% ** Level 2 read latency histogram (micros): Count: 88337 Average: 2.5110 StdDev: 17.73 Min: 1 Median: 1.4136 Max: 2423 Percentiles: P50: 1.41 P75: 1.83 P99: 5.88 P99.9: 157.42 P99.99: 782.39 ------------------------------------------------------ [ 0, 1 ] 22159 25.085% 25.085% ##### ( 1, 2 ] 53213 60.239% 85.323% ############ ( 2, 3 ] 7260 8.219% 93.542% ## ( 3, 4 ] 2698 3.054% 96.596% # ( 4, 6 ] 2258 2.556% 99.152% # ( 6, 10 ] 485 0.549% 99.701% ( 10, 15 ] 84 0.095% 99.796% ( 15, 22 ] 28 0.032% 99.828% ( 22, 34 ] 3 0.003% 99.831% ( 34, 51 ] 29 0.033% 99.864% ( 51, 76 ] 2 0.002% 99.866% ( 76, 110 ] 2 0.002% 99.869% ( 110, 170 ] 35 0.040% 99.908% ( 170, 250 ] 25 0.028% 99.937% ( 250, 380 ] 20 0.023% 99.959% ( 380, 580 ] 16 0.018% 99.977% ( 580, 870 ] 16 0.018% 99.995% ( 870, 1300 ] 1 0.001% 99.997% ( 1300, 1900 ] 2 0.002% 99.999% ( 1900, 2900 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 49014 Average: 4.9419 StdDev: 75.03 Min: 1 Median: 1.5640 Max: 5100 Percentiles: P50: 1.56 P75: 1.95 P99: 7.22 P99.9: 817.09 P99.99: 3867.99 ------------------------------------------------------ [ 0, 1 ] 6804 13.882% 13.882% ### ( 1, 2 ] 31391 64.045% 77.927% ############# ( 2, 3 ] 6702 13.674% 91.600% ### ( 3, 4 ] 1902 3.881% 95.481% # ( 4, 6 ] 1597 3.258% 98.739% # ( 6, 10 ] 419 0.855% 99.594% ( 10, 15 ] 57 0.116% 99.710% ( 15, 22 ] 16 0.033% 99.743% ( 22, 34 ] 2 0.004% 99.747% ( 110, 170 ] 11 0.022% 99.769% ( 170, 250 ] 14 0.029% 99.798% ( 250, 380 ] 10 0.020% 99.818% ( 380, 580 ] 22 0.045% 99.863% ( 580, 870 ] 22 0.045% 99.908% ( 870, 1300 ] 13 0.027% 99.935% ( 1300, 1900 ] 5 0.010% 99.945% ( 1900, 2900 ] 15 0.031% 99.976% ( 2900, 4400 ] 11 0.022% 99.998% ( 4400, 6600 ] 1 0.002% 100.000% ** Level 4 read latency histogram (micros): Count: 310 Average: 133.5806 StdDev: 557.22 Min: 0 Median: 1.6271 Max: 4474 Percentiles: P50: 1.63 P75: 5.90 P99: 3350.00 P99.9: 4474.00 P99.99: 4474.00 ------------------------------------------------------ [ 0, 1 ] 81 26.129% 26.129% ##### ( 1, 2 ] 118 38.065% 64.194% ######## ( 2, 3 ] 21 6.774% 70.968% # ( 3, 4 ] 3 0.968% 71.935% ( 4, 6 ] 10 3.226% 75.161% # ( 6, 10 ] 34 10.968% 86.129% ## ( 10, 15 ] 11 3.548% 89.677% # ( 15, 22 ] 2 0.645% 90.323% ( 51, 76 ] 1 0.323% 90.645% ( 170, 250 ] 2 0.645% 91.290% ( 250, 380 ] 3 0.968% 92.258% ( 380, 580 ] 7 2.258% 94.516% ( 580, 870 ] 3 0.968% 95.484% ( 870, 1300 ] 2 0.645% 96.129% ( 1300, 1900 ] 4 1.290% 97.419% ( 1900, 2900 ] 4 1.290% 98.710% ( 2900, 4400 ] 3 0.968% 99.677% ( 4400, 6600 ] 1 0.323% 100.000% ** Level 5 read latency histogram (micros): Count: 40 Average: 656.1250 StdDev: 702.03 Min: 83 Median: 302.0000 Max: 2360 Percentiles: P50: 302.00 P75: 797.50 P99: 2360.00 P99.9: 2360.00 P99.99: 2360.00 ------------------------------------------------------ ( 76, 110 ] 3 7.500% 7.500% ## ( 110, 170 ] 14 35.000% 42.500% ####### ( 170, 250 ] 1 2.500% 45.000% # ( 250, 380 ] 5 12.500% 57.500% ### ( 380, 580 ] 1 2.500% 60.000% # ( 580, 870 ] 8 20.000% 80.000% #### ( 1300, 1900 ] 4 10.000% 90.000% ## ( 1900, 2900 ] 4 10.000% 100.000% ## ** DB Stats ** Uptime(secs): 24.2 total, 8.3 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 244.10 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:8.005 H:M:S, 33.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 118.27 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.408 H:M:S, 65.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 6 num-running-flushes: 1 2024/12/13-12:18:05 ... thread 0: (1000000,7000000) ops and (227297.9,246703.5) ops/second in (4.399513,28.374146) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 13/7 3.13 GB 94.4 5.8 0.0 5.8 12.4 6.6 0.0 1.9 137.8 292.7 43.44 39.45 115 0.378 6075K 10K 0.0 0.0 L1 15/15 1.71 GB 0.0 4.0 3.3 0.8 4.0 3.2 0.2 1.2 226.1 223.8 18.31 17.56 3 6.103 4202K 40K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.3 0.2 0.2 0.3 0.2 1.5 1.8 246.3 246.1 1.41 1.36 2 0.707 353K 207 0.0 0.0 L3 24/0 958.81 MB 1.0 2.3 1.2 1.0 2.2 1.2 0.5 1.8 187.5 186.6 12.32 10.46 9 1.369 2345K 10K 0.0 0.0 L4 176/0 9.53 GB 1.0 0.9 0.9 0.0 0.9 0.9 0.8 1.0 115.9 115.7 8.05 4.47 15 0.537 941K 1186 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 1288/22 102.66 GB 0.0 13.4 5.6 7.8 19.9 12.1 4.6 3.0 164.2 244.1 83.53 73.31 144 0.580 13M 63K 0.0 0.0 Int 0/0 0.00 KB 0.0 13.4 5.6 7.8 19.9 12.1 4.6 3.0 164.2 244.1 83.53 73.31 144 0.580 13M 63K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 13.4 5.6 7.8 13.3 5.5 0.0 0.0 217.3 216.3 63.11 56.02 48 1.315 13M 63K 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 330.1 20.42 17.29 96 0.213 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 28.6 total, 28.4 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: 19.91 GB write, 713.16 MB/s write, 13.39 GB read, 479.64 MB/s read, 83.5 seconds Interval compaction: 19.91 GB write, 718.57 MB/s write, 13.39 GB read, 483.28 MB/s read, 83.5 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 16, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 16, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 36, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 16, total-stops: 36, interval: 52 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2593753 Average: 2.4956 StdDev: 27.08 Min: 0 Median: 1.5039 Max: 28419 Percentiles: P50: 1.50 P75: 1.89 P99: 5.91 P99.9: 15.00 P99.99: 200.99 ------------------------------------------------------ [ 0, 1 ] 452820 17.458% 17.458% ### ( 1, 2 ] 1675081 64.581% 82.039% ############# ( 2, 3 ] 277541 10.700% 92.740% ## ( 3, 4 ] 96992 3.739% 96.479% # ( 4, 6 ] 68505 2.641% 99.120% # ( 6, 10 ] 17768 0.685% 99.805% ( 10, 15 ] 2457 0.095% 99.900% ( 15, 22 ] 278 0.011% 99.911% ( 22, 34 ] 39 0.002% 99.912% ( 34, 51 ] 20 0.001% 99.913% ( 51, 76 ] 24 0.001% 99.914% ( 76, 110 ] 872 0.034% 99.948% ( 110, 170 ] 978 0.038% 99.985% ( 170, 250 ] 314 0.012% 99.998% ( 250, 380 ] 216 0.008% 100.006% ( 380, 580 ] 187 0.007% 100.013% ( 580, 870 ] 155 0.006% 100.019% ( 870, 1300 ] 89 0.003% 100.022% ( 1300, 1900 ] 33 0.001% 100.024% ( 1900, 2900 ] 34 0.001% 100.025% ( 2900, 4400 ] 21 0.001% 100.026% ( 4400, 6600 ] 7 0.000% 100.026% ( 6600, 9900 ] 1 0.000% 100.026% ( 22000, 33000 ] 1 0.000% 100.026% ** Level 1 read latency histogram (micros): Count: 594641 Average: 3.7778 StdDev: 44.99 Min: 1 Median: 1.7481 Max: 7919 Percentiles: P50: 1.75 P75: 2.57 P99: 8.80 P99.9: 23.18 P99.99: 169.02 ------------------------------------------------------ [ 0, 1 ] 42892 7.213% 7.213% # ( 1, 2 ] 340090 57.192% 64.406% ########### ( 2, 3 ] 110998 18.666% 83.072% #### ( 3, 4 ] 43992 7.398% 90.470% # ( 4, 6 ] 42413 7.133% 97.603% # ( 6, 10 ] 11876 1.997% 99.600% ( 10, 15 ] 1574 0.265% 99.864% ( 15, 22 ] 209 0.035% 99.900% ( 22, 34 ] 24 0.004% 99.904% ( 34, 51 ] 3 0.001% 99.904% ( 51, 76 ] 13 0.002% 99.906% ( 76, 110 ] 229 0.039% 99.945% ( 110, 170 ] 273 0.046% 99.991% ( 170, 250 ] 162 0.027% 100.018% ( 250, 380 ] 186 0.031% 100.049% ( 380, 580 ] 189 0.032% 100.081% ( 580, 870 ] 120 0.020% 100.101% ( 870, 1300 ] 83 0.014% 100.115% ( 1300, 1900 ] 46 0.008% 100.123% ( 1900, 2900 ] 20 0.003% 100.126% ( 2900, 4400 ] 20 0.003% 100.130% ( 4400, 6600 ] 9 0.002% 100.131% ( 6600, 9900 ] 5 0.001% 100.132% ** Level 2 read latency histogram (micros): Count: 100660 Average: 2.9579 StdDev: 36.75 Min: 1 Median: 1.4707 Max: 4056 Percentiles: P50: 1.47 P75: 1.89 P99: 6.67 P99.9: 188.11 P99.99: 1890.10 ------------------------------------------------------ [ 0, 1 ] 22312 22.166% 22.166% #### ( 1, 2 ] 59520 59.130% 81.295% ############ ( 2, 3 ] 10319 10.251% 91.547% ## ( 3, 4 ] 3960 3.934% 95.481% # ( 4, 6 ] 3410 3.388% 98.868% # ( 6, 10 ] 786 0.781% 99.649% ( 10, 15 ] 139 0.138% 99.787% ( 15, 22 ] 36 0.036% 99.823% ( 22, 34 ] 3 0.003% 99.826% ( 34, 51 ] 29 0.029% 99.855% ( 51, 76 ] 2 0.002% 99.857% ( 76, 110 ] 2 0.002% 99.859% ( 110, 170 ] 35 0.035% 99.894% ( 170, 250 ] 28 0.028% 99.922% ( 250, 380 ] 22 0.022% 99.943% ( 380, 580 ] 21 0.021% 99.964% ( 580, 870 ] 20 0.020% 99.984% ( 870, 1300 ] 2 0.002% 99.986% ( 1300, 1900 ] 4 0.004% 99.990% ( 1900, 2900 ] 5 0.005% 99.995% ( 2900, 4400 ] 5 0.005% 100.000% ** Level 3 read latency histogram (micros): Count: 359439 Average: 3.8986 StdDev: 47.31 Min: 1 Median: 1.9288 Max: 5192 Percentiles: P50: 1.93 P75: 2.91 P99: 8.36 P99.9: 13.22 P99.99: 14.71 ------------------------------------------------------ [ 0, 1 ] 10224 2.844% 2.844% # ( 1, 2 ] 182488 50.770% 53.615% ########## ( 2, 3 ] 84763 23.582% 77.197% ##### ( 3, 4 ] 36666 10.201% 87.398% ## ( 4, 6 ] 38058 10.588% 97.986% ## ( 6, 10 ] 6186 1.721% 99.707% ( 10, 15 ] 1080 0.300% 100.007% ( 15, 22 ] 122 0.034% 100.041% ( 22, 34 ] 9 0.003% 100.044% ( 34, 51 ] 1 0.000% 100.044% ( 51, 76 ] 3 0.001% 100.045% ( 76, 110 ] 12 0.003% 100.048% ( 110, 170 ] 31 0.009% 100.057% ( 170, 250 ] 45 0.013% 100.069% ( 250, 380 ] 50 0.014% 100.083% ( 380, 580 ] 61 0.017% 100.100% ( 580, 870 ] 56 0.016% 100.116% ( 870, 1300 ] 32 0.009% 100.125% ( 1300, 1900 ] 20 0.006% 100.130% ( 1900, 2900 ] 28 0.008% 100.138% ( 2900, 4400 ] 33 0.009% 100.147% ( 4400, 6600 ] 2 0.001% 100.148% ** Level 4 read latency histogram (micros): Count: 10890 Average: 130.1500 StdDev: 750.65 Min: 0 Median: 2.0756 Max: 35388 Percentiles: P50: 2.08 P75: 3.46 P99: 3376.58 P99.9: 6509.61 P99.99: 9863.29 ------------------------------------------------------ [ 0, 1 ] 304 2.792% 2.792% # ( 1, 2 ] 4964 45.583% 48.375% ######### ( 2, 3 ] 2341 21.497% 69.871% #### ( 3, 4 ] 1217 11.175% 81.047% ## ( 4, 6 ] 810 7.438% 88.485% # ( 6, 10 ] 258 2.369% 90.854% ( 10, 15 ] 37 0.340% 91.194% ( 15, 22 ] 4 0.037% 91.230% ( 22, 34 ] 1 0.009% 91.240% ( 34, 51 ] 1 0.009% 91.249% ( 51, 76 ] 1 0.009% 91.258% ( 76, 110 ] 5 0.046% 91.304% ( 110, 170 ] 36 0.331% 91.635% ( 170, 250 ] 48 0.441% 92.075% ( 250, 380 ] 91 0.836% 92.911% ( 380, 580 ] 132 1.212% 94.123% ( 580, 870 ] 184 1.690% 95.813% ( 870, 1300 ] 156 1.433% 97.245% ( 1300, 1900 ] 91 0.836% 98.081% ( 1900, 2900 ] 75 0.689% 98.770% ( 2900, 4400 ] 79 0.725% 99.495% ( 4400, 6600 ] 46 0.422% 99.917% ( 6600, 9900 ] 8 0.073% 99.991% ( 9900, 14000 ] 1 0.009% 100.000% ( 33000, 50000 ] 2 0.018% 100.018% ** Level 5 read latency histogram (micros): Count: 100 Average: 1157.1300 StdDev: 1464.11 Min: 83 Median: 522.8571 Max: 8473 Percentiles: P50: 522.86 P75: 1600.00 P99: 6600.00 P99.9: 8473.00 P99.99: 8473.00 ------------------------------------------------------ ( 76, 110 ] 9 9.000% 9.000% ## ( 110, 170 ] 18 18.000% 27.000% #### ( 170, 250 ] 5 5.000% 32.000% # ( 250, 380 ] 13 13.000% 45.000% ### ( 380, 580 ] 7 7.000% 52.000% # ( 580, 870 ] 13 13.000% 65.000% ### ( 870, 1300 ] 5 5.000% 70.000% # ( 1300, 1900 ] 10 10.000% 80.000% ## ( 1900, 2900 ] 6 6.000% 86.000% # ( 2900, 4400 ] 10 10.000% 96.000% ## ( 4400, 6600 ] 3 3.000% 99.000% # ( 6600, 9900 ] 1 1.000% 100.000% ** DB Stats ** Uptime(secs): 28.6 total, 4.4 interval Cumulative writes: 0 writes, 7000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 6.73 GB, 240.96 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:9.475 H:M:S, 33.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 223.70 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:1.469 H:M:S, 33.4 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/12/13-12:18:09 ... thread 0: (1000000,8000000) ops and (282443.1,250668.3) ops/second in (3.540536,31.914682) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 18/11 4.11 GB 169.9 6.7 0.0 6.7 14.3 7.6 0.0 1.9 138.0 293.6 49.74 45.36 132 0.377 6971K 10K 0.0 0.0 L1 15/15 1.71 GB 0.0 4.0 3.3 0.8 4.0 3.2 0.2 1.2 226.1 223.8 18.31 17.56 3 6.103 4202K 40K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.3 0.2 0.2 0.3 0.2 1.5 1.8 246.3 246.1 1.41 1.36 2 0.707 353K 207 0.0 0.0 L3 24/0 958.81 MB 1.0 2.3 1.2 1.0 2.2 1.2 0.5 1.8 187.5 186.6 12.32 10.46 9 1.369 2345K 10K 0.0 0.0 L4 176/0 9.53 GB 1.0 0.9 0.9 0.0 0.9 0.9 0.8 1.0 115.9 115.7 8.05 4.47 15 0.537 941K 1186 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 1293/26 103.64 GB 0.0 14.3 5.6 8.7 21.8 13.1 4.6 2.9 162.5 248.0 89.84 79.21 161 0.558 14M 64K 0.0 0.0 Int 0/0 0.00 KB 0.0 14.3 5.6 8.7 21.8 13.1 4.6 2.9 162.5 248.0 89.84 79.21 161 0.558 14M 64K 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.3 5.6 8.7 14.2 5.5 0.0 0.0 219.5 218.5 66.49 59.33 51 1.304 14M 64K 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 331.9 23.35 19.88 110 0.212 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 32.1 total, 31.9 interval Flush(GB): cumulative 7.567, interval 7.567 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 21.76 GB write, 693.36 MB/s write, 14.25 GB read, 454.23 MB/s read, 89.8 seconds Interval compaction: 21.76 GB write, 698.04 MB/s write, 14.25 GB read, 457.30 MB/s read, 89.8 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 19, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 19, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 40, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 19, total-stops: 40, interval: 59 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2993710 Average: 2.4689 StdDev: 25.49 Min: 0 Median: 1.5100 Max: 28419 Percentiles: P50: 1.51 P75: 1.89 P99: 5.90 P99.9: 14.29 P99.99: 169.03 ------------------------------------------------------ [ 0, 1 ] 504959 16.867% 16.867% ### ( 1, 2 ] 1944872 64.965% 81.833% ############# ( 2, 3 ] 328910 10.987% 92.819% ## ( 3, 4 ] 111558 3.726% 96.546% # ( 4, 6 ] 77160 2.577% 99.123% # ( 6, 10 ] 20774 0.694% 99.817% ( 10, 15 ] 2897 0.097% 99.914% ( 15, 22 ] 305 0.010% 99.924% ( 22, 34 ] 41 0.001% 99.925% ( 34, 51 ] 23 0.001% 99.926% ( 51, 76 ] 25 0.001% 99.927% ( 76, 110 ] 893 0.030% 99.957% ( 110, 170 ] 1010 0.034% 99.991% ( 170, 250 ] 330 0.011% 100.002% ( 250, 380 ] 229 0.008% 100.009% ( 380, 580 ] 193 0.006% 100.016% ( 580, 870 ] 162 0.005% 100.021% ( 870, 1300 ] 99 0.003% 100.024% ( 1300, 1900 ] 36 0.001% 100.026% ( 1900, 2900 ] 34 0.001% 100.027% ( 2900, 4400 ] 22 0.001% 100.027% ( 4400, 6600 ] 7 0.000% 100.028% ( 6600, 9900 ] 1 0.000% 100.028% ( 22000, 33000 ] 1 0.000% 100.028% ** Level 1 read latency histogram (micros): Count: 663201 Average: 3.6738 StdDev: 42.78 Min: 1 Median: 1.7299 Max: 7919 Percentiles: P50: 1.73 P75: 2.51 P99: 8.77 P99.9: 84.53 P99.99: 184.19 ------------------------------------------------------ [ 0, 1 ] 49099 7.403% 7.403% # ( 1, 2 ] 387022 58.357% 65.760% ############ ( 2, 3 ] 120692 18.198% 83.958% #### ( 3, 4 ] 46602 7.027% 90.985% # ( 4, 6 ] 44174 6.661% 97.646% # ( 6, 10 ] 12976 1.957% 99.603% ( 10, 15 ] 1631 0.246% 99.848% ( 15, 22 ] 215 0.032% 99.881% ( 22, 34 ] 24 0.004% 99.884% ( 34, 51 ] 3 0.000% 99.885% ( 51, 76 ] 20 0.003% 99.888% ( 76, 110 ] 318 0.048% 99.936% ( 110, 170 ] 328 0.049% 99.985% ( 170, 250 ] 173 0.026% 100.011% ( 250, 380 ] 202 0.030% 100.042% ( 380, 580 ] 199 0.030% 100.072% ( 580, 870 ] 124 0.019% 100.091% ( 870, 1300 ] 84 0.013% 100.103% ( 1300, 1900 ] 46 0.007% 100.110% ( 1900, 2900 ] 20 0.003% 100.113% ( 2900, 4400 ] 20 0.003% 100.116% ( 4400, 6600 ] 9 0.001% 100.118% ( 6600, 9900 ] 5 0.001% 100.118% ** Level 2 read latency histogram (micros): Count: 100660 Average: 2.9579 StdDev: 36.75 Min: 1 Median: 1.4707 Max: 4056 Percentiles: P50: 1.47 P75: 1.89 P99: 6.67 P99.9: 188.11 P99.99: 1890.10 ------------------------------------------------------ [ 0, 1 ] 22312 22.166% 22.166% #### ( 1, 2 ] 59520 59.130% 81.295% ############ ( 2, 3 ] 10319 10.251% 91.547% ## ( 3, 4 ] 3960 3.934% 95.481% # ( 4, 6 ] 3410 3.388% 98.868% # ( 6, 10 ] 786 0.781% 99.649% ( 10, 15 ] 139 0.138% 99.787% ( 15, 22 ] 36 0.036% 99.823% ( 22, 34 ] 3 0.003% 99.826% ( 34, 51 ] 29 0.029% 99.855% ( 51, 76 ] 2 0.002% 99.857% ( 76, 110 ] 2 0.002% 99.859% ( 110, 170 ] 35 0.035% 99.894% ( 170, 250 ] 28 0.028% 99.922% ( 250, 380 ] 22 0.022% 99.943% ( 380, 580 ] 21 0.021% 99.964% ( 580, 870 ] 20 0.020% 99.984% ( 870, 1300 ] 2 0.002% 99.986% ( 1300, 1900 ] 4 0.004% 99.990% ( 1900, 2900 ] 5 0.005% 99.995% ( 2900, 4400 ] 5 0.005% 100.000% ** Level 3 read latency histogram (micros): Count: 359439 Average: 3.8986 StdDev: 47.31 Min: 1 Median: 1.9288 Max: 5192 Percentiles: P50: 1.93 P75: 2.91 P99: 8.36 P99.9: 13.22 P99.99: 14.71 ------------------------------------------------------ [ 0, 1 ] 10224 2.844% 2.844% # ( 1, 2 ] 182488 50.770% 53.615% ########## ( 2, 3 ] 84763 23.582% 77.197% ##### ( 3, 4 ] 36666 10.201% 87.398% ## ( 4, 6 ] 38058 10.588% 97.986% ## ( 6, 10 ] 6186 1.721% 99.707% ( 10, 15 ] 1080 0.300% 100.007% ( 15, 22 ] 122 0.034% 100.041% ( 22, 34 ] 9 0.003% 100.044% ( 34, 51 ] 1 0.000% 100.044% ( 51, 76 ] 3 0.001% 100.045% ( 76, 110 ] 12 0.003% 100.048% ( 110, 170 ] 31 0.009% 100.057% ( 170, 250 ] 45 0.013% 100.069% ( 250, 380 ] 50 0.014% 100.083% ( 380, 580 ] 61 0.017% 100.100% ( 580, 870 ] 56 0.016% 100.116% ( 870, 1300 ] 32 0.009% 100.125% ( 1300, 1900 ] 20 0.006% 100.130% ( 1900, 2900 ] 28 0.008% 100.138% ( 2900, 4400 ] 33 0.009% 100.147% ( 4400, 6600 ] 2 0.001% 100.148% ** Level 4 read latency histogram (micros): Count: 10890 Average: 130.1500 StdDev: 750.65 Min: 0 Median: 2.0756 Max: 35388 Percentiles: P50: 2.08 P75: 3.46 P99: 3376.58 P99.9: 6509.61 P99.99: 9863.29 ------------------------------------------------------ [ 0, 1 ] 304 2.792% 2.792% # ( 1, 2 ] 4964 45.583% 48.375% ######### ( 2, 3 ] 2341 21.497% 69.871% #### ( 3, 4 ] 1217 11.175% 81.047% ## ( 4, 6 ] 810 7.438% 88.485% # ( 6, 10 ] 258 2.369% 90.854% ( 10, 15 ] 37 0.340% 91.194% ( 15, 22 ] 4 0.037% 91.230% ( 22, 34 ] 1 0.009% 91.240% ( 34, 51 ] 1 0.009% 91.249% ( 51, 76 ] 1 0.009% 91.258% ( 76, 110 ] 5 0.046% 91.304% ( 110, 170 ] 36 0.331% 91.635% ( 170, 250 ] 48 0.441% 92.075% ( 250, 380 ] 91 0.836% 92.911% ( 380, 580 ] 132 1.212% 94.123% ( 580, 870 ] 184 1.690% 95.813% ( 870, 1300 ] 156 1.433% 97.245% ( 1300, 1900 ] 91 0.836% 98.081% ( 1900, 2900 ] 75 0.689% 98.770% ( 2900, 4400 ] 79 0.725% 99.495% ( 4400, 6600 ] 46 0.422% 99.917% ( 6600, 9900 ] 8 0.073% 99.991% ( 9900, 14000 ] 1 0.009% 100.000% ( 33000, 50000 ] 2 0.018% 100.018% ** Level 5 read latency histogram (micros): Count: 100 Average: 1157.1300 StdDev: 1464.11 Min: 83 Median: 522.8571 Max: 8473 Percentiles: P50: 522.86 P75: 1600.00 P99: 6600.00 P99.9: 8473.00 P99.99: 8473.00 ------------------------------------------------------ ( 76, 110 ] 9 9.000% 9.000% ## ( 110, 170 ] 18 18.000% 27.000% #### ( 170, 250 ] 5 5.000% 32.000% # ( 250, 380 ] 13 13.000% 45.000% ### ( 380, 580 ] 7 7.000% 52.000% # ( 580, 870 ] 13 13.000% 65.000% ### ( 870, 1300 ] 5 5.000% 70.000% # ( 1300, 1900 ] 10 10.000% 80.000% ## ( 1900, 2900 ] 6 6.000% 86.000% # ( 2900, 4400 ] 10 10.000% 96.000% ## ( 4400, 6600 ] 3 3.000% 99.000% # ( 6600, 9900 ] 1 1.000% 100.000% ** DB Stats ** Uptime(secs): 32.1 total, 3.5 interval Cumulative writes: 0 writes, 8000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 7.69 GB, 245.04 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:10.313 H:M:S, 32.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 277.97 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.838 H:M:S, 23.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/13-12:18:25 ... thread 0: (1000000,9000000) ops and (60948.2,186250.4) ops/second in (16.407366,48.322048) 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/13 2.89 GB 44.1 7.5 0.0 7.5 16.0 8.5 0.0 1.9 135.6 290.0 56.65 51.21 149 0.380 7802K 11K 0.0 0.0 L1 16/16 1.87 GB 0.0 8.0 5.5 2.5 7.9 5.4 0.2 1.4 224.9 222.1 36.24 34.27 4 9.060 8068K 40K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.3 0.2 0.2 0.3 0.2 3.5 1.8 246.3 246.1 1.41 1.36 2 0.707 353K 207 0.0 0.0 L3 18/0 965.93 MB 1.0 4.7 2.6 2.1 4.7 2.6 1.1 1.8 171.4 170.4 28.12 22.13 20 1.406 4894K 28K 0.0 0.0 L4 170/0 9.51 GB 1.0 3.1 2.8 0.3 3.1 2.8 0.8 1.1 134.4 134.0 23.76 15.10 37 0.642 3182K 4758 0.0 0.0 L5 1084/0 89.32 GB 0.9 0.0 0.0 0.0 0.0 0.0 3.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1304/29 104.54 GB 0.0 23.6 11.1 12.6 32.0 19.5 9.2 3.7 165.5 224.4 146.18 124.07 212 0.690 24M 85K 0.0 0.0 Int 0/0 0.00 KB 0.0 23.6 11.1 12.6 32.0 19.5 9.2 3.7 165.5 224.4 146.18 124.07 212 0.690 24M 85K 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 23.6 11.1 12.6 23.5 10.9 0.0 0.0 203.1 201.8 119.15 101.45 88 1.354 24M 85K 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 323.9 27.03 22.62 124 0.218 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 48.5 total, 48.3 interval Flush(GB): cumulative 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.03 GB write, 675.75 MB/s write, 23.63 GB read, 498.44 MB/s read, 146.2 seconds Interval compaction: 32.03 GB write, 678.76 MB/s write, 23.63 GB read, 500.66 MB/s read, 146.2 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 20, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 20, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 50, pending-compaction-bytes-delays: 27, pending-compaction-bytes-stops: 0, total-delays: 47, total-stops: 50, interval: 97 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3686542 Average: 2.7217 StdDev: 30.01 Min: 0 Median: 1.5199 Max: 28419 Percentiles: P50: 1.52 P75: 1.91 P99: 6.26 P99.9: 97.12 P99.99: 418.10 ------------------------------------------------------ [ 0, 1 ] 616944 16.735% 16.735% ### ( 1, 2 ] 2358959 63.988% 80.723% ############# ( 2, 3 ] 412568 11.191% 91.915% ## ( 3, 4 ] 146908 3.985% 95.900% # ( 4, 6 ] 112374 3.048% 98.948% # ( 6, 10 ] 29338 0.796% 99.744% ( 10, 15 ] 4046 0.110% 99.853% ( 15, 22 ] 543 0.015% 99.868% ( 22, 34 ] 59 0.002% 99.870% ( 34, 51 ] 26 0.001% 99.870% ( 51, 76 ] 54 0.001% 99.872% ( 76, 110 ] 1670 0.045% 99.917% ( 110, 170 ] 1634 0.044% 99.962% ( 170, 250 ] 520 0.014% 99.976% ( 250, 380 ] 442 0.012% 99.988% ( 380, 580 ] 469 0.013% 100.000% ( 580, 870 ] 384 0.010% 100.011% ( 870, 1300 ] 266 0.007% 100.018% ( 1300, 1900 ] 107 0.003% 100.021% ( 1900, 2900 ] 64 0.002% 100.023% ( 2900, 4400 ] 48 0.001% 100.024% ( 4400, 6600 ] 12 0.000% 100.024% ( 6600, 9900 ] 1 0.000% 100.024% ( 9900, 14000 ] 1 0.000% 100.024% ( 22000, 33000 ] 1 0.000% 100.024% ** Level 1 read latency histogram (micros): Count: 1488025 Average: 4.2631 StdDev: 62.38 Min: 1 Median: 1.6785 Max: 13816 Percentiles: P50: 1.68 P75: 2.47 P99: 8.96 P99.9: 121.72 P99.99: 359.38 ------------------------------------------------------ [ 0, 1 ] 194091 13.044% 13.044% ### ( 1, 2 ] 810541 54.471% 67.514% ########### ( 2, 3 ] 239405 16.089% 83.603% ### ( 3, 4 ] 103606 6.963% 90.566% # ( 4, 6 ] 104280 7.008% 97.574% # ( 6, 10 ] 28645 1.925% 99.499% ( 10, 15 ] 3930 0.264% 99.763% ( 15, 22 ] 598 0.040% 99.803% ( 22, 34 ] 57 0.004% 99.807% ( 34, 51 ] 19 0.001% 99.808% ( 51, 76 ] 157 0.011% 99.819% ( 76, 110 ] 1054 0.071% 99.890% ( 110, 170 ] 788 0.053% 99.943% ( 170, 250 ] 335 0.023% 99.965% ( 250, 380 ] 440 0.030% 99.995% ( 380, 580 ] 510 0.034% 100.029% ( 580, 870 ] 446 0.030% 100.059% ( 870, 1300 ] 311 0.021% 100.080% ( 1300, 1900 ] 146 0.010% 100.090% ( 1900, 2900 ] 100 0.007% 100.096% ( 2900, 4400 ] 114 0.008% 100.104% ( 4400, 6600 ] 42 0.003% 100.107% ( 6600, 9900 ] 20 0.001% 100.108% ( 9900, 14000 ] 2 0.000% 100.108% ** Level 2 read latency histogram (micros): Count: 100660 Average: 2.9579 StdDev: 36.75 Min: 1 Median: 1.4707 Max: 4056 Percentiles: P50: 1.47 P75: 1.89 P99: 6.67 P99.9: 188.11 P99.99: 1890.10 ------------------------------------------------------ [ 0, 1 ] 22312 22.166% 22.166% #### ( 1, 2 ] 59520 59.130% 81.295% ############ ( 2, 3 ] 10319 10.251% 91.547% ## ( 3, 4 ] 3960 3.934% 95.481% # ( 4, 6 ] 3410 3.388% 98.868% # ( 6, 10 ] 786 0.781% 99.649% ( 10, 15 ] 139 0.138% 99.787% ( 15, 22 ] 36 0.036% 99.823% ( 22, 34 ] 3 0.003% 99.826% ( 34, 51 ] 29 0.029% 99.855% ( 51, 76 ] 2 0.002% 99.857% ( 76, 110 ] 2 0.002% 99.859% ( 110, 170 ] 35 0.035% 99.894% ( 170, 250 ] 28 0.028% 99.922% ( 250, 380 ] 22 0.022% 99.943% ( 380, 580 ] 21 0.021% 99.964% ( 580, 870 ] 20 0.020% 99.984% ( 870, 1300 ] 2 0.002% 99.986% ( 1300, 1900 ] 4 0.004% 99.990% ( 1900, 2900 ] 5 0.005% 99.995% ( 2900, 4400 ] 5 0.005% 100.000% ** Level 3 read latency histogram (micros): Count: 1051314 Average: 4.4019 StdDev: 51.41 Min: 1 Median: 1.9819 Max: 7751 Percentiles: P50: 1.98 P75: 2.99 P99: 8.73 P99.9: 13.96 P99.99: 18.63 ------------------------------------------------------ [ 0, 1 ] 17734 1.687% 1.687% ( 1, 2 ] 517312 49.206% 50.893% ########## ( 2, 3 ] 254761 24.233% 75.126% ##### ( 3, 4 ] 116527 11.084% 86.210% ## ( 4, 6 ] 120043 11.418% 97.628% ## ( 6, 10 ] 21125 2.009% 99.637% ( 10, 15 ] 3485 0.331% 99.969% ( 15, 22 ] 428 0.041% 100.010% ( 22, 34 ] 36 0.003% 100.013% ( 34, 51 ] 7 0.001% 100.014% ( 51, 76 ] 14 0.001% 100.015% ( 76, 110 ] 27 0.003% 100.018% ( 110, 170 ] 106 0.010% 100.028% ( 170, 250 ] 186 0.018% 100.045% ( 250, 380 ] 290 0.028% 100.073% ( 380, 580 ] 335 0.032% 100.105% ( 580, 870 ] 346 0.033% 100.138% ( 870, 1300 ] 233 0.022% 100.160% ( 1300, 1900 ] 95 0.009% 100.169% ( 1900, 2900 ] 86 0.008% 100.177% ( 2900, 4400 ] 76 0.007% 100.184% ( 4400, 6600 ] 11 0.001% 100.185% ( 6600, 9900 ] 3 0.000% 100.186% ** Level 4 read latency histogram (micros): Count: 76519 Average: 47.1568 StdDev: 364.14 Min: 0 Median: 2.0492 Max: 35388 Percentiles: P50: 2.05 P75: 3.30 P99: 1221.39 P99.9: 4340.33 P99.99: 6175.87 ------------------------------------------------------ [ 0, 1 ] 1471 1.922% 1.922% ( 1, 2 ] 35930 46.956% 48.878% ######### ( 2, 3 ] 17436 22.786% 71.665% ##### ( 3, 4 ] 8618 11.263% 82.927% ## ( 4, 6 ] 7615 9.952% 92.879% ## ( 6, 10 ] 2042 2.669% 95.548% # ( 10, 15 ] 271 0.354% 95.902% ( 15, 22 ] 31 0.041% 95.942% ( 22, 34 ] 7 0.009% 95.951% ( 34, 51 ] 4 0.005% 95.957% ( 51, 76 ] 6 0.008% 95.964% ( 76, 110 ] 48 0.063% 96.027% ( 110, 170 ] 192 0.251% 96.278% ( 170, 250 ] 263 0.344% 96.622% ( 250, 380 ] 333 0.435% 97.057% ( 380, 580 ] 514 0.672% 97.729% ( 580, 870 ] 592 0.774% 98.502% ( 870, 1300 ] 466 0.609% 99.111% ( 1300, 1900 ] 237 0.310% 99.421% ( 1900, 2900 ] 185 0.242% 99.663% ( 2900, 4400 ] 189 0.247% 99.910% ( 4400, 6600 ] 76 0.099% 100.009% ( 6600, 9900 ] 11 0.014% 100.024% ( 9900, 14000 ] 1 0.001% 100.025% ( 33000, 50000 ] 2 0.003% 100.027% ** Level 5 read latency histogram (micros): Count: 220 Average: 1100.9773 StdDev: 1387.94 Min: 79 Median: 455.0000 Max: 8542 Percentiles: P50: 455.00 P75: 1600.00 P99: 6512.00 P99.9: 8542.00 P99.99: 8542.00 ------------------------------------------------------ ( 76, 110 ] 20 9.091% 9.091% ## ( 110, 170 ] 31 14.091% 23.182% ### ( 170, 250 ] 19 8.636% 31.818% ## ( 250, 380 ] 31 14.091% 45.909% ### ( 380, 580 ] 24 10.909% 56.818% ## ( 580, 870 ] 18 8.182% 65.000% ## ( 870, 1300 ] 13 5.909% 70.909% # ( 1300, 1900 ] 18 8.182% 79.091% ## ( 1900, 2900 ] 21 9.545% 88.636% ## ( 2900, 4400 ] 18 8.182% 96.818% ## ( 4400, 6600 ] 5 2.273% 99.091% ( 6600, 9900 ] 2 0.909% 100.000% ** DB Stats ** Uptime(secs): 48.5 total, 16.4 interval Cumulative writes: 0 writes, 9000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 8.65 GB, 182.49 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:23.209 H:M:S, 47.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 59.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:12.896 H:M:S, 78.6 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/13-12:18:29 ... thread 0: (1000000,10000000) ops and (254194.2,191365.4) ops/second in (3.934000,52.256048) 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/9 3.87 GB 176.2 8.6 0.0 8.6 18.1 9.5 0.0 1.9 138.0 290.7 63.88 58.03 167 0.383 8954K 13K 0.0 0.0 L1 16/16 1.87 GB 0.0 8.0 5.5 2.5 7.9 5.4 0.2 1.4 224.9 222.1 36.24 34.27 4 9.060 8068K 40K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.3 0.2 0.2 0.3 0.2 3.5 1.8 246.3 246.1 1.41 1.36 2 0.707 353K 207 0.0 0.0 L3 18/0 965.93 MB 1.0 4.7 2.6 2.1 4.7 2.6 1.1 1.8 171.4 170.4 28.12 22.13 20 1.406 4894K 28K 0.0 0.0 L4 170/0 9.51 GB 1.0 3.1 2.8 0.3 3.1 2.8 0.8 1.1 134.4 134.0 23.76 15.10 37 0.642 3182K 4758 0.0 0.0 L5 1084/0 89.32 GB 0.9 0.0 0.0 0.0 0.0 0.0 3.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1306/25 105.52 GB 0.0 24.7 11.1 13.7 34.1 20.5 9.2 3.6 165.1 227.8 153.41 130.89 230 0.667 25M 87K 0.0 0.0 Int 0/0 0.00 KB 0.0 24.7 11.1 13.7 34.1 20.5 9.2 3.6 165.1 227.8 153.41 130.89 230 0.667 25M 87K 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.7 11.1 13.7 24.6 10.9 0.0 0.0 205.2 204.0 123.43 105.66 92 1.342 25M 87K 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 325.7 29.98 25.23 138 0.217 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.5 total, 52.3 interval Flush(GB): cumulative 9.536, interval 9.536 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 34.12 GB write, 665.88 MB/s write, 24.73 GB read, 482.68 MB/s read, 153.4 seconds Interval compaction: 34.12 GB write, 668.63 MB/s write, 24.73 GB read, 484.67 MB/s read, 153.4 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 23, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 23, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 54, pending-compaction-bytes-delays: 27, pending-compaction-bytes-stops: 0, total-delays: 50, total-stops: 54, interval: 104 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 4097453 Average: 2.6833 StdDev: 28.66 Min: 0 Median: 1.5196 Max: 28419 Percentiles: P50: 1.52 P75: 1.91 P99: 6.16 P99.9: 92.69 P99.99: 379.80 ------------------------------------------------------ [ 0, 1 ] 678006 16.547% 16.547% ### ( 1, 2 ] 2637783 64.376% 80.923% ############# ( 2, 3 ] 458636 11.193% 92.116% ## ( 3, 4 ] 160432 3.915% 96.032% # ( 4, 6 ] 120359 2.937% 98.969% # ( 6, 10 ] 32165 0.785% 99.754% ( 10, 15 ] 4402 0.107% 99.862% ( 15, 22 ] 569 0.014% 99.876% ( 22, 34 ] 61 0.001% 99.877% ( 34, 51 ] 30 0.001% 99.878% ( 51, 76 ] 57 0.001% 99.879% ( 76, 110 ] 1743 0.043% 99.922% ( 110, 170 ] 1761 0.043% 99.965% ( 170, 250 ] 566 0.014% 99.978% ( 250, 380 ] 474 0.012% 99.990% ( 380, 580 ] 501 0.012% 100.002% ( 580, 870 ] 398 0.010% 100.012% ( 870, 1300 ] 271 0.007% 100.019% ( 1300, 1900 ] 110 0.003% 100.021% ( 1900, 2900 ] 66 0.002% 100.023% ( 2900, 4400 ] 48 0.001% 100.024% ( 4400, 6600 ] 12 0.000% 100.024% ( 6600, 9900 ] 1 0.000% 100.024% ( 9900, 14000 ] 1 0.000% 100.024% ( 22000, 33000 ] 1 0.000% 100.024% ** Level 1 read latency histogram (micros): Count: 1560782 Average: 4.1901 StdDev: 60.96 Min: 1 Median: 1.6713 Max: 13816 Percentiles: P50: 1.67 P75: 2.43 P99: 8.94 P99.9: 124.20 P99.99: 362.66 ------------------------------------------------------ [ 0, 1 ] 203513 13.039% 13.039% ### ( 1, 2 ] 859360 55.060% 68.099% ########### ( 2, 3 ] 248452 15.918% 84.017% ### ( 3, 4 ] 106147 6.801% 90.818% # ( 4, 6 ] 105914 6.786% 97.604% # ( 6, 10 ] 29669 1.901% 99.505% ( 10, 15 ] 3995 0.256% 99.761% ( 15, 22 ] 608 0.039% 99.800% ( 22, 34 ] 58 0.004% 99.804% ( 34, 51 ] 20 0.001% 99.805% ( 51, 76 ] 158 0.010% 99.815% ( 76, 110 ] 1128 0.072% 99.887% ( 110, 170 ] 842 0.054% 99.941% ( 170, 250 ] 365 0.023% 99.965% ( 250, 380 ] 458 0.029% 99.994% ( 380, 580 ] 521 0.033% 100.027% ( 580, 870 ] 450 0.029% 100.056% ( 870, 1300 ] 312 0.020% 100.076% ( 1300, 1900 ] 146 0.009% 100.085% ( 1900, 2900 ] 100 0.006% 100.092% ( 2900, 4400 ] 114 0.007% 100.099% ( 4400, 6600 ] 42 0.003% 100.102% ( 6600, 9900 ] 20 0.001% 100.103% ( 9900, 14000 ] 2 0.000% 100.103% ** Level 2 read latency histogram (micros): Count: 100660 Average: 2.9579 StdDev: 36.75 Min: 1 Median: 1.4707 Max: 4056 Percentiles: P50: 1.47 P75: 1.89 P99: 6.67 P99.9: 188.11 P99.99: 1890.10 ------------------------------------------------------ [ 0, 1 ] 22312 22.166% 22.166% #### ( 1, 2 ] 59520 59.130% 81.295% ############ ( 2, 3 ] 10319 10.251% 91.547% ## ( 3, 4 ] 3960 3.934% 95.481% # ( 4, 6 ] 3410 3.388% 98.868% # ( 6, 10 ] 786 0.781% 99.649% ( 10, 15 ] 139 0.138% 99.787% ( 15, 22 ] 36 0.036% 99.823% ( 22, 34 ] 3 0.003% 99.826% ( 34, 51 ] 29 0.029% 99.855% ( 51, 76 ] 2 0.002% 99.857% ( 76, 110 ] 2 0.002% 99.859% ( 110, 170 ] 35 0.035% 99.894% ( 170, 250 ] 28 0.028% 99.922% ( 250, 380 ] 22 0.022% 99.943% ( 380, 580 ] 21 0.021% 99.964% ( 580, 870 ] 20 0.020% 99.984% ( 870, 1300 ] 2 0.002% 99.986% ( 1300, 1900 ] 4 0.004% 99.990% ( 1900, 2900 ] 5 0.005% 99.995% ( 2900, 4400 ] 5 0.005% 100.000% ** Level 3 read latency histogram (micros): Count: 1051314 Average: 4.4019 StdDev: 51.41 Min: 1 Median: 1.9819 Max: 7751 Percentiles: P50: 1.98 P75: 2.99 P99: 8.73 P99.9: 13.96 P99.99: 18.63 ------------------------------------------------------ [ 0, 1 ] 17734 1.687% 1.687% ( 1, 2 ] 517312 49.206% 50.893% ########## ( 2, 3 ] 254761 24.233% 75.126% ##### ( 3, 4 ] 116527 11.084% 86.210% ## ( 4, 6 ] 120043 11.418% 97.628% ## ( 6, 10 ] 21125 2.009% 99.637% ( 10, 15 ] 3485 0.331% 99.969% ( 15, 22 ] 428 0.041% 100.010% ( 22, 34 ] 36 0.003% 100.013% ( 34, 51 ] 7 0.001% 100.014% ( 51, 76 ] 14 0.001% 100.015% ( 76, 110 ] 27 0.003% 100.018% ( 110, 170 ] 106 0.010% 100.028% ( 170, 250 ] 186 0.018% 100.045% ( 250, 380 ] 290 0.028% 100.073% ( 380, 580 ] 335 0.032% 100.105% ( 580, 870 ] 346 0.033% 100.138% ( 870, 1300 ] 233 0.022% 100.160% ( 1300, 1900 ] 95 0.009% 100.169% ( 1900, 2900 ] 86 0.008% 100.177% ( 2900, 4400 ] 76 0.007% 100.184% ( 4400, 6600 ] 11 0.001% 100.185% ( 6600, 9900 ] 3 0.000% 100.186% ** Level 4 read latency histogram (micros): Count: 76519 Average: 47.1568 StdDev: 364.14 Min: 0 Median: 2.0492 Max: 35388 Percentiles: P50: 2.05 P75: 3.30 P99: 1221.39 P99.9: 4340.33 P99.99: 6175.87 ------------------------------------------------------ [ 0, 1 ] 1471 1.922% 1.922% ( 1, 2 ] 35930 46.956% 48.878% ######### ( 2, 3 ] 17436 22.786% 71.665% ##### ( 3, 4 ] 8618 11.263% 82.927% ## ( 4, 6 ] 7615 9.952% 92.879% ## ( 6, 10 ] 2042 2.669% 95.548% # ( 10, 15 ] 271 0.354% 95.902% ( 15, 22 ] 31 0.041% 95.942% ( 22, 34 ] 7 0.009% 95.951% ( 34, 51 ] 4 0.005% 95.957% ( 51, 76 ] 6 0.008% 95.964% ( 76, 110 ] 48 0.063% 96.027% ( 110, 170 ] 192 0.251% 96.278% ( 170, 250 ] 263 0.344% 96.622% ( 250, 380 ] 333 0.435% 97.057% ( 380, 580 ] 514 0.672% 97.729% ( 580, 870 ] 592 0.774% 98.502% ( 870, 1300 ] 466 0.609% 99.111% ( 1300, 1900 ] 237 0.310% 99.421% ( 1900, 2900 ] 185 0.242% 99.663% ( 2900, 4400 ] 189 0.247% 99.910% ( 4400, 6600 ] 76 0.099% 100.009% ( 6600, 9900 ] 11 0.014% 100.024% ( 9900, 14000 ] 1 0.001% 100.025% ( 33000, 50000 ] 2 0.003% 100.027% ** Level 5 read latency histogram (micros): Count: 220 Average: 1100.9773 StdDev: 1387.94 Min: 79 Median: 455.0000 Max: 8542 Percentiles: P50: 455.00 P75: 1600.00 P99: 6512.00 P99.9: 8542.00 P99.99: 8542.00 ------------------------------------------------------ ( 76, 110 ] 20 9.091% 9.091% ## ( 110, 170 ] 31 14.091% 23.182% ### ( 170, 250 ] 19 8.636% 31.818% ## ( 250, 380 ] 31 14.091% 45.909% ### ( 380, 580 ] 24 10.909% 56.818% ## ( 580, 870 ] 18 8.182% 65.000% ## ( 870, 1300 ] 13 5.909% 70.909% # ( 1300, 1900 ] 18 8.182% 79.091% ## ( 1900, 2900 ] 21 9.545% 88.636% ## ( 2900, 4400 ] 18 8.182% 96.818% ## ( 4400, 6600 ] 5 2.273% 99.091% ( 6600, 9900 ] 2 0.909% 100.000% ** DB Stats ** Uptime(secs): 52.5 total, 3.9 interval Cumulative writes: 0 writes, 10M keys, 0 commit groups, 0.0 writes per commit group, ingest: 9.61 GB, 187.56 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:24.437 H:M:S, 46.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 250.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:1.228 H:M:S, 31.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 using bdev Nvme0n1 Initializing RocksDB Options from the specified file Initializing RocksDB Options from command-line flags Integrated BlobDB: blob cache disabled Keys: 16 bytes each (+ 0 bytes user-defined timestamp) Values: 1000 bytes each (1000 bytes after compression) Entries: 100000000 Prefix: 0 bytes Keys per prefix: 0 RawSize: 96893.3 MB (estimated) FileSize: 96893.3 MB (estimated) Write rate: 0 bytes/second Read rate: 0 ops/second Compression: NoCompression Compression sampling rate: 0 Memtablerep: SkipListFactory Perf Level: 1 ------------------------------------------------ DB path: [/mnt/rocksdb] overwrite : 5.889 micros/op 169813 ops/sec 60.001 seconds 10188999 operations; 164.5 MB/s Microseconds per write: Count: 10188999 Average: 5.8888 StdDev: 354.14 Min: 0 Median: 1.7416 Max: 598756 Percentiles: P50: 1.74 P75: 2.77 P99: 9.80 P99.9: 1150.92 P99.99: 2707.72 ------------------------------------------------------ [ 0, 1 ] 1376130 13.506% 13.506% ### ( 1, 2 ] 5013940 49.209% 62.715% ########## ( 2, 3 ] 1624590 15.945% 78.660% ### ( 3, 4 ] 1379296 13.537% 92.197% ### ( 4, 6 ] 553469 5.432% 97.629% # ( 6, 10 ] 146893 1.442% 99.071% ( 10, 15 ] 50593 0.497% 99.567% ( 15, 22 ] 10627 0.104% 99.672% ( 22, 34 ] 1913 0.019% 99.690% ( 34, 51 ] 279 0.003% 99.693% ( 51, 76 ] 40 0.000% 99.694% ( 76, 110 ] 7013 0.069% 99.762% ( 110, 170 ] 2767 0.027% 99.789% ( 170, 250 ] 332 0.003% 99.793% ( 250, 380 ] 240 0.002% 99.795% ( 380, 580 ] 64 0.001% 99.796% ( 580, 870 ] 41 0.000% 99.796% ( 870, 1300 ] 16199 0.159% 99.955% ( 1300, 1900 ] 114 0.001% 99.956% ( 1900, 2900 ] 4259 0.042% 99.998% ( 2900, 4400 ] 147 0.001% 99.999% ( 4400, 6600 ] 24 0.000% 100.000% ( 6600, 9900 ] 3 0.000% 100.000% ( 9900, 14000 ] 2 0.000% 100.000% ( 14000, 22000 ] 2 0.000% 100.000% ( 22000, 33000 ] 2 0.000% 100.000% ( 33000, 50000 ] 1 0.000% 100.000% ( 75000, 110000 ] 1 0.000% 100.000% ( 170000, 250000 ] 15 0.000% 100.000% ( 250000, 380000 ] 1 0.000% 100.000% ( 380000, 570000 ] 1 0.000% 100.000% ( 570000, 860000 ] 1 0.000% 100.000% STATISTICS: rocksdb.block.cache.miss COUNT : 0 rocksdb.block.cache.hit COUNT : 0 rocksdb.block.cache.add COUNT : 0 rocksdb.block.cache.add.failures COUNT : 0 rocksdb.block.cache.index.miss COUNT : 0 rocksdb.block.cache.index.hit COUNT : 0 rocksdb.block.cache.index.add COUNT : 0 rocksdb.block.cache.index.bytes.insert COUNT : 0 rocksdb.block.cache.filter.miss COUNT : 0 rocksdb.block.cache.filter.hit COUNT : 0 rocksdb.block.cache.filter.add COUNT : 0 rocksdb.block.cache.filter.bytes.insert COUNT : 0 rocksdb.block.cache.data.miss COUNT : 0 rocksdb.block.cache.data.hit COUNT : 0 rocksdb.block.cache.data.add COUNT : 0 rocksdb.block.cache.data.bytes.insert COUNT : 0 rocksdb.block.cache.bytes.read COUNT : 0 rocksdb.block.cache.bytes.write COUNT : 0 rocksdb.bloom.filter.useful COUNT : 0 rocksdb.bloom.filter.full.positive COUNT : 0 rocksdb.bloom.filter.full.true.positive COUNT : 0 rocksdb.persistent.cache.hit COUNT : 0 rocksdb.persistent.cache.miss COUNT : 0 rocksdb.sim.block.cache.hit COUNT : 0 rocksdb.sim.block.cache.miss COUNT : 0 rocksdb.memtable.hit COUNT : 0 rocksdb.memtable.miss COUNT : 0 rocksdb.l0.hit COUNT : 0 rocksdb.l1.hit COUNT : 0 rocksdb.l2andup.hit COUNT : 0 rocksdb.compaction.key.drop.new COUNT : 207619 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 : 10188999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 10515046968 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 : 522 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 31340426 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 : 30679679934 rocksdb.compact.write.bytes COUNT : 30484022798 rocksdb.flush.write.bytes COUNT : 10503099298 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 : 53 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 : 213 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 : 10418372608 rocksdb.memtable.garbage.bytes.at.flush COUNT : 4012032 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 : 30773432105 rocksdb.non.last.level.read.count COUNT : 7436540 rocksdb.block.checksum.compute.count COUNT : 7435549 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.391306 P95 : 3.958605 P99 : 8.509888 P100 : 598754.000000 COUNT : 10188999 SUM : 55136251 rocksdb.compaction.times.micros P50 : 986410.256410 P95 : 2575000.000000 P99 : 14560000.000000 P100 : 17931189.000000 COUNT : 93 SUM : 124361993 rocksdb.compaction.times.cpu_micros P50 : 893055.555556 P95 : 1854500.000000 P99 : 14560000.000000 P100 : 16703866.000000 COUNT : 93 SUM : 106573346 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 : 688.750000 P95 : 2350.000000 P99 : 12278.000000 P100 : 39241.000000 COUNT : 142 SUM : 157337 rocksdb.compaction.outfile.sync.micros P50 : 1046.898734 P95 : 82816.666667 P99 : 139640.000000 P100 : 186581.000000 COUNT : 353 SUM : 4175184 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 : 100.437500 P95 : 1216.150000 P99 : 2752.500000 P100 : 6295.000000 COUNT : 259 SUM : 70644 rocksdb.table.open.io.micros P50 : 1462.962963 P95 : 6440.689655 P99 : 11799.666667 P100 : 20308.000000 COUNT : 522 SUM : 1065424 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.639454 P95 : 7.752138 P99 : 10.247151 P100 : 35396.000000 COUNT : 7434236 SUM : 42714496 rocksdb.read.block.get.micros P50 : 428.979592 P95 : 3233.962264 P99 : 4536.888889 P100 : 8660.000000 COUNT : 1044 SUM : 878190 rocksdb.write.raw.block.micros P50 : 0.513328 P95 : 0.975322 P99 : 2.958375 P100 : 39388.000000 COUNT : 9926986 SUM : 19699251 rocksdb.numfiles.in.singlecompaction P50 : 3.052632 P95 : 4.600000 P99 : 21.230000 P100 : 25.000000 COUNT : 122 SUM : 441 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.559860 P95 : 1160.474373 P99 : 2473.787879 P100 : 598546.000000 COUNT : 193932 SUM : 31361750 rocksdb.sst.read.micros P50 : 1.590042 P95 : 4.630791 P99 : 8.050335 P100 : 35388.000000 COUNT : 7437003 SUM : 27459766 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 : 10188999 SUM : 10515046968 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 : 213564.356436 P95 : 379277.777778 P99 : 654100.000000 P100 : 751254.000000 COUNT : 142 SUM : 30718804 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 : 334 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