有关cp的问题请教，谢谢！
日志：17:19:52Fuzzy Checkpoint Completed:duration was 5 seconds, 64319 buffers not
flushed.
请问这个是否CP不正常？
onconfig：
# Physical Log Configuration
PHYSDBS physdbs # Location (dbspace) of physical log
PHYSFILE 80000 # Physical log file size (Kbytes)
# Logical Log Configuration
LOGFILES 4 # Number of logical log files
LOGSIZE 20000 # Logical log size (Kbytes)
# Shared Memory Parameters
LOCKS 3000000 # Maximum number of locks
BUFFERS 250000 # Maximum number of shared buffers
NUMAIOVPS 16 # Number of IO vps
PHYSBUFF 128 # Physical log buffer size (Kbytes)
LOGBUFF 128 # Logical log buffer size (Kbytes)
CLEANERS 8 # Number of buffer cleaner processes
SHMBASE 0x0 # Shared memory base address
SHMVIRTSIZE 64000 # initial virtual shared memory segment size
SHMADD 8192 # Size of new shared memory segments (Kbytes)
SHMTOTAL 0 # Total shared memory (Kbytes). 0=>unlimited
CKPTINTVL 200 # Check point interval (in sec)
LRUS 8 # Number of LRU queues
LRU_MAX_DIRTY 60 # LRU percent dirty begin cleaning limit
LRU_MIN_DIRTY 50 # LRU percent dirty end cleaning limit
TXTIMEOUT 0x12c # Transaction timeout (in sec)
STACKSIZE 128 正常的单机checkpint日志~~ 正常？
我看了别的机器的是这样的：
10:02:13Checkpoint Completed:duration was 0 seconds.
不知“64319 buffers not flushed”是什么意思？
另外“单机”是指...? 原帖由 chenws362 于 2008-7-17 09:58 发表 http://bbs.chinaunix.net/images/common/back.gif
正常？
我看了别的机器的是这样的：
10:02:13Checkpoint Completed:duration was 0 seconds.
不知“64319 buffers not flushed”是什么意思？
另外“单机”是指...?
比如使用了HDR方式的数据库,就是以上的 10:02:13Checkpoint Completed:duration was 0 seconds.
只是单个数据库..就会有 Fuzzy Checkpoint Completed:
Fuzzy Checkpoint 是模糊检查点~
如果要改变,参考..
http://bbs.chinaunix.net/viewthread.php?tid=355296 非常感谢！
页:
[1]