[2024-11-27 11:18:38.866902] Starting SPDK v24.09.1-pre git sha1 b18e1bd62 / DPDK 22.11.4 initialization... [2024-11-27 11:18:38.867044] [ DPDK EAL parameters: rocksdb --no-shconf -c 0x1 --huge-unlink --no-telemetry --log-level=lib.eal:6 --log-level=lib.cryptodev:5 --log-level=lib.power:5 --log-level=user1:6 --base-virtaddr=0x200000000000 --match-allocations --file-prefix=spdk_pid1723106 ] Set seed to 1732702718863419 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-11-27 11:18:38.952024] app.c: 917:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-11-27 11:18:38.993384] app.c: 610:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-11-27 11:18:38.993434] app.c: 611:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 1723106' to capture a snapshot of events at runtime. [2024-11-27 11:18:38.993444] app.c: 616:app_setup_trace: *NOTICE*: 'spdk_trace' without parameters will also work if this is the only [2024-11-27 11:18:38.993469] app.c: 617:app_setup_trace: *NOTICE*: SPDK application currently running. [2024-11-27 11:18:38.993477] app.c: 618:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid1723106 for offline analysis/debug. [2024-11-27 11:18:38.993571] reactor.c: 990:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Wed Nov 27 11:18:43 2024 CPU: 96 * Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz CPUCache: 36608 KB 2024/11/27-11:18:45 ... thread 0: (1000000,1000000) ops and (364245.4,364245.4) ops/second in (2.745402,2.745402) 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/6 504.06 MB 12.6 0.0 0.0 0.0 0.8 0.8 0.0 1.0 0.0 359.2 2.28 2.08 12 0.190 0 0 0.0 0.0 L1 1/0 2.05 MB 0.2 0.2 0.2 0.1 0.2 0.2 0.1 1.3 253.6 253.4 0.99 0.97 1 0.994 255K 198 0.0 0.0 L2 3/2 298.56 MB 1.2 0.1 0.1 0.0 0.1 0.1 0.3 1.8 225.9 225.8 0.49 0.46 1 0.493 113K 35 0.0 0.0 L3 17/10 818.39 MB 0.0 0.1 0.1 0.0 0.1 0.1 0.0 1.0 200.6 200.6 0.31 0.26 1 0.312 63K 0 0.0 0.0 L4 116/0 9.54 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1044/0 85.82 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1189/18 96.94 GB 0.0 0.4 0.3 0.1 1.2 1.1 0.4 1.5 104.4 305.2 4.08 3.77 15 0.272 432K 233 0.0 0.0 Int 0/0 0.00 KB 0.0 0.4 0.3 0.1 1.2 1.1 0.4 1.5 104.4 305.2 4.08 3.77 15 0.272 432K 233 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 236.8 236.7 1.80 1.69 3 0.599 432K 233 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 359.2 2.28 2.08 12 0.190 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): 2.9 total, 2.7 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, 423.14 MB/s write, 0.42 GB read, 144.77 MB/s read, 4.1 seconds Interval compaction: 1.22 GB write, 453.10 MB/s write, 0.42 GB read, 155.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: 3, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 3, interval: 3 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 113765 Average: 1.7493 StdDev: 5.44 Min: 1 Median: 1.1607 Max: 897 Percentiles: P50: 1.16 P75: 1.63 P99: 3.97 P99.9: 9.54 P99.99: 231.65 ------------------------------------------------------ [ 0, 1 ] 47163 41.457% 41.457% ######## ( 1, 2 ] 60472 53.155% 94.612% ########### ( 2, 3 ] 3547 3.118% 97.730% # ( 3, 4 ] 1493 1.312% 99.042% ( 4, 6 ] 752 0.661% 99.703% ( 6, 10 ] 258 0.227% 99.930% ( 10, 15 ] 45 0.040% 99.969% ( 15, 22 ] 9 0.008% 99.977% ( 22, 34 ] 4 0.004% 99.981% ( 34, 51 ] 1 0.001% 99.982% ( 51, 76 ] 3 0.003% 99.984% ( 110, 170 ] 6 0.005% 99.989% ( 170, 250 ] 6 0.005% 99.995% ( 250, 380 ] 9 0.008% 100.003% ( 580, 870 ] 2 0.002% 100.004% ( 870, 1300 ] 1 0.001% 100.005% ** Level 1 read latency histogram (micros): Count: 16200 Average: 3.3751 StdDev: 52.53 Min: 1 Median: 1.3567 Max: 5012 Percentiles: P50: 1.36 P75: 1.80 P99: 9.06 P99.9: 232.93 P99.99: 3470.00 ------------------------------------------------------ [ 0, 1 ] 4854 29.963% 29.963% ###### ( 1, 2 ] 9100 56.173% 86.136% ########### ( 2, 3 ] 1307 8.068% 94.204% ## ( 3, 4 ] 339 2.093% 96.296% ( 4, 6 ] 328 2.025% 98.321% ( 6, 10 ] 144 0.889% 99.210% ( 10, 15 ] 32 0.198% 99.407% ( 15, 22 ] 4 0.025% 99.432% ( 22, 34 ] 1 0.006% 99.438% ( 34, 51 ] 34 0.210% 99.648% ( 51, 76 ] 18 0.111% 99.759% ( 76, 110 ] 5 0.031% 99.790% ( 110, 170 ] 6 0.037% 99.827% ( 170, 250 ] 15 0.093% 99.920% ( 250, 380 ] 4 0.025% 99.944% ( 380, 580 ] 2 0.012% 99.957% ( 580, 870 ] 1 0.006% 99.963% ( 870, 1300 ] 3 0.019% 99.981% ( 1300, 1900 ] 1 0.006% 99.988% ( 2900, 4400 ] 1 0.006% 99.994% ( 4400, 6600 ] 1 0.006% 100.000% ** Level 2 read latency histogram (micros): Count: 15874 Average: 1.7839 StdDev: 3.94 Min: 0 Median: 1.2103 Max: 310 Percentiles: P50: 1.21 P75: 1.67 P99: 3.71 P99.9: 9.85 P99.99: 276.82 ------------------------------------------------------ [ 0, 1 ] 6140 38.680% 38.680% ######## ( 1, 2 ] 8544 53.824% 92.503% ########### ( 2, 3 ] 916 5.770% 98.274% # ( 3, 4 ] 163 1.027% 99.301% ( 4, 6 ] 72 0.454% 99.754% ( 6, 10 ] 24 0.151% 99.906% ( 10, 15 ] 9 0.057% 99.962% ( 15, 22 ] 1 0.006% 99.969% ( 51, 76 ] 1 0.006% 99.975% ( 110, 170 ] 1 0.006% 99.981% ( 170, 250 ] 1 0.006% 99.987% ( 250, 380 ] 2 0.013% 100.000% ** Level 3 read latency histogram (micros): Count: 6900 Average: 14.4930 StdDev: 155.90 Min: 1 Median: 1.7795 Max: 4481 Percentiles: P50: 1.78 P75: 2.72 P99: 146.77 P99.9: 2771.43 P99.99: 4481.00 ------------------------------------------------------ [ 0, 1 ] 601 8.710% 8.710% ## ( 1, 2 ] 3656 52.986% 61.696% ########### ( 2, 3 ] 1277 18.507% 80.203% #### ( 3, 4 ] 514 7.449% 87.652% # ( 4, 6 ] 475 6.884% 94.536% # ( 6, 10 ] 211 3.058% 97.594% # ( 10, 15 ] 36 0.522% 98.116% ( 15, 22 ] 13 0.188% 98.304% ( 22, 34 ] 5 0.072% 98.377% ( 34, 51 ] 1 0.014% 98.391% ( 76, 110 ] 24 0.348% 98.739% ( 110, 170 ] 31 0.449% 99.188% ( 170, 250 ] 6 0.087% 99.275% ( 250, 380 ] 8 0.116% 99.391% ( 380, 580 ] 7 0.101% 99.493% ( 580, 870 ] 3 0.043% 99.536% ( 870, 1300 ] 10 0.145% 99.681% ( 1300, 1900 ] 10 0.145% 99.826% ( 1900, 2900 ] 7 0.101% 99.928% ( 2900, 4400 ] 5 0.072% 100.000% ( 4400, 6600 ] 1 0.014% 100.014% ** Level 4 read latency histogram (micros): Count: 30 Average: 1542.7667 StdDev: 1239.84 Min: 121 Median: 1177.1429 Max: 4709 Percentiles: P50: 1177.14 P75: 2150.00 P99: 4709.00 P99.9: 4709.00 P99.99: 4709.00 ------------------------------------------------------ ( 110, 170 ] 1 3.333% 3.333% # ( 170, 250 ] 3 10.000% 13.333% ## ( 380, 580 ] 3 10.000% 23.333% ## ( 580, 870 ] 3 10.000% 33.333% ## ( 870, 1300 ] 7 23.333% 56.667% ##### ( 1300, 1900 ] 5 16.667% 73.333% ### ( 1900, 2900 ] 2 6.667% 80.000% # ( 2900, 4400 ] 5 16.667% 96.667% ### ( 4400, 6600 ] 1 3.333% 100.000% # ** DB Stats ** Uptime(secs): 2.9 total, 2.7 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 334.57 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:0.164 H:M:S, 5.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 358.15 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.164 H:M:S, 6.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/11/27-11:18:49 ... thread 0: (1000000,2000000) ops and (325896.2,344005.3) ops/second in (3.068462,5.813864) 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/11 1.48 GB 18.9 0.6 0.0 0.6 2.4 1.8 0.0 1.3 83.5 325.5 7.54 6.95 28 0.269 639K 851 0.0 0.0 L1 1/1 2.05 MB 0.0 0.2 0.2 0.1 0.2 0.2 0.1 1.3 253.6 253.4 0.99 0.97 1 0.994 255K 198 0.0 0.0 L2 2/1 169.80 MB 1.2 0.1 0.1 0.0 0.1 0.1 0.3 1.8 225.9 225.8 0.49 0.46 1 0.493 113K 35 0.0 0.0 L3 74/9 947.09 MB 0.2 0.2 0.2 0.1 0.2 0.2 0.0 1.3 143.1 143.0 1.73 1.26 2 0.865 251K 92 0.0 0.0 L4 116/0 9.54 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1044/0 85.82 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1251/22 97.92 GB 0.0 1.2 0.4 0.8 3.0 2.2 0.4 1.7 115.3 285.0 10.76 9.64 32 0.336 1260K 1176 0.0 0.0 Int 0/0 0.00 KB 0.0 1.2 0.4 0.8 3.0 2.2 0.4 1.7 115.3 285.0 10.76 9.64 32 0.336 1260K 1176 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.2 0.4 0.8 1.2 0.4 0.0 0.0 220.6 220.4 5.63 5.05 6 0.938 1260K 1176 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 355.7 5.14 4.59 26 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): 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: 2.99 GB write, 510.29 MB/s write, 1.21 GB read, 206.50 MB/s read, 10.8 seconds Interval compaction: 2.99 GB write, 527.36 MB/s write, 1.21 GB read, 213.41 MB/s read, 10.8 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 7, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 7, interval: 7 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 383076 Average: 2.2097 StdDev: 8.02 Min: 1 Median: 1.4973 Max: 3257 Percentiles: P50: 1.50 P75: 1.90 P99: 5.79 P99.9: 11.51 P99.99: 15.92 ------------------------------------------------------ [ 0, 1 ] 73317 19.139% 19.139% #### ( 1, 2 ] 237729 62.058% 81.197% ############ ( 2, 3 ] 41957 10.953% 92.150% ## ( 3, 4 ] 15288 3.991% 96.140% # ( 4, 6 ] 12268 3.202% 99.343% # ( 6, 10 ] 1990 0.519% 99.862% ( 10, 15 ] 484 0.126% 99.989% ( 15, 22 ] 51 0.013% 100.002% ( 22, 34 ] 7 0.002% 100.004% ( 34, 51 ] 1 0.000% 100.004% ( 51, 76 ] 3 0.001% 100.005% ( 110, 170 ] 8 0.002% 100.007% ( 170, 250 ] 18 0.005% 100.012% ( 250, 380 ] 16 0.004% 100.016% ( 380, 580 ] 2 0.001% 100.016% ( 580, 870 ] 7 0.002% 100.018% ( 870, 1300 ] 3 0.001% 100.019% ( 1300, 1900 ] 1 0.000% 100.019% ( 2900, 4400 ] 1 0.000% 100.020% ** Level 1 read latency histogram (micros): Count: 44995 Average: 2.9188 StdDev: 31.54 Min: 1 Median: 1.6419 Max: 5012 Percentiles: P50: 1.64 P75: 2.27 P99: 7.79 P99.9: 67.67 P99.99: 1085.07 ------------------------------------------------------ [ 0, 1 ] 6050 13.446% 13.446% ### ( 1, 2 ] 25625 56.951% 70.397% ########### ( 2, 3 ] 7688 17.086% 87.483% ### ( 3, 4 ] 2539 5.643% 93.126% # ( 4, 6 ] 2426 5.392% 98.518% # ( 6, 10 ] 486 1.080% 99.598% ( 10, 15 ] 78 0.173% 99.771% ( 15, 22 ] 10 0.022% 99.793% ( 22, 34 ] 2 0.004% 99.798% ( 34, 51 ] 34 0.076% 99.873% ( 51, 76 ] 18 0.040% 99.913% ( 76, 110 ] 5 0.011% 99.924% ( 110, 170 ] 6 0.013% 99.938% ( 170, 250 ] 15 0.033% 99.971% ( 250, 380 ] 4 0.009% 99.980% ( 380, 580 ] 2 0.004% 99.984% ( 580, 870 ] 1 0.002% 99.987% ( 870, 1300 ] 3 0.007% 99.993% ( 1300, 1900 ] 1 0.002% 99.996% ( 2900, 4400 ] 1 0.002% 99.998% ( 4400, 6600 ] 1 0.002% 100.000% ** Level 2 read latency histogram (micros): Count: 17080 Average: 1.8269 StdDev: 3.81 Min: 0 Median: 1.2489 Max: 310 Percentiles: P50: 1.25 P75: 1.71 P99: 4.00 P99.9: 9.85 P99.99: 268.98 ------------------------------------------------------ [ 0, 1 ] 6218 36.405% 36.405% ####### ( 1, 2 ] 9330 54.625% 91.030% ########### ( 2, 3 ] 1136 6.651% 97.681% # ( 3, 4 ] 226 1.323% 99.005% ( 4, 6 ] 126 0.738% 99.742% ( 6, 10 ] 29 0.170% 99.912% ( 10, 15 ] 10 0.059% 99.971% ( 15, 22 ] 1 0.006% 99.977% ( 51, 76 ] 1 0.006% 99.982% ( 110, 170 ] 1 0.006% 99.988% ( 170, 250 ] 1 0.006% 99.994% ( 250, 380 ] 2 0.012% 100.006% ** Level 3 read latency histogram (micros): Count: 206610 Average: 3.4628 StdDev: 33.50 Min: 1 Median: 1.6256 Max: 4481 Percentiles: P50: 1.63 P75: 2.15 P99: 9.08 P99.9: 232.44 P99.99: 979.75 ------------------------------------------------------ [ 0, 1 ] 25537 12.360% 12.360% ## ( 1, 2 ] 124306 60.165% 72.525% ############ ( 2, 3 ] 33076 16.009% 88.533% ### ( 3, 4 ] 9977 4.829% 93.362% # ( 4, 6 ] 8834 4.276% 97.638% # ( 6, 10 ] 3659 1.771% 99.409% ( 10, 15 ] 400 0.194% 99.603% ( 15, 22 ] 107 0.052% 99.654% ( 22, 34 ] 25 0.012% 99.667% ( 34, 51 ] 6 0.003% 99.669% ( 51, 76 ] 5 0.002% 99.672% ( 76, 110 ] 99 0.048% 99.720% ( 110, 170 ] 292 0.141% 99.861% ( 170, 250 ] 103 0.050% 99.911% ( 250, 380 ] 68 0.033% 99.944% ( 380, 580 ] 67 0.032% 99.976% ( 580, 870 ] 24 0.012% 99.988% ( 870, 1300 ] 17 0.008% 99.996% ( 1300, 1900 ] 13 0.006% 100.002% ( 1900, 2900 ] 7 0.003% 100.006% ( 2900, 4400 ] 6 0.003% 100.009% ( 4400, 6600 ] 1 0.000% 100.009% ** Level 4 read latency histogram (micros): Count: 30 Average: 1542.7667 StdDev: 1239.84 Min: 121 Median: 1177.1429 Max: 4709 Percentiles: P50: 1177.14 P75: 2150.00 P99: 4709.00 P99.9: 4709.00 P99.99: 4709.00 ------------------------------------------------------ ( 110, 170 ] 1 3.333% 3.333% # ( 170, 250 ] 3 10.000% 13.333% ## ( 380, 580 ] 3 10.000% 23.333% ## ( 580, 870 ] 3 10.000% 33.333% ## ( 870, 1300 ] 7 23.333% 56.667% ##### ( 1300, 1900 ] 5 16.667% 73.333% ### ( 1900, 2900 ] 2 6.667% 80.000% # ( 2900, 4400 ] 5 16.667% 96.667% ### ( 4400, 6600 ] 1 3.333% 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.52 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.552 H:M:S, 9.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 320.76 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.388 H:M:S, 12.6 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/11/27-11:18:52 ... thread 0: (1000000,3000000) ops and (325982.5,337780.3) ops/second in (3.067649,8.881513) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 9/7 1.48 GB 12.6 1.7 0.0 1.7 4.5 2.8 0.0 1.6 119.9 312.4 14.71 13.73 46 0.320 1791K 2113 0.0 0.0 L1 9/9 1005.06 MB 0.0 1.2 1.2 0.1 1.2 1.2 0.1 1.1 232.6 231.8 5.42 5.25 2 2.711 1280K 4134 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.0 0.1 0.1 0.3 1.8 225.9 225.8 0.49 0.46 1 0.493 113K 35 0.0 0.0 L3 29/0 999.45 MB 1.0 1.2 0.4 0.9 1.2 0.4 0.0 3.5 209.5 209.4 6.05 5.27 4 1.513 1263K 591 0.0 0.0 L4 140/0 9.65 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.1 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1044/0 85.82 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1231/16 98.90 GB 0.0 4.3 1.6 2.7 7.1 4.3 0.5 2.6 165.1 271.1 26.68 24.71 53 0.503 4448K 6873 0.0 0.0 Int 0/0 0.00 KB 0.0 4.3 1.6 2.7 7.1 4.3 0.5 2.6 165.1 271.1 26.68 24.71 53 0.503 4448K 6873 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.3 1.6 2.7 4.3 1.6 0.0 0.0 235.6 235.2 18.69 17.58 13 1.438 4448K 6873 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 2.8 2.8 0.0 0.0 0.0 354.9 7.99 7.13 40 0.200 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 9.1 total, 8.9 interval Flush(GB): cumulative 2.768, interval 2.768 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 7.06 GB write, 796.70 MB/s write, 4.30 GB read, 485.20 MB/s read, 26.7 seconds Interval compaction: 7.06 GB write, 814.14 MB/s write, 4.30 GB read, 495.82 MB/s read, 26.7 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: 791566 Average: 2.3096 StdDev: 9.62 Min: 1 Median: 1.5386 Max: 3272 Percentiles: P50: 1.54 P75: 1.93 P99: 5.79 P99.9: 10.58 P99.99: 15.23 ------------------------------------------------------ [ 0, 1 ] 120792 15.260% 15.260% ### ( 1, 2 ] 510551 64.499% 79.759% ############# ( 2, 3 ] 94284 11.911% 91.670% ## ( 3, 4 ] 34779 4.394% 96.063% # ( 4, 6 ] 26016 3.287% 99.350% # ( 6, 10 ] 4260 0.538% 99.888% ( 10, 15 ] 802 0.101% 99.990% ( 15, 22 ] 87 0.011% 100.001% ( 22, 34 ] 12 0.002% 100.002% ( 34, 51 ] 3 0.000% 100.003% ( 51, 76 ] 10 0.001% 100.004% ( 76, 110 ] 63 0.008% 100.012% ( 110, 170 ] 78 0.010% 100.022% ( 170, 250 ] 55 0.007% 100.029% ( 250, 380 ] 36 0.005% 100.033% ( 380, 580 ] 20 0.003% 100.036% ( 580, 870 ] 14 0.002% 100.037% ( 870, 1300 ] 9 0.001% 100.039% ( 1300, 1900 ] 3 0.000% 100.039% ( 1900, 2900 ] 3 0.000% 100.039% ( 2900, 4400 ] 2 0.000% 100.040% ** Level 1 read latency histogram (micros): Count: 82632 Average: 3.0196 StdDev: 30.43 Min: 1 Median: 1.6428 Max: 5012 Percentiles: P50: 1.64 P75: 2.23 P99: 7.35 P99.9: 122.88 P99.99: 1222.40 ------------------------------------------------------ [ 0, 1 ] 9865 11.938% 11.938% ## ( 1, 2 ] 48926 59.210% 71.148% ############ ( 2, 3 ] 13686 16.563% 87.711% ### ( 3, 4 ] 4694 5.681% 93.391% # ( 4, 6 ] 4377 5.297% 98.688% # ( 6, 10 ] 763 0.923% 99.612% ( 10, 15 ] 133 0.161% 99.772% ( 15, 22 ] 16 0.019% 99.792% ( 22, 34 ] 2 0.002% 99.794% ( 34, 51 ] 34 0.041% 99.835% ( 51, 76 ] 18 0.022% 99.857% ( 76, 110 ] 30 0.036% 99.894% ( 110, 170 ] 25 0.030% 99.924% ( 170, 250 ] 22 0.027% 99.950% ( 250, 380 ] 17 0.021% 99.971% ( 380, 580 ] 7 0.008% 99.979% ( 580, 870 ] 3 0.004% 99.983% ( 870, 1300 ] 7 0.008% 99.992% ( 1300, 1900 ] 3 0.004% 99.995% ( 1900, 2900 ] 1 0.001% 99.996% ( 2900, 4400 ] 2 0.002% 99.999% ( 4400, 6600 ] 1 0.001% 100.000% ** Level 2 read latency histogram (micros): Count: 28281 Average: 2.0409 StdDev: 3.05 Min: 0 Median: 1.4144 Max: 310 Percentiles: P50: 1.41 P75: 1.84 P99: 5.53 P99.9: 9.92 P99.99: 183.75 ------------------------------------------------------ [ 0, 1 ] 7185 25.406% 25.406% ##### ( 1, 2 ] 16783 59.344% 84.749% ############ ( 2, 3 ] 2596 9.179% 93.929% ## ( 3, 4 ] 952 3.366% 97.295% # ( 4, 6 ] 631 2.231% 99.526% ( 6, 10 ] 108 0.382% 99.908% ( 10, 15 ] 19 0.067% 99.975% ( 15, 22 ] 2 0.007% 99.982% ( 51, 76 ] 1 0.004% 99.986% ( 110, 170 ] 1 0.004% 99.989% ( 170, 250 ] 1 0.004% 99.993% ( 250, 380 ] 2 0.007% 100.000% ** Level 3 read latency histogram (micros): Count: 230732 Average: 3.4087 StdDev: 32.42 Min: 1 Median: 1.6267 Max: 4481 Percentiles: P50: 1.63 P75: 2.14 P99: 8.92 P99.9: 229.50 P99.99: 987.70 ------------------------------------------------------ [ 0, 1 ] 27289 11.827% 11.827% ## ( 1, 2 ] 140536 60.909% 72.736% ############ ( 2, 3 ] 36825 15.960% 88.696% ### ( 3, 4 ] 11232 4.868% 93.564% # ( 4, 6 ] 9765 4.232% 97.796% # ( 6, 10 ] 3801 1.647% 99.444% ( 10, 15 ] 427 0.185% 99.629% ( 15, 22 ] 112 0.049% 99.677% ( 22, 34 ] 25 0.011% 99.688% ( 34, 51 ] 6 0.003% 99.691% ( 51, 76 ] 5 0.002% 99.693% ( 76, 110 ] 99 0.043% 99.736% ( 110, 170 ] 293 0.127% 99.863% ( 170, 250 ] 116 0.050% 99.913% ( 250, 380 ] 73 0.032% 99.945% ( 380, 580 ] 71 0.031% 99.975% ( 580, 870 ] 29 0.013% 99.988% ( 870, 1300 ] 18 0.008% 99.996% ( 1300, 1900 ] 15 0.007% 100.002% ( 1900, 2900 ] 7 0.003% 100.005% ( 2900, 4400 ] 6 0.003% 100.008% ( 4400, 6600 ] 1 0.000% 100.008% ** Level 4 read latency histogram (micros): Count: 30 Average: 1542.7667 StdDev: 1239.84 Min: 121 Median: 1177.1429 Max: 4709 Percentiles: P50: 1177.14 P75: 2150.00 P99: 4709.00 P99.9: 4709.00 P99.99: 4709.00 ------------------------------------------------------ ( 110, 170 ] 1 3.333% 3.333% # ( 170, 250 ] 3 10.000% 13.333% ## ( 380, 580 ] 3 10.000% 23.333% ## ( 580, 870 ] 3 10.000% 33.333% ## ( 870, 1300 ] 7 23.333% 56.667% ##### ( 1300, 1900 ] 5 16.667% 73.333% ### ( 1900, 2900 ] 2 6.667% 80.000% # ( 2900, 4400 ] 5 16.667% 96.667% ### ( 4400, 6600 ] 1 3.333% 100.000% # ** DB Stats ** Uptime(secs): 9.1 total, 3.1 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 325.26 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.939 H:M:S, 10.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 320.83 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.6 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/11/27-11:18:55 ... thread 0: (1000000,4000000) ops and (327838.9,335238.8) ops/second in (3.050279,11.931792) 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/11 2.40 GB 75.5 2.3 0.0 2.3 6.0 3.7 0.0 1.6 119.3 312.7 19.54 18.23 61 0.320 2366K 2739 0.0 0.0 L1 9/9 1005.06 MB 0.0 1.2 1.2 0.1 1.2 1.2 0.1 1.1 232.6 231.8 5.42 5.25 2 2.711 1280K 4134 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.0 0.1 0.1 0.3 1.8 225.9 225.8 0.49 0.46 1 0.493 113K 35 0.0 0.0 L3 29/0 999.45 MB 1.0 1.2 0.4 0.9 1.2 0.4 0.0 3.5 209.5 209.4 6.05 5.27 4 1.513 1263K 591 0.0 0.0 L4 140/0 9.65 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.1 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1044/0 85.82 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1238/20 99.82 GB 0.0 4.9 1.6 3.3 8.5 5.3 0.5 2.3 157.8 277.6 31.50 29.21 68 0.463 5023K 7499 0.0 0.0 Int 0/0 0.00 KB 0.0 4.9 1.6 3.3 8.5 5.3 0.5 2.3 157.8 277.6 31.50 29.21 68 0.463 5023K 7499 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.9 1.6 3.3 4.8 1.6 0.0 0.0 238.5 238.1 20.85 19.67 15 1.390 5023K 7499 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 354.8 10.65 9.53 53 0.201 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 12.1 total, 11.9 interval Flush(GB): cumulative 3.691, interval 3.691 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 8.54 GB write, 720.93 MB/s write, 4.85 GB read, 409.92 MB/s read, 31.5 seconds Interval compaction: 8.54 GB write, 732.68 MB/s write, 4.85 GB read, 416.60 MB/s read, 31.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: 13, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 13, interval: 13 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1088129 Average: 2.2739 StdDev: 9.94 Min: 1 Median: 1.5263 Max: 3641 Percentiles: P50: 1.53 P75: 1.91 P99: 5.72 P99.9: 10.27 P99.99: 14.98 ------------------------------------------------------ [ 0, 1 ] 168851 15.518% 15.518% ### ( 1, 2 ] 712964 65.522% 81.040% ############# ( 2, 3 ] 124842 11.473% 92.513% ## ( 3, 4 ] 43926 4.037% 96.549% # ( 4, 6 ] 30930 2.842% 99.392% # ( 6, 10 ] 5473 0.503% 99.895% ( 10, 15 ] 1040 0.096% 99.991% ( 15, 22 ] 98 0.009% 100.000% ( 22, 34 ] 14 0.001% 100.001% ( 34, 51 ] 4 0.000% 100.001% ( 51, 76 ] 13 0.001% 100.002% ( 76, 110 ] 80 0.007% 100.010% ( 110, 170 ] 90 0.008% 100.018% ( 170, 250 ] 61 0.006% 100.024% ( 250, 380 ] 47 0.004% 100.028% ( 380, 580 ] 25 0.002% 100.030% ( 580, 870 ] 18 0.002% 100.032% ( 870, 1300 ] 11 0.001% 100.033% ( 1300, 1900 ] 7 0.001% 100.034% ( 1900, 2900 ] 4 0.000% 100.034% ( 2900, 4400 ] 3 0.000% 100.034% ** Level 1 read latency histogram (micros): Count: 156366 Average: 2.8365 StdDev: 23.88 Min: 1 Median: 1.5774 Max: 5012 Percentiles: P50: 1.58 P75: 1.97 P99: 7.79 P99.9: 150.85 P99.99: 854.62 ------------------------------------------------------ [ 0, 1 ] 20732 13.259% 13.259% ### ( 1, 2 ] 99496 63.630% 76.889% ############# ( 2, 3 ] 21271 13.603% 90.492% ### ( 3, 4 ] 6877 4.398% 94.890% # ( 4, 6 ] 5616 3.592% 98.482% # ( 6, 10 ] 1815 1.161% 99.643% ( 10, 15 ] 214 0.137% 99.779% ( 15, 22 ] 23 0.015% 99.794% ( 22, 34 ] 3 0.002% 99.796% ( 34, 51 ] 34 0.022% 99.818% ( 51, 76 ] 18 0.012% 99.829% ( 76, 110 ] 48 0.031% 99.860% ( 110, 170 ] 92 0.059% 99.919% ( 170, 250 ] 42 0.027% 99.946% ( 250, 380 ] 37 0.024% 99.969% ( 380, 580 ] 21 0.013% 99.983% ( 580, 870 ] 12 0.008% 99.990% ( 870, 1300 ] 8 0.005% 99.996% ( 1300, 1900 ] 3 0.002% 99.997% ( 1900, 2900 ] 1 0.001% 99.998% ( 2900, 4400 ] 2 0.001% 99.999% ( 4400, 6600 ] 1 0.001% 100.000% ** Level 2 read latency histogram (micros): Count: 28281 Average: 2.0409 StdDev: 3.05 Min: 0 Median: 1.4144 Max: 310 Percentiles: P50: 1.41 P75: 1.84 P99: 5.53 P99.9: 9.92 P99.99: 183.75 ------------------------------------------------------ [ 0, 1 ] 7185 25.406% 25.406% ##### ( 1, 2 ] 16783 59.344% 84.749% ############ ( 2, 3 ] 2596 9.179% 93.929% ## ( 3, 4 ] 952 3.366% 97.295% # ( 4, 6 ] 631 2.231% 99.526% ( 6, 10 ] 108 0.382% 99.908% ( 10, 15 ] 19 0.067% 99.975% ( 15, 22 ] 2 0.007% 99.982% ( 51, 76 ] 1 0.004% 99.986% ( 110, 170 ] 1 0.004% 99.989% ( 170, 250 ] 1 0.004% 99.993% ( 250, 380 ] 2 0.007% 100.000% ** Level 3 read latency histogram (micros): Count: 230732 Average: 3.4087 StdDev: 32.42 Min: 1 Median: 1.6267 Max: 4481 Percentiles: P50: 1.63 P75: 2.14 P99: 8.92 P99.9: 229.50 P99.99: 987.70 ------------------------------------------------------ [ 0, 1 ] 27289 11.827% 11.827% ## ( 1, 2 ] 140536 60.909% 72.736% ############ ( 2, 3 ] 36825 15.960% 88.696% ### ( 3, 4 ] 11232 4.868% 93.564% # ( 4, 6 ] 9765 4.232% 97.796% # ( 6, 10 ] 3801 1.647% 99.444% ( 10, 15 ] 427 0.185% 99.629% ( 15, 22 ] 112 0.049% 99.677% ( 22, 34 ] 25 0.011% 99.688% ( 34, 51 ] 6 0.003% 99.691% ( 51, 76 ] 5 0.002% 99.693% ( 76, 110 ] 99 0.043% 99.736% ( 110, 170 ] 293 0.127% 99.863% ( 170, 250 ] 116 0.050% 99.913% ( 250, 380 ] 73 0.032% 99.945% ( 380, 580 ] 71 0.031% 99.975% ( 580, 870 ] 29 0.013% 99.988% ( 870, 1300 ] 18 0.008% 99.996% ( 1300, 1900 ] 15 0.007% 100.002% ( 1900, 2900 ] 7 0.003% 100.005% ( 2900, 4400 ] 6 0.003% 100.008% ( 4400, 6600 ] 1 0.000% 100.008% ** Level 4 read latency histogram (micros): Count: 30 Average: 1542.7667 StdDev: 1239.84 Min: 121 Median: 1177.1429 Max: 4709 Percentiles: P50: 1177.14 P75: 2150.00 P99: 4709.00 P99.9: 4709.00 P99.99: 4709.00 ------------------------------------------------------ ( 110, 170 ] 1 3.333% 3.333% # ( 170, 250 ] 3 10.000% 13.333% ## ( 380, 580 ] 3 10.000% 23.333% ## ( 580, 870 ] 3 10.000% 33.333% ## ( 870, 1300 ] 7 23.333% 56.667% ##### ( 1300, 1900 ] 5 16.667% 73.333% ### ( 1900, 2900 ] 2 6.667% 80.000% # ( 2900, 4400 ] 5 16.667% 96.667% ### ( 4400, 6600 ] 1 3.333% 100.000% # ** DB Stats ** Uptime(secs): 12.1 total, 3.1 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 324.60 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:1.337 H:M:S, 11.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 322.65 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.397 H:M:S, 13.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/27-11:18:58 ... thread 0: (1000000,5000000) ops and (325985.4,333346.4) ops/second in (3.067622,14.999414) 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/11 3.38 GB 182.5 3.4 0.0 3.4 8.1 4.7 0.0 1.7 130.0 309.4 26.66 24.97 79 0.337 3518K 3978 0.0 0.0 L1 9/9 1005.06 MB 0.0 1.2 1.2 0.1 1.2 1.2 0.1 1.1 232.6 231.8 5.42 5.25 2 2.711 1280K 4134 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.0 0.1 0.1 0.3 1.8 225.9 225.8 0.49 0.46 1 0.493 113K 35 0.0 0.0 L3 29/0 999.45 MB 1.0 1.2 0.4 0.9 1.2 0.4 0.0 3.5 209.5 209.4 6.05 5.27 4 1.513 1263K 591 0.0 0.0 L4 140/0 9.65 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.1 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1044/0 85.82 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1240/20 100.80 GB 0.0 6.0 1.6 4.4 10.6 6.2 0.5 2.3 158.1 281.8 38.62 35.94 86 0.449 6175K 8738 0.0 0.0 Int 0/0 0.00 KB 0.0 6.0 1.6 4.4 10.6 6.2 0.5 2.3 158.1 281.8 38.62 35.94 86 0.449 6175K 8738 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 6.0 1.6 4.4 6.0 1.6 0.0 0.0 242.9 242.5 25.14 23.88 19 1.323 6175K 8738 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 354.9 13.49 12.06 67 0.201 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 15.2 total, 15.0 interval Flush(GB): cumulative 4.676, interval 4.676 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 10.63 GB write, 716.26 MB/s write, 5.96 GB read, 401.79 MB/s read, 38.6 seconds Interval compaction: 10.63 GB write, 725.55 MB/s write, 5.96 GB read, 407.00 MB/s read, 38.6 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 1, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 1, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 15, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 1, total-stops: 15, interval: 16 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1430944 Average: 2.2923 StdDev: 10.87 Min: 1 Median: 1.5267 Max: 4353 Percentiles: P50: 1.53 P75: 1.90 P99: 5.73 P99.9: 10.40 P99.99: 19.73 ------------------------------------------------------ [ 0, 1 ] 217369 15.191% 15.191% ### ( 1, 2 ] 945775 66.094% 81.285% ############# ( 2, 3 ] 163374 11.417% 92.702% ## ( 3, 4 ] 56710 3.963% 96.665% # ( 4, 6 ] 38653 2.701% 99.367% # ( 6, 10 ] 7530 0.526% 99.893% ( 10, 15 ] 1304 0.091% 99.984% ( 15, 22 ] 130 0.009% 99.993% ( 22, 34 ] 17 0.001% 99.994% ( 34, 51 ] 6 0.000% 99.995% ( 51, 76 ] 16 0.001% 99.996% ( 76, 110 ] 136 0.010% 100.005% ( 110, 170 ] 140 0.010% 100.015% ( 170, 250 ] 87 0.006% 100.021% ( 250, 380 ] 66 0.005% 100.026% ( 380, 580 ] 39 0.003% 100.029% ( 580, 870 ] 41 0.003% 100.031% ( 870, 1300 ] 15 0.001% 100.032% ( 1300, 1900 ] 12 0.001% 100.033% ( 1900, 2900 ] 6 0.000% 100.034% ( 2900, 4400 ] 4 0.000% 100.034% ** Level 1 read latency histogram (micros): Count: 228946 Average: 2.7742 StdDev: 21.55 Min: 1 Median: 1.5701 Max: 5012 Percentiles: P50: 1.57 P75: 1.95 P99: 7.91 P99.9: 149.22 P99.99: 745.04 ------------------------------------------------------ [ 0, 1 ] 29445 12.861% 12.861% ### ( 1, 2 ] 149151 65.147% 78.008% ############# ( 2, 3 ] 30020 13.112% 91.120% ### ( 3, 4 ] 9387 4.100% 95.220% # ( 4, 6 ] 7277 3.178% 98.399% # ( 6, 10 ] 2880 1.258% 99.657% ( 10, 15 ] 301 0.131% 99.788% ( 15, 22 ] 32 0.014% 99.802% ( 22, 34 ] 4 0.002% 99.804% ( 34, 51 ] 37 0.016% 99.820% ( 51, 76 ] 18 0.008% 99.828% ( 76, 110 ] 68 0.030% 99.858% ( 110, 170 ] 150 0.066% 99.923% ( 170, 250 ] 65 0.028% 99.952% ( 250, 380 ] 48 0.021% 99.972% ( 380, 580 ] 32 0.014% 99.986% ( 580, 870 ] 16 0.007% 99.993% ( 870, 1300 ] 8 0.003% 99.997% ( 1300, 1900 ] 3 0.001% 99.998% ( 1900, 2900 ] 1 0.000% 99.999% ( 2900, 4400 ] 3 0.001% 100.000% ( 4400, 6600 ] 1 0.000% 100.000% ** Level 2 read latency histogram (micros): Count: 28281 Average: 2.0409 StdDev: 3.05 Min: 0 Median: 1.4144 Max: 310 Percentiles: P50: 1.41 P75: 1.84 P99: 5.53 P99.9: 9.92 P99.99: 183.75 ------------------------------------------------------ [ 0, 1 ] 7185 25.406% 25.406% ##### ( 1, 2 ] 16783 59.344% 84.749% ############ ( 2, 3 ] 2596 9.179% 93.929% ## ( 3, 4 ] 952 3.366% 97.295% # ( 4, 6 ] 631 2.231% 99.526% ( 6, 10 ] 108 0.382% 99.908% ( 10, 15 ] 19 0.067% 99.975% ( 15, 22 ] 2 0.007% 99.982% ( 51, 76 ] 1 0.004% 99.986% ( 110, 170 ] 1 0.004% 99.989% ( 170, 250 ] 1 0.004% 99.993% ( 250, 380 ] 2 0.007% 100.000% ** Level 3 read latency histogram (micros): Count: 230732 Average: 3.4087 StdDev: 32.42 Min: 1 Median: 1.6267 Max: 4481 Percentiles: P50: 1.63 P75: 2.14 P99: 8.92 P99.9: 229.50 P99.99: 987.70 ------------------------------------------------------ [ 0, 1 ] 27289 11.827% 11.827% ## ( 1, 2 ] 140536 60.909% 72.736% ############ ( 2, 3 ] 36825 15.960% 88.696% ### ( 3, 4 ] 11232 4.868% 93.564% # ( 4, 6 ] 9765 4.232% 97.796% # ( 6, 10 ] 3801 1.647% 99.444% ( 10, 15 ] 427 0.185% 99.629% ( 15, 22 ] 112 0.049% 99.677% ( 22, 34 ] 25 0.011% 99.688% ( 34, 51 ] 6 0.003% 99.691% ( 51, 76 ] 5 0.002% 99.693% ( 76, 110 ] 99 0.043% 99.736% ( 110, 170 ] 293 0.127% 99.863% ( 170, 250 ] 116 0.050% 99.913% ( 250, 380 ] 73 0.032% 99.945% ( 380, 580 ] 71 0.031% 99.975% ( 580, 870 ] 29 0.013% 99.988% ( 870, 1300 ] 18 0.008% 99.996% ( 1300, 1900 ] 15 0.007% 100.002% ( 1900, 2900 ] 7 0.003% 100.005% ( 2900, 4400 ] 6 0.003% 100.008% ( 4400, 6600 ] 1 0.000% 100.008% ** Level 4 read latency histogram (micros): Count: 30 Average: 1542.7667 StdDev: 1239.84 Min: 121 Median: 1177.1429 Max: 4709 Percentiles: P50: 1177.14 P75: 2150.00 P99: 4709.00 P99.9: 4709.00 P99.99: 4709.00 ------------------------------------------------------ ( 110, 170 ] 1 3.333% 3.333% # ( 170, 250 ] 3 10.000% 13.333% ## ( 380, 580 ] 3 10.000% 23.333% ## ( 580, 870 ] 3 10.000% 33.333% ## ( 870, 1300 ] 7 23.333% 56.667% ##### ( 1300, 1900 ] 5 16.667% 73.333% ### ( 1900, 2900 ] 2 6.667% 80.000% # ( 2900, 4400 ] 5 16.667% 96.667% ### ( 4400, 6600 ] 1 3.333% 100.000% # ** DB Stats ** Uptime(secs): 15.2 total, 3.1 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 323.84 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:1.735 H:M:S, 11.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 320.83 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.399 H:M:S, 13.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/27-11:19:03 ... thread 0: (1000000,6000000) ops and (193615.8,297555.9) ops/second in (5.164867,20.164281) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 17/9 2.95 GB 182.5 4.1 0.0 4.1 9.8 5.7 0.0 1.7 130.5 309.6 32.34 30.27 98 0.330 4285K 4740 0.0 0.0 L1 16/0 1.42 GB 145.2 3.6 2.5 1.0 3.5 2.5 0.1 1.4 228.1 226.5 16.00 15.35 3 5.334 3707K 26K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.0 0.1 0.1 1.2 1.8 225.9 225.8 0.49 0.46 1 0.493 113K 35 0.0 0.0 L3 14/0 974.65 MB 1.0 1.2 0.4 0.9 1.2 0.4 0.9 3.5 209.5 209.4 6.05 5.27 4 1.513 1263K 591 0.0 0.0 L4 174/0 9.58 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.9 1.0 156.7 156.6 1.06 0.83 2 0.530 163K 112 0.0 0.0 L5 1056/0 86.80 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 1277/9 101.70 GB 0.0 9.2 3.1 6.1 14.8 8.7 4.1 2.6 168.3 271.4 55.94 52.18 108 0.518 9533K 31K 0.0 0.0 Int 0/0 0.00 KB 0.0 9.2 3.1 6.1 14.8 8.7 4.1 2.6 168.3 271.4 55.94 52.18 108 0.518 9533K 31K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 9.2 3.1 6.1 9.2 3.1 0.0 0.0 238.0 237.2 39.57 37.56 25 1.583 9533K 31K 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 353.9 16.38 14.62 83 0.197 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 20.4 total, 20.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: 14.82 GB write, 745.59 MB/s write, 9.20 GB read, 462.52 MB/s read, 55.9 seconds Interval compaction: 14.82 GB write, 752.78 MB/s write, 9.20 GB read, 466.98 MB/s read, 55.9 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 9, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 9, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 15, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 9, total-stops: 15, interval: 24 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1916085 Average: 2.2742 StdDev: 10.47 Min: 1 Median: 1.5136 Max: 4353 Percentiles: P50: 1.51 P75: 1.89 P99: 5.72 P99.9: 10.71 P99.99: 91.85 ------------------------------------------------------ [ 0, 1 ] 303791 15.855% 15.855% ### ( 1, 2 ] 1273788 66.479% 82.333% ############# ( 2, 3 ] 207090 10.808% 93.141% ## ( 3, 4 ] 71562 3.735% 96.876% # ( 4, 6 ] 47194 2.463% 99.339% ( 6, 10 ] 10510 0.549% 99.888% ( 10, 15 ] 1655 0.086% 99.974% ( 15, 22 ] 174 0.009% 99.983% ( 22, 34 ] 20 0.001% 99.984% ( 34, 51 ] 8 0.000% 99.985% ( 51, 76 ] 18 0.001% 99.986% ( 76, 110 ] 181 0.009% 99.995% ( 110, 170 ] 272 0.014% 100.009% ( 170, 250 ] 128 0.007% 100.016% ( 250, 380 ] 90 0.005% 100.021% ( 380, 580 ] 60 0.003% 100.024% ( 580, 870 ] 60 0.003% 100.027% ( 870, 1300 ] 20 0.001% 100.028% ( 1300, 1900 ] 13 0.001% 100.029% ( 1900, 2900 ] 8 0.000% 100.029% ( 2900, 4400 ] 4 0.000% 100.029% ** Level 1 read latency histogram (micros): Count: 340834 Average: 2.7702 StdDev: 21.43 Min: 0 Median: 1.5454 Max: 5012 Percentiles: P50: 1.55 P75: 1.93 P99: 7.83 P99.9: 155.98 P99.99: 750.96 ------------------------------------------------------ [ 0, 1 ] 48052 14.098% 14.098% ### ( 1, 2 ] 224361 65.827% 79.925% ############# ( 2, 3 ] 40720 11.947% 91.873% ## ( 3, 4 ] 12824 3.763% 95.635% # ( 4, 6 ] 9614 2.821% 98.456% # ( 6, 10 ] 4055 1.190% 99.646% ( 10, 15 ] 397 0.116% 99.762% ( 15, 22 ] 49 0.014% 99.776% ( 22, 34 ] 5 0.001% 99.778% ( 34, 51 ] 37 0.011% 99.789% ( 51, 76 ] 30 0.009% 99.798% ( 76, 110 ] 153 0.045% 99.842% ( 110, 170 ] 256 0.075% 99.918% ( 170, 250 ] 92 0.027% 99.945% ( 250, 380 ] 79 0.023% 99.968% ( 380, 580 ] 60 0.018% 99.985% ( 580, 870 ] 27 0.008% 99.993% ( 870, 1300 ] 11 0.003% 99.996% ( 1300, 1900 ] 5 0.001% 99.998% ( 1900, 2900 ] 1 0.000% 99.998% ( 2900, 4400 ] 5 0.001% 100.000% ( 4400, 6600 ] 1 0.000% 100.000% ** Level 2 read latency histogram (micros): Count: 28281 Average: 2.0409 StdDev: 3.05 Min: 0 Median: 1.4144 Max: 310 Percentiles: P50: 1.41 P75: 1.84 P99: 5.53 P99.9: 9.92 P99.99: 183.75 ------------------------------------------------------ [ 0, 1 ] 7185 25.406% 25.406% ##### ( 1, 2 ] 16783 59.344% 84.749% ############ ( 2, 3 ] 2596 9.179% 93.929% ## ( 3, 4 ] 952 3.366% 97.295% # ( 4, 6 ] 631 2.231% 99.526% ( 6, 10 ] 108 0.382% 99.908% ( 10, 15 ] 19 0.067% 99.975% ( 15, 22 ] 2 0.007% 99.982% ( 51, 76 ] 1 0.004% 99.986% ( 110, 170 ] 1 0.004% 99.989% ( 170, 250 ] 1 0.004% 99.993% ( 250, 380 ] 2 0.007% 100.000% ** Level 3 read latency histogram (micros): Count: 263621 Average: 3.4782 StdDev: 31.24 Min: 1 Median: 1.6509 Max: 4481 Percentiles: P50: 1.65 P75: 2.23 P99: 9.07 P99.9: 245.24 P99.99: 969.71 ------------------------------------------------------ [ 0, 1 ] 28355 10.756% 10.756% ## ( 1, 2 ] 158951 60.295% 71.051% ############ ( 2, 3 ] 45379 17.214% 88.265% ### ( 3, 4 ] 13236 5.021% 93.286% # ( 4, 6 ] 11611 4.404% 97.690% # ( 6, 10 ] 4500 1.707% 99.397% ( 10, 15 ] 523 0.198% 99.596% ( 15, 22 ] 128 0.049% 99.644% ( 22, 34 ] 25 0.009% 99.654% ( 34, 51 ] 6 0.002% 99.656% ( 51, 76 ] 5 0.002% 99.658% ( 76, 110 ] 158 0.060% 99.718% ( 110, 170 ] 344 0.130% 99.848% ( 170, 250 ] 145 0.055% 99.903% ( 250, 380 ] 96 0.036% 99.940% ( 380, 580 ] 94 0.036% 99.975% ( 580, 870 ] 34 0.013% 99.988% ( 870, 1300 ] 20 0.008% 99.996% ( 1300, 1900 ] 15 0.006% 100.002% ( 1900, 2900 ] 7 0.003% 100.004% ( 2900, 4400 ] 6 0.002% 100.006% ( 4400, 6600 ] 1 0.000% 100.007% ** Level 4 read latency histogram (micros): Count: 165 Average: 301.7030 StdDev: 797.17 Min: 1 Median: 2.1389 Max: 4709 Percentiles: P50: 2.14 P75: 16.75 P99: 4205.00 P99.9: 4709.00 P99.99: 4709.00 ------------------------------------------------------ [ 0, 1 ] 39 23.636% 23.636% ##### ( 1, 2 ] 41 24.848% 48.485% ##### ( 2, 3 ] 18 10.909% 59.394% ## ( 3, 4 ] 3 1.818% 61.212% ( 4, 6 ] 1 0.606% 61.818% ( 6, 10 ] 5 3.030% 64.848% # ( 10, 15 ] 15 9.091% 73.939% ## ( 15, 22 ] 7 4.242% 78.182% # ( 110, 170 ] 4 2.424% 80.606% ( 170, 250 ] 3 1.818% 82.424% ( 380, 580 ] 4 2.424% 84.848% ( 580, 870 ] 3 1.818% 86.667% ( 870, 1300 ] 9 5.455% 92.121% # ( 1300, 1900 ] 5 3.030% 95.152% # ( 1900, 2900 ] 2 1.212% 96.364% ( 2900, 4400 ] 5 3.030% 99.394% # ( 4400, 6600 ] 1 0.606% 100.000% ** Level 5 read latency histogram (micros): Count: 60 Average: 780.1167 StdDev: 991.92 Min: 78 Median: 264.4444 Max: 3465 Percentiles: P50: 264.44 P75: 977.50 P99: 3465.00 P99.9: 3465.00 P99.99: 3465.00 ------------------------------------------------------ ( 76, 110 ] 7 11.667% 11.667% ## ( 110, 170 ] 9 15.000% 26.667% ### ( 170, 250 ] 13 21.667% 48.333% #### ( 250, 380 ] 9 15.000% 63.333% ### ( 380, 580 ] 2 3.333% 66.667% # ( 580, 870 ] 4 6.667% 73.333% # ( 870, 1300 ] 4 6.667% 80.000% # ( 1300, 1900 ] 2 3.333% 83.333% # ( 1900, 2900 ] 6 10.000% 93.333% ## ( 2900, 4400 ] 4 6.667% 100.000% # ** DB Stats ** Uptime(secs): 20.4 total, 5.2 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 290.03 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:4.116 H:M:S, 20.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 190.56 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.381 H:M:S, 46.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/27-11:19:06 ... thread 0: (1000000,7000000) ops and (321927.5,300809.1) ops/second in (3.106289,23.270570) 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/15 3.99 GB 6.3 6.0 0.0 6.0 12.7 6.6 0.0 1.9 145.1 304.7 42.56 40.05 117 0.364 6267K 9283 0.0 0.0 L1 16/16 1.42 GB 0.0 3.6 2.5 1.0 3.5 2.5 0.1 1.4 228.1 226.5 16.00 15.35 3 5.334 3707K 26K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.0 0.1 0.1 1.2 1.8 225.9 225.8 0.49 0.46 1 0.493 113K 35 0.0 0.0 L3 14/0 974.65 MB 1.0 1.2 0.4 0.9 1.2 0.4 0.9 3.5 209.5 209.4 6.05 5.27 4 1.513 1263K 591 0.0 0.0 L4 174/0 9.58 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.9 1.0 156.7 156.6 1.06 0.83 2 0.530 163K 112 0.0 0.0 L5 1056/0 86.80 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 1276/31 102.74 GB 0.0 11.1 3.1 8.0 17.7 9.7 4.1 2.7 171.8 274.1 66.16 61.95 127 0.521 11M 36K 0.0 0.0 Int 0/0 0.00 KB 0.0 11.1 3.1 8.0 17.7 9.7 4.1 2.7 171.8 274.1 66.16 61.95 127 0.521 11M 36K 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 11.1 3.1 8.0 11.1 3.1 0.0 0.0 242.0 241.3 46.97 44.84 30 1.566 11M 36K 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 354.5 19.19 17.12 97 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): 23.5 total, 23.3 interval Flush(GB): cumulative 6.644, interval 6.644 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 17.71 GB write, 772.84 MB/s write, 11.10 GB read, 484.48 MB/s read, 66.2 seconds Interval compaction: 17.71 GB write, 779.30 MB/s write, 11.10 GB read, 488.53 MB/s read, 66.2 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 10, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 10, 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: 10, total-stops: 17, interval: 27 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2253034 Average: 2.2497 StdDev: 10.43 Min: 0 Median: 1.5024 Max: 4353 Percentiles: P50: 1.50 P75: 1.88 P99: 5.69 P99.9: 10.49 P99.99: 89.04 ------------------------------------------------------ [ 0, 1 ] 376156 16.696% 16.696% ### ( 1, 2 ] 1493472 66.287% 82.983% ############# ( 2, 3 ] 236031 10.476% 93.459% ## ( 3, 4 ] 80429 3.570% 97.029% # ( 4, 6 ] 52494 2.330% 99.359% ( 6, 10 ] 12015 0.533% 99.892% ( 10, 15 ] 1873 0.083% 99.975% ( 15, 22 ] 204 0.009% 99.984% ( 22, 34 ] 24 0.001% 99.985% ( 34, 51 ] 10 0.000% 99.986% ( 51, 76 ] 19 0.001% 99.986% ( 76, 110 ] 213 0.009% 99.996% ( 110, 170 ] 296 0.013% 100.009% ( 170, 250 ] 155 0.007% 100.016% ( 250, 380 ] 105 0.005% 100.021% ( 380, 580 ] 62 0.003% 100.023% ( 580, 870 ] 67 0.003% 100.026% ( 870, 1300 ] 23 0.001% 100.027% ( 1300, 1900 ] 14 0.001% 100.028% ( 1900, 2900 ] 10 0.000% 100.028% ( 2900, 4400 ] 5 0.000% 100.029% ** Level 1 read latency histogram (micros): Count: 340835 Average: 2.7710 StdDev: 21.43 Min: 0 Median: 1.5454 Max: 5012 Percentiles: P50: 1.55 P75: 1.93 P99: 7.83 P99.9: 156.21 P99.99: 750.95 ------------------------------------------------------ [ 0, 1 ] 48052 14.098% 14.098% ### ( 1, 2 ] 224361 65.827% 79.925% ############# ( 2, 3 ] 40720 11.947% 91.872% ## ( 3, 4 ] 12824 3.763% 95.635% # ( 4, 6 ] 9614 2.821% 98.456% # ( 6, 10 ] 4055 1.190% 99.645% ( 10, 15 ] 397 0.116% 99.762% ( 15, 22 ] 49 0.014% 99.776% ( 22, 34 ] 5 0.001% 99.778% ( 34, 51 ] 37 0.011% 99.788% ( 51, 76 ] 30 0.009% 99.797% ( 76, 110 ] 153 0.045% 99.842% ( 110, 170 ] 256 0.075% 99.917% ( 170, 250 ] 92 0.027% 99.944% ( 250, 380 ] 80 0.023% 99.968% ( 380, 580 ] 60 0.018% 99.985% ( 580, 870 ] 27 0.008% 99.993% ( 870, 1300 ] 11 0.003% 99.996% ( 1300, 1900 ] 5 0.001% 99.998% ( 1900, 2900 ] 1 0.000% 99.998% ( 2900, 4400 ] 5 0.001% 100.000% ( 4400, 6600 ] 1 0.000% 100.000% ** Level 2 read latency histogram (micros): Count: 28281 Average: 2.0409 StdDev: 3.05 Min: 0 Median: 1.4144 Max: 310 Percentiles: P50: 1.41 P75: 1.84 P99: 5.53 P99.9: 9.92 P99.99: 183.75 ------------------------------------------------------ [ 0, 1 ] 7185 25.406% 25.406% ##### ( 1, 2 ] 16783 59.344% 84.749% ############ ( 2, 3 ] 2596 9.179% 93.929% ## ( 3, 4 ] 952 3.366% 97.295% # ( 4, 6 ] 631 2.231% 99.526% ( 6, 10 ] 108 0.382% 99.908% ( 10, 15 ] 19 0.067% 99.975% ( 15, 22 ] 2 0.007% 99.982% ( 51, 76 ] 1 0.004% 99.986% ( 110, 170 ] 1 0.004% 99.989% ( 170, 250 ] 1 0.004% 99.993% ( 250, 380 ] 2 0.007% 100.000% ** Level 3 read latency histogram (micros): Count: 263621 Average: 3.4782 StdDev: 31.24 Min: 1 Median: 1.6509 Max: 4481 Percentiles: P50: 1.65 P75: 2.23 P99: 9.07 P99.9: 245.24 P99.99: 969.71 ------------------------------------------------------ [ 0, 1 ] 28355 10.756% 10.756% ## ( 1, 2 ] 158951 60.295% 71.051% ############ ( 2, 3 ] 45379 17.214% 88.265% ### ( 3, 4 ] 13236 5.021% 93.286% # ( 4, 6 ] 11611 4.404% 97.690% # ( 6, 10 ] 4500 1.707% 99.397% ( 10, 15 ] 523 0.198% 99.596% ( 15, 22 ] 128 0.049% 99.644% ( 22, 34 ] 25 0.009% 99.654% ( 34, 51 ] 6 0.002% 99.656% ( 51, 76 ] 5 0.002% 99.658% ( 76, 110 ] 158 0.060% 99.718% ( 110, 170 ] 344 0.130% 99.848% ( 170, 250 ] 145 0.055% 99.903% ( 250, 380 ] 96 0.036% 99.940% ( 380, 580 ] 94 0.036% 99.975% ( 580, 870 ] 34 0.013% 99.988% ( 870, 1300 ] 20 0.008% 99.996% ( 1300, 1900 ] 15 0.006% 100.002% ( 1900, 2900 ] 7 0.003% 100.004% ( 2900, 4400 ] 6 0.002% 100.006% ( 4400, 6600 ] 1 0.000% 100.007% ** Level 4 read latency histogram (micros): Count: 165 Average: 301.7030 StdDev: 797.17 Min: 1 Median: 2.1389 Max: 4709 Percentiles: P50: 2.14 P75: 16.75 P99: 4205.00 P99.9: 4709.00 P99.99: 4709.00 ------------------------------------------------------ [ 0, 1 ] 39 23.636% 23.636% ##### ( 1, 2 ] 41 24.848% 48.485% ##### ( 2, 3 ] 18 10.909% 59.394% ## ( 3, 4 ] 3 1.818% 61.212% ( 4, 6 ] 1 0.606% 61.818% ( 6, 10 ] 5 3.030% 64.848% # ( 10, 15 ] 15 9.091% 73.939% ## ( 15, 22 ] 7 4.242% 78.182% # ( 110, 170 ] 4 2.424% 80.606% ( 170, 250 ] 3 1.818% 82.424% ( 380, 580 ] 4 2.424% 84.848% ( 580, 870 ] 3 1.818% 86.667% ( 870, 1300 ] 9 5.455% 92.121% # ( 1300, 1900 ] 5 3.030% 95.152% # ( 1900, 2900 ] 2 1.212% 96.364% ( 2900, 4400 ] 5 3.030% 99.394% # ( 4400, 6600 ] 1 0.606% 100.000% ** Level 5 read latency histogram (micros): Count: 60 Average: 780.1167 StdDev: 991.92 Min: 78 Median: 264.4444 Max: 3465 Percentiles: P50: 264.44 P75: 977.50 P99: 3465.00 P99.9: 3465.00 P99.99: 3465.00 ------------------------------------------------------ ( 76, 110 ] 7 11.667% 11.667% ## ( 110, 170 ] 9 15.000% 26.667% ### ( 170, 250 ] 13 21.667% 48.333% #### ( 250, 380 ] 9 15.000% 63.333% ### ( 380, 580 ] 2 3.333% 66.667% # ( 580, 870 ] 4 6.667% 73.333% # ( 870, 1300 ] 4 6.667% 80.000% # ( 1300, 1900 ] 2 3.333% 83.333% # ( 1900, 2900 ] 6 10.000% 93.333% ## ( 2900, 4400 ] 4 6.667% 100.000% # ** DB Stats ** Uptime(secs): 23.5 total, 3.1 interval Cumulative writes: 0 writes, 7000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 6.73 GB, 293.58 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:4.574 H:M:S, 19.5 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 316.84 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.458 H:M:S, 14.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/11/27-11:19:35 ... thread 0: (1000000,8000000) ops and (34140.1,152202.3) ops/second in (29.291052,52.561622) 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 1007.26 MB 25.2 6.6 0.0 6.6 14.1 7.6 0.0 1.9 137.4 295.2 49.05 44.60 132 0.372 6843K 9884 0.0 0.0 L1 7/7 569.52 MB 0.0 8.9 6.5 2.5 8.8 6.3 0.1 1.4 214.9 211.2 42.46 38.49 4 10.616 9047K 26K 0.0 0.0 L2 12/10 1.26 GB 2.1 0.1 0.1 0.0 0.1 0.1 5.8 1.8 225.9 225.8 0.49 0.46 1 0.493 113K 35 0.0 0.0 L3 37/9 3.79 GB 2.8 1.6 0.6 1.0 1.6 0.6 4.0 2.6 170.7 170.1 9.71 7.10 6 1.618 1658K 5249 0.0 0.0 L4 180/6 10.14 GB 1.0 0.7 0.6 0.0 0.7 0.6 0.9 1.1 108.9 108.7 6.47 3.45 6 1.078 702K 1425 0.0 0.0 L5 1056/0 86.80 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 1300/37 103.53 GB 0.0 17.9 7.8 10.1 25.3 15.2 11.9 3.3 169.5 239.5 108.18 94.11 149 0.726 18M 42K 0.0 0.0 Int 0/0 0.00 KB 0.0 17.9 7.8 10.1 25.3 15.2 11.9 3.3 169.5 239.5 108.18 94.11 149 0.726 18M 42K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 17.9 7.8 10.1 17.7 7.6 0.0 0.0 216.7 214.6 84.63 74.52 39 2.170 18M 42K 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 329.0 23.55 19.58 110 0.214 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 52.8 total, 52.6 interval Flush(GB): cumulative 7.567, interval 7.567 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 25.30 GB write, 491.15 MB/s write, 17.91 GB read, 347.62 MB/s read, 108.2 seconds Interval compaction: 25.30 GB write, 492.97 MB/s write, 17.91 GB read, 348.90 MB/s read, 108.2 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 15, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 15, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 28, pending-compaction-bytes-delays: 8, pending-compaction-bytes-stops: 0, total-delays: 23, total-stops: 28, interval: 51 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3486900 Average: 2.9920 StdDev: 25.13 Min: 0 Median: 1.4477 Max: 9363 Percentiles: P50: 1.45 P75: 1.84 P99: 7.49 P99.9: 161.01 P99.99: 419.98 ------------------------------------------------------ [ 0, 1 ] 746058 21.396% 21.396% #### ( 1, 2 ] 2227981 63.896% 85.292% ############# ( 2, 3 ] 291269 8.353% 93.645% ## ( 3, 4 ] 105052 3.013% 96.658% # ( 4, 6 ] 74991 2.151% 98.808% ( 6, 10 ] 17905 0.513% 99.322% ( 10, 15 ] 3275 0.094% 99.416% ( 15, 22 ] 551 0.016% 99.432% ( 22, 34 ] 36 0.001% 99.433% ( 34, 51 ] 14 0.000% 99.433% ( 51, 76 ] 268 0.008% 99.441% ( 76, 110 ] 9924 0.285% 99.725% ( 110, 170 ] 7163 0.205% 99.931% ( 170, 250 ] 1086 0.031% 99.962% ( 250, 380 ] 835 0.024% 99.986% ( 380, 580 ] 722 0.021% 100.007% ( 580, 870 ] 301 0.009% 100.015% ( 870, 1300 ] 59 0.002% 100.017% ( 1300, 1900 ] 33 0.001% 100.018% ( 1900, 2900 ] 38 0.001% 100.019% ( 2900, 4400 ] 30 0.001% 100.020% ( 4400, 6600 ] 11 0.000% 100.020% ( 6600, 9900 ] 7 0.000% 100.020% ** Level 1 read latency histogram (micros): Count: 1351351 Average: 4.6137 StdDev: 73.84 Min: 0 Median: 1.6244 Max: 11338 Percentiles: P50: 1.62 P75: 2.28 P99: 9.07 P99.9: 122.49 P99.99: 165.57 ------------------------------------------------------ [ 0, 1 ] 202761 15.004% 15.004% ### ( 1, 2 ] 757402 56.048% 71.052% ########### ( 2, 3 ] 193605 14.327% 85.379% ### ( 3, 4 ] 84626 6.262% 91.641% # ( 4, 6 ] 81556 6.035% 97.676% # ( 6, 10 ] 23276 1.722% 99.399% ( 10, 15 ] 3515 0.260% 99.659% ( 15, 22 ] 535 0.040% 99.698% ( 22, 34 ] 43 0.003% 99.702% ( 34, 51 ] 44 0.003% 99.705% ( 51, 76 ] 181 0.013% 99.718% ( 76, 110 ] 2106 0.156% 99.874% ( 110, 170 ] 1694 0.125% 99.999% ( 170, 250 ] 421 0.031% 100.031% ( 250, 380 ] 426 0.032% 100.062% ( 380, 580 ] 488 0.036% 100.098% ( 580, 870 ] 414 0.031% 100.129% ( 870, 1300 ] 193 0.014% 100.143% ( 1300, 1900 ] 116 0.009% 100.152% ( 1900, 2900 ] 101 0.007% 100.159% ( 2900, 4400 ] 163 0.012% 100.171% ( 4400, 6600 ] 48 0.004% 100.175% ( 6600, 9900 ] 41 0.003% 100.178% ( 9900, 14000 ] 1 0.000% 100.178% ** Level 2 read latency histogram (micros): Count: 28281 Average: 2.0409 StdDev: 3.05 Min: 0 Median: 1.4144 Max: 310 Percentiles: P50: 1.41 P75: 1.84 P99: 5.53 P99.9: 9.92 P99.99: 183.75 ------------------------------------------------------ [ 0, 1 ] 7185 25.406% 25.406% ##### ( 1, 2 ] 16783 59.344% 84.749% ############ ( 2, 3 ] 2596 9.179% 93.929% ## ( 3, 4 ] 952 3.366% 97.295% # ( 4, 6 ] 631 2.231% 99.526% ( 6, 10 ] 108 0.382% 99.908% ( 10, 15 ] 19 0.067% 99.975% ( 15, 22 ] 2 0.007% 99.982% ( 51, 76 ] 1 0.004% 99.986% ( 110, 170 ] 1 0.004% 99.989% ( 170, 250 ] 1 0.004% 99.993% ( 250, 380 ] 2 0.007% 100.000% ** Level 3 read latency histogram (micros): Count: 266166 Average: 3.9357 StdDev: 43.50 Min: 1 Median: 1.6551 Max: 6733 Percentiles: P50: 1.66 P75: 2.25 P99: 9.21 P99.9: 366.13 P99.99: 1494.14 ------------------------------------------------------ [ 0, 1 ] 28386 10.665% 10.665% ## ( 1, 2 ] 159820 60.045% 70.710% ############ ( 2, 3 ] 46005 17.284% 87.994% ### ( 3, 4 ] 13627 5.120% 93.114% # ( 4, 6 ] 11940 4.486% 97.600% # ( 6, 10 ] 4645 1.745% 99.345% ( 10, 15 ] 543 0.204% 99.549% ( 15, 22 ] 130 0.049% 99.598% ( 22, 34 ] 25 0.009% 99.607% ( 34, 51 ] 6 0.002% 99.610% ( 51, 76 ] 5 0.002% 99.612% ( 76, 110 ] 159 0.060% 99.671% ( 110, 170 ] 349 0.131% 99.802% ( 170, 250 ] 159 0.060% 99.862% ( 250, 380 ] 114 0.043% 99.905% ( 380, 580 ] 124 0.047% 99.952% ( 580, 870 ] 56 0.021% 99.973% ( 870, 1300 ] 38 0.014% 99.987% ( 1300, 1900 ] 29 0.011% 99.998% ( 1900, 2900 ] 13 0.005% 100.003% ( 2900, 4400 ] 11 0.004% 100.007% ( 4400, 6600 ] 2 0.001% 100.008% ( 6600, 9900 ] 1 0.000% 100.008% ** Level 4 read latency histogram (micros): Count: 11912 Average: 55.2989 StdDev: 286.03 Min: 1 Median: 2.0313 Max: 7760 Percentiles: P50: 2.03 P75: 3.41 P99: 1287.34 P99.9: 3828.15 P99.99: 5289.68 ------------------------------------------------------ [ 0, 1 ] 374 3.140% 3.140% # ( 1, 2 ] 5503 46.197% 49.337% ######### ( 2, 3 ] 2522 21.172% 70.509% #### ( 3, 4 ] 1316 11.048% 81.556% ## ( 4, 6 ] 954 8.009% 89.565% ## ( 6, 10 ] 383 3.215% 92.780% # ( 10, 15 ] 77 0.646% 93.427% ( 15, 22 ] 21 0.176% 93.603% ( 22, 34 ] 4 0.034% 93.637% ( 76, 110 ] 3 0.025% 93.662% ( 110, 170 ] 35 0.294% 93.956% ( 170, 250 ] 78 0.655% 94.610% ( 250, 380 ] 103 0.865% 95.475% ( 380, 580 ] 149 1.251% 96.726% ( 580, 870 ] 168 1.410% 98.136% ( 870, 1300 ] 106 0.890% 99.026% ( 1300, 1900 ] 61 0.512% 99.538% ( 1900, 2900 ] 27 0.227% 99.765% ( 2900, 4400 ] 26 0.218% 99.983% ( 4400, 6600 ] 2 0.017% 100.000% ( 6600, 9900 ] 1 0.008% 100.008% ** Level 5 read latency histogram (micros): Count: 60 Average: 780.1167 StdDev: 991.92 Min: 78 Median: 264.4444 Max: 3465 Percentiles: P50: 264.44 P75: 977.50 P99: 3465.00 P99.9: 3465.00 P99.99: 3465.00 ------------------------------------------------------ ( 76, 110 ] 7 11.667% 11.667% ## ( 110, 170 ] 9 15.000% 26.667% ### ( 170, 250 ] 13 21.667% 48.333% #### ( 250, 380 ] 9 15.000% 63.333% ### ( 380, 580 ] 2 3.333% 66.667% # ( 580, 870 ] 4 6.667% 73.333% # ( 870, 1300 ] 4 6.667% 80.000% # ( 1300, 1900 ] 2 3.333% 83.333% # ( 1900, 2900 ] 6 10.000% 93.333% ## ( 2900, 4400 ] 4 6.667% 100.000% # ** DB Stats ** Uptime(secs): 52.8 total, 29.3 interval Cumulative writes: 0 writes, 8000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 7.69 GB, 149.24 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:30.408 H:M:S, 57.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 33.60 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:25.833 H:M:S, 88.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 10 num-running-flushes: 1 2024/11/27-11:19:41 ... thread 0: (1000000,9000000) ops and (161428.7,153175.0) ops/second in (6.194685,58.756307) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 13/9 1.97 GB 94.4 7.3 0.0 7.3 15.9 8.5 0.0 1.9 127.8 276.8 58.67 50.40 145 0.405 7611K 10K 0.0 0.0 L1 7/7 569.52 MB 0.0 8.9 6.5 2.5 8.8 6.3 0.1 1.4 214.9 211.2 42.46 38.49 4 10.616 9047K 26K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.0 0.1 0.1 5.8 1.8 225.9 225.8 0.49 0.46 1 0.493 113K 35 0.0 0.0 L3 13/1 1.01 GB 0.9 3.6 1.9 1.7 3.6 1.8 4.0 1.9 136.6 135.2 27.24 16.59 12 2.270 3754K 36K 0.0 0.0 L4 166/3 9.52 GB 1.0 5.2 4.6 0.5 5.1 4.6 1.0 1.1 118.9 118.5 44.37 25.00 43 1.032 5062K 14K 0.0 0.0 L5 1112/0 91.41 GB 0.9 0.0 0.0 0.0 0.0 0.0 5.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1311/20 104.47 GB 0.0 25.1 13.0 12.1 33.5 21.3 16.6 3.9 148.5 197.8 173.24 130.94 205 0.845 25M 88K 0.0 0.0 Int 0/0 0.00 KB 0.0 25.1 13.0 12.1 33.5 21.3 16.6 3.9 148.5 197.8 173.24 130.94 205 0.845 25M 88K 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 25.1 13.0 12.1 24.9 12.8 0.0 0.0 178.7 177.2 143.98 108.61 84 1.714 25M 88K 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 299.3 29.26 22.33 121 0.242 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): 59.0 total, 58.8 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: 33.46 GB write, 581.19 MB/s write, 25.13 GB read, 436.43 MB/s read, 173.2 seconds Interval compaction: 33.46 GB write, 583.12 MB/s write, 25.13 GB read, 437.88 MB/s read, 173.2 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 15, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 15, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 71, pending-compaction-bytes-delays: 8, pending-compaction-bytes-stops: 0, total-delays: 23, total-stops: 71, interval: 94 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3839700 Average: 3.1945 StdDev: 34.66 Min: 0 Median: 1.4807 Max: 12138 Percentiles: P50: 1.48 P75: 1.88 P99: 7.94 P99.9: 162.26 P99.99: 508.40 ------------------------------------------------------ [ 0, 1 ] 757993 19.741% 19.741% #### ( 1, 2 ] 2417242 62.954% 82.695% ############# ( 2, 3 ] 365654 9.523% 92.218% ## ( 3, 4 ] 138808 3.615% 95.833% # ( 4, 6 ] 109470 2.851% 98.684% # ( 6, 10 ] 25006 0.651% 99.335% ( 10, 15 ] 4467 0.116% 99.452% ( 15, 22 ] 691 0.018% 99.470% ( 22, 34 ] 50 0.001% 99.471% ( 34, 51 ] 14 0.000% 99.471% ( 51, 76 ] 271 0.007% 99.478% ( 76, 110 ] 9935 0.259% 99.737% ( 110, 170 ] 7187 0.187% 99.924% ( 170, 250 ] 1125 0.029% 99.953% ( 250, 380 ] 884 0.023% 99.976% ( 380, 580 ] 810 0.021% 99.998% ( 580, 870 ] 408 0.011% 100.008% ( 870, 1300 ] 153 0.004% 100.012% ( 1300, 1900 ] 82 0.002% 100.014% ( 1900, 2900 ] 103 0.003% 100.017% ( 2900, 4400 ] 84 0.002% 100.019% ( 4400, 6600 ] 31 0.001% 100.020% ( 6600, 9900 ] 11 0.000% 100.020% ( 9900, 14000 ] 2 0.000% 100.020% ** Level 1 read latency histogram (micros): Count: 2052446 Average: 6.9260 StdDev: 110.67 Min: 0 Median: 1.7403 Max: 12058 Percentiles: P50: 1.74 P75: 2.61 P99: 9.45 P99.9: 158.47 P99.99: 447.87 ------------------------------------------------------ [ 0, 1 ] 210259 10.244% 10.244% ## ( 1, 2 ] 1102267 53.705% 63.949% ########### ( 2, 3 ] 370731 18.063% 82.012% #### ( 3, 4 ] 157292 7.664% 89.676% ## ( 4, 6 ] 154848 7.545% 97.220% ## ( 6, 10 ] 42393 2.065% 99.286% ( 10, 15 ] 7646 0.373% 99.658% ( 15, 22 ] 1079 0.053% 99.711% ( 22, 34 ] 78 0.004% 99.715% ( 34, 51 ] 67 0.003% 99.718% ( 51, 76 ] 193 0.009% 99.727% ( 76, 110 ] 2110 0.103% 99.830% ( 110, 170 ] 1771 0.086% 99.917% ( 170, 250 ] 529 0.026% 99.942% ( 250, 380 ] 654 0.032% 99.974% ( 380, 580 ] 954 0.046% 100.021% ( 580, 870 ] 979 0.048% 100.068% ( 870, 1300 ] 712 0.035% 100.103% ( 1300, 1900 ] 442 0.022% 100.125% ( 1900, 2900 ] 544 0.027% 100.151% ( 2900, 4400 ] 744 0.036% 100.187% ( 4400, 6600 ] 175 0.009% 100.196% ( 6600, 9900 ] 78 0.004% 100.200% ( 9900, 14000 ] 6 0.000% 100.200% ** Level 2 read latency histogram (micros): Count: 28281 Average: 2.0409 StdDev: 3.05 Min: 0 Median: 1.4144 Max: 310 Percentiles: P50: 1.41 P75: 1.84 P99: 5.53 P99.9: 9.92 P99.99: 183.75 ------------------------------------------------------ [ 0, 1 ] 7185 25.406% 25.406% ##### ( 1, 2 ] 16783 59.344% 84.749% ############ ( 2, 3 ] 2596 9.179% 93.929% ## ( 3, 4 ] 952 3.366% 97.295% # ( 4, 6 ] 631 2.231% 99.526% ( 6, 10 ] 108 0.382% 99.908% ( 10, 15 ] 19 0.067% 99.975% ( 15, 22 ] 2 0.007% 99.982% ( 51, 76 ] 1 0.004% 99.986% ( 110, 170 ] 1 0.004% 99.989% ( 170, 250 ] 1 0.004% 99.993% ( 250, 380 ] 2 0.007% 100.000% ** Level 3 read latency histogram (micros): Count: 871517 Average: 8.1748 StdDev: 121.85 Min: 1 Median: 1.8820 Max: 11843 Percentiles: P50: 1.88 P75: 2.84 P99: 9.22 P99.9: 510.81 P99.99: 908.17 ------------------------------------------------------ [ 0, 1 ] 33389 3.831% 3.831% # ( 1, 2 ] 456222 52.348% 56.179% ########## ( 2, 3 ] 195484 22.430% 78.609% #### ( 3, 4 ] 84609 9.708% 88.318% ## ( 4, 6 ] 80595 9.248% 97.565% ## ( 6, 10 ] 15509 1.780% 99.345% ( 10, 15 ] 2900 0.333% 99.678% ( 15, 22 ] 416 0.048% 99.725% ( 22, 34 ] 41 0.005% 99.730% ( 34, 51 ] 16 0.002% 99.732% ( 51, 76 ] 11 0.001% 99.733% ( 76, 110 ] 169 0.019% 99.753% ( 110, 170 ] 391 0.045% 99.797% ( 170, 250 ] 249 0.029% 99.826% ( 250, 380 ] 324 0.037% 99.863% ( 380, 580 ] 490 0.056% 99.919% ( 580, 870 ] 567 0.065% 99.985% ( 870, 1300 ] 539 0.062% 100.046% ( 1300, 1900 ] 305 0.035% 100.081% ( 1900, 2900 ] 293 0.034% 100.115% ( 2900, 4400 ] 366 0.042% 100.157% ( 4400, 6600 ] 101 0.012% 100.169% ( 6600, 9900 ] 30 0.003% 100.172% ( 9900, 14000 ] 4 0.000% 100.172% ** Level 4 read latency histogram (micros): Count: 127178 Average: 23.5220 StdDev: 227.16 Min: 1 Median: 1.9138 Max: 27688 Percentiles: P50: 1.91 P75: 2.90 P99: 662.01 P99.9: 3412.54 P99.99: 4377.10 ------------------------------------------------------ [ 0, 1 ] 2216 1.742% 1.742% ( 1, 2 ] 67159 52.807% 54.550% ########### ( 2, 3 ] 28904 22.727% 77.277% ##### ( 3, 4 ] 12847 10.102% 87.378% ## ( 4, 6 ] 10415 8.189% 95.568% ## ( 6, 10 ] 2652 2.085% 97.653% ( 10, 15 ] 546 0.429% 98.082% ( 15, 22 ] 91 0.072% 98.154% ( 22, 34 ] 8 0.006% 98.160% ( 34, 51 ] 9 0.007% 98.167% ( 51, 76 ] 1 0.001% 98.168% ( 76, 110 ] 27 0.021% 98.189% ( 110, 170 ] 100 0.079% 98.268% ( 170, 250 ] 206 0.162% 98.430% ( 250, 380 ] 224 0.176% 98.606% ( 380, 580 ] 370 0.291% 98.897% ( 580, 870 ] 464 0.365% 99.262% ( 870, 1300 ] 367 0.289% 99.550% ( 1300, 1900 ] 242 0.190% 99.741% ( 1900, 2900 ] 142 0.112% 99.852% ( 2900, 4400 ] 178 0.140% 99.992% ( 4400, 6600 ] 39 0.031% 100.023% ( 6600, 9900 ] 3 0.002% 100.025% ( 14000, 22000 ] 1 0.001% 100.026% ( 22000, 33000 ] 1 0.001% 100.027% ** Level 5 read latency histogram (micros): Count: 340 Average: 1821.9971 StdDev: 1732.16 Min: 77 Median: 1031.2500 Max: 7700 Percentiles: P50: 1031.25 P75: 3069.81 P99: 6574.86 P99.9: 7700.00 P99.99: 7700.00 ------------------------------------------------------ ( 76, 110 ] 11 3.235% 3.235% # ( 110, 170 ] 18 5.294% 8.529% # ( 170, 250 ] 24 7.059% 15.588% # ( 250, 380 ] 29 8.529% 24.118% ## ( 380, 580 ] 34 10.000% 34.118% ## ( 580, 870 ] 42 12.353% 46.471% ## ( 870, 1300 ] 32 9.412% 55.882% ## ( 1300, 1900 ] 18 5.294% 61.176% # ( 1900, 2900 ] 41 12.059% 73.235% ## ( 2900, 4400 ] 53 15.588% 88.824% ### ( 4400, 6600 ] 35 10.294% 99.118% ## ( 6600, 9900 ] 3 0.882% 100.000% ** DB Stats ** Uptime(secs): 59.0 total, 6.2 interval Cumulative writes: 0 writes, 9000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 8.65 GB, 150.25 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:33.556 H:M:S, 56.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 158.88 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:3.148 H:M:S, 50.8 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 using bdev Nvme0n1 Initializing RocksDB Options from the specified file Initializing RocksDB Options from command-line flags Integrated BlobDB: blob cache disabled Keys: 16 bytes each (+ 0 bytes user-defined timestamp) Values: 1000 bytes each (1000 bytes after compression) Entries: 100000000 Prefix: 0 bytes Keys per prefix: 0 RawSize: 96893.3 MB (estimated) FileSize: 96893.3 MB (estimated) Write rate: 0 bytes/second Read rate: 0 ops/second Compression: NoCompression Compression sampling rate: 0 Memtablerep: SkipListFactory Perf Level: 1 ------------------------------------------------ DB path: [/mnt/rocksdb] overwrite : 6.400 micros/op 156247 ops/sec 60.001 seconds 9374999 operations; 151.4 MB/s Microseconds per write: Count: 9374999 Average: 6.4001 StdDev: 620.98 Min: 0 Median: 1.7592 Max: 1092826 Percentiles: P50: 1.76 P75: 2.78 P99: 9.26 P99.9: 1194.61 P99.99: 2759.16 ------------------------------------------------------ [ 0, 1 ] 1146085 12.225% 12.225% ## ( 1, 2 ] 4664534 49.755% 61.980% ########## ( 2, 3 ] 1573890 16.788% 78.768% ### ( 3, 4 ] 1292992 13.792% 92.560% ### ( 4, 6 ] 513533 5.478% 98.038% # ( 6, 10 ] 110605 1.180% 99.217% ( 10, 15 ] 34923 0.373% 99.590% ( 15, 22 ] 7960 0.085% 99.675% ( 22, 34 ] 1501 0.016% 99.691% ( 34, 51 ] 198 0.002% 99.693% ( 51, 76 ] 27 0.000% 99.693% ( 76, 110 ] 6519 0.070% 99.763% ( 110, 170 ] 2565 0.027% 99.790% ( 170, 250 ] 263 0.003% 99.793% ( 250, 380 ] 140 0.001% 99.795% ( 380, 580 ] 25 0.000% 99.795% ( 580, 870 ] 26 0.000% 99.795% ( 870, 1300 ] 13032 0.139% 99.934% ( 1300, 1900 ] 37 0.000% 99.934% ( 1900, 2900 ] 6060 0.065% 99.999% ( 2900, 4400 ] 52 0.001% 100.000% ( 4400, 6600 ] 4 0.000% 100.000% ( 6600, 9900 ] 2 0.000% 100.000% ( 14000, 22000 ] 2 0.000% 100.000% ( 50000, 75000 ] 2 0.000% 100.000% ( 110000, 170000 ] 4 0.000% 100.000% ( 170000, 250000 ] 12 0.000% 100.000% ( 380000, 570000 ] 2 0.000% 100.000% ( 570000, 860000 ] 3 0.000% 100.000% ( 860000, 1200000 ] 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 : 230671 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 : 9374999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 9674998968 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 : 594 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 33795779 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 : 29238868156 rocksdb.compact.write.bytes COUNT : 28996930219 rocksdb.flush.write.bytes COUNT : 9578142898 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 : 78 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 : 346 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 : 9501051904 rocksdb.memtable.garbage.bytes.at.flush COUNT : 3811328 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 : 29340594081 rocksdb.non.last.level.read.count COUNT : 7083189 rocksdb.block.checksum.compute.count COUNT : 7082079 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.394337 P95 : 3.914683 P99 : 7.765838 P100 : 1092819.000000 COUNT : 9374999 SUM : 55419337 rocksdb.compaction.times.micros P50 : 1130740.740741 P95 : 4230000.000000 P99 : 23430000.000000 P100 : 26461184.000000 COUNT : 87 SUM : 155905162 rocksdb.compaction.times.cpu_micros P50 : 851944.444444 P95 : 3670000.000000 P99 : 23135117.000000 P100 : 23135117.000000 COUNT : 87 SUM : 116889023 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 : 719.041096 P95 : 12770.000000 P99 : 154400.000000 P100 : 580359.000000 COUNT : 126 SUM : 1044170 rocksdb.compaction.outfile.sync.micros P50 : 1183.850575 P95 : 225294.117647 P99 : 387125.000000 P100 : 415255.000000 COUNT : 385 SUM : 11287500 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 : 109.370370 P95 : 2711.111111 P99 : 4310.000000 P100 : 5719.000000 COUNT : 254 SUM : 128681 rocksdb.table.open.io.micros P50 : 1470.588235 P95 : 10651.666667 P99 : 19575.384615 P100 : 28065.000000 COUNT : 594 SUM : 1561310 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.669095 P95 : 8.069660 P99 : 12.876353 P100 : 14048.000000 COUNT : 7080368 SUM : 52286459 rocksdb.read.block.get.micros P50 : 453.684211 P95 : 4123.076923 P99 : 6177.170732 P100 : 27701.000000 COUNT : 1188 SUM : 1211637 rocksdb.write.raw.block.micros P50 : 0.514762 P95 : 0.978048 P99 : 2.976231 P100 : 58568.000000 COUNT : 9349973 SUM : 20993455 rocksdb.numfiles.in.singlecompaction P50 : 3.164557 P95 : 4.600000 P99 : 25.120000 P100 : 34.000000 COUNT : 148 SUM : 580 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.572149 P95 : 1249.288563 P99 : 2652.591489 P100 : 1092635.000000 COUNT : 152210 SUM : 33811404 rocksdb.sst.read.micros P50 : 1.602764 P95 : 4.840060 P99 : 9.331307 P100 : 27688.000000 COUNT : 7083410 SUM : 37884398 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 : 9374999 SUM : 9674998968 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 : 215714.285714 P95 : 555750.000000 P99 : 1111600.000000 P100 : 1217854.000000 COUNT : 126 SUM : 30362600 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 : 363 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