Hi, With version 1.4.x, the multi-threaded mode is still not the default, but I would like to fully support it. It's still beta however. With version 1.4.x, table-level locking is no longer used by default. Instead, MVCC is used.
Regards, Thomas On Wednesday, May 28, 2014, Brian Craft <[email protected]> wrote: > Thanks! > > Does MULTI_THREADED only help outside of a transaction? During a > transaction the table will still be locked. > > On Tuesday, May 27, 2014 10:47:46 PM UTC-7, Kartweel wrote: >> >> H2 is not multi-threaded in this version. So a single long running >> statement will block everything else. You'll either need to split it up >> into smaller inserts (can still be a single transaction, just smaller >> queries), or you could try turning on MULTI_THREADED=1. >> >> There is multi-threaded mode, but in this version it doesn't work with >> MVCC. I think in the latest beta version it might work, but if you are >> after reliability I'd go with breaking up your long running statement into >> smaller statements. >> >> On 28/05/2014 1:45 AM, Brian Craft wrote: >> >> Version 1.3.171. The only option I'm setting is MVCC, like >> "somefile;MVCC=TRUE". I'll try to get a thread dump in a few minutes. >> >> Does this mean readers should not be blocked during the insert? >> >> On Tuesday, May 27, 2014 4:18:01 AM UTC-7, Noel Grandin wrote: >>> >>> Can you post a thread dump, so we can see where it is blocked? >>> Also which version is this, and what does your DB URL look like? >>> >>> On 2014-05-25 20:24, Brian Craft wrote: >>> > I'm doing a large "insert into .. select * from CSVREAD ...", which is >>> in a transaction. It seems to be blocking >>> > readers, regardless of whether MVCC is enabled. Is this expected? If I >>> understand the threads on MVCC, it will allow >>> >> -- >> 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] > <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 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.
