topic permissionsAccessChace - shared vs. transactional problem in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/permissionsaccesschace-shared-vs-transactional-problem/m-p/172802#M125988 <HTML><HEAD></HEAD><BODY><SPAN>Hello,</SPAN><BR /><SPAN>Can someone explain the princip of transactional vs. shared caches concept in more detail? I have read the javadoc in TransactionalCache but its not fully clear to me. I am experencing following strange behaviour. </SPAN><BR /><BR /><SPAN>In my system there are about 25000 users. Because of this and because I needed to load all users in one query I had to significantly increase the system parameters&nbsp; system.acl.maxPermissionCheckTimeMillis=800000 and system.acl.maxPermissionChecks=80000. If i didn't I always obtained incomplete users list via lucene.&nbsp; It has the side-affect that loading the basic folder tree under company home takes more time, especially for the first time until the perimissions are cached. It would be ok, but it happens quite often that the permissionsAccessCache gets in fact cleared by some intensive queries, and it seems to be related to the transactional cache setting. </SPAN><BR /><BR /><SPAN>1. At one instant the state of permissionsAccessCache is following:</SPAN><BR /><PRE class="language-none line-numbers"><CODE><BR />16:49:13,981 DEBUG [alfresco.cache.permissionsAccessCache] <BR />===&gt;&nbsp; EHCache: [&nbsp; name = org.alfresco.cache.permissionsAccessCache status = STATUS_ALIVE eternal = true overflowToDisk = false maxElementsInMemory = 100000 maxElementsOnDisk = 0 memoryStoreEvictionPolicy = LRU timeToLiveSeconds = 0 timeToIdleSeconds = 0 diskPersistent = false diskExpiryThreadIntervalSeconds = 120 cacheEventListeners:&nbsp; hitCount = 231726 memoryStoreHitCount = 231726 diskStoreHitCount = 0 missCountNotFound = 302882 missCountExpired = 0 ]<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Hit Ratio:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 43,35 percent&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Hit Count:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 231726 hits&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Miss Count:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 302882 misses&nbsp;&nbsp; <BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Deep Size:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 64,06 MB&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Current Count:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 64968 entries&nbsp; <BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Percentage used:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 64,97 percent&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Max Count:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100000 entries&nbsp; <BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Estimated maximum size:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 98,61 MB&nbsp;&nbsp;&nbsp;&nbsp; <BR />1<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>2. after that I invoke an intensive query like "search for all users", and after that the cache state is:</SPAN><BR /><PRE class="language-none line-numbers"><CODE><BR />16:57:20,082 DEBUG [alfresco.cache.permissionsAccessCache] <BR />===&gt;&nbsp; EHCache: [&nbsp; name = org.alfresco.cache.permissionsAccessCache status = STATUS_ALIVE eternal = true overflowToDisk = false maxElementsInMemory = 100000 maxElementsOnDisk = 0 memoryStoreEvictionPolicy = LRU timeToLiveSeconds = 0 timeToIdleSeconds = 0 diskPersistent = false diskExpiryThreadIntervalSeconds = 120 cacheEventListeners:&nbsp; hitCount = 399146 memoryStoreHitCount = 399146 diskStoreHitCount = 0 missCountNotFound = 390898 missCountExpired = 0 ]<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Hit Ratio:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 50,52 percent&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Hit Count:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 399146 hits&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Miss Count:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 390898 misses&nbsp;&nbsp; <BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Deep Size:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 19,62 MB&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Current Count:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20002 entries&nbsp; <BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Percentage used:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20,00 percent&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Max Count:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100000 entries&nbsp; <BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Estimated maximum size:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 98,09 MB&nbsp;&nbsp;&nbsp;&nbsp; <BR /><BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>That's quite annoying because there was about 88000 miss count increase, but finally the cache is loaded just with 20000 items - so in nearly empty. One would expect all the misses would be added into the cache, so it is full. I suspect it is caused by setting of permissionsAccessCache where it is set "maxCacheSize=20000" like:</SPAN><BR /><PRE class="language-none line-numbers"><CODE><BR />&lt;bean name="permissionsAccessCache" class="org.alfresco.repo.cache.TransactionalCache"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="sharedCache"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;ref bean="permissionsAccessSharedCache" /&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/property&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="cacheManager" &gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;ref bean="transactionalEHCacheManager" /&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/property&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;!– Eh cache area –&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="name"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;value&gt;org.alfresco.permissionsAccessTransactionalCache&lt;/value&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/property&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="maxCacheSize"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;value&gt;20000&lt;/value&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/property&gt;<BR />&nbsp;&nbsp; &lt;/bean&gt;<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>So the problem is, how to setup the cache so that the shared one is not cleared on heavy queries by the transactional. Can I freely increase the size of the transactional cache? It's stated in javadoc: " Because there is a limited amount of space available to the in-transaction caches…"&nbsp; – how it is limited? </SPAN><BR /><BR /><SPAN>Thanks for any commnets.</SPAN></BODY></HTML> Mon, 03 Mar 2008 18:15:48 GMT vycitalr 2008-03-03T18:15:48Z permissionsAccessChace - shared vs. transactional problem https://connect.hyland.com/t5/alfresco-archive/permissionsaccesschace-shared-vs-transactional-problem/m-p/172802#M125988 Hello,Can someone explain the princip of transactional vs. shared caches concept in more detail? I have read the javadoc in TransactionalCache but its not fully clear to me. I am experencing following strange behaviour. In my system there are about 25000 users. Because of this and because I needed t Mon, 03 Mar 2008 18:15:48 GMT https://connect.hyland.com/t5/alfresco-archive/permissionsaccesschace-shared-vs-transactional-problem/m-p/172802#M125988 vycitalr 2008-03-03T18:15:48Z Re: permissionsAccessChace - shared vs. transactional problem https://connect.hyland.com/t5/alfresco-archive/permissionsaccesschace-shared-vs-transactional-problem/m-p/172803#M125989 <HTML><HEAD></HEAD><BODY><SPAN>I'm not so sure your problem has anything to do with the transactional cache.&nbsp; I have imported a little over 1000 users into the Alfresco repository and noticed a major slow down in user lookup.&nbsp; Stepping through the code I've found that the Alfresco JCR implimentation has some major scaling issues.&nbsp; I started a thread on the issue </SPAN><A href="http://forums.alfresco.com/viewtopic.php?f=14&amp;t=11374&amp;hilit=many+database+query" rel="nofollow noopener noreferrer">here</A><SPAN> but haven't gotten much response.</SPAN></BODY></HTML> Wed, 12 Mar 2008 14:19:10 GMT https://connect.hyland.com/t5/alfresco-archive/permissionsaccesschace-shared-vs-transactional-problem/m-p/172803#M125989 bprucha 2008-03-12T14:19:10Z