Hello,
Thank you for contacting Rank Math and bringing your concern to our attention.
So far I understood that the plugin you’re using purges the posts/pages after a certain period of time.
If you’ve already removed a bunch of URLs with the help of that plugin and those are redirecting to homepage, nothing else needs to be done in this case. Search engines should not index those page and neither you should have any issues with indexing for other active posts/pages.
Hope that helps, and please do not hesitate to let us know if you need our assistance with anything else.
Thank you.
Question running the plugin purge we are seeing this code spike in the server just checking to make sure it’s not yours
SELECT meta_id FROM wp_postmeta WHERE meta_key = ‘_thumbnail_id’ AND meta_value
As it’s causing huge mysql spikes
Or this code which is in my phonerror logs when using the plug-in
WordPress database error Duplicate entry ‘73983’ for key ‘PRIMARY’ for query INSERT INTO wp_rank_math_internal_meta (object_id, internal_link_count, external_link_count) VALUES (73983, ‘0’, ‘0’) made by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘after_setup_theme’), WP_Hook->do_action, WP_Hook->apply_filters, plugin_auto_prune_posts_activation, plugin_auto_prune_posts->prune, plugin_auto_prune_posts->delete_post_and_attachments, wp_delete_post, do_action(‘delete_post’), WP_Hook->do_action, WP_Hook->apply_filters, RankMath\Links\Links->delete_post, RankMath\Links\Storage->update_link_counts, RankMath\Links\Storage->save_meta_data
This code is causing huge spikes in server when using the prune plugin so need advise asap
Only thing I can think of is turn off rank math while we don’t unless there is something you can help with to fix this
Hello,
Sorry for the late response to this thread.
Looking at the messages you shared it seems that the plugin you are using to remove old content is using the same methods used by WordPress to delete data and since our plugin attaches itself to those methods when enabled to make sure we remove and update the internal links counter for the pages being removed it’s running those SQL queries.
However, since the deletion is happening in bulk we don’t have any data for the link counter and as such have multiple entries with zero values for the number of links which causes the issue.
The recommendation, when doing a bulk deletion like this is that you disable all plugins and make sure the content is in a good place before adding the plugins and starting the optimization.
Don’t hesitate to get in touch if you have any other questions.
Hello,
Since we did not hear back from you for 15 days, we are assuming that you found the solution. We are closing this support ticket.
If you still need assistance or any other help, please feel free to open a new support ticket, and we will be more than happy to assist.
Thank you.
