Category: SysBench

SysBench 0.5 rev. 132 for Windows

Hi 🙂

This is an update ! For details on how to use, see my previous post !

SysBench is a system performance benchmarking tool which can be used to test MySQL. Sources are available on launchpad but it’s hard to find builds for Windows.

I build the last committed version (3-1-2015) with MySQL 5.5.39.

Build : SysBench
Src : available on GitHub

Hope this helps 🙂

Marc

SysBench 0.5 rev. 130 for Windows

Hi 🙂

SysBench is a system performance benchmarking tool which can be used to test MySQL. Sources are available on launchpad but it’s hard to find builds for Windows.

So i build the last committed version (12-22-2014) with MySQL 5.5.39.

Build : SysBench
Src : available on GitHub

Here is an example on how to use it to benchmark your mysql instance:

sysbench --test=./db/oltp.lua prepare --mysql-host=localhost --mysql-port=3306 --mysql-user=root --mysql-password=pwd --mysql-db=test --oltp-table-size=1000000 --oltp-tables-count=4

sysbench --test=./db/oltp.lua run --mysql-host=localhost --mysql-port=3306 --mysql-user=root --mysql-password=pwd --mysql-db=test --oltp-tables-count=4 --num-threads=4

The full documentation for MySQL with Sysbench is available on Percona. You can also benchmark your cpu/ram/file io with sysbench..

Hope this helps 🙂

Marc