• My hosting co sent me this, apparently YARPP is gumming up the works. This happened before so I had to turn it off:

    Count ????????: 107
    Time ?????????: 4483 s total, 41.897196 s avg, 11 s to 178 s max
    ?95% of Time : 3683 s total, 36.465347 s avg, 11 s to 112 s max
    Lock Time (s) : 26 s total, 242.991 ms avg, 0 to 13 s max
    ?95% of Lock : 0 total, 0 avg, 0 to 0 max
    Rows sent ????: 0 avg, 0 to 0 max ?(0.00%)
    Rows examined : 20.79M avg, 2.45M to 86.39M max ?(97.87%)
    Database ?????: creative
    Users ????????:
    [email protected] 192.168.254.1 : 99.07% (106) of query, 80.74% (109) of all users

    EXPLAIN ??????: Not a SELECT statement

    Query abstract:
    SET timestamp=N; INSERT INTO wp_yarpp_related_cache (reference_id,id,score) (SELECT N, id, (N+ (MATCH (post_content) AGAINST (‘S’)) * N+ (MATCH (post_title) AGAINST (‘S’)) * N+ COUNT( DISTINCT tagtax.term_taxonomy_id ) * N+ COUNT( DISTINCT cattax.term_taxonomy_id ) * N) AS score FROM wp_posts LEFT JOIN wp_term_relationships AS thistag ON (thistag.object_id = N ) LEFT JOIN wp_term_relationships AS tagrel ON (tagrel.term_taxonomy_id = thistag.term_taxonomy_id AND tagrel.object_id = wp_posts.id) LEFT JOIN wp_term_taxonomy AS tagtax ON ( tagrel.term_taxonomy_id = tagtax.term_taxonomy_id AND tagtax.taxonomy = ‘S’) LEFT JOIN wp_term_relationships AS thiscat ON (thiscat.object_id = N ) LEFT JOIN wp_term_relationships AS catrel ON (catrel.term_taxonomy_id = thiscat.term_taxonomy_id AND catrel.object_id = wp_posts.id) LEFT JOIN wp_term_taxonomy AS cattax ON ( catrel.term_taxonomy_id = cattax.term_taxonomy_id AND cattax.taxonomy = ‘S’) WHERE (post_status IN ( ‘S’, ‘S’ ) AND id != ‘S’)
    AND post_password =’S’ GROUP BY id HAVING score >= N.N AND COUNT( DISTINCT tagtax.term_taxonomy_id ) >= N ORDER BY score DESC LIMIT N) UNION (SELECT N, id, (N+ (MATCH (post_content) AGAINST (‘S’)) * N+ (MATCH (post_title) AGAINST (‘S’)) * N+ COUNT( DISTINCT tagtax.term_taxonomy_id ) * N+ COUNT( DISTINCT cattax.term_taxonomy_id ) * N) AS score FROM wp_posts LEFT JOIN wp_term_relationships AS thistag ON (thistag.object_id = N ) LEFT JOIN wp_term_relationships AS tagrel ON (tagrel.term_taxonomy_id = thistag.term_taxonomy_id AND tagrel.object_id = wp_posts.id) LEFT JOIN wp_term_taxonomy AS tagtax ON ( tagrel.term_taxonomy_id = tagtax.term_taxonomy_id AND tagtax.taxonomy = ‘S’) LEFT JOIN wp_term_relationships AS thiscat ON (thiscat.object_id = N ) LEFT JOIN wp_term_relationships AS catrel ON (catrel.term_taxonomy_id = thiscat.term_taxonomy_id AND catrel.object_id = wp_posts.id) LEFT JOIN wp_term_taxonomy AS cattax ON ( catrel.term_taxonomy_id = cattax.term_taxonomy_id AND cattax.
    taxonomy = ‘S’) WHERE (post_status IN ( ‘S’, ‘S’ ) AND id != ‘S’) AND post_password =’S’ GROUP BY id HAVING score >= N.N AND COUNT( DISTINCT tagtax.term_taxonomy_id ) >= N ORDER BY score DESC LIMIT N) ON duplicate KEY UPDATE date = now();

    Query sample:
    SET timestamp=1271741124;
    insert into wp_yarpp_related_cache (reference_ID,ID,score) (SELECT 1006, ID, (0+ (MATCH (post_content) AGAINST (‘paulson banks financial eu bank american government panic global billion banking european power crisis goldman dramatic sachs his private treasury ‘)) * 3+ (MATCH (post_title) AGAINST (‘future global bank power warfare financial engdahl behind panic william ‘)) * 1+ COUNT( DISTINCT tagtax.term_taxonomy_id ) * 1+ COUNT( DISTINCT cattax.term_taxonomy_id ) * 1) as score
    from wp_posts
    left JOIN wp_term_relationships AS thistag ON (thistag.object_id = 1006 )
    left JOIN wp_term_relationships AS tagrel on (tagrel.term_taxonomy_id = thistag.term_taxonomy_id
    AND tagrel.object_id = wp_posts.ID)
    left JOIN wp_term_taxonomy AS tagtax ON ( tagrel.term_taxonomy_id = tagtax.term_taxonomy_id
    AND tagtax.taxonomy = ‘post_tag’)
    left JOIN wp_term_relationships AS thiscat ON (thiscat.object_id = 1006 )
    left JOIN wp_term_relationships AS catrel on (catrel.term_taxonomy_id = thiscat.term_taxonomy_id
    AND catrel.object_id = wp_posts.ID)
    left JOIN wp_term_taxonomy AS cattax ON ( catrel.term_taxonomy_id = cattax.term_taxonomy_id
    AND cattax.taxonomy = ‘category’)
    where (post_status IN ( ‘publish’, ?‘static’ ) and ID != ‘1006’) and post_password =”
    group by id
    having score >= 2.50 and COUNT( DISTINCT tagtax.term_taxonomy_id ) >= 1 order by score desc limit 10) union (SELECT 1006, ID, (0+ (MATCH (post_content) AGAINST (‘paulson banks financial eu bank american government panic global billion banking european power crisis goldman dramatic sachs his private treasury ‘)) * 3+ (MATCH (post_title) AGAINST (‘future global bank power warfare financial engdahl behind panic william ‘)) * 1+ COUNT( DISTINCT tagtax.term_taxonomy_id ) * 1+ COUNT( DISTINCT cattax.term_taxonomy_id ) * 1) as score
    from wp_posts
    left JOIN wp_term_relationships AS thistag ON (thistag.object_id = 1006 )
    left JOIN wp_term_relationships AS tagrel on (tagrel.term_taxonomy_id = thistag.term_taxonomy_id
    AND tagrel.object_id = wp_posts.ID)
    left JOIN wp_term_taxonomy AS tagtax ON ( tagrel.term_taxonomy_id = tagtax.term_taxonomy_id
    AND tagtax.taxonomy = ‘post_tag’)
    left JOIN wp_term_relationships AS thiscat ON (thiscat.object_id = 1006 )
    left JOIN wp_term_relationships AS catrel on (catrel.term_taxonomy_id = thiscat.term_taxonomy_id
    AND catrel.object_id = wp_posts.ID)
    left JOIN wp_term_taxonomy AS cattax ON ( catrel.term_taxonomy_id = cattax.term_taxonomy_id
    AND cattax.taxonomy = ‘category’)
    where (post_status IN ( ‘publish’, ?‘static’ ) and ID != ‘1006’) and post_password =”
    group by id
    having score >= 2.50 and COUNT( DISTINCT tagtax.term_taxonomy_id ) >= 1 order by score desc limit 10) on duplicate key update date = now();

    Bill

    https://www.creative-i.info

