Chinaunix首页 | 论坛 | 博客
  • 博客访问: 338009
  • 博文数量: 62
  • 博客积分: 0
  • 博客等级: 民兵
  • 技术积分: 710
  • 用 户 组: 普通用户
  • 注册时间: 2013-05-14 14:12
个人简介

太懒

文章分类

全部博文(62)

文章存档

2015年(8)

2014年(20)

2013年(34)

我的朋友

分类: Oracle

2013-05-30 16:52:13

介绍及下载地址:

ORION (Oracle I/O Calibration Tool) 是校准用于 Oracle 数据库的存储系统 I/O 性能的独立工具。校准结果对于了解存储系统的性能有很大帮助,不仅可以找出影响 Oracle 数据库性能的问题,还能测量新数据库安装的大小。由于 ORION 是一个独立工具,用户不需要创建和运行 Oracle 数据库。
为了尽可能地模拟 Oracle 数据库,ORION 使用和 Oracle 相同的 I/O 软件集生成一个合成的 I/O 负载。可以将 ORION 配置为生成很多 I/O 负载,包括一个模拟 OLTP 和数据仓库负载的 I/O 负载。
ORION 支持多种平台。将来还会增加对更多平台的支持。用户指南提供详细的使用文档,包括“入门”部分和疑难解答提示。在 ORION 中调用“-help”选项可以直接获取关于如何使用 ORION 的摘要。

支持的平台:

image

操作系统是 Oracle Linux 6.4 i386的,下载好x86版,只有十几M大小。

下载完以后上传服务器上

orion_linux_x86.gz

[root@my2950 software]# cd IO_Test_Tool/
[root@my2950 IO_Test_Tool]# ls
orion_linux_x86.gz
[root@my2950 IO_Test_Tool]#
[root@my2950 IO_Test_Tool]#
[root@my2950 IO_Test_Tool]# ll
total 11624
-rw-r--r-- 1 root root 11901381 May 30 10:17 orion_linux_x86.gz
[root@my2950 IO_Test_Tool]#
[root@my2950 IO_Test_Tool]# gunzip orion_linux_x86.gz
[root@my2950 IO_Test_Tool]# ls
orion_linux_x86
[root@my2950 IO_Test_Tool]#
[root@my2950 IO_Test_Tool]#
[root@my2950 IO_Test_Tool]# ls -l
total 37256
-rw-r--r-- 1 root root 38148082 May 30 10:17 orion_linux_x86
[root@my2950 IO_Test_Tool]#

本目录已经通过nfs共享给了node1和node2

转到node1

[root@node1 IO_Test_Tool]# cd /nfs/IO_Test_Tool
[root@node1 IO_Test_Tool]# ls -al
total 37260
drwxr-xr-x 2 oracle oinstall       28 May 30 10:18 .
drwxr-xr-x 6 oracle oinstall     4096 May 30 10:16 ..
-rw-r--r-- 1 oracle oinstall 38148082 May 30 10:17 orion_linux_x86
[root@node1 IO_Test_Tool]#

先测试一下本地硬盘的IO性能

[root@node1 IO_Test_Tool]# lvcreate -L 50G -n testio datavg
  Logical volume "testio" created
[root@node1 IO_Test_Tool]# lvdisplay /dev/datavg/testio
  --- Logical volume ---
  LV Path                /dev/datavg/testio
  LV Name                testio
  VG Name                datavg
  LV UUID                0H4VIQ-L3yR-q2a5-MnzO-QLDP-slh8-7zfCcb
  LV Write Access        read/write
  LV Creation host, time node1, 2013-05-30 14:02:01 +0800
  LV Status              available
  # open                 0
  LV Size                50.00 GiB
  Current LE             1600
  Segments               1
  Allocation             inherit
  Read ahead sectors     auto
  - currently set to     256
  Block device           252:3

[root@node1 IO_Test_Tool]#

建立node1的mytest.lun文件

[root@node1 ~]# mkdir -p /root/orion
[root@node1 ~]# cp /nfs/IO_Test_Tool/orion_linux_x86 /root/orion/

