Hi,
Thank you for your valuable inputs, I would say there is not much
improvement since we have large number of update, delete operations and we
can't afford to limit these.
I still see issue with java.io.DeleteOnExitHook. Please find attached
heap-dump analysis and let me know if there is any workaround for this
issue.
Thanks,
Suresh
On Friday, April 17, 2015 at 9:41:05 PM UTC+5:30, Thomas Mueller wrote:
>
> Hi,
>
> Most of those settings are dangerous, so I would expect you get a corrupt
> database (at least with the PageStore). But if it's just a cache, then that
> might be OK. I have to say that for others reading this email.
>
> Version 1.4.x (the MVStore) doesn't use that many temp files. The only
> situation I know if is large update or delete operations, specially if you
> use low MAX_MEMORY_ROWS or MAX_OPERATION_MEMORY settings, like you do. I
> would try using the default settings instead. Or try to limit your update
> and delete operations.
>
> Regards,
> Thomas
>
> On Fri, Apr 17, 2015 at 10:32 AM, Noel Grandin <[email protected]>
> wrote:
>
>>
>>
>> On 2015-04-17 10:18 AM, suresh kumar wrote:
>>
>>>
>>> Database URL:
>>>
>>> jdbc:h2:file:var/cache/10020/h2/mydb;LOG=0;LOCK_MODE=0;UNDO_LOG=0;FILE_LOCK=NO;TRACE_LEVEL_FILE=0;TRACE_LEVEL_SYSTEM_OUT=0;MAX_MEMORY_ROWS=100;MAX_OPERATION_MEMORY=100;
>>>
>>>
>> Did you read the many emails and documentation where we say that if you
>> use LOG=0 or UNDO_LOG=0 we don't care about your problems?
>>
>> And you are severely damaging your performance with those MAX_ settings.
>>
>>
>> --
>> 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.
Class Name
| Shallow Heap | Retained Heap | Percentage
-----------------------------------------------------------------------------------------------------------------------------------------------
| | |
class java.io.DeleteOnExitHook @ 0x782a5a188 System Class
| 8 | 27,150,696 | 16.80%
'- java.util.LinkedHashSet @ 0x782a5a200
| 16 | 27,150,688 | 16.80%
'- java.util.LinkedHashMap @ 0x782a5a210
| 56 | 27,150,672 | 16.80%
|- java.util.HashMap$Entry[262144] @ 0x785d40ce0
| 1,048,592 | 1,048,592 | 0.65%
|- java.util.LinkedHashMap$Entry @ 0x783b41468
| 40 | 192 | 0.00%
| '- java.lang.String @ 0x783b41490
/var/cache/10020/h2/mydb.1835859673.10276.temp.db | 24 |
152 | 0.00%
|- java.util.LinkedHashMap$Entry @ 0x783b41528
| 40 | 192 | 0.00%
| '- java.lang.String @ 0x783b41550
/var/cache/10020/h2/mydb.1835859673.10277.temp.db | 24 |
152 | 0.00%
|- java.util.LinkedHashMap$Entry @ 0x783b415e8
| 40 | 192 | 0.00%
| '- java.lang.String @ 0x783b41610
/var/cache/10020/h2/mydb.1835859673.10278.temp.db | 24 |
152 | 0.00%
|- java.util.LinkedHashMap$Entry @ 0x783b416a8
| 40 | 192 | 0.00%
| '- java.lang.String @ 0x783b416d0
/var/cache/10020/h2/mydb.1835859673.10279.temp.db | 24 |
152 | 0.00%
|- java.util.LinkedHashMap$Entry @ 0x7851f88c0
| 40 | 192 | 0.00%
|- java.util.LinkedHashMap$Entry @ 0x7851f8980
| 40 | 192 | 0.00%
|- java.util.LinkedHashMap$Entry @ 0x7851f8a40
| 40 | 192 | 0.00%
|- java.util.LinkedHashMap$Entry @ 0x7851f8b00
| 40 | 192 | 0.00%
|- java.util.LinkedHashMap$Entry @ 0x7851f8bc0
| 40 | 192 | 0.00%
|- java.util.LinkedHashMap$Entry @ 0x7851f8c80
| 40 | 192 | 0.00%
|- java.util.LinkedHashMap$Entry @ 0x7851f8d40
| 40 | 192 | 0.00%
|- java.util.LinkedHashMap$Entry @ 0x7851f8e00
| 40 | 192 | 0.00%
|- java.util.LinkedHashMap$Entry @ 0x7851f8ec0
| 40 | 192 | 0.00%
|- java.util.LinkedHashMap$Entry @ 0x7851f8f80
| 40 | 192 | 0.00%
|- java.util.LinkedHashMap$Entry @ 0x7851f9040
| 40 | 192 | 0.00%
|- java.util.LinkedHashMap$Entry @ 0x7851f9100
| 40 | 192 | 0.00%
|- java.util.LinkedHashMap$Entry @ 0x7851f91c0
| 40 | 192 | 0.00%
|- java.util.LinkedHashMap$Entry @ 0x7851f9280
| 40 | 192 | 0.00%
|- java.util.LinkedHashMap$Entry @ 0x7851f9340
| 40 | 192 | 0.00%
|- java.util.LinkedHashMap$Entry @ 0x7851f9400
| 40 | 192 | 0.00%
|- java.util.LinkedHashMap$Entry @ 0x7851f94c0
| 40 | 192 | 0.00%
|- java.util.LinkedHashMap$Entry @ 0x7851f9580
| 40 | 192 | 0.00%
|- java.util.LinkedHashMap$Entry @ 0x7851f9640
| 40 | 192 | 0.00%
|- java.util.LinkedHashMap$Entry @ 0x7851f9700
| 40 | 192 | 0.00%
'- Total: 25 of 135,954 entries; 135,929 more
| | |
org.apache.catalina.loader.WebappClassLoader @ 0x78107b0d8
| 144 | 13,733,760 | 8.50%
|- java.util.concurrent.ConcurrentHashMap @ 0x78107d148
| 48 | 10,579,408 | 6.55%
|- class org.h2.util.StringUtils @ 0x7822d1128
| 32 | 487,528 | 0.30%
|- class org.springframework.beans.CachedIntrospectionResults @ 0x781ca52d8
| 32 | 486,592 | 0.30%
|- class org.opensaml.XML @ 0x785b0f4d8
| 88 | 421,224 | 0.26%
|- org.apache.xmlbeans.impl.schema.SchemaTypeSystemImpl @ 0x781d212a0
| 112 | 306,480 | 0.19%
|- class org.unbescape.html.HtmlEscapeSymbols @ 0x783886850
| 16 | 169,704 | 0.11%
|- java.util.HashMap @ 0x78107c358
| 48 | 107,432 | 0.07%
|- class com.mysql.jdbc.CharsetMapping @ 0x781c934c8
| 296 | 79,216 | 0.05%
|- java.util.Hashtable @ 0x78107b168
| 48 | 76,056 | 0.05%
|- class org.h2.store.fs.FileMemData @ 0x782298c10
| 32 | 67,808 | 0.04%
|- class org.apache.xmlbeans.impl.common.XMLChar @ 0x781d02e18
| 40 | 65,592 | 0.04%
|- java.util.HashMap @ 0x780c1a3c8
| 48 | 56,680 | 0.04%
|- java.util.Vector @ 0x78107b328
| 32 | 41,008 | 0.03%
|- class org.h2.message.DbException @ 0x7823a64d0
| 16 | 37,440 | 0.02%
|- class ognl.OgnlRuntime @ 0x7838b3d48
| 200 | 34,696 | 0.02%
|- java.util.ArrayList @ 0x780c1a720
| 24 | 26,688 | 0.02%
|- class org.codehaus.jackson.io.NumberOutput @ 0x781a10b88
| 72 | 21,232 | 0.01%
|- class org.thymeleaf.dom.Attribute @ 0x7838c75a8
| 16 | 17,848 | 0.01%
|- java.util.HashMap @ 0x780c16b70
| 48 | 14,400 | 0.01%
|- class org.springframework.util.ReflectionUtils @ 0x781e67268
| 24 | 13,320 | 0.01%
|- class org.apache.xml.security.algorithms.JCEMapper @ 0x785abcc10
| 16 | 13,208 | 0.01%
|- class org.h2.value.DataType @ 0x782507358
| 24 | 12,416 | 0.01%
|- class org.springframework.core.annotation.AnnotationUtils @ 0x781d9bdc0
| 16 | 10,720 | 0.01%
|- org.apache.xmlbeans.impl.schema.BuiltinSchemaTypeSystem @ 0x781c26ac0
| 40 | 10,640 | 0.01%
|- class org.springframework.cglib.proxy.Enhancer @ 0x781e4a6a8
| 136 | 10,552 | 0.01%
'- Total: 25 of 4,654 entries; 4,629 more
| | |
org.h2.mvstore.MVStore @ 0x78231d128
| 176 | 13,655,896 | 8.45%
|- org.h2.mvstore.cache.CacheLongKeyLIRS @ 0x782321530
| 40 | 6,433,800 | 3.98%
|- org.h2.mvstore.cache.CacheLongKeyLIRS @ 0x782325378
| 40 | 5,081,288 | 3.14%
|- org.h2.mvstore.WriteBuffer @ 0x78363bc80
| 24 | 1,048,664 | 0.65%
|- org.h2.mvstore.FileStore @ 0x78231d410
| 80 | 1,042,632 | 0.65%
|- java.util.concurrent.ConcurrentHashMap @ 0x7823253f0
| 48 | 37,928 | 0.02%
|- java.util.concurrent.ConcurrentHashMap @ 0x7823254b8
| 48 | 2,640 | 0.00%
|- org.h2.mvstore.Page @ 0x789c6c590
| 64 | 2,288 | 0.00%
|- java.util.concurrent.ConcurrentHashMap @ 0x782327570
| 48 | 1,176 | 0.00%
|- java.util.HashMap @ 0x782327eb0
| 48 | 448 | 0.00%
|- org.h2.mvstore.Page @ 0x789c95e50
| 64 | 432 | 0.00%
|- org.h2.mvstore.MVMap @ 0x782321a38
| 64 | 376 | 0.00%
|- java.lang.Object[39] @ 0x789c5a8e8
| 176 | 176 | 0.00%
|- org.h2.mvstore.Chunk @ 0x789c2e3b0
| 104 | 104 | 0.00%
|- java.lang.String @ 0x783f28040 chunk.f70
| 24 | 64 | 0.00%
|- java.lang.String @ 0x788efa5b0 chunk.64ae
| 24 | 64 | 0.00%
|- java.lang.String @ 0x788efa5f0 chunk.64a8
| 24 | 64 | 0.00%
|- java.lang.String @ 0x788f64df8 chunk.64b4
| 24 | 64 | 0.00%
|- java.lang.String @ 0x788f6e958 chunk.64ba
| 24 | 64 | 0.00%
|- java.lang.String @ 0x788fe8a38 chunk.64c0
| 24 | 64 | 0.00%
|- java.lang.String @ 0x789076178 chunk.64cc
| 24 | 64 | 0.00%
|- java.lang.String @ 0x7890761b8 chunk.64c6
| 24 | 64 | 0.00%
|- java.lang.String @ 0x78910dd78 chunk.64d2
| 24 | 64 | 0.00%
|- java.lang.String @ 0x78910e268 chunk.64d8
| 24 | 64 | 0.00%
|- java.lang.String @ 0x78919ef60 chunk.64e4
| 24 | 64 | 0.00%
|- java.lang.String @ 0x78919efa0 chunk.64de
| 24 | 64 | 0.00%
'- Total: 25 of 93 entries; 68 more
| | |
org.h2.mvstore.MVStore @ 0x7823644e8
| 176 | 13,584,192 | 8.41%
|- org.h2.mvstore.cache.CacheLongKeyLIRS @ 0x782366b78
| 40 | 6,400,376 | 3.96%
|- org.h2.mvstore.cache.CacheLongKeyLIRS @ 0x782369550
| 40 | 5,078,184 | 3.14%
|- org.h2.mvstore.WriteBuffer @ 0x78373c510
| 24 | 1,048,664 | 0.65%
|- org.h2.mvstore.FileStore @ 0x7823647d0
| 80 | 1,008,984 | 0.62%
|- java.util.concurrent.ConcurrentHashMap @ 0x7823695c8
| 48 | 36,480 | 0.02%
|- java.util.concurrent.ConcurrentHashMap @ 0x782369690
| 48 | 2,640 | 0.00%
|- org.h2.mvstore.Page @ 0x789c5f7d8
| 64 | 2,344 | 0.00%
|- java.util.concurrent.ConcurrentHashMap @ 0x782369770
| 48 | 1,176 | 0.00%
|- java.util.HashMap @ 0x78236c098
| 48 | 448 | 0.00%
|- org.h2.mvstore.Page @ 0x789c60390
| 64 | 400 | 0.00%
|- org.h2.mvstore.MVMap @ 0x782366fc0
| 64 | 376 | 0.00%
|- java.lang.Object[38] @ 0x789c603d0
| 168 | 168 | 0.00%
|- org.h2.mvstore.Chunk @ 0x789c5eb80
| 104 | 104 | 0.00%
|- java.lang.String @ 0x783f28080 chunk.f70
| 24 | 64 | 0.00%
|- java.lang.String @ 0x788efa500 chunk.647e
| 24 | 64 | 0.00%
|- java.lang.String @ 0x788f61318 chunk.648a
| 24 | 64 | 0.00%
|- java.lang.String @ 0x788f61358 chunk.6484
| 24 | 64 | 0.00%
|- java.lang.String @ 0x788ff28a0 chunk.6496
| 24 | 64 | 0.00%
|- java.lang.String @ 0x788ff28e0 chunk.6490
| 24 | 64 | 0.00%
|- java.lang.String @ 0x789072790 chunk.64a2
| 24 | 64 | 0.00%
|- java.lang.String @ 0x789073300 chunk.649c
| 24 | 64 | 0.00%
|- java.lang.String @ 0x789106220 chunk.64ae
| 24 | 64 | 0.00%
|- java.lang.String @ 0x789106260 chunk.64a8
| 24 | 64 | 0.00%
|- java.lang.String @ 0x7891aa840 chunk.64ba
| 24 | 64 | 0.00%
|- java.lang.String @ 0x7891aa880 chunk.64b4
| 24 | 64 | 0.00%
'- Total: 25 of 91 entries; 66 more
| | |
org.h2.mvstore.MVStore @ 0x782324980
| 176 | 13,058,472 | 8.08%
org.h2.mvstore.MVStore @ 0x782377dd0
| 176 | 12,853,112 | 7.95%
org.h2.mvstore.MVStore @ 0x782344ef0
| 176 | 11,886,192 | 7.36%
org.apache.catalina.webresources.StandardRoot @ 0x780f487e8
| 80 | 9,425,192 | 5.83%
org.h2.mvstore.MVStore @ 0x783429ad0
| 176 | 8,529,888 | 5.28%
java.lang.Thread @ 0x786394008 RMI TCP Connection(111)-10.0.1.182 Thread
| 104 | 1,622,112 | 1.00%
org.springframework.beans.factory.support.DefaultListableBeanFactory @
0x78192b918 | 208 | 1,306,056 | 0.81%
org.apache.tomcat.util.net.NioEndpoint @ 0x780c6b750
| 288 | 1,140,064 | 0.71%
org.apache.tomcat.util.net.NioEndpoint @ 0x7810515c0
| 288 | 1,069,552 | 0.66%
org.h2.mvstore.MVStore @ 0x782bc8ca0
| 176 | 1,069,192 | 0.66%
org.h2.mvstore.MVStore @ 0x782cd5320
| 176 | 1,069,192 | 0.66%
org.h2.mvstore.MVStore @ 0x782de0ec0
| 176 | 1,069,192 | 0.66%
org.h2.mvstore.MVStore @ 0x7830fbd80
| 176 | 1,069,192 | 0.66%
org.h2.mvstore.MVStore @ 0x783208a40
| 176 | 1,069,192 | 0.66%
org.h2.mvstore.MVStore @ 0x783314bf0
| 176 | 1,069,192 | 0.66%
org.h2.mvstore.MVStore @ 0x78352d0d8
| 176 | 1,069,192 | 0.66%
org.h2.mvstore.MVStore @ 0x782eecfb0
| 176 | 1,069,184 | 0.66%
java.net.URLClassLoader @ 0x780e7bff0
| 80 | 647,752 | 0.40%
org.apache.catalina.core.StandardContext @ 0x780f48838
| 512 | 506,872 | 0.31%
org.apache.jasper.compiler.TldCache @ 0x78175b620
| 32 | 328,344 | 0.20%
org.apache.zookeeper.ZooKeeper$ZKWatchManager @ 0x7817231e8
| 32 | 312,336 | 0.19%
org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping
@ 0x782355668 | 96 | 272,096 | 0.17%
org.apache.catalina.valves.AccessLogValve @ 0x780c22d80
| 136 | 268,280 | 0.17%
org.thymeleaf.spring4.view.ThymeleafViewResolver @ 0x782465040
| 80 | 252,632 | 0.16%
Total: 30 of 35,310 entries; 35,280 more
| | |
-----------------------------------------------------------------------------------------------------------------------------------------------
