dbbench
is a fast, lightweight database workload generator that executes a
workload defined a flexible configuration file. Using this dbbench
, simple
'jobs' can be defined to describe a workload run
against a server. Each job represents a single query; by composing multiple
jobs together, an arbitrary workload can be described. The jobs are executed
against the server and timed to produce
aggregated benchmarking information that is emitted periodically and when the
test completes. Exact job run data can also be logged for additional offline
analysis.
Note that since dbbench
is a workload driver, it does not randomly generate
queries, tables, data, etc. Any random data generation or setup can be easily
done with SQL queries.
To install, first install the dependencies (golang-go
and git
).
sudo apt-get -y install golang
sudo apt-get -y install git
dbbench
requires golang version >= 1.10. Check the golang version:
go version
If your distribution comes with an older version of golang or the required version is not included in the repository, download and install a newer version of golang.
If you are installing go
for the first time, you will also need
to set your GOPATH
environment
variable and add $GOPATH/bin
to
your PATH
.
mkdir $HOME/go
export GOPATH=$HOME/go
export PATH=$PATH:$GOPATH/bin
Once go
has been set up, use the go
tool to get dbbench
.
go get github.com/memsql/dbbench
To learn how to run dbbench
, follow the tutorial.
dbbench
is heavily inspired by fio
. It
was written by Alex Reece [email protected] (Performance Engineer at MemSQL)
to enable flexible testing of a database. He got tired of writing specific test
applications to simulate a given workload, and found that the existing database
benchmark/test tools out there weren't flexible enough to do what he wanted. For more
context about the ethos of dbbench
, see the
blog post that introduced it.