Introduction to the use of MySQL performance stress benchmark tool sysbench

1. Introduction to sysbench

Here we introduce a MySQL database stress testing software sysbench, which is used for benchmark testing.

Sysbench is an open source, modular, cross-platform multi-threaded performance testing tool.

It can be used to perform performance tests on CPU, memory, disk I/O, threads, and databases.

Currently supported databases are MySQL, Oracle and PostgreSQL.

#Project download address:

https://launchpad.net/sysbench
http://github.com/akopytov/sysbench

The idea of ​​this benchmark suite is to quickly get an impression of system performance without having to set up a complex database benchmark or even having a database installed.
The current functionality allows testing of the following system parameters:

• #CPU Performance
• file I/O performance #File IO performance, disk IO performance
• scheduler performance
• memory allocation and transfer speed
• POSIX threads implementation performance
• database server performance (OLTP benchmark)
  

Sysbench's oltp is mainly used to evaluate and test the database load under various system parameters.
Compared with version 0.4, the subsequent versions of oltp testing mainly combine lua scripts. There is no need to modify the source code. Testing of different business types can be achieved through custom lua scripts.

Disadvantages of SysBench:
The simulated table structure is too simple, not as complete a transaction system as tpcc-mysql, but it is still very useful for MySQL performance stress testing comparison.

2. Sysbench installation process

#Install related dependencies

mount /dev/cdrom /mnt
yum -y install make automake libtool pkgconfig libaio-devel libtool

# Installation process starts

#Make a link to the client lib package ln -sf /mysql/app/mysql/lib/libmysqlclient.so.20 /usr/lib/libmysqlclient.so.20
#Unzip and install cd /softtar zxvf sysbench-1.0.15.tar.gz cd sysbench-1.0.15./autogen.sh
./configure --prefix=/mysql/app/sysbench --with-mysql=/mysql/app/mysql --with-mysql-includes=/mysql/app/mysql/include/
#--with-mysql-libs=/usr/lib/
make && make install
#Configure environment variables vi ~/.bash_profile
PATH=$PATH:/mysql/app/sysbench/bin:$HOME/bin
source ~/.bash_profile
sysbench --version
#If an error message is reported, sysbench: error while loading shared libraries: libmysqlclient.so.20: cannot open shared object file: No such file or directory

#Then add the line /usr/lib to /etc/ld.so.cnf [root@tse01 local]# cat /etc/ld.so.conf
include ld.so.conf.d/*.conf
/usr/lib/
#Execute ldconfig -v to update the configuration [root@tse01 local]# /sbin/ldconfig -v

# Tips:

If you installed the MySQL header files and libraries in nonstandard locations (no mysql_config can be found in PATH),

You can specify the --with-mysql-includes and --with-mysql-libs option arguments explicitly, as above.

To compile sysbench without MySQL support, use --without-mysql.
If no database driver is available, database-related scripts will not work, but other benchmarks will work.

#General command line options

The following table lists the supported common options, their descriptions and default values:

Note that you can specify a byte by appending the corresponding multiplication suffix (K for kilobytes, M for megabytes, G for gigabytes, T for terabytes).
to specify values ​​for all size options (--thread-stack-size as shown in this table).

#sysbench uses [command] commonly used are:

1) prepare for testing and generate data
2) Run the test
3) cleanup cleans up data
4) help
5) version

The above is the detailed introduction to the use of MySQL performance stress benchmark testing tool sysbench. For more information on the use of MySQL sysbench, please pay attention to other related articles on 123WORDPRESS.COM!