[2024-11-21 05:09:20.334631] Starting SPDK v25.01-pre git sha1 557f022f6 / DPDK 22.11.4 initialization... [2024-11-21 05:09:20.334779] [ DPDK EAL parameters: rocksdb --no-shconf -c 0x1 --huge-unlink --no-telemetry --log-level=lib.eal:6 --log-level=lib.cryptodev:5 --log-level=lib.power:5 --log-level=user1:6 --base-virtaddr=0x200000000000 --match-allocations --file-prefix=spdk_pid2435810 ] Set seed to 1732162160331139 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-11-21 05:09:20.429764] app.c: 919:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-11-21 05:09:20.453354] app.c: 612:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-11-21 05:09:20.453397] app.c: 613:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 2435810' to capture a snapshot of events at runtime. [2024-11-21 05:09:20.453408] app.c: 618:app_setup_trace: *NOTICE*: 'spdk_trace' without parameters will also work if this is the only [2024-11-21 05:09:20.453419] app.c: 619:app_setup_trace: *NOTICE*: SPDK application currently running. [2024-11-21 05:09:20.453427] app.c: 620:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid2435810 for offline analysis/debug. [2024-11-21 05:09:20.454021] reactor.c:1005:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Thu Nov 21 05:09:24 2024 CPU: 96 * Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz CPUCache: 36608 KB 2024/11/21-05:09:27 ... thread 0: (1000000,1000000) ops and (326537.9,326537.9) ops/second in (3.062432,3.062432) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 6/4 440.97 MB 18.9 0.0 0.0 0.0 0.9 0.9 0.0 1.0 0.0 342.5 2.58 2.33 12 0.215 0 0 0.0 0.0 L1 3/0 249.26 MB 24.9 0.2 0.2 0.0 0.2 0.2 0.2 1.0 244.2 243.9 1.03 1.00 1 1.032 255K 223 0.0 0.0 L2 3/2 191.37 MB 0.0 0.2 0.1 0.1 0.2 0.1 0.1 1.5 245.2 245.1 0.79 0.75 2 0.394 196K 83 0.0 0.0 L3 12/0 993.17 MB 1.0 0.0 0.0 0.0 0.0 0.0 0.1 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 116/0 9.60 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1040/0 85.57 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1180/6 97.00 GB 0.0 0.4 0.4 0.1 1.3 1.2 0.4 1.5 101.3 301.9 4.40 4.08 15 0.293 452K 306 0.0 0.0 Int 0/0 0.00 KB 0.0 0.4 0.4 0.1 1.3 1.2 0.2 1.5 101.3 301.9 4.40 4.08 15 0.293 452K 306 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 0.4 0.4 0.1 0.4 0.4 0.0 0.0 244.6 244.4 1.82 1.75 3 0.607 452K 306 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 342.5 2.58 2.33 12 0.215 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 3.3 total, 3.1 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.30 GB write, 406.04 MB/s write, 0.43 GB read, 136.27 MB/s read, 4.4 seconds Interval compaction: 1.30 GB write, 433.09 MB/s write, 0.43 GB read, 145.35 MB/s read, 4.4 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 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: 159450 Average: 1.9670 StdDev: 12.22 Min: 0 Median: 1.3240 Max: 3500 Percentiles: P50: 1.32 P75: 1.74 P99: 5.26 P99.9: 9.79 P99.99: 17.95 ------------------------------------------------------ [ 0, 1 ] 48996 30.728% 30.728% ###### ( 1, 2 ] 94850 59.486% 90.214% ############ ( 2, 3 ] 8873 5.565% 95.779% # ( 3, 4 ] 3677 2.306% 98.085% ( 4, 6 ] 2319 1.454% 99.539% ( 6, 10 ] 609 0.382% 99.921% ( 10, 15 ] 106 0.066% 99.987% ( 15, 22 ] 12 0.008% 99.995% ( 22, 34 ] 2 0.001% 99.996% ( 34, 51 ] 2 0.001% 99.997% ( 51, 76 ] 3 0.002% 99.999% ( 110, 170 ] 4 0.003% 100.002% ( 170, 250 ] 6 0.004% 100.006% ( 250, 380 ] 7 0.004% 100.010% ( 580, 870 ] 1 0.001% 100.011% ( 870, 1300 ] 2 0.001% 100.012% ( 1300, 1900 ] 3 0.002% 100.014% ( 2900, 4400 ] 1 0.001% 100.014% ** Level 1 read latency histogram (micros): Count: 655 Average: 6.5298 StdDev: 51.05 Min: 1 Median: 1.8553 Max: 1134 Percentiles: P50: 1.86 P75: 2.59 P99: 20.08 P99.9: 1018.35 P99.99: 1134.00 ------------------------------------------------------ [ 0, 1 ] 23 3.511% 3.511% # ( 1, 2 ] 356 54.351% 57.863% ########### ( 2, 3 ] 190 29.008% 86.870% ###### ( 3, 4 ] 36 5.496% 92.366% # ( 4, 6 ] 35 5.344% 97.710% # ( 6, 10 ] 5 0.763% 98.473% ( 10, 15 ] 2 0.305% 98.779% ( 15, 22 ] 2 0.305% 99.084% ( 110, 170 ] 1 0.153% 99.237% ( 170, 250 ] 1 0.153% 99.389% ( 250, 380 ] 3 0.458% 99.847% ( 870, 1300 ] 1 0.153% 100.000% ** Level 2 read latency histogram (micros): Count: 43127 Average: 2.4471 StdDev: 18.41 Min: 1 Median: 1.5585 Max: 2592 Percentiles: P50: 1.56 P75: 1.92 P99: 5.96 P99.9: 12.16 P99.99: 448.73 ------------------------------------------------------ [ 0, 1 ] 4967 11.517% 11.517% ## ( 1, 2 ] 29716 68.903% 80.421% ############## ( 2, 3 ] 4809 11.151% 91.571% ## ( 3, 4 ] 1936 4.489% 96.060% # ( 4, 6 ] 1296 3.005% 99.066% # ( 6, 10 ] 340 0.788% 99.854% ( 10, 15 ] 46 0.107% 99.961% ( 15, 22 ] 6 0.014% 99.974% ( 22, 34 ] 2 0.005% 99.979% ( 51, 76 ] 1 0.002% 99.981% ( 170, 250 ] 1 0.002% 99.984% ( 250, 380 ] 2 0.005% 99.988% ( 380, 580 ] 2 0.005% 99.993% ( 580, 870 ] 1 0.002% 99.995% ( 870, 1300 ] 1 0.002% 99.998% ( 1900, 2900 ] 2 0.005% 100.002% ** Level 3 read latency histogram (micros): Count: 55 Average: 1691.4545 StdDev: 1242.69 Min: 259 Median: 1333.3333 Max: 4664 Percentiles: P50: 1333.33 P75: 2556.25 P99: 4664.00 P99.9: 4664.00 P99.99: 4664.00 ------------------------------------------------------ ( 250, 380 ] 3 5.455% 5.455% # ( 380, 580 ] 6 10.909% 16.364% ## ( 580, 870 ] 13 23.636% 40.000% ##### ( 870, 1300 ] 5 9.091% 49.091% ## ( 1300, 1900 ] 9 16.364% 65.455% ### ( 1900, 2900 ] 8 14.545% 80.000% ### ( 2900, 4400 ] 10 18.182% 98.182% #### ( 4400, 6600 ] 1 1.818% 100.000% ** Level 4 read latency histogram (micros): Count: 20 Average: 1950.1000 StdDev: 1417.77 Min: 510 Median: 1540.0000 Max: 5428 Percentiles: P50: 1540.00 P75: 2566.67 P99: 5428.00 P99.9: 5428.00 P99.99: 5428.00 ------------------------------------------------------ ( 380, 580 ] 1 5.000% 5.000% # ( 580, 870 ] 4 20.000% 25.000% #### ( 870, 1300 ] 3 15.000% 40.000% ### ( 1300, 1900 ] 5 25.000% 65.000% ##### ( 1900, 2900 ] 3 15.000% 80.000% ### ( 2900, 4400 ] 2 10.000% 90.000% ## ( 4400, 6600 ] 2 10.000% 100.000% ## ** DB Stats ** Uptime(secs): 3.3 total, 3.1 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 301.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:0.465 H:M:S, 14.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 321.13 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.465 H:M:S, 15.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/21-05:09:30 ... thread 0: (1000000,2000000) ops and (326385.7,326461.7) ops/second in (3.063860,6.126292) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 11/10 1.41 GB 12.6 0.8 0.0 0.8 2.6 1.8 0.0 1.4 95.2 314.6 8.61 7.97 29 0.297 831K 904 0.0 0.0 L1 0/0 0.00 KB 0.0 0.2 0.2 0.0 0.2 0.2 0.2 1.0 244.2 243.9 1.03 1.00 1 1.032 255K 223 0.0 0.0 L2 2/1 81.97 MB 0.8 0.2 0.1 0.1 0.2 0.1 0.3 1.5 245.2 245.1 0.79 0.75 2 0.394 196K 83 0.0 0.0 L3 17/8 868.94 MB 0.2 0.2 0.2 0.0 0.2 0.2 0.3 1.0 218.1 218.1 0.86 0.79 1 0.857 189K 0 0.0 0.0 L4 173/0 9.70 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.3 1.0 141.4 141.4 1.19 0.81 1 1.188 170K 0 0.0 0.0 L5 1044/0 85.94 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1247/19 97.98 GB 0.0 1.6 0.7 0.9 3.4 2.6 1.4 1.9 129.8 281.3 12.47 11.32 34 0.367 1644K 1210 0.0 0.0 Int 0/0 0.00 KB 0.0 1.6 0.7 0.9 3.4 2.6 1.3 1.9 129.8 281.3 12.47 11.32 34 0.367 1644K 1210 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 1.6 0.7 0.9 1.6 0.7 0.0 0.0 231.7 231.5 6.99 6.41 8 0.873 1644K 1210 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 344.6 5.48 4.91 26 0.211 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 6.3 total, 6.1 interval Flush(GB): cumulative 1.846, interval 1.846 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 3.43 GB write, 554.01 MB/s write, 1.58 GB read, 255.73 MB/s read, 12.5 seconds Interval compaction: 3.43 GB write, 572.47 MB/s write, 1.58 GB read, 264.25 MB/s read, 12.5 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: 407254 Average: 2.1524 StdDev: 11.31 Min: 0 Median: 1.4565 Max: 3500 Percentiles: P50: 1.46 P75: 1.85 P99: 5.62 P99.9: 9.97 P99.99: 16.47 ------------------------------------------------------ [ 0, 1 ] 86202 21.167% 21.167% #### ( 1, 2 ] 257202 63.155% 84.322% ############# ( 2, 3 ] 38635 9.487% 93.809% ## ( 3, 4 ] 13532 3.323% 97.131% # ( 4, 6 ] 9378 2.303% 99.434% ( 6, 10 ] 1911 0.469% 99.903% ( 10, 15 ] 344 0.084% 99.988% ( 15, 22 ] 49 0.012% 100.000% ( 22, 34 ] 8 0.002% 100.002% ( 34, 51 ] 4 0.001% 100.003% ( 51, 76 ] 4 0.001% 100.004% ( 110, 170 ] 10 0.002% 100.006% ( 170, 250 ] 12 0.003% 100.009% ( 250, 380 ] 14 0.003% 100.013% ( 380, 580 ] 2 0.000% 100.013% ( 580, 870 ] 6 0.001% 100.014% ( 870, 1300 ] 4 0.001% 100.015% ( 1300, 1900 ] 8 0.002% 100.017% ( 2900, 4400 ] 2 0.000% 100.018% ** Level 1 read latency histogram (micros): Count: 655 Average: 6.5298 StdDev: 51.05 Min: 1 Median: 1.8553 Max: 1134 Percentiles: P50: 1.86 P75: 2.59 P99: 20.08 P99.9: 1018.35 P99.99: 1134.00 ------------------------------------------------------ [ 0, 1 ] 23 3.511% 3.511% # ( 1, 2 ] 356 54.351% 57.863% ########### ( 2, 3 ] 190 29.008% 86.870% ###### ( 3, 4 ] 36 5.496% 92.366% # ( 4, 6 ] 35 5.344% 97.710% # ( 6, 10 ] 5 0.763% 98.473% ( 10, 15 ] 2 0.305% 98.779% ( 15, 22 ] 2 0.305% 99.084% ( 110, 170 ] 1 0.153% 99.237% ( 170, 250 ] 1 0.153% 99.389% ( 250, 380 ] 3 0.458% 99.847% ( 870, 1300 ] 1 0.153% 100.000% ** Level 2 read latency histogram (micros): Count: 48874 Average: 2.4484 StdDev: 17.30 Min: 1 Median: 1.5713 Max: 2592 Percentiles: P50: 1.57 P75: 1.94 P99: 6.13 P99.9: 12.84 P99.99: 391.26 ------------------------------------------------------ [ 0, 1 ] 5364 10.975% 10.975% ## ( 1, 2 ] 33386 68.310% 79.286% ############## ( 2, 3 ] 5890 12.051% 91.337% ## ( 3, 4 ] 2264 4.632% 95.969% # ( 4, 6 ] 1468 3.004% 98.973% # ( 6, 10 ] 419 0.857% 99.830% ( 10, 15 ] 60 0.123% 99.953% ( 15, 22 ] 11 0.023% 99.975% ( 22, 34 ] 3 0.006% 99.982% ( 51, 76 ] 1 0.002% 99.984% ( 170, 250 ] 1 0.002% 99.986% ( 250, 380 ] 2 0.004% 99.990% ( 380, 580 ] 2 0.004% 99.994% ( 580, 870 ] 1 0.002% 99.996% ( 870, 1300 ] 1 0.002% 99.998% ( 1900, 2900 ] 2 0.004% 100.002% ** Level 3 read latency histogram (micros): Count: 168998 Average: 3.4846 StdDev: 41.19 Min: 1 Median: 1.6529 Max: 4664 Percentiles: P50: 1.65 P75: 2.17 P99: 8.75 P99.9: 168.76 P99.99: 937.58 ------------------------------------------------------ [ 0, 1 ] 14734 8.718% 8.718% ## ( 1, 2 ] 106856 63.229% 71.948% ############# ( 2, 3 ] 29808 17.638% 89.586% #### ( 3, 4 ] 7598 4.496% 94.082% # ( 4, 6 ] 6543 3.872% 97.953% # ( 6, 10 ] 2575 1.524% 99.477% ( 10, 15 ] 318 0.188% 99.665% ( 15, 22 ] 76 0.045% 99.710% ( 22, 34 ] 21 0.012% 99.722% ( 34, 51 ] 6 0.004% 99.726% ( 51, 76 ] 36 0.021% 99.747% ( 76, 110 ] 117 0.069% 99.817% ( 110, 170 ] 145 0.086% 99.902% ( 170, 250 ] 50 0.030% 99.932% ( 250, 380 ] 34 0.020% 99.952% ( 380, 580 ] 37 0.022% 99.974% ( 580, 870 ] 27 0.016% 99.990% ( 870, 1300 ] 7 0.004% 99.994% ( 1300, 1900 ] 11 0.007% 100.001% ( 1900, 2900 ] 10 0.006% 100.007% ( 2900, 4400 ] 10 0.006% 100.012% ( 4400, 6600 ] 1 0.001% 100.013% ** Level 4 read latency histogram (micros): Count: 305 Average: 132.3311 StdDev: 603.33 Min: 0 Median: 1.3462 Max: 5428 Percentiles: P50: 1.35 P75: 4.75 P99: 3612.50 P99.9: 5428.00 P99.99: 5428.00 ------------------------------------------------------ [ 0, 1 ] 121 39.672% 39.672% ######## ( 1, 2 ] 91 29.836% 69.508% ###### ( 2, 3 ] 9 2.951% 72.459% # ( 3, 4 ] 4 1.311% 73.770% ( 4, 6 ] 10 3.279% 77.049% # ( 6, 10 ] 45 14.754% 91.803% ### ( 10, 15 ] 1 0.328% 92.131% ( 110, 170 ] 3 0.984% 93.115% ( 170, 250 ] 1 0.328% 93.443% ( 380, 580 ] 1 0.328% 93.770% ( 580, 870 ] 4 1.311% 95.082% ( 870, 1300 ] 3 0.984% 96.066% ( 1300, 1900 ] 5 1.639% 97.705% ( 1900, 2900 ] 3 0.984% 98.689% ( 2900, 4400 ] 2 0.656% 99.344% ( 4400, 6600 ] 2 0.656% 100.000% ** Level 5 read latency histogram (micros): Count: 20 Average: 834.6500 StdDev: 1191.74 Min: 61 Median: 250.0000 Max: 4119 Percentiles: P50: 250.00 P75: 1085.00 P99: 4119.00 P99.9: 4119.00 P99.99: 4119.00 ------------------------------------------------------ ( 51, 76 ] 2 10.000% 10.000% ## ( 76, 110 ] 3 15.000% 25.000% ### ( 110, 170 ] 4 20.000% 45.000% #### ( 170, 250 ] 1 5.000% 50.000% # ( 250, 380 ] 3 15.000% 65.000% ### ( 380, 580 ] 1 5.000% 70.000% # ( 870, 1300 ] 2 10.000% 80.000% ## ( 1300, 1900 ] 1 5.000% 85.000% # ( 2900, 4400 ] 3 15.000% 100.000% ### ** DB Stats ** Uptime(secs): 6.3 total, 3.1 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 310.86 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.890 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, 321.23 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.425 H:M:S, 13.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/11/21-05:09:33 ... thread 0: (1000000,3000000) ops and (332669.1,328505.0) ops/second in (3.005990,9.132282) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 15/10 2.34 GB 107.0 1.6 0.0 1.6 4.4 2.8 0.0 1.6 113.5 309.7 14.44 13.44 45 0.321 1663K 1770 0.0 0.0 L1 0/0 0.00 KB 0.0 0.2 0.2 0.0 0.2 0.2 0.2 1.0 244.2 243.9 1.03 1.00 1 1.032 255K 223 0.0 0.0 L2 1/0 77.60 MB 0.8 0.2 0.1 0.1 0.2 0.1 0.3 1.5 245.2 245.1 0.79 0.75 2 0.394 196K 83 0.0 0.0 L3 15/0 870.31 MB 0.9 0.8 0.2 0.7 0.8 0.2 0.3 4.5 223.1 222.3 3.90 3.64 2 1.949 883K 3033 0.0 0.0 L4 173/0 9.70 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.3 1.0 141.4 141.4 1.19 0.81 1 1.188 170K 0 0.0 0.0 L5 1044/0 85.94 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1248/10 98.90 GB 0.0 3.0 0.7 2.3 5.8 3.5 1.4 2.1 146.2 278.8 21.34 19.64 51 0.418 3169K 5109 0.0 0.0 Int 0/0 0.00 KB 0.0 3.0 0.7 2.3 5.8 3.5 1.3 2.1 146.2 278.8 21.34 19.64 51 0.418 3169K 5109 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.0 0.7 2.3 3.0 0.7 0.0 0.0 236.7 236.3 13.19 12.36 12 1.099 3169K 5109 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 347.6 8.16 7.28 39 0.209 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 9.3 total, 9.1 interval Flush(GB): cumulative 2.768, interval 2.768 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 5.81 GB write, 637.24 MB/s write, 3.05 GB read, 334.21 MB/s read, 21.3 seconds Interval compaction: 5.81 GB write, 651.48 MB/s write, 3.05 GB read, 341.68 MB/s read, 21.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: 13, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 13, interval: 13 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 796695 Average: 2.2051 StdDev: 9.97 Min: 0 Median: 1.5086 Max: 3500 Percentiles: P50: 1.51 P75: 1.89 P99: 5.61 P99.9: 9.85 P99.99: 14.29 ------------------------------------------------------ [ 0, 1 ] 133574 16.766% 16.766% ### ( 1, 2 ] 520568 65.341% 82.107% ############# ( 2, 3 ] 90640 11.377% 93.484% ## ( 3, 4 ] 28331 3.556% 97.040% # ( 4, 6 ] 19423 2.438% 99.478% ( 6, 10 ] 3492 0.438% 99.916% ( 10, 15 ] 685 0.086% 100.002% ( 15, 22 ] 72 0.009% 100.011% ( 22, 34 ] 14 0.002% 100.013% ( 34, 51 ] 5 0.001% 100.014% ( 51, 76 ] 9 0.001% 100.015% ( 110, 170 ] 29 0.004% 100.018% ( 170, 250 ] 22 0.003% 100.021% ( 250, 380 ] 21 0.003% 100.024% ( 380, 580 ] 4 0.001% 100.024% ( 580, 870 ] 10 0.001% 100.026% ( 870, 1300 ] 8 0.001% 100.027% ( 1300, 1900 ] 9 0.001% 100.028% ( 1900, 2900 ] 1 0.000% 100.028% ( 2900, 4400 ] 3 0.000% 100.028% ** Level 1 read latency histogram (micros): Count: 655 Average: 6.5298 StdDev: 51.05 Min: 1 Median: 1.8553 Max: 1134 Percentiles: P50: 1.86 P75: 2.59 P99: 20.08 P99.9: 1018.35 P99.99: 1134.00 ------------------------------------------------------ [ 0, 1 ] 23 3.511% 3.511% # ( 1, 2 ] 356 54.351% 57.863% ########### ( 2, 3 ] 190 29.008% 86.870% ###### ( 3, 4 ] 36 5.496% 92.366% # ( 4, 6 ] 35 5.344% 97.710% # ( 6, 10 ] 5 0.763% 98.473% ( 10, 15 ] 2 0.305% 98.779% ( 15, 22 ] 2 0.305% 99.084% ( 110, 170 ] 1 0.153% 99.237% ( 170, 250 ] 1 0.153% 99.389% ( 250, 380 ] 3 0.458% 99.847% ( 870, 1300 ] 1 0.153% 100.000% ** Level 2 read latency histogram (micros): Count: 77332 Average: 2.6881 StdDev: 19.95 Min: 1 Median: 1.5996 Max: 3053 Percentiles: P50: 1.60 P75: 1.97 P99: 7.50 P99.9: 21.48 P99.99: 605.79 ------------------------------------------------------ [ 0, 1 ] 7552 9.766% 9.766% ## ( 1, 2 ] 51895 67.107% 76.872% ############# ( 2, 3 ] 10753 13.905% 90.777% ### ( 3, 4 ] 3543 4.582% 95.359% # ( 4, 6 ] 2467 3.190% 98.549% # ( 6, 10 ] 929 1.201% 99.750% ( 10, 15 ] 99 0.128% 99.878% ( 15, 22 ] 18 0.023% 99.902% ( 22, 34 ] 3 0.004% 99.906% ( 51, 76 ] 1 0.001% 99.907% ( 110, 170 ] 28 0.036% 99.943% ( 170, 250 ] 16 0.021% 99.964% ( 250, 380 ] 11 0.014% 99.978% ( 380, 580 ] 9 0.012% 99.990% ( 580, 870 ] 3 0.004% 99.994% ( 870, 1300 ] 3 0.004% 99.997% ( 1900, 2900 ] 2 0.003% 100.000% ( 2900, 4400 ] 1 0.001% 100.001% ** Level 3 read latency histogram (micros): Count: 186693 Average: 3.5311 StdDev: 40.43 Min: 1 Median: 1.6591 Max: 4664 Percentiles: P50: 1.66 P75: 2.19 P99: 8.80 P99.9: 192.11 P99.99: 1117.47 ------------------------------------------------------ [ 0, 1 ] 15514 8.310% 8.310% ## ( 1, 2 ] 118098 63.258% 71.568% ############# ( 2, 3 ] 33308 17.841% 89.409% #### ( 3, 4 ] 8514 4.560% 93.969% # ( 4, 6 ] 7376 3.951% 97.920% # ( 6, 10 ] 2885 1.545% 99.465% ( 10, 15 ] 347 0.186% 99.651% ( 15, 22 ] 77 0.041% 99.693% ( 22, 34 ] 22 0.012% 99.704% ( 34, 51 ] 6 0.003% 99.708% ( 51, 76 ] 36 0.019% 99.727% ( 76, 110 ] 137 0.073% 99.800% ( 110, 170 ] 170 0.091% 99.891% ( 170, 250 ] 59 0.032% 99.923% ( 250, 380 ] 41 0.022% 99.945% ( 380, 580 ] 48 0.026% 99.971% ( 580, 870 ] 30 0.016% 99.987% ( 870, 1300 ] 11 0.006% 99.993% ( 1300, 1900 ] 14 0.007% 100.000% ( 1900, 2900 ] 10 0.005% 100.005% ( 2900, 4400 ] 10 0.005% 100.011% ( 4400, 6600 ] 1 0.001% 100.011% ** Level 4 read latency histogram (micros): Count: 305 Average: 132.3311 StdDev: 603.33 Min: 0 Median: 1.3462 Max: 5428 Percentiles: P50: 1.35 P75: 4.75 P99: 3612.50 P99.9: 5428.00 P99.99: 5428.00 ------------------------------------------------------ [ 0, 1 ] 121 39.672% 39.672% ######## ( 1, 2 ] 91 29.836% 69.508% ###### ( 2, 3 ] 9 2.951% 72.459% # ( 3, 4 ] 4 1.311% 73.770% ( 4, 6 ] 10 3.279% 77.049% # ( 6, 10 ] 45 14.754% 91.803% ### ( 10, 15 ] 1 0.328% 92.131% ( 110, 170 ] 3 0.984% 93.115% ( 170, 250 ] 1 0.328% 93.443% ( 380, 580 ] 1 0.328% 93.770% ( 580, 870 ] 4 1.311% 95.082% ( 870, 1300 ] 3 0.984% 96.066% ( 1300, 1900 ] 5 1.639% 97.705% ( 1900, 2900 ] 3 0.984% 98.689% ( 2900, 4400 ] 2 0.656% 99.344% ( 4400, 6600 ] 2 0.656% 100.000% ** Level 5 read latency histogram (micros): Count: 20 Average: 834.6500 StdDev: 1191.74 Min: 61 Median: 250.0000 Max: 4119 Percentiles: P50: 250.00 P75: 1085.00 P99: 4119.00 P99.9: 4119.00 P99.99: 4119.00 ------------------------------------------------------ ( 51, 76 ] 2 10.000% 10.000% ## ( 76, 110 ] 3 15.000% 25.000% ### ( 110, 170 ] 4 20.000% 45.000% #### ( 170, 250 ] 1 5.000% 50.000% # ( 250, 380 ] 3 15.000% 65.000% ### ( 380, 580 ] 1 5.000% 70.000% # ( 870, 1300 ] 2 10.000% 80.000% ## ( 1300, 1900 ] 1 5.000% 85.000% # ( 2900, 4400 ] 3 15.000% 100.000% ### ** DB Stats ** Uptime(secs): 9.3 total, 3.0 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 316.19 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.271 H:M:S, 13.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 327.41 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.381 H:M:S, 12.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/21-05:09:36 ... thread 0: (1000000,4000000) ops and (340228.1,331359.3) ops/second in (2.939205,12.071487) 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/4 2.27 GB 207.7 2.4 0.0 2.4 6.1 3.7 0.0 1.6 120.9 309.8 20.33 19.00 62 0.328 2494K 2617 0.0 0.0 L1 10/0 1.04 GB 106.5 1.3 1.3 0.0 1.3 1.3 0.2 1.0 231.1 230.2 5.72 5.57 2 2.861 1342K 4744 0.0 0.0 L2 1/0 77.60 MB 0.8 0.2 0.1 0.1 0.2 0.1 0.3 1.5 245.2 245.1 0.79 0.75 2 0.394 196K 83 0.0 0.0 L3 15/0 870.31 MB 0.9 0.8 0.2 0.7 0.8 0.2 0.3 4.5 223.1 222.3 3.90 3.64 2 1.949 883K 3033 0.0 0.0 L4 173/0 9.70 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.3 1.0 141.4 141.4 1.19 0.81 1 1.188 170K 0 0.0 0.0 L5 1044/0 85.94 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1257/4 99.88 GB 0.0 4.9 1.8 3.1 8.6 5.5 1.4 2.3 156.9 277.0 31.92 29.77 69 0.463 5087K 10K 0.0 0.0 Int 0/0 0.00 KB 0.0 4.9 1.8 3.1 8.6 5.5 1.3 2.3 156.9 277.0 31.92 29.77 69 0.463 5087K 10K 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.9 1.8 3.1 4.9 1.8 0.0 0.0 239.1 238.6 20.95 19.94 16 1.309 5087K 10K 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 350.3 10.97 9.82 53 0.207 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: 8.63 GB write, 720.19 MB/s write, 4.89 GB read, 408.06 MB/s read, 31.9 seconds Interval compaction: 8.63 GB write, 732.37 MB/s write, 4.89 GB read, 414.96 MB/s read, 31.9 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: 16, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 16, interval: 16 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1046606 Average: 2.1517 StdDev: 10.35 Min: 0 Median: 1.4706 Max: 3500 Percentiles: P50: 1.47 P75: 1.86 P99: 5.53 P99.9: 9.96 P99.99: 14.80 ------------------------------------------------------ [ 0, 1 ] 205121 19.599% 19.599% #### ( 1, 2 ] 676165 64.605% 84.204% ############# ( 2, 3 ] 105012 10.034% 94.238% ## ( 3, 4 ] 33319 3.184% 97.421% # ( 4, 6 ] 21637 2.067% 99.489% ( 6, 10 ] 4354 0.416% 99.905% ( 10, 15 ] 930 0.089% 99.994% ( 15, 22 ] 103 0.010% 100.003% ( 22, 34 ] 15 0.001% 100.005% ( 34, 51 ] 6 0.001% 100.005% ( 51, 76 ] 12 0.001% 100.006% ( 110, 170 ] 56 0.005% 100.012% ( 170, 250 ] 31 0.003% 100.015% ( 250, 380 ] 29 0.003% 100.018% ( 380, 580 ] 10 0.001% 100.019% ( 580, 870 ] 17 0.002% 100.020% ( 870, 1300 ] 10 0.001% 100.021% ( 1300, 1900 ] 9 0.001% 100.022% ( 1900, 2900 ] 4 0.000% 100.022% ( 2900, 4400 ] 4 0.000% 100.023% ** Level 1 read latency histogram (micros): Count: 705 Average: 24.1319 StdDev: 138.92 Min: 1 Median: 1.8496 Max: 1645 Percentiles: P50: 1.85 P75: 2.63 P99: 928.36 P99.9: 1477.00 P99.99: 1645.00 ------------------------------------------------------ [ 0, 1 ] 39 5.532% 5.532% # ( 1, 2 ] 369 52.340% 57.872% ########## ( 2, 3 ] 191 27.092% 84.965% ##### ( 3, 4 ] 37 5.248% 90.213% # ( 4, 6 ] 35 4.965% 95.177% # ( 6, 10 ] 5 0.709% 95.887% ( 10, 15 ] 3 0.426% 96.312% ( 15, 22 ] 2 0.284% 96.596% ( 110, 170 ] 1 0.142% 96.738% ( 170, 250 ] 3 0.426% 97.163% ( 250, 380 ] 9 1.277% 98.440% ( 380, 580 ] 2 0.284% 98.723% ( 580, 870 ] 1 0.142% 98.865% ( 870, 1300 ] 7 0.993% 99.858% ( 1300, 1900 ] 1 0.142% 100.000% ** Level 2 read latency histogram (micros): Count: 77332 Average: 2.6881 StdDev: 19.95 Min: 1 Median: 1.5996 Max: 3053 Percentiles: P50: 1.60 P75: 1.97 P99: 7.50 P99.9: 21.48 P99.99: 605.79 ------------------------------------------------------ [ 0, 1 ] 7552 9.766% 9.766% ## ( 1, 2 ] 51895 67.107% 76.872% ############# ( 2, 3 ] 10753 13.905% 90.777% ### ( 3, 4 ] 3543 4.582% 95.359% # ( 4, 6 ] 2467 3.190% 98.549% # ( 6, 10 ] 929 1.201% 99.750% ( 10, 15 ] 99 0.128% 99.878% ( 15, 22 ] 18 0.023% 99.902% ( 22, 34 ] 3 0.004% 99.906% ( 51, 76 ] 1 0.001% 99.907% ( 110, 170 ] 28 0.036% 99.943% ( 170, 250 ] 16 0.021% 99.964% ( 250, 380 ] 11 0.014% 99.978% ( 380, 580 ] 9 0.012% 99.990% ( 580, 870 ] 3 0.004% 99.994% ( 870, 1300 ] 3 0.004% 99.997% ( 1900, 2900 ] 2 0.003% 100.000% ( 2900, 4400 ] 1 0.001% 100.001% ** Level 3 read latency histogram (micros): Count: 186693 Average: 3.5311 StdDev: 40.43 Min: 1 Median: 1.6591 Max: 4664 Percentiles: P50: 1.66 P75: 2.19 P99: 8.80 P99.9: 192.11 P99.99: 1117.47 ------------------------------------------------------ [ 0, 1 ] 15514 8.310% 8.310% ## ( 1, 2 ] 118098 63.258% 71.568% ############# ( 2, 3 ] 33308 17.841% 89.409% #### ( 3, 4 ] 8514 4.560% 93.969% # ( 4, 6 ] 7376 3.951% 97.920% # ( 6, 10 ] 2885 1.545% 99.465% ( 10, 15 ] 347 0.186% 99.651% ( 15, 22 ] 77 0.041% 99.693% ( 22, 34 ] 22 0.012% 99.704% ( 34, 51 ] 6 0.003% 99.708% ( 51, 76 ] 36 0.019% 99.727% ( 76, 110 ] 137 0.073% 99.800% ( 110, 170 ] 170 0.091% 99.891% ( 170, 250 ] 59 0.032% 99.923% ( 250, 380 ] 41 0.022% 99.945% ( 380, 580 ] 48 0.026% 99.971% ( 580, 870 ] 30 0.016% 99.987% ( 870, 1300 ] 11 0.006% 99.993% ( 1300, 1900 ] 14 0.007% 100.000% ( 1900, 2900 ] 10 0.005% 100.005% ( 2900, 4400 ] 10 0.005% 100.011% ( 4400, 6600 ] 1 0.001% 100.011% ** Level 4 read latency histogram (micros): Count: 305 Average: 132.3311 StdDev: 603.33 Min: 0 Median: 1.3462 Max: 5428 Percentiles: P50: 1.35 P75: 4.75 P99: 3612.50 P99.9: 5428.00 P99.99: 5428.00 ------------------------------------------------------ [ 0, 1 ] 121 39.672% 39.672% ######## ( 1, 2 ] 91 29.836% 69.508% ###### ( 2, 3 ] 9 2.951% 72.459% # ( 3, 4 ] 4 1.311% 73.770% ( 4, 6 ] 10 3.279% 77.049% # ( 6, 10 ] 45 14.754% 91.803% ### ( 10, 15 ] 1 0.328% 92.131% ( 110, 170 ] 3 0.984% 93.115% ( 170, 250 ] 1 0.328% 93.443% ( 380, 580 ] 1 0.328% 93.770% ( 580, 870 ] 4 1.311% 95.082% ( 870, 1300 ] 3 0.984% 96.066% ( 1300, 1900 ] 5 1.639% 97.705% ( 1900, 2900 ] 3 0.984% 98.689% ( 2900, 4400 ] 2 0.656% 99.344% ( 4400, 6600 ] 2 0.656% 100.000% ** Level 5 read latency histogram (micros): Count: 20 Average: 834.6500 StdDev: 1191.74 Min: 61 Median: 250.0000 Max: 4119 Percentiles: P50: 250.00 P75: 1085.00 P99: 4119.00 P99.9: 4119.00 P99.99: 4119.00 ------------------------------------------------------ ( 51, 76 ] 2 10.000% 10.000% ## ( 76, 110 ] 3 15.000% 25.000% ### ( 110, 170 ] 4 20.000% 45.000% #### ( 170, 250 ] 1 5.000% 50.000% # ( 250, 380 ] 3 15.000% 65.000% ### ( 380, 580 ] 1 5.000% 70.000% # ( 870, 1300 ] 2 10.000% 80.000% ## ( 1300, 1900 ] 1 5.000% 85.000% # ( 2900, 4400 ] 3 15.000% 100.000% ### ** DB Stats ** Uptime(secs): 12.3 total, 2.9 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 320.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:1.642 H:M:S, 13.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 334.85 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: 1 num-running-flushes: 1 2024/11/21-05:09:40 ... thread 0: (1000000,5000000) ops and (286419.8,321277.6) ops/second in (3.491379,15.562866) 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/17 3.20 GB 56.6 3.2 0.0 3.2 7.9 4.7 0.0 1.7 125.4 308.6 26.12 24.46 79 0.331 3326K 3464 0.0 0.0 L1 10/10 1.04 GB 0.0 1.3 1.3 0.0 1.3 1.3 0.2 1.0 231.1 230.2 5.72 5.57 2 2.861 1342K 4744 0.0 0.0 L2 1/0 77.60 MB 0.8 0.2 0.1 0.1 0.2 0.1 0.3 1.5 245.2 245.1 0.79 0.75 2 0.394 196K 83 0.0 0.0 L3 15/0 870.31 MB 0.9 0.8 0.2 0.7 0.8 0.2 0.3 4.5 223.1 222.3 3.90 3.64 2 1.949 883K 3033 0.0 0.0 L4 173/0 9.70 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.3 1.0 141.4 141.4 1.19 0.81 1 1.188 170K 0 0.0 0.0 L5 1044/0 85.94 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1262/27 100.80 GB 0.0 5.7 1.8 3.9 10.4 6.4 1.4 2.2 154.6 281.2 37.71 35.23 86 0.439 5918K 11K 0.0 0.0 Int 0/0 0.00 KB 0.0 5.7 1.8 3.9 10.4 6.4 1.3 2.2 154.6 281.2 37.71 35.23 86 0.439 5918K 11K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 5.7 1.8 3.9 5.7 1.8 0.0 0.0 242.2 241.7 24.07 23.01 19 1.267 5918K 11K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 4.7 4.7 0.0 0.0 0.0 350.9 13.64 12.22 67 0.204 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 15.8 total, 15.6 interval Flush(GB): cumulative 4.676, interval 4.676 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 10.36 GB write, 672.54 MB/s write, 5.69 GB read, 369.65 MB/s read, 37.7 seconds Interval compaction: 10.36 GB write, 681.36 MB/s write, 5.69 GB read, 374.50 MB/s read, 37.7 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: 18, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 3, total-stops: 18, interval: 21 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1349945 Average: 2.1647 StdDev: 10.47 Min: 0 Median: 1.4724 Max: 3500 Percentiles: P50: 1.47 P75: 1.86 P99: 5.53 P99.9: 10.23 P99.99: 15.81 ------------------------------------------------------ [ 0, 1 ] 260680 19.310% 19.310% #### ( 1, 2 ] 876907 64.959% 84.269% ############# ( 2, 3 ] 135638 10.048% 94.317% ## ( 3, 4 ] 42537 3.151% 97.468% # ( 4, 6 ] 27081 2.006% 99.474% ( 6, 10 ] 5695 0.422% 99.896% ( 10, 15 ] 1258 0.093% 99.989% ( 15, 22 ] 138 0.010% 99.999% ( 22, 34 ] 16 0.001% 100.000% ( 34, 51 ] 7 0.001% 100.001% ( 51, 76 ] 16 0.001% 100.002% ( 76, 110 ] 26 0.002% 100.004% ( 110, 170 ] 107 0.008% 100.012% ( 170, 250 ] 51 0.004% 100.016% ( 250, 380 ] 42 0.003% 100.019% ( 380, 580 ] 20 0.001% 100.020% ( 580, 870 ] 24 0.002% 100.022% ( 870, 1300 ] 16 0.001% 100.023% ( 1300, 1900 ] 10 0.001% 100.024% ( 1900, 2900 ] 5 0.000% 100.024% ( 2900, 4400 ] 5 0.000% 100.025% ** Level 1 read latency histogram (micros): Count: 54779 Average: 2.8029 StdDev: 19.85 Min: 1 Median: 1.4793 Max: 1645 Percentiles: P50: 1.48 P75: 1.87 P99: 8.27 P99.9: 165.24 P99.99: 1086.06 ------------------------------------------------------ [ 0, 1 ] 10400 18.985% 18.985% #### ( 1, 2 ] 35445 64.705% 83.691% ############# ( 2, 3 ] 5472 9.989% 93.680% ## ( 3, 4 ] 1429 2.609% 96.289% # ( 4, 6 ] 1044 1.906% 98.195% ( 6, 10 ] 778 1.420% 99.615% ( 10, 15 ] 49 0.089% 99.704% ( 15, 22 ] 8 0.015% 99.719% ( 22, 34 ] 1 0.002% 99.721% ( 51, 76 ] 2 0.004% 99.724% ( 76, 110 ] 64 0.117% 99.841% ( 110, 170 ] 35 0.064% 99.905% ( 170, 250 ] 15 0.027% 99.932% ( 250, 380 ] 14 0.026% 99.958% ( 380, 580 ] 9 0.016% 99.974% ( 580, 870 ] 4 0.007% 99.982% ( 870, 1300 ] 9 0.016% 99.998% ( 1300, 1900 ] 1 0.002% 100.000% ** Level 2 read latency histogram (micros): Count: 77332 Average: 2.6881 StdDev: 19.95 Min: 1 Median: 1.5996 Max: 3053 Percentiles: P50: 1.60 P75: 1.97 P99: 7.50 P99.9: 21.48 P99.99: 605.79 ------------------------------------------------------ [ 0, 1 ] 7552 9.766% 9.766% ## ( 1, 2 ] 51895 67.107% 76.872% ############# ( 2, 3 ] 10753 13.905% 90.777% ### ( 3, 4 ] 3543 4.582% 95.359% # ( 4, 6 ] 2467 3.190% 98.549% # ( 6, 10 ] 929 1.201% 99.750% ( 10, 15 ] 99 0.128% 99.878% ( 15, 22 ] 18 0.023% 99.902% ( 22, 34 ] 3 0.004% 99.906% ( 51, 76 ] 1 0.001% 99.907% ( 110, 170 ] 28 0.036% 99.943% ( 170, 250 ] 16 0.021% 99.964% ( 250, 380 ] 11 0.014% 99.978% ( 380, 580 ] 9 0.012% 99.990% ( 580, 870 ] 3 0.004% 99.994% ( 870, 1300 ] 3 0.004% 99.997% ( 1900, 2900 ] 2 0.003% 100.000% ( 2900, 4400 ] 1 0.001% 100.001% ** Level 3 read latency histogram (micros): Count: 186693 Average: 3.5311 StdDev: 40.43 Min: 1 Median: 1.6591 Max: 4664 Percentiles: P50: 1.66 P75: 2.19 P99: 8.80 P99.9: 192.11 P99.99: 1117.47 ------------------------------------------------------ [ 0, 1 ] 15514 8.310% 8.310% ## ( 1, 2 ] 118098 63.258% 71.568% ############# ( 2, 3 ] 33308 17.841% 89.409% #### ( 3, 4 ] 8514 4.560% 93.969% # ( 4, 6 ] 7376 3.951% 97.920% # ( 6, 10 ] 2885 1.545% 99.465% ( 10, 15 ] 347 0.186% 99.651% ( 15, 22 ] 77 0.041% 99.693% ( 22, 34 ] 22 0.012% 99.704% ( 34, 51 ] 6 0.003% 99.708% ( 51, 76 ] 36 0.019% 99.727% ( 76, 110 ] 137 0.073% 99.800% ( 110, 170 ] 170 0.091% 99.891% ( 170, 250 ] 59 0.032% 99.923% ( 250, 380 ] 41 0.022% 99.945% ( 380, 580 ] 48 0.026% 99.971% ( 580, 870 ] 30 0.016% 99.987% ( 870, 1300 ] 11 0.006% 99.993% ( 1300, 1900 ] 14 0.007% 100.000% ( 1900, 2900 ] 10 0.005% 100.005% ( 2900, 4400 ] 10 0.005% 100.011% ( 4400, 6600 ] 1 0.001% 100.011% ** Level 4 read latency histogram (micros): Count: 305 Average: 132.3311 StdDev: 603.33 Min: 0 Median: 1.3462 Max: 5428 Percentiles: P50: 1.35 P75: 4.75 P99: 3612.50 P99.9: 5428.00 P99.99: 5428.00 ------------------------------------------------------ [ 0, 1 ] 121 39.672% 39.672% ######## ( 1, 2 ] 91 29.836% 69.508% ###### ( 2, 3 ] 9 2.951% 72.459% # ( 3, 4 ] 4 1.311% 73.770% ( 4, 6 ] 10 3.279% 77.049% # ( 6, 10 ] 45 14.754% 91.803% ### ( 10, 15 ] 1 0.328% 92.131% ( 110, 170 ] 3 0.984% 93.115% ( 170, 250 ] 1 0.328% 93.443% ( 380, 580 ] 1 0.328% 93.770% ( 580, 870 ] 4 1.311% 95.082% ( 870, 1300 ] 3 0.984% 96.066% ( 1300, 1900 ] 5 1.639% 97.705% ( 1900, 2900 ] 3 0.984% 98.689% ( 2900, 4400 ] 2 0.656% 99.344% ( 4400, 6600 ] 2 0.656% 100.000% ** Level 5 read latency histogram (micros): Count: 20 Average: 834.6500 StdDev: 1191.74 Min: 61 Median: 250.0000 Max: 4119 Percentiles: P50: 250.00 P75: 1085.00 P99: 4119.00 P99.9: 4119.00 P99.99: 4119.00 ------------------------------------------------------ ( 51, 76 ] 2 10.000% 10.000% ## ( 76, 110 ] 3 15.000% 25.000% ### ( 110, 170 ] 4 20.000% 45.000% #### ( 170, 250 ] 1 5.000% 50.000% # ( 250, 380 ] 3 15.000% 65.000% ### ( 380, 580 ] 1 5.000% 70.000% # ( 870, 1300 ] 2 10.000% 80.000% ## ( 1300, 1900 ] 1 5.000% 85.000% # ( 2900, 4400 ] 3 15.000% 100.000% ### ** DB Stats ** Uptime(secs): 15.8 total, 3.5 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 312.07 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.535 H:M:S, 16.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 281.89 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.893 H:M:S, 25.6 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/21-05:09:52 ... thread 0: (1000000,6000000) ops and (84077.8,218526.6) ops/second in (11.893741,27.456607) 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/13 4.24 GB 188.6 5.2 0.0 5.2 10.9 5.7 0.0 1.9 144.9 303.3 36.95 34.81 102 0.362 5436K 7102 0.0 0.0 L1 10/10 1.04 GB 0.0 1.3 1.3 0.0 1.3 1.3 0.2 1.0 231.1 230.2 5.72 5.57 2 2.861 1342K 4744 0.0 0.0 L2 1/0 77.60 MB 0.8 0.2 0.1 0.1 0.2 0.1 0.3 1.5 245.2 245.1 0.79 0.75 2 0.394 196K 83 0.0 0.0 L3 15/0 870.31 MB 0.9 0.8 0.2 0.7 0.8 0.2 0.3 4.5 223.1 222.3 3.90 3.64 2 1.949 883K 3033 0.0 0.0 L4 173/0 9.70 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.3 1.0 141.4 141.4 1.19 0.81 1 1.188 170K 0 0.0 0.0 L5 1044/0 85.94 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1261/23 101.84 GB 0.0 7.7 1.8 6.0 13.4 7.5 1.4 2.3 162.9 283.3 48.54 45.57 109 0.445 8028K 14K 0.0 0.0 Int 0/0 0.00 KB 0.0 7.7 1.8 6.0 13.4 7.5 1.3 2.3 162.9 283.3 48.54 45.57 109 0.445 8028K 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.7 1.8 6.0 7.7 1.8 0.0 0.0 248.7 248.2 31.80 30.61 25 1.272 8028K 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 349.9 16.75 14.96 84 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): 27.7 total, 27.5 interval Flush(GB): cumulative 5.721, interval 5.721 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: 13.43 GB write, 497.08 MB/s write, 7.72 GB read, 285.84 MB/s read, 48.5 seconds Interval compaction: 13.43 GB write, 500.78 MB/s write, 7.72 GB read, 287.97 MB/s read, 48.5 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 15, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 15, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 18, pending-compaction-bytes-delays: 1, pending-compaction-bytes-stops: 0, total-delays: 16, total-stops: 18, interval: 34 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2332871 Average: 2.2825 StdDev: 11.89 Min: 0 Median: 1.4596 Max: 3899 Percentiles: P50: 1.46 P75: 1.84 P99: 5.62 P99.9: 65.14 P99.99: 164.22 ------------------------------------------------------ [ 0, 1 ] 459638 19.703% 19.703% #### ( 1, 2 ] 1537692 65.914% 85.617% ############# ( 2, 3 ] 212145 9.094% 94.711% ## ( 3, 4 ] 67941 2.912% 97.623% # ( 4, 6 ] 39565 1.696% 99.319% ( 6, 10 ] 10596 0.454% 99.773% ( 10, 15 ] 2398 0.103% 99.876% ( 15, 22 ] 486 0.021% 99.897% ( 22, 34 ] 23 0.001% 99.898% ( 34, 51 ] 11 0.000% 99.898% ( 51, 76 ] 78 0.003% 99.901% ( 76, 110 ] 1218 0.052% 99.954% ( 110, 170 ] 938 0.040% 99.994% ( 170, 250 ] 229 0.010% 100.004% ( 250, 380 ] 159 0.007% 100.011% ( 380, 580 ] 143 0.006% 100.017% ( 580, 870 ] 69 0.003% 100.020% ( 870, 1300 ] 28 0.001% 100.021% ( 1300, 1900 ] 12 0.001% 100.021% ( 1900, 2900 ] 14 0.001% 100.022% ( 2900, 4400 ] 6 0.000% 100.022% ** Level 1 read latency histogram (micros): Count: 257389 Average: 2.5809 StdDev: 12.99 Min: 1 Median: 1.4438 Max: 1645 Percentiles: P50: 1.44 P75: 1.82 P99: 7.98 P99.9: 148.85 P99.99: 566.62 ------------------------------------------------------ [ 0, 1 ] 53751 20.883% 20.883% #### ( 1, 2 ] 168858 65.604% 86.487% ############# ( 2, 3 ] 20502 7.965% 94.453% ## ( 3, 4 ] 6041 2.347% 96.800% ( 4, 6 ] 4286 1.665% 98.465% ( 6, 10 ] 2782 1.081% 99.546% ( 10, 15 ] 209 0.081% 99.627% ( 15, 22 ] 78 0.030% 99.657% ( 22, 34 ] 1 0.000% 99.658% ( 51, 76 ] 17 0.007% 99.664% ( 76, 110 ] 369 0.143% 99.808% ( 110, 170 ] 367 0.143% 99.950% ( 170, 250 ] 37 0.014% 99.965% ( 250, 380 ] 41 0.016% 99.981% ( 380, 580 ] 26 0.010% 99.991% ( 580, 870 ] 13 0.005% 99.996% ( 870, 1300 ] 9 0.003% 99.999% ( 1300, 1900 ] 2 0.001% 100.000% ** Level 2 read latency histogram (micros): Count: 77332 Average: 2.6881 StdDev: 19.95 Min: 1 Median: 1.5996 Max: 3053 Percentiles: P50: 1.60 P75: 1.97 P99: 7.50 P99.9: 21.48 P99.99: 605.79 ------------------------------------------------------ [ 0, 1 ] 7552 9.766% 9.766% ## ( 1, 2 ] 51895 67.107% 76.872% ############# ( 2, 3 ] 10753 13.905% 90.777% ### ( 3, 4 ] 3543 4.582% 95.359% # ( 4, 6 ] 2467 3.190% 98.549% # ( 6, 10 ] 929 1.201% 99.750% ( 10, 15 ] 99 0.128% 99.878% ( 15, 22 ] 18 0.023% 99.902% ( 22, 34 ] 3 0.004% 99.906% ( 51, 76 ] 1 0.001% 99.907% ( 110, 170 ] 28 0.036% 99.943% ( 170, 250 ] 16 0.021% 99.964% ( 250, 380 ] 11 0.014% 99.978% ( 380, 580 ] 9 0.012% 99.990% ( 580, 870 ] 3 0.004% 99.994% ( 870, 1300 ] 3 0.004% 99.997% ( 1900, 2900 ] 2 0.003% 100.000% ( 2900, 4400 ] 1 0.001% 100.001% ** Level 3 read latency histogram (micros): Count: 186693 Average: 3.5311 StdDev: 40.43 Min: 1 Median: 1.6591 Max: 4664 Percentiles: P50: 1.66 P75: 2.19 P99: 8.80 P99.9: 192.11 P99.99: 1117.47 ------------------------------------------------------ [ 0, 1 ] 15514 8.310% 8.310% ## ( 1, 2 ] 118098 63.258% 71.568% ############# ( 2, 3 ] 33308 17.841% 89.409% #### ( 3, 4 ] 8514 4.560% 93.969% # ( 4, 6 ] 7376 3.951% 97.920% # ( 6, 10 ] 2885 1.545% 99.465% ( 10, 15 ] 347 0.186% 99.651% ( 15, 22 ] 77 0.041% 99.693% ( 22, 34 ] 22 0.012% 99.704% ( 34, 51 ] 6 0.003% 99.708% ( 51, 76 ] 36 0.019% 99.727% ( 76, 110 ] 137 0.073% 99.800% ( 110, 170 ] 170 0.091% 99.891% ( 170, 250 ] 59 0.032% 99.923% ( 250, 380 ] 41 0.022% 99.945% ( 380, 580 ] 48 0.026% 99.971% ( 580, 870 ] 30 0.016% 99.987% ( 870, 1300 ] 11 0.006% 99.993% ( 1300, 1900 ] 14 0.007% 100.000% ( 1900, 2900 ] 10 0.005% 100.005% ( 2900, 4400 ] 10 0.005% 100.011% ( 4400, 6600 ] 1 0.001% 100.011% ** Level 4 read latency histogram (micros): Count: 305 Average: 132.3311 StdDev: 603.33 Min: 0 Median: 1.3462 Max: 5428 Percentiles: P50: 1.35 P75: 4.75 P99: 3612.50 P99.9: 5428.00 P99.99: 5428.00 ------------------------------------------------------ [ 0, 1 ] 121 39.672% 39.672% ######## ( 1, 2 ] 91 29.836% 69.508% ###### ( 2, 3 ] 9 2.951% 72.459% # ( 3, 4 ] 4 1.311% 73.770% ( 4, 6 ] 10 3.279% 77.049% # ( 6, 10 ] 45 14.754% 91.803% ### ( 10, 15 ] 1 0.328% 92.131% ( 110, 170 ] 3 0.984% 93.115% ( 170, 250 ] 1 0.328% 93.443% ( 380, 580 ] 1 0.328% 93.770% ( 580, 870 ] 4 1.311% 95.082% ( 870, 1300 ] 3 0.984% 96.066% ( 1300, 1900 ] 5 1.639% 97.705% ( 1900, 2900 ] 3 0.984% 98.689% ( 2900, 4400 ] 2 0.656% 99.344% ( 4400, 6600 ] 2 0.656% 100.000% ** Level 5 read latency histogram (micros): Count: 20 Average: 834.6500 StdDev: 1191.74 Min: 61 Median: 250.0000 Max: 4119 Percentiles: P50: 250.00 P75: 1085.00 P99: 4119.00 P99.9: 4119.00 P99.99: 4119.00 ------------------------------------------------------ ( 51, 76 ] 2 10.000% 10.000% ## ( 76, 110 ] 3 15.000% 25.000% ### ( 110, 170 ] 4 20.000% 45.000% #### ( 170, 250 ] 1 5.000% 50.000% # ( 250, 380 ] 3 15.000% 65.000% ### ( 380, 580 ] 1 5.000% 70.000% # ( 870, 1300 ] 2 10.000% 80.000% ## ( 1300, 1900 ] 1 5.000% 85.000% # ( 2900, 4400 ] 3 15.000% 100.000% ### ** DB Stats ** Uptime(secs): 27.7 total, 11.9 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 213.47 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:11.658 H:M:S, 42.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 82.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:9.123 H:M:S, 76.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 0 2024/11/21-05:09:58 ... thread 0: (1000000,7000000) ops and (164585.3,208752.8) ops/second in (6.075876,33.532483) 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/9 2.76 GB 0.0 6.1 0.0 6.1 12.7 6.6 0.0 1.9 143.5 299.8 43.47 40.73 118 0.368 6331K 8110 0.0 0.0 L1 13/13 1.37 GB 0.0 4.7 3.7 1.0 4.7 3.6 0.2 1.3 223.6 220.9 21.65 20.58 3 7.218 4916K 58K 0.0 0.0 L2 8/6 1.01 GB 2.6 0.2 0.1 0.1 0.2 0.1 2.3 1.5 245.2 245.1 0.79 0.75 2 0.394 196K 83 0.0 0.0 L3 26/4 1.17 GB 1.0 2.1 1.3 0.9 2.1 1.3 0.3 1.7 209.4 208.9 10.50 9.60 6 1.750 2233K 5887 0.0 0.0 L4 168/0 9.48 GB 1.0 0.4 0.4 0.0 0.4 0.4 0.8 1.0 159.9 159.7 2.57 1.94 5 0.513 410K 222 0.0 0.0 L5 1056/0 86.92 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1280/32 102.71 GB 0.0 13.6 5.5 8.1 20.1 12.0 5.0 3.0 175.8 261.0 78.98 73.60 134 0.589 14M 73K 0.0 0.0 Int 0/0 0.00 KB 0.0 13.6 5.5 8.1 20.1 12.0 4.9 3.0 175.8 261.0 78.98 73.60 134 0.589 14M 73K 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.6 5.5 8.1 13.5 5.4 0.0 0.0 234.1 232.8 59.30 56.18 37 1.603 14M 73K 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 345.8 19.67 17.42 97 0.203 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 33.7 total, 33.5 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: 20.13 GB write, 610.90 MB/s write, 13.56 GB read, 411.42 MB/s read, 79.0 seconds Interval compaction: 20.13 GB write, 614.61 MB/s write, 13.56 GB read, 413.93 MB/s read, 79.0 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 15, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 15, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 22, pending-compaction-bytes-delays: 13, pending-compaction-bytes-stops: 0, total-delays: 28, total-stops: 22, interval: 50 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2907813 Average: 2.4464 StdDev: 13.25 Min: 0 Median: 1.5037 Max: 3899 Percentiles: P50: 1.50 P75: 1.89 P99: 5.92 P99.9: 88.42 P99.99: 193.88 ------------------------------------------------------ [ 0, 1 ] 500381 17.208% 17.208% ### ( 1, 2 ] 1893027 65.101% 82.310% ############# ( 2, 3 ] 308728 10.617% 92.927% ## ( 3, 4 ] 106761 3.672% 96.598% # ( 4, 6 ] 72795 2.503% 99.102% # ( 6, 10 ] 18311 0.630% 99.731% ( 10, 15 ] 3492 0.120% 99.852% ( 15, 22 ] 622 0.021% 99.873% ( 22, 34 ] 26 0.001% 99.874% ( 34, 51 ] 22 0.001% 99.875% ( 51, 76 ] 91 0.003% 99.878% ( 76, 110 ] 1786 0.061% 99.939% ( 110, 170 ] 1371 0.047% 99.986% ( 170, 250 ] 376 0.013% 99.999% ( 250, 380 ] 315 0.011% 100.010% ( 380, 580 ] 276 0.009% 100.019% ( 580, 870 ] 123 0.004% 100.024% ( 870, 1300 ] 54 0.002% 100.026% ( 1300, 1900 ] 19 0.001% 100.026% ( 1900, 2900 ] 19 0.001% 100.027% ( 2900, 4400 ] 8 0.000% 100.027% ** Level 1 read latency histogram (micros): Count: 705879 Average: 3.1707 StdDev: 23.61 Min: 0 Median: 1.6477 Max: 5490 Percentiles: P50: 1.65 P75: 2.20 P99: 8.72 P99.9: 149.71 P99.99: 392.04 ------------------------------------------------------ [ 0, 1 ] 69982 9.914% 9.914% ## ( 1, 2 ] 436862 61.889% 71.803% ############ ( 2, 3 ] 113856 16.130% 87.933% ### ( 3, 4 ] 37675 5.337% 93.270% # ( 4, 6 ] 32712 4.634% 97.904% # ( 6, 10 ] 11385 1.613% 99.517% ( 10, 15 ] 1307 0.185% 99.702% ( 15, 22 ] 228 0.032% 99.735% ( 22, 34 ] 13 0.002% 99.737% ( 34, 51 ] 4 0.001% 99.737% ( 51, 76 ] 41 0.006% 99.743% ( 76, 110 ] 713 0.101% 99.844% ( 110, 170 ] 597 0.085% 99.929% ( 170, 250 ] 229 0.032% 99.961% ( 250, 380 ] 194 0.027% 99.989% ( 380, 580 ] 173 0.025% 100.013% ( 580, 870 ] 88 0.012% 100.026% ( 870, 1300 ] 45 0.006% 100.032% ( 1300, 1900 ] 17 0.002% 100.034% ( 1900, 2900 ] 7 0.001% 100.035% ( 2900, 4400 ] 8 0.001% 100.036% ( 4400, 6600 ] 1 0.000% 100.037% ** Level 2 read latency histogram (micros): Count: 77332 Average: 2.6881 StdDev: 19.95 Min: 1 Median: 1.5996 Max: 3053 Percentiles: P50: 1.60 P75: 1.97 P99: 7.50 P99.9: 21.48 P99.99: 605.79 ------------------------------------------------------ [ 0, 1 ] 7552 9.766% 9.766% ## ( 1, 2 ] 51895 67.107% 76.872% ############# ( 2, 3 ] 10753 13.905% 90.777% ### ( 3, 4 ] 3543 4.582% 95.359% # ( 4, 6 ] 2467 3.190% 98.549% # ( 6, 10 ] 929 1.201% 99.750% ( 10, 15 ] 99 0.128% 99.878% ( 15, 22 ] 18 0.023% 99.902% ( 22, 34 ] 3 0.004% 99.906% ( 51, 76 ] 1 0.001% 99.907% ( 110, 170 ] 28 0.036% 99.943% ( 170, 250 ] 16 0.021% 99.964% ( 250, 380 ] 11 0.014% 99.978% ( 380, 580 ] 9 0.012% 99.990% ( 580, 870 ] 3 0.004% 99.994% ( 870, 1300 ] 3 0.004% 99.997% ( 1900, 2900 ] 2 0.003% 100.000% ( 2900, 4400 ] 1 0.001% 100.001% ** Level 3 read latency histogram (micros): Count: 282071 Average: 3.9397 StdDev: 38.86 Min: 1 Median: 1.7647 Max: 4664 Percentiles: P50: 1.76 P75: 2.56 P99: 9.23 P99.9: 230.90 P99.99: 515.11 ------------------------------------------------------ [ 0, 1 ] 16536 5.862% 5.862% # ( 1, 2 ] 162804 57.717% 63.580% ############ ( 2, 3 ] 57969 20.551% 84.131% #### ( 3, 4 ] 19577 6.940% 91.071% # ( 4, 6 ] 18390 6.520% 97.591% # ( 6, 10 ] 4927 1.747% 99.338% ( 10, 15 ] 721 0.256% 99.593% ( 15, 22 ] 117 0.041% 99.635% ( 22, 34 ] 24 0.009% 99.643% ( 34, 51 ] 7 0.002% 99.646% ( 51, 76 ] 38 0.013% 99.659% ( 76, 110 ] 235 0.083% 99.743% ( 110, 170 ] 297 0.105% 99.848% ( 170, 250 ] 193 0.068% 99.916% ( 250, 380 ] 122 0.043% 99.960% ( 380, 580 ] 127 0.045% 100.005% ( 580, 870 ] 57 0.020% 100.025% ( 870, 1300 ] 21 0.007% 100.032% ( 1300, 1900 ] 14 0.005% 100.037% ( 1900, 2900 ] 11 0.004% 100.041% ( 2900, 4400 ] 14 0.005% 100.046% ( 4400, 6600 ] 1 0.000% 100.046% ** Level 4 read latency histogram (micros): Count: 3298 Average: 41.9339 StdDev: 222.81 Min: 0 Median: 2.0787 Max: 5428 Percentiles: P50: 2.08 P75: 3.53 P99: 800.20 P99.9: 3751.00 P99.99: 5428.00 ------------------------------------------------------ [ 0, 1 ] 178 5.397% 5.397% # ( 1, 2 ] 1416 42.935% 48.332% ######### ( 2, 3 ] 699 21.195% 69.527% #### ( 3, 4 ] 340 10.309% 79.836% ## ( 4, 6 ] 248 7.520% 87.356% ## ( 6, 10 ] 112 3.396% 90.752% # ( 10, 15 ] 15 0.455% 91.207% ( 15, 22 ] 2 0.061% 91.267% ( 51, 76 ] 1 0.030% 91.298% ( 76, 110 ] 22 0.667% 91.965% ( 110, 170 ] 64 1.941% 93.905% ( 170, 250 ] 45 1.364% 95.270% ( 250, 380 ] 51 1.546% 96.816% ( 380, 580 ] 50 1.516% 98.332% ( 580, 870 ] 29 0.879% 99.212% ( 870, 1300 ] 13 0.394% 99.606% ( 1300, 1900 ] 5 0.152% 99.757% ( 1900, 2900 ] 3 0.091% 99.848% ( 2900, 4400 ] 3 0.091% 99.939% ( 4400, 6600 ] 2 0.061% 100.000% ** Level 5 read latency histogram (micros): Count: 80 Average: 844.5500 StdDev: 1079.81 Min: 61 Median: 293.3333 Max: 4571 Percentiles: P50: 293.33 P75: 1156.67 P99: 4571.00 P99.9: 4571.00 P99.99: 4571.00 ------------------------------------------------------ ( 51, 76 ] 2 2.500% 2.500% # ( 76, 110 ] 10 12.500% 15.000% ### ( 110, 170 ] 13 16.250% 31.250% ### ( 170, 250 ] 12 15.000% 46.250% ### ( 250, 380 ] 9 11.250% 57.500% ## ( 380, 580 ] 6 7.500% 65.000% ## ( 580, 870 ] 4 5.000% 70.000% # ( 870, 1300 ] 6 7.500% 77.500% ## ( 1300, 1900 ] 5 6.250% 83.750% # ( 1900, 2900 ] 6 7.500% 91.250% ## ( 2900, 4400 ] 6 7.500% 98.750% ## ( 4400, 6600 ] 1 1.250% 100.000% ** DB Stats ** Uptime(secs): 33.7 total, 6.1 interval Cumulative writes: 0 writes, 7000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 6.73 GB, 204.20 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:14.992 H:M:S, 44.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 161.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:3.334 H:M:S, 54.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 4 num-running-flushes: 1 2024/11/21-05:10:02 ... thread 0: (1000000,8000000) ops and (210044.2,208913.4) ops/second in (4.760903,38.293386) 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/9 3.68 GB 163.3 7.6 0.0 7.6 15.1 7.6 0.0 2.0 144.4 288.5 53.66 49.14 134 0.400 7866K 11K 0.0 0.0 L1 13/13 1.37 GB 0.0 4.7 3.7 1.0 4.7 3.6 0.2 1.3 223.6 220.9 21.65 20.58 3 7.218 4916K 58K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.2 0.1 0.1 0.2 0.1 2.3 1.5 245.2 245.1 0.79 0.75 2 0.394 196K 83 0.0 0.0 L3 21/0 945.55 MB 0.9 3.6 2.3 1.3 3.6 2.3 0.3 1.6 196.9 196.5 18.53 16.18 10 1.853 3707K 8544 0.0 0.0 L4 178/0 9.74 GB 1.0 1.7 1.6 0.1 1.7 1.6 0.8 1.0 124.6 124.4 14.06 8.45 27 0.521 1748K 1725 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 1293/22 103.62 GB 0.0 17.8 7.7 10.0 25.2 15.2 6.0 3.3 167.3 237.8 108.69 95.11 176 0.618 18M 81K 0.0 0.0 Int 0/0 0.00 KB 0.0 17.8 7.7 10.0 25.2 15.2 5.9 3.3 167.3 237.8 108.69 95.11 176 0.618 18M 81K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 17.8 7.7 10.0 17.7 7.6 0.0 0.0 213.0 212.1 85.35 75.16 66 1.293 18M 81K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 7.6 7.6 0.0 0.0 0.0 331.9 23.34 19.95 110 0.212 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 38.5 total, 38.3 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: 25.24 GB write, 671.42 MB/s write, 17.76 GB read, 472.30 MB/s read, 108.7 seconds Interval compaction: 25.24 GB write, 675.00 MB/s write, 17.76 GB read, 474.82 MB/s read, 108.7 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 15, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 15, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 38, pending-compaction-bytes-delays: 22, pending-compaction-bytes-stops: 0, total-delays: 37, total-stops: 38, interval: 75 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3329117 Average: 2.5954 StdDev: 21.29 Min: 0 Median: 1.5328 Max: 9046 Percentiles: P50: 1.53 P75: 1.92 P99: 6.24 P99.9: 84.84 P99.99: 218.94 ------------------------------------------------------ [ 0, 1 ] 525812 15.794% 15.794% ### ( 1, 2 ] 2137295 64.200% 79.994% ############# ( 2, 3 ] 387966 11.654% 91.648% ## ( 3, 4 ] 139218 4.182% 95.830% # ( 4, 6 ] 104036 3.125% 98.955% # ( 6, 10 ] 25478 0.765% 99.720% ( 10, 15 ] 4598 0.138% 99.858% ( 15, 22 ] 753 0.023% 99.881% ( 22, 34 ] 33 0.001% 99.882% ( 34, 51 ] 26 0.001% 99.883% ( 51, 76 ] 103 0.003% 99.886% ( 76, 110 ] 1807 0.054% 99.940% ( 110, 170 ] 1404 0.042% 99.982% ( 170, 250 ] 417 0.013% 99.995% ( 250, 380 ] 370 0.011% 100.006% ( 380, 580 ] 341 0.010% 100.016% ( 580, 870 ] 191 0.006% 100.022% ( 870, 1300 ] 108 0.003% 100.025% ( 1300, 1900 ] 43 0.001% 100.026% ( 1900, 2900 ] 40 0.001% 100.028% ( 2900, 4400 ] 39 0.001% 100.029% ( 4400, 6600 ] 3 0.000% 100.029% ( 6600, 9900 ] 3 0.000% 100.029% ** Level 1 read latency histogram (micros): Count: 989315 Average: 3.6573 StdDev: 43.93 Min: 0 Median: 1.7052 Max: 12351 Percentiles: P50: 1.71 P75: 2.41 P99: 8.97 P99.9: 167.77 P99.99: 533.55 ------------------------------------------------------ [ 0, 1 ] 77536 7.837% 7.837% ## ( 1, 2 ] 591472 59.786% 67.623% ############ ( 2, 3 ] 179244 18.118% 85.741% #### ( 3, 4 ] 60953 6.161% 91.902% # ( 4, 6 ] 56409 5.702% 97.604% # ( 6, 10 ] 18620 1.882% 99.486% ( 10, 15 ] 2238 0.226% 99.713% ( 15, 22 ] 332 0.034% 99.746% ( 22, 34 ] 28 0.003% 99.749% ( 34, 51 ] 8 0.001% 99.750% ( 51, 76 ] 44 0.004% 99.754% ( 76, 110 ] 787 0.080% 99.834% ( 110, 170 ] 680 0.069% 99.903% ( 170, 250 ] 311 0.031% 99.934% ( 250, 380 ] 313 0.032% 99.966% ( 380, 580 ] 314 0.032% 99.997% ( 580, 870 ] 187 0.019% 100.016% ( 870, 1300 ] 96 0.010% 100.026% ( 1300, 1900 ] 45 0.005% 100.031% ( 1900, 2900 ] 29 0.003% 100.033% ( 2900, 4400 ] 38 0.004% 100.037% ( 4400, 6600 ] 11 0.001% 100.038% ( 6600, 9900 ] 7 0.001% 100.039% ( 9900, 14000 ] 1 0.000% 100.039% ** Level 2 read latency histogram (micros): Count: 77332 Average: 2.6881 StdDev: 19.95 Min: 1 Median: 1.5996 Max: 3053 Percentiles: P50: 1.60 P75: 1.97 P99: 7.50 P99.9: 21.48 P99.99: 605.79 ------------------------------------------------------ [ 0, 1 ] 7552 9.766% 9.766% ## ( 1, 2 ] 51895 67.107% 76.872% ############# ( 2, 3 ] 10753 13.905% 90.777% ### ( 3, 4 ] 3543 4.582% 95.359% # ( 4, 6 ] 2467 3.190% 98.549% # ( 6, 10 ] 929 1.201% 99.750% ( 10, 15 ] 99 0.128% 99.878% ( 15, 22 ] 18 0.023% 99.902% ( 22, 34 ] 3 0.004% 99.906% ( 51, 76 ] 1 0.001% 99.907% ( 110, 170 ] 28 0.036% 99.943% ( 170, 250 ] 16 0.021% 99.964% ( 250, 380 ] 11 0.014% 99.978% ( 380, 580 ] 9 0.012% 99.990% ( 580, 870 ] 3 0.004% 99.994% ( 870, 1300 ] 3 0.004% 99.997% ( 1900, 2900 ] 2 0.003% 100.000% ( 2900, 4400 ] 1 0.001% 100.001% ** Level 3 read latency histogram (micros): Count: 686986 Average: 5.3581 StdDev: 79.00 Min: 1 Median: 1.9245 Max: 11052 Percentiles: P50: 1.92 P75: 2.88 P99: 9.31 P99.9: 178.47 P99.99: 408.67 ------------------------------------------------------ [ 0, 1 ] 18974 2.762% 2.762% # ( 1, 2 ] 351019 51.096% 53.857% ########## ( 2, 3 ] 165524 24.094% 77.952% ##### ( 3, 4 ] 65700 9.564% 87.515% ## ( 4, 6 ] 66854 9.731% 97.247% ## ( 6, 10 ] 14557 2.119% 99.366% ( 10, 15 ] 2576 0.375% 99.741% ( 15, 22 ] 318 0.046% 99.787% ( 22, 34 ] 41 0.006% 99.793% ( 34, 51 ] 7 0.001% 99.794% ( 51, 76 ] 47 0.007% 99.801% ( 76, 110 ] 275 0.040% 99.841% ( 110, 170 ] 374 0.054% 99.895% ( 170, 250 ] 312 0.045% 99.941% ( 250, 380 ] 291 0.042% 99.983% ( 380, 580 ] 337 0.049% 100.032% ( 580, 870 ] 248 0.036% 100.068% ( 870, 1300 ] 161 0.023% 100.092% ( 1300, 1900 ] 84 0.012% 100.104% ( 1900, 2900 ] 64 0.009% 100.113% ( 2900, 4400 ] 120 0.017% 100.131% ( 4400, 6600 ] 20 0.003% 100.133% ( 6600, 9900 ] 14 0.002% 100.136% ( 9900, 14000 ] 2 0.000% 100.136% ** Level 4 read latency histogram (micros): Count: 19928 Average: 80.3658 StdDev: 370.54 Min: 0 Median: 2.1760 Max: 7099 Percentiles: P50: 2.18 P75: 3.49 P99: 1802.14 P99.9: 4524.13 P99.99: 6607.92 ------------------------------------------------------ [ 0, 1 ] 450 2.258% 2.258% ( 1, 2 ] 8680 43.557% 45.815% ######### ( 2, 3 ] 4738 23.776% 69.591% ##### ( 3, 4 ] 2212 11.100% 80.690% ## ( 4, 6 ] 1503 7.542% 88.233% ## ( 6, 10 ] 513 2.574% 90.807% # ( 10, 15 ] 72 0.361% 91.168% ( 15, 22 ] 11 0.055% 91.223% ( 22, 34 ] 2 0.010% 91.233% ( 51, 76 ] 2 0.010% 91.243% ( 76, 110 ] 34 0.171% 91.414% ( 110, 170 ] 133 0.667% 92.081% ( 170, 250 ] 164 0.823% 92.904% ( 250, 380 ] 236 1.184% 94.089% ( 380, 580 ] 287 1.440% 95.529% ( 580, 870 ] 315 1.581% 97.110% ( 870, 1300 ] 247 1.239% 98.349% ( 1300, 1900 ] 155 0.778% 99.127% ( 1900, 2900 ] 87 0.437% 99.563% ( 2900, 4400 ] 66 0.331% 99.895% ( 4400, 6600 ] 19 0.095% 99.990% ( 6600, 9900 ] 3 0.015% 100.005% ** Level 5 read latency histogram (micros): Count: 140 Average: 965.8214 StdDev: 1115.43 Min: 61 Median: 416.3636 Max: 5418 Percentiles: P50: 416.36 P75: 1375.00 P99: 5060.00 P99.9: 5418.00 P99.99: 5418.00 ------------------------------------------------------ ( 51, 76 ] 2 1.429% 1.429% ( 76, 110 ] 15 10.714% 12.143% ## ( 110, 170 ] 14 10.000% 22.143% ## ( 170, 250 ] 19 13.571% 35.714% ### ( 250, 380 ] 18 12.857% 48.571% ### ( 380, 580 ] 11 7.857% 56.429% ## ( 580, 870 ] 14 10.000% 66.429% ## ( 870, 1300 ] 11 7.857% 74.286% ## ( 1300, 1900 ] 8 5.714% 80.000% # ( 1900, 2900 ] 15 10.714% 90.714% ## ( 2900, 4400 ] 11 7.857% 98.571% ## ( 4400, 6600 ] 2 1.429% 100.000% ** DB Stats ** Uptime(secs): 38.5 total, 4.8 interval Cumulative writes: 0 writes, 8000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 7.69 GB, 204.51 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:16.892 H:M:S, 43.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 206.72 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:1.900 H:M:S, 39.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/21-05:10:12 ... thread 0: (1000000,9000000) ops and (100071.1,186388.3) ops/second in (9.992896,48.286282) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 10/6 2.82 GB 131.8 8.7 0.0 8.7 17.2 8.5 0.0 2.0 145.6 288.9 61.01 56.05 152 0.401 9017K 13K 0.0 0.0 L1 10/0 1.13 GB 116.2 7.9 5.5 2.4 7.8 5.4 0.2 1.4 216.7 214.0 37.53 35.00 4 9.384 7268K 58K 0.0 0.0 L2 5/4 584.75 MB 0.7 0.2 0.1 0.1 0.2 0.1 4.4 1.5 245.2 245.1 0.79 0.75 2 0.394 196K 83 0.0 0.0 L3 26/3 1.15 GB 1.0 5.5 3.5 2.0 5.4 3.5 0.5 1.6 170.3 169.7 32.86 25.37 21 1.565 5683K 21K 0.0 0.0 L4 172/2 9.67 GB 1.0 3.2 2.9 0.4 3.2 2.8 0.9 1.1 133.3 132.9 24.70 15.76 41 0.602 3283K 4490 0.0 0.0 L5 1084/0 89.20 GB 0.9 0.0 0.0 0.0 0.0 0.0 3.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1307/15 104.55 GB 0.0 25.5 12.0 13.5 33.9 20.4 9.6 4.0 166.3 221.2 156.89 132.94 220 0.713 25M 97K 0.0 0.0 Int 0/0 0.00 KB 0.0 25.5 12.0 13.5 33.9 20.4 9.5 4.0 166.3 221.2 156.89 132.94 220 0.713 25M 97K 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 25.5 12.0 13.5 25.3 11.8 0.0 0.0 199.8 198.7 130.60 110.42 96 1.360 25M 97K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 8.6 8.6 0.0 0.0 0.0 333.1 26.29 22.52 124 0.212 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 48.5 total, 48.3 interval Flush(GB): cumulative 8.551, interval 8.551 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 33.90 GB write, 715.76 MB/s write, 25.48 GB read, 538.13 MB/s read, 156.9 seconds Interval compaction: 33.90 GB write, 718.79 MB/s write, 25.48 GB read, 540.41 MB/s read, 156.9 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 15, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 15, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 41, pending-compaction-bytes-delays: 53, pending-compaction-bytes-stops: 0, total-delays: 68, total-stops: 41, interval: 109 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 4126398 Average: 2.6064 StdDev: 21.45 Min: 0 Median: 1.5444 Max: 9046 Percentiles: P50: 1.54 P75: 1.93 P99: 6.55 P99.9: 72.93 P99.99: 228.46 ------------------------------------------------------ [ 0, 1 ] 623761 15.116% 15.116% ### ( 1, 2 ] 2643922 64.073% 79.190% ############# ( 2, 3 ] 491392 11.908% 91.098% ## ( 3, 4 ] 181854 4.407% 95.505% # ( 4, 6 ] 139447 3.379% 98.885% # ( 6, 10 ] 34770 0.843% 99.727% ( 10, 15 ] 5963 0.145% 99.872% ( 15, 22 ] 995 0.024% 99.896% ( 22, 34 ] 47 0.001% 99.897% ( 34, 51 ] 26 0.001% 99.898% ( 51, 76 ] 109 0.003% 99.900% ( 76, 110 ] 1882 0.046% 99.946% ( 110, 170 ] 1480 0.036% 99.982% ( 170, 250 ] 463 0.011% 99.993% ( 250, 380 ] 414 0.010% 100.003% ( 380, 580 ] 391 0.009% 100.013% ( 580, 870 ] 233 0.006% 100.018% ( 870, 1300 ] 143 0.003% 100.022% ( 1300, 1900 ] 63 0.002% 100.023% ( 1900, 2900 ] 53 0.001% 100.024% ( 2900, 4400 ] 50 0.001% 100.026% ( 4400, 6600 ] 5 0.000% 100.026% ( 6600, 9900 ] 3 0.000% 100.026% ** Level 1 read latency histogram (micros): Count: 1654101 Average: 4.7407 StdDev: 64.92 Min: 0 Median: 1.7730 Max: 12351 Percentiles: P50: 1.77 P75: 2.62 P99: 9.27 P99.9: 253.87 P99.99: 697.29 ------------------------------------------------------ [ 0, 1 ] 104097 6.293% 6.293% # ( 1, 2 ] 935247 56.541% 62.834% ########### ( 2, 3 ] 324932 19.644% 82.478% #### ( 3, 4 ] 121595 7.351% 89.830% # ( 4, 6 ] 122091 7.381% 97.211% # ( 6, 10 ] 36208 2.189% 99.400% ( 10, 15 ] 4888 0.296% 99.695% ( 15, 22 ] 745 0.045% 99.740% ( 22, 34 ] 50 0.003% 99.743% ( 34, 51 ] 23 0.001% 99.745% ( 51, 76 ] 135 0.008% 99.753% ( 76, 110 ] 984 0.059% 99.812% ( 110, 170 ] 932 0.056% 99.869% ( 170, 250 ] 503 0.030% 99.899% ( 250, 380 ] 568 0.034% 99.933% ( 380, 580 ] 684 0.041% 99.975% ( 580, 870 ] 627 0.038% 100.013% ( 870, 1300 ] 422 0.026% 100.038% ( 1300, 1900 ] 207 0.013% 100.051% ( 1900, 2900 ] 136 0.008% 100.059% ( 2900, 4400 ] 196 0.012% 100.071% ( 4400, 6600 ] 50 0.003% 100.074% ( 6600, 9900 ] 13 0.001% 100.074% ( 9900, 14000 ] 1 0.000% 100.075% ** Level 2 read latency histogram (micros): Count: 77332 Average: 2.6881 StdDev: 19.95 Min: 1 Median: 1.5996 Max: 3053 Percentiles: P50: 1.60 P75: 1.97 P99: 7.50 P99.9: 21.48 P99.99: 605.79 ------------------------------------------------------ [ 0, 1 ] 7552 9.766% 9.766% ## ( 1, 2 ] 51895 67.107% 76.872% ############# ( 2, 3 ] 10753 13.905% 90.777% ### ( 3, 4 ] 3543 4.582% 95.359% # ( 4, 6 ] 2467 3.190% 98.549% # ( 6, 10 ] 929 1.201% 99.750% ( 10, 15 ] 99 0.128% 99.878% ( 15, 22 ] 18 0.023% 99.902% ( 22, 34 ] 3 0.004% 99.906% ( 51, 76 ] 1 0.001% 99.907% ( 110, 170 ] 28 0.036% 99.943% ( 170, 250 ] 16 0.021% 99.964% ( 250, 380 ] 11 0.014% 99.978% ( 380, 580 ] 9 0.012% 99.990% ( 580, 870 ] 3 0.004% 99.994% ( 870, 1300 ] 3 0.004% 99.997% ( 1900, 2900 ] 2 0.003% 100.000% ( 2900, 4400 ] 1 0.001% 100.001% ** Level 3 read latency histogram (micros): Count: 1201562 Average: 5.5405 StdDev: 77.36 Min: 1 Median: 2.0189 Max: 11052 Percentiles: P50: 2.02 P75: 3.05 P99: 9.30 P99.9: 120.26 P99.99: 365.20 ------------------------------------------------------ [ 0, 1 ] 22236 1.851% 1.851% ( 1, 2 ] 572860 47.676% 49.527% ########## ( 2, 3 ] 300022 24.969% 74.496% ##### ( 3, 4 ] 131551 10.948% 85.445% ## ( 4, 6 ] 140101 11.660% 97.104% ## ( 6, 10 ] 27602 2.297% 99.402% ( 10, 15 ] 4847 0.403% 99.805% ( 15, 22 ] 629 0.052% 99.857% ( 22, 34 ] 60 0.005% 99.862% ( 34, 51 ] 13 0.001% 99.863% ( 51, 76 ] 81 0.007% 99.870% ( 76, 110 ] 289 0.024% 99.894% ( 110, 170 ] 406 0.034% 99.928% ( 170, 250 ] 370 0.031% 99.959% ( 250, 380 ] 423 0.035% 99.994% ( 380, 580 ] 585 0.049% 100.043% ( 580, 870 ] 511 0.043% 100.085% ( 870, 1300 ] 345 0.029% 100.114% ( 1300, 1900 ] 196 0.016% 100.130% ( 1900, 2900 ] 133 0.011% 100.141% ( 2900, 4400 ] 214 0.018% 100.159% ( 4400, 6600 ] 37 0.003% 100.162% ( 6600, 9900 ] 17 0.001% 100.164% ( 9900, 14000 ] 2 0.000% 100.164% ** Level 4 read latency histogram (micros): Count: 94171 Average: 36.6659 StdDev: 244.87 Min: 0 Median: 2.2770 Max: 7099 Percentiles: P50: 2.28 P75: 3.58 P99: 1040.35 P99.9: 3437.72 P99.99: 4352.33 ------------------------------------------------------ [ 0, 1 ] 1062 1.128% 1.128% ( 1, 2 ] 39531 41.978% 43.106% ######## ( 2, 3 ] 23435 24.886% 67.991% ##### ( 3, 4 ] 11448 12.157% 80.148% ## ( 4, 6 ] 11879 12.614% 92.762% ### ( 6, 10 ] 2883 3.061% 95.824% # ( 10, 15 ] 439 0.466% 96.290% ( 15, 22 ] 64 0.068% 96.358% ( 22, 34 ] 7 0.007% 96.365% ( 51, 76 ] 12 0.013% 96.378% ( 76, 110 ] 68 0.072% 96.450% ( 110, 170 ] 194 0.206% 96.656% ( 170, 250 ] 268 0.285% 96.941% ( 250, 380 ] 390 0.414% 97.355% ( 380, 580 ] 626 0.665% 98.020% ( 580, 870 ] 705 0.749% 98.768% ( 870, 1300 ] 551 0.585% 99.353% ( 1300, 1900 ] 307 0.326% 99.679% ( 1900, 2900 ] 158 0.168% 99.847% ( 2900, 4400 ] 139 0.148% 99.995% ( 4400, 6600 ] 42 0.045% 100.039% ( 6600, 9900 ] 3 0.003% 100.042% ** Level 5 read latency histogram (micros): Count: 220 Average: 1204.0955 StdDev: 1364.39 Min: 61 Median: 603.2000 Max: 7796 Percentiles: P50: 603.20 P75: 1771.43 P99: 6270.00 P99.9: 7796.00 P99.99: 7796.00 ------------------------------------------------------ ( 51, 76 ] 2 0.909% 0.909% ( 76, 110 ] 15 6.818% 7.727% # ( 110, 170 ] 15 6.818% 14.545% # ( 170, 250 ] 24 10.909% 25.455% ## ( 250, 380 ] 27 12.273% 37.727% ## ( 380, 580 ] 25 11.364% 49.091% ## ( 580, 870 ] 25 11.364% 60.455% ## ( 870, 1300 ] 21 9.545% 70.000% ## ( 1300, 1900 ] 14 6.364% 76.364% # ( 1900, 2900 ] 22 10.000% 86.364% ## ( 2900, 4400 ] 21 9.545% 95.909% ## ( 4400, 6600 ] 8 3.636% 99.545% # ( 6600, 9900 ] 1 0.455% 100.000% ** DB Stats ** Uptime(secs): 48.5 total, 10.0 interval Cumulative writes: 0 writes, 9000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 8.65 GB, 182.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:24.072 H:M:S, 49.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 98.49 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:7.179 H:M:S, 71.8 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 4 num-running-flushes: 1 2024/11/21-05:10:16 ... thread 0: (1000000,10000000) ops and (297012.5,193599.1) ops/second in (3.366862,51.653144) 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/14 3.74 GB 31.5 10.5 0.0 10.5 20.0 9.5 0.0 2.1 150.0 284.8 71.78 65.88 167 0.430 10M 24K 0.0 0.0 L1 10/10 1.13 GB 0.0 7.9 5.5 2.4 7.8 5.4 0.2 1.4 216.7 214.0 37.53 35.00 4 9.384 7268K 58K 0.0 0.0 L2 1/0 69.63 MB 0.7 0.2 0.1 0.1 0.2 0.1 4.4 1.5 245.2 245.1 0.79 0.75 2 0.394 196K 83 0.0 0.0 L3 22/0 912.63 MB 0.9 6.0 4.0 2.1 6.0 4.0 0.5 1.5 167.8 167.2 36.76 28.08 22 1.671 6266K 22K 0.0 0.0 L4 174/0 9.75 GB 1.0 4.1 3.6 0.5 4.1 3.6 0.9 1.1 135.9 135.6 30.76 19.96 51 0.603 4139K 4490 0.0 0.0 L5 1092/0 89.88 GB 0.9 0.0 0.0 0.0 0.0 0.0 4.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1314/24 105.46 GB 0.0 28.8 13.2 15.5 38.1 22.6 10.2 4.0 165.8 219.5 177.63 149.67 246 0.722 28M 110K 0.0 0.0 Int 0/0 0.00 KB 0.0 28.8 13.2 15.5 38.1 22.6 10.1 4.0 165.8 219.5 177.63 149.67 246 0.722 28M 110K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 28.8 13.2 15.5 28.6 13.1 0.0 0.0 198.6 197.5 148.31 124.68 109 1.361 28M 110K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 9.5 9.5 0.0 0.0 0.0 330.8 29.33 24.98 137 0.214 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): 51.9 total, 51.7 interval Flush(GB): cumulative 9.474, interval 9.474 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: 38.08 GB write, 751.86 MB/s write, 28.76 GB read, 567.83 MB/s read, 177.6 seconds Interval compaction: 38.08 GB write, 754.83 MB/s write, 28.76 GB read, 570.07 MB/s read, 177.6 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 15, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 15, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 48, pending-compaction-bytes-delays: 53, pending-compaction-bytes-stops: 0, total-delays: 68, total-stops: 48, interval: 116 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 4434330 Average: 2.6326 StdDev: 23.17 Min: 0 Median: 1.5466 Max: 9095 Percentiles: P50: 1.55 P75: 1.94 P99: 6.54 P99.9: 30.42 P99.99: 241.88 ------------------------------------------------------ [ 0, 1 ] 658660 14.854% 14.854% ### ( 1, 2 ] 2851404 64.303% 79.157% ############# ( 2, 3 ] 534330 12.050% 91.206% ## ( 3, 4 ] 193574 4.365% 95.572% # ( 4, 6 ] 146881 3.312% 98.884% # ( 6, 10 ] 37741 0.851% 99.735% ( 10, 15 ] 6248 0.141% 99.876% ( 15, 22 ] 1027 0.023% 99.899% ( 22, 34 ] 48 0.001% 99.900% ( 34, 51 ] 26 0.001% 99.901% ( 51, 76 ] 111 0.003% 99.903% ( 76, 110 ] 1886 0.043% 99.946% ( 110, 170 ] 1507 0.034% 99.980% ( 170, 250 ] 497 0.011% 99.991% ( 250, 380 ] 456 0.010% 100.001% ( 380, 580 ] 450 0.010% 100.012% ( 580, 870 ] 280 0.006% 100.018% ( 870, 1300 ] 182 0.004% 100.022% ( 1300, 1900 ] 83 0.002% 100.024% ( 1900, 2900 ] 61 0.001% 100.025% ( 2900, 4400 ] 55 0.001% 100.027% ( 4400, 6600 ] 8 0.000% 100.027% ( 6600, 9900 ] 5 0.000% 100.027% ** Level 1 read latency histogram (micros): Count: 1654102 Average: 4.7427 StdDev: 64.97 Min: 0 Median: 1.7730 Max: 12351 Percentiles: P50: 1.77 P75: 2.62 P99: 9.27 P99.9: 254.10 P99.99: 697.75 ------------------------------------------------------ [ 0, 1 ] 104097 6.293% 6.293% # ( 1, 2 ] 935247 56.541% 62.834% ########### ( 2, 3 ] 324932 19.644% 82.478% #### ( 3, 4 ] 121595 7.351% 89.829% # ( 4, 6 ] 122091 7.381% 97.211% # ( 6, 10 ] 36208 2.189% 99.400% ( 10, 15 ] 4888 0.296% 99.695% ( 15, 22 ] 745 0.045% 99.740% ( 22, 34 ] 50 0.003% 99.743% ( 34, 51 ] 23 0.001% 99.745% ( 51, 76 ] 135 0.008% 99.753% ( 76, 110 ] 984 0.059% 99.812% ( 110, 170 ] 932 0.056% 99.869% ( 170, 250 ] 503 0.030% 99.899% ( 250, 380 ] 568 0.034% 99.933% ( 380, 580 ] 684 0.041% 99.975% ( 580, 870 ] 627 0.038% 100.013% ( 870, 1300 ] 422 0.026% 100.038% ( 1300, 1900 ] 207 0.013% 100.051% ( 1900, 2900 ] 136 0.008% 100.059% ( 2900, 4400 ] 197 0.012% 100.071% ( 4400, 6600 ] 50 0.003% 100.074% ( 6600, 9900 ] 13 0.001% 100.074% ( 9900, 14000 ] 1 0.000% 100.075% ** Level 2 read latency histogram (micros): Count: 77332 Average: 2.6881 StdDev: 19.95 Min: 1 Median: 1.5996 Max: 3053 Percentiles: P50: 1.60 P75: 1.97 P99: 7.50 P99.9: 21.48 P99.99: 605.79 ------------------------------------------------------ [ 0, 1 ] 7552 9.766% 9.766% ## ( 1, 2 ] 51895 67.107% 76.872% ############# ( 2, 3 ] 10753 13.905% 90.777% ### ( 3, 4 ] 3543 4.582% 95.359% # ( 4, 6 ] 2467 3.190% 98.549% # ( 6, 10 ] 929 1.201% 99.750% ( 10, 15 ] 99 0.128% 99.878% ( 15, 22 ] 18 0.023% 99.902% ( 22, 34 ] 3 0.004% 99.906% ( 51, 76 ] 1 0.001% 99.907% ( 110, 170 ] 28 0.036% 99.943% ( 170, 250 ] 16 0.021% 99.964% ( 250, 380 ] 11 0.014% 99.978% ( 380, 580 ] 9 0.012% 99.990% ( 580, 870 ] 3 0.004% 99.994% ( 870, 1300 ] 3 0.004% 99.997% ( 1900, 2900 ] 2 0.003% 100.000% ( 2900, 4400 ] 1 0.001% 100.001% ** Level 3 read latency histogram (micros): Count: 1397272 Average: 5.4465 StdDev: 77.22 Min: 1 Median: 1.9956 Max: 11052 Percentiles: P50: 2.00 P75: 3.00 P99: 9.17 P99.9: 80.56 P99.99: 302.70 ------------------------------------------------------ [ 0, 1 ] 26017 1.862% 1.862% ( 1, 2 ] 675578 48.350% 50.212% ########## ( 2, 3 ] 347750 24.888% 75.100% ##### ( 3, 4 ] 150953 10.803% 85.903% ## ( 4, 6 ] 158565 11.348% 97.251% ## ( 6, 10 ] 30805 2.205% 99.456% ( 10, 15 ] 5326 0.381% 99.837% ( 15, 22 ] 674 0.048% 99.885% ( 22, 34 ] 66 0.005% 99.890% ( 34, 51 ] 17 0.001% 99.891% ( 51, 76 ] 84 0.006% 99.897% ( 76, 110 ] 296 0.021% 99.918% ( 110, 170 ] 426 0.030% 99.949% ( 170, 250 ] 388 0.028% 99.977% ( 250, 380 ] 462 0.033% 100.010% ( 380, 580 ] 631 0.045% 100.055% ( 580, 870 ] 581 0.042% 100.096% ( 870, 1300 ] 388 0.028% 100.124% ( 1300, 1900 ] 219 0.016% 100.140% ( 1900, 2900 ] 160 0.011% 100.151% ( 2900, 4400 ] 230 0.016% 100.168% ( 4400, 6600 ] 45 0.003% 100.171% ( 6600, 9900 ] 24 0.002% 100.173% ( 9900, 14000 ] 3 0.000% 100.173% ** Level 4 read latency histogram (micros): Count: 121749 Average: 35.7084 StdDev: 242.12 Min: 0 Median: 2.1886 Max: 7590 Percentiles: P50: 2.19 P75: 3.45 P99: 999.26 P99.9: 3495.48 P99.99: 4398.56 ------------------------------------------------------ [ 0, 1 ] 1880 1.544% 1.544% ( 1, 2 ] 53380 43.844% 45.388% ######### ( 2, 3 ] 29774 24.455% 69.844% ##### ( 3, 4 ] 13979 11.482% 81.326% ## ( 4, 6 ] 14022 11.517% 92.843% ## ( 6, 10 ] 3578 2.939% 95.781% # ( 10, 15 ] 539 0.443% 96.224% ( 15, 22 ] 87 0.071% 96.296% ( 22, 34 ] 11 0.009% 96.305% ( 34, 51 ] 2 0.002% 96.306% ( 51, 76 ] 16 0.013% 96.319% ( 76, 110 ] 148 0.122% 96.441% ( 110, 170 ] 302 0.248% 96.689% ( 170, 250 ] 370 0.304% 96.993% ( 250, 380 ] 548 0.450% 97.443% ( 380, 580 ] 813 0.668% 98.111% ( 580, 870 ] 879 0.722% 98.833% ( 870, 1300 ] 677 0.556% 99.389% ( 1300, 1900 ] 356 0.292% 99.681% ( 1900, 2900 ] 194 0.159% 99.841% ( 2900, 4400 ] 182 0.149% 99.990% ( 4400, 6600 ] 54 0.044% 100.034% ( 6600, 9900 ] 4 0.003% 100.038% ** Level 5 read latency histogram (micros): Count: 260 Average: 1174.7038 StdDev: 1331.88 Min: 61 Median: 600.0000 Max: 7796 Percentiles: P50: 600.00 P75: 1688.24 P99: 6208.89 P99.9: 7796.00 P99.99: 7796.00 ------------------------------------------------------ ( 51, 76 ] 2 0.769% 0.769% ( 76, 110 ] 15 5.769% 6.538% # ( 110, 170 ] 21 8.077% 14.615% ## ( 170, 250 ] 29 11.154% 25.769% ## ( 250, 380 ] 32 12.308% 38.077% ## ( 380, 580 ] 29 11.154% 49.231% ## ( 580, 870 ] 29 11.154% 60.385% ## ( 870, 1300 ] 27 10.385% 70.769% ## ( 1300, 1900 ] 17 6.538% 77.308% # ( 1900, 2900 ] 27 10.385% 87.692% ## ( 2900, 4400 ] 22 8.462% 96.154% ## ( 4400, 6600 ] 9 3.462% 99.615% # ( 6600, 9900 ] 1 0.385% 100.000% ** DB Stats ** Uptime(secs): 51.9 total, 3.4 interval Cumulative writes: 0 writes, 10M keys, 0 commit groups, 0.0 writes per commit group, ingest: 9.61 GB, 189.78 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:24.698 H:M:S, 47.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 292.32 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.626 H:M:S, 18.6 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 : 5.865 micros/op 170504 ops/sec 60.028 seconds 10234999 operations; 165.2 MB/s Microseconds per write: Count: 10234999 Average: 5.8649 StdDev: 316.61 Min: 0 Median: 1.7307 Max: 451433 Percentiles: P50: 1.73 P75: 2.76 P99: 8.86 P99.9: 1148.56 P99.99: 2647.75 ------------------------------------------------------ [ 0, 1 ] 1437602 14.046% 14.046% ### ( 1, 2 ] 5035834 49.202% 63.248% ########## ( 2, 3 ] 1583279 15.469% 78.717% ### ( 3, 4 ] 1422100 13.894% 92.612% ### ( 4, 6 ] 577318 5.641% 98.252% # ( 6, 10 ] 107195 1.047% 99.300% ( 10, 15 ] 28812 0.282% 99.581% ( 15, 22 ] 7956 0.078% 99.659% ( 22, 34 ] 1643 0.016% 99.675% ( 34, 51 ] 246 0.002% 99.677% ( 51, 76 ] 29 0.000% 99.678% ( 76, 110 ] 6605 0.065% 99.742% ( 110, 170 ] 3329 0.033% 99.775% ( 170, 250 ] 322 0.003% 99.778% ( 250, 380 ] 121 0.001% 99.779% ( 380, 580 ] 23 0.000% 99.779% ( 580, 870 ] 24 0.000% 99.780% ( 870, 1300 ] 19027 0.186% 99.965% ( 1300, 1900 ] 185 0.002% 99.967% ( 1900, 2900 ] 3110 0.030% 99.998% ( 2900, 4400 ] 166 0.002% 99.999% ( 4400, 6600 ] 34 0.000% 100.000% ( 6600, 9900 ] 13 0.000% 100.000% ( 9900, 14000 ] 4 0.000% 100.000% ( 14000, 22000 ] 1 0.000% 100.000% ( 22000, 33000 ] 1 0.000% 100.000% ( 33000, 50000 ] 1 0.000% 100.000% ( 170000, 250000 ] 18 0.000% 100.000% ( 380000, 570000 ] 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 : 191342 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 : 10234999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 10562518968 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 : 600 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 32031799 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 : 35738894255 rocksdb.compact.write.bytes COUNT : 35552394595 rocksdb.flush.write.bytes COUNT : 10503160587 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 : 60 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 : 350 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 : 10418478080 rocksdb.memtable.garbage.bytes.at.flush COUNT : 4049920 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 : 35837732424 rocksdb.non.last.level.read.count COUNT : 8660085 rocksdb.block.checksum.compute.count COUNT : 8658945 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.381798 P95 : 3.912272 P99 : 7.406925 P100 : 451412.000000 COUNT : 10234999 SUM : 55373632 rocksdb.compaction.times.micros P50 : 926969.696970 P95 : 4148333.333333 P99 : 15933425.000000 P100 : 15933425.000000 COUNT : 113 SUM : 156150996 rocksdb.compaction.times.cpu_micros P50 : 753666.666667 P95 : 3996666.666667 P99 : 15009734.000000 P100 : 15009734.000000 COUNT : 113 SUM : 132446267 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 : 708.707865 P95 : 1244.906250 P99 : 43030.000000 P100 : 72980.000000 COUNT : 141 SUM : 204742 rocksdb.compaction.outfile.sync.micros P50 : 1100.357143 P95 : 70694.444444 P99 : 138900.000000 P100 : 182128.000000 COUNT : 411 SUM : 4769526 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 : 108.411215 P95 : 1405.000000 P99 : 2510.000000 P100 : 4985.000000 COUNT : 278 SUM : 82910 rocksdb.table.open.io.micros P50 : 1387.272727 P95 : 7218.750000 P99 : 12718.750000 P100 : 19927.000000 COUNT : 600 SUM : 1210424 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.710931 P95 : 7.955402 P99 : 10.896595 P100 : 12356.000000 COUNT : 8657196 SUM : 52070499 rocksdb.read.block.get.micros P50 : 405.000000 P95 : 3363.636364 P99 : 5622.222222 P100 : 10410.000000 COUNT : 1200 SUM : 1004732 rocksdb.write.raw.block.micros P50 : 0.512322 P95 : 0.973413 P99 : 2.894035 P100 : 18020.000000 COUNT : 11154229 SUM : 21160038 rocksdb.numfiles.in.singlecompaction P50 : 3.030769 P95 : 5.500000 P99 : 20.250000 P100 : 23.000000 COUNT : 150 SUM : 525 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.557183 P95 : 1129.828538 P99 : 2255.671835 P100 : 451164.000000 COUNT : 220084 SUM : 32048704 rocksdb.sst.read.micros P50 : 1.644422 P95 : 4.805040 P99 : 8.424811 P100 : 12351.000000 COUNT : 8660262 SUM : 34152281 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 : 10234999 SUM : 10562518968 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 : 213809.523810 P95 : 379593.750000 P99 : 557016.666667 P100 : 642909.000000 COUNT : 141 SUM : 30221241 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 : 395 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