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. >> > 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. >> >> >> -- > 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. > To post to this group, send email to [email protected]<javascript:> > . > To unsubscribe from this group, send email to > [email protected] <javascript:>. > For more options, visit this group at > 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. 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.
