db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Pertti Ylijukuri" <pertti.ylijuk...@gmail.com>
Subject How much derby need memory?
Date Wed, 28 Feb 2007 09:20:45 GMT
Hi!

I'am using derby nework server. I have started deby with following
properties:
derby.storage.pageCacheSize = 20000
derby.storage.pageSize = 4096
-Xmx200408k

I expect that derby need 20000 * 4096k = 80M memories.
Anyway sometimes derby throw java.lang.OutOfMemoryError Java heap space
XJ001.

How much I have to give memory for derby or is in derby memory leak?

This is derby memory dump using command jmap -histo [PID]

Attaching to process ID 354, please wait...
Debugger attached successfully.
Client compiler detected.
JVM version is 1.5.0_06-b05
Iterating over heap. This may take a while...
Object Histogram:

Size    Count    Class description
-------------------------------------------------------
86363952    81679    byte[]
68577936    1428707
org.apache.derby.impl.store.raw.data.StoredRecordHeader
30174120    1257255    org.apache.derby.impl.store.raw.data.RecordId
7299192    20000    org.apache.derby.impl.store.raw.data.StoredRecordHeader
[]
4104056    26653    char[]
3835968    19979    org.apache.derby.impl.store.raw.data.StoredPage
1898976    18365    * ConstMethodKlass
1159704    48321    org.apache.derby.iapi.types.SQLLongint
1028480    18365    * MethodKlass
890776    19608    * SymbolKlass
804000    1197    * ConstantPoolKlass
800160    20004    org.apache.derby.iapi.services.io.FormatIdInputStream
743680    11620    org.apache.derby.impl.store.access.btree.LeafControlRow
640128    20004    org.apache.derby.iapi.services.io.ArrayInputStream
628912    1197    * InstanceKlassKlass
575424    1096    * ConstantPoolCacheKlass
536592    22358    java.util.Hashtable$Entry
495216    20634    org.apache.derby.impl.services.cache.CachedItem
492504    12352    org.apache.derby.iapi.types.DataValueDescriptor[]
481560    20065    org.apache.derby.iapi.store.raw.PageKey
471936    19664    org.apache.derby.iapi.services.io.FormatIdOutputStream
471888    19662    org.apache.derby.iapi.services.io.ArrayOutputStream
403928    7213    org.apache.derby.impl.store.access.btree.index.B2I
321632    20102    java.util.zip.CRC32
265160    6723    int[]
246176    440    java.util.Hashtable$Entry[]
199480    1907    java.lang.Object[]
152592    6358    java.lang.String
148928    4654    org.apache.derby.iapi.store.raw.FetchDescriptor
131928    1299    short[]
122496    1392    java.lang.Class
114320    7145    org.apache.derby.impl.store.access.StorableFormatId
108672    1888    java.lang.Object[]
56544    186    * ObjArrayKlassKlass
48384    756    java.lang.reflect.Constructor
43488    560    java.util.HashMap$Entry[]
31056    800    java.lang.String[]
27888    498    org.apache.derby.iapi.types.TypeId
27776    868    org.apache.derby.catalog.types.TypeDescriptorImpl
26976    843    org.apache.derby.impl.services.uuid.BasicUUID
24576    768    org.apache.derby.impl.sql.GenericColumnDescriptor
23312    94    org.apache.derby.impl.sql.execute.ProjectRestrictResultSet
22200    555    java.util.HashMap
22152    923    java.util.LinkedList$Entry
21960    915    java.util.Vector
20520    57    org.apache.derby.impl.sql.execute.TableScanResultSet
17880    573    long[]
17376    724    org.apache.derby.catalog.types.BaseTypeIdImpl
16640    260    org.apache.derby.iapi.sql.dictionary.ColumnDescriptor
16416    57    org.apache.derby.impl.sql.execute.IndexRowToBaseRowResultSet
16400    410    java.util.Hashtable
16296    97    org.apache.derby.impl.store.raw.data.RAFContainer
14112    98    org.apache.derby.impl.sql.GenericPreparedStatement
13888    868    org.apache.derby.iapi.types.DataTypeDescriptor
..
....

Mime
View raw message