From: Thomas K. <tkr...@gm...> - 2009-11-07 11:15:12
|
In SMW1.4.3 if the parameter $smwgQMaxSize is increased to 16 or more the system is not reacting anymore >> The whole MW page is dead. For my queries I need a quite high $smwgQMaxSize (about 50). Is there any solution to solve this issue? I wrote two questions about "Semantic compound query is not accepting more than 5 arguments" earlier. This issue is related to the $smwgQMaxSize-problem, so don´t waste time with it. Thanks for your support! Best regards, tkrueger73 <http://semantic-mediawiki.org/wiki/Help:Configuration#smwgQMaxSize> |
From: Gu <gu...@ya...> - 2009-11-07 14:54:07
|
I use a value of 24 for $smwgQMaxSize for quite some versions of SMW without problems (btw the SQFT extension automatically increases the value to 24 if its lower and the variable $sqftgAdjustSMWQMaxVals is set to true (default value is false) as otherwise some of my queries didn't work). I assume your problem has something to do with the memory available to MW resp. PHP. Try to increase it. I have in my LocalSettings.php: ini_set( 'memory_limit', '512M' ); Cheers, Gu --- On Sat, 11/7/09, Thomas Krueger <tkr...@gm...> wrote: > From: Thomas Krueger <tkr...@gm...> > Subject: [Semediawiki-user] SMW 1.4.3 parameter $smwgQMaxSize problem > To: sem...@li... > Date: Saturday, November 7, 2009, 12:15 PM > In SMW1.4.3 if the parameter > $smwgQMaxSize is increased to 16 or more the > system is not reacting anymore >> The whole MW page > is dead. > > For my queries I need a quite high $smwgQMaxSize > (about 50). Is there any > solution to solve this issue? > > I wrote two questions about "Semantic compound query is not > accepting more > than 5 arguments" earlier. This issue is related to the > $smwgQMaxSize-problem, so don´t waste time with it. > > Thanks for your support! > > Best regards, > > tkrueger73 > <http://semantic-mediawiki.org/wiki/Help:Configuration#smwgQMaxSize> > ------------------------------------------------------------------------------ > Let Crystal Reports handle the reporting - Free Crystal > Reports 2008 30-Day > trial. Simplify your report design, integration and > deployment - and focus on > what you do best, core application coding. Discover what's > new with > Crystal Reports now. http://p.sf.net/sfu/bobj-july > _______________________________________________ > Semediawiki-user mailing list > Sem...@li... > https://lists.sourceforge.net/lists/listinfo/semediawiki-user > |
From: Thomas K. <tkr...@gm...> - 2009-11-07 15:15:44
|
I tried ini_set( 'memory_limit', '512M' ); in local settings and also increased the memorylimit in php.ini from 20M to 256M. still the same problems. I found that, if a query with $smwgQMaxSize higher than 15 is done, the process "msqld" is staying at 100% cpu load all the time. Checking msqlyd with mtop, I found that for each query I had a threat in an endlessloop for more than one hour. It was impossible to kill this "crashed treads". Only solution was stopping and restarting the mysql server. I have no deep knowledge about SMW and mysql, but maybe my comments are helpfull for somebody with more experience. Thanks for helping me, tkrueger73 2009/11/7 Gu <gu...@ya...> > I use a value of 24 for $smwgQMaxSize for quite some versions of SMW > without problems (btw the SQFT extension automatically increases the value > to 24 if its lower and the variable $sqftgAdjustSMWQMaxVals is set to true > (default value is false) as otherwise some of my queries didn't work). > > I assume your problem has something to do with the memory available to MW > resp. PHP. Try to increase it. > I have in my LocalSettings.php: > ini_set( 'memory_limit', '512M' ); > > Cheers, > Gu > > --- On Sat, 11/7/09, Thomas Krueger <tkr...@gm...> wrote: > > > From: Thomas Krueger <tkr...@gm...> > > Subject: [Semediawiki-user] SMW 1.4.3 parameter $smwgQMaxSize problem > > To: sem...@li... > > Date: Saturday, November 7, 2009, 12:15 PM > > In SMW1.4.3 if the parameter > > $smwgQMaxSize is increased to 16 or more the > > system is not reacting anymore >> The whole MW page > > is dead. > > > > For my queries I need a quite high $smwgQMaxSize > > (about 50). Is there any > > solution to solve this issue? > > > > I wrote two questions about "Semantic compound query is not > > accepting more > > than 5 arguments" earlier. This issue is related to the > > $smwgQMaxSize-problem, so don´t waste time with it. > > > > Thanks for your support! > > > > Best regards, > > > > tkrueger73 > > <http://semantic-mediawiki.org/wiki/Help:Configuration#smwgQMaxSize> > > > ------------------------------------------------------------------------------ > > Let Crystal Reports handle the reporting - Free Crystal > > Reports 2008 30-Day > > trial. Simplify your report design, integration and > > deployment - and focus on > > what you do best, core application coding. Discover what's > > new with > > Crystal Reports now. http://p.sf.net/sfu/bobj-july > > _______________________________________________ > > Semediawiki-user mailing list > > Sem...@li... > > https://lists.sourceforge.net/lists/listinfo/semediawiki-user > > > > > > |
From: Günther Z. <zeh...@mo...> - 2009-11-07 18:53:55
|
Maybe you could run the query with format=debug and than test the shown SQL select statement directly in MySQL and also check the buffer sizes in the MySQL configuration (http://dev.mysql.com/doc/refman/5.0/en/memory-use.html)? Gu --- On Sat, 11/7/09, Thomas Krueger <tkr...@gm...> wrote: > From: Thomas Krueger <tkr...@gm...> > Subject: Re: [Semediawiki-user] SMW 1.4.3 parameter $smwgQMaxSize problem > To: zeh...@mo... > Cc: sem...@li... > Date: Saturday, November 7, 2009, 4:15 PM > I tried ini_set( 'memory_limit', > '512M' ); in local settings and also increased the > memorylimit in php.ini from 20M to 256M. > > still the same problems. > > I found that, if a query with $smwgQMaxSize higher > than 15 is done, the process > "msqld" is staying at 100% cpu load all the > time. > Checking msqlyd with mtop, I found that for each query I > had a threat in an > > endlessloop for more than one hour. It was impossible to > kill this "crashed > treads". > Only solution was stopping and restarting the mysql > server. > > I have no deep knowledge about SMW and mysql, but maybe my > comments are > > helpfull for somebody with more experience. > Thanks for helping me, > > tkrueger73 > > 2009/11/7 Gu <zeh...@mo...> > > I use a value of 24 for > $smwgQMaxSize for quite some versions of SMW without > problems (btw the SQFT extension automatically increases the > value to 24 if its lower and the variable > $sqftgAdjustSMWQMaxVals is set to true (default value is > false) as otherwise some of my queries didn't work). > > > > > I assume your problem has something to do with the memory > available to MW resp. PHP. Try to increase it. > > I have in my LocalSettings.php: > > ini_set( 'memory_limit', '512M' ); > > > > Cheers, > > Gu > > > > --- On Sat, 11/7/09, Thomas Krueger <tkr...@gm...> > wrote: > > > > > From: Thomas Krueger <tkr...@gm...> > > > Subject: [Semediawiki-user] SMW 1.4.3 parameter > $smwgQMaxSize problem > > > To: sem...@li... > > > Date: Saturday, November 7, 2009, 12:15 PM > > > In SMW1.4.3 if the > parameter > > > $smwgQMaxSize is increased to 16 or more the > > > system is not reacting anymore >> The whole MW > page > > > is dead. > > > > > > For my queries I need a quite high $smwgQMaxSize > > > (about 50). Is there any > > > solution to solve this issue? > > > > > > I wrote two questions about "Semantic compound > query is not > > > accepting more > > > than 5 arguments" earlier. This issue is related > to the > > > $smwgQMaxSize-problem, so don´t waste time with it. > > > > > > Thanks for your support! > > > > > > Best regards, > > > > > > tkrueger73 > > > <http://semantic-mediawiki.org/wiki/Help:Configuration#smwgQMaxSize> > > > > ------------------------------------------------------------------------------ > > > Let Crystal Reports handle the reporting - Free > Crystal > > > Reports 2008 30-Day > > > trial. Simplify your report design, integration and > > > deployment - and focus on > > > what you do best, core application coding. Discover > what's > > > new with > > > Crystal Reports now. http://p.sf.net/sfu/bobj-july > > > _______________________________________________ > > > Semediawiki-user mailing list > > > Sem...@li... > > > https://lists.sourceforge.net/lists/listinfo/semediawiki-user > > > > > > > > > > > > > |