[2024-11-19 15:15:54.322831] Starting SPDK v24.01.1-pre git sha1 c13c99a5e / DPDK 23.11.0 initialization... [2024-11-19 15:15:54.323090] [ 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_pid271432 ] Set seed to 1732025754316187 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-11-19 15:15:54.438845] app.c: 798:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-11-19 15:15:54.644904] app.c: 488:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-11-19 15:15:54.644952] app.c: 489:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 271432' to capture a snapshot of events at runtime. [2024-11-19 15:15:54.644962] app.c: 494:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid271432 for offline analysis/debug. [2024-11-19 15:15:54.645002] reactor.c: 937:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Tue Nov 19 15:16:03 2024 CPU: 96 * Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz CPUCache: 36608 KB 2024/11/19-15:16:06 ... thread 0: (1000000,1000000) ops and (361390.1,361390.1) ops/second in (2.767093,2.767093) 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/8 629.99 MB 6.3 0.0 0.0 0.0 0.8 0.8 0.0 1.0 0.0 355.6 2.30 2.07 12 0.192 0 0 0.0 0.0 L1 1/1 63.00 MB 0.0 0.0 0.0 0.0 0.0 0.0 0.2 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L2 1/0 1.16 MB 0.0 0.1 0.1 0.1 0.1 0.1 0.1 2.0 247.9 247.8 0.51 0.49 1 0.508 127K 31 0.0 0.0 L3 19/1 1.03 GB 0.9 0.1 0.1 0.0 0.1 0.1 0.1 1.0 223.6 223.6 0.56 0.50 1 0.558 126K 0 0.0 0.0 L4 112/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 1036/0 85.63 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 1178/10 96.94 GB 0.0 0.2 0.2 0.1 1.0 1.0 0.4 1.3 74.4 317.5 3.37 3.06 14 0.241 254K 31 0.0 0.0 Int 0/0 0.00 KB 0.0 0.2 0.2 0.1 1.0 1.0 0.4 1.3 74.4 317.5 3.37 3.06 14 0.241 254K 31 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 0.2 0.2 0.1 0.2 0.2 0.0 0.0 235.2 235.2 1.07 0.99 2 0.533 254K 31 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 355.6 2.30 2.07 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.04 GB write, 356.28 MB/s write, 0.24 GB read, 83.53 MB/s read, 3.4 seconds Interval compaction: 1.04 GB write, 386.38 MB/s write, 0.24 GB read, 90.59 MB/s read, 3.4 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 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: 118040 Average: 2.0867 StdDev: 22.73 Min: 0 Median: 1.3588 Max: 5124 Percentiles: P50: 1.36 P75: 1.75 P99: 5.24 P99.9: 9.72 P99.99: 213.92 ------------------------------------------------------ [ 0, 1 ] 32178 27.260% 27.260% ##### ( 1, 2 ] 74811 63.378% 90.638% ############# ( 2, 3 ] 6324 5.358% 95.995% # ( 3, 4 ] 2448 2.074% 98.069% ( 4, 6 ] 1772 1.501% 99.570% ( 6, 10 ] 420 0.356% 99.926% ( 10, 15 ] 54 0.046% 99.972% ( 15, 22 ] 11 0.009% 99.981% ( 22, 34 ] 2 0.002% 99.983% ( 34, 51 ] 2 0.002% 99.985% ( 110, 170 ] 6 0.005% 99.990% ( 170, 250 ] 4 0.003% 99.993% ( 250, 380 ] 1 0.001% 99.994% ( 380, 580 ] 6 0.005% 99.999% ( 580, 870 ] 1 0.001% 100.000% ( 870, 1300 ] 1 0.001% 100.001% ( 1300, 1900 ] 1 0.001% 100.002% ( 1900, 2900 ] 1 0.001% 100.003% ( 2900, 4400 ] 2 0.002% 100.004% ( 4400, 6600 ] 1 0.001% 100.005% ** Level 1 read latency histogram (micros): Count: 5 Average: 2278.8000 StdDev: 2612.07 Min: 522 Median: 797.5000 Max: 7348 Percentiles: P50: 797.50 P75: 2650.00 P99: 7348.00 P99.9: 7348.00 P99.99: 7348.00 ------------------------------------------------------ ( 380, 580 ] 1 20.000% 20.000% #### ( 580, 870 ] 2 40.000% 60.000% ######## ( 1900, 2900 ] 1 20.000% 80.000% #### ( 6600, 9900 ] 1 20.000% 100.000% #### ** Level 2 read latency histogram (micros): Count: 31696 Average: 2.1389 StdDev: 44.92 Min: 1 Median: 1.2638 Max: 7587 Percentiles: P50: 1.26 P75: 1.66 P99: 3.62 P99.9: 8.99 P99.99: 820.82 ------------------------------------------------------ [ 0, 1 ] 10627 33.528% 33.528% ####### ( 1, 2 ] 19788 62.431% 95.958% ############ ( 2, 3 ] 791 2.496% 98.454% ( 3, 4 ] 277 0.874% 99.328% ( 4, 6 ] 132 0.416% 99.744% ( 6, 10 ] 66 0.208% 99.953% ( 10, 15 ] 4 0.013% 99.965% ( 15, 22 ] 2 0.006% 99.972% ( 22, 34 ] 1 0.003% 99.975% ( 51, 76 ] 1 0.003% 99.978% ( 170, 250 ] 1 0.003% 99.981% ( 380, 580 ] 2 0.006% 99.987% ( 580, 870 ] 1 0.003% 99.991% ( 870, 1300 ] 1 0.003% 99.994% ( 1900, 2900 ] 1 0.003% 99.997% ( 6600, 9900 ] 1 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 9853 Average: 20.5235 StdDev: 368.24 Min: 1 Median: 1.7732 Max: 11322 Percentiles: P50: 1.77 P75: 2.52 P99: 9.12 P99.9: 8310.64 P99.99: 11322.00 ------------------------------------------------------ [ 0, 1 ] 587 5.958% 5.958% # ( 1, 2 ] 5614 56.978% 62.935% ########### ( 2, 3 ] 2298 23.323% 86.258% ##### ( 3, 4 ] 541 5.491% 91.749% # ( 4, 6 ] 597 6.059% 97.808% # ( 6, 10 ] 152 1.543% 99.350% ( 10, 15 ] 16 0.162% 99.513% ( 15, 22 ] 2 0.020% 99.533% ( 250, 380 ] 2 0.020% 99.553% ( 380, 580 ] 7 0.071% 99.624% ( 580, 870 ] 11 0.112% 99.736% ( 870, 1300 ] 5 0.051% 99.787% ( 1900, 2900 ] 2 0.020% 99.807% ( 2900, 4400 ] 2 0.020% 99.827% ( 4400, 6600 ] 4 0.041% 99.868% ( 6600, 9900 ] 8 0.081% 99.949% ( 9900, 14000 ] 6 0.061% 100.010% ** Level 4 read latency histogram (micros): Count: 25 Average: 3359.2800 StdDev: 3606.20 Min: 95 Median: 1750.0000 Max: 11082 Percentiles: P50: 1750.00 P75: 6050.00 P99: 11082.00 P99.9: 11082.00 P99.99: 11082.00 ------------------------------------------------------ ( 76, 110 ] 1 4.000% 4.000% # ( 250, 380 ] 3 12.000% 16.000% ## ( 380, 580 ] 1 4.000% 20.000% # ( 580, 870 ] 5 20.000% 40.000% #### ( 870, 1300 ] 1 4.000% 44.000% # ( 1300, 1900 ] 2 8.000% 52.000% ## ( 1900, 2900 ] 3 12.000% 64.000% ## ( 2900, 4400 ] 2 8.000% 72.000% ## ( 4400, 6600 ] 1 4.000% 76.000% # ( 6600, 9900 ] 4 16.000% 92.000% ### ( 9900, 14000 ] 2 8.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, 327.75 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:0.194 H:M:S, 6.5 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 355.35 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.194 H:M:S, 7.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/11/19-15:16:09 ... thread 0: (1000000,2000000) ops and (326400.3,343005.2) ops/second in (3.063723,5.830816) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 10/10 1.35 GB 0.0 0.9 0.0 0.9 2.6 1.8 0.0 1.5 103.8 318.7 8.50 7.89 29 0.293 895K 1029 0.0 0.0 L1 1/1 3.02 MB 0.0 0.3 0.2 0.1 0.3 0.2 0.2 1.2 243.2 242.9 1.30 1.26 1 1.295 319K 365 0.0 0.0 L2 2/1 55.20 MB 0.5 0.1 0.1 0.1 0.1 0.1 0.4 2.0 247.9 247.8 0.51 0.49 1 0.508 127K 31 0.0 0.0 L3 20/11 1.17 GB 0.3 0.1 0.1 0.0 0.1 0.1 0.4 1.0 223.6 223.6 0.56 0.50 1 0.558 126K 0 0.0 0.0 L4 169/0 9.71 GB 1.0 0.1 0.1 0.0 0.1 0.1 0.0 1.0 115.7 115.8 0.97 0.63 1 0.969 113K 0 0.0 0.0 L5 1036/0 85.63 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/23 97.92 GB 0.0 1.5 0.5 1.0 3.3 2.3 1.0 1.9 131.9 286.3 11.83 10.77 33 0.358 1583K 1425 0.0 0.0 Int 0/0 0.00 KB 0.0 1.5 0.5 1.0 3.3 2.3 0.9 1.9 131.9 286.3 11.83 10.77 33 0.358 1583K 1425 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 1.5 0.5 1.0 1.5 0.5 0.0 0.0 234.4 234.1 6.66 6.15 7 0.951 1583K 1425 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 1.8 1.8 0.0 0.0 0.0 353.3 5.17 4.62 26 0.199 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 6.1 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.31 GB write, 558.07 MB/s write, 1.52 GB read, 257.15 MB/s read, 11.8 seconds Interval compaction: 3.31 GB write, 580.46 MB/s write, 1.52 GB read, 267.46 MB/s read, 11.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: 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: 378855 Average: 2.2397 StdDev: 16.12 Min: 0 Median: 1.4991 Max: 5124 Percentiles: P50: 1.50 P75: 1.88 P99: 5.65 P99.9: 9.72 P99.99: 18.99 ------------------------------------------------------ [ 0, 1 ] 64363 16.989% 16.989% ### ( 1, 2 ] 250590 66.144% 83.133% ############# ( 2, 3 ] 39715 10.483% 93.616% ## ( 3, 4 ] 12413 3.276% 96.892% # ( 4, 6 ] 9688 2.557% 99.449% # ( 6, 10 ] 1836 0.485% 99.934% ( 10, 15 ] 200 0.053% 99.987% ( 15, 22 ] 23 0.006% 99.993% ( 22, 34 ] 3 0.001% 99.994% ( 34, 51 ] 2 0.001% 99.994% ( 51, 76 ] 1 0.000% 99.994% ( 110, 170 ] 11 0.003% 99.997% ( 170, 250 ] 9 0.002% 100.000% ( 250, 380 ] 5 0.001% 100.001% ( 380, 580 ] 10 0.003% 100.004% ( 580, 870 ] 9 0.002% 100.006% ( 870, 1300 ] 4 0.001% 100.007% ( 1300, 1900 ] 3 0.001% 100.008% ( 1900, 2900 ] 3 0.001% 100.009% ( 2900, 4400 ] 3 0.001% 100.010% ( 4400, 6600 ] 1 0.000% 100.010% ** Level 1 read latency histogram (micros): Count: 26 Average: 610.0769 StdDev: 1451.47 Min: 1 Median: 2.6667 Max: 7348 Percentiles: P50: 2.67 P75: 652.50 P99: 7348.00 P99.9: 7348.00 P99.99: 7348.00 ------------------------------------------------------ [ 0, 1 ] 6 23.077% 23.077% ##### ( 1, 2 ] 5 19.231% 42.308% #### ( 2, 3 ] 3 11.538% 53.846% ## ( 4, 6 ] 1 3.846% 57.692% # ( 170, 250 ] 1 3.846% 61.538% # ( 380, 580 ] 3 11.538% 73.077% ## ( 580, 870 ] 2 7.692% 80.769% ## ( 870, 1300 ] 2 7.692% 88.462% ## ( 1300, 1900 ] 1 3.846% 92.308% # ( 1900, 2900 ] 1 3.846% 96.154% # ( 6600, 9900 ] 1 3.846% 100.000% # ** Level 2 read latency histogram (micros): Count: 31893 Average: 2.1442 StdDev: 44.78 Min: 1 Median: 1.2679 Max: 7587 Percentiles: P50: 1.27 P75: 1.67 P99: 3.66 P99.9: 9.07 P99.99: 815.10 ------------------------------------------------------ [ 0, 1 ] 10627 33.321% 33.321% ####### ( 1, 2 ] 19857 62.261% 95.582% ############ ( 2, 3 ] 901 2.825% 98.407% # ( 3, 4 ] 287 0.900% 99.307% ( 4, 6 ] 137 0.430% 99.737% ( 6, 10 ] 68 0.213% 99.950% ( 10, 15 ] 4 0.013% 99.962% ( 15, 22 ] 2 0.006% 99.969% ( 22, 34 ] 1 0.003% 99.972% ( 34, 51 ] 1 0.003% 99.975% ( 51, 76 ] 1 0.003% 99.978% ( 170, 250 ] 1 0.003% 99.981% ( 380, 580 ] 2 0.006% 99.987% ( 580, 870 ] 1 0.003% 99.991% ( 870, 1300 ] 1 0.003% 99.994% ( 1900, 2900 ] 1 0.003% 99.997% ( 6600, 9900 ] 1 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 188557 Average: 3.8746 StdDev: 85.86 Min: 1 Median: 1.5781 Max: 11322 Percentiles: P50: 1.58 P75: 1.96 P99: 8.98 P99.9: 229.44 P99.99: 1220.20 ------------------------------------------------------ [ 0, 1 ] 23183 12.295% 12.295% ## ( 1, 2 ] 122971 65.217% 77.512% ############# ( 2, 3 ] 24556 13.023% 90.535% ### ( 3, 4 ] 7521 3.989% 94.524% # ( 4, 6 ] 6129 3.250% 97.774% # ( 6, 10 ] 3098 1.643% 99.417% ( 10, 15 ] 480 0.255% 99.672% ( 15, 22 ] 55 0.029% 99.701% ( 22, 34 ] 7 0.004% 99.705% ( 51, 76 ] 5 0.003% 99.707% ( 76, 110 ] 68 0.036% 99.743% ( 110, 170 ] 236 0.125% 99.868% ( 170, 250 ] 80 0.042% 99.911% ( 250, 380 ] 74 0.039% 99.950% ( 380, 580 ] 40 0.021% 99.971% ( 580, 870 ] 27 0.014% 99.986% ( 870, 1300 ] 10 0.005% 99.991% ( 1300, 1900 ] 2 0.001% 99.992% ( 1900, 2900 ] 2 0.001% 99.993% ( 2900, 4400 ] 3 0.002% 99.995% ( 4400, 6600 ] 4 0.002% 99.997% ( 6600, 9900 ] 8 0.004% 100.001% ( 9900, 14000 ] 6 0.003% 100.004% ** Level 4 read latency histogram (micros): Count: 310 Average: 282.2355 StdDev: 1375.22 Min: 1 Median: 1.8605 Max: 11082 Percentiles: P50: 1.86 P75: 3.88 P99: 8992.50 P99.9: 11082.00 P99.99: 11082.00 ------------------------------------------------------ [ 0, 1 ] 44 14.194% 14.194% ### ( 1, 2 ] 129 41.613% 55.806% ######## ( 2, 3 ] 42 13.548% 69.355% ### ( 3, 4 ] 20 6.452% 75.806% # ( 4, 6 ] 22 7.097% 82.903% # ( 6, 10 ] 20 6.452% 89.355% # ( 10, 15 ] 3 0.968% 90.323% ( 76, 110 ] 1 0.323% 90.645% ( 110, 170 ] 2 0.645% 91.290% ( 170, 250 ] 1 0.323% 91.613% ( 250, 380 ] 4 1.290% 92.903% ( 380, 580 ] 1 0.323% 93.226% ( 580, 870 ] 5 1.613% 94.839% ( 870, 1300 ] 1 0.323% 95.161% ( 1300, 1900 ] 3 0.968% 96.129% ( 1900, 2900 ] 3 0.968% 97.097% ( 2900, 4400 ] 2 0.645% 97.742% ( 4400, 6600 ] 1 0.323% 98.065% ( 6600, 9900 ] 4 1.290% 99.355% ( 9900, 14000 ] 2 0.645% 100.000% ** DB Stats ** Uptime(secs): 6.1 total, 3.1 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 324.46 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.612 H:M:S, 10.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 321.24 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.418 H:M:S, 13.6 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/11/19-15:16:12 ... thread 0: (1000000,3000000) ops and (324278.4,336527.1) ops/second in (3.083770,8.914586) 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/14 2.27 GB 62.9 1.4 0.0 1.4 4.1 2.7 0.0 1.5 105.2 315.5 13.17 12.20 44 0.299 1407K 1529 0.0 0.0 L1 1/1 3.02 MB 0.0 0.3 0.2 0.1 0.3 0.2 0.2 1.2 243.2 242.9 1.30 1.26 1 1.295 319K 365 0.0 0.0 L2 1/0 54.03 MB 0.5 0.1 0.1 0.1 0.1 0.1 0.4 2.0 247.9 247.8 0.51 0.49 1 0.508 127K 31 0.0 0.0 L3 20/0 942.96 MB 0.9 1.0 0.1 0.9 1.0 0.1 0.4 8.4 240.8 240.5 4.39 4.03 2 2.194 1072K 1182 0.0 0.0 L4 169/0 9.59 GB 1.0 0.1 0.1 0.0 0.1 0.1 0.3 1.0 115.7 115.8 0.97 0.63 1 0.969 113K 0 0.0 0.0 L5 1040/0 86.00 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1248/15 98.84 GB 0.0 2.9 0.5 2.4 5.6 3.2 1.6 2.1 147.3 283.5 20.33 18.61 49 0.415 3041K 3107 0.0 0.0 Int 0/0 0.00 KB 0.0 2.9 0.5 2.4 5.6 3.2 1.5 2.1 147.3 283.5 20.33 18.61 49 0.415 3041K 3107 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.9 0.5 2.4 2.9 0.5 0.0 0.0 240.8 240.6 12.44 11.59 10 1.244 3041K 3107 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 351.2 7.89 7.02 39 0.202 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 9.2 total, 8.9 interval Flush(GB): cumulative 2.707, interval 2.707 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 5.63 GB write, 629.96 MB/s write, 2.93 GB read, 327.37 MB/s read, 20.3 seconds Interval compaction: 5.63 GB write, 646.49 MB/s write, 2.93 GB read, 335.96 MB/s read, 20.3 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: 14, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 14, interval: 14 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 760584 Average: 2.2737 StdDev: 13.08 Min: 0 Median: 1.5368 Max: 5124 Percentiles: P50: 1.54 P75: 1.91 P99: 5.68 P99.9: 9.77 P99.99: 14.53 ------------------------------------------------------ [ 0, 1 ] 104731 13.770% 13.770% ### ( 1, 2 ] 513299 67.487% 81.257% ############# ( 2, 3 ] 90059 11.841% 93.098% ## ( 3, 4 ] 27071 3.559% 96.657% # ( 4, 6 ] 21205 2.788% 99.445% # ( 6, 10 ] 3673 0.483% 99.928% ( 10, 15 ] 521 0.068% 99.997% ( 15, 22 ] 59 0.008% 100.004% ( 22, 34 ] 11 0.001% 100.006% ( 34, 51 ] 6 0.001% 100.007% ( 51, 76 ] 1 0.000% 100.007% ( 76, 110 ] 19 0.002% 100.009% ( 110, 170 ] 18 0.002% 100.012% ( 170, 250 ] 23 0.003% 100.015% ( 250, 380 ] 10 0.001% 100.016% ( 380, 580 ] 17 0.002% 100.018% ( 580, 870 ] 14 0.002% 100.020% ( 870, 1300 ] 10 0.001% 100.021% ( 1300, 1900 ] 5 0.001% 100.022% ( 1900, 2900 ] 3 0.000% 100.022% ( 2900, 4400 ] 4 0.001% 100.023% ( 4400, 6600 ] 1 0.000% 100.023% ** Level 1 read latency histogram (micros): Count: 12323 Average: 4.4584 StdDev: 73.90 Min: 1 Median: 1.5836 Max: 7348 Percentiles: P50: 1.58 P75: 1.96 P99: 9.69 P99.9: 425.13 P99.99: 2667.70 ------------------------------------------------------ [ 0, 1 ] 1381 11.207% 11.207% ## ( 1, 2 ] 8192 66.477% 77.684% ############# ( 2, 3 ] 1562 12.675% 90.359% ### ( 3, 4 ] 469 3.806% 94.165% # ( 4, 6 ] 390 3.165% 97.330% # ( 6, 10 ] 223 1.810% 99.140% ( 10, 15 ] 24 0.195% 99.335% ( 15, 22 ] 5 0.041% 99.375% ( 22, 34 ] 1 0.008% 99.383% ( 76, 110 ] 30 0.243% 99.627% ( 110, 170 ] 18 0.146% 99.773% ( 170, 250 ] 11 0.089% 99.862% ( 250, 380 ] 4 0.032% 99.895% ( 380, 580 ] 3 0.024% 99.919% ( 580, 870 ] 4 0.032% 99.951% ( 870, 1300 ] 3 0.024% 99.976% ( 1300, 1900 ] 1 0.008% 99.984% ( 1900, 2900 ] 1 0.008% 99.992% ( 6600, 9900 ] 1 0.008% 100.000% ** Level 2 read latency histogram (micros): Count: 47989 Average: 2.5599 StdDev: 38.81 Min: 1 Median: 1.3794 Max: 7587 Percentiles: P50: 1.38 P75: 1.78 P99: 6.28 P99.9: 128.29 P99.99: 913.24 ------------------------------------------------------ [ 0, 1 ] 12648 26.356% 26.356% ##### ( 1, 2 ] 29908 62.323% 88.679% ############ ( 2, 3 ] 3308 6.893% 95.572% # ( 3, 4 ] 923 1.923% 97.495% ( 4, 6 ] 696 1.450% 98.946% ( 6, 10 ] 370 0.771% 99.717% ( 10, 15 ] 45 0.094% 99.810% ( 15, 22 ] 11 0.023% 99.833% ( 22, 34 ] 2 0.004% 99.837% ( 34, 51 ] 4 0.008% 99.846% ( 51, 76 ] 1 0.002% 99.848% ( 76, 110 ] 18 0.038% 99.885% ( 110, 170 ] 23 0.048% 99.933% ( 170, 250 ] 9 0.019% 99.952% ( 250, 380 ] 5 0.010% 99.962% ( 380, 580 ] 8 0.017% 99.979% ( 580, 870 ] 5 0.010% 99.990% ( 870, 1300 ] 2 0.004% 99.994% ( 1300, 1900 ] 1 0.002% 99.996% ( 1900, 2900 ] 1 0.002% 99.998% ( 6600, 9900 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 236577 Average: 3.7600 StdDev: 77.41 Min: 0 Median: 1.5914 Max: 11322 Percentiles: P50: 1.59 P75: 1.98 P99: 8.99 P99.9: 235.63 P99.99: 1201.70 ------------------------------------------------------ [ 0, 1 ] 27163 11.482% 11.482% ## ( 1, 2 ] 154073 65.126% 76.608% ############# ( 2, 3 ] 31621 13.366% 89.974% ### ( 3, 4 ] 9981 4.219% 94.193% # ( 4, 6 ] 8402 3.551% 97.744% # ( 6, 10 ] 3979 1.682% 99.426% ( 10, 15 ] 612 0.259% 99.685% ( 15, 22 ] 61 0.026% 99.710% ( 22, 34 ] 7 0.003% 99.713% ( 51, 76 ] 5 0.002% 99.716% ( 76, 110 ] 72 0.030% 99.746% ( 110, 170 ] 275 0.116% 99.862% ( 170, 250 ] 109 0.046% 99.908% ( 250, 380 ] 94 0.040% 99.948% ( 380, 580 ] 54 0.023% 99.971% ( 580, 870 ] 33 0.014% 99.985% ( 870, 1300 ] 16 0.007% 99.992% ( 1300, 1900 ] 4 0.002% 99.993% ( 1900, 2900 ] 3 0.001% 99.995% ( 2900, 4400 ] 3 0.001% 99.996% ( 4400, 6600 ] 4 0.002% 99.997% ( 6600, 9900 ] 8 0.003% 100.001% ( 9900, 14000 ] 6 0.003% 100.003% ** Level 4 read latency histogram (micros): Count: 310 Average: 282.2355 StdDev: 1375.22 Min: 1 Median: 1.8605 Max: 11082 Percentiles: P50: 1.86 P75: 3.88 P99: 8992.50 P99.9: 11082.00 P99.99: 11082.00 ------------------------------------------------------ [ 0, 1 ] 44 14.194% 14.194% ### ( 1, 2 ] 129 41.613% 55.806% ######## ( 2, 3 ] 42 13.548% 69.355% ### ( 3, 4 ] 20 6.452% 75.806% # ( 4, 6 ] 22 7.097% 82.903% # ( 6, 10 ] 20 6.452% 89.355% # ( 10, 15 ] 3 0.968% 90.323% ( 76, 110 ] 1 0.323% 90.645% ( 110, 170 ] 2 0.645% 91.290% ( 170, 250 ] 1 0.323% 91.613% ( 250, 380 ] 4 1.290% 92.903% ( 380, 580 ] 1 0.323% 93.226% ( 580, 870 ] 5 1.613% 94.839% ( 870, 1300 ] 1 0.323% 95.161% ( 1300, 1900 ] 3 0.968% 96.129% ( 1900, 2900 ] 3 0.968% 97.097% ( 2900, 4400 ] 2 0.645% 97.742% ( 4400, 6600 ] 1 0.323% 98.065% ( 6600, 9900 ] 4 1.290% 99.355% ( 9900, 14000 ] 2 0.645% 100.000% ** Level 5 read latency histogram (micros): Count: 20 Average: 1260.5500 StdDev: 1466.27 Min: 136 Median: 380.0000 Max: 4623 Percentiles: P50: 380.00 P75: 2400.00 P99: 4623.00 P99.9: 4623.00 P99.99: 4623.00 ------------------------------------------------------ ( 110, 170 ] 4 20.000% 20.000% #### ( 170, 250 ] 3 15.000% 35.000% ### ( 250, 380 ] 3 15.000% 50.000% ### ( 380, 580 ] 1 5.000% 55.000% # ( 580, 870 ] 2 10.000% 65.000% ## ( 870, 1300 ] 1 5.000% 70.000% # ( 1900, 2900 ] 2 10.000% 80.000% ## ( 2900, 4400 ] 3 15.000% 95.000% ### ( 4400, 6600 ] 1 5.000% 100.000% # ** DB Stats ** Uptime(secs): 9.2 total, 3.1 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 322.67 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.048 H:M:S, 11.5 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 319.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.436 H:M:S, 14.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/11/19-15:16:15 ... thread 0: (1000000,4000000) ops and (314799.3,330818.8) ops/second in (3.176627,12.091213) 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/4 2.21 GB 201.4 2.5 0.0 2.5 6.2 3.7 0.0 1.7 123.3 311.1 20.45 19.08 62 0.330 2558K 2746 0.0 0.0 L1 10/0 1.10 GB 113.1 1.4 1.4 0.1 1.4 1.3 0.2 1.0 233.5 232.6 6.21 6.01 2 3.107 1473K 5560 0.0 0.0 L2 1/0 54.03 MB 0.5 0.1 0.1 0.1 0.1 0.1 0.4 2.0 247.9 247.8 0.51 0.49 1 0.508 127K 31 0.0 0.0 L3 20/0 942.96 MB 0.9 1.0 0.1 0.9 1.0 0.1 0.4 8.4 240.8 240.5 4.39 4.03 2 2.194 1072K 1182 0.0 0.0 L4 169/0 9.59 GB 1.0 0.1 0.1 0.0 0.1 0.1 0.3 1.0 115.7 115.8 0.97 0.63 1 0.969 113K 0 0.0 0.0 L5 1040/0 86.00 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1253/4 99.88 GB 0.0 5.1 1.6 3.5 8.9 5.4 1.6 2.4 161.9 279.7 32.52 30.25 68 0.478 5346K 9519 0.0 0.0 Int 0/0 0.00 KB 0.0 5.1 1.6 3.5 8.9 5.4 1.5 2.4 161.9 279.7 32.52 30.25 68 0.478 5346K 9519 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 5.1 1.6 3.5 5.1 1.6 0.0 0.0 242.9 242.5 21.67 20.58 15 1.445 5346K 9519 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 3.8 3.8 0.0 0.0 0.0 354.1 10.85 9.66 53 0.205 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.3 total, 12.1 interval Flush(GB): cumulative 3.753, interval 3.753 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 8.89 GB write, 738.10 MB/s write, 5.14 GB read, 427.15 MB/s read, 32.5 seconds Interval compaction: 8.89 GB write, 752.38 MB/s write, 5.14 GB read, 435.41 MB/s read, 32.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: 19, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 19, interval: 19 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1067746 Average: 2.2527 StdDev: 12.71 Min: 0 Median: 1.5126 Max: 5124 Percentiles: P50: 1.51 P75: 1.88 P99: 5.66 P99.9: 9.85 P99.99: 19.18 ------------------------------------------------------ [ 0, 1 ] 165414 15.492% 15.492% ### ( 1, 2 ] 718850 67.324% 82.816% ############# ( 2, 3 ] 115564 10.823% 93.639% ## ( 3, 4 ] 35131 3.290% 96.929% # ( 4, 6 ] 26694 2.500% 99.429% # ( 6, 10 ] 5219 0.489% 99.918% ( 10, 15 ] 721 0.068% 99.986% ( 15, 22 ] 79 0.007% 99.993% ( 22, 34 ] 14 0.001% 99.994% ( 34, 51 ] 7 0.001% 99.995% ( 51, 76 ] 7 0.001% 99.996% ( 76, 110 ] 61 0.006% 100.001% ( 110, 170 ] 76 0.007% 100.009% ( 170, 250 ] 46 0.004% 100.013% ( 250, 380 ] 18 0.002% 100.015% ( 380, 580 ] 34 0.003% 100.018% ( 580, 870 ] 25 0.002% 100.020% ( 870, 1300 ] 17 0.002% 100.022% ( 1300, 1900 ] 9 0.001% 100.022% ( 1900, 2900 ] 3 0.000% 100.023% ( 2900, 4400 ] 5 0.000% 100.023% ( 4400, 6600 ] 1 0.000% 100.023% ** Level 1 read latency histogram (micros): Count: 13139 Average: 6.5275 StdDev: 83.93 Min: 1 Median: 1.5800 Max: 7348 Percentiles: P50: 1.58 P75: 1.96 P99: 95.67 P99.9: 984.32 P99.99: 2795.37 ------------------------------------------------------ [ 0, 1 ] 1533 11.668% 11.668% ## ( 1, 2 ] 8684 66.093% 77.761% ############# ( 2, 3 ] 1612 12.269% 90.030% ## ( 3, 4 ] 482 3.668% 93.698% # ( 4, 6 ] 403 3.067% 96.765% # ( 6, 10 ] 233 1.773% 98.539% ( 10, 15 ] 26 0.198% 98.737% ( 15, 22 ] 7 0.053% 98.790% ( 22, 34 ] 1 0.008% 98.797% ( 76, 110 ] 46 0.350% 99.148% ( 110, 170 ] 44 0.335% 99.482% ( 170, 250 ] 21 0.160% 99.642% ( 250, 380 ] 13 0.099% 99.741% ( 380, 580 ] 11 0.084% 99.825% ( 580, 870 ] 8 0.061% 99.886% ( 870, 1300 ] 7 0.053% 99.939% ( 1300, 1900 ] 4 0.030% 99.970% ( 1900, 2900 ] 3 0.023% 99.992% ( 6600, 9900 ] 1 0.008% 100.000% ** Level 2 read latency histogram (micros): Count: 47989 Average: 2.5599 StdDev: 38.81 Min: 1 Median: 1.3794 Max: 7587 Percentiles: P50: 1.38 P75: 1.78 P99: 6.28 P99.9: 128.29 P99.99: 913.24 ------------------------------------------------------ [ 0, 1 ] 12648 26.356% 26.356% ##### ( 1, 2 ] 29908 62.323% 88.679% ############ ( 2, 3 ] 3308 6.893% 95.572% # ( 3, 4 ] 923 1.923% 97.495% ( 4, 6 ] 696 1.450% 98.946% ( 6, 10 ] 370 0.771% 99.717% ( 10, 15 ] 45 0.094% 99.810% ( 15, 22 ] 11 0.023% 99.833% ( 22, 34 ] 2 0.004% 99.837% ( 34, 51 ] 4 0.008% 99.846% ( 51, 76 ] 1 0.002% 99.848% ( 76, 110 ] 18 0.038% 99.885% ( 110, 170 ] 23 0.048% 99.933% ( 170, 250 ] 9 0.019% 99.952% ( 250, 380 ] 5 0.010% 99.962% ( 380, 580 ] 8 0.017% 99.979% ( 580, 870 ] 5 0.010% 99.990% ( 870, 1300 ] 2 0.004% 99.994% ( 1300, 1900 ] 1 0.002% 99.996% ( 1900, 2900 ] 1 0.002% 99.998% ( 6600, 9900 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 236577 Average: 3.7600 StdDev: 77.41 Min: 0 Median: 1.5914 Max: 11322 Percentiles: P50: 1.59 P75: 1.98 P99: 8.99 P99.9: 235.63 P99.99: 1201.70 ------------------------------------------------------ [ 0, 1 ] 27163 11.482% 11.482% ## ( 1, 2 ] 154073 65.126% 76.608% ############# ( 2, 3 ] 31621 13.366% 89.974% ### ( 3, 4 ] 9981 4.219% 94.193% # ( 4, 6 ] 8402 3.551% 97.744% # ( 6, 10 ] 3979 1.682% 99.426% ( 10, 15 ] 612 0.259% 99.685% ( 15, 22 ] 61 0.026% 99.710% ( 22, 34 ] 7 0.003% 99.713% ( 51, 76 ] 5 0.002% 99.716% ( 76, 110 ] 72 0.030% 99.746% ( 110, 170 ] 275 0.116% 99.862% ( 170, 250 ] 109 0.046% 99.908% ( 250, 380 ] 94 0.040% 99.948% ( 380, 580 ] 54 0.023% 99.971% ( 580, 870 ] 33 0.014% 99.985% ( 870, 1300 ] 16 0.007% 99.992% ( 1300, 1900 ] 4 0.002% 99.993% ( 1900, 2900 ] 3 0.001% 99.995% ( 2900, 4400 ] 3 0.001% 99.996% ( 4400, 6600 ] 4 0.002% 99.997% ( 6600, 9900 ] 8 0.003% 100.001% ( 9900, 14000 ] 6 0.003% 100.003% ** Level 4 read latency histogram (micros): Count: 310 Average: 282.2355 StdDev: 1375.22 Min: 1 Median: 1.8605 Max: 11082 Percentiles: P50: 1.86 P75: 3.88 P99: 8992.50 P99.9: 11082.00 P99.99: 11082.00 ------------------------------------------------------ [ 0, 1 ] 44 14.194% 14.194% ### ( 1, 2 ] 129 41.613% 55.806% ######## ( 2, 3 ] 42 13.548% 69.355% ### ( 3, 4 ] 20 6.452% 75.806% # ( 4, 6 ] 22 7.097% 82.903% # ( 6, 10 ] 20 6.452% 89.355% # ( 10, 15 ] 3 0.968% 90.323% ( 76, 110 ] 1 0.323% 90.645% ( 110, 170 ] 2 0.645% 91.290% ( 170, 250 ] 1 0.323% 91.613% ( 250, 380 ] 4 1.290% 92.903% ( 380, 580 ] 1 0.323% 93.226% ( 580, 870 ] 5 1.613% 94.839% ( 870, 1300 ] 1 0.323% 95.161% ( 1300, 1900 ] 3 0.968% 96.129% ( 1900, 2900 ] 3 0.968% 97.097% ( 2900, 4400 ] 2 0.645% 97.742% ( 4400, 6600 ] 1 0.323% 98.065% ( 6600, 9900 ] 4 1.290% 99.355% ( 9900, 14000 ] 2 0.645% 100.000% ** Level 5 read latency histogram (micros): Count: 20 Average: 1260.5500 StdDev: 1466.27 Min: 136 Median: 380.0000 Max: 4623 Percentiles: P50: 380.00 P75: 2400.00 P99: 4623.00 P99.9: 4623.00 P99.99: 4623.00 ------------------------------------------------------ ( 110, 170 ] 4 20.000% 20.000% #### ( 170, 250 ] 3 15.000% 35.000% ### ( 250, 380 ] 3 15.000% 50.000% ### ( 380, 580 ] 1 5.000% 55.000% # ( 580, 870 ] 2 10.000% 65.000% ## ( 870, 1300 ] 1 5.000% 70.000% # ( 1900, 2900 ] 2 10.000% 80.000% ## ( 2900, 4400 ] 3 15.000% 95.000% ### ( 4400, 6600 ] 1 5.000% 100.000% # ** DB Stats ** Uptime(secs): 12.3 total, 3.2 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 319.36 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:1.623 H:M:S, 13.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 309.82 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.575 H:M:S, 18.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/11/19-15:16:18 ... thread 0: (1000000,5000000) ops and (283944.5,320245.4) ops/second in (3.521815,15.613028) 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/13 3.13 GB 75.5 3.3 0.0 3.3 7.9 4.7 0.0 1.7 127.3 309.7 26.23 24.52 79 0.332 3390K 3541 0.0 0.0 L1 10/10 1.10 GB 0.0 1.4 1.4 0.1 1.4 1.3 0.2 1.0 233.5 232.6 6.21 6.01 2 3.107 1473K 5560 0.0 0.0 L2 1/0 54.03 MB 0.5 0.1 0.1 0.1 0.1 0.1 0.4 2.0 247.9 247.8 0.51 0.49 1 0.508 127K 31 0.0 0.0 L3 20/0 942.96 MB 0.9 1.0 0.1 0.9 1.0 0.1 0.4 8.4 240.8 240.5 4.39 4.03 2 2.194 1072K 1182 0.0 0.0 L4 169/0 9.59 GB 1.0 0.1 0.1 0.0 0.1 0.1 0.3 1.0 115.7 115.8 0.97 0.63 1 0.969 113K 0 0.0 0.0 L5 1040/0 86.00 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1258/23 100.80 GB 0.0 5.9 1.6 4.3 10.6 6.3 1.6 2.3 158.8 283.5 38.31 35.69 85 0.451 6178K 10K 0.0 0.0 Int 0/0 0.00 KB 0.0 5.9 1.6 4.3 10.6 6.3 1.5 2.3 158.8 283.5 38.31 35.69 85 0.451 6178K 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 5.9 1.6 4.3 5.9 1.6 0.0 0.0 245.5 245.0 24.79 23.64 18 1.377 6178K 10K 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.1 13.52 12.05 67 0.202 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 15.8 total, 15.6 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.61 GB write, 685.32 MB/s write, 5.94 GB read, 383.90 MB/s read, 38.3 seconds Interval compaction: 10.61 GB write, 695.59 MB/s write, 5.94 GB read, 389.65 MB/s read, 38.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: 20, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 3, total-stops: 20, interval: 23 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1362518 Average: 2.2597 StdDev: 13.12 Min: 0 Median: 1.5074 Max: 5124 Percentiles: P50: 1.51 P75: 1.88 P99: 5.64 P99.9: 9.91 P99.99: 91.87 ------------------------------------------------------ [ 0, 1 ] 213097 15.640% 15.640% ### ( 1, 2 ] 922587 67.712% 83.352% ############## ( 2, 3 ] 143030 10.497% 93.849% ## ( 3, 4 ] 43582 3.199% 97.048% # ( 4, 6 ] 32493 2.385% 99.433% ( 6, 10 ] 6506 0.477% 99.910% ( 10, 15 ] 881 0.065% 99.975% ( 15, 22 ] 101 0.007% 99.982% ( 22, 34 ] 20 0.001% 99.984% ( 34, 51 ] 9 0.001% 99.984% ( 51, 76 ] 9 0.001% 99.985% ( 76, 110 ] 143 0.010% 99.996% ( 110, 170 ] 167 0.012% 100.008% ( 170, 250 ] 69 0.005% 100.013% ( 250, 380 ] 34 0.002% 100.015% ( 380, 580 ] 51 0.004% 100.019% ( 580, 870 ] 30 0.002% 100.021% ( 870, 1300 ] 21 0.002% 100.023% ( 1300, 1900 ] 9 0.001% 100.024% ( 1900, 2900 ] 6 0.000% 100.024% ( 2900, 4400 ] 7 0.001% 100.025% ( 4400, 6600 ] 1 0.000% 100.025% ** Level 1 read latency histogram (micros): Count: 66493 Average: 3.3003 StdDev: 38.23 Min: 1 Median: 1.5046 Max: 7348 Percentiles: P50: 1.50 P75: 1.87 P99: 9.09 P99.9: 239.65 P99.99: 1502.60 ------------------------------------------------------ [ 0, 1 ] 10419 15.669% 15.669% ### ( 1, 2 ] 45235 68.030% 83.699% ############## ( 2, 3 ] 6179 9.293% 92.992% ## ( 3, 4 ] 1813 2.727% 95.718% # ( 4, 6 ] 1317 1.981% 97.699% ( 6, 10 ] 1121 1.686% 99.385% ( 10, 15 ] 110 0.165% 99.550% ( 15, 22 ] 12 0.018% 99.568% ( 22, 34 ] 1 0.002% 99.570% ( 76, 110 ] 116 0.174% 99.744% ( 110, 170 ] 80 0.120% 99.865% ( 170, 250 ] 27 0.041% 99.905% ( 250, 380 ] 19 0.029% 99.934% ( 380, 580 ] 19 0.029% 99.962% ( 580, 870 ] 10 0.015% 99.977% ( 870, 1300 ] 7 0.011% 99.988% ( 1300, 1900 ] 4 0.006% 99.994% ( 1900, 2900 ] 3 0.005% 99.998% ( 6600, 9900 ] 1 0.002% 100.000% ** Level 2 read latency histogram (micros): Count: 47989 Average: 2.5599 StdDev: 38.81 Min: 1 Median: 1.3794 Max: 7587 Percentiles: P50: 1.38 P75: 1.78 P99: 6.28 P99.9: 128.29 P99.99: 913.24 ------------------------------------------------------ [ 0, 1 ] 12648 26.356% 26.356% ##### ( 1, 2 ] 29908 62.323% 88.679% ############ ( 2, 3 ] 3308 6.893% 95.572% # ( 3, 4 ] 923 1.923% 97.495% ( 4, 6 ] 696 1.450% 98.946% ( 6, 10 ] 370 0.771% 99.717% ( 10, 15 ] 45 0.094% 99.810% ( 15, 22 ] 11 0.023% 99.833% ( 22, 34 ] 2 0.004% 99.837% ( 34, 51 ] 4 0.008% 99.846% ( 51, 76 ] 1 0.002% 99.848% ( 76, 110 ] 18 0.038% 99.885% ( 110, 170 ] 23 0.048% 99.933% ( 170, 250 ] 9 0.019% 99.952% ( 250, 380 ] 5 0.010% 99.962% ( 380, 580 ] 8 0.017% 99.979% ( 580, 870 ] 5 0.010% 99.990% ( 870, 1300 ] 2 0.004% 99.994% ( 1300, 1900 ] 1 0.002% 99.996% ( 1900, 2900 ] 1 0.002% 99.998% ( 6600, 9900 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 236577 Average: 3.7600 StdDev: 77.41 Min: 0 Median: 1.5914 Max: 11322 Percentiles: P50: 1.59 P75: 1.98 P99: 8.99 P99.9: 235.63 P99.99: 1201.70 ------------------------------------------------------ [ 0, 1 ] 27163 11.482% 11.482% ## ( 1, 2 ] 154073 65.126% 76.608% ############# ( 2, 3 ] 31621 13.366% 89.974% ### ( 3, 4 ] 9981 4.219% 94.193% # ( 4, 6 ] 8402 3.551% 97.744% # ( 6, 10 ] 3979 1.682% 99.426% ( 10, 15 ] 612 0.259% 99.685% ( 15, 22 ] 61 0.026% 99.710% ( 22, 34 ] 7 0.003% 99.713% ( 51, 76 ] 5 0.002% 99.716% ( 76, 110 ] 72 0.030% 99.746% ( 110, 170 ] 275 0.116% 99.862% ( 170, 250 ] 109 0.046% 99.908% ( 250, 380 ] 94 0.040% 99.948% ( 380, 580 ] 54 0.023% 99.971% ( 580, 870 ] 33 0.014% 99.985% ( 870, 1300 ] 16 0.007% 99.992% ( 1300, 1900 ] 4 0.002% 99.993% ( 1900, 2900 ] 3 0.001% 99.995% ( 2900, 4400 ] 3 0.001% 99.996% ( 4400, 6600 ] 4 0.002% 99.997% ( 6600, 9900 ] 8 0.003% 100.001% ( 9900, 14000 ] 6 0.003% 100.003% ** Level 4 read latency histogram (micros): Count: 310 Average: 282.2355 StdDev: 1375.22 Min: 1 Median: 1.8605 Max: 11082 Percentiles: P50: 1.86 P75: 3.88 P99: 8992.50 P99.9: 11082.00 P99.99: 11082.00 ------------------------------------------------------ [ 0, 1 ] 44 14.194% 14.194% ### ( 1, 2 ] 129 41.613% 55.806% ######## ( 2, 3 ] 42 13.548% 69.355% ### ( 3, 4 ] 20 6.452% 75.806% # ( 4, 6 ] 22 7.097% 82.903% # ( 6, 10 ] 20 6.452% 89.355% # ( 10, 15 ] 3 0.968% 90.323% ( 76, 110 ] 1 0.323% 90.645% ( 110, 170 ] 2 0.645% 91.290% ( 170, 250 ] 1 0.323% 91.613% ( 250, 380 ] 4 1.290% 92.903% ( 380, 580 ] 1 0.323% 93.226% ( 580, 870 ] 5 1.613% 94.839% ( 870, 1300 ] 1 0.323% 95.161% ( 1300, 1900 ] 3 0.968% 96.129% ( 1900, 2900 ] 3 0.968% 97.097% ( 2900, 4400 ] 2 0.645% 97.742% ( 4400, 6600 ] 1 0.323% 98.065% ( 6600, 9900 ] 4 1.290% 99.355% ( 9900, 14000 ] 2 0.645% 100.000% ** Level 5 read latency histogram (micros): Count: 20 Average: 1260.5500 StdDev: 1466.27 Min: 136 Median: 380.0000 Max: 4623 Percentiles: P50: 380.00 P75: 2400.00 P99: 4623.00 P99.9: 4623.00 P99.99: 4623.00 ------------------------------------------------------ ( 110, 170 ] 4 20.000% 20.000% #### ( 170, 250 ] 3 15.000% 35.000% ### ( 250, 380 ] 3 15.000% 50.000% ### ( 380, 580 ] 1 5.000% 55.000% # ( 580, 870 ] 2 10.000% 65.000% ## ( 870, 1300 ] 1 5.000% 70.000% # ( 1900, 2900 ] 2 10.000% 80.000% ## ( 2900, 4400 ] 3 15.000% 95.000% ### ( 4400, 6600 ] 1 5.000% 100.000% # ** DB Stats ** Uptime(secs): 15.8 total, 3.5 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 310.49 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:2.511 H:M:S, 15.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 279.46 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.888 H:M:S, 25.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/11/19-15:16:27 ... thread 0: (1000000,6000000) ops and (119192.3,249970.5) ops/second in (8.389804,24.002832) 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 4.12 GB 176.0 5.0 0.0 5.0 10.7 5.7 0.0 1.9 143.7 304.8 35.94 33.80 100 0.359 5244K 6930 0.0 0.0 L1 10/10 1.10 GB 0.0 1.4 1.4 0.1 1.4 1.3 0.2 1.0 233.5 232.6 6.21 6.01 2 3.107 1473K 5560 0.0 0.0 L2 1/0 54.03 MB 0.5 0.1 0.1 0.1 0.1 0.1 0.4 2.0 247.9 247.8 0.51 0.49 1 0.508 127K 31 0.0 0.0 L3 20/0 942.96 MB 0.9 1.0 0.1 0.9 1.0 0.1 0.4 8.4 240.8 240.5 4.39 4.03 2 2.194 1072K 1182 0.0 0.0 L4 169/0 9.59 GB 1.0 0.1 0.1 0.0 0.1 0.1 0.3 1.0 115.7 115.8 0.97 0.63 1 0.969 113K 0 0.0 0.0 L5 1040/0 86.00 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1259/23 101.78 GB 0.0 7.7 1.6 6.1 13.4 7.3 1.6 2.4 164.7 285.1 48.02 44.96 106 0.453 8032K 13K 0.0 0.0 Int 0/0 0.00 KB 0.0 7.7 1.6 6.1 13.4 7.3 1.5 2.4 164.7 285.1 48.02 44.96 106 0.453 8032K 13K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 7.7 1.6 6.1 7.7 1.6 0.0 0.0 250.8 250.4 31.54 30.31 23 1.371 8032K 13K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 5.7 5.7 0.0 0.0 0.0 351.6 16.48 14.65 83 0.199 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 24.2 total, 24.0 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: 13.37 GB write, 564.90 MB/s write, 7.73 GB read, 326.37 MB/s read, 48.0 seconds Interval compaction: 13.37 GB write, 570.41 MB/s write, 7.73 GB read, 329.55 MB/s read, 48.0 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 13, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 13, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 20, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 13, total-stops: 20, interval: 33 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2153418 Average: 2.2709 StdDev: 12.94 Min: 0 Median: 1.5026 Max: 5124 Percentiles: P50: 1.50 P75: 1.87 P99: 5.68 P99.9: 11.05 P99.99: 129.35 ------------------------------------------------------ [ 0, 1 ] 332412 15.436% 15.436% ### ( 1, 2 ] 1480943 68.772% 84.208% ############## ( 2, 3 ] 215004 9.984% 94.193% ## ( 3, 4 ] 65340 3.034% 97.227% # ( 4, 6 ] 45461 2.111% 99.338% ( 6, 10 ] 11793 0.548% 99.886% ( 10, 15 ] 1485 0.069% 99.954% ( 15, 22 ] 250 0.012% 99.966% ( 22, 34 ] 26 0.001% 99.967% ( 34, 51 ] 9 0.000% 99.968% ( 51, 76 ] 15 0.001% 99.968% ( 76, 110 ] 335 0.016% 99.984% ( 110, 170 ] 402 0.019% 100.003% ( 170, 250 ] 158 0.007% 100.010% ( 250, 380 ] 77 0.004% 100.014% ( 380, 580 ] 85 0.004% 100.018% ( 580, 870 ] 51 0.002% 100.020% ( 870, 1300 ] 33 0.002% 100.021% ( 1300, 1900 ] 12 0.001% 100.022% ( 1900, 2900 ] 11 0.001% 100.022% ( 2900, 4400 ] 10 0.000% 100.023% ( 4400, 6600 ] 1 0.000% 100.023% ** Level 1 read latency histogram (micros): Count: 217198 Average: 2.7472 StdDev: 22.51 Min: 1 Median: 1.5031 Max: 7348 Percentiles: P50: 1.50 P75: 1.86 P99: 8.61 P99.9: 151.29 P99.99: 761.74 ------------------------------------------------------ [ 0, 1 ] 32651 15.033% 15.033% ### ( 1, 2 ] 150973 69.509% 84.542% ############## ( 2, 3 ] 19395 8.930% 93.472% ## ( 3, 4 ] 5737 2.641% 96.113% # ( 4, 6 ] 3948 1.818% 97.931% ( 6, 10 ] 3565 1.641% 99.572% ( 10, 15 ] 264 0.122% 99.694% ( 15, 22 ] 48 0.022% 99.716% ( 22, 34 ] 6 0.003% 99.719% ( 34, 51 ] 2 0.001% 99.720% ( 51, 76 ] 4 0.002% 99.721% ( 76, 110 ] 267 0.123% 99.844% ( 110, 170 ] 177 0.081% 99.926% ( 170, 250 ] 68 0.031% 99.957% ( 250, 380 ] 29 0.013% 99.971% ( 380, 580 ] 32 0.015% 99.985% ( 580, 870 ] 18 0.008% 99.994% ( 870, 1300 ] 7 0.003% 99.997% ( 1300, 1900 ] 4 0.002% 99.999% ( 1900, 2900 ] 3 0.001% 100.000% ( 6600, 9900 ] 1 0.000% 100.000% ** Level 2 read latency histogram (micros): Count: 47989 Average: 2.5599 StdDev: 38.81 Min: 1 Median: 1.3794 Max: 7587 Percentiles: P50: 1.38 P75: 1.78 P99: 6.28 P99.9: 128.29 P99.99: 913.24 ------------------------------------------------------ [ 0, 1 ] 12648 26.356% 26.356% ##### ( 1, 2 ] 29908 62.323% 88.679% ############ ( 2, 3 ] 3308 6.893% 95.572% # ( 3, 4 ] 923 1.923% 97.495% ( 4, 6 ] 696 1.450% 98.946% ( 6, 10 ] 370 0.771% 99.717% ( 10, 15 ] 45 0.094% 99.810% ( 15, 22 ] 11 0.023% 99.833% ( 22, 34 ] 2 0.004% 99.837% ( 34, 51 ] 4 0.008% 99.846% ( 51, 76 ] 1 0.002% 99.848% ( 76, 110 ] 18 0.038% 99.885% ( 110, 170 ] 23 0.048% 99.933% ( 170, 250 ] 9 0.019% 99.952% ( 250, 380 ] 5 0.010% 99.962% ( 380, 580 ] 8 0.017% 99.979% ( 580, 870 ] 5 0.010% 99.990% ( 870, 1300 ] 2 0.004% 99.994% ( 1300, 1900 ] 1 0.002% 99.996% ( 1900, 2900 ] 1 0.002% 99.998% ( 6600, 9900 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 236577 Average: 3.7600 StdDev: 77.41 Min: 0 Median: 1.5914 Max: 11322 Percentiles: P50: 1.59 P75: 1.98 P99: 8.99 P99.9: 235.63 P99.99: 1201.70 ------------------------------------------------------ [ 0, 1 ] 27163 11.482% 11.482% ## ( 1, 2 ] 154073 65.126% 76.608% ############# ( 2, 3 ] 31621 13.366% 89.974% ### ( 3, 4 ] 9981 4.219% 94.193% # ( 4, 6 ] 8402 3.551% 97.744% # ( 6, 10 ] 3979 1.682% 99.426% ( 10, 15 ] 612 0.259% 99.685% ( 15, 22 ] 61 0.026% 99.710% ( 22, 34 ] 7 0.003% 99.713% ( 51, 76 ] 5 0.002% 99.716% ( 76, 110 ] 72 0.030% 99.746% ( 110, 170 ] 275 0.116% 99.862% ( 170, 250 ] 109 0.046% 99.908% ( 250, 380 ] 94 0.040% 99.948% ( 380, 580 ] 54 0.023% 99.971% ( 580, 870 ] 33 0.014% 99.985% ( 870, 1300 ] 16 0.007% 99.992% ( 1300, 1900 ] 4 0.002% 99.993% ( 1900, 2900 ] 3 0.001% 99.995% ( 2900, 4400 ] 3 0.001% 99.996% ( 4400, 6600 ] 4 0.002% 99.997% ( 6600, 9900 ] 8 0.003% 100.001% ( 9900, 14000 ] 6 0.003% 100.003% ** Level 4 read latency histogram (micros): Count: 310 Average: 282.2355 StdDev: 1375.22 Min: 1 Median: 1.8605 Max: 11082 Percentiles: P50: 1.86 P75: 3.88 P99: 8992.50 P99.9: 11082.00 P99.99: 11082.00 ------------------------------------------------------ [ 0, 1 ] 44 14.194% 14.194% ### ( 1, 2 ] 129 41.613% 55.806% ######## ( 2, 3 ] 42 13.548% 69.355% ### ( 3, 4 ] 20 6.452% 75.806% # ( 4, 6 ] 22 7.097% 82.903% # ( 6, 10 ] 20 6.452% 89.355% # ( 10, 15 ] 3 0.968% 90.323% ( 76, 110 ] 1 0.323% 90.645% ( 110, 170 ] 2 0.645% 91.290% ( 170, 250 ] 1 0.323% 91.613% ( 250, 380 ] 4 1.290% 92.903% ( 380, 580 ] 1 0.323% 93.226% ( 580, 870 ] 5 1.613% 94.839% ( 870, 1300 ] 1 0.323% 95.161% ( 1300, 1900 ] 3 0.968% 96.129% ( 1900, 2900 ] 3 0.968% 97.097% ( 2900, 4400 ] 2 0.645% 97.742% ( 4400, 6600 ] 1 0.323% 98.065% ( 6600, 9900 ] 4 1.290% 99.355% ( 9900, 14000 ] 2 0.645% 100.000% ** Level 5 read latency histogram (micros): Count: 20 Average: 1260.5500 StdDev: 1466.27 Min: 136 Median: 380.0000 Max: 4623 Percentiles: P50: 380.00 P75: 2400.00 P99: 4623.00 P99.9: 4623.00 P99.99: 4623.00 ------------------------------------------------------ ( 110, 170 ] 4 20.000% 20.000% #### ( 170, 250 ] 3 15.000% 35.000% ### ( 250, 380 ] 3 15.000% 50.000% ### ( 380, 580 ] 1 5.000% 55.000% # ( 580, 870 ] 2 10.000% 65.000% ## ( 870, 1300 ] 1 5.000% 70.000% # ( 1900, 2900 ] 2 10.000% 80.000% ## ( 2900, 4400 ] 3 15.000% 95.000% ### ( 4400, 6600 ] 1 5.000% 100.000% # ** DB Stats ** Uptime(secs): 24.2 total, 8.4 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 243.63 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:8.148 H:M:S, 33.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 117.31 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:5.637 H:M:S, 67.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/11/19-15:16:37 ... thread 0: (1000000,7000000) ops and (94024.5,202088.1) ops/second in (10.635522,34.638354) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 10/6 2.76 GB 50.4 6.6 0.0 6.6 13.3 6.7 0.0 2.0 147.6 297.8 45.66 42.70 120 0.380 6843K 10K 0.0 0.0 L1 9/9 953.25 MB 0.0 4.9 3.7 1.2 4.9 3.7 0.2 1.3 222.5 219.8 22.63 21.42 3 7.544 5114K 62K 0.0 0.0 L2 6/5 772.68 MB 1.3 0.1 0.1 0.1 0.1 0.1 2.9 2.0 247.9 247.8 0.51 0.49 1 0.508 127K 31 0.0 0.0 L3 43/9 2.07 GB 1.6 3.1 1.9 1.2 3.1 1.9 0.4 1.6 218.2 217.7 14.76 13.54 6 2.460 3270K 6958 0.0 0.0 L4 172/6 9.57 GB 1.0 0.1 0.1 0.0 0.1 0.1 0.9 1.0 115.7 115.8 0.97 0.63 1 0.969 113K 0 0.0 0.0 L5 1048/0 86.68 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 1288/35 102.76 GB 0.0 14.9 5.9 9.0 21.5 12.5 5.4 3.2 180.2 260.5 84.52 78.78 131 0.645 15M 79K 0.0 0.0 Int 0/0 0.00 KB 0.0 14.9 5.9 9.0 21.5 12.5 5.4 3.2 180.2 260.5 84.52 78.78 131 0.645 15M 79K 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.9 5.9 9.0 14.8 5.8 0.0 0.0 235.8 234.6 64.59 61.33 32 2.019 15M 79K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 6.7 6.7 0.0 0.0 0.0 344.5 19.93 17.45 99 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): 34.9 total, 34.6 interval Flush(GB): cumulative 6.706, interval 6.706 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: 21.50 GB write, 631.43 MB/s write, 14.88 GB read, 436.81 MB/s read, 84.5 seconds Interval compaction: 21.50 GB write, 635.69 MB/s write, 14.88 GB read, 439.76 MB/s read, 84.5 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: 23, pending-compaction-bytes-delays: 16, pending-compaction-bytes-stops: 0, total-delays: 31, total-stops: 23, interval: 54 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2863871 Average: 2.5256 StdDev: 15.01 Min: 0 Median: 1.5281 Max: 5124 Percentiles: P50: 1.53 P75: 1.90 P99: 6.04 P99.9: 100.94 P99.99: 220.75 ------------------------------------------------------ [ 0, 1 ] 412623 14.408% 14.408% ### ( 1, 2 ] 1930044 67.393% 81.801% ############# ( 2, 3 ] 311139 10.864% 92.665% ## ( 3, 4 ] 101343 3.539% 96.204% # ( 4, 6 ] 79870 2.789% 98.993% # ( 6, 10 ] 21355 0.746% 99.738% ( 10, 15 ] 2891 0.101% 99.839% ( 15, 22 ] 411 0.014% 99.854% ( 22, 34 ] 30 0.001% 99.855% ( 34, 51 ] 11 0.000% 99.855% ( 51, 76 ] 19 0.001% 99.856% ( 76, 110 ] 1734 0.061% 99.916% ( 110, 170 ] 1839 0.064% 99.980% ( 170, 250 ] 436 0.015% 99.996% ( 250, 380 ] 242 0.008% 100.004% ( 380, 580 ] 274 0.010% 100.014% ( 580, 870 ] 128 0.004% 100.018% ( 870, 1300 ] 57 0.002% 100.020% ( 1300, 1900 ] 21 0.001% 100.021% ( 1900, 2900 ] 21 0.001% 100.022% ( 2900, 4400 ] 13 0.000% 100.022% ( 4400, 6600 ] 1 0.000% 100.022% ** Level 1 read latency histogram (micros): Count: 986953 Average: 3.3086 StdDev: 23.29 Min: 1 Median: 1.6938 Max: 7348 Percentiles: P50: 1.69 P75: 2.35 P99: 9.06 P99.9: 137.59 P99.99: 321.97 ------------------------------------------------------ [ 0, 1 ] 71106 7.205% 7.205% # ( 1, 2 ] 608817 61.687% 68.891% ############ ( 2, 3 ] 174205 17.651% 86.542% #### ( 3, 4 ] 54718 5.544% 92.086% # ( 4, 6 ] 54130 5.485% 97.571% # ( 6, 10 ] 18449 1.869% 99.440% ( 10, 15 ] 3122 0.316% 99.756% ( 15, 22 ] 367 0.037% 99.793% ( 22, 34 ] 21 0.002% 99.796% ( 34, 51 ] 7 0.001% 99.796% ( 51, 76 ] 10 0.001% 99.797% ( 76, 110 ] 707 0.072% 99.869% ( 110, 170 ] 670 0.068% 99.937% ( 170, 250 ] 358 0.036% 99.973% ( 250, 380 ] 304 0.031% 100.004% ( 380, 580 ] 271 0.027% 100.031% ( 580, 870 ] 162 0.016% 100.048% ( 870, 1300 ] 74 0.007% 100.055% ( 1300, 1900 ] 48 0.005% 100.060% ( 1900, 2900 ] 9 0.001% 100.061% ( 2900, 4400 ] 1 0.000% 100.061% ( 4400, 6600 ] 1 0.000% 100.061% ( 6600, 9900 ] 1 0.000% 100.061% ** Level 2 read latency histogram (micros): Count: 47989 Average: 2.5599 StdDev: 38.81 Min: 1 Median: 1.3794 Max: 7587 Percentiles: P50: 1.38 P75: 1.78 P99: 6.28 P99.9: 128.29 P99.99: 913.24 ------------------------------------------------------ [ 0, 1 ] 12648 26.356% 26.356% ##### ( 1, 2 ] 29908 62.323% 88.679% ############ ( 2, 3 ] 3308 6.893% 95.572% # ( 3, 4 ] 923 1.923% 97.495% ( 4, 6 ] 696 1.450% 98.946% ( 6, 10 ] 370 0.771% 99.717% ( 10, 15 ] 45 0.094% 99.810% ( 15, 22 ] 11 0.023% 99.833% ( 22, 34 ] 2 0.004% 99.837% ( 34, 51 ] 4 0.008% 99.846% ( 51, 76 ] 1 0.002% 99.848% ( 76, 110 ] 18 0.038% 99.885% ( 110, 170 ] 23 0.048% 99.933% ( 170, 250 ] 9 0.019% 99.952% ( 250, 380 ] 5 0.010% 99.962% ( 380, 580 ] 8 0.017% 99.979% ( 580, 870 ] 5 0.010% 99.990% ( 870, 1300 ] 2 0.004% 99.994% ( 1300, 1900 ] 1 0.002% 99.996% ( 1900, 2900 ] 1 0.002% 99.998% ( 6600, 9900 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 287134 Average: 4.3356 StdDev: 73.76 Min: 0 Median: 1.6331 Max: 11322 Percentiles: P50: 1.63 P75: 2.12 P99: 9.36 P99.9: 405.80 P99.99: 1317.19 ------------------------------------------------------ [ 0, 1 ] 28304 9.857% 9.857% ## ( 1, 2 ] 182069 63.409% 73.266% ############# ( 2, 3 ] 43256 15.065% 88.331% ### ( 3, 4 ] 14033 4.887% 93.218% # ( 4, 6 ] 12654 4.407% 97.625% # ( 6, 10 ] 4703 1.638% 99.263% ( 10, 15 ] 744 0.259% 99.523% ( 15, 22 ] 77 0.027% 99.549% ( 22, 34 ] 11 0.004% 99.553% ( 34, 51 ] 2 0.001% 99.554% ( 51, 76 ] 5 0.002% 99.556% ( 76, 110 ] 125 0.044% 99.599% ( 110, 170 ] 402 0.140% 99.739% ( 170, 250 ] 249 0.087% 99.826% ( 250, 380 ] 195 0.068% 99.894% ( 380, 580 ] 154 0.054% 99.947% ( 580, 870 ] 83 0.029% 99.976% ( 870, 1300 ] 41 0.014% 99.991% ( 1300, 1900 ] 10 0.003% 99.994% ( 1900, 2900 ] 10 0.003% 99.998% ( 2900, 4400 ] 3 0.001% 99.999% ( 4400, 6600 ] 4 0.001% 100.000% ( 6600, 9900 ] 8 0.003% 100.003% ( 9900, 14000 ] 6 0.002% 100.005% ** Level 4 read latency histogram (micros): Count: 324 Average: 300.5216 StdDev: 1351.87 Min: 1 Median: 1.9147 Max: 11082 Percentiles: P50: 1.91 P75: 4.73 P99: 8877.00 P99.9: 11082.00 P99.99: 11082.00 ------------------------------------------------------ [ 0, 1 ] 44 13.580% 13.580% ### ( 1, 2 ] 129 39.815% 53.395% ######## ( 2, 3 ] 42 12.963% 66.358% ### ( 3, 4 ] 20 6.173% 72.531% # ( 4, 6 ] 22 6.790% 79.321% # ( 6, 10 ] 20 6.173% 85.494% # ( 10, 15 ] 3 0.926% 86.420% ( 76, 110 ] 1 0.309% 86.728% ( 110, 170 ] 2 0.617% 87.346% ( 170, 250 ] 2 0.617% 87.963% ( 250, 380 ] 5 1.543% 89.506% ( 380, 580 ] 5 1.543% 91.049% ( 580, 870 ] 11 3.395% 94.444% # ( 870, 1300 ] 3 0.926% 95.370% ( 1300, 1900 ] 3 0.926% 96.296% ( 1900, 2900 ] 4 1.235% 97.531% ( 2900, 4400 ] 2 0.617% 98.148% ( 4400, 6600 ] 1 0.309% 98.457% ( 6600, 9900 ] 4 1.235% 99.691% ( 9900, 14000 ] 2 0.617% 100.309% ** Level 5 read latency histogram (micros): Count: 60 Average: 1055.7167 StdDev: 1328.67 Min: 82 Median: 328.0000 Max: 4858 Percentiles: P50: 328.00 P75: 1660.00 P99: 4858.00 P99.9: 4858.00 P99.99: 4858.00 ------------------------------------------------------ ( 76, 110 ] 4 6.667% 6.667% # ( 110, 170 ] 16 26.667% 33.333% ##### ( 170, 250 ] 7 11.667% 45.000% ## ( 250, 380 ] 5 8.333% 53.333% ## ( 380, 580 ] 4 6.667% 60.000% # ( 580, 870 ] 4 6.667% 66.667% # ( 870, 1300 ] 2 3.333% 70.000% # ( 1300, 1900 ] 5 8.333% 78.333% ## ( 1900, 2900 ] 5 8.333% 86.667% ## ( 2900, 4400 ] 6 10.000% 96.667% ## ( 4400, 6600 ] 2 3.333% 100.000% # ** DB Stats ** Uptime(secs): 34.9 total, 10.6 interval Cumulative writes: 0 writes, 7000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 6.73 GB, 197.55 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:15.724 H:M:S, 45.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 92.53 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:7.577 H:M:S, 71.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 10 num-running-flushes: 0 2024/11/19-15:16:42 ... thread 0: (1000000,8000000) ops and (242667.1,206402.5) ops/second in (4.120871,38.759225) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 15/10 3.62 GB 113.3 7.2 0.0 7.2 14.8 7.6 0.0 1.9 142.2 291.5 51.83 47.46 133 0.390 7482K 10K 0.0 0.0 L1 9/9 953.25 MB 0.0 4.9 3.7 1.2 4.9 3.7 0.2 1.3 222.5 219.8 22.63 21.42 3 7.544 5114K 62K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.1 0.1 0.1 2.9 2.0 247.9 247.8 0.51 0.49 1 0.508 127K 31 0.0 0.0 L3 23/0 972.44 MB 1.0 4.2 2.7 1.5 4.2 2.7 0.4 1.6 207.5 207.0 20.75 18.43 9 2.306 4373K 9558 0.0 0.0 L4 184/0 9.72 GB 1.0 2.0 2.0 0.1 2.0 2.0 0.9 1.0 117.5 117.4 17.81 9.99 33 0.540 2088K 954 0.0 0.0 L5 1068/0 88.40 GB 0.9 0.0 0.0 0.0 0.0 0.0 2.8 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1299/19 103.62 GB 0.0 18.5 8.5 10.0 26.0 16.0 7.1 3.4 166.7 234.2 113.54 97.79 179 0.634 19M 83K 0.0 0.0 Int 0/0 0.00 KB 0.0 18.5 8.5 10.0 26.0 16.0 7.1 3.4 166.7 234.2 113.54 97.79 179 0.634 19M 83K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 18.5 8.5 10.0 18.4 8.4 0.0 0.0 210.5 209.5 89.95 78.00 69 1.304 19M 83K 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 328.5 23.59 19.78 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): 39.0 total, 38.8 interval Flush(GB): cumulative 7.567, interval 7.567 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 25.97 GB write, 681.98 MB/s write, 18.49 GB read, 485.47 MB/s read, 113.5 seconds Interval compaction: 25.97 GB write, 686.10 MB/s write, 18.49 GB read, 488.40 MB/s read, 113.5 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: 47, pending-compaction-bytes-delays: 16, pending-compaction-bytes-stops: 0, total-delays: 31, total-stops: 47, interval: 78 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3223730 Average: 2.6441 StdDev: 20.57 Min: 0 Median: 1.5471 Max: 5965 Percentiles: P50: 1.55 P75: 1.92 P99: 6.62 P99.9: 99.34 P99.99: 253.91 ------------------------------------------------------ [ 0, 1 ] 438356 13.598% 13.598% ### ( 1, 2 ] 2145131 66.542% 80.140% ############# ( 2, 3 ] 376169 11.669% 91.808% ## ( 3, 4 ] 122785 3.809% 95.617% # ( 4, 6 ] 104802 3.251% 98.868% # ( 6, 10 ] 27318 0.847% 99.716% ( 10, 15 ] 4158 0.129% 99.845% ( 15, 22 ] 528 0.016% 99.861% ( 22, 34 ] 36 0.001% 99.862% ( 34, 51 ] 14 0.000% 99.862% ( 51, 76 ] 19 0.001% 99.863% ( 76, 110 ] 1735 0.054% 99.917% ( 110, 170 ] 1864 0.058% 99.975% ( 170, 250 ] 485 0.015% 99.990% ( 250, 380 ] 287 0.009% 99.999% ( 380, 580 ] 339 0.011% 100.009% ( 580, 870 ] 191 0.006% 100.015% ( 870, 1300 ] 102 0.003% 100.018% ( 1300, 1900 ] 48 0.001% 100.020% ( 1900, 2900 ] 49 0.002% 100.021% ( 2900, 4400 ] 33 0.001% 100.022% ( 4400, 6600 ] 6 0.000% 100.022% ** Level 1 read latency histogram (micros): Count: 1032060 Average: 3.6420 StdDev: 38.46 Min: 1 Median: 1.7070 Max: 7764 Percentiles: P50: 1.71 P75: 2.40 P99: 9.17 P99.9: 150.02 P99.99: 403.67 ------------------------------------------------------ [ 0, 1 ] 71462 6.924% 6.924% # ( 1, 2 ] 628774 60.924% 67.848% ############ ( 2, 3 ] 186337 18.055% 85.903% #### ( 3, 4 ] 59519 5.767% 91.670% # ( 4, 6 ] 60026 5.816% 97.486% # ( 6, 10 ] 19712 1.910% 99.396% ( 10, 15 ] 3584 0.347% 99.744% ( 15, 22 ] 417 0.040% 99.784% ( 22, 34 ] 24 0.002% 99.786% ( 34, 51 ] 9 0.001% 99.787% ( 51, 76 ] 10 0.001% 99.788% ( 76, 110 ] 707 0.069% 99.857% ( 110, 170 ] 670 0.065% 99.922% ( 170, 250 ] 362 0.035% 99.957% ( 250, 380 ] 309 0.030% 99.987% ( 380, 580 ] 294 0.028% 100.015% ( 580, 870 ] 175 0.017% 100.032% ( 870, 1300 ] 106 0.010% 100.042% ( 1300, 1900 ] 77 0.007% 100.050% ( 1900, 2900 ] 47 0.005% 100.054% ( 2900, 4400 ] 33 0.003% 100.058% ( 4400, 6600 ] 8 0.001% 100.058% ( 6600, 9900 ] 2 0.000% 100.059% ** Level 2 read latency histogram (micros): Count: 47989 Average: 2.5599 StdDev: 38.81 Min: 1 Median: 1.3794 Max: 7587 Percentiles: P50: 1.38 P75: 1.78 P99: 6.28 P99.9: 128.29 P99.99: 913.24 ------------------------------------------------------ [ 0, 1 ] 12648 26.356% 26.356% ##### ( 1, 2 ] 29908 62.323% 88.679% ############ ( 2, 3 ] 3308 6.893% 95.572% # ( 3, 4 ] 923 1.923% 97.495% ( 4, 6 ] 696 1.450% 98.946% ( 6, 10 ] 370 0.771% 99.717% ( 10, 15 ] 45 0.094% 99.810% ( 15, 22 ] 11 0.023% 99.833% ( 22, 34 ] 2 0.004% 99.837% ( 34, 51 ] 4 0.008% 99.846% ( 51, 76 ] 1 0.002% 99.848% ( 76, 110 ] 18 0.038% 99.885% ( 110, 170 ] 23 0.048% 99.933% ( 170, 250 ] 9 0.019% 99.952% ( 250, 380 ] 5 0.010% 99.962% ( 380, 580 ] 8 0.017% 99.979% ( 580, 870 ] 5 0.010% 99.990% ( 870, 1300 ] 2 0.004% 99.994% ( 1300, 1900 ] 1 0.002% 99.996% ( 1900, 2900 ] 1 0.002% 99.998% ( 6600, 9900 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 812857 Average: 6.5303 StdDev: 96.80 Min: 0 Median: 1.8878 Max: 11322 Percentiles: P50: 1.89 P75: 2.83 P99: 9.63 P99.9: 289.26 P99.99: 612.25 ------------------------------------------------------ [ 0, 1 ] 32331 3.977% 3.977% # ( 1, 2 ] 421360 51.837% 55.814% ########## ( 2, 3 ] 187365 23.050% 78.865% ##### ( 3, 4 ] 69533 8.554% 87.419% ## ( 4, 6 ] 78938 9.711% 97.130% ## ( 6, 10 ] 16746 2.060% 99.190% ( 10, 15 ] 4222 0.519% 99.709% ( 15, 22 ] 430 0.053% 99.762% ( 22, 34 ] 30 0.004% 99.766% ( 34, 51 ] 12 0.001% 99.767% ( 51, 76 ] 6 0.001% 99.768% ( 76, 110 ] 131 0.016% 99.784% ( 110, 170 ] 456 0.056% 99.840% ( 170, 250 ] 373 0.046% 99.886% ( 250, 380 ] 368 0.045% 99.932% ( 380, 580 ] 427 0.053% 99.984% ( 580, 870 ] 429 0.053% 100.037% ( 870, 1300 ] 334 0.041% 100.078% ( 1300, 1900 ] 194 0.024% 100.102% ( 1900, 2900 ] 221 0.027% 100.129% ( 2900, 4400 ] 175 0.022% 100.151% ( 4400, 6600 ] 42 0.005% 100.156% ( 6600, 9900 ] 20 0.002% 100.158% ( 9900, 14000 ] 6 0.001% 100.159% ** Level 4 read latency histogram (micros): Count: 16435 Average: 174.7590 StdDev: 635.92 Min: 1 Median: 2.3341 Max: 11082 Percentiles: P50: 2.33 P75: 3.90 P99: 3597.00 P99.9: 6148.76 P99.99: 8564.05 ------------------------------------------------------ [ 0, 1 ] 309 1.880% 1.880% ( 1, 2 ] 6556 39.890% 41.771% ######## ( 2, 3 ] 4048 24.630% 66.401% ##### ( 3, 4 ] 1575 9.583% 75.984% ## ( 4, 6 ] 1352 8.226% 84.211% ## ( 6, 10 ] 317 1.929% 86.139% ( 10, 15 ] 122 0.742% 86.882% ( 15, 22 ] 11 0.067% 86.949% ( 22, 34 ] 1 0.006% 86.955% ( 51, 76 ] 1 0.006% 86.961% ( 76, 110 ] 8 0.049% 87.009% ( 110, 170 ] 71 0.432% 87.441% ( 170, 250 ] 148 0.901% 88.342% ( 250, 380 ] 179 1.089% 89.431% ( 380, 580 ] 288 1.752% 91.183% ( 580, 870 ] 395 2.403% 93.587% ( 870, 1300 ] 335 2.038% 95.625% ( 1300, 1900 ] 236 1.436% 97.061% ( 1900, 2900 ] 222 1.351% 98.412% ( 2900, 4400 ] 208 1.266% 99.678% ( 4400, 6600 ] 46 0.280% 99.957% ( 6600, 9900 ] 9 0.055% 100.012% ( 9900, 14000 ] 2 0.012% 100.024% ** Level 5 read latency histogram (micros): Count: 160 Average: 1648.0812 StdDev: 1696.96 Min: 82 Median: 996.4706 Max: 8623 Percentiles: P50: 996.47 P75: 2636.84 P99: 7260.00 P99.9: 8623.00 P99.99: 8623.00 ------------------------------------------------------ ( 76, 110 ] 4 2.500% 2.500% # ( 110, 170 ] 21 13.125% 15.625% ### ( 170, 250 ] 8 5.000% 20.625% # ( 250, 380 ] 13 8.125% 28.750% ## ( 380, 580 ] 15 9.375% 38.125% ## ( 580, 870 ] 14 8.750% 46.875% ## ( 870, 1300 ] 17 10.625% 57.500% ## ( 1300, 1900 ] 14 8.750% 66.250% ## ( 1900, 2900 ] 19 11.875% 78.125% ## ( 2900, 4400 ] 22 13.750% 91.875% ### ( 4400, 6600 ] 11 6.875% 98.750% # ( 6600, 9900 ] 2 1.250% 100.000% ** DB Stats ** Uptime(secs): 39.0 total, 4.1 interval Cumulative writes: 0 writes, 8000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 7.69 GB, 201.91 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:17.075 H:M:S, 43.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 238.86 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:1.351 H:M:S, 32.8 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/19-15:16:45 ... thread 0: (1000000,9000000) ops and (255619.1,210914.6) ops/second in (3.912071,42.671296) 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/6 4.67 GB 245.4 8.3 0.0 8.3 16.9 8.6 0.0 2.0 143.5 292.2 59.25 54.47 152 0.390 8634K 12K 0.0 0.0 L1 9/9 953.25 MB 0.0 4.9 3.7 1.2 4.9 3.7 0.2 1.3 222.5 219.8 22.63 21.42 3 7.544 5114K 62K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.1 0.1 0.1 2.9 2.0 247.9 247.8 0.51 0.49 1 0.508 127K 31 0.0 0.0 L3 23/0 972.44 MB 1.0 4.2 2.7 1.5 4.2 2.7 0.4 1.6 207.5 207.0 20.75 18.43 9 2.306 4373K 9558 0.0 0.0 L4 184/0 9.72 GB 1.0 2.0 2.0 0.1 2.0 2.0 0.9 1.0 117.5 117.4 17.81 9.99 33 0.540 2088K 954 0.0 0.0 L5 1068/0 88.40 GB 0.9 0.0 0.0 0.0 0.0 0.0 2.8 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1302/15 104.66 GB 0.0 19.6 8.5 11.1 28.1 17.0 7.1 3.3 165.9 238.1 120.96 104.80 198 0.611 20M 84K 0.0 0.0 Int 0/0 0.00 KB 0.0 19.6 8.5 11.1 28.1 17.0 7.1 3.3 165.9 238.1 120.96 104.80 198 0.611 20M 84K 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 19.6 8.5 11.1 19.5 8.4 0.0 0.0 212.9 212.0 94.24 82.22 73 1.291 20M 84K 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 330.1 26.72 22.58 125 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): 42.9 total, 42.7 interval Flush(GB): cumulative 8.613, interval 8.613 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: 28.12 GB write, 671.16 MB/s write, 19.59 GB read, 467.63 MB/s read, 121.0 seconds Interval compaction: 28.12 GB write, 674.84 MB/s write, 19.59 GB read, 470.19 MB/s read, 121.0 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 19, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 19, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 50, pending-compaction-bytes-delays: 16, pending-compaction-bytes-stops: 0, total-delays: 35, total-stops: 50, interval: 85 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3658504 Average: 2.6099 StdDev: 19.72 Min: 0 Median: 1.5475 Max: 5965 Percentiles: P50: 1.55 P75: 1.92 P99: 6.48 P99.9: 92.49 P99.99: 235.41 ------------------------------------------------------ [ 0, 1 ] 489957 13.392% 13.392% ### ( 1, 2 ] 2446018 66.858% 80.251% ############# ( 2, 3 ] 430346 11.763% 92.014% ## ( 3, 4 ] 136155 3.722% 95.735% # ( 4, 6 ] 115791 3.165% 98.900% # ( 6, 10 ] 30552 0.835% 99.735% ( 10, 15 ] 4534 0.124% 99.859% ( 15, 22 ] 557 0.015% 99.874% ( 22, 34 ] 37 0.001% 99.875% ( 34, 51 ] 16 0.000% 99.876% ( 51, 76 ] 22 0.001% 99.876% ( 76, 110 ] 1774 0.048% 99.925% ( 110, 170 ] 1954 0.053% 99.978% ( 170, 250 ] 520 0.014% 99.993% ( 250, 380 ] 297 0.008% 100.001% ( 380, 580 ] 365 0.010% 100.011% ( 580, 870 ] 201 0.005% 100.016% ( 870, 1300 ] 110 0.003% 100.019% ( 1300, 1900 ] 51 0.001% 100.021% ( 1900, 2900 ] 51 0.001% 100.022% ( 2900, 4400 ] 34 0.001% 100.023% ( 4400, 6600 ] 6 0.000% 100.023% ** Level 1 read latency histogram (micros): Count: 1105579 Average: 3.5861 StdDev: 37.27 Min: 1 Median: 1.6996 Max: 7764 Percentiles: P50: 1.70 P75: 2.37 P99: 9.14 P99.9: 149.98 P99.99: 408.30 ------------------------------------------------------ [ 0, 1 ] 77699 7.028% 7.028% # ( 1, 2 ] 679114 61.426% 68.454% ############ ( 2, 3 ] 197072 17.825% 86.279% #### ( 3, 4 ] 61864 5.596% 91.875% # ( 4, 6 ] 62316 5.637% 97.511% # ( 6, 10 ] 20936 1.894% 99.405% ( 10, 15 ] 3731 0.337% 99.742% ( 15, 22 ] 426 0.039% 99.781% ( 22, 34 ] 24 0.002% 99.783% ( 34, 51 ] 9 0.001% 99.784% ( 51, 76 ] 11 0.001% 99.785% ( 76, 110 ] 775 0.070% 99.855% ( 110, 170 ] 745 0.067% 99.922% ( 170, 250 ] 379 0.034% 99.957% ( 250, 380 ] 324 0.029% 99.986% ( 380, 580 ] 307 0.028% 100.014% ( 580, 870 ] 177 0.016% 100.030% ( 870, 1300 ] 107 0.010% 100.040% ( 1300, 1900 ] 77 0.007% 100.046% ( 1900, 2900 ] 47 0.004% 100.051% ( 2900, 4400 ] 33 0.003% 100.054% ( 4400, 6600 ] 8 0.001% 100.054% ( 6600, 9900 ] 2 0.000% 100.055% ** Level 2 read latency histogram (micros): Count: 47989 Average: 2.5599 StdDev: 38.81 Min: 1 Median: 1.3794 Max: 7587 Percentiles: P50: 1.38 P75: 1.78 P99: 6.28 P99.9: 128.29 P99.99: 913.24 ------------------------------------------------------ [ 0, 1 ] 12648 26.356% 26.356% ##### ( 1, 2 ] 29908 62.323% 88.679% ############ ( 2, 3 ] 3308 6.893% 95.572% # ( 3, 4 ] 923 1.923% 97.495% ( 4, 6 ] 696 1.450% 98.946% ( 6, 10 ] 370 0.771% 99.717% ( 10, 15 ] 45 0.094% 99.810% ( 15, 22 ] 11 0.023% 99.833% ( 22, 34 ] 2 0.004% 99.837% ( 34, 51 ] 4 0.008% 99.846% ( 51, 76 ] 1 0.002% 99.848% ( 76, 110 ] 18 0.038% 99.885% ( 110, 170 ] 23 0.048% 99.933% ( 170, 250 ] 9 0.019% 99.952% ( 250, 380 ] 5 0.010% 99.962% ( 380, 580 ] 8 0.017% 99.979% ( 580, 870 ] 5 0.010% 99.990% ( 870, 1300 ] 2 0.004% 99.994% ( 1300, 1900 ] 1 0.002% 99.996% ( 1900, 2900 ] 1 0.002% 99.998% ( 6600, 9900 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 812857 Average: 6.5303 StdDev: 96.80 Min: 0 Median: 1.8878 Max: 11322 Percentiles: P50: 1.89 P75: 2.83 P99: 9.63 P99.9: 289.26 P99.99: 612.25 ------------------------------------------------------ [ 0, 1 ] 32331 3.977% 3.977% # ( 1, 2 ] 421360 51.837% 55.814% ########## ( 2, 3 ] 187365 23.050% 78.865% ##### ( 3, 4 ] 69533 8.554% 87.419% ## ( 4, 6 ] 78938 9.711% 97.130% ## ( 6, 10 ] 16746 2.060% 99.190% ( 10, 15 ] 4222 0.519% 99.709% ( 15, 22 ] 430 0.053% 99.762% ( 22, 34 ] 30 0.004% 99.766% ( 34, 51 ] 12 0.001% 99.767% ( 51, 76 ] 6 0.001% 99.768% ( 76, 110 ] 131 0.016% 99.784% ( 110, 170 ] 456 0.056% 99.840% ( 170, 250 ] 373 0.046% 99.886% ( 250, 380 ] 368 0.045% 99.932% ( 380, 580 ] 427 0.053% 99.984% ( 580, 870 ] 429 0.053% 100.037% ( 870, 1300 ] 334 0.041% 100.078% ( 1300, 1900 ] 194 0.024% 100.102% ( 1900, 2900 ] 221 0.027% 100.129% ( 2900, 4400 ] 175 0.022% 100.151% ( 4400, 6600 ] 42 0.005% 100.156% ( 6600, 9900 ] 20 0.002% 100.158% ( 9900, 14000 ] 6 0.001% 100.159% ** Level 4 read latency histogram (micros): Count: 16435 Average: 174.7590 StdDev: 635.92 Min: 1 Median: 2.3341 Max: 11082 Percentiles: P50: 2.33 P75: 3.90 P99: 3597.00 P99.9: 6148.76 P99.99: 8564.05 ------------------------------------------------------ [ 0, 1 ] 309 1.880% 1.880% ( 1, 2 ] 6556 39.890% 41.771% ######## ( 2, 3 ] 4048 24.630% 66.401% ##### ( 3, 4 ] 1575 9.583% 75.984% ## ( 4, 6 ] 1352 8.226% 84.211% ## ( 6, 10 ] 317 1.929% 86.139% ( 10, 15 ] 122 0.742% 86.882% ( 15, 22 ] 11 0.067% 86.949% ( 22, 34 ] 1 0.006% 86.955% ( 51, 76 ] 1 0.006% 86.961% ( 76, 110 ] 8 0.049% 87.009% ( 110, 170 ] 71 0.432% 87.441% ( 170, 250 ] 148 0.901% 88.342% ( 250, 380 ] 179 1.089% 89.431% ( 380, 580 ] 288 1.752% 91.183% ( 580, 870 ] 395 2.403% 93.587% ( 870, 1300 ] 335 2.038% 95.625% ( 1300, 1900 ] 236 1.436% 97.061% ( 1900, 2900 ] 222 1.351% 98.412% ( 2900, 4400 ] 208 1.266% 99.678% ( 4400, 6600 ] 46 0.280% 99.957% ( 6600, 9900 ] 9 0.055% 100.012% ( 9900, 14000 ] 2 0.012% 100.024% ** Level 5 read latency histogram (micros): Count: 160 Average: 1648.0812 StdDev: 1696.96 Min: 82 Median: 996.4706 Max: 8623 Percentiles: P50: 996.47 P75: 2636.84 P99: 7260.00 P99.9: 8623.00 P99.99: 8623.00 ------------------------------------------------------ ( 76, 110 ] 4 2.500% 2.500% # ( 110, 170 ] 21 13.125% 15.625% ### ( 170, 250 ] 8 5.000% 20.625% # ( 250, 380 ] 13 8.125% 28.750% ## ( 380, 580 ] 15 9.375% 38.125% ## ( 580, 870 ] 14 8.750% 46.875% ## ( 870, 1300 ] 17 10.625% 57.500% ## ( 1300, 1900 ] 14 8.750% 66.250% ## ( 1900, 2900 ] 19 11.875% 78.125% ## ( 2900, 4400 ] 22 13.750% 91.875% ### ( 4400, 6600 ] 11 6.875% 98.750% # ( 6600, 9900 ] 2 1.250% 100.000% ** DB Stats ** Uptime(secs): 42.9 total, 3.9 interval Cumulative writes: 0 writes, 9000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 8.65 GB, 206.44 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:18.311 H:M:S, 42.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 251.57 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:1.236 H:M:S, 31.6 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/11/19-15:16:55 ... thread 0: (1000000,10000000) ops and (104193.1,191318.5) ops/second in (9.597560,52.268856) 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/16 3.32 GB 50.4 8.8 0.0 8.8 18.3 9.5 0.0 1.9 140.7 293.0 64.01 58.77 167 0.383 9145K 12K 0.0 0.0 L1 24/24 2.42 GB 0.0 8.1 6.0 2.1 8.0 5.9 0.2 1.3 219.7 217.0 37.83 35.47 4 9.458 7473K 62K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.1 0.1 0.1 3.7 2.0 247.9 247.8 0.51 0.49 1 0.508 127K 31 0.0 0.0 L3 21/0 922.70 MB 0.9 5.5 3.3 2.2 5.5 3.3 0.4 1.6 204.9 204.2 27.64 24.53 16 1.728 5754K 20K 0.0 0.0 L4 182/0 9.45 GB 1.0 2.8 2.8 0.1 2.8 2.8 0.9 1.0 130.0 129.9 22.42 13.82 44 0.510 2907K 1414 0.0 0.0 L5 1080/0 89.45 GB 0.9 0.0 0.0 0.0 0.0 0.0 3.8 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1326/40 105.53 GB 0.0 25.4 12.2 13.2 34.8 21.6 9.0 3.7 170.8 233.9 152.42 133.08 232 0.657 25M 97K 0.0 0.0 Int 0/0 0.00 KB 0.0 25.4 12.2 13.2 34.8 21.6 9.0 3.7 170.8 233.9 152.42 133.08 232 0.657 25M 97K 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.4 12.2 13.2 25.3 12.1 0.0 0.0 212.0 210.8 122.79 108.02 94 1.306 25M 97K 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 329.6 29.63 25.06 138 0.215 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.5 total, 52.3 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.81 GB write, 679.00 MB/s write, 25.42 GB read, 495.73 MB/s read, 152.4 seconds Interval compaction: 34.81 GB write, 682.04 MB/s write, 25.42 GB read, 497.95 MB/s read, 152.4 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 21, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 21, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 53, pending-compaction-bytes-delays: 31, pending-compaction-bytes-stops: 0, total-delays: 52, total-stops: 53, interval: 105 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 4157308 Average: 2.6690 StdDev: 20.79 Min: 0 Median: 1.5487 Max: 5965 Percentiles: P50: 1.55 P75: 1.92 P99: 6.72 P99.9: 97.09 P99.99: 359.87 ------------------------------------------------------ [ 0, 1 ] 557725 13.416% 13.416% ### ( 1, 2 ] 2771659 66.670% 80.085% ############# ( 2, 3 ] 491348 11.819% 91.904% ## ( 3, 4 ] 155180 3.733% 95.637% # ( 4, 6 ] 133260 3.205% 98.842% # ( 6, 10 ] 36683 0.882% 99.725% ( 10, 15 ] 5408 0.130% 99.855% ( 15, 22 ] 666 0.016% 99.871% ( 22, 34 ] 44 0.001% 99.872% ( 34, 51 ] 18 0.000% 99.872% ( 51, 76 ] 23 0.001% 99.873% ( 76, 110 ] 1834 0.044% 99.917% ( 110, 170 ] 2065 0.050% 99.966% ( 170, 250 ] 627 0.015% 99.982% ( 250, 380 ] 418 0.010% 99.992% ( 380, 580 ] 523 0.013% 100.004% ( 580, 870 ] 341 0.008% 100.012% ( 870, 1300 ] 181 0.004% 100.017% ( 1300, 1900 ] 87 0.002% 100.019% ( 1900, 2900 ] 60 0.001% 100.020% ( 2900, 4400 ] 37 0.001% 100.021% ( 4400, 6600 ] 6 0.000% 100.021% ** Level 1 read latency histogram (micros): Count: 1455418 Average: 3.5338 StdDev: 34.96 Min: 1 Median: 1.6729 Max: 7764 Percentiles: P50: 1.67 P75: 2.30 P99: 9.17 P99.9: 153.58 P99.99: 378.44 ------------------------------------------------------ [ 0, 1 ] 129351 8.888% 8.888% ## ( 1, 2 ] 889162 61.093% 69.981% ############ ( 2, 3 ] 241881 16.619% 86.600% ### ( 3, 4 ] 78986 5.427% 92.027% # ( 4, 6 ] 79429 5.457% 97.485% # ( 6, 10 ] 27822 1.912% 99.396% ( 10, 15 ] 4884 0.336% 99.732% ( 15, 22 ] 604 0.042% 99.773% ( 22, 34 ] 35 0.002% 99.776% ( 34, 51 ] 11 0.001% 99.776% ( 51, 76 ] 12 0.001% 99.777% ( 76, 110 ] 975 0.067% 99.844% ( 110, 170 ] 1116 0.077% 99.921% ( 170, 250 ] 547 0.038% 99.959% ( 250, 380 ] 463 0.032% 99.990% ( 380, 580 ] 419 0.029% 100.019% ( 580, 870 ] 237 0.016% 100.035% ( 870, 1300 ] 150 0.010% 100.046% ( 1300, 1900 ] 102 0.007% 100.053% ( 1900, 2900 ] 51 0.004% 100.056% ( 2900, 4400 ] 36 0.002% 100.059% ( 4400, 6600 ] 8 0.001% 100.059% ( 6600, 9900 ] 2 0.000% 100.059% ** Level 2 read latency histogram (micros): Count: 47989 Average: 2.5599 StdDev: 38.81 Min: 1 Median: 1.3794 Max: 7587 Percentiles: P50: 1.38 P75: 1.78 P99: 6.28 P99.9: 128.29 P99.99: 913.24 ------------------------------------------------------ [ 0, 1 ] 12648 26.356% 26.356% ##### ( 1, 2 ] 29908 62.323% 88.679% ############ ( 2, 3 ] 3308 6.893% 95.572% # ( 3, 4 ] 923 1.923% 97.495% ( 4, 6 ] 696 1.450% 98.946% ( 6, 10 ] 370 0.771% 99.717% ( 10, 15 ] 45 0.094% 99.810% ( 15, 22 ] 11 0.023% 99.833% ( 22, 34 ] 2 0.004% 99.837% ( 34, 51 ] 4 0.008% 99.846% ( 51, 76 ] 1 0.002% 99.848% ( 76, 110 ] 18 0.038% 99.885% ( 110, 170 ] 23 0.048% 99.933% ( 170, 250 ] 9 0.019% 99.952% ( 250, 380 ] 5 0.010% 99.962% ( 380, 580 ] 8 0.017% 99.979% ( 580, 870 ] 5 0.010% 99.990% ( 870, 1300 ] 2 0.004% 99.994% ( 1300, 1900 ] 1 0.002% 99.996% ( 1900, 2900 ] 1 0.002% 99.998% ( 6600, 9900 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 1187601 Average: 5.7994 StdDev: 82.33 Min: 0 Median: 1.9011 Max: 11322 Percentiles: P50: 1.90 P75: 2.85 P99: 9.56 P99.9: 184.55 P99.99: 405.42 ------------------------------------------------------ [ 0, 1 ] 39712 3.344% 3.344% # ( 1, 2 ] 614894 51.776% 55.120% ########## ( 2, 3 ] 277804 23.392% 78.512% ##### ( 3, 4 ] 103468 8.712% 87.224% ## ( 4, 6 ] 117419 9.887% 97.111% ## ( 6, 10 ] 25213 2.123% 99.235% ( 10, 15 ] 6207 0.523% 99.757% ( 15, 22 ] 663 0.056% 99.813% ( 22, 34 ] 43 0.004% 99.817% ( 34, 51 ] 13 0.001% 99.818% ( 51, 76 ] 9 0.001% 99.818% ( 76, 110 ] 191 0.016% 99.835% ( 110, 170 ] 677 0.057% 99.892% ( 170, 250 ] 552 0.046% 99.938% ( 250, 380 ] 542 0.046% 99.984% ( 380, 580 ] 592 0.050% 100.034% ( 580, 870 ] 539 0.045% 100.079% ( 870, 1300 ] 412 0.035% 100.114% ( 1300, 1900 ] 239 0.020% 100.134% ( 1900, 2900 ] 238 0.020% 100.154% ( 2900, 4400 ] 177 0.015% 100.169% ( 4400, 6600 ] 42 0.004% 100.172% ( 6600, 9900 ] 20 0.002% 100.174% ( 9900, 14000 ] 6 0.001% 100.174% ** Level 4 read latency histogram (micros): Count: 23316 Average: 140.3468 StdDev: 548.91 Min: 0 Median: 2.2812 Max: 11082 Percentiles: P50: 2.28 P75: 3.82 P99: 3117.18 P99.9: 5695.85 P99.99: 7211.75 ------------------------------------------------------ [ 0, 1 ] 459 1.969% 1.969% ( 1, 2 ] 9621 41.264% 43.232% ######## ( 2, 3 ] 5611 24.065% 67.297% ##### ( 3, 4 ] 2195 9.414% 76.711% ## ( 4, 6 ] 1805 7.741% 84.453% ## ( 6, 10 ] 445 1.909% 86.361% ( 10, 15 ] 157 0.673% 87.035% ( 15, 22 ] 18 0.077% 87.112% ( 22, 34 ] 1 0.004% 87.116% ( 51, 76 ] 1 0.004% 87.120% ( 76, 110 ] 28 0.120% 87.241% ( 110, 170 ] 226 0.969% 88.210% ( 170, 250 ] 321 1.377% 89.587% ( 250, 380 ] 317 1.360% 90.946% ( 380, 580 ] 463 1.986% 92.932% ( 580, 870 ] 520 2.230% 95.162% ( 870, 1300 ] 387 1.660% 96.822% ( 1300, 1900 ] 248 1.064% 97.886% ( 1900, 2900 ] 229 0.982% 98.868% ( 2900, 4400 ] 213 0.914% 99.781% ( 4400, 6600 ] 47 0.202% 99.983% ( 6600, 9900 ] 9 0.039% 100.021% ( 9900, 14000 ] 2 0.009% 100.030% ** Level 5 read latency histogram (micros): Count: 220 Average: 1444.0091 StdDev: 1601.31 Min: 82 Median: 767.6471 Max: 8623 Percentiles: P50: 767.65 P75: 2280.95 P99: 6560.00 P99.9: 8623.00 P99.99: 8623.00 ------------------------------------------------------ ( 76, 110 ] 7 3.182% 3.182% # ( 110, 170 ] 37 16.818% 20.000% ### ( 170, 250 ] 16 7.273% 27.273% # ( 250, 380 ] 18 8.182% 35.455% ## ( 380, 580 ] 21 9.545% 45.000% ## ( 580, 870 ] 17 7.727% 52.727% ## ( 870, 1300 ] 22 10.000% 62.727% ## ( 1300, 1900 ] 19 8.636% 71.364% ## ( 1900, 2900 ] 21 9.545% 80.909% ## ( 2900, 4400 ] 29 13.182% 94.091% ### ( 4400, 6600 ] 11 5.000% 99.091% # ( 6600, 9900 ] 2 0.909% 100.000% ** DB Stats ** Uptime(secs): 52.5 total, 9.6 interval Cumulative writes: 0 writes, 10M keys, 0 commit groups, 0.0 writes per commit group, ingest: 9.61 GB, 187.45 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:25.006 H:M:S, 47.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 102.55 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:6.695 H:M:S, 69.8 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 using bdev Nvme0n1 Initializing RocksDB Options from the specified file Initializing RocksDB Options from command-line flags Integrated BlobDB: blob cache disabled Keys: 16 bytes each (+ 0 bytes user-defined timestamp) Values: 1000 bytes each (1000 bytes after compression) Entries: 100000000 Prefix: 0 bytes Keys per prefix: 0 RawSize: 96893.3 MB (estimated) FileSize: 96893.3 MB (estimated) Write rate: 0 bytes/second Read rate: 0 ops/second Compression: NoCompression Compression sampling rate: 0 Memtablerep: SkipListFactory Perf Level: 1 ------------------------------------------------ DB path: [/mnt/rocksdb] overwrite : 5.819 micros/op 171855 ops/sec 60.010 seconds 10312999 operations; 166.5 MB/s Microseconds per write: Count: 10312999 Average: 5.8188 StdDev: 331.06 Min: 0 Median: 1.7271 Max: 544646 Percentiles: P50: 1.73 P75: 2.72 P99: 9.59 P99.9: 1145.41 P99.99: 2612.16 ------------------------------------------------------ [ 0, 1 ] 1457424 14.132% 14.132% ### ( 1, 2 ] 5087376 49.330% 63.462% ########## ( 2, 3 ] 1648322 15.983% 79.445% ### ( 3, 4 ] 1375786 13.340% 92.785% ### ( 4, 6 ] 523964 5.081% 97.866% # ( 6, 10 ] 130474 1.265% 99.131% ( 10, 15 ] 44660 0.433% 99.564% ( 15, 22 ] 10152 0.098% 99.662% ( 22, 34 ] 1627 0.016% 99.678% ( 34, 51 ] 208 0.002% 99.680% ( 51, 76 ] 33 0.000% 99.680% ( 76, 110 ] 7374 0.072% 99.752% ( 110, 170 ] 2610 0.025% 99.777% ( 170, 250 ] 266 0.003% 99.780% ( 250, 380 ] 192 0.002% 99.782% ( 380, 580 ] 28 0.000% 99.782% ( 580, 870 ] 22 0.000% 99.782% ( 870, 1300 ] 18998 0.184% 99.966% ( 1300, 1900 ] 51 0.000% 99.967% ( 1900, 2900 ] 3371 0.033% 99.999% ( 2900, 4400 ] 26 0.000% 100.000% ( 4400, 6600 ] 6 0.000% 100.000% ( 6600, 9900 ] 1 0.000% 100.000% ( 9900, 14000 ] 3 0.000% 100.000% ( 14000, 22000 ] 2 0.000% 100.000% ( 22000, 33000 ] 3 0.000% 100.000% ( 33000, 50000 ] 1 0.000% 100.000% ( 110000, 170000 ] 2 0.000% 100.000% ( 170000, 250000 ] 14 0.000% 100.000% ( 250000, 380000 ] 2 0.000% 100.000% ( 380000, 570000 ] 1 0.000% 100.000% STATISTICS: rocksdb.block.cache.miss COUNT : 0 rocksdb.block.cache.hit COUNT : 0 rocksdb.block.cache.add COUNT : 0 rocksdb.block.cache.add.failures COUNT : 0 rocksdb.block.cache.index.miss COUNT : 0 rocksdb.block.cache.index.hit COUNT : 0 rocksdb.block.cache.index.add COUNT : 0 rocksdb.block.cache.index.bytes.insert COUNT : 0 rocksdb.block.cache.filter.miss COUNT : 0 rocksdb.block.cache.filter.hit COUNT : 0 rocksdb.block.cache.filter.add COUNT : 0 rocksdb.block.cache.filter.bytes.insert COUNT : 0 rocksdb.block.cache.data.miss COUNT : 0 rocksdb.block.cache.data.hit COUNT : 0 rocksdb.block.cache.data.add COUNT : 0 rocksdb.block.cache.data.bytes.insert COUNT : 0 rocksdb.block.cache.bytes.read COUNT : 0 rocksdb.block.cache.bytes.write COUNT : 0 rocksdb.bloom.filter.useful COUNT : 0 rocksdb.bloom.filter.full.positive COUNT : 0 rocksdb.bloom.filter.full.true.positive COUNT : 0 rocksdb.persistent.cache.hit COUNT : 0 rocksdb.persistent.cache.miss COUNT : 0 rocksdb.sim.block.cache.hit COUNT : 0 rocksdb.sim.block.cache.miss COUNT : 0 rocksdb.memtable.hit COUNT : 0 rocksdb.memtable.miss COUNT : 0 rocksdb.l0.hit COUNT : 0 rocksdb.l1.hit COUNT : 0 rocksdb.l2andup.hit COUNT : 0 rocksdb.compaction.key.drop.new COUNT : 188663 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 : 10312999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 10643014968 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 : 560 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 31797281 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 : 30702550160 rocksdb.compact.write.bytes COUNT : 30519387517 rocksdb.flush.write.bytes COUNT : 10635363074 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 : 53 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 : 279 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 : 10549565440 rocksdb.memtable.garbage.bytes.at.flush COUNT : 4060160 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 : 30797820602 rocksdb.non.last.level.read.count COUNT : 7440658 rocksdb.block.checksum.compute.count COUNT : 7439591 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.376838 P95 : 3.915510 P99 : 8.273654 P100 : 544644.000000 COUNT : 10312999 SUM : 55273486 rocksdb.compaction.times.micros P50 : 827777.777778 P95 : 4076000.000000 P99 : 16419138.000000 P100 : 16419138.000000 COUNT : 96 SUM : 124657709 rocksdb.compaction.times.cpu_micros P50 : 666666.666667 P95 : 3926666.666667 P99 : 15411432.000000 P100 : 15411432.000000 COUNT : 96 SUM : 109854050 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 : 697.567568 P95 : 1711.428571 P99 : 94600.000000 P100 : 122268.000000 COUNT : 144 SUM : 327729 rocksdb.compaction.outfile.sync.micros P50 : 978.434783 P95 : 18685.714286 P99 : 100900.000000 P100 : 146938.000000 COUNT : 378 SUM : 1869415 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 : 115.689655 P95 : 1251.625000 P99 : 3555.000000 P100 : 5558.000000 COUNT : 269 SUM : 75229 rocksdb.table.open.io.micros P50 : 1407.142857 P95 : 9300.000000 P99 : 21600.000000 P100 : 22885.000000 COUNT : 560 SUM : 1348889 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.664974 P95 : 7.694321 P99 : 11.601104 P100 : 12491.000000 COUNT : 7438084 SUM : 42959905 rocksdb.read.block.get.micros P50 : 480.000000 P95 : 4008.695652 P99 : 9240.000000 P100 : 11406.000000 COUNT : 1120 SUM : 1118737 rocksdb.write.raw.block.micros P50 : 0.513274 P95 : 0.975220 P99 : 2.928026 P100 : 12760.000000 COUNT : 9967694 SUM : 19524606 rocksdb.numfiles.in.singlecompaction P50 : 3.000000 P95 : 6.800000 P99 : 30.640000 P100 : 36.000000 COUNT : 128 SUM : 469 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.558903 P95 : 1135.803687 P99 : 2278.263580 P100 : 544462.000000 COUNT : 213863 SUM : 31816820 rocksdb.sst.read.micros P50 : 1.606254 P95 : 4.616522 P99 : 8.518484 P100 : 11322.000000 COUNT : 7440996 SUM : 28174553 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 : 10312999 SUM : 10643014968 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 : 213018.867925 P95 : 370823.529412 P99 : 553280.000000 P100 : 673288.000000 COUNT : 144 SUM : 30745020 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 : 343 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