[2024-12-16 03:24:02.711194] Starting SPDK v24.01.1-pre git sha1 c13c99a5e / DPDK 22.11.4 initialization... [2024-12-16 03:24:02.711456] [ 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_pid694156 ] Set seed to 1734315842704606 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-12-16 03:24:02.805420] app.c: 798:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-12-16 03:24:02.841156] app.c: 488:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-12-16 03:24:02.841201] app.c: 489:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 694156' to capture a snapshot of events at runtime. [2024-12-16 03:24:02.841212] app.c: 494:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid694156 for offline analysis/debug. [2024-12-16 03:24:02.841238] reactor.c: 937:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Mon Dec 16 03:24:07 2024 CPU: 96 * Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz CPUCache: 36608 KB 2024/12/16-03:24:10 ... thread 0: (1000000,1000000) ops and (337045.7,337045.7) ops/second in (2.966957,2.966957) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 8/5 566.97 MB 25.2 0.0 0.0 0.0 0.9 0.9 0.0 1.0 0.0 351.9 2.51 2.27 12 0.209 0 0 0.0 0.0 L1 3/3 251.75 MB 0.0 0.2 0.2 0.1 0.2 0.2 0.1 1.3 263.7 263.4 0.96 0.93 1 0.956 255K 202 0.0 0.0 L2 1/0 48.75 MB 0.5 0.1 0.1 0.0 0.1 0.1 0.0 1.8 245.7 245.6 0.45 0.43 1 0.453 113K 27 0.0 0.0 L3 17/0 818.48 MB 0.8 0.1 0.1 0.0 0.1 0.1 0.0 1.0 208.8 208.9 0.30 0.25 1 0.299 63K 0 0.0 0.0 L4 116/0 9.54 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1044/0 85.82 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1189/8 97.00 GB 0.0 0.4 0.3 0.1 1.3 1.2 0.2 1.5 101.0 310.2 4.21 3.87 15 0.281 432K 229 0.0 0.0 Int 0/0 0.00 KB 0.0 0.4 0.3 0.1 1.3 1.2 0.2 1.5 101.0 310.2 4.21 3.87 15 0.281 432K 229 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 0.4 0.3 0.1 0.4 0.3 0.0 0.0 249.3 249.1 1.71 1.61 3 0.569 432K 229 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 0.9 0.9 0.0 0.0 0.0 351.9 2.51 2.27 12 0.209 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.1 total, 3.0 interval Flush(GB): cumulative 0.861, interval 0.861 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 1.28 GB write, 415.23 MB/s write, 0.42 GB read, 135.23 MB/s read, 4.2 seconds Interval compaction: 1.28 GB write, 440.41 MB/s write, 0.42 GB read, 143.43 MB/s read, 4.2 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 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: 107596 Average: 1.7508 StdDev: 16.59 Min: 1 Median: 1.1078 Max: 3631 Percentiles: P50: 1.11 P75: 1.58 P99: 3.19 P99.9: 8.85 P99.99: 290.31 ------------------------------------------------------ [ 0, 1 ] 47684 44.318% 44.318% ######### ( 1, 2 ] 56725 52.720% 97.038% ########### ( 2, 3 ] 1976 1.836% 98.874% ( 3, 4 ] 725 0.674% 99.548% ( 4, 6 ] 263 0.244% 99.793% ( 6, 10 ] 162 0.151% 99.943% ( 10, 15 ] 25 0.023% 99.967% ( 15, 22 ] 9 0.008% 99.975% ( 22, 34 ] 1 0.001% 99.976% ( 34, 51 ] 1 0.001% 99.977% ( 51, 76 ] 1 0.001% 99.978% ( 110, 170 ] 7 0.007% 99.984% ( 170, 250 ] 5 0.005% 99.989% ( 250, 380 ] 4 0.004% 99.993% ( 380, 580 ] 2 0.002% 99.994% ( 580, 870 ] 2 0.002% 99.996% ( 870, 1300 ] 1 0.001% 99.997% ( 1300, 1900 ] 1 0.001% 99.998% ( 2900, 4400 ] 2 0.002% 100.000% ** Level 1 read latency histogram (micros): Count: 34464 Average: 2.0589 StdDev: 17.17 Min: 0 Median: 1.1437 Max: 2123 Percentiles: P50: 1.14 P75: 1.62 P99: 5.62 P99.9: 61.67 P99.99: 949.35 ------------------------------------------------------ [ 0, 1 ] 14611 42.395% 42.395% ######## ( 1, 2 ] 18234 52.907% 95.302% ########### ( 2, 3 ] 912 2.646% 97.949% # ( 3, 4 ] 267 0.775% 98.723% ( 4, 6 ] 118 0.342% 99.066% ( 6, 10 ] 205 0.595% 99.661% ( 10, 15 ] 34 0.099% 99.759% ( 15, 22 ] 6 0.017% 99.777% ( 22, 34 ] 2 0.006% 99.782% ( 34, 51 ] 32 0.093% 99.875% ( 51, 76 ] 20 0.058% 99.933% ( 76, 110 ] 2 0.006% 99.939% ( 110, 170 ] 3 0.009% 99.948% ( 170, 250 ] 8 0.023% 99.971% ( 250, 380 ] 3 0.009% 99.980% ( 380, 580 ] 1 0.003% 99.983% ( 580, 870 ] 2 0.006% 99.988% ( 870, 1300 ] 3 0.009% 99.997% ( 1900, 2900 ] 1 0.003% 100.000% ** Level 2 read latency histogram (micros): Count: 15886 Average: 1.6401 StdDev: 3.17 Min: 1 Median: 1.0771 Max: 228 Percentiles: P50: 1.08 P75: 1.57 P99: 3.06 P99.9: 8.43 P99.99: 207.64 ------------------------------------------------------ [ 0, 1 ] 7323 46.097% 46.097% ######### ( 1, 2 ] 8044 50.636% 96.733% ########## ( 2, 3 ] 354 2.228% 98.961% ( 3, 4 ] 109 0.686% 99.647% ( 4, 6 ] 31 0.195% 99.843% ( 6, 10 ] 15 0.094% 99.937% ( 10, 15 ] 4 0.025% 99.962% ( 15, 22 ] 2 0.013% 99.975% ( 110, 170 ] 1 0.006% 99.981% ( 170, 250 ] 3 0.019% 100.000% ** Level 3 read latency histogram (micros): Count: 85 Average: 765.2706 StdDev: 1108.43 Min: 0 Median: 304.1667 Max: 3987 Percentiles: P50: 304.17 P75: 1058.12 P99: 3987.00 P99.9: 3987.00 P99.99: 3987.00 ------------------------------------------------------ [ 0, 1 ] 29 34.118% 34.118% ####### ( 1, 2 ] 7 8.235% 42.353% ## ( 3, 4 ] 1 1.176% 43.529% ( 110, 170 ] 2 2.353% 45.882% ( 170, 250 ] 1 1.176% 47.059% ( 250, 380 ] 6 7.059% 54.118% # ( 380, 580 ] 10 11.765% 65.882% ## ( 580, 870 ] 6 7.059% 72.941% # ( 870, 1300 ] 4 4.706% 77.647% # ( 1300, 1900 ] 4 4.706% 82.353% # ( 1900, 2900 ] 8 9.412% 91.765% ## ( 2900, 4400 ] 7 8.235% 100.000% ## ** Level 4 read latency histogram (micros): Count: 30 Average: 1657.6000 StdDev: 1248.89 Min: 186 Median: 1246.2500 Max: 4899 Percentiles: P50: 1246.25 P75: 2275.00 P99: 4899.00 P99.9: 4899.00 P99.99: 4899.00 ------------------------------------------------------ ( 170, 250 ] 1 3.333% 3.333% # ( 250, 380 ] 1 3.333% 6.667% # ( 380, 580 ] 3 10.000% 16.667% ## ( 580, 870 ] 3 10.000% 26.667% ## ( 870, 1300 ] 8 26.667% 53.333% ##### ( 1300, 1900 ] 5 16.667% 70.000% ### ( 1900, 2900 ] 4 13.333% 83.333% ### ( 2900, 4400 ] 3 10.000% 93.333% ## ( 4400, 6600 ] 2 6.667% 100.000% # ** DB Stats ** Uptime(secs): 3.1 total, 3.0 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 312.50 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.373 H:M:S, 11.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 331.42 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.373 H:M:S, 12.6 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/12/16-03:24:12 ... thread 0: (1000000,2000000) ops and (346480.7,341698.0) ops/second in (2.886164,5.853121) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 11/8 1.17 GB 62.9 0.6 0.0 0.6 2.3 1.8 0.0 1.3 77.7 327.9 7.30 6.70 28 0.261 575K 600 0.0 0.0 L1 2/0 50.34 MB 5.0 0.8 0.5 0.3 0.8 0.5 0.1 1.6 251.8 251.3 3.25 3.17 2 1.626 831K 1475 0.0 0.0 L2 5/4 563.82 MB 1.3 0.1 0.1 0.0 0.1 0.1 0.6 1.8 245.7 245.6 0.45 0.43 1 0.453 113K 27 0.0 0.0 L3 17/10 818.48 MB 0.0 0.1 0.1 0.0 0.1 0.1 0.0 1.0 208.8 208.9 0.30 0.25 1 0.299 63K 0 0.0 0.0 L4 116/0 9.54 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1044/0 85.82 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1195/22 97.92 GB 0.0 1.5 0.6 0.9 3.3 2.4 0.7 1.9 138.0 299.4 11.30 10.55 32 0.353 1583K 2102 0.0 0.0 Int 0/0 0.00 KB 0.0 1.5 0.6 0.9 3.3 2.4 0.7 1.9 138.0 299.4 11.30 10.55 32 0.353 1583K 2102 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 1.5 0.6 0.9 1.5 0.6 0.0 0.0 254.0 253.7 6.14 5.94 6 1.023 1583K 2102 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.7 5.16 4.61 26 0.199 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 6.0 total, 5.9 interval Flush(GB): cumulative 1.784, interval 1.784 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 3.30 GB write, 560.77 MB/s write, 1.52 GB read, 258.42 MB/s read, 11.3 seconds Interval compaction: 3.30 GB write, 578.02 MB/s write, 1.52 GB read, 266.36 MB/s read, 11.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: 6, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 6, interval: 6 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 390266 Average: 2.0778 StdDev: 12.49 Min: 1 Median: 1.3944 Max: 3631 Percentiles: P50: 1.39 P75: 1.81 P99: 5.62 P99.9: 10.08 P99.99: 15.94 ------------------------------------------------------ [ 0, 1 ] 101758 26.074% 26.074% ##### ( 1, 2 ] 236783 60.672% 86.746% ############ ( 2, 3 ] 27160 6.959% 93.706% # ( 3, 4 ] 13711 3.513% 97.219% # ( 4, 6 ] 8607 2.205% 99.424% ( 6, 10 ] 1852 0.475% 99.899% ( 10, 15 ] 350 0.090% 99.988% ( 15, 22 ] 52 0.013% 100.002% ( 22, 34 ] 14 0.004% 100.005% ( 34, 51 ] 3 0.001% 100.006% ( 51, 76 ] 5 0.001% 100.007% ( 110, 170 ] 13 0.003% 100.011% ( 170, 250 ] 14 0.004% 100.014% ( 250, 380 ] 10 0.003% 100.017% ( 380, 580 ] 6 0.002% 100.018% ( 580, 870 ] 4 0.001% 100.019% ( 870, 1300 ] 4 0.001% 100.020% ( 1300, 1900 ] 1 0.000% 100.021% ( 1900, 2900 ] 2 0.001% 100.021% ( 2900, 4400 ] 3 0.001% 100.022% ** Level 1 read latency histogram (micros): Count: 136055 Average: 2.2677 StdDev: 11.47 Min: 0 Median: 1.4781 Max: 2123 Percentiles: P50: 1.48 P75: 1.88 P99: 5.82 P99.9: 14.03 P99.99: 337.66 ------------------------------------------------------ [ 0, 1 ] 27853 20.472% 20.472% #### ( 1, 2 ] 84035 61.765% 82.237% ############ ( 2, 3 ] 13603 9.998% 92.235% ## ( 3, 4 ] 5423 3.986% 96.221% # ( 4, 6 ] 4152 3.052% 99.273% # ( 6, 10 ] 740 0.544% 99.817% ( 10, 15 ] 140 0.103% 99.920% ( 15, 22 ] 19 0.014% 99.934% ( 22, 34 ] 3 0.002% 99.936% ( 34, 51 ] 33 0.024% 99.960% ( 51, 76 ] 21 0.015% 99.976% ( 76, 110 ] 2 0.001% 99.977% ( 110, 170 ] 4 0.003% 99.980% ( 170, 250 ] 8 0.006% 99.986% ( 250, 380 ] 8 0.006% 99.992% ( 380, 580 ] 1 0.001% 99.993% ( 580, 870 ] 2 0.001% 99.994% ( 870, 1300 ] 6 0.004% 99.999% ( 1300, 1900 ] 1 0.001% 99.999% ( 1900, 2900 ] 1 0.001% 100.000% ** Level 2 read latency histogram (micros): Count: 15930 Average: 1.6434 StdDev: 3.17 Min: 1 Median: 1.0794 Max: 228 Percentiles: P50: 1.08 P75: 1.57 P99: 3.09 P99.9: 8.69 P99.99: 207.52 ------------------------------------------------------ [ 0, 1 ] 7324 45.976% 45.976% ######### ( 1, 2 ] 8068 50.647% 96.623% ########## ( 2, 3 ] 368 2.310% 98.933% ( 3, 4 ] 113 0.709% 99.642% ( 4, 6 ] 31 0.195% 99.837% ( 6, 10 ] 15 0.094% 99.931% ( 10, 15 ] 4 0.025% 99.956% ( 15, 22 ] 3 0.019% 99.975% ( 110, 170 ] 1 0.006% 99.981% ( 170, 250 ] 3 0.019% 100.000% ** Level 3 read latency histogram (micros): Count: 89705 Average: 3.8824 StdDev: 44.60 Min: 0 Median: 1.5766 Max: 3987 Percentiles: P50: 1.58 P75: 1.99 P99: 9.62 P99.9: 364.22 P99.99: 2403.69 ------------------------------------------------------ [ 0, 1 ] 13906 15.502% 15.502% ### ( 1, 2 ] 53673 59.833% 75.335% ############ ( 2, 3 ] 11005 12.268% 87.603% ## ( 3, 4 ] 5125 5.713% 93.316% # ( 4, 6 ] 3719 4.146% 97.462% # ( 6, 10 ] 1526 1.701% 99.163% ( 10, 15 ] 314 0.350% 99.513% ( 15, 22 ] 48 0.054% 99.566% ( 22, 34 ] 9 0.010% 99.576% ( 76, 110 ] 75 0.084% 99.660% ( 110, 170 ] 125 0.139% 99.799% ( 170, 250 ] 49 0.055% 99.854% ( 250, 380 ] 47 0.052% 99.906% ( 380, 580 ] 43 0.048% 99.954% ( 580, 870 ] 17 0.019% 99.973% ( 870, 1300 ] 7 0.008% 99.981% ( 1300, 1900 ] 4 0.004% 99.986% ( 1900, 2900 ] 8 0.009% 99.994% ( 2900, 4400 ] 7 0.008% 100.002% ** Level 4 read latency histogram (micros): Count: 30 Average: 1657.6000 StdDev: 1248.89 Min: 186 Median: 1246.2500 Max: 4899 Percentiles: P50: 1246.25 P75: 2275.00 P99: 4899.00 P99.9: 4899.00 P99.99: 4899.00 ------------------------------------------------------ ( 170, 250 ] 1 3.333% 3.333% # ( 250, 380 ] 1 3.333% 6.667% # ( 380, 580 ] 3 10.000% 16.667% ## ( 580, 870 ] 3 10.000% 26.667% ## ( 870, 1300 ] 8 26.667% 53.333% ##### ( 1300, 1900 ] 5 16.667% 70.000% ### ( 1900, 2900 ] 4 13.333% 83.333% ### ( 2900, 4400 ] 3 10.000% 93.333% ## ( 4400, 6600 ] 2 6.667% 100.000% # ** DB Stats ** Uptime(secs): 6.0 total, 2.9 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 326.15 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.582 H:M:S, 9.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 341.04 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.209 H:M:S, 7.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 4 num-running-flushes: 1 2024/12/16-03:24:15 ... thread 0: (1000000,3000000) ops and (325913.8,336269.5) ops/second in (3.068296,8.921417) 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/13 2.15 GB 0.0 1.7 0.0 1.7 4.4 2.8 0.0 1.6 117.3 312.6 14.50 13.51 46 0.315 1727K 1820 0.0 0.0 L1 2/2 50.34 MB 0.0 0.8 0.5 0.3 0.8 0.5 0.1 1.6 251.8 251.3 3.25 3.17 2 1.626 831K 1475 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.0 0.1 0.1 0.6 1.8 245.7 245.6 0.45 0.43 1 0.453 113K 27 0.0 0.0 L3 24/0 989.82 MB 1.0 1.4 0.6 0.8 1.4 0.6 0.0 2.3 219.3 219.2 6.67 5.92 4 1.667 1463K 700 0.0 0.0 L4 152/0 9.55 GB 1.0 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 L5 1048/0 86.19 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 1239/15 98.90 GB 0.0 4.0 1.2 2.8 6.8 3.9 1.4 2.4 164.5 278.3 24.88 23.02 53 0.469 4134K 4022 0.0 0.0 Int 0/0 0.00 KB 0.0 4.0 1.2 2.8 6.8 3.9 1.4 2.4 164.5 278.3 24.88 23.02 53 0.469 4134K 4022 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 4.0 1.2 2.8 4.0 1.2 0.0 0.0 242.4 242.1 16.89 15.90 13 1.299 4134K 4022 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 2.8 2.8 0.0 0.0 0.0 354.9 7.99 7.12 40 0.200 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 9.1 total, 8.9 interval Flush(GB): cumulative 2.768, interval 2.768 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 6.76 GB write, 760.58 MB/s write, 4.00 GB read, 449.64 MB/s read, 24.9 seconds Interval compaction: 6.76 GB write, 775.93 MB/s write, 4.00 GB read, 458.71 MB/s read, 24.9 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 8, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 8, interval: 8 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 631678 Average: 2.1836 StdDev: 13.67 Min: 1 Median: 1.4230 Max: 3631 Percentiles: P50: 1.42 P75: 1.83 P99: 5.71 P99.9: 11.33 P99.99: 94.22 ------------------------------------------------------ [ 0, 1 ] 152580 24.155% 24.155% ##### ( 1, 2 ] 385982 61.104% 85.259% ############ ( 2, 3 ] 48246 7.638% 92.897% ## ( 3, 4 ] 24879 3.939% 96.835% # ( 4, 6 ] 16015 2.535% 99.371% # ( 6, 10 ] 3191 0.505% 99.876% ( 10, 15 ] 577 0.091% 99.967% ( 15, 22 ] 97 0.015% 99.982% ( 22, 34 ] 16 0.003% 99.985% ( 34, 51 ] 6 0.001% 99.986% ( 51, 76 ] 6 0.001% 99.987% ( 76, 110 ] 37 0.006% 99.993% ( 110, 170 ] 54 0.009% 100.001% ( 170, 250 ] 47 0.007% 100.009% ( 250, 380 ] 24 0.004% 100.013% ( 380, 580 ] 17 0.003% 100.015% ( 580, 870 ] 18 0.003% 100.018% ( 870, 1300 ] 10 0.002% 100.020% ( 1300, 1900 ] 4 0.001% 100.020% ( 1900, 2900 ] 6 0.001% 100.021% ( 2900, 4400 ] 4 0.001% 100.022% ** Level 1 read latency histogram (micros): Count: 207004 Average: 2.3274 StdDev: 9.33 Min: 0 Median: 1.5444 Max: 2123 Percentiles: P50: 1.54 P75: 1.94 P99: 5.86 P99.9: 13.20 P99.99: 233.00 ------------------------------------------------------ [ 0, 1 ] 32957 15.921% 15.921% ### ( 1, 2 ] 129594 62.605% 78.526% ############# ( 2, 3 ] 24914 12.036% 90.561% ## ( 3, 4 ] 9975 4.819% 95.380% # ( 4, 6 ] 8039 3.883% 99.263% # ( 6, 10 ] 1163 0.562% 99.825% ( 10, 15 ] 242 0.117% 99.942% ( 15, 22 ] 30 0.014% 99.957% ( 22, 34 ] 3 0.001% 99.958% ( 34, 51 ] 33 0.016% 99.974% ( 51, 76 ] 21 0.010% 99.984% ( 76, 110 ] 2 0.001% 99.985% ( 110, 170 ] 4 0.002% 99.987% ( 170, 250 ] 8 0.004% 99.991% ( 250, 380 ] 8 0.004% 99.995% ( 380, 580 ] 1 0.000% 99.995% ( 580, 870 ] 2 0.001% 99.996% ( 870, 1300 ] 6 0.003% 99.999% ( 1300, 1900 ] 1 0.000% 100.000% ( 1900, 2900 ] 1 0.000% 100.000% ** Level 2 read latency histogram (micros): Count: 28267 Average: 2.2417 StdDev: 9.85 Min: 1 Median: 1.3036 Max: 583 Percentiles: P50: 1.30 P75: 1.76 P99: 5.77 P99.9: 137.81 P99.99: 527.81 ------------------------------------------------------ [ 0, 1 ] 9391 33.222% 33.222% ####### ( 1, 2 ] 15622 55.266% 88.488% ########### ( 2, 3 ] 1643 5.812% 94.301% # ( 3, 4 ] 883 3.124% 97.425% # ( 4, 6 ] 502 1.776% 99.200% ( 6, 10 ] 149 0.527% 99.728% ( 10, 15 ] 17 0.060% 99.788% ( 15, 22 ] 7 0.025% 99.813% ( 76, 110 ] 15 0.053% 99.866% ( 110, 170 ] 21 0.074% 99.940% ( 170, 250 ] 7 0.025% 99.965% ( 250, 380 ] 2 0.007% 99.972% ( 380, 580 ] 7 0.025% 99.996% ( 580, 870 ] 1 0.004% 100.000% ** Level 3 read latency histogram (micros): Count: 212683 Average: 3.3911 StdDev: 31.44 Min: 0 Median: 1.5684 Max: 3987 Percentiles: P50: 1.57 P75: 1.98 P99: 9.18 P99.9: 254.59 P99.99: 797.36 ------------------------------------------------------ [ 0, 1 ] 32439 15.252% 15.252% ### ( 1, 2 ] 130022 61.134% 76.386% ############ ( 2, 3 ] 24498 11.519% 87.905% ## ( 3, 4 ] 12349 5.806% 93.711% # ( 4, 6 ] 8300 3.903% 97.614% # ( 6, 10 ] 3714 1.746% 99.360% ( 10, 15 ] 495 0.233% 99.593% ( 15, 22 ] 66 0.031% 99.624% ( 22, 34 ] 24 0.011% 99.635% ( 34, 51 ] 25 0.012% 99.647% ( 51, 76 ] 6 0.003% 99.650% ( 76, 110 ] 146 0.069% 99.718% ( 110, 170 ] 269 0.126% 99.845% ( 170, 250 ] 114 0.054% 99.898% ( 250, 380 ] 94 0.044% 99.943% ( 380, 580 ] 73 0.034% 99.977% ( 580, 870 ] 37 0.017% 99.994% ( 870, 1300 ] 11 0.005% 100.000% ( 1300, 1900 ] 4 0.002% 100.001% ( 1900, 2900 ] 8 0.004% 100.005% ( 2900, 4400 ] 7 0.003% 100.008% ** Level 4 read latency histogram (micros): Count: 30 Average: 1657.6000 StdDev: 1248.89 Min: 186 Median: 1246.2500 Max: 4899 Percentiles: P50: 1246.25 P75: 2275.00 P99: 4899.00 P99.9: 4899.00 P99.99: 4899.00 ------------------------------------------------------ ( 170, 250 ] 1 3.333% 3.333% # ( 250, 380 ] 1 3.333% 6.667% # ( 380, 580 ] 3 10.000% 16.667% ## ( 580, 870 ] 3 10.000% 26.667% ## ( 870, 1300 ] 8 26.667% 53.333% ##### ( 1300, 1900 ] 5 16.667% 70.000% ### ( 1900, 2900 ] 4 13.333% 83.333% ### ( 2900, 4400 ] 3 10.000% 93.333% ## ( 4400, 6600 ] 2 6.667% 100.000% # ** Level 5 read latency histogram (micros): Count: 20 Average: 647.8000 StdDev: 716.74 Min: 85 Median: 354.0000 Max: 2668 Percentiles: P50: 354.00 P75: 870.00 P99: 2668.00 P99.9: 2668.00 P99.99: 2668.00 ------------------------------------------------------ ( 76, 110 ] 5 25.000% 25.000% ##### ( 170, 250 ] 1 5.000% 30.000% # ( 250, 380 ] 5 25.000% 55.000% ##### ( 380, 580 ] 3 15.000% 70.000% ### ( 580, 870 ] 1 5.000% 75.000% # ( 870, 1300 ] 3 15.000% 90.000% ### ( 1900, 2900 ] 2 10.000% 100.000% ## ** DB Stats ** Uptime(secs): 9.1 total, 3.1 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 324.33 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.964 H:M:S, 10.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 320.76 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.382 H:M:S, 12.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/16-03:24:19 ... thread 0: (1000000,4000000) ops and (323457.6,332972.3) ops/second in (3.091595,12.013012) 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/13 3.07 GB 88.1 2.5 0.0 2.5 6.1 3.7 0.0 1.7 124.5 311.1 20.24 18.88 62 0.326 2558K 2725 0.0 0.0 L1 2/2 50.34 MB 0.0 0.8 0.5 0.3 0.8 0.5 0.1 1.6 251.8 251.3 3.25 3.17 2 1.626 831K 1475 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.0 0.1 0.1 0.6 1.8 245.7 245.6 0.45 0.43 1 0.453 113K 27 0.0 0.0 L3 24/0 989.82 MB 1.0 1.4 0.6 0.8 1.4 0.6 0.0 2.3 219.3 219.2 6.67 5.92 4 1.667 1463K 700 0.0 0.0 L4 152/0 9.55 GB 1.0 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 L5 1048/0 86.19 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 1243/15 99.82 GB 0.0 4.8 1.2 3.6 8.5 4.9 1.4 2.3 160.5 283.8 30.61 28.40 69 0.444 4965K 4927 0.0 0.0 Int 0/0 0.00 KB 0.0 4.8 1.2 3.6 8.5 4.9 1.4 2.3 160.5 283.8 30.61 28.40 69 0.444 4965K 4927 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 4.8 1.2 3.6 4.8 1.2 0.0 0.0 246.5 246.3 19.93 18.88 16 1.245 4965K 4927 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 3.7 3.7 0.0 0.0 0.0 353.7 10.69 9.51 53 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): 12.2 total, 12.0 interval Flush(GB): cumulative 3.691, interval 3.691 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 8.48 GB write, 712.33 MB/s write, 4.80 GB read, 402.81 MB/s read, 30.6 seconds Interval compaction: 8.48 GB write, 723.00 MB/s write, 4.80 GB read, 408.84 MB/s read, 30.6 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 13, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 13, interval: 13 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1047067 Average: 2.1633 StdDev: 12.67 Min: 1 Median: 1.4379 Max: 3631 Percentiles: P50: 1.44 P75: 1.83 P99: 5.66 P99.9: 9.94 P99.99: 16.53 ------------------------------------------------------ [ 0, 1 ] 231986 22.156% 22.156% #### ( 1, 2 ] 665854 63.592% 85.748% ############# ( 2, 3 ] 80201 7.660% 93.408% ## ( 3, 4 ] 39391 3.762% 97.170% # ( 4, 6 ] 23126 2.209% 99.378% ( 6, 10 ] 5541 0.529% 99.908% ( 10, 15 ] 840 0.080% 99.988% ( 15, 22 ] 116 0.011% 99.999% ( 22, 34 ] 20 0.002% 100.001% ( 34, 51 ] 11 0.001% 100.002% ( 51, 76 ] 10 0.001% 100.003% ( 76, 110 ] 68 0.006% 100.009% ( 110, 170 ] 63 0.006% 100.015% ( 170, 250 ] 57 0.005% 100.021% ( 250, 380 ] 32 0.003% 100.024% ( 380, 580 ] 22 0.002% 100.026% ( 580, 870 ] 21 0.002% 100.028% ( 870, 1300 ] 16 0.002% 100.029% ( 1300, 1900 ] 6 0.001% 100.030% ( 1900, 2900 ] 7 0.001% 100.031% ( 2900, 4400 ] 7 0.001% 100.031% ** Level 1 read latency histogram (micros): Count: 207004 Average: 2.3274 StdDev: 9.33 Min: 0 Median: 1.5444 Max: 2123 Percentiles: P50: 1.54 P75: 1.94 P99: 5.86 P99.9: 13.20 P99.99: 233.00 ------------------------------------------------------ [ 0, 1 ] 32957 15.921% 15.921% ### ( 1, 2 ] 129594 62.605% 78.526% ############# ( 2, 3 ] 24914 12.036% 90.561% ## ( 3, 4 ] 9975 4.819% 95.380% # ( 4, 6 ] 8039 3.883% 99.263% # ( 6, 10 ] 1163 0.562% 99.825% ( 10, 15 ] 242 0.117% 99.942% ( 15, 22 ] 30 0.014% 99.957% ( 22, 34 ] 3 0.001% 99.958% ( 34, 51 ] 33 0.016% 99.974% ( 51, 76 ] 21 0.010% 99.984% ( 76, 110 ] 2 0.001% 99.985% ( 110, 170 ] 4 0.002% 99.987% ( 170, 250 ] 8 0.004% 99.991% ( 250, 380 ] 8 0.004% 99.995% ( 380, 580 ] 1 0.000% 99.995% ( 580, 870 ] 2 0.001% 99.996% ( 870, 1300 ] 6 0.003% 99.999% ( 1300, 1900 ] 1 0.000% 100.000% ( 1900, 2900 ] 1 0.000% 100.000% ** Level 2 read latency histogram (micros): Count: 28267 Average: 2.2417 StdDev: 9.85 Min: 1 Median: 1.3036 Max: 583 Percentiles: P50: 1.30 P75: 1.76 P99: 5.77 P99.9: 137.81 P99.99: 527.81 ------------------------------------------------------ [ 0, 1 ] 9391 33.222% 33.222% ####### ( 1, 2 ] 15622 55.266% 88.488% ########### ( 2, 3 ] 1643 5.812% 94.301% # ( 3, 4 ] 883 3.124% 97.425% # ( 4, 6 ] 502 1.776% 99.200% ( 6, 10 ] 149 0.527% 99.728% ( 10, 15 ] 17 0.060% 99.788% ( 15, 22 ] 7 0.025% 99.813% ( 76, 110 ] 15 0.053% 99.866% ( 110, 170 ] 21 0.074% 99.940% ( 170, 250 ] 7 0.025% 99.965% ( 250, 380 ] 2 0.007% 99.972% ( 380, 580 ] 7 0.025% 99.996% ( 580, 870 ] 1 0.004% 100.000% ** Level 3 read latency histogram (micros): Count: 212683 Average: 3.3911 StdDev: 31.44 Min: 0 Median: 1.5684 Max: 3987 Percentiles: P50: 1.57 P75: 1.98 P99: 9.18 P99.9: 254.59 P99.99: 797.36 ------------------------------------------------------ [ 0, 1 ] 32439 15.252% 15.252% ### ( 1, 2 ] 130022 61.134% 76.386% ############ ( 2, 3 ] 24498 11.519% 87.905% ## ( 3, 4 ] 12349 5.806% 93.711% # ( 4, 6 ] 8300 3.903% 97.614% # ( 6, 10 ] 3714 1.746% 99.360% ( 10, 15 ] 495 0.233% 99.593% ( 15, 22 ] 66 0.031% 99.624% ( 22, 34 ] 24 0.011% 99.635% ( 34, 51 ] 25 0.012% 99.647% ( 51, 76 ] 6 0.003% 99.650% ( 76, 110 ] 146 0.069% 99.718% ( 110, 170 ] 269 0.126% 99.845% ( 170, 250 ] 114 0.054% 99.898% ( 250, 380 ] 94 0.044% 99.943% ( 380, 580 ] 73 0.034% 99.977% ( 580, 870 ] 37 0.017% 99.994% ( 870, 1300 ] 11 0.005% 100.000% ( 1300, 1900 ] 4 0.002% 100.001% ( 1900, 2900 ] 8 0.004% 100.005% ( 2900, 4400 ] 7 0.003% 100.008% ** Level 4 read latency histogram (micros): Count: 30 Average: 1657.6000 StdDev: 1248.89 Min: 186 Median: 1246.2500 Max: 4899 Percentiles: P50: 1246.25 P75: 2275.00 P99: 4899.00 P99.9: 4899.00 P99.99: 4899.00 ------------------------------------------------------ ( 170, 250 ] 1 3.333% 3.333% # ( 250, 380 ] 1 3.333% 6.667% # ( 380, 580 ] 3 10.000% 16.667% ## ( 580, 870 ] 3 10.000% 26.667% ## ( 870, 1300 ] 8 26.667% 53.333% ##### ( 1300, 1900 ] 5 16.667% 70.000% ### ( 1900, 2900 ] 4 13.333% 83.333% ### ( 2900, 4400 ] 3 10.000% 93.333% ## ( 4400, 6600 ] 2 6.667% 100.000% # ** Level 5 read latency histogram (micros): Count: 20 Average: 647.8000 StdDev: 716.74 Min: 85 Median: 354.0000 Max: 2668 Percentiles: P50: 354.00 P75: 870.00 P99: 2668.00 P99.9: 2668.00 P99.99: 2668.00 ------------------------------------------------------ ( 76, 110 ] 5 25.000% 25.000% ##### ( 170, 250 ] 1 5.000% 30.000% # ( 250, 380 ] 5 25.000% 55.000% ##### ( 380, 580 ] 3 15.000% 70.000% ### ( 580, 870 ] 1 5.000% 75.000% # ( 870, 1300 ] 3 15.000% 90.000% ### ( 1900, 2900 ] 2 10.000% 100.000% ## ** DB Stats ** Uptime(secs): 12.2 total, 3.1 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 322.81 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.365 H:M:S, 11.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 318.34 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.400 H:M:S, 12.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/16-03:24:24 ... thread 0: (1000000,5000000) ops and (192377.4,290509.7) ops/second in (5.198116,17.211128) 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/9 2.15 GB 0.0 3.8 0.0 3.8 8.5 4.7 0.0 1.8 136.3 308.1 28.20 26.42 84 0.336 3901K 4043 0.0 0.0 L1 16/16 1.43 GB 0.0 2.8 2.4 0.4 2.7 2.4 0.1 1.1 237.3 235.7 11.88 11.51 3 3.960 2863K 19K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.0 0.1 0.1 1.1 1.8 245.7 245.6 0.45 0.43 1 0.453 113K 27 0.0 0.0 L3 20/4 989.79 MB 0.8 1.4 0.6 0.8 1.4 0.6 0.5 2.3 219.3 219.2 6.67 5.92 4 1.667 1463K 700 0.0 0.0 L4 156/0 9.74 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.9 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1052/0 86.49 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1253/29 100.79 GB 0.0 8.0 3.1 5.0 12.8 7.8 3.2 2.7 174.5 276.7 47.21 44.27 92 0.513 8341K 24K 0.0 0.0 Int 0/0 0.00 KB 0.0 8.0 3.1 5.0 12.8 7.8 3.2 2.7 174.5 276.7 47.21 44.27 92 0.513 8341K 24K 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 8.0 3.1 5.0 8.0 3.0 0.0 0.0 246.2 245.5 33.45 32.04 22 1.520 8341K 24K 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 352.6 13.76 12.24 70 0.197 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 17.4 total, 17.2 interval Flush(GB): cumulative 4.737, interval 4.737 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 12.76 GB write, 751.01 MB/s write, 8.04 GB read, 473.55 MB/s read, 47.2 seconds Interval compaction: 12.76 GB write, 758.87 MB/s write, 8.04 GB read, 478.50 MB/s read, 47.2 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 11, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 11, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 13, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 11, total-stops: 13, interval: 24 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1642468 Average: 2.1839 StdDev: 12.53 Min: 1 Median: 1.4330 Max: 3631 Percentiles: P50: 1.43 P75: 1.82 P99: 5.68 P99.9: 9.96 P99.99: 85.00 ------------------------------------------------------ [ 0, 1 ] 363087 22.106% 22.106% #### ( 1, 2 ] 1058028 64.417% 86.523% ############# ( 2, 3 ] 119614 7.283% 93.806% # ( 3, 4 ] 58089 3.537% 97.342% # ( 4, 6 ] 32351 1.970% 99.312% ( 6, 10 ] 9750 0.594% 99.906% ( 10, 15 ] 1125 0.068% 99.974% ( 15, 22 ] 155 0.009% 99.984% ( 22, 34 ] 22 0.001% 99.985% ( 34, 51 ] 13 0.001% 99.986% ( 51, 76 ] 17 0.001% 99.987% ( 76, 110 ] 203 0.012% 99.999% ( 110, 170 ] 225 0.014% 100.013% ( 170, 250 ] 117 0.007% 100.020% ( 250, 380 ] 79 0.005% 100.025% ( 380, 580 ] 65 0.004% 100.029% ( 580, 870 ] 57 0.003% 100.032% ( 870, 1300 ] 21 0.001% 100.033% ( 1300, 1900 ] 7 0.000% 100.034% ( 1900, 2900 ] 11 0.001% 100.035% ( 2900, 4400 ] 9 0.001% 100.035% ** Level 1 read latency histogram (micros): Count: 219886 Average: 2.5079 StdDev: 14.58 Min: 0 Median: 1.5376 Max: 2123 Percentiles: P50: 1.54 P75: 1.94 P99: 5.92 P99.9: 54.11 P99.99: 725.55 ------------------------------------------------------ [ 0, 1 ] 35721 16.245% 16.245% ### ( 1, 2 ] 138053 62.784% 79.029% ############# ( 2, 3 ] 25674 11.676% 90.705% ## ( 3, 4 ] 10344 4.704% 95.409% # ( 4, 6 ] 8217 3.737% 99.146% # ( 6, 10 ] 1340 0.609% 99.756% ( 10, 15 ] 247 0.112% 99.868% ( 15, 22 ] 30 0.014% 99.882% ( 22, 34 ] 4 0.002% 99.884% ( 34, 51 ] 33 0.015% 99.899% ( 51, 76 ] 25 0.011% 99.910% ( 76, 110 ] 73 0.033% 99.943% ( 110, 170 ] 37 0.017% 99.960% ( 170, 250 ] 22 0.010% 99.970% ( 250, 380 ] 23 0.010% 99.980% ( 380, 580 ] 18 0.008% 99.989% ( 580, 870 ] 6 0.003% 99.991% ( 870, 1300 ] 13 0.006% 99.997% ( 1300, 1900 ] 5 0.002% 100.000% ( 1900, 2900 ] 1 0.000% 100.000% ** Level 2 read latency histogram (micros): Count: 28267 Average: 2.2417 StdDev: 9.85 Min: 1 Median: 1.3036 Max: 583 Percentiles: P50: 1.30 P75: 1.76 P99: 5.77 P99.9: 137.81 P99.99: 527.81 ------------------------------------------------------ [ 0, 1 ] 9391 33.222% 33.222% ####### ( 1, 2 ] 15622 55.266% 88.488% ########### ( 2, 3 ] 1643 5.812% 94.301% # ( 3, 4 ] 883 3.124% 97.425% # ( 4, 6 ] 502 1.776% 99.200% ( 6, 10 ] 149 0.527% 99.728% ( 10, 15 ] 17 0.060% 99.788% ( 15, 22 ] 7 0.025% 99.813% ( 76, 110 ] 15 0.053% 99.866% ( 110, 170 ] 21 0.074% 99.940% ( 170, 250 ] 7 0.025% 99.965% ( 250, 380 ] 2 0.007% 99.972% ( 380, 580 ] 7 0.025% 99.996% ( 580, 870 ] 1 0.004% 100.000% ** Level 3 read latency histogram (micros): Count: 221662 Average: 3.6128 StdDev: 33.21 Min: 0 Median: 1.5693 Max: 3987 Percentiles: P50: 1.57 P75: 1.98 P99: 9.42 P99.9: 310.60 P99.99: 834.94 ------------------------------------------------------ [ 0, 1 ] 33941 15.312% 15.312% ### ( 1, 2 ] 135058 60.930% 76.242% ############ ( 2, 3 ] 25943 11.704% 87.946% ## ( 3, 4 ] 12753 5.753% 93.699% # ( 4, 6 ] 8466 3.819% 97.518% # ( 6, 10 ] 3837 1.731% 99.249% ( 10, 15 ] 532 0.240% 99.489% ( 15, 22 ] 76 0.034% 99.524% ( 22, 34 ] 24 0.011% 99.534% ( 34, 51 ] 25 0.011% 99.546% ( 51, 76 ] 6 0.003% 99.548% ( 76, 110 ] 214 0.097% 99.645% ( 110, 170 ] 360 0.162% 99.807% ( 170, 250 ] 148 0.067% 99.874% ( 250, 380 ] 123 0.055% 99.930% ( 380, 580 ] 89 0.040% 99.970% ( 580, 870 ] 51 0.023% 99.993% ( 870, 1300 ] 12 0.005% 99.998% ( 1300, 1900 ] 5 0.002% 100.000% ( 1900, 2900 ] 10 0.005% 100.005% ( 2900, 4400 ] 7 0.003% 100.008% ** Level 4 read latency histogram (micros): Count: 30 Average: 1657.6000 StdDev: 1248.89 Min: 186 Median: 1246.2500 Max: 4899 Percentiles: P50: 1246.25 P75: 2275.00 P99: 4899.00 P99.9: 4899.00 P99.99: 4899.00 ------------------------------------------------------ ( 170, 250 ] 1 3.333% 3.333% # ( 250, 380 ] 1 3.333% 6.667% # ( 380, 580 ] 3 10.000% 16.667% ## ( 580, 870 ] 3 10.000% 26.667% ## ( 870, 1300 ] 8 26.667% 53.333% ##### ( 1300, 1900 ] 5 16.667% 70.000% ### ( 1900, 2900 ] 4 13.333% 83.333% ### ( 2900, 4400 ] 3 10.000% 93.333% ## ( 4400, 6600 ] 2 6.667% 100.000% # ** Level 5 read latency histogram (micros): Count: 40 Average: 878.5500 StdDev: 1092.24 Min: 85 Median: 446.6667 Max: 4597 Percentiles: P50: 446.67 P75: 956.00 P99: 4597.00 P99.9: 4597.00 P99.99: 4597.00 ------------------------------------------------------ ( 76, 110 ] 5 12.500% 12.500% ### ( 110, 170 ] 2 5.000% 17.500% # ( 170, 250 ] 3 7.500% 25.000% ## ( 250, 380 ] 7 17.500% 42.500% #### ( 380, 580 ] 9 22.500% 65.000% ##### ( 580, 870 ] 3 7.500% 72.500% ## ( 870, 1300 ] 5 12.500% 85.000% ### ( 1300, 1900 ] 1 2.500% 87.500% # ( 1900, 2900 ] 2 5.000% 92.500% # ( 2900, 4400 ] 2 5.000% 97.500% # ( 4400, 6600 ] 1 2.500% 100.000% # ** DB Stats ** Uptime(secs): 17.4 total, 5.2 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 282.92 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:3.903 H:M:S, 22.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 189.34 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:2.539 H:M:S, 48.8 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/16-03:24:27 ... thread 0: (1000000,6000000) ops and (325877.8,295861.4) ops/second in (3.068635,20.279763) 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/13 3.13 GB 75.5 4.3 0.0 4.3 10.0 5.7 0.0 1.8 133.7 309.3 32.98 30.89 99 0.333 4477K 4643 0.0 0.0 L1 16/16 1.43 GB 0.0 2.8 2.4 0.4 2.7 2.4 0.1 1.1 237.3 235.7 11.88 11.51 3 3.960 2863K 19K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.0 0.1 0.1 1.1 1.8 245.7 245.6 0.45 0.43 1 0.453 113K 27 0.0 0.0 L3 16/0 832.29 MB 0.8 1.4 0.6 0.8 1.4 0.6 0.5 2.3 219.3 219.2 6.67 5.92 4 1.667 1463K 700 0.0 0.0 L4 169/0 9.59 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.9 1.0 180.2 180.2 0.87 0.71 1 0.874 130K 0 0.0 0.0 L5 1056/0 86.80 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1274/29 101.77 GB 0.0 8.8 3.2 5.5 14.4 8.9 3.5 2.5 169.5 278.7 52.86 49.45 108 0.489 9047K 24K 0.0 0.0 Int 0/0 0.00 KB 0.0 8.8 3.2 5.5 14.4 8.9 3.5 2.5 169.5 278.7 52.86 49.45 108 0.489 9047K 24K 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 8.8 3.2 5.5 8.7 3.2 0.0 0.0 246.0 245.3 36.43 34.82 25 1.457 9047K 24K 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 352.7 16.43 14.64 83 0.198 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 20.5 total, 20.3 interval Flush(GB): cumulative 5.660, interval 5.660 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 14.39 GB write, 719.94 MB/s write, 8.75 GB read, 437.94 MB/s read, 52.9 seconds Interval compaction: 14.39 GB write, 726.33 MB/s write, 8.75 GB read, 441.83 MB/s read, 52.9 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 11, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 11, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 18, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 11, total-stops: 18, interval: 29 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1990799 Average: 2.1834 StdDev: 12.01 Min: 1 Median: 1.4374 Max: 3631 Percentiles: P50: 1.44 P75: 1.82 P99: 5.66 P99.9: 9.91 P99.99: 79.89 ------------------------------------------------------ [ 0, 1 ] 430005 21.600% 21.600% #### ( 1, 2 ] 1292632 64.930% 86.530% ############# ( 2, 3 ] 146229 7.345% 93.875% # ( 3, 4 ] 70060 3.519% 97.394% # ( 4, 6 ] 38488 1.933% 99.328% ( 6, 10 ] 11645 0.585% 99.913% ( 10, 15 ] 1283 0.064% 99.977% ( 15, 22 ] 174 0.009% 99.986% ( 22, 34 ] 25 0.001% 99.987% ( 34, 51 ] 15 0.001% 99.988% ( 51, 76 ] 19 0.001% 99.989% ( 76, 110 ] 235 0.012% 100.001% ( 110, 170 ] 275 0.014% 100.014% ( 170, 250 ] 161 0.008% 100.022% ( 250, 380 ] 93 0.005% 100.027% ( 380, 580 ] 78 0.004% 100.031% ( 580, 870 ] 67 0.003% 100.034% ( 870, 1300 ] 24 0.001% 100.036% ( 1300, 1900 ] 9 0.000% 100.036% ( 1900, 2900 ] 13 0.001% 100.037% ( 2900, 4400 ] 9 0.000% 100.037% ** Level 1 read latency histogram (micros): Count: 240585 Average: 2.5389 StdDev: 14.54 Min: 0 Median: 1.5382 Max: 2123 Percentiles: P50: 1.54 P75: 1.93 P99: 5.98 P99.9: 83.38 P99.99: 722.88 ------------------------------------------------------ [ 0, 1 ] 38410 15.965% 15.965% ### ( 1, 2 ] 152137 63.236% 79.202% ############# ( 2, 3 ] 27682 11.506% 90.708% ## ( 3, 4 ] 11244 4.674% 95.381% # ( 4, 6 ] 8806 3.660% 99.042% # ( 6, 10 ] 1674 0.696% 99.737% ( 10, 15 ] 273 0.113% 99.851% ( 15, 22 ] 36 0.015% 99.866% ( 22, 34 ] 5 0.002% 99.868% ( 34, 51 ] 33 0.014% 99.882% ( 51, 76 ] 25 0.010% 99.892% ( 76, 110 ] 94 0.039% 99.931% ( 110, 170 ] 57 0.024% 99.955% ( 170, 250 ] 31 0.013% 99.968% ( 250, 380 ] 28 0.012% 99.979% ( 380, 580 ] 23 0.010% 99.989% ( 580, 870 ] 8 0.003% 99.992% ( 870, 1300 ] 14 0.006% 99.998% ( 1300, 1900 ] 5 0.002% 100.000% ( 1900, 2900 ] 1 0.000% 100.000% ** Level 2 read latency histogram (micros): Count: 28267 Average: 2.2417 StdDev: 9.85 Min: 1 Median: 1.3036 Max: 583 Percentiles: P50: 1.30 P75: 1.76 P99: 5.77 P99.9: 137.81 P99.99: 527.81 ------------------------------------------------------ [ 0, 1 ] 9391 33.222% 33.222% ####### ( 1, 2 ] 15622 55.266% 88.488% ########### ( 2, 3 ] 1643 5.812% 94.301% # ( 3, 4 ] 883 3.124% 97.425% # ( 4, 6 ] 502 1.776% 99.200% ( 6, 10 ] 149 0.527% 99.728% ( 10, 15 ] 17 0.060% 99.788% ( 15, 22 ] 7 0.025% 99.813% ( 76, 110 ] 15 0.053% 99.866% ( 110, 170 ] 21 0.074% 99.940% ( 170, 250 ] 7 0.025% 99.965% ( 250, 380 ] 2 0.007% 99.972% ( 380, 580 ] 7 0.025% 99.996% ( 580, 870 ] 1 0.004% 100.000% ** Level 3 read latency histogram (micros): Count: 252673 Average: 3.4395 StdDev: 31.13 Min: 0 Median: 1.5594 Max: 3987 Percentiles: P50: 1.56 P75: 1.96 P99: 9.27 P99.9: 278.88 P99.99: 817.30 ------------------------------------------------------ [ 0, 1 ] 38811 15.360% 15.360% ### ( 1, 2 ] 156464 61.924% 77.284% ############ ( 2, 3 ] 28636 11.333% 88.617% ## ( 3, 4 ] 13675 5.412% 94.029% # ( 4, 6 ] 8996 3.560% 97.589% # ( 6, 10 ] 4359 1.725% 99.315% ( 10, 15 ] 585 0.232% 99.546% ( 15, 22 ] 85 0.034% 99.580% ( 22, 34 ] 25 0.010% 99.590% ( 34, 51 ] 25 0.010% 99.599% ( 51, 76 ] 6 0.002% 99.602% ( 76, 110 ] 217 0.086% 99.688% ( 110, 170 ] 360 0.142% 99.830% ( 170, 250 ] 149 0.059% 99.889% ( 250, 380 ] 123 0.049% 99.938% ( 380, 580 ] 90 0.036% 99.973% ( 580, 870 ] 51 0.020% 99.994% ( 870, 1300 ] 12 0.005% 99.998% ( 1300, 1900 ] 5 0.002% 100.000% ( 1900, 2900 ] 10 0.004% 100.004% ( 2900, 4400 ] 7 0.003% 100.007% ** Level 4 read latency histogram (micros): Count: 115 Average: 445.1913 StdDev: 962.89 Min: 0 Median: 5.2500 Max: 4899 Percentiles: P50: 5.25 P75: 282.50 P99: 4899.00 P99.9: 4899.00 P99.99: 4899.00 ------------------------------------------------------ [ 0, 1 ] 27 23.478% 23.478% ##### ( 1, 2 ] 22 19.130% 42.609% #### ( 2, 3 ] 4 3.478% 46.087% # ( 3, 4 ] 2 1.739% 47.826% ( 4, 6 ] 4 3.478% 51.304% # ( 6, 10 ] 5 4.348% 55.652% # ( 10, 15 ] 1 0.870% 56.522% ( 15, 22 ] 1 0.870% 57.391% ( 22, 34 ] 15 13.043% 70.435% ### ( 110, 170 ] 1 0.870% 71.304% ( 170, 250 ] 4 3.478% 74.783% # ( 250, 380 ] 1 0.870% 75.652% ( 380, 580 ] 3 2.609% 78.261% # ( 580, 870 ] 3 2.609% 80.870% # ( 870, 1300 ] 8 6.957% 87.826% # ( 1300, 1900 ] 5 4.348% 92.174% # ( 1900, 2900 ] 4 3.478% 95.652% # ( 2900, 4400 ] 3 2.609% 98.261% # ( 4400, 6600 ] 2 1.739% 100.000% ** Level 5 read latency histogram (micros): Count: 60 Average: 806.2167 StdDev: 1025.90 Min: 81 Median: 400.0000 Max: 4597 Percentiles: P50: 400.00 P75: 977.50 P99: 4597.00 P99.9: 4597.00 P99.99: 4597.00 ------------------------------------------------------ ( 76, 110 ] 11 18.333% 18.333% #### ( 110, 170 ] 6 10.000% 28.333% ## ( 170, 250 ] 4 6.667% 35.000% # ( 250, 380 ] 8 13.333% 48.333% ### ( 380, 580 ] 10 16.667% 65.000% ### ( 580, 870 ] 4 6.667% 71.667% # ( 870, 1300 ] 8 13.333% 85.000% ### ( 1300, 1900 ] 2 3.333% 88.333% # ( 1900, 2900 ] 3 5.000% 93.333% # ( 2900, 4400 ] 3 5.000% 98.333% # ( 4400, 6600 ] 1 1.667% 100.000% ** DB Stats ** Uptime(secs): 20.5 total, 3.1 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 288.59 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:4.311 H:M:S, 21.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 320.72 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.408 H:M:S, 13.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/16-03:24:31 ... thread 0: (1000000,7000000) ops and (227493.6,283682.3) ops/second in (4.395728,24.675491) 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/9 4.06 GB 195.1 5.4 0.0 5.4 12.0 6.6 0.0 1.8 137.4 307.7 39.90 37.42 118 0.338 5564K 5794 0.0 0.0 L1 16/16 1.43 GB 0.0 2.8 2.4 0.4 2.7 2.4 0.1 1.1 237.3 235.7 11.88 11.51 3 3.960 2863K 19K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.0 0.1 0.1 1.1 1.8 245.7 245.6 0.45 0.43 1 0.453 113K 27 0.0 0.0 L3 16/0 832.29 MB 0.8 1.4 0.6 0.8 1.4 0.6 0.5 2.3 219.3 219.2 6.67 5.92 4 1.667 1463K 700 0.0 0.0 L4 169/0 9.59 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.9 1.0 180.2 180.2 0.87 0.71 1 0.874 130K 0 0.0 0.0 L5 1056/0 86.80 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1276/25 102.69 GB 0.0 9.8 3.2 6.6 16.4 9.8 3.5 2.5 167.8 281.2 59.78 55.98 127 0.471 10M 25K 0.0 0.0 Int 0/0 0.00 KB 0.0 9.8 3.2 6.6 16.4 9.8 3.5 2.5 167.8 281.2 59.78 55.98 127 0.471 10M 25K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 9.8 3.2 6.6 9.8 3.2 0.0 0.0 248.1 247.4 40.43 38.75 29 1.394 10M 25K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 6.6 6.6 0.0 0.0 0.0 351.7 19.34 17.23 98 0.197 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 24.9 total, 24.7 interval Flush(GB): cumulative 6.644, interval 6.644 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 16.41 GB write, 676.22 MB/s write, 9.80 GB read, 403.58 MB/s read, 59.8 seconds Interval compaction: 16.41 GB write, 681.15 MB/s write, 9.80 GB read, 406.53 MB/s read, 59.8 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 16, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 16, 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: 16, total-stops: 20, interval: 36 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2354496 Average: 2.1855 StdDev: 12.12 Min: 1 Median: 1.4349 Max: 3975 Percentiles: P50: 1.43 P75: 1.82 P99: 5.66 P99.9: 9.96 P99.99: 96.24 ------------------------------------------------------ [ 0, 1 ] 509669 21.647% 21.647% #### ( 1, 2 ] 1535164 65.201% 86.848% ############# ( 2, 3 ] 169585 7.203% 94.051% # ( 3, 4 ] 80516 3.420% 97.470% # ( 4, 6 ] 43450 1.845% 99.316% ( 6, 10 ] 13889 0.590% 99.906% ( 10, 15 ] 1530 0.065% 99.971% ( 15, 22 ] 205 0.009% 99.979% ( 22, 34 ] 26 0.001% 99.980% ( 34, 51 ] 17 0.001% 99.981% ( 51, 76 ] 25 0.001% 99.982% ( 76, 110 ] 310 0.013% 99.995% ( 110, 170 ] 380 0.016% 100.011% ( 170, 250 ] 203 0.009% 100.020% ( 250, 380 ] 111 0.005% 100.025% ( 380, 580 ] 105 0.004% 100.029% ( 580, 870 ] 82 0.003% 100.033% ( 870, 1300 ] 29 0.001% 100.034% ( 1300, 1900 ] 10 0.000% 100.034% ( 1900, 2900 ] 14 0.001% 100.035% ( 2900, 4400 ] 11 0.000% 100.035% ** Level 1 read latency histogram (micros): Count: 360833 Average: 2.4922 StdDev: 12.96 Min: 0 Median: 1.5010 Max: 2123 Percentiles: P50: 1.50 P75: 1.89 P99: 6.98 P99.9: 109.61 P99.99: 550.10 ------------------------------------------------------ [ 0, 1 ] 63931 17.718% 17.718% #### ( 1, 2 ] 232499 64.434% 82.152% ############# ( 2, 3 ] 35041 9.711% 91.863% ## ( 3, 4 ] 14333 3.972% 95.835% # ( 4, 6 ] 10572 2.930% 98.765% # ( 6, 10 ] 3479 0.964% 99.729% ( 10, 15 ] 354 0.098% 99.827% ( 15, 22 ] 41 0.011% 99.838% ( 22, 34 ] 5 0.001% 99.840% ( 34, 51 ] 33 0.009% 99.849% ( 51, 76 ] 27 0.007% 99.856% ( 76, 110 ] 159 0.044% 99.901% ( 110, 170 ] 181 0.050% 99.951% ( 170, 250 ] 67 0.019% 99.969% ( 250, 380 ] 46 0.013% 99.982% ( 380, 580 ] 34 0.009% 99.991% ( 580, 870 ] 11 0.003% 99.994% ( 870, 1300 ] 14 0.004% 99.998% ( 1300, 1900 ] 5 0.001% 100.000% ( 1900, 2900 ] 1 0.000% 100.000% ** Level 2 read latency histogram (micros): Count: 28267 Average: 2.2417 StdDev: 9.85 Min: 1 Median: 1.3036 Max: 583 Percentiles: P50: 1.30 P75: 1.76 P99: 5.77 P99.9: 137.81 P99.99: 527.81 ------------------------------------------------------ [ 0, 1 ] 9391 33.222% 33.222% ####### ( 1, 2 ] 15622 55.266% 88.488% ########### ( 2, 3 ] 1643 5.812% 94.301% # ( 3, 4 ] 883 3.124% 97.425% # ( 4, 6 ] 502 1.776% 99.200% ( 6, 10 ] 149 0.527% 99.728% ( 10, 15 ] 17 0.060% 99.788% ( 15, 22 ] 7 0.025% 99.813% ( 76, 110 ] 15 0.053% 99.866% ( 110, 170 ] 21 0.074% 99.940% ( 170, 250 ] 7 0.025% 99.965% ( 250, 380 ] 2 0.007% 99.972% ( 380, 580 ] 7 0.025% 99.996% ( 580, 870 ] 1 0.004% 100.000% ** Level 3 read latency histogram (micros): Count: 252673 Average: 3.4395 StdDev: 31.13 Min: 0 Median: 1.5594 Max: 3987 Percentiles: P50: 1.56 P75: 1.96 P99: 9.27 P99.9: 278.88 P99.99: 817.30 ------------------------------------------------------ [ 0, 1 ] 38811 15.360% 15.360% ### ( 1, 2 ] 156464 61.924% 77.284% ############ ( 2, 3 ] 28636 11.333% 88.617% ## ( 3, 4 ] 13675 5.412% 94.029% # ( 4, 6 ] 8996 3.560% 97.589% # ( 6, 10 ] 4359 1.725% 99.315% ( 10, 15 ] 585 0.232% 99.546% ( 15, 22 ] 85 0.034% 99.580% ( 22, 34 ] 25 0.010% 99.590% ( 34, 51 ] 25 0.010% 99.599% ( 51, 76 ] 6 0.002% 99.602% ( 76, 110 ] 217 0.086% 99.688% ( 110, 170 ] 360 0.142% 99.830% ( 170, 250 ] 149 0.059% 99.889% ( 250, 380 ] 123 0.049% 99.938% ( 380, 580 ] 90 0.036% 99.973% ( 580, 870 ] 51 0.020% 99.994% ( 870, 1300 ] 12 0.005% 99.998% ( 1300, 1900 ] 5 0.002% 100.000% ( 1900, 2900 ] 10 0.004% 100.004% ( 2900, 4400 ] 7 0.003% 100.007% ** Level 4 read latency histogram (micros): Count: 115 Average: 445.1913 StdDev: 962.89 Min: 0 Median: 5.2500 Max: 4899 Percentiles: P50: 5.25 P75: 282.50 P99: 4899.00 P99.9: 4899.00 P99.99: 4899.00 ------------------------------------------------------ [ 0, 1 ] 27 23.478% 23.478% ##### ( 1, 2 ] 22 19.130% 42.609% #### ( 2, 3 ] 4 3.478% 46.087% # ( 3, 4 ] 2 1.739% 47.826% ( 4, 6 ] 4 3.478% 51.304% # ( 6, 10 ] 5 4.348% 55.652% # ( 10, 15 ] 1 0.870% 56.522% ( 15, 22 ] 1 0.870% 57.391% ( 22, 34 ] 15 13.043% 70.435% ### ( 110, 170 ] 1 0.870% 71.304% ( 170, 250 ] 4 3.478% 74.783% # ( 250, 380 ] 1 0.870% 75.652% ( 380, 580 ] 3 2.609% 78.261% # ( 580, 870 ] 3 2.609% 80.870% # ( 870, 1300 ] 8 6.957% 87.826% # ( 1300, 1900 ] 5 4.348% 92.174% # ( 1900, 2900 ] 4 3.478% 95.652% # ( 2900, 4400 ] 3 2.609% 98.261% # ( 4400, 6600 ] 2 1.739% 100.000% ** Level 5 read latency histogram (micros): Count: 60 Average: 806.2167 StdDev: 1025.90 Min: 81 Median: 400.0000 Max: 4597 Percentiles: P50: 400.00 P75: 977.50 P99: 4597.00 P99.9: 4597.00 P99.99: 4597.00 ------------------------------------------------------ ( 76, 110 ] 11 18.333% 18.333% #### ( 110, 170 ] 6 10.000% 28.333% ## ( 170, 250 ] 4 6.667% 35.000% # ( 250, 380 ] 8 13.333% 48.333% ### ( 380, 580 ] 10 16.667% 65.000% ### ( 580, 870 ] 4 6.667% 71.667% # ( 870, 1300 ] 8 13.333% 85.000% ### ( 1300, 1900 ] 2 3.333% 88.333% # ( 1900, 2900 ] 3 5.000% 93.333% # ( 2900, 4400 ] 3 5.000% 98.333% # ( 4400, 6600 ] 1 1.667% 100.000% ** DB Stats ** Uptime(secs): 24.9 total, 4.4 interval Cumulative writes: 0 writes, 7000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 6.73 GB, 277.15 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:5.980 H:M:S, 24.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 223.90 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.669 H:M:S, 38.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/12/16-03:24:44 ... thread 0: (1000000,8000000) ops and (78128.8,213476.4) ops/second in (12.799382,37.474873) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 11/11 2.88 GB 0.0 7.5 0.0 7.5 15.1 7.6 0.0 2.0 147.8 297.7 52.00 48.34 137 0.380 7802K 15K 0.0 0.0 L1 23/23 2.10 GB 0.0 6.3 4.5 1.8 6.3 4.5 0.1 1.4 226.4 223.8 28.67 26.85 4 7.169 6591K 74K 0.0 0.0 L2 1/1 128.78 MB 0.0 0.1 0.1 0.0 0.1 0.1 2.5 1.8 245.7 245.6 0.45 0.43 1 0.453 113K 27 0.0 0.0 L3 20/4 1.15 GB 1.0 2.5 1.2 1.3 2.5 1.2 1.3 2.1 217.3 216.4 11.71 10.53 7 1.673 2561K 9738 0.0 0.0 L4 173/0 9.56 GB 1.0 0.9 0.8 0.1 0.9 0.8 1.2 1.1 176.3 175.5 5.45 4.37 12 0.454 946K 4575 0.0 0.0 L5 1068/0 87.78 GB 0.9 0.0 0.0 0.0 0.0 0.0 2.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1296/39 103.60 GB 0.0 17.4 6.6 10.8 24.9 14.1 7.0 3.3 181.0 259.4 98.29 90.52 161 0.610 18M 103K 0.0 0.0 Int 0/0 0.00 KB 0.0 17.4 6.6 10.8 24.9 14.1 7.0 3.3 181.0 259.4 98.29 90.52 161 0.610 18M 103K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 17.4 6.6 10.8 17.3 6.5 0.0 0.0 234.4 233.0 75.91 70.68 48 1.582 18M 103K 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 349.1 22.37 19.84 113 0.198 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 37.7 total, 37.5 interval Flush(GB): cumulative 7.629, interval 7.629 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 24.90 GB write, 677.11 MB/s write, 17.37 GB read, 472.44 MB/s read, 98.3 seconds Interval compaction: 24.90 GB write, 680.37 MB/s write, 17.37 GB read, 474.71 MB/s read, 98.3 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 22, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 22, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 21, pending-compaction-bytes-delays: 17, pending-compaction-bytes-stops: 0, total-delays: 39, total-stops: 21, interval: 60 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3323006 Average: 2.6736 StdDev: 17.10 Min: 0 Median: 1.4486 Max: 4607 Percentiles: P50: 1.45 P75: 1.83 P99: 7.01 P99.9: 143.21 P99.99: 266.89 ------------------------------------------------------ [ 0, 1 ] 692036 20.826% 20.826% #### ( 1, 2 ] 2160934 65.029% 85.855% ############# ( 2, 3 ] 245015 7.373% 93.228% # ( 3, 4 ] 118349 3.562% 96.790% # ( 4, 6 ] 66841 2.011% 98.801% ( 6, 10 ] 26142 0.787% 99.588% ( 10, 15 ] 2563 0.077% 99.665% ( 15, 22 ] 453 0.014% 99.679% ( 22, 34 ] 36 0.001% 99.680% ( 34, 51 ] 18 0.001% 99.680% ( 51, 76 ] 186 0.006% 99.686% ( 76, 110 ] 4716 0.142% 99.828% ( 110, 170 ] 4330 0.130% 99.958% ( 170, 250 ] 977 0.029% 99.988% ( 250, 380 ] 621 0.019% 100.006% ( 380, 580 ] 482 0.015% 100.021% ( 580, 870 ] 225 0.007% 100.028% ( 870, 1300 ] 78 0.002% 100.030% ( 1300, 1900 ] 30 0.001% 100.031% ( 1900, 2900 ] 26 0.001% 100.032% ( 2900, 4400 ] 20 0.001% 100.032% ( 4400, 6600 ] 1 0.000% 100.032% ** Level 1 read latency histogram (micros): Count: 899524 Average: 2.9967 StdDev: 23.04 Min: 0 Median: 1.5382 Max: 4243 Percentiles: P50: 1.54 P75: 1.92 P99: 8.41 P99.9: 156.90 P99.99: 416.41 ------------------------------------------------------ [ 0, 1 ] 134446 14.946% 14.946% ### ( 1, 2 ] 585908 65.135% 80.082% ############# ( 2, 3 ] 89906 9.995% 90.077% ## ( 3, 4 ] 41992 4.668% 94.745% # ( 4, 6 ] 30547 3.396% 98.141% # ( 6, 10 ] 12819 1.425% 99.566% ( 10, 15 ] 1257 0.140% 99.706% ( 15, 22 ] 137 0.015% 99.721% ( 22, 34 ] 12 0.001% 99.722% ( 34, 51 ] 34 0.004% 99.726% ( 51, 76 ] 55 0.006% 99.732% ( 76, 110 ] 740 0.082% 99.814% ( 110, 170 ] 987 0.110% 99.924% ( 170, 250 ] 293 0.033% 99.957% ( 250, 380 ] 267 0.030% 99.986% ( 380, 580 ] 187 0.021% 100.007% ( 580, 870 ] 101 0.011% 100.018% ( 870, 1300 ] 49 0.005% 100.024% ( 1300, 1900 ] 25 0.003% 100.026% ( 1900, 2900 ] 20 0.002% 100.029% ( 2900, 4400 ] 8 0.001% 100.030% ** Level 2 read latency histogram (micros): Count: 28267 Average: 2.2417 StdDev: 9.85 Min: 1 Median: 1.3036 Max: 583 Percentiles: P50: 1.30 P75: 1.76 P99: 5.77 P99.9: 137.81 P99.99: 527.81 ------------------------------------------------------ [ 0, 1 ] 9391 33.222% 33.222% ####### ( 1, 2 ] 15622 55.266% 88.488% ########### ( 2, 3 ] 1643 5.812% 94.301% # ( 3, 4 ] 883 3.124% 97.425% # ( 4, 6 ] 502 1.776% 99.200% ( 6, 10 ] 149 0.527% 99.728% ( 10, 15 ] 17 0.060% 99.788% ( 15, 22 ] 7 0.025% 99.813% ( 76, 110 ] 15 0.053% 99.866% ( 110, 170 ] 21 0.074% 99.940% ( 170, 250 ] 7 0.025% 99.965% ( 250, 380 ] 2 0.007% 99.972% ( 380, 580 ] 7 0.025% 99.996% ( 580, 870 ] 1 0.004% 100.000% ** Level 3 read latency histogram (micros): Count: 501796 Average: 3.8231 StdDev: 37.10 Min: 0 Median: 1.6865 Max: 5541 Percentiles: P50: 1.69 P75: 2.47 P99: 8.87 P99.9: 151.25 P99.99: 247.28 ------------------------------------------------------ [ 0, 1 ] 52288 10.420% 10.420% ## ( 1, 2 ] 289293 57.652% 68.072% ############ ( 2, 3 ] 73574 14.662% 82.734% ### ( 3, 4 ] 40926 8.156% 90.890% ## ( 4, 6 ] 34406 6.857% 97.746% # ( 6, 10 ] 8781 1.750% 99.496% ( 10, 15 ] 1204 0.240% 99.736% ( 15, 22 ] 142 0.028% 99.764% ( 22, 34 ] 30 0.006% 99.770% ( 34, 51 ] 25 0.005% 99.775% ( 51, 76 ] 9 0.002% 99.777% ( 76, 110 ] 259 0.052% 99.829% ( 110, 170 ] 521 0.104% 99.933% ( 170, 250 ] 299 0.060% 99.992% ( 250, 380 ] 243 0.048% 100.041% ( 380, 580 ] 213 0.042% 100.083% ( 580, 870 ] 140 0.028% 100.111% ( 870, 1300 ] 57 0.011% 100.122% ( 1300, 1900 ] 17 0.003% 100.126% ( 1900, 2900 ] 20 0.004% 100.130% ( 2900, 4400 ] 17 0.003% 100.133% ( 4400, 6600 ] 3 0.001% 100.134% ** Level 4 read latency histogram (micros): Count: 225 Average: 321.0933 StdDev: 795.31 Min: 0 Median: 2.9750 Max: 4899 Percentiles: P50: 2.98 P75: 181.67 P99: 4306.25 P99.9: 4899.00 P99.99: 4899.00 ------------------------------------------------------ [ 0, 1 ] 38 16.889% 16.889% ### ( 1, 2 ] 55 24.444% 41.333% ##### ( 2, 3 ] 20 8.889% 50.222% ## ( 3, 4 ] 4 1.778% 52.000% ( 4, 6 ] 12 5.333% 57.333% # ( 6, 10 ] 9 4.000% 61.333% # ( 10, 15 ] 2 0.889% 62.222% ( 15, 22 ] 8 3.556% 65.778% # ( 22, 34 ] 15 6.667% 72.444% # ( 34, 51 ] 3 1.333% 73.778% ( 110, 170 ] 1 0.444% 74.222% ( 170, 250 ] 12 5.333% 79.556% # ( 250, 380 ] 5 2.222% 81.778% ( 380, 580 ] 5 2.222% 84.000% ( 580, 870 ] 5 2.222% 86.222% ( 870, 1300 ] 13 5.778% 92.000% # ( 1300, 1900 ] 6 2.667% 94.667% # ( 1900, 2900 ] 6 2.667% 97.333% # ( 2900, 4400 ] 4 1.778% 99.111% ( 4400, 6600 ] 2 0.889% 100.000% ** Level 5 read latency histogram (micros): Count: 120 Average: 886.7583 StdDev: 1031.18 Min: 81 Median: 424.4444 Max: 4597 Percentiles: P50: 424.44 P75: 1085.00 P99: 4362.50 P99.9: 4597.00 P99.99: 4597.00 ------------------------------------------------------ ( 76, 110 ] 12 10.000% 10.000% ## ( 110, 170 ] 12 10.000% 20.000% ## ( 170, 250 ] 12 10.000% 30.000% ## ( 250, 380 ] 20 16.667% 46.667% ### ( 380, 580 ] 18 15.000% 61.667% ### ( 580, 870 ] 11 9.167% 70.833% ## ( 870, 1300 ] 10 8.333% 79.167% ## ( 1300, 1900 ] 8 6.667% 85.833% # ( 1900, 2900 ] 8 6.667% 92.500% # ( 2900, 4400 ] 8 6.667% 99.167% # ( 4400, 6600 ] 1 0.833% 100.000% ** DB Stats ** Uptime(secs): 37.7 total, 12.8 interval Cumulative writes: 0 writes, 8000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 7.69 GB, 209.09 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.840 H:M:S, 42.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 76.89 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:9.860 H:M:S, 77.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/12/16-03:24:47 ... thread 0: (1000000,9000000) ops and (314094.4,221355.2) ops/second in (3.183756,40.658629) 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/11 3.80 GB 100.7 8.4 0.0 8.4 16.8 8.5 0.0 2.0 147.2 296.3 58.19 53.86 152 0.383 8697K 16K 0.0 0.0 L1 23/23 2.10 GB 0.0 6.3 4.5 1.8 6.3 4.5 0.1 1.4 226.4 223.8 28.67 26.85 4 7.169 6591K 74K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.0 0.1 0.1 2.5 1.8 245.7 245.6 0.45 0.43 1 0.453 113K 27 0.0 0.0 L3 15/0 967.94 MB 1.0 2.8 1.3 1.5 2.8 1.3 1.3 2.2 218.0 217.0 13.13 11.85 8 1.641 2884K 12K 0.0 0.0 L4 177/0 9.52 GB 1.0 1.3 1.2 0.2 1.3 1.2 1.2 1.1 162.2 161.5 8.29 6.15 18 0.461 1337K 6599 0.0 0.0 L5 1072/0 88.15 GB 0.9 0.0 0.0 0.0 0.0 0.0 2.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1302/34 104.52 GB 0.0 18.9 7.1 11.9 27.3 15.4 7.4 3.2 178.2 257.1 108.73 99.14 183 0.594 19M 109K 0.0 0.0 Int 0/0 0.00 KB 0.0 18.9 7.1 11.9 27.3 15.4 7.4 3.2 178.2 257.1 108.73 99.14 183 0.594 19M 109K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 18.9 7.1 11.9 18.8 7.0 0.0 0.0 231.8 230.5 83.58 77.05 58 1.441 19M 109K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 8.5 8.5 0.0 0.0 0.0 345.7 25.15 22.10 125 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): 40.8 total, 40.7 interval Flush(GB): cumulative 8.490, interval 8.490 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 27.30 GB write, 684.58 MB/s write, 18.92 GB read, 474.41 MB/s read, 108.7 seconds Interval compaction: 27.30 GB write, 687.61 MB/s write, 18.92 GB read, 476.51 MB/s read, 108.7 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 22, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 22, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 24, pending-compaction-bytes-delays: 18, pending-compaction-bytes-stops: 0, total-delays: 40, total-stops: 24, interval: 64 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3718764 Average: 2.6609 StdDev: 18.87 Min: 0 Median: 1.4562 Max: 6864 Percentiles: P50: 1.46 P75: 1.84 P99: 6.91 P99.9: 137.35 P99.99: 245.41 ------------------------------------------------------ [ 0, 1 ] 755040 20.304% 20.304% #### ( 1, 2 ] 2420688 65.094% 85.397% ############# ( 2, 3 ] 285174 7.669% 93.066% ## ( 3, 4 ] 135413 3.641% 96.707% # ( 4, 6 ] 78483 2.110% 98.818% ( 6, 10 ] 29794 0.801% 99.619% ( 10, 15 ] 2938 0.079% 99.698% ( 15, 22 ] 505 0.014% 99.711% ( 22, 34 ] 42 0.001% 99.713% ( 34, 51 ] 23 0.001% 99.713% ( 51, 76 ] 189 0.005% 99.718% ( 76, 110 ] 4750 0.128% 99.846% ( 110, 170 ] 4403 0.118% 99.964% ( 170, 250 ] 1009 0.027% 99.992% ( 250, 380 ] 650 0.017% 100.009% ( 380, 580 ] 506 0.014% 100.023% ( 580, 870 ] 241 0.006% 100.029% ( 870, 1300 ] 84 0.002% 100.031% ( 1300, 1900 ] 31 0.001% 100.032% ( 1900, 2900 ] 35 0.001% 100.033% ( 2900, 4400 ] 34 0.001% 100.034% ( 4400, 6600 ] 2 0.000% 100.034% ( 6600, 9900 ] 1 0.000% 100.034% ** Level 1 read latency histogram (micros): Count: 900997 Average: 3.0091 StdDev: 23.10 Min: 0 Median: 1.5383 Max: 4243 Percentiles: P50: 1.54 P75: 1.92 P99: 8.43 P99.9: 158.38 P99.99: 422.38 ------------------------------------------------------ [ 0, 1 ] 134592 14.938% 14.938% ### ( 1, 2 ] 586889 65.138% 80.076% ############# ( 2, 3 ] 90090 9.999% 90.075% ## ( 3, 4 ] 42030 4.665% 94.740% # ( 4, 6 ] 30585 3.395% 98.134% # ( 6, 10 ] 12841 1.425% 99.559% ( 10, 15 ] 1258 0.140% 99.699% ( 15, 22 ] 138 0.015% 99.714% ( 22, 34 ] 12 0.001% 99.716% ( 34, 51 ] 34 0.004% 99.719% ( 51, 76 ] 55 0.006% 99.726% ( 76, 110 ] 740 0.082% 99.808% ( 110, 170 ] 1033 0.115% 99.922% ( 170, 250 ] 297 0.033% 99.955% ( 250, 380 ] 273 0.030% 99.986% ( 380, 580 ] 193 0.021% 100.007% ( 580, 870 ] 102 0.011% 100.018% ( 870, 1300 ] 49 0.005% 100.024% ( 1300, 1900 ] 25 0.003% 100.027% ( 1900, 2900 ] 20 0.002% 100.029% ( 2900, 4400 ] 8 0.001% 100.030% ** Level 2 read latency histogram (micros): Count: 28267 Average: 2.2417 StdDev: 9.85 Min: 1 Median: 1.3036 Max: 583 Percentiles: P50: 1.30 P75: 1.76 P99: 5.77 P99.9: 137.81 P99.99: 527.81 ------------------------------------------------------ [ 0, 1 ] 9391 33.222% 33.222% ####### ( 1, 2 ] 15622 55.266% 88.488% ########### ( 2, 3 ] 1643 5.812% 94.301% # ( 3, 4 ] 883 3.124% 97.425% # ( 4, 6 ] 502 1.776% 99.200% ( 6, 10 ] 149 0.527% 99.728% ( 10, 15 ] 17 0.060% 99.788% ( 15, 22 ] 7 0.025% 99.813% ( 76, 110 ] 15 0.053% 99.866% ( 110, 170 ] 21 0.074% 99.940% ( 170, 250 ] 7 0.025% 99.965% ( 250, 380 ] 2 0.007% 99.972% ( 380, 580 ] 7 0.025% 99.996% ( 580, 870 ] 1 0.004% 100.000% ** Level 3 read latency histogram (micros): Count: 600328 Average: 4.0736 StdDev: 42.95 Min: 0 Median: 1.7193 Max: 6747 Percentiles: P50: 1.72 P75: 2.58 P99: 8.88 P99.9: 155.17 P99.99: 261.66 ------------------------------------------------------ [ 0, 1 ] 55547 9.253% 9.253% ## ( 1, 2 ] 340074 56.648% 65.901% ########### ( 2, 3 ] 93447 15.566% 81.467% ### ( 3, 4 ] 52303 8.712% 90.179% ## ( 4, 6 ] 45417 7.565% 97.745% ## ( 6, 10 ] 10481 1.746% 99.490% ( 10, 15 ] 1512 0.252% 99.742% ( 15, 22 ] 165 0.027% 99.770% ( 22, 34 ] 32 0.005% 99.775% ( 34, 51 ] 25 0.004% 99.779% ( 51, 76 ] 10 0.002% 99.781% ( 76, 110 ] 272 0.045% 99.826% ( 110, 170 ] 588 0.098% 99.924% ( 170, 250 ] 366 0.061% 99.985% ( 250, 380 ] 323 0.054% 100.039% ( 380, 580 ] 308 0.051% 100.090% ( 580, 870 ] 191 0.032% 100.122% ( 870, 1300 ] 71 0.012% 100.134% ( 1300, 1900 ] 27 0.004% 100.138% ( 1900, 2900 ] 28 0.005% 100.143% ( 2900, 4400 ] 31 0.005% 100.148% ( 4400, 6600 ] 4 0.001% 100.149% ( 6600, 9900 ] 1 0.000% 100.149% ** Level 4 read latency histogram (micros): Count: 290 Average: 274.8000 StdDev: 737.10 Min: 0 Median: 2.9310 Max: 4899 Percentiles: P50: 2.93 P75: 39.10 P99: 4130.00 P99.9: 4899.00 P99.99: 4899.00 ------------------------------------------------------ [ 0, 1 ] 47 16.207% 16.207% ### ( 1, 2 ] 71 24.483% 40.690% ##### ( 2, 3 ] 29 10.000% 50.690% ## ( 3, 4 ] 14 4.828% 55.517% # ( 4, 6 ] 16 5.517% 61.034% # ( 6, 10 ] 9 3.103% 64.138% # ( 10, 15 ] 3 1.034% 65.172% ( 15, 22 ] 10 3.448% 68.621% # ( 22, 34 ] 17 5.862% 74.483% # ( 34, 51 ] 5 1.724% 76.207% ( 110, 170 ] 2 0.690% 76.897% ( 170, 250 ] 16 5.517% 82.414% # ( 250, 380 ] 5 1.724% 84.138% ( 380, 580 ] 7 2.414% 86.552% ( 580, 870 ] 5 1.724% 88.276% ( 870, 1300 ] 15 5.172% 93.448% # ( 1300, 1900 ] 6 2.069% 95.517% ( 1900, 2900 ] 6 2.069% 97.586% ( 2900, 4400 ] 5 1.724% 99.310% ( 4400, 6600 ] 2 0.690% 100.000% ** Level 5 read latency histogram (micros): Count: 140 Average: 857.0286 StdDev: 995.04 Min: 81 Median: 410.0000 Max: 4597 Percentiles: P50: 410.00 P75: 1104.55 P99: 4325.00 P99.9: 4597.00 P99.99: 4597.00 ------------------------------------------------------ ( 76, 110 ] 16 11.429% 11.429% ## ( 110, 170 ] 15 10.714% 22.143% ## ( 170, 250 ] 16 11.429% 33.571% ## ( 250, 380 ] 20 14.286% 47.857% ### ( 380, 580 ] 20 14.286% 62.143% ### ( 580, 870 ] 12 8.571% 70.714% ## ( 870, 1300 ] 11 7.857% 78.571% ## ( 1300, 1900 ] 11 7.857% 86.429% ## ( 1900, 2900 ] 10 7.143% 93.571% # ( 2900, 4400 ] 8 5.714% 99.286% # ( 4400, 6600 ] 1 0.714% 100.000% ** DB Stats ** Uptime(secs): 40.8 total, 3.2 interval Cumulative writes: 0 writes, 9000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 8.65 GB, 216.88 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:16.308 H:M:S, 39.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 309.12 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.468 H:M:S, 14.7 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 : 6.467 micros/op 154619 ops/sec 60.426 seconds 9342999 operations; 149.8 MB/s Microseconds per write: Count: 9342999 Average: 6.4673 StdDev: 368.83 Min: 1 Median: 1.7613 Max: 848425 Percentiles: P50: 1.76 P75: 2.79 P99: 9.10 P99.9: 1215.72 P99.99: 2757.98 ------------------------------------------------------ [ 0, 1 ] 1123247 12.022% 12.022% ## ( 1, 2 ] 4660952 49.887% 61.909% ########## ( 2, 3 ] 1542811 16.513% 78.422% ### ( 3, 4 ] 1316115 14.087% 92.509% ### ( 4, 6 ] 525148 5.621% 98.130% # ( 6, 10 ] 104983 1.124% 99.254% ( 10, 15 ] 27694 0.296% 99.550% ( 15, 22 ] 7289 0.078% 99.628% ( 22, 34 ] 1633 0.017% 99.645% ( 34, 51 ] 202 0.002% 99.648% ( 51, 76 ] 30 0.000% 99.648% ( 76, 110 ] 6374 0.068% 99.716% ( 110, 170 ] 2686 0.029% 99.745% ( 170, 250 ] 308 0.003% 99.748% ( 250, 380 ] 108 0.001% 99.749% ( 380, 580 ] 16 0.000% 99.750% ( 580, 870 ] 14 0.000% 99.750% ( 870, 1300 ] 17470 0.187% 99.937% ( 1300, 1900 ] 47 0.001% 99.937% ( 1900, 2900 ] 5755 0.062% 99.999% ( 2900, 4400 ] 74 0.001% 100.000% ( 4400, 6600 ] 15 0.000% 100.000% ( 6600, 9900 ] 7 0.000% 100.000% ( 9900, 14000 ] 2 0.000% 100.000% ( 14000, 22000 ] 2 0.000% 100.000% ( 22000, 33000 ] 1 0.000% 100.000% ( 33000, 50000 ] 2 0.000% 100.000% ( 110000, 170000 ] 1 0.000% 100.000% ( 170000, 250000 ] 12 0.000% 100.000% ( 570000, 860000 ] 1 0.000% 100.000% STATISTICS: rocksdb.block.cache.miss COUNT : 0 rocksdb.block.cache.hit COUNT : 0 rocksdb.block.cache.add COUNT : 0 rocksdb.block.cache.add.failures COUNT : 0 rocksdb.block.cache.index.miss COUNT : 0 rocksdb.block.cache.index.hit COUNT : 0 rocksdb.block.cache.index.add COUNT : 0 rocksdb.block.cache.index.bytes.insert COUNT : 0 rocksdb.block.cache.filter.miss COUNT : 0 rocksdb.block.cache.filter.hit COUNT : 0 rocksdb.block.cache.filter.add COUNT : 0 rocksdb.block.cache.filter.bytes.insert COUNT : 0 rocksdb.block.cache.data.miss COUNT : 0 rocksdb.block.cache.data.hit COUNT : 0 rocksdb.block.cache.data.add COUNT : 0 rocksdb.block.cache.data.bytes.insert COUNT : 0 rocksdb.block.cache.bytes.read COUNT : 0 rocksdb.block.cache.bytes.write COUNT : 0 rocksdb.bloom.filter.useful COUNT : 0 rocksdb.bloom.filter.full.positive COUNT : 0 rocksdb.bloom.filter.full.true.positive COUNT : 0 rocksdb.persistent.cache.hit COUNT : 0 rocksdb.persistent.cache.miss COUNT : 0 rocksdb.sim.block.cache.hit COUNT : 0 rocksdb.sim.block.cache.miss COUNT : 0 rocksdb.memtable.hit COUNT : 0 rocksdb.memtable.miss COUNT : 0 rocksdb.l0.hit COUNT : 0 rocksdb.l1.hit COUNT : 0 rocksdb.l2andup.hit COUNT : 0 rocksdb.compaction.key.drop.new COUNT : 225256 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 : 9342999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 9641974968 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 : 518 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 34572074 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 : 30329003918 rocksdb.compact.write.bytes COUNT : 30093766314 rocksdb.flush.write.bytes COUNT : 9578253659 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 : 38 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 : 277 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 : 9501053952 rocksdb.memtable.garbage.bytes.at.flush COUNT : 3728384 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 : 30414417794 rocksdb.non.last.level.read.count COUNT : 7349281 rocksdb.block.checksum.compute.count COUNT : 7348283 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.416018 P95 : 3.920859 P99 : 7.700313 P100 : 848423.000000 COUNT : 9342999 SUM : 56022017 rocksdb.compaction.times.micros P50 : 1055000.000000 P95 : 4410000.000000 P99 : 18840000.000000 P100 : 21678272.000000 COUNT : 79 SUM : 131897452 rocksdb.compaction.times.cpu_micros P50 : 889310.344828 P95 : 4410000.000000 P99 : 18840000.000000 P100 : 19697905.000000 COUNT : 79 SUM : 113002229 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 : 670.895522 P95 : 1283.461538 P99 : 8910.000000 P100 : 28244.000000 COUNT : 130 SUM : 130552 rocksdb.compaction.outfile.sync.micros P50 : 853.116438 P95 : 142076.923077 P99 : 244577.777778 P100 : 284986.000000 COUNT : 361 SUM : 7638693 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 : 97.378788 P95 : 1063.500000 P99 : 2562.500000 P100 : 6982.000000 COUNT : 235 SUM : 59912 rocksdb.table.open.io.micros P50 : 1364.000000 P95 : 6059.166667 P99 : 9174.000000 P100 : 10791.000000 COUNT : 518 SUM : 962264 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.539960 P95 : 7.482033 P99 : 11.879912 P100 : 18991.000000 COUNT : 7347006 SUM : 43079445 rocksdb.read.block.get.micros P50 : 415.185185 P95 : 2907.142857 P99 : 4387.142857 P100 : 5557.000000 COUNT : 1036 SUM : 798802 rocksdb.write.raw.block.micros P50 : 0.513511 P95 : 0.975671 P99 : 2.929788 P100 : 25648.000000 COUNT : 9611455 SUM : 18502012 rocksdb.numfiles.in.singlecompaction P50 : 3.194444 P95 : 6.600000 P99 : 25.960000 P100 : 30.000000 COUNT : 134 SUM : 539 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.558674 P95 : 1170.358962 P99 : 2529.139130 P100 : 848224.000000 COUNT : 223045 SUM : 34588186 rocksdb.sst.read.micros P50 : 1.520992 P95 : 4.474090 P99 : 8.868314 P100 : 18987.000000 COUNT : 7349775 SUM : 28389769 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 : 9342999 SUM : 9641974968 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 : 210000.000000 P95 : 345588.235294 P99 : 513000.000000 P100 : 1022694.000000 COUNT : 130 SUM : 27292382 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 : 338 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