MySQLPerformanceBlog has issue “Several days ago MySQL AB made new storage engine Falcon available for wide auditory. We cannot miss this event and executed several benchmarks to see how Falcon performs in comparison to InnoDB and MyISAM.
The second goal of benchmark was a popular myth that MyISAM is faster than InnoDB in reads, as InnoDB is transactional, supports Foreign Key and has an operational overhead. As you will see it is not always true.”
For benchmarks I used our PHPTestSuite which allows to test wide range tables and queries.
The script and instruction are available here at mysqlperformanceblog.com, it’s posted by Vadim at January 8, 2007.