[root@node1 ~]# cd /root/orion/
[root@node1 orion]#

[root@node1 orion]# vi mytest.lun
[root@node1 orion]# more mytest.lun
/dev/datavg/testio

[root@node1 orion]#

[root@node1 orion]# ls -al
total 37268
drwxr-xr-x  2 root root     4096 May 30 14:09 .
dr-xr-x---. 3 root root     4096 May 30 14:08 ..
-rw-r--r--  1 root root       20 May 30 14:09 mytest.lun
-rwxr-xr-x  1 root root 38148082 May 30 14:11 orion_linux_x86
[root@node1 orion]#

测试1:

[root@node1 orion]# ./orion_linux_x86 -run simple -testname mytest -num_disks 1

通过iostat观察

Device:         rrqm/s   wrqm/s     r/s     w/s   rsec/s   wsec/s avgrq-sz avgqu-sz   await  svctm  %util
sdb               0.00     0.00  129.50    0.00  2072.00     0.00    16.00     1.99   15.32   7.72 100.00
sda               0.00     0.00    0.00    0.00     0.00     0.00     0.00     0.00    0.00   0.00   0.00
dm-0              0.00     0.00    0.00    0.00     0.00     0.00     0.00     0.00    0.00   0.00   0.00
dm-1              0.00     0.00    0.00    0.00     0.00     0.00     0.00     0.00    0.00   0.00   0.00
dm-2              0.00     0.00    0.00    0.00     0.00     0.00     0.00     0.00    0.00   0.00   0.00
dm-3              0.00     0.00  129.50    0.00  2072.00     0.00    16.00     1.99   15.32   7.72 100.00

Device:            tps   Blk_read/s   Blk_wrtn/s   Blk_read   Blk_wrtn
sdb             127.00      2032.00         0.00       4064          0
sda               0.00         0.00         0.00          0          0
dm-0              0.00         0.00         0.00          0          0
dm-1              0.00         0.00         0.00          0          0
dm-2              0.00         0.00         0.00          0          0
dm-3            127.00      2032.00         0.00       4064          0

[root@node1 ~]# iostat -d -m 2
Linux 2.6.39-400.17.1.el6uek.i686 (node1)       05/30/2013      _i686_  (2 CPU)

Device:            tps    MB_read/s    MB_wrtn/s    MB_read    MB_wrtn
sdb              27.23         0.52         0.12       1423        319
sda               0.54         0.00         0.00          5          0
dm-0             17.19         0.16         0.12        433        317
dm-1              0.13         0.00         0.00          0          1
dm-2              0.07         0.00         0.00          0          0
dm-3             14.25         0.36         0.00        987          0

Device:            tps    MB_read/s    MB_wrtn/s    MB_read    MB_wrtn
sdb             122.00        61.00         0.00        122          0
sda               0.00         0.00         0.00          0          0
dm-0              0.00         0.00         0.00          0          0
dm-1              0.00         0.00         0.00          0          0
dm-2              0.00         0.00         0.00          0          0
dm-3            122.00        61.00         0.00        122          0

Device:            tps    MB_read/s    MB_wrtn/s    MB_read    MB_wrtn
sdb             120.50        60.25         0.00        120          0
sda               0.00         0.00         0.00          0          0
dm-0              0.00         0.00         0.00          0          0
dm-1              0.00         0.00         0.00          0          0
dm-2              0.00         0.00         0.00          0          0
dm-3            121.00        60.50         0.00        121          0

Device:            tps    MB_read/s    MB_wrtn/s    MB_read    MB_wrtn
sdb             121.00        60.50         0.00        121          0
sda               0.00         0.00         0.00          0          0
dm-0              0.00         0.00         0.00          0          0
dm-1              0.00         0.00         0.00          0          0
dm-2              0.00         0.00         0.00          0          0
dm-3            121.00        60.50         0.00        121          0

^C
[root@node1 ~]#

tps基本稳定在120左右

测试结束以后

