MySQL Forums
Forum List  »  InnoDB

I/O on checkpoints
Posted by: Tiago 504
Date: September 27, 2016 04:33AM

Hello,

I am trying to understand the I/O performed by Innodb. Concretely, i would like to understand how checkpoints are performed at the file system level, i.e, how checkpoints start and how end. I already have seen that the info of the last checkpoint is stored on the ib_logfile0 file at the offset 512 or 1536 (alternately).

My questions are:
(1) Is this disk access (mentioned above) the last write of a checkpoint?
(2) How can i detect that a checkpoint is starting? It is a access on the ibdata file or .ibd?

I am doing this questions because i want to understand what are the data that i need to save during a checkpoint in order to doan incremental backup.

Thanks in advance,
Best regards,
Tiago

Options: ReplyQuote


Subject
Views
Written By
Posted
I/O on checkpoints
1241
September 27, 2016 04:33AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.