Skip to content

Instantly share code, notes, and snippets.

@tomatolog

tomatolog/gist:69194eab71e3181967fd

Created October 1, 2014 07:48
Show Gist options
  • Save tomatolog/69194eab71e3181967fd to your computer and use it in GitHub Desktop.
Save tomatolog/69194eab71e3181967fd to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
all dist=0 (default)
20 threads, 23590 queries 428.9 qps load average: 14.37
30 threads, 23796 queries 432.6 qps load average: 22.50
100 threads, 23212 queries 422.0 qps load average: 62.82
all7 dist=0 (same as all)
20 threads, 18136 queries 329.7 qps load average: 14.79
30 threads, 18055 queries 328.2 qps load average: 21.99
100 threads, 18366 queries 333.9 qps load average: 78.16
all7 dist=6 (default)
20 threads, 16006 queries 291.0 qps load average: 36.29
30 threads, 15338 queries 278.9 qps load average: 44.96
100 threads, 16137 queries 293.4 qps load average: 98.59
index=all threads=100 dist_threads=0 index=all threads=30 dist_threads=0 index=all threads=20 dist_threads=0
# NumSamples = 23212; Min = 0.00; Max = 20.40 # NumSamples = 23647; Min = 0.00; Max = 1.23 # NumSamples = 23590; Min = 0.00; Max = 0.83
# Mean = 0.206813; Variance = 0.112069; SD = 0.334767; Median 0.203000 # Mean = 0.054450; Variance = 0.001427; SD = 0.037771; Median 0.048000 # Mean = 0.036556; Variance = 0.000458; SD = 0.021398; Median 0.036000
# each ∎ represents a count of 67 # each ∎ represents a count of 87 # each ∎ represents a count of 135
0.000 - 0.001 [ 286][ 1%]: ∎∎∎∎ 0.000 - 0.001 [ 335][ 1%]: ∎∎∎ 0.000 - 0.001 [ 538][ 2%]: ∎∎∎
0.001 - 0.010 [ 1660][ 7%]: ∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎ 0.001 - 0.010 [ 1942][ 8%]: ∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎ 0.001 - 0.010 [ 3162][ 13%]: ∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎
0.010 - 0.020 [ 344][ 1%]: ∎∎∎∎∎ 0.010 - 0.020 [ 1081][ 4%]: ∎∎∎∎∎∎∎∎∎∎∎∎ 0.010 - 0.020 [ 1270][ 5%]: ∎∎∎∎∎∎∎∎∎
0.020 - 0.030 [ 1705][ 7%]: ∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎ 0.020 - 0.030 [ 2545][ 10%]: ∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎ 0.020 - 0.030 [ 3244][ 13%]: ∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎
0.030 - 0.050 [ 4206][ 18%]: ∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎ 0.030 - 0.050 [ 6593][ 27%]: ∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎ 0.030 - 0.050 [ 10183][ 43%]: ∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎
0.050 - 0.070 [ 1171][ 5%]: ∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎ 0.050 - 0.070 [ 4831][ 20%]: ∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎ 0.050 - 0.070 [ 4141][ 17%]: ∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎
0.070 - 0.090 [ 501][ 2%]: ∎∎∎∎∎∎∎ 0.070 - 0.090 [ 2988][ 12%]: ∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎ 0.070 - 0.090 [ 851][ 3%]: ∎∎∎∎∎∎
0.090 - 0.110 [ 365][ 1%]: ∎∎∎∎∎ 0.090 - 0.110 [ 1665][ 7%]: ∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎ 0.090 - 0.110 [ 128][ 0%]:
0.110 - 0.150 [ 607][ 2%]: ∎∎∎∎∎∎∎∎∎ 0.110 - 0.150 [ 1259][ 5%]: ∎∎∎∎∎∎∎∎∎∎∎∎∎∎ 0.110 - 0.150 [ 49][ 0%]:
0.150 - 0.200 [ 705][ 3%]: ∎∎∎∎∎∎∎∎∎∎ 0.150 - 0.200 [ 324][ 1%]: ∎∎∎ 0.150 - 0.200 [ 17][ 0%]:
0.200 - 0.300 [ 4837][ 20%]: ∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎ 0.200 - 0.300 [ 65][ 0%]: 0.200 - 0.300 [ 3][ 0%]:
0.300 - 0.400 [ 5087][ 21%]: ∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎ 0.300 - 0.400 [ 9][ 0%]: 0.300 - 0.400 [ 2][ 0%]:
0.400 - 0.500 [ 964][ 4%]: ∎∎∎∎∎∎∎∎∎∎∎∎∎∎ 0.400 - 0.500 [ 4][ 0%]: 0.400 - 0.500 [ 1][ 0%]:
0.500 - 0.900 [ 515][ 2%]: ∎∎∎∎∎∎∎ 0.500 - 0.900 [ 5][ 0%]: 0.500 - 0.831 [ 1][ 0%]:
0.900 - 1.500 [ 160][ 0%]: ∎∎ 0.900 - 1.226 [ 1][ 0%]:
1.500 - 20.401 [ 99][ 0%]: ∎
index=all7 threads=100 dist_threads=0 index=all7 threads=30 dist_threads=0 index=all7 threads=20 dist_threads=0
# NumSamples = 18370; Min = 0.00; Max = 11.74 # NumSamples = 18060; Min = 0.00; Max = 3.99 # NumSamples = 18144; Min = 0.00; Max = 1.35
# Mean = 0.274236; Variance = 0.388838; SD = 0.623569; Median 0.046000 # Mean = 0.077279; Variance = 0.014235; SD = 0.119312; Median 0.046000 # Mean = 0.049944; Variance = 0.000990; SD = 0.031457; Median 0.044000
# each ∎ represents a count of 103 # each ∎ represents a count of 104 # each ∎ represents a count of 111
0.000 - 0.001 [ 210][ 1%]: ∎∎ 0.000 - 0.001 [ 235][ 1%]: ∎∎ 0.000 - 0.001 [ 241][ 1%]: ∎∎
0.001 - 0.010 [ 293][ 1%]: ∎∎ 0.001 - 0.010 [ 189][ 1%]: ∎ 0.001 - 0.010 [ 271][ 1%]: ∎∎
0.010 - 0.020 [ 504][ 2%]: ∎∎∎∎ 0.010 - 0.020 [ 456][ 2%]: ∎∎∎∎ 0.010 - 0.020 [ 498][ 2%]: ∎∎∎∎
0.020 - 0.030 [ 1478][ 8%]: ∎∎∎∎∎∎∎∎∎∎∎∎∎∎ 0.020 - 0.030 [ 1549][ 8%]: ∎∎∎∎∎∎∎∎∎∎∎∎∎∎ 0.020 - 0.030 [ 1608][ 8%]: ∎∎∎∎∎∎∎∎∎∎∎∎∎∎
0.030 - 0.050 [ 7793][ 42%]: ∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎ 0.030 - 0.050 [ 7839][ 43%]: ∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎ 0.030 - 0.050 [ 8381][ 46%]: ∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎
0.050 - 0.070 [ 2756][ 15%]: ∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎ 0.050 - 0.070 [ 3243][ 17%]: ∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎ 0.050 - 0.070 [ 4286][ 23%]: ∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎
0.070 - 0.090 [ 1152][ 6%]: ∎∎∎∎∎∎∎∎∎∎∎ 0.070 - 0.090 [ 1207][ 6%]: ∎∎∎∎∎∎∎∎∎∎∎ 0.070 - 0.090 [ 1655][ 9%]: ∎∎∎∎∎∎∎∎∎∎∎∎∎∎
0.090 - 0.110 [ 489][ 2%]: ∎∎∎∎ 0.090 - 0.110 [ 558][ 3%]: ∎∎∎∎∎ 0.090 - 0.110 [ 727][ 4%]: ∎∎∎∎∎∎
0.110 - 0.150 [ 309][ 1%]: ∎∎∎ 0.110 - 0.150 [ 685][ 3%]: ∎∎∎∎∎∎ 0.110 - 0.150 [ 365][ 2%]: ∎∎∎
0.150 - 0.200 [ 187][ 1%]: ∎ 0.150 - 0.200 [ 712][ 3%]: ∎∎∎∎∎∎ 0.150 - 0.200 [ 71][ 0%]:
0.200 - 0.300 [ 251][ 1%]: ∎∎ 0.200 - 0.300 [ 809][ 4%]: ∎∎∎∎∎∎∎ 0.200 - 0.300 [ 28][ 0%]:
0.300 - 0.400 [ 197][ 1%]: ∎ 0.300 - 0.400 [ 337][ 1%]: ∎∎∎ 0.300 - 0.400 [ 7][ 0%]:
0.400 - 0.500 [ 169][ 0%]: ∎ 0.400 - 0.500 [ 113][ 0%]: ∎ 0.400 - 0.500 [ 0][ 0%]:
0.500 - 0.900 [ 536][ 2%]: ∎∎∎∎∎ 0.500 - 0.900 [ 87][ 0%]: 0.500 - 0.900 [ 2][ 0%]:
0.900 - 1.500 [ 750][ 4%]: ∎∎∎∎∎∎∎ 0.900 - 1.500 [ 24][ 0%]: 0.900 - 1.354 [ 4][ 0%]:
1.500 - 11.745 [ 1296][ 7%]: ∎∎∎∎∎∎∎∎∎∎∎∎ 1.500 - 3.987 [ 17][ 0%]:
index=all7 threads=100 dist_threads=6 index=all7 threads=30 dist_threads=6 index=all7 threads=20 dist_threads=6
# NumSamples = 16140; Min = 0.00; Max = 7.77 # NumSamples = 15347; Min = 0.00; Max = 4.84 # NumSamples = 16012; Min = 0.00; Max = 2.79
# Mean = 0.301727; Variance = 0.077750; SD = 0.278837; Median 0.219000 # Mean = 0.094509; Variance = 0.017743; SD = 0.133202; Median 0.055000 # Mean = 0.060909; Variance = 0.006291; SD = 0.079318; Median 0.031000
# each ∎ represents a count of 54 # each ∎ represents a count of 57 # each ∎ represents a count of 64
0.001 - 0.001 [ 1][ 0%]: 0.001 - 0.001 [ 0][ 0%]: 0.001 - 0.001 [ 5][ 0%]:
0.001 - 0.010 [ 5][ 0%]: 0.004 - 0.010 [ 61][ 0%]: ∎ 0.001 - 0.010 [ 248][ 1%]: ∎∎∎
0.010 - 0.020 [ 16][ 0%]: 0.010 - 0.020 [ 711][ 4%]: ∎∎∎∎∎∎∎∎∎∎∎∎ 0.010 - 0.020 [ 2659][ 16%]: ∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎
0.020 - 0.030 [ 40][ 0%]: 0.020 - 0.030 [ 1756][ 11%]: ∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎ 0.020 - 0.030 [ 4841][ 30%]: ∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎
0.030 - 0.050 [ 248][ 1%]: ∎∎∎∎ 0.030 - 0.050 [ 4330][ 28%]: ∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎ 0.030 - 0.050 [ 4131][ 25%]: ∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎
0.050 - 0.070 [ 355][ 2%]: ∎∎∎∎∎∎ 0.050 - 0.070 [ 2782][ 18%]: ∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎ 0.050 - 0.070 [ 714][ 4%]: ∎∎∎∎∎∎∎∎∎∎∎
0.070 - 0.090 [ 569][ 3%]: ∎∎∎∎∎∎∎∎∎∎ 0.070 - 0.090 [ 1638][ 10%]: ∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎ 0.070 - 0.090 [ 338][ 2%]: ∎∎∎∎∎
0.090 - 0.110 [ 789][ 4%]: ∎∎∎∎∎∎∎∎∎∎∎∎∎∎ 0.090 - 0.110 [ 822][ 5%]: ∎∎∎∎∎∎∎∎∎∎∎∎∎∎ 0.090 - 0.110 [ 343][ 2%]: ∎∎∎∎∎
0.110 - 0.150 [ 2287][ 14%]: ∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎ 0.110 - 0.150 [ 851][ 5%]: ∎∎∎∎∎∎∎∎∎∎∎∎∎∎ 0.110 - 0.150 [ 820][ 5%]: ∎∎∎∎∎∎∎∎∎∎∎∎
0.150 - 0.200 [ 2868][ 17%]: ∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎ 0.150 - 0.200 [ 641][ 4%]: ∎∎∎∎∎∎∎∎∎∎∎ 0.150 - 0.200 [ 871][ 5%]: ∎∎∎∎∎∎∎∎∎∎∎∎∎
0.200 - 0.300 [ 4070][ 25%]: ∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎ 0.200 - 0.300 [ 858][ 5%]: ∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎ 0.200 - 0.300 [ 831][ 5%]: ∎∎∎∎∎∎∎∎∎∎∎∎
0.300 - 0.400 [ 1817][ 11%]: ∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎ 0.300 - 0.400 [ 487][ 3%]: ∎∎∎∎∎∎∎∎ 0.300 - 0.400 [ 163][ 1%]: ∎∎
0.400 - 0.500 [ 817][ 5%]: ∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎ 0.400 - 0.500 [ 243][ 1%]: ∎∎∎∎ 0.400 - 0.500 [ 30][ 0%]:
0.500 - 0.900 [ 1487][ 9%]: ∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎ 0.500 - 0.900 [ 152][ 0%]: ∎∎ 0.500 - 0.900 [ 12][ 0%]:
0.900 - 1.500 [ 701][ 4%]: ∎∎∎∎∎∎∎∎∎∎∎∎ 0.900 - 1.500 [ 4][ 0%]: 0.900 - 1.500 [ 2][ 0%]:
1.500 - 7.771 [ 70][ 0%]: ∎ 1.500 - 4.839 [ 11][ 0%]: 1.500 - 2.788 [ 4][ 0%]:
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment