[2024-07-15 05:00:40.748722] Starting SPDK v24.01.1-pre git sha1 4b94202c6 / DPDK 23.11.0 initialization... [2024-07-15 05:00:40.748982] [ DPDK EAL parameters: rocksdb --no-shconf -c 0x1 --huge-unlink --no-telemetry --log-level=lib.eal:6 --log-level=lib.cryptodev:5 --log-level=user1:6 --base-virtaddr=0x200000000000 --match-allocations --file-prefix=spdk_pid1869408 ] Set seed to 1721012440742322 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-07-15 05:00:40.859007] app.c: 798:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-07-15 05:00:40.898727] app.c: 488:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-07-15 05:00:40.898779] app.c: 489:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 1869408' to capture a snapshot of events at runtime. [2024-07-15 05:00:40.898791] app.c: 494:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid1869408 for offline analysis/debug. [2024-07-15 05:00:40.898813] reactor.c: 937:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Mon Jul 15 05:00:45 2024 CPU: 96 * Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz CPUCache: 36608 KB 2024/07/15-05:00:48 ... thread 0: (1000000,1000000) ops and (338353.6,338353.6) ops/second in (2.955488,2.955488) 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 8/8 566.98 MB 0.0 0.0 0.0 0.0 0.9 0.9 0.0 1.0 0.0 354.9 2.48 2.25 12 0.207 0 0 0.0 0.0 L1 3/3 188.86 MB 0.0 0.2 0.2 0.0 0.2 0.2 0.1 1.0 257.5 257.3 0.73 0.70 1 0.734 191K 96 0.0 0.0 L2 2/1 125.96 MB 0.0 0.1 0.1 0.1 0.1 0.1 0.1 2.0 231.6 231.6 0.54 0.52 1 0.544 127K 37 0.0 0.0 L3 9/0 741.45 MB 0.7 0.0 0.0 0.0 0.0 0.0 0.1 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 116/0 9.54 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1044/0 85.88 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1182/12 97.00 GB 0.0 0.3 0.2 0.1 1.2 1.1 0.9 1.4 83.7 318.1 3.76 3.48 14 0.269 319K 133 0.0 0.0 Int 0/0 0.00 KB 0.0 0.3 0.2 0.1 1.2 1.1 0.5 1.4 83.7 318.1 3.76 3.48 14 0.269 319K 133 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.1 0.3 0.2 0.0 0.0 246.5 246.4 1.28 1.23 2 0.639 319K 133 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 354.9 2.48 2.25 12 0.207 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 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.17 GB write, 378.35 MB/s write, 0.31 GB read, 99.58 MB/s read, 3.8 seconds Interval compaction: 1.17 GB write, 404.64 MB/s write, 0.31 GB read, 106.50 MB/s read, 3.8 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 2, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 2, interval: 2 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 122974 Average: 1.8792 StdDev: 14.30 Min: 1 Median: 1.2229 Max: 3188 Percentiles: P50: 1.22 P75: 1.67 P99: 4.88 P99.9: 10.72 P99.99: 226.20 ------------------------------------------------------ [ 0, 1 ] 46215 37.581% 37.581% ######## ( 1, 2 ] 68520 55.719% 93.300% ########### ( 2, 3 ] 4513 3.670% 96.970% # ( 3, 4 ] 2003 1.629% 98.599% ( 4, 6 ] 1123 0.913% 99.512% ( 6, 10 ] 466 0.379% 99.891% ( 10, 15 ] 84 0.068% 99.959% ( 15, 22 ] 19 0.015% 99.975% ( 22, 34 ] 4 0.003% 99.978% ( 34, 51 ] 3 0.002% 99.980% ( 51, 76 ] 2 0.002% 99.982% ( 110, 170 ] 10 0.008% 99.990% ( 170, 250 ] 1 0.001% 99.991% ( 250, 380 ] 6 0.005% 99.996% ( 380, 580 ] 1 0.001% 99.997% ( 870, 1300 ] 3 0.002% 99.999% ( 1300, 1900 ] 1 0.001% 100.000% ( 1900, 2900 ] 1 0.001% 100.001% ( 2900, 4400 ] 1 0.001% 100.002% ** Level 1 read latency histogram (micros): Count: 27163 Average: 1.8621 StdDev: 6.08 Min: 1 Median: 1.2758 Max: 821 Percentiles: P50: 1.28 P75: 1.70 P99: 4.65 P99.9: 10.91 P99.99: 286.88 ------------------------------------------------------ [ 0, 1 ] 9197 33.859% 33.859% ####### ( 1, 2 ] 15896 58.521% 92.379% ############ ( 2, 3 ] 1233 4.539% 96.919% # ( 3, 4 ] 477 1.756% 98.675% ( 4, 6 ] 275 1.012% 99.687% ( 6, 10 ] 55 0.202% 99.890% ( 10, 15 ] 21 0.077% 99.967% ( 15, 22 ] 5 0.018% 99.985% ( 51, 76 ] 1 0.004% 99.989% ( 170, 250 ] 1 0.004% 99.993% ( 250, 380 ] 1 0.004% 99.996% ( 380, 580 ] 1 0.004% 100.000% ( 580, 870 ] 1 0.004% 100.004% ** Level 2 read latency histogram (micros): Count: 19229 Average: 2.7040 StdDev: 31.47 Min: 0 Median: 1.4738 Max: 2494 Percentiles: P50: 1.47 P75: 1.88 P99: 6.07 P99.9: 14.04 P99.99: 1938.55 ------------------------------------------------------ [ 0, 1 ] 4033 20.974% 20.974% #### ( 1, 2 ] 11781 61.267% 82.240% ############ ( 2, 3 ] 1638 8.518% 90.759% ## ( 3, 4 ] 950 4.940% 95.699% # ( 4, 6 ] 633 3.292% 98.991% # ( 6, 10 ] 158 0.822% 99.813% ( 10, 15 ] 22 0.114% 99.927% ( 15, 22 ] 2 0.010% 99.938% ( 22, 34 ] 1 0.005% 99.943% ( 51, 76 ] 1 0.005% 99.948% ( 76, 110 ] 1 0.005% 99.953% ( 170, 250 ] 2 0.010% 99.964% ( 250, 380 ] 2 0.010% 99.974% ( 380, 580 ] 1 0.005% 99.979% ( 580, 870 ] 1 0.005% 99.984% ( 1300, 1900 ] 2 0.010% 99.995% ( 1900, 2900 ] 2 0.010% 100.005% ** Level 3 read latency histogram (micros): Count: 55 Average: 1466.2182 StdDev: 1006.10 Min: 136 Median: 1333.3333 Max: 3963 Percentiles: P50: 1333.33 P75: 2275.00 P99: 3963.00 P99.9: 3963.00 P99.99: 3963.00 ------------------------------------------------------ ( 110, 170 ] 4 7.273% 7.273% # ( 170, 250 ] 1 1.818% 9.091% ( 250, 380 ] 2 3.636% 12.727% # ( 380, 580 ] 9 16.364% 29.091% ### ( 580, 870 ] 5 9.091% 38.182% ## ( 870, 1300 ] 6 10.909% 49.091% ## ( 1300, 1900 ] 9 16.364% 65.455% ### ( 1900, 2900 ] 14 25.455% 90.909% ##### ( 2900, 4400 ] 5 9.091% 100.000% ## ** Level 4 read latency histogram (micros): Count: 15 Average: 1613.4667 StdDev: 784.27 Min: 489 Median: 1525.0000 Max: 3232 Percentiles: P50: 1525.00 P75: 2316.67 P99: 3232.00 P99.9: 3232.00 P99.99: 3232.00 ------------------------------------------------------ ( 380, 580 ] 1 6.667% 6.667% # ( 580, 870 ] 3 20.000% 26.667% #### ( 870, 1300 ] 2 13.333% 40.000% ### ( 1300, 1900 ] 4 26.667% 66.667% ##### ( 1900, 2900 ] 3 20.000% 86.667% #### ( 2900, 4400 ] 2 13.333% 100.000% ### ** Level 5 read latency histogram (micros): Count: 20 Average: 491.6000 StdDev: 720.97 Min: 73 Median: 130.0000 Max: 2723 Percentiles: P50: 130.00 P75: 580.00 P99: 2723.00 P99.9: 2723.00 P99.99: 2723.00 ------------------------------------------------------ ( 51, 76 ] 1 5.000% 5.000% # ( 76, 110 ] 8 40.000% 45.000% ######## ( 110, 170 ] 3 15.000% 60.000% ### ( 250, 380 ] 2 10.000% 70.000% ## ( 380, 580 ] 1 5.000% 75.000% # ( 580, 870 ] 1 5.000% 80.000% # ( 870, 1300 ] 2 10.000% 90.000% ## ( 1900, 2900 ] 2 10.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, 311.11 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.420 H:M:S, 13.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 332.69 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.420 H:M:S, 14.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/07/15-05:00:50 ... thread 0: (1000000,2000000) ops and (358980.5,348362.0) ops/second in (2.785667,5.741155) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 12/9 1.23 GB 25.2 0.6 0.0 0.6 2.3 1.8 0.0 1.3 78.4 330.8 7.23 6.66 28 0.258 575K 607 0.0 0.0 L1 1/1 3.24 MB 0.0 0.6 0.4 0.2 0.6 0.4 0.1 1.4 245.0 244.6 2.57 2.48 2 1.285 639K 844 0.0 0.0 L2 5/3 437.74 MB 0.5 0.1 0.1 0.1 0.1 0.1 0.5 2.0 231.6 231.6 0.54 0.52 1 0.544 127K 37 0.0 0.0 L3 17/1 866.52 MB 0.8 0.1 0.1 0.0 0.1 0.1 0.1 1.0 209.6 209.6 0.60 0.54 1 0.597 126K 0 0.0 0.0 L4 116/0 9.54 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1044/0 85.88 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1195/14 97.92 GB 0.0 1.4 0.6 0.8 3.2 2.4 1.3 1.8 132.3 299.1 10.95 10.20 32 0.342 1470K 1488 0.0 0.0 Int 0/0 0.00 KB 0.0 1.4 0.6 0.8 3.2 2.4 0.9 1.8 132.3 299.1 10.95 10.20 32 0.342 1470K 1488 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 1.4 0.6 0.8 1.4 0.6 0.0 0.0 248.7 248.5 5.82 5.61 6 0.970 1470K 1488 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 356.5 5.12 4.59 26 0.197 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): 5.9 total, 5.7 interval Flush(GB): cumulative 1.784, interval 1.784 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 3.20 GB write, 550.24 MB/s write, 1.41 GB read, 243.39 MB/s read, 10.9 seconds Interval compaction: 3.20 GB write, 569.93 MB/s write, 1.41 GB read, 252.11 MB/s read, 10.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: 5, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 5, interval: 5 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 386861 Average: 2.0924 StdDev: 13.09 Min: 1 Median: 1.4064 Max: 3718 Percentiles: P50: 1.41 P75: 1.81 P99: 5.57 P99.9: 10.54 P99.99: 18.92 ------------------------------------------------------ [ 0, 1 ] 95065 24.573% 24.573% ##### ( 1, 2 ] 242018 62.559% 87.133% ############# ( 2, 3 ] 26985 6.975% 94.108% # ( 3, 4 ] 12542 3.242% 97.350% # ( 4, 6 ] 8116 2.098% 99.448% ( 6, 10 ] 1710 0.442% 99.890% ( 10, 15 ] 361 0.093% 99.983% ( 15, 22 ] 47 0.012% 99.996% ( 22, 34 ] 17 0.004% 100.000% ( 34, 51 ] 8 0.002% 100.002% ( 51, 76 ] 6 0.002% 100.004% ( 110, 170 ] 20 0.005% 100.009% ( 170, 250 ] 6 0.002% 100.010% ( 250, 380 ] 10 0.003% 100.013% ( 380, 580 ] 4 0.001% 100.014% ( 580, 870 ] 3 0.001% 100.015% ( 870, 1300 ] 4 0.001% 100.016% ( 1300, 1900 ] 3 0.001% 100.017% ( 1900, 2900 ] 4 0.001% 100.018% ( 2900, 4400 ] 2 0.001% 100.018% ** Level 1 read latency histogram (micros): Count: 121995 Average: 2.1461 StdDev: 6.75 Min: 0 Median: 1.4797 Max: 1642 Percentiles: P50: 1.48 P75: 1.86 P99: 5.59 P99.9: 9.86 P99.99: 71.01 ------------------------------------------------------ [ 0, 1 ] 22888 18.761% 18.761% #### ( 1, 2 ] 79448 65.124% 83.885% ############# ( 2, 3 ] 11659 9.557% 93.442% ## ( 3, 4 ] 4234 3.471% 96.913% # ( 4, 6 ] 3198 2.621% 99.534% # ( 6, 10 ] 462 0.379% 99.913% ( 10, 15 ] 65 0.053% 99.966% ( 15, 22 ] 22 0.018% 99.984% ( 22, 34 ] 5 0.004% 99.989% ( 34, 51 ] 1 0.001% 99.989% ( 51, 76 ] 1 0.001% 99.990% ( 170, 250 ] 2 0.002% 99.992% ( 250, 380 ] 5 0.004% 99.996% ( 380, 580 ] 1 0.001% 99.997% ( 580, 870 ] 3 0.002% 99.999% ( 1300, 1900 ] 1 0.001% 100.000% ** Level 2 read latency histogram (micros): Count: 31767 Average: 2.5448 StdDev: 24.49 Min: 0 Median: 1.5151 Max: 2494 Percentiles: P50: 1.52 P75: 1.92 P99: 5.99 P99.9: 13.27 P99.99: 1546.99 ------------------------------------------------------ [ 0, 1 ] 5873 18.488% 18.488% #### ( 1, 2 ] 19434 61.177% 79.664% ############ ( 2, 3 ] 3329 10.479% 90.144% ## ( 3, 4 ] 1659 5.222% 95.366% # ( 4, 6 ] 1160 3.652% 99.018% # ( 6, 10 ] 256 0.806% 99.824% ( 10, 15 ] 37 0.116% 99.940% ( 15, 22 ] 6 0.019% 99.959% ( 22, 34 ] 1 0.003% 99.962% ( 51, 76 ] 1 0.003% 99.965% ( 76, 110 ] 1 0.003% 99.969% ( 170, 250 ] 2 0.006% 99.975% ( 250, 380 ] 2 0.006% 99.981% ( 380, 580 ] 1 0.003% 99.984% ( 580, 870 ] 1 0.003% 99.987% ( 1300, 1900 ] 2 0.006% 99.994% ( 1900, 2900 ] 2 0.006% 100.000% ** Level 3 read latency histogram (micros): Count: 21258 Average: 5.9878 StdDev: 90.48 Min: 1 Median: 1.5095 Max: 3963 Percentiles: P50: 1.51 P75: 1.90 P99: 5.86 P99.9: 1749.47 P99.99: 3762.26 ------------------------------------------------------ [ 0, 1 ] 3609 16.977% 16.977% ### ( 1, 2 ] 13778 64.813% 81.790% ############# ( 2, 3 ] 2247 10.570% 92.361% ## ( 3, 4 ] 829 3.900% 96.260% # ( 4, 6 ] 627 2.949% 99.210% # ( 6, 10 ] 91 0.428% 99.638% ( 10, 15 ] 17 0.080% 99.718% ( 15, 22 ] 1 0.005% 99.722% ( 22, 34 ] 2 0.009% 99.732% ( 110, 170 ] 4 0.019% 99.751% ( 170, 250 ] 1 0.005% 99.755% ( 250, 380 ] 2 0.009% 99.765% ( 380, 580 ] 10 0.047% 99.812% ( 580, 870 ] 6 0.028% 99.840% ( 870, 1300 ] 6 0.028% 99.868% ( 1300, 1900 ] 9 0.042% 99.911% ( 1900, 2900 ] 14 0.066% 99.976% ( 2900, 4400 ] 5 0.024% 100.000% ** Level 4 read latency histogram (micros): Count: 15 Average: 1613.4667 StdDev: 784.27 Min: 489 Median: 1525.0000 Max: 3232 Percentiles: P50: 1525.00 P75: 2316.67 P99: 3232.00 P99.9: 3232.00 P99.99: 3232.00 ------------------------------------------------------ ( 380, 580 ] 1 6.667% 6.667% # ( 580, 870 ] 3 20.000% 26.667% #### ( 870, 1300 ] 2 13.333% 40.000% ### ( 1300, 1900 ] 4 26.667% 66.667% ##### ( 1900, 2900 ] 3 20.000% 86.667% #### ( 2900, 4400 ] 2 13.333% 100.000% ### ** Level 5 read latency histogram (micros): Count: 20 Average: 491.6000 StdDev: 720.97 Min: 73 Median: 130.0000 Max: 2723 Percentiles: P50: 130.00 P75: 580.00 P99: 2723.00 P99.9: 2723.00 P99.99: 2723.00 ------------------------------------------------------ ( 51, 76 ] 1 5.000% 5.000% # ( 76, 110 ] 8 40.000% 45.000% ######## ( 110, 170 ] 3 15.000% 60.000% ### ( 250, 380 ] 2 10.000% 70.000% ## ( 380, 580 ] 1 5.000% 75.000% # ( 580, 870 ] 1 5.000% 80.000% # ( 870, 1300 ] 2 10.000% 90.000% ## ( 1900, 2900 ] 2 10.000% 100.000% ## ** DB Stats ** Uptime(secs): 5.9 total, 2.8 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 330.87 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:0.625 H:M:S, 10.5 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 353.32 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.205 H:M:S, 7.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/07/15-05:00:53 ... thread 0: (1000000,3000000) ops and (334213.0,343514.4) ops/second in (2.992104,8.733259) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 12/11 1.48 GB 6.3 1.4 0.0 1.4 4.1 2.8 0.0 1.5 105.7 321.8 13.11 12.19 45 0.291 1407K 1518 0.0 0.0 L1 8/8 756.47 MB 0.0 1.4 1.2 0.2 1.4 1.2 0.1 1.2 239.1 238.6 5.81 5.62 3 1.935 1409K 2860 0.0 0.0 L2 2/0 51.45 MB 0.5 0.1 0.1 0.1 0.1 0.1 0.5 2.0 231.6 231.6 0.54 0.52 1 0.544 127K 37 0.0 0.0 L3 42/0 970.60 MB 1.0 0.6 0.5 0.1 0.6 0.5 0.1 1.2 195.1 195.0 3.20 2.74 2 1.599 633K 515 0.0 0.0 L4 144/0 9.50 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1048/0 86.19 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1256/19 98.90 GB 0.0 3.4 1.7 1.7 6.2 4.5 1.9 2.2 155.5 280.4 22.66 21.07 51 0.444 3578K 4930 0.0 0.0 Int 0/0 0.00 KB 0.0 3.4 1.7 1.7 6.2 4.5 1.5 2.2 155.5 280.4 22.66 21.07 51 0.444 3578K 4930 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.4 1.7 1.7 3.4 1.7 0.0 0.0 239.2 238.9 14.73 13.95 11 1.339 3578K 4930 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 2.8 2.8 0.0 0.0 0.0 357.6 7.93 7.12 40 0.198 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 8.9 total, 8.7 interval Flush(GB): cumulative 2.768, interval 2.768 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 6.21 GB write, 710.69 MB/s write, 3.44 GB read, 394.20 MB/s read, 22.7 seconds Interval compaction: 6.21 GB write, 727.41 MB/s write, 3.44 GB read, 403.47 MB/s read, 22.7 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 9, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 9, interval: 9 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 726687 Average: 2.1218 StdDev: 11.82 Min: 1 Median: 1.4431 Max: 3737 Percentiles: P50: 1.44 P75: 1.83 P99: 5.53 P99.9: 9.86 P99.99: 14.29 ------------------------------------------------------ [ 0, 1 ] 155256 21.365% 21.365% #### ( 1, 2 ] 469641 64.628% 85.993% ############# ( 2, 3 ] 56309 7.749% 93.741% ## ( 3, 4 ] 26010 3.579% 97.321% # ( 4, 6 ] 15975 2.198% 99.519% ( 6, 10 ] 2869 0.395% 99.914% ( 10, 15 ] 647 0.089% 100.003% ( 15, 22 ] 72 0.010% 100.013% ( 22, 34 ] 19 0.003% 100.015% ( 34, 51 ] 9 0.001% 100.017% ( 51, 76 ] 7 0.001% 100.017% ( 110, 170 ] 28 0.004% 100.021% ( 170, 250 ] 10 0.001% 100.023% ( 250, 380 ] 16 0.002% 100.025% ( 380, 580 ] 6 0.001% 100.026% ( 580, 870 ] 8 0.001% 100.027% ( 870, 1300 ] 10 0.001% 100.028% ( 1300, 1900 ] 4 0.001% 100.029% ( 1900, 2900 ] 5 0.001% 100.029% ( 2900, 4400 ] 3 0.000% 100.030% ** Level 1 read latency histogram (micros): Count: 164536 Average: 2.2020 StdDev: 10.51 Min: 0 Median: 1.4837 Max: 2181 Percentiles: P50: 1.48 P75: 1.87 P99: 5.62 P99.9: 9.91 P99.99: 348.10 ------------------------------------------------------ [ 0, 1 ] 30764 18.697% 18.697% #### ( 1, 2 ] 106473 64.711% 83.408% ############# ( 2, 3 ] 16136 9.807% 93.215% ## ( 3, 4 ] 5838 3.548% 96.764% # ( 4, 6 ] 4533 2.755% 99.519% # ( 6, 10 ] 642 0.390% 99.909% ( 10, 15 ] 89 0.054% 99.963% ( 15, 22 ] 27 0.016% 99.979% ( 22, 34 ] 5 0.003% 99.982% ( 34, 51 ] 1 0.001% 99.983% ( 51, 76 ] 2 0.001% 99.984% ( 170, 250 ] 2 0.001% 99.985% ( 250, 380 ] 10 0.006% 99.991% ( 380, 580 ] 6 0.004% 99.995% ( 580, 870 ] 4 0.002% 99.998% ( 1300, 1900 ] 2 0.001% 99.999% ( 1900, 2900 ] 2 0.001% 100.000% ** Level 2 read latency histogram (micros): Count: 31767 Average: 2.5448 StdDev: 24.49 Min: 0 Median: 1.5151 Max: 2494 Percentiles: P50: 1.52 P75: 1.92 P99: 5.99 P99.9: 13.27 P99.99: 1546.99 ------------------------------------------------------ [ 0, 1 ] 5873 18.488% 18.488% #### ( 1, 2 ] 19434 61.177% 79.664% ############ ( 2, 3 ] 3329 10.479% 90.144% ## ( 3, 4 ] 1659 5.222% 95.366% # ( 4, 6 ] 1160 3.652% 99.018% # ( 6, 10 ] 256 0.806% 99.824% ( 10, 15 ] 37 0.116% 99.940% ( 15, 22 ] 6 0.019% 99.959% ( 22, 34 ] 1 0.003% 99.962% ( 51, 76 ] 1 0.003% 99.965% ( 76, 110 ] 1 0.003% 99.969% ( 170, 250 ] 2 0.006% 99.975% ( 250, 380 ] 2 0.006% 99.981% ( 380, 580 ] 1 0.003% 99.984% ( 580, 870 ] 1 0.003% 99.987% ( 1300, 1900 ] 2 0.006% 99.994% ( 1900, 2900 ] 2 0.006% 100.000% ** Level 3 read latency histogram (micros): Count: 28994 Average: 5.1520 StdDev: 77.65 Min: 0 Median: 1.5407 Max: 3963 Percentiles: P50: 1.54 P75: 1.93 P99: 6.00 P99.9: 1228.76 P99.99: 3530.18 ------------------------------------------------------ [ 0, 1 ] 4401 15.179% 15.179% ### ( 1, 2 ] 18673 64.403% 79.582% ############# ( 2, 3 ] 3331 11.489% 91.071% ## ( 3, 4 ] 1271 4.384% 95.454% # ( 4, 6 ] 1029 3.549% 99.003% # ( 6, 10 ] 142 0.490% 99.493% ( 10, 15 ] 22 0.076% 99.569% ( 15, 22 ] 1 0.003% 99.572% ( 22, 34 ] 48 0.166% 99.738% ( 34, 51 ] 10 0.034% 99.772% ( 110, 170 ] 8 0.028% 99.800% ( 170, 250 ] 2 0.007% 99.807% ( 250, 380 ] 4 0.014% 99.821% ( 380, 580 ] 12 0.041% 99.862% ( 580, 870 ] 6 0.021% 99.883% ( 870, 1300 ] 6 0.021% 99.903% ( 1300, 1900 ] 9 0.031% 99.934% ( 1900, 2900 ] 14 0.048% 99.983% ( 2900, 4400 ] 5 0.017% 100.000% ** Level 4 read latency histogram (micros): Count: 15 Average: 1613.4667 StdDev: 784.27 Min: 489 Median: 1525.0000 Max: 3232 Percentiles: P50: 1525.00 P75: 2316.67 P99: 3232.00 P99.9: 3232.00 P99.99: 3232.00 ------------------------------------------------------ ( 380, 580 ] 1 6.667% 6.667% # ( 580, 870 ] 3 20.000% 26.667% #### ( 870, 1300 ] 2 13.333% 40.000% ### ( 1300, 1900 ] 4 26.667% 66.667% ##### ( 1900, 2900 ] 3 20.000% 86.667% #### ( 2900, 4400 ] 2 13.333% 100.000% ### ** Level 5 read latency histogram (micros): Count: 40 Average: 650.3000 StdDev: 942.78 Min: 73 Median: 223.3333 Max: 4050 Percentiles: P50: 223.33 P75: 580.00 P99: 3800.00 P99.9: 4050.00 P99.99: 4050.00 ------------------------------------------------------ ( 51, 76 ] 1 2.500% 2.500% # ( 76, 110 ] 11 27.500% 30.000% ###### ( 110, 170 ] 6 15.000% 45.000% ### ( 170, 250 ] 3 7.500% 52.500% ## ( 250, 380 ] 5 12.500% 65.000% ### ( 380, 580 ] 4 10.000% 75.000% ## ( 580, 870 ] 2 5.000% 80.000% # ( 870, 1300 ] 2 5.000% 85.000% # ( 1900, 2900 ] 5 12.500% 97.500% ### ( 2900, 4400 ] 1 2.500% 100.000% # ** DB Stats ** Uptime(secs): 8.9 total, 3.0 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 330.22 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:1.050 H:M:S, 11.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 328.93 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.425 H:M:S, 14.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/07/15-05:00:56 ... thread 0: (1000000,4000000) ops and (334781.4,341288.7) ops/second in (2.987024,11.720283) 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/11 2.40 GB 100.7 2.2 0.0 2.2 5.8 3.7 0.0 1.6 117.2 317.9 18.82 17.54 61 0.308 2238K 2380 0.0 0.0 L1 8/8 756.47 MB 0.0 1.4 1.2 0.2 1.4 1.2 0.1 1.2 239.1 238.6 5.81 5.62 3 1.935 1409K 2860 0.0 0.0 L2 2/0 51.45 MB 0.5 0.1 0.1 0.1 0.1 0.1 0.5 2.0 231.6 231.6 0.54 0.52 1 0.544 127K 37 0.0 0.0 L3 42/0 970.60 MB 1.0 0.6 0.5 0.1 0.6 0.5 0.1 1.2 195.1 195.0 3.20 2.74 2 1.599 633K 515 0.0 0.0 L4 144/0 9.50 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1048/0 86.19 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1260/19 99.82 GB 0.0 4.2 1.7 2.5 7.9 5.4 1.9 2.1 153.1 286.2 28.36 26.43 67 0.423 4410K 5792 0.0 0.0 Int 0/0 0.00 KB 0.0 4.2 1.7 2.5 7.9 5.4 1.5 2.1 153.1 286.2 28.36 26.43 67 0.423 4410K 5792 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.2 1.7 2.5 4.2 1.7 0.0 0.0 244.1 243.8 17.79 16.95 14 1.271 4410K 5792 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 357.5 10.57 9.48 53 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): 11.9 total, 11.7 interval Flush(GB): cumulative 3.691, interval 3.691 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 7.93 GB write, 680.52 MB/s write, 4.24 GB read, 364.14 MB/s read, 28.4 seconds Interval compaction: 7.93 GB write, 692.45 MB/s write, 4.24 GB read, 370.52 MB/s read, 28.4 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 12, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 12, interval: 12 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1051464 Average: 2.1379 StdDev: 10.77 Min: 1 Median: 1.4545 Max: 3737 Percentiles: P50: 1.45 P75: 1.84 P99: 5.55 P99.9: 9.89 P99.99: 14.23 ------------------------------------------------------ [ 0, 1 ] 212658 20.225% 20.225% #### ( 1, 2 ] 688798 65.508% 85.733% ############# ( 2, 3 ] 84015 7.990% 93.724% ## ( 3, 4 ] 37198 3.538% 97.261% # ( 4, 6 ] 23521 2.237% 99.498% ( 6, 10 ] 4339 0.413% 99.911% ( 10, 15 ] 980 0.093% 100.004% ( 15, 22 ] 94 0.009% 100.013% ( 22, 34 ] 25 0.002% 100.016% ( 34, 51 ] 12 0.001% 100.017% ( 51, 76 ] 9 0.001% 100.018% ( 76, 110 ] 28 0.003% 100.020% ( 110, 170 ] 46 0.004% 100.025% ( 170, 250 ] 18 0.002% 100.026% ( 250, 380 ] 24 0.002% 100.029% ( 380, 580 ] 17 0.002% 100.030% ( 580, 870 ] 15 0.001% 100.032% ( 870, 1300 ] 15 0.001% 100.033% ( 1300, 1900 ] 5 0.000% 100.034% ( 1900, 2900 ] 6 0.001% 100.034% ( 2900, 4400 ] 3 0.000% 100.034% ** Level 1 read latency histogram (micros): Count: 233554 Average: 2.1704 StdDev: 8.84 Min: 0 Median: 1.4865 Max: 2181 Percentiles: P50: 1.49 P75: 1.86 P99: 5.58 P99.9: 9.95 P99.99: 258.38 ------------------------------------------------------ [ 0, 1 ] 41711 17.859% 17.859% #### ( 1, 2 ] 154286 66.060% 83.919% ############# ( 2, 3 ] 22253 9.528% 93.447% ## ( 3, 4 ] 8252 3.533% 96.981% # ( 4, 6 ] 5964 2.554% 99.534% # ( 6, 10 ] 865 0.370% 99.905% ( 10, 15 ] 157 0.067% 99.972% ( 15, 22 ] 31 0.013% 99.985% ( 22, 34 ] 5 0.002% 99.987% ( 34, 51 ] 1 0.000% 99.988% ( 51, 76 ] 3 0.001% 99.989% ( 170, 250 ] 2 0.001% 99.990% ( 250, 380 ] 10 0.004% 99.994% ( 380, 580 ] 6 0.003% 99.997% ( 580, 870 ] 4 0.002% 99.998% ( 1300, 1900 ] 2 0.001% 99.999% ( 1900, 2900 ] 2 0.001% 100.000% ** Level 2 read latency histogram (micros): Count: 31767 Average: 2.5448 StdDev: 24.49 Min: 0 Median: 1.5151 Max: 2494 Percentiles: P50: 1.52 P75: 1.92 P99: 5.99 P99.9: 13.27 P99.99: 1546.99 ------------------------------------------------------ [ 0, 1 ] 5873 18.488% 18.488% #### ( 1, 2 ] 19434 61.177% 79.664% ############ ( 2, 3 ] 3329 10.479% 90.144% ## ( 3, 4 ] 1659 5.222% 95.366% # ( 4, 6 ] 1160 3.652% 99.018% # ( 6, 10 ] 256 0.806% 99.824% ( 10, 15 ] 37 0.116% 99.940% ( 15, 22 ] 6 0.019% 99.959% ( 22, 34 ] 1 0.003% 99.962% ( 51, 76 ] 1 0.003% 99.965% ( 76, 110 ] 1 0.003% 99.969% ( 170, 250 ] 2 0.006% 99.975% ( 250, 380 ] 2 0.006% 99.981% ( 380, 580 ] 1 0.003% 99.984% ( 580, 870 ] 1 0.003% 99.987% ( 1300, 1900 ] 2 0.006% 99.994% ( 1900, 2900 ] 2 0.006% 100.000% ** Level 3 read latency histogram (micros): Count: 28994 Average: 5.1520 StdDev: 77.65 Min: 0 Median: 1.5407 Max: 3963 Percentiles: P50: 1.54 P75: 1.93 P99: 6.00 P99.9: 1228.76 P99.99: 3530.18 ------------------------------------------------------ [ 0, 1 ] 4401 15.179% 15.179% ### ( 1, 2 ] 18673 64.403% 79.582% ############# ( 2, 3 ] 3331 11.489% 91.071% ## ( 3, 4 ] 1271 4.384% 95.454% # ( 4, 6 ] 1029 3.549% 99.003% # ( 6, 10 ] 142 0.490% 99.493% ( 10, 15 ] 22 0.076% 99.569% ( 15, 22 ] 1 0.003% 99.572% ( 22, 34 ] 48 0.166% 99.738% ( 34, 51 ] 10 0.034% 99.772% ( 110, 170 ] 8 0.028% 99.800% ( 170, 250 ] 2 0.007% 99.807% ( 250, 380 ] 4 0.014% 99.821% ( 380, 580 ] 12 0.041% 99.862% ( 580, 870 ] 6 0.021% 99.883% ( 870, 1300 ] 6 0.021% 99.903% ( 1300, 1900 ] 9 0.031% 99.934% ( 1900, 2900 ] 14 0.048% 99.983% ( 2900, 4400 ] 5 0.017% 100.000% ** Level 4 read latency histogram (micros): Count: 15 Average: 1613.4667 StdDev: 784.27 Min: 489 Median: 1525.0000 Max: 3232 Percentiles: P50: 1525.00 P75: 2316.67 P99: 3232.00 P99.9: 3232.00 P99.99: 3232.00 ------------------------------------------------------ ( 380, 580 ] 1 6.667% 6.667% # ( 580, 870 ] 3 20.000% 26.667% #### ( 870, 1300 ] 2 13.333% 40.000% ### ( 1300, 1900 ] 4 26.667% 66.667% ##### ( 1900, 2900 ] 3 20.000% 86.667% #### ( 2900, 4400 ] 2 13.333% 100.000% ### ** Level 5 read latency histogram (micros): Count: 40 Average: 650.3000 StdDev: 942.78 Min: 73 Median: 223.3333 Max: 4050 Percentiles: P50: 223.33 P75: 580.00 P99: 3800.00 P99.9: 4050.00 P99.99: 4050.00 ------------------------------------------------------ ( 51, 76 ] 1 2.500% 2.500% # ( 76, 110 ] 11 27.500% 30.000% ###### ( 110, 170 ] 6 15.000% 45.000% ### ( 170, 250 ] 3 7.500% 52.500% ## ( 250, 380 ] 5 12.500% 65.000% ### ( 380, 580 ] 4 10.000% 75.000% ## ( 580, 870 ] 2 5.000% 80.000% # ( 870, 1300 ] 2 5.000% 85.000% # ( 1900, 2900 ] 5 12.500% 97.500% ### ( 2900, 4400 ] 1 2.500% 100.000% # ** DB Stats ** Uptime(secs): 11.9 total, 3.0 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 330.04 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:1.461 H:M:S, 12.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 329.49 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.411 H:M:S, 13.8 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/07/15-05:01:00 ... thread 0: (1000000,5000000) ops and (262404.9,321932.9) ops/second in (3.810904,15.531187) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 19/11 3.38 GB 201.4 3.2 0.0 3.2 7.9 4.7 0.0 1.7 128.2 315.5 25.55 23.93 80 0.319 3326K 3532 0.0 0.0 L1 8/8 756.47 MB 0.0 1.4 1.2 0.2 1.4 1.2 0.1 1.2 239.1 238.6 5.81 5.62 3 1.935 1409K 2860 0.0 0.0 L2 2/0 51.45 MB 0.5 0.1 0.1 0.1 0.1 0.1 0.5 2.0 231.6 231.6 0.54 0.52 1 0.544 127K 37 0.0 0.0 L3 42/0 970.60 MB 1.0 0.6 0.5 0.1 0.6 0.5 0.1 1.2 195.1 195.0 3.20 2.74 2 1.599 633K 515 0.0 0.0 L4 144/0 9.50 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1048/0 86.19 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1263/19 100.81 GB 0.0 5.3 1.7 3.6 10.0 6.4 1.9 2.1 154.3 290.5 35.10 32.81 86 0.408 5497K 6944 0.0 0.0 Int 0/0 0.00 KB 0.0 5.3 1.7 3.6 10.0 6.4 1.5 2.1 154.3 290.5 35.10 32.81 86 0.408 5497K 6944 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.3 1.7 3.6 5.3 1.7 0.0 0.0 249.0 248.6 21.75 20.84 18 1.208 5497K 6944 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 358.6 13.35 11.97 68 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): 15.7 total, 15.5 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.96 GB write, 647.76 MB/s write, 5.29 GB read, 344.02 MB/s read, 35.1 seconds Interval compaction: 9.96 GB write, 656.33 MB/s write, 5.29 GB read, 348.57 MB/s read, 35.1 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 5, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 5, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 14, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 5, total-stops: 14, interval: 19 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1450813 Average: 2.1583 StdDev: 10.30 Min: 1 Median: 1.4576 Max: 3737 Percentiles: P50: 1.46 P75: 1.84 P99: 5.60 P99.9: 9.94 P99.99: 14.72 ------------------------------------------------------ [ 0, 1 ] 287795 19.837% 19.837% #### ( 1, 2 ] 956331 65.917% 85.754% ############# ( 2, 3 ] 116118 8.004% 93.757% ## ( 3, 4 ] 50764 3.499% 97.256% # ( 4, 6 ] 31572 2.176% 99.433% ( 6, 10 ] 6879 0.474% 99.907% ( 10, 15 ] 1283 0.088% 99.995% ( 15, 22 ] 132 0.009% 100.004% ( 22, 34 ] 32 0.002% 100.006% ( 34, 51 ] 15 0.001% 100.007% ( 51, 76 ] 15 0.001% 100.008% ( 76, 110 ] 78 0.005% 100.014% ( 110, 170 ] 118 0.008% 100.022% ( 170, 250 ] 45 0.003% 100.025% ( 250, 380 ] 52 0.004% 100.029% ( 380, 580 ] 35 0.002% 100.031% ( 580, 870 ] 27 0.002% 100.033% ( 870, 1300 ] 20 0.001% 100.034% ( 1300, 1900 ] 6 0.000% 100.035% ( 1900, 2900 ] 8 0.001% 100.035% ( 2900, 4400 ] 3 0.000% 100.035% ** Level 1 read latency histogram (micros): Count: 319715 Average: 2.2951 StdDev: 9.93 Min: 0 Median: 1.4858 Max: 2181 Percentiles: P50: 1.49 P75: 1.86 P99: 5.85 P99.9: 14.31 P99.99: 436.23 ------------------------------------------------------ [ 0, 1 ] 56724 17.742% 17.742% #### ( 1, 2 ] 212305 66.404% 84.147% ############# ( 2, 3 ] 29268 9.154% 93.301% ## ( 3, 4 ] 11044 3.454% 96.755% # ( 4, 6 ] 7778 2.433% 99.188% ( 6, 10 ] 2048 0.641% 99.829% ( 10, 15 ] 265 0.083% 99.911% ( 15, 22 ] 39 0.012% 99.924% ( 22, 34 ] 7 0.002% 99.926% ( 34, 51 ] 1 0.000% 99.926% ( 51, 76 ] 3 0.001% 99.927% ( 76, 110 ] 30 0.009% 99.937% ( 110, 170 ] 93 0.029% 99.966% ( 170, 250 ] 38 0.012% 99.977% ( 250, 380 ] 33 0.010% 99.988% ( 380, 580 ] 25 0.008% 99.996% ( 580, 870 ] 8 0.003% 99.998% ( 870, 1300 ] 2 0.001% 99.999% ( 1300, 1900 ] 2 0.001% 99.999% ( 1900, 2900 ] 2 0.001% 100.000% ** Level 2 read latency histogram (micros): Count: 31767 Average: 2.5448 StdDev: 24.49 Min: 0 Median: 1.5151 Max: 2494 Percentiles: P50: 1.52 P75: 1.92 P99: 5.99 P99.9: 13.27 P99.99: 1546.99 ------------------------------------------------------ [ 0, 1 ] 5873 18.488% 18.488% #### ( 1, 2 ] 19434 61.177% 79.664% ############ ( 2, 3 ] 3329 10.479% 90.144% ## ( 3, 4 ] 1659 5.222% 95.366% # ( 4, 6 ] 1160 3.652% 99.018% # ( 6, 10 ] 256 0.806% 99.824% ( 10, 15 ] 37 0.116% 99.940% ( 15, 22 ] 6 0.019% 99.959% ( 22, 34 ] 1 0.003% 99.962% ( 51, 76 ] 1 0.003% 99.965% ( 76, 110 ] 1 0.003% 99.969% ( 170, 250 ] 2 0.006% 99.975% ( 250, 380 ] 2 0.006% 99.981% ( 380, 580 ] 1 0.003% 99.984% ( 580, 870 ] 1 0.003% 99.987% ( 1300, 1900 ] 2 0.006% 99.994% ( 1900, 2900 ] 2 0.006% 100.000% ** Level 3 read latency histogram (micros): Count: 28994 Average: 5.1520 StdDev: 77.65 Min: 0 Median: 1.5407 Max: 3963 Percentiles: P50: 1.54 P75: 1.93 P99: 6.00 P99.9: 1228.76 P99.99: 3530.18 ------------------------------------------------------ [ 0, 1 ] 4401 15.179% 15.179% ### ( 1, 2 ] 18673 64.403% 79.582% ############# ( 2, 3 ] 3331 11.489% 91.071% ## ( 3, 4 ] 1271 4.384% 95.454% # ( 4, 6 ] 1029 3.549% 99.003% # ( 6, 10 ] 142 0.490% 99.493% ( 10, 15 ] 22 0.076% 99.569% ( 15, 22 ] 1 0.003% 99.572% ( 22, 34 ] 48 0.166% 99.738% ( 34, 51 ] 10 0.034% 99.772% ( 110, 170 ] 8 0.028% 99.800% ( 170, 250 ] 2 0.007% 99.807% ( 250, 380 ] 4 0.014% 99.821% ( 380, 580 ] 12 0.041% 99.862% ( 580, 870 ] 6 0.021% 99.883% ( 870, 1300 ] 6 0.021% 99.903% ( 1300, 1900 ] 9 0.031% 99.934% ( 1900, 2900 ] 14 0.048% 99.983% ( 2900, 4400 ] 5 0.017% 100.000% ** Level 4 read latency histogram (micros): Count: 15 Average: 1613.4667 StdDev: 784.27 Min: 489 Median: 1525.0000 Max: 3232 Percentiles: P50: 1525.00 P75: 2316.67 P99: 3232.00 P99.9: 3232.00 P99.99: 3232.00 ------------------------------------------------------ ( 380, 580 ] 1 6.667% 6.667% # ( 580, 870 ] 3 20.000% 26.667% #### ( 870, 1300 ] 2 13.333% 40.000% ### ( 1300, 1900 ] 4 26.667% 66.667% ##### ( 1900, 2900 ] 3 20.000% 86.667% #### ( 2900, 4400 ] 2 13.333% 100.000% ### ** Level 5 read latency histogram (micros): Count: 40 Average: 650.3000 StdDev: 942.78 Min: 73 Median: 223.3333 Max: 4050 Percentiles: P50: 223.33 P75: 580.00 P99: 3800.00 P99.9: 4050.00 P99.99: 4050.00 ------------------------------------------------------ ( 51, 76 ] 1 2.500% 2.500% # ( 76, 110 ] 11 27.500% 30.000% ###### ( 110, 170 ] 6 15.000% 45.000% ### ( 170, 250 ] 3 7.500% 52.500% ## ( 250, 380 ] 5 12.500% 65.000% ### ( 380, 580 ] 4 10.000% 75.000% ## ( 580, 870 ] 2 5.000% 80.000% # ( 870, 1300 ] 2 5.000% 85.000% # ( 1900, 2900 ] 5 12.500% 97.500% ### ( 2900, 4400 ] 1 2.500% 100.000% # ** DB Stats ** Uptime(secs): 15.7 total, 3.8 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 312.66 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:2.632 H:M:S, 16.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 258.26 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.171 H:M:S, 30.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/07/15-05:01:04 ... thread 0: (1000000,6000000) ops and (257021.9,308929.5) ops/second in (3.890719,19.421906) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 18/15 3.26 GB 62.9 3.9 0.0 3.9 9.7 5.7 0.0 1.7 128.3 314.6 31.42 29.36 98 0.321 4093K 4253 0.0 0.0 L1 16/16 1.89 GB 0.0 3.3 2.3 0.9 3.2 2.3 0.1 1.4 234.7 233.4 14.23 13.75 4 3.558 3392K 18K 0.0 0.0 L2 2/0 51.45 MB 0.5 0.1 0.1 0.1 0.1 0.1 0.5 2.0 231.6 231.6 0.54 0.52 1 0.544 127K 37 0.0 0.0 L3 42/0 970.60 MB 1.0 0.6 0.5 0.1 0.6 0.5 0.1 1.2 195.1 195.0 3.20 2.74 2 1.599 633K 515 0.0 0.0 L4 144/0 9.50 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1048/0 86.19 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1270/31 101.84 GB 0.0 7.9 2.9 5.0 13.6 8.6 1.9 2.4 164.4 282.6 49.39 46.38 105 0.470 8247K 22K 0.0 0.0 Int 0/0 0.00 KB 0.0 7.9 2.9 5.0 13.6 8.6 1.5 2.4 164.4 282.6 49.39 46.38 105 0.470 8247K 22K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 7.9 2.9 5.0 7.9 2.9 0.0 0.0 246.3 245.6 32.98 31.71 22 1.499 8247K 22K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 5.7 5.7 0.0 0.0 0.0 356.9 16.41 14.67 83 0.198 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 19.6 total, 19.4 interval Flush(GB): cumulative 5.722, interval 5.722 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 13.63 GB write, 711.08 MB/s write, 7.93 GB read, 413.81 MB/s read, 49.4 seconds Interval compaction: 13.63 GB write, 718.60 MB/s write, 7.93 GB read, 418.19 MB/s read, 49.4 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 8, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 8, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 18, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 8, total-stops: 18, interval: 26 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1758692 Average: 2.1948 StdDev: 11.52 Min: 0 Median: 1.4551 Max: 4162 Percentiles: P50: 1.46 P75: 1.83 P99: 5.62 P99.9: 10.75 P99.99: 89.36 ------------------------------------------------------ [ 0, 1 ] 350351 19.921% 19.921% #### ( 1, 2 ] 1162295 66.089% 86.010% ############# ( 2, 3 ] 138887 7.897% 93.907% ## ( 3, 4 ] 60104 3.418% 97.324% # ( 4, 6 ] 36307 2.064% 99.389% ( 6, 10 ] 8766 0.498% 99.887% ( 10, 15 ] 1498 0.085% 99.972% ( 15, 22 ] 174 0.010% 99.982% ( 22, 34 ] 38 0.002% 99.985% ( 34, 51 ] 16 0.001% 99.985% ( 51, 76 ] 21 0.001% 99.987% ( 76, 110 ] 153 0.009% 99.995% ( 110, 170 ] 274 0.016% 100.011% ( 170, 250 ] 108 0.006% 100.017% ( 250, 380 ] 96 0.005% 100.023% ( 380, 580 ] 71 0.004% 100.027% ( 580, 870 ] 41 0.002% 100.029% ( 870, 1300 ] 25 0.001% 100.030% ( 1300, 1900 ] 8 0.000% 100.031% ( 1900, 2900 ] 11 0.001% 100.031% ( 2900, 4400 ] 5 0.000% 100.032% ** Level 1 read latency histogram (micros): Count: 415510 Average: 2.3698 StdDev: 11.93 Min: 0 Median: 1.4752 Max: 2181 Percentiles: P50: 1.48 P75: 1.85 P99: 6.12 P99.9: 90.30 P99.99: 544.04 ------------------------------------------------------ [ 0, 1 ] 76851 18.496% 18.496% #### ( 1, 2 ] 275464 66.295% 84.791% ############# ( 2, 3 ] 35685 8.588% 93.379% ## ( 3, 4 ] 13938 3.354% 96.734% # ( 4, 6 ] 9316 2.242% 98.976% ( 6, 10 ] 3389 0.816% 99.791% ( 10, 15 ] 348 0.084% 99.875% ( 15, 22 ] 46 0.011% 99.886% ( 22, 34 ] 9 0.002% 99.888% ( 34, 51 ] 1 0.000% 99.889% ( 51, 76 ] 5 0.001% 99.890% ( 76, 110 ] 101 0.024% 99.914% ( 110, 170 ] 181 0.044% 99.958% ( 170, 250 ] 50 0.012% 99.970% ( 250, 380 ] 50 0.012% 99.982% ( 380, 580 ] 42 0.010% 99.992% ( 580, 870 ] 16 0.004% 99.996% ( 870, 1300 ] 12 0.003% 99.999% ( 1300, 1900 ] 4 0.001% 100.000% ( 1900, 2900 ] 2 0.000% 100.000% ** Level 2 read latency histogram (micros): Count: 31767 Average: 2.5448 StdDev: 24.49 Min: 0 Median: 1.5151 Max: 2494 Percentiles: P50: 1.52 P75: 1.92 P99: 5.99 P99.9: 13.27 P99.99: 1546.99 ------------------------------------------------------ [ 0, 1 ] 5873 18.488% 18.488% #### ( 1, 2 ] 19434 61.177% 79.664% ############ ( 2, 3 ] 3329 10.479% 90.144% ## ( 3, 4 ] 1659 5.222% 95.366% # ( 4, 6 ] 1160 3.652% 99.018% # ( 6, 10 ] 256 0.806% 99.824% ( 10, 15 ] 37 0.116% 99.940% ( 15, 22 ] 6 0.019% 99.959% ( 22, 34 ] 1 0.003% 99.962% ( 51, 76 ] 1 0.003% 99.965% ( 76, 110 ] 1 0.003% 99.969% ( 170, 250 ] 2 0.006% 99.975% ( 250, 380 ] 2 0.006% 99.981% ( 380, 580 ] 1 0.003% 99.984% ( 580, 870 ] 1 0.003% 99.987% ( 1300, 1900 ] 2 0.006% 99.994% ( 1900, 2900 ] 2 0.006% 100.000% ** Level 3 read latency histogram (micros): Count: 28994 Average: 5.1520 StdDev: 77.65 Min: 0 Median: 1.5407 Max: 3963 Percentiles: P50: 1.54 P75: 1.93 P99: 6.00 P99.9: 1228.76 P99.99: 3530.18 ------------------------------------------------------ [ 0, 1 ] 4401 15.179% 15.179% ### ( 1, 2 ] 18673 64.403% 79.582% ############# ( 2, 3 ] 3331 11.489% 91.071% ## ( 3, 4 ] 1271 4.384% 95.454% # ( 4, 6 ] 1029 3.549% 99.003% # ( 6, 10 ] 142 0.490% 99.493% ( 10, 15 ] 22 0.076% 99.569% ( 15, 22 ] 1 0.003% 99.572% ( 22, 34 ] 48 0.166% 99.738% ( 34, 51 ] 10 0.034% 99.772% ( 110, 170 ] 8 0.028% 99.800% ( 170, 250 ] 2 0.007% 99.807% ( 250, 380 ] 4 0.014% 99.821% ( 380, 580 ] 12 0.041% 99.862% ( 580, 870 ] 6 0.021% 99.883% ( 870, 1300 ] 6 0.021% 99.903% ( 1300, 1900 ] 9 0.031% 99.934% ( 1900, 2900 ] 14 0.048% 99.983% ( 2900, 4400 ] 5 0.017% 100.000% ** Level 4 read latency histogram (micros): Count: 15 Average: 1613.4667 StdDev: 784.27 Min: 489 Median: 1525.0000 Max: 3232 Percentiles: P50: 1525.00 P75: 2316.67 P99: 3232.00 P99.9: 3232.00 P99.99: 3232.00 ------------------------------------------------------ ( 380, 580 ] 1 6.667% 6.667% # ( 580, 870 ] 3 20.000% 26.667% #### ( 870, 1300 ] 2 13.333% 40.000% ### ( 1300, 1900 ] 4 26.667% 66.667% ##### ( 1900, 2900 ] 3 20.000% 86.667% #### ( 2900, 4400 ] 2 13.333% 100.000% ### ** Level 5 read latency histogram (micros): Count: 40 Average: 650.3000 StdDev: 942.78 Min: 73 Median: 223.3333 Max: 4050 Percentiles: P50: 223.33 P75: 580.00 P99: 3800.00 P99.9: 4050.00 P99.99: 4050.00 ------------------------------------------------------ ( 51, 76 ] 1 2.500% 2.500% # ( 76, 110 ] 11 27.500% 30.000% ###### ( 110, 170 ] 6 15.000% 45.000% ### ( 170, 250 ] 3 7.500% 52.500% ## ( 250, 380 ] 5 12.500% 65.000% ### ( 380, 580 ] 4 10.000% 75.000% ## ( 580, 870 ] 2 5.000% 80.000% # ( 870, 1300 ] 2 5.000% 85.000% # ( 1900, 2900 ] 5 12.500% 97.500% ### ( 2900, 4400 ] 1 2.500% 100.000% # ** DB Stats ** Uptime(secs): 19.6 total, 3.9 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 300.83 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:3.912 H:M:S, 19.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 252.96 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:1.280 H:M:S, 32.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 0 2024/07/15-05:01:24 ... thread 0: (1000000,7000000) ops and (49528.7,176713.2) ops/second in (20.190301,39.612207) 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 8/6 1.78 GB 18.9 5.7 0.0 5.7 12.2 6.6 0.0 1.9 134.8 291.4 42.98 38.27 112 0.384 5883K 10K 0.0 0.0 L1 10/10 1.14 GB 0.0 7.5 4.7 2.8 7.4 4.6 0.1 1.6 232.5 229.7 32.98 31.49 5 6.597 7788K 91K 0.0 0.0 L2 1/1 923.57 KB 0.0 0.1 0.1 0.1 0.1 0.1 3.5 2.0 231.6 231.6 0.54 0.52 1 0.544 127K 37 0.0 0.0 L3 25/11 1.86 GB 0.9 1.8 1.4 0.3 1.8 1.4 2.2 1.2 144.9 144.6 12.43 8.12 10 1.243 1752K 1627 0.0 0.0 L4 157/6 9.68 GB 1.0 1.9 1.6 0.3 1.9 1.6 1.1 1.2 113.5 113.0 17.04 8.99 15 1.136 1936K 6912 0.0 0.0 L5 1072/0 88.15 GB 0.9 0.0 0.0 0.0 0.0 0.0 2.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1273/34 102.61 GB 0.0 16.9 7.8 9.1 23.4 14.2 9.6 3.6 163.5 226.0 105.97 87.39 143 0.741 17M 110K 0.0 0.0 Int 0/0 0.00 KB 0.0 16.9 7.8 9.1 23.4 14.2 9.2 3.6 163.5 226.0 105.97 87.39 143 0.741 17M 110K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 16.9 7.8 9.1 16.8 7.7 0.0 0.0 204.0 202.7 84.91 70.34 49 1.733 17M 110K 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 320.2 21.05 17.05 94 0.224 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 39.8 total, 39.6 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: 23.39 GB write, 601.46 MB/s write, 16.92 GB read, 435.06 MB/s read, 106.0 seconds Interval compaction: 23.39 GB write, 604.59 MB/s write, 16.92 GB read, 437.31 MB/s read, 106.0 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 10, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 10, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 46, pending-compaction-bytes-delays: 9, pending-compaction-bytes-stops: 0, total-delays: 19, total-stops: 46, interval: 65 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2939373 Average: 2.7614 StdDev: 31.69 Min: 0 Median: 1.4617 Max: 8630 Percentiles: P50: 1.46 P75: 1.85 P99: 6.84 P99.9: 129.21 P99.99: 316.85 ------------------------------------------------------ [ 0, 1 ] 601765 20.473% 20.473% #### ( 1, 2 ] 1879761 63.951% 84.424% ############# ( 2, 3 ] 239764 8.157% 92.581% ## ( 3, 4 ] 105715 3.597% 96.177% # ( 4, 6 ] 77916 2.651% 98.828% # ( 6, 10 ] 24075 0.819% 99.647% ( 10, 15 ] 3861 0.131% 99.778% ( 15, 22 ] 564 0.019% 99.798% ( 22, 34 ] 65 0.002% 99.800% ( 34, 51 ] 25 0.001% 99.801% ( 51, 76 ] 28 0.001% 99.802% ( 76, 110 ] 2038 0.069% 99.871% ( 110, 170 ] 2679 0.091% 99.962% ( 170, 250 ] 587 0.020% 99.982% ( 250, 380 ] 461 0.016% 99.998% ( 380, 580 ] 374 0.013% 100.010% ( 580, 870 ] 161 0.005% 100.016% ( 870, 1300 ] 77 0.003% 100.018% ( 1300, 1900 ] 48 0.002% 100.020% ( 1900, 2900 ] 86 0.003% 100.023% ( 2900, 4400 ] 106 0.004% 100.027% ( 4400, 6600 ] 16 0.001% 100.027% ( 6600, 9900 ] 3 0.000% 100.027% ** Level 1 read latency histogram (micros): Count: 1429955 Average: 5.0980 StdDev: 84.92 Min: 0 Median: 1.6036 Max: 8851 Percentiles: P50: 1.60 P75: 2.18 P99: 9.06 P99.9: 167.84 P99.99: 919.73 ------------------------------------------------------ [ 0, 1 ] 221422 15.485% 15.485% ### ( 1, 2 ] 817752 57.187% 72.672% ########### ( 2, 3 ] 180630 12.632% 85.304% ### ( 3, 4 ] 88007 6.155% 91.458% # ( 4, 6 ] 89429 6.254% 97.712% # ( 6, 10 ] 24085 1.684% 99.396% ( 10, 15 ] 5040 0.352% 99.749% ( 15, 22 ] 631 0.044% 99.793% ( 22, 34 ] 49 0.003% 99.796% ( 34, 51 ] 19 0.001% 99.798% ( 51, 76 ] 84 0.006% 99.804% ( 76, 110 ] 763 0.053% 99.857% ( 110, 170 ] 637 0.045% 99.902% ( 170, 250 ] 175 0.012% 99.914% ( 250, 380 ] 256 0.018% 99.932% ( 380, 580 ] 381 0.027% 99.958% ( 580, 870 ] 418 0.029% 99.988% ( 870, 1300 ] 294 0.021% 100.008% ( 1300, 1900 ] 209 0.015% 100.023% ( 1900, 2900 ] 295 0.021% 100.043% ( 2900, 4400 ] 314 0.022% 100.065% ( 4400, 6600 ] 84 0.006% 100.071% ( 6600, 9900 ] 23 0.002% 100.073% ** Level 2 read latency histogram (micros): Count: 31954 Average: 5.6444 StdDev: 80.77 Min: 0 Median: 1.5195 Max: 3988 Percentiles: P50: 1.52 P75: 1.93 P99: 7.45 P99.9: 1086.65 P99.99: 3800.86 ------------------------------------------------------ [ 0, 1 ] 5873 18.380% 18.380% #### ( 1, 2 ] 19451 60.872% 79.251% ############ ( 2, 3 ] 3372 10.553% 89.804% ## ( 3, 4 ] 1675 5.242% 95.046% # ( 4, 6 ] 1169 3.658% 98.704% # ( 6, 10 ] 260 0.814% 99.518% ( 10, 15 ] 38 0.119% 99.637% ( 15, 22 ] 6 0.019% 99.656% ( 22, 34 ] 1 0.003% 99.659% ( 51, 76 ] 1 0.003% 99.662% ( 76, 110 ] 2 0.006% 99.668% ( 110, 170 ] 3 0.009% 99.678% ( 170, 250 ] 8 0.025% 99.703% ( 250, 380 ] 16 0.050% 99.753% ( 380, 580 ] 21 0.066% 99.818% ( 580, 870 ] 20 0.063% 99.881% ( 870, 1300 ] 12 0.038% 99.919% ( 1300, 1900 ] 7 0.022% 99.941% ( 1900, 2900 ] 11 0.034% 99.975% ( 2900, 4400 ] 8 0.025% 100.000% ** Level 3 read latency histogram (micros): Count: 431865 Average: 14.5356 StdDev: 166.38 Min: 0 Median: 1.8790 Max: 8387 Percentiles: P50: 1.88 P75: 2.99 P99: 14.46 P99.9: 1760.46 P99.99: 2903.02 ------------------------------------------------------ [ 0, 1 ] 21178 4.904% 4.904% # ( 1, 2 ] 221571 51.306% 56.209% ########## ( 2, 3 ] 81652 18.907% 75.116% #### ( 3, 4 ] 45832 10.613% 85.729% ## ( 4, 6 ] 45803 10.606% 96.335% ## ( 6, 10 ] 9566 2.215% 98.550% ( 10, 15 ] 2179 0.505% 99.054% ( 15, 22 ] 235 0.054% 99.109% ( 22, 34 ] 73 0.017% 99.126% ( 34, 51 ] 24 0.006% 99.131% ( 51, 76 ] 4 0.001% 99.132% ( 76, 110 ] 25 0.006% 99.138% ( 110, 170 ] 161 0.037% 99.175% ( 170, 250 ] 257 0.060% 99.235% ( 250, 380 ] 434 0.100% 99.335% ( 380, 580 ] 709 0.164% 99.499% ( 580, 870 ] 844 0.195% 99.695% ( 870, 1300 ] 617 0.143% 99.838% ( 1300, 1900 ] 352 0.082% 99.919% ( 1900, 2900 ] 306 0.071% 99.990% ( 2900, 4400 ] 404 0.094% 100.084% ( 4400, 6600 ] 85 0.020% 100.103% ( 6600, 9900 ] 15 0.003% 100.107% ** Level 4 read latency histogram (micros): Count: 30584 Average: 8.0353 StdDev: 86.40 Min: 1 Median: 1.9505 Max: 4618 Percentiles: P50: 1.95 P75: 3.04 P99: 12.74 P99.9: 1317.83 P99.99: 3635.40 ------------------------------------------------------ [ 0, 1 ] 730 2.387% 2.387% ( 1, 2 ] 15322 50.098% 52.485% ########## ( 2, 3 ] 6743 22.047% 74.532% #### ( 3, 4 ] 3225 10.545% 85.077% ## ( 4, 6 ] 3562 11.647% 96.724% ## ( 6, 10 ] 638 2.086% 98.810% ( 10, 15 ] 108 0.353% 99.163% ( 15, 22 ] 18 0.059% 99.222% ( 22, 34 ] 5 0.016% 99.238% ( 34, 51 ] 1 0.003% 99.241% ( 51, 76 ] 2 0.007% 99.248% ( 76, 110 ] 10 0.033% 99.281% ( 110, 170 ] 24 0.078% 99.359% ( 170, 250 ] 46 0.150% 99.510% ( 250, 380 ] 32 0.105% 99.614% ( 380, 580 ] 36 0.118% 99.732% ( 580, 870 ] 34 0.111% 99.843% ( 870, 1300 ] 18 0.059% 99.902% ( 1300, 1900 ] 14 0.046% 99.948% ( 1900, 2900 ] 11 0.036% 99.984% ( 2900, 4400 ] 6 0.020% 100.003% ( 4400, 6600 ] 1 0.003% 100.007% ** Level 5 read latency histogram (micros): Count: 160 Average: 1271.6125 StdDev: 1425.60 Min: 73 Median: 684.4000 Max: 8217 Percentiles: P50: 684.40 P75: 1947.62 P99: 6336.00 P99.9: 8217.00 P99.99: 8217.00 ------------------------------------------------------ ( 51, 76 ] 1 0.625% 0.625% ( 76, 110 ] 13 8.125% 8.750% ## ( 110, 170 ] 10 6.250% 15.000% # ( 170, 250 ] 9 5.625% 20.625% # ( 250, 380 ] 22 13.750% 34.375% ### ( 380, 580 ] 16 10.000% 44.375% ## ( 580, 870 ] 25 15.625% 60.000% ### ( 870, 1300 ] 15 9.375% 69.375% ## ( 1300, 1900 ] 8 5.000% 74.375% # ( 1900, 2900 ] 21 13.125% 87.500% ### ( 2900, 4400 ] 14 8.750% 96.250% ## ( 4400, 6600 ] 5 3.125% 99.375% # ( 6600, 9900 ] 1 0.625% 100.000% ** DB Stats ** Uptime(secs): 39.8 total, 20.2 interval Cumulative writes: 0 writes, 7000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 6.73 GB, 173.01 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:20.817 H:M:S, 52.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 48.75 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:16.905 H:M:S, 83.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 5 num-running-flushes: 1 2024/07/15-05:01:27 ... thread 0: (1000000,8000000) ops and (328560.4,187547.8) ops/second in (3.043580,42.655787) 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/10 2.76 GB 100.7 6.6 0.0 6.6 14.2 7.6 0.0 1.9 136.1 291.0 49.97 44.70 129 0.387 6907K 11K 0.0 0.0 L1 10/10 1.14 GB 0.0 7.5 4.7 2.8 7.4 4.6 0.1 1.6 232.5 229.7 32.98 31.49 5 6.597 7788K 91K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.1 0.1 0.1 3.5 2.0 231.6 231.6 0.54 0.52 1 0.544 127K 37 0.0 0.0 L3 13/0 884.19 MB 0.9 2.5 1.4 1.1 2.5 1.4 2.2 1.7 146.3 146.0 17.38 11.16 11 1.580 2506K 2542 0.0 0.0 L4 162/0 9.69 GB 1.0 2.3 1.9 0.4 2.3 1.9 1.8 1.2 119.9 119.4 19.70 10.97 18 1.094 2372K 8441 0.0 0.0 L5 1084/0 89.14 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 1282/20 103.59 GB 0.0 19.0 8.1 11.0 26.5 15.5 11.3 3.5 161.8 225.0 120.57 98.84 164 0.735 19M 114K 0.0 0.0 Int 0/0 0.00 KB 0.0 19.0 8.1 11.0 26.5 15.5 10.9 3.5 161.8 225.0 120.57 98.84 164 0.735 19M 114K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 19.0 8.1 11.0 18.9 7.9 0.0 0.0 201.9 200.7 96.60 79.20 56 1.725 19M 114K 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 323.2 23.98 19.63 108 0.222 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 42.9 total, 42.7 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: 26.50 GB write, 633.02 MB/s write, 19.05 GB read, 455.00 MB/s read, 120.6 seconds Interval compaction: 26.50 GB write, 636.07 MB/s write, 19.05 GB read, 457.19 MB/s read, 120.6 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 10, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 10, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 51, pending-compaction-bytes-delays: 9, pending-compaction-bytes-stops: 0, total-delays: 19, total-stops: 51, interval: 70 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3283289 Average: 2.7255 StdDev: 30.14 Min: 0 Median: 1.4751 Max: 8630 Percentiles: P50: 1.48 P75: 1.87 P99: 6.79 P99.9: 119.58 P99.99: 269.34 ------------------------------------------------------ [ 0, 1 ] 642800 19.578% 19.578% #### ( 1, 2 ] 2102554 64.038% 83.616% ############# ( 2, 3 ] 285250 8.688% 92.304% ## ( 3, 4 ] 122942 3.744% 96.048% # ( 4, 6 ] 91487 2.786% 98.835% # ( 6, 10 ] 27449 0.836% 99.671% ( 10, 15 ] 4340 0.132% 99.803% ( 15, 22 ] 588 0.018% 99.821% ( 22, 34 ] 67 0.002% 99.823% ( 34, 51 ] 27 0.001% 99.824% ( 51, 76 ] 29 0.001% 99.825% ( 76, 110 ] 2040 0.062% 99.887% ( 110, 170 ] 2710 0.083% 99.969% ( 170, 250 ] 607 0.018% 99.988% ( 250, 380 ] 475 0.014% 100.002% ( 380, 580 ] 384 0.012% 100.014% ( 580, 870 ] 167 0.005% 100.019% ( 870, 1300 ] 86 0.003% 100.022% ( 1300, 1900 ] 50 0.002% 100.023% ( 1900, 2900 ] 86 0.003% 100.026% ( 2900, 4400 ] 107 0.003% 100.029% ( 4400, 6600 ] 16 0.000% 100.030% ( 6600, 9900 ] 3 0.000% 100.030% ** Level 1 read latency histogram (micros): Count: 1511411 Average: 4.9687 StdDev: 82.63 Min: 0 Median: 1.6013 Max: 8851 Percentiles: P50: 1.60 P75: 2.16 P99: 9.04 P99.9: 165.51 P99.99: 907.82 ------------------------------------------------------ [ 0, 1 ] 230239 15.233% 15.233% ### ( 1, 2 ] 873868 57.818% 73.051% ############ ( 2, 3 ] 189947 12.568% 85.619% ### ( 3, 4 ] 91072 6.026% 91.645% # ( 4, 6 ] 91809 6.074% 97.719% # ( 6, 10 ] 25503 1.687% 99.406% ( 10, 15 ] 5179 0.343% 99.749% ( 15, 22 ] 643 0.043% 99.792% ( 22, 34 ] 49 0.003% 99.795% ( 34, 51 ] 19 0.001% 99.796% ( 51, 76 ] 85 0.006% 99.802% ( 76, 110 ] 852 0.056% 99.858% ( 110, 170 ] 687 0.045% 99.903% ( 170, 250 ] 195 0.013% 99.916% ( 250, 380 ] 270 0.018% 99.934% ( 380, 580 ] 396 0.026% 99.960% ( 580, 870 ] 422 0.028% 99.988% ( 870, 1300 ] 294 0.019% 100.008% ( 1300, 1900 ] 209 0.014% 100.022% ( 1900, 2900 ] 295 0.020% 100.041% ( 2900, 4400 ] 314 0.021% 100.062% ( 4400, 6600 ] 84 0.006% 100.067% ( 6600, 9900 ] 23 0.002% 100.069% ** Level 2 read latency histogram (micros): Count: 60317 Average: 4.9026 StdDev: 61.88 Min: 0 Median: 1.6005 Max: 3988 Percentiles: P50: 1.60 P75: 2.07 P99: 8.87 P99.9: 702.60 P99.99: 3269.06 ------------------------------------------------------ [ 0, 1 ] 8291 13.746% 13.746% ### ( 1, 2 ] 36414 60.371% 74.117% ############ ( 2, 3 ] 7904 13.104% 87.221% ### ( 3, 4 ] 3775 6.259% 93.479% # ( 4, 6 ] 2739 4.541% 98.020% # ( 6, 10 ] 823 1.364% 99.385% ( 10, 15 ] 111 0.184% 99.569% ( 15, 22 ] 10 0.017% 99.586% ( 22, 34 ] 1 0.002% 99.587% ( 51, 76 ] 2 0.003% 99.590% ( 76, 110 ] 25 0.041% 99.632% ( 110, 170 ] 27 0.045% 99.677% ( 170, 250 ] 38 0.063% 99.740% ( 250, 380 ] 40 0.066% 99.806% ( 380, 580 ] 44 0.073% 99.879% ( 580, 870 ] 30 0.050% 99.929% ( 870, 1300 ] 15 0.025% 99.954% ( 1300, 1900 ] 9 0.015% 99.968% ( 1900, 2900 ] 11 0.018% 99.987% ( 2900, 4400 ] 8 0.013% 100.000% ** Level 3 read latency histogram (micros): Count: 448021 Average: 14.1835 StdDev: 163.49 Min: 0 Median: 1.8702 Max: 8387 Percentiles: P50: 1.87 P75: 2.98 P99: 14.36 P99.9: 1732.92 P99.99: 2897.38 ------------------------------------------------------ [ 0, 1 ] 22239 4.964% 4.964% # ( 1, 2 ] 231869 51.754% 56.718% ########## ( 2, 3 ] 83923 18.732% 75.450% #### ( 3, 4 ] 46992 10.489% 85.939% ## ( 4, 6 ] 46702 10.424% 96.363% ## ( 6, 10 ] 9888 2.207% 98.570% ( 10, 15 ] 2209 0.493% 99.063% ( 15, 22 ] 237 0.053% 99.116% ( 22, 34 ] 74 0.017% 99.132% ( 34, 51 ] 24 0.005% 99.138% ( 51, 76 ] 5 0.001% 99.139% ( 76, 110 ] 33 0.007% 99.146% ( 110, 170 ] 193 0.043% 99.189% ( 170, 250 ] 272 0.061% 99.250% ( 250, 380 ] 458 0.102% 99.352% ( 380, 580 ] 726 0.162% 99.514% ( 580, 870 ] 852 0.190% 99.704% ( 870, 1300 ] 623 0.139% 99.843% ( 1300, 1900 ] 352 0.079% 99.922% ( 1900, 2900 ] 306 0.068% 99.990% ( 2900, 4400 ] 404 0.090% 100.080% ( 4400, 6600 ] 85 0.019% 100.099% ( 6600, 9900 ] 15 0.003% 100.103% ** Level 4 read latency histogram (micros): Count: 37471 Average: 7.2415 StdDev: 78.81 Min: 1 Median: 1.9308 Max: 4618 Percentiles: P50: 1.93 P75: 2.98 P99: 11.41 P99.9: 1147.02 P99.99: 3213.22 ------------------------------------------------------ [ 0, 1 ] 850 2.268% 2.268% ( 1, 2 ] 19215 51.280% 53.548% ########## ( 2, 3 ] 8238 21.985% 75.533% #### ( 3, 4 ] 3786 10.104% 85.637% ## ( 4, 6 ] 4168 11.123% 96.760% ## ( 6, 10 ] 800 2.135% 98.895% ( 10, 15 ] 139 0.371% 99.266% ( 15, 22 ] 21 0.056% 99.322% ( 22, 34 ] 9 0.024% 99.346% ( 34, 51 ] 1 0.003% 99.349% ( 51, 76 ] 2 0.005% 99.354% ( 76, 110 ] 10 0.027% 99.381% ( 110, 170 ] 24 0.064% 99.445% ( 170, 250 ] 52 0.139% 99.584% ( 250, 380 ] 32 0.085% 99.669% ( 380, 580 ] 37 0.099% 99.768% ( 580, 870 ] 36 0.096% 99.864% ( 870, 1300 ] 21 0.056% 99.920% ( 1300, 1900 ] 14 0.037% 99.957% ( 1900, 2900 ] 11 0.029% 99.987% ( 2900, 4400 ] 6 0.016% 100.003% ( 4400, 6600 ] 1 0.003% 100.005% ** Level 5 read latency histogram (micros): Count: 220 Average: 1184.7909 StdDev: 1345.66 Min: 73 Median: 620.0000 Max: 8217 Percentiles: P50: 620.00 P75: 1807.69 P99: 6072.00 P99.9: 8217.00 P99.99: 8217.00 ------------------------------------------------------ ( 51, 76 ] 1 0.455% 0.455% ( 76, 110 ] 16 7.273% 7.727% # ( 110, 170 ] 24 10.909% 18.636% ## ( 170, 250 ] 17 7.727% 26.364% ## ( 250, 380 ] 28 12.727% 39.091% ### ( 380, 580 ] 20 9.091% 48.182% ## ( 580, 870 ] 29 13.182% 61.364% ### ( 870, 1300 ] 19 8.636% 70.000% ## ( 1300, 1900 ] 13 5.909% 75.909% # ( 1900, 2900 ] 27 12.273% 88.182% ## ( 2900, 4400 ] 20 9.091% 97.273% ## ( 4400, 6600 ] 5 2.273% 99.545% ( 6600, 9900 ] 1 0.455% 100.000% ** DB Stats ** Uptime(secs): 42.9 total, 3.0 interval Cumulative writes: 0 writes, 8000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 7.69 GB, 183.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:21.280 H:M:S, 49.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 323.37 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.463 H:M:S, 15.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/07/15-05:01:30 ... thread 0: (1000000,9000000) ops and (333594.9,197137.4) ops/second in (2.997648,45.653435) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 17/10 3.68 GB 195.0 7.5 0.0 7.5 16.0 8.5 0.0 1.9 137.6 292.9 55.86 50.27 145 0.385 7802K 12K 0.0 0.0 L1 10/10 1.14 GB 0.0 7.5 4.7 2.8 7.4 4.6 0.1 1.6 232.5 229.7 32.98 31.49 5 6.597 7788K 91K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.1 0.1 0.1 3.5 2.0 231.6 231.6 0.54 0.52 1 0.544 127K 37 0.0 0.0 L3 13/0 884.19 MB 0.9 2.5 1.4 1.1 2.5 1.4 2.2 1.7 146.3 146.0 17.38 11.16 11 1.580 2506K 2542 0.0 0.0 L4 162/0 9.69 GB 1.0 2.3 1.9 0.4 2.3 1.9 1.8 1.2 119.9 119.4 19.70 10.97 18 1.094 2372K 8441 0.0 0.0 L5 1084/0 89.14 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 1286/20 104.51 GB 0.0 19.9 8.1 11.9 28.3 16.4 11.3 3.3 161.2 229.0 126.47 104.41 180 0.703 20M 115K 0.0 0.0 Int 0/0 0.00 KB 0.0 19.9 8.1 11.9 28.3 16.4 10.9 3.3 161.2 229.0 126.47 104.41 180 0.703 20M 115K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 19.9 8.1 11.9 19.8 7.9 0.0 0.0 204.1 202.9 99.86 82.41 59 1.693 20M 115K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 8.5 8.5 0.0 0.0 0.0 326.7 26.61 21.99 121 0.220 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): 45.9 total, 45.7 interval Flush(GB): cumulative 8.490, interval 8.490 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 28.28 GB write, 631.46 MB/s write, 19.91 GB read, 444.49 MB/s read, 126.5 seconds Interval compaction: 28.28 GB write, 634.30 MB/s write, 19.91 GB read, 446.49 MB/s read, 126.5 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 10, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 10, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 56, pending-compaction-bytes-delays: 9, pending-compaction-bytes-stops: 0, total-delays: 19, total-stops: 56, interval: 75 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3583163 Average: 2.6860 StdDev: 29.10 Min: 0 Median: 1.4787 Max: 8630 Percentiles: P50: 1.48 P75: 1.87 P99: 6.59 P99.9: 111.39 P99.99: 244.61 ------------------------------------------------------ [ 0, 1 ] 689329 19.238% 19.238% #### ( 1, 2 ] 2302658 64.263% 83.501% ############# ( 2, 3 ] 315594 8.808% 92.309% ## ( 3, 4 ] 135587 3.784% 96.093% # ( 4, 6 ] 99877 2.787% 98.880% # ( 6, 10 ] 29142 0.813% 99.694% ( 10, 15 ] 4529 0.126% 99.820% ( 15, 22 ] 624 0.017% 99.837% ( 22, 34 ] 75 0.002% 99.840% ( 34, 51 ] 34 0.001% 99.841% ( 51, 76 ] 30 0.001% 99.841% ( 76, 110 ] 2041 0.057% 99.898% ( 110, 170 ] 2716 0.076% 99.974% ( 170, 250 ] 613 0.017% 99.991% ( 250, 380 ] 480 0.013% 100.005% ( 380, 580 ] 386 0.011% 100.015% ( 580, 870 ] 171 0.005% 100.020% ( 870, 1300 ] 90 0.003% 100.023% ( 1300, 1900 ] 50 0.001% 100.024% ( 1900, 2900 ] 90 0.003% 100.027% ( 2900, 4400 ] 109 0.003% 100.030% ( 4400, 6600 ] 16 0.000% 100.030% ( 6600, 9900 ] 3 0.000% 100.030% ** Level 1 read latency histogram (micros): Count: 1645888 Average: 4.7821 StdDev: 79.25 Min: 0 Median: 1.5982 Max: 8851 Percentiles: P50: 1.60 P75: 2.11 P99: 9.00 P99.9: 162.96 P99.99: 888.15 ------------------------------------------------------ [ 0, 1 ] 244511 14.856% 14.856% ### ( 1, 2 ] 966942 58.749% 73.605% ############ ( 2, 3 ] 205259 12.471% 86.076% ## ( 3, 4 ] 96224 5.846% 91.922% # ( 4, 6 ] 95683 5.813% 97.736% # ( 6, 10 ] 27769 1.687% 99.423% ( 10, 15 ] 5395 0.328% 99.751% ( 15, 22 ] 678 0.041% 99.792% ( 22, 34 ] 56 0.003% 99.795% ( 34, 51 ] 20 0.001% 99.796% ( 51, 76 ] 86 0.005% 99.802% ( 76, 110 ] 928 0.056% 99.858% ( 110, 170 ] 783 0.048% 99.906% ( 170, 250 ] 234 0.014% 99.920% ( 250, 380 ] 291 0.018% 99.937% ( 380, 580 ] 420 0.026% 99.963% ( 580, 870 ] 432 0.026% 99.989% ( 870, 1300 ] 294 0.018% 100.007% ( 1300, 1900 ] 209 0.013% 100.020% ( 1900, 2900 ] 295 0.018% 100.038% ( 2900, 4400 ] 314 0.019% 100.057% ( 4400, 6600 ] 84 0.005% 100.062% ( 6600, 9900 ] 23 0.001% 100.063% ** Level 2 read latency histogram (micros): Count: 60317 Average: 4.9026 StdDev: 61.88 Min: 0 Median: 1.6005 Max: 3988 Percentiles: P50: 1.60 P75: 2.07 P99: 8.87 P99.9: 702.60 P99.99: 3269.06 ------------------------------------------------------ [ 0, 1 ] 8291 13.746% 13.746% ### ( 1, 2 ] 36414 60.371% 74.117% ############ ( 2, 3 ] 7904 13.104% 87.221% ### ( 3, 4 ] 3775 6.259% 93.479% # ( 4, 6 ] 2739 4.541% 98.020% # ( 6, 10 ] 823 1.364% 99.385% ( 10, 15 ] 111 0.184% 99.569% ( 15, 22 ] 10 0.017% 99.586% ( 22, 34 ] 1 0.002% 99.587% ( 51, 76 ] 2 0.003% 99.590% ( 76, 110 ] 25 0.041% 99.632% ( 110, 170 ] 27 0.045% 99.677% ( 170, 250 ] 38 0.063% 99.740% ( 250, 380 ] 40 0.066% 99.806% ( 380, 580 ] 44 0.073% 99.879% ( 580, 870 ] 30 0.050% 99.929% ( 870, 1300 ] 15 0.025% 99.954% ( 1300, 1900 ] 9 0.015% 99.968% ( 1900, 2900 ] 11 0.018% 99.987% ( 2900, 4400 ] 8 0.013% 100.000% ** Level 3 read latency histogram (micros): Count: 448021 Average: 14.1835 StdDev: 163.49 Min: 0 Median: 1.8702 Max: 8387 Percentiles: P50: 1.87 P75: 2.98 P99: 14.36 P99.9: 1732.92 P99.99: 2897.38 ------------------------------------------------------ [ 0, 1 ] 22239 4.964% 4.964% # ( 1, 2 ] 231869 51.754% 56.718% ########## ( 2, 3 ] 83923 18.732% 75.450% #### ( 3, 4 ] 46992 10.489% 85.939% ## ( 4, 6 ] 46702 10.424% 96.363% ## ( 6, 10 ] 9888 2.207% 98.570% ( 10, 15 ] 2209 0.493% 99.063% ( 15, 22 ] 237 0.053% 99.116% ( 22, 34 ] 74 0.017% 99.132% ( 34, 51 ] 24 0.005% 99.138% ( 51, 76 ] 5 0.001% 99.139% ( 76, 110 ] 33 0.007% 99.146% ( 110, 170 ] 193 0.043% 99.189% ( 170, 250 ] 272 0.061% 99.250% ( 250, 380 ] 458 0.102% 99.352% ( 380, 580 ] 726 0.162% 99.514% ( 580, 870 ] 852 0.190% 99.704% ( 870, 1300 ] 623 0.139% 99.843% ( 1300, 1900 ] 352 0.079% 99.922% ( 1900, 2900 ] 306 0.068% 99.990% ( 2900, 4400 ] 404 0.090% 100.080% ( 4400, 6600 ] 85 0.019% 100.099% ( 6600, 9900 ] 15 0.003% 100.103% ** Level 4 read latency histogram (micros): Count: 37471 Average: 7.2415 StdDev: 78.81 Min: 1 Median: 1.9308 Max: 4618 Percentiles: P50: 1.93 P75: 2.98 P99: 11.41 P99.9: 1147.02 P99.99: 3213.22 ------------------------------------------------------ [ 0, 1 ] 850 2.268% 2.268% ( 1, 2 ] 19215 51.280% 53.548% ########## ( 2, 3 ] 8238 21.985% 75.533% #### ( 3, 4 ] 3786 10.104% 85.637% ## ( 4, 6 ] 4168 11.123% 96.760% ## ( 6, 10 ] 800 2.135% 98.895% ( 10, 15 ] 139 0.371% 99.266% ( 15, 22 ] 21 0.056% 99.322% ( 22, 34 ] 9 0.024% 99.346% ( 34, 51 ] 1 0.003% 99.349% ( 51, 76 ] 2 0.005% 99.354% ( 76, 110 ] 10 0.027% 99.381% ( 110, 170 ] 24 0.064% 99.445% ( 170, 250 ] 52 0.139% 99.584% ( 250, 380 ] 32 0.085% 99.669% ( 380, 580 ] 37 0.099% 99.768% ( 580, 870 ] 36 0.096% 99.864% ( 870, 1300 ] 21 0.056% 99.920% ( 1300, 1900 ] 14 0.037% 99.957% ( 1900, 2900 ] 11 0.029% 99.987% ( 2900, 4400 ] 6 0.016% 100.003% ( 4400, 6600 ] 1 0.003% 100.005% ** Level 5 read latency histogram (micros): Count: 220 Average: 1184.7909 StdDev: 1345.66 Min: 73 Median: 620.0000 Max: 8217 Percentiles: P50: 620.00 P75: 1807.69 P99: 6072.00 P99.9: 8217.00 P99.99: 8217.00 ------------------------------------------------------ ( 51, 76 ] 1 0.455% 0.455% ( 76, 110 ] 16 7.273% 7.727% # ( 110, 170 ] 24 10.909% 18.636% ## ( 170, 250 ] 17 7.727% 26.364% ## ( 250, 380 ] 28 12.727% 39.091% ### ( 380, 580 ] 20 9.091% 48.182% ## ( 580, 870 ] 29 13.182% 61.364% ### ( 870, 1300 ] 19 8.636% 70.000% ## ( 1300, 1900 ] 13 5.909% 75.909% # ( 1900, 2900 ] 27 12.273% 88.182% ## ( 2900, 4400 ] 20 9.091% 97.273% ## ( 4400, 6600 ] 5 2.273% 99.545% ( 6600, 9900 ] 1 0.455% 100.000% ** DB Stats ** Uptime(secs): 45.9 total, 3.0 interval Cumulative writes: 0 writes, 9000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 8.65 GB, 193.14 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:21.710 H:M:S, 47.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 328.32 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.430 H:M:S, 14.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/07/15-05:01:33 ... thread 0: (1000000,10000000) ops and (317214.6,204893.4) ops/second in (3.152440,48.805875) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 16/4 3.44 GB 327.2 8.7 0.0 8.7 18.1 9.5 0.0 1.9 140.4 293.5 63.26 57.25 162 0.390 9017K 14K 0.0 0.0 L1 27/0 2.35 GB 240.2 9.9 5.9 4.0 9.7 5.8 0.1 1.7 223.6 221.2 45.11 41.87 6 7.518 9060K 91K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.1 0.1 0.1 3.5 2.0 231.6 231.6 0.54 0.52 1 0.544 127K 37 0.0 0.0 L3 13/0 884.19 MB 0.9 2.5 1.4 1.1 2.5 1.4 2.2 1.7 146.3 146.0 17.38 11.16 11 1.580 2506K 2542 0.0 0.0 L4 162/0 9.69 GB 1.0 2.3 1.9 0.4 2.3 1.9 1.8 1.2 119.9 119.4 19.70 10.97 18 1.094 2372K 8441 0.0 0.0 L5 1084/0 89.14 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 1302/4 105.48 GB 0.0 23.4 9.3 14.2 32.8 18.6 11.3 3.5 164.4 229.9 145.99 121.78 198 0.737 23M 116K 0.0 0.0 Int 0/0 0.00 KB 0.0 23.4 9.3 14.2 32.8 18.6 10.9 3.5 164.4 229.9 145.99 121.78 198 0.737 23M 116K 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.4 9.3 14.2 23.3 9.1 0.0 0.0 206.0 204.8 116.51 97.23 64 1.821 23M 116K 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 329.1 29.48 24.54 134 0.220 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 49.0 total, 48.8 interval Flush(GB): cumulative 9.474, interval 9.474 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 32.78 GB write, 684.81 MB/s write, 23.44 GB read, 489.66 MB/s read, 146.0 seconds Interval compaction: 32.78 GB write, 687.69 MB/s write, 23.44 GB read, 491.72 MB/s read, 146.0 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 10, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 10, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 61, pending-compaction-bytes-delays: 9, pending-compaction-bytes-stops: 0, total-delays: 19, total-stops: 61, interval: 80 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3865586 Average: 2.6473 StdDev: 28.23 Min: 0 Median: 1.4746 Max: 8630 Percentiles: P50: 1.47 P75: 1.86 P99: 6.38 P99.9: 106.93 P99.99: 240.91 ------------------------------------------------------ [ 0, 1 ] 752781 19.474% 19.474% #### ( 1, 2 ] 2486531 64.325% 83.799% ############# ( 2, 3 ] 336062 8.694% 92.492% ## ( 3, 4 ] 143854 3.721% 96.214% # ( 4, 6 ] 104835 2.712% 98.926% # ( 6, 10 ] 30255 0.783% 99.709% ( 10, 15 ] 4742 0.123% 99.831% ( 15, 22 ] 642 0.017% 99.848% ( 22, 34 ] 78 0.002% 99.850% ( 34, 51 ] 35 0.001% 99.851% ( 51, 76 ] 37 0.001% 99.852% ( 76, 110 ] 2055 0.053% 99.905% ( 110, 170 ] 2735 0.071% 99.976% ( 170, 250 ] 630 0.016% 99.992% ( 250, 380 ] 497 0.013% 100.005% ( 380, 580 ] 399 0.010% 100.015% ( 580, 870 ] 183 0.005% 100.020% ( 870, 1300 ] 98 0.003% 100.022% ( 1300, 1900 ] 53 0.001% 100.024% ( 1900, 2900 ] 91 0.002% 100.026% ( 2900, 4400 ] 110 0.003% 100.029% ( 4400, 6600 ] 16 0.000% 100.029% ( 6600, 9900 ] 3 0.000% 100.029% ** Level 1 read latency histogram (micros): Count: 1725891 Average: 4.7175 StdDev: 77.76 Min: 0 Median: 1.5954 Max: 8851 Percentiles: P50: 1.60 P75: 2.08 P99: 8.99 P99.9: 166.48 P99.99: 906.99 ------------------------------------------------------ [ 0, 1 ] 253964 14.715% 14.715% ### ( 1, 2 ] 1022847 59.265% 73.980% ############ ( 2, 3 ] 213407 12.365% 86.345% ## ( 3, 4 ] 99027 5.738% 92.083% # ( 4, 6 ] 97663 5.659% 97.741% # ( 6, 10 ] 29074 1.685% 99.426% ( 10, 15 ] 5514 0.319% 99.745% ( 15, 22 ] 685 0.040% 99.785% ( 22, 34 ] 57 0.003% 99.788% ( 34, 51 ] 20 0.001% 99.790% ( 51, 76 ] 87 0.005% 99.795% ( 76, 110 ] 988 0.057% 99.852% ( 110, 170 ] 884 0.051% 99.903% ( 170, 250 ] 274 0.016% 99.919% ( 250, 380 ] 305 0.018% 99.937% ( 380, 580 ] 444 0.026% 99.962% ( 580, 870 ] 452 0.026% 99.988% ( 870, 1300 ] 307 0.018% 100.006% ( 1300, 1900 ] 215 0.012% 100.019% ( 1900, 2900 ] 297 0.017% 100.036% ( 2900, 4400 ] 314 0.018% 100.054% ( 4400, 6600 ] 85 0.005% 100.059% ( 6600, 9900 ] 23 0.001% 100.060% ** Level 2 read latency histogram (micros): Count: 60317 Average: 4.9026 StdDev: 61.88 Min: 0 Median: 1.6005 Max: 3988 Percentiles: P50: 1.60 P75: 2.07 P99: 8.87 P99.9: 702.60 P99.99: 3269.06 ------------------------------------------------------ [ 0, 1 ] 8291 13.746% 13.746% ### ( 1, 2 ] 36414 60.371% 74.117% ############ ( 2, 3 ] 7904 13.104% 87.221% ### ( 3, 4 ] 3775 6.259% 93.479% # ( 4, 6 ] 2739 4.541% 98.020% # ( 6, 10 ] 823 1.364% 99.385% ( 10, 15 ] 111 0.184% 99.569% ( 15, 22 ] 10 0.017% 99.586% ( 22, 34 ] 1 0.002% 99.587% ( 51, 76 ] 2 0.003% 99.590% ( 76, 110 ] 25 0.041% 99.632% ( 110, 170 ] 27 0.045% 99.677% ( 170, 250 ] 38 0.063% 99.740% ( 250, 380 ] 40 0.066% 99.806% ( 380, 580 ] 44 0.073% 99.879% ( 580, 870 ] 30 0.050% 99.929% ( 870, 1300 ] 15 0.025% 99.954% ( 1300, 1900 ] 9 0.015% 99.968% ( 1900, 2900 ] 11 0.018% 99.987% ( 2900, 4400 ] 8 0.013% 100.000% ** Level 3 read latency histogram (micros): Count: 448021 Average: 14.1835 StdDev: 163.49 Min: 0 Median: 1.8702 Max: 8387 Percentiles: P50: 1.87 P75: 2.98 P99: 14.36 P99.9: 1732.92 P99.99: 2897.38 ------------------------------------------------------ [ 0, 1 ] 22239 4.964% 4.964% # ( 1, 2 ] 231869 51.754% 56.718% ########## ( 2, 3 ] 83923 18.732% 75.450% #### ( 3, 4 ] 46992 10.489% 85.939% ## ( 4, 6 ] 46702 10.424% 96.363% ## ( 6, 10 ] 9888 2.207% 98.570% ( 10, 15 ] 2209 0.493% 99.063% ( 15, 22 ] 237 0.053% 99.116% ( 22, 34 ] 74 0.017% 99.132% ( 34, 51 ] 24 0.005% 99.138% ( 51, 76 ] 5 0.001% 99.139% ( 76, 110 ] 33 0.007% 99.146% ( 110, 170 ] 193 0.043% 99.189% ( 170, 250 ] 272 0.061% 99.250% ( 250, 380 ] 458 0.102% 99.352% ( 380, 580 ] 726 0.162% 99.514% ( 580, 870 ] 852 0.190% 99.704% ( 870, 1300 ] 623 0.139% 99.843% ( 1300, 1900 ] 352 0.079% 99.922% ( 1900, 2900 ] 306 0.068% 99.990% ( 2900, 4400 ] 404 0.090% 100.080% ( 4400, 6600 ] 85 0.019% 100.099% ( 6600, 9900 ] 15 0.003% 100.103% ** Level 4 read latency histogram (micros): Count: 37471 Average: 7.2415 StdDev: 78.81 Min: 1 Median: 1.9308 Max: 4618 Percentiles: P50: 1.93 P75: 2.98 P99: 11.41 P99.9: 1147.02 P99.99: 3213.22 ------------------------------------------------------ [ 0, 1 ] 850 2.268% 2.268% ( 1, 2 ] 19215 51.280% 53.548% ########## ( 2, 3 ] 8238 21.985% 75.533% #### ( 3, 4 ] 3786 10.104% 85.637% ## ( 4, 6 ] 4168 11.123% 96.760% ## ( 6, 10 ] 800 2.135% 98.895% ( 10, 15 ] 139 0.371% 99.266% ( 15, 22 ] 21 0.056% 99.322% ( 22, 34 ] 9 0.024% 99.346% ( 34, 51 ] 1 0.003% 99.349% ( 51, 76 ] 2 0.005% 99.354% ( 76, 110 ] 10 0.027% 99.381% ( 110, 170 ] 24 0.064% 99.445% ( 170, 250 ] 52 0.139% 99.584% ( 250, 380 ] 32 0.085% 99.669% ( 380, 580 ] 37 0.099% 99.768% ( 580, 870 ] 36 0.096% 99.864% ( 870, 1300 ] 21 0.056% 99.920% ( 1300, 1900 ] 14 0.037% 99.957% ( 1900, 2900 ] 11 0.029% 99.987% ( 2900, 4400 ] 6 0.016% 100.003% ( 4400, 6600 ] 1 0.003% 100.005% ** Level 5 read latency histogram (micros): Count: 220 Average: 1184.7909 StdDev: 1345.66 Min: 73 Median: 620.0000 Max: 8217 Percentiles: P50: 620.00 P75: 1807.69 P99: 6072.00 P99.9: 8217.00 P99.99: 8217.00 ------------------------------------------------------ ( 51, 76 ] 1 0.455% 0.455% ( 76, 110 ] 16 7.273% 7.727% # ( 110, 170 ] 24 10.909% 18.636% ## ( 170, 250 ] 17 7.727% 26.364% ## ( 250, 380 ] 28 12.727% 39.091% ### ( 380, 580 ] 20 9.091% 48.182% ## ( 580, 870 ] 29 13.182% 61.364% ### ( 870, 1300 ] 19 8.636% 70.000% ## ( 1300, 1900 ] 13 5.909% 75.909% # ( 1900, 2900 ] 27 12.273% 88.182% ## ( 2900, 4400 ] 20 9.091% 97.273% ## ( 4400, 6600 ] 5 2.273% 99.545% ( 6600, 9900 ] 1 0.455% 100.000% ** DB Stats ** Uptime(secs): 49.0 total, 3.2 interval Cumulative writes: 0 writes, 10M keys, 0 commit groups, 0.0 writes per commit group, ingest: 9.61 GB, 200.80 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:22.324 H:M:S, 45.5 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 312.20 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.614 H:M:S, 19.5 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.957 micros/op 167865 ops/sec 60.048 seconds 10079999 operations; 162.7 MB/s Microseconds per write: Count: 10079999 Average: 5.9569 StdDev: 466.84 Min: 0 Median: 1.7122 Max: 878489 Percentiles: P50: 1.71 P75: 2.64 P99: 8.27 P99.9: 1184.63 P99.99: 2754.50 ------------------------------------------------------ [ 0, 1 ] 1502984 14.911% 14.911% ### ( 1, 2 ] 4966578 49.272% 64.182% ########## ( 2, 3 ] 1707154 16.936% 81.118% ### ( 3, 4 ] 1310536 13.001% 94.120% ### ( 4, 6 ] 443233 4.397% 98.517% # ( 6, 10 ] 86028 0.853% 99.370% ( 10, 15 ] 24284 0.241% 99.611% ( 15, 22 ] 7109 0.071% 99.682% ( 22, 34 ] 2051 0.020% 99.702% ( 34, 51 ] 234 0.002% 99.704% ( 51, 76 ] 26 0.000% 99.705% ( 76, 110 ] 7200 0.071% 99.776% ( 110, 170 ] 2628 0.026% 99.802% ( 170, 250 ] 293 0.003% 99.805% ( 250, 380 ] 90 0.001% 99.806% ( 380, 580 ] 13 0.000% 99.806% ( 580, 870 ] 23 0.000% 99.806% ( 870, 1300 ] 12922 0.128% 99.934% ( 1300, 1900 ] 14 0.000% 99.935% ( 1900, 2900 ] 6543 0.065% 99.999% ( 2900, 4400 ] 16 0.000% 100.000% ( 4400, 6600 ] 6 0.000% 100.000% ( 6600, 9900 ] 5 0.000% 100.000% ( 9900, 14000 ] 2 0.000% 100.000% ( 14000, 22000 ] 1 0.000% 100.000% ( 22000, 33000 ] 3 0.000% 100.000% ( 33000, 50000 ] 1 0.000% 100.000% ( 110000, 170000 ] 1 0.000% 100.000% ( 170000, 250000 ] 18 0.000% 100.000% ( 250000, 380000 ] 1 0.000% 100.000% ( 570000, 860000 ] 1 0.000% 100.000% ( 860000, 1200000 ] 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 : 193939 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 : 10079999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 10402558968 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 : 481 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 33293928 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 : 28211209973 rocksdb.compact.write.bytes COUNT : 28022420218 rocksdb.flush.write.bytes COUNT : 10370968862 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 : 51 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 : 288 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 : 10287395840 rocksdb.memtable.garbage.bytes.at.flush COUNT : 4029440 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 : 28304210639 rocksdb.non.last.level.read.count COUNT : 6836957 rocksdb.block.checksum.compute.count COUNT : 6836046 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.344456 P95 : 3.775135 P99 : 6.429211 P100 : 878486.000000 COUNT : 10079999 SUM : 55494366 rocksdb.compaction.times.micros P50 : 1120312.500000 P95 : 6225000.000000 P99 : 16800000.000000 P100 : 18750751.000000 COUNT : 65 SUM : 117445438 rocksdb.compaction.times.cpu_micros P50 : 936206.896552 P95 : 5950000.000000 P99 : 16800000.000000 P100 : 17735667.000000 COUNT : 65 SUM : 98148745 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 : 704.036145 P95 : 1275.633333 P99 : 65750.000000 P100 : 136333.000000 COUNT : 137 SUM : 316365 rocksdb.compaction.outfile.sync.micros P50 : 921.343284 P95 : 91187.500000 P99 : 157640.000000 P100 : 216651.000000 COUNT : 306 SUM : 3939907 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 : 99.623377 P95 : 1558.000000 P99 : 3715.000000 P100 : 4599.000000 COUNT : 237 SUM : 72451 rocksdb.table.open.io.micros P50 : 1566.250000 P95 : 7536.964286 P99 : 9804.535714 P100 : 15377.000000 COUNT : 481 SUM : 1035665 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.536842 P95 : 7.240186 P99 : 10.632313 P100 : 11410.000000 COUNT : 6834787 SUM : 40703345 rocksdb.read.block.get.micros P50 : 507.659574 P95 : 3325.510204 P99 : 5019.666667 P100 : 8379.000000 COUNT : 962 SUM : 850229 rocksdb.write.raw.block.micros P50 : 0.511788 P95 : 0.972398 P99 : 2.698878 P100 : 13044.000000 COUNT : 9298761 SUM : 18072546 rocksdb.numfiles.in.singlecompaction P50 : 3.376623 P95 : 7.733333 P99 : 32.320000 P100 : 41.000000 COUNT : 114 SUM : 494 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.561746 P95 : 1222.141116 P99 : 2632.636656 P100 : 878288.000000 COUNT : 178215 SUM : 33306927 rocksdb.sst.read.micros P50 : 1.503658 P95 : 4.219344 P99 : 8.118767 P100 : 8851.000000 COUNT : 6837327 SUM : 26942084 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 : 10079999 SUM : 10402558968 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 : 209545.454545 P95 : 373861.111111 P99 : 967100.000000 P100 : 1021332.000000 COUNT : 137 SUM : 30003408 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 : 297 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