Maison > Article > base de données > 修改aix操作系统参数maxclient%和maxperm%的一点记录
关于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 <-------注意此行