共計 9209 個字符，預計需要花費 24 分鐘才能閱讀完成。
如何進行 sysbench 測試，很多新手對此不是很清楚，為了幫助大家解決這個難題，下面丸趣 TV 小編將為大家詳細講解，有這方面需求的人可以來學習下，希望你能有所收獲。
sysbench 支持以下幾種測試模式：
1、CPU 運算性能
2、磁盤 IO 性能
3、調度程序性能
4、內存分配及傳輸速度
5、POSIX 線程性能
6、數據庫性能 (OLTP 基準測試)
sysbench 版本：
[root@127-0-0-1 sysbench]# /u01/opt/sysbench/bin/sysbench –version
sysbench 1.1.0
CPU 測試：
[root@127-0-0-1 sysbench]# /u01/opt/sysbench/bin/sysbench cpu –cpu-max-prime=10000 run
sysbench 1.1.0 (using bundled LuaJIT 2.1.0-beta3)
Running the test with following options:
Number of threads: 1
Initializing random number generator from current time
Prime numbers limit: 10000
Initializing worker threads…
Threads started!
CPU speed:
events per second: 658.31
Throughput:
events/s (eps): 658.3125
time elapsed: 10.0013s
total number of events: 6584
Latency (ms):
min: 1.44
avg: 1.52
max: 3.07
95th percentile: 1.52
sum: 9998.21
Threads fairness:
events (avg/stddev): 6584.0000/0.00
execution time (avg/stddev): 9.9982/0.00
線程測試：
[root@127-0-0-1 sysbench]# /u01/opt/sysbench/bin/sysbench threads help
sysbench 1.1.0 (using bundled LuaJIT 2.1.0-beta3)
threads options:
–thread-yields=N number of yields to do per request [1000] # 每個請求要執行的收益效率 [1000]
–thread-locks=N number of locks per thread [8] #每個線程的鎖數 [8][root@127-0-0-1 sysbench]# /u01/opt/sysbench/bin/sysbench threads –thread-yields=1000 –thread-locks=2 run
sysbench 1.1.0 (using bundled LuaJIT 2.1.0-beta3)
Running the test with following options:
Number of threads: 1
Initializing random number generator from current time
Initializing worker threads…
Threads started!
Throughput:
events/s (eps): 1349.6979
time elapsed: 10.0008s
total number of events: 13498
Latency (ms):
min: 0.73
avg: 0.74
max: 1.50
95th percentile: 0.74
sum: 9996.37
Threads fairness:
events (avg/stddev): 13498.0000/0.00
execution time (avg/stddev): 9.9964/0.00
磁盤 IO 測試：
[root@127-0-0-1 sysbench]# /u01/opt/sysbench/bin/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] #代表生成文件的數量 [128]
–file-block-size=N block size to use in all IO operations [16384] #在所有 IO 操作中使用的塊大小 [16384]
–file-total-size=SIZE total size of files to create [2G] # 要創建的文件的總大小 [2G]
–file-test-mode=STRING test mode {seqwr, seqrewr, seqrd, rndrd, rndwr, rndrw} # 測試模式 {seqwr, seqrewr, seqrd, rndrd, rndwr, rndrw}
–file-io-mode=STRING file operations mode {sync,async,mmap} [sync] # 文件操作模式 {sync,async,mmap} [sync]
–file-async-backlog=N number of asynchronous operatons to queue per thread [128] # 每個線程要排隊的異步操作數 [128]
–file-extra-flags=[LIST,…] list of additional flags to use to open files {sync,dsync,direct} [] #用于打開文件的附加標志列表 {sync,dsync,direct} []
–file-fsync-freq=N do fsync() after this number of requests (0 – don t use fsync()) [100] #執行 fsync() 函數的頻率。fsync 主要是同步磁盤文件，因為可能有系統和磁盤緩沖的關系。0 代表不使用 fsync 函數。默認值為 100。
–file-fsync-all[=on|off] do fsync() after each write operation [off] # 每執行完一次寫操作，就執行一次 fsync。默認為 off。
–file-fsync-end[=on|off] do fsync() at the end of test [on] # 在測試結束時執行 fsync 函數。默認為 on。
–file-fsync-mode=STRING which method to use for synchronization {fsync, fdatasync} [fsync] #文件同步函數的選擇，同樣是和 API 相關的參數，由于多個操作系統對于 fdatasync 支持不同，因此不建議使用 fdatasync。默認為 fsync。
–file-merged-requests=N merge at most this number of IO requests if possible (0 – don t merge) [0] # 大多情況下，合并可能的 IO 的請求數，默認為 0。
–file-rw-ratio=N reads/writes ratio for combined test [1.5] # 測試時的讀寫比例，默認時為 1.5，即可 3：2。
/u01/opt/sysbench/bin/sysbench fileio –threads=16 –file-total-size=2G –file-test-mode=rndrw prepare #準備
/u01/opt/sysbench/bin/sysbench fileio –threads=16 –file-total-size=2G –file-fsync-freq=0 –file-test-mode=rndrw run # 運行
/u01/opt/sysbench/bin/sysbench fileio –threads=16 –file-total-size=2G –file-test-mode=rndrw cleanup #清理
[root@127-0-0-1 yoon]# /u01/opt/sysbench/bin/sysbench fileio –threads=16 –file-total-size=2G –file-fsync-freq=0 –file-test-mode=rndrw run
sysbench 1.1.0 (using bundled LuaJIT 2.1.0-beta3)
Running the test with following options:
Number of threads: 16
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
Calling fsync() at the end of test, Enabled.
Using synchronous I/O mode
Doing random r/w test
Initializing worker threads…
Threads started!
Throughput:
read: IOPS=383594.04 5993.66 MiB/s (6284.80 MB/s)
write: IOPS=255729.12 3995.77 MiB/s (4189.87 MB/s)
fsync: IOPS=122.71
Latency (ms):
min: 0.00
avg: 0.01
max: 1.73
95th percentile: 0.03
sum: 144444.71
內存測試：
[root@127-0-0-1 yoon]# /u01/opt/sysbench/bin/sysbench memory help
sysbench 1.1.0 (using bundled LuaJIT 2.1.0-beta3)
memory options:
–memory-block-size=SIZE size of memory block for test [1K] # 測試內存塊的大小 [1K]
–memory-total-size=SIZE total size of data to transfer [100G] #要傳輸的數據的總大小 100G]
–memory-scope=STRING memory access scope {global,local} [global] #內存訪問范圍 {global,local} [global]
–memory-hugetlb[=on|off] allocate memory from HugeTLB pool [off] #從內存池中分配內存 [off]
–memory-oper=STRING type of memory operations {read, write, none} [write] #存儲操作類型 {read, write, none} [write]
–memory-access-mode=STRING memory access mode {seq,rnd} [seq] #存儲器存取方式 {seq,rnd} [seq][root@127-0-0-1 yoon]# /u01/opt/sysbench/bin/sysbench memory –memory-total-size=10G –memory-block-size=8K run
sysbench 1.1.0 (using bundled LuaJIT 2.1.0-beta3)
Running the test with following options:
Number of threads: 1
Initializing random number generator from current time
Running memory speed test with the following options:
block size: 8KiB
total size: 10240MiB
operation: write
scope: global
Initializing worker threads…
Threads started!
Total operations: 1310720 (1077326.35 per second)
10240.00 MiB transferred (8416.61 MiB/sec)
Throughput:
events/s (eps): 1077326.3489
time elapsed: 1.2166s
total number of events: 1310720
Latency (ms):
min: 0.00
avg: 0.00
max: 0.02
95th percentile: 0.00
sum: 893.01
Threads fairness:
events (avg/stddev): 1310720.0000/0.00
execution time (avg/stddev): 0.8930/0.00
OLTP 測試：
[root@127-0-0-1 sysbench]# ls
bulk_insert.lua oltp_delete.lua oltp_point_select.lua oltp_read_write.lua oltp_update_non_index.lua prepare.log select_random_ranges.lua
oltp_common.lua oltp_insert.lua oltp_read_only.lua oltp_update_index.lua oltp_write_only.lua select_random_points.lua tests
/u01/opt/sysbench/bin/sysbench /u01/opt/sysbench/share/sysbench/oltp_common.lua –mysql-host=127.0.0.1 –mysql-port=3306 –mysql-user=root –mysql-password= root@01.com –mysql-db=sbtest –table-size=5000000 –threads=10 –report-interval=10 prepare
[root@127-0-0-1 sysbench]# /u01/opt/sysbench/bin/sysbench /u01/opt/sysbench/share/sysbench/oltp_read_write.lua –mysql-host=127.0.0.1 –mysql-port=3306 –mysql-user=root –mysql-password= root@01.com –mysql-db=sbtest –table-size=5000000 –threads=10 –report-interval=10 –time=120 run
sysbench 1.1.0 (using bundled LuaJIT 2.1.0-beta3)
Running the test with following options:
Number of threads: 10
Report intermediate results every 10 second(s)
Initializing random number generator from current time
Initializing worker threads…
Threads started!
[10s] thds: 10 tps: 824.26 qps: 16498.17 (r/w/o: 11550.29/3298.36/1649.53) lat (ms,95%): 16.71 err/s: 0.00 reconn/s: 0.00
[20s] thds: 10 tps: 938.90 qps: 18778.84 (r/w/o: 13146.36/3754.69/1877.79) lat (ms,95%): 13.95 err/s: 0.00 reconn/s: 0.00
[30s] thds: 10 tps: 969.19 qps: 19383.22 (r/w/o: 13568.10/3876.74/1938.37) lat (ms,95%): 13.70 err/s: 0.00 reconn/s: 0.00
[40s] thds: 10 tps: 1003.32 qps: 20061.71 (r/w/o: 14042.19/4012.88/2006.64) lat (ms,95%): 13.22 err/s: 0.00 reconn/s: 0.00
[50s] thds: 10 tps: 1011.57 qps: 20236.34 (r/w/o: 14166.91/4046.29/2023.14) lat (ms,95%): 13.22 err/s: 0.00 reconn/s: 0.00
[60s] thds: 10 tps: 1115.50 qps: 22309.32 (r/w/o: 15615.94/4462.38/2230.99) lat (ms,95%): 11.87 err/s: 0.00 reconn/s: 0.00
[70s] thds: 10 tps: 1064.13 qps: 21283.06 (r/w/o: 14898.46/4256.33/2128.27) lat (ms,95%): 12.30 err/s: 0.00 reconn/s: 0.00
[80s] thds: 10 tps: 1030.00 qps: 20599.45 (r/w/o: 14419.27/4120.19/2060.00) lat (ms,95%): 12.52 err/s: 0.00 reconn/s: 0.00
[90s] thds: 10 tps: 1056.32 qps: 21127.75 (r/w/o: 14790.22/4224.89/2112.65) lat (ms,95%): 12.30 err/s: 0.00 reconn/s: 0.00
[100s] thds: 10 tps: 1097.38 qps: 21946.72 (r/w/o: 15362.43/4389.52/2194.76) lat (ms,95%): 12.30 err/s: 0.00 reconn/s: 0.00
[110s] thds: 10 tps: 1147.39 qps: 22948.97 (r/w/o: 16063.71/4590.47/2294.79) lat (ms,95%): 11.87 err/s: 0.00 reconn/s: 0.00
[120s] thds: 10 tps: 1110.00 qps: 22200.00 (r/w/o: 15540.00/4440.00/2220.00) lat (ms,95%): 12.08 err/s: 0.00 reconn/s: 0.00
SQL statistics:
queries performed:
read: 1731702
write: 494772
other: 247386
total: 2473860
transactions: 123693 (1030.70 per sec.)
queries: 2473860 (20614.02 per sec.)
ignored errors: 0 (0.00 per sec.)
reconnects: 0 (0.00 per sec.)
Throughput:
events/s (eps): 1030.7010
time elapsed: 120.0086s
total number of events: 123693
Latency (ms):
min: 4.32
avg: 9.70
max: 185.38
95th percentile: 13.22
sum: 1199649.68
Threads fairness:
events (avg/stddev): 12369.3000/304.67
execution time (avg/stddev): 119.9650/0.00
看完上述內容是否對您有幫助呢？如果還想對相關知識有進一步的了解或閱讀更多相關文章，請關注丸趣 TV 行業資訊頻道，感謝您對丸趣 TV 的支持。
