[2024-11-20 11:09:49.442654] Starting SPDK v25.01-pre git sha1 4d3e9954d / DPDK 24.03.0 initialization... [2024-11-20 11:09:49.442970] [ 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_pid2400991 ] Set seed to 1732097389435404 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-11-20 11:09:49.596821] app.c: 919:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-11-20 11:09:49.702184] app.c: 612:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-11-20 11:09:49.702239] app.c: 613:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 2400991' to capture a snapshot of events at runtime. [2024-11-20 11:09:49.702252] app.c: 618:app_setup_trace: *NOTICE*: 'spdk_trace' without parameters will also work if this is the only [2024-11-20 11:09:49.702265] app.c: 619:app_setup_trace: *NOTICE*: SPDK application currently running. [2024-11-20 11:09:49.702279] app.c: 620:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid2400991 for offline analysis/debug. [2024-11-20 11:09:49.703532] reactor.c:1005:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Wed Nov 20 11:09:52 2024 CPU: 72 * Intel(R) Xeon(R) Gold 6140 CPU @ 2.30GHz CPUCache: 25344 KB 2024/11/20-11:09:58 ... thread 0: (1000000,1000000) ops and (174814.7,174814.7) ops/second in (5.720342,5.720342) 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 13/10 1.08 GB 50.2 0.2 0.0 0.2 1.1 0.9 0.0 1.3 36.0 161.8 6.99 3.64 13 0.538 255K 1238 0.0 0.0 L1 8/8 994.66 MB 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L2 2/2 213.32 MB 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L3 22/3 1.02 GB 0.9 2.7 1.5 1.2 2.5 1.3 0.0 1.7 139.2 131.4 19.59 12.71 10 1.959 1247K 5620 0.0 0.0 L4 132/2 9.61 GB 1.0 2.2 1.1 1.1 2.1 1.0 1.1 1.8 142.2 131.7 15.99 10.53 11 1.454 538K 2774 0.0 0.0 L5 144/0 11.13 GB 0.1 0.0 0.0 0.0 0.0 0.0 2.2 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 321/25 24.02 GB 0.0 5.1 2.6 2.5 5.7 3.1 3.2 6.6 123.4 136.5 42.57 26.89 34 1.252 2041K 9632 0.0 0.0 Int 0/0 0.00 KB 0.0 5.1 2.6 2.5 5.7 3.1 3.2 6.6 123.4 136.5 42.57 26.89 34 1.252 2041K 9632 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 5.1 2.6 2.5 4.8 2.3 0.0 0.0 140.7 132.1 37.33 24.32 22 1.697 2041K 9632 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 168.2 5.24 2.57 12 0.436 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): 5.8 total, 5.7 interval Flush(GB): cumulative 0.860, interval 0.860 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 5.67 GB write, 998.95 MB/s write, 5.13 GB read, 903.12 MB/s read, 42.6 seconds Interval compaction: 5.67 GB write, 1014.40 MB/s write, 5.13 GB read, 917.09 MB/s read, 42.6 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: 77294 Average: 89.0232 StdDev: 524.42 Min: 1 Median: 2.3196 Max: 68114 Percentiles: P50: 2.32 P75: 3.82 P99: 1349.94 P99.9: 4290.38 P99.99: 6526.83 ------------------------------------------------------ [ 0, 1 ] 1488 1.925% 1.925% ( 1, 2 ] 30893 39.968% 41.893% ######## ( 2, 3 ] 19610 25.371% 67.264% ##### ( 3, 4 ] 7253 9.384% 76.648% ## ( 4, 6 ] 7361 9.523% 86.171% ## ( 6, 10 ] 1898 2.456% 88.627% ( 10, 15 ] 390 0.505% 89.131% ( 15, 22 ] 39 0.050% 89.182% ( 22, 34 ] 16 0.021% 89.202% ( 34, 51 ] 25 0.032% 89.235% ( 51, 76 ] 11 0.014% 89.249% ( 76, 110 ] 2 0.003% 89.251% ( 110, 170 ] 110 0.142% 89.394% ( 170, 250 ] 641 0.829% 90.223% ( 250, 380 ] 1278 1.653% 91.876% ( 380, 580 ] 2348 3.038% 94.914% # ( 580, 870 ] 2281 2.951% 97.865% # ( 870, 1300 ] 860 1.113% 98.978% ( 1300, 1900 ] 229 0.296% 99.274% ( 1900, 2900 ] 241 0.312% 99.586% ( 2900, 4400 ] 264 0.342% 99.928% ( 4400, 6600 ] 52 0.067% 99.995% ( 6600, 9900 ] 8 0.010% 100.005% ( 9900, 14000 ] 2 0.003% 100.008% ( 14000, 22000 ] 4 0.005% 100.013% ( 22000, 33000 ] 3 0.004% 100.017% ( 33000, 50000 ] 2 0.003% 100.019% ( 50000, 75000 ] 1 0.001% 100.021% ** Level 1 read latency histogram (micros): Count: 196770 Average: 14.0284 StdDev: 208.81 Min: 1 Median: 2.2646 Max: 41793 Percentiles: P50: 2.26 P75: 3.26 P99: 28.81 P99.9: 2604.05 P99.99: 6295.38 ------------------------------------------------------ [ 0, 1 ] 1681 0.854% 0.854% ( 1, 2 ] 80994 41.162% 42.016% ######## ( 2, 3 ] 59377 30.176% 72.192% ###### ( 3, 4 ] 21374 10.862% 83.054% ## ( 4, 6 ] 23854 12.123% 95.177% ## ( 6, 10 ] 5963 3.030% 98.208% # ( 10, 15 ] 1340 0.681% 98.889% ( 15, 22 ] 201 0.102% 98.991% ( 22, 34 ] 34 0.017% 99.008% ( 34, 51 ] 50 0.025% 99.033% ( 51, 76 ] 26 0.013% 99.047% ( 76, 110 ] 15 0.008% 99.054% ( 110, 170 ] 42 0.021% 99.076% ( 170, 250 ] 130 0.066% 99.142% ( 250, 380 ] 239 0.121% 99.263% ( 380, 580 ] 436 0.222% 99.485% ( 580, 870 ] 405 0.206% 99.691% ( 870, 1300 ] 225 0.114% 99.805% ( 1300, 1900 ] 96 0.049% 99.854% ( 1900, 2900 ] 131 0.067% 99.920% ( 2900, 4400 ] 103 0.052% 99.973% ( 4400, 6600 ] 41 0.021% 99.993% ( 6600, 9900 ] 9 0.005% 99.998% ( 9900, 14000 ] 4 0.002% 100.000% ( 14000, 22000 ] 5 0.003% 100.003% ( 22000, 33000 ] 1 0.001% 100.003% ( 33000, 50000 ] 1 0.001% 100.004% ** Level 2 read latency histogram (micros): Count: 299785 Average: 10.9778 StdDev: 202.20 Min: 1 Median: 2.2350 Max: 49399 Percentiles: P50: 2.24 P75: 3.26 P99: 13.17 P99.9: 1113.83 P99.99: 2167.76 ------------------------------------------------------ [ 0, 1 ] 3428 1.143% 1.143% ( 1, 2 ] 126133 42.074% 43.218% ######## ( 2, 3 ] 86510 28.857% 72.075% ###### ( 3, 4 ] 33528 11.184% 83.259% ## ( 4, 6 ] 36643 12.223% 95.482% ## ( 6, 10 ] 9127 3.045% 98.527% # ( 10, 15 ] 2238 0.747% 99.273% ( 15, 22 ] 343 0.114% 99.388% ( 22, 34 ] 38 0.013% 99.401% ( 34, 51 ] 77 0.026% 99.426% ( 51, 76 ] 46 0.015% 99.442% ( 76, 110 ] 17 0.006% 99.447% ( 110, 170 ] 37 0.012% 99.460% ( 170, 250 ] 93 0.031% 99.491% ( 250, 380 ] 259 0.086% 99.577% ( 380, 580 ] 462 0.154% 99.731% ( 580, 870 ] 386 0.129% 99.860% ( 870, 1300 ] 212 0.071% 99.931% ( 1300, 1900 ] 140 0.047% 99.977% ( 1900, 2900 ] 142 0.047% 100.025% ( 2900, 4400 ] 115 0.038% 100.063% ( 4400, 6600 ] 33 0.011% 100.074% ( 6600, 9900 ] 9 0.003% 100.077% ( 9900, 14000 ] 6 0.002% 100.079% ( 14000, 22000 ] 3 0.001% 100.080% ( 22000, 33000 ] 4 0.001% 100.081% ( 33000, 50000 ] 1 0.000% 100.082% ** Level 3 read latency histogram (micros): Count: 562405 Average: 14.0577 StdDev: 269.21 Min: 1 Median: 2.2481 Max: 64063 Percentiles: P50: 2.25 P75: 3.23 P99: 14.78 P99.9: 999.86 P99.99: 1584.74 ------------------------------------------------------ [ 0, 1 ] 5358 0.953% 0.953% ( 1, 2 ] 234075 41.620% 42.573% ######## ( 2, 3 ] 168374 29.938% 72.511% ###### ( 3, 4 ] 61999 11.024% 83.535% ## ( 4, 6 ] 67384 11.981% 95.517% ## ( 6, 10 ] 16299 2.898% 98.415% # ( 10, 15 ] 3443 0.612% 99.027% ( 15, 22 ] 561 0.100% 99.127% ( 22, 34 ] 70 0.012% 99.139% ( 34, 51 ] 170 0.030% 99.169% ( 51, 76 ] 121 0.022% 99.191% ( 76, 110 ] 25 0.004% 99.195% ( 110, 170 ] 89 0.016% 99.211% ( 170, 250 ] 381 0.068% 99.279% ( 250, 380 ] 732 0.130% 99.409% ( 380, 580 ] 1358 0.241% 99.650% ( 580, 870 ] 1240 0.220% 99.871% ( 870, 1300 ] 545 0.097% 99.968% ( 1300, 1900 ] 265 0.047% 100.015% ( 1900, 2900 ] 322 0.057% 100.072% ( 2900, 4400 ] 320 0.057% 100.129% ( 4400, 6600 ] 70 0.012% 100.142% ( 6600, 9900 ] 8 0.001% 100.143% ( 9900, 14000 ] 10 0.002% 100.145% ( 14000, 22000 ] 17 0.003% 100.148% ( 22000, 33000 ] 12 0.002% 100.150% ( 33000, 50000 ] 2 0.000% 100.150% ( 50000, 75000 ] 3 0.001% 100.151% ** Level 4 read latency histogram (micros): Count: 285435 Average: 38.3067 StdDev: 326.76 Min: 1 Median: 2.3251 Max: 68026 Percentiles: P50: 2.33 P75: 3.49 P99: 830.36 P99.9: 2940.61 P99.99: 3709.75 ------------------------------------------------------ [ 0, 1 ] 2715 0.951% 0.951% ( 1, 2 ] 112994 39.587% 40.538% ######## ( 2, 3 ] 83079 29.106% 69.644% ###### ( 3, 4 ] 31409 11.004% 80.648% ## ( 4, 6 ] 34135 11.959% 92.607% ## ( 6, 10 ] 8333 2.919% 95.526% # ( 10, 15 ] 1706 0.598% 96.124% ( 15, 22 ] 211 0.074% 96.198% ( 22, 34 ] 22 0.008% 96.205% ( 34, 51 ] 54 0.019% 96.224% ( 51, 76 ] 44 0.015% 96.240% ( 76, 110 ] 24 0.008% 96.248% ( 110, 170 ] 161 0.056% 96.305% ( 170, 250 ] 836 0.293% 96.597% ( 250, 380 ] 1595 0.559% 97.156% ( 380, 580 ] 2835 0.993% 98.149% ( 580, 870 ] 2812 0.985% 99.135% ( 870, 1300 ] 1219 0.427% 99.562% ( 1300, 1900 ] 464 0.163% 99.724% ( 1900, 2900 ] 488 0.171% 99.895% ( 2900, 4400 ] 501 0.176% 100.071% ( 4400, 6600 ] 109 0.038% 100.109% ( 6600, 9900 ] 13 0.005% 100.114% ( 9900, 14000 ] 6 0.002% 100.116% ( 14000, 22000 ] 8 0.003% 100.118% ( 22000, 33000 ] 4 0.001% 100.120% ( 33000, 50000 ] 2 0.001% 100.121% ( 50000, 75000 ] 1 0.000% 100.121% ** Level 5 read latency histogram (micros): Count: 8225 Average: 886.9480 StdDev: 1424.77 Min: 97 Median: 577.0615 Max: 67968 Percentiles: P50: 577.06 P75: 863.79 P99: 4915.62 P99.9: 17700.00 P99.99: 54437.50 ------------------------------------------------------ ( 76, 110 ] 6 0.073% 0.073% ( 110, 170 ] 133 1.617% 1.690% ( 170, 250 ] 658 8.000% 9.690% ## ( 250, 380 ] 1136 13.812% 23.502% ### ( 380, 580 ] 2212 26.894% 50.395% ##### ( 580, 870 ] 2068 25.143% 75.538% ##### ( 870, 1300 ] 932 11.331% 86.869% ## ( 1300, 1900 ] 305 3.708% 90.578% # ( 1900, 2900 ] 313 3.805% 94.383% # ( 2900, 4400 ] 361 4.389% 98.772% # ( 4400, 6600 ] 80 0.973% 99.745% ( 6600, 9900 ] 7 0.085% 99.830% ( 9900, 14000 ] 3 0.036% 99.866% ( 14000, 22000 ] 6 0.073% 99.939% ( 22000, 33000 ] 4 0.049% 99.988% ( 50000, 75000 ] 1 0.012% 100.000% ** DB Stats ** Uptime(secs): 5.8 total, 5.7 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 169.20 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.161 H:M:S, 20.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 171.81 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:1.161 H:M:S, 20.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 5 num-running-flushes: 1 2024/11/20-11:10:02 ... thread 0: (1000000,2000000) ops and (231316.2,199135.2) ops/second in (4.323086,10.043428) 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/10 2.00 GB 137.9 1.0 0.0 1.0 2.8 1.8 0.0 1.5 69.0 193.6 14.59 9.46 30 0.486 1022K 4920 0.0 0.0 L2 0/0 0.00 KB 0.0 1.1 1.0 0.1 1.0 1.0 0.0 1.1 154.6 152.4 6.98 5.21 1 6.979 1096K 15K 0.0 0.0 L3 23/4 1.18 GB 1.0 3.4 2.1 1.3 3.2 1.9 0.5 1.5 145.0 138.3 24.05 16.36 13 1.850 1859K 7750 0.0 0.0 L4 144/12 10.09 GB 0.9 3.9 1.9 2.0 3.6 1.6 1.3 1.9 152.7 140.6 26.38 18.39 21 1.256 1483K 7564 0.0 0.0 L5 148/0 11.50 GB 0.1 0.0 0.0 0.0 0.0 0.0 2.5 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 333/26 24.77 GB 0.0 9.4 5.0 4.4 10.7 6.3 4.3 6.0 133.4 151.7 72.01 49.43 65 1.108 5462K 36K 0.0 0.0 Int 0/0 0.00 KB 0.0 9.4 5.0 4.4 10.7 6.3 4.3 6.0 133.4 151.7 72.01 49.43 65 1.108 5462K 36K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 9.4 5.0 4.4 8.9 4.5 0.0 0.0 153.2 145.2 62.66 44.17 39 1.607 5462K 36K 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 195.1 9.35 5.26 26 0.360 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 10.1 total, 10.1 interval Flush(GB): cumulative 1.781, interval 1.781 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 10.67 GB write, 1077.38 MB/s write, 9.38 GB read, 947.02 MB/s read, 72.0 seconds Interval compaction: 10.67 GB write, 1086.88 MB/s write, 9.38 GB read, 955.37 MB/s read, 72.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: 11, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 11, interval: 11 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 310031 Average: 47.3179 StdDev: 353.06 Min: 1 Median: 1.9578 Max: 68114 Percentiles: P50: 1.96 P75: 2.98 P99: 836.52 P99.9: 3629.16 P99.99: 4854.27 ------------------------------------------------------ [ 0, 1 ] 11683 3.768% 3.768% # ( 1, 2 ] 149655 48.271% 52.039% ########## ( 2, 3 ] 72687 23.445% 75.484% ##### ( 3, 4 ] 24486 7.898% 83.382% ## ( 4, 6 ] 23131 7.461% 90.843% # ( 6, 10 ] 4825 1.556% 92.399% ( 10, 15 ] 1104 0.356% 92.756% ( 15, 22 ] 156 0.050% 92.806% ( 22, 34 ] 23 0.007% 92.813% ( 34, 51 ] 32 0.010% 92.824% ( 51, 76 ] 19 0.006% 92.830% ( 76, 110 ] 20 0.006% 92.836% ( 110, 170 ] 848 0.274% 93.110% ( 170, 250 ] 4451 1.436% 94.545% ( 250, 380 ] 4993 1.610% 96.156% ( 380, 580 ] 5484 1.769% 97.925% ( 580, 870 ] 3771 1.216% 99.141% ( 870, 1300 ] 1286 0.415% 99.556% ( 1300, 1900 ] 361 0.116% 99.672% ( 1900, 2900 ] 462 0.149% 99.821% ( 2900, 4400 ] 506 0.163% 99.985% ( 4400, 6600 ] 92 0.030% 100.014% ( 6600, 9900 ] 17 0.005% 100.020% ( 9900, 14000 ] 6 0.002% 100.022% ( 14000, 22000 ] 9 0.003% 100.025% ( 22000, 33000 ] 7 0.002% 100.027% ( 33000, 50000 ] 4 0.001% 100.028% ( 50000, 75000 ] 1 0.000% 100.028% ** Level 1 read latency histogram (micros): Count: 254414 Average: 12.4379 StdDev: 185.36 Min: 1 Median: 2.1875 Max: 41793 Percentiles: P50: 2.19 P75: 3.08 P99: 171.12 P99.9: 2148.75 P99.99: 5825.10 ------------------------------------------------------ [ 0, 1 ] 2339 0.919% 0.919% ( 1, 2 ] 110647 43.491% 44.410% ######### ( 2, 3 ] 75863 29.819% 74.229% ###### ( 3, 4 ] 25729 10.113% 84.342% ## ( 4, 6 ] 27714 10.893% 95.235% ## ( 6, 10 ] 7452 2.929% 98.164% # ( 10, 15 ] 1629 0.640% 98.805% ( 15, 22 ] 237 0.093% 98.898% ( 22, 34 ] 40 0.016% 98.914% ( 34, 51 ] 51 0.020% 98.934% ( 51, 76 ] 26 0.010% 98.944% ( 76, 110 ] 17 0.007% 98.951% ( 110, 170 ] 119 0.047% 98.997% ( 170, 250 ] 491 0.193% 99.190% ( 250, 380 ] 484 0.190% 99.381% ( 380, 580 ] 532 0.209% 99.590% ( 580, 870 ] 432 0.170% 99.759% ( 870, 1300 ] 228 0.090% 99.849% ( 1300, 1900 ] 97 0.038% 99.887% ( 1900, 2900 ] 131 0.051% 99.939% ( 2900, 4400 ] 104 0.041% 99.980% ( 4400, 6600 ] 41 0.016% 99.996% ( 6600, 9900 ] 10 0.004% 100.000% ( 9900, 14000 ] 4 0.002% 100.001% ( 14000, 22000 ] 5 0.002% 100.003% ( 22000, 33000 ] 1 0.000% 100.004% ( 33000, 50000 ] 1 0.000% 100.004% ** Level 2 read latency histogram (micros): Count: 594880 Average: 8.9318 StdDev: 165.16 Min: 1 Median: 2.2278 Max: 49399 Percentiles: P50: 2.23 P75: 3.13 P99: 11.65 P99.9: 739.76 P99.99: 1266.56 ------------------------------------------------------ [ 0, 1 ] 4893 0.823% 0.823% ( 1, 2 ] 251139 42.217% 43.039% ######## ( 2, 3 ] 181736 30.550% 73.589% ###### ( 3, 4 ] 64178 10.788% 84.378% ## ( 4, 6 ] 68934 11.588% 95.966% ## ( 6, 10 ] 16807 2.825% 98.791% # ( 10, 15 ] 3767 0.633% 99.424% ( 15, 22 ] 543 0.091% 99.515% ( 22, 34 ] 86 0.014% 99.530% ( 34, 51 ] 142 0.024% 99.554% ( 51, 76 ] 92 0.015% 99.569% ( 76, 110 ] 41 0.007% 99.576% ( 110, 170 ] 70 0.012% 99.588% ( 170, 250 ] 230 0.039% 99.626% ( 250, 380 ] 560 0.094% 99.721% ( 380, 580 ] 752 0.126% 99.847% ( 580, 870 ] 572 0.096% 99.943% ( 870, 1300 ] 302 0.051% 99.994% ( 1300, 1900 ] 205 0.034% 100.028% ( 1900, 2900 ] 203 0.034% 100.063% ( 2900, 4400 ] 163 0.027% 100.090% ( 4400, 6600 ] 41 0.007% 100.097% ( 6600, 9900 ] 11 0.002% 100.099% ( 9900, 14000 ] 10 0.002% 100.100% ( 14000, 22000 ] 9 0.002% 100.102% ( 22000, 33000 ] 4 0.001% 100.103% ( 33000, 50000 ] 1 0.000% 100.103% ** Level 3 read latency histogram (micros): Count: 687656 Average: 14.9491 StdDev: 257.15 Min: 1 Median: 2.2213 Max: 64063 Percentiles: P50: 2.22 P75: 3.18 P99: 227.94 P99.9: 1080.41 P99.99: 1832.93 ------------------------------------------------------ [ 0, 1 ] 7176 1.044% 1.044% ( 1, 2 ] 291476 42.387% 43.430% ######## ( 2, 3 ] 204111 29.682% 73.113% ###### ( 3, 4 ] 74009 10.763% 83.875% ## ( 4, 6 ] 78444 11.407% 95.283% ## ( 6, 10 ] 19340 2.812% 98.095% # ( 10, 15 ] 3974 0.578% 98.673% ( 15, 22 ] 624 0.091% 98.764% ( 22, 34 ] 90 0.013% 98.777% ( 34, 51 ] 189 0.027% 98.804% ( 51, 76 ] 139 0.020% 98.824% ( 76, 110 ] 32 0.005% 98.829% ( 110, 170 ] 281 0.041% 98.870% ( 170, 250 ] 1235 0.180% 99.050% ( 250, 380 ] 1669 0.243% 99.292% ( 380, 580 ] 2165 0.315% 99.607% ( 580, 870 ] 1686 0.245% 99.852% ( 870, 1300 ] 671 0.098% 99.950% ( 1300, 1900 ] 311 0.045% 99.995% ( 1900, 2900 ] 388 0.056% 100.051% ( 2900, 4400 ] 387 0.056% 100.108% ( 4400, 6600 ] 82 0.012% 100.120% ( 6600, 9900 ] 10 0.001% 100.121% ( 9900, 14000 ] 12 0.002% 100.123% ( 14000, 22000 ] 24 0.003% 100.126% ( 22000, 33000 ] 12 0.002% 100.128% ( 33000, 50000 ] 2 0.000% 100.128% ( 50000, 75000 ] 3 0.000% 100.129% ** Level 4 read latency histogram (micros): Count: 690796 Average: 29.0320 StdDev: 265.01 Min: 1 Median: 2.2310 Max: 68026 Percentiles: P50: 2.23 P75: 3.30 P99: 614.33 P99.9: 1929.63 P99.99: 2723.65 ------------------------------------------------------ [ 0, 1 ] 8558 1.239% 1.239% ( 1, 2 ] 291412 42.185% 43.424% ######## ( 2, 3 ] 196698 28.474% 71.898% ###### ( 3, 4 ] 71288 10.320% 82.218% ## ( 4, 6 ] 74044 10.719% 92.936% ## ( 6, 10 ] 19486 2.821% 95.757% # ( 10, 15 ] 3915 0.567% 96.324% ( 15, 22 ] 513 0.074% 96.398% ( 22, 34 ] 72 0.010% 96.408% ( 34, 51 ] 163 0.024% 96.432% ( 51, 76 ] 110 0.016% 96.448% ( 76, 110 ] 51 0.007% 96.455% ( 110, 170 ] 964 0.140% 96.595% ( 170, 250 ] 4564 0.661% 97.256% ( 250, 380 ] 5559 0.805% 98.060% ( 380, 580 ] 5974 0.865% 98.925% ( 580, 870 ] 4385 0.635% 99.560% ( 870, 1300 ] 1689 0.245% 99.804% ( 1300, 1900 ] 639 0.093% 99.897% ( 1900, 2900 ] 783 0.113% 100.010% ( 2900, 4400 ] 786 0.114% 100.124% ( 4400, 6600 ] 162 0.023% 100.148% ( 6600, 9900 ] 27 0.004% 100.151% ( 9900, 14000 ] 14 0.002% 100.153% ( 14000, 22000 ] 20 0.003% 100.156% ( 22000, 33000 ] 8 0.001% 100.157% ( 33000, 50000 ] 2 0.000% 100.158% ( 50000, 75000 ] 1 0.000% 100.158% ** Level 5 read latency histogram (micros): Count: 18430 Average: 669.9738 StdDev: 1157.48 Min: 97 Median: 422.0808 Max: 67968 Percentiles: P50: 422.08 P75: 693.99 P99: 4287.01 P99.9: 13169.75 P99.99: 31675.29 ------------------------------------------------------ ( 76, 110 ] 31 0.168% 0.168% ( 110, 170 ] 794 4.308% 4.476% # ( 170, 250 ] 3602 19.544% 24.021% #### ( 250, 380 ] 3882 21.063% 45.084% #### ( 380, 580 ] 4306 23.364% 68.448% ##### ( 580, 870 ] 3072 16.668% 85.117% ### ( 870, 1300 ] 1202 6.522% 91.639% # ( 1300, 1900 ] 386 2.094% 93.733% ( 1900, 2900 ] 476 2.583% 96.316% # ( 2900, 4400 ] 535 2.903% 99.219% # ( 4400, 6600 ] 100 0.543% 99.761% ( 6600, 9900 ] 16 0.087% 99.848% ( 9900, 14000 ] 12 0.065% 99.913% ( 14000, 22000 ] 8 0.043% 99.957% ( 22000, 33000 ] 7 0.038% 99.995% ( 50000, 75000 ] 1 0.005% 100.000% ** DB Stats ** Uptime(secs): 10.1 total, 4.3 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 194.13 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:1.380 H:M:S, 13.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 227.66 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.220 H:M:S, 5.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 6 num-running-flushes: 1 2024/11/20-11:10:10 ... thread 0: (1000000,3000000) ops and (130908.6,169660.8) ops/second in (7.638916,17.682344) 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 17/6 3.02 GB 274.4 3.1 0.0 3.1 5.9 2.8 0.0 2.1 119.1 227.9 26.38 20.50 53 0.498 3190K 23K 0.0 0.0 L2 0/0 0.00 KB 0.0 1.1 1.0 0.1 1.0 1.0 0.0 1.1 154.6 152.4 6.98 5.21 1 6.979 1096K 15K 0.0 0.0 L3 19/0 996.93 MB 1.0 3.4 2.1 1.3 3.2 1.9 0.5 1.5 145.0 138.3 24.05 16.36 13 1.850 1859K 7750 0.0 0.0 L4 140/0 9.47 GB 1.0 5.1 2.1 3.0 4.6 1.6 1.3 2.2 161.8 145.5 32.41 23.27 25 1.296 1695K 7564 0.0 0.0 L5 156/0 12.12 GB 0.1 0.0 0.0 0.0 0.0 0.0 3.1 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 332/6 25.59 GB 0.0 12.6 5.2 7.5 14.8 7.3 4.9 5.2 144.2 168.3 89.82 65.33 92 0.976 7841K 54K 0.0 0.0 Int 0/0 0.00 KB 0.0 12.6 5.2 7.5 14.8 7.3 4.9 5.2 144.2 168.3 89.82 65.33 92 0.976 7841K 54K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 12.6 5.2 7.5 11.9 4.5 0.0 0.0 168.1 158.6 77.08 57.09 49 1.573 7841K 54K 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 227.0 12.75 8.24 43 0.296 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): 17.8 total, 17.7 interval Flush(GB): cumulative 2.826, interval 2.826 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 14.76 GB write, 850.35 MB/s write, 12.65 GB read, 728.60 MB/s read, 89.8 seconds Interval compaction: 14.76 GB write, 854.61 MB/s write, 12.65 GB read, 732.25 MB/s read, 89.8 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 12, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 12, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 11, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 12, total-stops: 11, interval: 23 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 891742 Average: 31.3374 StdDev: 215.64 Min: 1 Median: 1.6713 Max: 68114 Percentiles: P50: 1.67 P75: 2.54 P99: 507.30 P99.9: 1369.40 P99.99: 2874.85 ------------------------------------------------------ [ 0, 1 ] 128250 14.382% 14.382% ### ( 1, 2 ] 473124 53.056% 67.438% ########### ( 2, 3 ] 125962 14.125% 81.564% ### ( 3, 4 ] 39684 4.450% 86.014% # ( 4, 6 ] 32805 3.679% 89.692% # ( 6, 10 ] 7257 0.814% 90.506% ( 10, 15 ] 1558 0.175% 90.681% ( 15, 22 ] 236 0.026% 90.707% ( 22, 34 ] 39 0.004% 90.712% ( 34, 51 ] 37 0.004% 90.716% ( 51, 76 ] 24 0.003% 90.719% ( 76, 110 ] 832 0.093% 90.812% ( 110, 170 ] 20035 2.247% 93.059% ( 170, 250 ] 38772 4.348% 97.407% # ( 250, 380 ] 9699 1.088% 98.494% ( 380, 580 ] 7088 0.795% 99.289% ( 580, 870 ] 4072 0.457% 99.746% ( 870, 1300 ] 1334 0.150% 99.895% ( 1300, 1900 ] 374 0.042% 99.937% ( 1900, 2900 ] 484 0.054% 99.991% ( 2900, 4400 ] 509 0.057% 100.049% ( 4400, 6600 ] 92 0.010% 100.059% ( 6600, 9900 ] 18 0.002% 100.061% ( 9900, 14000 ] 6 0.001% 100.062% ( 14000, 22000 ] 9 0.001% 100.063% ( 22000, 33000 ] 7 0.001% 100.063% ( 33000, 50000 ] 4 0.000% 100.064% ( 50000, 75000 ] 1 0.000% 100.064% ** Level 1 read latency histogram (micros): Count: 254414 Average: 12.4379 StdDev: 185.36 Min: 1 Median: 2.1875 Max: 41793 Percentiles: P50: 2.19 P75: 3.08 P99: 171.12 P99.9: 2148.75 P99.99: 5825.10 ------------------------------------------------------ [ 0, 1 ] 2339 0.919% 0.919% ( 1, 2 ] 110647 43.491% 44.410% ######### ( 2, 3 ] 75863 29.819% 74.229% ###### ( 3, 4 ] 25729 10.113% 84.342% ## ( 4, 6 ] 27714 10.893% 95.235% ## ( 6, 10 ] 7452 2.929% 98.164% # ( 10, 15 ] 1629 0.640% 98.805% ( 15, 22 ] 237 0.093% 98.898% ( 22, 34 ] 40 0.016% 98.914% ( 34, 51 ] 51 0.020% 98.934% ( 51, 76 ] 26 0.010% 98.944% ( 76, 110 ] 17 0.007% 98.951% ( 110, 170 ] 119 0.047% 98.997% ( 170, 250 ] 491 0.193% 99.190% ( 250, 380 ] 484 0.190% 99.381% ( 380, 580 ] 532 0.209% 99.590% ( 580, 870 ] 432 0.170% 99.759% ( 870, 1300 ] 228 0.090% 99.849% ( 1300, 1900 ] 97 0.038% 99.887% ( 1900, 2900 ] 131 0.051% 99.939% ( 2900, 4400 ] 104 0.041% 99.980% ( 4400, 6600 ] 41 0.016% 99.996% ( 6600, 9900 ] 10 0.004% 100.000% ( 9900, 14000 ] 4 0.002% 100.001% ( 14000, 22000 ] 5 0.002% 100.003% ( 22000, 33000 ] 1 0.000% 100.004% ( 33000, 50000 ] 1 0.000% 100.004% ** Level 2 read latency histogram (micros): Count: 594880 Average: 8.9318 StdDev: 165.16 Min: 1 Median: 2.2278 Max: 49399 Percentiles: P50: 2.23 P75: 3.13 P99: 11.65 P99.9: 739.76 P99.99: 1266.56 ------------------------------------------------------ [ 0, 1 ] 4893 0.823% 0.823% ( 1, 2 ] 251139 42.217% 43.039% ######## ( 2, 3 ] 181736 30.550% 73.589% ###### ( 3, 4 ] 64178 10.788% 84.378% ## ( 4, 6 ] 68934 11.588% 95.966% ## ( 6, 10 ] 16807 2.825% 98.791% # ( 10, 15 ] 3767 0.633% 99.424% ( 15, 22 ] 543 0.091% 99.515% ( 22, 34 ] 86 0.014% 99.530% ( 34, 51 ] 142 0.024% 99.554% ( 51, 76 ] 92 0.015% 99.569% ( 76, 110 ] 41 0.007% 99.576% ( 110, 170 ] 70 0.012% 99.588% ( 170, 250 ] 230 0.039% 99.626% ( 250, 380 ] 560 0.094% 99.721% ( 380, 580 ] 752 0.126% 99.847% ( 580, 870 ] 572 0.096% 99.943% ( 870, 1300 ] 302 0.051% 99.994% ( 1300, 1900 ] 205 0.034% 100.028% ( 1900, 2900 ] 203 0.034% 100.063% ( 2900, 4400 ] 163 0.027% 100.090% ( 4400, 6600 ] 41 0.007% 100.097% ( 6600, 9900 ] 11 0.002% 100.099% ( 9900, 14000 ] 10 0.002% 100.100% ( 14000, 22000 ] 9 0.002% 100.102% ( 22000, 33000 ] 4 0.001% 100.103% ( 33000, 50000 ] 1 0.000% 100.103% ** Level 3 read latency histogram (micros): Count: 714528 Average: 17.7219 StdDev: 253.66 Min: 1 Median: 2.2409 Max: 64063 Percentiles: P50: 2.24 P75: 3.27 P99: 283.60 P99.9: 1068.18 P99.99: 1830.34 ------------------------------------------------------ [ 0, 1 ] 7643 1.070% 1.070% ( 1, 2 ] 299502 41.916% 42.986% ######## ( 2, 3 ] 208068 29.120% 72.105% ###### ( 3, 4 ] 75244 10.531% 82.636% ## ( 4, 6 ] 79479 11.123% 93.759% ## ( 6, 10 ] 19699 2.757% 96.516% # ( 10, 15 ] 4026 0.563% 97.080% ( 15, 22 ] 631 0.088% 97.168% ( 22, 34 ] 94 0.013% 97.181% ( 34, 51 ] 191 0.027% 97.208% ( 51, 76 ] 141 0.020% 97.228% ( 76, 110 ] 192 0.027% 97.254% ( 110, 170 ] 4078 0.571% 97.825% ( 170, 250 ] 7731 1.082% 98.907% ( 250, 380 ] 2568 0.359% 99.267% ( 380, 580 ] 2484 0.348% 99.614% ( 580, 870 ] 1730 0.242% 99.856% ( 870, 1300 ] 678 0.095% 99.951% ( 1300, 1900 ] 314 0.044% 99.995% ( 1900, 2900 ] 391 0.055% 100.050% ( 2900, 4400 ] 389 0.054% 100.104% ( 4400, 6600 ] 82 0.011% 100.116% ( 6600, 9900 ] 10 0.001% 100.117% ( 9900, 14000 ] 12 0.002% 100.119% ( 14000, 22000 ] 24 0.003% 100.122% ( 22000, 33000 ] 12 0.002% 100.124% ( 33000, 50000 ] 2 0.000% 100.124% ( 50000, 75000 ] 3 0.000% 100.125% ** Level 4 read latency histogram (micros): Count: 818192 Average: 37.1736 StdDev: 248.21 Min: 1 Median: 2.3180 Max: 68026 Percentiles: P50: 2.32 P75: 3.71 P99: 563.66 P99.9: 1705.65 P99.99: 2555.66 ------------------------------------------------------ [ 0, 1 ] 9990 1.221% 1.221% ( 1, 2 ] 329858 40.315% 41.536% ######## ( 2, 3 ] 217744 26.613% 68.149% ##### ( 3, 4 ] 78470 9.591% 77.740% ## ( 4, 6 ] 80216 9.804% 87.544% ## ( 6, 10 ] 21294 2.603% 90.147% # ( 10, 15 ] 4308 0.527% 90.673% ( 15, 22 ] 554 0.068% 90.741% ( 22, 34 ] 77 0.009% 90.750% ( 34, 51 ] 173 0.021% 90.771% ( 51, 76 ] 116 0.014% 90.786% ( 76, 110 ] 810 0.099% 90.885% ( 110, 170 ] 17525 2.142% 93.026% ( 170, 250 ] 32807 4.010% 97.036% # ( 250, 380 ] 9392 1.148% 98.184% ( 380, 580 ] 7270 0.889% 99.073% ( 580, 870 ] 4614 0.564% 99.637% ( 870, 1300 ] 1715 0.210% 99.846% ( 1300, 1900 ] 652 0.080% 99.926% ( 1900, 2900 ] 801 0.098% 100.024% ( 2900, 4400 ] 793 0.097% 100.121% ( 4400, 6600 ] 162 0.020% 100.140% ( 6600, 9900 ] 27 0.003% 100.144% ( 9900, 14000 ] 14 0.002% 100.145% ( 14000, 22000 ] 20 0.002% 100.148% ( 22000, 33000 ] 8 0.001% 100.149% ( 33000, 50000 ] 2 0.000% 100.149% ( 50000, 75000 ] 1 0.000% 100.149% ** Level 5 read latency histogram (micros): Count: 57078 Average: 350.9118 StdDev: 697.98 Min: 91 Median: 216.6188 Max: 67968 Percentiles: P50: 216.62 P75: 322.83 P99: 3219.46 P99.9: 6334.28 P99.99: 27173.46 ------------------------------------------------------ ( 76, 110 ] 598 1.048% 1.048% ( 110, 170 ] 13333 23.359% 24.407% ##### ( 170, 250 ] 25068 43.919% 68.326% ######### ( 250, 380 ] 6800 11.914% 80.239% ## ( 380, 580 ] 5253 9.203% 89.443% ## ( 580, 870 ] 3228 5.655% 95.098% # ( 870, 1300 ] 1225 2.146% 97.244% ( 1300, 1900 ] 397 0.696% 97.940% ( 1900, 2900 ] 490 0.858% 98.798% ( 2900, 4400 ] 541 0.948% 99.746% ( 4400, 6600 ] 100 0.175% 99.921% ( 6600, 9900 ] 16 0.028% 99.949% ( 9900, 14000 ] 12 0.021% 99.970% ( 14000, 22000 ] 8 0.014% 99.984% ( 22000, 33000 ] 7 0.012% 99.996% ( 50000, 75000 ] 1 0.002% 99.998% ** DB Stats ** Uptime(secs): 17.8 total, 7.6 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 166.07 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:5.178 H:M:S, 29.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 128.84 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:3.797 H:M:S, 49.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 0 using bdev Nvme0n1 Initializing RocksDB Options from the specified file Initializing RocksDB Options from command-line flags Integrated BlobDB: blob cache disabled Keys: 16 bytes each (+ 0 bytes user-defined timestamp) Values: 1000 bytes each (1000 bytes after compression) Entries: 20000000 Prefix: 0 bytes Keys per prefix: 0 RawSize: 19378.7 MB (estimated) FileSize: 19378.7 MB (estimated) Write rate: 0 bytes/second Read rate: 0 ops/second Compression: NoCompression Compression sampling rate: 0 Memtablerep: SkipListFactory Perf Level: 1 ------------------------------------------------ DB path: [/mnt/rocksdb] readwhilewriting : 381.047 micros/op 10441 ops/sec 20.208 seconds 210996 operations; 10.1 MB/s (51999 of 51999 found) Microseconds per read: Count: 210996 Average: 381.0634 StdDev: 941.35 Min: 2 Median: 238.0146 Max: 105971 Percentiles: P50: 238.01 P75: 374.68 P99: 2959.04 P99.9: 12269.07 P99.99: 38206.67 ------------------------------------------------------ ( 1, 2 ] 4 0.002% 0.002% ( 2, 3 ] 26 0.012% 0.014% ( 3, 4 ] 69 0.033% 0.047% ( 4, 6 ] 162 0.077% 0.124% ( 6, 10 ] 344 0.163% 0.287% ( 10, 15 ] 1059 0.502% 0.789% ( 15, 22 ] 2319 1.099% 1.888% ( 22, 34 ] 4921 2.332% 4.220% ( 34, 51 ] 2289 1.085% 5.305% ( 51, 76 ] 376 0.178% 5.483% ( 76, 110 ] 93 0.044% 5.527% ( 110, 170 ] 15076 7.145% 12.672% # ( 170, 250 ] 92639 43.906% 56.578% ######### ( 250, 380 ] 40530 19.209% 75.787% #### ( 380, 580 ] 27906 13.226% 89.013% ### ( 580, 870 ] 13184 6.248% 95.261% # ( 870, 1300 ] 4927 2.335% 97.596% ( 1300, 1900 ] 1633 0.774% 98.370% ( 1900, 2900 ] 1275 0.604% 98.974% ( 2900, 4400 ] 1373 0.651% 99.625% ( 4400, 6600 ] 367 0.174% 99.799% ( 6600, 9900 ] 161 0.076% 99.875% ( 9900, 14000 ] 90 0.043% 99.918% ( 14000, 22000 ] 101 0.048% 99.966% ( 22000, 33000 ] 46 0.022% 99.988% ( 33000, 50000 ] 16 0.008% 99.995% ( 50000, 75000 ] 9 0.004% 100.000% ( 75000, 110000 ] 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 : 3536048 rocksdb.bloom.filter.full.positive COUNT : 244920 rocksdb.bloom.filter.full.true.positive COUNT : 210153 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 : 843 rocksdb.memtable.miss COUNT : 210153 rocksdb.l0.hit COUNT : 24415 rocksdb.l1.hit COUNT : 1716 rocksdb.l2andup.hit COUNT : 184022 rocksdb.compaction.key.drop.new COUNT : 743565 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 : 3385117 rocksdb.number.keys.read COUNT : 210996 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 3493440744 rocksdb.bytes.read COUNT : 210996000 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 : 507 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 6343450 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 : 14248559109 rocksdb.compact.write.bytes COUNT : 13478530757 rocksdb.flush.write.bytes COUNT : 3429734141 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 : 30 rocksdb.number.superversion_acquires COUNT : 696 rocksdb.number.superversion_releases COUNT : 670 rocksdb.number.superversion_cleanups COUNT : 171 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 : 12 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 : 3407280128 rocksdb.memtable.garbage.bytes.at.flush COUNT : 6093824 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 : 14597755975 rocksdb.non.last.level.read.count COUNT : 3498814 rocksdb.block.checksum.compute.count COUNT : 3699740 rocksdb.multiget.coroutine.count COUNT : 0 rocksdb.blobdb.cache.miss COUNT : 0 rocksdb.blobdb.cache.hit COUNT : 0 rocksdb.blobdb.cache.add COUNT : 0 rocksdb.blobdb.cache.add.failures COUNT : 0 rocksdb.blobdb.cache.bytes.read COUNT : 0 rocksdb.blobdb.cache.bytes.write COUNT : 0 rocksdb.read.async.micros COUNT : 0 rocksdb.async.read.error.count COUNT : 0 rocksdb.secondary.cache.filter.hits COUNT : 0 rocksdb.secondary.cache.index.hits COUNT : 0 rocksdb.secondary.cache.data.hits COUNT : 0 rocksdb.table.open.prefetch.tail.miss COUNT : 0 rocksdb.table.open.prefetch.tail.hit COUNT : 0 rocksdb.db.get.micros P50 : 237.384185 P95 : 857.464829 P99 : 2955.761107 P100 : 105969.000000 COUNT : 210996 SUM : 80210679 rocksdb.db.write.micros P50 : 1.608906 P95 : 5.186537 P99 : 8.156444 P100 : 520927.000000 COUNT : 3385117 SUM : 15832111 rocksdb.compaction.times.micros P50 : 1459259.259259 P95 : 3600000.000000 P99 : 6979278.000000 P100 : 6979278.000000 COUNT : 50 SUM : 78012503 rocksdb.compaction.times.cpu_micros P50 : 1044166.666667 P95 : 3250000.000000 P99 : 5207203.000000 P100 : 5207203.000000 COUNT : 50 SUM : 58020284 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 : 1045.909091 P95 : 5962.000000 P99 : 8225.000000 P100 : 8225.000000 COUNT : 49 SUM : 83019 rocksdb.compaction.outfile.sync.micros P50 : 1669.230769 P95 : 7663.333333 P99 : 11458.000000 P100 : 30252.000000 COUNT : 162 SUM : 423562 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 : 218.275862 P95 : 1330.000000 P99 : 3724.000000 P100 : 3724.000000 COUNT : 119 SUM : 47106 rocksdb.table.open.io.micros P50 : 4752.564103 P95 : 16128.000000 P99 : 24411.000000 P100 : 24411.000000 COUNT : 507 SUM : 2887992 rocksdb.db.multiget.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.read.block.compaction.micros P50 : 4.201473 P95 : 9.767540 P99 : 230.668124 P100 : 68136.000000 COUNT : 3451670 SUM : 50232851 rocksdb.read.block.get.micros P50 : 206.254230 P95 : 747.689854 P99 : 2510.093458 P100 : 68034.000000 COUNT : 248036 SUM : 71670388 rocksdb.write.raw.block.micros P50 : 0.531410 P95 : 1.255039 P99 : 4.002420 P100 : 58511.000000 COUNT : 4097078 SUM : 13353355 rocksdb.numfiles.in.singlecompaction P50 : 3.057143 P95 : 3.982857 P99 : 11.400000 P100 : 12.000000 COUNT : 72 SUM : 247 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.561006 P95 : 1134.093141 P99 : 2168.963532 P100 : 520699.000000 COUNT : 38687 SUM : 6346009 rocksdb.sst.read.micros P50 : 2.049622 P95 : 196.299010 P99 : 522.974119 P100 : 68114.000000 COUNT : 3499571 SUM : 110039169 rocksdb.num.subcompactions.scheduled P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.bytes.per.read P50 : 1000.000000 P95 : 1000.000000 P99 : 1000.000000 P100 : 1000.000000 COUNT : 210996 SUM : 210996000 rocksdb.bytes.per.write P50 : 1032.000000 P95 : 1032.000000 P99 : 1032.000000 P100 : 1032.000000 COUNT : 3385117 SUM : 3493440744 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 : 235333.333333 P95 : 559312.500000 P99 : 778424.000000 P100 : 778424.000000 COUNT : 49 SUM : 13830684 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 : 172 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