Re: Aix begin to use pagingspace while the physical memory was not used up



Hi,Simon
I have a database server and i make a full db backup every three days to a
jfs2 file system on it's internal hard disk using dd and then compress the
datafile in the jfs2 file system. The db backup process endures for 4
hours.

My problem is:
Each time the db backup process has finished. Paging space usage of the
database server increase about 3 percent. And I found oracle server
processes ( the number of oracle server process is more than 100) use more
paging space than before,though there are about 50 percent physical memory
is free. It seems that during db backup, more file system cache is needed
and VMM has to steal pages that used by other processes, But after the db
backup process finished these pages are not paged into physical memory
again.

Later i have made a test:
i create a jfs bigfile enabled system used for db backup instead of the
jfs2 file systems. Then the above problems disappeared,everything looks OK.

Here i supply the vmm parameters on my server(AIX 5206):
cpu_scale_memp = 8
data_stagger_interval = 161
defps = 1
force_relalias_lite = 0
framesets = 2
htabscale = -1
kernel_heap_psize = 4096
large_page_heap_size = 0
lgpg_regions = 0
lgpg_size = 0
low_ps_handling = 1
lru_file_repage = 1
lru_poll_interval = 0
lrubucket = 131072
maxclient% = 20
maxfree = 128
maxperm = 392781
maxperm% = 20
maxpin = 1677722
maxpin% = 80
mbuf_heap_psize = 4096
memory_affinity = 1
memory_frames = 2097152
mempools = 1
minfree = 120
minperm = 98195
minperm% = 5
nokilluid = 0
npskill = 8192
npswarn = 32768
num_spec_dataseg = 0
numpsblks = 1048576
pagecoloring = 0
pinnable_frames = 1693995
pta_balance_threshold = 0
relalias_percentage = 0
soft_min_lgpgs_vmpool = 0
spec_dataseg_int = 512
strict_maxclient = 1
strict_maxperm = 1
v_pinshm = 0
vmm_fork_policy = 0
hd_pbuf_cnt = 2816
hd_pvs_opn = 18
j2_dynamicBufferPreallocation = 16
j2_inodeCacheSize = 400
j2_maxPageReadAhead = 128
j2_maxRandomWrite = 1
j2_maxUsableMaxTransfer = 512
j2_metadataCacheSize = 400
j2_minPageReadAhead = 2
j2_nBufferPerPagerDevice = 512
j2_nPagesPerWriteBehindCluster = 8
j2_nRandomCluster = 8
j2_non_fatal_crashes_system = 0
j2_syncModifiedMapped = 1
jfs_clread_enabled = 0
jfs_use_read_lock = 1
lvm_bufcnt = 9
maxpgahead = 8
maxrandwrt = 1
memory_frames = 2097152
minpgahead = 2
numclust = 1
numfsbufs = 196
pd_npages = 65536
pgahd_scale_thresh = 0
sync_release_ilock = 1
hd_pendqblked = 251304
psbufwaitcnt = 0
fsbufwaitcnt = 47376
rfsbufwaitcnt = 0
xpagerbufwaitcnt = 1242138



Relevant Pages

  • Re: Aix begin to use pagingspace while the physical memory was not used up
    ... jfs2 file system on it's internal hard disk using dd and then compress the ... Each time the db backup process has finished. ... database server increase about 3 percent. ... paging space than before,though there are about 50 percent physical memory ...
    (AIX-L)
  • Re: [Info-Ingres] Ingres and Dell-Equalogic SAN
    ... The backup server initiates the backups by calling a script on the database server via ssh. ... This SAN has a grpadmin account which owns the thing and a CLI from which I can issue commands to the SAN. ...
    (comp.databases.ingres)
  • Mapped Drive not availible for backup
    ... To save space on our database server I have shared a folder on our web ... availible as a backup option from SQL Enterprise manager. ... Cannot open backup device 'S:\DBBACKUPS\MyDB.bak'. ... See the SQL Server error log for more details. ...
    (microsoft.public.sqlserver.server)
  • freebsd boot and fsck problem
    ... I started to learn and used FreeBSD from last year. ... Last night, As usual,I started ./drivecopy.sh to backup my FreeBSD4.3 ... So I had to force to suspend the backup process by pressing Ctrl+Z. ... **start to quote error message ...
    (freebsd-newbies)
  • freebsd boot and fsck problem
    ... I started to learn and used FreeBSD from last year. ... Last night, As usual,I started ./drivecopy.sh to backup my FreeBSD4.3 ... So I had to force to suspend the backup process by pressing Ctrl+Z. ... **start to quote error message ...
    (freebsd-questions)