On Fri, Dec 10, 2010 at 10:24 PM, Nuwan Bandara <[email protected]> wrote:
> Hi Victor, > > I have looked in to the QSL log you have sent. One issue I saw was that > versioning is enabled in the registry, so for each select operation for a > gadget xml or any other property fetch, there will be an associated select > query to get version data. > > You can disable versioning in registry by adding the parameters to the > registry.xml > > <versionResourcesOnChange>false</versionResourcesOnChange> > > <!-- NOTE: You can edit the options under "StaticConfiguration" only > before the > startup. --> > <staticConfiguration> > <versioningProperties>false</versioningProperties> > <versioningComments>false</versioningComments> > <versioningTags>false</versioningTags> > <versioningRatings>false</versioningRatings> > </staticConfiguration> > > Other than this, All other queries are standard ones and there are no > anomalies. > No anomalies as of latest GS release. But we are also re-thinking on some aspects of database access. So future releases will have some definite improvements in this area. /sumedha > > Thanks & Regards, > /Nuwan > > > 2010/12/10 Víctor Álvarez <[email protected]> > > Any new about this?? >> >> we have a huge load on the mysql due to this, and it reflects on GS >> Threads pending to the myslq response, and pains the GS CPU to the 200% with >> a very low index of concurrent connections. >> >> Thanks in advance >> >> >> On Sat, Dec 4, 2010 at 5:52 AM, Senaka Fernando <[email protected]> wrote: >> >>> >>> >>> On Sat, Dec 4, 2010 at 10:10 AM, Afkham Azeez <[email protected]> wrote: >>> >>>> Damitha, >>>> Can you profile GS server and verify why this is happening? >>>> >>> >>> +1. >>> >>> Thanks, >>> Senaka. >>> >>>> >>>> Azeez >>>> >>>> 2010/12/3 Víctor Álvarez <[email protected]> >>>> >>>>> Hello, >>>>> i've made a simple login to the administration panel on Gadget >>>>> server... >>>>> >>>>> on the mysql logs... there are more than 900 select querys exectued >>>>> during the login...you can see the log file. >>>>> >>>>> >>>>> you can see repeated selects : >>>>> >>>>> 15 times : >>>>> >>>>> SELECT REG_VERSION FROM REG_RESOURCE WHERE REG_PATH_ID=1 AND REG_NAME >>>>> IS NULL AND REG_TENANT_ID=0 >>>>> >>>>> 8 times >>>>> SELECT REG_MEDIA_TYPE, REG_CREATOR, REG_CREATED_TIME, REG_LAST_UPDATOR, >>>>> REG_LAST_UPDATED_TIME, REG_VERSION, REG_DESCRIPTION, REG_CONTENT_ID FROM >>>>> REG_RESOURCE WHERE REG_PATH_ID=4 AND REG_NAME IS NULL AND REG_TENANT_ID=0 >>>>> >>>>> 15 times: >>>>> SELECT REG_PATH_ID FROM REG_PATH WHERE >>>>> REG_PATH_VALUE='/_system/config/repository/components/org.wso2.carbon.governance/configuration/services/service' >>>>> AND REG_TENANT_ID=0 >>>>> >>>>> 10 veces: >>>>> SELECT UM_ROLE_NAME FROM UM_HYBRID_USER_ROLE, UM_HYBRID_ROLE WHERE >>>>> UM_USER_NAME='victor.alvarez' AND >>>>> UM_HYBRID_USER_ROLE.UM_ROLE_ID=UM_HYBRID_ROLE.UM_ID AND >>>>> UM_HYBRID_USER_ROLE.UM_TENANT_ID=0 AND UM_HYBRID_ROLE.UM_TENANT_ID=0 >>>>> >>>>> 6 times: >>>>> SELECT REG_VERSION FROM REG_RESOURCE WHERE REG_PATH_ID=19 AND >>>>> REG_NAME='gadget-13' AND REG_TENANT_ID=0 >>>>> >>>>> >>>>> It shouldn't be normal to make this hard work over the myslq on every >>>>> simple login... >>>>> >>>>> I've checked too during the load of the main page of the gadget server, >>>>> and it produce hundreds of selects too... >>>>> >>>>> any idea? is this normal? >>>>> >>>>> Thanks in advance >>>>> >>>>> -- >>>>> Víctor Álvarez >>>>> Incoming IT www.incomingIT.com >>>>> www.twitter.com/incomingIT >>>>> Escribiendo en y sobre Accesibilidad Web: >>>>> http://accesibilidad.blogspot.com >>>>> >>>>> >>>>> >>>>> _______________________________________________ >>>>> Carbon-dev mailing list >>>>> [email protected] >>>>> https://wso2.org/cgi-bin/mailman/listinfo/carbon-dev >>>>> >>>>> >>>> >>>> >>>> -- >>>> *Afkham Azeez* >>>> Senior Software Architect & Senior Manager; WSO2, Inc.; http://wso2.com >>>> , >>>> * >>>> * >>>> *Member; Apache Software Foundation; >>>> **http://www.apache.org/*<http://www.apache.org/> >>>> * >>>> email: **[email protected]* <[email protected]>* cell: +94 77 3320919 >>>> blog: **http://blog.afkham.org* <http://blog.afkham.org>* >>>> twitter: >>>> **http://twitter.com/afkham_azeez*<http://twitter.com/afkham_azeez> >>>> * >>>> linked-in: **http://lk.linkedin.com/in/afkhamazeez* >>>> * >>>> * >>>> *Lean . Enterprise . Middleware* >>>> >>>> >>>> _______________________________________________ >>>> Carbon-dev mailing list >>>> [email protected] >>>> https://wso2.org/cgi-bin/mailman/listinfo/carbon-dev >>>> >>>> >>> >>> >>> -- >>> *Senaka Fernando* >>> Associate Technical Lead & Product Manager - WSO2 G-Reg; >>> 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://www.linkedin.com/in/senakafernando >>> >>> *Lean . Enterprise . Middleware >>> >>> >>> _______________________________________________ >>> Carbon-dev mailing list >>> [email protected] >>> https://wso2.org/cgi-bin/mailman/listinfo/carbon-dev >>> >>> >> >> >> -- >> Víctor Álvarez >> Incoming IT www.incomingIT.com >> www.twitter.com/incomingIT >> Escribiendo en y sobre Accesibilidad Web: >> http://accesibilidad.blogspot.com >> >> >> >> _______________________________________________ >> Carbon-dev mailing list >> [email protected] >> https://wso2.org/cgi-bin/mailman/listinfo/carbon-dev >> >> > > > -- > Thanks & Regards, > > Nuwan Bandara > > WSO2 Inc. | http://wso2.com > lean . enterprise . middleware > > http://www.nuwanbando.com > > <http://www.nuwanbando.com/> > > _______________________________________________ > Carbon-dev mailing list > [email protected] > https://wso2.org/cgi-bin/mailman/listinfo/carbon-dev > >
_______________________________________________ Carbon-dev mailing list [email protected] https://wso2.org/cgi-bin/mailman/listinfo/carbon-dev
