[2024-07-14 10:22:00.259737] Starting SPDK v24.09-pre git sha1 719d03c6a / DPDK 23.11.0 initialization... [2024-07-14 10:22:00.260003] [ 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_pid527189 ] Set seed to 1720945320253305 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-07-14 10:22:00.369557] app.c: 908:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-07-14 10:22:00.409047] app.c: 603:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-07-14 10:22:00.409095] app.c: 604:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 527189' to capture a snapshot of events at runtime. [2024-07-14 10:22:00.409105] app.c: 609:app_setup_trace: *NOTICE*: 'spdk_trace' without parameters will also work if this is the only [2024-07-14 10:22:00.409119] app.c: 610:app_setup_trace: *NOTICE*: SPDK application currently running. [2024-07-14 10:22:00.409126] app.c: 611:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid527189 for offline analysis/debug. [2024-07-14 10:22:00.409216] reactor.c: 941:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Sun Jul 14 10:22:04 2024 CPU: 96 * Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz CPUCache: 36608 KB 2024/07/14-10:22:07 ... thread 0: (1000000,1000000) ops and (362070.0,362070.0) ops/second in (2.761897,2.761897) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 8/5 504.02 MB 18.9 0.0 0.0 0.0 0.8 0.8 0.0 1.0 0.0 356.4 2.30 2.08 12 0.191 0 0 0.0 0.0 L1 3/3 251.76 MB 0.0 0.2 0.2 0.1 0.2 0.2 0.1 1.3 256.1 255.9 0.98 0.96 1 0.984 255K 197 0.0 0.0 L2 1/0 48.70 MB 0.5 0.1 0.1 0.0 0.1 0.1 0.0 1.8 230.8 230.8 0.48 0.46 1 0.482 112K 33 0.0 0.0 L3 16/0 755.45 MB 0.8 0.1 0.1 0.0 0.1 0.1 0.0 1.0 198.3 198.4 0.32 0.26 1 0.315 63K 0 0.0 0.0 L4 116/0 9.47 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.94 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 1188/8 96.94 GB 0.0 0.4 0.3 0.1 1.2 1.1 0.2 1.5 104.4 305.1 4.08 3.75 15 0.272 432K 230 0.0 0.0 Int 0/0 0.00 KB 0.0 0.4 0.3 0.1 1.2 1.1 0.2 1.5 104.4 305.1 4.08 3.75 15 0.272 432K 230 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.3 0.1 0.4 0.3 0.0 0.0 239.1 238.9 1.78 1.68 3 0.594 432K 230 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 0.8 0.8 0.0 0.0 0.0 356.4 2.30 2.08 12 0.191 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.0 total, 2.8 interval Flush(GB): cumulative 0.800, interval 0.800 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.22 GB write, 419.50 MB/s write, 0.42 GB read, 143.51 MB/s read, 4.1 seconds Interval compaction: 1.22 GB write, 450.32 MB/s write, 0.42 GB read, 154.05 MB/s read, 4.1 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 4, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 4, interval: 4 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 97052 Average: 1.8472 StdDev: 21.66 Min: 1 Median: 1.1571 Max: 3926 Percentiles: P50: 1.16 P75: 1.61 P99: 3.40 P99.9: 9.61 P99.99: 321.39 ------------------------------------------------------ [ 0, 1 ] 40088 41.306% 41.306% ######## ( 1, 2 ] 53706 55.337% 96.643% ########### ( 2, 3 ] 1982 2.042% 98.685% ( 3, 4 ] 764 0.787% 99.472% ( 4, 6 ] 305 0.314% 99.787% ( 6, 10 ] 123 0.127% 99.913% ( 10, 15 ] 54 0.056% 99.969% ( 15, 22 ] 6 0.006% 99.975% ( 51, 76 ] 1 0.001% 99.976% ( 110, 170 ] 9 0.009% 99.986% ( 170, 250 ] 2 0.002% 99.988% ( 250, 380 ] 6 0.006% 99.994% ( 580, 870 ] 1 0.001% 99.995% ( 870, 1300 ] 2 0.002% 99.997% ( 2900, 4400 ] 4 0.004% 100.001% ** Level 1 read latency histogram (micros): Count: 25710 Average: 2.2032 StdDev: 16.26 Min: 1 Median: 1.1861 Max: 1235 Percentiles: P50: 1.19 P75: 1.65 P99: 5.76 P99.9: 82.27 P99.99: 1023.62 ------------------------------------------------------ [ 0, 1 ] 10252 39.876% 39.876% ######## ( 1, 2 ] 13986 54.399% 94.275% ########### ( 2, 3 ] 852 3.314% 97.588% # ( 3, 4 ] 205 0.797% 98.386% ( 4, 6 ] 179 0.696% 99.082% ( 6, 10 ] 129 0.502% 99.584% ( 10, 15 ] 20 0.078% 99.662% ( 15, 22 ] 6 0.023% 99.685% ( 34, 51 ] 45 0.175% 99.860% ( 51, 76 ] 9 0.035% 99.895% ( 76, 110 ] 7 0.027% 99.922% ( 110, 170 ] 2 0.008% 99.930% ( 170, 250 ] 4 0.016% 99.946% ( 250, 380 ] 6 0.023% 99.969% ( 380, 580 ] 2 0.008% 99.977% ( 580, 870 ] 2 0.008% 99.984% ( 870, 1300 ] 4 0.016% 100.000% ** Level 2 read latency histogram (micros): Count: 15880 Average: 1.7533 StdDev: 3.59 Min: 1 Median: 1.2117 Max: 281 Percentiles: P50: 1.21 P75: 1.65 P99: 3.56 P99.9: 9.56 P99.99: 276.78 ------------------------------------------------------ [ 0, 1 ] 6010 37.846% 37.846% ######## ( 1, 2 ] 9115 57.399% 95.246% ########### ( 2, 3 ] 519 3.268% 98.514% # ( 3, 4 ] 138 0.869% 99.383% ( 4, 6 ] 59 0.372% 99.754% ( 6, 10 ] 26 0.164% 99.918% ( 10, 15 ] 9 0.057% 99.975% ( 110, 170 ] 1 0.006% 99.981% ( 170, 250 ] 1 0.006% 99.987% ( 250, 380 ] 2 0.013% 100.000% ** Level 3 read latency histogram (micros): Count: 80 Average: 721.7125 StdDev: 1041.98 Min: 1 Median: 170.0000 Max: 4202 Percentiles: P50: 170.00 P75: 1061.11 P99: 4160.00 P99.9: 4202.00 P99.99: 4202.00 ------------------------------------------------------ [ 0, 1 ] 18 22.500% 22.500% ##### ( 1, 2 ] 19 23.750% 46.250% ##### ( 2, 3 ] 1 1.250% 47.500% ( 76, 110 ] 1 1.250% 48.750% ( 110, 170 ] 1 1.250% 50.000% ( 170, 250 ] 1 1.250% 51.250% ( 250, 380 ] 3 3.750% 55.000% # ( 380, 580 ] 4 5.000% 60.000% # ( 580, 870 ] 8 10.000% 70.000% ## ( 870, 1300 ] 9 11.250% 81.250% ## ( 1300, 1900 ] 3 3.750% 85.000% # ( 1900, 2900 ] 7 8.750% 93.750% ## ( 2900, 4400 ] 5 6.250% 100.000% # ** Level 4 read latency histogram (micros): Count: 35 Average: 1711.6857 StdDev: 1224.22 Min: 203 Median: 1342.8571 Max: 4353 Percentiles: P50: 1342.86 P75: 2462.50 P99: 4325.00 P99.9: 4353.00 P99.99: 4353.00 ------------------------------------------------------ ( 170, 250 ] 2 5.714% 5.714% # ( 250, 380 ] 1 2.857% 8.571% # ( 380, 580 ] 3 8.571% 17.143% ## ( 580, 870 ] 7 20.000% 37.143% #### ( 870, 1300 ] 4 11.429% 48.571% ## ( 1300, 1900 ] 7 20.000% 68.571% #### ( 1900, 2900 ] 4 11.429% 80.000% ## ( 2900, 4400 ] 7 20.000% 100.000% #### ** DB Stats ** Uptime(secs): 3.0 total, 2.8 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 331.72 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:0.202 H:M:S, 6.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 356.04 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.202 H:M:S, 7.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/07/14-10:22:10 ... thread 0: (1000000,2000000) ops and (330494.6,345562.5) ops/second in (3.025768,5.787665) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 11/10 1.17 GB 6.3 0.5 0.0 0.5 2.3 1.8 0.0 1.3 72.2 333.8 6.98 6.42 28 0.249 511K 534 0.0 0.0 L1 6/6 565.47 MB 0.0 0.8 0.5 0.3 0.8 0.5 0.1 1.6 245.9 245.4 3.33 3.24 2 1.665 831K 1435 0.0 0.0 L2 1/0 48.70 MB 0.5 0.1 0.1 0.0 0.1 0.1 0.0 1.8 230.8 230.8 0.48 0.46 1 0.482 112K 33 0.0 0.0 L3 16/0 755.45 MB 0.8 0.1 0.1 0.0 0.1 0.1 0.0 1.0 198.3 198.4 0.32 0.26 1 0.315 63K 0 0.0 0.0 L4 116/0 9.47 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.94 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 1194/16 97.92 GB 0.0 1.5 0.6 0.8 3.2 2.4 0.2 1.8 134.7 299.0 11.11 10.38 32 0.347 1519K 2002 0.0 0.0 Int 0/0 0.00 KB 0.0 1.5 0.6 0.8 3.2 2.4 0.2 1.8 134.7 299.0 11.11 10.38 32 0.347 1519K 2002 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 1.5 0.6 0.8 1.5 0.6 0.0 0.0 251.9 251.5 5.94 5.74 6 0.990 1519K 2002 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 353.6 5.17 4.64 26 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): 6.0 total, 5.8 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.24 GB write, 554.27 MB/s write, 1.46 GB read, 249.74 MB/s read, 11.1 seconds Interval compaction: 3.24 GB write, 573.70 MB/s write, 1.46 GB read, 258.50 MB/s read, 11.1 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 8, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 8, interval: 8 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 331948 Average: 2.0054 StdDev: 13.90 Min: 1 Median: 1.3567 Max: 3926 Percentiles: P50: 1.36 P75: 1.76 P99: 5.00 P99.9: 10.23 P99.99: 68.53 ------------------------------------------------------ [ 0, 1 ] 92120 27.751% 27.751% ###### ( 1, 2 ] 207050 62.374% 90.126% ############ ( 2, 3 ] 20723 6.243% 96.368% # ( 3, 4 ] 6897 2.078% 98.446% ( 4, 6 ] 3667 1.105% 99.551% ( 6, 10 ] 1149 0.346% 99.897% ( 10, 15 ] 260 0.078% 99.975% ( 15, 22 ] 40 0.012% 99.987% ( 22, 34 ] 5 0.002% 99.989% ( 34, 51 ] 3 0.001% 99.990% ( 51, 76 ] 4 0.001% 99.991% ( 110, 170 ] 19 0.006% 99.997% ( 170, 250 ] 5 0.002% 99.998% ( 250, 380 ] 11 0.003% 100.002% ( 380, 580 ] 1 0.000% 100.002% ( 580, 870 ] 8 0.002% 100.004% ( 870, 1300 ] 3 0.001% 100.005% ( 1300, 1900 ] 4 0.001% 100.006% ( 1900, 2900 ] 1 0.000% 100.007% ( 2900, 4400 ] 4 0.001% 100.008% ** Level 1 read latency histogram (micros): Count: 95839 Average: 2.1072 StdDev: 12.26 Min: 1 Median: 1.3695 Max: 1688 Percentiles: P50: 1.37 P75: 1.77 P99: 5.16 P99.9: 19.31 P99.99: 620.22 ------------------------------------------------------ [ 0, 1 ] 25725 26.842% 26.842% ##### ( 1, 2 ] 60062 62.670% 89.512% ############# ( 2, 3 ] 6736 7.028% 96.540% # ( 3, 4 ] 1751 1.827% 98.367% ( 4, 6 ] 1050 1.096% 99.463% ( 6, 10 ] 350 0.365% 99.828% ( 10, 15 ] 63 0.066% 99.894% ( 15, 22 ] 10 0.010% 99.904% ( 34, 51 ] 45 0.047% 99.951% ( 51, 76 ] 10 0.010% 99.961% ( 76, 110 ] 7 0.007% 99.969% ( 110, 170 ] 3 0.003% 99.972% ( 170, 250 ] 4 0.004% 99.976% ( 250, 380 ] 10 0.010% 99.986% ( 380, 580 ] 3 0.003% 99.990% ( 580, 870 ] 3 0.003% 99.993% ( 870, 1300 ] 5 0.005% 99.998% ( 1300, 1900 ] 2 0.002% 100.000% ** Level 2 read latency histogram (micros): Count: 15880 Average: 1.7533 StdDev: 3.59 Min: 1 Median: 1.2117 Max: 281 Percentiles: P50: 1.21 P75: 1.65 P99: 3.56 P99.9: 9.56 P99.99: 276.78 ------------------------------------------------------ [ 0, 1 ] 6010 37.846% 37.846% ######## ( 1, 2 ] 9115 57.399% 95.246% ########### ( 2, 3 ] 519 3.268% 98.514% # ( 3, 4 ] 138 0.869% 99.383% ( 4, 6 ] 59 0.372% 99.754% ( 6, 10 ] 26 0.164% 99.918% ( 10, 15 ] 9 0.057% 99.975% ( 110, 170 ] 1 0.006% 99.981% ( 170, 250 ] 1 0.006% 99.987% ( 250, 380 ] 2 0.013% 100.000% ** Level 3 read latency histogram (micros): Count: 80 Average: 721.7125 StdDev: 1041.98 Min: 1 Median: 170.0000 Max: 4202 Percentiles: P50: 170.00 P75: 1061.11 P99: 4160.00 P99.9: 4202.00 P99.99: 4202.00 ------------------------------------------------------ [ 0, 1 ] 18 22.500% 22.500% ##### ( 1, 2 ] 19 23.750% 46.250% ##### ( 2, 3 ] 1 1.250% 47.500% ( 76, 110 ] 1 1.250% 48.750% ( 110, 170 ] 1 1.250% 50.000% ( 170, 250 ] 1 1.250% 51.250% ( 250, 380 ] 3 3.750% 55.000% # ( 380, 580 ] 4 5.000% 60.000% # ( 580, 870 ] 8 10.000% 70.000% ## ( 870, 1300 ] 9 11.250% 81.250% ## ( 1300, 1900 ] 3 3.750% 85.000% # ( 1900, 2900 ] 7 8.750% 93.750% ## ( 2900, 4400 ] 5 6.250% 100.000% # ** Level 4 read latency histogram (micros): Count: 35 Average: 1711.6857 StdDev: 1224.22 Min: 203 Median: 1342.8571 Max: 4353 Percentiles: P50: 1342.86 P75: 2462.50 P99: 4325.00 P99.9: 4353.00 P99.99: 4353.00 ------------------------------------------------------ ( 170, 250 ] 2 5.714% 5.714% # ( 250, 380 ] 1 2.857% 8.571% # ( 380, 580 ] 3 8.571% 17.143% ## ( 580, 870 ] 7 20.000% 37.143% #### ( 870, 1300 ] 4 11.429% 48.571% ## ( 1300, 1900 ] 7 20.000% 68.571% #### ( 1900, 2900 ] 4 11.429% 80.000% ## ( 2900, 4400 ] 7 20.000% 100.000% #### ** DB Stats ** Uptime(secs): 6.0 total, 3.0 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 328.47 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.619 H:M:S, 10.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 325.28 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.417 H:M:S, 13.8 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/07/14-10:22:13 ... thread 0: (1000000,3000000) ops and (331787.6,340845.5) ops/second in (3.013976,8.801641) 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/10 2.09 GB 100.7 1.4 0.0 1.4 4.1 2.7 0.0 1.5 106.8 320.3 12.97 12.05 44 0.295 1407K 1547 0.0 0.0 L1 6/6 565.47 MB 0.0 0.8 0.5 0.3 0.8 0.5 0.1 1.6 245.9 245.4 3.33 3.24 2 1.665 831K 1435 0.0 0.0 L2 1/0 48.70 MB 0.5 0.1 0.1 0.0 0.1 0.1 0.0 1.8 230.8 230.8 0.48 0.46 1 0.482 112K 33 0.0 0.0 L3 16/0 755.45 MB 0.8 0.1 0.1 0.0 0.1 0.1 0.0 1.0 198.3 198.4 0.32 0.26 1 0.315 63K 0 0.0 0.0 L4 116/0 9.47 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.94 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 1198/16 98.84 GB 0.0 2.3 0.6 1.7 5.0 3.3 0.2 1.9 139.1 301.0 17.10 16.01 48 0.356 2415K 3015 0.0 0.0 Int 0/0 0.00 KB 0.0 2.3 0.6 1.7 5.0 3.3 0.2 1.9 139.1 301.0 17.10 16.01 48 0.356 2415K 3015 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.3 0.6 1.7 2.3 0.6 0.0 0.0 256.0 255.6 9.29 9.01 9 1.032 2415K 3015 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 354.9 7.81 7.00 39 0.200 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.0 total, 8.8 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: 5.03 GB write, 571.51 MB/s write, 2.32 GB read, 264.09 MB/s read, 17.1 seconds Interval compaction: 5.03 GB write, 584.69 MB/s write, 2.32 GB read, 270.18 MB/s read, 17.1 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 11, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 11, interval: 11 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 689691 Average: 2.1154 StdDev: 11.68 Min: 1 Median: 1.4515 Max: 3926 Percentiles: P50: 1.45 P75: 1.83 P99: 5.41 P99.9: 9.87 P99.99: 14.59 ------------------------------------------------------ [ 0, 1 ] 140830 20.419% 20.419% #### ( 1, 2 ] 451874 65.518% 85.938% ############# ( 2, 3 ] 62318 9.036% 94.973% ## ( 3, 4 ] 19507 2.828% 97.802% # ( 4, 6 ] 11724 1.700% 99.502% ( 6, 10 ] 2839 0.412% 99.913% ( 10, 15 ] 577 0.084% 99.997% ( 15, 22 ] 61 0.009% 100.006% ( 22, 34 ] 9 0.001% 100.007% ( 34, 51 ] 8 0.001% 100.008% ( 51, 76 ] 5 0.001% 100.009% ( 110, 170 ] 24 0.003% 100.012% ( 170, 250 ] 12 0.002% 100.014% ( 250, 380 ] 17 0.002% 100.017% ( 380, 580 ] 3 0.000% 100.017% ( 580, 870 ] 12 0.002% 100.019% ( 870, 1300 ] 7 0.001% 100.020% ( 1300, 1900 ] 6 0.001% 100.021% ( 1900, 2900 ] 2 0.000% 100.021% ( 2900, 4400 ] 5 0.001% 100.022% ** Level 1 read latency histogram (micros): Count: 165969 Average: 2.1404 StdDev: 9.33 Min: 1 Median: 1.4535 Max: 1688 Percentiles: P50: 1.45 P75: 1.83 P99: 5.35 P99.9: 11.94 P99.99: 333.24 ------------------------------------------------------ [ 0, 1 ] 33613 20.253% 20.253% #### ( 1, 2 ] 108878 65.601% 85.854% ############# ( 2, 3 ] 15765 9.499% 95.353% ## ( 3, 4 ] 4253 2.563% 97.915% # ( 4, 6 ] 2660 1.603% 99.518% ( 6, 10 ] 596 0.359% 99.877% ( 10, 15 ] 98 0.059% 99.936% ( 15, 22 ] 14 0.008% 99.945% ( 34, 51 ] 45 0.027% 99.972% ( 51, 76 ] 10 0.006% 99.978% ( 76, 110 ] 7 0.004% 99.982% ( 110, 170 ] 3 0.002% 99.984% ( 170, 250 ] 4 0.002% 99.986% ( 250, 380 ] 10 0.006% 99.992% ( 380, 580 ] 3 0.002% 99.994% ( 580, 870 ] 3 0.002% 99.996% ( 870, 1300 ] 5 0.003% 99.999% ( 1300, 1900 ] 2 0.001% 100.000% ** Level 2 read latency histogram (micros): Count: 15880 Average: 1.7533 StdDev: 3.59 Min: 1 Median: 1.2117 Max: 281 Percentiles: P50: 1.21 P75: 1.65 P99: 3.56 P99.9: 9.56 P99.99: 276.78 ------------------------------------------------------ [ 0, 1 ] 6010 37.846% 37.846% ######## ( 1, 2 ] 9115 57.399% 95.246% ########### ( 2, 3 ] 519 3.268% 98.514% # ( 3, 4 ] 138 0.869% 99.383% ( 4, 6 ] 59 0.372% 99.754% ( 6, 10 ] 26 0.164% 99.918% ( 10, 15 ] 9 0.057% 99.975% ( 110, 170 ] 1 0.006% 99.981% ( 170, 250 ] 1 0.006% 99.987% ( 250, 380 ] 2 0.013% 100.000% ** Level 3 read latency histogram (micros): Count: 80 Average: 721.7125 StdDev: 1041.98 Min: 1 Median: 170.0000 Max: 4202 Percentiles: P50: 170.00 P75: 1061.11 P99: 4160.00 P99.9: 4202.00 P99.99: 4202.00 ------------------------------------------------------ [ 0, 1 ] 18 22.500% 22.500% ##### ( 1, 2 ] 19 23.750% 46.250% ##### ( 2, 3 ] 1 1.250% 47.500% ( 76, 110 ] 1 1.250% 48.750% ( 110, 170 ] 1 1.250% 50.000% ( 170, 250 ] 1 1.250% 51.250% ( 250, 380 ] 3 3.750% 55.000% # ( 380, 580 ] 4 5.000% 60.000% # ( 580, 870 ] 8 10.000% 70.000% ## ( 870, 1300 ] 9 11.250% 81.250% ## ( 1300, 1900 ] 3 3.750% 85.000% # ( 1900, 2900 ] 7 8.750% 93.750% ## ( 2900, 4400 ] 5 6.250% 100.000% # ** Level 4 read latency histogram (micros): Count: 35 Average: 1711.6857 StdDev: 1224.22 Min: 203 Median: 1342.8571 Max: 4353 Percentiles: P50: 1342.86 P75: 2462.50 P99: 4325.00 P99.9: 4353.00 P99.99: 4353.00 ------------------------------------------------------ ( 170, 250 ] 2 5.714% 5.714% # ( 250, 380 ] 1 2.857% 8.571% # ( 380, 580 ] 3 8.571% 17.143% ## ( 580, 870 ] 7 20.000% 37.143% #### ( 870, 1300 ] 4 11.429% 48.571% ## ( 1300, 1900 ] 7 20.000% 68.571% #### ( 1900, 2900 ] 4 11.429% 80.000% ## ( 2900, 4400 ] 7 20.000% 100.000% #### ** DB Stats ** Uptime(secs): 9.0 total, 3.0 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 327.82 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.020 H:M:S, 11.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 326.54 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.400 H:M:S, 13.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/07/14-10:22:16 ... thread 0: (1000000,4000000) ops and (329065.5,337822.1) ops/second in (3.038909,11.840550) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 14/4 2.21 GB 195.1 2.1 0.0 2.1 5.8 3.7 0.0 1.6 114.9 317.6 18.64 17.33 61 0.306 2174K 2316 0.0 0.0 L1 12/0 1.40 GB 143.8 2.2 1.4 0.9 2.2 1.3 0.1 1.6 234.6 233.5 9.66 9.33 3 3.219 2300K 9841 0.0 0.0 L2 1/0 48.70 MB 0.5 0.1 0.1 0.0 0.1 0.1 0.0 1.8 230.8 230.8 0.48 0.46 1 0.482 112K 33 0.0 0.0 L3 16/0 755.45 MB 0.8 0.1 0.1 0.0 0.1 0.1 0.0 1.0 198.3 198.4 0.32 0.26 1 0.315 63K 0 0.0 0.0 L4 116/0 9.47 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.94 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 1203/4 99.82 GB 0.0 4.5 1.5 3.0 8.2 5.2 0.2 2.2 157.5 287.0 29.09 27.38 66 0.441 4651K 12K 0.0 0.0 Int 0/0 0.00 KB 0.0 4.5 1.5 3.0 8.2 5.2 0.2 2.2 157.5 287.0 29.09 27.38 66 0.441 4651K 12K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 4.5 1.5 3.0 4.5 1.5 0.0 0.0 247.9 247.2 18.48 17.89 13 1.422 4651K 12K 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 356.2 10.61 9.49 53 0.200 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.0 total, 11.8 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.15 GB write, 693.10 MB/s write, 4.47 GB read, 380.35 MB/s read, 29.1 seconds Interval compaction: 8.15 GB write, 704.99 MB/s write, 4.47 GB read, 386.87 MB/s read, 29.1 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 16, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 16, interval: 16 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 975138 Average: 2.1554 StdDev: 12.20 Min: 0 Median: 1.4533 Max: 3926 Percentiles: P50: 1.45 P75: 1.83 P99: 5.45 P99.9: 10.48 P99.99: 78.99 ------------------------------------------------------ [ 0, 1 ] 198008 20.306% 20.306% #### ( 1, 2 ] 638787 65.507% 85.813% ############# ( 2, 3 ] 89132 9.140% 94.953% ## ( 3, 4 ] 27464 2.816% 97.770% # ( 4, 6 ] 16561 1.698% 99.468% ( 6, 10 ] 4131 0.424% 99.892% ( 10, 15 ] 836 0.086% 99.978% ( 15, 22 ] 88 0.009% 99.987% ( 22, 34 ] 10 0.001% 99.988% ( 34, 51 ] 10 0.001% 99.989% ( 51, 76 ] 9 0.001% 99.990% ( 76, 110 ] 51 0.005% 99.995% ( 110, 170 ] 93 0.010% 100.004% ( 170, 250 ] 51 0.005% 100.010% ( 250, 380 ] 35 0.004% 100.013% ( 380, 580 ] 18 0.002% 100.015% ( 580, 870 ] 22 0.002% 100.017% ( 870, 1300 ] 16 0.002% 100.019% ( 1300, 1900 ] 7 0.001% 100.020% ( 1900, 2900 ] 3 0.000% 100.020% ( 2900, 4400 ] 7 0.001% 100.021% ** Level 1 read latency histogram (micros): Count: 219845 Average: 2.3889 StdDev: 15.17 Min: 0 Median: 1.4717 Max: 2215 Percentiles: P50: 1.47 P75: 1.85 P99: 5.55 P99.9: 83.70 P99.99: 797.87 ------------------------------------------------------ [ 0, 1 ] 41255 18.765% 18.765% #### ( 1, 2 ] 145573 66.216% 84.982% ############# ( 2, 3 ] 22019 10.016% 94.997% ## ( 3, 4 ] 5878 2.674% 97.671% # ( 4, 6 ] 3773 1.716% 99.387% ( 6, 10 ] 922 0.419% 99.807% ( 10, 15 ] 118 0.054% 99.860% ( 15, 22 ] 18 0.008% 99.869% ( 34, 51 ] 46 0.021% 99.889% ( 51, 76 ] 15 0.007% 99.896% ( 76, 110 ] 36 0.016% 99.913% ( 110, 170 ] 76 0.035% 99.947% ( 170, 250 ] 40 0.018% 99.965% ( 250, 380 ] 30 0.014% 99.979% ( 380, 580 ] 15 0.007% 99.986% ( 580, 870 ] 12 0.005% 99.991% ( 870, 1300 ] 13 0.006% 99.997% ( 1300, 1900 ] 4 0.002% 99.999% ( 1900, 2900 ] 2 0.001% 100.000% ** Level 2 read latency histogram (micros): Count: 15880 Average: 1.7533 StdDev: 3.59 Min: 1 Median: 1.2117 Max: 281 Percentiles: P50: 1.21 P75: 1.65 P99: 3.56 P99.9: 9.56 P99.99: 276.78 ------------------------------------------------------ [ 0, 1 ] 6010 37.846% 37.846% ######## ( 1, 2 ] 9115 57.399% 95.246% ########### ( 2, 3 ] 519 3.268% 98.514% # ( 3, 4 ] 138 0.869% 99.383% ( 4, 6 ] 59 0.372% 99.754% ( 6, 10 ] 26 0.164% 99.918% ( 10, 15 ] 9 0.057% 99.975% ( 110, 170 ] 1 0.006% 99.981% ( 170, 250 ] 1 0.006% 99.987% ( 250, 380 ] 2 0.013% 100.000% ** Level 3 read latency histogram (micros): Count: 80 Average: 721.7125 StdDev: 1041.98 Min: 1 Median: 170.0000 Max: 4202 Percentiles: P50: 170.00 P75: 1061.11 P99: 4160.00 P99.9: 4202.00 P99.99: 4202.00 ------------------------------------------------------ [ 0, 1 ] 18 22.500% 22.500% ##### ( 1, 2 ] 19 23.750% 46.250% ##### ( 2, 3 ] 1 1.250% 47.500% ( 76, 110 ] 1 1.250% 48.750% ( 110, 170 ] 1 1.250% 50.000% ( 170, 250 ] 1 1.250% 51.250% ( 250, 380 ] 3 3.750% 55.000% # ( 380, 580 ] 4 5.000% 60.000% # ( 580, 870 ] 8 10.000% 70.000% ## ( 870, 1300 ] 9 11.250% 81.250% ## ( 1300, 1900 ] 3 3.750% 85.000% # ( 1900, 2900 ] 7 8.750% 93.750% ## ( 2900, 4400 ] 5 6.250% 100.000% # ** Level 4 read latency histogram (micros): Count: 35 Average: 1711.6857 StdDev: 1224.22 Min: 203 Median: 1342.8571 Max: 4353 Percentiles: P50: 1342.86 P75: 2462.50 P99: 4325.00 P99.9: 4353.00 P99.99: 4353.00 ------------------------------------------------------ ( 170, 250 ] 2 5.714% 5.714% # ( 250, 380 ] 1 2.857% 8.571% # ( 380, 580 ] 3 8.571% 17.143% ## ( 580, 870 ] 7 20.000% 37.143% #### ( 870, 1300 ] 4 11.429% 48.571% ## ( 1300, 1900 ] 7 20.000% 68.571% #### ( 1900, 2900 ] 4 11.429% 80.000% ## ( 2900, 4400 ] 7 20.000% 100.000% #### ** DB Stats ** Uptime(secs): 12.0 total, 3.0 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 326.82 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.437 H:M:S, 11.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 323.86 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.418 H:M:S, 13.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/07/14-10:22:19 ... thread 0: (1000000,5000000) ops and (337285.2,337714.6) ops/second in (2.964850,14.805400) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 16/14 3.20 GB 12.6 3.2 0.0 3.2 7.9 4.7 0.0 1.7 128.1 315.2 25.57 23.90 79 0.324 3326K 3542 0.0 0.0 L1 12/12 1.40 GB 0.0 2.2 1.4 0.9 2.2 1.3 0.1 1.6 234.6 233.5 9.66 9.33 3 3.219 2300K 9841 0.0 0.0 L2 1/0 48.70 MB 0.5 0.1 0.1 0.0 0.1 0.1 0.0 1.8 230.8 230.8 0.48 0.46 1 0.482 112K 33 0.0 0.0 L3 16/0 755.45 MB 0.8 0.1 0.1 0.0 0.1 0.1 0.0 1.0 198.3 198.4 0.32 0.26 1 0.315 63K 0 0.0 0.0 L4 116/0 9.47 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.94 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 1205/26 100.80 GB 0.0 5.6 1.5 4.1 10.2 6.1 0.2 2.2 158.6 291.2 36.03 33.96 84 0.429 5803K 13K 0.0 0.0 Int 0/0 0.00 KB 0.0 5.6 1.5 4.1 10.2 6.1 0.2 2.2 158.6 291.2 36.03 33.96 84 0.429 5803K 13K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 5.6 1.5 4.1 5.6 1.5 0.0 0.0 252.1 251.5 22.67 22.01 17 1.333 5803K 13K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 4.7 4.7 0.0 0.0 0.0 358.4 13.36 11.95 67 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): 15.0 total, 14.8 interval Flush(GB): cumulative 4.676, interval 4.676 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 10.24 GB write, 698.81 MB/s write, 5.58 GB read, 380.76 MB/s read, 36.0 seconds Interval compaction: 10.24 GB write, 708.39 MB/s write, 5.58 GB read, 385.98 MB/s read, 36.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: 20, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 20, interval: 20 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1225119 Average: 2.1465 StdDev: 12.41 Min: 0 Median: 1.4354 Max: 3926 Percentiles: P50: 1.44 P75: 1.82 P99: 5.37 P99.9: 11.40 P99.99: 129.46 ------------------------------------------------------ [ 0, 1 ] 265229 21.649% 21.649% #### ( 1, 2 ] 797773 65.118% 86.767% ############# ( 2, 3 ] 104487 8.529% 95.296% ## ( 3, 4 ] 32453 2.649% 97.945% # ( 4, 6 ] 18890 1.542% 99.487% ( 6, 10 ] 4765 0.389% 99.876% ( 10, 15 ] 1061 0.087% 99.962% ( 15, 22 ] 111 0.009% 99.971% ( 22, 34 ] 12 0.001% 99.972% ( 34, 51 ] 12 0.001% 99.973% ( 51, 76 ] 12 0.001% 99.974% ( 76, 110 ] 137 0.011% 99.986% ( 110, 170 ] 168 0.014% 99.999% ( 170, 250 ] 76 0.006% 100.005% ( 250, 380 ] 51 0.004% 100.010% ( 380, 580 ] 23 0.002% 100.012% ( 580, 870 ] 34 0.003% 100.014% ( 870, 1300 ] 20 0.002% 100.016% ( 1300, 1900 ] 8 0.001% 100.017% ( 1900, 2900 ] 7 0.001% 100.017% ( 2900, 4400 ] 7 0.001% 100.018% ** Level 1 read latency histogram (micros): Count: 224428 Average: 2.4169 StdDev: 15.23 Min: 0 Median: 1.4698 Max: 2215 Percentiles: P50: 1.47 P75: 1.85 P99: 5.60 P99.9: 104.36 P99.99: 793.20 ------------------------------------------------------ [ 0, 1 ] 42639 18.999% 18.999% #### ( 1, 2 ] 148085 65.983% 84.982% ############# ( 2, 3 ] 22314 9.943% 94.925% ## ( 3, 4 ] 6074 2.706% 97.631% # ( 4, 6 ] 3829 1.706% 99.337% ( 6, 10 ] 984 0.438% 99.776% ( 10, 15 ] 128 0.057% 99.833% ( 15, 22 ] 22 0.010% 99.843% ( 34, 51 ] 46 0.020% 99.863% ( 51, 76 ] 15 0.007% 99.870% ( 76, 110 ] 81 0.036% 99.906% ( 110, 170 ] 87 0.039% 99.945% ( 170, 250 ] 44 0.020% 99.964% ( 250, 380 ] 32 0.014% 99.979% ( 380, 580 ] 16 0.007% 99.986% ( 580, 870 ] 13 0.006% 99.992% ( 870, 1300 ] 13 0.006% 99.997% ( 1300, 1900 ] 4 0.002% 99.999% ( 1900, 2900 ] 2 0.001% 100.000% ** Level 2 read latency histogram (micros): Count: 15880 Average: 1.7533 StdDev: 3.59 Min: 1 Median: 1.2117 Max: 281 Percentiles: P50: 1.21 P75: 1.65 P99: 3.56 P99.9: 9.56 P99.99: 276.78 ------------------------------------------------------ [ 0, 1 ] 6010 37.846% 37.846% ######## ( 1, 2 ] 9115 57.399% 95.246% ########### ( 2, 3 ] 519 3.268% 98.514% # ( 3, 4 ] 138 0.869% 99.383% ( 4, 6 ] 59 0.372% 99.754% ( 6, 10 ] 26 0.164% 99.918% ( 10, 15 ] 9 0.057% 99.975% ( 110, 170 ] 1 0.006% 99.981% ( 170, 250 ] 1 0.006% 99.987% ( 250, 380 ] 2 0.013% 100.000% ** Level 3 read latency histogram (micros): Count: 80 Average: 721.7125 StdDev: 1041.98 Min: 1 Median: 170.0000 Max: 4202 Percentiles: P50: 170.00 P75: 1061.11 P99: 4160.00 P99.9: 4202.00 P99.99: 4202.00 ------------------------------------------------------ [ 0, 1 ] 18 22.500% 22.500% ##### ( 1, 2 ] 19 23.750% 46.250% ##### ( 2, 3 ] 1 1.250% 47.500% ( 76, 110 ] 1 1.250% 48.750% ( 110, 170 ] 1 1.250% 50.000% ( 170, 250 ] 1 1.250% 51.250% ( 250, 380 ] 3 3.750% 55.000% # ( 380, 580 ] 4 5.000% 60.000% # ( 580, 870 ] 8 10.000% 70.000% ## ( 870, 1300 ] 9 11.250% 81.250% ## ( 1300, 1900 ] 3 3.750% 85.000% # ( 1900, 2900 ] 7 8.750% 93.750% ## ( 2900, 4400 ] 5 6.250% 100.000% # ** Level 4 read latency histogram (micros): Count: 35 Average: 1711.6857 StdDev: 1224.22 Min: 203 Median: 1342.8571 Max: 4353 Percentiles: P50: 1342.86 P75: 2462.50 P99: 4325.00 P99.9: 4353.00 P99.99: 4353.00 ------------------------------------------------------ ( 170, 250 ] 2 5.714% 5.714% # ( 250, 380 ] 1 2.857% 8.571% # ( 380, 580 ] 3 8.571% 17.143% ## ( 580, 870 ] 7 20.000% 37.143% #### ( 870, 1300 ] 4 11.429% 48.571% ## ( 1300, 1900 ] 7 20.000% 68.571% #### ( 1900, 2900 ] 4 11.429% 80.000% ## ( 2900, 4400 ] 7 20.000% 100.000% #### ** DB Stats ** Uptime(secs): 15.0 total, 3.0 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 327.84 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.826 H:M:S, 12.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 331.95 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.389 H:M:S, 13.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/07/14-10:22:41 ... thread 0: (1000000,6000000) ops and (46442.0,165118.0) ops/second in (21.532243,36.337643) 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 3/3 1.17 GB 0.0 5.1 0.0 5.1 10.8 5.7 0.0 1.9 146.4 310.3 35.70 33.63 100 0.357 5308K 7413 0.0 0.0 L1 8/8 887.05 MB 0.0 6.7 4.4 2.3 6.6 4.3 0.1 1.5 219.2 215.9 31.25 28.87 4 7.814 6956K 102K 0.0 0.0 L2 29/5 3.57 GB 30.9 0.1 0.1 0.0 0.1 0.1 3.6 1.8 230.8 230.8 0.48 0.46 1 0.482 112K 33 0.0 0.0 L3 16/9 755.45 MB 0.0 0.1 0.1 0.0 0.1 0.1 0.0 1.0 198.3 198.4 0.32 0.26 1 0.315 63K 0 0.0 0.0 L4 116/0 9.47 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.94 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 1216/25 101.75 GB 0.0 12.0 4.5 7.4 17.6 10.2 3.7 3.1 180.8 265.7 67.76 63.21 106 0.639 12M 109K 0.0 0.0 Int 0/0 0.00 KB 0.0 12.0 4.5 7.4 17.6 10.2 3.7 3.1 180.8 265.7 67.76 63.21 106 0.639 12M 109K 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 12.0 4.5 7.4 11.9 4.4 0.0 0.0 238.3 236.2 51.41 48.58 23 2.235 12M 109K 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 358.4 16.35 14.63 83 0.197 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 36.5 total, 36.3 interval Flush(GB): cumulative 5.722, interval 5.722 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 17.58 GB write, 492.62 MB/s write, 11.97 GB read, 335.29 MB/s read, 67.8 seconds Interval compaction: 17.58 GB write, 495.37 MB/s write, 11.97 GB read, 337.16 MB/s read, 67.8 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: 21, pending-compaction-bytes-delays: 8, pending-compaction-bytes-stops: 0, total-delays: 16, total-stops: 21, interval: 37 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2511491 Average: 2.6853 StdDev: 16.49 Min: 0 Median: 1.4149 Max: 3926 Percentiles: P50: 1.41 P75: 1.80 P99: 5.89 P99.9: 152.70 P99.99: 409.73 ------------------------------------------------------ [ 0, 1 ] 580396 23.110% 23.110% ##### ( 1, 2 ] 1627796 64.814% 87.924% ############# ( 2, 3 ] 182565 7.269% 95.193% # ( 3, 4 ] 61987 2.468% 97.661% ( 4, 6 ] 35530 1.415% 99.076% ( 6, 10 ] 9561 0.381% 99.456% ( 10, 15 ] 2169 0.086% 99.543% ( 15, 22 ] 299 0.012% 99.555% ( 22, 34 ] 39 0.002% 99.556% ( 34, 51 ] 27 0.001% 99.557% ( 51, 76 ] 84 0.003% 99.561% ( 76, 110 ] 5696 0.227% 99.787% ( 110, 170 ] 3979 0.158% 99.946% ( 170, 250 ] 594 0.024% 99.969% ( 250, 380 ] 453 0.018% 99.987% ( 380, 580 ] 443 0.018% 100.005% ( 580, 870 ] 149 0.006% 100.011% ( 870, 1300 ] 39 0.002% 100.013% ( 1300, 1900 ] 16 0.001% 100.013% ( 1900, 2900 ] 15 0.001% 100.014% ( 2900, 4400 ] 15 0.001% 100.014% ** Level 1 read latency histogram (micros): Count: 590258 Average: 2.7391 StdDev: 18.66 Min: 0 Median: 1.4028 Max: 3784 Percentiles: P50: 1.40 P75: 1.80 P99: 6.73 P99.9: 161.03 P99.99: 855.62 ------------------------------------------------------ [ 0, 1 ] 146051 24.744% 24.744% ##### ( 1, 2 ] 370065 62.695% 87.439% ############# ( 2, 3 ] 42067 7.127% 94.566% # ( 3, 4 ] 15257 2.585% 97.151% # ( 4, 6 ] 10316 1.748% 98.898% ( 6, 10 ] 3272 0.554% 99.453% ( 10, 15 ] 560 0.095% 99.548% ( 15, 22 ] 92 0.016% 99.563% ( 22, 34 ] 8 0.001% 99.565% ( 34, 51 ] 49 0.008% 99.573% ( 51, 76 ] 49 0.008% 99.581% ( 76, 110 ] 987 0.167% 99.748% ( 110, 170 ] 1052 0.178% 99.927% ( 170, 250 ] 154 0.026% 99.953% ( 250, 380 ] 94 0.016% 99.969% ( 380, 580 ] 68 0.012% 99.980% ( 580, 870 ] 61 0.010% 99.991% ( 870, 1300 ] 37 0.006% 99.997% ( 1300, 1900 ] 14 0.002% 99.999% ( 1900, 2900 ] 3 0.001% 100.000% ( 2900, 4400 ] 2 0.000% 100.000% ** Level 2 read latency histogram (micros): Count: 15885 Average: 1.8336 StdDev: 6.19 Min: 1 Median: 1.2120 Max: 480 Percentiles: P50: 1.21 P75: 1.65 P99: 3.60 P99.9: 11.18 P99.99: 354.50 ------------------------------------------------------ [ 0, 1 ] 6010 37.834% 37.834% ######## ( 1, 2 ] 9115 57.381% 95.216% ########### ( 2, 3 ] 519 3.267% 98.483% # ( 3, 4 ] 138 0.869% 99.352% ( 4, 6 ] 59 0.371% 99.723% ( 6, 10 ] 26 0.164% 99.887% ( 10, 15 ] 9 0.057% 99.943% ( 110, 170 ] 2 0.013% 99.956% ( 170, 250 ] 3 0.019% 99.975% ( 250, 380 ] 3 0.019% 99.994% ( 380, 580 ] 1 0.006% 100.000% ** Level 3 read latency histogram (micros): Count: 5840 Average: 19.7747 StdDev: 159.84 Min: 1 Median: 1.6799 Max: 4202 Percentiles: P50: 1.68 P75: 2.44 P99: 536.80 P99.9: 2780.00 P99.99: 4202.00 ------------------------------------------------------ [ 0, 1 ] 615 10.531% 10.531% ## ( 1, 2 ] 3390 58.048% 68.579% ############ ( 2, 3 ] 851 14.572% 83.151% ### ( 3, 4 ] 413 7.072% 90.223% # ( 4, 6 ] 259 4.435% 94.658% # ( 6, 10 ] 118 2.021% 96.678% ( 10, 15 ] 20 0.342% 97.021% ( 15, 22 ] 4 0.068% 97.089% ( 76, 110 ] 11 0.188% 97.277% ( 110, 170 ] 32 0.548% 97.825% ( 170, 250 ] 20 0.342% 98.168% ( 250, 380 ] 29 0.497% 98.664% ( 380, 580 ] 25 0.428% 99.092% ( 580, 870 ] 24 0.411% 99.503% ( 870, 1300 ] 13 0.223% 99.726% ( 1300, 1900 ] 4 0.068% 99.795% ( 1900, 2900 ] 7 0.120% 99.914% ( 2900, 4400 ] 5 0.086% 100.000% ** Level 4 read latency histogram (micros): Count: 35 Average: 1711.6857 StdDev: 1224.22 Min: 203 Median: 1342.8571 Max: 4353 Percentiles: P50: 1342.86 P75: 2462.50 P99: 4325.00 P99.9: 4353.00 P99.99: 4353.00 ------------------------------------------------------ ( 170, 250 ] 2 5.714% 5.714% # ( 250, 380 ] 1 2.857% 8.571% # ( 380, 580 ] 3 8.571% 17.143% ## ( 580, 870 ] 7 20.000% 37.143% #### ( 870, 1300 ] 4 11.429% 48.571% ## ( 1300, 1900 ] 7 20.000% 68.571% #### ( 1900, 2900 ] 4 11.429% 80.000% ## ( 2900, 4400 ] 7 20.000% 100.000% #### ** DB Stats ** Uptime(secs): 36.5 total, 21.5 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 161.60 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.883 H:M:S, 54.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 45.71 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:18.057 H:M:S, 83.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 0 2024/07/14-10:22:48 ... thread 0: (1000000,7000000) ops and (137416.7,160496.0) ops/second in (7.277138,43.614781) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 9/7 2.09 GB 56.6 5.7 0.0 5.7 12.3 6.6 0.0 1.9 137.3 298.4 42.19 38.38 114 0.370 5884K 8022 0.0 0.0 L1 8/8 887.05 MB 0.0 6.7 4.4 2.3 6.6 4.3 0.1 1.5 219.2 215.9 31.25 28.87 4 7.814 6956K 102K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.0 0.1 0.1 3.6 1.8 230.8 230.8 0.48 0.46 1 0.482 112K 33 0.0 0.0 L3 24/1 1.07 GB 1.0 4.8 3.5 1.3 4.8 3.5 0.1 1.4 137.7 137.6 35.78 22.57 26 1.376 4449K 1289 0.0 0.0 L4 150/0 9.76 GB 1.0 0.0 0.0 0.0 0.0 0.0 3.2 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1080/0 88.89 GB 0.9 0.0 0.0 0.0 0.0 0.0 3.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1271/16 102.67 GB 0.0 17.3 8.0 9.3 23.8 14.5 10.0 3.6 161.2 222.2 109.71 90.27 145 0.757 17M 111K 0.0 0.0 Int 0/0 0.00 KB 0.0 17.3 8.0 9.3 23.8 14.5 10.0 3.6 161.2 222.2 109.71 90.27 145 0.757 17M 111K 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 17.3 8.0 9.3 17.2 7.9 0.0 0.0 197.8 196.5 89.42 73.14 50 1.788 17M 111K 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.2 20.30 17.13 95 0.214 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.8 total, 43.6 interval Flush(GB): cumulative 6.644, interval 6.644 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 23.80 GB write, 556.23 MB/s write, 17.27 GB read, 403.54 MB/s read, 109.7 seconds Interval compaction: 23.80 GB write, 558.82 MB/s write, 17.27 GB read, 405.42 MB/s read, 109.7 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: 47, pending-compaction-bytes-delays: 17, pending-compaction-bytes-stops: 0, total-delays: 25, total-stops: 47, interval: 72 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2917041 Average: 2.8661 StdDev: 25.85 Min: 0 Median: 1.4611 Max: 7081 Percentiles: P50: 1.46 P75: 1.85 P99: 6.91 P99.9: 152.19 P99.99: 500.98 ------------------------------------------------------ [ 0, 1 ] 599971 20.568% 20.568% #### ( 1, 2 ] 1862095 63.835% 84.403% ############# ( 2, 3 ] 263906 9.047% 93.450% ## ( 3, 4 ] 91555 3.139% 96.589% # ( 4, 6 ] 66328 2.274% 98.862% ( 6, 10 ] 17581 0.603% 99.465% ( 10, 15 ] 3564 0.122% 99.587% ( 15, 22 ] 446 0.015% 99.603% ( 22, 34 ] 49 0.002% 99.604% ( 34, 51 ] 27 0.001% 99.605% ( 51, 76 ] 94 0.003% 99.608% ( 76, 110 ] 5701 0.195% 99.804% ( 110, 170 ] 3993 0.137% 99.941% ( 170, 250 ] 631 0.022% 99.962% ( 250, 380 ] 502 0.017% 99.979% ( 380, 580 ] 508 0.017% 99.997% ( 580, 870 ] 233 0.008% 100.005% ( 870, 1300 ] 107 0.004% 100.009% ( 1300, 1900 ] 53 0.002% 100.010% ( 1900, 2900 ] 44 0.002% 100.012% ( 2900, 4400 ] 52 0.002% 100.014% ( 4400, 6600 ] 12 0.000% 100.014% ( 6600, 9900 ] 2 0.000% 100.014% ** Level 1 read latency histogram (micros): Count: 1538638 Average: 7.1162 StdDev: 109.19 Min: 0 Median: 1.7405 Max: 8877 Percentiles: P50: 1.74 P75: 2.61 P99: 9.41 P99.9: 165.36 P99.99: 459.63 ------------------------------------------------------ [ 0, 1 ] 156425 10.166% 10.166% ## ( 1, 2 ] 827684 53.793% 63.960% ########### ( 2, 3 ] 278460 18.098% 82.058% #### ( 3, 4 ] 117785 7.655% 89.713% ## ( 4, 6 ] 117494 7.636% 97.349% ## ( 6, 10 ] 29794 1.936% 99.285% ( 10, 15 ] 6013 0.391% 99.676% ( 15, 22 ] 790 0.051% 99.727% ( 22, 34 ] 62 0.004% 99.732% ( 34, 51 ] 64 0.004% 99.736% ( 51, 76 ] 67 0.004% 99.740% ( 76, 110 ] 1094 0.071% 99.811% ( 110, 170 ] 1482 0.096% 99.907% ( 170, 250 ] 554 0.036% 99.943% ( 250, 380 ] 486 0.032% 99.975% ( 380, 580 ] 578 0.038% 100.013% ( 580, 870 ] 583 0.038% 100.050% ( 870, 1300 ] 499 0.032% 100.083% ( 1300, 1900 ] 363 0.024% 100.107% ( 1900, 2900 ] 586 0.038% 100.145% ( 2900, 4400 ] 655 0.043% 100.187% ( 4400, 6600 ] 140 0.009% 100.196% ( 6600, 9900 ] 24 0.002% 100.198% ** Level 2 read latency histogram (micros): Count: 28248 Average: 2.9374 StdDev: 23.52 Min: 1 Median: 1.3776 Max: 1545 Percentiles: P50: 1.38 P75: 1.78 P99: 6.81 P99.9: 359.89 P99.99: 945.34 ------------------------------------------------------ [ 0, 1 ] 7541 26.696% 26.696% ##### ( 1, 2 ] 17432 61.711% 88.406% ############ ( 2, 3 ] 1931 6.836% 95.242% # ( 3, 4 ] 582 2.060% 97.302% ( 4, 6 ] 433 1.533% 98.835% ( 6, 10 ] 230 0.814% 99.650% ( 10, 15 ] 19 0.067% 99.717% ( 15, 22 ] 1 0.004% 99.720% ( 76, 110 ] 2 0.007% 99.727% ( 110, 170 ] 19 0.067% 99.795% ( 170, 250 ] 12 0.042% 99.837% ( 250, 380 ] 21 0.074% 99.911% ( 380, 580 ] 13 0.046% 99.958% ( 580, 870 ] 9 0.032% 99.989% ( 870, 1300 ] 1 0.004% 99.993% ( 1300, 1900 ] 2 0.007% 100.000% ** Level 3 read latency histogram (micros): Count: 355678 Average: 5.0825 StdDev: 60.45 Min: 0 Median: 1.8315 Max: 5583 Percentiles: P50: 1.83 P75: 2.75 P99: 9.49 P99.9: 436.04 P99.99: 859.53 ------------------------------------------------------ [ 0, 1 ] 14635 4.115% 4.115% # ( 1, 2 ] 196282 55.185% 59.300% ########### ( 2, 3 ] 74928 21.066% 80.366% #### ( 3, 4 ] 32513 9.141% 89.507% ## ( 4, 6 ] 27322 7.682% 97.189% ## ( 6, 10 ] 7387 2.077% 99.266% ( 10, 15 ] 1250 0.351% 99.617% ( 15, 22 ] 171 0.048% 99.665% ( 22, 34 ] 28 0.008% 99.673% ( 34, 51 ] 15 0.004% 99.678% ( 51, 76 ] 14 0.004% 99.681% ( 76, 110 ] 109 0.031% 99.712% ( 110, 170 ] 239 0.067% 99.779% ( 170, 250 ] 196 0.055% 99.834% ( 250, 380 ] 177 0.050% 99.884% ( 380, 580 ] 201 0.057% 99.941% ( 580, 870 ] 182 0.051% 99.992% ( 870, 1300 ] 116 0.033% 100.024% ( 1300, 1900 ] 53 0.015% 100.039% ( 1900, 2900 ] 40 0.011% 100.051% ( 2900, 4400 ] 35 0.010% 100.060% ( 4400, 6600 ] 8 0.002% 100.063% ** Level 4 read latency histogram (micros): Count: 35 Average: 1711.6857 StdDev: 1224.22 Min: 203 Median: 1342.8571 Max: 4353 Percentiles: P50: 1342.86 P75: 2462.50 P99: 4325.00 P99.9: 4353.00 P99.99: 4353.00 ------------------------------------------------------ ( 170, 250 ] 2 5.714% 5.714% # ( 250, 380 ] 1 2.857% 8.571% # ( 380, 580 ] 3 8.571% 17.143% ## ( 580, 870 ] 7 20.000% 37.143% #### ( 870, 1300 ] 4 11.429% 48.571% ## ( 1300, 1900 ] 7 20.000% 68.571% #### ( 1900, 2900 ] 4 11.429% 80.000% ## ( 2900, 4400 ] 7 20.000% 100.000% #### ** Level 5 read latency histogram (micros): Count: 180 Average: 1713.7722 StdDev: 1506.94 Min: 135 Median: 1174.5833 Max: 6953 Percentiles: P50: 1174.58 P75: 2664.71 P99: 6404.44 P99.9: 6953.00 P99.99: 6953.00 ------------------------------------------------------ ( 110, 170 ] 6 3.333% 3.333% # ( 170, 250 ] 11 6.111% 9.444% # ( 250, 380 ] 15 8.333% 17.778% ## ( 380, 580 ] 25 13.889% 31.667% ### ( 580, 870 ] 16 8.889% 40.556% ## ( 870, 1300 ] 24 13.333% 53.889% ### ( 1300, 1900 ] 12 6.667% 60.556% # ( 1900, 2900 ] 34 18.889% 79.444% #### ( 2900, 4400 ] 27 15.000% 94.444% ### ( 4400, 6600 ] 9 5.000% 99.444% # ( 6600, 9900 ] 1 0.556% 100.000% ** DB Stats ** Uptime(secs): 43.8 total, 7.3 interval Cumulative writes: 0 writes, 7000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 6.73 GB, 157.22 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:24.230 H:M:S, 55.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 135.24 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.347 H:M:S, 59.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/07/14-10:22:51 ... thread 0: (1000000,8000000) ops and (328506.5,171457.3) ops/second in (3.044080,46.658861) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 13/7 3.01 GB 157.3 6.5 0.0 6.5 14.1 7.6 0.0 1.9 138.5 299.0 48.22 44.07 130 0.371 6779K 9038 0.0 0.0 L1 8/8 887.05 MB 0.0 6.7 4.4 2.3 6.6 4.3 0.1 1.5 219.2 215.9 31.25 28.87 4 7.814 6956K 102K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.0 0.1 0.1 3.6 1.8 230.8 230.8 0.48 0.46 1 0.482 112K 33 0.0 0.0 L3 23/0 987.22 MB 1.0 4.8 3.5 1.3 4.8 3.5 0.1 1.4 137.7 137.6 35.78 22.57 26 1.376 4449K 1289 0.0 0.0 L4 148/0 9.55 GB 1.0 0.1 0.1 0.0 0.1 0.1 3.2 1.0 230.3 230.3 0.47 0.45 1 0.467 109K 0 0.0 0.0 L5 1084/0 89.20 GB 0.9 0.0 0.0 0.0 0.0 0.0 3.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1276/15 103.59 GB 0.0 18.2 8.1 10.1 25.7 15.6 10.3 3.4 160.7 226.4 116.20 96.41 162 0.717 18M 112K 0.0 0.0 Int 0/0 0.00 KB 0.0 18.2 8.1 10.1 25.7 15.6 10.3 3.4 160.7 226.4 116.20 96.41 162 0.717 18M 112K 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 18.2 8.1 10.1 18.1 8.0 0.0 0.0 200.3 199.1 93.22 76.86 54 1.726 18M 112K 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 337.2 22.98 19.55 108 0.213 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 46.9 total, 46.7 interval Flush(GB): cumulative 7.567, interval 7.567 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 25.69 GB write, 561.35 MB/s write, 18.23 GB read, 398.44 MB/s read, 116.2 seconds Interval compaction: 25.69 GB write, 563.79 MB/s write, 18.23 GB read, 400.18 MB/s read, 116.2 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: 50, pending-compaction-bytes-delays: 17, pending-compaction-bytes-stops: 0, total-delays: 25, total-stops: 50, interval: 75 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3183746 Average: 2.8167 StdDev: 24.86 Min: 0 Median: 1.4700 Max: 7081 Percentiles: P50: 1.47 P75: 1.86 P99: 6.62 P99.9: 147.73 P99.99: 472.40 ------------------------------------------------------ [ 0, 1 ] 631093 19.822% 19.822% #### ( 1, 2 ] 2044251 64.209% 84.031% ############# ( 2, 3 ] 298320 9.370% 93.401% ## ( 3, 4 ] 102140 3.208% 96.610% # ( 4, 6 ] 73180 2.299% 98.908% ( 6, 10 ] 18938 0.595% 99.503% ( 10, 15 ] 3784 0.119% 99.622% ( 15, 22 ] 462 0.015% 99.636% ( 22, 34 ] 52 0.002% 99.638% ( 34, 51 ] 31 0.001% 99.639% ( 51, 76 ] 95 0.003% 99.642% ( 76, 110 ] 5701 0.179% 99.821% ( 110, 170 ] 4000 0.126% 99.947% ( 170, 250 ] 635 0.020% 99.967% ( 250, 380 ] 510 0.016% 99.983% ( 380, 580 ] 510 0.016% 99.999% ( 580, 870 ] 238 0.007% 100.006% ( 870, 1300 ] 110 0.003% 100.010% ( 1300, 1900 ] 55 0.002% 100.011% ( 1900, 2900 ] 45 0.001% 100.013% ( 2900, 4400 ] 52 0.002% 100.014% ( 4400, 6600 ] 12 0.000% 100.015% ( 6600, 9900 ] 2 0.000% 100.015% ** Level 1 read latency histogram (micros): Count: 1677690 Average: 6.7438 StdDev: 104.62 Min: 0 Median: 1.7242 Max: 8877 Percentiles: P50: 1.72 P75: 2.55 P99: 9.33 P99.9: 163.30 P99.99: 460.41 ------------------------------------------------------ [ 0, 1 ] 170317 10.152% 10.152% ## ( 1, 2 ] 923113 55.023% 65.175% ########### ( 2, 3 ] 297197 17.715% 82.889% #### ( 3, 4 ] 122698 7.314% 90.203% # ( 4, 6 ] 121016 7.213% 97.416% # ( 6, 10 ] 31939 1.904% 99.320% ( 10, 15 ] 6145 0.366% 99.686% ( 15, 22 ] 809 0.048% 99.734% ( 22, 34 ] 64 0.004% 99.738% ( 34, 51 ] 65 0.004% 99.742% ( 51, 76 ] 75 0.004% 99.747% ( 76, 110 ] 1152 0.069% 99.815% ( 110, 170 ] 1601 0.095% 99.911% ( 170, 250 ] 586 0.035% 99.946% ( 250, 380 ] 506 0.030% 99.976% ( 380, 580 ] 595 0.035% 100.011% ( 580, 870 ] 588 0.035% 100.046% ( 870, 1300 ] 500 0.030% 100.076% ( 1300, 1900 ] 363 0.022% 100.098% ( 1900, 2900 ] 586 0.035% 100.133% ( 2900, 4400 ] 655 0.039% 100.172% ( 4400, 6600 ] 140 0.008% 100.180% ( 6600, 9900 ] 24 0.001% 100.181% ** Level 2 read latency histogram (micros): Count: 28248 Average: 2.9374 StdDev: 23.52 Min: 1 Median: 1.3776 Max: 1545 Percentiles: P50: 1.38 P75: 1.78 P99: 6.81 P99.9: 359.89 P99.99: 945.34 ------------------------------------------------------ [ 0, 1 ] 7541 26.696% 26.696% ##### ( 1, 2 ] 17432 61.711% 88.406% ############ ( 2, 3 ] 1931 6.836% 95.242% # ( 3, 4 ] 582 2.060% 97.302% ( 4, 6 ] 433 1.533% 98.835% ( 6, 10 ] 230 0.814% 99.650% ( 10, 15 ] 19 0.067% 99.717% ( 15, 22 ] 1 0.004% 99.720% ( 76, 110 ] 2 0.007% 99.727% ( 110, 170 ] 19 0.067% 99.795% ( 170, 250 ] 12 0.042% 99.837% ( 250, 380 ] 21 0.074% 99.911% ( 380, 580 ] 13 0.046% 99.958% ( 580, 870 ] 9 0.032% 99.989% ( 870, 1300 ] 1 0.004% 99.993% ( 1300, 1900 ] 2 0.007% 100.000% ** Level 3 read latency histogram (micros): Count: 367489 Average: 4.9973 StdDev: 59.47 Min: 0 Median: 1.8260 Max: 5583 Percentiles: P50: 1.83 P75: 2.73 P99: 9.43 P99.9: 424.29 P99.99: 857.65 ------------------------------------------------------ [ 0, 1 ] 15103 4.110% 4.110% # ( 1, 2 ] 204156 55.554% 59.664% ########### ( 2, 3 ] 77202 21.008% 80.672% #### ( 3, 4 ] 33101 9.007% 89.679% ## ( 4, 6 ] 27870 7.584% 97.263% ## ( 6, 10 ] 7442 2.025% 99.288% ( 10, 15 ] 1253 0.341% 99.629% ( 15, 22 ] 172 0.047% 99.676% ( 22, 34 ] 28 0.008% 99.684% ( 34, 51 ] 15 0.004% 99.688% ( 51, 76 ] 14 0.004% 99.692% ( 76, 110 ] 109 0.030% 99.721% ( 110, 170 ] 239 0.065% 99.786% ( 170, 250 ] 196 0.053% 99.840% ( 250, 380 ] 177 0.048% 99.888% ( 380, 580 ] 201 0.055% 99.943% ( 580, 870 ] 182 0.050% 99.992% ( 870, 1300 ] 116 0.032% 100.024% ( 1300, 1900 ] 53 0.014% 100.038% ( 1900, 2900 ] 40 0.011% 100.049% ( 2900, 4400 ] 35 0.010% 100.059% ( 4400, 6600 ] 8 0.002% 100.061% ** Level 4 read latency histogram (micros): Count: 45 Average: 1359.3778 StdDev: 1268.08 Min: 1 Median: 851.8750 Max: 4353 Percentiles: P50: 851.88 P75: 1878.57 P99: 4303.57 P99.9: 4353.00 P99.99: 4353.00 ------------------------------------------------------ [ 0, 1 ] 3 6.667% 6.667% # ( 1, 2 ] 3 6.667% 13.333% # ( 110, 170 ] 1 2.222% 15.556% ( 170, 250 ] 3 6.667% 22.222% # ( 250, 380 ] 2 4.444% 26.667% # ( 380, 580 ] 3 6.667% 33.333% # ( 580, 870 ] 8 17.778% 51.111% #### ( 870, 1300 ] 4 8.889% 60.000% ## ( 1300, 1900 ] 7 15.556% 75.556% ### ( 1900, 2900 ] 4 8.889% 84.444% ## ( 2900, 4400 ] 7 15.556% 100.000% ### ** Level 5 read latency histogram (micros): Count: 200 Average: 1624.9050 StdDev: 1482.20 Min: 83 Median: 1093.6000 Max: 6953 Percentiles: P50: 1093.60 P75: 2566.67 P99: 6355.56 P99.9: 6953.00 P99.99: 6953.00 ------------------------------------------------------ ( 76, 110 ] 3 1.500% 1.500% ( 110, 170 ] 9 4.500% 6.000% # ( 170, 250 ] 13 6.500% 12.500% # ( 250, 380 ] 17 8.500% 21.000% ## ( 380, 580 ] 25 12.500% 33.500% ### ( 580, 870 ] 20 10.000% 43.500% ## ( 870, 1300 ] 25 12.500% 56.000% ### ( 1300, 1900 ] 14 7.000% 63.000% # ( 1900, 2900 ] 36 18.000% 81.000% #### ( 2900, 4400 ] 28 14.000% 95.000% ### ( 4400, 6600 ] 9 4.500% 99.500% # ( 6600, 9900 ] 1 0.500% 100.000% ** DB Stats ** Uptime(secs): 46.9 total, 3.0 interval Cumulative writes: 0 writes, 8000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 7.69 GB, 168.01 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:24.666 H:M:S, 52.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 323.31 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.436 H:M:S, 14.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/07/14-10:22:54 ... thread 0: (1000000,9000000) ops and (331790.7,181185.6) ops/second in (3.013948,49.672809) 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/4 2.83 GB 258.0 7.4 0.0 7.4 15.9 8.5 0.0 1.9 138.9 299.7 54.41 49.87 147 0.370 7674K 10K 0.0 0.0 L1 16/0 1.48 GB 151.9 8.7 5.6 3.1 8.6 5.5 0.1 1.5 213.1 210.3 41.91 37.85 5 8.383 8168K 102K 0.0 0.0 L2 1/0 68.23 MB 0.7 0.1 0.1 0.0 0.1 0.1 4.1 1.8 230.8 230.8 0.48 0.46 1 0.482 112K 33 0.0 0.0 L3 21/0 978.84 MB 1.0 5.3 3.7 1.6 5.3 3.7 0.4 1.4 141.5 141.4 38.12 24.68 29 1.314 4924K 4400 0.0 0.0 L4 153/0 9.72 GB 1.0 0.1 0.1 0.0 0.1 0.1 3.7 1.0 230.3 230.3 0.47 0.45 1 0.467 109K 0 0.0 0.0 L5 1088/0 89.51 GB 0.9 0.0 0.0 0.0 0.0 0.0 3.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1294/4 104.56 GB 0.0 21.6 9.5 12.1 30.0 17.9 11.9 3.5 163.2 226.9 135.40 113.30 183 0.740 20M 116K 0.0 0.0 Int 0/0 0.00 KB 0.0 21.6 9.5 12.1 30.0 17.9 11.9 3.5 163.2 226.9 135.40 113.30 183 0.740 20M 116K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 21.6 9.5 12.1 21.5 9.3 0.0 0.0 201.7 200.5 109.58 91.24 61 1.796 20M 116K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 8.6 8.6 0.0 0.0 0.0 339.2 25.82 22.06 122 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): 49.9 total, 49.7 interval Flush(GB): cumulative 8.551, interval 8.551 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 30.01 GB write, 616.05 MB/s write, 21.58 GB read, 443.14 MB/s read, 135.4 seconds Interval compaction: 30.01 GB write, 618.57 MB/s write, 21.58 GB read, 444.95 MB/s read, 135.4 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 8, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 8, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 55, pending-compaction-bytes-delays: 17, pending-compaction-bytes-stops: 0, total-delays: 25, total-stops: 55, interval: 80 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3429827 Average: 2.7672 StdDev: 24.32 Min: 0 Median: 1.4671 Max: 7081 Percentiles: P50: 1.47 P75: 1.86 P99: 6.31 P99.9: 144.02 P99.99: 455.64 ------------------------------------------------------ [ 0, 1 ] 687941 20.058% 20.058% #### ( 1, 2 ] 2198831 64.109% 84.167% ############# ( 2, 3 ] 318694 9.292% 93.459% ## ( 3, 4 ] 109883 3.204% 96.662% # ( 4, 6 ] 78632 2.293% 98.955% ( 6, 10 ] 19733 0.575% 99.530% ( 10, 15 ] 4014 0.117% 99.647% ( 15, 22 ] 513 0.015% 99.662% ( 22, 34 ] 56 0.002% 99.664% ( 34, 51 ] 32 0.001% 99.665% ( 51, 76 ] 96 0.003% 99.668% ( 76, 110 ] 5701 0.166% 99.834% ( 110, 170 ] 4006 0.117% 99.951% ( 170, 250 ] 641 0.019% 99.969% ( 250, 380 ] 517 0.015% 99.984% ( 380, 580 ] 513 0.015% 99.999% ( 580, 870 ] 242 0.007% 100.006% ( 870, 1300 ] 113 0.003% 100.010% ( 1300, 1900 ] 57 0.002% 100.011% ( 1900, 2900 ] 45 0.001% 100.013% ( 2900, 4400 ] 54 0.002% 100.014% ( 4400, 6600 ] 13 0.000% 100.015% ( 6600, 9900 ] 2 0.000% 100.015% ** Level 1 read latency histogram (micros): Count: 1771506 Average: 6.6414 StdDev: 102.23 Min: 0 Median: 1.7288 Max: 8877 Percentiles: P50: 1.73 P75: 2.56 P99: 9.35 P99.9: 172.63 P99.99: 491.33 ------------------------------------------------------ [ 0, 1 ] 173159 9.775% 9.775% ## ( 1, 2 ] 977771 55.194% 64.969% ########### ( 2, 3 ] 318193 17.962% 82.931% #### ( 3, 4 ] 129040 7.284% 90.215% # ( 4, 6 ] 127110 7.175% 97.390% # ( 6, 10 ] 34071 1.923% 99.313% ( 10, 15 ] 6432 0.363% 99.677% ( 15, 22 ] 856 0.048% 99.725% ( 22, 34 ] 68 0.004% 99.729% ( 34, 51 ] 65 0.004% 99.732% ( 51, 76 ] 80 0.005% 99.737% ( 76, 110 ] 1194 0.067% 99.804% ( 110, 170 ] 1674 0.094% 99.899% ( 170, 250 ] 655 0.037% 99.936% ( 250, 380 ] 584 0.033% 99.969% ( 380, 580 ] 677 0.038% 100.007% ( 580, 870 ] 654 0.037% 100.044% ( 870, 1300 ] 532 0.030% 100.074% ( 1300, 1900 ] 375 0.021% 100.095% ( 1900, 2900 ] 588 0.033% 100.128% ( 2900, 4400 ] 656 0.037% 100.165% ( 4400, 6600 ] 140 0.008% 100.173% ( 6600, 9900 ] 24 0.001% 100.175% ** Level 2 read latency histogram (micros): Count: 28248 Average: 2.9374 StdDev: 23.52 Min: 1 Median: 1.3776 Max: 1545 Percentiles: P50: 1.38 P75: 1.78 P99: 6.81 P99.9: 359.89 P99.99: 945.34 ------------------------------------------------------ [ 0, 1 ] 7541 26.696% 26.696% ##### ( 1, 2 ] 17432 61.711% 88.406% ############ ( 2, 3 ] 1931 6.836% 95.242% # ( 3, 4 ] 582 2.060% 97.302% ( 4, 6 ] 433 1.533% 98.835% ( 6, 10 ] 230 0.814% 99.650% ( 10, 15 ] 19 0.067% 99.717% ( 15, 22 ] 1 0.004% 99.720% ( 76, 110 ] 2 0.007% 99.727% ( 110, 170 ] 19 0.067% 99.795% ( 170, 250 ] 12 0.042% 99.837% ( 250, 380 ] 21 0.074% 99.911% ( 380, 580 ] 13 0.046% 99.958% ( 580, 870 ] 9 0.032% 99.989% ( 870, 1300 ] 1 0.004% 99.993% ( 1300, 1900 ] 2 0.007% 100.000% ** Level 3 read latency histogram (micros): Count: 401673 Average: 4.8610 StdDev: 57.19 Min: 0 Median: 1.8252 Max: 5583 Percentiles: P50: 1.83 P75: 2.72 P99: 9.37 P99.9: 395.40 P99.99: 838.56 ------------------------------------------------------ [ 0, 1 ] 15835 3.942% 3.942% # ( 1, 2 ] 224180 55.812% 59.754% ########### ( 2, 3 ] 84710 21.089% 80.843% #### ( 3, 4 ] 36036 8.971% 89.815% ## ( 4, 6 ] 30180 7.514% 97.328% ## ( 6, 10 ] 7967 1.983% 99.312% ( 10, 15 ] 1327 0.330% 99.642% ( 15, 22 ] 183 0.046% 99.688% ( 22, 34 ] 29 0.007% 99.695% ( 34, 51 ] 15 0.004% 99.699% ( 51, 76 ] 14 0.003% 99.702% ( 76, 110 ] 127 0.032% 99.734% ( 110, 170 ] 257 0.064% 99.798% ( 170, 250 ] 208 0.052% 99.849% ( 250, 380 ] 187 0.047% 99.896% ( 380, 580 ] 212 0.053% 99.949% ( 580, 870 ] 186 0.046% 99.995% ( 870, 1300 ] 119 0.030% 100.025% ( 1300, 1900 ] 55 0.014% 100.038% ( 1900, 2900 ] 40 0.010% 100.048% ( 2900, 4400 ] 35 0.009% 100.057% ( 4400, 6600 ] 8 0.002% 100.059% ** Level 4 read latency histogram (micros): Count: 45 Average: 1359.3778 StdDev: 1268.08 Min: 1 Median: 851.8750 Max: 4353 Percentiles: P50: 851.88 P75: 1878.57 P99: 4303.57 P99.9: 4353.00 P99.99: 4353.00 ------------------------------------------------------ [ 0, 1 ] 3 6.667% 6.667% # ( 1, 2 ] 3 6.667% 13.333% # ( 110, 170 ] 1 2.222% 15.556% ( 170, 250 ] 3 6.667% 22.222% # ( 250, 380 ] 2 4.444% 26.667% # ( 380, 580 ] 3 6.667% 33.333% # ( 580, 870 ] 8 17.778% 51.111% #### ( 870, 1300 ] 4 8.889% 60.000% ## ( 1300, 1900 ] 7 15.556% 75.556% ### ( 1900, 2900 ] 4 8.889% 84.444% ## ( 2900, 4400 ] 7 15.556% 100.000% ### ** Level 5 read latency histogram (micros): Count: 220 Average: 1561.6318 StdDev: 1461.14 Min: 83 Median: 1007.6000 Max: 6953 Percentiles: P50: 1007.60 P75: 2521.62 P99: 6306.67 P99.9: 6953.00 P99.99: 6953.00 ------------------------------------------------------ ( 76, 110 ] 3 1.364% 1.364% ( 110, 170 ] 13 5.909% 7.273% # ( 170, 250 ] 16 7.273% 14.545% # ( 250, 380 ] 19 8.636% 23.182% ## ( 380, 580 ] 27 12.273% 35.455% ## ( 580, 870 ] 24 10.909% 46.364% ## ( 870, 1300 ] 25 11.364% 57.727% ## ( 1300, 1900 ] 15 6.818% 64.545% # ( 1900, 2900 ] 37 16.818% 81.364% ### ( 2900, 4400 ] 31 14.091% 95.455% ### ( 4400, 6600 ] 9 4.091% 99.545% # ( 6600, 9900 ] 1 0.455% 100.000% ** DB Stats ** Uptime(secs): 49.9 total, 3.0 interval Cumulative writes: 0 writes, 9000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 8.65 GB, 177.59 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:25.091 H:M:S, 50.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 326.55 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.424 H:M:S, 14.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 using bdev Nvme0n1 Initializing RocksDB Options from the specified file Initializing RocksDB Options from command-line flags Integrated BlobDB: blob cache disabled Keys: 16 bytes each (+ 0 bytes user-defined timestamp) Values: 1000 bytes each (1000 bytes after compression) Entries: 100000000 Prefix: 0 bytes Keys per prefix: 0 RawSize: 96893.3 MB (estimated) FileSize: 96893.3 MB (estimated) Write rate: 0 bytes/second Read rate: 0 ops/second Compression: NoCompression Compression sampling rate: 0 Memtablerep: SkipListFactory Perf Level: 1 ------------------------------------------------ DB path: [/mnt/rocksdb] overwrite : 6.089 micros/op 164223 ops/sec 60.003 seconds 9853999 operations; 159.1 MB/s Microseconds per write: Count: 9853999 Average: 6.0892 StdDev: 305.26 Min: 0 Median: 1.7370 Max: 448369 Percentiles: P50: 1.74 P75: 2.71 P99: 9.92 P99.9: 1163.81 P99.99: 2646.15 ------------------------------------------------------ [ 0, 1 ] 1302918 13.222% 13.222% ### ( 1, 2 ] 4917226 49.901% 63.123% ########## ( 2, 3 ] 1654342 16.789% 79.912% ### ( 3, 4 ] 1279823 12.988% 92.899% ### ( 4, 6 ] 461002 4.678% 97.578% # ( 6, 10 ] 142917 1.450% 99.028% ( 10, 15 ] 49855 0.506% 99.534% ( 15, 22 ] 10030 0.102% 99.636% ( 22, 34 ] 2010 0.020% 99.656% ( 34, 51 ] 270 0.003% 99.659% ( 51, 76 ] 30 0.000% 99.659% ( 76, 110 ] 7157 0.073% 99.732% ( 110, 170 ] 2311 0.023% 99.755% ( 170, 250 ] 272 0.003% 99.758% ( 250, 380 ] 214 0.002% 99.760% ( 380, 580 ] 22 0.000% 99.761% ( 580, 870 ] 15 0.000% 99.761% ( 870, 1300 ] 20096 0.204% 99.965% ( 1300, 1900 ] 54 0.001% 99.965% ( 1900, 2900 ] 3283 0.033% 99.998% ( 2900, 4400 ] 97 0.001% 99.999% ( 4400, 6600 ] 17 0.000% 100.000% ( 6600, 9900 ] 10 0.000% 100.000% ( 9900, 14000 ] 1 0.000% 100.000% ( 14000, 22000 ] 6 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 ] 16 0.000% 100.000% ( 380000, 570000 ] 1 0.000% 100.000% STATISTICS: rocksdb.block.cache.miss COUNT : 0 rocksdb.block.cache.hit COUNT : 0 rocksdb.block.cache.add COUNT : 0 rocksdb.block.cache.add.failures COUNT : 0 rocksdb.block.cache.index.miss COUNT : 0 rocksdb.block.cache.index.hit COUNT : 0 rocksdb.block.cache.index.add COUNT : 0 rocksdb.block.cache.index.bytes.insert COUNT : 0 rocksdb.block.cache.filter.miss COUNT : 0 rocksdb.block.cache.filter.hit COUNT : 0 rocksdb.block.cache.filter.add COUNT : 0 rocksdb.block.cache.filter.bytes.insert COUNT : 0 rocksdb.block.cache.data.miss COUNT : 0 rocksdb.block.cache.data.hit COUNT : 0 rocksdb.block.cache.data.add COUNT : 0 rocksdb.block.cache.data.bytes.insert COUNT : 0 rocksdb.block.cache.bytes.read COUNT : 0 rocksdb.block.cache.bytes.write COUNT : 0 rocksdb.bloom.filter.useful COUNT : 0 rocksdb.bloom.filter.full.positive COUNT : 0 rocksdb.bloom.filter.full.true.positive COUNT : 0 rocksdb.persistent.cache.hit COUNT : 0 rocksdb.persistent.cache.miss COUNT : 0 rocksdb.sim.block.cache.hit COUNT : 0 rocksdb.sim.block.cache.miss COUNT : 0 rocksdb.memtable.hit COUNT : 0 rocksdb.memtable.miss COUNT : 0 rocksdb.l0.hit COUNT : 0 rocksdb.l1.hit COUNT : 0 rocksdb.l2andup.hit COUNT : 0 rocksdb.compaction.key.drop.new COUNT : 169362 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 : 9853999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 10169326968 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 : 473 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 32808391 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 : 26307476116 rocksdb.compact.write.bytes COUNT : 26141342978 rocksdb.flush.write.bytes COUNT : 10106722721 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 : 55 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 : 282 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 : 10025423872 rocksdb.memtable.garbage.bytes.at.flush COUNT : 4074496 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 : 26398894468 rocksdb.non.last.level.read.count COUNT : 6375271 rocksdb.block.checksum.compute.count COUNT : 6374380 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.372368 P95 : 3.901642 P99 : 8.668690 P100 : 448364.000000 COUNT : 9853999 SUM : 55201780 rocksdb.compaction.times.micros P50 : 1101578.947368 P95 : 4206666.666667 P99 : 16880000.000000 P100 : 21597008.000000 COUNT : 64 SUM : 112631992 rocksdb.compaction.times.cpu_micros P50 : 950666.666667 P95 : 4160000.000000 P99 : 16880000.000000 P100 : 19532836.000000 COUNT : 64 SUM : 94236383 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 : 679.210526 P95 : 1495.000000 P99 : 29260.000000 P100 : 61202.000000 COUNT : 134 SUM : 192048 rocksdb.compaction.outfile.sync.micros P50 : 865.042735 P95 : 94727.272727 P99 : 186448.000000 P100 : 186448.000000 COUNT : 296 SUM : 4045740 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 : 91.802817 P95 : 749.166667 P99 : 2825.000000 P100 : 4600.000000 COUNT : 230 SUM : 51121 rocksdb.table.open.io.micros P50 : 1444.155844 P95 : 8802.115385 P99 : 13139.000000 P100 : 16238.000000 COUNT : 473 SUM : 1076289 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.571376 P95 : 7.360481 P99 : 10.989270 P100 : 8881.000000 COUNT : 6373020 SUM : 38082723 rocksdb.read.block.get.micros P50 : 470.476190 P95 : 3561.607143 P99 : 5506.769231 P100 : 7281.000000 COUNT : 946 SUM : 835807 rocksdb.write.raw.block.micros P50 : 0.512081 P95 : 0.972953 P99 : 2.928357 P100 : 13554.000000 COUNT : 8779113 SUM : 16603737 rocksdb.numfiles.in.singlecompaction P50 : 3.363636 P95 : 6.200000 P99 : 26.920000 P100 : 30.000000 COUNT : 118 SUM : 482 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.559645 P95 : 1136.052338 P99 : 2263.305886 P100 : 448132.000000 COUNT : 222272 SUM : 32832381 rocksdb.sst.read.micros P50 : 1.534493 P95 : 4.229042 P99 : 8.310877 P100 : 8877.000000 COUNT : 6375499 SUM : 25270586 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 : 9853999 SUM : 10169326968 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 : 204430.379747 P95 : 360500.000000 P99 : 665700.000000 P100 : 856561.000000 COUNT : 134 SUM : 28295983 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 : 287 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