Hi, There are two formats: the old (default in H2 version 1.3.x) PageStore format, and the new (default in 1.4.x) MVStore format. The PageStore format is similar to this: https://en.wikipedia.org/wiki/Algorithms_for_Recovery_and_Isolation_Exploiting_Semantics and the MVStore is documented in http://h2database.com/html/mvstore.html
> Could a power outage or JVM crash result in torn pages being written and the entire database refusing to launch afterwards In both cases that should not happen, meaning it would be a bug in H2. Please note the PageStore format more complex than the MVStore format, but currently more used in production. So I assume the risk is similar for both. Regards, Thomas On Tue, Feb 9, 2016 at 9:15 PM, Eric Harney <[email protected] <javascript:_e(%7B%7D,'cvml','[email protected]');>> wrote: > What does H2's on-disk format look like, and how does that tie-in with > crash resilience? Could a power outage or JVM crash result in torn pages > being written and the entire database refusing to launch afterwards (or > spending hours processing WAL entries, uncertain about when or even if > it'll ever finish)? > > I really like MySQL's MyISAM in that respect. Yes you'll lose some data > with it if it crashes and there's no WAL and no ACID and no nothing, but at > the same time you'll only be losing a few rows around the affected spots > rather than the entire table, because MyISAM doesn't use pages. How does H2 > compare to this? > > -- > You received this message because you are subscribed to the Google Groups > "H2 Database" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected] > <javascript:_e(%7B%7D,'cvml','h2-database%[email protected]');> > . > To post to this group, send email to [email protected] > <javascript:_e(%7B%7D,'cvml','[email protected]');>. > Visit this group at https://groups.google.com/group/h2-database. > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
