[2024-11-30 00:13:32.173289] Starting SPDK v24.01.1-pre git sha1 c13c99a5e / DPDK 23.11.0 initialization... [2024-11-30 00:13:32.173447] [ 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_pid690095 ] Set seed to 1732922012169787 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-11-30 00:13:32.283993] app.c: 798:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-11-30 00:13:32.498020] app.c: 488:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-11-30 00:13:32.498063] app.c: 489:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 690095' to capture a snapshot of events at runtime. [2024-11-30 00:13:32.498072] app.c: 494:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid690095 for offline analysis/debug. [2024-11-30 00:13:32.498110] reactor.c: 937:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Sat Nov 30 00:13:41 2024 CPU: 96 * Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz CPUCache: 36608 KB 2024/11/30-00:13:44 ... thread 0: (1000000,1000000) ops and (340091.3,340091.3) ops/second in (2.940387,2.940387) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 9/6 629.97 MB 25.2 0.0 0.0 0.0 0.9 0.9 0.0 1.0 0.0 357.9 2.46 2.23 12 0.205 0 0 0.0 0.0 L2 3/2 251.74 MB 0.0 0.4 0.2 0.2 0.4 0.2 0.1 2.0 251.7 251.6 1.50 1.46 2 0.751 383K 209 0.0 0.0 L3 9/0 741.26 MB 0.7 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.3 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.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1181/8 97.00 GB 0.0 0.4 0.2 0.2 1.2 1.0 0.8 1.4 95.3 317.6 3.97 3.68 14 0.283 383K 209 0.0 0.0 Int 0/0 0.00 KB 0.0 0.4 0.2 0.2 1.2 1.0 0.8 1.4 95.3 317.6 3.97 3.68 14 0.283 383K 209 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 0.0 0.0 251.7 251.6 1.50 1.46 2 0.751 383K 209 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 357.9 2.46 2.23 12 0.205 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 3.1 total, 2.9 interval Flush(GB): cumulative 0.861, interval 0.861 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 1.23 GB write, 402.85 MB/s write, 0.37 GB read, 120.87 MB/s read, 4.0 seconds Interval compaction: 1.23 GB write, 428.20 MB/s write, 0.37 GB read, 128.48 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: 111805 Average: 1.9852 StdDev: 19.60 Min: 1 Median: 1.2994 Max: 4997 Percentiles: P50: 1.30 P75: 1.71 P99: 4.47 P99.9: 11.26 P99.99: 420.97 ------------------------------------------------------ [ 0, 1 ] 35368 31.634% 31.634% ###### ( 1, 2 ] 68585 61.343% 92.977% ############ ( 2, 3 ] 4726 4.227% 97.204% # ( 3, 4 ] 1806 1.615% 98.819% ( 4, 6 ] 872 0.780% 99.599% ( 6, 10 ] 316 0.283% 99.882% ( 10, 15 ] 84 0.075% 99.957% ( 15, 22 ] 17 0.015% 99.972% ( 22, 34 ] 6 0.005% 99.978% ( 34, 51 ] 1 0.001% 99.979% ( 51, 76 ] 1 0.001% 99.979% ( 110, 170 ] 7 0.006% 99.986% ( 170, 250 ] 1 0.001% 99.987% ( 250, 380 ] 4 0.004% 99.990% ( 380, 580 ] 4 0.004% 99.994% ( 580, 870 ] 1 0.001% 99.995% ( 870, 1300 ] 3 0.003% 99.997% ( 1300, 1900 ] 1 0.001% 99.998% ( 1900, 2900 ] 2 0.002% 100.000% ( 4400, 6600 ] 1 0.001% 100.001% ** Level 1 read latency histogram (micros): Count: 5 Average: 2403.0000 StdDev: 2135.73 Min: 617 Median: 821.6667 Max: 5558 Percentiles: P50: 821.67 P75: 4025.00 P99: 5558.00 P99.9: 5558.00 P99.99: 5558.00 ------------------------------------------------------ ( 580, 870 ] 3 60.000% 60.000% ############ ( 2900, 4400 ] 1 20.000% 80.000% #### ( 4400, 6600 ] 1 20.000% 100.000% #### ** Level 2 read latency histogram (micros): Count: 60294 Average: 2.2026 StdDev: 37.00 Min: 0 Median: 1.3208 Max: 6380 Percentiles: P50: 1.32 P75: 1.73 P99: 5.35 P99.9: 10.71 P99.99: 1009.12 ------------------------------------------------------ [ 0, 1 ] 18251 30.270% 30.270% ###### ( 1, 2 ] 37084 61.505% 91.775% ############ ( 2, 3 ] 2529 4.194% 95.970% # ( 3, 4 ] 1301 2.158% 98.128% ( 4, 6 ] 779 1.292% 99.420% ( 6, 10 ] 284 0.471% 99.891% ( 10, 15 ] 40 0.066% 99.957% ( 15, 22 ] 9 0.015% 99.972% ( 22, 34 ] 1 0.002% 99.973% ( 34, 51 ] 3 0.005% 99.978% ( 51, 76 ] 2 0.003% 99.982% ( 250, 380 ] 3 0.005% 99.987% ( 580, 870 ] 1 0.002% 99.988% ( 870, 1300 ] 3 0.005% 99.993% ( 1300, 1900 ] 1 0.002% 99.995% ( 1900, 2900 ] 1 0.002% 99.997% ( 4400, 6600 ] 2 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 55 Average: 3263.6909 StdDev: 2771.29 Min: 431 Median: 2150.0000 Max: 7987 Percentiles: P50: 2150.00 P75: 5850.00 P99: 7987.00 P99.9: 7987.00 P99.99: 7987.00 ------------------------------------------------------ ( 380, 580 ] 8 14.545% 14.545% ### ( 580, 870 ] 12 21.818% 36.364% #### ( 870, 1300 ] 3 5.455% 41.818% # ( 1300, 1900 ] 3 5.455% 47.273% # ( 1900, 2900 ] 6 10.909% 58.182% ## ( 2900, 4400 ] 2 3.636% 61.818% # ( 4400, 6600 ] 11 20.000% 81.818% #### ( 6600, 9900 ] 10 18.182% 100.000% #### ** Level 4 read latency histogram (micros): Count: 15 Average: 4293.8667 StdDev: 2622.46 Min: 870 Median: 4871.4286 Max: 9016 Percentiles: P50: 4871.43 P75: 6050.00 P99: 9016.00 P99.9: 9016.00 P99.99: 9016.00 ------------------------------------------------------ ( 580, 870 ] 1 6.667% 6.667% # ( 870, 1300 ] 1 6.667% 13.333% # ( 1300, 1900 ] 3 20.000% 33.333% #### ( 1900, 2900 ] 1 6.667% 40.000% # ( 4400, 6600 ] 7 46.667% 86.667% ######### ( 6600, 9900 ] 2 13.333% 100.000% ### ** Level 5 read latency histogram (micros): Count: 20 Average: 595.7500 StdDev: 785.08 Min: 76 Median: 150.0000 Max: 2834 Percentiles: P50: 150.00 P75: 773.33 P99: 2800.00 P99.9: 2834.00 P99.99: 2834.00 ------------------------------------------------------ ( 51, 76 ] 1 5.000% 5.000% # ( 76, 110 ] 5 25.000% 30.000% ##### ( 110, 170 ] 6 30.000% 60.000% ###### ( 380, 580 ] 1 5.000% 65.000% # ( 580, 870 ] 3 15.000% 80.000% ### ( 1300, 1900 ] 2 10.000% 90.000% ## ( 1900, 2900 ] 2 10.000% 100.000% ## ** DB Stats ** Uptime(secs): 3.1 total, 2.9 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 314.73 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.371 H:M:S, 11.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 334.45 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.371 H:M:S, 12.6 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/30-00:13:46 ... thread 0: (1000000,2000000) ops and (356380.1,348045.2) ops/second in (2.805993,5.746380) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 11/8 1.17 GB 62.9 0.6 0.0 0.6 2.3 1.8 0.0 1.3 78.0 329.3 7.27 6.68 28 0.260 575K 579 0.0 0.0 L1 1/0 2.88 MB 0.3 0.4 0.4 0.0 0.4 0.4 0.2 1.0 236.4 235.9 1.60 1.55 1 1.599 383K 629 0.0 0.0 L2 2/0 54.91 MB 0.5 0.4 0.2 0.2 0.4 0.2 0.5 2.0 251.7 251.6 1.50 1.46 2 0.751 383K 209 0.0 0.0 L3 42/0 998.95 MB 1.0 0.8 0.6 0.2 0.8 0.6 0.1 1.4 201.0 200.7 3.96 3.50 3 1.321 808K 892 0.0 0.0 L4 144/0 9.47 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1048/0 86.25 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 1248/8 97.92 GB 0.0 2.1 1.1 1.0 3.9 2.9 2.1 2.2 147.9 275.2 14.33 13.18 34 0.421 2151K 2309 0.0 0.0 Int 0/0 0.00 KB 0.0 2.1 1.1 1.0 3.9 2.9 2.1 2.2 147.9 275.2 14.33 13.18 34 0.421 2151K 2309 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.1 1.0 2.1 1.1 0.0 0.0 229.6 229.3 9.23 8.63 8 1.154 2151K 2309 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 358.2 5.10 4.55 26 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): 5.9 total, 5.7 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.85 GB write, 664.73 MB/s write, 2.07 GB read, 357.19 MB/s read, 14.3 seconds Interval compaction: 3.85 GB write, 686.14 MB/s write, 2.07 GB read, 368.70 MB/s read, 14.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: 3, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 3, interval: 3 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 388606 Average: 2.2227 StdDev: 12.30 Min: 1 Median: 1.4936 Max: 4997 Percentiles: P50: 1.49 P75: 1.88 P99: 5.72 P99.9: 9.99 P99.99: 14.99 ------------------------------------------------------ [ 0, 1 ] 70140 18.049% 18.049% #### ( 1, 2 ] 251523 64.724% 82.774% ############# ( 2, 3 ] 39106 10.063% 92.837% ## ( 3, 4 ] 13929 3.584% 96.421% # ( 4, 6 ] 11644 2.996% 99.417% # ( 6, 10 ] 1882 0.484% 99.902% ( 10, 15 ] 344 0.089% 99.990% ( 15, 22 ] 35 0.009% 99.999% ( 22, 34 ] 10 0.003% 100.002% ( 34, 51 ] 2 0.001% 100.002% ( 51, 76 ] 2 0.001% 100.003% ( 76, 110 ] 2 0.001% 100.003% ( 110, 170 ] 11 0.003% 100.006% ( 170, 250 ] 10 0.003% 100.009% ( 250, 380 ] 5 0.001% 100.010% ( 380, 580 ] 7 0.002% 100.012% ( 580, 870 ] 10 0.003% 100.014% ( 870, 1300 ] 7 0.002% 100.016% ( 1300, 1900 ] 3 0.001% 100.017% ( 1900, 2900 ] 2 0.001% 100.017% ( 4400, 6600 ] 1 0.000% 100.018% ** Level 1 read latency histogram (micros): Count: 81598 Average: 2.7019 StdDev: 26.03 Min: 1 Median: 1.6913 Max: 5558 Percentiles: P50: 1.69 P75: 2.31 P99: 6.92 P99.9: 13.30 P99.99: 17.92 ------------------------------------------------------ [ 0, 1 ] 5345 6.550% 6.550% # ( 1, 2 ] 51289 62.856% 69.406% ############# ( 2, 3 ] 14745 18.070% 87.476% #### ( 3, 4 ] 4414 5.409% 92.886% # ( 4, 6 ] 4810 5.895% 98.781% # ( 6, 10 ] 782 0.958% 99.739% ( 10, 15 ] 199 0.244% 99.983% ( 15, 22 ] 14 0.017% 100.000% ( 22, 34 ] 2 0.002% 100.002% ( 34, 51 ] 1 0.001% 100.004% ( 51, 76 ] 1 0.001% 100.005% ( 110, 170 ] 1 0.001% 100.006% ( 170, 250 ] 1 0.001% 100.007% ( 250, 380 ] 2 0.002% 100.010% ( 380, 580 ] 1 0.001% 100.011% ( 580, 870 ] 5 0.006% 100.017% ( 870, 1300 ] 1 0.001% 100.018% ( 2900, 4400 ] 1 0.001% 100.020% ( 4400, 6600 ] 1 0.001% 100.021% ** Level 2 read latency histogram (micros): Count: 95419 Average: 2.2222 StdDev: 29.42 Min: 0 Median: 1.4151 Max: 6380 Percentiles: P50: 1.42 P75: 1.81 P99: 5.66 P99.9: 9.90 P99.99: 313.18 ------------------------------------------------------ [ 0, 1 ] 22639 23.726% 23.726% ##### ( 1, 2 ] 60400 63.300% 87.026% ############# ( 2, 3 ] 6645 6.964% 93.990% # ( 3, 4 ] 2996 3.140% 97.130% # ( 4, 6 ] 2144 2.247% 99.376% ( 6, 10 ] 512 0.537% 99.913% ( 10, 15 ] 56 0.059% 99.972% ( 15, 22 ] 9 0.009% 99.981% ( 22, 34 ] 2 0.002% 99.983% ( 34, 51 ] 3 0.003% 99.986% ( 51, 76 ] 2 0.002% 99.988% ( 250, 380 ] 3 0.003% 99.992% ( 580, 870 ] 1 0.001% 99.993% ( 870, 1300 ] 3 0.003% 99.996% ( 1300, 1900 ] 1 0.001% 99.997% ( 1900, 2900 ] 1 0.001% 99.998% ( 4400, 6600 ] 2 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 57472 Average: 5.7071 StdDev: 132.54 Min: 0 Median: 1.6846 Max: 7987 Percentiles: P50: 1.68 P75: 2.29 P99: 7.94 P99.9: 220.56 P99.99: 6250.56 ------------------------------------------------------ [ 0, 1 ] 4033 7.017% 7.017% # ( 1, 2 ] 36086 62.789% 69.806% ############# ( 2, 3 ] 10260 17.852% 87.658% #### ( 3, 4 ] 2901 5.048% 92.706% # ( 4, 6 ] 3313 5.765% 98.471% # ( 6, 10 ] 626 1.089% 99.560% ( 10, 15 ] 144 0.251% 99.810% ( 15, 22 ] 39 0.068% 99.878% ( 22, 34 ] 5 0.009% 99.887% ( 34, 51 ] 2 0.003% 99.890% ( 110, 170 ] 3 0.005% 99.896% ( 170, 250 ] 4 0.007% 99.903% ( 250, 380 ] 5 0.009% 99.911% ( 380, 580 ] 8 0.014% 99.925% ( 580, 870 ] 12 0.021% 99.946% ( 870, 1300 ] 5 0.009% 99.955% ( 1300, 1900 ] 3 0.005% 99.960% ( 1900, 2900 ] 6 0.010% 99.970% ( 2900, 4400 ] 2 0.003% 99.974% ( 4400, 6600 ] 11 0.019% 99.993% ( 6600, 9900 ] 10 0.017% 100.010% ** Level 4 read latency histogram (micros): Count: 15 Average: 4293.8667 StdDev: 2622.46 Min: 870 Median: 4871.4286 Max: 9016 Percentiles: P50: 4871.43 P75: 6050.00 P99: 9016.00 P99.9: 9016.00 P99.99: 9016.00 ------------------------------------------------------ ( 580, 870 ] 1 6.667% 6.667% # ( 870, 1300 ] 1 6.667% 13.333% # ( 1300, 1900 ] 3 20.000% 33.333% #### ( 1900, 2900 ] 1 6.667% 40.000% # ( 4400, 6600 ] 7 46.667% 86.667% ######### ( 6600, 9900 ] 2 13.333% 100.000% ### ** Level 5 read latency histogram (micros): Count: 40 Average: 762.2750 StdDev: 952.53 Min: 76 Median: 165.0000 Max: 3209 Percentiles: P50: 165.00 P75: 1300.00 P99: 3209.00 P99.9: 3209.00 P99.99: 3209.00 ------------------------------------------------------ ( 51, 76 ] 1 2.500% 2.500% # ( 76, 110 ] 8 20.000% 22.500% #### ( 110, 170 ] 12 30.000% 52.500% ###### ( 170, 250 ] 1 2.500% 55.000% # ( 250, 380 ] 1 2.500% 57.500% # ( 380, 580 ] 2 5.000% 62.500% # ( 580, 870 ] 4 10.000% 72.500% ## ( 870, 1300 ] 1 2.500% 75.000% # ( 1300, 1900 ] 3 7.500% 82.500% ## ( 1900, 2900 ] 6 15.000% 97.500% ### ( 2900, 4400 ] 1 2.500% 100.000% # ** DB Stats ** Uptime(secs): 5.9 total, 2.8 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 331.76 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.549 H:M:S, 9.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 350.75 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.178 H:M:S, 6.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/30-00:13:49 ... thread 0: (1000000,3000000) ops and (332500.9,342704.7) ops/second in (3.007511,8.753891) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 15/11 2.09 GB 44.1 1.4 0.0 1.4 4.1 2.7 0.0 1.5 106.7 320.1 12.99 12.04 44 0.295 1407K 1467 0.0 0.0 L1 1/1 2.88 MB 0.0 0.4 0.4 0.0 0.4 0.4 0.2 1.0 236.4 235.9 1.60 1.55 1 1.599 383K 629 0.0 0.0 L2 2/0 54.91 MB 0.5 0.4 0.2 0.2 0.4 0.2 0.5 2.0 251.7 251.6 1.50 1.46 2 0.751 383K 209 0.0 0.0 L3 42/0 998.95 MB 1.0 0.8 0.6 0.2 0.8 0.6 0.1 1.4 201.0 200.7 3.96 3.50 3 1.321 808K 892 0.0 0.0 L4 144/0 9.47 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1048/0 86.25 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 1252/12 98.84 GB 0.0 2.9 1.1 1.8 5.6 3.8 2.1 2.1 146.5 284.6 20.05 18.55 50 0.401 2983K 3197 0.0 0.0 Int 0/0 0.00 KB 0.0 2.9 1.1 1.8 5.6 3.8 2.1 2.1 146.5 284.6 20.05 18.55 50 0.401 2983K 3197 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 2.9 1.1 1.8 2.9 1.1 0.0 0.0 239.2 238.9 12.28 11.62 11 1.117 2983K 3197 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 2.7 2.7 0.0 0.0 0.0 356.9 7.77 6.93 39 0.199 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 8.9 total, 8.8 interval Flush(GB): cumulative 2.707, interval 2.707 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 5.57 GB write, 638.31 MB/s write, 2.87 GB read, 328.64 MB/s read, 20.0 seconds Interval compaction: 5.57 GB write, 651.81 MB/s write, 2.87 GB read, 335.59 MB/s read, 20.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: 7, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 7, interval: 7 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 702642 Average: 2.1603 StdDev: 11.89 Min: 1 Median: 1.4722 Max: 4997 Percentiles: P50: 1.47 P75: 1.85 P99: 5.59 P99.9: 9.83 P99.99: 14.91 ------------------------------------------------------ [ 0, 1 ] 131221 18.675% 18.675% #### ( 1, 2 ] 466108 66.336% 85.012% ############# ( 2, 3 ] 63338 9.014% 94.026% ## ( 3, 4 ] 21908 3.118% 97.144% # ( 4, 6 ] 16436 2.339% 99.483% ( 6, 10 ] 3064 0.436% 99.919% ( 10, 15 ] 508 0.072% 99.992% ( 15, 22 ] 60 0.009% 100.000% ( 22, 34 ] 12 0.002% 100.002% ( 34, 51 ] 2 0.000% 100.002% ( 51, 76 ] 3 0.000% 100.003% ( 76, 110 ] 2 0.000% 100.003% ( 110, 170 ] 16 0.002% 100.005% ( 170, 250 ] 16 0.002% 100.007% ( 250, 380 ] 7 0.001% 100.008% ( 380, 580 ] 14 0.002% 100.010% ( 580, 870 ] 14 0.002% 100.012% ( 870, 1300 ] 12 0.002% 100.014% ( 1300, 1900 ] 3 0.000% 100.015% ( 1900, 2900 ] 2 0.000% 100.015% ( 2900, 4400 ] 3 0.000% 100.015% ( 4400, 6600 ] 1 0.000% 100.015% ** Level 1 read latency histogram (micros): Count: 81599 Average: 2.7019 StdDev: 26.03 Min: 1 Median: 1.6913 Max: 5558 Percentiles: P50: 1.69 P75: 2.31 P99: 6.92 P99.9: 13.30 P99.99: 17.92 ------------------------------------------------------ [ 0, 1 ] 5345 6.550% 6.550% # ( 1, 2 ] 51289 62.855% 69.405% ############# ( 2, 3 ] 14745 18.070% 87.475% #### ( 3, 4 ] 4415 5.411% 92.886% # ( 4, 6 ] 4810 5.895% 98.781% # ( 6, 10 ] 782 0.958% 99.739% ( 10, 15 ] 199 0.244% 99.983% ( 15, 22 ] 14 0.017% 100.000% ( 22, 34 ] 2 0.002% 100.002% ( 34, 51 ] 1 0.001% 100.004% ( 51, 76 ] 1 0.001% 100.005% ( 110, 170 ] 1 0.001% 100.006% ( 170, 250 ] 1 0.001% 100.007% ( 250, 380 ] 2 0.002% 100.010% ( 380, 580 ] 1 0.001% 100.011% ( 580, 870 ] 5 0.006% 100.017% ( 870, 1300 ] 1 0.001% 100.018% ( 2900, 4400 ] 1 0.001% 100.020% ( 4400, 6600 ] 1 0.001% 100.021% ** Level 2 read latency histogram (micros): Count: 95419 Average: 2.2222 StdDev: 29.42 Min: 0 Median: 1.4151 Max: 6380 Percentiles: P50: 1.42 P75: 1.81 P99: 5.66 P99.9: 9.90 P99.99: 313.18 ------------------------------------------------------ [ 0, 1 ] 22639 23.726% 23.726% ##### ( 1, 2 ] 60400 63.300% 87.026% ############# ( 2, 3 ] 6645 6.964% 93.990% # ( 3, 4 ] 2996 3.140% 97.130% # ( 4, 6 ] 2144 2.247% 99.376% ( 6, 10 ] 512 0.537% 99.913% ( 10, 15 ] 56 0.059% 99.972% ( 15, 22 ] 9 0.009% 99.981% ( 22, 34 ] 2 0.002% 99.983% ( 34, 51 ] 3 0.003% 99.986% ( 51, 76 ] 2 0.002% 99.988% ( 250, 380 ] 3 0.003% 99.992% ( 580, 870 ] 1 0.001% 99.993% ( 870, 1300 ] 3 0.003% 99.996% ( 1300, 1900 ] 1 0.001% 99.997% ( 1900, 2900 ] 1 0.001% 99.998% ( 4400, 6600 ] 2 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 57472 Average: 5.7071 StdDev: 132.54 Min: 0 Median: 1.6846 Max: 7987 Percentiles: P50: 1.68 P75: 2.29 P99: 7.94 P99.9: 220.56 P99.99: 6250.56 ------------------------------------------------------ [ 0, 1 ] 4033 7.017% 7.017% # ( 1, 2 ] 36086 62.789% 69.806% ############# ( 2, 3 ] 10260 17.852% 87.658% #### ( 3, 4 ] 2901 5.048% 92.706% # ( 4, 6 ] 3313 5.765% 98.471% # ( 6, 10 ] 626 1.089% 99.560% ( 10, 15 ] 144 0.251% 99.810% ( 15, 22 ] 39 0.068% 99.878% ( 22, 34 ] 5 0.009% 99.887% ( 34, 51 ] 2 0.003% 99.890% ( 110, 170 ] 3 0.005% 99.896% ( 170, 250 ] 4 0.007% 99.903% ( 250, 380 ] 5 0.009% 99.911% ( 380, 580 ] 8 0.014% 99.925% ( 580, 870 ] 12 0.021% 99.946% ( 870, 1300 ] 5 0.009% 99.955% ( 1300, 1900 ] 3 0.005% 99.960% ( 1900, 2900 ] 6 0.010% 99.970% ( 2900, 4400 ] 2 0.003% 99.974% ( 4400, 6600 ] 11 0.019% 99.993% ( 6600, 9900 ] 10 0.017% 100.010% ** Level 4 read latency histogram (micros): Count: 15 Average: 4293.8667 StdDev: 2622.46 Min: 870 Median: 4871.4286 Max: 9016 Percentiles: P50: 4871.43 P75: 6050.00 P99: 9016.00 P99.9: 9016.00 P99.99: 9016.00 ------------------------------------------------------ ( 580, 870 ] 1 6.667% 6.667% # ( 870, 1300 ] 1 6.667% 13.333% # ( 1300, 1900 ] 3 20.000% 33.333% #### ( 1900, 2900 ] 1 6.667% 40.000% # ( 4400, 6600 ] 7 46.667% 86.667% ######### ( 6600, 9900 ] 2 13.333% 100.000% ### ** Level 5 read latency histogram (micros): Count: 40 Average: 762.2750 StdDev: 952.53 Min: 76 Median: 165.0000 Max: 3209 Percentiles: P50: 165.00 P75: 1300.00 P99: 3209.00 P99.9: 3209.00 P99.99: 3209.00 ------------------------------------------------------ ( 51, 76 ] 1 2.500% 2.500% # ( 76, 110 ] 8 20.000% 22.500% #### ( 110, 170 ] 12 30.000% 52.500% ###### ( 170, 250 ] 1 2.500% 55.000% # ( 250, 380 ] 1 2.500% 57.500% # ( 380, 580 ] 2 5.000% 62.500% # ( 580, 870 ] 4 10.000% 72.500% ## ( 870, 1300 ] 1 2.500% 75.000% # ( 1300, 1900 ] 3 7.500% 82.500% ## ( 1900, 2900 ] 6 15.000% 97.500% ### ( 2900, 4400 ] 1 2.500% 100.000% # ** DB Stats ** Uptime(secs): 8.9 total, 3.0 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 330.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:0.956 H:M:S, 10.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 327.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.406 H:M:S, 13.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/30-00:13:53 ... thread 0: (1000000,4000000) ops and (294851.8,329342.1) ops/second in (3.391534,12.145425) 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/11 3.13 GB 157.3 2.5 0.0 2.5 6.2 3.7 0.0 1.7 124.2 313.4 20.29 18.95 63 0.322 2558K 2689 0.0 0.0 L1 1/1 2.88 MB 0.0 0.4 0.4 0.0 0.4 0.4 0.2 1.0 236.4 235.9 1.60 1.55 1 1.599 383K 629 0.0 0.0 L2 2/0 54.91 MB 0.5 0.4 0.2 0.2 0.4 0.2 0.5 2.0 251.7 251.6 1.50 1.46 2 0.751 383K 209 0.0 0.0 L3 42/0 998.95 MB 1.0 0.8 0.6 0.2 0.8 0.6 0.1 1.4 201.0 200.7 3.96 3.50 3 1.321 808K 892 0.0 0.0 L4 144/0 9.47 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1048/0 86.25 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 1255/12 99.88 GB 0.0 4.0 1.1 2.9 7.7 4.9 2.1 2.1 148.9 289.2 27.36 25.45 69 0.396 4134K 4419 0.0 0.0 Int 0/0 0.00 KB 0.0 4.0 1.1 2.9 7.7 4.9 2.1 2.1 148.9 289.2 27.36 25.45 69 0.396 4134K 4419 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 4.0 1.1 2.9 4.0 1.1 0.0 0.0 245.9 245.6 16.56 15.82 15 1.104 4134K 4419 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.9 10.80 9.64 54 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.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: 7.72 GB write, 641.45 MB/s write, 3.98 GB read, 330.21 MB/s read, 27.4 seconds Interval compaction: 7.72 GB write, 651.23 MB/s write, 3.98 GB read, 335.24 MB/s read, 27.4 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: 10, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 3, total-stops: 10, interval: 13 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1167353 Average: 2.2074 StdDev: 10.62 Min: 1 Median: 1.4999 Max: 4997 Percentiles: P50: 1.50 P75: 1.87 P99: 5.65 P99.9: 9.96 P99.99: 14.67 ------------------------------------------------------ [ 0, 1 ] 190513 16.320% 16.320% ### ( 1, 2 ] 786524 67.377% 83.697% ############# ( 2, 3 ] 115943 9.932% 93.629% ## ( 3, 4 ] 39006 3.341% 96.970% # ( 4, 6 ] 28709 2.459% 99.430% ( 6, 10 ] 5541 0.475% 99.904% ( 10, 15 ] 1071 0.092% 99.996% ( 15, 22 ] 107 0.009% 100.005% ( 22, 34 ] 17 0.001% 100.007% ( 34, 51 ] 4 0.000% 100.007% ( 51, 76 ] 3 0.000% 100.007% ( 76, 110 ] 42 0.004% 100.011% ( 110, 170 ] 52 0.004% 100.015% ( 170, 250 ] 38 0.003% 100.019% ( 250, 380 ] 16 0.001% 100.020% ( 380, 580 ] 31 0.003% 100.023% ( 580, 870 ] 24 0.002% 100.025% ( 870, 1300 ] 18 0.002% 100.026% ( 1300, 1900 ] 4 0.000% 100.027% ( 1900, 2900 ] 2 0.000% 100.027% ( 2900, 4400 ] 4 0.000% 100.027% ( 4400, 6600 ] 1 0.000% 100.027% ** Level 1 read latency histogram (micros): Count: 81599 Average: 2.7019 StdDev: 26.03 Min: 1 Median: 1.6913 Max: 5558 Percentiles: P50: 1.69 P75: 2.31 P99: 6.92 P99.9: 13.30 P99.99: 17.92 ------------------------------------------------------ [ 0, 1 ] 5345 6.550% 6.550% # ( 1, 2 ] 51289 62.855% 69.405% ############# ( 2, 3 ] 14745 18.070% 87.475% #### ( 3, 4 ] 4415 5.411% 92.886% # ( 4, 6 ] 4810 5.895% 98.781% # ( 6, 10 ] 782 0.958% 99.739% ( 10, 15 ] 199 0.244% 99.983% ( 15, 22 ] 14 0.017% 100.000% ( 22, 34 ] 2 0.002% 100.002% ( 34, 51 ] 1 0.001% 100.004% ( 51, 76 ] 1 0.001% 100.005% ( 110, 170 ] 1 0.001% 100.006% ( 170, 250 ] 1 0.001% 100.007% ( 250, 380 ] 2 0.002% 100.010% ( 380, 580 ] 1 0.001% 100.011% ( 580, 870 ] 5 0.006% 100.017% ( 870, 1300 ] 1 0.001% 100.018% ( 2900, 4400 ] 1 0.001% 100.020% ( 4400, 6600 ] 1 0.001% 100.021% ** Level 2 read latency histogram (micros): Count: 95419 Average: 2.2222 StdDev: 29.42 Min: 0 Median: 1.4151 Max: 6380 Percentiles: P50: 1.42 P75: 1.81 P99: 5.66 P99.9: 9.90 P99.99: 313.18 ------------------------------------------------------ [ 0, 1 ] 22639 23.726% 23.726% ##### ( 1, 2 ] 60400 63.300% 87.026% ############# ( 2, 3 ] 6645 6.964% 93.990% # ( 3, 4 ] 2996 3.140% 97.130% # ( 4, 6 ] 2144 2.247% 99.376% ( 6, 10 ] 512 0.537% 99.913% ( 10, 15 ] 56 0.059% 99.972% ( 15, 22 ] 9 0.009% 99.981% ( 22, 34 ] 2 0.002% 99.983% ( 34, 51 ] 3 0.003% 99.986% ( 51, 76 ] 2 0.002% 99.988% ( 250, 380 ] 3 0.003% 99.992% ( 580, 870 ] 1 0.001% 99.993% ( 870, 1300 ] 3 0.003% 99.996% ( 1300, 1900 ] 1 0.001% 99.997% ( 1900, 2900 ] 1 0.001% 99.998% ( 4400, 6600 ] 2 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 57472 Average: 5.7071 StdDev: 132.54 Min: 0 Median: 1.6846 Max: 7987 Percentiles: P50: 1.68 P75: 2.29 P99: 7.94 P99.9: 220.56 P99.99: 6250.56 ------------------------------------------------------ [ 0, 1 ] 4033 7.017% 7.017% # ( 1, 2 ] 36086 62.789% 69.806% ############# ( 2, 3 ] 10260 17.852% 87.658% #### ( 3, 4 ] 2901 5.048% 92.706% # ( 4, 6 ] 3313 5.765% 98.471% # ( 6, 10 ] 626 1.089% 99.560% ( 10, 15 ] 144 0.251% 99.810% ( 15, 22 ] 39 0.068% 99.878% ( 22, 34 ] 5 0.009% 99.887% ( 34, 51 ] 2 0.003% 99.890% ( 110, 170 ] 3 0.005% 99.896% ( 170, 250 ] 4 0.007% 99.903% ( 250, 380 ] 5 0.009% 99.911% ( 380, 580 ] 8 0.014% 99.925% ( 580, 870 ] 12 0.021% 99.946% ( 870, 1300 ] 5 0.009% 99.955% ( 1300, 1900 ] 3 0.005% 99.960% ( 1900, 2900 ] 6 0.010% 99.970% ( 2900, 4400 ] 2 0.003% 99.974% ( 4400, 6600 ] 11 0.019% 99.993% ( 6600, 9900 ] 10 0.017% 100.010% ** Level 4 read latency histogram (micros): Count: 15 Average: 4293.8667 StdDev: 2622.46 Min: 870 Median: 4871.4286 Max: 9016 Percentiles: P50: 4871.43 P75: 6050.00 P99: 9016.00 P99.9: 9016.00 P99.99: 9016.00 ------------------------------------------------------ ( 580, 870 ] 1 6.667% 6.667% # ( 870, 1300 ] 1 6.667% 13.333% # ( 1300, 1900 ] 3 20.000% 33.333% #### ( 1900, 2900 ] 1 6.667% 40.000% # ( 4400, 6600 ] 7 46.667% 86.667% ######### ( 6600, 9900 ] 2 13.333% 100.000% ### ** Level 5 read latency histogram (micros): Count: 40 Average: 762.2750 StdDev: 952.53 Min: 76 Median: 165.0000 Max: 3209 Percentiles: P50: 165.00 P75: 1300.00 P99: 3209.00 P99.9: 3209.00 P99.99: 3209.00 ------------------------------------------------------ ( 51, 76 ] 1 2.500% 2.500% # ( 76, 110 ] 8 20.000% 22.500% #### ( 110, 170 ] 12 30.000% 52.500% ###### ( 170, 250 ] 1 2.500% 55.000% # ( 250, 380 ] 1 2.500% 57.500% # ( 380, 580 ] 2 5.000% 62.500% # ( 580, 870 ] 4 10.000% 72.500% ## ( 870, 1300 ] 1 2.500% 75.000% # ( 1300, 1900 ] 3 7.500% 82.500% ## ( 1900, 2900 ] 6 15.000% 97.500% ### ( 2900, 4400 ] 1 2.500% 100.000% # ** DB Stats ** Uptime(secs): 12.3 total, 3.4 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 319.23 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.739 H:M:S, 14.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 290.19 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.783 H:M:S, 23.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/30-00:13:56 ... thread 0: (1000000,5000000) ops and (354110.3,334014.6) ops/second in (2.823979,14.969404) 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/16 2.70 GB 0.0 3.2 0.0 3.2 7.9 4.7 0.0 1.7 127.1 312.8 25.77 24.08 80 0.322 3326K 3413 0.0 0.0 L1 12/12 1.35 GB 0.0 1.7 1.7 0.0 1.7 1.7 0.2 1.0 231.5 230.4 7.63 7.37 2 3.813 1792K 8761 0.0 0.0 L2 2/0 54.91 MB 0.5 0.4 0.2 0.2 0.4 0.2 0.5 2.0 251.7 251.6 1.50 1.46 2 0.751 383K 209 0.0 0.0 L3 42/0 998.95 MB 1.0 0.8 0.6 0.2 0.8 0.6 0.1 1.4 201.0 200.7 3.96 3.50 3 1.321 808K 892 0.0 0.0 L4 144/0 9.47 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1048/0 86.25 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/28 100.80 GB 0.0 6.1 2.5 3.6 10.7 7.1 2.1 2.3 160.0 282.8 38.86 36.41 87 0.447 6311K 13K 0.0 0.0 Int 0/0 0.00 KB 0.0 6.1 2.5 3.6 10.7 7.1 2.1 2.3 160.0 282.8 38.86 36.41 87 0.447 6311K 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.1 2.5 3.6 6.1 2.5 0.0 0.0 244.5 244.0 25.42 24.42 19 1.338 6311K 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 356.3 13.44 11.98 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.2 total, 15.0 interval Flush(GB): cumulative 4.676, interval 4.676 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 10.73 GB write, 725.11 MB/s write, 6.07 GB read, 410.12 MB/s read, 38.9 seconds Interval compaction: 10.73 GB write, 734.08 MB/s write, 6.07 GB read, 415.19 MB/s read, 38.9 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 4, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 4, 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: 4, total-stops: 12, interval: 16 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1368408 Average: 2.2162 StdDev: 13.38 Min: 1 Median: 1.4802 Max: 6367 Percentiles: P50: 1.48 P75: 1.85 P99: 5.62 P99.9: 10.87 P99.99: 78.12 ------------------------------------------------------ [ 0, 1 ] 243919 17.825% 17.825% #### ( 1, 2 ] 916826 66.999% 84.824% ############# ( 2, 3 ] 126415 9.238% 94.063% ## ( 3, 4 ] 42747 3.124% 97.186% # ( 4, 6 ] 30592 2.236% 99.422% ( 6, 10 ] 6320 0.462% 99.884% ( 10, 15 ] 1280 0.094% 99.977% ( 15, 22 ] 135 0.010% 99.987% ( 22, 34 ] 18 0.001% 99.989% ( 34, 51 ] 5 0.000% 99.989% ( 51, 76 ] 10 0.001% 99.990% ( 76, 110 ] 99 0.007% 99.997% ( 110, 170 ] 149 0.011% 100.008% ( 170, 250 ] 77 0.006% 100.013% ( 250, 380 ] 32 0.002% 100.016% ( 380, 580 ] 45 0.003% 100.019% ( 580, 870 ] 34 0.002% 100.022% ( 870, 1300 ] 20 0.001% 100.023% ( 1300, 1900 ] 7 0.001% 100.024% ( 1900, 2900 ] 6 0.000% 100.024% ( 2900, 4400 ] 6 0.000% 100.024% ( 4400, 6600 ] 2 0.000% 100.025% ** Level 1 read latency histogram (micros): Count: 95448 Average: 3.0341 StdDev: 30.88 Min: 1 Median: 1.6435 Max: 5558 Percentiles: P50: 1.64 P75: 2.16 P99: 7.69 P99.9: 104.87 P99.99: 540.85 ------------------------------------------------------ [ 0, 1 ] 9028 9.459% 9.459% ## ( 1, 2 ] 60136 63.004% 72.462% ############# ( 2, 3 ] 15391 16.125% 88.588% ### ( 3, 4 ] 4622 4.842% 93.430% # ( 4, 6 ] 4897 5.131% 98.560% # ( 6, 10 ] 992 1.039% 99.600% ( 10, 15 ] 215 0.225% 99.825% ( 15, 22 ] 18 0.019% 99.844% ( 22, 34 ] 2 0.002% 99.846% ( 34, 51 ] 1 0.001% 99.847% ( 51, 76 ] 3 0.003% 99.850% ( 76, 110 ] 56 0.059% 99.909% ( 110, 170 ] 39 0.041% 99.950% ( 170, 250 ] 17 0.018% 99.968% ( 250, 380 ] 11 0.012% 99.979% ( 380, 580 ] 13 0.014% 99.993% ( 580, 870 ] 9 0.009% 100.002% ( 870, 1300 ] 6 0.006% 100.008% ( 1300, 1900 ] 4 0.004% 100.013% ( 1900, 2900 ] 3 0.003% 100.016% ( 2900, 4400 ] 1 0.001% 100.017% ( 4400, 6600 ] 1 0.001% 100.018% ** Level 2 read latency histogram (micros): Count: 95419 Average: 2.2222 StdDev: 29.42 Min: 0 Median: 1.4151 Max: 6380 Percentiles: P50: 1.42 P75: 1.81 P99: 5.66 P99.9: 9.90 P99.99: 313.18 ------------------------------------------------------ [ 0, 1 ] 22639 23.726% 23.726% ##### ( 1, 2 ] 60400 63.300% 87.026% ############# ( 2, 3 ] 6645 6.964% 93.990% # ( 3, 4 ] 2996 3.140% 97.130% # ( 4, 6 ] 2144 2.247% 99.376% ( 6, 10 ] 512 0.537% 99.913% ( 10, 15 ] 56 0.059% 99.972% ( 15, 22 ] 9 0.009% 99.981% ( 22, 34 ] 2 0.002% 99.983% ( 34, 51 ] 3 0.003% 99.986% ( 51, 76 ] 2 0.002% 99.988% ( 250, 380 ] 3 0.003% 99.992% ( 580, 870 ] 1 0.001% 99.993% ( 870, 1300 ] 3 0.003% 99.996% ( 1300, 1900 ] 1 0.001% 99.997% ( 1900, 2900 ] 1 0.001% 99.998% ( 4400, 6600 ] 2 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 57472 Average: 5.7071 StdDev: 132.54 Min: 0 Median: 1.6846 Max: 7987 Percentiles: P50: 1.68 P75: 2.29 P99: 7.94 P99.9: 220.56 P99.99: 6250.56 ------------------------------------------------------ [ 0, 1 ] 4033 7.017% 7.017% # ( 1, 2 ] 36086 62.789% 69.806% ############# ( 2, 3 ] 10260 17.852% 87.658% #### ( 3, 4 ] 2901 5.048% 92.706% # ( 4, 6 ] 3313 5.765% 98.471% # ( 6, 10 ] 626 1.089% 99.560% ( 10, 15 ] 144 0.251% 99.810% ( 15, 22 ] 39 0.068% 99.878% ( 22, 34 ] 5 0.009% 99.887% ( 34, 51 ] 2 0.003% 99.890% ( 110, 170 ] 3 0.005% 99.896% ( 170, 250 ] 4 0.007% 99.903% ( 250, 380 ] 5 0.009% 99.911% ( 380, 580 ] 8 0.014% 99.925% ( 580, 870 ] 12 0.021% 99.946% ( 870, 1300 ] 5 0.009% 99.955% ( 1300, 1900 ] 3 0.005% 99.960% ( 1900, 2900 ] 6 0.010% 99.970% ( 2900, 4400 ] 2 0.003% 99.974% ( 4400, 6600 ] 11 0.019% 99.993% ( 6600, 9900 ] 10 0.017% 100.010% ** Level 4 read latency histogram (micros): Count: 15 Average: 4293.8667 StdDev: 2622.46 Min: 870 Median: 4871.4286 Max: 9016 Percentiles: P50: 4871.43 P75: 6050.00 P99: 9016.00 P99.9: 9016.00 P99.99: 9016.00 ------------------------------------------------------ ( 580, 870 ] 1 6.667% 6.667% # ( 870, 1300 ] 1 6.667% 13.333% # ( 1300, 1900 ] 3 20.000% 33.333% #### ( 1900, 2900 ] 1 6.667% 40.000% # ( 4400, 6600 ] 7 46.667% 86.667% ######### ( 6600, 9900 ] 2 13.333% 100.000% ### ** Level 5 read latency histogram (micros): Count: 40 Average: 762.2750 StdDev: 952.53 Min: 76 Median: 165.0000 Max: 3209 Percentiles: P50: 165.00 P75: 1300.00 P99: 3209.00 P99.9: 3209.00 P99.99: 3209.00 ------------------------------------------------------ ( 51, 76 ] 1 2.500% 2.500% # ( 76, 110 ] 8 20.000% 22.500% #### ( 110, 170 ] 12 30.000% 52.500% ###### ( 170, 250 ] 1 2.500% 55.000% # ( 250, 380 ] 1 2.500% 57.500% # ( 380, 580 ] 2 5.000% 62.500% # ( 580, 870 ] 4 10.000% 72.500% ## ( 870, 1300 ] 1 2.500% 75.000% # ( 1300, 1900 ] 3 7.500% 82.500% ## ( 1900, 2900 ] 6 15.000% 97.500% ### ( 2900, 4400 ] 1 2.500% 100.000% # ** DB Stats ** Uptime(secs): 15.2 total, 2.8 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 324.68 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.003 H:M:S, 13.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 348.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.264 H:M:S, 9.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/30-00:14:00 ... thread 0: (1000000,6000000) ops and (218106.6,306837.6) ops/second in (4.584914,19.554318) 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/12 3.69 GB 125.9 4.3 0.0 4.3 10.0 5.7 0.0 1.8 134.0 309.9 32.91 30.82 98 0.336 4477K 4657 0.0 0.0 L1 12/12 1.35 GB 0.0 1.7 1.7 0.0 1.7 1.7 0.2 1.0 231.5 230.4 7.63 7.37 2 3.813 1792K 8761 0.0 0.0 L2 2/0 54.91 MB 0.5 0.4 0.2 0.2 0.4 0.2 0.5 2.0 251.7 251.6 1.50 1.46 2 0.751 383K 209 0.0 0.0 L3 42/0 998.95 MB 1.0 0.8 0.6 0.2 0.8 0.6 0.1 1.4 201.0 200.7 3.96 3.50 3 1.321 808K 892 0.0 0.0 L4 144/0 9.47 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1048/0 86.25 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 1266/24 101.78 GB 0.0 7.2 2.5 4.7 12.8 8.1 2.1 2.3 159.8 285.4 46.00 43.15 105 0.438 7462K 14K 0.0 0.0 Int 0/0 0.00 KB 0.0 7.2 2.5 4.7 12.8 8.1 2.1 2.3 159.8 285.4 46.00 43.15 105 0.438 7462K 14K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 7.2 2.5 4.7 7.2 2.4 0.0 0.0 247.7 247.2 29.67 28.59 23 1.290 7462K 14K 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 354.8 16.33 14.55 82 0.199 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 19.7 total, 19.6 interval Flush(GB): cumulative 5.660, interval 5.660 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 12.82 GB write, 665.13 MB/s write, 7.18 GB read, 372.31 MB/s read, 46.0 seconds Interval compaction: 12.82 GB write, 671.43 MB/s write, 7.18 GB read, 375.83 MB/s read, 46.0 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 10, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 10, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 16, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 10, total-stops: 16, interval: 26 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1824913 Average: 2.2210 StdDev: 12.68 Min: 1 Median: 1.4869 Max: 6367 Percentiles: P50: 1.49 P75: 1.86 P99: 5.63 P99.9: 10.66 P99.99: 78.69 ------------------------------------------------------ [ 0, 1 ] 311501 17.069% 17.069% ### ( 1, 2 ] 1234144 67.628% 84.697% ############## ( 2, 3 ] 172000 9.425% 94.122% ## ( 3, 4 ] 56607 3.102% 97.224% # ( 4, 6 ] 39887 2.186% 99.410% ( 6, 10 ] 8733 0.479% 99.888% ( 10, 15 ] 1635 0.090% 99.978% ( 15, 22 ] 172 0.009% 99.987% ( 22, 34 ] 22 0.001% 99.988% ( 34, 51 ] 8 0.000% 99.989% ( 51, 76 ] 12 0.001% 99.989% ( 76, 110 ] 133 0.007% 99.997% ( 110, 170 ] 206 0.011% 100.008% ( 170, 250 ] 95 0.005% 100.013% ( 250, 380 ] 40 0.002% 100.015% ( 380, 580 ] 64 0.004% 100.019% ( 580, 870 ] 45 0.002% 100.021% ( 870, 1300 ] 27 0.001% 100.023% ( 1300, 1900 ] 11 0.001% 100.024% ( 1900, 2900 ] 7 0.000% 100.024% ( 2900, 4400 ] 7 0.000% 100.024% ( 4400, 6600 ] 2 0.000% 100.024% ** Level 1 read latency histogram (micros): Count: 188841 Average: 2.8103 StdDev: 22.97 Min: 1 Median: 1.5856 Max: 5558 Percentiles: P50: 1.59 P75: 1.96 P99: 8.23 P99.9: 131.62 P99.99: 504.91 ------------------------------------------------------ [ 0, 1 ] 21367 11.315% 11.315% ## ( 1, 2 ] 124742 66.057% 77.371% ############# ( 2, 3 ] 25280 13.387% 90.758% ### ( 3, 4 ] 7256 3.842% 94.601% # ( 4, 6 ] 6888 3.648% 98.248% # ( 6, 10 ] 2552 1.351% 99.600% ( 10, 15 ] 381 0.202% 99.801% ( 15, 22 ] 32 0.017% 99.818% ( 22, 34 ] 3 0.002% 99.820% ( 34, 51 ] 1 0.001% 99.820% ( 51, 76 ] 4 0.002% 99.823% ( 76, 110 ] 95 0.050% 99.873% ( 110, 170 ] 142 0.075% 99.948% ( 170, 250 ] 40 0.021% 99.969% ( 250, 380 ] 26 0.014% 99.983% ( 380, 580 ] 21 0.011% 99.994% ( 580, 870 ] 13 0.007% 100.001% ( 870, 1300 ] 6 0.003% 100.004% ( 1300, 1900 ] 4 0.002% 100.006% ( 1900, 2900 ] 3 0.002% 100.008% ( 2900, 4400 ] 1 0.001% 100.008% ( 4400, 6600 ] 1 0.001% 100.009% ** Level 2 read latency histogram (micros): Count: 95419 Average: 2.2222 StdDev: 29.42 Min: 0 Median: 1.4151 Max: 6380 Percentiles: P50: 1.42 P75: 1.81 P99: 5.66 P99.9: 9.90 P99.99: 313.18 ------------------------------------------------------ [ 0, 1 ] 22639 23.726% 23.726% ##### ( 1, 2 ] 60400 63.300% 87.026% ############# ( 2, 3 ] 6645 6.964% 93.990% # ( 3, 4 ] 2996 3.140% 97.130% # ( 4, 6 ] 2144 2.247% 99.376% ( 6, 10 ] 512 0.537% 99.913% ( 10, 15 ] 56 0.059% 99.972% ( 15, 22 ] 9 0.009% 99.981% ( 22, 34 ] 2 0.002% 99.983% ( 34, 51 ] 3 0.003% 99.986% ( 51, 76 ] 2 0.002% 99.988% ( 250, 380 ] 3 0.003% 99.992% ( 580, 870 ] 1 0.001% 99.993% ( 870, 1300 ] 3 0.003% 99.996% ( 1300, 1900 ] 1 0.001% 99.997% ( 1900, 2900 ] 1 0.001% 99.998% ( 4400, 6600 ] 2 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 57472 Average: 5.7071 StdDev: 132.54 Min: 0 Median: 1.6846 Max: 7987 Percentiles: P50: 1.68 P75: 2.29 P99: 7.94 P99.9: 220.56 P99.99: 6250.56 ------------------------------------------------------ [ 0, 1 ] 4033 7.017% 7.017% # ( 1, 2 ] 36086 62.789% 69.806% ############# ( 2, 3 ] 10260 17.852% 87.658% #### ( 3, 4 ] 2901 5.048% 92.706% # ( 4, 6 ] 3313 5.765% 98.471% # ( 6, 10 ] 626 1.089% 99.560% ( 10, 15 ] 144 0.251% 99.810% ( 15, 22 ] 39 0.068% 99.878% ( 22, 34 ] 5 0.009% 99.887% ( 34, 51 ] 2 0.003% 99.890% ( 110, 170 ] 3 0.005% 99.896% ( 170, 250 ] 4 0.007% 99.903% ( 250, 380 ] 5 0.009% 99.911% ( 380, 580 ] 8 0.014% 99.925% ( 580, 870 ] 12 0.021% 99.946% ( 870, 1300 ] 5 0.009% 99.955% ( 1300, 1900 ] 3 0.005% 99.960% ( 1900, 2900 ] 6 0.010% 99.970% ( 2900, 4400 ] 2 0.003% 99.974% ( 4400, 6600 ] 11 0.019% 99.993% ( 6600, 9900 ] 10 0.017% 100.010% ** Level 4 read latency histogram (micros): Count: 15 Average: 4293.8667 StdDev: 2622.46 Min: 870 Median: 4871.4286 Max: 9016 Percentiles: P50: 4871.43 P75: 6050.00 P99: 9016.00 P99.9: 9016.00 P99.99: 9016.00 ------------------------------------------------------ ( 580, 870 ] 1 6.667% 6.667% # ( 870, 1300 ] 1 6.667% 13.333% # ( 1300, 1900 ] 3 20.000% 33.333% #### ( 1900, 2900 ] 1 6.667% 40.000% # ( 4400, 6600 ] 7 46.667% 86.667% ######### ( 6600, 9900 ] 2 13.333% 100.000% ### ** Level 5 read latency histogram (micros): Count: 40 Average: 762.2750 StdDev: 952.53 Min: 76 Median: 165.0000 Max: 3209 Percentiles: P50: 165.00 P75: 1300.00 P99: 3209.00 P99.9: 3209.00 P99.99: 3209.00 ------------------------------------------------------ ( 51, 76 ] 1 2.500% 2.500% # ( 76, 110 ] 8 20.000% 22.500% #### ( 110, 170 ] 12 30.000% 52.500% ###### ( 170, 250 ] 1 2.500% 55.000% # ( 250, 380 ] 1 2.500% 57.500% # ( 380, 580 ] 2 5.000% 62.500% # ( 580, 870 ] 4 10.000% 72.500% ## ( 870, 1300 ] 1 2.500% 75.000% # ( 1300, 1900 ] 3 7.500% 82.500% ## ( 1900, 2900 ] 6 15.000% 97.500% ### ( 2900, 4400 ] 1 2.500% 100.000% # ** DB Stats ** Uptime(secs): 19.7 total, 4.6 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 299.13 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:4.000 H:M:S, 20.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 214.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:1.997 H:M:S, 43.6 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/11/30-00:14:17 ... thread 0: (1000000,7000000) ops and (60924.7,194617.3) ops/second in (16.413705,35.968023) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 9/7 2.14 GB 12.6 6.2 0.0 6.2 12.7 6.6 0.0 1.9 140.1 289.7 44.96 40.49 114 0.394 6395K 13K 0.0 0.0 L1 12/12 1.23 GB 0.0 5.5 4.2 1.3 5.5 4.1 0.2 1.3 221.6 218.7 25.55 23.92 3 8.518 5749K 72K 0.0 0.0 L2 1/1 1.96 MB 0.0 0.4 0.2 0.2 0.4 0.2 3.0 2.0 251.7 251.6 1.50 1.46 2 0.751 383K 209 0.0 0.0 L3 24/9 1.69 GB 1.0 1.6 1.2 0.4 1.6 1.2 2.0 1.3 148.8 148.5 11.21 7.52 9 1.246 1667K 3132 0.0 0.0 L4 163/0 9.66 GB 1.0 1.8 1.4 0.4 1.8 1.4 1.0 1.3 120.2 119.7 15.67 8.80 15 1.045 1893K 7459 0.0 0.0 L5 1068/0 87.91 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 1277/29 102.62 GB 0.0 15.5 7.0 8.5 22.0 13.5 8.6 3.3 160.7 227.8 98.91 82.19 143 0.692 16M 96K 0.0 0.0 Int 0/0 0.00 KB 0.0 15.5 7.0 8.5 22.0 13.5 8.6 3.3 160.7 227.8 98.91 82.19 143 0.692 16M 96K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 15.5 7.0 8.5 15.4 6.9 0.0 0.0 203.4 202.1 78.13 65.07 48 1.628 16M 96K 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 324.4 20.78 17.12 95 0.219 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): 36.2 total, 36.0 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: 22.01 GB write, 623.27 MB/s write, 15.52 GB read, 439.54 MB/s read, 98.9 seconds Interval compaction: 22.01 GB write, 626.48 MB/s write, 15.52 GB read, 441.80 MB/s read, 98.9 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 14, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 14, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 33, pending-compaction-bytes-delays: 6, pending-compaction-bytes-stops: 0, total-delays: 20, total-stops: 33, interval: 53 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2914812 Average: 2.9073 StdDev: 31.20 Min: 0 Median: 1.4998 Max: 20238 Percentiles: P50: 1.50 P75: 1.88 P99: 7.26 P99.9: 155.85 P99.99: 398.21 ------------------------------------------------------ [ 0, 1 ] 491230 16.853% 16.853% ### ( 1, 2 ] 1932939 66.314% 83.167% ############# ( 2, 3 ] 281785 9.667% 92.835% ## ( 3, 4 ] 96939 3.326% 96.160% # ( 4, 6 ] 75329 2.584% 98.745% # ( 6, 10 ] 23610 0.810% 99.555% ( 10, 15 ] 3547 0.122% 99.676% ( 15, 22 ] 548 0.019% 99.695% ( 22, 34 ] 44 0.002% 99.697% ( 34, 51 ] 14 0.000% 99.697% ( 51, 76 ] 18 0.001% 99.698% ( 76, 110 ] 2418 0.083% 99.781% ( 110, 170 ] 4550 0.156% 99.937% ( 170, 250 ] 974 0.033% 99.970% ( 250, 380 ] 534 0.018% 99.989% ( 380, 580 ] 467 0.016% 100.005% ( 580, 870 ] 240 0.008% 100.013% ( 870, 1300 ] 98 0.003% 100.016% ( 1300, 1900 ] 55 0.002% 100.018% ( 1900, 2900 ] 59 0.002% 100.020% ( 2900, 4400 ] 50 0.002% 100.022% ( 4400, 6600 ] 14 0.000% 100.022% ( 6600, 9900 ] 4 0.000% 100.022% ( 9900, 14000 ] 2 0.000% 100.023% ( 14000, 22000 ] 1 0.000% 100.023% ** Level 1 read latency histogram (micros): Count: 869333 Average: 5.6773 StdDev: 99.30 Min: 1 Median: 1.7171 Max: 22214 Percentiles: P50: 1.72 P75: 2.53 P99: 9.44 P99.9: 168.05 P99.99: 773.03 ------------------------------------------------------ [ 0, 1 ] 83874 9.648% 9.648% ## ( 1, 2 ] 489204 56.273% 65.922% ########### ( 2, 3 ] 147730 16.993% 82.915% ### ( 3, 4 ] 58196 6.694% 89.609% # ( 4, 6 ] 66256 7.621% 97.231% ## ( 6, 10 ] 17867 2.055% 99.286% ( 10, 15 ] 3551 0.408% 99.695% ( 15, 22 ] 476 0.055% 99.749% ( 22, 34 ] 52 0.006% 99.755% ( 34, 51 ] 9 0.001% 99.756% ( 51, 76 ] 8 0.001% 99.757% ( 76, 110 ] 517 0.059% 99.817% ( 110, 170 ] 748 0.086% 99.903% ( 170, 250 ] 167 0.019% 99.922% ( 250, 380 ] 171 0.020% 99.942% ( 380, 580 ] 249 0.029% 99.970% ( 580, 870 ] 257 0.030% 100.000% ( 870, 1300 ] 249 0.029% 100.029% ( 1300, 1900 ] 156 0.018% 100.046% ( 1900, 2900 ] 182 0.021% 100.067% ( 2900, 4400 ] 191 0.022% 100.089% ( 4400, 6600 ] 63 0.007% 100.097% ( 6600, 9900 ] 9 0.001% 100.098% ( 9900, 14000 ] 3 0.000% 100.098% ( 14000, 22000 ] 3 0.000% 100.098% ( 22000, 33000 ] 1 0.000% 100.098% ** Level 2 read latency histogram (micros): Count: 95765 Average: 3.3225 StdDev: 60.46 Min: 0 Median: 1.4176 Max: 6833 Percentiles: P50: 1.42 P75: 1.81 P99: 5.74 P99.9: 19.07 P99.99: 3470.58 ------------------------------------------------------ [ 0, 1 ] 22639 23.640% 23.640% ##### ( 1, 2 ] 60448 63.121% 86.761% ############# ( 2, 3 ] 6777 7.077% 93.838% # ( 3, 4 ] 3043 3.178% 97.016% # ( 4, 6 ] 2180 2.276% 99.292% ( 6, 10 ] 519 0.542% 99.834% ( 10, 15 ] 58 0.061% 99.895% ( 15, 22 ] 9 0.009% 99.904% ( 22, 34 ] 2 0.002% 99.906% ( 34, 51 ] 3 0.003% 99.909% ( 51, 76 ] 2 0.002% 99.911% ( 76, 110 ] 1 0.001% 99.912% ( 110, 170 ] 1 0.001% 99.913% ( 170, 250 ] 2 0.002% 99.915% ( 250, 380 ] 6 0.006% 99.922% ( 380, 580 ] 15 0.016% 99.937% ( 580, 870 ] 13 0.014% 99.951% ( 870, 1300 ] 17 0.018% 99.969% ( 1300, 1900 ] 8 0.008% 99.977% ( 1900, 2900 ] 9 0.009% 99.986% ( 2900, 4400 ] 9 0.009% 99.996% ( 4400, 6600 ] 3 0.003% 99.999% ( 6600, 9900 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 412523 Average: 12.5628 StdDev: 152.01 Min: 0 Median: 1.9032 Max: 20896 Percentiles: P50: 1.90 P75: 2.94 P99: 12.70 P99.9: 1006.77 P99.99: 1292.87 ------------------------------------------------------ [ 0, 1 ] 15063 3.651% 3.651% # ( 1, 2 ] 211696 51.317% 54.969% ########## ( 2, 3 ] 88210 21.383% 76.352% #### ( 3, 4 ] 39720 9.629% 85.980% ## ( 4, 6 ] 43368 10.513% 96.493% ## ( 6, 10 ] 9302 2.255% 98.748% ( 10, 15 ] 1923 0.466% 99.214% ( 15, 22 ] 291 0.071% 99.285% ( 22, 34 ] 30 0.007% 99.292% ( 34, 51 ] 10 0.002% 99.295% ( 51, 76 ] 4 0.001% 99.296% ( 76, 110 ] 65 0.016% 99.311% ( 110, 170 ] 134 0.032% 99.344% ( 170, 250 ] 275 0.067% 99.410% ( 250, 380 ] 435 0.105% 99.516% ( 380, 580 ] 662 0.160% 99.676% ( 580, 870 ] 745 0.181% 99.857% ( 870, 1300 ] 558 0.135% 99.992% ( 1300, 1900 ] 303 0.073% 100.066% ( 1900, 2900 ] 243 0.059% 100.125% ( 2900, 4400 ] 212 0.051% 100.176% ( 4400, 6600 ] 77 0.019% 100.195% ( 6600, 9900 ] 20 0.005% 100.200% ( 9900, 14000 ] 1 0.000% 100.200% ( 14000, 22000 ] 1 0.000% 100.200% ** Level 4 read latency histogram (micros): Count: 33103 Average: 6.5316 StdDev: 119.67 Min: 1 Median: 2.0096 Max: 9016 Percentiles: P50: 2.01 P75: 3.03 P99: 8.84 P99.9: 838.01 P99.99: 5245.33 ------------------------------------------------------ [ 0, 1 ] 542 1.637% 1.637% ( 1, 2 ] 15930 48.123% 49.760% ########## ( 2, 3 ] 8261 24.955% 74.715% ##### ( 3, 4 ] 3467 10.473% 85.189% ## ( 4, 6 ] 4158 12.561% 97.749% ### ( 6, 10 ] 583 1.761% 99.511% ( 10, 15 ] 65 0.196% 99.707% ( 15, 22 ] 10 0.030% 99.737% ( 22, 34 ] 7 0.021% 99.758% ( 34, 51 ] 2 0.006% 99.764% ( 51, 76 ] 3 0.009% 99.773% ( 76, 110 ] 4 0.012% 99.786% ( 110, 170 ] 1 0.003% 99.789% ( 170, 250 ] 22 0.066% 99.855% ( 250, 380 ] 3 0.009% 99.864% ( 380, 580 ] 3 0.009% 99.873% ( 580, 870 ] 10 0.030% 99.903% ( 870, 1300 ] 9 0.027% 99.931% ( 1300, 1900 ] 9 0.027% 99.958% ( 1900, 2900 ] 4 0.012% 99.970% ( 2900, 4400 ] 4 0.012% 99.982% ( 4400, 6600 ] 7 0.021% 100.003% ( 6600, 9900 ] 2 0.006% 100.009% ** Level 5 read latency histogram (micros): Count: 140 Average: 1341.5143 StdDev: 1538.64 Min: 76 Median: 659.0909 Max: 7753 Percentiles: P50: 659.09 P75: 2177.78 P99: 7590.00 P99.9: 7753.00 P99.99: 7753.00 ------------------------------------------------------ ( 51, 76 ] 1 0.714% 0.714% ( 76, 110 ] 14 10.000% 10.714% ## ( 110, 170 ] 19 13.571% 24.286% ### ( 170, 250 ] 10 7.143% 31.429% # ( 250, 380 ] 15 10.714% 42.143% ## ( 380, 580 ] 8 5.714% 47.857% # ( 580, 870 ] 11 7.857% 55.714% ## ( 870, 1300 ] 10 7.143% 62.857% # ( 1300, 1900 ] 12 8.571% 71.429% ## ( 1900, 2900 ] 18 12.857% 84.286% ### ( 2900, 4400 ] 16 11.429% 95.714% ## ( 4400, 6600 ] 4 2.857% 98.571% # ( 6600, 9900 ] 2 1.429% 100.000% ** DB Stats ** Uptime(secs): 36.2 total, 16.4 interval Cumulative writes: 0 writes, 7000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 6.73 GB, 190.55 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:17.528 H:M:S, 48.5 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 59.96 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:13.528 H:M:S, 82.4 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/11/30-00:14:20 ... thread 0: (1000000,8000000) ops and (320104.1,204645.4) ops/second in (3.123984,39.092007) 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 14/11 3.13 GB 94.4 7.1 0.0 7.1 14.6 7.6 0.0 1.9 140.2 290.0 51.65 46.71 131 0.394 7354K 14K 0.0 0.0 L1 12/12 1.23 GB 0.0 5.5 4.2 1.3 5.5 4.1 0.2 1.3 221.6 218.7 25.55 23.92 3 8.518 5749K 72K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 3.0 2.0 251.7 251.6 1.50 1.46 2 0.751 383K 209 0.0 0.0 L3 14/0 975.19 MB 1.0 2.4 1.2 1.1 2.4 1.2 2.0 1.9 152.5 152.2 15.81 10.58 10 1.581 2422K 5122 0.0 0.0 L4 164/0 9.41 GB 1.0 1.8 1.4 0.4 1.8 1.4 1.8 1.3 120.2 119.7 15.67 8.80 15 1.045 1893K 7459 0.0 0.0 L5 1080/0 88.89 GB 0.9 0.0 0.0 0.0 0.0 0.0 3.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1284/23 103.60 GB 0.0 17.2 7.0 10.1 24.6 14.5 10.3 3.3 159.5 228.9 110.19 91.46 161 0.684 17M 99K 0.0 0.0 Int 0/0 0.00 KB 0.0 17.2 7.0 10.1 24.6 14.5 10.3 3.3 159.5 228.9 110.19 91.46 161 0.684 17M 99K 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.2 7.0 10.1 17.1 6.9 0.0 0.0 203.3 202.1 86.48 71.74 52 1.663 17M 99K 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 326.7 23.72 19.72 109 0.218 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 39.3 total, 39.1 interval Flush(GB): cumulative 7.567, interval 7.567 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 24.64 GB write, 642.26 MB/s write, 17.17 GB read, 447.56 MB/s read, 110.2 seconds Interval compaction: 24.64 GB write, 645.30 MB/s write, 17.17 GB read, 449.68 MB/s read, 110.2 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 14, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 14, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 37, pending-compaction-bytes-delays: 6, pending-compaction-bytes-stops: 0, total-delays: 20, total-stops: 37, interval: 57 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3332156 Average: 2.8581 StdDev: 29.61 Min: 0 Median: 1.5176 Max: 20238 Percentiles: P50: 1.52 P75: 1.90 P99: 7.22 P99.9: 147.76 P99.99: 325.36 ------------------------------------------------------ [ 0, 1 ] 525623 15.774% 15.774% ### ( 1, 2 ] 2203264 66.121% 81.896% ############# ( 2, 3 ] 351554 10.550% 92.446% ## ( 3, 4 ] 116303 3.490% 95.936% # ( 4, 6 ] 93441 2.804% 98.740% # ( 6, 10 ] 28366 0.851% 99.592% ( 10, 15 ] 4283 0.129% 99.720% ( 15, 22 ] 610 0.018% 99.739% ( 22, 34 ] 48 0.001% 99.740% ( 34, 51 ] 15 0.000% 99.740% ( 51, 76 ] 20 0.001% 99.741% ( 76, 110 ] 2426 0.073% 99.814% ( 110, 170 ] 4562 0.137% 99.951% ( 170, 250 ] 993 0.030% 99.981% ( 250, 380 ] 543 0.016% 99.997% ( 380, 580 ] 480 0.014% 100.011% ( 580, 870 ] 247 0.007% 100.019% ( 870, 1300 ] 104 0.003% 100.022% ( 1300, 1900 ] 57 0.002% 100.023% ( 1900, 2900 ] 59 0.002% 100.025% ( 2900, 4400 ] 53 0.002% 100.027% ( 4400, 6600 ] 15 0.000% 100.027% ( 6600, 9900 ] 4 0.000% 100.027% ( 9900, 14000 ] 2 0.000% 100.027% ( 14000, 22000 ] 1 0.000% 100.028% ** Level 1 read latency histogram (micros): Count: 893181 Average: 5.6314 StdDev: 98.06 Min: 1 Median: 1.7160 Max: 22214 Percentiles: P50: 1.72 P75: 2.53 P99: 9.45 P99.9: 177.50 P99.99: 777.38 ------------------------------------------------------ [ 0, 1 ] 85508 9.573% 9.573% ## ( 1, 2 ] 504330 56.464% 66.038% ########### ( 2, 3 ] 151791 16.994% 83.032% ### ( 3, 4 ] 59384 6.649% 89.681% # ( 4, 6 ] 67409 7.547% 97.228% ## ( 6, 10 ] 18337 2.053% 99.281% ( 10, 15 ] 3625 0.406% 99.687% ( 15, 22 ] 485 0.054% 99.741% ( 22, 34 ] 53 0.006% 99.747% ( 34, 51 ] 10 0.001% 99.748% ( 51, 76 ] 8 0.001% 99.749% ( 76, 110 ] 548 0.061% 99.810% ( 110, 170 ] 782 0.088% 99.898% ( 170, 250 ] 190 0.021% 99.919% ( 250, 380 ] 188 0.021% 99.940% ( 380, 580 ] 264 0.030% 99.970% ( 580, 870 ] 264 0.030% 99.999% ( 870, 1300 ] 252 0.028% 100.028% ( 1300, 1900 ] 157 0.018% 100.045% ( 1900, 2900 ] 182 0.020% 100.066% ( 2900, 4400 ] 191 0.021% 100.087% ( 4400, 6600 ] 63 0.007% 100.094% ( 6600, 9900 ] 9 0.001% 100.095% ( 9900, 14000 ] 3 0.000% 100.095% ( 14000, 22000 ] 3 0.000% 100.096% ( 22000, 33000 ] 1 0.000% 100.096% ** Level 2 read latency histogram (micros): Count: 111915 Average: 3.3976 StdDev: 56.98 Min: 0 Median: 1.4664 Max: 6833 Percentiles: P50: 1.47 P75: 1.87 P99: 6.21 P99.9: 195.62 P99.99: 3201.42 ------------------------------------------------------ [ 0, 1 ] 23395 20.904% 20.904% #### ( 1, 2 ] 69824 62.390% 83.294% ############ ( 2, 3 ] 9917 8.861% 92.156% ## ( 3, 4 ] 4294 3.837% 95.992% # ( 4, 6 ] 3321 2.967% 98.960% # ( 6, 10 ] 871 0.778% 99.738% ( 10, 15 ] 113 0.101% 99.839% ( 15, 22 ] 11 0.010% 99.849% ( 22, 34 ] 2 0.002% 99.851% ( 34, 51 ] 3 0.003% 99.853% ( 51, 76 ] 2 0.002% 99.855% ( 76, 110 ] 23 0.021% 99.876% ( 110, 170 ] 21 0.019% 99.895% ( 170, 250 ] 19 0.017% 99.912% ( 250, 380 ] 15 0.013% 99.925% ( 380, 580 ] 19 0.017% 99.942% ( 580, 870 ] 17 0.015% 99.957% ( 870, 1300 ] 17 0.015% 99.972% ( 1300, 1900 ] 8 0.007% 99.979% ( 1900, 2900 ] 10 0.009% 99.988% ( 2900, 4400 ] 9 0.008% 99.996% ( 4400, 6600 ] 3 0.003% 99.999% ( 6600, 9900 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 444537 Average: 11.8850 StdDev: 146.57 Min: 0 Median: 1.8792 Max: 20896 Percentiles: P50: 1.88 P75: 2.89 P99: 12.14 P99.9: 984.77 P99.99: 1291.97 ------------------------------------------------------ [ 0, 1 ] 17724 3.987% 3.987% # ( 1, 2 ] 232652 52.336% 56.323% ########## ( 2, 3 ] 92798 20.875% 77.198% #### ( 3, 4 ] 41365 9.305% 86.503% ## ( 4, 6 ] 44811 10.080% 96.584% ## ( 6, 10 ] 9890 2.225% 98.808% ( 10, 15 ] 1992 0.448% 99.257% ( 15, 22 ] 294 0.066% 99.323% ( 22, 34 ] 32 0.007% 99.330% ( 34, 51 ] 10 0.002% 99.332% ( 51, 76 ] 4 0.001% 99.333% ( 76, 110 ] 73 0.016% 99.349% ( 110, 170 ] 146 0.033% 99.382% ( 170, 250 ] 285 0.064% 99.446% ( 250, 380 ] 443 0.100% 99.546% ( 380, 580 ] 670 0.151% 99.697% ( 580, 870 ] 754 0.170% 99.866% ( 870, 1300 ] 560 0.126% 99.992% ( 1300, 1900 ] 305 0.069% 100.061% ( 1900, 2900 ] 243 0.055% 100.116% ( 2900, 4400 ] 212 0.048% 100.163% ( 4400, 6600 ] 77 0.017% 100.181% ( 6600, 9900 ] 20 0.004% 100.185% ( 9900, 14000 ] 1 0.000% 100.185% ( 14000, 22000 ] 1 0.000% 100.186% ** Level 4 read latency histogram (micros): Count: 33103 Average: 6.5316 StdDev: 119.67 Min: 1 Median: 2.0096 Max: 9016 Percentiles: P50: 2.01 P75: 3.03 P99: 8.84 P99.9: 838.01 P99.99: 5245.33 ------------------------------------------------------ [ 0, 1 ] 542 1.637% 1.637% ( 1, 2 ] 15930 48.123% 49.760% ########## ( 2, 3 ] 8261 24.955% 74.715% ##### ( 3, 4 ] 3467 10.473% 85.189% ## ( 4, 6 ] 4158 12.561% 97.749% ### ( 6, 10 ] 583 1.761% 99.511% ( 10, 15 ] 65 0.196% 99.707% ( 15, 22 ] 10 0.030% 99.737% ( 22, 34 ] 7 0.021% 99.758% ( 34, 51 ] 2 0.006% 99.764% ( 51, 76 ] 3 0.009% 99.773% ( 76, 110 ] 4 0.012% 99.786% ( 110, 170 ] 1 0.003% 99.789% ( 170, 250 ] 22 0.066% 99.855% ( 250, 380 ] 3 0.009% 99.864% ( 380, 580 ] 3 0.009% 99.873% ( 580, 870 ] 10 0.030% 99.903% ( 870, 1300 ] 9 0.027% 99.931% ( 1300, 1900 ] 9 0.027% 99.958% ( 1900, 2900 ] 4 0.012% 99.970% ( 2900, 4400 ] 4 0.012% 99.982% ( 4400, 6600 ] 7 0.021% 100.003% ( 6600, 9900 ] 2 0.006% 100.009% ** Level 5 read latency histogram (micros): Count: 200 Average: 1227.1150 StdDev: 1432.77 Min: 76 Median: 540.0000 Max: 7753 Percentiles: P50: 540.00 P75: 2015.38 P99: 6600.00 P99.9: 7753.00 P99.99: 7753.00 ------------------------------------------------------ ( 51, 76 ] 1 0.500% 0.500% ( 76, 110 ] 20 10.000% 10.500% ## ( 110, 170 ] 30 15.000% 25.500% ### ( 170, 250 ] 14 7.000% 32.500% # ( 250, 380 ] 27 13.500% 46.000% ### ( 380, 580 ] 10 5.000% 51.000% # ( 580, 870 ] 15 7.500% 58.500% ## ( 870, 1300 ] 15 7.500% 66.000% ## ( 1300, 1900 ] 15 7.500% 73.500% ## ( 1900, 2900 ] 26 13.000% 86.500% ### ( 2900, 4400 ] 21 10.500% 97.000% ## ( 4400, 6600 ] 4 2.000% 99.000% ( 6600, 9900 ] 2 1.000% 100.000% ** DB Stats ** Uptime(secs): 39.3 total, 3.1 interval Cumulative writes: 0 writes, 8000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 7.69 GB, 200.45 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:18.008 H:M:S, 45.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 315.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.480 H:M:S, 15.4 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/11/30-00:14:23 ... thread 0: (1000000,9000000) ops and (321381.9,213252.1) ops/second in (3.111563,42.203570) 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/11 4.05 GB 188.8 7.9 0.0 7.9 16.3 8.5 0.0 1.9 139.9 290.6 57.61 52.28 147 0.392 8186K 14K 0.0 0.0 L1 12/12 1.23 GB 0.0 5.5 4.2 1.3 5.5 4.1 0.2 1.3 221.6 218.7 25.55 23.92 3 8.518 5749K 72K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 3.0 2.0 251.7 251.6 1.50 1.46 2 0.751 383K 209 0.0 0.0 L3 14/0 975.19 MB 1.0 2.4 1.2 1.1 2.4 1.2 2.0 1.9 152.5 152.2 15.81 10.58 10 1.581 2422K 5122 0.0 0.0 L4 164/0 9.41 GB 1.0 1.8 1.4 0.4 1.8 1.4 1.8 1.3 120.2 119.7 15.67 8.80 15 1.045 1893K 7459 0.0 0.0 L5 1080/0 88.89 GB 0.9 0.0 0.0 0.0 0.0 0.0 3.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1288/23 104.53 GB 0.0 18.0 7.0 10.9 26.4 15.4 10.3 3.1 158.4 232.4 116.15 97.03 177 0.656 18M 100K 0.0 0.0 Int 0/0 0.00 KB 0.0 18.0 7.0 10.9 26.4 15.4 10.3 3.1 158.4 232.4 116.15 97.03 177 0.656 18M 100K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 18.0 7.0 10.9 17.9 6.9 0.0 0.0 205.2 204.0 89.68 74.88 55 1.630 18M 100K 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 328.4 26.47 22.16 122 0.217 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 42.4 total, 42.2 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: 26.36 GB write, 636.70 MB/s write, 17.97 GB read, 434.03 MB/s read, 116.1 seconds Interval compaction: 26.36 GB write, 639.49 MB/s write, 17.97 GB read, 435.93 MB/s read, 116.1 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 14, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 14, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 40, pending-compaction-bytes-delays: 6, pending-compaction-bytes-stops: 0, total-delays: 20, total-stops: 40, interval: 60 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3608636 Average: 2.8254 StdDev: 28.73 Min: 0 Median: 1.5215 Max: 20238 Percentiles: P50: 1.52 P75: 1.90 P99: 7.07 P99.9: 144.36 P99.99: 308.67 ------------------------------------------------------ [ 0, 1 ] 558263 15.470% 15.470% ### ( 1, 2 ] 2389530 66.217% 81.687% ############# ( 2, 3 ] 388048 10.753% 92.440% ## ( 3, 4 ] 126381 3.502% 95.943% # ( 4, 6 ] 102258 2.834% 98.776% # ( 6, 10 ] 30146 0.835% 99.612% ( 10, 15 ] 4587 0.127% 99.739% ( 15, 22 ] 631 0.017% 99.756% ( 22, 34 ] 49 0.001% 99.758% ( 34, 51 ] 19 0.001% 99.758% ( 51, 76 ] 22 0.001% 99.759% ( 76, 110 ] 2442 0.068% 99.827% ( 110, 170 ] 4633 0.128% 99.955% ( 170, 250 ] 1019 0.028% 99.983% ( 250, 380 ] 552 0.015% 99.998% ( 380, 580 ] 495 0.014% 100.012% ( 580, 870 ] 259 0.007% 100.019% ( 870, 1300 ] 107 0.003% 100.022% ( 1300, 1900 ] 59 0.002% 100.024% ( 1900, 2900 ] 61 0.002% 100.026% ( 2900, 4400 ] 55 0.002% 100.027% ( 4400, 6600 ] 15 0.000% 100.028% ( 6600, 9900 ] 4 0.000% 100.028% ( 9900, 14000 ] 2 0.000% 100.028% ( 14000, 22000 ] 1 0.000% 100.028% ** Level 1 read latency histogram (micros): Count: 1015521 Average: 5.2890 StdDev: 92.08 Min: 1 Median: 1.6981 Max: 22214 Percentiles: P50: 1.70 P75: 2.45 P99: 9.36 P99.9: 169.96 P99.99: 772.75 ------------------------------------------------------ [ 0, 1 ] 98447 9.694% 9.694% ## ( 1, 2 ] 586360 57.740% 67.434% ############ ( 2, 3 ] 168879 16.630% 84.064% ### ( 3, 4 ] 63035 6.207% 90.271% # ( 4, 6 ] 71465 7.037% 97.308% # ( 6, 10 ] 20459 2.015% 99.323% ( 10, 15 ] 3797 0.374% 99.697% ( 15, 22 ] 499 0.049% 99.746% ( 22, 34 ] 54 0.005% 99.751% ( 34, 51 ] 10 0.001% 99.752% ( 51, 76 ] 14 0.001% 99.754% ( 76, 110 ] 607 0.060% 99.813% ( 110, 170 ] 880 0.087% 99.900% ( 170, 250 ] 239 0.024% 99.924% ( 250, 380 ] 205 0.020% 99.944% ( 380, 580 ] 286 0.028% 99.972% ( 580, 870 ] 276 0.027% 99.999% ( 870, 1300 ] 256 0.025% 100.024% ( 1300, 1900 ] 157 0.015% 100.040% ( 1900, 2900 ] 182 0.018% 100.058% ( 2900, 4400 ] 191 0.019% 100.077% ( 4400, 6600 ] 63 0.006% 100.083% ( 6600, 9900 ] 9 0.001% 100.084% ( 9900, 14000 ] 3 0.000% 100.084% ( 14000, 22000 ] 3 0.000% 100.084% ( 22000, 33000 ] 1 0.000% 100.084% ** Level 2 read latency histogram (micros): Count: 111915 Average: 3.3976 StdDev: 56.98 Min: 0 Median: 1.4664 Max: 6833 Percentiles: P50: 1.47 P75: 1.87 P99: 6.21 P99.9: 195.62 P99.99: 3201.42 ------------------------------------------------------ [ 0, 1 ] 23395 20.904% 20.904% #### ( 1, 2 ] 69824 62.390% 83.294% ############ ( 2, 3 ] 9917 8.861% 92.156% ## ( 3, 4 ] 4294 3.837% 95.992% # ( 4, 6 ] 3321 2.967% 98.960% # ( 6, 10 ] 871 0.778% 99.738% ( 10, 15 ] 113 0.101% 99.839% ( 15, 22 ] 11 0.010% 99.849% ( 22, 34 ] 2 0.002% 99.851% ( 34, 51 ] 3 0.003% 99.853% ( 51, 76 ] 2 0.002% 99.855% ( 76, 110 ] 23 0.021% 99.876% ( 110, 170 ] 21 0.019% 99.895% ( 170, 250 ] 19 0.017% 99.912% ( 250, 380 ] 15 0.013% 99.925% ( 380, 580 ] 19 0.017% 99.942% ( 580, 870 ] 17 0.015% 99.957% ( 870, 1300 ] 17 0.015% 99.972% ( 1300, 1900 ] 8 0.007% 99.979% ( 1900, 2900 ] 10 0.009% 99.988% ( 2900, 4400 ] 9 0.008% 99.996% ( 4400, 6600 ] 3 0.003% 99.999% ( 6600, 9900 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 444537 Average: 11.8850 StdDev: 146.57 Min: 0 Median: 1.8792 Max: 20896 Percentiles: P50: 1.88 P75: 2.89 P99: 12.14 P99.9: 984.77 P99.99: 1291.97 ------------------------------------------------------ [ 0, 1 ] 17724 3.987% 3.987% # ( 1, 2 ] 232652 52.336% 56.323% ########## ( 2, 3 ] 92798 20.875% 77.198% #### ( 3, 4 ] 41365 9.305% 86.503% ## ( 4, 6 ] 44811 10.080% 96.584% ## ( 6, 10 ] 9890 2.225% 98.808% ( 10, 15 ] 1992 0.448% 99.257% ( 15, 22 ] 294 0.066% 99.323% ( 22, 34 ] 32 0.007% 99.330% ( 34, 51 ] 10 0.002% 99.332% ( 51, 76 ] 4 0.001% 99.333% ( 76, 110 ] 73 0.016% 99.349% ( 110, 170 ] 146 0.033% 99.382% ( 170, 250 ] 285 0.064% 99.446% ( 250, 380 ] 443 0.100% 99.546% ( 380, 580 ] 670 0.151% 99.697% ( 580, 870 ] 754 0.170% 99.866% ( 870, 1300 ] 560 0.126% 99.992% ( 1300, 1900 ] 305 0.069% 100.061% ( 1900, 2900 ] 243 0.055% 100.116% ( 2900, 4400 ] 212 0.048% 100.163% ( 4400, 6600 ] 77 0.017% 100.181% ( 6600, 9900 ] 20 0.004% 100.185% ( 9900, 14000 ] 1 0.000% 100.185% ( 14000, 22000 ] 1 0.000% 100.186% ** Level 4 read latency histogram (micros): Count: 33103 Average: 6.5316 StdDev: 119.67 Min: 1 Median: 2.0096 Max: 9016 Percentiles: P50: 2.01 P75: 3.03 P99: 8.84 P99.9: 838.01 P99.99: 5245.33 ------------------------------------------------------ [ 0, 1 ] 542 1.637% 1.637% ( 1, 2 ] 15930 48.123% 49.760% ########## ( 2, 3 ] 8261 24.955% 74.715% ##### ( 3, 4 ] 3467 10.473% 85.189% ## ( 4, 6 ] 4158 12.561% 97.749% ### ( 6, 10 ] 583 1.761% 99.511% ( 10, 15 ] 65 0.196% 99.707% ( 15, 22 ] 10 0.030% 99.737% ( 22, 34 ] 7 0.021% 99.758% ( 34, 51 ] 2 0.006% 99.764% ( 51, 76 ] 3 0.009% 99.773% ( 76, 110 ] 4 0.012% 99.786% ( 110, 170 ] 1 0.003% 99.789% ( 170, 250 ] 22 0.066% 99.855% ( 250, 380 ] 3 0.009% 99.864% ( 380, 580 ] 3 0.009% 99.873% ( 580, 870 ] 10 0.030% 99.903% ( 870, 1300 ] 9 0.027% 99.931% ( 1300, 1900 ] 9 0.027% 99.958% ( 1900, 2900 ] 4 0.012% 99.970% ( 2900, 4400 ] 4 0.012% 99.982% ( 4400, 6600 ] 7 0.021% 100.003% ( 6600, 9900 ] 2 0.006% 100.009% ** Level 5 read latency histogram (micros): Count: 200 Average: 1227.1150 StdDev: 1432.77 Min: 76 Median: 540.0000 Max: 7753 Percentiles: P50: 540.00 P75: 2015.38 P99: 6600.00 P99.9: 7753.00 P99.99: 7753.00 ------------------------------------------------------ ( 51, 76 ] 1 0.500% 0.500% ( 76, 110 ] 20 10.000% 10.500% ## ( 110, 170 ] 30 15.000% 25.500% ### ( 170, 250 ] 14 7.000% 32.500% # ( 250, 380 ] 27 13.500% 46.000% ### ( 380, 580 ] 10 5.000% 51.000% # ( 580, 870 ] 15 7.500% 58.500% ## ( 870, 1300 ] 15 7.500% 66.000% ## ( 1300, 1900 ] 15 7.500% 73.500% ## ( 1900, 2900 ] 26 13.000% 86.500% ### ( 2900, 4400 ] 21 10.500% 97.000% ## ( 4400, 6600 ] 4 2.000% 99.000% ( 6600, 9900 ] 2 1.000% 100.000% ** DB Stats ** Uptime(secs): 42.4 total, 3.1 interval Cumulative writes: 0 writes, 9000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 8.65 GB, 208.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:18.479 H:M:S, 43.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 316.31 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.472 H:M:S, 15.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 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.140 micros/op 162857 ops/sec 60.016 seconds 9773999 operations; 157.8 MB/s Microseconds per write: Count: 9773999 Average: 6.1403 StdDev: 457.28 Min: 0 Median: 1.7331 Max: 838132 Percentiles: P50: 1.73 P75: 2.70 P99: 8.28 P99.9: 1195.18 P99.99: 2746.71 ------------------------------------------------------ [ 0, 1 ] 1300109 13.302% 13.302% ### ( 1, 2 ] 4892549 50.057% 63.358% ########## ( 2, 3 ] 1622120 16.596% 79.955% ### ( 3, 4 ] 1334215 13.651% 93.605% ### ( 4, 6 ] 480481 4.916% 98.521% # ( 6, 10 ] 82025 0.839% 99.361% ( 10, 15 ] 23677 0.242% 99.603% ( 15, 22 ] 6456 0.066% 99.669% ( 22, 34 ] 1197 0.012% 99.681% ( 34, 51 ] 155 0.002% 99.683% ( 51, 76 ] 20 0.000% 99.683% ( 76, 110 ] 7232 0.074% 99.757% ( 110, 170 ] 2346 0.024% 99.781% ( 170, 250 ] 220 0.002% 99.783% ( 250, 380 ] 92 0.001% 99.784% ( 380, 580 ] 17 0.000% 99.784% ( 580, 870 ] 18 0.000% 99.784% ( 870, 1300 ] 14937 0.153% 99.937% ( 1300, 1900 ] 22 0.000% 99.937% ( 1900, 2900 ] 6063 0.062% 100.000% ( 2900, 4400 ] 14 0.000% 100.000% ( 4400, 6600 ] 7 0.000% 100.000% ( 6600, 9900 ] 1 0.000% 100.000% ( 9900, 14000 ] 1 0.000% 100.000% ( 14000, 22000 ] 4 0.000% 100.000% ( 22000, 33000 ] 1 0.000% 100.000% ( 33000, 50000 ] 1 0.000% 100.000% ( 75000, 110000 ] 1 0.000% 100.000% ( 170000, 250000 ] 16 0.000% 100.000% ( 570000, 860000 ] 2 0.000% 100.000% STATISTICS: rocksdb.block.cache.miss COUNT : 0 rocksdb.block.cache.hit COUNT : 0 rocksdb.block.cache.add COUNT : 0 rocksdb.block.cache.add.failures COUNT : 0 rocksdb.block.cache.index.miss COUNT : 0 rocksdb.block.cache.index.hit COUNT : 0 rocksdb.block.cache.index.add COUNT : 0 rocksdb.block.cache.index.bytes.insert COUNT : 0 rocksdb.block.cache.filter.miss COUNT : 0 rocksdb.block.cache.filter.hit COUNT : 0 rocksdb.block.cache.filter.add COUNT : 0 rocksdb.block.cache.filter.bytes.insert COUNT : 0 rocksdb.block.cache.data.miss COUNT : 0 rocksdb.block.cache.data.hit COUNT : 0 rocksdb.block.cache.data.add COUNT : 0 rocksdb.block.cache.data.bytes.insert COUNT : 0 rocksdb.block.cache.bytes.read COUNT : 0 rocksdb.block.cache.bytes.write COUNT : 0 rocksdb.bloom.filter.useful COUNT : 0 rocksdb.bloom.filter.full.positive COUNT : 0 rocksdb.bloom.filter.full.true.positive COUNT : 0 rocksdb.persistent.cache.hit COUNT : 0 rocksdb.persistent.cache.miss COUNT : 0 rocksdb.sim.block.cache.hit COUNT : 0 rocksdb.sim.block.cache.miss COUNT : 0 rocksdb.memtable.hit COUNT : 0 rocksdb.memtable.miss COUNT : 0 rocksdb.l0.hit COUNT : 0 rocksdb.l1.hit COUNT : 0 rocksdb.l2andup.hit COUNT : 0 rocksdb.compaction.key.drop.new COUNT : 194786 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 : 9773999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 10086766968 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 : 461 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 33707099 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 : 26761691664 rocksdb.compact.write.bytes COUNT : 26574156116 rocksdb.flush.write.bytes COUNT : 10040703917 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 : 47 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 : 265 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 : 9959784448 rocksdb.memtable.garbage.bytes.at.flush COUNT : 3900416 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 : 26850628772 rocksdb.non.last.level.read.count COUNT : 6486282 rocksdb.block.checksum.compute.count COUNT : 6485408 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.369264 P95 : 3.833641 P99 : 6.366862 P100 : 838130.000000 COUNT : 9773999 SUM : 55503965 rocksdb.compaction.times.micros P50 : 1101290.322581 P95 : 5766666.666667 P99 : 17928834.000000 P100 : 17928834.000000 COUNT : 60 SUM : 108453372 rocksdb.compaction.times.cpu_micros P50 : 969677.419355 P95 : 5400000.000000 P99 : 16549940.000000 P100 : 16549940.000000 COUNT : 60 SUM : 91868891 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 : 688.313253 P95 : 1266.555556 P99 : 44220.000000 P100 : 119306.000000 COUNT : 134 SUM : 275694 rocksdb.compaction.outfile.sync.micros P50 : 949.935897 P95 : 83050.000000 P99 : 170800.000000 P100 : 188243.000000 COUNT : 297 SUM : 3689458 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 : 99.181818 P95 : 1113.666667 P99 : 3270.000000 P100 : 3651.000000 COUNT : 226 SUM : 59186 rocksdb.table.open.io.micros P50 : 1542.045455 P95 : 9285.000000 P99 : 20508.571429 P100 : 22938.000000 COUNT : 461 SUM : 1161907 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.552954 P95 : 7.161047 P99 : 10.824047 P100 : 22224.000000 COUNT : 6484076 SUM : 37327707 rocksdb.read.block.get.micros P50 : 534.128440 P95 : 4103.658537 P99 : 7726.714286 P100 : 9349.000000 COUNT : 922 SUM : 932587 rocksdb.write.raw.block.micros P50 : 0.512631 P95 : 0.973998 P99 : 2.823650 P100 : 22039.000000 COUNT : 8867818 SUM : 17681068 rocksdb.numfiles.in.singlecompaction P50 : 3.364286 P95 : 7.100000 P99 : 32.920000 P100 : 50.000000 COUNT : 109 SUM : 471 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.558983 P95 : 1188.048845 P99 : 2575.199009 P100 : 837934.000000 COUNT : 199567 SUM : 33720191 rocksdb.sst.read.micros P50 : 1.538230 P95 : 4.228040 P99 : 8.318070 P100 : 22214.000000 COUNT : 6486430 SUM : 24701274 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 : 9773999 SUM : 10086766968 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 : 211702.127660 P95 : 354684.210526 P99 : 948396.000000 P100 : 948396.000000 COUNT : 134 SUM : 28985798 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 : 283 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