[jira] [Comment Edited] (OAK-1119) [MongoMK] Reduce number of calls made to Mongo DB when an Oak based application is restarted

["Chetan Mehrotra (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/OAK-1119?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13805356#comment-13805356 ] 

Chetan Mehrotra edited comment on OAK-1119 at 10/25/13 3:06 PM:
----------------------------------------------------------------

Analysis of Query logs reveals following stats

* Total queries - 20206
* Updates - 1179
* Creates - 78
* Find - 426
* Fetch Children - 18523

Note that when we fetch children we also populate the Document cache has number of finds would be low. 



was (Author: chetanm):
Analysis of Query logs reveals following stats

* Total queries - 20206
* Updates - 1179
* Creates - 78
* Find - 426
* Fetch Children - 18523

Note that when we fetch children we also populate the Document cache has number of finds would be low. Further following are the path for which children have been fetched

Number of unique paths/totalpaths = (425/9923)

|| Count || Path ||
| 174 | /etc |
| 173 | /var |
| 172 | /tmp |
| 171 | /libs |
| 171 | /rep:repoPolicy |
| 170 | / |
| 170 | /:async |
| 170 | /apps |
| 170 | /content |
| 170 | /oak:index |
| 169 | /jcr:system |
| 169 | /rep:policy |
| 167 | /home |
| 166 | /bin |
| 149 | /oak:index/slingResourceType |
| 149 | /oak:index/status |
| 148 | /oak:index/damS7watch |
| 148 | /oak:index/slingResource |
| 147 | /oak:index/cqKeywords |
| 147 | /oak:index/jcrLockOwner |
| 147 | /oak:index/slingVanityPath |
| 146 | /oak:index/authorizableId |
| 146 | /oak:index/cqDefaultFormFor |
| 146 | /oak:index/event.job.topic |
| 146 | /oak:index/nodetype |
| 146 | /oak:index/type |
| 145 | /oak:index/cqOwnerCanvasPage |
| 145 | /oak:index/damScene7ID |
| 145 | /oak:index/extensionType |
| 145 | /oak:index/jcrLanguage |
| 145 | /oak:index/lucene |
| 145 | /oak:index/principalName |
| 145 | /oak:index/slingAlias |
| 145 | /oak:index/uuid |
| 144 | /oak:index/cqCloudServiceConfigs |
| 144 | /oak:index/cqParentPath |
| 144 | /oak:index/cqVariantFamily |
| 144 | /oak:index/damResolvedPath |
| 144 | /oak:index/lockCreated |
| 143 | /oak:index/acPrincipalName |
| 143 | /oak:index/cqCugEnabled |
| 143 | /oak:index/cqMaster |
| 143 | /oak:index/cqTags |
| 142 | /oak:index/members |
| 76 | /oak:index/lucene/:data/_b_7.del |
| 75 | /oak:index/lucene/:data/_b.fnm |
| 75 | /oak:index/lucene/:data/_b_Lucene41_0.pos |
| 75 | /oak:index/lucene/:data/_b_Lucene41_0.tip |
| 74 | /oak:index/lucene/:data/_b.si |

> [MongoMK] Reduce number of calls made to Mongo DB when an Oak based application is restarted
> --------------------------------------------------------------------------------------------
>
>                 Key: OAK-1119
>                 URL: https://issues.apache.org/jira/browse/OAK-1119
>             Project: Jackrabbit Oak
>          Issue Type: Task
>          Components: mongomk
>            Reporter: Chetan Mehrotra
>            Assignee: Chetan Mehrotra
>         Attachments: queries-and-cache-entries.tar.gz
>
>
> Current restarting an Oak based application like Adobe CQ makes quite high number of calls to Mongo DB (~23000). We should try to minimize number of such calls by analyzing the usage of caches , types of queries etc



--
This message was sent by Atlassian JIRA
(v6.1#6144)