You're right. I found the problem (I also used mvstore directly). Nevertheless, this thread is highly cpu consuming because by default the AutoCommitDelay is 1000ms and indirectly the sleep done in BackgroundWriterThread is 100 ms. I solved my issue by managing the commit of mvstore by myself.
Sorry for the convenience. Thanks. On Friday, November 21, 2014 5:03:31 PM UTC+1, IntensiveH2 wrote: > > Hello, > > Currently, I'm using Version 1.4.182 with the ooption ;PAGE_STORE=TRUE > When I activated the sampler of VisualVm on my server, I saw that we have > a thread name: > org.h2.mvstore.MVStore$BackgroundWriterThread.run(MVStore.java:2532) > and this thread consumed time. see below: > > > <https://lh3.googleusercontent.com/-Tz0pMooN3MI/VG9gXgyp0tI/AAAAAAAAAAM/0De1bantsko/s1600/2014-11-21_16h54_42.png> > I don't understand the reason why the mvstore is activated in this case > and also why we have an high CPU usage. > Could you help me to reduce CPU usage? > > Thanks you. > -- 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.
