db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Apache Wiki <wikidi...@apache.org>
Subject [Db-derby Wiki] Update of "Derby1961ResourceUsage" by KnutAndersHatlen
Date Thu, 19 Oct 2006 10:05:07 GMT
Dear Wiki user,

You have subscribed to a wiki page or wiki category on "Db-derby Wiki" for change notification.

The following page has been changed by KnutAndersHatlen:
http://wiki.apache.org/db-derby/Derby1961ResourceUsage

------------------------------------------------------------------------------
  
  === Results ===
  
- ==== Object allocation per module ====
+ ==== Object allocations ====
  
  These results have been found by running the JVM (Java SE 6.0 - build
  1.6.0-rc-b102) with the `-agentlib:hprof=heap=sites,...` option and
@@ -66, +66 @@

  || Data store     ||<style="text-align: right;"> 1099 B/tx ||<style="text-align:
right;"> 30 objs/tx ||<style="text-align: right;"> 1327 B/tx ||<style="text-align:
right;"> 36 objs/tx ||<style="text-align: right;"> 92658 B/tx ||<style="text-align:
right;"> 22960 objs/tx ||
  || Transaction control ||<style="text-align: right;"> 80 B/tx ||<style="text-align:
right;"> 3 objs/tx ||<style="text-align: right;">  136 B/tx ||<style="text-align:
right;"> 6 objs/tx ||<style="text-align: right;"> 80 B/tx ||<style="text-align:
right;"> 3 objs/tx ||
  
- ==== System calls per module ====
+ ==== System calls ====
  
  Results found by logging all system calls on the database server with DTrace.
  
@@ -82, +82 @@

  || Transaction control ||                                         ||                   
                     ||                        ||
  || Unknown             ||                                         ||                   
                     ||  0.5 scl/tx            ||
  
+ 
+ ==== Context switches ====
+ 
+ The results in the following table have been found by logging all
+ context switches on the database server with DTrace. There are two
+ kinds of context switches:
+ 
+   * voluntary context switches, which means the thread gives the CPU
+   to another thread voluntarily (e.g., blocking reads, calls to
+   `Object.wait()` or attempts to lock a monitor which is locked by
+   another thread)
+   * involuntary context switches, which means that a thread is
+   preempted by the scheduler (because its time quantum has expired)
+ 
+ All the numbers are context switches per transaction.
+ 
+ || '''Module'''        ||<-2> '''Single-record select (10 clients)''' ||<-2>
'''Single-record update (20 clients)''' ||<-2> '''Join (4 clients)''' ||
+ || ||<style="text-align: center;"> '''Voluntary''' ||<style="text-align: center;">
'''Involuntary''' ||<style="text-align: center;"> '''Voluntary''' ||<style="text-align:
center;"> '''Involuntary''' ||<style="text-align: center;"> '''Voluntary''' ||<style="text-align:
center;"> '''Involuntary'''||
+ || Network server      ||<style="text-align: center;">   2.0   ||<style="text-align:
center;">  0.0       ||<style="text-align: center;">   2.0      ||<style="text-align:
center;">     0.0    ||<style="text-align: center;">   2.0      ||<style="text-align:
center;">    0.0     ||
+ || JDBC                ||<style="text-align: center;">      ||<style="text-align:
center;">         ||<style="text-align: center;">         ||<style="text-align:
center;">         ||<style="text-align: center;">         ||<style="text-align:
center;">         ||
+ || Execution           ||<style="text-align: center;">      ||<style="text-align:
center;">         ||<style="text-align: center;">         ||<style="text-align:
center;">         ||<style="text-align: center;">    0.0     ||<style="text-align:
center;">  0.6       ||
+ || Access              ||<style="text-align: center;">      ||<style="text-align:
center;">         ||<style="text-align: center;">         ||<style="text-align:
center;">         ||<style="text-align: center;">    0.0     ||<style="text-align:
center;">  0.5       ||
+ || Lock manager        ||<style="text-align: center;">   0.4   ||<style="text-align:
center;">   0.1      ||<style="text-align: center;">   0.3      ||<style="text-align:
center;">  0.1       ||<style="text-align: center;">   7.3      ||<style="text-align:
center;">   2.9      ||
+ || Buffer manager      ||<style="text-align: center;">      ||<style="text-align:
center;">         ||<style="text-align: center;">         ||<style="text-align:
center;">         ||<style="text-align: center;">   0.1      ||<style="text-align:
center;">    0.2     ||
+ || Logging             ||<style="text-align: center;">      ||<style="text-align:
center;">         ||<style="text-align: center;">    1.6     ||<style="text-align:
center;">   0.3      ||<style="text-align: center;">         ||<style="text-align:
center;">         ||
+ || Data store          ||<style="text-align: center;">      ||<style="text-align:
center;">         ||<style="text-align: center;">         ||<style="text-align:
center;">         ||<style="text-align: center;">    0.0     ||<style="text-align:
center;">  0.6       ||
+ || Transaction control ||<style="text-align: center;">      ||<style="text-align:
center;">         ||<style="text-align: center;">         ||<style="text-align:
center;">         ||<style="text-align: center;">    0.0     ||<style="text-align:
center;">  0.1       ||
+ || Unknown             ||<style="text-align: center;">      ||<style="text-align:
center;">         ||<style="text-align: center;">    0.1  ||<style="text-align:
center;">   0.0   ||<style="text-align: center;">   0.8   ||<style="text-align:
center;">    0.0  ||
+ 
+ 
  More to come...
  

Mime
View raw message