performancelog

一个内存数据库的源代码这是服务器端还有客户端

======================== 20 July 2003 ===================

The compilation mode for both V5 and V4.3.7 is CFLAGS=-O2 
command: time Mserver -c perf.conf TST </dev/null >/dev/null
		orion(2x1.4Mh load 0)	
base		 0.29/0.14/0.16			
tst400a		 0.50/0.31/0.18	1M loop	 	
tst400a2	 0.59/0.42/0.17	1M loop inc	
tst400bHuge 	 1.16/0.93/0.23	100k count (io)	
tst400cHuge	 1.43/1.13/0.27	100k insert(io)	
tst400d		 1.35/1.06/0.29	1M insert tuple 
tst400e		 1.33/0.97/0.16	1M incr fcn     

tst901a		 1.8/1.4/0.4	[+] call	
tst901b		 4.4/4.1/0.27	[+] call	
======================== 29 May 2004 ===================
Same setup on Orion
The compilation mode for both V5 and V4.3.17 is CFLAGS=-O2 
command: time Mserver -c perf.conf TST </dev/null >/dev/null
		orion(2x1.4Mh load 0)	
base		 0.10/0.08/0.02			 0.80/0.14/0.68
tst400a		 0.25/0.23/0.02	1M loop	 	 2.80/2.14/0.66
tst400a2	 0.37/0.35/0.02	1M loop inc	
tst400bHuge 	 0.83/0.77/0.05	100k count (io)	11.69/10.77/0.85
tst400cHuge	 0.97/0.83/0.14	100k insert(io)	 5.25/ 4.21/0.98
tst400d		 0.73/0.72/0.01	1M insert tuple  9.04/ 8.34/0.67
tst400e		 1.02/1.01/0.01	1M incr fcn      4.66/ 4.01/0.60

tst901a		 0.98/0.93/0.05	[+] call	 8.95/ 8.24/0.68
tst901b		 4.26/4.13/0.13	[+] call	23.75/23.07/0.65
======================== July 5, 2004 ===================
Same setup on Orion
The compilation mode for both V5 and V4.3.17 is CFLAGS=-O2 
command: time Mserver -c perf.conf TST </dev/null >/dev/null
		orion(2x1.4Mh load 0)	
base		 0.10/0.08/0.02			 
tst400a		 0.20/0.18/0.02	1M loop	 	 
tst400a2	 0.33/0.32/0.01	1M loop inc	
tst400bHuge 	 0.77/0.70/0.06	100k count (io)	
tst400cHuge	 1.02/0.89/0.13	100k insert(io)	 
tst400d		 0.70/0.67/0.03	1M insert tuple  
tst400e		 1.02/1.01/0.01	1M incr fcn      

tst901a		 0.85/0.80/0.05	[+] call	 
tst901b		 4.12/4.07/0.05	[+] call	
======================== 7 Oct 2004 ===================
Setup on Orion with Fedora 2
The compilation mode for both V5 and V4.4 is CFLAGS=-O2 
command: time Mserver -c perf.conf TST </dev/null >/dev/null
		orion(2x1.4Mh load 0)		orion (V4.4)	
base		 0.19/0.10/0.08			 1.76/0.30/1.45
tst400a		 0.30/0.20/0.10	1M loop	 	 3.95/2.45/1.48
tst400a2	 0.42/0.33/0.09	1M loop inc	
tst400bHuge 	 0.90/0.74/0.15	100k count (io)	13.01/11.06/1.95
tst400cHuge	 1.16/0.93/0.22	100k insert(io)	 6.40/ 4.31/2.07
tst400d		 0.75/0.64/0.11	1M insert tuple  10.32/ 8.76/1.55
tst400e		 1.30/1.29/0.10	1M incr fcn      5.78/ 4.27/1.49

tst901a		 1.04/0.80/0.23	[+] call	 10.24/ 8.61/1.59
tst901b		 4.05/3.83/0.21	[+] call	26.04/24.72/1.72
======================== 7 Oct 2004 ===================
Setup on Orion with Fedora 2, and on P3 350Mhz with Fedora 1
The compilation mode for both V5 and V4.4 is CFLAGS=-O2 
command: time Mserver -c perf.conf TST </dev/null >/dev/null
		orion(2x1.4Mh load 0)		P3 350 V4.4
