Re: [Carbon-dev] 1 login ... more than 900 SELECT querys????

2010-12-10 Thread Sumedha Rubasinghe
On Fri, Dec 10, 2010 at 10:24 PM, Nuwan Bandara 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

Re: [Carbon-dev] 1 login ... more than 900 SELECT querys????

2010-12-10 Thread Nuwan Bandara
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

Re: [Carbon-dev] 1 login ... more than 900 SELECT querys????

2010-12-10 Thread Víctor Álvarez
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 wrote: > > > On S

Re: [Carbon-dev] 1 login ... more than 900 SELECT querys????

2010-12-03 Thread Senaka Fernando
On Sat, Dec 4, 2010 at 10:10 AM, Afkham Azeez wrote: > Damitha, > Can you profile GS server and verify why this is happening? > +1. Thanks, Senaka. > > Azeez > > 2010/12/3 Víctor Álvarez > >> Hello, >> i've made a simple login to the administration panel on Gadget server... >> >> on the mysql

Re: [Carbon-dev] 1 login ... more than 900 SELECT querys????

2010-12-03 Thread Afkham Azeez
Damitha, Can you profile GS server and verify why this is happening? Azeez 2010/12/3 Víctor Álvarez > 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 lo