修改aix操作系统参数maxclient%和maxperm%的一点记录
- WBOYOriginal
- 2016-06-07 16:11:162914browse
关于aix操作系统的参数maxclient%和maxperm%，有很多帖子有论述。包括白鳝的 《oracle优化日记--一个金牌DBA的故事》中也有论述，大概在书中的165到166页。具体我也记不清了。 该参数主要是限制了aix filesysemcache 使用（或者说直接占用）os 物理内存的比
关于aix操作系统的参数maxclient%和maxperm%，有很多帖子有论述。包括白鳝的 《oracle优化日记--一个金牌DBA的故事》中也有论述，大概在书中的165到166页。具体我也记不清了。
该参数主要是限制了aix filesysemcache 使用（或者说直接占用）os 物理内存的比例。
# vmo -a -F
ame_cpus_per_pool = 8
ame_maxfree_mem = 0
ame_min_ucpool_size = 0
ame_minfree_mem = 0
ams_loan_policy = n/a
force_relalias_lite = 0
kernel_heap_psize = 4096
lgpg_regions = 0
lgpg_size = 0
low_ps_handling = 1
maxfree = 1088
maxperm = 1494126
maxpin = 1402196
maxpin% = 80
memory_frames = 1736704
memplace_data = 2
memplace_mapped_file = 2
memplace_shm_anonymous = 2
memplace_shm_named = 2
memplace_stack = 2
memplace_text = 2
memplace_unmapped_file = 2
minfree = 960
minperm = 49803
minperm% = 3
nokilluid = 0
npskill = 16384
npswarn = 65536
numpsblks = 2097152
pinnable_frames = 1291242
relalias_percentage = 0
scrub = 0
v_pinshm = 0
vmm_default_pspa = -1
wlm_memlimit_nonpg = 1
##受限可调参数
ame_sys_memview = 0
cpu_scale_memp = 8
data_stagger_interval = 161
defps = 1
framesets = 2
htabscale = n/a
kernel_psize = 4096
large_page_heap_size = 0
lru_file_repage = 0
lru_poll_interval = 10
lrubucket = 131072
maxclient% = 90 <-------注意此行
maxperm% = 90 <-------注意此行
mbuf_heap_psize = 4096
memory_affinity = 1
npsrpgmax = 131072
npsrpgmin = 98304
npsscrubmax = 131072
npsscrubmin = 98304
num_spec_dataseg = 0
page_steal_method = 1
psm_timeout_interval = 5000
rpgclean = 0
rpgcontrol = 2
scrubclean = 0
soft_min_lgpgs_vmpool = 0
spec_dataseg_int = 512
strict_maxclient = 1
strict_maxperm = 0
vm_modlist_threshold = -1
vmm_fork_policy = 1
vmm_mpsize_support = 2
vmm_vmap_policy = 0
# vmo -p -o maxclient%=20
修改受限可调参数 maxclient%，需要确认 y/n y
正在 nextboot 文件中将 maxclient% 设置为 20
正在将 maxclient% 设置为 20
警告：已更改受限可调参数
# nmon
lqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq
x ------------------------------
x N N M M OOOO N N For online help type: h
x NN N MM MM O O NN N For command line option help:
x N N N M MM M O O N N N quick-hint nmon -?
x N N N M M O O N N N full-details nmon -h
x N NN M M O O N NN To start nmon the same way every time?
x N N M M OOOO N N set NMON ksh variable, for example:
x ------------------------------ export NMON=cmt
x TOPAS_NMON
x 8 - CPUs currently
x 8 - CPUs configured
x 1504 - MHz CPU clock rate
x PowerPC_POWER5 - Processor
x 64 bit - Hardware
x 64 bit - Kernel
x 1,65-7858E - Logical Partition
x 6.1.4.1 TL04 - AIX Kernel Version
x oradb1 - Hostname
x oradb1 - Node/WPAR Name
x 657858E - Serial Number
x IBM,9117-570 - Machine Type
lqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq
lqtopas_nmonqqh=HelpqqqqqqqqqqqqqHost=oradb1qqqqqqqqqRefresh=2 secsqqq14:50.26qqqqqqqqqqqqqqqqqqqqqqqqqq
x Memory qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq
x Physical PageSpace | pages/sec In Out | FileSystemCache
x% Used 79.4% 10.3% | to Paging Space 0.0 0.0 | (numperm) 19.0% <-------注意此行
x% Free 20.6% 89.7% | to File System 30550.3 10.4| Process 34.7%
xMB Used 5384.6MB 840.5MB | Page Scans 148325.4 | System 25.7%
xMB Free 1399.4MB 7351.5MB | Page Cycles 0.0 | Free 20.6%
xTotal(MB) 6784.0MB 8192.0MB | Page Steals 30414.7 | ------
x | Page Faults 1106.8 | Total 100.0%
x------------------------------------------------------------ | numclient 19.0%
xMin/Maxperm 195MB( 3%) 5836MB( 86%) <--% of RAM | maxclient 19.1%
xMin/Maxfree 960 1088 Total Virtual 14.6GB | User 50.0%
xMin/Maxpgahead 2 8 Accessed Virtual 4.4GB 30.1%| Pinned 25.7%
xqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq
注意上面倒数第三行中的： 5836MB( 86%) <--% of RAM <-------注意此行
# vmo -p -o maxperm%=20 <-------注意此行
修改受限可调参数 maxperm%，需要确认 y/n y
正在 nextboot 文件中将 maxperm% 设置为 20
正在将 maxperm% 设置为 20
警告：已更改受限可调参数
# nmon
lqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq
x ------------------------------
x N N M M OOOO N N For online help type: h
x NN N MM MM O O NN N For command line option help:
x N N N M MM M O O N N N quick-hint nmon -?
x N N N M M O O N N N full-details nmon -h
x N NN M M O O N NN To start nmon the same way every time?
x N N M M OOOO N N set NMON ksh variable, for example:
x ------------------------------ export NMON=cmt
x TOPAS_NMON
x 8 - CPUs currently
x 8 - CPUs configured
x 1504 - MHz CPU clock rate
x PowerPC_POWER5 - Processor
x 64 bit - Hardware
x 64 bit - Kernel
x 1,65-7858E - Logical Partition
x 6.1.4.1 TL04 - AIX Kernel Version
x oradb1 - Hostname
x oradb1 - Node/WPAR Name
x 657858E - Serial Number
x IBM,9117-570 - Machine Type
lqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq
lqtopas_nmonqqh=HelpqqqqqqqqqqqqqHost=oradb1qqqqqqqqqRefresh=2 secsqqq14:51.33qqqqqqqqqqqqqqqqqqqqqqqqqq
x Memory qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq
x Physical PageSpace | pages/sec In Out | FileSystemCache
x% Used 79.4% 10.3% | to Paging Space 0.0 0.0 | (numperm) 19.0%
x% Free 20.6% 89.7% | to File System 65.4 10.5 | Process 34.7%
xMB Used 5385.3MB 840.6MB | Page Scans 0.0 | System 25.7%
xMB Free 1398.7MB 7351.4MB | Page Cycles 0.0 | Free 20.6%
xTotal(MB) 6784.0MB 8192.0MB | Page Steals 0.0 | ------
x | Page Faults 652.1 | Total 100.0%
x------------------------------------------------------------ | numclient 19.0%
xMin/Maxperm 195MB( 3%) 1297MB( 19%) <--% of RAM | maxclient 19.1%
xMin/Maxfree 960 1088 Total Virtual 14.6GB | User 50.0%
xMin/Maxpgahead 2 8 Accessed Virtual 4.4GB 30.1%| Pinned 25.7%
xqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq
注意上面倒数第三行中的：1297MB( 19%) <--% of RAM <-------注意此行
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：《数据库原理》复习总结Next article：php支持连接sqlserver数据库