Skip to Main Content

Berkeley DB Family

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

What would happen when we disabled checkpoint?

789132Jun 21 2011 — edited Jun 22 2011
Hi,all
I have used je with some general configurations.But we found the performance dropped seriously when checkpoint waking up.
These are some EnvironmentStat:

Checkpoints: Frequency and extent of checkpointing activity.
lastCheckpointEnd=0x28e9/0xa4040b
lastCheckpointId=1,042
lastCheckpointStart=0x28e3/0x119add5
nCheckpoints=1
nDeltaINFlush=330,858
nFullBINFlush=32,482
nFullINFlush=36,946

I am confused that why so many Flush happened when checkpoints waking up.Disk io was very crowd so none of the io request can be perform.
The checkpoint continued about 10 seconds.

Then we disbled the checkpoint,but then the files of je were broken.It said:
"This environment's log file has no root. Since the root " +
"is the first entry written into a log at environment " +
"creation, this should only happen if the initial creation " +
"of the environment was never checkpointed or synced. " +
"Please move aside the existing log files to allow the " +
"creation of a new environment".
So I wonder that what would happened when we disabled checkpoint?

Thanks
yun

Edited by: 786129 on 2011-6-21 下午7:55

Edited by: 786129 on 2011-6-21 下午11:58
This post has been answered by Linda Lee-Oracle on Jun 22 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 20 2011
Added on Jun 21 2011
2 comments
331 views