Re: Checkpointing and Checkpointing hooks

On Thu, 2007-07-05 at 16:06 +0200, Sergei Golubchik wrote:
> Hi!
>
> On Jul 04, Alex Pilchin wrote:
> > Hi,
> > I need find a way to get notification that a checkpoint has occurred in
> > MySql. Is this functionality available somewhere (eg. as a patch or
> > somewhere in the MySql code)?
>
> Checkpoint doesn't occur in MySQL, it occurs in the storage engine.
> MySQL doesn't do checkpoints, it has no knowledge about checkpoints in
> the storage engine, it does not know when they happen. Different storage
> engines may do checkpoints in different moments of time, with different
> frequency, or not at all.

Sorry about that, all my questions are with regards to InnoDB but I'm also interested regarding BDB as well.

> > Also, it would be nice to know which transactions have been executed
> > after the last checkpoint. Is this at all possible w/o parsing and
> > scanning the log at the moment?
> > Is there any capability at the moment to support user triggered
> > check-pointing?
>
> Any answer to this question will necessary be storage engine specific.
> You need to clarify what storage engines you're interested in.

Cheers,
Alex

-- 
MySQL Internals Mailing List
For list archives: 
http://lists.mysql.com/internals
To unsubscribe:    
http://lists.mysql.com/internals?unsub=lists@pantek.com