欧美一区二区三区老妇人-欧美做爰猛烈大尺度电-99久久夜色精品国产亚洲a-亚洲福利视频一区二区

Sysbench基準(zhǔn)測試的示例分析

這篇文章給大家分享的是有關(guān)Sysbench基準(zhǔn)測試的示例分析的內(nèi)容。小編覺得挺實(shí)用的，因此分享給大家做個參考，一起跟隨小編過來看看吧。

創(chuàng)新互聯(lián)公司專業(yè)為企業(yè)提供漢陰網(wǎng)站建設(shè)、漢陰做網(wǎng)站、漢陰網(wǎng)站設(shè)計、漢陰網(wǎng)站制作等企業(yè)網(wǎng)站建設(shè)、網(wǎng)頁設(shè)計與制作、漢陰企業(yè)網(wǎng)站模板建站服務(wù)，10多年漢陰做網(wǎng)站經(jīng)驗(yàn)，不只是建網(wǎng)站，更提供有價值的思路和整體網(wǎng)絡(luò)服務(wù)。

Sysbench和TPCC-MySQL一樣,也是一款基準(zhǔn)測試的工具。

TPCC-MySQL
http://blog.itpub.net/29254281/viewspace-1195589/

相對于TPCC-MySQL,Sysbench不僅可以對MySQL，也可以對Oracle,PostgreSQL進(jìn)行基準(zhǔn)測試。

源碼下載地址:
https://launchpad.net/sysbench

先下載依賴包
yum install automake autoconf -y

運(yùn)行./configure && make 命令,可能有以下的報錯
../libtool: line 5172: : command not found
修改configure.ac文件
Sysbench基準(zhǔn)測試的示例分析

將LIBTOOL注釋,并增加AC_PROG_RANLIB
Sysbench基準(zhǔn)測試的示例分析

修改之后運(yùn)行如下命令
./autogen.sh && ./configure && make
完成之后，進(jìn)入sysbench文件夾,可以看到sysbench命令已經(jīng)編譯完成。

1.進(jìn)行文件IO測試
準(zhǔn)備文件
Sysbench基準(zhǔn)測試的示例分析
進(jìn)行基準(zhǔn)測試

  1. [root@mysql1 sysbench]# ./sysbench --test=fileio --file-total-size=2G --file-test-mode=rndrw --file-num=16 --num-threads=16 run

  2. sysbench 0.4.12:  multi-threaded system evaluation benchmark

  4. Running the test with following options:

  5. Number of threads: 16

  7. Extra file open flags: 0

  8. 16 files, 128Mb each

  9. 2Gb total file size

  10. Block size 16Kb

  11. Number of random requests for random IO: 10000

  12. Read/Write ratio for combined random IO test: 1.50

  13. Periodic FSYNC enabled, calling fsync() each 100 requests.

  14. Calling fsync() at the end of test, Enabled.

  15. Using synchronous I/O mode

  16. Doing random r/w test

  17. Threads started!

  18. Done.

  20. Operations performed:  6006 Read, 3996 Write, 1600 Other = 11602 Total

  21. Read 93.844Mb  Written 62.438Mb  Total transferred 156.28Mb  (2.1231Mb/sec)

  22. 135.88 Requests/sec executed

  24. Test execution summary:

  25. total time:                          73.6086s

  26. total number of events:              10002

  27. total time taken by event execution: 602.0152

  28. per-request statistics:

  29. min:                                  0.01ms

  30. avg:                                 60.19ms

  31. max:                               1587.11ms

  32. approx.  95 percentile:             290.98ms

  34. Threads fairness:

  35. events (avg/stddev):           625.1250/42.01

  36. execution time (avg/stddev):   37.6259/2.94

