下文主要給大家?guī)鞰ySQL基準(zhǔn)測試工具sysbench的安裝測試教程，希望這些內(nèi)容能夠帶給大家實(shí)際用處，這也是我編輯MySQL基準(zhǔn)測試工具sysbench的安裝測試教程這篇文章的主要目的。好了，廢話不多說，大家直接看下文吧。

我們提供的服務(wù)有：成都網(wǎng)站建設(shè)、成都網(wǎng)站設(shè)計(jì)、微信公眾號(hào)開發(fā)、網(wǎng)站優(yōu)化、網(wǎng)站認(rèn)證、西市ssl等。為1000多家企事業(yè)單位解決了網(wǎng)站和推廣的問題。提供周到的售前咨詢和貼心的售后服務(wù)，是有科學(xué)管理、有技術(shù)的西市網(wǎng)站制作公司

環(huán)境：CentOS6.5，MySQL5.7.22
1.下載  sysbench下載地址
2.安裝

tar -zxvf sysbench-1.1.0.tar.gz
yum install automake libtool –y  #安裝依賴包
cd sysbench-0.4.12.14
./autogen.sh
./configure --with-mysql-includes=/usr/local/mysql/include --with-mysql-libs=/usr/local/mysql/lib --with-mysql
export LD_LIBRARY_PATH=/usr/local/mysql/include #這里換成機(jī)器中mysql路徑下的include
make
make install
sysbench --version  # 檢驗(yàn)安裝是否成功

3.簡介
sysbench是跨平臺(tái)的基準(zhǔn)測試工具，支持多線程，支持多種數(shù)據(jù)庫，主要包括以下幾種測試：

• CPU性能
• 磁盤io性能
• 調(diào)度程序性能
• 內(nèi)存分配及傳輸速度
• POSIX線程性能
• 數(shù)據(jù)庫性能（基于OLTP的基本測試）
  4.sysbench語法  sysbench [options] [testname] [command]
• command sysbench要執(zhí)行的命令，包括prepare，run，cleanup。
• testname 指定要進(jìn)行的測試

• options

  • --mysql-host MySQL云服務(wù)器主機(jī)名
  • --mysql-port MySQL云服務(wù)器端口，默認(rèn)為3306
  • --mysql-user MySQL用戶名
  • --mysql-password MySQL密碼
  • --oltp-test-mode 執(zhí)行模式，默認(rèn)為complex
  • --oltp-tables-size 測試表的大小
  • --oltp-tables-count 測試表的數(shù)量
  • --threads 客戶端的并發(fā)連接
  • --time 測試執(zhí)行的時(shí)間
    5.測試實(shí)例
• CPU測試
  • --cpu-max-prime=N upper limit for primes generator [10000]

    sysbench   --cpu-max-prime=20000 --report-interval=10

