溫馨提示×
您好，登錄后才能下訂單哦！
點擊 登錄注冊 即表示同意《億速云用戶服務條款》
您好，登錄后才能下訂單哦！
本篇文章為大家展示了如何安裝使用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，你們學到知識或技能了嗎？如果還想學到更多技能或者豐富自己的知識儲備，歡迎關注億速云行業資訊頻道。
免責聲明：本站發布的內容（圖片、視頻和文字）以原創、轉載和分享為主，文章觀點不代表本網站立場，如果涉及侵權請聯系站長郵箱：is@yisu.com進行舉報，并提供相關證據，一經查實，將立刻刪除涉嫌侵權內容。
