Thursday, February 26, 2009

An update for sysbench

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.

2 comments:

 
Creative Commons License
This work is licensed under a Creative Commons Attribution-Share Alike 3.0 United States License.