cancel
Showing results for 
Search instead for 
Did you mean: 

MySQL query repeating excessively

MySQL query repeating excessively

Hi,

I have got an issue on my website which impacts the website performance in many times, I'll conclude the issue in some points :

- The website was working for a long time without any impact but from short days the website is getting 524 error (Cloudflare) due to some queries are running excessively.

Our server administrator provide us with the logs and top transaction when this issue was running; I'll attach some of there logs.

 

- Unfortunately, this issue occurs at different times, and we did not do any modification on the website caused this issue!

 

We've done many practices on the website but still these queries running excessively.

 

Breakdown1.PNGBreakdown2.PNGBreakdown3.PNGGraph.pngQuery1.PNGQuery2.PNG