The result is in queries per sec, more is better Threads InnoDB 4CPU PBXT 4CPU PBXT / InnoDB 4CPU InnoDB 8CPU PBXT 8CPU MyISAM 8CPU PBXT / INNODB 8CPU READ_PK_POINT 1 14172.66 12821.21 0.90 10198.89 9876.57 10077.96 0.97 4 38741.91 38026.75 0.98 38907.74 37095.15 36635.09 0.95 16 38815.3 34191.11 0.88 63062.52 50380.7 48310.9 0.80 64 33762.46 31479.78 0.93 37575.45 44204.7 51294.36 1.18 128 21940.69 27474.12 1.25 29520.45 39828.73 52974.66 1.35 256 17116.58 23739.36 1.39 19750.44 29087.95 40195.26 1.47 512 9806.24 16673.57 1.70 10933.7 17707.83 24322.59 1.62 READ_KEY_POINT 1 48.59 61.53 1.27 39.35 45.73 31 1.16 4 87.31 102.26 1.17 54.44 47.5 53.97 0.87 16 79.51 95.12 1.20 38.73 43.13 22.35 1.11 64 74.39 97.76 1.31 41.89 49.41 21.58 1.18 128 70.22 102.06 1.45 43.22 52.9 20.52 1.22 256 65.68 100.29 1.53 43.45 55.4 20.12 1.28 512 60.82 95.75 1.57 36.45 58.56 20.06 1.61 READ_KEY_POINT_NO_DATA 1 183.64 77.93 0.42 160.51 65.4 78.36 0.41 4 127.89 108.62 0.85 69.24 47.89 73.23 0.69 16 128.7 104.9 0.82 45.79 42.84 72.23 0.94 64 138.23 108.49 0.78 48.89 49.57 73.57 1.01 128 137.88 114.54 0.83 50.5 53.5 74.19 1.06 256 131.13 114.22 0.87 50.27 55.44 74.16 1.10 512 118.47 110.09 0.93 42.7 60.36 74.56 1.41 READ_KEY_POINT_LIMIT 1 10493.4 10810.13 1.03 7513.31 8709.21 4690.08 1.16 4 27456.91 30690.3 1.12 26858.61 31954.5 11667.25 1.19 16 26737.25 29563.51 1.11 39845.07 52890.59 8917.14 1.33 64 23010.3 27654.95 1.20 27553.34 48432.14 10915.2 1.76 128 17727.91 24994.73 1.41 22271.2 40128.76 11214.95 1.80 256 12491.43 22050.49 1.76 16676.02 29664.48 11497.28 1.78 512 7112.12 16177.67 2.28 10108.03 17944.54 11805.01 1.78 READ_KEY_POINT_NO_DATA_LIMIT 1 11299.47 10845.52 0.96 9241.6 8880.44 4847 0.96 4 28970.13 31041.66 1.07 26630.5 34095.13 11410.56 1.28 16 28603.1 30163.93 1.06 41941.1 56116.16 8854.22 1.34 64 24064.87 28041.77 1.16 28169.17 49408.19 10789.95 1.75 128 18214.04 25088.63 1.38 23004.37 40579.7 11087.63 1.76 256 12630.2 22195.44 1.76 17326.54 29783.17 11345.82 1.72 512 7581.57 16106.17 2.12 10354.49 17991.2 11636.52 1.74 READ_PK_POINT_INDEX 1 13466.95 12854.17 0.95 10255.22 9845.8 10542.61 0.96 4 38815.62 35111.8 0.90 42113.95 36647.37 36092.79 0.87 16 38618.39 34857.43 0.90 65945.89 54829.04 49163.62 0.83 64 33664.68 32316.93 0.96 37262.99 50891.13 52795.35 1.37 128 21696.29 27875.23 1.28 28953.06 42771.62 54430.48 1.48 256 17165.29 23944.05 1.40 19662.74 30558.78 42210.73 1.55 512 8780.58 16622.9 1.89 11039.5 18350.14 25121.65 1.66 READ_PK_RANGE 1 5179.31 3534.57 0.68 4513.5 2398.42 1848.98 0.53 4 16552.72 5600.94 0.34 16806.06 2421.06 2845.72 0.14 16 16074.64 4996.73 0.31 26861 2008.69 915.09 0.07 64 15055.71 4405.43 0.29 23565.96 1802.2 877.13 0.08 128 13392.04 4087.04 0.30 18823.03 1669.92 844.63 0.09 256 9551.16 3775.52 0.40 13972.98 1514.32 848.75 0.11 512 9025.41 3433.68 0.38 9502.32 1363.45 846.79 0.14 READ_PK_RANGE_INDEX 1 5684.95 5051.62 0.89 4882.95 3447.55 5097.55 0.71 4 17685.41 6283.51 0.36 18205.8 2510.09 5150.54 0.14 16 17090.04 5526.8 0.32 28703.07 2054.26 6327.83 0.07 64 16184.92 4818.67 0.30 24978.46 1843.61 6339.76 0.07 128 13872.41 4462.31 0.32 19046.89 1715.27 6319.81 0.09 256 10036.2 4072.47 0.41 14801.03 1566.31 6279.29 0.11 512 7120.36 3767 0.53 9673.03 1412.61 6229.78 0.15 READ_KEY_RANGE 1 672.59 857.18 1.27 508.13 726.45 333.45 1.43 4 1414.96 2234.7 1.58 915.33 1319.05 796.38 1.44 16 1286.76 2068.45 1.61 667.94 1231.66 337.41 1.84 64 1186.47 1853.4 1.56 733.98 1194.83 334.59 1.63 128 1102.33 1723.38 1.56 749.94 1153.26 317.18 1.54 256 982.44 1593.53 1.62 719.02 1097.54 313.76 1.53 512 794.11 1428.89 1.80 510.32 1032.61 317.52 2.02 READ_KEY_RANGE_LIMIT 1 5499.91 6464.29 1.18 4023.95 5207.95 3062.46 1.29 4 15937.94 19688.85 1.24 12594.54 18378.33 7992.58 1.46 16 15173.61 18103.42 1.19 15575.53 25857.83 7335.93 1.66 64 13469.69 17950.82 1.33 14974.51 24023.56 8820.09 1.60 128 12030.32 16085.03 1.34 13608.6 22381.76 9184.47 1.64 256 9030.17 14751.24 1.63 11252.78 21687.58 9296.88 1.93 512 6067.21 14000.78 2.31 8221.2 15097.59 9295.15 1.84 READ_KEY_RANGE_NO_DATA 1 1718.46 1097.1 0.64 1341.3 960.29 889.11 0.72 4 2575.44 2591.37 1.01 1236.54 1375.83 1153.81 1.11 16 2525.36 2600.85 1.03 875.01 1247.29 1091.32 1.43 64 2389.61 2383.14 1.00 907.74 1211.94 1116.53 1.34 128 2186.36 2111.38 0.97 926.02 1167.95 1132.84 1.26 256 1971.62 1950.01 0.99 876.86 1112.64 1143 1.27 512 1514.64 1771.72 1.17 699.48 1043.11 1139.4 1.49 READ_KEY_RANGE_NO_DATA_LIMIT 1 11157.56 9740.07 0.87 7933.09 7778.77 6639.1 0.98 4 30952.42 28693.98 0.93 31763.23 27817.69 25418.9 0.88 16 30164.77 28744.64 0.95 51553.05 50557.44 30733.04 0.98 64 27425.46 28377.65 1.04 36243.87 45402.64 35767.71 1.25 128 22529.44 26569.16 1.18 25121.81 37930.68 36444.37 1.51 256 15531.18 24099.33 1.55 17802.14 28216.79 32663.49 1.59 512 9677.88 21118.14 2.18 10654.27 17133.33 23864.16 1.61 READ_FTS 1 1.65 0.93 0.56 1.55 0.72 0.76 0.46 4 5.44 3.32 0.61 3.59 2.31 3 0.64 16 5.44 3.33 0.61 4.7 4.23 5.96 0.90 64 5.41 3.18 0.59 4.33 3.45 5.97 0.80 128 4.54 2.93 0.64 4.41 2.95 5.96 0.67 256 3.74 2.81 0.75 4.71 2.55 5.96 0.54 512 3.65 2.68 0.73 4.73 2.23 5.96 0.47