• fileio測試
  *4個(gè)線程，隨機(jī)讀寫，每10s輸出一次結(jié)果

  [root@slave1 sysbench-master]# sysbench fileio  help
  sysbench 1.1.0 (using bundled LuaJIT 2.1.0-beta3)
  fileio options:
  --file-num=N          number of files to create [128]  #需要?jiǎng)?chuàng)建的文件數(shù)，默認(rèn)為128
  --file-block-size=N      block size to use in all IO operations [16384]
  --file-total-size=SIZE     total size of files to create [2G]  創(chuàng)建的文件總大小
  --file-test-mode=STRING    test mode {seqwr, seqrewr, seqrd, rndrd, rndwr, rndrw}  #讀寫方式
  --file-io-mode=STRING     file operations mode {sync,async,mmap} [sync] # 文件操作模式{sync(同步),async(異步),fastmmap(快速map映射),slowmmap(慢map映射)}。默認(rèn)是sync
  --file-async-backlog=N     number of asynchronous operatons to queue per thread [128] 
  --file-extra-flags=[LIST,...] list of additional flags to use to open files {sync,dsync,direct} []  #使用額外的標(biāo)志來打開文件{sync,dsync,direct} 。默認(rèn)為空
  --file-fsync-freq=N      do fsync() after this number of requests (0 - don't use fsync()) [100]
  --file-fsync-all[=on|off]   do fsync() after each write operation [off]
  --file-fsync-end[=on|off]   do fsync() at the end of test [on]
  --file-fsync-mode=STRING    which method to use for synchronization {fsync, fdatasync} [fsync]  #使用哪種方法進(jìn)行同步{fsync, fdatasync}。默認(rèn)是fsync
  --file-merged-requests=N    merge at most this number of IO requests if possible (0 - don't merge) [0] #如果可以，合并最多的IO請求數(shù)(0–表示不合并)。默認(rèn)是0
  --file-rw-ratio=N       reads/writes ratio for combined test [1.5] #測試時(shí)的讀寫比例。默認(rèn)是1.5

[root@slave1 sysbench-master]# sysbench --threads=4 --file-test-mode=rndwr --report-interval=10 fileio prepare  #準(zhǔn)備階段
[root@slave1 sysbench-master]# sysbench --threads=4 --time=60 --report-interval=10 --file-test-mode=rndrw fileio 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 10 second(s)
Initializing random number generator from current time

Extra file open flags: (none)
128 files, 16MiB each
2GiB total file size
Block size 16KiB
Number of IO requests: 0
Read/Write ratio for combined random IO test: 1.50
Periodic FSYNC enabled, calling fsync() each 100 requests.
Calling fsync() at the end of test, Enabled.
Using synchronous I/O mode
Doing random r/w test
Initializing worker threads...

Threads started!

[ 10s ] reads: 3.65 MiB/s writes: 2.44 MiB/s fsyncs: 494.49/s latency (ms,95%): 30.265
[ 20s ] reads: 3.00 MiB/s writes: 2.00 MiB/s fsyncs: 412.60/s latency (ms,95%): 34.954
[ 30s ] reads: 3.28 MiB/s writes: 2.19 MiB/s fsyncs: 444.19/s latency (ms,95%): 35.589
[ 40s ] reads: 3.19 MiB/s writes: 2.13 MiB/s fsyncs: 434.41/s latency (ms,95%): 38.247
[ 50s ] reads: 3.00 MiB/s writes: 2.00 MiB/s fsyncs: 410.90/s latency (ms,95%): 37.565
[ 60s ] reads: 3.09 MiB/s writes: 2.06 MiB/s fsyncs: 419.19/s latency (ms,95%): 35.589

Throughput:
     read:  IOPS=204.22 3.19 MiB/s (3.35 MB/s)
     write: IOPS=136.15 2.13 MiB/s (2.23 MB/s)
     fsync: IOPS=442.70

Latency (ms):
     min:                  0.00
     avg:                  5.14
     max:                 310.70
     95th percentile:           35.59
     sum:               239996.51

[root@slave1 sysbench-master]# sysbench --threads=4 --time=60 --report-interval=10 --file-test-mode=rndrw fileio cleanup  #清理文件
sysbench 1.1.0 (using bundled LuaJIT 2.1.0-beta3)

Removing test files...

• 內(nèi)存測試
  • 測試4個(gè)線程，60秒，每10秒輸出一次報(bào)告信息，總內(nèi)存大小100G，隨機(jī)訪問模式

[root@slave1 sysbench-master]# sysbench --threads=4 --time=60 --report-interval=10 --memory-total-size=100G --memory-access-mode=rnd memory 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 10 second(s)
Initializing random number generator from current time

Running memory speed test with the following options:
  block size: 1KiB
  total size: 102400MiB
  operation: write
  scope: global

Initializing worker threads...

Threads started!

[ 10s ] 671.96 MiB/sec
[ 20s ] 672.65 MiB/sec
[ 30s ] 667.18 MiB/sec
[ 40s ] 675.73 MiB/sec
[ 50s ] 676.82 MiB/sec
Total operations: 41341475 (689021.00 per second)

40372.53 MiB transferred (672.87 MiB/sec)

Throughput:
   events/s (eps):            689021.0010
   time elapsed:             60.0003s
   total number of events:        41341475

Latency (ms):
     min:                   0.00
     avg:                   0.01
     max:                  20.25
     95th percentile:             0.00
     sum:                218390.97

Threads fairness:
   events (avg/stddev):      10335368.7500/59009.67
   execution time (avg/stddev):  54.5977/0.14

• MySQL測試
  • 壓測實(shí)例，4張表，每張表10W條記錄，壓測120秒

sysbench --db-driver=mysql --time=120 --threads=4 --report-interval=10 --mysql-host=localhost --mysql-port=2433 --mysql-socket=/data/mysqldata/mysql.sock --mysql-user=7roaddba --mysql-password=y%6bm@3o_q1a --mysql-db=inc --tables=4 --table-size=100000 oltp_read_write prepare  ##準(zhǔn)備

sysbench  --db-driver=mysql --time=120 --threads=4 --report-interval=10 --mysql-host=localhost --mysql-port=3306 --mysql-socket=/data/mysqldata/mysql.sock --mysql-user=7roaddba --mysql-password=y%6bm@3o_q1a --mysql-db=inc --tables=4 --table-size=100000 oltp_read_write 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 10 second(s)
Initializing random number generator from current time

Initializing worker threads...

Threads started!

[ 10s ] thds: 4 tps: 111.37 qps: 2233.72 (r/w/o: 1564.69/445.88/223.14) lat (ms,95%): 101.13 err/s: 0.00 reconn/s: 0.00
[ 20s ] thds: 4 tps: 197.50 qps: 3950.22 (r/w/o: 2764.42/790.80/395.00) lat (ms,95%): 44.98 err/s: 0.00 reconn/s: 0.00
[ 30s ] thds: 4 tps: 211.10 qps: 4222.06 (r/w/o: 2955.87/843.99/422.20) lat (ms,95%): 44.17 err/s: 0.00 reconn/s: 0.00
[ 40s ] thds: 4 tps: 213.70 qps: 4272.79 (r/w/o: 2991.39/854.00/427.40) lat (ms,95%): 43.39 err/s: 0.00 reconn/s: 0.00
[ 50s ] thds: 4 tps: 211.80 qps: 4239.27 (r/w/o: 2967.15/848.41/423.71) lat (ms,95%): 43.39 err/s: 0.10 reconn/s: 0.00
[ 60s ] thds: 4 tps: 223.10 qps: 4459.15 (r/w/o: 3121.36/891.59/446.19) lat (ms,95%): 41.85 err/s: 0.00 reconn/s: 0.00
[ 70s ] thds: 4 tps: 190.40 qps: 3811.24 (r/w/o: 2667.73/762.71/380.80) lat (ms,95%): 45.79 err/s: 0.00 reconn/s: 0.00
[ 80s ] thds: 4 tps: 183.00 qps: 3660.05 (r/w/o: 2561.97/732.09/366.00) lat (ms,95%): 43.39 err/s: 0.00 reconn/s: 0.00
[ 90s ] thds: 4 tps: 211.60 qps: 4226.63 (r/w/o: 2958.32/845.11/423.20) lat (ms,95%): 44.17 err/s: 0.00 reconn/s: 0.00
[ 100s ] thds: 4 tps: 213.30 qps: 4272.92 (r/w/o: 2991.64/854.58/426.69) lat (ms,95%): 39.65 err/s: 0.10 reconn/s: 0.00
[ 110s ] thds: 4 tps: 212.51 qps: 4249.12 (r/w/o: 2974.88/849.22/425.01) lat (ms,95%): 41.10 err/s: 0.00 reconn/s: 0.00
[ 120s ] thds: 4 tps: 183.00 qps: 3660.19 (r/w/o: 2561.80/732.40/366.00) lat (ms,95%): 51.94 err/s: 0.00 reconn/s: 0.00
SQL statistics:
   queries performed:
     read:               330820  #總select數(shù)量
     write:              94513  # 總update，insert，delete數(shù)量
     other:              47258 ##commit，unlock tables 數(shù)量
     total:              472591
   transactions:             23628  (196.88 per sec.)  #通常需要關(guān)注的數(shù)字(TPS)
   queries:               472591 (3937.94 per sec.) #
   ignored errors:            2    (0.02 per sec.) # 忽略的錯(cuò)誤數(shù)
   reconnects:              0    (0.00 per sec.)

Throughput:
   events/s (eps):            196.8840
   time elapsed:             120.0098s
   total number of events:        23628  #總的事件數(shù)

Latency (ms):
     min:                   6.03
     avg:                  20.31
     max:                  847.12
     95th percentile:            44.98
     sum:                479909.87

Threads fairness:
   events (avg/stddev):      5907.0000/60.54
   execution time (avg/stddev):  119.9775/0.00
對于以上關(guān)于MySQL基準(zhǔn)測試工具sysbench的安裝測試教程，大家是不是覺得非常有幫助。如果需要了解更多內(nèi)容，請繼續(xù)關(guān)注我們的行業(yè)資訊，相信你會(huì)喜歡上這些內(nèi)容的。

另外有需要云服務(wù)器可以了解下創(chuàng)新互聯(lián)cdcxhl.cn，海內(nèi)外云服務(wù)器15元起步，三天無理由+7*72小時(shí)售后在線，公司持有idc許可證，提供“云服務(wù)器、裸金屬服務(wù)器、高防服務(wù)器、香港服務(wù)器、美國服務(wù)器、虛擬主機(jī)、免備案服務(wù)器”等云主機(jī)租用服務(wù)以及企業(yè)上云的綜合解決方案，具有“安全穩(wěn)定、簡單易用、服務(wù)可用性高、性價(jià)比高”等特點(diǎn)與優(yōu)勢，專為企業(yè)上云打造定制，能夠滿足用戶豐富、多元化的應(yīng)用場景需求。

分享題目：MySQL基準(zhǔn)測試工具sysbench的安裝測試教程-創(chuàng)新互聯(lián)
網(wǎng)址分享：http://weahome.cn/article/disejo.html