- 论坛徽章:
- 0
|
informix731，数据库写命中率较低，有何方法可以提高，请教大家:
Profile
dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached
33776727 38866726 2025663997 98.33 48141810 71129911 134073254 64.09
isamtot open start read write rewrite delete commit rollbk
3029872238 190647214 323260009 1543376286 22034163 10207772 5477592 23755628 59
988
gp_read gp_write gp_rewrt gp_del gp_alloc gp_free gp_curs
0 0 0 0 0 0 0
ovlock ovuserthread ovbuff usercpu syscpu numckpts flushes
0 0 0 47133.77 21614.33 25100 50460
bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans
3486532 1591 4013348334 0 0 28581 2907347 59605671
ixda-RA idx-RA da-RA RA-pgsused lchwaits
17589 355094 30243526 30448330 4341675
机器内存3487514624，下面是onconfig文件：
ROOTNAME rootdbs # Root dbspace name
ROOTPATH /dev/chk0 # Path for device containing root dbspace
ROOTOFFSET 0 # Offset of root dbspace into device (Kbytes)
ROOTSIZE 2000000 # Size of root dbspace (Kbytes)
# Disk Mirroring Configuration Parameters
MIRROR 0 # Mirroring flag (Yes = 1, No = 0)
MIRRORPATH # Path for device containing mirrored root
MIRROROFFSET 0 # Offset into mirrored device (Kbytes)
# Physical Log Configuration
PHYSDBS logdbs # Location (dbspace) of physical log
PHYSFILE 400000 # Physical log file size (Kbytes)
# Logical Log Configuration
LOGFILES 30 # Number of logical log files
LOGSIZE 50000 # Logical log size (Kbytes)
SERVERNUM 0 # Unique id corresponding to a OnLine instance
DBSERVERNAME ywxt # Name of default database server
DBSERVERALIASES # List of alternate dbservernames
NETTYPE tlitcp,1,100,NET # Configure poll thread(s) for nettype
#NETTYPE ipcshm,1,100,CPU # Configure poll thread(s) for nettype
#NETTYPE tlitcp,5,5,NET # Configure poll thread(s) for nettype
DEADLOCK_TIMEOUT 60 # Max time to wait of lock in distributed env.
RESIDENT 0 # Forced residency flag (Yes = 1, No = 0)
MULTIPROCESSOR 1 # 0 for single-processor, 1 for multi-processor
NUMCPUVPS 4 # Number of user (cpu) vps
SINGLE_CPU_VP 0 # If non-zero, limit number of cpu vps to one
NOAGE 0 # Process aging
AFF_SPROC 4 # Affinity start processor
AFF_NPROCS 4 # Affinity number of processors
LOCKS 400000 # Maximum number of locks
BUFFERS 350000 # Maximum number of shared buffers
NUMAIOVPS 10 # Number of IO vps
PHYSBUFF 64 # Physical log buffer size (Kbytes)
LOGBUFF 64 # Logical log buffer size (Kbytes)
LOGSMAX 60 # Maximum number of logical log files
CLEANERS 8 # Number of buffer cleaner processes
SHMBASE 0x82000000 # Shared memory base address
SHMVIRTSIZE 52672
SHMADD 8192 # Size of new shared memory segments (Kbytes)
SHMTOTAL 0 # Total shared memory (Kbytes). 0=>unlimited
CKPTINTVL 300 # Check point interval (in sec)
LRUS 16 # Number of LRU queues
LRU_MAX_DIRTY 2 # LRU percent dirty begin cleaning limit
LRU_MIN_DIRTY 1 # LRU percent dirty end cleaning limit
LTXHWM 50 # Long transaction high water mark percentage
LTXEHWM 60 # Long transaction high water mark (exclusive)
TXTIMEOUT 0x12c # Transaction timeout (in sec)
STACKSIZE 32 # Stack size (Kbytes) |
|
免费注册
发表于 2011-07-21 13:08
