Skip to content

Instantly share code, notes, and snippets.

@3manuek

3manuek/gist:d6228123323e03cfdaca52df2aa78634

Last active November 8, 2016 21:36
Show Gist options
  • Save 3manuek/d6228123323e03cfdaca52df2aa78634 to your computer and use it in GitHub Desktop.
Save 3manuek/d6228123323e03cfdaca52df2aa78634 to your computer and use it in GitHub Desktop.
Download ZIP
myrocks being hit by linkbench
Raw
gistfile1.txt
linkbench log:
```
INFO 2016-11-08 16:27:41,756 [Thread-7]: 667264/10000000 id1s loaded (6.7% complete) at 467.66 id1s/sec avg. 2650991 links loaded at 1857.97 links/sec avg.
INFO 2016-11-08 16:27:48,497 [Thread-1]: 675456/10000000 id1s loaded (6.8% complete) at 471.17 id1s/sec avg. 2707233 links loaded at 1888.47 links/sec avg.
INFO 2016-11-08 16:28:15,157 [Thread-6]: 687744/10000000 id1s loaded (6.9% complete) at 470.99 id1s/sec avg. 2759075 links loaded at 1889.49 links/sec avg.
INFO 2016-11-08 16:29:09,943 [Thread-8]: 700032/10000000 id1s loaded (7.0% complete) at 462.06 id1s/sec avg. 2822366 links loaded at 1862.94 links/sec avg.
INFO 2016-11-08 16:29:35,518 [Thread-4]: 710272/10000000 id1s loaded (7.1% complete) at 461.04 id1s/sec avg. 2855556 links loaded at 1853.55 links/sec avg.
INFO 2016-11-08 16:30:45,513 [Thread-5]: 722560/10000000 id1s loaded (7.2% complete) at 448.63 id1s/sec avg. 2953569 links loaded at 1833.86 links/sec avg.
INFO 2016-11-08 16:31:23,228 [Thread-2]: 730752/10000000 id1s loaded (7.3% complete) at 443.34 id1s/sec avg. 3023813 links loaded at 1834.51 links/sec avg.
INFO 2016-11-08 16:31:36,629 [Thread-8]: 736896/10000000 id1s loaded (7.4% complete) at 443.46 id1s/sec avg. 3067139 links loaded at 1845.79 links/sec avg.
```
```
mysql> show engine rocksdb status\G
*************************** 1. row ***************************
Type: DBSTATS
Name: rocksdb
Status:
** DB Stats **
Uptime(secs): 15524.8 total, 452.3 interval
Cumulative writes: 5737 writes, 7794K keys, 5713 commit groups, 1.0 writes per commit group, ingest: 0.93 GB, 0.06 MB/s
Cumulative WAL: 5737 writes, 63 syncs, 89.64 writes per sync, written: 0.93 GB, 0.06 MB/s
Cumulative stall: 00:06:28.109 H:M:S, 2.5 percent
Interval writes: 1885 writes, 2499K keys, 1874 commit groups, 1.0 writes per commit group, ingest: 322.54 MB, 0.71 MB/s
Interval WAL: 1885 writes, 0 syncs, 1885.00 writes per sync, written: 0.31 MB, 0.71 MB/s
Interval stall: 00:03:19.520 H:M:S, 44.1 percent
** Level 0 read latency histogram (micros):
Count: 1146711 Average: 4.5422 StdDev: 49.42
Min: 1 Median: 3.7314 Max: 19622
Percentiles: P50: 3.73 P75: 4.59 P99: 6.89 P99.9: 14.14 P99.99: 152.66
------------------------------------------------------
[ 0, 1 ) 2772 0.242% 0.242%
[ 1, 2 ) 66047 5.760% 6.001% #
[ 2, 3 ) 225044 19.625% 25.627% ####
[ 3, 4 ) 382150 33.326% 58.952% #######
[ 4, 5 ) 313085 27.303% 86.255% #####
[ 5, 6 ) 122532 10.686% 96.941% ##
[ 6, 7 ) 26678 2.326% 99.267%
[ 7, 8 ) 4362 0.380% 99.648%
[ 8, 9 ) 1120 0.098% 99.745%
[ 9, 10 ) 532 0.046% 99.792%
[ 10, 12 ) 634 0.055% 99.847%
[ 12, 14 ) 583 0.051% 99.898%
[ 14, 16 ) 372 0.032% 99.930%
[ 16, 18 ) 133 0.012% 99.942%
[ 18, 20 ) 40 0.003% 99.945%
[ 20, 25 ) 80 0.007% 99.952%
[ 25, 30 ) 154 0.013% 99.966%
[ 30, 35 ) 70 0.006% 99.972%
[ 35, 40 ) 33 0.003% 99.975%
[ 40, 45 ) 17 0.001% 99.976%
[ 45, 50 ) 14 0.001% 99.977%
[ 50, 60 ) 21 0.002% 99.979%
[ 60, 70 ) 37 0.003% 99.982%
[ 70, 80 ) 36 0.003% 99.986%
[ 80, 90 ) 17 0.001% 99.987%
[ 90, 100 ) 6 0.001% 99.988%
[ 100, 120 ) 14 0.001% 99.989%
[ 120, 140 ) 7 0.001% 99.989%
[ 140, 160 ) 10 0.001% 99.990%
[ 160, 180 ) 5 0.000% 99.991%
[ 180, 200 ) 2 0.000% 99.991%
[ 200, 250 ) 14 0.001% 99.992%
[ 250, 300 ) 14 0.001% 99.993%
[ 300, 350 ) 6 0.001% 99.994%
[ 350, 400 ) 10 0.001% 99.995%
[ 400, 450 ) 1 0.000% 99.995%
[ 450, 500 ) 2 0.000% 99.995%
[ 500, 600 ) 6 0.001% 99.996%
[ 600, 700 ) 4 0.000% 99.996%
[ 700, 800 ) 2 0.000% 99.996%
[ 800, 900 ) 6 0.001% 99.997%
[ 900, 1000 ) 3 0.000% 99.997%
[ 1000, 1200 ) 4 0.000% 99.997%
[ 1400, 1600 ) 1 0.000% 99.997%
[ 1600, 1800 ) 1 0.000% 99.997%
[ 1800, 2000 ) 1 0.000% 99.997%
[ 2500, 3000 ) 1 0.000% 99.998%
[ 3000, 3500 ) 3 0.000% 99.998%
[ 3500, 4000 ) 3 0.000% 99.998%
[ 4000, 4500 ) 2 0.000% 99.998%
[ 4500, 5000 ) 2 0.000% 99.998%
[ 5000, 6000 ) 3 0.000% 99.999%
[ 6000, 7000 ) 1 0.000% 99.999%
[ 8000, 9000 ) 2 0.000% 99.999%
[ 9000, 10000 ) 1 0.000% 99.999%
[ 10000, 12000 ) 3 0.000% 99.999%
[ 12000, 14000 ) 2 0.000% 99.999%
[ 14000, 16000 ) 3 0.000% 100.000%
[ 16000, 18000 ) 2 0.000% 100.000%
[ 18000, 20000 ) 1 0.000% 100.000%
** Level 1 read latency histogram (micros):
Count: 3957847 Average: 238.7058 StdDev: 529.80
Min: 1 Median: 4.1768 Max: 72698
Percentiles: P50: 4.18 P75: 525.47 P99: 890.14 P99.9: 5241.33 P99.99: 17981.62
------------------------------------------------------
[ 0, 1 ) 934 0.024% 0.024%
[ 1, 2 ) 305779 7.726% 7.749% ##
[ 2, 3 ) 744008 18.798% 26.548% ####
[ 3, 4 ) 872620 22.048% 48.596% ####
[ 4, 5 ) 314402 7.944% 56.539% ##
[ 5, 6 ) 39973 1.010% 57.549%
[ 6, 7 ) 11739 0.297% 57.846%
[ 7, 8 ) 5638 0.142% 57.988%
[ 8, 9 ) 3470 0.088% 58.076%
[ 9, 10 ) 2493 0.063% 58.139%
[ 10, 12 ) 2972 0.075% 58.214%
[ 12, 14 ) 1700 0.043% 58.257%
[ 14, 16 ) 721 0.018% 58.275%
[ 16, 18 ) 177 0.004% 58.280%
[ 18, 20 ) 95 0.002% 58.282%
[ 20, 25 ) 1144 0.029% 58.311%
[ 25, 30 ) 15545 0.393% 58.704%
[ 30, 35 ) 22209 0.561% 59.265%
[ 35, 40 ) 16241 0.410% 59.675%
[ 40, 45 ) 5300 0.134% 59.809%
[ 45, 50 ) 3568 0.090% 59.899%
[ 50, 60 ) 21558 0.545% 60.444%
[ 60, 70 ) 4333 0.109% 60.554%
[ 70, 80 ) 8684 0.219% 60.773%
[ 80, 90 ) 5027 0.127% 60.900%
[ 90, 100 ) 5236 0.132% 61.032%
[ 100, 120 ) 23170 0.585% 61.618%
[ 120, 140 ) 20588 0.520% 62.138%
[ 140, 160 ) 18150 0.459% 62.597%
[ 160, 180 ) 16476 0.416% 63.013%
[ 180, 200 ) 16724 0.423% 63.435%
[ 200, 250 ) 39563 1.000% 64.435%
[ 250, 300 ) 33913 0.857% 65.292%
[ 300, 350 ) 48494 1.225% 66.517%
[ 350, 400 ) 64050 1.618% 68.135%
[ 400, 450 ) 85615 2.163% 70.299%
[ 450, 500 ) 107303 2.711% 73.010% #
[ 500, 600 ) 309285 7.814% 80.824% ##
[ 600, 700 ) 374907 9.472% 90.297% ##
[ 700, 800 ) 264452 6.682% 96.978% #
[ 800, 900 ) 88763 2.243% 99.221%
[ 900, 1000 ) 15512 0.392% 99.613%
[ 1000, 1200 ) 5487 0.139% 99.752%
[ 1200, 1400 ) 1672 0.042% 99.794%
[ 1400, 1600 ) 839 0.021% 99.815%
[ 1600, 1800 ) 548 0.014% 99.829%
[ 1800, 2000 ) 393 0.010% 99.839%
[ 2000, 2500 ) 526 0.013% 99.852%
[ 2500, 3000 ) 345 0.009% 99.861%
[ 3000, 3500 ) 236 0.006% 99.867%
[ 3500, 4000 ) 202 0.005% 99.872%
[ 4000, 4500 ) 278 0.007% 99.879%
[ 4500, 5000 ) 739 0.019% 99.898%
[ 5000, 6000 ) 386 0.010% 99.907%
[ 6000, 7000 ) 283 0.007% 99.915%
[ 7000, 8000 ) 236 0.006% 99.921%
[ 8000, 9000 ) 328 0.008% 99.929%
[ 9000, 10000 ) 223 0.006% 99.934%
[ 10000, 12000 ) 501 0.013% 99.947%
[ 12000, 14000 ) 498 0.013% 99.960%
[ 14000, 16000 ) 361 0.009% 99.969%
[ 16000, 18000 ) 847 0.021% 99.990%
[ 18000, 20000 ) 74 0.002% 99.992%
[ 20000, 25000 ) 249 0.006% 99.998%
[ 25000, 30000 ) 48 0.001% 100.000%
[ 30000, 35000 ) 11 0.000% 100.000%
[ 35000, 40000 ) 2 0.000% 100.000%
[ 40000, 45000 ) 1 0.000% 100.000%
[ 45000, 50000 ) 2 0.000% 100.000%
[ 70000, 80000 ) 1 0.000% 100.000%
** Level 2 read latency histogram (micros):
Count: 299725 Average: 482.6748 StdDev: 796.23
Min: 1 Median: 600.4574 Max: 48839
Percentiles: P50: 600.46 P75: 738.97 P99: 1107.46 P99.9: 15048.63 P99.99: 23811.71
------------------------------------------------------
[ 0, 1 ) 13 0.004% 0.004%
[ 1, 2 ) 1470 0.490% 0.495%
[ 2, 3 ) 31853 10.627% 11.122% ##
[ 3, 4 ) 55044 18.365% 29.487% ####
[ 4, 5 ) 14617 4.877% 34.364% #
[ 5, 6 ) 2975 0.993% 35.356%
[ 6, 7 ) 663 0.221% 35.578%
[ 7, 8 ) 108 0.036% 35.614%
[ 8, 9 ) 12 0.004% 35.618%
[ 9, 10 ) 8 0.003% 35.620%
[ 10, 12 ) 23 0.008% 35.628%
[ 12, 14 ) 43 0.014% 35.642%
[ 14, 16 ) 25 0.008% 35.651%
[ 16, 18 ) 3 0.001% 35.652%
[ 20, 25 ) 6 0.002% 35.654%
[ 25, 30 ) 7 0.002% 35.656%
[ 30, 35 ) 12 0.004% 35.660%
[ 35, 40 ) 4 0.001% 35.661%
[ 40, 45 ) 2 0.001% 35.662%
[ 45, 50 ) 1 0.000% 35.662%
[ 50, 60 ) 1 0.000% 35.663%
[ 70, 80 ) 2 0.001% 35.663%
[ 80, 90 ) 1 0.000% 35.664%
[ 100, 120 ) 1 0.000% 35.664%
[ 120, 140 ) 31 0.010% 35.674%
[ 140, 160 ) 90 0.030% 35.704%
[ 160, 180 ) 409 0.136% 35.841%
[ 180, 200 ) 1631 0.544% 36.385%
[ 200, 250 ) 4155 1.386% 37.771%
[ 250, 300 ) 1287 0.429% 38.201%
[ 300, 350 ) 553 0.185% 38.385%
[ 350, 400 ) 1037 0.346% 38.731%
[ 400, 450 ) 1466 0.489% 39.220%
[ 450, 500 ) 2758 0.920% 40.140%
[ 500, 600 ) 29302 9.776% 49.917% ##
[ 600, 700 ) 54553 18.201% 68.118% ####
[ 700, 800 ) 52934 17.661% 85.779% ####
[ 800, 900 ) 29377 9.801% 95.580% ##
[ 900, 1000 ) 9016 3.008% 98.588% #
[ 1000, 1200 ) 2298 0.767% 99.355%
[ 1200, 1400 ) 401 0.134% 99.489%
[ 1400, 1600 ) 144 0.048% 99.537%
[ 1600, 1800 ) 105 0.035% 99.572%
[ 1800, 2000 ) 59 0.020% 99.591%
[ 2000, 2500 ) 107 0.036% 99.627%
[ 2500, 3000 ) 52 0.017% 99.644%
[ 3000, 3500 ) 36 0.012% 99.656%
[ 3500, 4000 ) 45 0.015% 99.671%
[ 4000, 4500 ) 39 0.013% 99.684%
[ 4500, 5000 ) 159 0.053% 99.737%
[ 5000, 6000 ) 85 0.028% 99.766%
[ 6000, 7000 ) 41 0.014% 99.779%
[ 7000, 8000 ) 35 0.012% 99.791%
[ 8000, 9000 ) 70 0.023% 99.814%
[ 9000, 10000 ) 56 0.019% 99.833%
[ 10000, 12000 ) 82 0.027% 99.861%
[ 12000, 14000 ) 80 0.027% 99.887%
[ 14000, 16000 ) 73 0.024% 99.912%
[ 16000, 18000 ) 167 0.056% 99.967%
[ 18000, 20000 ) 20 0.007% 99.974%
[ 20000, 25000 ) 63 0.021% 99.995%
[ 25000, 30000 ) 7 0.002% 99.997%
[ 30000, 35000 ) 6 0.002% 99.999%
[ 35000, 40000 ) 1 0.000% 100.000%
[ 45000, 50000 ) 1 0.000% 100.000%
*************************** 2. row ***************************
Type: CF_COMPACTION
Name: __system__
Status:
** Compaction Stats [__system__] **
Level Files Size(MB) Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop
---------------------------------------------------------------------------------------------------------------------------------------------------------------------
L0 0/0 0.00 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 3.1 0 7 0.004 0 0
L1 1/0 0.01 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.2 10.6 1.6 0 2 0.004 807 613
Sum 1/0 0.01 0.0 0.0 0.0 0.0 0.0 0.0 0.0 1.2 2.6 2.7 0 9 0.004 807 613
Int 0/0 0.00 0.0 0.0 0.0 0.0 0.0 0.0 0.0 1.2 3.2 2.4 0 4 0.004 483 386
Uptime(secs): 15524.8 total, 15524.8 interval
Flush(GB): cumulative 0.000, interval 0.000
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: 0.00 GB write, 0.00 MB/s write, 0.00 GB read, 0.00 MB/s read, 0.0 seconds
Interval compaction: 0.00 GB write, 0.00 MB/s write, 0.00 GB read, 0.00 MB/s read, 0.0 seconds
Stalls(count): 0 level0_slowdown, 0 level0_slowdown_with_compaction, 0 level0_numfiles, 0 level0_numfiles_with_compaction, 0 stop for pending_compaction_bytes, 0 slowdown for pending_compaction_bytes, 0 memtable_compaction, 0 memtable_slowdown, interval 0 total count
*************************** 3. row ***************************
Type: CF_COMPACTION
Name: default
Status:
** Compaction Stats [default] **
Level Files Size(MB) Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop
---------------------------------------------------------------------------------------------------------------------------------------------------------------------
L0 18/0 60.75 4.5 0.0 0.0 0.0 0.9 0.9 0.0 0.0 0.0 17.2 52 278 0.186 0 0
L1 9/1 567.74 2.0 9.2 0.8 8.3 9.2 0.8 0.0 11.3 10.0 10.0 939 31 30.292 75M 0
L2 4/4 259.73 0.0 0.4 0.1 0.3 0.4 0.1 0.1 3.5 5.5 5.5 83 2 41.451 8915K 0
Sum 31/5 888.22 0.0 9.6 0.9 8.7 10.5 1.8 0.1 12.1 9.2 10.0 1074 311 3.452 84M 0
Int 0/0 0.00 0.0 4.3 0.4 3.9 4.6 0.7 0.1 15.5 10.5 11.2 424 103 4.116 34M 0
Uptime(secs): 15524.8 total, 15524.8 interval
Flush(GB): cumulative 0.869, interval 0.299
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.47 GB write, 0.69 MB/s write, 9.60 GB read, 0.63 MB/s read, 1073.6 seconds
Interval compaction: 4.63 GB write, 0.31 MB/s write, 4.33 GB read, 0.29 MB/s read, 424.0 seconds
Stalls(count): 38 level0_slowdown, 36 level0_slowdown_with_compaction, 0 level0_numfiles, 0 level0_numfiles_with_compaction, 0 stop for pending_compaction_bytes, 0 slowdown for pending_compaction_bytes, 0 memtable_compaction, 0 memtable_slowdown, interval 10 total count
*************************** 4. row ***************************
Type: Memory_Stats
Name: rocksdb
Status:
MemTable Total: 10486760
MemTable Unflushed: 1840888
Table Readers Total: 0
Cache Total: 7894716
Default Cache Capacity: 0
4 rows in set (0.00 sec)
```
LOAD STARTED:
INFO 2016-11-08 16:35:17,210 [Thread-9]: ThreadID = 9 LOAD_LINKS_BULK totalOps = 312 totalErrors = 0 ops = 312 sampleDuration = 1880903ms samples = 312 mean = 5721224.15 min = 472077 25% = 3218031 50% = 4498522 75% = 5086195 90% = 13307547 95% = 18519091 99% = 30155402 max = 38295945
INFO 2016-11-08 16:35:17,210 [Thread-9]: ThreadID = 9 LOAD_COUNTS_BULK totalOps = 69 totalErrors = 0 ops = 69 sampleDuration = 1880903ms samples = 69 mean = 1383706.19 min = 144580 25% = 194893 50% = 277959 75% = 376017 90% = 3602915 95% = 7297256 99% = 18328922 max = 18328922
INFO 2016-11-08 16:35:17,210 [Thread-9]: ThreadID = 9 LOAD_LINKS_BULK_NLINKS totalOps = 312 totalErrors = 0 ops = 312 sampleDuration = 1880903ms samples = 312 mean = 1024 min = 1024 25% = 1024 50% = 1024 75% = 1024 90% = 1024 95% = 1024 99% = 1024 max = 1024
INFO 2016-11-08 16:35:17,210 [Thread-9]: ThreadID = 9 LOAD_COUNTS_BULK_NLINKS totalOps = 69 totalErrors = 0 ops = 69 sampleDuration = 1880903ms samples = 69 mean = 1024 min = 1024 25% = 1024 50% = 1024 75% = 1024 90% = 1024 95% = 1024 99% = 1024 max = 1024
INFO 2016-11-08 16:35:19,336 [Thread-3]: 792192/10000000 id1s loaded (7.9% complete) at 420.39 id1s/sec avg. 3300048 links loaded at 1751.25 links/sec avg.
INFO 2016-11-08 16:35:42,012 [Thread-0]: ThreadID = 0 LOAD_LINKS_BULK totalOps = 320 totalErrors = 0 ops = 320 sampleDuration = 1905679ms samples = 320 mean = 5704479.83 min = 434376 25% = 3397826 50% = 4570277 75% = 5162820 90% = 11004782 95% = 21138805 99% = 30042736 max = 38190752
INFO 2016-11-08 16:35:42,012 [Thread-0]: ThreadID = 0 LOAD_COUNTS_BULK totalOps = 51 totalErrors = 0 ops = 51 sampleDuration = 1905679ms samples = 51 mean = 1566330.35 min = 131093 25% = 214706 50% = 316580 75% = 755239 90% = 4494595 95% = 9201341 99% = 15521491 max = 15521491
INFO 2016-11-08 16:35:42,012 [Thread-0]: ThreadID = 0 LOAD_LINKS_BULK_NLINKS totalOps = 320 totalErrors = 0 ops = 320 sampleDuration = 1905679ms samples = 320 mean = 1024 min = 1024 25% = 1024 50% = 1024 75% = 1024 90% = 1024 95% = 1024 99% = 1024 max = 1024
INFO 2016-11-08 16:35:42,012 [Thread-0]: ThreadID = 0 LOAD_COUNTS_BULK_NLINKS totalOps = 51 totalErrors = 0 ops = 51 sampleDuration = 1905679ms samples = 51 mean = 1024 min = 1024 25% = 1024 50% = 1024 75% = 1024 90% = 1024 95% = 1024 99% = 1024 max = 1024
INFO 2016-11-08 16:35:46,131 [Thread-1]: 806528/10000000 id1s loaded (8.1% complete) at 422.00 id1s/sec avg. 3352296 links loaded at 1754.03 links/sec avg.
mysql> show engine rocksdb status\G
*************************** 1. row ***************************
Type: DBSTATS
Name: rocksdb
Status:
** DB Stats **
Uptime(secs): 16295.5 total, 576.9 interval
Cumulative writes: 8548 writes, 11M keys, 8500 commit groups, 1.0 writes per commit group, ingest: 1.41 GB, 0.09 MB/s
Cumulative WAL: 8548 writes, 63 syncs, 133.56 writes per sync, written: 1.41 GB, 0.09 MB/s
Cumulative stall: 00:13:11.692 H:M:S, 4.9 percent
Interval writes: 1988 writes, 2668K keys, 1972 commit groups, 1.0 writes per commit group, ingest: 346.81 MB, 0.60 MB/s
Interval WAL: 1988 writes, 0 syncs, 1988.00 writes per sync, written: 0.34 MB, 0.60 MB/s
Interval stall: 00:05:18.493 H:M:S, 55.2 percent
** Level 0 read latency histogram (micros):
Count: 1947397 Average: 4.5678 StdDev: 51.28
Min: 1 Median: 3.7583 Max: 19622
Percentiles: P50: 3.76 P75: 4.63 P99: 6.90 P99.9: 14.30 P99.99: 176.13
------------------------------------------------------
[ 0, 1 ) 5369 0.276% 0.276%
[ 1, 2 ) 133123 6.836% 7.112% #
[ 2, 3 ) 372861 19.147% 26.258% ####
[ 3, 4 ) 609726 31.310% 57.568% ######
[ 4, 5 ) 540642 27.762% 85.330% ######
[ 5, 6 ) 222554 11.428% 96.759% ##
[ 6, 7 ) 48319 2.481% 99.240%
[ 7, 8 ) 7682 0.394% 99.634%
[ 8, 9 ) 2003 0.103% 99.737%
[ 9, 10 ) 936 0.048% 99.785%
[ 10, 12 ) 1098 0.056% 99.842%
[ 12, 14 ) 1040 0.053% 99.895%
[ 14, 16 ) 646 0.033% 99.928%
[ 16, 18 ) 202 0.010% 99.939%
[ 18, 20 ) 62 0.003% 99.942%
[ 20, 25 ) 149 0.008% 99.949%
[ 25, 30 ) 277 0.014% 99.964%
[ 30, 35 ) 125 0.006% 99.970%
[ 35, 40 ) 62 0.003% 99.973%
[ 40, 45 ) 38 0.002% 99.975%
[ 45, 50 ) 27 0.001% 99.977%
[ 50, 60 ) 40 0.002% 99.979%
[ 60, 70 ) 53 0.003% 99.981%
[ 70, 80 ) 57 0.003% 99.984%
[ 80, 90 ) 32 0.002% 99.986%
[ 90, 100 ) 15 0.001% 99.987%
[ 100, 120 ) 17 0.001% 99.988%
[ 120, 140 ) 18 0.001% 99.988%
[ 140, 160 ) 22 0.001% 99.990%
[ 160, 180 ) 9 0.000% 99.990%
[ 180, 200 ) 7 0.000% 99.990%
[ 200, 250 ) 29 0.001% 99.992%
[ 250, 300 ) 23 0.001% 99.993%
[ 300, 350 ) 14 0.001% 99.994%
[ 350, 400 ) 15 0.001% 99.995%
[ 400, 450 ) 1 0.000% 99.995%
[ 450, 500 ) 3 0.000% 99.995%
[ 500, 600 ) 9 0.000% 99.995%
[ 600, 700 ) 8 0.000% 99.996%
[ 700, 800 ) 7 0.000% 99.996%
[ 800, 900 ) 6 0.000% 99.996%
[ 900, 1000 ) 7 0.000% 99.997%
[ 1000, 1200 ) 6 0.000% 99.997%
[ 1200, 1400 ) 2 0.000% 99.997%
[ 1400, 1600 ) 2 0.000% 99.997%
[ 1600, 1800 ) 2 0.000% 99.997%
[ 1800, 2000 ) 2 0.000% 99.997%
[ 2000, 2500 ) 1 0.000% 99.997%
[ 2500, 3000 ) 2 0.000% 99.998%
[ 3000, 3500 ) 3 0.000% 99.998%
[ 3500, 4000 ) 3 0.000% 99.998%
[ 4000, 4500 ) 4 0.000% 99.998%
[ 4500, 5000 ) 2 0.000% 99.998%
[ 5000, 6000 ) 4 0.000% 99.998%
[ 6000, 7000 ) 2 0.000% 99.999%
[ 7000, 8000 ) 3 0.000% 99.999%
[ 8000, 9000 ) 5 0.000% 99.999%
[ 9000, 10000 ) 1 0.000% 99.999%
[ 10000, 12000 ) 5 0.000% 99.999%
[ 12000, 14000 ) 4 0.000% 99.999%
[ 14000, 16000 ) 5 0.000% 100.000%
[ 16000, 18000 ) 5 0.000% 100.000%
[ 18000, 20000 ) 1 0.000% 100.000%
** Level 1 read latency histogram (micros):
Count: 5142863 Average: 185.3199 StdDev: 476.08
Min: 1 Median: 3.6450 Max: 72698
Percentiles: P50: 3.64 P75: 385.56 P99: 876.83 P99.9: 3854.30 P99.99: 17705.90
------------------------------------------------------
[ 0, 1 ) 2043 0.040% 0.040%
[ 1, 2 ) 634341 12.334% 12.374% ##
[ 2, 3 ) 1193763 23.212% 35.586% #####
[ 3, 4 ) 1149359 22.349% 57.935% ####
[ 4, 5 ) 397815 7.735% 65.670% ##
[ 5, 6 ) 55721 1.083% 66.754%
[ 6, 7 ) 18054 0.351% 67.105%
[ 7, 8 ) 9464 0.184% 67.289%
[ 8, 9 ) 6056 0.118% 67.406%
[ 9, 10 ) 4514 0.088% 67.494%
[ 10, 12 ) 5009 0.097% 67.592%
[ 12, 14 ) 2513 0.049% 67.640%
[ 14, 16 ) 983 0.019% 67.659%
[ 16, 18 ) 254 0.005% 67.664%
[ 18, 20 ) 131 0.003% 67.667%
[ 20, 25 ) 1209 0.024% 67.690%
[ 25, 30 ) 15580 0.303% 67.993%
[ 30, 35 ) 22225 0.432% 68.426%
[ 35, 40 ) 16249 0.316% 68.742%
[ 40, 45 ) 5303 0.103% 68.845%
[ 45, 50 ) 3569 0.069% 68.914%
[ 50, 60 ) 21563 0.419% 69.333%
[ 60, 70 ) 4340 0.084% 69.418%
[ 70, 80 ) 8695 0.169% 69.587%
[ 80, 90 ) 5038 0.098% 69.685%
[ 90, 100 ) 5245 0.102% 69.787%
[ 100, 120 ) 23188 0.451% 70.238%
[ 120, 140 ) 20605 0.401% 70.638%
[ 140, 160 ) 18241 0.355% 70.993%
[ 160, 180 ) 17025 0.331% 71.324%
[ 180, 200 ) 17297 0.336% 71.660%
[ 200, 250 ) 39917 0.776% 72.436%
[ 250, 300 ) 34130 0.664% 73.100%
[ 300, 350 ) 49819 0.969% 74.069%
[ 350, 400 ) 67328 1.309% 75.378%
[ 400, 450 ) 89145 1.733% 77.111%
[ 450, 500 ) 108595 2.112% 79.223%
[ 500, 600 ) 309514 6.018% 85.241% #
[ 600, 700 ) 374931 7.290% 92.532% #
[ 700, 800 ) 264461 5.142% 97.674% #
[ 800, 900 ) 88769 1.726% 99.400%
[ 900, 1000 ) 15517 0.302% 99.702%
[ 1000, 1200 ) 5492 0.107% 99.808%
[ 1200, 1400 ) 1674 0.033% 99.841%
[ 1400, 1600 ) 841 0.016% 99.857%
[ 1600, 1800 ) 549 0.011% 99.868%
[ 1800, 2000 ) 393 0.008% 99.876%
[ 2000, 2500 ) 527 0.010% 99.886%
[ 2500, 3000 ) 347 0.007% 99.893%
[ 3000, 3500 ) 236 0.005% 99.897%
[ 3500, 4000 ) 202 0.004% 99.901%
[ 4000, 4500 ) 280 0.005% 99.907%
[ 4500, 5000 ) 739 0.014% 99.921%
[ 5000, 6000 ) 388 0.008% 99.929%
[ 6000, 7000 ) 284 0.006% 99.934%
[ 7000, 8000 ) 236 0.005% 99.939%
[ 8000, 9000 ) 328 0.006% 99.945%
[ 9000, 10000 ) 224 0.004% 99.949%
[ 10000, 12000 ) 502 0.010% 99.959%
[ 12000, 14000 ) 500 0.010% 99.969%
[ 14000, 16000 ) 362 0.007% 99.976%
[ 16000, 18000 ) 852 0.017% 99.992%
[ 18000, 20000 ) 74 0.001% 99.994%
[ 20000, 25000 ) 249 0.005% 99.999%
[ 25000, 30000 ) 48 0.001% 100.000%
[ 30000, 35000 ) 11 0.000% 100.000%
[ 35000, 40000 ) 2 0.000% 100.000%
[ 40000, 45000 ) 2 0.000% 100.000%
[ 45000, 50000 ) 2 0.000% 100.000%
[ 70000, 80000 ) 1 0.000% 100.000%
** Level 2 read latency histogram (micros):
Count: 2192827 Average: 359.6798 StdDev: 647.02
Min: 1 Median: 5.9727 Max: 68533
Percentiles: P50: 5.97 P75: 682.31 P99: 995.29 P99.9: 9840.57 P99.99: 21305.99
------------------------------------------------------
[ 0, 1 ) 1201 0.055% 0.055%
[ 1, 2 ) 158111 7.210% 7.265% #
[ 2, 3 ) 327957 14.956% 22.221% ###
[ 3, 4 ) 404572 18.450% 40.671% ####
[ 4, 5 ) 176704 8.058% 48.729% ##
[ 5, 6 ) 28651 1.307% 50.036%
[ 6, 7 ) 5932 0.271% 50.306%
[ 7, 8 ) 2078 0.095% 50.401%
[ 8, 9 ) 1180 0.054% 50.455%
[ 9, 10 ) 786 0.036% 50.491%
[ 10, 12 ) 901 0.041% 50.532%
[ 12, 14 ) 648 0.030% 50.561%
[ 14, 16 ) 227 0.010% 50.572%
[ 16, 18 ) 60 0.003% 50.574%
[ 18, 20 ) 28 0.001% 50.576%
[ 20, 25 ) 89 0.004% 50.580%
[ 25, 30 ) 98 0.004% 50.584%
[ 30, 35 ) 37 0.002% 50.586%
[ 35, 40 ) 20 0.001% 50.587%
[ 40, 45 ) 13 0.001% 50.587%
[ 45, 50 ) 13 0.001% 50.588%
[ 50, 60 ) 15 0.001% 50.589%
[ 60, 70 ) 12 0.001% 50.589%
[ 70, 80 ) 17 0.001% 50.590%
[ 80, 90 ) 16 0.001% 50.591%
[ 90, 100 ) 8 0.000% 50.591%
[ 100, 120 ) 126 0.006% 50.597%
[ 120, 140 ) 413 0.019% 50.616%
[ 140, 160 ) 651 0.030% 50.645%
[ 160, 180 ) 2036 0.093% 50.738%
[ 180, 200 ) 5196 0.237% 50.975%
[ 200, 250 ) 18492 0.843% 51.818%
[ 250, 300 ) 13933 0.635% 52.454%
[ 300, 350 ) 7160 0.327% 52.780%
[ 350, 400 ) 8018 0.366% 53.146%
[ 400, 450 ) 10477 0.478% 53.624%
[ 450, 500 ) 17257 0.787% 54.411%
[ 500, 600 ) 166724 7.603% 62.014% ##
[ 600, 700 ) 345972 15.777% 77.791% ###
[ 700, 800 ) 284205 12.961% 90.752% ###
[ 800, 900 ) 142341 6.491% 97.243% #
[ 900, 1000 ) 40429 1.844% 99.087%
[ 1000, 1200 ) 10295 0.469% 99.556%
[ 1200, 1400 ) 2164 0.099% 99.655%
[ 1400, 1600 ) 917 0.042% 99.697%
[ 1600, 1800 ) 570 0.026% 99.723%
[ 1800, 2000 ) 438 0.020% 99.743%
[ 2000, 2500 ) 595 0.027% 99.770%
[ 2500, 3000 ) 320 0.015% 99.785%
[ 3000, 3500 ) 257 0.012% 99.796%
[ 3500, 4000 ) 219 0.010% 99.806%
[ 4000, 4500 ) 205 0.009% 99.816%
[ 4500, 5000 ) 593 0.027% 99.843%
[ 5000, 6000 ) 389 0.018% 99.860%
[ 6000, 7000 ) 231 0.011% 99.871%
[ 7000, 8000 ) 205 0.009% 99.880%
[ 8000, 9000 ) 296 0.013% 99.894%
[ 9000, 10000 ) 162 0.007% 99.901%
[ 10000, 12000 ) 437 0.020% 99.921%
[ 12000, 14000 ) 375 0.017% 99.938%
[ 14000, 16000 ) 318 0.015% 99.953%
[ 16000, 18000 ) 691 0.032% 99.984%
[ 18000, 20000 ) 75 0.003% 99.988%
[ 20000, 25000 ) 198 0.009% 99.997%
[ 25000, 30000 ) 44 0.002% 99.999%
[ 30000, 35000 ) 16 0.001% 99.999%
[ 35000, 40000 ) 10 0.000% 100.000%
[ 45000, 50000 ) 1 0.000% 100.000%
[ 50000, 60000 ) 1 0.000% 100.000%
[ 60000, 70000 ) 1 0.000% 100.000%
*************************** 2. row ***************************
Type: CF_COMPACTION
Name: __system__
Status:
** Compaction Stats [__system__] **
Level Files Size(MB) Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop
---------------------------------------------------------------------------------------------------------------------------------------------------------------------
L0 4/0 0.04 1.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 3.2 0 11 0.003 0 0
L1 1/0 0.01 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.2 10.6 1.6 0 2 0.004 807 613
Sum 5/0 0.05 0.0 0.0 0.0 0.0 0.0 0.0 0.0 1.1 1.9 2.9 0 13 0.004 807 613
Int 0/0 0.00 0.0 0.0 0.0 0.0 0.0 0.0 0.0 1.0 0.0 3.3 0 3 0.003 0 0
Uptime(secs): 16295.5 total, 16295.5 interval
Flush(GB): cumulative 0.000, interval 0.000
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: 0.00 GB write, 0.00 MB/s write, 0.00 GB read, 0.00 MB/s read, 0.0 seconds
Interval compaction: 0.00 GB write, 0.00 MB/s write, 0.00 GB read, 0.00 MB/s read, 0.0 seconds
Stalls(count): 0 level0_slowdown, 0 level0_slowdown_with_compaction, 0 level0_numfiles, 0 level0_numfiles_with_compaction, 0 stop for pending_compaction_bytes, 0 slowdown for pending_compaction_bytes, 0 memtable_compaction, 0 memtable_slowdown, interval 0 total count
*************************** 3. row ***************************
Type: CF_COMPACTION
Name: default
Status:
** Compaction Stats [default] **
Level Files Size(MB) Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop
---------------------------------------------------------------------------------------------------------------------------------------------------------------------
L0 20/20 66.05 0.0 0.0 0.0 0.0 1.3 1.3 0.0 0.0 0.0 17.7 76 420 0.182 0 0
L1 8/8 509.40 0.0 13.1 1.3 11.8 13.1 1.3 0.0 10.4 11.2 11.2 1193 38 31.400 94M 0
L2 12/0 776.74 0.3 4.7 0.6 4.1 4.7 0.6 0.1 7.5 8.0 8.0 611 10 61.074 64M 0
Sum 40/28 1352.18 0.0 17.8 1.9 15.9 19.1 3.2 0.1 14.5 9.7 10.4 1880 468 4.018 159M 0
Int 0/0 0.00 0.0 6.0 0.6 5.3 6.3 1.0 0.0 19.7 10.9 11.4 562 110 5.111 52M 0
Uptime(secs): 16295.5 total, 16295.5 interval
Flush(GB): cumulative 1.322, interval 0.318
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: 19.14 GB write, 1.20 MB/s write, 17.82 GB read, 1.12 MB/s read, 1880.3 seconds
Interval compaction: 6.28 GB write, 0.39 MB/s write, 5.96 GB read, 0.37 MB/s read, 562.2 seconds
Stalls(count): 64 level0_slowdown, 46 level0_slowdown_with_compaction, 0 level0_numfiles, 0 level0_numfiles_with_compaction, 0 stop for pending_compaction_bytes, 0 slowdown for pending_compaction_bytes, 0 memtable_compaction, 0 memtable_slowdown, interval 18 total count
*************************** 4. row ***************************
Type: Memory_Stats
Name: rocksdb
Status:
MemTable Total: 12368992
MemTable Unflushed: 3578496
Table Readers Total: 0
Cache Total: 5359035
Default Cache Capacity: 0
4 rows in set (0.00 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment