3K update queries on sinlge database stalls


I have a Amazon 24XL server of 82 Cores, 378 GB RAM.
I have only one WordPress site where users read articles, there are 4-5 smal plugins
One plugins is used to add the points and rewards in my subscribers profile.
When there are around 2500 Users on my site there are around 3000+ UPDATE queries that runs to update the table

The issue is that the queries stuck in updating I can’t find the way to fix those things
However server has much RAM , CPU available but due to queries on the same table it stuck and caused 502 on my site

enter image description here

, , , , Naqi 3 years 2020-04-06T08:50:57-05:00 0 Answers 85 views 0

Leave an answer