[2024-11-19 11:03:47.077169] Starting SPDK v25.01-pre git sha1 fc96810c2 / DPDK 24.03.0 initialization... [2024-11-19 11:03:47.077508] [ 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_pid231991 ] Set seed to 1732010627069932 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-11-19 11:03:47.230246] app.c: 919:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-11-19 11:03:47.334175] app.c: 612:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-11-19 11:03:47.334229] app.c: 613:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 231991' to capture a snapshot of events at runtime. [2024-11-19 11:03:47.334242] app.c: 618:app_setup_trace: *NOTICE*: 'spdk_trace' without parameters will also work if this is the only [2024-11-19 11:03:47.334255] app.c: 619:app_setup_trace: *NOTICE*: SPDK application currently running. [2024-11-19 11:03:47.334265] app.c: 620:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid231991 for offline analysis/debug. [2024-11-19 11:03:47.335468] reactor.c:1005:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Tue Nov 19 11:03:50 2024 CPU: 72 * Intel(R) Xeon(R) Gold 6140 CPU @ 2.30GHz CPUCache: 25344 KB 2024/11/19-11:03:53 ... thread 0: (1000000,1000000) ops and (326876.5,326876.5) ops/second in (3.059259,3.059259) 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 629.14 MB 12.6 0.0 0.0 0.0 0.9 0.9 0.0 1.0 0.0 334.7 2.63 2.44 13 0.202 0 0 0.0 0.0 L1 3/3 188.13 MB 0.0 0.2 0.2 0.0 0.2 0.2 0.1 1.0 244.2 243.7 0.77 0.76 1 0.772 191K 404 0.0 0.0 L2 1/1 100.79 MB 0.0 0.2 0.1 0.1 0.2 0.1 0.0 2.6 249.2 248.9 0.64 0.62 1 0.645 163K 252 0.0 0.0 L3 18/11 1004.54 MB 0.1 0.1 0.1 0.0 0.1 0.1 0.0 1.0 195.6 195.6 0.30 0.29 1 0.305 60K 0 0.0 0.0 L4 120/0 9.54 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 112/0 8.67 GB 0.1 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 264/23 20.09 GB 0.0 0.4 0.3 0.1 1.3 1.2 0.1 1.5 93.9 296.1 4.35 4.10 16 0.272 415K 656 0.0 0.0 Int 0/0 0.00 KB 0.0 0.4 0.3 0.1 1.3 1.2 0.1 1.5 93.9 296.1 4.35 4.10 16 0.272 415K 656 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 0.4 0.3 0.1 0.4 0.3 0.0 0.0 237.5 237.1 1.72 1.66 3 0.574 415K 656 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 334.7 2.63 2.44 13 0.202 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 3.1 total, 3.1 interval Flush(GB): cumulative 0.860, interval 0.860 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.26 GB write, 411.40 MB/s write, 0.40 GB read, 130.52 MB/s read, 4.4 seconds Interval compaction: 1.26 GB write, 421.04 MB/s write, 0.40 GB read, 133.58 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: 2, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 2, interval: 2 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 129357 Average: 2.0478 StdDev: 5.62 Min: 0 Median: 1.3835 Max: 1221 Percentiles: P50: 1.38 P75: 1.80 P99: 5.72 P99.9: 11.43 P99.99: 170.43 ------------------------------------------------------ [ 0, 1 ] 35243 27.245% 27.245% ##### ( 1, 2 ] 76758 59.338% 86.583% ############ ( 2, 3 ] 9654 7.463% 94.046% # ( 3, 4 ] 4111 3.178% 97.224% # ( 4, 6 ] 2673 2.066% 99.290% ( 6, 10 ] 751 0.581% 99.871% ( 10, 15 ] 139 0.107% 99.978% ( 15, 22 ] 13 0.010% 99.988% ( 34, 51 ] 3 0.002% 99.991% ( 76, 110 ] 1 0.001% 99.991% ( 170, 250 ] 12 0.009% 100.001% ( 250, 380 ] 5 0.004% 100.005% ( 380, 580 ] 8 0.006% 100.011% ( 870, 1300 ] 1 0.001% 100.012% ** Level 1 read latency histogram (micros): Count: 29029 Average: 2.0905 StdDev: 5.62 Min: 1 Median: 1.4291 Max: 780 Percentiles: P50: 1.43 P75: 1.84 P99: 5.62 P99.9: 9.94 P99.99: 262.62 ------------------------------------------------------ [ 0, 1 ] 6945 23.924% 23.924% ##### ( 1, 2 ] 17639 60.763% 84.688% ############ ( 2, 3 ] 2550 8.784% 93.472% ## ( 3, 4 ] 1038 3.576% 97.048% # ( 4, 6 ] 699 2.408% 99.456% ( 6, 10 ] 131 0.451% 99.907% ( 10, 15 ] 19 0.065% 99.972% ( 15, 22 ] 3 0.010% 99.983% ( 34, 51 ] 1 0.003% 99.986% ( 170, 250 ] 1 0.003% 99.990% ( 250, 380 ] 1 0.003% 99.993% ( 380, 580 ] 1 0.003% 99.997% ( 580, 870 ] 1 0.003% 100.000% ** Level 2 read latency histogram (micros): Count: 40075 Average: 2.7942 StdDev: 20.39 Min: 1 Median: 1.4638 Max: 2710 Percentiles: P50: 1.46 P75: 1.91 P99: 9.27 P99.9: 146.54 P99.99: 868.91 ------------------------------------------------------ [ 0, 1 ] 9539 23.803% 23.803% ##### ( 1, 2 ] 22635 56.482% 80.284% ########### ( 2, 3 ] 3823 9.540% 89.824% ## ( 3, 4 ] 1634 4.077% 93.901% # ( 4, 6 ] 1566 3.908% 97.809% # ( 6, 10 ] 583 1.455% 99.264% ( 10, 15 ] 132 0.329% 99.593% ( 15, 22 ] 13 0.032% 99.626% ( 22, 34 ] 7 0.017% 99.643% ( 34, 51 ] 27 0.067% 99.711% ( 51, 76 ] 5 0.012% 99.723% ( 76, 110 ] 49 0.122% 99.845% ( 110, 170 ] 36 0.090% 99.935% ( 170, 250 ] 14 0.035% 99.970% ( 250, 380 ] 5 0.012% 99.983% ( 380, 580 ] 1 0.002% 99.985% ( 580, 870 ] 2 0.005% 99.990% ( 870, 1300 ] 1 0.002% 99.993% ( 1300, 1900 ] 2 0.005% 99.998% ( 1900, 2900 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 26508 Average: 8.9204 StdDev: 166.07 Min: 1 Median: 1.6857 Max: 7382 Percentiles: P50: 1.69 P75: 2.36 P99: 13.21 P99.9: 1649.20 P99.99: 7382.00 ------------------------------------------------------ [ 0, 1 ] 1782 6.722% 6.722% # ( 1, 2 ] 16730 63.113% 69.836% ############# ( 2, 3 ] 3814 14.388% 84.224% ### ( 3, 4 ] 1813 6.839% 91.063% # ( 4, 6 ] 1449 5.466% 96.529% # ( 6, 10 ] 545 2.056% 98.585% ( 10, 15 ] 171 0.645% 99.230% ( 15, 22 ] 16 0.060% 99.291% ( 22, 34 ] 2 0.008% 99.298% ( 34, 51 ] 16 0.060% 99.359% ( 51, 76 ] 12 0.045% 99.404% ( 76, 110 ] 17 0.064% 99.468% ( 110, 170 ] 71 0.268% 99.736% ( 170, 250 ] 12 0.045% 99.781% ( 250, 380 ] 4 0.015% 99.796% ( 380, 580 ] 2 0.008% 99.804% ( 580, 870 ] 16 0.060% 99.864% ( 870, 1300 ] 6 0.023% 99.887% ( 1300, 1900 ] 6 0.023% 99.909% ( 1900, 2900 ] 1 0.004% 99.913% ( 2900, 4400 ] 6 0.023% 99.936% ( 4400, 6600 ] 12 0.045% 99.981% ( 6600, 9900 ] 5 0.019% 100.000% ** Level 4 read latency histogram (micros): Count: 15 Average: 3666.8667 StdDev: 1511.11 Min: 649 Median: 3462.5000 Max: 6060 Percentiles: P50: 3462.50 P75: 4950.00 P99: 6060.00 P99.9: 6060.00 P99.99: 6060.00 ------------------------------------------------------ ( 580, 870 ] 1 6.667% 6.667% # ( 1300, 1900 ] 1 6.667% 13.333% # ( 1900, 2900 ] 4 26.667% 40.000% ##### ( 2900, 4400 ] 4 26.667% 66.667% ##### ( 4400, 6600 ] 5 33.333% 100.000% ####### ** DB Stats ** Uptime(secs): 3.1 total, 3.1 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 314.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.196 H:M:S, 6.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 321.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.196 H:M:S, 6.4 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/11/19-11:03:56 ... thread 0: (1000000,2000000) ops and (318782.5,322778.8) ops/second in (3.136935,6.196194) 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/4 1.35 GB 106.4 1.0 0.0 1.0 2.8 1.8 0.0 1.5 106.0 304.2 9.50 8.99 32 0.297 1022K 4948 0.0 0.0 L1 1/0 49.83 MB 5.0 0.6 0.4 0.2 0.6 0.4 0.1 1.4 242.0 240.4 2.60 2.55 2 1.298 638K 4011 0.0 0.0 L2 1/1 100.79 MB 0.0 0.2 0.1 0.1 0.2 0.1 0.4 2.6 249.2 248.9 0.64 0.62 1 0.645 163K 252 0.0 0.0 L3 21/11 1.36 GB 0.4 0.5 0.4 0.1 0.5 0.4 0.0 1.2 213.1 212.6 2.57 2.48 4 0.643 556K 1268 0.0 0.0 L4 120/0 9.54 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 112/0 8.67 GB 0.1 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 264/16 21.06 GB 0.0 2.3 0.9 1.4 4.1 2.8 0.4 2.2 153.1 275.6 15.31 14.63 39 0.393 2380K 10K 0.0 0.0 Int 0/0 0.00 KB 0.0 2.3 0.9 1.4 4.1 2.8 0.4 2.2 153.1 275.6 15.31 14.63 39 0.393 2380K 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 2.3 0.9 1.4 2.3 0.9 0.0 0.0 238.8 237.7 9.81 9.56 11 0.892 2380K 10K 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 343.4 5.50 5.07 28 0.196 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 6.3 total, 6.2 interval Flush(GB): cumulative 1.843, interval 1.843 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.12 GB write, 673.09 MB/s write, 2.29 GB read, 373.81 MB/s read, 15.3 seconds Interval compaction: 4.12 GB write, 680.89 MB/s write, 2.29 GB read, 378.14 MB/s read, 15.3 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 3, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 3, interval: 3 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 396692 Average: 2.4188 StdDev: 6.47 Min: 0 Median: 1.6120 Max: 1669 Percentiles: P50: 1.61 P75: 2.08 P99: 6.03 P99.9: 13.15 P99.99: 21.95 ------------------------------------------------------ [ 0, 1 ] 49959 12.594% 12.594% ### ( 1, 2 ] 242465 61.122% 73.716% ############ ( 2, 3 ] 61861 15.594% 89.310% ### ( 3, 4 ] 21915 5.524% 94.834% # ( 4, 6 ] 16500 4.159% 98.994% # ( 6, 10 ] 3138 0.791% 99.785% ( 10, 15 ] 725 0.183% 99.967% ( 15, 22 ] 90 0.023% 99.990% ( 22, 34 ] 18 0.005% 99.995% ( 34, 51 ] 3 0.001% 99.995% ( 51, 76 ] 3 0.001% 99.996% ( 76, 110 ] 5 0.001% 99.997% ( 110, 170 ] 13 0.003% 100.001% ( 170, 250 ] 27 0.007% 100.008% ( 250, 380 ] 10 0.003% 100.010% ( 380, 580 ] 21 0.005% 100.015% ( 580, 870 ] 2 0.001% 100.016% ( 870, 1300 ] 6 0.002% 100.017% ( 1300, 1900 ] 1 0.000% 100.018% ** Level 1 read latency histogram (micros): Count: 145840 Average: 2.8372 StdDev: 8.02 Min: 1 Median: 1.7598 Max: 882 Percentiles: P50: 1.76 P75: 2.54 P99: 8.77 P99.9: 20.00 P99.99: 227.63 ------------------------------------------------------ [ 0, 1 ] 9479 6.500% 6.500% # ( 1, 2 ] 83495 57.251% 63.751% ########### ( 2, 3 ] 30444 20.875% 84.626% #### ( 3, 4 ] 10354 7.100% 91.725% # ( 4, 6 ] 8991 6.165% 97.890% # ( 6, 10 ] 2340 1.604% 99.495% ( 10, 15 ] 549 0.376% 99.871% ( 15, 22 ] 59 0.040% 99.912% ( 22, 34 ] 6 0.004% 99.916% ( 34, 51 ] 5 0.003% 99.919% ( 51, 76 ] 2 0.001% 99.920% ( 76, 110 ] 10 0.007% 99.927% ( 110, 170 ] 59 0.040% 99.968% ( 170, 250 ] 45 0.031% 99.999% ( 250, 380 ] 13 0.009% 100.008% ( 380, 580 ] 8 0.005% 100.013% ( 580, 870 ] 5 0.003% 100.016% ( 870, 1300 ] 1 0.001% 100.017% ** Level 2 read latency histogram (micros): Count: 40726 Average: 3.2392 StdDev: 23.24 Min: 1 Median: 1.4756 Max: 2710 Percentiles: P50: 1.48 P75: 1.92 P99: 9.88 P99.9: 207.58 P99.99: 1069.39 ------------------------------------------------------ [ 0, 1 ] 9539 23.422% 23.422% ##### ( 1, 2 ] 22757 55.878% 79.301% ########### ( 2, 3 ] 4129 10.138% 89.439% ## ( 3, 4 ] 1697 4.167% 93.606% # ( 4, 6 ] 1617 3.970% 97.576% # ( 6, 10 ] 597 1.466% 99.042% ( 10, 15 ] 133 0.327% 99.369% ( 15, 22 ] 13 0.032% 99.401% ( 22, 34 ] 7 0.017% 99.418% ( 34, 51 ] 27 0.066% 99.484% ( 51, 76 ] 5 0.012% 99.497% ( 76, 110 ] 50 0.123% 99.619% ( 110, 170 ] 103 0.253% 99.872% ( 170, 250 ] 24 0.059% 99.931% ( 250, 380 ] 15 0.037% 99.968% ( 380, 580 ] 4 0.010% 99.978% ( 580, 870 ] 4 0.010% 99.988% ( 870, 1300 ] 2 0.005% 99.993% ( 1300, 1900 ] 2 0.005% 99.998% ( 1900, 2900 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 254427 Average: 3.4163 StdDev: 54.04 Min: 1 Median: 1.6847 Max: 7382 Percentiles: P50: 1.68 P75: 2.31 P99: 9.17 P99.9: 124.33 P99.99: 531.15 ------------------------------------------------------ [ 0, 1 ] 16977 6.673% 6.673% # ( 1, 2 ] 160992 63.276% 69.949% ############# ( 2, 3 ] 41384 16.266% 86.215% ### ( 3, 4 ] 16329 6.418% 92.632% # ( 4, 6 ] 12167 4.782% 97.415% # ( 6, 10 ] 5094 2.002% 99.417% ( 10, 15 ] 646 0.254% 99.671% ( 15, 22 ] 54 0.021% 99.692% ( 22, 34 ] 8 0.003% 99.695% ( 34, 51 ] 248 0.097% 99.792% ( 51, 76 ] 146 0.057% 99.850% ( 76, 110 ] 82 0.032% 99.882% ( 110, 170 ] 195 0.077% 99.959% ( 170, 250 ] 53 0.021% 99.980% ( 250, 380 ] 20 0.008% 99.987% ( 380, 580 ] 10 0.004% 99.991% ( 580, 870 ] 16 0.006% 99.998% ( 870, 1300 ] 6 0.002% 100.000% ( 1300, 1900 ] 7 0.003% 100.003% ( 1900, 2900 ] 1 0.000% 100.003% ( 2900, 4400 ] 6 0.002% 100.006% ( 4400, 6600 ] 12 0.005% 100.010% ( 6600, 9900 ] 5 0.002% 100.012% ** Level 4 read latency histogram (micros): Count: 15 Average: 3666.8667 StdDev: 1511.11 Min: 649 Median: 3462.5000 Max: 6060 Percentiles: P50: 3462.50 P75: 4950.00 P99: 6060.00 P99.9: 6060.00 P99.99: 6060.00 ------------------------------------------------------ ( 580, 870 ] 1 6.667% 6.667% # ( 1300, 1900 ] 1 6.667% 13.333% # ( 1900, 2900 ] 4 26.667% 40.000% ##### ( 2900, 4400 ] 4 26.667% 66.667% ##### ( 4400, 6600 ] 5 33.333% 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, 313.94 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.381 H:M:S, 6.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 313.75 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.185 H:M:S, 5.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/19-11:03:59 ... thread 0: (1000000,3000000) ops and (348330.1,330868.9) ops/second in (2.870840,9.067034) 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/8 2.26 GB 181.5 1.8 0.0 1.8 4.5 2.8 0.0 1.6 119.2 303.5 15.31 14.53 50 0.306 1852K 9289 0.0 0.0 L1 1/0 49.83 MB 5.0 0.6 0.4 0.2 0.6 0.4 0.1 1.4 242.0 240.4 2.60 2.55 2 1.298 638K 4011 0.0 0.0 L2 0/0 0.00 KB 0.0 0.2 0.1 0.1 0.2 0.1 0.4 2.6 249.2 248.9 0.64 0.62 1 0.645 163K 252 0.0 0.0 L3 17/0 747.54 MB 0.7 1.6 0.5 1.0 1.6 0.5 0.0 2.9 238.0 237.4 6.70 6.44 5 1.339 1618K 4330 0.0 0.0 L4 126/0 9.64 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.5 1.0 218.8 218.8 1.03 0.98 1 1.027 228K 0 0.0 0.0 L5 120/0 9.29 GB 0.1 0.0 0.0 0.0 0.0 0.0 0.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 279/8 21.97 GB 0.0 4.3 1.2 3.1 7.1 4.0 1.6 2.6 168.7 275.8 26.27 25.11 59 0.445 4500K 17K 0.0 0.0 Int 0/0 0.00 KB 0.0 4.3 1.2 3.1 7.1 4.0 1.6 2.6 168.7 275.8 26.27 25.11 59 0.445 4500K 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 4.3 1.2 3.1 4.3 1.2 0.0 0.0 243.8 242.8 18.18 17.66 16 1.136 4500K 17K 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 349.9 8.09 7.45 43 0.188 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 9.1 total, 9.1 interval Flush(GB): cumulative 2.764, interval 2.764 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 7.07 GB write, 792.55 MB/s write, 4.33 GB read, 484.84 MB/s read, 26.3 seconds Interval compaction: 7.07 GB write, 798.83 MB/s write, 4.33 GB read, 488.68 MB/s read, 26.3 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 3, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 3, interval: 3 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 649831 Average: 2.3402 StdDev: 6.26 Min: 0 Median: 1.5789 Max: 1669 Percentiles: P50: 1.58 P75: 1.97 P99: 5.91 P99.9: 12.45 P99.99: 21.15 ------------------------------------------------------ [ 0, 1 ] 86750 13.350% 13.350% ### ( 1, 2 ] 411404 63.309% 76.659% ############# ( 2, 3 ] 93280 14.355% 91.014% ### ( 3, 4 ] 31110 4.787% 95.801% # ( 4, 6 ] 21765 3.349% 99.150% # ( 6, 10 ] 4401 0.677% 99.827% ( 10, 15 ] 963 0.148% 99.976% ( 15, 22 ] 107 0.016% 99.992% ( 22, 34 ] 22 0.003% 99.996% ( 34, 51 ] 6 0.001% 99.996% ( 51, 76 ] 4 0.001% 99.997% ( 76, 110 ] 6 0.001% 99.998% ( 110, 170 ] 13 0.002% 100.000% ( 170, 250 ] 42 0.006% 100.006% ( 250, 380 ] 14 0.002% 100.009% ( 380, 580 ] 32 0.005% 100.014% ( 580, 870 ] 3 0.000% 100.014% ( 870, 1300 ] 11 0.002% 100.016% ( 1300, 1900 ] 1 0.000% 100.016% ** Level 1 read latency histogram (micros): Count: 145840 Average: 2.8372 StdDev: 8.02 Min: 1 Median: 1.7598 Max: 882 Percentiles: P50: 1.76 P75: 2.54 P99: 8.77 P99.9: 20.00 P99.99: 227.63 ------------------------------------------------------ [ 0, 1 ] 9479 6.500% 6.500% # ( 1, 2 ] 83495 57.251% 63.751% ########### ( 2, 3 ] 30444 20.875% 84.626% #### ( 3, 4 ] 10354 7.100% 91.725% # ( 4, 6 ] 8991 6.165% 97.890% # ( 6, 10 ] 2340 1.604% 99.495% ( 10, 15 ] 549 0.376% 99.871% ( 15, 22 ] 59 0.040% 99.912% ( 22, 34 ] 6 0.004% 99.916% ( 34, 51 ] 5 0.003% 99.919% ( 51, 76 ] 2 0.001% 99.920% ( 76, 110 ] 10 0.007% 99.927% ( 110, 170 ] 59 0.040% 99.968% ( 170, 250 ] 45 0.031% 99.999% ( 250, 380 ] 13 0.009% 100.008% ( 380, 580 ] 8 0.005% 100.013% ( 580, 870 ] 5 0.003% 100.016% ( 870, 1300 ] 1 0.001% 100.017% ** Level 2 read latency histogram (micros): Count: 65588 Average: 2.8568 StdDev: 18.33 Min: 1 Median: 1.5051 Max: 2710 Percentiles: P50: 1.51 P75: 1.91 P99: 9.07 P99.9: 162.08 P99.99: 756.99 ------------------------------------------------------ [ 0, 1 ] 12575 19.173% 19.173% #### ( 1, 2 ] 40033 61.037% 80.210% ############ ( 2, 3 ] 6922 10.554% 90.764% ## ( 3, 4 ] 2545 3.880% 94.644% # ( 4, 6 ] 2037 3.106% 97.750% # ( 6, 10 ] 1068 1.628% 99.378% ( 10, 15 ] 149 0.227% 99.605% ( 15, 22 ] 14 0.021% 99.626% ( 22, 34 ] 7 0.011% 99.637% ( 34, 51 ] 27 0.041% 99.678% ( 51, 76 ] 6 0.009% 99.687% ( 76, 110 ] 50 0.076% 99.764% ( 110, 170 ] 103 0.157% 99.921% ( 170, 250 ] 24 0.037% 99.957% ( 250, 380 ] 15 0.023% 99.980% ( 380, 580 ] 4 0.006% 99.986% ( 580, 870 ] 4 0.006% 99.992% ( 870, 1300 ] 2 0.003% 99.995% ( 1300, 1900 ] 2 0.003% 99.998% ( 1900, 2900 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 323086 Average: 3.3556 StdDev: 48.50 Min: 1 Median: 1.6917 Max: 7382 Percentiles: P50: 1.69 P75: 2.32 P99: 9.11 P99.9: 138.75 P99.99: 577.43 ------------------------------------------------------ [ 0, 1 ] 20456 6.331% 6.331% # ( 1, 2 ] 203981 63.135% 69.467% ############# ( 2, 3 ] 55746 17.254% 86.721% ### ( 3, 4 ] 19634 6.077% 92.798% # ( 4, 6 ] 14969 4.633% 97.431% # ( 6, 10 ] 6526 2.020% 99.451% ( 10, 15 ] 737 0.228% 99.679% ( 15, 22 ] 75 0.023% 99.702% ( 22, 34 ] 12 0.004% 99.706% ( 34, 51 ] 249 0.077% 99.783% ( 51, 76 ] 148 0.046% 99.829% ( 76, 110 ] 113 0.035% 99.864% ( 110, 170 ] 244 0.076% 99.939% ( 170, 250 ] 89 0.028% 99.967% ( 250, 380 ] 51 0.016% 99.983% ( 380, 580 ] 24 0.007% 99.990% ( 580, 870 ] 20 0.006% 99.996% ( 870, 1300 ] 11 0.003% 100.000% ( 1300, 1900 ] 7 0.002% 100.002% ( 1900, 2900 ] 1 0.000% 100.002% ( 2900, 4400 ] 6 0.002% 100.004% ( 4400, 6600 ] 12 0.004% 100.008% ( 6600, 9900 ] 5 0.002% 100.009% ** Level 4 read latency histogram (micros): Count: 45 Average: 1259.2222 StdDev: 1914.51 Min: 0 Median: 115.0000 Max: 6060 Percentiles: P50: 115.00 P75: 2337.50 P99: 6060.00 P99.9: 6060.00 P99.99: 6060.00 ------------------------------------------------------ [ 0, 1 ] 8 17.778% 17.778% #### ( 1, 2 ] 9 20.000% 37.778% #### ( 2, 3 ] 1 2.222% 40.000% ( 15, 22 ] 1 2.222% 42.222% ( 22, 34 ] 1 2.222% 44.444% ( 34, 51 ] 2 4.444% 48.889% # ( 110, 170 ] 6 13.333% 62.222% ### ( 170, 250 ] 1 2.222% 64.444% ( 380, 580 ] 1 2.222% 66.667% ( 580, 870 ] 1 2.222% 68.889% ( 1300, 1900 ] 1 2.222% 71.111% ( 1900, 2900 ] 4 8.889% 80.000% ## ( 2900, 4400 ] 4 8.889% 88.889% ## ( 4400, 6600 ] 5 11.111% 100.000% ## ** Level 5 read latency histogram (micros): Count: 40 Average: 448.2500 StdDev: 476.31 Min: 97 Median: 264.4444 Max: 2009 Percentiles: P50: 264.44 P75: 580.00 P99: 2009.00 P99.9: 2009.00 P99.99: 2009.00 ------------------------------------------------------ ( 76, 110 ] 4 10.000% 10.000% ## ( 110, 170 ] 10 25.000% 35.000% ##### ( 170, 250 ] 5 12.500% 47.500% ### ( 250, 380 ] 9 22.500% 70.000% ##### ( 380, 580 ] 2 5.000% 75.000% # ( 580, 870 ] 1 2.500% 77.500% # ( 870, 1300 ] 7 17.500% 95.000% #### ( 1900, 2900 ] 2 5.000% 100.000% # ** DB Stats ** Uptime(secs): 9.1 total, 2.9 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 323.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.381 H:M:S, 4.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 342.81 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/11/19-11:04:02 ... thread 0: (1000000,4000000) ops and (355153.6,336623.3) ops/second in (2.815683,11.882717) 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/4 3.18 GB 300.5 2.8 0.0 2.8 6.4 3.7 0.0 1.7 130.4 303.6 21.71 20.69 69 0.315 2874K 14K 0.0 0.0 L1 1/0 49.83 MB 5.0 0.6 0.4 0.2 0.6 0.4 0.1 1.4 242.0 240.4 2.60 2.55 2 1.298 638K 4011 0.0 0.0 L2 0/0 0.00 KB 0.0 0.2 0.1 0.1 0.2 0.1 0.4 2.6 249.2 248.9 0.64 0.62 1 0.645 163K 252 0.0 0.0 L3 17/0 747.54 MB 0.7 1.6 0.5 1.0 1.6 0.5 0.0 2.9 238.0 237.4 6.70 6.44 5 1.339 1618K 4330 0.0 0.0 L4 126/0 9.64 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.5 1.0 218.8 218.8 1.03 0.98 1 1.027 228K 0 0.0 0.0 L5 120/0 9.29 GB 0.1 0.0 0.0 0.0 0.0 0.0 0.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 282/4 22.89 GB 0.0 5.3 1.2 4.1 9.0 4.9 1.6 2.4 166.5 281.3 32.67 31.27 78 0.419 5523K 22K 0.0 0.0 Int 0/0 0.00 KB 0.0 5.3 1.2 4.1 9.0 4.9 1.6 2.4 166.5 281.3 32.67 31.27 78 0.419 5523K 22K 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.3 1.2 4.1 5.3 1.2 0.0 0.0 246.2 245.2 22.08 21.49 20 1.104 5523K 22K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 3.7 3.7 0.0 0.0 0.0 356.5 10.59 9.77 58 0.183 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.0 total, 11.9 interval Flush(GB): cumulative 3.686, interval 3.686 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.97 GB write, 768.60 MB/s write, 5.31 GB read, 454.85 MB/s read, 32.7 seconds Interval compaction: 8.97 GB write, 773.24 MB/s write, 5.31 GB read, 457.60 MB/s read, 32.7 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 3, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 3, interval: 3 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 892037 Average: 2.2615 StdDev: 6.29 Min: 0 Median: 1.5351 Max: 1669 Percentiles: P50: 1.54 P75: 1.93 P99: 5.85 P99.9: 12.24 P99.99: 21.03 ------------------------------------------------------ [ 0, 1 ] 140355 15.734% 15.734% ### ( 1, 2 ] 571193 64.032% 79.767% ############# ( 2, 3 ] 112427 12.603% 92.370% ### ( 3, 4 ] 36437 4.085% 96.455% # ( 4, 6 ] 24525 2.749% 99.204% # ( 6, 10 ] 5651 0.633% 99.838% ( 10, 15 ] 1249 0.140% 99.978% ( 15, 22 ] 131 0.015% 99.992% ( 22, 34 ] 29 0.003% 99.996% ( 34, 51 ] 7 0.001% 99.996% ( 51, 76 ] 5 0.001% 99.997% ( 76, 110 ] 6 0.001% 99.998% ( 110, 170 ] 13 0.001% 99.999% ( 170, 250 ] 58 0.007% 100.005% ( 250, 380 ] 23 0.003% 100.008% ( 380, 580 ] 38 0.004% 100.012% ( 580, 870 ] 6 0.001% 100.013% ( 870, 1300 ] 15 0.002% 100.015% ( 1300, 1900 ] 2 0.000% 100.015% ** Level 1 read latency histogram (micros): Count: 145840 Average: 2.8372 StdDev: 8.02 Min: 1 Median: 1.7598 Max: 882 Percentiles: P50: 1.76 P75: 2.54 P99: 8.77 P99.9: 20.00 P99.99: 227.63 ------------------------------------------------------ [ 0, 1 ] 9479 6.500% 6.500% # ( 1, 2 ] 83495 57.251% 63.751% ########### ( 2, 3 ] 30444 20.875% 84.626% #### ( 3, 4 ] 10354 7.100% 91.725% # ( 4, 6 ] 8991 6.165% 97.890% # ( 6, 10 ] 2340 1.604% 99.495% ( 10, 15 ] 549 0.376% 99.871% ( 15, 22 ] 59 0.040% 99.912% ( 22, 34 ] 6 0.004% 99.916% ( 34, 51 ] 5 0.003% 99.919% ( 51, 76 ] 2 0.001% 99.920% ( 76, 110 ] 10 0.007% 99.927% ( 110, 170 ] 59 0.040% 99.968% ( 170, 250 ] 45 0.031% 99.999% ( 250, 380 ] 13 0.009% 100.008% ( 380, 580 ] 8 0.005% 100.013% ( 580, 870 ] 5 0.003% 100.016% ( 870, 1300 ] 1 0.001% 100.017% ** Level 2 read latency histogram (micros): Count: 65588 Average: 2.8568 StdDev: 18.33 Min: 1 Median: 1.5051 Max: 2710 Percentiles: P50: 1.51 P75: 1.91 P99: 9.07 P99.9: 162.08 P99.99: 756.99 ------------------------------------------------------ [ 0, 1 ] 12575 19.173% 19.173% #### ( 1, 2 ] 40033 61.037% 80.210% ############ ( 2, 3 ] 6922 10.554% 90.764% ## ( 3, 4 ] 2545 3.880% 94.644% # ( 4, 6 ] 2037 3.106% 97.750% # ( 6, 10 ] 1068 1.628% 99.378% ( 10, 15 ] 149 0.227% 99.605% ( 15, 22 ] 14 0.021% 99.626% ( 22, 34 ] 7 0.011% 99.637% ( 34, 51 ] 27 0.041% 99.678% ( 51, 76 ] 6 0.009% 99.687% ( 76, 110 ] 50 0.076% 99.764% ( 110, 170 ] 103 0.157% 99.921% ( 170, 250 ] 24 0.037% 99.957% ( 250, 380 ] 15 0.023% 99.980% ( 380, 580 ] 4 0.006% 99.986% ( 580, 870 ] 4 0.006% 99.992% ( 870, 1300 ] 2 0.003% 99.995% ( 1300, 1900 ] 2 0.003% 99.998% ( 1900, 2900 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 323086 Average: 3.3556 StdDev: 48.50 Min: 1 Median: 1.6917 Max: 7382 Percentiles: P50: 1.69 P75: 2.32 P99: 9.11 P99.9: 138.75 P99.99: 577.43 ------------------------------------------------------ [ 0, 1 ] 20456 6.331% 6.331% # ( 1, 2 ] 203981 63.135% 69.467% ############# ( 2, 3 ] 55746 17.254% 86.721% ### ( 3, 4 ] 19634 6.077% 92.798% # ( 4, 6 ] 14969 4.633% 97.431% # ( 6, 10 ] 6526 2.020% 99.451% ( 10, 15 ] 737 0.228% 99.679% ( 15, 22 ] 75 0.023% 99.702% ( 22, 34 ] 12 0.004% 99.706% ( 34, 51 ] 249 0.077% 99.783% ( 51, 76 ] 148 0.046% 99.829% ( 76, 110 ] 113 0.035% 99.864% ( 110, 170 ] 244 0.076% 99.939% ( 170, 250 ] 89 0.028% 99.967% ( 250, 380 ] 51 0.016% 99.983% ( 380, 580 ] 24 0.007% 99.990% ( 580, 870 ] 20 0.006% 99.996% ( 870, 1300 ] 11 0.003% 100.000% ( 1300, 1900 ] 7 0.002% 100.002% ( 1900, 2900 ] 1 0.000% 100.002% ( 2900, 4400 ] 6 0.002% 100.004% ( 4400, 6600 ] 12 0.004% 100.008% ( 6600, 9900 ] 5 0.002% 100.009% ** Level 4 read latency histogram (micros): Count: 45 Average: 1259.2222 StdDev: 1914.51 Min: 0 Median: 115.0000 Max: 6060 Percentiles: P50: 115.00 P75: 2337.50 P99: 6060.00 P99.9: 6060.00 P99.99: 6060.00 ------------------------------------------------------ [ 0, 1 ] 8 17.778% 17.778% #### ( 1, 2 ] 9 20.000% 37.778% #### ( 2, 3 ] 1 2.222% 40.000% ( 15, 22 ] 1 2.222% 42.222% ( 22, 34 ] 1 2.222% 44.444% ( 34, 51 ] 2 4.444% 48.889% # ( 110, 170 ] 6 13.333% 62.222% ### ( 170, 250 ] 1 2.222% 64.444% ( 380, 580 ] 1 2.222% 66.667% ( 580, 870 ] 1 2.222% 68.889% ( 1300, 1900 ] 1 2.222% 71.111% ( 1900, 2900 ] 4 8.889% 80.000% ## ( 2900, 4400 ] 4 8.889% 88.889% ## ( 4400, 6600 ] 5 11.111% 100.000% ## ** Level 5 read latency histogram (micros): Count: 40 Average: 448.2500 StdDev: 476.31 Min: 97 Median: 264.4444 Max: 2009 Percentiles: P50: 264.44 P75: 580.00 P99: 2009.00 P99.9: 2009.00 P99.99: 2009.00 ------------------------------------------------------ ( 76, 110 ] 4 10.000% 10.000% ## ( 110, 170 ] 10 25.000% 35.000% ##### ( 170, 250 ] 5 12.500% 47.500% ### ( 250, 380 ] 9 22.500% 70.000% ##### ( 380, 580 ] 2 5.000% 75.000% # ( 580, 870 ] 1 2.500% 77.500% # ( 870, 1300 ] 7 17.500% 95.000% #### ( 1900, 2900 ] 2 5.000% 100.000% # ** DB Stats ** Uptime(secs): 12.0 total, 2.8 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 329.26 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.381 H:M:S, 3.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 349.54 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 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: 20000000 Prefix: 0 bytes Keys per prefix: 0 RawSize: 19378.7 MB (estimated) FileSize: 19378.7 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 : 4.156 micros/op 240619 ops/sec 20.098 seconds 4835999 operations; 233.1 MB/s Microseconds per write: Count: 4835999 Average: 4.1559 StdDev: 128.98 Min: 1 Median: 1.7883 Max: 191890 Percentiles: P50: 1.79 P75: 3.06 P99: 8.51 P99.9: 168.08 P99.99: 2462.01 ------------------------------------------------------ [ 0, 1 ] 578582 11.964% 11.964% ## ( 1, 2 ] 2333501 48.253% 60.217% ########## ( 2, 3 ] 673126 13.919% 74.136% ### ( 3, 4 ] 670124 13.857% 87.993% ### ( 4, 6 ] 493489 10.204% 98.197% ## ( 6, 10 ] 61906 1.280% 99.477% ( 10, 15 ] 11657 0.241% 99.718% ( 15, 22 ] 3312 0.068% 99.787% ( 22, 34 ] 956 0.020% 99.807% ( 34, 51 ] 126 0.003% 99.809% ( 51, 76 ] 18 0.000% 99.810% ( 76, 110 ] 3 0.000% 99.810% ( 110, 170 ] 4507 0.093% 99.903% ( 170, 250 ] 322 0.007% 99.910% ( 250, 380 ] 73 0.002% 99.911% ( 380, 580 ] 9 0.000% 99.911% ( 580, 870 ] 5 0.000% 99.911% ( 870, 1300 ] 3183 0.066% 99.977% ( 1300, 1900 ] 1 0.000% 99.977% ( 1900, 2900 ] 1095 0.023% 100.000% ( 2900, 4400 ] 1 0.000% 100.000% ( 22000, 33000 ] 1 0.000% 100.000% ( 170000, 250000 ] 2 0.000% 100.000% STATISTICS: rocksdb.block.cache.miss COUNT : 0 rocksdb.block.cache.hit COUNT : 0 rocksdb.block.cache.add COUNT : 0 rocksdb.block.cache.add.failures COUNT : 0 rocksdb.block.cache.index.miss COUNT : 0 rocksdb.block.cache.index.hit COUNT : 0 rocksdb.block.cache.index.add COUNT : 0 rocksdb.block.cache.index.bytes.insert COUNT : 0 rocksdb.block.cache.filter.miss COUNT : 0 rocksdb.block.cache.filter.hit COUNT : 0 rocksdb.block.cache.filter.add COUNT : 0 rocksdb.block.cache.filter.bytes.insert COUNT : 0 rocksdb.block.cache.data.miss COUNT : 0 rocksdb.block.cache.data.hit COUNT : 0 rocksdb.block.cache.data.add COUNT : 0 rocksdb.block.cache.data.bytes.insert COUNT : 0 rocksdb.block.cache.bytes.read COUNT : 0 rocksdb.block.cache.bytes.write COUNT : 0 rocksdb.bloom.filter.useful COUNT : 0 rocksdb.bloom.filter.full.positive COUNT : 0 rocksdb.bloom.filter.full.true.positive COUNT : 0 rocksdb.persistent.cache.hit COUNT : 0 rocksdb.persistent.cache.miss COUNT : 0 rocksdb.sim.block.cache.hit COUNT : 0 rocksdb.sim.block.cache.miss COUNT : 0 rocksdb.memtable.hit COUNT : 0 rocksdb.memtable.miss COUNT : 0 rocksdb.l0.hit COUNT : 0 rocksdb.l1.hit COUNT : 0 rocksdb.l2andup.hit COUNT : 0 rocksdb.compaction.key.drop.new COUNT : 157129 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 : 4835999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 4990750968 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 : 162 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 6082615 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 : 8231998058 rocksdb.compact.write.bytes COUNT : 8075725655 rocksdb.flush.write.bytes COUNT : 4947325699 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 : 15 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 : 98 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 : 4914383872 rocksdb.memtable.garbage.bytes.at.flush COUNT : 8265728 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 : 8274365215 rocksdb.non.last.level.read.count COUNT : 1996405 rocksdb.block.checksum.compute.count COUNT : 1996096 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.446428 P95 : 4.795568 P99 : 7.044309 P100 : 191887.000000 COUNT : 4835999 SUM : 17877748 rocksdb.compaction.times.micros P50 : 996000.000000 P95 : 1830000.000000 P99 : 3964000.000000 P100 : 4124070.000000 COUNT : 24 SUM : 25896636 rocksdb.compaction.times.cpu_micros P50 : 996000.000000 P95 : 1830000.000000 P99 : 3958953.000000 P100 : 3958953.000000 COUNT : 24 SUM : 25244965 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 : 560.555556 P95 : 1267.750000 P99 : 1495.000000 P100 : 1495.000000 COUNT : 73 SUM : 48367 rocksdb.compaction.outfile.sync.micros P50 : 670.625000 P95 : 1217.071429 P99 : 1456.000000 P100 : 1467.000000 COUNT : 74 SUM : 53462 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 : 79.777778 P95 : 247.333333 P99 : 352.960000 P100 : 373.000000 COUNT : 104 SUM : 10839 rocksdb.table.open.io.micros P50 : 787.142857 P95 : 16109.090909 P99 : 19522.000000 P100 : 19522.000000 COUNT : 162 SUM : 386783 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.580274 P95 : 6.563347 P99 : 9.945477 P100 : 4132.000000 COUNT : 1995795 SUM : 8917790 rocksdb.read.block.get.micros P50 : 367.716535 P95 : 4040.000000 P99 : 7694.000000 P100 : 7694.000000 COUNT : 324 SUM : 261122 rocksdb.write.raw.block.micros P50 : 0.511652 P95 : 0.972139 P99 : 2.950184 P100 : 4739.000000 COUNT : 3154867 SUM : 6010784 rocksdb.numfiles.in.singlecompaction P50 : 3.394737 P95 : 12.250000 P99 : 19.000000 P100 : 19.000000 COUNT : 31 SUM : 137 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.560199 P95 : 1177.394629 P99 : 2536.374429 P100 : 191701.000000 COUNT : 40117 SUM : 6085803 rocksdb.sst.read.micros P50 : 1.512484 P95 : 3.745111 P99 : 6.866261 P100 : 7382.000000 COUNT : 1996605 SUM : 4937705 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 : 4835999 SUM : 4990750968 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 : 177567.567568 P95 : 248594.594595 P99 : 348366.666667 P100 : 358573.000000 COUNT : 73 SUM : 13184374 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 : 98 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