[root@node1 orion]# ./orion_linux_x86 -run simple -testname mytest -num_disks 1
ORION: ORacle IO Numbers -- Version 11.1.0.7.0
mytest_20130530_1415
Test will take approximately 9 minutes
Larger caches may take longer

[root@node1 orion]# ll
total 37280
-rw-r--r-- 1 root root      128 May 30 14:22 mytest_20130530_1415_iops.csv
-rw-r--r-- 1 root root      128 May 30 14:22 mytest_20130530_1415_lat.csv
-rw-r--r-- 1 root root      100 May 30 14:22 mytest_20130530_1415_mbps.csv
-rw-r--r-- 1 root root      596 May 30 14:22 mytest_20130530_1415_summary.txt
-rw-r--r-- 1 root root     2916 May 30 14:22 mytest_20130530_1415_trace.txt
-rw-r--r-- 1 root root       20 May 30 14:09 mytest.lun
-rwxr-xr-x 1 root root 38148082 May 30 14:11 orion_linux_x86
[root@node1 orion]#

新生成的文件:

mytest_20130530_1415_iops.csv          IOPS的能力,1,2,3,4,5分别代表并发数

mytest_20130530_1415_mbps.csv        IO吞吐量,单位:MB/每秒

mytest_20130530_1415_lat.csv            表示每个IO的延时,1,2,3,4,5分别代表并发数

mytest_20130530_1415_summary.txt    摘要

mytest_20130530_1415_trace.txt          跟踪

 

mytest_20130530_1415_iops.csv   

image

mytest_20130530_1415_mbps.csv     

mytest_20130530_1415_lat.csv       

mytest_20130530_1415_summary.txt    摘要

mytest_20130530_1415_trace.txt          跟踪

mbps: Comma-separated value file containing the data transfer rate(MBPS)  results for the Large Random/Sequential workload.

iops:     Comma-separated value file containing the I/O throughput(in IOPS) results for the Small Random workload.

lat:       Comma-separated value file containing the latency results for the Small Random workload.

trace:   Contains extended, unprocessed test output.

看一下概要文件

ORION VERSION 11.1.0.7.0

Commandline:
-run simple -testname mytest -num_disks 1

This maps to this test:
Test: mytest
Small IO size: 8 KB
Large IO size: 1024 KB
IO Types: Small Random IOs, Large Random IOs
Simulated Array Type: CONCAT
Write: 0%
Cache Size: Not Entered
Duration for each Data Point: 60 seconds
Small Columns:,      0
Large Columns:,      0,      1,      2
Total Data Points: 8

Name: /dev/datavg/testio    Size: 53687091200
1 FILEs found.

Maximum Large MBPS=61.40 @ Small=0 and Large=2
Maximum Small IOPS=127 @ Small=5 and Large=0
Minimum Small Latency=7.97 @ Small=1 and Large=0

测试2:

[root@node1 orion]# ./orion_linux_x86 -run oltp -testname mytest -num_disks 1
ORION: ORacle IO Numbers -- Version 11.1.0.7.0
mytest_20130530_1538
Test will take approximately 22 minutes
Larger caches may take longer

摘要:

ORION VERSION 11.1.0.7.0

Commandline:
-run oltp -testname mytest -num_disks 1

This maps to this test:
Test: mytest
Small IO size: 8 KB
Large IO size: 1024 KB
IO Types: Small Random IOs, Large Random IOs
Simulated Array Type: CONCAT
Write: 0%
Cache Size: Not Entered
Duration for each Data Point: 60 seconds
Small Columns:,      1,      2,      3,      4,      5,      6,      7,      8,      9,     10,     11,     12,     13,     14,     15,     16,     17,     18,     19,     20
Large Columns:,      0
Total Data Points: 21

Name: /dev/datavg/testio    Size: 53687091200
1 FILEs found.

Maximum Small IOPS=154 @ Small=20 and Large=0
Minimum Small Latency=7.93 @ Small=1 and Large=0

IOPS:

image

latency图:

image

MBPS: 空白

image

测试3:

数据库OLTP类型,假定IO类型全部是8K随机操作,压力类型,自动加压,从小到大,一直到存储压力极限

