[2024-11-19 16:17:30.469748] Starting SPDK v25.01-pre git sha1 dcc2ca8f3 / DPDK 22.11.4 initialization... [2024-11-19 16:17:30.470016] [ DPDK EAL parameters: rocksdb --no-shconf -c 0x1 --huge-unlink --no-telemetry --log-level=lib.eal:6 --log-level=lib.cryptodev:5 --log-level=lib.power:5 --log-level=user1:6 --base-virtaddr=0x200000000000 --match-allocations --file-prefix=spdk_pid179839 ] Set seed to 1732029450463043 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-11-19 16:17:30.587891] app.c: 919:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-11-19 16:17:30.611433] app.c: 612:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-11-19 16:17:30.611478] app.c: 613:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 179839' to capture a snapshot of events at runtime. [2024-11-19 16:17:30.611493] app.c: 618:app_setup_trace: *NOTICE*: 'spdk_trace' without parameters will also work if this is the only [2024-11-19 16:17:30.611520] app.c: 619:app_setup_trace: *NOTICE*: SPDK application currently running. [2024-11-19 16:17:30.611528] app.c: 620:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid179839 for offline analysis/debug. [2024-11-19 16:17:30.612083] reactor.c:1005:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Tue Nov 19 16:17:34 2024 CPU: 96 * Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz CPUCache: 36608 KB 2024/11/19-16:17:37 ... thread 0: (1000000,1000000) ops and (323771.0,323771.0) ops/second in (3.088603,3.088603) 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 6/4 440.99 MB 18.9 0.0 0.0 0.0 0.9 0.9 0.0 1.0 0.0 340.0 2.59 2.34 12 0.216 0 0 0.0 0.0 L1 3/0 249.25 MB 24.9 0.2 0.2 0.0 0.2 0.2 0.2 1.0 245.6 245.3 1.03 0.99 1 1.026 255K 253 0.0 0.0 L2 3/2 191.36 MB 0.0 0.2 0.1 0.1 0.2 0.1 0.1 1.5 242.0 241.9 0.80 0.76 2 0.400 196K 78 0.0 0.0 L3 12/0 993.56 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.60 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.57 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/6 97.00 GB 0.0 0.4 0.4 0.1 1.3 1.2 0.4 1.5 100.8 300.3 4.42 4.09 15 0.295 452K 331 0.0 0.0 Int 0/0 0.00 KB 0.0 0.4 0.4 0.1 1.3 1.2 0.4 1.5 100.8 300.3 4.42 4.09 15 0.295 452K 331 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.4 0.1 0.4 0.4 0.0 0.0 244.0 243.8 1.83 1.76 3 0.608 452K 331 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 340.0 2.59 2.34 12 0.216 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.3 total, 3.1 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.30 GB write, 401.04 MB/s write, 0.43 GB read, 134.60 MB/s read, 4.4 seconds Interval compaction: 1.30 GB write, 429.40 MB/s write, 0.43 GB read, 144.12 MB/s read, 4.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: 3, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 3, interval: 3 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 159186 Average: 1.9712 StdDev: 17.11 Min: 0 Median: 1.3090 Max: 4299 Percentiles: P50: 1.31 P75: 1.73 P99: 5.01 P99.9: 9.57 P99.99: 22.33 ------------------------------------------------------ [ 0, 1 ] 50555 31.758% 31.758% ###### ( 1, 2 ] 93990 59.044% 90.803% ############ ( 2, 3 ] 8465 5.318% 96.120% # ( 3, 4 ] 3627 2.278% 98.399% ( 4, 6 ] 1896 1.191% 99.590% ( 6, 10 ] 556 0.349% 99.939% ( 10, 15 ] 69 0.043% 99.982% ( 15, 22 ] 14 0.009% 99.991% ( 22, 34 ] 3 0.002% 99.993% ( 34, 51 ] 1 0.001% 99.994% ( 51, 76 ] 3 0.002% 99.996% ( 110, 170 ] 7 0.004% 100.000% ( 170, 250 ] 3 0.002% 100.002% ( 250, 380 ] 4 0.003% 100.004% ( 380, 580 ] 2 0.001% 100.006% ( 580, 870 ] 2 0.001% 100.007% ( 870, 1300 ] 2 0.001% 100.008% ( 1900, 2900 ] 2 0.001% 100.009% ( 2900, 4400 ] 2 0.001% 100.011% ** Level 1 read latency histogram (micros): Count: 654 Average: 15.4174 StdDev: 115.77 Min: 1 Median: 2.3602 Max: 1883 Percentiles: P50: 2.36 P75: 3.29 P99: 477.33 P99.9: 1507.60 P99.99: 1860.76 ------------------------------------------------------ [ 0, 1 ] 20 3.058% 3.058% # ( 1, 2 ] 231 35.321% 38.379% ####### ( 2, 3 ] 211 32.263% 70.642% ###### ( 3, 4 ] 98 14.985% 85.627% ### ( 4, 6 ] 63 9.633% 95.260% ## ( 6, 10 ] 14 2.141% 97.401% ( 10, 15 ] 6 0.917% 98.318% ( 110, 170 ] 1 0.153% 98.471% ( 170, 250 ] 1 0.153% 98.624% ( 250, 380 ] 1 0.153% 98.777% ( 380, 580 ] 3 0.459% 99.235% ( 580, 870 ] 1 0.153% 99.388% ( 870, 1300 ] 3 0.459% 99.847% ( 1300, 1900 ] 1 0.153% 100.000% ** Level 2 read latency histogram (micros): Count: 43944 Average: 2.3365 StdDev: 11.99 Min: 1 Median: 1.5278 Max: 1349 Percentiles: P50: 1.53 P75: 1.90 P99: 5.91 P99.9: 11.63 P99.99: 501.12 ------------------------------------------------------ [ 0, 1 ] 6201 14.111% 14.111% ### ( 1, 2 ] 29883 68.002% 82.114% ############## ( 2, 3 ] 4282 9.744% 91.858% ## ( 3, 4 ] 1988 4.524% 96.382% # ( 4, 6 ] 1202 2.735% 99.117% # ( 6, 10 ] 330 0.751% 99.868% ( 10, 15 ] 43 0.098% 99.966% ( 15, 22 ] 3 0.007% 99.973% ( 22, 34 ] 1 0.002% 99.975% ( 34, 51 ] 2 0.005% 99.980% ( 51, 76 ] 1 0.002% 99.982% ( 110, 170 ] 1 0.002% 99.984% ( 170, 250 ] 2 0.005% 99.989% ( 380, 580 ] 1 0.002% 99.991% ( 580, 870 ] 1 0.002% 99.993% ( 870, 1300 ] 3 0.007% 100.000% ( 1300, 1900 ] 1 0.002% 100.002% ** Level 3 read latency histogram (micros): Count: 50 Average: 1644.5000 StdDev: 1229.38 Min: 274 Median: 1167.6923 Max: 4306 Percentiles: P50: 1167.69 P75: 2525.00 P99: 4306.00 P99.9: 4306.00 P99.99: 4306.00 ------------------------------------------------------ ( 250, 380 ] 4 8.000% 8.000% ## ( 380, 580 ] 2 4.000% 12.000% # ( 580, 870 ] 10 20.000% 32.000% #### ( 870, 1300 ] 13 26.000% 58.000% ##### ( 1300, 1900 ] 6 12.000% 70.000% ## ( 1900, 2900 ] 4 8.000% 78.000% ## ( 2900, 4400 ] 11 22.000% 100.000% #### ** Level 4 read latency histogram (micros): Count: 20 Average: 1567.8500 StdDev: 912.14 Min: 564 Median: 1400.0000 Max: 4247 Percentiles: P50: 1400.00 P75: 1900.00 P99: 4100.00 P99.9: 4247.00 P99.99: 4247.00 ------------------------------------------------------ ( 380, 580 ] 1 5.000% 5.000% # ( 580, 870 ] 6 30.000% 35.000% ###### ( 870, 1300 ] 2 10.000% 45.000% ## ( 1300, 1900 ] 6 30.000% 75.000% ###### ( 1900, 2900 ] 4 20.000% 95.000% #### ( 2900, 4400 ] 1 5.000% 100.000% # ** DB Stats ** Uptime(secs): 3.3 total, 3.1 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 297.42 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.429 H:M:S, 13.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 318.38 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.429 H:M:S, 13.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/19-16:17:40 ... thread 0: (1000000,2000000) ops and (342554.0,332897.7) ops/second in (2.919248,6.007851) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 11/8 1.35 GB 81.8 0.8 0.0 0.8 2.6 1.8 0.0 1.4 96.6 311.9 8.48 7.85 29 0.292 831K 867 0.0 0.0 L1 0/0 0.00 KB 0.0 0.2 0.2 0.0 0.2 0.2 0.2 1.0 245.6 245.3 1.03 0.99 1 1.026 255K 253 0.0 0.0 L2 2/1 81.83 MB 0.8 0.2 0.1 0.1 0.2 0.1 0.4 1.5 242.0 241.9 0.80 0.76 2 0.400 196K 78 0.0 0.0 L3 17/8 806.18 MB 0.2 0.2 0.2 0.0 0.2 0.2 0.3 1.0 229.1 229.2 0.82 0.76 1 0.816 189K 0 0.0 0.0 L4 173/0 9.76 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.4 1.0 128.8 128.9 1.31 0.91 1 1.306 170K 0 0.0 0.0 L5 1044/0 85.94 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1247/17 97.92 GB 0.0 1.6 0.7 0.9 3.4 2.5 1.6 1.9 130.3 277.2 12.43 11.28 34 0.366 1644K 1198 0.0 0.0 Int 0/0 0.00 KB 0.0 1.6 0.7 0.9 3.4 2.5 1.5 1.9 130.3 277.2 12.43 11.28 34 0.366 1644K 1198 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.6 0.7 0.9 1.6 0.7 0.0 0.0 227.7 227.5 7.11 6.54 8 0.889 1644K 1198 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 343.7 5.32 4.74 26 0.204 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 6.2 total, 6.0 interval Flush(GB): cumulative 1.784, interval 1.784 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 3.36 GB write, 553.18 MB/s write, 1.58 GB read, 260.04 MB/s read, 12.4 seconds Interval compaction: 3.36 GB write, 573.30 MB/s write, 1.58 GB read, 269.50 MB/s read, 12.4 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 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: 385420 Average: 2.1564 StdDev: 15.97 Min: 0 Median: 1.4392 Max: 4299 Percentiles: P50: 1.44 P75: 1.83 P99: 5.63 P99.9: 11.44 P99.99: 21.35 ------------------------------------------------------ [ 0, 1 ] 85181 22.101% 22.101% #### ( 1, 2 ] 244842 63.526% 85.627% ############# ( 2, 3 ] 32261 8.370% 93.997% ## ( 3, 4 ] 13207 3.427% 97.424% # ( 4, 6 ] 7446 1.932% 99.356% ( 6, 10 ] 1980 0.514% 99.869% ( 10, 15 ] 411 0.107% 99.976% ( 15, 22 ] 60 0.016% 99.992% ( 22, 34 ] 9 0.002% 99.994% ( 34, 51 ] 2 0.001% 99.995% ( 51, 76 ] 4 0.001% 99.996% ( 76, 110 ] 1 0.000% 99.996% ( 110, 170 ] 11 0.003% 99.999% ( 170, 250 ] 11 0.003% 100.002% ( 250, 380 ] 12 0.003% 100.005% ( 380, 580 ] 3 0.001% 100.005% ( 580, 870 ] 6 0.002% 100.007% ( 870, 1300 ] 6 0.002% 100.009% ( 1300, 1900 ] 1 0.000% 100.009% ( 1900, 2900 ] 3 0.001% 100.010% ( 2900, 4400 ] 5 0.001% 100.011% ** Level 1 read latency histogram (micros): Count: 6535 Average: 4.7307 StdDev: 38.66 Min: 1 Median: 1.6724 Max: 1883 Percentiles: P50: 1.67 P75: 2.28 P99: 80.35 P99.9: 477.67 P99.99: 1507.90 ------------------------------------------------------ [ 0, 1 ] 481 7.360% 7.360% # ( 1, 2 ] 4144 63.412% 70.773% ############# ( 2, 3 ] 970 14.843% 85.616% ### ( 3, 4 ] 450 6.886% 92.502% # ( 4, 6 ] 278 4.254% 96.756% # ( 6, 10 ] 127 1.943% 98.699% ( 10, 15 ] 10 0.153% 98.852% ( 51, 76 ] 3 0.046% 98.898% ( 76, 110 ] 52 0.796% 99.694% ( 110, 170 ] 5 0.077% 99.770% ( 170, 250 ] 3 0.046% 99.816% ( 250, 380 ] 4 0.061% 99.878% ( 380, 580 ] 3 0.046% 99.923% ( 580, 870 ] 1 0.015% 99.939% ( 870, 1300 ] 3 0.046% 99.985% ( 1300, 1900 ] 1 0.015% 100.000% ** Level 2 read latency histogram (micros): Count: 65066 Average: 2.5129 StdDev: 12.58 Min: 1 Median: 1.5410 Max: 1349 Percentiles: P50: 1.54 P75: 1.91 P99: 6.74 P99.9: 97.43 P99.99: 546.52 ------------------------------------------------------ [ 0, 1 ] 8668 13.322% 13.322% ### ( 1, 2 ] 44116 67.802% 81.124% ############## ( 2, 3 ] 7054 10.841% 91.965% ## ( 3, 4 ] 2822 4.337% 96.302% # ( 4, 6 ] 1641 2.522% 98.824% # ( 6, 10 ] 619 0.951% 99.776% ( 10, 15 ] 61 0.094% 99.869% ( 15, 22 ] 7 0.011% 99.880% ( 22, 34 ] 2 0.003% 99.883% ( 34, 51 ] 3 0.005% 99.888% ( 51, 76 ] 1 0.002% 99.889% ( 76, 110 ] 11 0.017% 99.906% ( 110, 170 ] 25 0.038% 99.945% ( 170, 250 ] 18 0.028% 99.972% ( 250, 380 ] 4 0.006% 99.978% ( 380, 580 ] 9 0.014% 99.992% ( 580, 870 ] 2 0.003% 99.995% ( 870, 1300 ] 3 0.005% 100.000% ( 1300, 1900 ] 1 0.002% 100.002% ** Level 3 read latency histogram (micros): Count: 170653 Average: 3.4811 StdDev: 37.62 Min: 1 Median: 1.6836 Max: 4306 Percentiles: P50: 1.68 P75: 2.29 P99: 8.99 P99.9: 165.08 P99.99: 573.54 ------------------------------------------------------ [ 0, 1 ] 13474 7.896% 7.896% ## ( 1, 2 ] 105114 61.595% 69.491% ############ ( 2, 3 ] 32243 18.894% 88.385% #### ( 3, 4 ] 9002 5.275% 93.660% # ( 4, 6 ] 6877 4.030% 97.689% # ( 6, 10 ] 2989 1.752% 99.441% ( 10, 15 ] 389 0.228% 99.669% ( 15, 22 ] 104 0.061% 99.730% ( 22, 34 ] 35 0.021% 99.750% ( 34, 51 ] 4 0.002% 99.753% ( 51, 76 ] 5 0.003% 99.756% ( 76, 110 ] 71 0.042% 99.797% ( 110, 170 ] 191 0.112% 99.909% ( 170, 250 ] 63 0.037% 99.946% ( 250, 380 ] 43 0.025% 99.971% ( 380, 580 ] 33 0.019% 99.991% ( 580, 870 ] 25 0.015% 100.005% ( 870, 1300 ] 20 0.012% 100.017% ( 1300, 1900 ] 6 0.004% 100.021% ( 1900, 2900 ] 4 0.002% 100.023% ( 2900, 4400 ] 11 0.006% 100.029% ** Level 4 read latency histogram (micros): Count: 305 Average: 111.0164 StdDev: 454.47 Min: 0 Median: 1.9312 Max: 4247 Percentiles: P50: 1.93 P75: 5.29 P99: 2387.50 P99.9: 3942.50 P99.99: 4247.00 ------------------------------------------------------ [ 0, 1 ] 51 16.721% 16.721% ### ( 1, 2 ] 109 35.738% 52.459% ####### ( 2, 3 ] 43 14.098% 66.557% ### ( 3, 4 ] 18 5.902% 72.459% # ( 4, 6 ] 12 3.934% 76.393% # ( 6, 10 ] 33 10.820% 87.213% ## ( 10, 15 ] 15 4.918% 92.131% # ( 15, 22 ] 1 0.328% 92.459% ( 110, 170 ] 1 0.328% 92.787% ( 380, 580 ] 1 0.328% 93.115% ( 580, 870 ] 8 2.623% 95.738% # ( 870, 1300 ] 2 0.656% 96.393% ( 1300, 1900 ] 6 1.967% 98.361% ( 1900, 2900 ] 4 1.311% 99.672% ( 2900, 4400 ] 1 0.328% 100.000% ** Level 5 read latency histogram (micros): Count: 20 Average: 859.0000 StdDev: 1104.73 Min: 100 Median: 250.0000 Max: 3602 Percentiles: P50: 250.00 P75: 870.00 P99: 3602.00 P99.9: 3602.00 P99.99: 3602.00 ------------------------------------------------------ ( 76, 110 ] 2 10.000% 10.000% ## ( 110, 170 ] 6 30.000% 40.000% ###### ( 170, 250 ] 2 10.000% 50.000% ## ( 250, 380 ] 1 5.000% 55.000% # ( 380, 580 ] 3 15.000% 70.000% ### ( 580, 870 ] 1 5.000% 75.000% # ( 1300, 1900 ] 1 5.000% 80.000% # ( 1900, 2900 ] 3 15.000% 95.000% ### ( 2900, 4400 ] 1 5.000% 100.000% # ** DB Stats ** Uptime(secs): 6.2 total, 2.9 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 316.04 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:0.647 H:M:S, 10.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 337.14 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.218 H:M:S, 7.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/11/19-16:17:43 ... thread 0: (1000000,3000000) ops and (329664.0,331812.8) ops/second in (3.033392,9.041243) 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/4 2.34 GB 214.0 1.9 0.0 1.9 4.7 2.8 0.0 1.7 125.4 307.2 15.58 14.57 47 0.331 1982K 2104 0.0 0.0 L1 0/0 0.00 KB 0.0 0.2 0.2 0.0 0.2 0.2 0.2 1.0 245.6 245.3 1.03 0.99 1 1.026 255K 253 0.0 0.0 L2 1/0 77.43 MB 0.8 0.2 0.1 0.1 0.2 0.1 0.4 1.5 242.0 241.9 0.80 0.76 2 0.400 196K 78 0.0 0.0 L3 14/0 807.85 MB 0.8 0.8 0.2 0.6 0.8 0.2 0.3 4.2 225.4 224.7 3.58 3.36 2 1.790 819K 2770 0.0 0.0 L4 173/0 9.76 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.4 1.0 128.8 128.9 1.31 0.91 1 1.306 170K 0 0.0 0.0 L5 1044/0 85.94 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1245/4 98.90 GB 0.0 3.3 0.7 2.6 6.1 3.5 1.6 2.2 151.3 278.3 22.29 20.59 53 0.421 3425K 5205 0.0 0.0 Int 0/0 0.00 KB 0.0 3.3 0.7 2.6 6.1 3.5 1.5 2.2 151.3 278.3 22.29 20.59 53 0.421 3425K 5205 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 3.3 0.7 2.6 3.3 0.7 0.0 0.0 237.8 237.4 14.19 13.36 13 1.091 3425K 5205 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 2.8 2.8 0.0 0.0 0.0 349.8 8.10 7.24 40 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.3 total, 9.0 interval Flush(GB): cumulative 2.768, interval 2.768 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 6.06 GB write, 669.78 MB/s write, 3.29 GB read, 364.25 MB/s read, 22.3 seconds Interval compaction: 6.06 GB write, 685.97 MB/s write, 3.29 GB read, 373.06 MB/s read, 22.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: 7, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 7, interval: 7 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 655453 Average: 2.0812 StdDev: 16.23 Min: 0 Median: 1.3961 Max: 4365 Percentiles: P50: 1.40 P75: 1.79 P99: 5.34 P99.9: 10.82 P99.99: 20.16 ------------------------------------------------------ [ 0, 1 ] 164045 25.028% 25.028% ##### ( 1, 2 ] 413206 63.041% 88.069% ############# ( 2, 3 ] 46577 7.106% 95.175% # ( 3, 4 ] 18657 2.846% 98.022% # ( 4, 6 ] 9549 1.457% 99.478% ( 6, 10 ] 2661 0.406% 99.884% ( 10, 15 ] 633 0.097% 99.981% ( 15, 22 ] 82 0.013% 99.993% ( 22, 34 ] 12 0.002% 99.995% ( 34, 51 ] 6 0.001% 99.996% ( 51, 76 ] 4 0.001% 99.997% ( 76, 110 ] 1 0.000% 99.997% ( 110, 170 ] 16 0.002% 99.999% ( 170, 250 ] 18 0.003% 100.002% ( 250, 380 ] 17 0.003% 100.005% ( 380, 580 ] 5 0.001% 100.005% ( 580, 870 ] 11 0.002% 100.007% ( 870, 1300 ] 10 0.002% 100.009% ( 1300, 1900 ] 4 0.001% 100.009% ( 1900, 2900 ] 5 0.001% 100.010% ( 2900, 4400 ] 8 0.001% 100.011% ** Level 1 read latency histogram (micros): Count: 13008 Average: 3.6428 StdDev: 28.17 Min: 1 Median: 1.6441 Max: 1883 Percentiles: P50: 1.64 P75: 2.10 P99: 9.32 P99.9: 282.24 P99.99: 1256.89 ------------------------------------------------------ [ 0, 1 ] 958 7.365% 7.365% # ( 1, 2 ] 8611 66.198% 73.562% ############# ( 2, 3 ] 1816 13.961% 87.523% ### ( 3, 4 ] 802 6.165% 93.688% # ( 4, 6 ] 495 3.805% 97.494% # ( 6, 10 ] 236 1.814% 99.308% ( 10, 15 ] 12 0.092% 99.400% ( 51, 76 ] 3 0.023% 99.423% ( 76, 110 ] 53 0.407% 99.831% ( 110, 170 ] 5 0.038% 99.869% ( 170, 250 ] 3 0.023% 99.892% ( 250, 380 ] 4 0.031% 99.923% ( 380, 580 ] 5 0.038% 99.962% ( 580, 870 ] 1 0.008% 99.969% ( 870, 1300 ] 3 0.023% 99.992% ( 1300, 1900 ] 1 0.008% 100.000% ** Level 2 read latency histogram (micros): Count: 65091 Average: 2.5131 StdDev: 12.58 Min: 1 Median: 1.5411 Max: 1349 Percentiles: P50: 1.54 P75: 1.91 P99: 6.74 P99.9: 97.36 P99.99: 546.46 ------------------------------------------------------ [ 0, 1 ] 8668 13.317% 13.317% ### ( 1, 2 ] 44129 67.796% 81.113% ############## ( 2, 3 ] 7059 10.845% 91.957% ## ( 3, 4 ] 2828 4.345% 96.302% # ( 4, 6 ] 1642 2.523% 98.825% # ( 6, 10 ] 619 0.951% 99.776% ( 10, 15 ] 61 0.094% 99.869% ( 15, 22 ] 7 0.011% 99.880% ( 22, 34 ] 2 0.003% 99.883% ( 34, 51 ] 3 0.005% 99.888% ( 51, 76 ] 1 0.002% 99.889% ( 76, 110 ] 11 0.017% 99.906% ( 110, 170 ] 25 0.038% 99.945% ( 170, 250 ] 18 0.028% 99.972% ( 250, 380 ] 4 0.006% 99.978% ( 380, 580 ] 9 0.014% 99.992% ( 580, 870 ] 2 0.003% 99.995% ( 870, 1300 ] 3 0.005% 100.000% ( 1300, 1900 ] 1 0.002% 100.002% ** Level 3 read latency histogram (micros): Count: 170678 Average: 3.5215 StdDev: 38.13 Min: 1 Median: 1.6836 Max: 4306 Percentiles: P50: 1.68 P75: 2.29 P99: 9.01 P99.9: 168.22 P99.99: 612.71 ------------------------------------------------------ [ 0, 1 ] 13478 7.897% 7.897% ## ( 1, 2 ] 105123 61.591% 69.488% ############ ( 2, 3 ] 32244 18.892% 88.380% #### ( 3, 4 ] 9003 5.275% 93.655% # ( 4, 6 ] 6877 4.029% 97.684% # ( 6, 10 ] 2989 1.751% 99.435% ( 10, 15 ] 389 0.228% 99.663% ( 15, 22 ] 104 0.061% 99.724% ( 22, 34 ] 35 0.021% 99.745% ( 34, 51 ] 4 0.002% 99.747% ( 51, 76 ] 5 0.003% 99.750% ( 76, 110 ] 71 0.042% 99.791% ( 110, 170 ] 191 0.112% 99.903% ( 170, 250 ] 63 0.037% 99.940% ( 250, 380 ] 46 0.027% 99.967% ( 380, 580 ] 36 0.021% 99.988% ( 580, 870 ] 26 0.015% 100.004% ( 870, 1300 ] 22 0.013% 100.016% ( 1300, 1900 ] 7 0.004% 100.021% ( 1900, 2900 ] 4 0.002% 100.023% ( 2900, 4400 ] 11 0.006% 100.029% ** Level 4 read latency histogram (micros): Count: 305 Average: 111.0164 StdDev: 454.47 Min: 0 Median: 1.9312 Max: 4247 Percentiles: P50: 1.93 P75: 5.29 P99: 2387.50 P99.9: 3942.50 P99.99: 4247.00 ------------------------------------------------------ [ 0, 1 ] 51 16.721% 16.721% ### ( 1, 2 ] 109 35.738% 52.459% ####### ( 2, 3 ] 43 14.098% 66.557% ### ( 3, 4 ] 18 5.902% 72.459% # ( 4, 6 ] 12 3.934% 76.393% # ( 6, 10 ] 33 10.820% 87.213% ## ( 10, 15 ] 15 4.918% 92.131% # ( 15, 22 ] 1 0.328% 92.459% ( 110, 170 ] 1 0.328% 92.787% ( 380, 580 ] 1 0.328% 93.115% ( 580, 870 ] 8 2.623% 95.738% # ( 870, 1300 ] 2 0.656% 96.393% ( 1300, 1900 ] 6 1.967% 98.361% ( 1900, 2900 ] 4 1.311% 99.672% ( 2900, 4400 ] 1 0.328% 100.000% ** Level 5 read latency histogram (micros): Count: 20 Average: 859.0000 StdDev: 1104.73 Min: 100 Median: 250.0000 Max: 3602 Percentiles: P50: 250.00 P75: 870.00 P99: 3602.00 P99.9: 3602.00 P99.99: 3602.00 ------------------------------------------------------ ( 76, 110 ] 2 10.000% 10.000% ## ( 110, 170 ] 6 30.000% 40.000% ###### ( 170, 250 ] 2 10.000% 50.000% ## ( 250, 380 ] 1 5.000% 55.000% # ( 380, 580 ] 3 15.000% 70.000% ### ( 580, 870 ] 1 5.000% 75.000% # ( 1300, 1900 ] 1 5.000% 80.000% # ( 1900, 2900 ] 3 15.000% 95.000% ### ( 2900, 4400 ] 1 5.000% 100.000% # ** DB Stats ** Uptime(secs): 9.3 total, 3.0 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 318.79 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:1.017 H:M:S, 11.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 324.45 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.370 H:M:S, 12.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/11/19-16:17:47 ... thread 0: (1000000,4000000) ops and (302667.3,324012.5) ops/second in (3.303958,12.345201) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 19/15 3.32 GB 69.2 2.7 0.0 2.7 6.5 3.7 0.0 1.7 128.8 307.3 21.51 20.13 65 0.331 2814K 2945 0.0 0.0 L1 0/0 0.00 KB 0.0 0.2 0.2 0.0 0.2 0.2 0.2 1.0 245.6 245.3 1.03 0.99 1 1.026 255K 253 0.0 0.0 L2 1/0 77.43 MB 0.8 0.2 0.1 0.1 0.2 0.1 0.4 1.5 242.0 241.9 0.80 0.76 2 0.400 196K 78 0.0 0.0 L3 14/0 807.85 MB 0.8 0.8 0.2 0.6 0.8 0.2 0.3 4.2 225.4 224.7 3.58 3.36 2 1.790 819K 2770 0.0 0.0 L4 173/0 9.76 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.4 1.0 128.8 128.9 1.31 0.91 1 1.306 170K 0 0.0 0.0 L5 1044/0 85.94 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1251/15 99.88 GB 0.0 4.1 0.7 3.4 7.8 4.5 1.6 2.1 148.5 284.5 28.22 26.16 71 0.398 4257K 6046 0.0 0.0 Int 0/0 0.00 KB 0.0 4.1 0.7 3.4 7.8 4.5 1.5 2.1 148.5 284.5 28.22 26.16 71 0.398 4257K 6046 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 4.1 0.7 3.4 4.1 0.7 0.0 0.0 242.6 242.3 17.28 16.39 16 1.080 4257K 6046 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 3.8 3.8 0.0 0.0 0.0 351.1 10.94 9.77 55 0.199 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 12.6 total, 12.3 interval Flush(GB): cumulative 3.753, interval 3.753 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 7.84 GB write, 638.99 MB/s write, 4.09 GB read, 333.65 MB/s read, 28.2 seconds Interval compaction: 7.84 GB write, 650.30 MB/s write, 4.09 GB read, 339.56 MB/s read, 28.2 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: 9, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 2, total-stops: 9, interval: 11 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1037634 Average: 2.1230 StdDev: 13.88 Min: 0 Median: 1.4276 Max: 4365 Percentiles: P50: 1.43 P75: 1.81 P99: 5.38 P99.9: 10.61 P99.99: 21.49 ------------------------------------------------------ [ 0, 1 ] 231963 22.355% 22.355% #### ( 1, 2 ] 670810 64.648% 87.003% ############# ( 2, 3 ] 82886 7.988% 94.991% ## ( 3, 4 ] 31096 2.997% 97.988% # ( 4, 6 ] 15261 1.471% 99.459% ( 6, 10 ] 4467 0.430% 99.889% ( 10, 15 ] 951 0.092% 99.981% ( 15, 22 ] 106 0.010% 99.991% ( 22, 34 ] 13 0.001% 99.992% ( 34, 51 ] 11 0.001% 99.993% ( 51, 76 ] 8 0.001% 99.994% ( 76, 110 ] 22 0.002% 99.996% ( 110, 170 ] 116 0.011% 100.007% ( 170, 250 ] 39 0.004% 100.011% ( 250, 380 ] 35 0.003% 100.014% ( 380, 580 ] 19 0.002% 100.016% ( 580, 870 ] 21 0.002% 100.018% ( 870, 1300 ] 14 0.001% 100.020% ( 1300, 1900 ] 7 0.001% 100.020% ( 1900, 2900 ] 6 0.001% 100.021% ( 2900, 4400 ] 8 0.001% 100.022% ** Level 1 read latency histogram (micros): Count: 13008 Average: 3.6428 StdDev: 28.17 Min: 1 Median: 1.6441 Max: 1883 Percentiles: P50: 1.64 P75: 2.10 P99: 9.32 P99.9: 282.24 P99.99: 1256.89 ------------------------------------------------------ [ 0, 1 ] 958 7.365% 7.365% # ( 1, 2 ] 8611 66.198% 73.562% ############# ( 2, 3 ] 1816 13.961% 87.523% ### ( 3, 4 ] 802 6.165% 93.688% # ( 4, 6 ] 495 3.805% 97.494% # ( 6, 10 ] 236 1.814% 99.308% ( 10, 15 ] 12 0.092% 99.400% ( 51, 76 ] 3 0.023% 99.423% ( 76, 110 ] 53 0.407% 99.831% ( 110, 170 ] 5 0.038% 99.869% ( 170, 250 ] 3 0.023% 99.892% ( 250, 380 ] 4 0.031% 99.923% ( 380, 580 ] 5 0.038% 99.962% ( 580, 870 ] 1 0.008% 99.969% ( 870, 1300 ] 3 0.023% 99.992% ( 1300, 1900 ] 1 0.008% 100.000% ** Level 2 read latency histogram (micros): Count: 65091 Average: 2.5131 StdDev: 12.58 Min: 1 Median: 1.5411 Max: 1349 Percentiles: P50: 1.54 P75: 1.91 P99: 6.74 P99.9: 97.36 P99.99: 546.46 ------------------------------------------------------ [ 0, 1 ] 8668 13.317% 13.317% ### ( 1, 2 ] 44129 67.796% 81.113% ############## ( 2, 3 ] 7059 10.845% 91.957% ## ( 3, 4 ] 2828 4.345% 96.302% # ( 4, 6 ] 1642 2.523% 98.825% # ( 6, 10 ] 619 0.951% 99.776% ( 10, 15 ] 61 0.094% 99.869% ( 15, 22 ] 7 0.011% 99.880% ( 22, 34 ] 2 0.003% 99.883% ( 34, 51 ] 3 0.005% 99.888% ( 51, 76 ] 1 0.002% 99.889% ( 76, 110 ] 11 0.017% 99.906% ( 110, 170 ] 25 0.038% 99.945% ( 170, 250 ] 18 0.028% 99.972% ( 250, 380 ] 4 0.006% 99.978% ( 380, 580 ] 9 0.014% 99.992% ( 580, 870 ] 2 0.003% 99.995% ( 870, 1300 ] 3 0.005% 100.000% ( 1300, 1900 ] 1 0.002% 100.002% ** Level 3 read latency histogram (micros): Count: 170678 Average: 3.5215 StdDev: 38.13 Min: 1 Median: 1.6836 Max: 4306 Percentiles: P50: 1.68 P75: 2.29 P99: 9.01 P99.9: 168.22 P99.99: 612.71 ------------------------------------------------------ [ 0, 1 ] 13478 7.897% 7.897% ## ( 1, 2 ] 105123 61.591% 69.488% ############ ( 2, 3 ] 32244 18.892% 88.380% #### ( 3, 4 ] 9003 5.275% 93.655% # ( 4, 6 ] 6877 4.029% 97.684% # ( 6, 10 ] 2989 1.751% 99.435% ( 10, 15 ] 389 0.228% 99.663% ( 15, 22 ] 104 0.061% 99.724% ( 22, 34 ] 35 0.021% 99.745% ( 34, 51 ] 4 0.002% 99.747% ( 51, 76 ] 5 0.003% 99.750% ( 76, 110 ] 71 0.042% 99.791% ( 110, 170 ] 191 0.112% 99.903% ( 170, 250 ] 63 0.037% 99.940% ( 250, 380 ] 46 0.027% 99.967% ( 380, 580 ] 36 0.021% 99.988% ( 580, 870 ] 26 0.015% 100.004% ( 870, 1300 ] 22 0.013% 100.016% ( 1300, 1900 ] 7 0.004% 100.021% ( 1900, 2900 ] 4 0.002% 100.023% ( 2900, 4400 ] 11 0.006% 100.029% ** Level 4 read latency histogram (micros): Count: 305 Average: 111.0164 StdDev: 454.47 Min: 0 Median: 1.9312 Max: 4247 Percentiles: P50: 1.93 P75: 5.29 P99: 2387.50 P99.9: 3942.50 P99.99: 4247.00 ------------------------------------------------------ [ 0, 1 ] 51 16.721% 16.721% ### ( 1, 2 ] 109 35.738% 52.459% ####### ( 2, 3 ] 43 14.098% 66.557% ### ( 3, 4 ] 18 5.902% 72.459% # ( 4, 6 ] 12 3.934% 76.393% # ( 6, 10 ] 33 10.820% 87.213% ## ( 10, 15 ] 15 4.918% 92.131% # ( 15, 22 ] 1 0.328% 92.459% ( 110, 170 ] 1 0.328% 92.787% ( 380, 580 ] 1 0.328% 93.115% ( 580, 870 ] 8 2.623% 95.738% # ( 870, 1300 ] 2 0.656% 96.393% ( 1300, 1900 ] 6 1.967% 98.361% ( 1900, 2900 ] 4 1.311% 99.672% ( 2900, 4400 ] 1 0.328% 100.000% ** Level 5 read latency histogram (micros): Count: 20 Average: 859.0000 StdDev: 1104.73 Min: 100 Median: 250.0000 Max: 3602 Percentiles: P50: 250.00 P75: 870.00 P99: 3602.00 P99.9: 3602.00 P99.99: 3602.00 ------------------------------------------------------ ( 76, 110 ] 2 10.000% 10.000% ## ( 110, 170 ] 6 30.000% 40.000% ###### ( 170, 250 ] 2 10.000% 50.000% ## ( 250, 380 ] 1 5.000% 55.000% # ( 380, 580 ] 3 15.000% 70.000% ### ( 580, 870 ] 1 5.000% 75.000% # ( 1300, 1900 ] 1 5.000% 80.000% # ( 1900, 2900 ] 3 15.000% 95.000% ### ( 2900, 4400 ] 1 5.000% 100.000% # ** DB Stats ** Uptime(secs): 12.6 total, 3.3 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 313.29 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.606 H:M:S, 12.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 297.88 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.590 H:M:S, 17.8 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/19-16:17:55 ... thread 0: (1000000,5000000) ops and (119791.3,241626.9) ops/second in (8.347855,20.693056) 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 7/4 1.84 GB 163.2 4.7 0.0 4.7 9.4 4.7 0.0 2.0 150.3 298.4 32.27 30.33 85 0.380 4924K 8496 0.0 0.0 L1 6/0 744.64 MB 74.5 2.6 2.6 0.0 2.6 2.6 0.2 1.0 227.5 225.1 11.90 11.43 2 5.949 2748K 27K 0.0 0.0 L2 15/9 1.72 GB 7.7 0.2 0.1 0.1 0.2 0.1 2.0 1.5 242.0 241.9 0.80 0.76 2 0.400 196K 78 0.0 0.0 L3 14/14 807.85 MB 0.0 0.8 0.2 0.6 0.8 0.2 0.3 4.2 225.4 224.7 3.58 3.36 2 1.790 819K 2770 0.0 0.0 L4 173/0 9.76 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.4 1.0 128.8 128.9 1.31 0.91 1 1.306 170K 0 0.0 0.0 L5 1044/0 85.94 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1259/27 100.77 GB 0.0 8.5 3.1 5.4 13.2 7.8 3.2 2.8 175.0 270.2 49.86 46.79 92 0.542 8859K 38K 0.0 0.0 Int 0/0 0.00 KB 0.0 8.5 3.1 5.4 13.2 7.8 3.1 2.8 175.0 270.2 49.86 46.79 92 0.542 8859K 38K 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.5 3.1 5.4 8.5 3.1 0.0 0.0 240.8 239.7 36.24 34.69 22 1.647 8859K 38K 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 351.6 13.62 12.10 70 0.195 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 20.9 total, 20.7 interval Flush(GB): cumulative 4.676, interval 4.676 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 13.16 GB write, 644.25 MB/s write, 8.52 GB read, 417.19 MB/s read, 49.9 seconds Interval compaction: 13.16 GB write, 651.05 MB/s write, 8.52 GB read, 421.60 MB/s read, 49.9 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 11, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 11, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 9, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 11, total-stops: 9, interval: 20 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1965795 Average: 2.3039 StdDev: 15.53 Min: 0 Median: 1.4433 Max: 6864 Percentiles: P50: 1.44 P75: 1.82 P99: 5.63 P99.9: 57.74 P99.99: 218.07 ------------------------------------------------------ [ 0, 1 ] 404532 20.579% 20.579% #### ( 1, 2 ] 1304829 66.377% 86.955% ############# ( 2, 3 ] 156462 7.959% 94.914% ## ( 3, 4 ] 57759 2.938% 97.853% # ( 4, 6 ] 27712 1.410% 99.262% ( 6, 10 ] 10774 0.548% 99.810% ( 10, 15 ] 1506 0.077% 99.887% ( 15, 22 ] 210 0.011% 99.898% ( 22, 34 ] 21 0.001% 99.899% ( 34, 51 ] 18 0.001% 99.900% ( 51, 76 ] 23 0.001% 99.901% ( 76, 110 ] 768 0.039% 99.940% ( 110, 170 ] 837 0.043% 99.983% ( 170, 250 ] 247 0.013% 99.995% ( 250, 380 ] 205 0.010% 100.005% ( 380, 580 ] 142 0.007% 100.013% ( 580, 870 ] 80 0.004% 100.017% ( 870, 1300 ] 40 0.002% 100.019% ( 1300, 1900 ] 16 0.001% 100.020% ( 1900, 2900 ] 10 0.001% 100.020% ( 2900, 4400 ] 12 0.001% 100.021% ( 6600, 9900 ] 1 0.000% 100.021% ** Level 1 read latency histogram (micros): Count: 70586 Average: 4.6162 StdDev: 33.34 Min: 0 Median: 1.9076 Max: 1953 Percentiles: P50: 1.91 P75: 2.88 P99: 9.93 P99.9: 237.09 P99.99: 394.01 ------------------------------------------------------ [ 0, 1 ] 1667 2.362% 2.362% ( 1, 2 ] 37048 52.486% 54.848% ########## ( 2, 3 ] 16161 22.895% 77.743% ##### ( 3, 4 ] 7171 10.159% 87.903% ## ( 4, 6 ] 6098 8.639% 96.542% ## ( 6, 10 ] 1766 2.502% 99.044% # ( 10, 15 ] 321 0.455% 99.498% ( 15, 22 ] 45 0.064% 99.562% ( 22, 34 ] 2 0.003% 99.565% ( 34, 51 ] 1 0.001% 99.566% ( 51, 76 ] 3 0.004% 99.571% ( 76, 110 ] 85 0.120% 99.691% ( 110, 170 ] 109 0.154% 99.846% ( 170, 250 ] 47 0.067% 99.912% ( 250, 380 ] 53 0.075% 99.987% ( 380, 580 ] 42 0.060% 100.047% ( 580, 870 ] 30 0.043% 100.089% ( 870, 1300 ] 15 0.021% 100.111% ( 1300, 1900 ] 9 0.013% 100.123% ( 1900, 2900 ] 1 0.001% 100.125% ** Level 2 read latency histogram (micros): Count: 65091 Average: 2.5131 StdDev: 12.58 Min: 1 Median: 1.5411 Max: 1349 Percentiles: P50: 1.54 P75: 1.91 P99: 6.74 P99.9: 97.36 P99.99: 546.46 ------------------------------------------------------ [ 0, 1 ] 8668 13.317% 13.317% ### ( 1, 2 ] 44129 67.796% 81.113% ############## ( 2, 3 ] 7059 10.845% 91.957% ## ( 3, 4 ] 2828 4.345% 96.302% # ( 4, 6 ] 1642 2.523% 98.825% # ( 6, 10 ] 619 0.951% 99.776% ( 10, 15 ] 61 0.094% 99.869% ( 15, 22 ] 7 0.011% 99.880% ( 22, 34 ] 2 0.003% 99.883% ( 34, 51 ] 3 0.005% 99.888% ( 51, 76 ] 1 0.002% 99.889% ( 76, 110 ] 11 0.017% 99.906% ( 110, 170 ] 25 0.038% 99.945% ( 170, 250 ] 18 0.028% 99.972% ( 250, 380 ] 4 0.006% 99.978% ( 380, 580 ] 9 0.014% 99.992% ( 580, 870 ] 2 0.003% 99.995% ( 870, 1300 ] 3 0.005% 100.000% ( 1300, 1900 ] 1 0.002% 100.002% ** Level 3 read latency histogram (micros): Count: 190576 Average: 3.9134 StdDev: 40.61 Min: 1 Median: 1.7017 Max: 4306 Percentiles: P50: 1.70 P75: 2.36 P99: 9.24 P99.9: 290.19 P99.99: 879.88 ------------------------------------------------------ [ 0, 1 ] 13834 7.259% 7.259% # ( 1, 2 ] 116074 60.907% 68.166% ############ ( 2, 3 ] 36634 19.223% 87.389% #### ( 3, 4 ] 10937 5.739% 93.128% # ( 4, 6 ] 8368 4.391% 97.519% # ( 6, 10 ] 3484 1.828% 99.347% ( 10, 15 ] 462 0.242% 99.589% ( 15, 22 ] 112 0.059% 99.648% ( 22, 34 ] 38 0.020% 99.668% ( 34, 51 ] 4 0.002% 99.670% ( 51, 76 ] 5 0.003% 99.673% ( 76, 110 ] 81 0.043% 99.715% ( 110, 170 ] 231 0.121% 99.836% ( 170, 250 ] 99 0.052% 99.888% ( 250, 380 ] 79 0.041% 99.930% ( 380, 580 ] 66 0.035% 99.964% ( 580, 870 ] 50 0.026% 99.991% ( 870, 1300 ] 41 0.022% 100.012% ( 1300, 1900 ] 15 0.008% 100.020% ( 1900, 2900 ] 5 0.003% 100.023% ( 2900, 4400 ] 11 0.006% 100.028% ** Level 4 read latency histogram (micros): Count: 305 Average: 111.0164 StdDev: 454.47 Min: 0 Median: 1.9312 Max: 4247 Percentiles: P50: 1.93 P75: 5.29 P99: 2387.50 P99.9: 3942.50 P99.99: 4247.00 ------------------------------------------------------ [ 0, 1 ] 51 16.721% 16.721% ### ( 1, 2 ] 109 35.738% 52.459% ####### ( 2, 3 ] 43 14.098% 66.557% ### ( 3, 4 ] 18 5.902% 72.459% # ( 4, 6 ] 12 3.934% 76.393% # ( 6, 10 ] 33 10.820% 87.213% ## ( 10, 15 ] 15 4.918% 92.131% # ( 15, 22 ] 1 0.328% 92.459% ( 110, 170 ] 1 0.328% 92.787% ( 380, 580 ] 1 0.328% 93.115% ( 580, 870 ] 8 2.623% 95.738% # ( 870, 1300 ] 2 0.656% 96.393% ( 1300, 1900 ] 6 1.967% 98.361% ( 1900, 2900 ] 4 1.311% 99.672% ( 2900, 4400 ] 1 0.328% 100.000% ** Level 5 read latency histogram (micros): Count: 20 Average: 859.0000 StdDev: 1104.73 Min: 100 Median: 250.0000 Max: 3602 Percentiles: P50: 250.00 P75: 870.00 P99: 3602.00 P99.9: 3602.00 P99.99: 3602.00 ------------------------------------------------------ ( 76, 110 ] 2 10.000% 10.000% ## ( 110, 170 ] 6 30.000% 40.000% ###### ( 170, 250 ] 2 10.000% 50.000% ## ( 250, 380 ] 1 5.000% 55.000% # ( 380, 580 ] 3 15.000% 70.000% ### ( 580, 870 ] 1 5.000% 75.000% # ( 1300, 1900 ] 1 5.000% 80.000% # ( 1900, 2900 ] 3 15.000% 95.000% ### ( 2900, 4400 ] 1 5.000% 100.000% # ** DB Stats ** Uptime(secs): 20.9 total, 8.3 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 235.30 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:6.955 H:M:S, 33.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 117.90 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.349 H:M:S, 64.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 5 num-running-flushes: 1 2024/11/19-16:17:59 ... thread 0: (1000000,6000000) ops and (265881.6,245357.3) ops/second in (3.761072,24.454128) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 14/11 2.82 GB 44.1 5.2 0.0 5.2 10.9 5.7 0.0 1.9 141.6 294.7 37.81 35.01 100 0.378 5436K 8963 0.0 0.0 L1 6/6 744.64 MB 0.0 2.6 2.6 0.0 2.6 2.6 0.2 1.0 227.5 225.1 11.90 11.43 2 5.949 2748K 27K 0.0 0.0 L2 6/4 772.67 MB 2.6 0.2 0.1 0.1 0.2 0.1 2.0 1.5 242.0 241.9 0.80 0.76 2 0.400 196K 78 0.0 0.0 L3 27/2 1.04 GB 1.0 2.5 1.2 1.4 2.5 1.1 0.3 2.2 204.4 202.8 12.73 11.52 6 2.121 2642K 20K 0.0 0.0 L4 170/0 9.47 GB 1.0 0.4 0.4 0.0 0.4 0.4 0.9 1.0 123.1 123.0 3.20 2.04 6 0.534 400K 409 0.0 0.0 L5 1056/0 86.92 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1279/23 101.74 GB 0.0 11.0 4.3 6.7 16.6 9.9 4.7 2.9 169.3 255.7 66.43 60.76 116 0.573 11M 57K 0.0 0.0 Int 0/0 0.00 KB 0.0 11.0 4.3 6.7 16.6 9.9 4.6 2.9 169.3 255.7 66.43 60.76 116 0.573 11M 57K 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 11.0 4.3 6.7 10.9 4.2 0.0 0.0 227.5 226.4 49.44 45.98 33 1.498 11M 57K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 5.7 5.7 0.0 0.0 0.0 341.1 16.99 14.78 83 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): 24.7 total, 24.5 interval Flush(GB): cumulative 5.660, interval 5.660 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 16.59 GB write, 688.47 MB/s write, 10.99 GB read, 455.92 MB/s read, 66.4 seconds Interval compaction: 16.59 GB write, 694.63 MB/s write, 10.99 GB read, 460.00 MB/s read, 66.4 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 11, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 11, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 20, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 11, total-stops: 20, interval: 31 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2289549 Average: 2.4217 StdDev: 18.79 Min: 0 Median: 1.4829 Max: 7010 Percentiles: P50: 1.48 P75: 1.86 P99: 5.90 P99.9: 21.50 P99.99: 241.94 ------------------------------------------------------ [ 0, 1 ] 419888 18.339% 18.339% #### ( 1, 2 ] 1501199 65.567% 83.907% ############# ( 2, 3 ] 218368 9.538% 93.444% ## ( 3, 4 ] 82365 3.597% 97.042% # ( 4, 6 ] 47168 2.060% 99.102% ( 6, 10 ] 15689 0.685% 99.787% ( 10, 15 ] 2302 0.101% 99.888% ( 15, 22 ] 304 0.013% 99.901% ( 22, 34 ] 30 0.001% 99.902% ( 34, 51 ] 21 0.001% 99.903% ( 51, 76 ] 23 0.001% 99.904% ( 76, 110 ] 774 0.034% 99.938% ( 110, 170 ] 906 0.040% 99.978% ( 170, 250 ] 317 0.014% 99.991% ( 250, 380 ] 270 0.012% 100.003% ( 380, 580 ] 194 0.008% 100.012% ( 580, 870 ] 109 0.005% 100.017% ( 870, 1300 ] 54 0.002% 100.019% ( 1300, 1900 ] 19 0.001% 100.020% ( 1900, 2900 ] 14 0.001% 100.020% ( 2900, 4400 ] 21 0.001% 100.021% ( 4400, 6600 ] 2 0.000% 100.021% ( 6600, 9900 ] 2 0.000% 100.021% ** Level 1 read latency histogram (micros): Count: 379165 Average: 3.8872 StdDev: 48.99 Min: 0 Median: 1.8279 Max: 7718 Percentiles: P50: 1.83 P75: 2.68 P99: 9.19 P99.9: 154.64 P99.99: 370.08 ------------------------------------------------------ [ 0, 1 ] 8585 2.264% 2.264% ( 1, 2 ] 218610 57.656% 59.920% ############ ( 2, 3 ] 84657 22.327% 82.247% #### ( 3, 4 ] 32243 8.504% 90.751% ## ( 4, 6 ] 24736 6.524% 97.275% # ( 6, 10 ] 8193 2.161% 99.435% ( 10, 15 ] 1209 0.319% 99.754% ( 15, 22 ] 177 0.047% 99.801% ( 22, 34 ] 10 0.003% 99.804% ( 34, 51 ] 1 0.000% 99.804% ( 51, 76 ] 5 0.001% 99.805% ( 76, 110 ] 186 0.049% 99.854% ( 110, 170 ] 235 0.062% 99.916% ( 170, 250 ] 149 0.039% 99.955% ( 250, 380 ] 143 0.038% 99.993% ( 380, 580 ] 127 0.033% 100.027% ( 580, 870 ] 75 0.020% 100.046% ( 870, 1300 ] 35 0.009% 100.056% ( 1300, 1900 ] 12 0.003% 100.059% ( 1900, 2900 ] 12 0.003% 100.062% ( 2900, 4400 ] 6 0.002% 100.064% ( 4400, 6600 ] 6 0.002% 100.065% ( 6600, 9900 ] 8 0.002% 100.067% ** Level 2 read latency histogram (micros): Count: 65091 Average: 2.5131 StdDev: 12.58 Min: 1 Median: 1.5411 Max: 1349 Percentiles: P50: 1.54 P75: 1.91 P99: 6.74 P99.9: 97.36 P99.99: 546.46 ------------------------------------------------------ [ 0, 1 ] 8668 13.317% 13.317% ### ( 1, 2 ] 44129 67.796% 81.113% ############## ( 2, 3 ] 7059 10.845% 91.957% ## ( 3, 4 ] 2828 4.345% 96.302% # ( 4, 6 ] 1642 2.523% 98.825% # ( 6, 10 ] 619 0.951% 99.776% ( 10, 15 ] 61 0.094% 99.869% ( 15, 22 ] 7 0.011% 99.880% ( 22, 34 ] 2 0.003% 99.883% ( 34, 51 ] 3 0.005% 99.888% ( 51, 76 ] 1 0.002% 99.889% ( 76, 110 ] 11 0.017% 99.906% ( 110, 170 ] 25 0.038% 99.945% ( 170, 250 ] 18 0.028% 99.972% ( 250, 380 ] 4 0.006% 99.978% ( 380, 580 ] 9 0.014% 99.992% ( 580, 870 ] 2 0.003% 99.995% ( 870, 1300 ] 3 0.005% 100.000% ( 1300, 1900 ] 1 0.002% 100.002% ** Level 3 read latency histogram (micros): Count: 399954 Average: 4.1142 StdDev: 43.70 Min: 1 Median: 1.7730 Max: 7014 Percentiles: P50: 1.77 P75: 2.56 P99: 9.26 P99.9: 263.46 P99.99: 667.74 ------------------------------------------------------ [ 0, 1 ] 18317 4.580% 4.580% # ( 1, 2 ] 235000 58.757% 63.337% ############ ( 2, 3 ] 82589 20.650% 83.986% #### ( 3, 4 ] 30029 7.508% 91.494% ## ( 4, 6 ] 23758 5.940% 97.434% # ( 6, 10 ] 7683 1.921% 99.355% ( 10, 15 ] 1093 0.273% 99.629% ( 15, 22 ] 191 0.048% 99.676% ( 22, 34 ] 61 0.015% 99.692% ( 34, 51 ] 15 0.004% 99.695% ( 51, 76 ] 9 0.002% 99.698% ( 76, 110 ] 158 0.040% 99.737% ( 110, 170 ] 385 0.096% 99.833% ( 170, 250 ] 247 0.062% 99.895% ( 250, 380 ] 184 0.046% 99.941% ( 380, 580 ] 159 0.040% 99.981% ( 580, 870 ] 119 0.030% 100.011% ( 870, 1300 ] 78 0.020% 100.030% ( 1300, 1900 ] 28 0.007% 100.037% ( 1900, 2900 ] 9 0.002% 100.040% ( 2900, 4400 ] 27 0.007% 100.046% ( 6600, 9900 ] 1 0.000% 100.047% ** Level 4 read latency histogram (micros): Count: 4049 Average: 77.9187 StdDev: 334.50 Min: 0 Median: 1.9315 Max: 5584 Percentiles: P50: 1.93 P75: 3.19 P99: 1662.28 P99.9: 3828.31 P99.99: 5054.61 ------------------------------------------------------ [ 0, 1 ] 156 3.853% 3.853% # ( 1, 2 ] 2006 49.543% 53.396% ########## ( 2, 3 ] 800 19.758% 73.154% #### ( 3, 4 ] 389 9.607% 82.761% ## ( 4, 6 ] 201 4.964% 87.725% # ( 6, 10 ] 112 2.766% 90.491% # ( 10, 15 ] 27 0.667% 91.158% ( 15, 22 ] 3 0.074% 91.232% ( 76, 110 ] 9 0.222% 91.455% ( 110, 170 ] 14 0.346% 91.800% ( 170, 250 ] 27 0.667% 92.467% ( 250, 380 ] 38 0.939% 93.406% ( 380, 580 ] 65 1.605% 95.011% ( 580, 870 ] 84 2.075% 97.086% ( 870, 1300 ] 60 1.482% 98.568% ( 1300, 1900 ] 29 0.716% 99.284% ( 1900, 2900 ] 20 0.494% 99.778% ( 2900, 4400 ] 8 0.198% 99.975% ( 4400, 6600 ] 2 0.049% 100.025% ** Level 5 read latency histogram (micros): Count: 80 Average: 895.3000 StdDev: 1060.76 Min: 93 Median: 368.1818 Max: 4176 Percentiles: P50: 368.18 P75: 1214.00 P99: 4176.00 P99.9: 4176.00 P99.99: 4176.00 ------------------------------------------------------ ( 76, 110 ] 6 7.500% 7.500% ## ( 110, 170 ] 14 17.500% 25.000% #### ( 170, 250 ] 10 12.500% 37.500% ### ( 250, 380 ] 11 13.750% 51.250% ### ( 380, 580 ] 7 8.750% 60.000% ## ( 580, 870 ] 8 10.000% 70.000% ## ( 870, 1300 ] 5 6.250% 76.250% # ( 1300, 1900 ] 5 6.250% 82.500% # ( 1900, 2900 ] 8 10.000% 92.500% ## ( 2900, 4400 ] 6 7.500% 100.000% ## ** DB Stats ** Uptime(secs): 24.7 total, 3.8 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 239.32 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:7.889 H:M:S, 32.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 261.68 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.934 H:M:S, 24.8 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 4 num-running-flushes: 1 2024/11/19-16:18:03 ... thread 0: (1000000,7000000) ops and (261046.1,247482.1) ops/second in (3.830741,28.284869) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 18/11 3.75 GB 138.5 6.2 0.0 6.2 12.7 6.6 0.0 1.9 138.9 287.4 45.34 41.27 116 0.391 6395K 9993 0.0 0.0 L1 6/6 744.64 MB 0.0 2.6 2.6 0.0 2.6 2.6 0.2 1.0 227.5 225.1 11.90 11.43 2 5.949 2748K 27K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.2 0.1 0.1 0.2 0.1 2.0 1.5 242.0 241.9 0.80 0.76 2 0.400 196K 78 0.0 0.0 L3 26/0 964.78 MB 1.0 3.6 1.9 1.7 3.6 1.9 0.3 1.9 194.4 193.2 18.91 16.40 10 1.891 3734K 22K 0.0 0.0 L4 182/0 9.71 GB 1.0 1.3 1.2 0.1 1.3 1.2 0.9 1.1 121.3 121.1 10.96 6.47 27 0.406 1305K 868 0.0 0.0 L5 1064/0 87.54 GB 0.9 0.0 0.0 0.0 0.0 0.0 2.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1296/17 102.66 GB 0.0 13.9 5.9 8.0 20.4 12.4 5.3 3.1 161.6 237.5 87.91 76.32 157 0.560 14M 60K 0.0 0.0 Int 0/0 0.00 KB 0.0 13.9 5.9 8.0 20.4 12.4 5.2 3.1 161.6 237.5 87.91 76.32 157 0.560 14M 60K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 13.9 5.9 8.0 13.8 5.8 0.0 0.0 210.7 209.8 67.42 59.03 61 1.105 14M 60K 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 328.9 20.50 17.29 96 0.213 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 28.5 total, 28.3 interval Flush(GB): cumulative 6.583, interval 6.583 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 20.39 GB write, 732.60 MB/s write, 13.87 GB read, 498.32 MB/s read, 87.9 seconds Interval compaction: 20.39 GB write, 738.27 MB/s write, 13.87 GB read, 502.18 MB/s read, 87.9 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 11, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 11, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 44, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 11, total-stops: 44, interval: 55 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2722792 Average: 2.5019 StdDev: 21.15 Min: 0 Median: 1.5175 Max: 7010 Percentiles: P50: 1.52 P75: 1.90 P99: 6.06 P99.9: 14.90 P99.99: 217.70 ------------------------------------------------------ [ 0, 1 ] 448886 16.486% 16.486% ### ( 1, 2 ] 1763259 64.759% 81.245% ############# ( 2, 3 ] 297885 10.940% 92.186% ## ( 3, 4 ] 112363 4.127% 96.313% # ( 4, 6 ] 72832 2.675% 98.988% # ( 6, 10 ] 21723 0.798% 99.785% ( 10, 15 ] 3184 0.117% 99.902% ( 15, 22 ] 397 0.015% 99.917% ( 22, 34 ] 37 0.001% 99.918% ( 34, 51 ] 23 0.001% 99.919% ( 51, 76 ] 23 0.001% 99.920% ( 76, 110 ] 782 0.029% 99.949% ( 110, 170 ] 922 0.034% 99.983% ( 170, 250 ] 345 0.013% 99.995% ( 250, 380 ] 290 0.011% 100.006% ( 380, 580 ] 212 0.008% 100.014% ( 580, 870 ] 133 0.005% 100.019% ( 870, 1300 ] 71 0.003% 100.021% ( 1300, 1900 ] 34 0.001% 100.022% ( 1900, 2900 ] 18 0.001% 100.023% ( 2900, 4400 ] 34 0.001% 100.024% ( 4400, 6600 ] 5 0.000% 100.024% ( 6600, 9900 ] 3 0.000% 100.025% ** Level 1 read latency histogram (micros): Count: 502879 Average: 4.4988 StdDev: 74.57 Min: 0 Median: 1.8325 Max: 10815 Percentiles: P50: 1.83 P75: 2.69 P99: 9.18 P99.9: 164.93 P99.99: 519.89 ------------------------------------------------------ [ 0, 1 ] 10720 2.132% 2.132% ( 1, 2 ] 289150 57.499% 59.631% ########### ( 2, 3 ] 112405 22.352% 81.983% #### ( 3, 4 ] 43064 8.563% 90.546% ## ( 4, 6 ] 33774 6.716% 97.263% # ( 6, 10 ] 10989 2.185% 99.448% ( 10, 15 ] 1613 0.321% 99.769% ( 15, 22 ] 225 0.045% 99.813% ( 22, 34 ] 14 0.003% 99.816% ( 34, 51 ] 2 0.000% 99.816% ( 51, 76 ] 5 0.001% 99.817% ( 76, 110 ] 189 0.038% 99.855% ( 110, 170 ] 247 0.049% 99.904% ( 170, 250 ] 163 0.032% 99.937% ( 250, 380 ] 161 0.032% 99.969% ( 380, 580 ] 154 0.031% 99.999% ( 580, 870 ] 104 0.021% 100.020% ( 870, 1300 ] 52 0.010% 100.030% ( 1300, 1900 ] 35 0.007% 100.037% ( 1900, 2900 ] 40 0.008% 100.045% ( 2900, 4400 ] 33 0.007% 100.052% ( 4400, 6600 ] 20 0.004% 100.056% ( 6600, 9900 ] 20 0.004% 100.060% ( 9900, 14000 ] 1 0.000% 100.060% ** Level 2 read latency histogram (micros): Count: 65091 Average: 2.5131 StdDev: 12.58 Min: 1 Median: 1.5411 Max: 1349 Percentiles: P50: 1.54 P75: 1.91 P99: 6.74 P99.9: 97.36 P99.99: 546.46 ------------------------------------------------------ [ 0, 1 ] 8668 13.317% 13.317% ### ( 1, 2 ] 44129 67.796% 81.113% ############## ( 2, 3 ] 7059 10.845% 91.957% ## ( 3, 4 ] 2828 4.345% 96.302% # ( 4, 6 ] 1642 2.523% 98.825% # ( 6, 10 ] 619 0.951% 99.776% ( 10, 15 ] 61 0.094% 99.869% ( 15, 22 ] 7 0.011% 99.880% ( 22, 34 ] 2 0.003% 99.883% ( 34, 51 ] 3 0.005% 99.888% ( 51, 76 ] 1 0.002% 99.889% ( 76, 110 ] 11 0.017% 99.906% ( 110, 170 ] 25 0.038% 99.945% ( 170, 250 ] 18 0.028% 99.972% ( 250, 380 ] 4 0.006% 99.978% ( 380, 580 ] 9 0.014% 99.992% ( 580, 870 ] 2 0.003% 99.995% ( 870, 1300 ] 3 0.005% 100.000% ( 1300, 1900 ] 1 0.002% 100.002% ** Level 3 read latency histogram (micros): Count: 683406 Average: 4.5109 StdDev: 63.71 Min: 1 Median: 1.8523 Max: 14760 Percentiles: P50: 1.85 P75: 2.74 P99: 8.96 P99.9: 157.86 P99.99: 357.48 ------------------------------------------------------ [ 0, 1 ] 21186 3.100% 3.100% # ( 1, 2 ] 376043 55.025% 58.125% ########### ( 2, 3 ] 155566 22.763% 80.888% ##### ( 3, 4 ] 61900 9.058% 89.946% ## ( 4, 6 ] 52808 7.727% 97.673% ## ( 6, 10 ] 12273 1.796% 99.469% ( 10, 15 ] 2016 0.295% 99.764% ( 15, 22 ] 306 0.045% 99.809% ( 22, 34 ] 71 0.010% 99.819% ( 34, 51 ] 19 0.003% 99.822% ( 51, 76 ] 12 0.002% 99.824% ( 76, 110 ] 170 0.025% 99.848% ( 110, 170 ] 442 0.065% 99.913% ( 170, 250 ] 314 0.046% 99.959% ( 250, 380 ] 256 0.037% 99.996% ( 380, 580 ] 247 0.036% 100.033% ( 580, 870 ] 195 0.029% 100.061% ( 870, 1300 ] 122 0.018% 100.079% ( 1300, 1900 ] 50 0.007% 100.086% ( 1900, 2900 ] 47 0.007% 100.093% ( 2900, 4400 ] 77 0.011% 100.104% ( 4400, 6600 ] 11 0.002% 100.106% ( 6600, 9900 ] 4 0.001% 100.107% ( 9900, 14000 ] 2 0.000% 100.107% ( 14000, 22000 ] 1 0.000% 100.107% ** Level 4 read latency histogram (micros): Count: 19775 Average: 73.5287 StdDev: 349.95 Min: 0 Median: 1.9793 Max: 8432 Percentiles: P50: 1.98 P75: 3.29 P99: 1556.13 P99.9: 4274.34 P99.99: 6618.56 ------------------------------------------------------ [ 0, 1 ] 531 2.685% 2.685% # ( 1, 2 ] 9554 48.314% 50.999% ########## ( 2, 3 ] 4156 21.016% 72.015% #### ( 3, 4 ] 2066 10.448% 82.463% ## ( 4, 6 ] 1181 5.972% 88.435% # ( 6, 10 ] 447 2.260% 90.695% ( 10, 15 ] 87 0.440% 91.135% ( 15, 22 ] 8 0.040% 91.176% ( 34, 51 ] 1 0.005% 91.181% ( 51, 76 ] 1 0.005% 91.186% ( 76, 110 ] 39 0.197% 91.383% ( 110, 170 ] 141 0.713% 92.096% ( 170, 250 ] 167 0.845% 92.941% ( 250, 380 ] 250 1.264% 94.205% ( 380, 580 ] 321 1.623% 95.828% ( 580, 870 ] 351 1.775% 97.603% ( 870, 1300 ] 231 1.168% 98.771% ( 1300, 1900 ] 106 0.536% 99.307% ( 1900, 2900 ] 65 0.329% 99.636% ( 2900, 4400 ] 57 0.288% 99.924% ( 4400, 6600 ] 13 0.066% 99.990% ( 6600, 9900 ] 4 0.020% 100.010% ** Level 5 read latency histogram (micros): Count: 120 Average: 1033.5167 StdDev: 1092.74 Min: 93 Median: 507.2727 Max: 4176 Percentiles: P50: 507.27 P75: 1600.00 P99: 4176.00 P99.9: 4176.00 P99.99: 4176.00 ------------------------------------------------------ ( 76, 110 ] 6 5.000% 5.000% # ( 110, 170 ] 17 14.167% 19.167% ### ( 170, 250 ] 14 11.667% 30.833% ## ( 250, 380 ] 16 13.333% 44.167% ### ( 380, 580 ] 11 9.167% 53.333% ## ( 580, 870 ] 10 8.333% 61.667% ## ( 870, 1300 ] 11 9.167% 70.833% ## ( 1300, 1900 ] 10 8.333% 79.167% ## ( 1900, 2900 ] 14 11.667% 90.833% ## ( 2900, 4400 ] 11 9.167% 100.000% ## ** DB Stats ** Uptime(secs): 28.5 total, 3.8 interval Cumulative writes: 0 writes, 7000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 6.73 GB, 241.69 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:8.872 H:M:S, 31.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 256.92 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.983 H:M:S, 25.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/19-16:18:07 ... thread 0: (1000000,8000000) ops and (229233.8,245043.8) ops/second in (4.362358,32.647227) 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/7 4.73 GB 270.6 7.5 0.0 7.5 15.1 7.6 0.0 2.0 143.7 288.3 53.49 49.04 136 0.393 7802K 11K 0.0 0.0 L1 6/6 744.64 MB 0.0 2.6 2.6 0.0 2.6 2.6 0.2 1.0 227.5 225.1 11.90 11.43 2 5.949 2748K 27K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.2 0.1 0.1 0.2 0.1 2.0 1.5 242.0 241.9 0.80 0.76 2 0.400 196K 78 0.0 0.0 L3 26/0 964.78 MB 1.0 3.6 1.9 1.7 3.6 1.9 0.3 1.9 194.4 193.2 18.91 16.40 10 1.891 3734K 22K 0.0 0.0 L4 182/0 9.71 GB 1.0 1.3 1.2 0.1 1.3 1.2 0.9 1.1 121.3 121.1 10.96 6.47 27 0.406 1305K 868 0.0 0.0 L5 1064/0 87.54 GB 0.9 0.0 0.0 0.0 0.0 0.0 2.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1296/13 103.64 GB 0.0 15.2 5.9 9.3 22.7 13.4 5.3 3.0 162.3 242.3 96.07 84.10 177 0.543 15M 62K 0.0 0.0 Int 0/0 0.00 KB 0.0 15.2 5.9 9.3 22.7 13.4 5.2 3.0 162.3 242.3 96.07 84.10 177 0.543 15M 62K 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 15.2 5.9 9.3 15.2 5.8 0.0 0.0 214.4 213.5 72.72 64.26 66 1.102 15M 62K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 7.6 7.6 0.0 0.0 0.0 331.9 23.35 19.84 111 0.210 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 32.9 total, 32.6 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: 22.73 GB write, 708.16 MB/s write, 15.23 GB read, 474.35 MB/s read, 96.1 seconds Interval compaction: 22.73 GB write, 712.90 MB/s write, 15.23 GB read, 477.53 MB/s read, 96.1 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 18, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 18, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 45, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 18, total-stops: 45, interval: 63 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3156783 Average: 2.4763 StdDev: 19.95 Min: 0 Median: 1.5192 Max: 7010 Percentiles: P50: 1.52 P75: 1.90 P99: 5.98 P99.9: 14.47 P99.99: 193.31 ------------------------------------------------------ [ 0, 1 ] 509224 16.131% 16.131% ### ( 1, 2 ] 2059404 65.237% 81.369% ############# ( 2, 3 ] 347143 10.997% 92.365% ## ( 3, 4 ] 128552 4.072% 96.438% # ( 4, 6 ] 81514 2.582% 99.020% # ( 6, 10 ] 24560 0.778% 99.798% ( 10, 15 ] 3615 0.115% 99.912% ( 15, 22 ] 429 0.014% 99.926% ( 22, 34 ] 39 0.001% 99.927% ( 34, 51 ] 23 0.001% 99.928% ( 51, 76 ] 27 0.001% 99.929% ( 76, 110 ] 826 0.026% 99.955% ( 110, 170 ] 998 0.032% 99.986% ( 170, 250 ] 389 0.012% 99.999% ( 250, 380 ] 322 0.010% 100.009% ( 380, 580 ] 238 0.008% 100.016% ( 580, 870 ] 147 0.005% 100.021% ( 870, 1300 ] 78 0.002% 100.024% ( 1300, 1900 ] 34 0.001% 100.025% ( 1900, 2900 ] 19 0.001% 100.025% ( 2900, 4400 ] 35 0.001% 100.026% ( 4400, 6600 ] 5 0.000% 100.027% ( 6600, 9900 ] 3 0.000% 100.027% ** Level 1 read latency histogram (micros): Count: 618828 Average: 4.1304 StdDev: 67.38 Min: 0 Median: 1.7636 Max: 10815 Percentiles: P50: 1.76 P75: 2.55 P99: 9.03 P99.9: 157.45 P99.99: 520.75 ------------------------------------------------------ [ 0, 1 ] 28246 4.564% 4.564% # ( 1, 2 ] 368224 59.503% 64.068% ############ ( 2, 3 ] 124102 20.054% 84.122% #### ( 3, 4 ] 46606 7.531% 91.654% ## ( 4, 6 ] 35881 5.798% 97.452% # ( 6, 10 ] 12629 2.041% 99.493% ( 10, 15 ] 1714 0.277% 99.770% ( 15, 22 ] 231 0.037% 99.807% ( 22, 34 ] 15 0.002% 99.809% ( 34, 51 ] 2 0.000% 99.810% ( 51, 76 ] 9 0.001% 99.811% ( 76, 110 ] 271 0.044% 99.855% ( 110, 170 ] 353 0.057% 99.912% ( 170, 250 ] 191 0.031% 99.943% ( 250, 380 ] 176 0.028% 99.971% ( 380, 580 ] 165 0.027% 99.998% ( 580, 870 ] 112 0.018% 100.016% ( 870, 1300 ] 53 0.009% 100.025% ( 1300, 1900 ] 35 0.006% 100.030% ( 1900, 2900 ] 40 0.006% 100.037% ( 2900, 4400 ] 33 0.005% 100.042% ( 4400, 6600 ] 20 0.003% 100.045% ( 6600, 9900 ] 20 0.003% 100.048% ( 9900, 14000 ] 1 0.000% 100.049% ** Level 2 read latency histogram (micros): Count: 65091 Average: 2.5131 StdDev: 12.58 Min: 1 Median: 1.5411 Max: 1349 Percentiles: P50: 1.54 P75: 1.91 P99: 6.74 P99.9: 97.36 P99.99: 546.46 ------------------------------------------------------ [ 0, 1 ] 8668 13.317% 13.317% ### ( 1, 2 ] 44129 67.796% 81.113% ############## ( 2, 3 ] 7059 10.845% 91.957% ## ( 3, 4 ] 2828 4.345% 96.302% # ( 4, 6 ] 1642 2.523% 98.825% # ( 6, 10 ] 619 0.951% 99.776% ( 10, 15 ] 61 0.094% 99.869% ( 15, 22 ] 7 0.011% 99.880% ( 22, 34 ] 2 0.003% 99.883% ( 34, 51 ] 3 0.005% 99.888% ( 51, 76 ] 1 0.002% 99.889% ( 76, 110 ] 11 0.017% 99.906% ( 110, 170 ] 25 0.038% 99.945% ( 170, 250 ] 18 0.028% 99.972% ( 250, 380 ] 4 0.006% 99.978% ( 380, 580 ] 9 0.014% 99.992% ( 580, 870 ] 2 0.003% 99.995% ( 870, 1300 ] 3 0.005% 100.000% ( 1300, 1900 ] 1 0.002% 100.002% ** Level 3 read latency histogram (micros): Count: 683406 Average: 4.5109 StdDev: 63.71 Min: 1 Median: 1.8523 Max: 14760 Percentiles: P50: 1.85 P75: 2.74 P99: 8.96 P99.9: 157.86 P99.99: 357.48 ------------------------------------------------------ [ 0, 1 ] 21186 3.100% 3.100% # ( 1, 2 ] 376043 55.025% 58.125% ########### ( 2, 3 ] 155566 22.763% 80.888% ##### ( 3, 4 ] 61900 9.058% 89.946% ## ( 4, 6 ] 52808 7.727% 97.673% ## ( 6, 10 ] 12273 1.796% 99.469% ( 10, 15 ] 2016 0.295% 99.764% ( 15, 22 ] 306 0.045% 99.809% ( 22, 34 ] 71 0.010% 99.819% ( 34, 51 ] 19 0.003% 99.822% ( 51, 76 ] 12 0.002% 99.824% ( 76, 110 ] 170 0.025% 99.848% ( 110, 170 ] 442 0.065% 99.913% ( 170, 250 ] 314 0.046% 99.959% ( 250, 380 ] 256 0.037% 99.996% ( 380, 580 ] 247 0.036% 100.033% ( 580, 870 ] 195 0.029% 100.061% ( 870, 1300 ] 122 0.018% 100.079% ( 1300, 1900 ] 50 0.007% 100.086% ( 1900, 2900 ] 47 0.007% 100.093% ( 2900, 4400 ] 77 0.011% 100.104% ( 4400, 6600 ] 11 0.002% 100.106% ( 6600, 9900 ] 4 0.001% 100.107% ( 9900, 14000 ] 2 0.000% 100.107% ( 14000, 22000 ] 1 0.000% 100.107% ** Level 4 read latency histogram (micros): Count: 19775 Average: 73.5287 StdDev: 349.95 Min: 0 Median: 1.9793 Max: 8432 Percentiles: P50: 1.98 P75: 3.29 P99: 1556.13 P99.9: 4274.34 P99.99: 6618.56 ------------------------------------------------------ [ 0, 1 ] 531 2.685% 2.685% # ( 1, 2 ] 9554 48.314% 50.999% ########## ( 2, 3 ] 4156 21.016% 72.015% #### ( 3, 4 ] 2066 10.448% 82.463% ## ( 4, 6 ] 1181 5.972% 88.435% # ( 6, 10 ] 447 2.260% 90.695% ( 10, 15 ] 87 0.440% 91.135% ( 15, 22 ] 8 0.040% 91.176% ( 34, 51 ] 1 0.005% 91.181% ( 51, 76 ] 1 0.005% 91.186% ( 76, 110 ] 39 0.197% 91.383% ( 110, 170 ] 141 0.713% 92.096% ( 170, 250 ] 167 0.845% 92.941% ( 250, 380 ] 250 1.264% 94.205% ( 380, 580 ] 321 1.623% 95.828% ( 580, 870 ] 351 1.775% 97.603% ( 870, 1300 ] 231 1.168% 98.771% ( 1300, 1900 ] 106 0.536% 99.307% ( 1900, 2900 ] 65 0.329% 99.636% ( 2900, 4400 ] 57 0.288% 99.924% ( 4400, 6600 ] 13 0.066% 99.990% ( 6600, 9900 ] 4 0.020% 100.010% ** Level 5 read latency histogram (micros): Count: 120 Average: 1033.5167 StdDev: 1092.74 Min: 93 Median: 507.2727 Max: 4176 Percentiles: P50: 507.27 P75: 1600.00 P99: 4176.00 P99.9: 4176.00 P99.99: 4176.00 ------------------------------------------------------ ( 76, 110 ] 6 5.000% 5.000% # ( 110, 170 ] 17 14.167% 19.167% ### ( 170, 250 ] 14 11.667% 30.833% ## ( 250, 380 ] 16 13.333% 44.167% ### ( 380, 580 ] 11 9.167% 53.333% ## ( 580, 870 ] 10 8.333% 61.667% ## ( 870, 1300 ] 11 9.167% 70.833% ## ( 1300, 1900 ] 10 8.333% 79.167% ## ( 1900, 2900 ] 14 11.667% 90.833% ## ( 2900, 4400 ] 11 9.167% 100.000% ## ** DB Stats ** Uptime(secs): 32.9 total, 4.4 interval Cumulative writes: 0 writes, 8000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 7.69 GB, 239.55 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:10.435 H:M:S, 31.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 225.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:1.563 H:M:S, 35.8 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/11/19-16:18:13 ... thread 0: (1000000,9000000) ops and (156755.9,230612.1) ops/second in (6.379344,39.026571) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 16/11 3.56 GB 56.7 8.8 0.0 8.8 17.3 8.5 0.0 2.0 146.6 288.8 61.46 56.60 154 0.399 9145K 14K 0.0 0.0 L1 17/17 1.90 GB 0.0 5.5 4.7 0.7 5.4 4.7 0.2 1.1 220.5 218.1 25.34 24.00 3 8.446 5672K 60K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.2 0.1 0.1 0.2 0.1 2.9 1.5 242.0 241.9 0.80 0.76 2 0.400 196K 78 0.0 0.0 L3 19/0 983.74 MB 1.0 4.5 2.5 2.0 4.5 2.4 0.6 1.8 194.7 193.5 23.60 20.60 15 1.573 4665K 27K 0.0 0.0 L4 184/0 9.57 GB 1.0 2.2 2.1 0.1 2.2 2.1 0.9 1.1 136.7 136.5 16.59 11.00 44 0.377 2231K 1948 0.0 0.0 L5 1076/0 88.52 GB 0.9 0.0 0.0 0.0 0.0 0.0 3.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1312/28 104.52 GB 0.0 21.1 9.4 11.8 29.6 17.8 7.5 3.5 169.4 237.1 127.78 112.97 218 0.586 21M 104K 0.0 0.0 Int 0/0 0.00 KB 0.0 21.1 9.4 11.8 29.6 17.8 7.4 3.5 169.4 237.1 127.78 112.97 218 0.586 21M 104K 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 21.1 9.4 11.8 21.0 9.3 0.0 0.0 213.3 212.2 101.50 90.52 92 1.103 21M 104K 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 333.3 26.28 22.45 126 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): 39.2 total, 39.0 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: 29.59 GB write, 771.96 MB/s write, 21.14 GB read, 551.58 MB/s read, 127.8 seconds Interval compaction: 29.59 GB write, 776.28 MB/s write, 21.14 GB read, 554.67 MB/s read, 127.8 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 22, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 22, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 46, pending-compaction-bytes-delays: 20, pending-compaction-bytes-stops: 0, total-delays: 42, total-stops: 46, interval: 88 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3667131 Average: 2.5033 StdDev: 20.02 Min: 0 Median: 1.5218 Max: 7010 Percentiles: P50: 1.52 P75: 1.90 P99: 5.99 P99.9: 14.71 P99.99: 234.72 ------------------------------------------------------ [ 0, 1 ] 583386 15.909% 15.909% ### ( 1, 2 ] 2395716 65.329% 81.238% ############# ( 2, 3 ] 404417 11.028% 92.266% ## ( 3, 4 ] 150607 4.107% 96.373% # ( 4, 6 ] 97036 2.646% 99.019% # ( 6, 10 ] 28364 0.773% 99.793% ( 10, 15 ] 4178 0.114% 99.907% ( 15, 22 ] 497 0.014% 99.920% ( 22, 34 ] 44 0.001% 99.921% ( 34, 51 ] 25 0.001% 99.922% ( 51, 76 ] 28 0.001% 99.923% ( 76, 110 ] 872 0.024% 99.947% ( 110, 170 ] 1172 0.032% 99.978% ( 170, 250 ] 522 0.014% 99.993% ( 250, 380 ] 428 0.012% 100.004% ( 380, 580 ] 317 0.009% 100.013% ( 580, 870 ] 201 0.005% 100.019% ( 870, 1300 ] 101 0.003% 100.021% ( 1300, 1900 ] 45 0.001% 100.022% ( 1900, 2900 ] 24 0.001% 100.023% ( 2900, 4400 ] 41 0.001% 100.024% ( 4400, 6600 ] 5 0.000% 100.024% ( 6600, 9900 ] 3 0.000% 100.024% ** Level 1 read latency histogram (micros): Count: 834368 Average: 3.9637 StdDev: 59.46 Min: 0 Median: 1.7497 Max: 10815 Percentiles: P50: 1.75 P75: 2.52 P99: 9.00 P99.9: 154.19 P99.99: 472.14 ------------------------------------------------------ [ 0, 1 ] 42980 5.151% 5.151% # ( 1, 2 ] 499121 59.820% 64.971% ############ ( 2, 3 ] 161397 19.344% 84.315% #### ( 3, 4 ] 61699 7.395% 91.710% # ( 4, 6 ] 48070 5.761% 97.471% # ( 6, 10 ] 16989 2.036% 99.507% ( 10, 15 ] 2244 0.269% 99.776% ( 15, 22 ] 303 0.036% 99.812% ( 22, 34 ] 18 0.002% 99.815% ( 34, 51 ] 2 0.000% 99.815% ( 51, 76 ] 14 0.002% 99.817% ( 76, 110 ] 321 0.038% 99.855% ( 110, 170 ] 510 0.061% 99.916% ( 170, 250 ] 263 0.032% 99.948% ( 250, 380 ] 243 0.029% 99.977% ( 380, 580 ] 240 0.029% 100.006% ( 580, 870 ] 169 0.020% 100.026% ( 870, 1300 ] 91 0.011% 100.037% ( 1300, 1900 ] 44 0.005% 100.042% ( 1900, 2900 ] 42 0.005% 100.047% ( 2900, 4400 ] 34 0.004% 100.051% ( 4400, 6600 ] 20 0.002% 100.053% ( 6600, 9900 ] 20 0.002% 100.056% ( 9900, 14000 ] 1 0.000% 100.056% ** Level 2 read latency histogram (micros): Count: 65091 Average: 2.5131 StdDev: 12.58 Min: 1 Median: 1.5411 Max: 1349 Percentiles: P50: 1.54 P75: 1.91 P99: 6.74 P99.9: 97.36 P99.99: 546.46 ------------------------------------------------------ [ 0, 1 ] 8668 13.317% 13.317% ### ( 1, 2 ] 44129 67.796% 81.113% ############## ( 2, 3 ] 7059 10.845% 91.957% ## ( 3, 4 ] 2828 4.345% 96.302% # ( 4, 6 ] 1642 2.523% 98.825% # ( 6, 10 ] 619 0.951% 99.776% ( 10, 15 ] 61 0.094% 99.869% ( 15, 22 ] 7 0.011% 99.880% ( 22, 34 ] 2 0.003% 99.883% ( 34, 51 ] 3 0.005% 99.888% ( 51, 76 ] 1 0.002% 99.889% ( 76, 110 ] 11 0.017% 99.906% ( 110, 170 ] 25 0.038% 99.945% ( 170, 250 ] 18 0.028% 99.972% ( 250, 380 ] 4 0.006% 99.978% ( 380, 580 ] 9 0.014% 99.992% ( 580, 870 ] 2 0.003% 99.995% ( 870, 1300 ] 3 0.005% 100.000% ( 1300, 1900 ] 1 0.002% 100.002% ** Level 3 read latency histogram (micros): Count: 994035 Average: 4.4973 StdDev: 56.07 Min: 0 Median: 1.8802 Max: 14760 Percentiles: P50: 1.88 P75: 2.82 P99: 9.17 P99.9: 140.48 P99.99: 246.46 ------------------------------------------------------ [ 0, 1 ] 26215 2.637% 2.637% # ( 1, 2 ] 534875 53.808% 56.446% ########### ( 2, 3 ] 224788 22.614% 79.059% ##### ( 3, 4 ] 97847 9.843% 88.903% ## ( 4, 6 ] 83898 8.440% 97.343% ## ( 6, 10 ] 20790 2.091% 99.434% ( 10, 15 ] 3360 0.338% 99.772% ( 15, 22 ] 512 0.052% 99.824% ( 22, 34 ] 80 0.008% 99.832% ( 34, 51 ] 20 0.002% 99.834% ( 51, 76 ] 23 0.002% 99.836% ( 76, 110 ] 253 0.025% 99.862% ( 110, 170 ] 748 0.075% 99.937% ( 170, 250 ] 551 0.055% 99.992% ( 250, 380 ] 483 0.049% 100.041% ( 380, 580 ] 422 0.042% 100.083% ( 580, 870 ] 317 0.032% 100.115% ( 870, 1300 ] 189 0.019% 100.134% ( 1300, 1900 ] 69 0.007% 100.141% ( 1900, 2900 ] 53 0.005% 100.147% ( 2900, 4400 ] 81 0.008% 100.155% ( 4400, 6600 ] 11 0.001% 100.156% ( 6600, 9900 ] 4 0.000% 100.156% ( 9900, 14000 ] 2 0.000% 100.157% ( 14000, 22000 ] 1 0.000% 100.157% ** Level 4 read latency histogram (micros): Count: 36115 Average: 56.4531 StdDev: 280.35 Min: 0 Median: 1.9588 Max: 8432 Percentiles: P50: 1.96 P75: 3.26 P99: 1188.16 P99.9: 3816.57 P99.99: 5819.59 ------------------------------------------------------ [ 0, 1 ] 1181 3.270% 3.270% # ( 1, 2 ] 17601 48.736% 52.006% ########## ( 2, 3 ] 7331 20.299% 72.305% #### ( 3, 4 ] 3773 10.447% 82.752% ## ( 4, 6 ] 2147 5.945% 88.697% # ( 6, 10 ] 850 2.354% 91.051% ( 10, 15 ] 150 0.415% 91.466% ( 15, 22 ] 20 0.055% 91.522% ( 22, 34 ] 3 0.008% 91.530% ( 34, 51 ] 1 0.003% 91.533% ( 51, 76 ] 2 0.006% 91.538% ( 76, 110 ] 155 0.429% 91.967% ( 110, 170 ] 389 1.077% 93.044% ( 170, 250 ] 386 1.069% 94.113% ( 250, 380 ] 465 1.288% 95.401% ( 380, 580 ] 558 1.545% 96.946% ( 580, 870 ] 511 1.415% 98.361% ( 870, 1300 ] 312 0.864% 99.225% ( 1300, 1900 ] 131 0.363% 99.587% ( 1900, 2900 ] 75 0.208% 99.795% ( 2900, 4400 ] 62 0.172% 99.967% ( 4400, 6600 ] 13 0.036% 100.003% ( 6600, 9900 ] 4 0.011% 100.014% ** Level 5 read latency histogram (micros): Count: 180 Average: 950.1722 StdDev: 1052.52 Min: 93 Median: 393.3333 Max: 4176 Percentiles: P50: 393.33 P75: 1476.47 P99: 4176.00 P99.9: 4176.00 P99.99: 4176.00 ------------------------------------------------------ ( 76, 110 ] 10 5.556% 5.556% # ( 110, 170 ] 31 17.222% 22.778% ### ( 170, 250 ] 22 12.222% 35.000% ## ( 250, 380 ] 26 14.444% 49.444% ### ( 380, 580 ] 15 8.333% 57.778% ## ( 580, 870 ] 13 7.222% 65.000% # ( 870, 1300 ] 13 7.222% 72.222% # ( 1300, 1900 ] 17 9.444% 81.667% ## ( 1900, 2900 ] 19 10.556% 92.222% ## ( 2900, 4400 ] 14 7.778% 100.000% ## ** DB Stats ** Uptime(secs): 39.2 total, 6.4 interval Cumulative writes: 0 writes, 9000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 8.65 GB, 225.69 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:13.931 H:M:S, 35.5 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 154.28 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:3.496 H:M:S, 54.8 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 using bdev Nvme0n1 Initializing RocksDB Options from the specified file Initializing RocksDB Options from command-line flags Integrated BlobDB: blob cache disabled Keys: 16 bytes each (+ 0 bytes user-defined timestamp) Values: 1000 bytes each (1000 bytes after compression) Entries: 100000000 Prefix: 0 bytes Keys per prefix: 0 RawSize: 96893.3 MB (estimated) FileSize: 96893.3 MB (estimated) Write rate: 0 bytes/second Read rate: 0 ops/second Compression: NoCompression Compression sampling rate: 0 Memtablerep: SkipListFactory Perf Level: 1 ------------------------------------------------ DB path: [/mnt/rocksdb] overwrite : 6.342 micros/op 157670 ops/sec 60.068 seconds 9470999 operations; 152.8 MB/s Microseconds per write: Count: 9470999 Average: 6.3419 StdDev: 300.97 Min: 1 Median: 1.7847 Max: 337595 Percentiles: P50: 1.78 P75: 2.87 P99: 10.77 P99.9: 1178.67 P99.99: 2654.86 ------------------------------------------------------ [ 0, 1 ] 1014377 10.710% 10.710% ## ( 1, 2 ] 4742105 50.070% 60.780% ########## ( 2, 3 ] 1545394 16.317% 77.097% ### ( 3, 4 ] 1338703 14.135% 91.232% ### ( 4, 6 ] 571797 6.037% 97.269% # ( 6, 10 ] 155330 1.640% 98.909% ( 10, 15 ] 55630 0.587% 99.497% ( 15, 22 ] 11711 0.124% 99.620% ( 22, 34 ] 2133 0.023% 99.643% ( 34, 51 ] 256 0.003% 99.646% ( 51, 76 ] 35 0.000% 99.646% ( 76, 110 ] 6430 0.068% 99.714% ( 110, 170 ] 2667 0.028% 99.742% ( 170, 250 ] 257 0.003% 99.745% ( 250, 380 ] 244 0.003% 99.747% ( 380, 580 ] 29 0.000% 99.748% ( 580, 870 ] 16 0.000% 99.748% ( 870, 1300 ] 20080 0.212% 99.960% ( 1300, 1900 ] 77 0.001% 99.961% ( 1900, 2900 ] 3684 0.039% 100.000% ( 2900, 4400 ] 22 0.000% 100.000% ( 4400, 6600 ] 4 0.000% 100.000% ( 14000, 22000 ] 1 0.000% 100.000% ( 22000, 33000 ] 1 0.000% 100.000% ( 110000, 170000 ] 2 0.000% 100.000% ( 170000, 250000 ] 10 0.000% 100.000% ( 250000, 380000 ] 4 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 : 209569 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 : 9470999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 9774070968 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 : 501 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 32831193 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 : 28497153720 rocksdb.compact.write.bytes COUNT : 28306533709 rocksdb.flush.write.bytes COUNT : 9710545077 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 : 44 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 : 278 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 : 9632185344 rocksdb.memtable.garbage.bytes.at.flush COUNT : 3692544 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 : 28581835769 rocksdb.non.last.level.read.count COUNT : 6909760 rocksdb.block.checksum.compute.count COUNT : 6908802 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.431762 P95 : 4.103666 P99 : 9.096688 P100 : 337589.000000 COUNT : 9470999 SUM : 55216617 rocksdb.compaction.times.micros P50 : 787500.000000 P95 : 3355000.000000 P99 : 12026000.000000 P100 : 13439764.000000 COUNT : 94 SUM : 103677880 rocksdb.compaction.times.cpu_micros P50 : 744000.000000 P95 : 3040000.000000 P99 : 12026000.000000 P100 : 12578769.000000 COUNT : 94 SUM : 92650360 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 : 719.423077 P95 : 1286.025000 P99 : 12647.000000 P100 : 18303.000000 COUNT : 133 SUM : 131269 rocksdb.compaction.outfile.sync.micros P50 : 1000.131579 P95 : 13555.833333 P99 : 60291.666667 P100 : 65715.000000 COUNT : 353 SUM : 1233606 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 : 98.666667 P95 : 609.000000 P99 : 2650.000000 P100 : 3750.000000 COUNT : 250 SUM : 49343 rocksdb.table.open.io.micros P50 : 1121.595745 P95 : 6137.083333 P99 : 10576.500000 P100 : 11239.000000 COUNT : 501 SUM : 872154 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.629401 P95 : 7.406683 P99 : 10.926274 P100 : 14768.000000 COUNT : 6907429 SUM : 37944123 rocksdb.read.block.get.micros P50 : 319.012346 P95 : 3070.192308 P99 : 4226.346154 P100 : 8462.000000 COUNT : 1002 SUM : 706005 rocksdb.write.raw.block.micros P50 : 0.514160 P95 : 0.976905 P99 : 3.028867 P100 : 18218.000000 COUNT : 9220054 SUM : 17723252 rocksdb.numfiles.in.singlecompaction P50 : 2.409091 P95 : 5.233333 P99 : 14.425000 P100 : 28.000000 COUNT : 123 SUM : 411 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.566503 P95 : 1161.279591 P99 : 2351.776691 P100 : 337353.000000 COUNT : 204801 SUM : 32860473 rocksdb.sst.read.micros P50 : 1.553181 P95 : 4.138437 P99 : 8.214141 P100 : 14760.000000 COUNT : 6909954 SUM : 23414707 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 : 9470999 SUM : 9774070968 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 : 211200.000000 P95 : 372958.333333 P99 : 492089.000000 P100 : 492089.000000 COUNT : 133 SUM : 27689468 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 : 319 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