Hi Ajith, Well, there still are some queries that are unwanted according to my understanding. For example, the query below sounds fishy. It seems to be some form of hack to get something running on the ESB.
2. SELECT REG_PATH_ID FROM REG_PATH WHERE REG_PATH_VALUE='/carbon/synapse-registries' AND REG_TENANT_ID=0 Also, there are number of queries fetching resource versions, which we need to reduce. AFAIU, none of these queries are related to the community features. So overall, we have better performance with caching, but it is not the best that we can get to. Anyway, we can focus on fixing this after 4.1.1, given the other more critical priorities right now. Thanks, Senaka. On Sat, Dec 10, 2011 at 10:07 AM, Ajith Vitharana <aji...@wso2.com> wrote: > > > On Sat, Dec 10, 2011 at 9:39 AM, Senaka Fernando <sen...@wso2.com> wrote: > >> Hi Ajith, >> >> The numbers do not suggest whether caching is working 100% of the time, >> or whether it is partial. A certain reduction indicates that this is at >> least partially working, but not totally. Would you mind reviewing the 38 >> select queries and determining what were the operations? If the 38 select >> calls resulted before the cache was populated, we are ok, but if it was >> not, we need to check what those were. >> > > Hi Senaka, > > This behavior happened in last few G-Reg releases too. > We are ONLY caching resource , and we are NOT Caching the resource related > comments , ratings , tags, dependencies , notifications .. etc. > Therefore caching didn't work 100% at all the time . > Those 38 quires happened to get community features that are related to > resources. > > Thanks > Ajith > > > >> Thanks, >> Senaka. >> >> >> 2011/12/9 Ajith Vitharana <aji...@wso2.com> >> >>> Hi Senaka, >>> >>> I did a quick test to verify the registry resource cache in latest test >>> pack. >>> >>> Steps >>> ====== >>> 1) Upload two resource to "/_system/config/tt" >>> 2) Calculate number of SQL queries .(enable and disable resource >>> caching from registry.xml) >>> >>> The results was 38 SELECT query with enable cache and 127 SELECT query >>> with disable cache. >>> Therefore resource level caching working in latest pack. >>> >>> Thanks >>> -Ajith >>> >>> >>> On Fri, Dec 9, 2011 at 7:35 PM, Ajith Vitharana <aji...@wso2.com> wrote: >>> >>>> >>>> >>>> On Fri, Dec 9, 2011 at 3:59 PM, Senaka Fernando <sen...@wso2.com>wrote: >>>> >>>>> Hi again, >>>>> >>>>> I believe that we tested these scenarios on 4.1.0, so I'm wondering >>>>> whether this is a regression issue that was introduced in 4.1.1? >>>>> >>>> >>>> Hi Senaka, >>>> >>>> SELECT REG_PATH_ID, REG_NAME FROM REG_RESOURCE WHERE >>>> (REG_RESOURCE.REG_TENANT_ID=0) AND >>>> REG_MEDIA_TYPE='application/vnd.wso2-service+xml' >>>> >>>> This SQL query has executed to get the path list of services and we >>>> are not getting individual resources from database when listing the >>>> services. Therefore this is not a bug. >>>> >>>> Thanks >>>> Ajith >>>> >>>> >>>> >>>> >>>> >>>> >>>>> >>>>> Thanks, >>>>> Senaka. >>>>> >>>>> >>>>> On Fri, Dec 9, 2011 at 3:58 PM, Senaka Fernando <sen...@wso2.com>wrote: >>>>> >>>>>> Hi Evanthika, >>>>>> >>>>>> Thanks for reporting and this needs to be definitely fixed. >>>>>> >>>>>> Thanks, >>>>>> Senaka. >>>>>> >>>>>> >>>>>> On Fri, Dec 9, 2011 at 3:36 PM, Evanthika Amarasiri < >>>>>> evanth...@wso2.com> wrote: >>>>>> >>>>>>> Hi, >>>>>>> >>>>>>> Found a blocker [1] in latest G-Reg packs. >>>>>>> >>>>>>> [1] - https://wso2.org/jira/browse/CARBON-11824 >>>>>>> >>>>>>> Regards, >>>>>>> Evanthika >>>>>>> >>>>>>> >>>>>>> On Fri, Dec 9, 2011 at 1:53 PM, Senaka Fernando <sen...@wso2.com>wrote: >>>>>>> >>>>>>>> Hi again, >>>>>>>> >>>>>>>> So here is the summary. We have changes to caching core that was >>>>>>>> introduced after 3.2.2. But, we also have some issues with regard to >>>>>>>> some >>>>>>>> fixes that were done in 3.2.2 not appearing in 3.2.3. So, can we first >>>>>>>> of >>>>>>>> all, review the difference below and decide whether 3.2.3 is >>>>>>>> up-to-date and >>>>>>>> if not fix that? After that's done, we need to include 3.2.3 into the >>>>>>>> build >>>>>>>> so that products will have it. >>>>>>>> >>>>>>>> Thanks, >>>>>>>> Senaka. >>>>>>>> >>>>>>>> >>>>>>>> On Fri, Dec 9, 2011 at 1:35 PM, Senaka Fernando <sen...@wso2.com>wrote: >>>>>>>> >>>>>>>>> Hi Asela, >>>>>>>>> >>>>>>>>> But there are differences in 3.2.2 and 3.2.3. How did that happen? >>>>>>>>> Also, somethings have been added to 3.2.3 which means we need to use >>>>>>>>> 3.2.3 >>>>>>>>> and not 3.2.2. >>>>>>>>> >>>>>>>>> +++++++++++++++++++++++++++++++++++ >>>>>>>>> $ diff -r 3.2.3 3.2.2 >>>>>>>>> diff -r >>>>>>>>> 3.2.3/src/main/java/org/wso2/carbon/caching/core/identity/IdentityCacheEntry.java >>>>>>>>> 3.2.2/src/main/java/org/wso2/carbon/caching/core/identity/IdentityCacheEntry.java >>>>>>>>> 32a33 >>>>>>>>> > private String[] cacheEntryArray; >>>>>>>>> 54a56,59 >>>>>>>>> > public IdentityCacheEntry(String[] cacheEntryArray) { >>>>>>>>> > this.cacheEntryArray = cacheEntryArray; >>>>>>>>> > } >>>>>>>>> > >>>>>>>>> 77a83,86 >>>>>>>>> > >>>>>>>>> > public String[] getCacheEntryArray() { >>>>>>>>> > return cacheEntryArray; >>>>>>>>> > } >>>>>>>>> diff -r >>>>>>>>> 3.2.3/src/main/java/org/wso2/carbon/caching/infinispan/InfinispanCacheManager.java >>>>>>>>> 3.2.2/src/main/java/org/wso2/carbon/caching/infinispan/InfinispanCacheManager.java >>>>>>>>> 88,98d87 >>>>>>>>> < >>>>>>>>> < >>>>>>>>> < String tcpConfigFile = >>>>>>>>> cacheConfiguration.getProperty("configuration.tcp.configFile"); >>>>>>>>> < if (tcpConfigFile != null) { >>>>>>>>> < Properties props = new Properties(); >>>>>>>>> < props.setProperty("configurationFile", >>>>>>>>> tcpConfigFile.replace("${carbon.home}", >>>>>>>>> < carbonHome)); >>>>>>>>> < log.debug("Setting infinispan tcp configuration >>>>>>>>> file"); >>>>>>>>> < globalConfiguration.setTransportProperties(props); >>>>>>>>> < } >>>>>>>>> < >>>>>>>>> 171d159 >>>>>>>>> < configuration.setUseLockStriping(false); >>>>>>>>> +++++++++++++++++++++++++++++++++++ >>>>>>>>> >>>>>>>>> Thanks, >>>>>>>>> Senaka. >>>>>>>>> >>>>>>>>> >>>>>>>>> On Fri, Dec 9, 2011 at 12:46 PM, Hasini Gunasinghe < >>>>>>>>> has...@wso2.com> wrote: >>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> On Fri, Dec 9, 2011 at 12:30 PM, Asela Pathberiya <as...@wso2.com >>>>>>>>>> > wrote: >>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> On Fri, Dec 9, 2011 at 11:57 AM, Senaka Fernando < >>>>>>>>>>> sen...@wso2.com> wrote: >>>>>>>>>>> >>>>>>>>>>>> Hi Asela, >>>>>>>>>>>> >>>>>>>>>>>> I see that 3.2.2 version of >>>>>>>>>>>> src/main/java/org/wso2/carbon/caching/core/identity/IdentityCacheEntry.java >>>>>>>>>>>> have differences over the 3.2.3 version. Can you sort these out >>>>>>>>>>>> and also >>>>>>>>>>>> add the 3.2.3 version of caching.core into the mainstream build? >>>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> I am sorry. IdentityCacheEntry class has not been changed after Oct >>>>>>>>>>> 17 (before the 3.2.2 release). Identity components are >>>>>>>>>>> still referring to the 3.2.2 caching core. May be 3.2.3 caching >>>>>>>>>>> core has >>>>>>>>>>> been created before 3.2.2 release or old revision. >>>>>>>>>>> >>>>>>>>>>> +1, it is an issue with 3.2.3 version, not with 3.2.2 version. >>>>>>>>>> >>>>>>>>>> Thanks, >>>>>>>>>> Hasini. >>>>>>>>>> >>>>>>>>>> Thanks, >>>>>>>>>>> Asela. >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> Thanks, >>>>>>>>>>>> Senaka. >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> On Fri, Dec 9, 2011 at 11:49 AM, Hasini Gunasinghe < >>>>>>>>>>>> has...@wso2.com> wrote: >>>>>>>>>>>> >>>>>>>>>>>>> Hi, >>>>>>>>>>>>> >>>>>>>>>>>>> In 3.2.3 branch, there is caching.core 3.2.3 version. >>>>>>>>>>>>> I see two issues with that: >>>>>>>>>>>>> 1. It is not included in latest product packs at [1], >>>>>>>>>>>>> 2. Seems like it is not a latest copy of 3.2.2 release.. so >>>>>>>>>>>>> some of the commits that has gone to 3.2.2 are not in 3.2.3 >>>>>>>>>>>>> component of it. >>>>>>>>>>>>> >>>>>>>>>>>>> I think this also should be fixed before the code freeze. >>>>>>>>>>>>> Would be great if some one who has been working with caching.core >>>>>>>>>>>>> 3.2.3 >>>>>>>>>>>>> component can please look into it. >>>>>>>>>>>>> >>>>>>>>>>>>> [1] >>>>>>>>>>>>> http://builder1.us1.wso2.org/~carbon320/releases/carbon/3.2.3/2011-12-07_05-46-09/ >>>>>>>>>>>>> >>>>>>>>>>>>> Thanks, >>>>>>>>>>>>> Hasini. >>>>>>>>>>>>> >>>>>>>>>>>>> On Fri, Dec 9, 2011 at 11:00 AM, Sumedha Rubasinghe < >>>>>>>>>>>>> sume...@wso2.com> wrote: >>>>>>>>>>>>> >>>>>>>>>>>>>> G-Reg is having 8 blockers still. Senaka will reply on the >>>>>>>>>>>>>> possibility of completion. >>>>>>>>>>>>>> /sumedha >>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>>> On Fri, Dec 9, 2011 at 10:26 AM, Prabath Siriwardena < >>>>>>>>>>>>>> prab...@wso2.com> wrote: >>>>>>>>>>>>>> >>>>>>>>>>>>>>> Hi folks, >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> Carbon 3.2.3 branch will be frozen at 6 PM IST today.... >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> -- >>>>>>>>>>>>>>> Thanks & Regards, >>>>>>>>>>>>>>> Prabath >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> http://blog.facilelogin.com >>>>>>>>>>>>>>> http://RampartFAQ.com >>>>>>>>>>>>>>> _______________________________________________ >>>>>>>>>>>>>>> Carbon-dev mailing list >>>>>>>>>>>>>>> Carbon-dev@wso2.org >>>>>>>>>>>>>>> http://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev >>>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>>> _______________________________________________ >>>>>>>>>>>>>> Carbon-dev mailing list >>>>>>>>>>>>>> Carbon-dev@wso2.org >>>>>>>>>>>>>> http://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev >>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> _______________________________________________ >>>>>>>>>>>>> Carbon-dev mailing list >>>>>>>>>>>>> Carbon-dev@wso2.org >>>>>>>>>>>>> http://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> -- >>>>>>>>>>>> *Senaka Fernando* >>>>>>>>>>>> Product Manager - WSO2 Governance Registry; >>>>>>>>>>>> Associate Technical Lead; WSO2 Inc.; http://wso2.com* >>>>>>>>>>>> Member; Apache Software Foundation; http://apache.org >>>>>>>>>>>> >>>>>>>>>>>> E-mail: senaka AT wso2.com >>>>>>>>>>>> **P: +1 408 754 7388; ext: 51736*; *M: +94 77 322 1818 >>>>>>>>>>>> Linked-In: http://linkedin.com/in/senakafernando >>>>>>>>>>>> >>>>>>>>>>>> *Lean . Enterprise . Middleware >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> _______________________________________________ >>>>>>>>>>> Carbon-dev mailing list >>>>>>>>>>> Carbon-dev@wso2.org >>>>>>>>>>> http://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> -- >>>>>>>>> *Senaka Fernando* >>>>>>>>> Product Manager - WSO2 Governance Registry; >>>>>>>>> Associate Technical Lead; WSO2 Inc.; http://wso2.com* >>>>>>>>> Member; Apache Software Foundation; http://apache.org >>>>>>>>> >>>>>>>>> E-mail: senaka AT wso2.com >>>>>>>>> **P: +1 408 754 7388; ext: 51736*; *M: +94 77 322 1818 >>>>>>>>> Linked-In: http://linkedin.com/in/senakafernando >>>>>>>>> >>>>>>>>> *Lean . Enterprise . Middleware >>>>>>>>> >>>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> -- >>>>>>>> *Senaka Fernando* >>>>>>>> Product Manager - WSO2 Governance Registry; >>>>>>>> Associate Technical Lead; WSO2 Inc.; http://wso2.com* >>>>>>>> Member; Apache Software Foundation; http://apache.org >>>>>>>> >>>>>>>> E-mail: senaka AT wso2.com >>>>>>>> **P: +1 408 754 7388; ext: 51736*; *M: +94 77 322 1818 >>>>>>>> Linked-In: http://linkedin.com/in/senakafernando >>>>>>>> >>>>>>>> *Lean . Enterprise . Middleware >>>>>>>> >>>>>>>> >>>>>>>> _______________________________________________ >>>>>>>> Carbon-dev mailing list >>>>>>>> Carbon-dev@wso2.org >>>>>>>> http://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev >>>>>>>> >>>>>>>> >>>>>>> >>>>>>> _______________________________________________ >>>>>>> Carbon-dev mailing list >>>>>>> Carbon-dev@wso2.org >>>>>>> http://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev >>>>>>> >>>>>>> >>>>>> >>>>>> >>>>>> -- >>>>>> *Senaka Fernando* >>>>>> Product Manager - WSO2 Governance Registry; >>>>>> Associate Technical Lead; WSO2 Inc.; http://wso2.com* >>>>>> Member; Apache Software Foundation; http://apache.org >>>>>> >>>>>> E-mail: senaka AT wso2.com >>>>>> **P: +1 408 754 7388; ext: 51736*; *M: +94 77 322 1818 >>>>>> Linked-In: http://linkedin.com/in/senakafernando >>>>>> >>>>>> *Lean . Enterprise . Middleware >>>>>> >>>>>> >>>>> >>>>> >>>>> -- >>>>> *Senaka Fernando* >>>>> Product Manager - WSO2 Governance Registry; >>>>> Associate Technical Lead; WSO2 Inc.; http://wso2.com* >>>>> Member; Apache Software Foundation; http://apache.org >>>>> >>>>> E-mail: senaka AT wso2.com >>>>> **P: +1 408 754 7388; ext: 51736*; *M: +94 77 322 1818 >>>>> Linked-In: http://linkedin.com/in/senakafernando >>>>> >>>>> *Lean . Enterprise . Middleware >>>>> >>>>> >>>>> _______________________________________________ >>>>> Carbon-dev mailing list >>>>> Carbon-dev@wso2.org >>>>> http://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev >>>>> >>>>> >>>> >>> >>> _______________________________________________ >>> Carbon-dev mailing list >>> Carbon-dev@wso2.org >>> http://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev >>> >>> >> >> >> -- >> *Senaka Fernando* >> Product Manager - WSO2 Governance Registry; >> Associate Technical Lead; WSO2 Inc.; http://wso2.com* >> Member; Apache Software Foundation; http://apache.org >> >> E-mail: senaka AT wso2.com >> **P: +1 408 754 7388; ext: 51736*; *M: +94 77 322 1818 >> Linked-In: http://linkedin.com/in/senakafernando >> >> *Lean . Enterprise . Middleware >> >> >> _______________________________________________ >> Carbon-dev mailing list >> Carbon-dev@wso2.org >> http://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev >> >> > > _______________________________________________ > Carbon-dev mailing list > Carbon-dev@wso2.org > http://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev > > -- *Senaka Fernando* Product Manager - WSO2 Governance Registry; Associate Technical Lead; WSO2 Inc.; http://wso2.com* Member; Apache Software Foundation; http://apache.org E-mail: senaka AT wso2.com **P: +1 408 754 7388; ext: 51736*; *M: +94 77 322 1818 Linked-In: http://linkedin.com/in/senakafernando *Lean . Enterprise . Middleware
_______________________________________________ Carbon-dev mailing list Carbon-dev@wso2.org http://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev
