SysBench is a modular, cross-platform and multi-threaded benchmark tool for evaluating OS parameters that are important for a system running a database under intensive load.
The idea of this benchmark suite is to quickly get an impression about system performance without setting up complex database benchmarks or even without installing a database at all.
Current features allow to test the following system parameters:
-
file I/O performance
-
scheduler performance
-
memory allocation and transfer speed
-
POSIX threads implementation performance
-
database server performance
./autogen.sh
./configure
make
The above will build SysBench with MySQL support by default. If you have MySQL headers and libraries in non-standard locations (and no mysql_config can be found in the PATH), you can specify them explicitly with --with-mysql-includes and --with-mysql-libs options to ./configure.
To compile SysBench without MySQL support, use --without-mysql. In
this case all database-related tests will not work, but other tests will
be functional.
The general syntax for SysBench is as follows:
sysbench [common-options] --test=name [test-options] command
See General command line options for a description of common options and documentation for particular test mode for a list of test-specific options.
Below is a brief description of available commands and their purpose:
prepare: performs preparative actions for those tests which need them, e.g. creating the necessary files on disk for thefileiotest, or filling the test database for OLTP tests.run: runs the actual test specified with the--testoption.cleanup: removes temporary data after the test run in those tests which create one.help: displays usage information for a test specified with the--testoption.
Also you can use sysbench help (without --test) to display the brief usage summary and the list of available test modes.
The table below lists the supported common options, their descriptions and default values:
| Option | Description | Default value |
|---|---|---|
--num-threads |
The total number of worker threads to create | 1 |
--max-requests |
Limit for total number of requests. 0 means unlimited | 10000 |
--max-time |
Limit for total execution time in seconds. 0 (default) means unlimited | 0 |
--thread-stack-size |
Size of stack for each thread | 32K |
--report-interval |
Periodically report intermediate statistics with a specified interval in seconds. Note that statistics produced by this option is per-interval rather than cumulative. 0 disables intermediate reports | 0 |
--test |
Name of the test mode to run | Required |
--debug |
Print more debug info | off |
--validate |
Perform validation of test results where possible | off |
--help |
Print help on general syntax or on a test mode specified with --test, and exit | off |
--verbosity |
Verbosity level (0 - only critical messages, 5 - debug) | 4 |
--percentile |
SysBench measures execution times for all processed requests to display statistical information like minimal, average and maximum execution time. For most benchmarks it is also useful to know a request execution time value matching some percentile (e.g. 95% percentile means we should drop 5% of the most long requests and choose the maximal value from the remaining ones). This option allows to specify a percentile rank of query execution times to count | 95 |
Note that numerical values for all size options (like --thread-stack-size in this table) may be specified by appending the corresponding multiplicative suffix (K for kilobytes, M for megabytes, G for gigabytes and T for terabytes).
Using Ubuntu 14.04 - intructions dated for 21/09/2016 (Was built on AWS in an r3.xlarge These actions were done against 0.5 checkout)
- Setup Oracleclient - https://help.ubuntu.com/community/Oracle%20Instant%20Client download from http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html. the following RPM's and upload them to the server. oracle-instantclient12.1-basic-12.1.0.2.0-1.x86_64.rpm oracle-instantclient12.1-devel-12.1.0.2.0-1.x86_64.rpm
alien -i oracle-instantclient12.1-basic-12.1.0.2.0-1.x86_64.rpm alien -i oracle-instantclient12.1-devel-12.1.0.2.0-1.x86_64.rpm
- Install Cuda - http://www.r-tutor.com/gpu-computing/cuda-installation/cuda7.5-ubuntu wget http://developer.download.nvidia.com/compute/cuda/repos/ubuntu1404/x86_64/cuda-repo-ubuntu1404_7.5-18_amd64.deb sudo dpkg -i cuda-repo-ubuntu1404_7.5-18_amd64.deb sudo apt-get update sudo apt-get install cuda export CUDA_HOME=/usr/local/cuda-7.5 export LD_LIBRARY_PATH=${CUDA_HOME}/lib64
PATH=${CUDA_HOME}/bin:${PATH} export PATH echo "/usr/lib/oracle/12.1/client64/lib" > /etc/ld.so.conf.d/oracle-client-12.1.conf ldconfig
- Login and install sys bench apt-get update apt-get -y install automake libtool git libmysqlclient15-dev make libaio1 libaio-dev git clone https://github.com/akopytov/sysbench.git cd sysbench vi configure.ac
Replace line - ORA_CFLAGS="-I${ac_cv_use_oracle}/rdbms/demo -I${ac_cv_use_oracle}/rdbms/public" With line - ORA_CFLAGS="-I${ac_cv_use_oracle}/include -I${ac_cv_use_oracle}/rdbms/demo -I${ac_cv_use_oracle}/rdbms/public" ./autogen.sh ./configure --with-oracle="/usr/lib/oracle/12.1/client64" make Run the following commands to allow sysbench use the full number of cores. sudo sh -c 'for x in /sys/class/net/eth0/queues/rx-*; do echo ffffffff> $x/rps_cpus; done' sudo sh -c "echo 32768 > /proc/sys/net/core/rps_sock_flow_entries" sudo sh -c "echo 4096 > /sys/class/net/eth0/queues/rx-0/rps_flow_cnt"