So, if i increase my memory from 8GB, would i be able to resolve this issue? Thanks, Neelima.Kaliki
On Wednesday, May 1, 2013 12:00:58 PM UTC-4, [email protected] wrote: > AFAIK you are limiting the memory your VM will ever know about to 4g > with this: > > JAVA_OPTS=-Xms512m -Xmx4076m > > therefore this > > Mem: 8174516k total, 3465712k used, 4708804k free, > > does not mean that the VM could use the 4708804k you still have free. In > the eyes of the VM, you're out of memory: > > > On Wed, May 1, 2013 at 11:53 AM, neelima kaliki > <[email protected]<javascript:> > > wrote: > >> Thanks for your reply. >> >> Below are the memory details of the linux box when the query is >> executing. >> >> >> Cpu(s): 25.0%us, 0.2%sy, 0.0%ni, 74.7%id, 0.0%wa, 0.0%hi, 0.1%si, >> 0.0%st >> Mem: 8174516k total, 3465712k used, 4708804k free, 148888k buffers >> Swap: 0k total, 0k used, 0k free, 1096344k cached >> PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND >> 3478 kn40169 17 0 2409m 1.6g 9808 S 100.9 20.0 19:40.60 java >> >> JVM parameters for the H2 is as below: >> >> JAVA_OPTS=-Xms512m -Xmx4076m >> >> I could not see any exceptions in the logs. There is almost 4GB free >> memory available in that box as well. Please guide me further. >> >> Thanks, >> >> Neelima.Kaliki >> >> >> On Wednesday, May 1, 2013 10:57:50 AM UTC-4, Kartweel wrote: >> >>> Sounds like you are running out of memory. >>> >>> What is the memory usage of the java process? and what JVM parameters >>> are you using? >>> >>> You'd expect CPU to be maxed out for an in-memory database. Something >>> would have to max out. >>> >>> >>> On 1/05/2013 9:40 PM, neelima kaliki wrote: >>> > Below are my System details: >>> > OS: Linux >>> > Processors : 4 >>> > Memory: 8 GB >>> > Below are my Application details: >>> > Tables: In-Memory tables >>> > Mode: Server/Embedded mode >>> > Data: Arround 10 Million records >>> > CPU utiliztion is more than 100% when a query is executing on huge >>> > records and the system just hangs on. After couple of hours, getting >>> > message as Database is closed and all my tables in Memory is getting >>> > dropped off. This keeps repeating every time. The problem is same in >>> > Server mode or Embedded mode. >>> > Response is normal for less number records in the memory tables. >>> > Please suggest to solve this issue. >>> > Thanks, >>> > Neelima.Kaliki >>> > -- >>> > 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 h2-database...@**googlegroups.com. >>> > To post to this group, send email to [email protected]. >>> > Visit this group at >>> > http://groups.google.com/**group/h2-database?hl=en<http://groups.google.com/group/h2-database?hl=en>. >>> > >>> >>> > For more options, visit >>> > https://groups.google.com/**groups/opt_out<https://groups.google.com/groups/opt_out>. >>> > >>> >>> > >>> > >>> >>> >>> -- >> 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] <javascript:>. >> To post to this group, send email to [email protected]<javascript:> >> . >> Visit this group at http://groups.google.com/group/h2-database?hl=en. >> For more options, visit https://groups.google.com/groups/opt_out. >> >> >> > > -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
