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.
If queries are running for a long time then you need to make sure you
have the right indexes for your queries.
--
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
I am using in-memory tables. Is indexes required in-memory tables as well?
I read in documentation that indexes are automatically used for in-memory
tables. Hence i have not created indexes. when i tried to create, i was
getting OutOfMemroy exception with 8GB memory. But i have not tried
Hi,
In-memory indexes are automatically used for in-memory databases
That should mean: for in-memory databases, if you create an index, then the
index is also kept in memory. But you still need to create the index.
Indexes are not automatically created.
Regards,
Thomas
On Fri, May 3, 2013 at
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
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
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, 14k buffers
Swap:0k total,0k used,
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:
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
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
10 matches
Mail list logo