[
https://issues.apache.org/jira/browse/OAK-1465?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13922559#comment-13922559
]
Stefan Egli commented on OAK-1465:
----------------------------------
I reran the CreateManyIndexedNodesTest on my macbook with the following
parameters:
* threadcount = 1 (although did see similar numbers with higher number of
threads, eg 10 or 20 threads)
* nodes per thread = 50
* parentcount = 100
* 40 loops: --concurrency
1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1
* homebrew-mongoD 2.2.0 on localhost
I see that:
* the benchmark runner is at 100-120% CPU
* the mongoD is at 30-35% only
Here's the result. The initial number of loops (N) is 112, which doesn't go in
a straight line south, but nevertheless, on average, N ends up lower in the 70s
range:
{code}
# CreateManyIndexedNodesTest C min 10% 50% 90% max
N
Oak-Mongo 1 143 159 178 194 428
112
Oak-Mongo 1 147 157 172 190 411
115
Oak-Mongo 1 141 152 165 185 450
118
Oak-Mongo 1 144 151 168 182 230
120
Oak-Mongo 1 144 155 172 197 972
107
Oak-Mongo 1 147 160 174 195 211
114
Oak-Mongo 1 150 162 179 197 704
109
Oak-Mongo 1 154 166 182 204 2660
79
Oak-Mongo 1 153 166 181 203 2116
93
Oak-Mongo 1 161 167 183 200 380
108
Oak-Mongo 1 164 172 186 204 1586
94
Oak-Mongo 1 164 175 188 212 459
104
Oak-Mongo 1 163 176 191 211 1058
100
Oak-Mongo 1 165 180 193 210 1459
93
Oak-Mongo 1 165 180 196 222 239
102
Oak-Mongo 1 171 179 209 1963 2893
35
Oak-Mongo 1 181 184 209 1483 2764
44
Oak-Mongo 1 178 184 197 237 2373
88
Oak-Mongo 1 180 188 200 238 478
96
Oak-Mongo 1 183 193 207 246 946
89
Oak-Mongo 1 185 196 209 247 1356
89
Oak-Mongo 1 192 198 216 240 277
92
Oak-Mongo 1 195 202 220 251 1133
84
Oak-Mongo 1 195 200 217 248 278
91
Oak-Mongo 1 199 207 219 255 1622
83
Oak-Mongo 1 208 213 228 255 767
84
Oak-Mongo 1 206 214 230 255 320
87
Oak-Mongo 1 207 217 245 290 1040
78
Oak-Mongo 1 210 219 247 297 860
75
Oak-Mongo 1 212 221 246 284 299
82
Oak-Mongo 1 207 220 245 298 935
77
Oak-Mongo 1 217 219 248 300 2502
71
Oak-Mongo 1 220 228 253 273 281
80
Oak-Mongo 1 212 224 253 304 1032
75
Oak-Mongo 1 213 224 250 300 1337
71
Oak-Mongo 1 218 227 254 292 397
79
Oak-Mongo 1 217 232 255 286 641
77
Oak-Mongo 1 225 231 257 299 1571
72
Oak-Mongo 1 229 234 258 284 309
78
Oak-Mongo 1 228 235 260 296 461
76
{code}
> performance degradation with growing index size on Oak-Mongo
> ------------------------------------------------------------
>
> Key: OAK-1465
> URL: https://issues.apache.org/jira/browse/OAK-1465
> Project: Jackrabbit Oak
> Issue Type: Bug
> Components: mongomk
> Affects Versions: 0.17.1
> Reporter: Stefan Egli
> Assignee: Alex Parvulescu
> Fix For: 0.19
>
> Attachments: CreateManyIndexedNodesTest.java
>
>
> Tested with an oak-snapshot of Monday Feb 24, 10AM EST.
> Noticed that when the amount of nodes indexed - eg wrt a particular property
> - the adding of nodes becomes slower and slower.
> Will attach a oak-run benchmark to underline this. Basically the scenario
> where this occurred was:
> * have a number of "level 1" nodes (eg 100)
> * under those "level 1" nodes, add a growing list of children, each with a
> property that is indexed (ie that index is actually growing and is probably
> causing the slowdown).
--
This message was sent by Atlassian JIRA
(v6.2#6252)
