[2024-12-09 23:55:43.074896] Starting SPDK v25.01-pre git sha1 969b360d9 / DPDK 24.03.0 initialization... [2024-12-09 23:55:43.075244] [ 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_pid3579481 ] Set seed to 1733784943067945 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-12-09 23:55:43.218578] app.c: 919:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-12-09 23:55:43.329708] app.c: 612:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-12-09 23:55:43.329760] app.c: 613:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 3579481' to capture a snapshot of events at runtime. [2024-12-09 23:55:43.329773] app.c: 618:app_setup_trace: *NOTICE*: 'spdk_trace' without parameters will also work if this is the only [2024-12-09 23:55:43.329803] app.c: 619:app_setup_trace: *NOTICE*: SPDK application currently running. [2024-12-09 23:55:43.329813] app.c: 620:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid3579481 for offline analysis/debug. [2024-12-09 23:55:43.331116] reactor.c:1005:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Mon Dec 9 23:55:46 2024 CPU: 72 * Intel(R) Xeon(R) Gold 6140 CPU @ 2.30GHz CPUCache: 25344 KB 2024/12/09-23:55:49 ... thread 0: (1000000,1000000) ops and (326603.3,326603.3) ops/second in (3.061818,3.061818) 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 336.9 2.61 2.42 13 0.201 0 0 0.0 0.0 L1 1/0 9.98 MB 1.0 0.2 0.2 0.0 0.2 0.2 0.1 1.0 238.2 237.2 1.06 1.03 1 1.055 255K 1028 0.0 0.0 L2 3/2 279.93 MB 1.1 0.3 0.1 0.1 0.3 0.1 0.2 2.0 247.6 247.2 1.04 1.01 2 0.521 262K 426 0.0 0.0 L3 17/11 876.59 MB 0.1 0.1 0.1 0.0 0.1 0.1 0.0 1.0 224.1 224.1 0.54 0.52 1 0.538 122K 0 0.0 0.0 L4 120/0 9.66 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 112/0 8.80 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 261/18 20.09 GB 0.0 0.6 0.5 0.1 1.5 1.3 0.4 1.7 120.1 287.5 5.25 4.99 17 0.309 640K 1454 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 120.1 287.5 5.25 4.99 17 0.309 640K 1454 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 239.1 238.5 2.64 2.57 4 0.659 640K 1454 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 336.9 2.61 2.42 13 0.201 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 3.1 total, 3.1 interval Flush(GB): cumulative 0.860, interval 0.860 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 1.47 GB write, 482.39 MB/s write, 0.62 GB read, 201.46 MB/s read, 5.3 seconds Interval compaction: 1.47 GB write, 492.69 MB/s write, 0.62 GB read, 205.76 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: 4, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 4, interval: 4 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 134890 Average: 2.0445 StdDev: 5.37 Min: 0 Median: 1.4015 Max: 1119 Percentiles: P50: 1.40 P75: 1.79 P99: 5.73 P99.9: 12.88 P99.99: 193.41 ------------------------------------------------------ [ 0, 1 ] 33001 24.465% 24.465% ##### ( 1, 2 ] 85799 63.607% 88.072% ############# ( 2, 3 ] 9938 7.367% 95.439% # ( 3, 4 ] 3313 2.456% 97.895% ( 4, 6 ] 1721 1.276% 99.171% ( 6, 10 ] 886 0.657% 99.828% ( 10, 15 ] 172 0.128% 99.956% ( 15, 22 ] 31 0.023% 99.979% ( 22, 34 ] 6 0.004% 99.983% ( 34, 51 ] 3 0.002% 99.985% ( 51, 76 ] 3 0.002% 99.987% ( 76, 110 ] 2 0.001% 99.989% ( 170, 250 ] 12 0.009% 99.998% ( 250, 380 ] 7 0.005% 100.003% ( 380, 580 ] 6 0.004% 100.007% ( 870, 1300 ] 1 0.001% 100.008% ** Level 1 read latency histogram (micros): Count: 1788 Average: 3.9211 StdDev: 27.11 Min: 1 Median: 1.7305 Max: 713 Percentiles: P50: 1.73 P75: 2.44 P99: 10.88 P99.9: 610.74 P99.99: 713.00 ------------------------------------------------------ [ 0, 1 ] 100 5.593% 5.593% # ( 1, 2 ] 1087 60.794% 66.387% ############ ( 2, 3 ] 350 19.575% 85.962% #### ( 3, 4 ] 124 6.935% 92.897% # ( 4, 6 ] 73 4.083% 96.980% # ( 6, 10 ] 34 1.902% 98.881% ( 10, 15 ] 12 0.671% 99.553% ( 15, 22 ] 2 0.112% 99.664% ( 34, 51 ] 2 0.112% 99.776% ( 380, 580 ] 2 0.112% 99.888% ( 580, 870 ] 2 0.112% 100.000% ** Level 2 read latency histogram (micros): Count: 64310 Average: 2.3492 StdDev: 18.99 Min: 1 Median: 1.4262 Max: 3677 Percentiles: P50: 1.43 P75: 1.82 P99: 7.75 P99.9: 90.55 P99.99: 436.90 ------------------------------------------------------ [ 0, 1 ] 14788 22.995% 22.995% ##### ( 1, 2 ] 40746 63.359% 86.354% ############# ( 2, 3 ] 5038 7.834% 94.188% ## ( 3, 4 ] 1794 2.790% 96.977% # ( 4, 6 ] 1036 1.611% 98.588% ( 6, 10 ] 606 0.942% 99.530% ( 10, 15 ] 188 0.292% 99.823% ( 15, 22 ] 23 0.036% 99.858% ( 22, 34 ] 9 0.014% 99.872% ( 34, 51 ] 3 0.005% 99.877% ( 51, 76 ] 1 0.002% 99.879% ( 76, 110 ] 32 0.050% 99.928% ( 110, 170 ] 25 0.039% 99.967% ( 170, 250 ] 12 0.019% 99.986% ( 250, 380 ] 2 0.003% 99.989% ( 380, 580 ] 2 0.003% 99.992% ( 580, 870 ] 2 0.003% 99.995% ( 1300, 1900 ] 1 0.002% 99.997% ( 1900, 2900 ] 1 0.002% 99.998% ( 2900, 4400 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 3439 Average: 36.2908 StdDev: 330.98 Min: 0 Median: 1.6879 Max: 5255 Percentiles: P50: 1.69 P75: 2.35 P99: 1094.46 P99.9: 5255.00 P99.99: 5255.00 ------------------------------------------------------ [ 0, 1 ] 226 6.572% 6.572% # ( 1, 2 ] 2171 63.129% 69.700% ############# ( 2, 3 ] 525 15.266% 84.967% ### ( 3, 4 ] 206 5.990% 90.957% # ( 4, 6 ] 99 2.879% 93.835% # ( 6, 10 ] 61 1.774% 95.609% ( 10, 15 ] 28 0.814% 96.423% ( 15, 22 ] 7 0.204% 96.627% ( 22, 34 ] 4 0.116% 96.743% ( 76, 110 ] 10 0.291% 97.034% ( 110, 170 ] 46 1.338% 98.372% ( 170, 250 ] 14 0.407% 98.779% ( 250, 380 ] 4 0.116% 98.895% ( 580, 870 ] 1 0.029% 98.924% ( 870, 1300 ] 5 0.145% 99.069% ( 1300, 1900 ] 10 0.291% 99.360% ( 1900, 2900 ] 4 0.116% 99.477% ( 2900, 4400 ] 10 0.291% 99.767% ( 4400, 6600 ] 7 0.204% 99.971% ** Level 4 read latency histogram (micros): Count: 30 Average: 3118.5000 StdDev: 1610.66 Min: 120 Median: 3309.0909 Max: 6009 Percentiles: P50: 3309.09 P75: 4331.82 P99: 6009.00 P99.9: 6009.00 P99.99: 6009.00 ------------------------------------------------------ ( 110, 170 ] 1 3.333% 3.333% # ( 250, 380 ] 3 10.000% 13.333% ## ( 870, 1300 ] 1 3.333% 16.667% # ( 1300, 1900 ] 2 6.667% 23.333% # ( 1900, 2900 ] 5 16.667% 40.000% ### ( 2900, 4400 ] 11 36.667% 76.667% ####### ( 4400, 6600 ] 7 23.333% 100.000% ##### ** DB Stats ** Uptime(secs): 3.1 total, 3.1 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 314.50 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.169 H:M:S, 5.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 321.18 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.169 H:M:S, 5.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/12/09-23:55:52 ... thread 0: (1000000,2000000) ops and (333468.7,330000.3) ops/second in (2.998782,6.060600) 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.2 300.1 9.62 9.13 32 0.301 1086K 5778 0.0 0.0 L1 1/0 9.98 MB 1.0 0.2 0.2 0.0 0.2 0.2 0.1 1.0 238.2 237.2 1.06 1.03 1 1.055 255K 1028 0.0 0.0 L2 1/1 39.52 MB 0.0 0.3 0.1 0.1 0.3 0.1 0.2 2.0 247.6 247.2 1.04 1.01 2 0.521 262K 426 0.0 0.0 L3 18/9 1.09 GB 0.4 0.5 0.4 0.1 0.5 0.4 0.0 1.4 223.7 223.0 2.26 2.20 3 0.755 514K 1522 0.0 0.0 L4 120/0 9.66 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 112/0 8.80 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 262/14 21.00 GB 0.0 2.0 0.7 1.3 3.8 2.5 0.4 2.1 149.1 279.0 13.98 13.37 38 0.368 2118K 8754 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 149.1 279.0 13.98 13.37 38 0.368 2118K 8754 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 239.3 238.3 8.72 8.51 10 0.872 2118K 8754 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 346.2 5.27 4.86 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.1 interval Flush(GB): cumulative 1.782, interval 1.782 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, 636.62 MB/s write, 2.04 GB read, 340.36 MB/s read, 14.0 seconds Interval compaction: 3.81 GB write, 643.49 MB/s write, 2.04 GB read, 344.03 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: 4, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 4, interval: 4 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 400027 Average: 2.3708 StdDev: 6.08 Min: 0 Median: 1.5964 Max: 1207 Percentiles: P50: 1.60 P75: 1.99 P99: 6.19 P99.9: 13.18 P99.99: 19.94 ------------------------------------------------------ [ 0, 1 ] 48666 12.166% 12.166% ## ( 1, 2 ] 253778 63.440% 75.606% ############# ( 2, 3 ] 61158 15.288% 90.894% ### ( 3, 4 ] 20007 5.001% 95.896% # ( 4, 6 ] 12261 3.065% 98.961% # ( 6, 10 ] 3257 0.814% 99.775% ( 10, 15 ] 790 0.197% 99.973% ( 15, 22 ] 102 0.025% 99.998% ( 22, 34 ] 19 0.005% 100.003% ( 34, 51 ] 6 0.001% 100.004% ( 51, 76 ] 10 0.002% 100.007% ( 76, 110 ] 2 0.000% 100.007% ( 170, 250 ] 27 0.007% 100.014% ( 250, 380 ] 12 0.003% 100.017% ( 380, 580 ] 15 0.004% 100.021% ( 580, 870 ] 4 0.001% 100.022% ( 870, 1300 ] 6 0.001% 100.023% ** Level 1 read latency histogram (micros): Count: 61059 Average: 2.7706 StdDev: 6.37 Min: 1 Median: 1.8087 Max: 713 Percentiles: P50: 1.81 P75: 2.57 P99: 8.20 P99.9: 14.56 P99.99: 366.23 ------------------------------------------------------ [ 0, 1 ] 1730 2.833% 2.833% # ( 1, 2 ] 35610 58.321% 61.154% ############ ( 2, 3 ] 14790 24.222% 85.376% ##### ( 3, 4 ] 4354 7.131% 92.507% # ( 4, 6 ] 3456 5.660% 98.167% # ( 6, 10 ] 923 1.512% 99.679% ( 10, 15 ] 148 0.242% 99.921% ( 15, 22 ] 15 0.025% 99.946% ( 22, 34 ] 3 0.005% 99.951% ( 34, 51 ] 2 0.003% 99.954% ( 110, 170 ] 17 0.028% 99.982% ( 170, 250 ] 4 0.007% 99.989% ( 250, 380 ] 1 0.002% 99.990% ( 380, 580 ] 4 0.007% 99.997% ( 580, 870 ] 2 0.003% 100.000% ** Level 2 read latency histogram (micros): Count: 65478 Average: 2.4257 StdDev: 19.32 Min: 1 Median: 1.4355 Max: 3677 Percentiles: P50: 1.44 P75: 1.83 P99: 7.87 P99.9: 112.34 P99.99: 518.09 ------------------------------------------------------ [ 0, 1 ] 14796 22.597% 22.597% ##### ( 1, 2 ] 41198 62.919% 85.516% ############# ( 2, 3 ] 5543 8.465% 93.981% ## ( 3, 4 ] 1894 2.893% 96.874% # ( 4, 6 ] 1101 1.681% 98.555% ( 6, 10 ] 623 0.951% 99.507% ( 10, 15 ] 188 0.287% 99.794% ( 15, 22 ] 23 0.035% 99.829% ( 22, 34 ] 9 0.014% 99.843% ( 34, 51 ] 3 0.005% 99.847% ( 51, 76 ] 1 0.002% 99.849% ( 76, 110 ] 32 0.049% 99.898% ( 110, 170 ] 39 0.060% 99.957% ( 170, 250 ] 14 0.021% 99.979% ( 250, 380 ] 4 0.006% 99.985% ( 380, 580 ] 5 0.008% 99.992% ( 580, 870 ] 2 0.003% 99.995% ( 1300, 1900 ] 1 0.002% 99.997% ( 1900, 2900 ] 1 0.002% 99.998% ( 2900, 4400 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 227213 Average: 3.2690 StdDev: 41.49 Min: 0 Median: 1.6915 Max: 5255 Percentiles: P50: 1.69 P75: 2.29 P99: 8.95 P99.9: 137.35 P99.99: 475.08 ------------------------------------------------------ [ 0, 1 ] 13580 5.977% 5.977% # ( 1, 2 ] 144661 63.668% 69.644% ############# ( 2, 3 ] 42095 18.527% 88.171% #### ( 3, 4 ] 13134 5.780% 93.951% # ( 4, 6 ] 8301 3.653% 97.605% # ( 6, 10 ] 4297 1.891% 99.496% ( 10, 15 ] 424 0.187% 99.683% ( 15, 22 ] 66 0.029% 99.712% ( 22, 34 ] 13 0.006% 99.717% ( 34, 51 ] 178 0.078% 99.796% ( 51, 76 ] 76 0.033% 99.829% ( 76, 110 ] 76 0.033% 99.863% ( 110, 170 ] 186 0.082% 99.945% ( 170, 250 ] 74 0.033% 99.977% ( 250, 380 ] 25 0.011% 99.988% ( 380, 580 ] 9 0.004% 99.992% ( 580, 870 ] 2 0.001% 99.993% ( 870, 1300 ] 5 0.002% 99.995% ( 1300, 1900 ] 10 0.004% 100.000% ( 1900, 2900 ] 4 0.002% 100.001% ( 2900, 4400 ] 10 0.004% 100.006% ( 4400, 6600 ] 7 0.003% 100.009% ** Level 4 read latency histogram (micros): Count: 30 Average: 3118.5000 StdDev: 1610.66 Min: 120 Median: 3309.0909 Max: 6009 Percentiles: P50: 3309.09 P75: 4331.82 P99: 6009.00 P99.9: 6009.00 P99.99: 6009.00 ------------------------------------------------------ ( 110, 170 ] 1 3.333% 3.333% # ( 250, 380 ] 3 10.000% 13.333% ## ( 870, 1300 ] 1 3.333% 16.667% # ( 1300, 1900 ] 2 6.667% 23.333% # ( 1900, 2900 ] 5 16.667% 40.000% ### ( 2900, 4400 ] 11 36.667% 76.667% ####### ( 4400, 6600 ] 7 23.333% 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, 321.21 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.169 H:M:S, 2.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 328.21 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/12/09-23:55:55 ... thread 0: (1000000,3000000) ops and (324175.8,328035.7) ops/second in (3.084746,9.145346) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 16/8 2.39 GB 187.8 1.8 0.0 1.8 4.5 2.8 0.0 1.6 118.4 301.5 15.41 14.66 50 0.308 1852K 9420 0.0 0.0 L1 1/0 9.98 MB 1.0 0.2 0.2 0.0 0.2 0.2 0.1 1.0 238.2 237.2 1.06 1.03 1 1.055 255K 1028 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.6 247.2 1.04 1.01 2 0.521 262K 426 0.0 0.0 L3 20/0 979.20 MB 1.0 1.3 0.4 0.9 1.3 0.4 0.0 3.2 237.6 236.5 5.48 5.28 4 1.370 1322K 6301 0.0 0.0 L4 123/0 9.52 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.0 1.0 201.9 201.9 0.85 0.78 1 0.847 173K 0 0.0 0.0 L5 116/0 9.10 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 276/8 21.97 GB 0.0 3.7 0.9 2.8 6.5 3.7 0.7 2.3 159.7 277.8 23.84 22.78 58 0.411 3866K 17K 0.0 0.0 Int 0/0 0.00 KB 0.0 3.7 0.9 2.8 6.5 3.7 0.7 2.3 159.7 277.8 23.84 22.78 58 0.411 3866K 17K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 3.7 0.9 2.8 3.7 0.9 0.0 0.0 241.5 240.4 15.77 15.32 15 1.051 3866K 17K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 2.8 2.8 0.0 0.0 0.0 350.8 8.07 7.46 43 0.188 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 9.2 total, 9.1 interval Flush(GB): cumulative 2.764, interval 2.764 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 6.47 GB write, 718.64 MB/s write, 3.72 GB read, 413.25 MB/s read, 23.8 seconds Interval compaction: 6.47 GB write, 723.78 MB/s write, 3.72 GB read, 416.21 MB/s read, 23.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: 5, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 5, interval: 5 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 650349 Average: 2.2803 StdDev: 6.24 Min: 0 Median: 1.5502 Max: 1396 Percentiles: P50: 1.55 P75: 1.93 P99: 5.92 P99.9: 12.76 P99.99: 20.43 ------------------------------------------------------ [ 0, 1 ] 92537 14.229% 14.229% ### ( 1, 2 ] 422854 65.020% 79.248% ############# ( 2, 3 ] 86366 13.280% 92.528% ### ( 3, 4 ] 27060 4.161% 96.689% # ( 4, 6 ] 15696 2.413% 99.103% ( 6, 10 ] 4593 0.706% 99.809% ( 10, 15 ] 1075 0.165% 99.974% ( 15, 22 ] 134 0.021% 99.995% ( 22, 34 ] 26 0.004% 99.999% ( 34, 51 ] 8 0.001% 100.000% ( 51, 76 ] 11 0.002% 100.002% ( 76, 110 ] 3 0.000% 100.002% ( 170, 250 ] 41 0.006% 100.008% ( 250, 380 ] 21 0.003% 100.012% ( 380, 580 ] 21 0.003% 100.015% ( 580, 870 ] 5 0.001% 100.016% ( 870, 1300 ] 11 0.002% 100.017% ( 1300, 1900 ] 1 0.000% 100.018% ** Level 1 read latency histogram (micros): Count: 61059 Average: 2.7706 StdDev: 6.37 Min: 1 Median: 1.8087 Max: 713 Percentiles: P50: 1.81 P75: 2.57 P99: 8.20 P99.9: 14.56 P99.99: 366.23 ------------------------------------------------------ [ 0, 1 ] 1730 2.833% 2.833% # ( 1, 2 ] 35610 58.321% 61.154% ############ ( 2, 3 ] 14790 24.222% 85.376% ##### ( 3, 4 ] 4354 7.131% 92.507% # ( 4, 6 ] 3456 5.660% 98.167% # ( 6, 10 ] 923 1.512% 99.679% ( 10, 15 ] 148 0.242% 99.921% ( 15, 22 ] 15 0.025% 99.946% ( 22, 34 ] 3 0.005% 99.951% ( 34, 51 ] 2 0.003% 99.954% ( 110, 170 ] 17 0.028% 99.982% ( 170, 250 ] 4 0.007% 99.989% ( 250, 380 ] 1 0.002% 99.990% ( 380, 580 ] 4 0.007% 99.997% ( 580, 870 ] 2 0.003% 100.000% ** Level 2 read latency histogram (micros): Count: 74332 Average: 2.4085 StdDev: 18.14 Min: 1 Median: 1.4536 Max: 3677 Percentiles: P50: 1.45 P75: 1.85 P99: 7.93 P99.9: 102.21 P99.99: 482.67 ------------------------------------------------------ [ 0, 1 ] 15784 21.234% 21.234% #### ( 1, 2 ] 47140 63.418% 84.653% ############# ( 2, 3 ] 6834 9.194% 93.847% ## ( 3, 4 ] 2200 2.960% 96.806% # ( 4, 6 ] 1250 1.682% 98.488% ( 6, 10 ] 791 1.064% 99.552% ( 10, 15 ] 198 0.266% 99.818% ( 15, 22 ] 23 0.031% 99.849% ( 22, 34 ] 9 0.012% 99.861% ( 34, 51 ] 3 0.004% 99.865% ( 51, 76 ] 1 0.001% 99.867% ( 76, 110 ] 32 0.043% 99.910% ( 110, 170 ] 39 0.052% 99.962% ( 170, 250 ] 14 0.019% 99.981% ( 250, 380 ] 4 0.005% 99.987% ( 380, 580 ] 5 0.007% 99.993% ( 580, 870 ] 2 0.003% 99.996% ( 1300, 1900 ] 1 0.001% 99.997% ( 1900, 2900 ] 1 0.001% 99.999% ( 2900, 4400 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 272465 Average: 3.2559 StdDev: 38.19 Min: 0 Median: 1.6958 Max: 5255 Percentiles: P50: 1.70 P75: 2.30 P99: 9.18 P99.9: 151.45 P99.99: 453.13 ------------------------------------------------------ [ 0, 1 ] 16025 5.881% 5.881% # ( 1, 2 ] 172750 63.403% 69.284% ############# ( 2, 3 ] 51845 19.028% 88.312% #### ( 3, 4 ] 15286 5.610% 93.923% # ( 4, 6 ] 9690 3.556% 97.479% # ( 6, 10 ] 5206 1.911% 99.390% ( 10, 15 ] 745 0.273% 99.663% ( 15, 22 ] 102 0.037% 99.701% ( 22, 34 ] 19 0.007% 99.707% ( 34, 51 ] 178 0.065% 99.773% ( 51, 76 ] 78 0.029% 99.801% ( 76, 110 ] 82 0.030% 99.832% ( 110, 170 ] 270 0.099% 99.931% ( 170, 250 ] 111 0.041% 99.971% ( 250, 380 ] 46 0.017% 99.988% ( 380, 580 ] 13 0.005% 99.993% ( 580, 870 ] 3 0.001% 99.994% ( 870, 1300 ] 5 0.002% 99.996% ( 1300, 1900 ] 10 0.004% 100.000% ( 1900, 2900 ] 4 0.001% 100.001% ( 2900, 4400 ] 10 0.004% 100.005% ( 4400, 6600 ] 7 0.003% 100.007% ** Level 4 read latency histogram (micros): Count: 65 Average: 1460.0615 StdDev: 1885.96 Min: 1 Median: 160.0000 Max: 6009 Percentiles: P50: 160.00 P75: 3138.64 P99: 6009.00 P99.9: 6009.00 P99.99: 6009.00 ------------------------------------------------------ [ 0, 1 ] 11 16.923% 16.923% ### ( 1, 2 ] 12 18.462% 35.385% #### ( 22, 34 ] 3 4.615% 40.000% # ( 76, 110 ] 4 6.154% 46.154% # ( 110, 170 ] 3 4.615% 50.769% # ( 170, 250 ] 3 4.615% 55.385% # ( 250, 380 ] 3 4.615% 60.000% # ( 870, 1300 ] 1 1.538% 61.538% ( 1300, 1900 ] 2 3.077% 64.615% # ( 1900, 2900 ] 5 7.692% 72.308% ## ( 2900, 4400 ] 11 16.923% 89.231% ### ( 4400, 6600 ] 7 10.769% 100.000% ## ** Level 5 read latency histogram (micros): Count: 20 Average: 400.7000 StdDev: 441.43 Min: 98 Median: 170.0000 Max: 1874 Percentiles: P50: 170.00 P75: 380.00 P99: 1780.00 P99.9: 1874.00 P99.99: 1874.00 ------------------------------------------------------ ( 76, 110 ] 1 5.000% 5.000% # ( 110, 170 ] 9 45.000% 50.000% ######### ( 170, 250 ] 1 5.000% 55.000% # ( 250, 380 ] 4 20.000% 75.000% #### ( 580, 870 ] 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, 320.48 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.342 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, 319.04 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.6 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/09-23:55:58 ... thread 0: (1000000,4000000) ops and (347491.2,332692.4) ops/second in (2.877771,12.023117) 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/8 3.30 GB 287.9 2.8 0.0 2.8 6.5 3.7 0.0 1.8 130.1 299.0 22.25 21.25 69 0.322 2938K 14K 0.0 0.0 L1 1/0 9.98 MB 1.0 0.2 0.2 0.0 0.2 0.2 0.1 1.0 238.2 237.2 1.06 1.03 1 1.055 255K 1028 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.6 247.2 1.04 1.01 2 0.521 262K 426 0.0 0.0 L3 20/0 979.20 MB 1.0 1.3 0.4 0.9 1.3 0.4 0.0 3.2 237.6 236.5 5.48 5.28 4 1.370 1322K 6301 0.0 0.0 L4 123/0 9.52 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.0 1.0 201.9 201.9 0.85 0.78 1 0.847 173K 0 0.0 0.0 L5 116/0 9.10 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 279/8 22.89 GB 0.0 4.8 0.9 3.8 8.4 4.6 0.7 2.3 159.0 281.3 30.67 29.36 77 0.398 4952K 22K 0.0 0.0 Int 0/0 0.00 KB 0.0 4.8 0.9 3.8 8.4 4.6 0.7 2.3 159.0 281.3 30.67 29.36 77 0.398 4952K 22K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 4.8 0.9 3.8 4.7 0.9 0.0 0.0 244.1 243.0 19.97 19.45 19 1.051 4952K 22K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 3.7 3.7 0.0 0.0 0.0 352.8 10.70 9.91 58 0.184 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.1 total, 12.0 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.43 GB write, 713.62 MB/s write, 4.76 GB read, 403.34 MB/s read, 30.7 seconds Interval compaction: 8.43 GB write, 717.50 MB/s write, 4.76 GB read, 405.53 MB/s read, 30.7 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 5, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 5, interval: 5 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 900689 Average: 2.2239 StdDev: 6.14 Min: 0 Median: 1.5225 Max: 1396 Percentiles: P50: 1.52 P75: 1.90 P99: 5.80 P99.9: 12.37 P99.99: 19.57 ------------------------------------------------------ [ 0, 1 ] 140204 15.566% 15.566% ### ( 1, 2 ] 593588 65.904% 81.470% ############# ( 2, 3 ] 108415 12.037% 93.507% ## ( 3, 4 ] 32997 3.664% 97.170% # ( 4, 6 ] 18322 2.034% 99.205% ( 6, 10 ] 5623 0.624% 99.829% ( 10, 15 ] 1353 0.150% 99.979% ( 15, 22 ] 150 0.017% 99.996% ( 22, 34 ] 29 0.003% 99.999% ( 34, 51 ] 10 0.001% 100.000% ( 51, 76 ] 13 0.001% 100.002% ( 76, 110 ] 3 0.000% 100.002% ( 170, 250 ] 56 0.006% 100.008% ( 250, 380 ] 27 0.003% 100.011% ( 380, 580 ] 32 0.004% 100.015% ( 580, 870 ] 7 0.001% 100.016% ( 870, 1300 ] 15 0.002% 100.017% ( 1300, 1900 ] 1 0.000% 100.017% ** Level 1 read latency histogram (micros): Count: 61059 Average: 2.7706 StdDev: 6.37 Min: 1 Median: 1.8087 Max: 713 Percentiles: P50: 1.81 P75: 2.57 P99: 8.20 P99.9: 14.56 P99.99: 366.23 ------------------------------------------------------ [ 0, 1 ] 1730 2.833% 2.833% # ( 1, 2 ] 35610 58.321% 61.154% ############ ( 2, 3 ] 14790 24.222% 85.376% ##### ( 3, 4 ] 4354 7.131% 92.507% # ( 4, 6 ] 3456 5.660% 98.167% # ( 6, 10 ] 923 1.512% 99.679% ( 10, 15 ] 148 0.242% 99.921% ( 15, 22 ] 15 0.025% 99.946% ( 22, 34 ] 3 0.005% 99.951% ( 34, 51 ] 2 0.003% 99.954% ( 110, 170 ] 17 0.028% 99.982% ( 170, 250 ] 4 0.007% 99.989% ( 250, 380 ] 1 0.002% 99.990% ( 380, 580 ] 4 0.007% 99.997% ( 580, 870 ] 2 0.003% 100.000% ** Level 2 read latency histogram (micros): Count: 74332 Average: 2.4085 StdDev: 18.14 Min: 1 Median: 1.4536 Max: 3677 Percentiles: P50: 1.45 P75: 1.85 P99: 7.93 P99.9: 102.21 P99.99: 482.67 ------------------------------------------------------ [ 0, 1 ] 15784 21.234% 21.234% #### ( 1, 2 ] 47140 63.418% 84.653% ############# ( 2, 3 ] 6834 9.194% 93.847% ## ( 3, 4 ] 2200 2.960% 96.806% # ( 4, 6 ] 1250 1.682% 98.488% ( 6, 10 ] 791 1.064% 99.552% ( 10, 15 ] 198 0.266% 99.818% ( 15, 22 ] 23 0.031% 99.849% ( 22, 34 ] 9 0.012% 99.861% ( 34, 51 ] 3 0.004% 99.865% ( 51, 76 ] 1 0.001% 99.867% ( 76, 110 ] 32 0.043% 99.910% ( 110, 170 ] 39 0.052% 99.962% ( 170, 250 ] 14 0.019% 99.981% ( 250, 380 ] 4 0.005% 99.987% ( 380, 580 ] 5 0.007% 99.993% ( 580, 870 ] 2 0.003% 99.996% ( 1300, 1900 ] 1 0.001% 99.997% ( 1900, 2900 ] 1 0.001% 99.999% ( 2900, 4400 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 272465 Average: 3.2559 StdDev: 38.19 Min: 0 Median: 1.6958 Max: 5255 Percentiles: P50: 1.70 P75: 2.30 P99: 9.18 P99.9: 151.45 P99.99: 453.13 ------------------------------------------------------ [ 0, 1 ] 16025 5.881% 5.881% # ( 1, 2 ] 172750 63.403% 69.284% ############# ( 2, 3 ] 51845 19.028% 88.312% #### ( 3, 4 ] 15286 5.610% 93.923% # ( 4, 6 ] 9690 3.556% 97.479% # ( 6, 10 ] 5206 1.911% 99.390% ( 10, 15 ] 745 0.273% 99.663% ( 15, 22 ] 102 0.037% 99.701% ( 22, 34 ] 19 0.007% 99.707% ( 34, 51 ] 178 0.065% 99.773% ( 51, 76 ] 78 0.029% 99.801% ( 76, 110 ] 82 0.030% 99.832% ( 110, 170 ] 270 0.099% 99.931% ( 170, 250 ] 111 0.041% 99.971% ( 250, 380 ] 46 0.017% 99.988% ( 380, 580 ] 13 0.005% 99.993% ( 580, 870 ] 3 0.001% 99.994% ( 870, 1300 ] 5 0.002% 99.996% ( 1300, 1900 ] 10 0.004% 100.000% ( 1900, 2900 ] 4 0.001% 100.001% ( 2900, 4400 ] 10 0.004% 100.005% ( 4400, 6600 ] 7 0.003% 100.007% ** Level 4 read latency histogram (micros): Count: 65 Average: 1460.0615 StdDev: 1885.96 Min: 1 Median: 160.0000 Max: 6009 Percentiles: P50: 160.00 P75: 3138.64 P99: 6009.00 P99.9: 6009.00 P99.99: 6009.00 ------------------------------------------------------ [ 0, 1 ] 11 16.923% 16.923% ### ( 1, 2 ] 12 18.462% 35.385% #### ( 22, 34 ] 3 4.615% 40.000% # ( 76, 110 ] 4 6.154% 46.154% # ( 110, 170 ] 3 4.615% 50.769% # ( 170, 250 ] 3 4.615% 55.385% # ( 250, 380 ] 3 4.615% 60.000% # ( 870, 1300 ] 1 1.538% 61.538% ( 1300, 1900 ] 2 3.077% 64.615% # ( 1900, 2900 ] 5 7.692% 72.308% ## ( 2900, 4400 ] 11 16.923% 89.231% ### ( 4400, 6600 ] 7 10.769% 100.000% ## ** Level 5 read latency histogram (micros): Count: 20 Average: 400.7000 StdDev: 441.43 Min: 98 Median: 170.0000 Max: 1874 Percentiles: P50: 170.00 P75: 380.00 P99: 1780.00 P99.9: 1874.00 P99.99: 1874.00 ------------------------------------------------------ ( 76, 110 ] 1 5.000% 5.000% # ( 110, 170 ] 9 45.000% 50.000% ######### ( 170, 250 ] 1 5.000% 55.000% # ( 250, 380 ] 4 20.000% 75.000% #### ( 580, 870 ] 1 5.000% 80.000% # ( 870, 1300 ] 3 15.000% 95.000% ### ( 1300, 1900 ] 1 5.000% 100.000% # ** DB Stats ** Uptime(secs): 12.1 total, 2.9 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 325.60 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.342 H:M:S, 2.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 342.00 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 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.045 micros/op 247217 ops/sec 20.059 seconds 4958999 operations; 239.5 MB/s Microseconds per write: Count: 4958999 Average: 4.0450 StdDev: 112.87 Min: 1 Median: 1.8036 Max: 173169 Percentiles: P50: 1.80 P75: 3.11 P99: 8.53 P99.9: 162.01 P99.99: 2419.67 ------------------------------------------------------ [ 0, 1 ] 598253 12.064% 12.064% ## ( 1, 2 ] 2341019 47.207% 59.271% ######### ( 2, 3 ] 703680 14.190% 73.461% ### ( 3, 4 ] 667767 13.466% 86.927% ### ( 4, 6 ] 554148 11.175% 98.102% ## ( 6, 10 ] 70379 1.419% 99.521% ( 10, 15 ] 10135 0.204% 99.725% ( 15, 22 ] 3169 0.064% 99.789% ( 22, 34 ] 1323 0.027% 99.816% ( 34, 51 ] 183 0.004% 99.820% ( 51, 76 ] 25 0.001% 99.820% ( 110, 170 ] 4567 0.092% 99.912% ( 170, 250 ] 389 0.008% 99.920% ( 250, 380 ] 72 0.001% 99.922% ( 380, 580 ] 3 0.000% 99.922% ( 580, 870 ] 7 0.000% 99.922% ( 870, 1300 ] 2852 0.058% 99.979% ( 1300, 1900 ] 1 0.000% 99.979% ( 1900, 2900 ] 1022 0.021% 100.000% ( 2900, 4400 ] 1 0.000% 100.000% ( 9900, 14000 ] 1 0.000% 100.000% ( 22000, 33000 ] 1 0.000% 100.000% ( 110000, 170000 ] 1 0.000% 100.000% ( 170000, 250000 ] 1 0.000% 100.000% STATISTICS: rocksdb.block.cache.miss COUNT : 0 rocksdb.block.cache.hit COUNT : 0 rocksdb.block.cache.add COUNT : 0 rocksdb.block.cache.add.failures COUNT : 0 rocksdb.block.cache.index.miss COUNT : 0 rocksdb.block.cache.index.hit COUNT : 0 rocksdb.block.cache.index.add COUNT : 0 rocksdb.block.cache.index.bytes.insert COUNT : 0 rocksdb.block.cache.filter.miss COUNT : 0 rocksdb.block.cache.filter.hit COUNT : 0 rocksdb.block.cache.filter.add COUNT : 0 rocksdb.block.cache.filter.bytes.insert COUNT : 0 rocksdb.block.cache.data.miss COUNT : 0 rocksdb.block.cache.data.hit COUNT : 0 rocksdb.block.cache.data.add COUNT : 0 rocksdb.block.cache.data.bytes.insert COUNT : 0 rocksdb.block.cache.bytes.read COUNT : 0 rocksdb.block.cache.bytes.write COUNT : 0 rocksdb.bloom.filter.useful COUNT : 0 rocksdb.bloom.filter.full.positive COUNT : 0 rocksdb.bloom.filter.full.true.positive COUNT : 0 rocksdb.persistent.cache.hit COUNT : 0 rocksdb.persistent.cache.miss COUNT : 0 rocksdb.sim.block.cache.hit COUNT : 0 rocksdb.sim.block.cache.miss COUNT : 0 rocksdb.memtable.hit COUNT : 0 rocksdb.memtable.miss COUNT : 0 rocksdb.l0.hit COUNT : 0 rocksdb.l1.hit COUNT : 0 rocksdb.l2andup.hit COUNT : 0 rocksdb.compaction.key.drop.new COUNT : 150821 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 : 4958999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 5117686968 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 : 156 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 5525749 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 : 7822634833 rocksdb.compact.write.bytes COUNT : 7673000104 rocksdb.flush.write.bytes COUNT : 5079281272 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 : 14 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 : 93 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 : 5045408768 rocksdb.memtable.garbage.bytes.at.flush COUNT : 8432640 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 : 7863066778 rocksdb.non.last.level.read.count COUNT : 1896918 rocksdb.block.checksum.compute.count COUNT : 1896620 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.455725 P95 : 4.907843 P99 : 7.141292 P100 : 173167.000000 COUNT : 4958999 SUM : 17745118 rocksdb.compaction.times.micros P50 : 1008750.000000 P95 : 1830000.000000 P99 : 3214669.000000 P100 : 3214669.000000 COUNT : 24 SUM : 24804100 rocksdb.compaction.times.cpu_micros P50 : 996000.000000 P95 : 1830000.000000 P99 : 3087902.000000 P100 : 3087902.000000 COUNT : 24 SUM : 24186683 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 : 523.181818 P95 : 1135.000000 P99 : 1135.000000 P100 : 1135.000000 COUNT : 75 SUM : 45926 rocksdb.compaction.outfile.sync.micros P50 : 717.750000 P95 : 1217.307692 P99 : 1395.000000 P100 : 1395.000000 COUNT : 70 SUM : 50900 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 : 76.000000 P95 : 198.800000 P99 : 374.800000 P100 : 487.000000 COUNT : 104 SUM : 10239 rocksdb.table.open.io.micros P50 : 767.439024 P95 : 14200.000000 P99 : 19496.000000 P100 : 19496.000000 COUNT : 156 SUM : 353734 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.612250 P95 : 6.143478 P99 : 10.074223 P100 : 13516.000000 COUNT : 1896232 SUM : 8595044 rocksdb.read.block.get.micros P50 : 351.865672 P95 : 4300.000000 P99 : 6113.000000 P100 : 6113.000000 COUNT : 312 SUM : 235588 rocksdb.write.raw.block.micros P50 : 0.511783 P95 : 0.972388 P99 : 2.926806 P100 : 2952.000000 COUNT : 3088849 SUM : 5918440 rocksdb.numfiles.in.singlecompaction P50 : 3.343750 P95 : 9.100000 P99 : 18.000000 P100 : 18.000000 COUNT : 29 SUM : 123 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.559370 P95 : 1177.865230 P99 : 2543.767123 P100 : 172919.000000 COUNT : 36707 SUM : 5527936 rocksdb.sst.read.micros P50 : 1.514918 P95 : 3.486659 P99 : 6.662235 P100 : 6009.000000 COUNT : 1897053 SUM : 4686177 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 : 4958999 SUM : 5117686968 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 : 198888.888889 P95 : 248888.888889 P99 : 347500.000000 P100 : 349203.000000 COUNT : 75 SUM : 13701733 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 : 97 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