During my work I sometimes need to perform some benchmarks. I usually use sysbench. The version provided in EPEL for CentOS is old and I wanted to benefit from all the new features of the latest version from launchpad maintained by my colleague Alexey. But as I don’t want to install bzr and devel packages and then recompile each time, I decided to make an rpm. I think some people could find it useful so I share it. Enjoy !

[update] I made a new package that also includes the lua files for db tests.

[update] New package from last bzr trunk where bug related to –tx-rate has been fixed (requested by my colleague Jay for his Percona Live New York tutorial about XtraDB Cluster

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

4 Comments

  1. Hello,

    Installation of the above fails on CentOS6:

    Setting up Install Process
    Examining sysbench-0.5-2.el6_.x86_64.rpm: sysbench-0.5-2.el6.x86_64
    Marking sysbench-0.5-2.el6_.x86_64.rpm as an update to sysbench-0.4.12-5.el6.x86_64
    Resolving Dependencies
    –> Running transaction check
    —> Package sysbench.x86_64 0:0.4.12-5.el6 will be updated
    —> Package sysbench.x86_64 0:0.5-2.el6 will be an update
    –> Processing Dependency: libmysqlclient.so.18()(64bit) for package: sysbench-0.5-2.el6.x86_64
    –> Finished Dependency Resolution
    Error: Package: sysbench-0.5-2.el6.x86_64 (/sysbench-0.5-2.el6_.x86_64)
    Requires: libmysqlclient.so.18()(64bit)
    You could try using –skip-broken to work around the problem

    Care to provide the source RPM?

    • [root@percona-pxc55-1 ~]# rpm -ivh sysbench-0.5-3.el6_.x86_64.rpm
      error: Failed dependencies:
      libmysqlclient.so.18()(64bit) is needed by sysbench-0.5-3.el6.x86_64
      [root@percona-pxc55-1 ~]#

      While installing if you get above error, then install shared package.

      [root@percona-pxc55-1 ~]# rpm -ivh Percona-XtraDB-Cluster-shared-55-5.5.37-25.10.756.el6.x86_64.rpm
      Preparing… ########################################### [100%]
      1:Percona-XtraDB-Cluster-########################################### [100%]
      [root@percona-pxc55-1 ~]#
      [root@percona-pxc55-1 ~]# rpm -ivh sysbench-0.5-3.el6_.x86_64.rpm
      Preparing… ########################################### [100%]
      1:sysbench ########################################### [100%]
      [root@percona-pxc55-1 ~]#

Leave a Reply to Nilnandan JoshiCancel Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

As MySQL Community Manager, I am an employee of Oracle and the views expressed on this blog are my own and do not necessarily reflect the views of Oracle.

You can find articles I wrote on Oracle’s blog.