[2024-12-09 10:27:42.697468] Starting SPDK v25.01-pre git sha1 b71c8b8dd / DPDK 24.03.0 initialization... [2024-12-09 10:27:42.697660] [ 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_pid586984 ] Set seed to 1733736462694353 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-12-09 10:27:42.837002] app.c: 919:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-12-09 10:27:42.948377] app.c: 612:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-12-09 10:27:42.948453] app.c: 613:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 586984' to capture a snapshot of events at runtime. [2024-12-09 10:27:42.948468] app.c: 618:app_setup_trace: *NOTICE*: 'spdk_trace' without parameters will also work if this is the only [2024-12-09 10:27:42.948483] app.c: 619:app_setup_trace: *NOTICE*: SPDK application currently running. [2024-12-09 10:27:42.948493] app.c: 620:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid586984 for offline analysis/debug. [2024-12-09 10:27:42.949783] reactor.c:1005:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Mon Dec 9 10:27:48 2024 CPU: 36 * Intel(R) Xeon(R) CPU E5-2699 v3 @ 2.30GHz CPUCache: 46080 KB 2024/12/09-10:27:54 ... thread 0: (1000000,1000000) ops and (159019.3,159019.3) ops/second in (6.288546,6.288546) 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 6/2 440.22 MB 31.4 0.0 0.0 0.0 0.9 0.9 0.0 1.0 0.0 172.7 5.10 4.76 11 0.463 0 0 0.0 0.0 L1 4/4 250.35 MB 0.0 0.2 0.2 0.0 0.2 0.2 0.2 1.0 189.9 189.1 1.32 1.29 1 1.324 255K 1067 0.0 0.0 L2 1/1 103.90 MB 0.0 0.4 0.2 0.3 0.4 0.2 0.1 2.4 202.4 201.8 2.21 2.14 2 1.104 453K 1362 0.0 0.0 L3 15/7 811.06 MB 0.2 0.2 0.2 0.0 0.2 0.2 0.0 1.0 102.8 102.8 1.76 1.68 1 1.762 183K 0 0.0 0.0 L4 112/0 9.72 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 104/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 242/14 20.08 GB 0.0 0.9 0.6 0.3 1.7 1.5 0.3 2.0 84.6 169.1 10.39 9.86 15 0.693 893K 2429 0.0 0.0 Int 0/0 0.00 KB 0.0 0.9 0.6 0.3 1.7 1.5 0.2 2.0 84.6 169.1 10.39 9.86 15 0.693 893K 2429 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.9 0.6 0.3 0.9 0.6 0.0 0.0 166.1 165.6 5.29 5.10 4 1.324 893K 2429 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 172.7 5.10 4.76 11 0.463 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.4 total, 6.3 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.72 GB write, 273.52 MB/s write, 0.86 GB read, 136.89 MB/s read, 10.4 seconds Interval compaction: 1.72 GB write, 279.34 MB/s write, 0.86 GB read, 139.80 MB/s read, 10.4 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 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: 140957 Average: 2.5829 StdDev: 8.81 Min: 1 Median: 1.7302 Max: 2128 Percentiles: P50: 1.73 P75: 2.29 P99: 7.81 P99.9: 14.80 P99.99: 444.54 ------------------------------------------------------ [ 0, 1 ] 3711 2.633% 2.633% # ( 1, 2 ] 91433 64.866% 67.499% ############# ( 2, 3 ] 36114 25.621% 93.119% ##### ( 3, 4 ] 4021 2.853% 95.972% # ( 4, 6 ] 3930 2.788% 98.760% # ( 6, 10 ] 749 0.531% 99.291% ( 10, 15 ] 894 0.634% 99.926% ( 15, 22 ] 60 0.043% 99.968% ( 22, 34 ] 16 0.011% 99.979% ( 34, 51 ] 3 0.002% 99.982% ( 51, 76 ] 3 0.002% 99.984% ( 76, 110 ] 2 0.001% 99.985% ( 250, 380 ] 5 0.004% 99.989% ( 380, 580 ] 9 0.006% 99.995% ( 580, 870 ] 7 0.005% 100.000% ( 1900, 2900 ] 1 0.001% 100.001% ** Level 1 read latency histogram (micros): Count: 82989 Average: 2.9507 StdDev: 15.77 Min: 1 Median: 1.9059 Max: 2670 Percentiles: P50: 1.91 P75: 2.55 P99: 10.07 P99.9: 29.21 P99.99: 470.04 ------------------------------------------------------ [ 0, 1 ] 1028 1.239% 1.239% ( 1, 2 ] 44671 53.828% 55.066% ########### ( 2, 3 ] 30015 36.167% 91.234% ####### ( 3, 4 ] 3432 4.135% 95.369% # ( 4, 6 ] 2203 2.655% 98.024% # ( 6, 10 ] 801 0.965% 98.989% ( 10, 15 ] 699 0.842% 99.831% ( 15, 22 ] 49 0.059% 99.890% ( 22, 34 ] 15 0.018% 99.908% ( 34, 51 ] 1 0.001% 99.910% ( 76, 110 ] 6 0.007% 99.917% ( 110, 170 ] 36 0.043% 99.960% ( 170, 250 ] 11 0.013% 99.973% ( 250, 380 ] 12 0.014% 99.988% ( 380, 580 ] 6 0.007% 99.995% ( 870, 1300 ] 2 0.002% 99.998% ( 1300, 1900 ] 1 0.001% 99.999% ( 1900, 2900 ] 2 0.002% 100.001% ** Level 2 read latency histogram (micros): Count: 87476 Average: 3.7656 StdDev: 5.82 Min: 1 Median: 3.1612 Max: 1006 Percentiles: P50: 3.16 P75: 4.24 P99: 13.04 P99.9: 28.73 P99.99: 220.10 ------------------------------------------------------ [ 0, 1 ] 1718 1.964% 1.964% ( 1, 2 ] 34665 39.628% 41.592% ######## ( 2, 3 ] 3589 4.103% 45.695% # ( 3, 4 ] 23357 26.701% 72.396% ##### ( 4, 6 ] 18788 21.478% 93.874% #### ( 6, 10 ] 3831 4.379% 98.253% # ( 10, 15 ] 1073 1.227% 99.480% ( 15, 22 ] 280 0.320% 99.800% ( 22, 34 ] 156 0.178% 99.978% ( 34, 51 ] 6 0.007% 99.985% ( 51, 76 ] 3 0.003% 99.989% ( 170, 250 ] 2 0.002% 99.991% ( 250, 380 ] 4 0.005% 99.995% ( 380, 580 ] 2 0.002% 99.998% ( 580, 870 ] 1 0.001% 99.999% ( 870, 1300 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 73631 Average: 6.9362 StdDev: 73.91 Min: 2 Median: 3.8533 Max: 8366 Percentiles: P50: 3.85 P75: 5.06 P99: 20.22 P99.9: 248.08 P99.99: 4045.53 ------------------------------------------------------ ( 1, 2 ] 6 0.008% 0.008% ( 2, 3 ] 1247 1.694% 1.702% ( 3, 4 ] 41678 56.604% 58.306% ########### ( 4, 6 ] 23293 31.635% 89.940% ###### ( 6, 10 ] 4349 5.906% 95.847% # ( 10, 15 ] 1859 2.525% 98.372% # ( 15, 22 ] 622 0.845% 99.216% ( 22, 34 ] 327 0.444% 99.660% ( 34, 51 ] 19 0.026% 99.686% ( 76, 110 ] 27 0.037% 99.723% ( 110, 170 ] 65 0.088% 99.811% ( 170, 250 ] 68 0.092% 99.904% ( 250, 380 ] 23 0.031% 99.935% ( 380, 580 ] 14 0.019% 99.954% ( 580, 870 ] 4 0.005% 99.959% ( 870, 1300 ] 2 0.003% 99.962% ( 1300, 1900 ] 3 0.004% 99.966% ( 1900, 2900 ] 11 0.015% 99.981% ( 2900, 4400 ] 10 0.014% 99.995% ( 4400, 6600 ] 4 0.005% 100.000% ( 6600, 9900 ] 1 0.001% 100.001% ** Level 4 read latency histogram (micros): Count: 40 Average: 4487.5000 StdDev: 2255.96 Min: 1352 Median: 3900.0000 Max: 9901 Percentiles: P50: 3900.00 P75: 6285.71 P99: 9901.00 P99.9: 9901.00 P99.99: 9901.00 ------------------------------------------------------ ( 1300, 1900 ] 1 2.500% 2.500% # ( 1900, 2900 ] 11 27.500% 30.000% ###### ( 2900, 4400 ] 12 30.000% 60.000% ###### ( 4400, 6600 ] 7 17.500% 77.500% #### ( 6600, 9900 ] 8 20.000% 97.500% #### ( 9900, 14000 ] 1 2.500% 100.000% # ** DB Stats ** Uptime(secs): 6.4 total, 6.3 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 153.18 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:1.382 H:M:S, 21.5 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 156.42 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:1.382 H:M:S, 22.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/09-10:28:02 ... thread 0: (1000000,2000000) ops and (132849.0,144760.9) ops/second in (7.527341,13.815887) 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 6/4 752.36 MB 50.1 0.5 0.0 0.5 2.3 1.8 0.0 1.3 36.0 170.9 13.97 13.12 29 0.482 511K 2493 0.0 0.0 L1 0/0 0.00 KB 0.0 1.5 0.9 0.6 1.5 0.9 0.2 1.6 183.1 180.7 8.56 8.25 3 2.854 1592K 20K 0.0 0.0 L2 8/5 922.60 MB 3.7 0.4 0.2 0.3 0.4 0.2 1.0 2.4 202.4 201.8 2.21 2.14 2 1.104 453K 1362 0.0 0.0 L3 20/15 908.89 MB 0.1 0.9 0.3 0.6 0.9 0.3 0.0 3.2 111.7 110.9 8.19 7.80 2 4.097 929K 6162 0.0 0.0 L4 112/0 9.72 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 104/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 250/24 21.04 GB 0.0 3.4 1.4 2.0 5.2 3.2 1.2 2.8 104.2 160.6 32.94 31.31 36 0.915 3486K 30K 0.0 0.0 Int 0/0 0.00 KB 0.0 3.4 1.4 2.0 5.2 3.2 1.1 2.8 104.2 160.6 32.94 31.31 36 0.915 3486K 30K 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.4 1.4 2.0 3.3 1.4 0.0 0.0 153.9 152.6 22.30 21.46 9 2.478 3486K 30K 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 177.4 10.64 9.85 27 0.394 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): 14.0 total, 13.8 interval Flush(GB): cumulative 1.843, interval 1.843 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 5.17 GB write, 379.11 MB/s write, 3.35 GB read, 246.07 MB/s read, 32.9 seconds Interval compaction: 5.17 GB write, 382.78 MB/s write, 3.35 GB read, 248.45 MB/s read, 32.9 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 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: 423624 Average: 3.2252 StdDev: 13.03 Min: 1 Median: 2.0538 Max: 3088 Percentiles: P50: 2.05 P75: 2.90 P99: 10.11 P99.9: 29.87 P99.99: 274.82 ------------------------------------------------------ [ 0, 1 ] 4717 1.113% 1.113% ( 1, 2 ] 200328 47.289% 48.403% ######### ( 2, 3 ] 125746 29.683% 78.086% ###### ( 3, 4 ] 53299 12.582% 90.668% ### ( 4, 6 ] 29176 6.887% 97.555% # ( 6, 10 ] 6047 1.427% 98.982% ( 10, 15 ] 3384 0.799% 99.781% ( 15, 22 ] 386 0.091% 99.872% ( 22, 34 ] 179 0.042% 99.915% ( 34, 51 ] 7 0.002% 99.916% ( 51, 76 ] 4 0.001% 99.917% ( 76, 110 ] 35 0.008% 99.925% ( 110, 170 ] 149 0.035% 99.961% ( 170, 250 ] 117 0.028% 99.988% ( 250, 380 ] 40 0.009% 99.998% ( 380, 580 ] 45 0.011% 100.008% ( 580, 870 ] 19 0.004% 100.013% ( 870, 1300 ] 5 0.001% 100.014% ( 1300, 1900 ] 2 0.000% 100.014% ( 1900, 2900 ] 2 0.000% 100.015% ( 2900, 4400 ] 2 0.000% 100.015% ** Level 1 read latency histogram (micros): Count: 216044 Average: 3.1848 StdDev: 14.92 Min: 1 Median: 2.0027 Max: 2670 Percentiles: P50: 2.00 P75: 2.65 P99: 10.59 P99.9: 131.44 P99.99: 510.87 ------------------------------------------------------ [ 0, 1 ] 1841 0.852% 0.852% ( 1, 2 ] 105957 49.044% 49.896% ########## ( 2, 3 ] 83853 38.813% 88.709% ######## ( 3, 4 ] 10346 4.789% 93.498% # ( 4, 6 ] 8039 3.721% 97.219% # ( 6, 10 ] 3628 1.679% 98.898% ( 10, 15 ] 1864 0.863% 99.761% ( 15, 22 ] 158 0.073% 99.834% ( 22, 34 ] 47 0.022% 99.856% ( 34, 51 ] 3 0.001% 99.857% ( 76, 110 ] 45 0.021% 99.878% ( 110, 170 ] 137 0.063% 99.942% ( 170, 250 ] 62 0.029% 99.970% ( 250, 380 ] 30 0.014% 99.984% ( 380, 580 ] 22 0.010% 99.994% ( 580, 870 ] 7 0.003% 99.998% ( 870, 1300 ] 11 0.005% 100.003% ( 1300, 1900 ] 3 0.001% 100.004% ( 1900, 2900 ] 2 0.001% 100.005% ** Level 2 read latency histogram (micros): Count: 113141 Average: 4.0600 StdDev: 11.98 Min: 1 Median: 3.4228 Max: 3622 Percentiles: P50: 3.42 P75: 4.46 P99: 13.76 P99.9: 29.12 P99.99: 151.15 ------------------------------------------------------ [ 0, 1 ] 1718 1.518% 1.518% ( 1, 2 ] 34665 30.639% 32.157% ###### ( 2, 3 ] 4029 3.561% 35.718% # ( 3, 4 ] 38221 33.782% 69.500% ####### ( 4, 6 ] 27168 24.013% 93.513% ##### ( 6, 10 ] 4928 4.356% 97.868% # ( 10, 15 ] 1704 1.506% 99.374% ( 15, 22 ] 465 0.411% 99.785% ( 22, 34 ] 219 0.194% 99.979% ( 34, 51 ] 8 0.007% 99.986% ( 51, 76 ] 3 0.003% 99.989% ( 76, 110 ] 1 0.001% 99.989% ( 110, 170 ] 1 0.001% 99.990% ( 170, 250 ] 2 0.002% 99.992% ( 250, 380 ] 4 0.004% 99.996% ( 380, 580 ] 2 0.002% 99.997% ( 580, 870 ] 1 0.001% 99.998% ( 870, 1300 ] 1 0.001% 99.999% ( 2900, 4400 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 178100 Average: 6.1384 StdDev: 58.16 Min: 1 Median: 3.6474 Max: 12744 Percentiles: P50: 3.65 P75: 4.41 P99: 18.84 P99.9: 259.59 P99.99: 2462.73 ------------------------------------------------------ [ 0, 1 ] 11 0.006% 0.006% ( 1, 2 ] 4425 2.485% 2.491% ( 2, 3 ] 17683 9.929% 12.419% ## ( 3, 4 ] 103388 58.051% 70.470% ############ ( 4, 6 ] 39029 21.914% 92.384% #### ( 6, 10 ] 7367 4.136% 96.520% # ( 10, 15 ] 3798 2.133% 98.653% ( 15, 22 ] 1126 0.632% 99.285% ( 22, 34 ] 483 0.271% 99.556% ( 34, 51 ] 29 0.016% 99.573% ( 51, 76 ] 1 0.001% 99.573% ( 76, 110 ] 66 0.037% 99.610% ( 110, 170 ] 293 0.165% 99.775% ( 170, 250 ] 217 0.122% 99.897% ( 250, 380 ] 80 0.045% 99.942% ( 380, 580 ] 51 0.029% 99.970% ( 580, 870 ] 17 0.010% 99.980% ( 870, 1300 ] 8 0.004% 99.984% ( 1300, 1900 ] 4 0.002% 99.987% ( 1900, 2900 ] 11 0.006% 99.993% ( 2900, 4400 ] 10 0.006% 99.998% ( 4400, 6600 ] 4 0.002% 100.001% ( 6600, 9900 ] 1 0.001% 100.001% ( 9900, 14000 ] 1 0.001% 100.002% ** Level 4 read latency histogram (micros): Count: 40 Average: 4487.5000 StdDev: 2255.96 Min: 1352 Median: 3900.0000 Max: 9901 Percentiles: P50: 3900.00 P75: 6285.71 P99: 9901.00 P99.9: 9901.00 P99.99: 9901.00 ------------------------------------------------------ ( 1300, 1900 ] 1 2.500% 2.500% # ( 1900, 2900 ] 11 27.500% 30.000% ###### ( 2900, 4400 ] 12 30.000% 60.000% ###### ( 4400, 6600 ] 7 17.500% 77.500% #### ( 6600, 9900 ] 8 20.000% 97.500% #### ( 9900, 14000 ] 1 2.500% 100.000% # ** DB Stats ** Uptime(secs): 14.0 total, 7.5 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 141.08 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:1.382 H:M:S, 9.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 130.75 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.000 H:M:S, 0.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 5 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 : 7.135 micros/op 140147 ops/sec 20.008 seconds 2803999 operations; 135.8 MB/s Microseconds per write: Count: 2803999 Average: 7.1353 StdDev: 399.48 Min: 1 Median: 5.2790 Max: 504395 Percentiles: P50: 5.28 P75: 7.67 P99: 19.17 P99.9: 111.58 P99.99: 358.36 ------------------------------------------------------ [ 0, 1 ] 15732 0.561% 0.561% ( 1, 2 ] 252446 9.003% 9.564% ## ( 2, 3 ] 185191 6.605% 16.169% # ( 3, 4 ] 217566 7.759% 23.928% ## ( 4, 6 ] 1143162 40.769% 64.697% ######## ( 6, 10 ] 690796 24.636% 89.333% ##### ( 10, 15 ] 252238 8.996% 98.329% ## ( 15, 22 ] 31610 1.127% 99.456% ( 22, 34 ] 11344 0.405% 99.860% ( 34, 51 ] 873 0.031% 99.892% ( 51, 76 ] 165 0.006% 99.897% ( 76, 110 ] 57 0.002% 99.899% ( 110, 170 ] 571 0.020% 99.920% ( 170, 250 ] 894 0.032% 99.952% ( 250, 380 ] 1288 0.046% 99.998% ( 380, 580 ] 55 0.002% 100.000% ( 580, 870 ] 2 0.000% 100.000% ( 1300, 1900 ] 2 0.000% 100.000% ( 9900, 14000 ] 1 0.000% 100.000% ( 33000, 50000 ] 1 0.000% 100.000% ( 75000, 110000 ] 1 0.000% 100.000% ( 170000, 250000 ] 2 0.000% 100.000% ( 250000, 380000 ] 1 0.000% 100.000% ( 380000, 570000 ] 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 : 84682 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 : 2803999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 2893726968 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 : 147 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 1382092 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 : 6843807436 rocksdb.compact.write.bytes COUNT : 6757050916 rocksdb.flush.write.bytes COUNT : 2836043637 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 : 24 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 : 59 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 : 2817566720 rocksdb.memtable.garbage.bytes.at.flush COUNT : 5121024 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 : 6877089095 rocksdb.non.last.level.read.count COUNT : 1658994 rocksdb.block.checksum.compute.count COUNT : 1658724 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 : 3.979939 P95 : 10.582553 P99 : 15.079714 P100 : 504394.000000 COUNT : 2803999 SUM : 16647844 rocksdb.compaction.times.micros P50 : 1856250.000000 P95 : 5565000.000000 P99 : 6313000.000000 P100 : 6432460.000000 COUNT : 17 SUM : 39237637 rocksdb.compaction.times.cpu_micros P50 : 1850000.000000 P95 : 5565000.000000 P99 : 6122995.000000 P100 : 6122995.000000 COUNT : 17 SUM : 37320416 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 : 1013.333333 P95 : 1696.000000 P99 : 1696.000000 P100 : 1696.000000 COUNT : 40 SUM : 40217 rocksdb.compaction.outfile.sync.micros P50 : 801.938776 P95 : 1892.500000 P99 : 15520.000000 P100 : 16110.000000 COUNT : 81 SUM : 107945 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 : 138.378378 P95 : 279.250000 P99 : 2190.000000 P100 : 2218.000000 COUNT : 71 SUM : 12524 rocksdb.table.open.io.micros P50 : 1556.250000 P95 : 19840.000000 P99 : 25185.000000 P100 : 25185.000000 COUNT : 147 SUM : 546598 rocksdb.db.multiget.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.read.block.compaction.micros P50 : 5.688940 P95 : 12.181652 P99 : 21.113177 P100 : 13777.000000 COUNT : 1658347 SUM : 12498501 rocksdb.read.block.get.micros P50 : 619.322034 P95 : 5307.500000 P99 : 9188.666667 P100 : 10036.000000 COUNT : 294 SUM : 376131 rocksdb.write.raw.block.micros P50 : 0.666691 P95 : 1.881437 P99 : 5.646082 P100 : 6363.000000 COUNT : 2324318 SUM : 6508032 rocksdb.numfiles.in.singlecompaction P50 : 3.333333 P95 : 11.000000 P99 : 13.000000 P100 : 13.000000 COUNT : 32 SUM : 131 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 : 210000.000000 P95 : 504167.000000 P99 : 504167.000000 P100 : 504167.000000 COUNT : 6 SUM : 1382092 rocksdb.sst.read.micros P50 : 2.700587 P95 : 5.991291 P99 : 13.501095 P100 : 12744.000000 COUNT : 1659136 SUM : 7274988 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 : 2803999 SUM : 2893726968 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 : 310000.000000 P95 : 692370.000000 P99 : 692370.000000 P100 : 692370.000000 COUNT : 40 SUM : 14188301 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 : 85 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