[2024-11-28 01:51:55.233484] Starting SPDK v24.09.1-pre git sha1 b18e1bd62 / DPDK 22.11.4 initialization... [2024-11-28 01:51:55.233634] [ 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_pid2273149 ] Set seed to 1732755115230058 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-11-28 01:51:55.315536] app.c: 917:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-11-28 01:51:55.353353] app.c: 610:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-11-28 01:51:55.353401] app.c: 611:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 2273149' to capture a snapshot of events at runtime. [2024-11-28 01:51:55.353411] app.c: 616:app_setup_trace: *NOTICE*: 'spdk_trace' without parameters will also work if this is the only [2024-11-28 01:51:55.353422] app.c: 617:app_setup_trace: *NOTICE*: SPDK application currently running. [2024-11-28 01:51:55.353430] app.c: 618:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid2273149 for offline analysis/debug. [2024-11-28 01:51:55.353512] reactor.c: 990:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Thu Nov 28 01:51:59 2024 CPU: 96 * Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz CPUCache: 36608 KB 2024/11/28-01:52:07 ... thread 0: (1000000,1000000) ops and (123659.7,123659.7) ops/second in (8.086709,8.086709) 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/5 881.25 MB 18.9 0.4 0.0 0.4 1.2 0.9 0.0 1.4 38.3 127.5 9.88 4.12 11 0.898 383K 574 0.0 0.0 L1 2/2 194.58 MB 0.0 0.6 0.5 0.1 0.6 0.5 0.0 1.2 104.2 103.9 5.80 2.78 1 5.804 614K 1390 0.0 0.0 L2 5/3 375.96 MB 1.5 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 L3 36/21 3.24 GB 1.6 3.0 2.0 1.0 2.9 2.0 0.3 1.5 96.6 95.3 31.53 14.25 17 1.855 1644K 858 0.0 0.0 L4 195/14 12.49 GB 1.2 3.1 2.1 1.1 3.1 2.0 0.7 1.5 120.1 118.7 26.70 14.52 20 1.335 1715K 0 0.0 0.0 L5 1085/0 89.63 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1330/45 106.78 GB 0.0 7.1 4.5 2.5 7.9 5.3 1.4 9.1 97.9 108.8 73.91 35.68 49 1.508 4357K 2822 0.0 0.0 Int 0/0 0.00 KB 0.0 7.1 4.5 2.5 7.9 5.3 1.4 9.1 97.9 108.8 73.91 35.68 49 1.508 4357K 2822 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 7.1 4.5 2.5 7.0 4.5 0.0 0.0 108.8 107.6 66.52 33.03 39 1.706 4357K 2822 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 119.3 7.39 2.65 10 0.739 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 8.2 total, 8.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: 7.85 GB write, 976.60 MB/s write, 7.06 GB read, 878.88 MB/s read, 73.9 seconds Interval compaction: 7.85 GB write, 993.84 MB/s write, 7.06 GB read, 894.40 MB/s read, 73.9 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 34, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 34, interval: 34 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 275576 Average: 9.6002 StdDev: 122.47 Min: 0 Median: 1.8936 Max: 9723 Percentiles: P50: 1.89 P75: 2.92 P99: 9.81 P99.9: 1829.64 P99.99: 4097.68 ------------------------------------------------------ [ 0, 1 ] 9831 3.567% 3.567% # ( 1, 2 ] 143188 51.960% 55.527% ########## ( 2, 3 ] 58593 21.262% 76.789% #### ( 3, 4 ] 26592 9.650% 86.439% ## ( 4, 6 ] 28579 10.371% 96.809% ## ( 6, 10 ] 6338 2.300% 99.109% ( 10, 15 ] 881 0.320% 99.429% ( 15, 22 ] 95 0.034% 99.463% ( 22, 34 ] 16 0.006% 99.469% ( 34, 51 ] 9 0.003% 99.472% ( 51, 76 ] 11 0.004% 99.476% ( 76, 110 ] 13 0.005% 99.481% ( 110, 170 ] 23 0.008% 99.489% ( 170, 250 ] 59 0.021% 99.511% ( 250, 380 ] 110 0.040% 99.551% ( 380, 580 ] 199 0.072% 99.623% ( 580, 870 ] 297 0.108% 99.731% ( 870, 1300 ] 305 0.111% 99.841% ( 1300, 1900 ] 185 0.067% 99.909% ( 1900, 2900 ] 145 0.053% 99.961% ( 2900, 4400 ] 102 0.037% 99.998% ( 4400, 6600 ] 27 0.010% 100.008% ( 6600, 9900 ] 5 0.002% 100.010% ** Level 1 read latency histogram (micros): Count: 42291 Average: 28.1043 StdDev: 271.65 Min: 1 Median: 2.0804 Max: 9786 Percentiles: P50: 2.08 P75: 3.25 P99: 781.87 P99.9: 4246.85 P99.99: 7906.28 ------------------------------------------------------ [ 0, 1 ] 392 0.927% 0.927% ( 1, 2 ] 19932 47.131% 48.058% ######### ( 2, 3 ] 10221 24.168% 72.226% ##### ( 3, 4 ] 4754 11.241% 83.467% ## ( 4, 6 ] 5139 12.152% 95.618% ## ( 6, 10 ] 1070 2.530% 98.149% # ( 10, 15 ] 172 0.407% 98.555% ( 15, 22 ] 15 0.035% 98.591% ( 22, 34 ] 2 0.005% 98.595% ( 51, 76 ] 1 0.002% 98.598% ( 76, 110 ] 2 0.005% 98.603% ( 110, 170 ] 5 0.012% 98.614% ( 170, 250 ] 8 0.019% 98.633% ( 250, 380 ] 16 0.038% 98.671% ( 380, 580 ] 66 0.156% 98.827% ( 580, 870 ] 105 0.248% 99.075% ( 870, 1300 ] 103 0.244% 99.319% ( 1300, 1900 ] 85 0.201% 99.520% ( 1900, 2900 ] 79 0.187% 99.707% ( 2900, 4400 ] 91 0.215% 99.922% ( 4400, 6600 ] 26 0.061% 99.983% ( 6600, 9900 ] 7 0.017% 100.000% ** Level 2 read latency histogram (micros): Count: 499482 Average: 14.3746 StdDev: 181.52 Min: 1 Median: 1.9832 Max: 30783 Percentiles: P50: 1.98 P75: 3.06 P99: 11.80 P99.9: 1377.21 P99.99: 1869.40 ------------------------------------------------------ [ 0, 1 ] 13859 2.775% 2.775% # ( 1, 2 ] 239907 48.031% 50.806% ########## ( 2, 3 ] 117645 23.553% 74.359% ##### ( 3, 4 ] 51803 10.371% 84.731% ## ( 4, 6 ] 54708 10.953% 95.684% ## ( 6, 10 ] 15529 3.109% 98.793% # ( 10, 15 ] 2883 0.577% 99.370% ( 15, 22 ] 485 0.097% 99.467% ( 22, 34 ] 95 0.019% 99.486% ( 34, 51 ] 29 0.006% 99.492% ( 51, 76 ] 20 0.004% 99.496% ( 76, 110 ] 22 0.004% 99.500% ( 110, 170 ] 45 0.009% 99.509% ( 170, 250 ] 75 0.015% 99.524% ( 250, 380 ] 222 0.044% 99.569% ( 380, 580 ] 354 0.071% 99.639% ( 580, 870 ] 574 0.115% 99.754% ( 870, 1300 ] 657 0.132% 99.886% ( 1300, 1900 ] 548 0.110% 99.996% ( 1900, 2900 ] 443 0.089% 100.084% ( 2900, 4400 ] 419 0.084% 100.168% ( 4400, 6600 ] 148 0.030% 100.198% ( 6600, 9900 ] 18 0.004% 100.201% ( 9900, 14000 ] 1 0.000% 100.202% ( 14000, 22000 ] 1 0.000% 100.202% ( 22000, 33000 ] 1 0.000% 100.202% ** Level 3 read latency histogram (micros): Count: 893996 Average: 9.6040 StdDev: 132.41 Min: 1 Median: 1.9504 Max: 28724 Percentiles: P50: 1.95 P75: 2.97 P99: 9.50 P99.9: 808.90 P99.99: 1191.14 ------------------------------------------------------ [ 0, 1 ] 18174 2.033% 2.033% ( 1, 2 ] 451209 50.471% 52.504% ########## ( 2, 3 ] 207029 23.158% 75.662% ##### ( 3, 4 ] 93278 10.434% 86.095% ## ( 4, 6 ] 96857 10.834% 96.930% ## ( 6, 10 ] 21145 2.365% 99.295% ( 10, 15 ] 3106 0.347% 99.642% ( 15, 22 ] 408 0.046% 99.688% ( 22, 34 ] 54 0.006% 99.694% ( 34, 51 ] 31 0.003% 99.697% ( 51, 76 ] 51 0.006% 99.703% ( 76, 110 ] 21 0.002% 99.705% ( 110, 170 ] 67 0.007% 99.713% ( 170, 250 ] 138 0.015% 99.728% ( 250, 380 ] 278 0.031% 99.760% ( 380, 580 ] 579 0.065% 99.824% ( 580, 870 ] 859 0.096% 99.920% ( 870, 1300 ] 835 0.093% 100.014% ( 1300, 1900 ] 596 0.067% 100.080% ( 1900, 2900 ] 420 0.047% 100.127% ( 2900, 4400 ] 387 0.043% 100.171% ( 4400, 6600 ] 96 0.011% 100.181% ( 6600, 9900 ] 23 0.003% 100.184% ( 9900, 14000 ] 5 0.001% 100.185% ( 22000, 33000 ] 1 0.000% 100.185% ** Level 4 read latency histogram (micros): Count: 362980 Average: 24.0973 StdDev: 229.72 Min: 1 Median: 1.9583 Max: 11243 Percentiles: P50: 1.96 P75: 3.02 P99: 588.71 P99.9: 2609.38 P99.99: 3370.46 ------------------------------------------------------ [ 0, 1 ] 6821 1.879% 1.879% ( 1, 2 ] 182274 50.216% 52.095% ########## ( 2, 3 ] 82553 22.743% 74.838% ##### ( 3, 4 ] 38388 10.576% 85.414% ## ( 4, 6 ] 37406 10.305% 95.719% ## ( 6, 10 ] 9159 2.523% 98.243% # ( 10, 15 ] 1309 0.361% 98.603% ( 15, 22 ] 175 0.048% 98.651% ( 22, 34 ] 26 0.007% 98.659% ( 34, 51 ] 27 0.007% 98.666% ( 51, 76 ] 30 0.008% 98.674% ( 76, 110 ] 8 0.002% 98.677% ( 110, 170 ] 42 0.012% 98.688% ( 170, 250 ] 133 0.037% 98.725% ( 250, 380 ] 290 0.080% 98.805% ( 380, 580 ] 677 0.187% 98.991% ( 580, 870 ] 1072 0.295% 99.286% ( 870, 1300 ] 1102 0.304% 99.590% ( 1300, 1900 ] 715 0.197% 99.787% ( 1900, 2900 ] 578 0.159% 99.946% ( 2900, 4400 ] 506 0.139% 100.086% ( 4400, 6600 ] 163 0.045% 100.131% ( 6600, 9900 ] 26 0.007% 100.138% ( 9900, 14000 ] 1 0.000% 100.138% ** Level 5 read latency histogram (micros): Count: 14723 Average: 1597.3861 StdDev: 1430.58 Min: 86 Median: 1089.8708 Max: 28861 Percentiles: P50: 1089.87 P75: 2149.84 P99: 6510.45 P99.9: 9758.31 P99.99: 21055.40 ------------------------------------------------------ ( 76, 110 ] 16 0.109% 0.109% ( 110, 170 ] 100 0.679% 0.788% ( 170, 250 ] 285 1.936% 2.724% ( 250, 380 ] 805 5.468% 8.191% # ( 380, 580 ] 1817 12.341% 20.533% ## ( 580, 870 ] 2894 19.656% 40.189% #### ( 870, 1300 ] 2825 19.188% 59.376% #### ( 1300, 1900 ] 1905 12.939% 72.315% ### ( 1900, 2900 ] 1582 10.745% 83.061% ## ( 2900, 4400 ] 1705 11.581% 94.641% ## ( 4400, 6600 ] 669 4.544% 99.185% # ( 6600, 9900 ] 110 0.747% 99.932% ( 9900, 14000 ] 5 0.034% 99.966% ( 14000, 22000 ] 4 0.027% 99.993% ( 22000, 33000 ] 1 0.007% 100.000% ** DB Stats ** Uptime(secs): 8.2 total, 8.1 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 119.56 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:4.082 H:M:S, 49.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 121.66 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:4.082 H:M:S, 50.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 10 num-running-flushes: 1 2024/11/28-01:52:14 ... thread 0: (1000000,2000000) ops and (146507.8,134117.6) ops/second in (6.825574,14.912283) 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/5 1.11 GB 18.9 1.1 0.0 1.1 2.9 1.8 0.0 1.6 54.3 141.7 20.89 9.89 24 0.870 1151K 1602 0.0 0.0 L1 4/4 338.16 MB 0.0 1.5 1.2 0.3 1.5 1.1 0.0 1.3 122.6 122.2 12.17 6.91 2 6.085 1514K 4362 0.0 0.0 L2 3/3 267.03 MB 0.0 0.0 0.0 0.0 0.0 0.0 0.9 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L3 28/11 1.74 GB 1.0 5.0 2.6 2.5 5.0 2.5 0.4 2.0 105.3 104.3 49.09 24.23 24 2.045 2767K 3300 0.0 0.0 L4 170/3 9.61 GB 1.0 7.4 3.9 3.6 7.3 3.8 1.0 1.9 123.7 121.7 61.63 34.62 39 1.580 3332K 12K 0.0 0.0 L5 1145/0 94.55 GB 1.0 0.0 0.0 0.0 0.0 0.0 4.9 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1357/26 107.60 GB 0.0 15.1 7.6 7.5 16.7 9.2 7.3 9.3 107.2 118.7 143.78 75.65 89 1.616 8765K 21K 0.0 0.0 Int 0/0 0.00 KB 0.0 15.1 7.6 7.5 16.7 9.2 7.3 9.3 107.2 118.7 143.78 75.65 89 1.616 8765K 21K 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.1 7.6 7.5 14.9 7.4 0.0 0.0 118.8 117.4 129.79 70.31 68 1.909 8765K 21K 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 130.6 13.99 5.35 21 0.666 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 15.1 total, 14.9 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: 16.67 GB write, 1133.40 MB/s write, 15.06 GB read, 1024.16 MB/s read, 143.8 seconds Interval compaction: 16.67 GB write, 1144.25 MB/s write, 15.06 GB read, 1033.97 MB/s read, 143.8 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 64, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 64, interval: 64 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 614848 Average: 10.3077 StdDev: 128.71 Min: 0 Median: 1.8836 Max: 10032 Percentiles: P50: 1.88 P75: 2.88 P99: 9.89 P99.9: 1838.82 P99.99: 3958.39 ------------------------------------------------------ [ 0, 1 ] 22498 3.659% 3.659% # ( 1, 2 ] 322444 52.443% 56.102% ########## ( 2, 3 ] 132307 21.519% 77.621% #### ( 3, 4 ] 57262 9.313% 86.934% ## ( 4, 6 ] 61034 9.927% 96.861% ## ( 6, 10 ] 13534 2.201% 99.062% ( 10, 15 ] 1870 0.304% 99.366% ( 15, 22 ] 202 0.033% 99.399% ( 22, 34 ] 26 0.004% 99.403% ( 34, 51 ] 26 0.004% 99.407% ( 51, 76 ] 27 0.004% 99.412% ( 76, 110 ] 17 0.003% 99.414% ( 110, 170 ] 55 0.009% 99.423% ( 170, 250 ] 136 0.022% 99.445% ( 250, 380 ] 285 0.046% 99.492% ( 380, 580 ] 574 0.093% 99.585% ( 580, 870 ] 788 0.128% 99.713% ( 870, 1300 ] 763 0.124% 99.837% ( 1300, 1900 ] 430 0.070% 99.907% ( 1900, 2900 ] 331 0.054% 99.961% ( 2900, 4400 ] 253 0.041% 100.002% ( 4400, 6600 ] 75 0.012% 100.014% ( 6600, 9900 ] 9 0.001% 100.016% ( 9900, 14000 ] 1 0.000% 100.016% ** Level 1 read latency histogram (micros): Count: 266897 Average: 13.4253 StdDev: 166.16 Min: 1 Median: 1.9894 Max: 10828 Percentiles: P50: 1.99 P75: 2.99 P99: 11.45 P99.9: 2400.53 P99.99: 3938.48 ------------------------------------------------------ [ 0, 1 ] 3623 1.357% 1.357% ( 1, 2 ] 131217 49.164% 50.521% ########## ( 2, 3 ] 65940 24.706% 75.228% ##### ( 3, 4 ] 27189 10.187% 85.415% ## ( 4, 6 ] 29010 10.869% 96.284% ## ( 6, 10 ] 6946 2.603% 98.886% # ( 10, 15 ] 1045 0.392% 99.278% ( 15, 22 ] 97 0.036% 99.314% ( 22, 34 ] 8 0.003% 99.317% ( 34, 51 ] 18 0.007% 99.324% ( 51, 76 ] 21 0.008% 99.332% ( 76, 110 ] 7 0.003% 99.335% ( 110, 170 ] 15 0.006% 99.340% ( 170, 250 ] 47 0.018% 99.358% ( 250, 380 ] 112 0.042% 99.400% ( 380, 580 ] 275 0.103% 99.503% ( 580, 870 ] 383 0.144% 99.646% ( 870, 1300 ] 361 0.135% 99.782% ( 1300, 1900 ] 219 0.082% 99.864% ( 1900, 2900 ] 194 0.073% 99.936% ( 2900, 4400 ] 207 0.078% 100.014% ( 4400, 6600 ] 61 0.023% 100.037% ( 6600, 9900 ] 12 0.004% 100.041% ( 9900, 14000 ] 1 0.000% 100.042% ** Level 2 read latency histogram (micros): Count: 518413 Average: 14.0361 StdDev: 178.89 Min: 1 Median: 1.9843 Max: 30783 Percentiles: P50: 1.98 P75: 3.06 P99: 11.64 P99.9: 1368.15 P99.99: 1876.22 ------------------------------------------------------ [ 0, 1 ] 14219 2.743% 2.743% # ( 1, 2 ] 248893 48.011% 50.753% ########## ( 2, 3 ] 122226 23.577% 74.330% ##### ( 3, 4 ] 53785 10.375% 84.705% ## ( 4, 6 ] 57003 10.996% 95.701% ## ( 6, 10 ] 16128 3.111% 98.812% # ( 10, 15 ] 2970 0.573% 99.385% ( 15, 22 ] 504 0.097% 99.482% ( 22, 34 ] 95 0.018% 99.500% ( 34, 51 ] 30 0.006% 99.506% ( 51, 76 ] 24 0.005% 99.511% ( 76, 110 ] 23 0.004% 99.515% ( 110, 170 ] 45 0.009% 99.524% ( 170, 250 ] 75 0.014% 99.538% ( 250, 380 ] 222 0.043% 99.581% ( 380, 580 ] 357 0.069% 99.650% ( 580, 870 ] 575 0.111% 99.761% ( 870, 1300 ] 658 0.127% 99.888% ( 1300, 1900 ] 551 0.106% 99.994% ( 1900, 2900 ] 446 0.086% 100.080% ( 2900, 4400 ] 421 0.081% 100.161% ( 4400, 6600 ] 151 0.029% 100.191% ( 6600, 9900 ] 18 0.003% 100.194% ( 9900, 14000 ] 1 0.000% 100.194% ( 14000, 22000 ] 1 0.000% 100.194% ( 22000, 33000 ] 1 0.000% 100.195% ** Level 3 read latency histogram (micros): Count: 1711284 Average: 9.9150 StdDev: 137.31 Min: 1 Median: 1.9636 Max: 28724 Percentiles: P50: 1.96 P75: 2.98 P99: 9.60 P99.9: 831.73 P99.99: 1228.07 ------------------------------------------------------ [ 0, 1 ] 30166 1.763% 1.763% ( 1, 2 ] 856632 50.058% 51.821% ########## ( 2, 3 ] 405740 23.710% 75.530% ##### ( 3, 4 ] 176233 10.298% 85.829% ## ( 4, 6 ] 186505 10.899% 96.727% ## ( 6, 10 ] 43235 2.526% 99.254% # ( 10, 15 ] 6340 0.370% 99.624% ( 15, 22 ] 785 0.046% 99.670% ( 22, 34 ] 89 0.005% 99.675% ( 34, 51 ] 110 0.006% 99.682% ( 51, 76 ] 162 0.009% 99.691% ( 76, 110 ] 32 0.002% 99.693% ( 110, 170 ] 117 0.007% 99.700% ( 170, 250 ] 262 0.015% 99.715% ( 250, 380 ] 533 0.031% 99.746% ( 380, 580 ] 1150 0.067% 99.813% ( 580, 870 ] 1707 0.100% 99.913% ( 870, 1300 ] 1579 0.092% 100.005% ( 1300, 1900 ] 1013 0.059% 100.065% ( 1900, 2900 ] 754 0.044% 100.109% ( 2900, 4400 ] 841 0.049% 100.158% ( 4400, 6600 ] 263 0.015% 100.173% ( 6600, 9900 ] 52 0.003% 100.176% ( 9900, 14000 ] 8 0.000% 100.177% ( 22000, 33000 ] 1 0.000% 100.177% ** Level 4 read latency histogram (micros): Count: 916955 Average: 19.5006 StdDev: 203.93 Min: 1 Median: 1.9645 Max: 11804 Percentiles: P50: 1.96 P75: 3.02 P99: 263.76 P99.9: 2239.04 P99.99: 3090.82 ------------------------------------------------------ [ 0, 1 ] 16337 1.782% 1.782% ( 1, 2 ] 458425 49.994% 51.776% ########## ( 2, 3 ] 211111 23.023% 74.799% ##### ( 3, 4 ] 94969 10.357% 85.156% ## ( 4, 6 ] 98091 10.697% 95.853% ## ( 6, 10 ] 24166 2.635% 98.489% # ( 10, 15 ] 3458 0.377% 98.866% ( 15, 22 ] 415 0.045% 98.911% ( 22, 34 ] 53 0.006% 98.917% ( 34, 51 ] 63 0.007% 98.924% ( 51, 76 ] 101 0.011% 98.935% ( 76, 110 ] 34 0.004% 98.939% ( 110, 170 ] 141 0.015% 98.954% ( 170, 250 ] 348 0.038% 98.992% ( 250, 380 ] 694 0.076% 99.068% ( 380, 580 ] 1487 0.162% 99.230% ( 580, 870 ] 2260 0.246% 99.476% ( 870, 1300 ] 2216 0.242% 99.718% ( 1300, 1900 ] 1310 0.143% 99.861% ( 1900, 2900 ] 1059 0.115% 99.976% ( 2900, 4400 ] 985 0.107% 100.084% ( 4400, 6600 ] 334 0.036% 100.120% ( 6600, 9900 ] 55 0.006% 100.126% ( 9900, 14000 ] 5 0.001% 100.127% ** Level 5 read latency histogram (micros): Count: 32013 Average: 1369.8973 StdDev: 1271.05 Min: 82 Median: 926.2776 Max: 28861 Percentiles: P50: 926.28 P75: 1691.97 P99: 6276.70 P99.9: 9505.39 P99.99: 17597.40 ------------------------------------------------------ ( 76, 110 ] 50 0.156% 0.156% ( 110, 170 ] 315 0.984% 1.140% ( 170, 250 ] 862 2.693% 3.833% # ( 250, 380 ] 2168 6.772% 10.605% # ( 380, 580 ] 4710 14.713% 25.318% ### ( 580, 870 ] 7061 22.057% 47.375% #### ( 870, 1300 ] 6422 20.061% 67.435% #### ( 1300, 1900 ] 3707 11.580% 79.015% ## ( 1900, 2900 ] 2712 8.472% 87.486% ## ( 2900, 4400 ] 2826 8.828% 96.314% ## ( 4400, 6600 ] 1008 3.149% 99.463% # ( 6600, 9900 ] 159 0.497% 99.959% ( 9900, 14000 ] 8 0.025% 99.984% ( 14000, 22000 ] 4 0.012% 99.997% ( 22000, 33000 ] 1 0.003% 100.000% ** DB Stats ** Uptime(secs): 15.1 total, 6.8 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 130.73 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.987 H:M:S, 46.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 144.19 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:2.906 H:M:S, 42.6 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 6 num-running-flushes: 1 2024/11/28-01:52:19 ... thread 0: (1000000,3000000) ops and (203171.0,151253.6) ops/second in (4.921962,19.834245) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 15/9 2.09 GB 94.4 1.7 0.0 1.7 4.5 2.8 0.0 1.6 61.7 160.7 28.59 15.19 40 0.715 1790K 2328 0.0 0.0 L1 4/4 338.16 MB 0.0 1.5 1.2 0.3 1.5 1.1 0.0 1.3 122.6 122.2 12.17 6.91 2 6.085 1514K 4362 0.0 0.0 L3 20/0 910.72 MB 0.9 6.0 2.8 3.1 5.9 2.8 0.4 2.1 110.3 109.4 55.28 28.49 27 2.048 3582K 7077 0.0 0.0 L4 173/0 9.73 GB 1.0 10.5 4.9 5.6 10.3 4.7 1.1 2.1 129.4 127.2 83.27 49.03 51 1.633 5635K 15K 0.0 0.0 L5 1157/0 95.48 GB 1.0 0.0 0.0 0.0 0.0 0.0 5.8 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1369/13 108.52 GB 0.0 19.7 8.9 10.8 22.2 11.4 7.3 8.0 112.2 126.7 179.32 99.62 120 1.494 12M 28K 0.0 0.0 Int 0/0 0.00 KB 0.0 19.7 8.9 10.8 22.2 11.4 7.3 8.0 112.2 126.7 179.32 99.62 120 1.494 12M 28K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 19.7 8.9 10.8 19.4 8.7 0.0 0.0 125.5 123.9 160.44 91.47 85 1.888 12M 28K 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 150.2 18.87 8.15 35 0.539 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.0 total, 19.8 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: 22.19 GB write, 1137.11 MB/s write, 19.66 GB read, 1007.48 MB/s read, 179.3 seconds Interval compaction: 22.19 GB write, 1145.29 MB/s write, 19.66 GB read, 1014.73 MB/s read, 179.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: 75, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 75, interval: 75 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 937862 Average: 10.2109 StdDev: 118.47 Min: 0 Median: 1.8356 Max: 10032 Percentiles: P50: 1.84 P75: 2.79 P99: 14.62 P99.9: 1488.00 P99.99: 3177.21 ------------------------------------------------------ [ 0, 1 ] 47754 5.092% 5.092% # ( 1, 2 ] 504021 53.741% 58.833% ########### ( 2, 3 ] 191829 20.454% 79.287% #### ( 3, 4 ] 80979 8.634% 87.922% ## ( 4, 6 ] 83687 8.923% 96.845% ## ( 6, 10 ] 17841 1.902% 98.747% ( 10, 15 ] 2568 0.274% 99.021% ( 15, 22 ] 297 0.032% 99.053% ( 22, 34 ] 37 0.004% 99.056% ( 34, 51 ] 34 0.004% 99.060% ( 51, 76 ] 43 0.005% 99.065% ( 76, 110 ] 356 0.038% 99.103% ( 110, 170 ] 1315 0.140% 99.243% ( 170, 250 ] 1214 0.129% 99.372% ( 250, 380 ] 1051 0.112% 99.484% ( 380, 580 ] 1333 0.142% 99.626% ( 580, 870 ] 1326 0.141% 99.768% ( 870, 1300 ] 1070 0.114% 99.882% ( 1300, 1900 ] 543 0.058% 99.940% ( 1900, 2900 ] 413 0.044% 99.984% ( 2900, 4400 ] 315 0.034% 100.017% ( 4400, 6600 ] 91 0.010% 100.027% ( 6600, 9900 ] 11 0.001% 100.028% ( 9900, 14000 ] 1 0.000% 100.028% ** Level 1 read latency histogram (micros): Count: 359297 Average: 11.9976 StdDev: 151.66 Min: 1 Median: 1.9897 Max: 10828 Percentiles: P50: 1.99 P75: 3.01 P99: 11.40 P99.9: 2153.14 P99.99: 3940.47 ------------------------------------------------------ [ 0, 1 ] 5340 1.486% 1.486% ( 1, 2 ] 176117 49.017% 50.503% ########## ( 2, 3 ] 87533 24.362% 74.866% ##### ( 3, 4 ] 36745 10.227% 85.093% ## ( 4, 6 ] 39748 11.063% 96.155% ## ( 6, 10 ] 9825 2.735% 98.890% # ( 10, 15 ] 1414 0.394% 99.283% ( 15, 22 ] 176 0.049% 99.332% ( 22, 34 ] 16 0.004% 99.337% ( 34, 51 ] 23 0.006% 99.343% ( 51, 76 ] 34 0.009% 99.353% ( 76, 110 ] 20 0.006% 99.358% ( 110, 170 ] 83 0.023% 99.381% ( 170, 250 ] 123 0.034% 99.416% ( 250, 380 ] 185 0.051% 99.467% ( 380, 580 ] 371 0.103% 99.570% ( 580, 870 ] 455 0.127% 99.697% ( 870, 1300 ] 418 0.116% 99.813% ( 1300, 1900 ] 255 0.071% 99.884% ( 1900, 2900 ] 224 0.062% 99.947% ( 2900, 4400 ] 225 0.063% 100.009% ( 4400, 6600 ] 68 0.019% 100.028% ( 6600, 9900 ] 13 0.004% 100.032% ( 9900, 14000 ] 1 0.000% 100.032% ** Level 2 read latency histogram (micros): Count: 518413 Average: 14.0361 StdDev: 178.89 Min: 1 Median: 1.9843 Max: 30783 Percentiles: P50: 1.98 P75: 3.06 P99: 11.64 P99.9: 1368.15 P99.99: 1876.22 ------------------------------------------------------ [ 0, 1 ] 14219 2.743% 2.743% # ( 1, 2 ] 248893 48.011% 50.753% ########## ( 2, 3 ] 122226 23.577% 74.330% ##### ( 3, 4 ] 53785 10.375% 84.705% ## ( 4, 6 ] 57003 10.996% 95.701% ## ( 6, 10 ] 16128 3.111% 98.812% # ( 10, 15 ] 2970 0.573% 99.385% ( 15, 22 ] 504 0.097% 99.482% ( 22, 34 ] 95 0.018% 99.500% ( 34, 51 ] 30 0.006% 99.506% ( 51, 76 ] 24 0.005% 99.511% ( 76, 110 ] 23 0.004% 99.515% ( 110, 170 ] 45 0.009% 99.524% ( 170, 250 ] 75 0.014% 99.538% ( 250, 380 ] 222 0.043% 99.581% ( 380, 580 ] 357 0.069% 99.650% ( 580, 870 ] 575 0.111% 99.761% ( 870, 1300 ] 658 0.127% 99.888% ( 1300, 1900 ] 551 0.106% 99.994% ( 1900, 2900 ] 446 0.086% 100.080% ( 2900, 4400 ] 421 0.081% 100.161% ( 4400, 6600 ] 151 0.029% 100.191% ( 6600, 9900 ] 18 0.003% 100.194% ( 9900, 14000 ] 1 0.000% 100.194% ( 14000, 22000 ] 1 0.000% 100.194% ( 22000, 33000 ] 1 0.000% 100.195% ** Level 3 read latency histogram (micros): Count: 2067374 Average: 9.6060 StdDev: 133.79 Min: 0 Median: 1.9589 Max: 28724 Percentiles: P50: 1.96 P75: 2.97 P99: 9.59 P99.9: 828.92 P99.99: 1253.33 ------------------------------------------------------ [ 0, 1 ] 36578 1.769% 1.769% ( 1, 2 ] 1039889 50.300% 52.069% ########## ( 2, 3 ] 489788 23.691% 75.761% ##### ( 3, 4 ] 210921 10.202% 85.963% ## ( 4, 6 ] 223399 10.806% 96.769% ## ( 6, 10 ] 51456 2.489% 99.258% ( 10, 15 ] 7489 0.362% 99.620% ( 15, 22 ] 916 0.044% 99.664% ( 22, 34 ] 107 0.005% 99.670% ( 34, 51 ] 143 0.007% 99.676% ( 51, 76 ] 204 0.010% 99.686% ( 76, 110 ] 65 0.003% 99.690% ( 110, 170 ] 249 0.012% 99.702% ( 170, 250 ] 386 0.019% 99.720% ( 250, 380 ] 673 0.033% 99.753% ( 380, 580 ] 1363 0.066% 99.819% ( 580, 870 ] 1958 0.095% 99.913% ( 870, 1300 ] 1776 0.086% 99.999% ( 1300, 1900 ] 1147 0.055% 100.055% ( 1900, 2900 ] 868 0.042% 100.097% ( 2900, 4400 ] 990 0.048% 100.145% ( 4400, 6600 ] 307 0.015% 100.160% ( 6600, 9900 ] 57 0.003% 100.162% ( 9900, 14000 ] 8 0.000% 100.163% ( 22000, 33000 ] 1 0.000% 100.163% ** Level 4 read latency histogram (micros): Count: 1378361 Average: 18.2071 StdDev: 190.99 Min: 1 Median: 1.9624 Max: 11804 Percentiles: P50: 1.96 P75: 3.00 P99: 226.73 P99.9: 1911.30 P99.99: 2807.63 ------------------------------------------------------ [ 0, 1 ] 23657 1.716% 1.716% ( 1, 2 ] 691513 50.169% 51.886% ########## ( 2, 3 ] 319665 23.192% 75.077% ##### ( 3, 4 ] 140125 10.166% 85.243% ## ( 4, 6 ] 144895 10.512% 95.755% ## ( 6, 10 ] 36487 2.647% 98.403% # ( 10, 15 ] 5179 0.376% 98.778% ( 15, 22 ] 612 0.044% 98.823% ( 22, 34 ] 74 0.005% 98.828% ( 34, 51 ] 115 0.008% 98.836% ( 51, 76 ] 161 0.012% 98.848% ( 76, 110 ] 235 0.017% 98.865% ( 110, 170 ] 1017 0.074% 98.939% ( 170, 250 ] 1188 0.086% 99.025% ( 250, 380 ] 1453 0.105% 99.130% ( 380, 580 ] 2480 0.180% 99.310% ( 580, 870 ] 3353 0.243% 99.554% ( 870, 1300 ] 3065 0.222% 99.776% ( 1300, 1900 ] 1693 0.123% 99.899% ( 1900, 2900 ] 1384 0.100% 99.999% ( 2900, 4400 ] 1351 0.098% 100.097% ( 4400, 6600 ] 415 0.030% 100.127% ( 6600, 9900 ] 71 0.005% 100.133% ( 9900, 14000 ] 5 0.000% 100.133% ** Level 5 read latency histogram (micros): Count: 55227 Average: 1048.1393 StdDev: 1155.82 Min: 77 Median: 683.6635 Max: 28861 Percentiles: P50: 683.66 P75: 1239.55 P99: 5934.59 P99.9: 9164.60 P99.99: 14954.60 ------------------------------------------------------ ( 76, 110 ] 1127 2.041% 2.041% ( 110, 170 ] 4926 8.920% 10.960% ## ( 170, 250 ] 4572 8.279% 19.239% ## ( 250, 380 ] 5150 9.325% 28.564% ## ( 380, 580 ] 8222 14.888% 43.452% ### ( 580, 870 ] 10120 18.324% 61.776% #### ( 870, 1300 ] 8499 15.389% 77.165% ### ( 1300, 1900 ] 4656 8.431% 85.596% ## ( 1900, 2900 ] 3274 5.928% 91.524% # ( 2900, 4400 ] 3315 6.002% 97.527% # ( 4400, 6600 ] 1168 2.115% 99.641% ( 6600, 9900 ] 185 0.335% 99.976% ( 9900, 14000 ] 8 0.014% 99.991% ( 14000, 22000 ] 4 0.007% 99.998% ( 22000, 33000 ] 1 0.002% 100.000% ** DB Stats ** Uptime(secs): 20.0 total, 4.9 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 147.78 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.121 H:M:S, 40.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 199.96 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:1.133 H:M:S, 23.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/28-01:52:22 ... thread 0: (1000000,4000000) ops and (291739.5,171954.6) ops/second in (3.427715,23.261960) 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/9 3.07 GB 195.1 2.7 0.0 2.7 6.5 3.7 0.0 1.7 77.4 184.7 35.80 21.88 60 0.597 2814K 3285 0.0 0.0 L1 4/4 338.16 MB 0.0 1.5 1.2 0.3 1.5 1.1 0.0 1.3 122.6 122.2 12.17 6.91 2 6.085 1514K 4362 0.0 0.0 L3 20/0 910.72 MB 0.9 6.0 2.8 3.1 5.9 2.8 0.4 2.1 110.3 109.4 55.28 28.49 27 2.048 3582K 7077 0.0 0.0 L4 173/0 9.73 GB 1.0 10.5 4.9 5.6 10.3 4.7 1.1 2.1 129.4 127.2 83.27 49.03 51 1.633 5635K 15K 0.0 0.0 L5 1157/0 95.48 GB 1.0 0.0 0.0 0.0 0.0 0.0 5.8 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1373/13 109.50 GB 0.0 20.6 8.9 11.7 24.2 12.4 7.3 6.4 113.3 132.6 186.52 106.31 140 1.332 13M 29K 0.0 0.0 Int 0/0 0.00 KB 0.0 20.6 8.9 11.7 24.2 12.4 7.3 6.4 113.3 132.6 186.52 106.31 140 1.332 13M 29K 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 20.6 8.9 11.7 20.4 8.7 0.0 0.0 128.6 127.1 164.41 95.35 89 1.847 13M 29K 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 173.8 22.11 10.97 51 0.433 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): 23.4 total, 23.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: 24.15 GB write, 1056.67 MB/s write, 20.64 GB read, 903.01 MB/s read, 186.5 seconds Interval compaction: 24.15 GB write, 1063.16 MB/s write, 20.64 GB read, 908.55 MB/s read, 186.5 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: 75, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 75, interval: 75 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1233808 Average: 10.7764 StdDev: 107.34 Min: 0 Median: 1.7527 Max: 10032 Percentiles: P50: 1.75 P75: 2.65 P99: 184.72 P99.9: 1171.68 P99.99: 2406.12 ------------------------------------------------------ [ 0, 1 ] 114897 9.312% 9.312% ## ( 1, 2 ] 666933 54.055% 63.367% ########### ( 2, 3 ] 221934 17.988% 81.355% #### ( 3, 4 ] 93119 7.547% 88.902% ## ( 4, 6 ] 90517 7.336% 96.239% # ( 6, 10 ] 19486 1.579% 97.818% ( 10, 15 ] 2993 0.243% 98.061% ( 15, 22 ] 408 0.033% 98.094% ( 22, 34 ] 60 0.005% 98.098% ( 34, 51 ] 38 0.003% 98.102% ( 51, 76 ] 49 0.004% 98.106% ( 76, 110 ] 2417 0.196% 98.301% ( 110, 170 ] 7800 0.632% 98.934% ( 170, 250 ] 4455 0.361% 99.295% ( 250, 380 ] 2480 0.201% 99.496% ( 380, 580 ] 2481 0.201% 99.697% ( 580, 870 ] 1714 0.139% 99.836% ( 870, 1300 ] 1132 0.092% 99.927% ( 1300, 1900 ] 556 0.045% 99.973% ( 1900, 2900 ] 428 0.035% 100.007% ( 2900, 4400 ] 321 0.026% 100.033% ( 4400, 6600 ] 91 0.007% 100.041% ( 6600, 9900 ] 11 0.001% 100.041% ( 9900, 14000 ] 1 0.000% 100.042% ** Level 1 read latency histogram (micros): Count: 376566 Average: 11.8894 StdDev: 148.49 Min: 1 Median: 2.0217 Max: 10828 Percentiles: P50: 2.02 P75: 3.12 P99: 13.07 P99.9: 2074.49 P99.99: 3915.62 ------------------------------------------------------ [ 0, 1 ] 5725 1.520% 1.520% ( 1, 2 ] 180580 47.954% 49.475% ########## ( 2, 3 ] 91219 24.224% 73.699% ##### ( 3, 4 ] 39897 10.595% 84.294% ## ( 4, 6 ] 43617 11.583% 95.876% ## ( 6, 10 ] 10773 2.861% 98.737% # ( 10, 15 ] 1609 0.427% 99.165% ( 15, 22 ] 257 0.068% 99.233% ( 22, 34 ] 24 0.006% 99.239% ( 34, 51 ] 23 0.006% 99.245% ( 51, 76 ] 34 0.009% 99.254% ( 76, 110 ] 78 0.021% 99.275% ( 110, 170 ] 310 0.082% 99.357% ( 170, 250 ] 230 0.061% 99.418% ( 250, 380 ] 233 0.062% 99.480% ( 380, 580 ] 399 0.106% 99.586% ( 580, 870 ] 464 0.123% 99.709% ( 870, 1300 ] 423 0.112% 99.822% ( 1300, 1900 ] 255 0.068% 99.890% ( 1900, 2900 ] 226 0.060% 99.950% ( 2900, 4400 ] 225 0.060% 100.009% ( 4400, 6600 ] 68 0.018% 100.027% ( 6600, 9900 ] 13 0.003% 100.031% ( 9900, 14000 ] 1 0.000% 100.031% ** Level 2 read latency histogram (micros): Count: 518413 Average: 14.0361 StdDev: 178.89 Min: 1 Median: 1.9843 Max: 30783 Percentiles: P50: 1.98 P75: 3.06 P99: 11.64 P99.9: 1368.15 P99.99: 1876.22 ------------------------------------------------------ [ 0, 1 ] 14219 2.743% 2.743% # ( 1, 2 ] 248893 48.011% 50.753% ########## ( 2, 3 ] 122226 23.577% 74.330% ##### ( 3, 4 ] 53785 10.375% 84.705% ## ( 4, 6 ] 57003 10.996% 95.701% ## ( 6, 10 ] 16128 3.111% 98.812% # ( 10, 15 ] 2970 0.573% 99.385% ( 15, 22 ] 504 0.097% 99.482% ( 22, 34 ] 95 0.018% 99.500% ( 34, 51 ] 30 0.006% 99.506% ( 51, 76 ] 24 0.005% 99.511% ( 76, 110 ] 23 0.004% 99.515% ( 110, 170 ] 45 0.009% 99.524% ( 170, 250 ] 75 0.014% 99.538% ( 250, 380 ] 222 0.043% 99.581% ( 380, 580 ] 357 0.069% 99.650% ( 580, 870 ] 575 0.111% 99.761% ( 870, 1300 ] 658 0.127% 99.888% ( 1300, 1900 ] 551 0.106% 99.994% ( 1900, 2900 ] 446 0.086% 100.080% ( 2900, 4400 ] 421 0.081% 100.161% ( 4400, 6600 ] 151 0.029% 100.191% ( 6600, 9900 ] 18 0.003% 100.194% ( 9900, 14000 ] 1 0.000% 100.194% ( 14000, 22000 ] 1 0.000% 100.194% ( 22000, 33000 ] 1 0.000% 100.195% ** Level 3 read latency histogram (micros): Count: 2068494 Average: 9.7096 StdDev: 133.88 Min: 0 Median: 1.9594 Max: 28724 Percentiles: P50: 1.96 P75: 2.97 P99: 9.67 P99.9: 830.17 P99.99: 1253.90 ------------------------------------------------------ [ 0, 1 ] 36578 1.768% 1.768% ( 1, 2 ] 1039889 50.273% 52.041% ########## ( 2, 3 ] 489788 23.678% 75.720% ##### ( 3, 4 ] 210921 10.197% 85.916% ## ( 4, 6 ] 223399 10.800% 96.717% ## ( 6, 10 ] 51456 2.488% 99.204% ( 10, 15 ] 7489 0.362% 99.566% ( 15, 22 ] 916 0.044% 99.610% ( 22, 34 ] 107 0.005% 99.616% ( 34, 51 ] 143 0.007% 99.623% ( 51, 76 ] 204 0.010% 99.632% ( 76, 110 ] 231 0.011% 99.644% ( 110, 170 ] 775 0.037% 99.681% ( 170, 250 ] 605 0.029% 99.710% ( 250, 380 ] 783 0.038% 99.748% ( 380, 580 ] 1430 0.069% 99.817% ( 580, 870 ] 1984 0.096% 99.913% ( 870, 1300 ] 1780 0.086% 99.999% ( 1300, 1900 ] 1148 0.055% 100.055% ( 1900, 2900 ] 869 0.042% 100.097% ( 2900, 4400 ] 990 0.048% 100.145% ( 4400, 6600 ] 307 0.015% 100.159% ( 6600, 9900 ] 57 0.003% 100.162% ( 9900, 14000 ] 8 0.000% 100.163% ( 22000, 33000 ] 1 0.000% 100.163% ** Level 4 read latency histogram (micros): Count: 1386021 Average: 19.1243 StdDev: 191.21 Min: 1 Median: 1.9678 Max: 11804 Percentiles: P50: 1.97 P75: 3.03 P99: 305.76 P99.9: 1908.63 P99.99: 2807.35 ------------------------------------------------------ [ 0, 1 ] 23657 1.707% 1.707% ( 1, 2 ] 691594 49.898% 51.605% ########## ( 2, 3 ] 319927 23.082% 74.687% ##### ( 3, 4 ] 140290 10.122% 84.809% ## ( 4, 6 ] 145096 10.469% 95.277% ## ( 6, 10 ] 36518 2.635% 97.912% # ( 10, 15 ] 5190 0.374% 98.287% ( 15, 22 ] 613 0.044% 98.331% ( 22, 34 ] 74 0.005% 98.336% ( 34, 51 ] 115 0.008% 98.344% ( 51, 76 ] 163 0.012% 98.356% ( 76, 110 ] 1218 0.088% 98.444% ( 110, 170 ] 4169 0.301% 98.745% ( 170, 250 ] 2663 0.192% 98.937% ( 250, 380 ] 2037 0.147% 99.084% ( 380, 580 ] 3006 0.217% 99.301% ( 580, 870 ] 3502 0.253% 99.553% ( 870, 1300 ] 3096 0.223% 99.777% ( 1300, 1900 ] 1695 0.122% 99.899% ( 1900, 2900 ] 1388 0.100% 99.999% ( 2900, 4400 ] 1352 0.098% 100.097% ( 4400, 6600 ] 415 0.030% 100.127% ( 6600, 9900 ] 71 0.005% 100.132% ( 9900, 14000 ] 5 0.000% 100.132% ** Level 5 read latency histogram (micros): Count: 96704 Average: 685.8016 StdDev: 973.12 Min: 71 Median: 310.5774 Max: 28861 Percentiles: P50: 310.58 P75: 794.67 P99: 5145.82 P99.9: 8353.39 P99.99: 10068.92 ------------------------------------------------------ ( 51, 76 ] 7 0.007% 0.007% ( 76, 110 ] 6883 7.118% 7.125% # ( 110, 170 ] 23981 24.798% 31.923% ##### ( 170, 250 ] 13365 13.821% 45.744% ### ( 250, 380 ] 8833 9.134% 54.878% ## ( 380, 580 ] 11278 11.662% 66.540% ## ( 580, 870 ] 11052 11.429% 77.969% ## ( 870, 1300 ] 8652 8.947% 86.916% ## ( 1300, 1900 ] 4680 4.840% 91.755% # ( 1900, 2900 ] 3291 3.403% 95.158% # ( 2900, 4400 ] 3319 3.432% 98.591% # ( 4400, 6600 ] 1168 1.208% 99.798% ( 6600, 9900 ] 185 0.191% 99.990% ( 9900, 14000 ] 8 0.008% 99.998% ( 14000, 22000 ] 4 0.004% 100.002% ( 22000, 33000 ] 1 0.001% 100.003% ** DB Stats ** Uptime(secs): 23.4 total, 3.4 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 168.19 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.121 H:M:S, 34.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 287.13 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.000 H:M:S, 0.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/28-01:52:28 ... thread 0: (1000000,5000000) ops and (181364.3,173757.6) ops/second in (5.513764,28.775724) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 15/14 3.13 GB 6.3 3.9 0.0 3.9 8.7 4.7 0.0 1.8 92.1 202.9 43.76 29.33 81 0.540 4093K 4444 0.0 0.0 L1 13/13 1.25 GB 0.0 2.7 2.1 0.6 2.7 2.1 0.0 1.3 106.8 106.3 25.98 14.48 3 8.660 2816K 10K 0.0 0.0 L3 20/0 910.72 MB 0.9 6.0 2.8 3.1 5.9 2.8 0.4 2.1 110.3 109.4 55.28 28.49 27 2.048 3582K 7077 0.0 0.0 L4 173/0 9.73 GB 1.0 10.5 4.9 5.6 10.3 4.7 1.1 2.1 129.4 127.2 83.27 49.03 51 1.633 5635K 15K 0.0 0.0 L5 1157/0 95.48 GB 1.0 0.0 0.0 0.0 0.0 0.0 5.8 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1378/27 110.48 GB 0.0 23.1 9.8 13.3 27.6 14.3 7.3 5.8 113.7 135.7 208.29 121.32 162 1.286 16M 37K 0.0 0.0 Int 0/0 0.00 KB 0.0 23.1 9.8 13.3 27.6 14.3 7.3 5.8 113.7 135.7 208.29 121.32 162 1.286 16M 37K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 23.1 9.8 13.3 22.9 9.6 0.0 0.0 129.4 128.0 183.03 107.64 95 1.927 16M 37K 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 192.1 25.26 13.69 67 0.377 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.9 total, 28.8 interval Flush(GB): cumulative 4.737, interval 4.737 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: 27.61 GB write, 977.70 MB/s write, 23.12 GB read, 818.74 MB/s read, 208.3 seconds Interval compaction: 27.61 GB write, 982.55 MB/s write, 23.12 GB read, 822.80 MB/s read, 208.3 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 8, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 8, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 75, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 8, total-stops: 75, interval: 83 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1600683 Average: 11.6121 StdDev: 98.37 Min: 0 Median: 1.7017 Max: 10032 Percentiles: P50: 1.70 P75: 2.55 P99: 211.45 P99.9: 940.25 P99.99: 1786.04 ------------------------------------------------------ [ 0, 1 ] 199486 12.463% 12.463% ## ( 1, 2 ] 856242 53.492% 65.955% ########### ( 2, 3 ] 261800 16.356% 82.310% ### ( 3, 4 ] 108513 6.779% 89.090% # ( 4, 6 ] 100381 6.271% 95.361% # ( 6, 10 ] 21907 1.369% 96.729% ( 10, 15 ] 3517 0.220% 96.949% ( 15, 22 ] 565 0.035% 96.984% ( 22, 34 ] 86 0.005% 96.990% ( 34, 51 ] 41 0.003% 96.992% ( 51, 76 ] 61 0.004% 96.996% ( 76, 110 ] 6791 0.424% 97.420% ( 110, 170 ] 20660 1.291% 98.711% ( 170, 250 ] 8928 0.558% 99.269% ( 250, 380 ] 4099 0.256% 99.525% ( 380, 580 ] 3738 0.234% 99.758% ( 580, 870 ] 2076 0.130% 99.888% ( 870, 1300 ] 1171 0.073% 99.961% ( 1300, 1900 ] 569 0.036% 99.997% ( 1900, 2900 ] 444 0.028% 100.024% ( 2900, 4400 ] 331 0.021% 100.045% ( 4400, 6600 ] 91 0.006% 100.051% ( 6600, 9900 ] 11 0.001% 100.052% ( 9900, 14000 ] 1 0.000% 100.052% ** Level 1 read latency histogram (micros): Count: 379044 Average: 12.3646 StdDev: 148.61 Min: 1 Median: 2.0314 Max: 10828 Percentiles: P50: 2.03 P75: 3.15 P99: 82.15 P99.9: 2063.52 P99.99: 3913.97 ------------------------------------------------------ [ 0, 1 ] 5745 1.516% 1.516% ( 1, 2 ] 180897 47.725% 49.240% ########## ( 2, 3 ] 91643 24.177% 73.418% ##### ( 3, 4 ] 40260 10.621% 84.039% ## ( 4, 6 ] 43866 11.573% 95.612% ## ( 6, 10 ] 10825 2.856% 98.468% # ( 10, 15 ] 1628 0.430% 98.897% ( 15, 22 ] 262 0.069% 98.966% ( 22, 34 ] 25 0.007% 98.973% ( 34, 51 ] 23 0.006% 98.979% ( 51, 76 ] 34 0.009% 98.988% ( 76, 110 ] 252 0.066% 99.054% ( 110, 170 ] 846 0.223% 99.278% ( 170, 250 ] 395 0.104% 99.382% ( 250, 380 ] 292 0.077% 99.459% ( 380, 580 ] 453 0.120% 99.578% ( 580, 870 ] 489 0.129% 99.707% ( 870, 1300 ] 432 0.114% 99.821% ( 1300, 1900 ] 261 0.069% 99.890% ( 1900, 2900 ] 226 0.060% 99.950% ( 2900, 4400 ] 225 0.059% 100.009% ( 4400, 6600 ] 68 0.018% 100.027% ( 6600, 9900 ] 13 0.003% 100.031% ( 9900, 14000 ] 1 0.000% 100.031% ** Level 2 read latency histogram (micros): Count: 518413 Average: 14.0361 StdDev: 178.89 Min: 1 Median: 1.9843 Max: 30783 Percentiles: P50: 1.98 P75: 3.06 P99: 11.64 P99.9: 1368.15 P99.99: 1876.22 ------------------------------------------------------ [ 0, 1 ] 14219 2.743% 2.743% # ( 1, 2 ] 248893 48.011% 50.753% ########## ( 2, 3 ] 122226 23.577% 74.330% ##### ( 3, 4 ] 53785 10.375% 84.705% ## ( 4, 6 ] 57003 10.996% 95.701% ## ( 6, 10 ] 16128 3.111% 98.812% # ( 10, 15 ] 2970 0.573% 99.385% ( 15, 22 ] 504 0.097% 99.482% ( 22, 34 ] 95 0.018% 99.500% ( 34, 51 ] 30 0.006% 99.506% ( 51, 76 ] 24 0.005% 99.511% ( 76, 110 ] 23 0.004% 99.515% ( 110, 170 ] 45 0.009% 99.524% ( 170, 250 ] 75 0.014% 99.538% ( 250, 380 ] 222 0.043% 99.581% ( 380, 580 ] 357 0.069% 99.650% ( 580, 870 ] 575 0.111% 99.761% ( 870, 1300 ] 658 0.127% 99.888% ( 1300, 1900 ] 551 0.106% 99.994% ( 1900, 2900 ] 446 0.086% 100.080% ( 2900, 4400 ] 421 0.081% 100.161% ( 4400, 6600 ] 151 0.029% 100.191% ( 6600, 9900 ] 18 0.003% 100.194% ( 9900, 14000 ] 1 0.000% 100.194% ( 14000, 22000 ] 1 0.000% 100.194% ( 22000, 33000 ] 1 0.000% 100.195% ** Level 3 read latency histogram (micros): Count: 2070536 Average: 9.8810 StdDev: 133.98 Min: 0 Median: 1.9604 Max: 28724 Percentiles: P50: 1.96 P75: 2.97 P99: 9.83 P99.9: 831.73 P99.99: 1254.91 ------------------------------------------------------ [ 0, 1 ] 36578 1.767% 1.767% ( 1, 2 ] 1039889 50.223% 51.990% ########## ( 2, 3 ] 489788 23.655% 75.645% ##### ( 3, 4 ] 210921 10.187% 85.832% ## ( 4, 6 ] 223399 10.789% 96.621% ## ( 6, 10 ] 51456 2.485% 99.106% ( 10, 15 ] 7489 0.362% 99.468% ( 15, 22 ] 916 0.044% 99.512% ( 22, 34 ] 107 0.005% 99.517% ( 34, 51 ] 143 0.007% 99.524% ( 51, 76 ] 204 0.010% 99.534% ( 76, 110 ] 579 0.028% 99.562% ( 110, 170 ] 1841 0.089% 99.651% ( 170, 250 ] 950 0.046% 99.697% ( 250, 380 ] 928 0.045% 99.742% ( 380, 580 ] 1524 0.074% 99.815% ( 580, 870 ] 2020 0.098% 99.913% ( 870, 1300 ] 1784 0.086% 99.999% ( 1300, 1900 ] 1151 0.056% 100.055% ( 1900, 2900 ] 870 0.042% 100.097% ( 2900, 4400 ] 990 0.048% 100.144% ( 4400, 6600 ] 307 0.015% 100.159% ( 6600, 9900 ] 57 0.003% 100.162% ( 9900, 14000 ] 8 0.000% 100.162% ( 22000, 33000 ] 1 0.000% 100.162% ** Level 4 read latency histogram (micros): Count: 1399768 Average: 20.6695 StdDev: 191.32 Min: 1 Median: 1.9777 Max: 11804 Percentiles: P50: 1.98 P75: 3.10 P99: 362.71 P99.9: 1904.47 P99.99: 2808.19 ------------------------------------------------------ [ 0, 1 ] 23657 1.690% 1.690% ( 1, 2 ] 691619 49.410% 51.100% ########## ( 2, 3 ] 319998 22.861% 73.960% ##### ( 3, 4 ] 140342 10.026% 83.986% ## ( 4, 6 ] 145201 10.373% 94.360% ## ( 6, 10 ] 36525 2.609% 96.969% # ( 10, 15 ] 5194 0.371% 97.340% ( 15, 22 ] 613 0.044% 97.384% ( 22, 34 ] 75 0.005% 97.389% ( 34, 51 ] 115 0.008% 97.397% ( 51, 76 ] 164 0.012% 97.409% ( 76, 110 ] 3724 0.266% 97.675% ( 110, 170 ] 11131 0.795% 98.470% ( 170, 250 ] 4912 0.351% 98.821% ( 250, 380 ] 2885 0.206% 99.027% ( 380, 580 ] 3687 0.263% 99.291% ( 580, 870 ] 3699 0.264% 99.555% ( 870, 1300 ] 3125 0.223% 99.778% ( 1300, 1900 ] 1697 0.121% 99.900% ( 1900, 2900 ] 1394 0.100% 99.999% ( 2900, 4400 ] 1354 0.097% 100.096% ( 4400, 6600 ] 415 0.030% 100.126% ( 6600, 9900 ] 71 0.005% 100.131% ( 9900, 14000 ] 5 0.000% 100.131% ** Level 5 read latency histogram (micros): Count: 169662 Average: 468.5265 StdDev: 780.64 Min: 71 Median: 178.6460 Max: 28861 Percentiles: P50: 178.65 P75: 462.75 P99: 4248.55 P99.9: 7016.30 P99.99: 9740.06 ------------------------------------------------------ ( 51, 76 ] 17 0.010% 0.010% ( 76, 110 ] 19772 11.654% 11.664% ## ( 110, 170 ] 62278 36.707% 48.371% ####### ( 170, 250 ] 25584 15.079% 63.450% ### ( 250, 380 ] 13410 7.904% 71.354% ## ( 380, 580 ] 14952 8.813% 80.167% ## ( 580, 870 ] 12138 7.154% 87.321% # ( 870, 1300 ] 8791 5.181% 92.503% # ( 1300, 1900 ] 4712 2.777% 95.280% # ( 1900, 2900 ] 3324 1.959% 97.239% ( 2900, 4400 ] 3324 1.959% 99.198% ( 4400, 6600 ] 1168 0.688% 99.887% ( 6600, 9900 ] 185 0.109% 99.996% ( 9900, 14000 ] 8 0.005% 100.001% ( 14000, 22000 ] 4 0.002% 100.003% ( 22000, 33000 ] 1 0.001% 100.004% ** DB Stats ** Uptime(secs): 28.9 total, 5.5 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 170.16 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.066 H:M:S, 34.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 178.50 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.945 H:M:S, 35.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/11/28-01:52:36 ... thread 0: (1000000,6000000) ops and (121664.1,162183.8) ops/second in (8.219350,36.995074) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 18/14 4.05 GB 100.5 5.5 0.0 5.5 11.1 5.7 0.0 2.0 106.4 216.2 52.70 37.77 100 0.527 5692K 7673 0.0 0.0 L1 13/13 1.25 GB 0.0 2.7 2.1 0.6 2.7 2.1 0.0 1.3 106.8 106.3 25.98 14.48 3 8.660 2816K 10K 0.0 0.0 L3 20/0 910.72 MB 0.9 6.0 2.8 3.1 5.9 2.8 0.4 2.1 110.3 109.4 55.28 28.49 27 2.048 3582K 7077 0.0 0.0 L4 173/0 9.73 GB 1.0 10.5 4.9 5.6 10.3 4.7 1.1 2.1 129.4 127.2 83.27 49.03 51 1.633 5635K 15K 0.0 0.0 L5 1157/0 95.48 GB 1.0 0.0 0.0 0.0 0.0 0.0 5.8 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1381/27 111.40 GB 0.0 24.7 9.8 14.8 30.1 15.2 7.3 5.3 116.2 141.7 217.23 129.77 181 1.200 17M 40K 0.0 0.0 Int 0/0 0.00 KB 0.0 24.7 9.8 14.8 30.1 15.2 7.3 5.3 116.2 141.7 217.23 129.77 181 1.200 17M 40K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 24.7 9.8 14.8 24.4 9.6 0.0 0.0 133.6 132.3 188.98 113.50 99 1.909 17M 40K 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 205.2 28.24 16.27 82 0.344 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): 37.1 total, 37.0 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: 30.07 GB write, 829.07 MB/s write, 24.66 GB read, 679.93 MB/s read, 217.2 seconds Interval compaction: 30.07 GB write, 832.27 MB/s write, 24.66 GB read, 682.56 MB/s read, 217.2 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: 75, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 18, total-stops: 75, interval: 93 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2112168 Average: 12.6549 StdDev: 90.60 Min: 0 Median: 1.6549 Max: 10032 Percentiles: P50: 1.65 P75: 2.47 P99: 223.08 P99.9: 798.34 P99.99: 1366.56 ------------------------------------------------------ [ 0, 1 ] 327919 15.525% 15.525% ### ( 1, 2 ] 1111868 52.641% 68.166% ########### ( 2, 3 ] 306954 14.533% 82.699% ### ( 3, 4 ] 135738 6.426% 89.125% # ( 4, 6 ] 111920 5.299% 94.424% # ( 6, 10 ] 24004 1.136% 95.561% ( 10, 15 ] 4128 0.195% 95.756% ( 15, 22 ] 648 0.031% 95.787% ( 22, 34 ] 90 0.004% 95.791% ( 34, 51 ] 41 0.002% 95.793% ( 51, 76 ] 71 0.003% 95.796% ( 76, 110 ] 13481 0.638% 96.435% ( 110, 170 ] 43406 2.055% 98.490% ( 170, 250 ] 16245 0.769% 99.259% ( 250, 380 ] 6284 0.298% 99.556% ( 380, 580 ] 5363 0.254% 99.810% ( 580, 870 ] 2518 0.119% 99.929% ( 870, 1300 ] 1215 0.058% 99.987% ( 1300, 1900 ] 575 0.027% 100.014% ( 1900, 2900 ] 478 0.023% 100.037% ( 2900, 4400 ] 345 0.016% 100.053% ( 4400, 6600 ] 91 0.004% 100.057% ( 6600, 9900 ] 11 0.001% 100.058% ( 9900, 14000 ] 1 0.000% 100.058% ** Level 1 read latency histogram (micros): Count: 408373 Average: 12.7918 StdDev: 144.04 Min: 1 Median: 2.1175 Max: 10828 Percentiles: P50: 2.12 P75: 3.35 P99: 150.35 P99.9: 1933.60 P99.99: 3883.38 ------------------------------------------------------ [ 0, 1 ] 6429 1.574% 1.574% ( 1, 2 ] 186301 45.620% 47.195% ######### ( 2, 3 ] 97492 23.873% 71.068% ##### ( 3, 4 ] 45899 11.239% 82.307% ## ( 4, 6 ] 51168 12.530% 94.837% ### ( 6, 10 ] 12220 2.992% 97.829% # ( 10, 15 ] 1919 0.470% 98.299% ( 15, 22 ] 441 0.108% 98.407% ( 22, 34 ] 41 0.010% 98.417% ( 34, 51 ] 23 0.006% 98.423% ( 51, 76 ] 34 0.008% 98.431% ( 76, 110 ] 810 0.198% 98.630% ( 110, 170 ] 2249 0.551% 99.180% ( 170, 250 ] 758 0.186% 99.366% ( 250, 380 ] 414 0.101% 99.467% ( 380, 580 ] 539 0.132% 99.599% ( 580, 870 ] 524 0.128% 99.728% ( 870, 1300 ] 435 0.107% 99.834% ( 1300, 1900 ] 261 0.064% 99.898% ( 1900, 2900 ] 227 0.056% 99.954% ( 2900, 4400 ] 226 0.055% 100.009% ( 4400, 6600 ] 68 0.017% 100.026% ( 6600, 9900 ] 13 0.003% 100.029% ( 9900, 14000 ] 1 0.000% 100.029% ** Level 2 read latency histogram (micros): Count: 518413 Average: 14.0361 StdDev: 178.89 Min: 1 Median: 1.9843 Max: 30783 Percentiles: P50: 1.98 P75: 3.06 P99: 11.64 P99.9: 1368.15 P99.99: 1876.22 ------------------------------------------------------ [ 0, 1 ] 14219 2.743% 2.743% # ( 1, 2 ] 248893 48.011% 50.753% ########## ( 2, 3 ] 122226 23.577% 74.330% ##### ( 3, 4 ] 53785 10.375% 84.705% ## ( 4, 6 ] 57003 10.996% 95.701% ## ( 6, 10 ] 16128 3.111% 98.812% # ( 10, 15 ] 2970 0.573% 99.385% ( 15, 22 ] 504 0.097% 99.482% ( 22, 34 ] 95 0.018% 99.500% ( 34, 51 ] 30 0.006% 99.506% ( 51, 76 ] 24 0.005% 99.511% ( 76, 110 ] 23 0.004% 99.515% ( 110, 170 ] 45 0.009% 99.524% ( 170, 250 ] 75 0.014% 99.538% ( 250, 380 ] 222 0.043% 99.581% ( 380, 580 ] 357 0.069% 99.650% ( 580, 870 ] 575 0.111% 99.761% ( 870, 1300 ] 658 0.127% 99.888% ( 1300, 1900 ] 551 0.106% 99.994% ( 1900, 2900 ] 446 0.086% 100.080% ( 2900, 4400 ] 421 0.081% 100.161% ( 4400, 6600 ] 151 0.029% 100.191% ( 6600, 9900 ] 18 0.003% 100.194% ( 9900, 14000 ] 1 0.000% 100.194% ( 14000, 22000 ] 1 0.000% 100.194% ( 22000, 33000 ] 1 0.000% 100.195% ** Level 3 read latency histogram (micros): Count: 2073831 Average: 10.1334 StdDev: 134.11 Min: 0 Median: 1.9620 Max: 28724 Percentiles: P50: 1.96 P75: 2.98 P99: 10.71 P99.9: 833.55 P99.99: 1255.95 ------------------------------------------------------ [ 0, 1 ] 36578 1.764% 1.764% ( 1, 2 ] 1039889 50.143% 51.907% ########## ( 2, 3 ] 489788 23.618% 75.525% ##### ( 3, 4 ] 210921 10.171% 85.695% ## ( 4, 6 ] 223399 10.772% 96.468% ## ( 6, 10 ] 51456 2.481% 98.949% ( 10, 15 ] 7489 0.361% 99.310% ( 15, 22 ] 916 0.044% 99.354% ( 22, 34 ] 107 0.005% 99.359% ( 34, 51 ] 143 0.007% 99.366% ( 51, 76 ] 204 0.010% 99.376% ( 76, 110 ] 1260 0.061% 99.437% ( 110, 170 ] 3613 0.174% 99.611% ( 170, 250 ] 1483 0.072% 99.682% ( 250, 380 ] 1089 0.053% 99.735% ( 380, 580 ] 1615 0.078% 99.813% ( 580, 870 ] 2067 0.100% 99.913% ( 870, 1300 ] 1790 0.086% 99.999% ( 1300, 1900 ] 1153 0.056% 100.054% ( 1900, 2900 ] 872 0.042% 100.096% ( 2900, 4400 ] 990 0.048% 100.144% ( 4400, 6600 ] 307 0.015% 100.159% ( 6600, 9900 ] 57 0.003% 100.162% ( 9900, 14000 ] 8 0.000% 100.162% ( 22000, 33000 ] 1 0.000% 100.162% ** Level 4 read latency histogram (micros): Count: 1422415 Average: 22.9592 StdDev: 191.10 Min: 1 Median: 1.9941 Max: 11804 Percentiles: P50: 1.99 P75: 3.22 P99: 398.75 P99.9: 1896.33 P99.99: 2807.62 ------------------------------------------------------ [ 0, 1 ] 23657 1.663% 1.663% ( 1, 2 ] 691619 48.623% 50.286% ########## ( 2, 3 ] 319998 22.497% 72.783% #### ( 3, 4 ] 140342 9.866% 82.649% ## ( 4, 6 ] 145201 10.208% 92.857% ## ( 6, 10 ] 36525 2.568% 95.425% # ( 10, 15 ] 5194 0.365% 95.790% ( 15, 22 ] 613 0.043% 95.833% ( 22, 34 ] 75 0.005% 95.839% ( 34, 51 ] 115 0.008% 95.847% ( 51, 76 ] 168 0.012% 95.859% ( 76, 110 ] 8421 0.592% 96.451% ( 110, 170 ] 23694 1.666% 98.116% ( 170, 250 ] 8257 0.580% 98.697% ( 250, 380 ] 3889 0.273% 98.970% ( 380, 580 ] 4510 0.317% 99.287% ( 580, 870 ] 3871 0.272% 99.559% ( 870, 1300 ] 3152 0.222% 99.781% ( 1300, 1900 ] 1702 0.120% 99.901% ( 1900, 2900 ] 1399 0.098% 99.999% ( 2900, 4400 ] 1355 0.095% 100.094% ( 4400, 6600 ] 415 0.029% 100.124% ( 6600, 9900 ] 71 0.005% 100.129% ( 9900, 14000 ] 5 0.000% 100.129% ** Level 5 read latency histogram (micros): Count: 292154 Average: 341.2328 StdDev: 617.32 Min: 71 Median: 156.5270 Max: 28861 Percentiles: P50: 156.53 P75: 251.21 P99: 3693.26 P99.9: 6400.05 P99.99: 9396.70 ------------------------------------------------------ ( 51, 76 ] 61 0.021% 0.021% ( 76, 110 ] 45240 15.485% 15.506% ### ( 110, 170 ] 129958 44.483% 59.989% ######### ( 170, 250 ] 43680 14.951% 74.940% ### ( 250, 380 ] 18951 6.487% 81.426% # ( 380, 580 ] 19396 6.639% 88.065% # ( 580, 870 ] 13165 4.506% 92.571% # ( 870, 1300 ] 8912 3.050% 95.622% # ( 1300, 1900 ] 4741 1.623% 97.245% ( 1900, 2900 ] 3369 1.153% 98.398% ( 2900, 4400 ] 3327 1.139% 99.537% ( 4400, 6600 ] 1168 0.400% 99.936% ( 6600, 9900 ] 185 0.063% 100.000% ( 9900, 14000 ] 8 0.003% 100.002% ( 14000, 22000 ] 4 0.001% 100.004% ( 22000, 33000 ] 1 0.000% 100.004% ** DB Stats ** Uptime(secs): 37.1 total, 8.2 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 159.00 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:14.533 H:M:S, 39.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 119.74 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:4.467 H:M:S, 54.3 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] readwhilewriting : 282.298 micros/op 14163 ops/sec 60.155 seconds 851996 operations; 13.7 MB/s (208999 of 208999 found) Microseconds per read: Count: 851996 Average: 282.3002 StdDev: 790.34 Min: 2 Median: 182.1329 Max: 85450 Percentiles: P50: 182.13 P75: 241.80 P99: 2105.24 P99.9: 12205.19 P99.99: 30540.31 ------------------------------------------------------ ( 1, 2 ] 7 0.001% 0.001% ( 2, 3 ] 35 0.004% 0.005% ( 3, 4 ] 40 0.005% 0.010% ( 4, 6 ] 94 0.011% 0.021% ( 6, 10 ] 284 0.033% 0.054% ( 10, 15 ] 2955 0.347% 0.401% ( 15, 22 ] 3919 0.460% 0.861% ( 22, 34 ] 9309 1.093% 1.953% ( 34, 51 ] 2859 0.336% 2.289% ( 51, 76 ] 409 0.048% 2.337% ( 76, 110 ] 13170 1.546% 3.883% ( 110, 170 ] 349602 41.033% 44.916% ######## ( 170, 250 ] 285604 33.522% 78.438% ####### ( 250, 380 ] 94660 11.110% 89.548% ## ( 380, 580 ] 41883 4.916% 94.464% # ( 580, 870 ] 20754 2.436% 96.900% ( 870, 1300 ] 11599 1.361% 98.261% ( 1300, 1900 ] 5547 0.651% 98.912% ( 1900, 2900 ] 3635 0.427% 99.339% ( 2900, 4400 ] 3081 0.362% 99.701% ( 4400, 6600 ] 1051 0.123% 99.824% ( 6600, 9900 ] 385 0.045% 99.869% ( 9900, 14000 ] 466 0.055% 99.924% ( 14000, 22000 ] 451 0.053% 99.977% ( 22000, 33000 ] 144 0.017% 99.994% ( 33000, 50000 ] 41 0.005% 99.999% ( 50000, 75000 ] 11 0.001% 100.000% ( 75000, 110000 ] 1 0.000% 100.000% STATISTICS: rocksdb.block.cache.miss COUNT : 0 rocksdb.block.cache.hit COUNT : 0 rocksdb.block.cache.add COUNT : 0 rocksdb.block.cache.add.failures COUNT : 0 rocksdb.block.cache.index.miss COUNT : 0 rocksdb.block.cache.index.hit COUNT : 0 rocksdb.block.cache.index.add COUNT : 0 rocksdb.block.cache.index.bytes.insert COUNT : 0 rocksdb.block.cache.filter.miss COUNT : 0 rocksdb.block.cache.filter.hit COUNT : 0 rocksdb.block.cache.filter.add COUNT : 0 rocksdb.block.cache.filter.bytes.insert COUNT : 0 rocksdb.block.cache.data.miss COUNT : 0 rocksdb.block.cache.data.hit COUNT : 0 rocksdb.block.cache.data.add COUNT : 0 rocksdb.block.cache.data.bytes.insert COUNT : 0 rocksdb.block.cache.bytes.read COUNT : 0 rocksdb.block.cache.bytes.write COUNT : 0 rocksdb.bloom.filter.useful COUNT : 16329790 rocksdb.bloom.filter.full.positive COUNT : 1009676 rocksdb.bloom.filter.full.true.positive COUNT : 851553 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 : 443 rocksdb.memtable.miss COUNT : 851553 rocksdb.l0.hit COUNT : 33293 rocksdb.l1.hit COUNT : 8735 rocksdb.l2andup.hit COUNT : 809525 rocksdb.compaction.key.drop.new COUNT : 286363 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 : 6300789 rocksdb.number.keys.read COUNT : 851996 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 6502414248 rocksdb.bytes.read COUNT : 851996000 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 : 1740 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 36248376 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 : 28411537475 rocksdb.compact.write.bytes COUNT : 28119484115 rocksdb.flush.write.bytes COUNT : 6473572449 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 : 24 rocksdb.number.superversion_acquires COUNT : 1284 rocksdb.number.superversion_releases COUNT : 1242 rocksdb.number.superversion_cleanups COUNT : 320 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 : 335 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 : 6421374976 rocksdb.memtable.garbage.bytes.at.flush COUNT : 2499584 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 : 32860079082 rocksdb.non.last.level.read.count COUNT : 7798011 rocksdb.block.checksum.compute.count COUNT : 7903802 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 : 180.671379 P95 : 642.248899 P99 : 2104.193726 P100 : 85447.000000 COUNT : 851996 SUM : 239748986 rocksdb.db.write.micros P50 : 1.534053 P95 : 4.103873 P99 : 8.078270 P100 : 1006456.000000 COUNT : 6300789 SUM : 51903140 rocksdb.compaction.times.micros P50 : 1508823.529412 P95 : 4090000.000000 P99 : 6492666.666667 P100 : 13809121.000000 COUNT : 101 SUM : 190842581 rocksdb.compaction.times.cpu_micros P50 : 975600.000000 P95 : 2637500.000000 P99 : 4295333.333333 P100 : 7565896.000000 COUNT : 101 SUM : 115323307 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 : 822.790698 P95 : 48300.000000 P99 : 214800.000000 P100 : 244388.000000 COUNT : 88 SUM : 1110361 rocksdb.compaction.outfile.sync.micros P50 : 24275.862069 P95 : 246266.666667 P99 : 555342.857143 P100 : 656167.000000 COUNT : 354 SUM : 23149349 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 : 546.666667 P95 : 4028.571429 P99 : 6054.400000 P100 : 7091.000000 COUNT : 224 SUM : 258048 rocksdb.table.open.io.micros P50 : 8416.330645 P95 : 19621.621622 P99 : 24084.210526 P100 : 46796.000000 COUNT : 1740 SUM : 14893795 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 : 4.000902 P95 : 9.854495 P99 : 165.197921 P100 : 30789.000000 COUNT : 6881581 SUM : 98359067 rocksdb.read.block.get.micros P50 : 140.119861 P95 : 528.242081 P99 : 1852.180755 P100 : 28729.000000 COUNT : 1020474 SUM : 205923638 rocksdb.write.raw.block.micros P50 : 0.529956 P95 : 1.175067 P99 : 3.434905 P100 : 35428.000000 COUNT : 8378880 SUM : 26047035 rocksdb.numfiles.in.singlecompaction P50 : 3.080357 P95 : 5.845455 P99 : 13.150000 P100 : 27.000000 COUNT : 137 SUM : 493 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.576544 P95 : 1932.060046 P99 : 2708.556494 P100 : 1006289.000000 COUNT : 144836 SUM : 36260230 rocksdb.sst.read.micros P50 : 2.033362 P95 : 158.180504 P99 : 510.326509 P100 : 30783.000000 COUNT : 7798037 SUM : 285153019 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 : 1000.000000 P95 : 1000.000000 P99 : 1000.000000 P100 : 1000.000000 COUNT : 851996 SUM : 851996000 rocksdb.bytes.per.write P50 : 1032.000000 P95 : 1032.000000 P99 : 1032.000000 P100 : 1032.000000 COUNT : 6300789 SUM : 6502414248 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 : 227704.918033 P95 : 968800.000000 P99 : 1256374.000000 P100 : 1256374.000000 COUNT : 88 SUM : 29447498 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 : 362 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