Advanced benchmarking tools

Until now we have used the mysqlslap benchmarking tool. But, if you need to test your database server more thoroughly, other more advanced benchmarking tools do exist. We will have a quick look at two of these tools: DBT2 and SysBench.

DBT2

This benchmarking tool is used in order to run automated benchmarking tests against a MySQL server. It allows you to mimic large amounts of data warehouses.

To download, compile and install DBT2, please enter the following commands on the container's CLI:

# cd /srv/www
# wget -O dbt2-0.37.tar.gz https://master.dl.sourceforge.net/project/osdldbt/dbt2/0.37/dbt2-0.37.tar.gz 
# tar -xvf dbt2-0.37.tar.gz 
# cd dbt2-0.37.tar.gz 
# ./configure --with-mysql 
# make...