[Plugin: Yet Another Related Posts Plugin] Yarpp slowing down the site (again)

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