A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | MySQL 5.5.22 | 8 Cores CPU: Intel(R) Xeon(R) CPU L5310 @ 1.60GHz (1596.07-MHz K8-class CPU) avail memory = 4090195968 (3900 MB) | ||||||||||||||
2 | sysbench --test=oltp --db-driver=mysql --mysql-table-engine=innodb --mysql-socket=/tmp/mysql.sock --mysql-user=root --max-requests=0 --max-time=120 --oltp-read-only=on --num-threads=$i run | |||||||||||||||
3 | Run2 after reboot | |||||||||||||||
4 | head/r233909/ULE | Threads 1 | Threads 4 | Threads 8 | Threads 16 | Threads 32 | Threads 40 | Threads 64 | Threads 128 | Threads 4 | Threads 8 | Threads 16 | Threads 32 | Threads 40 | Threads 64 | |
5 | Run 1 | 416.21 | 1458.69 | 2710.35 | 2646.16 | 2533.45 | 2476.49 | 2379.03 | 2246.8 | 1458.59 | 2701.36 | 2655.4 | 2534.52 | 2489.55 | 2397.62 | |
6 | Run 2 | 436.95 | 1474.93 | 2709.38 | 2628.81 | 2521.7 | 2467.79 | 2385.93 | 2215 | 1453.75 | 2683 | 2634.15 | 2529.82 | 2491.75 | 2398.26 | |
7 | Run 3 | 416.53 | 1453.95 | 2673.72 | 2634.68 | 2521.99 | 2466.22 | 2388 | 2199.27 | 1473.09 | 2718.59 | 2631.63 | 2523.65 | 2486.04 | 2403.84 | |
8 | Run 4 | 427.34 | 1452.33 | 2723.81 | 2635.23 | 2521.95 | 2458.14 | 2387.97 | 2245.07 | 1450.12 | 2671.53 | 2631.23 | 2505.29 | 2473.29 | 2393.16 | |
9 | Run 5 | 430.34 | 1454.67 | 2664.17 | 2636.7 | 2513.8 | 2465.6 | 2388.55 | 1854.41 | |||||||
10 | Run 6 | 422.05 | 1454.04 | 2719.83 | 2637.41 | 2508.81 | 2455.23 | 2384.94 | 2174.95 | |||||||
11 | Run 7 | 431.02 | 1455.3 | 2686.31 | 2633.42 | 2509.14 | 2465.23 | 2385.69 | 2167.8 | |||||||
12 | Run 8 | 414.95 | 1454.29 | 2707.05 | 2635.59 | 2504.11 | 2453.74 | 2386.93 | 2156.87 | |||||||
13 | head/r233909/ULE | 424.42375 | 1457.275 | 2699.3275 | 2636 | 2516.86875 | 2463.555 | 2385.88 | 2157.52125 | |||||||
14 | ||||||||||||||||
15 | head/r233913/ULE | Threads 1 | Threads 4 | Threads 8 | Threads 16 | Threads 32 | Threads 40 | Threads 64 | Threads 128 | |||||||
16 | Run 1 | 425.77 | 1449.87 | 2708.99 | 2651.66 | 2528.83 | 2478.12 | 2382.65 | 2236.82 | |||||||
17 | Run 2 | 413.57 | 1453.16 | 2656.5 | 2639.84 | 2519.02 | 2471.68 | 2395.21 | 2220.3 | |||||||
18 | Run 3 | 429.72 | 1475.29 | 2712.3 | 2640.03 | 2525.97 | 2469.71 | 2396.21 | 2190.72 | |||||||
19 | Run 4 | 415.84 | 1455.32 | 2672.78 | 2645.48 | 2507.74 | 2478.59 | 2395.23 | 2181.76 | |||||||
20 | Run 5 | 417.12 | 1456.07 | 2704.17 | 2642.56 | 2510.81 | 2471.91 | 2394.04 | 2193.34 | |||||||
21 | Run 6 | 426.89 | 1456.83 | 2683.95 | 2645.95 | 2504.61 | 2475.41 | 2393.19 | 2229.44 | |||||||
22 | Run 7 | 424.18 | 1453.75 | 2667.62 | 2642.31 | 2509.03 | 2469.79 | 2402.67 | 2174.63 | |||||||
23 | Run 8 | 424.66 | 1448.11 | 2718.47 | 2642.52 | 2502.95 | 2477.54 | 2397.25 | 2154.85 | |||||||
24 | head/r233913/ULE | 422.21875 | 1456.05 | 2690.5975 | 2643.79375 | 2513.62 | 2474.09375 | 2394.55625 | 2197.7325 | |||||||
25 | ||||||||||||||||
26 | head/r236758/ULE | Threads 1 | Threads 4 | Threads 8 | Threads 16 | Threads 32 | Threads 40 | Threads 64 | Threads 128 | |||||||
27 | Run 1 | 452.12 | 1631.4 | 3098.16 | 3013.98 | 2872.95 | 2971.94 | 2846.61 | 2677.89 | |||||||
28 | Run 2 | 473.45 | 1630.5 | 3103.96 | 3016.04 | 2967.71 | 2963.07 | 2862.4 | 2678.45 | |||||||
29 | Run 3 | 469.44 | 1630.71 | 3105.37 | 3011.3 | 2971.44 | 2966.02 | 2853.32 | 2669.84 | |||||||
30 | Run 4 | 473.63 | 1632.37 | 3098.35 | 3014.12 | 2971.68 | 2968.49 | 2860.84 | 2674.47 | |||||||
31 | Run 5 | 472.13 | 1628.36 | 3104.16 | 3012.88 | 2969.68 | 2958.29 | 2857.09 | 2670.51 | |||||||
32 | Run 6 | 471.6 | 1626.5 | 3103.47 | 3018 | 2975.59 | 2966.7 | 2875.13 | 2677.63 | |||||||
33 | Run 7 | 470.65 | 1633.33 | 3101.98 | 3014.14 | 2976.08 | 2959.83 | 2866.87 | 2667.29 | |||||||
34 | Run 8 | 457.62 | 1625.97 | 3100.93 | 3012 | 2973.57 | 2947.1 | 2865.92 | 2663.63 | |||||||
35 | head/r236758/ULE | 467.58 | 1629.8925 | 3102.0475 | 3014.0575 | 2959.8375 | 2962.68 | 2861.0225 | 2672.46375 | |||||||
36 | ||||||||||||||||
37 | head/r239148/ULE | Threads 1 | Threads 4 | Threads 8 | Threads 16 | Threads 32 | Threads 40 | Threads 64 | Threads 128 | |||||||
38 | Run 1 | 460.51 | 1646.94 | 3126.42 | 3039.79 | 2992.24 | 2979.7 | 2864.59 | 2668.52 | |||||||
39 | Run 2 | 459.58 | 1653.99 | 3135.42 | 3044.61 | 2987 | 2985.77 | 2866.64 | 2672.05 | |||||||
40 | Run 3 | 460.18 | 1649.36 | 3131.63 | 3046.07 | 2988.49 | 2990.75 | 2867.48 | 2664.95 | |||||||
41 | Run 4 | 462.03 | 1649.74 | 3132.15 | 3048.86 | 2988.22 | 2977.54 | 2863.56 | 2665.69 | |||||||
42 | Run 5 | 460.86 | 1649.99 | 3130.52 | 3047.58 | 2987.91 | 2980.99 | 2864.06 | 2665.91 | |||||||
43 | Run 6 | 459.85 | 1650.08 | 3131.41 | 3047.54 | 2991.23 | 2989.97 | 2867.48 | 2669.16 | |||||||
44 | Run 7 | 461.56 | 1651.43 | 3125.66 | 3044.76 | 2996.74 | 2979.29 | 2864.37 | 2666.28 | |||||||
45 | Run 8 | 462.48 | 1649.05 | 3138.95 | 3042.15 | 2993.48 | 3008.44 | 2865.29 | 2666 | |||||||
46 | head/r239148/ULE | 460.88125 | 1650.0725 | 3131.52 | 3045.17 | 2990.66375 | 2986.55625 | 2865.43375 | 2667.32 | |||||||
47 | ||||||||||||||||
48 | head/r239327/ULE | Threads 1 | Threads 4 | Threads 8 | Threads 16 | Threads 32 | Threads 40 | Threads 64 | Threads 128 | |||||||
49 | Run 1 | 474.03 | 1650.22 | 3198.87 | 3091.72 | 3068.81 | 3088.21 | 3002.34 | 2814.62 | |||||||
50 | Run 2 | 476.1 | 1652.65 | 3201.42 | 3090.7 | 3049.46 | 3067.32 | 2981.56 | 2776.37 | |||||||
51 | Run 3 | 473.44 | 1650.52 | 3200.57 | 3093.86 | 3105.3 | 3067.97 | 2985.76 | 2823.69 | |||||||
52 | Run 4 | 472.76 | 1651.07 | 3206.11 | 3086.39 | 3101.05 | 3108.13 | 3034.51 | 2802.46 | |||||||
53 | Run 5 | 476.08 | 1653.14 | 3205.24 | 3091.01 | 3071.82 | 3080.01 | 2980.99 | 2766.19 | |||||||
54 | Run 6 | 470.42 | 1649.62 | 3203.9 | 3089.71 | 3063.42 | 3026.73 | 3041.43 | 2867.34 | |||||||
55 | Run 7 | 472.11 | 1650.97 | 3197.12 | 3094.67 | 3112.26 | 3051.24 | 2992.1 | 2772.22 | |||||||
56 | Run 8 | 478.02 | 1653.56 | 3207.04 | 3090.7 | 3102.63 | 3070.96 | 3010.09 | 2954.47 | |||||||
57 | head/r239327/ULE | 474.12 | 1651.46875 | 3202.53375 | 3091.095 | 3084.34375 | 3070.07125 | 3003.5975 | 2822.17 | |||||||
58 | ||||||||||||||||
59 | ||||||||||||||||
60 | ||||||||||||||||
61 | ||||||||||||||||
62 | ||||||||||||||||
63 | ||||||||||||||||
64 | ||||||||||||||||
65 | ||||||||||||||||
66 | ||||||||||||||||
67 | ||||||||||||||||
68 | ||||||||||||||||
69 | ||||||||||||||||
70 | ||||||||||||||||
71 | ||||||||||||||||
72 | ||||||||||||||||
73 | ||||||||||||||||
74 | ||||||||||||||||
75 | ||||||||||||||||
76 | ||||||||||||||||
77 | ||||||||||||||||
78 | ||||||||||||||||
79 | ||||||||||||||||
80 | ||||||||||||||||
81 | ||||||||||||||||
82 | ||||||||||||||||
83 | ||||||||||||||||
84 | ||||||||||||||||
85 | ||||||||||||||||
86 | ||||||||||||||||
87 | ||||||||||||||||
88 | ||||||||||||||||
89 | ||||||||||||||||
90 | ||||||||||||||||
91 | ||||||||||||||||
92 | ||||||||||||||||
93 | ||||||||||||||||
94 | ||||||||||||||||
95 | ||||||||||||||||
96 | ||||||||||||||||
97 | ||||||||||||||||
98 | ||||||||||||||||
99 | ||||||||||||||||
100 |