I am running q2a site but sometimes I am getting error and database becomes irresponsive.
And when I see the performance insights I see LOCK TABLES qa_words WRITE is causing the issue.
Randomly getting LOCK TABLES qa_words WRITE in Q2A which is causing DB read operation blocked for the specific time.
Please anyone help me understand the issue to resolve it.