[2024-10-17 18:25:55.519254] Starting SPDK v25.01-pre git sha1 1ab56c2bd / DPDK 24.03.0 initialization... [2024-10-17 18:25:55.519428] [ 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_pid815237 ] Set seed to 1729182355515666 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-10-17 18:25:55.653252] app.c: 919:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-10-17 18:25:55.759545] app.c: 612:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-10-17 18:25:55.759599] app.c: 613:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 815237' to capture a snapshot of events at runtime. [2024-10-17 18:25:55.759628] app.c: 618:app_setup_trace: *NOTICE*: 'spdk_trace' without parameters will also work if this is the only [2024-10-17 18:25:55.759642] app.c: 619:app_setup_trace: *NOTICE*: SPDK application currently running. [2024-10-17 18:25:55.759653] app.c: 620:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid815237 for offline analysis/debug. [2024-10-17 18:25:55.760939] reactor.c:1005:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Thu Oct 17 18:25:58 2024 CPU: 72 * Intel(R) Xeon(R) Gold 6140 CPU @ 2.30GHz CPUCache: 25344 KB 2024/10/17-18:26:01 ... thread 0: (1000000,1000000) ops and (329638.6,329638.6) ops/second in (3.033625,3.033625) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 8/5 503.30 MB 18.9 0.0 0.0 0.0 0.9 0.9 0.0 1.0 0.0 341.4 2.58 2.41 13 0.198 0 0 0.0 0.0 L1 1/0 10.94 MB 1.1 0.2 0.2 0.0 0.2 0.2 0.1 1.0 232.1 231.2 1.08 1.04 1 1.083 255K 982 0.0 0.0 L2 3/2 279.62 MB 1.1 0.3 0.1 0.1 0.3 0.1 0.2 2.0 247.1 246.7 1.05 1.02 2 0.523 262K 461 0.0 0.0 L3 18/12 938.97 MB 0.1 0.1 0.1 0.0 0.1 0.1 0.0 1.0 219.6 219.6 0.55 0.53 1 0.547 121K 0 0.0 0.0 L4 120/0 9.47 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 116/0 8.92 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 266/19 20.09 GB 0.0 0.6 0.5 0.1 1.5 1.3 0.4 1.7 119.9 287.2 5.25 4.99 17 0.309 639K 1443 0.0 0.0 Int 0/0 0.00 KB 0.0 0.6 0.5 0.1 1.5 1.3 0.4 1.7 119.9 287.2 5.25 4.99 17 0.309 639K 1443 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.6 0.5 0.1 0.6 0.5 0.0 0.0 235.4 234.9 2.68 2.58 4 0.669 639K 1443 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 341.4 2.58 2.41 13 0.198 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.0 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.47 GB write, 481.67 MB/s write, 0.62 GB read, 201.06 MB/s read, 5.3 seconds Interval compaction: 1.47 GB write, 496.97 MB/s write, 0.62 GB read, 207.44 MB/s read, 5.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: 135128 Average: 2.0822 StdDev: 5.92 Min: 0 Median: 1.4291 Max: 1511 Percentiles: P50: 1.43 P75: 1.82 P99: 5.73 P99.9: 11.80 P99.99: 199.91 ------------------------------------------------------ [ 0, 1 ] 30403 22.499% 22.499% #### ( 1, 2 ] 86596 64.084% 86.584% ############# ( 2, 3 ] 11287 8.353% 94.937% ## ( 3, 4 ] 3637 2.692% 97.628% # ( 4, 6 ] 2145 1.587% 99.216% ( 6, 10 ] 870 0.644% 99.859% ( 10, 15 ] 155 0.115% 99.974% ( 15, 22 ] 11 0.008% 99.982% ( 22, 34 ] 4 0.003% 99.985% ( 34, 51 ] 1 0.001% 99.986% ( 51, 76 ] 2 0.001% 99.987% ( 170, 250 ] 12 0.009% 99.996% ( 250, 380 ] 8 0.006% 100.002% ( 380, 580 ] 5 0.004% 100.006% ( 1300, 1900 ] 1 0.001% 100.007% ** Level 1 read latency histogram (micros): Count: 1533 Average: 4.5910 StdDev: 28.11 Min: 1 Median: 1.9814 Max: 680 Percentiles: P50: 1.98 P75: 2.86 P99: 14.56 P99.9: 647.72 P99.99: 680.00 ------------------------------------------------------ [ 0, 1 ] 56 3.653% 3.653% # ( 1, 2 ] 726 47.358% 51.011% ######### ( 2, 3 ] 428 27.919% 78.930% ###### ( 3, 4 ] 131 8.545% 87.476% ## ( 4, 6 ] 98 6.393% 93.868% # ( 6, 10 ] 46 3.001% 96.869% # ( 10, 15 ] 38 2.479% 99.348% ( 15, 22 ] 5 0.326% 99.674% ( 22, 34 ] 1 0.065% 99.739% ( 34, 51 ] 1 0.065% 99.804% ( 51, 76 ] 1 0.065% 99.870% ( 380, 580 ] 2 0.130% 100.000% ( 580, 870 ] 2 0.130% 100.130% ** Level 2 read latency histogram (micros): Count: 64172 Average: 2.3101 StdDev: 8.28 Min: 0 Median: 1.4603 Max: 1084 Percentiles: P50: 1.46 P75: 1.85 P99: 7.71 P99.9: 89.63 P99.99: 301.44 ------------------------------------------------------ [ 0, 1 ] 13079 20.381% 20.381% #### ( 1, 2 ] 41290 64.343% 84.724% ############# ( 2, 3 ] 5854 9.122% 93.846% ## ( 3, 4 ] 1699 2.648% 96.494% # ( 4, 6 ] 1350 2.104% 98.598% ( 6, 10 ] 605 0.943% 99.540% ( 10, 15 ] 186 0.290% 99.830% ( 15, 22 ] 20 0.031% 99.861% ( 22, 34 ] 6 0.009% 99.871% ( 34, 51 ] 4 0.006% 99.877% ( 51, 76 ] 2 0.003% 99.880% ( 76, 110 ] 32 0.050% 99.930% ( 110, 170 ] 27 0.042% 99.972% ( 170, 250 ] 10 0.016% 99.988% ( 250, 380 ] 4 0.006% 99.994% ( 380, 580 ] 1 0.002% 99.995% ( 580, 870 ] 1 0.002% 99.997% ( 870, 1300 ] 2 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 1967 Average: 70.5928 StdDev: 497.41 Min: 1 Median: 2.5185 Max: 7197 Percentiles: P50: 2.52 P75: 3.83 P99: 2661.43 P99.9: 6296.09 P99.99: 7197.00 ------------------------------------------------------ [ 0, 1 ] 49 2.491% 2.491% ( 1, 2 ] 626 31.825% 34.316% ###### ( 2, 3 ] 595 30.249% 64.565% ###### ( 3, 4 ] 248 12.608% 77.173% ### ( 4, 6 ] 217 11.032% 88.205% ## ( 6, 10 ] 68 3.457% 91.662% # ( 10, 15 ] 30 1.525% 93.188% ( 15, 22 ] 13 0.661% 93.849% ( 22, 34 ] 2 0.102% 93.950% ( 34, 51 ] 2 0.102% 94.052% ( 76, 110 ] 3 0.153% 94.204% ( 110, 170 ] 52 2.644% 96.848% # ( 170, 250 ] 16 0.813% 97.661% ( 250, 380 ] 3 0.153% 97.814% ( 380, 580 ] 2 0.102% 97.916% ( 580, 870 ] 10 0.508% 98.424% ( 870, 1300 ] 1 0.051% 98.475% ( 1300, 1900 ] 5 0.254% 98.729% ( 1900, 2900 ] 7 0.356% 99.085% ( 2900, 4400 ] 10 0.508% 99.593% ( 4400, 6600 ] 7 0.356% 99.949% ( 6600, 9900 ] 2 0.102% 100.051% ** Level 4 read latency histogram (micros): Count: 25 Average: 3468.2000 StdDev: 1764.33 Min: 666 Median: 3087.5000 Max: 7260 Percentiles: P50: 3087.50 P75: 5264.29 P99: 7260.00 P99.9: 7260.00 P99.99: 7260.00 ------------------------------------------------------ ( 580, 870 ] 1 4.000% 4.000% # ( 870, 1300 ] 1 4.000% 8.000% # ( 1300, 1900 ] 3 12.000% 20.000% ## ( 1900, 2900 ] 7 28.000% 48.000% ###### ( 2900, 4400 ] 4 16.000% 64.000% ### ( 4400, 6600 ] 7 28.000% 92.000% ###### ( 6600, 9900 ] 2 8.000% 100.000% ## ** DB Stats ** Uptime(secs): 3.1 total, 3.0 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 314.15 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.153 H:M:S, 4.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 324.05 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.153 H:M:S, 5.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/10/17-18:26:04 ... thread 0: (1000000,2000000) ops and (337379.5,333464.2) ops/second in (2.964021,5.997646) 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/4 1.41 GB 118.9 1.0 0.0 1.0 2.8 1.8 0.0 1.6 111.5 301.0 9.59 9.13 32 0.300 1086K 5779 0.0 0.0 L1 1/0 10.94 MB 1.1 0.2 0.2 0.0 0.2 0.2 0.1 1.0 232.1 231.2 1.08 1.04 1 1.083 255K 982 0.0 0.0 L2 1/1 40.18 MB 0.0 0.3 0.1 0.1 0.3 0.1 0.2 2.0 247.1 246.7 1.05 1.02 2 0.523 262K 461 0.0 0.0 L3 19/10 1.15 GB 0.4 0.5 0.4 0.1 0.5 0.3 0.0 1.4 218.0 217.4 2.30 2.24 3 0.767 509K 1515 0.0 0.0 L4 120/0 9.47 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 116/0 8.92 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 267/15 21.00 GB 0.0 2.0 0.7 1.3 3.8 2.5 0.4 2.1 148.4 277.9 14.02 13.42 38 0.369 2113K 8737 0.0 0.0 Int 0/0 0.00 KB 0.0 2.0 0.7 1.3 3.8 2.5 0.4 2.1 148.4 277.9 14.02 13.42 38 0.369 2113K 8737 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.0 0.7 1.3 2.0 0.7 0.0 0.0 238.0 236.9 8.75 8.53 10 0.875 2113K 8737 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 345.7 5.28 4.89 28 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): 6.1 total, 6.0 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: 3.81 GB write, 639.16 MB/s write, 2.03 GB read, 341.39 MB/s read, 14.0 seconds Interval compaction: 3.81 GB write, 649.43 MB/s write, 2.03 GB read, 346.88 MB/s read, 14.0 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: 395682 Average: 2.4525 StdDev: 7.35 Min: 0 Median: 1.6364 Max: 2188 Percentiles: P50: 1.64 P75: 2.15 P99: 7.03 P99.9: 13.87 P99.99: 21.20 ------------------------------------------------------ [ 0, 1 ] 42966 10.859% 10.859% ## ( 1, 2 ] 243372 61.507% 72.366% ############ ( 2, 3 ] 69453 17.553% 89.918% #### ( 3, 4 ] 19964 5.045% 94.964% # ( 4, 6 ] 15029 3.798% 98.762% # ( 6, 10 ] 3664 0.926% 99.688% ( 10, 15 ] 1083 0.274% 99.962% ( 15, 22 ] 127 0.032% 99.994% ( 22, 34 ] 15 0.004% 99.998% ( 34, 51 ] 4 0.001% 99.999% ( 51, 76 ] 4 0.001% 100.000% ( 76, 110 ] 2 0.001% 100.000% ( 170, 250 ] 27 0.007% 100.007% ( 250, 380 ] 12 0.003% 100.010% ( 380, 580 ] 16 0.004% 100.014% ( 580, 870 ] 1 0.000% 100.014% ( 870, 1300 ] 5 0.001% 100.016% ( 1300, 1900 ] 2 0.001% 100.016% ( 1900, 2900 ] 1 0.000% 100.016% ** Level 1 read latency histogram (micros): Count: 60814 Average: 2.8441 StdDev: 5.92 Min: 1 Median: 1.8523 Max: 680 Percentiles: P50: 1.85 P75: 2.64 P99: 8.97 P99.9: 16.78 P99.99: 309.71 ------------------------------------------------------ [ 0, 1 ] 1438 2.365% 2.365% ( 1, 2 ] 33990 55.892% 58.256% ########### ( 2, 3 ] 15865 26.088% 84.344% ##### ( 3, 4 ] 4248 6.985% 91.329% # ( 4, 6 ] 3988 6.558% 97.887% # ( 6, 10 ] 913 1.501% 99.388% ( 10, 15 ] 301 0.495% 99.883% ( 15, 22 ] 40 0.066% 99.949% ( 22, 34 ] 4 0.007% 99.956% ( 34, 51 ] 1 0.002% 99.957% ( 51, 76 ] 2 0.003% 99.961% ( 110, 170 ] 10 0.016% 99.977% ( 170, 250 ] 7 0.012% 99.988% ( 250, 380 ] 2 0.003% 99.992% ( 380, 580 ] 3 0.005% 99.997% ( 580, 870 ] 2 0.003% 100.000% ** Level 2 read latency histogram (micros): Count: 65361 Average: 2.4852 StdDev: 10.36 Min: 0 Median: 1.4704 Max: 1084 Percentiles: P50: 1.47 P75: 1.86 P99: 8.09 P99.9: 142.47 P99.99: 462.13 ------------------------------------------------------ [ 0, 1 ] 13083 20.017% 20.017% #### ( 1, 2 ] 41665 63.746% 83.762% ############# ( 2, 3 ] 6402 9.795% 93.557% ## ( 3, 4 ] 1801 2.755% 96.313% # ( 4, 6 ] 1430 2.188% 98.501% ( 6, 10 ] 625 0.956% 99.457% ( 10, 15 ] 187 0.286% 99.743% ( 15, 22 ] 22 0.034% 99.777% ( 22, 34 ] 6 0.009% 99.786% ( 34, 51 ] 4 0.006% 99.792% ( 51, 76 ] 2 0.003% 99.795% ( 76, 110 ] 34 0.052% 99.847% ( 110, 170 ] 64 0.098% 99.945% ( 170, 250 ] 18 0.028% 99.972% ( 250, 380 ] 9 0.014% 99.986% ( 380, 580 ] 6 0.009% 99.995% ( 580, 870 ] 1 0.002% 99.997% ( 870, 1300 ] 2 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 220775 Average: 3.5256 StdDev: 47.99 Min: 1 Median: 1.7500 Max: 7197 Percentiles: P50: 1.75 P75: 2.46 P99: 9.54 P99.9: 143.26 P99.99: 292.85 ------------------------------------------------------ [ 0, 1 ] 10345 4.686% 4.686% # ( 1, 2 ] 133391 60.419% 65.105% ############ ( 2, 3 ] 47342 21.444% 86.549% #### ( 3, 4 ] 13021 5.898% 92.447% # ( 4, 6 ] 10633 4.816% 97.263% # ( 6, 10 ] 4330 1.961% 99.224% ( 10, 15 ] 909 0.412% 99.636% ( 15, 22 ] 122 0.055% 99.691% ( 22, 34 ] 9 0.004% 99.695% ( 34, 51 ] 158 0.072% 99.767% ( 51, 76 ] 79 0.036% 99.803% ( 76, 110 ] 71 0.032% 99.835% ( 110, 170 ] 262 0.119% 99.953% ( 170, 250 ] 75 0.034% 99.987% ( 250, 380 ] 21 0.010% 99.997% ( 380, 580 ] 10 0.005% 100.001% ( 580, 870 ] 12 0.005% 100.007% ( 870, 1300 ] 2 0.001% 100.008% ( 1300, 1900 ] 5 0.002% 100.010% ( 1900, 2900 ] 7 0.003% 100.013% ( 2900, 4400 ] 10 0.005% 100.018% ( 4400, 6600 ] 7 0.003% 100.021% ( 6600, 9900 ] 2 0.001% 100.022% ** Level 4 read latency histogram (micros): Count: 25 Average: 3468.2000 StdDev: 1764.33 Min: 666 Median: 3087.5000 Max: 7260 Percentiles: P50: 3087.50 P75: 5264.29 P99: 7260.00 P99.9: 7260.00 P99.99: 7260.00 ------------------------------------------------------ ( 580, 870 ] 1 4.000% 4.000% # ( 870, 1300 ] 1 4.000% 8.000% # ( 1300, 1900 ] 3 12.000% 20.000% ## ( 1900, 2900 ] 7 28.000% 48.000% ###### ( 2900, 4400 ] 4 16.000% 64.000% ### ( 4400, 6600 ] 7 28.000% 92.000% ###### ( 6600, 9900 ] 2 8.000% 100.000% ## ** DB Stats ** Uptime(secs): 6.1 total, 3.0 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 322.86 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:0.153 H:M:S, 2.5 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 332.06 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/10/17-18:26:07 ... thread 0: (1000000,3000000) ops and (325764.1,330857.3) ops/second in (3.069706,9.067352) 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.32 GB 187.7 1.8 0.0 1.8 4.5 2.7 0.0 1.7 121.4 298.8 15.54 14.81 49 0.317 1916K 10K 0.0 0.0 L1 1/0 10.94 MB 1.1 0.2 0.2 0.0 0.2 0.2 0.1 1.0 232.1 231.2 1.08 1.04 1 1.083 255K 982 0.0 0.0 L2 0/0 0.00 KB 0.0 0.3 0.1 0.1 0.3 0.1 0.2 2.0 247.1 246.7 1.05 1.02 2 0.523 262K 461 0.0 0.0 L3 17/0 780.47 MB 0.8 1.3 0.4 0.9 1.3 0.4 0.0 3.4 234.4 233.2 5.81 5.59 4 1.452 1382K 6895 0.0 0.0 L4 127/0 9.59 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.3 1.0 218.2 218.2 0.80 0.74 1 0.796 176K 0 0.0 0.0 L5 120/0 9.23 GB 0.1 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 280/8 21.91 GB 0.0 3.8 0.9 2.9 6.5 3.6 0.9 2.4 162.0 275.2 24.27 23.20 57 0.426 3992K 18K 0.0 0.0 Int 0/0 0.00 KB 0.0 3.8 0.9 2.9 6.5 3.6 0.9 2.4 162.0 275.2 24.27 23.20 57 0.426 3992K 18K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 3.8 0.9 2.9 3.8 0.9 0.0 0.0 241.1 239.9 16.31 15.83 15 1.087 3992K 18K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 2.7 2.7 0.0 0.0 0.0 347.5 7.96 7.37 42 0.190 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.2 total, 9.1 interval Flush(GB): cumulative 2.703, interval 2.703 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 6.52 GB write, 728.85 MB/s write, 3.84 GB read, 428.93 MB/s read, 24.3 seconds Interval compaction: 6.52 GB write, 736.60 MB/s write, 3.84 GB read, 433.49 MB/s read, 24.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: 6, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 6, interval: 6 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 650013 Average: 2.3613 StdDev: 6.95 Min: 0 Median: 1.5956 Max: 2188 Percentiles: P50: 1.60 P75: 1.99 P99: 6.23 P99.9: 13.52 P99.99: 20.93 ------------------------------------------------------ [ 0, 1 ] 77776 11.965% 11.965% ## ( 1, 2 ] 415096 63.860% 75.825% ############# ( 2, 3 ] 103903 15.985% 91.810% ### ( 3, 4 ] 27397 4.215% 96.025% # ( 4, 6 ] 19050 2.931% 98.955% # ( 6, 10 ] 5071 0.780% 99.735% ( 10, 15 ] 1523 0.234% 99.970% ( 15, 22 ] 157 0.024% 99.994% ( 22, 34 ] 22 0.003% 99.997% ( 34, 51 ] 5 0.001% 99.998% ( 51, 76 ] 4 0.001% 99.999% ( 76, 110 ] 5 0.001% 99.999% ( 170, 250 ] 40 0.006% 100.006% ( 250, 380 ] 24 0.004% 100.009% ( 380, 580 ] 20 0.003% 100.012% ( 580, 870 ] 3 0.000% 100.013% ( 870, 1300 ] 8 0.001% 100.014% ( 1300, 1900 ] 3 0.000% 100.014% ( 1900, 2900 ] 1 0.000% 100.015% ** Level 1 read latency histogram (micros): Count: 60814 Average: 2.8441 StdDev: 5.92 Min: 1 Median: 1.8523 Max: 680 Percentiles: P50: 1.85 P75: 2.64 P99: 8.97 P99.9: 16.78 P99.99: 309.71 ------------------------------------------------------ [ 0, 1 ] 1438 2.365% 2.365% ( 1, 2 ] 33990 55.892% 58.256% ########### ( 2, 3 ] 15865 26.088% 84.344% ##### ( 3, 4 ] 4248 6.985% 91.329% # ( 4, 6 ] 3988 6.558% 97.887% # ( 6, 10 ] 913 1.501% 99.388% ( 10, 15 ] 301 0.495% 99.883% ( 15, 22 ] 40 0.066% 99.949% ( 22, 34 ] 4 0.007% 99.956% ( 34, 51 ] 1 0.002% 99.957% ( 51, 76 ] 2 0.003% 99.961% ( 110, 170 ] 10 0.016% 99.977% ( 170, 250 ] 7 0.012% 99.988% ( 250, 380 ] 2 0.003% 99.992% ( 380, 580 ] 3 0.005% 99.997% ( 580, 870 ] 2 0.003% 100.000% ** Level 2 read latency histogram (micros): Count: 74367 Average: 2.4839 StdDev: 10.00 Min: 0 Median: 1.4867 Max: 1084 Percentiles: P50: 1.49 P75: 1.88 P99: 8.05 P99.9: 139.27 P99.99: 453.24 ------------------------------------------------------ [ 0, 1 ] 13912 18.707% 18.707% #### ( 1, 2 ] 47817 64.299% 83.006% ############# ( 2, 3 ] 7858 10.567% 93.572% ## ( 3, 4 ] 2021 2.718% 96.290% # ( 4, 6 ] 1620 2.178% 98.468% ( 6, 10 ] 771 1.037% 99.505% ( 10, 15 ] 189 0.254% 99.759% ( 15, 22 ] 23 0.031% 99.790% ( 22, 34 ] 7 0.009% 99.800% ( 34, 51 ] 4 0.005% 99.805% ( 51, 76 ] 2 0.003% 99.808% ( 76, 110 ] 34 0.046% 99.853% ( 110, 170 ] 71 0.095% 99.949% ( 170, 250 ] 18 0.024% 99.973% ( 250, 380 ] 10 0.013% 99.987% ( 380, 580 ] 7 0.009% 99.996% ( 580, 870 ] 1 0.001% 99.997% ( 870, 1300 ] 2 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 288404 Average: 3.3701 StdDev: 42.39 Min: 0 Median: 1.7268 Max: 7197 Percentiles: P50: 1.73 P75: 2.39 P99: 9.39 P99.9: 148.13 P99.99: 342.17 ------------------------------------------------------ [ 0, 1 ] 15325 5.314% 5.314% # ( 1, 2 ] 177327 61.486% 66.799% ############ ( 2, 3 ] 60579 21.005% 87.804% #### ( 3, 4 ] 15287 5.301% 93.105% # ( 4, 6 ] 12195 4.228% 97.333% # ( 6, 10 ] 5670 1.966% 99.299% ( 10, 15 ] 1048 0.363% 99.663% ( 15, 22 ] 133 0.046% 99.709% ( 22, 34 ] 10 0.003% 99.712% ( 34, 51 ] 158 0.055% 99.767% ( 51, 76 ] 81 0.028% 99.795% ( 76, 110 ] 91 0.032% 99.827% ( 110, 170 ] 333 0.115% 99.942% ( 170, 250 ] 102 0.035% 99.977% ( 250, 380 ] 51 0.018% 99.995% ( 380, 580 ] 15 0.005% 100.000% ( 580, 870 ] 12 0.004% 100.005% ( 870, 1300 ] 2 0.001% 100.005% ( 1300, 1900 ] 6 0.002% 100.007% ( 1900, 2900 ] 7 0.002% 100.010% ( 2900, 4400 ] 10 0.003% 100.013% ( 4400, 6600 ] 7 0.002% 100.016% ( 6600, 9900 ] 2 0.001% 100.016% ** Level 4 read latency histogram (micros): Count: 60 Average: 1462.9167 StdDev: 2042.28 Min: 1 Median: 130.0000 Max: 7260 Percentiles: P50: 130.00 P75: 2614.29 P99: 7260.00 P99.9: 7260.00 P99.99: 7260.00 ------------------------------------------------------ [ 0, 1 ] 15 25.000% 25.000% ##### ( 1, 2 ] 6 10.000% 35.000% ## ( 2, 3 ] 1 1.667% 36.667% ( 3, 4 ] 1 1.667% 38.333% ( 22, 34 ] 5 8.333% 46.667% ## ( 110, 170 ] 6 10.000% 56.667% ## ( 170, 250 ] 1 1.667% 58.333% ( 580, 870 ] 1 1.667% 60.000% ( 870, 1300 ] 1 1.667% 61.667% ( 1300, 1900 ] 3 5.000% 66.667% # ( 1900, 2900 ] 7 11.667% 78.333% ## ( 2900, 4400 ] 4 6.667% 85.000% # ( 4400, 6600 ] 7 11.667% 96.667% ## ( 6600, 9900 ] 2 3.333% 100.000% # ** Level 5 read latency histogram (micros): Count: 20 Average: 396.1500 StdDev: 424.59 Min: 106 Median: 170.0000 Max: 1675 Percentiles: P50: 170.00 P75: 380.00 P99: 1675.00 P99.9: 1675.00 P99.99: 1675.00 ------------------------------------------------------ ( 76, 110 ] 3 15.000% 15.000% ### ( 110, 170 ] 7 35.000% 50.000% ####### ( 170, 250 ] 2 10.000% 60.000% ## ( 250, 380 ] 3 15.000% 75.000% ### ( 380, 580 ] 1 5.000% 80.000% # ( 870, 1300 ] 3 15.000% 95.000% ### ( 1300, 1900 ] 1 5.000% 100.000% # ** DB Stats ** Uptime(secs): 9.2 total, 3.1 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 322.10 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.335 H:M:S, 3.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 320.61 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.181 H:M:S, 5.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/10/17-18:26:10 ... thread 0: (1000000,4000000) ops and (330518.0,330772.4) ops/second in (3.025554,12.092906) 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.30 GB 312.9 2.9 0.0 2.9 6.6 3.7 0.0 1.8 131.6 299.0 22.46 21.47 68 0.330 3002K 15K 0.0 0.0 L1 1/0 10.94 MB 1.1 0.2 0.2 0.0 0.2 0.2 0.1 1.0 232.1 231.2 1.08 1.04 1 1.083 255K 982 0.0 0.0 L2 0/0 0.00 KB 0.0 0.3 0.1 0.1 0.3 0.1 0.2 2.0 247.1 246.7 1.05 1.02 2 0.523 262K 461 0.0 0.0 L3 17/0 780.47 MB 0.8 1.3 0.4 0.9 1.3 0.4 0.0 3.4 234.4 233.2 5.81 5.59 4 1.452 1382K 6895 0.0 0.0 L4 127/0 9.59 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.3 1.0 218.2 218.2 0.80 0.74 1 0.796 176K 0 0.0 0.0 L5 120/0 9.23 GB 0.1 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 283/4 22.89 GB 0.0 4.9 0.9 4.0 8.5 4.6 0.9 2.3 160.3 280.6 31.19 29.86 76 0.410 5078K 23K 0.0 0.0 Int 0/0 0.00 KB 0.0 4.9 0.9 4.0 8.5 4.6 0.9 2.3 160.3 280.6 31.19 29.86 76 0.410 5078K 23K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 4.9 0.9 4.0 4.9 0.9 0.0 0.0 244.8 243.6 20.43 19.88 19 1.075 5078K 23K 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 350.7 10.76 9.98 57 0.189 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 12.2 total, 12.1 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.55 GB write, 717.76 MB/s write, 4.88 GB read, 410.19 MB/s read, 31.2 seconds Interval compaction: 8.55 GB write, 723.48 MB/s write, 4.88 GB read, 413.46 MB/s read, 31.2 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 7, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 7, interval: 7 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 892161 Average: 2.2825 StdDev: 6.89 Min: 0 Median: 1.5515 Max: 2188 Percentiles: P50: 1.55 P75: 1.94 P99: 5.95 P99.9: 13.26 P99.99: 21.03 ------------------------------------------------------ [ 0, 1 ] 127263 14.265% 14.265% ### ( 1, 2 ] 578055 64.793% 79.057% ############# ( 2, 3 ] 124439 13.948% 93.005% ### ( 3, 4 ] 32450 3.637% 96.643% # ( 4, 6 ] 21612 2.422% 99.065% ( 6, 10 ] 6238 0.699% 99.764% ( 10, 15 ] 1858 0.208% 99.972% ( 15, 22 ] 182 0.020% 99.993% ( 22, 34 ] 28 0.003% 99.996% ( 34, 51 ] 6 0.001% 99.997% ( 51, 76 ] 6 0.001% 99.997% ( 76, 110 ] 6 0.001% 99.998% ( 170, 250 ] 53 0.006% 100.004% ( 250, 380 ] 34 0.004% 100.008% ( 380, 580 ] 25 0.003% 100.011% ( 580, 870 ] 7 0.001% 100.011% ( 870, 1300 ] 13 0.001% 100.013% ( 1300, 1900 ] 3 0.000% 100.013% ( 1900, 2900 ] 1 0.000% 100.013% ** Level 1 read latency histogram (micros): Count: 60814 Average: 2.8441 StdDev: 5.92 Min: 1 Median: 1.8523 Max: 680 Percentiles: P50: 1.85 P75: 2.64 P99: 8.97 P99.9: 16.78 P99.99: 309.71 ------------------------------------------------------ [ 0, 1 ] 1438 2.365% 2.365% ( 1, 2 ] 33990 55.892% 58.256% ########### ( 2, 3 ] 15865 26.088% 84.344% ##### ( 3, 4 ] 4248 6.985% 91.329% # ( 4, 6 ] 3988 6.558% 97.887% # ( 6, 10 ] 913 1.501% 99.388% ( 10, 15 ] 301 0.495% 99.883% ( 15, 22 ] 40 0.066% 99.949% ( 22, 34 ] 4 0.007% 99.956% ( 34, 51 ] 1 0.002% 99.957% ( 51, 76 ] 2 0.003% 99.961% ( 110, 170 ] 10 0.016% 99.977% ( 170, 250 ] 7 0.012% 99.988% ( 250, 380 ] 2 0.003% 99.992% ( 380, 580 ] 3 0.005% 99.997% ( 580, 870 ] 2 0.003% 100.000% ** Level 2 read latency histogram (micros): Count: 74367 Average: 2.4839 StdDev: 10.00 Min: 0 Median: 1.4867 Max: 1084 Percentiles: P50: 1.49 P75: 1.88 P99: 8.05 P99.9: 139.27 P99.99: 453.24 ------------------------------------------------------ [ 0, 1 ] 13912 18.707% 18.707% #### ( 1, 2 ] 47817 64.299% 83.006% ############# ( 2, 3 ] 7858 10.567% 93.572% ## ( 3, 4 ] 2021 2.718% 96.290% # ( 4, 6 ] 1620 2.178% 98.468% ( 6, 10 ] 771 1.037% 99.505% ( 10, 15 ] 189 0.254% 99.759% ( 15, 22 ] 23 0.031% 99.790% ( 22, 34 ] 7 0.009% 99.800% ( 34, 51 ] 4 0.005% 99.805% ( 51, 76 ] 2 0.003% 99.808% ( 76, 110 ] 34 0.046% 99.853% ( 110, 170 ] 71 0.095% 99.949% ( 170, 250 ] 18 0.024% 99.973% ( 250, 380 ] 10 0.013% 99.987% ( 380, 580 ] 7 0.009% 99.996% ( 580, 870 ] 1 0.001% 99.997% ( 870, 1300 ] 2 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 288404 Average: 3.3701 StdDev: 42.39 Min: 0 Median: 1.7268 Max: 7197 Percentiles: P50: 1.73 P75: 2.39 P99: 9.39 P99.9: 148.13 P99.99: 342.17 ------------------------------------------------------ [ 0, 1 ] 15325 5.314% 5.314% # ( 1, 2 ] 177327 61.486% 66.799% ############ ( 2, 3 ] 60579 21.005% 87.804% #### ( 3, 4 ] 15287 5.301% 93.105% # ( 4, 6 ] 12195 4.228% 97.333% # ( 6, 10 ] 5670 1.966% 99.299% ( 10, 15 ] 1048 0.363% 99.663% ( 15, 22 ] 133 0.046% 99.709% ( 22, 34 ] 10 0.003% 99.712% ( 34, 51 ] 158 0.055% 99.767% ( 51, 76 ] 81 0.028% 99.795% ( 76, 110 ] 91 0.032% 99.827% ( 110, 170 ] 333 0.115% 99.942% ( 170, 250 ] 102 0.035% 99.977% ( 250, 380 ] 51 0.018% 99.995% ( 380, 580 ] 15 0.005% 100.000% ( 580, 870 ] 12 0.004% 100.005% ( 870, 1300 ] 2 0.001% 100.005% ( 1300, 1900 ] 6 0.002% 100.007% ( 1900, 2900 ] 7 0.002% 100.010% ( 2900, 4400 ] 10 0.003% 100.013% ( 4400, 6600 ] 7 0.002% 100.016% ( 6600, 9900 ] 2 0.001% 100.016% ** Level 4 read latency histogram (micros): Count: 60 Average: 1462.9167 StdDev: 2042.28 Min: 1 Median: 130.0000 Max: 7260 Percentiles: P50: 130.00 P75: 2614.29 P99: 7260.00 P99.9: 7260.00 P99.99: 7260.00 ------------------------------------------------------ [ 0, 1 ] 15 25.000% 25.000% ##### ( 1, 2 ] 6 10.000% 35.000% ## ( 2, 3 ] 1 1.667% 36.667% ( 3, 4 ] 1 1.667% 38.333% ( 22, 34 ] 5 8.333% 46.667% ## ( 110, 170 ] 6 10.000% 56.667% ## ( 170, 250 ] 1 1.667% 58.333% ( 580, 870 ] 1 1.667% 60.000% ( 870, 1300 ] 1 1.667% 61.667% ( 1300, 1900 ] 3 5.000% 66.667% # ( 1900, 2900 ] 7 11.667% 78.333% ## ( 2900, 4400 ] 4 6.667% 85.000% # ( 4400, 6600 ] 7 11.667% 96.667% ## ( 6600, 9900 ] 2 3.333% 100.000% # ** Level 5 read latency histogram (micros): Count: 20 Average: 396.1500 StdDev: 424.59 Min: 106 Median: 170.0000 Max: 1675 Percentiles: P50: 170.00 P75: 380.00 P99: 1675.00 P99.9: 1675.00 P99.99: 1675.00 ------------------------------------------------------ ( 76, 110 ] 3 15.000% 15.000% ### ( 110, 170 ] 7 35.000% 50.000% ####### ( 170, 250 ] 2 10.000% 60.000% ## ( 250, 380 ] 3 15.000% 75.000% ### ( 380, 580 ] 1 5.000% 80.000% # ( 870, 1300 ] 3 15.000% 95.000% ### ( 1300, 1900 ] 1 5.000% 100.000% # ** DB Stats ** Uptime(secs): 12.2 total, 3.0 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 322.89 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.508 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, 325.29 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.173 H:M:S, 5.7 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.149 micros/op 241021 ops/sec 20.044 seconds 4830999 operations; 233.5 MB/s Microseconds per write: Count: 4830999 Average: 4.1490 StdDev: 140.47 Min: 0 Median: 1.7826 Max: 181702 Percentiles: P50: 1.78 P75: 3.12 P99: 8.94 P99.9: 167.02 P99.99: 2382.61 ------------------------------------------------------ [ 0, 1 ] 637119 13.188% 13.188% ### ( 1, 2 ] 2272347 47.037% 60.225% ######### ( 2, 3 ] 636304 13.171% 73.396% ### ( 3, 4 ] 640714 13.263% 86.659% ### ( 4, 6 ] 543415 11.249% 97.907% ## ( 6, 10 ] 71708 1.484% 99.392% ( 10, 15 ] 14480 0.300% 99.691% ( 15, 22 ] 4277 0.089% 99.780% ( 22, 34 ] 1369 0.028% 99.808% ( 34, 51 ] 179 0.004% 99.812% ( 51, 76 ] 21 0.000% 99.812% ( 76, 110 ] 3 0.000% 99.812% ( 110, 170 ] 4453 0.092% 99.905% ( 170, 250 ] 359 0.007% 99.912% ( 250, 380 ] 88 0.002% 99.914% ( 380, 580 ] 9 0.000% 99.914% ( 580, 870 ] 5 0.000% 99.914% ( 870, 1300 ] 3217 0.067% 99.981% ( 1300, 1900 ] 2 0.000% 99.981% ( 1900, 2900 ] 926 0.019% 100.000% ( 22000, 33000 ] 1 0.000% 100.000% ( 110000, 170000 ] 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 : 150233 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 : 4830999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 4985590968 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 : 153 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 5895510 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 : 7648214724 rocksdb.compact.write.bytes COUNT : 7498772308 rocksdb.flush.write.bytes COUNT : 4946887916 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 : 13 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 : 94 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 : 4914394112 rocksdb.memtable.garbage.bytes.at.flush COUNT : 8694784 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 : 7687889096 rocksdb.non.last.level.read.count COUNT : 1854628 rocksdb.block.checksum.compute.count COUNT : 1854335 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.433402 P95 : 4.975499 P99 : 7.762590 P100 : 181697.000000 COUNT : 4830999 SUM : 17822669 rocksdb.compaction.times.micros P50 : 1030000.000000 P95 : 1865000.000000 P99 : 3503865.000000 P100 : 3503865.000000 COUNT : 23 SUM : 24374520 rocksdb.compaction.times.cpu_micros P50 : 1007333.333333 P95 : 1847500.000000 P99 : 3357153.000000 P100 : 3357153.000000 COUNT : 23 SUM : 23747394 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 : 621.428571 P95 : 1275.428571 P99 : 1331.000000 P100 : 1331.000000 COUNT : 72 SUM : 53517 rocksdb.compaction.outfile.sync.micros P50 : 676.666667 P95 : 1228.333333 P99 : 1690.000000 P100 : 1884.000000 COUNT : 70 SUM : 48670 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 : 73.149123 P95 : 249.000000 P99 : 304.000000 P100 : 304.000000 COUNT : 101 SUM : 9813 rocksdb.table.open.io.micros P50 : 780.328947 P95 : 16436.363636 P99 : 19504.000000 P100 : 19504.000000 COUNT : 153 SUM : 365010 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.610679 P95 : 6.353387 P99 : 10.639931 P100 : 9225.000000 COUNT : 1853942 SUM : 8360796 rocksdb.read.block.get.micros P50 : 350.676692 P95 : 4325.000000 P99 : 6420.615385 P100 : 7364.000000 COUNT : 306 SUM : 240328 rocksdb.write.raw.block.micros P50 : 0.511746 P95 : 0.972318 P99 : 2.962785 P100 : 3608.000000 COUNT : 3014648 SUM : 5774196 rocksdb.numfiles.in.singlecompaction P50 : 3.343750 P95 : 12.750000 P99 : 19.000000 P100 : 19.000000 COUNT : 29 SUM : 125 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.561351 P95 : 1168.769183 P99 : 2490.410367 P100 : 181488.000000 COUNT : 38228 SUM : 5899177 rocksdb.sst.read.micros P50 : 1.531592 P95 : 3.604470 P99 : 7.022447 P100 : 7260.000000 COUNT : 1854751 SUM : 4607251 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 : 4830999 SUM : 4985590968 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 : 200769.230769 P95 : 263000.000000 P99 : 356600.000000 P100 : 362832.000000 COUNT : 72 SUM : 13364547 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 : 94 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