sysbench的安装使用

yum -y install make automake libtool pkgconfig libaio-devel yum -y install mysql-devel openssl-devel unzip sysbench-master.zip ./autogen.sh./configure --with-mysql-includes=/usr/local/mysql/include --with-mysql-libs=/usr/local/mysql/libmake && make install 需要设置环境变量[root@dpcm01 sysbench-master]# sysbenchsysbench: error while loading shared libraries: libmysqlclient.so.20: cannot open shared object file: No such file or directory[root@dpcm01 sysbench-master]# echo $LD_LIBRARY_PATH [root@dpcm01 sysbench-master]# echo $LD_LIBRARY_PATH [root@dpcm01 sysbench-master]#  [root@dpcm01 sysbench-master]# export LD_LIBRARY_PATH=/usr/local/mysql/lib [root@dpcm01 sysbench-master]#  [root@dpcm01 sysbench-master]# sysbench sysbench 1.1.0 (using bundled LuaJIT 2.1.0-beta3) Reading the script from the standard input: [root@dpcm01 lua]# sysbench oltp_read_write.lua  --mysql-socket=/data/mysql/mysql.sock --mysql-user=root --mysql-host=localhost \ > --mysql-user=root --mysql-host=localhost --mysql-password=123456 --tables=10 --table_size=100000 prepare sysbench 1.1.0 (using bundled LuaJIT 2.1.0-beta3) FATAL: unable to connect to MySQL server on socket '/data/mysql/mysql.sock', aborting... FATAL: error 1049: Unknown database 'sbtest' FATAL: `sysbench.cmdline.call_command' function failed: ./oltp_common.lua:88: connection creation failed [root@dpcm01 lua]# sysbench oltp_read_write.lua  --mysql-socket=/data/mysql/mysql.sock --mysql-user=root --mysql-host=localhost --mysql-user=root --mysql-host=localhost --mysql-password=123456 --tables=10 --table_size=100000 prepare sysbench 1.1.0 (using bundled LuaJIT 2.1.0-beta3) Creating table 'sbtest1'... Inserting 100000 records into 'sbtest1' Creating a secondary index on 'sbtest1'... Creating table 'sbtest2'... Inserting 100000 records into 'sbtest2' Creating a secondary index on 'sbtest2'... Creating table 'sbtest3'... Inserting 100000 records into 'sbtest3' Creating a secondary index on 'sbtest3'... Creating table 'sbtest4'... Inserting 100000 records into 'sbtest4' Creating a secondary index on 'sbtest4'... Creating table 'sbtest5'... Inserting 100000 records into 'sbtest5' Creating a secondary index on 'sbtest5'... Creating table 'sbtest6'... Inserting 100000 records into 'sbtest6' Creating a secondary index on 'sbtest6'... Creating table 'sbtest7'... Inserting 100000 records into 'sbtest7' Creating a secondary index on 'sbtest7'... Creating table 'sbtest8'... Inserting 100000 records into 'sbtest8' Creating a secondary index on 'sbtest8'... Creating table 'sbtest9'... Inserting 100000 records into 'sbtest9' Creating a secondary index on 'sbtest9'... Creating table 'sbtest10'... Inserting 100000 records into 'sbtest10' Creating a secondary index on 'sbtest10'... [root@dpcm01 lua]# sysbench --threads=4 \ >         --time=20 \ >         --report-interval=5 \ >         --mysql-host=localhost \ >         --mysql-port=3306 \ >         --mysql-user=root \ >         --mysql-password=123456 --mysql-socket=/data/mysql/mysql.sock \ >          oltp_read_write.lua \ >         --tables=10 \ >         --table_size=100000 \ > run sysbench 1.1.0 (using bundled LuaJIT 2.1.0-beta3) Running the test with following options: Number of threads: 4 Report intermediate results every 5 second(s) Initializing random number generator from current time Initializing worker threads... Threads started! [ 5s ] thds: 4 tps: 286.08 qps: 5732.71 (r/w/o: 4013.85/1145.90/572.95) lat (ms,95%): 23.95 err/s: 0.00 reconn/s: 0.00 [ 10s ] thds: 4 tps: 337.00 qps: 6740.74 (r/w/o: 4719.55/1347.19/673.99) lat (ms,95%): 23.10 err/s: 0.00 reconn/s: 0.00 [ 15s ] thds: 4 tps: 342.04 qps: 6838.71 (r/w/o: 4786.90/1367.74/684.07) lat (ms,95%): 23.10 err/s: 0.00 reconn/s: 0.00 [ 20s ] thds: 4 tps: 344.79 qps: 6893.70 (r/w/o: 4824.79/1379.34/689.57) lat (ms,95%): 24.38 err/s: 0.00 reconn/s: 0.00 SQL statistics:     queries performed:         read:                            91756         write:                           26216         other:                           13108         total:                           131080     transactions:                        6554   (327.39 per sec.)     queries:                             131080 (6547.79 per sec.)     ignored errors:                      0      (0.00 per sec.)     reconnects:                          0      (0.00 per sec.) Throughput:     events/s (eps):                      327.3896     time elapsed:                        20.0190s     total number of events:              6554 Latency (ms):          min:                                    4.88          avg:                                   12.21          max:                                  398.72          95th percentile:                       23.95          sum:                                79998.74 Threads fairness:     events (avg/stddev):           1638.5000/9.10     execution time (avg/stddev):   19.9997/0.00