The result is in queries per sec, more is better Threads 5.1.14 InnoDB/MyISAM InnoDB/Falcon READ_PK_POINT MyISAM InnoDB Falcon ratio +/- % ratio +/- % 1 14,359.11 15,333.10 10,292.16 1.07 6.78 1.49 48.98 4 41,187.17 44,924.77 34,295.02 1.09 9.07 1.31 30.99 16 42,238.22 45,494.52 17,328.57 1.08 7.71 2.63 162.54 64 40,000.86 43,383.69 11,869.34 1.08 8.46 3.66 265.51 128 36,966.63 39,619.90 12,270.40 1.07 7.18 3.23 222.89 256 32,733.35 33,839.53 10,534.93 1.03 3.38 3.21 221.21 READ_KEY_POINT MyISAM InnoDB Falcon 1 36.63 48.76 53.59 1.33 33.11 0.91 -9.02 4 84.65 91.94 109.12 1.09 8.61 0.84 -15.74 16 86.63 87.49 114.56 1.01 0.99 0.76 -23.63 64 79.26 82.34 108.40 1.04 3.90 0.76 -24.04 128 12.42 76.97 112.82 6.20 519.67 0.68 -31.78 256 9.02 67.89 110.19 7.53 652.96 0.62 -38.39 READ_KEY_POINT_LIMIT MyISAM InnoDB Falcon 1 6,116.15 8,499.64 546.93 1.39 38.97 15.54 1454.07 4 16,002.83 25,381.56 326.61 1.59 58.61 77.71 7671.19 16 16,846.96 24,554.44 331.38 1.46 45.75 74.1 7309.75 64 16,399.62 22,421.92 333.18 1.37 36.72 67.3 6629.69 128 15,950.53 18,438.21 298.27 1.16 15.60 61.82 6081.68 256 15,957.51 14,409.64 243.98 0.90 -9.70 59.06 5806.2 READ_KEY_POINT_NO_DATA MyISAM InnoDB Falcon 1 82.71 145.80 53.96 1.76 76.29 2.7 170.19 4 144.78 193.56 109.21 1.34 33.69 1.77 77.24 16 148.96 194.07 115.33 1.30 30.28 1.68 68.27 64 153.03 192.64 113.13 1.26 25.88 1.7 70.28 128 153.44 187.18 115.36 1.22 21.99 1.62 62.27 256 151.02 167.08 118.36 1.11 10.64 1.41 41.16 READ_KEY_POINT_NO_DATA_LIMIT MyISAM InnoDB Falcon 1 6,572.27 10,735.49 556.09 1.63 63.35 19.31 1830.53 4 16,842.99 31,648.81 326.32 1.88 87.90 96.99 9598.85 16 17,888.32 31,577.40 331.75 1.77 76.53 95.19 9418.55 64 17,322.94 30,205.44 352.08 1.74 74.37 85.79 8479.04 128 17,250.46 24,138.65 300.24 1.40 39.93 80.4 7939.86 256 16,626.26 17,366.35 269.15 1.04 4.45 64.52 6352.37 READ_PK_POINT_INDEX MyISAM InnoDB Falcon 1 14,297.33 13,526.35 11,122.88 0.95 -5.39 1.22 21.61 4 44,311.21 45,777.73 33,579.24 1.03 3.31 1.36 36.33 16 45,556.98 46,373.19 16,956.02 1.02 1.79 2.73 173.49 64 43,293.97 44,062.56 11,559.29 1.02 1.78 3.81 281.19 128 39,496.03 39,935.80 11,555.42 1.01 1.11 3.46 245.6 256 33,763.71 33,611.28 11,004.43 1.00 -0.45 3.05 205.43 READ_PK_RANGE MyISAM InnoDB Falcon 1 2,383.66 5,862.24 3,572.97 2.46 145.93 1.64 64.07 4 5,712.09 19,891.56 11,070.23 3.48 248.24 1.8 79.69 16 5,692.84 19,643.22 6,736.77 3.45 245.05 2.92 191.58 64 1,229.50 18,679.80 4,856.48 15.19 1,419.30 3.85 284.64 128 953.91 17,532.95 4,616.27 18.38 1,738.01 3.8 279.81 256 491.06 12,816.76 4,394.58 26.10 2,510.03 2.92 191.65 READ_PK_RANGE_INDEX MyISAM InnoDB Falcon 1 7,146.21 6,812.92 3,906.40 0.95 -4.66 1.74 74.4 4 14,239.14 22,136.02 11,730.17 1.55 55.46 1.89 88.71 16 16,581.70 21,817.52 7,182.30 1.32 31.58 3.04 203.77 64 16,257.26 20,807.53 5,118.42 1.28 27.99 4.07 306.52 128 15,769.11 19,581.52 4,880.62 1.24 24.18 4.01 301.21 256 15,714.83 13,852.14 4,643.66 0.88 -11.85 2.98 198.3 READ_KEY_RANGE MyISAM InnoDB Falcon 1 170.31 212.91 252.09 1.25 25.02 0.84 -15.54 4 410.33 443.10 489.26 1.08 7.99 0.91 -9.43 16 419.39 421.16 501.22 1.00 0.42 0.84 -15.97 64 391.48 390.50 488.93 1.00 -0.25 0.8 -20.13 128 68.16 361.67 471.91 5.31 430.60 0.77 -23.36 256 42.57 312.08 443.64 7.33 633.12 0.7 -29.66 READ_KEY_RANGE_LIMIT MyISAM InnoDB Falcon 1 2,073.57 2,576.49 1,273.38 1.24 24.25 2.02 102.33 4 5,965.83 7,385.41 518.02 1.24 23.80 14.26 1325.7 16 6,003.12 6,766.84 528.52 1.13 12.72 12.8 1180.33 64 5,973.26 6,179.88 531.04 1.03 3.46 11.64 1063.74 128 5,399.38 5,624.43 483.85 1.04 4.17 11.62 1062.42 256 3,287.58 4,705.77 449.19 1.43 43.14 10.48 947.62 READ_KEY_RANGE_NO_DATA MyISAM InnoDB Falcon 1 368.86 558.65 259.44 1.51 51.45 2.15 115.33 4 699.25 912.40 496.82 1.30 30.48 1.84 83.65 16 736.47 907.04 501.94 1.23 23.16 1.81 80.71 64 729.88 862.26 491.40 1.18 18.14 1.75 75.47 128 721.71 815.53 474.70 1.13 13.00 1.72 71.8 256 754.95 732.32 447.23 0.97 -3.00 1.64 63.75 READ_KEY_RANGE_NO_DATA_LIMIT MyISAM InnoDB Falcon 1 3,222.39 4,296.94 1,288.38 1.33 33.35 3.34 233.52 4 8,082.49 14,644.13 517.79 1.81 81.18 28.28 2728.2 16 8,379.63 13,789.76 528.97 1.65 64.56 26.07 2506.89 64 8,374.92 12,955.95 518.09 1.55 54.70 25.01 2400.72 128 8,132.07 11,130.37 487.69 1.37 36.87 22.82 2182.26 256 8,397.02 9,359.08 449.76 1.11 11.46 20.81 1980.92 READ_FTS MyISAM InnoDB Falcon 1 1.07 1.93 0.90 1.80 80.13 2.16 115.75 4 4.22 5.46 1.79 1.30 29.51 3.05 205.14 16 4.30 5.64 1.77 1.31 31.04 3.18 218.28 64 4.62 5.26 1.90 1.14 13.89 2.76 176.47 128 4.96 4.95 2.16 1.00 -0.38 2.29 129.36 256 5.96 5.45 2.15 0.91 -8.54 2.54 153.58