Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 58791 invoked from network); 16 Feb 2006 04:48:34 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 16 Feb 2006 04:48:34 -0000 Received: (qmail 80280 invoked by uid 500); 16 Feb 2006 04:48:33 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 80159 invoked by uid 500); 16 Feb 2006 04:48:33 -0000 Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: Delivered-To: mailing list derby-dev@db.apache.org Received: (qmail 80149 invoked by uid 99); 16 Feb 2006 04:48:33 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 15 Feb 2006 20:48:33 -0800 X-ASF-Spam-Status: No, hits=1.9 required=10.0 tests=DNS_FROM_RFC_ABUSE,DNS_FROM_RFC_POST,MSGID_FROM_MTA_HEADER,SPF_HELO_PASS,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: domain of raymond_derby@hotmail.com designates 65.54.168.48 as permitted sender) Received: from [65.54.168.48] (HELO hotmail.com) (65.54.168.48) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 15 Feb 2006 20:48:32 -0800 Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Wed, 15 Feb 2006 20:48:11 -0800 Message-ID: Received: from 65.54.168.200 by by113fd.bay113.hotmail.msn.com with HTTP; Thu, 16 Feb 2006 04:48:11 GMT X-Originating-IP: [142.167.203.65] X-Originating-Email: [raymond_derby@hotmail.com] X-Sender: raymond_derby@hotmail.com From: "Raymond Raymond" To: derby-dev@db.apache.org Subject: Two questions on derby checkpointing Date: Thu, 16 Feb 2006 00:48:11 -0400 Mime-Version: 1.0 Content-Type: text/plain; format=flowed X-OriginalArrivalTime: 16 Feb 2006 04:48:11.0763 (UTC) FILETIME=[309B6430:01C632B4] X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N I have some questions about derby checkpointing. Someone can help me to make it clear? ^_^. 1. I want to summarize what events will trigger a checkpoint? On the derby website : http://db.apache.org/derby/papers/logformats.html I found such comments: ------------------------------------------------------------------------------------------------------------------------------------------- With the default values, a new log file is created (this is known as log switch) when a log file grows beyond 1MB and a checkpoint happens when the amount of log written is 10MB or more from the last checkpoint. RawStore exposes a checkpoint method which clients can call, or a checkpoint is taken automatically by the RawStore when: 1. The log file grows beyond a certain size (configurable, default 1MB) 2. RawStore is shutdown and a checkpoint hasn't been done "for a while" 3. RawStore is recovered and a checkpoint hasn't been done "for a while" ------------------------------------------------------------------------------------------------------------------------------------------- I am no very clear about what " for a while " means in the second and the third comments. I also want to know are there any other events will trigger a checkpoint besides these? 2. As what we discussed in the "incremental checkpointing issue" before, I need to monitor the data reads and log writes, to gather some runtime disk I/O information. So far, I found the basic classes to do data reads are : org.apache.derby.impl.store.raw.data.RAFContainer.java org.apache.derby.impl.store.raw.data.InputStreamContainer.java the basic class to do log writes is : org.apache.derby.impl.store.raw.log.LogAccessFile.java Are there any other classes is involved in data reads and log writes directly? Thanks. Raymond _________________________________________________________________ Powerful Parental Controls Let your child discover the best the Internet has to offer. http://join.msn.com/?pgmarket=en-ca&page=byoa/prem&xAPID=1994&DI=1034&SU=http://hotmail.com/enca&HL=Market_MSNIS_Taglines Start enjoying all the benefits of MSN� Premium right now and get the first two months FREE*.