[2024-07-22 22:02:16.937561] Starting SPDK v24.09-pre git sha1 f7b31b2b9 / DPDK 24.07.0-rc2 initialization... [2024-07-22 22:02:16.937768] [ 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_pid1939651 ] Set seed to 1721678536933166 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-07-22 22:02:17.065424] pci_dpdk.c: 37:dpdk_pci_init: *NOTICE*: In-development DPDK 24.07.0-rc2 is used. There is no support for it in SPDK. Enabled only for validation. [2024-07-22 22:02:17.149019] app.c: 909:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-07-22 22:02:17.202328] app.c: 603:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-07-22 22:02:17.202388] app.c: 604:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 1939651' to capture a snapshot of events at runtime. [2024-07-22 22:02:17.202410] app.c: 609:app_setup_trace: *NOTICE*: 'spdk_trace' without parameters will also work if this is the only [2024-07-22 22:02:17.202427] app.c: 610:app_setup_trace: *NOTICE*: SPDK application currently running. [2024-07-22 22:02:17.202446] app.c: 611:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid1939651 for offline analysis/debug. [2024-07-22 22:02:17.202576] reactor.c: 941:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Mon Jul 22 22:02:21 2024 CPU: 72 * Intel(R) Xeon(R) Gold 6140 CPU @ 2.30GHz CPUCache: 25344 KB 2024/07/22-22:02:30 ... thread 0: (1000000,1000000) ops and (121018.6,121018.6) ops/second in (8.263191,8.263191) 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 7/4 441.00 MB 18.9 0.0 0.0 0.0 0.9 0.9 0.0 1.0 0.0 154.9 5.69 5.27 14 0.407 0 0 0.0 0.0 L1 3/3 174.06 MB 0.0 0.4 0.2 0.1 0.4 0.2 0.2 1.5 192.4 192.3 1.96 1.89 2 0.982 383K 261 0.0 0.0 L2 10/0 266.43 MB 2.7 0.4 0.2 0.2 0.4 0.2 0.2 2.2 186.0 185.9 2.42 2.31 3 0.808 457K 224 0.0 0.0 L3 13/0 930.24 MB 0.9 0.0 0.0 0.0 0.0 0.0 0.1 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 140/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 1328/0 85.63 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 1501/7 97.00 GB 0.0 0.8 0.4 0.4 1.7 1.3 0.5 1.9 82.2 169.6 10.08 9.47 19 0.531 841K 485 0.0 0.0 Int 0/0 0.00 KB 0.0 0.8 0.4 0.4 1.7 1.3 0.5 1.9 82.2 169.6 10.08 9.47 19 0.531 841K 485 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.8 0.4 0.4 0.8 0.4 0.0 0.0 188.9 188.8 4.39 4.20 5 0.878 841K 485 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 154.9 5.69 5.27 14 0.407 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 8.6 total, 8.3 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.67 GB write, 199.16 MB/s write, 0.81 GB read, 96.52 MB/s read, 10.1 seconds Interval compaction: 1.67 GB write, 206.92 MB/s write, 0.81 GB read, 100.28 MB/s read, 10.1 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 0, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 0, ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 158138 Average: 2.3059 StdDev: 16.47 Min: 1 Median: 1.5575 Max: 4047 Percentiles: P50: 1.56 P75: 1.86 P99: 4.63 P99.9: 10.87 P99.99: 469.83 ------------------------------------------------------ [ 0, 1 ] 6376 4.032% 4.032% # ( 1, 2 ] 130392 82.455% 86.486% ################ ( 2, 3 ] 16348 10.338% 96.824% ## ( 3, 4 ] 3040 1.922% 98.747% ( 4, 6 ] 1277 0.808% 99.554% ( 6, 10 ] 529 0.335% 99.889% ( 10, 15 ] 131 0.083% 99.972% ( 15, 22 ] 13 0.008% 99.980% ( 22, 34 ] 4 0.003% 99.982% ( 34, 51 ] 3 0.002% 99.984% ( 51, 76 ] 2 0.001% 99.985% ( 250, 380 ] 5 0.003% 99.989% ( 380, 580 ] 16 0.010% 99.999% ( 580, 870 ] 3 0.002% 100.001% ( 1300, 1900 ] 1 0.001% 100.001% ( 1900, 2900 ] 1 0.001% 100.002% ( 2900, 4400 ] 2 0.001% 100.003% ** Level 1 read latency histogram (micros): Count: 95311 Average: 2.2885 StdDev: 16.29 Min: 1 Median: 1.5653 Max: 4422 Percentiles: P50: 1.57 P75: 1.87 P99: 4.48 P99.9: 10.31 P99.99: 270.32 ------------------------------------------------------ [ 0, 1 ] 3342 3.506% 3.506% # ( 1, 2 ] 78393 82.250% 85.756% ################ ( 2, 3 ] 10822 11.354% 97.111% ## ( 3, 4 ] 1607 1.686% 98.797% ( 4, 6 ] 813 0.853% 99.650% ( 6, 10 ] 234 0.246% 99.895% ( 10, 15 ] 76 0.080% 99.975% ( 15, 22 ] 6 0.006% 99.981% ( 51, 76 ] 2 0.002% 99.983% ( 76, 110 ] 1 0.001% 99.984% ( 170, 250 ] 5 0.005% 99.990% ( 250, 380 ] 3 0.003% 99.993% ( 380, 580 ] 1 0.001% 99.994% ( 580, 870 ] 2 0.002% 99.996% ( 870, 1300 ] 2 0.002% 99.998% ( 1300, 1900 ] 1 0.001% 99.999% ( 4400, 6600 ] 1 0.001% 100.000% ** Level 2 read latency histogram (micros): Count: 46846 Average: 2.2421 StdDev: 7.43 Min: 0 Median: 1.5584 Max: 991 Percentiles: P50: 1.56 P75: 1.86 P99: 4.36 P99.9: 9.95 P99.99: 401.03 ------------------------------------------------------ [ 0, 1 ] 2006 4.282% 4.282% # ( 1, 2 ] 38355 81.875% 86.157% ################ ( 2, 3 ] 5175 11.047% 97.204% ## ( 3, 4 ] 782 1.669% 98.873% ( 4, 6 ] 333 0.711% 99.584% ( 6, 10 ] 150 0.320% 99.904% ( 10, 15 ] 33 0.070% 99.974% ( 15, 22 ] 2 0.004% 99.979% ( 22, 34 ] 1 0.002% 99.981% ( 170, 250 ] 2 0.004% 99.985% ( 250, 380 ] 2 0.004% 99.989% ( 380, 580 ] 3 0.006% 99.996% ( 580, 870 ] 1 0.002% 99.998% ( 870, 1300 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 60 Average: 1759.5000 StdDev: 1097.20 Min: 134 Median: 1660.0000 Max: 4611 Percentiles: P50: 1660.00 P75: 2547.06 P99: 4611.00 P99.9: 4611.00 P99.99: 4611.00 ------------------------------------------------------ ( 110, 170 ] 1 1.667% 1.667% ( 170, 250 ] 2 3.333% 5.000% # ( 250, 380 ] 2 3.333% 8.333% # ( 380, 580 ] 5 8.333% 16.667% ## ( 580, 870 ] 4 6.667% 23.333% # ( 870, 1300 ] 10 16.667% 40.000% ### ( 1300, 1900 ] 10 16.667% 56.667% ### ( 1900, 2900 ] 17 28.333% 85.000% ###### ( 2900, 4400 ] 8 13.333% 98.333% ### ( 4400, 6600 ] 1 1.667% 100.000% ** Level 4 read latency histogram (micros): Count: 15 Average: 2051.0000 StdDev: 1095.58 Min: 156 Median: 2025.0000 Max: 4298 Percentiles: P50: 2025.00 P75: 2993.75 P99: 4298.00 P99.9: 4298.00 P99.99: 4298.00 ------------------------------------------------------ ( 110, 170 ] 1 6.667% 6.667% # ( 250, 380 ] 1 6.667% 13.333% # ( 870, 1300 ] 1 6.667% 20.000% # ( 1300, 1900 ] 4 26.667% 46.667% ##### ( 1900, 2900 ] 4 26.667% 73.333% ##### ( 2900, 4400 ] 4 26.667% 100.000% ##### ** DB Stats ** Uptime(secs): 8.6 total, 8.3 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 114.59 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.000 H:M:S, 0.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 119.05 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.000 H:M:S, 0.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/07/22-22:02:38 ... thread 0: (1000000,2000000) ops and (121902.1,121458.8) ops/second in (8.203303,16.466494) 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/8 1.17 GB 50.3 0.7 0.0 0.7 2.6 1.8 0.0 1.4 52.1 182.4 14.51 13.60 33 0.440 767K 742 0.0 0.0 L1 5/5 425.32 MB 0.0 0.8 0.5 0.3 0.8 0.5 0.2 1.6 184.3 184.1 4.36 4.23 3 1.454 816K 964 0.0 0.0 L2 6/0 31.76 MB 0.3 0.4 0.2 0.2 0.4 0.2 0.2 2.2 186.0 185.9 2.42 2.31 3 0.808 457K 224 0.0 0.0 L3 15/0 944.37 MB 0.9 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 192/0 9.57 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.0 1.0 112.7 112.7 1.96 1.55 1 1.957 223K 0 0.0 0.0 L5 1332/0 85.88 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.2 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1560/13 97.98 GB 0.0 2.2 0.9 1.3 4.0 2.8 0.9 2.2 96.0 177.2 23.25 21.69 40 0.581 2265K 1930 0.0 0.0 Int 0/0 0.00 KB 0.0 2.2 0.9 1.3 4.0 2.8 0.9 2.2 96.0 177.2 23.25 21.69 40 0.581 2265K 1930 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 2.2 0.9 1.3 2.2 0.9 0.0 0.0 180.5 180.4 12.36 11.63 10 1.236 2265K 1930 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 173.6 10.89 10.05 30 0.363 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): 16.8 total, 16.5 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: 4.02 GB write, 245.34 MB/s write, 2.18 GB read, 132.90 MB/s read, 23.2 seconds Interval compaction: 4.02 GB write, 250.14 MB/s write, 2.18 GB read, 135.50 MB/s read, 23.2 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 0, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 0, ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 453089 Average: 2.9701 StdDev: 15.27 Min: 1 Median: 1.8588 Max: 4047 Percentiles: P50: 1.86 P75: 2.91 P99: 8.73 P99.9: 15.92 P99.99: 29.01 ------------------------------------------------------ [ 0, 1 ] 9726 2.147% 2.147% ( 1, 2 ] 252471 55.722% 57.869% ########### ( 2, 3 ] 84960 18.751% 76.620% #### ( 3, 4 ] 60372 13.325% 89.945% ### ( 4, 6 ] 35396 7.812% 97.757% ## ( 6, 10 ] 8247 1.820% 99.577% ( 10, 15 ] 1416 0.313% 99.889% ( 15, 22 ] 380 0.084% 99.973% ( 22, 34 ] 133 0.029% 100.003% ( 34, 51 ] 13 0.003% 100.006% ( 51, 76 ] 7 0.002% 100.007% ( 76, 110 ] 1 0.000% 100.007% ( 110, 170 ] 1 0.000% 100.008% ( 170, 250 ] 2 0.000% 100.008% ( 250, 380 ] 17 0.004% 100.012% ( 380, 580 ] 26 0.006% 100.017% ( 580, 870 ] 6 0.001% 100.019% ( 870, 1300 ] 4 0.001% 100.020% ( 1300, 1900 ] 3 0.001% 100.020% ( 1900, 2900 ] 2 0.000% 100.021% ( 2900, 4400 ] 6 0.001% 100.022% ** Level 1 read latency histogram (micros): Count: 180318 Average: 3.4042 StdDev: 12.91 Min: 1 Median: 2.5135 Max: 4422 Percentiles: P50: 2.51 P75: 3.69 P99: 9.55 P99.9: 20.83 P99.99: 238.21 ------------------------------------------------------ [ 0, 1 ] 3357 1.862% 1.862% ( 1, 2 ] 78740 43.667% 45.529% ######### ( 2, 3 ] 15699 8.706% 54.235% ## ( 3, 4 ] 54197 30.056% 84.292% ###### ( 4, 6 ] 21908 12.150% 96.441% ## ( 6, 10 ] 5195 2.881% 99.322% # ( 10, 15 ] 831 0.461% 99.783% ( 15, 22 ] 253 0.140% 99.923% ( 22, 34 ] 105 0.058% 99.982% ( 34, 51 ] 4 0.002% 99.984% ( 51, 76 ] 3 0.002% 99.986% ( 76, 110 ] 1 0.001% 99.986% ( 110, 170 ] 1 0.001% 99.987% ( 170, 250 ] 7 0.004% 99.991% ( 250, 380 ] 3 0.002% 99.992% ( 380, 580 ] 3 0.002% 99.994% ( 580, 870 ] 5 0.003% 99.997% ( 870, 1300 ] 3 0.002% 99.998% ( 1300, 1900 ] 2 0.001% 99.999% ( 4400, 6600 ] 1 0.001% 100.000% ** Level 2 read latency histogram (micros): Count: 102835 Average: 2.7047 StdDev: 5.12 Min: 0 Median: 1.9446 Max: 991 Percentiles: P50: 1.94 P75: 2.59 P99: 7.64 P99.9: 14.24 P99.99: 48.59 ------------------------------------------------------ [ 0, 1 ] 2006 1.951% 1.951% ( 1, 2 ] 52307 50.865% 52.816% ########## ( 2, 3 ] 38737 37.669% 90.485% ######## ( 3, 4 ] 5148 5.006% 95.491% # ( 4, 6 ] 3108 3.022% 98.513% # ( 6, 10 ] 1222 1.188% 99.701% ( 10, 15 ] 241 0.234% 99.936% ( 15, 22 ] 50 0.049% 99.984% ( 22, 34 ] 4 0.004% 99.988% ( 34, 51 ] 2 0.002% 99.990% ( 51, 76 ] 1 0.001% 99.991% ( 170, 250 ] 2 0.002% 99.993% ( 250, 380 ] 2 0.002% 99.995% ( 380, 580 ] 3 0.003% 99.998% ( 580, 870 ] 1 0.001% 99.999% ( 870, 1300 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 60 Average: 1759.5000 StdDev: 1097.20 Min: 134 Median: 1660.0000 Max: 4611 Percentiles: P50: 1660.00 P75: 2547.06 P99: 4611.00 P99.9: 4611.00 P99.99: 4611.00 ------------------------------------------------------ ( 110, 170 ] 1 1.667% 1.667% ( 170, 250 ] 2 3.333% 5.000% # ( 250, 380 ] 2 3.333% 8.333% # ( 380, 580 ] 5 8.333% 16.667% ## ( 580, 870 ] 4 6.667% 23.333% # ( 870, 1300 ] 10 16.667% 40.000% ### ( 1300, 1900 ] 10 16.667% 56.667% ### ( 1900, 2900 ] 17 28.333% 85.000% ###### ( 2900, 4400 ] 8 13.333% 98.333% ### ( 4400, 6600 ] 1 1.667% 100.000% ** Level 4 read latency histogram (micros): Count: 295 Average: 114.8169 StdDev: 513.77 Min: 1 Median: 1.7746 Max: 4298 Percentiles: P50: 1.77 P75: 8.33 P99: 3293.75 P99.9: 4289.38 P99.99: 4298.00 ------------------------------------------------------ [ 0, 1 ] 53 17.966% 17.966% #### ( 1, 2 ] 122 41.356% 59.322% ######## ( 2, 3 ] 32 10.847% 70.169% ## ( 3, 4 ] 5 1.695% 71.864% ( 4, 6 ] 4 1.356% 73.220% ( 6, 10 ] 9 3.051% 76.271% # ( 10, 15 ] 39 13.220% 89.492% ### ( 15, 22 ] 1 0.339% 89.831% ( 22, 34 ] 3 1.017% 90.847% ( 34, 51 ] 6 2.034% 92.881% ( 110, 170 ] 1 0.339% 93.220% ( 170, 250 ] 4 1.356% 94.576% ( 250, 380 ] 1 0.339% 94.915% ( 380, 580 ] 2 0.678% 95.593% ( 870, 1300 ] 1 0.339% 95.932% ( 1300, 1900 ] 4 1.356% 97.288% ( 1900, 2900 ] 4 1.356% 98.644% ( 2900, 4400 ] 4 1.356% 100.000% ** Level 5 read latency histogram (micros): Count: 20 Average: 703.4000 StdDev: 936.55 Min: 120 Median: 196.6667 Max: 3057 Percentiles: P50: 196.67 P75: 725.00 P99: 3057.00 P99.9: 3057.00 P99.99: 3057.00 ------------------------------------------------------ ( 110, 170 ] 9 45.000% 45.000% ######### ( 170, 250 ] 3 15.000% 60.000% ### ( 250, 380 ] 1 5.000% 65.000% # ( 380, 580 ] 1 5.000% 70.000% # ( 580, 870 ] 2 10.000% 80.000% ## ( 1900, 2900 ] 3 15.000% 95.000% ### ( 2900, 4400 ] 1 5.000% 100.000% # ** DB Stats ** Uptime(secs): 16.8 total, 8.2 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 117.22 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.000 H:M:S, 0.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 119.97 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.000 H:M:S, 0.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/07/22-22:02:46 ... thread 0: (1000000,3000000) ops and (121722.2,121546.5) ops/second in (8.215428,24.681922) 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 1.72 GB 62.9 1.7 0.0 1.7 4.6 2.8 0.0 1.6 68.6 181.1 25.73 24.15 53 0.485 1791K 1701 0.0 0.0 L1 4/4 348.31 MB 0.0 1.6 0.9 0.7 1.6 0.9 0.2 1.8 124.0 123.7 13.47 13.08 4 3.369 1695K 3553 0.0 0.0 L2 6/0 31.76 MB 0.3 0.4 0.2 0.2 0.4 0.2 0.7 2.2 186.0 185.9 2.42 2.31 3 0.808 457K 224 0.0 0.0 L3 11/0 892.54 MB 0.9 0.0 0.0 0.0 0.0 0.0 0.8 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 192/0 9.63 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.6 1.0 112.7 112.7 1.96 1.55 1 1.957 223K 0 0.0 0.0 L5 1340/0 86.37 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1563/10 98.96 GB 0.0 4.0 1.3 2.7 6.8 4.2 3.0 2.4 94.2 160.6 43.58 41.08 61 0.714 4168K 5478 0.0 0.0 Int 0/0 0.00 KB 0.0 4.0 1.3 2.7 6.8 4.2 3.0 2.4 94.2 160.6 43.58 41.08 61 0.714 4168K 5478 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 4.0 1.3 2.7 4.0 1.3 0.0 0.0 142.7 142.5 28.76 27.51 15 1.917 4168K 5478 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 195.5 14.82 13.58 46 0.322 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 25.0 total, 24.7 interval Flush(GB): cumulative 2.830, interval 2.830 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 6.83 GB write, 279.84 MB/s write, 4.01 GB read, 164.18 MB/s read, 43.6 seconds Interval compaction: 6.83 GB write, 283.49 MB/s write, 4.01 GB read, 166.32 MB/s read, 43.6 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 0, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 0, ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 859095 Average: 3.6228 StdDev: 12.68 Min: 1 Median: 2.7419 Max: 4047 Percentiles: P50: 2.74 P75: 3.92 P99: 9.94 P99.9: 20.04 P99.99: 29.32 ------------------------------------------------------ [ 0, 1 ] 10695 1.245% 1.245% ( 1, 2 ] 309638 36.042% 37.287% ####### ( 2, 3 ] 147214 17.136% 54.423% ### ( 3, 4 ] 193090 22.476% 76.899% #### ( 4, 6 ] 160802 18.718% 95.617% #### ( 6, 10 ] 29533 3.438% 99.054% # ( 10, 15 ] 6190 0.721% 99.775% ( 15, 22 ] 1493 0.174% 99.949% ( 22, 34 ] 582 0.068% 100.017% ( 34, 51 ] 36 0.004% 100.021% ( 51, 76 ] 13 0.002% 100.022% ( 76, 110 ] 4 0.000% 100.023% ( 110, 170 ] 4 0.000% 100.023% ( 170, 250 ] 3 0.000% 100.024% ( 250, 380 ] 38 0.004% 100.028% ( 380, 580 ] 33 0.004% 100.032% ( 580, 870 ] 11 0.001% 100.033% ( 870, 1300 ] 6 0.001% 100.034% ( 1300, 1900 ] 4 0.000% 100.034% ( 1900, 2900 ] 4 0.000% 100.035% ( 2900, 4400 ] 7 0.001% 100.036% ** Level 1 read latency histogram (micros): Count: 203968 Average: 3.6668 StdDev: 14.58 Min: 1 Median: 3.0591 Max: 4422 Percentiles: P50: 3.06 P75: 3.87 P99: 9.83 P99.9: 21.79 P99.99: 674.37 ------------------------------------------------------ [ 0, 1 ] 3357 1.646% 1.646% ( 1, 2 ] 78745 38.607% 40.252% ######## ( 2, 3 ] 16145 7.915% 48.168% ## ( 3, 4 ] 63200 30.985% 79.153% ###### ( 4, 6 ] 33767 16.555% 95.708% ### ( 6, 10 ] 7006 3.435% 99.143% # ( 10, 15 ] 1223 0.600% 99.743% ( 15, 22 ] 331 0.162% 99.905% ( 22, 34 ] 142 0.070% 99.975% ( 34, 51 ] 5 0.002% 99.977% ( 51, 76 ] 4 0.002% 99.979% ( 76, 110 ] 1 0.000% 99.979% ( 110, 170 ] 2 0.001% 99.980% ( 170, 250 ] 8 0.004% 99.984% ( 250, 380 ] 4 0.002% 99.986% ( 380, 580 ] 5 0.002% 99.989% ( 580, 870 ] 8 0.004% 99.993% ( 870, 1300 ] 12 0.006% 99.999% ( 1300, 1900 ] 2 0.001% 100.000% ( 4400, 6600 ] 1 0.000% 100.000% ** Level 2 read latency histogram (micros): Count: 102835 Average: 2.7047 StdDev: 5.12 Min: 0 Median: 1.9446 Max: 991 Percentiles: P50: 1.94 P75: 2.59 P99: 7.64 P99.9: 14.24 P99.99: 48.59 ------------------------------------------------------ [ 0, 1 ] 2006 1.951% 1.951% ( 1, 2 ] 52307 50.865% 52.816% ########## ( 2, 3 ] 38737 37.669% 90.485% ######## ( 3, 4 ] 5148 5.006% 95.491% # ( 4, 6 ] 3108 3.022% 98.513% # ( 6, 10 ] 1222 1.188% 99.701% ( 10, 15 ] 241 0.234% 99.936% ( 15, 22 ] 50 0.049% 99.984% ( 22, 34 ] 4 0.004% 99.988% ( 34, 51 ] 2 0.002% 99.990% ( 51, 76 ] 1 0.001% 99.991% ( 170, 250 ] 2 0.002% 99.993% ( 250, 380 ] 2 0.002% 99.995% ( 380, 580 ] 3 0.003% 99.998% ( 580, 870 ] 1 0.001% 99.999% ( 870, 1300 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 60 Average: 1759.5000 StdDev: 1097.20 Min: 134 Median: 1660.0000 Max: 4611 Percentiles: P50: 1660.00 P75: 2547.06 P99: 4611.00 P99.9: 4611.00 P99.99: 4611.00 ------------------------------------------------------ ( 110, 170 ] 1 1.667% 1.667% ( 170, 250 ] 2 3.333% 5.000% # ( 250, 380 ] 2 3.333% 8.333% # ( 380, 580 ] 5 8.333% 16.667% ## ( 580, 870 ] 4 6.667% 23.333% # ( 870, 1300 ] 10 16.667% 40.000% ### ( 1300, 1900 ] 10 16.667% 56.667% ### ( 1900, 2900 ] 17 28.333% 85.000% ###### ( 2900, 4400 ] 8 13.333% 98.333% ### ( 4400, 6600 ] 1 1.667% 100.000% ** Level 4 read latency histogram (micros): Count: 295 Average: 114.8169 StdDev: 513.77 Min: 1 Median: 1.7746 Max: 4298 Percentiles: P50: 1.77 P75: 8.33 P99: 3293.75 P99.9: 4289.38 P99.99: 4298.00 ------------------------------------------------------ [ 0, 1 ] 53 17.966% 17.966% #### ( 1, 2 ] 122 41.356% 59.322% ######## ( 2, 3 ] 32 10.847% 70.169% ## ( 3, 4 ] 5 1.695% 71.864% ( 4, 6 ] 4 1.356% 73.220% ( 6, 10 ] 9 3.051% 76.271% # ( 10, 15 ] 39 13.220% 89.492% ### ( 15, 22 ] 1 0.339% 89.831% ( 22, 34 ] 3 1.017% 90.847% ( 34, 51 ] 6 2.034% 92.881% ( 110, 170 ] 1 0.339% 93.220% ( 170, 250 ] 4 1.356% 94.576% ( 250, 380 ] 1 0.339% 94.915% ( 380, 580 ] 2 0.678% 95.593% ( 870, 1300 ] 1 0.339% 95.932% ( 1300, 1900 ] 4 1.356% 97.288% ( 1900, 2900 ] 4 1.356% 98.644% ( 2900, 4400 ] 4 1.356% 100.000% ** Level 5 read latency histogram (micros): Count: 60 Average: 734.9167 StdDev: 995.92 Min: 98 Median: 170.0000 Max: 3611 Percentiles: P50: 170.00 P75: 787.14 P99: 3611.00 P99.9: 3611.00 P99.99: 3611.00 ------------------------------------------------------ ( 76, 110 ] 4 6.667% 6.667% # ( 110, 170 ] 26 43.333% 50.000% ######### ( 170, 250 ] 5 8.333% 58.333% ## ( 250, 380 ] 3 5.000% 63.333% # ( 380, 580 ] 2 3.333% 66.667% # ( 580, 870 ] 7 11.667% 78.333% ## ( 870, 1300 ] 1 1.667% 80.000% ( 1300, 1900 ] 2 3.333% 83.333% # ( 1900, 2900 ] 6 10.000% 93.333% ## ( 2900, 4400 ] 4 6.667% 100.000% # ** DB Stats ** Uptime(secs): 25.0 total, 8.2 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 118.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:0.000 H:M:S, 0.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 119.80 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.000 H:M:S, 0.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 0 2024/07/22-22:02:54 ... thread 0: (1000000,4000000) ops and (121950.5,121647.2) ops/second in (8.200048,32.881970) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 16/10 2.64 GB 132.2 2.5 0.0 2.5 6.2 3.8 0.0 1.7 71.8 181.3 35.08 32.98 71 0.494 2558K 2441 0.0 0.0 L1 4/4 348.31 MB 0.0 1.6 0.9 0.7 1.6 0.9 0.2 1.8 124.0 123.7 13.47 13.08 4 3.369 1695K 3553 0.0 0.0 L2 6/0 31.76 MB 0.3 0.4 0.2 0.2 0.4 0.2 0.7 2.2 186.0 185.9 2.42 2.31 3 0.808 457K 224 0.0 0.0 L3 11/0 892.54 MB 0.9 0.0 0.0 0.0 0.0 0.0 0.8 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 192/0 9.63 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.6 1.0 112.7 112.7 1.96 1.55 1 1.957 223K 0 0.0 0.0 L5 1340/0 86.37 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1569/14 99.88 GB 0.0 4.7 1.3 3.4 8.5 5.1 3.0 2.3 91.8 164.3 52.93 49.92 79 0.670 4936K 6218 0.0 0.0 Int 0/0 0.00 KB 0.0 4.7 1.3 3.4 8.5 5.1 3.0 2.3 91.8 164.3 52.93 49.92 79 0.670 4936K 6218 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 4.7 1.3 3.4 4.7 1.3 0.0 0.0 149.1 148.9 32.62 31.26 18 1.812 4936K 6218 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 189.2 20.32 18.66 61 0.333 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.2 total, 32.9 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.49 GB write, 261.94 MB/s write, 4.75 GB read, 146.41 MB/s read, 52.9 seconds Interval compaction: 8.49 GB write, 264.51 MB/s write, 4.75 GB read, 147.84 MB/s read, 52.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: 0, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 0, ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1225570 Average: 3.6102 StdDev: 13.36 Min: 1 Median: 2.7227 Max: 4168 Percentiles: P50: 2.72 P75: 3.85 P99: 9.76 P99.9: 19.10 P99.99: 27.40 ------------------------------------------------------ [ 0, 1 ] 13209 1.078% 1.078% ( 1, 2 ] 424244 34.616% 35.694% ####### ( 2, 3 ] 242604 19.795% 55.489% #### ( 3, 4 ] 280615 22.897% 78.386% ##### ( 4, 6 ] 212768 17.361% 95.746% ### ( 6, 10 ] 42440 3.463% 99.209% # ( 10, 15 ] 7377 0.602% 99.811% ( 15, 22 ] 1866 0.152% 99.964% ( 22, 34 ] 732 0.060% 100.023% ( 34, 51 ] 50 0.004% 100.027% ( 51, 76 ] 17 0.001% 100.029% ( 76, 110 ] 12 0.001% 100.030% ( 110, 170 ] 30 0.002% 100.032% ( 170, 250 ] 12 0.001% 100.033% ( 250, 380 ] 46 0.004% 100.037% ( 380, 580 ] 48 0.004% 100.041% ( 580, 870 ] 20 0.002% 100.042% ( 870, 1300 ] 9 0.001% 100.043% ( 1300, 1900 ] 6 0.000% 100.044% ( 1900, 2900 ] 5 0.000% 100.044% ( 2900, 4400 ] 12 0.001% 100.045% ** Level 1 read latency histogram (micros): Count: 271073 Average: 3.9300 StdDev: 12.68 Min: 1 Median: 3.3439 Max: 4422 Percentiles: P50: 3.34 P75: 4.06 P99: 9.92 P99.9: 21.96 P99.99: 415.71 ------------------------------------------------------ [ 0, 1 ] 3357 1.238% 1.238% ( 1, 2 ] 78748 29.050% 30.289% ###### ( 2, 3 ] 18718 6.905% 37.194% # ( 3, 4 ] 100943 37.238% 74.432% ####### ( 4, 6 ] 54890 20.249% 94.682% #### ( 6, 10 ] 11945 4.407% 99.088% # ( 10, 15 ] 1710 0.631% 99.719% ( 15, 22 ] 494 0.182% 99.901% ( 22, 34 ] 212 0.078% 99.979% ( 34, 51 ] 8 0.003% 99.982% ( 51, 76 ] 5 0.002% 99.984% ( 76, 110 ] 1 0.000% 99.985% ( 110, 170 ] 2 0.001% 99.985% ( 170, 250 ] 8 0.003% 99.988% ( 250, 380 ] 4 0.001% 99.990% ( 380, 580 ] 5 0.002% 99.992% ( 580, 870 ] 8 0.003% 99.994% ( 870, 1300 ] 12 0.004% 99.999% ( 1300, 1900 ] 2 0.001% 100.000% ( 4400, 6600 ] 1 0.000% 100.000% ** Level 2 read latency histogram (micros): Count: 102835 Average: 2.7047 StdDev: 5.12 Min: 0 Median: 1.9446 Max: 991 Percentiles: P50: 1.94 P75: 2.59 P99: 7.64 P99.9: 14.24 P99.99: 48.59 ------------------------------------------------------ [ 0, 1 ] 2006 1.951% 1.951% ( 1, 2 ] 52307 50.865% 52.816% ########## ( 2, 3 ] 38737 37.669% 90.485% ######## ( 3, 4 ] 5148 5.006% 95.491% # ( 4, 6 ] 3108 3.022% 98.513% # ( 6, 10 ] 1222 1.188% 99.701% ( 10, 15 ] 241 0.234% 99.936% ( 15, 22 ] 50 0.049% 99.984% ( 22, 34 ] 4 0.004% 99.988% ( 34, 51 ] 2 0.002% 99.990% ( 51, 76 ] 1 0.001% 99.991% ( 170, 250 ] 2 0.002% 99.993% ( 250, 380 ] 2 0.002% 99.995% ( 380, 580 ] 3 0.003% 99.998% ( 580, 870 ] 1 0.001% 99.999% ( 870, 1300 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 60 Average: 1759.5000 StdDev: 1097.20 Min: 134 Median: 1660.0000 Max: 4611 Percentiles: P50: 1660.00 P75: 2547.06 P99: 4611.00 P99.9: 4611.00 P99.99: 4611.00 ------------------------------------------------------ ( 110, 170 ] 1 1.667% 1.667% ( 170, 250 ] 2 3.333% 5.000% # ( 250, 380 ] 2 3.333% 8.333% # ( 380, 580 ] 5 8.333% 16.667% ## ( 580, 870 ] 4 6.667% 23.333% # ( 870, 1300 ] 10 16.667% 40.000% ### ( 1300, 1900 ] 10 16.667% 56.667% ### ( 1900, 2900 ] 17 28.333% 85.000% ###### ( 2900, 4400 ] 8 13.333% 98.333% ### ( 4400, 6600 ] 1 1.667% 100.000% ** Level 4 read latency histogram (micros): Count: 295 Average: 114.8169 StdDev: 513.77 Min: 1 Median: 1.7746 Max: 4298 Percentiles: P50: 1.77 P75: 8.33 P99: 3293.75 P99.9: 4289.38 P99.99: 4298.00 ------------------------------------------------------ [ 0, 1 ] 53 17.966% 17.966% #### ( 1, 2 ] 122 41.356% 59.322% ######## ( 2, 3 ] 32 10.847% 70.169% ## ( 3, 4 ] 5 1.695% 71.864% ( 4, 6 ] 4 1.356% 73.220% ( 6, 10 ] 9 3.051% 76.271% # ( 10, 15 ] 39 13.220% 89.492% ### ( 15, 22 ] 1 0.339% 89.831% ( 22, 34 ] 3 1.017% 90.847% ( 34, 51 ] 6 2.034% 92.881% ( 110, 170 ] 1 0.339% 93.220% ( 170, 250 ] 4 1.356% 94.576% ( 250, 380 ] 1 0.339% 94.915% ( 380, 580 ] 2 0.678% 95.593% ( 870, 1300 ] 1 0.339% 95.932% ( 1300, 1900 ] 4 1.356% 97.288% ( 1900, 2900 ] 4 1.356% 98.644% ( 2900, 4400 ] 4 1.356% 100.000% ** Level 5 read latency histogram (micros): Count: 60 Average: 734.9167 StdDev: 995.92 Min: 98 Median: 170.0000 Max: 3611 Percentiles: P50: 170.00 P75: 787.14 P99: 3611.00 P99.9: 3611.00 P99.99: 3611.00 ------------------------------------------------------ ( 76, 110 ] 4 6.667% 6.667% # ( 110, 170 ] 26 43.333% 50.000% ######### ( 170, 250 ] 5 8.333% 58.333% ## ( 250, 380 ] 3 5.000% 63.333% # ( 380, 580 ] 2 3.333% 66.667% # ( 580, 870 ] 7 11.667% 78.333% ## ( 870, 1300 ] 1 1.667% 80.000% ( 1300, 1900 ] 2 3.333% 83.333% # ( 1900, 2900 ] 6 10.000% 93.333% ## ( 2900, 4400 ] 4 6.667% 100.000% # ** DB Stats ** Uptime(secs): 33.2 total, 8.2 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 118.55 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:0.000 H:M:S, 0.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 120.02 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.000 H:M:S, 0.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/07/22-22:03:02 ... thread 0: (1000000,5000000) ops and (121485.5,121614.8) ops/second in (8.231438,41.113408) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 14/9 2.52 GB 69.2 3.4 0.0 3.4 8.2 4.7 0.0 1.7 77.2 183.3 45.70 43.08 91 0.502 3582K 3383 0.0 0.0 L1 14/14 1.44 GB 0.0 3.1 2.0 1.0 3.1 2.0 0.2 1.5 108.1 107.6 29.17 28.33 5 5.833 3200K 12K 0.0 0.0 L2 6/0 31.76 MB 0.3 0.4 0.2 0.2 0.4 0.2 0.7 2.2 186.0 185.9 2.42 2.31 3 0.808 457K 224 0.0 0.0 L3 11/0 892.54 MB 0.9 0.0 0.0 0.0 0.0 0.0 0.8 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 192/0 9.63 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.6 1.0 112.7 112.7 1.96 1.55 1 1.957 223K 0 0.0 0.0 L5 1340/0 86.37 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1577/23 100.86 GB 0.0 7.2 2.4 4.7 11.9 7.2 3.0 2.5 92.8 153.8 79.24 75.27 100 0.792 7464K 16K 0.0 0.0 Int 0/0 0.00 KB 0.0 7.2 2.4 4.7 11.9 7.2 3.0 2.5 92.8 153.8 79.24 75.27 100 0.792 7464K 16K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 7.2 2.4 4.7 7.2 2.4 0.0 0.0 135.2 134.9 54.35 52.44 23 2.363 7464K 16K 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 194.9 24.89 22.83 77 0.323 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): 41.4 total, 41.1 interval Flush(GB): cumulative 4.737, interval 4.737 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 11.90 GB write, 294.06 MB/s write, 7.18 GB read, 177.39 MB/s read, 79.2 seconds Interval compaction: 11.90 GB write, 296.36 MB/s write, 7.18 GB read, 178.78 MB/s read, 79.2 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 0, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 0, ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1621344 Average: 3.6030 StdDev: 13.46 Min: 1 Median: 2.6460 Max: 4168 Percentiles: P50: 2.65 P75: 3.79 P99: 9.70 P99.9: 19.31 P99.99: 29.63 ------------------------------------------------------ [ 0, 1 ] 14789 0.912% 0.912% ( 1, 2 ] 549764 33.908% 34.820% ####### ( 2, 3 ] 380998 23.499% 58.319% ##### ( 3, 4 ] 342007 21.094% 79.413% #### ( 4, 6 ] 267656 16.508% 95.921% ### ( 6, 10 ] 54018 3.332% 99.253% # ( 10, 15 ] 9033 0.557% 99.810% ( 15, 22 ] 2366 0.146% 99.956% ( 22, 34 ] 866 0.053% 100.009% ( 34, 51 ] 56 0.003% 100.013% ( 51, 76 ] 23 0.001% 100.014% ( 76, 110 ] 62 0.004% 100.018% ( 110, 170 ] 179 0.011% 100.029% ( 170, 250 ] 52 0.003% 100.032% ( 250, 380 ] 89 0.005% 100.038% ( 380, 580 ] 76 0.005% 100.043% ( 580, 870 ] 34 0.002% 100.045% ( 870, 1300 ] 16 0.001% 100.046% ( 1300, 1900 ] 11 0.001% 100.046% ( 1900, 2900 ] 7 0.000% 100.047% ( 2900, 4400 ] 14 0.001% 100.048% ** Level 1 read latency histogram (micros): Count: 382489 Average: 3.8705 StdDev: 14.23 Min: 1 Median: 3.0861 Max: 4422 Percentiles: P50: 3.09 P75: 3.90 P99: 9.91 P99.9: 29.15 P99.99: 757.98 ------------------------------------------------------ [ 0, 1 ] 3716 0.972% 0.972% ( 1, 2 ] 117896 30.823% 31.795% ###### ( 2, 3 ] 59522 15.562% 47.357% ### ( 3, 4 ] 117467 30.711% 78.068% ###### ( 4, 6 ] 64995 16.993% 95.061% ### ( 6, 10 ] 15433 4.035% 99.095% # ( 10, 15 ] 2288 0.598% 99.694% ( 15, 22 ] 644 0.168% 99.862% ( 22, 34 ] 246 0.064% 99.926% ( 34, 51 ] 9 0.002% 99.929% ( 51, 76 ] 5 0.001% 99.930% ( 76, 110 ] 63 0.016% 99.946% ( 110, 170 ] 110 0.029% 99.975% ( 170, 250 ] 20 0.005% 99.980% ( 250, 380 ] 15 0.004% 99.984% ( 380, 580 ] 16 0.004% 99.988% ( 580, 870 ] 11 0.003% 99.991% ( 870, 1300 ] 29 0.008% 99.999% ( 1300, 1900 ] 4 0.001% 100.000% ( 4400, 6600 ] 1 0.000% 100.000% ** Level 2 read latency histogram (micros): Count: 102835 Average: 2.7047 StdDev: 5.12 Min: 0 Median: 1.9446 Max: 991 Percentiles: P50: 1.94 P75: 2.59 P99: 7.64 P99.9: 14.24 P99.99: 48.59 ------------------------------------------------------ [ 0, 1 ] 2006 1.951% 1.951% ( 1, 2 ] 52307 50.865% 52.816% ########## ( 2, 3 ] 38737 37.669% 90.485% ######## ( 3, 4 ] 5148 5.006% 95.491% # ( 4, 6 ] 3108 3.022% 98.513% # ( 6, 10 ] 1222 1.188% 99.701% ( 10, 15 ] 241 0.234% 99.936% ( 15, 22 ] 50 0.049% 99.984% ( 22, 34 ] 4 0.004% 99.988% ( 34, 51 ] 2 0.002% 99.990% ( 51, 76 ] 1 0.001% 99.991% ( 170, 250 ] 2 0.002% 99.993% ( 250, 380 ] 2 0.002% 99.995% ( 380, 580 ] 3 0.003% 99.998% ( 580, 870 ] 1 0.001% 99.999% ( 870, 1300 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 60 Average: 1759.5000 StdDev: 1097.20 Min: 134 Median: 1660.0000 Max: 4611 Percentiles: P50: 1660.00 P75: 2547.06 P99: 4611.00 P99.9: 4611.00 P99.99: 4611.00 ------------------------------------------------------ ( 110, 170 ] 1 1.667% 1.667% ( 170, 250 ] 2 3.333% 5.000% # ( 250, 380 ] 2 3.333% 8.333% # ( 380, 580 ] 5 8.333% 16.667% ## ( 580, 870 ] 4 6.667% 23.333% # ( 870, 1300 ] 10 16.667% 40.000% ### ( 1300, 1900 ] 10 16.667% 56.667% ### ( 1900, 2900 ] 17 28.333% 85.000% ###### ( 2900, 4400 ] 8 13.333% 98.333% ### ( 4400, 6600 ] 1 1.667% 100.000% ** Level 4 read latency histogram (micros): Count: 295 Average: 114.8169 StdDev: 513.77 Min: 1 Median: 1.7746 Max: 4298 Percentiles: P50: 1.77 P75: 8.33 P99: 3293.75 P99.9: 4289.38 P99.99: 4298.00 ------------------------------------------------------ [ 0, 1 ] 53 17.966% 17.966% #### ( 1, 2 ] 122 41.356% 59.322% ######## ( 2, 3 ] 32 10.847% 70.169% ## ( 3, 4 ] 5 1.695% 71.864% ( 4, 6 ] 4 1.356% 73.220% ( 6, 10 ] 9 3.051% 76.271% # ( 10, 15 ] 39 13.220% 89.492% ### ( 15, 22 ] 1 0.339% 89.831% ( 22, 34 ] 3 1.017% 90.847% ( 34, 51 ] 6 2.034% 92.881% ( 110, 170 ] 1 0.339% 93.220% ( 170, 250 ] 4 1.356% 94.576% ( 250, 380 ] 1 0.339% 94.915% ( 380, 580 ] 2 0.678% 95.593% ( 870, 1300 ] 1 0.339% 95.932% ( 1300, 1900 ] 4 1.356% 97.288% ( 1900, 2900 ] 4 1.356% 98.644% ( 2900, 4400 ] 4 1.356% 100.000% ** Level 5 read latency histogram (micros): Count: 60 Average: 734.9167 StdDev: 995.92 Min: 98 Median: 170.0000 Max: 3611 Percentiles: P50: 170.00 P75: 787.14 P99: 3611.00 P99.9: 3611.00 P99.99: 3611.00 ------------------------------------------------------ ( 76, 110 ] 4 6.667% 6.667% # ( 110, 170 ] 26 43.333% 50.000% ######### ( 170, 250 ] 5 8.333% 58.333% ## ( 250, 380 ] 3 5.000% 63.333% # ( 380, 580 ] 2 3.333% 66.667% # ( 580, 870 ] 7 11.667% 78.333% ## ( 870, 1300 ] 1 1.667% 80.000% ( 1300, 1900 ] 2 3.333% 83.333% # ( 1900, 2900 ] 6 10.000% 93.333% ## ( 2900, 4400 ] 4 6.667% 100.000% # ** DB Stats ** Uptime(secs): 41.4 total, 8.2 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 118.75 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.000 H:M:S, 0.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 119.57 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.000 H:M:S, 0.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/07/22-22:03:11 ... thread 0: (1000000,6000000) ops and (122258.5,121721.6) ops/second in (8.179389,49.292797) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 17/9 3.44 GB 163.6 4.4 0.0 4.4 10.1 5.7 0.0 1.8 81.0 184.3 56.02 52.89 110 0.509 4605K 4350 0.0 0.0 L1 14/14 1.44 GB 0.0 3.1 2.0 1.0 3.1 2.0 0.2 1.5 108.1 107.6 29.17 28.33 5 5.833 3200K 12K 0.0 0.0 L2 6/0 31.76 MB 0.3 0.4 0.2 0.2 0.4 0.2 0.7 2.2 186.0 185.9 2.42 2.31 3 0.808 457K 224 0.0 0.0 L3 11/0 892.54 MB 0.9 0.0 0.0 0.0 0.0 0.0 0.8 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 192/0 9.63 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.6 1.0 112.7 112.7 1.96 1.55 1 1.957 223K 0 0.0 0.0 L5 1340/0 86.37 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1580/23 101.78 GB 0.0 8.2 2.4 5.7 13.8 8.1 3.0 2.4 93.3 157.8 89.57 85.08 119 0.753 8487K 17K 0.0 0.0 Int 0/0 0.00 KB 0.0 8.2 2.4 5.7 13.8 8.1 3.0 2.4 93.3 157.8 89.57 85.08 119 0.753 8487K 17K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 8.2 2.4 5.7 8.1 2.4 0.0 0.0 140.6 140.3 59.46 57.43 27 2.202 8487K 17K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 5.7 5.7 0.0 0.0 0.0 192.5 30.11 27.64 92 0.327 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): 49.6 total, 49.3 interval Flush(GB): cumulative 5.660, interval 5.660 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 13.81 GB write, 284.92 MB/s write, 8.16 GB read, 168.47 MB/s read, 89.6 seconds Interval compaction: 13.81 GB write, 286.79 MB/s write, 8.16 GB read, 169.57 MB/s read, 89.6 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 1, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 1, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 0, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 1, total-stops: 0, interval: 1 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2080505 Average: 3.4403 StdDev: 12.85 Min: 1 Median: 2.4239 Max: 4168 Percentiles: P50: 2.42 P75: 3.54 P99: 9.49 P99.9: 19.08 P99.99: 33.67 ------------------------------------------------------ [ 0, 1 ] 17702 0.851% 0.851% ( 1, 2 ] 783207 37.645% 38.496% ######## ( 2, 3 ] 564620 27.139% 65.634% ##### ( 3, 4 ] 357815 17.198% 82.833% ### ( 4, 6 ] 285238 13.710% 96.543% ### ( 6, 10 ] 58661 2.820% 99.363% # ( 10, 15 ] 9755 0.469% 99.831% ( 15, 22 ] 2447 0.118% 99.949% ( 22, 34 ] 877 0.042% 99.991% ( 34, 51 ] 57 0.003% 99.994% ( 51, 76 ] 29 0.001% 99.995% ( 76, 110 ] 153 0.007% 100.003% ( 110, 170 ] 341 0.016% 100.019% ( 170, 250 ] 79 0.004% 100.023% ( 250, 380 ] 120 0.006% 100.029% ( 380, 580 ] 117 0.006% 100.034% ( 580, 870 ] 41 0.002% 100.036% ( 870, 1300 ] 25 0.001% 100.037% ( 1300, 1900 ] 15 0.001% 100.038% ( 1900, 2900 ] 7 0.000% 100.039% ( 2900, 4400 ] 15 0.001% 100.039% ** Level 1 read latency histogram (micros): Count: 545845 Average: 3.5934 StdDev: 13.25 Min: 1 Median: 2.4872 Max: 4422 Percentiles: P50: 2.49 P75: 3.64 P99: 9.72 P99.9: 83.30 P99.99: 550.13 ------------------------------------------------------ [ 0, 1 ] 5174 0.948% 0.948% ( 1, 2 ] 212233 38.882% 39.829% ######## ( 2, 3 ] 113954 20.877% 60.706% #### ( 3, 4 ] 121439 22.248% 82.954% #### ( 4, 6 ] 70420 12.901% 95.855% ### ( 6, 10 ] 18465 3.383% 99.238% # ( 10, 15 ] 2629 0.482% 99.720% ( 15, 22 ] 674 0.123% 99.843% ( 22, 34 ] 254 0.047% 99.890% ( 34, 51 ] 9 0.002% 99.891% ( 51, 76 ] 11 0.002% 99.893% ( 76, 110 ] 173 0.032% 99.925% ( 110, 170 ] 238 0.044% 99.968% ( 170, 250 ] 70 0.013% 99.981% ( 250, 380 ] 27 0.005% 99.986% ( 380, 580 ] 24 0.004% 99.991% ( 580, 870 ] 16 0.003% 99.994% ( 870, 1300 ] 29 0.005% 99.999% ( 1300, 1900 ] 4 0.001% 100.000% ( 1900, 2900 ] 1 0.000% 100.000% ( 4400, 6600 ] 1 0.000% 100.000% ** Level 2 read latency histogram (micros): Count: 102835 Average: 2.7047 StdDev: 5.12 Min: 0 Median: 1.9446 Max: 991 Percentiles: P50: 1.94 P75: 2.59 P99: 7.64 P99.9: 14.24 P99.99: 48.59 ------------------------------------------------------ [ 0, 1 ] 2006 1.951% 1.951% ( 1, 2 ] 52307 50.865% 52.816% ########## ( 2, 3 ] 38737 37.669% 90.485% ######## ( 3, 4 ] 5148 5.006% 95.491% # ( 4, 6 ] 3108 3.022% 98.513% # ( 6, 10 ] 1222 1.188% 99.701% ( 10, 15 ] 241 0.234% 99.936% ( 15, 22 ] 50 0.049% 99.984% ( 22, 34 ] 4 0.004% 99.988% ( 34, 51 ] 2 0.002% 99.990% ( 51, 76 ] 1 0.001% 99.991% ( 170, 250 ] 2 0.002% 99.993% ( 250, 380 ] 2 0.002% 99.995% ( 380, 580 ] 3 0.003% 99.998% ( 580, 870 ] 1 0.001% 99.999% ( 870, 1300 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 60 Average: 1759.5000 StdDev: 1097.20 Min: 134 Median: 1660.0000 Max: 4611 Percentiles: P50: 1660.00 P75: 2547.06 P99: 4611.00 P99.9: 4611.00 P99.99: 4611.00 ------------------------------------------------------ ( 110, 170 ] 1 1.667% 1.667% ( 170, 250 ] 2 3.333% 5.000% # ( 250, 380 ] 2 3.333% 8.333% # ( 380, 580 ] 5 8.333% 16.667% ## ( 580, 870 ] 4 6.667% 23.333% # ( 870, 1300 ] 10 16.667% 40.000% ### ( 1300, 1900 ] 10 16.667% 56.667% ### ( 1900, 2900 ] 17 28.333% 85.000% ###### ( 2900, 4400 ] 8 13.333% 98.333% ### ( 4400, 6600 ] 1 1.667% 100.000% ** Level 4 read latency histogram (micros): Count: 295 Average: 114.8169 StdDev: 513.77 Min: 1 Median: 1.7746 Max: 4298 Percentiles: P50: 1.77 P75: 8.33 P99: 3293.75 P99.9: 4289.38 P99.99: 4298.00 ------------------------------------------------------ [ 0, 1 ] 53 17.966% 17.966% #### ( 1, 2 ] 122 41.356% 59.322% ######## ( 2, 3 ] 32 10.847% 70.169% ## ( 3, 4 ] 5 1.695% 71.864% ( 4, 6 ] 4 1.356% 73.220% ( 6, 10 ] 9 3.051% 76.271% # ( 10, 15 ] 39 13.220% 89.492% ### ( 15, 22 ] 1 0.339% 89.831% ( 22, 34 ] 3 1.017% 90.847% ( 34, 51 ] 6 2.034% 92.881% ( 110, 170 ] 1 0.339% 93.220% ( 170, 250 ] 4 1.356% 94.576% ( 250, 380 ] 1 0.339% 94.915% ( 380, 580 ] 2 0.678% 95.593% ( 870, 1300 ] 1 0.339% 95.932% ( 1300, 1900 ] 4 1.356% 97.288% ( 1900, 2900 ] 4 1.356% 98.644% ( 2900, 4400 ] 4 1.356% 100.000% ** Level 5 read latency histogram (micros): Count: 60 Average: 734.9167 StdDev: 995.92 Min: 98 Median: 170.0000 Max: 3611 Percentiles: P50: 170.00 P75: 787.14 P99: 3611.00 P99.9: 3611.00 P99.99: 3611.00 ------------------------------------------------------ ( 76, 110 ] 4 6.667% 6.667% # ( 110, 170 ] 26 43.333% 50.000% ######### ( 170, 250 ] 5 8.333% 58.333% ## ( 250, 380 ] 3 5.000% 63.333% # ( 380, 580 ] 2 3.333% 66.667% # ( 580, 870 ] 7 11.667% 78.333% ## ( 870, 1300 ] 1 1.667% 80.000% ( 1300, 1900 ] 2 3.333% 83.333% # ( 1900, 2900 ] 6 10.000% 93.333% ## ( 2900, 4400 ] 4 6.667% 100.000% # ** DB Stats ** Uptime(secs): 49.6 total, 8.2 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 119.01 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.203 H:M:S, 0.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 120.34 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.203 H:M:S, 2.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 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 : 8.665 micros/op 115400 ops/sec 60.008 seconds 6924999 operations; 111.8 MB/s Microseconds per write: Count: 6924999 Average: 8.6654 StdDev: 242.73 Min: 1 Median: 5.6176 Max: 628124 Percentiles: P50: 5.62 P75: 9.40 P99: 21.33 P99.9: 325.79 P99.99: 2137.09 ------------------------------------------------------ [ 0, 1 ] 1218 0.018% 0.018% ( 1, 2 ] 175511 2.534% 2.552% # ( 2, 3 ] 299078 4.319% 6.871% # ( 3, 4 ] 252741 3.650% 10.521% # ( 4, 6 ] 3380194 48.811% 59.332% ########## ( 6, 10 ] 1275104 18.413% 77.745% #### ( 10, 15 ] 1276958 18.440% 96.185% #### ( 15, 22 ] 215420 3.111% 99.296% # ( 22, 34 ] 32440 0.468% 99.764% ( 34, 51 ] 4538 0.066% 99.830% ( 51, 76 ] 648 0.009% 99.839% ( 76, 110 ] 186 0.003% 99.842% ( 110, 170 ] 191 0.003% 99.844% ( 170, 250 ] 596 0.009% 99.853% ( 250, 380 ] 5576 0.081% 99.934% ( 380, 580 ] 609 0.009% 99.942% ( 580, 870 ] 119 0.002% 99.944% ( 870, 1300 ] 2995 0.043% 99.987% ( 1300, 1900 ] 33 0.000% 99.988% ( 1900, 2900 ] 639 0.009% 99.997% ( 2900, 4400 ] 169 0.002% 99.999% ( 4400, 6600 ] 17 0.000% 100.000% ( 6600, 9900 ] 12 0.000% 100.000% ( 9900, 14000 ] 3 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% ( 570000, 860000 ] 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 : 81029 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 : 6924999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 7146598968 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 : 325 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 5097633 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 : 16884628497 rocksdb.compact.write.bytes COUNT : 16799079277 rocksdb.flush.write.bytes COUNT : 7002599642 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 : 23 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 : 122 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 : 6945579008 rocksdb.memtable.garbage.bytes.at.flush COUNT : 2202624 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 : 16944208627 rocksdb.non.last.level.read.count COUNT : 4093756 rocksdb.block.checksum.compute.count COUNT : 4093129 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 : 4.463098 P95 : 13.373513 P99 : 19.380415 P100 : 628122.000000 COUNT : 6924999 SUM : 50294054 rocksdb.compaction.times.micros P50 : 1591176.470588 P95 : 9635000.000000 P99 : 19760584.000000 P100 : 19760584.000000 COUNT : 41 SUM : 105976035 rocksdb.compaction.times.cpu_micros P50 : 1163571.428571 P95 : 9635000.000000 P99 : 18884291.000000 P100 : 18884291.000000 COUNT : 41 SUM : 95633111 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 : 705.338983 P95 : 1750.000000 P99 : 6563.333333 P100 : 11704.000000 COUNT : 105 SUM : 103146 rocksdb.compaction.outfile.sync.micros P50 : 933.442623 P95 : 6551.111111 P99 : 9883.500000 P100 : 11455.000000 COUNT : 204 SUM : 331046 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 : 145.666667 P95 : 557.272727 P99 : 2250.000000 P100 : 3780.000000 COUNT : 165 SUM : 40067 rocksdb.table.open.io.micros P50 : 1678.000000 P95 : 8085.000000 P99 : 12334.375000 P100 : 12615.000000 COUNT : 325 SUM : 750618 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 : 5.617206 P95 : 12.088135 P99 : 19.515413 P100 : 34998.000000 COUNT : 4092866 SUM : 34495868 rocksdb.read.block.get.micros P50 : 596.681416 P95 : 3532.692308 P99 : 5359.750000 P100 : 8976.000000 COUNT : 651 SUM : 597228 rocksdb.write.raw.block.micros P50 : 0.780788 P95 : 2.212571 P99 : 7.874992 P100 : 36371.000000 COUNT : 5775289 SUM : 19723724 rocksdb.numfiles.in.singlecompaction P50 : 3.284091 P95 : 7.150000 P99 : 23.000000 P100 : 23.000000 COUNT : 77 SUM : 294 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.561973 P95 : 1151.281366 P99 : 2362.682119 P100 : 627818.000000 COUNT : 32654 SUM : 5101603 rocksdb.sst.read.micros P50 : 2.674778 P95 : 7.643496 P99 : 12.448836 P100 : 19132.000000 COUNT : 4094907 SUM : 20704449 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 : 6924999 SUM : 7146598968 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 : 299035.087719 P95 : 671500.000000 P99 : 917133.000000 P100 : 917133.000000 COUNT : 105 SUM : 35971947 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 : 184 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