[2024-07-26 23:39:01.174056] Starting SPDK v24.05.1-pre git sha1 241d0f3c9 / DPDK 23.11.0 initialization... [2024-07-26 23:39:01.174166] [ 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_pid2694450 ] Set seed to 1722029941171735 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-07-26 23:39:01.270742] app.c: 909:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-07-26 23:39:01.308610] app.c: 604:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-07-26 23:39:01.308658] app.c: 605:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 2694450' to capture a snapshot of events at runtime. [2024-07-26 23:39:01.308668] app.c: 610:app_setup_trace: *NOTICE*: 'spdk_trace' without parameters will also work if this is the only [2024-07-26 23:39:01.308694] app.c: 611:app_setup_trace: *NOTICE*: SPDK application currently running. [2024-07-26 23:39:01.308703] app.c: 612:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid2694450 for offline analysis/debug. [2024-07-26 23:39:01.308786] reactor.c: 937:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Fri Jul 26 23:39:05 2024 CPU: 96 * Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz CPUCache: 36608 KB 2024/07/26-23:39:08 ... thread 0: (1000000,1000000) ops and (336302.5,336302.5) ops/second in (2.973513,2.973513) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 9/6 629.97 MB 25.2 0.0 0.0 0.0 0.9 0.9 0.0 1.0 0.0 348.4 2.53 2.29 12 0.211 0 0 0.0 0.0 L2 3/2 251.71 MB 0.0 0.4 0.2 0.2 0.4 0.2 0.1 2.0 248.7 248.5 1.52 1.47 2 0.760 383K 216 0.0 0.0 L3 12/0 993.05 MB 1.0 0.0 0.0 0.0 0.0 0.0 0.1 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 116/0 9.54 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1040/0 85.63 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1180/8 97.00 GB 0.0 0.4 0.2 0.2 1.2 1.0 0.2 1.4 93.3 310.9 4.05 3.76 14 0.289 383K 216 0.0 0.0 Int 0/0 0.00 KB 0.0 0.4 0.2 0.2 1.2 1.0 0.2 1.4 93.3 310.9 4.05 3.76 14 0.289 383K 216 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 0.0 0.0 248.7 248.5 1.52 1.47 2 0.760 383K 216 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 348.4 2.53 2.29 12 0.211 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 3.2 total, 3.0 interval Flush(GB): cumulative 0.861, interval 0.861 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 1.23 GB write, 399.50 MB/s write, 0.37 GB read, 119.85 MB/s read, 4.1 seconds Interval compaction: 1.23 GB write, 423.42 MB/s write, 0.37 GB read, 127.03 MB/s read, 4.1 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 4, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 4, interval: 4 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 110299 Average: 2.0116 StdDev: 24.23 Min: 0 Median: 1.2643 Max: 3589 Percentiles: P50: 1.26 P75: 1.69 P99: 4.13 P99.9: 9.25 P99.99: 378.70 ------------------------------------------------------ [ 0, 1 ] 38176 34.611% 34.611% ####### ( 1, 2 ] 64214 58.218% 92.829% ############ ( 2, 3 ] 5034 4.564% 97.393% # ( 3, 4 ] 1719 1.558% 98.952% ( 4, 6 ] 819 0.743% 99.694% ( 6, 10 ] 279 0.253% 99.947% ( 10, 15 ] 26 0.024% 99.971% ( 15, 22 ] 6 0.005% 99.976% ( 22, 34 ] 1 0.001% 99.977% ( 34, 51 ] 1 0.001% 99.978% ( 110, 170 ] 9 0.008% 99.986% ( 170, 250 ] 1 0.001% 99.987% ( 250, 380 ] 3 0.003% 99.990% ( 580, 870 ] 1 0.001% 99.991% ( 870, 1300 ] 3 0.003% 99.994% ( 1300, 1900 ] 1 0.001% 99.995% ( 1900, 2900 ] 1 0.001% 99.995% ( 2900, 4400 ] 5 0.005% 100.000% ** Level 1 read latency histogram (micros): Count: 5 Average: 685.8000 StdDev: 309.31 Min: 340 Median: 652.5000 Max: 1214 Percentiles: P50: 652.50 P75: 833.75 P99: 1214.00 P99.9: 1214.00 P99.99: 1214.00 ------------------------------------------------------ ( 250, 380 ] 1 20.000% 20.000% #### ( 380, 580 ] 1 20.000% 40.000% #### ( 580, 870 ] 2 40.000% 80.000% ######## ( 870, 1300 ] 1 20.000% 100.000% #### ** Level 2 read latency histogram (micros): Count: 71359 Average: 1.9442 StdDev: 10.22 Min: 1 Median: 1.3071 Max: 1591 Percentiles: P50: 1.31 P75: 1.72 P99: 5.01 P99.9: 10.00 P99.99: 371.17 ------------------------------------------------------ [ 0, 1 ] 22488 31.514% 31.514% ###### ( 1, 2 ] 42958 60.200% 91.714% ############ ( 2, 3 ] 3392 4.753% 96.467% # ( 3, 4 ] 1446 2.026% 98.494% ( 4, 6 ] 716 1.003% 99.497% ( 6, 10 ] 288 0.404% 99.901% ( 10, 15 ] 50 0.070% 99.971% ( 15, 22 ] 6 0.008% 99.979% ( 22, 34 ] 2 0.003% 99.982% ( 34, 51 ] 2 0.003% 99.985% ( 76, 110 ] 1 0.001% 99.986% ( 170, 250 ] 1 0.001% 99.987% ( 250, 380 ] 2 0.003% 99.990% ( 380, 580 ] 1 0.001% 99.992% ( 580, 870 ] 3 0.004% 99.996% ( 870, 1300 ] 1 0.001% 99.997% ( 1300, 1900 ] 2 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 50 Average: 1783.0800 StdDev: 1355.35 Min: 241 Median: 1300.0000 Max: 5205 Percentiles: P50: 1300.00 P75: 2622.22 P99: 5205.00 P99.9: 5205.00 P99.99: 5205.00 ------------------------------------------------------ ( 170, 250 ] 1 2.000% 2.000% ( 250, 380 ] 4 8.000% 10.000% ## ( 380, 580 ] 4 8.000% 18.000% ## ( 580, 870 ] 5 10.000% 28.000% ## ( 870, 1300 ] 11 22.000% 50.000% #### ( 1300, 1900 ] 6 12.000% 62.000% ## ( 1900, 2900 ] 9 18.000% 80.000% #### ( 2900, 4400 ] 6 12.000% 92.000% ## ( 4400, 6600 ] 4 8.000% 100.000% ## ** Level 4 read latency histogram (micros): Count: 20 Average: 1810.1000 StdDev: 1275.52 Min: 337 Median: 1300.0000 Max: 5246 Percentiles: P50: 1300.00 P75: 1900.00 P99: 5246.00 P99.9: 5246.00 P99.99: 5246.00 ------------------------------------------------------ ( 250, 380 ] 1 5.000% 5.000% # ( 580, 870 ] 1 5.000% 10.000% # ( 870, 1300 ] 8 40.000% 50.000% ######## ( 1300, 1900 ] 5 25.000% 75.000% ##### ( 1900, 2900 ] 1 5.000% 80.000% # ( 2900, 4400 ] 3 15.000% 95.000% ### ( 4400, 6600 ] 1 5.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, 312.13 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:0.431 H:M:S, 13.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 330.74 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.431 H:M:S, 14.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/07/26-23:39:11 ... thread 0: (1000000,2000000) ops and (319481.9,327676.5) ops/second in (3.130068,6.103581) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 11/10 1.23 GB 6.3 0.6 0.0 0.6 2.4 1.8 0.0 1.3 74.2 321.5 7.64 7.00 28 0.273 575K 654 0.0 0.0 L1 1/1 3.76 MB 0.0 0.4 0.4 0.0 0.4 0.4 0.2 1.0 232.2 231.8 1.63 1.57 1 1.628 383K 613 0.0 0.0 L2 2/1 53.62 MB 0.5 0.4 0.2 0.2 0.4 0.2 0.5 2.0 248.7 248.5 1.52 1.47 2 0.760 383K 216 0.0 0.0 L3 18/8 962.64 MB 0.3 0.2 0.2 0.0 0.2 0.2 0.4 1.0 233.0 233.0 1.07 1.01 1 1.069 253K 0 0.0 0.0 L4 169/0 9.51 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.4 1.0 146.8 146.8 1.53 1.11 1 1.527 227K 0 0.0 0.0 L5 1048/0 86.25 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 1249/20 97.98 GB 0.0 1.8 1.0 0.7 3.6 2.9 2.1 1.9 134.2 275.3 13.38 12.16 33 0.406 1823K 1483 0.0 0.0 Int 0/0 0.00 KB 0.0 1.8 1.0 0.7 3.6 2.9 2.1 1.9 134.2 275.3 13.38 12.16 33 0.406 1823K 1483 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 1.8 1.0 0.7 1.8 1.0 0.0 0.0 226.3 226.1 7.94 7.31 7 1.134 1823K 1483 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 347.0 5.45 4.85 26 0.209 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 6.3 total, 6.1 interval Flush(GB): cumulative 1.846, interval 1.846 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 3.60 GB write, 586.42 MB/s write, 1.75 GB read, 285.88 MB/s read, 13.4 seconds Interval compaction: 3.60 GB write, 603.53 MB/s write, 1.75 GB read, 294.22 MB/s read, 13.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: 10, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 10, interval: 10 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 390272 Average: 2.2542 StdDev: 17.46 Min: 0 Median: 1.4961 Max: 4506 Percentiles: P50: 1.50 P75: 1.88 P99: 5.66 P99.9: 9.90 P99.99: 17.27 ------------------------------------------------------ [ 0, 1 ] 70625 18.096% 18.096% #### ( 1, 2 ] 250998 64.314% 82.410% ############# ( 2, 3 ] 41821 10.716% 93.126% ## ( 3, 4 ] 14868 3.810% 96.935% # ( 4, 6 ] 9731 2.493% 99.429% ( 6, 10 ] 1884 0.483% 99.912% ( 10, 15 ] 292 0.075% 99.986% ( 15, 22 ] 43 0.011% 99.997% ( 22, 34 ] 7 0.002% 99.999% ( 34, 51 ] 3 0.001% 100.000% ( 51, 76 ] 3 0.001% 100.001% ( 110, 170 ] 18 0.005% 100.005% ( 170, 250 ] 4 0.001% 100.006% ( 250, 380 ] 6 0.002% 100.008% ( 380, 580 ] 4 0.001% 100.009% ( 580, 870 ] 5 0.001% 100.010% ( 870, 1300 ] 7 0.002% 100.012% ( 1300, 1900 ] 2 0.001% 100.013% ( 1900, 2900 ] 3 0.001% 100.013% ( 2900, 4400 ] 6 0.002% 100.015% ( 4400, 6600 ] 1 0.000% 100.015% ** Level 1 read latency histogram (micros): Count: 31 Average: 277.0000 StdDev: 430.59 Min: 1 Median: 2.5000 Max: 1924 Percentiles: P50: 2.50 P75: 396.67 P99: 1924.00 P99.9: 1924.00 P99.99: 1924.00 ------------------------------------------------------ [ 0, 1 ] 8 25.806% 25.806% ##### ( 1, 2 ] 7 22.581% 48.387% ##### ( 2, 3 ] 1 3.226% 51.613% # ( 6, 10 ] 1 3.226% 54.839% # ( 110, 170 ] 1 3.226% 58.065% # ( 170, 250 ] 1 3.226% 61.290% # ( 250, 380 ] 4 12.903% 74.194% ### ( 380, 580 ] 3 9.677% 83.871% ## ( 580, 870 ] 3 9.677% 93.548% ## ( 870, 1300 ] 1 3.226% 96.774% # ( 1900, 2900 ] 1 3.226% 100.000% # ** Level 2 read latency histogram (micros): Count: 95823 Average: 2.0127 StdDev: 8.83 Min: 1 Median: 1.3718 Max: 1591 Percentiles: P50: 1.37 P75: 1.78 P99: 5.41 P99.9: 9.99 P99.99: 203.42 ------------------------------------------------------ [ 0, 1 ] 25866 26.994% 26.994% ##### ( 1, 2 ] 59292 61.877% 88.870% ############ ( 2, 3 ] 6038 6.301% 95.171% # ( 3, 4 ] 2614 2.728% 97.899% # ( 4, 6 ] 1492 1.557% 99.456% ( 6, 10 ] 426 0.445% 99.901% ( 10, 15 ] 69 0.072% 99.973% ( 15, 22 ] 10 0.010% 99.983% ( 22, 34 ] 2 0.002% 99.985% ( 34, 51 ] 2 0.002% 99.987% ( 51, 76 ] 1 0.001% 99.989% ( 76, 110 ] 1 0.001% 99.990% ( 170, 250 ] 1 0.001% 99.991% ( 250, 380 ] 2 0.002% 99.993% ( 380, 580 ] 1 0.001% 99.994% ( 580, 870 ] 3 0.003% 99.997% ( 870, 1300 ] 1 0.001% 99.998% ( 1300, 1900 ] 2 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 184456 Average: 3.5292 StdDev: 40.37 Min: 1 Median: 1.6882 Max: 5205 Percentiles: P50: 1.69 P75: 2.31 P99: 9.07 P99.9: 167.08 P99.99: 503.97 ------------------------------------------------------ [ 0, 1 ] 14317 7.762% 7.762% ## ( 1, 2 ] 113208 61.374% 69.136% ############ ( 2, 3 ] 35350 19.164% 88.300% #### ( 3, 4 ] 9459 5.128% 93.428% # ( 4, 6 ] 8049 4.364% 97.792% # ( 6, 10 ] 2904 1.574% 99.366% ( 10, 15 ] 596 0.323% 99.689% ( 15, 22 ] 114 0.062% 99.751% ( 22, 34 ] 32 0.017% 99.769% ( 34, 51 ] 5 0.003% 99.771% ( 51, 76 ] 8 0.004% 99.776% ( 76, 110 ] 85 0.046% 99.822% ( 110, 170 ] 153 0.083% 99.905% ( 170, 250 ] 86 0.047% 99.951% ( 250, 380 ] 49 0.027% 99.978% ( 380, 580 ] 38 0.021% 99.998% ( 580, 870 ] 21 0.011% 100.010% ( 870, 1300 ] 17 0.009% 100.019% ( 1300, 1900 ] 7 0.004% 100.023% ( 1900, 2900 ] 10 0.005% 100.028% ( 2900, 4400 ] 7 0.004% 100.032% ( 4400, 6600 ] 4 0.002% 100.034% ** Level 4 read latency histogram (micros): Count: 305 Average: 126.8262 StdDev: 554.15 Min: 0 Median: 1.6059 Max: 5246 Percentiles: P50: 1.61 P75: 6.69 P99: 3375.00 P99.9: 5246.00 P99.99: 5246.00 ------------------------------------------------------ [ 0, 1 ] 81 26.557% 26.557% ##### ( 1, 2 ] 118 38.689% 65.246% ######## ( 2, 3 ] 16 5.246% 70.492% # ( 3, 4 ] 4 1.311% 71.803% ( 4, 6 ] 7 2.295% 74.098% ( 6, 10 ] 16 5.246% 79.344% # ( 10, 15 ] 35 11.475% 90.820% ## ( 15, 22 ] 3 0.984% 91.803% ( 76, 110 ] 1 0.328% 92.131% ( 170, 250 ] 1 0.328% 92.459% ( 250, 380 ] 3 0.984% 93.443% ( 380, 580 ] 1 0.328% 93.770% ( 580, 870 ] 1 0.328% 94.098% ( 870, 1300 ] 8 2.623% 96.721% # ( 1300, 1900 ] 5 1.639% 98.361% ( 1900, 2900 ] 1 0.328% 98.689% ( 2900, 4400 ] 3 0.984% 99.672% ( 4400, 6600 ] 1 0.328% 100.000% ** Level 5 read latency histogram (micros): Count: 40 Average: 852.0500 StdDev: 1109.87 Min: 104 Median: 354.0000 Max: 5474 Percentiles: P50: 354.00 P75: 1128.00 P99: 5474.00 P99.9: 5474.00 P99.99: 5474.00 ------------------------------------------------------ ( 76, 110 ] 3 7.500% 7.500% ## ( 110, 170 ] 10 25.000% 32.500% ##### ( 170, 250 ] 3 7.500% 40.000% ## ( 250, 380 ] 5 12.500% 52.500% ### ( 380, 580 ] 4 10.000% 62.500% ## ( 580, 870 ] 2 5.000% 67.500% # ( 870, 1300 ] 5 12.500% 80.000% ### ( 1300, 1900 ] 2 5.000% 85.000% # ( 1900, 2900 ] 4 10.000% 95.000% ## ( 2900, 4400 ] 1 2.500% 97.500% # ( 4400, 6600 ] 1 2.500% 100.000% # ** DB Stats ** Uptime(secs): 6.3 total, 3.1 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 313.28 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.927 H:M:S, 14.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 314.43 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.497 H:M:S, 15.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/07/26-23:39:14 ... thread 0: (1000000,3000000) ops and (354330.5,336104.1) ops/second in (2.822224,8.925805) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 9/4 1.23 GB 100.7 1.4 0.0 1.4 4.1 2.7 0.0 1.5 104.4 313.0 13.28 12.31 44 0.302 1407K 1470 0.0 0.0 L1 9/0 881.84 MB 88.2 1.2 1.2 0.0 1.2 1.2 0.2 1.0 233.4 232.7 5.41 5.26 2 2.705 1282K 3605 0.0 0.0 L2 1/0 51.08 MB 0.5 0.4 0.2 0.2 0.4 0.2 0.5 2.0 248.7 248.5 1.52 1.47 2 0.760 383K 216 0.0 0.0 L3 15/0 963.59 MB 1.0 0.8 0.2 0.6 0.8 0.2 0.4 3.4 226.7 226.3 3.82 3.58 2 1.912 880K 1608 0.0 0.0 L4 169/0 9.51 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.4 1.0 146.8 146.8 1.53 1.11 1 1.527 227K 0 0.0 0.0 L5 1048/0 86.25 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 1251/4 98.84 GB 0.0 4.0 1.9 2.1 6.7 4.6 2.1 2.5 161.1 269.3 25.56 23.72 51 0.501 4181K 6899 0.0 0.0 Int 0/0 0.00 KB 0.0 4.0 1.9 2.1 6.7 4.6 2.1 2.5 161.1 269.3 25.56 23.72 51 0.501 4181K 6899 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.0 1.9 2.1 4.0 1.9 0.0 0.0 233.7 233.3 17.62 16.66 12 1.469 4181K 6899 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 2.7 2.7 0.0 0.0 0.0 349.3 7.94 7.07 39 0.203 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 9.1 total, 8.9 interval Flush(GB): cumulative 2.707, interval 2.707 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 6.72 GB write, 755.88 MB/s write, 4.02 GB read, 452.24 MB/s read, 25.6 seconds Interval compaction: 6.72 GB write, 770.96 MB/s write, 4.02 GB read, 461.27 MB/s read, 25.6 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: 13, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 13, interval: 13 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 758288 Average: 2.2438 StdDev: 13.84 Min: 0 Median: 1.5180 Max: 4506 Percentiles: P50: 1.52 P75: 1.90 P99: 5.62 P99.9: 9.79 P99.99: 13.97 ------------------------------------------------------ [ 0, 1 ] 121359 16.004% 16.004% ### ( 1, 2 ] 497669 65.631% 81.635% ############# ( 2, 3 ] 86790 11.446% 93.080% ## ( 3, 4 ] 29426 3.881% 96.961% # ( 4, 6 ] 19097 2.518% 99.479% # ( 6, 10 ] 3361 0.443% 99.923% ( 10, 15 ] 643 0.085% 100.008% ( 15, 22 ] 69 0.009% 100.017% ( 22, 34 ] 12 0.002% 100.018% ( 34, 51 ] 5 0.001% 100.019% ( 51, 76 ] 6 0.001% 100.020% ( 76, 110 ] 1 0.000% 100.020% ( 110, 170 ] 26 0.003% 100.023% ( 170, 250 ] 8 0.001% 100.024% ( 250, 380 ] 8 0.001% 100.025% ( 380, 580 ] 11 0.001% 100.027% ( 580, 870 ] 9 0.001% 100.028% ( 870, 1300 ] 11 0.001% 100.029% ( 1300, 1900 ] 3 0.000% 100.030% ( 1900, 2900 ] 4 0.001% 100.030% ( 2900, 4400 ] 7 0.001% 100.031% ( 4400, 6600 ] 1 0.000% 100.031% ** Level 1 read latency histogram (micros): Count: 13260 Average: 4.9046 StdDev: 38.70 Min: 0 Median: 1.6880 Max: 1924 Percentiles: P50: 1.69 P75: 2.28 P99: 9.91 P99.9: 560.62 P99.99: 1271.96 ------------------------------------------------------ [ 0, 1 ] 797 6.011% 6.011% # ( 1, 2 ] 8478 63.937% 69.947% ############# ( 2, 3 ] 2357 17.775% 87.722% #### ( 3, 4 ] 731 5.513% 93.235% # ( 4, 6 ] 534 4.027% 97.262% # ( 6, 10 ] 236 1.780% 99.042% ( 10, 15 ] 28 0.211% 99.253% ( 15, 22 ] 4 0.030% 99.284% ( 34, 51 ] 1 0.008% 99.291% ( 110, 170 ] 39 0.294% 99.585% ( 170, 250 ] 13 0.098% 99.683% ( 250, 380 ] 17 0.128% 99.811% ( 380, 580 ] 13 0.098% 99.910% ( 580, 870 ] 6 0.045% 99.955% ( 870, 1300 ] 5 0.038% 99.992% ( 1900, 2900 ] 1 0.008% 100.000% ** Level 2 read latency histogram (micros): Count: 111900 Average: 2.2079 StdDev: 10.60 Min: 1 Median: 1.4179 Max: 1591 Percentiles: P50: 1.42 P75: 1.82 P99: 5.83 P99.9: 14.23 P99.99: 540.33 ------------------------------------------------------ [ 0, 1 ] 26754 23.909% 23.909% ##### ( 1, 2 ] 69865 62.435% 86.344% ############ ( 2, 3 ] 8779 7.845% 94.189% ## ( 3, 4 ] 3441 3.075% 97.265% # ( 4, 6 ] 2128 1.902% 99.166% ( 6, 10 ] 734 0.656% 99.822% ( 10, 15 ] 103 0.092% 99.914% ( 15, 22 ] 15 0.013% 99.928% ( 22, 34 ] 2 0.002% 99.929% ( 34, 51 ] 2 0.002% 99.931% ( 51, 76 ] 1 0.001% 99.932% ( 76, 110 ] 17 0.015% 99.947% ( 110, 170 ] 21 0.019% 99.966% ( 170, 250 ] 10 0.009% 99.975% ( 250, 380 ] 12 0.011% 99.986% ( 380, 580 ] 6 0.005% 99.991% ( 580, 870 ] 6 0.005% 99.996% ( 870, 1300 ] 2 0.002% 99.998% ( 1300, 1900 ] 2 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 184873 Average: 3.5680 StdDev: 40.91 Min: 1 Median: 1.6881 Max: 5205 Percentiles: P50: 1.69 P75: 2.31 P99: 9.08 P99.9: 171.98 P99.99: 524.80 ------------------------------------------------------ [ 0, 1 ] 14347 7.760% 7.760% ## ( 1, 2 ] 113481 61.383% 69.144% ############ ( 2, 3 ] 35411 19.154% 88.298% #### ( 3, 4 ] 9488 5.132% 93.430% # ( 4, 6 ] 8058 4.359% 97.789% # ( 6, 10 ] 2908 1.573% 99.362% ( 10, 15 ] 596 0.322% 99.684% ( 15, 22 ] 114 0.062% 99.746% ( 22, 34 ] 32 0.017% 99.763% ( 34, 51 ] 5 0.003% 99.766% ( 51, 76 ] 8 0.004% 99.770% ( 76, 110 ] 85 0.046% 99.816% ( 110, 170 ] 153 0.083% 99.899% ( 170, 250 ] 86 0.047% 99.945% ( 250, 380 ] 55 0.030% 99.975% ( 380, 580 ] 38 0.021% 99.996% ( 580, 870 ] 21 0.011% 100.007% ( 870, 1300 ] 18 0.010% 100.017% ( 1300, 1900 ] 10 0.005% 100.022% ( 1900, 2900 ] 10 0.005% 100.028% ( 2900, 4400 ] 7 0.004% 100.031% ( 4400, 6600 ] 4 0.002% 100.034% ** Level 4 read latency histogram (micros): Count: 305 Average: 126.8262 StdDev: 554.15 Min: 0 Median: 1.6059 Max: 5246 Percentiles: P50: 1.61 P75: 6.69 P99: 3375.00 P99.9: 5246.00 P99.99: 5246.00 ------------------------------------------------------ [ 0, 1 ] 81 26.557% 26.557% ##### ( 1, 2 ] 118 38.689% 65.246% ######## ( 2, 3 ] 16 5.246% 70.492% # ( 3, 4 ] 4 1.311% 71.803% ( 4, 6 ] 7 2.295% 74.098% ( 6, 10 ] 16 5.246% 79.344% # ( 10, 15 ] 35 11.475% 90.820% ## ( 15, 22 ] 3 0.984% 91.803% ( 76, 110 ] 1 0.328% 92.131% ( 170, 250 ] 1 0.328% 92.459% ( 250, 380 ] 3 0.984% 93.443% ( 380, 580 ] 1 0.328% 93.770% ( 580, 870 ] 1 0.328% 94.098% ( 870, 1300 ] 8 2.623% 96.721% # ( 1300, 1900 ] 5 1.639% 98.361% ( 1900, 2900 ] 1 0.328% 98.689% ( 2900, 4400 ] 3 0.984% 99.672% ( 4400, 6600 ] 1 0.328% 100.000% ** Level 5 read latency histogram (micros): Count: 40 Average: 852.0500 StdDev: 1109.87 Min: 104 Median: 354.0000 Max: 5474 Percentiles: P50: 354.00 P75: 1128.00 P99: 5474.00 P99.9: 5474.00 P99.99: 5474.00 ------------------------------------------------------ ( 76, 110 ] 3 7.500% 7.500% ## ( 110, 170 ] 10 25.000% 32.500% ##### ( 170, 250 ] 3 7.500% 40.000% ## ( 250, 380 ] 5 12.500% 52.500% ### ( 380, 580 ] 4 10.000% 62.500% ## ( 580, 870 ] 2 5.000% 67.500% # ( 870, 1300 ] 5 12.500% 80.000% ### ( 1300, 1900 ] 2 5.000% 85.000% # ( 1900, 2900 ] 4 10.000% 95.000% ## ( 2900, 4400 ] 1 2.500% 97.500% # ( 4400, 6600 ] 1 2.500% 100.000% # ** DB Stats ** Uptime(secs): 9.1 total, 2.8 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 324.27 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:1.156 H:M:S, 12.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 348.73 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.229 H:M:S, 8.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/07/26-23:39:17 ... thread 0: (1000000,4000000) ops and (333221.6,335378.8) ops/second in (3.001006,11.926811) 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/16 2.21 GB 25.2 1.8 0.0 1.8 5.5 3.7 0.0 1.5 105.0 315.0 17.99 16.71 60 0.300 1918K 1947 0.0 0.0 L1 9/9 881.84 MB 0.0 1.2 1.2 0.0 1.2 1.2 0.2 1.0 233.4 232.7 5.41 5.26 2 2.705 1282K 3605 0.0 0.0 L2 1/0 51.08 MB 0.5 0.4 0.2 0.2 0.4 0.2 0.5 2.0 248.7 248.5 1.52 1.47 2 0.760 383K 216 0.0 0.0 L3 15/0 963.59 MB 1.0 0.8 0.2 0.6 0.8 0.2 0.4 3.4 226.7 226.3 3.82 3.58 2 1.912 880K 1608 0.0 0.0 L4 169/0 9.51 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.4 1.0 146.8 146.8 1.53 1.11 1 1.527 227K 0 0.0 0.0 L5 1048/0 86.25 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 1259/25 99.82 GB 0.0 4.5 1.9 2.6 8.2 5.6 2.1 2.2 152.7 277.3 30.27 28.12 67 0.452 4693K 7376 0.0 0.0 Int 0/0 0.00 KB 0.0 4.5 1.9 2.6 8.2 5.6 2.1 2.2 152.7 277.3 30.27 28.12 67 0.452 4693K 7376 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.5 1.9 2.6 4.5 1.9 0.0 0.0 236.8 236.4 19.52 18.52 14 1.394 4693K 7376 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 351.5 10.75 9.60 53 0.203 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 12.1 total, 11.9 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: 8.20 GB write, 693.35 MB/s write, 4.51 GB read, 381.77 MB/s read, 30.3 seconds Interval compaction: 8.20 GB write, 703.71 MB/s write, 4.51 GB read, 387.47 MB/s read, 30.3 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: 18, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 18, interval: 18 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1015653 Average: 2.1979 StdDev: 12.64 Min: 0 Median: 1.4985 Max: 4506 Percentiles: P50: 1.50 P75: 1.88 P99: 5.54 P99.9: 9.79 P99.99: 14.12 ------------------------------------------------------ [ 0, 1 ] 175578 17.287% 17.287% ### ( 1, 2 ] 666563 65.629% 82.916% ############# ( 2, 3 ] 109858 10.816% 93.733% ## ( 3, 4 ] 36006 3.545% 97.278% # ( 4, 6 ] 22707 2.236% 99.514% ( 6, 10 ] 4149 0.409% 99.922% ( 10, 15 ] 841 0.083% 100.005% ( 15, 22 ] 85 0.008% 100.013% ( 22, 34 ] 13 0.001% 100.014% ( 34, 51 ] 6 0.001% 100.015% ( 51, 76 ] 8 0.001% 100.016% ( 76, 110 ] 1 0.000% 100.016% ( 110, 170 ] 35 0.003% 100.019% ( 170, 250 ] 12 0.001% 100.021% ( 250, 380 ] 14 0.001% 100.022% ( 380, 580 ] 16 0.002% 100.024% ( 580, 870 ] 15 0.001% 100.025% ( 870, 1300 ] 11 0.001% 100.026% ( 1300, 1900 ] 3 0.000% 100.026% ( 1900, 2900 ] 6 0.001% 100.027% ( 2900, 4400 ] 7 0.001% 100.028% ( 4400, 6600 ] 1 0.000% 100.028% ** Level 1 read latency histogram (micros): Count: 66369 Average: 2.7345 StdDev: 18.29 Min: 0 Median: 1.5057 Max: 1924 Percentiles: P50: 1.51 P75: 1.89 P99: 6.64 P99.9: 182.38 P99.99: 843.61 ------------------------------------------------------ [ 0, 1 ] 11098 16.722% 16.722% ### ( 1, 2 ] 43674 65.805% 82.526% ############# ( 2, 3 ] 7295 10.992% 93.518% ## ( 3, 4 ] 2210 3.330% 96.848% # ( 4, 6 ] 1340 2.019% 98.867% ( 6, 10 ] 548 0.826% 99.693% ( 10, 15 ] 59 0.089% 99.782% ( 15, 22 ] 11 0.017% 99.798% ( 34, 51 ] 1 0.002% 99.800% ( 76, 110 ] 11 0.017% 99.816% ( 110, 170 ] 53 0.080% 99.896% ( 170, 250 ] 17 0.026% 99.922% ( 250, 380 ] 23 0.035% 99.956% ( 380, 580 ] 16 0.024% 99.980% ( 580, 870 ] 7 0.011% 99.991% ( 870, 1300 ] 5 0.008% 99.998% ( 1900, 2900 ] 1 0.002% 100.000% ** Level 2 read latency histogram (micros): Count: 111900 Average: 2.2079 StdDev: 10.60 Min: 1 Median: 1.4179 Max: 1591 Percentiles: P50: 1.42 P75: 1.82 P99: 5.83 P99.9: 14.23 P99.99: 540.33 ------------------------------------------------------ [ 0, 1 ] 26754 23.909% 23.909% ##### ( 1, 2 ] 69865 62.435% 86.344% ############ ( 2, 3 ] 8779 7.845% 94.189% ## ( 3, 4 ] 3441 3.075% 97.265% # ( 4, 6 ] 2128 1.902% 99.166% ( 6, 10 ] 734 0.656% 99.822% ( 10, 15 ] 103 0.092% 99.914% ( 15, 22 ] 15 0.013% 99.928% ( 22, 34 ] 2 0.002% 99.929% ( 34, 51 ] 2 0.002% 99.931% ( 51, 76 ] 1 0.001% 99.932% ( 76, 110 ] 17 0.015% 99.947% ( 110, 170 ] 21 0.019% 99.966% ( 170, 250 ] 10 0.009% 99.975% ( 250, 380 ] 12 0.011% 99.986% ( 380, 580 ] 6 0.005% 99.991% ( 580, 870 ] 6 0.005% 99.996% ( 870, 1300 ] 2 0.002% 99.998% ( 1300, 1900 ] 2 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 184873 Average: 3.5680 StdDev: 40.91 Min: 1 Median: 1.6881 Max: 5205 Percentiles: P50: 1.69 P75: 2.31 P99: 9.08 P99.9: 171.98 P99.99: 524.80 ------------------------------------------------------ [ 0, 1 ] 14347 7.760% 7.760% ## ( 1, 2 ] 113481 61.383% 69.144% ############ ( 2, 3 ] 35411 19.154% 88.298% #### ( 3, 4 ] 9488 5.132% 93.430% # ( 4, 6 ] 8058 4.359% 97.789% # ( 6, 10 ] 2908 1.573% 99.362% ( 10, 15 ] 596 0.322% 99.684% ( 15, 22 ] 114 0.062% 99.746% ( 22, 34 ] 32 0.017% 99.763% ( 34, 51 ] 5 0.003% 99.766% ( 51, 76 ] 8 0.004% 99.770% ( 76, 110 ] 85 0.046% 99.816% ( 110, 170 ] 153 0.083% 99.899% ( 170, 250 ] 86 0.047% 99.945% ( 250, 380 ] 55 0.030% 99.975% ( 380, 580 ] 38 0.021% 99.996% ( 580, 870 ] 21 0.011% 100.007% ( 870, 1300 ] 18 0.010% 100.017% ( 1300, 1900 ] 10 0.005% 100.022% ( 1900, 2900 ] 10 0.005% 100.028% ( 2900, 4400 ] 7 0.004% 100.031% ( 4400, 6600 ] 4 0.002% 100.034% ** Level 4 read latency histogram (micros): Count: 305 Average: 126.8262 StdDev: 554.15 Min: 0 Median: 1.6059 Max: 5246 Percentiles: P50: 1.61 P75: 6.69 P99: 3375.00 P99.9: 5246.00 P99.99: 5246.00 ------------------------------------------------------ [ 0, 1 ] 81 26.557% 26.557% ##### ( 1, 2 ] 118 38.689% 65.246% ######## ( 2, 3 ] 16 5.246% 70.492% # ( 3, 4 ] 4 1.311% 71.803% ( 4, 6 ] 7 2.295% 74.098% ( 6, 10 ] 16 5.246% 79.344% # ( 10, 15 ] 35 11.475% 90.820% ## ( 15, 22 ] 3 0.984% 91.803% ( 76, 110 ] 1 0.328% 92.131% ( 170, 250 ] 1 0.328% 92.459% ( 250, 380 ] 3 0.984% 93.443% ( 380, 580 ] 1 0.328% 93.770% ( 580, 870 ] 1 0.328% 94.098% ( 870, 1300 ] 8 2.623% 96.721% # ( 1300, 1900 ] 5 1.639% 98.361% ( 1900, 2900 ] 1 0.328% 98.689% ( 2900, 4400 ] 3 0.984% 99.672% ( 4400, 6600 ] 1 0.328% 100.000% ** Level 5 read latency histogram (micros): Count: 40 Average: 852.0500 StdDev: 1109.87 Min: 104 Median: 354.0000 Max: 5474 Percentiles: P50: 354.00 P75: 1128.00 P99: 5474.00 P99.9: 5474.00 P99.99: 5474.00 ------------------------------------------------------ ( 76, 110 ] 3 7.500% 7.500% ## ( 110, 170 ] 10 25.000% 32.500% ##### ( 170, 250 ] 3 7.500% 40.000% ## ( 250, 380 ] 5 12.500% 52.500% ### ( 380, 580 ] 4 10.000% 62.500% ## ( 580, 870 ] 2 5.000% 67.500% # ( 870, 1300 ] 5 12.500% 80.000% ### ( 1300, 1900 ] 2 5.000% 85.000% # ( 1900, 2900 ] 4 10.000% 95.000% ## ( 2900, 4400 ] 1 2.500% 97.500% # ( 4400, 6600 ] 1 2.500% 100.000% # ** DB Stats ** Uptime(secs): 12.1 total, 3.0 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 325.18 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:1.591 H:M:S, 13.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 327.95 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.435 H:M:S, 14.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/07/26-23:39:21 ... thread 0: (1000000,5000000) ops and (275021.0,321276.9) ops/second in (3.636086,15.562897) 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/12 3.20 GB 151.0 3.0 0.0 3.0 7.6 4.7 0.0 1.6 120.4 311.0 25.11 23.47 77 0.326 3070K 3176 0.0 0.0 L1 9/9 881.84 MB 0.0 1.2 1.2 0.0 1.2 1.2 0.2 1.0 233.4 232.7 5.41 5.26 2 2.705 1282K 3605 0.0 0.0 L2 1/0 51.08 MB 0.5 0.4 0.2 0.2 0.4 0.2 0.5 2.0 248.7 248.5 1.52 1.47 2 0.760 383K 216 0.0 0.0 L3 15/0 963.59 MB 1.0 0.8 0.2 0.6 0.8 0.2 0.4 3.4 226.7 226.3 3.82 3.58 2 1.912 880K 1608 0.0 0.0 L4 169/0 9.51 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.4 1.0 146.8 146.8 1.53 1.11 1 1.527 227K 0 0.0 0.0 L5 1048/0 86.25 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/21 100.80 GB 0.0 5.6 1.9 3.7 10.3 6.5 2.1 2.2 153.9 281.7 37.39 34.89 84 0.445 5844K 8605 0.0 0.0 Int 0/0 0.00 KB 0.0 5.6 1.9 3.7 10.3 6.5 2.1 2.2 153.9 281.7 37.39 34.89 84 0.445 5844K 8605 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.6 1.9 3.7 5.6 1.9 0.0 0.0 241.9 241.5 23.79 22.72 18 1.322 5844K 8605 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 352.1 13.60 12.17 66 0.206 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 15.7 total, 15.6 interval Flush(GB): cumulative 4.675, interval 4.675 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: 10.29 GB write, 669.18 MB/s write, 5.62 GB read, 365.62 MB/s read, 37.4 seconds Interval compaction: 10.29 GB write, 676.84 MB/s write, 5.62 GB read, 369.81 MB/s read, 37.4 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 2, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 2, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 21, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 2, total-stops: 21, interval: 23 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1407955 Average: 2.2419 StdDev: 12.56 Min: 0 Median: 1.5039 Max: 4506 Percentiles: P50: 1.50 P75: 1.88 P99: 5.57 P99.9: 10.15 P99.99: 19.01 ------------------------------------------------------ [ 0, 1 ] 233955 16.617% 16.617% ### ( 1, 2 ] 932837 66.255% 82.871% ############# ( 2, 3 ] 154194 10.952% 93.823% ## ( 3, 4 ] 49320 3.503% 97.326% # ( 4, 6 ] 30051 2.134% 99.460% ( 6, 10 ] 6156 0.437% 99.898% ( 10, 15 ] 1236 0.088% 99.985% ( 15, 22 ] 119 0.008% 99.994% ( 22, 34 ] 18 0.001% 99.995% ( 34, 51 ] 10 0.001% 99.996% ( 51, 76 ] 10 0.001% 99.997% ( 76, 110 ] 106 0.008% 100.004% ( 110, 170 ] 121 0.009% 100.013% ( 170, 250 ] 48 0.003% 100.016% ( 250, 380 ] 58 0.004% 100.020% ( 380, 580 ] 43 0.003% 100.023% ( 580, 870 ] 33 0.002% 100.026% ( 870, 1300 ] 18 0.001% 100.027% ( 1300, 1900 ] 7 0.000% 100.027% ( 1900, 2900 ] 6 0.000% 100.028% ( 2900, 4400 ] 9 0.001% 100.028% ( 4400, 6600 ] 1 0.000% 100.028% ** Level 1 read latency histogram (micros): Count: 143953 Average: 2.6506 StdDev: 14.57 Min: 0 Median: 1.5231 Max: 1924 Percentiles: P50: 1.52 P75: 1.90 P99: 7.89 P99.9: 148.85 P99.99: 663.93 ------------------------------------------------------ [ 0, 1 ] 21755 15.113% 15.113% ### ( 1, 2 ] 96005 66.692% 81.804% ############# ( 2, 3 ] 16317 11.335% 93.139% ## ( 3, 4 ] 4662 3.239% 96.378% # ( 4, 6 ] 2908 2.020% 98.398% ( 6, 10 ] 1829 1.271% 99.669% ( 10, 15 ] 164 0.114% 99.783% ( 15, 22 ] 21 0.015% 99.797% ( 34, 51 ] 1 0.001% 99.798% ( 76, 110 ] 70 0.049% 99.846% ( 110, 170 ] 119 0.083% 99.929% ( 170, 250 ] 29 0.020% 99.949% ( 250, 380 ] 26 0.018% 99.967% ( 380, 580 ] 30 0.021% 99.988% ( 580, 870 ] 9 0.006% 99.994% ( 870, 1300 ] 7 0.005% 99.999% ( 1900, 2900 ] 1 0.001% 100.000% ** Level 2 read latency histogram (micros): Count: 111900 Average: 2.2079 StdDev: 10.60 Min: 1 Median: 1.4179 Max: 1591 Percentiles: P50: 1.42 P75: 1.82 P99: 5.83 P99.9: 14.23 P99.99: 540.33 ------------------------------------------------------ [ 0, 1 ] 26754 23.909% 23.909% ##### ( 1, 2 ] 69865 62.435% 86.344% ############ ( 2, 3 ] 8779 7.845% 94.189% ## ( 3, 4 ] 3441 3.075% 97.265% # ( 4, 6 ] 2128 1.902% 99.166% ( 6, 10 ] 734 0.656% 99.822% ( 10, 15 ] 103 0.092% 99.914% ( 15, 22 ] 15 0.013% 99.928% ( 22, 34 ] 2 0.002% 99.929% ( 34, 51 ] 2 0.002% 99.931% ( 51, 76 ] 1 0.001% 99.932% ( 76, 110 ] 17 0.015% 99.947% ( 110, 170 ] 21 0.019% 99.966% ( 170, 250 ] 10 0.009% 99.975% ( 250, 380 ] 12 0.011% 99.986% ( 380, 580 ] 6 0.005% 99.991% ( 580, 870 ] 6 0.005% 99.996% ( 870, 1300 ] 2 0.002% 99.998% ( 1300, 1900 ] 2 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 184873 Average: 3.5680 StdDev: 40.91 Min: 1 Median: 1.6881 Max: 5205 Percentiles: P50: 1.69 P75: 2.31 P99: 9.08 P99.9: 171.98 P99.99: 524.80 ------------------------------------------------------ [ 0, 1 ] 14347 7.760% 7.760% ## ( 1, 2 ] 113481 61.383% 69.144% ############ ( 2, 3 ] 35411 19.154% 88.298% #### ( 3, 4 ] 9488 5.132% 93.430% # ( 4, 6 ] 8058 4.359% 97.789% # ( 6, 10 ] 2908 1.573% 99.362% ( 10, 15 ] 596 0.322% 99.684% ( 15, 22 ] 114 0.062% 99.746% ( 22, 34 ] 32 0.017% 99.763% ( 34, 51 ] 5 0.003% 99.766% ( 51, 76 ] 8 0.004% 99.770% ( 76, 110 ] 85 0.046% 99.816% ( 110, 170 ] 153 0.083% 99.899% ( 170, 250 ] 86 0.047% 99.945% ( 250, 380 ] 55 0.030% 99.975% ( 380, 580 ] 38 0.021% 99.996% ( 580, 870 ] 21 0.011% 100.007% ( 870, 1300 ] 18 0.010% 100.017% ( 1300, 1900 ] 10 0.005% 100.022% ( 1900, 2900 ] 10 0.005% 100.028% ( 2900, 4400 ] 7 0.004% 100.031% ( 4400, 6600 ] 4 0.002% 100.034% ** Level 4 read latency histogram (micros): Count: 305 Average: 126.8262 StdDev: 554.15 Min: 0 Median: 1.6059 Max: 5246 Percentiles: P50: 1.61 P75: 6.69 P99: 3375.00 P99.9: 5246.00 P99.99: 5246.00 ------------------------------------------------------ [ 0, 1 ] 81 26.557% 26.557% ##### ( 1, 2 ] 118 38.689% 65.246% ######## ( 2, 3 ] 16 5.246% 70.492% # ( 3, 4 ] 4 1.311% 71.803% ( 4, 6 ] 7 2.295% 74.098% ( 6, 10 ] 16 5.246% 79.344% # ( 10, 15 ] 35 11.475% 90.820% ## ( 15, 22 ] 3 0.984% 91.803% ( 76, 110 ] 1 0.328% 92.131% ( 170, 250 ] 1 0.328% 92.459% ( 250, 380 ] 3 0.984% 93.443% ( 380, 580 ] 1 0.328% 93.770% ( 580, 870 ] 1 0.328% 94.098% ( 870, 1300 ] 8 2.623% 96.721% # ( 1300, 1900 ] 5 1.639% 98.361% ( 1900, 2900 ] 1 0.328% 98.689% ( 2900, 4400 ] 3 0.984% 99.672% ( 4400, 6600 ] 1 0.328% 100.000% ** Level 5 read latency histogram (micros): Count: 40 Average: 852.0500 StdDev: 1109.87 Min: 104 Median: 354.0000 Max: 5474 Percentiles: P50: 354.00 P75: 1128.00 P99: 5474.00 P99.9: 5474.00 P99.99: 5474.00 ------------------------------------------------------ ( 76, 110 ] 3 7.500% 7.500% ## ( 110, 170 ] 10 25.000% 32.500% ##### ( 170, 250 ] 3 7.500% 40.000% ## ( 250, 380 ] 5 12.500% 52.500% ### ( 380, 580 ] 4 10.000% 62.500% ## ( 580, 870 ] 2 5.000% 67.500% # ( 870, 1300 ] 5 12.500% 80.000% ### ( 1300, 1900 ] 2 5.000% 85.000% # ( 1900, 2900 ] 4 10.000% 95.000% ## ( 2900, 4400 ] 1 2.500% 97.500% # ( 4400, 6600 ] 1 2.500% 100.000% # ** DB Stats ** Uptime(secs): 15.7 total, 3.6 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 312.59 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.608 H:M:S, 16.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 270.67 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.017 H:M:S, 28.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/07/26-23:39:26 ... thread 0: (1000000,6000000) ops and (194158.7,289668.6) ops/second in (5.150426,20.713323) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 13/11 2.70 GB 12.6 4.0 0.0 4.0 9.6 5.6 0.0 1.7 129.0 309.5 31.74 29.77 96 0.331 4157K 4227 0.0 0.0 L1 19/19 2.25 GB 0.0 3.5 2.6 0.9 3.5 2.6 0.2 1.3 229.2 227.5 15.68 15.17 3 5.226 3648K 25K 0.0 0.0 L2 1/0 51.08 MB 0.5 0.4 0.2 0.2 0.4 0.2 0.5 2.0 248.7 248.5 1.52 1.47 2 0.760 383K 216 0.0 0.0 L3 15/0 963.59 MB 1.0 0.8 0.2 0.6 0.8 0.2 0.4 3.4 226.7 226.3 3.82 3.58 2 1.912 880K 1608 0.0 0.0 L4 169/0 9.51 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.4 1.0 146.8 146.8 1.53 1.11 1 1.527 227K 0 0.0 0.0 L5 1048/0 86.25 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 1265/30 101.70 GB 0.0 8.9 3.3 5.6 14.5 8.9 2.1 2.6 168.7 273.7 54.29 51.08 104 0.522 9297K 31K 0.0 0.0 Int 0/0 0.00 KB 0.0 8.9 3.3 5.6 14.5 8.9 2.1 2.6 168.7 273.7 54.29 51.08 104 0.522 9297K 31K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 8.9 3.3 5.6 8.9 3.3 0.0 0.0 240.7 239.8 38.05 36.55 23 1.654 9297K 31K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 5.6 5.6 0.0 0.0 0.0 353.0 16.24 14.54 81 0.201 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 20.9 total, 20.7 interval Flush(GB): cumulative 5.598, interval 5.598 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 14.51 GB write, 711.09 MB/s write, 8.94 GB read, 438.26 MB/s read, 54.3 seconds Interval compaction: 14.51 GB write, 717.20 MB/s write, 8.94 GB read, 442.03 MB/s read, 54.3 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: 21, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 10, total-stops: 21, interval: 31 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1797161 Average: 2.2670 StdDev: 13.17 Min: 0 Median: 1.4863 Max: 4506 Percentiles: P50: 1.49 P75: 1.86 P99: 5.61 P99.9: 12.08 P99.99: 138.00 ------------------------------------------------------ [ 0, 1 ] 320698 17.845% 17.845% #### ( 1, 2 ] 1188306 66.121% 83.966% ############# ( 2, 3 ] 183431 10.207% 94.173% ## ( 3, 4 ] 59008 3.283% 97.456% # ( 4, 6 ] 34553 1.923% 99.379% ( 6, 10 ] 8723 0.485% 99.864% ( 10, 15 ] 1549 0.086% 99.950% ( 15, 22 ] 158 0.009% 99.959% ( 22, 34 ] 20 0.001% 99.960% ( 34, 51 ] 12 0.001% 99.961% ( 51, 76 ] 14 0.001% 99.962% ( 76, 110 ] 338 0.019% 99.980% ( 110, 170 ] 367 0.020% 100.001% ( 170, 250 ] 122 0.007% 100.008% ( 250, 380 ] 99 0.006% 100.013% ( 380, 580 ] 87 0.005% 100.018% ( 580, 870 ] 60 0.003% 100.021% ( 870, 1300 ] 23 0.001% 100.023% ( 1300, 1900 ] 7 0.000% 100.023% ( 1900, 2900 ] 9 0.001% 100.024% ( 2900, 4400 ] 12 0.001% 100.024% ( 4400, 6600 ] 1 0.000% 100.024% ** Level 1 read latency histogram (micros): Count: 243604 Average: 2.6547 StdDev: 15.69 Min: 0 Median: 1.4841 Max: 1924 Percentiles: P50: 1.48 P75: 1.86 P99: 8.04 P99.9: 152.41 P99.99: 783.64 ------------------------------------------------------ [ 0, 1 ] 44210 18.148% 18.148% #### ( 1, 2 ] 160279 65.795% 83.943% ############# ( 2, 3 ] 23433 9.619% 93.563% ## ( 3, 4 ] 7336 3.011% 96.574% # ( 4, 6 ] 4262 1.750% 98.324% ( 6, 10 ] 3227 1.325% 99.648% ( 10, 15 ] 236 0.097% 99.745% ( 15, 22 ] 31 0.013% 99.758% ( 22, 34 ] 1 0.000% 99.758% ( 34, 51 ] 2 0.001% 99.759% ( 51, 76 ] 5 0.002% 99.761% ( 76, 110 ] 185 0.076% 99.837% ( 110, 170 ] 217 0.089% 99.926% ( 170, 250 ] 48 0.020% 99.946% ( 250, 380 ] 42 0.017% 99.963% ( 380, 580 ] 53 0.022% 99.985% ( 580, 870 ] 18 0.007% 99.992% ( 870, 1300 ] 16 0.007% 99.999% ( 1300, 1900 ] 2 0.001% 100.000% ( 1900, 2900 ] 1 0.000% 100.000% ** Level 2 read latency histogram (micros): Count: 111900 Average: 2.2079 StdDev: 10.60 Min: 1 Median: 1.4179 Max: 1591 Percentiles: P50: 1.42 P75: 1.82 P99: 5.83 P99.9: 14.23 P99.99: 540.33 ------------------------------------------------------ [ 0, 1 ] 26754 23.909% 23.909% ##### ( 1, 2 ] 69865 62.435% 86.344% ############ ( 2, 3 ] 8779 7.845% 94.189% ## ( 3, 4 ] 3441 3.075% 97.265% # ( 4, 6 ] 2128 1.902% 99.166% ( 6, 10 ] 734 0.656% 99.822% ( 10, 15 ] 103 0.092% 99.914% ( 15, 22 ] 15 0.013% 99.928% ( 22, 34 ] 2 0.002% 99.929% ( 34, 51 ] 2 0.002% 99.931% ( 51, 76 ] 1 0.001% 99.932% ( 76, 110 ] 17 0.015% 99.947% ( 110, 170 ] 21 0.019% 99.966% ( 170, 250 ] 10 0.009% 99.975% ( 250, 380 ] 12 0.011% 99.986% ( 380, 580 ] 6 0.005% 99.991% ( 580, 870 ] 6 0.005% 99.996% ( 870, 1300 ] 2 0.002% 99.998% ( 1300, 1900 ] 2 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 184873 Average: 3.5680 StdDev: 40.91 Min: 1 Median: 1.6881 Max: 5205 Percentiles: P50: 1.69 P75: 2.31 P99: 9.08 P99.9: 171.98 P99.99: 524.80 ------------------------------------------------------ [ 0, 1 ] 14347 7.760% 7.760% ## ( 1, 2 ] 113481 61.383% 69.144% ############ ( 2, 3 ] 35411 19.154% 88.298% #### ( 3, 4 ] 9488 5.132% 93.430% # ( 4, 6 ] 8058 4.359% 97.789% # ( 6, 10 ] 2908 1.573% 99.362% ( 10, 15 ] 596 0.322% 99.684% ( 15, 22 ] 114 0.062% 99.746% ( 22, 34 ] 32 0.017% 99.763% ( 34, 51 ] 5 0.003% 99.766% ( 51, 76 ] 8 0.004% 99.770% ( 76, 110 ] 85 0.046% 99.816% ( 110, 170 ] 153 0.083% 99.899% ( 170, 250 ] 86 0.047% 99.945% ( 250, 380 ] 55 0.030% 99.975% ( 380, 580 ] 38 0.021% 99.996% ( 580, 870 ] 21 0.011% 100.007% ( 870, 1300 ] 18 0.010% 100.017% ( 1300, 1900 ] 10 0.005% 100.022% ( 1900, 2900 ] 10 0.005% 100.028% ( 2900, 4400 ] 7 0.004% 100.031% ( 4400, 6600 ] 4 0.002% 100.034% ** Level 4 read latency histogram (micros): Count: 305 Average: 126.8262 StdDev: 554.15 Min: 0 Median: 1.6059 Max: 5246 Percentiles: P50: 1.61 P75: 6.69 P99: 3375.00 P99.9: 5246.00 P99.99: 5246.00 ------------------------------------------------------ [ 0, 1 ] 81 26.557% 26.557% ##### ( 1, 2 ] 118 38.689% 65.246% ######## ( 2, 3 ] 16 5.246% 70.492% # ( 3, 4 ] 4 1.311% 71.803% ( 4, 6 ] 7 2.295% 74.098% ( 6, 10 ] 16 5.246% 79.344% # ( 10, 15 ] 35 11.475% 90.820% ## ( 15, 22 ] 3 0.984% 91.803% ( 76, 110 ] 1 0.328% 92.131% ( 170, 250 ] 1 0.328% 92.459% ( 250, 380 ] 3 0.984% 93.443% ( 380, 580 ] 1 0.328% 93.770% ( 580, 870 ] 1 0.328% 94.098% ( 870, 1300 ] 8 2.623% 96.721% # ( 1300, 1900 ] 5 1.639% 98.361% ( 1900, 2900 ] 1 0.328% 98.689% ( 2900, 4400 ] 3 0.984% 99.672% ( 4400, 6600 ] 1 0.328% 100.000% ** Level 5 read latency histogram (micros): Count: 40 Average: 852.0500 StdDev: 1109.87 Min: 104 Median: 354.0000 Max: 5474 Percentiles: P50: 354.00 P75: 1128.00 P99: 5474.00 P99.9: 5474.00 P99.99: 5474.00 ------------------------------------------------------ ( 76, 110 ] 3 7.500% 7.500% ## ( 110, 170 ] 10 25.000% 32.500% ##### ( 170, 250 ] 3 7.500% 40.000% ## ( 250, 380 ] 5 12.500% 52.500% ### ( 380, 580 ] 4 10.000% 62.500% ## ( 580, 870 ] 2 5.000% 67.500% # ( 870, 1300 ] 5 12.500% 80.000% ### ( 1300, 1900 ] 2 5.000% 85.000% # ( 1900, 2900 ] 4 10.000% 95.000% ## ( 2900, 4400 ] 1 2.500% 97.500% # ( 4400, 6600 ] 1 2.500% 100.000% # ** DB Stats ** Uptime(secs): 20.9 total, 5.2 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 282.64 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:5.085 H:M:S, 24.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 191.09 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:2.476 H:M:S, 48.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/07/26-23:39:53 ... thread 0: (1000000,7000000) ops and (37203.1,147081.0) ops/second in (26.879490,47.592813) 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/4 1.17 GB 50.4 4.8 0.0 4.8 11.4 6.6 0.0 1.7 128.0 305.0 38.40 35.71 114 0.337 4989K 5095 0.0 0.0 L1 6/6 682.80 MB 0.0 8.3 5.2 3.1 8.2 5.1 0.2 1.6 222.3 219.1 38.44 35.86 4 9.609 8675K 120K 0.0 0.0 L2 26/24 3.27 GB 2.6 0.4 0.2 0.2 0.4 0.2 4.5 2.0 248.7 248.5 1.52 1.47 2 0.760 383K 216 0.0 0.0 L3 20/3 1.27 GB 1.0 2.4 1.1 1.3 2.4 1.1 0.4 2.1 206.6 203.5 11.90 10.58 5 2.380 2444K 4726 0.0 0.0 L4 169/1 9.63 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.9 1.0 146.8 146.8 1.53 1.11 1 1.527 227K 0 0.0 0.0 L5 1052/0 86.62 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1281/38 102.62 GB 0.0 16.1 6.7 9.4 22.6 13.2 7.1 3.4 180.0 252.3 91.78 84.73 126 0.728 16M 130K 0.0 0.0 Int 0/0 0.00 KB 0.0 16.1 6.7 9.4 22.6 13.2 7.0 3.4 180.0 252.3 91.78 84.73 126 0.728 16M 130K 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.1 6.7 9.4 16.0 6.6 0.0 0.0 229.1 226.9 72.09 67.38 30 2.403 16M 130K 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 345.4 19.70 17.35 96 0.205 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 47.8 total, 47.6 interval Flush(GB): cumulative 6.644, interval 6.644 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 22.62 GB write, 484.76 MB/s write, 16.13 GB read, 345.76 MB/s read, 91.8 seconds Interval compaction: 22.62 GB write, 486.58 MB/s write, 16.13 GB read, 347.05 MB/s read, 91.8 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: 25, pending-compaction-bytes-delays: 14, pending-compaction-bytes-stops: 0, total-delays: 24, total-stops: 25, interval: 49 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2826194 Average: 2.7799 StdDev: 17.46 Min: 0 Median: 1.4638 Max: 4506 Percentiles: P50: 1.46 P75: 1.86 P99: 7.26 P99.9: 152.35 P99.99: 379.00 ------------------------------------------------------ [ 0, 1 ] 583801 20.657% 20.657% #### ( 1, 2 ] 1788160 63.271% 83.928% ############# ( 2, 3 ] 260562 9.220% 93.147% ## ( 3, 4 ] 94146 3.331% 96.478% # ( 4, 6 ] 65141 2.305% 98.783% ( 6, 10 ] 19449 0.688% 99.472% ( 10, 15 ] 3094 0.109% 99.581% ( 15, 22 ] 488 0.017% 99.598% ( 22, 34 ] 42 0.001% 99.600% ( 34, 51 ] 22 0.001% 99.601% ( 51, 76 ] 143 0.005% 99.606% ( 76, 110 ] 5480 0.194% 99.800% ( 110, 170 ] 4023 0.142% 99.942% ( 170, 250 ] 765 0.027% 99.969% ( 250, 380 ] 600 0.021% 99.990% ( 380, 580 ] 482 0.017% 100.007% ( 580, 870 ] 239 0.008% 100.016% ( 870, 1300 ] 48 0.002% 100.017% ( 1300, 1900 ] 26 0.001% 100.018% ( 1900, 2900 ] 21 0.001% 100.019% ( 2900, 4400 ] 15 0.001% 100.020% ( 4400, 6600 ] 1 0.000% 100.020% ** Level 1 read latency histogram (micros): Count: 1565336 Average: 3.4065 StdDev: 27.78 Min: 0 Median: 1.5724 Max: 4415 Percentiles: P50: 1.57 P75: 2.06 P99: 8.94 P99.9: 154.97 P99.99: 330.42 ------------------------------------------------------ [ 0, 1 ] 275767 17.617% 17.617% #### ( 1, 2 ] 885530 56.571% 74.188% ########### ( 2, 3 ] 205743 13.144% 87.332% ### ( 3, 4 ] 90165 5.760% 93.092% # ( 4, 6 ] 73410 4.690% 97.782% # ( 6, 10 ] 25932 1.657% 99.439% ( 10, 15 ] 3349 0.214% 99.652% ( 15, 22 ] 512 0.033% 99.685% ( 22, 34 ] 39 0.002% 99.688% ( 34, 51 ] 7 0.000% 99.688% ( 51, 76 ] 101 0.006% 99.695% ( 76, 110 ] 1726 0.110% 99.805% ( 110, 170 ] 1989 0.127% 99.932% ( 170, 250 ] 569 0.036% 99.968% ( 250, 380 ] 552 0.035% 100.004% ( 380, 580 ] 552 0.035% 100.039% ( 580, 870 ] 369 0.024% 100.062% ( 870, 1300 ] 160 0.010% 100.073% ( 1300, 1900 ] 69 0.004% 100.077% ( 1900, 2900 ] 38 0.002% 100.079% ( 2900, 4400 ] 15 0.001% 100.080% ( 4400, 6600 ] 1 0.000% 100.080% ** Level 2 read latency histogram (micros): Count: 111900 Average: 2.2079 StdDev: 10.60 Min: 1 Median: 1.4179 Max: 1591 Percentiles: P50: 1.42 P75: 1.82 P99: 5.83 P99.9: 14.23 P99.99: 540.33 ------------------------------------------------------ [ 0, 1 ] 26754 23.909% 23.909% ##### ( 1, 2 ] 69865 62.435% 86.344% ############ ( 2, 3 ] 8779 7.845% 94.189% ## ( 3, 4 ] 3441 3.075% 97.265% # ( 4, 6 ] 2128 1.902% 99.166% ( 6, 10 ] 734 0.656% 99.822% ( 10, 15 ] 103 0.092% 99.914% ( 15, 22 ] 15 0.013% 99.928% ( 22, 34 ] 2 0.002% 99.929% ( 34, 51 ] 2 0.002% 99.931% ( 51, 76 ] 1 0.001% 99.932% ( 76, 110 ] 17 0.015% 99.947% ( 110, 170 ] 21 0.019% 99.966% ( 170, 250 ] 10 0.009% 99.975% ( 250, 380 ] 12 0.011% 99.986% ( 380, 580 ] 6 0.005% 99.991% ( 580, 870 ] 6 0.005% 99.996% ( 870, 1300 ] 2 0.002% 99.998% ( 1300, 1900 ] 2 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 363078 Average: 4.6309 StdDev: 46.30 Min: 1 Median: 1.7906 Max: 5205 Percentiles: P50: 1.79 P75: 2.62 P99: 9.70 P99.9: 504.47 P99.99: 1232.39 ------------------------------------------------------ [ 0, 1 ] 16595 4.571% 4.571% # ( 1, 2 ] 208643 57.465% 62.036% ########### ( 2, 3 ] 76002 20.933% 82.968% #### ( 3, 4 ] 27579 7.596% 90.564% ## ( 4, 6 ] 24334 6.702% 97.266% # ( 6, 10 ] 6801 1.873% 99.140% ( 10, 15 ] 1371 0.378% 99.517% ( 15, 22 ] 202 0.056% 99.573% ( 22, 34 ] 46 0.013% 99.585% ( 34, 51 ] 6 0.002% 99.587% ( 51, 76 ] 10 0.003% 99.590% ( 76, 110 ] 138 0.038% 99.628% ( 110, 170 ] 313 0.086% 99.714% ( 170, 250 ] 274 0.075% 99.790% ( 250, 380 ] 265 0.073% 99.863% ( 380, 580 ] 220 0.061% 99.923% ( 580, 870 ] 167 0.046% 99.969% ( 870, 1300 ] 91 0.025% 99.994% ( 1300, 1900 ] 40 0.011% 100.005% ( 1900, 2900 ] 25 0.007% 100.012% ( 2900, 4400 ] 15 0.004% 100.016% ( 4400, 6600 ] 4 0.001% 100.017% ** Level 4 read latency histogram (micros): Count: 896 Average: 63.4654 StdDev: 337.72 Min: 0 Median: 1.7926 Max: 5246 Percentiles: P50: 1.79 P75: 3.12 P99: 1424.80 P99.9: 4628.80 P99.99: 5246.00 ------------------------------------------------------ [ 0, 1 ] 104 11.607% 11.607% ## ( 1, 2 ] 434 48.438% 60.045% ########## ( 2, 3 ] 128 14.286% 74.330% ### ( 3, 4 ] 51 5.692% 80.022% # ( 4, 6 ] 25 2.790% 82.812% # ( 6, 10 ] 23 2.567% 85.379% # ( 10, 15 ] 38 4.241% 89.621% # ( 15, 22 ] 4 0.446% 90.067% ( 76, 110 ] 8 0.893% 90.960% ( 110, 170 ] 21 2.344% 93.304% ( 170, 250 ] 13 1.451% 94.754% ( 250, 380 ] 16 1.786% 96.540% ( 380, 580 ] 8 0.893% 97.433% ( 580, 870 ] 3 0.335% 97.768% ( 870, 1300 ] 10 1.116% 98.884% ( 1300, 1900 ] 5 0.558% 99.442% ( 1900, 2900 ] 1 0.112% 99.554% ( 2900, 4400 ] 3 0.335% 99.888% ( 4400, 6600 ] 1 0.112% 100.000% ** Level 5 read latency histogram (micros): Count: 60 Average: 850.7667 StdDev: 1086.01 Min: 84 Median: 324.2857 Max: 5474 Percentiles: P50: 324.29 P75: 1228.33 P99: 5280.00 P99.9: 5474.00 P99.99: 5474.00 ------------------------------------------------------ ( 76, 110 ] 8 13.333% 13.333% ### ( 110, 170 ] 12 20.000% 33.333% #### ( 170, 250 ] 6 10.000% 43.333% ## ( 250, 380 ] 7 11.667% 55.000% ## ( 380, 580 ] 4 6.667% 61.667% # ( 580, 870 ] 3 5.000% 66.667% # ( 870, 1300 ] 6 10.000% 76.667% ## ( 1300, 1900 ] 4 6.667% 83.333% # ( 1900, 2900 ] 7 11.667% 95.000% ## ( 2900, 4400 ] 2 3.333% 98.333% # ( 4400, 6600 ] 1 1.667% 100.000% ** DB Stats ** Uptime(secs): 47.8 total, 26.9 interval Cumulative writes: 0 writes, 7000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 6.73 GB, 144.21 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:29.061 H:M:S, 60.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 36.61 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:23.976 H:M:S, 89.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 4 num-running-flushes: 1 2024/07/26-23:40:01 ... thread 0: (1000000,8000000) ops and (120663.4,143163.1) ops/second in (8.287515,55.880328) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 9/7 1.41 GB 18.9 5.4 0.0 5.4 12.9 7.6 0.0 1.7 119.2 287.7 45.96 40.60 127 0.362 5564K 5694 0.0 0.0 L1 13/13 798.57 MB 0.0 9.7 5.9 3.8 9.6 5.8 0.2 1.6 218.4 215.6 45.42 42.16 5 9.085 9378K 120K 0.0 0.0 L2 1/1 128.78 MB 0.0 0.4 0.2 0.2 0.4 0.2 5.1 2.0 248.7 248.5 1.52 1.47 2 0.760 383K 216 0.0 0.0 L3 26/8 1.68 GB 1.1 7.0 4.8 2.2 6.9 4.7 0.4 1.4 193.3 191.8 36.92 31.43 12 3.077 6100K 15K 0.0 0.0 L4 206/10 12.59 GB 1.3 3.6 3.4 0.2 3.6 3.4 0.9 1.0 119.2 119.0 30.80 17.26 41 0.751 3632K 3124 0.0 0.0 L5 1056/0 86.92 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1311/39 103.51 GB 0.0 26.0 14.3 11.6 33.3 21.7 8.0 4.4 165.5 212.5 160.63 132.92 187 0.859 25M 145K 0.0 0.0 Int 0/0 0.00 KB 0.0 26.0 14.3 11.6 33.3 21.7 7.9 4.4 165.5 212.5 160.63 132.92 187 0.859 25M 145K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 26.0 14.3 11.6 25.8 14.1 0.0 0.0 195.8 194.3 135.81 112.91 80 1.698 25M 145K 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 312.2 24.82 20.01 107 0.232 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): 56.1 total, 55.9 interval Flush(GB): cumulative 7.567, interval 7.567 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 33.34 GB write, 608.99 MB/s write, 25.96 GB read, 474.28 MB/s read, 160.6 seconds Interval compaction: 33.34 GB write, 610.94 MB/s write, 25.96 GB read, 475.79 MB/s read, 160.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: 64, pending-compaction-bytes-delays: 22, pending-compaction-bytes-stops: 0, total-delays: 32, total-stops: 64, interval: 96 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3194224 Average: 3.0132 StdDev: 28.05 Min: 0 Median: 1.5005 Max: 14802 Percentiles: P50: 1.50 P75: 1.90 P99: 7.85 P99.9: 161.39 P99.99: 495.42 ------------------------------------------------------ [ 0, 1 ] 598873 18.749% 18.749% #### ( 1, 2 ] 1994588 62.444% 81.192% ############ ( 2, 3 ] 333661 10.446% 91.638% ## ( 3, 4 ] 126625 3.964% 95.602% # ( 4, 6 ] 96340 3.016% 98.618% # ( 6, 10 ] 26400 0.826% 99.445% ( 10, 15 ] 4351 0.136% 99.581% ( 15, 22 ] 608 0.019% 99.600% ( 22, 34 ] 48 0.002% 99.601% ( 34, 51 ] 24 0.001% 99.602% ( 51, 76 ] 143 0.004% 99.607% ( 76, 110 ] 5638 0.177% 99.783% ( 110, 170 ] 4357 0.136% 99.920% ( 170, 250 ] 1042 0.033% 99.952% ( 250, 380 ] 829 0.026% 99.978% ( 380, 580 ] 656 0.021% 99.999% ( 580, 870 ] 370 0.012% 100.010% ( 870, 1300 ] 119 0.004% 100.014% ( 1300, 1900 ] 55 0.002% 100.016% ( 1900, 2900 ] 50 0.002% 100.017% ( 2900, 4400 ] 46 0.001% 100.019% ( 4400, 6600 ] 9 0.000% 100.019% ( 9900, 14000 ] 3 0.000% 100.019% ( 14000, 22000 ] 1 0.000% 100.019% ** Level 1 read latency histogram (micros): Count: 2342105 Average: 3.9728 StdDev: 47.92 Min: 0 Median: 1.6641 Max: 12104 Percentiles: P50: 1.66 P75: 2.38 P99: 9.08 P99.9: 153.76 P99.99: 327.31 ------------------------------------------------------ [ 0, 1 ] 290088 12.386% 12.386% ## ( 1, 2 ] 1326631 56.643% 69.028% ########### ( 2, 3 ] 372594 15.909% 84.937% ### ( 3, 4 ] 158644 6.774% 91.711% # ( 4, 6 ] 137185 5.857% 97.568% # ( 6, 10 ] 43541 1.859% 99.427% ( 10, 15 ] 6328 0.270% 99.697% ( 15, 22 ] 787 0.034% 99.731% ( 22, 34 ] 57 0.002% 99.733% ( 34, 51 ] 12 0.001% 99.734% ( 51, 76 ] 108 0.005% 99.738% ( 76, 110 ] 1985 0.085% 99.823% ( 110, 170 ] 2472 0.106% 99.929% ( 170, 250 ] 897 0.038% 99.967% ( 250, 380 ] 911 0.039% 100.006% ( 380, 580 ] 865 0.037% 100.043% ( 580, 870 ] 635 0.027% 100.070% ( 870, 1300 ] 333 0.014% 100.084% ( 1300, 1900 ] 168 0.007% 100.091% ( 1900, 2900 ] 122 0.005% 100.096% ( 2900, 4400 ] 119 0.005% 100.101% ( 4400, 6600 ] 40 0.002% 100.103% ( 6600, 9900 ] 9 0.000% 100.104% ( 9900, 14000 ] 1 0.000% 100.104% ** Level 2 read latency histogram (micros): Count: 111900 Average: 2.2079 StdDev: 10.60 Min: 1 Median: 1.4179 Max: 1591 Percentiles: P50: 1.42 P75: 1.82 P99: 5.83 P99.9: 14.23 P99.99: 540.33 ------------------------------------------------------ [ 0, 1 ] 26754 23.909% 23.909% ##### ( 1, 2 ] 69865 62.435% 86.344% ############ ( 2, 3 ] 8779 7.845% 94.189% ## ( 3, 4 ] 3441 3.075% 97.265% # ( 4, 6 ] 2128 1.902% 99.166% ( 6, 10 ] 734 0.656% 99.822% ( 10, 15 ] 103 0.092% 99.914% ( 15, 22 ] 15 0.013% 99.928% ( 22, 34 ] 2 0.002% 99.929% ( 34, 51 ] 2 0.002% 99.931% ( 51, 76 ] 1 0.001% 99.932% ( 76, 110 ] 17 0.015% 99.947% ( 110, 170 ] 21 0.019% 99.966% ( 170, 250 ] 10 0.009% 99.975% ( 250, 380 ] 12 0.011% 99.986% ( 380, 580 ] 6 0.005% 99.991% ( 580, 870 ] 6 0.005% 99.996% ( 870, 1300 ] 2 0.002% 99.998% ( 1300, 1900 ] 2 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 1386486 Average: 8.4436 StdDev: 124.43 Min: 1 Median: 1.9553 Max: 20459 Percentiles: P50: 1.96 P75: 2.95 P99: 9.72 P99.9: 372.39 P99.99: 683.76 ------------------------------------------------------ [ 0, 1 ] 24869 1.794% 1.794% ( 1, 2 ] 699664 50.463% 52.257% ########## ( 2, 3 ] 331560 23.914% 76.170% ##### ( 3, 4 ] 145839 10.519% 86.689% ## ( 4, 6 ] 142812 10.300% 96.989% ## ( 6, 10 ] 30004 2.164% 99.153% ( 10, 15 ] 7476 0.539% 99.693% ( 15, 22 ] 916 0.066% 99.759% ( 22, 34 ] 87 0.006% 99.765% ( 34, 51 ] 19 0.001% 99.766% ( 51, 76 ] 17 0.001% 99.768% ( 76, 110 ] 191 0.014% 99.781% ( 110, 170 ] 500 0.036% 99.817% ( 170, 250 ] 513 0.037% 99.854% ( 250, 380 ] 675 0.049% 99.903% ( 380, 580 ] 852 0.061% 99.965% ( 580, 870 ] 996 0.072% 100.036% ( 870, 1300 ] 792 0.057% 100.093% ( 1300, 1900 ] 497 0.036% 100.129% ( 1900, 2900 ] 564 0.041% 100.170% ( 2900, 4400 ] 582 0.042% 100.212% ( 4400, 6600 ] 140 0.010% 100.222% ( 6600, 9900 ] 30 0.002% 100.224% ( 9900, 14000 ] 6 0.000% 100.225% ( 14000, 22000 ] 6 0.000% 100.225% ** Level 4 read latency histogram (micros): Count: 42446 Average: 101.7041 StdDev: 519.49 Min: 0 Median: 2.0608 Max: 22949 Percentiles: P50: 2.06 P75: 3.30 P99: 2694.27 P99.9: 5824.25 P99.99: 9832.73 ------------------------------------------------------ [ 0, 1 ] 964 2.271% 2.271% ( 1, 2 ] 19666 46.332% 48.603% ######### ( 2, 3 ] 9759 22.992% 71.594% ##### ( 3, 4 ] 4742 11.172% 82.766% ## ( 4, 6 ] 3022 7.120% 89.886% # ( 6, 10 ] 892 2.101% 91.987% ( 10, 15 ] 265 0.624% 92.612% ( 15, 22 ] 29 0.068% 92.680% ( 22, 34 ] 11 0.026% 92.706% ( 34, 51 ] 5 0.012% 92.718% ( 51, 76 ] 2 0.005% 92.723% ( 76, 110 ] 23 0.054% 92.777% ( 110, 170 ] 49 0.115% 92.892% ( 170, 250 ] 107 0.252% 93.144% ( 250, 380 ] 225 0.530% 93.674% ( 380, 580 ] 455 1.072% 94.746% ( 580, 870 ] 651 1.534% 96.280% ( 870, 1300 ] 579 1.364% 97.644% ( 1300, 1900 ] 373 0.879% 98.523% ( 1900, 2900 ] 255 0.601% 99.124% ( 2900, 4400 ] 281 0.662% 99.786% ( 4400, 6600 ] 75 0.177% 99.962% ( 6600, 9900 ] 12 0.028% 99.991% ( 9900, 14000 ] 10 0.024% 100.014% ( 22000, 33000 ] 1 0.002% 100.016% ** Level 5 read latency histogram (micros): Count: 85 Average: 1257.1529 StdDev: 1495.30 Min: 84 Median: 567.5000 Max: 6439 Percentiles: P50: 567.50 P75: 2045.83 P99: 6226.00 P99.9: 6439.00 P99.99: 6439.00 ------------------------------------------------------ ( 76, 110 ] 8 9.412% 9.412% ## ( 110, 170 ] 12 14.118% 23.529% ### ( 170, 250 ] 7 8.235% 31.765% ## ( 250, 380 ] 8 9.412% 41.176% ## ( 380, 580 ] 8 9.412% 50.588% ## ( 580, 870 ] 6 7.059% 57.647% # ( 870, 1300 ] 8 9.412% 67.059% ## ( 1300, 1900 ] 5 5.882% 72.941% # ( 1900, 2900 ] 12 14.118% 87.059% ### ( 2900, 4400 ] 6 7.059% 94.118% # ( 4400, 6600 ] 5 5.882% 100.000% # ** DB Stats ** Uptime(secs): 56.1 total, 8.3 interval Cumulative writes: 0 writes, 8000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 7.69 GB, 140.45 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:34.360 H:M:S, 61.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 118.76 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:5.299 H:M:S, 63.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 10 num-running-flushes: 1 2024/07/26-23:40:04 ... thread 0: (1000000,9000000) ops and (285702.0,151565.0) ops/second in (3.500150,59.380478) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 13/7 2.40 GB 132.1 6.3 0.0 6.3 14.9 8.5 0.0 1.7 120.9 283.9 53.67 47.22 143 0.375 6588K 7016 0.0 0.0 L1 13/13 798.57 MB 0.0 9.7 5.9 3.8 9.6 5.8 0.2 1.6 218.4 215.6 45.42 42.16 5 9.085 9378K 120K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 5.1 2.0 248.7 248.5 1.52 1.47 2 0.760 383K 216 0.0 0.0 L3 15/0 944.54 MB 0.9 7.2 4.9 2.3 7.2 4.9 0.4 1.5 192.6 191.2 38.36 32.51 13 2.951 6355K 16K 0.0 0.0 L4 170/0 9.53 GB 1.0 4.3 4.2 0.2 4.3 4.1 1.1 1.0 119.6 119.3 37.19 21.15 50 0.744 4397K 3983 0.0 0.0 L5 1104/0 90.86 GB 0.9 0.0 0.0 0.0 0.0 0.0 5.2 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1315/20 104.49 GB 0.0 27.9 15.2 12.8 36.3 23.5 12.1 4.2 162.5 211.0 176.16 144.50 213 0.827 27M 148K 0.0 0.0 Int 0/0 0.00 KB 0.0 27.9 15.2 12.8 36.3 23.5 12.0 4.2 162.5 211.0 176.16 144.50 213 0.827 27M 148K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 27.9 15.2 12.8 27.8 15.0 0.0 0.0 193.3 191.9 148.07 121.86 93 1.592 27M 148K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 8.6 8.6 0.0 0.0 0.0 311.7 28.09 22.64 120 0.234 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): 59.6 total, 59.4 interval Flush(GB): cumulative 8.551, interval 8.551 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 36.31 GB write, 624.18 MB/s write, 27.95 GB read, 480.53 MB/s read, 176.2 seconds Interval compaction: 36.31 GB write, 626.06 MB/s write, 27.95 GB read, 481.97 MB/s read, 176.2 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: 78, pending-compaction-bytes-delays: 22, pending-compaction-bytes-stops: 0, total-delays: 32, total-stops: 78, interval: 110 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3506807 Average: 2.9970 StdDev: 27.60 Min: 0 Median: 1.5119 Max: 14802 Percentiles: P50: 1.51 P75: 1.91 P99: 7.78 P99.9: 158.51 P99.99: 483.98 ------------------------------------------------------ [ 0, 1 ] 630104 17.968% 17.968% #### ( 1, 2 ] 2194528 62.579% 80.547% ############# ( 2, 3 ] 381629 10.883% 91.430% ## ( 3, 4 ] 142975 4.077% 95.507% # ( 4, 6 ] 109328 3.118% 98.624% # ( 6, 10 ] 29575 0.843% 99.468% ( 10, 15 ] 5085 0.145% 99.613% ( 15, 22 ] 648 0.018% 99.631% ( 22, 34 ] 52 0.001% 99.633% ( 34, 51 ] 27 0.001% 99.633% ( 51, 76 ] 145 0.004% 99.638% ( 76, 110 ] 5641 0.161% 99.798% ( 110, 170 ] 4408 0.126% 99.924% ( 170, 250 ] 1080 0.031% 99.955% ( 250, 380 ] 871 0.025% 99.980% ( 380, 580 ] 695 0.020% 100.000% ( 580, 870 ] 404 0.012% 100.011% ( 870, 1300 ] 144 0.004% 100.015% ( 1300, 1900 ] 66 0.002% 100.017% ( 1900, 2900 ] 59 0.002% 100.019% ( 2900, 4400 ] 48 0.001% 100.020% ( 4400, 6600 ] 9 0.000% 100.020% ( 9900, 14000 ] 3 0.000% 100.020% ( 14000, 22000 ] 1 0.000% 100.020% ** Level 1 read latency histogram (micros): Count: 2462028 Average: 3.9964 StdDev: 48.58 Min: 0 Median: 1.6660 Max: 12104 Percentiles: P50: 1.67 P75: 2.37 P99: 9.10 P99.9: 156.74 P99.99: 347.33 ------------------------------------------------------ [ 0, 1 ] 296888 12.059% 12.059% ## ( 1, 2 ] 1402568 56.968% 69.027% ########### ( 2, 3 ] 394849 16.038% 85.064% ### ( 3, 4 ] 164936 6.699% 91.763% # ( 4, 6 ] 142650 5.794% 97.557% # ( 6, 10 ] 45878 1.863% 99.421% ( 10, 15 ] 6760 0.275% 99.695% ( 15, 22 ] 825 0.034% 99.729% ( 22, 34 ] 58 0.002% 99.731% ( 34, 51 ] 14 0.001% 99.732% ( 51, 76 ] 108 0.004% 99.736% ( 76, 110 ] 2023 0.082% 99.818% ( 110, 170 ] 2579 0.105% 99.923% ( 170, 250 ] 942 0.038% 99.961% ( 250, 380 ] 940 0.038% 100.000% ( 380, 580 ] 906 0.037% 100.036% ( 580, 870 ] 671 0.027% 100.064% ( 870, 1300 ] 372 0.015% 100.079% ( 1300, 1900 ] 180 0.007% 100.086% ( 1900, 2900 ] 133 0.005% 100.091% ( 2900, 4400 ] 131 0.005% 100.097% ( 4400, 6600 ] 44 0.002% 100.099% ( 6600, 9900 ] 9 0.000% 100.099% ( 9900, 14000 ] 1 0.000% 100.099% ** Level 2 read latency histogram (micros): Count: 111900 Average: 2.2079 StdDev: 10.60 Min: 1 Median: 1.4179 Max: 1591 Percentiles: P50: 1.42 P75: 1.82 P99: 5.83 P99.9: 14.23 P99.99: 540.33 ------------------------------------------------------ [ 0, 1 ] 26754 23.909% 23.909% ##### ( 1, 2 ] 69865 62.435% 86.344% ############ ( 2, 3 ] 8779 7.845% 94.189% ## ( 3, 4 ] 3441 3.075% 97.265% # ( 4, 6 ] 2128 1.902% 99.166% ( 6, 10 ] 734 0.656% 99.822% ( 10, 15 ] 103 0.092% 99.914% ( 15, 22 ] 15 0.013% 99.928% ( 22, 34 ] 2 0.002% 99.929% ( 34, 51 ] 2 0.002% 99.931% ( 51, 76 ] 1 0.001% 99.932% ( 76, 110 ] 17 0.015% 99.947% ( 110, 170 ] 21 0.019% 99.966% ( 170, 250 ] 10 0.009% 99.975% ( 250, 380 ] 12 0.011% 99.986% ( 380, 580 ] 6 0.005% 99.991% ( 580, 870 ] 6 0.005% 99.996% ( 870, 1300 ] 2 0.002% 99.998% ( 1300, 1900 ] 2 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 1558541 Average: 8.2271 StdDev: 121.82 Min: 1 Median: 1.9472 Max: 20459 Percentiles: P50: 1.95 P75: 2.94 P99: 9.68 P99.9: 357.47 P99.99: 683.16 ------------------------------------------------------ [ 0, 1 ] 27763 1.781% 1.781% ( 1, 2 ] 793386 50.906% 52.687% ########## ( 2, 3 ] 371468 23.834% 76.521% ##### ( 3, 4 ] 161583 10.368% 86.889% ## ( 4, 6 ] 157634 10.114% 97.003% ## ( 6, 10 ] 33805 2.169% 99.172% ( 10, 15 ] 8347 0.536% 99.708% ( 15, 22 ] 1004 0.064% 99.772% ( 22, 34 ] 95 0.006% 99.778% ( 34, 51 ] 21 0.001% 99.780% ( 51, 76 ] 19 0.001% 99.781% ( 76, 110 ] 195 0.013% 99.793% ( 110, 170 ] 538 0.035% 99.828% ( 170, 250 ] 535 0.034% 99.862% ( 250, 380 ] 713 0.046% 99.908% ( 380, 580 ] 901 0.058% 99.966% ( 580, 870 ] 1063 0.068% 100.034% ( 870, 1300 ] 842 0.054% 100.088% ( 1300, 1900 ] 531 0.034% 100.122% ( 1900, 2900 ] 609 0.039% 100.161% ( 2900, 4400 ] 661 0.042% 100.204% ( 4400, 6600 ] 147 0.009% 100.213% ( 6600, 9900 ] 32 0.002% 100.215% ( 9900, 14000 ] 6 0.000% 100.215% ( 14000, 22000 ] 6 0.000% 100.216% ** Level 4 read latency histogram (micros): Count: 49435 Average: 89.5955 StdDev: 484.16 Min: 0 Median: 2.0072 Max: 22949 Percentiles: P50: 2.01 P75: 3.21 P99: 2431.71 P99.9: 5589.91 P99.99: 9365.54 ------------------------------------------------------ [ 0, 1 ] 1204 2.436% 2.436% ( 1, 2 ] 23432 47.400% 49.835% ######### ( 2, 3 ] 11304 22.866% 72.702% ##### ( 3, 4 ] 5382 10.887% 83.589% ## ( 4, 6 ] 3417 6.912% 90.501% # ( 6, 10 ] 1025 2.073% 92.574% ( 10, 15 ] 305 0.617% 93.191% ( 15, 22 ] 33 0.067% 93.258% ( 22, 34 ] 16 0.032% 93.290% ( 34, 51 ] 7 0.014% 93.304% ( 51, 76 ] 2 0.004% 93.308% ( 76, 110 ] 46 0.093% 93.401% ( 110, 170 ] 91 0.184% 93.586% ( 170, 250 ] 152 0.307% 93.893% ( 250, 380 ] 253 0.512% 94.405% ( 380, 580 ] 485 0.981% 95.386% ( 580, 870 ] 682 1.380% 96.765% ( 870, 1300 ] 592 1.198% 97.963% ( 1300, 1900 ] 376 0.761% 98.724% ( 1900, 2900 ] 257 0.520% 99.243% ( 2900, 4400 ] 284 0.574% 99.818% ( 4400, 6600 ] 75 0.152% 99.970% ( 6600, 9900 ] 12 0.024% 99.994% ( 9900, 14000 ] 10 0.020% 100.014% ( 22000, 33000 ] 1 0.002% 100.016% ** Level 5 read latency histogram (micros): Count: 320 Average: 1359.1969 StdDev: 1459.53 Min: 84 Median: 759.1176 Max: 7145 Percentiles: P50: 759.12 P75: 2177.78 P99: 6360.00 P99.9: 7145.00 P99.99: 7145.00 ------------------------------------------------------ ( 76, 110 ] 14 4.375% 4.375% # ( 110, 170 ] 31 9.688% 14.062% ## ( 170, 250 ] 34 10.625% 24.688% ## ( 250, 380 ] 34 10.625% 35.312% ## ( 380, 580 ] 26 8.125% 43.438% ## ( 580, 870 ] 34 10.625% 54.062% ## ( 870, 1300 ] 30 9.375% 63.438% ## ( 1300, 1900 ] 27 8.438% 71.875% ## ( 1900, 2900 ] 36 11.250% 83.125% ## ( 2900, 4400 ] 41 12.812% 95.938% ### ( 4400, 6600 ] 11 3.438% 99.375% # ( 6600, 9900 ] 2 0.625% 100.000% ** DB Stats ** Uptime(secs): 59.6 total, 3.5 interval Cumulative writes: 0 writes, 9000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 8.65 GB, 148.72 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:35.213 H:M:S, 59.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 281.19 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.854 H:M:S, 24.4 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 using bdev Nvme0n1 Initializing RocksDB Options from the specified file Initializing RocksDB Options from command-line flags Integrated BlobDB: blob cache disabled Keys: 16 bytes each (+ 0 bytes user-defined timestamp) Values: 1000 bytes each (1000 bytes after compression) Entries: 100000000 Prefix: 0 bytes Keys per prefix: 0 RawSize: 96893.3 MB (estimated) FileSize: 96893.3 MB (estimated) Write rate: 0 bytes/second Read rate: 0 ops/second Compression: NoCompression Compression sampling rate: 0 Memtablerep: SkipListFactory Perf Level: 1 ------------------------------------------------ DB path: [/mnt/rocksdb] overwrite : 6.490 micros/op 154089 ops/sec 60.004 seconds 9245999 operations; 149.3 MB/s Microseconds per write: Count: 9245999 Average: 6.4895 StdDev: 506.79 Min: 0 Median: 1.7323 Max: 763669 Percentiles: P50: 1.73 P75: 2.67 P99: 8.35 P99.9: 1268.18 P99.99: 2797.90 ------------------------------------------------------ [ 0, 1 ] 1264275 13.674% 13.674% ### ( 1, 2 ] 4586345 49.604% 63.277% ########## ( 2, 3 ] 1622804 17.551% 80.829% #### ( 3, 4 ] 1215111 13.142% 93.971% ### ( 4, 6 ] 418113 4.522% 98.493% # ( 6, 10 ] 79927 0.864% 99.357% ( 10, 15 ] 22813 0.247% 99.604% ( 15, 22 ] 6449 0.070% 99.674% ( 22, 34 ] 1333 0.014% 99.688% ( 34, 51 ] 176 0.002% 99.690% ( 51, 76 ] 32 0.000% 99.690% ( 76, 110 ] 6915 0.075% 99.765% ( 110, 170 ] 2122 0.023% 99.788% ( 170, 250 ] 216 0.002% 99.791% ( 250, 380 ] 98 0.001% 99.792% ( 380, 580 ] 31 0.000% 99.792% ( 580, 870 ] 20 0.000% 99.792% ( 870, 1300 ] 10770 0.116% 99.909% ( 1300, 1900 ] 26 0.000% 99.909% ( 1900, 2900 ] 8351 0.090% 99.999% ( 2900, 4400 ] 31 0.000% 100.000% ( 4400, 6600 ] 6 0.000% 100.000% ( 6600, 9900 ] 4 0.000% 100.000% ( 9900, 14000 ] 4 0.000% 100.000% ( 14000, 22000 ] 1 0.000% 100.000% ( 22000, 33000 ] 4 0.000% 100.000% ( 75000, 110000 ] 1 0.000% 100.000% ( 110000, 170000 ] 1 0.000% 100.000% ( 170000, 250000 ] 16 0.000% 100.000% ( 250000, 380000 ] 1 0.000% 100.000% ( 570000, 860000 ] 3 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 : 210736 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 : 9245999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 9541870968 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 : 580 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 35213444 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 : 32098879176 rocksdb.compact.write.bytes COUNT : 31887765658 rocksdb.flush.write.bytes COUNT : 9379890057 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 : 72 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 : 226 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 : 9304480768 rocksdb.memtable.garbage.bytes.at.flush COUNT : 3817472 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 : 32197678672 rocksdb.non.last.level.read.count COUNT : 7778194 rocksdb.block.checksum.compute.count COUNT : 7777106 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.372062 P95 : 3.785729 P99 : 6.583698 P100 : 763667.000000 COUNT : 9245999 SUM : 55743354 rocksdb.compaction.times.micros P50 : 885185.185185 P95 : 6830000.000000 P99 : 22660000.000000 P100 : 22758907.000000 COUNT : 94 SUM : 149015472 rocksdb.compaction.times.cpu_micros P50 : 553829.787234 P95 : 4960000.000000 P99 : 14480000.000000 P100 : 20694309.000000 COUNT : 94 SUM : 122792763 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 : 694.791667 P95 : 8951.250000 P99 : 69250.000000 P100 : 152149.000000 COUNT : 123 SUM : 407634 rocksdb.compaction.outfile.sync.micros P50 : 1111.597938 P95 : 76338.235294 P99 : 109855.882353 P100 : 136825.000000 COUNT : 407 SUM : 4572113 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 : 106.797101 P95 : 1994.444444 P99 : 4077.500000 P100 : 5089.000000 COUNT : 243 SUM : 98797 rocksdb.table.open.io.micros P50 : 1711.111111 P95 : 8630.769231 P99 : 15371.428571 P100 : 19915.000000 COUNT : 580 SUM : 1435050 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.666237 P95 : 8.147865 P99 : 12.865462 P100 : 22953.000000 COUNT : 7775572 SUM : 53904021 rocksdb.read.block.get.micros P50 : 561.355932 P95 : 3773.417722 P99 : 5874.000000 P100 : 13862.000000 COUNT : 1160 SUM : 1164272 rocksdb.write.raw.block.micros P50 : 0.513617 P95 : 0.975873 P99 : 2.825260 P100 : 21740.000000 COUNT : 10004926 SUM : 20477706 rocksdb.numfiles.in.singlecompaction P50 : 3.000000 P95 : 8.800000 P99 : 20.740000 P100 : 30.000000 COUNT : 136 SUM : 501 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.563262 P95 : 1293.826614 P99 : 2700.298633 P100 : 763491.000000 COUNT : 171111 SUM : 35224320 rocksdb.sst.read.micros P50 : 1.638457 P95 : 4.954638 P99 : 9.253844 P100 : 22949.000000 COUNT : 7778602 SUM : 38643618 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 : 9245999 SUM : 9541870968 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 : 215238.095238 P95 : 470250.000000 P99 : 918427.000000 P100 : 918427.000000 COUNT : 123 SUM : 28664675 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 : 365 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