InnoDB vs MyISAM vs Falcon benchmarks

核心提示： The schema and queries are described hereUsed hardwareCentOS release 4.4 (Final)2 х Dual Core Intel XEON 5130model name : Intel(R) Xeon(R) CPU 51

The schema and queries are described here

Used hardware

CentOS release 4.4 (Final)

2 х Dual Core Intel XEON 5130

model name : Intel(R) Xeon(R) CPU 5130 @ 2.00GHz

stepping : 6

cpu MHz : 1995.004

cache size : 4096 KB

16GB of RAM

MySQL version

We used MySQL 5.1.14-beta sources for MyISAM / InnoDB

and MySQL 5.1.14-falcon bitkeeper tree

bk://mysql.bkbits.net/mysql-5.1-falcon for Falcon

(Please note this is a first release of Falcon and it is still in alpha stage and performance parameters may vary a lot in next releases)

Compilation parameters:

PLAIN TEXT

CODE:

For MyISAM / InnoDB

./configure --prefix=/usr/local/mysqltest/mysql- --with-innodb

For Falcon

./configure --prefix=/usr/local/mysqltest/mysql- --with-falcon

mysqld startup params:

PLAIN TEXT

CODE:

Falcon:

libexec/mysqld --no-defaults --user=root --falcon_min_record_memory=1G --falcon_max_record_memory=2GB --falcon_page_cache_size=1500M --max-connections=1500 --table-cache=512 --net_read_timeout=30 --net_write_timeout=30 --backlog=128