mysql for aix6.1_AIO on AIX 6.1 (文档 ID 1328019.1)

最近在AIO 6.1与SF环境中遇到了AIO的问题，下面是MOS中关于AIO 在6.1下的一般变化说明

欢迎大家加入ORACLE超级群：17115662 免费解决各种ORACLE问题,以后BLOG将迁移到http://www.htz.pw

AIO on AIX 6.1 (文档 ID 1328019.1)

修改时间:2014-5-6

类型:HOWTO

In this Document

AIO on AIX 6.1 (文档 ID 1328019.1)

修改时间:2014-5-6

类型:HOWTO

In this Document

APPLIES TO:

Oracle Server - Enterprise Edition - Version 10.2.0.4 to 11.2.0.2.0 [Release 10.2 to 11.2]

IBM AIX on POWER Systems (64-bit)

GOAL

Enabling or checking AIO on AIX 6.1 Operating System.

FIX

Customersdo not need to enable AIO subsystemon AIX 6.1 as it's a defaultoption. AIO subsystems arehandled thru AIX kernel extensions and they areloaded by default. They are also automatically started when an applicationinitiates an AIO requests.

Two new parameters (aio_active and posix_aio_active; ioo -a | grep aio) havebeen added on AIX 6.1, but they can only be changed by AIX. The value is setto 1 only when AIX kernel extensions are used and pinned.

So, the bottom line is that you don't need to do any checking on AIX 6.1. Anotherway of checking if AIO subsystems are loaded is to verify whether kernel extensions are loaded ornot. You can do that by doing "genkex | grep aio".

As an example - the following command may show:

/usr/sbin/ioo -a | grep aio

aio_active = 1

aio_maxreqs = 8192

aio_maxservers = 40

aio_minservers = 20

aio_server_inactivity = 300

posix_aio_active = 1

posix_aio_maxreqs = 65536

posix_aio_maxservers = 30

posix_aio_minservers = 3

posix_aio_server_inactivity = 300

NOTE:Please note that Oracle is not recommending changes to these parameters asthey are dynamically tuned by AIX 6.1 and values of these parameters get changed according to the server utilization.  AIX will adjust them accordingly.

APPLIES TO:

Oracle Server - Enterprise Edition - Version 10.2.0.4 to 11.2.0.2.0 [Release 10.2 to 11.2]

IBM AIX on POWER Systems (64-bit)

GOAL

Enabling or checking AIO on AIX 6.1 Operating System.

FIX

Customers do not need to enable AIO subsystem on AIX 6.1 as it's a default option. AIO subsystems are handled thru AIX kernel extensions and they are  loaded by default. They are also automatically started when an application initiates an AIO requests.

Two new parameters (aio_active and posix_aio_active; ioo -a | grep aio) have been added on AIX 6.1, but they can only be changed by AIX. The value is set to 1 only when AIX kernel extensions are used and pinned.

So, the bottom line is that you don't need to do any checking on AIX 6.1. Another way of checking if AIO subsystems are loaded is to verify whether kernel extensions are loaded or not. You can do that by doing "genkex | grep aio".

As an example - the following command may show:

/usr/sbin/ioo -a | grep aio

aio_active = 1

aio_maxreqs = 8192

aio_maxservers = 40

aio_minservers = 20

aio_server_inactivity = 300

posix_aio_active = 1

posix_aio_maxreqs = 65536

posix_aio_maxservers = 30

posix_aio_minservers = 3

posix_aio_server_inactivity = 300

NOTE:  Please note that Oracle is not recommending changes to these parameters as they are dynamically tuned by AIX 6.1 and values of these parameters get changed according to the server utilization.  AIX will adjust them accordingly.