[2024-12-13 06:17:38.886711] Starting SPDK v25.01-pre git sha1 e01cb43b8 / DPDK 23.11.0 initialization... [2024-12-13 06:17:38.886977] [ DPDK EAL parameters: rocksdb --no-shconf -c 0x1 --huge-unlink --no-telemetry --log-level=lib.eal:6 --log-level=lib.cryptodev:5 --log-level=lib.power:5 --log-level=user1:6 --base-virtaddr=0x200000000000 --match-allocations --file-prefix=spdk_pid431007 ] Set seed to 1734067058880041 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-12-13 06:17:39.017184] app.c: 919:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-12-13 06:17:39.040517] app.c: 612:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-12-13 06:17:39.040560] app.c: 613:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 431007' to capture a snapshot of events at runtime. [2024-12-13 06:17:39.040571] app.c: 618:app_setup_trace: *NOTICE*: 'spdk_trace' without parameters will also work if this is the only [2024-12-13 06:17:39.040581] app.c: 619:app_setup_trace: *NOTICE*: SPDK application currently running. [2024-12-13 06:17:39.040589] app.c: 620:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid431007 for offline analysis/debug. [2024-12-13 06:17:39.041149] reactor.c: 995:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Fri Dec 13 06:17:43 2024 CPU: 96 * Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz CPUCache: 36608 KB 2024/12/13-06:17:46 ... thread 0: (1000000,1000000) ops and (329814.3,329814.3) ops/second in (3.032009,3.032009) 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 692.99 MB 6.3 0.0 0.0 0.0 0.9 0.9 0.0 1.0 0.0 346.9 2.54 2.31 12 0.212 0 0 0.0 0.0 L2 3/2 237.16 MB 0.5 0.3 0.2 0.2 0.3 0.2 0.0 1.8 247.4 247.3 1.41 1.36 2 0.705 354K 170 0.0 0.0 L3 8/0 692.94 MB 0.7 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 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.88 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 1181/11 97.00 GB 0.0 0.3 0.2 0.2 1.2 1.0 0.0 1.4 88.2 311.4 3.95 3.66 14 0.282 354K 170 0.0 0.0 Int 0/0 0.00 KB 0.0 0.3 0.2 0.2 1.2 1.0 0.0 1.4 88.2 311.4 3.95 3.66 14 0.282 354K 170 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.3 0.2 0.2 0.3 0.2 0.0 0.0 247.4 247.3 1.41 1.36 2 0.705 354K 170 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 0.9 0.9 0.0 0.0 0.0 346.9 2.54 2.31 12 0.212 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.3 total, 3.0 interval Flush(GB): cumulative 0.861, interval 0.861 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 1.20 GB write, 377.60 MB/s write, 0.34 GB read, 107.00 MB/s read, 4.0 seconds Interval compaction: 1.20 GB write, 405.66 MB/s write, 0.34 GB read, 114.95 MB/s read, 4.0 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 2, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 2, interval: 2 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 136401 Average: 1.9866 StdDev: 14.94 Min: 0 Median: 1.3130 Max: 3664 Percentiles: P50: 1.31 P75: 1.74 P99: 5.20 P99.9: 9.91 P99.99: 18.90 ------------------------------------------------------ [ 0, 1 ] 43400 31.818% 31.818% ###### ( 1, 2 ] 79244 58.096% 89.914% ############ ( 2, 3 ] 7973 5.845% 95.760% # ( 3, 4 ] 3331 2.442% 98.202% ( 4, 6 ] 1822 1.336% 99.537% ( 6, 10 ] 508 0.372% 99.910% ( 10, 15 ] 103 0.076% 99.985% ( 15, 22 ] 15 0.011% 99.996% ( 22, 34 ] 2 0.001% 99.998% ( 34, 51 ] 1 0.001% 99.999% ( 51, 76 ] 2 0.001% 100.000% ( 76, 110 ] 1 0.001% 100.001% ( 110, 170 ] 7 0.005% 100.006% ( 170, 250 ] 4 0.003% 100.009% ( 250, 380 ] 4 0.003% 100.012% ( 380, 580 ] 1 0.001% 100.012% ( 580, 870 ] 1 0.001% 100.013% ( 870, 1300 ] 2 0.001% 100.015% ( 1300, 1900 ] 2 0.001% 100.016% ( 1900, 2900 ] 2 0.001% 100.018% ( 2900, 4400 ] 1 0.001% 100.018% ** Level 1 read latency histogram (micros): Count: 12289 Average: 2.9754 StdDev: 32.32 Min: 1 Median: 1.2816 Max: 2438 Percentiles: P50: 1.28 P75: 1.78 P99: 9.55 P99.9: 218.81 P99.99: 2285.55 ------------------------------------------------------ [ 0, 1 ] 4409 35.878% 35.878% ####### ( 1, 2 ] 6162 50.142% 86.020% ########## ( 2, 3 ] 1049 8.536% 94.556% ## ( 3, 4 ] 233 1.896% 96.452% ( 4, 6 ] 203 1.652% 98.104% ( 6, 10 ] 124 1.009% 99.113% ( 10, 15 ] 27 0.220% 99.333% ( 15, 22 ] 8 0.065% 99.398% ( 22, 34 ] 2 0.016% 99.414% ( 34, 51 ] 38 0.309% 99.723% ( 51, 76 ] 7 0.057% 99.780% ( 76, 110 ] 7 0.057% 99.837% ( 110, 170 ] 1 0.008% 99.845% ( 170, 250 ] 11 0.090% 99.935% ( 380, 580 ] 3 0.024% 99.959% ( 580, 870 ] 2 0.016% 99.976% ( 870, 1300 ] 1 0.008% 99.984% ( 1900, 2900 ] 2 0.016% 100.000% ** Level 2 read latency histogram (micros): Count: 69622 Average: 1.9487 StdDev: 4.37 Min: 1 Median: 1.3476 Max: 788 Percentiles: P50: 1.35 P75: 1.76 P99: 5.37 P99.9: 10.04 P99.99: 211.51 ------------------------------------------------------ [ 0, 1 ] 20099 28.869% 28.869% ###### ( 1, 2 ] 42322 60.788% 89.657% ############ ( 2, 3 ] 4052 5.820% 95.477% # ( 3, 4 ] 1753 2.518% 97.995% # ( 4, 6 ] 1028 1.477% 99.471% ( 6, 10 ] 300 0.431% 99.902% ( 10, 15 ] 48 0.069% 99.971% ( 15, 22 ] 5 0.007% 99.978% ( 22, 34 ] 3 0.004% 99.983% ( 34, 51 ] 3 0.004% 99.987% ( 51, 76 ] 1 0.001% 99.989% ( 110, 170 ] 2 0.003% 99.991% ( 170, 250 ] 2 0.003% 99.994% ( 250, 380 ] 5 0.007% 100.001% ( 580, 870 ] 1 0.001% 100.003% ** Level 3 read latency histogram (micros): Count: 40 Average: 1551.9000 StdDev: 1032.56 Min: 356 Median: 1138.7500 Max: 4703 Percentiles: P50: 1138.75 P75: 2300.00 P99: 4703.00 P99.9: 4703.00 P99.99: 4703.00 ------------------------------------------------------ ( 250, 380 ] 1 2.500% 2.500% # ( 380, 580 ] 3 7.500% 10.000% ## ( 580, 870 ] 11 27.500% 37.500% ###### ( 870, 1300 ] 8 20.000% 57.500% #### ( 1300, 1900 ] 3 7.500% 65.000% ## ( 1900, 2900 ] 10 25.000% 90.000% ##### ( 2900, 4400 ] 3 7.500% 97.500% ## ( 4400, 6600 ] 1 2.500% 100.000% # ** Level 4 read latency histogram (micros): Count: 35 Average: 1472.8571 StdDev: 1182.13 Min: 51 Median: 1118.0769 Max: 5547 Percentiles: P50: 1118.08 P75: 1941.67 P99: 5547.00 P99.9: 5547.00 P99.99: 5547.00 ------------------------------------------------------ ( 34, 51 ] 1 2.857% 2.857% # ( 110, 170 ] 1 2.857% 5.714% # ( 170, 250 ] 1 2.857% 8.571% # ( 250, 380 ] 2 5.714% 14.286% # ( 380, 580 ] 1 2.857% 17.143% # ( 580, 870 ] 4 11.429% 28.571% ## ( 870, 1300 ] 13 37.143% 65.714% ####### ( 1300, 1900 ] 3 8.571% 74.286% ## ( 1900, 2900 ] 6 17.143% 91.429% ### ( 2900, 4400 ] 2 5.714% 97.143% # ( 4400, 6600 ] 1 2.857% 100.000% # ** DB Stats ** Uptime(secs): 3.3 total, 3.0 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 301.99 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.433 H:M:S, 13.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 324.35 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.433 H:M:S, 14.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/12/13-06:17:49 ... thread 0: (1000000,2000000) ops and (355108.8,341994.5) ops/second in (2.816038,5.848047) 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/4 1.29 GB 100.7 0.8 0.0 0.8 2.6 1.8 0.0 1.4 98.2 317.0 8.34 7.76 29 0.288 831K 837 0.0 0.0 L1 1/0 2.39 MB 0.2 0.3 0.3 0.0 0.3 0.3 0.2 1.0 244.1 243.7 1.29 1.24 1 1.291 319K 395 0.0 0.0 L2 1/0 49.69 MB 0.5 0.3 0.2 0.2 0.3 0.2 0.4 1.8 247.4 247.3 1.41 1.36 2 0.705 354K 170 0.0 0.0 L3 32/0 972.57 MB 1.0 0.7 0.5 0.2 0.7 0.5 0.0 1.4 194.1 194.0 3.54 3.05 3 1.180 697K 582 0.0 0.0 L4 144/0 9.75 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.2 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1044/0 85.88 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 1232/4 97.92 GB 0.0 2.1 1.0 1.1 3.9 2.8 0.8 2.2 148.8 273.9 14.58 13.41 35 0.417 2203K 1984 0.0 0.0 Int 0/0 0.00 KB 0.0 2.1 1.0 1.1 3.9 2.8 0.8 2.2 148.8 273.9 14.58 13.41 35 0.417 2203K 1984 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 2.1 1.0 1.1 2.1 1.0 0.0 0.0 231.1 230.9 9.39 8.75 9 1.043 2203K 1984 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 351.7 5.19 4.67 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.8 interval Flush(GB): cumulative 1.784, interval 1.784 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 3.90 GB write, 657.60 MB/s write, 2.12 GB read, 357.20 MB/s read, 14.6 seconds Interval compaction: 3.90 GB write, 682.94 MB/s write, 2.12 GB read, 370.96 MB/s read, 14.6 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 5, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 5, interval: 5 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 377726 Average: 2.0740 StdDev: 11.26 Min: 0 Median: 1.3996 Max: 3664 Percentiles: P50: 1.40 P75: 1.81 P99: 5.56 P99.9: 10.82 P99.99: 14.95 ------------------------------------------------------ [ 0, 1 ] 96385 25.517% 25.517% ##### ( 1, 2 ] 231400 61.261% 86.779% ############ ( 2, 3 ] 28315 7.496% 94.275% # ( 3, 4 ] 12514 3.313% 97.588% # ( 4, 6 ] 6852 1.814% 99.402% ( 6, 10 ] 1816 0.481% 99.882% ( 10, 15 ] 411 0.109% 99.991% ( 15, 22 ] 39 0.010% 100.002% ( 22, 34 ] 5 0.001% 100.003% ( 34, 51 ] 3 0.001% 100.004% ( 51, 76 ] 4 0.001% 100.005% ( 76, 110 ] 1 0.000% 100.005% ( 110, 170 ] 14 0.004% 100.009% ( 170, 250 ] 11 0.003% 100.012% ( 250, 380 ] 13 0.003% 100.015% ( 380, 580 ] 2 0.001% 100.016% ( 580, 870 ] 7 0.002% 100.017% ( 870, 1300 ] 4 0.001% 100.019% ( 1300, 1900 ] 2 0.001% 100.019% ( 1900, 2900 ] 4 0.001% 100.020% ( 2900, 4400 ] 1 0.000% 100.020% ** Level 1 read latency histogram (micros): Count: 91551 Average: 2.5299 StdDev: 13.03 Min: 1 Median: 1.6209 Max: 2438 Percentiles: P50: 1.62 P75: 2.09 P99: 6.86 P99.9: 17.81 P99.99: 228.97 ------------------------------------------------------ [ 0, 1 ] 10574 11.550% 11.550% ## ( 1, 2 ] 56690 61.922% 73.472% ############ ( 2, 3 ] 15063 16.453% 89.925% ### ( 3, 4 ] 4442 4.852% 94.777% # ( 4, 6 ] 3694 4.035% 98.812% # ( 6, 10 ] 799 0.873% 99.684% ( 10, 15 ] 187 0.204% 99.889% ( 15, 22 ] 26 0.028% 99.917% ( 22, 34 ] 3 0.003% 99.920% ( 34, 51 ] 40 0.044% 99.964% ( 51, 76 ] 7 0.008% 99.972% ( 76, 110 ] 7 0.008% 99.979% ( 110, 170 ] 1 0.001% 99.980% ( 170, 250 ] 12 0.013% 99.993% ( 250, 380 ] 3 0.003% 99.997% ( 380, 580 ] 4 0.004% 100.001% ( 580, 870 ] 2 0.002% 100.003% ( 870, 1300 ] 1 0.001% 100.004% ( 1300, 1900 ] 1 0.001% 100.005% ( 1900, 2900 ] 2 0.002% 100.008% ** Level 2 read latency histogram (micros): Count: 75886 Average: 1.9840 StdDev: 4.20 Min: 1 Median: 1.3742 Max: 788 Percentiles: P50: 1.37 P75: 1.78 P99: 5.46 P99.9: 10.72 P99.99: 186.46 ------------------------------------------------------ [ 0, 1 ] 20569 27.105% 27.105% ##### ( 1, 2 ] 46435 61.190% 88.296% ############ ( 2, 3 ] 5119 6.746% 95.041% # ( 3, 4 ] 2074 2.733% 97.774% # ( 4, 6 ] 1272 1.676% 99.450% ( 6, 10 ] 332 0.437% 99.888% ( 10, 15 ] 63 0.083% 99.971% ( 15, 22 ] 5 0.007% 99.978% ( 22, 34 ] 3 0.004% 99.982% ( 34, 51 ] 3 0.004% 99.986% ( 51, 76 ] 1 0.001% 99.987% ( 110, 170 ] 2 0.003% 99.989% ( 170, 250 ] 2 0.003% 99.992% ( 250, 380 ] 5 0.007% 99.999% ( 580, 870 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 47931 Average: 3.8706 StdDev: 55.54 Min: 1 Median: 1.6441 Max: 4703 Percentiles: P50: 1.64 P75: 2.13 P99: 7.36 P99.9: 191.38 P99.99: 2646.08 ------------------------------------------------------ [ 0, 1 ] 4197 8.756% 8.756% ## ( 1, 2 ] 30693 64.036% 72.792% ############# ( 2, 3 ] 7971 16.630% 89.422% ### ( 3, 4 ] 2546 5.312% 94.734% # ( 4, 6 ] 1910 3.985% 98.719% # ( 6, 10 ] 397 0.828% 99.547% ( 10, 15 ] 106 0.221% 99.768% ( 15, 22 ] 27 0.056% 99.825% ( 22, 34 ] 28 0.058% 99.883% ( 110, 170 ] 7 0.015% 99.898% ( 170, 250 ] 4 0.008% 99.906% ( 250, 380 ] 3 0.006% 99.912% ( 380, 580 ] 5 0.010% 99.923% ( 580, 870 ] 12 0.025% 99.948% ( 870, 1300 ] 8 0.017% 99.965% ( 1300, 1900 ] 4 0.008% 99.973% ( 1900, 2900 ] 11 0.023% 99.996% ( 2900, 4400 ] 3 0.006% 100.002% ( 4400, 6600 ] 1 0.002% 100.004% ** Level 4 read latency histogram (micros): Count: 35 Average: 1472.8571 StdDev: 1182.13 Min: 51 Median: 1118.0769 Max: 5547 Percentiles: P50: 1118.08 P75: 1941.67 P99: 5547.00 P99.9: 5547.00 P99.99: 5547.00 ------------------------------------------------------ ( 34, 51 ] 1 2.857% 2.857% # ( 110, 170 ] 1 2.857% 5.714% # ( 170, 250 ] 1 2.857% 8.571% # ( 250, 380 ] 2 5.714% 14.286% # ( 380, 580 ] 1 2.857% 17.143% # ( 580, 870 ] 4 11.429% 28.571% ## ( 870, 1300 ] 13 37.143% 65.714% ####### ( 1300, 1900 ] 3 8.571% 74.286% ## ( 1900, 2900 ] 6 17.143% 91.429% ### ( 2900, 4400 ] 2 5.714% 97.143% # ( 4400, 6600 ] 1 2.857% 100.000% # ** DB Stats ** Uptime(secs): 6.1 total, 2.8 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 324.02 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.627 H:M:S, 10.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 349.51 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.193 H:M:S, 6.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/12/13-06:17:52 ... thread 0: (1000000,3000000) ops and (334926.0,339605.4) ops/second in (2.985734,8.833781) 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 12/11 2.27 GB 6.3 1.9 0.0 1.9 4.7 2.8 0.0 1.7 127.4 312.3 15.33 14.37 47 0.326 1982K 2045 0.0 0.0 L1 1/1 2.39 MB 0.0 0.3 0.3 0.0 0.3 0.3 0.2 1.0 244.1 243.7 1.29 1.24 1 1.291 319K 395 0.0 0.0 L2 1/0 49.69 MB 0.5 0.3 0.2 0.2 0.3 0.2 0.4 1.8 247.4 247.3 1.41 1.36 2 0.705 354K 170 0.0 0.0 L3 32/0 972.57 MB 1.0 0.7 0.5 0.2 0.7 0.5 0.0 1.4 194.1 194.0 3.54 3.05 3 1.180 697K 582 0.0 0.0 L4 144/0 9.75 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.2 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1044/0 85.88 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 1234/12 98.90 GB 0.0 3.2 1.0 2.2 6.0 3.7 0.8 2.2 153.2 284.5 21.57 20.02 53 0.407 3354K 3192 0.0 0.0 Int 0/0 0.00 KB 0.0 3.2 1.0 2.2 6.0 3.7 0.8 2.2 153.2 284.5 21.57 20.02 53 0.407 3354K 3192 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 1.0 2.2 3.2 1.0 0.0 0.0 242.4 242.2 13.63 12.90 13 1.048 3354K 3192 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 357.1 7.94 7.12 40 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): 9.1 total, 8.8 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, 677.15 MB/s write, 3.23 GB read, 364.64 MB/s read, 21.6 seconds Interval compaction: 5.99 GB write, 694.43 MB/s write, 3.23 GB read, 373.94 MB/s read, 21.6 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 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: 636517 Average: 2.0014 StdDev: 10.46 Min: 0 Median: 1.3618 Max: 3664 Percentiles: P50: 1.36 P75: 1.77 P99: 5.23 P99.9: 10.00 P99.99: 15.04 ------------------------------------------------------ [ 0, 1 ] 177583 27.899% 27.899% ###### ( 1, 2 ] 388821 61.086% 88.985% ############ ( 2, 3 ] 41151 6.465% 95.450% # ( 3, 4 ] 17243 2.709% 98.159% # ( 4, 6 ] 8721 1.370% 99.529% ( 6, 10 ] 2362 0.371% 99.900% ( 10, 15 ] 573 0.090% 99.990% ( 15, 22 ] 61 0.010% 100.000% ( 22, 34 ] 9 0.001% 100.001% ( 34, 51 ] 5 0.001% 100.002% ( 51, 76 ] 5 0.001% 100.003% ( 76, 110 ] 1 0.000% 100.003% ( 110, 170 ] 22 0.003% 100.006% ( 170, 250 ] 17 0.003% 100.009% ( 250, 380 ] 18 0.003% 100.012% ( 380, 580 ] 3 0.000% 100.012% ( 580, 870 ] 14 0.002% 100.014% ( 870, 1300 ] 12 0.002% 100.016% ( 1300, 1900 ] 2 0.000% 100.017% ( 1900, 2900 ] 4 0.001% 100.017% ( 2900, 4400 ] 2 0.000% 100.018% ** Level 1 read latency histogram (micros): Count: 91552 Average: 2.5300 StdDev: 13.03 Min: 1 Median: 1.6210 Max: 2438 Percentiles: P50: 1.62 P75: 2.09 P99: 6.86 P99.9: 17.81 P99.99: 228.97 ------------------------------------------------------ [ 0, 1 ] 10574 11.550% 11.550% ## ( 1, 2 ] 56690 61.921% 73.471% ############ ( 2, 3 ] 15063 16.453% 89.924% ### ( 3, 4 ] 4442 4.852% 94.776% # ( 4, 6 ] 3695 4.036% 98.812% # ( 6, 10 ] 799 0.873% 99.684% ( 10, 15 ] 187 0.204% 99.889% ( 15, 22 ] 26 0.028% 99.917% ( 22, 34 ] 3 0.003% 99.920% ( 34, 51 ] 40 0.044% 99.964% ( 51, 76 ] 7 0.008% 99.972% ( 76, 110 ] 7 0.008% 99.979% ( 110, 170 ] 1 0.001% 99.980% ( 170, 250 ] 12 0.013% 99.993% ( 250, 380 ] 3 0.003% 99.997% ( 380, 580 ] 4 0.004% 100.001% ( 580, 870 ] 2 0.002% 100.003% ( 870, 1300 ] 1 0.001% 100.004% ( 1300, 1900 ] 1 0.001% 100.005% ( 1900, 2900 ] 2 0.002% 100.008% ** Level 2 read latency histogram (micros): Count: 75886 Average: 1.9840 StdDev: 4.20 Min: 1 Median: 1.3742 Max: 788 Percentiles: P50: 1.37 P75: 1.78 P99: 5.46 P99.9: 10.72 P99.99: 186.46 ------------------------------------------------------ [ 0, 1 ] 20569 27.105% 27.105% ##### ( 1, 2 ] 46435 61.190% 88.296% ############ ( 2, 3 ] 5119 6.746% 95.041% # ( 3, 4 ] 2074 2.733% 97.774% # ( 4, 6 ] 1272 1.676% 99.450% ( 6, 10 ] 332 0.437% 99.888% ( 10, 15 ] 63 0.083% 99.971% ( 15, 22 ] 5 0.007% 99.978% ( 22, 34 ] 3 0.004% 99.982% ( 34, 51 ] 3 0.004% 99.986% ( 51, 76 ] 1 0.001% 99.987% ( 110, 170 ] 2 0.003% 99.989% ( 170, 250 ] 2 0.003% 99.992% ( 250, 380 ] 5 0.007% 99.999% ( 580, 870 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 47931 Average: 3.8706 StdDev: 55.54 Min: 1 Median: 1.6441 Max: 4703 Percentiles: P50: 1.64 P75: 2.13 P99: 7.36 P99.9: 191.38 P99.99: 2646.08 ------------------------------------------------------ [ 0, 1 ] 4197 8.756% 8.756% ## ( 1, 2 ] 30693 64.036% 72.792% ############# ( 2, 3 ] 7971 16.630% 89.422% ### ( 3, 4 ] 2546 5.312% 94.734% # ( 4, 6 ] 1910 3.985% 98.719% # ( 6, 10 ] 397 0.828% 99.547% ( 10, 15 ] 106 0.221% 99.768% ( 15, 22 ] 27 0.056% 99.825% ( 22, 34 ] 28 0.058% 99.883% ( 110, 170 ] 7 0.015% 99.898% ( 170, 250 ] 4 0.008% 99.906% ( 250, 380 ] 3 0.006% 99.912% ( 380, 580 ] 5 0.010% 99.923% ( 580, 870 ] 12 0.025% 99.948% ( 870, 1300 ] 8 0.017% 99.965% ( 1300, 1900 ] 4 0.008% 99.973% ( 1900, 2900 ] 11 0.023% 99.996% ( 2900, 4400 ] 3 0.006% 100.002% ( 4400, 6600 ] 1 0.002% 100.004% ** Level 4 read latency histogram (micros): Count: 35 Average: 1472.8571 StdDev: 1182.13 Min: 51 Median: 1118.0769 Max: 5547 Percentiles: P50: 1118.08 P75: 1941.67 P99: 5547.00 P99.9: 5547.00 P99.99: 5547.00 ------------------------------------------------------ ( 34, 51 ] 1 2.857% 2.857% # ( 110, 170 ] 1 2.857% 5.714% # ( 170, 250 ] 1 2.857% 8.571% # ( 250, 380 ] 2 5.714% 14.286% # ( 380, 580 ] 1 2.857% 17.143% # ( 580, 870 ] 4 11.429% 28.571% ## ( 870, 1300 ] 13 37.143% 65.714% ####### ( 1300, 1900 ] 3 8.571% 74.286% ## ( 1900, 2900 ] 6 17.143% 91.429% ### ( 2900, 4400 ] 2 5.714% 97.143% # ( 4400, 6600 ] 1 2.857% 100.000% # ** DB Stats ** Uptime(secs): 9.1 total, 3.0 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 325.87 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.017 H:M:S, 11.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 329.63 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.390 H:M:S, 13.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/12/13-06:17:55 ... thread 0: (1000000,4000000) ops and (290918.5,325967.3) ops/second in (3.437389,12.271170) 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 21/15 3.32 GB 81.8 2.4 0.0 2.4 6.2 3.8 0.0 1.6 121.0 313.3 20.30 18.95 64 0.317 2494K 2546 0.0 0.0 L1 1/1 2.39 MB 0.0 0.3 0.3 0.0 0.3 0.3 0.2 1.0 244.1 243.7 1.29 1.24 1 1.291 319K 395 0.0 0.0 L2 1/0 49.69 MB 0.5 0.3 0.2 0.2 0.3 0.2 0.4 1.8 247.4 247.3 1.41 1.36 2 0.705 354K 170 0.0 0.0 L3 32/0 972.57 MB 1.0 0.7 0.5 0.2 0.7 0.5 0.0 1.4 194.1 194.0 3.54 3.05 3 1.180 697K 582 0.0 0.0 L4 144/0 9.75 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.2 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1044/0 85.88 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 1243/16 99.95 GB 0.0 3.7 1.0 2.7 7.5 4.8 0.8 2.0 143.5 290.5 26.54 24.61 70 0.379 3866K 3693 0.0 0.0 Int 0/0 0.00 KB 0.0 3.7 1.0 2.7 7.5 4.8 0.8 2.0 143.5 290.5 26.54 24.61 70 0.379 3866K 3693 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.7 1.0 2.7 3.7 1.0 0.0 0.0 245.1 244.9 15.54 14.77 15 1.036 3866K 3693 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 355.0 11.00 9.84 55 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): 12.5 total, 12.3 interval Flush(GB): cumulative 3.814, interval 3.814 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 7.53 GB write, 616.86 MB/s write, 3.72 GB read, 304.66 MB/s read, 26.5 seconds Interval compaction: 7.53 GB write, 628.19 MB/s write, 3.72 GB read, 310.26 MB/s read, 26.5 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: 12, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 3, total-stops: 12, interval: 15 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1016493 Average: 2.0388 StdDev: 10.76 Min: 0 Median: 1.3925 Max: 4093 Percentiles: P50: 1.39 P75: 1.79 P99: 5.19 P99.9: 10.12 P99.99: 16.89 ------------------------------------------------------ [ 0, 1 ] 255127 25.099% 25.099% ##### ( 1, 2 ] 644877 63.441% 88.540% ############# ( 2, 3 ] 71247 7.009% 95.549% # ( 3, 4 ] 27294 2.685% 98.234% # ( 4, 6 ] 13065 1.285% 99.520% ( 6, 10 ] 3848 0.379% 99.898% ( 10, 15 ] 913 0.090% 99.988% ( 15, 22 ] 90 0.009% 99.997% ( 22, 34 ] 10 0.001% 99.998% ( 34, 51 ] 9 0.001% 99.999% ( 51, 76 ] 8 0.001% 100.000% ( 76, 110 ] 5 0.000% 100.000% ( 110, 170 ] 69 0.007% 100.007% ( 170, 250 ] 28 0.003% 100.010% ( 250, 380 ] 35 0.003% 100.013% ( 380, 580 ] 10 0.001% 100.014% ( 580, 870 ] 20 0.002% 100.016% ( 870, 1300 ] 16 0.002% 100.018% ( 1300, 1900 ] 5 0.000% 100.018% ( 1900, 2900 ] 6 0.001% 100.019% ( 2900, 4400 ] 3 0.000% 100.019% ** Level 1 read latency histogram (micros): Count: 91552 Average: 2.5300 StdDev: 13.03 Min: 1 Median: 1.6210 Max: 2438 Percentiles: P50: 1.62 P75: 2.09 P99: 6.86 P99.9: 17.81 P99.99: 228.97 ------------------------------------------------------ [ 0, 1 ] 10574 11.550% 11.550% ## ( 1, 2 ] 56690 61.921% 73.471% ############ ( 2, 3 ] 15063 16.453% 89.924% ### ( 3, 4 ] 4442 4.852% 94.776% # ( 4, 6 ] 3695 4.036% 98.812% # ( 6, 10 ] 799 0.873% 99.684% ( 10, 15 ] 187 0.204% 99.889% ( 15, 22 ] 26 0.028% 99.917% ( 22, 34 ] 3 0.003% 99.920% ( 34, 51 ] 40 0.044% 99.964% ( 51, 76 ] 7 0.008% 99.972% ( 76, 110 ] 7 0.008% 99.979% ( 110, 170 ] 1 0.001% 99.980% ( 170, 250 ] 12 0.013% 99.993% ( 250, 380 ] 3 0.003% 99.997% ( 380, 580 ] 4 0.004% 100.001% ( 580, 870 ] 2 0.002% 100.003% ( 870, 1300 ] 1 0.001% 100.004% ( 1300, 1900 ] 1 0.001% 100.005% ( 1900, 2900 ] 2 0.002% 100.008% ** Level 2 read latency histogram (micros): Count: 75886 Average: 1.9840 StdDev: 4.20 Min: 1 Median: 1.3742 Max: 788 Percentiles: P50: 1.37 P75: 1.78 P99: 5.46 P99.9: 10.72 P99.99: 186.46 ------------------------------------------------------ [ 0, 1 ] 20569 27.105% 27.105% ##### ( 1, 2 ] 46435 61.190% 88.296% ############ ( 2, 3 ] 5119 6.746% 95.041% # ( 3, 4 ] 2074 2.733% 97.774% # ( 4, 6 ] 1272 1.676% 99.450% ( 6, 10 ] 332 0.437% 99.888% ( 10, 15 ] 63 0.083% 99.971% ( 15, 22 ] 5 0.007% 99.978% ( 22, 34 ] 3 0.004% 99.982% ( 34, 51 ] 3 0.004% 99.986% ( 51, 76 ] 1 0.001% 99.987% ( 110, 170 ] 2 0.003% 99.989% ( 170, 250 ] 2 0.003% 99.992% ( 250, 380 ] 5 0.007% 99.999% ( 580, 870 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 47931 Average: 3.8706 StdDev: 55.54 Min: 1 Median: 1.6441 Max: 4703 Percentiles: P50: 1.64 P75: 2.13 P99: 7.36 P99.9: 191.38 P99.99: 2646.08 ------------------------------------------------------ [ 0, 1 ] 4197 8.756% 8.756% ## ( 1, 2 ] 30693 64.036% 72.792% ############# ( 2, 3 ] 7971 16.630% 89.422% ### ( 3, 4 ] 2546 5.312% 94.734% # ( 4, 6 ] 1910 3.985% 98.719% # ( 6, 10 ] 397 0.828% 99.547% ( 10, 15 ] 106 0.221% 99.768% ( 15, 22 ] 27 0.056% 99.825% ( 22, 34 ] 28 0.058% 99.883% ( 110, 170 ] 7 0.015% 99.898% ( 170, 250 ] 4 0.008% 99.906% ( 250, 380 ] 3 0.006% 99.912% ( 380, 580 ] 5 0.010% 99.923% ( 580, 870 ] 12 0.025% 99.948% ( 870, 1300 ] 8 0.017% 99.965% ( 1300, 1900 ] 4 0.008% 99.973% ( 1900, 2900 ] 11 0.023% 99.996% ( 2900, 4400 ] 3 0.006% 100.002% ( 4400, 6600 ] 1 0.002% 100.004% ** Level 4 read latency histogram (micros): Count: 35 Average: 1472.8571 StdDev: 1182.13 Min: 51 Median: 1118.0769 Max: 5547 Percentiles: P50: 1118.08 P75: 1941.67 P99: 5547.00 P99.9: 5547.00 P99.99: 5547.00 ------------------------------------------------------ ( 34, 51 ] 1 2.857% 2.857% # ( 110, 170 ] 1 2.857% 5.714% # ( 170, 250 ] 1 2.857% 8.571% # ( 250, 380 ] 2 5.714% 14.286% # ( 380, 580 ] 1 2.857% 17.143% # ( 580, 870 ] 4 11.429% 28.571% ## ( 870, 1300 ] 13 37.143% 65.714% ####### ( 1300, 1900 ] 3 8.571% 74.286% ## ( 1900, 2900 ] 6 17.143% 91.429% ### ( 2900, 4400 ] 2 5.714% 97.143% # ( 4400, 6600 ] 1 2.857% 100.000% # ** DB Stats ** Uptime(secs): 12.5 total, 3.4 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 314.97 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.801 H:M:S, 14.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 286.24 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.784 H:M:S, 22.8 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 0 2024/12/13-06:18:02 ... thread 0: (1000000,5000000) ops and (146991.5,262133.0) ops/second in (6.803115,19.074285) 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 12/10 1.97 GB 31.5 3.4 0.0 3.4 8.1 4.7 0.0 1.7 131.1 308.8 26.92 25.12 82 0.328 3582K 3651 0.0 0.0 L1 3/0 183.82 MB 18.4 2.5 2.5 0.0 2.5 2.5 0.2 1.0 233.1 231.0 11.08 10.72 2 5.540 2622K 23K 0.0 0.0 L2 10/6 1.18 GB 5.2 0.3 0.2 0.2 0.3 0.2 2.4 1.8 247.4 247.3 1.41 1.36 2 0.705 354K 170 0.0 0.0 L3 32/15 1.78 GB 1.0 0.7 0.5 0.2 0.7 0.5 0.9 1.4 194.1 194.0 3.54 3.05 3 1.180 697K 582 0.0 0.0 L4 147/0 9.50 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1048/0 86.19 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1252/31 100.78 GB 0.0 7.0 3.2 3.8 11.6 7.8 4.0 2.5 166.4 277.2 42.94 40.26 89 0.483 7256K 28K 0.0 0.0 Int 0/0 0.00 KB 0.0 7.0 3.2 3.8 11.6 7.8 4.0 2.5 166.4 277.2 42.94 40.26 89 0.483 7256K 28K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 7.0 3.2 3.8 7.0 3.2 0.0 0.0 243.9 242.9 29.30 28.17 20 1.465 7256K 28K 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 350.9 13.64 12.09 69 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): 19.3 total, 19.1 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.63 GB write, 616.85 MB/s write, 6.98 GB read, 370.29 MB/s read, 42.9 seconds Interval compaction: 11.63 GB write, 624.14 MB/s write, 6.98 GB read, 374.66 MB/s read, 42.9 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 11, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 11, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 12, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 11, total-stops: 12, interval: 23 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1759252 Average: 2.1140 StdDev: 11.20 Min: 0 Median: 1.4150 Max: 4093 Percentiles: P50: 1.42 P75: 1.80 P99: 5.51 P99.9: 11.50 P99.99: 129.17 ------------------------------------------------------ [ 0, 1 ] 407472 23.162% 23.162% ##### ( 1, 2 ] 1137649 64.667% 87.828% ############# ( 2, 3 ] 125856 7.154% 94.982% # ( 3, 4 ] 51154 2.908% 97.890% # ( 4, 6 ] 25834 1.468% 99.358% ( 6, 10 ] 9049 0.514% 99.873% ( 10, 15 ] 1607 0.091% 99.964% ( 15, 22 ] 176 0.010% 99.974% ( 22, 34 ] 17 0.001% 99.975% ( 34, 51 ] 12 0.001% 99.976% ( 51, 76 ] 10 0.001% 99.976% ( 76, 110 ] 144 0.008% 99.985% ( 110, 170 ] 307 0.017% 100.002% ( 170, 250 ] 93 0.005% 100.007% ( 250, 380 ] 79 0.004% 100.012% ( 380, 580 ] 38 0.002% 100.014% ( 580, 870 ] 41 0.002% 100.016% ( 870, 1300 ] 25 0.001% 100.018% ( 1300, 1900 ] 8 0.000% 100.018% ( 1900, 2900 ] 8 0.000% 100.019% ( 2900, 4400 ] 7 0.000% 100.019% ** Level 1 read latency histogram (micros): Count: 164812 Average: 2.9433 StdDev: 20.28 Min: 0 Median: 1.7357 Max: 4016 Percentiles: P50: 1.74 P75: 2.50 P99: 7.53 P99.9: 14.73 P99.99: 97.18 ------------------------------------------------------ [ 0, 1 ] 12133 7.362% 7.362% # ( 1, 2 ] 95525 57.960% 65.322% ############ ( 2, 3 ] 31752 19.266% 84.587% #### ( 3, 4 ] 12369 7.505% 92.092% ## ( 4, 6 ] 10676 6.478% 98.570% # ( 6, 10 ] 1859 1.128% 99.698% ( 10, 15 ] 353 0.214% 99.912% ( 15, 22 ] 49 0.030% 99.942% ( 22, 34 ] 3 0.002% 99.944% ( 34, 51 ] 40 0.024% 99.968% ( 51, 76 ] 7 0.004% 99.972% ( 76, 110 ] 49 0.030% 100.002% ( 110, 170 ] 7 0.004% 100.006% ( 170, 250 ] 20 0.012% 100.018% ( 250, 380 ] 8 0.005% 100.023% ( 380, 580 ] 21 0.013% 100.036% ( 580, 870 ] 12 0.007% 100.043% ( 870, 1300 ] 10 0.006% 100.049% ( 1300, 1900 ] 5 0.003% 100.052% ( 1900, 2900 ] 3 0.002% 100.054% ( 2900, 4400 ] 1 0.001% 100.055% ** Level 2 read latency histogram (micros): Count: 75950 Average: 2.3652 StdDev: 15.91 Min: 1 Median: 1.3748 Max: 1241 Percentiles: P50: 1.37 P75: 1.78 P99: 5.56 P99.9: 45.62 P99.99: 856.73 ------------------------------------------------------ [ 0, 1 ] 20569 27.082% 27.082% ##### ( 1, 2 ] 46435 61.139% 88.221% ############ ( 2, 3 ] 5119 6.740% 94.961% # ( 3, 4 ] 2074 2.731% 97.692% # ( 4, 6 ] 1272 1.675% 99.367% ( 6, 10 ] 332 0.437% 99.804% ( 10, 15 ] 63 0.083% 99.887% ( 15, 22 ] 5 0.007% 99.893% ( 22, 34 ] 3 0.004% 99.897% ( 34, 51 ] 3 0.004% 99.901% ( 51, 76 ] 1 0.001% 99.903% ( 76, 110 ] 1 0.001% 99.904% ( 110, 170 ] 8 0.011% 99.914% ( 170, 250 ] 9 0.012% 99.926% ( 250, 380 ] 24 0.032% 99.958% ( 380, 580 ] 12 0.016% 99.974% ( 580, 870 ] 13 0.017% 99.991% ( 870, 1300 ] 7 0.009% 100.000% ** Level 3 read latency histogram (micros): Count: 91127 Average: 6.0763 StdDev: 77.00 Min: 1 Median: 1.7421 Max: 5011 Percentiles: P50: 1.74 P75: 2.55 P99: 9.96 P99.9: 741.04 P99.99: 2744.36 ------------------------------------------------------ [ 0, 1 ] 5884 6.457% 6.457% # ( 1, 2 ] 53472 58.679% 65.135% ############ ( 2, 3 ] 16441 18.042% 83.177% #### ( 3, 4 ] 7145 7.841% 91.018% ## ( 4, 6 ] 5767 6.329% 97.347% # ( 6, 10 ] 1523 1.671% 99.018% ( 10, 15 ] 276 0.303% 99.321% ( 15, 22 ] 62 0.068% 99.389% ( 22, 34 ] 31 0.034% 99.423% ( 51, 76 ] 5 0.005% 99.428% ( 76, 110 ] 46 0.050% 99.479% ( 110, 170 ] 128 0.140% 99.619% ( 170, 250 ] 80 0.088% 99.707% ( 250, 380 ] 61 0.067% 99.774% ( 380, 580 ] 82 0.090% 99.864% ( 580, 870 ] 61 0.067% 99.931% ( 870, 1300 ] 23 0.025% 99.956% ( 1300, 1900 ] 15 0.016% 99.973% ( 1900, 2900 ] 20 0.022% 99.995% ( 2900, 4400 ] 18 0.020% 100.014% ( 4400, 6600 ] 3 0.003% 100.018% ** Level 4 read latency histogram (micros): Count: 35 Average: 1472.8571 StdDev: 1182.13 Min: 51 Median: 1118.0769 Max: 5547 Percentiles: P50: 1118.08 P75: 1941.67 P99: 5547.00 P99.9: 5547.00 P99.99: 5547.00 ------------------------------------------------------ ( 34, 51 ] 1 2.857% 2.857% # ( 110, 170 ] 1 2.857% 5.714% # ( 170, 250 ] 1 2.857% 8.571% # ( 250, 380 ] 2 5.714% 14.286% # ( 380, 580 ] 1 2.857% 17.143% # ( 580, 870 ] 4 11.429% 28.571% ## ( 870, 1300 ] 13 37.143% 65.714% ####### ( 1300, 1900 ] 3 8.571% 74.286% ## ( 1900, 2900 ] 6 17.143% 91.429% ### ( 2900, 4400 ] 2 5.714% 97.143% # ( 4400, 6600 ] 1 2.857% 100.000% # ** Level 5 read latency histogram (micros): Count: 20 Average: 836.2500 StdDev: 1035.55 Min: 120 Median: 250.0000 Max: 3106 Percentiles: P50: 250.00 P75: 580.00 P99: 3106.00 P99.9: 3106.00 P99.99: 3106.00 ------------------------------------------------------ ( 110, 170 ] 5 25.000% 25.000% ##### ( 170, 250 ] 5 25.000% 50.000% ##### ( 250, 380 ] 1 5.000% 55.000% # ( 380, 580 ] 4 20.000% 75.000% #### ( 1300, 1900 ] 1 5.000% 80.000% # ( 1900, 2900 ] 3 15.000% 95.000% ### ( 2900, 4400 ] 1 5.000% 100.000% # ** DB Stats ** Uptime(secs): 19.3 total, 6.8 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 254.96 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.744 H:M:S, 29.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 144.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:3.943 H:M:S, 58.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 6 num-running-flushes: 1 2024/12/13-06:18:06 ... thread 0: (1000000,6000000) ops and (257752.5,261392.6) ops/second in (3.879691,22.953976) 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/4 2.88 GB 263.4 5.7 0.0 5.7 11.3 5.6 0.0 2.0 147.2 290.9 39.79 36.73 98 0.406 5947K 13K 0.0 0.0 L1 3/0 183.82 MB 18.4 2.5 2.5 0.0 2.5 2.5 0.2 1.0 233.1 231.0 11.08 10.72 2 5.540 2622K 23K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.3 0.2 0.2 0.3 0.2 2.4 1.8 247.4 247.3 1.41 1.36 2 0.705 354K 170 0.0 0.0 L3 16/1 1.04 GB 0.9 2.7 1.5 1.1 2.7 1.5 1.0 1.7 190.6 190.2 14.38 11.97 10 1.438 2735K 4767 0.0 0.0 L4 166/4 9.75 GB 1.0 0.7 0.6 0.1 0.7 0.6 1.6 1.1 161.8 161.4 4.38 3.30 7 0.626 704K 1281 0.0 0.0 L5 1068/0 87.85 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 1263/9 101.69 GB 0.0 12.0 4.9 7.1 17.5 10.4 7.1 3.1 172.3 252.3 71.04 64.08 119 0.597 12M 43K 0.0 0.0 Int 0/0 0.00 KB 0.0 12.0 4.9 7.1 17.5 10.4 7.1 3.1 172.3 252.3 71.04 64.08 119 0.597 12M 43K 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 12.0 4.9 7.1 11.9 4.8 0.0 0.0 226.6 225.7 54.02 49.51 38 1.422 12M 43K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 5.6 5.6 0.0 0.0 0.0 336.9 17.02 14.57 81 0.210 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 23.2 total, 23.0 interval Flush(GB): cumulative 5.598, interval 5.598 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 17.51 GB write, 773.33 MB/s write, 11.95 GB read, 528.00 MB/s read, 71.0 seconds Interval compaction: 17.51 GB write, 780.92 MB/s write, 11.95 GB read, 533.18 MB/s read, 71.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: 25, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 11, total-stops: 25, interval: 36 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2211160 Average: 2.3069 StdDev: 15.67 Min: 0 Median: 1.4815 Max: 4478 Percentiles: P50: 1.48 P75: 1.88 P99: 5.91 P99.9: 12.38 P99.99: 115.35 ------------------------------------------------------ [ 0, 1 ] 430713 19.479% 19.479% #### ( 1, 2 ] 1401612 63.388% 82.867% ############# ( 2, 3 ] 207985 9.406% 92.273% ## ( 3, 4 ] 92188 4.169% 96.443% # ( 4, 6 ] 59141 2.675% 99.117% # ( 6, 10 ] 15983 0.723% 99.840% ( 10, 15 ] 2789 0.126% 99.966% ( 15, 22 ] 304 0.014% 99.980% ( 22, 34 ] 20 0.001% 99.981% ( 34, 51 ] 12 0.001% 99.981% ( 51, 76 ] 11 0.000% 99.982% ( 76, 110 ] 151 0.007% 99.989% ( 110, 170 ] 335 0.015% 100.004% ( 170, 250 ] 130 0.006% 100.010% ( 250, 380 ] 113 0.005% 100.015% ( 380, 580 ] 76 0.003% 100.018% ( 580, 870 ] 64 0.003% 100.021% ( 870, 1300 ] 53 0.002% 100.024% ( 1300, 1900 ] 18 0.001% 100.024% ( 1900, 2900 ] 21 0.001% 100.025% ( 2900, 4400 ] 17 0.001% 100.026% ( 4400, 6600 ] 1 0.000% 100.026% ** Level 1 read latency histogram (micros): Count: 448763 Average: 3.5980 StdDev: 35.86 Min: 0 Median: 1.8467 Max: 5168 Percentiles: P50: 1.85 P75: 2.77 P99: 8.81 P99.9: 17.98 P99.99: 221.93 ------------------------------------------------------ [ 0, 1 ] 17274 3.849% 3.849% # ( 1, 2 ] 244601 54.506% 58.355% ########### ( 2, 3 ] 97596 21.748% 80.103% #### ( 3, 4 ] 41304 9.204% 89.307% ## ( 4, 6 ] 37865 8.438% 97.744% ## ( 6, 10 ] 8030 1.789% 99.534% ( 10, 15 ] 1549 0.345% 99.879% ( 15, 22 ] 224 0.050% 99.929% ( 22, 34 ] 13 0.003% 99.932% ( 34, 51 ] 40 0.009% 99.941% ( 51, 76 ] 16 0.004% 99.944% ( 76, 110 ] 76 0.017% 99.961% ( 110, 170 ] 73 0.016% 99.977% ( 170, 250 ] 88 0.020% 99.997% ( 250, 380 ] 90 0.020% 100.017% ( 380, 580 ] 113 0.025% 100.042% ( 580, 870 ] 75 0.017% 100.059% ( 870, 1300 ] 34 0.008% 100.066% ( 1300, 1900 ] 20 0.004% 100.071% ( 1900, 2900 ] 21 0.005% 100.076% ( 2900, 4400 ] 19 0.004% 100.080% ( 4400, 6600 ] 2 0.000% 100.080% ** Level 2 read latency histogram (micros): Count: 88506 Average: 2.6944 StdDev: 20.43 Min: 1 Median: 1.4384 Max: 2222 Percentiles: P50: 1.44 P75: 1.86 P99: 6.18 P99.9: 232.47 P99.99: 1032.20 ------------------------------------------------------ [ 0, 1 ] 20975 23.699% 23.699% ##### ( 1, 2 ] 53102 59.998% 83.697% ############ ( 2, 3 ] 7840 8.858% 92.555% ## ( 3, 4 ] 3266 3.690% 96.245% # ( 4, 6 ] 2409 2.722% 98.967% # ( 6, 10 ] 654 0.739% 99.706% ( 10, 15 ] 100 0.113% 99.819% ( 15, 22 ] 7 0.008% 99.827% ( 22, 34 ] 3 0.003% 99.831% ( 34, 51 ] 4 0.005% 99.835% ( 51, 76 ] 4 0.005% 99.840% ( 76, 110 ] 24 0.027% 99.867% ( 110, 170 ] 17 0.019% 99.886% ( 170, 250 ] 16 0.018% 99.904% ( 250, 380 ] 33 0.037% 99.941% ( 380, 580 ] 21 0.024% 99.965% ( 580, 870 ] 18 0.020% 99.985% ( 870, 1300 ] 11 0.012% 99.998% ( 1300, 1900 ] 1 0.001% 99.999% ( 1900, 2900 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 416428 Average: 6.7574 StdDev: 81.09 Min: 1 Median: 1.8494 Max: 7013 Percentiles: P50: 1.85 P75: 2.81 P99: 9.92 P99.9: 676.31 P99.99: 1217.80 ------------------------------------------------------ [ 0, 1 ] 15238 3.659% 3.659% # ( 1, 2 ] 227200 54.559% 58.218% ########### ( 2, 3 ] 86554 20.785% 79.003% #### ( 3, 4 ] 40008 9.607% 88.611% ## ( 4, 6 ] 34997 8.404% 97.015% ## ( 6, 10 ] 8435 2.026% 99.040% ( 10, 15 ] 1450 0.348% 99.389% ( 15, 22 ] 204 0.049% 99.438% ( 22, 34 ] 43 0.010% 99.448% ( 34, 51 ] 11 0.003% 99.451% ( 51, 76 ] 13 0.003% 99.454% ( 76, 110 ] 148 0.036% 99.489% ( 110, 170 ] 350 0.084% 99.573% ( 170, 250 ] 350 0.084% 99.657% ( 250, 380 ] 413 0.099% 99.757% ( 380, 580 ] 482 0.116% 99.872% ( 580, 870 ] 348 0.084% 99.956% ( 870, 1300 ] 176 0.042% 99.998% ( 1300, 1900 ] 66 0.016% 100.014% ( 1900, 2900 ] 109 0.026% 100.040% ( 2900, 4400 ] 86 0.021% 100.061% ( 4400, 6600 ] 8 0.002% 100.063% ( 6600, 9900 ] 1 0.000% 100.063% ** Level 4 read latency histogram (micros): Count: 145 Average: 517.3517 StdDev: 947.87 Min: 1 Median: 4.5000 Max: 5547 Percentiles: P50: 4.50 P75: 797.50 P99: 4231.25 P99.9: 5547.00 P99.99: 5547.00 ------------------------------------------------------ [ 0, 1 ] 16 11.034% 11.034% ## ( 1, 2 ] 35 24.138% 35.172% ##### ( 2, 3 ] 19 13.103% 48.276% ### ( 3, 4 ] 2 1.379% 49.655% ( 4, 6 ] 2 1.379% 51.034% ( 6, 10 ] 1 0.690% 51.724% ( 15, 22 ] 2 1.379% 53.103% ( 34, 51 ] 2 1.379% 54.483% ( 51, 76 ] 1 0.690% 55.172% ( 76, 110 ] 1 0.690% 55.862% ( 110, 170 ] 14 9.655% 65.517% ## ( 170, 250 ] 4 2.759% 68.276% # ( 250, 380 ] 3 2.069% 70.345% ( 380, 580 ] 3 2.069% 72.414% ( 580, 870 ] 5 3.448% 75.862% # ( 870, 1300 ] 17 11.724% 87.586% ## ( 1300, 1900 ] 5 3.448% 91.034% # ( 1900, 2900 ] 8 5.517% 96.552% # ( 2900, 4400 ] 4 2.759% 99.310% # ( 4400, 6600 ] 1 0.690% 100.000% ** Level 5 read latency histogram (micros): Count: 120 Average: 1210.2583 StdDev: 1364.80 Min: 80 Median: 555.0000 Max: 6220 Percentiles: P50: 555.00 P75: 2042.86 P99: 5720.00 P99.9: 6220.00 P99.99: 6220.00 ------------------------------------------------------ ( 76, 110 ] 2 1.667% 1.667% ( 110, 170 ] 12 10.000% 11.667% ## ( 170, 250 ] 15 12.500% 24.167% ### ( 250, 380 ] 17 14.167% 38.333% ### ( 380, 580 ] 16 13.333% 51.667% ### ( 580, 870 ] 16 13.333% 65.000% ### ( 870, 1300 ] 6 5.000% 70.000% # ( 1300, 1900 ] 4 3.333% 73.333% # ( 1900, 2900 ] 14 11.667% 85.000% ## ( 2900, 4400 ] 15 12.500% 97.500% ### ( 4400, 6600 ] 3 2.500% 100.000% # ** DB Stats ** Uptime(secs): 23.2 total, 3.9 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 254.74 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:6.699 H:M:S, 28.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 253.68 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.955 H:M:S, 24.6 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/12/13-06:18:09 ... thread 0: (1000000,7000000) ops and (306889.2,267048.4) ops/second in (3.258505,26.212481) 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 3.92 GB 376.7 6.6 0.0 6.6 13.3 6.6 0.0 2.0 146.6 292.8 46.41 42.93 115 0.404 6906K 14K 0.0 0.0 L1 3/0 183.82 MB 18.4 2.5 2.5 0.0 2.5 2.5 0.2 1.0 233.1 231.0 11.08 10.72 2 5.540 2622K 23K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.3 0.2 0.2 0.3 0.2 2.4 1.8 247.4 247.3 1.41 1.36 2 0.705 354K 170 0.0 0.0 L3 15/0 931.60 MB 0.9 2.7 1.5 1.1 2.7 1.5 1.0 1.7 190.6 190.2 14.38 11.97 10 1.438 2735K 4767 0.0 0.0 L4 163/0 9.57 GB 1.0 0.8 0.7 0.1 0.8 0.7 1.6 1.2 164.4 164.0 5.29 4.03 8 0.661 868K 1899 0.0 0.0 L5 1072/0 88.15 GB 0.9 0.0 0.0 0.0 0.0 0.0 2.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1268/4 102.73 GB 0.0 13.0 5.0 8.1 19.6 11.6 7.4 3.0 169.8 255.8 78.57 71.01 137 0.574 13M 45K 0.0 0.0 Int 0/0 0.00 KB 0.0 13.0 5.0 8.1 19.6 11.6 7.4 3.0 169.8 255.8 78.57 71.01 137 0.574 13M 45K 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 13.0 5.0 8.1 13.0 4.9 0.0 0.0 228.1 227.3 58.51 53.73 42 1.393 13M 45K 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 339.2 20.06 17.28 95 0.211 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): 26.4 total, 26.2 interval Flush(GB): cumulative 6.644, interval 6.644 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 19.63 GB write, 760.28 MB/s write, 13.03 GB read, 504.75 MB/s read, 78.6 seconds Interval compaction: 19.63 GB write, 766.82 MB/s write, 13.03 GB read, 509.09 MB/s read, 78.6 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: 31, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 11, total-stops: 31, interval: 42 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2484948 Average: 2.2623 StdDev: 15.23 Min: 0 Median: 1.4630 Max: 4478 Percentiles: P50: 1.46 P75: 1.86 P99: 5.86 P99.9: 12.22 P99.99: 110.98 ------------------------------------------------------ [ 0, 1 ] 517711 20.834% 20.834% #### ( 1, 2 ] 1565481 62.999% 83.832% ############# ( 2, 3 ] 222811 8.966% 92.799% ## ( 3, 4 ] 97147 3.909% 96.708% # ( 4, 6 ] 61271 2.466% 99.174% ( 6, 10 ] 16694 0.672% 99.846% ( 10, 15 ] 3037 0.122% 99.968% ( 15, 22 ] 344 0.014% 99.982% ( 22, 34 ] 22 0.001% 99.983% ( 34, 51 ] 14 0.001% 99.983% ( 51, 76 ] 12 0.000% 99.984% ( 76, 110 ] 151 0.006% 99.990% ( 110, 170 ] 338 0.014% 100.003% ( 170, 250 ] 140 0.006% 100.009% ( 250, 380 ] 121 0.005% 100.014% ( 380, 580 ] 77 0.003% 100.017% ( 580, 870 ] 68 0.003% 100.020% ( 870, 1300 ] 58 0.002% 100.022% ( 1300, 1900 ] 19 0.001% 100.023% ( 1900, 2900 ] 22 0.001% 100.024% ( 2900, 4400 ] 18 0.001% 100.024% ( 4400, 6600 ] 1 0.000% 100.025% ** Level 1 read latency histogram (micros): Count: 451224 Average: 3.5907 StdDev: 35.76 Min: 0 Median: 1.8447 Max: 5168 Percentiles: P50: 1.84 P75: 2.76 P99: 8.80 P99.9: 17.90 P99.99: 221.71 ------------------------------------------------------ [ 0, 1 ] 17535 3.886% 3.886% # ( 1, 2 ] 246323 54.590% 58.476% ########### ( 2, 3 ] 97916 21.700% 80.176% #### ( 3, 4 ] 41374 9.169% 89.345% ## ( 4, 6 ] 37907 8.401% 97.746% ## ( 6, 10 ] 8073 1.789% 99.535% ( 10, 15 ] 1552 0.344% 99.879% ( 15, 22 ] 224 0.050% 99.929% ( 22, 34 ] 13 0.003% 99.932% ( 34, 51 ] 40 0.009% 99.941% ( 51, 76 ] 16 0.004% 99.944% ( 76, 110 ] 76 0.017% 99.961% ( 110, 170 ] 73 0.016% 99.977% ( 170, 250 ] 88 0.020% 99.997% ( 250, 380 ] 90 0.020% 100.017% ( 380, 580 ] 113 0.025% 100.042% ( 580, 870 ] 75 0.017% 100.059% ( 870, 1300 ] 34 0.008% 100.066% ( 1300, 1900 ] 20 0.004% 100.070% ( 1900, 2900 ] 21 0.005% 100.075% ( 2900, 4400 ] 19 0.004% 100.079% ( 4400, 6600 ] 2 0.000% 100.080% ** Level 2 read latency histogram (micros): Count: 88506 Average: 2.6944 StdDev: 20.43 Min: 1 Median: 1.4384 Max: 2222 Percentiles: P50: 1.44 P75: 1.86 P99: 6.18 P99.9: 232.47 P99.99: 1032.20 ------------------------------------------------------ [ 0, 1 ] 20975 23.699% 23.699% ##### ( 1, 2 ] 53102 59.998% 83.697% ############ ( 2, 3 ] 7840 8.858% 92.555% ## ( 3, 4 ] 3266 3.690% 96.245% # ( 4, 6 ] 2409 2.722% 98.967% # ( 6, 10 ] 654 0.739% 99.706% ( 10, 15 ] 100 0.113% 99.819% ( 15, 22 ] 7 0.008% 99.827% ( 22, 34 ] 3 0.003% 99.831% ( 34, 51 ] 4 0.005% 99.835% ( 51, 76 ] 4 0.005% 99.840% ( 76, 110 ] 24 0.027% 99.867% ( 110, 170 ] 17 0.019% 99.886% ( 170, 250 ] 16 0.018% 99.904% ( 250, 380 ] 33 0.037% 99.941% ( 380, 580 ] 21 0.024% 99.965% ( 580, 870 ] 18 0.020% 99.985% ( 870, 1300 ] 11 0.012% 99.998% ( 1300, 1900 ] 1 0.001% 99.999% ( 1900, 2900 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 417756 Average: 6.7438 StdDev: 80.97 Min: 1 Median: 1.8482 Max: 7013 Percentiles: P50: 1.85 P75: 2.80 P99: 9.92 P99.9: 675.20 P99.99: 1217.48 ------------------------------------------------------ [ 0, 1 ] 15424 3.692% 3.692% # ( 1, 2 ] 228088 54.598% 58.290% ########### ( 2, 3 ] 86716 20.758% 79.048% #### ( 3, 4 ] 40055 9.588% 88.636% ## ( 4, 6 ] 35017 8.382% 97.018% ## ( 6, 10 ] 8455 2.024% 99.042% ( 10, 15 ] 1453 0.348% 99.390% ( 15, 22 ] 205 0.049% 99.439% ( 22, 34 ] 43 0.010% 99.449% ( 34, 51 ] 11 0.003% 99.452% ( 51, 76 ] 13 0.003% 99.455% ( 76, 110 ] 148 0.035% 99.491% ( 110, 170 ] 350 0.084% 99.574% ( 170, 250 ] 350 0.084% 99.658% ( 250, 380 ] 414 0.099% 99.757% ( 380, 580 ] 482 0.115% 99.873% ( 580, 870 ] 348 0.083% 99.956% ( 870, 1300 ] 176 0.042% 99.998% ( 1300, 1900 ] 66 0.016% 100.014% ( 1900, 2900 ] 109 0.026% 100.040% ( 2900, 4400 ] 86 0.021% 100.061% ( 4400, 6600 ] 8 0.002% 100.062% ( 6600, 9900 ] 1 0.000% 100.063% ** Level 4 read latency histogram (micros): Count: 170 Average: 451.8294 StdDev: 891.31 Min: 1 Median: 2.9474 Max: 5547 Percentiles: P50: 2.95 P75: 480.00 P99: 4137.50 P99.9: 5547.00 P99.99: 5547.00 ------------------------------------------------------ [ 0, 1 ] 24 14.118% 14.118% ### ( 1, 2 ] 43 25.294% 39.412% ##### ( 2, 3 ] 19 11.176% 50.588% ## ( 3, 4 ] 2 1.176% 51.765% ( 4, 6 ] 3 1.765% 53.529% ( 6, 10 ] 1 0.588% 54.118% ( 15, 22 ] 2 1.176% 55.294% ( 22, 34 ] 1 0.588% 55.882% ( 34, 51 ] 2 1.176% 57.059% ( 51, 76 ] 1 0.588% 57.647% ( 76, 110 ] 1 0.588% 58.235% ( 110, 170 ] 18 10.588% 68.824% ## ( 170, 250 ] 5 2.941% 71.765% # ( 250, 380 ] 4 2.353% 74.118% ( 380, 580 ] 3 1.765% 75.882% ( 580, 870 ] 6 3.529% 79.412% # ( 870, 1300 ] 17 10.000% 89.412% ## ( 1300, 1900 ] 5 2.941% 92.353% # ( 1900, 2900 ] 8 4.706% 97.059% # ( 2900, 4400 ] 4 2.353% 99.412% ( 4400, 6600 ] 1 0.588% 100.000% ** Level 5 read latency histogram (micros): Count: 140 Average: 1150.7000 StdDev: 1308.67 Min: 80 Median: 546.6667 Max: 6220 Percentiles: P50: 546.67 P75: 1900.00 P99: 5573.33 P99.9: 6220.00 P99.99: 6220.00 ------------------------------------------------------ ( 76, 110 ] 4 2.857% 2.857% # ( 110, 170 ] 18 12.857% 15.714% ### ( 170, 250 ] 16 11.429% 27.143% ## ( 250, 380 ] 17 12.143% 39.286% ## ( 380, 580 ] 18 12.857% 52.143% ### ( 580, 870 ] 19 13.571% 65.714% ### ( 870, 1300 ] 7 5.000% 70.714% # ( 1300, 1900 ] 6 4.286% 75.000% # ( 1900, 2900 ] 17 12.143% 87.143% ## ( 2900, 4400 ] 15 10.714% 97.857% ## ( 4400, 6600 ] 3 2.143% 100.000% ** DB Stats ** Uptime(secs): 26.4 total, 3.3 interval Cumulative writes: 0 writes, 7000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 6.73 GB, 260.57 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:7.332 H:M:S, 27.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 302.03 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.633 H:M:S, 19.4 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/12/13-06:18:12 ... thread 0: (1000000,8000000) ops and (331536.5,273703.2) ops/second in (3.016259,29.228740) 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/4 4.91 GB 477.4 7.8 0.0 7.8 15.4 7.6 0.0 2.0 148.5 294.3 53.45 49.60 133 0.402 8058K 15K 0.0 0.0 L1 3/0 183.82 MB 18.4 2.5 2.5 0.0 2.5 2.5 0.2 1.0 233.1 231.0 11.08 10.72 2 5.540 2622K 23K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.3 0.2 0.2 0.3 0.2 2.4 1.8 247.4 247.3 1.41 1.36 2 0.705 354K 170 0.0 0.0 L3 15/0 931.60 MB 0.9 2.7 1.5 1.1 2.7 1.5 1.0 1.7 190.6 190.2 14.38 11.97 10 1.438 2735K 4767 0.0 0.0 L4 163/0 9.57 GB 1.0 0.8 0.7 0.1 0.8 0.7 1.6 1.2 164.4 164.0 5.29 4.03 8 0.661 868K 1899 0.0 0.0 L5 1072/0 88.15 GB 0.9 0.0 0.0 0.0 0.0 0.0 2.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1270/4 103.72 GB 0.0 14.1 5.0 9.2 21.7 12.6 7.4 2.8 169.1 259.8 85.61 77.68 155 0.552 14M 46K 0.0 0.0 Int 0/0 0.00 KB 0.0 14.1 5.0 9.2 21.7 12.6 7.4 2.8 169.1 259.8 85.61 77.68 155 0.552 14M 46K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 14.1 5.0 9.2 14.1 4.9 0.0 0.0 230.6 229.8 62.79 57.91 46 1.365 14M 46K 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 342.2 22.82 19.77 109 0.209 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 29.5 total, 29.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: 21.72 GB write, 755.09 MB/s write, 14.14 GB read, 491.55 MB/s read, 85.6 seconds Interval compaction: 21.72 GB write, 760.91 MB/s write, 14.14 GB read, 495.34 MB/s read, 85.6 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 12, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 12, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 36, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 12, total-stops: 36, interval: 48 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2742726 Average: 2.2259 StdDev: 14.60 Min: 0 Median: 1.4486 Max: 4478 Percentiles: P50: 1.45 P75: 1.85 P99: 5.81 P99.9: 12.09 P99.99: 107.69 ------------------------------------------------------ [ 0, 1 ] 598558 21.823% 21.823% #### ( 1, 2 ] 1722670 62.809% 84.632% ############# ( 2, 3 ] 235189 8.575% 93.207% ## ( 3, 4 ] 101732 3.709% 96.916% # ( 4, 6 ] 63148 2.302% 99.219% ( 6, 10 ] 17323 0.632% 99.850% ( 10, 15 ] 3265 0.119% 99.969% ( 15, 22 ] 373 0.014% 99.983% ( 22, 34 ] 25 0.001% 99.984% ( 34, 51 ] 16 0.001% 99.984% ( 51, 76 ] 15 0.001% 99.985% ( 76, 110 ] 151 0.006% 99.990% ( 110, 170 ] 348 0.013% 100.003% ( 170, 250 ] 145 0.005% 100.008% ( 250, 380 ] 129 0.005% 100.013% ( 380, 580 ] 84 0.003% 100.016% ( 580, 870 ] 73 0.003% 100.019% ( 870, 1300 ] 60 0.002% 100.021% ( 1300, 1900 ] 19 0.001% 100.022% ( 1900, 2900 ] 22 0.001% 100.023% ( 2900, 4400 ] 18 0.001% 100.023% ( 4400, 6600 ] 1 0.000% 100.023% ** Level 1 read latency histogram (micros): Count: 451224 Average: 3.5907 StdDev: 35.76 Min: 0 Median: 1.8447 Max: 5168 Percentiles: P50: 1.84 P75: 2.76 P99: 8.80 P99.9: 17.90 P99.99: 221.71 ------------------------------------------------------ [ 0, 1 ] 17535 3.886% 3.886% # ( 1, 2 ] 246323 54.590% 58.476% ########### ( 2, 3 ] 97916 21.700% 80.176% #### ( 3, 4 ] 41374 9.169% 89.345% ## ( 4, 6 ] 37907 8.401% 97.746% ## ( 6, 10 ] 8073 1.789% 99.535% ( 10, 15 ] 1552 0.344% 99.879% ( 15, 22 ] 224 0.050% 99.929% ( 22, 34 ] 13 0.003% 99.932% ( 34, 51 ] 40 0.009% 99.941% ( 51, 76 ] 16 0.004% 99.944% ( 76, 110 ] 76 0.017% 99.961% ( 110, 170 ] 73 0.016% 99.977% ( 170, 250 ] 88 0.020% 99.997% ( 250, 380 ] 90 0.020% 100.017% ( 380, 580 ] 113 0.025% 100.042% ( 580, 870 ] 75 0.017% 100.059% ( 870, 1300 ] 34 0.008% 100.066% ( 1300, 1900 ] 20 0.004% 100.070% ( 1900, 2900 ] 21 0.005% 100.075% ( 2900, 4400 ] 19 0.004% 100.079% ( 4400, 6600 ] 2 0.000% 100.080% ** Level 2 read latency histogram (micros): Count: 88506 Average: 2.6944 StdDev: 20.43 Min: 1 Median: 1.4384 Max: 2222 Percentiles: P50: 1.44 P75: 1.86 P99: 6.18 P99.9: 232.47 P99.99: 1032.20 ------------------------------------------------------ [ 0, 1 ] 20975 23.699% 23.699% ##### ( 1, 2 ] 53102 59.998% 83.697% ############ ( 2, 3 ] 7840 8.858% 92.555% ## ( 3, 4 ] 3266 3.690% 96.245% # ( 4, 6 ] 2409 2.722% 98.967% # ( 6, 10 ] 654 0.739% 99.706% ( 10, 15 ] 100 0.113% 99.819% ( 15, 22 ] 7 0.008% 99.827% ( 22, 34 ] 3 0.003% 99.831% ( 34, 51 ] 4 0.005% 99.835% ( 51, 76 ] 4 0.005% 99.840% ( 76, 110 ] 24 0.027% 99.867% ( 110, 170 ] 17 0.019% 99.886% ( 170, 250 ] 16 0.018% 99.904% ( 250, 380 ] 33 0.037% 99.941% ( 380, 580 ] 21 0.024% 99.965% ( 580, 870 ] 18 0.020% 99.985% ( 870, 1300 ] 11 0.012% 99.998% ( 1300, 1900 ] 1 0.001% 99.999% ( 1900, 2900 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 417756 Average: 6.7438 StdDev: 80.97 Min: 1 Median: 1.8482 Max: 7013 Percentiles: P50: 1.85 P75: 2.80 P99: 9.92 P99.9: 675.20 P99.99: 1217.48 ------------------------------------------------------ [ 0, 1 ] 15424 3.692% 3.692% # ( 1, 2 ] 228088 54.598% 58.290% ########### ( 2, 3 ] 86716 20.758% 79.048% #### ( 3, 4 ] 40055 9.588% 88.636% ## ( 4, 6 ] 35017 8.382% 97.018% ## ( 6, 10 ] 8455 2.024% 99.042% ( 10, 15 ] 1453 0.348% 99.390% ( 15, 22 ] 205 0.049% 99.439% ( 22, 34 ] 43 0.010% 99.449% ( 34, 51 ] 11 0.003% 99.452% ( 51, 76 ] 13 0.003% 99.455% ( 76, 110 ] 148 0.035% 99.491% ( 110, 170 ] 350 0.084% 99.574% ( 170, 250 ] 350 0.084% 99.658% ( 250, 380 ] 414 0.099% 99.757% ( 380, 580 ] 482 0.115% 99.873% ( 580, 870 ] 348 0.083% 99.956% ( 870, 1300 ] 176 0.042% 99.998% ( 1300, 1900 ] 66 0.016% 100.014% ( 1900, 2900 ] 109 0.026% 100.040% ( 2900, 4400 ] 86 0.021% 100.061% ( 4400, 6600 ] 8 0.002% 100.062% ( 6600, 9900 ] 1 0.000% 100.063% ** Level 4 read latency histogram (micros): Count: 170 Average: 451.8294 StdDev: 891.31 Min: 1 Median: 2.9474 Max: 5547 Percentiles: P50: 2.95 P75: 480.00 P99: 4137.50 P99.9: 5547.00 P99.99: 5547.00 ------------------------------------------------------ [ 0, 1 ] 24 14.118% 14.118% ### ( 1, 2 ] 43 25.294% 39.412% ##### ( 2, 3 ] 19 11.176% 50.588% ## ( 3, 4 ] 2 1.176% 51.765% ( 4, 6 ] 3 1.765% 53.529% ( 6, 10 ] 1 0.588% 54.118% ( 15, 22 ] 2 1.176% 55.294% ( 22, 34 ] 1 0.588% 55.882% ( 34, 51 ] 2 1.176% 57.059% ( 51, 76 ] 1 0.588% 57.647% ( 76, 110 ] 1 0.588% 58.235% ( 110, 170 ] 18 10.588% 68.824% ## ( 170, 250 ] 5 2.941% 71.765% # ( 250, 380 ] 4 2.353% 74.118% ( 380, 580 ] 3 1.765% 75.882% ( 580, 870 ] 6 3.529% 79.412% # ( 870, 1300 ] 17 10.000% 89.412% ## ( 1300, 1900 ] 5 2.941% 92.353% # ( 1900, 2900 ] 8 4.706% 97.059% # ( 2900, 4400 ] 4 2.353% 99.412% ( 4400, 6600 ] 1 0.588% 100.000% ** Level 5 read latency histogram (micros): Count: 140 Average: 1150.7000 StdDev: 1308.67 Min: 80 Median: 546.6667 Max: 6220 Percentiles: P50: 546.67 P75: 1900.00 P99: 5573.33 P99.9: 6220.00 P99.99: 6220.00 ------------------------------------------------------ ( 76, 110 ] 4 2.857% 2.857% # ( 110, 170 ] 18 12.857% 15.714% ### ( 170, 250 ] 16 11.429% 27.143% ## ( 250, 380 ] 17 12.143% 39.286% ## ( 380, 580 ] 18 12.857% 52.143% ### ( 580, 870 ] 19 13.571% 65.714% ### ( 870, 1300 ] 7 5.000% 70.714% # ( 1300, 1900 ] 6 4.286% 75.000% # ( 1900, 2900 ] 17 12.143% 87.143% ## ( 2900, 4400 ] 15 10.714% 97.857% ## ( 4400, 6600 ] 3 2.143% 100.000% ** DB Stats ** Uptime(secs): 29.5 total, 3.0 interval Cumulative writes: 0 writes, 8000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 7.69 GB, 267.29 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:7.753 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, 326.18 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.421 H:M:S, 14.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/12/13-06:18:40 ... thread 0: (1000000,9000000) ops and (35277.5,156316.6) ops/second in (28.346710,57.575450) 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 5/4 692.50 MB 6.3 8.5 0.0 8.5 17.0 8.5 0.0 2.0 146.4 292.6 59.36 54.74 150 0.396 8825K 16K 0.0 0.0 L1 6/6 603.68 MB 0.0 7.8 7.6 0.2 7.6 7.5 0.2 1.0 210.6 206.5 37.89 34.04 3 12.630 8104K 155K 0.0 0.0 L2 19/18 2.16 GB 1.3 0.3 0.2 0.2 0.3 0.2 6.9 1.8 247.4 247.3 1.41 1.36 2 0.705 354K 170 0.0 0.0 L3 36/9 3.31 GB 2.5 2.7 1.5 1.1 2.7 1.5 3.4 1.7 190.6 190.2 14.38 11.97 10 1.438 2735K 4767 0.0 0.0 L4 163/0 9.57 GB 1.0 0.8 0.7 0.1 0.8 0.7 1.6 1.2 164.4 164.0 5.29 4.03 8 0.661 868K 1899 0.0 0.0 L5 1072/0 88.15 GB 0.9 0.0 0.0 0.0 0.0 0.0 2.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1301/37 104.45 GB 0.0 20.1 10.1 10.1 28.5 18.4 14.4 3.4 174.4 246.3 118.33 106.14 173 0.684 20M 179K 0.0 0.0 Int 0/0 0.00 KB 0.0 20.1 10.1 10.1 28.5 18.4 14.4 3.4 174.4 246.3 118.33 106.14 173 0.684 20M 179K 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.1 10.1 10.1 20.0 9.9 0.0 0.0 223.0 221.0 92.54 84.08 50 1.851 20M 179K 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 337.2 25.78 22.06 123 0.210 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): 57.8 total, 57.6 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.46 GB write, 504.23 MB/s write, 20.15 GB read, 356.96 MB/s read, 118.3 seconds Interval compaction: 28.46 GB write, 506.21 MB/s write, 20.15 GB read, 358.36 MB/s read, 118.3 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 23, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 23, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 37, pending-compaction-bytes-delays: 2, pending-compaction-bytes-stops: 0, total-delays: 25, total-stops: 37, interval: 62 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 4249636 Average: 2.9242 StdDev: 22.93 Min: 0 Median: 1.4021 Max: 7675 Percentiles: P50: 1.40 P75: 1.81 P99: 7.79 P99.9: 160.57 P99.99: 448.81 ------------------------------------------------------ [ 0, 1 ] 1070357 25.187% 25.187% ##### ( 1, 2 ] 2622248 61.705% 86.892% ############ ( 2, 3 ] 283138 6.663% 93.555% # ( 3, 4 ] 133677 3.146% 96.701% # ( 4, 6 ] 87255 2.053% 98.754% ( 6, 10 ] 23389 0.550% 99.304% ( 10, 15 ] 5241 0.123% 99.427% ( 15, 22 ] 979 0.023% 99.450% ( 22, 34 ] 40 0.001% 99.451% ( 34, 51 ] 46 0.001% 99.453% ( 51, 76 ] 121 0.003% 99.455% ( 76, 110 ] 11409 0.268% 99.724% ( 110, 170 ] 8883 0.209% 99.933% ( 170, 250 ] 1196 0.028% 99.961% ( 250, 380 ] 953 0.022% 99.983% ( 380, 580 ] 811 0.019% 100.003% ( 580, 870 ] 331 0.008% 100.010% ( 870, 1300 ] 97 0.002% 100.013% ( 1300, 1900 ] 37 0.001% 100.013% ( 1900, 2900 ] 62 0.001% 100.015% ( 2900, 4400 ] 47 0.001% 100.016% ( 4400, 6600 ] 5 0.000% 100.016% ( 6600, 9900 ] 4 0.000% 100.016% ** Level 1 read latency histogram (micros): Count: 671138 Average: 5.2450 StdDev: 81.06 Min: 0 Median: 1.8469 Max: 12040 Percentiles: P50: 1.85 P75: 2.81 P99: 9.39 P99.9: 139.61 P99.99: 268.12 ------------------------------------------------------ [ 0, 1 ] 37020 5.516% 5.516% # ( 1, 2 ] 352526 52.527% 58.043% ########### ( 2, 3 ] 140767 20.974% 79.017% #### ( 3, 4 ] 64188 9.564% 88.581% ## ( 4, 6 ] 59023 8.794% 97.376% ## ( 6, 10 ] 12865 1.917% 99.292% ( 10, 15 ] 2684 0.400% 99.692% ( 15, 22 ] 374 0.056% 99.748% ( 22, 34 ] 19 0.003% 99.751% ( 34, 51 ] 44 0.007% 99.757% ( 51, 76 ] 48 0.007% 99.765% ( 76, 110 ] 630 0.094% 99.858% ( 110, 170 ] 565 0.084% 99.943% ( 170, 250 ] 285 0.042% 99.985% ( 250, 380 ] 236 0.035% 100.020% ( 380, 580 ] 241 0.036% 100.056% ( 580, 870 ] 187 0.028% 100.084% ( 870, 1300 ] 115 0.017% 100.101% ( 1300, 1900 ] 60 0.009% 100.110% ( 1900, 2900 ] 74 0.011% 100.121% ( 2900, 4400 ] 124 0.018% 100.140% ( 4400, 6600 ] 36 0.005% 100.145% ( 6600, 9900 ] 14 0.002% 100.147% ( 9900, 14000 ] 1 0.000% 100.147% ** Level 2 read latency histogram (micros): Count: 88506 Average: 2.6944 StdDev: 20.43 Min: 1 Median: 1.4384 Max: 2222 Percentiles: P50: 1.44 P75: 1.86 P99: 6.18 P99.9: 232.47 P99.99: 1032.20 ------------------------------------------------------ [ 0, 1 ] 20975 23.699% 23.699% ##### ( 1, 2 ] 53102 59.998% 83.697% ############ ( 2, 3 ] 7840 8.858% 92.555% ## ( 3, 4 ] 3266 3.690% 96.245% # ( 4, 6 ] 2409 2.722% 98.967% # ( 6, 10 ] 654 0.739% 99.706% ( 10, 15 ] 100 0.113% 99.819% ( 15, 22 ] 7 0.008% 99.827% ( 22, 34 ] 3 0.003% 99.831% ( 34, 51 ] 4 0.005% 99.835% ( 51, 76 ] 4 0.005% 99.840% ( 76, 110 ] 24 0.027% 99.867% ( 110, 170 ] 17 0.019% 99.886% ( 170, 250 ] 16 0.018% 99.904% ( 250, 380 ] 33 0.037% 99.941% ( 380, 580 ] 21 0.024% 99.965% ( 580, 870 ] 18 0.020% 99.985% ( 870, 1300 ] 11 0.012% 99.998% ( 1300, 1900 ] 1 0.001% 99.999% ( 1900, 2900 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 449658 Average: 6.7700 StdDev: 81.54 Min: 1 Median: 1.8570 Max: 7013 Percentiles: P50: 1.86 P75: 2.83 P99: 9.98 P99.9: 666.02 P99.99: 1209.81 ------------------------------------------------------ [ 0, 1 ] 16118 3.585% 3.585% # ( 1, 2 ] 243529 54.159% 57.743% ########### ( 2, 3 ] 93897 20.882% 78.625% #### ( 3, 4 ] 43587 9.693% 88.318% ## ( 4, 6 ] 38642 8.594% 96.912% ## ( 6, 10 ] 9437 2.099% 99.011% ( 10, 15 ] 1617 0.360% 99.370% ( 15, 22 ] 229 0.051% 99.421% ( 22, 34 ] 44 0.010% 99.431% ( 34, 51 ] 12 0.003% 99.434% ( 51, 76 ] 14 0.003% 99.437% ( 76, 110 ] 153 0.034% 99.471% ( 110, 170 ] 432 0.096% 99.567% ( 170, 250 ] 416 0.093% 99.660% ( 250, 380 ] 456 0.101% 99.761% ( 380, 580 ] 515 0.115% 99.875% ( 580, 870 ] 372 0.083% 99.958% ( 870, 1300 ] 181 0.040% 99.998% ( 1300, 1900 ] 67 0.015% 100.013% ( 1900, 2900 ] 112 0.025% 100.038% ( 2900, 4400 ] 94 0.021% 100.059% ( 4400, 6600 ] 11 0.002% 100.062% ( 6600, 9900 ] 1 0.000% 100.062% ** Level 4 read latency histogram (micros): Count: 170 Average: 451.8294 StdDev: 891.31 Min: 1 Median: 2.9474 Max: 5547 Percentiles: P50: 2.95 P75: 480.00 P99: 4137.50 P99.9: 5547.00 P99.99: 5547.00 ------------------------------------------------------ [ 0, 1 ] 24 14.118% 14.118% ### ( 1, 2 ] 43 25.294% 39.412% ##### ( 2, 3 ] 19 11.176% 50.588% ## ( 3, 4 ] 2 1.176% 51.765% ( 4, 6 ] 3 1.765% 53.529% ( 6, 10 ] 1 0.588% 54.118% ( 15, 22 ] 2 1.176% 55.294% ( 22, 34 ] 1 0.588% 55.882% ( 34, 51 ] 2 1.176% 57.059% ( 51, 76 ] 1 0.588% 57.647% ( 76, 110 ] 1 0.588% 58.235% ( 110, 170 ] 18 10.588% 68.824% ## ( 170, 250 ] 5 2.941% 71.765% # ( 250, 380 ] 4 2.353% 74.118% ( 380, 580 ] 3 1.765% 75.882% ( 580, 870 ] 6 3.529% 79.412% # ( 870, 1300 ] 17 10.000% 89.412% ## ( 1300, 1900 ] 5 2.941% 92.353% # ( 1900, 2900 ] 8 4.706% 97.059% # ( 2900, 4400 ] 4 2.353% 99.412% ( 4400, 6600 ] 1 0.588% 100.000% ** Level 5 read latency histogram (micros): Count: 140 Average: 1150.7000 StdDev: 1308.67 Min: 80 Median: 546.6667 Max: 6220 Percentiles: P50: 546.67 P75: 1900.00 P99: 5573.33 P99.9: 6220.00 P99.99: 6220.00 ------------------------------------------------------ ( 76, 110 ] 4 2.857% 2.857% # ( 110, 170 ] 18 12.857% 15.714% ### ( 170, 250 ] 16 11.429% 27.143% ## ( 250, 380 ] 17 12.143% 39.286% ## ( 380, 580 ] 18 12.857% 52.143% ### ( 580, 870 ] 19 13.571% 65.714% ### ( 870, 1300 ] 7 5.000% 70.714% # ( 1300, 1900 ] 6 4.286% 75.000% # ( 1900, 2900 ] 17 12.143% 87.143% ## ( 2900, 4400 ] 15 10.714% 97.857% ## ( 4400, 6600 ] 3 2.143% 100.000% ** DB Stats ** Uptime(secs): 57.8 total, 28.3 interval Cumulative writes: 0 writes, 9000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 8.65 GB, 153.24 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:32.699 H:M:S, 56.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 34.72 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:24.946 H:M:S, 88.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 10 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.552 micros/op 152625 ops/sec 60.377 seconds 9214999 operations; 147.9 MB/s Microseconds per write: Count: 9214999 Average: 6.5520 StdDev: 545.23 Min: 1 Median: 1.7269 Max: 1014063 Percentiles: P50: 1.73 P75: 2.74 P99: 9.62 P99.9: 1271.27 P99.99: 2799.23 ------------------------------------------------------ [ 0, 1 ] 1301698 14.126% 14.126% ### ( 1, 2 ] 4548029 49.355% 63.480% ########## ( 2, 3 ] 1432658 15.547% 79.028% ### ( 3, 4 ] 1247842 13.541% 92.569% ### ( 4, 6 ] 489592 5.313% 97.882% # ( 6, 10 ] 113990 1.237% 99.119% ( 10, 15 ] 40227 0.437% 99.555% ( 15, 22 ] 10388 0.113% 99.668% ( 22, 34 ] 1908 0.021% 99.689% ( 34, 51 ] 231 0.003% 99.691% ( 51, 76 ] 27 0.000% 99.692% ( 76, 110 ] 6371 0.069% 99.761% ( 110, 170 ] 2532 0.027% 99.788% ( 170, 250 ] 265 0.003% 99.791% ( 250, 380 ] 188 0.002% 99.793% ( 380, 580 ] 20 0.000% 99.793% ( 580, 870 ] 13 0.000% 99.794% ( 870, 1300 ] 10507 0.114% 99.908% ( 1300, 1900 ] 29 0.000% 99.908% ( 1900, 2900 ] 8410 0.091% 99.999% ( 2900, 4400 ] 38 0.000% 100.000% ( 4400, 6600 ] 3 0.000% 100.000% ( 6600, 9900 ] 5 0.000% 100.000% ( 9900, 14000 ] 1 0.000% 100.000% ( 14000, 22000 ] 3 0.000% 100.000% ( 22000, 33000 ] 2 0.000% 100.000% ( 50000, 75000 ] 2 0.000% 100.000% ( 75000, 110000 ] 1 0.000% 100.000% ( 110000, 170000 ] 1 0.000% 100.000% ( 170000, 250000 ] 13 0.000% 100.000% ( 250000, 380000 ] 3 0.000% 100.000% ( 860000, 1200000 ] 2 0.000% 100.000% STATISTICS: rocksdb.block.cache.miss COUNT : 0 rocksdb.block.cache.hit COUNT : 0 rocksdb.block.cache.add COUNT : 0 rocksdb.block.cache.add.failures COUNT : 0 rocksdb.block.cache.index.miss COUNT : 0 rocksdb.block.cache.index.hit COUNT : 0 rocksdb.block.cache.index.add COUNT : 0 rocksdb.block.cache.index.bytes.insert COUNT : 0 rocksdb.block.cache.filter.miss COUNT : 0 rocksdb.block.cache.filter.hit COUNT : 0 rocksdb.block.cache.filter.add COUNT : 0 rocksdb.block.cache.filter.bytes.insert COUNT : 0 rocksdb.block.cache.data.miss COUNT : 0 rocksdb.block.cache.data.hit COUNT : 0 rocksdb.block.cache.data.add COUNT : 0 rocksdb.block.cache.data.bytes.insert COUNT : 0 rocksdb.block.cache.bytes.read COUNT : 0 rocksdb.block.cache.bytes.write COUNT : 0 rocksdb.bloom.filter.useful COUNT : 0 rocksdb.bloom.filter.full.positive COUNT : 0 rocksdb.bloom.filter.full.true.positive COUNT : 0 rocksdb.persistent.cache.hit COUNT : 0 rocksdb.persistent.cache.miss COUNT : 0 rocksdb.sim.block.cache.hit COUNT : 0 rocksdb.sim.block.cache.miss COUNT : 0 rocksdb.memtable.hit COUNT : 0 rocksdb.memtable.miss COUNT : 0 rocksdb.l0.hit COUNT : 0 rocksdb.l1.hit COUNT : 0 rocksdb.l2andup.hit COUNT : 0 rocksdb.compaction.key.drop.new COUNT : 233294 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 : 9214999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 9509878968 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 : 426 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 34871918 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 : 25780553654 rocksdb.compact.write.bytes COUNT : 25540905763 rocksdb.flush.write.bytes COUNT : 9446223534 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 : 39 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 : 222 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 : 9370074112 rocksdb.memtable.garbage.bytes.at.flush COUNT : 3651584 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 : 25862313347 rocksdb.non.last.level.read.count COUNT : 6248110 rocksdb.block.checksum.compute.count COUNT : 6247297 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.371657 P95 : 3.928561 P99 : 8.311179 P100 : 1014060.000000 COUNT : 9214999 SUM : 56057971 rocksdb.compaction.times.micros P50 : 1062903.225806 P95 : 4410000.000000 P99 : 26510000.000000 P100 : 26809808.000000 COUNT : 59 SUM : 108919104 rocksdb.compaction.times.cpu_micros P50 : 971153.846154 P95 : 4410000.000000 P99 : 23318469.000000 P100 : 23318469.000000 COUNT : 59 SUM : 92336176 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 : 709.736842 P95 : 5940.000000 P99 : 100900.000000 P100 : 222623.000000 COUNT : 126 SUM : 505163 rocksdb.compaction.outfile.sync.micros P50 : 996.269841 P95 : 230500.000000 P99 : 503737.500000 P100 : 533602.000000 COUNT : 279 SUM : 9400011 rocksdb.wal.file.sync.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.manifest.file.sync.micros P50 : 97.462500 P95 : 1907.142857 P99 : 3578.750000 P100 : 4189.000000 COUNT : 219 SUM : 63925 rocksdb.table.open.io.micros P50 : 1424.137931 P95 : 7540.500000 P99 : 11504.857143 P100 : 12087.000000 COUNT : 426 SUM : 881510 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.565533 P95 : 7.817153 P99 : 12.822678 P100 : 12437.000000 COUNT : 6246306 SUM : 38755580 rocksdb.read.block.get.micros P50 : 436.790123 P95 : 3243.902439 P99 : 4945.600000 P100 : 6636.000000 COUNT : 852 SUM : 720658 rocksdb.write.raw.block.micros P50 : 0.515644 P95 : 0.979723 P99 : 3.011346 P100 : 15334.000000 COUNT : 8476429 SUM : 17802048 rocksdb.numfiles.in.singlecompaction P50 : 3.253731 P95 : 5.657143 P99 : 13.800000 P100 : 20.000000 COUNT : 124 SUM : 469 rocksdb.db.seek.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.db.write.stall P50 : 0.583010 P95 : 2107.028089 P99 : 2744.166865 P100 : 1013879.000000 COUNT : 133831 SUM : 34889019 rocksdb.sst.read.micros P50 : 1.534823 P95 : 4.568023 P99 : 9.173836 P100 : 12040.000000 COUNT : 6248617 SUM : 25891529 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 : 9214999 SUM : 9509878968 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 : 210493.827160 P95 : 377705.882353 P99 : 985800.000000 P100 : 1154788.000000 COUNT : 126 SUM : 28570960 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 : 254 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