[2024-11-20 12:41:54.346648] Starting SPDK v24.01.1-pre git sha1 c13c99a5e / DPDK 23.11.0 initialization... [2024-11-20 12:41:54.346757] [ 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_pid327334 ] Set seed to 1732102914344235 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-11-20 12:41:54.453526] app.c: 798:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-11-20 12:41:54.660299] app.c: 488:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-11-20 12:41:54.660348] app.c: 489:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 327334' to capture a snapshot of events at runtime. [2024-11-20 12:41:54.660358] app.c: 494:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid327334 for offline analysis/debug. [2024-11-20 12:41:54.660386] reactor.c: 937:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Wed Nov 20 12:42:03 2024 CPU: 96 * Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz CPUCache: 36608 KB 2024/11/20-12:42:06 ... thread 0: (1000000,1000000) ops and (356929.5,356929.5) ops/second in (2.801674,2.801674) 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 6/4 378.04 MB 12.6 0.0 0.0 0.0 0.8 0.8 0.0 1.0 0.0 348.4 2.35 2.10 12 0.196 0 0 0.0 0.0 L1 4/0 251.74 MB 25.2 0.2 0.2 0.0 0.2 0.2 0.2 1.0 241.2 240.9 1.04 1.01 1 1.045 255K 245 0.0 0.0 L2 3/2 188.88 MB 0.0 0.2 0.1 0.1 0.2 0.1 0.1 1.5 244.8 244.7 0.77 0.74 1 0.772 191K 65 0.0 0.0 L3 11/0 867.26 MB 0.9 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.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.75 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 1184/6 96.94 GB 0.0 0.4 0.4 0.1 1.2 1.2 0.4 1.5 105.8 302.2 4.17 3.85 14 0.298 447K 310 0.0 0.0 Int 0/0 0.00 KB 0.0 0.4 0.4 0.1 1.2 1.2 0.2 1.5 105.8 302.2 4.17 3.85 14 0.298 447K 310 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.4 0.1 0.4 0.4 0.0 0.0 242.7 242.6 1.82 1.75 2 0.908 447K 310 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 0.8 0.8 0.0 0.0 0.0 348.4 2.35 2.10 12 0.196 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 3.0 total, 2.8 interval Flush(GB): cumulative 0.800, interval 0.800 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 1.23 GB write, 417.60 MB/s write, 0.43 GB read, 146.19 MB/s read, 4.2 seconds Interval compaction: 1.23 GB write, 449.33 MB/s write, 0.43 GB read, 157.30 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: 1, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 1, interval: 1 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 143469 Average: 2.0133 StdDev: 12.77 Min: 0 Median: 1.3502 Max: 3708 Percentiles: P50: 1.35 P75: 1.76 P99: 5.35 P99.9: 9.59 P99.99: 57.89 ------------------------------------------------------ [ 0, 1 ] 40921 28.523% 28.523% ###### ( 1, 2 ] 87982 61.325% 89.847% ############ ( 2, 3 ] 7854 5.474% 95.322% # ( 3, 4 ] 3685 2.568% 97.890% # ( 4, 6 ] 2353 1.640% 99.530% ( 6, 10 ] 592 0.413% 99.943% ( 10, 15 ] 54 0.038% 99.980% ( 15, 22 ] 8 0.006% 99.986% ( 22, 34 ] 4 0.003% 99.989% ( 34, 51 ] 1 0.001% 99.990% ( 51, 76 ] 6 0.004% 99.994% ( 110, 170 ] 4 0.003% 99.997% ( 170, 250 ] 5 0.003% 100.000% ( 250, 380 ] 1 0.001% 100.001% ( 380, 580 ] 6 0.004% 100.005% ( 580, 870 ] 3 0.002% 100.007% ( 870, 1300 ] 1 0.001% 100.008% ( 1300, 1900 ] 3 0.002% 100.010% ( 2900, 4400 ] 1 0.001% 100.010% ** Level 1 read latency histogram (micros): Count: 20 Average: 161.5000 StdDev: 306.60 Min: 1 Median: 1.6250 Max: 1131 Percentiles: P50: 1.62 P75: 170.00 P99: 1131.00 P99.9: 1131.00 P99.99: 1131.00 ------------------------------------------------------ [ 0, 1 ] 5 25.000% 25.000% ##### ( 1, 2 ] 8 40.000% 65.000% ######## ( 3, 4 ] 1 5.000% 70.000% # ( 110, 170 ] 1 5.000% 75.000% # ( 170, 250 ] 1 5.000% 80.000% # ( 380, 580 ] 2 10.000% 90.000% ## ( 580, 870 ] 1 5.000% 95.000% # ( 870, 1300 ] 1 5.000% 100.000% # ** Level 2 read latency histogram (micros): Count: 32370 Average: 3.3584 StdDev: 82.84 Min: 1 Median: 1.5108 Max: 9295 Percentiles: P50: 1.51 P75: 1.89 P99: 5.92 P99.9: 12.84 P99.99: 4222.25 ------------------------------------------------------ [ 0, 1 ] 5306 16.392% 16.392% ### ( 1, 2 ] 21298 65.795% 82.187% ############# ( 2, 3 ] 2724 8.415% 90.602% ## ( 3, 4 ] 1606 4.961% 95.564% # ( 4, 6 ] 1156 3.571% 99.135% # ( 6, 10 ] 230 0.711% 99.846% ( 10, 15 ] 31 0.096% 99.941% ( 15, 22 ] 4 0.012% 99.954% ( 22, 34 ] 1 0.003% 99.957% ( 110, 170 ] 1 0.003% 99.960% ( 170, 250 ] 1 0.003% 99.963% ( 380, 580 ] 3 0.009% 99.972% ( 580, 870 ] 1 0.003% 99.975% ( 870, 1300 ] 1 0.003% 99.978% ( 1300, 1900 ] 1 0.003% 99.981% ( 1900, 2900 ] 1 0.003% 99.985% ( 2900, 4400 ] 2 0.006% 99.991% ( 4400, 6600 ] 1 0.003% 99.994% ( 6600, 9900 ] 2 0.006% 100.000% ** Level 3 read latency histogram (micros): Count: 45 Average: 3922.1333 StdDev: 3577.47 Min: 332 Median: 2775.0000 Max: 12377 Percentiles: P50: 2775.00 P75: 6909.38 P99: 12377.00 P99.9: 12377.00 P99.99: 12377.00 ------------------------------------------------------ ( 250, 380 ] 2 4.444% 4.444% # ( 380, 580 ] 7 15.556% 20.000% ### ( 580, 870 ] 7 15.556% 35.556% ### ( 870, 1300 ] 3 6.667% 42.222% # ( 1900, 2900 ] 4 8.889% 51.111% ## ( 2900, 4400 ] 4 8.889% 60.000% ## ( 4400, 6600 ] 6 13.333% 73.333% ### ( 6600, 9900 ] 8 17.778% 91.111% #### ( 9900, 14000 ] 4 8.889% 100.000% ## ** Level 4 read latency histogram (micros): Count: 25 Average: 4043.2800 StdDev: 3194.33 Min: 261 Median: 3462.5000 Max: 10966 Percentiles: P50: 3462.50 P75: 6050.00 P99: 10966.00 P99.9: 10966.00 P99.99: 10966.00 ------------------------------------------------------ ( 250, 380 ] 3 12.000% 12.000% ## ( 380, 580 ] 2 8.000% 20.000% ## ( 580, 870 ] 1 4.000% 24.000% # ( 870, 1300 ] 1 4.000% 28.000% # ( 1300, 1900 ] 1 4.000% 32.000% # ( 1900, 2900 ] 3 12.000% 44.000% ## ( 2900, 4400 ] 4 16.000% 60.000% ### ( 4400, 6600 ] 5 20.000% 80.000% #### ( 6600, 9900 ] 3 12.000% 92.000% ## ( 9900, 14000 ] 2 8.000% 100.000% ## ** DB Stats ** Uptime(secs): 3.0 total, 2.8 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 326.26 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:0.202 H:M:S, 6.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 350.98 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.202 H:M:S, 7.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/20-12:42:09 ... thread 0: (1000000,2000000) ops and (322159.9,338654.6) ops/second in (3.104049,5.905723) 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/10 1.35 GB 12.6 0.8 0.0 0.8 2.6 1.8 0.0 1.4 97.8 315.8 8.38 7.73 29 0.289 831K 902 0.0 0.0 L1 0/0 0.00 KB 0.0 0.2 0.2 0.0 0.2 0.2 0.2 1.0 241.2 240.9 1.04 1.01 1 1.045 255K 245 0.0 0.0 L2 2/1 81.74 MB 0.8 0.2 0.1 0.1 0.2 0.1 0.3 1.5 241.2 241.1 0.80 0.76 2 0.400 195K 70 0.0 0.0 L3 20/11 1.03 GB 0.2 0.2 0.2 0.0 0.2 0.2 0.3 1.0 232.0 232.0 0.81 0.74 1 0.807 190K 0 0.0 0.0 L4 174/0 9.70 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.0 1.0 126.8 126.9 1.33 0.91 1 1.330 171K 0 0.0 0.0 L5 1044/0 85.75 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1251/22 97.92 GB 0.0 1.6 0.7 0.9 3.4 2.5 0.8 1.9 131.1 278.8 12.36 11.15 34 0.363 1644K 1217 0.0 0.0 Int 0/0 0.00 KB 0.0 1.6 0.7 0.9 3.4 2.5 0.7 1.9 131.1 278.8 12.36 11.15 34 0.363 1644K 1217 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.6 0.7 0.9 1.6 0.7 0.0 0.0 226.0 225.9 7.17 6.55 8 0.896 1644K 1217 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 352.0 5.19 4.61 26 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): 6.1 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.36 GB write, 562.95 MB/s write, 1.58 GB read, 264.65 MB/s read, 12.4 seconds Interval compaction: 3.36 GB write, 583.25 MB/s write, 1.58 GB read, 274.20 MB/s read, 12.4 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 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: 379089 Average: 2.2095 StdDev: 13.87 Min: 0 Median: 1.4763 Max: 4868 Percentiles: P50: 1.48 P75: 1.86 P99: 5.73 P99.9: 10.45 P99.99: 21.04 ------------------------------------------------------ [ 0, 1 ] 72806 19.206% 19.206% #### ( 1, 2 ] 245116 64.659% 83.865% ############# ( 2, 3 ] 35027 9.240% 93.105% ## ( 3, 4 ] 13858 3.656% 96.760% # ( 4, 6 ] 9811 2.588% 99.348% # ( 6, 10 ] 2063 0.544% 99.892% ( 10, 15 ] 334 0.088% 99.980% ( 15, 22 ] 43 0.011% 99.992% ( 22, 34 ] 8 0.002% 99.994% ( 34, 51 ] 2 0.001% 99.994% ( 51, 76 ] 6 0.002% 99.996% ( 110, 170 ] 7 0.002% 99.998% ( 170, 250 ] 13 0.003% 100.001% ( 250, 380 ] 4 0.001% 100.002% ( 380, 580 ] 11 0.003% 100.005% ( 580, 870 ] 6 0.002% 100.007% ( 870, 1300 ] 9 0.002% 100.009% ( 1300, 1900 ] 4 0.001% 100.010% ( 1900, 2900 ] 2 0.001% 100.011% ( 2900, 4400 ] 1 0.000% 100.011% ( 4400, 6600 ] 1 0.000% 100.011% ** Level 1 read latency histogram (micros): Count: 587 Average: 7.9642 StdDev: 63.53 Min: 1 Median: 1.7356 Max: 1131 Percentiles: P50: 1.74 P75: 2.44 P99: 117.80 P99.9: 1047.59 P99.99: 1131.00 ------------------------------------------------------ [ 0, 1 ] 50 8.518% 8.518% ## ( 1, 2 ] 331 56.388% 64.906% ########### ( 2, 3 ] 135 22.998% 87.905% ##### ( 3, 4 ] 32 5.451% 93.356% # ( 4, 6 ] 24 4.089% 97.445% # ( 6, 10 ] 7 1.193% 98.637% ( 10, 15 ] 1 0.170% 98.807% ( 15, 22 ] 1 0.170% 98.978% ( 110, 170 ] 1 0.170% 99.148% ( 170, 250 ] 1 0.170% 99.319% ( 380, 580 ] 2 0.341% 99.659% ( 580, 870 ] 1 0.170% 99.830% ( 870, 1300 ] 1 0.170% 100.000% ** Level 2 read latency histogram (micros): Count: 48651 Average: 2.9331 StdDev: 67.58 Min: 1 Median: 1.5014 Max: 9295 Percentiles: P50: 1.50 P75: 1.87 P99: 5.86 P99.9: 11.78 P99.99: 2034.90 ------------------------------------------------------ [ 0, 1 ] 7982 16.407% 16.407% ### ( 1, 2 ] 32598 67.004% 83.410% ############# ( 2, 3 ] 4087 8.401% 91.811% ## ( 3, 4 ] 2133 4.384% 96.195% # ( 4, 6 ] 1471 3.024% 99.219% # ( 6, 10 ] 316 0.650% 99.868% ( 10, 15 ] 43 0.088% 99.957% ( 15, 22 ] 5 0.010% 99.967% ( 22, 34 ] 3 0.006% 99.973% ( 110, 170 ] 1 0.002% 99.975% ( 170, 250 ] 1 0.002% 99.977% ( 380, 580 ] 3 0.006% 99.984% ( 580, 870 ] 1 0.002% 99.986% ( 870, 1300 ] 1 0.002% 99.988% ( 1300, 1900 ] 1 0.002% 99.990% ( 1900, 2900 ] 1 0.002% 99.992% ( 2900, 4400 ] 2 0.004% 99.996% ( 4400, 6600 ] 1 0.002% 99.998% ( 6600, 9900 ] 2 0.004% 100.002% ** Level 3 read latency histogram (micros): Count: 193396 Average: 3.8802 StdDev: 82.23 Min: 1 Median: 1.6052 Max: 12377 Percentiles: P50: 1.61 P75: 2.00 P99: 9.07 P99.9: 158.74 P99.99: 476.27 ------------------------------------------------------ [ 0, 1 ] 21992 11.371% 11.371% ## ( 1, 2 ] 123448 63.832% 75.203% ############# ( 2, 3 ] 26473 13.688% 88.892% ### ( 3, 4 ] 8901 4.602% 93.494% # ( 4, 6 ] 8026 4.150% 97.644% # ( 6, 10 ] 3411 1.764% 99.408% ( 10, 15 ] 550 0.284% 99.692% ( 15, 22 ] 58 0.030% 99.722% ( 22, 34 ] 5 0.003% 99.725% ( 76, 110 ] 142 0.073% 99.798% ( 110, 170 ] 242 0.125% 99.923% ( 170, 250 ] 59 0.031% 99.954% ( 250, 380 ] 48 0.025% 99.979% ( 380, 580 ] 45 0.023% 100.002% ( 580, 870 ] 27 0.014% 100.016% ( 870, 1300 ] 5 0.003% 100.019% ( 1300, 1900 ] 3 0.002% 100.020% ( 1900, 2900 ] 4 0.002% 100.022% ( 2900, 4400 ] 4 0.002% 100.024% ( 4400, 6600 ] 6 0.003% 100.027% ( 6600, 9900 ] 8 0.004% 100.032% ( 9900, 14000 ] 4 0.002% 100.034% ** Level 4 read latency histogram (micros): Count: 315 Average: 329.8952 StdDev: 1414.70 Min: 1 Median: 2.2132 Max: 10966 Percentiles: P50: 2.21 P75: 6.95 P99: 8635.00 P99.9: 10966.00 P99.99: 10966.00 ------------------------------------------------------ [ 0, 1 ] 44 13.968% 13.968% ### ( 1, 2 ] 99 31.429% 45.397% ###### ( 2, 3 ] 68 21.587% 66.984% #### ( 3, 4 ] 11 3.492% 70.476% # ( 4, 6 ] 9 2.857% 73.333% # ( 6, 10 ] 22 6.984% 80.317% # ( 10, 15 ] 28 8.889% 89.206% ## ( 15, 22 ] 4 1.270% 90.476% ( 110, 170 ] 2 0.635% 91.111% ( 170, 250 ] 1 0.317% 91.429% ( 250, 380 ] 3 0.952% 92.381% ( 380, 580 ] 3 0.952% 93.333% ( 580, 870 ] 2 0.635% 93.968% ( 870, 1300 ] 1 0.317% 94.286% ( 1300, 1900 ] 1 0.317% 94.603% ( 1900, 2900 ] 3 0.952% 95.556% ( 2900, 4400 ] 4 1.270% 96.825% ( 4400, 6600 ] 5 1.587% 98.413% ( 6600, 9900 ] 3 0.952% 99.365% ( 9900, 14000 ] 2 0.635% 100.000% ** DB Stats ** Uptime(secs): 6.1 total, 3.1 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 321.60 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:0.614 H:M:S, 10.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 317.07 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.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/11/20-12:42:12 ... thread 0: (1000000,3000000) ops and (325263.7,334070.1) ops/second in (3.074429,8.980152) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 16/10 2.34 GB 107.0 1.6 0.0 1.6 4.4 2.8 0.0 1.6 113.3 309.3 14.46 13.41 46 0.314 1663K 1801 0.0 0.0 L1 0/0 0.00 KB 0.0 0.2 0.2 0.0 0.2 0.2 0.2 1.0 241.2 240.9 1.04 1.01 1 1.045 255K 245 0.0 0.0 L2 1/0 77.85 MB 0.8 0.2 0.1 0.1 0.2 0.1 0.3 1.5 241.2 241.1 0.80 0.76 2 0.400 195K 70 0.0 0.0 L3 12/0 542.33 MB 0.5 1.0 0.2 0.8 1.0 0.2 0.3 5.5 226.8 226.0 4.67 4.36 2 2.333 1075K 3951 0.0 0.0 L4 170/0 9.53 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.5 1.0 126.8 126.9 1.33 0.91 1 1.330 171K 0 0.0 0.0 L5 1052/0 86.43 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 1251/10 98.90 GB 0.0 3.2 0.7 2.5 6.0 3.5 1.9 2.2 148.4 275.3 22.30 20.46 52 0.429 3361K 6067 0.0 0.0 Int 0/0 0.00 KB 0.0 3.2 0.7 2.5 6.0 3.5 1.8 2.2 148.4 275.3 22.30 20.46 52 0.429 3361K 6067 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.2 0.7 2.5 3.2 0.7 0.0 0.0 232.0 231.6 14.26 13.35 12 1.189 3361K 6067 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 352.9 8.03 7.10 40 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): 9.2 total, 9.0 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: 5.99 GB write, 667.62 MB/s write, 3.23 GB read, 359.98 MB/s read, 22.3 seconds Interval compaction: 5.99 GB write, 683.46 MB/s write, 3.23 GB read, 368.51 MB/s read, 22.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: 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: 791087 Average: 2.2709 StdDev: 11.92 Min: 0 Median: 1.5268 Max: 4868 Percentiles: P50: 1.53 P75: 1.90 P99: 5.75 P99.9: 9.96 P99.99: 14.82 ------------------------------------------------------ [ 0, 1 ] 119420 15.096% 15.096% ### ( 1, 2 ] 524164 66.259% 81.354% ############# ( 2, 3 ] 87714 11.088% 92.442% ## ( 3, 4 ] 31761 4.015% 96.457% # ( 4, 6 ] 22953 2.901% 99.358% # ( 6, 10 ] 4322 0.546% 99.905% ( 10, 15 ] 699 0.088% 99.993% ( 15, 22 ] 83 0.010% 100.004% ( 22, 34 ] 21 0.003% 100.006% ( 34, 51 ] 2 0.000% 100.007% ( 51, 76 ] 8 0.001% 100.008% ( 110, 170 ] 19 0.002% 100.010% ( 170, 250 ] 35 0.004% 100.014% ( 250, 380 ] 8 0.001% 100.015% ( 380, 580 ] 18 0.002% 100.018% ( 580, 870 ] 15 0.002% 100.020% ( 870, 1300 ] 15 0.002% 100.021% ( 1300, 1900 ] 7 0.001% 100.022% ( 1900, 2900 ] 3 0.000% 100.023% ( 2900, 4400 ] 2 0.000% 100.023% ( 4400, 6600 ] 1 0.000% 100.023% ** Level 1 read latency histogram (micros): Count: 587 Average: 7.9642 StdDev: 63.53 Min: 1 Median: 1.7356 Max: 1131 Percentiles: P50: 1.74 P75: 2.44 P99: 117.80 P99.9: 1047.59 P99.99: 1131.00 ------------------------------------------------------ [ 0, 1 ] 50 8.518% 8.518% ## ( 1, 2 ] 331 56.388% 64.906% ########### ( 2, 3 ] 135 22.998% 87.905% ##### ( 3, 4 ] 32 5.451% 93.356% # ( 4, 6 ] 24 4.089% 97.445% # ( 6, 10 ] 7 1.193% 98.637% ( 10, 15 ] 1 0.170% 98.807% ( 15, 22 ] 1 0.170% 98.978% ( 110, 170 ] 1 0.170% 99.148% ( 170, 250 ] 1 0.170% 99.319% ( 380, 580 ] 2 0.341% 99.659% ( 580, 870 ] 1 0.170% 99.830% ( 870, 1300 ] 1 0.170% 100.000% ** Level 2 read latency histogram (micros): Count: 77242 Average: 3.2559 StdDev: 56.61 Min: 1 Median: 1.5603 Max: 9295 Percentiles: P50: 1.56 P75: 1.94 P99: 7.73 P99.9: 168.59 P99.99: 1382.74 ------------------------------------------------------ [ 0, 1 ] 9890 12.804% 12.804% ### ( 1, 2 ] 51277 66.385% 79.189% ############# ( 2, 3 ] 8356 10.818% 90.007% ## ( 3, 4 ] 3721 4.817% 94.824% # ( 4, 6 ] 2852 3.692% 98.516% # ( 6, 10 ] 863 1.117% 99.634% ( 10, 15 ] 120 0.155% 99.789% ( 15, 22 ] 18 0.023% 99.812% ( 22, 34 ] 4 0.005% 99.817% ( 76, 110 ] 12 0.016% 99.833% ( 110, 170 ] 53 0.069% 99.902% ( 170, 250 ] 21 0.027% 99.929% ( 250, 380 ] 17 0.022% 99.951% ( 380, 580 ] 18 0.023% 99.974% ( 580, 870 ] 8 0.010% 99.984% ( 870, 1300 ] 4 0.005% 99.990% ( 1300, 1900 ] 2 0.003% 99.992% ( 1900, 2900 ] 1 0.001% 99.994% ( 2900, 4400 ] 3 0.004% 99.997% ( 4400, 6600 ] 1 0.001% 99.999% ( 6600, 9900 ] 2 0.003% 100.001% ** Level 3 read latency histogram (micros): Count: 234779 Average: 3.7493 StdDev: 75.31 Min: 1 Median: 1.6062 Max: 12377 Percentiles: P50: 1.61 P75: 1.99 P99: 9.04 P99.9: 161.61 P99.99: 517.58 ------------------------------------------------------ [ 0, 1 ] 25778 10.980% 10.980% ## ( 1, 2 ] 151134 64.373% 75.353% ############# ( 2, 3 ] 31479 13.408% 88.760% ### ( 3, 4 ] 11052 4.707% 93.468% # ( 4, 6 ] 9810 4.178% 97.646% # ( 6, 10 ] 4184 1.782% 99.428% ( 10, 15 ] 649 0.276% 99.705% ( 15, 22 ] 68 0.029% 99.734% ( 22, 34 ] 5 0.002% 99.736% ( 51, 76 ] 3 0.001% 99.737% ( 76, 110 ] 162 0.069% 99.806% ( 110, 170 ] 256 0.109% 99.915% ( 170, 250 ] 76 0.032% 99.948% ( 250, 380 ] 61 0.026% 99.974% ( 380, 580 ] 56 0.024% 99.997% ( 580, 870 ] 29 0.012% 100.010% ( 870, 1300 ] 8 0.003% 100.013% ( 1300, 1900 ] 7 0.003% 100.016% ( 1900, 2900 ] 5 0.002% 100.018% ( 2900, 4400 ] 4 0.002% 100.020% ( 4400, 6600 ] 6 0.003% 100.023% ( 6600, 9900 ] 8 0.003% 100.026% ( 9900, 14000 ] 4 0.002% 100.028% ** Level 4 read latency histogram (micros): Count: 315 Average: 329.8952 StdDev: 1414.70 Min: 1 Median: 2.2132 Max: 10966 Percentiles: P50: 2.21 P75: 6.95 P99: 8635.00 P99.9: 10966.00 P99.99: 10966.00 ------------------------------------------------------ [ 0, 1 ] 44 13.968% 13.968% ### ( 1, 2 ] 99 31.429% 45.397% ###### ( 2, 3 ] 68 21.587% 66.984% #### ( 3, 4 ] 11 3.492% 70.476% # ( 4, 6 ] 9 2.857% 73.333% # ( 6, 10 ] 22 6.984% 80.317% # ( 10, 15 ] 28 8.889% 89.206% ## ( 15, 22 ] 4 1.270% 90.476% ( 110, 170 ] 2 0.635% 91.111% ( 170, 250 ] 1 0.317% 91.429% ( 250, 380 ] 3 0.952% 92.381% ( 380, 580 ] 3 0.952% 93.333% ( 580, 870 ] 2 0.635% 93.968% ( 870, 1300 ] 1 0.317% 94.286% ( 1300, 1900 ] 1 0.317% 94.603% ( 1900, 2900 ] 3 0.952% 95.556% ( 2900, 4400 ] 4 1.270% 96.825% ( 4400, 6600 ] 5 1.587% 98.413% ( 6600, 9900 ] 3 0.952% 99.365% ( 9900, 14000 ] 2 0.635% 100.000% ** Level 5 read latency histogram (micros): Count: 40 Average: 1043.4750 StdDev: 1251.14 Min: 109 Median: 336.6667 Max: 4914 Percentiles: P50: 336.67 P75: 1900.00 P99: 4914.00 P99.9: 4914.00 P99.99: 4914.00 ------------------------------------------------------ ( 76, 110 ] 1 2.500% 2.500% # ( 110, 170 ] 9 22.500% 25.000% ##### ( 170, 250 ] 8 20.000% 45.000% #### ( 250, 380 ] 3 7.500% 52.500% ## ( 380, 580 ] 2 5.000% 57.500% # ( 580, 870 ] 1 2.500% 60.000% # ( 870, 1300 ] 5 12.500% 72.500% ### ( 1300, 1900 ] 1 2.500% 75.000% # ( 1900, 2900 ] 5 12.500% 87.500% ### ( 2900, 4400 ] 4 10.000% 97.500% ## ( 4400, 6600 ] 1 2.500% 100.000% # ** DB Stats ** Uptime(secs): 9.2 total, 3.1 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 321.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:0.990 H:M:S, 10.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 320.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.376 H:M:S, 12.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/20-12:42:15 ... thread 0: (1000000,4000000) ops and (325592.8,331909.6) ops/second in (3.071321,12.051473) 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/4 2.34 GB 214.0 2.5 0.0 2.5 6.2 3.7 0.0 1.7 120.9 305.1 20.85 19.37 63 0.331 2558K 2789 0.0 0.0 L1 6/0 487.75 MB 48.8 1.2 1.2 0.0 1.2 1.2 0.2 1.0 229.7 228.9 5.48 5.32 2 2.741 1278K 4328 0.0 0.0 L2 1/1 128.77 MB 0.0 0.2 0.1 0.1 0.2 0.1 0.8 1.5 241.2 241.1 0.80 0.76 2 0.400 195K 70 0.0 0.0 L3 20/2 1005.45 MB 0.9 1.6 0.6 1.0 1.6 0.6 0.3 2.5 218.7 218.1 7.63 7.05 4 1.909 1695K 4974 0.0 0.0 L4 170/0 9.53 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.5 1.0 126.8 126.9 1.33 0.91 1 1.330 171K 0 0.0 0.0 L5 1052/0 86.43 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 1264/7 99.88 GB 0.0 5.7 2.2 3.5 9.4 5.9 2.4 2.5 161.0 267.1 36.09 33.41 72 0.501 5900K 12K 0.0 0.0 Int 0/0 0.00 KB 0.0 5.7 2.2 3.5 9.4 5.9 2.3 2.5 161.0 267.1 36.09 33.41 72 0.501 5900K 12K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 5.7 2.2 3.5 5.7 2.1 0.0 0.0 230.9 230.4 25.16 23.76 18 1.398 5900K 12K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 3.8 3.8 0.0 0.0 0.0 351.7 10.93 9.64 54 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.3 total, 12.1 interval Flush(GB): cumulative 3.753, interval 3.753 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 9.41 GB write, 785.97 MB/s write, 5.67 GB read, 473.69 MB/s read, 36.1 seconds Interval compaction: 9.41 GB write, 799.86 MB/s write, 5.67 GB read, 482.06 MB/s read, 36.1 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 12, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 12, interval: 12 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1068835 Average: 2.2842 StdDev: 12.88 Min: 0 Median: 1.5336 Max: 4868 Percentiles: P50: 1.53 P75: 1.91 P99: 5.75 P99.9: 9.93 P99.99: 14.77 ------------------------------------------------------ [ 0, 1 ] 154480 14.453% 14.453% ### ( 1, 2 ] 712004 66.615% 81.068% ############# ( 2, 3 ] 120523 11.276% 92.344% ## ( 3, 4 ] 43357 4.056% 96.401% # ( 4, 6 ] 31693 2.965% 99.366% # ( 6, 10 ] 5815 0.544% 99.910% ( 10, 15 ] 898 0.084% 99.994% ( 15, 22 ] 107 0.010% 100.004% ( 22, 34 ] 23 0.002% 100.006% ( 34, 51 ] 4 0.000% 100.006% ( 51, 76 ] 8 0.001% 100.007% ( 110, 170 ] 20 0.002% 100.009% ( 170, 250 ] 43 0.004% 100.013% ( 250, 380 ] 10 0.001% 100.014% ( 380, 580 ] 27 0.003% 100.017% ( 580, 870 ] 18 0.002% 100.018% ( 870, 1300 ] 23 0.002% 100.020% ( 1300, 1900 ] 7 0.001% 100.021% ( 1900, 2900 ] 3 0.000% 100.021% ( 2900, 4400 ] 4 0.000% 100.022% ( 4400, 6600 ] 2 0.000% 100.022% ** Level 1 read latency histogram (micros): Count: 161231 Average: 2.7860 StdDev: 16.53 Min: 1 Median: 1.6322 Max: 2364 Percentiles: P50: 1.63 P75: 2.04 P99: 7.54 P99.9: 21.13 P99.99: 494.40 ------------------------------------------------------ [ 0, 1 ] 12857 7.974% 7.974% ## ( 1, 2 ] 107179 66.475% 74.450% ############# ( 2, 3 ] 25358 15.728% 90.177% ### ( 3, 4 ] 7424 4.605% 94.782% # ( 4, 6 ] 6144 3.811% 98.593% # ( 6, 10 ] 1705 1.057% 99.650% ( 10, 15 ] 360 0.223% 99.873% ( 15, 22 ] 50 0.031% 99.904% ( 22, 34 ] 4 0.002% 99.907% ( 34, 51 ] 1 0.001% 99.908% ( 51, 76 ] 1 0.001% 99.908% ( 76, 110 ] 2 0.001% 99.909% ( 110, 170 ] 53 0.033% 99.942% ( 170, 250 ] 31 0.019% 99.962% ( 250, 380 ] 28 0.017% 99.979% ( 380, 580 ] 33 0.020% 99.999% ( 580, 870 ] 13 0.008% 100.007% ( 870, 1300 ] 7 0.004% 100.012% ( 1300, 1900 ] 5 0.003% 100.015% ( 1900, 2900 ] 1 0.001% 100.016% ** Level 2 read latency histogram (micros): Count: 77242 Average: 3.2559 StdDev: 56.61 Min: 1 Median: 1.5603 Max: 9295 Percentiles: P50: 1.56 P75: 1.94 P99: 7.73 P99.9: 168.59 P99.99: 1382.74 ------------------------------------------------------ [ 0, 1 ] 9890 12.804% 12.804% ### ( 1, 2 ] 51277 66.385% 79.189% ############# ( 2, 3 ] 8356 10.818% 90.007% ## ( 3, 4 ] 3721 4.817% 94.824% # ( 4, 6 ] 2852 3.692% 98.516% # ( 6, 10 ] 863 1.117% 99.634% ( 10, 15 ] 120 0.155% 99.789% ( 15, 22 ] 18 0.023% 99.812% ( 22, 34 ] 4 0.005% 99.817% ( 76, 110 ] 12 0.016% 99.833% ( 110, 170 ] 53 0.069% 99.902% ( 170, 250 ] 21 0.027% 99.929% ( 250, 380 ] 17 0.022% 99.951% ( 380, 580 ] 18 0.023% 99.974% ( 580, 870 ] 8 0.010% 99.984% ( 870, 1300 ] 4 0.005% 99.990% ( 1300, 1900 ] 2 0.003% 99.992% ( 1900, 2900 ] 1 0.001% 99.994% ( 2900, 4400 ] 3 0.004% 99.997% ( 4400, 6600 ] 1 0.001% 99.999% ( 6600, 9900 ] 2 0.003% 100.001% ** Level 3 read latency histogram (micros): Count: 245406 Average: 4.1472 StdDev: 74.86 Min: 1 Median: 1.6090 Max: 12377 Percentiles: P50: 1.61 P75: 2.00 P99: 9.45 P99.9: 263.22 P99.99: 654.88 ------------------------------------------------------ [ 0, 1 ] 26792 10.917% 10.917% ## ( 1, 2 ] 157480 64.171% 75.089% ############# ( 2, 3 ] 33331 13.582% 88.671% ### ( 3, 4 ] 11517 4.693% 93.364% # ( 4, 6 ] 10145 4.134% 97.498% # ( 6, 10 ] 4279 1.744% 99.241% ( 10, 15 ] 690 0.281% 99.522% ( 15, 22 ] 74 0.030% 99.553% ( 22, 34 ] 9 0.004% 99.556% ( 34, 51 ] 1 0.000% 99.557% ( 51, 76 ] 3 0.001% 99.558% ( 76, 110 ] 239 0.097% 99.655% ( 110, 170 ] 429 0.175% 99.830% ( 170, 250 ] 160 0.065% 99.895% ( 250, 380 ] 114 0.046% 99.942% ( 380, 580 ] 104 0.042% 99.984% ( 580, 870 ] 56 0.023% 100.007% ( 870, 1300 ] 12 0.005% 100.012% ( 1300, 1900 ] 9 0.004% 100.015% ( 1900, 2900 ] 5 0.002% 100.018% ( 2900, 4400 ] 4 0.002% 100.019% ( 4400, 6600 ] 6 0.002% 100.022% ( 6600, 9900 ] 8 0.003% 100.025% ( 9900, 14000 ] 4 0.002% 100.026% ** Level 4 read latency histogram (micros): Count: 315 Average: 329.8952 StdDev: 1414.70 Min: 1 Median: 2.2132 Max: 10966 Percentiles: P50: 2.21 P75: 6.95 P99: 8635.00 P99.9: 10966.00 P99.99: 10966.00 ------------------------------------------------------ [ 0, 1 ] 44 13.968% 13.968% ### ( 1, 2 ] 99 31.429% 45.397% ###### ( 2, 3 ] 68 21.587% 66.984% #### ( 3, 4 ] 11 3.492% 70.476% # ( 4, 6 ] 9 2.857% 73.333% # ( 6, 10 ] 22 6.984% 80.317% # ( 10, 15 ] 28 8.889% 89.206% ## ( 15, 22 ] 4 1.270% 90.476% ( 110, 170 ] 2 0.635% 91.111% ( 170, 250 ] 1 0.317% 91.429% ( 250, 380 ] 3 0.952% 92.381% ( 380, 580 ] 3 0.952% 93.333% ( 580, 870 ] 2 0.635% 93.968% ( 870, 1300 ] 1 0.317% 94.286% ( 1300, 1900 ] 1 0.317% 94.603% ( 1900, 2900 ] 3 0.952% 95.556% ( 2900, 4400 ] 4 1.270% 96.825% ( 4400, 6600 ] 5 1.587% 98.413% ( 6600, 9900 ] 3 0.952% 99.365% ( 9900, 14000 ] 2 0.635% 100.000% ** Level 5 read latency histogram (micros): Count: 40 Average: 1043.4750 StdDev: 1251.14 Min: 109 Median: 336.6667 Max: 4914 Percentiles: P50: 336.67 P75: 1900.00 P99: 4914.00 P99.9: 4914.00 P99.99: 4914.00 ------------------------------------------------------ ( 76, 110 ] 1 2.500% 2.500% # ( 110, 170 ] 9 22.500% 25.000% ##### ( 170, 250 ] 8 20.000% 45.000% #### ( 250, 380 ] 3 7.500% 52.500% ## ( 380, 580 ] 2 5.000% 57.500% # ( 580, 870 ] 1 2.500% 60.000% # ( 870, 1300 ] 5 12.500% 72.500% ### ( 1300, 1900 ] 1 2.500% 75.000% # ( 1900, 2900 ] 5 12.500% 87.500% ### ( 2900, 4400 ] 4 10.000% 97.500% ## ( 4400, 6600 ] 1 2.500% 100.000% # ** DB Stats ** Uptime(secs): 12.3 total, 3.1 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 320.94 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.385 H:M:S, 11.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 320.44 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.395 H:M:S, 12.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/20-12:42:18 ... thread 0: (1000000,5000000) ops and (279097.9,319806.7) ops/second in (3.582972,15.634445) 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/16 3.26 GB 6.3 3.5 0.0 3.5 8.2 4.7 0.0 1.7 130.3 303.9 27.56 25.74 81 0.340 3646K 3904 0.0 0.0 L1 6/6 487.75 MB 0.0 1.2 1.2 0.0 1.2 1.2 0.2 1.0 229.7 228.9 5.48 5.32 2 2.741 1278K 4328 0.0 0.0 L2 0/0 0.00 KB 0.0 0.2 0.1 0.1 0.2 0.1 0.8 1.5 241.2 241.1 0.80 0.76 2 0.400 195K 70 0.0 0.0 L3 20/0 910.51 MB 0.9 1.8 0.8 1.1 1.8 0.8 0.3 2.4 218.5 217.9 8.63 7.99 5 1.727 1916K 5332 0.0 0.0 L4 172/0 9.74 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.7 1.0 126.8 126.9 1.33 0.91 1 1.330 171K 0 0.0 0.0 L5 1052/0 86.43 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 1267/22 100.80 GB 0.0 6.9 2.3 4.6 11.6 6.9 2.7 2.5 162.1 271.0 43.80 40.72 91 0.481 7207K 13K 0.0 0.0 Int 0/0 0.00 KB 0.0 6.9 2.3 4.6 11.6 6.9 2.6 2.5 162.1 271.0 43.80 40.72 91 0.481 7207K 13K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 6.9 2.3 4.6 6.9 2.3 0.0 0.0 234.1 233.6 30.32 28.78 23 1.318 7207K 13K 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 355.1 13.48 11.93 68 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): 15.8 total, 15.6 interval Flush(GB): cumulative 4.676, interval 4.676 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 11.59 GB write, 749.06 MB/s write, 6.93 GB read, 447.85 MB/s read, 43.8 seconds Interval compaction: 11.59 GB write, 759.26 MB/s write, 6.93 GB read, 453.95 MB/s read, 43.8 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 3, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 3, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 13, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 3, total-stops: 13, interval: 16 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1482751 Average: 2.3065 StdDev: 12.44 Min: 0 Median: 1.5354 Max: 4868 Percentiles: P50: 1.54 P75: 1.91 P99: 5.77 P99.9: 10.58 P99.99: 21.33 ------------------------------------------------------ [ 0, 1 ] 208356 14.052% 14.052% ### ( 1, 2 ] 995549 67.142% 81.194% ############# ( 2, 3 ] 168936 11.393% 92.587% ## ( 3, 4 ] 57958 3.909% 96.496% # ( 4, 6 ] 41920 2.827% 99.323% # ( 6, 10 ] 8392 0.566% 99.889% ( 10, 15 ] 1358 0.092% 99.981% ( 15, 22 ] 149 0.010% 99.991% ( 22, 34 ] 25 0.002% 99.993% ( 34, 51 ] 5 0.000% 99.993% ( 51, 76 ] 10 0.001% 99.994% ( 76, 110 ] 70 0.005% 99.998% ( 110, 170 ] 86 0.006% 100.004% ( 170, 250 ] 87 0.006% 100.010% ( 250, 380 ] 34 0.002% 100.012% ( 380, 580 ] 52 0.004% 100.016% ( 580, 870 ] 38 0.003% 100.018% ( 870, 1300 ] 29 0.002% 100.020% ( 1300, 1900 ] 10 0.001% 100.021% ( 1900, 2900 ] 4 0.000% 100.021% ( 2900, 4400 ] 5 0.000% 100.022% ( 4400, 6600 ] 2 0.000% 100.022% ** Level 1 read latency histogram (micros): Count: 194718 Average: 2.7351 StdDev: 15.48 Min: 1 Median: 1.6066 Max: 2364 Percentiles: P50: 1.61 P75: 1.98 P99: 7.80 P99.9: 99.23 P99.99: 490.40 ------------------------------------------------------ [ 0, 1 ] 18382 9.440% 9.440% ## ( 1, 2 ] 130194 66.863% 76.303% ############# ( 2, 3 ] 28125 14.444% 90.747% ### ( 3, 4 ] 8249 4.236% 94.984% # ( 4, 6 ] 6789 3.487% 98.470% # ( 6, 10 ] 2294 1.178% 99.648% ( 10, 15 ] 404 0.207% 99.856% ( 15, 22 ] 53 0.027% 99.883% ( 22, 34 ] 4 0.002% 99.885% ( 34, 51 ] 3 0.002% 99.887% ( 51, 76 ] 1 0.001% 99.887% ( 76, 110 ] 37 0.019% 99.906% ( 110, 170 ] 70 0.036% 99.942% ( 170, 250 ] 39 0.020% 99.962% ( 250, 380 ] 33 0.017% 99.979% ( 380, 580 ] 39 0.020% 99.999% ( 580, 870 ] 13 0.007% 100.006% ( 870, 1300 ] 7 0.004% 100.009% ( 1300, 1900 ] 5 0.003% 100.012% ( 1900, 2900 ] 1 0.001% 100.012% ** Level 2 read latency histogram (micros): Count: 77242 Average: 3.2559 StdDev: 56.61 Min: 1 Median: 1.5603 Max: 9295 Percentiles: P50: 1.56 P75: 1.94 P99: 7.73 P99.9: 168.59 P99.99: 1382.74 ------------------------------------------------------ [ 0, 1 ] 9890 12.804% 12.804% ### ( 1, 2 ] 51277 66.385% 79.189% ############# ( 2, 3 ] 8356 10.818% 90.007% ## ( 3, 4 ] 3721 4.817% 94.824% # ( 4, 6 ] 2852 3.692% 98.516% # ( 6, 10 ] 863 1.117% 99.634% ( 10, 15 ] 120 0.155% 99.789% ( 15, 22 ] 18 0.023% 99.812% ( 22, 34 ] 4 0.005% 99.817% ( 76, 110 ] 12 0.016% 99.833% ( 110, 170 ] 53 0.069% 99.902% ( 170, 250 ] 21 0.027% 99.929% ( 250, 380 ] 17 0.022% 99.951% ( 380, 580 ] 18 0.023% 99.974% ( 580, 870 ] 8 0.010% 99.984% ( 870, 1300 ] 4 0.005% 99.990% ( 1300, 1900 ] 2 0.003% 99.992% ( 1900, 2900 ] 1 0.001% 99.994% ( 2900, 4400 ] 3 0.004% 99.997% ( 4400, 6600 ] 1 0.001% 99.999% ( 6600, 9900 ] 2 0.003% 100.001% ** Level 3 read latency histogram (micros): Count: 251012 Average: 4.1070 StdDev: 74.04 Min: 1 Median: 1.6051 Max: 12377 Percentiles: P50: 1.61 P75: 1.99 P99: 9.41 P99.9: 260.16 P99.99: 651.98 ------------------------------------------------------ [ 0, 1 ] 27906 11.117% 11.117% ## ( 1, 2 ] 161286 64.254% 75.372% ############# ( 2, 3 ] 33768 13.453% 88.824% ### ( 3, 4 ] 11647 4.640% 93.464% # ( 4, 6 ] 10233 4.077% 97.541% # ( 6, 10 ] 4296 1.711% 99.253% ( 10, 15 ] 696 0.277% 99.530% ( 15, 22 ] 74 0.029% 99.559% ( 22, 34 ] 10 0.004% 99.563% ( 34, 51 ] 1 0.000% 99.564% ( 51, 76 ] 3 0.001% 99.565% ( 76, 110 ] 239 0.095% 99.660% ( 110, 170 ] 430 0.171% 99.831% ( 170, 250 ] 163 0.065% 99.896% ( 250, 380 ] 115 0.046% 99.942% ( 380, 580 ] 106 0.042% 99.984% ( 580, 870 ] 56 0.022% 100.007% ( 870, 1300 ] 12 0.005% 100.012% ( 1300, 1900 ] 9 0.004% 100.015% ( 1900, 2900 ] 5 0.002% 100.017% ( 2900, 4400 ] 4 0.002% 100.019% ( 4400, 6600 ] 6 0.002% 100.021% ( 6600, 9900 ] 8 0.003% 100.024% ( 9900, 14000 ] 4 0.002% 100.026% ** Level 4 read latency histogram (micros): Count: 315 Average: 329.8952 StdDev: 1414.70 Min: 1 Median: 2.2132 Max: 10966 Percentiles: P50: 2.21 P75: 6.95 P99: 8635.00 P99.9: 10966.00 P99.99: 10966.00 ------------------------------------------------------ [ 0, 1 ] 44 13.968% 13.968% ### ( 1, 2 ] 99 31.429% 45.397% ###### ( 2, 3 ] 68 21.587% 66.984% #### ( 3, 4 ] 11 3.492% 70.476% # ( 4, 6 ] 9 2.857% 73.333% # ( 6, 10 ] 22 6.984% 80.317% # ( 10, 15 ] 28 8.889% 89.206% ## ( 15, 22 ] 4 1.270% 90.476% ( 110, 170 ] 2 0.635% 91.111% ( 170, 250 ] 1 0.317% 91.429% ( 250, 380 ] 3 0.952% 92.381% ( 380, 580 ] 3 0.952% 93.333% ( 580, 870 ] 2 0.635% 93.968% ( 870, 1300 ] 1 0.317% 94.286% ( 1300, 1900 ] 1 0.317% 94.603% ( 1900, 2900 ] 3 0.952% 95.556% ( 2900, 4400 ] 4 1.270% 96.825% ( 4400, 6600 ] 5 1.587% 98.413% ( 6600, 9900 ] 3 0.952% 99.365% ( 9900, 14000 ] 2 0.635% 100.000% ** Level 5 read latency histogram (micros): Count: 40 Average: 1043.4750 StdDev: 1251.14 Min: 109 Median: 336.6667 Max: 4914 Percentiles: P50: 336.67 P75: 1900.00 P99: 4914.00 P99.9: 4914.00 P99.99: 4914.00 ------------------------------------------------------ ( 76, 110 ] 1 2.500% 2.500% # ( 110, 170 ] 9 22.500% 25.000% ##### ( 170, 250 ] 8 20.000% 45.000% #### ( 250, 380 ] 3 7.500% 52.500% ## ( 380, 580 ] 2 5.000% 57.500% # ( 580, 870 ] 1 2.500% 60.000% # ( 870, 1300 ] 5 12.500% 72.500% ### ( 1300, 1900 ] 1 2.500% 75.000% # ( 1900, 2900 ] 5 12.500% 87.500% ### ( 2900, 4400 ] 4 10.000% 97.500% ## ( 4400, 6600 ] 1 2.500% 100.000% # ** DB Stats ** Uptime(secs): 15.8 total, 3.6 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 310.48 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.244 H:M:S, 14.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 274.69 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.859 H:M:S, 24.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/20-12:42:25 ... thread 0: (1000000,6000000) ops and (154094.8,271199.2) ops/second in (6.489510,22.123955) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 18/17 4.24 GB 87.8 5.4 0.0 5.4 11.0 5.7 0.0 1.9 145.1 298.4 37.76 35.48 102 0.370 5564K 7705 0.0 0.0 L1 6/6 487.75 MB 0.0 1.2 1.2 0.0 1.2 1.2 0.2 1.0 229.7 228.9 5.48 5.32 2 2.741 1278K 4328 0.0 0.0 L2 0/0 0.00 KB 0.0 0.2 0.1 0.1 0.2 0.1 0.8 1.5 241.2 241.1 0.80 0.76 2 0.400 195K 70 0.0 0.0 L3 20/0 910.51 MB 0.9 1.8 0.8 1.1 1.8 0.8 0.3 2.4 218.5 217.9 8.63 7.99 5 1.727 1916K 5332 0.0 0.0 L4 172/0 9.74 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.7 1.0 126.8 126.9 1.33 0.91 1 1.330 171K 0 0.0 0.0 L5 1052/0 86.43 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1268/23 101.78 GB 0.0 8.8 2.3 6.5 14.4 7.9 2.7 2.5 166.4 273.4 54.01 50.46 112 0.482 9125K 17K 0.0 0.0 Int 0/0 0.00 KB 0.0 8.8 2.3 6.5 14.4 7.9 2.6 2.5 166.4 273.4 54.01 50.46 112 0.482 9125K 17K 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 2.3 6.5 8.8 2.3 0.0 0.0 238.9 238.4 37.62 35.98 28 1.344 9125K 17K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 5.7 5.7 0.0 0.0 0.0 353.7 16.39 14.49 84 0.195 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): 22.3 total, 22.1 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.42 GB write, 660.97 MB/s write, 8.78 GB read, 402.31 MB/s read, 54.0 seconds Interval compaction: 14.42 GB write, 667.33 MB/s write, 8.78 GB read, 406.19 MB/s read, 54.0 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: 2257151 Average: 2.3230 StdDev: 12.26 Min: 0 Median: 1.5331 Max: 4868 Percentiles: P50: 1.53 P75: 1.90 P99: 5.81 P99.9: 10.58 P99.99: 53.29 ------------------------------------------------------ [ 0, 1 ] 316880 14.039% 14.039% ### ( 1, 2 ] 1522643 67.459% 81.498% ############# ( 2, 3 ] 250131 11.082% 92.579% ## ( 3, 4 ] 87967 3.897% 96.477% # ( 4, 6 ] 62944 2.789% 99.265% # ( 6, 10 ] 14094 0.624% 99.890% ( 10, 15 ] 2020 0.089% 99.979% ( 15, 22 ] 204 0.009% 99.988% ( 22, 34 ] 33 0.001% 99.990% ( 34, 51 ] 9 0.000% 99.990% ( 51, 76 ] 14 0.001% 99.991% ( 76, 110 ] 197 0.009% 99.999% ( 110, 170 ] 287 0.013% 100.012% ( 170, 250 ] 159 0.007% 100.019% ( 250, 380 ] 82 0.004% 100.023% ( 380, 580 ] 97 0.004% 100.027% ( 580, 870 ] 56 0.002% 100.030% ( 870, 1300 ] 39 0.002% 100.031% ( 1300, 1900 ] 11 0.000% 100.032% ( 1900, 2900 ] 8 0.000% 100.032% ( 2900, 4400 ] 7 0.000% 100.032% ( 4400, 6600 ] 3 0.000% 100.033% ** Level 1 read latency histogram (micros): Count: 267305 Average: 2.7348 StdDev: 15.00 Min: 1 Median: 1.5821 Max: 2364 Percentiles: P50: 1.58 P75: 1.95 P99: 8.01 P99.9: 139.06 P99.99: 519.50 ------------------------------------------------------ [ 0, 1 ] 28962 10.835% 10.835% ## ( 1, 2 ] 179862 67.287% 78.122% ############# ( 2, 3 ] 35152 13.151% 91.273% ### ( 3, 4 ] 10455 3.911% 95.184% # ( 4, 6 ] 8470 3.169% 98.352% # ( 6, 10 ] 3452 1.291% 99.644% ( 10, 15 ] 478 0.179% 99.823% ( 15, 22 ] 55 0.021% 99.843% ( 22, 34 ] 4 0.001% 99.845% ( 34, 51 ] 3 0.001% 99.846% ( 51, 76 ] 1 0.000% 99.846% ( 76, 110 ] 57 0.021% 99.868% ( 110, 170 ] 179 0.067% 99.935% ( 170, 250 ] 67 0.025% 99.960% ( 250, 380 ] 45 0.017% 99.976% ( 380, 580 ] 52 0.019% 99.996% ( 580, 870 ] 19 0.007% 100.003% ( 870, 1300 ] 10 0.004% 100.007% ( 1300, 1900 ] 5 0.002% 100.009% ( 1900, 2900 ] 1 0.000% 100.009% ** Level 2 read latency histogram (micros): Count: 77242 Average: 3.2559 StdDev: 56.61 Min: 1 Median: 1.5603 Max: 9295 Percentiles: P50: 1.56 P75: 1.94 P99: 7.73 P99.9: 168.59 P99.99: 1382.74 ------------------------------------------------------ [ 0, 1 ] 9890 12.804% 12.804% ### ( 1, 2 ] 51277 66.385% 79.189% ############# ( 2, 3 ] 8356 10.818% 90.007% ## ( 3, 4 ] 3721 4.817% 94.824% # ( 4, 6 ] 2852 3.692% 98.516% # ( 6, 10 ] 863 1.117% 99.634% ( 10, 15 ] 120 0.155% 99.789% ( 15, 22 ] 18 0.023% 99.812% ( 22, 34 ] 4 0.005% 99.817% ( 76, 110 ] 12 0.016% 99.833% ( 110, 170 ] 53 0.069% 99.902% ( 170, 250 ] 21 0.027% 99.929% ( 250, 380 ] 17 0.022% 99.951% ( 380, 580 ] 18 0.023% 99.974% ( 580, 870 ] 8 0.010% 99.984% ( 870, 1300 ] 4 0.005% 99.990% ( 1300, 1900 ] 2 0.003% 99.992% ( 1900, 2900 ] 1 0.001% 99.994% ( 2900, 4400 ] 3 0.004% 99.997% ( 4400, 6600 ] 1 0.001% 99.999% ( 6600, 9900 ] 2 0.003% 100.001% ** Level 3 read latency histogram (micros): Count: 251012 Average: 4.1070 StdDev: 74.04 Min: 1 Median: 1.6051 Max: 12377 Percentiles: P50: 1.61 P75: 1.99 P99: 9.41 P99.9: 260.16 P99.99: 651.98 ------------------------------------------------------ [ 0, 1 ] 27906 11.117% 11.117% ## ( 1, 2 ] 161286 64.254% 75.372% ############# ( 2, 3 ] 33768 13.453% 88.824% ### ( 3, 4 ] 11647 4.640% 93.464% # ( 4, 6 ] 10233 4.077% 97.541% # ( 6, 10 ] 4296 1.711% 99.253% ( 10, 15 ] 696 0.277% 99.530% ( 15, 22 ] 74 0.029% 99.559% ( 22, 34 ] 10 0.004% 99.563% ( 34, 51 ] 1 0.000% 99.564% ( 51, 76 ] 3 0.001% 99.565% ( 76, 110 ] 239 0.095% 99.660% ( 110, 170 ] 430 0.171% 99.831% ( 170, 250 ] 163 0.065% 99.896% ( 250, 380 ] 115 0.046% 99.942% ( 380, 580 ] 106 0.042% 99.984% ( 580, 870 ] 56 0.022% 100.007% ( 870, 1300 ] 12 0.005% 100.012% ( 1300, 1900 ] 9 0.004% 100.015% ( 1900, 2900 ] 5 0.002% 100.017% ( 2900, 4400 ] 4 0.002% 100.019% ( 4400, 6600 ] 6 0.002% 100.021% ( 6600, 9900 ] 8 0.003% 100.024% ( 9900, 14000 ] 4 0.002% 100.026% ** Level 4 read latency histogram (micros): Count: 315 Average: 329.8952 StdDev: 1414.70 Min: 1 Median: 2.2132 Max: 10966 Percentiles: P50: 2.21 P75: 6.95 P99: 8635.00 P99.9: 10966.00 P99.99: 10966.00 ------------------------------------------------------ [ 0, 1 ] 44 13.968% 13.968% ### ( 1, 2 ] 99 31.429% 45.397% ###### ( 2, 3 ] 68 21.587% 66.984% #### ( 3, 4 ] 11 3.492% 70.476% # ( 4, 6 ] 9 2.857% 73.333% # ( 6, 10 ] 22 6.984% 80.317% # ( 10, 15 ] 28 8.889% 89.206% ## ( 15, 22 ] 4 1.270% 90.476% ( 110, 170 ] 2 0.635% 91.111% ( 170, 250 ] 1 0.317% 91.429% ( 250, 380 ] 3 0.952% 92.381% ( 380, 580 ] 3 0.952% 93.333% ( 580, 870 ] 2 0.635% 93.968% ( 870, 1300 ] 1 0.317% 94.286% ( 1300, 1900 ] 1 0.317% 94.603% ( 1900, 2900 ] 3 0.952% 95.556% ( 2900, 4400 ] 4 1.270% 96.825% ( 4400, 6600 ] 5 1.587% 98.413% ( 6600, 9900 ] 3 0.952% 99.365% ( 9900, 14000 ] 2 0.635% 100.000% ** Level 5 read latency histogram (micros): Count: 40 Average: 1043.4750 StdDev: 1251.14 Min: 109 Median: 336.6667 Max: 4914 Percentiles: P50: 336.67 P75: 1900.00 P99: 4914.00 P99.9: 4914.00 P99.99: 4914.00 ------------------------------------------------------ ( 76, 110 ] 1 2.500% 2.500% # ( 110, 170 ] 9 22.500% 25.000% ##### ( 170, 250 ] 8 20.000% 45.000% #### ( 250, 380 ] 3 7.500% 52.500% ## ( 380, 580 ] 2 5.000% 57.500% # ( 580, 870 ] 1 2.500% 60.000% # ( 870, 1300 ] 5 12.500% 72.500% ### ( 1300, 1900 ] 1 2.500% 75.000% # ( 1900, 2900 ] 5 12.500% 87.500% ### ( 2900, 4400 ] 4 10.000% 97.500% ## ( 4400, 6600 ] 1 2.500% 100.000% # ** DB Stats ** Uptime(secs): 22.3 total, 6.5 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 264.34 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.879 H:M:S, 26.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 151.66 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:3.635 H:M:S, 56.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/20-12:42:34 ... thread 0: (1000000,7000000) ops and (113839.8,226476.9) ops/second in (8.784274,30.908229) 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/9 2.82 GB 12.6 6.6 0.0 6.6 13.2 6.6 0.0 2.0 140.2 278.9 48.51 43.16 115 0.422 6906K 12K 0.0 0.0 L1 7/7 853.86 MB 0.0 4.0 3.6 0.5 4.0 3.5 0.2 1.1 220.6 218.4 18.76 17.97 3 6.252 4202K 42K 0.0 0.0 L2 1/1 128.78 MB 0.0 0.2 0.1 0.1 0.2 0.1 2.7 1.5 241.2 241.1 0.80 0.76 2 0.400 195K 70 0.0 0.0 L3 28/6 1.27 GB 1.0 5.0 2.6 2.4 4.9 2.6 0.3 1.9 171.6 170.9 29.59 22.89 17 1.741 5156K 21K 0.0 0.0 L4 181/7 9.87 GB 1.0 1.7 1.6 0.1 1.7 1.6 0.7 1.0 117.9 117.7 14.37 8.21 27 0.532 1692K 1744 0.0 0.0 L5 1068/0 87.72 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 1295/30 102.64 GB 0.0 17.5 7.9 9.6 24.0 14.4 5.9 3.6 159.8 219.3 112.03 93.00 164 0.683 18M 78K 0.0 0.0 Int 0/0 0.00 KB 0.0 17.5 7.9 9.6 24.0 14.4 5.8 3.6 159.8 219.3 112.03 93.00 164 0.683 18M 78K 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.5 7.9 9.6 17.4 7.8 0.0 0.0 198.1 197.2 90.40 75.95 69 1.310 18M 78K 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 311.5 21.64 17.05 95 0.228 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): 31.1 total, 30.9 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: 23.99 GB write, 789.32 MB/s write, 17.49 GB read, 575.31 MB/s read, 112.0 seconds Interval compaction: 23.99 GB write, 794.76 MB/s write, 17.49 GB read, 579.27 MB/s read, 112.0 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 13, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 13, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 50, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 13, total-stops: 50, interval: 63 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2920456 Average: 2.7018 StdDev: 117.02 Min: 0 Median: 1.5594 Max: 195807 Percentiles: P50: 1.56 P75: 1.94 P99: 6.70 P99.9: 14.26 P99.99: 187.39 ------------------------------------------------------ [ 0, 1 ] 394242 13.499% 13.499% ### ( 1, 2 ] 1905671 65.253% 78.752% ############# ( 2, 3 ] 349660 11.973% 90.725% ## ( 3, 4 ] 128611 4.404% 95.128% # ( 4, 6 ] 108300 3.708% 98.837% # ( 6, 10 ] 27402 0.938% 99.775% ( 10, 15 ] 4283 0.147% 99.922% ( 15, 22 ] 418 0.014% 99.936% ( 22, 34 ] 44 0.002% 99.938% ( 34, 51 ] 13 0.000% 99.938% ( 51, 76 ] 19 0.001% 99.939% ( 76, 110 ] 617 0.021% 99.960% ( 110, 170 ] 808 0.028% 99.987% ( 170, 250 ] 354 0.012% 100.000% ( 250, 380 ] 205 0.007% 100.007% ( 380, 580 ] 237 0.008% 100.015% ( 580, 870 ] 169 0.006% 100.020% ( 870, 1300 ] 126 0.004% 100.025% ( 1300, 1900 ] 45 0.002% 100.026% ( 1900, 2900 ] 45 0.002% 100.028% ( 2900, 4400 ] 49 0.002% 100.030% ( 4400, 6600 ] 12 0.000% 100.030% ( 6600, 9900 ] 1 0.000% 100.030% ( 170000, 250000 ] 1 0.000% 100.030% ** Level 1 read latency histogram (micros): Count: 814582 Average: 5.2725 StdDev: 176.95 Min: 1 Median: 1.8069 Max: 144019 Percentiles: P50: 1.81 P75: 2.72 P99: 9.45 P99.9: 166.31 P99.99: 587.11 ------------------------------------------------------ [ 0, 1 ] 43176 5.300% 5.300% # ( 1, 2 ] 451242 55.396% 60.696% ########### ( 2, 3 ] 162162 19.907% 80.603% #### ( 3, 4 ] 64591 7.929% 88.533% ## ( 4, 6 ] 69951 8.587% 97.120% ## ( 6, 10 ] 17739 2.178% 99.298% ( 10, 15 ] 4015 0.493% 99.791% ( 15, 22 ] 400 0.049% 99.840% ( 22, 34 ] 38 0.005% 99.844% ( 34, 51 ] 15 0.002% 99.846% ( 51, 76 ] 7 0.001% 99.847% ( 76, 110 ] 133 0.016% 99.863% ( 110, 170 ] 318 0.039% 99.902% ( 170, 250 ] 186 0.023% 99.925% ( 250, 380 ] 231 0.028% 99.954% ( 380, 580 ] 290 0.036% 99.989% ( 580, 870 ] 267 0.033% 100.022% ( 870, 1300 ] 194 0.024% 100.046% ( 1300, 1900 ] 102 0.013% 100.058% ( 1900, 2900 ] 131 0.016% 100.074% ( 2900, 4400 ] 122 0.015% 100.089% ( 4400, 6600 ] 41 0.005% 100.094% ( 6600, 9900 ] 10 0.001% 100.096% ( 9900, 14000 ] 1 0.000% 100.096% ( 110000, 170000 ] 1 0.000% 100.096% ** Level 2 read latency histogram (micros): Count: 77242 Average: 3.2559 StdDev: 56.61 Min: 1 Median: 1.5603 Max: 9295 Percentiles: P50: 1.56 P75: 1.94 P99: 7.73 P99.9: 168.59 P99.99: 1382.74 ------------------------------------------------------ [ 0, 1 ] 9890 12.804% 12.804% ### ( 1, 2 ] 51277 66.385% 79.189% ############# ( 2, 3 ] 8356 10.818% 90.007% ## ( 3, 4 ] 3721 4.817% 94.824% # ( 4, 6 ] 2852 3.692% 98.516% # ( 6, 10 ] 863 1.117% 99.634% ( 10, 15 ] 120 0.155% 99.789% ( 15, 22 ] 18 0.023% 99.812% ( 22, 34 ] 4 0.005% 99.817% ( 76, 110 ] 12 0.016% 99.833% ( 110, 170 ] 53 0.069% 99.902% ( 170, 250 ] 21 0.027% 99.929% ( 250, 380 ] 17 0.022% 99.951% ( 380, 580 ] 18 0.023% 99.974% ( 580, 870 ] 8 0.010% 99.984% ( 870, 1300 ] 4 0.005% 99.990% ( 1300, 1900 ] 2 0.003% 99.992% ( 1900, 2900 ] 1 0.001% 99.994% ( 2900, 4400 ] 3 0.004% 99.997% ( 4400, 6600 ] 1 0.001% 99.999% ( 6600, 9900 ] 2 0.003% 100.001% ** Level 3 read latency histogram (micros): Count: 1006859 Average: 6.2764 StdDev: 354.01 Min: 1 Median: 1.9239 Max: 200714 Percentiles: P50: 1.92 P75: 2.94 P99: 9.62 P99.9: 248.40 P99.99: 690.15 ------------------------------------------------------ [ 0, 1 ] 37405 3.715% 3.715% # ( 1, 2 ] 504425 50.099% 53.814% ########## ( 2, 3 ] 227142 22.559% 76.373% ##### ( 3, 4 ] 97573 9.691% 86.064% ## ( 4, 6 ] 109741 10.899% 96.964% ## ( 6, 10 ] 22687 2.253% 99.217% ( 10, 15 ] 5135 0.510% 99.727% ( 15, 22 ] 554 0.055% 99.782% ( 22, 34 ] 63 0.006% 99.788% ( 34, 51 ] 26 0.003% 99.791% ( 51, 76 ] 13 0.001% 99.792% ( 76, 110 ] 246 0.024% 99.816% ( 110, 170 ] 506 0.050% 99.867% ( 170, 250 ] 343 0.034% 99.901% ( 250, 380 ] 340 0.034% 99.934% ( 380, 580 ] 407 0.040% 99.975% ( 580, 870 ] 401 0.040% 100.015% ( 870, 1300 ] 252 0.025% 100.040% ( 1300, 1900 ] 174 0.017% 100.057% ( 1900, 2900 ] 187 0.019% 100.076% ( 2900, 4400 ] 178 0.018% 100.093% ( 4400, 6600 ] 44 0.004% 100.098% ( 6600, 9900 ] 17 0.002% 100.099% ( 9900, 14000 ] 5 0.000% 100.100% ( 170000, 250000 ] 3 0.000% 100.100% ** Level 4 read latency histogram (micros): Count: 21522 Average: 151.8397 StdDev: 2030.90 Min: 1 Median: 2.1980 Max: 201746 Percentiles: P50: 2.20 P75: 3.62 P99: 3284.32 P99.9: 6520.28 P99.99: 135434.00 ------------------------------------------------------ [ 0, 1 ] 546 2.537% 2.537% # ( 1, 2 ] 9266 43.054% 45.591% ######### ( 2, 3 ] 4793 22.270% 67.861% #### ( 3, 4 ] 2477 11.509% 79.370% ## ( 4, 6 ] 1792 8.326% 87.696% ## ( 6, 10 ] 470 2.184% 89.880% ( 10, 15 ] 218 1.013% 90.893% ( 15, 22 ] 18 0.084% 90.977% ( 76, 110 ] 2 0.009% 90.986% ( 110, 170 ] 27 0.125% 91.111% ( 170, 250 ] 86 0.400% 91.511% ( 250, 380 ] 164 0.762% 92.273% ( 380, 580 ] 283 1.315% 93.588% ( 580, 870 ] 353 1.640% 95.228% ( 870, 1300 ] 327 1.519% 96.748% ( 1300, 1900 ] 253 1.176% 97.923% ( 1900, 2900 ] 179 0.832% 98.755% ( 2900, 4400 ] 206 0.957% 99.712% ( 4400, 6600 ] 42 0.195% 99.907% ( 6600, 9900 ] 13 0.060% 99.967% ( 9900, 14000 ] 4 0.019% 99.986% ( 110000, 170000 ] 2 0.009% 99.995% ( 170000, 250000 ] 1 0.005% 100.000% ** Level 5 read latency histogram (micros): Count: 134 Average: 1846.8881 StdDev: 1718.70 Min: 90 Median: 1165.6250 Max: 7549 Percentiles: P50: 1165.62 P75: 3128.26 P99: 6542.46 P99.9: 7549.00 P99.99: 7549.00 ------------------------------------------------------ ( 76, 110 ] 2 1.493% 1.493% ( 110, 170 ] 9 6.716% 8.209% # ( 170, 250 ] 14 10.448% 18.657% ## ( 250, 380 ] 11 8.209% 26.866% ## ( 380, 580 ] 10 7.463% 34.328% # ( 580, 870 ] 10 7.463% 41.791% # ( 870, 1300 ] 16 11.940% 53.731% ## ( 1300, 1900 ] 5 3.731% 57.463% # ( 1900, 2900 ] 20 14.925% 72.388% ### ( 2900, 4400 ] 23 17.164% 89.552% ### ( 4400, 6600 ] 13 9.701% 99.254% ## ( 6600, 9900 ] 1 0.746% 100.000% ** DB Stats ** Uptime(secs): 31.1 total, 8.8 interval Cumulative writes: 0 writes, 7000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 6.73 GB, 221.36 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:11.566 H:M:S, 37.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 112.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:5.687 H:M:S, 64.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 7 num-running-flushes: 1 2024/11/20-12:42:37 ... thread 0: (1000000,8000000) ops and (302850.9,233848.5) ops/second in (3.301955,34.210184) 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/9 3.87 GB 132.1 7.6 0.0 7.6 15.2 7.6 0.0 2.0 139.8 279.3 55.88 49.82 132 0.423 7929K 13K 0.0 0.0 L1 7/7 853.86 MB 0.0 4.0 3.6 0.5 4.0 3.5 0.2 1.1 220.6 218.4 18.76 17.97 3 6.252 4202K 42K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.2 0.1 0.1 0.2 0.1 2.7 1.5 241.2 241.1 0.80 0.76 2 0.400 195K 70 0.0 0.0 L3 22/0 977.74 MB 1.0 5.2 2.7 2.5 5.2 2.7 0.3 1.9 170.6 169.9 31.42 24.19 18 1.745 5444K 23K 0.0 0.0 L4 181/0 9.63 GB 1.0 2.1 2.0 0.1 2.1 2.0 0.7 1.0 123.0 122.8 17.65 10.51 35 0.504 2150K 1744 0.0 0.0 L5 1076/0 88.40 GB 0.9 0.0 0.0 0.0 0.0 0.0 2.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1301/16 103.68 GB 0.0 19.2 8.4 10.8 26.8 16.0 6.6 3.5 158.0 220.1 124.50 103.24 190 0.655 19M 81K 0.0 0.0 Int 0/0 0.00 KB 0.0 19.2 8.4 10.8 26.8 16.0 6.5 3.5 158.0 220.1 124.50 103.24 190 0.655 19M 81K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 19.2 8.4 10.8 19.1 8.3 0.0 0.0 197.4 196.5 99.66 83.48 81 1.230 19M 81K 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 314.5 24.84 19.76 109 0.228 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 34.4 total, 34.2 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: 26.76 GB write, 795.91 MB/s write, 19.21 GB read, 571.42 MB/s read, 124.5 seconds Interval compaction: 26.76 GB write, 800.86 MB/s write, 19.21 GB read, 574.98 MB/s read, 124.5 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 13, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 13, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 55, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 13, total-stops: 55, interval: 68 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3325228 Average: 2.6780 StdDev: 109.78 Min: 0 Median: 1.5646 Max: 195807 Percentiles: P50: 1.56 P75: 1.95 P99: 6.77 P99.9: 14.00 P99.99: 169.17 ------------------------------------------------------ [ 0, 1 ] 435917 13.109% 13.109% ### ( 1, 2 ] 2172720 65.340% 78.450% ############# ( 2, 3 ] 407547 12.256% 90.706% ## ( 3, 4 ] 145775 4.384% 95.090% # ( 4, 6 ] 123796 3.723% 98.813% # ( 6, 10 ] 32183 0.968% 99.781% ( 10, 15 ] 4956 0.149% 99.930% ( 15, 22 ] 453 0.014% 99.943% ( 22, 34 ] 50 0.002% 99.945% ( 34, 51 ] 15 0.000% 99.945% ( 51, 76 ] 19 0.001% 99.946% ( 76, 110 ] 649 0.020% 99.965% ( 110, 170 ] 828 0.025% 99.990% ( 170, 250 ] 372 0.011% 100.002% ( 250, 380 ] 225 0.007% 100.008% ( 380, 580 ] 267 0.008% 100.016% ( 580, 870 ] 188 0.006% 100.022% ( 870, 1300 ] 137 0.004% 100.026% ( 1300, 1900 ] 47 0.001% 100.028% ( 1900, 2900 ] 46 0.001% 100.029% ( 2900, 4400 ] 50 0.002% 100.030% ( 4400, 6600 ] 13 0.000% 100.031% ( 6600, 9900 ] 1 0.000% 100.031% ( 170000, 250000 ] 1 0.000% 100.031% ** Level 1 read latency histogram (micros): Count: 821465 Average: 5.2515 StdDev: 176.21 Min: 1 Median: 1.8068 Max: 144019 Percentiles: P50: 1.81 P75: 2.72 P99: 9.45 P99.9: 165.01 P99.99: 586.36 ------------------------------------------------------ [ 0, 1 ] 43408 5.284% 5.284% # ( 1, 2 ] 455301 55.425% 60.710% ########### ( 2, 3 ] 163510 19.905% 80.614% #### ( 3, 4 ] 65108 7.926% 88.540% ## ( 4, 6 ] 70486 8.581% 97.121% ## ( 6, 10 ] 17905 2.180% 99.300% ( 10, 15 ] 4037 0.491% 99.792% ( 15, 22 ] 404 0.049% 99.841% ( 22, 34 ] 38 0.005% 99.846% ( 34, 51 ] 15 0.002% 99.847% ( 51, 76 ] 7 0.001% 99.848% ( 76, 110 ] 133 0.016% 99.865% ( 110, 170 ] 318 0.039% 99.903% ( 170, 250 ] 186 0.023% 99.926% ( 250, 380 ] 231 0.028% 99.954% ( 380, 580 ] 290 0.035% 99.989% ( 580, 870 ] 267 0.033% 100.022% ( 870, 1300 ] 194 0.024% 100.045% ( 1300, 1900 ] 102 0.012% 100.058% ( 1900, 2900 ] 131 0.016% 100.074% ( 2900, 4400 ] 122 0.015% 100.089% ( 4400, 6600 ] 41 0.005% 100.094% ( 6600, 9900 ] 10 0.001% 100.095% ( 9900, 14000 ] 1 0.000% 100.095% ( 110000, 170000 ] 1 0.000% 100.095% ** Level 2 read latency histogram (micros): Count: 77242 Average: 3.2559 StdDev: 56.61 Min: 1 Median: 1.5603 Max: 9295 Percentiles: P50: 1.56 P75: 1.94 P99: 7.73 P99.9: 168.59 P99.99: 1382.74 ------------------------------------------------------ [ 0, 1 ] 9890 12.804% 12.804% ### ( 1, 2 ] 51277 66.385% 79.189% ############# ( 2, 3 ] 8356 10.818% 90.007% ## ( 3, 4 ] 3721 4.817% 94.824% # ( 4, 6 ] 2852 3.692% 98.516% # ( 6, 10 ] 863 1.117% 99.634% ( 10, 15 ] 120 0.155% 99.789% ( 15, 22 ] 18 0.023% 99.812% ( 22, 34 ] 4 0.005% 99.817% ( 76, 110 ] 12 0.016% 99.833% ( 110, 170 ] 53 0.069% 99.902% ( 170, 250 ] 21 0.027% 99.929% ( 250, 380 ] 17 0.022% 99.951% ( 380, 580 ] 18 0.023% 99.974% ( 580, 870 ] 8 0.010% 99.984% ( 870, 1300 ] 4 0.005% 99.990% ( 1300, 1900 ] 2 0.003% 99.992% ( 1900, 2900 ] 1 0.001% 99.994% ( 2900, 4400 ] 3 0.004% 99.997% ( 4400, 6600 ] 1 0.001% 99.999% ( 6600, 9900 ] 2 0.003% 100.001% ** Level 3 read latency histogram (micros): Count: 1107330 Average: 6.0204 StdDev: 337.67 Min: 0 Median: 1.9294 Max: 200714 Percentiles: P50: 1.93 P75: 2.94 P99: 9.55 P99.9: 178.94 P99.99: 532.39 ------------------------------------------------------ [ 0, 1 ] 39206 3.541% 3.541% # ( 1, 2 ] 553529 49.988% 53.528% ########## ( 2, 3 ] 252074 22.764% 76.292% ##### ( 3, 4 ] 107877 9.742% 86.035% ## ( 4, 6 ] 120984 10.926% 96.960% ## ( 6, 10 ] 25445 2.298% 99.258% ( 10, 15 ] 5582 0.504% 99.762% ( 15, 22 ] 601 0.054% 99.816% ( 22, 34 ] 66 0.006% 99.822% ( 34, 51 ] 26 0.002% 99.825% ( 51, 76 ] 14 0.001% 99.826% ( 76, 110 ] 248 0.022% 99.848% ( 110, 170 ] 530 0.048% 99.896% ( 170, 250 ] 364 0.033% 99.929% ( 250, 380 ] 354 0.032% 99.961% ( 380, 580 ] 419 0.038% 99.999% ( 580, 870 ] 408 0.037% 100.036% ( 870, 1300 ] 257 0.023% 100.059% ( 1300, 1900 ] 176 0.016% 100.075% ( 1900, 2900 ] 188 0.017% 100.092% ( 2900, 4400 ] 181 0.016% 100.108% ( 4400, 6600 ] 44 0.004% 100.112% ( 6600, 9900 ] 17 0.002% 100.114% ( 9900, 14000 ] 5 0.000% 100.114% ( 170000, 250000 ] 3 0.000% 100.115% ** Level 4 read latency histogram (micros): Count: 25900 Average: 131.9659 StdDev: 1852.95 Min: 1 Median: 2.1767 Max: 201746 Percentiles: P50: 2.18 P75: 3.59 P99: 2979.33 P99.9: 6290.95 P99.99: 122300.00 ------------------------------------------------------ [ 0, 1 ] 675 2.606% 2.606% # ( 1, 2 ] 11262 43.483% 46.089% ######### ( 2, 3 ] 5734 22.139% 68.228% #### ( 3, 4 ] 2964 11.444% 79.672% ## ( 4, 6 ] 2147 8.290% 87.961% ## ( 6, 10 ] 573 2.212% 90.174% ( 10, 15 ] 241 0.931% 91.104% ( 15, 22 ] 22 0.085% 91.189% ( 76, 110 ] 7 0.027% 91.216% ( 110, 170 ] 96 0.371% 91.587% ( 170, 250 ] 159 0.614% 92.201% ( 250, 380 ] 238 0.919% 93.120% ( 380, 580 ] 334 1.290% 94.409% ( 580, 870 ] 398 1.537% 95.946% ( 870, 1300 ] 342 1.320% 97.266% ( 1300, 1900 ] 256 0.988% 98.255% ( 1900, 2900 ] 182 0.703% 98.958% ( 2900, 4400 ] 208 0.803% 99.761% ( 4400, 6600 ] 42 0.162% 99.923% ( 6600, 9900 ] 13 0.050% 99.973% ( 9900, 14000 ] 4 0.015% 99.988% ( 110000, 170000 ] 2 0.008% 99.996% ( 170000, 250000 ] 1 0.004% 100.000% ** Level 5 read latency histogram (micros): Count: 160 Average: 1768.6688 StdDev: 1672.66 Min: 90 Median: 1085.0000 Max: 7549 Percentiles: P50: 1085.00 P75: 3011.11 P99: 6505.71 P99.9: 7549.00 P99.99: 7549.00 ------------------------------------------------------ ( 76, 110 ] 3 1.875% 1.875% ( 110, 170 ] 10 6.250% 8.125% # ( 170, 250 ] 17 10.625% 18.750% ## ( 250, 380 ] 16 10.000% 28.750% ## ( 380, 580 ] 11 6.875% 35.625% # ( 580, 870 ] 15 9.375% 45.000% ## ( 870, 1300 ] 16 10.000% 55.000% ## ( 1300, 1900 ] 7 4.375% 59.375% # ( 1900, 2900 ] 23 14.375% 73.750% ### ( 2900, 4400 ] 27 16.875% 90.625% ### ( 4400, 6600 ] 14 8.750% 99.375% ## ( 6600, 9900 ] 1 0.625% 100.000% ** DB Stats ** Uptime(secs): 34.4 total, 3.3 interval Cumulative writes: 0 writes, 8000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 7.69 GB, 228.71 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:12.175 H:M:S, 35.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 298.01 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.610 H:M:S, 18.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/20-12:42:40 ... thread 0: (1000000,9000000) ops and (349838.1,242792.8) ops/second in (2.858465,37.068649) 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.73 GB 220.2 8.4 0.0 8.4 16.9 8.5 0.0 2.0 140.1 281.0 61.59 55.18 148 0.416 8761K 14K 0.0 0.0 L1 7/7 853.86 MB 0.0 4.0 3.6 0.5 4.0 3.5 0.2 1.1 220.6 218.4 18.76 17.97 3 6.252 4202K 42K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.2 0.1 0.1 0.2 0.1 2.7 1.5 241.2 241.1 0.80 0.76 2 0.400 195K 70 0.0 0.0 L3 22/0 977.74 MB 1.0 5.2 2.7 2.5 5.2 2.7 0.3 1.9 170.6 169.9 31.42 24.19 18 1.745 5444K 23K 0.0 0.0 L4 181/0 9.63 GB 1.0 2.1 2.0 0.1 2.1 2.0 0.7 1.0 123.0 122.8 17.65 10.51 35 0.504 2150K 1744 0.0 0.0 L5 1076/0 88.40 GB 0.9 0.0 0.0 0.0 0.0 0.0 2.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1305/16 104.54 GB 0.0 20.0 8.4 11.6 28.4 16.8 6.6 3.3 157.4 223.5 130.21 108.61 206 0.632 20M 82K 0.0 0.0 Int 0/0 0.00 KB 0.0 20.0 8.4 11.6 28.4 16.8 6.5 3.3 157.4 223.5 130.21 108.61 206 0.632 20M 82K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 20.0 8.4 11.6 19.9 8.3 0.0 0.0 199.1 198.3 102.89 86.65 84 1.225 20M 82K 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 318.2 27.32 21.96 122 0.224 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.3 total, 37.1 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: 28.42 GB write, 780.49 MB/s write, 20.01 GB read, 549.58 MB/s read, 130.2 seconds Interval compaction: 28.42 GB write, 784.97 MB/s write, 20.01 GB read, 552.74 MB/s read, 130.2 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 13, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 13, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 58, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 13, total-stops: 58, interval: 71 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3661249 Average: 2.6502 StdDev: 104.66 Min: 0 Median: 1.5648 Max: 195807 Percentiles: P50: 1.56 P75: 1.95 P99: 6.74 P99.9: 13.81 P99.99: 163.41 ------------------------------------------------------ [ 0, 1 ] 474561 12.962% 12.962% ### ( 1, 2 ] 2401098 65.581% 78.543% ############# ( 2, 3 ] 451463 12.331% 90.874% ## ( 3, 4 ] 157758 4.309% 95.183% # ( 4, 6 ] 133240 3.639% 98.822% # ( 6, 10 ] 35362 0.966% 99.788% ( 10, 15 ] 5385 0.147% 99.935% ( 15, 22 ] 488 0.013% 99.948% ( 22, 34 ] 58 0.002% 99.950% ( 34, 51 ] 17 0.000% 99.950% ( 51, 76 ] 20 0.001% 99.951% ( 76, 110 ] 663 0.018% 99.969% ( 110, 170 ] 866 0.024% 99.993% ( 170, 250 ] 403 0.011% 100.004% ( 250, 380 ] 233 0.006% 100.010% ( 380, 580 ] 286 0.008% 100.018% ( 580, 870 ] 199 0.005% 100.023% ( 870, 1300 ] 139 0.004% 100.027% ( 1300, 1900 ] 50 0.001% 100.028% ( 1900, 2900 ] 48 0.001% 100.030% ( 2900, 4400 ] 50 0.001% 100.031% ( 4400, 6600 ] 13 0.000% 100.031% ( 6600, 9900 ] 1 0.000% 100.031% ( 170000, 250000 ] 1 0.000% 100.031% ** Level 1 read latency histogram (micros): Count: 847063 Average: 5.1718 StdDev: 173.54 Min: 1 Median: 1.7956 Max: 144019 Percentiles: P50: 1.80 P75: 2.69 P99: 9.42 P99.9: 164.40 P99.99: 585.71 ------------------------------------------------------ [ 0, 1 ] 47445 5.601% 5.601% # ( 1, 2 ] 472728 55.808% 61.409% ########### ( 2, 3 ] 166084 19.607% 81.016% #### ( 3, 4 ] 65699 7.756% 88.772% ## ( 4, 6 ] 70968 8.378% 97.150% ## ( 6, 10 ] 18302 2.161% 99.311% ( 10, 15 ] 4062 0.480% 99.790% ( 15, 22 ] 405 0.048% 99.838% ( 22, 34 ] 38 0.004% 99.843% ( 34, 51 ] 16 0.002% 99.845% ( 51, 76 ] 7 0.001% 99.845% ( 76, 110 ] 160 0.019% 99.864% ( 110, 170 ] 333 0.039% 99.904% ( 170, 250 ] 196 0.023% 99.927% ( 250, 380 ] 234 0.028% 99.954% ( 380, 580 ] 296 0.035% 99.989% ( 580, 870 ] 269 0.032% 100.021% ( 870, 1300 ] 194 0.023% 100.044% ( 1300, 1900 ] 102 0.012% 100.056% ( 1900, 2900 ] 131 0.015% 100.072% ( 2900, 4400 ] 122 0.014% 100.086% ( 4400, 6600 ] 41 0.005% 100.091% ( 6600, 9900 ] 10 0.001% 100.092% ( 9900, 14000 ] 1 0.000% 100.092% ( 110000, 170000 ] 1 0.000% 100.092% ** Level 2 read latency histogram (micros): Count: 77242 Average: 3.2559 StdDev: 56.61 Min: 1 Median: 1.5603 Max: 9295 Percentiles: P50: 1.56 P75: 1.94 P99: 7.73 P99.9: 168.59 P99.99: 1382.74 ------------------------------------------------------ [ 0, 1 ] 9890 12.804% 12.804% ### ( 1, 2 ] 51277 66.385% 79.189% ############# ( 2, 3 ] 8356 10.818% 90.007% ## ( 3, 4 ] 3721 4.817% 94.824% # ( 4, 6 ] 2852 3.692% 98.516% # ( 6, 10 ] 863 1.117% 99.634% ( 10, 15 ] 120 0.155% 99.789% ( 15, 22 ] 18 0.023% 99.812% ( 22, 34 ] 4 0.005% 99.817% ( 76, 110 ] 12 0.016% 99.833% ( 110, 170 ] 53 0.069% 99.902% ( 170, 250 ] 21 0.027% 99.929% ( 250, 380 ] 17 0.022% 99.951% ( 380, 580 ] 18 0.023% 99.974% ( 580, 870 ] 8 0.010% 99.984% ( 870, 1300 ] 4 0.005% 99.990% ( 1300, 1900 ] 2 0.003% 99.992% ( 1900, 2900 ] 1 0.001% 99.994% ( 2900, 4400 ] 3 0.004% 99.997% ( 4400, 6600 ] 1 0.001% 99.999% ( 6600, 9900 ] 2 0.003% 100.001% ** Level 3 read latency histogram (micros): Count: 1107330 Average: 6.0204 StdDev: 337.67 Min: 0 Median: 1.9294 Max: 200714 Percentiles: P50: 1.93 P75: 2.94 P99: 9.55 P99.9: 178.94 P99.99: 532.39 ------------------------------------------------------ [ 0, 1 ] 39206 3.541% 3.541% # ( 1, 2 ] 553529 49.988% 53.528% ########## ( 2, 3 ] 252074 22.764% 76.292% ##### ( 3, 4 ] 107877 9.742% 86.035% ## ( 4, 6 ] 120984 10.926% 96.960% ## ( 6, 10 ] 25445 2.298% 99.258% ( 10, 15 ] 5582 0.504% 99.762% ( 15, 22 ] 601 0.054% 99.816% ( 22, 34 ] 66 0.006% 99.822% ( 34, 51 ] 26 0.002% 99.825% ( 51, 76 ] 14 0.001% 99.826% ( 76, 110 ] 248 0.022% 99.848% ( 110, 170 ] 530 0.048% 99.896% ( 170, 250 ] 364 0.033% 99.929% ( 250, 380 ] 354 0.032% 99.961% ( 380, 580 ] 419 0.038% 99.999% ( 580, 870 ] 408 0.037% 100.036% ( 870, 1300 ] 257 0.023% 100.059% ( 1300, 1900 ] 176 0.016% 100.075% ( 1900, 2900 ] 188 0.017% 100.092% ( 2900, 4400 ] 181 0.016% 100.108% ( 4400, 6600 ] 44 0.004% 100.112% ( 6600, 9900 ] 17 0.002% 100.114% ( 9900, 14000 ] 5 0.000% 100.114% ( 170000, 250000 ] 3 0.000% 100.115% ** Level 4 read latency histogram (micros): Count: 25900 Average: 131.9659 StdDev: 1852.95 Min: 1 Median: 2.1767 Max: 201746 Percentiles: P50: 2.18 P75: 3.59 P99: 2979.33 P99.9: 6290.95 P99.99: 122300.00 ------------------------------------------------------ [ 0, 1 ] 675 2.606% 2.606% # ( 1, 2 ] 11262 43.483% 46.089% ######### ( 2, 3 ] 5734 22.139% 68.228% #### ( 3, 4 ] 2964 11.444% 79.672% ## ( 4, 6 ] 2147 8.290% 87.961% ## ( 6, 10 ] 573 2.212% 90.174% ( 10, 15 ] 241 0.931% 91.104% ( 15, 22 ] 22 0.085% 91.189% ( 76, 110 ] 7 0.027% 91.216% ( 110, 170 ] 96 0.371% 91.587% ( 170, 250 ] 159 0.614% 92.201% ( 250, 380 ] 238 0.919% 93.120% ( 380, 580 ] 334 1.290% 94.409% ( 580, 870 ] 398 1.537% 95.946% ( 870, 1300 ] 342 1.320% 97.266% ( 1300, 1900 ] 256 0.988% 98.255% ( 1900, 2900 ] 182 0.703% 98.958% ( 2900, 4400 ] 208 0.803% 99.761% ( 4400, 6600 ] 42 0.162% 99.923% ( 6600, 9900 ] 13 0.050% 99.973% ( 9900, 14000 ] 4 0.015% 99.988% ( 110000, 170000 ] 2 0.008% 99.996% ( 170000, 250000 ] 1 0.004% 100.000% ** Level 5 read latency histogram (micros): Count: 160 Average: 1768.6688 StdDev: 1672.66 Min: 90 Median: 1085.0000 Max: 7549 Percentiles: P50: 1085.00 P75: 3011.11 P99: 6505.71 P99.9: 7549.00 P99.99: 7549.00 ------------------------------------------------------ ( 76, 110 ] 3 1.875% 1.875% ( 110, 170 ] 10 6.250% 8.125% # ( 170, 250 ] 17 10.625% 18.750% ## ( 250, 380 ] 16 10.000% 28.750% ## ( 380, 580 ] 11 6.875% 35.625% # ( 580, 870 ] 15 9.375% 45.000% ## ( 870, 1300 ] 16 10.000% 55.000% ## ( 1300, 1900 ] 7 4.375% 59.375% # ( 1900, 2900 ] 23 14.375% 73.750% ### ( 2900, 4400 ] 27 16.875% 90.625% ### ( 4400, 6600 ] 14 8.750% 99.375% ## ( 6600, 9900 ] 1 0.625% 100.000% ** DB Stats ** Uptime(secs): 37.3 total, 2.9 interval Cumulative writes: 0 writes, 9000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 8.65 GB, 237.58 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:12.388 H:M:S, 33.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 344.38 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.212 H:M:S, 7.4 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.052 micros/op 165228 ops/sec 60.147 seconds 9937999 operations; 160.1 MB/s Microseconds per write: Count: 9937999 Average: 6.0522 StdDev: 473.69 Min: 0 Median: 1.7668 Max: 862378 Percentiles: P50: 1.77 P75: 2.80 P99: 9.67 P99.9: 1164.25 P99.99: 2722.90 ------------------------------------------------------ [ 0, 1 ] 1148901 11.561% 11.561% ## ( 1, 2 ] 4981666 50.127% 61.688% ########## ( 2, 3 ] 1647681 16.580% 78.268% ### ( 3, 4 ] 1379331 13.879% 92.147% ### ( 4, 6 ] 557857 5.613% 97.760% # ( 6, 10 ] 134240 1.351% 99.111% ( 10, 15 ] 46797 0.471% 99.582% ( 15, 22 ] 9643 0.097% 99.679% ( 22, 34 ] 1636 0.016% 99.696% ( 34, 51 ] 218 0.002% 99.698% ( 51, 76 ] 28 0.000% 99.698% ( 76, 110 ] 6878 0.069% 99.767% ( 110, 170 ] 2720 0.027% 99.795% ( 170, 250 ] 276 0.003% 99.797% ( 250, 380 ] 207 0.002% 99.800% ( 380, 580 ] 37 0.000% 99.800% ( 580, 870 ] 22 0.000% 99.800% ( 870, 1300 ] 14501 0.146% 99.946% ( 1300, 1900 ] 46 0.000% 99.947% ( 1900, 2900 ] 5250 0.053% 99.999% ( 2900, 4400 ] 32 0.000% 100.000% ( 4400, 6600 ] 5 0.000% 100.000% ( 6600, 9900 ] 2 0.000% 100.000% ( 9900, 14000 ] 2 0.000% 100.000% ( 22000, 33000 ] 1 0.000% 100.000% ( 33000, 50000 ] 1 0.000% 100.000% ( 75000, 110000 ] 2 0.000% 100.000% ( 110000, 170000 ] 1 0.000% 100.000% ( 170000, 250000 ] 14 0.000% 100.000% ( 380000, 570000 ] 2 0.000% 100.000% ( 570000, 860000 ] 1 0.000% 100.000% ( 860000, 1200000 ] 1 0.000% 100.000% STATISTICS: rocksdb.block.cache.miss COUNT : 0 rocksdb.block.cache.hit COUNT : 0 rocksdb.block.cache.add COUNT : 0 rocksdb.block.cache.add.failures COUNT : 0 rocksdb.block.cache.index.miss COUNT : 0 rocksdb.block.cache.index.hit COUNT : 0 rocksdb.block.cache.index.add COUNT : 0 rocksdb.block.cache.index.bytes.insert COUNT : 0 rocksdb.block.cache.filter.miss COUNT : 0 rocksdb.block.cache.filter.hit COUNT : 0 rocksdb.block.cache.filter.add COUNT : 0 rocksdb.block.cache.filter.bytes.insert COUNT : 0 rocksdb.block.cache.data.miss COUNT : 0 rocksdb.block.cache.data.hit COUNT : 0 rocksdb.block.cache.data.add COUNT : 0 rocksdb.block.cache.data.bytes.insert COUNT : 0 rocksdb.block.cache.bytes.read COUNT : 0 rocksdb.block.cache.bytes.write COUNT : 0 rocksdb.bloom.filter.useful COUNT : 0 rocksdb.bloom.filter.full.positive COUNT : 0 rocksdb.bloom.filter.full.true.positive COUNT : 0 rocksdb.persistent.cache.hit COUNT : 0 rocksdb.persistent.cache.miss COUNT : 0 rocksdb.sim.block.cache.hit COUNT : 0 rocksdb.sim.block.cache.miss COUNT : 0 rocksdb.memtable.hit COUNT : 0 rocksdb.memtable.miss COUNT : 0 rocksdb.l0.hit COUNT : 0 rocksdb.l1.hit COUNT : 0 rocksdb.l2andup.hit COUNT : 0 rocksdb.compaction.key.drop.new COUNT : 202735 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 : 9937999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 10256014968 rocksdb.bytes.read COUNT : 0 rocksdb.number.db.seek COUNT : 0 rocksdb.number.db.next COUNT : 0 rocksdb.number.db.prev COUNT : 0 rocksdb.number.db.seek.found COUNT : 0 rocksdb.number.db.next.found COUNT : 0 rocksdb.number.db.prev.found COUNT : 0 rocksdb.db.iter.bytes.read COUNT : 0 rocksdb.no.file.opens COUNT : 538 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 32113274 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 : 30975713426 rocksdb.compact.write.bytes COUNT : 30785087231 rocksdb.flush.write.bytes COUNT : 10238861435 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 : 49 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 : 299 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 : 10156357632 rocksdb.memtable.garbage.bytes.at.flush COUNT : 3993600 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 : 31065164485 rocksdb.non.last.level.read.count COUNT : 7508203 rocksdb.block.checksum.compute.count COUNT : 7507176 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.414353 P95 : 3.949919 P99 : 8.248056 P100 : 862376.000000 COUNT : 9937999 SUM : 55244222 rocksdb.compaction.times.micros P50 : 876190.476190 P95 : 3366666.666667 P99 : 14000000.000000 P100 : 15251202.000000 COUNT : 100 SUM : 127846312 rocksdb.compaction.times.cpu_micros P50 : 871724.137931 P95 : 3366666.666667 P99 : 14000000.000000 P100 : 14083773.000000 COUNT : 100 SUM : 109219976 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 : 731.214286 P95 : 4565.000000 P99 : 43710.000000 P100 : 146711.000000 COUNT : 137 SUM : 323625 rocksdb.compaction.outfile.sync.micros P50 : 1100.357143 P95 : 28359.375000 P99 : 63281.250000 P100 : 73268.000000 COUNT : 375 SUM : 2078981 rocksdb.wal.file.sync.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.manifest.file.sync.micros P50 : 115.675676 P95 : 1705.000000 P99 : 4002.500000 P100 : 5088.000000 COUNT : 259 SUM : 98583 rocksdb.table.open.io.micros P50 : 1407.692308 P95 : 10351.000000 P99 : 28182.000000 P100 : 202149.000000 COUNT : 538 SUM : 1578509 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.658889 P95 : 7.891492 P99 : 11.538503 P100 : 200720.000000 COUNT : 7505521 SUM : 45477134 rocksdb.read.block.get.micros P50 : 458.832117 P95 : 4292.452830 P99 : 9013.714286 P100 : 201771.000000 COUNT : 1076 SUM : 1303674 rocksdb.write.raw.block.micros P50 : 0.512951 P95 : 0.974606 P99 : 2.892098 P100 : 199295.000000 COUNT : 9935562 SUM : 20852003 rocksdb.numfiles.in.singlecompaction P50 : 2.611111 P95 : 4.650000 P99 : 20.110000 P100 : 36.000000 COUNT : 127 SUM : 448 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.561298 P95 : 1186.552309 P99 : 2557.533410 P100 : 862185.000000 COUNT : 182084 SUM : 32134043 rocksdb.sst.read.micros P50 : 1.600601 P95 : 4.753588 P99 : 8.615622 P100 : 201746.000000 COUNT : 7508220 SUM : 30512086 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 : 9937999 SUM : 10256014968 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 : 212978.723404 P95 : 374184.210526 P99 : 806350.000000 P100 : 1028481.000000 COUNT : 137 SUM : 30539344 rocksdb.sst.batch.size P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.num.index.and.filter.blocks.read.per.level P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.num.sst.read.per.level P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.error.handler.autoresume.retry.count P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.async.read.bytes P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.poll.wait.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.prefetched.bytes.discarded P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 343 SUM : 0 rocksdb.multiget.io.batch.size P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.num.level.read.per.multiget P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.async.prefetch.abort.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.table.open.prefetch.tail.read.bytes P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0