[2024-07-23 18:56:39.959696] Starting SPDK v24.01.1-pre git sha1 dbef7efac / DPDK 22.11.4 initialization... [2024-07-23 18:56:39.959953] [ DPDK EAL parameters: rocksdb --no-shconf -c 0x1 --huge-unlink --no-telemetry --log-level=lib.eal:6 --log-level=lib.cryptodev:5 --log-level=user1:6 --base-virtaddr=0x200000000000 --match-allocations --file-prefix=spdk_pid1759723 ] Set seed to 1721753799953264 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-07-23 18:56:40.061214] app.c: 798:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-07-23 18:56:40.099857] app.c: 488:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-07-23 18:56:40.099908] app.c: 489:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 1759723' to capture a snapshot of events at runtime. [2024-07-23 18:56:40.099923] app.c: 494:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid1759723 for offline analysis/debug. [2024-07-23 18:56:40.099953] reactor.c: 937:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Tue Jul 23 18:56:44 2024 CPU: 96 * Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz CPUCache: 36608 KB 2024/07/23-18:56:47 ... thread 0: (1000000,1000000) ops and (359439.9,359439.9) ops/second in (2.782106,2.782106) 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.00 MB 18.9 0.0 0.0 0.0 0.8 0.8 0.0 1.0 0.0 356.0 2.30 2.08 12 0.192 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 248.9 248.7 1.01 0.98 1 1.012 255K 186 0.0 0.0 L2 1/0 49.28 MB 0.5 0.1 0.1 0.0 0.1 0.1 0.0 1.8 241.5 241.4 0.46 0.44 1 0.462 113K 39 0.0 0.0 L3 19/1 1007.23 MB 1.0 0.1 0.1 0.0 0.1 0.1 0.0 1.0 207.9 207.9 0.30 0.25 1 0.300 63K 0 0.0 0.0 L4 116/0 9.60 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1040/0 85.57 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1187/9 96.94 GB 0.0 0.4 0.3 0.1 1.2 1.1 0.1 1.5 104.5 305.4 4.08 3.75 15 0.272 432K 225 0.0 0.0 Int 0/0 0.00 KB 0.0 0.4 0.3 0.1 1.2 1.1 0.1 1.5 104.5 305.4 4.08 3.75 15 0.272 432K 225 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 240.0 239.9 1.77 1.67 3 0.592 432K 225 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.0 2.30 2.08 12 0.192 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, 420.63 MB/s write, 0.42 GB read, 143.95 MB/s read, 4.1 seconds Interval compaction: 1.22 GB write, 447.14 MB/s write, 0.42 GB read, 153.02 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: 97769 Average: 1.9309 StdDev: 21.82 Min: 1 Median: 1.2224 Max: 3914 Percentiles: P50: 1.22 P75: 1.65 P99: 3.89 P99.9: 10.47 P99.99: 359.80 ------------------------------------------------------ [ 0, 1 ] 36219 37.045% 37.045% ####### ( 1, 2 ] 56941 58.240% 95.286% ############ ( 2, 3 ] 2791 2.855% 98.141% # ( 3, 4 ] 950 0.972% 99.112% ( 4, 6 ] 509 0.521% 99.633% ( 6, 10 ] 256 0.262% 99.895% ( 10, 15 ] 67 0.069% 99.963% ( 15, 22 ] 8 0.008% 99.971% ( 22, 34 ] 3 0.003% 99.974% ( 51, 76 ] 1 0.001% 99.975% ( 110, 170 ] 6 0.006% 99.982% ( 170, 250 ] 5 0.005% 99.987% ( 250, 380 ] 5 0.005% 99.992% ( 380, 580 ] 1 0.001% 99.993% ( 580, 870 ] 1 0.001% 99.994% ( 870, 1300 ] 2 0.002% 99.996% ( 1300, 1900 ] 1 0.001% 99.997% ( 1900, 2900 ] 1 0.001% 99.998% ( 2900, 4400 ] 3 0.003% 100.001% ** Level 1 read latency histogram (micros): Count: 14252 Average: 1.8787 StdDev: 10.72 Min: 1 Median: 1.2363 Max: 1060 Percentiles: P50: 1.24 P75: 1.66 P99: 3.76 P99.9: 8.58 P99.99: 494.96 ------------------------------------------------------ [ 0, 1 ] 5119 35.918% 35.918% ####### ( 1, 2 ] 8494 59.599% 95.516% ############ ( 2, 3 ] 384 2.694% 98.211% # ( 3, 4 ] 148 1.038% 99.249% ( 4, 6 ] 76 0.533% 99.782% ( 6, 10 ] 26 0.182% 99.965% ( 34, 51 ] 1 0.007% 99.972% ( 250, 380 ] 2 0.014% 99.986% ( 380, 580 ] 1 0.007% 99.993% ( 870, 1300 ] 1 0.007% 100.000% ** Level 2 read latency histogram (micros): Count: 28196 Average: 2.2908 StdDev: 18.94 Min: 1 Median: 1.2827 Max: 2150 Percentiles: P50: 1.28 P75: 1.72 P99: 7.13 P99.9: 71.30 P99.99: 947.57 ------------------------------------------------------ [ 0, 1 ] 9493 33.668% 33.668% ####### ( 1, 2 ] 16289 57.771% 91.439% ############ ( 2, 3 ] 1651 5.855% 97.294% # ( 3, 4 ] 279 0.990% 98.283% ( 4, 6 ] 147 0.521% 98.805% ( 6, 10 ] 195 0.692% 99.496% ( 10, 15 ] 59 0.209% 99.706% ( 15, 22 ] 9 0.032% 99.738% ( 34, 51 ] 32 0.113% 99.851% ( 51, 76 ] 17 0.060% 99.911% ( 76, 110 ] 3 0.011% 99.922% ( 110, 170 ] 4 0.014% 99.936% ( 170, 250 ] 7 0.025% 99.961% ( 250, 380 ] 4 0.014% 99.975% ( 580, 870 ] 4 0.014% 99.989% ( 870, 1300 ] 1 0.004% 99.993% ( 1300, 1900 ] 1 0.004% 99.996% ( 1900, 2900 ] 1 0.004% 100.000% ** Level 3 read latency histogram (micros): Count: 1647 Average: 53.1864 StdDev: 358.59 Min: 1 Median: 3.5279 Max: 4784 Percentiles: P50: 3.53 P75: 4.48 P99: 1843.60 P99.9: 4302.95 P99.99: 4784.00 ------------------------------------------------------ [ 0, 1 ] 2 0.121% 0.121% ( 1, 2 ] 35 2.125% 2.247% ( 2, 3 ] 398 24.165% 26.412% ##### ( 3, 4 ] 736 44.687% 71.099% ######### ( 4, 6 ] 269 16.333% 87.432% ### ( 6, 10 ] 115 6.982% 94.414% # ( 10, 15 ] 25 1.518% 95.932% ( 15, 22 ] 9 0.546% 96.478% ( 34, 51 ] 1 0.061% 96.539% ( 51, 76 ] 3 0.182% 96.721% ( 170, 250 ] 5 0.304% 97.025% ( 250, 380 ] 10 0.607% 97.632% ( 380, 580 ] 2 0.121% 97.753% ( 580, 870 ] 10 0.607% 98.361% ( 870, 1300 ] 6 0.364% 98.725% ( 1300, 1900 ] 5 0.304% 99.029% ( 1900, 2900 ] 5 0.304% 99.332% ( 2900, 4400 ] 10 0.607% 99.939% ( 4400, 6600 ] 1 0.061% 100.000% ** Level 4 read latency histogram (micros): Count: 20 Average: 1579.0000 StdDev: 1458.53 Min: 282 Median: 754.0000 Max: 4491 Percentiles: P50: 754.00 P75: 2900.00 P99: 4491.00 P99.9: 4491.00 P99.99: 4491.00 ------------------------------------------------------ ( 250, 380 ] 4 20.000% 20.000% #### ( 380, 580 ] 3 15.000% 35.000% ### ( 580, 870 ] 5 25.000% 60.000% ##### ( 1300, 1900 ] 1 5.000% 65.000% # ( 1900, 2900 ] 2 10.000% 75.000% ## ( 2900, 4400 ] 4 20.000% 95.000% #### ( 4400, 6600 ] 1 5.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, 332.56 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:0.171 H:M:S, 5.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 353.43 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.171 H:M:S, 6.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/07/23-18:56:50 ... thread 0: (1000000,2000000) ops and (327110.8,342514.2) ops/second in (3.057068,5.839174) 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/8 1.17 GB 0.0 0.7 0.0 0.7 2.5 1.8 0.0 1.4 95.4 325.8 7.93 7.35 29 0.273 767K 693 0.0 0.0 L1 2/2 50.41 MB 0.0 0.8 0.5 0.3 0.8 0.5 0.1 1.6 240.9 240.4 3.40 3.31 2 1.699 831K 1406 0.0 0.0 L2 1/0 49.28 MB 0.5 0.1 0.1 0.0 0.1 0.1 0.5 1.8 241.5 241.4 0.46 0.44 1 0.462 113K 39 0.0 0.0 L3 15/0 773.35 MB 0.8 0.2 0.2 0.0 0.2 0.2 0.4 1.0 222.1 222.1 0.87 0.79 2 0.435 196K 4 0.0 0.0 L4 174/0 9.65 GB 1.0 0.1 0.1 0.0 0.1 0.1 0.7 1.0 66.3 66.3 0.85 0.52 1 0.845 56K 0 0.0 0.0 L5 1048/0 86.25 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1248/10 97.92 GB 0.0 1.9 0.8 1.1 3.7 2.6 2.4 2.1 143.4 278.5 13.50 12.41 35 0.386 1965K 2142 0.0 0.0 Int 0/0 0.00 KB 0.0 1.9 0.8 1.1 3.7 2.6 2.4 2.1 143.4 278.5 13.50 12.41 35 0.386 1965K 2142 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.9 0.8 1.1 1.9 0.8 0.0 0.0 230.4 230.1 8.40 7.83 9 0.933 1965K 2142 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 358.1 5.10 4.58 26 0.196 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.67 GB write, 625.01 MB/s write, 1.89 GB read, 321.73 MB/s read, 13.5 seconds Interval compaction: 3.67 GB write, 643.79 MB/s write, 1.89 GB read, 331.39 MB/s read, 13.5 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 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: 360339 Average: 2.0743 StdDev: 14.77 Min: 1 Median: 1.3926 Max: 3914 Percentiles: P50: 1.39 P75: 1.78 P99: 5.49 P99.9: 11.61 P99.99: 50.81 ------------------------------------------------------ [ 0, 1 ] 89438 24.821% 24.821% ##### ( 1, 2 ] 231120 64.140% 88.960% ############# ( 2, 3 ] 22938 6.366% 95.326% # ( 3, 4 ] 8929 2.478% 97.804% ( 4, 6 ] 5779 1.604% 99.408% ( 6, 10 ] 1640 0.455% 99.863% ( 10, 15 ] 422 0.117% 99.980% ( 15, 22 ] 30 0.008% 99.988% ( 22, 34 ] 5 0.001% 99.989% ( 34, 51 ] 3 0.001% 99.990% ( 51, 76 ] 6 0.002% 99.992% ( 110, 170 ] 12 0.003% 99.995% ( 170, 250 ] 14 0.004% 99.999% ( 250, 380 ] 9 0.002% 100.002% ( 380, 580 ] 3 0.001% 100.002% ( 580, 870 ] 8 0.002% 100.005% ( 870, 1300 ] 4 0.001% 100.006% ( 1300, 1900 ] 3 0.001% 100.007% ( 1900, 2900 ] 1 0.000% 100.007% ( 2900, 4400 ] 5 0.001% 100.008% ** Level 1 read latency histogram (micros): Count: 96654 Average: 2.1708 StdDev: 9.10 Min: 0 Median: 1.4713 Max: 1671 Percentiles: P50: 1.47 P75: 1.85 P99: 5.68 P99.9: 11.16 P99.99: 322.25 ------------------------------------------------------ [ 0, 1 ] 17893 18.512% 18.512% #### ( 1, 2 ] 64576 66.812% 85.324% ############# ( 2, 3 ] 8162 8.445% 93.768% ## ( 3, 4 ] 3250 3.363% 97.131% # ( 4, 6 ] 2152 2.226% 99.358% ( 6, 10 ] 502 0.519% 99.877% ( 10, 15 ] 96 0.099% 99.976% ( 15, 22 ] 5 0.005% 99.981% ( 22, 34 ] 1 0.001% 99.982% ( 34, 51 ] 3 0.003% 99.986% ( 110, 170 ] 1 0.001% 99.987% ( 250, 380 ] 6 0.006% 99.993% ( 380, 580 ] 2 0.002% 99.995% ( 580, 870 ] 1 0.001% 99.996% ( 870, 1300 ] 3 0.003% 99.999% ( 1300, 1900 ] 1 0.001% 100.000% ** Level 2 read latency histogram (micros): Count: 28196 Average: 2.2908 StdDev: 18.94 Min: 1 Median: 1.2827 Max: 2150 Percentiles: P50: 1.28 P75: 1.72 P99: 7.13 P99.9: 71.30 P99.99: 947.57 ------------------------------------------------------ [ 0, 1 ] 9493 33.668% 33.668% ####### ( 1, 2 ] 16289 57.771% 91.439% ############ ( 2, 3 ] 1651 5.855% 97.294% # ( 3, 4 ] 279 0.990% 98.283% ( 4, 6 ] 147 0.521% 98.805% ( 6, 10 ] 195 0.692% 99.496% ( 10, 15 ] 59 0.209% 99.706% ( 15, 22 ] 9 0.032% 99.738% ( 34, 51 ] 32 0.113% 99.851% ( 51, 76 ] 17 0.060% 99.911% ( 76, 110 ] 3 0.011% 99.922% ( 110, 170 ] 4 0.014% 99.936% ( 170, 250 ] 7 0.025% 99.961% ( 250, 380 ] 4 0.014% 99.975% ( 580, 870 ] 4 0.014% 99.989% ( 870, 1300 ] 1 0.004% 99.993% ( 1300, 1900 ] 1 0.004% 99.996% ( 1900, 2900 ] 1 0.004% 100.000% ** Level 3 read latency histogram (micros): Count: 14852 Average: 8.9993 StdDev: 120.52 Min: 0 Median: 2.6672 Max: 4784 Percentiles: P50: 2.67 P75: 3.59 P99: 11.11 P99.9: 2129.60 P99.99: 4327.22 ------------------------------------------------------ [ 0, 1 ] 141 0.949% 0.949% ( 1, 2 ] 3259 21.943% 22.893% #### ( 2, 3 ] 6034 40.628% 63.520% ######## ( 3, 4 ] 2912 19.607% 83.127% #### ( 4, 6 ] 1699 11.440% 94.566% ## ( 6, 10 ] 640 4.309% 98.876% # ( 10, 15 ] 83 0.559% 99.434% ( 15, 22 ] 20 0.135% 99.569% ( 22, 34 ] 1 0.007% 99.576% ( 34, 51 ] 2 0.013% 99.589% ( 51, 76 ] 3 0.020% 99.609% ( 110, 170 ] 1 0.007% 99.616% ( 170, 250 ] 6 0.040% 99.657% ( 250, 380 ] 11 0.074% 99.731% ( 380, 580 ] 3 0.020% 99.751% ( 580, 870 ] 10 0.067% 99.818% ( 870, 1300 ] 6 0.040% 99.859% ( 1300, 1900 ] 5 0.034% 99.892% ( 1900, 2900 ] 5 0.034% 99.926% ( 2900, 4400 ] 10 0.067% 99.993% ( 4400, 6600 ] 1 0.007% 100.000% ** Level 4 read latency histogram (micros): Count: 310 Average: 104.9000 StdDev: 535.82 Min: 1 Median: 2.6132 Max: 4491 Percentiles: P50: 2.61 P75: 3.65 P99: 3612.50 P99.9: 4491.00 P99.99: 4491.00 ------------------------------------------------------ [ 0, 1 ] 5 1.613% 1.613% ( 1, 2 ] 85 27.419% 29.032% ##### ( 2, 3 ] 106 34.194% 63.226% ####### ( 3, 4 ] 56 18.065% 81.290% #### ( 4, 6 ] 33 10.645% 91.935% ## ( 6, 10 ] 3 0.968% 92.903% ( 10, 15 ] 2 0.645% 93.548% ( 250, 380 ] 4 1.290% 94.839% ( 380, 580 ] 3 0.968% 95.806% ( 580, 870 ] 5 1.613% 97.419% ( 1300, 1900 ] 1 0.323% 97.742% ( 1900, 2900 ] 2 0.645% 98.387% ( 2900, 4400 ] 4 1.290% 99.677% ( 4400, 6600 ] 1 0.323% 100.000% ** Level 5 read latency histogram (micros): Count: 40 Average: 922.9250 StdDev: 1164.58 Min: 75 Median: 315.0000 Max: 5134 Percentiles: P50: 315.00 P75: 1450.00 P99: 5134.00 P99.9: 5134.00 P99.99: 5134.00 ------------------------------------------------------ ( 51, 76 ] 1 2.500% 2.500% # ( 76, 110 ] 3 7.500% 10.000% ## ( 110, 170 ] 10 25.000% 35.000% ##### ( 170, 250 ] 5 12.500% 47.500% ### ( 250, 380 ] 2 5.000% 52.500% # ( 380, 580 ] 4 10.000% 62.500% ## ( 580, 870 ] 1 2.500% 65.000% # ( 870, 1300 ] 3 7.500% 72.500% ## ( 1300, 1900 ] 4 10.000% 82.500% ## ( 1900, 2900 ] 3 7.500% 90.000% ## ( 2900, 4400 ] 3 7.500% 97.500% ## ( 4400, 6600 ] 1 2.500% 100.000% # ** DB Stats ** Uptime(secs): 6.0 total, 3.1 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 327.16 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:0.575 H:M:S, 9.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 321.94 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.404 H:M:S, 13.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/07/23-18:56:52 ... thread 0: (1000000,3000000) ops and (352960.0,345926.8) ops/second in (2.833182,8.672356) 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/12 2.09 GB 69.2 1.3 0.0 1.3 4.0 2.7 0.0 1.5 104.8 324.2 12.63 11.75 45 0.281 1343K 1337 0.0 0.0 L1 2/2 50.41 MB 0.0 0.8 0.5 0.3 0.8 0.5 0.1 1.6 240.9 240.4 3.40 3.31 2 1.699 831K 1406 0.0 0.0 L2 1/0 49.28 MB 0.5 0.1 0.1 0.0 0.1 0.1 0.5 1.8 241.5 241.4 0.46 0.44 1 0.462 113K 39 0.0 0.0 L3 15/0 773.35 MB 0.8 0.2 0.2 0.0 0.2 0.2 0.4 1.0 222.1 222.1 0.87 0.79 2 0.435 196K 4 0.0 0.0 L4 174/0 9.65 GB 1.0 0.1 0.1 0.0 0.1 0.1 0.7 1.0 66.3 66.3 0.85 0.52 1 0.845 56K 0 0.0 0.0 L5 1048/0 86.25 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1256/14 98.84 GB 0.0 2.4 0.8 1.6 5.1 3.5 2.4 1.9 137.5 289.6 18.20 16.81 51 0.357 2541K 2786 0.0 0.0 Int 0/0 0.00 KB 0.0 2.4 0.8 1.6 5.1 3.5 2.4 1.9 137.5 289.6 18.20 16.81 51 0.357 2541K 2786 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.4 0.8 1.6 2.4 0.8 0.0 0.0 238.4 238.1 10.50 9.89 11 0.954 2541K 2786 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 359.8 7.70 6.92 40 0.193 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 8.8 total, 8.7 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.15 GB write, 595.69 MB/s write, 2.44 GB read, 282.79 MB/s read, 18.2 seconds Interval compaction: 5.15 GB write, 607.74 MB/s write, 2.44 GB read, 288.51 MB/s read, 18.2 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 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: 711501 Average: 2.1168 StdDev: 13.10 Min: 1 Median: 1.4427 Max: 3914 Percentiles: P50: 1.44 P75: 1.82 P99: 5.44 P99.9: 9.97 P99.99: 14.76 ------------------------------------------------------ [ 0, 1 ] 147388 20.715% 20.715% #### ( 1, 2 ] 470714 66.158% 86.873% ############# ( 2, 3 ] 55168 7.754% 94.627% ## ( 3, 4 ] 21750 3.057% 97.684% # ( 4, 6 ] 12974 1.823% 99.507% ( 6, 10 ] 2817 0.396% 99.903% ( 10, 15 ] 651 0.091% 99.995% ( 15, 22 ] 46 0.006% 100.001% ( 22, 34 ] 9 0.001% 100.002% ( 34, 51 ] 6 0.001% 100.003% ( 51, 76 ] 13 0.002% 100.005% ( 76, 110 ] 2 0.000% 100.005% ( 110, 170 ] 20 0.003% 100.008% ( 170, 250 ] 19 0.003% 100.011% ( 250, 380 ] 16 0.002% 100.013% ( 380, 580 ] 4 0.001% 100.013% ( 580, 870 ] 11 0.002% 100.015% ( 870, 1300 ] 6 0.001% 100.016% ( 1300, 1900 ] 4 0.001% 100.016% ( 1900, 2900 ] 5 0.001% 100.017% ( 2900, 4400 ] 6 0.001% 100.018% ** Level 1 read latency histogram (micros): Count: 96654 Average: 2.1708 StdDev: 9.10 Min: 0 Median: 1.4713 Max: 1671 Percentiles: P50: 1.47 P75: 1.85 P99: 5.68 P99.9: 11.16 P99.99: 322.25 ------------------------------------------------------ [ 0, 1 ] 17893 18.512% 18.512% #### ( 1, 2 ] 64576 66.812% 85.324% ############# ( 2, 3 ] 8162 8.445% 93.768% ## ( 3, 4 ] 3250 3.363% 97.131% # ( 4, 6 ] 2152 2.226% 99.358% ( 6, 10 ] 502 0.519% 99.877% ( 10, 15 ] 96 0.099% 99.976% ( 15, 22 ] 5 0.005% 99.981% ( 22, 34 ] 1 0.001% 99.982% ( 34, 51 ] 3 0.003% 99.986% ( 110, 170 ] 1 0.001% 99.987% ( 250, 380 ] 6 0.006% 99.993% ( 380, 580 ] 2 0.002% 99.995% ( 580, 870 ] 1 0.001% 99.996% ( 870, 1300 ] 3 0.003% 99.999% ( 1300, 1900 ] 1 0.001% 100.000% ** Level 2 read latency histogram (micros): Count: 28196 Average: 2.2908 StdDev: 18.94 Min: 1 Median: 1.2827 Max: 2150 Percentiles: P50: 1.28 P75: 1.72 P99: 7.13 P99.9: 71.30 P99.99: 947.57 ------------------------------------------------------ [ 0, 1 ] 9493 33.668% 33.668% ####### ( 1, 2 ] 16289 57.771% 91.439% ############ ( 2, 3 ] 1651 5.855% 97.294% # ( 3, 4 ] 279 0.990% 98.283% ( 4, 6 ] 147 0.521% 98.805% ( 6, 10 ] 195 0.692% 99.496% ( 10, 15 ] 59 0.209% 99.706% ( 15, 22 ] 9 0.032% 99.738% ( 34, 51 ] 32 0.113% 99.851% ( 51, 76 ] 17 0.060% 99.911% ( 76, 110 ] 3 0.011% 99.922% ( 110, 170 ] 4 0.014% 99.936% ( 170, 250 ] 7 0.025% 99.961% ( 250, 380 ] 4 0.014% 99.975% ( 580, 870 ] 4 0.014% 99.989% ( 870, 1300 ] 1 0.004% 99.993% ( 1300, 1900 ] 1 0.004% 99.996% ( 1900, 2900 ] 1 0.004% 100.000% ** Level 3 read latency histogram (micros): Count: 14852 Average: 8.9993 StdDev: 120.52 Min: 0 Median: 2.6672 Max: 4784 Percentiles: P50: 2.67 P75: 3.59 P99: 11.11 P99.9: 2129.60 P99.99: 4327.22 ------------------------------------------------------ [ 0, 1 ] 141 0.949% 0.949% ( 1, 2 ] 3259 21.943% 22.893% #### ( 2, 3 ] 6034 40.628% 63.520% ######## ( 3, 4 ] 2912 19.607% 83.127% #### ( 4, 6 ] 1699 11.440% 94.566% ## ( 6, 10 ] 640 4.309% 98.876% # ( 10, 15 ] 83 0.559% 99.434% ( 15, 22 ] 20 0.135% 99.569% ( 22, 34 ] 1 0.007% 99.576% ( 34, 51 ] 2 0.013% 99.589% ( 51, 76 ] 3 0.020% 99.609% ( 110, 170 ] 1 0.007% 99.616% ( 170, 250 ] 6 0.040% 99.657% ( 250, 380 ] 11 0.074% 99.731% ( 380, 580 ] 3 0.020% 99.751% ( 580, 870 ] 10 0.067% 99.818% ( 870, 1300 ] 6 0.040% 99.859% ( 1300, 1900 ] 5 0.034% 99.892% ( 1900, 2900 ] 5 0.034% 99.926% ( 2900, 4400 ] 10 0.067% 99.993% ( 4400, 6600 ] 1 0.007% 100.000% ** Level 4 read latency histogram (micros): Count: 310 Average: 104.9000 StdDev: 535.82 Min: 1 Median: 2.6132 Max: 4491 Percentiles: P50: 2.61 P75: 3.65 P99: 3612.50 P99.9: 4491.00 P99.99: 4491.00 ------------------------------------------------------ [ 0, 1 ] 5 1.613% 1.613% ( 1, 2 ] 85 27.419% 29.032% ##### ( 2, 3 ] 106 34.194% 63.226% ####### ( 3, 4 ] 56 18.065% 81.290% #### ( 4, 6 ] 33 10.645% 91.935% ## ( 6, 10 ] 3 0.968% 92.903% ( 10, 15 ] 2 0.645% 93.548% ( 250, 380 ] 4 1.290% 94.839% ( 380, 580 ] 3 0.968% 95.806% ( 580, 870 ] 5 1.613% 97.419% ( 1300, 1900 ] 1 0.323% 97.742% ( 1900, 2900 ] 2 0.645% 98.387% ( 2900, 4400 ] 4 1.290% 99.677% ( 4400, 6600 ] 1 0.323% 100.000% ** Level 5 read latency histogram (micros): Count: 40 Average: 922.9250 StdDev: 1164.58 Min: 75 Median: 315.0000 Max: 5134 Percentiles: P50: 315.00 P75: 1450.00 P99: 5134.00 P99.9: 5134.00 P99.99: 5134.00 ------------------------------------------------------ ( 51, 76 ] 1 2.500% 2.500% # ( 76, 110 ] 3 7.500% 10.000% ## ( 110, 170 ] 10 25.000% 35.000% ##### ( 170, 250 ] 5 12.500% 47.500% ### ( 250, 380 ] 2 5.000% 52.500% # ( 380, 580 ] 4 10.000% 62.500% ## ( 580, 870 ] 1 2.500% 65.000% # ( 870, 1300 ] 3 7.500% 72.500% ## ( 1300, 1900 ] 4 10.000% 82.500% ## ( 1900, 2900 ] 3 7.500% 90.000% ## ( 2900, 4400 ] 3 7.500% 97.500% ## ( 4400, 6600 ] 1 2.500% 100.000% # ** DB Stats ** Uptime(secs): 8.8 total, 2.8 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 333.64 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.772 H:M:S, 8.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 347.38 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.196 H:M:S, 6.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/07/23-18:56:56 ... thread 0: (1000000,4000000) ops and (314662.0,337542.2) ops/second in (3.178013,11.850369) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 11/4 1.91 GB 169.9 2.3 0.0 2.3 6.0 3.7 0.0 1.6 123.0 317.0 19.47 18.20 64 0.304 2430K 2413 0.0 0.0 L1 11/0 1.21 GB 124.0 2.0 1.7 0.4 2.0 1.7 0.1 1.2 237.6 236.6 8.69 8.47 3 2.898 2097K 8115 0.0 0.0 L2 1/0 49.28 MB 0.5 0.1 0.1 0.0 0.1 0.1 0.5 1.8 241.5 241.4 0.46 0.44 1 0.462 113K 39 0.0 0.0 L3 15/0 773.35 MB 0.8 0.2 0.2 0.0 0.2 0.2 0.4 1.0 222.1 222.1 0.87 0.79 2 0.435 196K 4 0.0 0.0 L4 174/0 9.65 GB 1.0 0.1 0.1 0.0 0.1 0.1 0.7 1.0 66.3 66.3 0.85 0.52 1 0.845 56K 0 0.0 0.0 L5 1048/0 86.25 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1260/4 99.82 GB 0.0 4.7 2.0 2.7 8.4 5.6 2.4 2.3 158.9 283.1 30.34 28.42 71 0.427 4894K 10K 0.0 0.0 Int 0/0 0.00 KB 0.0 4.7 2.0 2.7 8.4 5.6 2.4 2.3 158.9 283.1 30.34 28.42 71 0.427 4894K 10K 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.7 2.0 2.7 4.7 2.0 0.0 0.0 243.4 242.8 19.81 18.99 16 1.238 4894K 10K 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 358.9 10.53 9.43 55 0.192 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.9 interval Flush(GB): cumulative 3.691, interval 3.691 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 8.39 GB write, 714.13 MB/s write, 4.71 GB read, 400.76 MB/s read, 30.3 seconds Interval compaction: 8.39 GB write, 724.70 MB/s write, 4.71 GB read, 406.70 MB/s read, 30.3 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 3, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 3, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 13, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 3, total-stops: 13, interval: 16 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1094673 Average: 2.1334 StdDev: 12.19 Min: 1 Median: 1.4574 Max: 4527 Percentiles: P50: 1.46 P75: 1.83 P99: 5.50 P99.9: 9.95 P99.99: 14.44 ------------------------------------------------------ [ 0, 1 ] 213892 19.539% 19.539% #### ( 1, 2 ] 728937 66.589% 86.129% ############# ( 2, 3 ] 89756 8.199% 94.328% ## ( 3, 4 ] 35417 3.235% 97.564% # ( 4, 6 ] 20909 1.910% 99.474% ( 6, 10 ] 4729 0.432% 99.906% ( 10, 15 ] 1040 0.095% 100.001% ( 15, 22 ] 74 0.007% 100.007% ( 22, 34 ] 16 0.001% 100.009% ( 34, 51 ] 7 0.001% 100.010% ( 51, 76 ] 18 0.002% 100.011% ( 76, 110 ] 6 0.001% 100.012% ( 110, 170 ] 31 0.003% 100.015% ( 170, 250 ] 29 0.003% 100.017% ( 250, 380 ] 27 0.002% 100.020% ( 380, 580 ] 5 0.000% 100.020% ( 580, 870 ] 18 0.002% 100.022% ( 870, 1300 ] 9 0.001% 100.023% ( 1300, 1900 ] 7 0.001% 100.023% ( 1900, 2900 ] 6 0.001% 100.024% ( 2900, 4400 ] 6 0.001% 100.024% ( 4400, 6600 ] 1 0.000% 100.024% ** Level 1 read latency histogram (micros): Count: 109508 Average: 2.2894 StdDev: 13.97 Min: 0 Median: 1.4758 Max: 1671 Percentiles: P50: 1.48 P75: 1.85 P99: 5.65 P99.9: 11.69 P99.99: 801.07 ------------------------------------------------------ [ 0, 1 ] 19699 17.989% 17.989% #### ( 1, 2 ] 73679 67.282% 85.270% ############# ( 2, 3 ] 9332 8.522% 93.792% ## ( 3, 4 ] 3721 3.398% 97.190% # ( 4, 6 ] 2398 2.190% 99.380% ( 6, 10 ] 536 0.489% 99.869% ( 10, 15 ] 99 0.090% 99.960% ( 15, 22 ] 5 0.005% 99.964% ( 22, 34 ] 2 0.002% 99.966% ( 34, 51 ] 3 0.003% 99.969% ( 110, 170 ] 1 0.001% 99.970% ( 170, 250 ] 1 0.001% 99.971% ( 250, 380 ] 12 0.011% 99.982% ( 380, 580 ] 6 0.005% 99.987% ( 580, 870 ] 4 0.004% 99.991% ( 870, 1300 ] 6 0.005% 99.996% ( 1300, 1900 ] 4 0.004% 100.000% ** Level 2 read latency histogram (micros): Count: 28196 Average: 2.2908 StdDev: 18.94 Min: 1 Median: 1.2827 Max: 2150 Percentiles: P50: 1.28 P75: 1.72 P99: 7.13 P99.9: 71.30 P99.99: 947.57 ------------------------------------------------------ [ 0, 1 ] 9493 33.668% 33.668% ####### ( 1, 2 ] 16289 57.771% 91.439% ############ ( 2, 3 ] 1651 5.855% 97.294% # ( 3, 4 ] 279 0.990% 98.283% ( 4, 6 ] 147 0.521% 98.805% ( 6, 10 ] 195 0.692% 99.496% ( 10, 15 ] 59 0.209% 99.706% ( 15, 22 ] 9 0.032% 99.738% ( 34, 51 ] 32 0.113% 99.851% ( 51, 76 ] 17 0.060% 99.911% ( 76, 110 ] 3 0.011% 99.922% ( 110, 170 ] 4 0.014% 99.936% ( 170, 250 ] 7 0.025% 99.961% ( 250, 380 ] 4 0.014% 99.975% ( 580, 870 ] 4 0.014% 99.989% ( 870, 1300 ] 1 0.004% 99.993% ( 1300, 1900 ] 1 0.004% 99.996% ( 1900, 2900 ] 1 0.004% 100.000% ** Level 3 read latency histogram (micros): Count: 14852 Average: 8.9993 StdDev: 120.52 Min: 0 Median: 2.6672 Max: 4784 Percentiles: P50: 2.67 P75: 3.59 P99: 11.11 P99.9: 2129.60 P99.99: 4327.22 ------------------------------------------------------ [ 0, 1 ] 141 0.949% 0.949% ( 1, 2 ] 3259 21.943% 22.893% #### ( 2, 3 ] 6034 40.628% 63.520% ######## ( 3, 4 ] 2912 19.607% 83.127% #### ( 4, 6 ] 1699 11.440% 94.566% ## ( 6, 10 ] 640 4.309% 98.876% # ( 10, 15 ] 83 0.559% 99.434% ( 15, 22 ] 20 0.135% 99.569% ( 22, 34 ] 1 0.007% 99.576% ( 34, 51 ] 2 0.013% 99.589% ( 51, 76 ] 3 0.020% 99.609% ( 110, 170 ] 1 0.007% 99.616% ( 170, 250 ] 6 0.040% 99.657% ( 250, 380 ] 11 0.074% 99.731% ( 380, 580 ] 3 0.020% 99.751% ( 580, 870 ] 10 0.067% 99.818% ( 870, 1300 ] 6 0.040% 99.859% ( 1300, 1900 ] 5 0.034% 99.892% ( 1900, 2900 ] 5 0.034% 99.926% ( 2900, 4400 ] 10 0.067% 99.993% ( 4400, 6600 ] 1 0.007% 100.000% ** Level 4 read latency histogram (micros): Count: 310 Average: 104.9000 StdDev: 535.82 Min: 1 Median: 2.6132 Max: 4491 Percentiles: P50: 2.61 P75: 3.65 P99: 3612.50 P99.9: 4491.00 P99.99: 4491.00 ------------------------------------------------------ [ 0, 1 ] 5 1.613% 1.613% ( 1, 2 ] 85 27.419% 29.032% ##### ( 2, 3 ] 106 34.194% 63.226% ####### ( 3, 4 ] 56 18.065% 81.290% #### ( 4, 6 ] 33 10.645% 91.935% ## ( 6, 10 ] 3 0.968% 92.903% ( 10, 15 ] 2 0.645% 93.548% ( 250, 380 ] 4 1.290% 94.839% ( 380, 580 ] 3 0.968% 95.806% ( 580, 870 ] 5 1.613% 97.419% ( 1300, 1900 ] 1 0.323% 97.742% ( 1900, 2900 ] 2 0.645% 98.387% ( 2900, 4400 ] 4 1.290% 99.677% ( 4400, 6600 ] 1 0.323% 100.000% ** Level 5 read latency histogram (micros): Count: 40 Average: 922.9250 StdDev: 1164.58 Min: 75 Median: 315.0000 Max: 5134 Percentiles: P50: 315.00 P75: 1450.00 P99: 5134.00 P99.9: 5134.00 P99.99: 5134.00 ------------------------------------------------------ ( 51, 76 ] 1 2.500% 2.500% # ( 76, 110 ] 3 7.500% 10.000% ## ( 110, 170 ] 10 25.000% 35.000% ##### ( 170, 250 ] 5 12.500% 47.500% ### ( 250, 380 ] 2 5.000% 52.500% # ( 380, 580 ] 4 10.000% 62.500% ## ( 580, 870 ] 1 2.500% 65.000% # ( 870, 1300 ] 3 7.500% 72.500% ## ( 1300, 1900 ] 4 10.000% 82.500% ## ( 1900, 2900 ] 3 7.500% 90.000% ## ( 2900, 4400 ] 3 7.500% 97.500% ## ( 4400, 6600 ] 1 2.500% 100.000% # ** DB Stats ** Uptime(secs): 12.0 total, 3.2 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 327.31 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.296 H:M:S, 10.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 309.69 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.524 H:M:S, 16.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/07/23-18:56:59 ... thread 0: (1000000,5000000) ops and (330658.3,336142.6) ops/second in (3.024270,14.874639) 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/13 2.95 GB 6.3 3.4 0.0 3.4 8.1 4.7 0.0 1.7 131.5 315.4 26.35 24.72 83 0.318 3518K 3528 0.0 0.0 L1 11/11 1.21 GB 0.0 2.0 1.7 0.4 2.0 1.7 0.1 1.2 237.6 236.6 8.69 8.47 3 2.898 2097K 8115 0.0 0.0 L2 1/0 49.28 MB 0.5 0.1 0.1 0.0 0.1 0.1 0.5 1.8 241.5 241.4 0.46 0.44 1 0.462 113K 39 0.0 0.0 L3 15/0 773.35 MB 0.8 0.2 0.2 0.0 0.2 0.2 0.4 1.0 222.1 222.1 0.87 0.79 2 0.435 196K 4 0.0 0.0 L4 174/0 9.65 GB 1.0 0.1 0.1 0.0 0.1 0.1 0.7 1.0 66.3 66.3 0.85 0.52 1 0.845 56K 0 0.0 0.0 L5 1048/0 86.25 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1263/24 100.86 GB 0.0 5.8 2.0 3.8 10.5 6.7 2.4 2.2 158.3 288.2 37.22 34.94 90 0.414 5981K 11K 0.0 0.0 Int 0/0 0.00 KB 0.0 5.8 2.0 3.8 10.5 6.7 2.4 2.2 158.3 288.2 37.22 34.94 90 0.414 5981K 11K 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.8 2.0 3.8 5.7 2.0 0.0 0.0 247.8 247.3 23.78 22.88 20 1.189 5981K 11K 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 360.7 13.45 12.06 70 0.192 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 15.1 total, 14.9 interval Flush(GB): cumulative 4.737, interval 4.737 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 10.48 GB write, 712.87 MB/s write, 5.75 GB read, 391.39 MB/s read, 37.2 seconds Interval compaction: 10.48 GB write, 721.27 MB/s write, 5.75 GB read, 396.01 MB/s read, 37.2 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 3, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 3, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 17, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 3, total-stops: 17, interval: 20 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1342805 Average: 2.0989 StdDev: 11.92 Min: 0 Median: 1.4347 Max: 4527 Percentiles: P50: 1.43 P75: 1.81 P99: 5.43 P99.9: 10.16 P99.99: 14.78 ------------------------------------------------------ [ 0, 1 ] 286104 21.306% 21.306% #### ( 1, 2 ] 886367 66.009% 87.315% ############# ( 2, 3 ] 100578 7.490% 94.805% # ( 3, 4 ] 39855 2.968% 97.773% # ( 4, 6 ] 22984 1.712% 99.485% ( 6, 10 ] 5531 0.412% 99.897% ( 10, 15 ] 1309 0.097% 99.994% ( 15, 22 ] 111 0.008% 100.003% ( 22, 34 ] 18 0.001% 100.004% ( 34, 51 ] 7 0.001% 100.004% ( 51, 76 ] 18 0.001% 100.006% ( 76, 110 ] 15 0.001% 100.007% ( 110, 170 ] 48 0.004% 100.010% ( 170, 250 ] 40 0.003% 100.013% ( 250, 380 ] 35 0.003% 100.016% ( 380, 580 ] 8 0.001% 100.017% ( 580, 870 ] 22 0.002% 100.018% ( 870, 1300 ] 14 0.001% 100.019% ( 1300, 1900 ] 10 0.001% 100.020% ( 1900, 2900 ] 6 0.000% 100.020% ( 2900, 4400 ] 7 0.001% 100.021% ( 4400, 6600 ] 1 0.000% 100.021% ** Level 1 read latency histogram (micros): Count: 109553 Average: 2.3598 StdDev: 14.53 Min: 0 Median: 1.4761 Max: 1671 Percentiles: P50: 1.48 P75: 1.85 P99: 5.69 P99.9: 13.96 P99.99: 814.59 ------------------------------------------------------ [ 0, 1 ] 19699 17.981% 17.981% #### ( 1, 2 ] 73679 67.254% 85.235% ############# ( 2, 3 ] 9332 8.518% 93.754% ## ( 3, 4 ] 3721 3.397% 97.150% # ( 4, 6 ] 2398 2.189% 99.339% ( 6, 10 ] 536 0.489% 99.828% ( 10, 15 ] 99 0.090% 99.919% ( 15, 22 ] 5 0.005% 99.923% ( 22, 34 ] 2 0.002% 99.925% ( 34, 51 ] 3 0.003% 99.928% ( 76, 110 ] 6 0.005% 99.933% ( 110, 170 ] 30 0.027% 99.961% ( 170, 250 ] 6 0.005% 99.966% ( 250, 380 ] 14 0.013% 99.979% ( 380, 580 ] 8 0.007% 99.986% ( 580, 870 ] 5 0.005% 99.991% ( 870, 1300 ] 6 0.005% 99.996% ( 1300, 1900 ] 4 0.004% 100.000% ** Level 2 read latency histogram (micros): Count: 28196 Average: 2.2908 StdDev: 18.94 Min: 1 Median: 1.2827 Max: 2150 Percentiles: P50: 1.28 P75: 1.72 P99: 7.13 P99.9: 71.30 P99.99: 947.57 ------------------------------------------------------ [ 0, 1 ] 9493 33.668% 33.668% ####### ( 1, 2 ] 16289 57.771% 91.439% ############ ( 2, 3 ] 1651 5.855% 97.294% # ( 3, 4 ] 279 0.990% 98.283% ( 4, 6 ] 147 0.521% 98.805% ( 6, 10 ] 195 0.692% 99.496% ( 10, 15 ] 59 0.209% 99.706% ( 15, 22 ] 9 0.032% 99.738% ( 34, 51 ] 32 0.113% 99.851% ( 51, 76 ] 17 0.060% 99.911% ( 76, 110 ] 3 0.011% 99.922% ( 110, 170 ] 4 0.014% 99.936% ( 170, 250 ] 7 0.025% 99.961% ( 250, 380 ] 4 0.014% 99.975% ( 580, 870 ] 4 0.014% 99.989% ( 870, 1300 ] 1 0.004% 99.993% ( 1300, 1900 ] 1 0.004% 99.996% ( 1900, 2900 ] 1 0.004% 100.000% ** Level 3 read latency histogram (micros): Count: 14852 Average: 8.9993 StdDev: 120.52 Min: 0 Median: 2.6672 Max: 4784 Percentiles: P50: 2.67 P75: 3.59 P99: 11.11 P99.9: 2129.60 P99.99: 4327.22 ------------------------------------------------------ [ 0, 1 ] 141 0.949% 0.949% ( 1, 2 ] 3259 21.943% 22.893% #### ( 2, 3 ] 6034 40.628% 63.520% ######## ( 3, 4 ] 2912 19.607% 83.127% #### ( 4, 6 ] 1699 11.440% 94.566% ## ( 6, 10 ] 640 4.309% 98.876% # ( 10, 15 ] 83 0.559% 99.434% ( 15, 22 ] 20 0.135% 99.569% ( 22, 34 ] 1 0.007% 99.576% ( 34, 51 ] 2 0.013% 99.589% ( 51, 76 ] 3 0.020% 99.609% ( 110, 170 ] 1 0.007% 99.616% ( 170, 250 ] 6 0.040% 99.657% ( 250, 380 ] 11 0.074% 99.731% ( 380, 580 ] 3 0.020% 99.751% ( 580, 870 ] 10 0.067% 99.818% ( 870, 1300 ] 6 0.040% 99.859% ( 1300, 1900 ] 5 0.034% 99.892% ( 1900, 2900 ] 5 0.034% 99.926% ( 2900, 4400 ] 10 0.067% 99.993% ( 4400, 6600 ] 1 0.007% 100.000% ** Level 4 read latency histogram (micros): Count: 310 Average: 104.9000 StdDev: 535.82 Min: 1 Median: 2.6132 Max: 4491 Percentiles: P50: 2.61 P75: 3.65 P99: 3612.50 P99.9: 4491.00 P99.99: 4491.00 ------------------------------------------------------ [ 0, 1 ] 5 1.613% 1.613% ( 1, 2 ] 85 27.419% 29.032% ##### ( 2, 3 ] 106 34.194% 63.226% ####### ( 3, 4 ] 56 18.065% 81.290% #### ( 4, 6 ] 33 10.645% 91.935% ## ( 6, 10 ] 3 0.968% 92.903% ( 10, 15 ] 2 0.645% 93.548% ( 250, 380 ] 4 1.290% 94.839% ( 380, 580 ] 3 0.968% 95.806% ( 580, 870 ] 5 1.613% 97.419% ( 1300, 1900 ] 1 0.323% 97.742% ( 1900, 2900 ] 2 0.645% 98.387% ( 2900, 4400 ] 4 1.290% 99.677% ( 4400, 6600 ] 1 0.323% 100.000% ** Level 5 read latency histogram (micros): Count: 40 Average: 922.9250 StdDev: 1164.58 Min: 75 Median: 315.0000 Max: 5134 Percentiles: P50: 315.00 P75: 1450.00 P99: 5134.00 P99.9: 5134.00 P99.99: 5134.00 ------------------------------------------------------ ( 51, 76 ] 1 2.500% 2.500% # ( 76, 110 ] 3 7.500% 10.000% ## ( 110, 170 ] 10 25.000% 35.000% ##### ( 170, 250 ] 5 12.500% 47.500% ### ( 250, 380 ] 2 5.000% 52.500% # ( 380, 580 ] 4 10.000% 62.500% ## ( 580, 870 ] 1 2.500% 65.000% # ( 870, 1300 ] 3 7.500% 72.500% ## ( 1300, 1900 ] 4 10.000% 82.500% ## ( 1900, 2900 ] 3 7.500% 90.000% ## ( 2900, 4400 ] 3 7.500% 97.500% ## ( 4400, 6600 ] 1 2.500% 100.000% # ** DB Stats ** Uptime(secs): 15.1 total, 3.0 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 326.93 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.682 H:M:S, 11.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 325.42 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.387 H:M:S, 12.8 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/07/23-18:57:03 ... thread 0: (1000000,6000000) ops and (229358.5,311937.4) ops/second in (4.359987,19.234626) 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.87 GB 100.7 4.2 0.0 4.2 9.8 5.7 0.0 1.7 133.5 314.1 32.08 30.08 100 0.321 4349K 4384 0.0 0.0 L1 11/11 1.21 GB 0.0 2.0 1.7 0.4 2.0 1.7 0.1 1.2 237.6 236.6 8.69 8.47 3 2.898 2097K 8115 0.0 0.0 L2 1/0 49.28 MB 0.5 0.1 0.1 0.0 0.1 0.1 0.5 1.8 241.5 241.4 0.46 0.44 1 0.462 113K 39 0.0 0.0 L3 15/0 773.35 MB 0.8 0.2 0.2 0.0 0.2 0.2 0.4 1.0 222.1 222.1 0.87 0.79 2 0.435 196K 4 0.0 0.0 L4 174/0 9.65 GB 1.0 0.1 0.1 0.0 0.1 0.1 0.7 1.0 66.3 66.3 0.85 0.52 1 0.845 56K 0 0.0 0.0 L5 1048/0 86.25 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1268/24 101.78 GB 0.0 6.6 2.0 4.6 12.2 7.6 2.4 2.2 156.2 290.9 42.95 40.30 107 0.401 6813K 12K 0.0 0.0 Int 0/0 0.00 KB 0.0 6.6 2.0 4.6 12.2 7.6 2.4 2.2 156.2 290.9 42.95 40.30 107 0.401 6813K 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 6.6 2.0 4.6 6.5 2.0 0.0 0.0 250.1 249.6 26.83 25.86 23 1.167 6813K 12K 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 359.5 16.12 14.44 84 0.192 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.4 total, 19.2 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.20 GB write, 643.58 MB/s write, 6.55 GB read, 345.68 MB/s read, 42.9 seconds Interval compaction: 12.20 GB write, 649.45 MB/s write, 6.55 GB read, 348.83 MB/s read, 42.9 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: 19, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 8, total-stops: 19, interval: 27 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1729273 Average: 2.1302 StdDev: 12.43 Min: 0 Median: 1.4407 Max: 4527 Percentiles: P50: 1.44 P75: 1.82 P99: 5.47 P99.9: 10.98 P99.99: 21.65 ------------------------------------------------------ [ 0, 1 ] 357484 20.673% 20.673% #### ( 1, 2 ] 1150854 66.551% 87.224% ############# ( 2, 3 ] 131364 7.596% 94.820% ## ( 3, 4 ] 51351 2.970% 97.790% # ( 4, 6 ] 28481 1.647% 99.437% ( 6, 10 ] 7668 0.443% 99.880% ( 10, 15 ] 1746 0.101% 99.981% ( 15, 22 ] 160 0.009% 99.990% ( 22, 34 ] 26 0.002% 99.992% ( 34, 51 ] 11 0.001% 99.993% ( 51, 76 ] 20 0.001% 99.994% ( 76, 110 ] 87 0.005% 99.999% ( 110, 170 ] 154 0.009% 100.008% ( 170, 250 ] 68 0.004% 100.012% ( 250, 380 ] 49 0.003% 100.014% ( 380, 580 ] 27 0.002% 100.016% ( 580, 870 ] 34 0.002% 100.018% ( 870, 1300 ] 21 0.001% 100.019% ( 1300, 1900 ] 14 0.001% 100.020% ( 1900, 2900 ] 7 0.000% 100.020% ( 2900, 4400 ] 10 0.001% 100.021% ( 4400, 6600 ] 1 0.000% 100.021% ** Level 1 read latency histogram (micros): Count: 181299 Average: 2.3797 StdDev: 12.61 Min: 0 Median: 1.4706 Max: 1671 Percentiles: P50: 1.47 P75: 1.84 P99: 6.83 P99.9: 95.20 P99.99: 578.00 ------------------------------------------------------ [ 0, 1 ] 33226 18.327% 18.327% #### ( 1, 2 ] 122021 67.304% 85.630% ############# ( 2, 3 ] 14819 8.174% 93.804% ## ( 3, 4 ] 5605 3.092% 96.896% # ( 4, 6 ] 3469 1.913% 98.809% ( 6, 10 ] 1666 0.919% 99.728% ( 10, 15 ] 245 0.135% 99.863% ( 15, 22 ] 15 0.008% 99.871% ( 22, 34 ] 4 0.002% 99.874% ( 34, 51 ] 3 0.002% 99.875% ( 51, 76 ] 8 0.004% 99.880% ( 76, 110 ] 65 0.036% 99.916% ( 110, 170 ] 89 0.049% 99.965% ( 170, 250 ] 11 0.006% 99.971% ( 250, 380 ] 22 0.012% 99.983% ( 380, 580 ] 13 0.007% 99.990% ( 580, 870 ] 7 0.004% 99.994% ( 870, 1300 ] 7 0.004% 99.998% ( 1300, 1900 ] 4 0.002% 100.000% ** Level 2 read latency histogram (micros): Count: 28196 Average: 2.2908 StdDev: 18.94 Min: 1 Median: 1.2827 Max: 2150 Percentiles: P50: 1.28 P75: 1.72 P99: 7.13 P99.9: 71.30 P99.99: 947.57 ------------------------------------------------------ [ 0, 1 ] 9493 33.668% 33.668% ####### ( 1, 2 ] 16289 57.771% 91.439% ############ ( 2, 3 ] 1651 5.855% 97.294% # ( 3, 4 ] 279 0.990% 98.283% ( 4, 6 ] 147 0.521% 98.805% ( 6, 10 ] 195 0.692% 99.496% ( 10, 15 ] 59 0.209% 99.706% ( 15, 22 ] 9 0.032% 99.738% ( 34, 51 ] 32 0.113% 99.851% ( 51, 76 ] 17 0.060% 99.911% ( 76, 110 ] 3 0.011% 99.922% ( 110, 170 ] 4 0.014% 99.936% ( 170, 250 ] 7 0.025% 99.961% ( 250, 380 ] 4 0.014% 99.975% ( 580, 870 ] 4 0.014% 99.989% ( 870, 1300 ] 1 0.004% 99.993% ( 1300, 1900 ] 1 0.004% 99.996% ( 1900, 2900 ] 1 0.004% 100.000% ** Level 3 read latency histogram (micros): Count: 14852 Average: 8.9993 StdDev: 120.52 Min: 0 Median: 2.6672 Max: 4784 Percentiles: P50: 2.67 P75: 3.59 P99: 11.11 P99.9: 2129.60 P99.99: 4327.22 ------------------------------------------------------ [ 0, 1 ] 141 0.949% 0.949% ( 1, 2 ] 3259 21.943% 22.893% #### ( 2, 3 ] 6034 40.628% 63.520% ######## ( 3, 4 ] 2912 19.607% 83.127% #### ( 4, 6 ] 1699 11.440% 94.566% ## ( 6, 10 ] 640 4.309% 98.876% # ( 10, 15 ] 83 0.559% 99.434% ( 15, 22 ] 20 0.135% 99.569% ( 22, 34 ] 1 0.007% 99.576% ( 34, 51 ] 2 0.013% 99.589% ( 51, 76 ] 3 0.020% 99.609% ( 110, 170 ] 1 0.007% 99.616% ( 170, 250 ] 6 0.040% 99.657% ( 250, 380 ] 11 0.074% 99.731% ( 380, 580 ] 3 0.020% 99.751% ( 580, 870 ] 10 0.067% 99.818% ( 870, 1300 ] 6 0.040% 99.859% ( 1300, 1900 ] 5 0.034% 99.892% ( 1900, 2900 ] 5 0.034% 99.926% ( 2900, 4400 ] 10 0.067% 99.993% ( 4400, 6600 ] 1 0.007% 100.000% ** Level 4 read latency histogram (micros): Count: 310 Average: 104.9000 StdDev: 535.82 Min: 1 Median: 2.6132 Max: 4491 Percentiles: P50: 2.61 P75: 3.65 P99: 3612.50 P99.9: 4491.00 P99.99: 4491.00 ------------------------------------------------------ [ 0, 1 ] 5 1.613% 1.613% ( 1, 2 ] 85 27.419% 29.032% ##### ( 2, 3 ] 106 34.194% 63.226% ####### ( 3, 4 ] 56 18.065% 81.290% #### ( 4, 6 ] 33 10.645% 91.935% ## ( 6, 10 ] 3 0.968% 92.903% ( 10, 15 ] 2 0.645% 93.548% ( 250, 380 ] 4 1.290% 94.839% ( 380, 580 ] 3 0.968% 95.806% ( 580, 870 ] 5 1.613% 97.419% ( 1300, 1900 ] 1 0.323% 97.742% ( 1900, 2900 ] 2 0.645% 98.387% ( 2900, 4400 ] 4 1.290% 99.677% ( 4400, 6600 ] 1 0.323% 100.000% ** Level 5 read latency histogram (micros): Count: 40 Average: 922.9250 StdDev: 1164.58 Min: 75 Median: 315.0000 Max: 5134 Percentiles: P50: 315.00 P75: 1450.00 P99: 5134.00 P99.9: 5134.00 P99.99: 5134.00 ------------------------------------------------------ ( 51, 76 ] 1 2.500% 2.500% # ( 76, 110 ] 3 7.500% 10.000% ## ( 110, 170 ] 10 25.000% 35.000% ##### ( 170, 250 ] 5 12.500% 47.500% ### ( 250, 380 ] 2 5.000% 52.500% # ( 380, 580 ] 4 10.000% 62.500% ## ( 580, 870 ] 1 2.500% 65.000% # ( 870, 1300 ] 3 7.500% 72.500% ## ( 1300, 1900 ] 4 10.000% 82.500% ## ( 1900, 2900 ] 3 7.500% 90.000% ## ( 2900, 4400 ] 3 7.500% 97.500% ## ( 4400, 6600 ] 1 2.500% 100.000% # ** DB Stats ** Uptime(secs): 19.4 total, 4.4 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 304.20 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.376 H:M:S, 17.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 225.74 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:1.694 H:M:S, 38.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/07/23-18:57:21 ... thread 0: (1000000,7000000) ops and (54851.9,186838.3) ops/second in (18.230922,37.465548) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 7/6 1.90 GB 31.5 6.3 0.0 6.3 12.8 6.6 0.0 2.0 147.7 302.3 43.51 40.41 118 0.369 6523K 12K 0.0 0.0 L1 9/9 1.00 GB 0.0 6.1 4.5 1.6 6.0 4.5 0.1 1.3 229.3 226.1 27.31 26.10 4 6.828 6359K 86K 0.0 0.0 L2 18/14 2.26 GB 5.2 0.1 0.1 0.0 0.1 0.1 3.5 1.8 241.5 241.4 0.46 0.44 1 0.462 113K 39 0.0 0.0 L3 24/3 1.25 GB 1.0 1.4 1.0 0.4 1.4 1.0 0.4 1.4 194.3 193.7 7.51 6.43 5 1.502 1481K 4665 0.0 0.0 L4 174/0 9.65 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.8 1.0 120.4 120.4 1.66 1.19 3 0.553 202K 83 0.0 0.0 L5 1052/0 86.55 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1284/32 102.62 GB 0.0 14.1 5.8 8.3 20.6 12.3 5.9 3.1 179.7 262.2 80.45 74.57 131 0.614 14M 103K 0.0 0.0 Int 0/0 0.00 KB 0.0 14.1 5.8 8.3 20.6 12.3 5.9 3.1 179.7 262.2 80.45 74.57 131 0.614 14M 103K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 14.1 5.8 8.3 14.0 5.7 0.0 0.0 236.8 235.1 61.05 57.68 33 1.850 14M 103K 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 347.5 19.40 16.89 98 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): 37.6 total, 37.5 interval Flush(GB): cumulative 6.583, interval 6.583 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 20.60 GB write, 560.38 MB/s write, 14.12 GB read, 384.07 MB/s read, 80.4 seconds Interval compaction: 20.60 GB write, 563.01 MB/s write, 14.12 GB read, 385.87 MB/s read, 80.4 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: 21, pending-compaction-bytes-delays: 13, pending-compaction-bytes-stops: 0, total-delays: 25, total-stops: 21, interval: 46 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3042175 Average: 2.4708 StdDev: 16.87 Min: 0 Median: 1.4641 Max: 4527 Percentiles: P50: 1.46 P75: 1.85 P99: 6.41 P99.9: 106.87 P99.99: 254.20 ------------------------------------------------------ [ 0, 1 ] 606283 19.929% 19.929% #### ( 1, 2 ] 1970940 64.787% 84.716% ############# ( 2, 3 ] 254169 8.355% 93.071% ## ( 3, 4 ] 105329 3.462% 96.534% # ( 4, 6 ] 72645 2.388% 98.922% ( 6, 10 ] 23336 0.767% 99.689% ( 10, 15 ] 3991 0.131% 99.820% ( 15, 22 ] 543 0.018% 99.838% ( 22, 34 ] 49 0.002% 99.839% ( 34, 51 ] 13 0.000% 99.840% ( 51, 76 ] 38 0.001% 99.841% ( 76, 110 ] 1981 0.065% 99.906% ( 110, 170 ] 2086 0.069% 99.975% ( 170, 250 ] 459 0.015% 99.990% ( 250, 380 ] 334 0.011% 100.001% ( 380, 580 ] 264 0.009% 100.009% ( 580, 870 ] 132 0.004% 100.014% ( 870, 1300 ] 74 0.002% 100.016% ( 1300, 1900 ] 26 0.001% 100.017% ( 1900, 2900 ] 25 0.001% 100.018% ( 2900, 4400 ] 26 0.001% 100.019% ( 4400, 6600 ] 1 0.000% 100.019% ** Level 1 read latency histogram (micros): Count: 1065549 Average: 3.5208 StdDev: 33.47 Min: 0 Median: 1.6753 Max: 4885 Percentiles: P50: 1.68 P75: 2.42 P99: 9.03 P99.9: 110.70 P99.99: 256.81 ------------------------------------------------------ [ 0, 1 ] 116370 10.921% 10.921% ## ( 1, 2 ] 616625 57.869% 68.790% ############ ( 2, 3 ] 159175 14.938% 83.729% ### ( 3, 4 ] 76744 7.202% 90.931% # ( 4, 6 ] 70734 6.638% 97.569% # ( 6, 10 ] 20135 1.890% 99.459% ( 10, 15 ] 3653 0.343% 99.802% ( 15, 22 ] 364 0.034% 99.836% ( 22, 34 ] 30 0.003% 99.839% ( 34, 51 ] 8 0.001% 99.839% ( 51, 76 ] 45 0.004% 99.844% ( 76, 110 ] 595 0.056% 99.899% ( 110, 170 ] 638 0.060% 99.959% ( 170, 250 ] 311 0.029% 99.989% ( 250, 380 ] 333 0.031% 100.020% ( 380, 580 ] 290 0.027% 100.047% ( 580, 870 ] 202 0.019% 100.066% ( 870, 1300 ] 120 0.011% 100.077% ( 1300, 1900 ] 51 0.005% 100.082% ( 1900, 2900 ] 59 0.006% 100.088% ( 2900, 4400 ] 24 0.002% 100.090% ( 4400, 6600 ] 2 0.000% 100.090% ** Level 2 read latency histogram (micros): Count: 40712 Average: 3.4073 StdDev: 31.13 Min: 1 Median: 1.4674 Max: 2346 Percentiles: P50: 1.47 P75: 1.92 P99: 9.31 P99.9: 350.30 P99.99: 1685.76 ------------------------------------------------------ [ 0, 1 ] 9740 23.924% 23.924% ##### ( 1, 2 ] 22712 55.787% 79.711% ########### ( 2, 3 ] 4300 10.562% 90.273% ## ( 3, 4 ] 1541 3.785% 94.058% # ( 4, 6 ] 1539 3.780% 97.838% # ( 6, 10 ] 571 1.403% 99.241% ( 10, 15 ] 137 0.337% 99.578% ( 15, 22 ] 15 0.037% 99.614% ( 34, 51 ] 32 0.079% 99.693% ( 51, 76 ] 17 0.042% 99.735% ( 76, 110 ] 3 0.007% 99.742% ( 110, 170 ] 15 0.037% 99.779% ( 170, 250 ] 30 0.074% 99.853% ( 250, 380 ] 25 0.061% 99.914% ( 380, 580 ] 11 0.027% 99.941% ( 580, 870 ] 13 0.032% 99.973% ( 870, 1300 ] 5 0.012% 99.985% ( 1300, 1900 ] 3 0.007% 99.993% ( 1900, 2900 ] 3 0.007% 100.000% ** Level 3 read latency histogram (micros): Count: 137787 Average: 6.4296 StdDev: 81.36 Min: 0 Median: 2.0839 Max: 6280 Percentiles: P50: 2.08 P75: 3.23 P99: 11.09 P99.9: 700.40 P99.99: 2295.04 ------------------------------------------------------ [ 0, 1 ] 2448 1.777% 1.777% ( 1, 2 ] 63651 46.195% 47.972% ######### ( 2, 3 ] 33319 24.182% 72.153% ##### ( 3, 4 ] 17018 12.351% 84.504% ## ( 4, 6 ] 15755 11.434% 95.939% ## ( 6, 10 ] 4012 2.912% 98.850% # ( 10, 15 ] 945 0.686% 99.536% ( 15, 22 ] 104 0.075% 99.612% ( 22, 34 ] 6 0.004% 99.616% ( 34, 51 ] 4 0.003% 99.619% ( 51, 76 ] 5 0.004% 99.623% ( 76, 110 ] 16 0.012% 99.634% ( 110, 170 ] 55 0.040% 99.674% ( 170, 250 ] 92 0.067% 99.741% ( 250, 380 ] 96 0.070% 99.811% ( 380, 580 ] 90 0.065% 99.876% ( 580, 870 ] 80 0.058% 99.934% ( 870, 1300 ] 40 0.029% 99.963% ( 1300, 1900 ] 23 0.017% 99.980% ( 1900, 2900 ] 36 0.026% 100.006% ( 2900, 4400 ] 34 0.025% 100.030% ( 4400, 6600 ] 3 0.002% 100.033% ** Level 4 read latency histogram (micros): Count: 815 Average: 109.3816 StdDev: 398.51 Min: 1 Median: 2.6775 Max: 4491 Percentiles: P50: 2.68 P75: 5.02 P99: 2183.33 P99.9: 4491.00 P99.99: 4491.00 ------------------------------------------------------ [ 0, 1 ] 18 2.209% 2.209% ( 1, 2 ] 254 31.166% 33.374% ###### ( 2, 3 ] 200 24.540% 57.914% ##### ( 3, 4 ] 104 12.761% 70.675% ### ( 4, 6 ] 69 8.466% 79.141% ## ( 6, 10 ] 13 1.595% 80.736% ( 10, 15 ] 3 0.368% 81.104% ( 15, 22 ] 2 0.245% 81.350% ( 76, 110 ] 7 0.859% 82.209% ( 110, 170 ] 22 2.699% 84.908% # ( 170, 250 ] 31 3.804% 88.712% # ( 250, 380 ] 24 2.945% 91.656% # ( 380, 580 ] 27 3.313% 94.969% # ( 580, 870 ] 22 2.699% 97.669% # ( 870, 1300 ] 6 0.736% 98.405% ( 1300, 1900 ] 4 0.491% 98.896% ( 1900, 2900 ] 3 0.368% 99.264% ( 2900, 4400 ] 5 0.613% 99.877% ( 4400, 6600 ] 1 0.123% 100.000% ** Level 5 read latency histogram (micros): Count: 60 Average: 911.7167 StdDev: 1117.30 Min: 74 Median: 347.5000 Max: 5134 Percentiles: P50: 347.50 P75: 1420.00 P99: 5134.00 P99.9: 5134.00 P99.99: 5134.00 ------------------------------------------------------ ( 51, 76 ] 2 3.333% 3.333% # ( 76, 110 ] 3 5.000% 8.333% # ( 110, 170 ] 12 20.000% 28.333% #### ( 170, 250 ] 10 16.667% 45.000% ### ( 250, 380 ] 4 6.667% 51.667% # ( 380, 580 ] 6 10.000% 61.667% ## ( 580, 870 ] 3 5.000% 66.667% # ( 870, 1300 ] 4 6.667% 73.333% # ( 1300, 1900 ] 5 8.333% 81.667% ## ( 1900, 2900 ] 5 8.333% 90.000% ## ( 2900, 4400 ] 5 8.333% 98.333% ## ( 4400, 6600 ] 1 1.667% 100.000% ** DB Stats ** Uptime(secs): 37.6 total, 18.2 interval Cumulative writes: 0 writes, 7000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 6.73 GB, 183.02 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:18.571 H:M:S, 49.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 53.98 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:15.194 H:M:S, 83.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 5 num-running-flushes: 1 2024/07/23-18:57:26 ... thread 0: (1000000,8000000) ops and (192676.6,187548.7) ops/second in (5.190044,42.655592) 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/10 2.88 GB 100.7 6.8 0.0 6.8 14.4 7.6 0.0 1.9 136.5 287.4 51.24 45.40 133 0.385 7098K 12K 0.0 0.0 L1 9/9 1.00 GB 0.0 6.1 4.5 1.6 6.0 4.5 0.1 1.3 229.3 226.1 27.31 26.10 4 6.828 6359K 86K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.0 0.1 0.1 3.5 1.8 241.5 241.4 0.46 0.44 1 0.462 113K 39 0.0 0.0 L3 21/2 1.10 GB 1.0 4.5 3.3 1.2 4.4 3.2 0.4 1.4 176.3 175.6 25.92 20.49 12 2.160 4641K 18K 0.0 0.0 L4 182/2 9.70 GB 1.0 2.6 2.6 0.0 2.6 2.6 0.9 1.0 114.2 114.1 23.40 13.04 37 0.632 2696K 744 0.0 0.0 L5 1080/0 88.89 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 1306/23 103.59 GB 0.0 20.1 10.4 9.7 27.6 17.9 8.2 3.6 160.6 220.0 128.33 105.46 187 0.686 20M 118K 0.0 0.0 Int 0/0 0.00 KB 0.0 20.1 10.4 9.7 27.6 17.9 8.2 3.6 160.6 220.0 128.33 105.46 187 0.686 20M 118K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 20.1 10.4 9.7 20.0 10.3 0.0 0.0 198.1 196.9 104.05 85.84 76 1.369 20M 118K 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 319.2 24.28 19.62 111 0.219 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): 42.8 total, 42.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: 27.58 GB write, 659.27 MB/s write, 20.13 GB read, 481.15 MB/s read, 128.3 seconds Interval compaction: 27.58 GB write, 661.98 MB/s write, 20.13 GB read, 483.13 MB/s read, 128.3 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: 40, pending-compaction-bytes-delays: 24, pending-compaction-bytes-stops: 0, total-delays: 36, total-stops: 40, interval: 76 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3345549 Average: 2.7035 StdDev: 28.44 Min: 0 Median: 1.4962 Max: 10988 Percentiles: P50: 1.50 P75: 1.89 P99: 7.20 P99.9: 109.38 P99.99: 348.72 ------------------------------------------------------ [ 0, 1 ] 618187 18.478% 18.478% #### ( 1, 2 ] 2125482 63.532% 82.010% ############# ( 2, 3 ] 318702 9.526% 91.536% ## ( 3, 4 ] 132931 3.973% 95.509% # ( 4, 6 ] 107519 3.214% 98.723% # ( 6, 10 ] 30975 0.926% 99.649% ( 10, 15 ] 5625 0.168% 99.817% ( 15, 22 ] 688 0.021% 99.837% ( 22, 34 ] 69 0.002% 99.839% ( 34, 51 ] 20 0.001% 99.840% ( 51, 76 ] 43 0.001% 99.841% ( 76, 110 ] 1999 0.060% 99.901% ( 110, 170 ] 2153 0.064% 99.965% ( 170, 250 ] 523 0.016% 99.981% ( 250, 380 ] 393 0.012% 99.993% ( 380, 580 ] 346 0.010% 100.003% ( 580, 870 ] 204 0.006% 100.009% ( 870, 1300 ] 143 0.004% 100.014% ( 1300, 1900 ] 58 0.002% 100.015% ( 1900, 2900 ] 69 0.002% 100.017% ( 2900, 4400 ] 64 0.002% 100.019% ( 4400, 6600 ] 19 0.001% 100.020% ( 6600, 9900 ] 3 0.000% 100.020% ( 9900, 14000 ] 1 0.000% 100.020% ** Level 1 read latency histogram (micros): Count: 1407392 Average: 4.7639 StdDev: 75.08 Min: 0 Median: 1.7362 Max: 23211 Percentiles: P50: 1.74 P75: 2.61 P99: 9.44 P99.9: 167.01 P99.99: 548.55 ------------------------------------------------------ [ 0, 1 ] 122953 8.736% 8.736% ## ( 1, 2 ] 788880 56.053% 64.789% ########### ( 2, 3 ] 235516 16.734% 81.523% ### ( 3, 4 ] 111503 7.923% 89.446% ## ( 4, 6 ] 108633 7.719% 97.164% ## ( 6, 10 ] 30071 2.137% 99.301% ( 10, 15 ] 6376 0.453% 99.754% ( 15, 22 ] 653 0.046% 99.801% ( 22, 34 ] 51 0.004% 99.804% ( 34, 51 ] 13 0.001% 99.805% ( 51, 76 ] 46 0.003% 99.808% ( 76, 110 ] 615 0.044% 99.852% ( 110, 170 ] 711 0.051% 99.903% ( 170, 250 ] 385 0.027% 99.930% ( 250, 380 ] 451 0.032% 99.962% ( 380, 580 ] 469 0.033% 99.995% ( 580, 870 ] 372 0.026% 100.022% ( 870, 1300 ] 258 0.018% 100.040% ( 1300, 1900 ] 177 0.013% 100.053% ( 1900, 2900 ] 218 0.015% 100.068% ( 2900, 4400 ] 160 0.011% 100.080% ( 4400, 6600 ] 51 0.004% 100.083% ( 6600, 9900 ] 13 0.001% 100.084% ( 9900, 14000 ] 2 0.000% 100.084% ( 14000, 22000 ] 2 0.000% 100.084% ( 22000, 33000 ] 1 0.000% 100.084% ** Level 2 read latency histogram (micros): Count: 40712 Average: 3.4073 StdDev: 31.13 Min: 1 Median: 1.4674 Max: 2346 Percentiles: P50: 1.47 P75: 1.92 P99: 9.31 P99.9: 350.30 P99.99: 1685.76 ------------------------------------------------------ [ 0, 1 ] 9740 23.924% 23.924% ##### ( 1, 2 ] 22712 55.787% 79.711% ########### ( 2, 3 ] 4300 10.562% 90.273% ## ( 3, 4 ] 1541 3.785% 94.058% # ( 4, 6 ] 1539 3.780% 97.838% # ( 6, 10 ] 571 1.403% 99.241% ( 10, 15 ] 137 0.337% 99.578% ( 15, 22 ] 15 0.037% 99.614% ( 34, 51 ] 32 0.079% 99.693% ( 51, 76 ] 17 0.042% 99.735% ( 76, 110 ] 3 0.007% 99.742% ( 110, 170 ] 15 0.037% 99.779% ( 170, 250 ] 30 0.074% 99.853% ( 250, 380 ] 25 0.061% 99.914% ( 380, 580 ] 11 0.027% 99.941% ( 580, 870 ] 13 0.032% 99.973% ( 870, 1300 ] 5 0.012% 99.985% ( 1300, 1900 ] 3 0.007% 99.993% ( 1900, 2900 ] 3 0.007% 100.000% ** Level 3 read latency histogram (micros): Count: 909564 Average: 8.7113 StdDev: 118.92 Min: 0 Median: 2.0333 Max: 11478 Percentiles: P50: 2.03 P75: 3.19 P99: 10.29 P99.9: 430.84 P99.99: 776.40 ------------------------------------------------------ [ 0, 1 ] 12195 1.341% 1.341% ( 1, 2 ] 435447 47.874% 49.215% ########## ( 2, 3 ] 214675 23.602% 72.817% ##### ( 3, 4 ] 103483 11.377% 84.194% ## ( 4, 6 ] 109340 12.021% 96.215% ## ( 6, 10 ] 24939 2.742% 98.957% # ( 10, 15 ] 6748 0.742% 99.699% ( 15, 22 ] 768 0.084% 99.784% ( 22, 34 ] 38 0.004% 99.788% ( 34, 51 ] 17 0.002% 99.790% ( 51, 76 ] 15 0.002% 99.791% ( 76, 110 ] 51 0.006% 99.797% ( 110, 170 ] 168 0.018% 99.815% ( 170, 250 ] 275 0.030% 99.846% ( 250, 380 ] 364 0.040% 99.886% ( 380, 580 ] 521 0.057% 99.943% ( 580, 870 ] 635 0.070% 100.013% ( 870, 1300 ] 506 0.056% 100.068% ( 1300, 1900 ] 402 0.044% 100.112% ( 1900, 2900 ] 471 0.052% 100.164% ( 2900, 4400 ] 409 0.045% 100.209% ( 4400, 6600 ] 83 0.009% 100.218% ( 6600, 9900 ] 11 0.001% 100.220% ( 9900, 14000 ] 2 0.000% 100.220% ** Level 4 read latency histogram (micros): Count: 9941 Average: 371.7615 StdDev: 899.58 Min: 1 Median: 2.7493 Max: 14356 Percentiles: P50: 2.75 P75: 124.54 P99: 4223.54 P99.9: 6621.63 P99.99: 14047.20 ------------------------------------------------------ [ 0, 1 ] 135 1.358% 1.358% ( 1, 2 ] 3229 32.482% 33.840% ###### ( 2, 3 ] 2144 21.567% 55.407% #### ( 3, 4 ] 966 9.717% 65.124% ## ( 4, 6 ] 652 6.559% 71.683% # ( 6, 10 ] 188 1.891% 73.574% ( 10, 15 ] 56 0.563% 74.137% ( 15, 22 ] 27 0.272% 74.409% ( 22, 34 ] 4 0.040% 74.449% ( 34, 51 ] 7 0.070% 74.520% ( 76, 110 ] 24 0.241% 74.761% ( 110, 170 ] 98 0.986% 75.747% ( 170, 250 ] 151 1.519% 77.266% ( 250, 380 ] 178 1.791% 79.056% ( 380, 580 ] 314 3.159% 82.215% # ( 580, 870 ] 386 3.883% 86.098% # ( 870, 1300 ] 331 3.330% 89.428% # ( 1300, 1900 ] 318 3.199% 92.626% # ( 1900, 2900 ] 353 3.551% 96.177% # ( 2900, 4400 ] 318 3.199% 99.376% # ( 4400, 6600 ] 52 0.523% 99.899% ( 6600, 9900 ] 9 0.091% 99.990% ( 14000, 22000 ] 1 0.010% 100.000% ** Level 5 read latency histogram (micros): Count: 200 Average: 1401.6100 StdDev: 1503.09 Min: 74 Median: 730.8000 Max: 8328 Percentiles: P50: 730.80 P75: 2291.30 P99: 6380.00 P99.9: 8328.00 P99.99: 8328.00 ------------------------------------------------------ ( 51, 76 ] 2 1.000% 1.000% ( 76, 110 ] 4 2.000% 3.000% ( 110, 170 ] 16 8.000% 11.000% ## ( 170, 250 ] 15 7.500% 18.500% ## ( 250, 380 ] 23 11.500% 30.000% ## ( 380, 580 ] 27 13.500% 43.500% ### ( 580, 870 ] 25 12.500% 56.000% ### ( 870, 1300 ] 20 10.000% 66.000% ## ( 1300, 1900 ] 9 4.500% 70.500% # ( 1900, 2900 ] 23 11.500% 82.000% ## ( 2900, 4400 ] 25 12.500% 94.500% ### ( 4400, 6600 ] 10 5.000% 99.500% # ( 6600, 9900 ] 1 0.500% 100.000% ** DB Stats ** Uptime(secs): 42.8 total, 5.2 interval Cumulative writes: 0 writes, 8000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 7.69 GB, 183.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:20.797 H:M:S, 48.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 189.63 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:2.227 H:M:S, 42.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 5 num-running-flushes: 1 2024/07/23-18:57:30 ... thread 0: (1000000,9000000) ops and (306387.9,195995.5) ops/second in (3.263836,45.919428) 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/10 3.87 GB 195.1 7.6 0.0 7.6 16.2 8.5 0.0 1.9 136.4 289.1 57.27 51.06 149 0.384 7930K 13K 0.0 0.0 L1 9/9 1.00 GB 0.0 6.1 4.5 1.6 6.0 4.5 0.1 1.3 229.3 226.1 27.31 26.10 4 6.828 6359K 86K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.0 0.1 0.1 3.5 1.8 241.5 241.4 0.46 0.44 1 0.462 113K 39 0.0 0.0 L3 19/0 989.74 MB 1.0 4.5 3.3 1.2 4.4 3.2 0.4 1.4 176.3 175.6 25.92 20.49 12 2.160 4641K 18K 0.0 0.0 L4 180/0 9.53 GB 1.0 2.8 2.7 0.0 2.7 2.7 0.9 1.0 116.8 116.8 24.11 13.68 39 0.618 2841K 845 0.0 0.0 L5 1084/0 89.20 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 1310/19 104.57 GB 0.0 21.1 10.6 10.5 29.5 19.0 8.5 3.4 159.7 223.7 135.06 111.77 205 0.659 21M 119K 0.0 0.0 Int 0/0 0.00 KB 0.0 21.1 10.6 10.5 29.5 19.0 8.5 3.4 159.7 223.7 135.06 111.77 205 0.659 21M 119K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 21.1 10.6 10.5 20.9 10.5 0.0 0.0 200.0 198.8 107.88 89.53 81 1.332 21M 119K 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 322.1 27.18 22.24 124 0.219 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.1 total, 45.9 interval Flush(GB): cumulative 8.551, interval 8.551 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 29.50 GB write, 655.31 MB/s write, 21.07 GB read, 467.96 MB/s read, 135.1 seconds Interval compaction: 29.50 GB write, 657.81 MB/s write, 21.07 GB read, 469.75 MB/s read, 135.1 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: 45, pending-compaction-bytes-delays: 24, pending-compaction-bytes-stops: 0, total-delays: 36, total-stops: 45, interval: 81 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3624472 Average: 2.6748 StdDev: 27.47 Min: 0 Median: 1.5003 Max: 10988 Percentiles: P50: 1.50 P75: 1.89 P99: 7.07 P99.9: 105.08 P99.99: 331.35 ------------------------------------------------------ [ 0, 1 ] 654431 18.056% 18.056% #### ( 1, 2 ] 2314077 63.846% 81.902% ############# ( 2, 3 ] 350761 9.678% 91.579% ## ( 3, 4 ] 144407 3.984% 95.564% # ( 4, 6 ] 115728 3.193% 98.757% # ( 6, 10 ] 32922 0.908% 99.665% ( 10, 15 ] 5961 0.164% 99.829% ( 15, 22 ] 716 0.020% 99.849% ( 22, 34 ] 69 0.002% 99.851% ( 34, 51 ] 21 0.001% 99.852% ( 51, 76 ] 45 0.001% 99.853% ( 76, 110 ] 2002 0.055% 99.908% ( 110, 170 ] 2172 0.060% 99.968% ( 170, 250 ] 549 0.015% 99.983% ( 250, 380 ] 402 0.011% 99.994% ( 380, 580 ] 354 0.010% 100.004% ( 580, 870 ] 214 0.006% 100.010% ( 870, 1300 ] 148 0.004% 100.014% ( 1300, 1900 ] 58 0.002% 100.016% ( 1900, 2900 ] 70 0.002% 100.018% ( 2900, 4400 ] 65 0.002% 100.019% ( 4400, 6600 ] 19 0.001% 100.020% ( 6600, 9900 ] 3 0.000% 100.020% ( 9900, 14000 ] 1 0.000% 100.020% ** Level 1 read latency histogram (micros): Count: 1552393 Average: 4.5646 StdDev: 71.56 Min: 0 Median: 1.7171 Max: 23211 Percentiles: P50: 1.72 P75: 2.54 P99: 9.36 P99.9: 162.28 P99.99: 547.46 ------------------------------------------------------ [ 0, 1 ] 138841 8.944% 8.944% ## ( 1, 2 ] 888783 57.252% 66.196% ########### ( 2, 3 ] 252377 16.257% 82.453% ### ( 3, 4 ] 116516 7.506% 89.959% ## ( 4, 6 ] 112802 7.266% 97.225% # ( 6, 10 ] 32765 2.111% 99.336% ( 10, 15 ] 6572 0.423% 99.759% ( 15, 22 ] 662 0.043% 99.802% ( 22, 34 ] 52 0.003% 99.805% ( 34, 51 ] 19 0.001% 99.806% ( 51, 76 ] 46 0.003% 99.809% ( 76, 110 ] 693 0.045% 99.854% ( 110, 170 ] 819 0.053% 99.907% ( 170, 250 ] 418 0.027% 99.934% ( 250, 380 ] 466 0.030% 99.964% ( 380, 580 ] 487 0.031% 99.995% ( 580, 870 ] 378 0.024% 100.020% ( 870, 1300 ] 261 0.017% 100.036% ( 1300, 1900 ] 177 0.011% 100.048% ( 1900, 2900 ] 218 0.014% 100.062% ( 2900, 4400 ] 160 0.010% 100.072% ( 4400, 6600 ] 51 0.003% 100.075% ( 6600, 9900 ] 13 0.001% 100.076% ( 9900, 14000 ] 2 0.000% 100.076% ( 14000, 22000 ] 2 0.000% 100.076% ( 22000, 33000 ] 1 0.000% 100.077% ** Level 2 read latency histogram (micros): Count: 40712 Average: 3.4073 StdDev: 31.13 Min: 1 Median: 1.4674 Max: 2346 Percentiles: P50: 1.47 P75: 1.92 P99: 9.31 P99.9: 350.30 P99.99: 1685.76 ------------------------------------------------------ [ 0, 1 ] 9740 23.924% 23.924% ##### ( 1, 2 ] 22712 55.787% 79.711% ########### ( 2, 3 ] 4300 10.562% 90.273% ## ( 3, 4 ] 1541 3.785% 94.058% # ( 4, 6 ] 1539 3.780% 97.838% # ( 6, 10 ] 571 1.403% 99.241% ( 10, 15 ] 137 0.337% 99.578% ( 15, 22 ] 15 0.037% 99.614% ( 34, 51 ] 32 0.079% 99.693% ( 51, 76 ] 17 0.042% 99.735% ( 76, 110 ] 3 0.007% 99.742% ( 110, 170 ] 15 0.037% 99.779% ( 170, 250 ] 30 0.074% 99.853% ( 250, 380 ] 25 0.061% 99.914% ( 380, 580 ] 11 0.027% 99.941% ( 580, 870 ] 13 0.032% 99.973% ( 870, 1300 ] 5 0.012% 99.985% ( 1300, 1900 ] 3 0.007% 99.993% ( 1900, 2900 ] 3 0.007% 100.000% ** Level 3 read latency histogram (micros): Count: 917783 Average: 8.6599 StdDev: 118.38 Min: 0 Median: 2.0323 Max: 11478 Percentiles: P50: 2.03 P75: 3.19 P99: 10.24 P99.9: 425.76 P99.99: 773.74 ------------------------------------------------------ [ 0, 1 ] 12288 1.339% 1.339% ( 1, 2 ] 439604 47.898% 49.237% ########## ( 2, 3 ] 216628 23.603% 72.841% ##### ( 3, 4 ] 104356 11.370% 84.211% ## ( 4, 6 ] 110301 12.018% 96.229% ## ( 6, 10 ] 25106 2.736% 98.965% # ( 10, 15 ] 6765 0.737% 99.702% ( 15, 22 ] 769 0.084% 99.786% ( 22, 34 ] 38 0.004% 99.790% ( 34, 51 ] 17 0.002% 99.792% ( 51, 76 ] 15 0.002% 99.793% ( 76, 110 ] 51 0.006% 99.799% ( 110, 170 ] 169 0.018% 99.817% ( 170, 250 ] 275 0.030% 99.847% ( 250, 380 ] 364 0.040% 99.887% ( 380, 580 ] 521 0.057% 99.944% ( 580, 870 ] 635 0.069% 100.013% ( 870, 1300 ] 506 0.055% 100.068% ( 1300, 1900 ] 402 0.044% 100.112% ( 1900, 2900 ] 471 0.051% 100.163% ( 2900, 4400 ] 409 0.045% 100.208% ( 4400, 6600 ] 83 0.009% 100.217% ( 6600, 9900 ] 11 0.001% 100.218% ( 9900, 14000 ] 2 0.000% 100.218% ** Level 4 read latency histogram (micros): Count: 10071 Average: 367.1334 StdDev: 894.70 Min: 1 Median: 2.7377 Max: 14356 Percentiles: P50: 2.74 P75: 103.27 P99: 4217.41 P99.9: 6597.00 P99.99: 9897.40 ------------------------------------------------------ [ 0, 1 ] 143 1.420% 1.420% ( 1, 2 ] 3288 32.648% 34.068% ####### ( 2, 3 ] 2175 21.597% 55.665% #### ( 3, 4 ] 981 9.741% 65.406% ## ( 4, 6 ] 659 6.544% 71.949% # ( 6, 10 ] 192 1.906% 73.856% ( 10, 15 ] 56 0.556% 74.412% ( 15, 22 ] 27 0.268% 74.680% ( 22, 34 ] 6 0.060% 74.739% ( 34, 51 ] 7 0.070% 74.809% ( 76, 110 ] 24 0.238% 75.047% ( 110, 170 ] 98 0.973% 76.020% ( 170, 250 ] 153 1.519% 77.539% ( 250, 380 ] 179 1.777% 79.317% ( 380, 580 ] 314 3.118% 82.435% # ( 580, 870 ] 387 3.843% 86.277% # ( 870, 1300 ] 331 3.287% 89.564% # ( 1300, 1900 ] 318 3.158% 92.722% # ( 1900, 2900 ] 353 3.505% 96.227% # ( 2900, 4400 ] 318 3.158% 99.384% # ( 4400, 6600 ] 52 0.516% 99.901% ( 6600, 9900 ] 9 0.089% 99.990% ( 14000, 22000 ] 1 0.010% 100.000% ** Level 5 read latency histogram (micros): Count: 220 Average: 1361.8182 StdDev: 1476.11 Min: 74 Median: 702.6923 Max: 8328 Percentiles: P50: 702.69 P75: 2207.69 P99: 6336.00 P99.9: 8328.00 P99.99: 8328.00 ------------------------------------------------------ ( 51, 76 ] 2 0.909% 0.909% ( 76, 110 ] 4 1.818% 2.727% ( 110, 170 ] 20 9.091% 11.818% ## ( 170, 250 ] 18 8.182% 20.000% ## ( 250, 380 ] 26 11.818% 31.818% ## ( 380, 580 ] 29 13.182% 45.000% ### ( 580, 870 ] 26 11.818% 56.818% ## ( 870, 1300 ] 22 10.000% 66.818% ## ( 1300, 1900 ] 10 4.545% 71.364% # ( 1900, 2900 ] 26 11.818% 83.182% ## ( 2900, 4400 ] 26 11.818% 95.000% ## ( 4400, 6600 ] 10 4.545% 99.545% # ( 6600, 9900 ] 1 0.455% 100.000% ** DB Stats ** Uptime(secs): 46.1 total, 3.3 interval Cumulative writes: 0 writes, 9000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 8.65 GB, 192.16 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:21.418 H:M:S, 46.5 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 301.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.621 H:M:S, 19.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/07/23-18:57:33 ... thread 0: (1000000,10000000) ops and (291324.6,202625.9) ops/second in (3.432597,49.352025) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 18/14 3.50 GB 50.4 8.7 0.0 8.7 18.3 9.5 0.0 1.9 138.9 290.3 64.39 57.78 167 0.386 9081K 14K 0.0 0.0 L1 31/31 2.17 GB 0.0 8.5 5.9 2.6 8.4 5.8 0.1 1.4 216.9 214.4 39.97 36.74 5 7.993 7758K 86K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.0 0.1 0.1 3.7 1.8 241.5 241.4 0.46 0.44 1 0.462 113K 39 0.0 0.0 L3 20/0 944.28 MB 0.9 4.5 3.3 1.2 4.4 3.2 0.5 1.4 176.3 175.6 25.92 20.49 12 2.160 4641K 18K 0.0 0.0 L4 183/0 9.75 GB 1.0 3.0 2.9 0.0 3.0 2.9 0.9 1.0 120.0 119.9 25.32 14.73 42 0.603 3065K 897 0.0 0.0 L5 1084/0 89.20 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 1336/45 105.54 GB 0.0 24.7 12.1 12.6 34.1 21.5 8.8 3.6 162.3 224.0 156.05 130.18 227 0.687 24M 120K 0.0 0.0 Int 0/0 0.00 KB 0.0 24.7 12.1 12.6 34.1 21.5 8.8 3.6 162.3 224.0 156.05 130.18 227 0.687 24M 120K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 24.7 12.1 12.6 24.6 12.0 0.0 0.0 201.0 199.9 126.01 105.40 89 1.416 24M 120K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 9.5 9.5 0.0 0.0 0.0 325.1 30.04 24.78 138 0.218 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.5 total, 49.4 interval Flush(GB): cumulative 9.536, interval 9.536 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: 34.14 GB write, 705.87 MB/s write, 24.74 GB read, 511.49 MB/s read, 156.1 seconds Interval compaction: 34.14 GB write, 708.38 MB/s write, 24.74 GB read, 513.31 MB/s read, 156.1 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 14, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 14, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 52, pending-compaction-bytes-delays: 24, pending-compaction-bytes-stops: 0, total-delays: 38, total-stops: 52, interval: 90 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3933273 Average: 2.6497 StdDev: 26.67 Min: 0 Median: 1.4970 Max: 10988 Percentiles: P50: 1.50 P75: 1.89 P99: 6.98 P99.9: 103.84 P99.99: 318.81 ------------------------------------------------------ [ 0, 1 ] 716879 18.226% 18.226% #### ( 1, 2 ] 2514626 63.932% 82.158% ############# ( 2, 3 ] 375605 9.549% 91.708% ## ( 3, 4 ] 154745 3.934% 95.642% # ( 4, 6 ] 123479 3.139% 98.781% # ( 6, 10 ] 34993 0.890% 99.671% ( 10, 15 ] 6379 0.162% 99.833% ( 15, 22 ] 763 0.019% 99.852% ( 22, 34 ] 74 0.002% 99.854% ( 34, 51 ] 22 0.001% 99.855% ( 51, 76 ] 48 0.001% 99.856% ( 76, 110 ] 2109 0.054% 99.910% ( 110, 170 ] 2351 0.060% 99.969% ( 170, 250 ] 578 0.015% 99.984% ( 250, 380 ] 432 0.011% 99.995% ( 380, 580 ] 371 0.009% 100.005% ( 580, 870 ] 226 0.006% 100.010% ( 870, 1300 ] 152 0.004% 100.014% ( 1300, 1900 ] 62 0.002% 100.016% ( 1900, 2900 ] 70 0.002% 100.018% ( 2900, 4400 ] 68 0.002% 100.019% ( 4400, 6600 ] 19 0.000% 100.020% ( 6600, 9900 ] 3 0.000% 100.020% ( 9900, 14000 ] 1 0.000% 100.020% ** Level 1 read latency histogram (micros): Count: 1566052 Average: 4.5930 StdDev: 71.46 Min: 0 Median: 1.7160 Max: 23211 Percentiles: P50: 1.72 P75: 2.54 P99: 9.38 P99.9: 170.35 P99.99: 561.62 ------------------------------------------------------ [ 0, 1 ] 140070 8.944% 8.944% ## ( 1, 2 ] 897964 57.339% 66.283% ########### ( 2, 3 ] 254245 16.235% 82.518% ### ( 3, 4 ] 117002 7.471% 89.989% # ( 4, 6 ] 113177 7.227% 97.216% # ( 6, 10 ] 33025 2.109% 99.325% ( 10, 15 ] 6587 0.421% 99.746% ( 15, 22 ] 663 0.042% 99.788% ( 22, 34 ] 52 0.003% 99.791% ( 34, 51 ] 20 0.001% 99.793% ( 51, 76 ] 48 0.003% 99.796% ( 76, 110 ] 756 0.048% 99.844% ( 110, 170 ] 875 0.056% 99.900% ( 170, 250 ] 449 0.029% 99.929% ( 250, 380 ] 492 0.031% 99.960% ( 380, 580 ] 518 0.033% 99.993% ( 580, 870 ] 389 0.025% 100.018% ( 870, 1300 ] 279 0.018% 100.036% ( 1300, 1900 ] 181 0.012% 100.047% ( 1900, 2900 ] 218 0.014% 100.061% ( 2900, 4400 ] 160 0.010% 100.071% ( 4400, 6600 ] 51 0.003% 100.075% ( 6600, 9900 ] 13 0.001% 100.075% ( 9900, 14000 ] 2 0.000% 100.076% ( 14000, 22000 ] 2 0.000% 100.076% ( 22000, 33000 ] 1 0.000% 100.076% ** Level 2 read latency histogram (micros): Count: 40712 Average: 3.4073 StdDev: 31.13 Min: 1 Median: 1.4674 Max: 2346 Percentiles: P50: 1.47 P75: 1.92 P99: 9.31 P99.9: 350.30 P99.99: 1685.76 ------------------------------------------------------ [ 0, 1 ] 9740 23.924% 23.924% ##### ( 1, 2 ] 22712 55.787% 79.711% ########### ( 2, 3 ] 4300 10.562% 90.273% ## ( 3, 4 ] 1541 3.785% 94.058% # ( 4, 6 ] 1539 3.780% 97.838% # ( 6, 10 ] 571 1.403% 99.241% ( 10, 15 ] 137 0.337% 99.578% ( 15, 22 ] 15 0.037% 99.614% ( 34, 51 ] 32 0.079% 99.693% ( 51, 76 ] 17 0.042% 99.735% ( 76, 110 ] 3 0.007% 99.742% ( 110, 170 ] 15 0.037% 99.779% ( 170, 250 ] 30 0.074% 99.853% ( 250, 380 ] 25 0.061% 99.914% ( 380, 580 ] 11 0.027% 99.941% ( 580, 870 ] 13 0.032% 99.973% ( 870, 1300 ] 5 0.012% 99.985% ( 1300, 1900 ] 3 0.007% 99.993% ( 1900, 2900 ] 3 0.007% 100.000% ** Level 3 read latency histogram (micros): Count: 973222 Average: 8.3862 StdDev: 115.04 Min: 0 Median: 2.0279 Max: 11478 Percentiles: P50: 2.03 P75: 3.18 P99: 10.29 P99.9: 391.88 P99.99: 747.82 ------------------------------------------------------ [ 0, 1 ] 12939 1.330% 1.330% ( 1, 2 ] 467270 48.013% 49.342% ########## ( 2, 3 ] 229740 23.606% 72.948% ##### ( 3, 4 ] 110016 11.304% 84.253% ## ( 4, 6 ] 116180 11.938% 96.190% ## ( 6, 10 ] 26919 2.766% 98.956% # ( 10, 15 ] 7218 0.742% 99.698% ( 15, 22 ] 827 0.085% 99.783% ( 22, 34 ] 42 0.004% 99.787% ( 34, 51 ] 17 0.002% 99.789% ( 51, 76 ] 15 0.002% 99.790% ( 76, 110 ] 90 0.009% 99.800% ( 110, 170 ] 256 0.026% 99.826% ( 170, 250 ] 301 0.031% 99.857% ( 250, 380 ] 387 0.040% 99.897% ( 380, 580 ] 535 0.055% 99.952% ( 580, 870 ] 644 0.066% 100.018% ( 870, 1300 ] 507 0.052% 100.070% ( 1300, 1900 ] 403 0.041% 100.111% ( 1900, 2900 ] 471 0.048% 100.160% ( 2900, 4400 ] 409 0.042% 100.202% ( 4400, 6600 ] 83 0.009% 100.210% ( 6600, 9900 ] 11 0.001% 100.211% ( 9900, 14000 ] 2 0.000% 100.212% ** Level 4 read latency histogram (micros): Count: 10883 Average: 347.0277 StdDev: 865.56 Min: 1 Median: 2.7269 Max: 14356 Percentiles: P50: 2.73 P75: 93.30 P99: 4179.10 P99.9: 6562.64 P99.99: 9867.62 ------------------------------------------------------ [ 0, 1 ] 162 1.489% 1.489% ( 1, 2 ] 3575 32.849% 34.338% ####### ( 2, 3 ] 2345 21.547% 55.885% #### ( 3, 4 ] 1059 9.731% 65.616% ## ( 4, 6 ] 698 6.414% 72.030% # ( 6, 10 ] 205 1.884% 73.913% ( 10, 15 ] 60 0.551% 74.465% ( 15, 22 ] 29 0.266% 74.731% ( 22, 34 ] 7 0.064% 74.796% ( 34, 51 ] 8 0.074% 74.869% ( 76, 110 ] 28 0.257% 75.126% ( 110, 170 ] 130 1.195% 76.321% ( 170, 250 ] 195 1.792% 78.113% ( 250, 380 ] 220 2.022% 80.134% ( 380, 580 ] 355 3.262% 83.396% # ( 580, 870 ] 413 3.795% 87.191% # ( 870, 1300 ] 340 3.124% 90.315% # ( 1300, 1900 ] 320 2.940% 93.256% # ( 1900, 2900 ] 354 3.253% 96.508% # ( 2900, 4400 ] 318 2.922% 99.430% # ( 4400, 6600 ] 52 0.478% 99.908% ( 6600, 9900 ] 9 0.083% 99.991% ( 14000, 22000 ] 1 0.009% 100.000% ** Level 5 read latency histogram (micros): Count: 220 Average: 1361.8182 StdDev: 1476.11 Min: 74 Median: 702.6923 Max: 8328 Percentiles: P50: 702.69 P75: 2207.69 P99: 6336.00 P99.9: 8328.00 P99.99: 8328.00 ------------------------------------------------------ ( 51, 76 ] 2 0.909% 0.909% ( 76, 110 ] 4 1.818% 2.727% ( 110, 170 ] 20 9.091% 11.818% ## ( 170, 250 ] 18 8.182% 20.000% ## ( 250, 380 ] 26 11.818% 31.818% ## ( 380, 580 ] 29 13.182% 45.000% ### ( 580, 870 ] 26 11.818% 56.818% ## ( 870, 1300 ] 22 10.000% 66.818% ## ( 1300, 1900 ] 10 4.545% 71.364% # ( 1900, 2900 ] 26 11.818% 83.182% ## ( 2900, 4400 ] 26 11.818% 95.000% ## ( 4400, 6600 ] 10 4.545% 99.545% # ( 6600, 9900 ] 1 0.455% 100.000% ** DB Stats ** Uptime(secs): 49.5 total, 3.4 interval Cumulative writes: 0 writes, 10M keys, 0 commit groups, 0.0 writes per commit group, ingest: 9.61 GB, 198.71 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:22.194 H:M:S, 44.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 286.72 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.776 H:M:S, 22.6 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 : 5.890 micros/op 169769 ops/sec 60.087 seconds 10200999 operations; 164.5 MB/s Microseconds per write: Count: 10200999 Average: 5.8903 StdDev: 352.45 Min: 1 Median: 1.7619 Max: 721831 Percentiles: P50: 1.76 P75: 2.76 P99: 8.61 P99.9: 1163.22 P99.99: 2711.27 ------------------------------------------------------ [ 0, 1 ] 1170640 11.476% 11.476% ## ( 1, 2 ] 5157787 50.562% 62.037% ########## ( 2, 3 ] 1738614 17.044% 79.081% ### ( 3, 4 ] 1432441 14.042% 93.123% ### ( 4, 6 ] 535573 5.250% 98.373% # ( 6, 10 ] 98006 0.961% 99.334% ( 10, 15 ] 26881 0.264% 99.598% ( 15, 22 ] 7164 0.070% 99.668% ( 22, 34 ] 1802 0.018% 99.685% ( 34, 51 ] 252 0.002% 99.688% ( 51, 76 ] 46 0.000% 99.688% ( 76, 110 ] 7123 0.070% 99.758% ( 110, 170 ] 2816 0.028% 99.786% ( 170, 250 ] 277 0.003% 99.788% ( 250, 380 ] 104 0.001% 99.790% ( 380, 580 ] 16 0.000% 99.790% ( 580, 870 ] 25 0.000% 99.790% ( 870, 1300 ] 16470 0.161% 99.951% ( 1300, 1900 ] 90 0.001% 99.952% ( 1900, 2900 ] 4748 0.047% 99.999% ( 2900, 4400 ] 73 0.001% 100.000% ( 4400, 6600 ] 19 0.000% 100.000% ( 6600, 9900 ] 5 0.000% 100.000% ( 9900, 14000 ] 2 0.000% 100.000% ( 14000, 22000 ] 2 0.000% 100.000% ( 22000, 33000 ] 4 0.000% 100.000% ( 33000, 50000 ] 2 0.000% 100.000% ( 75000, 110000 ] 1 0.000% 100.000% ( 110000, 170000 ] 1 0.000% 100.000% ( 170000, 250000 ] 12 0.000% 100.000% ( 250000, 380000 ] 2 0.000% 100.000% ( 570000, 860000 ] 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 : 193045 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 : 10200999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 10527430968 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 : 538 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 31940550 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 : 29949986506 rocksdb.compact.write.bytes COUNT : 29763522563 rocksdb.flush.write.bytes COUNT : 10503162092 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 : 52 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 : 302 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 : 10418490368 rocksdb.memtable.garbage.bytes.at.flush COUNT : 4066304 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 : 30043535258 rocksdb.non.last.level.read.count COUNT : 7258603 rocksdb.block.checksum.compute.count COUNT : 7257579 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.415728 P95 : 3.854059 P99 : 6.908043 P100 : 721829.000000 COUNT : 10200999 SUM : 55231490 rocksdb.compaction.times.micros P50 : 860000.000000 P95 : 5125000.000000 P99 : 14800000.000000 P100 : 18618377.000000 COUNT : 90 SUM : 127157058 rocksdb.compaction.times.cpu_micros P50 : 570000.000000 P95 : 3950000.000000 P99 : 14800000.000000 P100 : 17627571.000000 COUNT : 90 SUM : 106522956 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 : 709.736842 P95 : 2866.666667 P99 : 18640.000000 P100 : 91104.000000 COUNT : 142 SUM : 229590 rocksdb.compaction.outfile.sync.micros P50 : 1095.539216 P95 : 25135.000000 P99 : 54625.000000 P100 : 413882.000000 COUNT : 363 SUM : 1959453 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 : 102.935065 P95 : 1348.000000 P99 : 3140.000000 P100 : 3996.000000 COUNT : 252 SUM : 71618 rocksdb.table.open.io.micros P50 : 1542.857143 P95 : 7715.714286 P99 : 13371.333333 P100 : 17006.000000 COUNT : 538 SUM : 1154180 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.617953 P95 : 7.983025 P99 : 12.088015 P100 : 23218.000000 COUNT : 7255940 SUM : 46235029 rocksdb.read.block.get.micros P50 : 427.058824 P95 : 3547.619048 P99 : 5395.500000 P100 : 9661.000000 COUNT : 1076 SUM : 942785 rocksdb.write.raw.block.micros P50 : 0.513048 P95 : 0.974790 P99 : 2.922154 P100 : 26932.000000 COUNT : 9752349 SUM : 19788928 rocksdb.numfiles.in.singlecompaction P50 : 3.074074 P95 : 7.100000 P99 : 31.840000 P100 : 45.000000 COUNT : 118 SUM : 451 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.560696 P95 : 1168.923904 P99 : 2499.182896 P100 : 721649.000000 COUNT : 197946 SUM : 31955732 rocksdb.sst.read.micros P50 : 1.577223 P95 : 4.810233 P99 : 8.865534 P100 : 23211.000000 COUNT : 7258646 SUM : 31627617 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 : 10200999 SUM : 10527430968 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 : 209560.439560 P95 : 379277.777778 P99 : 738200.000000 P100 : 862325.000000 COUNT : 142 SUM : 30740654 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 : 327 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