Re: How to make sure I don't write a corrupt page to db when I checkpoint?
Date: Sun, 01 Jul 2007 13:30:05 GMT
"Sune" <sune_ahlgren_at_hotmail.com> wrote in message
> Hi all!
> I'm looking into designing an in-memory DB. Before I start, there are
> several things I must have figured out. Among those things is a
> technique to use to make sure that I don't write a corrupt page to db
> when I checkpoint. How do I make sure stray pointers in the
> application using my db (which will load into application process
> memory) does not damage my page(s) from the time of latest checkpoint
> and next checkpoint? And if it does, I don't want to flush it to disk,
> how do I detect a page corruption to avoid this?
> Am I simply being paranoid?
> Should I, for every update, calculate the checksum of the changed
> record? Records can be large and this sounds like a pain in the back,
> Any other, better ways out there, to achieve what I want?
> The checksum does not have to be idiot proof, that is, the checksum
> does not have to be unique for the bit pattern of the page, unless
> there is a cheap way of achieving this of course, but I don't think
> there is...
Received on Sun Jul 01 2007 - 15:30:05 CEST