Last update killing msql server

{“cache_posts”:0,”cache”:0,”add_to”:{“single”:”single”},”content_filter_priority”:”999″,”insert_after_paragraph”:”-1″,”disable_on_mobile”:1,”disable_on_amp”:0,”uninstall_options”:1,”uninstall_indices”:1,”uninstall_indices_deactivate”:0,”show_metabox”:1,”show_metabox_admins”:0,”show_credit”:0,”limit”:”6″,”daily_range”:”0″,”ordering”:”relevance”,”random_order”:0,”match_content”:1,”match_content_words”:”0″,”post_types”:”post”,”same_post_type”:0,”same_author”:0,”primary_term”:0,”same_taxes”:”category”,”match_all”:0,”no_of_common_terms”:”1″,”related_meta_keys”:””,”exclude_post_ids”:””,”exclude_cat_slugs”:””,”exclude_categories”:””,”disable_contextual”:0,”disable_contextual_cpt”:1,”title”:”<h3>Related Posts:<\/h3>”,”blank_output”:”blank”,”blank_output_text”:”No related posts found”,”show_excerpt”:0,”excerpt_length”:”10″,”show_date”:0,”show_author”:0,”show_primary_term”:0,”title_length”:”60″,”link_new_window”:0,”link_nofollow”:0,”exclude_output_header”:0,”exclude_on_post_ids”:””,”exclude_on_post_types”:””,”exclude_on_cat_slugs”:””,”html_wrapper_header”:0,”before_list”:”

“,”after_list”:”<\/ul>”,”before_list_item”:”
• “,”after_list_item”:”<\/li>”,”post_thumb_op”:”inline”,”thumb_size”:”crp_thumbnail”,”thumb_width”:”150″,”thumb_height”:”150″,”thumb_crop”:1,”thumb_create_sizes”:1,”thumb_html”:”html”,”thumb_meta”:”post-image”,”scan_images”:1,”thumb_default_show”:1,”thumb_default”:”https:\/\/www.zorg.video\/wp-content\/plugins\/contextual-related-posts\/default.png”,”crp_styles”:”rounded_thumbs”,”custom_css”:””,”feed_options_desc”:0,”limit_feed”:”5″,”show_excerpt_feed”:0,”post_thumb_op_feed”:”text_only”,”thumb_width_feed”:”250″,”thumb_height_feed”:”250″,”exclude_on_categories”:””}

No cash:

SELECT wp_posts.*, MATCH (wp_posts.post_title,wp_posts.post_content) AGAINST ('Carla Gugino nude lesbian sex Gaite Jansen - Leopard Skin (2022) s1e5-6 1080p Web Carla Gugino nude lesbisan sex Gaite Jansen - Leopard Skin (2022) s1e5-6 1080p Web. Carla Gugino nude topless hot lesbian sex nude topless Gaite Jansen.') as score
FROM wp_posts
LEFT JOIN wp_term_relationships
ON (wp_posts.ID = wp_term_relationships.object_id)
WHERE 1=1
AND ( wp_posts.post_date <= '2022-11-19 22:33:49' )
AND wp_posts.ID NOT IN (266919)
AND ( wp_term_relationships.term_taxonomy_id IN (9254,361,2106,10665,2194,58) )
AND wp_posts.post_type = 'post'
AND ((wp_posts.post_status = 'publish'
OR wp_posts.post_status = 'inherit'))
AND MATCH (wp_posts.post_title,wp_posts.post_content) AGAINST ('Carla Gugino nude lesbian sex Gaite Jansen - Leopard Skin (2022) s1e5-6 1080p Web Carla Gugino nude lesbisan sex Gaite Jansen - Leopard Skin (2022) s1e5-6 1080p Web. Carla Gugino nude topless hot lesbian sex nude topless Gaite Jansen.')
GROUP BY wp_posts.ID
ORDER BY score DESC
LIMIT 0, 6
WP_Query->get_posts()

