Re: Checkpointing and Checkpointing hooks

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.  

> 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.

Regards / Mit vielen Grüssen,
Sergei

-- 
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /   Sergei Golubchik 
 / /|_/ / // /\ \/ /_/ / /__  Principal Software Developer
/_/  /_/\_, /___/\___\_\___/  MySQL GmbH, Radlkoferstr. 2, D-81373 München
       <___/                  Geschäftsführer: Kaj Arnö - HRB München 162140

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