Maybe "inflate" is the wrong term? Data becomes 3x larger. Whatever you want to call that. Thread here:
https://groups.google.com/forum/#!searchin/h2-database/data$20size$20inflation/h2-database/AX_74h3YjyE/YUBaR_GVyq8J On Tuesday, June 10, 2014 11:10:37 AM UTC-7, Thomas Mueller wrote: > > Hi, > > The MVStore doesn't "inflate", but it temporarily uses more disk space > than really needed, specially if you have lots of updates. It keeps the old > data for some time (45 seconds by default), to prevent corrupt databases in > case of power failure. I understand the current version doesn't do a good > job to efficiently shrink the file down to the actual space needed. This is > one of the main disadvantages of log structured storage, and I will have to > work on this for some time. > > The PageStore also doesn't "inflate", but uses a transaction log, like > most relational databases do. > > Regards, > Thomas > > > > On Wednesday, June 4, 2014, Brian Craft <[email protected] <javascript:>> > wrote: > >> It's 1.3. I saw the earlier thread about MVStore disk space, which is a >> concern because the data inflation in PageStore is already very large. I >> posted an example some months ago. I have a branch that will put the larger >> items into the java port of leveldb to avoid this inflation, but leveldb >> has other problems that make it unusable in my app (in particular it opens >> more file descriptors than many OS will allow w/o mucking with system >> settings). >> >> On Wednesday, June 4, 2014 11:50:03 AM UTC-7, Thomas Mueller wrote: >>> >>> Hi, >>> >>> What version of H2 did you use to create the database? With version >>> 1.3.x (using the PageStore), LOG=0 it is unstable as documented. >>> >>> Version 1.4.x (using the MVStore) on the other hand is known to use more >>> disk space right now, this will be improved in future versions. >>> >>> Regards, >>> Thomas >>> >>> On Tuesday, June 3, 2014, Brian Craft <[email protected]> wrote: >>> >>>> Running a recovery, the resulting db file is 5x larger, and still >>>> growing. >>>> >>>> I just had a bulk load deadlock. I'm not sure how to interrupt these >>>> things, but started with kill -INT, then kill -SEGV, then kill -KILL. >>>> After >>>> that the db could not be opened, and would dump a bunch of lines like this >>>> into the trace: >>>> >>>> org.h2.jdbc.JdbcSQLException: Table "PROBEMAP_PROBES" not found; SQL >>>> statement: >>>> CREATE PRIMARY KEY PUBLIC.PRIMARY_KEY_E9 ON PUBLIC.PROBEMAP_PROBES(ID) >>>> [42102-175] >>>> 06-02 16:17:52 database: CREATE PRIMARY KEY PUBLIC.PRIMARY_KEY_E9 ON >>>> PUBLIC.PROBEMAP_PROBES(ID) >>>> >>>> >>>> I ran the recovery tool with >>>> >>>> java -cp ~/.m2/repository/com/h2database/h2/1.3.175/h2-1.3.175.jar >>>> org.h2.tools.Recover >>>> >>>> which generated a sql file that was 1.25x the size of the db file. I >>>> then loaded the script into a fresh db file with >>>> >>>> java -cp ~/.m2/repository/com/h2database/h2/1.3.175/h2-1.3.175.jar >>>> org.h2.tools.RunScript -url "jdbc:h2:recovered" -user '' -script >>>> cavm-testing.h2.sql >>>> >>>> which at the moment is more than 5x larger than the original db file. >>>> It's fairly remarkable. I may have to kill it. >>>> >>>> Any idea what would cause this, or if there's a way to prevent it? >>>> >>>> During the load which deadlocked the url was "cavm-testing;CACHE_SIZE= >>>> 65536;UNDO_LOG=1;LOG=0;MVCC=TRUE" >>>> >>>> >>>> -- >>>> 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 http://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 http://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 http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
