AIX6.1 数据库服务器优化
请教一下,aix6.1 跑sybase 12.5.0.3
有什么可以优化的地方么?
为什么有的时候pagespace 占用很多?而计算内存刚15%,是文件缓存过多么? 给sybase配置了50G内存啊?
请帮助分析下,,多谢。
|
| 64 - CPUs currently |
| 64 - CPUs configured |
| 4228 - MHz CPU clock rate |
| PowerPC_POWER7 - Processor |
| 64 bit - Hardware |
| 64 bit - Kernel |
| 6.1.7.16 TL07 - AIX Kernel Version |
vmo -a
ame_cpus_per_pool = n/a
ame_maxfree_mem = n/a
ame_min_ucpool_size = n/a
ame_minfree_mem = n/a
ams_loan_policy = n/a
enhanced_affinity_affin_time = 1
enhanced_affinity_vmpool_limit = 10
esid_allocator = 0
force_relalias_lite = 0
kernel_heap_psize = 65536
lgpg_regions = 0
lgpg_size = 0
low_ps_handling = 1
maxfree = 1088
maxperm = 14134144
maxpin = 13044170
maxpin% = 80
memory_frames = 16187392
memplace_data = 0
memplace_mapped_file = 0
memplace_shm_anonymous = 0
memplace_shm_named = 0
memplace_stack = 0
memplace_text = 0
memplace_unmapped_file = 0
minfree = 960
minperm = 471135
minperm% = 3
nokilluid = 0
npskill = 122880
npswarn = 491520
num_locks_per_semid = 1
numpsblks = 15728640
pinnable_frames = 14474951
relalias_percentage = 0
scrub = 0
v_pinshm = 0
vmm_default_pspa = 0
vmm_klock_mode = 1
wlm_memlimit_nonpg = 1
ioo -a
aio_active = 1
aio_maxreqs = 65536
aio_maxservers = 30
aio_minservers = 3
aio_server_inactivity = 300
j2_atimeUpdateSymlink = 0
j2_dynamicBufferPreallocation = 16
j2_inodeCacheSize = 400
j2_maxPageReadAhead = 128
j2_maxRandomWrite = 0
j2_metadataCacheSize = 400
j2_minPageReadAhead = 2
j2_nPagesPerWriteBehindCluster = 32
j2_nRandomCluster = 0
j2_syncPageCount = 0
j2_syncPageLimit = 16
lvm_bufcnt = 9
maxpgahead = 8
maxrandwrt = 0
numclust = 1
numfsbufs = 196
pd_npages = 65536
posix_aio_active = 0
posix_aio_maxreqs = 65536
posix_aio_maxservers = 30
posix_aio_minservers = 3
posix_aio_server_inactivity = 300