Solved

Aix ioo vmo

Posted on 2012-03-30
6
840 Views
Last Modified: 2012-06-21
I'm wondering what would these parameters do for performance in AIX

2. " ioo -o maxpgahead=256 " to set maxpgahead parameter
Initial settings were : Min/Maxpgahead 2 16

3. " vmo -o minfree=360 -o maxfree=1128 " to set minfree and maxfree...
Initial settings were : Min/Maxfree 240 256
0
Comment
Question by:it-rex
  • 3
  • 3
6 Comments
 
LVL 68

Accepted Solution

by:
woolmilkporc earned 500 total points
ID: 37787454
This is from ioo help:
Help for tunable minpgahead:
Purpose:
Specifies the number of pages with which sequential read-ahead starts.
Values:
        Default: 2
        Range: 0, 1, 2, 4, 8, 16, 32, 64, 128, 256, 512, 1024, 2048, 4096
        Type: Dynamic
        Unit: 4KB pages
Tuning:
The value must be a power of two. Observe the elapsed execution time of critical sequential-I/O-dependent applications with time command. Useful to increase if there are lots of large sequential accesses. Observe other applications to ensure that their performance has not deteriorated. Value of 0 may be useful if I/O pattern is purely random.
Help for tunable maxpgahead:
Purpose:
Specifies the maximum number of pages to be read ahead when processing a sequentially accessed file.
Values:
        Default: 8
        Range: 0, 1, 2, 4, 8, 16, 32, 64, 128, 256, 512, 1024, 2048, 4096
        Type: Dynamic
        Unit: 4KB pages
Tuning:
The value must be a power of two and should be greater than or equal to minpgahead. Observe the elapsed execution time of critical sequential-I/O-dependent applications with the time command. Because of limitations in the kernel, do not exceed 512 as the maximum value used. The difference between minfree and maxfree should always be equal to or greater than maxpgahead. If execution time decreases with higher maxpgahead, observe other applications to ensure that their performance has not deteriorated.

This is from vmo help:
Help for tunable minfree:
Purpose:
Specifies the number of frames on the free list at which the VMM starts to steal pages to replenish the free list.
Values:
        Default: 960
        Range: 8 - 838860
        Type: Dynamic
        Unit: 4KB pages
Tuning:
Page replacement occurs when the number of free frames reaches minfree. If processes are being delayed by page stealing, increase minfree to improve response time. The difference between maxfree and minfree should be of the order of maxpgahead, and no less than 8.
Help for tunable maxfree:
Purpose:
Specifies the number of frames on the free list at which page-stealing is to stop.
Values:
        Default: 1088
        Range: 16 - 838860
        Type: Dynamic
        Unit: 4KB pages
Tuning:
Observe free-list-size changes with vmstat n. If vmstat n shows free-list size frequently driven below minfree by application demands, increase maxfree to reduce calls to replenish the free list. Setting the value too high causes page replacement to run for a longer period of time. The difference between maxfree and minfree should be of the order of maxpgahead, and no less than 8.

I think the above should give you a good start.

By the way, get help for individual tunables with:

ioo|nfso|no|raso|vmo -h tunable_name

wmp
0
 
LVL 11

Author Comment

by:it-rex
ID: 37787486
Do we have scattered reads in Aix like we have sequential ones?

In Aix what does scattered and sequential reads mean? And when they happen?
0
 
LVL 68

Expert Comment

by:woolmilkporc
ID: 37787581
Scattered read is not an OS phenomenon and has thus no relation to AIX.

Such reads are basically sequential ones, the only difference being that the application (e.g. Oracle) would scatter the blocks read across multiple discontiguous memory regions (e.g. in the Oracle SGA) either for performance improvement purposes or because there's no contiguous memory area available to hold the data.

The OS and its I/O subsystem as well as the physical disks just see the underlying sequential multiblock read operations.

When, why and how scattered reads take place is fully application-specific.
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 11

Author Comment

by:it-rex
ID: 37787739
What would you Prefer for these values?
0
 
LVL 68

Expert Comment

by:woolmilkporc
ID: 37787865
Increase maxpgahead and minpgahead if you're experiencing lots of large sequential I/Os.
Determining the amount of sequential reads is a real hard task when using just OS tools.
Your application (database) should have far better information.

Don't execeed 512 for maxpgahead, however.

The default of 2/16 is often too low, particularly when running large-scale reports against big databases.
Consider 64/256 (or 16/256 if there is a considerable amount of random reads as well, or 16/128 if you're short on memory), but please keep an attentive eye on the effects.

Observe the rules given in the help text, particularly those concerning minfree/maxfree:
"The difference between minfree and maxfree should always be equal to or greater than maxpgahead."

I'd suggest leaving minfree at the default of 960. Add your setting of maxpghead to obtain the value for maxfree, with my suggestion of 256 you should consequently set maxfree to at least 960+256=1216.

Again, keep an eye on the effects!
0
 
LVL 11

Author Closing Comment

by:it-rex
ID: 37794172
Thanks a ton!
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
dbms_crypto.decrypt   errors out 6 40
Expiration and Locking of Unix/Solaris OS Accounts 7 63
Creation date for a PDB 5 60
Oracle function to insert records? 15 61
Why Shell Scripting? Shell scripting is a powerful method of accessing UNIX systems and it is very flexible. Shell scripts are required when we want to execute a sequence of commands in Unix flavored operating systems. “Shell” is the command line i…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

680 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question