Loading...
 

Tikiwiki-devel (mailman list mirror)


Did someone try some score expiry or user ranking feature on doc.tiki.org?

There was some heavy load situation caused by some mysql queries that seem
to be locked up related to "score expiry" or "user ranking" - did anyone
try our some feature related to either of this on doc.tiki.org?

Nelson

ok - managed to nail this down to the use of Module Users Rank and Module
Users Own Rank on the following pages:

Module users_own_rank

module users_rank

UserPagelindon


I've removed these uses for now until we can figure out how to limit/reduce
the query size. There are over 144,000 items in tiki_object_scores on
doc.tiki.org so maybe that's the problem...


Nelson

On Sat, Mar 26, 2016 at 1:13 PM, Nelson Ko <nelson@synergiqsolutions.com>
wrote:

> There was some heavy load situation caused by some mysql queries that seem
> to be locked up related to "score expiry" or "user ranking" - did anyone
> try our some feature related to either of this on doc.tiki.org?
>
> Nelson

Didn't seem to help. Those queries must be still being triggered from
somewhere else. I'm turning off the score feature for now to see if it
helps.

On Mon, Apr 25, 2016 at 11:31 AM, Nelson Ko <nelson@synergiqsolutions.com>
wrote:

> ok - managed to nail this down to the use of Module Users Rank and Module
> Users Own Rank on the following pages:
>
> Module users_own_rank
>
> module users_rank
>
> UserPagelindon
>
>
> I've removed these uses for now until we can figure out how to
> limit/reduce the query size. There are over 144,000 items in
> tiki_object_scores on doc.tiki.org so maybe that's the problem...
>
>
> Nelson
>
> On Sat, Mar 26, 2016 at 1:13 PM, Nelson Ko <nelson@synergiqsolutions.com>
> wrote:
>
>> There was some heavy load situation caused by some mysql queries that
>> seem to be locked up related to "score expiry" or "user ranking" - did
>> anyone try our some feature related to either of this on doc.tiki.org?
>>
>> Nelson

Thanks to improve, yesterday doc and dev were not usable. :-(

Bernard


> On 25 Apr 2016, at 23:57 , Nelson Ko <nelson@synergiqsolutions.com> wrote:
>
> Didn't seem to help. Those queries must be still being triggered from somewhere else. I'm turning off the score feature for now to see if it helps.
>
> On Mon, Apr 25, 2016 at 11:31 AM, Nelson Ko <nelson@synergiqsolutions.com <mailto:nelson@synergiqsolutions.com>> wrote:
> ok - managed to nail this down to the use of Module Users Rank and Module Users Own Rank on the following pages:
>
> Module users_own_rank
>
>
> module users_rank
>
>
> UserPagelindon
>
>
>
> I've removed these uses for now until we can figure out how to limit/reduce the query size. There are over 144,000 items in tiki_object_scores on doc.tiki.org <http://doc.tiki.org/> so maybe that's the problem...
>
>
>
> Nelson
>
>
> On Sat, Mar 26, 2016 at 1:13 PM, Nelson Ko <nelson@synergiqsolutions.com <mailto:nelson@synergiqsolutions.com>> wrote:
> There was some heavy load situation caused by some mysql queries that seem to be locked up related to "score expiry" or "user ranking" - did anyone try our some feature related to either of this on doc.tiki.org <http://doc.tiki.org/>?
>
> Nelson
>
>
> ------------------------------------------------------------------------------
> Find and fix application performance issues faster with Applications Manager
> Applications Manager provides deep performance insights into multiple tiers of
> your business applications. It resolves application problems quickly and
> reduces your MTTR. Get your free trial!
> https://ad.doubleclick.net/ddm/clk/302982198;130105516;z___
> TikiWiki-devel mailing list
> TikiWiki-devel at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel


Why Register?

Register at tiki.org and you'll be able to use the account at any *.tiki.org site, thanks to the InterTiki feature. A valid email address is required to receive site notifications and occasional newsletters. You can opt out of these items at any time.