./orion_linux_x86 -run advanced -testname mytest -num_disks 1 -size_small 8 -size_large 8 -type rand

[root@node1 orion]# ./orion_linux_x86 -run advanced -testname mytest -num_disks 1 -size_small 8 -size_large 8 -type rand
ORION: ORacle IO Numbers -- Version 11.1.0.7.0
mytest_20130530_1518
Test will take approximately 9 minutes
Larger caches may take longer

[root@node1 orion]#

摘要:

ORION VERSION 11.1.0.7.0

Commandline:
-run advanced -testname mytest -num_disks 1 -size_small 8 -size_large 8 -type rand

This maps to this test:
Test: mytest
Small IO size: 8 KB
Large IO size: 8 KB
IO Types: Small Random IOs, Large Random IOs
Simulated Array Type: CONCAT
Write: 0%
Cache Size: Not Entered
Duration for each Data Point: 60 seconds
Small Columns:,      0
Large Columns:,      0,      1,      2
Total Data Points: 8

Name: /dev/datavg/testio    Size: 53687091200
1 FILEs found.

Maximum Large MBPS=0.98 @ Small=0 and Large=1
Maximum Small IOPS=128 @ Small=5 and Large=0
Minimum Small Latency=8.00 @ Small=1 and Large=0

IOPS图:

image 

latency图:

image

MBPS 只有两个值,都是0.98

IO最大吞吐量只有0.9M/s,iops稳定状态达到128左右,而Latency在并发Load Level5左右的时候达到38.87ms

另一个节点测试结果:

[root@node2 orgin]# ./orion_linux_x86 -run advanced -testname mytest -num_disks 1 -size_small 8 -size_large 8 -type rand
ORION: ORacle IO Numbers -- Version 11.1.0.7.0
mytest_20130530_1624
Test will take approximately 9 minutes
Larger caches may take longer

[root@node2 orgin]#

ORION VERSION 11.1.0.7.0

Commandline:
-run advanced -testname mytest -num_disks 1 -size_small 8 -size_large 8 -type rand

This maps to this test:
Test: mytest
Small IO size: 8 KB
Large IO size: 8 KB
IO Types: Small Random IOs, Large Random IOs
Simulated Array Type: CONCAT
Write: 0%
Cache Size: Not Entered
Duration for each Data Point: 60 seconds
Small Columns:,      0
Large Columns:,      0,      1,      2
Total Data Points: 8

Name: /dev/datavg/iotest    Size: 53687091200
1 FILEs found.

Maximum Large MBPS=1.28 @ Small=0 and Large=2
Maximum Small IOPS=192 @ Small=5 and Large=0
Minimum Small Latency=7.01 @ Small=1 and Large=0

IOPS:

image

MBPS:

image

Latency:

image

ISCSI盘测试

[root@node2 orgin]# ./orion_linux_x86 -run advanced -testname iscsi -num_disks 1 -size_small 8 -size_large 8 -type rand
ORION: ORacle IO Numbers -- Version 11.1.0.7.0
iscsi_20130530_1651
Test will take approximately 9 minutes
Larger caches may take longer

[root@node2 orgin]#

ORION VERSION 11.1.0.7.0

Commandline:
-run advanced -testname iscsi -num_disks 1 -size_small 8 -size_large 8 -type rand

This maps to this test:
Test: iscsi
Small IO size: 8 KB
Large IO size: 8 KB
IO Types: Small Random IOs, Large Random IOs
Simulated Array Type: CONCAT
Write: 0%
Cache Size: Not Entered
Duration for each Data Point: 60 seconds
Small Columns:,      0
Large Columns:,      0,      1,      2
Total Data Points: 8

Name: /dev/asm-diskf    Size: 2147483648
1 FILEs found.

Maximum Large MBPS=1.50 @ Small=0 and Large=2
Maximum Small IOPS=161 @ Small=5 and Large=0
Minimum Small Latency=9.37 @ Small=1 and Large=0

IOPS:

image

MBPS:

image

Latency:

image

 

阅读(4125) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~