设为首页 加入收藏

TOP

数据库优化-基准测试(四)(二)
2015-11-21 01:36:33 来源: 作者: 【 】 浏览:3
Tags:数据库 优化 基准 测试
s total number of events: 262144 total time taken by event execution: 0.3994s response time: min: 0.00ms avg: 0.00ms max: 0.11ms approx. 95 percentile: 0.00ms Threads fairness: events (avg/stddev): 262144.0000/0.00 execution time (avg/stddev): 0.3994/0.00

内存OPS:
这里写图片描述
数字的谎言!
前一个测试报告在8MB块大小时读速度1.8TB/s
32MB块大小时读速度上升到7.2TB/s
恒定的OPS是真正的读瓶颈。

内存写OPS:
这里写图片描述

内存写带宽MB/S:
这里写图片描述

Sysbench 文件IO测试

IO测试包括两个阶段:

准备:在文件系统中创建文件 运行:在之前创建的文件上执行测试

支持测试的I/O模式( ?file-test-mode),包括:

seqwr : 顺序写 seqrewr : 顺序重写 seqrd : 顺序读 rndrd : 随机读 rndwr : 随机写 rndrw : 随机读/写

其它选项:

--file-num : 文件数量
--file-block-size:文件块大小
--file-total-size : 所有合并的文件
--file-io-mode : sync , async, mmap
--file-extra-flags (odirect)
--file-fsync-freq : fsync()的频率
--file-fsync-all
--file-rw-ratio : rndrw模式中的R/W比例

准备文件:

$ sysbench --test=fileio --file-num=4 --file-total-size=1G prepare
4 files, 262144Kb each, 1024Mb total
Creating files for the test...
Extra file open flags: 0
Creating file test_file.0
Creating file test_file.1
Creating file test_file.2
Creating file test_file.3
1073741824 bytes written in 40.32 seconds (25.40 MB/sec).

执行测试1(文件数1,顺序重写,文件块大小4K):

sysbench --test=fileio --file-num=1 --file-total-size=2G --file-fsync-all=on --file-test-mode=seqrewr --max-time=100 ?file-block-size=4096 --max-requests=0 run
Number of threads: 1
Extra file open flags: 0
1 files, 2Gb each
2Gb total file size
Block size 4Kb
Calling fsync() after each write operation.
Using synchronous I/O mode
Doing sequential rewrite test
Operations performed: 0 Read, 524288 Write, 524288 Other = 1048576 Total
Read 0b Written 2Gb Total transferred 2Gb (52.616Mb/sec)
13469.70 Requests/sec executed
Test execution summary:
total time: 38.9235s
total number of events: 524288
total time taken by event execution: 38.2213
per-request statistics:
min: 0.06ms
avg: 0.07ms
max: 8.60ms
approx. 95 percentile: 0.12ms

执行测试2(文件数29,随机读写,文件块大小16K):

sysbench --test=fileio --file-num=29 --file-total-size=290G --file-fsync-all=on --file-test-mode=rndrw --max-time=100 --file-block-size=16384 --max-requests=0 run
Number of threads: 1
Extra file open flags: 0
29 files, 10Gb each
290Gb total file size
Block size 16Kb
Number of random requests for random IO: 0
Read/Write ratio for combined random IO test: 1.50
Calling fsync() after each write operation.
Using synchronous I/O mode
Doing random r/w test
Operations performed: 449824 Read, 299883 Write, 299883 Other = 1049590 Total
Read 6.8638Gb Written 4.5759Gb Total transferred 11.44Gb (117.14Mb/sec)
7497.05 Requests/sec executed
Test execution summary:
total time: 100.0003s
total number of events: 749707
total time taken by event execution: 98.9223
per-request statistics:
min: 0.01ms
avg: 0.13ms
max: 7.34ms
approx. 95 percentile: 0.16ms

执行测试3(文件数29,随机读写,读写比率为4,文件块大小16K,线程数8):

sysbench --num-threads=8 --test=fileio --file-num=29 ?file-total-size=290G --file-fsync-all=on --file-test-mode=rndrw --max-time=100 --file-rw-ratio=4 --file-block-size=16384 --max-requests=0 run
Number of threads: 8
Extra file open flags: 0
29 files, 10Gb each
290Gb total file size
Block size 16Kb
Number of random requests for random IO: 0
Read/Write ratio for combined random IO test: 4.00
Calling fsync() after each write operation.
Using synchronous I/O mode
Doing random r/w test
Operations performed: 1734215 Read, 433552 Write, 433552 Other = 2601319 Total
Read 26.462Gb Written 6.61
首页 上一页 1 2 3 4 下一页 尾页 2/4/4
】【打印繁体】【投稿】【收藏】 【推荐】【举报】【评论】 【关闭】 【返回顶部
分享到: 
上一篇Redis学习笔记---字符串类型 下一篇MongoDB的master-slave及replset..

评论

帐  号: 密码: (新用户注册)
验 证 码:
表  情:
内  容: