Is there any way I can run multiple H2 instances on one
machine and load balance them to see if it helps my
concurrent issue?
-Sri
On Wednesday, January 30, 2013 1:11:27 PM UTC-8, Sri wrote:
I had added all necessary indexes required for my
queries and they perform very well.
It's been performing very good with single/few
user/thread and is getting degraded as I add more
concurrent users/threads.
I had also profiled usingbuilt-in profiler and queries
were taking longer as I added more concurrent users/threads.
-Sri
On Wednesday, January 30, 2013 12:55:26 PM UTC-8, Thomas
Mueller wrote:
Hi,
> I tied using in-memory db doesn't improve the
performance at all.
Did you read the performance docs yet -
http://h2database.com/html/performance.html
<http://h2database.com/html/performance.html> ?
Specially the built-in profiler and indexes.
> LOG=0, LOCK_MODE=0 and FILE_LOCK=NO has any effect
on the performance?
Not if indexes are missing, queries are slow and so
on. LOG=0 might double performance, but that's it.
lock mode and file lock don't typically improve
performance, they are just dangerous.
Regards,
Thomas
On Wed, Jan 30, 2013 at 8:53 PM, Sri
<[email protected]> wrote:
I tied using in-memory db doesn't improve the
performance at all. Both in-memory and server
have similar turn around times.
I was looking at some of the H2 documentation
and came across below one. As I mentioned
earlier DB is only for reads so by doing LOG=0,
LOCK_MODE=0 and FILE_LOCK=NO has any effect on
the performance?
"Some features are known to be dangerous, *they
are only supported for situations where
performance is more important than reliability*.
Those dangerous features are:
* Disabling the transaction log or
FileDescriptor.sync() using LOG=0 or LOG=1.
* Using the transaction isolation level
|READ_UNCOMMITTED| (|LOCK_MODE 0|) while at
the same time using multiple connections.
* Disabling database file protection using
(setting |FILE_LOCK| to |NO| in the database
URL).
* Disabling referential integrity using |SET
REFERENTIAL_INTEGRITY FALSE|."
-Sri
On Tuesday, November 13, 2012 7:32:35 PM UTC-8,
Kartweel wrote:
Other people might have some suggestions,
but I guess if you try it on a solid state
disk or just trial as an in memory database
and see if it performs faster.
Or you could also try it on a ram disk and
see if it improves performance. That way you
don't need to try any other hardware.
At least then you'll know the disk was the
bottleneck.
Ryan
On 14/11/2012 7:03 AM, Sri wrote:
Sorry I was looking into some other
things...now I got back to this..
How do we determine if disk io is capped?
I do see disk io is varying (up and down
from 40kb- 200kb and occasionally shoots up
to 950kb) all the time when I observed
windows resource monitor.
-Sri
On Friday, November 2, 2012 2:23:03 PM
UTC-7, Kartweel wrote:
Hi,
Makes sense to me. If cpu isn't the
issue (which I doubt it would be in a
database, but maybe the encryption adds
a lot of overhead?) then adding more
threads would increase the time
proportionally + synchronisation
overhead. Also there would be more work
for the disk seeking between all the
different locations.
So are you saying that disk io is
increasing with each thread you add? or
is it capped? both bandwidth and iops ?
On 3/11/2012 4:44 AM, Sri wrote:
Disk IO looks good too...can't seem to
find what is the issue...
On Thursday, November 1, 2012 2:36:21
PM UTC-7, Kartweel wrote:
How about disk io?, usually the
disk is the bottleneck.
On 2/11/2012 3:44 AM, Sri wrote:
> Hi,
>
> I am running H2 DB in server
mode and using it for read only. It's
> been performing very good with
single user/thread and the
performance
> is getting degraded as I add
more concurrent users/threads.
>
> Single user/thread --> about 100ms
> 10 users/threads --> about 230ms
> 15 users/threads --> about 320ms
> 20 users/threads --> about 440ms
> 25 users/threads --> about 550ms
> 40 users/threads --> about
900-1000ms
> 50 users/threads --> about
1300-1400ms
>
> Please see the attached
screenshot for CPU, heap and thread
> monitoring. I do not see the
problem of CPU being max out or not
> enough memory or not scaling
threads as I add more users.
>
> H2 Version:h2-1.3.166
> Url:
>
jdbc:h2:tcp://localhost:9092/<<DB
absolute
>
path>>;MULTI_THREADED=1;CACHE_SIZE=<<cashesize>>;CIPHER=AES;IFEXISTS=TRUE
>
> <<cashesize>> ==> tried
different values, defualt-16mb,
128mb, 256mb,
> 512mb and 1024mb (supplied in KB
though)
>
> FYI,
> Each thread is executing lot of
queries (around 15-20) and some of
> them are recursive queries (to
fetch heirachy data).
>
>
> Please let me know if anybody
run into the same problem and how did
> you resolve.
>
> Thanks in advance.
> -Sri
> --
> You received this message
because you are subscribed to the
Google
> Groups "H2 Database" group.
> To view this discussion on the
web visit
>
https://groups.google.com/d/msg/h2-database/-/hbZ9WV8cFWEJ
<https://groups.google.com/d/msg/h2-database/-/hbZ9WV8cFWEJ>.
> 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
<http://groups.google.com/group/h2-database?hl=en>.
--
You received this message because you
are subscribed to the Google Groups
"H2 Database" group.
To view this discussion on the web
visit
https://groups.google.com/d/msg/h2-database/-/njQ5VJHkPvEJ
<https://groups.google.com/d/msg/h2-database/-/njQ5VJHkPvEJ>.
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
<http://groups.google.com/group/h2-database?hl=en>.
--
You received this message because you are
subscribed to the Google Groups "H2
Database" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/h2-database/-/YscoajbGnT4J
<https://groups.google.com/d/msg/h2-database/-/YscoajbGnT4J>.
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
<http://groups.google.com/group/h2-database?hl=en>.
--
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
<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].
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>.