其中主要參數(shù)和默認(rèn)值
  --file-num=N                     創(chuàng)建測試的文件數(shù)量 [128]
  --file-block-size=N             塊的尺寸,默認(rèn)是16K 用于測試Oracle一般改為8K[16384]        
  --file-total-size=SIZE         所有測試文件總的大小[2G]
  --file-test-mode=STRING   測試模式 seqwr(順序?qū)?, seqrewr(順序讀寫), seqrd(順序讀), rndrd(隨機(jī)讀), rndwr(隨機(jī)寫), rndrw(隨機(jī)讀寫)
  --file-io-mode=STRING      文件操作模式 sync(同步),async(異步),fastmmap,slowmmap(兩種內(nèi)存映射模式) [sync]
  --file-rw-ratio=N                測試時的讀寫比例  [1.5]

  --file-async-backlog=N        number of asynchronous operatons to queue per thread [128]
  --file-extra-flags=STRING     additional flags to use on opening files {sync,dsync,direct} []
  --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]
  --file-merged-requests=N      merge at most this number of IO requests if possible (0 - don't merge) [0]
 
測試完成之后清理生成的文件
[root@mysql1 sysbench]# ./sysbench --test=fileio --file-num=16 --file-total-size=2G cleanup
sysbench 0.4.12:  multi-threaded system evaluation benchmark
Removing test files...

如果出現(xiàn)如下錯誤,則需要注意 指定的file-num能夠被file-total-size 整除
FATAL: Too large position discovered in request!

2.進(jìn)行CPU基準(zhǔn)測試
[root@mysql1 sysbench]# ./sysbench --test=cpu --num-threads=16 run
sysbench 0.4.12:  multi-threaded system evaluation benchmark
Running the test with following options:
Number of threads: 16
Doing CPU performance benchmark
Threads started!
Done.
Maximum prime number checked in CPU test: 10000
Test execution summary:
    total time:                          2.5106s
    total number of events:              10000
    total time taken by event execution: 39.3201
    per-request statistics:
         min:                                  0.30ms
         avg:                                  3.93ms
         max:                                 43.80ms
         approx.  95 percentile:              15.07ms

Threads fairness:
    events (avg/stddev):           625.0000/50.60
    execution time (avg/stddev):   2.4575/0.03

3.OLTP基準(zhǔn)測試
進(jìn)行準(zhǔn)備
[root@mysql1 sysbench]# ./sysbench --test=oltp --mysql-table-engine=innodb --oltp-table-size=1000000 --mysql-host=127.0.0.1 --mysql-user=xx --mysql-password=xx --mysql-socket=/home/lihuilin/mysql-5.6.14/mysql.sock  --num-threads=15  prepare
sysbench 0.4.12:  multi-threaded system evaluation benchmark

No DB drivers specified, using mysql
Creating table 'sbtest'...
Creating 1000000 records in table 'sbtest'...

然后進(jìn)行測試
[root@mysql1 sysbench]# ./sysbench --test=oltp --mysql-table-engine=innodb --oltp-table-size=1000000 --mysql-host=127.0.0.1 --mysql-user=xx --mysql-password=xx --mysql-socket=/home/lihuilin/mysql-5.6.14/mysql.sock  --num-threads=15  run
sysbench 0.4.12:  multi-threaded system evaluation benchmark

No DB drivers specified, using mysql
Running the test with following options:
Number of threads: 15

Doing OLTP test.
Running mixed OLTP test
Using Special distribution (12 iterations,  1 pct of values are returned in 75 pct cases)
Using "BEGIN" for starting transactions
Using auto_inc on the id column
Maximum number of requests for OLTP test is limited to 10000
Threads started!
Done.

OLTP test statistics:
    queries performed:
        read:                            140000
        write:                           50000
        other:                           20000
        total:                           210000
    transactions:                        10000  (502.61 per sec.)
    deadlocks:                           0      (0.00 per sec.)
    read/write requests:                 190000 (9549.53 per sec.)
    other operations:                    20000  (1005.21 per sec.)

Test execution summary:
    total time:                          19.8963s
    total number of events:              10000
    total time taken by event execution: 298.1265
    per-request statistics:
         min:                                 11.62ms
         avg:                                 29.81ms
         max:                                185.70ms
         approx.  95 percentile:              42.60ms

Threads fairness:
    events (avg/stddev):           666.6667/5.69
    execution time (avg/stddev):   19.8751/0.01

相對于TPCC-MySQL，sysbench的測試結(jié)果非常直觀, 一目了然

感謝各位的閱讀！關(guān)于“Sysbench基準(zhǔn)測試的示例分析”這篇文章就分享到這里了，希望以上內(nèi)容可以對大家有一定的幫助，讓大家可以學(xué)到更多知識，如果覺得文章不錯，可以把它分享出去讓更多的人看到吧！

分享標(biāo)題：Sysbench基準(zhǔn)測試的示例分析
標(biāo)題來源：http://www.chinadenli.net/article16/jogogg.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供網(wǎng)站排名、做網(wǎng)站、網(wǎng)站設(shè)計公司、網(wǎng)站制作、手機(jī)網(wǎng)站建設(shè)、網(wǎng)站收錄

廣告

聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請盡快告知，我們將會在第一時間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場，如需處理請聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時需注明來源： 創(chuàng)新互聯(lián)

h5響應(yīng)式網(wǎng)站建設(shè)