Hi, >From what you describe, it could be a memory leak in the application. Could you post the number without using "grep .h2." But only a reproducible test case would show that.
Regards, Thomas On Wed, Oct 8, 2008 at 12:25 PM, vsaji <[EMAIL PROTECTED]> wrote: > > Hi Thomas, > > I could see the same topic has been posted earlier in this forum. I > have tried those resolutions as well. However, no luck. > > My application is a stand-alone multi threaded application which use > H2 in-memory DB to cache few records. > Currently I am having 7 tables in this database and the avg of record > count is 40 per table. > > The table gets accessed Max 100 times per second (only SELECT(98%) and > INSERT(2%)). The behavior of the application is, it queries a source > DB on every 5000 ms seconds and transforms the data using the cached > value then stores to a target DB. > > If you look at the below histo (produced out of JMAP), every interval > the memory consumption is going high and never comes down. > > I have tried keeping the CACHE_SIZE as 8192 and even tested with > 1.0.79 (last stable version). No changes in the result. > > PLS HELP. > > C:\app\jdk1.6.0\bin>jmap -histo 3488 | grep .h2. | head -10 > 12: 14793 710064 org.h2.expression.ExpressionColumn > 18: 1755 280800 org.h2.command.dml.Select > 22: 12714 203424 org.h2.util.ObjectArray > 26: 5134 177352 [Lorg.h2.value.Value; > 28: 4833 154656 org.h2.expression.Comparison > 30: 3582 143280 org.h2.expression.ExpressionVisitor > 31: 1755 140400 org.h2.table.TableFilter > 32: 1755 126360 org.h2.result.LocalResult > 34: 2129 119224 org.h2.expression.Function > 35: 4558 117208 [Lorg.h2.expression.Expression; > > > C:\app\jdk1.6.0\bin>jmap -histo 3488 | grep .h2. | head -10 > 8: 16058 770784 org.h2.expression.ExpressionColumn > 13: 1813 290080 org.h2.command.dml.Select > 16: 11155 178480 org.h2.util.ObjectArray > 17: 5552 177664 org.h2.expression.Comparison > 20: 1813 145040 org.h2.table.TableFilter > 21: 1858 133776 org.h2.jdbc.JdbcPreparedStatement > 22: 1813 130536 org.h2.result.LocalResult > 24: 3554 103616 [Lorg.h2.expression.Expression; > 25: 1813 101528 org.h2.jdbc.JdbcResultSet > 27: 1657 92792 org.h2.expression.Function > > > C:\app\jdk1.6.0\bin>jmap -histo 3488 | grep .h2. | head -10 > 11: 21077 1011696 org.h2.expression.ExpressionColumn > 18: 2447 391520 org.h2.command.dml.Select > 22: 17076 273216 org.h2.util.ObjectArray > 26: 7083 226656 org.h2.expression.Comparison > 28: 2447 195760 org.h2.table.TableFilter > 29: 2447 176184 org.h2.result.LocalResult > 30: 4401 176040 org.h2.expression.ExpressionVisitor > 31: 4842 171440 [Lorg.h2.value.Value; > 33: 2348 169056 org.h2.jdbc.JdbcPreparedStatement > 35: 2843 159208 org.h2.expression.Function > > > C:\app\jdk1.6.0\bin>jmap -histo 3488 | grep .h2. | head -10 > 9: 29904 1435392 org.h2.expression.ExpressionColumn > 15: 3362 537920 org.h2.command.dml.Select > 16: 21262 340192 org.h2.util.ObjectArray > 17: 10245 327840 org.h2.expression.Comparison > 19: 3362 268960 org.h2.table.TableFilter > 21: 3362 242064 org.h2.result.LocalResult > 22: 3355 241560 org.h2.jdbc.JdbcPreparedStatement > 26: 7105 200536 [Lorg.h2.expression.Expression; > 28: 3414 191184 org.h2.expression.Function > 29: 3362 188272 org.h2.jdbc.JdbcResultSet > > > C:\app\jdk1.6.0\bin>jmap -histo 3488 | grep .h2. | head -10 > 5: 39956 1917888 org.h2.expression.ExpressionColumn > 13: 4452 712320 org.h2.command.dml.Select > 15: 27632 442112 org.h2.util.ObjectArray > 16: 13718 438976 org.h2.expression.Comparison > 17: 4452 356160 org.h2.table.TableFilter > 18: 4460 321120 org.h2.jdbc.JdbcPreparedStatement > 19: 4452 320544 org.h2.result.LocalResult > 21: 9196 262872 [Lorg.h2.expression.Expression; > 24: 4466 250096 org.h2.expression.Function > 25: 4452 249312 org.h2.jdbc.JdbcResultSet > > > C:\app\jdk1.6.0\bin>jmap -histo 3488 | grep .h2. | head -10 > 8: 50740 2435520 org.h2.expression.ExpressionColumn > 13: 5708 913280 org.h2.command.dml.Select > 16: 37196 595136 org.h2.util.ObjectArray > 18: 17238 551616 org.h2.expression.Comparison > 22: 5708 456640 org.h2.table.TableFilter > 25: 5708 410976 org.h2.result.LocalResult > 26: 5580 401760 org.h2.jdbc.JdbcPreparedStatement > 28: 12852 352984 [Lorg.h2.expression.Expression; > 29: 6258 350448 org.h2.expression.Function > 32: 5708 319648 org.h2.jdbc.JdbcResultSet > > > C:\app\jdk1.6.0\bin>jmap -histo 3488 | grep .h2. | head -10 > 1: 70720 3394560 org.h2.expression.ExpressionColumn > 8: 7796 1247360 org.h2.command.dml.Select > 13: 24344 779008 org.h2.expression.Comparison > 14: 47127 754032 org.h2.util.ObjectArray > 16: 7796 623680 org.h2.table.TableFilter > 17: 7841 564552 org.h2.jdbc.JdbcPreparedStatement > 18: 7796 561312 org.h2.result.LocalResult > 19: 15560 452976 [Lorg.h2.expression.Expression; > 21: 7796 436576 org.h2.jdbc.JdbcResultSet > 22: 7657 428792 org.h2.expression.Function > > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
