You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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.
Getting started
To install, first install the dependencies (golang-go and git).
dbbench is heavily inspired by fio. It
was written by Alex Reece awreece@gmail.com (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.