InnoDB vs MyISAM vs Falcon benchmarks

核心提示： MyISAM / InnoDB:libexec/mysqld --no-defaults --user=root --key-buffer-size=1500M --innodb-buffer-pool-size=1500M --innodb-log-file-size=100M --in

MyISAM / InnoDB:

libexec/mysqld --no-defaults --user=root --key-buffer-size=1500M --innodb-buffer-pool-size=1500M --innodb-log-file-size=100M --innodb-thread-concurrency=8 --max-connections=1500 --table-cache=512 --net_read_timeout=30 --net_write_timeout=30 --back_log=128

Method of benchmark:

1. Prepare table with 1,000,000 records (about 350Mb of data on disk)

2. Run each query for 1, 4, 16, 64, 128, 256 concurrent threads.

3. For each thread perform a warm-up run (duration 180 sec), and then

run three effective runs (duration of each is 60 sec).

As the final result we get a maximal result of three runs.

The raw numbers are available here:

http://www.mysqlperformanceblog.com/files/benchmarks/innodb-myisam-falcon.html

(Note: This benchmark is synthetic micro benchmarks focusing on particular simple data access patterns. Results for your workload are likely to be different.)

There are interesting results I want to show graphics with comments

READ_PK_POINT

Query: SELECT name FROM $tableName WHERE id = %d

The very common query with access by primary key.