base		 0.19/0.10/0.08			 2.99/0.50/1.33	
tst400a		 0.30/0.20/0.10	1M loop	 	 9.71/8.19/1.45
tst400a2	 0.42/0.33/0.09	1M loop inc	
tst400bHuge 	 0.90/0.74/0.15	100k count (io)	55.38/37.87/2.71
tst400cHuge	 1.16/0.93/0.22	100k insert(io)	55.48/18.01/4.91
tst400d		 0.75/0.64/0.11	1M insert tuple 40.58/38.16/1.50
tst400e		 1.30/1.29/0.10	1M incr fcn     17.99/16.56/1.36

tst901a		 1.04/0.80/0.23	[+] call	 40.36/38.59/1.47
tst901b		 4.05/3.83/0.21	[+] call	112.45/110.42/1.73
======================== 15 Oct 2004 ===================
Setup on Shuttle with Fedora 2, and on AMD 
The compilation mode for both V5 and V4.4 is CFLAGS=-O2
command: time Mserver -c perf.conf TST </dev/null >/dev/null
                Version 4.99			Version 4.4
base             0.06/0.03/0.02                  0.06/0.03/0.01
tst400a          0.10/0.07/0.03 1M loop          0.70/0.69/0.01
tst400a2         		1M loop inc
tst400bHuge      0.30/0.25/0.05 100k count (io)  4.52/4.33/0.18
tst400cHuge      0.41/0.34/0.07 100k insert(io)  1.71/1.51/0.21 
tst400d          0.26/0.22/0.03 1M insert tuple  2.80/2.78/0.02
tst400e          0.43/0.41/0.02 1M incr fcn      1.45/1.44/0.01

tst901a          0.32/0.25/0.06 [+] call         2.76/2.72/0.03
tst901b          1.29/1.22/0.07 [+] call         7.44/7.39/0.05

======================== 16 Oct 2004 ===================
The situation on Ara with a new kernel
The compilation mode for both V5 and V4.4 is CFLAGS=-O2
command: time Mserver -c perf.conf TST </dev/null >/dev/null
                 V4.99 				V4.4
base             0.30/0.10/0.05                  1.44/0.18/1.21
tst400a          0.37/0.19/0.06 1M loop          3.60/2.19/1.35
tst400a2         0.53/0.37/0.04	1M loop inc	 0.93/0.17/0.71
tst400bHuge      0.97/0.72/0.10 100k count (io) 12.21/10.60/1.40
tst400cHuge      1.12/0.94/0.14 100k insert(io)  5.71/4.01/1.45 
tst400d          0.80/0.60/0.08 1M insert tuple  9.24/8.39/0.75
tst400e          1.37/1.2/0.04 1M incr fcn       4.91/4.06/0.78

tst901a          1.04/0.76/0.17 [+] call         9.31/8.37/0.84
tst901b          3.92/3.59/0.18 [+] call        24.45/23.02/0.83

======================== 16 Oct 2004 ===================
The situation on Stem with a new kernel
The compilation mode for both V5 and V4.4 is CFLAGS=-O2
command: time Mserver -c perf.conf TST </dev/null >/dev/null
                 V4.99 				V4.4
base             0.26/0.09/0.04                  0.81/0.14/0.61
tst400a          0.36/0.20/0.04 1M loop          2.73/2.07/0.61
tst400a2         0.53/0.35/0.04	1M loop inc	 0.81/0.15/0.61
tst400bHuge      0.97/0.70/0.09 100k count (io) 11.38/10.18/0.94
tst400cHuge      1.12/0.94/0.15 100k insert(io)  5.00/3.80/1.12 
tst400d          0.75/0.57/0.05 1M insert tuple  8.71/7.88/0.70
tst400e          1.32/1.15/0.04 1M incr fcn       4.91/4.06/0.78

tst901a          1.03/0.77/0.15 [+] call         8.87/8.02/0.68
tst901b          3.61/3.33/0.16 [+] call        22.77/21.96/0.70

======================== 17 Oct 2004 ===================
Running V4.4 using embedded features
Mserver --set monet_embedded=yes --dbinit="module(mapi);listen();"
and running tests via MapiClient
                 V4.4
base             0.16
tst400a          2.2 	1M loop         
tst400a2         	1M loop inc
tst400bHuge      13.6	100k count (io) 
tst400cHuge      4.8	100k insert(io)
tst400d          7.5	1M insert tuple
tst400e          4.2	1M incr fcn    

tst901a          7.5	[+] call      
tst901b          21.2	[+] call     

