Installation and performance testing of sysbench-0.5

Sysbench is a modular, cross-platform, multi-threaded benchmarking tool designed to evaluate the load of databases under different system parameters .

This includes testing in several ways:
1. CPU Performance
2. Disk IO performance
3. Scheduling Program Performance
4. Memory allocation and transmission speed
5. POSIX threading Performance
6. Database performance (OLTP benchmark)

First, installation :

TAR-ZXVF sysbench-0.5.tar.gz-c/mnt

cd/mnt/sysbench-0.5

chmod +x autogen.sh

[Email protected] sysbench-0.5]#./autogen.sh

The error:

Libtoolize 1.4+ wasn ' t found, exiting

Install dependency Package:: Yum install Libtool

#./configure--prefix=/usr/local/sysbench--with-mysql-includes=/usr/local/mysql-5.6.25-linux-glibc2.5-x86_ 64/include--with-mysql-libs=/usr/local/mysql-5.6.25-linux-glibc2.5-x86_64/lib

# Make && make install

#cp/usr/local/sysbench/bin/sysbench/usr/bin/

# #sysbench--help

If the error:

Sysbench:error while loading shared libraries:libmysqlclient.so.18:cannot open Shared object file:no such file or dire Ctory

Sysbench:error while loading shared libraries:libmysqlclient.so.18:cannot open Shared object file:no such file or dire Ctory problem Reason: Sysbench unable to find the MySQL library file, the environment variable ld_library_path is not set, can be set to resolve the problem: add Export ld_library_path=/usr/local/ Mysql-5.6.25-linux-glibc2.5-x86_64/lib can

# # #其他测试略

# # #MySQL测试:

sysbench --test=./tests/db/oltp.lua --mysql-table-engine=myisam --oltp-table-size=100000 - -mysql-db=test --mysql-user=dlan --oltp-tables-count=10 --mysql-password=root123 -- Mysql-socket=/tmp/mysql.sock prepare  sysbench --test=./tests/db/parallel_prepare.lua   --mysql-table-engine=myisam --oltp-table-size=100000  --num-threads=10 -- mysql-db=test  --mysql-user=dlan --oltp-tables-count=10 --mysql-password=root123 -- mysql-socket=/tmp/mysql.sock run ## #参数详解  prepare     Generate tables and insert data, you can use Parallel_ Prepare.lua the script to prepare the data in parallel.     –db-driver  server type  mysql | drizzle, default is mysql    – mysql-table-engine  table Memory engine     –myisam-max-rows myisam table Max_Rows options (for large tables)      –oltp-table-count  Generate table Count [Sbtest1, Sbtest2 ...]     –oltp-table-size  number of rows generated for the table  &NBsp;  –oltp-secondary id column generates a level two index instead of a primary key     –oltp-auto-inc  set ID column is self-increment   On | off, default is on

This article is from the "DBSpace" blog, so be sure to keep this source http://dbspace.blog.51cto.com/6873717/1871112

Installation and performance testing of sysbench-0.5