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.
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