======================== 11 Nov 2004 ===================
Setup on Orion with Fedora 2 patched 
The compilation mode for both V5 and V4.4 is CFLAGS=-O2 
command: time Mserver -c perf.conf TST </dev/null >/dev/null
		orion(2x1.4Mh load 0)		 V4.5
base		 0.11/0.06/0.05			 0.81/0.15/0.65	
tst400a		 0.20/0.16/0.04	1M loop	 	 2.86/2.16/0.69
tst400a2	 0.34/0.29/0.05	1M loop inc	
tst400bHuge 	 0.82/0.71/0.10	100k count (io)	11.70/10.61/0.99
tst400cHuge	 1.03/0.89/0.14	100k insert(io)	 4.72/3.61/1.07
tst400d		 0.57/0.52/0.05	1M insert tuple  7.78/7.08/0.68
tst400e		 1.18/1.14/0.04	1M incr fcn      4.78/4.17/0.60

tst901a		 0.86/0.68/0.16	[+] call	 7.56/6.82/0.69
tst901b		 3.57/3.43/0.13	[+] call	20.10/19.18/0.81
======================== 20 dec 2004 ===================
Setup on Orion with bstream enhancement 
The compilation mode for both V5 is CFLAGS=-O2 
command: time Mserver -c perf.conf TST </dev/null >/dev/null
		orion(2x1.4Mh load 0)		 
base		 0.12/0.07/0.05			
tst400a		 0.22/0.17/0.04	1M loop	 	
tst400a2	 0.36/0.30/0.05	1M loop inc	
tst400bHuge 	 0.83/0.72/0.10	100k count (io)
tst400cHuge	 1.20/1.07/0.11	100k insert(io)	
tst400d		 0.66/0.59/0.07	1M insert tuple 
tst400e		 1.11/1.06/0.05	1M incr fcn     

tst901a		 0.90/0.74/0.15	[+] call	 
tst901b		 3.60/3.42/0.16	[+] call	
======================== 22 feb 2005 ===================
Setup on Orion just before refcount updates
The compilation mode for both V5 is CFLAGS=-O2 
command: time Mserver -c perf.conf TST </dev/null >/dev/null
		orion(2x1.4Mh load 0)		 
base		 0.12/0.07/0.05			
tst400a		 0.19/0.15/0.04	1M loop	 	
tst400a2	 0.34/0.31/0.02	1M loop inc	
tst400bHuge	 0.80/0.72/0.08	100k count (io)
tst400cHuge	 1.20/1.07/0.11	100k insert(io)	
tst400d		 0.66/0.59/0.07	1M insert tuple 
tst400e		 1.16/1.11/0.05	1M incr fcn     

tst901a		 0.78/0.65/0.12	[+] call	 
tst901b		 3.60/3.42/0.16	[+] call	
======================== 15 Apr 2005 ===================
Setup on Orion just after the parser requires full qualified names.
The compilation mode for both V5 is CFLAGS=-O2 
command: time Mserver -c perf.conf TST </dev/null >/dev/null
		orion(2x1.4Mh load 0)		 
base		 0.08/0.06/0.02			
tst400a		 0.20/0.18/0.02	1M loop	 	
tst400a2	 0.34/0.31/0.02	1M loop inc	
tst400bHuge  0.84/0.73/0.08	100k count (io)
tst400cHuge	 1.20/1.07/0.11	100k insert(io)	
tst400d		 1.09/1.00/0.07	1M insert tuple 
tst400e		 1.09/1.07/0.02	1M incr fcn     

tst901a		 1.20/1.16/0.12	[+] call	 
tst901b		 5.07/4.92/0.14	[+] call	
The performance drain is significant, most likely related to
correcting incref/fix/unfix. Callgrind traces collected in callgrind/20050415

======================== 17 Apr 2005 ===================
Setup on Orion just after the parser requires full qualified names
and optimization to reduce parsing and type checking.
The compilation mode for both V5 is CFLAGS=-O2 
command: time Mserver -c perf.conf TST </dev/null >/dev/null
		orion(2x1.4Mh load 0)		 
base		 0.08/0.06/0.02			
tst400a		 0.20/0.17/0.02	1M loop	 	
tst400a2	 0.34/0.31/0.02	1M loop inc	
tst400bHuge	 0.64/0.53/0.09	100k count (io)
tst400cHuge	 0.79/0.68/0.11	100k insert(io)	
tst400d		 1.07/1.02/0.04	1M insert tuple 
tst400e		 1.09/1.07/0.02	1M incr fcn     

