Maison > Article > base de données > 修改aix操作系统参数maxclient%和maxperm%的一点记录
修改aix操作系统参数maxclient%和maxperm%的一点记录
- WBOYoriginal
- 2016-06-07 16:11:162946parcourir
关于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 <-------注意此行
Déclaration：
Le contenu de cet article est volontairement contribué par les internautes et les droits d'auteur appartiennent à l'auteur original. Ce site n'assume aucune responsabilité légale correspondante. Si vous trouvez un contenu suspecté de plagiat ou de contrefaçon, veuillez contacter admin@php.cn
Article précédent：《数据库原理》复习总结Article suivant：php支持连接sqlserver数据库