Viewing 14 replies - 1 through 14 (of 14 total)
  • Bill, if you want to try again, try turning off “consider tags”, “consider cats” and/or “cross-relate posts and pages”. All of these options are making it more computationally intensive, and you have them all on. ??

    Thread Starter William Bowles

    (@creative-i)

    Hi Mitchoyoshitaka,
    Okay thanks, I’ll try it. Strangely, I have it running on my other site (same host but different box) and it seems to work without a problem.

    Bill

    Thread Starter William Bowles

    (@creative-i)

    Mitchoyoshitaka,
    I’ve discovered that if you turn off these options nothing comes up!

    Bill

    Having similar issues, posted them in another thread: https://www.ads-software.com/support/topic/374062?replies=13

    With the YARPP active my site slows to a crawl.

    In all fairness though I have a crazy complex blog with thousands of entries and millions of pageviews.

    @creative-i which option did you turn off? It’s possible that right after you turn off an option, it needs to cache the new results so you won’t get any for a little bit. It’s also possible that you need to readjust your “match threshold” as nothing is being hit anymore.

    Thread Starter William Bowles

    (@creative-i)

    The cross-related option. I’ve deleted some categories but the posts still show up in the list of related posts, so how do I clear the cache as Yarpp has no option to empty it?

    Bill

    @creative-i whenever you change YARPP options which change the “relatedness” formula, YARPP automatically clears the cache. Is it working for you now?

    Thread Starter William Bowles

    (@creative-i)

    mitchoyoshitaka

    I’ve changed one of the relatedness options but have no idea if it’s cleared the cache or not as my hosting co sent the code I posted above, so I’ll have to check with them.

    I’ve tried quite a few of these kinds of plugins and YARPP is the only one that didn’t wreak havoc on the site (like produce completely blank pages!).

    For all I know, whether they work properly or not might depend on the theme, a plugin or the like as there as so many interacting variables with a complex installation like WP and I’m not au fait with PHP and frankly just don’t have the time to mess about with it.

    Bill

    @creative-i like I said, the cache should be cleared when you change the relatedness options. Hope all is well.

    Thread Starter William Bowles

    (@creative-i)

    Well no complaints from my host, so I assume it’s working as it should be.

    Bill

    @creative-i glad to hear.

    mitcho, I need helP! -_-

    What I’ve Done:

    I’ve had yarpp on for 3 days(default settings). The first two were crawl the 3rd day was picking up.
    After the 3rd day I decided to deactivate.
    I just learned from this page the options I have to have less stress on the servers by unchecking tags, comments, etc.
    Is it possible to reactivate the plugin and have a cache of that 3 days that I had loaded, so it won’t be as slow as it was when I first started it?
    If not, is there a process you recommend to have YARP functioning at full capacity over time?
    I run a popular, high content website – dprogram.net – and this plugin would benefit greatly in page hits =)

    Shahin

    @sakerfa using the options I suggested above (and in the FAQ) will make it run smoother. Unfortunately when you reactivate the plugin and change these options, the old cache will become invalid (and YARPP will automatically clear it) as it no longer applies. However, hopefully with the newer options it’ll be much smoother this time. Hope to see YARPP on your site soon!

Viewing 14 replies - 1 through 14 (of 14 total)
  • The topic ‘[Plugin: Yet Another Related Posts Plugin] Yarpp slowing down the site (again)’ is closed to new replies.