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