[2024-11-21 00:17:41.404109] Starting SPDK v24.01.1-pre git sha1 c13c99a5e / DPDK 23.11.0 initialization... [2024-11-21 00:17:41.404374] [ DPDK EAL parameters: rocksdb --no-shconf -c 0x1 --huge-unlink --no-telemetry --log-level=lib.eal:6 --log-level=lib.cryptodev:5 --log-level=user1:6 --base-virtaddr=0x200000000000 --match-allocations --file-prefix=spdk_pid890239 ] Set seed to 1732144661397416 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-11-21 00:17:41.517875] app.c: 798:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-11-21 00:17:41.558452] app.c: 488:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-11-21 00:17:41.558499] app.c: 489:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 890239' to capture a snapshot of events at runtime. [2024-11-21 00:17:41.558529] app.c: 494:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid890239 for offline analysis/debug. [2024-11-21 00:17:41.558555] reactor.c: 937:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Thu Nov 21 00:17:45 2024 CPU: 96 * Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz CPUCache: 36608 KB 2024/11/21-00:17:48 ... thread 0: (1000000,1000000) ops and (332412.1,332412.1) ops/second in (3.008314,3.008314) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 9/6 629.94 MB 25.2 0.0 0.0 0.0 0.9 0.9 0.0 1.0 0.0 348.7 2.53 2.29 12 0.211 0 0 0.0 0.0 L2 3/2 251.75 MB 0.0 0.4 0.2 0.2 0.4 0.2 0.2 2.0 251.1 250.9 1.51 1.45 2 0.753 383K 209 0.0 0.0 L3 9/0 741.42 MB 0.7 0.0 0.0 0.0 0.0 0.0 0.1 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 116/0 9.54 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1044/0 85.88 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1181/8 97.00 GB 0.0 0.4 0.2 0.2 1.2 1.0 0.3 1.4 93.7 312.2 4.03 3.74 14 0.288 383K 209 0.0 0.0 Int 0/0 0.00 KB 0.0 0.4 0.2 0.2 1.2 1.0 0.2 1.4 93.7 312.2 4.03 3.74 14 0.288 383K 209 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 0.0 0.0 251.1 250.9 1.51 1.45 2 0.753 383K 209 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 0.9 0.9 0.0 0.0 0.0 348.7 2.53 2.29 12 0.211 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 3.2 total, 3.0 interval Flush(GB): cumulative 0.861, interval 0.861 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 1.23 GB write, 393.44 MB/s write, 0.37 GB read, 118.05 MB/s read, 4.0 seconds Interval compaction: 1.23 GB write, 418.50 MB/s write, 0.37 GB read, 125.57 MB/s read, 4.0 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: 114704 Average: 1.9251 StdDev: 20.48 Min: 1 Median: 1.2245 Max: 3272 Percentiles: P50: 1.22 P75: 1.66 P99: 3.96 P99.9: 9.93 P99.99: 315.77 ------------------------------------------------------ [ 0, 1 ] 42726 37.249% 37.249% ####### ( 1, 2 ] 65149 56.797% 94.046% ########### ( 2, 3 ] 4099 3.574% 97.620% # ( 3, 4 ] 1645 1.434% 99.054% ( 4, 6 ] 699 0.609% 99.663% ( 6, 10 ] 279 0.243% 99.907% ( 10, 15 ] 64 0.056% 99.963% ( 15, 22 ] 18 0.016% 99.978% ( 22, 34 ] 2 0.002% 99.980% ( 34, 51 ] 1 0.001% 99.981% ( 51, 76 ] 1 0.001% 99.982% ( 110, 170 ] 9 0.008% 99.990% ( 170, 250 ] 1 0.001% 99.990% ( 250, 380 ] 5 0.004% 99.995% ( 580, 870 ] 2 0.002% 99.997% ( 870, 1300 ] 1 0.001% 99.997% ( 1300, 1900 ] 1 0.001% 99.998% ( 1900, 2900 ] 3 0.003% 100.001% ( 2900, 4400 ] 2 0.002% 100.003% ** Level 1 read latency histogram (micros): Count: 5 Average: 1398.4000 StdDev: 1328.54 Min: 125 Median: 480.0000 Max: 3216 Percentiles: P50: 480.00 P75: 2650.00 P99: 3216.00 P99.9: 3216.00 P99.99: 3216.00 ------------------------------------------------------ ( 110, 170 ] 1 20.000% 20.000% #### ( 250, 380 ] 1 20.000% 40.000% #### ( 380, 580 ] 1 20.000% 60.000% #### ( 1900, 2900 ] 1 20.000% 80.000% #### ( 2900, 4400 ] 1 20.000% 100.000% #### ** Level 2 read latency histogram (micros): Count: 60500 Average: 1.8731 StdDev: 7.90 Min: 0 Median: 1.2641 Max: 1177 Percentiles: P50: 1.26 P75: 1.70 P99: 5.10 P99.9: 11.06 P99.99: 74.75 ------------------------------------------------------ [ 0, 1 ] 20990 34.694% 34.694% ####### ( 1, 2 ] 35063 57.955% 92.650% ############ ( 2, 3 ] 2286 3.779% 96.428% # ( 3, 4 ] 1220 2.017% 98.445% ( 4, 6 ] 611 1.010% 99.455% ( 6, 10 ] 259 0.428% 99.883% ( 10, 15 ] 54 0.089% 99.972% ( 15, 22 ] 9 0.015% 99.987% ( 22, 34 ] 2 0.003% 99.990% ( 51, 76 ] 1 0.002% 99.992% ( 380, 580 ] 3 0.005% 99.997% ( 870, 1300 ] 3 0.005% 100.002% ** Level 3 read latency histogram (micros): Count: 40 Average: 1447.0500 StdDev: 1284.94 Min: 116 Median: 817.2727 Max: 4401 Percentiles: P50: 817.27 P75: 2300.00 P99: 4401.00 P99.9: 4401.00 P99.99: 4401.00 ------------------------------------------------------ ( 110, 170 ] 4 10.000% 10.000% ## ( 170, 250 ] 2 5.000% 15.000% # ( 250, 380 ] 1 2.500% 17.500% # ( 380, 580 ] 4 10.000% 27.500% ## ( 580, 870 ] 11 27.500% 55.000% ###### ( 870, 1300 ] 2 5.000% 60.000% # ( 1300, 1900 ] 4 10.000% 70.000% ## ( 1900, 2900 ] 5 12.500% 82.500% ### ( 2900, 4400 ] 6 15.000% 97.500% ### ( 4400, 6600 ] 1 2.500% 100.000% # ** Level 4 read latency histogram (micros): Count: 35 Average: 1979.2286 StdDev: 1565.44 Min: 165 Median: 1375.0000 Max: 5321 Percentiles: P50: 1375.00 P75: 3134.38 P99: 5321.00 P99.9: 5321.00 P99.99: 5321.00 ------------------------------------------------------ ( 110, 170 ] 1 2.857% 2.857% # ( 170, 250 ] 1 2.857% 5.714% # ( 250, 380 ] 1 2.857% 8.571% # ( 380, 580 ] 1 2.857% 11.429% # ( 580, 870 ] 10 28.571% 40.000% ###### ( 870, 1300 ] 3 8.571% 48.571% ## ( 1300, 1900 ] 4 11.429% 60.000% ## ( 1900, 2900 ] 4 11.429% 71.429% ## ( 2900, 4400 ] 8 22.857% 94.286% ##### ( 4400, 6600 ] 2 5.714% 100.000% # ** DB Stats ** Uptime(secs): 3.2 total, 3.0 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 307.38 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.403 H:M:S, 12.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 326.89 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.403 H:M:S, 13.4 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/21-00:17:51 ... thread 0: (1000000,2000000) ops and (347939.0,339998.4) ops/second in (2.874067,5.882381) 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/9 1.17 GB 12.6 0.6 0.0 0.6 2.3 1.8 0.0 1.3 76.4 322.3 7.42 6.82 28 0.265 575K 631 0.0 0.0 L1 1/1 2.87 MB 0.0 0.4 0.4 0.0 0.4 0.4 0.2 1.0 240.5 240.0 1.57 1.52 1 1.572 383K 613 0.0 0.0 L2 2/0 54.29 MB 0.5 0.4 0.2 0.2 0.4 0.2 0.5 2.0 251.1 250.9 1.51 1.45 2 0.753 383K 209 0.0 0.0 L3 38/0 961.72 MB 1.0 0.8 0.6 0.2 0.8 0.6 0.1 1.4 203.8 203.6 3.91 3.44 3 1.304 809K 784 0.0 0.0 L4 148/0 9.57 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1048/0 86.19 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1248/10 97.92 GB 0.0 2.1 1.1 1.0 3.9 2.9 1.5 2.2 147.1 273.7 14.41 13.23 34 0.424 2152K 2237 0.0 0.0 Int 0/0 0.00 KB 0.0 2.1 1.1 1.0 3.9 2.9 1.4 2.2 147.1 273.7 14.41 13.23 34 0.424 2152K 2237 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 2.1 1.1 1.0 2.1 1.1 0.0 0.0 231.3 231.1 9.16 8.54 8 1.146 2152K 2237 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 348.1 5.25 4.69 26 0.202 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 6.1 total, 5.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: 3.85 GB write, 649.24 MB/s write, 2.07 GB read, 348.93 MB/s read, 14.4 seconds Interval compaction: 3.85 GB write, 670.39 MB/s write, 2.07 GB read, 360.30 MB/s read, 14.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: 6, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 6, interval: 6 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 392212 Average: 2.1453 StdDev: 13.74 Min: 1 Median: 1.4355 Max: 3272 Percentiles: P50: 1.44 P75: 1.84 P99: 5.61 P99.9: 9.93 P99.99: 18.15 ------------------------------------------------------ [ 0, 1 ] 89447 22.806% 22.806% ##### ( 1, 2 ] 244937 62.450% 85.256% ############ ( 2, 3 ] 31592 8.055% 93.311% ## ( 3, 4 ] 14719 3.753% 97.064% # ( 4, 6 ] 9436 2.406% 99.469% ( 6, 10 ] 1717 0.438% 99.907% ( 10, 15 ] 305 0.078% 99.985% ( 15, 22 ] 44 0.011% 99.996% ( 22, 34 ] 14 0.004% 100.000% ( 34, 51 ] 2 0.001% 100.000% ( 51, 76 ] 3 0.001% 100.001% ( 110, 170 ] 15 0.004% 100.005% ( 170, 250 ] 9 0.002% 100.007% ( 250, 380 ] 10 0.003% 100.010% ( 380, 580 ] 2 0.001% 100.010% ( 580, 870 ] 7 0.002% 100.012% ( 870, 1300 ] 5 0.001% 100.013% ( 1300, 1900 ] 2 0.001% 100.014% ( 1900, 2900 ] 4 0.001% 100.015% ( 2900, 4400 ] 3 0.001% 100.016% ** Level 1 read latency histogram (micros): Count: 81740 Average: 2.4679 StdDev: 16.63 Min: 1 Median: 1.5928 Max: 3216 Percentiles: P50: 1.59 P75: 1.98 P99: 5.95 P99.9: 12.49 P99.99: 24.48 ------------------------------------------------------ [ 0, 1 ] 9285 11.359% 11.359% ## ( 1, 2 ] 53277 65.179% 76.538% ############# ( 2, 3 ] 10381 12.700% 89.238% ### ( 3, 4 ] 4376 5.354% 94.591% # ( 4, 6 ] 3705 4.533% 99.124% # ( 6, 10 ] 579 0.708% 99.832% ( 10, 15 ] 111 0.136% 99.968% ( 15, 22 ] 17 0.021% 99.989% ( 22, 34 ] 4 0.005% 99.994% ( 34, 51 ] 1 0.001% 99.995% ( 51, 76 ] 1 0.001% 99.996% ( 110, 170 ] 2 0.002% 99.999% ( 170, 250 ] 2 0.002% 100.001% ( 250, 380 ] 4 0.005% 100.006% ( 380, 580 ] 1 0.001% 100.007% ( 580, 870 ] 1 0.001% 100.009% ( 870, 1300 ] 1 0.001% 100.010% ( 1300, 1900 ] 1 0.001% 100.011% ( 1900, 2900 ] 1 0.001% 100.012% ( 2900, 4400 ] 1 0.001% 100.013% ** Level 2 read latency histogram (micros): Count: 95454 Average: 1.9994 StdDev: 6.32 Min: 0 Median: 1.3746 Max: 1177 Percentiles: P50: 1.37 P75: 1.78 P99: 5.55 P99.9: 11.31 P99.99: 26.36 ------------------------------------------------------ [ 0, 1 ] 25927 27.162% 27.162% ##### ( 1, 2 ] 58199 60.971% 88.133% ############ ( 2, 3 ] 5969 6.253% 94.386% # ( 3, 4 ] 3001 3.144% 97.530% # ( 4, 6 ] 1815 1.901% 99.431% ( 6, 10 ] 421 0.441% 99.872% ( 10, 15 ] 101 0.106% 99.978% ( 15, 22 ] 10 0.010% 99.988% ( 22, 34 ] 4 0.004% 99.993% ( 51, 76 ] 1 0.001% 99.994% ( 380, 580 ] 3 0.003% 99.997% ( 870, 1300 ] 3 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 57528 Average: 3.4469 StdDev: 51.60 Min: 0 Median: 1.5853 Max: 4401 Percentiles: P50: 1.59 P75: 1.97 P99: 6.24 P99.9: 33.56 P99.99: 2549.44 ------------------------------------------------------ [ 0, 1 ] 6901 11.996% 11.996% ## ( 1, 2 ] 37351 64.927% 76.923% ############# ( 2, 3 ] 7039 12.236% 89.158% ## ( 3, 4 ] 3087 5.366% 94.524% # ( 4, 6 ] 2550 4.433% 98.957% # ( 6, 10 ] 408 0.709% 99.666% ( 10, 15 ] 79 0.137% 99.804% ( 15, 22 ] 15 0.026% 99.830% ( 22, 34 ] 42 0.073% 99.903% ( 34, 51 ] 1 0.002% 99.904% ( 110, 170 ] 8 0.014% 99.918% ( 170, 250 ] 7 0.012% 99.930% ( 250, 380 ] 5 0.009% 99.939% ( 380, 580 ] 5 0.009% 99.948% ( 580, 870 ] 14 0.024% 99.972% ( 870, 1300 ] 3 0.005% 99.977% ( 1300, 1900 ] 4 0.007% 99.984% ( 1900, 2900 ] 5 0.009% 99.993% ( 2900, 4400 ] 6 0.010% 100.003% ( 4400, 6600 ] 1 0.002% 100.005% ** Level 4 read latency histogram (micros): Count: 35 Average: 1979.2286 StdDev: 1565.44 Min: 165 Median: 1375.0000 Max: 5321 Percentiles: P50: 1375.00 P75: 3134.38 P99: 5321.00 P99.9: 5321.00 P99.99: 5321.00 ------------------------------------------------------ ( 110, 170 ] 1 2.857% 2.857% # ( 170, 250 ] 1 2.857% 5.714% # ( 250, 380 ] 1 2.857% 8.571% # ( 380, 580 ] 1 2.857% 11.429% # ( 580, 870 ] 10 28.571% 40.000% ###### ( 870, 1300 ] 3 8.571% 48.571% ## ( 1300, 1900 ] 4 11.429% 60.000% ## ( 1900, 2900 ] 4 11.429% 71.429% ## ( 2900, 4400 ] 8 22.857% 94.286% ##### ( 4400, 6600 ] 2 5.714% 100.000% # ** Level 5 read latency histogram (micros): Count: 20 Average: 738.5500 StdDev: 795.43 Min: 130 Median: 336.6667 Max: 2392 Percentiles: P50: 336.67 P75: 870.00 P99: 2392.00 P99.9: 2392.00 P99.99: 2392.00 ------------------------------------------------------ ( 110, 170 ] 5 25.000% 25.000% ##### ( 170, 250 ] 3 15.000% 40.000% ### ( 250, 380 ] 3 15.000% 55.000% ### ( 380, 580 ] 2 10.000% 65.000% ## ( 580, 870 ] 2 10.000% 75.000% ## ( 1300, 1900 ] 1 5.000% 80.000% # ( 1900, 2900 ] 4 20.000% 100.000% #### ** DB Stats ** Uptime(secs): 6.1 total, 2.9 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 323.96 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:0.620 H:M:S, 10.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 342.44 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.217 H:M:S, 7.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/21-00:17:54 ... thread 0: (1000000,3000000) ops and (333460.9,337790.9) ops/second in (2.998852,8.881233) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 10/4 1.29 GB 100.7 1.4 0.0 1.4 4.1 2.7 0.0 1.5 104.8 314.2 13.23 12.27 44 0.301 1407K 1512 0.0 0.0 L1 8/0 818.45 MB 81.8 1.2 1.2 0.0 1.2 1.2 0.2 1.0 234.7 234.0 5.11 4.97 2 2.555 1217K 3192 0.0 0.0 L2 2/0 54.29 MB 0.5 0.4 0.2 0.2 0.4 0.2 0.5 2.0 251.1 250.9 1.51 1.45 2 0.753 383K 209 0.0 0.0 L3 38/0 961.72 MB 1.0 0.8 0.6 0.2 0.8 0.6 0.1 1.4 203.8 203.6 3.91 3.44 3 1.304 809K 784 0.0 0.0 L4 148/0 9.57 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1048/0 86.19 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1254/4 98.84 GB 0.0 3.7 1.9 1.8 6.4 4.6 1.5 2.4 158.3 274.7 23.75 22.13 51 0.466 3817K 5697 0.0 0.0 Int 0/0 0.00 KB 0.0 3.7 1.9 1.8 6.4 4.6 1.4 2.4 158.3 274.7 23.75 22.13 51 0.466 3817K 5697 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.7 1.9 1.8 3.7 1.9 0.0 0.0 237.6 237.2 15.83 15.03 12 1.319 3817K 5697 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 2.7 2.7 0.0 0.0 0.0 349.6 7.93 7.10 39 0.203 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 9.1 total, 8.9 interval Flush(GB): cumulative 2.707, interval 2.707 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 6.37 GB write, 719.15 MB/s write, 3.67 GB read, 414.36 MB/s read, 23.8 seconds Interval compaction: 6.37 GB write, 734.68 MB/s write, 3.67 GB read, 423.30 MB/s read, 23.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: 9, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 9, interval: 9 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 770874 Average: 2.1148 StdDev: 10.92 Min: 1 Median: 1.4469 Max: 3272 Percentiles: P50: 1.45 P75: 1.83 P99: 5.48 P99.9: 9.66 P99.99: 14.05 ------------------------------------------------------ [ 0, 1 ] 162591 21.092% 21.092% #### ( 1, 2 ] 498643 64.685% 85.777% ############# ( 2, 3 ] 62153 8.063% 93.840% ## ( 3, 4 ] 27431 3.558% 97.398% # ( 4, 6 ] 16654 2.160% 99.559% ( 6, 10 ] 2878 0.373% 99.932% ( 10, 15 ] 553 0.072% 100.004% ( 15, 22 ] 67 0.009% 100.012% ( 22, 34 ] 17 0.002% 100.015% ( 34, 51 ] 2 0.000% 100.015% ( 51, 76 ] 5 0.001% 100.016% ( 76, 110 ] 1 0.000% 100.016% ( 110, 170 ] 22 0.003% 100.019% ( 170, 250 ] 14 0.002% 100.020% ( 250, 380 ] 20 0.003% 100.023% ( 380, 580 ] 4 0.001% 100.023% ( 580, 870 ] 11 0.001% 100.025% ( 870, 1300 ] 6 0.001% 100.026% ( 1300, 1900 ] 4 0.001% 100.026% ( 1900, 2900 ] 6 0.001% 100.027% ( 2900, 4400 ] 3 0.000% 100.027% ** Level 1 read latency histogram (micros): Count: 82508 Average: 2.5597 StdDev: 18.49 Min: 1 Median: 1.5921 Max: 3216 Percentiles: P50: 1.59 P75: 1.98 P99: 5.95 P99.9: 13.19 P99.99: 294.31 ------------------------------------------------------ [ 0, 1 ] 9444 11.446% 11.446% ## ( 1, 2 ] 53721 65.110% 76.556% ############# ( 2, 3 ] 10491 12.715% 89.271% ### ( 3, 4 ] 4400 5.333% 94.604% # ( 4, 6 ] 3714 4.501% 99.106% # ( 6, 10 ] 584 0.708% 99.813% ( 10, 15 ] 112 0.136% 99.949% ( 15, 22 ] 17 0.021% 99.970% ( 22, 34 ] 5 0.006% 99.976% ( 34, 51 ] 1 0.001% 99.977% ( 51, 76 ] 1 0.001% 99.978% ( 110, 170 ] 4 0.005% 99.983% ( 170, 250 ] 2 0.002% 99.985% ( 250, 380 ] 11 0.013% 99.999% ( 380, 580 ] 2 0.002% 100.001% ( 580, 870 ] 3 0.004% 100.005% ( 870, 1300 ] 4 0.005% 100.010% ( 1300, 1900 ] 1 0.001% 100.011% ( 1900, 2900 ] 1 0.001% 100.012% ( 2900, 4400 ] 1 0.001% 100.013% ** Level 2 read latency histogram (micros): Count: 95454 Average: 1.9994 StdDev: 6.32 Min: 0 Median: 1.3746 Max: 1177 Percentiles: P50: 1.37 P75: 1.78 P99: 5.55 P99.9: 11.31 P99.99: 26.36 ------------------------------------------------------ [ 0, 1 ] 25927 27.162% 27.162% ##### ( 1, 2 ] 58199 60.971% 88.133% ############ ( 2, 3 ] 5969 6.253% 94.386% # ( 3, 4 ] 3001 3.144% 97.530% # ( 4, 6 ] 1815 1.901% 99.431% ( 6, 10 ] 421 0.441% 99.872% ( 10, 15 ] 101 0.106% 99.978% ( 15, 22 ] 10 0.010% 99.988% ( 22, 34 ] 4 0.004% 99.993% ( 51, 76 ] 1 0.001% 99.994% ( 380, 580 ] 3 0.003% 99.997% ( 870, 1300 ] 3 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 57528 Average: 3.4469 StdDev: 51.60 Min: 0 Median: 1.5853 Max: 4401 Percentiles: P50: 1.59 P75: 1.97 P99: 6.24 P99.9: 33.56 P99.99: 2549.44 ------------------------------------------------------ [ 0, 1 ] 6901 11.996% 11.996% ## ( 1, 2 ] 37351 64.927% 76.923% ############# ( 2, 3 ] 7039 12.236% 89.158% ## ( 3, 4 ] 3087 5.366% 94.524% # ( 4, 6 ] 2550 4.433% 98.957% # ( 6, 10 ] 408 0.709% 99.666% ( 10, 15 ] 79 0.137% 99.804% ( 15, 22 ] 15 0.026% 99.830% ( 22, 34 ] 42 0.073% 99.903% ( 34, 51 ] 1 0.002% 99.904% ( 110, 170 ] 8 0.014% 99.918% ( 170, 250 ] 7 0.012% 99.930% ( 250, 380 ] 5 0.009% 99.939% ( 380, 580 ] 5 0.009% 99.948% ( 580, 870 ] 14 0.024% 99.972% ( 870, 1300 ] 3 0.005% 99.977% ( 1300, 1900 ] 4 0.007% 99.984% ( 1900, 2900 ] 5 0.009% 99.993% ( 2900, 4400 ] 6 0.010% 100.003% ( 4400, 6600 ] 1 0.002% 100.005% ** Level 4 read latency histogram (micros): Count: 35 Average: 1979.2286 StdDev: 1565.44 Min: 165 Median: 1375.0000 Max: 5321 Percentiles: P50: 1375.00 P75: 3134.38 P99: 5321.00 P99.9: 5321.00 P99.99: 5321.00 ------------------------------------------------------ ( 110, 170 ] 1 2.857% 2.857% # ( 170, 250 ] 1 2.857% 5.714% # ( 250, 380 ] 1 2.857% 8.571% # ( 380, 580 ] 1 2.857% 11.429% # ( 580, 870 ] 10 28.571% 40.000% ###### ( 870, 1300 ] 3 8.571% 48.571% ## ( 1300, 1900 ] 4 11.429% 60.000% ## ( 1900, 2900 ] 4 11.429% 71.429% ## ( 2900, 4400 ] 8 22.857% 94.286% ##### ( 4400, 6600 ] 2 5.714% 100.000% # ** Level 5 read latency histogram (micros): Count: 20 Average: 738.5500 StdDev: 795.43 Min: 130 Median: 336.6667 Max: 2392 Percentiles: P50: 336.67 P75: 870.00 P99: 2392.00 P99.9: 2392.00 P99.99: 2392.00 ------------------------------------------------------ ( 110, 170 ] 5 25.000% 25.000% ##### ( 170, 250 ] 3 15.000% 40.000% ### ( 250, 380 ] 3 15.000% 55.000% ### ( 380, 580 ] 2 10.000% 65.000% ## ( 580, 870 ] 2 10.000% 75.000% ## ( 1300, 1900 ] 1 5.000% 80.000% # ( 1900, 2900 ] 4 20.000% 100.000% #### ** DB Stats ** Uptime(secs): 9.1 total, 3.0 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 325.36 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.005 H:M:S, 11.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 328.19 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.384 H:M:S, 12.8 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/11/21-00:17:57 ... thread 0: (1000000,4000000) ops and (326842.8,334985.7) ops/second in (3.059575,11.940808) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 12/10 2.27 GB 12.6 2.5 0.0 2.5 6.1 3.7 0.0 1.7 123.5 308.7 20.40 19.04 62 0.329 2558K 2720 0.0 0.0 L1 4/4 303.37 MB 0.0 1.2 1.2 0.0 1.2 1.2 0.2 1.0 234.7 234.0 5.11 4.97 2 2.555 1217K 3192 0.0 0.0 L2 2/0 54.29 MB 0.5 0.4 0.2 0.2 0.4 0.2 1.0 2.0 251.1 250.9 1.51 1.45 2 0.753 383K 209 0.0 0.0 L3 16/0 907.23 MB 0.9 1.0 0.7 0.3 1.0 0.7 0.5 1.4 209.0 208.8 4.66 4.17 4 1.166 990K 1185 0.0 0.0 L4 166/0 9.45 GB 1.0 0.1 0.1 0.0 0.1 0.1 0.8 1.0 219.2 219.2 0.49 0.46 1 0.492 109K 0 0.0 0.0 L5 1056/0 86.86 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1256/14 99.82 GB 0.0 5.1 2.1 2.9 8.7 5.8 3.5 2.4 161.0 278.3 32.17 30.08 71 0.453 5259K 7306 0.0 0.0 Int 0/0 0.00 KB 0.0 5.1 2.1 2.9 8.7 5.8 3.4 2.4 161.0 278.3 32.17 30.08 71 0.453 5259K 7306 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 5.1 2.1 2.9 5.1 2.1 0.0 0.0 241.9 241.5 21.41 20.46 18 1.190 5259K 7306 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 3.7 3.7 0.0 0.0 0.0 351.4 10.76 9.62 53 0.203 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 12.1 total, 11.9 interval Flush(GB): cumulative 3.691, interval 3.691 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 8.74 GB write, 737.75 MB/s write, 5.06 GB read, 426.88 MB/s read, 32.2 seconds Interval compaction: 8.74 GB write, 749.59 MB/s write, 5.06 GB read, 433.74 MB/s read, 32.2 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 13, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 13, interval: 13 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1027467 Average: 2.0968 StdDev: 10.49 Min: 1 Median: 1.4342 Max: 3272 Percentiles: P50: 1.43 P75: 1.82 P99: 5.46 P99.9: 9.67 P99.99: 14.25 ------------------------------------------------------ [ 0, 1 ] 226971 22.090% 22.090% #### ( 1, 2 ] 660455 64.280% 86.370% ############# ( 2, 3 ] 79329 7.721% 94.091% ## ( 3, 4 ] 34992 3.406% 97.497% # ( 4, 6 ] 21184 2.062% 99.559% ( 6, 10 ] 3821 0.372% 99.930% ( 10, 15 ] 721 0.070% 100.001% ( 15, 22 ] 88 0.009% 100.009% ( 22, 34 ] 18 0.002% 100.011% ( 34, 51 ] 3 0.000% 100.011% ( 51, 76 ] 6 0.001% 100.012% ( 76, 110 ] 1 0.000% 100.012% ( 110, 170 ] 30 0.003% 100.015% ( 170, 250 ] 18 0.002% 100.017% ( 250, 380 ] 25 0.002% 100.019% ( 380, 580 ] 8 0.001% 100.020% ( 580, 870 ] 18 0.002% 100.022% ( 870, 1300 ] 11 0.001% 100.023% ( 1300, 1900 ] 6 0.001% 100.023% ( 1900, 2900 ] 7 0.001% 100.024% ( 2900, 4400 ] 3 0.000% 100.024% ** Level 1 read latency histogram (micros): Count: 115205 Average: 2.4742 StdDev: 15.67 Min: 1 Median: 1.5799 Max: 3216 Percentiles: P50: 1.58 P75: 1.96 P99: 5.99 P99.9: 13.40 P99.99: 255.67 ------------------------------------------------------ [ 0, 1 ] 13434 11.661% 11.661% ## ( 1, 2 ] 76170 66.117% 77.778% ############# ( 2, 3 ] 14019 12.169% 89.947% ## ( 3, 4 ] 5738 4.981% 94.927% # ( 4, 6 ] 4712 4.090% 99.017% # ( 6, 10 ] 899 0.780% 99.798% ( 10, 15 ] 173 0.150% 99.948% ( 15, 22 ] 29 0.025% 99.973% ( 22, 34 ] 8 0.007% 99.980% ( 34, 51 ] 2 0.002% 99.982% ( 51, 76 ] 2 0.002% 99.984% ( 110, 170 ] 4 0.003% 99.987% ( 170, 250 ] 3 0.003% 99.990% ( 250, 380 ] 11 0.010% 99.999% ( 380, 580 ] 2 0.002% 100.001% ( 580, 870 ] 3 0.003% 100.003% ( 870, 1300 ] 4 0.003% 100.007% ( 1300, 1900 ] 1 0.001% 100.008% ( 1900, 2900 ] 1 0.001% 100.009% ( 2900, 4400 ] 1 0.001% 100.010% ** Level 2 read latency histogram (micros): Count: 95454 Average: 1.9994 StdDev: 6.32 Min: 0 Median: 1.3746 Max: 1177 Percentiles: P50: 1.37 P75: 1.78 P99: 5.55 P99.9: 11.31 P99.99: 26.36 ------------------------------------------------------ [ 0, 1 ] 25927 27.162% 27.162% ##### ( 1, 2 ] 58199 60.971% 88.133% ############ ( 2, 3 ] 5969 6.253% 94.386% # ( 3, 4 ] 3001 3.144% 97.530% # ( 4, 6 ] 1815 1.901% 99.431% ( 6, 10 ] 421 0.441% 99.872% ( 10, 15 ] 101 0.106% 99.978% ( 15, 22 ] 10 0.010% 99.988% ( 22, 34 ] 4 0.004% 99.993% ( 51, 76 ] 1 0.001% 99.994% ( 380, 580 ] 3 0.003% 99.997% ( 870, 1300 ] 3 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 97407 Average: 2.9915 StdDev: 39.80 Min: 0 Median: 1.5832 Max: 4401 Percentiles: P50: 1.58 P75: 1.97 P99: 5.99 P99.9: 23.60 P99.99: 1788.89 ------------------------------------------------------ [ 0, 1 ] 11601 11.910% 11.910% ## ( 1, 2 ] 63618 65.312% 77.221% ############# ( 2, 3 ] 12203 12.528% 89.749% ### ( 3, 4 ] 5015 5.149% 94.898% # ( 4, 6 ] 4009 4.116% 99.013% # ( 6, 10 ] 710 0.729% 99.742% ( 10, 15 ] 126 0.129% 99.872% ( 15, 22 ] 22 0.023% 99.894% ( 22, 34 ] 42 0.043% 99.937% ( 34, 51 ] 1 0.001% 99.938% ( 51, 76 ] 1 0.001% 99.939% ( 110, 170 ] 8 0.008% 99.948% ( 170, 250 ] 8 0.008% 99.956% ( 250, 380 ] 6 0.006% 99.962% ( 380, 580 ] 6 0.006% 99.968% ( 580, 870 ] 15 0.015% 99.984% ( 870, 1300 ] 3 0.003% 99.987% ( 1300, 1900 ] 4 0.004% 99.991% ( 1900, 2900 ] 5 0.005% 99.996% ( 2900, 4400 ] 6 0.006% 100.002% ( 4400, 6600 ] 1 0.001% 100.003% ** Level 4 read latency histogram (micros): Count: 60 Average: 1179.6667 StdDev: 1527.03 Min: 1 Median: 632.7273 Max: 5321 Percentiles: P50: 632.73 P75: 1750.00 P99: 5321.00 P99.9: 5321.00 P99.99: 5321.00 ------------------------------------------------------ [ 0, 1 ] 10 16.667% 16.667% ### ( 1, 2 ] 4 6.667% 23.333% # ( 2, 3 ] 1 1.667% 25.000% ( 10, 15 ] 1 1.667% 26.667% ( 15, 22 ] 2 3.333% 30.000% # ( 51, 76 ] 3 5.000% 35.000% # ( 76, 110 ] 1 1.667% 36.667% ( 110, 170 ] 1 1.667% 38.333% ( 170, 250 ] 2 3.333% 41.667% # ( 250, 380 ] 2 3.333% 45.000% # ( 380, 580 ] 1 1.667% 46.667% ( 580, 870 ] 11 18.333% 65.000% #### ( 870, 1300 ] 3 5.000% 70.000% # ( 1300, 1900 ] 4 6.667% 76.667% # ( 1900, 2900 ] 4 6.667% 83.333% # ( 2900, 4400 ] 8 13.333% 96.667% ### ( 4400, 6600 ] 2 3.333% 100.000% # ** Level 5 read latency histogram (micros): Count: 60 Average: 675.4500 StdDev: 852.37 Min: 77 Median: 271.6667 Max: 3611 Percentiles: P50: 271.67 P75: 870.00 P99: 3500.00 P99.9: 3611.00 P99.99: 3611.00 ------------------------------------------------------ ( 76, 110 ] 12 20.000% 20.000% #### ( 110, 170 ] 12 20.000% 40.000% #### ( 170, 250 ] 5 8.333% 48.333% ## ( 250, 380 ] 6 10.000% 58.333% ## ( 380, 580 ] 7 11.667% 70.000% ## ( 580, 870 ] 3 5.000% 75.000% # ( 870, 1300 ] 5 8.333% 83.333% ## ( 1300, 1900 ] 2 3.333% 86.667% # ( 1900, 2900 ] 7 11.667% 98.333% ## ( 2900, 4400 ] 1 1.667% 100.000% ** DB Stats ** Uptime(secs): 12.1 total, 3.1 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 324.43 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.433 H:M:S, 11.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 321.67 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.429 H:M:S, 14.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/11/21-00:18:01 ... thread 0: (1000000,5000000) ops and (276533.8,321398.7) ops/second in (3.616195,15.557003) 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 3.32 GB 94.4 3.3 0.0 3.3 8.0 4.7 0.0 1.7 126.2 309.3 26.46 24.75 80 0.331 3390K 3581 0.0 0.0 L1 4/4 303.37 MB 0.0 1.2 1.2 0.0 1.2 1.2 0.2 1.0 234.7 234.0 5.11 4.97 2 2.555 1217K 3192 0.0 0.0 L2 2/0 54.29 MB 0.5 0.4 0.2 0.2 0.4 0.2 1.0 2.0 251.1 250.9 1.51 1.45 2 0.753 383K 209 0.0 0.0 L3 16/0 907.23 MB 0.9 1.0 0.7 0.3 1.0 0.7 0.5 1.4 209.0 208.8 4.66 4.17 4 1.166 990K 1185 0.0 0.0 L4 166/0 9.45 GB 1.0 0.1 0.1 0.0 0.1 0.1 0.8 1.0 219.2 219.2 0.49 0.46 1 0.492 109K 0 0.0 0.0 L5 1056/0 86.86 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1262/18 100.87 GB 0.0 5.9 2.1 3.7 10.6 6.9 3.5 2.2 156.9 283.5 38.23 35.79 89 0.430 6091K 8167 0.0 0.0 Int 0/0 0.00 KB 0.0 5.9 2.1 3.7 10.6 6.9 3.4 2.2 156.9 283.5 38.23 35.79 89 0.430 6091K 8167 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 5.9 2.1 3.7 5.8 2.1 0.0 0.0 245.7 245.4 24.41 23.41 21 1.163 6091K 8167 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.0 13.82 12.38 68 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): 15.8 total, 15.6 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: 10.59 GB write, 688.30 MB/s write, 5.86 GB read, 380.87 MB/s read, 38.2 seconds Interval compaction: 10.59 GB write, 696.78 MB/s write, 5.86 GB read, 385.56 MB/s read, 38.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: 15, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 2, total-stops: 15, interval: 17 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1475022 Average: 2.1116 StdDev: 10.15 Min: 1 Median: 1.4439 Max: 3272 Percentiles: P50: 1.44 P75: 1.83 P99: 5.44 P99.9: 9.67 P99.99: 14.26 ------------------------------------------------------ [ 0, 1 ] 309068 20.953% 20.953% #### ( 1, 2 ] 965153 65.433% 86.387% ############# ( 2, 3 ] 115429 7.826% 94.212% ## ( 3, 4 ] 49962 3.387% 97.599% # ( 4, 6 ] 28711 1.946% 99.546% ( 6, 10 ] 5692 0.386% 99.932% ( 10, 15 ] 1009 0.068% 100.000% ( 15, 22 ] 115 0.008% 100.008% ( 22, 34 ] 23 0.002% 100.009% ( 34, 51 ] 6 0.000% 100.010% ( 51, 76 ] 9 0.001% 100.011% ( 76, 110 ] 23 0.002% 100.012% ( 110, 170 ] 66 0.004% 100.017% ( 170, 250 ] 40 0.003% 100.019% ( 250, 380 ] 39 0.003% 100.022% ( 380, 580 ] 17 0.001% 100.023% ( 580, 870 ] 27 0.002% 100.025% ( 870, 1300 ] 17 0.001% 100.026% ( 1300, 1900 ] 8 0.001% 100.027% ( 1900, 2900 ] 10 0.001% 100.027% ( 2900, 4400 ] 3 0.000% 100.027% ** Level 1 read latency histogram (micros): Count: 115205 Average: 2.4742 StdDev: 15.67 Min: 1 Median: 1.5799 Max: 3216 Percentiles: P50: 1.58 P75: 1.96 P99: 5.99 P99.9: 13.40 P99.99: 255.67 ------------------------------------------------------ [ 0, 1 ] 13434 11.661% 11.661% ## ( 1, 2 ] 76170 66.117% 77.778% ############# ( 2, 3 ] 14019 12.169% 89.947% ## ( 3, 4 ] 5738 4.981% 94.927% # ( 4, 6 ] 4712 4.090% 99.017% # ( 6, 10 ] 899 0.780% 99.798% ( 10, 15 ] 173 0.150% 99.948% ( 15, 22 ] 29 0.025% 99.973% ( 22, 34 ] 8 0.007% 99.980% ( 34, 51 ] 2 0.002% 99.982% ( 51, 76 ] 2 0.002% 99.984% ( 110, 170 ] 4 0.003% 99.987% ( 170, 250 ] 3 0.003% 99.990% ( 250, 380 ] 11 0.010% 99.999% ( 380, 580 ] 2 0.002% 100.001% ( 580, 870 ] 3 0.003% 100.003% ( 870, 1300 ] 4 0.003% 100.007% ( 1300, 1900 ] 1 0.001% 100.008% ( 1900, 2900 ] 1 0.001% 100.009% ( 2900, 4400 ] 1 0.001% 100.010% ** Level 2 read latency histogram (micros): Count: 95454 Average: 1.9994 StdDev: 6.32 Min: 0 Median: 1.3746 Max: 1177 Percentiles: P50: 1.37 P75: 1.78 P99: 5.55 P99.9: 11.31 P99.99: 26.36 ------------------------------------------------------ [ 0, 1 ] 25927 27.162% 27.162% ##### ( 1, 2 ] 58199 60.971% 88.133% ############ ( 2, 3 ] 5969 6.253% 94.386% # ( 3, 4 ] 3001 3.144% 97.530% # ( 4, 6 ] 1815 1.901% 99.431% ( 6, 10 ] 421 0.441% 99.872% ( 10, 15 ] 101 0.106% 99.978% ( 15, 22 ] 10 0.010% 99.988% ( 22, 34 ] 4 0.004% 99.993% ( 51, 76 ] 1 0.001% 99.994% ( 380, 580 ] 3 0.003% 99.997% ( 870, 1300 ] 3 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 97407 Average: 2.9915 StdDev: 39.80 Min: 0 Median: 1.5832 Max: 4401 Percentiles: P50: 1.58 P75: 1.97 P99: 5.99 P99.9: 23.60 P99.99: 1788.89 ------------------------------------------------------ [ 0, 1 ] 11601 11.910% 11.910% ## ( 1, 2 ] 63618 65.312% 77.221% ############# ( 2, 3 ] 12203 12.528% 89.749% ### ( 3, 4 ] 5015 5.149% 94.898% # ( 4, 6 ] 4009 4.116% 99.013% # ( 6, 10 ] 710 0.729% 99.742% ( 10, 15 ] 126 0.129% 99.872% ( 15, 22 ] 22 0.023% 99.894% ( 22, 34 ] 42 0.043% 99.937% ( 34, 51 ] 1 0.001% 99.938% ( 51, 76 ] 1 0.001% 99.939% ( 110, 170 ] 8 0.008% 99.948% ( 170, 250 ] 8 0.008% 99.956% ( 250, 380 ] 6 0.006% 99.962% ( 380, 580 ] 6 0.006% 99.968% ( 580, 870 ] 15 0.015% 99.984% ( 870, 1300 ] 3 0.003% 99.987% ( 1300, 1900 ] 4 0.004% 99.991% ( 1900, 2900 ] 5 0.005% 99.996% ( 2900, 4400 ] 6 0.006% 100.002% ( 4400, 6600 ] 1 0.001% 100.003% ** Level 4 read latency histogram (micros): Count: 60 Average: 1179.6667 StdDev: 1527.03 Min: 1 Median: 632.7273 Max: 5321 Percentiles: P50: 632.73 P75: 1750.00 P99: 5321.00 P99.9: 5321.00 P99.99: 5321.00 ------------------------------------------------------ [ 0, 1 ] 10 16.667% 16.667% ### ( 1, 2 ] 4 6.667% 23.333% # ( 2, 3 ] 1 1.667% 25.000% ( 10, 15 ] 1 1.667% 26.667% ( 15, 22 ] 2 3.333% 30.000% # ( 51, 76 ] 3 5.000% 35.000% # ( 76, 110 ] 1 1.667% 36.667% ( 110, 170 ] 1 1.667% 38.333% ( 170, 250 ] 2 3.333% 41.667% # ( 250, 380 ] 2 3.333% 45.000% # ( 380, 580 ] 1 1.667% 46.667% ( 580, 870 ] 11 18.333% 65.000% #### ( 870, 1300 ] 3 5.000% 70.000% # ( 1300, 1900 ] 4 6.667% 76.667% # ( 1900, 2900 ] 4 6.667% 83.333% # ( 2900, 4400 ] 8 13.333% 96.667% ### ( 4400, 6600 ] 2 3.333% 100.000% # ** Level 5 read latency histogram (micros): Count: 60 Average: 675.4500 StdDev: 852.37 Min: 77 Median: 271.6667 Max: 3611 Percentiles: P50: 271.67 P75: 870.00 P99: 3500.00 P99.9: 3611.00 P99.99: 3611.00 ------------------------------------------------------ ( 76, 110 ] 12 20.000% 20.000% #### ( 110, 170 ] 12 20.000% 40.000% #### ( 170, 250 ] 5 8.333% 48.333% ## ( 250, 380 ] 6 10.000% 58.333% ## ( 380, 580 ] 7 11.667% 70.000% ## ( 580, 870 ] 3 5.000% 75.000% # ( 870, 1300 ] 5 8.333% 83.333% ## ( 1300, 1900 ] 2 3.333% 86.667% # ( 1900, 2900 ] 7 11.667% 98.333% ## ( 2900, 4400 ] 1 1.667% 100.000% ** DB Stats ** Uptime(secs): 15.8 total, 3.6 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 312.43 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:2.368 H:M:S, 15.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 272.16 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.935 H:M:S, 25.8 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/21-00:18:08 ... thread 0: (1000000,6000000) ops and (138422.0,263374.0) ops/second in (7.224287,22.781290) 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/4 2.09 GB 188.6 4.8 0.0 4.8 10.5 5.7 0.0 1.8 140.2 305.3 35.05 32.93 99 0.354 4988K 6645 0.0 0.0 L1 13/0 1.41 GB 144.7 3.6 3.3 0.3 3.6 3.3 0.2 1.1 231.7 229.7 15.99 15.46 3 5.331 3762K 32K 0.0 0.0 L2 10/7 1.06 GB 3.9 0.4 0.2 0.2 0.4 0.2 2.0 2.0 251.1 250.9 1.51 1.45 2 0.753 383K 209 0.0 0.0 L3 16/15 907.23 MB 0.1 1.0 0.7 0.3 1.0 0.7 0.5 1.4 209.0 208.8 4.66 4.17 4 1.166 990K 1185 0.0 0.0 L4 166/0 9.45 GB 1.0 0.1 0.1 0.0 0.1 0.1 0.8 1.0 219.2 219.2 0.49 0.46 1 0.492 109K 0 0.0 0.0 L5 1056/0 86.86 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1272/26 101.76 GB 0.0 9.8 4.3 5.5 15.5 9.9 4.6 2.7 174.7 274.4 57.70 54.47 109 0.529 10M 40K 0.0 0.0 Int 0/0 0.00 KB 0.0 9.8 4.3 5.5 15.5 9.9 4.4 2.7 174.7 274.4 57.70 54.47 109 0.529 10M 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 9.8 4.3 5.5 9.8 4.3 0.0 0.0 244.6 243.6 41.21 39.71 26 1.585 10M 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 351.4 16.50 14.76 83 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): 23.0 total, 22.8 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: 15.46 GB write, 689.18 MB/s write, 9.84 GB read, 438.70 MB/s read, 57.7 seconds Interval compaction: 15.46 GB write, 694.98 MB/s write, 9.84 GB read, 442.39 MB/s read, 57.7 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: 15, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 11, total-stops: 15, interval: 26 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2210767 Average: 2.1597 StdDev: 10.92 Min: 1 Median: 1.4410 Max: 4209 Percentiles: P50: 1.44 P75: 1.82 P99: 5.56 P99.9: 9.97 P99.99: 116.95 ------------------------------------------------------ [ 0, 1 ] 462527 20.922% 20.922% #### ( 1, 2 ] 1457667 65.935% 86.856% ############# ( 2, 3 ] 166045 7.511% 94.367% ## ( 3, 4 ] 71238 3.222% 97.590% # ( 4, 6 ] 40100 1.814% 99.403% ( 6, 10 ] 11060 0.500% 99.904% ( 10, 15 ] 1387 0.063% 99.966% ( 15, 22 ] 176 0.008% 99.974% ( 22, 34 ] 25 0.001% 99.975% ( 34, 51 ] 9 0.000% 99.976% ( 51, 76 ] 13 0.001% 99.976% ( 76, 110 ] 257 0.012% 99.988% ( 110, 170 ] 362 0.016% 100.004% ( 170, 250 ] 155 0.007% 100.011% ( 250, 380 ] 96 0.004% 100.016% ( 380, 580 ] 72 0.003% 100.019% ( 580, 870 ] 52 0.002% 100.021% ( 870, 1300 ] 28 0.001% 100.023% ( 1300, 1900 ] 10 0.000% 100.023% ( 1900, 2900 ] 14 0.001% 100.024% ( 2900, 4400 ] 5 0.000% 100.024% ** Level 1 read latency histogram (micros): Count: 231041 Average: 3.3506 StdDev: 33.75 Min: 1 Median: 1.5837 Max: 8183 Percentiles: P50: 1.58 P75: 1.97 P99: 8.24 P99.9: 194.17 P99.99: 528.86 ------------------------------------------------------ [ 0, 1 ] 29140 12.612% 12.612% ### ( 1, 2 ] 147989 64.053% 76.666% ############# ( 2, 3 ] 27907 12.079% 88.744% ## ( 3, 4 ] 11910 5.155% 93.899% # ( 4, 6 ] 10115 4.378% 98.277% # ( 6, 10 ] 2979 1.289% 99.567% ( 10, 15 ] 419 0.181% 99.748% ( 15, 22 ] 67 0.029% 99.777% ( 22, 34 ] 11 0.005% 99.782% ( 34, 51 ] 5 0.002% 99.784% ( 51, 76 ] 5 0.002% 99.786% ( 76, 110 ] 113 0.049% 99.835% ( 110, 170 ] 128 0.055% 99.890% ( 170, 250 ] 76 0.033% 99.923% ( 250, 380 ] 76 0.033% 99.956% ( 380, 580 ] 106 0.046% 100.002% ( 580, 870 ] 47 0.020% 100.023% ( 870, 1300 ] 26 0.011% 100.034% ( 1300, 1900 ] 15 0.006% 100.040% ( 1900, 2900 ] 4 0.002% 100.042% ( 2900, 4400 ] 4 0.002% 100.044% ( 6600, 9900 ] 1 0.000% 100.044% ** Level 2 read latency histogram (micros): Count: 95673 Average: 2.2796 StdDev: 15.42 Min: 0 Median: 1.3761 Max: 2561 Percentiles: P50: 1.38 P75: 1.79 P99: 5.62 P99.9: 14.49 P99.99: 755.05 ------------------------------------------------------ [ 0, 1 ] 25927 27.100% 27.100% ##### ( 1, 2 ] 58254 60.889% 87.988% ############ ( 2, 3 ] 6036 6.309% 94.297% # ( 3, 4 ] 3014 3.150% 97.448% # ( 4, 6 ] 1829 1.912% 99.359% ( 6, 10 ] 424 0.443% 99.802% ( 10, 15 ] 104 0.109% 99.911% ( 15, 22 ] 10 0.010% 99.922% ( 22, 34 ] 4 0.004% 99.926% ( 51, 76 ] 1 0.001% 99.927% ( 76, 110 ] 3 0.003% 99.930% ( 110, 170 ] 8 0.008% 99.938% ( 170, 250 ] 12 0.013% 99.951% ( 250, 380 ] 9 0.009% 99.960% ( 380, 580 ] 23 0.024% 99.984% ( 580, 870 ] 9 0.009% 99.994% ( 870, 1300 ] 5 0.005% 99.999% ( 1900, 2900 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 106568 Average: 4.1120 StdDev: 57.47 Min: 0 Median: 1.6066 Max: 4401 Percentiles: P50: 1.61 P75: 2.00 P99: 7.41 P99.9: 517.47 P99.99: 2807.96 ------------------------------------------------------ [ 0, 1 ] 11842 11.112% 11.112% ## ( 1, 2 ] 68323 64.112% 75.224% ############# ( 2, 3 ] 14028 13.163% 88.388% ### ( 3, 4 ] 6016 5.645% 94.033% # ( 4, 6 ] 4969 4.663% 98.696% # ( 6, 10 ] 921 0.864% 99.560% ( 10, 15 ] 187 0.175% 99.735% ( 15, 22 ] 33 0.031% 99.766% ( 22, 34 ] 43 0.040% 99.807% ( 34, 51 ] 1 0.001% 99.808% ( 51, 76 ] 3 0.003% 99.810% ( 110, 170 ] 13 0.012% 99.823% ( 170, 250 ] 23 0.022% 99.844% ( 250, 380 ] 35 0.033% 99.877% ( 380, 580 ] 37 0.035% 99.912% ( 580, 870 ] 37 0.035% 99.947% ( 870, 1300 ] 23 0.022% 99.968% ( 1300, 1900 ] 8 0.008% 99.976% ( 1900, 2900 ] 18 0.017% 99.992% ( 2900, 4400 ] 11 0.010% 100.003% ( 4400, 6600 ] 1 0.001% 100.004% ** Level 4 read latency histogram (micros): Count: 60 Average: 1179.6667 StdDev: 1527.03 Min: 1 Median: 632.7273 Max: 5321 Percentiles: P50: 632.73 P75: 1750.00 P99: 5321.00 P99.9: 5321.00 P99.99: 5321.00 ------------------------------------------------------ [ 0, 1 ] 10 16.667% 16.667% ### ( 1, 2 ] 4 6.667% 23.333% # ( 2, 3 ] 1 1.667% 25.000% ( 10, 15 ] 1 1.667% 26.667% ( 15, 22 ] 2 3.333% 30.000% # ( 51, 76 ] 3 5.000% 35.000% # ( 76, 110 ] 1 1.667% 36.667% ( 110, 170 ] 1 1.667% 38.333% ( 170, 250 ] 2 3.333% 41.667% # ( 250, 380 ] 2 3.333% 45.000% # ( 380, 580 ] 1 1.667% 46.667% ( 580, 870 ] 11 18.333% 65.000% #### ( 870, 1300 ] 3 5.000% 70.000% # ( 1300, 1900 ] 4 6.667% 76.667% # ( 1900, 2900 ] 4 6.667% 83.333% # ( 2900, 4400 ] 8 13.333% 96.667% ### ( 4400, 6600 ] 2 3.333% 100.000% # ** Level 5 read latency histogram (micros): Count: 60 Average: 675.4500 StdDev: 852.37 Min: 77 Median: 271.6667 Max: 3611 Percentiles: P50: 271.67 P75: 870.00 P99: 3500.00 P99.9: 3611.00 P99.99: 3611.00 ------------------------------------------------------ ( 76, 110 ] 12 20.000% 20.000% #### ( 110, 170 ] 12 20.000% 40.000% #### ( 170, 250 ] 5 8.333% 48.333% ## ( 250, 380 ] 6 10.000% 58.333% ## ( 380, 580 ] 7 11.667% 70.000% ## ( 580, 870 ] 3 5.000% 75.000% # ( 870, 1300 ] 5 8.333% 83.333% ## ( 1300, 1900 ] 2 3.333% 86.667% # ( 1900, 2900 ] 7 11.667% 98.333% ## ( 2900, 4400 ] 1 1.667% 100.000% ** DB Stats ** Uptime(secs): 23.0 total, 7.2 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 257.03 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.726 H:M:S, 29.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 136.23 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.358 H:M:S, 60.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 6 num-running-flushes: 1 2024/11/21-00:18:12 ... thread 0: (1000000,7000000) ops and (254691.4,262097.6) ops/second in (3.926321,26.707611) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 17/13 3.01 GB 56.7 5.4 0.0 5.4 11.9 6.6 0.0 1.8 133.2 296.9 41.14 37.70 113 0.364 5564K 7264 0.0 0.0 L1 13/13 1.41 GB 0.0 3.6 3.3 0.3 3.6 3.3 0.2 1.1 231.7 229.7 15.99 15.46 3 5.331 3762K 32K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 2.0 2.0 251.1 250.9 1.51 1.45 2 0.753 383K 209 0.0 0.0 L3 30/6 1.24 GB 1.0 3.2 1.7 1.5 3.2 1.7 0.5 1.8 194.7 194.1 16.92 14.50 12 1.410 3346K 11K 0.0 0.0 L4 166/6 9.53 GB 1.0 0.6 0.5 0.1 0.6 0.5 1.1 1.2 161.4 160.7 3.80 2.79 10 0.380 603K 2093 0.0 0.0 L5 1064/0 87.48 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1290/38 102.67 GB 0.0 13.2 5.8 7.4 19.7 12.3 5.5 3.0 169.8 254.0 79.36 71.90 140 0.567 13M 52K 0.0 0.0 Int 0/0 0.00 KB 0.0 13.2 5.8 7.4 19.7 12.3 5.4 3.0 169.8 254.0 79.36 71.90 140 0.567 13M 52K 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.2 5.8 7.4 13.1 5.7 0.0 0.0 227.4 226.5 59.24 54.62 45 1.316 13M 52K 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 335.1 20.11 17.28 95 0.212 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 26.9 total, 26.7 interval Flush(GB): cumulative 6.583, interval 6.583 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 19.68 GB write, 749.31 MB/s write, 13.16 GB read, 500.76 MB/s read, 79.4 seconds Interval compaction: 19.68 GB write, 754.69 MB/s write, 13.16 GB read, 504.35 MB/s read, 79.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: 28, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 11, total-stops: 28, interval: 39 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2515859 Average: 2.3172 StdDev: 14.66 Min: 1 Median: 1.4748 Max: 5352 Percentiles: P50: 1.47 P75: 1.86 P99: 5.84 P99.9: 12.24 P99.99: 154.36 ------------------------------------------------------ [ 0, 1 ] 481982 19.158% 19.158% #### ( 1, 2 ] 1634223 64.957% 84.115% ############# ( 2, 3 ] 217371 8.640% 92.755% ## ( 3, 4 ] 96600 3.840% 96.594% # ( 4, 6 ] 65639 2.609% 99.203% # ( 6, 10 ] 16453 0.654% 99.857% ( 10, 15 ] 2403 0.096% 99.953% ( 15, 22 ] 300 0.012% 99.965% ( 22, 34 ] 29 0.001% 99.966% ( 34, 51 ] 10 0.000% 99.966% ( 51, 76 ] 13 0.001% 99.967% ( 76, 110 ] 269 0.011% 99.977% ( 110, 170 ] 428 0.017% 99.994% ( 170, 250 ] 218 0.009% 100.003% ( 250, 380 ] 154 0.006% 100.009% ( 380, 580 ] 160 0.006% 100.016% ( 580, 870 ] 123 0.005% 100.021% ( 870, 1300 ] 68 0.003% 100.023% ( 1300, 1900 ] 28 0.001% 100.024% ( 1900, 2900 ] 17 0.001% 100.025% ( 2900, 4400 ] 11 0.000% 100.025% ( 4400, 6600 ] 1 0.000% 100.025% ** Level 1 read latency histogram (micros): Count: 592350 Average: 3.4668 StdDev: 31.55 Min: 1 Median: 1.7107 Max: 8183 Percentiles: P50: 1.71 P75: 2.47 P99: 8.80 P99.9: 76.38 P99.99: 279.57 ------------------------------------------------------ [ 0, 1 ] 43747 7.385% 7.385% # ( 1, 2 ] 355207 59.966% 67.351% ############ ( 2, 3 ] 96514 16.293% 83.644% ### ( 3, 4 ] 42584 7.189% 90.833% # ( 4, 6 ] 40907 6.906% 97.739% # ( 6, 10 ] 10651 1.798% 99.537% ( 10, 15 ] 1852 0.313% 99.850% ( 15, 22 ] 239 0.040% 99.890% ( 22, 34 ] 35 0.006% 99.896% ( 34, 51 ] 12 0.002% 99.898% ( 51, 76 ] 8 0.001% 99.900% ( 76, 110 ] 148 0.025% 99.925% ( 110, 170 ] 218 0.037% 99.962% ( 170, 250 ] 126 0.021% 99.983% ( 250, 380 ] 188 0.032% 100.015% ( 380, 580 ] 214 0.036% 100.051% ( 580, 870 ] 124 0.021% 100.072% ( 870, 1300 ] 59 0.010% 100.082% ( 1300, 1900 ] 29 0.005% 100.086% ( 1900, 2900 ] 14 0.002% 100.089% ( 2900, 4400 ] 10 0.002% 100.090% ( 4400, 6600 ] 2 0.000% 100.091% ( 6600, 9900 ] 1 0.000% 100.091% ** Level 2 read latency histogram (micros): Count: 95915 Average: 2.2819 StdDev: 15.40 Min: 0 Median: 1.3777 Max: 2561 Percentiles: P50: 1.38 P75: 1.79 P99: 5.63 P99.9: 14.48 P99.99: 754.27 ------------------------------------------------------ [ 0, 1 ] 25928 27.032% 27.032% ##### ( 1, 2 ] 58322 60.806% 87.838% ############ ( 2, 3 ] 6151 6.413% 94.251% # ( 3, 4 ] 3041 3.171% 97.422% # ( 4, 6 ] 1854 1.933% 99.355% ( 6, 10 ] 429 0.447% 99.802% ( 10, 15 ] 105 0.109% 99.911% ( 15, 22 ] 10 0.010% 99.922% ( 22, 34 ] 4 0.004% 99.926% ( 51, 76 ] 1 0.001% 99.927% ( 76, 110 ] 3 0.003% 99.930% ( 110, 170 ] 8 0.008% 99.938% ( 170, 250 ] 12 0.013% 99.951% ( 250, 380 ] 9 0.009% 99.960% ( 380, 580 ] 23 0.024% 99.984% ( 580, 870 ] 9 0.009% 99.994% ( 870, 1300 ] 5 0.005% 99.999% ( 1900, 2900 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 424914 Average: 5.1213 StdDev: 55.48 Min: 0 Median: 1.7985 Max: 4401 Percentiles: P50: 1.80 P75: 2.73 P99: 9.27 P99.9: 420.16 P99.99: 690.57 ------------------------------------------------------ [ 0, 1 ] 21822 5.136% 5.136% # ( 1, 2 ] 238743 56.186% 61.322% ########### ( 2, 3 ] 79326 18.669% 79.991% #### ( 3, 4 ] 37824 8.902% 88.892% ## ( 4, 6 ] 37395 8.801% 97.693% ## ( 6, 10 ] 6790 1.598% 99.291% ( 10, 15 ] 1232 0.290% 99.581% ( 15, 22 ] 161 0.038% 99.619% ( 22, 34 ] 49 0.012% 99.630% ( 34, 51 ] 5 0.001% 99.631% ( 51, 76 ] 5 0.001% 99.632% ( 76, 110 ] 77 0.018% 99.651% ( 110, 170 ] 301 0.071% 99.721% ( 170, 250 ] 314 0.074% 99.795% ( 250, 380 ] 373 0.088% 99.883% ( 380, 580 ] 364 0.086% 99.969% ( 580, 870 ] 240 0.056% 100.025% ( 870, 1300 ] 121 0.028% 100.054% ( 1300, 1900 ] 42 0.010% 100.064% ( 1900, 2900 ] 40 0.009% 100.073% ( 2900, 4400 ] 44 0.010% 100.083% ( 4400, 6600 ] 1 0.000% 100.084% ** Level 4 read latency histogram (micros): Count: 130 Average: 635.3692 StdDev: 1219.81 Min: 1 Median: 6.0000 Max: 5321 Percentiles: P50: 6.00 P75: 672.27 P99: 5170.00 P99.9: 5321.00 P99.99: 5321.00 ------------------------------------------------------ [ 0, 1 ] 19 14.615% 14.615% ### ( 1, 2 ] 27 20.769% 35.385% #### ( 2, 3 ] 9 6.923% 42.308% # ( 3, 4 ] 7 5.385% 47.692% # ( 4, 6 ] 3 2.308% 50.000% ( 6, 10 ] 1 0.769% 50.769% ( 10, 15 ] 1 0.769% 51.538% ( 15, 22 ] 3 2.308% 53.846% ( 51, 76 ] 3 2.308% 56.154% ( 76, 110 ] 1 0.769% 56.923% ( 110, 170 ] 5 3.846% 60.769% # ( 170, 250 ] 6 4.615% 65.385% # ( 250, 380 ] 7 5.385% 70.769% # ( 380, 580 ] 2 1.538% 72.308% ( 580, 870 ] 11 8.462% 80.769% ## ( 870, 1300 ] 5 3.846% 84.615% # ( 1300, 1900 ] 4 3.077% 87.692% # ( 1900, 2900 ] 5 3.846% 91.538% # ( 2900, 4400 ] 9 6.923% 98.462% # ( 4400, 6600 ] 2 1.538% 100.000% ** Level 5 read latency histogram (micros): Count: 100 Average: 770.4000 StdDev: 942.81 Min: 77 Median: 325.8333 Max: 3816 Percentiles: P50: 325.83 P75: 1013.33 P99: 3816.00 P99.9: 3816.00 P99.99: 3816.00 ------------------------------------------------------ ( 76, 110 ] 15 15.000% 15.000% ### ( 110, 170 ] 20 20.000% 35.000% #### ( 170, 250 ] 8 8.000% 43.000% ## ( 250, 380 ] 12 12.000% 55.000% ## ( 380, 580 ] 10 10.000% 65.000% ## ( 580, 870 ] 7 7.000% 72.000% # ( 870, 1300 ] 9 9.000% 81.000% ## ( 1300, 1900 ] 3 3.000% 84.000% # ( 1900, 2900 ] 11 11.000% 95.000% ## ( 2900, 4400 ] 5 5.000% 100.000% # ** DB Stats ** Uptime(secs): 26.9 total, 3.9 interval Cumulative writes: 0 writes, 7000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 6.73 GB, 256.10 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:7.809 H:M:S, 29.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 250.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:1.084 H:M:S, 27.6 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 8 num-running-flushes: 1 2024/11/21-00:18:16 ... thread 0: (1000000,8000000) ops and (243003.9,259548.4) ops/second in (4.115160,30.822771) 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.99 GB 188.8 6.5 0.0 6.5 14.0 7.6 0.0 1.9 136.3 295.7 48.53 44.54 131 0.370 6715K 8568 0.0 0.0 L1 13/13 1.41 GB 0.0 3.6 3.3 0.3 3.6 3.3 0.2 1.1 231.7 229.7 15.99 15.46 3 5.331 3762K 32K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 2.0 2.0 251.1 250.9 1.51 1.45 2 0.753 383K 209 0.0 0.0 L3 24/0 986.62 MB 1.0 3.2 1.7 1.5 3.2 1.7 0.5 1.8 194.7 194.1 16.92 14.50 12 1.410 3346K 11K 0.0 0.0 L4 168/0 9.43 GB 1.0 0.9 0.8 0.1 0.9 0.8 1.1 1.2 159.1 158.4 5.97 4.33 16 0.373 945K 3935 0.0 0.0 L5 1068/0 87.85 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 1292/22 103.65 GB 0.0 14.6 6.0 8.6 22.1 13.5 5.8 2.9 168.0 254.5 88.93 80.28 164 0.542 15M 56K 0.0 0.0 Int 0/0 0.00 KB 0.0 14.6 6.0 8.6 22.1 13.5 5.7 2.9 168.0 254.5 88.93 80.28 164 0.542 15M 56K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 14.6 6.0 8.6 14.5 6.0 0.0 0.0 227.2 226.3 65.78 60.44 55 1.196 15M 56K 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 334.8 23.15 19.84 109 0.212 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 31.0 total, 30.8 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.10 GB write, 729.73 MB/s write, 14.59 GB read, 481.75 MB/s read, 88.9 seconds Interval compaction: 22.10 GB write, 734.26 MB/s write, 14.59 GB read, 484.75 MB/s read, 88.9 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 16, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 16, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 37, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 16, total-stops: 37, interval: 53 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2935218 Average: 2.3228 StdDev: 15.20 Min: 1 Median: 1.4795 Max: 7045 Percentiles: P50: 1.48 P75: 1.86 P99: 5.87 P99.9: 12.15 P99.99: 141.24 ------------------------------------------------------ [ 0, 1 ] 551430 18.787% 18.787% #### ( 1, 2 ] 1910802 65.099% 83.886% ############# ( 2, 3 ] 257336 8.767% 92.653% ## ( 3, 4 ] 113585 3.870% 96.523% # ( 4, 6 ] 77812 2.651% 99.174% # ( 6, 10 ] 20080 0.684% 99.858% ( 10, 15 ] 2877 0.098% 99.956% ( 15, 22 ] 347 0.012% 99.968% ( 22, 34 ] 35 0.001% 99.969% ( 34, 51 ] 12 0.000% 99.969% ( 51, 76 ] 15 0.001% 99.970% ( 76, 110 ] 342 0.012% 99.981% ( 110, 170 ] 483 0.016% 99.998% ( 170, 250 ] 241 0.008% 100.006% ( 250, 380 ] 171 0.006% 100.012% ( 380, 580 ] 174 0.006% 100.018% ( 580, 870 ] 132 0.004% 100.022% ( 870, 1300 ] 75 0.003% 100.025% ( 1300, 1900 ] 31 0.001% 100.026% ( 1900, 2900 ] 24 0.001% 100.027% ( 2900, 4400 ] 13 0.000% 100.027% ( 4400, 6600 ] 1 0.000% 100.027% ( 6600, 9900 ] 1 0.000% 100.027% ** Level 1 read latency histogram (micros): Count: 659121 Average: 3.3741 StdDev: 30.15 Min: 1 Median: 1.6810 Max: 8183 Percentiles: P50: 1.68 P75: 2.37 P99: 8.76 P99.9: 91.38 P99.99: 295.36 ------------------------------------------------------ [ 0, 1 ] 57723 8.758% 8.758% ## ( 1, 2 ] 399203 60.566% 69.324% ############ ( 2, 3 ] 101192 15.353% 84.676% ### ( 3, 4 ] 44301 6.721% 91.397% # ( 4, 6 ] 42053 6.380% 97.777% # ( 6, 10 ] 11665 1.770% 99.547% ( 10, 15 ] 1900 0.288% 99.836% ( 15, 22 ] 243 0.037% 99.872% ( 22, 34 ] 35 0.005% 99.878% ( 34, 51 ] 13 0.002% 99.880% ( 51, 76 ] 33 0.005% 99.885% ( 76, 110 ] 223 0.034% 99.919% ( 110, 170 ] 255 0.039% 99.957% ( 170, 250 ] 147 0.022% 99.980% ( 250, 380 ] 198 0.030% 100.010% ( 380, 580 ] 232 0.035% 100.045% ( 580, 870 ] 129 0.020% 100.064% ( 870, 1300 ] 59 0.009% 100.073% ( 1300, 1900 ] 29 0.004% 100.078% ( 1900, 2900 ] 14 0.002% 100.080% ( 2900, 4400 ] 10 0.002% 100.081% ( 4400, 6600 ] 2 0.000% 100.082% ( 6600, 9900 ] 1 0.000% 100.082% ** Level 2 read latency histogram (micros): Count: 95915 Average: 2.2819 StdDev: 15.40 Min: 0 Median: 1.3777 Max: 2561 Percentiles: P50: 1.38 P75: 1.79 P99: 5.63 P99.9: 14.48 P99.99: 754.27 ------------------------------------------------------ [ 0, 1 ] 25928 27.032% 27.032% ##### ( 1, 2 ] 58322 60.806% 87.838% ############ ( 2, 3 ] 6151 6.413% 94.251% # ( 3, 4 ] 3041 3.171% 97.422% # ( 4, 6 ] 1854 1.933% 99.355% ( 6, 10 ] 429 0.447% 99.802% ( 10, 15 ] 105 0.109% 99.911% ( 15, 22 ] 10 0.010% 99.922% ( 22, 34 ] 4 0.004% 99.926% ( 51, 76 ] 1 0.001% 99.927% ( 76, 110 ] 3 0.003% 99.930% ( 110, 170 ] 8 0.008% 99.938% ( 170, 250 ] 12 0.013% 99.951% ( 250, 380 ] 9 0.009% 99.960% ( 380, 580 ] 23 0.024% 99.984% ( 580, 870 ] 9 0.009% 99.994% ( 870, 1300 ] 5 0.005% 99.999% ( 1900, 2900 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 497511 Average: 4.9211 StdDev: 55.42 Min: 0 Median: 1.8200 Max: 5021 Percentiles: P50: 1.82 P75: 2.79 P99: 9.06 P99.9: 319.18 P99.99: 530.14 ------------------------------------------------------ [ 0, 1 ] 23807 4.785% 4.785% # ( 1, 2 ] 274328 55.140% 59.925% ########### ( 2, 3 ] 95112 19.118% 79.043% #### ( 3, 4 ] 46734 9.394% 88.436% ## ( 4, 6 ] 46415 9.329% 97.766% ## ( 6, 10 ] 8035 1.615% 99.381% ( 10, 15 ] 1447 0.291% 99.672% ( 15, 22 ] 186 0.037% 99.709% ( 22, 34 ] 49 0.010% 99.719% ( 34, 51 ] 5 0.001% 99.720% ( 51, 76 ] 5 0.001% 99.721% ( 76, 110 ] 77 0.015% 99.736% ( 110, 170 ] 301 0.061% 99.797% ( 170, 250 ] 314 0.063% 99.860% ( 250, 380 ] 373 0.075% 99.935% ( 380, 580 ] 364 0.073% 100.008% ( 580, 870 ] 241 0.048% 100.057% ( 870, 1300 ] 122 0.025% 100.081% ( 1300, 1900 ] 42 0.008% 100.090% ( 1900, 2900 ] 41 0.008% 100.098% ( 2900, 4400 ] 56 0.011% 100.109% ( 4400, 6600 ] 2 0.000% 100.110% ** Level 4 read latency histogram (micros): Count: 190 Average: 486.6316 StdDev: 1075.78 Min: 1 Median: 3.0000 Max: 5321 Percentiles: P50: 3.00 P75: 306.88 P99: 4510.00 P99.9: 5321.00 P99.99: 5321.00 ------------------------------------------------------ [ 0, 1 ] 29 15.263% 15.263% ### ( 1, 2 ] 47 24.737% 40.000% ##### ( 2, 3 ] 19 10.000% 50.000% ## ( 3, 4 ] 13 6.842% 56.842% # ( 4, 6 ] 5 2.632% 59.474% # ( 6, 10 ] 1 0.526% 60.000% ( 10, 15 ] 1 0.526% 60.526% ( 15, 22 ] 3 1.579% 62.105% ( 51, 76 ] 3 1.579% 63.684% ( 76, 110 ] 1 0.526% 64.211% ( 110, 170 ] 10 5.263% 69.474% # ( 170, 250 ] 7 3.684% 73.158% # ( 250, 380 ] 8 4.211% 77.368% # ( 380, 580 ] 3 1.579% 78.947% ( 580, 870 ] 11 5.789% 84.737% # ( 870, 1300 ] 6 3.158% 87.895% # ( 1300, 1900 ] 5 2.632% 90.526% # ( 1900, 2900 ] 6 3.158% 93.684% # ( 2900, 4400 ] 10 5.263% 98.947% # ( 4400, 6600 ] 2 1.053% 100.000% ** Level 5 read latency histogram (micros): Count: 120 Average: 759.8333 StdDev: 909.28 Min: 77 Median: 325.8333 Max: 3816 Percentiles: P50: 325.83 P75: 1049.17 P99: 3816.00 P99.9: 3816.00 P99.99: 3816.00 ------------------------------------------------------ ( 76, 110 ] 18 15.000% 15.000% ### ( 110, 170 ] 25 20.833% 35.833% #### ( 170, 250 ] 10 8.333% 44.167% ## ( 250, 380 ] 12 10.000% 54.167% ## ( 380, 580 ] 12 10.000% 64.167% ## ( 580, 870 ] 8 6.667% 70.833% # ( 870, 1300 ] 12 10.000% 80.833% ## ( 1300, 1900 ] 5 4.167% 85.000% # ( 1900, 2900 ] 13 10.833% 95.833% ## ( 2900, 4400 ] 5 4.167% 100.000% # ** DB Stats ** Uptime(secs): 31.0 total, 4.1 interval Cumulative writes: 0 writes, 8000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 7.69 GB, 253.85 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:9.314 H:M:S, 30.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 239.16 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.504 H:M:S, 36.6 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/11/21-00:18:29 ... thread 0: (1000000,9000000) ops and (78963.5,206959.1) ops/second in (12.664075,43.486846) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 13/10 2.76 GB 18.9 7.9 0.0 7.9 16.4 8.5 0.0 1.9 142.1 295.0 56.75 52.27 150 0.378 8186K 10K 0.0 0.0 L1 22/22 2.51 GB 0.0 7.2 5.5 1.7 7.1 5.4 0.2 1.3 226.1 223.5 32.52 31.06 4 8.130 7466K 84K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 3.1 2.0 251.1 250.9 1.51 1.45 2 0.753 383K 209 0.0 0.0 L3 19/1 1.07 GB 1.0 4.8 2.6 2.2 4.8 2.6 0.6 1.8 196.0 195.0 25.14 21.90 19 1.323 5004K 24K 0.0 0.0 L4 166/3 9.69 GB 1.0 2.3 1.8 0.5 2.3 1.8 1.1 1.3 172.4 171.3 13.51 10.58 29 0.466 2346K 14K 0.0 0.0 L5 1076/0 88.46 GB 0.9 0.0 0.0 0.0 0.0 0.0 2.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1296/36 104.50 GB 0.0 22.5 10.1 12.5 30.9 18.4 7.6 3.6 178.1 244.2 129.43 117.26 204 0.634 23M 134K 0.0 0.0 Int 0/0 0.00 KB 0.0 22.5 10.1 12.5 30.9 18.4 7.5 3.6 178.1 244.2 129.43 117.26 204 0.634 23M 134K 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 22.5 10.1 12.5 22.4 9.9 0.0 0.0 222.9 221.6 103.41 94.97 80 1.293 23M 134K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 8.5 8.5 0.0 0.0 0.0 334.1 26.02 22.29 124 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): 43.7 total, 43.5 interval Flush(GB): cumulative 8.490, interval 8.490 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 30.87 GB write, 723.62 MB/s write, 22.51 GB read, 527.69 MB/s read, 129.4 seconds Interval compaction: 30.87 GB write, 726.81 MB/s write, 22.51 GB read, 530.01 MB/s read, 129.4 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 24, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 24, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 38, pending-compaction-bytes-delays: 19, pending-compaction-bytes-stops: 0, total-delays: 43, total-stops: 38, interval: 81 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3707288 Average: 2.4051 StdDev: 16.90 Min: 0 Median: 1.4811 Max: 7045 Percentiles: P50: 1.48 P75: 1.87 P99: 5.94 P99.9: 13.64 P99.99: 228.12 ------------------------------------------------------ [ 0, 1 ] 696365 18.784% 18.784% #### ( 1, 2 ] 2405270 64.880% 83.663% ############# ( 2, 3 ] 324595 8.756% 92.419% ## ( 3, 4 ] 145297 3.919% 96.338% # ( 4, 6 ] 101916 2.749% 99.087% # ( 6, 10 ] 27401 0.739% 99.826% ( 10, 15 ] 3757 0.101% 99.928% ( 15, 22 ] 599 0.016% 99.944% ( 22, 34 ] 45 0.001% 99.945% ( 34, 51 ] 15 0.000% 99.945% ( 51, 76 ] 22 0.001% 99.946% ( 76, 110 ] 612 0.017% 99.962% ( 110, 170 ] 745 0.020% 99.982% ( 170, 250 ] 383 0.010% 99.993% ( 250, 380 ] 296 0.008% 100.001% ( 380, 580 ] 320 0.009% 100.009% ( 580, 870 ] 254 0.007% 100.016% ( 870, 1300 ] 140 0.004% 100.020% ( 1300, 1900 ] 61 0.002% 100.022% ( 1900, 2900 ] 29 0.001% 100.022% ( 2900, 4400 ] 21 0.001% 100.023% ( 4400, 6600 ] 1 0.000% 100.023% ( 6600, 9900 ] 1 0.000% 100.023% ** Level 1 read latency histogram (micros): Count: 1187851 Average: 3.1967 StdDev: 26.18 Min: 1 Median: 1.6339 Max: 8183 Percentiles: P50: 1.63 P75: 2.22 P99: 8.77 P99.9: 93.66 P99.99: 265.01 ------------------------------------------------------ [ 0, 1 ] 141984 11.953% 11.953% ## ( 1, 2 ] 712981 60.023% 71.976% ############ ( 2, 3 ] 161277 13.577% 85.553% ### ( 3, 4 ] 74422 6.265% 91.818% # ( 4, 6 ] 70427 5.929% 97.747% # ( 6, 10 ] 21490 1.809% 99.556% ( 10, 15 ] 3194 0.269% 99.825% ( 15, 22 ] 433 0.036% 99.862% ( 22, 34 ] 47 0.004% 99.866% ( 34, 51 ] 15 0.001% 99.867% ( 51, 76 ] 82 0.007% 99.874% ( 76, 110 ] 599 0.050% 99.924% ( 110, 170 ] 494 0.042% 99.966% ( 170, 250 ] 252 0.021% 99.987% ( 250, 380 ] 305 0.026% 100.013% ( 380, 580 ] 355 0.030% 100.043% ( 580, 870 ] 207 0.017% 100.060% ( 870, 1300 ] 101 0.009% 100.069% ( 1300, 1900 ] 40 0.003% 100.072% ( 1900, 2900 ] 16 0.001% 100.073% ( 2900, 4400 ] 14 0.001% 100.074% ( 4400, 6600 ] 2 0.000% 100.075% ( 6600, 9900 ] 1 0.000% 100.075% ** Level 2 read latency histogram (micros): Count: 95915 Average: 2.2819 StdDev: 15.40 Min: 0 Median: 1.3777 Max: 2561 Percentiles: P50: 1.38 P75: 1.79 P99: 5.63 P99.9: 14.48 P99.99: 754.27 ------------------------------------------------------ [ 0, 1 ] 25928 27.032% 27.032% ##### ( 1, 2 ] 58322 60.806% 87.838% ############ ( 2, 3 ] 6151 6.413% 94.251% # ( 3, 4 ] 3041 3.171% 97.422% # ( 4, 6 ] 1854 1.933% 99.355% ( 6, 10 ] 429 0.447% 99.802% ( 10, 15 ] 105 0.109% 99.911% ( 15, 22 ] 10 0.010% 99.922% ( 22, 34 ] 4 0.004% 99.926% ( 51, 76 ] 1 0.001% 99.927% ( 76, 110 ] 3 0.003% 99.930% ( 110, 170 ] 8 0.008% 99.938% ( 170, 250 ] 12 0.013% 99.951% ( 250, 380 ] 9 0.009% 99.960% ( 380, 580 ] 23 0.024% 99.984% ( 580, 870 ] 9 0.009% 99.994% ( 870, 1300 ] 5 0.005% 99.999% ( 1900, 2900 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 972887 Average: 4.6537 StdDev: 46.44 Min: 0 Median: 1.8286 Max: 5021 Percentiles: P50: 1.83 P75: 2.82 P99: 9.20 P99.9: 246.21 P99.99: 417.06 ------------------------------------------------------ [ 0, 1 ] 42483 4.367% 4.367% # ( 1, 2 ] 535809 55.074% 59.441% ########### ( 2, 3 ] 184044 18.917% 78.358% #### ( 3, 4 ] 93181 9.578% 87.936% ## ( 4, 6 ] 93311 9.591% 97.527% ## ( 6, 10 ] 17921 1.842% 99.369% ( 10, 15 ] 3088 0.317% 99.687% ( 15, 22 ] 406 0.042% 99.728% ( 22, 34 ] 58 0.006% 99.734% ( 34, 51 ] 7 0.001% 99.735% ( 51, 76 ] 11 0.001% 99.736% ( 76, 110 ] 263 0.027% 99.763% ( 110, 170 ] 691 0.071% 99.834% ( 170, 250 ] 673 0.069% 99.903% ( 250, 380 ] 719 0.074% 99.977% ( 380, 580 ] 673 0.069% 100.046% ( 580, 870 ] 471 0.048% 100.095% ( 870, 1300 ] 217 0.022% 100.117% ( 1300, 1900 ] 61 0.006% 100.123% ( 1900, 2900 ] 49 0.005% 100.128% ( 2900, 4400 ] 67 0.007% 100.135% ( 4400, 6600 ] 2 0.000% 100.135% ** Level 4 read latency histogram (micros): Count: 59354 Average: 10.5547 StdDev: 115.08 Min: 1 Median: 1.9295 Max: 7045 Percentiles: P50: 1.93 P75: 3.17 P99: 164.85 P99.9: 1263.02 P99.99: 3563.88 ------------------------------------------------------ [ 0, 1 ] 2043 3.442% 3.442% # ( 1, 2 ] 29729 50.088% 53.530% ########## ( 2, 3 ] 11692 19.699% 73.228% #### ( 3, 4 ] 6198 10.442% 83.671% ## ( 4, 6 ] 6739 11.354% 95.025% ## ( 6, 10 ] 1726 2.908% 97.933% # ( 10, 15 ] 386 0.650% 98.583% ( 15, 22 ] 56 0.094% 98.677% ( 22, 34 ] 1 0.002% 98.679% ( 34, 51 ] 2 0.003% 98.682% ( 51, 76 ] 3 0.005% 98.688% ( 76, 110 ] 52 0.088% 98.775% ( 110, 170 ] 146 0.246% 99.021% ( 170, 250 ] 148 0.249% 99.270% ( 250, 380 ] 126 0.212% 99.483% ( 380, 580 ] 139 0.234% 99.717% ( 580, 870 ] 73 0.123% 99.840% ( 870, 1300 ] 39 0.066% 99.906% ( 1300, 1900 ] 17 0.029% 99.934% ( 1900, 2900 ] 22 0.037% 99.971% ( 2900, 4400 ] 25 0.042% 100.013% ( 4400, 6600 ] 4 0.007% 100.020% ( 6600, 9900 ] 1 0.002% 100.022% ** Level 5 read latency histogram (micros): Count: 160 Average: 804.7250 StdDev: 953.58 Min: 77 Median: 363.7500 Max: 4167 Percentiles: P50: 363.75 P75: 1099.33 P99: 4133.33 P99.9: 4167.00 P99.99: 4167.00 ------------------------------------------------------ ( 76, 110 ] 20 12.500% 12.500% ### ( 110, 170 ] 33 20.625% 33.125% #### ( 170, 250 ] 13 8.125% 41.250% ## ( 250, 380 ] 16 10.000% 51.250% ## ( 380, 580 ] 18 11.250% 62.500% ## ( 580, 870 ] 12 7.500% 70.000% ## ( 870, 1300 ] 15 9.375% 79.375% ## ( 1300, 1900 ] 9 5.625% 85.000% # ( 1900, 2900 ] 15 9.375% 94.375% ## ( 2900, 4400 ] 9 5.625% 100.000% # ** DB Stats ** Uptime(secs): 43.7 total, 12.7 interval Cumulative writes: 0 writes, 9000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 8.65 GB, 202.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:19.095 H:M:S, 43.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 77.72 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:9.781 H:M:S, 77.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 using bdev Nvme0n1 Initializing RocksDB Options from the specified file Initializing RocksDB Options from command-line flags Integrated BlobDB: blob cache disabled Keys: 16 bytes each (+ 0 bytes user-defined timestamp) Values: 1000 bytes each (1000 bytes after compression) Entries: 100000000 Prefix: 0 bytes Keys per prefix: 0 RawSize: 96893.3 MB (estimated) FileSize: 96893.3 MB (estimated) Write rate: 0 bytes/second Read rate: 0 ops/second Compression: NoCompression Compression sampling rate: 0 Memtablerep: SkipListFactory Perf Level: 1 ------------------------------------------------ DB path: [/mnt/rocksdb] overwrite : 6.205 micros/op 161169 ops/sec 60.167 seconds 9696999 operations; 156.2 MB/s Microseconds per write: Count: 9696999 Average: 6.2047 StdDev: 305.95 Min: 0 Median: 1.7398 Max: 363743 Percentiles: P50: 1.74 P75: 2.77 P99: 9.59 P99.9: 1184.94 P99.99: 2701.33 ------------------------------------------------------ [ 0, 1 ] 1303322 13.440% 13.440% ### ( 1, 2 ] 4792228 49.420% 62.860% ########## ( 2, 3 ] 1530812 15.786% 78.647% ### ( 3, 4 ] 1330830 13.724% 92.371% ### ( 4, 6 ] 538410 5.552% 97.923% # ( 6, 10 ] 116221 1.199% 99.122% ( 10, 15 ] 40298 0.416% 99.537% ( 15, 22 ] 9447 0.097% 99.635% ( 22, 34 ] 1905 0.020% 99.654% ( 34, 51 ] 221 0.002% 99.657% ( 51, 76 ] 35 0.000% 99.657% ( 76, 110 ] 6532 0.067% 99.724% ( 110, 170 ] 2839 0.029% 99.754% ( 170, 250 ] 288 0.003% 99.757% ( 250, 380 ] 178 0.002% 99.758% ( 380, 580 ] 30 0.000% 99.759% ( 580, 870 ] 12 0.000% 99.759% ( 870, 1300 ] 18697 0.193% 99.952% ( 1300, 1900 ] 39 0.000% 99.952% ( 1900, 2900 ] 4599 0.047% 99.999% ( 2900, 4400 ] 27 0.000% 100.000% ( 4400, 6600 ] 3 0.000% 100.000% ( 6600, 9900 ] 3 0.000% 100.000% ( 9900, 14000 ] 2 0.000% 100.000% ( 14000, 22000 ] 2 0.000% 100.000% ( 22000, 33000 ] 2 0.000% 100.000% ( 33000, 50000 ] 1 0.000% 100.000% ( 110000, 170000 ] 1 0.000% 100.000% ( 170000, 250000 ] 11 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 : 222110 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 : 9696999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 10007302968 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 : 486 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 33320958 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 : 30717427543 rocksdb.compact.write.bytes COUNT : 30510354658 rocksdb.flush.write.bytes COUNT : 9974601459 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 : 47 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 : 234 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 : 9894283264 rocksdb.memtable.garbage.bytes.at.flush COUNT : 3954688 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 : 30804019117 rocksdb.non.last.level.read.count COUNT : 7446415 rocksdb.block.checksum.compute.count COUNT : 7445490 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.386637 P95 : 3.935668 P99 : 8.190172 P100 : 363741.000000 COUNT : 9696999 SUM : 55595162 rocksdb.compaction.times.micros P50 : 1005714.285714 P95 : 3273333.333333 P99 : 15280000.000000 P100 : 16530258.000000 COUNT : 84 SUM : 110155175 rocksdb.compaction.times.cpu_micros P50 : 955625.000000 P95 : 3273333.333333 P99 : 15280000.000000 P100 : 15601445.000000 COUNT : 84 SUM : 101629596 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 : 674.565217 P95 : 1550.000000 P99 : 8745.000000 P100 : 159853.000000 COUNT : 135 SUM : 262949 rocksdb.compaction.outfile.sync.micros P50 : 868.993056 P95 : 15428.571429 P99 : 48512.500000 P100 : 131422.000000 COUNT : 335 SUM : 1117374 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.534884 P95 : 371.875000 P99 : 1085.000000 P100 : 1921.000000 COUNT : 250 SUM : 38329 rocksdb.table.open.io.micros P50 : 1219.375000 P95 : 5870.526316 P99 : 11786.000000 P100 : 12700.000000 COUNT : 486 SUM : 857391 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.572562 P95 : 7.200455 P99 : 9.994999 P100 : 10905.000000 COUNT : 7444089 SUM : 37153610 rocksdb.read.block.get.micros P50 : 398.691589 P95 : 2887.500000 P99 : 4267.142857 P100 : 6978.000000 COUNT : 972 SUM : 709948 rocksdb.write.raw.block.micros P50 : 0.511929 P95 : 0.972664 P99 : 2.889510 P100 : 10225.000000 COUNT : 9805151 SUM : 18329688 rocksdb.numfiles.in.singlecompaction P50 : 3.194030 P95 : 4.900000 P99 : 20.320000 P100 : 32.000000 COUNT : 124 SUM : 470 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.560872 P95 : 1158.573257 P99 : 2435.701200 P100 : 363517.000000 COUNT : 215681 SUM : 33340622 rocksdb.sst.read.micros P50 : 1.527664 P95 : 4.245252 P99 : 7.858268 P100 : 8183.000000 COUNT : 7446581 SUM : 21972381 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 : 9696999 SUM : 10007302968 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 : 211649.484536 P95 : 365781.250000 P99 : 518700.000000 P100 : 536464.000000 COUNT : 135 SUM : 28332340 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 : 324 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