[2024-11-18 08:35:57.015211] Starting SPDK v24.01.1-pre git sha1 c13c99a5e / DPDK 22.11.4 initialization... [2024-11-18 08:35:57.015495] [ 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_pid690259 ] Set seed to 1731915357008518 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-11-18 08:35:57.117726] app.c: 798:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-11-18 08:35:57.159171] app.c: 488:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-11-18 08:35:57.159219] app.c: 489:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 690259' to capture a snapshot of events at runtime. [2024-11-18 08:35:57.159232] app.c: 494:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid690259 for offline analysis/debug. [2024-11-18 08:35:57.159258] reactor.c: 937:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Mon Nov 18 08:36:01 2024 CPU: 96 * Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz CPUCache: 36608 KB 2024/11/18-08:36:04 ... thread 0: (1000000,1000000) ops and (337050.2,337050.2) ops/second in (2.966917,2.966917) 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/6 629.98 MB 25.2 0.0 0.0 0.0 0.9 0.9 0.0 1.0 0.0 351.6 2.51 2.27 12 0.209 0 0 0.0 0.0 L2 3/2 251.74 MB 0.0 0.4 0.2 0.2 0.4 0.2 0.2 2.0 245.7 245.5 1.54 1.49 2 0.769 383K 213 0.0 0.0 L3 12/0 993.12 MB 1.0 0.0 0.0 0.0 0.0 0.0 0.1 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 116/0 9.60 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1040/0 85.57 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1180/8 97.00 GB 0.0 0.4 0.2 0.2 1.2 1.0 0.3 1.4 93.4 311.3 4.05 3.76 14 0.289 383K 213 0.0 0.0 Int 0/0 0.00 KB 0.0 0.4 0.2 0.2 1.2 1.0 0.2 1.4 93.4 311.3 4.05 3.76 14 0.289 383K 213 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.2 0.2 0.4 0.2 0.0 0.0 245.7 245.5 1.54 1.49 2 0.769 383K 213 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.6 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.2 total, 3.0 interval Flush(GB): cumulative 0.861, interval 0.861 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 1.23 GB write, 393.66 MB/s write, 0.37 GB read, 118.11 MB/s read, 4.0 seconds Interval compaction: 1.23 GB write, 424.33 MB/s write, 0.37 GB read, 127.31 MB/s read, 4.0 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 2, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 2, interval: 2 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 110858 Average: 1.9241 StdDev: 18.77 Min: 1 Median: 1.2275 Max: 3360 Percentiles: P50: 1.23 P75: 1.67 P99: 4.17 P99.9: 9.94 P99.99: 344.71 ------------------------------------------------------ [ 0, 1 ] 41100 37.074% 37.074% ####### ( 1, 2 ] 62983 56.814% 93.889% ########### ( 2, 3 ] 4022 3.628% 97.517% # ( 3, 4 ] 1580 1.425% 98.942% ( 4, 6 ] 759 0.685% 99.627% ( 6, 10 ] 309 0.279% 99.905% ( 10, 15 ] 59 0.053% 99.959% ( 15, 22 ] 15 0.014% 99.972% ( 22, 34 ] 5 0.005% 99.977% ( 34, 51 ] 3 0.003% 99.979% ( 110, 170 ] 8 0.007% 99.986% ( 170, 250 ] 2 0.002% 99.988% ( 250, 380 ] 4 0.004% 99.992% ( 580, 870 ] 1 0.001% 99.993% ( 870, 1300 ] 3 0.003% 99.995% ( 1300, 1900 ] 3 0.003% 99.998% ( 1900, 2900 ] 1 0.001% 99.999% ( 2900, 4400 ] 2 0.002% 100.001% ** Level 1 read latency histogram (micros): Count: 5 Average: 709.0000 StdDev: 818.18 Min: 57 Median: 210.0000 Max: 2194 Percentiles: P50: 210.00 P75: 1192.50 P99: 2194.00 P99.9: 2194.00 P99.99: 2194.00 ------------------------------------------------------ ( 51, 76 ] 2 40.000% 40.000% ######## ( 170, 250 ] 1 20.000% 60.000% #### ( 870, 1300 ] 1 20.000% 80.000% #### ( 1900, 2900 ] 1 20.000% 100.000% #### ** Level 2 read latency histogram (micros): Count: 60087 Average: 1.8604 StdDev: 6.48 Min: 1 Median: 1.2693 Max: 1095 Percentiles: P50: 1.27 P75: 1.70 P99: 4.89 P99.9: 9.96 P99.99: 75.78 ------------------------------------------------------ [ 0, 1 ] 20635 34.342% 34.342% ####### ( 1, 2 ] 34940 58.149% 92.491% ############ ( 2, 3 ] 2368 3.941% 96.432% # ( 3, 4 ] 1269 2.112% 98.544% ( 4, 6 ] 619 1.030% 99.574% ( 6, 10 ] 199 0.331% 99.905% ( 10, 15 ] 41 0.068% 99.973% ( 15, 22 ] 8 0.013% 99.987% ( 22, 34 ] 2 0.003% 99.990% ( 51, 76 ] 1 0.002% 99.992% ( 250, 380 ] 1 0.002% 99.993% ( 380, 580 ] 2 0.003% 99.997% ( 580, 870 ] 2 0.003% 100.000% ( 870, 1300 ] 1 0.002% 100.002% ** Level 3 read latency histogram (micros): Count: 55 Average: 1716.6727 StdDev: 1302.00 Min: 172 Median: 1199.6667 Max: 5095 Percentiles: P50: 1199.67 P75: 2650.00 P99: 5095.00 P99.9: 5095.00 P99.99: 5095.00 ------------------------------------------------------ ( 170, 250 ] 2 3.636% 3.636% # ( 250, 380 ] 2 3.636% 7.273% # ( 380, 580 ] 5 9.091% 16.364% ## ( 580, 870 ] 7 12.727% 29.091% ### ( 870, 1300 ] 15 27.273% 56.364% ##### ( 1300, 1900 ] 5 9.091% 65.455% ## ( 1900, 2900 ] 7 12.727% 78.182% ### ( 2900, 4400 ] 8 14.545% 92.727% ### ( 4400, 6600 ] 4 7.273% 100.000% # ** Level 4 read latency histogram (micros): Count: 20 Average: 1748.5000 StdDev: 1185.08 Min: 431 Median: 1246.2500 Max: 4377 Percentiles: P50: 1246.25 P75: 2566.67 P99: 4325.00 P99.9: 4377.00 P99.99: 4377.00 ------------------------------------------------------ ( 380, 580 ] 2 10.000% 10.000% ## ( 580, 870 ] 1 5.000% 15.000% # ( 870, 1300 ] 8 40.000% 55.000% ######## ( 1300, 1900 ] 2 10.000% 65.000% ## ( 1900, 2900 ] 3 15.000% 80.000% ### ( 2900, 4400 ] 4 20.000% 100.000% #### ** DB Stats ** Uptime(secs): 3.2 total, 3.0 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 307.56 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:0.412 H:M:S, 12.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 331.43 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.412 H:M:S, 13.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/18-08:36:07 ... thread 0: (1000000,2000000) ops and (322467.3,329597.5) ops/second in (3.101090,6.068007) 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.23 GB 69.2 0.6 0.0 0.6 2.4 1.8 0.0 1.3 74.4 322.5 7.62 7.00 28 0.272 575K 575 0.0 0.0 L1 1/0 3.88 MB 0.4 0.4 0.4 0.0 0.4 0.4 0.2 1.0 238.0 237.6 1.59 1.54 1 1.588 383K 626 0.0 0.0 L2 2/1 53.95 MB 0.5 0.4 0.2 0.2 0.4 0.2 0.5 2.0 245.7 245.5 1.54 1.49 2 0.769 383K 213 0.0 0.0 L3 18/8 1.00 GB 0.3 0.2 0.2 0.0 0.2 0.2 0.4 1.0 226.3 226.3 1.10 1.02 1 1.101 253K 0 0.0 0.0 L4 174/0 9.75 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.3 1.0 151.5 151.5 1.48 1.11 1 1.480 227K 0 0.0 0.0 L5 1044/0 85.94 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 1250/17 97.98 GB 0.0 1.8 1.0 0.7 3.6 2.9 1.9 1.9 134.8 276.5 13.32 12.16 33 0.404 1823K 1414 0.0 0.0 Int 0/0 0.00 KB 0.0 1.8 1.0 0.7 3.6 2.9 1.8 1.9 134.8 276.5 13.32 12.16 33 0.404 1823K 1414 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.8 1.0 0.7 1.8 1.0 0.0 0.0 227.2 227.0 7.91 7.32 7 1.129 1823K 1414 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 348.8 5.42 4.84 26 0.208 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.3 total, 6.1 interval Flush(GB): cumulative 1.846, interval 1.846 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.60 GB write, 584.79 MB/s write, 1.75 GB read, 285.09 MB/s read, 13.3 seconds Interval compaction: 3.60 GB write, 607.07 MB/s write, 1.75 GB read, 295.95 MB/s read, 13.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: 7, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 7, interval: 7 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 411337 Average: 2.1906 StdDev: 12.89 Min: 1 Median: 1.4604 Max: 3360 Percentiles: P50: 1.46 P75: 1.86 P99: 5.79 P99.9: 11.12 P99.99: 18.20 ------------------------------------------------------ [ 0, 1 ] 86707 21.079% 21.079% #### ( 1, 2 ] 258402 62.820% 83.899% ############# ( 2, 3 ] 35029 8.516% 92.415% ## ( 3, 4 ] 16505 4.013% 96.428% # ( 4, 6 ] 11812 2.872% 99.299% # ( 6, 10 ] 2371 0.576% 99.876% ( 10, 15 ] 448 0.109% 99.985% ( 15, 22 ] 50 0.012% 99.997% ( 22, 34 ] 10 0.002% 99.999% ( 34, 51 ] 5 0.001% 100.000% ( 110, 170 ] 11 0.003% 100.003% ( 170, 250 ] 11 0.003% 100.006% ( 250, 380 ] 10 0.002% 100.008% ( 380, 580 ] 4 0.001% 100.009% ( 580, 870 ] 4 0.001% 100.010% ( 870, 1300 ] 7 0.002% 100.012% ( 1300, 1900 ] 3 0.001% 100.013% ( 1900, 2900 ] 3 0.001% 100.013% ( 2900, 4400 ] 3 0.001% 100.014% ** Level 1 read latency histogram (micros): Count: 30 Average: 235.2333 StdDev: 450.78 Min: 1 Median: 2.8000 Max: 2194 Percentiles: P50: 2.80 P75: 271.67 P99: 2194.00 P99.9: 2194.00 P99.99: 2194.00 ------------------------------------------------------ [ 0, 1 ] 5 16.667% 16.667% ### ( 1, 2 ] 6 20.000% 36.667% #### ( 2, 3 ] 5 16.667% 53.333% ### ( 4, 6 ] 1 3.333% 56.667% # ( 51, 76 ] 2 6.667% 63.333% # ( 110, 170 ] 1 3.333% 66.667% # ( 170, 250 ] 2 6.667% 73.333% # ( 250, 380 ] 3 10.000% 83.333% ## ( 380, 580 ] 1 3.333% 86.667% # ( 580, 870 ] 2 6.667% 93.333% # ( 870, 1300 ] 1 3.333% 96.667% # ( 1900, 2900 ] 1 3.333% 100.000% # ** Level 2 read latency histogram (micros): Count: 95780 Average: 1.9802 StdDev: 5.18 Min: 1 Median: 1.3684 Max: 1095 Percentiles: P50: 1.37 P75: 1.78 P99: 5.46 P99.9: 10.58 P99.99: 24.53 ------------------------------------------------------ [ 0, 1 ] 26437 27.602% 27.602% ###### ( 1, 2 ] 58234 60.800% 88.402% ############ ( 2, 3 ] 5743 5.996% 94.398% # ( 3, 4 ] 3208 3.349% 97.747% # ( 4, 6 ] 1649 1.722% 99.469% ( 6, 10 ] 404 0.422% 99.890% ( 10, 15 ] 80 0.084% 99.974% ( 15, 22 ] 15 0.016% 99.990% ( 22, 34 ] 2 0.002% 99.992% ( 51, 76 ] 1 0.001% 99.993% ( 76, 110 ] 1 0.001% 99.994% ( 250, 380 ] 1 0.001% 99.995% ( 380, 580 ] 2 0.002% 99.997% ( 580, 870 ] 2 0.002% 99.999% ( 870, 1300 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 181187 Average: 3.5443 StdDev: 40.88 Min: 1 Median: 1.6510 Max: 5095 Percentiles: P50: 1.65 P75: 2.22 P99: 9.19 P99.9: 185.80 P99.99: 579.39 ------------------------------------------------------ [ 0, 1 ] 17642 9.737% 9.737% ## ( 1, 2 ] 112065 61.850% 71.587% ############ ( 2, 3 ] 28403 15.676% 87.263% ### ( 3, 4 ] 9724 5.367% 92.630% # ( 4, 6 ] 9044 4.992% 97.622% # ( 6, 10 ] 3132 1.729% 99.350% ( 10, 15 ] 622 0.343% 99.694% ( 15, 22 ] 108 0.060% 99.753% ( 22, 34 ] 30 0.017% 99.770% ( 34, 51 ] 7 0.004% 99.774% ( 51, 76 ] 1 0.001% 99.774% ( 76, 110 ] 68 0.038% 99.812% ( 110, 170 ] 145 0.080% 99.892% ( 170, 250 ] 75 0.041% 99.933% ( 250, 380 ] 64 0.035% 99.969% ( 380, 580 ] 39 0.022% 99.990% ( 580, 870 ] 20 0.011% 100.001% ( 870, 1300 ] 23 0.013% 100.014% ( 1300, 1900 ] 7 0.004% 100.018% ( 1900, 2900 ] 7 0.004% 100.022% ( 2900, 4400 ] 9 0.005% 100.026% ( 4400, 6600 ] 4 0.002% 100.029% ** Level 4 read latency histogram (micros): Count: 310 Average: 119.6677 StdDev: 523.79 Min: 0 Median: 2.0000 Max: 4377 Percentiles: P50: 2.00 P75: 5.91 P99: 3237.50 P99.9: 4283.75 P99.99: 4377.00 ------------------------------------------------------ [ 0, 1 ] 56 18.065% 18.065% #### ( 1, 2 ] 99 31.935% 50.000% ###### ( 2, 3 ] 53 17.097% 67.097% ### ( 3, 4 ] 14 4.516% 71.613% # ( 4, 6 ] 11 3.548% 75.161% # ( 6, 10 ] 12 3.871% 79.032% # ( 10, 15 ] 26 8.387% 87.419% ## ( 15, 22 ] 15 4.839% 92.258% # ( 110, 170 ] 2 0.645% 92.903% ( 170, 250 ] 1 0.323% 93.226% ( 380, 580 ] 3 0.968% 94.194% ( 580, 870 ] 1 0.323% 94.516% ( 870, 1300 ] 8 2.581% 97.097% # ( 1300, 1900 ] 2 0.645% 97.742% ( 1900, 2900 ] 3 0.968% 98.710% ( 2900, 4400 ] 4 1.290% 100.000% ** Level 5 read latency histogram (micros): Count: 20 Average: 766.9000 StdDev: 1122.25 Min: 78 Median: 170.0000 Max: 4524 Percentiles: P50: 170.00 P75: 1300.00 P99: 4524.00 P99.9: 4524.00 P99.99: 4524.00 ------------------------------------------------------ ( 76, 110 ] 5 25.000% 25.000% ##### ( 110, 170 ] 5 25.000% 50.000% ##### ( 250, 380 ] 3 15.000% 65.000% ### ( 380, 580 ] 1 5.000% 70.000% # ( 870, 1300 ] 1 5.000% 75.000% # ( 1300, 1900 ] 3 15.000% 90.000% ### ( 1900, 2900 ] 1 5.000% 95.000% # ( 4400, 6600 ] 1 5.000% 100.000% # ** DB Stats ** Uptime(secs): 6.3 total, 3.1 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 312.38 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.872 H:M:S, 13.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 317.37 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.459 H:M:S, 14.8 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/11/18-08:36:10 ... thread 0: (1000000,3000000) ops and (356202.9,338013.1) ops/second in (2.807389,8.875396) 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/12 2.09 GB 44.1 1.4 0.0 1.4 4.1 2.7 0.0 1.5 107.8 314.0 13.44 12.49 44 0.305 1471K 1596 0.0 0.0 L1 1/1 3.88 MB 0.0 0.4 0.4 0.0 0.4 0.4 0.2 1.0 238.0 237.6 1.59 1.54 1 1.588 383K 626 0.0 0.0 L2 1/0 51.40 MB 0.5 0.4 0.2 0.2 0.4 0.2 0.5 2.0 245.7 245.5 1.54 1.49 2 0.769 383K 213 0.0 0.0 L3 12/0 510.88 MB 0.5 0.9 0.2 0.7 0.9 0.2 0.4 3.7 224.6 224.2 4.14 3.87 2 2.070 944K 1798 0.0 0.0 L4 170/0 9.64 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.8 1.0 151.5 151.5 1.48 1.11 1 1.480 227K 0 0.0 0.0 L5 1052/0 86.55 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1251/13 98.84 GB 0.0 3.3 1.0 2.3 6.0 3.7 3.0 2.2 151.4 276.2 22.18 20.50 50 0.444 3410K 4233 0.0 0.0 Int 0/0 0.00 KB 0.0 3.3 1.0 2.3 6.0 3.7 2.9 2.2 151.4 276.2 22.18 20.50 50 0.444 3410K 4233 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 3.3 1.0 2.3 3.3 1.0 0.0 0.0 235.0 234.7 14.29 13.44 11 1.299 3410K 4233 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.06 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.1 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.98 GB write, 672.63 MB/s write, 3.28 GB read, 368.78 MB/s read, 22.2 seconds Interval compaction: 5.98 GB write, 690.16 MB/s write, 3.28 GB read, 378.39 MB/s read, 22.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: 9, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 9, interval: 9 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 697245 Average: 2.1642 StdDev: 11.94 Min: 1 Median: 1.4610 Max: 3360 Percentiles: P50: 1.46 P75: 1.85 P99: 5.69 P99.9: 10.55 P99.99: 14.76 ------------------------------------------------------ [ 0, 1 ] 141758 20.331% 20.331% #### ( 1, 2 ] 448765 64.363% 84.694% ############# ( 2, 3 ] 58565 8.399% 93.093% ## ( 3, 4 ] 26418 3.789% 96.882% # ( 4, 6 ] 17436 2.501% 99.383% # ( 6, 10 ] 3526 0.506% 99.889% ( 10, 15 ] 745 0.107% 99.995% ( 15, 22 ] 85 0.012% 100.008% ( 22, 34 ] 16 0.002% 100.010% ( 34, 51 ] 5 0.001% 100.011% ( 51, 76 ] 2 0.000% 100.011% ( 110, 170 ] 20 0.003% 100.014% ( 170, 250 ] 15 0.002% 100.016% ( 250, 380 ] 16 0.002% 100.018% ( 380, 580 ] 6 0.001% 100.019% ( 580, 870 ] 8 0.001% 100.020% ( 870, 1300 ] 11 0.002% 100.022% ( 1300, 1900 ] 4 0.001% 100.022% ( 1900, 2900 ] 3 0.000% 100.023% ( 2900, 4400 ] 5 0.001% 100.024% ** Level 1 read latency histogram (micros): Count: 28274 Average: 3.0942 StdDev: 24.12 Min: 1 Median: 1.4923 Max: 2194 Percentiles: P50: 1.49 P75: 1.87 P99: 8.73 P99.9: 304.65 P99.99: 944.22 ------------------------------------------------------ [ 0, 1 ] 4812 17.019% 17.019% ### ( 1, 2 ] 18942 66.994% 84.014% ############# ( 2, 3 ] 2441 8.633% 92.647% ## ( 3, 4 ] 955 3.378% 96.025% # ( 4, 6 ] 512 1.811% 97.835% ( 6, 10 ] 482 1.705% 99.540% ( 10, 15 ] 42 0.149% 99.689% ( 15, 22 ] 2 0.007% 99.696% ( 51, 76 ] 2 0.007% 99.703% ( 76, 110 ] 1 0.004% 99.706% ( 110, 170 ] 32 0.113% 99.820% ( 170, 250 ] 16 0.057% 99.876% ( 250, 380 ] 16 0.057% 99.933% ( 380, 580 ] 11 0.039% 99.972% ( 580, 870 ] 5 0.018% 99.989% ( 870, 1300 ] 1 0.004% 99.993% ( 1300, 1900 ] 1 0.004% 99.996% ( 1900, 2900 ] 1 0.004% 100.000% ** Level 2 read latency histogram (micros): Count: 95907 Average: 1.9809 StdDev: 5.18 Min: 1 Median: 1.3690 Max: 1095 Percentiles: P50: 1.37 P75: 1.78 P99: 5.46 P99.9: 10.57 P99.99: 24.46 ------------------------------------------------------ [ 0, 1 ] 26440 27.568% 27.568% ###### ( 1, 2 ] 58309 60.797% 88.366% ############ ( 2, 3 ] 5782 6.029% 94.395% # ( 3, 4 ] 3213 3.350% 97.745% # ( 4, 6 ] 1653 1.724% 99.468% ( 6, 10 ] 405 0.422% 99.891% ( 10, 15 ] 80 0.083% 99.974% ( 15, 22 ] 15 0.016% 99.990% ( 22, 34 ] 2 0.002% 99.992% ( 51, 76 ] 1 0.001% 99.993% ( 76, 110 ] 1 0.001% 99.994% ( 250, 380 ] 1 0.001% 99.995% ( 380, 580 ] 2 0.002% 99.997% ( 580, 870 ] 2 0.002% 99.999% ( 870, 1300 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 200893 Average: 3.5011 StdDev: 39.53 Min: 0 Median: 1.6345 Max: 5095 Percentiles: P50: 1.63 P75: 2.14 P99: 9.15 P99.9: 188.11 P99.99: 629.31 ------------------------------------------------------ [ 0, 1 ] 20741 10.324% 10.324% ## ( 1, 2 ] 125617 62.529% 72.854% ############# ( 2, 3 ] 30106 14.986% 87.840% ### ( 3, 4 ] 10280 5.117% 92.957% # ( 4, 6 ] 9402 4.680% 97.637% # ( 6, 10 ] 3479 1.732% 99.369% ( 10, 15 ] 635 0.316% 99.685% ( 15, 22 ] 108 0.054% 99.739% ( 22, 34 ] 31 0.015% 99.754% ( 34, 51 ] 8 0.004% 99.758% ( 51, 76 ] 1 0.000% 99.759% ( 76, 110 ] 91 0.045% 99.804% ( 110, 170 ] 175 0.087% 99.891% ( 170, 250 ] 80 0.040% 99.931% ( 250, 380 ] 69 0.034% 99.965% ( 380, 580 ] 46 0.023% 99.988% ( 580, 870 ] 23 0.011% 100.000% ( 870, 1300 ] 24 0.012% 100.011% ( 1300, 1900 ] 9 0.004% 100.016% ( 1900, 2900 ] 7 0.003% 100.019% ( 2900, 4400 ] 9 0.004% 100.024% ( 4400, 6600 ] 4 0.002% 100.026% ** Level 4 read latency histogram (micros): Count: 310 Average: 119.6677 StdDev: 523.79 Min: 0 Median: 2.0000 Max: 4377 Percentiles: P50: 2.00 P75: 5.91 P99: 3237.50 P99.9: 4283.75 P99.99: 4377.00 ------------------------------------------------------ [ 0, 1 ] 56 18.065% 18.065% #### ( 1, 2 ] 99 31.935% 50.000% ###### ( 2, 3 ] 53 17.097% 67.097% ### ( 3, 4 ] 14 4.516% 71.613% # ( 4, 6 ] 11 3.548% 75.161% # ( 6, 10 ] 12 3.871% 79.032% # ( 10, 15 ] 26 8.387% 87.419% ## ( 15, 22 ] 15 4.839% 92.258% # ( 110, 170 ] 2 0.645% 92.903% ( 170, 250 ] 1 0.323% 93.226% ( 380, 580 ] 3 0.968% 94.194% ( 580, 870 ] 1 0.323% 94.516% ( 870, 1300 ] 8 2.581% 97.097% # ( 1300, 1900 ] 2 0.645% 97.742% ( 1900, 2900 ] 3 0.968% 98.710% ( 2900, 4400 ] 4 1.290% 100.000% ** Level 5 read latency histogram (micros): Count: 60 Average: 812.2667 StdDev: 948.21 Min: 78 Median: 354.0000 Max: 4524 Percentiles: P50: 354.00 P75: 1300.00 P99: 4524.00 P99.9: 4524.00 P99.99: 4524.00 ------------------------------------------------------ ( 76, 110 ] 9 15.000% 15.000% ### ( 110, 170 ] 12 20.000% 35.000% #### ( 170, 250 ] 5 8.333% 43.333% ## ( 250, 380 ] 5 8.333% 51.667% ## ( 380, 580 ] 3 5.000% 56.667% # ( 580, 870 ] 7 11.667% 68.333% ## ( 870, 1300 ] 4 6.667% 75.000% # ( 1300, 1900 ] 7 11.667% 86.667% ## ( 1900, 2900 ] 6 10.000% 96.667% ## ( 2900, 4400 ] 1 1.667% 98.333% ( 4400, 6600 ] 1 1.667% 100.000% ** DB Stats ** Uptime(secs): 9.1 total, 2.8 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 324.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:1.098 H:M:S, 12.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 350.57 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.226 H:M:S, 8.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/18-08:36:13 ... thread 0: (1000000,4000000) ops and (325410.4,334771.8) ops/second in (3.073043,11.948439) 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/8 3.07 GB 169.9 2.5 0.0 2.5 6.1 3.7 0.0 1.7 123.9 309.6 20.34 19.03 62 0.328 2558K 2719 0.0 0.0 L1 1/1 3.88 MB 0.0 0.4 0.4 0.0 0.4 0.4 0.2 1.0 238.0 237.6 1.59 1.54 1 1.588 383K 626 0.0 0.0 L2 1/0 51.40 MB 0.5 0.4 0.2 0.2 0.4 0.2 0.5 2.0 245.7 245.5 1.54 1.49 2 0.769 383K 213 0.0 0.0 L3 12/0 510.88 MB 0.5 0.9 0.2 0.7 0.9 0.2 0.4 3.7 224.6 224.2 4.14 3.87 2 2.070 944K 1798 0.0 0.0 L4 170/0 9.64 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.8 1.0 151.5 151.5 1.48 1.11 1 1.480 227K 0 0.0 0.0 L5 1052/0 86.55 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1253/9 99.82 GB 0.0 4.3 1.0 3.3 8.0 4.7 3.0 2.2 152.3 282.1 29.09 27.03 68 0.428 4498K 5356 0.0 0.0 Int 0/0 0.00 KB 0.0 4.3 1.0 3.3 8.0 4.7 2.9 2.2 152.3 282.1 29.09 27.03 68 0.428 4498K 5356 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 4.3 1.0 3.3 4.3 1.0 0.0 0.0 241.4 241.1 18.35 17.42 15 1.224 4498K 5356 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 352.1 10.73 9.61 53 0.203 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.01 GB write, 673.51 MB/s write, 4.33 GB read, 363.67 MB/s read, 29.1 seconds Interval compaction: 8.01 GB write, 686.54 MB/s write, 4.33 GB read, 370.70 MB/s read, 29.1 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 1, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 1, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 14, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 1, total-stops: 14, interval: 15 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1112817 Average: 2.1804 StdDev: 10.69 Min: 1 Median: 1.4735 Max: 3360 Percentiles: P50: 1.47 P75: 1.85 P99: 5.69 P99.9: 10.32 P99.99: 14.68 ------------------------------------------------------ [ 0, 1 ] 210671 18.931% 18.931% #### ( 1, 2 ] 730239 65.621% 84.552% ############# ( 2, 3 ] 96319 8.655% 93.208% ## ( 3, 4 ] 41958 3.770% 96.978% # ( 4, 6 ] 26616 2.392% 99.370% ( 6, 10 ] 5827 0.524% 99.893% ( 10, 15 ] 1149 0.103% 99.997% ( 15, 22 ] 97 0.009% 100.005% ( 22, 34 ] 21 0.002% 100.007% ( 34, 51 ] 6 0.001% 100.008% ( 51, 76 ] 7 0.001% 100.008% ( 76, 110 ] 33 0.003% 100.011% ( 110, 170 ] 52 0.005% 100.016% ( 170, 250 ] 43 0.004% 100.020% ( 250, 380 ] 30 0.003% 100.023% ( 380, 580 ] 14 0.001% 100.024% ( 580, 870 ] 21 0.002% 100.026% ( 870, 1300 ] 13 0.001% 100.027% ( 1300, 1900 ] 5 0.000% 100.027% ( 1900, 2900 ] 5 0.000% 100.028% ( 2900, 4400 ] 5 0.000% 100.028% ** Level 1 read latency histogram (micros): Count: 28274 Average: 3.0942 StdDev: 24.12 Min: 1 Median: 1.4923 Max: 2194 Percentiles: P50: 1.49 P75: 1.87 P99: 8.73 P99.9: 304.65 P99.99: 944.22 ------------------------------------------------------ [ 0, 1 ] 4812 17.019% 17.019% ### ( 1, 2 ] 18942 66.994% 84.014% ############# ( 2, 3 ] 2441 8.633% 92.647% ## ( 3, 4 ] 955 3.378% 96.025% # ( 4, 6 ] 512 1.811% 97.835% ( 6, 10 ] 482 1.705% 99.540% ( 10, 15 ] 42 0.149% 99.689% ( 15, 22 ] 2 0.007% 99.696% ( 51, 76 ] 2 0.007% 99.703% ( 76, 110 ] 1 0.004% 99.706% ( 110, 170 ] 32 0.113% 99.820% ( 170, 250 ] 16 0.057% 99.876% ( 250, 380 ] 16 0.057% 99.933% ( 380, 580 ] 11 0.039% 99.972% ( 580, 870 ] 5 0.018% 99.989% ( 870, 1300 ] 1 0.004% 99.993% ( 1300, 1900 ] 1 0.004% 99.996% ( 1900, 2900 ] 1 0.004% 100.000% ** Level 2 read latency histogram (micros): Count: 95907 Average: 1.9809 StdDev: 5.18 Min: 1 Median: 1.3690 Max: 1095 Percentiles: P50: 1.37 P75: 1.78 P99: 5.46 P99.9: 10.57 P99.99: 24.46 ------------------------------------------------------ [ 0, 1 ] 26440 27.568% 27.568% ###### ( 1, 2 ] 58309 60.797% 88.366% ############ ( 2, 3 ] 5782 6.029% 94.395% # ( 3, 4 ] 3213 3.350% 97.745% # ( 4, 6 ] 1653 1.724% 99.468% ( 6, 10 ] 405 0.422% 99.891% ( 10, 15 ] 80 0.083% 99.974% ( 15, 22 ] 15 0.016% 99.990% ( 22, 34 ] 2 0.002% 99.992% ( 51, 76 ] 1 0.001% 99.993% ( 76, 110 ] 1 0.001% 99.994% ( 250, 380 ] 1 0.001% 99.995% ( 380, 580 ] 2 0.002% 99.997% ( 580, 870 ] 2 0.002% 99.999% ( 870, 1300 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 200893 Average: 3.5011 StdDev: 39.53 Min: 0 Median: 1.6345 Max: 5095 Percentiles: P50: 1.63 P75: 2.14 P99: 9.15 P99.9: 188.11 P99.99: 629.31 ------------------------------------------------------ [ 0, 1 ] 20741 10.324% 10.324% ## ( 1, 2 ] 125617 62.529% 72.854% ############# ( 2, 3 ] 30106 14.986% 87.840% ### ( 3, 4 ] 10280 5.117% 92.957% # ( 4, 6 ] 9402 4.680% 97.637% # ( 6, 10 ] 3479 1.732% 99.369% ( 10, 15 ] 635 0.316% 99.685% ( 15, 22 ] 108 0.054% 99.739% ( 22, 34 ] 31 0.015% 99.754% ( 34, 51 ] 8 0.004% 99.758% ( 51, 76 ] 1 0.000% 99.759% ( 76, 110 ] 91 0.045% 99.804% ( 110, 170 ] 175 0.087% 99.891% ( 170, 250 ] 80 0.040% 99.931% ( 250, 380 ] 69 0.034% 99.965% ( 380, 580 ] 46 0.023% 99.988% ( 580, 870 ] 23 0.011% 100.000% ( 870, 1300 ] 24 0.012% 100.011% ( 1300, 1900 ] 9 0.004% 100.016% ( 1900, 2900 ] 7 0.003% 100.019% ( 2900, 4400 ] 9 0.004% 100.024% ( 4400, 6600 ] 4 0.002% 100.026% ** Level 4 read latency histogram (micros): Count: 310 Average: 119.6677 StdDev: 523.79 Min: 0 Median: 2.0000 Max: 4377 Percentiles: P50: 2.00 P75: 5.91 P99: 3237.50 P99.9: 4283.75 P99.99: 4377.00 ------------------------------------------------------ [ 0, 1 ] 56 18.065% 18.065% #### ( 1, 2 ] 99 31.935% 50.000% ###### ( 2, 3 ] 53 17.097% 67.097% ### ( 3, 4 ] 14 4.516% 71.613% # ( 4, 6 ] 11 3.548% 75.161% # ( 6, 10 ] 12 3.871% 79.032% # ( 10, 15 ] 26 8.387% 87.419% ## ( 15, 22 ] 15 4.839% 92.258% # ( 110, 170 ] 2 0.645% 92.903% ( 170, 250 ] 1 0.323% 93.226% ( 380, 580 ] 3 0.968% 94.194% ( 580, 870 ] 1 0.323% 94.516% ( 870, 1300 ] 8 2.581% 97.097% # ( 1300, 1900 ] 2 0.645% 97.742% ( 1900, 2900 ] 3 0.968% 98.710% ( 2900, 4400 ] 4 1.290% 100.000% ** Level 5 read latency histogram (micros): Count: 60 Average: 812.2667 StdDev: 948.21 Min: 78 Median: 354.0000 Max: 4524 Percentiles: P50: 354.00 P75: 1300.00 P99: 4524.00 P99.9: 4524.00 P99.99: 4524.00 ------------------------------------------------------ ( 76, 110 ] 9 15.000% 15.000% ### ( 110, 170 ] 12 20.000% 35.000% #### ( 170, 250 ] 5 8.333% 43.333% ## ( 250, 380 ] 5 8.333% 51.667% ## ( 380, 580 ] 3 5.000% 56.667% # ( 580, 870 ] 7 11.667% 68.333% ## ( 870, 1300 ] 4 6.667% 75.000% # ( 1300, 1900 ] 7 11.667% 86.667% ## ( 1900, 2900 ] 6 10.000% 96.667% ## ( 2900, 4400 ] 1 1.667% 98.333% ( 4400, 6600 ] 1 1.667% 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, 323.17 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.559 H:M:S, 12.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 320.26 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.461 H:M:S, 15.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/11/18-08:36:16 ... thread 0: (1000000,5000000) ops and (299230.9,327003.8) ops/second in (3.341901,15.290340) 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.64 GB 37.8 3.0 0.0 3.0 7.6 4.7 0.0 1.6 120.7 311.6 25.06 23.43 78 0.321 3070K 3193 0.0 0.0 L1 13/13 1.41 GB 0.0 1.8 1.8 0.0 1.8 1.8 0.2 1.0 231.8 230.5 7.89 7.63 2 3.947 1857K 9637 0.0 0.0 L2 1/0 51.40 MB 0.5 0.4 0.2 0.2 0.4 0.2 0.5 2.0 245.7 245.5 1.54 1.49 2 0.769 383K 213 0.0 0.0 L3 12/0 510.88 MB 0.5 0.9 0.2 0.7 0.9 0.2 0.4 3.7 224.6 224.2 4.14 3.87 2 2.070 944K 1798 0.0 0.0 L4 170/0 9.64 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.8 1.0 151.5 151.5 1.48 1.11 1 1.480 227K 0 0.0 0.0 L5 1052/0 86.55 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1265/27 100.80 GB 0.0 6.2 2.4 3.8 10.9 7.1 3.0 2.3 159.2 278.2 40.11 37.53 85 0.472 6483K 14K 0.0 0.0 Int 0/0 0.00 KB 0.0 6.2 2.4 3.8 10.9 7.1 2.9 2.3 159.2 278.2 40.11 37.53 85 0.472 6483K 14K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 6.2 2.4 3.8 6.2 2.4 0.0 0.0 240.4 239.8 26.56 25.39 18 1.476 6483K 14K 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 353.4 13.55 12.14 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.5 total, 15.3 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.90 GB write, 718.79 MB/s write, 6.24 GB read, 411.35 MB/s read, 40.1 seconds Interval compaction: 10.90 GB write, 729.66 MB/s write, 6.24 GB read, 417.57 MB/s read, 40.1 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 3, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 3, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 17, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 3, total-stops: 17, interval: 20 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1402417 Average: 2.1979 StdDev: 11.67 Min: 1 Median: 1.4667 Max: 4081 Percentiles: P50: 1.47 P75: 1.85 P99: 5.68 P99.9: 10.93 P99.99: 21.77 ------------------------------------------------------ [ 0, 1 ] 270144 19.263% 19.263% #### ( 1, 2 ] 923656 65.862% 85.124% ############# ( 2, 3 ] 118532 8.452% 93.576% ## ( 3, 4 ] 50034 3.568% 97.144% # ( 4, 6 ] 30906 2.204% 99.348% ( 6, 10 ] 7483 0.534% 99.881% ( 10, 15 ] 1396 0.100% 99.981% ( 15, 22 ] 131 0.009% 99.990% ( 22, 34 ] 23 0.002% 99.992% ( 34, 51 ] 8 0.001% 99.993% ( 51, 76 ] 9 0.001% 99.993% ( 76, 110 ] 70 0.005% 99.998% ( 110, 170 ] 131 0.009% 100.008% ( 170, 250 ] 84 0.006% 100.014% ( 250, 380 ] 62 0.004% 100.018% ( 380, 580 ] 40 0.003% 100.021% ( 580, 870 ] 36 0.003% 100.023% ( 870, 1300 ] 15 0.001% 100.024% ( 1300, 1900 ] 7 0.000% 100.025% ( 1900, 2900 ] 6 0.000% 100.025% ( 2900, 4400 ] 7 0.000% 100.026% ** Level 1 read latency histogram (micros): Count: 84061 Average: 3.1628 StdDev: 25.92 Min: 1 Median: 1.4486 Max: 2194 Percentiles: P50: 1.45 P75: 1.83 P99: 8.86 P99.9: 311.17 P99.99: 1253.49 ------------------------------------------------------ [ 0, 1 ] 17323 20.608% 20.608% #### ( 1, 2 ] 55082 65.526% 86.134% ############# ( 2, 3 ] 6248 7.433% 93.567% # ( 3, 4 ] 2246 2.672% 96.238% # ( 4, 6 ] 1344 1.599% 97.837% ( 6, 10 ] 1365 1.624% 99.461% ( 10, 15 ] 130 0.155% 99.616% ( 15, 22 ] 13 0.015% 99.631% ( 22, 34 ] 1 0.001% 99.632% ( 51, 76 ] 5 0.006% 99.638% ( 76, 110 ] 43 0.051% 99.690% ( 110, 170 ] 107 0.127% 99.817% ( 170, 250 ] 53 0.063% 99.880% ( 250, 380 ] 36 0.043% 99.923% ( 380, 580 ] 32 0.038% 99.961% ( 580, 870 ] 13 0.015% 99.976% ( 870, 1300 ] 13 0.015% 99.992% ( 1300, 1900 ] 6 0.007% 99.999% ( 1900, 2900 ] 1 0.001% 100.000% ** Level 2 read latency histogram (micros): Count: 95907 Average: 1.9809 StdDev: 5.18 Min: 1 Median: 1.3690 Max: 1095 Percentiles: P50: 1.37 P75: 1.78 P99: 5.46 P99.9: 10.57 P99.99: 24.46 ------------------------------------------------------ [ 0, 1 ] 26440 27.568% 27.568% ###### ( 1, 2 ] 58309 60.797% 88.366% ############ ( 2, 3 ] 5782 6.029% 94.395% # ( 3, 4 ] 3213 3.350% 97.745% # ( 4, 6 ] 1653 1.724% 99.468% ( 6, 10 ] 405 0.422% 99.891% ( 10, 15 ] 80 0.083% 99.974% ( 15, 22 ] 15 0.016% 99.990% ( 22, 34 ] 2 0.002% 99.992% ( 51, 76 ] 1 0.001% 99.993% ( 76, 110 ] 1 0.001% 99.994% ( 250, 380 ] 1 0.001% 99.995% ( 380, 580 ] 2 0.002% 99.997% ( 580, 870 ] 2 0.002% 99.999% ( 870, 1300 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 200893 Average: 3.5011 StdDev: 39.53 Min: 0 Median: 1.6345 Max: 5095 Percentiles: P50: 1.63 P75: 2.14 P99: 9.15 P99.9: 188.11 P99.99: 629.31 ------------------------------------------------------ [ 0, 1 ] 20741 10.324% 10.324% ## ( 1, 2 ] 125617 62.529% 72.854% ############# ( 2, 3 ] 30106 14.986% 87.840% ### ( 3, 4 ] 10280 5.117% 92.957% # ( 4, 6 ] 9402 4.680% 97.637% # ( 6, 10 ] 3479 1.732% 99.369% ( 10, 15 ] 635 0.316% 99.685% ( 15, 22 ] 108 0.054% 99.739% ( 22, 34 ] 31 0.015% 99.754% ( 34, 51 ] 8 0.004% 99.758% ( 51, 76 ] 1 0.000% 99.759% ( 76, 110 ] 91 0.045% 99.804% ( 110, 170 ] 175 0.087% 99.891% ( 170, 250 ] 80 0.040% 99.931% ( 250, 380 ] 69 0.034% 99.965% ( 380, 580 ] 46 0.023% 99.988% ( 580, 870 ] 23 0.011% 100.000% ( 870, 1300 ] 24 0.012% 100.011% ( 1300, 1900 ] 9 0.004% 100.016% ( 1900, 2900 ] 7 0.003% 100.019% ( 2900, 4400 ] 9 0.004% 100.024% ( 4400, 6600 ] 4 0.002% 100.026% ** Level 4 read latency histogram (micros): Count: 310 Average: 119.6677 StdDev: 523.79 Min: 0 Median: 2.0000 Max: 4377 Percentiles: P50: 2.00 P75: 5.91 P99: 3237.50 P99.9: 4283.75 P99.99: 4377.00 ------------------------------------------------------ [ 0, 1 ] 56 18.065% 18.065% #### ( 1, 2 ] 99 31.935% 50.000% ###### ( 2, 3 ] 53 17.097% 67.097% ### ( 3, 4 ] 14 4.516% 71.613% # ( 4, 6 ] 11 3.548% 75.161% # ( 6, 10 ] 12 3.871% 79.032% # ( 10, 15 ] 26 8.387% 87.419% ## ( 15, 22 ] 15 4.839% 92.258% # ( 110, 170 ] 2 0.645% 92.903% ( 170, 250 ] 1 0.323% 93.226% ( 380, 580 ] 3 0.968% 94.194% ( 580, 870 ] 1 0.323% 94.516% ( 870, 1300 ] 8 2.581% 97.097% # ( 1300, 1900 ] 2 0.645% 97.742% ( 1900, 2900 ] 3 0.968% 98.710% ( 2900, 4400 ] 4 1.290% 100.000% ** Level 5 read latency histogram (micros): Count: 60 Average: 812.2667 StdDev: 948.21 Min: 78 Median: 354.0000 Max: 4524 Percentiles: P50: 354.00 P75: 1300.00 P99: 4524.00 P99.9: 4524.00 P99.99: 4524.00 ------------------------------------------------------ ( 76, 110 ] 9 15.000% 15.000% ### ( 110, 170 ] 12 20.000% 35.000% #### ( 170, 250 ] 5 8.333% 43.333% ## ( 250, 380 ] 5 8.333% 51.667% ## ( 380, 580 ] 3 5.000% 56.667% # ( 580, 870 ] 7 11.667% 68.333% ## ( 870, 1300 ] 4 6.667% 75.000% # ( 1300, 1900 ] 7 11.667% 86.667% ## ( 1900, 2900 ] 6 10.000% 96.667% ## ( 2900, 4400 ] 1 1.667% 98.333% ( 4400, 6600 ] 1 1.667% 100.000% ** DB Stats ** Uptime(secs): 15.5 total, 3.3 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 317.00 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.330 H:M:S, 15.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 294.50 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.771 H:M:S, 23.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/18-08:36:20 ... thread 0: (1000000,6000000) ops and (231717.8,306029.8) ops/second in (4.315594,19.605934) 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/10 3.63 GB 169.9 4.1 0.0 4.1 9.7 5.7 0.0 1.7 128.6 307.8 32.32 30.27 96 0.337 4221K 4402 0.0 0.0 L1 13/13 1.41 GB 0.0 1.8 1.8 0.0 1.8 1.8 0.2 1.0 231.8 230.5 7.89 7.63 2 3.947 1857K 9637 0.0 0.0 L2 1/0 51.40 MB 0.5 0.4 0.2 0.2 0.4 0.2 0.5 2.0 245.7 245.5 1.54 1.49 2 0.769 383K 213 0.0 0.0 L3 12/0 510.88 MB 0.5 0.9 0.2 0.7 0.9 0.2 0.4 3.7 224.6 224.2 4.14 3.87 2 2.070 944K 1798 0.0 0.0 L4 170/0 9.64 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.8 1.0 151.5 151.5 1.48 1.11 1 1.480 227K 0 0.0 0.0 L5 1052/0 86.55 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1267/23 101.78 GB 0.0 7.3 2.4 4.9 13.0 8.1 3.0 2.3 158.7 280.7 47.37 44.36 103 0.460 7635K 16K 0.0 0.0 Int 0/0 0.00 KB 0.0 7.3 2.4 4.9 13.0 8.1 2.9 2.3 158.7 280.7 47.37 44.36 103 0.460 7635K 16K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 7.3 2.4 4.9 7.3 2.4 0.0 0.0 243.2 242.7 30.92 29.65 22 1.405 7635K 16K 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.2 16.46 14.71 81 0.203 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 19.8 total, 19.6 interval Flush(GB): cumulative 5.660, interval 5.660 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 12.99 GB write, 670.33 MB/s write, 7.34 GB read, 379.02 MB/s read, 47.4 seconds Interval compaction: 12.99 GB write, 678.23 MB/s write, 7.34 GB read, 383.50 MB/s read, 47.4 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 8, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 8, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 19, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 8, total-stops: 19, interval: 27 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1800004 Average: 2.1995 StdDev: 11.30 Min: 1 Median: 1.4649 Max: 4081 Percentiles: P50: 1.46 P75: 1.84 P99: 5.68 P99.9: 10.97 P99.99: 80.98 ------------------------------------------------------ [ 0, 1 ] 347292 19.294% 19.294% #### ( 1, 2 ] 1188776 66.043% 85.337% ############# ( 2, 3 ] 150596 8.366% 93.703% ## ( 3, 4 ] 62993 3.500% 97.203% # ( 4, 6 ] 38480 2.138% 99.341% ( 6, 10 ] 9737 0.541% 99.882% ( 10, 15 ] 1706 0.095% 99.976% ( 15, 22 ] 175 0.010% 99.986% ( 22, 34 ] 32 0.002% 99.988% ( 34, 51 ] 10 0.001% 99.989% ( 51, 76 ] 11 0.001% 99.989% ( 76, 110 ] 116 0.006% 99.996% ( 110, 170 ] 212 0.012% 100.007% ( 170, 250 ] 114 0.006% 100.014% ( 250, 380 ] 88 0.005% 100.019% ( 380, 580 ] 53 0.003% 100.021% ( 580, 870 ] 51 0.003% 100.024% ( 870, 1300 ] 20 0.001% 100.025% ( 1300, 1900 ] 9 0.000% 100.026% ( 1900, 2900 ] 8 0.000% 100.026% ( 2900, 4400 ] 7 0.000% 100.027% ** Level 1 read latency histogram (micros): Count: 185594 Average: 2.7683 StdDev: 18.73 Min: 1 Median: 1.4607 Max: 2194 Percentiles: P50: 1.46 P75: 1.84 P99: 8.51 P99.9: 192.98 P99.99: 917.65 ------------------------------------------------------ [ 0, 1 ] 36141 19.473% 19.473% #### ( 1, 2 ] 122989 66.268% 85.741% ############# ( 2, 3 ] 14235 7.670% 93.411% ## ( 3, 4 ] 5184 2.793% 96.204% # ( 4, 6 ] 3336 1.797% 98.002% ( 6, 10 ] 2948 1.588% 99.590% ( 10, 15 ] 231 0.124% 99.714% ( 15, 22 ] 24 0.013% 99.727% ( 22, 34 ] 3 0.002% 99.729% ( 34, 51 ] 2 0.001% 99.730% ( 51, 76 ] 6 0.003% 99.733% ( 76, 110 ] 109 0.059% 99.792% ( 110, 170 ] 178 0.096% 99.888% ( 170, 250 ] 78 0.042% 99.930% ( 250, 380 ] 49 0.026% 99.956% ( 380, 580 ] 43 0.023% 99.980% ( 580, 870 ] 18 0.010% 99.989% ( 870, 1300 ] 13 0.007% 99.996% ( 1300, 1900 ] 6 0.003% 99.999% ( 1900, 2900 ] 1 0.001% 100.000% ** Level 2 read latency histogram (micros): Count: 95907 Average: 1.9809 StdDev: 5.18 Min: 1 Median: 1.3690 Max: 1095 Percentiles: P50: 1.37 P75: 1.78 P99: 5.46 P99.9: 10.57 P99.99: 24.46 ------------------------------------------------------ [ 0, 1 ] 26440 27.568% 27.568% ###### ( 1, 2 ] 58309 60.797% 88.366% ############ ( 2, 3 ] 5782 6.029% 94.395% # ( 3, 4 ] 3213 3.350% 97.745% # ( 4, 6 ] 1653 1.724% 99.468% ( 6, 10 ] 405 0.422% 99.891% ( 10, 15 ] 80 0.083% 99.974% ( 15, 22 ] 15 0.016% 99.990% ( 22, 34 ] 2 0.002% 99.992% ( 51, 76 ] 1 0.001% 99.993% ( 76, 110 ] 1 0.001% 99.994% ( 250, 380 ] 1 0.001% 99.995% ( 380, 580 ] 2 0.002% 99.997% ( 580, 870 ] 2 0.002% 99.999% ( 870, 1300 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 200893 Average: 3.5011 StdDev: 39.53 Min: 0 Median: 1.6345 Max: 5095 Percentiles: P50: 1.63 P75: 2.14 P99: 9.15 P99.9: 188.11 P99.99: 629.31 ------------------------------------------------------ [ 0, 1 ] 20741 10.324% 10.324% ## ( 1, 2 ] 125617 62.529% 72.854% ############# ( 2, 3 ] 30106 14.986% 87.840% ### ( 3, 4 ] 10280 5.117% 92.957% # ( 4, 6 ] 9402 4.680% 97.637% # ( 6, 10 ] 3479 1.732% 99.369% ( 10, 15 ] 635 0.316% 99.685% ( 15, 22 ] 108 0.054% 99.739% ( 22, 34 ] 31 0.015% 99.754% ( 34, 51 ] 8 0.004% 99.758% ( 51, 76 ] 1 0.000% 99.759% ( 76, 110 ] 91 0.045% 99.804% ( 110, 170 ] 175 0.087% 99.891% ( 170, 250 ] 80 0.040% 99.931% ( 250, 380 ] 69 0.034% 99.965% ( 380, 580 ] 46 0.023% 99.988% ( 580, 870 ] 23 0.011% 100.000% ( 870, 1300 ] 24 0.012% 100.011% ( 1300, 1900 ] 9 0.004% 100.016% ( 1900, 2900 ] 7 0.003% 100.019% ( 2900, 4400 ] 9 0.004% 100.024% ( 4400, 6600 ] 4 0.002% 100.026% ** Level 4 read latency histogram (micros): Count: 310 Average: 119.6677 StdDev: 523.79 Min: 0 Median: 2.0000 Max: 4377 Percentiles: P50: 2.00 P75: 5.91 P99: 3237.50 P99.9: 4283.75 P99.99: 4377.00 ------------------------------------------------------ [ 0, 1 ] 56 18.065% 18.065% #### ( 1, 2 ] 99 31.935% 50.000% ###### ( 2, 3 ] 53 17.097% 67.097% ### ( 3, 4 ] 14 4.516% 71.613% # ( 4, 6 ] 11 3.548% 75.161% # ( 6, 10 ] 12 3.871% 79.032% # ( 10, 15 ] 26 8.387% 87.419% ## ( 15, 22 ] 15 4.839% 92.258% # ( 110, 170 ] 2 0.645% 92.903% ( 170, 250 ] 1 0.323% 93.226% ( 380, 580 ] 3 0.968% 94.194% ( 580, 870 ] 1 0.323% 94.516% ( 870, 1300 ] 8 2.581% 97.097% # ( 1300, 1900 ] 2 0.645% 97.742% ( 1900, 2900 ] 3 0.968% 98.710% ( 2900, 4400 ] 4 1.290% 100.000% ** Level 5 read latency histogram (micros): Count: 60 Average: 812.2667 StdDev: 948.21 Min: 78 Median: 354.0000 Max: 4524 Percentiles: P50: 354.00 P75: 1300.00 P99: 4524.00 P99.9: 4524.00 P99.99: 4524.00 ------------------------------------------------------ ( 76, 110 ] 9 15.000% 15.000% ### ( 110, 170 ] 12 20.000% 35.000% #### ( 170, 250 ] 5 8.333% 43.333% ## ( 250, 380 ] 5 8.333% 51.667% ## ( 380, 580 ] 3 5.000% 56.667% # ( 580, 870 ] 7 11.667% 68.333% ## ( 870, 1300 ] 4 6.667% 75.000% # ( 1300, 1900 ] 7 11.667% 86.667% ## ( 1900, 2900 ] 6 10.000% 96.667% ## ( 2900, 4400 ] 1 1.667% 98.333% ( 4400, 6600 ] 1 1.667% 100.000% ** DB Stats ** Uptime(secs): 19.8 total, 4.3 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 297.65 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.057 H:M:S, 20.5 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 228.06 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.728 H:M:S, 40.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/11/18-08:36:36 ... thread 0: (1000000,7000000) ops and (66165.1,201615.0) ops/second in (15.113709,34.719643) 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 2.58 GB 0.0 6.0 0.0 6.0 12.6 6.6 0.0 1.9 143.6 300.1 42.99 40.18 115 0.374 6267K 11K 0.0 0.0 L1 20/20 2.32 GB 0.0 5.2 3.7 1.4 5.1 3.7 0.2 1.4 221.5 219.1 23.86 22.62 3 7.954 5367K 57K 0.0 0.0 L2 1/1 128.78 MB 0.0 0.4 0.2 0.2 0.4 0.2 1.5 2.0 245.7 245.5 1.54 1.49 2 0.769 383K 213 0.0 0.0 L3 22/2 1.05 GB 1.0 2.0 1.2 0.9 2.0 1.2 0.4 1.7 223.2 222.6 9.39 8.67 5 1.878 2128K 5315 0.0 0.0 L4 173/0 9.65 GB 1.0 0.6 0.6 0.0 0.6 0.6 0.8 1.0 167.2 167.0 3.56 2.86 7 0.509 604K 891 0.0 0.0 L5 1056/0 86.92 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1282/33 102.65 GB 0.0 14.2 5.7 8.5 20.7 12.2 4.4 3.1 178.6 260.5 81.34 75.82 132 0.616 14M 75K 0.0 0.0 Int 0/0 0.00 KB 0.0 14.2 5.7 8.5 20.7 12.2 4.3 3.1 178.6 260.5 81.34 75.82 132 0.616 14M 75K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 14.2 5.7 8.5 14.1 5.6 0.0 0.0 233.9 232.6 62.11 58.65 36 1.725 14M 75K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 6.6 6.6 0.0 0.0 0.0 350.7 19.22 17.17 96 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): 35.0 total, 34.7 interval Flush(GB): cumulative 6.583, interval 6.583 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 20.69 GB write, 606.30 MB/s write, 14.19 GB read, 415.62 MB/s read, 81.3 seconds Interval compaction: 20.69 GB write, 610.34 MB/s write, 14.19 GB read, 418.39 MB/s read, 81.3 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: 19, pending-compaction-bytes-delays: 10, pending-compaction-bytes-stops: 0, total-delays: 26, total-stops: 19, interval: 45 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2853288 Average: 2.4890 StdDev: 14.95 Min: 1 Median: 1.4656 Max: 4081 Percentiles: P50: 1.47 P75: 1.84 P99: 6.27 P99.9: 119.78 P99.99: 252.02 ------------------------------------------------------ [ 0, 1 ] 546114 19.140% 19.140% #### ( 1, 2 ] 1891179 66.281% 85.421% ############# ( 2, 3 ] 232732 8.157% 93.577% ## ( 3, 4 ] 95131 3.334% 96.911% # ( 4, 6 ] 58159 2.038% 98.950% ( 6, 10 ] 21208 0.743% 99.693% ( 10, 15 ] 2914 0.102% 99.795% ( 15, 22 ] 438 0.015% 99.810% ( 22, 34 ] 46 0.002% 99.812% ( 34, 51 ] 13 0.000% 99.812% ( 51, 76 ] 26 0.001% 99.813% ( 76, 110 ] 2095 0.073% 99.887% ( 110, 170 ] 2335 0.082% 99.969% ( 170, 250 ] 607 0.021% 99.990% ( 250, 380 ] 429 0.015% 100.005% ( 380, 580 ] 302 0.011% 100.015% ( 580, 870 ] 148 0.005% 100.021% ( 870, 1300 ] 40 0.001% 100.022% ( 1300, 1900 ] 17 0.001% 100.023% ( 1900, 2900 ] 19 0.001% 100.023% ( 2900, 4400 ] 14 0.000% 100.024% ** Level 1 read latency histogram (micros): Count: 783109 Average: 2.8080 StdDev: 20.38 Min: 1 Median: 1.4843 Max: 4297 Percentiles: P50: 1.48 P75: 1.85 P99: 8.62 P99.9: 162.22 P99.99: 684.28 ------------------------------------------------------ [ 0, 1 ] 135045 17.245% 17.245% ### ( 1, 2 ] 529642 67.633% 84.878% ############## ( 2, 3 ] 61797 7.891% 92.769% ## ( 3, 4 ] 25045 3.198% 95.967% # ( 4, 6 ] 15536 1.984% 97.951% ( 6, 10 ] 12535 1.601% 99.552% ( 10, 15 ] 978 0.125% 99.677% ( 15, 22 ] 171 0.022% 99.699% ( 22, 34 ] 13 0.002% 99.700% ( 34, 51 ] 4 0.001% 99.701% ( 51, 76 ] 90 0.011% 99.712% ( 76, 110 ] 758 0.097% 99.809% ( 110, 170 ] 818 0.104% 99.914% ( 170, 250 ] 252 0.032% 99.946% ( 250, 380 ] 185 0.024% 99.969% ( 380, 580 ] 134 0.017% 99.986% ( 580, 870 ] 77 0.010% 99.996% ( 870, 1300 ] 46 0.006% 100.002% ( 1300, 1900 ] 15 0.002% 100.004% ( 1900, 2900 ] 5 0.001% 100.005% ( 2900, 4400 ] 8 0.001% 100.006% ** Level 2 read latency histogram (micros): Count: 95907 Average: 1.9809 StdDev: 5.18 Min: 1 Median: 1.3690 Max: 1095 Percentiles: P50: 1.37 P75: 1.78 P99: 5.46 P99.9: 10.57 P99.99: 24.46 ------------------------------------------------------ [ 0, 1 ] 26440 27.568% 27.568% ###### ( 1, 2 ] 58309 60.797% 88.366% ############ ( 2, 3 ] 5782 6.029% 94.395% # ( 3, 4 ] 3213 3.350% 97.745% # ( 4, 6 ] 1653 1.724% 99.468% ( 6, 10 ] 405 0.422% 99.891% ( 10, 15 ] 80 0.083% 99.974% ( 15, 22 ] 15 0.016% 99.990% ( 22, 34 ] 2 0.002% 99.992% ( 51, 76 ] 1 0.001% 99.993% ( 76, 110 ] 1 0.001% 99.994% ( 250, 380 ] 1 0.001% 99.995% ( 380, 580 ] 2 0.002% 99.997% ( 580, 870 ] 2 0.002% 99.999% ( 870, 1300 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 326671 Average: 3.7077 StdDev: 35.45 Min: 0 Median: 1.7257 Max: 5095 Percentiles: P50: 1.73 P75: 2.55 P99: 8.95 P99.9: 116.80 P99.99: 168.99 ------------------------------------------------------ [ 0, 1 ] 26536 8.123% 8.123% ## ( 1, 2 ] 188501 57.704% 65.827% ############ ( 2, 3 ] 54831 16.785% 82.612% ### ( 3, 4 ] 24916 7.627% 90.239% ## ( 4, 6 ] 24386 7.465% 97.704% # ( 6, 10 ] 5751 1.760% 99.464% ( 10, 15 ] 1018 0.312% 99.776% ( 15, 22 ] 138 0.042% 99.818% ( 22, 34 ] 36 0.011% 99.829% ( 34, 51 ] 10 0.003% 99.832% ( 51, 76 ] 16 0.005% 99.837% ( 76, 110 ] 168 0.051% 99.889% ( 110, 170 ] 338 0.103% 99.992% ( 170, 250 ] 182 0.056% 100.048% ( 250, 380 ] 136 0.042% 100.089% ( 380, 580 ] 110 0.034% 100.123% ( 580, 870 ] 50 0.015% 100.138% ( 870, 1300 ] 29 0.009% 100.147% ( 1300, 1900 ] 12 0.004% 100.151% ( 1900, 2900 ] 8 0.002% 100.153% ( 2900, 4400 ] 12 0.004% 100.157% ( 4400, 6600 ] 4 0.001% 100.158% ** Level 4 read latency histogram (micros): Count: 6179 Average: 29.2405 StdDev: 160.85 Min: 0 Median: 2.0453 Max: 4377 Percentiles: P50: 2.05 P75: 3.54 P99: 648.03 P99.9: 2507.00 P99.99: 4214.63 ------------------------------------------------------ [ 0, 1 ] 283 4.580% 4.580% # ( 1, 2 ] 2754 44.570% 49.150% ######### ( 2, 3 ] 1160 18.773% 67.924% #### ( 3, 4 ] 814 13.174% 81.097% ### ( 4, 6 ] 529 8.561% 89.659% ## ( 6, 10 ] 136 2.201% 91.860% ( 10, 15 ] 60 0.971% 92.831% ( 15, 22 ] 16 0.259% 93.089% ( 22, 34 ] 1 0.016% 93.106% ( 51, 76 ] 2 0.032% 93.138% ( 76, 110 ] 45 0.728% 93.866% ( 110, 170 ] 123 1.991% 95.857% ( 170, 250 ] 57 0.922% 96.779% ( 250, 380 ] 65 1.052% 97.831% ( 380, 580 ] 64 1.036% 98.867% ( 580, 870 ] 35 0.566% 99.434% ( 870, 1300 ] 23 0.372% 99.806% ( 1300, 1900 ] 4 0.065% 99.871% ( 1900, 2900 ] 3 0.049% 99.919% ( 2900, 4400 ] 5 0.081% 100.000% ** Level 5 read latency histogram (micros): Count: 80 Average: 853.6875 StdDev: 995.80 Min: 78 Median: 342.8571 Max: 4524 Percentiles: P50: 342.86 P75: 1375.00 P99: 4524.00 P99.9: 4524.00 P99.99: 4524.00 ------------------------------------------------------ ( 76, 110 ] 9 11.250% 11.250% ## ( 110, 170 ] 14 17.500% 28.750% #### ( 170, 250 ] 12 15.000% 43.750% ### ( 250, 380 ] 7 8.750% 52.500% ## ( 380, 580 ] 4 5.000% 57.500% # ( 580, 870 ] 9 11.250% 68.750% ## ( 870, 1300 ] 4 5.000% 73.750% # ( 1300, 1900 ] 8 10.000% 83.750% ## ( 1900, 2900 ] 10 12.500% 96.250% ### ( 2900, 4400 ] 2 2.500% 98.750% # ( 4400, 6600 ] 1 1.250% 100.000% ** DB Stats ** Uptime(secs): 35.0 total, 15.1 interval Cumulative writes: 0 writes, 7000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 6.73 GB, 197.10 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:16.319 H:M:S, 46.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 65.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:12.261 H:M:S, 81.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/11/18-08:36:39 ... thread 0: (1000000,8000000) ops and (311933.1,210940.1) ops/second in (3.205816,37.925459) 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.56 GB 100.7 6.8 0.0 6.8 14.4 7.6 0.0 1.9 141.9 298.8 49.28 45.97 132 0.373 7099K 12K 0.0 0.0 L1 20/20 2.32 GB 0.0 5.2 3.7 1.4 5.1 3.7 0.2 1.4 221.5 219.1 23.86 22.62 3 7.954 5367K 57K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 1.5 2.0 245.7 245.5 1.54 1.49 2 0.769 383K 213 0.0 0.0 L3 20/0 974.26 MB 1.0 2.3 1.3 1.0 2.3 1.3 0.4 1.7 222.3 221.8 10.46 9.67 6 1.744 2363K 5815 0.0 0.0 L4 173/0 9.56 GB 1.0 0.8 0.8 0.0 0.8 0.8 0.8 1.0 170.2 169.9 4.95 4.03 11 0.450 854K 1501 0.0 0.0 L5 1060/0 87.23 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1288/30 103.63 GB 0.0 15.5 6.0 9.4 22.9 13.5 4.7 3.0 175.6 260.8 90.09 83.77 154 0.585 16M 77K 0.0 0.0 Int 0/0 0.00 KB 0.0 15.5 6.0 9.4 22.9 13.5 4.6 3.0 175.6 260.8 90.09 83.77 154 0.585 16M 77K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 15.5 6.0 9.4 15.4 5.9 0.0 0.0 233.3 232.2 67.82 63.96 44 1.541 16M 77K 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 347.9 22.27 19.81 110 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): 38.2 total, 37.9 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: 22.94 GB write, 615.70 MB/s write, 15.45 GB read, 414.68 MB/s read, 90.1 seconds Interval compaction: 22.94 GB write, 619.45 MB/s write, 15.45 GB read, 417.21 MB/s read, 90.1 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: 27, pending-compaction-bytes-delays: 10, pending-compaction-bytes-stops: 0, total-delays: 26, total-stops: 27, interval: 53 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3140150 Average: 2.4792 StdDev: 14.88 Min: 1 Median: 1.4718 Max: 4081 Percentiles: P50: 1.47 P75: 1.85 P99: 6.21 P99.9: 112.96 P99.99: 243.59 ------------------------------------------------------ [ 0, 1 ] 589039 18.758% 18.758% #### ( 1, 2 ] 2079134 66.211% 84.970% ############# ( 2, 3 ] 264000 8.407% 93.377% ## ( 3, 4 ] 107754 3.431% 96.808% # ( 4, 6 ] 67593 2.153% 98.961% ( 6, 10 ] 23513 0.749% 99.710% ( 10, 15 ] 3141 0.100% 99.810% ( 15, 22 ] 474 0.015% 99.825% ( 22, 34 ] 51 0.002% 99.826% ( 34, 51 ] 15 0.000% 99.827% ( 51, 76 ] 27 0.001% 99.828% ( 76, 110 ] 2153 0.069% 99.896% ( 110, 170 ] 2369 0.075% 99.972% ( 170, 250 ] 624 0.020% 99.992% ( 250, 380 ] 448 0.014% 100.006% ( 380, 580 ] 311 0.010% 100.016% ( 580, 870 ] 160 0.005% 100.021% ( 870, 1300 ] 41 0.001% 100.022% ( 1300, 1900 ] 19 0.001% 100.023% ( 1900, 2900 ] 20 0.001% 100.023% ( 2900, 4400 ] 17 0.001% 100.024% ** Level 1 read latency histogram (micros): Count: 888004 Average: 2.7848 StdDev: 19.80 Min: 1 Median: 1.4938 Max: 4297 Percentiles: P50: 1.49 P75: 1.86 P99: 8.62 P99.9: 157.65 P99.99: 664.10 ------------------------------------------------------ [ 0, 1 ] 147924 16.658% 16.658% ### ( 1, 2 ] 599626 67.525% 84.183% ############## ( 2, 3 ] 73752 8.305% 92.489% ## ( 3, 4 ] 29431 3.314% 95.803% # ( 4, 6 ] 18979 2.137% 97.940% ( 6, 10 ] 14386 1.620% 99.560% ( 10, 15 ] 1163 0.131% 99.691% ( 15, 22 ] 187 0.021% 99.712% ( 22, 34 ] 16 0.002% 99.714% ( 34, 51 ] 4 0.000% 99.714% ( 51, 76 ] 94 0.011% 99.725% ( 76, 110 ] 871 0.098% 99.823% ( 110, 170 ] 860 0.097% 99.920% ( 170, 250 ] 262 0.030% 99.949% ( 250, 380 ] 198 0.022% 99.972% ( 380, 580 ] 139 0.016% 99.987% ( 580, 870 ] 80 0.009% 99.996% ( 870, 1300 ] 47 0.005% 100.002% ( 1300, 1900 ] 16 0.002% 100.003% ( 1900, 2900 ] 5 0.001% 100.004% ( 2900, 4400 ] 9 0.001% 100.005% ** Level 2 read latency histogram (micros): Count: 95907 Average: 1.9809 StdDev: 5.18 Min: 1 Median: 1.3690 Max: 1095 Percentiles: P50: 1.37 P75: 1.78 P99: 5.46 P99.9: 10.57 P99.99: 24.46 ------------------------------------------------------ [ 0, 1 ] 26440 27.568% 27.568% ###### ( 1, 2 ] 58309 60.797% 88.366% ############ ( 2, 3 ] 5782 6.029% 94.395% # ( 3, 4 ] 3213 3.350% 97.745% # ( 4, 6 ] 1653 1.724% 99.468% ( 6, 10 ] 405 0.422% 99.891% ( 10, 15 ] 80 0.083% 99.974% ( 15, 22 ] 15 0.016% 99.990% ( 22, 34 ] 2 0.002% 99.992% ( 51, 76 ] 1 0.001% 99.993% ( 76, 110 ] 1 0.001% 99.994% ( 250, 380 ] 1 0.001% 99.995% ( 380, 580 ] 2 0.002% 99.997% ( 580, 870 ] 2 0.002% 99.999% ( 870, 1300 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 393953 Average: 3.5928 StdDev: 33.01 Min: 0 Median: 1.7565 Max: 5095 Percentiles: P50: 1.76 P75: 2.64 P99: 8.80 P99.9: 83.30 P99.99: 149.28 ------------------------------------------------------ [ 0, 1 ] 28074 7.126% 7.126% # ( 1, 2 ] 223266 56.673% 63.799% ########### ( 2, 3 ] 69391 17.614% 81.414% #### ( 3, 4 ] 32471 8.242% 89.656% ## ( 4, 6 ] 31968 8.115% 97.771% ## ( 6, 10 ] 6930 1.759% 99.530% ( 10, 15 ] 1201 0.305% 99.834% ( 15, 22 ] 157 0.040% 99.874% ( 22, 34 ] 39 0.010% 99.884% ( 34, 51 ] 10 0.003% 99.887% ( 51, 76 ] 16 0.004% 99.891% ( 76, 110 ] 168 0.043% 99.933% ( 110, 170 ] 340 0.086% 100.020% ( 170, 250 ] 187 0.047% 100.067% ( 250, 380 ] 138 0.035% 100.102% ( 380, 580 ] 112 0.028% 100.131% ( 580, 870 ] 50 0.013% 100.143% ( 870, 1300 ] 29 0.007% 100.151% ( 1300, 1900 ] 13 0.003% 100.154% ( 1900, 2900 ] 8 0.002% 100.156% ( 2900, 4400 ] 13 0.003% 100.159% ( 4400, 6600 ] 4 0.001% 100.160% ** Level 4 read latency histogram (micros): Count: 10118 Average: 29.4065 StdDev: 151.91 Min: 0 Median: 1.9761 Max: 4377 Percentiles: P50: 1.98 P75: 3.44 P99: 672.28 P99.9: 1891.15 P99.99: 4147.05 ------------------------------------------------------ [ 0, 1 ] 476 4.704% 4.704% # ( 1, 2 ] 4695 46.402% 51.107% ######### ( 2, 3 ] 1864 18.423% 69.530% #### ( 3, 4 ] 1260 12.453% 81.983% ## ( 4, 6 ] 815 8.055% 90.038% ## ( 6, 10 ] 210 2.076% 92.113% ( 10, 15 ] 88 0.870% 92.983% ( 15, 22 ] 18 0.178% 93.161% ( 22, 34 ] 1 0.010% 93.171% ( 51, 76 ] 2 0.020% 93.190% ( 76, 110 ] 56 0.553% 93.744% ( 110, 170 ] 180 1.779% 95.523% ( 170, 250 ] 107 1.058% 96.580% ( 250, 380 ] 103 1.018% 97.598% ( 380, 580 ] 117 1.156% 98.755% ( 580, 870 ] 78 0.771% 99.526% ( 870, 1300 ] 30 0.297% 99.822% ( 1300, 1900 ] 8 0.079% 99.901% ( 1900, 2900 ] 4 0.040% 99.941% ( 2900, 4400 ] 6 0.059% 100.000% ** Level 5 read latency histogram (micros): Count: 100 Average: 823.9400 StdDev: 965.45 Min: 78 Median: 341.0000 Max: 4524 Percentiles: P50: 341.00 P75: 1300.00 P99: 4400.00 P99.9: 4524.00 P99.99: 4524.00 ------------------------------------------------------ ( 76, 110 ] 14 14.000% 14.000% ### ( 110, 170 ] 15 15.000% 29.000% ### ( 170, 250 ] 14 14.000% 43.000% ### ( 250, 380 ] 10 10.000% 53.000% ## ( 380, 580 ] 6 6.000% 59.000% # ( 580, 870 ] 11 11.000% 70.000% ## ( 870, 1300 ] 5 5.000% 75.000% # ( 1300, 1900 ] 9 9.000% 84.000% ## ( 1900, 2900 ] 12 12.000% 96.000% ## ( 2900, 4400 ] 3 3.000% 99.000% # ( 4400, 6600 ] 1 1.000% 100.000% ** DB Stats ** Uptime(secs): 38.2 total, 3.2 interval Cumulative writes: 0 writes, 8000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 7.69 GB, 206.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:16.793 H:M:S, 44.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 306.95 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.475 H:M:S, 14.8 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/18-08:37:00 ... thread 0: (1000000,9000000) ops and (47869.4,153020.6) ops/second in (20.890153,58.815612) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 7/6 2.20 GB 37.7 9.2 0.0 9.2 17.8 8.5 0.0 2.1 143.1 275.4 66.01 58.40 148 0.446 9591K 23K 0.0 0.0 L1 0/0 0.00 KB 0.0 9.8 6.1 3.7 9.7 5.9 0.2 1.6 221.0 218.1 45.46 42.50 4 11.366 9359K 57K 0.0 0.0 L2 16/14 1.93 GB 1.8 0.4 0.2 0.2 0.4 0.2 6.1 2.0 245.7 245.5 1.54 1.49 2 0.769 383K 213 0.0 0.0 L3 19/4 1.34 GB 1.0 6.1 3.8 2.3 6.1 3.7 0.6 1.6 165.9 165.0 37.57 27.88 21 1.789 6330K 32K 0.0 0.0 L4 172/7 9.81 GB 1.0 3.4 2.9 0.5 3.4 2.9 1.0 1.2 138.9 138.2 25.42 16.52 35 0.726 3532K 13K 0.0 0.0 L5 1084/0 89.20 GB 0.9 0.0 0.0 0.0 0.0 0.0 3.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1298/31 104.49 GB 0.0 28.9 12.9 16.0 37.3 21.3 11.6 4.4 168.4 217.0 175.99 146.78 210 0.838 29M 127K 0.0 0.0 Int 0/0 0.00 KB 0.0 28.9 12.9 16.0 37.3 21.3 11.4 4.4 168.4 217.0 175.99 146.78 210 0.838 29M 127K 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 28.9 12.9 16.0 28.7 12.7 0.0 0.0 198.8 197.4 149.11 124.27 88 1.694 29M 127K 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 325.7 26.89 22.51 122 0.220 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 59.0 total, 58.8 interval Flush(GB): cumulative 8.551, interval 8.551 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 37.29 GB write, 646.68 MB/s write, 28.94 GB read, 501.89 MB/s read, 176.0 seconds Interval compaction: 37.29 GB write, 649.22 MB/s write, 28.94 GB read, 503.86 MB/s read, 176.0 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: 45, pending-compaction-bytes-delays: 37, pending-compaction-bytes-stops: 0, total-delays: 53, total-stops: 45, interval: 98 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 4180469 Average: 2.9579 StdDev: 25.70 Min: 1 Median: 1.5007 Max: 7584 Percentiles: P50: 1.50 P75: 1.89 P99: 8.09 P99.9: 157.26 P99.99: 448.52 ------------------------------------------------------ [ 0, 1 ] 745713 17.838% 17.838% #### ( 1, 2 ] 2685228 64.233% 82.071% ############# ( 2, 3 ] 385925 9.232% 91.302% ## ( 3, 4 ] 169920 4.065% 95.367% # ( 4, 6 ] 129930 3.108% 98.475% # ( 6, 10 ] 42037 1.006% 99.481% ( 10, 15 ] 6051 0.145% 99.625% ( 15, 22 ] 811 0.019% 99.645% ( 22, 34 ] 75 0.002% 99.646% ( 34, 51 ] 60 0.001% 99.648% ( 51, 76 ] 144 0.003% 99.651% ( 76, 110 ] 5861 0.140% 99.792% ( 110, 170 ] 5756 0.138% 99.929% ( 170, 250 ] 1344 0.032% 99.961% ( 250, 380 ] 926 0.022% 99.984% ( 380, 580 ] 788 0.019% 100.002% ( 580, 870 ] 420 0.010% 100.012% ( 870, 1300 ] 170 0.004% 100.017% ( 1300, 1900 ] 61 0.001% 100.018% ( 1900, 2900 ] 69 0.002% 100.020% ( 2900, 4400 ] 57 0.001% 100.021% ( 4400, 6600 ] 15 0.000% 100.021% ( 6600, 9900 ] 4 0.000% 100.021% ** Level 1 read latency histogram (micros): Count: 2293262 Average: 4.5054 StdDev: 63.49 Min: 0 Median: 1.6412 Max: 8217 Percentiles: P50: 1.64 P75: 2.32 P99: 9.41 P99.9: 167.69 P99.99: 576.02 ------------------------------------------------------ [ 0, 1 ] 293611 12.803% 12.803% ### ( 1, 2 ] 1330322 58.010% 70.813% ############ ( 2, 3 ] 301615 13.152% 83.965% ### ( 3, 4 ] 153298 6.685% 90.650% # ( 4, 6 ] 151011 6.585% 97.235% # ( 6, 10 ] 47520 2.072% 99.307% ( 10, 15 ] 8417 0.367% 99.674% ( 15, 22 ] 978 0.043% 99.717% ( 22, 34 ] 80 0.003% 99.720% ( 34, 51 ] 23 0.001% 99.721% ( 51, 76 ] 241 0.011% 99.732% ( 76, 110 ] 2074 0.090% 99.822% ( 110, 170 ] 1850 0.081% 99.903% ( 170, 250 ] 592 0.026% 99.929% ( 250, 380 ] 646 0.028% 99.957% ( 380, 580 ] 770 0.034% 99.991% ( 580, 870 ] 740 0.032% 100.023% ( 870, 1300 ] 571 0.025% 100.048% ( 1300, 1900 ] 261 0.011% 100.059% ( 1900, 2900 ] 220 0.010% 100.069% ( 2900, 4400 ] 248 0.011% 100.080% ( 4400, 6600 ] 75 0.003% 100.083% ( 6600, 9900 ] 15 0.001% 100.084% ** Level 2 read latency histogram (micros): Count: 95907 Average: 1.9809 StdDev: 5.18 Min: 1 Median: 1.3690 Max: 1095 Percentiles: P50: 1.37 P75: 1.78 P99: 5.46 P99.9: 10.57 P99.99: 24.46 ------------------------------------------------------ [ 0, 1 ] 26440 27.568% 27.568% ###### ( 1, 2 ] 58309 60.797% 88.366% ############ ( 2, 3 ] 5782 6.029% 94.395% # ( 3, 4 ] 3213 3.350% 97.745% # ( 4, 6 ] 1653 1.724% 99.468% ( 6, 10 ] 405 0.422% 99.891% ( 10, 15 ] 80 0.083% 99.974% ( 15, 22 ] 15 0.016% 99.990% ( 22, 34 ] 2 0.002% 99.992% ( 51, 76 ] 1 0.001% 99.993% ( 76, 110 ] 1 0.001% 99.994% ( 250, 380 ] 1 0.001% 99.995% ( 380, 580 ] 2 0.002% 99.997% ( 580, 870 ] 2 0.002% 99.999% ( 870, 1300 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 1301555 Average: 5.4948 StdDev: 73.11 Min: 0 Median: 1.9173 Max: 9424 Percentiles: P50: 1.92 P75: 3.03 P99: 9.49 P99.9: 123.72 P99.99: 364.22 ------------------------------------------------------ [ 0, 1 ] 44624 3.429% 3.429% # ( 1, 2 ] 660797 50.770% 54.198% ########## ( 2, 3 ] 266859 20.503% 74.701% #### ( 3, 4 ] 141918 10.904% 85.605% ## ( 4, 6 ] 148973 11.446% 97.051% ## ( 6, 10 ] 29088 2.235% 99.286% ( 10, 15 ] 6803 0.523% 99.808% ( 15, 22 ] 755 0.058% 99.866% ( 22, 34 ] 75 0.006% 99.872% ( 34, 51 ] 27 0.002% 99.874% ( 51, 76 ] 49 0.004% 99.878% ( 76, 110 ] 187 0.014% 99.892% ( 110, 170 ] 435 0.033% 99.926% ( 170, 250 ] 386 0.030% 99.956% ( 250, 380 ] 512 0.039% 99.995% ( 380, 580 ] 657 0.050% 100.045% ( 580, 870 ] 638 0.049% 100.094% ( 870, 1300 ] 445 0.034% 100.129% ( 1300, 1900 ] 199 0.015% 100.144% ( 1900, 2900 ] 184 0.014% 100.158% ( 2900, 4400 ] 197 0.015% 100.173% ( 4400, 6600 ] 50 0.004% 100.177% ( 6600, 9900 ] 10 0.001% 100.178% ** Level 4 read latency histogram (micros): Count: 145003 Average: 25.4963 StdDev: 215.85 Min: 0 Median: 1.9230 Max: 10926 Percentiles: P50: 1.92 P75: 3.09 P99: 739.72 P99.9: 3211.77 P99.99: 4311.51 ------------------------------------------------------ [ 0, 1 ] 4884 3.368% 3.368% # ( 1, 2 ] 73262 50.524% 53.893% ########## ( 2, 3 ] 29196 20.135% 74.027% #### ( 3, 4 ] 15458 10.660% 84.688% ## ( 4, 6 ] 14283 9.850% 94.538% ## ( 6, 10 ] 3446 2.377% 96.915% ( 10, 15 ] 974 0.672% 97.586% ( 15, 22 ] 119 0.082% 97.668% ( 22, 34 ] 6 0.004% 97.672% ( 34, 51 ] 4 0.003% 97.675% ( 51, 76 ] 5 0.003% 97.679% ( 76, 110 ] 67 0.046% 97.725% ( 110, 170 ] 246 0.170% 97.895% ( 170, 250 ] 275 0.190% 98.084% ( 250, 380 ] 352 0.243% 98.327% ( 380, 580 ] 591 0.408% 98.735% ( 580, 870 ] 699 0.482% 99.217% ( 870, 1300 ] 480 0.331% 99.548% ( 1300, 1900 ] 270 0.186% 99.734% ( 1900, 2900 ] 204 0.141% 99.874% ( 2900, 4400 ] 178 0.123% 99.997% ( 4400, 6600 ] 30 0.021% 100.018% ( 6600, 9900 ] 7 0.005% 100.023% ( 9900, 14000 ] 4 0.003% 100.026% ** Level 5 read latency histogram (micros): Count: 220 Average: 1283.9364 StdDev: 1346.66 Min: 78 Median: 725.0000 Max: 5127 Percentiles: P50: 725.00 P75: 2042.86 P99: 5127.00 P99.9: 5127.00 P99.99: 5127.00 ------------------------------------------------------ ( 76, 110 ] 17 7.727% 7.727% ## ( 110, 170 ] 21 9.545% 17.273% ## ( 170, 250 ] 23 10.455% 27.727% ## ( 250, 380 ] 21 9.545% 37.273% ## ( 380, 580 ] 14 6.364% 43.636% # ( 580, 870 ] 28 12.727% 56.364% ### ( 870, 1300 ] 16 7.273% 63.636% # ( 1300, 1900 ] 21 9.545% 73.182% ## ( 1900, 2900 ] 28 12.727% 85.909% ### ( 2900, 4400 ] 21 9.545% 95.455% ## ( 4400, 6600 ] 10 4.545% 100.000% # ** DB Stats ** Uptime(secs): 59.0 total, 20.9 interval Cumulative writes: 0 writes, 9000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 8.65 GB, 150.01 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:34.284 H:M:S, 58.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 47.11 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:17.491 H:M:S, 83.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 7 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.401 micros/op 156230 ops/sec 60.001 seconds 9373999 operations; 151.4 MB/s Microseconds per write: Count: 9373999 Average: 6.4008 StdDev: 414.18 Min: 0 Median: 1.7317 Max: 635229 Percentiles: P50: 1.73 P75: 2.74 P99: 8.83 P99.9: 1190.14 P99.99: 2733.97 ------------------------------------------------------ [ 0, 1 ] 1322705 14.110% 14.110% ### ( 1, 2 ] 4597745 49.048% 63.158% ########## ( 2, 3 ] 1509743 16.106% 79.264% ### ( 3, 4 ] 1280780 13.663% 92.927% ### ( 4, 6 ] 501011 5.345% 98.272% # ( 6, 10 ] 96533 1.030% 99.301% ( 10, 15 ] 24661 0.263% 99.565% ( 15, 22 ] 6254 0.067% 99.631% ( 22, 34 ] 1637 0.017% 99.649% ( 34, 51 ] 191 0.002% 99.651% ( 51, 76 ] 61 0.001% 99.651% ( 76, 110 ] 6335 0.068% 99.719% ( 110, 170 ] 2784 0.030% 99.749% ( 170, 250 ] 292 0.003% 99.752% ( 250, 380 ] 97 0.001% 99.753% ( 380, 580 ] 14 0.000% 99.753% ( 580, 870 ] 22 0.000% 99.753% ( 870, 1300 ] 18482 0.197% 99.950% ( 1300, 1900 ] 91 0.001% 99.951% ( 1900, 2900 ] 4345 0.046% 99.998% ( 2900, 4400 ] 129 0.001% 99.999% ( 4400, 6600 ] 55 0.001% 100.000% ( 6600, 9900 ] 7 0.000% 100.000% ( 9900, 14000 ] 3 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 ] 15 0.000% 100.000% ( 380000, 570000 ] 1 0.000% 100.000% ( 570000, 860000 ] 2 0.000% 100.000% STATISTICS: rocksdb.block.cache.miss COUNT : 0 rocksdb.block.cache.hit COUNT : 0 rocksdb.block.cache.add COUNT : 0 rocksdb.block.cache.add.failures COUNT : 0 rocksdb.block.cache.index.miss COUNT : 0 rocksdb.block.cache.index.hit COUNT : 0 rocksdb.block.cache.index.add COUNT : 0 rocksdb.block.cache.index.bytes.insert COUNT : 0 rocksdb.block.cache.filter.miss COUNT : 0 rocksdb.block.cache.filter.hit COUNT : 0 rocksdb.block.cache.filter.add COUNT : 0 rocksdb.block.cache.filter.bytes.insert COUNT : 0 rocksdb.block.cache.data.miss COUNT : 0 rocksdb.block.cache.data.hit COUNT : 0 rocksdb.block.cache.data.add COUNT : 0 rocksdb.block.cache.data.bytes.insert COUNT : 0 rocksdb.block.cache.bytes.read COUNT : 0 rocksdb.block.cache.bytes.write COUNT : 0 rocksdb.bloom.filter.useful COUNT : 0 rocksdb.bloom.filter.full.positive COUNT : 0 rocksdb.bloom.filter.full.true.positive COUNT : 0 rocksdb.persistent.cache.hit COUNT : 0 rocksdb.persistent.cache.miss COUNT : 0 rocksdb.sim.block.cache.hit COUNT : 0 rocksdb.sim.block.cache.miss COUNT : 0 rocksdb.memtable.hit COUNT : 0 rocksdb.memtable.miss COUNT : 0 rocksdb.l0.hit COUNT : 0 rocksdb.l1.hit COUNT : 0 rocksdb.l2andup.hit COUNT : 0 rocksdb.compaction.key.drop.new COUNT : 214198 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 : 9373999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 9673966968 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 : 551 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 34472206 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 : 34136721797 rocksdb.compact.write.bytes COUNT : 33923458290 rocksdb.flush.write.bytes COUNT : 9578172842 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 : 56 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 : 220 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 : 9501101056 rocksdb.memtable.garbage.bytes.at.flush COUNT : 3838976 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 : 34228701805 rocksdb.non.last.level.read.count COUNT : 8272094 rocksdb.block.checksum.compute.count COUNT : 8271048 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.383005 P95 : 3.896825 P99 : 7.337295 P100 : 635227.000000 COUNT : 9373999 SUM : 55771497 rocksdb.compaction.times.micros P50 : 1041333.333333 P95 : 5326666.666667 P99 : 18320000.000000 P100 : 21601071.000000 COUNT : 92 SUM : 152379740 rocksdb.compaction.times.cpu_micros P50 : 913125.000000 P95 : 5070000.000000 P99 : 18320000.000000 P100 : 19884670.000000 COUNT : 92 SUM : 126921722 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 : 696.381579 P95 : 1795.000000 P99 : 68250.000000 P100 : 222331.000000 COUNT : 127 SUM : 398261 rocksdb.compaction.outfile.sync.micros P50 : 1068.875000 P95 : 107200.000000 P99 : 227600.000000 P100 : 1072522.000000 COUNT : 384 SUM : 8195161 rocksdb.wal.file.sync.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.manifest.file.sync.micros P50 : 109.757143 P95 : 1536.666667 P99 : 3841.250000 P100 : 4894.000000 COUNT : 249 SUM : 83894 rocksdb.table.open.io.micros P50 : 1476.712329 P95 : 8244.310345 P99 : 12459.083333 P100 : 16762.000000 COUNT : 551 SUM : 1227323 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.641081 P95 : 8.202529 P99 : 12.632064 P100 : 14460.000000 COUNT : 8269692 SUM : 51660260 rocksdb.read.block.get.micros P50 : 472.561983 P95 : 3694.531250 P99 : 5681.500000 P100 : 8513.000000 COUNT : 1102 SUM : 1002939 rocksdb.write.raw.block.micros P50 : 0.513075 P95 : 0.974842 P99 : 2.895463 P100 : 12178.000000 COUNT : 10537681 SUM : 20457633 rocksdb.numfiles.in.singlecompaction P50 : 3.096491 P95 : 6.350000 P99 : 26.000000 P100 : 26.000000 COUNT : 133 SUM : 498 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.557646 P95 : 1146.464651 P99 : 2427.308854 P100 : 635042.000000 COUNT : 223499 SUM : 34489338 rocksdb.sst.read.micros P50 : 1.606596 P95 : 5.014754 P99 : 9.215135 P100 : 10926.000000 COUNT : 8272681 SUM : 34883760 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 : 9373999 SUM : 9673966968 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 : 215894.736842 P95 : 377323.529412 P99 : 737233.333333 P100 : 761429.000000 COUNT : 127 SUM : 28031548 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 : 365 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