当前位置:Gxlcms > mysql > 修改aix操作系统参数maxclient%和maxperm%的一点记录

修改aix操作系统参数maxclient%和maxperm%的一点记录

时间:2021-07-01 10:21:17 帮助过:126人阅读

关于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  <-------注意此行



人气教程排行