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
Please be advised the install location for the lua files needed for database tests are:
/usr/share/doc/sysbench/tests/db/oltp.lua
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 ~]#
[…] — you’re only going to be on this version if you build it yourself or if you use the package provided courtesy of Frederic Descamps (thanks lefred!). If you’re using the version from […]