Io testing software-Orion

Author: Piner original address:Http://www.ixdba.com/html/y2007/m06/125-orion-storage-test.html

Orion,OracleProvided by the company, it is used to simulate the database operation mechanism to test the excellent storage performance.IoStore the test software.OracleSimulate random OLTP operations (TestIops) Or OLAP continuous operations (test throughput ).

First look at the softwareAnd description:

Orion isOracleI/O numbers calibration tool designed to simulateOracleI/O workloads
-Without having to create and runOracleDatabase
-UsingOracleDatabase's I/O Libraries
-Using small I/OS to simulate OLTP workloads
-Using large I/OS to simulate Data Warehouses
Orion is useful for understanding the performance capabilities of a storage system, either to uncover performance issues or to size a new database installation.
The users guide contains a getting started Section, detailed usage documentation, and trouble-shooting tips. Please note that Orion is not supportedOracle.
Download the files:
· Orion_aix64.gz (11,670,726 bytes)
· Orion_solaris64_sparc.gz (898,929 bytes)
· Orion_solaris_x8664.gz (655,975 bytes)
· Orion_linux_em64t.gz (767,380 bytes)
· Orion10.2_linux.gz (630,354 bytes)
· Orion10. 2_windows.msi (7,865,856 bytes)
· Users guide
As you can see, this software already supports multiple OS environments. Unfortunately,OracleIt does not provide service support for the software. However, this does not affect the normal use of the software. From my test results, the software is really a good storage test software.

The downloaded software has been compiled separately and can be run in the OS environment without any compilation. This is much better than many stress testing software that needs to be re-compiled, it is much more convenient, for example, running in the decompressed directory in the AIX environment. /Orion-help, you can see the Detailed Help of the software.

The software supports three running modes.

Simple: small random testIo(8 K by default) and largeIo(1024 kb by default). This method is useful for running the software for the first time or for a general understanding of basic storage features.

Normal: you can combine differentIoType, but cannot be customizedIoSize

Advanced: supports multiple advanced options, suchIoSize, pressure size,IoType, test method, etc.

And two different stress Methods

Typical OLTP environment: small randomIo, The maximum value supported by the test storageIopsAnd Response Time

Typical OLAP environment: large orderIoTo test the maximum throughput and response time supported by storage.

Only one configuration file <testname>. Lun is required to run the software. The disk information required for testing is configured, and the following information is returned:

<Testname> _iops.csv: for different pressure typesIopsValue

<Testname> _mbps.csv: throughput of different pressure types

<Testname> _lat.csv: Response Time under different pressure types

<Testname> _summary.txt: test result summary

I am running Load Runner +OracleSimulating database activities and only running the software to simulate database activities can clearly find the advantages of the software:

1. Do not need to run Load Runner and configure a large number of clinet

2. No need to runOracleDatabase and prepare a large amount of test data

3. More representative test results, such as randomIoDuring the test, the software can make the storage hit rate close to 0, and simulate the real DiskIopsWhile Load Runner is hard to do this, the final diskIopsTo be converted.

4. You can customize a certain proportion of write operations as needed (no write operations by default). However, note that if data exists on the disk, be careful when overwriting the data.

Of course, it also has its shortcomings.

1. Up to now, the custom overall running time and pressurization range cannot be specified. Here it is completely automatic

2. You cannot perform custom operation types, such as table scan and load testing.OracleDatabase Combination to achieve this effect

Below, I will give a few specific examples to illustrate their operations.

1. Database OLTP type, assumingIoAll types are 8 K random operation, pressure type, automatic pressurization, from small to large, up to the storage pressure limit

# Nohup./Orion-run advanced-testname mytest-num_disks 96-size_small 8-size_large 8-type Rand &

2. Database throughput test, assumingIoAll are 1 m sequencesIo

# Nohup./Orion-run advanced-testname mytest-num_disks 96-size_small 1024-size_large 1024-type seq &

3. Specify a specificIoType andIoStress, such as smallIoWhen the pressure is 500IoUnder Pressure

# Nohup./Orion-run advanced-testname mytest-num_disks 96-size_small 8-size_large 128-matrix col-num_small 500-type Rand &

4. Combining differentIoType, test pressure Matrix

# Nohup./Orion-run advanced-testname mytest-num_disks 96-size_small 8-size_large 128-matrix detailed-type Rand &

Because the test results are CSV files, you can easily draw a pressure curve in excle based on the results. For example, a stored stress test is drawn based on the Orion test results.IopsResponse time table:

The horizontal axis is the response time, and the vertical axis isIopsValue, indicating thatIopsIn this caseIoThe average response time.