I posted a patch for sysbench here. This adds a new flag, --oltp-secondary-index, that can be used for the OLTP tests. When this flag is set another column and secondary index are added to the sbtest table and half of the queries use the secondary index. The default behavior is used when it is not set, and all query predicates use the primary key on sbtest.
Feedback is welcome. I need to determine whether I should submit the patch to the sysbench maintainer. sysbench is a very nice tool for benchmarking. There are more complex tests, but if a system doesn't do well on sysbench, it probably will have problems on everything else. So it is a great place to start.
Thursday, February 26, 2009
Subscribe to:
Post Comments (Atom)


This was something I was realy looking for! great!
ReplyDeleteFantastic Job! Thanks Mark!
ReplyDelete