WEB开发网
开发学院数据库MySQL InnoDB vs MyISAM vs Falcon benchmarks 阅读

InnoDB vs MyISAM vs Falcon benchmarks

 2008-10-17 11:12:09 来源:WEB开发网   
核心提示: InnoDB is faster than MyISAM by 6-9%.Falcon shows very bad scalabilty.READ_KEY_POINTQuery: SELECT name FROM $tableName WHERE country_id = %dIn th

InnoDB is faster than MyISAM by 6-9%.

Falcon shows very bad scalabilty.

READ_KEY_POINT

InnoDB vs MyISAM vs Falcon benchmarks

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

In this case Falcon is the best, because Falcon uses a tricky technic to retrieve rows (more

details with Jim Starkey's comments in Part 2).

There MyISAM shows bad scalability with increasing count of thread. I think the reason is pread system

call MyISAM uses to access data and retrieving from OS cache is not scaled.

READ_KEY_POINT_LIMIT

InnoDB vs MyISAM vs Falcon benchmarks

Query: SELECT name FROM $tableName WHERE country_id = %d LIMIT 5

The same query as previous but with LIMIT clause.

Due to Falcon's way of key access Falcon cannot handle LIMIT properly and that is why

we see bad performance. We hope the performance of LIMIT queries will be fixed before release.

MyISAM shows stable result.

InnoDB is better than MyISAM by 58% in case with 4 threads, but does not scale good enough.

Perhaps there is still a problem with InnoDB mutexes.

READ_KEY_POINT_NO_DATA

InnoDB vs MyISAM vs Falcon benchmarks

上一页  1 2 3 4 5 6 7  下一页

Tags:InnoDB vs MyISAM

编辑录入:爽爽 [复制链接] [打 印]
赞助商链接