13518219792
本篇文章为大家展示了如何安装使用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/lib make && make install
需要设置环境变量
[root@dpcm01 sysbench-master]# sysbench sysbench: 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
上述内容就是如何安装使用sysbench，你们学到知识或技能了吗？如果还想学到更多技能或者丰富自己的知识储备，欢迎关注创新互联-成都网站建设公司行业资讯频道。