Plugin: contextual-related-posts	6	2.3308
SELECT wposts.ID
FROM wp_posts wposts, wp_postmeta wpostmeta
WHERE wposts.ID = wpostmeta.post_id
AND wpostmeta.meta_key = '_wp_attached_file'
AND wpostmeta.meta_value = '2022/11/Gaite-Jansen-nude-bush-Amelia-Eve-and-Carla-Gugino-hot-and-sexy-Leopard-Skin-2022-s1e3-4-1080p-Web-15.webp'
AND wposts.post_type = 'attachment'
crp_get_attachment_id_from_url()

Plugin: contextual-related-posts	1	3.0276
SELECT wposts.ID
FROM wp_posts wposts, wp_postmeta wpostmeta
WHERE wposts.ID = wpostmeta.post_id
AND wpostmeta.meta_key = '_wp_attached_file'
AND wpostmeta.meta_value = '2022/11/Amelia-Eve-nude-Carla-Gugino-butt-naked-Nora-Arnezeder-sexy-Leopard-Skin-2022-s1e1-2-1080p-Web06.webp'
AND wposts.post_type = 'attachment'
crp_get_attachment_id_from_url()

Plugin: contextual-related-posts	1	2.7670
SELECT wposts.ID
FROM wp_posts wposts, wp_postmeta wpostmeta
WHERE wposts.ID = wpostmeta.post_id
AND wpostmeta.meta_key = '_wp_attached_file'
AND wpostmeta.meta_value = '2019/08/jett_2.1.1.jpg'
AND wposts.post_type = 'attachment'
crp_get_attachment_id_from_url()

Plugin: contextual-related-posts	1	3.2575
SELECT wposts.ID
FROM wp_posts wposts, wp_postmeta wpostmeta
WHERE wposts.ID = wpostmeta.post_id
AND wpostmeta.meta_key = '_wp_attached_file'
AND wpostmeta.meta_value = '2022/11/Nora-Arnezeder-hot-and-sexy-Amelia-Eve-nude-butt-Carla-Gugino-sexy-Leopard-Skin-2022-s1e7-81080p-Web-09.webp'
AND wposts.post_type = 'attachment'
crp_get_attachment_id_from_url()

Plugin: contextual-related-posts	1	4.3611
SELECT wposts.ID
FROM wp_posts wposts, wp_postmeta wpostmeta
WHERE wposts.ID = wpostmeta.post_id
AND wpostmeta.meta_key = '_wp_attached_file'
AND wpostmeta.meta_value = '2014/01/Gaite-Jansen-nude-topless-and-sex-170-Hz-2011-6.jpg'
AND wposts.post_type = 'attachment'
crp_get_attachment_id_from_url()

Plugin: contextual-related-posts	1	4.1641
SELECT wposts.ID
FROM wp_posts wposts, wp_postmeta wpostmeta
WHERE wposts.ID = wpostmeta.post_id
AND wpostmeta.meta_key = '_wp_attached_file'
AND wpostmeta.meta_value = '2019/07/Carla-Gugino-sexy-Gaite-Jansen-nude-topless-Jett-2019-s1e4-HD-1080p-0005.jpg'
AND wposts.post_type = 'attachment

I installed 3.2.1 and had the same problem.
It was working fine till I updated 2day.

???

Hi,
I have to disable it. Msqld went up to 700%.
As for the other plugin updates yesterday no. WP too no update? Just your plugin? Nor did I install any other plugin.
This is very strange. Everything else works fine when I disable it.

I love your plugin I’m using it probably from the earliest realized. Never have such a problem. My blog is huge over 8000+ posts. Most developers don’t test on such a huge database.

Please just drop a note here when you think you fix a problem. So I give it another try.

Hi Ajay,

I wanted to give a plugin another try. Now it won’t activate!? I guess it has to do something with old indexes, so I remove two FULLTEXT indexes in posts. Now activation took a bit more time but still didn’t activate.

Any idea?

Thanks

Working Now!

I enabled debugging and logging. The log file shows some index warnings, but nothing about this plugin. I disable (for the third time) a similar plugin I was using then create and re-create the indexes n Phpmyadimn… and it works 🙂

Now I have to fiddle with the settings. Finally, I got it right. The first opening of the page was very slow 40+ sec until it was cashed (HTML page type). refreshing the page to return to normal load speed 0.69 ms.

thanks for the support.

This is the best-related post plugin. I tried them all and they are no match for this one.