API tools faq
paste
View difference between Paste ID: cFK1JsCN and 23Ygh17u
SHOW: | | - or go back to the newest paste.
1
Source code is available at http://symas.com/mdb/microbench/db_bench_sophia.cc. Build it using the LevelDB microbench source code.
2
3
Sophia

4
Date:           Sun Nov  3 07:41:52 2013

5
CPU:            4 * Intel(R) Core(TM)2 Extreme CPU Q9300  @ 2.53GHz

6
CPUCache:       6144 KB

7
Keys:       16 bytes each

8
Values:     100 bytes each (50 bytes after compression)

9
Entries:    1000000

10
RawSize:    110.6 MB (estimated)

11
FileSize:   62.9 MB (estimated)

12
------------------------------------------------

13
fillseqsync  :       5.360 micros/op;   20.6 MB/s  

14
132	/tmp/leveldbtest-1000/dbbench_sph-1

15
1806128	/tmp/leveldbtest-1000/dbbench_mdb-1

16
1806260	/tmp/leveldbtest-1000

17
fillrandsync :       5.337 micros/op;   20.7 MB/s     

18
129912	/tmp/leveldbtest-1000/dbbench_sph-2

19
129912	/tmp/leveldbtest-1000

20
fillseq      :       4.042 micros/op;   27.4 MB/s     

21
130804	/tmp/leveldbtest-1000/dbbench_sph-3

22
130804	/tmp/leveldbtest-1000

23
fillseqbatch :       1.635 micros/op;   67.7 MB/s     

24
130992	/tmp/leveldbtest-1000/dbbench_sph-4

25
130992	/tmp/leveldbtest-1000

26
fillrandom   :       5.119 micros/op;   21.6 MB/s     

27
129908	/tmp/leveldbtest-1000/dbbench_sph-5

28
129908	/tmp/leveldbtest-1000

29
fillrandbatch :       2.595 micros/op;   42.6 MB/s    

30
235940	/tmp/leveldbtest-1000/dbbench_sph-6

31
235940	/tmp/leveldbtest-1000

32
overwrite    :       5.320 micros/op;   20.8 MB/s     

33
189472	/tmp/leveldbtest-1000/dbbench_sph-6

34
189472	/tmp/leveldbtest-1000

35
readrandom   :       3.212 micros/op;                 

36
readseq      :       0.082 micros/op; 1353.5 MB/s     

37
readreverse  :       0.081 micros/op; 1370.0 MB/s 

38
39
MDB:    version MDB 0.9.6: (January 10, 2013)

40
Date:           Sun Nov  3 07:42:29 2013

41
CPU:            4 * Intel(R) Core(TM)2 Extreme CPU Q9300  @ 2.53GHz

42
CPUCache:       6144 KB

43
Keys:       16 bytes each

44
Values:     100 bytes each (50 bytes after compression)

45
Entries:    1000000

46
RawSize:    110.6 MB (estimated)

47
FileSize:   62.9 MB (estimated)

48
------------------------------------------------

49
fillseqsync  :       5.898 micros/op;   18.8 MB/s  

50
172	/tmp/leveldbtest-1000/dbbench_mdb-1

51
133520	/tmp/leveldbtest-1000/dbbench_sph-6

52
133692	/tmp/leveldbtest-1000

53
fillrandsync :       5.995 micros/op;   18.5 MB/s     

54
180836	/tmp/leveldbtest-1000/dbbench_mdb-2

55
180836	/tmp/leveldbtest-1000

56
fillseq      :       2.159 micros/op;   51.2 MB/s     

57
126680	/tmp/leveldbtest-1000/dbbench_mdb-3

58
126680	/tmp/leveldbtest-1000

59
fillseqbatch :       0.428 micros/op;  258.2 MB/s     

60
126680	/tmp/leveldbtest-1000/dbbench_mdb-4

61
126680	/tmp/leveldbtest-1000

62
fillrandom   :       4.197 micros/op;   26.4 MB/s     

63
180720	/tmp/leveldbtest-1000/dbbench_mdb-5

64
180720	/tmp/leveldbtest-1000

65
fillrandbatch :       3.472 micros/op;   31.9 MB/s    

66
192544	/tmp/leveldbtest-1000/dbbench_mdb-6

67
192544	/tmp/leveldbtest-1000

68
overwrite    :      10.839 micros/op;   10.2 MB/s     

69
192544	/tmp/leveldbtest-1000/dbbench_mdb-6

70
192544	/tmp/leveldbtest-1000

71
readrandom   :       1.326 micros/op;                 

72
readseq      :       0.071 micros/op; 1551.3 MB/s     

73-
readreverse  :       0.079 micros/op; 1397.5 MB/s
73+
readreverse  :       0.079 micros/op; 1397.5 MB/s

74
75
76
Using 100,000 byte values:

77
violino:/home/software/leveldb> ./db_bench_sophia --value_size=100000 --num=10000

