InnoDB vs MyISAM vs Falcon benchmarks
2008-10-17 11:12:09 来源:WEB开发网MyISAM和InnoDB的性能比较的一篇文章,可以看出InnoDB并不比MyISAM慢。而且InnoDB提供事务支持。
PS: javaeye用的就是InnoDB
InnoDB vs MyISAM vs Falcon benchmarks - part 1
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:
http://www.mysqlperformanceblog.com/files/benchmarks/phptestsuite.stable.tar.gz
We used table "normal" table structure which corresponds to typical structure you would see in OLTP or Web applications - medium size rows, auto increment primary key and couple of extra indexes.
PLAIN TEXT
SQL:
CREATE TABLE IF NOT EXISTS `$tableName` (
- ››VSFTP服务器配置详解
- ››VS2008 安装失败(“Web 创作组件”无法)的解决办...
- ››VS调用存储过程
- ››VS2005无法远程连接SQL数据库问题
- ››VS2010 Express中文版已经发布至MSDN
- ››VS2008C# 开发 Windows Mobile 6.0程序应注意的几...
- ››VS08中最简单也最实用的Ajax无刷新技术
- ››VS2003+nds OR VS2003+carbide.vs 开发 Symbian 程...
- ››VS2008 平台下进行 Windows Mobile 开发环境的搭建...
- ››myisamchk详细用法(表的维护和崩溃恢复)
- ››VS 2010/.NET 4 RC版 发布了
- ››VS 2010的Intellisense相关崩溃的修补
更多精彩
赞助商链接