Hello @macbook71,
Thank you for contacting Rank Math support today and bringing your concern to our attention.
Can you please share the full error log you received from your host so we can identify why that specific query is causing CPU usage in your server?
Looking forward to helping you.
Hello, here is the type of error I am getting
[27-Sep-2022 15:18:03 UTC] Erreur de la base de données WordPress : Lost connection to MySQL server during query pour la requête SELECT COUNT(*) FROM wp_term_relationships, wp_posts WHERE wp_posts.ID = wp_term_relationships.object_id AND post_status IN (‘publish’) AND post_type IN (‘post’) AND term_taxonomy_id = 44 faite par edit_post, wp_update_post, wp_insert_post, wp_transition_post_status, do_action(‘transition_post_status’), WP_Hook->do_action, WP_Hook->apply_filters, _update_term_count_on_transition_post_status, wp_update_term_count, wp_update_term_count_now, _update_post_term_count`
and
-
This reply was modified 3 years, 6 months ago by
macbook71.
-
This reply was modified 3 years, 6 months ago by
macbook71.
Hello @macbook71,
In the full error log, it doesn’t seem to mention anything about Rank Math anymore and it seems to be an issue with regard to counting the term. Is there are any specific steps you did to replicate this?
Also, this type of error indicates that your database is not working as expected (connection issue) when there’s a lot of traffic coming into your website. Kindly check this one first with your hosting provider, as they might be able to address the issue.
You can try rebuilding the index by following this guide:
https://rankmath.com/kb/recreate-missing-database-tables/
Looking forward to helping you.