[2024-12-16 23:59:00.244240] Starting SPDK v24.01.1-pre git sha1 c13c99a5e / DPDK 22.11.4 initialization... [2024-12-16 23:59:00.244399] [ 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_pid693101 ] Set seed to 1734389940240724 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-12-16 23:59:00.335428] app.c: 798:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-12-16 23:59:00.375569] app.c: 488:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-12-16 23:59:00.375617] app.c: 489:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 693101' to capture a snapshot of events at runtime. [2024-12-16 23:59:00.375629] app.c: 494:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid693101 for offline analysis/debug. [2024-12-16 23:59:00.375668] reactor.c: 937:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Mon Dec 16 23:59:04 2024 CPU: 96 * Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz CPUCache: 36608 KB 2024/12/16-23:59:07 ... thread 0: (1000000,1000000) ops and (359979.1,359979.1) ops/second in (2.777939,2.777939) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 8/5 504.01 MB 18.9 0.0 0.0 0.0 0.8 0.8 0.0 1.0 0.0 354.0 2.31 2.08 12 0.193 0 0 0.0 0.0 L1 3/3 251.72 MB 0.0 0.2 0.2 0.1 0.2 0.2 0.1 1.3 253.2 253.0 0.99 0.97 1 0.995 255K 181 0.0 0.0 L2 1/0 48.48 MB 0.5 0.1 0.1 0.0 0.1 0.1 0.0 1.8 234.3 234.2 0.47 0.45 1 0.474 112K 40 0.0 0.0 L3 17/0 818.45 MB 0.8 0.1 0.1 0.0 0.1 0.1 0.0 1.0 206.3 206.3 0.30 0.25 1 0.303 63K 0 0.0 0.0 L4 116/0 9.60 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1044/0 85.75 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1189/8 96.94 GB 0.0 0.4 0.3 0.1 1.2 1.1 0.2 1.5 104.1 304.5 4.09 3.75 15 0.272 432K 221 0.0 0.0 Int 0/0 0.00 KB 0.0 0.4 0.3 0.1 1.2 1.1 0.1 1.5 104.1 304.5 4.09 3.75 15 0.272 432K 221 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 0.4 0.3 0.1 0.4 0.3 0.0 0.0 240.1 240.0 1.77 1.66 3 0.591 432K 221 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 0.8 0.8 0.0 0.0 0.0 354.0 2.31 2.08 12 0.193 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 3.0 total, 2.8 interval Flush(GB): cumulative 0.800, interval 0.800 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 1.22 GB write, 418.10 MB/s write, 0.42 GB read, 142.97 MB/s read, 4.1 seconds Interval compaction: 1.22 GB write, 447.66 MB/s write, 0.42 GB read, 153.08 MB/s read, 4.1 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 4, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 4, interval: 4 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 97362 Average: 1.7930 StdDev: 15.40 Min: 1 Median: 1.1332 Max: 3169 Percentiles: P50: 1.13 P75: 1.60 P99: 3.52 P99.9: 9.69 P99.99: 334.86 ------------------------------------------------------ [ 0, 1 ] 41728 42.859% 42.859% ######### ( 1, 2 ] 52208 53.623% 96.481% ########### ( 2, 3 ] 2041 2.096% 98.577% ( 3, 4 ] 786 0.807% 99.385% ( 4, 6 ] 331 0.340% 99.725% ( 6, 10 ] 186 0.191% 99.916% ( 10, 15 ] 46 0.047% 99.963% ( 15, 22 ] 4 0.004% 99.967% ( 22, 34 ] 1 0.001% 99.968% ( 34, 51 ] 4 0.004% 99.972% ( 51, 76 ] 3 0.003% 99.975% ( 110, 170 ] 8 0.008% 99.984% ( 170, 250 ] 4 0.004% 99.988% ( 250, 380 ] 5 0.005% 99.993% ( 380, 580 ] 1 0.001% 99.994% ( 580, 870 ] 2 0.002% 99.996% ( 870, 1300 ] 2 0.002% 99.998% ( 1900, 2900 ] 2 0.002% 100.000% ( 2900, 4400 ] 1 0.001% 100.001% ** Level 1 read latency histogram (micros): Count: 26073 Average: 2.4199 StdDev: 33.29 Min: 1 Median: 1.1926 Max: 3584 Percentiles: P50: 1.19 P75: 1.65 P99: 7.06 P99.9: 75.88 P99.99: 1535.56 ------------------------------------------------------ [ 0, 1 ] 10292 39.474% 39.474% ######## ( 1, 2 ] 14249 54.650% 94.124% ########### ( 2, 3 ] 881 3.379% 97.503% # ( 3, 4 ] 225 0.863% 98.366% ( 4, 6 ] 115 0.441% 98.807% ( 6, 10 ] 194 0.744% 99.551% ( 10, 15 ] 32 0.123% 99.674% ( 15, 22 ] 10 0.038% 99.712% ( 22, 34 ] 2 0.008% 99.720% ( 34, 51 ] 33 0.127% 99.847% ( 51, 76 ] 15 0.058% 99.904% ( 76, 110 ] 5 0.019% 99.923% ( 110, 170 ] 2 0.008% 99.931% ( 170, 250 ] 7 0.027% 99.958% ( 250, 380 ] 2 0.008% 99.965% ( 380, 580 ] 4 0.015% 99.981% ( 580, 870 ] 1 0.004% 99.985% ( 870, 1300 ] 2 0.008% 99.992% ( 1300, 1900 ] 1 0.004% 99.996% ( 2900, 4400 ] 2 0.008% 100.004% ** Level 2 read latency histogram (micros): Count: 15876 Average: 1.8238 StdDev: 6.60 Min: 1 Median: 1.1863 Max: 626 Percentiles: P50: 1.19 P75: 1.65 P99: 5.27 P99.9: 12.66 P99.99: 462.48 ------------------------------------------------------ [ 0, 1 ] 6351 40.004% 40.004% ######## ( 1, 2 ] 8519 53.660% 93.663% ########### ( 2, 3 ] 570 3.590% 97.254% # ( 3, 4 ] 181 1.140% 98.394% ( 4, 6 ] 152 0.957% 99.351% ( 6, 10 ] 77 0.485% 99.836% ( 10, 15 ] 19 0.120% 99.956% ( 15, 22 ] 3 0.019% 99.975% ( 110, 170 ] 1 0.006% 99.981% ( 170, 250 ] 1 0.006% 99.987% ( 380, 580 ] 1 0.006% 99.994% ( 580, 870 ] 1 0.006% 100.000% ** Level 3 read latency histogram (micros): Count: 85 Average: 983.7176 StdDev: 1442.43 Min: 1 Median: 266.2500 Max: 5397 Percentiles: P50: 266.25 P75: 1525.00 P99: 5397.00 P99.9: 5397.00 P99.99: 5397.00 ------------------------------------------------------ [ 0, 1 ] 27 31.765% 31.765% ###### ( 1, 2 ] 11 12.941% 44.706% ### ( 110, 170 ] 1 1.176% 45.882% ( 170, 250 ] 3 3.529% 49.412% # ( 250, 380 ] 4 4.706% 54.118% # ( 380, 580 ] 9 10.588% 64.706% ## ( 580, 870 ] 6 7.059% 71.765% # ( 870, 1300 ] 2 2.353% 74.118% ( 1300, 1900 ] 2 2.353% 76.471% ( 1900, 2900 ] 8 9.412% 85.882% ## ( 2900, 4400 ] 8 9.412% 95.294% ## ( 4400, 6600 ] 4 4.706% 100.000% # ** Level 4 read latency histogram (micros): Count: 30 Average: 1919.0667 StdDev: 1250.03 Min: 394 Median: 1700.0000 Max: 5232 Percentiles: P50: 1700.00 P75: 2828.57 P99: 5232.00 P99.9: 5232.00 P99.99: 5232.00 ------------------------------------------------------ ( 380, 580 ] 4 13.333% 13.333% ### ( 580, 870 ] 5 16.667% 30.000% ### ( 870, 1300 ] 4 13.333% 43.333% ### ( 1300, 1900 ] 3 10.000% 53.333% ## ( 1900, 2900 ] 7 23.333% 76.667% ##### ( 2900, 4400 ] 6 20.000% 96.667% #### ( 4400, 6600 ] 1 3.333% 100.000% # ** DB Stats ** Uptime(secs): 3.0 total, 2.8 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 330.70 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.173 H:M:S, 5.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 353.99 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.173 H:M:S, 6.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/12/16-23:59:10 ... thread 0: (1000000,2000000) ops and (326713.4,342540.5) ops/second in (3.060787,5.838726) 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.5 0.0 0.5 2.3 1.8 0.0 1.3 71.5 330.6 7.05 6.50 28 0.252 511K 472 0.0 0.0 L1 2/0 50.36 MB 5.0 0.8 0.5 0.3 0.8 0.5 0.1 1.6 246.1 245.7 3.33 3.24 2 1.663 831K 1410 0.0 0.0 L2 5/4 563.55 MB 1.3 0.1 0.1 0.0 0.1 0.1 0.5 1.8 234.3 234.2 0.47 0.45 1 0.474 112K 40 0.0 0.0 L3 17/10 818.45 MB 0.0 0.1 0.1 0.0 0.1 0.1 0.0 1.0 206.3 206.3 0.30 0.25 1 0.303 63K 0 0.0 0.0 L4 116/0 9.60 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1044/0 85.75 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1195/22 97.92 GB 0.0 1.5 0.6 0.8 3.2 2.4 0.7 1.8 134.2 297.8 11.15 10.43 32 0.349 1519K 1922 0.0 0.0 Int 0/0 0.00 KB 0.0 1.5 0.6 0.8 3.2 2.4 0.6 1.8 134.2 297.8 11.15 10.43 32 0.349 1519K 1922 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 1.5 0.6 0.8 1.5 0.6 0.0 0.0 250.7 250.3 5.97 5.77 6 0.995 1519K 1922 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 1.8 1.8 0.0 0.0 0.0 352.5 5.18 4.66 26 0.199 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 6.0 total, 5.8 interval Flush(GB): cumulative 1.784, interval 1.784 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 3.24 GB write, 550.15 MB/s write, 1.46 GB read, 247.86 MB/s read, 11.2 seconds Interval compaction: 3.24 GB write, 568.66 MB/s write, 1.46 GB read, 256.20 MB/s read, 11.2 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 10, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 10, interval: 10 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 347539 Average: 2.0425 StdDev: 12.24 Min: 1 Median: 1.3721 Max: 3329 Percentiles: P50: 1.37 P75: 1.78 P99: 5.48 P99.9: 9.96 P99.99: 58.02 ------------------------------------------------------ [ 0, 1 ] 94011 27.050% 27.050% ##### ( 1, 2 ] 214365 61.681% 88.731% ############ ( 2, 3 ] 21154 6.087% 94.818% # ( 3, 4 ] 9821 2.826% 97.644% # ( 4, 6 ] 6379 1.835% 99.479% ( 6, 10 ] 1477 0.425% 99.904% ( 10, 15 ] 247 0.071% 99.976% ( 15, 22 ] 36 0.010% 99.986% ( 22, 34 ] 7 0.002% 99.988% ( 34, 51 ] 5 0.001% 99.989% ( 51, 76 ] 8 0.002% 99.992% ( 110, 170 ] 12 0.003% 99.995% ( 170, 250 ] 12 0.003% 99.999% ( 250, 380 ] 12 0.003% 100.002% ( 380, 580 ] 2 0.001% 100.003% ( 580, 870 ] 9 0.003% 100.005% ( 870, 1300 ] 3 0.001% 100.006% ( 1300, 1900 ] 1 0.000% 100.006% ( 1900, 2900 ] 4 0.001% 100.007% ( 2900, 4400 ] 2 0.001% 100.008% ** Level 1 read latency histogram (micros): Count: 129562 Average: 2.2711 StdDev: 16.18 Min: 1 Median: 1.4631 Max: 3584 Percentiles: P50: 1.46 P75: 1.86 P99: 5.81 P99.9: 14.13 P99.99: 461.75 ------------------------------------------------------ [ 0, 1 ] 26958 20.807% 20.807% #### ( 1, 2 ] 81679 63.042% 83.849% ############# ( 2, 3 ] 11817 9.121% 92.970% ## ( 3, 4 ] 4604 3.554% 96.524% # ( 4, 6 ] 3547 2.738% 99.261% # ( 6, 10 ] 735 0.567% 99.829% ( 10, 15 ] 112 0.086% 99.915% ( 15, 22 ] 21 0.016% 99.931% ( 22, 34 ] 3 0.002% 99.934% ( 34, 51 ] 35 0.027% 99.961% ( 51, 76 ] 15 0.012% 99.972% ( 76, 110 ] 5 0.004% 99.976% ( 110, 170 ] 3 0.002% 99.978% ( 170, 250 ] 8 0.006% 99.985% ( 250, 380 ] 5 0.004% 99.988% ( 380, 580 ] 5 0.004% 99.992% ( 580, 870 ] 2 0.002% 99.994% ( 870, 1300 ] 4 0.003% 99.997% ( 1300, 1900 ] 2 0.002% 99.998% ( 2900, 4400 ] 2 0.002% 100.000% ** Level 2 read latency histogram (micros): Count: 15920 Average: 1.8274 StdDev: 6.59 Min: 1 Median: 1.1883 Max: 626 Percentiles: P50: 1.19 P75: 1.65 P99: 5.29 P99.9: 12.92 P99.99: 461.60 ------------------------------------------------------ [ 0, 1 ] 6352 39.899% 39.899% ######## ( 1, 2 ] 8541 53.649% 93.549% ########### ( 2, 3 ] 587 3.687% 97.236% # ( 3, 4 ] 183 1.149% 98.386% ( 4, 6 ] 152 0.955% 99.340% ( 6, 10 ] 78 0.490% 99.830% ( 10, 15 ] 19 0.119% 99.950% ( 15, 22 ] 3 0.019% 99.969% ( 22, 34 ] 1 0.006% 99.975% ( 110, 170 ] 1 0.006% 99.981% ( 170, 250 ] 1 0.006% 99.987% ( 380, 580 ] 1 0.006% 99.994% ( 580, 870 ] 1 0.006% 100.000% ** Level 3 read latency histogram (micros): Count: 77058 Average: 4.2780 StdDev: 59.86 Min: 1 Median: 1.6317 Max: 5397 Percentiles: P50: 1.63 P75: 2.21 P99: 9.93 P99.9: 314.78 P99.99: 2686.77 ------------------------------------------------------ [ 0, 1 ] 9718 12.611% 12.611% ### ( 1, 2 ] 45609 59.188% 71.799% ############ ( 2, 3 ] 11475 14.891% 86.691% ### ( 3, 4 ] 4119 5.345% 92.036% # ( 4, 6 ] 3923 5.091% 97.127% # ( 6, 10 ] 1469 1.906% 99.033% ( 10, 15 ] 342 0.444% 99.477% ( 15, 22 ] 62 0.080% 99.557% ( 22, 34 ] 21 0.027% 99.585% ( 34, 51 ] 2 0.003% 99.587% ( 51, 76 ] 1 0.001% 99.589% ( 76, 110 ] 57 0.074% 99.663% ( 110, 170 ] 117 0.152% 99.814% ( 170, 250 ] 49 0.064% 99.878% ( 250, 380 ] 34 0.044% 99.922% ( 380, 580 ] 27 0.035% 99.957% ( 580, 870 ] 12 0.016% 99.973% ( 870, 1300 ] 5 0.006% 99.979% ( 1300, 1900 ] 2 0.003% 99.982% ( 1900, 2900 ] 8 0.010% 99.992% ( 2900, 4400 ] 8 0.010% 100.003% ( 4400, 6600 ] 4 0.005% 100.008% ** Level 4 read latency histogram (micros): Count: 30 Average: 1919.0667 StdDev: 1250.03 Min: 394 Median: 1700.0000 Max: 5232 Percentiles: P50: 1700.00 P75: 2828.57 P99: 5232.00 P99.9: 5232.00 P99.99: 5232.00 ------------------------------------------------------ ( 380, 580 ] 4 13.333% 13.333% ### ( 580, 870 ] 5 16.667% 30.000% ### ( 870, 1300 ] 4 13.333% 43.333% ### ( 1300, 1900 ] 3 10.000% 53.333% ## ( 1900, 2900 ] 7 23.333% 76.667% ##### ( 2900, 4400 ] 6 20.000% 96.667% #### ( 4400, 6600 ] 1 3.333% 100.000% # ** DB Stats ** Uptime(secs): 6.0 total, 3.1 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 326.06 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.560 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, 321.55 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.388 H:M:S, 12.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 4 num-running-flushes: 1 2024/12/16-23:59:13 ... thread 0: (1000000,3000000) ops and (324035.9,336141.8) ops/second in (3.086078,8.924804) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 13/10 2.15 GB 18.9 1.6 0.0 1.6 4.4 2.8 0.0 1.6 114.7 313.2 14.28 13.31 46 0.310 1663K 1752 0.0 0.0 L1 2/2 50.36 MB 0.0 0.8 0.5 0.3 0.8 0.5 0.1 1.6 246.1 245.7 3.33 3.24 2 1.663 831K 1410 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.0 0.1 0.1 0.5 1.8 234.3 234.2 0.47 0.45 1 0.474 112K 40 0.0 0.0 L3 24/0 989.49 MB 1.0 1.4 0.6 0.8 1.4 0.6 0.0 2.3 217.7 217.6 6.71 5.97 4 1.679 1462K 729 0.0 0.0 L4 152/0 9.67 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1048/0 86.06 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 1239/12 98.90 GB 0.0 3.9 1.2 2.8 6.7 3.9 1.4 2.4 162.5 276.7 24.79 22.97 53 0.468 4069K 3931 0.0 0.0 Int 0/0 0.00 KB 0.0 3.9 1.2 2.8 6.7 3.9 1.3 2.4 162.5 276.7 24.79 22.97 53 0.468 4069K 3931 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 3.9 1.2 2.8 3.9 1.2 0.0 0.0 240.3 240.0 16.77 15.79 13 1.290 4069K 3931 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 2.8 2.8 0.0 0.0 0.0 353.4 8.02 7.18 40 0.201 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 9.1 total, 8.9 interval Flush(GB): cumulative 2.768, interval 2.768 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 6.70 GB write, 751.98 MB/s write, 3.93 GB read, 441.69 MB/s read, 24.8 seconds Interval compaction: 6.70 GB write, 768.53 MB/s write, 3.93 GB read, 451.41 MB/s read, 24.8 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: 20, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 20, interval: 20 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 599601 Average: 2.1956 StdDev: 13.08 Min: 0 Median: 1.4327 Max: 3329 Percentiles: P50: 1.43 P75: 1.84 P99: 5.72 P99.9: 11.14 P99.99: 170.07 ------------------------------------------------------ [ 0, 1 ] 139025 23.186% 23.186% ##### ( 1, 2 ] 371555 61.967% 85.153% ############ ( 2, 3 ] 46274 7.717% 92.871% ## ( 3, 4 ] 22361 3.729% 96.600% # ( 4, 6 ] 16691 2.784% 99.384% # ( 6, 10 ] 2981 0.497% 99.881% ( 10, 15 ] 504 0.084% 99.965% ( 15, 22 ] 72 0.012% 99.977% ( 22, 34 ] 10 0.002% 99.979% ( 34, 51 ] 6 0.001% 99.980% ( 51, 76 ] 13 0.002% 99.982% ( 76, 110 ] 18 0.003% 99.985% ( 110, 170 ] 32 0.005% 99.990% ( 170, 250 ] 45 0.008% 99.998% ( 250, 380 ] 32 0.005% 100.003% ( 380, 580 ] 20 0.003% 100.006% ( 580, 870 ] 21 0.004% 100.010% ( 870, 1300 ] 9 0.002% 100.011% ( 1300, 1900 ] 3 0.001% 100.012% ( 1900, 2900 ] 5 0.001% 100.013% ( 2900, 4400 ] 4 0.001% 100.013% ** Level 1 read latency histogram (micros): Count: 206920 Average: 2.3468 StdDev: 12.82 Min: 1 Median: 1.5396 Max: 3584 Percentiles: P50: 1.54 P75: 1.93 P99: 5.92 P99.9: 13.48 P99.99: 243.08 ------------------------------------------------------ [ 0, 1 ] 32630 15.769% 15.769% ### ( 1, 2 ] 131269 63.439% 79.209% ############# ( 2, 3 ] 23403 11.310% 90.519% ## ( 3, 4 ] 9446 4.565% 95.084% # ( 4, 6 ] 8453 4.085% 99.169% # ( 6, 10 ] 1347 0.651% 99.820% ( 10, 15 ] 237 0.115% 99.935% ( 15, 22 ] 45 0.022% 99.957% ( 22, 34 ] 4 0.002% 99.958% ( 34, 51 ] 35 0.017% 99.975% ( 51, 76 ] 15 0.007% 99.983% ( 76, 110 ] 5 0.002% 99.985% ( 110, 170 ] 3 0.001% 99.986% ( 170, 250 ] 8 0.004% 99.990% ( 250, 380 ] 5 0.002% 99.993% ( 380, 580 ] 5 0.002% 99.995% ( 580, 870 ] 2 0.001% 99.996% ( 870, 1300 ] 4 0.002% 99.998% ( 1300, 1900 ] 2 0.001% 99.999% ( 2900, 4400 ] 2 0.001% 100.000% ** Level 2 read latency histogram (micros): Count: 28188 Average: 2.1306 StdDev: 8.52 Min: 1 Median: 1.3563 Max: 807 Percentiles: P50: 1.36 P75: 1.78 P99: 6.85 P99.9: 13.47 P99.99: 525.41 ------------------------------------------------------ [ 0, 1 ] 8190 29.055% 29.055% ###### ( 1, 2 ] 16571 58.787% 87.842% ############ ( 2, 3 ] 1634 5.797% 93.639% # ( 3, 4 ] 874 3.101% 96.740% # ( 4, 6 ] 574 2.036% 98.776% ( 6, 10 ] 296 1.050% 99.826% ( 10, 15 ] 30 0.106% 99.933% ( 15, 22 ] 5 0.018% 99.950% ( 22, 34 ] 1 0.004% 99.954% ( 51, 76 ] 1 0.004% 99.957% ( 110, 170 ] 1 0.004% 99.961% ( 170, 250 ] 2 0.007% 99.968% ( 250, 380 ] 4 0.014% 99.982% ( 380, 580 ] 3 0.011% 99.993% ( 580, 870 ] 2 0.007% 100.000% ** Level 3 read latency histogram (micros): Count: 212624 Average: 3.6029 StdDev: 39.96 Min: 1 Median: 1.6119 Max: 5397 Percentiles: P50: 1.61 P75: 2.11 P99: 9.45 P99.9: 243.13 P99.99: 804.18 ------------------------------------------------------ [ 0, 1 ] 27314 12.846% 12.846% ### ( 1, 2 ] 129099 60.717% 73.563% ############ ( 2, 3 ] 27894 13.119% 86.682% ### ( 3, 4 ] 12275 5.773% 92.455% # ( 4, 6 ] 10497 4.937% 97.392% # ( 6, 10 ] 3968 1.866% 99.258% ( 10, 15 ] 673 0.317% 99.575% ( 15, 22 ] 94 0.044% 99.619% ( 22, 34 ] 44 0.021% 99.640% ( 34, 51 ] 20 0.009% 99.649% ( 51, 76 ] 10 0.005% 99.654% ( 76, 110 ] 156 0.073% 99.727% ( 110, 170 ] 265 0.125% 99.852% ( 170, 250 ] 112 0.053% 99.905% ( 250, 380 ] 90 0.042% 99.947% ( 380, 580 ] 67 0.032% 99.978% ( 580, 870 ] 32 0.015% 99.993% ( 870, 1300 ] 12 0.006% 99.999% ( 1300, 1900 ] 2 0.001% 100.000% ( 1900, 2900 ] 11 0.005% 100.005% ( 2900, 4400 ] 9 0.004% 100.009% ( 4400, 6600 ] 4 0.002% 100.011% ** Level 4 read latency histogram (micros): Count: 30 Average: 1919.0667 StdDev: 1250.03 Min: 394 Median: 1700.0000 Max: 5232 Percentiles: P50: 1700.00 P75: 2828.57 P99: 5232.00 P99.9: 5232.00 P99.99: 5232.00 ------------------------------------------------------ ( 380, 580 ] 4 13.333% 13.333% ### ( 580, 870 ] 5 16.667% 30.000% ### ( 870, 1300 ] 4 13.333% 43.333% ### ( 1300, 1900 ] 3 10.000% 53.333% ## ( 1900, 2900 ] 7 23.333% 76.667% ##### ( 2900, 4400 ] 6 20.000% 96.667% #### ( 4400, 6600 ] 1 3.333% 100.000% # ** Level 5 read latency histogram (micros): Count: 20 Average: 753.5500 StdDev: 867.51 Min: 100 Median: 223.3333 Max: 2783 Percentiles: P50: 223.33 P75: 1600.00 P99: 2783.00 P99.9: 2783.00 P99.99: 2783.00 ------------------------------------------------------ ( 76, 110 ] 2 10.000% 10.000% ## ( 110, 170 ] 6 30.000% 40.000% ###### ( 170, 250 ] 3 15.000% 55.000% ### ( 250, 380 ] 1 5.000% 60.000% # ( 580, 870 ] 2 10.000% 70.000% ## ( 1300, 1900 ] 2 10.000% 80.000% ## ( 1900, 2900 ] 4 20.000% 100.000% #### ** DB Stats ** Uptime(secs): 9.1 total, 3.1 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 323.65 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:0.970 H:M:S, 10.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 318.91 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.410 H:M:S, 13.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/12/16-23:59:16 ... thread 0: (1000000,4000000) ops and (322602.8,332651.6) ops/second in (3.099787,12.024591) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 17/10 3.07 GB 113.3 2.4 0.0 2.4 6.1 3.7 0.0 1.6 122.3 310.3 20.09 18.80 62 0.324 2494K 2629 0.0 0.0 L1 2/2 50.36 MB 0.0 0.8 0.5 0.3 0.8 0.5 0.1 1.6 246.1 245.7 3.33 3.24 2 1.663 831K 1410 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.0 0.1 0.1 0.5 1.8 234.3 234.2 0.47 0.45 1 0.474 112K 40 0.0 0.0 L3 24/0 989.49 MB 1.0 1.4 0.6 0.8 1.4 0.6 0.0 2.3 217.7 217.6 6.71 5.97 4 1.679 1462K 729 0.0 0.0 L4 152/0 9.67 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1048/0 86.06 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 1243/12 99.82 GB 0.0 4.7 1.2 3.6 8.4 4.9 1.4 2.3 158.4 281.7 30.61 28.45 69 0.444 4901K 4808 0.0 0.0 Int 0/0 0.00 KB 0.0 4.7 1.2 3.6 8.4 4.9 1.3 2.3 158.4 281.7 30.61 28.45 69 0.444 4901K 4808 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.7 1.2 3.6 4.7 1.2 0.0 0.0 243.9 243.7 19.88 18.85 16 1.242 4901K 4808 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 3.7 3.7 0.0 0.0 0.0 352.3 10.73 9.61 53 0.202 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 12.2 total, 12.0 interval Flush(GB): cumulative 3.691, interval 3.691 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 8.42 GB write, 705.51 MB/s write, 4.73 GB read, 396.68 MB/s read, 30.6 seconds Interval compaction: 8.42 GB write, 717.03 MB/s write, 4.73 GB read, 403.16 MB/s read, 30.6 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 2, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 2, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 23, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 2, total-stops: 23, interval: 25 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 988415 Average: 2.1893 StdDev: 12.02 Min: 0 Median: 1.4506 Max: 3329 Percentiles: P50: 1.45 P75: 1.84 P99: 5.71 P99.9: 10.51 P99.99: 23.99 ------------------------------------------------------ [ 0, 1 ] 208730 21.118% 21.118% #### ( 1, 2 ] 633524 64.095% 85.213% ############# ( 2, 3 ] 79498 8.043% 93.256% ## ( 3, 4 ] 35465 3.588% 96.844% # ( 4, 6 ] 24867 2.516% 99.359% # ( 6, 10 ] 5254 0.532% 99.891% ( 10, 15 ] 874 0.088% 99.979% ( 15, 22 ] 102 0.010% 99.990% ( 22, 34 ] 13 0.001% 99.991% ( 34, 51 ] 7 0.001% 99.992% ( 51, 76 ] 17 0.002% 99.994% ( 76, 110 ] 28 0.003% 99.996% ( 110, 170 ] 63 0.006% 100.003% ( 170, 250 ] 66 0.007% 100.009% ( 250, 380 ] 42 0.004% 100.014% ( 380, 580 ] 27 0.003% 100.016% ( 580, 870 ] 26 0.003% 100.019% ( 870, 1300 ] 15 0.002% 100.021% ( 1300, 1900 ] 4 0.000% 100.021% ( 1900, 2900 ] 8 0.001% 100.022% ( 2900, 4400 ] 5 0.001% 100.022% ** Level 1 read latency histogram (micros): Count: 206920 Average: 2.3468 StdDev: 12.82 Min: 1 Median: 1.5396 Max: 3584 Percentiles: P50: 1.54 P75: 1.93 P99: 5.92 P99.9: 13.48 P99.99: 243.08 ------------------------------------------------------ [ 0, 1 ] 32630 15.769% 15.769% ### ( 1, 2 ] 131269 63.439% 79.209% ############# ( 2, 3 ] 23403 11.310% 90.519% ## ( 3, 4 ] 9446 4.565% 95.084% # ( 4, 6 ] 8453 4.085% 99.169% # ( 6, 10 ] 1347 0.651% 99.820% ( 10, 15 ] 237 0.115% 99.935% ( 15, 22 ] 45 0.022% 99.957% ( 22, 34 ] 4 0.002% 99.958% ( 34, 51 ] 35 0.017% 99.975% ( 51, 76 ] 15 0.007% 99.983% ( 76, 110 ] 5 0.002% 99.985% ( 110, 170 ] 3 0.001% 99.986% ( 170, 250 ] 8 0.004% 99.990% ( 250, 380 ] 5 0.002% 99.993% ( 380, 580 ] 5 0.002% 99.995% ( 580, 870 ] 2 0.001% 99.996% ( 870, 1300 ] 4 0.002% 99.998% ( 1300, 1900 ] 2 0.001% 99.999% ( 2900, 4400 ] 2 0.001% 100.000% ** Level 2 read latency histogram (micros): Count: 28188 Average: 2.1306 StdDev: 8.52 Min: 1 Median: 1.3563 Max: 807 Percentiles: P50: 1.36 P75: 1.78 P99: 6.85 P99.9: 13.47 P99.99: 525.41 ------------------------------------------------------ [ 0, 1 ] 8190 29.055% 29.055% ###### ( 1, 2 ] 16571 58.787% 87.842% ############ ( 2, 3 ] 1634 5.797% 93.639% # ( 3, 4 ] 874 3.101% 96.740% # ( 4, 6 ] 574 2.036% 98.776% ( 6, 10 ] 296 1.050% 99.826% ( 10, 15 ] 30 0.106% 99.933% ( 15, 22 ] 5 0.018% 99.950% ( 22, 34 ] 1 0.004% 99.954% ( 51, 76 ] 1 0.004% 99.957% ( 110, 170 ] 1 0.004% 99.961% ( 170, 250 ] 2 0.007% 99.968% ( 250, 380 ] 4 0.014% 99.982% ( 380, 580 ] 3 0.011% 99.993% ( 580, 870 ] 2 0.007% 100.000% ** Level 3 read latency histogram (micros): Count: 212624 Average: 3.6029 StdDev: 39.96 Min: 1 Median: 1.6119 Max: 5397 Percentiles: P50: 1.61 P75: 2.11 P99: 9.45 P99.9: 243.13 P99.99: 804.18 ------------------------------------------------------ [ 0, 1 ] 27314 12.846% 12.846% ### ( 1, 2 ] 129099 60.717% 73.563% ############ ( 2, 3 ] 27894 13.119% 86.682% ### ( 3, 4 ] 12275 5.773% 92.455% # ( 4, 6 ] 10497 4.937% 97.392% # ( 6, 10 ] 3968 1.866% 99.258% ( 10, 15 ] 673 0.317% 99.575% ( 15, 22 ] 94 0.044% 99.619% ( 22, 34 ] 44 0.021% 99.640% ( 34, 51 ] 20 0.009% 99.649% ( 51, 76 ] 10 0.005% 99.654% ( 76, 110 ] 156 0.073% 99.727% ( 110, 170 ] 265 0.125% 99.852% ( 170, 250 ] 112 0.053% 99.905% ( 250, 380 ] 90 0.042% 99.947% ( 380, 580 ] 67 0.032% 99.978% ( 580, 870 ] 32 0.015% 99.993% ( 870, 1300 ] 12 0.006% 99.999% ( 1300, 1900 ] 2 0.001% 100.000% ( 1900, 2900 ] 11 0.005% 100.005% ( 2900, 4400 ] 9 0.004% 100.009% ( 4400, 6600 ] 4 0.002% 100.011% ** Level 4 read latency histogram (micros): Count: 30 Average: 1919.0667 StdDev: 1250.03 Min: 394 Median: 1700.0000 Max: 5232 Percentiles: P50: 1700.00 P75: 2828.57 P99: 5232.00 P99.9: 5232.00 P99.99: 5232.00 ------------------------------------------------------ ( 380, 580 ] 4 13.333% 13.333% ### ( 580, 870 ] 5 16.667% 30.000% ### ( 870, 1300 ] 4 13.333% 43.333% ### ( 1300, 1900 ] 3 10.000% 53.333% ## ( 1900, 2900 ] 7 23.333% 76.667% ##### ( 2900, 4400 ] 6 20.000% 96.667% #### ( 4400, 6600 ] 1 3.333% 100.000% # ** Level 5 read latency histogram (micros): Count: 20 Average: 753.5500 StdDev: 867.51 Min: 100 Median: 223.3333 Max: 2783 Percentiles: P50: 223.33 P75: 1600.00 P99: 2783.00 P99.9: 2783.00 P99.99: 2783.00 ------------------------------------------------------ ( 76, 110 ] 2 10.000% 10.000% ## ( 110, 170 ] 6 30.000% 40.000% ###### ( 170, 250 ] 3 15.000% 55.000% ### ( 250, 380 ] 1 5.000% 60.000% # ( 580, 870 ] 2 10.000% 70.000% ## ( 1300, 1900 ] 2 10.000% 80.000% ## ( 1900, 2900 ] 4 20.000% 100.000% #### ** DB Stats ** Uptime(secs): 12.2 total, 3.1 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 322.09 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:1.414 H:M:S, 11.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 317.50 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.443 H:M:S, 14.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/12/16-23:59:23 ... thread 0: (1000000,5000000) ops and (154906.3,270561.2) ops/second in (6.455516,18.480107) 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/9 2.09 GB 94.4 3.1 0.0 3.1 7.8 4.7 0.0 1.7 123.8 308.0 25.96 24.12 81 0.321 3262K 3296 0.0 0.0 L1 10/0 609.95 MB 61.0 2.8 2.5 0.4 2.8 2.4 0.1 1.1 234.0 232.3 12.32 11.89 3 4.106 2927K 20K 0.0 0.0 L2 1/0 128.78 MB 1.3 0.1 0.1 0.0 0.1 0.1 2.0 1.8 234.3 234.2 0.47 0.45 1 0.474 112K 40 0.0 0.0 L3 18/4 1.29 GB 0.9 1.5 0.7 0.8 1.5 0.7 1.2 2.2 215.2 215.1 7.17 6.34 5 1.433 1525K 729 0.0 0.0 L4 156/10 9.63 GB 1.0 0.1 0.1 0.0 0.1 0.1 1.2 1.3 173.5 172.6 0.66 0.51 1 0.663 116K 576 0.0 0.0 L5 1060/0 87.05 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1259/23 100.79 GB 0.0 7.7 3.3 4.4 12.3 7.9 5.8 2.6 168.8 271.0 46.58 43.30 91 0.512 7944K 25K 0.0 0.0 Int 0/0 0.00 KB 0.0 7.7 3.3 4.4 12.3 7.9 5.8 2.6 168.8 271.0 46.58 43.30 91 0.512 7944K 25K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 7.7 3.3 4.4 7.7 3.3 0.0 0.0 240.0 239.2 32.77 31.12 22 1.490 7944K 25K 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 346.7 13.81 12.19 69 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): 18.7 total, 18.5 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: 12.33 GB write, 675.98 MB/s write, 7.68 GB read, 421.05 MB/s read, 46.6 seconds Interval compaction: 12.33 GB write, 683.17 MB/s write, 7.68 GB read, 425.53 MB/s read, 46.6 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: 24, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 10, total-stops: 24, interval: 34 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1729471 Average: 2.2031 StdDev: 11.29 Min: 0 Median: 1.4611 Max: 4016 Percentiles: P50: 1.46 P75: 1.85 P99: 5.82 P99.9: 11.25 P99.99: 91.34 ------------------------------------------------------ [ 0, 1 ] 349161 20.189% 20.189% #### ( 1, 2 ] 1118058 64.647% 84.836% ############# ( 2, 3 ] 141835 8.201% 93.037% ## ( 3, 4 ] 61652 3.565% 96.602% # ( 4, 6 ] 45549 2.634% 99.236% # ( 6, 10 ] 11080 0.641% 99.876% ( 10, 15 ] 1626 0.094% 99.971% ( 15, 22 ] 235 0.014% 99.984% ( 22, 34 ] 20 0.001% 99.985% ( 34, 51 ] 9 0.001% 99.986% ( 51, 76 ] 19 0.001% 99.987% ( 76, 110 ] 122 0.007% 99.994% ( 110, 170 ] 184 0.011% 100.005% ( 170, 250 ] 101 0.006% 100.010% ( 250, 380 ] 62 0.004% 100.014% ( 380, 580 ] 46 0.003% 100.017% ( 580, 870 ] 40 0.002% 100.019% ( 870, 1300 ] 19 0.001% 100.020% ( 1300, 1900 ] 5 0.000% 100.020% ( 1900, 2900 ] 11 0.001% 100.021% ( 2900, 4400 ] 8 0.000% 100.021% ** Level 1 read latency histogram (micros): Count: 314674 Average: 2.8400 StdDev: 23.20 Min: 0 Median: 1.6257 Max: 4015 Percentiles: P50: 1.63 P75: 2.17 P99: 7.38 P99.9: 16.47 P99.99: 242.50 ------------------------------------------------------ [ 0, 1 ] 38232 12.150% 12.150% ## ( 1, 2 ] 190341 60.488% 72.638% ############ ( 2, 3 ] 42884 13.628% 86.266% ### ( 3, 4 ] 19440 6.178% 92.444% # ( 4, 6 ] 19450 6.181% 98.625% # ( 6, 10 ] 3421 1.087% 99.712% ( 10, 15 ] 572 0.182% 99.894% ( 15, 22 ] 92 0.029% 99.923% ( 22, 34 ] 8 0.003% 99.926% ( 34, 51 ] 35 0.011% 99.937% ( 51, 76 ] 20 0.006% 99.943% ( 76, 110 ] 66 0.021% 99.964% ( 110, 170 ] 48 0.015% 99.979% ( 170, 250 ] 37 0.012% 99.991% ( 250, 380 ] 30 0.010% 100.001% ( 380, 580 ] 39 0.012% 100.013% ( 580, 870 ] 17 0.005% 100.018% ( 870, 1300 ] 21 0.007% 100.025% ( 1300, 1900 ] 11 0.003% 100.029% ( 1900, 2900 ] 3 0.001% 100.030% ( 2900, 4400 ] 6 0.002% 100.031% ** Level 2 read latency histogram (micros): Count: 28188 Average: 2.1306 StdDev: 8.52 Min: 1 Median: 1.3563 Max: 807 Percentiles: P50: 1.36 P75: 1.78 P99: 6.85 P99.9: 13.47 P99.99: 525.41 ------------------------------------------------------ [ 0, 1 ] 8190 29.055% 29.055% ###### ( 1, 2 ] 16571 58.787% 87.842% ############ ( 2, 3 ] 1634 5.797% 93.639% # ( 3, 4 ] 874 3.101% 96.740% # ( 4, 6 ] 574 2.036% 98.776% ( 6, 10 ] 296 1.050% 99.826% ( 10, 15 ] 30 0.106% 99.933% ( 15, 22 ] 5 0.018% 99.950% ( 22, 34 ] 1 0.004% 99.954% ( 51, 76 ] 1 0.004% 99.957% ( 110, 170 ] 1 0.004% 99.961% ( 170, 250 ] 2 0.007% 99.968% ( 250, 380 ] 4 0.014% 99.982% ( 380, 580 ] 3 0.011% 99.993% ( 580, 870 ] 2 0.007% 100.000% ** Level 3 read latency histogram (micros): Count: 276583 Average: 5.1288 StdDev: 56.24 Min: 1 Median: 1.6642 Max: 5397 Percentiles: P50: 1.66 P75: 2.37 P99: 11.34 P99.9: 493.21 P99.99: 1109.77 ------------------------------------------------------ [ 0, 1 ] 30776 11.127% 11.127% ## ( 1, 2 ] 161874 58.526% 69.654% ############ ( 2, 3 ] 40145 14.515% 84.168% ### ( 3, 4 ] 18731 6.772% 90.941% # ( 4, 6 ] 16376 5.921% 96.861% # ( 6, 10 ] 5636 2.038% 98.899% ( 10, 15 ] 1044 0.377% 99.277% ( 15, 22 ] 158 0.057% 99.334% ( 22, 34 ] 50 0.018% 99.352% ( 34, 51 ] 20 0.007% 99.359% ( 51, 76 ] 11 0.004% 99.363% ( 76, 110 ] 232 0.084% 99.447% ( 110, 170 ] 511 0.185% 99.632% ( 170, 250 ] 332 0.120% 99.752% ( 250, 380 ] 275 0.099% 99.851% ( 380, 580 ] 241 0.087% 99.938% ( 580, 870 ] 112 0.040% 99.979% ( 870, 1300 ] 58 0.021% 100.000% ( 1300, 1900 ] 14 0.005% 100.005% ( 1900, 2900 ] 43 0.016% 100.020% ( 2900, 4400 ] 22 0.008% 100.028% ( 4400, 6600 ] 4 0.001% 100.030% ** Level 4 read latency histogram (micros): Count: 50 Average: 1189.7400 StdDev: 1325.02 Min: 0 Median: 696.0000 Max: 5232 Percentiles: P50: 696.00 P75: 2114.29 P99: 5232.00 P99.9: 5232.00 P99.99: 5232.00 ------------------------------------------------------ [ 0, 1 ] 5 10.000% 10.000% ## ( 1, 2 ] 8 16.000% 26.000% ### ( 3, 4 ] 1 2.000% 28.000% ( 22, 34 ] 1 2.000% 30.000% ( 110, 170 ] 3 6.000% 36.000% # ( 380, 580 ] 5 10.000% 46.000% ## ( 580, 870 ] 5 10.000% 56.000% ## ( 870, 1300 ] 5 10.000% 66.000% ## ( 1300, 1900 ] 3 6.000% 72.000% # ( 1900, 2900 ] 7 14.000% 86.000% ### ( 2900, 4400 ] 6 12.000% 98.000% ## ( 4400, 6600 ] 1 2.000% 100.000% ** Level 5 read latency histogram (micros): Count: 80 Average: 894.4750 StdDev: 1045.81 Min: 96 Median: 408.5714 Max: 4908 Percentiles: P50: 408.57 P75: 1300.00 P99: 4840.00 P99.9: 4908.00 P99.99: 4908.00 ------------------------------------------------------ ( 76, 110 ] 4 5.000% 5.000% # ( 110, 170 ] 13 16.250% 21.250% ### ( 170, 250 ] 14 17.500% 38.750% #### ( 250, 380 ] 8 10.000% 48.750% ## ( 380, 580 ] 7 8.750% 57.500% ## ( 580, 870 ] 10 12.500% 70.000% ### ( 870, 1300 ] 4 5.000% 75.000% # ( 1300, 1900 ] 6 7.500% 82.500% ## ( 1900, 2900 ] 9 11.250% 93.750% ## ( 2900, 4400 ] 4 5.000% 98.750% # ( 4400, 6600 ] 1 1.250% 100.000% ** DB Stats ** Uptime(secs): 18.7 total, 6.5 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 263.46 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:5.016 H:M:S, 26.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 152.46 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:3.602 H:M:S, 55.8 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 5 num-running-flushes: 1 2024/12/16-23:59:26 ... thread 0: (1000000,6000000) ops and (326901.3,278562.7) ops/second in (3.059027,21.539134) 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.01 GB 18.9 4.9 0.0 4.9 10.5 5.6 0.0 1.9 140.4 302.0 35.43 33.11 98 0.362 5052K 7590 0.0 0.0 L1 10/10 609.95 MB 0.0 2.8 2.5 0.4 2.8 2.4 0.1 1.1 234.0 232.3 12.32 11.89 3 4.106 2927K 20K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.0 0.1 0.1 2.0 1.8 234.3 234.2 0.47 0.45 1 0.474 112K 40 0.0 0.0 L3 14/0 929.02 MB 0.9 1.5 0.7 0.8 1.5 0.7 1.3 2.2 215.2 215.1 7.17 6.34 5 1.433 1525K 729 0.0 0.0 L4 164/0 9.47 GB 1.0 0.8 0.6 0.2 0.8 0.6 1.2 1.3 172.1 171.4 4.56 3.54 5 0.913 787K 3034 0.0 0.0 L5 1068/0 87.72 GB 0.9 0.0 0.0 0.0 0.0 0.0 2.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1270/21 101.70 GB 0.0 10.1 3.8 6.3 15.6 9.4 6.6 2.8 171.8 266.8 59.96 55.33 112 0.535 10M 31K 0.0 0.0 Int 0/0 0.00 KB 0.0 10.1 3.8 6.3 15.6 9.4 6.6 2.8 171.8 266.8 59.96 55.33 112 0.535 10M 31K 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 10.1 3.8 6.3 10.0 3.8 0.0 0.0 237.0 236.3 43.45 40.78 30 1.448 10M 31K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 5.6 5.6 0.0 0.0 0.0 347.3 16.51 14.55 82 0.201 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 21.7 total, 21.5 interval Flush(GB): cumulative 5.598, interval 5.598 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 15.62 GB write, 735.97 MB/s write, 10.06 GB read, 473.75 MB/s read, 60.0 seconds Interval compaction: 15.62 GB write, 742.68 MB/s write, 10.06 GB read, 478.08 MB/s read, 60.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: 30, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 10, total-stops: 30, interval: 40 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1970041 Average: 2.2208 StdDev: 12.68 Min: 0 Median: 1.4516 Max: 4016 Percentiles: P50: 1.45 P75: 1.84 P99: 5.81 P99.9: 11.91 P99.99: 130.42 ------------------------------------------------------ [ 0, 1 ] 412279 20.927% 20.927% #### ( 1, 2 ] 1268226 64.376% 85.303% ############# ( 2, 3 ] 156702 7.954% 93.257% ## ( 3, 4 ] 68132 3.458% 96.716% # ( 4, 6 ] 49836 2.530% 99.245% # ( 6, 10 ] 12185 0.619% 99.864% ( 10, 15 ] 1865 0.095% 99.959% ( 15, 22 ] 248 0.013% 99.971% ( 22, 34 ] 21 0.001% 99.972% ( 34, 51 ] 9 0.000% 99.973% ( 51, 76 ] 30 0.002% 99.974% ( 76, 110 ] 214 0.011% 99.985% ( 110, 170 ] 288 0.015% 100.000% ( 170, 250 ] 148 0.008% 100.007% ( 250, 380 ] 95 0.005% 100.012% ( 380, 580 ] 66 0.003% 100.015% ( 580, 870 ] 51 0.003% 100.018% ( 870, 1300 ] 28 0.001% 100.019% ( 1300, 1900 ] 10 0.001% 100.020% ( 1900, 2900 ] 14 0.001% 100.021% ( 2900, 4400 ] 12 0.001% 100.021% ** Level 1 read latency histogram (micros): Count: 355056 Average: 2.7846 StdDev: 21.85 Min: 0 Median: 1.6227 Max: 4015 Percentiles: P50: 1.62 P75: 2.14 P99: 7.31 P99.9: 14.86 P99.99: 225.12 ------------------------------------------------------ [ 0, 1 ] 42471 11.962% 11.962% ## ( 1, 2 ] 216904 61.090% 73.052% ############ ( 2, 3 ] 48213 13.579% 86.631% ### ( 3, 4 ] 21367 6.018% 92.649% # ( 4, 6 ] 21308 6.001% 98.650% # ( 6, 10 ] 3808 1.073% 99.723% ( 10, 15 ] 648 0.183% 99.905% ( 15, 22 ] 97 0.027% 99.932% ( 22, 34 ] 9 0.003% 99.935% ( 34, 51 ] 35 0.010% 99.945% ( 51, 76 ] 20 0.006% 99.950% ( 76, 110 ] 66 0.019% 99.969% ( 110, 170 ] 49 0.014% 99.983% ( 170, 250 ] 37 0.010% 99.993% ( 250, 380 ] 30 0.008% 100.002% ( 380, 580 ] 39 0.011% 100.013% ( 580, 870 ] 17 0.005% 100.017% ( 870, 1300 ] 21 0.006% 100.023% ( 1300, 1900 ] 11 0.003% 100.026% ( 1900, 2900 ] 3 0.001% 100.027% ( 2900, 4400 ] 6 0.002% 100.029% ** Level 2 read latency histogram (micros): Count: 28188 Average: 2.1306 StdDev: 8.52 Min: 1 Median: 1.3563 Max: 807 Percentiles: P50: 1.36 P75: 1.78 P99: 6.85 P99.9: 13.47 P99.99: 525.41 ------------------------------------------------------ [ 0, 1 ] 8190 29.055% 29.055% ###### ( 1, 2 ] 16571 58.787% 87.842% ############ ( 2, 3 ] 1634 5.797% 93.639% # ( 3, 4 ] 874 3.101% 96.740% # ( 4, 6 ] 574 2.036% 98.776% ( 6, 10 ] 296 1.050% 99.826% ( 10, 15 ] 30 0.106% 99.933% ( 15, 22 ] 5 0.018% 99.950% ( 22, 34 ] 1 0.004% 99.954% ( 51, 76 ] 1 0.004% 99.957% ( 110, 170 ] 1 0.004% 99.961% ( 170, 250 ] 2 0.007% 99.968% ( 250, 380 ] 4 0.014% 99.982% ( 380, 580 ] 3 0.011% 99.993% ( 580, 870 ] 2 0.007% 100.000% ** Level 3 read latency histogram (micros): Count: 284592 Average: 5.1267 StdDev: 55.70 Min: 1 Median: 1.6666 Max: 5397 Percentiles: P50: 1.67 P75: 2.38 P99: 11.38 P99.9: 493.37 P99.99: 1063.43 ------------------------------------------------------ [ 0, 1 ] 31312 11.002% 11.002% ## ( 1, 2 ] 166485 58.500% 69.502% ############ ( 2, 3 ] 41517 14.588% 84.090% ### ( 3, 4 ] 19374 6.808% 90.898% # ( 4, 6 ] 16952 5.957% 96.854% # ( 6, 10 ] 5805 2.040% 98.894% ( 10, 15 ] 1090 0.383% 99.277% ( 15, 22 ] 159 0.056% 99.333% ( 22, 34 ] 50 0.018% 99.351% ( 34, 51 ] 21 0.007% 99.358% ( 51, 76 ] 11 0.004% 99.362% ( 76, 110 ] 233 0.082% 99.444% ( 110, 170 ] 528 0.186% 99.629% ( 170, 250 ] 342 0.120% 99.749% ( 250, 380 ] 285 0.100% 99.850% ( 380, 580 ] 253 0.089% 99.939% ( 580, 870 ] 120 0.042% 99.981% ( 870, 1300 ] 59 0.021% 100.001% ( 1300, 1900 ] 14 0.005% 100.006% ( 1900, 2900 ] 43 0.015% 100.021% ( 2900, 4400 ] 22 0.008% 100.029% ( 4400, 6600 ] 4 0.001% 100.031% ** Level 4 read latency histogram (micros): Count: 12521 Average: 7.5665 StdDev: 113.83 Min: 0 Median: 1.4682 Max: 5232 Percentiles: P50: 1.47 P75: 1.85 P99: 8.54 P99.9: 2111.29 P99.99: 4336.97 ------------------------------------------------------ [ 0, 1 ] 2454 19.599% 19.599% #### ( 1, 2 ] 8130 64.931% 84.530% ############# ( 2, 3 ] 1022 8.162% 92.692% ## ( 3, 4 ] 533 4.257% 96.949% # ( 4, 6 ] 220 1.757% 98.706% ( 6, 10 ] 58 0.463% 99.169% ( 10, 15 ] 21 0.168% 99.337% ( 15, 22 ] 1 0.008% 99.345% ( 22, 34 ] 15 0.120% 99.465% ( 34, 51 ] 3 0.024% 99.489% ( 51, 76 ] 1 0.008% 99.497% ( 76, 110 ] 1 0.008% 99.505% ( 110, 170 ] 14 0.112% 99.617% ( 170, 250 ] 2 0.016% 99.633% ( 250, 380 ] 5 0.040% 99.673% ( 380, 580 ] 10 0.080% 99.752% ( 580, 870 ] 7 0.056% 99.808% ( 870, 1300 ] 7 0.056% 99.864% ( 1300, 1900 ] 3 0.024% 99.888% ( 1900, 2900 ] 7 0.056% 99.944% ( 2900, 4400 ] 6 0.048% 99.992% ( 4400, 6600 ] 1 0.008% 100.000% ** Level 5 read latency histogram (micros): Count: 120 Average: 889.1500 StdDev: 998.41 Min: 96 Median: 455.0000 Max: 4908 Percentiles: P50: 455.00 P75: 1177.14 P99: 4350.00 P99.9: 4908.00 P99.99: 4908.00 ------------------------------------------------------ ( 76, 110 ] 4 3.333% 3.333% # ( 110, 170 ] 15 12.500% 15.833% ### ( 170, 250 ] 19 15.833% 31.667% ### ( 250, 380 ] 16 13.333% 45.000% ### ( 380, 580 ] 16 13.333% 58.333% ### ( 580, 870 ] 15 12.500% 70.833% ### ( 870, 1300 ] 7 5.833% 76.667% # ( 1300, 1900 ] 9 7.500% 84.167% ## ( 1900, 2900 ] 12 10.000% 94.167% ## ( 2900, 4400 ] 6 5.000% 99.167% # ( 4400, 6600 ] 1 0.833% 100.000% ** DB Stats ** Uptime(secs): 21.7 total, 3.1 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 271.66 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:5.426 H:M:S, 25.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 321.73 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.410 H:M:S, 13.4 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/12/16-23:59:29 ... thread 0: (1000000,7000000) ops and (260591.8,275845.2) ops/second in (3.837419,25.376553) 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 125.9 5.9 0.0 5.9 12.5 6.6 0.0 1.9 142.3 302.1 42.51 39.78 118 0.360 6140K 8665 0.0 0.0 L1 10/10 609.95 MB 0.0 2.8 2.5 0.4 2.8 2.4 0.1 1.1 234.0 232.3 12.32 11.89 3 4.106 2927K 20K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.0 0.1 0.1 2.0 1.8 234.3 234.2 0.47 0.45 1 0.474 112K 40 0.0 0.0 L3 14/0 929.02 MB 0.9 1.5 0.7 0.8 1.5 0.7 1.3 2.2 215.2 215.1 7.17 6.34 5 1.433 1525K 729 0.0 0.0 L4 164/0 9.47 GB 1.0 0.8 0.6 0.2 0.8 0.6 1.2 1.3 172.1 171.4 4.56 3.54 5 0.913 787K 3034 0.0 0.0 L5 1068/0 87.72 GB 0.9 0.0 0.0 0.0 0.0 0.0 2.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1274/21 102.75 GB 0.0 11.1 3.8 7.3 17.7 10.4 6.6 2.7 169.6 270.6 67.03 62.00 132 0.508 11M 32K 0.0 0.0 Int 0/0 0.00 KB 0.0 11.1 3.8 7.3 17.7 10.4 6.6 2.7 169.6 270.6 67.03 62.00 132 0.508 11M 32K 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 11.1 3.8 7.3 11.1 3.8 0.0 0.0 239.4 238.7 47.49 44.75 34 1.397 11M 32K 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 348.2 19.54 17.25 98 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): 25.6 total, 25.4 interval Flush(GB): cumulative 6.644, interval 6.644 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 17.71 GB write, 709.24 MB/s write, 11.10 GB read, 444.54 MB/s read, 67.0 seconds Interval compaction: 17.71 GB write, 714.74 MB/s write, 11.10 GB read, 447.99 MB/s read, 67.0 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 17, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 17, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 31, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 17, total-stops: 31, interval: 48 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2465782 Average: 2.2023 StdDev: 11.62 Min: 0 Median: 1.4565 Max: 4016 Percentiles: P50: 1.46 P75: 1.84 P99: 5.79 P99.9: 11.22 P99.99: 93.46 ------------------------------------------------------ [ 0, 1 ] 500681 20.305% 20.305% #### ( 1, 2 ] 1604092 65.054% 85.359% ############# ( 2, 3 ] 197236 7.999% 93.358% ## ( 3, 4 ] 85270 3.458% 96.816% # ( 4, 6 ] 60062 2.436% 99.252% ( 6, 10 ] 15414 0.625% 99.877% ( 10, 15 ] 2304 0.093% 99.971% ( 15, 22 ] 296 0.012% 99.983% ( 22, 34 ] 24 0.001% 99.984% ( 34, 51 ] 16 0.001% 99.984% ( 51, 76 ] 30 0.001% 99.986% ( 76, 110 ] 217 0.009% 99.994% ( 110, 170 ] 296 0.012% 100.006% ( 170, 250 ] 158 0.006% 100.013% ( 250, 380 ] 102 0.004% 100.017% ( 380, 580 ] 72 0.003% 100.020% ( 580, 870 ] 60 0.002% 100.022% ( 870, 1300 ] 31 0.001% 100.023% ( 1300, 1900 ] 11 0.000% 100.024% ( 1900, 2900 ] 15 0.001% 100.025% ( 2900, 4400 ] 12 0.000% 100.025% ** Level 1 read latency histogram (micros): Count: 355056 Average: 2.7846 StdDev: 21.85 Min: 0 Median: 1.6227 Max: 4015 Percentiles: P50: 1.62 P75: 2.14 P99: 7.31 P99.9: 14.86 P99.99: 225.12 ------------------------------------------------------ [ 0, 1 ] 42471 11.962% 11.962% ## ( 1, 2 ] 216904 61.090% 73.052% ############ ( 2, 3 ] 48213 13.579% 86.631% ### ( 3, 4 ] 21367 6.018% 92.649% # ( 4, 6 ] 21308 6.001% 98.650% # ( 6, 10 ] 3808 1.073% 99.723% ( 10, 15 ] 648 0.183% 99.905% ( 15, 22 ] 97 0.027% 99.932% ( 22, 34 ] 9 0.003% 99.935% ( 34, 51 ] 35 0.010% 99.945% ( 51, 76 ] 20 0.006% 99.950% ( 76, 110 ] 66 0.019% 99.969% ( 110, 170 ] 49 0.014% 99.983% ( 170, 250 ] 37 0.010% 99.993% ( 250, 380 ] 30 0.008% 100.002% ( 380, 580 ] 39 0.011% 100.013% ( 580, 870 ] 17 0.005% 100.017% ( 870, 1300 ] 21 0.006% 100.023% ( 1300, 1900 ] 11 0.003% 100.026% ( 1900, 2900 ] 3 0.001% 100.027% ( 2900, 4400 ] 6 0.002% 100.029% ** Level 2 read latency histogram (micros): Count: 28188 Average: 2.1306 StdDev: 8.52 Min: 1 Median: 1.3563 Max: 807 Percentiles: P50: 1.36 P75: 1.78 P99: 6.85 P99.9: 13.47 P99.99: 525.41 ------------------------------------------------------ [ 0, 1 ] 8190 29.055% 29.055% ###### ( 1, 2 ] 16571 58.787% 87.842% ############ ( 2, 3 ] 1634 5.797% 93.639% # ( 3, 4 ] 874 3.101% 96.740% # ( 4, 6 ] 574 2.036% 98.776% ( 6, 10 ] 296 1.050% 99.826% ( 10, 15 ] 30 0.106% 99.933% ( 15, 22 ] 5 0.018% 99.950% ( 22, 34 ] 1 0.004% 99.954% ( 51, 76 ] 1 0.004% 99.957% ( 110, 170 ] 1 0.004% 99.961% ( 170, 250 ] 2 0.007% 99.968% ( 250, 380 ] 4 0.014% 99.982% ( 380, 580 ] 3 0.011% 99.993% ( 580, 870 ] 2 0.007% 100.000% ** Level 3 read latency histogram (micros): Count: 284592 Average: 5.1267 StdDev: 55.70 Min: 1 Median: 1.6666 Max: 5397 Percentiles: P50: 1.67 P75: 2.38 P99: 11.38 P99.9: 493.37 P99.99: 1063.43 ------------------------------------------------------ [ 0, 1 ] 31312 11.002% 11.002% ## ( 1, 2 ] 166485 58.500% 69.502% ############ ( 2, 3 ] 41517 14.588% 84.090% ### ( 3, 4 ] 19374 6.808% 90.898% # ( 4, 6 ] 16952 5.957% 96.854% # ( 6, 10 ] 5805 2.040% 98.894% ( 10, 15 ] 1090 0.383% 99.277% ( 15, 22 ] 159 0.056% 99.333% ( 22, 34 ] 50 0.018% 99.351% ( 34, 51 ] 21 0.007% 99.358% ( 51, 76 ] 11 0.004% 99.362% ( 76, 110 ] 233 0.082% 99.444% ( 110, 170 ] 528 0.186% 99.629% ( 170, 250 ] 342 0.120% 99.749% ( 250, 380 ] 285 0.100% 99.850% ( 380, 580 ] 253 0.089% 99.939% ( 580, 870 ] 120 0.042% 99.981% ( 870, 1300 ] 59 0.021% 100.001% ( 1300, 1900 ] 14 0.005% 100.006% ( 1900, 2900 ] 43 0.015% 100.021% ( 2900, 4400 ] 22 0.008% 100.029% ( 4400, 6600 ] 4 0.001% 100.031% ** Level 4 read latency histogram (micros): Count: 12521 Average: 7.5665 StdDev: 113.83 Min: 0 Median: 1.4682 Max: 5232 Percentiles: P50: 1.47 P75: 1.85 P99: 8.54 P99.9: 2111.29 P99.99: 4336.97 ------------------------------------------------------ [ 0, 1 ] 2454 19.599% 19.599% #### ( 1, 2 ] 8130 64.931% 84.530% ############# ( 2, 3 ] 1022 8.162% 92.692% ## ( 3, 4 ] 533 4.257% 96.949% # ( 4, 6 ] 220 1.757% 98.706% ( 6, 10 ] 58 0.463% 99.169% ( 10, 15 ] 21 0.168% 99.337% ( 15, 22 ] 1 0.008% 99.345% ( 22, 34 ] 15 0.120% 99.465% ( 34, 51 ] 3 0.024% 99.489% ( 51, 76 ] 1 0.008% 99.497% ( 76, 110 ] 1 0.008% 99.505% ( 110, 170 ] 14 0.112% 99.617% ( 170, 250 ] 2 0.016% 99.633% ( 250, 380 ] 5 0.040% 99.673% ( 380, 580 ] 10 0.080% 99.752% ( 580, 870 ] 7 0.056% 99.808% ( 870, 1300 ] 7 0.056% 99.864% ( 1300, 1900 ] 3 0.024% 99.888% ( 1900, 2900 ] 7 0.056% 99.944% ( 2900, 4400 ] 6 0.048% 99.992% ( 4400, 6600 ] 1 0.008% 100.000% ** Level 5 read latency histogram (micros): Count: 120 Average: 889.1500 StdDev: 998.41 Min: 96 Median: 455.0000 Max: 4908 Percentiles: P50: 455.00 P75: 1177.14 P99: 4350.00 P99.9: 4908.00 P99.99: 4908.00 ------------------------------------------------------ ( 76, 110 ] 4 3.333% 3.333% # ( 110, 170 ] 15 12.500% 15.833% ### ( 170, 250 ] 19 15.833% 31.667% ### ( 250, 380 ] 16 13.333% 45.000% ### ( 380, 580 ] 16 13.333% 58.333% ### ( 580, 870 ] 15 12.500% 70.833% ### ( 870, 1300 ] 7 5.833% 76.667% # ( 1300, 1900 ] 9 7.500% 84.167% ## ( 1900, 2900 ] 12 10.000% 94.167% ## ( 2900, 4400 ] 6 5.000% 99.167% # ( 4400, 6600 ] 1 0.833% 100.000% ** DB Stats ** Uptime(secs): 25.6 total, 3.8 interval Cumulative writes: 0 writes, 7000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 6.73 GB, 269.38 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:6.524 H:M:S, 25.5 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 256.47 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.098 H:M:S, 28.6 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/12/16-23:59:39 ... thread 0: (1000000,8000000) ops and (107405.8,230633.7) ops/second in (9.310483,34.687036) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 19/15 4.97 GB 194.4 7.9 0.0 7.9 15.5 7.6 0.0 2.0 152.5 297.5 53.29 49.79 137 0.389 8249K 16K 0.0 0.0 L1 10/10 609.95 MB 0.0 2.8 2.5 0.4 2.8 2.4 0.1 1.1 234.0 232.3 12.32 11.89 3 4.106 2927K 20K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.0 0.1 0.1 2.0 1.8 234.3 234.2 0.47 0.45 1 0.474 112K 40 0.0 0.0 L3 14/0 929.02 MB 0.9 1.5 0.7 0.8 1.5 0.7 1.3 2.2 215.2 215.1 7.17 6.34 5 1.433 1525K 729 0.0 0.0 L4 164/0 9.47 GB 1.0 0.8 0.6 0.2 0.8 0.6 1.2 1.3 172.1 171.4 4.56 3.54 5 0.913 787K 3034 0.0 0.0 L5 1068/0 87.72 GB 0.9 0.0 0.0 0.0 0.0 0.0 2.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1275/25 103.66 GB 0.0 13.1 3.8 9.3 20.7 11.3 6.6 2.7 172.8 271.8 77.81 72.01 151 0.515 13M 41K 0.0 0.0 Int 0/0 0.00 KB 0.0 13.1 3.8 9.3 20.7 11.3 6.6 2.7 172.8 271.8 77.81 72.01 151 0.515 13M 41K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 13.1 3.8 9.3 13.1 3.7 0.0 0.0 242.1 241.4 55.54 52.33 38 1.461 13M 41K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 7.6 7.6 0.0 0.0 0.0 347.8 22.28 19.69 113 0.197 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 34.9 total, 34.7 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: 20.66 GB write, 606.37 MB/s write, 13.13 GB read, 385.46 MB/s read, 77.8 seconds Interval compaction: 20.66 GB write, 609.81 MB/s write, 13.13 GB read, 387.64 MB/s read, 77.8 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 25, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 25, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 31, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 25, total-stops: 31, interval: 56 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3442707 Average: 2.4302 StdDev: 13.96 Min: 0 Median: 1.4504 Max: 4016 Percentiles: P50: 1.45 P75: 1.83 P99: 6.06 P99.9: 108.48 P99.99: 219.00 ------------------------------------------------------ [ 0, 1 ] 700935 20.360% 20.360% #### ( 1, 2 ] 2265620 65.809% 86.169% ############# ( 2, 3 ] 255026 7.408% 93.577% # ( 3, 4 ] 113641 3.301% 96.878% # ( 4, 6 ] 72691 2.111% 98.989% ( 6, 10 ] 24760 0.719% 99.709% ( 10, 15 ] 3257 0.095% 99.803% ( 15, 22 ] 526 0.015% 99.818% ( 22, 34 ] 34 0.001% 99.819% ( 34, 51 ] 20 0.001% 99.820% ( 51, 76 ] 103 0.003% 99.823% ( 76, 110 ] 2776 0.081% 99.904% ( 110, 170 ] 2576 0.075% 99.978% ( 170, 250 ] 651 0.019% 99.997% ( 250, 380 ] 416 0.012% 100.009% ( 380, 580 ] 297 0.009% 100.018% ( 580, 870 ] 137 0.004% 100.022% ( 870, 1300 ] 48 0.001% 100.023% ( 1300, 1900 ] 20 0.001% 100.024% ( 1900, 2900 ] 22 0.001% 100.025% ( 2900, 4400 ] 18 0.001% 100.025% ** Level 1 read latency histogram (micros): Count: 455627 Average: 2.8840 StdDev: 22.02 Min: 0 Median: 1.5835 Max: 4015 Percentiles: P50: 1.58 P75: 1.98 P99: 7.94 P99.9: 119.61 P99.99: 356.17 ------------------------------------------------------ [ 0, 1 ] 60799 13.344% 13.344% ### ( 1, 2 ] 286250 62.826% 76.170% ############# ( 2, 3 ] 54195 11.895% 88.064% ## ( 3, 4 ] 24418 5.359% 93.423% # ( 4, 6 ] 22839 5.013% 98.436% # ( 6, 10 ] 5292 1.161% 99.597% ( 10, 15 ] 747 0.164% 99.761% ( 15, 22 ] 125 0.027% 99.789% ( 22, 34 ] 9 0.002% 99.791% ( 34, 51 ] 35 0.008% 99.799% ( 51, 76 ] 31 0.007% 99.805% ( 76, 110 ] 384 0.084% 99.890% ( 110, 170 ] 302 0.066% 99.956% ( 170, 250 ] 96 0.021% 99.977% ( 250, 380 ] 74 0.016% 99.993% ( 380, 580 ] 63 0.014% 100.007% ( 580, 870 ] 25 0.005% 100.013% ( 870, 1300 ] 24 0.005% 100.018% ( 1300, 1900 ] 12 0.003% 100.020% ( 1900, 2900 ] 3 0.001% 100.021% ( 2900, 4400 ] 8 0.002% 100.023% ** Level 2 read latency histogram (micros): Count: 28188 Average: 2.1306 StdDev: 8.52 Min: 1 Median: 1.3563 Max: 807 Percentiles: P50: 1.36 P75: 1.78 P99: 6.85 P99.9: 13.47 P99.99: 525.41 ------------------------------------------------------ [ 0, 1 ] 8190 29.055% 29.055% ###### ( 1, 2 ] 16571 58.787% 87.842% ############ ( 2, 3 ] 1634 5.797% 93.639% # ( 3, 4 ] 874 3.101% 96.740% # ( 4, 6 ] 574 2.036% 98.776% ( 6, 10 ] 296 1.050% 99.826% ( 10, 15 ] 30 0.106% 99.933% ( 15, 22 ] 5 0.018% 99.950% ( 22, 34 ] 1 0.004% 99.954% ( 51, 76 ] 1 0.004% 99.957% ( 110, 170 ] 1 0.004% 99.961% ( 170, 250 ] 2 0.007% 99.968% ( 250, 380 ] 4 0.014% 99.982% ( 380, 580 ] 3 0.011% 99.993% ( 580, 870 ] 2 0.007% 100.000% ** Level 3 read latency histogram (micros): Count: 284592 Average: 5.1267 StdDev: 55.70 Min: 1 Median: 1.6666 Max: 5397 Percentiles: P50: 1.67 P75: 2.38 P99: 11.38 P99.9: 493.37 P99.99: 1063.43 ------------------------------------------------------ [ 0, 1 ] 31312 11.002% 11.002% ## ( 1, 2 ] 166485 58.500% 69.502% ############ ( 2, 3 ] 41517 14.588% 84.090% ### ( 3, 4 ] 19374 6.808% 90.898% # ( 4, 6 ] 16952 5.957% 96.854% # ( 6, 10 ] 5805 2.040% 98.894% ( 10, 15 ] 1090 0.383% 99.277% ( 15, 22 ] 159 0.056% 99.333% ( 22, 34 ] 50 0.018% 99.351% ( 34, 51 ] 21 0.007% 99.358% ( 51, 76 ] 11 0.004% 99.362% ( 76, 110 ] 233 0.082% 99.444% ( 110, 170 ] 528 0.186% 99.629% ( 170, 250 ] 342 0.120% 99.749% ( 250, 380 ] 285 0.100% 99.850% ( 380, 580 ] 253 0.089% 99.939% ( 580, 870 ] 120 0.042% 99.981% ( 870, 1300 ] 59 0.021% 100.001% ( 1300, 1900 ] 14 0.005% 100.006% ( 1900, 2900 ] 43 0.015% 100.021% ( 2900, 4400 ] 22 0.008% 100.029% ( 4400, 6600 ] 4 0.001% 100.031% ** Level 4 read latency histogram (micros): Count: 12521 Average: 7.5665 StdDev: 113.83 Min: 0 Median: 1.4682 Max: 5232 Percentiles: P50: 1.47 P75: 1.85 P99: 8.54 P99.9: 2111.29 P99.99: 4336.97 ------------------------------------------------------ [ 0, 1 ] 2454 19.599% 19.599% #### ( 1, 2 ] 8130 64.931% 84.530% ############# ( 2, 3 ] 1022 8.162% 92.692% ## ( 3, 4 ] 533 4.257% 96.949% # ( 4, 6 ] 220 1.757% 98.706% ( 6, 10 ] 58 0.463% 99.169% ( 10, 15 ] 21 0.168% 99.337% ( 15, 22 ] 1 0.008% 99.345% ( 22, 34 ] 15 0.120% 99.465% ( 34, 51 ] 3 0.024% 99.489% ( 51, 76 ] 1 0.008% 99.497% ( 76, 110 ] 1 0.008% 99.505% ( 110, 170 ] 14 0.112% 99.617% ( 170, 250 ] 2 0.016% 99.633% ( 250, 380 ] 5 0.040% 99.673% ( 380, 580 ] 10 0.080% 99.752% ( 580, 870 ] 7 0.056% 99.808% ( 870, 1300 ] 7 0.056% 99.864% ( 1300, 1900 ] 3 0.024% 99.888% ( 1900, 2900 ] 7 0.056% 99.944% ( 2900, 4400 ] 6 0.048% 99.992% ( 4400, 6600 ] 1 0.008% 100.000% ** Level 5 read latency histogram (micros): Count: 120 Average: 889.1500 StdDev: 998.41 Min: 96 Median: 455.0000 Max: 4908 Percentiles: P50: 455.00 P75: 1177.14 P99: 4350.00 P99.9: 4908.00 P99.99: 4908.00 ------------------------------------------------------ ( 76, 110 ] 4 3.333% 3.333% # ( 110, 170 ] 15 12.500% 15.833% ### ( 170, 250 ] 19 15.833% 31.667% ### ( 250, 380 ] 16 13.333% 45.000% ### ( 380, 580 ] 16 13.333% 58.333% ### ( 580, 870 ] 15 12.500% 70.833% ### ( 870, 1300 ] 7 5.833% 76.667% # ( 1300, 1900 ] 9 7.500% 84.167% ## ( 1900, 2900 ] 12 10.000% 94.167% ## ( 2900, 4400 ] 6 5.000% 99.167% # ( 4400, 6600 ] 1 0.833% 100.000% ** DB Stats ** Uptime(secs): 34.9 total, 9.3 interval Cumulative writes: 0 writes, 8000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 7.69 GB, 225.70 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:13.018 H:M:S, 37.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 105.71 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:6.494 H:M:S, 69.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/16-23:59:45 ... thread 0: (1000000,9000000) ops and (171989.7,222214.9) ops/second in (5.814300,40.501336) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 13/11 3.07 GB 12.6 8.7 0.0 8.7 17.1 8.5 0.0 2.0 149.4 295.4 59.44 55.10 154 0.386 9017K 17K 0.0 0.0 L1 22/22 2.29 GB 0.0 6.2 5.3 1.0 6.2 5.2 0.1 1.2 226.2 223.6 28.22 26.67 4 7.056 6407K 20K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.0 0.1 0.1 3.0 1.8 234.3 234.2 0.47 0.45 1 0.474 112K 40 0.0 0.0 L3 17/0 959.36 MB 1.0 2.7 1.4 1.3 2.7 1.4 1.7 2.0 213.9 212.6 13.06 11.80 9 1.451 2795K 15K 0.0 0.0 L4 168/0 9.51 GB 1.0 1.9 1.6 0.3 1.9 1.6 1.2 1.2 152.9 152.2 12.99 9.07 20 0.650 1997K 8969 0.0 0.0 L5 1080/0 88.71 GB 0.9 0.0 0.0 0.0 0.0 0.0 3.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1300/33 104.51 GB 0.0 19.7 8.4 11.3 28.1 16.7 9.1 3.3 176.5 251.6 114.19 103.09 188 0.607 20M 62K 0.0 0.0 Int 0/0 0.00 KB 0.0 19.7 8.4 11.3 28.1 16.7 9.0 3.3 176.5 251.6 114.19 103.09 188 0.607 20M 62K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 19.7 8.4 11.3 19.6 8.3 0.0 0.0 227.3 226.0 88.67 80.96 61 1.454 20M 62K 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 340.7 25.52 22.13 127 0.201 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 40.7 total, 40.5 interval Flush(GB): cumulative 8.490, interval 8.490 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 28.06 GB write, 705.95 MB/s write, 19.68 GB read, 495.25 MB/s read, 114.2 seconds Interval compaction: 28.06 GB write, 709.38 MB/s write, 19.68 GB read, 497.66 MB/s read, 114.2 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 30, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 30, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 41, pending-compaction-bytes-delays: 9, pending-compaction-bytes-stops: 0, total-delays: 39, total-stops: 41, interval: 80 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3822140 Average: 2.4877 StdDev: 16.08 Min: 0 Median: 1.4596 Max: 7185 Percentiles: P50: 1.46 P75: 1.84 P99: 6.36 P99.9: 110.81 P99.99: 241.71 ------------------------------------------------------ [ 0, 1 ] 760483 19.897% 19.897% #### ( 1, 2 ] 2503336 65.496% 85.392% ############# ( 2, 3 ] 295301 7.726% 93.119% ## ( 3, 4 ] 132154 3.458% 96.576% # ( 4, 6 ] 90016 2.355% 98.931% ( 6, 10 ] 29216 0.764% 99.696% ( 10, 15 ] 4013 0.105% 99.801% ( 15, 22 ] 618 0.016% 99.817% ( 22, 34 ] 42 0.001% 99.818% ( 34, 51 ] 20 0.001% 99.818% ( 51, 76 ] 104 0.003% 99.821% ( 76, 110 ] 2979 0.078% 99.899% ( 110, 170 ] 2793 0.073% 99.972% ( 170, 250 ] 764 0.020% 99.992% ( 250, 380 ] 491 0.013% 100.005% ( 380, 580 ] 379 0.010% 100.015% ( 580, 870 ] 189 0.005% 100.020% ( 870, 1300 ] 78 0.002% 100.022% ( 1300, 1900 ] 33 0.001% 100.023% ( 1900, 2900 ] 31 0.001% 100.024% ( 2900, 4400 ] 25 0.001% 100.024% ( 6600, 9900 ] 1 0.000% 100.024% ** Level 1 read latency histogram (micros): Count: 825920 Average: 3.2556 StdDev: 24.12 Min: 0 Median: 1.6422 Max: 4015 Percentiles: P50: 1.64 P75: 2.25 P99: 8.69 P99.9: 110.94 P99.99: 219.61 ------------------------------------------------------ [ 0, 1 ] 90364 10.941% 10.941% ## ( 1, 2 ] 502355 60.824% 71.765% ############ ( 2, 3 ] 108401 13.125% 84.890% ### ( 3, 4 ] 55270 6.692% 91.582% # ( 4, 6 ] 52131 6.312% 97.893% # ( 6, 10 ] 13612 1.648% 99.541% ( 10, 15 ] 1980 0.240% 99.781% ( 15, 22 ] 303 0.037% 99.818% ( 22, 34 ] 21 0.003% 99.820% ( 34, 51 ] 38 0.005% 99.825% ( 51, 76 ] 40 0.005% 99.830% ( 76, 110 ] 570 0.069% 99.899% ( 110, 170 ] 580 0.070% 99.969% ( 170, 250 ] 278 0.034% 100.003% ( 250, 380 ] 263 0.032% 100.035% ( 380, 580 ] 238 0.029% 100.063% ( 580, 870 ] 125 0.015% 100.079% ( 870, 1300 ] 66 0.008% 100.087% ( 1300, 1900 ] 27 0.003% 100.090% ( 1900, 2900 ] 8 0.001% 100.091% ( 2900, 4400 ] 11 0.001% 100.092% ** Level 2 read latency histogram (micros): Count: 28188 Average: 2.1306 StdDev: 8.52 Min: 1 Median: 1.3563 Max: 807 Percentiles: P50: 1.36 P75: 1.78 P99: 6.85 P99.9: 13.47 P99.99: 525.41 ------------------------------------------------------ [ 0, 1 ] 8190 29.055% 29.055% ###### ( 1, 2 ] 16571 58.787% 87.842% ############ ( 2, 3 ] 1634 5.797% 93.639% # ( 3, 4 ] 874 3.101% 96.740% # ( 4, 6 ] 574 2.036% 98.776% ( 6, 10 ] 296 1.050% 99.826% ( 10, 15 ] 30 0.106% 99.933% ( 15, 22 ] 5 0.018% 99.950% ( 22, 34 ] 1 0.004% 99.954% ( 51, 76 ] 1 0.004% 99.957% ( 110, 170 ] 1 0.004% 99.961% ( 170, 250 ] 2 0.007% 99.968% ( 250, 380 ] 4 0.014% 99.982% ( 380, 580 ] 3 0.011% 99.993% ( 580, 870 ] 2 0.007% 100.000% ** Level 3 read latency histogram (micros): Count: 586399 Average: 5.2943 StdDev: 69.14 Min: 1 Median: 1.7694 Max: 15488 Percentiles: P50: 1.77 P75: 2.70 P99: 9.46 P99.9: 236.45 P99.99: 373.36 ------------------------------------------------------ [ 0, 1 ] 40908 6.976% 6.976% # ( 1, 2 ] 327927 55.922% 62.898% ########### ( 2, 3 ] 101157 17.251% 80.149% ### ( 3, 4 ] 52621 8.974% 89.122% ## ( 4, 6 ] 48905 8.340% 97.462% ## ( 6, 10 ] 10423 1.777% 99.240% ( 10, 15 ] 2188 0.373% 99.613% ( 15, 22 ] 256 0.044% 99.657% ( 22, 34 ] 52 0.009% 99.665% ( 34, 51 ] 22 0.004% 99.669% ( 51, 76 ] 13 0.002% 99.671% ( 76, 110 ] 252 0.043% 99.714% ( 110, 170 ] 655 0.112% 99.826% ( 170, 250 ] 522 0.089% 99.915% ( 250, 380 ] 463 0.079% 99.994% ( 380, 580 ] 459 0.078% 100.072% ( 580, 870 ] 286 0.049% 100.121% ( 870, 1300 ] 117 0.020% 100.141% ( 1300, 1900 ] 40 0.007% 100.148% ( 1900, 2900 ] 77 0.013% 100.161% ( 2900, 4400 ] 75 0.013% 100.174% ( 4400, 6600 ] 10 0.002% 100.175% ( 6600, 9900 ] 5 0.001% 100.176% ( 14000, 22000 ] 1 0.000% 100.177% ** Level 4 read latency histogram (micros): Count: 13622 Average: 8.9728 StdDev: 118.56 Min: 0 Median: 1.4931 Max: 5232 Percentiles: P50: 1.49 P75: 1.89 P99: 14.78 P99.9: 2237.80 P99.99: 4309.45 ------------------------------------------------------ [ 0, 1 ] 2536 18.617% 18.617% #### ( 1, 2 ] 8670 63.647% 82.264% ############# ( 2, 3 ] 1228 9.015% 91.279% ## ( 3, 4 ] 652 4.786% 96.065% # ( 4, 6 ] 306 2.246% 98.312% ( 6, 10 ] 67 0.492% 98.803% ( 10, 15 ] 28 0.206% 99.009% ( 15, 22 ] 3 0.022% 99.031% ( 22, 34 ] 20 0.147% 99.178% ( 34, 51 ] 3 0.022% 99.200% ( 51, 76 ] 4 0.029% 99.229% ( 76, 110 ] 5 0.037% 99.266% ( 110, 170 ] 15 0.110% 99.376% ( 170, 250 ] 15 0.110% 99.486% ( 250, 380 ] 10 0.073% 99.560% ( 380, 580 ] 16 0.117% 99.677% ( 580, 870 ] 14 0.103% 99.780% ( 870, 1300 ] 8 0.059% 99.838% ( 1300, 1900 ] 5 0.037% 99.875% ( 1900, 2900 ] 10 0.073% 99.949% ( 2900, 4400 ] 6 0.044% 99.993% ( 4400, 6600 ] 1 0.007% 100.000% ** Level 5 read latency histogram (micros): Count: 180 Average: 925.3056 StdDev: 1038.77 Min: 96 Median: 434.5455 Max: 4908 Percentiles: P50: 434.55 P75: 1350.00 P99: 4620.00 P99.9: 4908.00 P99.99: 4908.00 ------------------------------------------------------ ( 76, 110 ] 7 3.889% 3.889% # ( 110, 170 ] 23 12.778% 16.667% ### ( 170, 250 ] 29 16.111% 32.778% ### ( 250, 380 ] 25 13.889% 46.667% ### ( 380, 580 ] 22 12.222% 58.889% ## ( 580, 870 ] 17 9.444% 68.333% ## ( 870, 1300 ] 11 6.111% 74.444% # ( 1300, 1900 ] 12 6.667% 81.111% # ( 1900, 2900 ] 21 11.667% 92.778% ## ( 2900, 4400 ] 11 6.111% 98.889% # ( 4400, 6600 ] 2 1.111% 100.000% ** DB Stats ** Uptime(secs): 40.7 total, 5.8 interval Cumulative writes: 0 writes, 9000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 8.65 GB, 217.64 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:15.965 H:M:S, 39.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 169.27 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:2.947 H:M:S, 50.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 using bdev Nvme0n1 Initializing RocksDB Options from the specified file Initializing RocksDB Options from command-line flags Integrated BlobDB: blob cache disabled Keys: 16 bytes each (+ 0 bytes user-defined timestamp) Values: 1000 bytes each (1000 bytes after compression) Entries: 100000000 Prefix: 0 bytes Keys per prefix: 0 RawSize: 96893.3 MB (estimated) FileSize: 96893.3 MB (estimated) Write rate: 0 bytes/second Read rate: 0 ops/second Compression: NoCompression Compression sampling rate: 0 Memtablerep: SkipListFactory Perf Level: 1 ------------------------------------------------ DB path: [/mnt/rocksdb] overwrite : 6.260 micros/op 159743 ops/sec 60.209 seconds 9617999 operations; 154.8 MB/s Microseconds per write: Count: 9617999 Average: 6.2600 StdDev: 245.77 Min: 0 Median: 1.7487 Max: 285903 Percentiles: P50: 1.75 P75: 2.78 P99: 8.78 P99.9: 1266.56 P99.99: 2793.54 ------------------------------------------------------ [ 0, 1 ] 1203095 12.509% 12.509% ### ( 1, 2 ] 4816336 50.076% 62.585% ########## ( 2, 3 ] 1532413 15.933% 78.518% ### ( 3, 4 ] 1362998 14.171% 92.689% ### ( 4, 6 ] 540350 5.618% 98.307% # ( 6, 10 ] 95971 0.998% 99.305% ( 10, 15 ] 26322 0.274% 99.579% ( 15, 22 ] 7915 0.082% 99.661% ( 22, 34 ] 1817 0.019% 99.680% ( 34, 51 ] 178 0.002% 99.682% ( 51, 76 ] 28 0.000% 99.682% ( 76, 110 ] 6750 0.070% 99.752% ( 110, 170 ] 2586 0.027% 99.779% ( 170, 250 ] 287 0.003% 99.782% ( 250, 380 ] 112 0.001% 99.783% ( 380, 580 ] 23 0.000% 99.784% ( 580, 870 ] 16 0.000% 99.784% ( 870, 1300 ] 12127 0.126% 99.910% ( 1300, 1900 ] 27 0.000% 99.910% ( 1900, 2900 ] 8602 0.089% 100.000% ( 2900, 4400 ] 21 0.000% 100.000% ( 4400, 6600 ] 4 0.000% 100.000% ( 6600, 9900 ] 1 0.000% 100.000% ( 14000, 22000 ] 3 0.000% 100.000% ( 22000, 33000 ] 3 0.000% 100.000% ( 50000, 75000 ] 1 0.000% 100.000% ( 110000, 170000 ] 3 0.000% 100.000% ( 170000, 250000 ] 9 0.000% 100.000% ( 250000, 380000 ] 1 0.000% 100.000% STATISTICS: rocksdb.block.cache.miss COUNT : 0 rocksdb.block.cache.hit COUNT : 0 rocksdb.block.cache.add COUNT : 0 rocksdb.block.cache.add.failures COUNT : 0 rocksdb.block.cache.index.miss COUNT : 0 rocksdb.block.cache.index.hit COUNT : 0 rocksdb.block.cache.index.add COUNT : 0 rocksdb.block.cache.index.bytes.insert COUNT : 0 rocksdb.block.cache.filter.miss COUNT : 0 rocksdb.block.cache.filter.hit COUNT : 0 rocksdb.block.cache.filter.add COUNT : 0 rocksdb.block.cache.filter.bytes.insert COUNT : 0 rocksdb.block.cache.data.miss COUNT : 0 rocksdb.block.cache.data.hit COUNT : 0 rocksdb.block.cache.data.add COUNT : 0 rocksdb.block.cache.data.bytes.insert COUNT : 0 rocksdb.block.cache.bytes.read COUNT : 0 rocksdb.block.cache.bytes.write COUNT : 0 rocksdb.bloom.filter.useful COUNT : 0 rocksdb.bloom.filter.full.positive COUNT : 0 rocksdb.bloom.filter.full.true.positive COUNT : 0 rocksdb.persistent.cache.hit COUNT : 0 rocksdb.persistent.cache.miss COUNT : 0 rocksdb.sim.block.cache.hit COUNT : 0 rocksdb.sim.block.cache.miss COUNT : 0 rocksdb.memtable.hit COUNT : 0 rocksdb.memtable.miss COUNT : 0 rocksdb.l0.hit COUNT : 0 rocksdb.l1.hit COUNT : 0 rocksdb.l2andup.hit COUNT : 0 rocksdb.compaction.key.drop.new COUNT : 207517 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 : 9617999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 9925774968 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 : 457 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 33756573 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 : 28144634318 rocksdb.compact.write.bytes COUNT : 27955486126 rocksdb.flush.write.bytes COUNT : 9908788258 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 : 46 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 : 227 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 : 9828679680 rocksdb.memtable.garbage.bytes.at.flush COUNT : 3632128 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 : 28230263739 rocksdb.non.last.level.read.count COUNT : 6823611 rocksdb.block.checksum.compute.count COUNT : 6822743 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.401027 P95 : 3.890732 P99 : 7.160328 P100 : 285901.000000 COUNT : 9617999 SUM : 55663099 rocksdb.compaction.times.micros P50 : 1000689.655172 P95 : 4160000.000000 P99 : 15905889.000000 P100 : 15905889.000000 COUNT : 66 SUM : 96509974 rocksdb.compaction.times.cpu_micros P50 : 969285.714286 P95 : 4160000.000000 P99 : 14784432.000000 P100 : 14784432.000000 COUNT : 66 SUM : 88246245 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 : 697.303371 P95 : 1261.300000 P99 : 7623.000000 P100 : 9183.000000 COUNT : 138 SUM : 113661 rocksdb.compaction.outfile.sync.micros P50 : 837.189781 P95 : 10566.250000 P99 : 57750.000000 P100 : 83849.000000 COUNT : 307 SUM : 870803 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 : 89.830508 P95 : 308.500000 P99 : 1720.000000 P100 : 3954.000000 COUNT : 230 SUM : 35767 rocksdb.table.open.io.micros P50 : 1057.698413 P95 : 6437.200000 P99 : 11560.500000 P100 : 14418.000000 COUNT : 457 SUM : 822797 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.503818 P95 : 6.818642 P99 : 10.628053 P100 : 15492.000000 COUNT : 6821408 SUM : 34641870 rocksdb.read.block.get.micros P50 : 352.631579 P95 : 3119.767442 P99 : 4395.116279 P100 : 5496.000000 COUNT : 914 SUM : 673205 rocksdb.write.raw.block.micros P50 : 0.511924 P95 : 0.972655 P99 : 2.811584 P100 : 39644.000000 COUNT : 9170085 SUM : 16883105 rocksdb.numfiles.in.singlecompaction P50 : 3.325397 P95 : 7.300000 P99 : 21.755000 P100 : 29.000000 COUNT : 107 SUM : 445 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.562602 P95 : 1273.753523 P99 : 2684.285548 P100 : 285692.000000 COUNT : 187234 SUM : 33769854 rocksdb.sst.read.micros P50 : 1.487652 P95 : 3.959513 P99 : 8.336801 P100 : 15488.000000 COUNT : 6823736 SUM : 20865005 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 : 9617999 SUM : 9925774968 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 : 208019.801980 P95 : 341000.000000 P99 : 482600.000000 P100 : 526773.000000 COUNT : 138 SUM : 27665621 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 : 298 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