78
Sophia 1.1

79
Date:           Sun Nov  3 13:07:41 2013

80
CPU:            4 * Intel(R) Core(TM)2 Extreme CPU Q9300  @ 2.53GHz

81
CPUCache:       6144 KB

82
Keys:       16 bytes each

83
Values:     100000 bytes each (50000 bytes after compression)

84
Entries:    10000

85
RawSize:    953.8 MB (estimated)

86
FileSize:   477.0 MB (estimated)

87
------------------------------------------------

88
fillseqsync  :     307.012 micros/op;  310.7 MB/s

89
980	/tmp/leveldbtest-1000/dbbench_sph-1

90
138264	/tmp/leveldbtest-1000/dbbench_sph-6

91
139244	/tmp/leveldbtest-1000

92
fillrandsync :     209.313 micros/op;  455.7 MB/s   

93
976888	/tmp/leveldbtest-1000/dbbench_sph-2

94
976888	/tmp/leveldbtest-1000

95
fillseq      :     222.895 micros/op;  427.9 MB/s   

96
976888	/tmp/leveldbtest-1000/dbbench_sph-3

97
976888	/tmp/leveldbtest-1000

98
fillseqbatch :     218.425 micros/op;  436.7 MB/s   

99
976888	/tmp/leveldbtest-1000/dbbench_sph-4

100
976888	/tmp/leveldbtest-1000

101
fillrandom   :     209.467 micros/op;  455.4 MB/s   

102
976888	/tmp/leveldbtest-1000/dbbench_sph-5

103
976888	/tmp/leveldbtest-1000

104
fillrandbatch :     219.503 micros/op;  434.5 MB/s  

105
976888	/tmp/leveldbtest-1000/dbbench_sph-6

106
976888	/tmp/leveldbtest-1000

107
overwrite    :     205.772 micros/op;  463.5 MB/s   

108
1953772	/tmp/leveldbtest-1000/dbbench_sph-6

109
1953772	/tmp/leveldbtest-1000

110
readrandom   :      20.275 micros/op;               

111
readseq      :       0.290 micros/op; 328351.9 MB/s 

112
readreverse  :       0.148 micros/op; 645785.3 MB/s 

113
114
violino:/home/software/leveldb> ./db_bench_mdb --value_size=100000 --num=10000

115
MDB:    version MDB 0.9.6: (January 10, 2013)

116
Date:           Sun Nov  3 13:08:16 2013

117
CPU:            4 * Intel(R) Core(TM)2 Extreme CPU Q9300  @ 2.53GHz

118
CPUCache:       6144 KB

119
Keys:       16 bytes each

120
Values:     100000 bytes each (50000 bytes after compression)

121
Entries:    10000

122
RawSize:    953.8 MB (estimated)

123
FileSize:   477.0 MB (estimated)

124
------------------------------------------------

125
fillseqsync  :     148.582 micros/op;  642.0 MB/s

126
1036	/tmp/leveldbtest-1000/dbbench_mdb-1

127
1953772	/tmp/leveldbtest-1000/dbbench_sph-6

128
1954808	/tmp/leveldbtest-1000

129
fillrandsync :      95.437 micros/op;  999.4 MB/s   

130
1000540	/tmp/leveldbtest-1000/dbbench_mdb-2

131
1000540	/tmp/leveldbtest-1000

132
fillseq      :      92.622 micros/op; 1029.8 MB/s   

133
1000380	/tmp/leveldbtest-1000/dbbench_mdb-3

134
1000380	/tmp/leveldbtest-1000

135
fillseqbatch :      90.041 micros/op; 1059.3 MB/s   

136
1000380	/tmp/leveldbtest-1000/dbbench_mdb-4

137
1000380	/tmp/leveldbtest-1000

138
fillrandom   :      93.742 micros/op; 1017.5 MB/s   

139
1000516	/tmp/leveldbtest-1000/dbbench_mdb-5

140
1000516	/tmp/leveldbtest-1000

141
fillrandbatch :      90.742 micros/op; 1051.1 MB/s  

142
1001352	/tmp/leveldbtest-1000/dbbench_mdb-6

143
1001352	/tmp/leveldbtest-1000

144
overwrite    :      51.941 micros/op; 1836.4 MB/s   

145
1001552	/tmp/leveldbtest-1000/dbbench_mdb-6

146
1001552	/tmp/leveldbtest-1000

147
readrandom   :       0.999 micros/op;               

148
readseq      :       0.082 micros/op; 1163314.9 MB/s

149
readreverse  :       0.079 micros/op; 1213786.4 MB/s
        

    


            


                                


        

            



                
    

        Public Pastes
    

    
            

    

                    

        

    





    


    
    
    
    
    
    
    
    




    


    



                

            We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.             OK, I Understand
        

    
                

            

                
                    
                
            

            

                Not a member of Pastebin yet?

                Sign Up, it unlocks many cool features!