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
