共計 4234 個字符，預計需要花費 11 分鐘才能閱讀完成。
本篇文章為大家展示了如何安裝使用 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，你們學到知識或技能了嗎？如果還想學到更多技能或者豐富自己的知識儲備，歡迎關注丸趣 TV 行業資訊頻道。
正文完
