[2024-11-02 13:38:46.391628] Starting SPDK v24.09.1-pre git sha1 b18e1bd62 / DPDK 22.11.4 initialization... [2024-11-02 13:38:46.391780] [ 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_pid1436158 ] Set seed to 1730551126388156 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-11-02 13:38:46.482713] app.c: 917:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-11-02 13:38:46.524278] app.c: 610:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-11-02 13:38:46.524336] app.c: 611:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 1436158' to capture a snapshot of events at runtime. [2024-11-02 13:38:46.524346] app.c: 616:app_setup_trace: *NOTICE*: 'spdk_trace' without parameters will also work if this is the only [2024-11-02 13:38:46.524357] app.c: 617:app_setup_trace: *NOTICE*: SPDK application currently running. [2024-11-02 13:38:46.524365] app.c: 618:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid1436158 for offline analysis/debug. [2024-11-02 13:38:46.524454] reactor.c: 990:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Sat Nov 2 13:38:50 2024 CPU: 96 * Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz CPUCache: 36608 KB 2024/11/02-13:38:53 ... thread 0: (1000000,1000000) ops and (331067.9,331067.9) ops/second in (3.020528,3.020528) 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 692.95 MB 18.9 0.0 0.0 0.0 0.9 0.9 0.0 1.0 0.0 344.5 2.56 2.32 12 0.213 0 0 0.0 0.0 L1 1/1 62.99 MB 0.0 0.0 0.0 0.0 0.0 0.0 0.2 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L2 1/0 1013.34 KB 0.0 0.1 0.1 0.1 0.1 0.1 0.2 2.0 237.7 237.6 0.53 0.51 1 0.530 127K 43 0.0 0.0 L3 17/0 866.27 MB 0.9 0.1 0.1 0.0 0.1 0.1 0.1 1.0 226.6 226.6 0.55 0.49 1 0.552 126K 0 0.0 0.0 L4 116/0 9.60 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1044/0 85.82 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 97.00 GB 0.0 0.2 0.2 0.1 1.1 1.0 0.5 1.3 68.9 311.1 3.64 3.31 14 0.260 254K 43 0.0 0.0 Int 0/0 0.00 KB 0.0 0.2 0.2 0.1 1.1 1.0 0.4 1.3 68.9 311.1 3.64 3.31 14 0.260 254K 43 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.2 0.2 0.1 0.2 0.2 0.0 0.0 232.0 232.0 1.08 1.00 2 0.541 254K 43 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 344.5 2.56 2.32 12 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): 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.11 GB write, 352.90 MB/s write, 0.25 GB read, 78.18 MB/s read, 3.6 seconds Interval compaction: 1.11 GB write, 374.87 MB/s write, 0.25 GB read, 83.04 MB/s read, 3.6 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 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: 146572 Average: 1.8673 StdDev: 11.20 Min: 1 Median: 1.2653 Max: 2855 Percentiles: P50: 1.27 P75: 1.69 P99: 4.24 P99.9: 9.12 P99.99: 59.57 ------------------------------------------------------ [ 0, 1 ] 50460 34.427% 34.427% ####### ( 1, 2 ] 86053 58.710% 93.137% ############ ( 2, 3 ] 6049 4.127% 97.264% # ( 3, 4 ] 2403 1.639% 98.904% ( 4, 6 ] 1199 0.818% 99.722% ( 6, 10 ] 336 0.229% 99.951% ( 10, 15 ] 45 0.031% 99.982% ( 15, 22 ] 11 0.008% 99.989% ( 22, 34 ] 2 0.001% 99.990% ( 51, 76 ] 1 0.001% 99.991% ( 110, 170 ] 5 0.003% 99.995% ( 170, 250 ] 5 0.003% 99.998% ( 250, 380 ] 7 0.005% 100.003% ( 580, 870 ] 3 0.002% 100.005% ( 870, 1300 ] 1 0.001% 100.005% ( 1300, 1900 ] 1 0.001% 100.006% ( 1900, 2900 ] 2 0.001% 100.008% ** Level 1 read latency histogram (micros): Count: 9 Average: 458.0000 StdDev: 668.87 Min: 1 Median: 140.0000 Max: 2122 Percentiles: P50: 140.00 P75: 530.00 P99: 2122.00 P99.9: 2122.00 P99.99: 2122.00 ------------------------------------------------------ [ 0, 1 ] 1 11.111% 11.111% ## ( 1, 2 ] 1 11.111% 22.222% ## ( 2, 3 ] 1 11.111% 33.333% ## ( 76, 110 ] 1 11.111% 44.444% ## ( 110, 170 ] 1 11.111% 55.556% ## ( 250, 380 ] 1 11.111% 66.667% ## ( 380, 580 ] 1 11.111% 77.778% ## ( 870, 1300 ] 1 11.111% 88.889% ## ( 1900, 2900 ] 1 11.111% 100.000% ## ** Level 2 read latency histogram (micros): Count: 31731 Average: 1.6777 StdDev: 7.76 Min: 1 Median: 1.1225 Max: 1332 Percentiles: P50: 1.12 P75: 1.59 P99: 3.23 P99.9: 9.06 P99.99: 31.92 ------------------------------------------------------ [ 0, 1 ] 13788 43.453% 43.453% ######### ( 1, 2 ] 16958 53.443% 96.896% ########### ( 2, 3 ] 619 1.951% 98.847% ( 3, 4 ] 211 0.665% 99.512% ( 4, 6 ] 82 0.258% 99.770% ( 6, 10 ] 54 0.170% 99.940% ( 10, 15 ] 12 0.038% 99.978% ( 15, 22 ] 3 0.009% 99.987% ( 22, 34 ] 1 0.003% 99.991% ( 51, 76 ] 1 0.003% 99.994% ( 250, 380 ] 1 0.003% 99.997% ( 1300, 1900 ] 1 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 80 Average: 706.3000 StdDev: 928.52 Min: 0 Median: 170.0000 Max: 3699 Percentiles: P50: 170.00 P75: 1182.73 P99: 3699.00 P99.9: 3699.00 P99.99: 3699.00 ------------------------------------------------------ [ 0, 1 ] 28 35.000% 35.000% ####### ( 1, 2 ] 4 5.000% 40.000% # ( 2, 3 ] 2 2.500% 42.500% # ( 3, 4 ] 2 2.500% 45.000% # ( 4, 6 ] 2 2.500% 47.500% # ( 110, 170 ] 2 2.500% 50.000% # ( 170, 250 ] 2 2.500% 52.500% # ( 250, 380 ] 1 1.250% 53.750% ( 380, 580 ] 1 1.250% 55.000% ( 580, 870 ] 8 10.000% 65.000% ## ( 870, 1300 ] 11 13.750% 78.750% ### ( 1300, 1900 ] 7 8.750% 87.500% ## ( 1900, 2900 ] 8 10.000% 97.500% ## ( 2900, 4400 ] 2 2.500% 100.000% # ** Level 4 read latency histogram (micros): Count: 35 Average: 1760.6571 StdDev: 1248.98 Min: 679 Median: 1174.5833 Max: 4886 Percentiles: P50: 1174.58 P75: 2316.67 P99: 4886.00 P99.9: 4886.00 P99.99: 4886.00 ------------------------------------------------------ ( 580, 870 ] 9 25.714% 25.714% ##### ( 870, 1300 ] 12 34.286% 60.000% ####### ( 1300, 1900 ] 4 11.429% 71.429% ## ( 1900, 2900 ] 3 8.571% 80.000% ## ( 2900, 4400 ] 6 17.143% 97.143% ### ( 4400, 6600 ] 1 2.857% 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, 306.57 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.433 H:M:S, 13.5 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 325.57 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.433 H:M:S, 14.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/02-13:38:56 ... thread 0: (1000000,2000000) ops and (353077.5,341718.7) ops/second in (2.832239,5.852767) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 11/8 1.35 GB 81.8 0.8 0.0 0.8 2.6 1.8 0.0 1.4 98.1 316.8 8.35 7.73 29 0.288 831K 841 0.0 0.0 L1 1/0 2.37 MB 0.2 0.3 0.2 0.1 0.3 0.2 0.2 1.2 247.2 246.9 1.27 1.24 1 1.274 319K 355 0.0 0.0 L2 2/0 55.68 MB 0.6 0.1 0.1 0.1 0.1 0.1 0.5 2.0 237.7 237.6 0.53 0.51 1 0.530 127K 43 0.0 0.0 L3 54/0 986.66 MB 1.0 0.5 0.4 0.1 0.5 0.4 0.1 1.3 182.6 182.4 2.71 2.24 2 1.356 502K 347 0.0 0.0 L4 136/0 9.73 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.1 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1044/0 85.82 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 1248/8 97.92 GB 0.0 1.7 0.7 1.0 3.5 2.5 0.9 2.0 136.4 278.3 12.86 11.72 33 0.390 1782K 1586 0.0 0.0 Int 0/0 0.00 KB 0.0 1.7 0.7 1.0 3.5 2.5 0.8 2.0 136.4 278.3 12.86 11.72 33 0.390 1782K 1586 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.7 0.7 1.0 1.7 0.7 0.0 0.0 230.0 229.8 7.63 7.03 7 1.090 1782K 1586 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 349.0 5.23 4.68 26 0.201 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 6.0 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.50 GB write, 592.54 MB/s write, 1.71 GB read, 290.46 MB/s read, 12.9 seconds Interval compaction: 3.50 GB write, 611.59 MB/s write, 1.71 GB read, 299.79 MB/s read, 12.9 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 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: 377027 Average: 2.0029 StdDev: 12.42 Min: 0 Median: 1.3576 Max: 3012 Percentiles: P50: 1.36 P75: 1.76 P99: 5.20 P99.9: 9.73 P99.99: 16.63 ------------------------------------------------------ [ 0, 1 ] 105448 27.968% 27.968% ###### ( 1, 2 ] 232257 61.602% 89.571% ############ ( 2, 3 ] 23517 6.237% 95.808% # ( 3, 4 ] 8921 2.366% 98.174% ( 4, 6 ] 5207 1.381% 99.555% ( 6, 10 ] 1396 0.370% 99.925% ( 10, 15 ] 239 0.063% 99.989% ( 15, 22 ] 27 0.007% 99.996% ( 22, 34 ] 5 0.001% 99.997% ( 34, 51 ] 2 0.001% 99.998% ( 51, 76 ] 4 0.001% 99.999% ( 110, 170 ] 8 0.002% 100.001% ( 170, 250 ] 17 0.005% 100.006% ( 250, 380 ] 12 0.003% 100.009% ( 380, 580 ] 1 0.000% 100.009% ( 580, 870 ] 8 0.002% 100.011% ( 870, 1300 ] 4 0.001% 100.012% ( 1300, 1900 ] 2 0.001% 100.013% ( 1900, 2900 ] 3 0.001% 100.014% ( 2900, 4400 ] 3 0.001% 100.014% ** Level 1 read latency histogram (micros): Count: 65403 Average: 2.3939 StdDev: 11.46 Min: 1 Median: 1.6035 Max: 2122 Percentiles: P50: 1.60 P75: 1.98 P99: 5.83 P99.9: 12.74 P99.99: 313.25 ------------------------------------------------------ [ 0, 1 ] 6375 9.747% 9.747% ## ( 1, 2 ] 43620 66.694% 76.441% ############# ( 2, 3 ] 10356 15.834% 92.276% ### ( 3, 4 ] 2713 4.148% 96.424% # ( 4, 6 ] 1845 2.821% 99.245% # ( 6, 10 ] 376 0.575% 99.820% ( 10, 15 ] 96 0.147% 99.966% ( 15, 22 ] 7 0.011% 99.977% ( 22, 34 ] 1 0.002% 99.979% ( 34, 51 ] 2 0.003% 99.982% ( 76, 110 ] 2 0.003% 99.985% ( 110, 170 ] 2 0.003% 99.988% ( 250, 380 ] 3 0.005% 99.992% ( 380, 580 ] 1 0.002% 99.994% ( 580, 870 ] 1 0.002% 99.995% ( 870, 1300 ] 1 0.002% 99.997% ( 1300, 1900 ] 1 0.002% 99.998% ( 1900, 2900 ] 1 0.002% 100.000% ** Level 2 read latency histogram (micros): Count: 31731 Average: 1.6777 StdDev: 7.76 Min: 1 Median: 1.1225 Max: 1332 Percentiles: P50: 1.12 P75: 1.59 P99: 3.23 P99.9: 9.06 P99.99: 31.92 ------------------------------------------------------ [ 0, 1 ] 13788 43.453% 43.453% ######### ( 1, 2 ] 16958 53.443% 96.896% ########### ( 2, 3 ] 619 1.951% 98.847% ( 3, 4 ] 211 0.665% 99.512% ( 4, 6 ] 82 0.258% 99.770% ( 6, 10 ] 54 0.170% 99.940% ( 10, 15 ] 12 0.038% 99.978% ( 15, 22 ] 3 0.009% 99.987% ( 22, 34 ] 1 0.003% 99.991% ( 51, 76 ] 1 0.003% 99.994% ( 250, 380 ] 1 0.003% 99.997% ( 1300, 1900 ] 1 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 28955 Average: 4.3329 StdDev: 61.37 Min: 0 Median: 1.6070 Max: 3699 Percentiles: P50: 1.61 P75: 1.99 P99: 6.89 P99.9: 835.38 P99.99: 2788.06 ------------------------------------------------------ [ 0, 1 ] 2989 10.323% 10.323% ## ( 1, 2 ] 18927 65.367% 75.690% ############# ( 2, 3 ] 4719 16.298% 91.988% ### ( 3, 4 ] 1143 3.948% 95.935% # ( 4, 6 ] 846 2.922% 98.857% # ( 6, 10 ] 187 0.646% 99.503% ( 10, 15 ] 47 0.162% 99.665% ( 15, 22 ] 18 0.062% 99.727% ( 22, 34 ] 27 0.093% 99.820% ( 34, 51 ] 3 0.010% 99.831% ( 110, 170 ] 3 0.010% 99.841% ( 170, 250 ] 5 0.017% 99.858% ( 250, 380 ] 3 0.010% 99.869% ( 380, 580 ] 2 0.007% 99.876% ( 580, 870 ] 8 0.028% 99.903% ( 870, 1300 ] 11 0.038% 99.941% ( 1300, 1900 ] 7 0.024% 99.965% ( 1900, 2900 ] 8 0.028% 99.993% ( 2900, 4400 ] 2 0.007% 100.000% ** Level 4 read latency histogram (micros): Count: 35 Average: 1760.6571 StdDev: 1248.98 Min: 679 Median: 1174.5833 Max: 4886 Percentiles: P50: 1174.58 P75: 2316.67 P99: 4886.00 P99.9: 4886.00 P99.99: 4886.00 ------------------------------------------------------ ( 580, 870 ] 9 25.714% 25.714% ##### ( 870, 1300 ] 12 34.286% 60.000% ####### ( 1300, 1900 ] 4 11.429% 71.429% ## ( 1900, 2900 ] 3 8.571% 80.000% ## ( 2900, 4400 ] 6 17.143% 97.143% ### ( 4400, 6600 ] 1 2.857% 100.000% # ** DB Stats ** Uptime(secs): 6.0 total, 2.8 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 325.75 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.635 H:M:S, 10.5 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 347.49 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.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/02-13:38:59 ... thread 0: (1000000,3000000) ops and (332838.5,338706.5) ops/second in (3.004460,8.857227) 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/13 2.34 GB 44.1 1.7 0.0 1.7 4.4 2.8 0.0 1.6 117.4 313.0 14.49 13.51 46 0.315 1727K 1815 0.0 0.0 L1 1/1 2.37 MB 0.0 0.3 0.2 0.1 0.3 0.2 0.2 1.2 247.2 246.9 1.27 1.24 1 1.274 319K 355 0.0 0.0 L2 2/0 55.68 MB 0.6 0.1 0.1 0.1 0.1 0.1 0.5 2.0 237.7 237.6 0.53 0.51 1 0.530 127K 43 0.0 0.0 L3 54/0 986.66 MB 1.0 0.5 0.4 0.1 0.5 0.4 0.1 1.3 182.6 182.4 2.71 2.24 2 1.356 502K 347 0.0 0.0 L4 136/0 9.73 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.1 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1044/0 85.82 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 1253/14 98.90 GB 0.0 2.6 0.7 1.9 5.3 3.4 0.9 1.9 138.8 287.8 19.00 17.49 50 0.380 2677K 2560 0.0 0.0 Int 0/0 0.00 KB 0.0 2.6 0.7 1.9 5.3 3.4 0.8 1.9 138.8 287.8 19.00 17.49 50 0.380 2677K 2560 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.6 0.7 1.9 2.6 0.7 0.0 0.0 240.2 239.9 10.98 10.32 10 1.098 2677K 2560 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 2.8 2.8 0.0 0.0 0.0 353.4 8.02 7.17 40 0.201 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 9.0 total, 8.9 interval Flush(GB): cumulative 2.768, interval 2.768 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 5.34 GB write, 604.55 MB/s write, 2.58 GB read, 291.49 MB/s read, 19.0 seconds Interval compaction: 5.34 GB write, 617.39 MB/s write, 2.58 GB read, 297.68 MB/s read, 19.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: 10, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 10, interval: 10 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 693804 Average: 2.0341 StdDev: 11.90 Min: 0 Median: 1.3937 Max: 3435 Percentiles: P50: 1.39 P75: 1.79 P99: 5.15 P99.9: 9.52 P99.99: 13.97 ------------------------------------------------------ [ 0, 1 ] 174109 25.095% 25.095% ##### ( 1, 2 ] 438907 63.261% 88.356% ############# ( 2, 3 ] 49882 7.190% 95.545% # ( 3, 4 ] 18277 2.634% 98.180% # ( 4, 6 ] 9878 1.424% 99.603% ( 6, 10 ] 2336 0.337% 99.940% ( 10, 15 ] 436 0.063% 100.003% ( 15, 22 ] 40 0.006% 100.009% ( 22, 34 ] 8 0.001% 100.010% ( 34, 51 ] 5 0.001% 100.011% ( 51, 76 ] 8 0.001% 100.012% ( 110, 170 ] 11 0.002% 100.013% ( 170, 250 ] 29 0.004% 100.018% ( 250, 380 ] 17 0.002% 100.020% ( 380, 580 ] 2 0.000% 100.020% ( 580, 870 ] 13 0.002% 100.022% ( 870, 1300 ] 7 0.001% 100.023% ( 1300, 1900 ] 4 0.001% 100.024% ( 1900, 2900 ] 4 0.001% 100.024% ( 2900, 4400 ] 5 0.001% 100.025% ** Level 1 read latency histogram (micros): Count: 65404 Average: 2.3939 StdDev: 11.46 Min: 1 Median: 1.6036 Max: 2122 Percentiles: P50: 1.60 P75: 1.98 P99: 5.83 P99.9: 12.74 P99.99: 313.25 ------------------------------------------------------ [ 0, 1 ] 6375 9.747% 9.747% ## ( 1, 2 ] 43620 66.693% 76.440% ############# ( 2, 3 ] 10356 15.834% 92.274% ### ( 3, 4 ] 2714 4.150% 96.424% # ( 4, 6 ] 1845 2.821% 99.245% # ( 6, 10 ] 376 0.575% 99.820% ( 10, 15 ] 96 0.147% 99.966% ( 15, 22 ] 7 0.011% 99.977% ( 22, 34 ] 1 0.002% 99.979% ( 34, 51 ] 2 0.003% 99.982% ( 76, 110 ] 2 0.003% 99.985% ( 110, 170 ] 2 0.003% 99.988% ( 250, 380 ] 3 0.005% 99.992% ( 380, 580 ] 1 0.002% 99.994% ( 580, 870 ] 1 0.002% 99.995% ( 870, 1300 ] 1 0.002% 99.997% ( 1300, 1900 ] 1 0.002% 99.998% ( 1900, 2900 ] 1 0.002% 100.000% ** Level 2 read latency histogram (micros): Count: 31731 Average: 1.6777 StdDev: 7.76 Min: 1 Median: 1.1225 Max: 1332 Percentiles: P50: 1.12 P75: 1.59 P99: 3.23 P99.9: 9.06 P99.99: 31.92 ------------------------------------------------------ [ 0, 1 ] 13788 43.453% 43.453% ######### ( 1, 2 ] 16958 53.443% 96.896% ########### ( 2, 3 ] 619 1.951% 98.847% ( 3, 4 ] 211 0.665% 99.512% ( 4, 6 ] 82 0.258% 99.770% ( 6, 10 ] 54 0.170% 99.940% ( 10, 15 ] 12 0.038% 99.978% ( 15, 22 ] 3 0.009% 99.987% ( 22, 34 ] 1 0.003% 99.991% ( 51, 76 ] 1 0.003% 99.994% ( 250, 380 ] 1 0.003% 99.997% ( 1300, 1900 ] 1 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 28955 Average: 4.3329 StdDev: 61.37 Min: 0 Median: 1.6070 Max: 3699 Percentiles: P50: 1.61 P75: 1.99 P99: 6.89 P99.9: 835.38 P99.99: 2788.06 ------------------------------------------------------ [ 0, 1 ] 2989 10.323% 10.323% ## ( 1, 2 ] 18927 65.367% 75.690% ############# ( 2, 3 ] 4719 16.298% 91.988% ### ( 3, 4 ] 1143 3.948% 95.935% # ( 4, 6 ] 846 2.922% 98.857% # ( 6, 10 ] 187 0.646% 99.503% ( 10, 15 ] 47 0.162% 99.665% ( 15, 22 ] 18 0.062% 99.727% ( 22, 34 ] 27 0.093% 99.820% ( 34, 51 ] 3 0.010% 99.831% ( 110, 170 ] 3 0.010% 99.841% ( 170, 250 ] 5 0.017% 99.858% ( 250, 380 ] 3 0.010% 99.869% ( 380, 580 ] 2 0.007% 99.876% ( 580, 870 ] 8 0.028% 99.903% ( 870, 1300 ] 11 0.038% 99.941% ( 1300, 1900 ] 7 0.024% 99.965% ( 1900, 2900 ] 8 0.028% 99.993% ( 2900, 4400 ] 2 0.007% 100.000% ** Level 4 read latency histogram (micros): Count: 35 Average: 1760.6571 StdDev: 1248.98 Min: 679 Median: 1174.5833 Max: 4886 Percentiles: P50: 1174.58 P75: 2316.67 P99: 4886.00 P99.9: 4886.00 P99.99: 4886.00 ------------------------------------------------------ ( 580, 870 ] 9 25.714% 25.714% ##### ( 870, 1300 ] 12 34.286% 60.000% ####### ( 1300, 1900 ] 4 11.429% 71.429% ## ( 1900, 2900 ] 3 8.571% 80.000% ## ( 2900, 4400 ] 6 17.143% 97.143% ### ( 4400, 6600 ] 1 2.857% 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, 326.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.029 H:M:S, 11.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 327.59 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.395 H:M:S, 13.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/02-13:39:03 ... thread 0: (1000000,4000000) ops and (282718.9,322728.8) ops/second in (3.537082,12.394309) 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/13 3.32 GB 144.7 2.7 0.0 2.7 6.5 3.7 0.0 1.7 128.7 307.0 21.54 20.14 65 0.331 2814K 2856 0.0 0.0 L1 1/1 2.37 MB 0.0 0.3 0.2 0.1 0.3 0.2 0.2 1.2 247.2 246.9 1.27 1.24 1 1.274 319K 355 0.0 0.0 L2 2/0 55.68 MB 0.6 0.1 0.1 0.1 0.1 0.1 0.5 2.0 237.7 237.6 0.53 0.51 1 0.530 127K 43 0.0 0.0 L3 54/0 986.66 MB 1.0 0.5 0.4 0.1 0.5 0.4 0.1 1.3 182.6 182.4 2.71 2.24 2 1.356 502K 347 0.0 0.0 L4 136/0 9.73 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.1 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1044/0 85.82 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 1256/14 99.89 GB 0.0 3.6 0.7 2.9 7.4 4.4 0.9 2.0 142.3 289.7 26.06 24.12 69 0.378 3764K 3601 0.0 0.0 Int 0/0 0.00 KB 0.0 3.6 0.7 2.9 7.4 4.4 0.8 2.0 142.3 289.7 26.06 24.12 69 0.378 3764K 3601 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.6 0.7 2.9 3.6 0.7 0.0 0.0 245.8 245.5 15.09 14.33 14 1.078 3764K 3601 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 3.8 3.8 0.0 0.0 0.0 350.4 10.97 9.78 55 0.199 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 12.6 total, 12.4 interval Flush(GB): cumulative 3.753, interval 3.753 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 7.37 GB write, 599.74 MB/s write, 3.62 GB read, 294.67 MB/s read, 26.1 seconds Interval compaction: 7.37 GB write, 608.85 MB/s write, 3.62 GB read, 299.14 MB/s read, 26.1 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 4, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 4, 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: 4, total-stops: 11, interval: 15 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1176484 Average: 2.1129 StdDev: 11.41 Min: 0 Median: 1.4443 Max: 3435 Percentiles: P50: 1.44 P75: 1.83 P99: 5.32 P99.9: 9.64 P99.99: 14.01 ------------------------------------------------------ [ 0, 1 ] 245846 20.897% 20.897% #### ( 1, 2 ] 770569 65.498% 86.394% ############# ( 2, 3 ] 101088 8.592% 94.987% ## ( 3, 4 ] 34724 2.952% 97.938% # ( 4, 6 ] 18861 1.603% 99.541% ( 6, 10 ] 4642 0.395% 99.936% ( 10, 15 ] 798 0.068% 100.004% ( 15, 22 ] 67 0.006% 100.009% ( 22, 34 ] 22 0.002% 100.011% ( 34, 51 ] 9 0.001% 100.012% ( 51, 76 ] 19 0.002% 100.014% ( 76, 110 ] 21 0.002% 100.015% ( 110, 170 ] 65 0.006% 100.021% ( 170, 250 ] 49 0.004% 100.025% ( 250, 380 ] 29 0.002% 100.028% ( 380, 580 ] 13 0.001% 100.029% ( 580, 870 ] 22 0.002% 100.031% ( 870, 1300 ] 12 0.001% 100.032% ( 1300, 1900 ] 8 0.001% 100.032% ( 1900, 2900 ] 7 0.001% 100.033% ( 2900, 4400 ] 6 0.001% 100.033% ** Level 1 read latency histogram (micros): Count: 65404 Average: 2.3939 StdDev: 11.46 Min: 1 Median: 1.6036 Max: 2122 Percentiles: P50: 1.60 P75: 1.98 P99: 5.83 P99.9: 12.74 P99.99: 313.25 ------------------------------------------------------ [ 0, 1 ] 6375 9.747% 9.747% ## ( 1, 2 ] 43620 66.693% 76.440% ############# ( 2, 3 ] 10356 15.834% 92.274% ### ( 3, 4 ] 2714 4.150% 96.424% # ( 4, 6 ] 1845 2.821% 99.245% # ( 6, 10 ] 376 0.575% 99.820% ( 10, 15 ] 96 0.147% 99.966% ( 15, 22 ] 7 0.011% 99.977% ( 22, 34 ] 1 0.002% 99.979% ( 34, 51 ] 2 0.003% 99.982% ( 76, 110 ] 2 0.003% 99.985% ( 110, 170 ] 2 0.003% 99.988% ( 250, 380 ] 3 0.005% 99.992% ( 380, 580 ] 1 0.002% 99.994% ( 580, 870 ] 1 0.002% 99.995% ( 870, 1300 ] 1 0.002% 99.997% ( 1300, 1900 ] 1 0.002% 99.998% ( 1900, 2900 ] 1 0.002% 100.000% ** Level 2 read latency histogram (micros): Count: 31731 Average: 1.6777 StdDev: 7.76 Min: 1 Median: 1.1225 Max: 1332 Percentiles: P50: 1.12 P75: 1.59 P99: 3.23 P99.9: 9.06 P99.99: 31.92 ------------------------------------------------------ [ 0, 1 ] 13788 43.453% 43.453% ######### ( 1, 2 ] 16958 53.443% 96.896% ########### ( 2, 3 ] 619 1.951% 98.847% ( 3, 4 ] 211 0.665% 99.512% ( 4, 6 ] 82 0.258% 99.770% ( 6, 10 ] 54 0.170% 99.940% ( 10, 15 ] 12 0.038% 99.978% ( 15, 22 ] 3 0.009% 99.987% ( 22, 34 ] 1 0.003% 99.991% ( 51, 76 ] 1 0.003% 99.994% ( 250, 380 ] 1 0.003% 99.997% ( 1300, 1900 ] 1 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 28955 Average: 4.3329 StdDev: 61.37 Min: 0 Median: 1.6070 Max: 3699 Percentiles: P50: 1.61 P75: 1.99 P99: 6.89 P99.9: 835.38 P99.99: 2788.06 ------------------------------------------------------ [ 0, 1 ] 2989 10.323% 10.323% ## ( 1, 2 ] 18927 65.367% 75.690% ############# ( 2, 3 ] 4719 16.298% 91.988% ### ( 3, 4 ] 1143 3.948% 95.935% # ( 4, 6 ] 846 2.922% 98.857% # ( 6, 10 ] 187 0.646% 99.503% ( 10, 15 ] 47 0.162% 99.665% ( 15, 22 ] 18 0.062% 99.727% ( 22, 34 ] 27 0.093% 99.820% ( 34, 51 ] 3 0.010% 99.831% ( 110, 170 ] 3 0.010% 99.841% ( 170, 250 ] 5 0.017% 99.858% ( 250, 380 ] 3 0.010% 99.869% ( 380, 580 ] 2 0.007% 99.876% ( 580, 870 ] 8 0.028% 99.903% ( 870, 1300 ] 11 0.038% 99.941% ( 1300, 1900 ] 7 0.024% 99.965% ( 1900, 2900 ] 8 0.028% 99.993% ( 2900, 4400 ] 2 0.007% 100.000% ** Level 4 read latency histogram (micros): Count: 35 Average: 1760.6571 StdDev: 1248.98 Min: 679 Median: 1174.5833 Max: 4886 Percentiles: P50: 1174.58 P75: 2316.67 P99: 4886.00 P99.9: 4886.00 P99.99: 4886.00 ------------------------------------------------------ ( 580, 870 ] 9 25.714% 25.714% ##### ( 870, 1300 ] 12 34.286% 60.000% ####### ( 1300, 1900 ] 4 11.429% 71.429% ## ( 1900, 2900 ] 3 8.571% 80.000% ## ( 2900, 4400 ] 6 17.143% 97.143% ### ( 4400, 6600 ] 1 2.857% 100.000% # ** DB Stats ** Uptime(secs): 12.6 total, 3.5 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 312.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.878 H:M:S, 14.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 278.25 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.849 H:M:S, 24.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/02-13:39:06 ... thread 0: (1000000,5000000) ops and (265278.3,309330.6) ops/second in (3.769626,16.163935) 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/13 2.58 GB 37.8 3.4 0.0 3.4 8.1 4.7 0.0 1.7 130.5 307.5 27.03 25.28 82 0.330 3582K 3641 0.0 0.0 L1 15/15 1.65 GB 0.0 2.0 1.9 0.1 2.0 1.9 0.2 1.0 230.3 228.8 8.76 8.48 2 4.379 2047K 12K 0.0 0.0 L2 2/0 55.68 MB 0.6 0.1 0.1 0.1 0.1 0.1 0.5 2.0 237.7 237.6 0.53 0.51 1 0.530 127K 43 0.0 0.0 L3 54/0 986.66 MB 1.0 0.5 0.4 0.1 0.5 0.4 0.1 1.3 182.6 182.4 2.71 2.24 2 1.356 502K 347 0.0 0.0 L4 136/0 9.73 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.1 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1044/0 85.82 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 1266/28 100.80 GB 0.0 6.0 2.3 3.7 10.7 7.0 0.9 2.3 158.0 280.2 39.03 36.51 87 0.449 6260K 16K 0.0 0.0 Int 0/0 0.00 KB 0.0 6.0 2.3 3.7 10.7 7.0 0.8 2.3 158.0 280.2 39.03 36.51 87 0.449 6260K 16K 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 6.0 2.3 3.7 6.0 2.3 0.0 0.0 243.3 242.7 25.34 24.29 18 1.408 6260K 16K 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 349.6 13.69 12.22 69 0.198 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): 16.4 total, 16.2 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.68 GB write, 668.74 MB/s write, 6.02 GB read, 377.03 MB/s read, 39.0 seconds Interval compaction: 10.68 GB write, 676.53 MB/s write, 6.02 GB read, 381.42 MB/s read, 39.0 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: 12, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 8, total-stops: 12, interval: 20 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1497721 Average: 2.1449 StdDev: 11.76 Min: 0 Median: 1.4432 Max: 3435 Percentiles: P50: 1.44 P75: 1.82 P99: 5.35 P99.9: 9.79 P99.99: 21.77 ------------------------------------------------------ [ 0, 1 ] 311300 20.785% 20.785% #### ( 1, 2 ] 987306 65.921% 86.705% ############# ( 2, 3 ] 125591 8.385% 95.091% ## ( 3, 4 ] 43054 2.875% 97.966% # ( 4, 6 ] 22878 1.528% 99.493% ( 6, 10 ] 6427 0.429% 99.922% ( 10, 15 ] 932 0.062% 99.984% ( 15, 22 ] 86 0.006% 99.990% ( 22, 34 ] 27 0.002% 99.992% ( 34, 51 ] 9 0.001% 99.993% ( 51, 76 ] 22 0.001% 99.994% ( 76, 110 ] 72 0.005% 99.999% ( 110, 170 ] 176 0.012% 100.011% ( 170, 250 ] 98 0.007% 100.017% ( 250, 380 ] 64 0.004% 100.021% ( 380, 580 ] 44 0.003% 100.024% ( 580, 870 ] 33 0.002% 100.027% ( 870, 1300 ] 20 0.001% 100.028% ( 1300, 1900 ] 12 0.001% 100.029% ( 1900, 2900 ] 10 0.001% 100.029% ( 2900, 4400 ] 6 0.000% 100.030% ** Level 1 read latency histogram (micros): Count: 113636 Average: 2.6600 StdDev: 16.46 Min: 0 Median: 1.5283 Max: 2122 Percentiles: P50: 1.53 P75: 1.91 P99: 6.87 P99.9: 148.32 P99.99: 897.37 ------------------------------------------------------ [ 0, 1 ] 17403 15.315% 15.315% ### ( 1, 2 ] 74608 65.655% 80.970% ############# ( 2, 3 ] 13743 12.094% 93.064% ## ( 3, 4 ] 4003 3.523% 96.586% # ( 4, 6 ] 2537 2.233% 98.819% ( 6, 10 ] 946 0.832% 99.652% ( 10, 15 ] 157 0.138% 99.790% ( 15, 22 ] 13 0.011% 99.801% ( 22, 34 ] 2 0.002% 99.803% ( 34, 51 ] 3 0.003% 99.806% ( 51, 76 ] 4 0.004% 99.809% ( 76, 110 ] 51 0.045% 99.854% ( 110, 170 ] 82 0.072% 99.926% ( 170, 250 ] 26 0.023% 99.949% ( 250, 380 ] 17 0.015% 99.964% ( 380, 580 ] 20 0.018% 99.982% ( 580, 870 ] 9 0.008% 99.989% ( 870, 1300 ] 10 0.009% 99.998% ( 1300, 1900 ] 1 0.001% 99.999% ( 1900, 2900 ] 1 0.001% 100.000% ** Level 2 read latency histogram (micros): Count: 31731 Average: 1.6777 StdDev: 7.76 Min: 1 Median: 1.1225 Max: 1332 Percentiles: P50: 1.12 P75: 1.59 P99: 3.23 P99.9: 9.06 P99.99: 31.92 ------------------------------------------------------ [ 0, 1 ] 13788 43.453% 43.453% ######### ( 1, 2 ] 16958 53.443% 96.896% ########### ( 2, 3 ] 619 1.951% 98.847% ( 3, 4 ] 211 0.665% 99.512% ( 4, 6 ] 82 0.258% 99.770% ( 6, 10 ] 54 0.170% 99.940% ( 10, 15 ] 12 0.038% 99.978% ( 15, 22 ] 3 0.009% 99.987% ( 22, 34 ] 1 0.003% 99.991% ( 51, 76 ] 1 0.003% 99.994% ( 250, 380 ] 1 0.003% 99.997% ( 1300, 1900 ] 1 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 28955 Average: 4.3329 StdDev: 61.37 Min: 0 Median: 1.6070 Max: 3699 Percentiles: P50: 1.61 P75: 1.99 P99: 6.89 P99.9: 835.38 P99.99: 2788.06 ------------------------------------------------------ [ 0, 1 ] 2989 10.323% 10.323% ## ( 1, 2 ] 18927 65.367% 75.690% ############# ( 2, 3 ] 4719 16.298% 91.988% ### ( 3, 4 ] 1143 3.948% 95.935% # ( 4, 6 ] 846 2.922% 98.857% # ( 6, 10 ] 187 0.646% 99.503% ( 10, 15 ] 47 0.162% 99.665% ( 15, 22 ] 18 0.062% 99.727% ( 22, 34 ] 27 0.093% 99.820% ( 34, 51 ] 3 0.010% 99.831% ( 110, 170 ] 3 0.010% 99.841% ( 170, 250 ] 5 0.017% 99.858% ( 250, 380 ] 3 0.010% 99.869% ( 380, 580 ] 2 0.007% 99.876% ( 580, 870 ] 8 0.028% 99.903% ( 870, 1300 ] 11 0.038% 99.941% ( 1300, 1900 ] 7 0.024% 99.965% ( 1900, 2900 ] 8 0.028% 99.993% ( 2900, 4400 ] 2 0.007% 100.000% ** Level 4 read latency histogram (micros): Count: 35 Average: 1760.6571 StdDev: 1248.98 Min: 679 Median: 1174.5833 Max: 4886 Percentiles: P50: 1174.58 P75: 2316.67 P99: 4886.00 P99.9: 4886.00 P99.99: 4886.00 ------------------------------------------------------ ( 580, 870 ] 9 25.714% 25.714% ##### ( 870, 1300 ] 12 34.286% 60.000% ####### ( 1300, 1900 ] 4 11.429% 71.429% ## ( 1900, 2900 ] 3 8.571% 80.000% ## ( 2900, 4400 ] 6 17.143% 97.143% ### ( 4400, 6600 ] 1 2.857% 100.000% # ** DB Stats ** Uptime(secs): 16.4 total, 3.8 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 300.91 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:3.003 H:M:S, 18.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 261.08 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.125 H:M:S, 29.8 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/02-13:39:10 ... thread 0: (1000000,6000000) ops and (302910.2,308241.7) ops/second in (3.301308,19.465243) 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 20/13 3.57 GB 138.5 4.2 0.0 4.2 9.9 5.7 0.0 1.7 131.7 307.1 33.01 30.89 99 0.333 4413K 4458 0.0 0.0 L1 15/15 1.65 GB 0.0 2.0 1.9 0.1 2.0 1.9 0.2 1.0 230.3 228.8 8.76 8.48 2 4.379 2047K 12K 0.0 0.0 L2 2/0 55.68 MB 0.6 0.1 0.1 0.1 0.1 0.1 0.5 2.0 237.7 237.6 0.53 0.51 1 0.530 127K 43 0.0 0.0 L3 54/0 986.66 MB 1.0 0.5 0.4 0.1 0.5 0.4 0.1 1.3 182.6 182.4 2.71 2.24 2 1.356 502K 347 0.0 0.0 L4 136/0 9.73 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.1 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1044/0 85.82 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 1271/28 101.78 GB 0.0 6.8 2.3 4.5 12.5 8.0 0.9 2.2 155.2 283.6 45.01 42.11 104 0.433 7092K 17K 0.0 0.0 Int 0/0 0.00 KB 0.0 6.8 2.3 4.5 12.5 8.0 0.8 2.2 155.2 283.6 45.01 42.11 104 0.433 7092K 17K 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 6.8 2.3 4.5 6.8 2.3 0.0 0.0 245.5 244.9 28.45 27.34 21 1.355 7092K 17K 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 350.0 16.56 14.77 83 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): 19.7 total, 19.5 interval Flush(GB): cumulative 5.660, interval 5.660 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 12.46 GB write, 649.32 MB/s write, 6.82 GB read, 355.37 MB/s read, 45.0 seconds Interval compaction: 12.46 GB write, 655.60 MB/s write, 6.82 GB read, 358.81 MB/s read, 45.0 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: 14, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 11, total-stops: 14, interval: 25 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1822605 Average: 2.1567 StdDev: 11.14 Min: 0 Median: 1.4526 Max: 3435 Percentiles: P50: 1.45 P75: 1.83 P99: 5.39 P99.9: 9.76 P99.99: 20.71 ------------------------------------------------------ [ 0, 1 ] 364026 19.973% 19.973% #### ( 1, 2 ] 1209080 66.338% 86.311% ############# ( 2, 3 ] 157598 8.647% 94.958% ## ( 3, 4 ] 53839 2.954% 97.912% # ( 4, 6 ] 28605 1.569% 99.481% ( 6, 10 ] 8126 0.446% 99.927% ( 10, 15 ] 1069 0.059% 99.986% ( 15, 22 ] 99 0.005% 99.991% ( 22, 34 ] 35 0.002% 99.993% ( 34, 51 ] 11 0.001% 99.994% ( 51, 76 ] 22 0.001% 99.995% ( 76, 110 ] 88 0.005% 100.000% ( 110, 170 ] 217 0.012% 100.012% ( 170, 250 ] 122 0.007% 100.018% ( 250, 380 ] 79 0.004% 100.023% ( 380, 580 ] 56 0.003% 100.026% ( 580, 870 ] 51 0.003% 100.028% ( 870, 1300 ] 23 0.001% 100.030% ( 1300, 1900 ] 12 0.001% 100.030% ( 1900, 2900 ] 10 0.001% 100.031% ( 2900, 4400 ] 6 0.000% 100.031% ** Level 1 read latency histogram (micros): Count: 200131 Average: 2.6440 StdDev: 15.93 Min: 0 Median: 1.5199 Max: 2867 Percentiles: P50: 1.52 P75: 1.89 P99: 7.46 P99.9: 153.94 P99.99: 761.01 ------------------------------------------------------ [ 0, 1 ] 30649 15.314% 15.314% ### ( 1, 2 ] 133515 66.714% 82.028% ############# ( 2, 3 ] 22364 11.175% 93.203% ## ( 3, 4 ] 6667 3.331% 96.534% # ( 4, 6 ] 4141 2.069% 98.603% ( 6, 10 ] 2170 1.084% 99.688% ( 10, 15 ] 189 0.094% 99.782% ( 15, 22 ] 17 0.008% 99.791% ( 22, 34 ] 2 0.001% 99.792% ( 34, 51 ] 3 0.001% 99.793% ( 51, 76 ] 5 0.002% 99.796% ( 76, 110 ] 110 0.055% 99.851% ( 110, 170 ] 135 0.067% 99.918% ( 170, 250 ] 61 0.030% 99.949% ( 250, 380 ] 40 0.020% 99.969% ( 380, 580 ] 33 0.016% 99.985% ( 580, 870 ] 16 0.008% 99.993% ( 870, 1300 ] 11 0.005% 99.999% ( 1300, 1900 ] 1 0.000% 99.999% ( 1900, 2900 ] 2 0.001% 100.000% ** Level 2 read latency histogram (micros): Count: 31731 Average: 1.6777 StdDev: 7.76 Min: 1 Median: 1.1225 Max: 1332 Percentiles: P50: 1.12 P75: 1.59 P99: 3.23 P99.9: 9.06 P99.99: 31.92 ------------------------------------------------------ [ 0, 1 ] 13788 43.453% 43.453% ######### ( 1, 2 ] 16958 53.443% 96.896% ########### ( 2, 3 ] 619 1.951% 98.847% ( 3, 4 ] 211 0.665% 99.512% ( 4, 6 ] 82 0.258% 99.770% ( 6, 10 ] 54 0.170% 99.940% ( 10, 15 ] 12 0.038% 99.978% ( 15, 22 ] 3 0.009% 99.987% ( 22, 34 ] 1 0.003% 99.991% ( 51, 76 ] 1 0.003% 99.994% ( 250, 380 ] 1 0.003% 99.997% ( 1300, 1900 ] 1 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 28955 Average: 4.3329 StdDev: 61.37 Min: 0 Median: 1.6070 Max: 3699 Percentiles: P50: 1.61 P75: 1.99 P99: 6.89 P99.9: 835.38 P99.99: 2788.06 ------------------------------------------------------ [ 0, 1 ] 2989 10.323% 10.323% ## ( 1, 2 ] 18927 65.367% 75.690% ############# ( 2, 3 ] 4719 16.298% 91.988% ### ( 3, 4 ] 1143 3.948% 95.935% # ( 4, 6 ] 846 2.922% 98.857% # ( 6, 10 ] 187 0.646% 99.503% ( 10, 15 ] 47 0.162% 99.665% ( 15, 22 ] 18 0.062% 99.727% ( 22, 34 ] 27 0.093% 99.820% ( 34, 51 ] 3 0.010% 99.831% ( 110, 170 ] 3 0.010% 99.841% ( 170, 250 ] 5 0.017% 99.858% ( 250, 380 ] 3 0.010% 99.869% ( 380, 580 ] 2 0.007% 99.876% ( 580, 870 ] 8 0.028% 99.903% ( 870, 1300 ] 11 0.038% 99.941% ( 1300, 1900 ] 7 0.024% 99.965% ( 1900, 2900 ] 8 0.028% 99.993% ( 2900, 4400 ] 2 0.007% 100.000% ** Level 4 read latency histogram (micros): Count: 35 Average: 1760.6571 StdDev: 1248.98 Min: 679 Median: 1174.5833 Max: 4886 Percentiles: P50: 1174.58 P75: 2316.67 P99: 4886.00 P99.9: 4886.00 P99.99: 4886.00 ------------------------------------------------------ ( 580, 870 ] 9 25.714% 25.714% ##### ( 870, 1300 ] 12 34.286% 60.000% ####### ( 1300, 1900 ] 4 11.429% 71.429% ## ( 1900, 2900 ] 3 8.571% 80.000% ## ( 2900, 4400 ] 6 17.143% 97.143% ### ( 4400, 6600 ] 1 2.857% 100.000% # ** DB Stats ** Uptime(secs): 19.7 total, 3.3 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 300.44 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:3.692 H:M:S, 18.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 298.12 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.689 H:M:S, 20.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/02-13:39:25 ... thread 0: (1000000,7000000) ops and (66236.6,202530.9) ops/second in (15.097386,34.562629) 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 2.58 GB 63.0 4.8 0.0 4.8 11.4 6.6 0.0 1.7 125.3 298.6 39.22 35.76 114 0.344 4989K 5050 0.0 0.0 L1 14/14 1.55 GB 0.0 5.6 3.9 1.7 5.5 3.8 0.2 1.4 228.8 226.2 24.99 23.84 3 8.331 5808K 65K 0.0 0.0 L2 1/0 1013.34 KB 0.0 0.1 0.1 0.1 0.1 0.1 2.5 2.0 237.7 237.6 0.53 0.51 1 0.530 127K 43 0.0 0.0 L3 17/0 999.07 MB 1.0 1.8 1.4 0.4 1.8 1.4 1.1 1.3 162.6 162.4 11.47 8.64 11 1.043 1832K 881 0.0 0.0 L4 167/0 9.44 GB 1.0 1.1 1.0 0.1 1.1 1.0 1.2 1.1 148.2 147.8 7.54 5.08 14 0.539 1135K 3509 0.0 0.0 L5 1072/0 88.15 GB 0.9 0.0 0.0 0.0 0.0 0.0 2.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1289/28 102.71 GB 0.0 13.4 6.4 7.1 20.0 12.9 7.3 3.0 164.1 244.4 83.76 73.82 143 0.586 13M 75K 0.0 0.0 Int 0/0 0.00 KB 0.0 13.4 6.4 7.1 20.0 12.9 7.2 3.0 164.1 244.4 83.76 73.82 143 0.586 13M 75K 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.4 6.4 7.1 13.3 6.3 0.0 0.0 217.3 216.1 63.24 56.35 47 1.345 13M 75K 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 331.6 20.52 17.47 96 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): 34.8 total, 34.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: 19.99 GB write, 589.02 MB/s write, 13.42 GB read, 395.46 MB/s read, 83.8 seconds Interval compaction: 19.99 GB write, 592.22 MB/s write, 13.42 GB read, 397.61 MB/s read, 83.8 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 12, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 12, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 38, pending-compaction-bytes-delays: 5, pending-compaction-bytes-stops: 0, total-delays: 17, total-stops: 38, interval: 55 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2527482 Average: 2.4305 StdDev: 16.47 Min: 0 Median: 1.4522 Max: 4229 Percentiles: P50: 1.45 P75: 1.84 P99: 5.80 P99.9: 93.73 P99.99: 247.15 ------------------------------------------------------ [ 0, 1 ] 533161 21.095% 21.095% #### ( 1, 2 ] 1615462 63.916% 85.010% ############# ( 2, 3 ] 221271 8.755% 93.765% ## ( 3, 4 ] 81508 3.225% 96.990% # ( 4, 6 ] 56478 2.235% 99.224% ( 6, 10 ] 14149 0.560% 99.784% ( 10, 15 ] 1780 0.070% 99.855% ( 15, 22 ] 240 0.009% 99.864% ( 22, 34 ] 42 0.002% 99.866% ( 34, 51 ] 15 0.001% 99.866% ( 51, 76 ] 59 0.002% 99.869% ( 76, 110 ] 1514 0.060% 99.929% ( 110, 170 ] 1151 0.046% 99.974% ( 170, 250 ] 414 0.016% 99.991% ( 250, 380 ] 327 0.013% 100.004% ( 380, 580 ] 306 0.012% 100.016% ( 580, 870 ] 148 0.006% 100.021% ( 870, 1300 ] 64 0.003% 100.024% ( 1300, 1900 ] 32 0.001% 100.025% ( 1900, 2900 ] 27 0.001% 100.026% ( 2900, 4400 ] 15 0.001% 100.027% ** Level 1 read latency histogram (micros): Count: 867149 Average: 3.6957 StdDev: 56.31 Min: 0 Median: 1.5620 Max: 11838 Percentiles: P50: 1.56 P75: 2.01 P99: 8.02 P99.9: 108.26 P99.99: 234.56 ------------------------------------------------------ [ 0, 1 ] 157067 18.113% 18.113% #### ( 1, 2 ] 491965 56.734% 74.847% ########### ( 2, 3 ] 111999 12.916% 87.762% ### ( 3, 4 ] 47792 5.511% 93.274% # ( 4, 6 ] 44310 5.110% 98.384% # ( 6, 10 ] 10608 1.223% 99.607% ( 10, 15 ] 1541 0.178% 99.785% ( 15, 22 ] 206 0.024% 99.808% ( 22, 34 ] 20 0.002% 99.811% ( 34, 51 ] 11 0.001% 99.812% ( 51, 76 ] 75 0.009% 99.821% ( 76, 110 ] 725 0.084% 99.904% ( 110, 170 ] 619 0.071% 99.976% ( 170, 250 ] 154 0.018% 99.993% ( 250, 380 ] 167 0.019% 100.013% ( 380, 580 ] 182 0.021% 100.034% ( 580, 870 ] 154 0.018% 100.051% ( 870, 1300 ] 113 0.013% 100.064% ( 1300, 1900 ] 65 0.007% 100.072% ( 1900, 2900 ] 76 0.009% 100.081% ( 2900, 4400 ] 65 0.007% 100.088% ( 4400, 6600 ] 18 0.002% 100.090% ( 6600, 9900 ] 6 0.001% 100.091% ( 9900, 14000 ] 2 0.000% 100.091% ** Level 2 read latency histogram (micros): Count: 31731 Average: 1.6777 StdDev: 7.76 Min: 1 Median: 1.1225 Max: 1332 Percentiles: P50: 1.12 P75: 1.59 P99: 3.23 P99.9: 9.06 P99.99: 31.92 ------------------------------------------------------ [ 0, 1 ] 13788 43.453% 43.453% ######### ( 1, 2 ] 16958 53.443% 96.896% ########### ( 2, 3 ] 619 1.951% 98.847% ( 3, 4 ] 211 0.665% 99.512% ( 4, 6 ] 82 0.258% 99.770% ( 6, 10 ] 54 0.170% 99.940% ( 10, 15 ] 12 0.038% 99.978% ( 15, 22 ] 3 0.009% 99.987% ( 22, 34 ] 1 0.003% 99.991% ( 51, 76 ] 1 0.003% 99.994% ( 250, 380 ] 1 0.003% 99.997% ( 1300, 1900 ] 1 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 286418 Average: 9.5116 StdDev: 109.14 Min: 0 Median: 1.9300 Max: 10645 Percentiles: P50: 1.93 P75: 2.96 P99: 10.56 P99.9: 779.30 P99.99: 1114.07 ------------------------------------------------------ [ 0, 1 ] 7389 2.580% 2.580% # ( 1, 2 ] 146046 50.991% 53.570% ########## ( 2, 3 ] 63643 22.220% 75.791% #### ( 3, 4 ] 31773 11.093% 86.884% ## ( 4, 6 ] 30120 10.516% 97.400% ## ( 6, 10 ] 4502 1.572% 98.972% ( 10, 15 ] 724 0.253% 99.225% ( 15, 22 ] 115 0.040% 99.265% ( 22, 34 ] 31 0.011% 99.276% ( 34, 51 ] 3 0.001% 99.277% ( 51, 76 ] 2 0.001% 99.277% ( 76, 110 ] 106 0.037% 99.314% ( 110, 170 ] 287 0.100% 99.414% ( 170, 250 ] 318 0.111% 99.526% ( 250, 380 ] 368 0.128% 99.654% ( 380, 580 ] 440 0.154% 99.808% ( 580, 870 ] 385 0.134% 99.942% ( 870, 1300 ] 242 0.084% 100.027% ( 1300, 1900 ] 136 0.047% 100.074% ( 1900, 2900 ] 109 0.038% 100.112% ( 2900, 4400 ] 110 0.038% 100.150% ( 4400, 6600 ] 14 0.005% 100.155% ( 9900, 14000 ] 1 0.000% 100.156% ** Level 4 read latency histogram (micros): Count: 225 Average: 403.6533 StdDev: 921.85 Min: 0 Median: 2.6346 Max: 4886 Percentiles: P50: 2.63 P75: 225.29 P99: 4346.43 P99.9: 4886.00 P99.99: 4886.00 ------------------------------------------------------ [ 0, 1 ] 30 13.333% 13.333% ### ( 1, 2 ] 66 29.333% 42.667% ###### ( 2, 3 ] 26 11.556% 54.222% ## ( 3, 4 ] 9 4.000% 58.222% # ( 4, 6 ] 5 2.222% 60.444% ( 6, 10 ] 8 3.556% 64.000% # ( 10, 15 ] 8 3.556% 67.556% # ( 15, 22 ] 1 0.444% 68.000% ( 22, 34 ] 1 0.444% 68.444% ( 34, 51 ] 1 0.444% 68.889% ( 110, 170 ] 2 0.889% 69.778% ( 170, 250 ] 17 7.556% 77.333% ## ( 250, 380 ] 3 1.333% 78.667% ( 580, 870 ] 10 4.444% 83.111% # ( 870, 1300 ] 17 7.556% 90.667% ## ( 1300, 1900 ] 7 3.111% 93.778% # ( 1900, 2900 ] 5 2.222% 96.000% ( 2900, 4400 ] 7 3.111% 99.111% # ( 4400, 6600 ] 2 0.889% 100.000% ** Level 5 read latency histogram (micros): Count: 140 Average: 1173.8143 StdDev: 1395.45 Min: 78 Median: 553.3333 Max: 7378 Percentiles: P50: 553.33 P75: 1900.00 P99: 6306.67 P99.9: 7378.00 P99.99: 7378.00 ------------------------------------------------------ ( 76, 110 ] 10 7.143% 7.143% # ( 110, 170 ] 20 14.286% 21.429% ### ( 170, 250 ] 14 10.000% 31.429% ## ( 250, 380 ] 13 9.286% 40.714% ## ( 380, 580 ] 15 10.714% 51.429% ## ( 580, 870 ] 16 11.429% 62.857% ## ( 870, 1300 ] 9 6.429% 69.286% # ( 1300, 1900 ] 8 5.714% 75.000% # ( 1900, 2900 ] 15 10.714% 85.714% ## ( 2900, 4400 ] 16 11.429% 97.143% ## ( 4400, 6600 ] 3 2.143% 99.286% ( 6600, 9900 ] 1 0.714% 100.000% ** DB Stats ** Uptime(secs): 34.8 total, 15.1 interval Cumulative writes: 0 writes, 7000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 6.73 GB, 198.24 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:15.649 H:M:S, 45.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 65.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:11.957 H:M:S, 79.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/02-13:39:33 ... thread 0: (1000000,8000000) ops and (118884.9,186158.5) ops/second in (8.411497,42.974126) 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/10 3.56 GB 188.4 6.8 0.0 6.8 14.4 7.6 0.0 1.9 139.8 295.8 50.01 46.06 134 0.373 7099K 10K 0.0 0.0 L1 14/14 1.55 GB 0.0 5.6 3.9 1.7 5.5 3.8 0.2 1.4 228.8 226.2 24.99 23.84 3 8.331 5808K 65K 0.0 0.0 L2 1/0 1013.34 KB 0.0 0.1 0.1 0.1 0.1 0.1 2.5 2.0 237.7 237.6 0.53 0.51 1 0.530 127K 43 0.0 0.0 L3 17/0 999.07 MB 1.0 1.8 1.4 0.4 1.8 1.4 1.1 1.3 162.6 162.4 11.47 8.64 11 1.043 1832K 881 0.0 0.0 L4 167/0 9.44 GB 1.0 1.1 1.0 0.1 1.1 1.0 1.2 1.1 148.2 147.8 7.54 5.08 14 0.539 1135K 3509 0.0 0.0 L5 1072/0 88.15 GB 0.9 0.0 0.0 0.0 0.0 0.0 2.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1288/24 103.68 GB 0.0 15.5 6.4 9.1 23.0 13.9 7.3 3.0 167.3 249.1 94.55 84.13 163 0.580 16M 80K 0.0 0.0 Int 0/0 0.00 KB 0.0 15.5 6.4 9.1 23.0 13.9 7.2 3.0 167.3 249.1 94.55 84.13 163 0.580 16M 80K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 15.5 6.4 9.1 15.4 6.3 0.0 0.0 222.5 221.4 71.10 64.04 52 1.367 16M 80K 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 333.0 23.46 20.08 111 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): 43.2 total, 43.0 interval Flush(GB): cumulative 7.629, interval 7.629 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.00 GB write, 545.61 MB/s write, 15.45 GB read, 366.54 MB/s read, 94.6 seconds Interval compaction: 23.00 GB write, 548.00 MB/s write, 15.45 GB read, 368.14 MB/s read, 94.6 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 20, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 20, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 40, pending-compaction-bytes-delays: 5, pending-compaction-bytes-stops: 0, total-delays: 25, total-stops: 40, interval: 65 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3213760 Average: 2.4107 StdDev: 15.57 Min: 0 Median: 1.4538 Max: 4229 Percentiles: P50: 1.45 P75: 1.84 P99: 5.79 P99.9: 95.94 P99.99: 241.90 ------------------------------------------------------ [ 0, 1 ] 661521 20.584% 20.584% #### ( 1, 2 ] 2083133 64.819% 85.403% ############# ( 2, 3 ] 277080 8.622% 94.025% ## ( 3, 4 ] 101563 3.160% 97.185% # ( 4, 6 ] 65297 2.032% 99.217% ( 6, 10 ] 18363 0.571% 99.788% ( 10, 15 ] 2070 0.064% 99.853% ( 15, 22 ] 296 0.009% 99.862% ( 22, 34 ] 49 0.002% 99.863% ( 34, 51 ] 18 0.001% 99.864% ( 51, 76 ] 60 0.002% 99.866% ( 76, 110 ] 1869 0.058% 99.924% ( 110, 170 ] 1646 0.051% 99.975% ( 170, 250 ] 527 0.016% 99.992% ( 250, 380 ] 396 0.012% 100.004% ( 380, 580 ] 363 0.011% 100.015% ( 580, 870 ] 177 0.006% 100.021% ( 870, 1300 ] 70 0.002% 100.023% ( 1300, 1900 ] 33 0.001% 100.024% ( 1900, 2900 ] 29 0.001% 100.025% ( 2900, 4400 ] 17 0.001% 100.025% ** Level 1 read latency histogram (micros): Count: 1142441 Average: 3.4017 StdDev: 49.26 Min: 0 Median: 1.5470 Max: 11838 Percentiles: P50: 1.55 P75: 1.97 P99: 7.99 P99.9: 114.93 P99.99: 253.90 ------------------------------------------------------ [ 0, 1 ] 198288 17.357% 17.357% ### ( 1, 2 ] 681807 59.680% 77.036% ############ ( 2, 3 ] 138894 12.158% 89.194% ## ( 3, 4 ] 55964 4.899% 94.093% # ( 4, 6 ] 48995 4.289% 98.381% # ( 6, 10 ] 14236 1.246% 99.627% ( 10, 15 ] 1749 0.153% 99.780% ( 15, 22 ] 239 0.021% 99.801% ( 22, 34 ] 21 0.002% 99.803% ( 34, 51 ] 12 0.001% 99.804% ( 51, 76 ] 101 0.009% 99.813% ( 76, 110 ] 918 0.080% 99.893% ( 110, 170 ] 907 0.079% 99.973% ( 170, 250 ] 190 0.017% 99.989% ( 250, 380 ] 192 0.017% 100.006% ( 380, 580 ] 211 0.018% 100.025% ( 580, 870 ] 160 0.014% 100.039% ( 870, 1300 ] 116 0.010% 100.049% ( 1300, 1900 ] 65 0.006% 100.055% ( 1900, 2900 ] 76 0.007% 100.061% ( 2900, 4400 ] 65 0.006% 100.067% ( 4400, 6600 ] 18 0.002% 100.069% ( 6600, 9900 ] 6 0.001% 100.069% ( 9900, 14000 ] 2 0.000% 100.069% ** Level 2 read latency histogram (micros): Count: 31731 Average: 1.6777 StdDev: 7.76 Min: 1 Median: 1.1225 Max: 1332 Percentiles: P50: 1.12 P75: 1.59 P99: 3.23 P99.9: 9.06 P99.99: 31.92 ------------------------------------------------------ [ 0, 1 ] 13788 43.453% 43.453% ######### ( 1, 2 ] 16958 53.443% 96.896% ########### ( 2, 3 ] 619 1.951% 98.847% ( 3, 4 ] 211 0.665% 99.512% ( 4, 6 ] 82 0.258% 99.770% ( 6, 10 ] 54 0.170% 99.940% ( 10, 15 ] 12 0.038% 99.978% ( 15, 22 ] 3 0.009% 99.987% ( 22, 34 ] 1 0.003% 99.991% ( 51, 76 ] 1 0.003% 99.994% ( 250, 380 ] 1 0.003% 99.997% ( 1300, 1900 ] 1 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 286418 Average: 9.5116 StdDev: 109.14 Min: 0 Median: 1.9300 Max: 10645 Percentiles: P50: 1.93 P75: 2.96 P99: 10.56 P99.9: 779.30 P99.99: 1114.07 ------------------------------------------------------ [ 0, 1 ] 7389 2.580% 2.580% # ( 1, 2 ] 146046 50.991% 53.570% ########## ( 2, 3 ] 63643 22.220% 75.791% #### ( 3, 4 ] 31773 11.093% 86.884% ## ( 4, 6 ] 30120 10.516% 97.400% ## ( 6, 10 ] 4502 1.572% 98.972% ( 10, 15 ] 724 0.253% 99.225% ( 15, 22 ] 115 0.040% 99.265% ( 22, 34 ] 31 0.011% 99.276% ( 34, 51 ] 3 0.001% 99.277% ( 51, 76 ] 2 0.001% 99.277% ( 76, 110 ] 106 0.037% 99.314% ( 110, 170 ] 287 0.100% 99.414% ( 170, 250 ] 318 0.111% 99.526% ( 250, 380 ] 368 0.128% 99.654% ( 380, 580 ] 440 0.154% 99.808% ( 580, 870 ] 385 0.134% 99.942% ( 870, 1300 ] 242 0.084% 100.027% ( 1300, 1900 ] 136 0.047% 100.074% ( 1900, 2900 ] 109 0.038% 100.112% ( 2900, 4400 ] 110 0.038% 100.150% ( 4400, 6600 ] 14 0.005% 100.155% ( 9900, 14000 ] 1 0.000% 100.156% ** Level 4 read latency histogram (micros): Count: 225 Average: 403.6533 StdDev: 921.85 Min: 0 Median: 2.6346 Max: 4886 Percentiles: P50: 2.63 P75: 225.29 P99: 4346.43 P99.9: 4886.00 P99.99: 4886.00 ------------------------------------------------------ [ 0, 1 ] 30 13.333% 13.333% ### ( 1, 2 ] 66 29.333% 42.667% ###### ( 2, 3 ] 26 11.556% 54.222% ## ( 3, 4 ] 9 4.000% 58.222% # ( 4, 6 ] 5 2.222% 60.444% ( 6, 10 ] 8 3.556% 64.000% # ( 10, 15 ] 8 3.556% 67.556% # ( 15, 22 ] 1 0.444% 68.000% ( 22, 34 ] 1 0.444% 68.444% ( 34, 51 ] 1 0.444% 68.889% ( 110, 170 ] 2 0.889% 69.778% ( 170, 250 ] 17 7.556% 77.333% ## ( 250, 380 ] 3 1.333% 78.667% ( 580, 870 ] 10 4.444% 83.111% # ( 870, 1300 ] 17 7.556% 90.667% ## ( 1300, 1900 ] 7 3.111% 93.778% # ( 1900, 2900 ] 5 2.222% 96.000% ( 2900, 4400 ] 7 3.111% 99.111% # ( 4400, 6600 ] 2 0.889% 100.000% ** Level 5 read latency histogram (micros): Count: 140 Average: 1173.8143 StdDev: 1395.45 Min: 78 Median: 553.3333 Max: 7378 Percentiles: P50: 553.33 P75: 1900.00 P99: 6306.67 P99.9: 7378.00 P99.99: 7378.00 ------------------------------------------------------ ( 76, 110 ] 10 7.143% 7.143% # ( 110, 170 ] 20 14.286% 21.429% ### ( 170, 250 ] 14 10.000% 31.429% ## ( 250, 380 ] 13 9.286% 40.714% ## ( 380, 580 ] 15 10.714% 51.429% ## ( 580, 870 ] 16 11.429% 62.857% ## ( 870, 1300 ] 9 6.429% 69.286% # ( 1300, 1900 ] 8 5.714% 75.000% # ( 1900, 2900 ] 15 10.714% 85.714% ## ( 2900, 4400 ] 16 11.429% 97.143% ## ( 4400, 6600 ] 3 2.143% 99.286% ( 6600, 9900 ] 1 0.714% 100.000% ** DB Stats ** Uptime(secs): 43.2 total, 8.4 interval Cumulative writes: 0 writes, 8000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 7.69 GB, 182.41 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:21.372 H:M:S, 49.5 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 117.01 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:5.724 H:M:S, 68.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/11/02-13:39:40 ... thread 0: (1000000,9000000) ops and (140129.0,179603.4) ops/second in (7.136284,50.110410) 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/16 2.76 GB 0.0 7.1 0.0 7.1 15.6 8.5 0.0 1.8 131.4 289.9 55.15 49.50 147 0.375 7355K 10K 0.0 0.0 L1 16/16 1.76 GB 0.0 8.9 5.6 3.3 8.8 5.5 0.2 1.6 223.4 220.8 40.60 38.27 4 10.150 8121K 65K 0.0 0.0 L2 2/0 62.66 MB 0.6 0.1 0.1 0.1 0.1 0.1 4.0 2.0 237.7 237.6 0.53 0.51 1 0.530 127K 43 0.0 0.0 L3 22/0 979.32 MB 1.0 3.1 2.0 1.1 3.1 2.0 2.0 1.6 150.6 149.9 21.14 14.76 20 1.057 3171K 14K 0.0 0.0 L4 165/0 9.56 GB 1.0 2.9 2.4 0.5 2.9 2.4 1.2 1.2 146.1 145.6 20.56 13.75 31 0.663 3050K 10K 0.0 0.0 L5 1088/0 89.45 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 1309/32 104.55 GB 0.0 22.1 10.0 12.1 30.5 18.4 11.0 3.6 164.0 226.4 137.97 116.79 203 0.680 21M 101K 0.0 0.0 Int 0/0 0.00 KB 0.0 22.1 10.0 12.1 30.5 18.4 10.8 3.6 164.0 226.4 137.97 116.79 203 0.680 21M 101K 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.1 10.0 12.1 22.0 9.9 0.0 0.0 205.1 203.7 110.36 94.19 80 1.379 21M 101K 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 317.1 27.62 22.60 123 0.225 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): 50.3 total, 50.1 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.51 GB write, 621.08 MB/s write, 22.10 GB read, 449.88 MB/s read, 138.0 seconds Interval compaction: 30.51 GB write, 623.42 MB/s write, 22.10 GB read, 451.57 MB/s read, 138.0 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 22, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 22, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 63, pending-compaction-bytes-delays: 7, pending-compaction-bytes-stops: 0, total-delays: 29, total-stops: 63, interval: 92 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3576052 Average: 2.6397 StdDev: 27.01 Min: 0 Median: 1.4738 Max: 8294 Percentiles: P50: 1.47 P75: 1.86 P99: 5.93 P99.9: 105.73 P99.99: 349.77 ------------------------------------------------------ [ 0, 1 ] 700781 19.596% 19.596% #### ( 1, 2 ] 2294826 64.172% 83.769% ############# ( 2, 3 ] 333559 9.328% 93.096% ## ( 3, 4 ] 125871 3.520% 96.616% # ( 4, 6 ] 88273 2.468% 99.084% ( 6, 10 ] 23964 0.670% 99.755% ( 10, 15 ] 2737 0.077% 99.831% ( 15, 22 ] 397 0.011% 99.842% ( 22, 34 ] 62 0.002% 99.844% ( 34, 51 ] 21 0.001% 99.844% ( 51, 76 ] 76 0.002% 99.847% ( 76, 110 ] 2184 0.061% 99.908% ( 110, 170 ] 1910 0.053% 99.961% ( 170, 250 ] 633 0.018% 99.979% ( 250, 380 ] 523 0.015% 99.993% ( 380, 580 ] 511 0.014% 100.008% ( 580, 870 ] 271 0.008% 100.015% ( 870, 1300 ] 129 0.004% 100.019% ( 1300, 1900 ] 74 0.002% 100.021% ( 1900, 2900 ] 67 0.002% 100.023% ( 2900, 4400 ] 75 0.002% 100.025% ( 4400, 6600 ] 13 0.000% 100.025% ( 6600, 9900 ] 5 0.000% 100.025% ** Level 1 read latency histogram (micros): Count: 1671788 Average: 4.2534 StdDev: 69.37 Min: 0 Median: 1.6134 Max: 11838 Percentiles: P50: 1.61 P75: 2.20 P99: 8.47 P99.9: 121.26 P99.99: 373.76 ------------------------------------------------------ [ 0, 1 ] 246715 14.758% 14.758% ### ( 1, 2 ] 960587 57.459% 72.216% ########### ( 2, 3 ] 237483 14.205% 86.422% ### ( 3, 4 ] 100692 6.023% 92.445% # ( 4, 6 ] 93920 5.618% 98.062% # ( 6, 10 ] 25334 1.515% 99.578% ( 10, 15 ] 3474 0.208% 99.786% ( 15, 22 ] 464 0.028% 99.813% ( 22, 34 ] 44 0.003% 99.816% ( 34, 51 ] 18 0.001% 99.817% ( 51, 76 ] 179 0.011% 99.828% ( 76, 110 ] 1006 0.060% 99.888% ( 110, 170 ] 1067 0.064% 99.952% ( 170, 250 ] 297 0.018% 99.970% ( 250, 380 ] 358 0.021% 99.991% ( 380, 580 ] 433 0.026% 100.017% ( 580, 870 ] 409 0.024% 100.041% ( 870, 1300 ] 275 0.016% 100.058% ( 1300, 1900 ] 157 0.009% 100.067% ( 1900, 2900 ] 182 0.011% 100.078% ( 2900, 4400 ] 207 0.012% 100.091% ( 4400, 6600 ] 56 0.003% 100.094% ( 6600, 9900 ] 23 0.001% 100.095% ( 9900, 14000 ] 5 0.000% 100.096% ** Level 2 read latency histogram (micros): Count: 31731 Average: 1.6777 StdDev: 7.76 Min: 1 Median: 1.1225 Max: 1332 Percentiles: P50: 1.12 P75: 1.59 P99: 3.23 P99.9: 9.06 P99.99: 31.92 ------------------------------------------------------ [ 0, 1 ] 13788 43.453% 43.453% ######### ( 1, 2 ] 16958 53.443% 96.896% ########### ( 2, 3 ] 619 1.951% 98.847% ( 3, 4 ] 211 0.665% 99.512% ( 4, 6 ] 82 0.258% 99.770% ( 6, 10 ] 54 0.170% 99.940% ( 10, 15 ] 12 0.038% 99.978% ( 15, 22 ] 3 0.009% 99.987% ( 22, 34 ] 1 0.003% 99.991% ( 51, 76 ] 1 0.003% 99.994% ( 250, 380 ] 1 0.003% 99.997% ( 1300, 1900 ] 1 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 616695 Average: 9.2272 StdDev: 114.96 Min: 0 Median: 1.9375 Max: 10645 Percentiles: P50: 1.94 P75: 2.96 P99: 9.74 P99.9: 775.86 P99.99: 1162.45 ------------------------------------------------------ [ 0, 1 ] 11662 1.891% 1.891% ( 1, 2 ] 316465 51.316% 53.207% ########## ( 2, 3 ] 140658 22.808% 76.016% ##### ( 3, 4 ] 68014 11.029% 87.044% ## ( 4, 6 ] 64410 10.444% 97.489% ## ( 6, 10 ] 9975 1.617% 99.106% ( 10, 15 ] 1828 0.296% 99.403% ( 15, 22 ] 232 0.038% 99.440% ( 22, 34 ] 47 0.008% 99.448% ( 34, 51 ] 9 0.001% 99.449% ( 51, 76 ] 17 0.003% 99.452% ( 76, 110 ] 134 0.022% 99.474% ( 110, 170 ] 365 0.059% 99.533% ( 170, 250 ] 433 0.070% 99.603% ( 250, 380 ] 612 0.099% 99.703% ( 380, 580 ] 729 0.118% 99.821% ( 580, 870 ] 723 0.117% 99.938% ( 870, 1300 ] 471 0.076% 100.014% ( 1300, 1900 ] 275 0.045% 100.059% ( 1900, 2900 ] 246 0.040% 100.099% ( 2900, 4400 ] 255 0.041% 100.140% ( 4400, 6600 ] 50 0.008% 100.148% ( 6600, 9900 ] 4 0.001% 100.149% ( 9900, 14000 ] 1 0.000% 100.149% ** Level 4 read latency histogram (micros): Count: 80162 Average: 12.9287 StdDev: 147.52 Min: 0 Median: 1.9346 Max: 9570 Percentiles: P50: 1.93 P75: 2.94 P99: 136.26 P99.9: 2230.16 P99.99: 4166.13 ------------------------------------------------------ [ 0, 1 ] 779 0.972% 0.972% ( 1, 2 ] 42051 52.458% 53.429% ########## ( 2, 3 ] 18310 22.841% 76.271% ##### ( 3, 4 ] 8231 10.268% 86.539% ## ( 4, 6 ] 7890 9.843% 96.381% ## ( 6, 10 ] 1739 2.169% 98.550% ( 10, 15 ] 265 0.331% 98.881% ( 15, 22 ] 38 0.047% 98.928% ( 22, 34 ] 10 0.012% 98.941% ( 34, 51 ] 7 0.009% 98.950% ( 51, 76 ] 2 0.002% 98.952% ( 76, 110 ] 20 0.025% 98.977% ( 110, 170 ] 42 0.052% 99.029% ( 170, 250 ] 112 0.140% 99.169% ( 250, 380 ] 118 0.147% 99.316% ( 380, 580 ] 140 0.175% 99.491% ( 580, 870 ] 165 0.206% 99.697% ( 870, 1300 ] 102 0.127% 99.824% ( 1300, 1900 ] 44 0.055% 99.879% ( 1900, 2900 ] 51 0.064% 99.943% ( 2900, 4400 ] 45 0.056% 99.999% ( 4400, 6600 ] 16 0.020% 100.019% ( 6600, 9900 ] 1 0.001% 100.020% ** Level 5 read latency histogram (micros): Count: 220 Average: 1125.5500 StdDev: 1354.94 Min: 78 Median: 510.4348 Max: 7378 Percentiles: P50: 510.43 P75: 1850.00 P99: 6160.00 P99.9: 7378.00 P99.99: 7378.00 ------------------------------------------------------ ( 76, 110 ] 12 5.455% 5.455% # ( 110, 170 ] 32 14.545% 20.000% ### ( 170, 250 ] 24 10.909% 30.909% ## ( 250, 380 ] 27 12.273% 43.182% ## ( 380, 580 ] 23 10.455% 53.636% ## ( 580, 870 ] 25 11.364% 65.000% ## ( 870, 1300 ] 11 5.000% 70.000% # ( 1300, 1900 ] 12 5.455% 75.455% # ( 1900, 2900 ] 27 12.273% 87.727% ## ( 2900, 4400 ] 20 9.091% 96.818% ## ( 4400, 6600 ] 6 2.727% 99.545% # ( 6600, 9900 ] 1 0.455% 100.000% ** DB Stats ** Uptime(secs): 50.3 total, 7.1 interval Cumulative writes: 0 writes, 9000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 8.65 GB, 176.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:25.666 H:M:S, 51.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 137.91 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.293 H:M:S, 60.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 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.183 micros/op 161722 ops/sec 60.047 seconds 9710999 operations; 156.7 MB/s Microseconds per write: Count: 9710999 Average: 6.1834 StdDev: 437.28 Min: 0 Median: 1.7302 Max: 746612 Percentiles: P50: 1.73 P75: 2.75 P99: 8.74 P99.9: 1187.45 P99.99: 2730.09 ------------------------------------------------------ [ 0, 1 ] 1352504 13.928% 13.928% ### ( 1, 2 ] 4797461 49.402% 63.330% ########## ( 2, 3 ] 1508787 15.537% 78.867% ### ( 3, 4 ] 1349325 13.895% 92.762% ### ( 4, 6 ] 542680 5.588% 98.350% # ( 6, 10 ] 92118 0.949% 99.298% ( 10, 15 ] 26980 0.278% 99.576% ( 15, 22 ] 7413 0.076% 99.653% ( 22, 34 ] 1972 0.020% 99.673% ( 34, 51 ] 213 0.002% 99.675% ( 51, 76 ] 42 0.000% 99.676% ( 76, 110 ] 6216 0.064% 99.740% ( 110, 170 ] 3214 0.033% 99.773% ( 170, 250 ] 310 0.003% 99.776% ( 250, 380 ] 125 0.001% 99.777% ( 380, 580 ] 22 0.000% 99.777% ( 580, 870 ] 23 0.000% 99.778% ( 870, 1300 ] 16096 0.166% 99.943% ( 1300, 1900 ] 22 0.000% 99.944% ( 1900, 2900 ] 5427 0.056% 99.999% ( 2900, 4400 ] 19 0.000% 100.000% ( 4400, 6600 ] 3 0.000% 100.000% ( 6600, 9900 ] 3 0.000% 100.000% ( 9900, 14000 ] 1 0.000% 100.000% ( 22000, 33000 ] 2 0.000% 100.000% ( 33000, 50000 ] 3 0.000% 100.000% ( 50000, 75000 ] 1 0.000% 100.000% ( 110000, 170000 ] 2 0.000% 100.000% ( 170000, 250000 ] 10 0.000% 100.000% ( 250000, 380000 ] 2 0.000% 100.000% ( 380000, 570000 ] 1 0.000% 100.000% ( 570000, 860000 ] 2 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 : 185173 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 : 9710999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 10021750968 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 : 511 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 33536828 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 : 28116858370 rocksdb.compact.write.bytes COUNT : 27938593496 rocksdb.flush.write.bytes COUNT : 9974665661 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 : 232 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 : 9894250496 rocksdb.memtable.garbage.bytes.at.flush COUNT : 3853312 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 : 28208432233 rocksdb.non.last.level.read.count COUNT : 6814861 rocksdb.block.checksum.compute.count COUNT : 6813894 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.374278 P95 : 3.899817 P99 : 7.066235 P100 : 746609.000000 COUNT : 9710999 SUM : 55594762 rocksdb.compaction.times.micros P50 : 986285.714286 P95 : 2700000.000000 P99 : 16236766.000000 P100 : 16236766.000000 COUNT : 84 SUM : 115301407 rocksdb.compaction.times.cpu_micros P50 : 811666.666667 P95 : 1876666.666667 P99 : 15359085.000000 P100 : 15359085.000000 COUNT : 84 SUM : 99007646 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 : 698.795181 P95 : 3350.000000 P99 : 29260.000000 P100 : 138579.000000 COUNT : 134 SUM : 286540 rocksdb.compaction.outfile.sync.micros P50 : 1002.307692 P95 : 44050.000000 P99 : 107200.000000 P100 : 149579.000000 COUNT : 348 SUM : 2678432 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 : 107.136842 P95 : 1497.142857 P99 : 3447.500000 P100 : 4312.000000 COUNT : 254 SUM : 82894 rocksdb.table.open.io.micros P50 : 1461.250000 P95 : 6559.666667 P99 : 9881.850000 P100 : 16565.000000 COUNT : 511 SUM : 1027915 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.580943 P95 : 7.166394 P99 : 9.903324 P100 : 15391.000000 COUNT : 6812441 SUM : 39288079 rocksdb.read.block.get.micros P50 : 382.272727 P95 : 3279.411765 P99 : 4909.666667 P100 : 7498.000000 COUNT : 1022 SUM : 838657 rocksdb.write.raw.block.micros P50 : 0.512415 P95 : 0.973588 P99 : 2.829375 P100 : 15005.000000 COUNT : 9182809 SUM : 18504798 rocksdb.numfiles.in.singlecompaction P50 : 3.119718 P95 : 4.050000 P99 : 24.000000 P100 : 24.000000 COUNT : 139 SUM : 501 rocksdb.db.seek.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.db.write.stall P50 : 0.563158 P95 : 1188.014321 P99 : 2548.440622 P100 : 746415.000000 COUNT : 192653 SUM : 33551499 rocksdb.sst.read.micros P50 : 1.531669 P95 : 4.183845 P99 : 7.501081 P100 : 11838.000000 COUNT : 6815075 SUM : 25374676 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 : 9710999 SUM : 10021750968 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 : 214536.082474 P95 : 394250.000000 P99 : 810700.000000 P100 : 883757.000000 COUNT : 134 SUM : 29807430 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 : 320 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