[SmartCrawl Pro] Smartcrawl Locking Database

Hi,

We recently started encountering a problem on the site listed. Basically the Database started running at 100% and did not finish running ina reasonable time. the queries in question were all the same (similar) and locking the entire DB. After investigation I have determined its SmartCrawl doing it and its likely soemthing to do with the Auto Linking (although I can’t be sure about the last bit). The queries are all like this:

SELECT SQL_CALC_FOUND_ROWS DISTINCT bedsandherts_posts.ID FROM bedsandherts_posts  INNER JOIN bedsandherts_postmeta ON ( bedsandherts_posts.ID = bedsandherts_postmeta.post_id )  INNER JOIN bedsandherts_postmeta AS mt1 ON ( bedsandherts_posts.ID = mt1.post_id )  INNER JOIN bedsandherts_postmeta AS mt2 ON ( bedsandherts_posts.ID = mt2.post_id )  INNER JOIN bedsandherts_postmeta AS mt3 ON ( bedsandherts_posts.ID = mt3.post_id )  INNER JOIN bedsandherts_postmeta AS mt4 ON ( bedsandherts_posts.ID = mt4.post_id )  INNER JOIN bedsandherts_postmeta AS mt5 ON ( bedsandherts_posts.ID = mt5.post_id )  INNER JOIN bedsandherts_postmeta AS mt6 ON ( bedsandherts_posts.ID = mt6.post_id )  INNER JOIN bedsandherts_postmeta AS mt7 ON ( bedsandherts_posts.ID = mt7.post_id )  INNER JOIN bedsandherts_postmeta AS mt8 ON ( bedsandherts_posts.ID = mt8.post_id )  INNER JOIN bedsandherts_postmeta AS mt9 ON ( bedsandherts_posts.ID = mt9.post_id )  INNER JOIN bedsandherts_postmeta AS mt10 ON ( bedsandherts_posts.ID = mt10.post_id )  INNER JOIN bedsandherts_postmeta AS mt11 ON ( bedsandherts_posts.ID = mt11.post_id )  INNER JOIN bedsandherts_postmeta AS mt12 ON ( bedsandherts_posts.ID = mt12.post_id )  INNER JOIN bedsandherts_postmeta AS mt13 ON ( bedsandherts_posts.ID = mt13.post_id )  INNER JOIN bedsandherts_postmeta AS mt14 ON ( bedsandherts_posts.ID = mt14.post_id )  INNER JOIN bedsandherts_postmeta AS mt15 ON ( bedsandherts_posts.ID = mt15.post_id ) LEFT JOIN bedsandherts_postmeta as tribe_event_postmeta on bedsandherts_posts.ID = tribe_event_postmeta.post_id AND tribe_event_postmeta.meta_key = '_EventStartDate' WHERE 1=1  AND bedsandherts_posts.ID NOT IN (31734,31611) AND ( 
  ( 
    ( bedsandherts_postmeta.meta_key = '_wds_focus-keywords' AND bedsandherts_postmeta.meta_value LIKE '%practice%' ) 
    AND 
    ( mt1.meta_key = '_wds_focus-keywords' AND mt1.meta_value LIKE '%salaried%' ) 
    AND 
    ( mt2.meta_key = '_wds_focus-keywords' AND mt2.meta_value LIKE '%gp%' ) 
    AND 
    ( mt3.meta_key = '_wds_focus-keywords' AND mt3.meta_value LIKE '%greensand%' ) 
    AND 
    ( mt4.meta_key = '_wds_focus-keywords' AND mt4.meta_value LIKE '%surgery%' ) 
    AND 
    ( mt5.meta_key = '_wds_focus-keywords' AND mt5.meta_value LIKE '%beds%' ) 
    AND 
    ( mt6.meta_key = '_wds_focus-keywords' AND mt6.meta_value LIKE '%herts%' ) 
    AND 
    ( mt7.meta_key = '_wds_focus-keywords' AND mt7.meta_value LIKE '%bedfordshire%' ) 
    AND 
    ( mt8.meta_key = '_wds_focus-keywords' AND mt8.meta_value LIKE '%hertfordshire%' ) 
    AND 
    ( mt9.meta_key = '_wds_focus-keywords' AND mt9.meta_value LIKE '%patient%' ) 
    AND 
    ( mt10.meta_key = '_wds_focus-keywords' AND mt10.meta_value LIKE '%gms%' ) 
    AND 
    ( mt11.meta_key = '_wds_focus-keywords' AND mt11.meta_value LIKE '%gmc%' ) 
    AND 
    ( mt12.meta_key = '_wds_focus-keywords' AND mt12.meta_value LIKE '%care%' ) 
    AND 
    ( mt13.meta_key = '_wds_focus-keywords' AND mt13.meta_value LIKE '%medical%' ) 
    AND 
    ( mt14.meta_key = '_wds_focus-keywords' AND mt14.meta_value LIKE '%standard%' ) 
    AND 
    ( mt15.meta_key = '_wds_focus-keywords' AND mt15.meta_value LIKE '%excellent%' )
  )
) AND bedsandherts_posts.post_type IN ('post', 'page', 'attachment', 'job_listing', 'product', 'wdf_scan', 'wdf_scan_item', 'faq', 'tribe_venue', 'tribe_events', 'sp_homepanel', 'sp_innerpages', 'sp_hot_topics', 'lc_lib', 'vc4_templates') AND (bedsandherts_posts.post_status = 'publish' OR bedsandherts_posts.post_status = 'disabled' OR bedsandherts_posts.post_status = 'expired' OR bedsandherts_posts.post_status = 'tribe-ea-success' OR bedsandherts_posts.post_status = 'tribe-ea-failed' OR bedsandherts_posts.post_status = 'tribe-ea-schedule' OR bedsandherts_posts.post_status = 'tribe-ea-pending' OR bedsandherts_posts.post_status = 'tribe-ea-draft' OR bedsandherts_posts.post_status = 'future' OR bedsandherts_posts.post_status = 'draft' OR bedsandherts_posts.post_status = 'pending' OR bedsandherts_posts.post_status = 'expired' OR bedsandherts_posts.post_author = 1410 AND bedsandherts_posts.post_status = 'private') GROUP BY bedsandherts_posts.ID ORDER BY bedsandherts_posts.post_date DESC LIMIT 0, 10;

Please do note that the post in question is a Job Post (WP-Job Manager) and there were NO focus keywords set within SmartCrawl.

I had tried disabling Auto Linking in the SmartCrawl Plugin but noticed that when visiting the specific post the Auto Link option was still there and switched on.

Obviously as its killing the DB to edit these then its very difficult to turn
off the auto linking individually.

Smartcrawl remains turned off for now.
Kind regards
Mark