Thanks for your response. I have increased my memory from 8 GB to 16 GB and trying to load the same amount of data and executing the same query. But still facing the same issue like CPU Utilization is more than 100% and its hangs off for couple of hours. Below are the details for the same. Please help me on this. JAVA_OPTS=-Xms512m -Xmx14336m
Tasks: 153 total, 1 running, 152 sleeping, 0 stopped, 0 zombie Cpu(s): 25.7%us, 0.1%sy, 0.0%ni, 74.2%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Mem: 16436116k total, 3322464k used, 13113652k free, 65260k buffers Swap: 0k total, 0k used, 0k free, 326288k cached PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 11545 kn40169 18 0 4420m 2.4g 9804 S 102.5 15.4 30:36.49 java Thanks, Neelima.Kaliki On Wednesday, May 1, 2013 7:02:40 PM UTC-4, Kartweel wrote: > You can try it and see if it works. -Xmx7000m or something like that. > But you may keep running out of memory. It might just be too much data to > fit. You might be better off trying using a file based database on an SSD? > > On 2/05/2013 12:03 AM, neelima kaliki wrote: > > 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]>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 [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. >>>> > >>>> > >>>> >>>> >>>> -- >>> 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. >>> >>> >>> >> >> -- > 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.