tst901a		 1.20/1.08/0.12	[+] call	 
tst901b		 5.07/4.92/0.14	[+] call	
The performance drain is significant, most likely related to
correcting incref/fix/unfix. Callgrind traces collected in callgrind/20050415

======================== 20 Apr 2005 ===================
Setup on Orion just after the descriptor change and minor polishing of M5
The compilation mode for both V5 is CFLAGS=-O2 
command: time Mserver -c perf.conf TST </dev/null >/dev/null
		orion(2x1.4Mh load 0)		 
base		 0.08/0.06/0.02			
tst400a		 0.19/0.16/0.02	1M loop	 	
tst400a2	 0.34/0.31/0.02	1M loop inc	
tst400bHuge	 0.60/0.50/0.08	100k count (io)
tst400cHuge	 0.77/0.68/0.08	100k insert(io)	
tst400d		 0.96/0.89/0.08	1M insert tuple 
tst400e		 1.07/1.04/0.02	1M incr fcn     

tst901a		 1.17/1.00/0.10	[+] call	 
tst901b		 4.86/4.71/0.14	[+] call	
======================== 23 Apr 2005 ===================
Setup on Orion just after after BBP changes to reduce locks.
The compilation mode for both V5 is CFLAGS=-O2 
command: time Mserver -c perf.conf TST </dev/null >/dev/null
		orion(2x1.4Mh load 0)		 
base		 0.09/0.06/0.02			
tst400a		 0.19/0.16/0.02	1M loop	 	
tst400a2	 0.34/0.31/0.02	1M loop inc	
tst400bHuge	 0.59/0.49/0.08	100k count (io)
tst400cHuge	 0.73/0.64/0.08	100k insert(io)	
tst400d		 0.89/0.83/0.05	1M insert tuple 
tst400e		 1.07/1.04/0.02	1M incr fcn     

tst901a		 1.10/0.97/0.10	[+] call	 
tst901b		 4.63/4.44/0.16	[+] call	
======================== 24 Apr 2005 ===================
Setup on Orion just after after cpu savers and small bats
The compilation mode for both V5 is CFLAGS=-O2 
command: time Mserver -c perf.conf TST </dev/null >/dev/null
		orion(2x1.4Mh load 0)		 
base		 0.09/0.06/0.02			
tst400a		 0.18/0.16/0.02	1M loop	 	
tst400a2	 0.33/0.30/0.02	1M loop inc	
tst400bHuge	 0.56/0.48/0.08	100k count (io)
tst400cHuge	 0.73/0.65/0.08	100k insert(io)	
tst400d		 0.93/0.89/0.04	1M insert tuple 
tst400e		 1.07/1.04/0.02	1M incr fcn     

tst901a		 1.10/0.97/0.10	[+] call	 
tst901b		 4.63/4.44/0.16	[+] call	
======================== 5 May 2005 ===================
Setup on Orion after BAT reductions
The compilation mode for both V5 is CFLAGS=-O2 
command: time Mserver -c perf.conf TST </dev/null >/dev/null
		orion(2x1.4Mh load 0)		 
base		 0.08/0.055/0.02			
tst400a		 0.17/0.15/0.02	1M loop	 	
tst400a2	 0.30/0.28/0.02	1M loop inc	
tst400bHuge	 0.57/0.49/0.08	100k count (io)
tst400cHuge	 0.73/0.62/0.08	100k insert(io)	
tst400d		 0.91/0.87/0.04	1M insert tuple 
tst400e		 1.05/1.02/0.02	1M incr fcn     

tst901a		 1.10/0.97/0.10	[+] call	 
tst901b		 4.63/4.44/0.16	[+] call	
======================== 2 jul 2005 ===================
Setup on Orion before new machines arive, version 4.9 kernel
The compilation mode for both V5 is CFLAGS=-O2 
command: time Mserver -c perf.conf TST </dev/null >/dev/null
		orion(2x1.4Mh load 0)		 
base		 0.10/0.07/0.03	
tst400a		 0.19/0.16/0.03	1M loop	 	
tst400a2	 0.33/0.29/0.03	1M loop inc	
tst400bHuge	 0.58/0.49/0.09	100k count (io)
tst400cHuge	 0.76/0.66/0.09	100k insert(io)	
tst400d		 0.94/0.89/0.05	1M insert tuple 
tst400e		 0.95/0.92/0.03	1M incr fcn     

tst901a		 1.14/1.03/0.11	[+] call	 
tst901b		 4.85/4.68/0.16	[+] call