Aha, thanks I missed that it could handle only one thread by default. 

I checked the MULTI_THREADED, but once again its marked as experimental :). 
We will have a look at it anyway.
Thanks

Dne čtvrtek, 17. ledna 2013 13:11:44 UTC+1 Kartweel napsal(a):
>
>  I'm not sure how it works in a cluster, but H2 can only handle a single 
> thread at a time, so will block in MVCC mode anyway if you have a single 
> long running operation. You could try with MULTI_THREADED=1 to allow 
> multithreading.
>
> On 17/01/2013 6:58 PM, Matouš Voldřich wrote:
>  
> Thanks for answers. Well our problem is that H2 is used in 
> highly concurrent environment where multiple threads (spread accross a 
> cluster) are making queries to one H2 cluster (2 nodes). And because of H2 
> locks entire table, the queries often wait and block. If there is a long 
> running operation (like backup of 5 milion records), it blocks H2 server 
> for 30sec - 1 minute, halting everything. 
>
>  I know that chosing H2 for this use case was wrong and am trying to 
> convince to switch to some other server, but right now we are investigating 
> the options we have.
>
>  Matous 
>
> Dne pondělí, 14. ledna 2013 21:08:20 UTC+1 Thomas Mueller napsal(a): 
>>
>> Hi, 
>>
>>  The cluster mode is also an area that is not very well tested. And 
>> using LOCK_MODE=0 is not recommended (even when not using a cluster). 
>>
>>  What problem do you want to solve? Why don't you just use the default 
>> settings?
>>
>>  Regards,
>> Thomas
>>
>>
>> On Sun, Jan 13, 2013 at 3:32 PM, Ryan How <[email protected]> wrote:
>>
>>>  I'm not sure sorry, someone else might be able to answer for you. I 
>>> could only suggest give it a go and see if it works. I don't see why it 
>>> wouldn't work, you are only changing transaction isolation level.
>>>
>>> Thanks, Ryan 
>>>
>>>
>>> On 13/01/2013 6:24 PM, Matouš Voldřich wrote:
>>>    
>>> Thanks for answer. We will give it a try and at write some tests. 
>>>
>>>  Could you answer my second question? Is it possible to set LOCK_MODE=0 
>>> and still use cluster mode?
>>>
>>>  Thanks 
>>> Matous
>>>
>>> Dne sobota, 12. ledna 2013 15:34:27 UTC+1 Kartweel napsal(a): 
>>>>
>>>>  MVCC has been around for a while, so it is pretty stable. But I did 
>>>> find a bug the other day with "for update" and lobs, so it still has bugs. 
>>>> It isn't as well tested as the rest of the engine, and not as well 
>>>> supported :)
>>>>
>>>> Ryan
>>>>
>>>> On 11/01/2013 6:35 PM, Matouš Voldřich wrote:
>>>>  
>>>> Hi, 
>>>>
>>>>  I would like to ask about H2 feature MVCC (multi version 
>>>> concurrency). On some places this feature is marked as experimental so I 
>>>> would like to ask about its status. Is it ussable?
>>>>
>>>>  We would like to prevent locking of entire table. Are there any other 
>>>> options? I found only to use LOCK_LEVEL=0 since we do not need 
>>>> transactions 
>>>> at all (we use it as simple INSERT-GET-UPDATE-DELETE store). But we also 
>>>> use cluster, so I'm not sure if setting it will not disable the cluster 
>>>> functionality as well.
>>>>
>>>>  Thanks.
>>>> Matous
>>>> -- 
>>>> You received this message because you are subscribed to the Google 
>>>> Groups "H2 Database" group.
>>>> To view this discussion on the web visit 
>>>> https://groups.google.com/d/msg/h2-database/-/IPVunNjiwuUJ.
>>>> 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.
>>>>
>>>>
>>>>   -- 
>>> You received this message because you are subscribed to the Google 
>>> Groups "H2 Database" group.
>>> To view this discussion on the web visit 
>>> https://groups.google.com/d/msg/h2-database/-/vImI06FfFZMJ.
>>> 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.
>>>
>>>
>>>    -- 
>>> 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.
>>>  
>>  
>>   -- 
> You received this message because you are subscribed to the Google Groups 
> "H2 Database" group.
> To view this discussion on the web visit 
> https://groups.google.com/d/msg/h2-database/-/5TNsLRCIhHMJ.
> To post to this group, send email to [email protected]<javascript:>
> .
> To unsubscribe from this group, send email to 
> [email protected] <javascript:>.
> For more options, visit this group at 
> http://groups.google.com/group/h2-database?hl=en.
>
>
> 

-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To view this discussion on the web visit 
https://groups.google.com/d/msg/h2-database/-/LKRDNlQAVNAJ.
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.

Reply via email to