rank_math_redirections appears many times in slow log

Hello,

I’m sorry to hear about the issue you’re facing with the rank_math_redirections table appearing many times in the slow log. To investigate and improve the situation, you can follow these steps:

1. Check Redirections Configuration: Verify if there are any misconfigured redirections within Rank Math that might be causing excessive queries to the rank_math_redirections table. You can review and optimize the redirection rules by following the guidelines provided in our documentation:

   • Solving Redirection Issues Using Rank Math SEO Plugin
   • Random URLs Redirecting Even When No Redirect Was Created

2. Debug Redirections: Enable the debug feature within Rank Math to identify specific redirect rules causing issues. This feature can help pinpoint problematic redirects and assist in resolving them efficiently. Here’s how you can enable and use the debug redirection feature:

   • Navigate to Rank Math SEO → General Settings → Redirections and enable the debug option as shown in the documentation: Debugging Your Redirects

3. Bulk Actions and Redirection Statistics: Utilize Rank Math’s bulk actions feature to manage multiple redirects efficiently. Additionally, monitor redirection statistics to track the performance of each redirection rule. This can help you identify any redirects causing excessive queries to the database. More information on these features can be found here:

   • How to Set Up Redirections

If after following these steps you still encounter issues with the rank_math_redirections table appearing multiple times in the slow log, please provide more details or reply to this ticket for further assistance. Our support team will be glad to investigate and help you resolve this issue.

Thank you for raising this concern, and we appreciate your cooperation in resolving this matter efficiently.

Sources:
Solving Redirection Issues Using Rank Math SEO Plugin » Rank Math
Random URLs Redirecting Even When No Redirect Was Created » Rank Math
Page With Redirect – Google Search Console Status » Rank Math
How to Set Up Redirections » Rank Math
Warning: You Have More Than 1000 Active Redirections » Rank Math