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, trh...@gmail.com 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
<neeli...@gmail.com <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
h2-da...@googlegroups.com.
> 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 h2-database...@googlegroups.com
<javascript:>.
To post to this group, send email to h2-da...@googlegroups.com
<javascript:>.
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 h2-database+unsubscr...@googlegroups.com.
To post to this group, send email to h2-database@googlegroups.com.
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 h2-database+unsubscr...@googlegroups.com.
To post to this group, send email to h2-database@googlegroups.com.
Visit this group at http://groups.google.com/group/h2-database?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
