SMW 1.4.3 parameter $smwgQMaxSize problem

[Thomas Krueger-3]

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
Semediawiki-user@...
https://lists.sourceforge.net/lists/listinfo/semediawiki-user

[mbwgu]

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 <tkrueger73@...> wrote:

> From: Thomas Krueger <tkrueger73@...>
> Subject: [Semediawiki-user] SMW 1.4.3 parameter $smwgQMaxSize problem
> To: semediawiki-user@...
> 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
> Semediawiki-user@...
> https://lists.sourceforge.net/lists/listinfo/semediawiki-user
>

     

------------------------------------------------------------------------------
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
Semediawiki-user@...
https://lists.sourceforge.net/lists/listinfo/semediawiki-user

[Thomas Krueger-3]

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

> 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 <tkrueger73@...> wrote:
>
> > From: Thomas Krueger <tkrueger73@...>
> > Subject: [Semediawiki-user] SMW 1.4.3 parameter $smwgQMaxSize problem
> > To: semediawiki-user@...
> > 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
> > Semediawiki-user@...
> > https://lists.sourceforge.net/lists/listinfo/semediawiki-user
> >
>
>
>
>

------------------------------------------------------------------------------
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
Semediawiki-user@...
https://lists.sourceforge.net/lists/listinfo/semediawiki-user

[Günther Zehetner]

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 <tkrueger73@...> wrote:

> From: Thomas Krueger <tkrueger73@...>
> Subject: Re: [Semediawiki-user] SMW 1.4.3 parameter $smwgQMaxSize problem
> To: zehetner@...
> Cc: semediawiki-user@...
> 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 <zehetner@...>
>
> 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 <tkrueger73@...>
> wrote:
>
>
>
> > From: Thomas Krueger <tkrueger73@...>
>
> > Subject: [Semediawiki-user] SMW 1.4.3 parameter
> $smwgQMaxSize problem
>
> > To: semediawiki-user@...
>
> > 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
>
> > Semediawiki-user@...
>
> > https://lists.sourceforge.net/lists/listinfo/semediawiki-user
>
> >
>
>
>
>
>
>
>
>
>
>

     

------------------------------------------------------------------------------
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
Semediawiki-user@...
https://lists.sourceforge.net/lists/listinfo/semediawiki-user