[2024-07-16 00:22:21.103986] Starting SPDK v24.09-pre git sha1 fcbf7f00f / DPDK 24.03.0 initialization... [2024-07-16 00:22:21.104113] [ 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_pid2213539 ] Set seed to 1721082141101391 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-07-16 00:22:21.236053] app.c: 914:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-07-16 00:22:21.458125] app.c: 607:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-07-16 00:22:21.458181] app.c: 608:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 2213539' to capture a snapshot of events at runtime. [2024-07-16 00:22:21.458194] app.c: 613:app_setup_trace: *NOTICE*: 'spdk_trace' without parameters will also work if this is the only [2024-07-16 00:22:21.458208] app.c: 614:app_setup_trace: *NOTICE*: SPDK application currently running. [2024-07-16 00:22:21.458218] app.c: 615:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid2213539 for offline analysis/debug. [2024-07-16 00:22:21.458316] reactor.c: 941:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Tue Jul 16 00:22:25 2024 CPU: 72 * Intel(R) Xeon(R) Gold 6140 CPU @ 2.30GHz CPUCache: 25344 KB 2024/07/16-00:22:31 ... thread 0: (1000000,1000000) ops and (162805.0,162805.0) ops/second in (6.142317,6.142317) 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 12/10 1.08 GB 37.6 0.2 0.0 0.2 1.1 0.9 0.0 1.3 34.4 154.6 7.31 3.85 12 0.609 255K 1168 0.0 0.0 L1 8/8 1003.06 MB 0.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 L2 1/1 84.42 MB 0.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 L3 27/5 1.28 GB 1.0 2.1 1.1 1.0 2.0 1.0 0.0 1.8 129.6 121.6 16.98 10.51 8 2.123 1223K 6665 0.0 0.0 L4 142/15 10.58 GB 1.0 2.3 1.5 0.8 2.2 1.5 0.5 1.5 115.5 113.6 20.08 11.83 11 1.826 589K 0 0.0 0.0 L5 128/0 10.21 GB 0.1 0.0 0.0 0.0 0.0 0.0 1.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 318/39 24.22 GB 0.0 4.7 2.6 2.0 5.3 3.3 1.5 6.2 107.5 123.4 44.38 26.19 31 1.432 2068K 7833 0.0 0.0 Int 0/0 0.00 KB 0.0 4.7 2.6 2.0 5.3 3.3 1.5 6.2 107.5 123.4 44.38 26.19 31 1.432 2068K 7833 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 2.6 2.0 4.5 2.5 0.0 0.0 122.8 118.3 38.85 23.59 20 1.942 2068K 7833 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 159.1 5.53 2.59 11 0.503 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.2 total, 6.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: 5.35 GB write, 881.26 MB/s write, 4.66 GB read, 767.63 MB/s read, 44.4 seconds Interval compaction: 5.35 GB write, 891.47 MB/s write, 4.66 GB read, 776.52 MB/s read, 44.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: 22, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 22, interval: 22 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 81768 Average: 88.1810 StdDev: 729.22 Min: 1 Median: 2.2459 Max: 52009 Percentiles: P50: 2.25 P75: 3.60 P99: 1819.44 P99.9: 5448.79 P99.99: 31150.59 ------------------------------------------------------ [ 0, 1 ] 1895 2.318% 2.318% ( 1, 2 ] 33855 41.404% 43.721% ######## ( 2, 3 ] 20877 25.532% 69.253% ##### ( 3, 4 ] 7864 9.617% 78.871% ## ( 4, 6 ] 8031 9.822% 88.692% ## ( 6, 10 ] 1826 2.233% 90.926% ( 10, 15 ] 303 0.371% 91.296% ( 15, 22 ] 32 0.039% 91.335% ( 22, 34 ] 3 0.004% 91.339% ( 34, 51 ] 10 0.012% 91.351% ( 51, 76 ] 6 0.007% 91.358% ( 76, 110 ] 6 0.007% 91.366% ( 110, 170 ] 44 0.054% 91.420% ( 170, 250 ] 438 0.536% 91.955% ( 250, 380 ] 1236 1.512% 93.467% ( 380, 580 ] 2235 2.733% 96.200% # ( 580, 870 ] 1548 1.893% 98.093% ( 870, 1300 ] 596 0.729% 98.822% ( 1300, 1900 ] 169 0.207% 99.029% ( 1900, 2900 ] 323 0.395% 99.424% ( 2900, 4400 ] 354 0.433% 99.857% ( 4400, 6600 ] 76 0.093% 99.950% ( 6600, 9900 ] 16 0.020% 99.969% ( 9900, 14000 ] 4 0.005% 99.974% ( 14000, 22000 ] 8 0.010% 99.984% ( 22000, 33000 ] 7 0.009% 99.993% ( 33000, 50000 ] 12 0.015% 100.007% ( 50000, 75000 ] 1 0.001% 100.009% ** Level 1 read latency histogram (micros): Count: 182240 Average: 16.7714 StdDev: 293.88 Min: 1 Median: 2.2437 Max: 47040 Percentiles: P50: 2.24 P75: 3.25 P99: 63.62 P99.9: 3334.70 P99.99: 9395.10 ------------------------------------------------------ [ 0, 1 ] 1733 0.951% 0.951% ( 1, 2 ] 76321 41.879% 42.830% ######## ( 2, 3 ] 53627 29.427% 72.257% ###### ( 3, 4 ] 20256 11.115% 83.372% ## ( 4, 6 ] 21701 11.908% 95.280% ## ( 6, 10 ] 5324 2.921% 98.201% # ( 10, 15 ] 1200 0.658% 98.860% ( 15, 22 ] 176 0.097% 98.956% ( 22, 34 ] 31 0.017% 98.973% ( 34, 51 ] 39 0.021% 98.995% ( 51, 76 ] 21 0.012% 99.006% ( 76, 110 ] 10 0.005% 99.012% ( 110, 170 ] 21 0.012% 99.023% ( 170, 250 ] 89 0.049% 99.072% ( 250, 380 ] 259 0.142% 99.214% ( 380, 580 ] 460 0.252% 99.467% ( 580, 870 ] 342 0.188% 99.654% ( 870, 1300 ] 176 0.097% 99.751% ( 1300, 1900 ] 90 0.049% 99.800% ( 1900, 2900 ] 139 0.076% 99.877% ( 2900, 4400 ] 151 0.083% 99.959% ( 4400, 6600 ] 50 0.027% 99.987% ( 6600, 9900 ] 8 0.004% 99.991% ( 9900, 14000 ] 5 0.003% 99.994% ( 14000, 22000 ] 6 0.003% 99.997% ( 22000, 33000 ] 7 0.004% 100.001% ( 33000, 50000 ] 2 0.001% 100.002% ** Level 2 read latency histogram (micros): Count: 264494 Average: 11.3958 StdDev: 193.97 Min: 1 Median: 2.1711 Max: 31488 Percentiles: P50: 2.17 P75: 3.10 P99: 12.86 P99.9: 1448.52 P99.99: 3030.29 ------------------------------------------------------ [ 0, 1 ] 2981 1.127% 1.127% ( 1, 2 ] 116186 43.928% 45.055% ######### ( 2, 3 ] 76425 28.895% 73.950% ###### ( 3, 4 ] 28014 10.592% 84.541% ## ( 4, 6 ] 29855 11.288% 95.829% ## ( 6, 10 ] 7457 2.819% 98.648% # ( 10, 15 ] 1630 0.616% 99.264% ( 15, 22 ] 252 0.095% 99.360% ( 22, 34 ] 55 0.021% 99.380% ( 34, 51 ] 77 0.029% 99.409% ( 51, 76 ] 48 0.018% 99.428% ( 76, 110 ] 14 0.005% 99.433% ( 110, 170 ] 31 0.012% 99.445% ( 170, 250 ] 106 0.040% 99.485% ( 250, 380 ] 278 0.105% 99.590% ( 380, 580 ] 394 0.149% 99.739% ( 580, 870 ] 259 0.098% 99.837% ( 870, 1300 ] 143 0.054% 99.891% ( 1300, 1900 ] 99 0.037% 99.928% ( 1900, 2900 ] 150 0.057% 99.985% ( 2900, 4400 ] 156 0.059% 100.044% ( 4400, 6600 ] 38 0.014% 100.058% ( 6600, 9900 ] 7 0.003% 100.061% ( 9900, 14000 ] 2 0.001% 100.062% ( 14000, 22000 ] 7 0.003% 100.064% ( 22000, 33000 ] 4 0.002% 100.066% ** Level 3 read latency histogram (micros): Count: 480380 Average: 16.2749 StdDev: 346.94 Min: 1 Median: 2.2623 Max: 54071 Percentiles: P50: 2.26 P75: 3.21 P99: 14.71 P99.9: 989.21 P99.99: 1689.09 ------------------------------------------------------ [ 0, 1 ] 3754 0.781% 0.781% ( 1, 2 ] 197728 41.161% 41.942% ######## ( 2, 3 ] 147560 30.717% 72.660% ###### ( 3, 4 ] 53718 11.182% 83.842% ## ( 4, 6 ] 56995 11.865% 95.707% ## ( 6, 10 ] 13525 2.815% 98.522% # ( 10, 15 ] 2440 0.508% 99.030% ( 15, 22 ] 317 0.066% 99.096% ( 22, 34 ] 79 0.016% 99.112% ( 34, 51 ] 156 0.032% 99.145% ( 51, 76 ] 83 0.017% 99.162% ( 76, 110 ] 36 0.007% 99.170% ( 110, 170 ] 78 0.016% 99.186% ( 170, 250 ] 314 0.065% 99.251% ( 250, 380 ] 768 0.160% 99.411% ( 380, 580 ] 1315 0.274% 99.685% ( 580, 870 ] 923 0.192% 99.877% ( 870, 1300 ] 399 0.083% 99.960% ( 1300, 1900 ] 222 0.046% 100.006% ( 1900, 2900 ] 270 0.056% 100.062% ( 2900, 4400 ] 311 0.065% 100.127% ( 4400, 6600 ] 81 0.017% 100.144% ( 6600, 9900 ] 19 0.004% 100.148% ( 9900, 14000 ] 17 0.004% 100.152% ( 14000, 22000 ] 24 0.005% 100.157% ( 22000, 33000 ] 21 0.004% 100.161% ( 33000, 50000 ] 11 0.002% 100.163% ( 50000, 75000 ] 1 0.000% 100.163% ** Level 4 read latency histogram (micros): Count: 348912 Average: 38.6842 StdDev: 460.62 Min: 1 Median: 2.3218 Max: 78852 Percentiles: P50: 2.32 P75: 3.42 P99: 717.84 P99.9: 2668.48 P99.99: 3266.85 ------------------------------------------------------ [ 0, 1 ] 3158 0.905% 0.905% ( 1, 2 ] 137752 39.480% 40.386% ######## ( 2, 3 ] 104254 29.880% 70.265% ###### ( 3, 4 ] 39222 11.241% 81.507% ## ( 4, 6 ] 41660 11.940% 93.446% ## ( 6, 10 ] 10086 2.891% 96.337% # ( 10, 15 ] 1965 0.563% 96.900% ( 15, 22 ] 307 0.088% 96.988% ( 22, 34 ] 76 0.022% 97.010% ( 34, 51 ] 90 0.026% 97.036% ( 51, 76 ] 68 0.019% 97.055% ( 76, 110 ] 39 0.011% 97.067% ( 110, 170 ] 118 0.034% 97.100% ( 170, 250 ] 583 0.167% 97.268% ( 250, 380 ] 1804 0.517% 97.785% ( 380, 580 ] 3123 0.895% 98.680% ( 580, 870 ] 2356 0.675% 99.355% ( 870, 1300 ] 991 0.284% 99.639% ( 1300, 1900 ] 452 0.130% 99.768% ( 1900, 2900 ] 600 0.172% 99.940% ( 2900, 4400 ] 716 0.205% 100.146% ( 4400, 6600 ] 185 0.053% 100.199% ( 6600, 9900 ] 47 0.013% 100.212% ( 9900, 14000 ] 12 0.003% 100.216% ( 14000, 22000 ] 19 0.005% 100.221% ( 22000, 33000 ] 19 0.005% 100.226% ( 33000, 50000 ] 12 0.003% 100.230% ( 50000, 75000 ] 1 0.000% 100.230% ( 75000, 110000 ] 1 0.000% 100.230% ** Level 5 read latency histogram (micros): Count: 7943 Average: 954.3125 StdDev: 1315.47 Min: 104 Median: 562.8244 Max: 51998 Percentiles: P50: 562.82 P75: 891.70 P99: 5651.74 P99.9: 15208.00 P99.99: 51998.00 ------------------------------------------------------ ( 76, 110 ] 1 0.013% 0.013% ( 110, 170 ] 96 1.209% 1.221% ( 170, 250 ] 456 5.741% 6.962% # ( 250, 380 ] 1263 15.901% 22.863% ### ( 380, 580 ] 2358 29.687% 52.549% ###### ( 580, 870 ] 1746 21.982% 74.531% #### ( 870, 1300 ] 738 9.291% 83.822% ## ( 1300, 1900 ] 305 3.840% 87.662% # ( 1900, 2900 ] 369 4.646% 92.308% # ( 2900, 4400 ] 465 5.854% 98.162% # ( 4400, 6600 ] 117 1.473% 99.635% ( 6600, 9900 ] 17 0.214% 99.849% ( 9900, 14000 ] 3 0.038% 99.887% ( 14000, 22000 ] 7 0.088% 99.975% ( 22000, 33000 ] 1 0.013% 99.987% ( 50000, 75000 ] 1 0.013% 100.000% ** DB Stats ** Uptime(secs): 6.2 total, 6.1 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 158.34 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:1.529 H:M:S, 24.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 160.15 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:1.529 H:M:S, 24.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 8 num-running-flushes: 1 2024/07/16-00:22:35 ... thread 0: (1000000,2000000) ops and (238015.4,193353.9) ops/second in (4.201409,10.343726) 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/6 2.00 GB 162.9 1.3 0.0 1.3 3.1 1.8 0.0 1.7 79.3 188.3 16.66 10.96 31 0.537 1341K 6674 0.0 0.0 L2 0/0 0.00 KB 0.0 1.1 1.0 0.1 1.0 1.0 0.0 1.1 141.4 139.3 7.69 5.34 1 7.690 1104K 16K 0.0 0.0 L3 27/6 1.27 GB 1.0 3.1 2.0 1.1 3.0 1.9 0.2 1.5 144.9 138.4 21.94 14.96 11 1.995 2188K 9087 0.0 0.0 L4 144/16 10.11 GB 0.9 4.0 2.0 2.0 3.8 1.7 1.0 1.9 131.3 122.5 31.53 19.54 18 1.752 1218K 1804 0.0 0.0 L5 144/0 11.50 GB 0.1 0.0 0.0 0.0 0.0 0.0 2.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 330/28 24.87 GB 0.0 9.5 5.0 4.5 10.8 6.3 3.5 6.1 125.0 142.7 77.82 50.80 61 1.276 5853K 33K 0.0 0.0 Int 0/0 0.00 KB 0.0 9.5 5.0 4.5 10.8 6.3 3.5 6.1 125.0 142.7 77.82 50.80 61 1.276 5853K 33K 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 9.5 5.0 4.5 9.1 4.6 0.0 0.0 142.8 136.3 68.13 45.47 35 1.947 5853K 33K 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 188.2 9.69 5.33 26 0.373 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): 10.4 total, 10.3 interval Flush(GB): cumulative 1.781, interval 1.781 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 10.85 GB write, 1066.38 MB/s write, 9.50 GB read, 933.91 MB/s read, 77.8 seconds Interval compaction: 10.85 GB write, 1073.72 MB/s write, 9.50 GB read, 940.34 MB/s read, 77.8 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 23, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 23, interval: 23 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 358821 Average: 40.5166 StdDev: 401.69 Min: 1 Median: 1.9296 Max: 52009 Percentiles: P50: 1.93 P75: 2.93 P99: 755.30 P99.9: 3566.23 P99.99: 4932.03 ------------------------------------------------------ [ 0, 1 ] 14968 4.171% 4.171% # ( 1, 2 ] 176896 49.299% 53.471% ########## ( 2, 3 ] 83052 23.146% 76.616% ##### ( 3, 4 ] 28639 7.981% 84.598% ## ( 4, 6 ] 27745 7.732% 92.330% ## ( 6, 10 ] 5662 1.578% 93.908% ( 10, 15 ] 883 0.246% 94.154% ( 15, 22 ] 95 0.026% 94.181% ( 22, 34 ] 13 0.004% 94.184% ( 34, 51 ] 37 0.010% 94.195% ( 51, 76 ] 23 0.006% 94.201% ( 76, 110 ] 23 0.006% 94.207% ( 110, 170 ] 942 0.263% 94.470% ( 170, 250 ] 4450 1.240% 95.710% ( 250, 380 ] 4878 1.359% 97.070% ( 380, 580 ] 5123 1.428% 98.497% ( 580, 870 ] 2984 0.832% 99.329% ( 870, 1300 ] 972 0.271% 99.600% ( 1300, 1900 ] 313 0.087% 99.687% ( 1900, 2900 ] 527 0.147% 99.834% ( 2900, 4400 ] 534 0.149% 99.983% ( 4400, 6600 ] 108 0.030% 100.013% ( 6600, 9900 ] 19 0.005% 100.018% ( 9900, 14000 ] 7 0.002% 100.020% ( 14000, 22000 ] 10 0.003% 100.023% ( 22000, 33000 ] 10 0.003% 100.026% ( 33000, 50000 ] 15 0.004% 100.030% ( 50000, 75000 ] 1 0.000% 100.030% ** Level 1 read latency histogram (micros): Count: 256480 Average: 14.1108 StdDev: 252.26 Min: 1 Median: 2.1361 Max: 47040 Percentiles: P50: 2.14 P75: 3.01 P99: 140.39 P99.9: 2754.86 P99.99: 6531.59 ------------------------------------------------------ [ 0, 1 ] 3229 1.259% 1.259% ( 1, 2 ] 114965 44.824% 46.083% ######### ( 2, 3 ] 73826 28.784% 74.867% ###### ( 3, 4 ] 25820 10.067% 84.934% ## ( 4, 6 ] 27087 10.561% 95.496% ## ( 6, 10 ] 7148 2.787% 98.283% # ( 10, 15 ] 1477 0.576% 98.858% ( 15, 22 ] 201 0.078% 98.937% ( 22, 34 ] 32 0.012% 98.949% ( 34, 51 ] 42 0.016% 98.966% ( 51, 76 ] 21 0.008% 98.974% ( 76, 110 ] 12 0.005% 98.978% ( 110, 170 ] 109 0.042% 99.021% ( 170, 250 ] 350 0.136% 99.157% ( 250, 380 ] 473 0.184% 99.342% ( 380, 580 ] 596 0.232% 99.574% ( 580, 870 ] 421 0.164% 99.738% ( 870, 1300 ] 193 0.075% 99.814% ( 1300, 1900 ] 95 0.037% 99.851% ( 1900, 2900 ] 148 0.058% 99.908% ( 2900, 4400 ] 158 0.062% 99.970% ( 4400, 6600 ] 53 0.021% 99.991% ( 6600, 9900 ] 8 0.003% 99.994% ( 9900, 14000 ] 5 0.002% 99.996% ( 14000, 22000 ] 7 0.003% 99.998% ( 22000, 33000 ] 7 0.003% 100.001% ( 33000, 50000 ] 2 0.001% 100.002% ** Level 2 read latency histogram (micros): Count: 536441 Average: 8.5212 StdDev: 153.28 Min: 1 Median: 2.1239 Max: 31488 Percentiles: P50: 2.12 P75: 2.96 P99: 10.42 P99.9: 611.01 P99.99: 1162.85 ------------------------------------------------------ [ 0, 1 ] 4375 0.816% 0.816% ( 1, 2 ] 244020 45.489% 46.304% ######### ( 2, 3 ] 160047 29.835% 76.139% ###### ( 3, 4 ] 54250 10.113% 86.252% ## ( 4, 6 ] 54529 10.165% 96.417% ## ( 6, 10 ] 13645 2.544% 98.961% # ( 10, 15 ] 2493 0.465% 99.425% ( 15, 22 ] 336 0.063% 99.488% ( 22, 34 ] 75 0.014% 99.502% ( 34, 51 ] 122 0.023% 99.525% ( 51, 76 ] 62 0.012% 99.536% ( 76, 110 ] 22 0.004% 99.540% ( 110, 170 ] 102 0.019% 99.560% ( 170, 250 ] 468 0.087% 99.647% ( 250, 380 ] 670 0.125% 99.772% ( 380, 580 ] 646 0.120% 99.892% ( 580, 870 ] 398 0.074% 99.966% ( 870, 1300 ] 187 0.035% 100.001% ( 1300, 1900 ] 119 0.022% 100.023% ( 1900, 2900 ] 178 0.033% 100.056% ( 2900, 4400 ] 172 0.032% 100.089% ( 4400, 6600 ] 43 0.008% 100.097% ( 6600, 9900 ] 11 0.002% 100.099% ( 9900, 14000 ] 2 0.000% 100.099% ( 14000, 22000 ] 9 0.002% 100.101% ( 22000, 33000 ] 6 0.001% 100.102% ** Level 3 read latency histogram (micros): Count: 600634 Average: 16.4451 StdDev: 329.28 Min: 1 Median: 2.2275 Max: 54071 Percentiles: P50: 2.23 P75: 3.15 P99: 216.81 P99.9: 1060.28 P99.99: 1924.72 ------------------------------------------------------ [ 0, 1 ] 5481 0.913% 0.913% ( 1, 2 ] 253507 42.207% 43.119% ######## ( 2, 3 ] 181655 30.244% 73.363% ###### ( 3, 4 ] 64937 10.811% 84.174% ## ( 4, 6 ] 68048 11.329% 95.504% ## ( 6, 10 ] 16356 2.723% 98.227% # ( 10, 15 ] 2896 0.482% 98.709% ( 15, 22 ] 374 0.062% 98.771% ( 22, 34 ] 92 0.015% 98.787% ( 34, 51 ] 192 0.032% 98.819% ( 51, 76 ] 104 0.017% 98.836% ( 76, 110 ] 47 0.008% 98.844% ( 110, 170 ] 271 0.045% 98.889% ( 170, 250 ] 1141 0.190% 99.079% ( 250, 380 ] 1509 0.251% 99.330% ( 380, 580 ] 1953 0.325% 99.655% ( 580, 870 ] 1250 0.208% 99.863% ( 870, 1300 ] 498 0.083% 99.946% ( 1300, 1900 ] 255 0.042% 99.989% ( 1900, 2900 ] 321 0.053% 100.042% ( 2900, 4400 ] 372 0.062% 100.104% ( 4400, 6600 ] 89 0.015% 100.119% ( 6600, 9900 ] 23 0.004% 100.123% ( 9900, 14000 ] 19 0.003% 100.126% ( 14000, 22000 ] 26 0.004% 100.130% ( 22000, 33000 ] 23 0.004% 100.134% ( 33000, 50000 ] 13 0.002% 100.136% ( 50000, 75000 ] 1 0.000% 100.136% ** Level 4 read latency histogram (micros): Count: 691730 Average: 32.6910 StdDev: 382.34 Min: 1 Median: 2.3174 Max: 78852 Percentiles: P50: 2.32 P75: 3.45 P99: 590.59 P99.9: 2231.79 P99.99: 2924.94 ------------------------------------------------------ [ 0, 1 ] 6226 0.900% 0.900% ( 1, 2 ] 275119 39.773% 40.673% ######## ( 2, 3 ] 203297 29.390% 70.062% ###### ( 3, 4 ] 76699 11.088% 81.150% ## ( 4, 6 ] 81122 11.727% 92.878% ## ( 6, 10 ] 19756 2.856% 95.734% # ( 10, 15 ] 3796 0.549% 96.283% ( 15, 22 ] 538 0.078% 96.360% ( 22, 34 ] 140 0.020% 96.381% ( 34, 51 ] 263 0.038% 96.419% ( 51, 76 ] 151 0.022% 96.440% ( 76, 110 ] 101 0.015% 96.455% ( 110, 170 ] 1146 0.166% 96.621% ( 170, 250 ] 4685 0.677% 97.298% ( 250, 380 ] 5579 0.807% 98.104% ( 380, 580 ] 6058 0.876% 98.980% ( 580, 870 ] 3936 0.569% 99.549% ( 870, 1300 ] 1463 0.211% 99.761% ( 1300, 1900 ] 669 0.097% 99.857% ( 1900, 2900 ] 908 0.131% 99.989% ( 2900, 4400 ] 952 0.138% 100.126% ( 4400, 6600 ] 228 0.033% 100.159% ( 6600, 9900 ] 64 0.009% 100.169% ( 9900, 14000 ] 14 0.002% 100.171% ( 14000, 22000 ] 37 0.005% 100.176% ( 22000, 33000 ] 32 0.005% 100.181% ( 33000, 50000 ] 13 0.002% 100.182% ( 50000, 75000 ] 2 0.000% 100.183% ( 75000, 110000 ] 1 0.000% 100.183% ** Level 5 read latency histogram (micros): Count: 18490 Average: 685.6076 StdDev: 1185.27 Min: 96 Median: 414.5058 Max: 51998 Percentiles: P50: 414.51 P75: 674.39 P99: 4370.79 P99.9: 15342.22 P99.99: 42783.50 ------------------------------------------------------ ( 76, 110 ] 27 0.146% 0.146% ( 110, 170 ] 877 4.743% 4.889% # ( 170, 250 ] 3561 19.259% 24.148% #### ( 250, 380 ] 4005 21.660% 45.809% #### ( 380, 580 ] 4492 24.294% 70.103% ##### ( 580, 870 ] 2782 15.046% 85.149% ### ( 870, 1300 ] 1014 5.484% 90.633% # ( 1300, 1900 ] 410 2.217% 92.850% ( 1900, 2900 ] 538 2.910% 95.760% # ( 2900, 4400 ] 611 3.304% 99.064% # ( 4400, 6600 ] 128 0.692% 99.757% ( 6600, 9900 ] 22 0.119% 99.876% ( 9900, 14000 ] 3 0.016% 99.892% ( 14000, 22000 ] 9 0.049% 99.941% ( 22000, 33000 ] 8 0.043% 99.984% ( 33000, 50000 ] 2 0.011% 99.995% ( 50000, 75000 ] 1 0.005% 100.000% ** DB Stats ** Uptime(secs): 10.4 total, 4.2 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 188.96 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:1.533 H:M:S, 14.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 234.25 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.004 H:M:S, 0.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 7 num-running-flushes: 1 2024/07/16-00:22:40 ... thread 0: (1000000,3000000) ops and (181884.6,189373.4) ops/second in (5.497991,15.841717) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 19/10 3.04 GB 187.8 2.3 0.0 2.3 5.1 2.8 0.0 1.8 98.4 217.1 24.28 17.87 51 0.476 2427K 12K 0.0 0.0 L2 0/0 0.00 KB 0.0 1.1 1.0 0.1 1.0 1.0 0.0 1.1 141.4 139.3 7.69 5.34 1 7.690 1104K 16K 0.0 0.0 L3 21/0 993.39 MB 1.0 3.1 2.0 1.1 3.0 1.9 0.2 1.5 144.9 138.4 21.94 14.96 11 1.995 2188K 9087 0.0 0.0 L4 141/0 9.49 GB 1.0 5.7 2.3 3.4 5.1 1.7 1.0 2.2 141.6 127.8 41.17 26.59 24 1.715 1526K 1804 0.0 0.0 L5 152/0 12.13 GB 0.1 0.0 0.0 0.0 0.0 0.0 2.9 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 333/10 25.63 GB 0.0 12.2 5.3 6.9 14.3 7.4 4.1 5.1 131.3 154.0 95.08 64.76 87 1.093 7246K 39K 0.0 0.0 Int 0/0 0.00 KB 0.0 12.2 5.3 6.9 14.3 7.4 4.1 5.1 131.3 154.0 95.08 64.76 87 1.093 7246K 39K 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 12.2 5.3 6.9 11.5 4.6 0.0 0.0 152.4 143.3 81.95 56.56 45 1.821 7246K 39K 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 220.3 13.14 8.20 42 0.313 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 15.9 total, 15.8 interval Flush(GB): cumulative 2.825, interval 2.825 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: 14.30 GB write, 919.93 MB/s write, 12.19 GB read, 784.59 MB/s read, 95.1 seconds Interval compaction: 14.30 GB write, 924.06 MB/s write, 12.19 GB read, 788.11 MB/s read, 95.1 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 3, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 3, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 25, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 3, total-stops: 25, interval: 28 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 709254 Average: 33.7687 StdDev: 291.82 Min: 1 Median: 1.7245 Max: 52009 Percentiles: P50: 1.72 P75: 2.67 P99: 539.45 P99.9: 2221.55 P99.99: 3600.20 ------------------------------------------------------ [ 0, 1 ] 87490 12.335% 12.335% ## ( 1, 2 ] 368699 51.984% 64.320% ########## ( 2, 3 ] 112782 15.901% 80.221% ### ( 3, 4 ] 37040 5.222% 85.443% # ( 4, 6 ] 33150 4.674% 90.117% # ( 6, 10 ] 7461 1.052% 91.169% ( 10, 15 ] 1143 0.161% 91.330% ( 15, 22 ] 133 0.019% 91.349% ( 22, 34 ] 30 0.004% 91.353% ( 34, 51 ] 37 0.005% 91.359% ( 51, 76 ] 25 0.004% 91.362% ( 76, 110 ] 468 0.066% 91.428% ( 110, 170 ] 12295 1.734% 93.162% ( 170, 250 ] 27290 3.848% 97.009% # ( 250, 380 ] 8830 1.245% 98.254% ( 380, 580 ] 6636 0.936% 99.190% ( 580, 870 ] 3456 0.487% 99.677% ( 870, 1300 ] 1069 0.151% 99.828% ( 1300, 1900 ] 333 0.047% 99.875% ( 1900, 2900 ] 559 0.079% 99.954% ( 2900, 4400 ] 555 0.078% 100.032% ( 4400, 6600 ] 109 0.015% 100.047% ( 6600, 9900 ] 19 0.003% 100.050% ( 9900, 14000 ] 7 0.001% 100.051% ( 14000, 22000 ] 10 0.001% 100.052% ( 22000, 33000 ] 10 0.001% 100.054% ( 33000, 50000 ] 15 0.002% 100.056% ( 50000, 75000 ] 1 0.000% 100.056% ** Level 1 read latency histogram (micros): Count: 256480 Average: 14.1108 StdDev: 252.26 Min: 1 Median: 2.1361 Max: 47040 Percentiles: P50: 2.14 P75: 3.01 P99: 140.39 P99.9: 2754.86 P99.99: 6531.59 ------------------------------------------------------ [ 0, 1 ] 3229 1.259% 1.259% ( 1, 2 ] 114965 44.824% 46.083% ######### ( 2, 3 ] 73826 28.784% 74.867% ###### ( 3, 4 ] 25820 10.067% 84.934% ## ( 4, 6 ] 27087 10.561% 95.496% ## ( 6, 10 ] 7148 2.787% 98.283% # ( 10, 15 ] 1477 0.576% 98.858% ( 15, 22 ] 201 0.078% 98.937% ( 22, 34 ] 32 0.012% 98.949% ( 34, 51 ] 42 0.016% 98.966% ( 51, 76 ] 21 0.008% 98.974% ( 76, 110 ] 12 0.005% 98.978% ( 110, 170 ] 109 0.042% 99.021% ( 170, 250 ] 350 0.136% 99.157% ( 250, 380 ] 473 0.184% 99.342% ( 380, 580 ] 596 0.232% 99.574% ( 580, 870 ] 421 0.164% 99.738% ( 870, 1300 ] 193 0.075% 99.814% ( 1300, 1900 ] 95 0.037% 99.851% ( 1900, 2900 ] 148 0.058% 99.908% ( 2900, 4400 ] 158 0.062% 99.970% ( 4400, 6600 ] 53 0.021% 99.991% ( 6600, 9900 ] 8 0.003% 99.994% ( 9900, 14000 ] 5 0.002% 99.996% ( 14000, 22000 ] 7 0.003% 99.998% ( 22000, 33000 ] 7 0.003% 100.001% ( 33000, 50000 ] 2 0.001% 100.002% ** Level 2 read latency histogram (micros): Count: 536441 Average: 8.5212 StdDev: 153.28 Min: 1 Median: 2.1239 Max: 31488 Percentiles: P50: 2.12 P75: 2.96 P99: 10.42 P99.9: 611.01 P99.99: 1162.85 ------------------------------------------------------ [ 0, 1 ] 4375 0.816% 0.816% ( 1, 2 ] 244020 45.489% 46.304% ######### ( 2, 3 ] 160047 29.835% 76.139% ###### ( 3, 4 ] 54250 10.113% 86.252% ## ( 4, 6 ] 54529 10.165% 96.417% ## ( 6, 10 ] 13645 2.544% 98.961% # ( 10, 15 ] 2493 0.465% 99.425% ( 15, 22 ] 336 0.063% 99.488% ( 22, 34 ] 75 0.014% 99.502% ( 34, 51 ] 122 0.023% 99.525% ( 51, 76 ] 62 0.012% 99.536% ( 76, 110 ] 22 0.004% 99.540% ( 110, 170 ] 102 0.019% 99.560% ( 170, 250 ] 468 0.087% 99.647% ( 250, 380 ] 670 0.125% 99.772% ( 380, 580 ] 646 0.120% 99.892% ( 580, 870 ] 398 0.074% 99.966% ( 870, 1300 ] 187 0.035% 100.001% ( 1300, 1900 ] 119 0.022% 100.023% ( 1900, 2900 ] 178 0.033% 100.056% ( 2900, 4400 ] 172 0.032% 100.089% ( 4400, 6600 ] 43 0.008% 100.097% ( 6600, 9900 ] 11 0.002% 100.099% ( 9900, 14000 ] 2 0.000% 100.099% ( 14000, 22000 ] 9 0.002% 100.101% ( 22000, 33000 ] 6 0.001% 100.102% ** Level 3 read latency histogram (micros): Count: 644112 Average: 18.1273 StdDev: 319.32 Min: 1 Median: 2.2411 Max: 54071 Percentiles: P50: 2.24 P75: 3.23 P99: 264.83 P99.9: 1035.23 P99.99: 1892.07 ------------------------------------------------------ [ 0, 1 ] 6027 0.936% 0.936% ( 1, 2 ] 269834 41.892% 42.828% ######## ( 2, 3 ] 191587 29.744% 72.572% ###### ( 3, 4 ] 68847 10.689% 83.261% ## ( 4, 6 ] 72142 11.200% 94.461% ## ( 6, 10 ] 17247 2.678% 97.139% # ( 10, 15 ] 2998 0.465% 97.604% ( 15, 22 ] 386 0.060% 97.664% ( 22, 34 ] 95 0.015% 97.679% ( 34, 51 ] 200 0.031% 97.710% ( 51, 76 ] 108 0.017% 97.727% ( 76, 110 ] 143 0.022% 97.749% ( 110, 170 ] 2542 0.395% 98.144% ( 170, 250 ] 5259 0.816% 98.960% ( 250, 380 ] 2243 0.348% 99.309% ( 380, 580 ] 2244 0.348% 99.657% ( 580, 870 ] 1363 0.212% 99.869% ( 870, 1300 ] 528 0.082% 99.950% ( 1300, 1900 ] 258 0.040% 99.991% ( 1900, 2900 ] 332 0.052% 100.042% ( 2900, 4400 ] 380 0.059% 100.101% ( 4400, 6600 ] 89 0.014% 100.115% ( 6600, 9900 ] 23 0.004% 100.118% ( 9900, 14000 ] 19 0.003% 100.121% ( 14000, 22000 ] 26 0.004% 100.125% ( 22000, 33000 ] 23 0.004% 100.129% ( 33000, 50000 ] 13 0.002% 100.131% ( 50000, 75000 ] 1 0.000% 100.131% ** Level 4 read latency histogram (micros): Count: 899318 Average: 34.2482 StdDev: 338.94 Min: 0 Median: 2.3533 Max: 78852 Percentiles: P50: 2.35 P75: 3.64 P99: 531.47 P99.9: 1571.19 P99.99: 2356.94 ------------------------------------------------------ [ 0, 1 ] 8599 0.956% 0.956% ( 1, 2 ] 351687 39.106% 40.062% ######## ( 2, 3 ] 252966 28.129% 68.191% ###### ( 3, 4 ] 96230 10.700% 78.891% ## ( 4, 6 ] 100317 11.155% 90.046% ## ( 6, 10 ] 24409 2.714% 92.760% # ( 10, 15 ] 4485 0.499% 93.259% ( 15, 22 ] 614 0.068% 93.327% ( 22, 34 ] 152 0.017% 93.344% ( 34, 51 ] 307 0.034% 93.378% ( 51, 76 ] 180 0.020% 93.398% ( 76, 110 ] 607 0.067% 93.466% ( 110, 170 ] 11372 1.265% 94.730% ( 170, 250 ] 23858 2.653% 97.383% # ( 250, 380 ] 8903 0.990% 98.373% ( 380, 580 ] 7447 0.828% 99.201% ( 580, 870 ] 4407 0.490% 99.691% ( 870, 1300 ] 1566 0.174% 99.865% ( 1300, 1900 ] 694 0.077% 99.942% ( 1900, 2900 ] 939 0.104% 100.047% ( 2900, 4400 ] 974 0.108% 100.155% ( 4400, 6600 ] 229 0.025% 100.181% ( 6600, 9900 ] 64 0.007% 100.188% ( 9900, 14000 ] 14 0.002% 100.189% ( 14000, 22000 ] 37 0.004% 100.193% ( 22000, 33000 ] 32 0.004% 100.197% ( 33000, 50000 ] 13 0.001% 100.198% ( 50000, 75000 ] 2 0.000% 100.199% ( 75000, 110000 ] 1 0.000% 100.199% ** Level 5 read latency histogram (micros): Count: 45845 Average: 404.2230 StdDev: 795.63 Min: 92 Median: 228.4034 Max: 51998 Percentiles: P50: 228.40 P75: 379.77 P99: 3717.54 P99.9: 6585.70 P99.99: 30821.31 ------------------------------------------------------ ( 76, 110 ] 431 0.940% 0.940% ( 110, 170 ] 8939 19.498% 20.438% #### ( 170, 250 ] 18564 40.493% 60.931% ######## ( 250, 380 ] 6461 14.093% 75.025% ### ( 380, 580 ] 5468 11.927% 86.952% ## ( 580, 870 ] 3119 6.803% 93.755% # ( 870, 1300 ] 1076 2.347% 96.102% ( 1300, 1900 ] 425 0.927% 97.029% ( 1900, 2900 ] 564 1.230% 98.259% ( 2900, 4400 ] 623 1.359% 99.618% ( 4400, 6600 ] 130 0.284% 99.902% ( 6600, 9900 ] 22 0.048% 99.950% ( 9900, 14000 ] 3 0.007% 99.956% ( 14000, 22000 ] 9 0.020% 99.976% ( 22000, 33000 ] 8 0.017% 99.993% ( 33000, 50000 ] 2 0.004% 99.998% ( 50000, 75000 ] 1 0.002% 100.000% ** DB Stats ** Uptime(secs): 15.9 total, 5.5 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 185.52 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:3.230 H:M:S, 20.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 179.01 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:1.697 H:M:S, 30.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 0 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] readwhilewriting : 394.198 micros/op 10133 ops/sec 20.132 seconds 203996 operations; 9.8 MB/s (50999 of 50999 found) Microseconds per read: Count: 203996 Average: 394.2144 StdDev: 1143.77 Min: 2 Median: 237.6653 Max: 114583 Percentiles: P50: 237.67 P75: 375.66 P99: 3183.96 P99.9: 17032.52 P99.99: 46328.27 ------------------------------------------------------ ( 1, 2 ] 8 0.004% 0.004% ( 2, 3 ] 65 0.032% 0.036% ( 3, 4 ] 97 0.048% 0.083% ( 4, 6 ] 205 0.100% 0.184% ( 6, 10 ] 312 0.153% 0.337% ( 10, 15 ] 1637 0.802% 1.139% ( 15, 22 ] 2719 1.333% 2.472% ( 22, 34 ] 4283 2.100% 4.572% ( 34, 51 ] 1495 0.733% 5.305% ( 51, 76 ] 229 0.112% 5.417% ( 76, 110 ] 78 0.038% 5.455% ( 110, 170 ] 16044 7.865% 13.320% ## ( 170, 250 ] 88466 43.367% 56.686% ######### ( 250, 380 ] 38649 18.946% 75.632% #### ( 380, 580 ] 27549 13.505% 89.137% ### ( 580, 870 ] 12428 6.092% 95.229% # ( 870, 1300 ] 4476 2.194% 97.423% ( 1300, 1900 ] 1557 0.763% 98.187% ( 1900, 2900 ] 1380 0.676% 98.863% ( 2900, 4400 ] 1474 0.723% 99.586% ( 4400, 6600 ] 353 0.173% 99.759% ( 6600, 9900 ] 158 0.077% 99.836% ( 9900, 14000 ] 83 0.041% 99.877% ( 14000, 22000 ] 124 0.061% 99.938% ( 22000, 33000 ] 87 0.043% 99.980% ( 33000, 50000 ] 25 0.012% 99.993% ( 50000, 75000 ] 11 0.005% 99.998% ( 75000, 110000 ] 3 0.001% 100.000% ( 110000, 170000 ] 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 : 3365041 rocksdb.bloom.filter.full.positive COUNT : 236132 rocksdb.bloom.filter.full.true.positive COUNT : 203119 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 : 877 rocksdb.memtable.miss COUNT : 203119 rocksdb.l0.hit COUNT : 24369 rocksdb.l1.hit COUNT : 1649 rocksdb.l2andup.hit COUNT : 177101 rocksdb.compaction.key.drop.new COUNT : 766477 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 : 3444124 rocksdb.number.keys.read COUNT : 203996 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 3554335968 rocksdb.bytes.read COUNT : 203996000 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 : 504 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 5811445 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 : 14632638911 rocksdb.compact.write.bytes COUNT : 13836318631 rocksdb.flush.write.bytes COUNT : 3495562766 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 : 33 rocksdb.number.superversion_acquires COUNT : 664 rocksdb.number.superversion_releases COUNT : 642 rocksdb.number.superversion_cleanups COUNT : 163 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 : 19 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 : 3472801792 rocksdb.memtable.garbage.bytes.at.flush COUNT : 6320128 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 : 14552682105 rocksdb.non.last.level.read.count COUNT : 3487698 rocksdb.block.checksum.compute.count COUNT : 3783456 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 : 237.081663 P95 : 858.537605 P99 : 3182.944369 P100 : 114582.000000 COUNT : 203996 SUM : 80257311 rocksdb.db.write.micros P50 : 1.632160 P95 : 5.149647 P99 : 7.996489 P100 : 557132.000000 COUNT : 3444124 SUM : 15475748 rocksdb.compaction.times.micros P50 : 1622916.666667 P95 : 3810000.000000 P99 : 7690133.000000 P100 : 7690133.000000 COUNT : 47 SUM : 85887281 rocksdb.compaction.times.cpu_micros P50 : 1247727.272727 P95 : 3355000.000000 P99 : 5336168.000000 P100 : 5336168.000000 COUNT : 47 SUM : 60451358 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 : 856.818182 P95 : 2787.500000 P99 : 10444.000000 P100 : 10444.000000 COUNT : 49 SUM : 62806 rocksdb.compaction.outfile.sync.micros P50 : 1632.142857 P95 : 7608.333333 P99 : 11335.000000 P100 : 71108.000000 COUNT : 165 SUM : 474244 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 : 198.965517 P95 : 802.772727 P99 : 2845.000000 P100 : 4282.000000 COUNT : 111 SUM : 37954 rocksdb.table.open.io.micros P50 : 5833.333333 P95 : 19164.912281 P99 : 21994.385965 P100 : 27532.000000 COUNT : 504 SUM : 3455864 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 : 4.269435 P95 : 9.727373 P99 : 227.299837 P100 : 52014.000000 COUNT : 3543918 SUM : 54430237 rocksdb.read.block.get.micros P50 : 207.895706 P95 : 752.869308 P99 : 2793.600526 P100 : 78857.000000 COUNT : 239094 SUM : 72140472 rocksdb.write.raw.block.micros P50 : 0.530972 P95 : 1.226242 P99 : 3.636045 P100 : 93234.000000 COUNT : 4199484 SUM : 14611263 rocksdb.numfiles.in.singlecompaction P50 : 3.185714 P95 : 3.995714 P99 : 11.000000 P100 : 11.000000 COUNT : 63 SUM : 231 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.559950 P95 : 1128.000000 P99 : 2103.746835 P100 : 556945.000000 COUNT : 32252 SUM : 5813794 rocksdb.sst.read.micros P50 : 2.034247 P95 : 194.981334 P99 : 512.849366 P100 : 78852.000000 COUNT : 3487841 SUM : 112337245 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 : 1000.000000 P95 : 1000.000000 P99 : 1000.000000 P100 : 1000.000000 COUNT : 203996 SUM : 203996000 rocksdb.bytes.per.write P50 : 1032.000000 P95 : 1032.000000 P99 : 1032.000000 P100 : 1032.000000 COUNT : 3444124 SUM : 3554335968 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 : 232666.666667 P95 : 623166.666667 P99 : 812633.333333 P100 : 859285.000000 COUNT : 49 SUM : 14456960 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 : 170 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