I currently use H2 for a logging/monitoring application which runs 24x7 and I am experiencing two issues:
1) The size of the database constantly grows, and once the size hits around 250MB it refuses to accept new connections. If the database is shut down and re-opened the size of the database shrinks and it becomes responsive again. 2) My second issue is that of a long start up time. One sites h2 database takes about one hour to open. I enabled logging and it appears that the database is replaying every transaction since it was created. I see lots of lines like the following: 11-23 17:35:16 pageStore: log redo - table:175 key:34191721 ... 11-23 17:41:19 pageStore: updateRecord page[89022] b-tree leaf table: 13 entries:17 11-23 17:41:20 index: T10_DATA remove ( /* key:5977917 */ 5977917, '0102D2918A90517BB06', 'Intel(R) ICH10 Family USB Universal Host Controller - 3A68', 'Universal Serial Bus controllers', '9.0.0.1005', 'Intel', '2-25-2008', 'usbuhci.sys', 'Enabled') 11-23 17:41:20 pageStore: log redo - table:10 key:5977918 My theory is that these two issues have something to do with MVCC. The documentation states that if one enables MVCC then the transaction log must fit in memory. Is memory here the heap space? What about disk? One of my theories here is that the database is constantly growing as a result of the transaction log being persisted in addition to the data. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
