上一次使用DBMS_RESOURCE_MANAGER.CALIBRATE_IO存储过程来对oracle RAC进行了 测试,然后达梦厂商用的自己工具测试,两边的结果值不匹配,io性能方面达梦数据库达不到迁移条件,于是这次两边都使用fio工具来进行测试,测试io块大小设置为32k,以下实验为自己的测试环境。
1.检查fio工具是否安装
rpm –qa|grep fio
2.安装fio工具
2.1使用yum安装
yum install fio
2.2使用rpm安装
下载地址:https://pkgs.org/download/fio
wget http://mirror.centos.org/centos/7/os/x86_64/Packages/fio-3.7-2.el7.x86_64.rpm
安装rpm包依赖
需要安装部分依赖
yum install libaio-devel
yum install libibverbs -y
yum install libpmem -y
yum install librados2 -y
yum install librbd1
rpm -ivh fio-3.7-2.el7.x86_64.rpm
3.测试是否安装
fio
rpm –qa|grep fio
4.测试磁盘io
我的ASM磁盘对应os磁盘为sdb,sdc,sdd,sde,sdf,向这5个分区存储上随机读写100s时间
参数解释(略)
4.1单线程任务随机读写
fio -filename=/dev/sdb:/dev/sdc:/dev/sdd:/dev/sde:/dev/sdf -direct=1 -iodepth 1 -thread -rw=randrw -ioengine=psync -bs=32k -size=50G -numjobs=1 -runtime=100 -group_reporting -name=test
结果
Run status group 0 (all jobs):
READ: bw=42.1MiB/s (44.2MB/s), 42.1MiB/s-42.1MiB/s (44.2MB/s-44.2MB/s), io=4211MiB (4416MB), run=100001-100001msec
WRITE: bw=42.2MiB/s (44.2MB/s), 42.2MiB/s-42.2MiB/s (44.2MB/s-44.2MB/s), io=4216MiB (4421MB), run=100001-100001msecDisk stats (read/write):
sdb: ios=27196/27340, merge=0/0, ticks=7917/12470, in_queue=20371, util=20.36%
sdc: ios=27129/26793, merge=0/0, ticks=6515/11961, in_queue=18463, util=18.50%
sdd: ios=27080/26875, merge=0/0, ticks=4526/11231, in_queue=15744, util=15.75%
sde: ios=27049/26873, merge=0/0, ticks=4790/11476, in_queue=16258, util=16.29%
sdf: ios=26838/27115, merge=0/0, ticks=5909/12354, in_queue=18255, util=18.29%
4.2多线程任务随机读写
fio -filename=/dev/sdb:/dev/sdc:/dev/sdd:/dev/sde:/dev/sdf -direct=1 -iodepth 1 -thread -rw=randrw -ioengine=psync -bs=32k -size=50G -numjobs=10 -runtime=100 -group_reporting -name=test
结果
Run status group 0 (all jobs):
READ: bw=78.5MiB/s (82.3MB/s), 78.5MiB/s-78.5MiB/s (82.3MB/s-82.3MB/s), io=7855MiB (8236MB), run=100046-100046msec
WRITE: bw=78.5MiB/s (82.3MB/s), 78.5MiB/s-78.5MiB/s (82.3MB/s-82.3MB/s), io=7854MiB (8235MB), run=100046-100046msecDisk stats (read/write):
sdb: ios=50628/50496, merge=0/0, ticks=39977/36885, in_queue=76688, util=52.20%
sdc: ios=50100/50418, merge=0/0, ticks=37034/36980, in_queue=73829, util=51.46%
sdd: ios=50614/49904, merge=0/0, ticks=32364/33068, in_queue=65272, util=48.77%
sde: ios=50534/49947, merge=0/0, ticks=33319/33239, in_queue=66332, util=48.84%
sdf: ios=50008/50506, merge=0/0, ticks=35082/35578, in_queue=70520, util=50.36%
就这样吧 搞一搞交差了。。。