如何安装使用sysbench

本篇文章为大家展示了如何安装使用sysbench，内容简明扼要并且容易理解，绝对能使你眼前一亮，通过这篇文章的详细介绍希望你能有所收获。

yum -y install make automake libtool pkgconfig libaio-develyum -y install mysql-devel openssl-develunzip 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]# sysbenchsysbench 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 preparesysbench 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 preparesysbench 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 \> runsysbench 1.1.0 (using bundled LuaJIT 2.1.0-beta3)Running the test with following options:Number of threads: 4Report intermediate results every 5 second(s)Initializing random number generator from current timeInitializing 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.00SQL 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:              6554Latency (ms):         min:                                    4.88         avg:                                   12.21         max:                                  398.72         95th percentile:                       23.95         sum:                                79998.74Threads fairness:    events (avg/stddev):           1638.5000/9.10    execution time (avg/stddev):   19.9997/0.00

上述内容就是如何安装使用sysbench，你们学到知识或技能了吗？如果还想学到更多技能或者丰富自己的知识储备，欢迎关注行业资讯频道。